article_selection.inc.php

Go to the documentation of this file.

<?php

$aColumns = array( 'container1' => array(    // field , table,         visible, multilanguage, ident
                                        array( 'oxtitle',   'oxselectlist', 1, 1, 0 ),
                                        array( 'oxident',   'oxselectlist', 1, 0, 0 ),
                                        array( 'oxvaldesc', 'oxselectlist', 1, 0, 0 ),
                                        array( 'oxid',      'oxselectlist', 0, 0, 1 )
                                        ),
                     'container2' => array(
                                        array( 'oxtitle',   'oxselectlist', 1, 1, 0 ),
                                        array( 'oxident',   'oxselectlist', 1, 0, 0 ),
                                        array( 'oxvaldesc', 'oxselectlist', 1, 0, 0 ),
                                        array( 'oxid',      'oxobject2selectlist', 0, 0, 1 )
                                        )
                    );
class ajaxComponent extends ajaxListComponent
{
    protected function _getQuery()
    {
        $sSLViewName = getViewName('oxselectlist');

        $sArtId      = oxConfig::getParameter( 'oxid' );
        $sSynchArtId = oxConfig::getParameter( 'synchoxid' );

        if ( $sArtId ) {
            // all categories article is in
            $sQAdd  = " from oxobject2selectlist left join $sSLViewName on $sSLViewName.oxid=oxobject2selectlist.oxselnid ";
            $sQAdd .= " where oxobject2selectlist.oxobjectid = '$sArtId' ";
        } else {
            $sQAdd  = " from $sSLViewName  where $sSLViewName.oxid not in ( select oxobject2selectlist.oxselnid from oxobject2selectlist left join $sSLViewName on $sSLViewName.oxid=oxobject2selectlist.oxselnid ";
            $sQAdd .= " where oxobject2selectlist.oxobjectid = '$sSynchArtId' ) ";
        }

        return $sQAdd;
    }

    public function removesel()
    {
        $aChosenArt = $this->_getActionIds( 'oxobject2selectlist.oxid' );
        if ( oxConfig::getParameter( 'all' ) ) {

            $sQ = $this->_addFilter( "delete oxobject2selectlist.* ".$this->_getQuery() );
            oxDb::getDb()->Execute( $sQ );

        } elseif ( is_array( $aChosenArt ) ) {
            $sQ = "delete from oxobject2selectlist where oxobject2selectlist.oxid in ('" . implode( "', '", $aChosenArt ) . "') ";
            oxDb::getDb()->Execute( $sQ );
        }
    }

    public function addsel()
    {
        $aAddSel = $this->_getActionIds( 'oxselectlist.oxid' );
        $soxId   = oxConfig::getParameter( 'synchoxid');

        // adding
        if ( oxConfig::getParameter( 'all' ) ) {
            $sSLViewName = getViewName('oxselectlist');
            $aAddSel = $this->_getAll( $this->_addFilter( "select $sSLViewName.oxid ".$this->_getQuery() ) );
        }

        if ( $soxId && $soxId != "-1" && is_array( $aAddSel ) ) {
            foreach ($aAddSel as $sAdd) {
                $oNew = oxNew( "oxbase" );
                $oNew->init( "oxobject2selectlist" );
                $oNew->oxobject2selectlist__oxobjectid = new oxField($soxId);
                $oNew->oxobject2selectlist__oxselnid   = new oxField($sAdd);
                $oNew->save();
            }
        }
    }
}

---