LogOperationModel.php
3.05 KB
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
<?php
namespace App\Model;
use App\map\OperationLogMap;
use Illuminate\Database\Eloquent\Model;
use Request;
use DB;
class LogOperationModel extends Model
{
protected $connection='yunxin';
protected $table='log_operation';
protected $primaryKey='id';
public $timestamps = false;
//列表
public function getList($export=array())
{
$input = Request::all();
$list = $this->where(function ($query) use ($input) {
foreach ($input as $k => $v){
$v = trim($v);
if (empty($v)){
continue;
}
switch ($k){
case "p":
case "limit":
case "_url":
case "s":
continue;
break;
default:
$query->whereRaw("FIND_IN_SET($k,'".trim($v,',')."') > 0");
break;
}
}
})->orderBy('id','desc')->paginate($input['limit'], ['*'], 'p', $input['p'])->toArray();
if (!$list) return [20001, '没有数据'];
$UserModel = new UserModel();
foreach ($list['data'] as $k=>&$v){
$userName = $UserModel->FinduserInfoName($v['create_uid']);
$v['user_id_name'] = $userName ? $userName : "";
$v['relevance_type_name'] = OperationLogMap::$relevance_type[$v['relevance_type']];
$v['operation_type_name'] = OperationLogMap::$operation_type[$v['operation_type']];
$v['create_time'] = date("Y-m-d H:i:s",$v['create_time']);
}
return [0, '成功', $list['data'], $list['total']];
}
/*
* 插入操作日志
*@param `operation_type` '操作类型：1添加,2删除,3修改,4审核通过,5审核驳回,6导出',
*@param `relevance_type` '关联单据的类型或者模块: 参考 OperationLogMap
*@param `relevance_id` '关联ID',
*@param `relevance_sn` '关联单号',
*@param `content` '内容',
*@param `create_uid` '操作人id',
*@param `create_name` '操作人名称',
* @param `extend1` '扩展字段1',
*/
static function log($data){
$data['operation_type'] = @$data['operation_type'] == "" ? 1: @$data['operation_type'];
$data['relevance_type'] = @$data['relevance_type'];
$data['relevance_id'] =@$data['relevance_id'] == "" ? 0: @$data['relevance_id'];
$data['relevance_sn'] = @$data['relevance_sn'] == "" ? "": @$data['relevance_sn'];
$data['content'] =empty(@$data['content']) ? "" : (is_array(@$data['content']) ? json_encode(@$data['content'],JSON_UNESCAPED_UNICODE) : @$data['content']);
$data['create_uid'] = @$data['create_uid'] == "" ? 0: @$data['relevance_id'];
$data['create_name'] = @$data['create_name'] == "" ? "": @$data['create_name'];
$data['extend1'] = is_array(@$data['extend1']) ? json_encode(@$data['extend1'],JSON_UNESCAPED_UNICODE) : @$data['extend1'];
$data['create_time'] = time();
return self::insert($data);
}
}