Adrian / imaxmultiean

<?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')";
		return Db::getInstance()->execute($sql);
	}
	
	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'";
		return Db::getInstance()->execute($sql);
	}

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