@php use App\Models\SPPMO\Constants; $offs_sequence = 0; $const_sequence = 0; $oacs_sequence = 0; $others_sequence = 0; $grand_total = []; $infra_total = []; $grand_total_index = 0; @endphp {{--@include('sppmo.header_landscape')--}}
Date Covered: {{$data['date_covered'][0]}} - {{$data['date_covered'][1]}}
Page {PAGENO} of {nbpg}
Date Generated: @php echo date('Y-m-d H:i:s') @endphp
Republic of the Philippines
VISAYAS STATE UNIVERSITY
Visca, Baybay City, Leyte
Annual Procurement Plan (APP) for FY {{ $data['year'] }}
In Thousand Pesos
{{-- START GOODS FIRST QUARTER--}} @for($i = 0; $i< $data['category_size']; $i++) @for($k = 0; $k< $data['mop_size']; $k++) @php $totaloffs1= 0; @endphp @php $totaloffs_set1= 0; @endphp @foreach($data['categoryqtr1'.$i.$k] as $index => $offs_qtr1 ) {{-- @foreach($data['categoryqtr1_set'.$i.$k] as $index =>$offs_qtr1_set) @if(($offs_qtr1->ch_id == $offs_qtr1_set->ch_id) && ($offs_qtr1->mop_id == $offs_qtr1_set->mop_id) && ($offs_qtr1->fund_sourc == $offs_qtr1_set->ch_id)) @endif @endforeach --}} {{-- {{$data['categoryqtr1'.$i.$k][0]->category}}--}} @php $totaloffs1 = $totaloffs1 + $total; @endphp @endforeach @if($totaloffs1 != 0) {{-- {{$data['categoryqtr1'.$i.$k][0]->category}}--}} error @php $grand_total[$grand_total_index] = $totaloffs1; $grand_total_index++; @endphp @endif {{-- ITEM PACKAGE--}} {{-- @foreach($data['categoryqtr_set1'.$i.$k] as $index => $offs_set1 )--}} {{-- --}} {{-- --}}{{-- {{$data['categoryqtr1'.$i.$k][0]->category}}--}} {{-- --}} {{-- --}} {{-- --}} {{-- --}} {{-- --}} {{-- --}} {{-- --}} {{-- --}} {{-- --}} {{-- --}} {{-- --}} {{-- --}} {{-- --}} {{-- --}} {{-- --}} {{-- --}} {{-- --}} {{-- --}} {{-- --}} {{-- --}} {{-- --}} {{-- --}} {{-- --}} {{-- @php--}} {{-- $totaloffs_set1 = $totaloffs_set1 + $total;--}} {{-- @endphp--}} {{-- @endforeach--}} {{-- @if($totaloffs_set1 != 0)--}} {{-- --}} {{-- --}}{{-- {{$data['categoryqtr1'.$i.$k][0]->category}}--}} {{-- --}} {{-- --}} {{-- --}} {{-- error--}} {{-- --}} {{-- --}} {{-- --}} {{-- --}} {{-- --}} {{-- --}} {{-- --}} {{-- @endif--}} {{-- END ITEM PACKAGE--}} @endfor @endfor {{-- END GOODS FIRST QUARTER--}} {{-- GOODS SECOND QUARTER--}} @for($i = 0; $i< $data['category_size']; $i++) @for($k = 0; $k< $data['mop_size']; $k++) @php $totaloffs1= 0; @endphp @foreach($data['categoryqtr2'.$i.$k] as $index => $offs_qtr1 ) {{-- {{$data['categoryqtr2'.$i.$k][0]->category}}--}} @php $totaloffs1 = $totaloffs1 + $total; @endphp @endforeach @if($totaloffs1 != 0) @php $grand_total[$grand_total_index] = $totaloffs1; $grand_total_index++; @endphp @endif @endfor @endfor {{-- --}}{{-- END GOODS SECOND QUARTER--}} {{-- --}}{{-- GOODS 3RD QUARTER--}} @for($i = 0; $i< $data['category_size']; $i++) @for($k = 0; $k< $data['mop_size']; $k++) @php $totaloffs1= 0; @endphp @foreach($data['categoryqtr3'.$i.$k] as $index => $offs_qtr1 ) {{-- {{$data['categoryqtr3'.$i.$k][0]->category}}--}} @php $totaloffs1 = $totaloffs1 + $total; @endphp @endforeach @if($totaloffs1 != 0) @php $grand_total[$grand_total_index] = $totaloffs1; $grand_total_index++; @endphp @endif @endfor @endfor {{-- --}}{{-- END GOODS 3RD QUARTER--}} {{-- --}}{{-- GOODS 4th QUARTER--}} @for($i = 0; $i< $data['category_size']; $i++) @for($k = 0; $k< $data['mop_size']; $k++) @php $totaloffs1= 0; @endphp @foreach($data['categoryqtr4'.$i.$k] as $index => $offs_qtr1 ) {{-- {{$data['categoryqtr4'.$i.$k][0]->category}}--}} @php $totaloffs1 = $totaloffs1 + $total; @endphp @endforeach @if($totaloffs1 != 0) @php $grand_total[$grand_total_index] = $totaloffs1; $grand_total_index++; @endphp @endif @endfor @endfor {{-- END GOODS 4th QUARTER--}} {{--START FOR CIVIL WORKS--}} {{-- @foreach($data['cw_modes'] as $mode_key=>$mode_value)--}} {{-- @foreach($data['cw_funding'] as $funding_key => $funding_value)--}} {{-- --}} {{-- @endforeach--}} {{-- @endforeach--}} @foreach($data['civil_works'] as $cw_item) @php $totaloffs1 = 0; @endphp @php array_push($infra_total, $cw_item->total_cost); @endphp @endforeach @php $grand_total[$grand_total_index] = array_sum($infra_total); @endphp {{--END FOR CIVIL WORKS--}}
Code (PAP) Procurement Program/Project PMO/
EndUser		 Mode of Procurement Schedule of Each Procurement Activity Source of funds Estimated Budget (PhP) Remarks()
Ads/Post of IEI/REI Sub/Open of Bids Notice of Awards Contract Signing Total MOOE CO
{{$data['categoryqtr1'.$i.$k][0]->category}}
{{-- @if($offs_qtr1->ch_id == 2)--}} {{-- OFFS-{{ sprintf('%03d',$offs_sequence + 1) }}--}} {{-- @php--}} {{-- $offs_sequence++;--}} {{-- @endphp--}} {{-- @endif--}} {{-- @if($offs_qtr1->ch_id == 1)--}} {{-- CONST-{{ sprintf('%03d',$const_sequence + 1) }}--}} {{-- @php--}} {{-- $const_sequence++;--}} {{-- @endphp--}} {{-- @endif--}} {{-- @if($offs_qtr1->ch_id == 3)--}} {{-- OACS-{{ sprintf('%03d',$oacs_sequence + 1) }}--}} {{-- @php--}} {{-- $oacs_sequence++;--}} {{-- @endphp--}} {{-- @endif--}} {{-- @if($offs_qtr1->ch_id == 4)--}} {{-- OTHERS-{{ sprintf('%03d',$others_sequence + 1) }}--}} {{-- @php--}} {{-- $others_sequence++;--}} {{-- @endphp--}} {{-- @endif--}} {{ substr($offs_qtr1->category, 0, 4).sprintf('%03d',$offs_sequence + 1)}} @php $offs_sequence++; @endphp {{ $offs_qtr1->category }} {{ $offs_qtr1->fund_source }} {{-- @if($offs_qtr1->mop_id == 1)--}} {{-- CB--}} {{-- @endif--}} {{-- @if($offs_qtr1->mop_id == 2)--}} {{-- NP-SVP--}} {{-- @endif--}} {{-- @if($offs_qtr1->mop_id == 3)--}} {{-- DC--}} {{-- @endif--}} {{-- @if($offs_qtr1->mop_id == 5)--}} {{-- Not Assigned--}} {{-- @endif--}} {{$offs_qtr1->mop}} 1st Quarter GoP {{-- P {{ number_format($offs_qtr1->ttotal, 2) }}--}} @php $total = $offs_qtr1->ttotal @endphp P {{ number_format($total, 2) }} P {{ number_format($total, 2) }}
Total P {{ number_format( $totaloffs1, 2) }}
{{$data['categoryqtr_set1'.$i.$k][0]->category}}
--}} {{-- @if($offs_set1->ch_id == 2)--}} {{-- OFFS-{{ sprintf('%03d',$offs_sequence + 1) }}--}} {{-- @php--}} {{-- $offs_sequence++;--}} {{-- @endphp--}} {{-- @endif--}} {{-- @if($offs_set1->ch_id == 1)--}} {{-- CONST-{{ sprintf('%03d',$const_sequence + 1) }}--}} {{-- @php--}} {{-- $const_sequence++;--}} {{-- @endphp--}} {{-- @endif--}} {{-- @if($offs_set1->ch_id == 3)--}} {{-- OACS-{{ sprintf('%03d',$oacs_sequence + 1) }}--}} {{-- @php--}} {{-- $oacs_sequence++;--}} {{-- @endphp--}} {{-- @endif--}} {{-- @if($offs_set1->ch_id == 4)--}} {{-- OTHERS-{{ sprintf('%03d',$others_sequence + 1) }}--}} {{-- @php--}} {{-- $others_sequence++;--}} {{-- @endphp--}} {{-- @endif--}} {{-- {{$offs_set1->category }} {{ $offs_set1->fund_source }}--}} {{-- @if($offs_set1->mop_id == 1)--}} {{-- CB--}} {{-- @endif--}} {{-- @if($offs_set1->mop_id == 2)--}} {{-- NP-SVP--}} {{-- @endif--}} {{-- @if($offs_set1->mop_id == 3)--}} {{-- DC--}} {{-- @endif--}} {{-- @if($offs_set1->mop_id == 5)--}} {{-- Not Assigned--}} {{-- @endif--}} {{-- 1st QuarterGoP--}} {{-- --}}{{-- P {{ number_format($offs_qtr1->ttotal, 2) }}--}} {{-- @php--}} {{-- $total = $offs_set1->ttotal--}} {{-- @endphp--}} {{-- P {{ number_format($total, 2) }}--}} {{-- P {{ number_format($total, 2) }}
TotalP {{ number_format( $totaloffs_set1, 2) }}
{{$data['categoryqtr2'.$i.$k][0]->category}}
{{-- @if($offs_qtr1->ch_id == 2)--}} {{-- OFFS-{{ sprintf('%03d',$offs_sequence + 1) }}--}} {{-- @php--}} {{-- $offs_sequence++;--}} {{-- @endphp--}} {{-- @endif--}} {{-- @if($offs_qtr1->ch_id == 1)--}} {{-- CONST-{{ sprintf('%03d',$const_sequence + 1) }}--}} {{-- @php--}} {{-- $const_sequence++;--}} {{-- @endphp--}} {{-- @endif--}} {{-- @if($offs_qtr1->ch_id == 3)--}} {{-- OACS-{{ sprintf('%03d',$oacs_sequence + 1) }}--}} {{-- @php--}} {{-- $oacs_sequence++;--}} {{-- @endphp--}} {{-- @endif--}} {{-- @if($offs_qtr1->ch_id == 4)--}} {{-- OTHERS-{{ sprintf('%03d',$others_sequence + 1) }}--}} {{-- @php--}} {{-- $others_sequence++;--}} {{-- @endphp--}} {{-- @endif--}} {{ substr($offs_qtr1->category, 0, 4).sprintf('%03d',$offs_sequence + 1)}} @php $offs_sequence++; @endphp {{ $offs_qtr1->category }} {{ $offs_qtr1->fund_source }} {{-- @if($offs_qtr1->mop_id == 1)--}} {{-- CB--}} {{-- @endif--}} {{-- @if($offs_qtr1->mop_id == 2)--}} {{-- NP-SVP--}} {{-- @endif--}} {{-- @if($offs_qtr1->mop_id == 3)--}} {{-- DC--}} {{-- @endif--}} {{-- @if($offs_qtr1->mop_id == 5)--}} {{-- Not Assigned--}} {{-- @endif--}} {{$offs_qtr1->mop}} 2nd Quarter GoP {{-- P {{ number_format($offs_qtr1->ttotal, 2) }}--}} @php $total = $offs_qtr1->ttotal @endphp P {{ number_format($total, 2) }} P {{ number_format($total, 2) }}
Total P {{ number_format( $totaloffs1, 2) }}
{{$data['categoryqtr3'.$i.$k][0]->category}}
{{-- @if($offs_qtr1->ch_id == 2)--}} {{-- OFFS-{{ sprintf('%03d',$offs_sequence + 1) }}--}} {{-- @php--}} {{-- $offs_sequence++;--}} {{-- @endphp--}} {{-- @endif--}} {{-- @if($offs_qtr1->ch_id == 1)--}} {{-- CONST-{{ sprintf('%03d',$const_sequence + 1) }}--}} {{-- @php--}} {{-- $const_sequence++;--}} {{-- @endphp--}} {{-- @endif--}} {{-- @if($offs_qtr1->ch_id == 3)--}} {{-- OACS-{{ sprintf('%03d',$oacs_sequence + 1) }}--}} {{-- @php--}} {{-- $oacs_sequence++;--}} {{-- @endphp--}} {{-- @endif--}} {{-- @if($offs_qtr1->ch_id == 4)--}} {{-- OTHERS-{{ sprintf('%03d',$others_sequence + 1) }}--}} {{-- @php--}} {{-- $others_sequence++;--}} {{-- @endphp--}} {{-- @endif--}} {{ substr($offs_qtr1->category, 0, 4).sprintf('%03d',$offs_sequence + 1)}} @php $offs_sequence++; @endphp {{ $offs_qtr1->category }} {{ $offs_qtr1->fund_source }} {{-- @if($offs_qtr1->mop_id == 1)--}} {{-- CB--}} {{-- @endif--}} {{-- @if($offs_qtr1->mop_id == 2)--}} {{-- NP-SVP--}} {{-- @endif--}} {{-- @if($offs_qtr1->mop_id == 3)--}} {{-- DC--}} {{-- @endif--}} {{-- @if($offs_qtr1->mop_id == 5)--}} {{-- Not Assigned--}} {{-- @endif--}} {{$offs_qtr1->mop}} 3rd Quarter GoP {{-- P {{ number_format($offs_qtr1->ttotal, 2) }}--}} @php $total = $offs_qtr1->ttotal @endphp P {{ number_format($total, 2) }} P {{ number_format($total, 2) }}
Total P {{ number_format( $totaloffs1, 2) }}
{{$data['categoryqtr4'.$i.$k][0]->category}}
{{-- @if($offs_qtr1->ch_id == 2)--}} {{-- OFFS-{{ sprintf('%03d',$offs_sequence + 1) }}--}} {{-- @php--}} {{-- $offs_sequence++;--}} {{-- @endphp--}} {{-- @endif--}} {{-- @if($offs_qtr1->ch_id == 1)--}} {{-- CONST-{{ sprintf('%03d',$const_sequence + 1) }}--}} {{-- @php--}} {{-- $const_sequence++;--}} {{-- @endphp--}} {{-- @endif--}} {{-- @if($offs_qtr1->ch_id == 3)--}} {{-- OACS-{{ sprintf('%03d',$oacs_sequence + 1) }}--}} {{-- @php--}} {{-- $oacs_sequence++;--}} {{-- @endphp--}} {{-- @endif--}} {{-- @if($offs_qtr1->ch_id == 4)--}} {{-- OTHERS-{{ sprintf('%03d',$others_sequence + 1) }}--}} {{-- @php--}} {{-- $others_sequence++;--}} {{-- @endphp--}} {{-- @endif--}} {{ substr($offs_qtr1->category, 0, 4).sprintf('%03d',$offs_sequence + 1)}} @php $offs_sequence++; @endphp {{ $offs_qtr1->category }} {{ $offs_qtr1->fund_source }} {{-- @if($offs_qtr1->mop_id == 1)--}} {{-- CB--}} {{-- @endif--}} {{-- @if($offs_qtr1->mop_id == 2)--}} {{-- NP-SVP--}} {{-- @endif--}} {{-- @if($offs_qtr1->mop_id == 3)--}} {{-- DC--}} {{-- @endif--}} {{-- @if($offs_qtr1->mop_id == 5)--}} {{-- Not Assigned--}} {{-- @endif--}} {{ $offs_qtr1->mop }} 4th Quarter GoP {{-- P {{ number_format($offs_qtr1->ttotal, 2) }}--}} @php $total = $offs_qtr1->ttotal @endphp P {{ number_format($total, 2) }} P {{ number_format($total, 2) }}
Total P {{ number_format( $totaloffs1, 2) }}
Infrastructure
{{ $cw_item->project_code }} {{ $cw_item->fund_source }} {{ $cw_item->mode }} 1st Quarter GoP P {{ number_format($cw_item->total_cost, 2) }} P {{ number_format($cw_item->total_cost, 2) }}
Total P {{ number_format( array_sum($infra_total), 2) }}
Grand Total P {{ number_format( array_sum($grand_total), 2) }}
PREPARED BY: ________________________
  {{strtoupper($data['prepared_by'])}}
Member, BAC Secretariat
APPROVED: _______________________
  {{ strtoupper($data['president']->president) }}
President
RECOMMENDING APPROVAL: _______________________
  {{strtoupper($data['bac_chairman'])}}
Unit Head/Project Leader
{{--
BAC
--}} {{--
PResident
--}} {{--
BAC Chair
--}}
{{----}} {{--
Page {PAGENO} of {nbpg}
--}} {{----}} {{--
--}} {{--
--}} {{--
--}} {{--
--}} {{--
--}} {{--
--}} {{--
--}} {{-- --}} {{-- --}} {{-- --}} {{-- --}} {{-- --}} {{-- --}} {{-- --}} {{-- --}} {{--
--}} {{-- --}} {{-- --}} {{-- --}} {{-- --}} {{-- --}} {{-- --}} {{-- --}} {{-- --}} {{-- --}} {{--
PREPARED BY:________________________
 TONI MARC DARGANTES
--}} {{-- Member, BAC Secretariat--}} {{--
--}} {{-- 		--}} {{-- --}} {{-- --}} {{-- --}} {{-- --}} {{-- --}} {{-- --}} {{-- --}} {{-- --}} {{--
APPROVED:_______________________
 {{ strtoupper($data['president']->president) }}
President--}} {{-- --}}{{-- ?>
--}} {{--
--}} {{--
--}} {{-- --}} {{-- --}} {{-- --}} {{-- --}} {{-- --}} {{-- --}} {{-- --}} {{-- --}} {{-- --}} {{-- --}} {{--
RECOMMENDING APPROVAL:_______________________
 --}} {{-- DILBERTO O. FERRAREN
Unit Head/Project Leader--}} {{--
--}} {{--
--}} {{--
--}}