· 禪道中按產(chǎn)品計(jì)劃統(tǒng)計(jì)需求階段分布表

　　· 使用純sql替代報(bào)表設(shè)計(jì)
　　sql 語句
　　select t2.title， sum(t1.stage='wait') as PRD中， sum(t1.stage='planned') as PRD評審， sum(t1.stage='projected') as PRD完成， sum(t1.stage='developing') as 研發(fā)中， sum(t1.stage='developed') as 研發(fā)完畢，sum(t1.stage='testing') as 測試中， sum(t1.stage='tested') as 測試完畢， sum(t1.stage='verified') as 已驗(yàn)收， sum(t1.stage='released') as 已發(fā)布， count(t2.title) as 總計(jì) from zt_story as t1， zt_productplan as t2 where t1.plan=t2.id and t1.product='43' and t2.product='43' group by t2.title