article_extend_ajax.php

Go to the documentation of this file.

<?php

class article_extend_ajax extends ajaxListComponent
{
    protected $_aColumns = array( 'container1' => array(    // field , table,         visible, multilanguage, ident
                                        array( 'oxtitle', 'oxcategories', 1, 1, 0 ),
                                        array( 'oxdesc',  'oxcategories', 1, 1, 0 ),
                                        array( 'oxid',    'oxcategories', 0, 0, 0 ),
                                        array( 'oxid',    'oxcategories', 0, 0, 1 )
                                        ),
                                    'container2' => array(
                                        array( 'oxtitle', 'oxcategories', 1, 1, 0 ),
                                        array( 'oxdesc',  'oxcategories', 1, 1, 0 ),
                                        array( 'oxid',    'oxcategories', 0, 0, 0 ),
                                        array( 'oxid',    'oxobject2category', 0, 0, 1 ),
                                        array( 'oxtime',  'oxobject2category', 0, 0, 1 ),
                                        array( 'oxid',    'oxcategories',      0, 0, 1 )
                                        ),
                                );

    protected function _getQuery()
    {
        $sCategoriesTable = $this->_getViewName( 'oxcategories' );
        $sO2CView = $this->_getViewName( 'oxobject2category' );
        $oDb = oxDb::getDb();

        $sOxid      = oxConfig::getParameter( 'oxid' );
        $sSynchOxid = oxConfig::getParameter( 'synchoxid' );

        if ( $sOxid ) {
            // all categories article is in
            $sQAdd  = " from $sO2CView left join $sCategoriesTable on $sCategoriesTable.oxid=$sO2CView.oxcatnid ";
            $sQAdd .= " where $sO2CView.oxobjectid = " . $oDb->quote( $sOxid ) . " and $sCategoriesTable.oxid is not null ";
        } else {
            $sQAdd  = " from $sCategoriesTable where $sCategoriesTable.oxid not in ( ";
            $sQAdd .= " select $sCategoriesTable.oxid from $sO2CView left join $sCategoriesTable on $sCategoriesTable.oxid=$sO2CView.oxcatnid ";
            $sQAdd .= " where $sO2CView.oxobjectid = " . $oDb->quote( $sSynchOxid ) . " and $sCategoriesTable.oxid is not null ) and $sCategoriesTable.oxpriceto = '0'";
        }

        return $sQAdd;
    }

    protected function _getDataFields( $sQ )
    {
        $aDataFields = parent::_getDataFields( $sQ );
        if ( oxConfig::getParameter( 'oxid' ) && is_array( $aDataFields ) && count( $aDataFields ) ) {

            // looking for smallest time value to mark record as main category ..
            $iMinPos = null;
            $iMinVal = null;
            reset( $aDataFields );
            while ( list( $iPos, $aField ) = each( $aDataFields ) ) {

                // already set ?
                if ( $aField['_3'] == '0' ) {
                    $iMinPos = null;
                    break;
                }

                if ( !$iMinVal ) {
                    $iMinVal = $aField['_3'];
                    $iMinPos = $iPos;
                } elseif ( $iMinVal > $aField['_3'] ) {
                    $iMinPos = $iPos;
                }
            }

            // setting primary category
            if ( isset( $iMinPos ) ) {
                $aDataFields[$iMinPos]['_3'] = '0';
            }
        }

        return $aDataFields;
    }

    public function removeCat()
    {
        $myConfig = $this->getConfig();
        $aRemoveCat = $this->_getActionIds( 'oxcategories.oxid' );

        $soxId   = oxConfig::getParameter( 'oxid' );
        $sShopID = $myConfig->getShopId();
        $oDb = oxDb::getDb();

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

        // removing all
        if ( is_array( $aRemoveCat ) && count( $aRemoveCat ) ) {

            $sQ = "delete from oxobject2category where oxobject2category.oxobjectid= " . oxDb::getDb()->quote( $soxId ) . " and ";
            $sQ .= " oxcatnid in (" . implode( ', ', oxDb::getInstance()->quoteArray( $aRemoveCat ) ) . ')';
            $oDb->Execute( $sQ );
            //echo "\n$sQ\n___________________";


            // updating oxtime values
            $this->_updateOxTime( $soxId );
        }

        $this->resetArtSeoUrl( $soxId, $aRemoveCat );
        $this->resetContentCache();

    }

    public function addCat()
    {
        $myConfig = $this->getConfig();
        $oDb      = oxDb::getDb();
        $aAddCat  = $this->_getActionIds( 'oxcategories.oxid' );
        $soxId    = oxConfig::getParameter( 'synchoxid' );
        $sShopID  = $myConfig->getShopId();
        $sO2CView = $this->_getViewName('oxobject2category');

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

        if ( isset( $aAddCat) && is_array($aAddCat)) {

            $oDb = oxDb::getDb();

            $oNew = oxNew( 'oxbase' );
            $oNew->init( 'oxobject2category' );
            $myUtilsObj = oxUtilsObject::getInstance();

            foreach ( $aAddCat as $sAdd ) {

                // check, if it's already in, then don't add it again
                $sSelect = "select 1 from " . $sO2CView . " as oxobject2category where oxobject2category.oxcatnid= " . $oDb->quote( $sAdd ) . " and oxobject2category.oxobjectid = " . $oDb->quote( $soxId ) . " ";
                if ( $oDb->getOne( $sSelect, false, false ) )
                    continue;

                $oNew->setId( $myUtilsObj->generateUID() );
                $oNew->oxobject2category__oxobjectid = new oxField( $soxId );
                $oNew->oxobject2category__oxcatnid   = new oxField( $sAdd );
                $oNew->oxobject2category__oxtime     = new oxField( time() );


                $oNew->save();
            }

            $this->_updateOxTime( $soxId );

            $this->resetArtSeoUrl( $soxId );
            $this->resetContentCache();


        }
    }

    protected function _updateOxTime( $soxId )
    {
        $oDb = oxDb::getDb();
        $sO2CView = $this->_getViewName('oxobject2category');
        $soxId = $oDb->quote( $soxId );

        // updating oxtime values
        $sQ  = "update oxobject2category set oxtime = 0 where oxobjectid = {$soxId} and oxid = (
                    select oxid from (
                        select oxid from {$sO2CView} where oxobjectid = {$soxId} order by oxtime limit 1
                    ) as _tmp
                )";
        $oDb->execute( $sQ );
    }

    public function setAsDefault()
    {
        $myConfig = $this->getConfig();
        $sDefCat  = oxConfig::getParameter( "defcat" );
        $soxId    = oxConfig::getParameter( "oxid" );
        $sShopId  = $myConfig->getShopId();
        $oDb      = oxDb::getDb();

        $sShopCheck = "";

        // #0003650: increment all product references independent to active shop
        $sQ = "update oxobject2category set oxtime = oxtime + 10 where oxobjectid = " . $oDb->quote( $soxId );
        oxDb::getDb()->Execute($sQ);

        // set main category for active shop
        $sQ = "update oxobject2category set oxtime = 0 where oxobjectid = " . $oDb->quote( $soxId ) . " and oxcatnid = " . $oDb->quote( $sDefCat ) . " $sShopCheck ";
        oxDb::getDb()->Execute($sQ);
        //echo "\n$sQ\n";

        // #0003366: invalidate article SEO for all shops
        oxRegistry::get("oxSeoEncoder")->markAsExpired( $soxId, null, 1, null, "oxtype='oxarticle'" );
        $this->resetContentCache();
    }
}