$caller="active"; $caller1="open"; $appointment_detil="active"; require_once '../template/superadmin/action_connection.php' ; include("../settings/adminsession.php"); session_start(); ?> if(isset($_POST['sumbit'])){//to run PHP script on submit $v_id_order=$_REQUEST["v_id_order"]; $cour=$_REQUEST["courier_status_".$v_id_order.""]; date_default_timezone_set('Asia/Kolkata'); $date_ss = date('Y-m-d H:i:s ', time()); $Query="UPDATE `tbl_appointment_office` SET `status`='$cour' WHERE `id`='$v_id_order'"; $DB->query($Query); //$ids=$_REQUEST['ids']; header("location:appointment_details_mas.php"); //$cour="courier_status".$v_id_order.""; //header("location:view_order.php?ids=15"); } ?> if($_REQUEST['id']!='') { $id=$_REQUEST['id']; $datemal = date_default_timezone_set('Asia/Kolkata'); $dt2=date('Y-m-d H:i:s'); $Query="UPDATE tbl_appointment SET status='4',cancel_time='$dt2' WHERE `id`='".$_REQUEST['id']."'"; $DB->query($Query); $Query_m = "SELECT * from tbl_appointment where id='".$_REQUEST['id']."' "; $namesss_m=$DB->query($Query_m); $rowsss_m = mysql_fetch_array($namesss_m); $email_id=$rowsss_m['email_id']; $mailcopy=$rowsss_m['email_id']; $date=$rowsss['date']; $me_id=$rowsss_m['mem_id']; $order_id=$rowsss_m['id']; $ap_date= $rowsss_m['appointment_date']; $ap_hour= sprintf("%02d",$rowsss_m['hour_date']); $ap_min= sprintf("%02d",$rowsss_m['min_date']); $ap_sec= $rowsss_m['am_date']; $Query_m_a = "SELECT * from `tbl_member` where id='$me_id' "; $namesss_m_a=$DB->query($Query_m_a); $no_m_a=mysql_num_rows($namesss_m_a); $row_m_a = mysql_fetch_array($namesss_m_a); $firstname= $row_m_a['name']; $skypeid=$row_m_a['skypeid']; $mobss= $row_m_a['phone']; sprintf("%02d", $to_hour); /* -----------------------------------*/ $message = "Hi ".$firstname." your appointment with Dr. G.ANBUGANAPATHI on ".$ap_date." ".$ap_hour.":".$ap_min.":".$ap_sec." is Cancelled.Sorry For the inconvenience."; //enter Your Message $message = urlencode($message); $curl = curl_init(); curl_setopt_array($curl, array( CURLOPT_URL => 'http://sms.dial4sms.com/api/v2/SendSMS?SenderId=DRANBU&Message='.$message.'&MobileNumbers='.$mobss.'&ApiKey=eYfIWFmiAMhbL6JDTfOb3kzGzQr+eimy6prshuD8qLo=&ClientId=b45d4e3d-cb26-4856-8cbf-93a02a7b9eeb', CURLOPT_RETURNTRANSFER => true, CURLOPT_ENCODING => '', CURLOPT_MAXREDIRS => 10, CURLOPT_TIMEOUT => 0, CURLOPT_FOLLOWLOCATION => true, CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1, CURLOPT_CUSTOMREQUEST => 'GET', )); $response = curl_exec($curl); curl_close($curl); //$mobilenumbers1='$res_owner_mobile'; $Msg1 = '
|
S.No | Receipt No | Name | Booked Date | Mobile No | Appointment Date | Country | Fees | Status |
---|---|---|---|---|---|---|---|---|
echo $nsssss;?> | OC- echo $rowsss['order_id'];?> | echo $row['name'];?> | echo $rowsss['added_date'];?> | echo $row['phone'];?> | echo $rowsss['appointment_date'];?> echo sprintf("%02d",$rowsss['hour_date']);?>: echo sprintf("%02d",$rowsss['min_date']);?> echo $rowsss['am_date'];?> | echo $connn=$row['country'];?> | $r_p_ar=$rowsss['id']; ?> if($r_p_ar==3248) { ?> Rs999 } else { ?> if($connn=="India") { $sss="Rs"; } else { $sss="$"; } ?> echo $sss;?> echo $rowsss ['amount'];?> } ?> | ?> Cancel |
echo $si=$si+1;?> | Direct | echo $row_job_move_free_job['name'];?> | echo $row_job_move_free_job['added_date'];?> | echo $row_job_move_free_job['mobile_no'];?> | echo $row_job_move_free_job['appointment_date'];?> echo sprintf("%02d",$row_job_move_free_job['hour_date']);?>: echo sprintf("%02d",$row_job_move_free_job['min_date']);?> echo $row_job_move_free_job['am_date'];?> | India | echo $row_job_move_free_job['des'];?> |