source/Application/Controller/Admin/CategoryMainAjax.php
protected function _updateOxTime($sProdIds)
    {
        if ($sProdIds) {
            $sO2CView = $this->_getViewName('oxobject2category');
            $sSqlShopFilter = $this->getUpdateOxTimeQueryShopFilter();
            $sSqlWhereShopFilter = $this->getUpdateOxTimeSqlWhereFilter();
            $sQ = "update oxobject2category set oxtime = 0 where oxid in (
                      select _tmp.oxid from (
                          select oxobject2category.oxid from (
                              select min(oxtime) as oxtime, oxobjectid from {$sO2CView}
                              where oxobjectid in ( {$sProdIds} ) {$sSqlShopFilter} group by oxobjectid
                          ) as _subtmp
                          left join oxobject2category on oxobject2category.oxtime = _subtmp.oxtime
                           and oxobject2category.oxobjectid = _subtmp.oxobjectid
                           {$sSqlWhereShopFilter}
                      ) as _tmp
                   ) {$sSqlShopFilter}";

            \OxidEsales\Eshop\Core\DatabaseProvider::getDb()->execute($sQ);
        }
    }
protected function _updateOxTime($sProdIds)
    {
        if ($sProdIds) {
            $sO2CView = $this->_getViewName('oxobject2category');
            $sSqlShopFilter = $this->getUpdateOxTimeQueryShopFilter();
            $sSqlWhereShopFilter = $this->getUpdateOxTimeSqlWhereFilter();
            $sQ = "update oxobject2category set oxtime = 0 where oxid in (
                      select _tmp.oxid from (
                          select oxobject2category.oxid from (
                              select min(oxtime) as oxtime, oxobjectid from {$sO2CView}
                              where oxobjectid in ( {$sProdIds} ) {$sSqlShopFilter} group by oxobjectid
                          ) as _subtmp
                          left join oxobject2category on oxobject2category.oxtime = _subtmp.oxtime
                           and oxobject2category.oxobjectid = _subtmp.oxobjectid
                           {$sSqlWhereShopFilter}
                      ) as _tmp
                   ) {$sSqlShopFilter}";

            \OxidEsales\Eshop\Core\DatabaseProvider::getDb()->execute($sQ);
        }
    }
protected function _updateOxTime ( $ sProdIds ) { if ( $ sProdIds ) { $ sO2CView = $ this -> _getViewName ( 'oxobject2category' ) ; $ sSqlShopFilter = $ this -> getUpdateOxTimeQueryShopFilter ( ) ; $ sSqlWhereShopFilter = $ this -> getUpdateOxTimeSqlWhereFilter ( ) ; $ sQ = "update oxobject2category set oxtime = 0 where oxid in (
                      select _tmp.oxid from (
                          select oxobject2category.oxid from (
                              select min(oxtime) as oxtime, oxobjectid from {$sO2CView}
                              where oxobjectid in ( {$sProdIds} ) {$sSqlShopFilter} group by oxobjectid
                          ) as _subtmp
                          left join oxobject2category on oxobject2category.oxtime = _subtmp.oxtime
                           and oxobject2category.oxobjectid = _subtmp.oxobjectid
                           {$sSqlWhereShopFilter}
                      ) as _tmp
                   ) {$sSqlShopFilter}" ; \ OxidEsales \ Eshop \ Core \ DatabaseProvider :: getDb ( ) -> execute ( $ sQ ) ; } }
Updates oxtime value for products

@param string $sProdIds product ids: "id1", "id2", "id3"
Updates oxtime value for products