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");
$clientModel = new ClientModel();
$clientModelData = $clientModel->fetchAll($clientModel->getAllClient());
$this->view->clientModelData = $clientModelData;
$tabela = new ClientModel();
$agenda = $tabela->fetchAll();
$count = count($agenda);
if ($count > 0 && $limit > 0) {
$total_pages = ceil($count / $limit);
} else {
$total_pages = 0;
}
if ($page > $total_pages) {
$page = $total_pages;
}
//$agenda = $tabela->fetchAll(null, "$sidx $sord", $limit, ($page*$limit-$limit));
$responce = new stdClass();
$responce->page = $page;
$responce->total = $total_pages;
$responce->records = $count;
$i = 0;
foreach ($clientModelData as $row) {
$responce->rows[$i]['id'] = $row->cdusergslab;
$responce->rows[$i]['cell'] = array($row->nmclient, $row->idcomplement, $row->idcep, $row->nmimages);
$i++;
}
$this->view->dados = $responce;
}
public function autoclientsearchAction()
{
$client = $this->_request->getParam('term');
$clientModel = new ClientModel();
$userData = $clientModel->fetchAll('nmclient LIKE "%' . $client . '%"');
$json = '[';
$first = true;
foreach ($userData as $row) {
if (!$first) {
$json .= ',';
} else {
$first = false;
}
$json .= '{"id":"' . $row['cdclient'] . '", "value":"' . $row['nmclient'] . '"}';
}
$json .= ']';
echo $json;
}
public function __construct()
{
parent::__construct();
$covenantModel = new CovenantModel();
$selectCovenant = $covenantModel->fetchAll();
$company = new CompanyModel();
$selectCompany = $company->fetchAll('cdcompanyparent IS NULL');
$departmentModel = new DepartmentModel();
$selectDepartment = $departmentModel->fetchAll();
$nmcollectionplaceModel = new CompanyModel();
$selectCompany = $nmcollectionplaceModel->fetchAll();
$clientModel = new ClientModel();
$clientData = $clientModel->fetchAll();
$this->_cdcovenant = new Zend_Form_Element_Select('cdcovenant');
$this->_cdcovenant->setAttrib("id", "covenantbilling_cdcovenant");
$this->_cdcovenant->setAttrib("class", "check_multiple_select");
foreach ($selectCovenant as $value) {
//$this->_cdcovenant->addMultiOption($value->cdcovenant, $value->nmcovenant);
}
$this->_cdcovenant->setLabel("Convênio");
$this->_cdcovenant->setDecorators($this->_decoratorsDefault);
$this->_cdcovenant->setRegisterInArrayValidator(false);
$this->_cdcovenant->setRequired(false);
$this->_cdcompanyparent = new Zend_Form_Element_Select('cdcompanyparent');
$this->_cdcompanyparent->setAttrib("id", "controltbilling_cdcompanyparent");
foreach ($selectCompany as $value) {
$this->_cdcompanyparent->addMultiOption($value->cdcompany, $value->nmcompany);
}
$this->_cdcompanyparent->setLabel("Posto de Coleta");
$this->_cdcompanyparent->setDecorators($this->_decoratorsDefault);
$this->_cdcompanyparent->setRegisterInArrayValidator(false);
$this->_cdcompanyparent->setRequired(false);
$this->_cddepartment = new Zend_Form_Element_Select('cddepartment');
$this->_cddepartment->setAttrib("id", "covenantbilling_ceddepartment");
$this->_cddepartment->setAttrib("class", "check_multiple_select");
foreach ($selectDepartment as $value) {
$this->_cddepartment->addMultiOption($value->cddepartment, $value->nmdepartment);
}
$this->_cddepartment->setLabel("Setor");
$this->_cddepartment->setDecorators($this->_decoratorsDefault);
$this->_cddepartment->setRegisterInArrayValidator(false);
$this->_cddepartment->setRequired(false);
$this->_fgstatus = new Zend_Form_Element_Select('fgstatus');
$this->_fgstatus->setAttrib("id", "covenantbilling_fgstatus");
$this->_fgstatus->setMultiOptions(array("0" => "Selecione", "1" => "Ativo", "2" => "Inativo"));
$this->_fgstatus->setLabel("Status");
$this->_fgstatus->setDecorators($this->_decoratorsDefault);
$this->_fgstatus->setRegisterInArrayValidator(false);
$this->_fgstatus->setRequired(false);
//$clientData
$this->_cdclient = new Zend_Form_Element_Text('cdclient');
$this->_cdclient->setAttrib("id", "covenantbilling_cdclient");
$this->_cdclient->setAttrib("onkeyup", "lookup(this.value);");
$this->_cdclient->setAttrib("onblur", "fill();");
$this->_cdclient->setAttrib("autocomplete", "off");
$this->_cdclient->setAttrib("size", "50");
// foreach ($clientData as $value) {
// $this->_cdclient->addMultiOption($value->cdclient, $value->nmclient);
// }
$this->_cdclient->setLabel("Paciente");
$this->_cdclient->setDecorators($this->_decoratorsDefault);
$this->_cdclient->setRequired(false);
$this->_dtstart = new Zend_Form_Element_Text('dtstart');
$this->_dtstart->setAttrib("id", "covenantbilling_dtstart");
$this->_dtstart->setAttrib("class", "datepicker");
$this->_dtstart->setLabel("Data Inicio");
$this->_dtstart->setDecorators($this->_decoratorsDefault);
$this->_dtstart->setRequired(false);
$this->_hrend = new Zend_Form_Element_Text('dtenddate');
$this->_hrend->setLabel("Hora Início");
$this->_hrend->setDecorators($this->_decoratorsDefault);
$this->_hrend->setAttrib("id", "covenantbilling_hrend");
$this->_hrend->setAttrib("class", "mask_time");
$this->_dtend = new Zend_Form_Element_Text('dtend');
$this->_dtend->setAttrib("id", "covenantbilling_dtenddate");
$this->_dtend->setAttrib("class", "datepicker");
$this->_dtend->setLabel("Data Fim");
$this->_dtend->setDecorators($this->_decoratorsDefault);
$this->_dtend->setRequired(false);
$this->_hrstart = new Zend_Form_Element_Text('hrstart');
$this->_hrstart->setLabel("Hora Fim");
$this->_hrstart->setDecorators($this->_decoratorsDefault);
$this->_hrstart->setAttrib("id", "covenantbilling_hrstart");
$this->_hrstart->setAttrib("class", "mask_time");
$this->_nrbatch = new Zend_Form_Element_Text('nrlot');
$this->_nrbatch->setAttrib("id", "covenantbilling_nrbatch");
$this->_nrbatch->setLabel("Número do Lote");
$this->_nrbatch->setDecorators($this->_decoratorsDefault);
$this->_nrbatch->setRequired(false);
$this->_dtduedate = new Zend_Form_Element_Text('dtduedate');
$this->_dtduedate->setAttrib("id", "covenantbilling_dtduedate");
$this->_dtduedate->setAttrib("class", "datepicker");
$this->_dtduedate->setLabel("Vencimento");
$this->_dtduedate->setDecorators($this->_decoratorsDefault);
$this->_dtduedate->setRequired(false);
}
public function autosearchAction()
{
$client = $_POST["queryString"];
$clientModel = new ClientModel();
$clientData = $clientModel->fetchAll($clientModel->getClient($client));
echo "<ul id='sug'>";
foreach ($clientData as $row) {
echo '<li onClick="fill(\'' . $row->cdclient . '\', \'' . $row->nmclient . '\');"><a href="javascript:void(0);">' . $row->nmclient . '</a></li>';
}
echo "</ul>";
}
public static function autoCompletePatientSearch($nmclient)
{
$clientModel = new ClientModel();
$clientData = $clientModel->fetchAll('nmclient like "%' . $nmclient . '%"');
$json = '[';
$first = true;
foreach ($clientData as $row) {
if (!$first) {
$json .= ',';
} else {
$first = false;
}
$json .= '{"id":"' . $row['cdclient'] . '", "value":"' . $row['nmclient'] . '"}';
}
$json .= ']';
return $json;
}
private function getFormData($cdrequest = "0")
{
/* 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);
}
*
*
* public function getPatientSituationCdRequest($cdrequest) { ///////
$select = $this->select()
->from("request")
->join("client", "request.cdclient = client.cdclient") //faz a união das tabelas
->where("client.cdclient = ?", $cdrequest) //apresenta os parametros
->setIntegrityCheck(false);
echo $select;die;
return $select;
}
*/
// Busca todos os Clientes/Pacientes, Ativos e Inativos.
$clientModel = new ClientModel();
$this->view->clientData = $clientModel->fetchAll(null, array('client.cdclient', 'client.nmclient'));
// Busca todas as empresas, Ativas e Inativas.
$companyModel = new CompanyModel();
$this->view->companyData = $companyModel->fetchAll(null, 'company.nmcompany');
// Busca apenas Exames Ativos(fgactive = 1)
$examinationModel = new ExaminationModel();
$this->view->examinationData = $examinationModel->fetchAll('examination.fgactive = 1', 'examination.nmexamination');
}
public function autosearchAction()
{
$client = $_POST["queryString"];
$clientModel = new ClientModel();
$clientData = $clientModel->fetchAll($clientModel->getClient($client));
foreach ($clientData as $row) {
echo '<li onClick="fill(\'' . $row->cdclient . '\', \'' . $row->nmclient . '\');">' . $row->nmclient . '</li>';
}
}
public function dadosAction()
{
$this->_helper->layout->disableLayout();
$page = $this->_request->getParam("page");
$limit = $this->_request->getParam("rows");
$sord = $this->_request->getParam("sord");
$clientModel = new ClientModel();
$phoneModel = new ClientphonenumberModel();
$client = $clientModel->fetchAll();
$count = count($client);
if ($count > 0 && $limit > 0) {
$total_pages = ceil($count / $limit);
} else {
$total_pages = 0;
}
if ($page > $total_pages) {
$page = $total_pages;
}
if ($this->_request->getParam("_search") == 'true') {
$searchString = $this->_request->getParam("searchString");
$searchField = $this->_request->getParam("searchField");
$clientDados = $clientModel->fetchAll($clientModel->getClientSearchGrid($searchField, $searchString, $sord));
} else {
$clientDados = $clientModel->fetchAll(null, 'nmclient', $limit, $page * $limit - $limit);
}
$response = new stdClass();
$response->page = $page;
$response->total = $total_pages;
$response->records = $count;
$i = 0;
foreach ($clientDados as $rows) {
// TODO: Arrumar telefone de paciente
$phoneData = $phoneModel->fetchRow('cdclient = ' . $rows->cdclient);
$fgsex = null;
switch ($rows->fgsex) {
case '1':
$fgsex = 'Masculino';
break;
case '2':
$fgsex = 'Feminino';
break;
}
switch ($rows->fgvip) {
case '1':
$fgvip = 'Sim';
break;
case '2':
$fgvip = 'Não';
break;
}
if (isset($rows["dtbirth"])) {
$date = GslabUtils::dateToLocaleBR($rows["dtbirth"]);
}
$response->rows[$i]['cell'] = array($rows->cdclient, $rows->nmclient, $fgsex, $date, $fgvip, $phoneData['nrdddphone'] . " " . $phoneData['nrphonenumber']);
$i++;
}
$this->view->dados = $response;
}
