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();
     }
 }