@extends('admin.layouts.app')
@section('title',get_setting('site_name').' | Asset Stock Report')
@section('content')
    <div class="row mt-3 mb-5">
        <div class="col-md-10 mx-auto">
            <div class="card">
                <div class="card-header">
                    <h5>Asset Stock Report</h5>
                </div>
                <div class="card-body">
                    <form action="" method="get">
                        <div class="row no-print mb-2">
                            <div class="col-md-8"></div>
                            <div class="col-md-3">

                                <select class="form-control" name="branch_id" id="">
                                    <option value="">Select Branch</option>
                                    @foreach(\App\Models\warehouse::where('status',1)->get() as $branch)

                                        <option value="{{$branch->id}}"
                                                @if(request()->branch_id==$branch->id) selected @endif>{{$branch->name}}</option>
                                    @endforeach
                                </select>

                            </div>
                            <div class="col-md-1">
                                <button class="btn btn-primary" type="submit"><i class="fas fa-filter"></i>&nbsp;Filter
                                </button>
                            </div>


                        </div>
                    </form>
                    <table class="table table-bordered">

                        <thead>
                        <tr>
                            <th>Asset Category</th>
                            <th>Asset</th>
                            <th class="text-center">Purchase</th>
                            <th class="text-center">Assign</th>
                            <th class="text-center">Damage</th>
                            <th class="text-center">Stock</th>
                        </tr>
                        </thead>
                        <tbody>
                        @foreach(\App\Models\asset_category::all() as $item)
                            <tr>
                                <td>{{!empty($item->parentCategory)?$item->parentCategory->name:$item->name}}</td>
                                <td>{{empty($item->parentCategory)?'-':$item->name}}</td>
                                <td class="text-center">
                                    @if(request()->branch_id)
                                        {{$purchase=\App\Models\asset::where('asset_category_id',$item->id)->where('branch_id',request()->branch_id)->sum('qty')}}
                                    @else
                                        {{$purchase=\App\Models\asset::where('asset_category_id',$item->id)->sum('qty')}}
                                    @endif


                                </td>
                                <td class="text-center">
                                    @if(request()->branch_id)
                                        {{$assigns=\App\Models\asset::where('asset_category_id',$item->id)->where('branch_id',request()->branch_id)->where('status',1)->sum('qty')}}
                                    @else
                                        {{$assigns=\App\Models\asset::where('asset_category_id',$item->id)->where('status',1)->sum('qty')}}
                                    @endif
                                </td>
                                <td class="text-center">
                                    @if(request()->branch_id)
                                        {{$damage=\App\Models\asset::where('asset_category_id',$item->id)->where('status',2)->where('branch_id',request()->branch_id)->sum('qty')}}
                                    @else
                                        {{$damage=\App\Models\asset::where('asset_category_id',$item->id)->where('status',2)->sum('qty')}}
                                    @endif

                                </td>
                                <td class="text-center">
                                        <br />
<b>Warning</b>:  Undefined variable $assigns in <b>/home/easyhr/public_html/psks.easyhr.us/resources/views/admin/asset/asset_stock.blade.php</b> on line <b>76</b><br />
<br />
<b>Warning</b>:  Undefined variable $damage in <b>/home/easyhr/public_html/psks.easyhr.us/resources/views/admin/asset/asset_stock.blade.php</b> on line <b>76</b><br />
<br />
<b>Warning</b>:  Undefined variable $purchase in <b>/home/easyhr/public_html/psks.easyhr.us/resources/views/admin/asset/asset_stock.blade.php</b> on line <b>76</b><br />
0                                </td>


                            </tr>
                        @endforeach
                        </tbody>

                    </table>
                    <button class="btn btn-primary float-right mt-3 mb-3 print-button" onclick="window.print()"><i
                            class="fas fa-print"></i></button>
                </div>
            </div>
        </div>
    </div>
@endsection