<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.hdkj.lt.mq.mapper.plan.FhzgPlanTransferSchemeMapper">

    <select id="getLoadRecoveryByPlanId"
            resultType="java.lang.String">
        SELECT load_recovery
        FROM fhzg_plan_transfer_scheme
        where id = #{schemeId}
    </select>

    <select id="getShemeIdByPlanId" resultType="java.lang.Long">
        SELECT id
        FROM fhzg_plan_transfer_scheme
        where plan_id = #{planId}
        order by load_recovery desc
            limit 10
    </select>

    <update id="updateEvaluationScore">
        update fhzg_plan_transfer_scheme
        set evaluation_score = #{score}
        where id = #{schemeId}
    </update>
</mapper>
