FuncionesImaxMultiEAN.php
1.36 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
<?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;
}
}