48 lines
1.7 KiB
PHP
48 lines
1.7 KiB
PHP
<?php
|
|
include ('includes/config/config.php');
|
|
include ('includes/functions.php');
|
|
include ('log_entry.php');
|
|
$noOfRows = $_POST['count_items'];
|
|
error_log("noOfRows".$noOfRows);
|
|
begin();
|
|
// echo $noOfRows;
|
|
$calibration_id = $_POST['calibration_id'];
|
|
$initquery = "";
|
|
$data = array();
|
|
$endquery = "";
|
|
|
|
if (! empty($calibration_id)) {
|
|
|
|
$current_stock_level_calibration_item_tbl_query = "select cat_id,qty,cali_on,next_cali from calibration_item_tbl where calibration_id='" . $calibration_id . "' ";
|
|
$results_calibration_item = mysqli_query($conn,$current_stock_level_calibration_item_tbl_query);
|
|
// echo $current_stock_level_calibration_item_tbl_query;
|
|
|
|
}
|
|
// clear existing entries into the child table
|
|
$query_del = " delete from calibration_item_tbl where calibration_id = '" . $calibration_id . "' ";
|
|
// echo $query_del;
|
|
$result_del = @mysqli_query($conn,$query_del);
|
|
|
|
for ($i = 0; $i < $noOfRows; $i ++) {
|
|
|
|
// if (! @mysqli_query($conn,$current_stock_query)) {
|
|
// rollback();
|
|
// header('HTTP/1.1 500 Internal Server Error');
|
|
// echo json_encode(die('failed!' . mysqli_error($conn)));
|
|
// }
|
|
|
|
$query1 = "insert into calibration_item_tbl set calibration_id='$calibration_id', cat_id ='" . ${"cat_id$i"} . "',qty = '" . ${"qty$i"} . "',cali_on=STR_TO_DATE('" . ${"cali_on$i"} . "','%d/%m/%Y'),next_cali=STR_TO_DATE('" . ${"next_cali$i"} . "','%d/%m/%Y'),modified_by = '" . $_SESSION['user_id'] . "' ";
|
|
// echo $query1;
|
|
error_log("query1".$query1);
|
|
if (! $result1 = @mysqli_query($conn,$query1)) {
|
|
|
|
rollback();
|
|
header('HTTP/1.1 500 Internal Server Error');
|
|
echo json_encode(die('failed!' . mysqli_error($conn)));
|
|
}
|
|
}
|
|
commit();
|
|
|
|
echo json_encode($data);
|
|
|
|
?>
|