@php
$i = 1;
@endphp
@if (!empty($rate_type))
@foreach ($rate_type as $val)
@php
$ssr_pdf = DB::table('tbl_ssr_pdf')
->select('*')
->where([
'RateType' => $val['rate_type_id'],
'SanctionYear' => $val['year'],
])
->limit(1)
->get()
->toArray();
$str = $val['rate_type_id'] . '_' . $val['year'];
@endphp
@if (count($ssr_pdf) != 0)
@endif
Rate Analysis {{ $val['rate_type'] }}-{{$val['year'] }}
List
@php
// Checking and processing rate item database and selected item strings
$rate_item_db = isset(
$rate_item_db_array[
$val['rate_type_id'] .
'_' .
$val['year']
],
)
? array_unique(
$rate_item_db_array[
$val[
'rate_type_id'
] .
'_' .
$val['year']
],
)
: [];
$rate_item_str = isset(
$rate_selected_item_str[
$val['rate_type_id'] .
'_' .
$val['year']
],
)
? array_unique(
$rate_selected_item_str[
$val[
'rate_type_id'
] .
'_' .
$val['year']
],
)
: [];
$year = explode(
'-',
$val['year'],
);
@endphp
@if (!empty($rate_item_str))
@foreach ($rate_item_str as $strval)
@php
// Perform Eloquent query to get the rate for each RateIndexCode
$rate = \App\Models\DsrBasicRate::where(
'RateIndexCode',
$strval,
)
->where(
'RateFromYear',
$year[0],
)
->where(
'RateToYear',
$year[1],
)
->where(
'RateType',
$val[
'rate_type_id'
],
)
->get(); // Assuming the model is DsrBasicRate and you have it set up
@endphp
@endforeach
@endif
@php
$i++;
@endphp
@endforeach
@endif