public function saveAction() { $this->_model->getAdapter()->beginTransaction(); $paramSample = $this->_request->getParam('data'); // print_r($paramSample); die; $date = $this->_request->getParam('date'); $time = $this->_request->getParam('time'); $delivery = $this->_request->getParam('delivery'); $cdusergslab = $this->_request->getParam('cdusergslab'); $paramSampleArray = array(); $RequestArray = array(); $modelRequest = new RequestexaminationModel(); try { $date = new Zend_Date($date, 'dd-MM-YY'); $date = $date->toString('YYYY-MM-dd'); foreach ($paramSample as $row) { $paramSampleArray = array('cdrequestexaminationsample' => $row['cdreqexasam'], 'cdusergslab' => $cdusergslab, 'dtsamplereceivingdate' => $date, 'nmsamplereceivingperson' => $delivery); $RequestArray = array('fgstatus' => 1); $this->_model->insert($paramSampleArray); $modelRequest->update($RequestArray, "cdrequestexamination = " . $row['cdrequestexamination']); $fgstatus = 1; } $message = 'Cadastro efetuado com sucesso'; $this->_model->getAdapter()->commit(); } catch (Exception $e) { $message = "Erro na inserção dos dados." + $e->getMessage(); $this->_model->getAdapter()->rollBack(); } $this->view->fgstatus = $fgstatus; }
public function saveallAction() { $AppraisalData = $this->_request->getParam('allAppraisalData'); $dscomment = $this->_request->getParam('dscomment'); $userSession = Zend_Session::namespaceGet('Gslab_Session'); $dateAppraisalTyping = date('Y-m-d'); $bootstrap = $this->getInvokeArg('bootstrap'); $gslab_db = $bootstrap->getResource('db'); $cdappraisalArray = array(); $appraisalModel = new AppraisalModel(); $appraisalcommentModel = new AppraisalcommentModel(); $appraisalattributeModel = new AppraisalattributeModel(); $requestexaminationModel = new RequestexaminationModel(); $gslab_db->beginTransaction(); try { foreach ($AppraisalData as $appr) { $arrayAppraisal = array(); $arrayAppraisal['cdrequest'] = $appr[1]; $arrayAppraisal['cdusergslab'] = $userSession['user']->cdusergslab; $arrayAppraisal['dtappraisaltyping'] = $dateAppraisalTyping; $cdappraisal = $appraisalModel->insert($arrayAppraisal); if (strlen($appr[0]) == 0) { // Insere Observação $arrayAppraisalComment = array(); $arrayAppraisalComment['cdappraisal'] = $cdappraisal; $arrayAppraisalComment['dscomment'] = $dscomment; $appraisalcommentModel->insert($arrayAppraisalComment); foreach ($appr[3] as $appAttr) { if ($appAttr['name'] != 'cdappraisaltyping') { // Explode a string em um Array onde as posições: // 0 - CdRequestExamination; 1 - CdExamination; 2 - CdAttribute; 3 - CdExaminationMaterial $txtidentifier = "appraisal_input_"; $identifierAppraisal = str_replace($txtidentifier, "", $appAttr['name']); $arrayIdent = explode("_", $identifierAppraisal); $arrayAppraisalAttribute = array(); $arrayAppraisalAttribute['cdrequestexamination'] = $arrayIdent[0]; $arrayAppraisalAttribute['cdappraisal'] = $cdappraisal; $arrayAppraisalAttribute['cdattribute'] = $arrayIdent[2]; $arrayAppraisalAttribute['cdexaminationmaterial'] = $arrayIdent[3]; $arrayAppraisalAttribute['vlattribute'] = $appAttr['value']; $appraisalattributeModel->insert($arrayAppraisalAttribute); $requestexaminationModel->update(array("fgstatus" => 5), "cdrequestexamination = {$appr['2']}"); } } $cdappraisalArray[] = $cdappraisal; } else { $appraisalattributeModel->delete("cdappraisal = {$appr['0']}"); $appraisalcommentModel->delete("cdappraisal = {$appr['0']}"); if (strlen($appr[4]) > 0) { // Insere Observação $arrayAppraisalComment = array(); $arrayAppraisalComment['cdappraisal'] = $appr[0]; $arrayAppraisalComment['dscomment'] = $appr[4]; $appraisalcommentModel->insert($arrayAppraisalComment); } foreach ($appr[3] as $appAttr) { if ($appAttr['name'] != 'cdappraisaltyping') { // Explode a string em um Array onde as posições: // 0 - CdRequestExamination; 1 - CdExamination; 2 - CdAttribute; 3 - CdExaminationMaterial $txtidentifier = "appraisal_input_"; $identifierAppraisal = str_replace($txtidentifier, "", $appAttr['name']); $arrayIdent = explode("_", $identifierAppraisal); $arrayAppraisalAttribute = array(); $arrayAppraisalAttribute['cdrequestexamination'] = $arrayIdent[0]; $arrayAppraisalAttribute['cdappraisal'] = $appr[0]; $arrayAppraisalAttribute['cdattribute'] = $arrayIdent[2]; $arrayAppraisalAttribute['cdexaminationmaterial'] = $arrayIdent[3]; $arrayAppraisalAttribute['vlattribute'] = $appAttr['value']; $appraisalattributeModel->insert($arrayAppraisalAttribute); $requestexaminationModel->update(array("fgstatus" => 5), "cdrequestexamination = {$appr['2']}"); } } $cdappraisalArray[] = $appr[0]; } } $gslab_db->commit(); $return[0] = 1; $return[1] = "Todas os resultados digitados foram salvos com sucesso!"; $return[2] = $cdappraisalArray; $this->view->saveall = $return; } catch (Exception $e) { $gslab_db->rollback(); $return[0] = 0; $return[1] = "Os resultados digitados não puderam ser salvos!"; $return[2] = ''; $this->view->saveall = $return; } }
public function editexaminationdataAction() { $values = $this->_request->getParams(); if (isset($values['dtcollection']) != '') { $values['dtcollection'] = GslabUtils::dateToDatabaseFormat($values['dtcollection']); $values['fgstatus'] = 1; } else { $values['fgstatus'] = 2; } if (isset($values['dtresult']) != '') { $values['dtresult'] = GslabUtils::dateToDatabaseFormat($values['dtresult']); } $array = array(); $requestExaminationModel = new RequestexaminationModel(); $examinationMaterialRequestModel = new ExaminationmaterialrequestModel(); $columns = $requestExaminationModel->info(Zend_Db_Table_Abstract::COLS); $requestExaminationModel->getAdapter()->beginTransaction(); try { foreach ($values as $id => $value) { if (isset($value) && $value != '' && $value != '0' && in_array($id, $columns)) { $array[$id] = addslashes($value); } else { if (in_array($id, $columns)) { $array[$id] = null; } } } if (isset($values['fgpriority'])) { if ($values['fgpriority'] == 'Sim') { $array['fgpriority'] = 1; } else { $array['fgpriority'] = 2; } } if (empty($array) && $values['oper'] != 'del') { throw new Exception('Dados Incorretos. Confira seus dados e Tente Novamente.'); } else { if ($values['oper'] != 'del') { $requestExaminationModel->update($array, "cdrequestexamination = " . $values['cdrequestexamination']); } else { // Apenas altera o status da amostra para "Inativo" no lugar de DELETA-LO do banco de dados $requestExaminationModel->update(array("fgstatus" => 0), "cdrequestexamination = " . $values['id']); // $examinationMaterialRequestModel->delete("cdrequestexamination = ".$values['id']); // $requestExaminationModel->delete("cdrequestexamination = ".$values['id']); } } $requestExaminationModel->getAdapter()->commit(); } catch (exception $e) { $requestExaminationModel->getAdapter()->rollback(); $this->addMessage($e->getMessage()); } }
public function saveAction() { //print_r($_POST);die; $this->_model->getAdapter()->beginTransaction(); $paramApp = $this->_request->getParam('data'); $request = $this->_request->getParam('request'); $delivery = $this->_request->getParam('delivery'); $date = $this->_request->getParam('date'); $time = $this->_request->getParam('time'); //$RequestArray = array(); try { $date = new Zend_Date($date, 'dd-MM-YY'); $date = $date->toString('YYYY-MM-dd'); $date = $date . " " . $time . ":00"; $paramAppArray = array('cdrequest' => $request, 'nmdeliveryperson' => $delivery, 'dtappraisaldelivery' => $date); $this->_model->insert($paramAppArray); $message = 'Cadastro efetuado com sucesso'; $this->_model->getAdapter()->commit(); } catch (Exception $e) { $message = "Erro na inserção dos dados." + $e->getMessage(); $this->_model->getAdapter()->rollBack(); } $this->view->message = $message; $modelRequest = new RequestexaminationModel(); $RequestArray = array('fgstatus' => 6); $modelRequest->update($RequestArray, "fgstatus = 5"); }
public function saveAction() { $bootstrap = $this->getInvokeArg('bootstrap'); $gslab_db = $bootstrap->getResource('db'); $deliveryModel = new AppraisaldeliveryModel(); $modelRequest = new RequestexaminationModel(); $gslab_db->beginTransaction(); $paramApp = $this->_request->getParam('data'); $request = $this->_request->getParam('request'); $delivery = $this->_request->getParam('delivery'); $date = $this->_request->getParam('date'); $time = $this->_request->getParam('time'); $dtdelivery = GslabUtils::dateToDatabaseFormat($date); $datahora = substr($dtdelivery, 0, -8); try { $paramAppArray = array('cdrequest' => $request, 'nmdeliveryperson' => $delivery, 'dtappraisaldelivery' => $datahora . $time . ":00"); $deliveryModel->insert($paramAppArray); $message = 'Cadastro efetuado com sucesso'; $gslab_db->commit(); } catch (Exception $e) { $message = "Erro na inserção dos dados." + $e->getMessage(); $this->_model->getAdapter()->rollBack(); } $this->view->message = $message; $RequestArray = array('fgstatus' => 6); $modelRequest->update($RequestArray, "cdrequest = " . $request . " AND fgstatus = 5"); }
public function saveAction() { $AppraisalData = $this->_request->getParam('AppraisalData'); $cdRequest = $this->_request->getParam('cdrequest'); $cdRequestExamination = $this->_request->getParam('cdrequestexamination'); $dscomment = $this->_request->getParam('dscomment'); $userSession = Zend_Session::namespaceGet('Gslab_Session'); $dateAppraisalTyping = date('Y-m-d'); $bootstrap = $this->getInvokeArg('bootstrap'); $gslab_db = $bootstrap->getResource('db'); $appraisalModel = new AppraisalModel(); $appraisalattributeModel = new AppraisalattributeModel(); $appraisalcommentModel = new AppraisalcommentModel(); $requestexaminationModel = new RequestexaminationModel(); $gslab_db->beginTransaction(); try { $arrayAppraisal = array(); $arrayAppraisal['cdrequest'] = $cdRequest; $arrayAppraisal['cdusergslab'] = $userSession['user']->cdusergslab; $arrayAppraisal['dtappraisaltyping'] = $dateAppraisalTyping; $appraisalModel->insert($arrayAppraisal); $cdappraisal = $appraisalModel->getAdapter()->lastInsertId(); // Insere Observação $arrayAppraisalComment = array(); $arrayAppraisalComment['cdappraisal'] = $cdappraisal; $arrayAppraisalComment['dscomment'] = $dscomment; $appraisalcommentModel->insert($arrayAppraisalComment); foreach ($AppraisalData as $appAttr) { if ($appAttr['name'] != 'cdappraisaltyping') { // Explode a string em um Array onde as posições: // 0 - CdRequestExamination; 1 - CdExamination; 2 - CdAttribute; 3 - CdExaminationMaterial $txtidentifier = "appraisal_input_"; $identifierAppraisal = str_replace($txtidentifier, "", $appAttr['name']); $arrayIdent = explode("_", $identifierAppraisal); $arrayAppraisalAttribute = array(); $arrayAppraisalAttribute['cdrequestexamination'] = $arrayIdent[0]; $arrayAppraisalAttribute['cdappraisal'] = $cdappraisal; $arrayAppraisalAttribute['cdattribute'] = $arrayIdent[2]; $arrayAppraisalAttribute['cdexaminationmaterial'] = $arrayIdent[3]; $arrayAppraisalAttribute['vlattribute'] = $appAttr['value']; $appraisalattributeModel->insert($arrayAppraisalAttribute); } } $requestexaminationModel->update(array("fgstatus" => 4), "cdrequestexamination = {$cdRequestExamination}"); $gslab_db->commit(); $return[0] = 1; $return[1] = "Digitação salva com sucesso!"; $return[2] = $cdappraisal; $this->view->save = $return; } catch (Exception $e) { $gslab_db->rollback(); $return[0] = 0; $return[1] = "A Digitação não pode ser salva!"; $return[2] = null; $this->view->save = $return; } }