Tablemake.php
6.0 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
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
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
<?php
namespace addons\tablemake;
use app\common\library\Menu;
use think\Addons;
use think\Config;
use think\Db;
use think\Exception;
/**
* 自建表管理插件
*/
class Tablemake extends Addons {
/**
* 插件安装方法
* @return bool
*/
public function install() {
$menu = [
[
'name' => 'tablemake',
'title' => '自建表管理',
'icon' => 'fa fa-cubes',
'sublist' => [
['name' => 'tablemake/index', 'title' => '查看列表'],
['name' => 'tablemake/add', 'title' => '创建新表'],
['name' => 'tablemake/edit', 'title' => '编辑表'],
['name' => 'tablemake/del', 'title' => '删除模块'],
['name' => 'tablemake/fields', 'title' => '字段管理'],
['name' => 'tablemake/field_add', 'title' => '添加字段'],
['name' => 'tablemake/field_del', 'title' => '删除字段'],
]
]
];
Menu::create($menu);
//$this->doUpgrade();
return true;
}
/**
* 插件卸载方法
* @return bool
*/
public function uninstall() {
Menu::delete('tablemake');
return true;
}
/**
* 插件启用方法
* @return bool
*/
public function enable() {
Menu::enable('tablemake');
//$this->doUpgrade();
return true;
}
/**
* 插件禁用方法
* @return bool
*/
public function disable() {
Menu::disable('tablemake');
return true;
}
public function doUpgrade() {
$prefix = Config::get('database.prefix');
$haTable = Db::query('SHOW TABLES LIKE '."'{$prefix}tablemake_tables'");
if(!$haTable){
//数据表不存在，表示是安装动作，非升级动作
return;
}
//<editor-fold desc="1.0.7版本更新数据表字段" defaultstate="collapsed">
/**
* 1.检测tablemake_tables表是否需要更新，如果需要则更新tablemake_tables表
*/
$sql = "describe `{$prefix}tablemake_tables` `weigh`;";
$has_weigh = Db::query($sql);
if (!$has_weigh) {//tablemake_tables
Db::startTrans();
try {
//1.新增weigh字段
$sql = "ALTER TABLE `{$prefix}tablemake_tables`
ADD COLUMN `weigh` bigint(11) NOT NULL DEFAULT 0 COMMENT '排序权重' AFTER `desc`;";
Db::execute($sql);
//2.更新weigh字段的值为对应记录的ID值
$sql = "UPDATE `{$prefix}tablemake_tables` SET `weigh`=`id`;";
Db::execute($sql);
//3.原有字段更新
$sql = "ALTER TABLE `{$prefix}tablemake_tables`
MODIFY COLUMN `id` bigint(11) NOT NULL AUTO_INCREMENT COMMENT 'ID' FIRST ,
MODIFY COLUMN `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '自建表名称' AFTER `id`,
MODIFY COLUMN `table` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '自建表表名' AFTER `name`,
MODIFY COLUMN `desc` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '自建表简介' AFTER `table`,
MODIFY COLUMN `createtime` bigint(11) NOT NULL DEFAULT 0 COMMENT '创建时间' AFTER `weigh`,
MODIFY COLUMN `updatetime` bigint(11) NOT NULL DEFAULT 0 COMMENT '更新时间' AFTER `createtime`;";
Db::execute($sql);
Db::commit();
} catch (Exception $e) {
\think\Log::write("更新{$prefix}tablemake_tables表字段失败，异常：" . $e->getTraceAsString());
Db::rollback();
}
}
/**
* 2.检测tablemake_fields表是否需要更新，如果需要则更新tablemake_fields表
*/
$sql = "describe `{$prefix}tablemake_fields` `weigh`;";
$has_weigh = Db::query($sql);
if (!$has_weigh) {//tablemake_fields
Db::startTrans();
try {
//1.新增weigh字段
$sql = "ALTER TABLE `{$prefix}tablemake_fields`
ADD COLUMN `desc` varchar(255) NOT NULL DEFAULT '' COMMENT '字段备注' AFTER `comment`,
ADD COLUMN `weigh` bigint(11) NOT NULL DEFAULT 0 COMMENT '排序权重' AFTER `desc`;";
Db::execute($sql);
//2.更新weigh字段的值为对应记录的ID值
$sql = "UPDATE `{$prefix}tablemake_fields` SET `weigh`=`id`;";
Db::execute($sql);
//3.原有字段更新
$sql = "ALTER TABLE `{$prefix}tablemake_fields`
MODIFY COLUMN `id` bigint(11) NOT NULL AUTO_INCREMENT COMMENT 'ID' FIRST ,
MODIFY COLUMN `mid` bigint(11) NOT NULL DEFAULT 0 COMMENT '所属自建表ID' AFTER `id`,
MODIFY COLUMN `length` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 0 COMMENT '字段长度' AFTER `type`,
MODIFY COLUMN `default` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '默认值' AFTER `length`,
MODIFY COLUMN `comment` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '字段备注' AFTER `default`,
MODIFY COLUMN `createtime` bigint(11) NOT NULL DEFAULT 0 COMMENT '创建时间' AFTER `weigh`,
MODIFY COLUMN `updatetime` bigint(11) NOT NULL DEFAULT 0 COMMENT '更新时间' AFTER `createtime`;";
Db::execute($sql);
Db::commit();
} catch (Exception $e) {
\think\Log::write("更新{$prefix}tablemake_fields表字段失败，异常：" . $e->getTraceAsString());
Db::rollback();
}
}
//</editor-fold>
}
}