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/exports/ |
Upload File : |
<table style="table-layout: auto;widtd: 100%;">
<thead>
@if($companyInfo)
<tr><td colspan="{{$colors->count()+12}}" style="text-align: center;"> {{$companyInfo->company_name ? $companyInfo->company_name: "MAKTEL LIMITED"}}</td></tr>
<tr><td colspan="{{$colors->count()+12}}" style="text-align: center;"> {{$companyInfo->company_address ? $companyInfo->company_address : "House-277(Level-4),Lane-4,Baridhara DOHS,Dhaka-1206."}}</td></tr>
<tr><td colspan="{{$colors->count()+12}}" style="text-align: center;"> Hotline: +{{$companyInfo->company_phone ? $companyInfo->company_phone: "88 01844241530"}}</td></tr>
<tr><td colspan="{{$colors->count()+12}}" style="text-align: center;"> Email: {{$companyInfo->company_email ? $companyInfo->company_email : "info@maktel.com.bd"}}</td></tr>
<tr><td colspan="{{$colors->count()+12}}" style="text-align: center;"> Web: {{$companyInfo->company_website ? $companyInfo->company_website : "www.maktel.com.bd"}}</td></tr>
<tr><td colspan="{{$colors->count()+12}}" style="text-align: center;">Facebook: {{$companyInfo->company_facebook ? $companyInfo->company_facebook : "www.facebook.com/maktel"}}</td></tr>
@else
<tr><td colspan="{{$colors->count()+12}}">MAKTEL LIMITED</td></tr>
<tr><td colspan="{{$colors->count()+12}}">House-277(Level-4),Lane-4,Baridhara DOHS,Dhaka-1206.</td></tr>
<tr><td colspan="{{$colors->count()+12}}">Hotline:+88 01844241530</td></tr>
<tr><td colspan="{{$colors->count()+12}}">Email:info@maktel.com.bd</td></tr>
<tr><td colspan="{{$colors->count()+12}}">Web:www.maktel.com.bd</td></tr>
<tr><td colspan="{{$colors->count()+12}}">Facebook:www.facebook.com/maktel</td></tr>
@endif
<tr >
<td></td>
<td></td>
<td> </td>
<td> </td>
<td></td>
<td> </td>
<td> </td>
<td></td>
<td colspan="{{$colors->count()}}" style="text-align: center;">Color</td>
<td></td>
<td> </td>
<td> </td>
<td></td>
</tr>
<tr>
<td>SL</td>
<td>Date</td>
<td>Bill No.</td>
<td>Supplier</td>
<td>CNF Name</td>
<td>Brand</td>
<td>Product Name</td>
<td>Model</td>
@foreach($colors as $color)
<td>{{$color->color_name}}</td>
@endforeach
<td><b>DOA</b></td>
<td><b>Missing Qty</b></td>
<td><b>Quantity</b></td>
<td><b>Total</b></td>
</thead>
<tbody>
@php $i=1;$g_total=0;$s_g_total=0;$d_total=0;$m_total=0;$total_arr=array(); @endphp
@foreach($stocks as $stock)
@foreach($stock->groupBy('product_id') as $d)
<tr>
<td>{{$i}}</td>
<td>{{$d[0]->stock->stock_date}}</td>
<td>{{$d[0]->stock->bill_no}}</td>
<td>{{$d[0]->stock->supplier->supplier_name}}</td>
<td>{{$d[0]->stock->cnf->cnf_name}}</td>
<td>{{$d[0]->product->brand->brand_name}}</td>
<td>{{$d[0]->product->product_name}}</td>
<td>{{$d[0]->product->model->model_name}}</td>
@php $total=0; @endphp
@foreach($colors as $color)
<td>
@php
//print_r($d);
$q= $d->where('color_id',$color->color_id)->sum('product_quantity');
if(!isset($total_arr[$color->color_id])){
$total_arr[$color->color_id]=0;
}
$total_arr[$color->color_id] += $q;
$total += $q;
@endphp
{{$q}}
</td>
@endforeach
@php
$doa=$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;
$missing=$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;
$t_total=$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);
$g_total += $t_total;
$s_g_total += $total;
$d_total += $doa;
$m_total += $missing;
@endphp
<td>{{$doa}}</td>
<td>{{$missing}}</td>
<td>{{$total}}</td>
<td>{{$t_total}}</td>
</tr>
@php $i++; @endphp
@endforeach
@endforeach
<tr>
<td colspan="8" style="text-align:right;"><strong>Total</strong></td>
@foreach($colors as $color)
<td><strong>{{$total_arr[$color->color_id]}}</strong></td>
@endforeach
<td><strong>{{$d_total}}</strong></td>
<td><strong>{{$m_total}}</strong></td>
<td><strong>{{$s_g_total}}</strong></td>
<td><strong>{{$g_total}}</strong></td>
</tr>
</tbody>
</table>