query($Query); $nsssss=mysql_num_rows($namesss); $manssss='0'; $si=0; $kjjj=0; $rowsss = mysql_fetch_array($namesss); $new_orid =$rowsss['orid']; $userid =$rowsss['user_id']; $varstatus =$rowsss['varstatus']; $varstatus =$rowsss['varstatus']; $orderid=$rowsss['orderid']; $contry=$rowsss['del_country']; $state=$rowsss['del_state']; $order_tc_id =$rowsss['order_tc_id']; $orderstatus =$rowsss['orderstatus']; if($contry=="India") { $sss="Rs"; } else { $sss="$"; } $Query = "SELECT * from `shop_user` where user_id='$userid' "; $name=$DB->query($Query); $no=mysql_num_rows($name); $row = mysql_fetch_array($name); $new_status=$row['new_status']; /*weight calculation*/ $Query_new = "SELECT * from shop_cart where trans='$tx_id'"; $namesss_new=$DB->query($Query_new); $nsssss_new=mysql_num_rows($namesss_new); $x=0; $qty_new=0; $qty_new1=0; $new_qty_1_1=0; while ($rowsss_new = mysql_fetch_array($namesss_new)) { $product_id_new=$rowsss_new['productid']; $qty_new=$rowsss_new['qty']; $unit_pr_new=$rowsss_new['price']; $tot_price_new=$rowsss_new['totprice']; $Query_12_new = "SELECT * from `shop_product` where product_id='$product_id_new' "; $name_12_new=$DB->query($Query_12_new); $no_new=mysql_num_rows($name_12_new); $row_12_new = mysql_fetch_array($name_12_new); $vstatus=$row_12_new['vstatus']; 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); echo $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); echo $new_kilo_6=($new_kilo_5[0]+1); echo $Query_oo = "SELECT * from `shop_cart` where trans='$tx_id' "; $name_oo=$DB->query($Query_oo); echo $no_oo=mysql_num_rows($name_oo); $objqrynewsubee = "SELECT SUM(totprice) AS amtTotal FROM shop_cart where trans='$tx_id'"; $name_12_123=$DB->query($objqrynewsubee); $Fetchnewww = mysql_fetch_array($name_12_123); $subtotal_123=$Fetchnewww['amtTotal']; /*shipping*/ $contry; $state; if($contry=="India") { $packing_charges=round((($subtotal_123*10)/100)); if($state=="Puducherry") { $packing_charges=0; } if($state=="Tamilnadu") { $packing_charges=0; } $Query_job_move_courier= "SELECT * from tbl_courier_charges where state='$state' "; $name_12=$DB->query($Query_job_move_courier); $row_job_move_courier= mysql_fetch_array($name_12); $courier_fees=$row_job_move_courier['amount']; $courier_fees_para_1=$row_job_move_courier['amount']; if($courier_fees=='') { $Query_job_move_courier_1= "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($name_12_w); $courier_fees=$row_job_move_courier_1['amount']; $subtotal_123; $packing_charges123=round((($subtotal_123*10)/100)); $packing_charges=round((($subtotal*10)/100)); $courier_fees=($courier_fees); } } else {} $new_courier=(($courier_fees*$new_kilo_6)+$packing_charges); /*shipping*/ if($no_oo>0) { if($orderstatus==0) { $par_status="Placed"; } if($orderstatus==1) { $par_status="Confirmed"; } if($orderstatus==2) { $par_status="Dispatched"; } if($orderstatus==3) { $par_status="Delivered"; } if($orderstatus==4) { $par_status="Refund"; } if($orderstatus==5) { $par_status="Packed"; } //sprintf("%02d", $to_hour); ?>

S.No.	Invoice No	Name	State	Mobile No	Amount	Qty	View
							View

Product Details