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