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

<!-- 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"> To Be Closing 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>To Be Closing 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> Pending Close Loan( Cheque / Cash )
                <div style="top:2px;">
                  <input type="button" onClick="printDiv('printableArea')" value="Print Summary Report" class="pull-right" />
                </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-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 style="display: none;" 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 style="display: none;" 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-3 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>
                
                <table class="table table-bordered table-condensed table-hover dataTable" id="warehouse_table">
                  <thead>
                    <tr>
                      <th>Customer Code</th>
                      <th>Customer Name</th>
                      <th>Due Date</th>
                      <th>Loan Ref.no</th>
                      <th>Installments <br>
                      <th>Due</th>
                    </tr>
                  </thead>
                  <tfoot>
                    <tr>
                     <th>Customer Code</th>
                      <th>Customer Name</th>
                      <th>Due Date</th>
                      <th>Loan Ref.no</th>
                      <th>Installments <br>
                      <th>Due</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 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>
    function searchDetailsReset() {
      $('#srh_to_date').val('');
      $('#srh_from_date').val('');
    }

    function searchDetails() {
      load_close_summary();
      loadGrid();
    }


    jQuery(document).ready(function() {
      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: firstDay,
        format: "YYYY-MM-DD"
      });

      //TableData.init();
      load_close_summary();
      loadGrid();
      $("#route_id").select2();

    });


    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_not_close_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": [
          [2, "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() {
      $('#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_not_close_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.pymnt_amount, "", 2, ",", "."));

          $('#total_balance').text(accounting.formatMoney(obj.loan_payable_total_amount - obj.pymnt_amount, "", 2, ",", "."));



          $('#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;
    }

    $(document).on('click', function(event) {
      $('tr').css('background-color', 'inherit');
      $(event.target).closest('tr').css('background-color', '#85C1E9');
    });
  </script>

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

</html>