<?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>
<link rel="stylesheet" href="<?php echo asset_url();?>css/buttons.dataTables.min.css" type="text/css" />
<!-- 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 Due 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 Due 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 Due 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-2">
											<div class="form-group">
												<label>Route Name </label>
												<select id="route_id" class="form-control search-select" name="route_id">
													<option value="">-- All Routes --</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-2">
											<div class="form-group">
												<label>Sale Type </label>
												<select id="type_id" class="form-control search-select" name="type_id">
													<option value="">-- All --</option>
													<?php 
				
                            foreach ($type_list as $row){?>
													<option value="<?php echo $row['invoice_type_id']; ?>">
														<?php echo $row['invoice_type_name']; ?> </option>
													<?php }?>
												</select>
											</div>
										</div>
										
										
										<div class="col-sm-3">
											<div class="form-group">
												<label>Customer Name </label>
												<select id="cus_id" class="form-control search-select" name="cus_id">
													<option value="">-- All Customers --</option>
													<?php 
				
                            foreach ($cus_list as $row){?>
													<option value="<?php echo $row['cus_id']; ?>">
														<?php echo "( ".$row['cus_code']." ) ".$row['cus_name']; ?> </option>
													<?php }?>
												</select>
											</div>
										</div>
										
										
										
										<div class="col-sm-2">
											<div class="form-group">
												<label>Status </label>
												<select id="status_id" class="form-control search-select" name="status_id">
													<option value="">-- All --</option>
													<option value=pending>Pending</option>
													<option value=completed>Completed</option>
														 
													
												</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-picker" value="<?php //echo date('Y-m-d'); ?>" data-bv-field="date"/>
                  </div>
                </div>
                <div class="col-sm-2">
                  <div class="form-group">
                    <label>To Date </label>
                    <input id="srh_to_date" name="srh_to_date" type='text' class="form-control date-picker" value="<?php echo date('Y-m-d'); ?>" 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 Due 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%">Cash Sale Due Total</th>
												<td width="50%">
													<div id="completed_total">............</div>
												</td>
											</tr>
											
											<tr>
												<th width="50%">Credit Sale Due Total</th>
												<td width="50%">
													<div id="pending_total">............</div>
												</td>
											</tr>
											
											<tr>
												<th width="50%">Total Due </th>
												<td width="50%">
													<div id="order_total">............</div>
												</td>
											</tr>
											
											
										</table>
									</div>
								</div>
								<br>
								<br>
								<br>
								<div class="panel-heading"> <i class="fa fa-external-link-square"></i> Order List </div>
								<br>
								<table class="table table-bordered table-condensed table-hover table-striped dataTable" id="payment_table">
									<thead>
										<tr>
											<th class="col-sm-1">Date</th>
											<th class="col-sm-1">Type</th>
											<th class="col-sm-1">Sale No</th>
											<th class="col-sm-1">Customer code</th>
											<th class="col-sm-2">Customer Name</th>											
											<th class="col-sm-1">Due Date</th>
											<th class="col-sm-1">Net Amount</th>											
											<th class="col-sm-1">Paid Amount</th>
											<th class="col-sm-1">Due Amount</th>
										</tr>
									</thead>
									<tfoot>
										<tr>
											<th class="col-sm-1">Date</th>
											<th class="col-sm-1">Type</th>
											<th class="col-sm-1">Sale No</th>
											<th class="col-sm-1">Customer code</th>
											<th class="col-sm-2">Customer Name</th>											
											<th class="col-sm-1">Due Date</th>
											<th class="col-sm-1">Net Amount</th>											
											<th class="col-sm-1">Paid Amount</th>
											<th class="col-sm-1">Due Amount</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 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.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 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_summary();
			}

			jQuery( document ).ready( function () {
				
				$('.date-picker').datetimepicker({
					format:"YYYY-MM-DD"
				});
				
				$('.search-select').select2();
				//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_summary()
			{	
				var srh_from_date=$('#srh_from_date').val();	
				var srh_to_date=$('#srh_to_date').val();
				var route_id=$('#route_id').val();	
				var cus_id=$('#cus_id').val();
				var status_id=$('#status_id').val();
				var type_id=$('#type_id').val();				 
				$.post( "<?php echo base_url();?>reports_marketing/get_order_summary_report", {route_id:route_id,from_date:srh_from_date,to_date:srh_to_date,cus_id:cus_id,status_id:status_id,type_id:type_id})
				.done(function( data ) {	
				var obj = jQuery.parseJSON(data);	  
				$('#order_total').text("Rs. "+accounting.formatMoney(obj.order_total, "", 2, ",", "."));
				$('#completed_total').text("Rs. "+accounting.formatMoney(obj.completed_total, "", 2, ",", "."));
				$('#pending_total').text("Rs. "+accounting.formatMoney(obj.pending_total, "", 2, ",", "."));
				
	  			});  
			}
			
			
			function loadGrid() {
			var srh_from_date=$('#srh_from_date').val();	
			var srh_to_date=$('#srh_to_date').val();
			var route_id=$('#route_id').val();	
			var cus_id=$('#cus_id').val();
			var status_id=$('#status_id').val();
			var type_id=$('#type_id').val();					
						
					    $('#payment_table').DataTable({
							dom: 'Blfrtip',
				lengthMenu: [[10, 25, 50, -1 ], [10, 25, 50, "All"]],
				buttons: [
						{ extend: 'copy', text: '<i class="fa fa-copy fa-2x"></i>',footer: true, exportOptions:
				 [ 0,1,2,3,4,5,6,7,8]},
						   { extend: 'print', text: '<i class="fa fa-print fa-2x"></i>',footer: true,exportOptions:
	 { columns: [0,1,2,3,4,5,6,7,8] },title:"<center>Due Sale Report</center>"},
							{ extend: 'excel', text: '<i class="far fa-file-excel fa-2x"></i>Excel',footer: true,exportOptions:
	 { columns: [0,1,2,3,4,5,6,7,8] },title:"Due Sale Report "},
							 { extend: 'pdf', text: '<i class="far fa-file-pdf fa-2x"></i>PDF',footer: true,exportOptions:
	 { columns: [0,1,2,3,4,5,6,7,8] },title:"Due Sale Report"},							 
						],
							"ajax": {
							'type': 'POST',
							'url': '<?php echo base_url('reports_marketing/get_customer_due_report');?>?to_date='+srh_to_date +'&from_date='+srh_from_date+'&route_id='+route_id+'&cus_id='+cus_id+'&status_id='+status_id+'&type_id='+type_id,
							'data': {							  
							}
							},
					        "bDestroy": true,
					        "iDisplayLength": 10,
					        "bDestroy": true,
					        "iDisplayLength": 20,
							"order": false, "fnFooterCallback": function (nRow, aaData, iStart, iEnd, aiDisplay) {
				
				var ser_tot1=0;
				var ser_tot2=0;
				var ser_tot3=0;
				var ser_tot4=0;	
				var ser_tot5=0;	
				var ser_tot6=0;
                for (var i = 0; i < aaData.length; i++) {					
					//ser_tot1 += parseFloat(aaData[[i]][3]);
					//ser_tot2 += parseFloat(aaData[[i]][4]);
					//ser_tot3 += parseFloat(aaData[[i]][5]);
					//ser_tot4 += parseFloat(aaData[[i]][6]);	
					//ser_tot5 += parseFloat(aaData[[i]][7]);
					ser_tot6 += parseFloat(aaData[[i]][8]);
                }					
                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>';				
				//nCells[6].innerHTML = '<div class="text-right">'+accounting.formatMoney(ser_tot4, "", 2, ",", ".")+' </div>';
				//nCells[7].innerHTML = '<div class="text-right">'+accounting.formatMoney(ser_tot5, "", 2, ",", ".")+' </div>';	
				nCells[8].innerHTML = '<div class="text-right">'+accounting.formatMoney(ser_tot6, "", 2, ",", ".")+' </div>';				
            }
					    });
		}
			
			
			
			
			
			
			
			
			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>