	<?php $this->load->view("common/header"); ?>
	<!-- end: HEAD -->
       
		<!-- start: CSS REQUIRED FOR THIS PAGE ONLY -->
		<link rel="stylesheet" type="text/css" href="<?php echo asset_url(); ?>plugins/select2/select2.css" />
		<link rel="stylesheet" href="<?php echo asset_url(); ?>plugins/DataTables/media/css/DT_bootstrap.css" />
		<link href="<?php echo asset_url(); ?>plugins/bootstrap-modal/css/bootstrap-modal-bs3patch.css" rel="stylesheet" type="text/css"/>
		<link href="<?php echo asset_url(); ?>plugins/bootstrap-modal/css/bootstrap-modal.css" rel="stylesheet" type="text/css"/>
		<link rel="stylesheet" href="<?php echo asset_url(); ?>plugins/bootstrap-fileupload/bootstrap-fileupload.min.css">
		<link rel="stylesheet" href="<?php echo asset_url(); ?>plugins/select2/select2.css">


		<link rel="stylesheet" href="<?php echo asset_url(); ?>plugins/select2/select2.css">
		<link rel="stylesheet" href="<?php echo asset_url(); ?>plugins/datepicker/css/datepicker.css">
		<link rel="stylesheet" href="<?php echo asset_url(); ?>plugins/bootstrap-timepicker/css/bootstrap-timepicker.min.css">
		<link rel="stylesheet" href="<?php echo asset_url(); ?>plugins/bootstrap-daterangepicker/daterangepicker-bs3.css">
		<link rel="stylesheet" href="<?php echo asset_url(); ?>plugins/bootstrap-colorpicker/css/bootstrap-colorpicker.css">
		<link rel="stylesheet" href="<?php echo asset_url(); ?>plugins/jQuery-Tags-Input/jquery.tagsinput.css">
		<link rel="stylesheet" href="<?php echo asset_url(); ?>plugins/bootstrap-fileupload/bootstrap-fileupload.min.css">
		<link rel="stylesheet" href="<?php echo asset_url(); ?>plugins/summernote/build/summernote.css">

		<style type="text/css">
			.table > thead:first-child > tr:first-child > th, .table > thead:first-child > tr:first-child > td, .table-striped thead tr.primary:nth-child(2n+1) th {
			    background-color: #428bca;
			    border-color: #357ebd;
			    border-top: 1px solid #357ebd;
			    color: white;
			    text-align: center;
			}
#s2id_srh_customer_id{
	border: 0 none;
padding: 0;
}
button.dt-button, div.dt-button, a.dt-button {
  -moz-user-select: none;
  background-color: #e9e9e9;
  background-image: linear-gradient(to bottom, #fff 0%, #e9e9e9 100%);
  border: 1px solid #999;
  border-radius: 2px;
  box-sizing: border-box;
  color: black;
  cursor: pointer;
  display: inline-block;
  font-size: 0.88em;
  margin-right: 0.333em;
  outline: medium none;
  overflow: hidden;
  padding: 0.5em 1em;
  position: relative;
  text-decoration: none;
  white-space: nowrap;
}

		</style>
		<!-- end: CSS REQUIRED FOR THIS PAGE ONLY -->
	<!-- end: HEAD -->
	<!-- start: BODY -->
	<body>
		<!-- start: HEADER -->
		<div class="navbar navbar-inverse navbar-fixed-top">
			<!-- start: TOP NAVIGATION CONTAINER -->
			<div class="container">
				<div class="navbar-header">
					<!-- start: RESPONSIVE MENU TOGGLER -->
					<button data-target=".navbar-collapse" data-toggle="collapse" class="navbar-toggle" type="button">
						<span class="clip-list-2"></span>
					</button>
					<!-- end: RESPONSIVE MENU TOGGLER -->
					<!-- start: LOGO -->
					<?php $this->load->view("common/logo"); ?>
					<!-- end: LOGO -->
				</div>
				<div class="navbar-tools">
					<!-- start: TOP NAVIGATION MENU -->
				<?php $this->load->view("common/notifications.php"); ?>
					<!-- end: TOP NAVIGATION MENU -->
				</div>
			</div>
			<!-- end: TOP NAVIGATION CONTAINER -->
		</div>
		<!-- end: HEADER -->
		<!-- start: MAIN CONTAINER -->
		<div class="main-container">
			<div class="navbar-content">
				<!-- start: SIDEBAR -->
				<?php $this->load->view("common/navigation"); ?>
				<!-- end: SIDEBAR -->
			</div>
			<!-- start: PAGE -->
			<div class="main-content">
				<!-- end: SPANEL CONFIGURATION MODAL FORM -->
				<div class="container">
					<!-- start: PAGE HEADER -->
					<div class="row">
						<div class="col-sm-12">
							<!-- start: PAGE TITLE & BREADCRUMB -->
							<ol class="breadcrumb">
								<li>
									<a href="<?php echo base_url('dashboard'); ?>">
										 Dashboard 
									</a>
								</li>
                                <li>
									<a href="#">
										Reports 
									</a>
								</li>
                                                                
								<li class="active">
									Loan Report
								</li>
								<li class="search-box">
									<form class="sidebar-search">
										<div class="form-group">
											<input type="text" placeholder="Start Searching...">
											<button class="submit">

												<i class="clip-search-3"></i>
											</button>
										</div>
									</form>
								</li>
							</ol>
							<div class="page-header">
								<h1> Loan Report</h1>
							</div>

                            <p>Please use the table below to navigate or filter the results. </p>
						</div>
					</div>
					<!-- end: PAGE HEADER -->
					<!-- start: PAGE CONTENT 
                    <!-- start grid -->
                    <div class="row">
						<div class="col-md-12">
							<!-- start: DYNAMIC TABLE PANEL -->
							<div class="panel panel-default">
								<div class="panel-heading">
									<i class="fa fa-external-link-square"></i>
									Loan( Cheque / Cash )
                                    <div class="panel-tools" style="top:2px;">
												<button onClick="JavaScript:fbs_click('<?php echo base_url('reports/print_grn?srh_warehouse_id=1'); ?>');" class="btn btn-blue dropdown-toggle" data-toggle="dropdown"> Report
													<i class="fa fa-print"></i>
												</button>
                                                
                                                
                                                
                                                <button onClick="JavaScript:fbs_click_cus_only();" class="btn btn-blue dropdown-toggle" data-toggle="dropdown" >Customer Only
													<i class="fa fa-print"></i>
												</button>
                                                
                                                
                                                
                                                <button class="btn btn-blue dropdown-toggle" data-toggle="dropdown" id="excel">
<i class="fa fa-fw" aria-hidden="true" title="Copy to use file-excel-o"></i>
</button> 
 
												
												</div>
								</div>
								</div>
							  <div class="panel-body">
							    <div id="error"></div>
                                
                              <div class="col-md-12">
											<div class="panel panel-default">
												<div style="font-weight: 700;" class="panel-heading"></div>
													<div class="panel-body">
														
                                                          <div class="col-md-3">
              <div class="form-group">
               
                <label for="loan_payment_term">Payment Term *  </label>
                <select  id="loan_payment_term" class="form-control" name="loan_payment_term" >              
              	 <option   value="">Select Payment method</option>                     
               <?php 						
						foreach ($payment_term_list as $row)
							{ ?>                                                         
                            <option value="<?php echo $row['id'];?>"><?php echo $row['payment_term_name'];?></option>                          
							<?php }  ?>	
                 </select>
                 </div></div>
                                                        
                                                        <div class="col-sm-3">
                                                      	<div class="form-group">
															<label>Route </label>
                                                       <select id="route_id" class="form-control search-select" name="route_id">
                                                               
																 <option value="">-Select-</option>
									                             <?php foreach ($routes_list as $key) {
									                                echo"<option value=".$key['route_id'].">".$key['route_name']."</option>";
									                             } ?>  
								                             </select>                                       
														</div>
														</div>
                                                        
                                                      
                                                        
                                                       <div class="col-sm-2">
                                                      	<div class="form-group">
															<label>From Date  </label>
                                                         <input id="srh_from_date" name="srh_from_date" type='text' class="form-control date" value="" data-bv-field="date"/>                                                             
														</div>
														</div>
                                                        
                                                        <div class="col-sm-2">
                                                      	<div class="form-group">
															<label for="s2id_autogen1">To Date </label>
                                                          
															 <input id="srh_to_date" name="srh_to_date" type='text' class="form-control date" value="" data-bv-field="date"/>        
														</div>
													</div>
                                                    
                                                    <div class="col-sm-4 pull-right">
                                                      	<div class="form-group">
															<label for="s2id_autogen1">&nbsp;<br><br>
</label>
                                                          
															 <input type="submit" name="add_category" value="Search" class="btn btn-primary" onClick="searchDetails()"> &nbsp;&nbsp;
                                                             
                                                             <input type="submit" name="add_category" value="Reset" class="btn btn-danger" onClick="searchDetailsReset()">
														</div>
													</div>
                                                   
                                                    
												</div>
											</div> 
 <div id="printableArea">
<div class="page-header">
								<h1>Loan Summary</h1>
                                
   <table class="table table-bordered table-condensed table-hover table-striped dataTable" id="">
   <tr>
   <td></td>
   <td></td>
   <td></td>
   <td class="text-right">From Date:  <span id="f-date-txt">Lording....</span>, To Date: <span id="t-date-txt">Lording....</span></td>
  </tr>
  
  <tr>
    <th width="25%"></th>
    <th width="25%">Total  </th>
     <th width="25%">Received  </th>
      <th width="25%">Different </th>
   </tr>
   
   <tr>      
    <th>Capital</th>  
    <td><div id="tot_capital_amount">Lording....</div></td>   
    <td><div id="tot_r_capital_amount">Lording....</div></td>    
    <td><div id="tot_capital_balance">Lording....</div></td>  
  </tr>
 
  <tr>
    <th>Interest</th>
    <td><div id="interest_amount">Lording....</div></td>    
    <td><div id="interest_r_amount">Lording....</div></td>
    <td><div id="interest_balance">Lording....</div></td>
  </tr>
  <tr>
  <th>Panalty</th>
    <td><div id="panalty_amount">Lording....</div></td>    
    <td><div id="panalty_r_amount">Lording....</div></td>
    <td><div id="panalty_balance">Lording....</div></td>
   
  </tr>
  <tr>
  	<th>Due</th>
    <td><div id="due_amount">Lording....</div></td>    
    <td><div id="due_r_amount">Lording....</div></td>
    <td><div id="due_balance">Lording....</div></td>
  </tr>
  
  
  	<th>Total </th>
    <td><div id="total_amount">Lording....</div></td>    
    <td><div id="total_r_amount">Lording....</div></td>
    <td><div id="total_balance">Lording....</div></td>
  </tr>
 
  <tr>
    <th>Net Income</th>
    <td></td>
     <td></td>
    <td align="right"><div id="net_income">Lording....</div></td>
  </tr>
</table>
                               
                                
							</div>                                
                                
								  <table class="table table-bordered table-condensed table-hover table-striped dataTable" id="warehouse_table">
									  <thead>
							            <tr>
                                    <th>Closed <br>Date</th>
                                    <th>Loan Ref.no</th>
                                     <th>Payment<br> term </th>
                                     <th>Customer</th>
                                     <th>Route</th>
                                    <th>Capital</th>
                                    <th>Interest</th>
                                    <th>Panalty</th>
                                    <th>Due</th>
                                    <th>Balance<br>payment</th>
                                    </tr>
							          </thead>
							          <tfoot>
									<tr>
                                  
                 					 <th>Closed <br>Date</th>
                                    <th>Loan Ref.no</th>
                                     <th>Payment<br> term </th>
                                     <th>Customer</th>
                                     <th>Route</th>
                                    <th>Capital</th>
                                    <th>Interest</th>
                                    <th>Panalty</th>
                                    <th>Due</th>
                                     <th>Balance<br>payment</th>
                                    
                                    </tr>
								           
						          </table>
								</div>
							</div>
							<!-- end: DYNAMIC TABLE PANEL -->

                            
                            
                            
						</div>
					</div>

                    <!-- end grid -->
                    
					
			</div>
			<!-- end: PAGE -->
		</div>
        </div>
		<!-- end: MAIN CONTAINER -->
		<!-- start: FOOTER -->
		<div class="footer clearfix">
			<div class="footer-inner">
				2014 &copy; clip-one by cliptheme.
			</div>
			<div class="footer-items">
				<span class="go-top"><i class="clip-chevron-up"></i></span>
			</div>
		</div>
		<!-- end: FOOTER -->
		<!-- start: RIGHT SIDEBAR -->
		<!-- end: RIGHT SIDEBAR -->
		<div id="event-management" class="modal fade" tabindex="-1" data-width="760" style="display: none;">
			<div class="modal-dialog">
				<div class="modal-content">
					<div class="modal-header">
						<button type="button" class="close" data-dismiss="modal" aria-hidden="true">
							&times;
						</button>
						<h4 class="modal-title">Event Management</h4>
					</div>
					<div class="modal-body"></div>
					<div class="modal-footer">
						<button type="button" data-dismiss="modal" class="btn btn-light-grey">
							Close
						</button>
						<button type="button" class="btn btn-danger remove-event no-display">
							<i class='fa fa-trash-o'></i> Delete Event
						</button>
						<button type='submit' class='btn btn-success save-event'>
							<i class='fa fa-check'></i> Save
						</button>
					</div>
				</div>
			</div>
		</div>

		<!-- start ajax model -->
		<div id="ajax-modal" class="modal fade" data-backdrop="static" data-keyboard="false" tabindex="-1" style="display: none;"></div>
		<!-- end ajax model -->

		<!-- start: MAIN JAVASCRIPTS -->
		<?php $this->load->view("common/footer"); ?>
        <script src="<?php echo asset_url(); ?>js/jquery-ui.js" ></script>		
		<script src="<?php echo asset_url(); ?>js/moment-with-locales.js"></script>
		<script type="text/javascript" src="<?php echo asset_url(); ?>js/bootstrap-datetimepicker.js"></script>
		
		<script type="text/javascript" src="<?php echo asset_url(); ?>js/bootbox.min.js"></script>
        
         <script type="text/javascript" src="<?php echo asset_url(); ?>js/accounting.js"></script>
          <script type="text/javascript" src="<?php echo asset_url(); ?>js/accounting.min.js"></script>
		<!-- end: MAIN JAVASCRIPTS -->
	<!--	<script type="text/javascript" src="https://cdn.datatables.net/1.10.10/js/jquery.dataTables.min.js"></script>
		<script type="text/javascript" src="https://cdn.datatables.net/1.10.10/js/dataTables.bootstrap.min.js"></script>-->
        
        <script type="text/javascript" src="<?php echo asset_url(); ?>js/jquery.dataTables.min.js"></script>
        
        <script type="text/javascript" src="<?php echo asset_url(); ?>js/dataTables.bootstrap.min.js"></script>
        <script>
		
		
		function searchDetailsReset(){
			$('#srh_to_date').val('');
			$('#srh_from_date').val('');
		}
		function searchDetails(){
			load_close_summary();
			loadGrid();
		}
				
				
			jQuery(document).ready(function() {
				
				var currentDate = new Date();
				var tomorrow = new Date();				
				$('#srh_to_date').datetimepicker({
					defaultDate: currentDate
				});				
				$('#srh_from_date').datetimepicker({
					defaultDate: new Date()
				});
				
				//TableData.init();
				load_close_summary();
				loadGrid();
				  $("#route_id").select2();
				$('#srh_from_date').val('');
			});


			function loadGrid() {
				
			var route_id=$('#route_id').val();
			var loan_payment_term=$('#loan_payment_term').val();
			var srh_from_date=$('#srh_from_date').val();
			var srh_to_date=$('#srh_to_date').val();
			
			
			
							
					    $('#warehouse_table').DataTable({
							dom: 'Blfrtip',
							buttons: [
       { extend: 'print', text: 'Print',footer: true},
        { extend: 'excel', text: 'Save as Excel',footer: true},
		 { extend: 'pdf', text: 'Save as Pdf',footer: true},
		
    ],
							
							"ajax": {
							'type': 'POST',
							'url': '<?php echo base_url('reports_loan/get_loan_list');?>',
							'data': {
							    route_id:route_id, 
								loan_payment_term:loan_payment_term,
								srh_from_date:srh_from_date,
								srh_to_date:srh_to_date
							}
							},
					        "bDestroy": true,
					        "iDisplayLength": 10,
							"order": [[ 0, "desc" ]], "fnFooterCallback": function (nRow, aaData, iStart, iEnd, aiDisplay) {
				
                var pq = 0, sq = 0, bq = 0, pa = 0, grand_tot = 0, tech_tot = 0, parts_tot=0 , ser_tot=0;
				//alert(aaData.length);
				var ser_tot3=0;
				var ser_tot2=0;
				var ser_tot1=0;
				var ser_tot4=0;
				var ser_tot5=0;
				//var sales_rtn=0;
               /* for (var i = 0; i < aaData.length; i++) {
					//alert(aaData[[i]][5]);
                   // p = (aaData[aiDisplay[i]][2]).split('__');
					
					ser_tot1 += parseFloat(aaData[[i]][5]);
					ser_tot2 += parseFloat(aaData[[i]][6]);
					ser_tot3 += parseFloat(aaData[[i]][7]);	
					ser_tot4 += parseFloat(aaData[[i]][8]);	
					ser_tot5 += parseFloat(aaData[[i]][9]);
                }
				
				
                var nCells = nRow.getElementsByTagName('th');*/
			/*
				nCells[5].innerHTML = '<div class="text-right">'+accounting.formatMoney(ser_tot1, "", 2, ",", ".")+' </div>';
				nCells[6].innerHTML = '<div class="text-right">'+accounting.formatMoney(ser_tot2, "", 2, ",", ".")+' </div>';
				nCells[7].innerHTML = '<div class="text-right">'+accounting.formatMoney(ser_tot3, "", 2, ",", ".")+' </div>';
				nCells[8].innerHTML = '<div class="text-right">'+accounting.formatMoney(ser_tot4, "", 2, ",", ".")+' </div>';
				nCells[9].innerHTML = '<div class="text-right">'+accounting.formatMoney(ser_tot5, "", 2, ",", ".")+' </div>';*/
				
				
				
			
				
				 

            }
							
	
			});

	}
	
	
	
					


function fbs_click(url) {
	var srh_from_date=$('#srh_from_date').val();
	var srh_to_date=$('#srh_to_date').val();
	var srh_warehouse_id=$('#srh_warehouse_id').val();
	var route_id=$('#route_id').val();
	var sales_rep=$('#sales_rep').val();
	u=location.href;
	t=document.title;
	url='<?php echo base_url();?>'+'reports_settu/get_line_delivary_print?srh_warehouse_id='+srh_warehouse_id+'&route_id='+route_id+'&sales_rep='+sales_rep;
	window.open(url,'sharer','toolbar=0,status=0,width=750,height=436, left=10, top=10,scrollbars=yes');return false;
}




function fbs_click_cus_only(url) {
	var srh_from_date=$('#srh_from_date').val();
	var srh_to_date=$('#srh_to_date').val();
	var srh_warehouse_id=$('#srh_warehouse_id').val();
	var route_id=$('#route_id').val();
	var sales_rep=$('#sales_rep').val();
	u=location.href;
	t=document.title;
	url='<?php echo base_url();?>'+'reports_settu/get_line_delivary_print_cus_only?srh_warehouse_id='+srh_warehouse_id+'&route_id='+route_id+'&sales_rep='+sales_rep;
	window.open(url,'sharer','toolbar=0,status=0,width=750,height=436, left=10, top=10,scrollbars=yes');return false;
}





</script>
<script type="text/javascript">
$(function(){
    $('#excel').click(function(){
        var url='data:application/vnd.ms-excel,' + encodeURIComponent($('#printableArea').html()) 
        location.href=url
        return false
    })
})





function load_close_summary()
	{			
	
	var route_id=$('#route_id').val();
	var loan_payment_term=$('#loan_payment_term').val();
	var srh_from_date=$('#srh_from_date').val();
	var srh_to_date=$('#srh_to_date').val();

				 
	$.post( "<?php echo base_url();?>reports_loan/get_loan_summary", {route_id:route_id, loan_payment_term:loan_payment_term,srh_from_date:srh_from_date,srh_to_date:srh_to_date})
	  .done(function( data ) {		

	  var obj = jQuery.parseJSON(data);	
	  
	  $('#tot_capital_amount').text(accounting.formatMoney(obj.loan_tot_amount, "", 2, ",", "."));
	  $('#tot_r_capital_amount').text(accounting.formatMoney(obj.capital_received, "", 2, ",", "."));
	  $('#tot_capital_balance').text(accounting.formatMoney(obj.capital_balance, "", 2, ",", "."));
	  
	  $('#interest_amount').text(accounting.formatMoney(obj.total_interest, "", 2, ",", "."));
	  $('#interest_r_amount').text(accounting.formatMoney(obj.loan_interest_recived, "", 2, ",", "."));
	  $('#interest_balance').text(accounting.formatMoney(obj.interest_balance, "", 2, ",", "."));
	  
	   $('#panalty_amount').text(accounting.formatMoney(obj.panalty_amount, "", 2, ",", "."));
	   $('#panalty_r_amount').text(accounting.formatMoney(obj.panalty_received, "", 2, ",", "."));
	    $('#panalty_balance').text(accounting.formatMoney(obj.panalty_balance, "", 2, ",", "."));
	 
	  $('#due_amount').text(accounting.formatMoney(obj.due_amount, "", 2, ",", "."));
	  $('#due_r_amount').text(accounting.formatMoney(obj.due_received, "", 2, ",", "."));
	  $('#due_balance').text(accounting.formatMoney(obj.due_balance, "", 2, ",", "."));
	  
	  $('#total_amount').text(accounting.formatMoney(obj.total_payble, "", 2, ",", "."));	
	  $('#total_r_amount').text(accounting.formatMoney(obj.loan_payable_total_amount, "", 2, ",", "."));	
	  $('#total_balance').text(accounting.formatMoney(obj.pymnt_amount, "", 2, ",", "."));	
		
			
	 $('#net_income').text(accounting.formatMoney(obj.net_income, "", 2, ",", "."));	
	 
	
	  //loadGrid();// load customer data
	  });  
	}

</script>
 <script type="text/javascript" language="javascript" src="https://cdn.datatables.net/buttons/1.2.3/js/dataTables.buttons.min.js">
	</script>
	<script type="text/javascript" language="javascript" src="//cdn.datatables.net/buttons/1.2.3/js/buttons.print.min.js">
	</script>
	<script type="text/javascript" language="javascript" src="//cdn.datatables.net/buttons/1.2.3/js/buttons.flash.min.js">
	</script>
	<script type="text/javascript" language="javascript" src="//cdnjs.cloudflare.com/ajax/libs/jszip/2.5.0/jszip.min.js">
	</script>
	<script type="text/javascript" language="javascript" src="//cdn.rawgit.com/bpampuch/pdfmake/0.1.18/build/pdfmake.min.js">
	</script>
	<script type="text/javascript" language="javascript" src="//cdn.rawgit.com/bpampuch/pdfmake/0.1.18/build/vfs_fonts.js">
	</script>
	<script type="text/javascript" language="javascript" src="//cdn.datatables.net/buttons/1.2.3/js/buttons.html5.min.js">
	</script>
	<script type="text/javascript" language="javascript" src="//cdn.datatables.net/buttons/1.2.3/js/buttons.print.min.js"></script>
     
	</body>
	<!-- end: BODY -->
</html>