ICMS一键按天按作者获取文章列表，在使用ICMS系统时候，在实际工作应用中可能涉及到多人多账户操作一个系统，并且工作中要求做报表的情况。做报表量少的情况可以直接少量复制，量大的时候我们就需要考虑如何提效率了。一下代码存入php文件中，访问PHP文件即可获取前面所提到的需求列表：
<?php require (dirname(__FILE__). '/iCMS.php');
header(
"Content-type:text/html;charset=utf-8");
$p = (int)$_GET['p']?(int)$_GET['p']:1;
//分页数 $user=$_GET[ 'user']?$_GET[
'user']:0;
$user = iSecurity::escapeStr($user);
$map_where = a rray();
$sql = '' ;
$orderby = 'id desc' ;
$pageSize = 3 0;
$sqls = iDB::all(
"SELECT id FROM `icms_article`");
$total = c ount($sqls);
function pageBar($total,$pageSize = 20,$showPage = 5,$user = 0) {
//第一个参数为条数 第二个参数为每页显示几个 需要与之前遍历数据处相同 $page=( int)$_GET[ 'p']?(int)$_GET[
'p']:1;
$user = $_GET['user']?$_GET['user']:0;
//获取作者 $user=iSecurity::escapeStr($user);
if ($user != "0") {
$sqlu = iDB::all(
"SELECT id FROM `icms_article` where `editor` like '%{$user}%'");
$total = c ount($sqlu);
}
$total = $ total;
$totalPage = c eil($total / $pageSize);
//获取总页数 $pageOffset=( $showPage - 1) / 2; //页码偏移量 $pageBanner="" ; if($total){
$pageBanner = "<span>总条数：" .$total. "</span>";
}
$pageSelf = $ _SERVER[
'PHP_SELF'];
$pageSelf = $pageSelf. "?user=".$user. "&";
$start = 1 ;
//开始页码 $end=$
totalPage;
//结束页码 if($page>
1) {
$pageBanner .= "
<a href='".$pageSelf."p=1'>
首页
</a>
";
$pageBanner .= "
<a href='".$pageSelf."p=".($page - 1)."'>
上一页
</a>
";
}
if ($totalPage > $showPage) {
//当总页数大于显示页数时 if($page > $pageOffset
+ 1) {
//当当前页大于页码偏移量+1时，也就是当页码为4时 开始页码1替换为... $pageBanner .= "..."; } if($page > $pageOffset) {
//当当前页大于页码偏移量时 开始页码变为当前页-偏移页码 $start = $page - $pageOffset;
$end = $totalPage > $page + $pageOffset ? $page + $pageOffset : $totalPage;
//如果当前页数+偏移量大于总页数 那么$end为总页数 }else{ $start = 1; $end = $totalPage > $showPage
? $showPage : $totalPage;
}
if ($page + $pageOffset > $totalPage) {
$start = $start - ($page + $pageOffset - $end);
}
}
for ($i = $start ; $i <= $ end ; $i++) {
//循环出页码 if($i==$ page){ $pageBanner .="<span>" .$i.
"</span>";
} else {
$pageBanner .= "<a href='" .$pageSelf. "p=".$i. "'>".$i.
"</a>";
}
}
if ($totalPage >
$showPage && $totalPage > $page + $pageOffset) {
//当总页数大于页码显示页数时 且总页数大于当前页+偏移量
$pageBanner .= "...";
}
if ($page < $totalPage) {
$pageBanner .= "<a href='" .$pageSelf. "p=".($page + 1).
"'>下一页</a>";
$pageBanner .= "<a href='" .$pageSelf. "p=".$totalPage. "'>尾页</a>";
}
if ($total == "0") {
$pageBanner = "暂无数据！" ;
}
echo $pageBanner;
}
if (($sql == ""
) and ($user != "0")) {
$sql = " where `editor` like '%{$user}%'" ;
} else
if (($sql == "") and ($user == "0")) {
$sql = $sql;
} else {
$sql.= " and `editor` like '%{$user}%'"
;
}
$pagenote = $p-1;
if ($pagenote < 0) {
$pagenote = 0;
}
$pagenote = $pagenote*$pageSize;
$limit = 'LIMIT ' .$pagenote. ','.$pageSize;
$rs = i DB::all(
"SELECT * FROM `icms_article` {$sql} ORDER BY {$orderby} {$limit}");
$users = iDB::all(
"SELECT uid,username,nickname,status FROM `icms_user` where status=1 ORDER BY uid DESC");
$categoryArray = c ategory::multi_get($rs, 'cid');
$scategoryArray = c
ategory::multi_get($rs, 'scid');
if ($rs) foreach ($rs as $key =>
$value) {
$C = (array)$categoryArray[$value['cid']];
$iurl = iURL::get('article',array($value,$C));
$value['url'] = $iurl->href;
}
?>
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
<title>文章归档</title>
<!-- Bootstrap -->
<link href="https://cdn.jsdelivr.net/npm/bootstrap@3.3.7/dist/css/bootstrap.min.css" rel="stylesheet">
<!--[if lt IE 9]>
<script src="https://cdn.jsdelivr.net/npm/html5shiv@3.7.3/dist/html5shiv.min.js">
</script>
<script src="https://cdn.jsdelivr.net/npm/respond.js@1.4.2/dest/respond.min.js">
</script>
<![endif]-->
</head>
<body>
<div style="margin-top: 20px;">
<div>
<div>
<div>
<div>
<ul>
<li>发布者：
<select name="user" id="user">
<option value="0" <?php if ($user=="0" ) { echo "selected=''"; } ?>>显示全部</option>
<?php if ($users); foreach ($users as $k=>$v) { if ($v['nickname'] != "技术部") { //unset($v['nickname']); $select=""; if (($v['nickname'] == $user) and $user != "0") { $select = "selected"; } echo "
<option value='".$v[' nickname ']."' ".$select.">".$v['nickname']."</option>"; } } ?></select>
</li>
</ul>
</div>
<table class="table table-condensed table-hover table-bordered table-striped">
<tr>
<th colspan="5" style="padding:10px 0 10px 5px;font-size: 18px;">文章归档</th>
</tr>
<tr>
<th>时间</th>
<th>标题</th>
<th>url</th>
<th>栏目</th>
<th>发布人</th>
</tr>
<?php if ($rs) foreach ($rs as $key=>$value) { $C = (array)$categoryArray[$value['cid']]; $iurl = iURL::get('article',array($value,$C)); $value['url'] = $iurl->href; ?>
<tr>
<td>
<?php if ($value[ 'pubdate']) echo get_date($value[ 'pubdate'], 'Y-m-d H:i'); ?>
</td>
<td>
<a href="<?php echo $value['url'] ;
?>" target="_blank">
<?php echo $value[ 'title'] ; ?>
</a>
</td>
<td>
<?php echo $value[ 'url'] ; ?>
</td>
<td>
<?php echo $C[ 'name'] ; ?>
</td>
<td>
<?php echo $value[ 'editor'] ; ?>
</td>
</tr>
<?php } ?>
<tr>
<th colspan="5">
<?php pageBar($total,$pageSize); ?>
</th>
</tr>
</table>
</div>
</div>
</div>
</div>
<style type="text/css">
* {
padding:0px;
margin:0px;
}
li {
list-style:none;
}
.titall {
width:100%;
height:auto;
overflow:hidden;
margin:auto;
}
.titall th {
text-align: center;
}
.success th span {
color: #f00;
}
.success th a, .success th span {
display:inline-block;
font-size: 16px;
line-height: 1.5;
padding: 3px 5px;
}
.success th span.totla {
color:#2c2a2a;
margin-right:10px;
}
</style>
<script src="https://cdn.jsdelivr.net/npm/jquery@1.12.4/dist/jquery.min.js">
</script>
<script src="https://cdn.jsdelivr.net/npm/bootstrap@3.3.7/dist/js/bootstrap.min.js">
</script>
<script type="text/javascript">
$("#user").change(function () {
var user = $("#user").val();
var host = window.location.host;
var href = 'http://' + host + '/updata.php?p=1&user=' + user + '';
window.location.href = href;
});
</script>
</body>
</html>
