public function query()
{
$uid = $this->userid ? $this->userid : 0;
$datas = ProductModel::where('del', 0)->where('uid', $uid)->orderBy('sort', 'desc')->orderBy('id', 'desc')->paginate($this->limit);
$datas->limit = $this->limit;
return $datas;
}
/**
* 在线创作查询
*/
public function products($type)
{
//genre==1:个人供应；genre==2:企业供应
if ($type) {
$datas = ProductModel::where('del', 0)->where('genre', $type)->where('isshow', 1)->orderBy('sort', 'desc')->orderBy('id', 'desc')->paginate($this->limit);
} else {
$datas = ProductModel::where('del', 0)->where('isshow', 1)->orderBy('sort', 'desc')->orderBy('id', 'desc')->paginate($this->limit);
}
return $datas;
}
public function update(Request $request, $id)
{
$data = $this->getData($request);
$data['updated_at'] = time();
ProductModel::where('id', $id)->update($data);
//更新搜索表
$productModel = ProductModel::where('id', $id)->first();
\App\Models\Home\SearchModel::change($productModel, 1, 'update');
return redirect(DOMAIN . 'admin/product');
}
/**
* 以下是要展示的数据
*/
public function query($cate)
{
if ($cate) {
$datas = ProductModel::where('cate', $cate)->where('isshow', 2)->where('isauth', 3)->where('uid', 0)->orderBy('sort', 'desc')->orderBy('id', 'desc')->paginate($this->limit);
} else {
$datas = ProductModel::where('isshow', 2)->where('isauth', 3)->where('uid', 0)->orderBy('sort', 'desc')->orderBy('id', 'desc')->paginate($this->limit);
}
$datas->limit = $this->limit;
return $datas;
}
/**
* 在线创作的作品
*/
public function products($p_type = 1)
{
if ($p_type == 1) {
$buyerIds = array();
$buyers = OrderProductModel::where('del', 0)->where('buyer', $this->userid)->where('isshow', 1)->get();
if (count($buyers)) {
foreach ($buyers as $buyer) {
$buyerIds[] = $buyer->id;
}
}
$datas = ProductModel::where('del', 0)->whereIn('uid', $buyerIds)->where('isshow', 1)->orderBy('sort', 'desc')->orderBy('id', 'desc')->paginate(10);
} else {
if ($p_type == 2) {
$datas = ProductModel::where('del', 0)->where('uid', $this->userid)->where('isshow', 1)->orderBy('sort', 'desc')->orderBy('id', 'desc')->paginate(10);
}
}
return $datas;
}
/**
* 获取在线创作
*/
public function getProducts($limit)
{
return ProductModel::where('isshow', 1)->orderBy('sort', 'desc')->orderBy('id', 'desc')->paginate($limit);
}
/**
* 查询方法
*/
public function query()
{
$datas = ProductModel::where('isshow', 2)->orderBy('id', 'desc')->paginate($this->limit);
$datas->limit = $this->limit;
return $datas;
}
public function query($genre, $cate)
{
if ($genre == 1) {
if ($cate) {
$datas = ProductModel::where('cate', $cate)->where('video_id', '>', 0)->orderBy('id', 'desc')->paginate($this->limit);
} else {
$datas = ProductModel::where('video_id', '>', 0)->orderBy('id', 'desc')->paginate($this->limit);
}
} elseif (in_array($genre, [2, 3])) {
if ($cate) {
$datas = ProductVideoModel::where('cate', $cate)->where('genre', $genre - 1)->orderBy('id', 'desc')->paginate($this->limit);
} else {
$datas = ProductVideoModel::where('genre', $genre - 1)->orderBy('id', 'desc')->paginate($this->limit);
}
}
$datas->limit = $this->limit;
return $datas;
}
/**
* 获取产品记录
*/
public function getProduct($id)
{
$productModel = ProductModel::find($id);
$data = ['name' => $productModel->name, 'serial' => $productModel->serial, 'cate' => $productModel->cate, 'gif' => $productModel->gif, 'intro' => $productModel->intro, 'uid' => $this->userid, 'pid' => $id, 'created_at' => time()];
ProductModel::create($data);
$productModelNew = ProductModel::where($data)->first();
return $productModelNew->id;
}
