【问】实现查看指定截止时间的库存,如何实现? | ||
【适用版本】便利店8 | 【模块】基础业务 | 【点击数】19 |
【知识编号】P2017121300010 | ||
【问题描述】您好,怎么实现查看指定日期的库存。或者提供下隐藏功能。比如【进销存日报表】就有一个结存库存,这样可以查看记录。 |
–隐藏功能:在“零售”模块的“销售报表”下增加“日进销存报表”
use storev8
go
insert into t_sys_menu(menu_id,menu_name,menu_code,menu_type,open_type,branch_flag,normal_flag,flag1,flag2,flag3,sort_no)
values(‘3477′,’日进销存报表’,’w_rm_jxc_day’,’BROW’,’S’,’110000′,’1′,’0′,’0′,’0′,0)
insert t_sys_oper_grant(oper_id, func_id, grant0, other)
select a.oper_id,a.menu_id, ‘1’, ”
from (select oper_id, menu_id from t_sys_operator,t_sys_menu
where (menu_id NOT LIKE ‘_000’) AND (menu_name <> ‘-‘)
) as a
where not exists (select * from t_sys_oper_grant b where a.oper_id = b.oper_id and a.menu_id = b.func_id)
update t_sys_oper_grant set grant0=’1′, grant1=’1′, grant2=’1′, grant3=’1′, grant4=’1′,grant5=’1′,grant6=’1′,grant7=’1′
where oper_id=’1001′
go