57 lines
2.4 KiB
PHP
57 lines
2.4 KiB
PHP
|
<?php
|
||
|
|
include('includes/config/config.php');
|
||
|
|
include ('includes/functions.php');
|
||
|
|
include ('log_entry.php');
|
||
|
|
error_log ( "Start Printing Request Attributes" );
|
||
|
|
$requestStr="";
|
||
|
|
foreach ( $_REQUEST as $key => $value ) {
|
||
|
|
$requestStr.=$key . " : " . $value . "\n";
|
||
|
|
error_log ( $key . " : " . $value . "<br />\r\n" );
|
||
|
|
}
|
||
|
|
error_log ( "End Printing Request Attributes" );
|
||
|
|
save_log($requestStr,'Ambulance Move','SAVE','save_ambulance_details.php');
|
||
|
|
$noOfRows=$_POST['count_items'];
|
||
|
|
|
||
|
|
$dis_agncy = $_POST['dis_agncy'];
|
||
|
|
//ech "hello".$noOfRows;
|
||
|
|
//$waste_id = $_POST['waste_id'];
|
||
|
|
for($i=0;$i<$noOfRows;$i++){
|
||
|
|
|
||
|
|
$ambulance_id_str="ambulance_id".$i;
|
||
|
|
$ambulance_id=$_REQUEST[$ambulance_id_str];
|
||
|
|
//echo $ambulance_id;
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
//echo $procurement_refno;
|
||
|
|
$query_initial="";
|
||
|
|
$endquery="";
|
||
|
|
begin();
|
||
|
|
if(!empty($ambulance_id)){
|
||
|
|
$query_initial="update ";
|
||
|
|
$endquery=" where ambulance_id = '".$ambulance_id."' ";
|
||
|
|
}else{
|
||
|
|
$query_initial="insert into ";
|
||
|
|
}
|
||
|
|
|
||
|
|
$sql="select ambulance_number FROM ambulance_details_new WHERE id=$ambulance_number";
|
||
|
|
$sql_new=$sql;
|
||
|
|
$result=mysqli_query($conn,$sql);
|
||
|
|
$row=mysqli_fetch_assoc($result);
|
||
|
|
$ambulance_number=$row['ambulance_number'];
|
||
|
|
error_log("ABCDEHHH".$ambulance_number);
|
||
|
|
$city=$_REQUEST['city_id'];
|
||
|
|
error_log("city".$city);
|
||
|
|
|
||
|
|
|
||
|
|
$query=$query_initial." ambulance_details set ambulance_date=STR_TO_DATE('".${"ambulance_date$i"}."','%d/%m/%Y'), ambulance_driver ='".${"ambulance_driver$i"}."',city_id ='".$city."',ambulance_type ='".$_REQUEST['ambulance_type']."',IsChargeable ='".$_REQUEST['IsChargeable']."',patient_id ='".$_REQUEST['patient_id']."',cost ='".${"cost$i"}."',total_cost ='".${"total_cost$i"}."',amb_charge ='".${"amb_charge$i"}."',ambulance_extra_km ='".${"ambulance_extra_km$i"}."',ambulance_from = '".${"ambulance_from$i"}."',ambulance_to ='".${"ambulance_to$i"}."',ambulance_out_km='".${"ambulance_out_km$i"}."',ambulance_in_km='".${"ambulance_in_km$i"}."',ambulance_total_km='".${"ambulance_total_km$i"}."',ambulance_out_time='".${"ambulance_out_time$i"}."',ambulance_in_time='".${"ambulance_in_time$i"}."',ambulance_duty='".${"ambulance_duty$i"}."',ambulance_used='".${"ambulance_used$i"}."',ambulance_details='".${"ambulance_details$i"}."',ambulance_number='".${"ambulance_number"}."',modified_by = '".$_SESSION['user_id']."' ".$endquery;
|
||
|
|
|
||
|
|
error_log( $query);
|
||
|
|
|
||
|
|
if (!$result = mysqli_query($conn,$query)) {
|
||
|
|
rollback();
|
||
|
|
exit(mysqli_error($conn));
|
||
|
|
}
|
||
|
|
}
|
||
|
|
commit();
|
||
|
|
?>
|