public function getSistemasPorTipoPerfil($sqTipoPerfil = 1, array $arrTipoPerfil = array(1, 2), $exc = TRUE) { $qBuilder = $this->_em->createQueryBuilder(); $query = $qBuilder->select('s.sqSistema')->from('app:UsuarioPerfil', 'up')->innerJoin('up.sqUsuario', 'u')->innerJoin('up.sqPerfil', 'p')->innerJoin('p.sqTipoPerfil', 'tp')->innerJoin('p.sqSistema', 's')->where($qBuilder->expr()->in('tp.sqTipoPerfil', ':sqTipoPerfil'))->andWhere($qBuilder->expr()->eq('u.sqUsuario', ':sqUsuario'))->setParameters(array('sqTipoPerfil' => $arrTipoPerfil, 'sqUsuario' => \Core_Integration_Sica_User::getUserId())); $result = $query->getQuery()->getResult(); $arrSistemas = array(); foreach ($result as $value) { $arrSistemas[] = $value['sqSistema']; } $arrSistemas = array_unique($arrSistemas); $sqSistema = \Core_Integration_Sica_User::getUserSystem(); if ($sqTipoPerfil == 3) { $key = array_search($sqSistema, $arrSistemas); if ($key !== FALSE) { unset($arrSistemas[$key]); } } if (!$arrSistemas || in_array($sqSistema, $arrSistemas) && count($arrSistemas) == 1) { if ($exc) { \Core_Messaging_Manager::getGateway('Service')->addErrorMessage('MN148'); throw new \Core_Exception_ServiceLayer_Verification(); } } return $arrSistemas; }
public function optionAlterarCadastro($home = FALSE) { $urlSica = rtrim(Zend_Controller_Front::getInstance()->getParam('bootstrap')->getOption('urlSica'), '/'); $sqUsuario = \Core_Integration_Sica_User::getUserId(); $urlAlter = $urlSica . '/principal/usuario-externo/edit/id/' . $sqUsuario; if ($home) { $urlAlter = $urlSica . '/principal/usuario-externo/edit/id/' . $sqUsuario . '/page/home'; } $html = '<li><a href="' . $urlAlter . '">Alterar Cadastro</a></li>'; return $html; }
/** * */ 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; }
public function init() { parent::init(); $comboDas = $this->getService('VwChefia')->getComboDas(); $listaPais = $this->getService('VwPais')->comboPais(); $listaDocumentos = $this->getService('VwTipoDocumento')->listTipoDocumento(); $this->view->listaDocumentos = $listaDocumentos; $this->view->listaPais = $listaPais; $this->view->comboDas = $comboDas; $this->view->user = array('id' => Core_Integration_Sica_User::getUserId(), 'name' => $this->getSicaUsername()); $this->view->pessoa = Core_Integration_Sica_User::getPersonId(); }
/** * */ 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; }
/** * $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; }
private function getUserSica() { return \Core_Integration_Sica_User::getUserId(); }
/** * $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()); $request = Zend_Controller_Front::getInstance()->getRequest(); $params = array('sgSistema' => (string) $sistema['sgSistema'], 'noClasse' => $request->getModuleName() . '/' . $request->getControllerName(), 'noMetodo' => $request->getActionName(), 'sqUsuario' => \Core_Integration_Sica_User::getUserId(), 'sgOperacao' => self::$sqOperacao, 'stUsuarioExterno' => 0); $columns = array(); $values = array(); $associationMaps = array_merge($metadata->getFieldNames(), $metadata->getAssociationNames()); foreach ($associationMaps as $name) { $value = $metadata->getFieldValue($args->getEntity(), $name); $column = $metadata->getColumnName($name); if ($metadata->hasAssociation($name)) { $associationMap = $metadata->getAssociationMapping($name); $value = self::validateValue($value, $args); if (isset($associationMap['sourceToTargetKeyColumns'])) { $column = key($associationMap['sourceToTargetKeyColumns']); } else { $column = $associationMap['fieldName']; } } array_push($columns, $column); array_push($values, $value); } foreach ($values as $key => $value) { if (NULL === $value) { $values[$key] = ''; } if (!count($value)) { $values[$key] = ''; } } self::trataAlgo($values); $params['xmTrilha'] = self::geraTagXml($columns, $values, $metadata, $args); return $params; }
public function printAction() { // desabilitando layout $this->_helper->layout->disableLayout(); $this->_helper->viewRenderer->setNoRender(TRUE); $etiquetaPdf = new Sgdoce_EtiquetaPdf(); $sqLoteEtiqueta = $this->getRequest()->getPost('lote'); $dto = Core_Dto::factoryFromData(array('sqLoteEtiqueta' => $sqLoteEtiqueta), 'search'); $entityLote = $this->getService('LoteEtiqueta')->find($sqLoteEtiqueta); $arrDigitais = $this->getService()->listEtiquetaImprimir($dto); $textoEtiquetaKey = 'textoEtiqueta'; $etiquetaPdf->setEtiquetaComNUP($entityLote->getInLoteComNupSiorg()); if ($entityLote->getInLoteComNupSiorg()) { $textoEtiquetaKey = 'textoEtiquetaComNup'; } $textoEtiqueta = Zend_Controller_Front::getInstance()->getParam('bootstrap')->getOption($textoEtiquetaKey); if ($arrDigitais) { $this->getService('LoteEtiqueta')->saveUserPrintedDigital($sqLoteEtiqueta, \Core_Integration_Sica_User::getUserId()); } $etiquetaPdf->setTextoEtiqueta($textoEtiqueta)->setDigitais($arrDigitais)->generate(); }