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