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