$product_name = zen_get_products_name($pr_list->fields['product_id'], $_SESSION['languages_id']);
?>
<td class="dataTableContent"><?php
echo $_GET['cid'];
?>
</td>
<td class="dataTableContent" align="center"><?php
echo $coupon->fields['coupon_name'];
?>
</td>
<td class="dataTableContent" align="center"><?php
echo $pr_list->fields['product_id'];
?>
</td>
<td class="dataTableContent" align="left"><?php
echo '<strong>' . $product_name . '</strong><br />' . TEXT_CATEGORY . zen_get_categories_name_from_product($pr_list->fields['product_id']) . '<br />' . TEXT_MANUFACTURER . zen_get_products_manufacturers_name($pr_list->fields['product_id']);
?>
</td>
<?php
if ($pr_list->fields['coupon_restrict'] == 'N') {
echo '<td class="dataTableContent" align="center"><a href="' . zen_href_link('coupon_restrict.php', zen_get_all_get_params(array('info', 'action', 'x', 'y')) . 'action=switch_status&info=' . $pr_list->fields['restrict_id'], 'NONSSL') . '" onClick="divertClickSwitchStatus(this.href);return false;" >' . zen_image(DIR_WS_IMAGES . 'icon_status_green.gif', IMAGE_ALLOW) . '</a></td>';
} else {
echo '<td class="dataTableContent" align="center"><a href="' . zen_href_link('coupon_restrict.php', zen_get_all_get_params(array('info', 'action', 'x', 'y')) . 'action=switch_status&info=' . $pr_list->fields['restrict_id'], 'NONSSL') . '" onClick="divertClickSwitchStatus(this.href);return false;" >' . zen_image(DIR_WS_IMAGES . 'icon_status_red.gif', IMAGE_DENY) . '</a></td>';
}
if ($pr_list->fields['coupon_restrict'] == 'Y') {
echo '<td class="dataTableContent" align="center"><a href="' . zen_href_link('coupon_restrict.php', zen_get_all_get_params(array('info', 'action', 'x', 'y')) . 'action=switch_status&info=' . $pr_list->fields['restrict_id'], 'NONSSL') . '" onClick="divertClickSwitchStatus(this.href);return false;" >' . zen_image(DIR_WS_IMAGES . 'icon_status_green.gif', IMAGE_DENY) . '</a></td>';
} else {
echo '<td class="dataTableContent" align="center"><a href="' . zen_href_link('coupon_restrict.php', zen_get_all_get_params(array('info', 'action', 'x', 'y')) . 'action=switch_status&info=' . $pr_list->fields['restrict_id'], 'NONSSL') . '" onClick="divertClickSwitchStatus(this.href);return false;" >' . zen_image(DIR_WS_IMAGES . 'icon_status_red.gif', IMAGE_ALLOW) . '</a></td>';
}
echo '<td class="dataTableContent" align="center"><a href="' . zen_href_link('coupon_restrict.php', zen_get_all_get_params(array('info', 'action', 'x', 'y')) . 'action=remove&info=' . $pr_list->fields['restrict_id'], 'NONSSL') . '" onClick="divertClickActionRemove(this.href);return false;" >' . zen_image(DIR_WS_IMAGES . 'icons/delete.gif', IMAGE_REMOVE) . '</a></td>';
?>
// This should be first line of the script:
$zco_notifier->notify('NOTIFY_MAIN_TEMPLATE_VARS_START_DOCUMENT_GENERAL_INFO');
$module_show_categories = DOCUMENT_GENERAL_INFO_CATEGORIES;
$sql = "select count(*) as total\n from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd\n where p.products_status = '1'\n and p.products_id = '" . (int) $_GET['products_id'] . "'\n and pd.products_id = p.products_id\n and pd.language_id = '" . (int) $_SESSION['languages_id'] . "'";
$res = $db->Execute($sql);
if ($res->fields['total'] < 1) {
$tpl_page_body = '/tpl_product_info_noproduct.php';
} else {
$tpl_page_body = '/tpl_document_general_info_display.php';
$sql = "update " . TABLE_PRODUCTS_DESCRIPTION . "\n set products_viewed = products_viewed+1\n where products_id = '" . (int) $_GET['products_id'] . "'\n and language_id = '" . (int) $_SESSION['languages_id'] . "'";
$res = $db->Execute($sql);
$sql = "select p.products_id, pd.products_name,\n pd.products_description, p.products_model,\n p.products_quantity, p.products_image,\n pd.products_url, p.products_price,\n p.products_tax_class_id, p.products_date_added,\n p.products_date_available, p.manufacturers_id, p.products_quantity,\n p.products_weight, p.products_priced_by_attribute, p.product_is_free,\n p.products_qty_box_status,\n p.products_quantity_order_max,\n p.products_discount_type, p.products_discount_type_from, p.products_sort_order, p.products_price_sorter\n from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd\n where p.products_status = '1'\n and p.products_id = '" . (int) $_GET['products_id'] . "'\n and pd.products_id = p.products_id\n and pd.language_id = '" . (int) $_SESSION['languages_id'] . "'";
$product_info = $db->Execute($sql);
$products_price_sorter = $product_info->fields['products_price_sorter'];
$products_price = $currencies->display_price($product_info->fields['products_price'], zen_get_tax_rate($product_info->fields['products_tax_class_id']));
$manufacturers_name = zen_get_products_manufacturers_name((int) $_GET['products_id']);
if ($new_price = zen_get_products_special_price($product_info->fields['products_id'])) {
$specials_price = $currencies->display_price($new_price, zen_get_tax_rate($product_info->fields['products_tax_class_id']));
}
// set flag for attributes module usage:
$flag_show_weight_attrib_for_this_prod_type = SHOW_DOCUMENT_GENERAL_INFO_WEIGHT_ATTRIBUTES;
// get attributes
require DIR_WS_MODULES . zen_get_module_directory(FILENAME_ATTRIBUTES);
// if review must be approved or disabled do not show review
$review_status = " and r.status = '1'";
$reviews_query = "select count(*) as count from " . TABLE_REVIEWS . " r, " . TABLE_REVIEWS_DESCRIPTION . " rd\n where r.products_id = '" . (int) $_GET['products_id'] . "'\n and r.reviews_id = rd.reviews_id\n and rd.languages_id = '" . (int) $_SESSION['languages_id'] . "'" . $review_status;
$reviews = $db->Execute($reviews_query);
}
require DIR_WS_MODULES . zen_get_module_directory('product_prev_next.php');
$products_name = $product_info->fields['products_name'];
$products_model = $product_info->fields['products_model'];
public function exportPrepareFields(array $fields)
{
$fields = parent::exportPrepareFields($fields);
$products_id = $fields['products_id'];
$tax_class_id = $fields['products_tax_class_id'];
unset($fields['products_id'], $fields['products_tax_class_id']);
$default_language_code = $this->first_language_code;
global $db;
if ($this->export_language == 'all') {
$this->debugMessage('Products::exportPrepareFields, language = ' . $this->export_language . ', default language = ' . $default_language_code . ', sql: ' . $this->saved_data['products_description_sql'] . ', languages: ' . print_r($this->languages, true));
foreach ($this->languages as $language_code => $language_id) {
if ($language_code != $default_language_code) {
$description_info = $db->Execute(sprintf($this->saved_data['products_description_sql'], $products_id, $language_id));
if (!$description_info->EOF) {
$encoded_fields = $this->exportEncodeData($description_info->fields);
foreach ($encoded_fields as $field_name => $field_value) {
if ($field_name != 'products_id' && $field_name != 'language_id') {
$fields[$field_name . '_' . $language_code] = $field_value;
}
}
}
}
}
}
$fields['manufacturers_name'] = zen_get_products_manufacturers_name($products_id);
$tax_class_info = $db->Execute("SELECT tax_class_title FROM " . TABLE_TAX_CLASS . " WHERE tax_class_id = {$tax_class_id} LIMIT 1");
$fields['tax_class_title'] = $tax_class_info->EOF ? '' : $tax_class_info->fields['tax_class_title'];
$cPath_array = explode('_', zen_get_product_path($products_id));
$default_language_id = $this->languages[DEFAULT_LANGUAGE];
$categories_name = '';
foreach ($cPath_array as $next_category_id) {
$category_info = $db->Execute("SELECT categories_name FROM " . TABLE_CATEGORIES_DESCRIPTION . " WHERE categories_id = {$next_category_id} AND language_id = {$default_language_id} LIMIT 1");
$categories_name .= ($category_info->EOF ? self::DBIO_UNKNOWN_VALUE : $category_info->fields['categories_name']) . '^';
}
$fields['categories_name'] = $this->exportEncodeData(substr($categories_name, 0, -1));
return $fields;
}
