核算报告详情

xiangpei

2024-04-23 72efbdfb7f79bacacc559e552f8076e292073d0f

核算报告详情

 ycl-server/src/main/resources/mapper/zgyw/CalculateRecordMapper.xml

@@ -8,14 +8,24 @@
        <result column="create_time" property="createTime" />
        <result column="rule_id" property="ruleId" />
        <result column="rule_name" property="ruleName" />
        <result column="contract_id" property="contractId" />
        <result column="deduct_category" property="deductCategory" />
        <result column="rule_condition" property="ruleCondition" />
        <result column="rule_desc" property="ruleDesc" />
        <result column="deduct_money" property="deductMoney" />
        <result column="score" property="score" />
    </resultMap>

    <select id="getByContractId" resultMap="BaseResultMap">
        SELECT
            tcr.id, tcr.create_time, tcr.deduct_money, tcru.rule_name, tcr.score, tcr.rule_id
               tcr.id,
               tcr.create_time,
               tcr.deduct_money,
               tcr.score,
               tcr.rule_id,
               tcru.rule_name,
               tcru.deduct_category,
               tcru.rule_desc,
               tcru.rule_condition
        FROM
             t_calculate_record tcr
                 INNER JOIN t_calculate_rule tcru ON tcr.rule_id = tcru.id AND tcr.contract_id = #{contractId}