# 时间: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','','');
  
  
  