public function selectedpricingAction()
 {
     $this->_helper->layout->disableLayout();
     $covenantModel = new CovenantpricingModel();
     $examinationModel = new ExaminationModel();
     $cdcovenant = $this->_request->getParam('cdcovenant');
     $examinationDados = $covenantModel->fetchAll($covenantModel->getCovenantExamination($cdcovenant));
     $examinationDadosNN = $examinationModel->fetchAll($examinationModel->getCovenantExaminationNN($cdcovenant));
     $opt = '';
     $i = 0;
     $response = new stdClass();
     if ($examinationDadosNN->count() > 0) {
         foreach ($examinationDadosNN as $examination) {
             $opt .= "<option value='" . $examination['cdexamination'] . "'>" . $examination['nmexamination'] . "</option>";
         }
         foreach ($examinationDados as $row) {
             if ($row['fgauthrequired'] == '2') {
                 $fg = '0';
             } else {
                 $fg = '1';
             }
             $response->rows[$i]['cell'] = array($row['cdcovenant'], $row['cdexamination'], $row['idcovenant'] . " - " . $row['nmcovenant'], $row['nmexamination'], $row['vlexamination'], $row['vlchdefault'], $row['fgbasevalexamination'], $row['nrdeadline'], $fg);
             $i++;
             $response->chvalue = $row['vlchvalue'];
         }
         $response->options = $opt;
         $result = json_encode($response);
         print_r($result);
         return $result;
     } else {
         $response = new stdClass();
         $response->options = "empty";
         $response->rows = "empty";
         $result = json_encode($response);
         print_r($result);
         return $result;
     }
 }