public function indexAction() { $data = array('paramId' => '8467', 'subproductId' => '21863', 'value' => '6'); $subproductParamsValuesMapper = new Catalog_Model_Mapper_SubproductParamsValues(); $subproductParamsValue = $subproductParamsValuesMapper->find('21863', '8467', new Catalog_Model_SubproductParamsValues()); /*$subproductParamsValue = new Catalog_Model_SubproductParamsValues(); $subproductParamsValue->setOptions($data); $subproductParamsValuesMapper->save($subproductParamsValue);*/ Zend_Debug::dump($subproductParamsValue); }
/** * @param $subProductId * @param $values */ public function saveEditSubproductParamsValues($subProductId, &$values) { foreach ($values as $value) { $subproductParamsValue = $this->_subproductParamsValuesMapper->find($subProductId, $value['paramId'], new Catalog_Model_SubproductParamsValues()); if (is_null($subproductParamsValue)) { $subproductParamsValue = new Catalog_Model_SubproductParamsValues(); $subproductParamsValue->setSubproductId($subProductId)->setParamId($value['paramId']); } $subproductParamsValue->setValue($value['value']); $this->_subproductParamsValuesMapper->save($subproductParamsValue); } }
/** * @param $modification_id * @param $property_id * @return mixed */ protected function _getModificationParamValue($modification_id, $property_id) { $result = $this->_subproductParamsValuesMapper->findBySubproductParam($modification_id, $property_id, new Catalog_Model_SubproductParamsValues()); return $result->getValue(); }
/** * @param $id * @return Catalog_Model_SubproductParamsValues[]|null * @throws Zend_Db_Table_Exception */ public function findSubProductParamValue($id) { $result = $this->getDbTable()->find($id); if (0 == count($result)) { return null; } $db = $this->getDbTable()->getAdapter(); $select = $db->select()->from("subproduct_params_values")->join("subproduct_params", "subproduct_params_values.param_id = subproduct_params.id")->where('subproduct_id = ?', $id)->order('subproduct_params.order ASC'); $stmt = $db->query($select); $resultSet = array(); while ($param = $stmt->fetchObject()) { $resultSet[] = $param; } $entries = array(); $modelMapper = new Catalog_Model_Mapper_SubproductParamsValues(); foreach ($resultSet as $row) { $entry = new Catalog_Model_SubproductParamsValues(); $entry = $modelMapper->_setDbData($row, $entry); $entries[] = $entry; } return $entries; }