= $set_info['name']; ?>
= nl2br($set_info['address']); ?>
= nl2br($set_info['city']); ?>
= nl2br($set_info['state'].' '.$set_info['postcode']); ?>
Contact: = $set_info['phone']; ?>
Order Id : = $ref_no ?>
Date : = date('d-m-Y H:i:s',strtotime($set_deal['order_date_time'])) ?>
REQUEST AMOUNT : = $sub_tot; ?>
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'])).'
';
}
}
echo '';
echo 'BILLED AMOUNT: '.round($totprice).'';
echo '
';
}
?>
Anbu Phaarmaa
# |
Product |
Content |
Rate |
Request |
Amount |
Billed |
Amount |
>
= ($i=$i+1);?> |
= strtoupper($set_prod['name'])?> |
= $set_prod['product_url']?> |
= $set_list['price']?> |
= $set_list['qty']?> |
DELETED |
|
|
= $set_list['tot_price']; ?> |
= $set_ord['qty']?> |
= $set_ord['totprice']?> |
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"';
?>
>
= ($i=$i+1);?> |
= strtoupper($set_prod['name'])?> |
= $set_prod['product_url']?> |
= $set_list['price']?> |
= $set_list['qty']?> |
NO STOCK |
|
|
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"';
?>
>
= ($i=$i+1);?> |
= strtoupper($set_prod['name'])?> |
= $set_prod['product_url']?> |
= $set_list['price']?> |
= $set_list['qty']?> |
CANCELLED |
|
|
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"';
?>
>
= ($i=$i+1);?> |
= strtoupper($set_prod['name'])?> |
= $set_prod['product_url']?> |
= $set_list['price']?> |
= $set_list['qty']?> |
DELETED |
|
|
|
|
|
|
TOTAL: |
= round($amount);?> |
TOTAL: |
= round($billed_amount);?> |
|
|
|
|
= $disc ?>% DISCOUNT: |
= round($temp_disc);?> |
= $disc ?>% DISCOUNT: |
= round($bill_disc);?> |
|
|
|
|
NET TOTAL: |
= round($net_total);?> |
NET TOTAL: |
= round($net_disc);?> |
Energy Foods
# |
Product |
Content |
Rate |
Request |
Amount |
Billed |
Amount |
>
= ($i=$i+1);?> |
= strtoupper($set_prod['name'])?> |
= $set_prod['product_url']?> |
= $set_list['price']?> |
= $set_list['qty']?> |
DELETED |
|
|
= $set_list['tot_price']; ?> |
= $set_ord['qty']?> |
= $set_list['totprice']?> |
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"';
?>
>
= ($i=$i+1);?> |
= strtoupper($set_prod['name'])?> |
= $set_prod['product_url']?> |
= $set_list['price']?> |
= $set_list['qty']?> |
NO STOCK |
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"';
?>
>
= ($i=$i+1);?> |
= strtoupper($set_prod['name'])?> |
= $set_prod['product_url']?> |
= $set_list['price']?> |
= $set_list['qty']?> |
CANCELLED |
|
|
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"';
?>
>
= ($i=$i+1);?> |
= strtoupper($set_prod['name'])?> |
= $set_prod['product_url']?> |
= $set_list['price']?> |
= $set_list['qty']?> |
DELETED |
|
|
|
|
|
|
TOTAL: |
= round($amount);?> |
TOTAL: |
= round($billed_amount);?> |
|
|
|
|
= $disc ?>% DISCOUNT: |
= round($temp_disc);?> |
= $disc ?>% DISCOUNT: |
= round($bill_disc);?> |
|
|
|
|
NET TOTAL: |
= round($net_total);?> |
NET TOTAL: |
= round($net_disc);?> |
= $set_info['name']; ?>
= nl2br($set_info['address']); ?>
= nl2br($set_info['city']); ?>
= nl2br($set_info['state'].' '.$set_info['postcode']); ?>
Contact: = $set_info['phone']; ?>
Order Id : = $ref_no ?>
Date : = date('d-m-Y H:i:s',strtotime($set_deal['order_date_time'])) ?>
REQUEST AMOUNT : = $sub_tot; ?>
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: '.date('d-m-Y', strtotime($set_ref['order_date_time'])).'
';
}
}
echo '';
echo 'BILLED AMOUNT: '.round($totprice).'';
echo '
';
}
?>
Anbu Phaarmaa
# |
Product |
Content |
Rate |
Request |
Amount |
Billed |
Amount |
>
= ($i=$i+1);?> |
= strtoupper($set_prod['name'])?> |
= $set_prod['product_url']?> |
= $set_list['price']?> |
= $set_list['qty'] .' + '. $set_list['free_qty']?> |
DELETED |
|
|
= $set_list['tot_price']; ?> |
= $set_ord['qty'] .' + '. $set_ord['freeqty']?> |
= $set_ord['totprice']?> |
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){
$amount+=$set_list['tot_price'];
$str='class="strikethrough" style="color:red"';
?>
>
= ($i=$i+1);?> |
= strtoupper($set_prod['name'])?> |
= $set_prod['product_url']?> |
= $set_list['price']?> |
= $set_list['qty'] .' + '. $set_list['free_qty']?> |
NO STOCK |
|
|
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){
$amount+=$set_list['tot_price'];
$str='class="strikethrough" style="color:red"';
?>
>
= ($i=$i+1);?> |
= strtoupper($set_prod['name'])?> |
= $set_prod['product_url']?> |
= $set_list['price']?> |
= $set_list['qty'] .' + '. $set_list['free_qty']?> |
CANCELLED |
|
|
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){
$amount+=$set_list['tot_price'];
$str='class="strikethrough" style="color:red"';
?>
>
= ($i=$i+1);?> |
= strtoupper($set_prod['name'])?> |
= $set_prod['product_url']?> |
= $set_list['price']?> |
= $set_list['qty'] .' + '. $set_list['free_qty']?> |
DELETED |
|
|
|
|
|
|
TOTAL: |
= round($amount);?> |
TOTAL: |
= round($billed_amount);?> |
Energy Foods
# |
Product |
Content |
Rate |
Request |
Amount |
Billed |
Amount |
>
= ($i=$i+1);?> |
= strtoupper($set_prod['name'])?> |
= $set_prod['product_url']?> |
= $set_list['price']?> |
= $set_list['qty'] .' + '. $set_list['free_qty']?> |
DELETED |
|
|
= $set_list['tot_price']; ?> |
= $set_ord['qty'] .' + '. $set_ord['freeqty']?> |
= $set_ord['totprice']?> |
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){
$amount+=$set_list['tot_price'];
$str='class="strikethrough" style="color:red"';
?>
>
= ($i=$i+1);?> |
= strtoupper($set_prod['name'])?> |
= $set_prod['product_url']?> |
= $set_list['price']?> |
= $set_list['qty'] .' + '. $set_list['free_qty']?> |
NO STOCK |
|
|
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){
$amount+=$set_list['tot_price'];
$str='class="strikethrough" style="color:red"';
?>
>
= ($i=$i+1);?> |
= strtoupper($set_prod['name'])?> |
= $set_prod['product_url']?> |
= $set_list['price']?> |
= $set_list['qty'] .' + '. $set_list['free_qty']?> |
CANCELLED |
|
|
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){
$amount+=$set_list['tot_price'];
$str='class="strikethrough" style="color:red"';
?>
>
= ($i=$i+1);?> |
= strtoupper($set_prod['name'])?> |
= $set_prod['product_url']?> |
= $set_list['price']?> |
= $set_list['qty'] .' + '. $set_list['free_qty']?> |
DELETED |
|
|
|
|
|
|
TOTAL: |
= round($amount);?> |
TOTAL: |
= round($billed_amount);?> |
= $set_info['name']; ?>
= nl2br($set_info['address']); ?>
= nl2br($set_info['city']); ?>
= nl2br($set_info['state'].' '.$set_info['postcode']); ?>
Contact: = $set_info['phone']; ?>
Order Id : = $ref_no ?>
Date : = date('d-m-Y H:i:s',strtotime($set_deal['order_date_time'])) ?>
REQUEST AMOUNT : = $sub_tot; ?>
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);
echo $set_ref['refid'].' = '.$set_tot['totprice'].' Dt: '.date('d-m-Y', strtotime($set_ref['order_date_time'])).'
';
}
}
echo '';
echo 'BILLED AMOUNT: '.round($totprice).'';
echo '
';
}
?>
Anbu Phaarmaa
# |
Product |
Content |
Rate |
Request |
Amount |
Billed |
Amount |
>
= ($i=$i+1);?> |
= strtoupper($set_prod['name'])?> |
= $set_prod['product_url']?> |
= $set_list['price']?> |
= $set_list['qty']?> |
DELETED |
|
|
= $set_list['tot_price']; ?> |
= $set_ord['qty']?> |
= $set_ord['totprice']?> |
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){
$amount+=$set_list['tot_price'];
$str='class="strikethrough" style="color:red"';
?>
>
= ($i=$i+1);?> |
= strtoupper($set_prod['name'])?> |
= $set_prod['product_url']?> |
= $set_list['price']?> |
= $set_list['qty']?> |
NO STOCK |
|
|
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){
$amount+=$set_list['tot_price'];
$str='class="strikethrough" style="color:red"';
?>
>
= ($i=$i+1);?> |
= strtoupper($set_prod['name'])?> |
= $set_prod['product_url']?> |
= $set_list['price']?> |
= $set_list['qty']?> |
CANCELLED |
|
|
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){
$amount+=$set_list['tot_price'];
$str='class="strikethrough" style="color:red"';
?>
>
= ($i=$i+1);?> |
= strtoupper($set_prod['name'])?> |
= $set_prod['product_url']?> |
= $set_list['price']?> |
= $set_list['qty']?> |
DELETED |
|
|
|
|
|
|
TOTAL: |
= round($amount);?> |
TOTAL: |
= round($billed_amount);?> |
Energy Foods
# |
Product |
Content |
Rate |
Request |
Amount |
Billed |
Amount |
>
= ($i=$i+1);?> |
= strtoupper($set_prod['name'])?> |
= $set_prod['product_url']?> |
= $set_list['price']?> |
= $set_list['qty']?> |
DELETED |
|
|
= $set_list['tot_price']; ?> |
= $set_ord['qty']?> |
= $set_ord['totprice']?> |
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){
$amount+=$set_list['tot_price'];
$str='class="strikethrough" style="color:red"';
?>
>
= ($i=$i+1);?> |
= strtoupper($set_prod['name'])?> |
= $set_prod['product_url']?> |
= $set_list['price']?> |
= $set_list['qty']?> |
NO STOCK |
|
|
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){
$amount+=$set_list['tot_price'];
$str='class="strikethrough" style="color:red"';
?>
>
= ($i=$i+1);?> |
= strtoupper($set_prod['name'])?> |
= $set_prod['product_url']?> |
= $set_list['price']?> |
= $set_list['qty']?> |
CANCELLED |
|
|
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){
$amount+=$set_list['tot_price'];
$str='class="strikethrough" style="color:red"';
?>
>
= ($i=$i+1);?> |
= strtoupper($set_prod['name'])?> |
= $set_prod['product_url']?> |
= $set_list['price']?> |
= $set_list['qty']?> |
DELETED |
|
|
|
|
|
|
TOTAL: |
= round($amount);?> |
TOTAL: |
= round($billed_amount);?> |