144 lines
6.4 KiB
PHP
144 lines
6.4 KiB
PHP
<?php
|
|
include('includes/config/config.php');
|
|
include('includes/functions.php');
|
|
include('log_entry.php');
|
|
$noOfRows = $_POST['count_items'];
|
|
error_log("noOfRows" . $noOfRows);
|
|
|
|
|
|
// echo $noOfRows;
|
|
error_log('date '.$_POST["activity_date"]);
|
|
$calibration_id = $_POST['training_camp_id'];
|
|
$training_camp_id = $_POST['training_camp_id'];
|
|
$initquery = "";
|
|
$data = array();
|
|
$endquery = "";
|
|
begin();
|
|
if ($_POST['training_camp_id'] != "" && isset($_POST['training_camp_id'])) {
|
|
|
|
|
|
|
|
$initquery="UPDATE training_camp SET ";
|
|
$endquery = " WHERE id = '" . $calibration_id . "' ";
|
|
|
|
}else{
|
|
|
|
$initquery="INSERT INTO training_camp SET ";
|
|
$endquery = " ";
|
|
}
|
|
|
|
$query111 = $initquery . " activity_date=str_to_date('" . $_POST["activity_date"] . "','%Y-%m-%d'),program_id = '" . $_POST['program_name'] . "',activity = '" . $_POST['activity'] . "',act_location = '" . $_POST['act_location'] . "',activity_type = '" . $_POST['activity_type'] . "',total_beneficiary_b = '" . $_POST['total_beneficiary_b'] . "',total_expensess_b = '" . $_POST['total_expensess_b'] . "',activity_remarks = '" . $_POST['activity_remarks'] . "',modified_by = '" . $_SESSION['user_id'] . "' ,ohc_type_id = '" . $_SESSION['current_ohcttype'] . "' " . $endquery;
|
|
error_log($query111."raj");
|
|
|
|
$result1 = @mysqli_query($conn, $query111);
|
|
|
|
if ($_POST['training_camp_id'] == "" || !isset($_POST['training_camp_id'])) {
|
|
$calibration_id=mysqli_insert_id($conn);;
|
|
}
|
|
|
|
|
|
// $query_del = " delete from training_camp_items where training_camp_pri_id = '" . $calibration_id . "' ";
|
|
// error_log($query_del) ;
|
|
// $result_del = @mysqli_query($conn, $query_del);
|
|
|
|
|
|
for ($i = 0; $i < $noOfRows; $i++) {
|
|
|
|
$bill_id = 'bill' . $i;
|
|
$file_path = $_FILES[$bill_id]['tmp_name'];
|
|
$file_type = $_FILES[$bill_id]['type'];
|
|
$file_size = $_FILES[$bill_id]['size'];
|
|
$file_name = $_FILES[$bill_id]['name'];
|
|
|
|
if (!empty($file_path) && !empty($file_name) && !empty($file_type) && !empty($file_size)) {
|
|
|
|
$bill_data = mysqli_real_escape_string($conn, file_get_contents($file_path));
|
|
|
|
$sqlForUpload = " , bill_doc = '" . $bill_data . "', bill_doc_name='" . $file_name . "' , bill_doc_type='" . $file_type . "'";
|
|
} else {
|
|
$sqlForUpload = "";
|
|
}
|
|
|
|
$check_query = "SELECT * FROM training_camp_details WHERE training_camp_pri_id = '" . $calibration_id . "' AND village_id = '" . $_POST["village_id" . $i] . "'";
|
|
$check_result = @mysqli_query($conn, $check_query);
|
|
|
|
if (mysqli_num_rows($check_result) > 0) {
|
|
|
|
$update_query = "UPDATE training_camp_details SET
|
|
remarks = '" . $_POST['remarks' . $i] . "',
|
|
total_expenses = '" . $_POST['total_expenses' . $i] . "',
|
|
modified_by = '" . $_SESSION['user_id'] . "'
|
|
$sqlForUpload
|
|
WHERE training_camp_pri_id = '" . $calibration_id . "'
|
|
AND village_id = '" . $_POST["village_id" . $i] . "'";
|
|
error_log("Update query: " . $update_query);
|
|
if (!@mysqli_query($conn, $update_query)) {
|
|
rollback();
|
|
header('HTTP/1.1 500 Internal Server Error');
|
|
echo json_encode(die('Update failed!' . mysqli_error($conn)));
|
|
}
|
|
} else {
|
|
error_log( $_POST["village_id" . $i]."dipak mali");
|
|
|
|
$insert_query = "INSERT INTO training_camp_details SET
|
|
training_camp_pri_id='" . $calibration_id . "',
|
|
village_id='" . $_POST["village_id" . $i] . "',
|
|
remarks = '" . $_POST['remarks' . $i] . "',
|
|
total_expenses = '" . $_POST['total_expenses' . $i] . "',
|
|
modified_by = '" . $_SESSION['user_id'] . "'
|
|
$sqlForUpload";
|
|
error_log("Insert query: " . $insert_query);
|
|
if (!@mysqli_query($conn, $insert_query)) {
|
|
rollback();
|
|
header('HTTP/1.1 500 Internal Server Error');
|
|
echo json_encode(die('Insert failed!' . mysqli_error($conn)));
|
|
}
|
|
}
|
|
|
|
|
|
$param = "SELECT key_param_id, key_param_name
|
|
FROM activity_key_parameter_master WHERE activity='" . $_POST['activity'] . "'";
|
|
$param_result = @mysqli_query($conn, $param);
|
|
while ($param_result_row = mysqli_fetch_array($param_result)) {
|
|
|
|
$check_key_query = "SELECT * FROM training_camp_items WHERE
|
|
training_camp_pri_id = '" . $calibration_id . "'
|
|
AND village_id = '" . $_POST["village_id" . $i] . "'
|
|
AND key_id = '" . $param_result_row['key_param_id'] . "'";
|
|
$key_result = @mysqli_query($conn, $check_key_query);
|
|
|
|
if (mysqli_num_rows($key_result) > 0) {
|
|
|
|
$update_key_query = "UPDATE training_camp_items SET
|
|
key_value='" . $_POST[$param_result_row['key_param_id'] . '_' . $i] . "'
|
|
WHERE training_camp_pri_id='" . $calibration_id . "'
|
|
AND village_id='" . $_POST["village_id" . $i] . "'
|
|
AND key_id='" . $param_result_row['key_param_id'] . "'";
|
|
error_log("Update key query: " . $update_key_query);
|
|
if (!@mysqli_query($conn, $update_key_query)) {
|
|
rollback();
|
|
header('HTTP/1.1 500 Internal Server Error');
|
|
echo json_encode(die('Update key failed!' . mysqli_error($conn)));
|
|
}
|
|
} else {
|
|
|
|
$insert_key_query = "INSERT INTO training_camp_items SET
|
|
training_camp_pri_id='" . $calibration_id . "',
|
|
village_id='" . $_POST["village_id" . $i] . "',
|
|
key_id = '" . $param_result_row['key_param_id'] . "',
|
|
key_value='" . $_POST[$param_result_row['key_param_id'] . '_' . $i] . "'";
|
|
error_log("Insert key query: " . $insert_key_query);
|
|
if (!@mysqli_query($conn, $insert_key_query)) {
|
|
rollback();
|
|
header('HTTP/1.1 500 Internal Server Error');
|
|
echo json_encode(die('Insert key failed!' . mysqli_error($conn)));
|
|
}
|
|
}
|
|
}
|
|
}
|
|
commit();
|
|
$data['training_camp_id'] = $calibration_id;
|
|
echo json_encode($data);
|
|
|
|
|
|
?>
|