コード例 #1
0
 public function query($genre)
 {
     if ($genre == 1) {
         //视频需求,type==1、3是需求
         $datas = GoodsModel::whereIn('type', [1, 3])->where('isshow', 1)->where('isshow2', 1)->where('del', 0)->orderBy('sort', 'desc')->orderBy('id', 'desc')->paginate($this->limit);
     } elseif ($genre == 2) {
         //创意剧本,genre==2是需求
         $datas = IdeasModel::where('genre', 2)->where('isshow', 1)->where('del', 0)->orderBy('sort', 'desc')->orderBy('id', 'desc')->paginate($this->limit);
     } elseif ($genre == 3) {
         //分镜需求,genre==2是需求
         $datas = StoryBoardModel::where('genre', 2)->where('isshow', 1)->where('isshow2', 1)->where('del', 0)->orderBy('sort', 'desc')->orderBy('sort2', 'desc')->orderBy('id', 'desc')->paginate($this->limit);
     } elseif ($genre == 4) {
         //演员需求,genre==2是需求
         $datas = EntertainModel::where('genre', 2)->where('del', 0)->orderBy('sort', 'desc')->orderBy('id', 'desc')->paginate($this->limit);
     } elseif ($genre == 5) {
         //设备需求,genre==2是需求
         $datas = RentModel::where('genre', 2)->where('del', 0)->orderBy('sort', 'desc')->orderBy('id', 'desc')->paginate($this->limit);
     } elseif ($genre == 6) {
         //设计需求,genre==2是需求
         $datas = DesignModel::where('genre', 2)->where('del', 0)->orderBy('sort', 'desc')->orderBy('id', 'desc')->paginate($this->limit);
     }
     $datas->limit = $this->limit;
     return $datas;
 }
コード例 #2
0
 public function query($del = 0)
 {
     $datas = StoryBoardModel::where('del', $del)->where('isshow', 1)->orderBy('sort', 'desc')->orderBy('id', 'desc')->paginate($this->limit);
     $datas->limit = $this->limit;
     return $datas;
 }
コード例 #3
0
 public function query($way, $cate)
 {
     //way:0所有,1最新isnew,2最热ishot
     if ($way == 0) {
         if ($cate) {
             $datas = StoryBoardModel::where('del', 0)->where('isshow', 1)->where('cate', $cate)->where('genre', $this->genre)->orderBy('sort', 'desc')->orderBy('id', 'desc')->paginate($this->limit);
         } else {
             $datas = StoryBoardModel::where('del', 0)->where('isshow', 1)->where('genre', $this->genre)->orderBy('sort', 'desc')->orderBy('id', 'desc')->paginate($this->limit);
         }
     } elseif ($way == 1) {
         if ($cate) {
             $datas = StoryBoardModel::where('del', 0)->where('isshow', 1)->where('isnew', 1)->where('cate', $cate)->where('genre', $this->genre)->orderBy('sort', 'desc')->orderBy('id', 'desc')->paginate($this->limit);
         } else {
             $datas = StoryBoardModel::where('del', 0)->where('isshow', 1)->where('isnew', 1)->where('genre', $this->genre)->orderBy('sort', 'desc')->orderBy('id', 'desc')->paginate($this->limit);
         }
     } elseif ($way == 2) {
         if ($cate) {
             $datas = StoryBoardModel::where('del', 0)->where('isshow', 1)->where('ishot', 1)->where('cate', $cate)->where('genre', $this->genre)->orderBy('sort', 'desc')->orderBy('id', 'desc')->paginate($this->limit);
         } else {
             $datas = StoryBoardModel::where('del', 0)->where('isshow', 1)->where('ishot', 1)->where('genre', $this->genre)->orderBy('sort', 'desc')->orderBy('id', 'desc')->paginate($this->limit);
         }
     }
     $datas->limit = $this->limit;
     return $datas;
 }