<?php
|
|
namespace app\admin\controller;
|
|
use think\facade\Cache;
|
use think\facade\Db;
|
use think\facade\View;
|
use think\facade\Request;
|
|
class CountryCode extends Common {
|
private $viewPath = 'country_code';
|
/**
|
* 菜单列表
|
*/
|
public function index() {
|
////////
|
if (!Request::isPost()) {
|
$guide['one']['text'] = '基础信息设置';
|
$guide['two']['text'] = '国家城市管理';
|
View::assign('guide', $guide);
|
View::assign('viewPath', $this->viewPath);
|
return View::fetch('index');
|
}
|
}
|
public function getCountryCodeList() {
|
if (!Request::isPost()) {
|
return $this->errorResponse(lang('request_method_incorrect'));
|
}
|
try {
|
$father_id = input('father_id');
|
$where[] = ['father_id','=',$father_id];
|
$order = 'order_id asc,id asc';
|
$list = Db::name('country_code')->field('id,cate_name,cate_code,order_id,status,father_id')->where($where)->order($order)->select()->toArray();
|
if(!$list){
|
return $this->errorResponse('暂无菜单');
|
}
|
$reuslt['list'] = $list;
|
return $this->successResponse($reuslt);
|
} catch (\Exception $e) {
|
return $this->errorResponse($e->getMessage());
|
}
|
}
|
/**
|
* 更新显示状态
|
*/
|
public function updateShow() {
|
header('Content-Type:text/html;charset=utf-8');
|
if (!Request::isPost()) {
|
return $this->errorResponse(lang('request_method_incorrect'));
|
}
|
$id = input('id');
|
if (!is_numeric($id)) {
|
return $this->errorResponse('参数错误');
|
}
|
$status = input('status');
|
$info = Db::name('country_code')->field('id')->where('id', $id)->find();
|
if (empty($info)) {
|
return $this->errorResponse('信息不存在');
|
}
|
if ($status == '1') {
|
$data['status'] = 1;
|
} else {
|
$data['status'] = 0;
|
}
|
$backval = Db::name('country_code')->where('id', $id)->save($data);
|
if ($backval === FALSE) {
|
return $this->errorResponse('更新失败');
|
} else {
|
$this->delCache();
|
return $this->successResponse('更新成功');
|
}
|
}
|
|
/**
|
* 保存国家信息
|
* @return array|int[]
|
*/
|
public function saveCountryCode() {
|
if (!Request::isPost()) {
|
return $this->errorResponse(lang('request_method_incorrect'));
|
}
|
$id = input('id');
|
$data = Request::post();
|
$id = $data['id'];
|
if (is_numeric($id)) {
|
//更新数据
|
$validate = new \app\admin\validate\CountryCode();
|
$result = $validate->check($data);
|
if (!$result) {
|
return $this->errorResponse($validate->getError());
|
}
|
//////保存////////////
|
Db::name('country_code')->where('id', $id)->withoutField('id')->save($data);
|
////////////////////////
|
$this->delCache();
|
$res['message'] = '编辑成功';
|
return $this->successResponse($res);
|
} else {
|
unset($data['id']);
|
$data['status'] = 1;
|
$validate = new \app\admin\validate\CountryCode();
|
$result = $validate->check($data);
|
if (!$result) {
|
return $this->errorResponse($validate->getError());
|
}
|
//////////////////////
|
Db::startTrans();
|
try {
|
$new_id = Db::name('country_code')->insertGetId($data);
|
if ($new_id) {
|
Db::name('country_code')->where('id', $new_id)->save(['order_id' => $new_id]);
|
///////执行成功，提交事务///////
|
Db::commit();
|
$this->delCache();
|
$res['message'] = '添加成功';
|
return $this->successResponse($res);
|
} else {
|
//任一执行失败，执行回滚操作
|
Db::rollback();
|
return $this->errorResponse('添加失败');
|
}
|
} catch (\Exception $e) {
|
// 回滚事务
|
Db::rollback();
|
return $this->errorResponse('添加失败');
|
}
|
}
|
}
|
/*
|
* 保存城市信息
|
*/
|
public function saveCityCode() {
|
if (!Request::isPost()) {
|
return $this->errorResponse(lang('request_method_incorrect'));
|
}
|
$id = input('id');
|
$data = Request::post();
|
$id = $data['id'];
|
if (is_numeric($id)) {
|
//更新数据
|
$validate = new \app\admin\validate\CountryCode();
|
$result = $validate->scene('city')->check($data);
|
if (!$result) {
|
return $this->errorResponse($validate->getError());
|
}
|
//////保存////////////
|
Db::name('country_code')->where('id', $id)->withoutField('id')->save($data);
|
////////////////////////
|
$this->delCache();
|
$res['message'] = '编辑成功';
|
return $this->successResponse($res);
|
} else {
|
unset($data['id']);
|
$data['status'] = 1;
|
$validate = new \app\admin\validate\CountryCode();
|
$result = $validate->scene('city')->check($data);
|
if (!$result) {
|
return $this->errorResponse($validate->getError());
|
}
|
//////////////////////
|
Db::startTrans();
|
try {
|
$new_id = Db::name('country_code')->insertGetId($data);
|
if ($new_id) {
|
Db::name('country_code')->where('id', $new_id)->save(['order_id' => $new_id]);
|
///////执行成功，提交事务///////
|
Db::commit();
|
$this->delCache();
|
$res['message'] = '添加成功';
|
return $this->successResponse($res);
|
} else {
|
//任一执行失败，执行回滚操作
|
Db::rollback();
|
return $this->errorResponse('添加失败');
|
}
|
} catch (\Exception $e) {
|
// 回滚事务
|
Db::rollback();
|
return $this->errorResponse('添加失败');
|
}
|
}
|
}
|
/**
|
* 清除缓存
|
* @return void
|
*/
|
private function delCache() {
|
Cache::tag('country_code')->clear();
|
}
|
|
}
|
