public function edit(Context $context, $id = 0)
 {
     parent::edit($context, $id);
     // lotacoes do usuario
     $query = $this->em()->createQuery("SELECT e FROM Novosga\\Model\\Lotacao e JOIN e.cargo c JOIN e.grupo g WHERE e.usuario = :usuario ORDER BY g.left DESC");
     $query->setParameter('usuario', $this->model->getId());
     $rs = $query->getResult();
     $items = array();
     foreach ($rs as $lotacao) {
         $items[] = array('grupo_id' => $lotacao->getGrupo()->getId(), 'grupo' => $lotacao->getGrupo()->getNome(), 'cargo_id' => $lotacao->getCargo()->getId(), 'cargo' => $lotacao->getCargo()->getNome());
     }
     $this->app()->view()->set('lotacoes', $items);
     // servicos do usuario
     $query = $this->em()->createQuery("SELECT e FROM Novosga\\Model\\ServicoUsuario e WHERE e.usuario = :usuario");
     $query->setParameter('usuario', $this->model->getId());
     $rs = $query->getResult();
     $items = array();
     foreach ($rs as $servico) {
         $items[] = array('unidade_id' => $servico->getUnidade()->getId(), 'unidade' => $servico->getUnidade()->getNome(), 'servico_id' => $servico->getServico()->getId(), 'servico' => $servico->getServico()->getNome());
     }
     $this->app()->view()->set('servicos', $items);
     // unidades
     $query = $this->em()->createQuery("SELECT e FROM Novosga\\Model\\Unidade e ORDER BY e.nome");
     $this->app()->view()->set('unidades', $query->getResult());
     // cargos disponiveis
     $query = $this->em()->createQuery("SELECT e FROM Novosga\\Model\\Cargo e ORDER BY e.nome");
     $this->app()->view()->set('cargos', $query->getResult());
 }
 public function edit(Context $context, $id = 0)
 {
     parent::edit($context, $id);
     $query = $this->em()->createQuery("SELECT e FROM Novosga\\Model\\Servico e WHERE e.mestre IS NULL AND e.id != :id ORDER BY e.nome ASC");
     $query->setParameter('id', $this->model->getId());
     $this->app()->view()->set('macros', $query->getResult());
 }
 public function edit(Context $context, $id = 0)
 {
     parent::edit($context, $id);
     $className = get_class($this->model);
     $query = $this->em()->createQuery("SELECT e FROM {$className} e WHERE e.id != :id ORDER BY e.left");
     $query->setParameter('id', $this->model->getId());
     $this->app()->view()->set('pais', $query->getResult());
     $this->app()->view()->set('modelParent', $this->model->getParent($this->em()));
 }
 public function edit(Context $context, $id = 0)
 {
     $this->app()->view()->set('pesos', array(0 => _('Normal'), 1 => '1', 2 => '2', 3 => '3', 4 => '4', 5 => '5'));
     $this->app()->view()->set('status', array('' => _('Selecione'), 1 => _('Ativo'), 0 => _('Inativo')));
     parent::edit($context, $id);
 }
 public function edit(Context $context, $id = 0)
 {
     parent::edit($context, $id);
     $this->app()->view()->set('grupos', $this->getGruposFolhasDisponiveis($this->model));
 }