inspection-server/src/main/resources/mapper/InspectionMapper.xml

@@ -5,18 +5,18 @@
        select i.id,
        i.code icode,
        i.type type,
        DATE_FORMAT(`form_time`,'%Y-%m-%d'),
        DATE_FORMAT(`form_time`,'%Y-%m-%d') form_time,
        supplier,
        im.code mcode,
        im.name,
        specifications,
        unit,
        num,
        DATE_FORMAT(i.`create_time`,'%Y-%m-%d'),
        DATE_FORMAT(i.`create_time`,'%Y-%m-%d') as create_time,
        u.name userName,
        inspection_status,
        DATE_FORMAT(i.`start_time`,'%Y-%m-%d'),
        DATE_FORMAT(i.`end_time`,'%Y-%m-%d')
        DATE_FORMAT(i.`start_time`,'%Y-%m-%d') as start_time,
        DATE_FORMAT(i.`end_time`,'%Y-%m-%d') as end_time
        from lims_laboratory.inspection i
        join lims_laboratory.user u on i.user_id = u.id
        join lims_laboratory.inspection_material im on i.id = im.inspection_id