opt: 人大金仓数据库改造

linwei

2026-04-07 daa84749e7a9427dfedd3970ff4b1b2bc6ae07e9

opt: 人大金仓数据库改造

 drone-service/drone-gd/src/main/java/org/sxkj/gd/orderdata/mapper/GdSupplyDemandMapper.xml

@@ -115,14 +115,15 @@
            <include refid="gdSupplyDemandCondition"/>
            <if test="deptIdList != null and deptIdList.size > 0">
                AND (
                    create_dept IN
                    <foreach collection="deptIdList" item="deptId" open="(" separator="," close=")">
                        #{deptId}
                    </foreach>
                    OR apply_target_dept_id IN
                    <foreach collection="deptIdList" item="deptId" open="(" separator="," close=")">
                        #{deptId}
                    </foreach>
                create_dept::text IN
                <foreach collection="deptIdList" item="deptId" open="(" separator="," close=")">
                    #{deptId}::text
                </foreach>
                OR
                apply_target_dept_id::text IN
                <foreach collection="deptIdList" item="deptId" open="(" separator="," close=")">
                    #{deptId}::text
                </foreach>
                )
            </if>
        </where>