@php $cpAccountGroups = \App\Models\AccountGroup::with('group')->get()->map(function($ag) { $ag->display_name = $ag->a_sub_group_name ? $ag->a_group_name . ' (' . $ag->a_sub_group_name . ')' : $ag->a_group_name; return $ag; }); $cpGroupCategory = []; $cpGroupNature = []; $cpNameHint = []; foreach($cpAccountGroups as $ag) { $combinedName = strtolower(trim($ag->a_group_name . ' ' . ($ag->group->group_name ?? ''))); if (str_contains($combinedName, 'debtor') || str_contains($combinedName, 'creditor')) { $cat = 'party'; } elseif (str_contains($combinedName, 'cash') || str_contains($combinedName, 'bank account')) { $cat = 'cashbank'; } elseif (str_contains($combinedName, 'income') || str_contains($combinedName, 'expense') || str_contains($combinedName, 'sales') || str_contains($combinedName, 'purchase') || str_contains($combinedName, 'tax') || str_contains($combinedName, 'duties')) { $cat = 'income_expense'; } else { $cat = 'simple'; } $cpGroupCategory[$ag->id] = $cat; $cpGroupNature[$ag->id] = $combinedName; $cpNameHint[$ag->id] = $ag->display_name; } $cpGroupedAccounts = $cpAccountGroups->groupBy(function($ag) { $combinedName = strtolower(trim($ag->a_group_name . ' ' . ($ag->group->group_name ?? ''))); $cat = 'simple'; if (str_contains($combinedName, 'debtor') || str_contains($combinedName, 'creditor')) { $cat = 'party'; } elseif (str_contains($combinedName, 'cash') || str_contains($combinedName, 'bank account')) { $cat = 'cashbank'; } elseif (str_contains($combinedName, 'income') || str_contains($combinedName, 'expense') || str_contains($combinedName, 'sales') || str_contains($combinedName, 'purchase') || str_contains($combinedName, 'tax') || str_contains($combinedName, 'duties')) { $cat = 'income_expense'; } if ($cat === 'party') return 'Party Ledgers'; if ($cat === 'cashbank') return 'Cash / Bank Ledgers'; if ($cat === 'income_expense') return 'Income & Expense Ledgers (P&L)'; return 'Balance Sheet Ledgers'; }); $cpState = \App\Models\State::select( \Illuminate\Support\Facades\DB::raw("CONCAT(state_code,'-',state_name) as state_name"), 'id', ) ->pluck('state_name', 'id') ->toArray(); $cpGroups = \Illuminate\Support\Facades\DB::table('groups')->get(); $cpFinancialYearStart = isset($financial_year_start) ? $financial_year_start : date('d-m-Y'); @endphp @push('footer_script') @endpush