public function additionalsupplyrequestAction() { $value = $this->_request->getParam('examinationmaterials'); $SupplyexaminationmaterialModel = new SupplyexaminationmaterialModel(); $supplyexaminationmaterialData = $SupplyexaminationmaterialModel->fetchAll($SupplyexaminationmaterialModel->getSupplyExaminationMaterialByRequestExamination($value)); $responce = new stdClass(); $index = 0; foreach ($supplyexaminationmaterialData as $row) { $subtotal = $row->vlchargeprice * $row->nrquantity; $responce->rows[$index]['id'] = $row->cdsupply; $responce->rows[$index]['cell'] = array($row->cdsupply, $row->nmsupply, $row->cdsupplycentre, $row->idsupplycentre, str_replace(".", ",", $row->vlchargeprice), $row->nrquantity, str_replace(".", ",", $subtotal)); $index++; } $this->view->additionalsupplyrequest = $responce; }
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(); } }