App\Models\ConfigModel::getAllConfig()

Complexity

Conditions	2
Paths	2

Size

Total Lines	22
Code Lines	13

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
    public function getAllConfig():array
    {
        $returnData = [];
        //Grabbing the configs class
        $sql = 'select * from configs_class order by class';
        $this->query($sql);
        $this->execute();
        $configClass = $this->stmt->fetchAll();

        //getting the configurations grouped by class
        $sql = "select idconfigs, configs_name, configs_value from configs where configs_class_idconfigsclass = :classId";
        $this->query($sql);

        foreach ($configClass as $class) {
            //we remove the first 3 characters as they are used for ordering (10_global_site_configuration)
            $className = substr($class->class, 3);

            $this->bind(':classId', $class->idconfigsclass);
            $this->execute();
            $returnData[$className] = $this->stmt->fetchAll();
        }
        return $returnData;
    }
}