$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') { /** * ************显示某篇文章信息的具体内容*************** */ $infoId = $_REQUEST['infoId'];
$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; } $res_check1 = $db->execsql($sql_check1);