EVOLUTION-NINJA

Edit File: hsn_report.php

<h3 class="page-title">
HSN Details
</h3>

<div class="page-bar">
		<ul class="page-breadcrumb">
			<li><i class="fa fa-home"></i> <a href="https://swansilk.co/dashboard/dashboard_fun">Home</a> <i
			class="fa fa-angle-right"></i> <a href="#" > HSN Details </a></li>
		</ul>
	</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="button" onclick="new_export();" class="btn btn-primary">Submit</button>
				
				 
				</div>
				
		</form>
	</div> 
	<div style="overflow-x: scroll;" ><table  border="1" style="border-spacing: 0px !important;" id="listing" class="export_table">
	<thead style="background-color: #485b7f !important;color:white;width:100% !important;padding:30px;"><tr>
                <th>Id</th>
                <th>Type</th>
                <th>Invoice Date</th>
                <th>Invoice #</th>
                <th>Article</th>
                <th>Width</th>
                <th>Design</th>
                <th>Shade</th>
                <th>Qty</th>
                <th>Units</th>
                <th>Unit Price</th>
                <th>Value</th>
                <th>Currency</th>
                <th>Contract Type</th>
                <th>HSN Code</th>
                <th>Approved</th>
                
                </tr></thead>
                <tbody id="loans_table_body_prints">
                	
                </tbody>
                
</table></div>
			
</div>
</div>
</div>

$(".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,
    });  
});
new_export();
function new_export()
{
  var from_delivery_date_required_on =$('#from_delivery_date_required_on').val();
  var to_delivery_date_required_on =$('#to_delivery_date_required_on').val();
  var arrayReturn = [];
            $.ajax({
                url: "<?php echo base_url('reports/hsn_report_details')?>?from_date="+from_delivery_date_required_on+"&&to_date="+to_delivery_date_required_on,   
                async: true,
                dataType: 'json',
                success: function (data) {
          for (var i = 0, len = data.length; i < len; i++) {
            var key=i+1;
            var id = key;
             var type = data[i].type;
            var sys_date = data[i].sys_date;
            var invoice_num = data[i].invoice_num;
            var article = data[i].article;
            var width = data[i].width;
            var design = data[i].design;
            
            var shade = data[i].shades;
            //var qty = data[i].values_es;
            var qty = data[i].stock_wt;
            var unit = data[i].units;
            var unit_price = data[i].unitprice;
            var value = data[i].values_es;
            var new_currency = data[i].new_currency;
            var constract_type = data[i].contarct_type;
            var hsn_code = data[i].hsn_code;
             var approved = data[i].approved_by;

arrayReturn.push([id,type,sys_date,invoice_num,article, width,design,shade,qty,unit,unit_price,value,new_currency,constract_type,hsn_code,approved]);
            //var id = (data[i].customer_name).toString();
            //arrayReturn.push([id, '<a href="http://google.com" target="_blank">'+title.substring(0, 20)+'</a>', desc.substring(0, 120)]);
          }
        inittable(arrayReturn);
                }
            });
            
  
}

function inittable(data) {

$('#listing').DataTable({
			 destroy: true,
			 "bInfo" : false,
			"aaData": data,
			"dom": 'lBfrtip',
			filter: 'applied',
			buttons: [
            { extend: 'excelHtml5', footer: true,text: 'Export to Excel',title: 'HSN Report', download: 'open',orientation:'landscape',
        	exportOptions: {
				  columns: ':visible'
				}},
             ],
             
            "footerCallback": function ( row, data, start, end, display ) {

var api = this.api(), data;
            CalculateTableSummary(this,row, data, start, end, display);
           
        },

} );
	}

function CalculateTableSummary(table,row, data, start, end, display)
	{

try {

var intVal = function (i) {
            return typeof i === 'string' ?
                    i.replace(/[\$,]/g, '') * 1 :
                    typeof i === 'number' ?
                        i : 0;
        };

var count =api.rows( { filter : 'applied'} ).nodes().length;
               var usd=0;
              	var inr=0;
              	var eur =0;
              	var chf =0;
              	var gbp=0;
              	var all_inr=0;

for( i=0;i < count;i++){
              	if(all_data[i][14]!=''){
              	all_inr = parseFloat(all_inr) + parseFloat(all_data[i][14]);

}
              	if((all_data[i][7])=="USD")
              	{
              		
              	 	usd= parseFloat(usd) + parseFloat(all_data[i][10]);
              	}else if((all_data[i][7])=="INR")
              	{
              		inr= parseFloat(inr) + parseFloat(all_data[i][10]);
              	}else if((all_data[i][7])=="EUR")
              	{
              		eur= parseFloat(eur) + parseFloat(all_data[i][10]);
              	}else if((all_data[i][7])=="CHF")
              	{
              		chf= parseFloat(chf) + parseFloat(all_data[i][10]);
              	}else if ((all_data[i][7])=="GBP") {

gbp= parseFloat(gbp) + parseFloat(all_data[i][10]);
              	}
              	
               
             
}
				
				$( api.column( 0 ).footer() ).html('USD Total : '+usd.toFixed(2));
				//$( api.column( 1 ).footer() ).html();
				$( api.column( 2 ).footer() ).html('EUR Total : '+eur.toFixed(2));
				//$( api.column( 3 ).footer() ).html();

$( api.column( 4 ).footer() ).html('GBP Total : '+gbp.toFixed(2));
				//$( api.column( 5 ).footer() ).html();

$( api.column( 6 ).footer() ).html('CHF Total : '+chf.toFixed(2));
				//$( api.column( 7 ).footer() ).html();

$( api.column( 8 ).footer() ).html('INR Total : '+inr.toFixed(2));
				$( api.column( 14 ).footer() ).html('Total INR value : '+all_inr.toFixed(2));
				
          
        });
    } catch (e) {
        console.log('Error in CalculateTableSummary');
        console.log(e)
    }

}

</script>

.content-wrapper, .right-side {			
		//min-height:900px !important;
	}	
	
	a {
	 color: inherit; 
	}
	.checkbox input[type=checkbox], .checkbox-inline input[type=checkbox], .radio input[type=radio], .radio-inline input[type=radio] {
    position: absolute;
    margin-top: 4px\9;
	margin-left: -47px;
}
input[type=checkbox], input[type=radio] {
    margin: -8px 0 0;
    margin-top: 1px\9;
    line-height: normal;
}

.radio-inline input[type=radio] {
    margin-left: -20px;
    width: 15px !important;
    margin-top: -5px;
}
#ui-datepicker-div {
		z-index: 1000 !important;
	}
.date_row {
	padding-bottom: 3%;
}	
</style>