1#@!#!123s

file_get_contents 1#@!#!123s
: / home / u247928417 / domains / fruitbagan.com / public_html / admin / reports /
Filename : download-purchase-list.php
back
<?php
include ("../session/session.php");
include ("../config/config.php");
//xls download function start here
  function cleanData($str)
  {
    $str = preg_replace("/\t/", "\\t", $str);
    $str = preg_replace("/\r?\n/", "\\n", $str);
    if(strstr($str, '"')) $str = '"' . str_replace('"', '""', $str) . '"';
  }

  // filename for download
  $filename = "purchase-list-" . date('d-m-Y') . ".xls";

  header("Content-Disposition: attachment; filename=\"$filename\"");
  header("Content-Type: application/vnd.ms-excel");
 //xls download function end here
 
 if($_REQUEST['vendor_id']!='' and $_REQUEST['product_id']==''){
	
	$search="where purchase_vendor_id='".$_REQUEST['vendor_id']."' ";	
	
}
else if($_REQUEST['product_id']!='' and $_REQUEST['vendor_id']==''){
	
	$search="where purchase_product_id='".$_REQUEST['product_id']."' ";	
	
}
else if($_REQUEST['product_id']!='' and $_REQUEST['vendor_id']!=''){
	
	$search="where purchase_product_id='".$_REQUEST['product_id']."' and purchase_vendor_id='".$_REQUEST['vendor_id']."' ";	
	
}
else{
	
	$search="";
}
 
$product_images = "select `purchase_vendor_id`, `purchase_product_id`, `product_previous_quantity`, `purchase_product_quantity`, `current_product_quantity`, `product_per_quantity_price`, `total_quantity_product_price`, `date_purchase`,`product_name`,`vendor_name`,`product_pec_weight`,`vendor_id`,`purchase_id` from inventory_purchase t1
left join inventory_vendors t2 on t1.purchase_vendor_id=t2.vendor_id
left join interface_product t3 on t1.purchase_product_id=t3.product_id 
left join interface_price t4 on t3.product_id=t4.product_id ".$search."";
$product_images_result =mysqli_query($conn,$product_images) or die(mysqli_error());
$product_images_row = mysqli_num_rows($product_images_result);

 ?>
 <table class="table table-striped table-bordered" style="background-color:#333;color:#fff;">
 <tr>
 <th colspan="9">
 Purchase Details
 </th>
 </tr>
 </table>
 
 <table class="table table-striped table-bordered" style="border:2px solid #ccc;padding:5px;" border="1">
                              <thead>
                                                    <tr>
                                                        <th> S No. </th>
                                                        <th> Vendor Name</th>
                                                        <th> Product Name </th>
                                                        <th> Product Previous Quantity</th>
                                                        <th> Purchase Product Quantity </th>
                                                        <th> Current Product Quantity</th>
                                                        <th> Product Per Quantity Price</th>
                                                        <th> Total Quantity Product Price</th>
                                                        <th> Date Purchase</th>
                                                       
                                                    </tr>
                                                </thead>

                                                <tbody>
                                                    <?php
                                                    $i = 1;
                                                    if ($product_images_row) {
                                                        while ($product_data = mysqli_fetch_assoc($product_images_result)) {
                                                          
													$total_current_product_quantity +=$product_data['current_product_quantity'];														  
                                                     ?>
                                                            <tr>
                                                                <td><?php echo $i; ?></td>
                                                                <td><?php echo $product_data['vendor_name']; ?></td>
                                                                <td><?php echo $product_data['product_name'].' '.$product_data['product_pec_weight']; ?></td>
                                                                <td><?php echo $product_data['product_previous_quantity']; ?></td>
                                                                <td><?php echo $product_data['purchase_product_quantity']; ?></td>
                                                                <td><?php echo $product_data['current_product_quantity']; ?></td>
                                                                <td><?php echo $product_data['product_per_quantity_price']; ?></td>
                                                                <td><?php echo $product_data['total_quantity_product_price']; ?></td>
                                                                <td><?php echo date('d-m-Y',strtotime($product_data['date_purchase'])); ?></td>
                                                               
                                                            </tr>
                                                            <?php
                                                            $i++;
                                                        }
                                                    } else {
                                                        echo '<tr ><td colspan="9" style="text-align:center;">';
                                                        echo 'No Customer !</td></tr>';
                                                    }
													if ($product_images_row>0) {
													if($_REQUEST['vendor_id']!='' or $_REQUEST['product_id']!=''){
                                                    ?>
														<tr>
                                                                <td colspan="5"><b>Total</b></td>
                                                                <td><b><?php echo number_format($total_current_product_quantity, 2, '.', ''); ?></b></td>
                                                                <td colspan="3">&nbsp;</td>
                                                              
                                                              
                                                            </tr>
													<?php }
													
													 }?>
                                                    
                                                </tbody>
                                            </table>