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