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