<?php $this->load->view("common/header"); ?>
<!-- end: HEAD -->
<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;
}
</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="fa fa-list"></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"> Supplier Payment 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="fa fa-search"></i> </button>
                </div>
              </form>
            </li>
          </ol>
          <div class="page-header">
            <h1>Supplier Payment 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> Cheque Report
              <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-4" style="display:none">
                    <div class="form-group">
                      <label>User </label>
                      <select id="srh_user_id" class="form-control" name="srh_user_id">
                        <option value=""> -Select- </option>
                        <?php 
																 $ss_user_id=$this->session->userdata('ss_user_id'); 
                                                              foreach ($user_list as $row)
                                                              {
																  $sel='';
																  if($ss_user_id==$row->user_id)
																  {
																	  $sel=' selected="selected"';
																  }
                                                              ?>
                        <option value="<?php echo $row->user_id; ?>" <?php echo $sel; ?>> <?php echo $row->user_first_name; ?> </option>
                        <?php }?>
                      </select>
                    </div>
                  </div>
                  <div class="col-sm-4" style="display:none">
                    <div class="form-group">
                      <label>Type </label>
                      <select id="srh_type" class="form-control" name="srh_type">
                        <!--<option value="">-- Select --</option>-->
                        <option value="sale"> Sales </option>
                        <option value="grn" selected> GRN </option>
                        <option value="sales_return"> Sales Return </option>
                      </select>
                    </div>
                  </div>
                  <div class="col-sm-4" style="display:none">
                    <div class="form-group">
                      <label>Payment Term </label>
                      <select id="srh_payment_term" class="form-control" name="srh_payment_term">
                        <option value="">-- Select --</option>
                        <option value="Cash"> Cash </option>
                        <option value="Cheque"> Cheque </option>
                      </select>
                    </div>
                  </div>
                  <div class="col-sm-4">
                    <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"/>                    -->
                      
                      <input id="srh_from_date" name="srh_from_date" type='text' class="form-control date-time" value="<?php echo date('Y/m/d'); ?>" data-bv-field="date"/>
                      <?php //echo date('m/d/Y', strtotime('-1 day', strtotime(date('m/d/Y')))); ?>
                    </div>
                  </div>
                  <div class="col-sm-4">
                    <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"/>        -->
                      
                      <input id="srh_to_date" name="srh_to_date" type='text' class="form-control date-time" value="<?php echo date('Y/m/d'); ?>" data-bv-field="date"/>
                    </div>
                  </div>
                  <div class="col-sm-4" style="display:none">
                    <div class="form-group">
                      <?php
				$ss_group_id=$this->session->userdata('ss_group_id');
				//echo $ss_group_id;
				 if ($ss_group_id==1) 
				 {?>
                      <label>Warehouse </label>
                      <select id="srh_warehouse_id" class="form-control" name="srh_warehouse_id">
                        <?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-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>
              <table class="table table-bordered table-condensed table-hover table-striped dataTable" id="warehouse_table">
                <thead>
                  <tr>
                    <th>#</th>
                    <th>Customer / Supplier</th>
                    <th>Cheque Received Date</th>
                    <th>Bank</th>
                    <th>Cheque No</th>
                    <th>Realized Date</th>
                    <th>Invoice / GRN No</th>
                    <th class="text-right" style="text-align:right !important;"> Amount</th>
                  </tr>
                </thead>
                <tfoot>
                  <tr>
                    <th>&nbsp;</th>
                    <th>&nbsp;</th>
                    <th>&nbsp;</th>
                    <th>&nbsp;</th>
                    <th>&nbsp;</th>
                    <th>&nbsp;</th>
                    <th>&nbsp;</th>
                    <th>&nbsp;</th>
                  </tr>
                </tfoot>
              </table>
            </div>
          </div>
          <!-- end: DYNAMIC TABLE PANEL --> 
        </div>
      </div>
      
      <!-- end grid --> 
      
    </div>
    <!-- end: PAGE --> 
  </div>
</div>
<!-- end: MAIN CONTAINER --> 
<!-- start: FOOTER --> 

<!-- 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/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/accounting.js"></script> 
<script type="text/javascript" src="<?php echo asset_url(); ?>js/accounting.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> 
<!-- end: MAIN JAVASCRIPTS --> 
<script type="text/javascript" language="javascript" src="<?php echo asset_url(); ?>js/dataTables.buttons.min.js">
	</script> 
<script type="text/javascript" language="javascript" src="<?php echo asset_url(); ?>js/buttons.print.min.js">
	</script> 
<script type="text/javascript" language="javascript" src="<?php echo asset_url(); ?>js/buttons.flash.min.js">
	</script> 
<script type="text/javascript" language="javascript" src="<?php echo asset_url(); ?>js/jszip.min.js">
	</script> 
<script type="text/javascript" language="javascript" src="<?php echo asset_url(); ?>js/pdfmake.min.js">
	</script> 
<script type="text/javascript" language="javascript" src="<?php echo asset_url(); ?>js/vfs_fonts.js">
	</script> 
<script type="text/javascript" language="javascript" src="<?php echo asset_url(); ?>js/buttons.html5.min.js">
	</script> 
<script type="text/javascript" language="javascript" src="<?php echo asset_url(); ?>js/buttons.print.min.js"></script> 

<script>
		
		function searchDetailsReset(){
			$('#srh_to_date').val('');
			$('#srh_from_date').val('');
		}
		function searchDetails(){
					
					loadGrid();
		}
				
				
			jQuery(document).ready(function() {
				//FormElements.init();
					$("#srh_customer_id").select2();
				//TableData.init();
				loadGrid();
				
				/*var currentDate = new Date();
				$('#srh_to_date').datetimepicker({
					defaultDate: new Date()
				});
				$('#srh_from_date').datetimepicker({
					defaultDate: new Date()
				});*/
				
				$('.date-time').datetimepicker({
		defaultDate: new Date()
		});
			});


			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 srh_customer_id=$('#srh_customer_id').val();
			var srh_payment_status=$('#srh_payment_status').val();
			var srh_type=$('#srh_type').val();
	
							
					    $('#warehouse_table').DataTable({
							dom: 'Blfrtip',
							
						buttons: [
       { extend: 'print', text: '<i class="fa fa-print fa-2x"></i>',footer: true},
        { extend: 'excel', text: '<i class="fa fa-file-excel-o fa-2x"></i>',footer: true},
		 { extend: 'pdf', text: '<i class="fa fa-file-pdf-o fa-2x"></i>',footer: true},
		
    ],
							"ajax": {
							'type': 'POST',
							'url': '<?php echo base_url('reports/get_list_supplier_payment_for_report');?>',
							'data': {
							   srh_from_date: srh_from_date,
							   srh_to_date: srh_to_date,
							   srh_warehouse_id: srh_warehouse_id,
							    srh_customer_id: srh_customer_id,
							   srh_payment_status: srh_payment_status,
							   srh_type:srh_type,
						}
							},
					        "bDestroy": true,
					        "iDisplayLength": 20,
							"columnDefs": [
    { className: "text-left", "targets": [ 1 ] }
  ],
							"order": [[ 0, "asc" ]], "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 pay_type='';
				var sales_return_tot=0;
				var sales_grn_tot=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]][7]);
					//pay_type=aaData[[i]][4];
					if(aaData[[i]][3]=='sale'){
						//ser_tot2 += parseFloat(aaData[[i]][5]);
						//alert(aaData[[i]][4]);
						//alert(ser_tot2);
					}else {
						
						//ser_tot2 -= parseFloat(aaData[[i]][6]);
						if(aaData[[i]][3]=='grn'){
							//sales_grn_tot += parseFloat(aaData[[i]][5]);
						}
						if(aaData[[i]][3]=='sales_return'){
							//alert(aaData[[i]][4]);
							//sales_return_tot += parseFloat(aaData[[i]][5]);
							//alert(sales_return_tot);
						}
						
					}
					
					
					//ser_tot3 += parseFloat(aaData[[i]][5]);	
                }
                var nCells = nRow.getElementsByTagName('th');
			//	nCells[3].innerHTML = '<div class="text-right">'+accounting.formatMoney(ser_tot1, "", 2, ",", ".")+' </div>';
				
				
				nCells[7].innerHTML = '<div class="text-right">'+accounting.formatMoney(ser_tot1, "", 2, ",", ".")+' </div>';
			//	nCells[5].innerHTML = '<div class="text-right">'+accounting.formatMoney(ser_tot3, "", 2, ",", ".")+' </div>';
				
				var sales_rtn_tot_cost=ser_tot1;
				var sales_rtn_tot_val=ser_tot2;
				//alert(ser_tot2);
				$('#sales_summ_tbl').text(accounting.formatMoney(ser_tot2, "", 2, ",", "."));
				$('#sales_grn_tbl').text(accounting.formatMoney(sales_grn_tot, "", 2, ",", "."));
				$('#sales_return_tbl').text(accounting.formatMoney(sales_return_tot, "", 2, ",", "."));
				$('#sales_summ_fld').val(ser_tot2-sales_grn_tot-sales_return_tot);
			//	$('#sales-rtn-cost-fld').val(accounting.formatMoney(sales_rtn_tot_cost, "", 2, ",", "."));
				//$('#sales-rtn-val-fld').val(accounting.formatMoney(sales_rtn_tot_val, "", 2, ",", "."));
			//	$('#sales-rtn-cost-tbl').text(accounting.formatMoney(sales_rtn_tot_cost, "", 2, ",", "."));
			//	$('#sales-rtn-val-tbl').text(accounting.formatMoney(sales_rtn_tot_val, "", 2, ",", "."));
				
				
				
				
              
            }
					    });

					}
					

$( document ).ajaxStart(function() {
   $('body').modalmanager('loading');
});


$( document ).ajaxStop(function() {
  $('body').modalmanager('removeLoading');
  $('body').removeClass('modal-open');
  $('body').removeClass('page-overflow');
});



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