@php
    $work_order_id                              = $advance_slip->work_order_id;
    $branch_id                                  = $advance_slip->branch_id;
    $work_order                                 = App\Models\WorkOrder::where(['id' => $work_order_id , 'branch_id' => $branch_id])->first();


    $total_advance_paid                         = $work_order->advance_slip->sum('paid_amount');
    $total_advance_recovered                    = $work_order->contractor_bills->sum('advance_amount');

    $mobilization_advance_paid                  = $work_order->mobilization_amount->sum('paid_amount');
    $total_mobilization_advance_recovered       = $work_order->contractor_bills->sum('moblization_advance_amount');

    $retention_amount_held_upto_bill            = $work_order->contractor_bills->sum('retention_amount');

@endphp
  <div size="A4">
    @include('admin.partials.image-watermark')
    @include('admin.partials.branch-watermark')
    @include('admin.sub-contracting.advance-slip.templates.header', ['extra' => $extra])
    
    <div class="box">
      <h4 class="text-a-c margin-top-20" style="text-align: center !important">ADVANCE SLIP</h4>
    </div>

    <table class="table" style="width:100%">
        <tbody>
            <tr>
                <td width="10%"><strong>Project</strong></td>
                <td width="1%">:</td>
                <td width="30%">{{$advance_slip->branch->name}}</td>

                <td width="10%"><strong>Date</strong></td>
                <td width="1%">:</td>
                <td width="30%">{{$transaction->date_format($advance_slip->voucher_date)}}</td>
            </tr>
        </tbody>
    </table>

    <div class="border-class">
        <table class="table" style="width:100%">
            <tbody>
                <tr>
                    <td width="20%"><strong>Contractor Name</strong></td>
                    <td width="1%">:</td>
                    <td width="30%">{{$work_order->contractor->name}}</td>
    
                    <td width="20%"><strong>Work Order No.</strong></td>
                    <td width="1%">:</td>
                    <td width="30%">{{$work_order->voucher_no}}</td>
                </tr>
                <tr>
                    <td><strong>Type of Work</strong></td>
                    <td width="1%">:</td>
                    <td>{{$work_order->work->name ?? '-'}}</td>
    
                    <td><strong>Work Order Amount</strong></td>
                    <td width="1%">:</td>
                    <td>{{$work_order->total_amount}}</td>
                </tr>
    
                <tr>
                    <td><strong>Work Order Location</strong></td>
                    <td width="1%">:</td>
                    <td>{{$work_order->location}}</td>
                </tr>
            </tbody>
        </table>
    </div>
    <div class="border-class">
        <div class="text-bold-underline">
            From Site
        </div>
        <div class="text-center">
            <span>Estimated amount of net Work Done for next Bill after deduction approx</span>
        </div>
        <table class="table text-center" style="width:100%">
            <tbody>
                <tr>
                    <td width="30%"><strong>ADVANCE RECOMMENDED AGAINT BILL NO</strong></td>
                    <td width="1%">:</td>
                    <td width="50%">____________________________________________</td>
                </tr>
            </tbody>
        </table>
        
        <div class="text-center">
            <span>Advance Payment for work execution at Project Site to be charge in labor part of the Contract i-e.</span>
        </div>

        <div class="mt-5">

        </div>

        <div>
            <table class="table"  style="font-size: 12px;">
                  <tr>
                    <td class="text-center border-n">
                       _______________________________ <br>
                        (Site QS)
                    </td>
      
                    <td class="text-center border-n">
                       _______________________________ <br>
                        (GM / PM)
                    </td>
    
                  </tr>
            </table>
        </div>
        <table class="table" style="width:100%">
            <tbody>
                <tr>
                    <td width="10%"><strong>Payment in favor of</strong></td>
                    <td width="1%">:</td>
                    <td width="50%">_________________________________ (PK)</td>
                </tr>
            </tbody>
        </table>
    </div>

    <div class="border-class">
        <div class="text-bold-underline">
            H O
        </div>
        <table class="table" style="width:100%">
            <tbody>
                <tr>
                    <td width="30%"><strong class="ho-font-size">Total Advances Paid Upto Bill</strong></td>
                    <td width="1%">:</td>
                    <td width="50%">{{$transaction->convert_money_format($total_advance_paid)}}</td>
                </tr>
                <tr>
                    <td width="30%"><strong class="ho-font-size">Total Advances Recovered Upto Bill</strong></td>
                    <td width="1%">:</td>
                    <td width="50%">{{$transaction->convert_money_format($total_advance_recovered)}}</td>
                </tr>
                <tr>
                    <td width="30%"><strong class="ho-font-size">Mobilization Advance Paid</strong></td>
                    <td width="1%">:</td>
                    <td width="50%">{{$transaction->convert_money_format($mobilization_advance_paid)}}</td>
                </tr>
                <tr>
                    <td width="30%"><strong class="ho-font-size">Mobilization Advance Recovered Upto Bill</strong></td>
                    <td width="1%">:</td>
                    <td width="50%">{{$transaction->convert_money_format($total_mobilization_advance_recovered)}}</td>
                </tr>
                <tr>
                    <td width="30%"><strong class="ho-font-size">Retenetion Money Held Upto Bill</strong></td>
                    <td width="1%">:</td>
                    <td width="50%">{{$transaction->convert_money_format($retention_amount_held_upto_bill)}}</td>
                </tr>
            </tbody>
        </table>

        <div class="text-bold-underline">
            Note:
        </div>

        <div>
            <table class="table"  style="font-size: 12px;">
                  <tr>
                    <td class="text-center border-n">
                       _______________________________ <br>
                        (Manager Q&E)
                    </td>
      
                    <td class="text-center border-n">
                       _______________________________ <br>
                        (Finance Div)
                    </td>
    
                  </tr>
            </table>
        </div>
    </div>


    <div class="border-class">
        <div class="text-center">
            <span>Amount Approved for Advance Rs:</span>
            <span class="bordered-box">{{$transaction->convert_money_format($advance_slip->advance_slip_amount)}}{{$transaction->systemSettingCurrency()}}</span>
        </div>

        <div>
            <table class="table"  style="font-size: 12px;">
                  <tr>
      
                    <td class="text-center border-n">
                       _______________________________ <br>
                        (C.E.O / DIRECTOR)
                    </td>
    
                  </tr>
            </table>
        </div>
    </div>
    <footer>
        Printed By:
    </footer>
  </div>
{{-- @endforeach --}}