开通专卖9零钱包功能

请将软件升级至最新版本

1、零钱包开通方法如下：报表在总部零售管理-更多功能中查询
/*—————————————————————————————–
1.使用说明
  开启后：
 门店系统：前台启用零钱包功能
        从20160503版本开始，可支持带储值功能的会员卡存零钱功能
2.风险
  无 
——————————————————————————————*/
–前台启用零钱包功能(非储值的会员卡有效)
use isszmv9
go

delete from t_sys_system where sys_var_id=’isvipsmallpay’
—-开启参数。
if not exists(select 1 from t_sys_system where sys_var_id=’isvipsmallpay’ and branch_no=’000′)
begin
   insert into t_sys_system(sys_var_id,sys_var_name,sys_var_value,is_changed,sys_ver_flag,branch_no,oper_id)
   values(‘isvipsmallpay’,’启用零钱包’,’1′,’否’,’1′,’000′,’1001′)
end

–收银对账用。零钱包支付以及存款付款方式。
if not exists(SELECT * FROM t_bd_payment_info WHERE pay_way=’LEP’)
 INSERT INTO t_bd_payment_info(pay_way,pay_flag,pay_name,rate,default_amt,pay_memo) VALUES (‘LEP’,0,’零钱包支付’,1,0,’系统默认’)
go
if not exists(SELECT * FROM t_bd_payment_info WHERE pay_way=’LEV’)
 INSERT INTO t_bd_payment_info(pay_way,pay_flag,pay_name,rate,default_amt,pay_memo) VALUES (‘LEV’,0,’零钱包存款’,1,0,’系统默认’)
go

–零钱包报表

insert into t_sys_menu (menu_id,menu_name,menu_code,menu_type,open_type,open_parameter,branch_flag,normal_flag,flag1,flag2,flag3,memo,net_flag,net_menu_code,
     net_open_parameter)
 values (‘4290′,’零钱包报表’,’w_rm_saleflow_change_query’,’BROW’,’S’,”,’110001′,’0′,’0′,’0′,’0′,”,’0′,”,”)
go

–菜单权限
insert into t_sys_oper_grant (oper_id,func_id,grant0,grant1,grant2,grant3,grant4,grant5,grant6,grant7,grant8,grant9)
select a.oper_id, b.menu_id, ‘0’, ‘0’, ‘0’, ‘0’, ‘0’, ‘0’, ‘0’, ‘0’, ‘0’, ‘0’
from t_sys_operator a, t_sys_menu b
where b.menu_name <> ” and not exists (select 1 from t_sys_oper_grant where oper_id = a.oper_id and func_id = b.menu_id)
GO