-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathdata_init.php
133 lines (123 loc) · 6.53 KB
/
data_init.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
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
<?php
/**
* 初始化数据
*/
include 'library/init.inc.php';
global $db, $loader;
$loader->includeScript('purview');
header('Content-Type: text/html;charset=utf-8');
$table = array();
$data = array();
//站点参数
/*
$table[] = 'sysconf';
$data[] = array(
//================================= 业务参数 =====================================================
array('key'=>'recommend_integral', 'name'=>'推广赠送积分', 'value'=>10, 'type'=>'text', 'group'=>'config', 'remark'=>''),
array('key'=>'level_1', 'name'=>'一级分销比例', 'value'=>0, 'type'=>'text', 'group'=>'config', 'remark'=>''),
array('key'=>'level_2', 'name'=>'二级分销比例', 'value'=>0, 'type'=>'text', 'group'=>'config', 'remark'=>''),
array('key'=>'level_3', 'name'=>'三级分销比例', 'value'=>0, 'type'=>'text', 'group'=>'config', 'remark'=>''),
array('key'=>'fee_rate', 'name'=>'提现手续费比例', 'value'=>0, 'type'=>'text', 'group'=>'config', 'remark'=>''),
array('key'=>'integral_rate', 'name'=>'积分比值', 'value'=>1, 'type'=>'text', 'group'=>'config', 'remark'=>''),
array('key'=>'reward_rate', 'name'=>'佣金比例', 'value'=>1, 'type'=>'text', 'group'=>'config', 'remark'=>''),
array('key'=>'withdraw_min', 'name'=>'最小提现金额', 'value'=>0, 'type'=>'text', 'group'=>'config', 'remark'=>''),
//================================= 微信参数 =====================================================
array('key'=>'public_account', 'name'=>'公众号原始ID', 'value'=>'', 'type'=>'text', 'group'=>'wechat', 'remark'=>''),
array('key'=>'appid', 'name'=>'微信AppID', 'value'=>'', 'type'=>'text', 'group'=>'wechat', 'remark'=>''),
array('key'=>'mini_appid', 'name'=>'微信小程序AppID', 'value'=>'', 'type'=>'text', 'group'=>'wechat', 'remark'=>''),
array('key'=>'appsecret', 'name'=>'微信AppSecret', 'value'=>'', 'type'=>'text', 'group'=>'wechat', 'remark'=>''),
array('key'=>'mini_appsecret', 'name'=>'微信小程序AppSecret', 'value'=>'', 'type'=>'text', 'group'=>'wechat', 'remark'=>''),
array('key'=>'token', 'name'=>'微信接入口令', 'value'=>'', 'type'=>'text', 'group'=>'wechat', 'remark'=>''),
array('key'=>'access_token', 'name'=>'接口凭证', 'value'=>'', 'type'=>'text', 'group'=>'wechat', 'remark'=>''),
array('key'=>'jsapi_ticket', 'name'=>'微信JSSDK口令', 'value'=>'', 'type'=>'text', 'group'=>'wechat', 'remark'=>''),
array('key'=>'jsapi_ticket_expire', 'name'=>'微信JSSDK口令超时时间', 'value'=>'', 'type'=>'text', 'group'=>'wechat', 'remark'=>''),
array('key'=>'expired', 'name'=>'接口凭证超时时间', 'value'=>0, 'type'=>'text', 'group'=>'wechat', 'remark'=>''),
array('key'=>'mch_id', 'name'=>'微信支付商户号', 'value'=>'', 'type'=>'text', 'group'=>'wechat', 'remark'=>''),
array('key'=>'mch_key', 'name'=>'微信支付商户号', 'value'=>'', 'type'=>'text', 'group'=>'wechat', 'remark'=>''),
array('key'=>'wx_ssl_key', 'name'=>'微信支付证书密钥', 'value'=>'', 'type'=>'text', 'group'=>'wechat', 'remark'=>''),
array('key'=>'wx_ssl_cert', 'name'=>'微信支付证书', 'value'=>'', 'type'=>'text', 'group'=>'wechat', 'remark'=>''),
//================================= 系统设置 =====================================================
array('key'=>'category_depth', 'name'=>'产品分类深度', 'value'=>4, 'type'=>'text', 'group'=>'config', 'remark'=>''),
array('key'=>'domain', 'name'=>'域名', 'value'=>'http://local.wine.winsen.com', 'type'=>'text', 'group'=>'config', 'remark'=>''),
array('key'=>'site_name', 'name'=>'站点名称', 'value'=>'', 'type'=>'text', 'group'=>'config', 'remark'=>''),
array('key'=>'themes', 'name'=>'模板文件', 'value'=>'wine', 'type'=>'text', 'group'=>'themes', 'remark'=>''),
array('key'=>'statistics ', 'name'=>'开启统计', 'value'=>'0', 'type'=>'text', 'group'=>'themes', 'remark'=>''),
);
//初始化商家
$table[] = 'business';
$data[] = array(
array(
'id' => 1,
'business_account' => 'Wine2018',
'password' => md5('Wine2018@'.PASSWORD_END),
'company' => '知性小厨',
'license' => '',
'identity' => '',
'industry_id' => 0,
'category_id' => 0,
'province' => 5,
'city' => 5,
'district' => 103,
'group' => 0,
'address' => '',
'status' => 2,
'contact' => '彭',
'mobile' => '13929564894',
'email' => '[email protected]',
'shop_name' => '知性小厨',
'shop_logo' => '',
'comment' => 0,
'account' => ''
)
);
*/
/*
//产品分类
$table[] = 'category';
$data[] = array(
);
$table[] = 'product';
$data[] = array(
);
*/
/*
$table[] = 'card_pool';
$data[] = array(
array('account'=>'SJ000000', 'status'=>1)
);
$table[] = 'payment';
$data[] = array(
array('name'=>'微信支付', 'plugins'=>'wechat', 'desc'=>'微信支付', 'status'=>1)
);
*/
/*
$table[] = '初始化广告位数据';
$sql[] = 'insert into '.$db->table('ad_position').' (`id`, `pos_name`, `width`, `height`, `number`, `code`) values
(\'1\', \'首页轮播广告\', \'320\', \'140\', \'5\', \'\'),
(\'2\', \'首页展示广告\', \'320\', \'128\', \'3\', \'\'),
(\'3\', \'商家轮播\', \'320\', \'140\', \'3\', \'\'),
(\'4\', \'PC端网站首页大广告\', \'788\', \'328\', \'5\', \'\');';
*/
$table[] = 'level';
$data[] = [
['id' => 1, 'name' => '普卡', 'experience' => 0, 'experience_type' => 2, 'recommend_count' => 0, 'is_special' => 0, 'discount' => 95, 'remark' => '', 'expired' => -1, 'birthday_integral_rate' => 5, 'recharge_discount' => 100, 'birthday_given_integral' => 50],
['id' => 2, 'name' => '金卡', 'experience' => 30000, 'experience_type' => 2, 'recommend_count' => 0, 'is_special' => 0, 'discount' => 90, 'remark' => '', 'expired' => 86400*365, 'birthday_integral_rate' => 8, 'recharge_discount' => 98, 'birthday_given_integral' => 100],
['id' => 3, 'name' => '钻卡', 'experience' => 50000, 'experience_type' => 2, 'recommend_count' => 0, 'is_special' => 0, 'discount' => 80, 'remark' => '', 'expired' => 86400*365, 'birthday_integral_rate' => 10, 'recharge_discount' => 95, 'birthday_given_integral' => 200],
];
echo '初始化数据:<br/>';
foreach($table as $key=>$name)
{
$db->query('truncate table '.$db->table($name).';');
echo $name;
$dot_count = 30 - strlen($name);
while($dot_count--)
{
echo '-';
}
if($db->autoInsert($name, $data[$key]))
{
echo ' <font color="green">success</font><br/>';
} else {
echo ' <font color="red">fail</font><br/>'.$db->errmsg();
}
}