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;
}
//签单之星,上个星期谁签单的业务最多,或者最少
//签单之星,上个星期谁签单的业务最多,或者最少
case "signStar":
$desc = isset($_REQUEST['desc']) ? $_REQUEST['desc'] == "true" : false;
$number = isset($_REQUEST['number']) ? intval($_REQUEST['number']) : 5;
$number = $number < 1 ? 5 : $number;
$startTime = date("Y-m-d H:i:s", mktime(0, 0, 0, date("m"), date("d") - date("w") + 1 - 7, date("Y")));
$endTime = date("Y-m-d H:i:s", mktime(23, 59, 59, date("m"), date("d") - date("w") + 7 - 7, date("Y")));
$res = getSignStar($desc, $number, $startTime, $endTime);
break;
//获取所有潜在业务，扫楼名单
//获取所有潜在业务，扫楼名单
case "getAllPotentialBusiness":
//'address','proprietor','phone' 模糊查询
// 'regionID','status','salesman','salesmanName' 精确查询
$res = getAllPotentialBusiness($_REQUEST);
break;
//增加潜在业务，扫楼名单
//增加潜在业务，扫楼名单
case "addPotentialBusiness":
$res = addPotentialBusiness($_REQUEST);
break;
//修改潜在业务，扫楼名单
//修改潜在业务，扫楼名单
case "editPotentialBusiness":
$res = editPotentialBusiness($_REQUEST);
break;
//删除潜在业务，扫楼名单
//删除潜在业务，扫楼名单
case "deletePotentialBusiness":
$res = deletePotentialBusiness($_REQUEST['id']);
