Blame view

application/admin/model/fastflow/flow/Agency.php 2.19 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
  <?php
  
  namespace app\admin\model\fastflow\flow;
  
  use app\admin\model\Admin;
  use app\admin\model\AuthGroup;
  use think\Config;
  use think\Db;
  use think\Model;
  
  
  class Agency extends Model
  {
      // 表名
      protected $name = 'fastflow_agency';
  
      // 自动写入时间戳字段
      protected $autoWriteTimestamp = 'int';
  
      // 定义时间戳字段名
      protected $createTime = 'createtime';
      protected $updateTime = 'updatetime';
      protected $deleteTime = false;
  
      // 追加属性
      protected $append = [
          'bill_comment',
          'principal',
          'agent',
      ];
  
  
      public function getRangeList()
      {
          return ['1' => __('Range 1'), '2' => __('Range 2'), '3' => __('Range 3')];
      }
  
      public function getScopeList()
      {
          return ['1' => __('Scope 1'), '2' => __('Scope 2')];
      }
  
  
      public function getBillCommentAttr($value, $data)
      {
          $tables = Db::query("select TABLE_NAME as name,TABLE_COMMENT as comment from information_schema.tables where table_schema='" . Config::get('database')['database'] . "'");
          $bill_comment = '';
          for ($i = 0; $i < count($tables); $i++) {
              if ($tables[$i]['name'] == $data['bill']) {
                  $bill_comment = $tables[$i]['comment'];
                  break;
              }
          }
          return $bill_comment;
      }
  
      public function getPrincipalAttr($value, $data)
      {
          if ($data['scope'] == 1) {
              $admin = (new Admin())->find($data['principal_id']);
              if ($admin) {
                  return $admin['nickname'];
              }
          }
          elseif ($data['scope'] == 2) {
              $group = (new AuthGroup())->find($data['principal_id']);
              if ($group) {
                  return $group['name'];
              }
          }
      }
  
      public function getAgentAttr($value, $data)
      {
          if ($data['scope'] == 1) {
              $admin = (new Admin())->find($data['agent_id']);
              if ($admin) {
                  return $admin['nickname'];
              }
          }
          elseif ($data['scope'] == 2) {
              $group = (new AuthGroup())->find($data['agent_id']);
              if ($group) {
                  return $group['name'];
              }
          }
      }
  }