slowquery/config.php at master · hectorqin/slowquery · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
<?php

if (!function_exists('env')) {
    function env($name, $default = null)
    {
        static $env = null;
        if (is_null($env)) {
            $env = is_file(".env") ? parse_ini_file(".env") : (is_file("../.env") ? parse_ini_file("../.env") : []);
        }
        return isset($env[$name]) ? $env[$name] : $default;
    }
}

if (!function_exists('db')) {
    function db()
    {
        static $connection = null;
        if (is_null($connection)) {
            $connection = mysqli_connect(env('SLOWQUERY_DB_HOST'), env('SLOWQUERY_DB_USER'), env('SLOWQUERY_DB_PASSWORD'), env('SLOWQUERY_DB_DATABASE'), env('SLOWQUERY_DB_PORT')) or die("数据库链接错误" . mysqli_connect_error());
            mysqli_query($connection, "set names utf8");
        }
        return $connection;
    }
}

if (!function_exists('page')) {
    function page($totalCount, $pageSize, $params = [], $pageName='page')
    {
        $totalPage   = ceil($totalCount / $pageSize); //计算出总页数
        $maxPageCount = 10;
        $buffCount    = 2;
        $startPage    = 1;

        if ($totalPage < $maxPageCount) {
            $maxPageCount = $totalPage;
        }

        $currentPage = isset($_GET[$pageName]) ? $_GET[$pageName] : (isset($_POST[$pageName]) ? $_POST[$pageName] : 1);
        $params = empty($params) ? (!empty($_POST) ? $_POST : $_GET) : $params;
        if ($currentPage <= $buffCount) {
            $startPage = 1;
        } else if ($currentPage > $buffCount && $currentPage < $totalPage - $maxPageCount + $buffCount) {
            $startPage = $currentPage - $buffCount + 1;
        } else {
            $startPage = $totalPage - $maxPageCount + 1;
        }

        $endPage = $startPage + $maxPageCount - 1;

        $pageStr = "";

        $pageLink = $_SERVER['PHP_SELF'];
        $pageLink .= empty($params) ? "?${pageName}" : ('?' . http_build_query($params) . "&${pageName}");

        $pageStr .= "<ul class='pagination'>";
        if ($currentPage > 1) {
            $pageStr .= "<li class='page-item'> <a class='page-link' href='${pageLink}=1" . "'>第一页</a></li>";
            $pageStr .= "<li class='page-item'> <a class='page-link' href='${pageLink}=" . ($currentPage - 1) . "'>上一页</a></li>";
        }

        $pageStr .= "<li class='page-item'><span class='page-link disabled'>总共${totalPage}页</span></li>";

        for ($i = $startPage; $i <= $endPage; $i++) {
            if ($i == $currentPage) {
                $pageStr .= "<li class='page-item active'><a class='page-link' href='javascript:;'>" . $i . "</a></li>";
            } else {
                $pageStr .= "<li class='page-item'><a class='page-link' href='${pageLink}=" . $i . "'>" . $i . "</a></li>";
            }
        }

        if ($currentPage < $totalPage) {
            $pageStr .= "<li class='page-item'><a class='page-link' href='${pageLink}=" . ($currentPage + 1) . "'>下一页</a></li>";
            $pageStr .= "<li class='page-item'><a class='page-link' href='${pageLink}=" . $totalPage . "'>最后页</a></li>";
        }

        $pageStr .= "</ul>";
        return [$pageStr, ($currentPage - 1) * $pageSize . "," . $pageSize];
    }
}

if (!function_exists('fixTimeZone')) {
    function fixTimeZone($date, $format="Y-m-d H:i:s")
    {
        static $timeZoneFix = null;
        if (is_null($timeZoneFix)) {
            $timeZoneFix = env('TIME_ZONE_FIX');
        }
        return date($format, strtotime($date) + $timeZoneFix * 3600);
    }
}