public function insertOrderDetails($jsondata = NULL, $lastOrderId = NULL) { #adding data in order details table $orderDetails = array(); foreach ($jsondata as $key => $each) { $res_menu_item_id = 0; $restaurant_menu_item_data = FoodjetsMenuItems::select('restaurant_menu_item_id')->where('id', '=', $each['food_id'])->first(); $res_menu_item_id = $restaurant_menu_item_data->restaurant_menu_item_id; $getRestaurantMenuItemData = RestaurantMenuItem::select('name', 'description', 'selling_price')->where('id', '=', $res_menu_item_id)->first(); $orderDetails[$key]['order_id'] = $lastOrderId; $orderDetails[$key]['menu_item_id'] = $each['food_id']; $orderDetails[$key]['menu_item_name'] = $getRestaurantMenuItemData->name; $orderDetails[$key]['menu_item_description'] = $getRestaurantMenuItemData->description; $orderDetails[$key]['unit_selling_price'] = $getRestaurantMenuItemData->selling_price; if (isset($each['happy_hour_discount'])) { $orderDetails[$key]['item_discount'] = $each['happy_hour_discount']; } else { $orderDetails[$key]['item_discount'] = "0"; } $orderDetails[$key]['quantity'] = $each['food_qty']; if (isset($each['happy_hour_discount'])) { if (strpos($each['happy_hour_discount'], '%') !== false) { $orderDetails[$key]['amount'] = number_format($each['food_qty'] * ($getRestaurantMenuItemData->selling_price - $getRestaurantMenuItemData->selling_price * $each['happy_hour_discount'] / 100), 2); } else { $orderDetails[$key]['amount'] = number_format($each['food_qty'] * ($getRestaurantMenuItemData->selling_price - $each['happy_hour_discount']), 2); } } else { $orderDetails[$key]['amount'] = number_format($each['food_qty'] * $getRestaurantMenuItemData->selling_price, 2); } $orderDetails[$key]['date'] = date('Y-m-d'); } OrderDetails::insert($orderDetails); return $orderDetails; }
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; }