public function changeOrderStatus($order_id, $data) { $menu_item_ids = array(); list($driver_id, $foodjets_meal_plan_id, $order_number, $customer_id, $coupon_id, $credit, $customer_new_credit) = $data; $isChanged = Order::where('id', '=', $order_id)->update(array('order_status' => 'Canceling', 'payment_status' => 'Refunded')); if ($isChanged) { $menu_items = OrderDetails::select('menu_item_id')->where('order_id', '=', $order_id)->get(); if (!empty($menu_items)) { foreach ($menu_items as $each) { array_push($menu_item_ids, $each->menu_item_id); } } ##reseting item quantity in order details table $todays_driver_list_id = $this->resetDriverItemQuantity($driver_id, $foodjets_meal_plan_id, $menu_item_ids, $order_id); ##end ##return credit or reset coupon used $this->returnCredit($order_number, $customer_id, $coupon_id, $credit, $customer_new_credit); ##end } return $todays_driver_list_id; }
protected function getOrderItemDetails($order_id) { $orderarray = array(); $result = OrderDetails::select('id', 'menu_item_id', 'menu_item_name', 'menu_item_description', 'unit_selling_price', 'item_discount', 'quantity', 'amount')->where('order_id', '=', $order_id)->get(); $i = 1; foreach ($result as $k => $v) { $orderarray[$k]['slno'] = $i; $orderarray[$k]['id'] = $v->id; $orderarray[$k]['menu_item_id'] = $v->menu_item_id; $orderarray[$k]['name'] = $v->menu_item_name; $orderarray[$k]['description'] = $v->menu_item_description; $orderarray[$k]['selling_price'] = "\$ " . $v->unit_selling_price; $orderarray[$k]['happy_hour_discount'] = $v->item_discount != "0" ? $v->item_discount : "-"; $orderarray[$k]['quantity'] = $v->quantity; $orderarray[$k]['amount'] = "\$ " . $v->amount; $orderarray[$k]['raw_amount'] = $v->amount; $i++; } return $orderarray; }