$_POST['razorpay_order_id'], 'razorpay_payment_id' => $_POST['razorpay_payment_id'], 'razorpay_signature' => $_POST['razorpay_signature'], ); $api->utility->verifyPaymentSignature($attributes); } catch (SignatureVerificationError $e) { $success = false; $error = 'Razorpay Error : ' . $e->getMessage(); } } if ($success === true) { $razorpay_order_id = $_POST['razorpay_order_id']; $razorpay_payment_id = $_POST['razorpay_payment_id']; $msg_to_verify = $_SESSION['msg_to_verify']; $subject_to_verify = $_SESSION['subject_to_verify']; $subject = $subject_to_verify.' / '.$razorpay_payment_id; $table_gmail = '

Payment Id
'.$razorpay_payment_id.'

'; $msg_gmail = $msg_to_verify. $table_gmail; send_mail($subject, $msg_gmail); $time_id=trim(addslashes($_POST['time_id'])); $time_id_1=strtotime($time_id); $appointment_time=date('h:i a', $time_id_1); $curr_date = date('Y-m-d H:i:s'); $appointment_time_1=date('h', $time_id_1); $appointment_time_2=date('i', $time_id_1); $appointment_time_3=date('a', $time_id_1); $amount = $_POST['paid_amount'] / 100; $query= "INSERT INTO `tbl_appointment_office`(`mem_id`, `appointment_date`, `added_date`, `hour_date`, `min_date`, `am_date`, `des`, `document_name`, `mobile_no`, `email_id`, `name`, `location`, `cancel_time`, `completion_time`, `amount`, `order_id`, `payment_type`, `status`, `cancel_us`, `quoted_by`, `razid`, `upload_photo`, `token_no`, `payment`, `app_id`, `paid_amount`) VALUES ('6','$_POST[app_date]','$curr_date', '$appointment_time_1',' $appointment_time_2','$appointment_time_3','$_POST[consulting]',NULL,'$_POST[mobile]',NULL,'$_POST[pat_name]','$_POST[location]',NULL,NULL,'$_POST[age]','$_POST[razorpay_order_id]','def','1','0','patient','$_POST[vehicle1]',NULL, NULL,'RAZORPAY', '$_POST[app_id]', '$amount')"; if(mysqli_query($conn, $query)){ $get_id = mysqli_insert_id($conn); sleep(3); $app_info = date('d-m-Y', strtotime($_POST['app_date'])).' : '.date('l', strtotime($_POST['app_date'])).' : '; $log = "INSERT INTO tbl_missed_dc_log (cust_name, whatsapp, age, `location`, consulting_for, app_date, app_time, reference, amount, raz_order_id, app_id, time_id, payment_status) VALUES('$_POST[pat_name]', '$_POST[mobile]', '".$_POST['age']."', '$_POST[location]', '$_POST[consulting]', '$_POST[app_date]', '$app_info', '".$_POST['vehicle1']."', '400', '$razorpay_payment_id', '".$_POST['app_id']."', '".$_POST['time_id']."', 'post-order');"; mysqli_query($conn, $log); $get_appt = mysqli_query($conn, "select * from tbl_doctor_appointment_office where id = '$_POST[app_id]'"); $get_apps = mysqli_fetch_array($get_appt, MYSQLI_ASSOC); if($get_apps['from_min'] == '0'){ $from_min = '00'; }else{ $from_min = $get_apps['from_min']; } if($get_apps['to_min'] == '0'){ $to_min = '00'; }else{ $to_min = $get_apps['to_min']; } $schedule =$get_apps['from_hour'].':'.$from_min.' '.$get_apps['from_sta'].' to '.$get_apps['to_hour'].':'.$to_min.' '.$get_apps['to_sta']; $login = "SELECT * from shop_user WHERE phone= '$_POST[mobile]'"; $resqry = mysqli_query($conn, $login); $numrows = mysqli_num_rows($resqry); if($numrows==0) { $username="drg-".time(); $Insert_Qry_12 = "INSERT INTO shop_user (`name`,`phone`, `username`, `password`, `status`, `new_status`, `package`, `GST`) VALUES ('$_POST[pat_name]','$_POST[mobile]', '$username', 'pass@202k', '1', '0', '0', '')"; $Insert_Run_12 = mysqli_query($conn, $Insert_Qry_12); } // $app_infos = $_POST['app_date'].' '.$time_id; sleep(2); sms_api($_POST['pat_name'], $app_info, $schedule, $_POST['mobile']); header('location: ../direct_consultation_payment_complete.php?req_id='.$get_id); } } ?>