Skip to content
This repository

HTTPS clone URL

Subversion checkout URL

You can clone with HTTPS or Subversion.

Download ZIP
tree: 63b1c04e08
Fetching contributors…

Cannot retrieve contributors at this time

file 201 lines (180 sloc) 6.465 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 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201
<?php
/*
* 2007-2011 PrestaShop
*
* NOTICE OF LICENSE
*
* This source file is subject to the Open Software License (OSL 3.0)
* that is bundled with this package in the file LICENSE.txt.
* It is also available through the world-wide-web at this URL:
* http://opensource.org/licenses/osl-3.0.php
* If you did not receive a copy of the license and are unable to
* obtain it through the world-wide-web, please send an email
* to license@prestashop.com so we can send you a copy immediately.
*
* DISCLAIMER
*
* Do not edit or add to this file if you wish to upgrade PrestaShop to newer
* versions in the future. If you wish to customize PrestaShop for your
* needs please refer to http://www.prestashop.com for more information.
*
* @author PrestaShop SA <contact@prestashop.com>
* @copyright 2007-2011 PrestaShop SA
* @version Release: $Revision: 8783 $
* @license http://opensource.org/licenses/osl-3.0.php Open Software License (OSL 3.0)
* International Registered Trademark & Property of PrestaShop SA
*/

class TagCore extends ObjectModel
{
  /** @var integer Language id */
public $id_lang;

  /** @var string Name */
public $name;

  protected $fieldsRequired = array('id_lang', 'name');
  protected $fieldsValidate = array('id_lang' => 'isUnsignedId', 'name' => 'isGenericName');

protected $table = 'tag';
protected $identifier = 'id_tag';

protected $webserviceParameters = array(
'fields' => array(
'id_lang' => array('xlink_resource' => 'languages'),
),
);

public function __construct($id = NULL, $name = NULL, $id_lang = NULL)
{
if ($id)
parent::__construct($id);
elseif ($name AND Validate::isGenericName($name) AND $id_lang AND Validate::isUnsignedId($id_lang))
{
$row = Db::getInstance(_PS_USE_SQL_SLAVE_)->getRow('
SELECT *
FROM `'._DB_PREFIX_.'tag` t
WHERE `name` LIKE \''.pSQL($name).'\' AND `id_lang` = '.(int)($id_lang));

if ($row)
{
$this->id = (int)($row['id_tag']);
$this->id_lang = (int)($row['id_lang']);
$this->name = $row['name'];
}
}
}

public function getFields()
{
parent::validateFields();
$fields['id_lang'] = (int)($this->id_lang);
$fields['name'] = pSQL($this->name);
return $fields;
}

public function add($autodate = true, $nullValues = false)
{
if (!parent::add($autodate, $nullValues))
return false;
elseif (isset($_POST['products']))
return $this->setProducts(Tools::getValue('products'));
return true;
}

/**
* Add several tags in database and link it to a product
*
* @param integer $id_lang Language id
* @param integer $id_product Product id to link tags with
* @param string $string Tags separated by commas
*
* @return boolean Operation success
*/
public static function addTags($id_lang, $id_product, $string)
{
if (!Validate::isUnsignedId($id_lang) OR !Validate::isTagsList($string))
return false;

$tmpTab = array_unique(array_map('trim', preg_split('/,/', $string, NULL, PREG_SPLIT_NO_EMPTY)));
$list = array();
foreach ($tmpTab AS $tag)
{
if (!Validate::isGenericName($tag))
return false;
$tagObj = new Tag(NULL, trim($tag), (int)($id_lang));

/* Tag does not exist in database */
if (!Validate::isLoadedObject($tagObj))
{
$tagObj->name = trim($tag);
$tagObj->id_lang = (int)($id_lang);
$tagObj->add();
}
if (!in_array($tagObj->id, $list))
$list[] = $tagObj->id;
}
$data = '';
foreach ($list AS $tag)
$data .= '('.(int)($tag).','.(int)($id_product).'),';
$data = rtrim($data, ',');

return Db::getInstance()->Execute('
INSERT INTO `'._DB_PREFIX_.'product_tag` (`id_tag`, `id_product`)
VALUES '.$data);
}

public static function getMainTags($id_lang, $nb = 10)
{
$groups = FrontController::getCurrentCustomerGroups();
$sqlGroups = (count($groups) ? 'IN ('.implode(',', $groups).')' : '= 1');

return Db::getInstance(_PS_USE_SQL_SLAVE_)->ExecuteS('
SELECT t.name, COUNT(pt.id_tag) AS times
FROM `'._DB_PREFIX_.'product_tag` pt
LEFT JOIN `'._DB_PREFIX_.'tag` t ON (t.id_tag = pt.id_tag)
LEFT JOIN `'._DB_PREFIX_.'product` p ON (p.id_product = pt.id_product)
WHERE t.`id_lang` = '.(int)($id_lang).'
AND p.`active` = 1
AND p.`id_product` IN (
SELECT cp.`id_product`
FROM `'._DB_PREFIX_.'category_group` cg
LEFT JOIN `'._DB_PREFIX_.'category_product` cp ON (cp.`id_category` = cg.`id_category`)
WHERE cg.`id_group` '.$sqlGroups.'
)
GROUP BY t.id_tag
ORDER BY times DESC
LIMIT 0, '.(int)($nb));
}

public static function getProductTags($id_product)
{
if (!$tmp = Db::getInstance(_PS_USE_SQL_SLAVE_)->ExecuteS('
SELECT t.`id_lang`, t.`name`
FROM '._DB_PREFIX_.'tag t
LEFT JOIN '._DB_PREFIX_.'product_tag pt ON (pt.id_tag = t.id_tag)
WHERE pt.`id_product`='.(int)($id_product)))
return false;
$result = array();
foreach ($tmp AS $tag)
$result[$tag['id_lang']][] = $tag['name'];
return $result;
}

public function getProducts($associated = true)
{
global $cookie;
$id_lang = $this->id_lang ? $this->id_lang : $cookie->id_lang;

if (!$this->id AND $associated)
return array();

return Db::getInstance(_PS_USE_SQL_SLAVE_)->ExecuteS('
SELECT pl.name, pl.id_product
FROM `'._DB_PREFIX_.'product` p
LEFT JOIN `'._DB_PREFIX_.'product_lang` pl ON p.id_product = pl.id_product
WHERE pl.id_lang = '.(int)($id_lang).'
AND p.active = 1
'.($this->id ? ('AND p.id_product '.($associated ? 'IN' : 'NOT IN').' (SELECT pt.id_product FROM `'._DB_PREFIX_.'product_tag` pt WHERE pt.id_tag = '.(int)($this->id).')') : '').'
ORDER BY pl.name');
}

public function setProducts($array)
{
Db::getInstance()->Execute('DELETE FROM '._DB_PREFIX_.'product_tag WHERE id_tag = '.(int)$this->id);
if (is_array($array))
{
$array = array_map('intval', $array);
$result1 = Db::getInstance()->Execute('UPDATE '._DB_PREFIX_.'product SET indexed = 0 WHERE id_product IN ('.implode(',', array_map('intval', $array)).')');
$ids = array();
foreach ($array as $id_product)
$ids[] = '('.(int)$id_product.','.(int)$this->id.')';
return ($result1 && Db::getInstance()->Execute('INSERT INTO '._DB_PREFIX_.'product_tag (id_product, id_tag) VALUES '.implode(',',$ids)) && Search::indexation(false));
}
return $result1;
}

public static function deleteTagsForProduct($id_product)
{
return Db::getInstance()->Execute('DELETE FROM `'._DB_PREFIX_.'product_tag` WHERE `id_product` = '.(int)($id_product));
}
}
Something went wrong with that request. Please try again.