query($Query);
//$ids=$_REQUEST['ids'];
header("location:appointment_details.php");
//$cour="courier_status".$v_id_order."";
//header("location:view_order.php?ids=15");
}
?>
query($Query);
header("location:appointment_details.php");
}
?>
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);
/* -----------------------------------*/
$user = "A5aa862a129267ac55838c7f2e5869d7f"; //your username
$password = "conform123"; //your password
$senderid="DRANBU"; //Your senderid
$messagetype="N"; //Type Of Your Message
$url="http://hpsms.dial4sms.com/api/web2sms.php?";
$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);
$ch = curl_init();
if (!$ch){die("Couldn't initialize a cURL handle");}
$ret = curl_setopt($ch, CURLOPT_URL,$url);
curl_setopt ($ch, CURLOPT_POST, 1);
curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, 2);
curl_setopt ($ch, CURLOPT_POSTFIELDS,
"workingkey=$user&sender=$senderid&to=$mobss&message=$message");
$ret = curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
$curlresponse = curl_exec($ch); // execute
//$mobilenumbers1='$res_owner_mobile';
$Msg1 = '
| Dr. G.ANBUGANAPATHI |
|
|
| Cancelled Appointment Details |
Hi '.$firstname.' your appointment with Dr. G.ANBUGANAPATHI on '.$ap_date.' '.$ap_hour.':'.$ap_min.':'.$ap_sec.'(Indian Standard Time (IST)) is Cancelled.Sorry For the inconvenience.
* Consultation fees will be refunded with in 3-4 bank working days.
|
Thanks & Regards
Dr. G.ANBUGANAPATHI
|
|
|
| Copyright © 2020 - dranbuganapathi.com, All Rights Reserved. |
|
';
$job_name14357="Appointment Cancellation in Dr. G.ANBUGANAPATHI";
$Subjectnew123 = "$job_name14357-$order_id";
$Subject1="Appointment Cancellation in Dr. G.ANBUGANAPATHI";
//echo $mailformat;
//$mailheaders = "Content-type: text/html; charset=iso-8859-1\r\n";
$useremail="drganbuganapathi@gmail.com";
$headers1 = "From: dranbuganapathi.com\r\n"."Content-Type: text/html; charset=iso-8859-1\r\n";
$Msg1;
//@mail($useremail,$Subjectnew123,$Msg1,$headers1);
@mail($mailcopy,$Subject1,$Msg1,$headers1);
//$Delete_Question = "DELETE FROM tbl_appointment WHERE `id`='$id'";
//$Result_Question = mysql_query($Delete_Question);
////$Query_delete = "DELETE from tbl_appointment where id='$id'";
//$name_delete=$DB->query($Query_delete);
header("location:appointment_details.php?msg=sucess");
}
?>
Success! Data Deleted Sucessfully.
| S.No |
Receipt No |
Reference |
Name |
Booked Date |
Mobile No |
Appointment Date |
City |
Problem |
= CURDATE() order by appointment_date asc ";
$Query = "SELECT * from tbl_appointment where status='1' order by appointment_date asc";
$namesss=$DB->query($Query);
$nsssss=mysql_num_rows($namesss);
$manssss='0';
while ($rowsss = mysql_fetch_array($namesss)) {
$pundai_order_id=$rowsss['id'];
$date=$rowsss['date'];
$me_id=$rowsss['mem_id'];
$status=$rowsss['status'];
$document_name=$rowsss['document_name'];
$Query = "SELECT * from `tbl_member` where id='$me_id' ";
$name=$DB->query($Query);
$no=mysql_num_rows($name);
$row = mysql_fetch_array($name);
$skypeid=$row['skypeid'];
sprintf("%02d", $to_hour);
$docname=$rowsss['document_name'];
$new_email=$row['email'];
$men_country=$row['country'];
$new_phone=$row['phone'];
$name_mal=$row['name'];
$Query_user = "SELECT * from `shop_user` where phone='$new_phone' ";
$name_user=$DB->query($Query_user);
$no_user=mysql_num_rows($name_user);
$row_user = mysql_fetch_array($name_user);
$cur_1_dt2=date('Y-m-d');
$new_appointment_date=date('Y-m-d', strtotime($rowsss["appointment_date"]));
?>
0){
$set_id = mysqli_fetch_assoc($get_id);
$get_shop = mysqli_query($conn, "SELECT * FROM shop_user WHERE user_id = '".$set_id['dealer_id']."'");
$set_shop = mysqli_fetch_assoc($get_shop);
$reference = $set_shop['name'];
}else{
$reference = strtoupper($rowsss['vehicle']);
}
}else{
$reference = strtoupper($rowsss['vehicle']);
}
?>
style=" color:#0000FF;"
$new_appointment_date) { ?> style=" color:#FF0000;"
>
|
OC- |
|
() |
|
|
:
|
USA
|
Rs3500
|
= '2021-12-17' order by appointment_date,hour_date,min_date asc ");
//$Query_job_move_free_job = mysql_query("SELECT * from shop_product where stock_status_id='0' and and appointment_date >= '$date' order by product_id desc ");
$nsssss=mysql_num_rows($Query_job_move_free_job);
$qty=1;
$si=0;
while($row_job_move_free_job = mysql_fetch_array($Query_job_move_free_job))
{
$pundai_order_id=$row_job_move_free_job['id'];
$pun_id=$row_job_move_free_job['mem_id'];
$cur_1_dt2_man=date('Y-m-d');
// $new_appointment_date_man=$row_job_move_free_job['appointment_date'];
$new_appointment_date_man=date('Y-m-d', strtotime($row_job_move_free_job["appointment_date"]));
$Query_pu = mysql_query("SELECT * from tbl_staff where 1=1 and id='$pun_id' ");
$row_pu = mysql_fetch_array($Query_pu);
$num_padded = sprintf("%02d", $day);
$nnnn_year=$row_job_move_free_job['appointment_date'];
$tod_day = $nnnn_year;
$n_t_d=strtotime($tod_day);
$from_hour=$row_job_move_free_job['hour_date'];
$from_hour_1 = sprintf("%02d", $from_hour);
$from_min=$row_job_move_free_job['min_date'];
$from_min_1 = sprintf("%02d", $from_min);
$from_sta=$row_job_move_free_job['am_date'];
$new_time_ma = ''.$from_hour_1.':'.$from_min_1.' '.$from_sta.'';
$new_time_ma_1=strtotime($new_time_ma);
$id=$new_time_ma_1;
$m_id=$n_t_d;
?>
style=" color:#0000FF;"
$new_appointment_date_man) { ?> style=" color:#FF0000"
>
|
Direct |
|
() |
|
|
:
|
|
|