general.php

PHP 建站工具,CMS系统,类似与oscommerce

    
    return $category['categories_meta_keywords'];
  }

  function twe_get_orders_status_name($orders_status_id, $language_id = '') {

    if (!$language_id) $language_id = $_SESSION['languages_id'];
    $orders_status_query = twe_db_query("select orders_status_name from " . TABLE_ORDERS_STATUS . " where orders_status_id = '" . $orders_status_id . "' and language_id = '" . $language_id . "'");
    $orders_status = twe_db_fetch_array($orders_status_query);

    return $orders_status['orders_status_name'];
  }

    function twe_get_shipping_status_name($shipping_status_id, $language_id = '') {

    if (!$language_id) $language_id = $_SESSION['languages_id'];
    $shipping_status_query = twe_db_query("select shipping_status_name from " . TABLE_SHIPPING_STATUS . " where shipping_status_id = '" . $shipping_status_id . "' and language_id = '" . $language_id . "'");
    $shipping_status = twe_db_fetch_array($shipping_status_query);

    return $shipping_status['shipping_status_name'];
  }

  function twe_get_orders_status() {

    $orders_status_array = array();
    $orders_status_query = twe_db_query("select orders_status_id, orders_status_name from " . TABLE_ORDERS_STATUS . " where language_id = '" . $_SESSION['languages_id'] . "' order by orders_status_id");
    while ($orders_status = twe_db_fetch_array($orders_status_query)) {
      $orders_status_array[] = array('id' => $orders_status['orders_status_id'],
                                     'text' => $orders_status['orders_status_name']
                                    );
    }

    return $orders_status_array;
  }

    function twe_get_shipping_status() {

    $shipping_status_array = array();
    $shipping_status_query = twe_db_query("select shipping_status_id, shipping_status_name from " . TABLE_SHIPPING_STATUS . " where language_id = '" . $_SESSION['languages_id'] . "' order by shipping_status_id");
    while ($shipping_status = twe_db_fetch_array($shipping_status_query)) {
      $shipping_status_array[] = array('id' => $shipping_status['shipping_status_id'],
                                     'text' => $shipping_status['shipping_status_name']
                                    );
    }

    return $shipping_status_array;
  }

  function twe_get_products_name($product_id, $language_id = 0) {

    if ($language_id == 0) $language_id = $_SESSION['languages_id'];
    $product_query = twe_db_query("select products_name from " . TABLE_PRODUCTS_DESCRIPTION . " where products_id = '" . $product_id . "' and language_id = '" . $language_id . "'");
    $product = twe_db_fetch_array($product_query);

    return $product['products_name'];
  }

  function twe_get_products_description($product_id, $language_id) {
    $product_query = twe_db_query("select products_description from " . TABLE_PRODUCTS_DESCRIPTION . " where products_id = '" . $product_id . "' and language_id = '" . $language_id . "'");
    $product = twe_db_fetch_array($product_query);

    return $product['products_description'];
  }

    function twe_get_products_short_description($product_id, $language_id) {
    $product_query = twe_db_query("select products_short_description from " . TABLE_PRODUCTS_DESCRIPTION . " where products_id = '" . $product_id . "' and language_id = '" . $language_id . "'");
    $product = twe_db_fetch_array($product_query);

    return $product['products_short_description'];
  }

  function twe_get_products_meta_title($product_id, $language_id) {
    $product_query = twe_db_query("select products_meta_title from " . TABLE_PRODUCTS_DESCRIPTION . " where products_id = '" . $product_id . "' and language_id = '" . $language_id . "'");
    $product = twe_db_fetch_array($product_query);

    return $product['products_meta_title'];
  }

  function twe_get_products_meta_description($product_id, $language_id) {
    $product_query = twe_db_query("select products_meta_description from " . TABLE_PRODUCTS_DESCRIPTION . " where products_id = '" . $product_id . "' and language_id = '" . $language_id . "'");
    $product = twe_db_fetch_array($product_query);

    return $product['products_meta_description'];
  }

  function twe_get_products_meta_keywords($product_id, $language_id) {
    $product_query = twe_db_query("select products_meta_keywords from " . TABLE_PRODUCTS_DESCRIPTION . " where products_id = '" . $product_id . "' and language_id = '" . $language_id . "'");
    $product = twe_db_fetch_array($product_query);

    return $product['products_meta_keywords'];
  }

  function twe_get_products_url($product_id, $language_id) {
    $product_query = twe_db_query("select products_url from " . TABLE_PRODUCTS_DESCRIPTION . " where products_id = '" . $product_id . "' and language_id = '" . $language_id . "'");
    $product = twe_db_fetch_array($product_query);

    return $product['products_url'];
  }

  ////
  // Return the manufacturers URL in the needed language
  // TABLES: manufacturers_info
  function twe_get_manufacturer_url($manufacturer_id, $language_id) {
    $manufacturer_query = twe_db_query("select manufacturers_url from " . TABLE_MANUFACTURERS_INFO . " where manufacturers_id = '" . $manufacturer_id . "' and languages_id = '" . $language_id . "'");
    $manufacturer = twe_db_fetch_array($manufacturer_query);

    return $manufacturer['manufacturers_url'];
  }

  ////
  // Wrapper for class_exists() function
  // This function is not available in all PHP versions so we test it before using it.
  function twe_class_exists($class_name) {
    if (function_exists('class_exists')) {
      return class_exists($class_name);
    } else {
      return true;
    }
  }

  ////
  // Count how many products exist in a category
  // TABLES: products, products_to_categories, categories
  function twe_products_in_category_count($categories_id, $include_deactivated = false) {
    $products_count = 0;

    if ($include_deactivated) {
      $products_query = twe_db_query("select count(*) as total from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_id = p2c.products_id and p2c.categories_id = '" . $categories_id . "'");
    } else {
      $products_query = twe_db_query("select count(*) as total from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '" . $categories_id . "'");
    }

    $products = twe_db_fetch_array($products_query);

    $products_count += $products['total'];

    $childs_query = twe_db_query("select categories_id from " . TABLE_CATEGORIES . " where parent_id = '" . $categories_id . "'");
    if (twe_db_num_rows($childs_query)) {
      while ($childs = twe_db_fetch_array($childs_query)) {
        $products_count += twe_products_in_category_count($childs['categories_id'], $include_deactivated);
      }
    }

    return $products_count;
  }

  ////
  // Count how many subcategories exist in a category
  // TABLES: categories
  function twe_childs_in_category_count($categories_id) {
    $categories_count = 0;

    $categories_query = twe_db_query("select categories_id from " . TABLE_CATEGORIES . " where parent_id = '" . $categories_id . "'");
    while ($categories = twe_db_fetch_array($categories_query)) {
      $categories_count++;
      $categories_count += twe_childs_in_category_count($categories['categories_id']);
    }

    return $categories_count;
  }

  ////
  // Returns an array with countries
  // TABLES: countries
  function twe_get_countries($default = '') {
    $countries_array = array();
    if ($default) {
      $countries_array[] = array('id' => STORE_COUNTRY,
                                 'text' => $default);
    }
    $countries_query = twe_db_query("select countries_id, countries_name from " . TABLE_COUNTRIES . " order by countries_name");
    while ($countries = twe_db_fetch_array($countries_query)) {
      $countries_array[] = array('id' => $countries['countries_id'],
                                 'text' => $countries['countries_name']);
    }

    return $countries_array;
  }

  ////
  // return an array with country zones
  function twe_get_country_zones($country_id) {
    $zones_array = array();
    $zones_query = twe_db_query("select zone_id, zone_name from " . TABLE_ZONES . " where zone_country_id = '" . $country_id . "' order by zone_name");
    while ($zones = twe_db_fetch_array($zones_query)) {
      $zones_array[] = array('id' => $zones['zone_id'],
                             'text' => $zones['zone_name']);
    }

    return $zones_array;
  }

  function twe_prepare_country_zones_pull_down($country_id = '') {
    // preset the width of the drop-down for Netscape
    $pre = '';
    if ( (!twe_browser_detect('MSIE')) && (twe_browser_detect('Mozilla/4')) ) {
      for ($i=0; $i<45; $i++) $pre .= '&nbsp;';
    }

    $zones = twe_get_country_zones($country_id);

    if (sizeof($zones) > 0) {
      $zones_select = array(array('id' => '', 'text' => PLEASE_SELECT));
      $zones = twe_array_merge($zones_select, $zones);
    } else {
      $zones = array(array('id' => '', 'text' => TYPE_BELOW));
      // create dummy options for Netscape to preset the height of the drop-down
      if ( (!twe_browser_detect('MSIE')) && (twe_browser_detect('Mozilla/4')) ) {
        for ($i=0; $i<9; $i++) {
          $zones[] = array('id' => '', 'text' => $pre);
        }
      }
    }

    return $zones;
  }

  ////
  // Get list of address_format_id's
  function twe_get_address_formats() {
    $address_format_query = twe_db_query("select address_format_id from " . TABLE_ADDRESS_FORMAT . " order by address_format_id");
    $address_format_array = array();
    while ($address_format_values = twe_db_fetch_array($address_format_query)) {
      $address_format_array[] = array('id' => $address_format_values['address_format_id'],
                                      'text' => $address_format_values['address_format_id']);
    }
    return $address_format_array;
  }

  ////
  // Alias function for Store configuration values in the Administration Tool
  function twe_cfg_pull_down_country_list($country_id) {
    return twe_draw_pull_down_menu('configuration_value', twe_get_countries(), $country_id);
  }

  function twe_cfg_pull_down_zone_list($zone_id) {
    return twe_draw_pull_down_menu('configuration_value', twe_get_country_zones(STORE_COUNTRY), $zone_id);
  }

  function twe_cfg_pull_down_tax_classes($tax_class_id, $key = '') {
    $name = (($key) ? 'configuration[' . $key . ']' : 'configuration_value');

    $tax_class_array = array(array('id' => '0', 'text' => TEXT_NONE));
    $tax_class_query = twe_db_query("select tax_class_id, tax_class_title from " . TABLE_TAX_CLASS . " order by tax_class_title");
    while ($tax_class = twe_db_fetch_array($tax_class_query)) {
      $tax_class_array[] = array('id' => $tax_class['tax_class_id'],
                                 'text' => $tax_class['tax_class_title']);
    }

    return twe_draw_pull_down_menu($name, $tax_class_array, $tax_class_id);
  }

  ////
  // Function to read in text area in admin
 function twe_cfg_textarea($text) {
    return twe_draw_textarea_field('configuration_value', false, 35, 5, $text);
  }

  function twe_cfg_get_zone_name($zone_id) {
    $zone_query = twe_db_query("select zone_name from " . TABLE_ZONES . " where zone_id = '" . $zone_id . "'");

    if (!twe_db_num_rows($zone_query)) {
      return $zone_id;
    } else {
      $zone = twe_db_fetch_array($zone_query);
      return $zone['zone_name'];
    }
  }

  ////
  // Sets the status of a banner
  function twe_set_banner_status($banners_id, $status) {
    if ($status == '1') {
      return twe_db_query("update " . TABLE_BANNERS . " set status = '1', expires_impressions = NULL, expires_date = NULL, date_status_change = NULL where banners_id = '" . $banners_id . "'");
    } elseif ($status == '0') {
      return twe_db_query("update " . TABLE_BANNERS . " set status = '0', date_status_change = now() where banners_id = '" . $banners_id . "'");
    } else {
      return -1;
    }
  }

  ////
  // Sets the status of a product
  function twe_set_product_status($products_id, $status) {
    if ($status == '1') {
      return twe_db_query("update " . TABLE_PRODUCTS . " set products_status = '1', products_last_modified = now() where products_id = '" . $products_id . "'");
    } elseif ($status == '0') {
      return twe_db_query("update " . TABLE_PRODUCTS . " set products_status = '0', products_last_modified = now() where products_id = '" . $products_id . "'");
    } else {
      return -1;
    }
  }

  ////
  // Sets the status of a product on special
  function twe_set_specials_status($specials_id, $status) {
    if ($status == '1') {
      return twe_db_query("update " . TABLE_SPECIALS . " set status = '1', expires_date = NULL, date_status_change = NULL where specials_id = '" . $specials_id . "'");
    } elseif ($status == '0') {
      return twe_db_query("update " . TABLE_SPECIALS . " set status = '0', date_status_change = now() where specials_id = '" . $specials_id . "'");
    } else {
      return -1;
    }
  }

  ////
  // Sets timeout for the current script.