<?php

session_start();
ob_start();


//global varable
global $showoutside;

//to check if the page from .htacess
//$showoutside = $_GET['sn'];
// get the config file
include_once("../public/config.php");

//here the db files that include in the file
include("../public/include_dao.php");
//Buybill
require_once('../models/dao/BuybillDAO.class.php');
require_once('../models/dto/Buybill.class.php');
require_once('../models/mysql/BuybillMySqlDAO.class.php');
require_once('../models/mysql/ext/BuybillMySqlExtDAO.class.php');
//Buybilldetail
require_once('../models/dao/BuybilldetailDAO.class.php');
require_once('../models/dto/Buybilldetail.class.php');
require_once('../models/mysql/BuybilldetailMySqlDAO.class.php');
require_once('../models/mysql/ext/BuybilldetailMySqlExtDAO.class.php');
//Returnbuybill
require_once('../models/dao/ReturnbuybillDAO.class.php');
require_once('../models/dto/Returnbuybill.class.php');
require_once('../models/mysql/ReturnbuybillMySqlDAO.class.php');
require_once('../models/mysql/ext/ReturnbuybillMySqlExtDAO.class.php');
//Returnbuybilldetail
require_once('../models/dao/ReturnbuybilldetailDAO.class.php');
require_once('../models/dto/Returnbuybilldetail.class.php');
require_once('../models/mysql/ReturnbuybilldetailMySqlDAO.class.php');
require_once('../models/mysql/ext/ReturnbuybilldetailMySqlExtDAO.class.php');
//Buyandruternbill
require_once('../models/dao/BuyandruternbillDAO.class.php');
require_once('../models/dto/Buyandruternbill.class.php');
require_once('../models/mysql/BuyandruternbillMySqlDAO.class.php');
require_once('../models/mysql/ext/BuyandruternbillMySqlExtDAO.class.php');
//Buyandruternbilldetail
require_once('../models/dao/BuyandruternbilldetailDAO.class.php');
require_once('../models/dto/Buyandruternbilldetail.class.php');
require_once('../models/mysql/BuyandruternbilldetailMySqlDAO.class.php');
require_once('../models/mysql/ext/BuyandruternbilldetailMySqlExtDAO.class.php');
//Product
require_once('../models/dao/ProductDAO.class.php');
require_once('../models/dto/Product.class.php');
require_once('../models/mysql/ProductMySqlDAO.class.php');
require_once('../models/mysql/ext/ProductMySqlExtDAO.class.php');
//Productcat
require_once('../models/dao/ProductcatDAO.class.php');
require_once('../models/dto/Productcat.class.php');
require_once('../models/mysql/ProductcatMySqlDAO.class.php');
require_once('../models/mysql/ext/ProductcatMySqlExtDAO.class.php');
//Supplier
require_once('../models/dao/SupplierDAO.class.php');
require_once('../models/dto/Supplier.class.php');
require_once('../models/mysql/SupplierMySqlDAO.class.php');
require_once('../models/mysql/ext/SupplierMySqlExtDAO.class.php');
//Supplierdebtchange
require_once('../models/dao/SupplierdebtchangeDAO.class.php');
require_once('../models/dto/Supplierdebtchange.class.php');
require_once('../models/mysql/SupplierdebtchangeMySqlDAO.class.php');
require_once('../models/mysql/ext/SupplierdebtchangeMySqlExtDAO.class.php');
//Store
require_once('../models/dao/StoreDAO.class.php');
require_once('../models/dto/Store.class.php');
require_once('../models/mysql/StoreMySqlDAO.class.php');
require_once('../models/mysql/ext/StoreMySqlExtDAO.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');
//Unit
require_once('../models/dao/UnitDAO.class.php');
require_once('../models/dto/Unit.class.php');
require_once('../models/mysql/UnitMySqlDAO.class.php');
require_once('../models/mysql/ext/UnitMySqlExtDAO.class.php');
//Billname
require_once('../models/dao/BillnameDAO.class.php');
require_once('../models/dto/Billname.class.php');
require_once('../models/mysql/BillnameMySqlDAO.class.php');
require_once('../models/mysql/ext/BillnameMySqlExtDAO.class.php');
//Billsetting
require_once('../models/dao/BillsettingsDAO.class.php');
require_once('../models/dto/Billsetting.class.php');
require_once('../models/mysql/BillsettingsMySqlDAO.class.php');
require_once('../models/mysql/ext/BillsettingsMySqlExtDAO.class.php');
//Storedetail
require_once('../models/dao/StoredetailDAO.class.php');
require_once('../models/dto/Storedetail.class.php');
require_once('../models/mysql/StoredetailMySqlDAO.class.php');
require_once('../models/mysql/ext/StoredetailMySqlExtDAO.class.php');
//Storereport
require_once('../models/dao/StorereportDAO.class.php');
require_once('../models/dto/Storereport.class.php');
require_once('../models/mysql/StorereportMySqlDAO.class.php');
require_once('../models/mysql/ext/StorereportMySqlExtDAO.class.php');
//Save
require_once('../models/dao/SaveDAO.class.php');
require_once('../models/dto/Save.class.php');
require_once('../models/mysql/SaveMySqlDAO.class.php');
require_once('../models/mysql/ext/SaveMySqlExtDAO.class.php');
//Savedaily
require_once('../models/dao/SavedailyDAO.class.php');
require_once('../models/dto/Savedaily.class.php');
require_once('../models/mysql/SavedailyMySqlDAO.class.php');
require_once('../models/mysql/ext/SavedailyMySqlExtDAO.class.php');
//Productserial
require_once('../models/dao/ProductserialDAO.class.php');
require_once('../models/dto/Productserial.class.php');
require_once('../models/mysql/ProductserialMySqlDAO.class.php');
require_once('../models/mysql/ext/ProductserialMySqlExtDAO.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');

//Productunit
require_once('../models/dao/ProductunitDAO.class.php');
require_once('../models/dto/Productunit.class.php');
require_once('../models/mysql/ProductunitMySqlDAO.class.php');
require_once('../models/mysql/ext/ProductunitMySqlExtDAO.class.php');



//Sellbilldetail
require_once('../models/dao/SellbilldetailDAO.class.php');
require_once('../models/dto/Sellbilldetail.class.php');
require_once('../models/mysql/SellbilldetailMySqlDAO.class.php');
require_once('../models/mysql/ext/SellbilldetailMySqlExtDAO.class.php');


//Returnsellbilldetail
require_once('../models/dao/ReturnsellbilldetailDAO.class.php');
require_once('../models/dto/Returnsellbilldetail.class.php');
require_once('../models/mysql/ReturnsellbilldetailMySqlDAO.class.php');
require_once('../models/mysql/ext/ReturnsellbilldetailMySqlExtDAO.class.php');

//Sellandruternbilldetail
require_once('../models/dao/SellandruternbilldetailDAO.class.php');
require_once('../models/dto/Sellandruternbilldetail.class.php');
require_once('../models/mysql/SellandruternbilldetailMySqlDAO.class.php');
require_once('../models/mysql/ext/SellandruternbilldetailMySqlExtDAO.class.php');

//Sellbill
require_once('../models/dao/SellbillDAO.class.php');
require_once('../models/dto/Sellbill.class.php');
require_once('../models/mysql/SellbillMySqlDAO.class.php');
require_once('../models/mysql/ext/SellbillMySqlExtDAO.class.php');

//Returnsellbill
require_once('../models/dao/ReturnsellbillDAO.class.php');
require_once('../models/dto/Returnsellbill.class.php');
require_once('../models/mysql/ReturnsellbillMySqlDAO.class.php');
require_once('../models/mysql/ext/ReturnsellbillMySqlExtDAO.class.php');

//Sellbillandrutern
require_once('../models/dao/SellbillandruternDAO.class.php');
require_once('../models/dto/Sellbillandrutern.class.php');
require_once('../models/mysql/SellbillandruternMySqlDAO.class.php');
require_once('../models/mysql/ext/SellbillandruternMySqlExtDAO.class.php');




//get the do the action
$do = $_GET['do'];

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

  Controller Name :- buyBillController

  OPERTATION in Controller

  1- add buy bill, buy And Return Bill and return buy bill
  2- show buy bill details
  3- show buy bills
  4- delete buy bill

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



//handling saveid session
/* if(!isset($_SESSION['saveid']))
  {
  $_SESSION['saveid'] = 1;
  }
 */

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

//here goes the instances and general variables
//Sellbill
$Sellbill = new Sellbill();
$SellbillDAO = new SellbillMySqlDAO();
$SellbillEX = new SellbillMySqlExtDAO();

//Returnsellbill
$Returnsellbill = new Returnsellbill();
$ReturnsellbillDAO = new ReturnsellbillMySqlDAO();
$ReturnsellbillEX = new ReturnsellbillMySqlExtDAO();

//Sellbillandrutern
$Sellbillandrutern = new Sellbillandrutern();
$SellbillandruternDAO = new SellbillandruternMySqlDAO();
$SellbillandruternEX = new SellbillandruternMySqlExtDAO();

//Sellbilldetail
$Sellbilldetail = new Sellbilldetail();
$SellbilldetailDAO = new SellbilldetailMySqlDAO();
$SellbilldetailEX = new SellbilldetailMySqlExtDAO();

//Returnsellbilldetail
$Returnsellbilldetail = new Returnsellbilldetail();
$ReturnsellbilldetailEX = new ReturnsellbilldetailMySqlExtDAO();
$ReturnsellbilldetailDAO = new ReturnsellbilldetailMySqlDAO();

//Sellandruternbilldetail
$Sellandruternbilldetail = new Sellandruternbilldetail();
$SellandruternbilldetailDAO = new SellandruternbilldetailMySqlDAO();
$SellandruternbilldetailEX = new SellandruternbilldetailMySqlExtDAO();

//Buybilldetail
$buyBillDetail = new Buybilldetail();
$buyBillDetailDAO = new BuybilldetailMySqlDAO();
$buyBillDetailExt = new BuybilldetailMySqlExtDAO();

//Returnbuybilldetail
$returnBuyBillDetail = new Returnbuybilldetail();
$returnBuyBillDetailDAO = new ReturnbuybilldetailMySqlDAO();
$returnBuyBillDetailExt = new ReturnbuybilldetailMySqlExtDAO();

//Buyandruternbilldetail
$buyAndReturnBillDetail = new Buyandruternbilldetail();
$buyAndReturnBillDetailDAO = new BuyandruternbilldetailMySqlDAO();
$buyAndReturnBillDetailExt = new BuyandruternbilldetailMySqlExtDAO();

//Productunit
$myProductunitEx = new ProductunitMySqlExtDAO();


//$userdata=$userDAO->load($_SESSION['userid']);
//$smarty->assign("userdata",$userdata);
//print_r($userdata);


$today = date("Y-m-d");
$smarty->assign("today", $today);

//check and use the condition that suite this action

$allselldetail = $SellbilldetailEX->queryAllnothavestor();
if (count($allselldetail) > 0) {

    foreach ($allselldetail as $myallselldetail) {
        $sellbillid = $myallselldetail->sellbillid;
        $sellbilldetailid = $myallselldetail->sellbilldetailid;
        $selldata = $SellbillDAO->load($sellbillid);
        $sellbillstoreid = $selldata->sellbillstoreid;

        $SellbilldetailEX->updatestoreid($sellbillstoreid, $sellbilldetailid);
    }
}



$allselldetail = $SellandruternbilldetailEX->queryAllnothavestor();
if (count($allselldetail) > 0) {

    foreach ($allselldetail as $myallselldetail) {
        $sellbillid = $myallselldetail->sellbillid;
        $sellbilldetailid = $myallselldetail->sellbilldetailid;
        $selldata = $SellbillDAO->load($sellbillid);
        $sellbillstoreid = $selldata->sellbillstoreid;

        $SellbilldetailEX->updatestoreid($sellbillstoreid, $sellbilldetailid);
    }
}




$allreturnselldetail = $ReturnsellbilldetailEX->queryAllnothavestor();
if (count($allreturnselldetail) > 0) {

    foreach ($allreturnselldetail as $myallreturnselldetail) {
        $returnsellbillid = $myallreturnselldetail->returnsellbillid;
        $returnsellbilldetailid = $myallreturnselldetail->returnsellbilldetailid;
        $returnselldata = $ReturnsellbillDAO->load($returnsellbillid);
        $returnsellbillstoreid = $returnselldata->returnsellbillstoreid;

        $ReturnsellbilldetailEX->updatestoreid($returnsellbillstoreid, $returnsellbilldetailid);
    }
}




$allselldata = $SellbilldetailEX->queryAllnothaveuintid();
foreach ($allselldata as $mysell) {

    $productid = $mysell->sellbilldetailproductid;
    //print_r($productid.'<br>');
    $sellbilldetailid = $mysell->sellbilldetailid;

    $myuintdata = $myProductunitEx->getfirstunitt($productid);
    $productunitid = $myuintdata->productunitid;

    $sellbilldetail->productunitid = $productunitid;
    $sellbilldetail->sellbilldetailid = $sellbilldetailid;
    if ($productunitid > 0 && $sellbilldetailid > 0) {
        $SellbilldetailEX->updateproductunit($productunitid, $sellbilldetailid);
    }
}




$allselldata = $ReturnsellbilldetailEX->queryAllnothaveuintid();
foreach ($allselldata as $mysell) {

    $productid = $mysell->returnsellbilldetailproductid;
    print_r($productid . '<br>');
    $returnsellbilldetailid = $mysell->returnsellbilldetailid;

    $myuintdata = $myProductunitEx->getfirstunitt($productid);
    $productunitid = $myuintdata->productunitid;

    if ($productunitid > 0 && $returnsellbilldetailid > 0) {
        $ReturnsellbilldetailEX->updateproductunit($productunitid, $returnsellbilldetailid);
    }
}




$allselldata = $SellandruternbilldetailEX->queryAllnothaveuintid();
foreach ($allselldata as $mysell) {

    $productid = $mysell->sellbilldetailproductid;
    //print_r($productid.'<br>');
    $sellbilldetailid = $mysell->sellbilldetailid;

    $myuintdata = $myProductunitEx->getfirstunitt($productid);
    $productunitid = $myuintdata->productunitid;

    if ($productunitid > 0 && $sellbilldetailid > 0) {
        $SellandruternbilldetailEX->updateproductunit($productunitid, $sellbilldetailid);
    }
}





$allbuybilldata = $buyBillDetailExt->queryAllnothaveuintid();
foreach ($allbuybilldata as $mybuy) {

    $productid = $mybuy->buybilldetailproductid;
    $buybilldetailid = $mybuy->buybilldetailid;
    //print_r($productid.'<br>');
    $myuintdata = $myProductunitEx->getfirstunitt($productid);
    $productunitid = $myuintdata->productunitid;

    $buyBillDetail->productunitid = $productunitid;
    $buyBillDetail->buybilldetailid = $buybilldetailid;

    if ($productunitid > 0 && $buybilldetailid > 0) {
        $buyBillDetailExt->updateproductunit($buyBillDetail);
    }
}





$allreturnbuybilldata = $returnBuyBillDetailExt->queryAllnothaveuintid();
foreach ($allreturnbuybilldata as $myreturnbuy) {

    $productid = $myreturnbuy->returnbuybilldetailproductid;
    $returnbuybilldetailid = $myreturnbuy->returnbuybilldetailid;
    $myuintdata = $myProductunitEx->getfirstunitt($productid);

    $productunitid = $myuintdata->productunitid;

    $returnBuyBillDetail->productunitid = $productunitid;
    $returnBuyBillDetail->returnbuybilldetailid = $returnbuybilldetailid;
    if ($productunitid > 0 && $returnbuybilldetailid > 0) {
        $returnBuyBillDetailExt->updateproductunit($returnBuyBillDetail);
    }
}



$allreturnandbuybilldata = $buyAndReturnBillDetailExt->queryAllnothaveuintid();
foreach ($allreturnandbuybilldata as $myreturnbuy) {

    $productid = $myreturnbuy->buybilldetailproductid;
    $buybilldetailid = $myreturnbuy->buybilldetailid;
    $myuintdata = $myProductunitEx->getfirstunitt($productid);

    $productunitid = $myuintdata->productunitid;

    $buyAndReturnBillDetail->productunitid = $productunitid;
    $buyAndReturnBillDetail->buybilldetailid = $buybilldetailid;
    if ($productunitid > 0 && $buybilldetailid > 0) {
        $buyAndReturnBillDetailExt->updateproductunit($buyAndReturnBillDetail);
    }
}
?>