编辑文件 - Permissao.php

✏️ 正在编辑: Permissao.php

路径: /srv/systems_dir/yuppiecred-lidernegocios/application/models/DbTable/Permissao.php
提示: 您可以编辑任何文件（包括二进制文件），但请注意不当修改可能导致文件损坏。

<?php

class Model_DbTable_Permissao extends Core_DbTable
{

protected $_primary = 'id';
    protected $_name = 'tb_permissoes';
    
    public function getPermissoesGrupoUsuario($grupoId)
    {
        $select = $this->select()->setIntegrityCheck(false)
                ->from(array('p' => 'tb_permissoes'))
                ->joinLeft(array('t' => 'tb_resources'), 't.id = p.resource_id')
                ->where('p.grupo_id = ?', $grupoId)
                ->where('p.excluido <> 1');
        $perms = $this->getAdapter()->fetchAll($select);
        
        $permissoes = array();
        if ($perms) {
            foreach($perms as $perm) {
                if (!isset($permissoes[$perm['allow']][$perm['resource']])) {
                    $permissoes[$perm['allow']][$perm['resource']] = array();
                }
                if ($perm['privilege']) {
                    $permissoes[$perm['allow']][$perm['resource']][] = $perm['privilege'];
                }
            }
        }
        
        return $permissoes;
    }
    
    public function getPermissaoByResourceAndGrupo($resource, $grupo){
        $select = $this->select()->setIntegrityCheck(false)
                ->from(array('p' => 'tb_permissoes'))
                ->joinInner(array('r' => 'tb_resources'), "r.id = p.resource_id")
                ->joinInner(array('gu' => 'tb_grupos_usuarios'), "gu.id = p.grupo_id")
                ->where("gu.nome LIKE '$grupo'")
                ->where("r.resource LIKE '$resource'");
        
        return $this->getAdapter()->fetchRow($select);
        
    }
}

← 返回文件管理器