如何打开专卖店中的“连锁版加密码”输入界面?
此功能需要语句开通,然后在“系统管理”—“更多功能”—“验证码设置”中进行设置即可。
use isszmv8 –请先备份数据再开通
go
insert into t_sys_menu(menu_id,branch_flag,menu_name,menu_code,menu_type, open_type,normal_flag)
values (‘B116′,’111111’, ‘验证码设置’,’w_sys_code_input’, ‘OTHR’, ‘R’,’0′);
INSERT INTO t_sys_oper_grant(oper_id, func_id, other)
select a.oper_id, b.menu_id, ”
from t_sys_operator a, t_sys_menu b
where (b.menu_name <> ‘-‘)
and not exists ( select 1 from t_sys_oper_grant c where c.oper_id = a.oper_id and c.func_id = b.menu_id )
order by a.oper_id
update t_sys_oper_grant set grant0=’1′, grant1=’1′, grant2=’1′, grant3=’1′, grant4=’1′,grant5=’1′,grant6=’1′
where oper_id=’1001′
go
INSERT INTO t_sys_menu_grant
SELECT menu_id,
substring(branch_flag,1,1),
substring(branch_flag,2,1),
substring(branch_flag,3,1),
substring(branch_flag,4,1),
substring(branch_flag,5,1),
substring(branch_flag,6,1),
null
FROM t_sys_menu
Where menu_id not in (select func_id from t_sys_menu_grant) ;
go
select ‘ok! menu.sql’