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;
}
