改动1.0 8-28

zss

2023-08-28 4d6e8cc8d1f41b2b433b8368102fb5387dcd6a3b

改动1.0 8-28

 chart-server/src/main/resources/mapper/WorkMapper.xml

@@ -7,7 +7,7 @@
        from (select distinct user.name, count(inspection_product.id) unfinish
              from lims_laboratory.inspection_product
                       left join lims_laboratory.user on inspection_product.user_pro_id = user.id
              where state = 1
              where inspection_product.state = 1
                and test_state is null
                and inspection_product.inspection_material_id in
                    (select id
@@ -23,7 +23,7 @@
             (select distinct user.name, count(inspection_product.id) finsh
              from lims_laboratory.inspection_product
                       left join lims_laboratory.user on inspection_product.user_pro_id = user.id
              where state = 1
              where inspection_product.state = 1
                and test_state is not null
                and inspection_product.inspection_material_id in
                    (select id
@@ -45,7 +45,7 @@
        from (select distinct user.name, count(inspection_product.id) unfinsh
              from lims_laboratory.inspection_product
                       left join lims_laboratory.user on inspection_product.user_id = user.id
              where state = 1
              where inspection_product.state = 1
                and test_state is null
                and inspection_product.inspection_material_id in
                    (select id
@@ -61,7 +61,7 @@
             (select distinct user.name, count(inspection_product.id) finsh
              from lims_laboratory.inspection_product
                       left join lims_laboratory.user on inspection_product.user_id = user.id
              where state = 1
              where inspection_product.state = 1
                and test_state is not null
                and inspection_product.inspection_material_id in
                    (select id
@@ -83,7 +83,7 @@
        from (select distinct user.name, count(inspection_product.id) total
              from lims_laboratory.inspection_product
                       left join lims_laboratory.user on inspection_product.user_pro_id = user.id
              where state = 1
              where inspection_product.state = 1
                and inspection_product.inspection_material_id in
                    (select id
                     from lims_laboratory.inspection_material
@@ -126,7 +126,7 @@
        from (select distinct user.name, count(inspection_product.id) total
              from lims_laboratory.inspection_product
                       left join lims_laboratory.user on inspection_product.user_id = user.id
              where state = 1
              where inspection_product.state = 1
                and inspection_product.inspection_material_id in
                    (select id
                     from lims_laboratory.inspection_material