@php $index_project = DB::table('tbl_projects_rate_analysis') ->where('ProjectIDRef', $row->ProjectID) ->select('RateIndexCode') ->groupBy('RateIndexCode') ->get(); if(!empty($index_project)){ $index_project=json_decode(json_encode($index_project),true); } $ssr_year = explode('-', $year); @endphp @foreach($index_project as $project) @php $rates = DB::table('tbl_marketing_basic_rates') ->where('RateIndexCode', $project['RateIndexCode']) ->where('ProjectID', $row->ProjectID) ->where('RateFromYear', $ssr_year[0]) ->where('RateToYear', $ssr_year[1]) ->get(); $rate_item_db = array(); foreach ($rate_analysis as $item) { array_push($rate_item_db, $item->DSRItemCodeRef); } @endphp @endforeach