<?php
$ck='not';
include("../include/checkLogin.php");
include("../include/class.php");
include("../include/table_name.php");
$date_year = date("Y");
$date_month = date("m");


/*
echo "<pre>";
print_r($_POST);
echo "</pre>";
exit();
*/
$sql2 = array('table'=>$name_table27,'where'=>"TaxInvoiceId = '".@$row['Id']."'");
$view2 = $view_db->view($sql2);
$row2 = $view_db->q($view2);
$oldStatus = $row2['Status'];
$CreateDateTime = $util_class->date_chang_1_2($_POST['CreateDateTime']);

$list = array(
  'table'=>$name_table27,
  'TaxInvoiceId'=>@$_POST["Id"],
  'TaxInvoiceNo'=>@$_POST["TaxInvoiceNo"],
  'Status'=>@$_POST["Status"],
  'NotiEmail'=>@$_POST["NotiEmail"],
  'ResponseId'=>@$_POST["ResponseId"],
  'UpdateBy'=>@$_SESSION['UserInfo'][0]["UserId"],
  'UpdateDateTime'=>@$CreateDateTime,
);
$data = $actiondata_db->edit_db($list);

$d_t = $data['suc'];
if(@$_POST["Status"]==2){
  $list = array(
    'table'=>'ct_invoice',
    'InvoiceId'=>@$_POST["InvoiceId"],
    'Status'=>@$_POST["Status"],
    'UpdateBy'=>@$_SESSION['UserInfo'][0]["UserId"],
    'UpdateDateTime'=>@$date,
  );
  $data = $actiondata_db->edit_db($list);
}


if(@$oldStatus == 1 && @$_POST["Status"]==2){
    $sql = array('table'=>'ct_invoice_item','where'=>'InvoiceId = "'.@$_POST["InvoiceId"].'"');
    $view = $view_db->view($sql);
    $result = $view_db->q_re($view);

    while ($row = $view_db->q_ro($result)) {
      if(@$row['QuotationPaymentTermId']!=''){
        $list = array(
          'table'=>'ct_quotation_payment_terms',
          'QuotationPaymentTermId'=>@$row['QuotationPaymentTermId'],
          'Status'=>'3'
        );
        $data = $actiondata_db->edit_db($list);
      }
    }
}

if(@$oldStatus == 2 && @$_POST["Status"]==1){
    $sql = array('table'=>'ct_invoice_item','where'=>'InvoiceId = "'.@$_POST["InvoiceId"].'"');
    $view = $view_db->view($sql);
    $result = $view_db->q_re($view);

    while ($row = $this->q_ro($result)) {
      if(@$row['QuotationPaymentTermId']!=''){
        $list = array(
          'table'=>'ct_quotation_payment_terms',
          'QuotationPaymentTermId'=>@$row['QuotationPaymentTermId'],
          'Status'=>'1'
        );
        $data = $actiondata_db->edit_db($list);
      }
    }
}

if(@$d_t==1){
  $_SESSION['Success']='Update successful';
  echo "<script>window.location.href='Edit.php?Type=Edit&Id=$_POST[Id]'</script>";

}else{
  $_SESSION['Error']='false';
  echo "<script>window.location.href='Edit.php?Type=Edit&Id=$_POST[Id]'</script>";
}


?>