/***
* @return \think\response\Json
* 更新城市json数据
*/
public function makejsonareas(){
set_time_limit(0);
$pro = Db::table('up_area')
->where('level',1)
// ->where('district_id',1001)
->field('district_id id,district name')
->select();
$shi = Db::table('up_area')
->where('level',2)
->field('district_id id,district name,pid parentId')
->select();
$qu = Db::table('up_area')
->where('level',3)
->field('district_id id,district name,pid parentId')
->select();
$street = Db::table('up_area')
->where('level',4)
->field('district_id id,district name,pid parentId')
->select();
foreach ($qu as $k=>$v){
foreach ($street as $kk=>$vv){
if($vv['parentId'] == $v['id']){
$qu[$k]['sub'][] = $vv;
}
}
}
foreach ($shi as $k=>$v){
foreach ($qu as $kk=>$vv){
if($vv['parentId'] == $v['id']){
$shi[$k]['sub'][] = $vv;
}
}
}
foreach($pro as $k=>$v){
$pro[$k]['parentId'] = 0;
foreach ($shi as $kk=>$vv){
if($vv['parentId'] == $v['id']){
$pro[$k]['sub'][] = $vv;
}
}
}
$root = $_SERVER['DOCUMENT_ROOT'];
$myfile = fopen("$root/static/test.json", "w") or die("Unable to open file!");
$txt = json_encode($pro);
fwrite($myfile, $txt);
fclose($myfile);
return json(['code' => 200, 'msg' => '更新成功']);
}