create view wage_zs_view as
select distinct E37_worker.Wor_name,R8_4_workroom.Wor_type,DM_class.class_name,E4_workroom.Workroom_date,E4_workroom.Workroom_class,R8_4_workroom.Workroom_cq,E1_Material.M_name,R8_4_workroom.Workroom_peo_num,R8_4_workroom.Workroom_good_num,R8_4_workroom.Workroom_pro_price,R8_4_workroom.Workroom_is_add,R8_4_workroom.Workroom_ycf,R8_4_workroom.Workroom_time_s*1.5+R8_4_workroom.Workroom_time_f*2+R8_4_workroom.Workroom_stop_time*3 as wage_stop,R8_4_workroom.Workroom_pro_price*R8_4_workroom.Workroom_peo_num+R8_4_workroom.Workroom_is_add+R8_4_workroom.Workroom_time_s*1.5+R8_4_workroom.Workroom_time_f*2+R8_4_workroom.Workroom_stop_time*3 as wage
from R8_4_workroom,E4_workroom,E37_worker,DM_class,E1_Material
where E4_workroom.Workroom_id=R8_4_workroom.Workroom_id and R8_4_workroom.Wor_id=E37_worker.Wor_id and R8_4_workroom.M_id=E1_Material.M_id and E4_workroom.class_id =DM_class.class_id and E4_workroom.class_id in (select class_id from DM_class where class_name like '注塑%')
create view wage_zs_view2 as
select Wor_name,Workroom_date,Workroom_cq,Workroom_ycf,wage from wage_zs_view
select wage_zs_view.Wor_name,wage_zs_view.Wor_type,wage_zs_view.class_name,wage_zs_view.Workroom_date,wage_zs_view.Workroom_class,wage_zs_view.Workroom_cq,wage_zs_view.M_name,wage_zs_view.Workroom_peo_num,wage_zs_view.Workroom_good_num,wage_zs_view.Workroom_pro_price,wage_zs_view.Workroom_is_add,wage_zs_view.Workroom_ycf,wage_zs_view.wage_stop,wage_zs_view.wage,total_cq=(select sum(wage_zs_view2.Workroom_cq) from wage_zs_view2 where wage_zs_view.Wor_name=wage_zs_view2.Wor_name),total_ycf=(select sum(wage_zs_view2.Workroom_ycf) from wage_zs_view2 where wage_zs_view.Wor_name=wage_zs_view2.Wor_name),total_wage=(select sum(wage_zs_view2.wage) from wage_zs_view2 where wage_zs_view.Wor_name=wage_zs_view2.Wor_name) from wage_zs_view group by wage_zs_view.Wor_name,wage_zs_view.Wor_type,wage_zs_view.class_name,wage_zs_view.Workroom_date,wage_zs_view.Workroom_class,wage_zs_view.Workroom_cq,wage_zs_view.M_name,wage_zs_view.Workroom_peo_num,wage_zs_view.Workroom_good_num,wage_zs_view.Workroom_pro_price,wage_zs_view.Workroom_is_add,wage_zs_view.Workroom_ycf,wage_zs_view.wage_stop,wage_zs_view.wage