/**
* Return all the orders with their products and price/amount at given time
*
* @return \Illuminate\Database\Eloquent\Collection|static[]
*/
public function index()
{
return Order::with(['products' => function ($query) {
$query->select(['id', 'name', 'price', 'pivot.price', 'pivot.amount']);
$query->orderBy('sort');
}])->get();
}
public function edit($id)
{
$orders = Order::with('product')->where('order_unique_id', $id)->get();
$products = Product::lists('product_name', 'id');
$title = "Edit order ( {$id})";
return view('order.edit', compact('orders', 'title', 'products', 'id'));
}
/**
* Handle the event.
*
* @param MadeCheckout $event
* @return void
*/
public function handle(MadeCheckout $event)
{
$user = $event->user;
$checkout = $event->checkout;
$orders = Order::with('product')->where('checkout_id', $checkout->id)->get();
$admin = Sentinel::findRoleBySlug('admin');
$admins = $admin->users()->get();
$admin_emails = [];
foreach ($admins as $admin) {
array_push($admin_emails, $admin->email);
}
$data = ['checkout' => $checkout, 'orders' => $orders, 'user' => $user];
//dd($data);
Mail::send('email.orderconfirmation', $data, function ($message) use($user) {
$message->from('*****@*****.**', $name = "Trolleyin");
$message->subject('Trolleyin.com Order Confirmation');
$message->to($user->email);
});
foreach ($admin_emails as $email) {
Mail::send('email.admin.orderconfirmation', $data, function ($message) use($email) {
$message->from('*****@*****.**');
$message->subject('New Order Placed');
$message->to($email);
});
}
}
/**
* Make sure order belong to user given.
*
* @param User $user
* @param Order $order
*
* @return bool
*/
public function belongToUser(User $user, $order_id, &$order = null)
{
$query = Order::with('details')->where(['id' => $order_id, 'user_id' => $user->id])->first();
if (func_num_args() > 1) {
$order = $query;
}
return $query ? true : false;
}
/**
* Execute the console command.
* updating status prepared to traveling
* @return mixed
*/
public function fire()
{
$orders = Order::with('user')->where('status', 3)->get();
if ($orders) {
foreach ($orders as $order) {
$order->update(['status' => 4, 'shipped_on' => Carbon::now(), 'expected_delivery_on' => Carbon::now()->addDay()]);
event(new OrderShippedOn($order));
}
}
}
/**
* @param $id
* @return \Illuminate\Contracts\View\Factory|\Illuminate\View\View
*/
public function show($id)
{
try {
$order = Order::with('user', 'items.item')->findOrFail($id);
return view('orders.show', compact('order'));
} catch (ModelNotFoundException $ex) {
Flash::error('Model not found');
return view('orders.index');
}
}
/**
* Execute the console command.
*
* @return mixed
*/
public function fire()
{
$orders = Order::with('user')->where('status', 1)->whereNotNull('address_id')->get();
if (count($orders)) {
foreach ($orders as $order) {
$order->update(['status' => 2, 'processed_on' => Carbon::now()]);
event(new OrderWasProcessed($order));
}
}
}
/**
* Execute the console command.
*
* @return mixed
*/
public function fire()
{
$orders = Order::with('user', 'address')->where('status', 4)->where('expected_delivery_on', '<', Carbon::now())->get();
if ($orders) {
foreach ($orders as $order) {
$order->update(['status' => 5, 'delivered_on' => Carbon::now()]);
event(new OrderWasDelivered($order));
}
}
}
public function index(Request $request)
{
//取出订单列表
$builder = Order::with(['details'])->where('uid', '=', $this->user->getKey())->orderBy('updated_at', 'desc');
if ($request->get('status')) {
$builder->where('status', '=', $request->get('status'));
}
$this->_order_list = $builder->get();
$this->_status = $request->get('status') ?: 0;
return $this->view('m.ucenter');
}
public function getIndex()
{
$user_id = Auth::user()->id;
$orders = Order::with('orderItems')->where('user_id', $user_id)->get();
$order_count = $orders->count();
foreach ($orders as $order) {
$order->fullname = unserialize($order->fullname);
$order->address = unserialize($order->address);
}
return view('/order', ['orders' => $orders, 'order_count' => $order_count]);
}
public function index()
{
dd(\Auth::user()->email);
$user = \Auth::user();
$member_id = \Auth::user()->id;
// vibiraem vse zakazy usera
$orders = \App\Order::with('orderItems')->where('member_id', '=', $member_id)->orderBy('created_at', 'desc')->get();
// foreach ($orders as $order) {
// dd($order->orderItems);
// }
return view('orders', compact('orders', 'user'));
}
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index()
{
$sortBy = Input::get('sortBy');
$direction = Input::get('direction');
$limit = Input::get('limit') ? Input::get('limit') : 20;
$q = Input::get('q');
/* 정렬이 있는경우 */
if ($sortBy and $direction) {
/* 정렬이 있고 검색이 있는 경우
*/
// $order = Order::whereHas('orderItem', function($query) use ($q){
// $query->where('product_code','LIKE',"%$q%");
// })->with('orderItem')->orderBy($sortBy,$direction)->paginate($limit);
$order = Order::whereHas('orderItem', function ($query) use($q) {
$query->where('order_items.product_code', 'Like', "%{$q}%");
})->with(['orderItem' => function ($query) use($sortBy, $direction) {
$query->join('products', 'order_items.product_id', '=', 'products.id');
}])->orderBy($sortBy, $direction)->paginate($limit);
if ($q) {
// /* 정렬이 있지만 검색은 없는경우
// */
} else {
//$order = Order::with('orderItem')->orderBy($sortBy, $direction)->paginate($limit);
$order = Order::with(['orderItem' => function ($query) use($sortBy, $direction) {
$query->leftJoin('products', 'order_items.product_id', '=', 'products.id')->get();
}])->orderBy($sortBy, $direction)->paginate($limit);
}
//정렬이 없는 경우
} else {
/* 정렬은 없지만 검색이 있는 경우
*/
if ($q) {
$order = Order::whereHas('orderItem', function ($query) use($q) {
$query->where('order_items.product_code', 'Like', "%{$q}%");
})->with(['orderItem' => function ($query) {
$query->join('products', 'order_items.product_id', '=', 'products.id');
}])->orderBy('order_date', 'desc')->paginate($limit);
//return dd($order);
} else {
$order = Order::with(['orderItem' => function ($query) {
$query->leftJoin('products', 'order_items.product_id', '=', 'products.id')->get();
}])->orderBy('id', 'desc')->paginate($limit);
}
}
//return dd($order);
return view('order.index', compact('order'));
}
public function edit($id)
{
$order = Order::with(['details', 'order_express'])->join('order_expresses', 'order_expresses.id', '=', 'orders.id', 'INNER')->where('order_expresses.sid', $this->store->getKey())->find($id);
if (empty($order)) {
return $this->failure_noexists();
}
if ($order->order_express->express_type == 39) {
$this->_express_address = UserAddress::find($order->order_express->uaid)->getFullAddressAttribute();
} else {
$user_stores = Store::with('user')->find($order->order_express->sid);
$this->_express_address = $user_stores->name . '-店主:' . $user_stores->user->realname . '-电话:' . $user_stores->phone . '-地址:' . $user_stores->address ?: '无';
}
$keys = 'expresses_money';
$this->_validates = $this->getScriptValidate('order.express', $keys);
$this->_data = $order;
return $this->view('store-backend.order.edit');
}
/**
* Define your route model bindings, pattern filters, etc.
*
* @param \Illuminate\Routing\Router $router
* @return void
*/
public function boot(Router $router)
{
parent::boot($router);
$throwModelNotFound = function () {
throw new ModelNotFoundException();
};
$router->model('admins', User::class, $throwModelNotFound);
$router->model('users', User::class, $throwModelNotFound);
$router->model('dispatchers', User::class, $throwModelNotFound);
$router->model('drivers', User::class, $throwModelNotFound);
$router->bind('orders', function ($id) {
try {
return Order::with('statusHistory')->findOrFail($id);
} catch (Exception $e) {
$this->throwModelNotFound();
}
});
}
public function edit($id)
{
$order = Order::with(['order_express'])->where('fid', $this->factory->getKey())->find($id);
if (empty($order)) {
return $this->failure_noexists();
}
if ($order->order_express->express_type == 39) {
$this->_user_address = UserAddress::find($order->order_express->uaid)->getFullAddressAttribute();
$keys = 'express_name,no';
$this->_validates = $this->getScriptValidate('order.deliver', $keys);
} else {
$this->_user_stores = User::find($order->uid)->stores()->get();
$keys = 'sid';
$this->_validates = $this->getScriptValidate('order.express_store', $keys);
}
$this->_data = $order;
return $this->view('factory-backend.express.edit');
}
/**
* Display a listing of the resource.
*
* @return Response
*/
public function index()
{
$view = 'orders.index';
$statuses = [];
if ($this->user->is_admin) {
$statuses = OrderStatus::$statuses;
if (Input::get('status')) {
$orders = Order::where('status', Input::get('status'))->with('user', 'products')->get();
} else {
$orders = Order::with('user', 'products')->get();
}
} else {
$view .= '_client';
if (!Input::get('status')) {
$orders = $this->user->orders()->with('products')->get();
} else {
$orders = $this->user->orders()->where('status', Input::get('status'))->with('products')->get();
}
}
return view($view, compact('orders', 'statuses'));
}
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index()
{
$orders = Order::with('user', 'products')->orderBy('order_date', 'ASC')->paginate(20);
return view('admin.order.index', compact('orders'));
}
public function lab_upload($id)
{
$user = \Auth::user();
$userId = $user->id;
if ($id) {
$job = DB::table('work_schedule.events')->join('work_schedule.calendars', 'work_schedule.events.calendar_id', '=', 'work_schedule.calendars.calendar_id')->where('work_schedule.events.order_id', '=', $id)->first();
$file_path = base_path() . '/storage/excel/' . $id;
if (File::exists($file_path)) {
$job_file = 'exist';
} else {
$job_file = '';
}
$detail = Order::with('details')->join('site_details', 'site_details.id', '=', 'orders.site_id')->where('orders.id', '=', $id)->first();
foreach ($detail['details'] as $value) {
$test_material[] = DB::table('test_processes')->join('process_items', 'test_processes.item_id', '=', 'process_items.id')->select('process_items.name', 'process_items.image', 'process_items.type')->where('test_id', '=', $value['test_id'])->get();
}
$documents = array();
foreach ($detail['details'] as $item) {
$test_id = $item['test_id'];
// $path = public_path().'/TestFiles/'.$userId."/".$id;
$path = public_path() . '/TestFiles/' . $id;
//$main_path = public_path().'/TestFiles/'.$userId."/".$id;
// $half_path = public_path().'/TestFiles/'.$userId;
if (File::exists($path)) {
$uploaded_file = \Input::File('test_files');
if ($uploaded_file) {
$fileName = $uploaded_file->getClientOriginalName();
$uploaded_file->move($path, $fileName);
// read uploaded file //
Excel::load($path . '/' . $fileName, function ($reader) {
// Getting all results
$results = $reader->toArray();
});
}
//Session::flash('flash_type', 'alert-success');
//Session::flash('flash_message', 'File uploaded successfully.');
$files = File::allFiles($path);
if (!empty($files)) {
foreach ($files as $file) {
$documents[] = array('name' => $file->getfileName(), 'path' => $file->getpathName());
}
}
}
}
}
$items = DB::table('users')->select('id', 'name')->where('type', '=', 'laboratory')->get();
return view('lab/lab_detail')->with(compact('job', 'detail', 'documents', 'job_file', 'test_material', 'items'));
}
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index()
{
return Order::with('meals', 'status')->get();
}
/**
* Display the specified resource.
*
* @param int $id
* @return Response
*/
public function show($id)
{
return JsonResponse::create(Order::with('sweeties')->findOrFail($id));
}
public function pertanggalReturn(Request $request)
{
$tanggal = $request->get('tanggal') ? $request->get('tanggal') : date('Y-m-d');
$orders = Order::with('karyawan')->whereHas('detail', function ($query) {
$query->leftJoin('order_detail_returns', 'order_details.id', '=', 'order_detail_returns.order_detail_id')->whereNotNull('order_detail_returns.id');
})->where(DB::raw('SUBSTRING(tanggal, 1, 10)'), $tanggal)->get();
$data = ['tanggal' => Carbon::parse($tanggal), 'orders' => $orders];
return view(config('app.template') . '.order.return-pertanggal', $data);
}
/**
* Display the specified resource.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function show($id)
{
$order = Order::with('shares')->find($id);
return view('order.show', compact('order'));
}
/**
* Responds to requests to GET /books/edit/{$id}
*/
public function getEdit($id = null)
{
# Get this book and eager load its tags
/* $ordertreat = \App\Order::with('treat')->find($id);
$orderaccesory = \App\Order::with('accesory')->find($id); */
/* $order = \App\Order::where('user_id','=',\Auth::id())->orderBy('id','DESC')->get(); */
$order = \App\Order::with('accesory')->find($id);
if (is_null($order)) {
\Session::flash('flash_message', 'We are sorry, but your order was not found.');
return redirect('\\orders');
}
# Get all the possible accessories to display to the user
$accesoryModel = new \App\Accesory();
$accesories_for_checkbox = $accesoryModel->getAccesoriesForCheckboxes();
$accesories_for_inputbox = $accesoryModel->getAccesoriesForInputboxes();
$accesoryprices_for_display = $accesoryModel->getAccesoriesPrices();
# Get all the possible treats to display to the user
$treatModel = new \App\Treat();
$treats_for_checkbox = $treatModel->getTreatsForCheckboxes();
$treats_for_inputbox = $treatModel->getTreatsForInputboxes();
$treatprices_for_display = $treatModel->getTreatsPrices();
/*
Create a simple array of just the tag names for tags associated with this book;
will be used in the view to decide which tags should be checked off
*/
/* $accesories_for_this_order = [];
$accesoryquantities_for_this_order = [];
$accesoryprices_for_this_order = [];
$accesory =new \App\Accesory();
for($i=0; $i < count($accesories_for_checkbox); ++$i) {
$accesories_for_this_order[$i]=$accesory->name;
$accesoryquantities_for_this_order[$i]=$accesory->quantity;
$accesoryprices_for_this_order[$i]=$accesory->price;
} */
$accesories_for_this_order = [];
$accesoryquantities_for_this_order = [];
$accesoryprices_for_this_order = [];
foreach ($order->accesory as $accesory) {
$accesories_for_this_order[] = $accesory->name;
$accesoryquantities_for_this_order[] = $accesory->quantity;
$accesoryprices_for_this_order[] = $accesory->price;
}
$treats_for_this_order = [];
$treatquantities_for_this_order = [];
$treatprices_for_this_order = [];
foreach ($order->treat as $treat) {
$treats_for_this_order[] = $treat->name;
$treatquantities_for_this_order[] = $treat->quantity;
$treatprices_for_this_order[] = $treat->price;
}
/* for($i=0; $i < count($dataname); ++$i) {
$accesory = new \App\Accesory();
$accesory->name = $dataname[$i];
$accesory->size = $datasize[$i];
$accesory->price = $dataprice[$i];
$accesory->quantity = $dataquantity[$i];
$accesory->order_total = $dataquantity[$i] * $dataprice[$i];
$accesory->description = $datadescription[$i];
$accesory->save(); */
/*
$treats_for_this_order = [];
$treatquantities_for_this_order = [];
$treatprices_for_this_order = [];
foreach($ordertreat->treats as $treat) {
$treats_for_this_order[] = $treat->name;
$treatquantities_for_this_order[] = $treat->quantity;
$treatprices_for_this_order[] = $treat->price;
}
*/
/*$treats_for_this_order = [];
$treatquantities_for_this_order = [];
$treatprices_for_this_order = [];
$treat =new \App\Treat();
for($i=0; $i < count($treats_for_checkbox); ++$i) {
$treats_for_this_order[$i]=$treat->name;
$treatquantities_for_this_order[$i]=$treat->quantity;
$treatprices_for_this_order[$i]=$treat->price;
} */
return view('orders.edit')->with(['order' => $order, 'accesories_for_checkbox' => $accesories_for_checkbox, 'accesories_for_inputbox' => $accesories_for_inputbox, 'accesoryprices_for_display' => $accesoryprices_for_display, 'accesories_for_this_order' => $accesories_for_this_order, 'accesoryquantities_for_this_order' => $accesoryquantities_for_this_order, 'accesoryprices_for_this_order' => $accesoryprices_for_this_order, 'treats_for_checkbox' => $treats_for_checkbox, 'treats_for_inputbox' => $treats_for_inputbox, 'treats_for_display' => $accesoryprices_for_display, 'treats_for_this_order' => $treats_for_this_order, 'treatquantities_for_this_order' => $treatquantities_for_this_order, 'treatprices_for_this_order' => $treatprices_for_this_order]);
}
function order_reveiw($id)
{
if (!is_numeric($id)) {
return Response::view('errors.404', array(), 404);
}
$result = DB::table('orders')->where('id', '=', $id)->first();
if (is_null($result)) {
return Response::view('errors.404', array(), 404);
}
$order = Order::with(array('customer', 'site'))->where('orders.id', '=', $id)->first();
//$technicians = User::where('role_id','=',4)->where('status','=',1)->get();
//$tech_schedule = TechnicianSchedule::where('order_id','=',$id)->first();
$tech = DB::table('work_schedule.events')->join('work_schedule.calendars', 'work_schedule.events.calendar_id', '=', 'work_schedule.calendars.calendar_id')->leftjoin('raman.reporting_schedule', 'raman.reporting_schedule.order_id', '=', 'work_schedule.events.order_id')->leftjoin('raman.laboratory_schedule', 'raman.laboratory_schedule.order_id', '=', 'work_schedule.events.order_id')->where('work_schedule.events.order_id', '=', $id)->select('work_schedule.calendars.name', 'raman.reporting_schedule.start_date as rstart', 'raman.reporting_schedule.start_time as rstart_time', 'raman.laboratory_schedule.start_date as lstart', 'raman.laboratory_schedule.start_time as lstart_time')->first();
/*echo "<pre>";
print_r($tech);die;*/
return view('order_review')->with(compact('order', 'tech'));
}
public function edit()
{
//check for integer in quantity
if (!(Input::get('quantity') >= 0 && Input::get('quantity') < 1000)) {
Session::flash('type', "danger");
Session::flash('message', "Please enter a quantity between 1 and 1000");
return Redirect::back();
}
if (!Auth::check()) {
//create unregistered user and a new make for them
$user = new User();
$user->save();
Auth::login($user);
}
//save cookes for new user
if (!Session::has('order')) {
//create new order
$order = new Order();
$order->user_id = Auth::user()->id;
$order->status = 'Open';
$order->save();
Session::put('order', $order->id);
Session::put('orderCount', 0);
}
//return Session::has('order');
$quantity = Input::get('quantity');
$product_id = Input::get('product_id');
$colour_hex = Input::get('colour_hex');
$colour_name = Input::get('colour_name');
$action_id = Input::get('action_id');
$order = Order::with('product')->find(Session::get('order'));
//if order bnot open then send to dash with message
if ($order->status !== 'Quote' && $order->status !== 'Open') {
Session::flash('message', 'This order is locked. Please click \'Start a new quote\' below to begin another order');
Session::flash('alert-class', "alert-danger");
return Redirect::to('users/dashboard');
}
//return $order;
//derach product is the same as existing
//$order->product()->detach($product_id, ['hex' => $colour_hex]);
\DB::delete('delete from order_product where order_id = ? AND product_id = ? AND hex = ?', array($order->id, $product_id, $colour_hex));
//attach if not 0
if (Input::get('quantity') != 0) {
$order->product()->attach($product_id, ['quantity' => $quantity, 'colour' => $colour_name, 'hex' => $colour_hex]);
}
//count them again
$updatedOrder = Order::with('product')->find(Session::get('order'));
$orderCount = 0;
foreach ($updatedOrder->product as $products) {
$orderCount = $orderCount + 1;
}
//return $orderCount;
Session::put('orderCount', $orderCount);
//set message depending od whethet order is open or quote
if ($order->status !== 'Open') {
Session::flash('registerMessage', "You are updating an existing quote. When you are happy please click the green button below to confirm your update.");
Session::flash('type', "danger");
return redirect()->route('orders.show', [$order->id]);
}
//updating quantities
if ($action_id == 'update') {
return redirect()->route('orders.show', [$order->id]);
}
Session::flash('message', $quantity . " of these have been added to your quote");
Session::flash('type', "success");
return Redirect::back()->withCookie(cookie('user_id', Auth::user()->id, 3600));
//return $quantity;
}
public function edit($id)
{
$order = Order::with(['details', 'order_express'])->find($id);
if (empty($order)) {
return $this->failure_noexists();
}
$keys = 'expresses_money';
$this->_validates = $this->getScriptValidate('order.express', $keys);
$this->_data = $order;
return $this->view('admin.order.edit');
}
function getOrder($orderId)
{
if ($orderId) {
$order = Order::with('details')->where('id', '=', $orderId)->orderBy('id', 'DESC')->get();
if ($order) {
return $order;
}
}
}
public function bayar(Request $request)
{
if ($request->get('id')) {
$id = $request->get('id');
$order = Order::with(['karyawan', 'bayar.karyawan', 'tax.tax', 'bayarBank.bank', 'place.place', 'customer'])->find($id);
$total = $orderDetails = OrderDetail::with('order')->leftJoin('order_detail_returns', 'order_details.id', '=', 'order_detail_returns.order_detail_id')->join('produks', 'order_details.produk_id', '=', 'produks.id')->where('order_details.order_id', $id)->select(['order_details.id', 'order_details.produk_id', 'produks.nama', 'order_details.harga_jual', 'order_details.qty as qty_ori', DB::raw('ifnull(order_detail_returns.qty, 0) as qty_return'), DB::raw('(order_details.qty - ifnull(order_detail_returns.qty, 0))qty'), DB::raw('(order_details.harga_jual * (order_details.qty - ifnull(order_detail_returns.qty, 0)))subtotal')])->get()->sum('subtotal');
foreach ($order->place as $op) {
if ($op->harga > 0) {
$total += $op->harga;
}
}
$total += $order->bayar->service_cost;
$tax_procentage = round($order->tax->procentage);
$tax = round($total * ($tax_procentage / 100));
$tax_bayar_procentage = $order->bayarBank != null ? round($order->bayarBank->tax_procentage) : 0;
$tax_bayar = round(($total + $tax) * ($tax_bayar_procentage / 100));
$jumlah = round($total + $tax + $tax_bayar);
$sisa = round($jumlah - $order->bayar->diskon);
$kembali = round($order->bayar->bayar - $sisa);
return ['kasir' => $order->bayar->karyawan->nama, 'waiters' => $order->karyawan->nama, 'customer' => $order->customer != null ? $order->customer->nama : null, 'total' => number_format($total, 0, ",", "."), 'tax_pro' => $order->tax->procentage, 'tax' => number_format($tax, 0, ",", "."), 'tax_bayar_pro' => $tax_bayar_procentage, 'tax_bayar' => number_format($tax_bayar, 0, ",", "."), 'jumlah' => number_format($jumlah, 0, ",", "."), 'diskon' => number_format($order->bayar->diskon, 0, ",", "."), 'sisa' => number_format($sisa, 0, ",", "."), 'bayar' => number_format($order->bayar->bayar, 0, ",", "."), 'kembali' => number_format($kembali, 0, ",", ".")];
} else {
abort(500);
}
}
