<?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>User </label>
                    <select id="user_id" class="form-control" name="user_id">
                      <option value="">All Users</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>                     
                      <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>