2015-12-28 工作笔记-1

今天完成的工作包括如下：

1、对Orcale数据库的数据进行分类统计，主要涉及行转列、总数与各个分项的连接，为方便使用数据创建视图

create or replace view benefitsstatistical_view as

select tb1.ducode, tb1.AREACODE,tb1.EVALYEAR,tb1.Water,tb1.Soil,tb1.Carbon,tb1.Nutrient,tb1.Air,tb1.Diversity,tb1.Play,tb1.DUNAME,tb.EVAL total from


            (
              select lt.*,rt.duname,rt.ducode from (

               select
                  Areacode,
                  evalyear,
                  sum(decode(PID,'1', Eval,null)) Water,
                  sum(decode(PID,'2', Eval,null)) Soil,
                  sum(decode(PID,'3', Eval,null)) Carbon,
                  sum(decode(PID,'4', Eval,null)) Nutrient,
                  sum(decode(PID,'5', Eval,null)) Air,
                  sum(decode(PID,'6', Eval,null)) Diversity,
                  sum(decode(PID,'7', Eval,null)) Play
               from
                         (            select
                                         sum(t.evalvalue) Eval,
                                         t.evaldistrict  Areacode ,
                                         substr(t.evalparentid,0,1)  PID,
                                         t.evalyear  evalyear
                                 from
                                         BM_EVALRESULT t,bm_evalresultzd m ,sys_area l
                                 where
                                         t.evalid=m.evalid and m.ismoney='1'
                                 group by
                                       t.evaldistrict ,t.evalparentid ,t.evalyear
                         )  tmp
                        group by Areacode,evalyear) lt,bm_dataunit rt

              where lt.Areacode=rt.ducode and rt.isxzqh='1'

           ) tb1,

        (      select
                 sum(t.evalvalue) Eval,
                 t.evaldistrict  Areacode,
                 t.evalyear evalyear

         from
                 BM_EVALRESULT t,bm_evalresultzd m ,sys_area l
         where
                 t.evalid=m.evalid and m.ismoney='1'
         group by
               t.evaldistrict,t.evalyear )  tb


               where tb.Areacode=tb1.Areacode and tb.evalyear=tb1.evalyear;

2、对统计的数据进行饼图展示，插件为echart，以前会使用Ajax返回josn串，今天该采用后台进行数据邦定