// +---------------------------------------------------------------------- namespace App\Services\Api; use App\Models\ArticleCateModel; use App\Models\ArticleModel; use App\Services\BaseService; use App\Services\ConfigService; use App\Services\RedisService; /** * 文章-服务类 * @author laravel开发员 * @since 2020/11/11 * @package App\Services\Api */ class ArticleService extends BaseService { // 静态对象 protected static $instance = null; /** * 构造函数 * @author laravel开发员 * @since 2020/11/11 */ public function __construct() { $this->model = new ArticleModel(); } /** * 静态入口 */ public static function make() { if (!self::$instance) { self::$instance = new static(); } return self::$instance; } /** * 信息 * @param int $num * @return array|mixed */ public function getInfoByType($type) { $cacheKey = "caches:article:info_{$type}"; $datas = RedisService::get($cacheKey); if($datas){ return $datas; } $datas = $this->model->where(['type'=>$type,'status'=>1,'mark'=>1]) ->select(['id','title','type','content','status']) ->orderBy('create_time','desc') ->first(); $datas = $datas? $datas->toArray() : []; if($datas){ $datas['content'] = preg_replace("/\n+/",'
',$datas['content']); $datas['content'] = get_format_content($datas['content']); RedisService::set($cacheKey, $datas, 86400); } return $datas; } /** * @param $params * @param int $pageSize * @return array */ public function getDataList($params, $pageSize = 15) { $query = $this->getQuery($params); $list = $query->select(['a.id','a.type','a.title','a.cover','a.views','a.create_time','a.content','a.status']) ->orderBy('a.create_time','desc') ->paginate($pageSize > 0 ? $pageSize : 9999999); $list = $list? $list->toArray() :[]; if($list){ foreach($list['data'] as &$item){ $item['create_time'] = $item['create_time']? datetime($item['create_time'],'Y-m-d H.i.s') : ''; $item['cover'] = $item['cover']? get_image_url($item['cover']) : ''; $item['content'] = $item['content']? get_format_content($item['content']) : ''; } } return [ 'pageSize'=> $pageSize, 'total'=>isset($list['total'])? $list['total'] : 0, 'list'=> isset($list['data'])? $list['data'] : [] ]; } /** * 查询 * @param $params * @return mixed */ public function getQuery($params) { $where = ['a.mark' => 1]; $status = isset($params['status'])? $params['status'] : 0; $type = isset($params['type'])? $params['type'] : 0; if($status>0){ $where['a.status'] = $status; } if($type>0){ $where['a.type'] = $type; } return $this->model->from('article as a') ->where($where) ->where(function ($query) use($params){ $keyword = isset($params['keyword'])? $params['keyword'] : ''; if($keyword){ $query->where('a.title','like',"%{$keyword}%"); } }); } /** * 获取文章详情 * @param $id * @return array|mixed */ public function getInfo($id) { $cacheKey = "caches:articles:info_{$id}"; $info = RedisService::get($cacheKey); if($info){ return $info; } $info = $this->model->where(['id'=> $id,'status'=>1,'mark'=>1]) ->select(['id','title','cover','views','create_time','type','content']) ->first(); $info = $info? $info->toArray() : []; if($info){ $info['create_time'] = $info['create_time']? datetime($info['create_time'],'Y-m-d H.i.s') : ''; $info['cover'] = get_image_url($info['cover']); $info['content'] = get_format_content($info['content']); $this->model->where(['id'=> $id])->increment('views',1); $info['views'] += intval($info['views']); RedisService::set($cacheKey, $info, rand(3600,7200)); } return $info; } /** * 获取分类文章推荐 * @param int $cateId 推荐分类ID * @param int $type 类别:3-普通文章,4-客服回复 * @return array|mixed */ public function getCustomRecommend($cateId=0, $type=4) { $cacheKey = "caches:articles:list_{$cateId}"; $datas = RedisService::get($cacheKey); if($datas){ return $datas; } $limitNum = ConfigService::make()->getConfigByCode('custom_recommend_num', 6); $limitNum = $limitNum? $limitNum : 6; $datas = ArticleCateModel::where(function($query) use($cateId){ if($cateId){ $query->where('cate_id', $cateId); } })->where(['type'=>$type,'status'=>1,'mark'=>1]) ->select(['id','cate_id','title','description','sort','type','status']) ->limit($limitNum) ->orderBy('sort','desc') ->orderBy('create_time','desc') ->get(); $datas = $datas? $datas->toArray() : []; if($datas){ RedisService::set($cacheKey, $datas, rand(300,600)); } return $datas; } /** * 获取文章推荐分类 * @param int $type 1-普通文章分类,2-客服回复文章分类 * @return array|mixed */ public function getCateList($type=2) { $cacheKey = "caches:articles:cateList_{$type}"; $datas = RedisService::get($cacheKey); if($datas){ return $datas; } $limitNum = ConfigService::make()->getConfigByCode('custom_cate_num', 6); $limitNum = $limitNum? $limitNum : 6; $datas = ArticleCateModel::where(['type'=> $type,'status'=>1,'mark'=>1]) ->select(['cate_id','name','sort','type']) ->limit($limitNum) ->get(); $datas = $datas? $datas->toArray() : []; if($datas){ RedisService::set($cacheKey, $datas, rand(300,600)); } return $datas; } }