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