WB 2.11.0

<?php

/**

 * @category        WebsiteBaker

 * @package         WebsiteBaker_core

 * @author          Ryan Djurovich, WebsiteBaker Project, Werner v.d.Decken

 * @copyright       2009-2011, Website Baker Org. e.V.

 * @link            http://websitebaker2.org

 * @license         http://www.gnu.org/licenses/gpl.html

 * @version         $Id: class.order.php 2 2017-07-02 15:14:29Z Manuela $

 * @filesource        $HeadURL: svn://isteam.dynxs.de/wb/2.10.x/branches/main/framework/class.order.php $

 * Ordering class

 * This class will be used to change the order of an item in a table

 * which contains a special order field (type must be integer)

 */

/*******************************************************************************

 * abstract factory for application

 */

/* -------------------------------------------------------- */

// Must include code to stop this file being accessed directly

if(!defined('WB_PATH')) {

    require_once(dirname(__FILE__).'/globalExceptionHandler.php');

    throw new IllegalFileException();

}

/* -------------------------------------------------------- */

    define('ORDERING_CLASS_LOADED', true);

// Load the other required class files if they are not already loaded

    require_once(WB_PATH."/framework/class.database.php");

class order {

    const MOVE_UP   = 0;

    const MOVE_DOWN = 1;

    private $_Table      = '';

    private $_FieldOrder = '';

    private $_FieldId    = '';

    private $_FieldGroup = '';

    private $_DB         = null;

    /**

     * Constructor

     * @param string $Table

     * @param string $FieldOrder

     * @param string $FieldId

     * @param string $FieldGroup

     * use $GLOBALS['database']

     */

    public function __construct($Table, $FieldOrder, $FieldId, $FieldGroup) {

        $this->_DB         = $GLOBALS['database'];

        $this->_Table      = $Table;

        $this->_FieldOrder = $FieldOrder;

        $this->_FieldId    = $FieldId;

        $this->_FieldGroup = $FieldGroup;

    }

    /**

     *

     * @param string|int $id

     * @param int $direction

     * @return bool

     */

    public function move($id, $direction = self::MOVE_UP)

    {

        $retval = false;

        $sql  = 'SELECT `'.$this->_FieldOrder.'` `order`, `'.$this->_FieldGroup.'` `group` ';

        $sql .= 'FROM `'.$this->_Table.'` WHERE `'.$this->_FieldId.'`=\''.$id.'\'';

        // get Position and Group for Element to move

        if(($res1 = $this->_DB->query($sql))) {

            if(($rec1 = $res1->fetchRow())) {

                $sql  = 'SELECT `'.$this->_FieldId.'` `id`, `'.$this->_FieldOrder.'` `order` ';

                $sql .= 'FROM `'.$this->_Table.'` ';

                $sql .= 'WHERE `'.$this->_FieldGroup.'`=\''.$rec1['group'].'\' ';

                if($direction == self::MOVE_UP) {

                    // search for Element with next lower Position

                    $sql .=     'AND `'.$this->_FieldOrder.'`<\''.$rec1['order'].'\' ';

                    $sql .= 'ORDER BY `'.$this->_FieldOrder.'` DESC';

                }else {

                    // search for Element with next higher Position

                    $sql .=     'AND `'.$this->_FieldOrder.'`>\''.$rec1['order'].'\' ';

                    $sql .= 'ORDER BY `'.$this->_FieldOrder.'` ASC';

                }

                // get Id and Position of the Element to change with

                if(($res2 = $this->_DB->query($sql))) {

                    if(($rec2 = $res2->fetchRow())) {

                        $sql  = 'UPDATE `'.$this->_Table.'` ';

                        $sql .= 'SET `'.$this->_FieldOrder.'`=\''.$rec1['order'].'\' ';

                        $sql .= 'WHERE `'.$this->_FieldId.'`=\''.$rec2['id'].'\'';

                        // update Position number of target

                        if($this->_DB->query($sql)) {

                            $sql  = 'UPDATE `'.$this->_Table.'` ';

                            $sql .= 'SET `'.$this->_FieldOrder.'`=\''.$rec2['order'].'\' ';

                            $sql .= 'WHERE `'.$this->_FieldId.'`=\''.$id.'\'';

                            // update Position number source

                            $retval = $this->_DB->query($sql);

                        }

                    }

                }

            }

        }

        return $retval;

    }

    /**

     * Move a row up

     * @param string|int $id

     * @return bool

     */

    public function move_up($id) {

        // Get current order

        return $this->move($id, self::MOVE_UP);

    }

    /**

     * Move a row down

     * @param string|int $id

     * @return bool

     */

    public function move_down($id) {

        // Get current order

        return $this->move($id, self::MOVE_DOWN);

    }

    /**

     * Get next free number for order

     * @param string|int $group

     * @return integer

     */

    public function get_new($group) {

        // Get last order

        $sql  = 'SELECT MAX(`'.$this->_FieldOrder.'`) FROM `'.$this->_Table.'` ';

        $sql .= 'WHERE `'.$this->_FieldGroup.'`=\''.$group.'\' ';

        $max = intval($this->_DB->get_one($sql)) + 1;

        return $max;

    }

    /**

     * Renumbering a group from 1 to n (should be called if a row in the middle has been deleted)

     * @param string|int $group

     * @return bool

     */

    public function clean($group) {

        // Loop through all records and give new order

        $sql  = 'SET @c:=0';

        $this->_DB->query($sql);

        $sql  = 'UPDATE `'.$this->_Table.'` SET `'.$this->_FieldOrder.'`=(SELECT @c:=@c+1) ';

        $sql .= 'WHERE `'.$this->_FieldGroup.'`=\''.$group.'\' ';

        $sql .= 'ORDER BY `'.$this->_FieldOrder.'` ASC;';

        return $this->_DB->query($sql);

    }

} // end of class