public static function getSelect($lang, $id = 0)
{
$colors = Db_Product::getFieldById('p_color', $id);
$colors = !empty($colors) ? explode(',', $colors) : array(0);
self::getDB()->query("\n SELECT *, c.id, ct_title AS title\n FROM ?f AS c\n LEFT JOIN ?f AS ct ON ct.ct_color_id = c.id\n WHERE ct.ct_lang_id = ?d\n ORDER BY c.c_priority ASC\n ", TAB_COLOR, TAB_COLOR_TRANS, $lang);
$items = array();
if (self::getDB()->numRows() > 0) {
while ($row = self::getDB()->fetchArray(MYSQL_ASSOC)) {
$row['status'] = in_array($row['id'], $colors) ? 'selected' : '';
$items[] = $row;
}
}
return $items;
}
public static function getSelect($product_id = 0)
{
$categories = Db_Product::getFieldById('p_category_id', $product_id);
$categories = !empty($categories) ? explode(',', $categories) : array(0);
self::getDB()->query("\n SELECT\n ct.ct_title AS title\n , c.id\n FROM ?f AS c\n INNER JOIN ?f AS ct ON ct.ct_category_id = c.id\n WHERE c.c_published = 1\n AND ct.ct_lang_id = ?i\n ORDER BY c.c_priority ASC\n ", TAB_CATEGORY, TAB_CATEGORY_TRANS, self::getLangId());
$items = array();
if (self::getDB()->numRows() > 0) {
while ($row = self::getDB()->fetchArray(MYSQL_ASSOC)) {
$row['status'] = in_array($row['id'], $categories) ? 'selected' : '';
$items[] = $row;
}
}
return $items;
}