modify

Helius

2020-12-29 4860f148b405018ff1f8f99de425ae567a675b94

modify

 zq-erp/src/main/resources/mybatis/mapper/hive/AchieveNewDao.xml

@@ -992,8 +992,8 @@
        from achieve_new a
        inner join sys_users b on a.beault_id=b.su_id
        left join sys_shop_info c on a.shop_id=c.ID
        where a.order_type='服务单'
        <where>
            a.order_type='服务单'
            <if test="record.companyId != null">
                and a.company_id=#{record.companyId}
            </if>

 zq-erp/src/main/resources/mybatis/mapper/hive/SysOrderDao.xml

@@ -605,6 +605,6 @@
            </if>
        </where>
        group by b.su_id
        order by amount desc, a.su_id
        order by amount desc, b.su_id
    </select>
</mapper>