54 lines
1.7 KiB
PHP
54 lines
1.7 KiB
PHP
|
<?php
|
||
|
|
include('includes/config/config.php');
|
||
|
|
include('includes/functions.php');
|
||
|
|
$noOfRows = $_POST['count_items'];
|
||
|
|
|
||
|
|
$dis_agncy = $_POST['dis_agncy'];
|
||
|
|
//ech "hello".$noOfRows;
|
||
|
|
//$waste_id = $_POST['waste_id'];
|
||
|
|
|
||
|
|
error_log("#_REQ" . print_r($_POST, true));
|
||
|
|
|
||
|
|
for ($i = 0; $i < $noOfRows; $i++) {
|
||
|
|
|
||
|
|
$checkup_type_id_str = "checkup_type_id" . $i;
|
||
|
|
$checkup_type_id = $_POST[$checkup_type_id_str];
|
||
|
|
|
||
|
|
error_log("milind");
|
||
|
|
|
||
|
|
|
||
|
|
$checkup_form_section_ids = $_POST['checkup_form_section_ids'];
|
||
|
|
|
||
|
|
$ohc_ids = $_POST['ohc_id'];
|
||
|
|
|
||
|
|
$status = $_POST['Status'];
|
||
|
|
$state = $_POST['type_state'];
|
||
|
|
$sec_choice = $_POST['sec_choice'];
|
||
|
|
//echo $procurement_refno;
|
||
|
|
$query_initial = "";
|
||
|
|
$endquery = "";
|
||
|
|
//begin();
|
||
|
|
if (!empty($checkup_type_id)) {
|
||
|
|
$query_initial = "update ";
|
||
|
|
$endquery = " where checkup_type_id = '" . $checkup_type_id . "' ";
|
||
|
|
} else {
|
||
|
|
$query_initial = "insert into ";
|
||
|
|
}
|
||
|
|
|
||
|
|
|
||
|
|
$checkup_form_section_ids = implode(',', $checkup_form_section_ids);
|
||
|
|
$ohc_ids = implode(",", $ohc_ids);
|
||
|
|
|
||
|
|
error_log("messgeeeee");
|
||
|
|
|
||
|
|
$query = $query_initial . " checkup_type set checkup_type_name = '" . ${"checkup_type_name$i"} . "',pre_checkup_type = '" . ${"pre_checkup_type$i"} . "', checkup_type_code='" . ${"checkup_type_code$i"} . "' ,ohc_ids='" . ${"ohc_ids"} . "',checkup_form_section_ids='$checkup_form_section_ids',type_status='$status' ,type_state='$state',valid_upto='" . ${"valid_duration$i"} . "', cost='" . ${"cost$i"} . "',sec_choice='" . $sec_choice . "',modified_by = '" . $_SESSION['user_id'] . "' " . $endquery;
|
||
|
|
error_log("error message " . $query);
|
||
|
|
|
||
|
|
if (!$result = mysqli_query($conn, $query)) {
|
||
|
|
error_log("error " . mysqli_error($conn));
|
||
|
|
//rollback();
|
||
|
|
exit(mysqli_error($conn));
|
||
|
|
}
|
||
|
|
}
|
||
|
|
//commit();
|