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

exit();
*/
//$timesheetdate = explode("/",@$_POST["TaskDate"]);
$timesheetdate = $util_class->date_chang_1($_POST["TaskDate"]);
$TaskDescription = str_replace("'", "’", @$_POST["TaskDescription"]);

$sql_ts = array('table'=>$name_table9,'where'=>"CaseTimeSheetId = '".@$_GET["Id"]."'");
$view_sql_ts = $view_db->view($sql_ts);
$row_ts = $view_db->q($view_sql_ts);
$CreateBy = $row_ts['CreateBy'];

if($CreateBy==0){
  $sql_ts2 = array('table'=>$name_table28,'where'=>"TimeSheetId = '".@$_GET["Id"]."'");
  $view_sql_ts2 = $view_db->view($sql_ts2);
  $row_ts2 = $view_db->q($view_sql_ts2);
  $CreateBy2 = $row_ts2['CreateBy'];
  $CreateBy2;
  if($CreateBy2==0){
    $list_s = array(
      'table'=>$name_table9,
      'CaseTimeSheetId'=>@$_GET["Id"],
      'CreateBy'=>@$_SESSION["UserInfo"][0]['UserId'],
    );
    $data = $actiondata_db->edit_db($list_s);
    $list_s = array(
      'table'=>$name_table28,
      'TimeSheetId'=>@$_GET["Id"],
      'CreateBy'=>@$_SESSION["UserInfo"][0]['UserId'],
    );
    $data = $actiondata_db->edit_db($list_s);
  }else{
    $list_s = array(
      'table'=>$name_table9,
      'CaseTimeSheetId'=>@$_GET["Id"],
      'CreateBy'=>@$CreateBy2,
    );
    $data = $actiondata_db->edit_db($list_s);
  }
}else {
  $sql_ts2 = array('table'=>$name_table28,'where'=>"TimeSheetId = '".@$_GET["Id"]."'");
  $view_sql_ts2 = $view_db->view($sql_ts2);
  $row_ts2 = $view_db->q($view_sql_ts2);
  $CreateBy2 = $row_ts2['CreateBy'];
  if($CreateBy2==0){
    $list_s = array(
      'table'=>$name_table28,
      'TimeSheetId'=>@$_GET["Id"],
      'CreateBy'=>$CreateBy,
    );
    $data = $actiondata_db->edit_db($list_s);
  }

}

$list = array(
  'table'=>$name_table9,
  'CaseTimeSheetId'=>@$_GET["Id"],
  'TaskDate'=>@$timesheetdate,
  'TaskDescription'=>@$TaskDescription,
  'Duration'=>@$_POST["Duration"],
  'UpdateBy'=>@$_SESSION["UserInfo"][0]['UserId'],
  'UpdateDateTime'=>@$date
);
$data = $actiondata_db->edit_db($list);

$list = array(
  'table'=>$name_table28,
  'TimeSheetId'=>@$_GET["Id"],
  'TaskDate'=>@$timesheetdate,
  'TaskDescription'=>@$TaskDescription,
  'Duration'=>@$_POST["Duration"],
  'UpdateBy'=>@$_SESSION["UserInfo"][0]['UserId'],
  'UpdateDateTime'=>@$date
);
$data = $actiondata_db->edit_db($list);


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

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

}


?>