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

codeigniter Login_log_model update+


<?php
defined('BASEPATH') OR exit('No direct script access allowed');

class Login_log_model extends BaseModel
{
    protected $table = "login_log";
    protected $hidden = ['createby', 'lastupdate', 'lastupby', 'deletedate', 'deleteby', 'deleted'];

    public static function check_if_lock()
    {
        $date = new DateTime();
        $date->modify('-10 minutes');
        $last_ten_minutes = $date->format('Y-m-d H:i:s');

        $result = Login_log_model::where('is_block', 1)->
        where('createdate', '>=', $last_ten_minutes)->
        where('createdate', '<=', date('Y-m-d H:i:s'))->
        whereRaw('(ip_address = ? or session_id = ?)', array(get_client_ip(), session_id()))->count();

        return $result >= 5;
    }

    public static function count_retry()
    {
        $date = new DateTime();
        $date->modify('-10 minutes');
        $last_ten_minutes = $date->format('Y-m-d H:i:s');

        $result = Login_log_model::where('is_block', 1)->
        whereRaw('(ip_address = ? or session_id = ?)', array(get_client_ip(), session_id()))->
        where('createdate', '>=', $last_ten_minutes)->
        where('createdate', '<=', date('Y-m-d H:i:s'))->count();

        return 5-$result;
    }

    public static function form_list()
    {

        return array(
            'table_name'   => array(
                'label'                 => __('平台'),
            ),
            'table_id'   => array(
                'label'                 => __('登入名稱'),
            ),
            'createdate'   => array(
                'label'                 => __('登錄日期'),
            ),
            'ip_address'  => array(
                'label'                 => __('IP地址'),
            ),
            'is_success'   => array(
                'label'                 => __('是否成功登錄'),
            ),
            'is_block'   => array(
                'label'                 => __('是否已阻擋登錄'),
            ),
//            'user_agent' => array(
//                'label'                 => __('用戶介面'),
//            ),
        );
    }

}