<?php 
	$header_file=APPPATH.'views/include/header.php';
	require($header_file);
	
	?>

    <!-- BEGIN: Content-->
    <div class="app-content content">
      <div class="content-overlay"></div>
      <div class="content-wrapper">
        <div class="content-header row">
          <div class="content-header-left col-md-12 col-12 mb-2 breadcrumb-new">
            <h3 class="content-header-title mb-0 d-inline-block">Vendor Ledger</h3>
            <div class="row breadcrumbs-top d-inline-block">
              <div class="breadcrumb-wrapper col-12">
                <ol class="breadcrumb">
                  <li class="breadcrumb-item"><a href="#">Home</a>
                  </li>
                  <li class="breadcrumb-item"><a href="#">Stock Management</a>
                  </li>
                  <li class="breadcrumb-item active">Vendor Ledger
                  </li>
                </ol>
              </div>
            </div>
          </div>
        
        </div>
        <div class="content-body"><!-- Zero configuration table -->
<section id="configuration">
    <div class="row">
        <div class="col-md-12">
            <div class="card">
                <!--<div class="card-header">
                    <h4 class="card-title">Vendor Ledger</h4>
                    <a class="heading-elements-toggle"><i class="la la-ellipsis-v font-medium-3"></i></a>
                    <div class="heading-elements">
                        <ul class="list-inline mb-0">
                            <li><a data-action="collapse"><i class="ft-minus"></i></a></li>
                            <li><a data-action="reload"><i class="ft-rotate-cw"></i></a></li>
                            <li><a data-action="expand"><i class="ft-maximize"></i></a></li>
                            <li><a data-action="close"><i class="ft-x"></i></a></li>
                        </ul>
                    </div>
                </div>-->
                <div class="card-content collapse show">
                    <div class="card-body card-dashboard">
                       
                        
							<form method="post" autocomplete="off" action="<?php echo site_url('StockManagement/searchVendorLedger/');?>" method="POST">
                        	<div class="row justify-content-md-center">
							
								<div class="col-md-3">
									<div class="form-group">
										<input class="form-control pickadate datepicker picker__input picker__input--active" type="text" name="from_date"  id="from_date" required data-uk-datepicker="{format:'DD-MM-YYYY'}" placeholder="From Date">
									</div>
								</div>
								<div class="col-md-3">
									<div class="form-group">
										<input class="form-control pickadate datepicker picker__input picker__input--active" type="text" name="to_date"  id="to_date" required data-uk-datepicker="{format:'DD-MM-YYYY'}" placeholder="To Date">
									</div>
								</div>
								<div class="col-md-3">
									<div class="form-group">
										<select id="supplier" name="supplier" class="select2" >
											<option value="">Select Supplier</option>
											<option value="All">All</option>
											<?php  foreach($supplier as $row)
												{
											?>
												<option value="<?php echo $row->company_name; ?>"><?php echo $row->company_name; ?></option>
											<?php
												} 
											?>
										</select>
									</div>
								</div>
								<div class="col-md-3">
									<div class="form-group">
										<input type="submit" name="submit" class="btn btn-primary" value="Vendor Report">
									</div>
								</div>
							
						</div>
						</form>
						<div class="table-responsive">
						<?php
				if(isset($_POST['submit'])) {
					 
					if (isset($result_display)) {
						//echo "<p><u>Result</u></p>";
						if ($result_display == 'No record found !') {
							echo $result_display;
							} else {
						?>
						<?php if($_POST['from_date']!="" && $_POST['to_date']!="" && $_POST['supplier']=="All"){ ?>

								 <table id="" class="table table-striped table-bordered dataex-html5-exports">
									<thead>
									    	<th>Sl No</th>
										<th>Vendor Name</th>
										<th>GRN Value</th>
										<th>Rejected Value</th>
										<th>Final Value</th>
									</thead>
						<tbody>
							<?php 
							$tot_grn1 = 0;
							$tot_rjn1 = 0;
							$tot_final1 = 0;
							if(isset($result_display) && is_array($result_display) && count($result_display)): $i=1;
							foreach ($result_display as $data) { 
								$tot_grn1 = $tot_grn1 + $data['grand'];
								$tot_rjn1 = $tot_rjn1 + ($data['grand'] - $data['reject_amt']);
								$tot_final1 = $tot_final1 + $data['reject_amt'];
							?>
								<tr>
								    <td><?php echo $i; ?></td>
									<td><?php echo $data['vendor_name']; ?></td>
									<td><?php echo $data['grand']; ?></td>
									<td><?php echo round(($data['grand'] - $data['reject_amt']),2); ?></td>
									<td><?php echo round($data['reject_amt'],2); ?></td>
								</tr>
													
								<?php
									$i++;
									} ?>
									<td><strong>Total</strong></td>
									<td><strong></strong></td>
									<td><strong><?php echo $tot_grn1; ?></strong></td>
									<td><strong><?php echo $tot_rjn1; ?></strong></td>
									<td><strong><?php echo $tot_final1; ?></strong></td>
									<?php else:
								?>
								<tr>
									<td colspan="4" align="center" >No Records Found..</td>
								</tr>
								<?php
									endif;
								?>
						</tbody>
					</table>

						
						<?php } if($_POST['from_date']!="" && $_POST['to_date']!="" && $_POST['supplier']!="All"){ ?>
						<table class="table table-striped table-bordered dataex-html5-exports">
									<thead>
									    <th>Sl No</th>
										<th>Date</th>
									<th>Transaction</th>
									<th>GRN Value</th>
									<th>Rejected Value</th>
									<th>Final Value</th>
									</thead>
						<tbody>
							<?php 
							$tot_grn = 0;
							$tot_rjn = 0;
							$tot_final = 0;
							if(isset($result_display) && is_array($result_display) && count($result_display)): $i=1;
							foreach ($result_display as $data) { 
								$tot_grn = $tot_grn + $data['value'];
								$tot_rjn = $tot_rjn + ($data['value'] - $data['reject_amt']);
								$tot_final = $tot_final + $data['reject_amt'];
							?>
								<tr>
								    <td><?php echo $i; ?></td>
									<td><?php echo $data['grn_date']; ?></td>
									<?php if($data['purchase_id'] == '0') { ?>
									<td class="uk-text-nowrap">
										<a href="<?php echo site_url('Purchase/dgrn_view/'. $data['gnr_id']); ?>" id="view" name="view" class="btn btn-sm btn-info md-btn-success"><?php echo $data['grn_no']; ?></a>
									</td>
									<?php } else { ?>
									<td class="uk-text-nowrap">
										<a target="_blank" href="<?php echo site_url('Purchase/grn_detail/'. $data['gnr_id']); ?>" class="btn btn-sm btn-info"><?php echo $data['grn_no']; ?></a>
									</td>
									<?php } ?>
									<td><?php echo $data['value']; ?></td>
									<td><?php echo round(($data['value'] - $data['reject_amt']),2); ?></td>
									<td><?php echo $data['reject_amt']; ?></td>
								</tr>
													
								<?php
									$i++;
									} ?>
									
								<tr>
									<td><strong>Total</strong></td>
									<td></td>
									<td></td>
									<td><strong><?php echo $tot_grn; ?></strong></td>
									<td><strong><?php echo $tot_rjn; ?></strong></td>
									<td><strong><?php echo $tot_final; ?></strong></td>
								</tr>
									<?php else:
								?>
								<tr>
									<td colspan="8" align="center" >No Records Found..</td>
								</tr>
								<?php
									endif;
								?>
						</tbody>
					</table>
							<?php }	
					} }
				} else { ?>
				    <table class="table table-striped table-bordered dataex-html5-export">
						<thead>
						    <th>Sl No</th>
    						<th>Date</th>
    						<th>Transaction</th>
    						<th>Vendor</th>
    						<th>GRN Value</th>
    						<th>Rejected Value</th>
    						<th>Final Value</th>
						</thead>
						<tbody>
							<?php 
							$tot_grn = 0;
							$tot_rjn = 0;
							$tot_final = 0;
							if(isset($vnd_ledger) && is_array($vnd_ledger) && count($vnd_ledger)): $i=1;
							foreach ($vnd_ledger as $data) { 
								$tot_grn = $tot_grn + $data->value;
								$tot_rjn = $tot_rjn + ($data->value - $data->reject_amt);
								$tot_final = $tot_final + $data->reject_amt;
							?>
								<tr>
								    <td><?php echo $data->gnr_id; ?></td>
									<td><?php echo $data->grn_date; ?></td>
									<?php if($data->purchase_id == '0') { ?>
									<td class="uk-text-nowrap">
										<a href="<?php echo site_url('Purchase/dgrn_view/'. $data->gnr_id); ?>" id="view" name="view" class="btn btn-sm btn-info md-btn-success"><?php echo $data->grn_no; ?></a>
									</td>
									<?php } else { ?>
									<td class="uk-text-nowrap">
										<a target="_blank" href="<?php echo site_url('Purchase/grn_detail/'. $data->gnr_id); ?>" class="btn btn-sm btn-info"><?php echo $data->grn_no; ?></a>
									</td>
									<?php } ?>
									<td><?php echo $data->vendor_name; ?></td>
									<td><?php echo $data->value; ?></td>
									<td><?php echo round(($data->value - $data->reject_amt),2); ?></td>
									<td><?php echo $data->reject_amt; ?></td>
								</tr>
													
								<?php
									$i++;
									} ?>
									
								<tr>
									<td><strong>Total</strong></td>
									<td></td>
									<td></td>
									<td></td>
									<td><strong><?php echo round($tot_grn,2); ?></strong></td>
									<td><strong><?php echo round($tot_rjn,2); ?></strong></td>
									<td><strong><?php echo round($tot_final,2); ?></strong></td>
								</tr>
									<?php else:
								?>
								<tr>
									<td colspan="7" align="center" >No Records Found..</td>
								</tr>
								<?php
									endif;
								?>
						</tbody>
					</table>
				<?php } ?>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
</section>
<!--/ Zero configuration table -->



<!--/ Language - Comma decimal place table -->

        </div>
      </div>
    </div>
    <!-- END: Content-->

   <?php //require('include/theme_customizer.php');?>
 <?php 
  $footer_file=APPPATH.'views/include/footer.php';
	require($footer_file);
	?>
<script>
	$('.param_check').each(function() { $(this).on( {'click contextmenu': function() {
		//contextmenu
		var i = $(this).data('value');
		var anchor = $("a");
		var anchorTarget = $(this).parent().find('.parmetre').val();
		var submodid = $(this).parent().find('.submod_id').val();
		var link = $(this).attr('href');
		$(this).attr("href", link + submodid +'/'+anchorTarget);

		location.reload();
	}
	})
	})
	
	
	
</script>
<script type='text/javascript'>
    $(document).ready(function() {
        $("#myTable").DataTable({
           dom: "Bfrtip",
             displayLength: 500,
            buttons: ["copyHtml5", "excelHtml5", "csvHtml5", "pdfHtml5"]
    }) 
   });
   
   $(".dataex-html5-exports").DataTable({
        dom: "Bfrtip",
         displayLength: 500,
        buttons: ["copyHtml5", "excelHtml5", "csvHtml5", "pdfHtml5"]
    })
</script>
  </body>
  <!-- END: Body-->

<!-- Mirrored from pixinvent.com/modern-admin-clean-bootstrap-4-dashboard-html-template/html/ltr/vertical-modern-menu-template/form-layout-basic.html by HTTrack Website Copier/3.x [XR&CO'2014], Mon, 27 Apr 2020 09:38:02 GMT -->
</html>