公司日常加班费用报销系统

雏形如下：

初步脚本：
		-- 做个系统：个人工资条的查询、日常报销费用的记录查询
	   --日常报销记录功能： 管理员进来可以查看所有人的报销情况:查询条件：报销类别(下拉框):吃饭、打车、出差; 报销状态(下拉框):已报销、未报销；
	   -- 个人工资条查询功能

-- 日常加班餐费、打车费报销记录表  
   -- 消费  consumption  kənˈsʌmpʃn    费用报销;报销;偿付;补偿;赛季报销   consumption  美 [ˌriːɪmˈbɜːrsmənt] ；  
  
   select a.*,a.rowid from t_pc_personal_consumption a where  1=1 
   and consumption_Status=0
   --and consumption_type_code=1
  -- and to_char(consumption_Create_Time,'yyyy/MM')='2019/11'
   order by id desc;
   
   -- 总计 sum(a.consumption_momey) as total
   select b.consumption_people, b.consumption_type,to_char(consumption_Create_Time,'yyyy/MM')as time,sum(b.consumption_momey) as total 
   from t_pc_personal_consumption b
   group by  b.consumption_people,b.consumption_type,to_char(consumption_Create_Time,'yyyy/MM')
   
   
   -- 吃饭
   insert into t_pc_personal_consumption values(seq_personal_consumption.nextval,&