@php
    if(!function_exists('get_lowest')){
        function get_lowest($bidders)
        {
            $min = array_reduce($bidders, function ($carry, $value){
                return $carry['bid_amount'] < $value['bid_amount']? $carry: $value;
            }, $bidders[0]);
            return  $min['id'];
        }
    }
    if(!function_exists('get_allowed_tag')){
        function get_allowed_tag($text){
            $allowed_tags = '<b><br><em><hr><i><li><ol><p><s><span><u><ul><h1><h2><h3>';
            $desc = str_replace(['<table>','</table>','<tr>','</tr>'], ['<ul>','</ul>','<li>','</li>'],$text);
            return strip_tags($desc, $allowed_tags);
        }

    }
    //$allowed_tags = ['b', 'br', 'em', 'hr', 'i', 'li', 'ol', 'p', 's', 'span', 'u', 'ul', 'h1', 'h2', 'h3'];
    $REMARK_COL = 1;
    $SUPPLIER_PER_PAGE = 3;
    $abstractdetail = $data['detail'];
    $twgs = $data['twg'];
    $suppliers = $data['detail'][0]['bidders'];
    $REGULAR_MEMBER_COUNT = 3;
    $ALT_MEMBER_COUNT = 1;
    $AS_READ = 1;
    $AS_AWARDED = 2;
@endphp
<div id="abs">
    <htmlpageheader name="mainheader">
    </htmlpageheader>
    @for($copy = 0; $copy < ceil( $data['no_of_supplier'] / $SUPPLIER_PER_PAGE); $copy++)
        <div class="header">
            <div class="vsu-header-container">
                <img src="{{ public_path('/images/vsu-logo-header.png') }}">
            </div>
            <div class="abs-barcode-container" >
                <barcode code="" type="C128B" height="0.80"  text="1"></barcode>
                <div style="font-size: 10px; width: 100%; text-align: center; position: absolute"></div>
            </div>
        </div>
        <div style="width: 100%;">
            @if($data['type'] == $AS_READ)
                <div class="abs-title" align="center">ABSTRACT OF BIDS (AS READ)</div>
            @else
                <div class="abs-title" align="center">ABSTRACT OF BIDS (AS AWARDED)</div>
            @endif
        </div>
        <div style="width: 100%; margin-top: 10px;">
            <div style=" float: left; width: 75%;">
                <table class="table-project">
                    <tr>
                        <td class="table-project-td" style="width: 27%;"><b>Project Name :</b></td>
                        <td class="table-project-td">{{ $data['bid_title'] }}</td>
                    </tr>
                    <tr>
                        <td class="table-project-td"><b>Project Location :</b></td>
                        <td class="table-project-td">Visayas State University - Main Campus</td>
                    </tr>
                    <tr>
                        <td class="table-project-td"><b>Implementing Office :</b></td>
                        <td class="table-project-td">{{ $data['owner_dept'] }}</td>
                    </tr>
                    <tr>
                        <td class="table-project-td"><b>Approve Budget for the Contract :</b></td>
                        <td class="table-project-td">Php {{ number_format($data['approved_amount'], 2) }}</td>
                    </tr>
                </table>
            </div>
            <div class="legend" style="float: right; width: 15%;">
                <div class="legend-title"> Note: </div>
                <div class="legend-scale">
                    <ul class="legend-labels">
                        <li><span style="background:#8DD3C7;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span> - Above ABC</li>
                        <li><span style="background:yellow;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span> - Award</li>
                        <li><span style="background:white; color: red;">Text</span> - LCB / SCB</li>
                    </ul>
                </div>
            </div>
        </div>
        <div style="width: 100%; margin-top: 10px;">
            <table width="100%" border="1">
                <thead>
                <tr>
                    <th rowspan="3" width="3%" style="font-weight: bold; text-align: center; border: 1px solid black !important;">Item No.</th>
                    <th rowspan="3" width="20%" style="font-weight: bold; text-align: center; border: 1px solid black !important;">DESCRIPTION</th>
                    <th rowspan="3" width="6%" style="font-weight: bold; text-align: center; border: 1px solid black !important;">UNIT</th>
                    <th rowspan="3" width="5%" style="font-weight: bold; text-align: center; border: 1px solid black !important;">QTY</th>
                    <th rowspan="3" width="8%" style="font-weight: bold; text-align: center; border: 1px solid black !important;">ABC</th>
                    <th colspan="{{$SUPPLIER_PER_PAGE + $REMARK_COL}}" style="font-weight: bold; text-align: center; border: 1px solid black !important;">NAME OF FIRM OR DEALER</th>
                </tr>
                <tr>
                    @for($i= $copy*$SUPPLIER_PER_PAGE ; $i < ($copy*$SUPPLIER_PER_PAGE)+$SUPPLIER_PER_PAGE ; $i++)
                        @if($i < $data['no_of_supplier'])
                            <th style="font-weight: bold; text-align: center; border: 1px solid black !important;" width="10%">{{$suppliers[$i]['supplier']['supplier_name']}}</th>
                        @else
                            <th style="font-weight: bold; text-align: center; border: 1px solid black !important;" width="10%">&nbsp;</th>
                        @endif
                    @endfor
                    <th style="font-weight: bold; text-align: center; border: 1px solid black !important;" rowspan="2" width="7%">REMARKS</th>
                </tr>
                <tr>
                    @for($i= $copy*$SUPPLIER_PER_PAGE ; $i < ($copy*$SUPPLIER_PER_PAGE)+$SUPPLIER_PER_PAGE ; $i++)
                        @if($i < $data['no_of_supplier'])
                            <th style="font-weight: bold; text-align: center; border: 1px solid black !important;">Unit Price</th>
                        @else
                            <th style="font-weight: bold; text-align: center; border: 1px solid black !important;">&nbsp;</th>
                        @endif
                    @endfor
                </tr>
                </thead>
                <tbody>
                @php
                    $currentRow = 0;
                    $totalRows = 100; // Example number of rows
                @endphp
                @for($i=0; $i < count($abstractdetail); $i++)
{{--                @for($i=0; $i < $totalRows; $i++)--}}
                    {{--                @for($i=0; $i < 17; $i++)--}}

                    <tr class="break">
                        <td class="row-details">{{$i+1}}</td>
                        <td class="row-details" style="text-align: left;"><span style="font-size: 13px; font-weight: bold">{{$abstractdetail[$i]['stock']['descript']}}</span>
                            @if($abstractdetail[$i]['stock']['spec'])
                                @php
                                    $desc = get_allowed_tag($abstractdetail[$i]['stock']['spec']['full_descript']);
                                @endphp
                                <div style="font-size: 12px; font-style: italic;">
                                    {!! $desc !!}
                                </div>
                            @endif
                        </td>
                        @php
                            $new_abc = is_null($abstractdetail[$i]['abc_updated']) ?
                                        $abstractdetail[$i]['price']['unit_price']: $abstractdetail[$i]['abc_updated'];
                            $lowest_bid_id = null;
                            $lowest_bid_id = get_lowest(json_decode($abstractdetail[$i]['bidders'],true));
                        @endphp
                        <td class="row-details">{{$abstractdetail[$i]['stock']['unit']['unit']}}</td>
                        <td class="row-details" style="text-align: center;">{{$abstractdetail[$i]['total_qty']}}</td>
                        <td class="row-details">{{number_format($new_abc,2)}}</td>
                        @for($supp= $copy*$SUPPLIER_PER_PAGE ; $supp < ($copy*$SUPPLIER_PER_PAGE)+$SUPPLIER_PER_PAGE ; $supp++)
                            @if($supp < $data['no_of_supplier'])
                                @php
                                    $class = "row-details";

                                    if (!is_null($lowest_bid_id) and $lowest_bid_id == $abstractdetail[$i]['bidders'][$supp]['id']){
                                        $class .= " lcb";
                                    }

                                    if($abstractdetail[$i]['bidders'][$supp]['bid_amount'] > $new_abc){
                                        $class .= $data['type'] == $AS_READ? " above-abc" : "";
                                    }
                                    if ($abstractdetail[$i]['bidders'][$supp]['won'] == 1) {
                                        $class .= $data['type'] == $AS_AWARDED? " award": "";
                                    }

                                @endphp
                                <td class="{{ $class }}">
                                    <div style="text-align: center;">
                                        <span>{{ number_format($abstractdetail[$i]['bidders'][$supp]['bid_amount'],2)}}</span><br>
                                        @if ($abstractdetail[$i]['bidders'][$supp]['offer_remarks'] != null)
                                            <span class="offer-remark"> <b>Offer</b></span>
                                            <div style="font-size: 12px; font-style: italic;">
                                                {!! $abstractdetail[$i]['bidders'][$supp]['offer_remarks'] !!}
                                            </div>
                                        @endif
                                    </div>
                                </td>
                            @else
                                <td class="row-details">&nbsp;</td>
                            @endif
                        @endfor
                        @if($data['type'] == $AS_AWARDED)
                            <td class="row-details"> {{$abstractdetail[$i]['remarks']}}</td>
                        @else
                            <td class="row-details"> &nbsp;</td>
                        @endif
                    </tr>
                @endfor
                <tr>
                    <td class="row-details"></td>
                    <td class="row-details-end"> xxxxxxxxxxxxxxNothing Followsxxxxxxxxxxxxxxxxx </td>
                    <td class="row-details"></td>
                    <td class="row-details"></td>
                    <td class="row-details"></td>
                    @for($supp= $copy*$SUPPLIER_PER_PAGE ; $supp < ($copy*$SUPPLIER_PER_PAGE)+$SUPPLIER_PER_PAGE ; $supp++)
                        <td class="row-details">&nbsp;</td>
                    @endfor
                    <td class="row-details"></td>
                </tr>
                </tbody>
            </table>
        </div>

        @if($copy != ceil($data['no_of_supplier'] / $SUPPLIER_PER_PAGE)-1)
            <pagebreak></pagebreak>
        @endif
    @endfor
    <div style="width: 100%; height: auto; bottom: 0; padding-top: 2px;" >
        <table width="100%">
            <tr>
                <td>
                    <table>
                        <tr>
                            <td class="table-project-td" width="12%">WE HEREBY CERTIFY: &nbsp; </td>
                            <td class="table-project-td"> 1. That we opened the bids publicy in response to a public advertisement copy of which is filed herewith. </td>
                        </tr>
                        <tr>
                            <td></td>
                            <td class="table-project-td"> 2. That all the entries above are true and correct.</td>
                        </tr>

                    </table>
                </td>
            </tr>
        </table>
    </div>
    <div style="width: 100%; height: auto; bottom: 0; margin-top: 10px;" >
        <div style="width: 65%; float: left; font-size: 14px;">
            <h4>COMMITTEE ON BIDS AND AWARDS:</h4>
            <table width="100%" style="margin-left: 5px;">
                <tr>
                    <td class="bac_twg">
                        @if(count($data->bac_chair) > 0)
                            <b>{{ strtoupper($data->bac_chair[0]['personnels']['realname']) }}
                        @endif
                        </b><br/>
                        Chairperson
                    </td>
                    <td class="bac_twg">
                        @if(count($data->bac_vice_chair) > 0)
                        <b>{{ strtoupper($data->bac_vice_chair[0]['personnels']['realname']) }}
                            @endif
                        </b><br/>
                        Vice-Chairperson
                    </td>
                </tr>
                <tr>
                    @for($reg_member_count = 0; $reg_member_count < $REGULAR_MEMBER_COUNT and $reg_member_count < count($data->bac_reg_member); $reg_member_count++ )
                        <td class="bac_twg">
                            <b>{{ strtoupper($data->bac_reg_member[$reg_member_count]['personnels']['realname']) }}</b><br/>
                            Regular Member
                        </td>
                    @endfor
                        @for($alt_member_count = 0; $alt_member_count < $ALT_MEMBER_COUNT and $alt_member_count < count($data->bac_alt_member); $alt_member_count++ )
                            <td class="bac_twg">
                                <b>{{ strtoupper($data->bac_alt_member[$alt_member_count]['personnels']['realname']) }}</b><br/>
                                Alternate Member
                            </td>
                        @endfor
                </tr>
            </table>
        </div>
        <div style="width: 35%; float: right;">
            <h4>TECHNICAL WORKING GROUP:</h4>
            <table width="100%" style="margin-left:5px;">
                @if(count($data->twg) >= 2)
                    <tr>
                        <td class="bac_twg">
                            <b>{{ strtoupper($data->twg [0]['personnels']['realname']) }}
                            </b><br/>
                            Member
                        </td>
                    </tr>
                    <tr>
                        <td class="bac_twg">
                            <b>{{ strtoupper($data->twg[1]['personnels']['realname']) }}</b><br/>
                            Member
                        </td>
                    </tr>
                @else
                    <tr>
                        <td class="bac_twg">
                            <b>No TWG assigned to this category</b><br/>
                        </td>
                    </tr>
                @endif
            </table>
        </div>

    </div>
    {{--    <div style="width: 100%; height: auto;" >--}}
    {{--        <p style="font-weight: bold;">COMMITTE ON BIDS AND AWARDS : </p>--}}
    {{--    </div>--}}

    {{--    <htmlpagefooter name="mainfooter">--}}
    {{--        <div style="text-align: right;font-size: 11px;font-weight:  400; ">Control No.: {{$data['control_num']}}</div>--}}
    {{--    </htmlpagefooter>--}}
</div>