public function pre($id) { $data = GoodsModel::find($id); $videoid = $data->video_id ? $data->video_id : 0; $result = ['data' => $data, 'video' => VideoModel::find($videoid), 'uid' => $this->userid, 'videoName' => $data->name]; return view('layout.videoPre', $result); }
/** * 视频查询,会员作品,type==2设计师供应,4企业供应 */ public function goods($type) { if ($type) { $datas = GoodsModel::where('del', 0)->where('genre', 1)->where('isshow', 1)->whereIn('type', [2, 4])->orderBy('sort', 'desc')->orderBy('id', 'desc')->paginate($this->limit); } else { $datas = GoodsModel::where('del', 0)->where('genre', 1)->where('isshow', 1)->orderBy('sort', 'desc')->orderBy('id', 'desc')->paginate($this->limit); } return $datas; }
/** * 查询方法 */ public function query($type = 0) { if ($type) { $datas = GoodsModel::where('del', 0)->where('type', $type)->orderBy('id', 'desc')->paginate($this->limit); } else { $datas = GoodsModel::where('del', 0)->orderBy('id', 'desc')->paginate($this->limit); } $datas->limit = $this->limit; return $datas; }
/** * 订单来源的数据 */ public function getModel() { if (in_array($this->genre, [1, 2])) { $model = IdeasModel::find($this->fromid); } elseif (in_array($this->genre, [3, 4])) { $model = StoryBoardModel::find($this->fromid); } elseif (in_array($this->genre, [5, 6])) { $model = GoodsModel::find($this->fromid); } return isset($model) ? $model : ''; }
public function query($uid, $genre, $cate) { $limit = 20; if ($cate) { $datas = GoodsModel::where('uid', $uid)->where('del', 0)->where('genre', $genre)->where('type', 4)->where('cate', $cate)->where('isshow', 1)->where('isshow2', 1)->orderBy('sort', 'desc')->orderBy('id', 'desc')->paginate($limit); } else { $datas = GoodsModel::where('uid', $uid)->where('del', 0)->where('genre', $genre)->where('type', 4)->where('isshow', 1)->where('isshow2', 1)->orderBy('sort', 'desc')->orderBy('id', 'desc')->paginate($limit); } $datas->limit = $limit; return $datas; }
public function query() { $data = new \stdClass(); //type==1公司简介,2历程,3新闻,4资讯,5服务,6团队,7招聘,21单页 $data->abouts = ComFuncModel::where('type', '<', 5)->where('cid', $this->cid)->get(); $data->products = GoodsModel::where('genre', 1)->where('type', 4)->get(); $data->teams = ComFuncModel::where('type', 6)->where('cid', $this->cid)->get(); $data->jobs = ComFuncModel::where('type', 7)->where('cid', $this->cid)->get(); //公司联系方式 $data->contactFields = ['area', 'point', 'address', 'tel', 'qq', 'web', 'fax', 'email']; $data->contactFieldNames = ['地区', '坐标', '地址', '电话', 'qq', '网址', '传真', '邮箱']; $data->contact = 0; $comMainModel = CompanyModel::find($this->cid); $comMainModel = Tools::objectToArray($comMainModel); foreach ($data->contactFields as $contactField) { if ($comMainModel[$contactField]) { $data->contact++; } } $data->parts = GoodsModel::where('genre', 2)->where('type', 4)->get(); $data->firms = ComFuncModel::where('type', 5)->where('cid', $this->cid)->get(); return $data; }
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; }
/** * 根据类别cate,获取样片 */ public function getGoodsByCate($cate = 1, $limit = 5) { return GoodsModel::where('isshow', 1)->where('isshow2', 1)->where('cate', $cate)->where('del', 0)->orderBy('sort', 'desc')->orderBy('id', 'desc')->paginate($limit); }
/** * 初始化搜索表 */ public function init() { //在线创作表 $products = ProductModel::all(); if (count($products)) { $rst['product'] = $this->tochange($products, 'product'); } else { $rst['product'] = "在线创作表 product 没有记录!"; } //上传的产品表 $goods = GoodsModel::all(); if (count($goods)) { $rst['goods'] = $this->tochange($goods, 'goods'); } else { $rst['goods'] = "上传的产品表 goods 没有记录!"; } //创意表 $ideas = IdeasModel::all(); if (count($ideas)) { $rst['idea'] = $this->tochange($ideas, 'idea'); } else { $rst['idea'] = "创意表 idea 没有记录!"; } //分镜表 $storyboards = StoryBoardModel::all(); if (count($ideas)) { $rst['storyboard'] = $this->tochange($storyboards, 'storyboard'); } else { $rst['storyboard'] = "分镜表 storyboard 没有记录!"; } //公司表 $companys = CompanyModel::all(); if (count($ideas)) { $rst['company'] = $this->tochange($companys, 'company'); } else { $rst['company'] = "公司表 company 没有记录!"; } //影视作品表 $works = WorksModel::all(); if (count($works)) { $rst['works'] = $this->tochange($works, 'works'); } else { $rst['works'] = "作品表 works 没有记录!"; } //演员表 $actors = StaffModel::where('genre', 1)->get(); if (count($actors)) { $rst['actor'] = $this->tochange($actors, 'actor'); } else { $rst['actor'] = "人员表演员 actor 没有记录!"; } //租赁表 $rents = RentModel::all(); if (count($rents)) { $rst['rent'] = $this->tochange($rents, 'rent'); } else { $rst['rent'] = "租赁表 rent 没有记录!"; } //设计表 $designs = DesignModel::all(); if (count($designs)) { $rst['design'] = $this->tochange($designs, 'design'); } else { $rst['design'] = "设计表 design 没有记录!"; } dd($rst); }
/** * 获取样片需求 个人需求type==1,企业需求type==3 */ public function getDemands($limit) { return GoodsModel::whereIn('type', [1, 3])->orderBy('sort', 'desc')->orderBy('id', 'desc')->paginate($limit); }
public function forceDelete($id) { GoodsModel::where('id', $id)->delete(); return redirect(DOMAIN . 'member/companyD/trash'); }
/** * 查询方法 */ public function query($del = 0, $cate = 0) { //说明:genre==1产品,2花絮;type==1个人需求,2个人供应,3企业需求,4企业供应 if ($cate) { $datas = GoodsModel::where('uid', $this->userid)->where('del', $del)->where('cate', $cate)->where(array('genre' => 1, 'type' => 4))->paginate($this->limit); } else { $datas = GoodsModel::where('uid', $this->userid)->where('del', $del)->where(array('genre' => 1, 'type' => 4))->paginate($this->limit); } $datas->limit = $this->limit; return $datas; }
/** * 推荐样片 */ public function queryR() { return GoodsModel::where('recommend', 1)->where('isshow', 1)->where('isshow2', 1)->where('del', 0)->orderBy('sort', 'desc')->orderBy('id', 'desc')->paginate($this->limit); }
/** * 企业产品 GodsModel */ public function getWorks($uid, $limit) { $works = GoodsModel::where('uid', $uid)->where('del', 0)->where('genre', 1)->where('type', 4)->where('isshow', 1)->where('isshow2', 1)->orderBy('sort', 'desc')->orderBy('id', 'desc')->paginate($limit); $works->limit = $limit; return $works; }
/** * 查询方法 */ public function query($del = 0, $type) { $datas = GoodsModel::where('del', $del)->where('type', $type)->orderBy('id', 'desc')->paginate($this->limit); $datas->limit = $this->limit; return $datas; }