123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106 |
- <?php
- namespace app\dao\article;
- use app\dao\BaseDao;
- use app\model\article\Article;
- class ArticleDao extends BaseDao
- {
-
- protected function setModel(): string
- {
- return Article::class;
- }
- public function search(array $where = [])
- {
- return parent::search($where)->when(isset($where['ids']) && count($where['ids']), function ($query) use ($where) {
- $query->whereNotIn('id', $where['ids']);
- });
- }
-
- public function getList(array $where, int $page, int $limit)
- {
- return $this->search($where)->with(['content', 'storeInfo', 'cateName'])->page($page, $limit)->order('sort desc,id desc')->select()->toArray();
- }
-
- public function read($id)
- {
- $data = $this->search()->with(['content', 'storeInfo', 'cateName'])->find($id);
- if($data){
- $data['store_info'] = $data['storeInfo'];
- }
- return $data;
- }
-
- public function cidByArticleList(array $where, int $page, int $limit, string $field = '*')
- {
- return $this->search(['status' => 1, 'hide' => 0])
- ->when(isset($where['cid']) && $where['cid'], function ($query) use ($where) {
- $query->where('cid', $where['cid']);
- })->when(isset($where['is_hot']) && $where['is_hot'], function ($query) use ($where) {
- $query->where('is_hot', $where['is_hot']);
- })->when(isset($where['is_banner']) && $where['is_banner'], function ($query) use ($where) {
- $query->where('is_banner', $where['is_banner']);
- })->when($page != 0, function ($query) use ($page, $limit) {
- $query->page($page, $limit);
- })->order('add_time desc')->field($field)->select()->toArray();
- }
-
- public function articleLists($new_id)
- {
- return $this->getModel()->where('hide', 0)->where('id', 'in', $new_id)->select();
- }
-
- public function articleContentList($new_id)
- {
- return $this->getModel()->where('hide', 0)->where('id', 'in', $new_id)->with('content')->select();
- }
- }
|