<?php

namespace Modules\Parametrage\Fournisseur\Repository;

use Helpers\QueryBuilder\AbsRepository;
use PDOStatement;

class ParametrageFournisseur extends AbsRepository
{
    /**
     * @return array<mixed>
     */
    public function getDashboardParam()
    {
        $req = "SELECT p.LIB01PARV, r.LIBELLE, p.CODEPARV
            FROM PARAVRAC p WITH (NOLOCK)
                LEFT JOIN REGROUP r WITH (NOLOCK) ON r.CODE_REG = p.LIB01PARV
            WHERE p.TYPEPARV = 'PARAMTDB' AND p.CODEPARV LIKE 'CAT_FOUR_%'
            ORDER BY p.CODEPARV";

        return $this->fetchAssocAll($req, []);
    }
}
