<?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>";

*/
$caseId='';
$caseTimeSheetId='';
$q= $_POST['TimeSheetId'];
$sql = array('table'=>$name_table28,'where'=>"TimeSheetId = '".$q."'");
$view = $view_db->view($sql);
$row = $view_db->q($view);



if(@$row['CaseId']!=''){

  $caseId='';$caseTimeSheetId='';
  $list = array(
    'table'=>$name_table9,
    'CaseTimeSheetId'=>$row['CaseTimeSheetId']
  );
  $data = $actiondata_db->delete($list);

  $list = array(
    'table'=>$name_table28,
    'TimeSheetId'=>@$q,
    'CaseId'=>@$caseId,
    'CaseTimeSheetId'=>@$caseTimeSheetId,
    'Del'=>'1',
    'UpdateBy'=>@$_SESSION["UserInfo"][0]['UserId'],
    'UpdateDateTime'=>@$date
  );
  $data = $actiondata_db->edit_db($list);

  if($data['suc']==1){

    $response = array(
      'Message' => 'success',
      'Id' => $row['TimeSheetId'],
    );
    echo json_encode($response, JSON_UNESCAPED_UNICODE);
  }else{
    $response = array(
      'Message' => 'false',
      'data' => @$data,
    );
    echo json_encode($response, JSON_UNESCAPED_UNICODE);
  }


}else{
  $response = array(
    'Message' => 'false',
    'r' => $row,
    'sql' => $view,
  );
  echo json_encode($response, JSON_UNESCAPED_UNICODE);
}






?>