$session_data_zone = substr($session_data, $start_zone, strpos($session_data, ';', $start_zone) - $start_zone + 1); session_decode($session_data_id); session_decode($session_data_currency); session_decode($session_data_country); session_decode($session_data_zone); session_decode($session_data_cart); if (PHP_VERSION < 4) { $broken_cart = $cart; $cart = new shoppingCart(); $cart->unserialize($broken_cart); } if (is_object($_SESSION['cart'])) { $contents[] = array('text' => $full_name . ' - ' . $ip_address . '<br />' . $info); $products = $_SESSION['cart']->get_products(); for ($i = 0, $n = sizeof($products); $i < $n; $i++) { $contents[] = array('text' => $products[$i]['quantity'] . ' x ' . '<a href="' . zen_href_link(FILENAME_CATEGORIES, 'cPath=' . zen_get_product_path($products[$i]['id']) . '&pID=' . $products[$i]['id']) . '">' . $products[$i]['name'] . '</a>'); // cPath=23&pID=74 } if (sizeof($products) > 0) { $contents[] = array('text' => zen_draw_separator('pixel_black.gif', '100%', '1')); $contents[] = array('align' => 'right', 'text' => TEXT_SHOPPING_CART_SUBTOTAL . ' ' . $currencies->format($_SESSION['cart']->show_total(), true, $_SESSION['currency'])); } else { $contents[] = array('text' => TEXT_EMPTY_CART); } } } } if (zen_not_null($heading) && zen_not_null($contents)) { echo ' <td width="25%" valign="top">' . "\n"; $box = new box(); echo $box->infoBox($heading, $contents);
function validate_for_category($product_id, $coupon_id) { global $db; $retVal = 'none'; $productCatPath = zen_get_product_path($product_id); $catPathArray = array_reverse(explode('_', $productCatPath)); $sql = "SELECT count(*) AS total\r\n FROM " . TABLE_COUPON_RESTRICT . "\r\n WHERE category_id = -1\r\n AND coupon_restrict = 'Y'\r\n AND coupon_id = " . (int) $coupon_id . " LIMIT 1"; $checkQuery = $db->execute($sql); foreach ($catPathArray as $catPath) { $sql = "SELECT * FROM " . TABLE_COUPON_RESTRICT . "\r\n WHERE category_id = " . (int) $catPath . "\r\n AND coupon_id = " . (int) $coupon_id; $result = $db->execute($sql); if ($result->recordCount() > 0 && $result->fields['coupon_restrict'] == 'N') { return true; } if ($result->recordCount() > 0 && $result->fields['coupon_restrict'] == 'Y') { return false; } } if ($checkQuery->fields['total'] > 0) { return false; } else { return 'none'; } }
if (isset($_GET['page']) && $_GET['page'] > 1) { $rows = $_GET['page'] * MAX_DISPLAY_SEARCH_RESULTS_REPORTS - MAX_DISPLAY_SEARCH_RESULTS_REPORTS; } $rows = 0; $products_query_raw = "select p.`products_id`, pd.`products_name`, p.`products_quantity`, p.`products_type` from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.`products_id` = pd.`products_id` and pd.`language_id`='" . $_SESSION['languages_id'] . "' order by p.`products_quantity`, pd.`products_name`"; $products_split = new splitPageResults($_GET['page'], MAX_DISPLAY_SEARCH_RESULTS_REPORTS, $products_query_raw, $products_query_numrows); $products = $gBitDb->Execute($products_query_raw); while (!$products->EOF) { // only show low stock on products that can be added to the cart if ($zc_products->get_allow_add_to_cart($products->fields['products_id']) == 'Y') { $rows++; if (strlen($rows) < 2) { $rows = '0' . $rows; } $type_handler = $zc_products->get_admin_handler($products->fields['products_type']); $cPath = zen_get_product_path($products->fields['products_id']); ?> <tr class="dataTableRow" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)" onclick="document.location.href='<?php echo zen_href_link_admin($type_handler, '&product_type=' . $products->fields['products_type'] . '&cPath=' . $cPath . '&pID=' . $products->fields['products_id'] . '&action=new_product'); ?> '"> <td class="dataTableContent" align="right"><?php echo $products->fields['products_id']; ?> </td> <td class="dataTableContent"><?php echo '<a href="' . zen_href_link_admin(FILENAME_CATEGORIES, 'cPath=' . $cPath . '&pID=' . $products->fields['products_id']) . '">' . $products->fields['products_name'] . '</a>'; ?> </td> <td class="dataTableContent" align="center"><?php echo $products->fields['products_quantity'];
$specials_current_price = zen_get_products_base_price($sInfo->products_id); } else { $specials_current_price = $sInfo->products_price; } $contents[] = array('align' => 'center', 'text' => '<a href="' . zen_href_link(FILENAME_SPECIALS, 'page=' . $_GET['page'] . '&sID=' . $sInfo->specials_id . '&action=edit') . '">' . zen_image_button('button_edit.gif', IMAGE_EDIT) . '</a> <a href="' . zen_href_link(FILENAME_SPECIALS, 'page=' . $_GET['page'] . '&sID=' . $sInfo->specials_id . '&action=delete') . '">' . zen_image_button('button_delete.gif', IMAGE_DELETE) . '</a>'); $contents[] = array('align' => 'center', 'text' => '<a href="' . zen_href_link(FILENAME_PRODUCTS_PRICE_MANAGER, 'action=edit&products_filter=' . $sInfo->products_id) . '">' . zen_image_button('button_products_price_manager.gif', IMAGE_PRODUCTS_PRICE_MANAGER) . '</a>'); $contents[] = array('text' => '<br>' . TEXT_INFO_DATE_ADDED . ' ' . zen_date_short($sInfo->specials_date_added)); $contents[] = array('text' => '' . TEXT_INFO_LAST_MODIFIED . ' ' . zen_date_short($sInfo->specials_last_modified)); $contents[] = array('align' => 'center', 'text' => '<br>' . zen_info_image($sInfo->products_image, $sInfo->products_name, SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT)); $contents[] = array('text' => '<br>' . TEXT_INFO_ORIGINAL_PRICE . ' ' . $currencies->format($specials_current_price)); $contents[] = array('text' => '' . TEXT_INFO_NEW_PRICE . ' ' . $currencies->format($sInfo->specials_new_products_price)); $contents[] = array('text' => '' . TEXT_INFO_DISPLAY_PRICE . ' ' . zen_get_products_display_price($sInfo->products_id)); $contents[] = array('text' => '<br>' . TEXT_INFO_AVAILABLE_DATE . ' <b>' . (($specials->fields['specials_date_available'] != '0001-01-01' and $specials->fields['specials_date_available'] != '') ? zen_date_short($specials->fields['specials_date_available']) : TEXT_NONE) . '</b>'); $contents[] = array('text' => '<br>' . TEXT_INFO_EXPIRES_DATE . ' <b>' . (($specials->fields['expires_date'] != '0001-01-01' and $specials->fields['expires_date'] != '') ? zen_date_short($specials->fields['expires_date']) : TEXT_NONE) . '</b>'); $contents[] = array('text' => '' . TEXT_INFO_STATUS_CHANGE . ' ' . zen_date_short($sInfo->date_status_change)); $contents[] = array('align' => 'center', 'text' => '<a href="' . zen_href_link(FILENAME_CATEGORIES, '&action=new_product' . '&cPath=' . zen_get_product_path($sInfo->products_id, 'override') . '&pID=' . $sInfo->products_id . '&product_type=' . zen_get_products_type($sInfo->products_id)) . '">' . zen_image_button('button_edit_product.gif', IMAGE_EDIT_PRODUCT) . '<br />' . TEXT_PRODUCT_EDIT . '</a>'); $contents[] = array('align' => 'center', 'text' => '<a href="' . zen_href_link(FILENAME_SPECIALS, 'action=pre_add') . '">' . zen_image_button('button_select.gif', IMAGE_SELECT) . '<br />' . TEXT_INFO_MANUAL . '</a><br /><br />'); } break; } if (zen_not_null($heading) && zen_not_null($contents)) { echo ' <td width="25%" valign="top">' . "\n"; $box = new box(); echo $box->infoBox($heading, $contents); echo ' </td>' . "\n"; } } ?> </tr> </table></td> </tr>
?> </td> </tr> <tr> <td colspan="2"><table border="1" cellspacing="2" cellpadding="4" align="left"> <tr> <td colspan="7" class="main" align="center"> <?php echo TEXT_PRODUCTS_LISTING . TEXT_PRODUCTS_ID . $products_filter . TEXT_PRODUCT_IN_CATEGORY_NAME . zen_get_category_name(zen_get_products_category_id($products_filter), (int) $_SESSION['languages_id']) . '<br />' . zen_get_products_name($products_filter); ?> </td> </tr> <tr> <td class="smallText" align="center"><?php echo '<a href="' . zen_href_link(FILENAME_CATEGORIES, 'action=new_product' . '&cPath=' . zen_get_product_path($products_filter) . '&pID=' . $products_filter . '&product_type=' . zen_get_products_type($products_filter)) . '">' . zen_image_button('button_edit_product.gif', IMAGE_EDIT_PRODUCT) . '<br />' . TEXT_PRODUCT_EDIT . '</a>'; ?> </td> <td class="smallText" align="center"> <?php if ($zc_products->get_allow_add_to_cart($products_filter) == "Y") { echo '<a href="' . zen_href_link(FILENAME_PRODUCTS_PRICE_MANAGER, '&products_filter=' . $products_filter . '¤t_category_id=' . $current_category_id) . '">' . zen_image_button('button_products_price_manager.gif', IMAGE_PRODUCTS_PRICE_MANAGER) . '<br />' . TEXT_PRODUCTS_PRICE_MANAGER . '</a>'; } else { echo TEXT_INFO_ALLOW_ADD_TO_CART_NO; } ?> </td> <?php if (zen_has_product_attributes($products_filter, 'false')) { ?> <td class="smallText" align="center"><?php
<?php /** * category_icon_display module * * @package modules * @copyright Copyright 2003-2010 Zen Cart Development Team * @copyright Portions Copyright 2003 osCommerce * @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0 * @version $Id: category_icon_display.php 16776 2010-06-24 20:48:53Z drbyte $ */ if (!defined('IS_ADMIN_FLAG')) { die('Illegal Access'); } if ($cPath == '' || $cPath == 0) { $cPath = zen_get_product_path((int) $_GET['products_id']); } if (!isset($_GET['cPath']) || $_GET['cPath'] == '') { $_GET['cPath'] = $cPath; } $cPath_new = zen_get_path(zen_get_products_category_id((int) $_GET['products_id'])); // if ((zen_get_categories_image(zen_get_products_category_id((int)$_GET['products_id']))) !='') { switch (true) { case $module_show_categories == '1': $align = 'left'; break; case $module_show_categories == '2': $align = 'center'; break; case $module_show_categories == '3': $align = 'right';
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; }
/** * Get ZenCart view data. */ public function getZcViewData($request) { // category path - no support for get_terms_to_filter table. does anybody use that? $manufacturerId = $request->query->getInt('manufacturers_id'); $productId = $request->query->get('products_id'); $show_welcome = false; if ($request->query->has('cPath')) { if (!empty($productId) && empty($manufacturerId)) { $request->query->set('cPath', zen_get_product_path($productId)); } elseif (SHOW_CATEGORIES_ALWAYS == '1' && empty($manufacturerId)) { $show_welcome = true; $request->query->set('cPath', defined('CATEGORIES_START_MAIN') ? CATEGORIES_START_MAIN : ''); } } // end category path define('PAGE_PARSE_START_TIME', microtime()); $lng = new \language(); $languageId = $request->getSession()->getLanguageId(); // breadcrumb $robotsNoIndex = false; $validCategories = array(); $cPathArray = (array) $request->attributes->get('categoryIds'); foreach ($cPathArray as $categoryId) { $category = $this->container->get('categoryService')->getCategoryForId($categoryId, $languageId); if (null != $category) { $validCategories[] = $category; } elseif (SHOW_CATEGORIES_ALWAYS == 0) { $robotsNoIndex = true; break; } } // ZenMagick does most of the following , we should be able to reuse it. $manufacturer = null; $manufacturerId = $request->query->getInt('manufacturers_id'); if (null != $manufacturerId) { $manufacturer = $this->container->get('manufacturerService')->getManufacturerForId($manufacturerId, $languageId); } $product = null; if (null != $productId) { $product = $this->container->get('productService')->getProductForId($productId); } $breadcrumb = $this->initCrumbs($validCategories, $manufacturer, $product); // end breakdcrumb $params = $request->attributes->get('_route_params'); $canonicalLink = $this->get('router')->generate($request->getRequestId(), $params, true); $this_is_home_page = $this->isHomePage(); $zv_onload = $this->getOnLoadJS(); $tpl = compact('breadcrumb', 'canonicalLink', 'lng', 'robotsNoIndex', 'show_welcome', 'this_is_home_page', 'zv_onload'); $tpl['session_started'] = true; return $tpl; }
function _dispatchProduct($map, $data) { $product_id = $data->fields['products_id']; $value = '<a href="' . zen_href_link(FILENAME_CATEGORIES, '&action=new_product' . '&cPath=' . zen_get_product_path($data->fields['products_id'], 'override') . '&pID=' . $data->fields['products_id'] . '&product_type=' . zen_get_products_type($data->fields['products_id'])) . '">' . $data->fields['products_name'] . '</a>'; #$value = $data->fields['products_name']; return $value; }
// auto expire featured products require_once DIR_FS_FUNCTIONS . 'featured.php'; zen_start_featured(); zen_expire_featured(); // auto expire salemaker sales require_once DIR_FS_FUNCTIONS . 'salemaker.php'; zen_start_salemaker(); zen_expire_salemaker(); $_SESSION['update_expirations'] = 'true'; } // calculate category path if (isset($_REQUEST['cPath'])) { $cPath = $_REQUEST['cPath']; } elseif (isset($_REQUEST['products_id']) && !zen_check_url_get_terms()) { // } elseif (isset($_REQUEST['products_id']) && !isset($_REQUEST['manufacturers_id']) && !isset($_REQUEST['music_genres_id'])) { $cPath = zen_get_product_path($_REQUEST['products_id']); } else { if (SHOW_CATEGORIES_ALWAYS == '1' && !zen_check_url_get_terms()) { $show_welcome = 'true'; $cPath = defined('CATEGORIES_START_MAIN') ? CATEGORIES_START_MAIN : ''; } else { $show_welcome = 'false'; $cPath = ''; } } if (zen_not_null($cPath)) { $cPath_array = zen_parse_category_path($cPath); $cPath = implode('_', $cPath_array); $current_category_id = $cPath_array[sizeof($cPath_array) - 1]; } else { $current_category_id = 0;