@extends('report.index')

@section('title')
    CS Report
@endsection

{{--@section('report_title')--}}
    {{--PO Report--}}
{{--@endsection--}}

{{--@section('by')--}}
    {{--Who prepared this--}}
{{--@endsection--}}

@section('content')
@php
    $height = request('gap') && request('gap') != 'default' ? request('gap') + 30 : 40;    
@endphp
<style>
    .cs-td {
        height: {{ $height }}px !important;
    }
    .signature-gap{
        margin-top: 96px !important;;
    }
    @media print{
        .purchased{
            background-color: white !important;
            color: black !important;
            font-weight: bold !important;
        }
        .unpurchased{
            font-weight: lighter !important;
        }
    }

</style>

    <!-- Each sheet element should have the class "sheet" -->
    <!-- "padding-**mm" is optional: you can set 10, 15, 20 or 25 -->
    @php
        $chunckNumber = 8;
        $page_no = 1;
        $total = count($allProducts);
        $total_pages = ceil($total / $chunckNumber); 
        if(request('per_page_item') > 0){
            $chunckNumber = request('per_page_item');
        }
    @endphp
    @foreach($allProducts->chunk($chunckNumber) as $products)
        <section class="sheet padding-10mm" style="">
            <div class="text-right"> <small>Page No: {{  $page_no++ }}/{{ $total_pages }}</small> </div>
            <center>
                <h1 class="font-weight-normal">Comparative Statement</h1>
                <div style="margin-top: -20px;font-size: 18px">
                    <strong>{{ unit_name() ?? app_info()->company_name }}</strong>
                </div>
                <div class="print-none" style="font-weight: normal !important; font-size: 18px !important">
                @if($loop->first)
                    <form action="" method="get">
                        <select name="gap" onchange="this.form.submit()" >
                            @foreach(gaps() as $key => $gap)
                                <option value="{{ $key }}" @if(request('gap') == $key) selected @endif>{{ $gap }}</option>
                            @endforeach
                        </select>
                        <select name="per_page_item" onchange="this.form.submit()">
                            @foreach(perPageItem() as $key => $item_number)
                                <option value="{{ $key }}" @if(request('per_page_item') == $key) selected @endif>{{ $item_number }}</option>
                            @endforeach
                        </select>
                    </form>
                @endif

            </div>
            </center>
            <br><br>
            <div style="margin-bottom: 5px;font-size: 16px;float: left">
                <strong>C/S No : {{ $requisition->cs_no }}, Date: {{ dateFormat($cs_date->created_at) }}<br>
                    Purchase Requisition : {{ $requisition->requisition->requisition_id }}, Date: {{ dateFormat($requisition->created_at) }}

                </strong>

            </div>

             <div style="margin-bottom: 5px;font-size: 10px;float: right; font-weight: bold;">
              PRINTED ON: {{ date("d/m/Y   H:iA") }}
            </div> 
            <br>
            <table class="table" align="center" cellpadding="0" cellspacing="0" border="0" style="margin-top:20px;">
                <thead>
                <tr style="font-size: 13px;height: 30px;" class="text-center">
                    <th width="22%" class="td"colspan="4">Supplier Name</th>
                    @php $counterStopAfterThirdSuppliername = 0; @endphp
                    @foreach($suppliers as $sup=>$supplier)
                        @php $counterStopAfterThirdSuppliername++ @endphp
                        <td style="padding: 3px 0px 3px 0px" class="td text-center"> {{ \App\Supplier::find($supplier->first()->supplier_id)['name'] ?? "Unknown" }}  </td>
                    @endforeach
                    <td width="18%" rowspan="2" class="td text-center">
                        Last Purchase<br>Tk, Dt, PO, Supplier
                    </td>
                    <td width="18%" rowspan="2" class="td text-center">Remarks</td>
                </tr>
                <tr style="font-size: 13px;height: 30px; " class="text-center">
                    <th class="td text-center">Item</th>
                    <th class="td text-center">Code</th>
                    <th class="td text-center">Req Qty</th>
                    <th class="td text-center">Unit</th>
                    <!--<th class="td text-center">Qty</th>-->
                   
                    @if($requisition->purchased_status == 1)
                        @php
                            $count_suppliers = count($suppliers);
                            $count_products = count($products);
                            $supplier_number = 0;
                            $po_array = array();
                        @endphp
                        @foreach($suppliers as $sup=>$supplier)
                            @php
                                // dd($sup);
                                $po_no = App\Purchase::query()->where(get_where())->where('requisition_id',$requisition->id)->where('supplier_id',$sup)->first();

                            @endphp
                            <th class="td text-left">
                                PO No -{{$po_no ? $po_no->purchase_no: null}}
                            </th>
                        @endforeach
                    @else
                        @foreach($suppliers as $sup=>$supplier)
                            <th class="td text-left">
                                PO No -
                            </th>
                        @endforeach
                    @endif
                </tr>
                </thead>
                <tbody>
                @php $i =0; $count = 0; $j = 0 @endphp

                @if($requisition->purchased_status == 1)
                    @foreach($products as $productskey=>$cs)
                        <tr style="font-size: 13px" class="text-center">
                            @if($count == 0)
                                <td class="td cs-td">{{ $cs[$count]->requisitionProduct->product->name }}</td>
                                <td class="td cs-td">{{ $cs[$count]->requisitionProduct->product->item_code }}</td>
                                <td class="td cs-td">{{ $cs[$count]->requisitionProduct->qty }}</td>
                                <td class="td cs-td">{{ $cs[$count]->qty }} {{ optional(optional($cs[$count]->product)->unit)->name }}</td>
                              
                                <!--<td class="td cs-td"></td>-->
                                @php
                                    $counterStopAfterThirdSupplier = 0;

                                @endphp
                                @foreach($suppliers as $sup=>$supplier)

                                    @php
                                        $counterStopAfterThirdSupplier++;
                                        $pricing = App\QuotationProduct::where('supplier_id', $sup)->where('requisition_product_id',$productskey)->first();
                                        if($pricing){
                                         $purchase_product = App\PurchaseProduct::where('quotation_id',$pricing->id)->first();
                                        }
                                    @endphp

                                    @if(isset($purchase_product->id) )
                                        @if($pricing)
                                        <td class="td text-left cs-td purchased"  style="padding: 3px 0px 3px 0px;background-color: #687b7d; color: white;">
                                            
                                            Tk-{{ $pricing->price }}/- Per {{ optional(optional($cs[$count]->product)->unit)->name }}<br>
                                           
                                            @php
                                                //$last_purchase_price = $pricing->price;
                                                //$last_purchase_brand = optional(optional($cs[$count]->product)->brand)->name;
                                                $j++;
                                            @endphp
                                            
                                        </td>
                                        @else
                                        <td class="td cs-td">
                                          
                                              
                                           

                                        </td>
                                        @endif
                                    @else
                                        <td class="td text-left cs-td unpurchased" style="padding: 3px 0px 3px 0px">
                                            @if($pricing)
                                                Tk-{{ $pricing->price }}/- Per {{ optional(optional($cs[$count]->product)->unit)->name }}<br>
                                                
                                            @endif
                                        </td>
                                    @endif

                                    {{-- @if($counterStopAfterThirdSupplier == 3)
                                        @break
                                    @endif --}}
                                @endforeach
                                <td class="td cs-td text-left">
                                    @php
                                        $requisition_product = App\RequisitionProduct::where('product_id', $cs[$count]->product_id)->where('requisition_id', $cs[$count]->requisitionProduct->new_requisition->requisition->id)->first();
                                        $last_purchase = App\GoodsinProduct::find($requisition_product->last_goodsin_id);
                                        // if(!$last_purchase){
                                        //     $last_purchase = App\GoodsinProduct::where('goodsin_id','!=', 0)->where(get_where())->where('product_id',$cs[$count]->product_id)->orderBy('id','desc')->first();
                                        // }
                                        
                                    @endphp

                                    @if($last_purchase)
                                        Tk-{{ optional($last_purchase)->price }}/- Per {{ optional($last_purchase->product_unit)->name }}<br> Date: {{ $last_purchase->goodsin ? dateFormat($last_purchase->goodsin->bill_date) : null }}, PO-{{ optional($last_purchase->purchase)->purchase_no }}
                                    @else
                                        New
                                    @endif
                                </td>
                                
                            @php
                                $counterStopAfterThirdSupplier = 0;

                            @endphp
                            @foreach($suppliers as $sup=>$supplier)

                                @php
                                    $counterStopAfterThirdSupplier++;
                                    $pricing = App\QuotationProduct::where('supplier_id', $sup)->where('requisition_product_id',$productskey)->first();
                                    if($pricing){
                                     $purchase_product = App\PurchaseProduct::where('quotation_id',$pricing->id)->first();
                                    }
                                    $requisition_product = App\RequisitionProduct::where('product_id', $cs[$count]->product_id)->where('requisition_id', $cs[$count]->requisitionProduct->new_requisition->requisition->id)->first();
                                @endphp

                                @if(isset($purchase_product->id) )
                                    @if($pricing)
                                    <td class="td cs-td">
                                        {{ $requisition_product->checking_note }} 
                                        @php
                                            // $note = $requisition_product->checking_note;
                                            $j++;
                                        @endphp 
                                    </td>
                                     @endif
                                @else
                                    
                                @if($pricing)
                                    <td class="td cs-td"">
                                        {{-- {{ $note  ? $note : $requisition_product->checking_note }} --}}

                                        {{-- {!! !empty($note) ? '' : $requisition_product->checking_note !!} --}}

                                    </td>
                                @endif
                                    
                                @endif

                                {{-- @if($counterStopAfterThirdSupplier == 3)
                                    @break
                                @endif --}}
                            @endforeach

                            @endif
                        </tr>
                    @endforeach
                @else
                    @foreach($products as $productskey=>$cs)
                        <tr style="font-size: 13px">
                            @if($count == 0)
                                <td class="td cs-td text-center">{{ $cs[$count]->requisitionProduct->product->name }}</td>
                                <td class="td cs-td text-center">{{ $cs[$count]->requisitionProduct->product->item_code }}</td>
                                <td class="td cs-td">{{ $cs[$count]->requisitionProduct->qty }}</td>
                                <td class="td cs-td text-center">{{ $cs[$count]->qty }} {{ optional(optional($cs[$count]->product)->unit)->name }}</td>
                                @php $counterStopAfterThirdSupplier = 0; @endphp
                                @foreach($suppliers as $sup=>$supplier)
                                    @php
                                        $counterStopAfterThirdSupplier++;
                                        $pricing = App\QuotationProduct::where('supplier_id', $sup)->where('requisition_product_id',$productskey)->first();
                                    @endphp
                                    <!--<td class="td cs-td text-center"> </td>-->
                                    <td class="td cs-td text-left" style="padding: 3px 0px 3px 0px">
                                        @if(isset($pricing->id))
                                        Tk-{{ $pricing->price }}/- {{ optional(optional($cs[$count]->product)->unit)->name }}<br>
                                       
                                        @endif
                                    </td>
                                @endforeach
                                <td class="td cs-td text-center">
                                    @php
                                        $requisition_product = App\RequisitionProduct::where('product_id', $cs[$count]->product_id)->where('requisition_id', $cs[$count]->requisitionProduct->new_requisition->requisition->id)->first();
                                        $last_purchase = App\GoodsinProduct::find($requisition_product->last_goodsin_id);
                                        // if(!$last_purchase){
                                        //     $last_purchase = App\GoodsinProduct::where('goodsin_id','!=', 0)->where(get_where())->where('product_id',$cs[$count]->product_id)->orderBy('id','desc')->first();
                                        // }
                                    @endphp

                                    @if($last_purchase)
                                        Tk-{{ optional($last_purchase)->price }}/- Per {{ optional($last_purchase->product_unit)->name }}<br> Date-{{ dateFormat(optional($last_purchase->goodsin)->bill_date) }}, PO-{{ optional($last_purchase->purchase)->purchase_no }}
                                    @else
                                        New
                                    @endif
                                </td>
                                <td class="td cs-td">
                                    {{ $requisition_product->checking_note }}   
                                </td>
                            @endif
                        </tr>
                    @endforeach
                @endif

                </tbody>
            </table>
            <div>Note: {{ $cs_date->note }}</div>
            <div class="signature signature-gap">
                <table class=" table"  align="center" cellpadding="0" cellspacing="0" style="width: 100%;border:none; float:left;">
                    <tr>
                        <td style="border-top: 1px solid black;width: 20%;text-align: center;font-size: 13px; margin-top:30px;" ><br>Prepare By</td>
                        <td style="width: 20%;border:none;"></td>
                        <td style="border-top: 1px solid black;width: 20%;text-align: center;font-size: 13px; margin-top:30px;" ><br> Purchase Officer</td>
                        <td style="width: 20%;border:none;"></td>
                        <td style="border-top: 1px solid black;width: 20%;text-align: center;font-size: 13px"><br>Head Of the Dept.</td>
                        {{-- <td style="width: 12%;border:none;"></td>
                        <td style="border-top: 1px solid black;width: 15%;text-align: center;font-size: 13px"><br><span class="strong">ED(Tech)/ Director/ MD</span></td> --}}
                    </tr>
                </table>
            </div>
            {{-- <br><br><br> --}}
            @if($loop->last)
                <center><a id="print" class="btn-print print-none" onclick="window.print()" >Print</a></center>
            @endif
            
        </section>
        <!--<div class="page_break"></div>-->
    @endforeach

@endsection