public function MenuProfileSystem()
{
$urlSica = rtrim(\Zend_Controller_Front::getInstance()->getParam('bootstrap')->getOption('urlSica'), '/');
$infoSystem = \Core_Integration_Sica_User::getInfoSystem();
$urlHelp = array_key_exists('txUrlHelp', (array) $infoSystem) ? $infoSystem['txUrlHelp'] : '#';
$html = '<ul class="nav pull-right dropdown-perfil">
<li class="divider-vertical visible-desktop"></li>
<li class="dropdown pull-right">
<a data-toggle="dropdown" class="dropdown-toggle" href="#">
<img src="/img/icons/icon-perfil.png">
</a>
<ul class="dropdown-menu">';
$html .= '<li><span>Nome: ' . $this->view->userName() . '</span></li>';
$html .= '<li><span>Perfil: ' . \Core_Integration_Sica_User::getUserNoProfile() . '</span></li>';
if (\Core_Integration_Sica_User::getUserProfileExternal()) {
$linkHelp = '';
$html .= '<li class="divider"></li>';
if (count(\Core_Integration_Sica_User::getUserAllProfile()) > 1) {
$html .= $this->view->usuarioExterno()->optionSelecionarPerfil();
}
$html .= $this->view->usuarioExterno()->optionAlterarCadastro();
} else {
$linkHelp = '<li><a href="' . $urlHelp . '" target="_blank">Ajuda</a></li>';
$html .= $this->view->usuario()->optionUnidadeOrg();
$html .= '<li class="divider"></li>';
if (count(\Core_Integration_Sica_User::getUserAllProfile()) > 1) {
$html .= $this->view->usuario()->optionSelecionarPerfil();
}
}
$html .= '<li><a href="' . $urlSica . '/index/home/change/password">Alterar Senha</a></li>';
$html .= $linkHelp;
$html .= '<li><a href="' . $urlSica . '/usuario/logout">Sair</a></li>';
$html .= '</ul></li><li class="divider-vertical visible-desktop"></li>';
return $html;
}
public function MenuProfileSystem()
{
$infoSystem = Core_Integration_Sica_User::getInfoSystem();
$urlHelp = array_key_exists('txUrlHelp', (array) $infoSystem) ? $infoSystem['txUrlHelp'] : '#';
$html = '<ul class="nav pull-right dropdown-perfil">
<li class="divider-vertical visible-desktop"></li>
<li class="dropdown pull-right">
<a data-toggle="dropdown" class="dropdown-toggle" href="#">
<img src="/assets/img/icons/icon-perfil.png">
</a>
<ul class="dropdown-menu">';
$html .= '<li><span>Nome: ' . $this->view->userName() . '</span></li>';
$html .= '<li><span>Perfil: ' . Core_Integration_Sica_User::getUserNoProfile() . '</span></li>';
if (\Core_Integration_Sica_User::getUserProfileExternal()) {
$linkHelp = '';
$html .= '<li class="divider"></li>';
if (count(\Core_Integration_Sica_User::getUserAllProfile()) > 1) {
$html .= $this->view->usuarioExterno()->optionSelecionarPerfil();
}
$html .= $this->view->usuarioExterno()->optionAlterarCadastro();
} else {
$linkHelp = '<li><a href="' . $urlHelp . '" target="_blank">Ajuda</a></li>';
$html .= $this->view->usuario()->optionUnidadeOrg();
$html .= '<li class="divider"></li>';
if (count(\Core_Integration_Sica_User::getUserAllProfile()) > 1) {
$html .= $this->view->usuario()->optionSelecionarPerfil();
}
}
$html .= '<li><a data-toggle="modal" data-backdrop="static" data-keyboard="false" ' . 'href="#modal-alterar-senha" id="btn-alterar-senha">Alterar Senha</a></li>';
$html .= $linkHelp;
$html .= '<li><a href="' . $this->view->usuario()->urlLogout() . '">Sair</a></li>';
$html .= '</ul></li><li class="divider-vertical visible-desktop"></li>';
return $html;
}
public function indexAction()
{
$zsn = new Zend_Session_Namespace('interval');
$zsn->interval = self::INTERVAL;
if (!\Core_Integration_Sica_User::getUserProfileExternal()) {
$this->_redirect('/artefato/area-trabalho/index/tipoArtefato/1/caixa/minhaCaixa');
}
}
public function modalSelecionarPerfil()
{
if (\Core_Integration_Sica_User::getUserProfileExternal()) {
return $this->view->usuarioExterno()->modalSelecionarPerfil();
} else {
return $this->view->usuario()->modalSelecionarPerfil();
}
}
public function systemsActives($sqTipoPerfil = 1, array $arrTipoPerfil = array(1, 2))
{
$queryBuilder = $this->getEntityManager()->createQueryBuilder();
$query = $queryBuilder->select('s.sqSistema', 's.noSistema', 's.sgSistema')->from('app:Sistema', 's')->andWhere($queryBuilder->expr()->eq('s.stRegistroAtivo', ':active'))->setParameter('active', 'TRUE')->orderBy('s.sgSistema, s.noSistema');
if (!in_array($sqTipoPerfil, $arrTipoPerfil) && !\Core_Integration_Sica_User::getUserProfileExternal()) {
$queryBuilder->andWhere($queryBuilder->expr()->in('s.sqSistema', $this->_em->getRepository('app:Sistema')->getSistemasPorTipoPerfil($sqTipoPerfil, $arrTipoPerfil)));
}
return $query->getQuery()->getArrayResult();
}
/**
*
*/
protected static function getParams($data, $type, $options, $metodo)
{
self::checaOperacaoWs($metodo);
$sqUsuario = \Core_Integration_Sica_User::getUserId() ? \Core_Integration_Sica_User::getUserId() : null;
$perfilUsuario = isset($_SESSION["USER"]) ? \Core_Integration_Sica_User::getUserProfileExternal() : true;
$sistema = \Core_Integration_Sica_User::getInfoSystem(\Core_Integration_Sica_User::getUserSystem());
$request = new \Zend_Controller_Request_Http();
$arrRequest = explode('/', $request->getRequestUri());
$params = array('sqSistema' => (int) $sistema['sqSistema'], 'sgSistema' => (string) $sistema['sgSistema'], 'sqClasse' => 0, 'noClasse' => (string) $arrRequest[1] . '/' . $arrRequest[2], 'sqMetodo' => 0, 'noMetodo' => (string) 'index', 'sqUsuario' => $sqUsuario, 'sgOperacao' => self::$sqOperacao, 'stUsuarioExterno' => (int) $perfilUsuario);
$params['xmTrilha'] = self::geraTagXml($type);
return $params;
}
/**
*
*/
protected static function getParams($data, $type, $options, $metodo)
{
self::checaOperacaoWs($metodo);
$session = \Core_Integration_Sica_User::has();
$sqUsuario = \Core_Integration_Sica_User::getUserId() ? \Core_Integration_Sica_User::getUserId() : null;
$perfilUsuario = $session ? \Core_Integration_Sica_User::getUserProfileExternal() : true;
$sistema = \Core_Integration_Sica_User::getInfoSystem(\Core_Integration_Sica_User::getUserSystem());
$sis = \Zend_Registry::get('doctrine')->getEntityManager()->getRepository('app:Sistema')->findBySgSistema('SICA-e');
$sqSistema = $session ? $sistema['sqSistema'] : $sis[0]->getSqSistema();
$sgSistema = $session ? $sistema['sgSistema'] : $sis[0]->getSgSistema();
$request = new \Zend_Controller_Request_Http();
$arrRequest = explode('/', $request->getRequestUri());
$params = array('sqSistema' => (int) $sqSistema, 'sgSistema' => (string) $sgSistema, 'sqClasse' => self::NUM_ZERO, 'noClasse' => (string) $arrRequest[1] . '/' . $arrRequest[2], 'sqMetodo' => self::NUM_ZERO, 'noMetodo' => (string) 'index', 'sqUsuario' => $sqUsuario, 'sgOperacao' => self::$sqOperacao, 'stUsuarioExterno' => (int) $perfilUsuario);
$params['xmTrilha'] = self::geraTagXml($type);
return $params;
}
public function unitProfile(\Core_Dto_Mapping $dto)
{
$queryBuilder = $this->_em->createQueryBuilder();
$repository = 'app:UsuarioPerfil';
$inPerfilExterno = 'FALSE';
$column = 'up.sqUsuario';
if (\Core_Integration_Sica_User::getUserProfileExternal()) {
$repository = 'app:UsuarioExternoPerfil';
$column = 'up.sqUsuarioExterno';
$inPerfilExterno = 'TRUE';
}
$queryBuilder->select('up')->from($repository, 'up')->innerJoin('up.sqPerfil', 'p');
if (!\Core_Integration_Sica_User::getUserProfileExternal()) {
$queryBuilder->where('up.sqUnidadeOrgPessoa = :sqUnidadeOrg')->setParameter('sqUnidadeOrg', $dto->getSqUnidadeOrgPessoa());
}
$queryBuilder->andWhere($column . ' = :sqUsuario')->setParameter('sqUsuario', $dto->getSqUsuario())->andWhere('p.sqSistema = :sqSistema')->setParameter('sqSistema', $dto->getSqSistema())->andWhere($queryBuilder->expr()->eq('p.inPerfilExterno', ':inPerfilExterno'))->setParameter('inPerfilExterno', $inPerfilExterno);
return $queryBuilder->getQuery()->getResult();
}
public function MenuProfileHome()
{
$html = '<ul class="nav pull-right dropdown-perfil">
<li class="divider-vertical visible-desktop"></li>
<li class="dropdown pull-right">
<a data-toggle="dropdown" class="dropdown-toggle" href="#">
<img src="/assets/img/icons/icon-perfil.png">
</a>
<ul class="dropdown-menu">';
$html .= '<li><span>Nome: ' . $this->view->userName() . '</span></li>';
$html .= '<li class="divider"></li>';
if (\Core_Integration_Sica_User::getUserProfileExternal()) {
$html .= $this->view->usuarioExterno()->optionAlterarCadastro(TRUE);
}
$html .= '<li><a data-toggle="modal" data-backdrop="static" data-keyboard="false" ' . 'href="#modal-alterar-senha" id="btn-alterar-senha">Alterar Senha</a>' . '</li>';
$html .= '<li><a href="' . $this->view->usuario()->urlLogout() . '">Sair</a></li>';
$html .= '</ul></li><li class="divider-vertical visible-desktop"></li></ul>';
return $html;
}
public function userProfileAction()
{
$this->_helper->layout->disableLayout(TRUE);
$params = $this->_getAllParams();
$perfil = $this->getService('Perfil')->find($params['sqPerfil']);
$session = new Core_Session_Namespace('USER', FALSE, TRUE);
if (!\Core_Integration_Sica_User::getUserProfileExternal()) {
$pessoa = $this->getService('Pessoa')->find($params['sqUnidadeOrg']);
$session->sqUnidadeOrg = $params['sqUnidadeOrg'];
$session->noUnidadeOrg = $pessoa->getNoPessoa();
}
$session->sqPerfil = $params['sqPerfil'];
$session->noPerfil = $perfil->getNoPerfil();
$sqSistema = $this->getService('Sistema')->find($params['systemId']);
$session->sqSistema = $sqSistema->getSqSistema();
$session->sqLeiaute = $sqSistema->getSqLeiaute()->getSqLeiaute();
$mappingPerfil = new Core_Dto_Mapping(array('sqPerfil' => $session->sqPerfil, 'noPerfil' => $session->noPerfil), array('noPerfil', 'sqPerfil'));
$acl = $this->getService('Usuario')->mountAcl($mappingPerfil);
if ($acl instanceof \Core_Acl_AclSession) {
$session->acl = $acl;
}
$this->view->response = \Zend_Json::encode(TRUE);
}
/**
* $sqSistema = Sigla do sistema
* $sqClass = sequencial da class, para indefinido utilize 0 (zero)
* $sqMetodo = sequencial do metodo, para indefinido utilize 0 (zero)
* $noSchema = Nome do Schema
* $noTabela = Nome da tabela
* $sqUsuario = Usuario logado
* $sgOperacao = I, U, D
* $columns = {campo1, campo2, campo3}
* $values = {value1, value2, value3}
* @param \Doctrine\ORM\Event\LifecycleEventArgs $args
*/
protected static function getParams(LifecycleEventArgs $args)
{
$metadata = $args->getEntityManager()->getClassMetadata(get_class($args->getEntity()));
$sistema = Core_Integration_Sica_User::getInfoSystem(Core_Integration_Sica_User::getUserSystem());
$sis = \Zend_Registry::get('doctrine')->getEntityManager()->getRepository('app:Sistema')->findBySgSistema('SICA-e');
$session = Core_Integration_Sica_User::has();
$sqSistema = $session ? $sistema['sqSistema'] : $sis[0]->getSqSistema();
$sgSistema = $session ? $sistema['sgSistema'] : $sis[0]->getSgSistema();
$request = new Zend_Controller_Request_Http();
$arrRequest = explode('/', $request->getRequestUri());
$perfilUsuario = $session ? \Core_Integration_Sica_User::getUserProfileExternal() : true;
$usuario = $session ? \Core_Integration_Sica_User::getUserId() : null;
$params = array('sqSistema' => (int) $sqSistema, 'sgSistema' => (string) $sgSistema, 'sqClasse' => self::NUM_ZERO, 'noClasse' => (string) $arrRequest[1] . '/' . $arrRequest[2], 'sqMetodo' => self::NUM_ZERO, 'noMetodo' => (string) 'index', 'sqUsuario' => $usuario, 'sgOperacao' => self::$sqOperacao, 'stUsuarioExterno' => (int) $perfilUsuario);
$columnsFields = array();
$columnField = array();
$columnAssoc = array();
$valueField = array();
$valueAssoc = array();
foreach ($metadata->getFieldNames() as $name) {
$valueField = $metadata->getFieldValue($args->getEntity(), $name);
$columnField = $metadata->getColumnName($name);
$columnsFields[$columnField] = $valueField;
}
foreach ($metadata->getAssociationNames() as $name) {
if ($metadata->hasAssociation($name)) {
$associationMap = $metadata->getAssociationMapping($name);
if (isset($associationMap['sourceToTargetKeyColumns'])) {
$valueAssoc = $metadata->getFieldValue($args->getEntity(), $name);
$columnAssoc = key($associationMap['sourceToTargetKeyColumns']);
$columnsFields[$columnAssoc] = $valueAssoc;
}
}
}
$columnsFields = self::validateValue($columnsFields);
$params['xmTrilha'] = self::geraTagXml($columnsFields, $metadata, $args);
return $params;
}
public function modalAlterarSenha()
{
$urlSica = rtrim(Zend_Controller_Front::getInstance()->getParam('bootstrap')->getOption('urlSica'), '/') . '/';
$html = '<div class="modal hide fade" id="modal-alterar-senha">
<div class="modal-header">
<a class="close" data-dismiss="modal">×</a>
<h3>Alterar Minha Senha</h3>
</div>
<div class="modal-body">
<form class="form-horizontal" id="form-altera-senha"
name="form-altera-senha" method="post">
<fieldset>
<div class="control-group error-pass">
</div>
<div class="control-group">
<label class="control-label" for="input01"><span class="required">* </span>Senha Atual</label>
<div class="controls">
<input type="password" name="txSenha"
class="input-xlarge required validatePassword"
maxlength="32" id="txSenha">
<span class="help-block">Digite a senha que você quer trocar</span>
</div>
</div>
<div class="control-group">
<label class="control-label" for="input01"><span class="required">* </span>Nova Senha</label>
<div class="controls">
<input type="password" name="txSenhaNova"
class="input-xlarge required validatePassword" maxlength="32" id="txSenhaNova">
<span class="help-block">Digite sua nova senha</span>
</div>
</div>
<div class="control-group">
<label class="control-label" for="input01"><span class="required">* </span>Confirmação Nova Senha</label>
<div class="controls">
<input type="password" name="txSenhaNovaConfirm"
class="input-xlarge required validatePassword" maxlength="32"
id="txSenhaNovaConfirm">
<span class="help-block">Digite sua nova senha outra vez</span>
</div>
</div>
</fieldset>
</form>
</div>
<div class="modal-footer">
<button type="button" id="btnAlteraSenha" class="btn btn-primary">Concluir</button>
<button type="button" class="btn" id="btnCancelar" data-dismiss="modal">
<i class="icon-remove"></i>
Cancelar</button>
</div>
</div>';
if (\Core_Integration_Sica_User::getUserProfileExternal()) {
$url = 'sica/usuario-externo/usuario-externo.js';
} else {
$url = 'sica/usuario/usuario.js';
}
$html .= '<script src="' . $urlSica . $this->view->assetUrl($url) . '" type="text/javascript"></script>';
return $html;
}
/**
* @return void
*/
public function logoutAction()
{
Zend_Auth::getInstance()->clearIdentity();
$urlToRedirect = '';
$urlBack = $this->_getParam('url-back', '');
if (!empty($urlBack)) {
$urlToRedirect = $urlBack;
} else {
$urlToRedirect = rtrim(Zend_Controller_Front::getInstance()->getParam('bootstrap')->getOption('urlSica'), '/');
if (\Core_Integration_Sica_User::getUserProfileExternal()) {
$urlToRedirect .= '/usuario-externo/login';
}
}
$this->_redirect($urlToRedirect);
}
/**
* Atribuir dados extras a SESSION['USER']
*
* @param integer $unit
* @param object $dto
* @return void
*/
protected function _setSessionInfoUser($unit, $dto)
{
$data = array('sqUsuario' => $dto->getSqUsuario(), 'sqSistema' => $dto->getSqSistema(), 'sqUnidadeOrgPessoa' => $unit['sqPessoa']);
$dto->setInput($data);
$data = $this->getService('UsuarioPerfil')->unitProfile($dto);
$session = new Core_Session_Namespace('USER', FALSE, TRUE);
$session->acl = NULL;
if (!\Core_Integration_Sica_User::getUserProfileExternal()) {
$session->sqUnidadeOrg = current($data)->getSqUnidadeOrgPessoa()->getSqPessoa();
$session->noUnidadeOrg = current($data)->getSqUnidadeOrgPessoa()->getNoPessoa();
}
$session->sqPerfil = current($data)->getSqPerfil()->getSqPerfil();
$session->noPerfil = current($data)->getSqPerfil()->getNoPerfil();
$session->sqSistema = $dto->getSqSistema();
}
