public function dadosforwardAction()
{
$cdclient = $_GET["cdcliente"];
$this->_helper->layout->disableLayout();
$page = $this->_request->getParam("page", 1);
$limit = $this->_request->getParam("rows");
$sidx = $this->_request->getParam("sidx", 1);
$sord = $this->_request->getParam("sord");
$forwardModel = new ForwardModel();
$forwardData = $forwardModel->fetchAll();
$count = count($forwardData);
if ($count > 0 && $limit > 0) {
$total_pages = ceil($count / $limit);
} else {
$total_pages = 0;
}
if ($page > $total_pages) {
$page = $total_pages;
}
$forwardData = $forwardModel->fetchAll($forwardModel->getForwardByClient($cdclient, $sidx, $sord, $limit, $page));
$responce = new stdClass();
$responce->page = $page;
$responce->total = $total_pages;
$responce->records = $count;
$i = 0;
foreach ($forwardData as $row) {
$responce->rows[$i]['cdclient'] = $row->cdclient;
$responce->rows[$i]['cell'] = array($row->nmforward, substr($row->dtrequest, 8, 2) . '/' . substr($row->dtrequest, 5, 2) . '/' . substr($row->dtrequest, 0, 4));
$i++;
}
$this->view->dadosforward = $responce;
}
public function dadosindexAction()
{
$this->_helper->layout->disableLayout();
$page = $this->_request->getParam("page", 1);
$limit = $this->_request->getParam("rows");
$sidx = $this->_request->getParam("sidx", 1);
$sord = $this->_request->getParam("sord");
$forwardModel = new ForwardModel();
$forward = $forwardModel->fetchAll();
$count = count($forward);
if ($count > 0 && $limit > 0) {
$total_pages = ceil($count / $limit);
} else {
$total_pages = 0;
}
if ($page > $total_pages) {
$page = $total_pages;
}
$forward = $forwardModel->fetchAll(null, "{$sidx} {$sord}", $limit, $page * $limit - $limit);
$responce = new stdClass();
$responce->page = $page;
$responce->total = $total_pages;
$responce->records = $count;
$i = 0;
foreach ($forward as $rows) {
switch ($rows->fgactive) {
case '1':
$fgactive = 'Ativo';
break;
case '2':
$fgactive = 'Inativo';
break;
}
switch ($rows->fgcovenantrestriction) {
case '1':
$fgcovenantrestriction = '1';
break;
case '2':
$fgcovenantrestriction = '2';
break;
}
$responce->rows[$i]['cell'] = array($rows->cdforward, $rows->nmforward, $rows->nmmail, $rows->idmaincrm, $rows->idmaincrmstate, $rows->idalternativecrm, $rows->idalternativecrmstate, $rows->idcnes, $rows->nrcellphone, $rows->nrphone, $rows->nmstreet, $rows->nrnumber, $rows->nmneighborhood, $rows->idcity, $rows->idstate, $rows->idcep, $fgcovenantrestriction, $fgactive);
$i++;
}
// print_r($responce); die;
$this->view->dados = $responce;
}
private function getFormData($cdrequest = "0")
{
$gslabSession = Zend_Session::namespaceGet('Gslab_Session');
/* Usado para a edição de uma requisição
* Remover quando criar a tela de controle de requisição
* Maikon.Deletar
*
if($cdrequest > 0)
{
$requestModel = new RequestModel();
$requestData = $requestModel->fetchRow($requestModel->getRequestByCdRequest($cdrequest));
$this->view->cdrequest = $requestData->cdrequest;
$this->view->cdclient = $requestData->cdclient;
$this->view->cdcovenant = $requestData->cdcovenant;
$this->view->cdforward = $requestData->cdforward;
$this->view->idcovenantcard = $requestData->idcovenantcard;
$this->view->fgpriority = $requestData->fgpriority;
//$this->view->fgcollection = $requestData->fgcollection;
// Completar aqui com as novas colunas da tabela 'request'
// Tratar variável de data vinda do banco para colocar no formulário
$dtrequestdb = $requestData->dtrequest;
$date = new Zend_Date($dtrequestdb, 'YYYY-MM-dd HH:mm:ss');
$dtrequest = $date->toString('dd-MM-YYYY');
$hrrequest = $date->toString('HH:mm:ss');
$this->view->dtrequest = $dtrequest;
$this->view->hrrequest = $hrrequest;
//die("feshow, cdrequest: " . $cdrequest .", cdclient: ". $requestData->cdclient .", dtbirth: ". $requestData->dtbirth .", nrage: ". $this->view->nrage);
}
*/
// Busca todos os Clientes/Pacientes, Ativos e Inativos.
$clientModel = new ClientModel();
$this->view->clientData = $clientModel->fetchAll(null, 'client.nmclient');
// Busca os Guichês ativos e relacionados ao posto de coleta .
$cashdeskModel = new CashdeskModel();
$cdcompany = $gslabSession['user']->cdcompany;
$this->view->cashdeskData = $cashdeskModel->fetchAll("cashdesk.cdcompany = {$cdcompany} AND cashdesk.fgactive = 1", 'cashdesk.nmcashdesk');
// Busca todas as empresas, Ativas e Inativas.
$companyModel = new CompanyModel();
$this->view->companyData = $companyModel->fetchAll('company.cdcompany = ' . $gslabSession['user']->cdcompany . ' OR company.cdcompanyparent = ' . $gslabSession['user']->cdcompany, 'company.nmcompany');
// Busca todos os médicos que enviaram o paciente
$forwardModel = new ForwardModel();
$this->view->forwardData = $forwardModel->fetchAll(null, 'forward.nmforward');
// Busca apenas Exames Ativos(fgactive = 1)
$opernatureModel = new OpernatureModel();
$this->view->opernature = $opernatureModel->fetchAll();
// Busca apenas suprimentos Ativos(fgactive = 1)
$supplyModel = new SupplyModel();
$this->view->supplyData = $supplyModel->fetchAll('supply.fgactive = 1', 'supply.nmsupply');
// Busca todos os Logradouros.
$addressTypeModel = new AddresstypeModel();
$this->view->addressTypeData = $addressTypeModel->getAllAddressType();
$medicinesModel = new MedicineModel();
$this->view->medicineData = $medicinesModel->fetchAll("cdsupply IS NOT NULL", 'medicine.nmmedicine');
$cashdeskModel = new CashdeskModel();
$this->view->cashdeskData = $cashdeskModel->fetchAll(null, 'cashdesk.nmcashdesk');
}
