<?php
include_once('conn.php');
?>
<?php
include_once('admin_background_head.php');
?>
<?php
$sqls = <<<SQL
SELECT user,COUNT(user) counts FROM message
GROUP BY user
SQL;
$querys = mysqli_query($link, $sqls);
$inforss = mysqli_fetch_all($querys, MYSQLI_ASSOC);
$array_1 = [];//存储用户名
$array_2 = [];//存储用户留言数
$i = 0;
foreach ($inforss as $vale){
    $array_1[$i] = $vale['user'];
    $array_2[$i] = $vale['counts'];
    $i ++;
}
//var_dump($array_1);
?>
<div id="container" style="width: 100%;height: 200px"></div>
<script type="text/javascript">
    var dom = document.getElementById("container");
    var myChart = echarts.init(dom);
    var app = {};
    var option;
    option = {
        title: {
            text: '用户留言数量图'
        },
        xAxis: {
            type: 'category',
            boundaryGap: false,
            data: [
                <?php
                $i = 0;
                foreach ($array_1 as $value) {
                    echo '"';
                    echo $value;
                    echo '"';

                    $i++;
                    if ($i < count($array_1)) {
                        echo ',';
                    }
                }
                ?>
            ]
        },
        yAxis: {
            type: 'value'
        },
        series: [
            {
                data: [
                    <?php
                    $i = 0;
                    foreach ($array_2 as $value) {
                        echo $value;
                        $i++;
                        if ($i < count($array_1)) {
                            echo ',';
                        }
                    }
                    ?>
                ],
                type: 'line',
                areaStyle: {}
            }
        ]
    };

    if (option && typeof option === 'object') {
        myChart.setOption(option);
    }

</script>

<?php
$sql = <<<SQL
SELECT * FROM message
SQL;
$query = mysqli_query($link, $sql);
$infors = mysqli_fetch_all($query, MYSQLI_ASSOC);
?>
<?php
$perpage = 3;
$total_num = count($infors);
$total_page = ceil($total_num / $perpage);
$page = isset($_GET['page']) ? $_GET['page'] : 1;

$start_index = $perpage * ($page - 1);
$end_index = $perpage * $page - 1;
$end_index = min($end_index, $total_num - 1);
$count = 0;
?>
<div style="background-image: url(image/userinfor.jpg)">
    <div>
        <form action="admin_message_search.php" method="post">
            <label class="layui-form-label">用户名</label>
            <div class="layui-input-inline">
                <input type="text" name="user" lay-verify="required" placeholder="请输入" autocomplete="off" class="layui-input">
            </div>
            <button type="button" class="layui-btn layui-btn-normal"><input type="submit" value="搜索"
                                                                            style="background-color: #33CCFF"></button>
        </form>
    </div>
    <table border="1" width="100%" height="100" cellspacing="0" cellpadding="5">
        <tr>

            <th colspan="20" class="layui-bg-blue">留言信息</th>
        </tr>
        <tr>
            <th>序号</th>
            <th>用户</th>
            <th>内容</th>
            <th>时间</th>
            <th>操作</th>
        </tr>
        <?php
        for ($i = $start_index; $i <= $end_index; $i++) {
            $count++;

            ?>
            <tr>
                <td><?php echo $count; ?></td>
                <td><?php echo $infors[$i]['user']; ?></td>
                <td><?php echo $infors[$i]['content']; ?></td>
                <?php date_default_timezone_set("PRC"); ?>
                <td><?php echo date("Y-m-d H:i:s", $infors[$i]['time']); ?></td>
                <td><a href="admin_message_infor_delete_start.php?messageid=<?php echo $infors[$i]['id'] ?>">删除</a></td>
            </tr>
            <?php
        }
        ?>
    </table>

    <div class="page">
        <a href="?page=1">首页</a>
        <?php
        $pre_page = ($page - 1) < 1 ? 1 : ($page - 1);
        ?>
        <a href="?page=<?php echo $pre_page; ?>">上一页</a>
        <?php
        $next_page = ($page + 1) > $total_page ? $total_page : ($page + 1);
        ?>
        <a href="?page=<?php echo $next_page; ?>">下一页</a>
        <form action="" method="get" class="free_page">
            <input type="text" name="page">
            <input type="submit" value="确定">
        </form>
    </div>
</div>
<?php
include_once('admin_background_foot.php');
?>