0) { while ($set_user = mysqli_fetch_assoc($get_user)){ array_push($disc_arr, $set_user['user_id']); } } $get_disc = mysqli_query($conn, "SELECT discount FROM shop_user where user_id='$dealer_id'"); $set_disc = mysqli_fetch_assoc($get_disc); $disc = $set_disc['discount']; $arr = array("11363"); if(in_array($dealer_id, $disc_arr)){ ?>




Contact:
Order Id :
Date :
0){ while($set_dist=mysqli_fetch_assoc($get_dist)){ $get_ref = mysqli_query($conn, "SELECT * FROM tbl_confirmorder where orderid='".$set_dist['ref_id']."' and orderstatus not in (90)"); $mycheck = mysqli_num_rows($get_ref); if($mycheck > 0){ $set_ref = mysqli_fetch_assoc($get_ref); $get_tot = mysqli_query($conn, "SELECT sum(totprice) as totprice FROM tbl_order where orderid='".$set_dist['ref_id']."'"); $set_tot = mysqli_fetch_assoc($get_tot); $discount = $set_ref['offer']; $temp_disc = ($set_tot['totprice'] * $discount) / 100; $disc_amount = $set_tot['totprice'] - $temp_disc; echo $set_ref['refid'].' = '.round($disc_amount).' Dt: '.date('d-m-Y', strtotime($set_ref['order_date_time'])).'
'; } } } ?>

Anbu Phaarmaa

> 0){ while($set_list = mysqli_fetch_assoc($get_list)){ $get_prod = mysqli_query($conn, "select * from shop_product where product_id='".$set_list['prod_id']."'"); $set_prod = mysqli_fetch_assoc($get_prod); if($set_prod['vstatus']==10 || $set_prod['vstatus']==11){ $str='class="strikethrough" style="color:red"'; ?> > 0){ while($set_list = mysqli_fetch_assoc($get_list)){ $get_prod = mysqli_query($conn, "select * from shop_product where product_id='".$set_list['prod_id']."'"); $set_prod = mysqli_fetch_assoc($get_prod); if($set_prod['vstatus']==10 || $set_prod['vstatus']==11){ $str='class="strikethrough" style="color:red"'; ?> >
# Product Content Rate Qty Total
DELETED
NO STOCK
CANCELLED
TOTAL:
% DISCOUNT:
NET TOTAL:

Energy Foods

> 0){ while($set_list = mysqli_fetch_assoc($get_list)){ $get_prod = mysqli_query($conn, "select * from shop_product where product_id='".$set_list['prod_id']."'"); $set_prod = mysqli_fetch_assoc($get_prod); if($set_prod['vstatus']==2 || $set_prod['vstatus']==7){ $str='class="strikethrough" style="color:red"'; ?> > 0){ while($set_list = mysqli_fetch_assoc($get_list)){ $get_prod = mysqli_query($conn, "select * from shop_product where product_id='".$set_list['prod_id']."'"); $set_prod = mysqli_fetch_assoc($get_prod); if($set_prod['vstatus']==2 || $set_prod['vstatus']==7){ $str='class="strikethrough" style="color:red"'; ?> >
# Product Content Rate Qty Total
DELETED
NO STOCK
CANCELLED
TOTAL:
% DISCOUNT:
NET TOTAL:
PRINT




Contact:
Order Id :
Date :
0){ while($set_dist=mysqli_fetch_assoc($get_dist)){ $get_ref = mysqli_query($conn, "SELECT * FROM tbl_confirmorder where orderid='".$set_dist['ref_id']."' and orderstatus not in (90)"); $mygcheck = mysqli_num_rows($get_ref); if($mygcheck > 0){ $set_ref = mysqli_fetch_assoc($get_ref); $get_tot = mysqli_query($conn, "SELECT sum(totprice) as totprice FROM tbl_order where orderid='".$set_dist['ref_id']."'"); $set_tot = mysqli_fetch_assoc($get_tot); echo $set_ref['refid'].' = '.$set_tot['totprice'].' Dt: '.$set_ref['order_date_time'].'
'; } } } ?>

ANBU PHAARMAA

> 0){ while($set_list = mysqli_fetch_assoc($get_list)){ $get_prod = mysqli_query($conn, "select * from shop_product where product_id='".$set_list['prod_id']."'"); $set_prod = mysqli_fetch_assoc($get_prod); if($set_prod['vstatus']==10 || $set_prod['vstatus']==11){ $str='class="strikethrough" style="color:red"'; ?> > 0){ while($set_list = mysqli_fetch_assoc($get_list)){ $get_prod = mysqli_query($conn, "select * from shop_product where product_id='".$set_list['prod_id']."'"); $set_prod = mysqli_fetch_assoc($get_prod); if($set_prod['vstatus']==10 || $set_prod['vstatus']==11){ $str='class="strikethrough" style="color:red"'; ?> >
# Product Content Rate Qty Total
DELETED
NO STOCK
CANCELLED
TOTAL:

ENERGY FOODS

> 0){ while($set_list = mysqli_fetch_assoc($get_list)){ $get_prod = mysqli_query($conn, "select * from shop_product where product_id='".$set_list['prod_id']."'"); $set_prod = mysqli_fetch_assoc($get_prod); if($set_prod['vstatus']==2 || $set_prod['vstatus']==7){ $str='class="strikethrough" style="color:red"'; ?> > 0){ while($set_list = mysqli_fetch_assoc($get_list)){ $get_prod = mysqli_query($conn, "select * from shop_product where product_id='".$set_list['prod_id']."'"); $set_prod = mysqli_fetch_assoc($get_prod); if($set_prod['vstatus']==2 || $set_prod['vstatus']==7){ $str='class="strikethrough" style="color:red"'; ?> >
# Product Content Rate Qty Total
DELETED
NO STOCK
CANCELLED
TOTAL:




Contact:
Order Id :
Date :
0){ while($set_dist=mysqli_fetch_assoc($get_dist)){ $get_ref = mysqli_query($conn, "SELECT * FROM tbl_confirmorder where orderid='".$set_dist['ref_id']."' and orderstatus not in (90)"); $mygcheck = mysqli_num_rows($get_ref); if($mygcheck > 0){ $set_ref = mysqli_fetch_assoc($get_ref); $get_tot = mysqli_query($conn, "SELECT sum(totprice) as totprice FROM tbl_order where orderid='".$set_dist['ref_id']."'"); $set_tot = mysqli_fetch_assoc($get_tot); echo $set_ref['refid'].' = '.$set_tot['totprice'].'
'; } } } ?>

ANBU PHAARMAA

> 0){ while($set_list = mysqli_fetch_assoc($get_list)){ $get_prod = mysqli_query($conn, "select * from shop_product where product_id='".$set_list['prod_id']."'"); $set_prod = mysqli_fetch_assoc($get_prod); if($set_prod['vstatus']==10 || $set_prod['vstatus']==11){ $str='class="strikethrough" style="color:red"'; ?> > 0){ while($set_list = mysqli_fetch_assoc($get_list)){ $get_prod = mysqli_query($conn, "select * from shop_product where product_id='".$set_list['prod_id']."'"); $set_prod = mysqli_fetch_assoc($get_prod); if($set_prod['vstatus']==10 || $set_prod['vstatus']==11){ $str='class="strikethrough" style="color:red"'; ?> >
# Product Content Rate Qty Total
DELETED
NO STOCK
CANCELLED
TOTAL:

ENERGY FOODS

> 0){ while($set_list = mysqli_fetch_assoc($get_list)){ $get_prod = mysqli_query($conn, "select * from shop_product where product_id='".$set_list['prod_id']."'"); $set_prod = mysqli_fetch_assoc($get_prod); if($set_prod['vstatus']==2 || $set_prod['vstatus']==7){ $str='class="strikethrough" style="color:red"'; ?> > 0){ while($set_list = mysqli_fetch_assoc($get_list)){ $get_prod = mysqli_query($conn, "select * from shop_product where product_id='".$set_list['prod_id']."'"); $set_prod = mysqli_fetch_assoc($get_prod); if($set_prod['vstatus']==2 || $set_prod['vstatus']==7){ $str='class="strikethrough" style="color:red"'; ?> >
# Product Content Rate Qty Total
DELETED
NO STOCK
CANCELLED
TOTAL: