1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
<?php
// 获取志愿者活动列表
require_once ("../user_include.inc");
ErrorLogger::doOutput("Compass...ajax_get_volunteer_event_list.php....Start.", 0);
//获取参数
$unionId = ParamUtil::getRequestString("unionId");
//用户所在【省市区】
$province = ParamUtil::getRequestString("province");
$city = ParamUtil::getRequestString("city");
$district = ParamUtil::getRequestString("district");
//翻页
$page = ParamUtil::getRequestNumber("page", 0);//翻页
$result = array();
//参数检查
if(empty($unionId)) {
$result["message"] = "参数错误！";
responseNG($result);
}
//判断用户是否存在
$param = array();
$param['unionid'] = $unionId;
$param['delete_flg'] = false;
$userList = UserMst::getList($param,'id','desc', 0, 1);
if(empty($userList)) {
$result["message"] = "用户不存在！";
responseNG($result);
}
//每页显示条数
$rowCount = 10;
$offset = $page * $rowCount;
$userMst = $userList[0];
//志愿者活动
$param = array();
if(DEBUG_MODE==false) {
$param['province'] = $province;
$param['city'] = $city;
$param['district'] = $district;
}
$param['status'] = "OK";
$param['delete_flg'] = false;
//社会用户和机构用户的时候，添加【是否允许社会人士参加】
if($userMst->role == 5 || $userMst->role == 6) {
$param['include_social_user'] = true;
}
$volunteerEventList = array();
$tmpVolunteerEventList = VolunteerEventDat::getList($param,'id','desc', $offset, $rowCount);
$volunteerEvenCount = VolunteerEventDat::getListCount($param);
$pageCount = ceil($volunteerEvenCount/$rowCount);
//查询所在区域能力分汇总
//能力分汇总
$abilityPoint = 0;
$sql = "select sum(ability_point) as ability_point from user_mst where delete_flg = false and school_no is not null and province='{$province}'";
if(!empty($city)) {
$sql .= " and city='{$city}'";
}
if(!empty($district)) {
$sql .= " and district='{$district}'";
}
$db = &CompassDBManager::getInstance();
$tmp = $db->executeQuery($sql);
if(!empty($tmp)) {
$abilityPoint = $tmp[0]['ability_point'];
}
$result["abilityPoint"] = $abilityPoint;
//设置状态和招募范围
foreach($tmpVolunteerEventList as $tmp) {
$tmp->status_title = "征集中";
$tmp->scope = "校内";
if($tmp->include_social_user) {
$tmp->scope = "校内.社会人士";
}
$volunteerEventList[] = $tmp;
}
//组装返回数据
$result["rowCount"] = $rowCount;
$result["page"] = $page;
$result["pageCount"] = $pageCount;
$result["volunteerEventList"] = $volunteerEventList;
ErrorLogger::doOutput("Compass...ajax_get_volunteer_event_list.php....End.", 0);
//返回结果
responseOK($result);
function responseNG($result) {
$result = array("status"=>"NG", "result"=>$result);
print json_encode($result);
exit;
}
function responseOK($result) {
$result = array("status"=>"OK", "result"=>$result);
print json_encode($result);
exit;
}
?>