general.php

全新且完善的强大网上商店系统

<?php
/*
  [SOOBIC!] includes/general.php 

	Version: 1.5 C
	Author: Soolan ([e-mail])
	Copyright: Soolan (www.soobic.com)
	Last Modified: 2005/4/3 10:00

*/



function tep_get_languages() {
    global $db,$table_languages;
		$languages_query = $db->query("select languages_id, name, code, image, directory from $table_languages order by sort_order");
    while ($languages = $db->fetch_array($languages_query)) {
      $languages_array[] = array('id' => $languages['languages_id'],
                                 'name' => $languages['name'],
                                 'code' => $languages['code'],
                                 'image' => $languages['image'],
                                 'directory' => $languages['directory']);
    }

    return $languages_array;
}
function tep_get_tax_rate_value($class_id) {
    global $db,$table_tax_rates;
		$tax_query = $db->query("select SUM(tax_rate) as tax_rate from $table_tax_rates where tax_class_id = '" . (int)$class_id . "' group by tax_priority");
    if ($db->num_rows($tax_query)) {
      $tax_multiplier = 0;
      while ($tax = $db->fetch_array($tax_query)) {
        $tax_multiplier += $tax['tax_rate'];
      }
      return $tax_multiplier;
    } else {
      return 0;
    }
}
function tep_call_function($function, $parameter, $object = '') {
    if ($object == '') {
      return call_user_func($function, $parameter);
    } elseif (PHP_VERSION < 4) {
      return call_user_method($function, $object, $parameter);
    } else {
      return call_user_func(array($object, $function), $parameter);
    }
}
function tep_get_order_status_name($order_status_id, $language_id = '') {
    global $languages_id,$db,$table_orders_status;
    if ($order_status_id < 1) return TEXT_DEFAULT;
    if (!is_numeric($language_id)) $language_id = $languages_id;
    $query = $db->query("select orders_status_name from $table_orders_status where orders_status_id = '" . (int)$order_status_id . "' and language_id = '" . (int)$language_id . "'");
    $status = $db->fetch_array($query);
    return $status['orders_status_name'];
}
function tep_get_zone_class_title($zone_class_id) {
    global $table_geo_zones,$db;
		if ($zone_class_id == '0') {
        return TEXT_NONE;
    } else {
        $classes_query = $db->query("select geo_zone_name from $table_geo_zones where geo_zone_id = '" . (int)$zone_class_id . "'");
        $classes = $db->fetch_array($classes_query);
        return $classes['geo_zone_name'];
		}
}
function tep_cfg_select_option($select_array, $key_value, $key = '') {
    $string = '';
		for ($i=0, $n=sizeof($select_array); $i<$n; $i++) {
      $name = ((tep_not_null($key)) ? 'configuration[' . $key . ']' : 'configuration_value');
      $string .= '<br><input type="radio" name="' . $name . '" value="' . $select_array[$i] . '"';
      if ($key_value == $select_array[$i]) $string .= ' CHECKED';
      $string .= '> ' . $select_array[$i];
    }
    return $string;
}
function tep_cfg_pull_down_zone_classes($zone_class_id, $key = '') {
    global $table_geo_zones,$db;
		$name = (($key) ? 'configuration[' . $key . ']' : 'configuration_value');
    $zone_class_array = array(array('id' => '0', 'text' => TEXT_NONE));
    $zone_class_query = $db->query("select geo_zone_id, geo_zone_name from $table_geo_zones order by geo_zone_name");
    while ($zone_class = $db->fetch_array($zone_class_query)) {
      $zone_class_array[] = array('id' => $zone_class['geo_zone_id'],
                                  'text' => $zone_class['geo_zone_name']);
    }
    return tep_draw_pull_down_menu($name, $zone_class_array, $zone_class_id);
}
function tep_cfg_pull_down_order_statuses($order_status_id, $key = '') {
    global $languages_id,$db,$table_orders_status;
    $name = (($key) ? 'configuration[' . $key . ']' : 'configuration_value');
    $statuses_array = array(array('id' => '0', 'text' => TEXT_DEFAULT));
    $statuses_query = $db->query("select orders_status_id, orders_status_name from $table_orders_status where language_id = '" . (int)$languages_id . "' order by orders_status_name");
    while ($statuses = $db->fetch_array($statuses_query)) {
      $statuses_array[] = array('id' => $statuses['orders_status_id'],
                                'text' => $statuses['orders_status_name']);
    }
    return tep_draw_pull_down_menu($name, $statuses_array, $order_status_id);
}
function tep_get_tax_class_title($tax_class_id) {
    global $table_tax_class,$db;
		if ($tax_class_id == '0') {
      return TEXT_NONE;
    } else {
      $classes_query = $db->query("select tax_class_title from $table_tax_class where tax_class_id = '" . (int)$tax_class_id . "'");
      $classes = $db->fetch_array($classes_query);

      return $classes['tax_class_title'];
    }
}

function tep_cfg_pull_down_tax_classes($tax_class_id, $key = '') {
    global $table_tax_class,$db;
		$name = (($key) ? 'configuration[' . $key . ']' : 'configuration_value');

    $tax_class_array = array(array('id' => '0', 'text' => TEXT_NONE));
    $tax_class_query = $db->query("select tax_class_id, tax_class_title from $table_tax_class order by tax_class_title");
    while ($tax_class = $db->fetch_array($tax_class_query)) {
      $tax_class_array[] = array('id' => $tax_class['tax_class_id'],
                                 'text' => $tax_class['tax_class_title']);
    }

    return tep_draw_pull_down_menu($name, $tax_class_array, $tax_class_id);
}
function tep_tax_classes_pull_down($parameters, $selected = '') {
    global $table_tax_class,$db;
		$select_string = '<select ' . $parameters . '>';
    $classes_query = $db->query("select tax_class_id, tax_class_title from $table_tax_class order by tax_class_title");
    while ($classes = $db->fetch_array($classes_query)) {
        $select_string .= '<option value="' . $classes['tax_class_id'] . '"';
        if ($selected == $classes['tax_class_id']) $select_string .= ' SELECTED';
        $select_string .= '>' . $classes['tax_class_title'] . '</option>';
    }
    $select_string .= '</select>';
    return $select_string;
}
function tep_geo_zones_pull_down($parameters, $selected = '') {
    global $table_geo_zones,$db;
		$select_string = '<select ' . $parameters . '>';
    $zones_query = $db->query("select geo_zone_id, geo_zone_name from $table_geo_zones order by geo_zone_name");
    while ($zones = $db->fetch_array($zones_query)) {
      $select_string .= '<option value="' . $zones['geo_zone_id'] . '"';
      if ($selected == $zones['geo_zone_id']) $select_string .= ' SELECTED';
      $select_string .= '>' . $zones['geo_zone_name'] . '</option>';
    }
    $select_string .= '</select>';

    return $select_string;
}

function tep_cfg_pull_down_country_list($country_id) {
    return tep_draw_pull_down_menu('configuration_value', tep_get_countries(), $country_id);
}

function tep_cfg_pull_down_zone_list($zone_id) {
		return tep_draw_pull_down_menu('configuration_value', tep_get_country_zones(STORE_COUNTRY), $zone_id);
}
function tep_get_country_zones($country_id) {
    global $db,$table_zones;
		$zones_array = array();
    $zones_query = $db->query("select zone_id, zone_name from $table_zones where zone_country_id = '" . (int)$country_id . "' order by zone_name");
    while ($zones = $db->fetch_array($zones_query)) {
         $zones_array[] = array('id' => $zones['zone_id'],
                             'text' => $zones['zone_name']);
    }

    return $zones_array;
}

function tep_cfg_get_zone_name($zone_id) {
    global $db,$table_zones;
		$zone_query = $db->query("select zone_name from $table_zones where zone_id = '" . (int)$zone_id . "'");

    if (!$db->num_rows($zone_query)) {
      return $zone_id;
    } else {
      $zone = $db->fetch_array($zone_query);
      return $zone['zone_name'];
    }
}
function tep_draw_radio_field($name, $value = '', $checked = false, $compare = '', $parameter = '') {
    return tep_draw_selection_field($name, 'radio', $value, $checked, $compare, $parameter);
}

function tep_get_category_tree($parent_id = '0', $spacing = '', $exclude = '', $category_tree_array = '', $include_itself = false) {
    global $languages_id,$db,$table_categories_description,$table_categories;

    if (!is_array($category_tree_array)) $category_tree_array = array();
    if ( (sizeof($category_tree_array) < 1) && ($exclude != '0') ) $category_tree_array[] = array('id' => '0', 'text' => TEXT_TOP);

    if ($include_itself) {
      $category_query = $db->query("select cd.categories_name from $table_categories_description cd where cd.language_id = '" . (int)$languages_id . "' and cd.categories_id = '" . (int)$parent_id . "'");
      $category = $db->fetch_array($category_query);
      $category_tree_array[] = array('id' => $parent_id, 'text' => $category['categories_name']);
    }

    $categories_query = $db->query("select c.categories_id, cd.categories_name, c.parent_id from $table_categories c, $table_categories_description cd where c.categories_id = cd.categories_id and cd.language_id = '" . (int)$languages_id . "' and c.parent_id = '" . (int)$parent_id . "' order by c.sort_order, cd.categories_name");
    while ($categories = $db->fetch_array($categories_query)) {
      if ($exclude != $categories['categories_id']) $category_tree_array[] = array('id' => $categories['categories_id'], 'text' => $spacing . $categories['categories_name']);
      $category_tree_array = tep_get_category_tree($categories['categories_id'], $spacing . '&nbsp;&nbsp;&nbsp;', $exclude, $category_tree_array);
    }

    return $category_tree_array;
}