61 lines
3.0 KiB
PHP
61 lines
3.0 KiB
PHP
<?php
|
|
include('includes/config/config.php');
|
|
include('includes/functions.php');
|
|
include('log_entry.php');
|
|
|
|
session_start();
|
|
|
|
$id = isset($_POST['cid']) ? $_POST['cid'] : null;
|
|
$batch_name = $_POST['batch_name'];
|
|
$new_batch_name = $_POST['new_batch_name'];
|
|
$beneficiary_id = $_POST['beneficiary_id'];
|
|
$old_course = $_POST['old_course'];
|
|
$new_course = $_POST['new_course'];
|
|
$remarks = $_POST['remarks'];
|
|
$status = $_POST['status'];
|
|
$ohc_type_id = $_SESSION['current_ohcttype'];
|
|
$apply_date = date('Y-m-d');
|
|
|
|
$batch_pri_tbl_id = getFieldFromTable('id','training_batch_enrollment','batch_id',$new_batch_name);
|
|
$batch_pri_tbl_id = getFieldFromTable('id','training_batch_enrollment','batch_id',$new_batch_name);
|
|
$shoes_issue = getFieldFromTable('shoes_issue','training_batch_enrollment_beneficiary','beneficiary_id',$beneficiary_id);
|
|
$kit_issue = getFieldFromTable('kit_issue','training_batch_enrollment_beneficiary','beneficiary_id',$beneficiary_id);
|
|
if ($status == 'Approve') {
|
|
|
|
if($new_batch_name){
|
|
$delete_sql = "DELETE FROM training_batch_enrollment_beneficiary WHERE batch_id = '$batch_name' AND beneficiary_id = '$beneficiary_id'";
|
|
mysqli_query($conn, $delete_sql);
|
|
$update_sql = "INSERT INTO training_batch_enrollment_beneficiary SET batch_pri_tbl_id='$batch_pri_tbl_id',batch_id = '$new_batch_name' ,shoes_issue='$shoes_issue',kit_issue='$kit_issue', beneficiary_id = '$beneficiary_id' ";
|
|
mysqli_query($conn, $update_sql);
|
|
$update_sql_enq = "UPDATE beneficiary_enquiry SET subject = '$new_course' WHERE patient_id = '$beneficiary_id'";
|
|
mysqli_query($conn, $update_sql_enq);
|
|
|
|
error_log($delete_sql);
|
|
error_log($update_sql);
|
|
error_log($update_sql_enq);
|
|
|
|
}else{
|
|
|
|
|
|
$delete_sql = "DELETE FROM training_batch_enrollment_beneficiary WHERE batch_id = '$batch_name' AND beneficiary_id = '$beneficiary_id'";
|
|
mysqli_query($conn, $delete_sql);
|
|
$update_sql = "UPDATE beneficiary_enquiry SET subject = '$new_course', addmission_status = 'BPE' WHERE patient_id = '$beneficiary_id'";
|
|
mysqli_query($conn, $update_sql);
|
|
}
|
|
}
|
|
error_log("Check_outher_sql : ".$id);
|
|
error_log("Check_outher_sql : ".$update_sql);
|
|
|
|
if (!empty($id)) {
|
|
$query = "UPDATE course_change SET batch_name = '$batch_name',new_batch_name= '$new_batch_name', beneficiary_id = '$beneficiary_id', old_course = '$old_course', new_course = '$new_course', remarks = '$remarks', status = '$status', modified_by = '" . $_SESSION['user_id'] . "', apply_date = '$apply_date', ohc_type_id = '$ohc_type_id' WHERE id = '$id'";
|
|
} else {
|
|
$query = "INSERT INTO course_change (batch_name,new_batch_name, beneficiary_id, old_course, new_course, remarks, status, modified_by, apply_date, ohc_type_id) VALUES ('$batch_name','$new_batch_name', '$beneficiary_id', '$old_course', '$new_course', '$remarks', '$status', '" . $_SESSION['user_id'] . "', '$apply_date', '$ohc_type_id')";
|
|
}
|
|
|
|
$result = mysqli_query($conn, $query);
|
|
if (!$result) {
|
|
error_log("Database query failed: " . mysqli_error($conn));
|
|
exit("Database query failed: " . mysqli_error($conn));
|
|
}
|
|
?>
|