Пример #1
0
 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;
 }