/**
* 视频查询，会员作品，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 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;
}
/**
* 根据类别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);
}
/**
* 获取推荐产品 设计师供应type==2，制作公司供应type==4
*/
public function getRecommendProducts($limit)
{
return GoodsModel::where('recommend', 1)->whereIn('type', [2, 4])->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;
}
