public function getDatas($genre, $keyword)
{
//genre==1创作，2样片，3创意，4分镜，5企业，6影视，7演员，8设备，9设计，
$datas = SearchModel::where('genre', $genre)->where('keyword', 'like', '%' . $keyword . '%')->get();
$searchIds = array();
if (count($datas)) {
foreach ($datas as $data) {
$searchIds[] = $data->fromid;
//处理关键字才行频率
if (SearchKeywordModel::where('search_id', $data->id)->first()) {
//假如有记录，更新频率 rate
SearchKeywordModel::where('search_id', $data->id)->update(array('updated_at' => time()));
SearchKeywordModel::where('search_id', $data->id)->increment('rate');
} else {
$searchKeyword = ['search_id' => $data->id, 'keyword' => $keyword, 'created_at' => time()];
SearchKeywordModel::create($searchKeyword);
}
}
}
if ($genre == 1) {
$datas = ProductModel::whereIn('id', $searchIds)->orderBy('id', 'desc')->paginate($this->limit);
$datas->url = DOMAIN . 'creation/';
} elseif ($genre == 2) {
$datas = GoodsModel::whereIn('id', $searchIds)->orderBy('id', 'desc')->paginate($this->limit);
$datas->url = DOMAIN . 'product/';
} elseif ($genre == 3) {
$datas = IdeasModel::whereIn('id', $searchIds)->orderBy('id', 'desc')->paginate($this->limit);
$datas->url = DOMAIN . 'idea/';
} elseif ($genre == 4) {
$datas = StoryBoardModel::whereIn('id', $searchIds)->orderBy('id', 'desc')->paginate($this->limit);
$datas->url = DOMAIN . 'storyboard/';
} elseif ($genre == 5) {
$datas = CompanyModel::whereIn('id', $searchIds)->orderBy('id', 'desc')->paginate($this->limit);
$datas->url = DOMAIN . 'company/';
} elseif ($genre == 6) {
$datas = WorksModel::whereIn('id', $searchIds)->orderBy('id', 'desc')->paginate($this->limit);
$datas->url = DOMAIN . 'entertain/works/show/';
} elseif ($genre == 7) {
$datas = StaffModel::whereIn('id', $searchIds)->orderBy('id', 'desc')->paginate($this->limit);
$datas->url = DOMAIN . 'entertain/staff/show/';
} elseif ($genre == 8) {
$datas = RentModel::whereIn('id', $searchIds)->orderBy('id', 'desc')->paginate($this->limit);
$datas->url = DOMAIN . 'rent/';
} elseif ($genre == 9) {
$datas = DesignModel::whereIn('id', $searchIds)->orderBy('id', 'desc')->paginate($this->limit);
$datas->url = DOMAIN . 'design/';
}
$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;
}
/**
* 用户类型数组 arr
* 推荐和最新：recommend、newest
*/
public function getNewests($arr)
{
if ($arr) {
$userModels = UserModel::whereIn('isuser', $arr)->get();
$userIds = array();
if ($userModels) {
foreach ($userModels as $userModel) {
$userIds[] = $userModel->id;
}
}
return GoodsModel::whereIn('uid', $userIds)->where('newest', 1)->where('isshow', 1)->where('isshow2', 1)->where('del', 0)->orderBy('sort', 'desc')->orderBy('id', 'desc')->paginate($this->limit);
// ->get();
} else {
return GoodsModel::where('newest', 1)->where('isshow', 1)->where('isshow2', 1)->where('del', 0)->orderBy('sort', 'desc')->orderBy('id', 'desc')->paginate($this->limit);
}
}
/**
* 获取样片需求 个人需求type==1，企业需求type==3
*/
public function getDemands($limit)
{
return GoodsModel::whereIn('type', [1, 3])->orderBy('sort', 'desc')->orderBy('id', 'desc')->paginate($limit);
}
