$value) { $requestStr .= $key . " : " . $value . "\n"; error_log($key . " : " . $value . "
\r\n"); } error_log("End Printing Request Attributes"); save_log($requestStr, 'Schedule', 'SAVE', 'save_schedule.php'); $ohc_type_id =$_SESSION['current_ohcttype']; $fee_schedule_id = isset($_POST['fee_schedule_id']) ? $_POST['fee_schedule_id'] : ''; $batch = isset($_POST['batch']) ? $_POST['batch'] : "DFS".$ohc_type_id; $schedule_name = isset($_POST['schedule_name']) ? $_POST['schedule_name'] : ''; $due_date = isset($_POST['due_date']) ? $_POST['due_date'] : ''; $amount_due = isset($_POST['amount_due']) ? $_POST['amount_due'] : ''; $ohc_type_id = $_SESSION['current_ohcttype']; if (!empty($fee_schedule_id)) { $query = "UPDATE batch_fee_schedule SET schedule_name = '$schedule_name', batch = '$batch', due_date = '$due_date', amount_due = '$amount_due', modified_by = 'username_placeholder', -- Replace with actual username variable ohc_type_id ='$ohc_type_id' WHERE fee_schedule_id = '$fee_schedule_id'"; } else { $query = "INSERT INTO batch_fee_schedule( fee_schedule_id, schedule_name, batch, due_date, amount_due,ohc_type_id, modified_by ) VALUES ( '$fee_schedule_id', '$schedule_name', '$batch', '$due_date', '$amount_due','$ohc_type_id', 'username_placeholder' -- Replace with actual username variable )"; } error_log($query); if (!$result = mysqli_query($conn, $query)) { error_log(mysqli_error($conn)); exit(mysqli_error($conn)); } ?>