Blame view

application/api/model/kuerp/Systems.php 3.63 KB
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'=>'更新失败'];

                  }

              }

          }

      }

  

  }