芝麻web文件管理V1.00

编辑当前文件:/home/krishnamexports/public_html/panel/pages/order/orderInvoice.php

<?php

if(isset($_GET['order_id']))

{

$order_id       = $_GET['order_id'];

$sqlInvoice     = mysqli_query($cn,"select *,sum(total),sum(delivery_charge) from `tbl_order` where `order_id`='".$order_id."'");

$sqlInvoiceData = mysqli_fetch_array($sqlInvoice);

}

$sql     = mysqli_query($cn, "select * from tbl_home where id='1'");

$sqlData = mysqli_fetch_array($sql);

<h6 class="card-title">Order Invoice</h6>

<button type="button" class="btn btn-light btn-sm ml-3" onclick='printDiv();'><i class="icon-printer mr-2"></i> Print</button>

</div>

@import "css/style.css";

</style>

<style>

.table thead th {

vertical-align: bottom;

border: 1px solid #000;

}

.table th, .table td {

padding: 10px 3px;

vertical-align: top;

border: 1px solid #000;

}

</style>

<img src="../logo/<?php echo $sqlData['logo'];?>" class="mb-3 mt-2" alt="logo" style="width:150px;">

<p class="my-2"><strong>MOBILE : </strong> <?php echo $sqlData['contact'];?></span></p>

</ul>

</div>

<h4 class="text-primary mb-2 mt-md-2">Invoice #<?php echo $order_id;?></h4>

<li>Invoice Date: <span class="font-weight-semibold"><?php echo date('F d, Y',strtotime($sqlInvoiceData['date']));?></span></li>

</ul>

</div>

<span class="text-muted">CUSTOMR DETAIL</span>

<p class="my-2"><strong>EMAIL : </strong> <?php echo $sqlInvoiceData['email'];?></span></p>

<p class="my-2"><strong>MOBILE : </strong> <?php echo $sqlInvoiceData['phone'];?></span></p>

<p class="my-2"><strong>ALT. CONTACT : </strong> <?php echo $sqlInvoiceData['alternate_mobile'];?></span></p>

<h6>ADDRESS</h6>

<p class="my-2"><strong>LANDMARK : </strong> <?php echo $sqlInvoiceData['landmark'];?></span></p>

</ul>

</div>

<span class="text-muted">PAYMENT DETAILS</span>

<li><h5 class="my-2">Total Amount : </h5></li>

<li>Payment Mode : </li>

</ul>

</ul>

</div>

<thead>

<tr>

<th>Description</th>

</tr>

</thead>

<tbody>

<?php

$sr = 1;

$sqlInvoice2     = mysqli_query($cn,"select * from `tbl_order` where `order_id`='".$order_id."'");

while($sqlInvoiceData2 = mysqli_fetch_array($sqlInvoice2))

{

$sqlProduct     = mysqli_query($cn,"select * from `tbl_product` where `id`='".$sqlInvoiceData2['product_id']."'");

$sqlProductData = mysqli_fetch_array($sqlProduct);

<tr>

<td>

<?php if(!empty($sqlInvoiceData2['size'])){?>

<?php }?>

<?php if(!empty($sqlInvoiceData2['polish'])){?>

<h6><strong>POLISH : </strong> <span><?php echo $sqlInvoiceData2['polish'];?></span></h6>

<?php }?></h6>

</td>

</tr>

<?php }?> 
                     <tr>
                            <th width="10%">Remark</th>
                            <th width="80%" colspan="4"><?php echo $sqlInvoiceData['notes'];?></th>                            
                        </tr>

</tbody>

</table>

</div>

<br />

<tr>

<span class="text-muted" style="font-size:16px;">OUR BANK DETAIL</span>

<li><strong>Account Holder Name :</strong> <?php echo $sqlData['ac_name'];?></li>

<li><strong>Branch Name :</strong> <?php echo $sqlData['branch'];?></li>

<li><strong>Account Number :</strong> <?php echo $sqlData['ac_no'];?></li>

<li><strong>SWIFT CODE :</strong> <?php echo $sqlData['swift_code'];?> </li>

</ul>

</div>

</td>

</tr>

<!--<tr>

<span class="text-muted" style="font-size:16px;">Term & Conditions</span>

<li>Subject to Jaipur Jurisdiction.</li>

<li>Goods once sold will not taken back.</li>

<li>Interest @ 18% will be charged if will is not paid with 3 days.</li>

</ul>

</td>

</tr>-->

</table>

</div>

<tr>

<li style="text-align:right;"><strong>Autorised Signature</strong></li>

</ul>

</td>

</tr>

</table>

</div>

<style>

.text-muted, .preview-list .preview-item .preview-item-content p .content-category{color:#000 !important;font-weight:600;}

</style>

function printDiv()

{

var divToPrint=document.getElementById('DivIdToPrint');

var newWin=window.open('','Print-Window');

newWin.document.open();

newWin.document.write('<html><body onload="window.print()">'+divToPrint.innerHTML+'</body></html>');

newWin.document.close();

setTimeout(function(){newWin.close();},10);

}

</script>