PHP历理 列表模板和标签库
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<meta name="renderer" content="webkit">
<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
<meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1">
<title><?php echo $titlebar;?></title>
<link rel="stylesheet" href="/_/_js/layui/css/layui.css">
<link rel="stylesheet" href="/_/_css/base.css">
<script src="/_/_js/layui/layui.js"></script>
<script src="/_/_js/jquery-1.10.1.min.js"></script>
</head>
<?php echo $setextCss;?>
<div class="layui-row t-container">
<?php include ROOT . '_php/twig/menu.php';?>
<div class="layui-col-xs12 layui-col-sm12 <?php echo $seissideCss;?>" id="top">
<div class="m-map">
<a href="###" class="g-l lb-menu"><i class="layui-icon"></i> 菜单</a>
<a href="###" class="g-r lb-save"><i class="layui-icon"></i> 收藏</a>
<ul>
<li><a href="/admin.php">主页</a> <span>/</span></li>
<script>
var path = window.location.pathname;
var route = path.replace(/^(.+)\/[^\/]+$/, '$1');
var routename = path.substring(3, 6);
document.writeln('<li><a href="'+route+'">'+routename+'</a></li>');
var file = path;
var filename = path.substring(path.lastIndexOf('/') + 1);
if(filename.length<2){filename = 'index';}else{ filename = filename.replace(/\.[^/.]+$/, "")}
document.writeln('<li><a href="'+file+'">'+filename+'</a></li>');
</script>
</ul>
</div>
<form method="get" action="<?php echo htmlspecialchars($_SERVER["PHP_SELF"]);?>">
<div class="layui-row layui-form m-search">
<?php echo $form;?>
</div>
<div class="layui-btn-group m-btn">
<button type="button" class="layui-btn layui-bg-red lb-btn" id="orderbying" lay-options="{}">
<span>排序</span>
<i class="layui-icon layui-icon-down layui-font-12"></i>
</button>
<button type="button" class="layui-btn layui-bg-orange lb-btn" id="toggle">切换</button>
<button type="button" class="layui-btn layui-bg-blue lb-btn" id="show">展开</button>
<button type="submit" class="layui-btn lb-btn">搜索</button>
</div>
</form>
<div class="layui-collapse">
<?php echo $show;?>
</div>
<div class="m-page">
<div id="paging"></div>
</div>
<div class="m-path">
<?php echo $path;?>
</div>
</div>
<?php include ROOT . '_php/twig/footer.php';?>
</div>
<script src="/_/_js/foot.js"></script>
</body>
</html>
<script>
//orderby sql排序功能
var link = window.location.search;
if(link.indexOf('?') !== -1){
var parameter = 'orderby';
var pattern = new RegExp('\\b' + parameter + '=([^&]*)');
if (link.match(pattern)) {
link = link.replace(pattern, '');
if (/[&]/.test(link.slice(-1))) {
link = link.slice(0, -1);
}
}
}else{
link = '?';
}
layui.use(function () {
var dropdown = layui.dropdown;
dropdown.render({
elem: '#orderbying',
data: [<?php echo $orde;?>]
});
});
//分页功能
layui.use(function(){
var laypage = layui.laypage;
var layer = layui.layer;
laypage.render({
elem: 'paging',
count: <?php echo $number;?>,
limit: <?php echo $pageSize;?>,
prev: '<em><</em>',
next: '<em>></em>',
layout: ['skip','prev','next','count'],
curr: function(){
var page = location.search.match(/page=(\d+)/);
return page ? page[1] : 1;
}(),
jump: function(e, first){
if(!first){
var url=window.location.search;
if(url.indexOf("?")!=-1){
var str = url.substr(1);
strs = str.split("&");
var searchURL = '';
for(i=0;i<strs.length;i++) {
if(strs[i].split("=")[0]!='page'){
searchURL+='&'+strs[i].split("=")[0]+"="+strs[i].split("=")[1];
}
}
location.href = '?page='+e.curr+searchURL;
}else{
location.href = '?page='+e.curr;
}
}
}
});
});
</script>
<?php
function li_form_input($label,$type,$name,$value,$placeholder) {
$html = "<div class='layui-col-xs12 layui-col-sm6 layui-col-md4'>".PHP_EOL;
$html .= "<div class='layui-form-item'>".PHP_EOL;
$html .= "<label class='layui-form-label'>$label</label>".PHP_EOL;
$html .= "<div class='layui-input-block'>".PHP_EOL;
$html .= "<input type='$type' name='$name' value='$value' placeholder='$placeholder' class='layui-input'>".PHP_EOL;
$html .= "</div></div></div>".PHP_EOL;
return $html;
}
function li_form_select($label,$name,$option){
$html = "<div class='layui-col-xs12 layui-col-sm6 layui-col-md4'>".PHP_EOL;
$html .= "<div class='layui-form-item'>".PHP_EOL;
$html .= "<label class='layui-form-label'>$label</label>".PHP_EOL;
$html .= "<div class='layui-input-block'>".PHP_EOL;
$html .= "<select name='$name'>".PHP_EOL;
$html .= $option.PHP_EOL;
$html .= "</select></div></div></div>".PHP_EOL;
return $html;
}
function li_form_selectSql($label,$name,$placeholder,$conn,$sql,$fag){
$html = "<div class='layui-col-xs12 layui-col-sm6 layui-col-md4'>".PHP_EOL;
$html .= "<div class='layui-form-item'>".PHP_EOL;
$html .= "<label class='layui-form-label'>$label</label>".PHP_EOL;
$html .= "<div class='layui-input-block'>".PHP_EOL;
$html .= "<select name='$name'>".PHP_EOL;
$option = "<option value='0' selected>$placeholder</option>".PHP_EOL;
if($fag!=0){
$option = "<option value='0'>$placeholder</option>".PHP_EOL;
}
$result = mysqli_query($conn,$sql);
while ($res = mysqli_fetch_array($result, MYSQLI_ASSOC)) {
if($res['id']==$fag){
$option .= "<option value='{$res['id']}' selected>{$res['news']}</option>".PHP_EOL;
}else{
$option .= "<option value='{$res['id']}'>{$res['news']}</option>".PHP_EOL;
}
}
$html .= $option;
$html .= "</select></div></div></div>".PHP_EOL;
return $html;
}
function li_orde_json($title,$href){
$js = "{title: '$title',href:link+'&orderby=$href'},".PHP_EOL;
return $js;
}
function li_path_a($href,$icon,$name) {
$html = "<a href='{$href}' class='layui-btn layui-btn-primary layui-border-red'><i class='layui-icon'>{$icon}</i>$name</a>".PHP_EOL;
return $html;
}
<?php
ini_set('session.gc_maxlifetime', 86400); // 设置session的有效时间为24小时
session_start();
define('CHAOYI',true);
require $_SERVER['DOCUMENT_ROOT'].'/_/_php/data/database.php';
require ROOT.'_php/data/common.php';
require ROOT.'_php/data/config.php';
require ROOT.'_php/temp/li.inc.php';
//重新定义标题
$titlebar = '用户列表页';
$tbname = 'U11';
//权限设置
if(!($seroleId==1 || $seroleId==2 || $seroleId==3)){
mysqli_close($conn);
echo prompt('没有权限操作，请联系管理员','index.php',4,3);
exit;
}
//显示每页显示的条数
$pageSize = is_numeric($sepagenum) ? $sepagenum : 10;
$page=1;
if(isset($_GET['page']) && $_GET['page']>0){$page=$_GET['page'];}
$offset = $pageSize*($page-1);
//搜索条件
$condition='';
if(isset($_GET['id'])){
$id = filterHTML($_GET['id']);
if($id!=''){
$condition .= "AND a.id LIKE '{$id}'";
}
}
if(isset($_GET['unum'])){
$unum = filterHTML($_GET['unum']);
if($unum!=''){
$condition .= "AND a.unum LIKE '%{$unum}%'";
}
}
if(isset($_GET['wxnum'])){
$wxnum = filterHTML($_GET['wxnum']);
if($wxnum!=''){
$condition .= "AND a.wxnum LIKE '%{$wxnum}%'";
}
}
if(isset($_GET['cname'])){
$cname = filterHTML($_GET['cname']);
if($cname!=''){
$condition .= "AND a.cname LIKE '%{$cname}%'";
}
}
if(isset($_GET['level_id'])){
if($_GET['level_id']!=0){
$condition .= "AND a.level_id={$_GET['level_id']} ";
}
}
if(isset($_GET['role_id'])){
if($_GET['role_id']!=0){
$condition .= "AND a.role_id={$_GET['role_id']} ";
}
}
if(isset($_GET['bond_id'])){
if($_GET['bond_id']!=0){
$condition .= "AND a.bond_id={$_GET['bond_id']} ";
}
}
if(isset($_GET['sort'])){
$sort = filterHTML($_GET['sort']);
if($sort!=''){
$condition .= "AND a.sort LIKE '%{$sort}%'";
}
}
//重新排序条件
$reorder ='ORDER BY a.uptime DESC';
if(isset($_GET['orderby'])){
$orderby = filterHTML($_GET['orderby']);
if($orderby!=''){
$reorder = $orderby;
}
}
//获取展示的数据
$sql = "SELECT a.id, a.unum, a.wximg, a.wxnum, a.uname, a.cname, a.tel, a.aduser_id, a.upuser_id, b.tit role, c.tit bond,d.tag tag,d.tit level, a.sort, SUBSTRING(a.adtime,3,14) adtime, SUBSTRING(a.uptime,3,14) uptime FROM u11 a LEFT JOIN u11role b ON a.role_id = b.id LEFT JOIN u11bond c ON a.bond_id = c.id LEFT JOIN u11level d ON a.level_id = d.id WHERE a.isnow=1 $condition $reorder LIMIT $offset,$pageSize";
$result = sqlQuery($conn,$sql);
//获取页数
$sqlnum = "SELECT COUNT(id) id FROM u11 a WHERE isnow=1 $condition LIMIT 1";
$resnum = sqlGetOne($conn,$sqlnum);
$number = $resnum['id'];
/**
* 生成表单
*/
//生成表单HTML
$form = li_form_input($tbname.'-ID','text','id',$id,'请输入ID');
$form .= li_form_input('会员号码','text','unum',$unum,'请输入会员名称');
$form .= li_form_input('微信号码','text','wxnum',$wxnum,'请输入微信号码');
$form .= li_form_input('真实姓名','text','cname',$cname,'请输入真实姓名');
$form .= li_form_input('自定序号','text','sort',$sort,'请输入排序');
$form .= li_form_selectSql('用户等级','level_id','请输入用户等级',$conn,"SELECT id, CONCAT(tag,' ', tit) AS news FROM u11level ORDER BY sort ASC LIMIT 50",$_GET['level_id']);
$form .= li_form_selectSql('用户权限','role_id','请选择用户权限',$conn,"SELECT id, CONCAT(tit) AS news FROM u11role ORDER BY sort ASC LIMIT 50",$_GET['role_id']);
$form .= li_form_selectSql('用户关系','bond_id','请选择用户关系',$conn,"SELECT id, CONCAT(tit) AS news FROM u11bond ORDER BY sort ASC LIMIT 50",$_GET['bond_id']);
//生成列表展示的HTML
$show = "";
$enseid= enstr($seid);
$entbname = enstr($tbname);
while ($res = mysqli_fetch_array($result,MYSQLI_ASSOC)){
$tel = substr($res['tel'], 0, 11);
$show .= "<div class='layui-colla-item ui-item'><div class='layui-colla-title ui-title'><img src='{$res['wximg']}' height='20px' width='20px'> {$res['tag']}{$res['unum']}{$res['cname']} {$res['wxnum']} $tel</div><div class='layui-colla-content ui-content'><table class='layui-table ui-table layui-form'>";
$enid = enstr($res['id']);
$show .= "<tr><th>基本操作</th><td><span class='g-r'>{$tbname}-{$res['id']}</span> <a href='inup.php?f={$enid}'>修改</a> | <a href='javascript:void(0);' onclick=\"confirmDel('{$enid}','{$entbname}');\">删除</a> | <a href='inse.php?f={$enid}&u={$enseid}&w=0'>查看</a></td></tr>";
$show .= "<tr><th>微信头像</th><td><img src='{$res['wximg']}' height='50px' class='pimg'></td></tr>";
$show .= "<tr><th>用户等级</th><td>{$res['tag']}{$res['level']}</td></tr>";
$show .= "<tr><th>会员号码</th><td>{$res['unum']}</td></tr>";
$show .= "<tr><th>真实姓名</th><td>{$res['cname']}</td></tr>";
$show .= "<tr><th>微信号码</th><td>{$res['wxnum']}</td></tr>";
$show .= "<tr><th>电话号码</th><td>{$res['tel']}</td></tr>";
$show .= "<tr><th>用户权限</th><td>{$res['role']}</td></tr>";
$show .= "<tr><th>用户关系</th><td>{$res['bond']}</td></tr>";
$show .= "<tr><th>设置排序</th><td>用户排序：{$res['sort']}</td></tr>";
$weixin = sqlGetOne($conn,'SELECT CONCAT(b.tag,a.unum,a.cname) AS news FROM u11 a LEFT JOIN u11level b ON a.level_id = b.id WHERE a.id='.$res['aduser_id']);
$show .= "<tr><th>注册信息</th><td>{$res['adtime']} of {$weixin['news']}</td></tr>";
$weixin = sqlGetOne($conn,'SELECT CONCAT(b.tag,a.unum,a.cname) AS news FROM u11 a LEFT JOIN u11level b ON a.level_id = b.id WHERE a.id='.$res['upuser_id']);
$show .= "<tr><th>修改信息</th><td>{$res['uptime']} of {$weixin['news']}</td></tr>";
$show .= "</table></div></div>";
}
//生成链接HTML
$path = li_path_a('inad.php','','添加用户');
//生成搜索JS
$orde = li_orde_json('创建时间-按新到旧排序','ORDER BY a.adtime DESC');
$orde .= li_orde_json('创建时间-按旧到新排序','ORDER BY a.adtime ASC');
$orde .= li_orde_json('修改时间-按新到旧排序','ORDER BY a.uptime DESC');
$orde .= li_orde_json('修改时间-按新到旧排序','ORDER BY a.uptime ASC');
$orde .= li_orde_json('会员名称-小到大排序','ORDER BY a.unum ASC');
$orde .= li_orde_json('会员名称-大到小排序','ORDER BY a.unum DESC');
$orde .= li_orde_json('自定序号-小到大排序','ORDER BY a.sort ASC');
$orde .= li_orde_json('自定序号-大到小排序','ORDER BY a.sort DESC');
mysqli_close($conn);
include ROOT . '_php/temp/li.tpl.php';
?>
效果图：
