123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293 |
- <?php
- // +----------------------------------------------------------------------
- // | CRMEB [ CRMEB赋能开发者,助力企业发展 ]
- // +----------------------------------------------------------------------
- // | Copyright (c) 2016~2022 https://www.crmeb.com All rights reserved.
- // +----------------------------------------------------------------------
- // | Licensed CRMEB并不是自由软件,未经许可不能去掉CRMEB相关版权
- // +----------------------------------------------------------------------
- // | Author: CRMEB Team <admin@crmeb.com>
- // +----------------------------------------------------------------------
- namespace app\wap\model\material;
- use think\Db;
- use traits\ModelTrait;
- use basic\ModelBasic;
- use app\wap\model\material\DataDownloadCategpry;
- /**资料 model
- * Class DataDownload
- * @package app\wap\model\material
- */
- class DataDownload extends ModelBasic
- {
- use ModelTrait;
- public static function PreWhere($alias = '', $model = null)
- {
- if (is_null($model)) $model = new self();
- if ($alias) {
- $model = $model->alias($alias);
- $alias .= '.';
- }
- return $model->where([$alias . 'is_show' => 1, $alias . 'status' => 1, $alias . 'is_del' => 0]);
- }
- /**列表
- * @param int $page
- * @param int $limit
- * @param $tid
- * @return array
- */
- public static function getDataDownloadExercisesList($page, $limit, $pid, $cate_id, $search)
- {
- $model = self::PreWhere();
- if ($pid && $cate_id) {
- $model = $model->where(['cate_id' => $cate_id]);
- } else if ($pid && !$cate_id) {
- $cate_ids = DataDownloadCategpry::where('pid', $pid)->column('id');
- $model = $model->where('cate_id', 'in', $cate_ids);
- }
- if ($search) $model = $model->where('title', 'LIKE', "%$search%");
- $list = $model->order('sort desc,id desc')->page($page, $limit)->select();
- $list = count($list) ? $list->toArray() : [];
- return $list;
- }
- /**
- * 获取单个资料的详细信息
- * @param $uid 用户id
- * @param $id 资料id
- * */
- public static function getOneDataDownload($uid, $id)
- {
- $data = self::PreWhere()->find($id);
- if (!$data) return self::setErrorInfo('您要查看的资料不存在!');
- if ($data->is_show == 0) return self::setErrorInfo('您要查看的资料已下架!');
- $title = $data->title;
- $data->collect = self::getDb('special_relation')->where(['link_id' => $id, 'type' => 1, 'uid' => $uid, 'category' => 1])->count() ? true : false;
- $data->abstract = htmlspecialchars_decode($data->abstract);
- $data = json_encode($data->toArray());
- return compact('data', 'title');
- }
- /**讲师名下资料
- * @param $mer_id
- * @param $page
- * @param $limit
- */
- public static function getLecturerDataDownloadList($mer_id, $page, $limit)
- {
- if ($mer_id) {
- $model = self::PreWhere();
- $model = $model->where(['mer_id' => $mer_id])->order('sort desc,id desc');
- $list = $model->page($page, $limit)->select();
- $list = count($list) ? $list->toArray() : [];
- } else {
- $list = [];
- }
- return $list;
- }
- }
|