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;
}
public function getDriverInventory($input)
{
$meal_plan_id = $input['meal_plan_id'];
$meal_list_id = $input['meal_list_id'];
$driver_id = $input['driver_id'];
$data = array();
$car_no = "";
$todayDriverLists = TodaysDriversInventory::select("todays_drivers_inventory.quantity", "todays_drivers_inventory.foodjets_menu_item_id", "todays_drivers_inventory.car_no")->join('todays_drivers_list', 'todays_drivers_list.id', '=', 'todays_drivers_inventory.todays_drivers_list_id')->where("todays_drivers_inventory.foodjets_meal_plan_id", $meal_plan_id)->where("todays_drivers_inventory.todays_drivers_list_id", $meal_list_id)->where("todays_drivers_list.drivers_id", $driver_id)->get();
$menu_item_ids = array();
foreach ($todayDriverLists as $key => $value) {
$menu_item_ids[] = $value['foodjets_menu_item_id'];
$data[$value['foodjets_menu_item_id']] = array("quantity" => $value['quantity']);
$car_no = $value['car_no'];
}
$menuItems = FoodjetsMenuItems::select("restaurant_menu_item.name", "restaurant_menu_item.image", "foodjets_menu_item.id")->join('restaurant_menu_item', 'restaurant_menu_item.id', '=', 'foodjets_menu_item.restaurant_menu_item_id')->whereIn("foodjets_menu_item.id", $menu_item_ids)->get();
$i = 1;
foreach ($menuItems as $value) {
if ($value['image'] != "" && $value['image'] != null) {
$image = Config::get('images.foodpics') . $value['image'];
} else {
$image = "/images/no-image.png";
}
$data[$value['id']]['slno'] = $i;
$data[$value['id']]['name'] = $value['name'];
$data[$value['id']]['image'] = $image;
$i++;
}
return array("items" => $data, "car_no" => $car_no);
}
