<?php

//the global file operation
include("../public/impOpreation.php");

// get the config file
include_once("../public/config.php");

//here the db files that include in the file
include("../public/include_dao.php");

//Restauranthall
require_once('../models/dao/RestauranthallDAO.class.php');
require_once('../models/dto/Restauranthall.class.php');
require_once('../models/mysql/RestauranthallMySqlDAO.class.php');
require_once('../models/mysql/ext/RestauranthallMySqlExtDAO.class.php');
//Restauranttable
require_once('../models/dao/RestauranttableDAO.class.php');
require_once('../models/dto/Restauranttable.class.php');
require_once('../models/mysql/RestauranttableMySqlDAO.class.php');
require_once('../models/mysql/ext/RestauranttableMySqlExtDAO.class.php');
//Restaurantorder
require_once('../models/dao/RestaurantorderDAO.class.php');
require_once('../models/dto/Restaurantorder.class.php');
require_once('../models/mysql/RestaurantorderMySqlDAO.class.php');
require_once('../models/mysql/ext/RestaurantorderMySqlExtDAO.class.php');
//Restaurantorderdetail
require_once('../models/dao/RestaurantorderdetailsDAO.class.php');
require_once('../models/dto/Restaurantorderdetail.class.php');
require_once('../models/mysql/RestaurantorderdetailsMySqlDAO.class.php');
require_once('../models/mysql/ext/RestaurantorderdetailsMySqlExtDAO.class.php');
////Programsetting
//require_once('../models/dao/ProgramsettingsDAO.class.php');
//require_once('../models/dto/Programsetting.class.php');
//require_once('../models/mysql/ProgramsettingsMySqlDAO.class.php');
//require_once('../models/mysql/ext/ProgramsettingsMySqlExtDAO.class.php');
//User
require_once('../models/dao/UserDAO.class.php');
require_once('../models/dto/User.class.php');
require_once('../models/mysql/UserMySqlDAO.class.php');
require_once('../models/mysql/ext/UserMySqlExtDAO.class.php');


require_once('../models/dao/YoutubeLinkDAO.class.php');
require_once('../models/dto/YoutubeLink.class.php');
require_once('../models/mysql/YoutubeLinkMySqlDAO.class.php');
require_once('../models/mysql/ext/YoutubeLinkMySqlExtDAO.class.php');

$do = $_GET['do'];

/* ======================

  Controller Name :- storedetailCTRL تقرير مخزون اول مدة

  OPERTATION in Controller

  1-load save data
  2-display show form

  ======================== */

//here the global templates


//here goes the instances and general variables
//Restauranthall
$restaurantHall = new Restauranthall();
$restaurantHallDAO = new RestauranthallMySqlDAO();
$restaurantHallEX = new RestauranthallMySqlExtDAO();
//Restauranttable
$restaurantTable = new Restauranttable();
$restaurantTableDAO = new RestauranttableMySqlDAO();
$restaurantTableEX = new RestauranttableMySqlExtDAO();
//Restaurantorder
$restaurantOrder = new Restaurantorder();
$restaurantOrderDAO = new RestaurantorderMySqlDAO();
$restaurantOrderEX = new RestaurantorderMySqlExtDAO();
//Restaurantorderdeliverydetail
$restaurantOrderDeliveryDetail = new Restaurantorderdeliverydetail();
$restaurantOrderDeliveryDetailDAO = new RestaurantorderdeliverydetailsMySqlDAO();
$restaurantOrderDeliveryDetailEX = new RestaurantorderdeliverydetailsMySqlExtDAO();
//Restaurantorderdetail
$restaurantOrderDetails = new Restaurantorderdetail();
$restaurantOrderDetailsDAO = new RestaurantorderdetailsMySqlDAO();
$restaurantOrderDetailsEX = new RestaurantorderdetailsMySqlExtDAO();
$ProgramsettingDAO = new ProgramsettingsMySqlDAO();

$youtubeLink = new YoutubeLink();
$youtubeLinkDAO = new YoutubeLinkMySqlDAO();
$youtubeLinkEX = new YoutubeLinkMySqlExtDAO();
//
//User
$user = new User();
$userDAO = new UserMySqlDAO();
$userEX = new UserMySqlExtDAO();
//$myUserGroupRecord = new UsergroupMySqlDAO();
//$userGroupId = $_SESSION['usergroupid'];
//$loadData = $myUserGroupRecord->load($userGroupId);
//$smarty->assign("loadData", $loadData);
//check and use the condition that suite this action
if (empty($do) || $do == "show") {
    //here the permission check
    //include_once("../public/authentication.php");
    //السائقين
    $drivers = $userEX->queryWithGroupName("سائقين");
    $smarty->assign("drivers", $drivers);
    //search
    $driver = (int) filter_input(INPUT_POST, 'driver');
    $datefrom = filter_input(INPUT_POST, 'datefrom');
    $dateto = filter_input(INPUT_POST, 'dateto');
    if ($driver > 0) {
        $queryString = " where 1 ";
        if (empty($datefrom) && empty($dateto) && empty($sellBillId) && empty($orderId)) {
            $Programsetting = $ProgramsettingDAO->load(1);
            $datefrom = $dateto = date('Y-m-d');
            if (isset($Programsetting->reportsPlusHours) && !empty($Programsetting->reportsPlusHours)) {
                $reportsPlusHours = $Programsetting->reportsPlusHours + 24; //24 to get the end of the day and add search hours to it
                $dateto = date('Y-m-d H:i:s', strtotime('+' . $reportsPlusHours . ' hour +0 minutes', strtotime($dateto)));
                $datefrom = date('Y-m-d H:i:s', strtotime('+' . $Programsetting->reportsPlusHours . ' hour +0 minutes', strtotime($datefrom)));
            } else {
                $dateto = $dateto . ' 23:59:59';
                $datefrom = $datefrom . " 00:00:00";
            }
        }
        ##date
        if (isset($datefrom) && !empty($datefrom)) {
            $queryString .= 'and  restaurantorderdeliverydetails.driverReciveDate  >= "' . $datefrom . '" '; //restaurantorder.sysdate
        }
        if (isset($dateto) && !empty($dateto)) {
            $queryString .= 'and  restaurantorderdeliverydetails.driverReciveDate  <= "' . $dateto . '" '; //restaurantorder.sysdate
        }
        if (isset($driver) && !empty($driver)) {
            $queryString .= 'and  restaurantorderdeliverydetails.driverId  = ' . $driver . ' ';
        }
        $queryString .=' and restaurantorder.tableId =-2';
        $ordersData = $restaurantOrderEX->queryOrdersQueryStringNoHallNoTable($queryString);
        $smarty->assign("ordersData", $ordersData);
    }

    $youtubes = $youtubeLinkDAO->queryAll();
    $smarty->assign("youtubes", $youtubes);

    //here the smarty templates
    $smarty->display("header.html");
    $smarty->display("orderdeliveryreport/show.html");
    $smarty->display("footer.html");

    //$smarty->assign("ordersreport", 1);
}else if($do == "print"){
    $id = $_GET['id'];
    $datefrom = $_GET['datefrom'];
    $dateto = $_GET['dateto'];
    $smarty->assign("datefrom", $datefrom);
    $smarty->assign("dateto", $dateto);
    $queryString = '';
    if (isset($datefrom) && !empty($datefrom)) {
            $queryString .= ' and  restaurantorderdeliverydetails.driverReciveDate  >= "' . $datefrom . '" '; 
    }
    if (isset($dateto) && !empty($dateto)) {
        $queryString .= ' and  restaurantorderdeliverydetails.driverReciveDate  <= "' . $dateto . '" '; //restaurantorder.sysdate
    }
    $programsettings = R::getRow("SELECT programsettings.* FROM `programsettings` WHERE 1");
    $smarty->assign("programsettings", $programsettings);
    $userdata = R::getRow("SELECT user.* FROM `user` WHERE userid = $id");
    $smarty->assign("userdata", $userdata);
    $countorder = R::count("restaurantorderdeliverydetails","driverId = $id $queryString ");
    $smarty->assign("countorder", $countorder);
    $totals = R::getRow("SELECT sum(totalBill) as totalBills, sum(tax) as taxs,
        sum(netBill) as netBills FROM `restaurantorderdeliverydetails` left join restaurantorder ON restaurantorderdeliverydetails.orderId = restaurantorder.id   WHERE driverId = $id $queryString ");
    $smarty->assign("totals", $totals);


    $smarty->display("orderdeliveryreport/print.html");
}
//here the global templates

/* ===============================
  function in this CONTROLLER
  ================================ */
?>