attribute_order_ajax.php

Go to the documentation of this file.

<?php

class attribute_order_ajax extends ajaxListComponent
{

    protected $_aColumns = array('container1' => array(
        array('oxtitle', 'oxattribute', 1, 1, 0),
        array('oxsort', 'oxcategory2attribute', 1, 0, 0),
        array('oxid', 'oxcategory2attribute', 0, 0, 1)
    )
    );

    protected function _getQuery()
    {
        $sSelTable = $this->_getViewName('oxattribute');
        $sArtId = oxRegistry::getConfig()->getRequestParameter('oxid');

        $sQAdd = " from $sSelTable left join oxcategory2attribute on oxcategory2attribute.oxattrid = $sSelTable.oxid " .
                 "where oxobjectid = " . oxDb::getDb()->quote($sArtId) . " ";

        return $sQAdd;
    }

    protected function _getSorting()
    {
        return 'order by oxcategory2attribute.oxsort ';
    }

    public function setSorting()
    {
        $sSelId = oxRegistry::getConfig()->getRequestParameter('oxid');
        $sSelect = "select * from oxcategory2attribute where oxobjectid= " . oxDb::getDb()->quote($sSelId) . " order by oxsort";

        $oList = oxNew("oxlist");
        $oList->init("oxbase", "oxcategory2attribute");
        $oList->selectString($sSelect);

        // fixing indexes
        $iSelCnt = 0;
        $aIdx2Id = array();
        foreach ($oList as $sKey => $oSel) {
            if ($oSel->oxcategory2attribute__oxsort->value != $iSelCnt) {
                $oSel->oxcategory2attribute__oxsort->setValue($iSelCnt);
                // saving new index
                $oSel->save();
            }
            $aIdx2Id[$iSelCnt] = $sKey;
            $iSelCnt++;
        }
        //
        if (($iKey = array_search(oxRegistry::getConfig()->getRequestParameter('sortoxid'), $aIdx2Id)) !== false) {
            $iDir = (oxRegistry::getConfig()->getRequestParameter('direction') == 'up') ? ($iKey - 1) : ($iKey + 1);
            if (isset($aIdx2Id[$iDir])) {
                // exchanging indexes
                $oDir1 = $oList->offsetGet($aIdx2Id[$iDir]);
                $oDir2 = $oList->offsetGet($aIdx2Id[$iKey]);

                $iCopy = $oDir1->oxcategory2attribute__oxsort->value;
                $oDir1->oxcategory2attribute__oxsort->setValue($oDir2->oxcategory2attribute__oxsort->value);
                $oDir2->oxcategory2attribute__oxsort->setValue($iCopy);
                $oDir1->save();
                $oDir2->save();
            }
        }

        $sQAdd = $this->_getQuery();

        $sQ = 'select ' . $this->_getQueryCols() . $sQAdd;
        $sCountQ = 'select count( * ) ' . $sQAdd;

        $this->_outputResponse($this->_getData($sCountQ, $sQ));
    }
}