public function saveAction()
{
$values = $this->_request->getParam('search');
$values = json_decode($values, true);
$arrayDepartment = array();
$arrayUniqueDepartment = array();
$arrayCovenant = array();
$arrayCollection = array();
$arrayPriorityexploded = array();
$arrayPriority = array();
$dtstartqry = null;
$dtendqry = null;
if (isset($values['cddepartment']) && ($values['cddepartment'] != '0' && $values['cddepartment'] != '')) {
$arrayDepartment = explode(',', $values['cddepartment']);
}
if (isset($values['cdcovenant']) && ($values['cdcovenant'] != '0' && $values['cdcovenant'] != '')) {
$arrayCovenant = explode(',', $values['cdcovenant']);
}
if (isset($values['collection']) && ($values['collection'] != '0' && $values['collection'] != '')) {
$arrayCollection = explode(',', $values['collection']);
}
if (isset($values['fgpriority']) && ($values['fgpriority'] != '0' && $values['fgpriority'] != '')) {
$arrayPriorityexploded = explode(',', $values['fgpriority']);
foreach ($arrayPriorityexploded as $priority) {
if ($priority == 'Normal') {
$arrayPriority[] = 0;
} else {
if ($priority == 'Urgente') {
$arrayPriority[] = 1;
}
}
}
}
if (isset($values['dtstartqry']) && ($values['dtstartqry'] != '0' && $values['dtstartqry'] != '')) {
$dtstartqry = new Zend_Date($values['dtstartqry'], 'dd-MM-YYYY');
$dtstartqry = $dtstartqry->toString('YYYY-MM-dd');
}
if (isset($values['dtendqry']) && ($values['dtendqry'] != '0' && $values['dtendqry'] != '')) {
$dtendqry = new Zend_Date($values['dtendqry'], 'dd-MM-YYYY');
$dtendqry = $dtendqry->toString('YYYY-MM-dd');
}
if (!($arrayDepartment == null && $arrayCovenant == null && $arrayCollection == null && $arrayPriorityexploded == null && $arrayPriority == null && $dtstartqry == null && $dtendqry == null)) {
// Realiza a mesma consulta feita para a Pré-Visualização
$requestExaminationSampleModel = new RequestexaminationsampleModel();
$mapdataReturn = $requestExaminationSampleModel->fetchAll($requestExaminationSampleModel->getMapData($arrayDepartment, $arrayCovenant, $arrayCollection, $arrayPriority, $dtstartqry, $dtendqry));
foreach ($mapdataReturn as $uniqueDepartment) {
$arrayUniqueDepartment[] = $uniqueDepartment['cddepartment'];
}
$arrayUniqueDepartment = array_unique($arrayUniqueDepartment);
// Salva no Banco como Mapa de Trabalho os dados consultados
$mapModel = new MapsModel();
$mapSampleModel = new MapsampleModel();
$requestionExaminationModel = new RequestExaminationModel();
$dtGeneric = new Zend_Date();
$dtNow = $dtGeneric->get('YYYY-MM-dd HH:mm:ss');
$mapModel->getAdapter()->beginTransaction();
try {
foreach ($arrayUniqueDepartment as $singleDepartment) {
$arrayMap = array('cddepartment' => $singleDepartment, 'fgmapprinted' => '2', 'dtmaprendering' => $dtNow);
$mapModel->insert($arrayMap);
$lastMapInserted = $mapModel->getAdapter()->lastInsertId();
foreach ($mapdataReturn as $singleSample) {
if ($singleSample['cddepartment'] == $singleDepartment) {
$arrayMapSample = array('cdmap' => $lastMapInserted, 'cdrequestexaminationsample' => $singleSample['cdrequestexaminationsample'], 'nrmappage' => '1');
$mapSampleModel->insert($arrayMapSample);
$requestionExaminationModel->update(array("fgstatus" => 3), "cdrequestexamination = " . $singleSample['cdrequestexamination']);
}
}
}
$mapModel->getAdapter()->commit();
$this->view->msgreturn = 1;
} catch (Exception $e) {
$mapModel->getAdapter()->rollback();
$this->view->msgreturn = 2;
}
}
}
public function covenantbillingroupexaminationdataAction()
{
$cdrequest = $this->_request->getParam('id');
$requestExaminationModel = new RequestExaminationModel();
$requestexaminationData = $requestExaminationModel->fetchAll('cdrequest = ' . $cdrequest);
$responce = new stdClass();
$i = 0;
foreach ($requestexaminationData as $rows) {
if ($rows['cdrequestexamination'] != null) {
$examinationparticularData = $requestExaminationModel->fetchRow($requestExaminationModel->getRequestExamination($rows['cdrequestexamination']));
$vlexaminationparticular = $examinationparticularData['vlexamination'];
$nmexamination = $examinationparticularData['nmexamination'];
$idexamination = $examinationparticularData['idexamination'];
$requestExamination = $examinationparticularData['cdrequestexamination'];
}
if (count($examinationparticularData) > 0) {
$responce->rows[$i]['cdrequest'] = $rows['cdrequest'];
$responce->rows[$i]['cell'] = array($rows['cdrequest'], $idexamination, $nmexamination, $vlexaminationparticular, $rows['cdrequestexamination']);
$i++;
}
}
$this->view->covenantbillingroupexaminationdata = $responce;
}
