article_selection_ajax.php

Go to the documentation of this file.

<?php

class article_selection_ajax extends ajaxListComponent
{
    protected $_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 )
                                        )
                                );

    protected function _getQuery()
    {
        $sSLViewName  = $this->_getViewName('oxselectlist');
        $sArtViewName = $this->_getViewName('oxarticles');
        $oDb          = oxDb::getDb();

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

        $sOxid = ( $sArtId ) ? $sArtId : $sSynchArtId;
        $sQ = "select oxparentid from $sArtViewName where oxid = " . $oDb->quote( $sOxid ) . " and oxparentid != '' ";
        $sQ .= "and (select count(oxobjectid) from oxobject2selectlist where oxobjectid = " . $oDb->quote( $sOxid ) . ") = 0";
        $sParentId = oxDb::getDb()->getOne( $sQ, false, false );

        // all selectlists article is in
        $sQAdd  = " from oxobject2selectlist left join $sSLViewName on $sSLViewName.oxid=oxobject2selectlist.oxselnid ";
        $sQAdd .= " where oxobject2selectlist.oxobjectid = " . $oDb->quote( $sOxid ) . " ";
        if ( $sParentId ) {
            $sQAdd .= "or oxobject2selectlist.oxobjectid = " . $oDb->quote( $sParentId ) . " ";
        }
        // all not assigned selectlists
        if ( $sSynchArtId ) {
            $sQAdd  = " from $sSLViewName  where $sSLViewName.oxid not in ( select oxobject2selectlist.oxselnid $sQAdd ) ";
        }

        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( ", ", oxDb::getInstance()->quoteArray( $aChosenArt ) ) . ") ";
            oxDb::getDb()->Execute( $sQ );
        }

    }

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

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

        if ( $soxId && $soxId != "-1" && is_array( $aAddSel ) ) {
            $oDb = oxDb::getDb();
            foreach ($aAddSel as $sAdd) {
                $oNew = oxNew( "oxbase" );
                $oNew->init( "oxobject2selectlist" );
                $oNew->oxobject2selectlist__oxobjectid = new oxField($soxId);
                $oNew->oxobject2selectlist__oxselnid   = new oxField($sAdd);
                $oNew->oxobject2selectlist__oxsort     = new oxField( ( int ) $oDb->getOne( "select max(oxsort) + 1 from oxobject2selectlist where oxobjectid =  " . $oDb->quote( $soxId ) . " ", false, false ) );
                $oNew->save();
            }

        }
    }
}