Orders
Order |
Date |
Status |
Total |
Bill |
Actions |
query($Query);
$nsssss=mysql_num_rows($Query);
$manssss='0';
while ($rowsss = mysql_fetch_array($Query)) {
$orid=$rowsss['orid'];
$objitem = mysql_query("SELECT * from tbl_order where orderid='$orid'");
$Fetitem = mysql_fetch_array($objitem);
$cust_id=$Fetitem['user_id'];
$objqrynewsubee = mysql_query("SELECT SUM(totprice) AS amtTotal FROM tbl_order where orderid='$orid'");
//$name_12_123=$DB->query($objqrynewsubee);
$Fetchnewww = mysql_fetch_array($objqrynewsubee);
?>
$or_status=$rowsss['orderstatus'];
if($or_status==0)
{
$or_status_pu="Processing";
}
if($or_status==1)
{
$or_status_pu="Confirmed";
}
if($or_status==5)
{
$or_status_pu="Packed";
}
if($or_status==15)
{
$or_status_pu="Ready to Dispatch";
}
if($or_status==2)
{
$or_status_pu="Dispatched";
$courier_no=$rowsss['courier_no'];
$courier_name=$rowsss['couriername'];
}
if($or_status==3)
{
$or_status_pu="Delivered";
}
?>
echo $si=$si+1;?> |
echo $rowsss['order_date_time'];?> |
echo $or_status_pu;?>
if($or_status==2)
{
?>
Courier Name: echo $courier_name;?>
Courier No: echo $courier_no;?>
}
?>
|
echo $Fetchnewww['amtTotal'];?> |
Download |
view |
}
?>
Orders View
S.No |
Product Name |
Price |
Qty |
query($Query);
$nsssss=mysql_num_rows($Query);
$manssss='0';
while ($rowsss = mysql_fetch_array($Query)) {
$productid=$rowsss['productid'];
$objitem = mysql_query("SELECT * from shop_product where product_id='$productid'");
$Fetitem = mysql_fetch_array($objitem);
//$cust_id=$Fetitem['user_id'];
//$objqrynewsubee = mysql_query("SELECT SUM(totprice) AS amtTotal FROM tbl_order where orderid='$orid'");
//$name_12_123=$DB->query($objqrynewsubee);
//$Fetchnewww = mysql_fetch_array($objqrynewsubee);
?>
echo $si=$si+1;?> |
echo $Fetitem['name'];?> |
Rs. echo $Fetitem['price'];?> |
echo $rowsss['qty'];?> |
}
?>
Appointment Details
S.No |
Appointment Date |
Cancel Appointment |
query($Query);
$nsssss_app=mysql_num_rows($Query_ap);
$rowsss_app = mysql_fetch_array($Query_ap);
$phon=$rowsss_app['phone'];
$email_dd=$rowsss_app['email'];
$dt_c=date('Y-m-d');
$Query = mysql_query("SELECT * from tbl_appointment where email_id='$email_dd' and appointment_date>'$dt_c' ");
//$namesss=$DB->query($Query);
$nsssss=mysql_num_rows($Query);
$manssss='0';
while ($rowsss = mysql_fetch_array($Query)) {
$withdraw_status=$rowsss['status'];
$ap_date= $rowsss['appointment_date'];
$ap_hour= sprintf("%02d",$rowsss['hour_date']);
$ap_min= sprintf("%02d",$rowsss['min_date']);
$ap_sec= $rowsss['am_date'];
?>
echo $si=$si+1;?> |
echo $ap_date;?> echo $ap_hour;?>: echo $ap_min;?> echo $ap_sec;?> |
if($withdraw_status==1)
{
?>
Cancel Appointment
}
?>
if($withdraw_status==4)
{
?>
Cancelled
}
?>
|
}
?>
$ses_u_id=$_SESSION["userid"];
$objqrynewsubee = "SELECT * FROM shop_user where user_id='$ses_u_id'";
$objResultnewsubee = mysql_query($objqrynewsubee);
$Fetchnewww = mysql_fetch_array($objResultnewsubee);
$gender=$Fetchnewww['gender'];
$language=$Fetchnewww['language'];
$dob=$Fetchnewww['dob'];
$id_lang=$Fetchnewww['language'];
// $time=strtotime($dob);
//$dob=date('m/d/Y', strtotime($dob));
$country=$Fetchnewww['country'];
?>