Total Count
{{ $dmc_bus_concession_scheme_count }}
Total Count
{{ $dmc_disability_scheme_total_count }}
@php
$dmc_education_scheme_total_count = DB::table('all_education_scheme_details AS t1')
->leftJoin('users AS t2', 't2.id', '=', 't1.created_by')
->where(function ($query) {
$query->where('t2.category', 1)
->orWhere('t2.category', 2);
})
->whereNull('t1.deleted_at')
->get();
$dmc_pending_count = [];
$dmc_approved_count = [];
$dmc_rejected_count = [];
foreach ($dmc_education_scheme_total_count as $key => $list) {
if($list->dmc_status == 'pending')
{
$dmc_pending_count[] = $list->application_no;
}elseif ($list->dmc_status == 'approved') {
$dmc_approved_count[] = $list->application_no;
}elseif ($list->dmc_status == 'rejected') {
$dmc_rejected_count[] = $list->application_no;
}
}
@endphp
Total Count
{{ count($dmc_education_scheme_total_count) }}
Total Count
{{ $dmc_marriage_scheme_total_count }}