Server : ApacheSystem : Linux host44.registrar-servers.com 4.18.0-513.18.1.lve.2.el8.x86_64 #1 SMP Sat Mar 30 15:36:11 UTC 2024 x86_64 User : vapecompany ( 2719) PHP Version : 7.4.33 Disable Function : NONE Directory : /home/vapecompany/demo.vapecompany.com.bd/resources/views/backend/reports/tables/ |
Upload File : |
<!-- Column -->
<div class="card">
<div class="card-body">
<h4 class="card-title">Stock (Doa/Missing) Report</h4>
@if($stocks->count() > 0)
<div style="padding: 10px;margin-bottom: 10px;" role="group" class="btn-group btn-group-sm filter-pdf-btn">
<form action="{{url('reports/stockIn_export')}}" method="get">
<input type="hidden" name="action_type" value="download">
<input type="hidden" name="product" value="{{$product}}">
<input type="hidden" name="brand" value="{{$brand_id}}">
<input type="hidden" name="s_date" value="{{$s_date}}">
<input type="hidden" name="e_date" value="{{$e_date}}">
<input type="hidden" name="supplier" value="{{$supplier_id}}">
<input type="hidden" name="cnf" value="{{$cnf}}">
<button style="padding: 10px" type="submit" class="btn btn-secondary rounded-0 btn-sm pl-2 pr-2"><i class="fas fa-file-pdf mr-2"></i> PDF </button>
</form>
<form action="{{url('reports/stockIn_export')}}" method="get" target="_blank">
<input type="hidden" name="action_type" value="print">
<input type="hidden" name="product" value="{{$product}}">
<input type="hidden" name="brand" value="{{$brand_id}}">
<input type="hidden" name="s_date" value="{{$s_date}}">
<input type="hidden" name="e_date" value="{{$e_date}}">
<input type="hidden" name="supplier" value="{{$supplier_id}}">
<input type="hidden" name="cnf" value="{{$cnf}}">
<button style="padding: 10px" type="submit" class="btn btn-warning btn-sm rounded-0 pl-2 pr-2"><i class="fa fa-print mr-2"></i> Print </button>
</form>
<form action="{{url('reports/stockIn_export')}}" method="get">
<input type="hidden" name="action_type" value="excel">
<input type="hidden" name="product" value="{{$product}}">
<input type="hidden" name="brand" value="{{$brand_id}}">
<input type="hidden" name="s_date" value="{{$s_date}}">
<input type="hidden" name="e_date" value="{{$e_date}}">
<input type="hidden" name="supplier" value="{{$supplier_id}}">
<input type="hidden" name="cnf" value="{{$cnf}}">
<button style="padding: 10px" type="submit" class="btn btn-secondary btn-sm rounded-0 pl-2 pr-2"><i class="fas fa-file-excel mr-2"></i> Excel </button>
</form>
</div>
<div class="table-responsive">
<table id="dtables" class="table table-striped table-bordered dt-responsive nowrap" style="width:100%">
<thead>
<tr>
<th class="min-mobile"></th>
<th class="min-mobile"></th>
<th class="not-mobile"></th>
<th class="not-mobile"></th>
<th class="not-mobile"></th>
<th class="min-mobile"></th>
<th class="not-mobile"></th>
<th class="not-mobile"></th>
<th class="not-mobile text-center" colspan="{{$colors->count()}}">Color</th>
<!-- <th class="not-mobile">Purchase Price</th> -->
<th class="not-mobile"></th>
<th class="not-mobile"></th>
<th class="not-mobile"></th>
<th class="not-mobile"></th>
<!-- <th class="not-mobile">Current Stock Value</th> -->
</tr>
<tr>
<th class="min-mobile">SL</th>
<th class="min-mobile">Date</th>
<th class="not-mobile">Bill No.</th>
<th class="not-mobile">Supplier</th>
<th class="not-mobile">C&F Name</th>
<th class="min-mobile">Brand</th>
<th class="not-mobile">Product Name</th>
<th class="not-mobile">Model</th>
@foreach($colors as $color)
<th class="not-mobile">{{$color->color_name}}</th>
@endforeach
<!-- <th class="not-mobile">Purchase Price</th> -->
<th class="not-mobile">DOA</th>
<th class="not-mobile">Missing Qty</th>
<th class="not-mobile">Quantity</th>
<th class="not-mobile">Total</th>
<!-- <th class="not-mobile">Current Stock Value</th> -->
</tr>
</thead>
<tbody>
@php $i=1; @endphp
@foreach($stocks as $stock)
@foreach($stock->groupBy('product_id') as $d)
<tr>
<td class="min-mobile">{{$i}}</td>
<td class="min-mobile">{{$d[0]->stock->stock_date->format('d-m-Y')}}</td>
<td class="not-mobile">{{$d[0]->stock->bill_no}}</td>
<td class="min-mobile">{{$d[0]->stock->supplier->supplier_name}}</td>
<td class="min-mobile">{{$d[0]->stock->cnf->cnf_name}}</td>
<td class="min-mobile">{{$d[0]->product->brand->brand_name}}</td>
<td class="not-mobile">{{$d[0]->product->product_name}}</td>
<td class="not-mobile">{{$d[0]->product->model->model_name}}</td>
@php $total=0; @endphp
@foreach($colors as $color)
<td class="not-mobile">
@php
//print_r($d);
$q= $d->where('color_id',$color->color_id)->sum('product_quantity');
$total += $q;
@endphp
{{$q}}
</th>
@endforeach
<td class="not-mobile">{{$d[0]->stock->doa ? $d[0]->stock->doa->details->where('product_id',$d[0]->product_id)->sum('doa')- $d[0]->stock->doa->details->where('product_id',$d[0]->product_id)->sum('doa_a') : 0}}</td>
<td class="not-mobile">{{$d[0]->stock->doa ? $d[0]->stock->doa->details->where('product_id',$d[0]->product_id)->sum('missing')-$d[0]->stock->doa->details->where('product_id',$d[0]->product_id)->sum('missing_a') : 0 }}</td>
<td class="not-mobile">{{$total}}</td>
<td class="not-mobile">{{$total-($d[0]->stock->doa ? $d[0]->stock->doa->details->where('product_id',$d[0]->product_id)->sum('missing')-$d[0]->stock->doa->details->where('product_id',$d[0]->product_id)->sum('missing_a') : 0)}}</td>
</tr>
@php $i++; @endphp
@endforeach
@endforeach
</tbody>
</table>
</td>
@else
<div style="padding: 20px;color:red;text-align:center;font-size: 25px;" >Data Not Found</div>
@endif
</div>
</div>
</div>