public function pre($id, $video_id)
{
//去除最新的标识
OrderProductModel::where('id', $id)->update(['is_new' => 2]);
$data = VideoModel::find($video_id);
$result = ['video' => $data, 'orderProModel' => OrderProductModel::find($id), 'videoName' => $data->name];
return view('layout.videoPre', $result);
}
public function orders()
{
$orders_create = OrderProductModel::all();
$orders_all = OrderModel::all();
$orders_firm = OrderFirmModel::all();
//各个订单
$orders_C = OrderProductModel::where('isshow', 1)->paginate($this->limit);
$orders_A = OrderModel::where('del', 0)->where('isshow', 1)->paginate($this->limit);
$orders_F = OrderFirmModel::where('del', 0)->where('isshow', 1)->paginate($this->limit);
return array('create' => count($orders_create), 'all' => count($orders_all), 'firm' => count($orders_firm), 'ordersC' => $orders_C, 'ordersA' => $orders_A, 'ordersF' => $orders_F);
}
/**
* 在线创作的作品
*/
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 query($isshow, $status)
{
if ($isshow && $status) {
$datas = OrderProductModel::where('isshow', $isshow)->where('status', $status)->orderBy('id', 'desc')->paginate($this->limit);
} elseif (!$isshow && $status) {
$datas = OrderProductModel::where('status', $status)->orderBy('id', 'desc')->paginate($this->limit);
} elseif ($isshow && !$status) {
$datas = OrderProductModel::where('isshow', $isshow)->orderBy('id', 'desc')->paginate($this->limit);
} elseif (!$isshow && !$status) {
$datas = OrderProductModel::orderBy('id', 'desc')->paginate($this->limit);
}
$datas->limit = $this->limit;
return $datas;
}
/**
* 成功的在线创作订单
*/
public function orderPros($genre, $cate)
{
if ($cate) {
$datas = OrderProductModel::where('genre', $genre)->where('cate', $cate)->where('video_id', '>', 0)->orderBy('id', 'desc')->paginate($this->limit);
} else {
$datas = OrderProductModel::where('genre', $genre)->where('video_id', '>', 0)->orderBy('id', 'desc')->paginate($this->limit);
}
$datas->limit = $this->limit;
return $datas;
}
public function query()
{
$datas = OrderProductModel::where('isshow', 2)->orderBy('id', 'desc')->paginate($this->limit);
$datas->limit = $this->limit;
return $datas;
}
