mambax7 / references

     * @param integer  $currentOrder L'ordre de l'élément courant à remonter

     * @return void

     */

    public function moveUp($currentId, $currentOrder)

    {

        $sql_plus = 'SELECT article_id FROM ' . $this->table . ' WHERE article_weight = ' . ((int)$currentOrder - 1);

        $res_plus = $this->db->query($sql_plus);

        if ($this->db->getRowsNum($res_plus) == 0) {

            return;

        }

        $row_plus = $this->db->fetchArray($res_plus);

        $upd1 = 'UPDATE ' . $this->table . ' SET article_weight = (article_weight + 1) WHERE article_id = ' . $row_plus['article_id'];

        $this->db->queryF($upd1);

        $upd2 = 'UPDATE ' . $this->table . ' SET article_weight = (article_weight - 1) WHERE article_id = ' . (int)$currentId;

        $this->db->queryF($upd2);

        $this->forceCacheClean();

    }

    /**

     * Descend un article d'un cran dans l'ordre global des articles

     * @param integer  $currentOrder L'orde de l'élément courant à remonter

     * @return void

     */

    public function moveDown($currentId, $currentOrder)

    {

        $sql_moins = 'SELECT article_id FROM ' . $this->table . ' WHERE article_weight = ' . ((int)$currentOrder + 1);

        $res_moins = $this->db->query($sql_moins);

        if ($this->db->getRowsNum($res_moins) == 0) {

            return;

        }

        $row_moins = $this->db->fetchArray($res_moins);

        $upd1      = 'UPDATE ' . $this->table . ' SET article_weight = (article_weight - 1) WHERE article_id = ' . $row_moins['article_id'];

        $this->db->queryF($upd1);

        $upd2 = 'UPDATE ' . $this->table . ' SET article_weight =( article_weight + 1) WHERE article_id = ' . (int)$currentId;

        $this->db->queryF($upd2);

        $this->forceCacheClean();

    }

}