date_default_timezone_set('Asia/Kolkata'); $caller="active"; $caller1="open"; $dc_appointment_detil="active"; require_once '../template/superadmin/action_connection.php' ; include("../settings/adminsession.php"); include "../../include/conf.php"; session_start(); $today = date('Y-m-d'); $get_tod_direct = mysqli_query($conn, "SELECT * from tbl_appointment_office where status in (1,2,3,4) and DATE(appointment_date) = '$today'"); $get_tod_direct_count = mysqli_num_rows($get_tod_direct); $get_tod_direct = mysqli_query($conn, "SELECT * from tbl_appointment_office where status='2' and DATE(appointment_date) = '$today'"); $get_tod_direct_completed_count = mysqli_num_rows($get_tod_direct); $get_pen = mysqli_query($conn, "SELECT * from tbl_appointment_office where status='1' and DATE(appointment_date) = '$today'"); $get_pending = mysqli_num_rows($get_pen); $get_can = mysqli_query($conn, "SELECT * from tbl_appointment_office where status in (3,4) and DATE(appointment_date) = '$today'"); $get_cancelled = mysqli_num_rows($get_can); $dates = date('Y-m-d'); $get_on_con = mysqli_query($conn, "SELECT * from tbl_appointment where status = 1 and DATE(appointment_date) < '$dates'"); $get_on_con_count = mysqli_num_rows($get_on_con); $get_oc = mysqli_query($conn, "SELECT * from tbl_appointment where status='1' and DATE(appointment_date) = '$today'"); $get_oc_pending = mysqli_num_rows($get_oc); ?> if(isset($_POST['sumbit1_para'])){//to run PHP script on submit $v_id_order=$_REQUEST["v_id_order"]; $cour=$_REQUEST["courier_status_".$v_id_order.""]; console_log($v_id_order); $date_ss = date('Y-m-d H:i:s ', time()); echo $Query="UPDATE `tbl_appointment_office` SET `status`='$cour' WHERE `id`='$v_id_order'"; $DB->query($Query); //$ids=$_REQUEST['ids']; //header("location:direct_appointment_details.php"); //$cour="courier_status".$v_id_order.""; //header("location:view_order.php?ids=15"); } ?> if(isset($_POST['sumbit_note_para'])){//to run PHP script on submit $v_id_order=$_REQUEST["v_id_order"]; $cour=$_REQUEST["c_note_".$v_id_order.""]; date_default_timezone_set('Asia/Kolkata'); $date_ss = date('Y-m-d H:i:s ', time()); $Query="UPDATE tbl_appointment SET status='". $cour."',comp_time_da='". $date_ss."' WHERE `id`='".$v_id_order."'"; $DB->query($Query); $date_ss = date('Y-m-d H:i:s ', time()); //$ids=$_REQUEST['ids']; header("location:direct_appointment_details.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 | Reference | Name | Problem | Status | Mobile No | Booked Date | Appt Date | City | Token No. | |
---|---|---|---|---|---|---|---|---|---|---|
= date('d-m-Y', strtotime($get_split['app_date'])).' - '.date('l', strtotime($get_split['app_date']))?> | ||||||||||
style="background-color:#AAFF00;" > echo $si=$si+1;?> | style="background-color:#AAFF00;" >= $row_job_move_free_job['payment'] ?> | style="background-color:#AAFF00;" >
|
style="background-color:#AAFF00;" > echo $row_job_move_free_job['des'];?> | style="background-color:#AAFF00;" > echo $row_job_move_free_job['mobile_no'];?> | style="background-color:#AAFF00;" > echo $row_job_move_free_job['added_date'];?> | style="background-color:#AAFF00;" > 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'];?> | style="background-color:#AAFF00;" > echo $row_job_move_free_job['location'];?> | style="background-color:#AAFF00;" > |