Zen Cart 源代码 products.php

下载文件

文件名: products.php
文件类型: PHP文件
文件大小: 3.58 KiB
MD5: 265eecf8f97918ae0ba7b2475f97da2f

products.php - 打开高亮: <?php /** * products class * * @package classes * @copyright Copyright 2003-2006 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: products.php 4265 2006-08-25 08:09:36Z drbyte $ */ if (!defined('IS_ADMIN_FLAG')) { die('Illegal Access'); } /** * products class * Class used for managing various product information * * @package classes */ class products extends base { var $modules, $selected_module; // class constructor function products($module = '') { } function get_products_in_category($zf_category_id, $zf_recurse=true, $zf_product_ids_only=false) { global $db; $za_products_array = array(); // get top level products $zp_products_query = "select ptc.*, pd.products_name from " . TABLE_PRODUCTS_TO_CATEGORIES . " ptc left join " . TABLE_PRODUCTS_DESCRIPTION . " pd on ptc.products_id = pd.products_id and pd.language_id = '" . (int)$_SESSION['languages_id'] . "' where ptc.categories_id='" . (int)$zf_category_id . "' order by pd.products_name"; $zp_products = $db->Execute($zp_products_query); while (!$zp_products->EOF) { if ($zf_product_ids_only) { $za_products_array[] = $zp_products->fields['products_id']; } else { $za_products_array[] = array('id' => $zp_products->fields['products_id'], 'text' => $zp_products->fields['products_name']); } $zp_products->MoveNext(); } if ($zf_recurse) { $zp_categories_query = "select categories_id from " . TABLE_CATEGORIES . " where parent_id = '" . (int)$zf_category_id . "'"; $zp_categories = $db->Execute($zp_categories_query); while (!$zp_categories->EOF) { $za_sub_products_array = $this->get_products_in_category($zp_categories->fields['categories_id'], true, $zf_product_ids_only); $za_products_array = array_merge($za_products_array, $za_sub_products_array); $zp_categories->MoveNext(); } } return $za_products_array; } function products_name($zf_product_id) { global $db; $zp_product_name_query = "select products_name from " . TABLE_PRODUCTS_DESCRIPTION . " where language_id = '" . $_SESSION['languages_id'] . "' and products_id = '" . (int)$zf_product_id . "'"; $zp_product_name = $db->Execute($zp_product_name_query); $zp_product_name = $zp_product_name->fields['products_name']; return $zp_product_name; } function get_admin_handler($type) { return $this->get_handler($type) . '.php'; } function get_handler($type) { global $db; $sql = "select type_handler from " . TABLE_PRODUCT_TYPES . " where type_id = '" . (int)$type . "'"; $handler = $db->Execute($sql); return $handler->fields['type_handler']; } function get_allow_add_to_cart($zf_product_id) { global $db; $sql = "select products_type from " . TABLE_PRODUCTS . " where products_id='" . (int)$zf_product_id . "'"; $type_lookup = $db->Execute($sql); $sql = "select allow_add_to_cart from " . TABLE_PRODUCT_TYPES . " where type_id = '" . (int)$type_lookup->fields['products_type'] . "'"; $allow_add_to_cart = $db->Execute($sql); return $allow_add_to_cart->fields['allow_add_to_cart']; } } ?>