39 lines
1.2 KiB
PHP
39 lines
1.2 KiB
PHP
|
<?php
|
||
|
|
include('includes/config/config.php');
|
||
|
|
include('includes/functions.php');
|
||
|
|
$noOfRows=$_POST['count_items'];
|
||
|
|
|
||
|
|
for($i=0;$i<$noOfRows;$i++){
|
||
|
|
|
||
|
|
$notice_id_str="notice_id".$i;
|
||
|
|
$notice_id=$_POST[$notice_id_str];
|
||
|
|
//echo $notice_id;
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
//echo $procurement_refno;
|
||
|
|
$query_initial="";
|
||
|
|
$endquery="";
|
||
|
|
begin();
|
||
|
|
if(!empty($notice_id)){
|
||
|
|
$query_initial="update ";
|
||
|
|
$endquery=" where notice_id = '".$notice_id."' ";
|
||
|
|
}else{
|
||
|
|
$query_initial="insert into ";
|
||
|
|
}
|
||
|
|
$status =$_REQUEST['status'];
|
||
|
|
error_log("golu".$status);
|
||
|
|
|
||
|
|
$query=$query_initial." notice set trigger_date=STR_TO_DATE('".${"trigger_date$i"}."','%d/%m/%Y'), expiry_date=STR_TO_DATE('".${"expiry_date$i"}."','%d/%m/%Y'),issued_by ='".${"issued_by$i"}."',status ='".${"status$i"}."',issued_to ='".${"issued_to$i"}."',remark ='".${"remark$i"}."',notice_details = '".${"notice_details$i"}."',modified_by = '".$_SESSION['user_id']."' ".$endquery;
|
||
|
|
error_log("dipakmali".$query);
|
||
|
|
|
||
|
|
//echo $query;
|
||
|
|
|
||
|
|
if (!$result = mysqli_query($conn,$query)) {
|
||
|
|
rollback();
|
||
|
|
exit(mysqli_error($conn));
|
||
|
|
}
|
||
|
|
}
|
||
|
|
commit();
|
||
|
|
?>
|
||
|
|
|