<div class="main-content">
          <div class="content-wrapper">
            <div class="container-fluid"><!-- Basic form layout section start -->
<section id="basic-form-layouts">
	<!--<div class="row">
		<div class="col-sm-12">
			<h2 class="content-header">Driver Master</h2>
		</div>
	</div>-->
	<div class="row">
		<div class="col-md-12">
			<div class="card">
				<div class="card-header">
					<div class="page-title-wrap">
						<h4 class="card-title">Settlement Due Report</h4>
						
					</div>
					
					
					<!--<p class="mb-0">This is the most basic and cost estimation form is the default position.</p>-->
				</div>
				<div class="card-body">
					<div class="px-3">
						<div class="row">
							<div class="table-responsive custom_table_area export_table_area">
								<table id="settlement_due_table" class="table table-striped table-bordered export_btn_dt c_table_style">
									<thead>
                                		<tr>
											<th>Sl No.</th>
											<th>Car No</th>
											<th>Driver Name </th>
											<th>DC</th>
											<th>Mobile No</th>
											<th>Week 1</th>
											<th>Week 2</th>
											<th>Week 3</th>
											<th>3 Week Plus Due </th>
                                		</tr>
                            		</thead>
									
									<tbody id="tbody_settlement_due_table">
                            		</tbody>
                        		</table>
							</div>
						</div>
					</div>
				</div>
			</div>
		</div>
	</div>
</section>
<!-- // Basic form layout section end -->
            </div>
          </div>
        </div>
<script>
	$(document).ready(function() {
		settlement_due_list();
	});

	function settlement_due_list() {
		
		var resulthtml = '';
		$.ajax({
				url: "<?php echo base_url('admin/report/get_settlement_due_report'); ?>",
				type: "POST",
				data: {},
				dataType: "json",
				encode: true,
				//async: false
			})
			.done(function(data) {

				if (data.status) {

					if (data.settlement_due_list) {
						var i = 0;
						$.each(data.settlement_due_list, function(key, value) {
							i++;
							
							resulthtml += '<tr>';
							resulthtml += '<td>' + i + '</td>';
							resulthtml += '<td>' + value.registration_no + '</td>';
							resulthtml += '<td>' + value.full_name + '</td>';
							resulthtml += '<td>' + value.dc_no + '</td>';
							resulthtml += '<td>' + value.mobile + '</td>';
							var weekly_settlement_status =[];
							if(value.weekly_settlement_status){

								 weekly_settlement_status= value.weekly_settlement_status.split('|#|');

							}
							console.log(weekly_settlement_status);
							$.each(weekly_settlement_status,function(key1,value1){
								if(value1 != ''){
									resulthtml += '<td><span class="week_color week_color_red">Due</span></td>';
								}
								else{
									resulthtml += '<td><span class="week_color week_color_green">Settled</span></td>';
								}
							})
									 
							resulthtml += '</tr>';
						})
					}
				
						//console.log(resulthtml);
						var now = new Date();
						var date = now.getFullYear() + ":" + now.getMonth() + ":" + now.getDate();
						$("#settlement_due_table").dataTable().fnDestroy();
						$("#tbody_settlement_due_table").html(resulthtml);
						$('#settlement_due_table').DataTable({
							pageLength: 100,
							dom: 'Bfrtip',
							buttons: [{
									extend: 'excel',
									text: 'Download Excel',
									className: 'btn btn-outline-primary mr-1',
									filename: 'settlement_due_report' + date
								}
								//'copy', 'csv', 'excel', 'pdf', 'print'
							]
						});


					} else {
						$.alert({
							type: 'red',
							title: 'Alert!',
							content: 'Oops!Something went wrong...',
						});
					}
				})
				.fail(function(result) {
					$.alert({
						type: 'red',
						title: 'Alert!',
						content: 'Oops!Something went wrong...',
					});
				})
		}
</script>