EVOLUTION-NINJA

Edit File: billing_fabric_report_new.php

<script src="<?php echo base_url('assets/js/jquery.table2excel.js');?>"></script> <script src="<?php echo base_url('assets/js/jspdf.debug.js');?>"></script> <script src="<?php echo base_url('assets/js/jspdf.min.js');?>"></script> <script type="text/javascript" src="<?php echo base_url('assets/js/shim.min.js');?>"></script> <script type="text/javascript" src="<?php echo base_url('assets/js/xlsx.full.min.js');?>"></script> <script type="text/javascript" src="<?php echo base_url('assets/js/Blob.js');?>"></script> <script type="text/javascript" src="<?php echo base_url('assets/js/FileSaver.js');?>"></script> <style> .ui-jqgrid { text-transform: capitalize !important; } .tablediv { text-transform: uppercase !important; } .ui-jqgrid tr.jqgrow td{ text-transform: uppercase !important; } </style> <div class="page-content-wrapper"> <div class="page-content"> <!-- BEGIN PAGE HEADER--> <h3 class="page-title"> Billing Fabric Export Report </h3> <div class="page-bar"> <ul class="page-breadcrumb"> <li><i class="fa fa-home"></i> <a href="<?php echo base_url('dashboard/dashboard_fun');?>">Home</a> <i class="fa fa-angle-right"></i> <a href="#" > Billing Fabric Report </a></li> </ul> </div> <div class="row date_row"> <form class="filter_form"> <div class="col-md-3"> <div class="form-group"> <label class="control-label col-md-4">From Date :</label> <div class="col-md-8"> <input type="text" class="form-control input-group openDatePicker from_delivery_date_required_on" name="from_delivery_date_required_on" id="from_delivery_date_required_on" data-provide="datepicker"> </div> </div> </div> <div class="col-md-3"> <div class="form-group"> <label class="control-label col-md-4">To Date :</label> <div class="col-md-8"> <input type="text" class="form-control input-group openDatePicker to_delivery_date_required_on" name="to_delivery_date_required_on" id="to_delivery_date_required_on" data-provide="datepicker"> </div> </div> </div> <div class="col-md-3"> <button type="submit" class="btn btn-primary">Submit</button> </div> </form> <div class="col-md-3"> <button type="button" class="btn btn-primary" onclick="export_data();">Export</button> </div> </div> <!-- row -2--> <div class="row" style="overflow: scroll;"> <table class="table table-striped table-hover loans_table_print" style="border-spacing: 0px !important;" border="1"> <thead class="thead"> <tr style="background-color: #485b7f;color: white;" class="default"> <th class="">SL#</th> <th class="">Customer ID</th> <th class="">Customer Name </th> <th class="">Invoice #</th> <th class="">Invoice Date </th> <th class="">Order Type</th> <th class="">HSN</th> <th class="">Width</th> <th class="">Article </th> <th class="">Shade</th> <th class="">Buyer Shade</th> <th class="">SL Piece #</th> <th class="">Exported Qty</th> <th class="">Unit</th> <th class="">Unit Price</th> <th class="">Value</th> <th class="">Currency</th> <th class="">Country</th> <th class="">Contract Type</th> <th class="">Customer Order #</th> <th class="">Description</th> <th class="">Port Code</th> <th class="">Shipping Bill</th> <th class="">Shipping Bill Date</th> <th class="">Approved</th> <th class="">Shipped</th> <th class="">Payment</th> </tr> </thead> <tbody id="loans_table_body_prints"> <div id="wait" style="display:none;width:80px;height:95px;position:absolute;top:30%;left:45%;padding:2px;"><img src="<?php echo base_url();?>assets/loader.gif" width="64" height="64" /><br>Loading..</div> </tbody> </table> <div style="display:none;" class=""> <table id="export_table" class="table table-striped table-hover print_table" style="border-spacing: 0px !important;" border="1"> <thead class="thead"> <tr style="background-color: #485b7f;color: white;" class="default"> <th class="">SL#</th> <th class="">Customer ID</th> <th class="">Customer Name </th> <th class="">Invoice #</th> <th class="">Invoice Date </th> <th class="">Order Type</th> <th class="">HSN</th> <th class="">Width</th> <th class="">Article </th> <th class="">Shade</th> <th class="">Buyer Shade</th> <th class="">SL Piece #</th> <th class="">Exported Qty</th> <th class="">Unit</th> <th class="">Unit Price</th> <th class="">Value</th> <th class="">Currency</th> <th class="">Country</th> <th class="">Contract Type</th> <th class="">Customer Order #</th> <th class="">Description</th> <th class="">Port Code</th> <th class="">Shipping Bill</th> <th class="">Shipping Bill Date</th> <th class="">Approved</th> <th class="">Shipped</th> <th class="">Payment</th> </tr> </thead> <tbody class="loans_table_body_prints"> <div id="wait" style="display:none;width:80px;height:95px;position:absolute;top:30%;left:45%;padding:2px;"><img src="<?php echo base_url();?>assets/loader.gif" width="64" height="64" /><br>Loading..</div> </tbody> </table> </div> </div> </div> </div> </div> <script type="text/javascript" src="<?php echo base_url('assets/jquery.dataTables.min.js');?>"></script> <link href="<?php echo base_url('assets/jquery.dataTables.min.css');?>" rel="stylesheet" type="text/css"/> <script type="text/javascript"> $('.filter_form').submit(function(e){ e.preventDefault(); get_report(); }); get_report(); var datatable; var tbody = $('#loans_table_body_prints'); datatable = $('.loans_table_print').DataTable({ dom: 'Blfrtip', buttons: [ 'pageLength' ], buttons: [ 'excel' ] }); function get_report(){ var from=$('#from_delivery_date_required_on').val(); var to=$('#to_delivery_date_required_on').val(); $("#wait").css("display", "block"); $.ajax({ type : 'post', url : '<?php echo site_url('reports/billing_fabrics_report_data');?>', data : {'from':from,'to':to}, success:function(data){ $("#wait").css("display", "none"); response=jQuery.parseJSON(data); $("#wait").css("display", "none"); if(response.result==1) { $('#loans_table_body_prints').empty(); $('.loans_table_body_prints').empty(); tbody.empty(); var table_row = []; var cons=''; $.each(response.message, function(key, val){ var sl=key+1; var row = []; row.push(sl); row.push(val.customerID); row.push(val.customer_name); row.push(val.invoice_num); row.push(val.sys_date); row.push(val.order_type); row.push(val.hsn_code); row.push(val.width); row.push(val.article); row.push(val.shades); row.push(val.buyer_shades); row.push(val.ssl_pc_no); row.push(val.exp_qty); var exp_qty=0; if(val.exp_qty!='') { exp_qty=val.exp_qty; } var type=0; if(val.type!='') { type=val.type; } var value_final_amount=parseFloat(type)*parseFloat(exp_qty); var value_final=value_final_amount.toFixed(2); //alert(value_final_amount); row.push(val.units); row.push(val.type); row.push(value_final); row.push(val.currency); row.push(val.country); row.push(val.contarct_type); row.push(val.order_no); row.push(val.description); row.push(val.shipping_port_code); row.push(val.shipping_bill_num); row.push(val.shipping_bill_date); row.push(val.confirm); row.push(val.shipped); row.push(val.payment); table_row.push(row); cons +='<tr>'; cons +='<td>'+sl+'</td>'; cons +='<td>'+val.customerID+'</td>'; cons +='<td>&nbsp'+val.customer_name+'</td>'; cons +='<td>'+val.invoice_num+'</td>'; cons +='<td>'+val.sys_date+'</td>'; cons +='<td>'+val.order_type+'</td>'; cons +='<td>'+val.hsn_code+'</td>'; cons +='<td>'+val.width+'</td>'; cons +='<td>'+val.article+'</td>'; cons +='<td>'+val.shades+'</td>'; cons +='<td>'+val.buyer_shades+'</td>'; cons +='<td>'+val.ssl_pc_no+'</td>'; cons +='<td>'+val.exp_qty+'</td>'; cons +='<td>'+val.units+'</td>'; cons +='<td>'+val.type+'</td>'; cons +='<td >'+value_final+'</td>'; cons +='<td >'+val.currency+'</td>'; cons +='<td>'+val.country+'</td>'; cons +='<td >'+val.contarct_type+'</td>'; cons +='<td>'+val.order_no+'</td>'; cons +='<td>'+val.description+'</td>'; cons +='<td>&nbsp'+val.shipping_port_code+'</td>'; cons +='<td>'+val.shipping_bill_num+'</td>'; cons +='<td>'+val.shipping_bill_date+'</td>'; cons +='<td>'+val.confirm+'</td>'; cons +='<td>'+val.shipped+'</td>'; cons +='<td>'+val.payment+'</td>'; cons +='</tr>'; }); // $('#loans_table_body_prints').append(cons); $('.loans_table_body_prints').append(cons); //$('.loans_table_print').DataTable(); datatable.clear(); datatable.rows.add(table_row).draw(); datatable.draw(); } else if(response.result==0) { alert('No data found'); } } }); } /*function get_report(){ var from=$('#from_delivery_date_required_on').val(); var to=$('#to_delivery_date_required_on').val(); $("#wait").css("display", "block"); $.ajax({ type : 'post', url : '<?php echo site_url('reports/billing_fabrics_report_data');?>', data : {'from':from,'to':to}, success:function(data){ $("#wait").css("display", "none"); response=jQuery.parseJSON(data); $("#wait").css("display", "none"); if(response.result==1) { $('#loans_table_body_prints').empty(); $('.loans_table_body_prints').empty(); var cons=''; $.each(response.message, function(key, val){ var sl=key+1; cons +='<tr>'; cons +='<td>'+sl+'</td>'; cons +='<td>'+val.customerID+'</td>'; cons +='<td>&nbsp'+val.customer_name+'</td>'; cons +='<td>'+val.invoice_num+'</td>'; cons +='<td>'+val.sys_date+'</td>'; cons +='<td>'+val.order_type+'</td>'; cons +='<td>'+val.hsn_code+'</td>'; cons +='<td>'+val.width+'</td>'; cons +='<td>'+val.article+'</td>'; cons +='<td>'+val.shades+'</td>'; cons +='<td>'+val.buyer_shades+'</td>'; cons +='<td>'+val.ssl_pc_no+'</td>'; cons +='<td>'+val.exp_qty+'</td>'; cons +='<td>'+val.units+'</td>'; cons +='<td>'+val.type+'</td>'; cons +='<td >'+val.total_value+'</td>'; cons +='<td >'+val.currency+'</td>'; cons +='<td>'+val.country+'</td>'; cons +='<td>'+val.order_no+'</td>'; cons +='<td>'+val.description+'</td>'; cons +='<td>&nbsp'+val.shipping_port_code+'</td>'; cons +='<td>'+val.shipping_bill_num+'</td>'; cons +='<td>'+val.shipping_bill_date+'</td>'; cons +='<td>'+val.confirm+'</td>'; cons +='<td>'+val.shipped+'</td>'; }); $('#loans_table_body_prints').append(cons); $('.loans_table_body_prints').append(cons); $('.loans_table_print').DataTable(); } else if(response.result==0) { alert('No data found'); } } }); }*/ $(function(){ $(".from_delivery_date_required_on").datepicker({ dateFormat: 'dd-mm-yy', }).on('changeDate', function(ev){ $('.from_delivery_date_required_on').datepicker('hide'); }); }); $('.from_delivery_date_required_on').on('change', function(){ var date = $(this).val(); $('.to_delivery_date_required_on').datepicker({ dateFormat: 'dd-mm-yy', minDate: date, }); }); function export_data() { doit('xlsx'); /*$(".print_table").table2excel({ exclude: ".noExl", name: "Excel Document Name", filename: "BillingFabric-Report", fileext: ".xlsx", exclude_img: true, exclude_links: true, exclude_inputs: true });*/ } function doit(type, fn, dl) { var elt = document.getElementById('export_table'); var wb = XLSX.utils.table_to_book(elt, {sheet:"Sheet JS"}); return dl ? XLSX.write(wb, {bookType:type, bookSST:true, type: 'base64'}) : XLSX.writeFile(wb, fn || ('Billing Fabric Report.' + (type || 'xlsx'))); } </script>