/** * Edits a accessLine * * @param string $id */ public function editAction($id) { try { if ($this->request->isPost()) { throw new Exception('Acesso inválido a essa action!!!'); } $cpf = CellPhoneLine::find(['columns' => 'distinct cpf, name', 'order' => '2']); $linha = CellPhoneLine::find(['columns' => 'distinct linha']); $cpfs = $linhas = []; foreach ($cpf->toArray(0) as $value) { $cpfs[$value['CPF']] = $value['NAME']; } foreach ($linha->toArray(0) as $value) { $linhas[$value['LINHA']] = $value['LINHA']; } $this->view->cpfs = $cpfs; $this->view->linhas = $linhas; $accessLine = AccessLine::findFirstByid($id); if (!$accessLine) { throw new Exception('Acesso a Linha não encontrado!'); } $this->view->id = $accessLine->id; $this->tag->setDefault('id', $accessLine->getId()); $this->tag->setDefault('cpf', $accessLine->getCpf()); $this->tag->setDefault('linha', $accessLine->getLinha()); } catch (Exception $exc) { $this->flash->error($exc->getMessage()); return $this->response->redirect('telephony/access_line'); } }
public function contaCelularAdminAction() { try { $this->view->pesquisa = ''; if ($this->request->isPost()) { $linhas = $this->request->getPost('linhas', 'string'); $mes = str_replace('20', '', $this->request->getPost('mes', 'string')); $this->view->extratos = Statement::find("operLd IS NOT NULL AND numAcs = '{$linhas}' AND mes = '{$mes}'"); $this->view->totais = Statement::find("operLd IS NULL AND numAcs = '{$linhas}' AND mes = '{$mes}'"); $statement = new Statement(); $this->view->totalLinha = $statement->getTotal($linhas, $mes); $this->view->pesquisa = $linhas . ' | ' . $this->request->getPost('mes', 'string'); $this->view->export = true; } $cellPhoneLine = CellPhoneLine::find(['order' => 'linha']); $linhas = []; foreach ($cellPhoneLine as $value) { $linhas[$value->linha] = $value->linha; } $this->view->linhas = $linhas; } catch (\Exception $e) { $this->flash->error($e->getMessage()); } }