selectlist_order.inc.php

Go to the documentation of this file.

<?php

$aColumns = array( 'container1' => array(
                                        array( 'oxtitle',   'oxselectlist', 1, 1, 0 ),
                                        array( 'oxsort',    'oxobject2selectlist', 1, 0, 0 ),
                                        array( 'oxident',   'oxselectlist', 0, 0, 0 ),
                                        array( 'oxvaldesc', 'oxselectlist', 0, 0, 0 ),
                                        array( 'oxid',      'oxobject2selectlist', 0, 0, 1 )
                                        )
                                    );
class ajaxComponent extends ajaxListComponent
{
    protected function _getQuery()
    {
        $sSelTable = getViewName('oxselectlist');
        $sArtId    = oxConfig::getParameter( 'oxid' );

        $sQAdd = " from $sSelTable left join oxobject2selectlist on oxobject2selectlist.oxselnid = $sSelTable.oxid where oxobjectid = '$sArtId' ";

        return $sQAdd;
    }

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

    public function setSorting()
    {
        $sSelId  = oxConfig::getParameter( 'oxid' );
        $sSelect = "select * from oxobject2selectlist where oxobjectid='$sSelId' order by oxsort";

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

        // fixing indexes
        $iSelCnt = 0;
        $aIdx2Id = array();
        foreach ( $oList as $sKey => $oSel ) {

            if ( $oSel->oxobject2selectlist__oxsort->value != $iSelCnt ) {
                $oSel->oxobject2selectlist__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->oxobject2selectlist__oxsort->value;
                $oDir1->oxobject2selectlist__oxsort->setValue($oDir2->oxobject2selectlist__oxsort->value);
                $oDir2->oxobject2selectlist__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 ) );
    }
}