69 lines
2.6 KiB
PHP
69 lines
2.6 KiB
PHP
<?php
|
|
include('includes/config/config.php');
|
|
include('includes/functions.php');
|
|
include('log_entry.php');
|
|
|
|
// Logging request parameters
|
|
$requestStr = "";
|
|
foreach ($_REQUEST as $key => $value) {
|
|
$requestStr .= $key . " : " . $value . "\n";
|
|
error_log($key . " : " . $value . "\n");
|
|
}
|
|
|
|
// Assuming session is started elsewhere
|
|
$modified_by = $_SESSION['user_id'];
|
|
|
|
// Extract POST data
|
|
$i = $_POST['count_items'];
|
|
$batch_name = mysqli_real_escape_string($conn, $_POST['batch_name']);
|
|
$teacher_name = mysqli_real_escape_string($conn, $_POST["teacher_name"]);
|
|
$meeting_date = mysqli_real_escape_string($conn, $_POST['meeting_date']);
|
|
$beneficiary_name = mysqli_real_escape_string($conn, $_POST["beneficiary_name$i"]);
|
|
$meeting_status = mysqli_real_escape_string($conn, $_POST["meeting_status$i"]);
|
|
$parent_name = mysqli_real_escape_string($conn, $_POST["parent_name$i"]);
|
|
$discussion_remark = mysqli_real_escape_string($conn, $_POST["discussion_remark$i"]);
|
|
|
|
// Start transaction
|
|
mysqli_begin_transaction($conn);
|
|
|
|
if (!empty($_POST['ppm_id'])) {
|
|
$ppm_id = mysqli_real_escape_string($conn, $_POST['ppm_id']);
|
|
} else {
|
|
// Insert new records into primary_parents_meeting table
|
|
$query = "INSERT INTO primary_parents_meeting (batch_name, meeting_date, teacher_name, modified_by)
|
|
VALUES (?, ?, ?, ?)";
|
|
$stmt = $conn->prepare($query);
|
|
$stmt->bind_param("ssss", $batch_name, $meeting_date, $teacher_name, $modified_by);
|
|
|
|
if (!$stmt->execute()) {
|
|
error_log("Failed to insert into primary_parents_meeting: " . $stmt->error);
|
|
mysqli_rollback($conn); // Rollback transaction on failure
|
|
header('HTTP/1.1 500 Internal Server Error');
|
|
die(json_encode(['error' => 'Failed to save primary parents meeting']));
|
|
}
|
|
|
|
$ppm_id = $stmt->insert_id;
|
|
$stmt->close();
|
|
}
|
|
|
|
// Insert into child_parents_meeting table
|
|
$query2 = "INSERT INTO child_parents_meeting (beneficiary_name, meeting_status, parent_name, discussion_remark, ppm_id, modified_by)
|
|
VALUES (?, ?, ?, ?, ?, ?)";
|
|
$stmt2 = $conn->prepare($query2);
|
|
$stmt2->bind_param("ssssss", $beneficiary_name, $meeting_status, $parent_name, $discussion_remark, $ppm_id, $modified_by);
|
|
|
|
if (!$stmt2->execute()) {
|
|
error_log("Failed to insert into child_parents_meeting: " . $stmt2->error);
|
|
mysqli_rollback($conn); // Rollback transaction on failure
|
|
header('HTTP/1.1 500 Internal Server Error');
|
|
die(json_encode(['error' => 'Failed to save child parents meeting']));
|
|
}
|
|
|
|
$stmt2->close();
|
|
|
|
mysqli_commit($conn); // Commit transaction if all queries are successful
|
|
|
|
// Return data after successful insertion or update
|
|
$data = ['ppm_id' => $ppm_id];
|
|
echo json_encode($data);
|
|
?>
|