69 lines
2.2 KiB
PHP
69 lines
2.2 KiB
PHP
<?php
|
|
include('includes/config/config.php');
|
|
include('includes/functions.php');
|
|
$response_array = array();
|
|
$response_mssages = "";
|
|
|
|
$usage_id = $_REQUEST['usage_id'];
|
|
for ($i = 0; $i < count($usage_id); $i++) {
|
|
if ($usage_id[$i] != null || $usage_id[$i] != '') {
|
|
$data_q = "SELECT * FROM temporary_vaccination_details WHERE id ='$usage_id[$i]'";
|
|
|
|
error_log('$data_q' . $data_q);
|
|
$result_data_q = mysqli_query($conn, $data_q);
|
|
while ($usage_fetch = mysqli_fetch_array($result_data_q)) {
|
|
|
|
$vac_id = $usage_fetch['vac_id'];
|
|
$emp_id = $usage_fetch['emp_id'];
|
|
$vac_d1 = $usage_fetch['vac_d1'];
|
|
$vac_center1 = $usage_fetch['vac_center1'];
|
|
$vac_d2 = $usage_fetch['vac_d2'];
|
|
$vac_center2 = $usage_fetch['vac_center2'];
|
|
$vac_d3 = $usage_fetch['vac_d3'];
|
|
$vac_center3 = $usage_fetch['vac_center3'];
|
|
$remarks = $usage_fetch['remarks'];
|
|
|
|
$queid = "select id ,vac_id from vaccination_details where emp_id='" . $emp_id . "' and vac_id='" . $vac_id . "'";
|
|
error_log("UPDATE OR NOT " . $queid);
|
|
$result_id_sql = mysqli_query($conn, $queid);
|
|
$row_id = mysqli_fetch_array($result_id_sql);
|
|
$id = $row_id['id'];
|
|
|
|
|
|
|
|
error_log("interm usage::" . $id);
|
|
|
|
|
|
$initquery = "";
|
|
$endquery = "";
|
|
|
|
if ($id != "" && $id != null) {
|
|
$initquery = "update vaccination_details set ";
|
|
$endquery = " where id = '" . $id . "' ";
|
|
$update_counter++;
|
|
} else {
|
|
$initquery = "insert into vaccination_details set ";
|
|
$endquery = "";
|
|
$insert_counter++;
|
|
}
|
|
$query_vac = $initquery . " emp_id = '" . $emp_id . "',vac_id = '" . $vac_id . "' , vac_d1='" . $vac_d1 . "',vac_center1='" . $vac_center1 . "',vac_d2='" . $vac_d2 . "',vac_d3='" . $vac_d3 . "',vac_center3='" . $vac_center3 . "',vac_center2='" . $vac_center2 . "',remarks='" . $remarks . "'" . $endquery;
|
|
|
|
error_log("PERENT " . $query_vac);
|
|
|
|
|
|
error_log("PROCUREMENT QUERY::" . $query_vac);
|
|
$result1 = mysqli_query($conn, $query_vac);
|
|
}
|
|
}
|
|
}
|
|
if (empty($result1)) {
|
|
$type = "error";
|
|
rollback();
|
|
} else {
|
|
$sql = "TRUNCATE TABLE temporary_vaccination_details";
|
|
error_log($sql . "delete");
|
|
$query = mysqli_query($conn, $sql);
|
|
commit();
|
|
}
|
|
echo json_encode($type);
|