63 lines
1.5 KiB
PHP
63 lines
1.5 KiB
PHP
<?php
|
|
error_reporting(E_ERROR | E_PARSE);
|
|
include('includes/config/config.php');
|
|
include 'log_entry.php';
|
|
$status= $_POST['status'];
|
|
$emp_assign_training_id=$_POST['emp_assign_training_id'];
|
|
$completion_date=$_POST['completion_date'];
|
|
|
|
$sql="";
|
|
if(!empty($emp_assign_training_id)){
|
|
|
|
|
|
$sql="update employee_assign_training set status='$status' ,completion_date=STR_TO_DATE('".$completion_date."', '%d/%m/%Y') where emp_assign_training_id='$emp_assign_training_id'";
|
|
error_log("sql".$sql);
|
|
|
|
|
|
//echo $sql;
|
|
$result=mysqli_query($conn,$sql);
|
|
if (!$result) {
|
|
|
|
exit(mysqli_error($conn));
|
|
echo json_encode("FAILURE");
|
|
}
|
|
else
|
|
{
|
|
echo json_encode("SUCCESS");
|
|
}
|
|
|
|
|
|
|
|
|
|
|
|
$sql_approved="select count(*) as items employee_assign_training set status='$status' ";
|
|
error_log('approved'.$sql_approved);
|
|
// if (!$result_approved = @mysqli_query($conn, $sql_approved)) {
|
|
// error_log ("Exception saving save_app_indent_vendor_rate:".mysqli_error($conn)." failing query:".$sql_approved);
|
|
// rollback();
|
|
|
|
// exit(mysqli_error($conn));
|
|
//}
|
|
$row_approved = mysqli_fetch_array($result_approved);
|
|
$unapproved=$row_approved['items'];
|
|
if($unapproved==0){
|
|
$sql = "update assin_training set status='" . $status . "' where assin_training_id='" . $assin_training_id . "'";
|
|
|
|
error_log("sql " . $sql);
|
|
// if (!$result = @mysqli_query($conn, $sql)) {
|
|
// error_log ("Exception saving save_app_indent_vendor_rate:".mysqli_error($conn)." failing query:".$sql);
|
|
// rollback();
|
|
|
|
// exit(mysqli_error($conn));
|
|
// } else {
|
|
|
|
// $data = "success";
|
|
//}
|
|
}
|
|
|
|
|
|
|
|
|
|
|
|
|
|
} |