<?php

/**

* 地域处理

* ============================================================================

* * 版权所有 2005-2012 广州新泛联数码有限公司，并保留所有权利。

* 网站地址: http://www..com；

* ----------------------------------------------------------------------------

* 这不是一个自由软件！您只能在不用于商业目的的前提下对程序代码进行修改和

* 使用；不允许对程序代码以任何形式任何目的的再发布。

* ============================================================================

* $Author: zenghd $

* $Id: region.php 17217 2014-08-20 11:08:08Z zenghd $

*/

define('IN_ECS', true);

require(dirname(__FILE__) . '/includes/init.php');

include(dirname(__FILE__) . '/includes/cls_json.php');

$json = new JSON;

$smarty->assign('categories_pro', get_categories_tree_pro()); // 分类树加强版/* 周改 */

$smarty->assign('navigator_list',get_navigator($ctype, $catlist)); //自定义导航栏

$smarty->assign('helps', get_shop_help()); // 网店帮助

if($_POST['act'] == ''){

$region_table = $ecs->table('region');

$table_arr = explode('.',$region_table);

$table = substr($table_arr[1],1,-1);

$sql_region = "SHOW TABLES LIKE '{$table}'";

$tb_name = $db->getOne($sql_region);

if($tb_name == $table){

//echo 11;

$sql_capital = "SHOW COLUMNS FROM {$region_table} LIKE 'capital' ";

$col_capital_name = $db->getOne($sql_capital);

$sql_pinyin = "SHOW COLUMNS FROM {$region_table} LIKE 'pinyin' ";

$col_pinyin_name = $db->getOne($sql_pinyin);

if(empty($col_capital_name)){

$sql_add_capital = "ALTER TABLE {$region_table} ADD `capital` char(1) not null DEFAULT 'A' ";

$db->query($sql_add_capital);

}

if(empty($col_pinyin_name)){

$sql_add_capital = "ALTER TABLE {$region_table} ADD `pinyin` varchar(50) not null DEFAULT 'abcd' ";

$db->query($sql_add_capital);

}

if(empty($col_capital_name) || empty($col_pinyin_name)){

$sql = "SELECT region_id,region_name FROM {$region_table}";

$rows=array();

$rows = $db->getAll($sql);

//dump($rows);

foreach($rows as $row){

//echo $row['region_name'];

$spell = Pinyin($row['region_name'],'utf-8');

if($row['region_name'] == '亳州'){

$spell = 'bozhou';

}

if($row['region_name'] == '儋州'){

$spell = 'danzhou';

}

if($row['region_name'] == '衢州'){

$spell = 'quzhou';

}

if($row['region_name'] == '重庆'){

$spell = 'chongqing';

}

$capital=strtoupper(substr($spell, 0, 1));

$sql_update="UPDATE {$region_table} SET capital = '$capital',pinyin = '$spell' WHERE region_id = '".$row['region_id']."'";

$db->query($sql_update);

}

}

}else{

echo "<script type='text/javascript'>alert('您的region数据表不存在,无法进行数据的读取！')</script>";

}

$smarty->assign('reset_css_path', 'themes/' . $_CFG['template'] . '/reset.css');

$smarty->assign('choosecities_css_path', 'themes/' . $_CFG['template'] . '/choosecities.css');

assign_template();

$smarty->display('region.dwt');

}

if($_REQUEST['act'] == 'change_city'){

$city_id = intval($_REQUEST['city_id']);

$sql_url = "SELECT agency_url FROM " . $ecs->table('agency_url').'WHERE region_id ='.$city_id;

$agency_url = $db->getOne($sql_url);

if($agency_url){

header("Location:http://".$agency_url);

}else{

echo "<script type='text/javascript'>alert('您所选择的城市还没有代理商哦！')</script>";

exit();

}

}elseif($_REQUEST['act'] == 'user_address'){

$type = !empty($_REQUEST['type']) ? intval($_REQUEST['type']) : 0;

$parent = !empty($_REQUEST['parent']) ? intval($_REQUEST['parent']) : 0;

$address['regions'] = get_regions($type, $parent);

$address['type'] = $type;

$address['target'] = !empty($_REQUEST['target']) ? stripslashes(trim($_REQUEST['target'])) : '';

$address['target'] = htmlspecialchars($address['target']);

die($json->encode($address));

}elseif($_POST['act'] == 'inquer_region'){

$region = $_POST['region'] ? mysql_real_escape_string($_POST['region']) : '';

$parent = $_POST['parent'] ? intval($_POST['parent']) : 0;

switch($region){

case 'province':

$region_type = 1;

break;

case 'city':

$region_type = 2;

break;

case 'area':

$region_type = 3;

break;

}

$parent_id = $parent;

$sql = "SELECT region_id,region_name FROM " . $ecs->table('region') .

" WHERE parent_id = $parent_id AND region_type = $region_type ";

$result = $db->getAll($sql);

//dump($result);

//$json->encode($result);

die($json->encode($result));

}elseif($_POST['act'] == 'select_search'){

$city_id = $_POST['city_id'] ? intval($_POST['city_id']) : 0;

$sql_url = "SELECT agency_url FROM " . $ecs->table('agency_url').'WHERE region_id ='.$city_id;

$agency_url = $db->getOne($sql_url);

//header("Location:http://".$agency_url);

$result_url = array();

$result_url['url'] = $agency_url;

die($json->encode($result_url));

}elseif($_POST['act'] == 'word_search'){

$keyword = !empty($_POST['keyword']) ? $_POST['keyword'] : '';

$sql = "SELECT region_id,region_name,pinyin FROM " . $ecs->table('region') ." WHERE region_name LIKE '$keyword%' OR pinyin LIKE '$keyword%'";

$rows = $db->getAll($sql);

//dump($rows);

die($json->encode($rows));

}elseif($_POST['act'] == 'capital_search'){

#读取缓存

$rows = read_static_cache('region');

if($rows === false)

{

$sql = "SELECT region_id,region_name,capital FROM " . $ecs->table('region') . " WHERE region_type = 2 ORDER BY capital ASC";

$rows = array();

$rows = $db->getAll($sql);

#写入缓存

write_static_cache('region', $rows);

}

/* 对数据进行组装 start */

$arr = array();

foreach($rows as $key=>$value){

$arr[$value['capital']][] = $value;

}

$html = '';

foreach($arr as $k=>$v){

$city = '';

$html .= "<li id='city-A' class=''><div class='cf fn-clear'><div class='label'><strong>".$k.

"</strong></div><div class='label-city fn-clear'>";

foreach($v as $city_k=>$city_v){

$city .="<div class='city-content'><a class='link' onclick='jq_cookie($city_v[region_id])' value='$city_v[region_id]' ".

" style='font-size:14px;' target='_self' href='$url'>$city_v[region_name]</a>".

'<div class="city-county">';

$res = array();

$sql = "SELECT region_id,region_name,capital FROM " . $ecs->table('region') .

" WHERE parent_id = $city_v[region_id] ORDER BY capital ASC";

$res = $db->getAll($sql);

foreach($res as $k=>$v){

$x_url = "region.php?act=change_city&city_name=$v[region_name]&city_id=$v[region_id]";

$city .= " <a href='$x_url' onclick='jq_cookie($v[region_id])'>$v[region_name]</a>";

}

$city .=' </div></div>';

}

$html .= $city;

$html .= "</div></li>";

}

$html .= '<script type="text/javascript">

$(".label-city .city-content").hover(function(){

var xuliehao = $(".label-city .city-content").index($(this));

$(".city-content").removeClass("active");

$(this).addClass("active");

}

);

$(".city-content").hover(function(){},function(){

$(this).removeClass("active");

});

</script>';

/* 数据组装 and*/

die($json->encode(array($html,$rows)));

}elseif($_POST['act'] == 'query_lately_accessing'){

$lately_accessing_id = $_POST['lately_accessing_id'];

//print_r($lately_accessing_id);

if(!empty($lately_accessing_id)){

$lately_accessing_rows = array();

foreach($lately_accessing_id as $k=>$id_value){

if($id_value>0){

$region_id = intval($id_value);

$sql = "SELECT region_id,region_name FROM " . $ecs->table('region') . " WHERE region_id = {$region_id} ";

$lately_accessing_rows[] = $db->getRow($sql);

}

}

die($json->encode($lately_accessing_rows));

}

}

function Pinyin($_String, $_Code='gb2312')

}

function _Pinyin($_Num, $_Data)

}

function _U2_Utf8_Gb($_C)

}

function _Array_Combine($_Arr1, $_Arr2)

}

?>