Logi-CE / fmup

     * @param {Array} un tableau de tous les filtres éventuels

     * @param {string} le champ sur lequel ordonner

     **/

    public static function findAllAttributeFromTable($table, $attribute, $where = array(), $options = array())

    {

        $SQL = "SELECT    id\n";

        if ($attribute != 'id') {

            $SQL .= "," . $attribute . "\n";

        }

        $SQL .= "FROM $table ";

        $SQL .= Sql::parseWhere($where);

        if (isset($options["order"]) && $options["order"]) {

            $SQL .= " ORDER BY " . $options["order"];

        }

        if (isset($options["limit"]) && $options["limit"]) {

            $SQL .= " LIMIT " . $options["limit"];

        }

        //echo($SQL);

        // Exécution de la requète

        $db = \Model::getDb();

        $result = $db->fetchAll($SQL);

        return $result;

    }

    public static function findAllAttributeFromLeftJoinTable(

        $table,

        return $result;

    }

    public static function findAllAttributeFromLeftJoinTable(

        $table,

        $left_table,

        $link_table,

        $attribute,

        $where = array(),

        $options = array()

    )

    {

        $SQL = "SELECT $attribute \n";

        $SQL .= " FROM $table  \n LEFT JOIN $left_table  \n";

        $SQL .= " ON $link_table  \n";

        $SQL .= Sql::parseWhere($where);

        if (isset($options["order"]) && $options["order"]) {

            $SQL .= " ORDER BY " . $options["order"] . "  \n";

        }

        if (isset($options["limit"]) && $options["limit"]) {

            $SQL .= " LIMIT " . $options["limit"];

        }

        //debug::output($SQL);

        // Exécution de la requète

        $db = \Model::getDb();

        $result = $db->getIterator($SQL);

        return $result;

    }

    /**