<?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">Rep Commission Breakdown 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>Rep Commission Breakdown 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> Rep Commission Breakdown 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>User 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['user_id']; ?>">
														<?php echo $row['user_first_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-picker" value="<?php echo date('m/d/Y'); ?>" 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('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>Rep Commission 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> Sales Commission List </div>
								<div class="panel-body">
								<table class="table table-bordered table-condensed table-hover table-striped dataTable" id="outstanding_table">
									<thead>
										<tr>
											<th class="col-sm-1">Invoice No</th>
											<th class="col-sm-1">Invoice type</th>
											<th class="col-sm-1">Invoice Date</th>
											<th class="col-sm-1">Commsion due date</th>
											<th class="col-sm-1">last Payment Date</th>
											<th class="col-sm-1">Invoice Total</th>
											<th class="col-sm-1">Paid (Total)</th>
											<th class="col-sm-1">paid (Due Date)</th>
										    <!--<th class="col-sm-1">Commission<br>(Invoice)</th>-->
											<th class="col-sm-1">Commission<br>(Paid (Due Date))</th>
											<th class="col-sm-1">Selected Product <br>(Deduction)</th>
											<th class="col-sm-1">Commission Total</th>
											
											
										</tr>
									</thead>
									<tfoot>
										<tr>
										<th class="col-sm-1">Invoice No</th>
											<th class="col-sm-1">Invoice type</th>
											<th class="col-sm-1">Invoice Date</th>
											<th class="col-sm-1">Commsion due date</th>
											<th class="col-sm-1">last Payment Date</th>
											<th class="col-sm-1">Invoice Total</th>
											<th class="col-sm-1">Paid (Total)</th>
											<th class="col-sm-1">paid (Due Date)</th>
										    <!--<th class="col-sm-1">Commission<br>(Invoice)</th>-->
											<th class="col-sm-1">Commission<br>(Paid (Due Date))</th>
											<th class="col-sm-1">Selected Product <br>(Deduction)</th>
											<th class="col-sm-1">Commission Total</th>
											
											
										</tr>
								</table>
								<br>
								<br>
								</div>
							
							<div>
							<hr>							
						</div>
						<div class="panel-heading"> <i class="fa fa-external-link-square"></i> Sales Return Deductions List </div>
								<br>
								<table class="table table-bordered table-condensed table-hover table-striped dataTable" id="outstanding_table_return">
									<thead>
										<tr>
											<th class="col-sm-1">Return No</th>
											<th class="col-sm-1">Return Invoice type</th>
											<th class="col-sm-1">Return Date</th>
											<th class="col-sm-1">Return Amount</th>
											<th class="col-sm-1">Reutn Cash <br>Value </th>
											<th class="col-sm-1">Reutn Credit <br>Value </th>											
											<th class="col-sm-1">Deducted Commission<br>(Cash)</th>
											<th class="col-sm-1">Deducted Commission<br>(Credit)</th>									
											<th class="col-sm-1">Retun Commission Deduction</th>
											
											
										</tr>
									</thead>
									<tfoot>
										<tr>
										<th class="col-sm-1">Return No</th>
											<th class="col-sm-1">Return Invoice type</th>
											<th class="col-sm-1">Return Date</th>
											<th class="col-sm-1">Return Amount</th>
											<th class="col-sm-1">Reutn Cash <br>Value </th>
											<th class="col-sm-1">Reutn Credit <br>Value </th>											
											<th class="col-sm-1">Deducted Commission<br>(Cash)</th>
											<th class="col-sm-1">Deducted Commission<br>(Credit)</th>									
											<th class="col-sm-1">Retun Commission Deduction</th>
											
											
										</tr>
								</table>
									<div>
							<hr>							
						</div>
						<div class="panel-heading"> <i class="fa fa-external-link-square"></i> Cheque Return Deductions List (settled ) </div>
								<br>
								<table class="table table-bordered table-condensed table-hover table-striped dataTable" id="chequ_table_return">
									<thead>
										<tr>
											<th class="col-sm-1">Cheque No</th>
											<th class="col-sm-1">Cheque Date</th>
											<th class="col-sm-1">Return Date</th>
											<th class="col-sm-1">settled Date</th>
											<th class="col-sm-1">Return Invoice type</th>
											<th class="col-sm-1">Cheque Amount</th>
											<th class="col-sm-1">Deduction <br>Value </th>
											
										</tr>
									</thead>
									<tfoot>
										<tr>
										<th class="col-sm-1">Cheque No</th>
											<th class="col-sm-1">Cheque Date</th>
											<th class="col-sm-1">Return Date</th>
											<th class="col-sm-1">settled Date</th>
											<th class="col-sm-1">Return Invoice type</th>
											<th class="col-sm-1">Cheque Amount</th>
											<th class="col-sm-1">Deduction <br>Value </th>
											
											
										</tr>
								</table>
								<br>
								<br>
								<hr>
								<div class="panel-heading"> <i class="fa fa-external-link-square"></i> Cheque Return Deductions List ( not settle ) </div>
								<br>
								<table class="table table-bordered table-condensed table-hover table-striped dataTable" id="chequ_table_return_not_settle">
									<thead>
										<tr>
											<th class="col-sm-1">Cheque No</th>
											<th class="col-sm-1">Cheque Date</th>
											<th class="col-sm-1">Return Date</th>
											<th class="col-sm-1">Settlemet Date</th>
											<th class="col-sm-1">Return Invoice type</th>
											<th class="col-sm-1">Cheque Amount</th>
											<th class="col-sm-1">Deduction <br>Value </th>
											
										</tr>
									</thead>
									<tfoot>
										<tr>
										<th class="col-sm-1">Cheque No</th>
											<th class="col-sm-1">Cheque Date</th>
											<th class="col-sm-1">Return Date</th>
											<th class="col-sm-1">Settlemet Date</th>
											<th class="col-sm-1">Return Invoice type</th>
											<th class="col-sm-1">Cheque Amount</th>
											<th class="col-sm-1">Deduction <br>Value </th>
											
											
										</tr>
								</table>
								<br>
								<br>
							
							</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.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 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( '' );
				$( '#srh_to_date' ).val( '' );
			}

			function searchDetails() {
				loadGrid();		
				loadGrid2();
				loadGrid3();
				loadGrid4();
			}

			jQuery( document ).ready( function () {
				FormElements.init();
				//var currentDate = new Date();
				var tomorrow = new Date();			
			} );
			
			
		
			function loadGrid() {
						var route_id=$('#route_id').val();
						var fromdate=$( '#srh_from_date' ).val();
						var todate=$( '#srh_to_date' ).val();
					    $('#outstanding_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,3]},
						   { extend: 'print', text: '<i class="fa fa-print fa-2x"></i>',footer: true,exportOptions:
	 { columns: [0,1,3] },title:"<center>Outstanding Report </center>"},
							{ extend: 'excel', text: '<i class="far fa-file-excel fa-2x"></i>Excel',footer: true,exportOptions:
	 { columns: [0,1,3] },title:"Outstanding Report"},
							 { extend: 'pdf', text: '<i class="far fa-file-pdf fa-2x"></i>PDF',footer: true,exportOptions:
	 { columns: [0,1,3] },title:"Outstanding Report"},							 
						],
					        "ajax": "<?php echo base_url('reports_marketing/get_rep_commission_breakdown?route_id=') ?>"+route_id+"&fromdate="+fromdate+"&todate="+todate,
					        "bDestroy": true,							
							"serverSide": false,
					        "iDisplayLength": 50,
							"order": false, "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_tot1=0;
				var ser_tot2=0;
				var ser_tot3=0;
				var ser_tot4=0;
				var ser_tot5=0;
				var ser_tot6=0;
				var ser_tot7=0;
				var ser_tot8=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]][8]);	
					ser_tot5 += parseFloat(aaData[[i]][9]);	
					ser_tot6 += parseFloat(aaData[[i]][10]);	
					//ser_tot7 += parseFloat(aaData[[i]][11]);
					//ser_tot8 += parseFloat(aaData[[i]][12]);	
				
                }
              var nCells = nRow.getElementsByTagName('th');
				nCells[5].innerHTML = '<div class="text-right">'+accounting.formatMoney(ser_tot1, "", 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>';			
				nCells[10].innerHTML = '<div class="text-right">'+accounting.formatMoney(ser_tot6, "", 2, ",", ".")+' </div>';
				//nCells[11].innerHTML = '<div class="text-right">'+accounting.formatMoney(ser_tot7, "", 2, ",", ".")+' </div>';
				//nCells[12].innerHTML = '<div class="text-right">'+accounting.formatMoney(ser_tot8, "", 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 route_id = $( '#route_id' ).val();
				u = location.href;
				t = document.title;
				url = '<?php echo base_url();?>' + 'reports_marketing/customer_outstanding_report_print?route_id=' + route_id ;
				//window.open( url, 'sharer', 'toolbar=0,status=0,width=750,height=436, left=10, top=10,scrollbars=yes' );
				return false;
			}


			function loadGrid2() {
						var route_id=$('#route_id').val();
						var fromdate=$( '#srh_from_date' ).val();
						var todate=$( '#srh_to_date' ).val();
					    $('#outstanding_table_return').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,3]},
						   { extend: 'print', text: '<i class="fa fa-print fa-2x"></i>',footer: true,exportOptions:
	 { columns: [0,1,3] },title:"<center>Outstanding Report </center>"},
							{ extend: 'excel', text: '<i class="far fa-file-excel fa-2x"></i>Excel',footer: true,exportOptions:
	 { columns: [0,1,3] },title:"Outstanding Report"},
							 { extend: 'pdf', text: '<i class="far fa-file-pdf fa-2x"></i>PDF',footer: true,exportOptions:
	 { columns: [0,1,3] },title:"Outstanding Report"},							 
						],
					        "ajax": "<?php echo base_url('reports_marketing/get_rep_commission_breakdown_return?route_id=') ?>"+route_id+"&fromdate="+fromdate+"&todate="+todate,
					        "bDestroy": true,							
							"serverSide": false,
					        "iDisplayLength": 200,
							"order": false, "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_tot1=0;
				var ser_tot2=0;
				var ser_tot3=0;
				var ser_tot4=0;
				var ser_tot5=0;
				var ser_tot6=0;
				var ser_tot7=0;
				var ser_tot8=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]][4]);
					ser_tot2 += parseFloat(aaData[[i]][5]);
					ser_tot3 += parseFloat(aaData[[i]][6]);	
					ser_tot4 += parseFloat(aaData[[i]][7]);	
					ser_tot5 += parseFloat(aaData[[i]][8]);	
					ser_tot6 += parseFloat(aaData[[i]][3]);	
					//ser_tot7 += parseFloat(aaData[[i]][11]);
					//ser_tot8 += parseFloat(aaData[[i]][12]);	
				
                }
              var nCells = nRow.getElementsByTagName('th');
			 	nCells[3].innerHTML = '<div class="text-right">'+accounting.formatMoney(ser_tot6, "", 2, ",", ".")+' </div>';
				nCells[4].innerHTML = '<div class="text-right">'+accounting.formatMoney(ser_tot1, "", 2, ",", ".")+' </div>';			
				nCells[5].innerHTML = '<div class="text-right">'+accounting.formatMoney(ser_tot2, "", 2, ",", ".")+' </div>';
				nCells[6].innerHTML = '<div class="text-right">'+accounting.formatMoney(ser_tot3, "", 2, ",", ".")+' </div>';
				nCells[7].innerHTML = '<div class="text-right">'+accounting.formatMoney(ser_tot4, "", 2, ",", ".")+' </div>';
				nCells[8].innerHTML = '<div class="text-right">'+accounting.formatMoney(ser_tot5, "", 2, ",", ".")+' </div>';			
				//nCells[9].innerHTML = '<div class="text-right">'+accounting.formatMoney(ser_tot6, "", 2, ",", ".")+' </div>';
				//nCells[11].innerHTML = '<div class="text-right">'+accounting.formatMoney(ser_tot7, "", 2, ",", ".")+' </div>';
				//nCells[12].innerHTML = '<div class="text-right">'+accounting.formatMoney(ser_tot8, "", 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 loadGrid3() {
						var route_id=$('#route_id').val();
						var fromdate=$( '#srh_from_date' ).val();
						var todate=$( '#srh_to_date' ).val();
					    $('#chequ_table_return').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,3]},
						   { extend: 'print', text: '<i class="fa fa-print fa-2x"></i>',footer: true,exportOptions:
	 { columns: [0,1,3] },title:"<center>Outstanding Report </center>"},
							{ extend: 'excel', text: '<i class="far fa-file-excel fa-2x"></i>Excel',footer: true,exportOptions:
	 { columns: [0,1,3] },title:"Outstanding Report"},
							 { extend: 'pdf', text: '<i class="far fa-file-pdf fa-2x"></i>PDF',footer: true,exportOptions:
	 { columns: [0,1,3] },title:"Outstanding Report"},							 
						],
					        "ajax": "<?php echo base_url('reports_marketing/get_rep_commission_breakdown_cheque_return?route_id=') ?>"+route_id+"&fromdate="+fromdate+"&todate="+todate,
					        "bDestroy": true,							
							"serverSide": false,
					        "iDisplayLength": 200,
							"order": false, "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_tot1=0;
				var ser_tot2=0;
				var ser_tot3=0;
				var ser_tot4=0;
				var ser_tot5=0;
				var ser_tot6=0;
				var ser_tot7=0;
				var ser_tot8=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]][6]);	
					//ser_tot4 += parseFloat(aaData[[i]][7]);	
					//ser_tot5 += parseFloat(aaData[[i]][8]);	
					//ser_tot6 += parseFloat(aaData[[i]][3]);	
					//ser_tot7 += parseFloat(aaData[[i]][11]);
					//ser_tot8 += parseFloat(aaData[[i]][12]);	
				
                }
              var nCells = nRow.getElementsByTagName('th');
			 	nCells[5].innerHTML = '<div class="text-right">'+accounting.formatMoney(ser_tot1, "", 2, ",", ".")+' </div>';
				nCells[6].innerHTML = '<div class="text-right">'+accounting.formatMoney(ser_tot2, "", 2, ",", ".")+' </div>';			
			//	nCells[5].innerHTML = '<div class="text-right">'+accounting.formatMoney(ser_tot2, "", 2, ",", ".")+' </div>';
			//	nCells[6].innerHTML = '<div class="text-right">'+accounting.formatMoney(ser_tot3, "", 2, ",", ".")+' </div>';
			//	nCells[7].innerHTML = '<div class="text-right">'+accounting.formatMoney(ser_tot4, "", 2, ",", ".")+' </div>';
			//	nCells[8].innerHTML = '<div class="text-right">'+accounting.formatMoney(ser_tot5, "", 2, ",", ".")+' </div>';			
				//nCells[9].innerHTML = '<div class="text-right">'+accounting.formatMoney(ser_tot6, "", 2, ",", ".")+' </div>';
				//nCells[11].innerHTML = '<div class="text-right">'+accounting.formatMoney(ser_tot7, "", 2, ",", ".")+' </div>';
				//nCells[12].innerHTML = '<div class="text-right">'+accounting.formatMoney(ser_tot8, "", 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 loadGrid4() {
						var route_id=$('#route_id').val();
						var fromdate=$( '#srh_from_date' ).val();
						var todate=$( '#srh_to_date' ).val();
					    $('#chequ_table_return_not_settle').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,3]},
						   { extend: 'print', text: '<i class="fa fa-print fa-2x"></i>',footer: true,exportOptions:
	 { columns: [0,1,3] },title:"<center>Outstanding Report </center>"},
							{ extend: 'excel', text: '<i class="far fa-file-excel fa-2x"></i>Excel',footer: true,exportOptions:
	 { columns: [0,1,3] },title:"Outstanding Report"},
							 { extend: 'pdf', text: '<i class="far fa-file-pdf fa-2x"></i>PDF',footer: true,exportOptions:
	 { columns: [0,1,3] },title:"Outstanding Report"},							 
						],
					        "ajax": "<?php echo base_url('reports_marketing/get_rep_commission_breakdown_cheque_return_not_settle?route_id=') ?>"+route_id+"&fromdate="+fromdate+"&todate="+todate,
					        "bDestroy": true,							
							"serverSide": false,
					        "iDisplayLength": 200,
							"order": false, "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_tot1=0;
				var ser_tot2=0;
				var ser_tot3=0;
				var ser_tot4=0;
				var ser_tot5=0;
				var ser_tot6=0;
				var ser_tot7=0;
				var ser_tot8=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]][6]);	
					//ser_tot4 += parseFloat(aaData[[i]][7]);	
					//ser_tot5 += parseFloat(aaData[[i]][8]);	
					//ser_tot6 += parseFloat(aaData[[i]][3]);	
					//ser_tot7 += parseFloat(aaData[[i]][11]);
					//ser_tot8 += parseFloat(aaData[[i]][12]);	
				
                }
              var nCells = nRow.getElementsByTagName('th');
			 	nCells[5].innerHTML = '<div class="text-right">'+accounting.formatMoney(ser_tot1, "", 2, ",", ".")+' </div>';
				nCells[6].innerHTML = '<div class="text-right">'+accounting.formatMoney(ser_tot2, "", 2, ",", ".")+' </div>';			
			//	nCells[5].innerHTML = '<div class="text-right">'+accounting.formatMoney(ser_tot2, "", 2, ",", ".")+' </div>';
			//	nCells[6].innerHTML = '<div class="text-right">'+accounting.formatMoney(ser_tot3, "", 2, ",", ".")+' </div>';
			//	nCells[7].innerHTML = '<div class="text-right">'+accounting.formatMoney(ser_tot4, "", 2, ",", ".")+' </div>';
			//	nCells[8].innerHTML = '<div class="text-right">'+accounting.formatMoney(ser_tot5, "", 2, ",", ".")+' </div>';			
				//nCells[9].innerHTML = '<div class="text-right">'+accounting.formatMoney(ser_tot6, "", 2, ",", ".")+' </div>';
				//nCells[11].innerHTML = '<div class="text-right">'+accounting.formatMoney(ser_tot7, "", 2, ",", ".")+' </div>';
				//nCells[12].innerHTML = '<div class="text-right">'+accounting.formatMoney(ser_tot8, "", 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, ",", "."));
				
              
            }
					    });

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

</html>