<?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="#"> Reports </a> </li>
              <li class="active"> Cash 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>Cash 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> User Payments
                <div class="panel-tools" style="top:2px;">
                  <!--<button onClick="JavaScript:fbs_click('<?php //echo base_url('reports/print_sale?srh_warehouse_id=1'); 
                                                              ?>');" class="btn btn-blue dropdown-toggle" data-toggle="dropdown">
													<i class="fa fa-print"></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-sm-2">
                      <div class="form-group">
                        <?php
                        $ss_group_id = $this->session->userdata('ss_group_id');
                        if ($ss_group_id == 2 || $ss_group_id == 1) { ?>
                          <label>Warehouse </label>
                          <select id="srh_warehouse_id" class="form-control" name="srh_warehouse_id">
                            <option value="">-- Select Warehouse --</option>
                            <?php
                            $ss_warehouse_id = $this->session->userdata('ss_warehouse_id');
                            foreach ($warehouse_list as $row) {
                              $sel = '';
                              if ($ss_warehouse_id == $row->id) {
                                $sel = ' selected="selected"';
                              }
                            ?>
                              <option value="<?php echo $row->id; ?>" <?php echo $sel; ?>> <?php echo $row->name; ?> </option>
                            <?php } ?>
                          </select>
                        <?php } else if ($ss_group_id == 3) {

                        ?>
                          <input name="srh_warehouse_id" type="hidden" value="<?php echo $this->session->userdata('ss_warehouse_id'); ?>">
                        <?php } ?>
                      </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>Collector </label>
                        <select id="user_id" class="form-control" name="user_id">
                          <option value="">All Collectors</option>
                          <?php
                          foreach ($user_list as $row) {
                          ?>
                            <option value="<?php echo $row->user_id; ?>"> <?php echo $row->user_first_name . " - " . $row->user_group_name; ?> </option>
                          <?php } ?>
                        </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()">
                        &nbsp;&nbsp;

                        <!--  <input onClick="print_booking_report();" type="submit" name="add_category" value="Print" class="btn btn-success">-->

                      </div>
                    </div>
                  </div>
                </div>
                <div id="printableArea">
                  <div class="page-header">
                    <table class="table table-bordered table-condensed table-striped table-hover  dataTable" id="">
                      <thead>
                      </thead>
                      <tbody>
                        <tr>
                          <td>
                            <h4>Cash Report Summary</h4> [ Route - <span id="route_display">Loading....</span> | User - <span id="user_display">Loading....</span> | From : <span id="f-date-txt"></span> To : <span id="t-date-txt"></span>]
                          </td>
                          <td></td>
                        </tr>
                        <tr>

                          <td width="25%"><strong>Total Collection</strong> </td>
                          <td width="25%"><strong><span id="total_collection">Loading....</span></strong></td>
                        </tr>
                        <!-- <tr>                     
                      <td width="25%">Loan Collection </td>
                       <td width="25%"><span id="loan_collection">Loading....</span></td>
                    </tr>-->
                        <tr style="color:#063">
                          <td width="25%">Capital Collection </td>
                          <td width="25%"><span id="capital_collection">Loading....</span></td>
                        </tr>
                        <tr style="display: none;">
                          <td width="25%">Interest Collection </td>
                          <td width="25%"><span id="interest_collection">Loading....</span></td>
                        </tr>
                        <tr>
                          <td width="25%">Penety Collection </td>
                          <td width="25%"><span id="penelty_collection">Loading....</span></td>
                        </tr>
                        <tr>
                          <td width="25%">Due Collection </td>
                          <td width="25%"><span id="due_collection">Loading....</span></td>
                        </tr>
                        <tr>
                          <td width="25%">Total Income </td>
                          <td width="25%"><span id="income_collection">Loading....</span></td>
                        </tr>

                      </tbody>

                    </table>
                  </div>
                </div>
                <table class="table table-bordered table-condensed table-hover  dataTable" id="warehouse_table">
                  <thead>
                    <tr>
                      <th>#</th>
                      <th>User</th>
                      <!-- <th>Ref. No.</th>-->
                      <th>Payment Date</th>
                      <th>Loan Number</th>
                      <th>Customer name</th>
                      <!--<th class="text-right">Loan</th>-->
                      <th class="text-right">Paid</th>
                      <th class="text-right">Capital</th>
                      <th class="text-right">Interest</th>
                      <th class="text-right">Penelty</th>
                      <th class="text-right">Due</th>
                      <!--  <th>Cheque Deposited Status</th>
                                            <th>Check Returned Status</th>
                                                  <th>Cash Collected Status</th>-->
                      <!--<th>Collected Status</th>-->


                    </tr>
                  </thead>
                  <tfoot>
                    <tr>
                      <th>&nbsp;</th>
                      <th>User</th>
                      <th>Payment Date</th>
                      <th>Loan Number</th>
                      <th>Customer name</th>
                      <th id="paid_tot_t">Paid</th>
                      <th id="paid_tot_c">Capital</th>
                      <th id="paid_tot_i">Interest</th>
                      <th id="paid_tot_p">Penelty</th>
                      <th id="paid_tot_d">Due</th>



                      <!--<th id="paid_tot_l">Loan</th>-->

                      <!--<th>Cheque Deposited Status</th>
                                               <th>Check Returned Status</th>-->
                      <!-- <th>Collected Status</th>-->


                    </tr>
                </table>
              </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"); ?> &copy; 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"); ?>
    <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="<?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.5.6/js/dataTables.buttons.min.js">
    </script>
    <script type="text/javascript" language="javascript" src="https://cdn.datatables.net/buttons/1.5.6/js/buttons.print.min.js">
    </script>
    <script>
      function searchDetailsReset() {
        $('#srh_to_date').val('');
        $('#srh_from_date').val('');
      }

      function searchDetails() {

        loadGrid();
        load_sum_collected_payment_summary();
      }





      function loadGrid() {
        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 user_id = $('#user_id').val();
        var route_id = $('#route_id').val();


        $('#warehouse_table').DataTable({

          dom: 'Blfrtip',
          buttons: [{
              extend: 'print',
              text: 'Print',
              footer: true
            },


          ],

          "ajax": {
            'type': 'POST',
            'url': '<?php echo base_url('reports/get_list_payments_for_report'); ?>',
            'data': {
              srh_from_date: srh_from_date,
              srh_to_date: srh_to_date,
              srh_warehouse_id: srh_warehouse_id,
              user_id: user_id,
              route_id: route_id,
            }
          },
          "bDestroy": true,
          "iDisplayLength": 20,
          "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]][11]);	
              /*ser_tot5 += parseFloat(aaData[[i]][9]);*/
            }
            var nCells = nRow.getElementsByTagName('th');

            //nCells[11].innerHTML = '<div class="text-right">'+accounting.formatMoney(ser_tot4, "", 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>';*/

          }
        });

        $('#f-date-txt').text($('#srh_from_date').val());
        $('#t-date-txt').text($('#srh_to_date').val());

      }


      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: currentDate,
          format: "YYYY-MM-DD"
        });
        searchDetails();
        //loadGrid();
      });


      function load_sum_collected_payment_summary() {
        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 user_id = $('#user_id').val();
        var route_id = $('#route_id').val();

        $.post("<?php echo base_url(); ?>reports/get_list_payments_for_report_summary", {
            srh_from_date: srh_from_date,
            srh_to_date: srh_to_date,
            srh_warehouse_id: srh_warehouse_id,
            user_id: user_id,
            route_id: route_id,
          })
          .done(function(data) {
            var obj = jQuery.parseJSON(data);
            $('#total_collection').text("Rs. " + accounting.formatMoney(obj.total_paid, "", 2, ",", "."));
            $('#loan_collection').text("Rs. " + accounting.formatMoney(obj.loan_received, "", 2, ",", "."));
            $('#capital_collection').text("Rs. " + accounting.formatMoney(obj.capital_received, "", 2, ",", "."));
            $('#interest_collection').text("Rs. " + accounting.formatMoney(obj.loan_interest_recived, "", 2, ",", "."));
            $('#penelty_collection').text("Rs. " + accounting.formatMoney(obj.panalty_received, "", 2, ",", "."));
            $('#due_collection').text("Rs. " + accounting.formatMoney(obj.due_received, "", 2, ",", "."));
            $('#income_collection').text("Rs. " + accounting.formatMoney(obj.total_income, "", 2, ",", "."));










            $('#paid_tot_t').text("Rs. " + accounting.formatMoney(obj.total_paid, "", 2, ",", "."));
            //$('#paid_tot_l').text("Rs. "+accounting.formatMoney(obj.loan_received, "", 2, ",", "."));
            $('#paid_tot_c').text("Rs. " + accounting.formatMoney(obj.capital_received, "", 2, ",", "."));
            $('#paid_tot_i').text("Rs. " + accounting.formatMoney(obj.loan_interest_recived, "", 2, ",", "."));
            $('#paid_tot_p').text("Rs. " + accounting.formatMoney(obj.panalty_received, "", 2, ",", "."));
            $('#paid_tot_d').text("Rs. " + accounting.formatMoney(obj.due_received, "", 2, ",", "."));
            $('#route_display').text($("#route_id option:selected").text());
            $('#user_display').text($("#user_id option:selected").text());


            //$('#total_collection').text(accounting.formatMoney(ser_tot4, "", 2, ",", "."));

            //loadGrid();// load customer data
          });


      }



      <?php /*?>function changeColectedStatus_this_page(id,sta,type){
				 //  alert(id);
	   var fld_id='collected_'+id;
	  // alert(sta);
	  paymnt_id=id;
	  if(sta){
		  status=1;
	  }else {
		  status=0;
	  }

			$.post( "<?php echo base_url();?>loan/change_collected_status", {paymnt_id:paymnt_id, status:status, type:type})
	  .done(function( data ) {
		
	  	var obj = jQuery.parseJSON(data);
		 if (obj.status==0) 
		{
		
		}		  
	   if (obj.status==1) 
		{
			var type_name='';
			if(type=='collected'){
			type_name='Collected';
		}
		if(type=='deposited'){
			type_name='Deposited';
		}
		if(type=='returned'){
			type_name='Returned';
		}
		
	   if(sta){
		   displayNotice('Payment','Payment '+type_name);
		   load_sum_collected_payment_summary();
    	 // Code in the case checkbox is checked.
		} else {
			displayNotice('Payment','Deleted Payment '+type_name+ ' Status');
			load_sum_collected_payment_summary();
		  // alert('no');
     		// Code in the case checkbox is NOT checked.
		}
		}
		});
		
	   return false;
	   
   }<?php */ ?>
      $(document).on('click', function(event) {
        $('tr').css('background-color', 'inherit');
        $(event.target).closest('tr').css('background-color', '#0F6');
      });
    </script>

    <div id="log">old </div>
</body>
<!-- end: BODY -->

</html>