调整语法不兼容

whycxzp

2024-11-12 3c51c159a12f820c335af6b969d0c73eac798b94

调整语法不兼容

 src/main/resources/mapper/FaultUploadMapper.xml

@@ -92,16 +92,16 @@
    </select>
    <select id="getListWithGroupName" resultType="com.whyc.pojo.FaultUpload">
        SELECT distinct
            u.*,user.uName as upload_user_name,g.baoji_group_name as group_name
            u.*,usr.uName as upload_user_name,g.baoji_group_name as group_name
        FROM
            web_site.tb_fault_upload u,
            db_user.tb_user_battgroup_baojigroup_battgroup bb,
            db_user.tb_user_battgroup_baojigroup g,
            db_user.tb_user_inf user
            db_user.tb_user_inf usr
        WHERE
            u.station_id = bb.StationId
        and bb.baoji_group_id = g.baoji_group_id
        and u.upload_user_id = user.uId
        and u.upload_user_id = usr.uId
        and g.discharge_plan_flag = 1
        and u.create_time like  CONCAT('%',#{year},'%')
        and station_id in