<?php $this->load->view("common/header"); ?>

<!-- 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="#"> Loan Reports </a> </li>
            <li class="active"> Capital 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">
            <h3>Capital Report</h3>
          </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> Capital Report
              <div class="panel-tools" style="top:2px;">
              <!--------------------->
              <input type="button" onClick="printDiv('printableArea')" value="Print Summary Report" class="pull-right"/>
              <!--------------------->
              </div>
            </div>
          </div>
          <div class="panel-body">
            <div class="col-md-2">
              <div class="form-group">
                <label for="loan_payment_term">Payment Term * </label>
                <select  id="loan_payment_term" class="form-control search-select" name="loan_payment_term" >
                  <option   value="">ALL</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-2">
              <div class="form-group">
                <label>Route </label>
                <select id="route_id" class="form-control search-select" name="route_id">
                  <option value="">ALL</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>
                </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 id="printableArea">
              <div class="page-header">
              
             
                
              
              
              
              <table class="table table-bordered table-condensed table-hover table-striped dataTable" id="">
               <thead>
               </thead>
               <tbody>
               
                <tr>
                  <td width="25%"><strong>Capital Report Summary</strong></td>
                  <td width="25%"><strong>Total</strong> </td>
                  <td width="25%"><strong>Received </strong></td>
                  <td width="25%"><strong>Balance</strong> </td>
                </tr>
                 <tr>
                  <td>Capital</td>
                  <td><div id="tot_capital_amount">Loading....</div></td>
                  <td><div id="tot_r_capital_amount">Loading....</div></td>
                  <td><div id="tot_capital_balance">Loading....</div></td>
                </tr>
                  <tr style="display: none;">
                  <td>Interest</td>
                  <td><div id="interest_amount">Loading....</div></td>
                  <td><div id="interest_r_amount">Loading....</div></td>
                  <td><div id="interest_balance">Loading....</div></td>
                </tr>
                 <tr>
                  <td>Panalty</td>
                  <td><div id="panalty_amount">Loading....</div></td>
                  <td><div id="panalty_r_amount">Loading....</div></td>
                  <td><div id="panalty_balance">Loading....</div></td>
                </tr>
                <tr>
                  <td>Due</td>
                  <td><div id="due_amount">Loading....</div></td>
                  <td><div id="due_r_amount">Loading....</div></td>
                  <td><div id="due_balance">Loading....</div></td>
                </tr>
                 <tr>
                  <td></td>
                  <td></td>
                  <td></td>
                  <td></td>
                </tr>
               <tr>
                  <td>Total </td>
                  <td><div id="total_amount">Loading....</div></td>
                  <td><div id="total_r_amount">Loading....</div></td>
                  <td><div id="total_balance">Loading....</div></td>
                </tr>
               </tbody>
               
               </table>
               <div>
               <hr>
                  From Date: <span id="f-date-txt">Loading....</span>
                 To Date: <span id="t-date-txt">Loading....</span>
                 </div>
                 <div>
                 <br>
             		Net Income Rs.
                  <div id="net_income">Loading....</div>
                  </div>
              
               </div>
               </div>
               
            

            
            </div>
          </div>
        </div>
        <!-- end: DYNAMIC TABLE PANEL --> 
      </div>
    </div>
    
    <!-- end grid --> 
    
  </div>
  <!-- end: PAGE --> 
</div>
<!-- end: MAIN CONTAINER --> 
<!-- start: FOOTER -->
<div class="footer clearfix">
  <div class="footer-inner"> <?php echo date("Y"); ?> © A.S.S.K Loan Management System </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"); ?>
<!-- end: MAIN JAVASCRIPTS --> 
<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 type="text/javascript" src="<?php echo base_url('thems/js/bootbox.min.js'); ?>"></script>
<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" 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>
<script>
jQuery(document).ready(function() {
//TableData.init();
//loadGrid();


var date = new Date();
var firstDay = new Date(date.getFullYear(), date.getMonth(), 1);

				var currentDate = new Date();
				var tomorrow = new Date();				
				$('#srh_to_date').datetimepicker({
					defaultDate: currentDate,
					format:"YYYY-MM-DD"
				});				
				$('#srh_from_date').datetimepicker({
					defaultDate: '',
					format:"YYYY-MM-DD"
				});
				
				//TableData.init();
				load_close_summary();
				
				  $("#route_id").select2();
				
});

			
	
	function searchDetailsReset(){
			//$('#srh_to_date').val('');
			$('#srh_from_date').val('');
		}
		function searchDetails(){
			load_close_summary();
			
		}
		
		
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_capital_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.pymnt_amount, "", 2, ",", "."));	
	  $('#total_balance').text(accounting.formatMoney(obj.total_payble-obj.pymnt_amount, "", 2, ",", "."));	
	
		$('#f-date-txt').text($('#srh_from_date').val());	
		$('#t-date-txt').text($('#srh_to_date').val());		
		$('#net_income').text(accounting.formatMoney(obj.net_income, "", 2, ",", "."));	
	  //loadGrid();// load customer data
	  });  
	}
	
	function printDiv(divName) {
     var printContents = document.getElementById(divName).innerHTML;
     var originalContents = document.body.innerHTML;

     document.body.innerHTML = printContents;

     window.print();

     document.body.innerHTML = originalContents;
}

		
	
</script>
</body>
<!-- end: BODY -->
</html>