category_rights_visible.inc.php

Go to the documentation of this file.

<?php

$aColumns = array( 'container1' => array(    // field , table,  visible, multilanguage, ident
                                        array( 'oxtitle',  'oxgroups', 1, 0, 0 ),
                                        array( 'oxid',     'oxgroups', 0, 0, 0 ),
                                        array( 'oxrrid',   'oxgroups', 0, 0, 1 ),
                                        ),
                     'container2' => array(
                                        array( 'oxtitle',  'oxgroups', 1, 0, 0 ),
                                        array( 'oxid',     'oxgroups', 0, 0, 0 ),
                                        array( 'oxrrid',   'oxgroups', 0, 0, 1 ),
                                        )
                    );
class ajaxComponent extends ajaxListComponent
{
    protected function _getQuery()
    {
        $sRRId = null;
        $iAction = 1;

        // looking for table/view
        $sGroupTable = getViewName('oxgroups');

        $sCatId      = oxConfig::getParameter( 'oxid' );
        $sSynchCatId = oxConfig::getParameter( 'synchoxid' );

        // category selected or not ?
        if ( !$sCatId) {
            $sQAdd  = " from $sGroupTable where 1 ";
        } else {
            // fetching category RR view index
            $sQAdd   = " from $sGroupTable, oxobjectrights where ";
            $sQAdd  .= " oxobjectrights.oxobjectid = '$sCatId' and ";
            $sQAdd  .= " oxobjectrights.oxoffset = ($sGroupTable.oxrrid div 31) and ";
            $sQAdd  .= " oxobjectrights.oxgroupidx & (1 << ($sGroupTable.oxrrid mod 31)) and oxobjectrights.oxaction = $iAction ";
        }

        if ( $sSynchCatId && $sSynchCatId != $sCatId) {
            $sQAdd   = " from $sGroupTable left join oxobjectrights on ";
            $sQAdd  .= " oxobjectrights.oxoffset = ($sGroupTable.oxrrid div 31) and ";
            $sQAdd  .= " oxobjectrights.oxgroupidx & (1 << ($sGroupTable.oxrrid mod 31)) and oxobjectrights.oxobjectid='$sSynchCatId' and oxobjectrights.oxaction = $iAction ";
            $sQAdd  .= " where oxobjectrights.oxobjectid != '$sSynchCatId' or (oxobjectid is null)";
        }

        return $sQAdd;
    }

    public function removegroupfromcatview()
    {
        $myConfig = $this->getConfig();

        $iRange  = oxConfig::getParameter( 'oxrrapplyrange');

        $aGroups = $this->_getActionIds( 'oxgroups.oxrrid' );
        $soxId   = oxConfig::getParameter( 'oxid');

        $iAction = 1;

        // removing all
        if ( oxConfig::getParameter( 'all' ) ) {
            $sGroupTable = getViewName('oxgroups');
            $aGroups = $this->_getAll( $this->_addFilter( "select $sGroupTable.oxrrid ".$this->_getQuery() ) );
        }

        if ( $soxId != "-1" && isset( $soxId) && is_array($aGroups) && count($aGroups) ) {
            $aIndexes = array();
            foreach ($aGroups as $iRRIdx) {
                $iOffset = ( int ) ( $iRRIdx / 31 );
                $iBitMap = 1 << ( $iRRIdx % 31 );

                // summing indexes
                if ( !isset( $aIndexes[ $iOffset ] ) )
                    $aIndexes[ $iOffset ] = $iBitMap;
                else
                    $aIndexes[ $iOffset ] = $aIndexes [ $iOffset ] | $iBitMap;
            }

            $oCat = oxNew( "oxcategory" );
            $oCat->load( $soxId);

            $sShopID  = $myConfig->getShopID();
            $iShopBit = oxUtils::getInstance()->getShopBit($sShopID);

            $sO2CView = getViewName('oxobject2category');

            // iterating through indexes and applying to (sub)categories R&R
            foreach ( $aIndexes as $iOffset => $sIdx ) {
                // processing category
                $sQ  = "update oxobjectrights set oxgroupidx = oxgroupidx & ~$sIdx where oxobjectid = '$soxId' and oxoffset = $iOffset and oxaction = $iAction ";
                oxDb::getDb()->Execute( $sQ );

                // processing articles
                $sQ  = "update oxobjectrights set oxgroupidx = oxgroupidx & ~$sIdx where oxaction = $iAction and oxoffset = $iOffset and oxobjectid in ( ";
                $sQ .= "select oxobject2category.oxobjectid from $sO2CView as oxobject2category where oxobject2category.oxcatnid='$soxId' ) ";
                oxDb::getDb()->Execute( $sQ );

                if ($iRange) {
                    // processing subcategories
                    $sQ  = "update oxobjectrights, oxcategories set oxobjectrights.oxgroupidx = oxobjectrights.oxgroupidx & ~$sIdx where oxobjectrights.oxoffset = $iOffset and oxobjectrights.oxaction = $iAction ";
                    $sQ .= "and oxobjectrights.oxobjectid = oxcategories.oxid and ";
                    $sQ .= "( ( oxcategories.oxshopincl & $iShopBit ) > 0 and ( oxcategories.oxshopexcl & $iShopBit ) = 0 ) and ";
                    $sQ .= "oxcategories.oxleft > ".$oCat->oxcategories__oxleft->value." and oxcategories.oxright < ".$oCat->oxcategories__oxright->value." and ";
                    $sQ .= "oxcategories.oxrootid='".$oCat->oxcategories__oxrootid->value."' ";
                    oxDb::getDb()->Execute( $sQ );

                    // processing articles
                    $sQ  = "update oxobjectrights set oxobjectrights.oxgroupidx = oxobjectrights.oxgroupidx & ~$sIdx ";
                    $sQ .= "where oxobjectrights.oxaction = $iAction and oxobjectrights.oxobjectid in ( ";
                    $sQ .= "select oxobject2category.oxobjectid from $sO2CView oxobject2category ";
                    $sQ .= "left join oxcategories on oxcategories.oxid = oxobject2category.oxcatnid ";
                    $sQ .= "where ( ( oxcategories.oxshopincl & $iShopBit ) > 0 and ( oxcategories.oxshopexcl & $iShopBit ) = 0 ) and ";
                    $sQ .= "oxcategories.oxrootid = '".$oCat->oxcategories__oxrootid->value."' and ";
                    $sQ .= "oxcategories.oxleft > ".$oCat->oxcategories__oxleft->value." and ";
                    $sQ .= "oxcategories.oxright < ".$oCat->oxcategories__oxright->value." ";
                    $sQ .= ") ";
                    oxDb::getDb()->Execute( $sQ );
                }
            }

            // removing cleared
            $sQ = "delete from oxobjectrights where oxgroupidx = 0";
            oxDb::getDb()->Execute( $sQ );
        }
    }

    public function addgrouptocatview()
    {
        $myConfig = $this->getConfig();

        $aGroups = $this->_getActionIds( 'oxgroups.oxrrid' );
        $soxId   = oxConfig::getParameter( 'synchoxid' );

        $iRange  = oxConfig::getParameter( 'oxrrapplyrange' );
        $iAction = 1;

        // adding
        if ( oxConfig::getParameter( 'all' ) ) {
            $sGroupTable = getViewName('oxgroups');
            $aGroups = $this->_getAll( $this->_addFilter( "select $sGroupTable.oxrrid ".$this->_getQuery() ) );
        }

        if ( $soxId != "-1" && isset( $soxId) && is_array($aGroups) && count($aGroups)) {
            $aIndexes = array();
            foreach ($aGroups as $iRRIdx) {
                $iOffset = ( int ) ( $iRRIdx / 31 );
                $iBitMap = 1 << ( $iRRIdx % 31 );

                // summing indexes
                if ( !isset( $aIndexes[ $iOffset ] ) )
                    $aIndexes[ $iOffset ] = $iBitMap;
                else
                    $aIndexes[ $iOffset ] = $aIndexes [ $iOffset ] | $iBitMap;
            }

            $oCat = oxNew( "oxcategory" );
            $oCat->load( $soxId);

            $sShopID  = $myConfig->getShopID();
            //$iShopBit = pow( 2, ( $sShopID - 1 ) );
            $iShopBit = oxUtils::getInstance()->getShopBit($sShopID);
            $sO2CView = getViewName('oxobject2category');

            // iterating through indexes and applying to (sub)categories R&R
            foreach ( $aIndexes as $iOffset => $sIdx ) {
                // processing category
                $sQ  = "insert into oxobjectrights (oxid, oxobjectid, oxgroupidx, oxoffset, oxaction) ";
                $sQ .= "values ('".oxUtilsObject::getInstance()->generateUID()."', '$soxId', $sIdx, $iOffset,  $iAction ) on duplicate key update oxgroupidx = (oxgroupidx | $sIdx ) ";
                oxDb::getDb()->Execute( $sQ );

                $sQ  = "insert into oxobjectrights (oxid, oxobjectid, oxgroupidx, oxoffset, oxaction) ";
                $sQ .= "select md5( concat( a.oxobjectid, oxobject2category.oxid) ), oxobject2category.oxobjectid, a.oxgroupidx, a.oxoffset, a.oxaction ";
                $sQ .= "from $sO2CView as oxobject2category left join oxobjectrights a on oxobject2category.oxcatnid=a.oxobjectid where oxobject2category.oxcatnid='$soxId' and a.oxaction = $iAction ";
                $sQ .= "on duplicate key update oxobjectrights.oxgroupidx = (oxobjectrights.oxgroupidx | a.oxgroupidx ) ";
                oxDb::getDb()->Execute( $sQ );

                if ( $iRange ) {
                    // processing subcategories
                    $sQ  = "insert into oxobjectrights (oxid, oxobjectid, oxgroupidx, oxoffset, oxaction) ";
                    $sQ .= "select '".oxUtilsObject::getInstance()->generateUID()."', oxcategories.oxid, $sIdx, $iOffset, $iAction from oxcategories ";
                    $sQ .= "where ( ( oxcategories.oxshopincl & $iShopBit ) > 0 and ( oxcategories.oxshopexcl & $iShopBit ) = 0 ) and ";
                    $sQ .= "oxcategories.oxleft > ".$oCat->oxcategories__oxleft->value." and oxcategories.oxright < ".$oCat->oxcategories__oxright->value." and ";
                    $sQ .= "oxcategories.oxrootid='".$oCat->oxcategories__oxrootid->value."' ";
                    $sQ .= "on duplicate key update oxgroupidx = (oxgroupidx | $sIdx ) ";
                    oxDb::getDb()->Execute( $sQ );

                    // processing articles
                    $sQ  = "insert into oxobjectrights (oxid, oxobjectid, oxgroupidx, oxoffset, oxaction) ";
                    $sQ .= "select md5( concat( a.oxobjectid, oxobject2category.oxid, a.oxaction, a.oxoffset) ), oxobject2category.oxobjectid, a.oxgroupidx, a.oxoffset, a.oxaction ";
                    $sQ .= "from $sO2CView as oxobject2category ";
                    $sQ .= "left join oxcategories on oxcategories.oxid = oxobject2category.oxcatnid ";
                    $sQ .= "left join oxobjectrights a on a.oxobjectid = '$soxId' ";
                    $sQ .= "where ( ( oxcategories.oxshopincl & $iShopBit ) > 0 and ( oxcategories.oxshopexcl & $iShopBit ) = 0 ) and ";
                    $sQ .= "oxcategories.oxrootid = '".$oCat->oxcategories__oxrootid->value."' and ";
                    $sQ .= "oxcategories.oxleft > ".$oCat->oxcategories__oxleft->value." and  ";
                    $sQ .= "oxcategories.oxright < ".$oCat->oxcategories__oxright->value." and a.oxaction = $iAction ";
                    $sQ .= "on duplicate key update oxobjectrights.oxgroupidx = (oxobjectrights.oxgroupidx | a.oxgroupidx )";
                    oxDb::getDb()->Execute( $sQ );
                }
            }
        }
    }
}

---