| 12345678910111213141516171819202122232425262728 |
- # 时间:20211109 是否已发版: 测试- 是 生产-已发版 并以上日期执行完毕 11/19
- #视图
- CREATE OR REPLACE VIEW financeInf AS
- SELECT
- zfi_id,
- zfi_number,
- zfi_supplier_id,
- zfi_core_id,
- zfi_amount,
- zfi_status,
- zfbr_bill_id
- FROM
- zc_finance_bill_rel
- LEFT JOIN zc_finance_inf
- ON zfbr_finance_id = zfi_id
- WHERE (
- zfi_status != '03'
- AND zfi_status != '99'
- )
- OR ISNULL(zfi_status) ;
-
- # 时间:20211109 是否已发版: 测试- 是 生产-否
- insert into `sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`, `approval`, `approval_table`, `icon_url`) values('2667','任务管理','2594','3','myCompanyTask','approval/approval/myCompanyTask','1','0','C','0','0',NULL,'#','admin','2021-11-09 20:28:46','',NULL,'','0','','');
-
-
-
|
