public function requestexaminationsamplesaveAction()
{
$values = $this->_request->getParams();
if (isset($values['dtcollection']) != '') {
$values['dtcollection'] = new Zend_Date($values['dtcollection'], 'dd-MM-YYYY HH:mm:ss');
$values['dtcollection'] = $values['dtcollection']->toString('YYYY-MM-dd HH:mm:ss');
$values['fgstatus'] = 1;
} else {
$values['fgstatus'] = 2;
}
// print_r($values);
$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 (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 {
$examinationMaterialRequestModel->delete("cdrequestexamination = " . $values['id']);
$requestExaminationModel->delete("cdrequestexamination = " . $values['id']);
}
}
$requestExaminationModel->getAdapter()->commit();
} catch (exception $e) {
$requestExaminationModel->getAdapter()->rollback();
}
}
