$res_check['hot'][$key_hot]['medianum'] = 0;
$check_hot_media = explode(';', $res_hot_details['media']);
foreach ($check_hot_media as $key_hot_me => $val_hot_me) {
if ($val_hot_me == null) {
unset($check_hot_media[$key_hot_me]);
} else {
++$res_check['hot'][$key_hot]['medianum'];
}
}
$res_check['hot'][$key_hot]['media'] = $check_hot_media;
$res_check['hot'][$key_hot]['id'] = $val_hot['activityId'];
//Id
$res_check['hot'][$key_hot]['content'] = $res_hot_details['content'];
//文字描述
//查询出评论数和点赞数
$res_check['hot'][$key_hot]['lwdNum'] = $lwd->lwdNum($val_hot['activityId']);
$res_check['hot'][$key_hot]['zanNum'] = $zan->zanNum($val_hot['activityId']);
$res_check['hot'][$key_hot]['date'] = $res_hot_details['date'];
}
//查看用户参与情况
$page = $_GET['page'];
//获得当前页码
$num = 10;
//每页显示的条数
if ($res_audit['flag'] == 1) {
//审核功能开启
$sql_check1 = "select id from wx_activity_interact where audit=1 and projectId=" . $projectId;
} else {
//审核功能关闭
$sql_check1 = "select id from wx_activity_interact where projectId=" . $projectId;
}
//查找是否有置顶项，在首页显示
$sql_top_select = "select id,title,thumb,abstract,content,date,is_leaveword,is_zan,importance from wx_info where moduleId='{$moduleId}' and importance=1 order by date desc ";
$res_top_select = $db->execsql($sql_top_select);
if (!empty($res_top_select)) {
//有置顶项
$list['top'] = $res_top_select;
}
$sql_info = "select id,title,thumb,abstract,content,date,importance from wx_info where moduleId='{$moduleId}' and importance=0 order by date desc limit " . $start . "," . $num;
$res_info = $db->execsql($sql_info);
} else {
$sql_info = "select id,title,thumb,abstract,content,date,importance from wx_info where moduleId='{$moduleId}' and importance=0 order by date desc limit " . $start . "," . $num;
$res_info = $db->execsql($sql_info);
}
foreach ($res_info as $key_list => $val_list) {
// 根据文章信息ID在wx_leaveword表中查询出该文章信息的评论次数，在wx_zan表中查询出该文章信息的点赞次数
$list['normal'][$key_list]['num_leaveword'] = $lwd->lwdNum($val_list['id']);
//评论次数
$list['normal'][$key_list]['num_zan'] = $zan->zanNum($val_list['id']);
//点赞次数
$list['normal'][$key_list]['id'] = $val_list['id'];
$list['normal'][$key_list]['thumb'] = $val_list['thumb'];
$list['normal'][$key_list]['title'] = $val_list['title'];
$list['normal'][$key_list]['date'] = $val_list['date'];
$list['normal'][$key_list]['importance'] = $val_list['importance'];
$list['normal'][$key_list]['abstract'] = $val_list['abstract'];
$list['normal'][$key_list]['content'] = $val_list['content'];
}
echo json_encode($list);
} elseif ($type == 'details') {
/**
* ************显示某篇文章信息的具体内容***************
$res_check2 = $db->execsql($sql_check2);
foreach ($res_check2 as $key_check => $val_check) {
// 根据userId在wx_user中查询出作者的微信号和微信头像
$sql_user_name = "select wechatName, header from wx_user where openid='{$val_check['userId']}'";
$res_user_name = $db->getrow($sql_user_name);
$res_check['join'][$key_check]['wechatName'] = $res_user_name['wechatName'];
$res_check['join'][$key_check]['header'] = $res_user_name['header'];
// 将查询出的每个media的url根据“；”分开，单独存放
$check_media = explode(';', $val_check['media']);
$res_check['join'][$key_check]['media'] = $check_media;
$res_check['join'][$key_check]['id'] = $val_check['id'];
//Id
$res_check['join'][$key_check]['content'] = $val_check['content'];
//文字描述
//查询出评论数和点赞数
$res_check['join'][$key_check]['lwdNum'] = $lwd->lwdNum($val_check['id']);
$res_check['join'][$key_check]['zanNum'] = $zan->zanNum($val_check['id']);
$res_check['join'][$key_check]['date'] = $val_check['date'];
$res_check['join'][$key_check]['pic_audit'] = $val_check['audit'];
}
echo json_encode($res_check);
}
} else {
echo 0;
//参数错误
}
} elseif ($type == 'details') {
/***************查看某项活动的某个用户参与的具体信息，以及其他用户对其的评论和点赞*******************/
$activityId = $_GET['activityId'];
if ($regex->isNumber($activityId)) {
$sql_details = "select id,userId,multimediaFile as media,content,date,audit as pic_audit from wx_activity_interact where id=" . $activityId;
