FuncionesImaxMultiEAN.php
1.88 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
<?php
class FuncionesImaxMultiEAN {
private $modulo;
public function __construct($modulo) {
$this->modulo = $modulo;
}
public function getEANs($id_product, $id_product_attribute = 0) {
$sql = 'SELECT ean13 FROM ' . _DB_PREFIX_ . $this->modulo->prefijo . 'multiean WHERE id_product = ' . (int)$id_product . ' AND id_product_attribute = ' . (int)$id_product_attribute;
return Db::getInstance()->executeS($sql);
}
public function storeEAN($productId, $ean, $combinationId = 0) {
$sql = 'INSERT INTO ' . _DB_PREFIX_.$this->modulo->prefijo . "multiean (id_product, id_product_attribute, ean13) VALUES ('$productId', '$combinationId', '$ean')";
try {
return Db::getInstance()->execute($sql);
} catch (Exception $e) {
return false;
}
}
public function deleteEAN($productId, $ean, $combinationId = 0) {
$sql = 'DELETE FROM ' . _DB_PREFIX_ . $this->modulo->prefijo . "multiean WHERE id_product = '$productId' AND id_product_attribute = '$combinationId' AND ean13 = '$ean'";
try {
return Db::getInstance()->execute($sql);
} catch (Exception $e) {
return false;
}
}
public function getProductByEan($ean) {
if (!$ean) {
return false;
}
$ean = pSQL($ean);
$sql = 'SELECT * FROM `' . _DB_PREFIX_ . $this->modulo->prefijo . "multiean` WHERE `ean13` = '$ean'";
$resultado = Db::getInstance()->getRow($sql);
return $resultado;
}
/**
* Devuelve los eans13 asociados a un producto
* @param mixed $idProduct
* @param mixed $idProductAttribute
* @return array
*/
public function getEansByIds($idProduct, $idProductAttribute){
$idProduct = (int) $idProduct;
$idProductAttribute = (int) $idProductAttribute;
$sql = 'SELECT `ean13` FROM ' . _DB_PREFIX_ . $this->modulo->prefijo . "multiean WHERE `id_product` = '$idProduct' AND `id_product_attribute` = '$idProductAttribute'";
$resultado = Db::getInstance()->executeS($sql);
return $resultado;
}
}