upgrade.php
6.11 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
<?php
$sql = "
CREATE TABLE IF NOT EXISTS `ims_wwx_fxxt_printer` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`uniacid` int(10) NOT NULL,
`name` varchar(100) NOT NULL,
`printertype` int(11) NOT NULL DEFAULT '0' COMMENT '0常规打印，1快递',
`createtime` int(10) NOT NULL DEFAULT '0',
`isdefault` int(11) NOT NULL DEFAULT '0',
`expressdaxiao` varchar(50) DEFAULT '12' COMMENT '字体大小',
`expressziti` varchar(50) DEFAULT '宋体' COMMENT '字体样式',
`expresspic` varchar(1000) DEFAULT '',
`expresscode` varchar(100) NOT NULL DEFAULT '',
`expressconfig` text,
`printerconfig` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `ims_wwx_fxxt_member_flaggrade` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`uniacid` int(11) NOT NULL,
`displayorder` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '级别',
`flag_name` varchar(50) DEFAULT NULL COMMENT '等级名称',
`flag_commission1` int(3) NOT NULL DEFAULT '0' COMMENT '1级分销比例',
`flag_commission2` int(3) NOT NULL DEFAULT '0' COMMENT '2级分销比例',
`flag_commission3` int(3) NOT NULL DEFAULT '0' COMMENT '3级分销比例',
`flag_money` decimal(10,2) NOT NULL DEFAULT '0' COMMENT '提现金额',
`flag_totalmoney` decimal(10,2) NOT NULL DEFAULT '0' COMMENT '分销总金额',
`flag_count` int(10) NOT NULL DEFAULT '0' COMMENT '所需粉丝数量',
`promoterstate` tinyint(1) DEFAULT '0' COMMENT '加入此代理需要分销订单的状态',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `ims_wwx_fxxt_member_shipgrade` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`uniacid` int(11) NOT NULL,
`displayorder` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '级别',
`member_name` varchar(50) DEFAULT NULL COMMENT '等级名称',
`member_turnover` decimal(10,2) NOT NULL DEFAULT '0' COMMENT '所需交易额',
`member_motercount` int(10) NOT NULL DEFAULT '0' COMMENT '所需成交单数',
`member_commission` int(3) NOT NULL DEFAULT '0' COMMENT '享受折扣率,百分比',
`promoterstate` tinyint(1) DEFAULT '0' COMMENT '加入此会员需要订单的状态',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `ims_wwx_fxxt_phb_medal`;
";
pdo_run($sql);
if(!pdo_fieldexists('wwx_fxxt_order', 'zhifutime')) {
pdo_query("ALTER TABLE ".tablename('wwx_fxxt_order')." ADD COLUMN `zhifutime` int(10) DEFAULT '0' COMMENT '订单付款时间';");
}
if(!pdo_fieldexists('wwx_fxxt_order', 'ordermessage')) {
pdo_query("ALTER TABLE ".tablename('wwx_fxxt_order')." ADD COLUMN `ordermessage` tinyint(1) NOT NULL DEFAULT '0' COMMENT '订单消息状态,0未发送,1已发送';");
}
if(!pdo_fieldexists('users', 'collection')) {
pdo_query("ALTER TABLE ".tablename('users')." ADD COLUMN `collection` int(11) unsigned DEFAULT '5' COMMENT '采集点数';");
}
if(!pdo_fieldexists('wwx_fxxt_rules', 'promoterstate')) {
pdo_query("ALTER TABLE ".tablename('wwx_fxxt_rules')." ADD COLUMN `promoterstate` int(10) NOT NULL DEFAULT '0' COMMENT '成为代理需要订单的状态';");
}
if(!pdo_fieldexists('wwx_fxxt_rules', 'autocanceltime')) {
pdo_query("ALTER TABLE ".tablename('wwx_fxxt_rules')." ADD COLUMN `autocanceltime` int(10) NOT NULL DEFAULT '0' COMMENT '自动取消订单检查';");
}
if(!pdo_fieldexists('wwx_fxxt_printer', 'expressdaxiao')) {
pdo_query("ALTER TABLE ".tablename('wwx_fxxt_printer')." ADD COLUMN `expressdaxiao` varchar(50) DEFAULT '12' COMMENT '字体大小';");
}
if(!pdo_fieldexists('wwx_fxxt_printer', 'expressziti')) {
pdo_query("ALTER TABLE ".tablename('wwx_fxxt_printer')." ADD COLUMN `expressziti` varchar(50) DEFAULT '宋体' COMMENT '字体样式';");
}
if(!pdo_fieldexists('wwx_fxxt_member', 'usergrade')) {
pdo_query("ALTER TABLE ".tablename('wwx_fxxt_member')." ADD COLUMN `usergrade` tinyint(3) DEFAULT '0' COMMENT '会员等级';");
}
if(!pdo_fieldexists('wwx_fxxt_member', 'usergradeauto')) {
pdo_query("ALTER TABLE ".tablename('wwx_fxxt_member')." ADD COLUMN `usergradeauto` tinyint(1) DEFAULT '0' COMMENT '是否允许会员自动升级，0为自动升级，1为手动调整。';");
}
if(!pdo_fieldexists('wwx_fxxt_member', 'flaggrade')) {
pdo_query("ALTER TABLE ".tablename('wwx_fxxt_member')." ADD COLUMN `flaggrade` tinyint(3) DEFAULT '0' COMMENT '代理等级';");
}
if(!pdo_fieldexists('wwx_fxxt_member', 'flaggradeauto')) {
pdo_query("ALTER TABLE ".tablename('wwx_fxxt_member')." ADD COLUMN `flaggradeauto` tinyint(1) DEFAULT '0' COMMENT '是否允许代理自动升级，0为自动升级，1为手动调整。';");
}
if(!pdo_fieldexists('wwx_fxxt_member', 'flagcount')) {
pdo_query("ALTER TABLE ".tablename('wwx_fxxt_member')." ADD COLUMN `flagcount` int(11) NOT NULL DEFAULT '0' COMMENT '下级代理总人数';");
}
if(!pdo_fieldexists('wwx_fxxt_member', 'nickname')) {
pdo_query("ALTER TABLE ".tablename('wwx_fxxt_member')." ADD COLUMN `nickname` varchar(50) NOT NULL COMMENT '用户昵称';");
$namelist = pdo_fetchall("select * from ".tablename('wwx_fxxt_member')." where realname<>''");
foreach ($namelist as &$names){
$names['realname'] = htmlspecialchars_decode($names['realname']);
pdo_query("update ".tablename('wwx_fxxt_member')." set nickname = '{$names['realname']}' where id='{$names['id']}'");
}
}
$wwx_fxxt = pdo_fetch("select `version` from ".tablename('modules')." where `name`='wwx_fxxt'");
if($wwx_fxxt['version']=='5.5.5')
{
$wechatslist = pdo_fetchall("select * from ".tablename('account_wechats'));
foreach ($wechatslist as $wechats)
{
$total =pdo_fetchcolumn('SELECT count(id) FROM '.tablename('wwx_fxxt_rules')." WHERE uniacid = :uniacid " , array(':uniacid' => $wechats['uniacid']) );
if($total>1)
{
$items =pdo_fetchall('SELECT * FROM '.tablename('wwx_fxxt_rules')." WHERE uniacid = :uniacid order by id" , array(':uniacid' => $wechats['uniacid']) );
$newitem='';
foreach ($items as $item)
{
if(empty($newitem)||empty($newitem['id']))
{
$newitem=$item;
}else {
pdo_query("delete from ".tablename('wwx_fxxt_rules')." WHERE uniacid = :uniacid and id!=:id" , array(':uniacid' => $wechats['uniacid'],':id' => $newitem['id']));
}
}
}
}
}