61 lines
2.1 KiB
PHP
61 lines
2.1 KiB
PHP
<?php
|
|
include('includes/config/config.php');
|
|
include('log_entry.php');
|
|
include('includes/functions.php');
|
|
|
|
|
|
|
|
$id = $_POST['id'];
|
|
$batch_name = $_POST['batch_name'];
|
|
$enqiry_id = $_POST['beneficiary_id'];
|
|
$addmission_status = $_POST['addmission_status'];
|
|
if($addmission_status == 'Dropout'){
|
|
|
|
$dropout_date = $_POST['unenroll_date'];
|
|
$remark = $_POST['remark'];
|
|
}else{
|
|
$dropout_date = $_POST['unenroll_date2'];
|
|
$remark = $_POST['remark2'];
|
|
}
|
|
$batch_name2 = $_POST['batch_name2'];
|
|
|
|
|
|
|
|
$ohc_type_id = $_SESSION['current_ohcttype'];
|
|
$modified_by = $_SESSION['user_id'];
|
|
if($id >0 || $id != ''){
|
|
$query1 = "UPDATE dropout_beneficiary SET dropout_status = '$addmission_status',dpd ='$dropout_date',remark = '$remark' WHERE id='$id' ";
|
|
}else{
|
|
|
|
$query1 = "INSERT INTO dropout_beneficiary (enquiry_id,old_batch,dropout_status, dpd, remark,ohc_type_id,modified_by) VALUES ('$enqiry_id','$batch_name','$addmission_status','$dropout_date','$remark',$ohc_type_id,$modified_by)";
|
|
}
|
|
|
|
error_log('Check_query1 : '.$query1);
|
|
|
|
if ($result = mysqli_query($conn, $query1)) {
|
|
$query2 = "DELETE FROM training_batch_enrollment_beneficiary WHERE beneficiary_id = '$enqiry_id'";
|
|
if ($result = mysqli_query($conn, $query2)) {
|
|
if($addmission_status == 'Dropout'){
|
|
$query3 = "UPDATE beneficiary_enquiry SET addmission_status = 'Droped' WHERE id = '$enqiry_id'";
|
|
}else{
|
|
$program_id = getFieldFromTable('training_program_id','training_batch_master','batch_id ',$batch_name2);
|
|
|
|
$query3 = "UPDATE beneficiary_enquiry SET addmission_status = 'BPE',subject='$program_id',batch_id = '$batch_name2' WHERE id = '$enqiry_id'";
|
|
|
|
}
|
|
if (!$result = mysqli_query($conn, $query3)) {
|
|
error_log("Database query failed: " . mysqli_error($conn));
|
|
exit("Database query failed: " . mysqli_error($conn));
|
|
}
|
|
|
|
}else{
|
|
error_log("Database query failed: " . mysqli_error($conn));
|
|
exit("Database query failed: " . mysqli_error($conn));
|
|
}
|
|
}else{
|
|
error_log("Database query failed: " . mysqli_error($conn));
|
|
exit("Database query failed: " . mysqli_error($conn));
|
|
}
|
|
|
|
|