function getRegionList($data)
{
$params = array();
if (isset($data['isFrozen'])) {
array_push($params, $data['isFrozen'] == true || $data['isFrozen'] == 'true');
$sql = "select r.* from `region` r , `business` b where r.isDeleted = 'false' and b.isDeleted = 'false' and b.regionId = r.id and r.isDeleted = 'false' and isFrozen = '?' ";
} else {
$sql = "select r.* from `region` r where isDeleted = 'false' ";
}
if (isset($data['parentID'])) {
$sql = $sql . " and r.parentID = '?' ";
array_push($params, $data['parentID']);
} else {
$sql = $sql . " and r.parentID = -1 ";
}
global $mysql;
$arr = $mysql->DBGetAsMap($sql . ' order by createTime desc ', $params);
// 获取小区的业务
/*if(isset($data['parentID']) && $data['parentID'] != '-1' && $data['parentID'] != -1){
for ($i = 0; $i < count($arr); $i++) {
$arr[$i]["business"] = getBusinessByRegion($arr[$i]["id"], 'false', 'false');
}
}*/
for ($i = 0; $i < count($arr); $i++) {
if (-1 == $arr[$i]["parentID"]) {
$arr[$i]["regionListInfo"] = getRegionList(array("parentID" => $arr[$i]["id"]));
} else {
$arr[$i]["businessListInfo"] = getAllPotentialBusiness(array("regionID" => $arr[$i]["id"]));
}
}
usort($arr, function ($a, $b) {
$result = false;
if (isset($a["regionListInfo"])) {
$result = count($a["regionListInfo"]) <= count($b["regionListInfo"]);
} else {
if (isset($a["businessListInfo"])) {
$result = count($a["businessListInfo"]) <= count($b["businessListInfo"]);
}
}
return $result;
});
return $arr;
}
getPatientOverviewMaster();
break;
case "getFacility":
getFacilityList();
break;
case "getFacilityType":
getFacilityTypeList();
break;
case "getRegimens":
getRegimenList();
break;
case "UserGroupNameFetch":
UserGroupNameList();
break;
case "getRegion":
getRegionList();
break;
case "getAdjust":
getAdjustList();
break;
case "getRegionAll":
getRegionListAll();
break;
case "getgroup":
getgroup();
break;
case "getgroupMobile":
getgroupMobile();
break;
case "getgroupFortool":
getgroupFortool();
getUnit($conn);
break;
case "getDosesForm":
getDosesForm($conn);
break;
case "getFormulation":
getFormulation($conn);
break;
case "getFacilityType":
getFacilityType($conn);
break;
case "getFacilityLevel":
getFacilityLevel($conn);
break;
case "getRegionList":
getRegionList($conn);
break;
case "getFormulationByGroup":
getFormulationByGroup($conn);
break;
case "getServiceType":
getServiceType($conn);
break;
case "getProductSubGroup":
getProductSubGroup($conn);
break;
case "getFrequencyList":
getFrequencyList($conn);
break;
case "getQuadMonthList":
getQuadMonthList($conn);
<?php
include_once "conn.php";
include_once "businessDB.php";
include_once "potentialBusinessDB.php";
include_once "businessDetailDB.php";
include_once "regionDB.php";
$action = $_REQUEST["action"];
$res = "";
switch ($action) {
//获取小区列表
case "getRegionList":
$res = getRegionList($_REQUEST);
break;
//增加小区
//增加小区
case "addRegion":
$res = addRegion($_REQUEST);
break;
//删除小区
//删除小区
case "deleteRegion":
$res = deleteRegion($_REQUEST["id"]);
//删除小区下对应的业务
$res = deleteBusinessByRegion($_REQUEST["id"]);
break;
//修改小区
//修改小区
case "editRegion":
$res = editRegion($_REQUEST);
break;
