@php
    $list = $data['list'];
    $signatory = $data['signatory'];
    $obligation_total = 0.00;
    $firstdata = [];
    $obligation = [];
    $grosstotal =0.00;
    $deductiontotal = 0.00;
    $grandtotal_deduciton = 0.00;
    $grandtotal = 0.00;
    $monthly =[];
    $codes = [
        '100000000' => 0.00,
        '302000000' => 0.00,
        '301000000' => 0.00,
        '303000000' => 0.00,
        '304000000' => 0.00,
        '200010000' => 0.00
    ];
    $code1 = 0;
    $code2 = 0;
    $code3 = 0;
    $code4 = 0;
    $code5 = 0;
    $code6 = 0;

    foreach ($list as $key => $newdata){
        $firstdata = $newdata;
        break;
    }
    foreach ($list as $key => $data){
                $monthly =[];
                $total = 0.00;
                $first = \Carbon\Carbon::parse($data['effective_date'].'12:00:00');
                $last = \Carbon\Carbon::parse($data['nosi_approve_date'].'12:00:00');
                $i = $first->year;
                $ctn = 0; $level = 0;
                if(date('d',strtotime($first)) > 1){
                     $lastday = new DateTime($first);
                     $lastday->modify('last day of this month');
                     $monthly[$ctn] = [date('M d',strtotime( $first->format('Y-m-d'))).' -'.date('d, Y',strtotime( $lastday->format('Y-m-d'))),$first->diffInDays($lastday),1];
                     $ctn++;
                     $level++;
                }
                while ($i < $last->year) {
                    if($level == 0){
                        $month = date('Y-m',strtotime($first));
                        $lastdate = \Carbon\Carbon::parse($i.'-12-31');
                        $test = \Carbon\Carbon::parse($first);
                    }else {
                        $month = date('Y-m',strtotime(' +1 months '. $first));
                        $lastdate = \Carbon\Carbon::parse($i.'-12-01');
                        $test = \Carbon\Carbon::parse($first);
                        $level = 0;
                    }
                     $monthly[$ctn] = [((date('m',strtotime($month)) == 12)?'Dec':date('M',strtotime($month)).'- Dec').' 1-31, '.date('Y',strtotime($first)),31,$lastdate->diffInMonths($test) + 1];
                     $ctn++; $i++;
                     $first = $i.'-01-01';
                }
                $last = \Carbon\Carbon::parse($last);
                $test0 = \Carbon\Carbon::parse($first);
                $monthly[$ctn] = [((date('M',strtotime($first)) == date('M',strtotime( $last->format('Y-m'))))? '':date('M',strtotime($first)).'-').date('M',strtotime( $last->format('Y-m'))).' 1-'.date('d, Y',strtotime( $last->format('Y-m-d'))),31,$last->diffInMonths($test0) + 1];
                $diff =  $data['new_rate'] - $data['old_rate'];

        foreach ($monthly as $value){
            $gross = ($diff/31)*$value[1]*$value[2];
            $deduction = $gross * 0.09;
            $recieve = $gross - $deduction;
            $total += $recieve;
            $grandtotal_deduciton += $deduction;
            $deductiontotal += $deduction;
            $grosstotal +=$gross;
            $grandtotal +=$grosstotal;
        }
        if($data['personnel']['fund_source']['code'] == '100000000'){
            $codes['100000000'] += $grosstotal;
        }
        if($data['personnel']['fund_source']['code'] == '302000000'){
            $codes['302000000'] += $grosstotal;
        }
        if($data['personnel']['fund_source']['code'] == '301000000'){
            $codes['301000000'] += $grosstotal;
        }
        if($data['personnel']['fund_source']['code'] == '303000000'){
            $codes['303000000'] += $grosstotal;
        }
        if($data['personnel']['fund_source']['code'] == '304000000'){
            $codes['304000000'] += $grosstotal;
        }
        if($data['personnel']['fund_source']['code'] == '200010000'){
            $codes['200010000'] += $grosstotal;
        }
    }


@endphp
<style>
    @page{
        margin-top:5%;
        margin-right: 2%;
        margin-left: 2%;
        margin-bottom: 2%;
        font-family: "Courier New", Courier, "Lucida Sans Typewriter", "Lucida Typewriter", monospace; font-size: 10px; font-style: normal; font-variant: normal; font-weight: 700;
    }
    table {
        border-collapse: collapse;
        font-family: Calibri, sans-serif;
        width: 100%;
    }
    td.form_header {
        text-align: center;
    }
    td.note {
        line-height: 2;
        font-size: 9pt !important;
    }
    td.border{
        border-top: solid 0.5pt black;
    }
    td.border-left{
        border-left: solid 0.5pt black;
    }
    td.border-right{
        border-right: solid 0.5pt black;
    }
    td.border-bottom{
        border-bottom: solid 0.5pt black;
    }
    tr.head_row {
        border-top: solid 0.5pt black;
    }
    tr.head_row_thin {
        border-top: solid 0.5pt black;
    }
    td.mini-head {
        text-align: center;
    }
    .content {
        padding-top: 10pt;
        padding-bottom: 10pt;
        padding-right: 5pt;
        text-align: center;
        vertical-align: text-top;
    }
    .amount {
        text-align: right;
        padding-right: 5pt;
    }
    p {
        line-height: 1.6;
    }
    .labelA {
        border: 1pt solid black;
        letter-spacing: 2pt;
        padding: 100px 2px 3px 4px !important;
         }
</style>
<div>
    <div style="text-align: right; padding-bottom: 5pt">
        <span>Annex F</span>
    </div>
    <table width="100%" cellspacing="0" autoresize="1" >
        <tr>
            <td width="65%" colspan="4" class="form_header border border-left"><h3>OBLIGATION REQUEST AND STATUS</h3></td>
            <td width="15%" class="border border-left">No.:     PS</td>
            <td colspan="2" width="20%" class="border border-right border-bottom"></td>
        </tr>
        <tr>
            <td colspan="4" class="form_header border-left"><h4>VISAYAS STATE UNIVERSITY</h4></td>
            <td class="border-left">Date:</td>
            <td colspan="2" class="border-right border-bottom"></td>
        </tr>
        <tr>
            <td colspan="4" class="form_header border-left"><h6>Visca, Baybay City, Leyte</h6></td>
            <td class="border-left">Fund:</td>
            <td colspan="2" class="border-right"></td>
        </tr>
        <tr>
            <td width="20%" class="border border-left border-right">Payee:</td>
            <td colspan="2" width="20%" class="border">{{ $firstdata['personnel']['person_info']['realname'] }}</td>
            <td class="border">ETAL</td>
            <td class="border"></td>
            <td class="border"></td>
            <td class="border border-right"></td>
        </tr>
        <tr>
            <td width="20%" class="border border-left border-right" >Office:</td>
            <td colspan="6"  class="border border-right"></td>
        </tr>
        <tr>
            <td width="20%" class="border border-left border-right">Address:</td>
            <td colspan="6" class="border border-right">VSU-MAIN</td>
        </tr>
        <tr class="head_row">
            <td width="20%" class="border border-left mini-head"><h6>Responsibility Center</h6></td>
            <td width="45%" colspan="3" class="border border-left mini-head"><h6>Particulars</h6></td>
            <td width="11%" class="border border-left mini-head"><h6>MFO/PAP</h6></td>
            <td width="11%" class="border border-left border-right mini-head"><h6>UACS Code / Expenditure</h6></td>
            <td width="13%" class="border border-right mini-head"><h6>Amount</h6></td>
        </tr>
        <tr class="head_row_thin">
            <td class="border border-left content" height="200pt"  width="20%"></td>
            <td class="border border-left content" width="45%" colspan="3">
                SALARY DIFFERENTIAL for <br>
                {{ date('M d',strtotime($first)) }} - {{ date('M d, Y',strtotime($last)) }}
            </td>
            <td class="border border-left content" width="11%">
                @foreach($codes as $key => $data)
                    @if($data > 0)
                        {{$key}}<br><br>
                    @endif
                @endforeach
            <td class="border border-left content" width="11%">
                @foreach($codes as $key => $data)
                    @if($data > 0)
                        5010101001<br><br>
                    @endif
                @endforeach
            </td>
            <td class="border border-left border-right content amount" width="13%" style="text-align: right">
                @foreach($codes as $key => $data)
                    @if($data > 0)
                        {{ number_format((float)$data, 2, '.', ',')}}<br><br>
                    @endif
                @endforeach
            </td>
        </tr>
        <tr class="head_row_thin">
            <td class=" border-left content" width="20%"></td>
            <td class=" border-left content" width="45%" colspan="3" style="text-align: right">Total</td>
            <td class=" border-left content" width="11%"></td>
            <td class=" border-left content" width="11%"></td>
            <td class="border border-left border-right content amount" width="13%" style="text-align: right; font-weight: bold"> {{number_format((float)$grandtotal, 2, '.', ',')}}</td>
        </tr>
        <tr>
            <td class="border border-left" width="20%" style="vertical-align: text-top;"><span class="labelA">  A</span> &nbsp;&nbsp;&nbsp; <span style="padding-left: 200px;">Certified:</span></td>
            <td width="48%" colspan="2" class="note border">Charges to appropration/allotment <br> necessary, lawful and under my direct supervision <br> and supporting documents valid, proper and legal</td>
            <td class="border border-left" width="12%" style="vertical-align: text-top;"><span class="labelA">  B</span> &nbsp;&nbsp;&nbsp; Certified:</td>
            <td width="30%" colspan="3" class="note border border-right">Allotment available and obligated for the <br> purpose/adjustment necessary as <br> indicated above</td>
        </tr>
        <tr>
            <td class="border-left" width="20%" height="25pt">Signature:</td>
            <td class="border-bottom" colspan="2"></td>
            <td class="border-left" >Signature:</td>
            <td class="border-bottom border-right" colspan="3"></td>
        </tr>
        <tr>
            <td class="border-left" width="20%" height="25pt">Printed Name</td>
            <td class="border-bottom" colspan="2" style="text-align: center"> {{strtoupper($signatory[0]['head']['realname'])}}</td>
            <td class="border-left" >Printed Name</td>
            <td class="border-bottom border-right" colspan="3" style="text-align: center">{{strtoupper($signatory[1]['head']['realname'])}}</td>
        </tr>
        <tr>
            <td class="border-left" width="20%" height="25pt">Position:</td>
            <td class="border-bottom" colspan="2" style="font-size: 9pt; text-align: center">Vice President for Admin. & Finance</td>
            <td class="border-left" >Position:</td>
            <td class="border-bottom border-right" colspan="3" style="font-size: 9pt; text-align: center">ADMIN OFFICER V</td>
        </tr>
        <tr>
            <td class="border-left" width="20%" height="25pt"></td>
            <td class="border-bottom" colspan="2"></td>
            <td class="border-left"  ></td>
            <td class="border-bottom border-right" colspan="3" style="font-size: 9pt; text-align: center">Head, Budget Unit/Authorized Representative</td>
        </tr>
        <tr>
            <td class="border-left" width="20%" height="25pt">Date:</td>
            <td colspan="2"></td>
            <td class="border-left" >Date:</td>
            <td class="border-right" colspan="3"></td>
        </tr>
    </table>
    <table  width="100%" cellspacing="0" autoresize="1">
        <tr>
            <td class="border border-left"><span class="labelA">C</span></td>
            <td class="border border-right" colspan="6" style="text-align: center"><h3>STATUS OF OBLIGATION</h3></td>
        </tr>
        <tr>
            <td class="mini-head border border-left border-right" width="50%" colspan="3">Reference</td>
            <td class="mini-head border border-right" width="50%" colspan="4">Amount</td>
        </tr>
        <tr>
            <td class="mini-head border border-left border-bottom" width="15%">Date</td>
            <td class="mini-head border border-left" width="12%">Particulars</td>
            <td class="mini-head border border-left" width="20%">ORS/JEV/RCI/RADAI No.</td>
            <td class="mini-head border border-left" width="15%">Obligation</td>
            <td class="mini-head border border-left" width="12%">Payment</td>
            <td class="mini-head border border-left" width="15%">Not Yet Due</td>
            <td class="mini-head border border-right" >Due and Demandable</td>
        </tr>
        <tr>
            <td rowspan="2" class="border border-left border-bottom"></td>
            <td  class="mini-head border border-left border-bottom" rowspan="2">Obligation</td>
            <td class="border border-left" height="50pt" ></td>
            <td class="amount border border-left">{{number_format((float)$grandtotal, 2, '.', ',')}}</td>
            <td class="border border-left"></td>
            <td class="amount border border-left"> {{number_format((float)$grandtotal, 2, '.', ',')}}</td>
            <td class="border border-left border-right"></td>
        </tr>
        <tr>
            <td class="border border-left border-bottom">Totals</td>
            <td class="border border-left border-bottom"></td>
            <td class="border border-left border-bottom"></td>
            <td class="border border-left border-bottom"></td>
            <td class="border border-left border-bottom border-right"></td>
        </tr>
    </table>
</div>