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
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
<?php
/**
* Created by PhpStorm.
* User: chouchou
* Date: 2019-6-10
* Time: 19:33
*/
namespace app\admin\controller;
use think\Controller;
use think\Request;
use think\db;
class Log extends Base
{
public function loginlog_list(Request $request){
$map=[];
$search_text = $request->get('search_text');
$search_type = $request->get('search_type');
if($search_text){
switch ($search_type) {
case '1':
$map[]=['name','like',"%$search_text%"];;
$this->assign('search_text',$search_text);
$this->assign('search_type',$search_type);
break;
case '2':
$map[]=['ip','like',"%$search_text%"];;
$this->assign('search_text',$search_text);
$this->assign('search_type',$search_type);
break;
}
}else{
$this->assign('search_type','');
$this->assign('search_text','');
}
$page = $request->get('page')?$request->get('page'):1;
$limit = $request->get('limit')?$request->get('limit'):10;
if(empty($request->get('page'))){
$page_s=0;
}else{
$page_s=(($page-1)*$limit);
}
$loginlog=db::name('loginlog')->field('*,FROM_UNIXTIME(create_time, "%Y-%m-%d %H:%i:%s") as create_time')->where($map)->limit($page_s,$limit)->select();
$loginlogcnt=db::name('loginlog')->where($map)->count();
if($request->get('page')){
return ['code'=>0,'msg'=>'','count'=>$loginlogcnt,'data'=>$loginlog];
}
return $this->fetch('loginlog_list');
}
public function clouldlog_list(Request $request){
$page = $request->get('page')?$request->get('page'):1;
$limit = $request->get('limit')?$request->get('limit'):10;
if(empty($request->get('page'))){
$page_s=0;
}else{
$page_s=(($page-1)*$limit);
}
$cloudlog=db::name('cloudlog')->field('*,FROM_UNIXTIME(create_time, "%Y-%m-%d %H:%i:%s") as create_time')->limit($page_s,$limit)->select();
foreach ($cloudlog as $key => $value) {
$cloudlog[$key]['content']=json_decode($value['content'],true);
$cloudlog[$key]['content']=$cloudlog[$key]['content']['info'];
}
$cloudlogcnt=db::name('cloudlog')->count();
if($request->get('page')){
return ['code'=>0,'msg'=>'','count'=>$cloudlogcnt,'data'=>$cloudlog];
}
return $this->fetch('clouldlog_list');
}
public function activity_log(Request $request){
$map=[];
$search_text = $request->get('search_text');
$search_type = $request->get('search_type');
if($search_text){
switch ($search_type) {
case '1':
$map[]=['name','like',"%$search_text%"];;
$this->assign('search_text',$search_text);
$this->assign('search_type',$search_type);
break;
}
}else{
$this->assign('search_type','');
$this->assign('search_text','');
}
$page = $request->get('page')?$request->get('page'):1;
$limit = $request->get('limit')?$request->get('limit'):10;
if(empty($request->get('page'))){
$page_s=0;
}else{
$page_s=(($page-1)*$limit);
}
$activity_log=db::name('activity_log')->field('*,FROM_UNIXTIME(create_time, "%Y-%m-%d %H:%i:%s") as create_time')->where($map)->limit($page_s,$limit)->select();
foreach ($activity_log as $key => $value) {
$activity_log[$key]['description']=json_decode($value['description'],true);
}
$activity_logcnt=db::name('activity_log')->where($map)->count();
if($request->get('page')){
return ['code'=>0,'msg'=>'','count'=>$activity_logcnt,'data'=>$activity_log];
}
return $this->fetch('activitylog_list');
}
}