<?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($_SESSION);
echo "</pre>";
echo "<pre>";
print_r($_FILES['File']);
echo "</pre>";
echo "<pre>";
print_r($_POST);
echo "</pre>";
echo "<pre>";
print_r($_GET);
echo "</pre>";
*/

$CaseId = $_GET['id'];
$QuotationId = $_POST['QuotationId'];

//$name_table2 = 'ct_case';
//$name_table8 = 'ct_case_quotation';
$sql_case = array('table'=>$name_table2,'where'=>"CaseId = '".@$CaseId."'");
$view_sql_case = $view_db->view($sql_case);
$require_case = $view_db->q_re($view_sql_case);
$num_require_case = $view_db->q_nr($require_case);

if($num_require_case>0){
  $row_case = $view_db->q($view_sql_case);
  $null = "";
  if($row_case['QuotationId']==$QuotationId){
    $list = array(
      'table'=>$name_table2,
      'CaseId'=>@$CaseId,
      'QuotationId'=>@$null,
      'UpdateBy'=>@$_SESSION["UserInfo"][0]['UserId'],
      'UpdateDateTime'=>@$date
    );
    $data = $actiondata_db->edit_db($list);
  }else{
    $list = array(
      'table'=>$name_table8,
      'CaseId'=>$CaseId."' AND QuotationId = '".$QuotationId
    );

    $data = $actiondata_db->delete($list);
  }
}

if($data['suc']==1){
  $message = array(
    'mes' => 'Successful',
    'data'=> $data
  );
  echo json_encode($message ,JSON_UNESCAPED_UNICODE);
}else{
  $message = array(
    'mes' => 'False',    
    'data'=> $data
  );
  echo json_encode($message ,JSON_UNESCAPED_UNICODE);
}

 ?>