Orders
| Order |
Order No |
Date |
Status |
Total |
Bill |
Actions |
query($Query);
$nsssss=mysql_num_rows($Query);
$increment = $nsssss +1;
$manssss='0';
while ($rowsss = mysql_fetch_array($Query)) {
$contry=$rowsss['contry'];
$state=$rowsss['state'];
$orid=$rowsss['orid'];
$order_tc_id =$rowsss['order_tc_id'];
$new_orid =$rowsss['orid'];
$userid =$rowsss['userid'];
"SELECT a.ordid from tbl_order as a,shop_product as b where a.productid=b.product_id and b.v_s='0' and a.orderid='$orid' ";
$Query_jobmal_shipping_devidiya = mysql_query("SELECT a.ordid from tbl_order as a,shop_product as b where a.productid=b.product_id and b.v_s='0' and a.orderid='$orid' ");
//$name_pundai=$DB->query($Query_jobmal_shipping_devidiya);
$qty_devidiya=mysql_num_rows($Query_jobmal_shipping_devidiya);
$objitem = mysql_query("SELECT * from tbl_order where orderid='$orid'");
$x=0;
$qty_new=0;
$qty_new1=0;
$new_qty_1_1=0;
while ($Fetitem = mysql_fetch_array($objitem))
{
$cust_id=$Fetitem['user_id'];
$qty_new=$Fetitem['qty'];
$product_id_new=$Fetitem['productid'];
$qty_new=$Fetitem['qty'];
$unit_pr_new=$Fetitem['price'];
$tot_price_new=$Fetitem['totprice'];
$Query_12_new = mysql_query("SELECT * from `shop_product` where product_id='$product_id_new'");
$no_new=mysql_num_rows($Query_12_new);
$row_12_new = mysql_fetch_array($Query_12_new);
$weight=$row_12_new['stock_status_id'];
if($new_status==1)
{
if($vstatus==1)
{
$v_qty=($qty_new/2);
}
if($vstatus==7)
{
$v_qty=($qty_new/2);
}
if($vstatus==6)
{
$v_qty=($qty_new/2);
}
if($vstatus==2)
{
$v_qty=($qty_new/4);
}
$x = (int)$v_qty;
}
else
{
$x=0;
}
$weight=$row_12_new['stock_status_id'];
if($weight=='' || $weight==0)
{
$weight=100;
}
$qty_new_1=($qty_new+$x);
$new_qty=($weight*$qty_new_1);
$new_qty_1_1 +=$new_qty;
}
/*weight calculation*/
$new_qty_1_1;
$new_kilo_41=($new_qty_1_1/1000);
$new_kilo_5 = explode('.',$new_kilo_41);
$new_kilo_6=($new_kilo_5[0]+1);
if($pundai_order_id>495)
{
$kudhi=0;
}
else
{
$kudhi=10;
}
$Query_oo = mysql_query("SELECT * from `tbl_order` where orderid='$orid' ");
//$name_oo=$DB->query($Query_oo);
$no_oo=mysql_num_rows($name_oo);
$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);
$subtotal_123=$Fetchnewww['amtTotal'];
$del_ti = mysql_query("select deliverytime1 from tbl_confirmorder where orid = '$orid'");
$del_time = mysql_fetch_array($del_ti);
$offer=$rowsss['offer'];
$subtotal_123=($subtotal_123-($subtotal_123*($offer/100)));
$subtotal_123=number_format((float)$subtotal_123, 2, '.', '');
$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);
$contry;
?>
query($Query_job_move_courier);
$row_job_move_courier= mysql_fetch_array($Query_job_move_courier);
//$courier_fees=$row_job_move_courier['amount'];
//$courier_fees_para_1=$row_job_move_courier['amount'];
$pundai_order_id;
if($pundai_order_id>495)
{
$courier_fees=$row_job_move_courier['amount'];
$courier_fees_para_1=$row_job_move_courier['amount'];
}
else
{
$courier_fees=$row_job_move_courier['amount'];
$courier_fees_para_1=$row_job_move_courier['amount'];
}
$courier_fees;
if($courier_fees=='')
{
$Query_job_move_courier_1= mysql_query("SELECT * from tbl_courier_charges where state='Others' ");
//$name_12_w=$DB->query($Query_job_move_courier_1);
$row_job_move_courier_1= mysql_fetch_array($Query_job_move_courier_1);
$new_date_mal =$rowsss['order_date_time'];
$new_date_mal_1 = date("Y-m-d",strtotime($new_date_mal));
date_default_timezone_set('Asia/Kolkata');
$date_mal_1 = date('2020-10-06', time());
$curdate_mal_1 = strtotime($new_date_mal_1);
$curdate_mal_2 = strtotime($date_mal_1);
if($curdate_mal_1<$curdate_mal_2)
{
$courier_fees=300;
}
else
{
$courier_fees=$row_job_move_courier_1['amount'];
}
$subtotal_123;
$packing_charges123=round((($subtotal_123*$kudhi)/100));
$packing_charges=round((($subtotal_123*$kudhi)/100));
$courier_fees=($courier_fees);
}
}
else
{
$tot_weight_2_int=$new_qty_1_1;
$Query_q= mysql_query("SELECT * from tbl_courier_charges_country where state='$contry' ");
//$Query_job_move_courier_country=$DB->query($Query_q);
$row_job_move_courier_country= mysql_fetch_array($Query_q);
$num_max_ship_int=mysql_num_rows($Query_job_move_courier_country);
if($num_max_ship_int>0)
{
$courier_fees_country=$row_job_move_courier_country['amount'];
$courier_fees_country_extra=$row_job_move_courier_country['additional_amount'];
}
else
{
$Query_jo= mysql_query("SELECT * from tbl_courier_charges_country where state='Others' ");
//$Query_job_move_courier_country=$DB->query($Query_jo);
$row_job_move_courier_country= mysql_fetch_array($Query_jo);
$courier_fees_country=$row_job_move_courier_country['amount'];
$courier_fees_country_extra=$row_job_move_courier_country['additional_amount'];
}
if($tot_weight_2_int<=500)
{
$courier_fees_country_1=$courier_fees_country;
$new_kilo_4=$courier_fees_country_1;
}
else
{
$tot_weight_2_int_1=($tot_weight_2_int-500);
$tot_weight_2_int_1_2=($tot_weight_2_int_1/250);
$new_kilo_5_int = explode('.',$tot_weight_2_int_1_2);
$new_kilo_6_int=$new_kilo_5_int[0];
$new_kilo_6_int_7=($new_kilo_6_int+1);
$new_kilo_6_int_7_8=($courier_fees_country_extra*$new_kilo_6_int_7);
$courier_fees_country_1=($courier_fees_country+$new_kilo_6_int_7_8);
$new_kilo_4=$courier_fees_country_1;
}
}
$subtotal_123;
$new_kilo_6;
$new_courier=(($courier_fees*$new_kilo_6));
?>
|
|
|
through "" Tracking No.
""
on ""
|
|
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);
?>
|
|
Rs. |
|
| 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'];
$new_status=$rowsss_app['new_status'];
$dt_c=date('Y-m-d');
// if($email_dd != ''){
$Query = mysql_query("SELECT * from tbl_appointment ta inner join tbl_member tm on ta.mem_id = tm.id where tm.phone='$phon' and appointment_date>'$dt_c' ");
// $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'];
?>
|
: |
Cancel Appointment
Cancelled
|
