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    = oxConfig::getParameter( '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  = oxConfig::getParameter( '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( oxConfig::getParameter( 'sortoxid' ), $aIdx2Id ) ) !== false ) {
            $iDir = (oxConfig::getParameter( '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 ) );
    }
}