$value) { $requestStr .= $key . " : " . $value . "\n"; error_log($key . " : " . $value . "
\r\n"); } error_log("End Printing Request Attributes"); save_log($requestStr, 'Save_appointment', 'SAVE', 'save_appointment.php'); $appointment_book_id= $_POST['appointment_book_id']; $app_id=0; $doctor_name= $_POST['doctor_name']; $appointment_book_date= $_POST['appointment_book_date']; $patient_name_cc= $_POST['patient_name_cc']; $app_type = $_POST['appointment_booking_type']; $slot = $_POST['doctor_slot']; $in=''; $end=''; if(!empty($appointment_book_id)){ $in="update"; $end=" where id='".$appointment_book_id."'"; $old_slot= getTableFieldValue('appointment_details','time','id',$appointment_book_id); if($slot!=$old_slot){ $sql_old_slot = "update doc_slots set status='' where emp_id='$doctor_name' and slot_date=str_to_date('$appointment_book_date','%Y-%m-%d') and slot_id='$old_slot' and ohc_type_id='".$_SESSION['current_ohcttype']."' "; error_log("sql_old_slot " . $sql_old_slot); @mysqli_query($conn,$sql_old_slot); } } else { $in= "insert into "; } $sql = $in." appointment_details set emp_id = '$patient_name_cc',doctor_id='$doctor_name',date=str_to_date('$appointment_book_date','%Y-%m-%d'),time='$slot',app_type='$app_type',modified_by = '".$_SESSION['user_id']."' ,ohc_type_id='".$_SESSION['current_ohcttype']."',status='BOOKED' ".$end; error_log("emp appointment " . $sql); if (!$result_app = mysqli_query($conn, $sql)) { error_log("Exception:" . mysqli_error($conn)); rollback(); error_log("Followup Save: " . $sql); exit(error_log(mysqli_error($conn))); } else{ if(!empty($appointment_book_id)){ $app_id=$appointment_book_id; }else{ $query_id = "select max(id) id from appointment_details "; // echo $query; error_log("max appointment_id query: " . $query_id); if (!$result_id = @mysqli_query($conn, $query_id)) { rollback(); exit(error_log(mysqli_error($conn))); } if (mysqli_num_rows($result_id) > 0) { while ($row_id = mysqli_fetch_assoc($result_id)) { $app_id= $row_id['id']; } } } $sql_remarks = "update doc_slots set status='BOOKED' where emp_id='$doctor_name' and slot_date=str_to_date('$appointment_book_date','%Y-%m-%d') and slot_id='$slot' and ohc_type_id='".$_SESSION['current_ohcttype']."' "; error_log("sql_remarks " . $sql_remarks); if (!$result = @mysqli_query($conn, $sql_remarks)) { error_log ("Exception saving save_app_indent_vendor:".mysqli_error($conn)." failing query:".$sql_remarks); rollback(); exit(mysqli_error($conn)); } } $data['app_id']=$app_id; echo json_encode($data); ?>