article_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()
    {
        $sGroupTable = getViewName('oxgroups');

        $sRRId = null;
        $iAction = 1;

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

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

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

        return $sQAdd;
    }

    public function removegroupfromview()
    {
        $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;
            }

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

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

    public function addgrouptoview()
    {
        $aGroups = $this->_getActionIds( 'oxgroups.oxrrid' );
        $soxId   = oxConfig::getParameter( 'synchoxid');
        $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;
            }

            // 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 );
            }
        }
    }
}

---