项目视图源码

 

CREATE VIEW dpperformance_view

as

SELECT a.supplierid,b.name,a.okcon1d,a.failcon1d,(a.okcon1d/(a.okcon1d+a.failcon1d)*100) as successrate1day,a.okcon3d,a.failcon3d,(a.okcon3d/(a.okcon3d+a.failcon3d)*100) as successrate3day,a.okcon1w,a.failcon1w,(a.okcon1w/(a.okcon1w+a.failcon1w)*100) as successrate1week,a.okcon1m,a.failcon1m,(a.okcon1m/(a.okcon1m+a.failcon1m)*100) as successrate1month,a.okcon1y,a.failcon1y,(a.okcon1y/(a.okcon1y+a.failcon1y)*100) as successrate1year,(select count(*) from stockarticle where upv is null and downv is null and stockarticle.recomid=a.supplierid) as dates from dpperformance a,supplier b where a.supplierid=b.id