igamebox
/
mtb_crm_asp


			
				
					
						
						
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152
							<?php
require_once('conn.php');

// Check login status (assuming you have a similar function in PHP)
checkLogin("信息管理");

// Initialize variables to avoid undefined warnings
$page = isset($_GET['Page']) ? $_GET['Page'] : 1;
$keys = isset($_GET['Keys']) ? urlencode($_GET['Keys']) : '';
$keyscode = isset($_GET['Keys']) ? htmlspecialcharsFix($_GET['Keys']) : '';

// Prepare the SQL query with proper escaping
$search_term = mysqli_real_escape_string($conn, $keyscode);
$sql = "SELECT * FROM logrecord WHERE loginAct LIKE '%$search_term%' ORDER BY id DESC";
$result = mysqli_query($conn, $sql);

// Get total records for pagination
$total_records = mysqli_num_rows($result);
$records_per_page = 20;
$total_pages = ceil($total_records / $records_per_page);

// Validate page number
if ($page === 'end') {
    $page = $total_pages;
}
if (!is_numeric($page) || $page < 1) {
    $page = 1;
}
if ($page > $total_pages) {
    $page = $total_pages;
}

// Calculate offset for pagination
$offset = ($page - 1) * $records_per_page;
$sql .= " LIMIT $offset, $records_per_page";
$result = mysqli_query($conn, $sql);
?>
<!DOCTYPE html>
<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">
    <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 (mysqli_num_rows($result) > 0) {
            $temp_num = $offset;
            while ($row = mysqli_fetch_assoc($result)) {
                $temp_num++;
                ?>
                <tr onMouseOver="this.style.background='#F7FCFF'" onMouseOut="this.style.background='#FFFFFF'">
                    <td align="center"><?php echo $temp_num; ?></td>
                    <td align="center"><?php echo htmlspecialcharsFix($row['loginTime']); ?></td>
                    <td align="center"><?php echo htmlspecialcharsFix($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) {
                        $page_name = "?Keys=" . $keys . "&";
                        $page_len = 3;

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

                        // Calculate page range
                        if ($page_len * 2 + 1 >= $total_pages) {
                            $start_page = 1;
                            $end_page = $total_pages;
                        } else {
                            if ($page <= $page_len + 1) {
                                $start_page = 1;
                                $end_page = $page_len * 2 + 1;
                            } else {
                                $start_page = $page - $page_len;
                                $end_page = $page + $page_len;
                            }
                            if ($page + $page_len > $total_pages) {
                                $start_page = $total_pages - $page_len * 2;
                                $end_page = $total_pages;
                            }
                        }

                        // Page numbers
                        for ($i = $start_page; $i <= $end_page; $i++) {
                            if ($i == $page) {
                                echo "<a class=\"current\">{$i}</a>";
                            } else {
                                echo "<a href=\"{$page_name}Page={$i}\">{$i}</a>";
                            }
                        }

                        // Next page links
                        if ($page < $total_pages) {
                            if ($total_pages - $page > $page_len) {
                                echo "<a href=\"{$page_name}Page={$total_pages}\">...{$total_pages}</a>";
                            }
                            echo "<a href=\"{$page_name}Page=" . ($page + 1) . "\">下一页</a>";
                            echo "<a href=\"{$page_name}Page={$total_pages}\">尾页</a>";
                        }
                    }
                    ?>
                    </div>
                    <div class="searchbox">
                        <input type="text" id="keys" class="inputTxt" 
                            value="<?php echo empty($keyscode) ? '请输入搜索关键词' : htmlspecialcharsFix($keyscode); ?>" 
                            onFocus="if(this.value == '<?php echo empty($keyscode) ? '请输入搜索关键词' : htmlspecialcharsFix($keyscode); ?>'){this.value='';}" 
                            onBlur="if(this.value == ''){this.value='<?php echo empty($keyscode) ? '请输入搜索关键词' : htmlspecialcharsFix($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>
<?php mysqli_close($conn); ?>
</body>
</html>