<?php

//the global file operation
session_start();
ob_start();
//global varable
global $showoutside;
include_once("dailyentryfun.php");

//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");


//GovernArea
require_once('../models/dao/GoverareaDAO.class.php');
require_once('../models/dto/Goverarea.class.php');
require_once('../models/mysql/GoverareaMySqlDAO.class.php');
require_once('../models/mysql/ext/GoverareaMySqlExtDAO.class.php');

require_once('../models/dao/ClientareaDAO.class.php');
require_once('../models/dto/Clientarea.class.php');
require_once('../models/mysql/ClientareaMySqlDAO.class.php');
require_once('../models/mysql/ext/ClientareaMySqlExtDAO.class.php');

//Government
require_once('../models/dao/GovernmentDAO.class.php');
require_once('../models/dto/Government.class.php');
require_once('../models/mysql/GovernmentMySqlDAO.class.php');
require_once('../models/mysql/ext/GovernmentMySqlExtDAO.class.php');

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

  Controller Name :- productController

  OPERTATION in Controller

  1- display add form, add supplier cat and supplier with ajax
  2- add in supplier tbl
  2.1- insert into supplier unit tbl
  2.2- insert into storedetail tbl
  2.3- insert new row into storereport tbl
  3- display show and tempdelete
  4- edit supplier
  5- update supplier
  5.1- update supplier tbl with supplierid
  5.2- delete supplier units associated to this supplier from productunit tbl, then insert it again

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

//here goes the instances and general variables
//Clientarea
$Clientarea = new Clientarea();
$ClientareaDAO = new ClientareaMySqlDAO();
$ClientareaEX = new ClientareaMySqlExtDAO();


// GovernArea
$governArea = new Goverarea();
$governAreaDAO = new GoverareaMySqlDAO();
$governAreaExt = new GoverareaMySqlExtDAO();

// Government
$government = new Government();
$governmentDAO = new GovernmentMySqlDAO();
$governmentExt = new GovernmentMySqlExtDAO();

//check and use the condition that suite this action
if ($do == "add") {

    $dataContent = add();
    echo $dataContent;
}
##
elseif ($do == 'check') {
       $clientareaid = $_POST['newArea'];
    $oldGovernmentId = $_POST['oldGovernmentId'];
    $governmentname = $_POST['governmentname'];
    $area_itration = $_POST['area_itration'];

    $area_arr = array();
    if ($oldGovernmentId) {
        $governmentData = $governmentExt->queryByGovernmentnames($governmentname, $oldGovernmentId);
    }else{
         $governmentData = $governmentDAO->queryByGovernmentname($governmentname);
    }
    if (!empty($governmentData)) {
        echo ' تم ادخال محافظة ' . $governmentname . ' من قبل';
        return;
    }
   

    for ($i = 0; $i <= $area_itration; $i++) {
        $clientareaData = $governAreaDAO->queryByClientareaid($_POST['areaid_' . $i . '']);
        $areaData1 = $ClientareaDAO->load($_POST['areaid_' . $i . '']);

        if ($clientareaData[0]->governmentid != $oldGovernmentId && !empty($clientareaData)) {
            $areaData2 = $ClientareaDAO->load($clientareaData[0]->clientareaid);

            echo 'تم اختيار شركة ' . $areaData2->name . ' من قبل مع محافظة اخرى';
            return;
        } else if (in_array($_POST['areaid_' . $i . ''], $area_arr)) {

            echo 'تم اختيار شركة ' . $areaData1->name . ' مع هذه المحافظة من قبل';
            return;
        }
        array_push($area_arr, $_POST['areaid_' . $i . '']);
    }

    echo 0;
}
##
elseif ($do == 'checkAdd') {
    $clientareaid = $_POST['newArea'];
    $area_itration = $_POST['area_itration'];
    $governmentname = $_POST['governmentname'];
    $area_arr = array();

    $governmentData = $governmentDAO->queryByGovernmentname($governmentname);
    if (!empty($governmentData)) {
        echo ' تم ادخال محافظة ' . $governmentname . ' من قبل';
        return;
    }
    for ($i = 0; $i <= $area_itration; $i++) {
        $clientareaData = $governAreaDAO->queryByClientareaid($_POST['areaid_' . $i . '']);
        $areaData1 = $ClientareaDAO->load($_POST['areaid_' . $i . '']);
        $areaData2 = $ClientareaDAO->load($clientareaData[0]->clientareaid);

        if (!empty($areaData2)) {

            echo 'تم اختيار شركة ' . $areaData2->name . ' من قبل مع محافظة اخرى';
            return;
        } else if (in_array($_POST['areaid_' . $i . ''], $area_arr)) {

            echo 'تم اختيار شركة ' . $areaData1->name . ' مع هذه المحافظة من قبل';
            return;
        }
        array_push($area_arr, $_POST['areaid_' . $i . '']);
    }

    echo 0;
}
##
elseif ($do == "getgovarea") {
    $govid = filter_input(INPUT_POST, "govid");
    $govarea = $governAreaDAO->queryByGovernmentid($govid);
    $data = '<option></option>';
    foreach ($govarea as $value) {
        $area = $ClientareaDAO->load($value->clientareaid);
        $data .= '<option value="' . $area->id . '">' . $area->name . '</option>';
    }
    echo $data;
}


/* ===============================
  function in this CONTROLLER
  ================================ */

function add() {
    global $Clientarea;
    global $ClientareaDAO;
    $flag = 0;
    $dataContent = '';
    $newclientArea = filter_input(INPUT_POST, 'newclientArea');
    $clientAreaDiscription = filter_input(INPUT_POST, 'clientAreaDiscription');

    try {
        $Clientarea->name = $newclientArea;
        $Clientarea->comment = $clientAreaDiscription;
        $clientareaId = $ClientareaDAO->insert($Clientarea);

        $flag = 1;
        $dataContent = $clientareaId;
    } catch (Exception $ex) {

    }

    return $dataContent;
}

?>