148 行
3.5 KiB
PHP
可执行文件
148 行
3.5 KiB
PHP
可执行文件
<?php
|
||
|
||
/**
|
||
* 地区模型 - 数据对象模型
|
||
* @author Alexis <zimuruyan2008@163.com>
|
||
* @version LV1.0
|
||
*/
|
||
|
||
namespace Common\Model;
|
||
|
||
use Think\Model;
|
||
|
||
//[1.7.90]
|
||
|
||
/**
|
||
* Class CitysModel
|
||
* @package Common\Model
|
||
*/
|
||
class CitysModel extends BaseModel
|
||
{
|
||
protected $tableName = 'citys';
|
||
protected $fields = array(
|
||
0 => 'id', // int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
|
||
1 => 'cityid', // int(11) NOT NULL COMMENT '城市ID',
|
||
2 => 'parentid', // int(11) NOT NULL DEFAULT '0' COMMENT '父节点ID',
|
||
3 => 'city_name', // varchar(50) NOT NULL COMMENT '城市名称',
|
||
4 => 'state', // tinyint(1) NOT NULL DEFAULT '0' COMMENT '状态 0：正常 1：删除',
|
||
);
|
||
|
||
public function getListBase($map, $order)
|
||
{
|
||
$list = $this->where($map)->order($order)->select();
|
||
return $list;
|
||
}
|
||
|
||
public function getList($map, $page, $order)
|
||
{
|
||
$list = $this->where($map)->order($order)->page($page)->select();
|
||
return $list;
|
||
}
|
||
|
||
public function getCount($map, $order)
|
||
{
|
||
$list = $this->where($map)->order($order)->count();
|
||
return $list;
|
||
}
|
||
|
||
/**
|
||
* 根据ID获取地区信息
|
||
*
|
||
* @return array 根据ID获取地区信息
|
||
*/
|
||
public function getCityById($id)
|
||
{
|
||
$map ['id'] = $id;
|
||
$Citys = $this->where($map)->find();
|
||
return $Citys;
|
||
}
|
||
|
||
/**
|
||
* 添加地区信息
|
||
*
|
||
* @return 添加地区信息
|
||
*/
|
||
public function AddCity($City)
|
||
{
|
||
$ret = $this->data($City)->add();
|
||
return $ret;
|
||
}
|
||
|
||
/**
|
||
* 修改地区信息
|
||
*
|
||
* @return 修改地区信息
|
||
*/
|
||
public function updateCity($City)
|
||
{
|
||
$ret = $this->where('id=' . $City ['id'])->save($City);
|
||
return $ret;
|
||
}
|
||
|
||
/**
|
||
* 修改地区信息
|
||
*
|
||
* @return 修改地区信息
|
||
*/
|
||
public function updateCityEx($where, $City)
|
||
{
|
||
$ret = $this->where($where)->save($City);
|
||
return $ret;
|
||
}
|
||
|
||
/**
|
||
* 删除地区信息
|
||
*
|
||
* @return 删除地区信息
|
||
*/
|
||
public function deleteCity($where)
|
||
{
|
||
$ret = $this->where($where)->delete();
|
||
return $ret;
|
||
}
|
||
|
||
/**
|
||
* 根据区域ID，获取城市信息
|
||
* @param $temDistributionAreaCom 区域ID总 ","拼接
|
||
* @return mixed
|
||
*/
|
||
public function distributionAreaCityInfo($temDistributionAreaCom)
|
||
{
|
||
$cityData = $this->field('id,cityid,parentid,city_name')
|
||
->where("state = 0")
|
||
->where(array('cityid' => array('in', $temDistributionAreaCom)))
|
||
->select();
|
||
return $cityData;
|
||
}
|
||
|
||
|
||
/**
|
||
* 根据父节点，查询当前城市的上一级信息
|
||
* @param $parentId 父节点ID
|
||
* @return mixed
|
||
*/
|
||
public function getAreaCityInfoByParentId($parentId)
|
||
{
|
||
$cityData = $this->field('id,cityid,parentid,city_name')
|
||
->where("state = 0")
|
||
->where(array('cityid' => $parentId))
|
||
->find();
|
||
return $cityData;
|
||
}
|
||
|
||
|
||
/**
|
||
* 查询省市区对应的区域信息
|
||
* @param $province 省
|
||
* @param $city 市
|
||
* @param $area 区
|
||
* @return mixed
|
||
*/
|
||
public function getCityDataByCityName($province, $city, $area)
|
||
{
|
||
$cityData = $this->field('id,cityid,parentid,city_name')
|
||
->where(array('city_name' => array('in', $province . ',' . $city . ',' . $area)))
|
||
->select();
|
||
return $cityData;
|
||
}
|
||
} |