@extends('layouts.default')
@section('content')
<div class="az-content az-content-dashboard">
  <br>
	<div class="container">
		<div class="az-content-body">
			<div class="az-content-breadcrumb"> 
				<span><a href="" style="color: #596881;">Net booking-Billing Report </a></span> 
                <span><a href="" style="color: #596881;">
               
                </a></span>
			</div> 
            
            @include('includes.fgs.net-bk-billing-tab')
            <br><br>
			<h4 class="az-content-title" style="font-size: 20px;">Net billing Report
				<button style="float: right; font-size: 14px;" onclick="document.location.href='{{url('fgs/net-bk-billing-report/export').'?'.http_build_query(array_merge(request()->all()))}}'" class="badge badge-pill badge-info">
					<i class="fas fa-file-excel"></i> Report
				</button>
			</h4>
			
		   @if (Session::get('success'))
		   <div class="alert alert-success " style="width: 100%;">
			   <button type="button" class="close" data-dismiss="alert" aria-hidden="true">×</button>
			   <i class="icon fa fa-check"></i> {{ Session::get('success') }}
		   </div>
		   @endif
			<div class="tab-content">
				<div class="row row-sm mg-b-20 mg-lg-b-0">
						<div class="table-responsive" style="margin-bottom: 13px;">
							<table class="table table-bordered mg-b-0">
								<tbody>
									<tr>
										<style>
											.select2-container .select2-selection--single {
												height: 26px;
												/* width: 122px; */
											}
											.select2-selection__rendered {
												font-size:12px;
											}
										</style>
										<form autocomplete="off" id="formfilter">
											<th scope="row">
												<div class="row filter_search" style="margin-left: 0px;">
													<div class="col-sm-10 col-md-10 col-lg-10 col-xl-10 row">
                                                         
														<div class="form-group col-sm-12 col-md-4 col-lg-4 col-xl-4">
															<label>SKU Code</label>
															<input type="text" value="{{request()->get('sku_code')}}" name="sku_code"  id="sku_code" class="form-control" placeholder="SKU CODE">
														</div><!-- form-group -->
														<div class="form-group col-sm-12 col-md-3 col-lg-3 col-xl-3">
														<label style="font-size: 12px;">Product Category</label>
														<select name="category_name" id="category_name" class="form-control">
															<option value="">-- Select one ---</option>
															@foreach ($fgs_product_category as $item)
															<option value="{{$item->id}}">{{$item->category_name}}</option>
															@endforeach
														</select>
													</div>
													<div class="form-group col-sm-12 col-md-4 col-lg-4 col-xl-4">
														<label style="font-size: 12px;">Month</label>
														<input type="text" value="{{request()->get('from')}}" id="from" class="form-control datepicker" name="from" placeholder="Month(MM-YYYY)">
													</div>
                                                        <div class="form-group col-sm-12 col-md-3 col-lg-3 col-xl-3" style="padding: 0 0 0px 6px;">
                                                            <label style="width: 100%;">&nbsp;</label>
                                                            <button type="submit" class="badge badge-pill badge-primary search-btn" style="margin-top:-2px;"><i class="fas fa-search"></i> Search</button>
                                                            @if(count(request()->all('')) > 2)
                                                                <a href="{{url()->current()}}" class="badge badge-pill badge-warning"
                                                                style="margin-top:-2px;"><i class="fas fa-sync"></i> Reset</a>
                                                            @endif
													    </div> 
														
																			
													</div>
													<div class="col-sm-2 col-md-2 col-lg-2 col-xl-2 row">
													
												</div>
												</div>
											</th>
										</form>
									</tr>
								</tbody>
							</table>
						</div>
					</div>
				<div class="tab-pane tab-pane active  show" id="purchase">
					
					<div class="table-responsive">
						<table class="table table-bordered mg-b-0" id="example1">
							<thead>
								<tr>
									<th>Doc number</th>
									<th>SKU Code </th>
									<th  width='35%'>Description </th>
									<th>HSN Code</th>
                                    <th>BatchCard</th>
                                    <th>QTY</th>
                                   {{-- <th>Rate</th>
                                    <th>Discount</th>
                                    <th>GST</th>--}}
									<th>Date </th>
                                    <th>Customer</th>
                                    <th>Zone</th>
								</tr>
							</thead>
							<tbody id="prbody1">
							@foreach($dni_items as $dni)
								<tr>
									<td>{{$dni->dni_number}}</td>
									<td>{{$dni->sku_code}}</td>
									<td>{{$dni->discription}}</td>
									<td>{{$dni->hsn_code}}</td>
									<td></td>
									<td>{{$dni->quantity}}</td>
									{{--<td>{{$dni->rate}}</td>
									<td>{{$dni['discount']}}%</td>
									<td>IGST:{{$dni['igst']}}%<br />SGST:{{$dni['sgst']}}%<br />CGST:{{$dni['cgst']}}%</td>--}}
									<td>{{date('d-m-Y',strtotime($dni->dni_date))}}</td>
									<td>{{$dni->firm_name}}</td>
									<td>{{$dni->zone_name}}</td>

								</tr>
								@endforeach
								@foreach($exi_items as $exi)
								<tr>
									<td>{{$exi->dni_number}}</td>
									<td>{{$exi->sku_code}}</td>
									<td>{{$exi->discription}}</td>
									<td>{{$exi->hsn_code}}</td>
									<td></td>
									<td>{{$exi->quantity}}</td>
									{{--<td>{{$exi->rate}}</td>
									<td>{{$exi['discount']}}%</td>
									<td>IGST:{{$exi['igst']}}%<br />SGST:{{$exi['sgst']}}%<br />CGST:{{$exi['cgst']}}%</td>--}}
									<td>{{date('d-m-Y',strtotime($exi->dni_date))}}</td>
									<td>{{$exi->firm_name}}</td>
									<td>{{$exi->zone_name}}</td>

								</tr>
								@endforeach
							@foreach($srn_items as $srn)
								<tr>
									<td>{{$srn->srn_number}}</td>
									<td>{{$srn->sku_code}}</td>
									<td>{{$srn->discription}}</td>
									<td>{{$srn->hsn_code}}</td>
									<td></td>
									<td>{{$srn->quantity}}</td>
									{{--<td>{{$srn->rate}}</td>
									<td>{{$srn['discount']}}%</td>
									<td>IGST:{{$srn['igst']}}%<br />SGST:{{$srn['sgst']}}%<br />CGST:{{$srn['cgst']}}%</td>--}}
									<td>{{date('d-m-Y',strtotime($srn->srn_date))}}</td>
									<td>{{$srn->firm_name}}</td>
									<td>{{$srn->zone_name}}</td>

								</tr>
								@endforeach
							</tbody>
						</table>
						<div class="box-footer clearfix">
                        {{--$dni_items->appends(request()->input())->links()--}}               
						</div> 
					</div>
				</div>
			</div>
		</div>
	</div>
	<!-- az-content-body -->
</div>


<script src="