修改日期 | 修改人 | 备注 |
2024-08-02 17:49:13[当前版本] | 梁建宁 | 更新内容 |
2024-06-15 11:32:12 | 梁建宁 | 更新内容 |
2024-04-12 18:02:29 | 梁建宁 | 更新内容 |
2024-04-09 18:12:04 | 梁建宁 | 更新内容 |
本脚本用于从娱乐管家中直接导出会员资料、会员储值数据出来,且包含会员卡卡ID(导入此ID则不需要换卡依然能直接读卡)。注意!脚本仅供内部测试使用,未经过官方检测,在导入前必须仔细检查无误后再导入新系统。
1.1 安装服务器系统,安装流程如下:
注意:无论是连锁商城或者是多商户,可只安装总部服务器系统,等待数据导入完毕后再安装门店系统。如总部为租用云服务器,请提前联系助理获取云服务器的登录地址。
1.2 提前录入原来系统数据,包含以下数据:
a.机台数据,包括项目分类、游乐项目、机台物理参数;
b.零售商品,包括零售商品名称、价格、兑换值(不包含库存);
c.游戏币套餐、预存款套餐、入会套餐、组合商品、游乐套票套餐等;
d.员工信息,包括角色设置以及用户设置两个部分;
e.权益优惠,包含商品促销、兑换折扣、活动赠送等;
f.线上商城搭建,包括线上套餐、线上兑换、注册会员权益等
1.3 将游乐宝系统升级到8.1.6898版本以上(旧版本不支持导出卡ID和导出0储值会员)
2.1 备份新安装的娱乐管家数据库
备份数据库操作流程请参考:【数据库备份】
3.1 登录数据库,目标数据库选择原的数据库YCHMALL库
3.2 选择【新建查询】,复制以下语句到查询页,并执行(过程大概需要几分钟时间,需要耐心等待,需要等待到底部显示“查询完毕”后才可以执行下一步)
1、游乐宝导出会员资料,包括储值和芯片号,升级娱乐管家后不需要换卡
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
|
select LeaguerCode,LevelName,ISNULL(RealName,'') AS RealName,PASSWORD,ISNULL(Birthday,'') AS Birthday,ISNULL(Address,'') AS Address,case Sex when 1 then '男' else '女' end as Sex,ISNULL(IDCard,'') AS IDCard,ISNULL(Phone,'') AS Phone,VerifyTime,ISNULL([预存款],0) AS [预存款],ISNULL([代币],0)
as [代币], ISNULL([金币],0)as [金币] ,ISNULL([彩票],0) as [彩票],ISNULL([娃娃],0) as [娃娃],ISNULL([积分],0) as [积分] ,ISNULL(ICNumber,'') as ICNumber from (select A.ID,LeaguerCode,B.LevelName,A.RealName,123456 AS PASSWORD,A.Birthday,C.Address,A.Sex,A.IDCard,ISNULL(A.Phone,C.Phone) AS Phone, A.VerifyTime ,D.ICNumber from Mall_LeaguerBase A JOIN Mall_LeaguerLevel b ON A.LeaguerLevel=B.ID JOIN Mall_Leaguer C ON A.ID=C.BaseInfo LEFT JOIN (SELECT OwnedLeaguerBase,MAX(ICNumber) AS ICNumber FROM Mall_ICCard WHERE ISDELETE =0 AND ISMASTER =1 GROUP BY OwnedLeaguerBase)D ON D.OwnedLeaguerBase=A.ID where A.IsDelete=0 )AS x left join (SELECT LeaguerBase,ISNULL(T.[401],0) AS 金币,ISNULL(T.[402],0) AS 代币,ISNULL(T.[403],0) AS 彩票,ISNULL(T.[404],0) AS 娃娃,ISNULL(T.[3],0) AS 积分 FROM ( SELECT TypeCode,LeaguerBase , RemainAmount FROM Mall_LeaguerValues) P PIVOT (SUM(RemainAmount) FOR TypeCode IN ([401],[402],[403],[404],[3])) AS T ) y on x.ID=Y.LeaguerBase left join( SELECT LeaguerBase , ISNULL(RemainAmount,0) AS 预存款 FROM Mall_LeaguerPrepaid) z on x.ID=z.LeaguerBase |
2、对上述语句导出数据求和,以便验证是否和会员储值余额数据一致
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
|
select SUM([代币]) as [代币],SUM([金币]) as [金币],SUM([彩票]) as [彩票],SUM([娃娃]) as [娃娃],SUM([积分]) as [积分] FROM (
select LeaguerCode,LevelName,ISNULL(RealName,'') AS RealName,PASSWORD,ISNULL(Birthday,'') AS Birthday,ISNULL(Address,'') AS Address,case Sex when 1 then '男' else '女' end as Sex,ISNULL(IDCard,'') AS IDCard,ISNULL(Phone,'') AS Phone,VerifyTime,ISNULL([预存款],0) AS [预存款],ISNULL([代币],0)
as [代币], ISNULL([金币],0)as [金币] ,ISNULL([彩票],0) as [彩票],ISNULL([娃娃],0) as [娃娃],ISNULL([积分],0) as [积分]
,ICNumber
from
(select A.ID,LeaguerCode,B.LevelName,A.RealName,123456 AS PASSWORD,A.Birthday,C.Address,A.Sex,A.IDCard,C.Phone,
A.VerifyTime
,D.ICNumber
from Mall_LeaguerBase A JOIN Mall_LeaguerLevel b ON A.LeaguerLevel=B.ID
JOIN Mall_Leaguer C ON A.ID=C.BaseInfo
LEFT JOIN (SELECT OwnedLeaguerBase,MAX(ICNumber) AS ICNumber FROM Mall_ICCard WHERE ISDELETE =0 AND ISMASTER =1 GROUP BY OwnedLeaguerBase)D ON D.OwnedLeaguerBase=A.ID
where A.IsDelete=0 )AS x left join
(SELECT LeaguerBase,ISNULL(T.[401],0) AS 金币,ISNULL(T.[402],0) AS 代币,ISNULL(T.[403],0) AS 彩票,ISNULL(T.[404],0) AS 娃娃,ISNULL(T.[3],0) AS 积分
FROM ( SELECT TypeCode,LeaguerBase , RemainAmount FROM Mall_LeaguerValues) P PIVOT (SUM(RemainAmount)
FOR TypeCode IN ([401],[402],[403],[404],[3])) AS T ) y
on x.ID=Y.LeaguerBase left join( SELECT LeaguerBase , ISNULL(RemainAmount,0) AS 预存款 FROM Mall_LeaguerPrepaid) z
on x.ID=z.LeaguerBase) AS XXX
|
3.3. 等待输出结果(注意执行需要时间,一定要等待结束)
3.4. 登录门店,选择【会员】-【会员资料导入】-【下载模板】
3.4 打开模板,先将对应的格式设置好,设置内容如下:
【会员号】、【芯片号】设置为文本格式;
【生日】、【有效期】设置为日期格式。
操作如下图所示:
3.5在数据库查询结果上中右键,选择【全选】,然后再右键选择【复制】,然后在上一步表格中选择粘贴;
3.6.检查上一步导出数据是否与原系统数据匹配,包括储值数量和对应储值是否匹配;
3.7.查询游乐宝中的储值平衡表,查看一下币单价,并将币单价填写到娱乐管家导入界面中,并选择已编辑好的会员资料导入模板,然后选择导入,等待导入结束。
3.8.完成数据导入。
1.数据检查标准:
从原系统中分别找出各个储值最大的10个会员,通过会员号在新系统中找出来,并核对对应的所有储值是否一致;
从原系统中分别找出套票剩余次数最多的10个会员,通过会员号在新系统中找出来,并核对对应的所有剩余次数以及可游玩的项目是否一致;