2db47680
hexiaodong
chore: 初始提交 php 遗...
|
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
112
113
114
115
|
<?php
namespace app\api\model\kuerp;
use think\Model;
use think\Db;
use think\Exception;
class Systems extends Model
{
// 表名
protected $name = 'kuerp_user_config';
// 自动写入时间戳字段
protected $autoWriteTimestamp = true;
// 定义时间戳字段名
protected $createTime = 'createtime';
protected $updateTime = 'updatetime';
/**
* 获取详情
* @param int $id
*/
public static function getDetail($name){
$detail = self::where(function ($query) use ($name) {
$query->where('name', 'in', $name);
})->field('id,name,value')->select();
return $detail;
}
/**
* 添加
* @param array $detail
* @return array
*/
public static function addDetail($detail){
if(empty($detail)){
return ['status'=>400,'msg'=>'参数错误'];
}else{
$check = (new \app\api\model\kuerp\UserAddress)->checkParameter($detail,[
'name|设置项'=>'require',
'value|内容'=>'require',
]);
if(isset($check['status'])){
return $check;
}else{
$model = new \app\api\model\kuerp\Systems();
$row = $model->where(['name'=>$detail['name']])->find();
if(!empty($row)){
return ['status'=>500,'msg'=>'设置项已存在'];
}
Db::startTrans();
try {
$res = (new Systems())->allowField(true)->save($detail);
Db::commit();
} catch (Exception $e) {
Db::rollback();
return ['status'=>500,'msg'=>$e->getMessage()];
}
if($res){
return ['status'=>200,'msg'=>$res];
}else{
return ['status'=>500,'msg'=>'添加失败'];
}
}
}
}
/**
* 更新
* @param array $detail
* @return array
*/
public static function editDetail($detail){
if(empty($detail)){
return ['status'=>400,'msg'=>'参数错误'];
}else{
$check = (new \app\api\model\kuerp\UserAddress)->checkParameter($detail,[
'id|ID'=>'require|number',
'name|设置项'=>'require',
'value|内容'=>'require',
]);
if(isset($check['status'])){
return $check;
}else{
$model = new \app\api\model\kuerp\Systems();
$row = $model->where(['name'=>$detail['name'],'id'=>['<>',$detail['id']]])->find();
if(!empty($row)){
return ['status'=>500,'msg'=>'设置项已存在'];
}
$row = $model->where(['id'=>$detail['id']])->find();
if(empty($row)){
return ['status'=>500,'msg'=>'数据不存在'];
}
$detail['updatetime'] = time();
Db::startTrans();
try {
$res = $row->allowField(true)->save($detail);
Db::commit();
} catch (Exception $e) {
Db::rollback();
return ['status'=>500,'msg'=>$e->getMessage()];
}
if($res){
return ['status'=>200,'msg'=>'更新成功'];
}else{
return ['status'=>500,'msg'=>'更新失败'];
}
}
}
}
}
|