EVOLUTION-NINJA

Edit File: billing_madeups_report_new.php

text-transform: uppercase !important;

}
.ui-jqgrid tr.jqgrow td{ 
text-transform: uppercase !important;
}
</style>
<div class="page-content-wrapper">
<div class="page-content">

<h3 class="page-title">
 Billing Madeups 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 Maseups Report </a></li>
		</ul>
	</div>

<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> 
	<div class="row" style="overflow: scroll;">
		<table id="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=""> OSL # </th>   
		                    <th class="">Order Type</th>
		                    <th class="">HSN</th>
		                    <th class="">Size</th>
		                   
		                    <th class="">Article </th>
		                    <th class="">Exported Qty</th>
		                    <th class="">SSL Shade</th>
							<th class="">Buyer Shade</th>
							<th class="">Batch #</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=""> OSL # </th>   
		                    <th class="">Order Type</th>
		                    <th class="">HSN</th>
		                    <th class="">Size</th>
		                   
		                    <th class="">Article </th>
		                    <th class="">Exported Qty</th>
		                    <th class="">SSL Shade</th>
							<th class="">Buyer Shade</th>
							<th class="">Batch #</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="https://cdn.datatables.net/1.10.20/js/jquery.dataTables.min.js"></script>
<link href="https://cdn.datatables.net/1.10.20/css/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_madeups_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);
			            row.push(val.sys_date);
			            row.push(val.ssl_pc_no);
			            row.push(val.order_type);	
			            row.push(val.hsn_code);
			            row.push(val.size);
			            row.push(val.article);
			            row.push(val.exp_qty);
			            row.push(val.shades);
			            row.push(val.buyer_shades);
			            row.push(val.batch_no);
			            
			           
			            row.push(val.unitprice);
			            var exp_qty=0;
			            if(val.exp_qty!='')
			            {
			            	exp_qty=val.exp_qty;
			            }
			            
			            var unitprice=0;
			            if(val.unitprice!='')
			            {
			            	unitprice=val.unitprice;
			            }
			            var value_final_amount=parseFloat(unitprice)*parseFloat(exp_qty);
			            var value_final=value_final_amount.toFixed(2);
			            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);
			            //row.push(val.type);
			            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+'</td>';
						cons +='<td>'+val.sys_date+'</td>';
						cons +='<td>'+val.ssl_pc_no+'</td>';
						
						cons +='<td>'+val.order_type+'</td>';
						cons +='<td>'+val.hsn_code+'</td>';
						cons +='<td>'+val.size+'</td>';
						
						cons +='<td>'+val.article+'</td>';
						cons +='<td>'+val.exp_qty+'</td>';
						cons +='<td>'+val.shades+'</td>';
						cons +='<td>'+val.buyer_shades+'</td>';
						cons +='<td>'+val.batch_no+'</td>';
						cons +='<td>'+val.unitprice+'</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);
	                 	datatable.clear();
					    datatable.rows.add(table_row).draw();
					    datatable.draw(); 
	              }
	             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,
    });  
});