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

print_r($_SESSION);
print_r($_FILES['File']);
print_r($_POST);


echo json_encode($_POST, JSON_UNESCAPED_UNICODE);
exit();
*/

$userId = @$_POST["userId"];
if($userId == ""){
  $response = array(
    'Message' => 'Error UserId',
  );
  echo json_encode($response, JSON_UNESCAPED_UNICODE);
}else{
  $timesheetdate = $util_class->date_chang_1_2($_POST["TaskDate"]);//in:07/06/2023  //out: 2023-06-07
  $timesheetdate2 = $util_class->date_chang_1($_POST["TaskDate"]);//in:07/06/2023  //out: 2023-06-07 05:24:40

  $TaskDescription = str_replace("'", "’", @$_POST["TaskDescription"]);
  $caseTimeSheetId = 0;
  $caseId = 0;
  $categoryId = 0;
  if(@$_POST["CaseNumber"]!=''){
    $sql_casenumber = array('table'=>'ct_case','where'=>"CaseNumber = '".$_POST['CaseNumber']."'");
    $view_casenumber = $view_db->view($sql_casenumber);
    $result_casenumber = $view_db->q_re($view_casenumber);
    $num_casenumber = $view_db->q_nr($result_casenumber);
    if(@$num_casenumber ==0){
      $response = array(
        'Message' => 'CaseNumber is incorrect.',
        'sql_view_casenumber' => $view_casenumber,
      );
      //echo json_encode($response, JSON_UNESCAPED_UNICODE);

    }

    $sql_ctCase = array('table'=>'ct_case','where'=>"CaseNumber = '".$_POST['CaseNumber']."'");
    $view_ctCase = $view_db->view($sql_ctCase);
    $result_ctCase = $view_db->q_re($view_ctCase);
    $num_ctCase = $view_db->q_nr($result_ctCase);
    if($num_ctCase>0){
      $row_ctCase = $view_db->q($view_ctCase);
      $caseId = $row_ctCase['CaseId'];
      $customerId = $row_ctCase['CustomerId'];
    }

  }
  elseif(@$_POST["CustomerCode"] != '') {

    $sql_nameMas = array('table'=>'t_names_mas','where'=>"NamesCode = '".$_POST['CustomerCode']."'");
    $view_nameMas = $view_db->view($sql_nameMas);
    $result_nameMas = $view_db->q_re($view_nameMas);
    $num_nameMas = $view_db->q_nr($result_nameMas);

    if(@$num_nameMas < 1){
      $response = array(
        'Message' => 'CustomerCode is incorrect.',
      );
      //echo json_encode($response, JSON_UNESCAPED_UNICODE);

    }
    $sql_customer = array('table'=>'t_names_mas','where'=>"NamesCode = '".$_POST['CustomerCode']."'");
    $view_customer = $view_db->view($sql_customer);
    $row_customer = $view_db->q($view_customer);
    $customerId = $row_customer['NamesId'];

    $sql_caseTimeSheetId = array('table'=>$name_table9,'count'=>'MAX(CaseTimeSheetId) AS caseTimeSheetId');
    $view_caseTimeSheetId = $view_db->view($sql_caseTimeSheetId);
    $row_caseTimeSheetId = $view_db->q($view_caseTimeSheetId);
    $caseTimeSheetId = $row_caseTimeSheetId['caseTimeSheetId'];
  }

  if(@$_POST["CategoryId"] != ''){
    $sql_cate = array('table'=>'ct_category_timesheet','where'=>"CategoryId = '".$_POST['CategoryId']."'");
    $view_cate = $view_db->view($sql_cate);
    $result_cate = $view_db->q_re($view_cate);
    $num_cate = $view_db->q_nr($result_cate);

    if(@$num_cate < 1){
      $response = array(
        'Message' => 'Category is incorrect.',
      );
      //echo json_encode($response, JSON_UNESCAPED_UNICODE);

    }
    if($num_cate>0){
      $row_cate = $view_db->q($view_cate);
      $categoryId = $row_cate['CategoryId'];
    }
  }
  

  $list = array(
  'table'=>$name_table9,
  'TaskDate'=>"'".@$timesheetdate."'",
  'TaskDescription'=>"'".@$TaskDescription."'",
  'Duration'=>"'".@$_POST["Duration"]."'",
  'CaseId'=>"'".@$caseId."'",
  'CategoryId'=>"'".@$categoryId."'",
  'CreateBy'=>"'".@$userId."'",
  'CreateDateTime'=>"'".@$date."'"
  );

  $data = $actiondata_db->add_db($list);

  $sql_caseTimeSheetId = array('table'=>$name_table9,'count'=>'MAX(CaseTimeSheetId) AS caseTimeSheetId');
  $view_caseTimeSheetId = $view_db->view($sql_caseTimeSheetId);
  $row_caseTimeSheetId = $view_db->q($view_caseTimeSheetId);
  $caseTimeSheetId = $row_caseTimeSheetId['caseTimeSheetId'];


  //$name_table28 = ct_timesheet
  $list2 = array(
  'table'=>$name_table28,
  'CaseTimeSheetId'=>"'".@$caseTimeSheetId."'",
  'TaskDate'=>"'".@$timesheetdate2."'",
  'TaskDescription'=>"'".@$TaskDescription."'",
  'Duration'=>"'".@$_POST["Duration"]."'",
  'CaseId'=>"'".@$caseId."'",
  'CategoryId'=>"'".@$categoryId."'",
  'CustomerId'=>"'".@$customerId."'",
  'CreateBy'=>"'".@$userId."'",
  'CreateDateTime'=>"'".@$date."'"

  );
  $data2 = $actiondata_db->add_db($list2);


  if(@$customerId!=''){
    $sql_nameMas = array('table'=>'t_names_mas','where'=>"NamesId = '".$customerId."'");
    $view_nameMas = $view_db->view($sql_nameMas);
    $row_nameMas = $view_db->q($view_nameMas);
    $customerCode = @$row_nameMas['NamesCode'];
    $customerName = @$row_nameMas['NamesCode'] . " ".@$row_nameMas['NamesName'];
  }

  if(@$categoryId!=''){
    $sql_cate = array('table'=>'ct_category_timesheet','where'=>"CategoryId = '".$categoryId."'");
    $view_cate = $view_db->view($sql_cate);
    $row_cate = $view_db->q($view_cate);
    $categoryId = @$row_cate['CategoryId'];
    $categoryName = @$row_cate['CategoryName'];
  }


  $sql_TimeSheetId = array('table'=>$name_table28,'count'=>'MAX(TimeSheetId) AS TimeSheetId');
  $view_TimeSheetId = $view_db->view($sql_TimeSheetId);
  $row_TimeSheetId = $view_db->q($view_TimeSheetId);
  $TimeSheetId = $row_TimeSheetId['TimeSheetId'];

  if($data2['suc']==1){
    $response = array(
    'Message' => 'success',
    'Id' => $TimeSheetId,
    'CaseNumber' => $_POST['CaseNumber'],
    'CustomerCode' => $customerCode,
    'CustomerName' => $customerName,
    'CategoryId' => $categoryId,
    'Category' => $categoryName,
    'TaskDate' => $timesheetdate,
    'CaseTimeSheetId' => $caseTimeSheetId,
    'data1' => @$data,
    'data2' => @$data2,
    );
    echo json_encode($response, JSON_UNESCAPED_UNICODE);
  }else{
    $response = array(
    'Message' => 'false',
    );
    echo json_encode($response, JSON_UNESCAPED_UNICODE);
  }

}


?>