/
home
/
u775757334
/
domains
/
civicwelllife.com
/
public_html
/
management
/
admin
/
/home/u775757334/domains/civicwelllife.com/public_html/management/admin
mkdir
upload
Name
Size
Mode
Actions
api/
-
0755
rm
dataQuery/
-
0755
rm
dist/
-
0755
rm
fonts/
-
0755
rm
function/
-
0755
rm
icons/
-
0755
rm
images/
-
0755
rm
include/
-
0755
rm
js/
-
0755
rm
loginQuery/
-
0755
rm
scripts/
-
0755
rm
styles/
-
0755
rm
vendor/
-
0755
rm
add-product.php
18141
0644
edit
dl
rm
apply-fresh.php
26904
0644
edit
dl
rm
banner-list.php
15940
0644
edit
dl
rm
banner.php
15867
0644
edit
dl
rm
blog-list.php
15943
0644
edit
dl
rm
blog.php
17027
0644
edit
dl
rm
brand-list.php
15920
0644
edit
dl
rm
brand-logo-list.php
15299
0644
edit
dl
rm
brand-logo.php
16979
0644
edit
dl
rm
brand.php
16209
0644
edit
dl
rm
brocher-list.php
15713
0644
edit
dl
rm
career-enquiry-list.php
16537
0644
edit
dl
rm
categories-list.php
17202
0644
edit
dl
rm
categories.php
17416
0644
edit
dl
rm
change-password.php
11770
0644
edit
dl
rm
city-list.php
16215
0644
edit
dl
rm
city.php
16082
0644
edit
dl
rm
company-list.php
15504
0644
edit
dl
rm
company-office-list.php
15811
0644
edit
dl
rm
company-office.php
16131
0644
edit
dl
rm
company-profile.php
19643
0644
edit
dl
rm
company-stock.php
16999
0644
edit
dl
rm
company.php
21073
0644
edit
dl
rm
course-list.php
16177
0644
edit
dl
rm
course.php
19406
0644
edit
dl
rm
customer-list.php
18027
0644
edit
dl
rm
customer-order-list.php
20938
0644
edit
dl
rm
customer.php
18812
0644
edit
dl
rm
day.php
13822
0644
edit
dl
rm
dbc.php
6617
0644
edit
dl
rm
delivered-parcel-list.php
26169
0644
edit
dl
rm
distributor-list.php
17837
0644
edit
dl
rm
distributor-order-details.php
17018
0644
edit
dl
rm
distributor-order-list.php
22259
0644
edit
dl
rm
distributor.php
19110
0644
edit
dl
rm
enquiry-list.php
16660
0644
edit
dl
rm
export-data.php
16892
0644
edit
dl
rm
favicon.ico
1150
0644
edit
dl
rm
forgot-password.php
4019
0644
edit
dl
rm
gallery-list.php
15893
0644
edit
dl
rm
gallery.php
16793
0644
edit
dl
rm
genrate-customer-order.php
25330
0644
edit
dl
rm
genrate-lead-list.php
19566
0644
edit
dl
rm
genrate-lead.php
24067
0644
edit
dl
rm
genrate-order.php
22370
0644
edit
dl
rm
home.php
16384
0644
edit
dl
rm
import-deliver-report.php
18563
0644
edit
dl
rm
import-manager-user.php
20714
0644
edit
dl
rm
import-mis-report.php
21161
0644
edit
dl
rm
index.php
4739
0644
edit
dl
rm
inward-report-list.php
21518
0644
edit
dl
rm
lead-category-list.php
15237
0644
edit
dl
rm
lead-category.php
18615
0644
edit
dl
rm
lead-list.php
15963
0644
edit
dl
rm
lead-status-list.php
15374
0644
edit
dl
rm
lead-status.php
18394
0644
edit
dl
rm
lead.php
23475
0644
edit
dl
rm
manager-list.php
16921
0644
edit
dl
rm
manager-user-list.php
27810
0644
edit
dl
rm
media-list.php
17533
0644
edit
dl
rm
media.php
14839
0644
edit
dl
rm
menu-category-list.php
15739
0644
edit
dl
rm
menu-category.php
16257
0644
edit
dl
rm
menu-list.php
15953
0644
edit
dl
rm
menu.php
16723
0644
edit
dl
rm
message.php
3033
0644
edit
dl
rm
mis-report-list.php
17045
0644
edit
dl
rm
mis-sample.csv
483
0644
edit
dl
rm
my-order-list.php
21040
0644
edit
dl
rm
my-product-stock.php
17959
0644
edit
dl
rm
my-retailer-order-list.php
20688
0644
edit
dl
rm
news-list.php
17941
0644
edit
dl
rm
news.php
17396
0644
edit
dl
rm
online-product-list.php
19468
0644
edit
dl
rm
online-product.php
17214
0644
edit
dl
rm
order-details.php
20698
0644
edit
dl
rm
order-list.php
23106
0644
edit
dl
rm
order-list2.php
22470
0644
edit
dl
rm
parcel-details-list.php
27146
0644
edit
dl
rm
parcel-request-list.php
27666
0644
edit
dl
rm
partners-list.php
15975
0644
edit
dl
rm
partners.php
17715
0644
edit
dl
rm
pdf-category-list.php
17954
0644
edit
dl
rm
pdf-category.php
16234
0644
edit
dl
rm
pdf-list.php
18100
0644
edit
dl
rm
pdf.php
18717
0644
edit
dl
rm
poster-list.php
15925
0644
edit
dl
rm
poster.php
16129
0644
edit
dl
rm
print-bill.php
25616
0644
edit
dl
rm
print-customer-bill.php
25378
0644
edit
dl
rm
product-list.php
18289
0644
edit
dl
rm
product.php
22375
0644
edit
dl
rm
project-category.php
19504
0644
edit
dl
rm
project-image-list.php
17805
0644
edit
dl
rm
project-image.php
17612
0644
edit
dl
rm
project-list.php
18233
0644
edit
dl
rm
project-product-list.php
17820
0644
edit
dl
rm
project-product.php
18483
0644
edit
dl
rm
project.php
19003
0644
edit
dl
rm
receive-product-list.php
17978
0644
edit
dl
rm
receive-product.php
19682
0644
edit
dl
rm
retail-print-bill.php
26362
0644
edit
dl
rm
retailer-genrate-order.php
22367
0644
edit
dl
rm
retailer-list.php
17825
0644
edit
dl
rm
retailer-order-details.php
17213
0644
edit
dl
rm
retailer-order-list.php
21049
0644
edit
dl
rm
retailer.php
19086
0644
edit
dl
rm
rm-order-list.php
22360
0644
edit
dl
rm
rm-user-list.php
17766
0644
edit
dl
rm
rm-user.php
19056
0644
edit
dl
rm
service-list.php
17589
0644
edit
dl
rm
service.php
15818
0644
edit
dl
rm
setting.php
19923
0644
edit
dl
rm
show-student-list.php
20558
0644
edit
dl
rm
size-list.php
16053
0644
edit
dl
rm
size.php
15517
0644
edit
dl
rm
source-list.php
15217
0644
edit
dl
rm
source.php
18382
0644
edit
dl
rm
staff-list.php
15906
0644
edit
dl
rm
staff.php
17700
0644
edit
dl
rm
state-list.php
15944
0644
edit
dl
rm
state.php
15242
0644
edit
dl
rm
stock-transaction.php
17998
0644
edit
dl
rm
stock.php
16317
0644
edit
dl
rm
team-list.php
16019
0644
edit
dl
rm
team.php
16318
0644
edit
dl
rm
testimonial-list.php
15969
0644
edit
dl
rm
testimonial.php
16399
0644
edit
dl
rm
university-list.php
17911
0644
edit
dl
rm
university.php
18601
0644
edit
dl
rm
upload-brocher.php
18118
0644
edit
dl
rm
user-list.php
16591
0644
edit
dl
rm
user.php
21410
0644
edit
dl
rm
view-lead.php
23641
0644
edit
dl
rm
view-product.php
18105
0644
edit
dl
rm
website-setting.php
12534
0644
edit
dl
rm
Edit:
/home/u775757334/domains/civicwelllife.com/public_html/management/admin/print-bill.php
(25616B)
<?php include'loginQuery/session_start.php'; include'dbc.php';?> <!DOCTYPE html> <html> <head> <meta charset="utf-8"> <meta content="width=device-width, initial-scale=1.0" name="viewport"> <meta content="IE=edge" http-equiv="X-UA-Compatible"> <!-- Page title --> <title> Order </title> <!-- Place favicon.ico and apple-touch-icon.png in the root directory --> <!--<link rel="shortcut icon" type="image/ico" href="favicon.ico" />--> <!-- Vendor styles --> <?php include'include/header-file.php';?> <!--select feild css--> <link rel="stylesheet" href="vendor/select2-3.5.2/select2.css" /> <link rel="stylesheet" href="vendor/select2-bootstrap/select2-bootstrap.css" /> <link rel="stylesheet" href="vendor/bootstrap-touchspin/dist/jquery.bootstrap-touchspin.min.css" /> <link rel="stylesheet" href="vendor/datatables.net-bs/css/dataTables.bootstrap.min.css" /> </meta> </meta> </meta> </head> <body class="hide-sidebar"> <!-- Header --> <?php include'include/header.php';?> <!-- Header End--> <!-- Navigation --> <?php include'include/side-menu.php';?> <!-- Navigation --> <!-- Main Wrapper --> <div id="wrapper"> <!----------------start top normal header---------------------> <!----------------end top normal header---------------------> <!--model window--> <!--model window--> <div class="content "> <div class="row"> <div class="col-lg-12"> <div class="hpanel"> <div class="panel-body"> <!------------------------------------------------> <?php $user_id =$_SESSION['userid']; $sqlc =mysqli_query($conn,"select * from $tblCompanyProfile where user_id='$user_id'") or die(mysqli_error()); $rowc = mysqli_fetch_assoc($sqlc); $orderID= $_GET['orderid']; $sql =mysqli_query($conn,"select * from $tblOrder where order_id='$orderID'") or die(mysqli_error()); $row = mysqli_fetch_assoc($sql); extract($row); $sqld =mysqli_query($conn,"select * from $tblCompanyProfile where user_id='$distributor_id'") or die(mysqli_error()); $rowd = mysqli_fetch_assoc($sqld); $sqlMA =mysqli_query($conn,"select * from tbl_product") or die(mysqli_error()); while($rowMA=mysqli_fetch_assoc($sqlMA)) { $key = $rowMA['id']; $productNameAry[$key] = "{$rowMA['name']}<br><span style='font-size: 11px;color: #8e8a8a'>{$rowMA['description']}</span>"; } ?> <?php /*$sqlMA =mysqli_query($conn,"select * from tbl_courier_services") or die(mysqli_error()); while($rowMA=mysqli_fetch_assoc($sqlMA)) { $key = $rowMA['id']; $courierNameAry[$key] = $rowMA['name']; }*/ ?> <style> @media print { #printtable { width:100%; visibility: visible; /* margin-top: 0; padding-top: 0; */ margin-top: -90px !important; margin-bottom: 5px; } body{ visibility:hidden; margin-top:0px; padding-top:0px; } #header{ display:none; } #menu{ display:none; } } table{ margin-bottom: 5px !important; } .table > thead > tr > th, .table > tbody > tr > th, .table > tfoot > tr > th, .table > thead > tr > td, .table > tbody > tr > td, .table > tfoot > tr > td { padding: 4px !important; } </style> <div class="clearfix"></div> <div id="printtable"> <h3 class="text-center"><strong>TAX INVOICE</strong></h3> <table class="table table-striped table-bordered table-hover" > <thead> <tr> <th colspan="4" > <div class="row"> <div class="col-sm-3"> <img src="../media/image/<?= $rowc['image1'] ?>" class="img-fluid"> </div> <div class="col-sm-9"> <strong class="text-uppercase" style='font-size:15px'><?= $rowc['company_name'] ?></strong> <p style='font-weight: 500;font-size:14px'> <?= $rowc['address1'] ?><br> <?= $rowc['address2'] ?><br> GSTIN/UIN: <?= $rowc['gst_number'] ?><br> State Name: <?= $rowc['state'] ?><br> Contact: <?= $rowc['contact_number'] ?><br> Email: <?= $rowc['email'] ?> </p> </div> </div> </th> <th colspan="4" align="top" style='position: relative;'> <table class="table" style='position: absolute;top: -1px;width: 90%;'> <tbody> <tr> <td>Invoice No</td> <td>:<?= $row['order_id'] ?></td> </tr> <tr> <td>Date</td> <td>:<?= $row['order_date'] ?></td> </tr> <tr> <Td colspan='2'>Terms of Delivery</Td> </tr> </tbody> </table> </th> </tr> <tr> <td colspan="8" > <div class="row"> <div class="col-sm-6"> <p style='margin:0'>Consignee(Ship to)</p> <strong class="text-uppercase" style='font-size:15px'> <?= $rowd['company_name'] ?></strong> <p style='font-weight: 500;font-size:14px'> <?= $rowd['address1'] ?>,<?= $rowd['address2'] ?> </p> <table class="table-borderless"> <tr> <td>GSTIN/UIN</td> <td>: <?= $rowd['gst_number'] ?></td> </tr> <tr> <td>State Name</td> <td>: <?= $rowd['state'] ?></td> </tr> <tr> <td>Contact Person</td> <td>: <?= $rowd['name'] ?></td> </tr> <tr> <td>Contact</td> <td>: <?= $rowd['contact_number'] ?>,<?= $rowd['email'] ?></td> </tr> </table> </div> <div class="col-sm-6"> <p style='margin:0'>Buyer (Bill to)</p> <strong class="text-uppercase" style='font-size:15px'> <?= $rowd['company_name'] ?></strong> <p style='font-weight: 500;font-size:14px'> <?= $rowd['address1'] ?>,<?= $rowd['address2'] ?> </p> <table class="table-borderless"> <tr> <td>GSTIN/UIN</td> <td>: <?= $rowd['gst_number'] ?></td> </tr> <tr> <td>State Name</td> <td>: <?= $rowd['state'] ?></td> </tr> <tr> <td>Contact Person</td> <td>: <?= $rowd['name'] ?></td> </tr> <tr> <td>Contact</td> <td>: <?= $rowd['contact_number'] ?>,<?= $rowd['email'] ?></td> </tr> </table> </div> </div> </td> </tr> <tr> <th rowspan="2">S.No</th> <th rowspan="2">Description of Goods</th> <th rowspan="2">HSN/SAC</th> <th rowspan="2">Qty</th> <th rowspan="2">Price</th> <th colspan="2">IGST</th> <th rowspan="2">Amount(<i class="fa fa-inr"></i>)</th> </tr> <tr> <th>%</th> <th>Amt.</th> </tr> </thead> <tbody> <?php $oid=$_GET['orderid']; $i=1; $total=0; $shiptotal=0; $temp_total=0; $temp_shiptotal=0; $gstAmount=0; $sql=mysqli_query($conn,"select * from $tblOrderDetails where order_id='$oid'")or die(mysqli_error()); while($row=mysqli_fetch_assoc($sql)) { $gstAmount+=$row['gst_amount']; ?> <tr> <td><?= $i++;?></td> <td ><?= $productNameAry[$row['product_id']]?></td> <td ><?= $row['hsn_code']?></td> <td><?= $row['quantity'];?></td> <td><?= $row['price'];?></td> <td><?= $row['gst_rate'];?>%</td> <td><?= $row['gst_amount'];?></td> <!-- <td><i class="fa fa-inr"></i> <?= $row['gst_amount'];?></td> --> <td><?= $row['total'];?></td> </tr> <?php }?> <tr style="background-color:#f1f1f1"> <td rowspan="3" colspan="4" > Total In Words<br> <strong><i><?php $paybleAmount = round($gstAmount+$total_amount,2); echo amountToWords($paybleAmount) ?></i></strong> </td> <td colspan="3" align="right"> <strong>Sub Total</strong> </td> <td><i class="fa fa-inr"></i> <?php echo $total_amount;?></td> </tr> <tr style="background-color:#f1f1f1"> <td colspan="3" align="right"><strong>GST</strong></td> <td><i class="fa fa-inr"></i> <?php $gstAmount; echo $gstAmount; ?></td> </tr> <tr style="background-color:#f1f1f1"> <td colspan="3" align="right"><strong>Total Amount</strong></td> <td><i class="fa fa-inr"></i> <?php echo round($gstAmount+$total_amount,2); ?></td> </tr> <!-- <tr > <td colspan="3" > </td> <td colspan="5"></td> </tr> --> </tbody> </table> <div class="row"> <div class="col-sm-7"> <strong>Bank Details</strong>:<?= $rowc['bank_name'] ?> A/c No. <?= $rowc['account_number'] ?> | IFSC: <?= $rowc['branch_name'] ?> & <?= $rowc['ifsc_code'] ?> Terms & Conditions<br> 1. Goods once sold will not be taken back.<br> 2. Interest @ 18% p.a. for delayed payment.<br> 3. Seller is not responsible for any loss or damage of goods in transit.<br> 4. Subject to 'Agra' Jurisdiction only. </div> <div class="col-sm-1"></div> <div class="col-sm-4"> <p>Receiver's Signature :<br> </p> <p></p> </div> </div> </div> </div> <button style="margin:0 auto; display:block; margin-top:5px;" onClick="myFunction()" class="btn btn-success"><i class="fa fa-print"></i> Print Report</button> <div id="showrecord"> </div> </div> </div> </div> <!-- Footer--> <?php function convertToWords($number) { $units = array('', 'one', 'two', 'three', 'four', 'five', 'six', 'seven', 'eight', 'nine'); $teens = array('ten', 'eleven', 'twelve', 'thirteen', 'fourteen', 'fifteen', 'sixteen', 'seventeen', 'eighteen', 'nineteen'); $tens = array('', 'ten', 'twenty', 'thirty', 'forty', 'fifty', 'sixty', 'seventy', 'eighty', 'ninety'); $numWords = ""; if ($number < 10) { $numWords = $units[$number]; } elseif ($number < 20) { $numWords = $teens[$number - 10]; } elseif ($number < 100) { $numWords = $tens[(int)($number / 10)] . " " . $units[$number % 10]; } elseif ($number < 1000) { $numWords = $units[(int)($number / 100)] . " hundred " . convertToWords($number % 100); } elseif ($number < 1000000) { $numWords = convertToWords((int)($number / 1000)) . " thousand " . convertToWords($number % 1000); } elseif ($number < 1000000000) { $numWords = convertToWords((int)($number / 1000000)) . " million " . convertToWords($number % 1000000); } else { $numWords = "Number too large to convert"; } return $numWords; } function amountToWords($amount) { $number = number_format($amount, 2, '.', ''); $numArr = explode('.', $number); $dollars = (int)$numArr[0]; $cents = isset($numArr[1]) ? (int)$numArr[1] : 0; $dollarsWords = convertToWords($dollars); $centsWords = convertToWords($cents); $output = ucfirst($dollarsWords) . " INR"; if ($cents > 0) { $output .= " and " . ucfirst($centsWords) . " Paise"; } return $output; } ?> <?php include'include/footer-file.php';?> <!--select feild css--> <script src="vendor/bootstrap-touchspin/dist/jquery.bootstrap-touchspin.min.js"></script> <script src="vendor/select2-3.5.2/select2.min.js"></script> <!-- App scripts --> </body> </html> <script type="text/javascript"> //======================= add name start ==================================*/ //======================= add name end ==================================*/ $(document).on('click','.page-link',function(){ var pageID=$(this).attr("pageid"); var status=$(this).attr("pageid2"); var getbackurl=$("#getbackurl").val(); $("#showrecord").html('<center><i class="fa fa-spinner fa-spin" aria-hidden="true"></i></center>'); var cid= $("#applicationid").val(); var getquerystring= $("#getquerystring").val(); $.ajax({ type: "POST", url: "function/getOrderPageList.php", data: "pageID="+ pageID+"&getquerystring="+getquerystring, success: function(html){ $("#showrecord").html(html); } }); return false; }); </script> <!--<script type="text/javascript" charset="utf8" src="http://ajax.aspnetcdn.com/ajax/jQuery/jquery-2.0.3.js"></script>--> <script type="text/javascript"> $(document).ready(function(){ $('.pagination').pagination({ items: <?php echo $total_records;?>, itemsOnPage: <?php echo $limit;?>, cssStyle: 'light-theme', currentPage : <?php echo $page;?>, hrefTextPrefix : 'brands-list.php?page=' }); }); </script> <!-- DataTables --> <script src="vendor/datatables/media/js/jquery.dataTables.min.js"></script> <script src="vendor/datatables.net-bs/js/dataTables.bootstrap.min.js"></script> <script src="vendor/datatables.net-buttons/js/buttons.html5.min.js"></script> <script src="vendor/datatables.net-buttons/js/buttons.print.min.js"></script> <script src="vendor/datatables.net-buttons/js/dataTables.buttons.min.js"></script> <script src="vendor/datatables.net-buttons-bs/js/buttons.bootstrap.min.js"></script> <script> $(function () { // Initialize Example 1 $('#example1').dataTable( { "ajax": 'api/datatables.json', dom: "<'row'<'col-sm-4'l><'col-sm-4 text-center'B><'col-sm-4'f>>tp", "lengthMenu": [ [10, 25, 50, -1], [10, 25, 50, "All"] ], buttons: [ {extend: 'copy',className: 'btn-sm'}, {extend: 'csv',title: 'ExampleFile', className: 'btn-sm'}, {extend: 'pdf', title: 'ExampleFile', className: 'btn-sm'}, {extend: 'print',className: 'btn-sm'} ] }); // Initialize Example 2 $('#example2').dataTable(); }); </script> <link rel="stylesheet" href="dist/simplePagination.css" /> <script src="dist/jquery.simplePagination.js"></script> <script> $(function(){ $("#form_2").validate({ rules: { name: { required: true, minlength: 3 }, username: { required: true, minlength: 5 }, url: { required: true, url: true }, number: { required: true, number: true }, last_name: { required: true, minlength: 6 } }, messages: { number: { required: "(Please enter your phone number)", number: "(Please enter valid phone number)" }, last_name: { required: "This is custom message for required", minlength: "This is custom message for min length" } }, submitHandler: function(form) { form.submit(); }, errorPlacement: function(error, element) { $( element ) .closest( "form" ) .find( "label[for='" + element.attr( "id" ) + "']" ) .append( error ); }, errorElement: "span", }); }); </script> <script> $(function(){ $('#datepicker').datepicker(); $("#datepicker").on("changeDate", function(event) { $("#my_hidden_input").val( $("#datepicker").datepicker('getFormattedDate') ) }); $('#datapicker2').datepicker(); $('.input-group.date').datepicker({ }); $('.input-daterange').datepicker({ }); $("#demo1").TouchSpin({ min: 0, max: 100, step: 0.1, decimals: 2, boostat: 5, maxboostedstep: 10, }); $("#demo2").TouchSpin({ verticalbuttons: true }); $("#demo3").TouchSpin({ postfix: '%' }); $("#demo4").TouchSpin({ postfix: "a button", postfix_extraclass: "btn btn-default" }); $(".js-source-states").select2(); $(".js-source-states-2").select2(); //turn to inline mode $.fn.editable.defaults.mode = 'inline'; //defaults $.fn.editable.defaults.url = '#'; //editables $('#username').editable({ url: '#', type: 'text', pk: 1, name: 'username', title: 'Enter username' }); $('#firstname').editable({ validate: function(value) { if($.trim(value) == '') return 'This field is required'; } }); $('#sex').editable({ prepend: "not selected", source: [ {value: 1, text: 'Male'}, {value: 2, text: 'Female'} ], display: function(value, sourceData) { var colors = {"": "gray", 1: "green", 2: "blue"}, elem = $.grep(sourceData, function(o){return o.value == value;}); if(elem.length) { $(this).text(elem[0].text).css("color", colors[value]); } else { $(this).empty(); } } }); $('#dob').editable(); $('#event').editable({ placement: 'right', combodate: { firstItem: 'name' } }); $('#comments').editable({ showbuttons: 'bottom' }); $('#fruits').editable({ pk: 1, limit: 3, source: [ {value: 1, text: 'banana'}, {value: 2, text: 'peach'}, {value: 3, text: 'apple'}, {value: 4, text: 'watermelon'}, {value: 5, text: 'orange'} ] }); $('#user .editable').on('hidden', function(e, reason){ if(reason === 'save' || reason === 'nochange') { var $next = $(this).closest('tr').next().find('.editable'); if($('#autoopen').is(':checked')) { setTimeout(function() { $next.editable('show'); }, 300); } else { $next.focus(); } } }); // ClockPicker $('.clockpicker').clockpicker({autoclose: true}); // DateTimePicker $('#datetimepicker1').datetimepicker(); }); </script> <script> function myFunction() { window.print(); } </script>
Save
cmd:
run