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

<!-- start: CSS REQUIRED FOR THIS PAGE ONLY -->

<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;
	}
</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="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="#"> Marketing Reports </a> </li>
							<li class="active">Customer Outstanding 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>Customer Outstanding 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> Customer Outstanding 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">
											<div class="form-group">
												<label>Route Name </label>
												<select id="route_id" class="form-control" name="route_id">
													<option value="">-- Select Route --</option>
													<?php 
				
                            foreach ($route_list as $row){?>
													<option value="<?php echo $row->route_id; ?>">
														<?php echo $row->route_name; ?> </option>
													<?php }?>
												</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-picker" value="<?php echo date('m/d/Y'); ?>" 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" id="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>
								<input type="button" onClick="printDiv('printableArea')" value="Print Daily Sales Report" class="pull-right"/>
								<div id="printableArea">
									<div id="printableArea">
										<h4>Customer Outstanding summary</h4>
										<div class="page-header"> </div>
										<table class="table table-bordered table-condensed table-hover table-striped dataTable" id="">
											<tr>
												<th>Route</th>
												<td>
													<div id="route">............</div>
												</td>
											</tr>
											<tr>
												<th width="50%">Sale Total</th>
												<td width="50%">
													<div id="sale_total">............</div>
												</td>
											</tr>
											<tr>
												<th width="50%">Sale Return Total</th>
												<td width="50%">
													<div id="sale_return">............</div>
												</td>
											</tr>

											<tr>
												<th>Sale Paid</th>
												<td>
													<div id="sale_paid">............</div>
												</td>
											</tr>
											<tr>
												<th>Outstanding Amount</th>
												<td>
													<div id="outstanding">............</div>
												</td>
											</tr>
										</table>
									</div>
								</div>
								<br>
								<br>
								<br>
								<div class="panel-heading"> <i class="fa fa-external-link-square"></i> collected cash List </div>
								<br>
								<table class="table table-bordered table-condensed table-hover table-striped dataTable" id="outstanding_table">
									<thead>
										<tr>
											<th class="col-sm-1">customer code</th>
											<th class="col-sm-3">customer name</th>
											<th>invoice list</th>
											<th class="col-sm-2">outstanding</th>
										</tr>
									</thead>
									<tfoot>
										<tr>
											<th>customer code</th>
											<th>customer name</th>
											<th>invoice list</th>
											<th>outstanding</th>
										</tr>
								</table>
								<br>
								<br>
							</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"> 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>
		<input name="sales-rtn-val-cost" type="text" id="sales-rtn-cost-fld" value="0">
		<input name="sales-rtn-val-fld" type="text" id="sales-rtn-val-fld" value="0">
		<input name="sales-val-cost" type="text" id="sales-cost-fld" value="0">
		<input name="sales-val-fld" type="text" id="sales-val-fld" value="0">

		<!-- 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/bootstrap-datepicker.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 src="<?php echo asset_url(); ?>/plugins/jquery-inputlimiter/jquery.inputlimiter.1.3.1.min.js"></script>
		<script src="<?php echo asset_url(); ?>/plugins/autosize/jquery.autosize.min.js"></script>
		<script src="<?php echo asset_url(); ?>/plugins/select2/select2.min.js"></script>
		<script src="<?php echo asset_url(); ?>/plugins/jquery.maskedinput/src/jquery.maskedinput.js"></script>
		<script src="<?php echo asset_url(); ?>/plugins/jquery-maskmoney/jquery.maskMoney.js"></script>
		<script src="<?php echo asset_url(); ?>/plugins/bootstrap-datepicker/js/bootstrap-datepicker.js"></script>
		<script src="<?php echo asset_url(); ?>/plugins/bootstrap-timepicker/js/bootstrap-timepicker.min.js"></script>
		<script src="<?php echo asset_url(); ?>/plugins/bootstrap-daterangepicker/moment.min.js"></script>
		<script src="<?php echo asset_url(); ?>/plugins/bootstrap-daterangepicker/daterangepicker.js"></script>
		<script src="<?php echo asset_url(); ?>/plugins/bootstrap-colorpicker/js/bootstrap-colorpicker.js"></script>
		<script src="<?php echo asset_url(); ?>/plugins/bootstrap-colorpicker/js/commits.js"></script>
		<script src="<?php echo asset_url(); ?>/plugins/jQuery-Tags-Input/jquery.tagsinput.js"></script>
		<script src="<?php echo asset_url(); ?>/plugins/bootstrap-fileupload/bootstrap-fileupload.min.js"></script>
		<script src="<?php echo asset_url(); ?>/plugins/summernote/build/summernote.min.js"></script>
		<script src="<?php echo asset_url(); ?>/plugins/ckeditor/ckeditor.js"></script>
		<script src="<?php echo asset_url(); ?>/plugins/ckeditor/adapters/jquery.js"></script>
		<script src="<?php echo asset_url(); ?>/js/form-elements.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>
			function printDiv( divName ) {
				var printContents = document.getElementById( divName ).innerHTML;
				var originalContents = document.body.innerHTML;
				document.body.innerHTML = printContents;
				window.print();
				document.body.innerHTML = originalContents;
			}

			function searchDetailsReset() {
				$( '#srh_from_date' ).val( '' );
			}

			function searchDetails() {
				loadGrid();
				load_ouststanding_summary();
				//load_summary();
			}

			jQuery( document ).ready( function () {
				FormElements.init();
				//var currentDate = new Date();
				var tomorrow = new Date();
				currentDate = tomorrow.setDate( tomorrow.getDate() + 1 );
				//TableData.init();
				//loadGrid();
				//loadGridSalesReturn();
				load_ouststanding_summary();
			} );
			
			
			function load_ouststanding_summary()
			{	
				var route_id=$('#route_id').val();					 
				$.post( "<?php echo base_url();?>reports_marketing/get_customer_outstanding_summary", {route_id:route_id})
				.done(function( data ) {	
				var obj = jQuery.parseJSON(data);	  
				$('#sale_total').text("Rs. "+accounting.formatMoney(obj.sale_total, "", 2, ",", "."));
				$('#sale_return').text("Rs. "+accounting.formatMoney(obj.sale_return, "", 2, ",", "."));
				$('#sale_paid').text("Rs. "+accounting.formatMoney(obj.sale_paid, "", 2, ",", "."));
				$('#outstanding').text("Rs. "+accounting.formatMoney(obj.outstanding, "", 2, ",", "."));
				
	  			});  
			}
			
			function loadGrid() {
						var route_id=$('#route_id').val();
					    $('#outstanding_table').DataTable({
					        "ajax": "<?php echo base_url('reports_marketing/get_customer_outstanding_list?route_id=') ?>"+route_id,
					        "bDestroy": true,
							"serverSide": true,
					        "iDisplayLength": 10,
							"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 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]][3]);
				//	ser_tot2 += parseFloat(aaData[[i]][4]);
				//	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[4].innerHTML = '<div class="text-right">'+accounting.formatMoney(ser_tot2, "", 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;
				//$('#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, ",", "."));
				
              
            }
					    });

					}
			function fbs_click( url ) {
				var srh_from_date = $( '#srh_from_date' ).val();

				var collector_id = $( '#collector_id' ).val();

				u = location.href;
				t = document.title;
				url = '<?php echo base_url();?>' + 'reports_marketing/get_daily_cash_by_collector_id_and_date_summary_print?collector_id=' + collector_id + '&date=' + srh_from_date;
				window.open( url, 'sharer', 'toolbar=0,status=0,width=750,height=436, left=10, top=10,scrollbars=yes' );
				return false;
			}
		</script>
</body>
<!-- end: BODY -->

</html>