roles_fegroups.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()
    {
        // looking for table/view
        $sGroupTable = getViewName('oxgroups');

        $sId      = oxConfig::getParameter( 'oxid' );
        $sSynchId = oxConfig::getParameter( 'synchoxid' );

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

        if ( $sSynchId && $sSynchId != $sId) {
            $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='$sSynchId' and oxobjectrights.oxaction = $iAction ";
            $sQAdd  .= " where oxobjectrights.oxobjectid != '$sSynchId' or (oxobjectid is null) ";
        }

        return $sQAdd;
    }

    public function removegroupfromferoles()
    {
        $aChosenGrp = $this->_getActionIds( 'oxgroups.oxrrid' );
        $soxId      = oxConfig::getParameter( 'oxid');

        $iAction    = 1;

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

        if ( isset( $soxId) && $soxId != "-1" && is_array( $aChosenGrp ) && $aChosenGrp ) {
            $aIndexes = array();
            foreach ($aChosenGrp 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  = "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 addgrouptoferoles()
    {
        $aChosenCat = $this->_getActionIds( 'oxgroups.oxrrid' );
        $soxId      = oxConfig::getParameter( 'synchoxid' );

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

        if ( isset( $soxId) && $soxId != "-1" && isset( $aChosenCat) && $aChosenCat) {
            $aIndexes = array();
            foreach ( $aChosenCat 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 );
            }
        }
    }
}

---