FM / Services

/home/alixis5/integrate.sellofinance.com/src/Services/

/home/alixis5/integrate.sellofinance.com/src/Services

Name	Size	Mode	Actions
ApplicationService.php	29094	0644	edit dl rm
AuthService.php	12728	0644	edit dl rm
CatalogAggregator.php	5791	0644	edit dl rm
CustomerBundleLoader.php	3952	0644	edit dl rm
EligibilityEvaluator.php	17603	0644	edit dl rm
GoogleAuthService.php	8285	0644	edit dl rm
MeritRanker.php	6279	0644	edit dl rm
OnboardingService.php	22947	0644	edit dl rm
ProductPolicyLoader.php	3818	0644	edit dl rm
VerificationService.php	3752	0644	edit dl rm

Edit: /home/alixis5/integrate.sellofinance.com/src/Services/ProductPolicyLoader.php (3818B)

<?php

declare(strict_types=1);

namespace Sello\Services;

use Sello\Repositories\EspoApiClient;

/**
 * Loads program + product decision policies (with their rule groups and
 * eligibility rules) for a given product. Extracted from CatalogController
 * so ApplicationService can reuse the exact same shape.
 */
class ProductPolicyLoader
{
    public function __construct(private readonly EspoApiClient $client) {}

/**
     * Load all active CDecisionPolicy rows that apply to this product, along
     * with their rule groups and eligibility rules.
     *
     * @return array<int, array<string, mixed>> nested: policies[].groups[].rules[]
     */
    public function loadForProduct(string $productId): array
    {
        // Find linked programs (reverse m:n via linkedWith, mirrors Phase 2A pattern)
        $programsRes = $this->client->get('CFinancialProgram', [
            'select'  => 'id',
            'maxSize' => 20,
            'where'   => [
                ['type' => 'linkedWith', 'attribute' => 'financialProducts', 'value' => [$productId]],
            ],
        ]);
        $programIds = array_column($programsRes['list'] ?? [], 'id');

// Build where for policies
        $policyWhere = [
            ['type' => 'equals', 'attribute' => 'status', 'value' => 'active'],
            [
                'type'  => 'or',
                'value' => array_values(array_filter([
                    !empty($programIds) ? ['type' => 'in', 'attribute' => 'financialProgramId', 'value' => $programIds] : null,
                    ['type' => 'equals', 'attribute' => 'financialProductId', 'value' => $productId],
                ])),
            ],
        ];

$policiesRes = $this->client->get('CDecisionPolicy', [
            'select'  => 'id,name,policyLevel,overrideAllowed,financialProgramId,financialProductId,status',
            'maxSize' => 50,
            'where'   => $policyWhere,
        ]);
        $policies = $policiesRes['list'] ?? [];
        if (empty($policies)) {
            return [];
        }

// Groups for those policies
        $policyIds = array_column($policies, 'id');
        $groupsRes = $this->client->get('CRuleGroup', [
            'select'  => 'id,decisionPolicyId,logicOperator,status',
            'maxSize' => 200,
            'where'   => [
                ['type' => 'in',     'attribute' => 'decisionPolicyId', 'value' => $policyIds],
                ['type' => 'equals', 'attribute' => 'status',           'value' => 'active'],
            ],
        ]);
        $groupsByPolicy = [];
        foreach ($groupsRes['list'] ?? [] as $g) {
            $groupsByPolicy[$g['decisionPolicyId']][] = $g;
        }

// Rules for those groups
        $groupIds = array_column($groupsRes['list'] ?? [], 'id');
        $rulesByGroup = [];
        if (!empty($groupIds)) {
            $rulesRes = $this->client->get('CEligibilityRule', [
                'select'  => 'id,ruleGroupId,conditionFieldId,operator,value,valueFrom,valueTo,valueList,status',
                'maxSize' => 200,
                'where'   => [
                    ['type' => 'in',     'attribute' => 'ruleGroupId', 'value' => $groupIds],
                    ['type' => 'equals', 'attribute' => 'status',      'value' => 'active'],
                ],
            ]);
            foreach ($rulesRes['list'] ?? [] as $r) {
                $rulesByGroup[$r['ruleGroupId']][] = $r;
            }
        }

// Assemble the nested shape
        foreach ($policies as &$p) {
            $groups = $groupsByPolicy[$p['id']] ?? [];
            foreach ($groups as &$g) {
                $g['rules'] = $rulesByGroup[$g['id']] ?? [];
            }
            unset($g);
            $p['groups'] = $groups;
        }
        unset($p);

return $policies;
    }
}

> nested: policies[].groups[].rules[] */ public function loadForProduct(string $productId): array { // Find linked programs (reverse m:n via linkedWith, mirrors Phase 2A pattern) $programsRes = $this->client->get('CFinancialProgram', [ 'select' => 'id', 'maxSize' => 20, 'where' => [ ['type' => 'linkedWith', 'attribute' => 'financialProducts', 'value' => [$productId]], ], ]); $programIds = array_column($programsRes['list'] ?? [], 'id'); // Build where for policies $policyWhere = [ ['type' => 'equals', 'attribute' => 'status', 'value' => 'active'], [ 'type' => 'or', 'value' => array_values(array_filter([ !empty($programIds) ? ['type' => 'in', 'attribute' => 'financialProgramId', 'value' => $programIds] : null, ['type' => 'equals', 'attribute' => 'financialProductId', 'value' => $productId], ])), ], ]; $policiesRes = $this->client->get('CDecisionPolicy', [ 'select' => 'id,name,policyLevel,overrideAllowed,financialProgramId,financialProductId,status', 'maxSize' => 50, 'where' => $policyWhere, ]); $policies = $policiesRes['list'] ?? []; if (empty($policies)) { return []; } // Groups for those policies $policyIds = array_column($policies, 'id'); $groupsRes = $this->client->get('CRuleGroup', [ 'select' => 'id,decisionPolicyId,logicOperator,status', 'maxSize' => 200, 'where' => [ ['type' => 'in', 'attribute' => 'decisionPolicyId', 'value' => $policyIds], ['type' => 'equals', 'attribute' => 'status', 'value' => 'active'], ], ]); $groupsByPolicy = []; foreach ($groupsRes['list'] ?? [] as $g) { $groupsByPolicy[$g['decisionPolicyId']][] = $g; } // Rules for those groups $groupIds = array_column($groupsRes['list'] ?? [], 'id'); $rulesByGroup = []; if (!empty($groupIds)) { $rulesRes = $this->client->get('CEligibilityRule', [ 'select' => 'id,ruleGroupId,conditionFieldId,operator,value,valueFrom,valueTo,valueList,status', 'maxSize' => 200, 'where' => [ ['type' => 'in', 'attribute' => 'ruleGroupId', 'value' => $groupIds], ['type' => 'equals', 'attribute' => 'status', 'value' => 'active'], ], ]); foreach ($rulesRes['list'] ?? [] as $r) { $rulesByGroup[$r['ruleGroupId']][] = $r; } } // Assemble the nested shape foreach ($policies as &$p) { $groups = $groupsByPolicy[$p['id']] ?? []; foreach ($groups as &$g) { $g['rules'] = $rulesByGroup[$g['id']] ?? []; } unset($g); $p['groups'] = $groups; } unset($p); return $policies; } }