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;
}
private function _verifySign($domain, $text, $sign)
{
include_once KFL_DIR . '/Libs/Cache.class.php';
$filename = $domain . ".txt";
$cache = new Cache(86400 * 300, 0);
$cache->setCacheStore("file");
// or memcache
$cache->setCacheDir(APP_TEMP_DIR);
$cache->setCacheFile($filename);
if ($cache->isCached()) {
$client = unserialize($cache->fetch());
} else {
require_once 'ClientModel.class.php';
$ClientModel = new ClientModel();
$client = $ClientModel->getClientByName($domain);
if ($client) {
$cache->save(serialize($client));
} else {
return false;
}
}
$this->_private_key = $client['private_key'];
if (hmac($this->_private_key, $text, 'sha1') == $sign) {
return true;
} else {
return false;
}
}
function op_delclient()
{
$t = true;
if (isset($_POST['delete']) && is_array($_POST['delete'])) {
include_once "ClientModel.class.php";
$clientModel = new ClientModel();
foreach ($_POST['delete'] as $u) {
$t *= $clientModel->deleteClient($u);
}
if ($t) {
show_message_goback(lang('success'));
}
}
show_message(lang('selectone'));
goback();
}
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);
}
</ul>
<div id="toolplate_session">
<b><p1>Welcome</p1> </style>:<p2> <i><?php
echo $login_session;
?>
</i></p2></b>
<b id="logout"><a href="logout.php"><p1>Log Out</p1></a></b>
</div>
</div>
</div><!-- End of Header-->
<div id="tooplate_main">
<div id="tooplate_content" >
<div id="tooplate_contentusers" >
<div id="tooplate_contentusers" style="overflow-y: scroll; height:500px;" >
<?php
include '../model/ClientModel.php';
$model = new ClientModel();
$model->viewClients();
?>
</div>
</div>
</div>
</div>
<div id="tooplate_footer">
Copyright © 2015 <a href="http://www.eedadvisory.com" target="_blank">EED Advisory Limited </a> | Designed for Household Energy Data Aggregator (HEDA).
</div>
</div><!-- End of Wrapper-->
</body>
</html>
function getEnergyUsage()
{
$db = $this->conn;
$result = mysqli_query($db, "SELECT * FROM incoming_messages WHERE deleted=0 ORDER BY date_received DESC ");
echo "<table width = '880' border='0' class='table_s1' >";
echo "<th width='10'>#</th>";
echo '<th>Respondent</th>';
echo "<th>Fuel</th>";
echo "<th>Amount (Kg)</th>";
echo "<th>Date</th>";
echo "<tbody>";
$num = 0;
while ($row = mysqli_fetch_array($result)) {
$num++;
echo "<tr>";
echo "<td>";
echo $num . '.';
echo "</td>";
echo "<td>";
$model = new ClientModel();
$mobNum = $row['sender_number'];
$name = $model->getClientNameByMobNum($mobNum);
echo $name;
echo "</td>";
echo "<td>";
$id = $row['energy_id'];
$message = $this->getFuelName($id);
echo $message;
echo "</td>";
echo "<td>";
echo $row['amount'];
echo "</td>";
echo "<td>";
echo $row['date_received'];
echo "</td>";
echo "</tr>";
echo "</tbody>";
}
echo "</table>";
}
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>";
}
<!DOCTYPE html>
<!--
To change this license header, choose License Headers in Project Properties.
To change this template file, choose Tools | Templates
and open the template in the editor.
-->
<?php
include '../model/ClientModel.php';
function test_input($data)
{
$data = trim($data);
$data = stripslashes($data);
$data = htmlspecialchars($data);
return $data;
}
$model = new ClientModel();
$error = "";
$id = $first_name = $second_name = $last_name = $gender = $passport = $country = $region = $province = $county = $district = $division = $location = $nearest_town = $postal_address = $postal_town = $mobile = $email = $marital_status = $family_size = $rooms = $connected = $distance = $energy_source = $gps = $household_head = $household_category = $building_materials = $income_sources = $main_income_source = $monthly_income = $cooking_methods = $cooking_frequency = $cooking_type = $lighting_methods = $lighting_duration = $rooms_lit = "";
$first_nameErr = $second_nameErr = $last_nameErr = $genderErr = $passportErr = $countryErr = $regionErr = $provinceErr = $countyErr = $districtErr = $divisionErr = $locationErr = $nearest_townErr = $postal_addressErr = $postal_townErr = $mobileErr = $emailErr = $marital_statusErr = $family_sizeErr = $roomsErr = $connectedErr = $distanceErr = $energy_sourceErr = $gpsErr = $household_headErr = $household_categoryErr = $building_materialsErr = $income_sourcesErr = $main_income_sourceErr = $monthly_incomeErr = $cooking_methodsErr = $cooking_frequencyErr = $cooking_typeErr = $lighting_methodsErr = $lighting_durationErr = $rooms_litErr = "";
if ($_SERVER["REQUEST_METHOD"] == "POST") {
if (isset($_POST['edit-client'])) {
$id = $_POST['id'];
$first_name = test_input($_POST["first_name"]);
$second_name = test_input($_POST["second_name"]);
$last_name = test_input($_POST['last_name']);
$gender = $_POST['gender'];
$passport = $_POST['passport'];
$country = $_POST['country'];
$province = $_POST['region'];
$county = $_POST['county'];
$district = $_POST["district"];
public function printcardAction()
{
$cdclient = $this->_request->getParam("cdclient");
$clientModel = new ClientModel();
$clientCode = $clientModel->fetchRow('cdclient = ' . $cdclient);
$array = array();
$array['nome'] = $clientCode->nmclient;
$data = new Zend_Date($clientCode->dtbirth, "YYYY-MM-dd HH:mm:ss");
$clientCode->dtbirth = $data->toString('dd-MM-YYYY');
$array['nascimento'] = $clientCode->dtbirth;
if ($clientCode->fgbloodtype == 1) {
$array['sangue'] = 'O';
} else {
if ($clientCode->fgbloodtype == 2) {
$array['sangue'] = 'A';
} else {
if ($clientCode->fgbloodtype == 3) {
$array['sangue'] = 'B';
} else {
if ($clientCode->fgbloodtype == 0) {
$array['sangue'] = '';
}
}
}
}
if ($clientCode->fgrhfactor == 1) {
$array['RH'] = 'Positivo';
} else {
if ($clientCode->fgrhfactor == 2) {
$array['RH'] = 'Negativo';
} else {
if ($clientCode->fgrhfactor == 0) {
$array['RH'] = '';
}
}
}
echo "<div id='div_box'>\r\n Nome: " . ucwords(strtolower($array['nome'])) . "<br>\r\n Data de Nascimento: " . $array['nascimento'] . "<br>\r\n Grupo Sanguíneo: " . $array['sangue'] . "<br>\r\n Fator RH: " . $array['RH'] . "<br>\r\n </div>";
}
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
}
$objPHPExcel->getActiveSheet()->getStyle($header)->getFill()->setFillType(\PHPExcel_Style_Fill::FILL_SOLID)->getStartColor()->setARGB('00ffff00');
$style = array('font' => array('bold' => true), 'alignment' => array('horizontal' => \PHPExcel_Style_Alignment::HORIZONTAL_LEFT));
$objPHPExcel->getActiveSheet()->getStyle($header)->applyFromArray($style);
// Miscellaneous glyphs, UTF-8
$num = 1;
$x = 2;
while ($row = mysqli_fetch_array($result)) {
$head = 'A' . $x . ':D' . $x;
$objPHPExcel->getActiveSheet()->getStyle($head)->getFill()->setFillType(\PHPExcel_Style_Fill::FILL_SOLID)->getStartColor()->setARGB('00ffcccc');
$style = array('font' => array('bold' => false), 'alignment' => array('horizontal' => \PHPExcel_Style_Alignment::HORIZONTAL_GENERAL));
$objPHPExcel->getActiveSheet()->getStyle($head)->applyFromArray($style);
$x += 2;
$id = $row['energy_id'];
$fuelName = $message->getFuelName($id);
$amount = $row['amount'];
$model = new ClientModel();
$mobNum = $row['sender_number'];
$name = $model->getClientNameByMobNum($mobNum);
$date = $row['date_received'];
$num++;
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('A' . $num, $name)->setCellValue('B' . $num, $fuelName)->setCellValue('C' . $num, $amount)->setCellValue('D' . $num, $date);
}
$objPHPExcel->getActiveSheet()->getColumnDimensionByColumn(0)->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimensionByColumn(1)->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimensionByColumn(2)->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimensionByColumn(3)->setAutoSize(true);
//$objPHPExcel->getActiveSheet()->getStyle('A8')->getAlignment()->setWrapText(true);
// Rename worksheet
//echo date('H:i:s'), " Rename worksheet", EOL;
$objPHPExcel->getActiveSheet()->setTitle('Simple');
// Set active sheet index to the first sheet, so Excel opens this as the first sheet
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 static function countryList()
{
// -- Return a list of COuntries
// -----------------------------
$results = array();
$results = \ClientModel::countryList();
return $results;
}
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 post_search()
{
// -- Search for a Client
// ----------------------
$this->template->title = 'Client Search';
$data['titles'] = ClientClass::titleList();
$data['countries'] = ClientClass::countryList();
if (isset($_POST)) {
$seachValues = array();
foreach ($_POST as $key => $value) {
if ($value != '' && $key != 'Search') {
$seachValues[$key] = $value;
}
}
// -- Return search results
// ------------------------
$results = array();
$results = \ClientModel::clientSearch($seachValues);
// -- If results returned, then loop through and assign them to an array;
// ----------------------------------------------------------------------
if (!empty($results) > 0) {
$clients = array();
foreach ($results as $result) {
$clients[] = ClientClass::forge($result['id']);
}
}
}
$this->template->content = View::forge(static::$_viewPath . '/index.php', $data);
}
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;
}
<?php
if (isset($_POST['delete-client'])) {
include '../model/ClientModel.php';
$model = new ClientModel();
$id = $_POST['id'];
if ($model->deleteClient($id)) {
header("location: clients.php");
}
} else {
if (isset($_POST['delete-system-message'])) {
include '../model/Messages.php';
$model = new Messages();
$id = $_POST['id'];
if ($model->deleteSystemMessages($id)) {
header("location: system-messages.php");
}
} else {
if (isset($_POST['delete-user'])) {
require_once '../model/SystemUsers.php';
$model = new SystemUsersModel();
$id = $_POST['id'];
if ($model->deleteUser($id)) {
header("location: users.php");
}
}
}
}
?>
