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