42 public $fk_prod_combination;
54 public $fk_prod_attr_val;
73 require_once DOL_DOCUMENT_ROOT .
'/variants/class/ProductAttributeValue.class.php';
74 require_once DOL_DOCUMENT_ROOT .
'/variants/class/ProductAttribute.class.php';
79 $prodattr->fetch($this->fk_prod_attr);
80 $prodattrval->fetch($this->fk_prod_attr_val);
82 return $prodattr->label .
': ' . $prodattrval->value;
91 $sql =
"INSERT INTO " . MAIN_DB_PREFIX .
"product_attribute_combination2val
92 (fk_prod_combination, fk_prod_attr, fk_prod_attr_val)
93 VALUES(" . (int) $this->fk_prod_combination .
", " . (
int) $this->fk_prod_attr .
", " . (int) $this->fk_prod_attr_val .
")";
95 $query = $this->
db->query($sql);
98 $this->
id = $this->
db->last_insert_id(MAIN_DB_PREFIX .
'product_attribute_combination2val');
116 c2v.fk_prod_attr_val,
118 c2v.fk_prod_combination
119 FROM " . MAIN_DB_PREFIX .
"product_attribute c LEFT JOIN " . MAIN_DB_PREFIX .
"product_attribute_combination2val c2v ON c.rowid = c2v.fk_prod_attr
120 WHERE c2v.fk_prod_combination = " . (int) $fk_combination;
122 $sql .= $this->
db->order(
'c.position',
'asc');
124 $query = $this->
db->query($sql);
132 while ($obj = $this->
db->fetch_object($query)) {
134 $tmp->fk_prod_attr_val = $obj->fk_prod_attr_val;
135 $tmp->fk_prod_attr = $obj->fk_prod_attr;
136 $tmp->fk_prod_combination = $obj->fk_prod_combination;
137 $tmp->id = $obj->rowid;
153 $sql =
"DELETE FROM " . MAIN_DB_PREFIX .
"product_attribute_combination2val WHERE fk_prod_combination = " . (int) $fk_combination;
155 if ($this->
db->query($sql)) {