public function __construct()
{
parent::__construct();
$covenantModel = new CovenantModel();
$covenantData = $covenantModel->getAllCovenant();
$examinationModel = new ExaminationModel();
$examinationData = $examinationModel->fetchAll();
$this->_cdexamination = new Zend_Form_Element_Select('cdexamination');
$this->_cdexamination->setAttrib("id", "pricing_cdexamination");
$this->_cdexamination->setLabel("Exame");
$this->_cdexamination->setDecorators($this->_decoratorsDefault);
$this->_cdexamination->setRequired(false);
$this->_cdexamination->setRegisterInArrayValidator(false);
$this->_cdexamination->addMultiOption("", 'Selecione um convênio');
$this->_nrdeadline = new Zend_Form_Element_Text('nrdeadline');
$this->_nrdeadline->setAttrib("id", "pricing_nrdeadline");
$this->_nrdeadline->setAttrib("size", "15");
$this->_nrdeadline->setLabel("Prazo Novo Exame (Mês)");
$this->_nrdeadline->setDecorators($this->_decoratorsDefault);
$this->_nrdeadline->setRequired(false);
$this->_cdcovenant = new Zend_Form_Element_Select('cdcovenant');
$this->_cdcovenant->setAttrib("id", "pricing_cdcovenant");
$this->_cdcovenant->setLabel("Convênio");
$this->_cdcovenant->setDecorators($this->_decoratorsDefault);
$this->_cdcovenant->setRequired(false);
$this->_cdcovenant->setRegisterInArrayValidator(false);
$this->_cdcovenant->addMultiOption("Selecione", '000 - Selecione');
foreach ($covenantData as $covenant) {
$this->_cdcovenant->addMultiOption($covenant->cdcovenant, $covenant->idcovenant . ' - ' . $covenant->nmcovenant);
}
$this->_vlexamination = new Zend_Form_Element_Text('vlexamination');
$this->_vlexamination->setAttrib("id", "pricing_vlexamination");
$this->_vlexamination->setAttrib("maxlength", "22");
$this->_vlexamination->setAttrib("size", "10");
$this->_vlexamination->setLabel("Valor");
$this->_vlexamination->setDecorators($this->_decoratorsDefault);
$this->_vlexamination->setRequired(false);
$this->_vlch = new Zend_Form_Element_Hidden('vlch');
$this->_vlch->setAttrib("id", "pricing_vlch");
$this->_fgbasevalexamination = new Zend_Form_Element_Select('fgbasevalexamination');
$this->_fgbasevalexamination->setAttrib("id", "pricing_basevalexamination");
$this->_fgbasevalexamination->setLabel("Un. Valor");
$this->_fgbasevalexamination->addMultiOptions(array("1" => "CH", "2" => "R\$"));
$this->_fgbasevalexamination->setDecorators($this->_decoratorsDefault);
$this->_fgbasevalexamination->setRequired(false);
$this->_fgauthrequired = new Zend_Form_Element_Checkbox('fgauthrequired');
$this->_fgauthrequired->setAttrib("id", "pricing_fgauthrequired");
$this->_fgauthrequired->setAttrib("value", "1");
$this->_fgauthrequired->setLabel("Solic. Autorização");
$this->_fgauthrequired->setDecorators($this->_decoratorsDefault);
$this->_submitservice = new Zend_Form_Element_Button('submitservice');
$this->_submitservice->setLabel("Adicionar");
$this->_submitservice->setAttrib("id", "pricing_submitservice");
$this->_submitservice->setAttrib("onClick", "save_covenantpricing();");
}
public function autocompletedoctorbycdAction()
{
$term = $this->_request->getParam('term');
$cddoctor = $this->_request->getParam('cddoctor');
$cdpatient = $this->_request->getParam('cdpatient');
$covenantModel = new CovenantModel();
$covenants = $covenantModel->fetchAll($covenantModel->getCovenantByDoctor($cddoctor, $cdpatient, $term));
$json = '[';
$first = true;
foreach ($covenants as $row) {
if (!$first) {
$json .= ',';
} else {
$first = false;
}
$json .= json_encode(array("id" => $row['cdcovenant'], "value" => $row['nmcovenant']));
}
$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 covenantsearchAction()
{
$covenant = $_POST["querySt"];
$covenantModel = new CovenantModel();
$covenantData = $covenantModel->fetchAll('nmcovenant like "%' . $covenant . '%"');
echo "<ul id='sug2'>";
foreach ($covenantData as $row) {
echo '<li onClick="fill2(\'' . $row->cdcovenant . '\', \'' . $row->nmcovenant . '\');"><a href="javascript:void(0);">' . $row->nmcovenant . '</a></li>';
}
echo "</ul>";
}
public function generateprotocolAction($cdrequest = 1)
{
require_once 'fpdf/pdf_protocol.php';
$gslabSession = Zend_Session::namespaceGet('Gslab_Session');
$cdcompany = $gslabSession['user']->cdcompany;
$companyModel = new CompanyModel();
$requestModel = new RequestModel();
$sampleModel = new RequestexaminationsampleModel();
$clientModel = new ClientModel();
$covenantModel = new CovenantModel();
$forwardModel = new ForwardModel();
$examinationModel = new RequestexaminationModel();
$companyData = $companyModel->fetchRow('cdcompany = ' . $cdcompany);
$requestData = $requestModel->fetchRow('cdrequest = ' . $cdrequest);
$sampleData = $sampleModel->fetchRow('cdrequest = ' . $cdrequest);
$clientData = $clientModel->fetchRow('cdclient = ' . $requestData->cdclient);
$covenantData = $covenantModel->fetchRow('cdcovenant = ' . $requestData->cdcovenant);
$forwardData = $forwardModel->fetchRow('cdforward = ' . $requestData->cdforward);
$dtbirth = new Zend_Date($clientData->dtbirth, 'dd-MM-YYYY');
$dtrequest = new Zend_Date($requestData->dtrequest, 'dd-MM-YYYY HH:mm');
$dtdeadline = new Zend_Date($requestData->dtdeadline, 'dd-MM-YYYY HH:mm');
$year = $dtbirth->toString('YYYY');
$month = $dtbirth->toString('MM');
$day = $dtbirth->toString('dd');
$today = new Zend_Date();
$tdYear = $today->toString('YYYY');
$tdMonth = $today->toString('MM');
$tdDay = $today->toString('dd');
$nrage = 0;
$nrage = GslabUtils::calcAgeDifferenceShort($clientData->dtbirth);
$idade = GslabUtils::calcula_idade($clientData->dtbirth);
if ($clientData->fgsex == 1) {
$sexo = 'M';
} else {
$sexo = 'F';
}
if ($tdMonth < $month || $tdMonth == $month && $tdDay < $day) {
$nrage--;
}
$pdf = new PDF_PROTOCOL();
$pdf->AddPage();
$pdf->SetFont('Courier', 'B', 11);
$pdf->ln(55);
$pdf->Cell(0, 0, utf8_decode(strtoupper($companyData->nmcompany)), 0, 1, 'C');
$pdf->Cell(0, 8, utf8_decode('LABORATÓRIO DE ANÁLISES CLÍNICAS'), 0, 2, 'C');
$pdf->Cell(0, -5, str_repeat('_', 81), 0, 1, 'L');
$pdf->ln(8);
$pdf->SetFont('Helvetica', '', 9);
$pdf->Cell(0, 0, utf8_decode(strtoupper($companyData->nmstreet) . ', ' . $companyData->nrnumber), 0, 1, 'L');
$pdf->ln(4);
$pdf->Cell(0, 0, 'COMPROVANTE DE COLETA', 0, 1, 'L');
$pdf->Cell(0, 0, utf8_decode(strtoupper($companyData->nmneighborhood)) . ' - Fone: (47) 3427-3668', 0, 1, 'R');
//ADICIONAR TELEFONE NA BASE
$pdf->ln(4);
$pdf->Cell(0, 0, utf8_decode('Ficha: ') . $requestData->cdcompany . "-" . $requestData->cdrequest, 0, 1, 'L');
$pdf->Cell(0, 0, 'Senha: 2301', 0, 1, 'R');
$pdf->ln(8);
$pdf->Cell(0, 0, utf8_decode('PRONTUÁRIO'), 0, 1, 'L');
$pdf->ln(4);
$pdf->SetFont('Helvetica', '', 10);
$pdf->Cell(15, 5, utf8_decode('Amostra: '), 0, 0, 'L');
$pdf->Cell(0, 5, $pdf->SetFont('Helvetica', 'BU', 10) . $sampleData->nmbarcodesample, 0, 1, 'L');
$pdf->ln(4);
$pdf->SetFont('Helvetica', 'BU', 10);
$pdf->Write(0, utf8_decode(strtoupper($clientData->nmclient)));
$pdf->SetFont('Helvetica', '', 10);
$pdf->ln(8);
$pdf->Write(0, utf8_decode('Idade: ' . $nrage));
$pdf->Write(0, utf8_decode(' Sexo: ' . $sexo));
$pdf->ln(6);
$pdf->Write(0, utf8_decode('Convênio: ' . $covenantData->nmcovenant));
$pdf->ln(6);
$pdf->Write(0, utf8_decode('Médico: ' . $forwardData->idmaincrm . ' - ' . $forwardData->nmforward));
$pdf->ln(6);
$pdf->Write(0, utf8_decode('Coleta: ' . strtoupper($companyData->cdcompany . ' - ' . $companyData->nmfantasyname)));
$pdf->ln(6);
$pdf->Write(0, utf8_decode('Data e Hora: ') . $dtrequest);
$pdf->ln(4);
$pdf->SetFont('Courier', 'B', 11);
$pdf->Cell(0, 0, str_repeat('_', 81), 0, 1, 'L');
/* CAIXA LATERAL */
$pdf->SetFont('Helvetica', '', 10);
$pdf->SetY(89);
$pdf->SetX(90);
$pdf->drawTextBox(utf8_decode('Provável local e data da entrega:
Local: ' . strtoupper($companyData->nmfantasyname) . '
Data: ' . $dtdeadline . '
Salvo quando ocorrer:
1- Imprevistos técnicos
2- Bloqueio de resultado pelo controle de qualidade
3- Atraso no fornecimento de reagentes
Autorizo a coleta do(s) exame(s) acima citado(s) e declaro estar ciente dos riscos quanto ao surgimento de possíveis hematomas no local da punção.
Assinatura do cliente e/ou responsável:__________________________________________'), 109, 50, 'L', 'M');
/* doze exames */
$Exames = $examinationModel->fetchAll($examinationModel->getExaminationProtocol($cdrequest));
$pdf->ln(13);
// Exames
$pdf->SetFont('Helvetica', 'B', 9);
$pdf->SetWidths(array(50, 23, 18));
$pdf->SetX(10);
$pdf->Row(array(utf8_decode('Exames'), utf8_decode('Material'), utf8_decode('Status')));
$pdf->SetFont('Helvetica', '', 9);
$i = 0;
foreach ($Exames as $examination) {
if ($examination['nmmaterial'] == 2) {
$status = 'Faltante';
} else {
$status = 'OK';
}
if ($i == 11) {
$pdf->SetY(148);
}
$pdf->SetX(10);
$pdf->Row(array(utf8_decode($examination['nmexamination']), utf8_decode($examination['nmmaterial']), $status));
$i++;
}
$pdf->ln(5);
/* -------------------------------------------------------------- */
/* PESQUISA DE SATISFAÇÃO */
$pdf->SetFont('Helvetica', '', 7);
$pdf->SetY(205);
$pdf->Cell(0, 0, str_repeat(' -', 125), 0, 1, 'L');
$pdf->SetX(10);
$pdf->Write(5, utf8_decode('Prezado cliente: com o objetivo de melhorarmos cada vez mais a'));
$pdf->ln(3);
$pdf->SetX(10);
$pdf->Write(5, utf8_decode('qualidade dos nossos serviços e o atendimento à você, solicitamos'));
$pdf->ln(3);
$pdf->SetX(10);
$pdf->Write(5, utf8_decode('a sua gentileza preenchendo o formulário abaixo.'));
$pdf->ln(5);
$pdf->SetFont('Helvetica', 'B', 7);
$pdf->SetWidths(array(30, 13, 13, 13, 13));
$pdf->SetX(10);
$pdf->Row(array(utf8_decode('Assinale sua opinião'), utf8_decode('Ótimo'), 'Bom', 'Regular', 'Ruim'));
$pdf->SetFont('Helvetica', '', 7);
$pdf->SetX(10);
$pdf->Row(array(utf8_decode('1. Como foi o atendimento ao telefone?'), '', '', '', ''));
$pdf->SetX(10);
$pdf->Row(array(utf8_decode('2. Como foi o atendimento da recepção?'), '', '', '', ''));
$pdf->SetX(10);
$pdf->Row(array(utf8_decode('3. Quanto ao conforto e bem estar na sala de espera?'), '', '', '', ''));
$pdf->SetX(10);
$pdf->Row(array(utf8_decode('4. Quanto à coleta do material para o exame?'), '', '', '', ''));
$pdf->SetX(10);
$pdf->Row(array(utf8_decode('5. Quanto ao prazo e entrega dos resultados?'), '', '', '', ''));
$pdf->SetY(215);
$pdf->SetX(117);
$pdf->Write(5, utf8_decode('6. Como conheceu o Laboratório? _______________________________'));
$pdf->ln(7);
$pdf->SetX(117);
$pdf->Write(5, utf8_decode('7. Você indicaria o laboratório para outras pessoas? ( ) Sim ( ) Não'));
$pdf->ln(7);
$pdf->SetX(117);
$pdf->Write(5, utf8_decode('Se NÃO, por quê?____________________________________________'));
$pdf->ln(7);
$pdf->SetX(117);
$pdf->Write(5, utf8_decode('8. Conhece nosso '));
$pdf->SetFont('Helvetica', 'BU', 7);
$pdf->Write(5, utf8_decode('Programa de Coleta Domiciliar'));
$pdf->SetFont('Helvetica', '', 7);
$pdf->Write(5, utf8_decode(' (tel: 3433-2127)?'));
$pdf->ln(7);
$pdf->SetX(117);
$pdf->Write(5, utf8_decode('( ) Sim ( ) Não'));
$pdf->ln(7);
$pdf->SetX(117);
$pdf->Write(5, utf8_decode('9. Sugestões e críticas:_______________________________________'));
$pdf->ln(7);
$pdf->SetX(117);
$pdf->Write(5, utf8_decode('__________________________________________________________'));
$pdf->ln(7);
$pdf->SetX(117);
$pdf->Write(5, utf8_decode('__________________________________________________________'));
$pdf->Output();
//IMPRIME O PDF NA TELA
$pdf->Output('teste_pro.pdf', "D");
//IMPRIME O PDF NO ARQUIVO
}
public function __construct()
{
parent::__construct();
$arrayPriority = array('1' => 'Normal', '2' => 'Urgente');
$covenantModel = new CovenantModel();
$selectCovenant = $covenantModel->fetchAll();
$arrayCovenant = array();
$arrayCovenant['0'] = "0";
foreach ($selectCovenant as $selCv) {
$arrayCovenant[$selCv->cdcovenant] = $selCv->nmcovenant;
}
$departmentModel = new DepartmentModel();
$selectDepartment = $departmentModel->fetchAll();
$arrayDepartment = array();
$arrayDepartment['0'] = "0";
foreach ($selectDepartment as $selDP) {
$arrayDepartment[$selDP->cddepartment] = $selDP->nmdepartment;
}
$uncollectionModel = new CompanyModel();
$selectCompany = $uncollectionModel->fetchAll("cdcompanyparent IS NOT NULL");
$arrayuncollection = array();
$arrayuncollection['0'] = "0";
foreach ($selectCompany as $cdplace) {
$arrayuncollection[$cdplace->cdcompany] = $cdplace->nmfantasyname;
}
$fgstatusModel = new RequestexaminationModel();
$selectstatus = $fgstatusModel->fetchAll();
$arrayfgstatus = array();
$arrayfgstatus['0'] = "Selecione";
foreach ($selectstatus as $cdstatus) {
$arrayfgstatus[$cdstatus->cdrequestexamination] = $cdstatus->fgstatus;
}
//Novas...
$this->_departament = new Zend_Form_Element_Select('departament');
$this->_departament->setAttrib("id", "maps_departament");
$this->_departament->setAttrib("class", "check_multiple_select");
$this->_departament->setMultiOptions($arrayDepartment);
$this->_departament->setLabel("Setor");
$this->_departament->setDecorators($this->_decoratorsDefault);
$this->_departament->setRegisterInArrayValidator(true);
$this->_departament->setRequired(true);
$this->_covenant = new Zend_Form_Element_Select('covenant');
$this->_covenant->setAttrib("id", "maps_covenant");
$this->_covenant->setAttrib("class", "check_multiple_select");
$this->_covenant->setMultiOptions($arrayCovenant);
$this->_covenant->setLabel("Convênio");
$this->_covenant->setDecorators($this->_decoratorsDefault);
$this->_covenant->setRegisterInArrayValidator(true);
$this->_covenant->setRequired(true);
$this->_uncollection = new Zend_Form_Element_Select('uncollection');
$this->_uncollection->setAttrib("id", "maps_uncollection");
$this->_uncollection->setAttrib("class", "check_multiple_select");
$this->_uncollection->setMultiOptions($arrayuncollection);
$this->_uncollection->setLabel("Unidade de Coleta");
$this->_uncollection->setDecorators($this->_decoratorsDefault);
$this->_uncollection->setRegisterInArrayValidator(true);
$this->_uncollection->setRequired(true);
$this->_stsample = new Zend_Form_Element_Select('stsample');
$this->_stsample->setAttrib("id", "maps_stsample");
$this->_stsample->setAttrib("class", "multiple_select");
$this->_stsample->setMultiOptions($arrayfgstatus);
$this->_stsample->setLabel("Status Amostra");
$this->_stsample->setDecorators($this->_decoratorsDefault);
$this->_stsample->setRegisterInArrayValidator(true);
$this->_stsample->setRequired(true);
$this->_priority = new Zend_Form_Element_Select('priority');
$this->_priority->setAttrib("id", "maps_priority");
$this->_priority->setAttrib("class", "check_multiple_select");
$this->_priority->setMultiOptions($arrayPriority);
$this->_priority->setLabel("Prioridade");
$this->_priority->setDecorators($this->_decoratorsDefault);
$this->_priority->setRegisterInArrayValidator(true);
$this->_priority->setRequired(true);
$this->_dtstart = new Zend_Form_Element_Text('dtstart');
$this->_dtstart->setAttrib("id", "maps_dtstart");
$this->_dtstart->setAttrib("class", "datepicker");
$this->_dtstart->setLabel("Data Inicial");
$this->_dtstart->setDecorators($this->_decoratorsDefault);
$this->_dtstart->setRequired(false);
$this->_dtend = new Zend_Form_Element_Text('dtend');
$this->_dtend->setAttrib("id", "maps_dtend");
$this->_dtend->setAttrib("class", "datepicker");
$this->_dtend->setLabel("Data Final");
$this->_dtend->setDecorators($this->_decoratorsDefault);
$this->_dtend->setRequired(false);
}
public function __construct()
{
parent::__construct();
$covenantModel = new CovenantModel();
$selectCovenant = $covenantModel->fetchAll();
$arrayCovenant = array();
$arrayCovenant['0'] = "Selecione";
foreach ($selectCovenant as $selCVNT) {
$arrayCovenant[$selCVNT->cdcovenant] = $selCVNT->nmcovenant;
}
$responsibleModel = new UserModel();
$selectUser = $responsibleModel->fetchAll();
$arrayResponsible = array();
$userInfo = Zend_Auth::getInstance()->getStorage()->read();
$nmcollectionplaceModel = new CompanyModel();
$selectCompany = $nmcollectionplaceModel->fetchAll();
$arraynmcollectionplace = array();
$arraynmcollectionplace['0'] = "Selecione";
foreach ($selectCompany as $cdplace) {
$arraynmcollectionplace[$cdplace->cdcompanyparent] = $cdplace->nmfantasyname;
}
// $departmentModel = new DepartmentModel();
// $selectDepartment = $departmentModel->fetchAll();
// $arrayDepartment = array();
// $arrayDepartment['0'] = "Selecione";
// foreach($selectDepartment as $selDP){
// $arrayDepartment[$selDP->cddepartment] = $selDP->nmdepartment;
// }
$departmentModel = new DepartmentModel();
$selectDepartment = $departmentModel->fetchAll();
$arrayDepartment = array();
$arrayDepartment['0'] = "Selecione";
foreach ($selectDepartment as $selDP) {
$arrayDepartment[$selDP->cddepartment] = $selDP->nmdepartment;
}
$this->_fgcdcovenant = new Zend_Form_Element_Select('cdcovenant');
$this->_fgcdcovenant->setAttrib("id", "controltbilling_select");
// $this->_fgcdcovenant->setAttrib("class", "check_multiple_select");
$this->_fgcdcovenant->setMultiOptions($arrayCovenant);
$this->_fgcdcovenant->setLabel("Convênio");
$this->_fgcdcovenant->setDecorators($this->_decoratorsDefault);
$this->_fgcdcovenant->setRegisterInArrayValidator(true);
$this->_fgcdcovenant->setRequired(true);
// select do convenio para a página biilingdata
$this->_fgcdcovenantdata = new Zend_Form_Element_Select('fgcdcovenantdata');
$this->_fgcdcovenantdata->setAttrib("id", "controltbillingdata_fgcdcovenantdata");
$this->_fgcdcovenantdata->setAttrib("class", "nmbillingcss");
$this->_fgcdcovenantdata->setMultiOptions($arrayCovenant);
$this->_fgcdcovenantdata->setLabel("Convênios");
$this->_fgcdcovenantdata->setDecorators($this->_decoratorsDefault);
$this->_fgcdcovenantdata->setRegisterInArrayValidator(true);
$this->_fgcdcovenantdata->setRequired(true);
$this->_nmcollectionplace = new Zend_Form_Element_Select('nmcollectionplace');
$this->_nmcollectionplace->setAttrib("id", "controltbilling_select");
// $this->_nmcollectionplace->setMultiOptions($arrayDocumentData);
$this->_nmcollectionplace->setMultiOptions($arraynmcollectionplace);
$this->_nmcollectionplace->setLabel("Posto de Coleta");
$this->_nmcollectionplace->setDecorators($this->_decoratorsDefault);
$this->_nmcollectionplace->setRegisterInArrayValidator(true);
$this->_nmcollectionplace->setRequired(true);
$this->_nmdepartment = new Zend_Form_Element_Select('nmdepartment');
$this->_nmdepartment->setAttrib("id", "controltbilling_select");
// $this->_nmdepartment->setAttrib("class", "check_multiple_select");
$this->_nmdepartment->setMultiOptions($arrayDepartment);
$this->_nmdepartment->setLabel("Setor");
$this->_nmdepartment->setDecorators($this->_decoratorsDefault);
$this->_nmdepartment->setRegisterInArrayValidator(true);
$this->_nmdepartment->setRequired(true);
$this->_fgstatus = new Zend_Form_Element_Select('fgstatus');
$this->_fgstatus->setAttrib("id", "controltbilling_select");
$this->_fgstatus->setMultiOptions(array("0" => "Selecione", "1" => "Ativo", "2" => "Inativo"));
$this->_fgstatus->setLabel("Status");
$this->_fgstatus->setDecorators($this->_decoratorsDefault);
$this->_fgstatus->setRegisterInArrayValidator(true);
$this->_fgstatus->setRequired(true);
$this->_nmpacient = new Zend_Form_Element_Text('nmpacient');
$this->_nmpacient->setAttrib("id", "controllbilling_nmpacient");
$this->_nmpacient->setAttrib("onkeyup", "lookup(this.value);");
$this->_nmpacient->setAttrib("onblur", "fill();");
$this->_nmpacient->setAttrib("autocomplete", "off");
$this->_nmpacient->setAttrib("size", "50");
$this->_nmpacient->setLabel("Paciente");
$this->_nmpacient->setDecorators($this->_decoratorsDefault);
$this->_nmpacient->setRequired(false);
$this->_responsible = new Zend_Form_Element_Select('responsible');
$this->_responsible->setAttrib("id", "controltbilling_select");
$this->_responsible->setAttrib("class", "controlbilling_responsible");
// $this->_fgcdcovenant->setAttrib("class", "check_multiple_select");
$this->_responsible->setLabel("Responsável");
$arrayResponsible['0'] = "Selecione";
foreach ($selectUser as $userLog) {
/* if ($userInfo->idusergslab == $userLog->idusergslab) {
$arrayResponsible[$userLog->idusergslab] = $userLog->nmusergslab;
} */
$arrayResponsible[$userLog->idusergslab] = $userLog->nmusergslab;
}
$this->_responsible->setMultiOptions($arrayResponsible);
$this->_responsible->setValue($userInfo);
$this->_responsible->setDecorators($this->_decoratorsDefault);
$this->_responsible->setRegisterInArrayValidator(true);
$this->_responsible->setRequired(true);
$this->_responsibledata = new Zend_Form_Element_Select('responsibledata');
$this->_responsibledata->setAttrib("id", "controltbilling_responsible");
$this->_responsibledata->setAttrib("class", "controlbillingdata_responsibledata");
// $this->_fgcdcovenant->setAttrib("class", "check_multiple_select");
$this->_responsibledata->setMultiOptions($arrayResponsible);
$this->_responsibledata->setLabel("Responsável");
$this->_responsibledata->setDecorators($this->_decoratorsDefault);
$this->_responsibledata->setRegisterInArrayValidator(true);
$this->_responsibledata->setRequired(true);
$this->_dtbegindate = new Zend_Form_Element_Text('dtbegindate');
$this->_dtbegindate->setAttrib("id", "controltbilling_dtbegindate");
$this->_dtbegindate->setAttrib("class", "datepicker");
$this->_dtbegindate->setLabel("Data Início");
$this->_dtbegindate->setDecorators($this->_decoratorsDefault);
$this->_dtbegindate->setRequired(false);
$this->_timebeginhour = new Zend_Form_Element_Text('timebeginhour');
$this->_timebeginhour->setLabel("Horário");
$this->_timebeginhour->setDecorators($this->_decoratorsDefault);
$this->_timebeginhour->setAttrib("id", "controltbilling_timebeginhour");
$this->_timebeginhour->setAttrib("class", "mask_time");
$this->_dtenddate = new Zend_Form_Element_Text('dtenddate');
$this->_dtenddate->setAttrib("id", "controltbilling_dtenddate");
$this->_dtenddate->setAttrib("class", "datepicker");
$this->_dtenddate->setLabel("Data Fim");
$this->_dtenddate->setDecorators($this->_decoratorsDefault);
$this->_dtenddate->setRequired(false);
$this->_timeendhour = new Zend_Form_Element_Text('timeendhour');
$this->_timeendhour->setLabel("Horário");
$this->_timeendhour->setDecorators($this->_decoratorsDefault);
$this->_timeendhour->setAttrib("id", "controltbilling_timeendhour");
$this->_timeendhour->setAttrib("class", "mask_time");
//////////////////
$this->_dtbegindatedata = new Zend_Form_Element_Text('dtbegindatedata');
$this->_dtbegindatedata->setAttrib("id", "controltbillingdata_dtbegindatedata");
$this->_dtbegindatedata->setAttrib("class", "datepicker");
$this->_dtbegindatedata->setLabel("Data Início");
$this->_dtbegindatedata->setDecorators($this->_decoratorsDefault);
$this->_dtbegindatedata->setRequired(false);
$this->_timebeginhourdata = new Zend_Form_Element_Text('timebeginhourdata');
$this->_timebeginhourdata->setAttrib("id", "controltbillingdata_timebeginhourdata");
$this->_timebeginhourdata->setLabel("Hora Início");
$this->_timebeginhourdata->setDecorators($this->_decoratorsDefault);
$this->_timebeginhourdata->setRequired(false);
$this->_dtenddatedata = new Zend_Form_Element_Text('dtenddatedata');
$this->_dtenddatedata->setAttrib("id", "controltbillingdata_dtenddatedata");
$this->_dtenddatedata->setAttrib("class", "datepicker");
$this->_dtenddatedata->setLabel("Data Fim");
$this->_dtenddatedata->setDecorators($this->_decoratorsDefault);
$this->_dtenddatedata->setRequired(false);
$this->_timeendhourdata = new Zend_Form_Element_Text('timeendhourdata');
$this->_timeendhourdata->setAttrib("id", "controltbillingdata_timeendhourdata");
$this->_timeendhourdata->setLabel("Hora Fim");
$this->_timeendhourdata->setDecorators($this->_decoratorsDefault);
$this->_timeendhourdata->setRequired(false);
//////////////
$this->_nrlot = new Zend_Form_Element_Text('nrlot');
$this->_nrlot->setAttrib("id", "controltbilling_nrlot");
$this->_nrlot->setLabel("Número do Lote");
$this->_nrlot->setDecorators($this->_decoratorsDefault);
$this->_nrlot->setRequired(false);
$this->_statusbilling = new Zend_Form_Element_Text('statusbilling');
$this->_statusbilling->setAttrib("id", "controltbillingdata_statusbilling");
$this->_statusbilling->setLabel("Status Faturamento");
$this->_statusbilling->setDecorators($this->_decoratorsDefault);
$this->_statusbilling->setRequired(false);
// Numero da fatura
$this->_nmbilling = new Zend_Form_Element_Text('nmbilling');
$this->_nmbilling->setAttrib("id", "controltbillingdata_nmbilling");
$this->_nmbilling->setAttrib("class", "nmbillingcss");
$this->_nmbilling->setLabel("# Fatura");
$this->_nmbilling->setDecorators($this->_decoratorsDefault);
$this->_nmbilling->setRequired(false);
// Numero da Fatura
$this->_nmlotbilling = new Zend_Form_Element_Text('nmlotbilling');
$this->_nmlotbilling->setAttrib("id", "controltbilling__nmlotbilling");
$this->_nmlotbilling->setAttrib("class", "nmlotbillingcss");
$this->_nmlotbilling->setLabel("Nº Lote Fatura");
$this->_nmlotbilling->setDecorators($this->_decoratorsDefault);
$this->_nmlotbilling->setRequired(false);
$this->_dtmaturity = new Zend_Form_Element_Text('dtmaturity');
$this->_dtmaturity->setAttrib("id", "controltbilling_dtmaturity");
$this->_dtmaturity->setAttrib("class", "datepicker");
$this->_dtmaturity->setLabel("Vencimento");
$this->_dtmaturity->setDecorators($this->_decoratorsDefault);
$this->_dtmaturity->setRequired(false);
$this->_dtmaturitydata = new Zend_Form_Element_Text('dtmaturitydata');
$this->_dtmaturitydata->setAttrib("id", "controltbillingdata_dtmaturitydata");
$this->_dtmaturitydata->setAttrib("class", "datepicker");
$this->_dtmaturitydata->setLabel("Vencimento");
$this->_dtmaturitydata->setDecorators($this->_decoratorsDefault);
$this->_dtmaturitydata->setRequired(false);
$this->_accountsreceivable = new Zend_Form_Element_MultiCheckbox('accountsreceivable');
$this->_accountsreceivable->addMultiOption('accountsreceivable', ' Enviar para Contas à Receber');
$this->_accountsreceivable->setAttrib("id", "accountsreceivable");
$this->_accountsreceivable->setAttrib("class", "standartchecklabel");
$this->_accountsreceivable->AddDecorator('HtmlTag', array('tag' => 'li', 'openOnly' => true));
$this->_accountsreceivable->setDecorators(array(array('ViewHelper'), array('HtmlTag', array('tag' => 'li'))));
}
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");
$filters = $this->_request->getParam("filters");
if ($filters != '') {
$data = $this->buildWhereClause($filters);
}
$covenantModel = new CovenantModel();
if (isset($data['sql']) && $data['sql'] != '') {
$covenant = $covenantModel->fetchAll($data['sql']);
$count = count($covenant);
if ($count > 0 && $limit > 0) {
$total_pages = ceil($count / $limit);
$covenant = $covenantModel->fetchAll($data['sql'], "{$sidx} {$sord}", $limit, $page * $limit - $limit);
} else {
$total_pages = 0;
}
if ($page > $total_pages) {
$page = $total_pages;
}
$responce = new stdClass();
$responce->page = $page;
$responce->total = $total_pages;
$responce->records = $count;
} else {
$covenant = $covenantModel->fetchAll();
$count = count($covenant);
if ($count > 0 && $limit > 0) {
$total_pages = ceil($count / $limit);
} else {
$total_pages = 0;
}
if ($page > $total_pages) {
$page = $total_pages;
}
$covenant = $covenantModel->fetchAll(null, "{$sidx} {$sord}", $limit, $page * $limit - $limit);
$responce = new stdClass();
$responce->page = $page;
$responce->total = $total_pages;
$responce->records = $count;
}
$i = 0;
$idcnpj = '';
$desc_fgcovenanttype = '';
//print_r($covenant);
foreach ($covenant as $row) {
switch ($row->fgcovenanttype) {
case 1:
$desc_fgcovenanttype = 'Plano de Saúde';
break;
case 2:
$desc_fgcovenanttype = 'Convênio';
break;
case 3:
$desc_fgcovenanttype = 'Sindicato';
break;
case 4:
$desc_fgcovenanttype = 'Particular';
break;
}
if ($row->idcnpj != '') {
$idcnpj = substr($row->idcnpj, 0, 2) . "." . substr($row->idcnpj, 2, 3) . "." . substr($row->idcnpj, 5, 3) . "/" . substr($row->idcnpj, 8, 4) . "-" . substr($row->idcnpj, 12);
}
if ($row->idcep != '') {
$idcep = substr($row->idcnpj, 0, 5) . "-" . substr($row->idcep, 5);
} else {
$idcep = '';
}
$responce->rows[$i]['cell'] = array($row->cdcovenant, $row->idcovenant, $row->nmcovenant, $idcnpj, $desc_fgcovenanttype, $row->nmstreet, $row->nrnumber, $row->nmneighborhood, $row->idstate, $row->idcity, $idcep, $row->fgcovenanttype, str_replace(".", ",", $row->vlchvalue));
$idcnpj = '';
$desc_fgcovenanttype = '';
$idcep = '';
$i++;
}
$data = '';
$this->view->dados = $responce;
/*
$responce[$i]['id'] = $i+1;
$responce[$i]['code'] = md5(rand(0, 10000));
$responce[$i]['name'] = 'Jonas'.($i+1);
foreach($covenant as $row) {
$responce->rows[$i]['id']=$row->code;
$responce->rows[$i]['cell']=array(
$row->code,
$row->name,
$row->CNPJ,
$row->type
);
$i++;
}
*/
}
public function __construct()
{
parent::__construct();
$userInfo = Zend_Auth::getInstance()->getStorage()->read();
$covenantModel = new CovenantModel();
$selectCovenant = $covenantModel->fetchAll();
$arrayCovenant = array();
$arrayCovenant['0'] = "Selecione";
foreach ($selectCovenant as $selCv) {
$arrayCovenant[$selCv->cdcovenant] = $selCv->nmcovenant;
$arrayCovenantCD[$selCv->cdcovenant] = $selCv->cdcovenant;
}
//Novas...
$this->_covenant = new Zend_Form_Element_Select('covenant');
$this->_covenant->setAttrib("id", "budgetbilling_covenant");
$this->_covenant->setAttrib("class", "check_multiple_select");
$this->_covenant->setMultiOptions($arrayCovenant, $arrayCovenantCD);
$this->_covenant->setLabel("Convênios");
$this->_covenant->setDecorators($this->_decoratorsDefault);
$this->_covenant->setRegisterInArrayValidator(true);
$this->_covenant->setRequired(true);
$this->_examination = new Zend_Form_Element_Text('examination');
$this->_examination->setAttrib("id", "budgetbilling_examination");
$this->_examination->setAttrib("onkeyup", "lookup(this.value);");
$this->_examination->setAttrib("onblur", "fill();");
$this->_examination->setAttrib("autocomplete", "off");
$this->_examination->setLabel("Exame/Material");
$this->_examination->setDecorators($this->_decoratorsDefault);
$this->_examination->setRequired(false);
$this->_idexamination = new Zend_Form_Element_Hidden('idexamination');
$this->_idexamination->setAttrib("id", "budgetbilling_idexamination");
$this->_idexamination->setDecorators($this->_decoratorsDefault);
//$this->_idexamination->setRequired(false);
$this->_cdexamination = new Zend_Form_Element_Hidden('cdexamination');
$this->_cdexamination->setAttrib("id", "budgetbilling_cdexamination");
$this->_cdexamination->setDecorators($this->_decoratorsDefault);
//$this->_cdexamination->setRequired(false);
$this->_sizecols = new Zend_Form_Element_Hidden('sizecols');
$this->_sizecols->setAttrib("id", "sizecols");
$this->_sizecols->setDecorators($this->_decoratorsDefault);
//$this->_cdexamination->setRequired(false);
$this->_cashvalue = new Zend_Form_Element_Text('cashvalue');
$this->_cashvalue->setAttrib("id", "budgetbilling_cashvalue");
$this->_cashvalue->setValue("R\$");
$this->_cashvalue->setAttrib("onfocus", "limpaCampo1();");
$this->_cashvalue->setAttrib("onblur", "returnCampo1();");
$this->_cashvalue->setDecorators($this->_decoratorsDefault);
$this->_cashvalue->setRequired(false);
$this->_percentagevalue = new Zend_Form_Element_Text('percentagevalue');
$this->_percentagevalue->setAttrib("id", "budgetbilling_percentagevalue");
$this->_percentagevalue->setValue("%");
$this->_percentagevalue->setAttrib("onfocus", "limpaCampo2();");
$this->_percentagevalue->setAttrib("onblur", "returnCampo2();");
$this->_percentagevalue->setDecorators($this->_decoratorsDefault);
$this->_percentagevalue->setRequired(false);
$this->_cashvalue2 = new Zend_Form_Element_Text('cashvalue2');
$this->_cashvalue2->setAttrib("id", "budgetbilling_cashvalue2");
$this->_cashvalue2->setValue("R\$");
$this->_cashvalue2->setAttrib("onfocus", "limpaCampo3();");
$this->_cashvalue2->setAttrib("onblur", "returnCampo3();");
$this->_cashvalue2->setDecorators($this->_decoratorsDefault);
$this->_cashvalue2->setRequired(false);
$this->_percentagevalue2 = new Zend_Form_Element_Text('percentagevalue2');
$this->_percentagevalue2->setAttrib("id", "budgetbilling_percentagevalue2");
$this->_percentagevalue2->setValue("%");
$this->_percentagevalue2->setAttrib("onfocus", "limpaCampo4();");
$this->_percentagevalue2->setAttrib("onblur", "returnCampo4();");
$this->_percentagevalue2->setDecorators($this->_decoratorsDefault);
$this->_percentagevalue2->setRequired(false);
$this->_user = new Zend_Form_Element_Text('user');
$this->_user->setAttrib("id", "budgetbilling_user");
$this->_user->setValue($userInfo->nmusergslab);
$this->_user->setDecorators($this->_decoratorsDefault);
$this->_user->setRequired(true);
$this->_covenant2 = new Zend_Form_Element_Select('covenant');
$this->_covenant2->setAttrib("id", "budgetbilling_covenant");
$this->_covenant2->setAttrib("class", "multiple_select");
$this->_covenant2->setMultiOptions($arrayCovenant);
$this->_covenant2->setLabel("Selecione um convênio");
$this->_covenant2->setDecorators($this->_decoratorsDefault);
$this->_covenant2->setRegisterInArrayValidator(true);
$this->_covenant2->setRequired(true);
}
public function covenantbillingdataAction()
{
// FUNÇÃO QUE REALIZA A PESQUISA / FILTROS
$cdcovenant = $this->_request->getParam('cdcovenant');
$cdcompanyparent = $this->_request->getParam('cdcompanyparent');
$dtstart = $this->_request->getParam('dtstart');
$dtend = $this->_request->getParam('dtend');
if (isset($dtstart) && $dtstart != '') {
$dtstart = new Zend_Date($dtstart, 'dd-MM-YYYY HH:mm:ss');
$dtstart = $dtstart->toString('YYYY-MM-dd HH:mm:ss');
}
if (isset($dtend) && $dtend != '') {
$dtend = new Zend_Date($dtend, 'dd-MM-YYYY HH:mm:ss');
$dtend = $dtend->toString('YYYY-MM-dd HH:mm:ss');
}
$responce = 0;
$convenantModel = new CovenantModel();
$clientModel = new ClientModel();
$requestModel = new RequestModel();
$covenantbillingData = $requestModel->fetchAll($requestModel->getRequestsUnbilled($cdcovenant, $cdcompanyparent, $dtstart, $dtend));
$responce = new stdClass();
if (count($covenantbillingData) > 0) {
$i = 0;
foreach ($covenantbillingData as $rows) {
$nmclient = '';
$cdclient = '';
$nmconvenant = '';
$cdcovenant = '';
$rows['dtrequest'] = new Zend_Date($rows['dtrequest'], 'YYYY-MM-dd HH:mm:ss');
$rows['dtrequest'] = $rows['dtrequest']->toString('dd/MM/yyyy');
if ($rows['cdclient'] != null) {
$clientData = $clientModel->fetchRow('cdclient=' . $rows['cdclient']);
$nmclient = $clientData['nmclient'];
$cdclient = $clientData['cdclient'];
}
if ($rows['cdcovenant'] != null) {
$convenantData = $convenantModel->fetchRow('cdcovenant=' . $rows['cdcovenant']);
$nmconvenant = $convenantData->nmcovenant;
$cdcovenant = $convenantData['cdcovenant'];
}
$responce->rows[$i]['cdrequest'] = $rows['cdrequest'];
$responce->rows[$i]['cell'] = array($rows['cdrequest'], $rows['dtrequest'], $nmclient, $nmconvenant, $rows['nrguide'], $cdclient, $cdcovenant);
$i++;
}
$this->view->covenantbillingdata = $responce;
} else {
$this->view->covenantbillingdata = 'vazio';
}
}
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;
}
