储运投资
本月:select i.DISPNAME,s.NAME,ROUND(d.FINISHED_INFO) FINISHED_INFO,ROUND(d.PLAN_BALANCE) PLAN_BALANCE,d.PLAN_NO,d.START_DATE,ROUND(d.TOTAL_INVEST) TOTAL_INVEST,ROUND(d.THISYEAR_INVEST) THISYEAR_INVEST,ROUND(d.STR_CONSTRUCTION) STR_CONSTRUCTION,ROUND(d.STR_EQUIPMENT) STR_EQUIPMENT,ROUND(d.STR_FIX) STR_FIX,ROUND(d.STR_OTHER) STR_OTHERfrom DT_INVEST_INFO_DETAIL d,DT_INVEST_INFO r,DT_INVEST_ITEM i,SYS_DICTIONARY sWHERE d.DT_INVEST_INFO = r.IDand s.TYPE = i.ITEMTYPEand i.INVESTTYPE = s.IDand i.ID = d.PROJECT_NAMEand r.AUDIT_STATUS = '1'and r.ORG_TYPE = ?and r.YEAR_MONTH = ?and r.PROJECT_TYPE = 'TZXM-CYXM' ORDER BY i.DISPNO asc
分类:
select s.NAMEfrom SYS_DICTIONARY s,SYS_DICTIONARYCONFIG cwhere c.ID = s.TYPEand c.CODE = 'TZXM-CYXM'order by s.ID asc
本年累计:
select i.DISPNAME,ROUND(d.FINISHED_INFO) FINISHED_INFO,ROUND(d.PLAN_BALANCE) PLAN_BALANCE,d.PLAN_NO,d.PROJECT_NAME,d.START_DATE,ROUND(d.TOTAL_INVEST) TOTAL_INVEST,ROUND(d.THISYEAR_INVEST) THISYEAR_INVEST,ROUND(d.STR_CONSTRUCTION) STR_CONSTRUCTION,ROUND(d.STR_EQUIPMENT) STR_EQUIPMENT,ROUND(d.STR_FIX) STR_FIX,ROUND(d.STR_OTHER) STR_OTHERfrom DT_INVEST_INFO_DETAIL d,DT_INVEST_INFO r,DT_INVEST_ITEM i,SYS_DICTIONARY swhere d.DT_INVEST_INFO = r.IDand s.TYPE = i.ITEMTYPEand i.INVESTTYPE = s.IDand i.ID = d.PROJECT_NAMEand r.AUDIT_STATUS = '1'and r.ORG_TYPE = ?and r.YEAR_MONTH between ? and ?and r.PROJECT_TYPE = 'TZXM-CYXM'order by i.DISPNO asc
去年累计:
select i.DISPNAME,ROUND(d.FINISHED_INFO) FINISHED_INFO,ROUND(d.PLAN_BALANCE) PLAN_BALANCE,d.PLAN_NO,d.PROJECT_NAME,d.START_DATE,ROUND(d.TOTAL_INVEST) TOTAL_INVEST,ROUND(d.THISYEAR_INVEST) THISYEAR_INVEST,ROUND(d.STR_CONSTRUCTION) STR_CONSTRUCTION,ROUND(d.STR_EQUIPMENT) STR_EQUIPMENT,ROUND(d.STR_FIX) STR_FIX,ROUND(d.STR_OTHER) STR_OTHERfrom DT_INVEST_INFO_DETAIL d,DT_INVEST_INFO r,DT_INVEST_ITEM i,SYS_DICTIONARY swhere d.DT_INVEST_INFO = r.IDand s.TYPE = i.ITEMTYPEand i.INVESTTYPE = s.IDand i.ID = d.PROJECT_NAMEand r.AUDIT_STATUS = '1'and r.ORG_TYPE = ?and r.YEAR_MONTH between ? and ?and r.PROJECT_TYPE = 'TZXM-CYXM'order by i.DISPNO asc
自开工累计:
select i.DISPNAME,ROUND(d.FINISHED_INFO) FINISHED_INFO,ROUND(d.PLAN_BALANCE) PLAN_BALANCE,d.PLAN_NO,d.PROJECT_NAME,d.START_DATE,ROUND(d.TOTAL_INVEST) TOTAL_INVEST,ROUND(d.THISYEAR_INVEST) THISYEAR_INVEST,ROUND(d.STR_CONSTRUCTION) STR_CONSTRUCTION,ROUND(d.STR_EQUIPMENT) STR_EQUIPMENT,ROUND(d.STR_FIX) STR_FIX,ROUND(d.STR_OTHER) STR_OTHERfrom DT_INVEST_INFO_DETAIL d,DT_INVEST_INFO r,DT_INVEST_ITEM i,SYS_DICTIONARY swhere d.DT_INVEST_INFO = r.IDand s.TYPE = i.ITEMTYPEand i.INVESTTYPE = s.IDand i.ID = d.PROJECT_NAMEand r.AUDIT_STATUS = '1'and r.ORG_TYPE = ?and d.START_DATE between ? and ?and r.PROJECT_TYPE = 'TZXM-CYXM'ORDER BY i.DISPNO asc
页:
[1]