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');
}
public function dadosAction()
{
$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");
$array = $this->_request->getParams();
$clientModel = new ClientModel();
$covenantModel = new CovenantModel();
$opernatureModel = new OpernatureModel();
$supplierModel = new SupplierModel();
$total_pages = 0;
if (isset($array['secondperiod']) && $array['secondperiod'] != '') {
$array['secondperiod'] = new Zend_Date($array['secondperiod'], 'dd-MM-YYYY HH:mm:ss');
$array['secondperiod'] = $array['secondperiod']->toString('YYYY-MM-dd HH:mm:ss');
}
if (isset($array['firstperiod']) && $array['firstperiod'] != '') {
$array['firstperiod'] = new Zend_Date($array['firstperiod'], 'dd-MM-YYYY HH:mm:ss');
$array['firstperiod'] = $array['firstperiod']->toString('YYYY-MM-dd HH:mm:ss');
}
$accountentryData = $this->_model->fetchAll($this->_model->getAccountGridParams($array, $sidx, $sord, $limit, $page));
$count = count($accountentryData);
if ($page > $total_pages) {
$page = $total_pages;
} else {
$total_pages = 0;
}
$responce = new stdClass();
$responce->page = $page;
$responce->total = $total_pages;
$responce->records = $count;
$i = 0;
foreach ($accountentryData as $rows) {
$favored = '';
$nmopernature = '';
$fgaccountcheck = '';
$fgaccountentrytype = '';
switch ($rows->fgaccountentrytype) {
case '1':
$fgaccountentrytype = 'À Pagar';
break;
case '2':
$fgaccountentrytype = 'À Receber';
break;
}
switch ($rows->fgactive) {
case '2':
$fgactive = 'Inativo';
break;
case '1':
$fgactive = 'Ativo';
break;
}
switch ($rows->fgaccountcheck) {
case '0':
$fgaccountcheck = 'Pendente';
break;
case '1':
$fgaccountcheck = 'Baixa Realizada';
break;
}
if ($rows->fgclienttype == 'a') {
if ($rows->cdclient != null && $rows->cdclient != '') {
$clientData = $clientModel->fetchRow('cdclient = ' . $rows->cdclient);
$favored = $clientData['nmclient'];
}
} elseif ($rows->fgclienttype == 'b') {
if ($rows->cdclient != null && $rows->cdclient != '') {
$clientData = $covenantModel->fetchRow('cdcovenant = ' . $rows->cdclient);
$favored = $clientData['nmcovenant'];
}
}
if ($rows->fgaccountcheck != null && $rows->fgaccountcheck != '0') {
if ($rows->cdopernature != '') {
$opernatureData = $opernatureModel->fetchRow('cdopernature = ' . $rows->cdopernature);
$nmopernature = $opernatureData['nmopernature'];
}
}
if ($rows->cdsupplier != '' && $rows->cdsupplier != null) {
$supplierData = $supplierModel->fetchRow('cdsupplier = ' . $rows->cdsupplier);
$favored = $supplierData['nmsupplier'];
}
$responce->rows[$i]['cdaccountentry'] = $rows->cdaccountentry;
$responce->rows[$i]['cell'] = array($rows->nraccountentry, $fgaccountentrytype, $favored, $fgaccountcheck, $fgactive, $nmopernature, $rows->cdaccountentry);
$i++;
}
$this->view->dados = $responce;
}
