public function getOrderslist() { $Orders = DB::table('Orders'); $Orders->leftJoin('order_shipping', 'Orders.id', '=', 'order_shipping.order_id'); $Orders->select('Orders.id', 'Orders.buy_tel', 'Orders.order_created', 'Orders.voucher_name', 'Orders.pay_total', 'order_shipping.shipping_code', 'order_shipping.created_at', 'Orders.buy_name', 'Orders.taopix_order_id', 'Orders.item_count', 'Orders.status'); $orderid = Input::get('orderid'); if ($orderid) { $Orders->where('taopix_order_id', $orderid); } $buytel = Input::get('buy_tel'); if ($buytel) { $Orders->where('buy_tel', $buytel); } $buyname = Input::get('buy_name'); if ($buyname) { $Orders->where('buy_name', $buyname); } $createdStart = Input::get('order_created_start'); $createdEnd = Input::get('order_created_end'); if ($createdStart && $createdEnd) { //$where .= ' AND order_created between ' . $createdStart."'"." AND ' ".$createdEnd ."'"; $Orders->whereBetween('order_created', [$createdStart, $createdEnd]); } $orders['search']['orderid'] = $orderid; $orders['search']['buytel'] = $buytel; $orders['search']['buyname'] = $buyname; $orders['search']['createdStart'] = $createdStart; $orders['search']['createdEnd'] = $createdEnd; $orders['data'] = $Orders->orderBy('Orders.id', 'desc')->paginate(10); return $orders; }
public function assignRoleFeature($rid) { $role = Role::find($rid); $fid = Input::get('feature_id'); $role_feature = FeatureRole::createNewPivot($rid, $fid); return Redirect::to('/crm/role/' . $rid)->withMessage(Generate::message('Success', 'New Featured Assigned.')); }
public function ajaxImageUpload() { $user_id = Input::get('user_id'); $file = Input::file('display_image'); //get the image folder to store the image, in this case the specific restaurant folder. $image_folder = '/assets/images/users/'; //upload the image and return the file path $file_path = Image::uploadImage($file, $image_folder); if ($file_path['status'] != 1) { return Response::json(['success' => false, 'errors' => $file_path['errors']]); } $user = User::find($user_id); $user->display_image = $file_path['data']; $user->save(); User::updateUserSession(); return Response::json(['success' => true, 'message' => 'Profile Image Updated.', 'file' => $user->display_image]); }