alrahma_sunday_school/app/Services/Parents/ParentPaymentService.php

<?php

namespace App\Services\Parents;

use CodeIgniter\Database\BaseConnection;

class ParentPaymentService
{
    public function __construct(private readonly BaseConnection $db)
    {
    }

    public function invoicesForParent(int $parentId, bool $includeRegisteredKids = false): array
    {
        if ($parentId <= 0) {
            return [];
        }

        $select = $includeRegisteredKids ? 'invoices.*, registeredKids' : '*';

        return $this->db->table('invoices')
            ->select($select)
            ->where('parent_id', $parentId)
            ->get()
            ->getResultArray();
    }

    public function markTuitionPaidForParent(int $parentId): void
    {
        if ($parentId <= 0) {
            return;
        }

        $this->db->table('students')
            ->where('parent_id', $parentId)
            ->update(['tuition_paid' => 1]);
    }
}