EVOLUTION-NINJA

Edit File: proforma_invoice_form.php

<?php echo view('includes/header');?>
<script src="<?php echo base_url('public/assets/admin_dashboard/js/jquery.table2excel.js');?>"></script>
	<section class="content-header">
				<h1>Proforma Invoice Form</h1>				
			</section> 
	
			<div role="tabpanel" class="tab-pane" id="tax">

<div class="form-group col-sm-12 col-md-4">
								<label class="col-sm-4 ">Select Holder Name</label>
								<select class="form-control col-sm-8 holder_name" name="holder_name" id="holder_name">
									<option value="">Select</option>
									<?php foreach($bank_details as $bank) { ?>
									<option value="<?php echo $bank->holder_name;?>"><?php echo $bank->holder_name;?></option>
									<?php } ?>
									
								</select>
							</div>	
																	
					  
						</div>	
						
									
					<div class="row land_owner_a">
							<div class="col-sm-4 col-md-4"></div>
							<div class="col-sm-4 col-md-4">
								<button type="submit" class="btn btn-primary center-block submit">Submit</button>
							</div>
							<div class="col-sm-4 col-md-4"></div>													
						</div> 
			
					</form>
		</div>
				<hr>

<section class="content">
				<div class="col-sm-12 col-md-12 buttons">
					<div style="display:none;">
						<table  border="1" style="border-spacing: 0px !important;" id="print_table" class="print_table"></table>
					</div>
								<button type="submit" class="btn btn-primary" onclick="print_page();" >Print</button>
								<button type="submit" class="btn btn-primary" onclick="export_page();">Export</button>
				</div>				
				<div id = "jaytab1" style="margin-top:3%;margin-left: -28px;" class="col-sm-12 grid">
					<div class="grid_div"></div>
					<table id="list1"></table>
			  			<div id="pager3"></div>
		     				<div id="dialogSelectRow3" title="Warning" style="display:none">
							 <p>Please select row</p>
		  					</div>
				</div>
			</section>
				 
  <div class="modal fade" id="edit_modal" role="dialog">
    <div class="modal-dialog modal-lg">
      <div class="modal-content">
        <div class="modal-header">
          <button type="button" class="close" data-dismiss="modal">&times;</button>
          <h4 class="modal-title">Update Invoice details</h4>
        </div>

<div class="modal-body">
         
         <form id="land_owner" class="form-inline update_form">
         <input type="hidden" class="form-control col-sm-8 invoice_id_pk" name="id" required="required">
					<div class="row land_owner_a">
						<div class="form-group col-sm-12 col-md-6">
								<label class="col-sm-4">Project Name</label>
								<div  id="project"></div>
							</div>
							<div class="form-group col-sm-12 col-md-6">
								<label class="col-sm-4">Site numbers</label>
								<input type="text" class="form-control col-sm-8 site_numbers" name="site_numbers" required="required">
							</div>
							
						</div>
							 
						<div class="row land_owner_a">	
							
							<div class="form-group col-sm-12 col-md-6">
								<label class="col-sm-4">Invoice number</label>
								<input type="text" class="form-control col-sm-8 invoice_number" name="invoice_number" required="required">
							</div>
							<div class="form-group col-sm-12 col-md-6">
								<label class="col-sm-4">Invoice Type</label>
								<input type="text" class="form-control col-sm-8 invoice_type" name="invoice_type" required="required">
							</div>

</div>
							 
						<div class="row land_owner_a">	
							<div class="form-group col-sm-12 col-md-6">
								<label class="col-sm-4">To</label>
								<input type="text" class="form-control col-sm-8 invoice_to" name="invoice_to">
							</div>
							<div class="form-group col-sm-12 col-md-6">
								<label class="col-sm-4 col-md-4">Bank</label>
								<div  id="pkgbody"></div>
							</div>
					 
									
							
							
					</div>
						 
						<div class="row land_owner_a">
						<div class="form-group col-sm-12 col-md-6">
								<label class="col-sm-4">Total Sqft</label>
								<input type="text" class="form-control col-sm-8 total_sqft" name="total_sqft">
							</div>
							<div class="form-group col-sm-12 col-md-6">
								<label class="col-sm-4">Rate Per Sqft</label>
								<input type="text" class="form-control col-sm-8 rate_per_sqft" name="rate_per_sqft">
							</div>		
						
							
						</div>
							 
					<div class="row land_owner_a">
												
							<div class="form-group col-sm-12 col-md-6">
								<label class="col-sm-4">Basic Amount</label>
								<input type="text" class="form-control col-sm-8 total_amt" name="total_amt">
							</div>
							<div class="form-group col-sm-12 col-md-6">
								<label class="col-sm-4">SGST</label>
								<input type="text" class="form-control col-sm-8 sgst" name="sgst">
							</div>
						
						
						
						
												
							
						</div>
						 
						<div class="row land_owner_a">
							<div class="form-group col-sm-12 col-md-6">
								<label class="col-sm-4">CGST</label>
								<input type="text" class="form-control col-sm-8 cgst" name="cgst">
							</div>
							<div class="form-group col-sm-12 col-md-6">
								<label class="col-sm-4">Total</label>
								<input type="text" class="form-control col-sm-8 total_withgst_amt" onfocusout="myFunction();" name="total_withgst_amt">
							</div>
						</div>
						
						<div class="row land_owner_a">
							<div class="col-sm-4 col-md-4"></div>
							<div class="col-sm-4 col-md-4">
								<button type="submit" class="btn btn-primary center-block submit">Submit</button>
							</div>
							<div class="col-sm-4 col-md-4"></div>													
						</div> 					
					</form>

</div>

</div>
    </div>
  </div>

a {
	 color: inherit; 
	}
	
	.form-control:focus, input[type="Submit"]:focus, input[type="button"]:focus {
				  border-color: #FF0000;
				  box-shadow: inset 0 1px 1px rgba(0, 0, 0, 0.075), 0 0 8px rgba(255, 0, 0, 0.6);
				}
				#FrmGrid_list2
				{
					width: 100% !important;
				}
				.ui-jqdialog .ui-jqdialog-titlebar
				{
					height: 29px !important;
					background-color: #001a00;
					color: white;
					padding-left: 10px;
				}
				.fm-button
				{
					height: 21px !important;
					padding: 1px;					
					margin-right: 10px !important;
					height: 21px !important;				    
				    width: 50%;
				    margin-top: -7px !important;
				}
				.ui-jqdialog-content td.navButton {
					padding-top: 12px !important;
				}
				.ui-jqgrid .ui-jqgrid-titlebar
				{
					height: 27px !important;
					background:#AF0100 !important;
					color:white !important;
				}
				.ui-jqgrid-bdiv
				{
					height: auto !important;
				}
				.ui-widget-overlay
				{
					z-index:0 !important;
				}
				.ui-resizable
				{
					z-index:9999 !important;
				}
				.ui-widget-header
				{
				background: #1e7ad7 !important;
				}
				.ui-jqgrid-hdiv ui-state-default
				{
				width: 873px !important; cursor: default!important
				}
				ui-state-highlight, .ui-widget-content .ui-state-highlight, .ui-widget-header .ui-state-highlight 
				{
				border: 1px solid #fed22f;
				background: #ffe45c;
			   }
			   .ui-state-default, .ui-widget-content .ui-state-default, .ui-widget-header .ui-state-default
			   {
					font-weight: bold;
					color: black;
				}
			.ui-jqgrid .ui-jqgrid-bdiv {
				overflow-y: scroll;
				//overflow-x: hidden;
				}
				
				.agr_appr
				{
				font-weight:bold !important;
				color:#AF0100;
				cursor: pointer; 
				}

</style>
	   
	    <script type="text/ecmascript" src="<?php echo base_url('public/jqgrid/js/jquery.jqGrid.min.js'); ?>"></script>
	    
	    <script type="text/ecmascript" src="<?php echo base_url('public/jqgrid/js/i18n/grid.locale-en.js'); ?>"></script>
	    
	    <link rel="stylesheet" type="text/css" media="screen" href="<?php echo base_url('public/assets/css/jquery-ui.css'); ?>" />
	    
	    <link rel="stylesheet" type="text/css" media="screen" href="<?php echo base_url('public/jqgrid/css/ui.jqgrid.css'); ?>" />
						
		<script src="<?php echo base_url('public/assets/js/jquery-ui.js'); ?>" type="text/javascript"></script>			
<script type="text/javascript"><!--

$(function(){

$(".from_date_picker").datepicker({

dateFormat: 'dd-mm-yy',

}).on('changeDate', function(ev){

$('.from_date_picker').datepicker('hide');

});

});
$('.from_date_picker').on('change', function(){
    var date = $(this).val();
    $('.to_date_picker').datepicker({
            dateFormat: 'dd-mm-yy',
            minDate: date,
    });  
});
//$('.from_date_picker').datepicker({
//
//		changeMonth:true,
//		changeYear:true,
//	    yearRange: "2000:c",
//	    dateFormat: 'dd-mm-yy' 
//
//	});
//
//	$('.to_date_picker').datepicker({
//
//		changeMonth:true,
//		changeYear:true,
//	    yearRange: "2000:c",
//	    dateFormat: 'dd-mm-yy' 
//
//	});
$('.proforma_invoice_form').submit(function(e){    
         e.preventDefault();
		var from= $("#tax_invoice_from").val();
		 
		 var to= $("#tax_invoice_to").val();
		
		 var name= $("#holder_name").val();

jQuery("#list1").jqGrid({
		
	 	url:"<?php echo site_url('proforma-invoice-list')?>?from_date="+from+"&to_date="+to+"&holder_name="+name, 
		 mtype : "post", 	 
		datatype: "json", 
	    colNames:['SI','Project Name','Sites','Invoice No','Invoice Type','To','Total SQFT','Rate/SQFT','Basic Amt','SGST','CGST','Total CGST','Total SGST','With GST Total Amt','Holder Name','Date','Status','Convert','Edit','Delete','Print'],
		colModel:[
					{name:'id',index:'id', width:50, hidden:true,editable:false,key:true},
					{name:'project_name',index:'project_name', width:100, editable:false},
					{name:'site_numbers',index:'site_numbers', width:100, editable:false,
		                formatter: function (cellvalue, options, rowObject) {
		                	if(rowObject.site_numbers){
		                		var  site_number=rowObject.site_numbers;
									console.log(site_number);
		                		var retVal = '';
		                   	 $.each(site_number, function(key, val){
		                   		 retVal +=''+val+',';
			                   	  });
		                   	return retVal;
		                   	  
		                   	
		                	}
		                	else{

return 'No Id proof';
		                	}
		                }},
						 
					{name:'invoice_number',index:'invoice_number', width:100, editable:false},
					{name:'invoice_type',index:'invoice_type', width:100, editable:false},
					{name:'invoice_to',index:'invoice_to', width:100, editable:false},
					{name:'total_sqft',index:'total_sqft', width:100, editable:false},
					{name:'rate_per_sqft',index:'rate_per_sqft', width:100, editable:false},
					{name:'without_gst_total_amt',index:'without_gst_total_amt', width:100, editable:false},
					{name:'sgst',index:'sgst', width:100, editable:false},
					{name:'cgst',index:'cgst', width:100, editable:false},
					{name:'total_cgst',index:'total_cgst', width:100, editable:false},
					{name:'total_sgst',index:'total_sgst', width:100, editable:false},
					{name:'with_gst_total_amt',index:'with_gst_total_amt', width:100, editable:false},
					{name:'bank_name',index:'bank_name', width:100, editable:false},
					{name:'created_at',index:'created_at', width:100, editable:false,formatter:'date', formatoptions: {newformat:'d/m/Y'}},
					{name:'delete_status',index:'delete_status', width:100, editable:false},

{name:' ',index:' ',editable:false,align: "center",editrules:{required: true},search:false, width:80,cellattr: function (rowId, tv, rawObject, cm, rdata) 
						{
                	     return ' onclick="convert($(this))" ';
                		},formatter:function (cellvalue, options, rowObject) {    
						return "<input type='button' value='CONVERT' \>";
			}},	
			
					{name:' ',index:' ',editable:false,align: "center",editrules:{required: true},search:false, width:50,cellattr: function (rowId, tv, rawObject, cm, rdata) 
						{
                	     return ' onclick="fun($(this))" ';
                		},formatter:function (cellvalue, options, rowObject) {    
						return "<input type='button' value='EDIT' \>";
			}},

{name:'delete',index:'delete',align: "center",editable:false,search:false,editrules:{required: true}, width:70,cellattr: function (rowId, tv, rawObject, cm, rdata) 
						{
                	     return ' onclick="fun_delete($(this))" ';
                		},formatter:function (cellvalue, options, rowObject) {    
						return "<input type='button'  value='DELETE'  \>";
			  }},
			  {name:'print',index:'print',align: "center",editable:false,search:false,editrules:{required: true}, width:70,cellattr: function (rowId, tv, rawObject, cm, rdata) 
						{
                	     return ' onclick="fun_print($(this))" ';
                		},formatter:function (cellvalue, options, rowObject) {    
						return "<input type='button'  value='PRINT'  \>";
			  }},
	      	    ],
	      	  rowNum:20000,
		      	rowTotal: 2000,
		      	rowList : [10,20,30,50,100,500,1000],
		      	rownumbers: true,
		      	rownumWidth: 40,
		      	pager:"#pager3", 
		      	sortname:'owner_id', 
		      	viewrecords: true,
		      	gridview: true,
		      	autowidth: true,
		      	sortorder:"asc",
		      	shrinkToFit: false,
		      	
		      	 emptyrecords: 'No records to display',
		       //  multiselect: true,
		         // multiboxonly: true,
		      	loadonce:true,
				caption:" Invoice List",
			
		});

$("#list1").jqGrid("setLabel", "rn", "SL");

$("#list1").jqGrid('filterToolbar',{searchOperators : false}); //for multisearch code,remove if not required

$("#list1").jqGrid('navGrid','#pager1',
			{edit:true,add:false,del:false,search:true,refreshstate:"current"},
			{ },
	        { },
	        { }, 
			{
		    	sopt:['eq', 'ne', 'lt', 'gt', 'cn', 'bw', 'ew'],
		        closeOnEscape: true, 
		        	multipleSearch: true, 
		         	closeAfterSearch: true }
		);

});

function convert(rowId)
{
	
  var id = rowId.closest('tr').attr('id'); 
 
    swal({

title: "Are you sure?",
        text: "You will not be able to recover this data!",
        type: "warning",   showCancelButton: true,
        confirmButtonColor: "#DD6B55",
        confirmButtonText: "Yes, Convert it!",
        cancelButtonText: "No, cancel plz!",
        closeOnConfirm: false,
        closeOnCancel: false 
        },

function(isConfirm){

if (isConfirm) {

$(".sweet-alert").hide();
            $(".sweet-overlay").hide();
                $.ajax({          
                        type   : 'post',
                        url    : '<?php echo site_url("convert_invoice")?>',
                        data   : {id:id},

success:function(response) {
                        //response=jQuery.parseJSON(response);
								console.log(response);

if(response.result == 1) 
                            {
                               toastr["success"](response.message);
                               $("#list1").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid'); 
                            }
                        }
                    });

} 
                        else {
                        
                        $(".sweet-alert").hide();
                        $(".sweet-overlay").hide();
                    }

});
}

function fun_delete(rowId)
{
	
  var id = rowId.closest('tr').attr('id'); 
 
    swal({

title: "Are you sure?",
        text: "You will not be able to recover this data!",
        type: "warning",   showCancelButton: true,
        confirmButtonColor: "#DD6B55",
        confirmButtonText: "Yes, Delete it!",
        cancelButtonText: "No, cancel plz!",
        closeOnConfirm: false,
        closeOnCancel: false 
        },

function(isConfirm){

if (isConfirm) {

$(".sweet-alert").hide();
            $(".sweet-overlay").hide();
                $.ajax({          
                        type   : 'post',
                        url    : '<?php echo site_url("delete_invoice")?>',
                        data   : {id:id},

success:function(response) {
                       // response=jQuery.parseJSON(response);
								console.log(response);

} 
                        else {

$(".sweet-alert").hide();
                        $(".sweet-overlay").hide();
                    }

});
}

function fun_print(rowId)
{
  var id = rowId.closest('tr').attr('id'); 
  window.location.href = "<?php echo site_url('proforma-invoice-print');?>?id="+id;
}

function fun(rowId)
{
   var id = rowId.closest('tr').attr('id');
	
	//alert(id);

window.location.href = "<?php echo site_url('edit-proforma-invoice-form');?>?id="+id;
}

$(".rate_per_sqft").focusout(function(){
	var total_sqft=$('.total_sqft').val();
	var rate_per_sqft=$('.rate_per_sqft').val();
	var amount=parseFloat(total_sqft) * parseFloat(rate_per_sqft);
	$('.total_amt').val(amount.toFixed()); 
    
});

$(".total_amt").focusout(function(){
	var total_sqft=$('.total_sqft').val();
	var total_amt=$('.total_amt').val();
	var amount=parseFloat(total_amt) / parseFloat(total_sqft);
	//$('.rate_per_sqft').val(amount.toFixed()); 
    
});

$(".sgst").focusout(function(){
	var total_sqft=$('.total_sqft').val();
	var rate_per_sqft=$('.rate_per_sqft').val();
	var amount=parseFloat(total_sqft) * parseFloat(rate_per_sqft);
	var sgst=$('.sgst').val();
	var cgst=$('.cgst').val();
		var total_sgst=(parseFloat(amount) * parseFloat(sgst))/100;
		var total_cgst=(parseFloat(amount) * parseFloat(cgst))/100;
	if(total_cgst > 0)
	{
	var tot_amount=parseFloat(amount) + parseFloat(total_sgst) + parseFloat(total_cgst);
	}
	else
	{
		var tot_amount=parseFloat(amount) + parseFloat(total_sgst);
	}
	$('.total_withgst_amt').val(tot_amount.toFixed()); 
    
});
$(".cgst").focusout(function(){
	var total_sqft=$('.total_sqft').val();
	var rate_per_sqft=$('.rate_per_sqft').val();
	var amount=parseFloat(total_sqft) * parseFloat(rate_per_sqft);
	var sgst=$('.sgst').val();
	var cgst=$('.cgst').val();
		var total_sgst=(parseFloat(amount) * parseFloat(sgst))/100;
		var total_cgst=(parseFloat(amount) * parseFloat(cgst))/100;
	if(total_sgst>0)
	{
	var tot_amount=parseFloat(amount) + parseFloat(total_sgst) + parseFloat(total_cgst);
	}
	else
	{
		var tot_amount=parseFloat(amount) + parseFloat(total_cgst);
	}
	$('.total_withgst_amt').val(tot_amount.toFixed()); 
    
});

// $(".total_withgst_amt").focusout(function(){
	// var total_withgst_amt=$('.total_withgst_amt').val();
	// var basic_amt=$('.total_amt').val();
	
	// if(sgst>0 && cgst>0)
	// {
		// var total_sgst=(parseFloat(total_amt) * parseFloat(sgst))/100;
		// var total_cgst=(parseFloat(total_amt) * parseFloat(cgst))/100;
	// if(total_sgst>0)
	// {
	// var tot_amount=parseFloat(total_amt) + parseFloat(total_sgst) + parseFloat(total_cgst);
	// }
	// else
	// {
		// var tot_amount=parseFloat(total_amt) + parseFloat(total_cgst);
	// }
	// $('.total_withgst_amt').val(tot_amount.toFixed()); 
	// }
    
// });

function myFunction()
{
	var total_withgst_amt=$('.total_withgst_amt').val();
	//alert(total_withgst_amt);
	
	var total_sqft=$('.total_sqft').val();
	
	var sgst=$('.sgst').val();
	
	
	var cgst=$('.cgst').val();
	
	
	var total_gst = parseFloat(sgst)+parseFloat(cgst);
	
	
	var amount = (parseFloat(total_withgst_amt)-(parseFloat(total_withgst_amt)*(100/(100+parseFloat(total_gst)))));

var amount1 = parseFloat(total_withgst_amt)- parseFloat(amount);
	
	 var rate_per_sqft = parseFloat(amount1)/parseFloat(total_sqft);
	
	$('.total_amt').val(amount1.toFixed()); 	
	
	$('.rate_per_sqft').val(rate_per_sqft.toFixed()); 
}

function print_page() {
    var id = jQuery("#list1").jqGrid('getDataIDs');

$.ajax({
        type: 'POST',
        url: '<?php echo site_url("get_table_details_invoice")?>',
        data: { id: id },
        dataType: "json",
        success: function (response) {
            if (!Array.isArray(response) || response.length === 0) {
                console.error("No valid data found.");
                alert("No invoice details found.");
                return;
            }

console.log(response);
            $('.print_table').empty();
            var count = 1;
            var content = '';

content += '<thead><tr>';
            content += '<th>SI</th><th>Project Name</th><th>Sites</th><th>Invoice No</th>';
            content += '<th>Invoice Type</th><th>To</th><th>Total SQFT</th><th>Rate/SQFT</th>';
            content += '<th>Without GST Total Amt</th><th>SGST</th><th>CGST</th><th>Total CGST</th>';
            content += '<th>Total SGST</th><th>With GST Total Amt</th><th>Holder Name</th><th>Date</th>';
            content += '</tr></thead>';

response.forEach(val => {
                try {
                    var sites = Array.isArray(val.site_numbers) ? val.site_numbers : JSON.parse(val.site_numbers || "[]");

content += '<tr>';
                    content += '<td>' + count + '</td>';
                    content += '<td>' + val.project_name + '</td>';
                    content += '<td>' + (Array.isArray(sites) ? sites.join(", ") : '') + '</td>';
                    content += '<td>' + val.invoice_number + '</td>';
                    content += '<td>' + val.invoice_type + '</td>';
                    content += '<td>' + val.invoice_to + '</td>';
                    content += '<td>' + val.total_sqft + '</td>';
                    content += '<td>' + val.rate_per_sqft + '</td>';
                    content += '<td>' + val.without_gst_total_amt + '</td>';
                    content += '<td>' + val.sgst + '</td>';
                    content += '<td>' + val.cgst + '</td>';
                    content += '<td>' + val.total_cgst + '</td>';
                    content += '<td>' + val.total_sgst + '</td>';
                    content += '<td>' + val.with_gst_total_amt + '</td>';
                    content += '<td>' + val.bank_name + '</td>';
                    content += '<td>' + val.created_at + '</td>';
                    content += '</tr>';

count++;
                } catch (error) {
                    console.error("Error processing row:", val, error);
                }
            });

$('.print_table').append(content);
            print_page1(); // Make sure this exists and handles window.print()
        },
        error: function (xhr, status, error) {
            console.error("AJAX Error:", status, error);
            alert("Failed to retrieve invoice details.");
        }
    });
}

function export_page() {
    var id = jQuery("#list1").jqGrid('getDataIDs');

if (!id || id.length === 0) {
        alert("No data to export.");
        return;
    }

$.ajax({
        type: 'POST',
        url: '<?php echo site_url("get_table_details_invoice")?>',
        data: { id: id }, // Send as form data (no need to JSON.stringify)
        dataType: "json",
        success: function (response) {
            if (!Array.isArray(response)) {
                alert("Unexpected response from server.");
                return;
            }

$('.print_table').empty();
            var count = 1;
            var content = '<thead><tr><th>SI</th><th>Project Name</th><th>Sites</th><th>Invoice No</th><th>Invoice Type</th><th>To</th><th>Total SQFT</th><th>Rate/SQFT</th><th>Without GST Total Amt</th><th>SGST</th><th>CGST</th><th>Total CGST</th><th>Total SGST</th><th>With GST Total Amt</th><th>Holder Name</th><th>Date</th></tr></thead>';

response.forEach((va, index) => {
                try {
                    var sites = (typeof va.site_numbers === "string") ? JSON.parse(va.site_numbers) : va.site_numbers;

content += '<tr>';
                    content += '<td>' + count + '</td>';
                    content += '<td>' + va.project_name + '</td>';
                    content += '<td>' + (Array.isArray(sites) ? sites.join(', ') : '') + '</td>';
                    content += '<td>' + va.invoice_number + '</td>';
                    content += '<td>' + va.invoice_type + '</td>';
                    content += '<td>' + va.invoice_to + '</td>';
                    content += '<td>' + va.total_sqft + '</td>';
                    content += '<td>' + va.rate_per_sqft + '</td>';
                    content += '<td>' + va.without_gst_total_amt + '</td>';
                    content += '<td>' + va.sgst + '</td>';
                    content += '<td>' + va.cgst + '</td>';
                    content += '<td>' + va.total_cgst + '</td>';
                    content += '<td>' + va.total_sgst + '</td>';
                    content += '<td>' + va.with_gst_total_amt + '</td>';
                    content += '<td>' + va.bank_name + '</td>';
                    content += '<td>' + va.created_at + '</td>';
                    content += '</tr>';
                    count++;
                } catch (err) {
                    console.error("Row parse error:", err);
                }
            });

$('.print_table').html(content);
            export_data();
        },
        error: function (xhr, status, error) {
            console.error("Export AJAX Error:", error);
            alert("Failed to export data.");
        }
    });	
}

function export_data() {
    $("#print_table").table2excel({
        exclude: ".noExl",
        name: "Invoice Report",
        filename: "tax-invoice-list",
        fileext: ".xls",
        exclude_img: true,
        exclude_links: true,
        exclude_inputs: true
    });
}

function print_page1()
{  
	
	var divToPrint=document.getElementById('print_table');
		newWin= window.open("");
		newWin.document.write('<html><head><title></title>');
		newWin.document.write('</head>');
		newWin.document.write(divToPrint.outerHTML);
		newWin.document.write('</html>');
		newWin.print();
		document.getElementById('print_table').style.display='';
		newWin.close();
		location.reload();
}

--></script>
<?php echo view('includes/footer');?>