// +---------------------------------------------------------------------- namespace App\Services; use App\Models\ArticleModel; /** * 文章管理-服务类 * @author wesmiler * @since 2020/11/11 * Class ArticleService * @package App\Services */ class ArticleService extends BaseService { /** * 构造函数 * @author wesmiler * @since 2020/11/11 * ArticleService constructor. */ public function __construct() { $this->model = new ArticleModel(); } /** * 获取列表 * @return array * @since 2020/11/11 * @author wesmiler */ public function getList() { $params = request()->all(); $page = isset($params['pageSize']) ? intval($params['pageSize']) : PAGE; $pageSize = isset($params['pageSize']) ? intval($params['pageSize']) : PERPAGE; $dataList = $this->model::from('article as a') ->leftJoin('article_cates as c', 'a.cate_id', '=', 'c.id') ->where(function ($query) use ($params) { $query->where('a.mark', 1); $title = isset($params['title']) ? trim($params['title']) : ''; if (!empty($title)) { $query->where('a.title', 'like', "%{$title}%"); } $cateId = isset($params['cate_id']) ? intval($params['cate_id']) : 0; if ($cateId > 0) { $query->where('a.cate_id', $cateId); } else if ($cateId == -1) { $query->where('a.is_recommand', 1); } $isTop = isset($params['is_top']) ? intval($params['is_top']) : 0; if ($isTop > 0) { $query->where('a.is_top', $isTop); } $status = isset($params['status']) ? $params['status'] : 0; if ($status > 0) { $query->where('a.status', $status); } else { $query->whereIn('a.status', [1, 2]); } }) ->select(['a.id', 'a.cate_id', 'c.name as cate_name', 'a.title', 'a.is_form', 'a.is_recommand', 'a.view_num', 'a.thumb', 'a.status', 'a.create_time', 'a.update_time', 'a.description', 'a.sort', 'a.content','a.publish_at']) ->orderBy('a.update_time', 'desc') ->paginate($pageSize); $dataList = $dataList ? $dataList->toArray() : []; if ($dataList) { foreach ($dataList['data'] as &$item) { $item['thumb'] = $item['thumb'] ? get_image_url($item['thumb']) : ''; $item['create_time'] = $item['create_time'] ? datetime($item['create_time'],'Y-m-d H:i:s') : ''; } unset($item); } return [ 'code' => 0, 'success'=> true, 'msg' => '操作成功', 'count' => isset($dataList['total']) ? $dataList['total'] : 0, 'data' => isset($dataList['data']) ? $dataList['data'] : 0, ]; } /** * 添加或编辑 * @return array * @since 2020/11/11 * @author wesmiler */ public function edit() { $data = request()->all(); // 图片处理 $image = trim($data['thumb']); $id = isset($data['id']) ? $data['id'] : 0; if (!$id && !$image) { return message('请上传文章图片', false); } if (strpos($image, "temp")) { $data['thumb'] = save_image($image, 'item'); } else { $data['thumb'] = str_replace(IMG_URL, "", $data['thumb']); } $data['update_time'] = time(); $data['publish_at'] = isset($data['publish_at']) && $data['publish_at']? $data['publish_at'] : date('Y-m-d H:i:s'); return parent::edit($data); // TODO: Change the autogenerated stub } }