public function savelineeditingsupplyexaminationmaterialAction() { $values = $this->_request->getParams(); $array = array(); if (isset($values["fgbilling"])) { if ($values["fgbilling"] == 'Sim') { $values["fgbilling"] = 1; } else { $values["fgbilling"] = 2; } } $supplyMaterialModel = new SupplyexaminationmaterialModel(); $columns = $supplyMaterialModel->info(Zend_Db_Table_Abstract::COLS); $supplyMaterialModel->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($array) && !empty($array)) { $supplyMaterialModel->update($array, "cdsupply = " . $values['cdsupply'] . " AND cdexaminationmaterial = " . $values['cdexaminationmaterial']); $supplyMaterialModel->getAdapter()->commit(); } } catch (Exception $e) { $supplyMaterialModel->getAdapter()->rollback(); } }