public function query($type, $fromMoney, $toMoney) { if ($type) { $datas = RentModel::where('genre', 1)->where('del', 0)->where('type', $type)->where('money', '>', $fromMoney)->where('money', '<', $toMoney)->orderBy('sort', 'desc')->orderBy('id', 'desc')->paginate($this->limit); } else { $datas = RentModel::where('genre', 1)->where('del', 0)->where('money', '>', $fromMoney)->where('money', '<', $toMoney)->orderBy('sort', 'desc')->orderBy('id', 'desc')->paginate($this->limit); } $datas->limit = $this->limit; return $datas; }
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; }
/** * 用于初始化 * 组合关键字 */ public function getKeyword($data, $genre) { $model = new SearchModel(); if ($genre == 'product') { $keyword = $data->name . $data->uname; $genre = 1; } elseif ($genre == 'goods') { $keyword = $data->name . $data->uname . $model['cates2'][$data->cate] . $data->money . '元'; $genre = 2; } elseif ($genre == 'idea') { $keyword = $data->name . $data->uname . $model['cates2'][$data->cate] . $data->money . '元'; $genre = 3; } elseif ($genre == 'storyboard') { $keyword = $data->name . $data->uname . $model['cates2'][$data->cate] . $data->money . '元'; $genre = 4; } elseif ($genre == 'company') { $companyModel = new CompanyModel(); $genreName = array_key_exists($data->genre, $companyModel['genres']) ? $companyModel['genres'][$data->genre] : ''; $keyword = $data->name . $data->uname . $genreName . $companyModel->getAreaName($data->area) . $data->address; $genre = 5; } elseif ($genre == 'works') { $keyword = $data->name . $model['cates2'][$data->cate]; $genre = 6; } elseif ($genre == 'actor') { $education = new StaffModel(); $keyword = $data->name . $data->realname . $data->origin . $education['educations'][$data->education] . $data->school . $education->getAreaName($data->area); $genre = 7; } elseif ($genre == 'rent') { $rentModel = new RentModel(); $keyword = $data->name . $rentModel->getAreaName($data->area) . $data->money . '元'; $genre = 8; } elseif ($genre == 'design') { $keyword = $data->name . $model['cates1'][$data->cate] . $data->money . '元'; $genre = 9; } return array('keyword' => $keyword, 'genre' => $genre); }
/** * 获取租赁信息 */ public function getRents($limit) { return RentModel::where('del', 0)->orderBy('sort', 'desc')->orderBy('id', 'desc')->paginate($limit); }
/** * 查询方法 */ public function query($del, $genre, $type) { if ($genre) { $datas = RentModel::where('del', $del)->where('genre', $genre)->where('type', $type)->orderBy('id', 'desc')->paginate($this->limit); } else { $datas = RentModel::where('del', $del)->where('genre', $genre)->orderBy('id', 'desc')->paginate($this->limit); } $datas->limit = $this->limit; return $datas; }
/** * 查询方法 */ public function query($del = 0) { $datas = RentModel::where('del', $del)->orderBy('id', 'desc')->paginate($this->limit); $datas->limit = $this->limit; return $datas; }
/** * 将对这些表的操作,插入或更新到数据库 * genre==1创作,2样片,3创意,4分镜,5企业,6影视,7演员,8设备,9设计, */ public static function change($data, $genre, $oper) { $model = new SearchModel(); if ($oper == 'create') { if ($genre == 'product') { $keyword = $data->name . $data->uname; SearchModel::intoDB($keyword, 1, $data->id); } elseif ($genre == 'goods') { $keyword = $data->name . $data->uname . $model['cates2'][$data->cate] . $data->money . '元'; SearchModel::intoDB($keyword, 2, $data->id); } elseif ($genre == 'idea') { $keyword = $data->name . $data->uname . $model['cates2'][$data->cate] . $data->money . '元'; SearchModel::intoDB($keyword, 3, $data->id); } elseif ($genre == 'storyboard') { $keyword = $data->name . $data->uname . $model['cates2'][$data->cate] . $data->money . '元'; SearchModel::intoDB($keyword, 4, $data->id); } elseif ($genre == 'company') { $companyModel = new CompanyModel(); $genreName = array_key_exists($data->genre, $companyModel['genres']) ? $companyModel['genres'][$data->genre] : ''; $keyword = $data->name . $data->uname . $genreName . $companyModel->getAreaName($data->area) . $data->address; SearchModel::intoDB($keyword, 5, $data->id); } elseif ($genre == 'works') { $keyword = $data->name . $model['cates2'][$data->cate]; SearchModel::intoDB($keyword, 6, $data->id); } elseif ($genre == 'actor') { $education = new StaffModel(); $keyword = $data->name . $data->realname . $data->origin . $education['educations'][$data->education] . $data->school . $education->getAreaName($data->area); SearchModel::intoDB($keyword, 7, $data->id); } elseif ($genre == 'rent') { $rentModel = new RentModel(); $keyword = $data->name . $rentModel->getAreaName($data->area) . $data->money . '元'; SearchModel::intoDB($keyword, 8, $data->id); } elseif ($genre == 'design') { $keyword = $data->name . $model['cates1'][$data->cate] . $data->money . '元'; SearchModel::intoDB($keyword, 9, $data->id); } } elseif ($oper == 'update') { if ($genre == 'product') { $keyword = $data->name . $data->uname; SearchModel::updateDB($keyword, 1, $data->id); } elseif ($genre == 'goods') { $keyword = $data->name . $data->uname . $model['cates2'][$data->cate] . $data->money . '元'; SearchModel::updateDB($keyword, 2, $data->id); } elseif ($genre == 'idea') { $keyword = $data->name . $data->uname . $model['cates2'][$data->cate] . $data->money . '元'; SearchModel::updateDB($keyword, 3, $data->id); } elseif ($genre == 'storyboard') { $keyword = $data->name . $data->uname . $model['cates2'][$data->cate] . $data->money . '元'; SearchModel::updateDB($keyword, 4, $data->id); } elseif ($genre == 'company') { $companyModel = new CompanyModel(); $keyword = $data->name . $data->uname . $companyModel['genres'][$data->genre] . $companyModel->getAreaName($data->area) . $data->address; SearchModel::updateDB($keyword, 5, $data->id); } elseif ($genre == 'works') { $keyword = $data->name . $model['cates2'][$data->cate]; SearchModel::updateDB($keyword, 6, $data->id); } elseif ($genre == 'actor') { $education = new StaffModel(); $keyword = $data->name . $data->realname . $data->origin . $education['educations'][$data->education] . $data->school . $education->getAreaName($data->area); SearchModel::updateDB($keyword, 7, $data->id); } elseif ($genre == 'rent') { $rentModel = new RentModel(); $keyword = $data->name . $rentModel->getAreaName($data->area) . $data->money . '元'; SearchModel::updateDB($keyword, 8, $data->id); } elseif ($genre == 'design') { $keyword = $data->name . $model['cates1'][$data->cate] . $data->money . '元'; SearchModel::updateDB($keyword, 9, $data->id); } } elseif ($oper == 'del') { } }