php地区管理,thinkphp地区管理功能

thinkphp地区管理功能的实现，实现效果图：

数据库结构：

CREATE TABLE `sp_region` (

`Id` INT(11) NOT NULL AUTO_INCREMENT,

`parent_id` INT(11) DEFAULT NULL,

`region_name` VARCHAR(120) CHARACTER SET gbk DEFAULT NULL,

`region_type` SMALLINT(5) DEFAULT NULL,

`agency_id` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',

`is_show` SMALLINT(5) NOT NULL DEFAULT '0',

PRIMARY KEY (`Id`)

) ENGINE=MYISAM AUTO_INCREMENT=3417 DEFAULT CHARSET=utf8 COLLATE=utf8_bin

前台代码：

{if $region_type=3}{$regionts}： {/if} $region_typeyuanshi,'parentid'=>$fuID))}">返回上一级

{$region_type}

{$vo['region_name']} | {if $region_type=3} $region_type,'parentid'=>$vo['Id']))}">管理 {/if} $vo['Id'],'parentid'=>$vo['Id']))}" >删除 暂无地区

注视：1级地区：国家 2级地区：省份 3级地区：市级 4级地区：县/区

public function region(){

$parent_id = intval(trim($_GET['parentid']));//父ID

$region = D("region");

$regionarr = $region->where(" parent_id=".$parent_id)->select();

if( $_GET['regiontype']=="" ){

$region_type = '0';

$regionts = "新增1级地区";

}else{

if($regionarr[0]['Id'] == ""){

//取出上一级的region_type

$regiontypearr = $region->where('id='.$parent_id)->field('region_type')->find();

$region_type = $regiontypearr['region_type']+1;

}else{

$region_type = $regionarr[0]['region_type'];

}

$regionts = $region_type+1;

$regionts = "新增".$regionts."级地区";

}

$this->assign("region_type",$region_type);//属于省份还是市

$region_typeyuanshi=$region_type-1;

$this->assign("region_typeyuanshi",$region_typeyuanshi);

$this->assign("regionts",$regionts);//文字提示

if( $regionarr[0]['parent_id'] != 0){

$fuidarr = $region->where("id=".$regionarr[0]['parent_id'])->find();//用fuID去取fuID的parent_id;

$this->assign("fuID", $fuidarr['parent_id'] );//返回上一级的时候，取的fuID

}

if( $region_type == 0 ){

$this->assign('Id', '0' );

}else{

$this->assign('Id', $parent_id );

}

$this->assign('list',$regionarr);

$this->display();

}

function delRegion(){

$region = D("Region");

//删除

if( $_GET['regionid'] != "" ){

//先判断是否有子分类

$regionid= intval( $_GET['regionid'] );

$ziarr = $region->where("parent_id=".$regionid)->select();

if( $ziarr[0]['Id'] != "" ){

$this->error("请先删除子分类！");

}else{

$region->Id=$regionid;

if($region->delete()){

$this->success();

}else{

$this->error("删除失败");

}

}

}

}

public function add(){

$Region = D('Region');

$region_name=trim($_POST['region_name']);

if(!$region_name) $this->error("新增地区不能为空！");

$Region->region_name = $region_name;

$Region->region_type = trim($_POST['region_type']);

$Region->parent_id = trim($_POST['parent_id']);

if($Region->add()){

$this->success('添加成功！');

}else{

$this->error($Region->getError());

}

}