igamebox
/
mtb_crm_asp


			
				
					
						
						
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137
							<?php
include "conn.php";
checkLogin("信息管理");
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>管理区域</title>
<link rel="stylesheet" href="css/common.css" type="text/css" />
<link rel="stylesheet" href="css/jquery.galpop.css" type="text/css" />
<script language="javascript" src="js/jquery-1.7.2.min.js"></script>
<script type="text/javascript" src="js/js.js"></script>
<script type="text/javascript" src="xheditor-1.1.9/xheditor-1.1.9-zh-cn.min.js"></script>
<script type="text/javascript" src="js/jquery.galpop.min.js"></script>
</head>
<body>
<div id="man_zone">
<?php
$page = $_GET['Page'] ?? '';
$keys = urlencode($_GET['Keys'] ?? '');
$keyscode = textEncode($_GET['Keys'] ?? '');

$sql = "SELECT * FROM logRecord WHERE loginAct LIKE ? ORDER BY id DESC";
$stmt = $conn->prepare($sql);
$stmt->execute(['%' . $keyscode . '%']);
$results = $stmt->fetchAll(PDO::FETCH_ASSOC);

$records_per_page = 20;
$total_records = count($results);
$total_pages = ceil($total_records / $records_per_page);

if ($page == "") $page = 1;
if ($page == "end") $page = $total_pages;
if (!is_numeric($page) || $page < 1) $page = 1;
$page = (int)$page;
if ($page > $total_pages) $page = $total_pages;

$start = ($page - 1) * $records_per_page;
$results = array_slice($results, $start, $records_per_page);
?>
<table width="100%" border="0" cellpadding="3" cellspacing="1" class="table1">
    <thead>
        <tr>
            <th width="10%">序号</th>
            <th width="20%">时间</th>
            <th width="70%">日志</th>
        </tr>
    </thead>
    <tbody>
    <?php
    if (!empty($results)) {
        $tempNum = ($page - 1) * $records_per_page;
        foreach ($results as $row) {
            $tempNum++;
            ?>
            <tr onMouseOver="this.style.background='#F7FCFF'" onMouseOut="this.style.background='#FFFFFF'">
                <td align="center"><?php echo $tempNum; ?></td>
                <td align="center"><?php echo $row['loginTime']; ?></td>
                <td align="center"><?php echo $row['loginAct']; ?></td>
            </tr>
            <?php
        }
    } else {
        ?>
        <tr>
            <td colspan="4">暂无相关记录</td>
        </tr>
        <?php
    }
    ?>
    </tbody>
    <tfoot>
        <tr>
            <td colspan="4">
                <div class="showpagebox">
                <?php
                if ($total_pages > 1) {
                    $pageName = "?Keys=$keys&Ord=&";
                    $pagelen = 3;

                    if ($page > 1) {
                        echo "<a href=\"{$pageName}Page=1\">首页</a>";
                        echo "<a href=\"{$pageName}Page=" . ($page-1) . "\">上一页</a>";
                    }

                    if ($pagelen * 2 + 1 >= $total_pages) {
                        $startPage = 1;
                        $endPage = $total_pages;
                    } else {
                        if ($page <= $pagelen + 1) {
                            $startPage = 1;
                            $endPage = $pagelen * 2 + 1;
                        } else {
                            $startPage = $page - $pagelen;
                            $endPage = $page + $pagelen;
                        }
                        if ($page + $pagelen > $total_pages) {
                            $startPage = $total_pages - $pagelen * 2;
                            $endPage = $total_pages;
                        }
                    }

                    for ($i = $startPage; $i <= $endPage; $i++) {
                        if ($i == $page) {
                            echo "<a class=\"current\">$i</a>";
                        } else {
                            echo "<a href=\"{$pageName}Page=$i\">$i</a>";
                        }
                    }

                    if ($page < $total_pages) {
                        if ($total_pages - $page > $pagelen) {
                            echo "<a href=\"{$pageName}Page=$total_pages\">...$total_pages</a>";
                        }
                        echo "<a href=\"{$pageName}Page=" . ($page+1) . "\">下一页</a>";
                        echo "<a href=\"{$pageName}Page=$total_pages\">尾页</a>";
                    }
                }
                ?>
                </div>
                <div class="searchbox">
                    <input type="text" id="keys" class="inputTxt" 
                           value="<?php echo ($keyscode == "") ? "请输入搜索关键词" : $keyscode; ?>" 
                           onFocus="if(this.value == '<?php echo ($keyscode == "") ? "请输入搜索关键词" : $keyscode; ?>'){this.value='';}" 
                           onBlur="if(this.value == ''){this.value='<?php echo ($keyscode == "") ? "请输入搜索关键词" : $keyscode; ?>';}" 
                           onKeyDown="if(event.keyCode==13){location.href='?Keys='+escape(document.getElementById('keys').value)+'&Page=<?php echo $page; ?>'}" />
                    <input type="button" id="searchgo" class="searchgo" value="go" 
                           onClick="location.href='?Keys='+escape(document.getElementById('keys').value)+'&Page=<?php echo $page; ?>'" />
                </div>
            </td>
        </tr>
    </tfoot>
</table>
</div>
</body>
</html>