$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;