<commit_before><?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="selling.order.pool">

	<resultMap id="refundConfigVo" type="selling.sunshine.model.RefundConfig">
		<result property="refundConfigId" column="refund_config_id"></result>
		<result property="amountTrigger" column="refund_trigger_amount"></result>
		<result property="level1Percent" column="level_1_percent"></result>
		<result property="level2Percent" column="level_2_percent"></result>
		<result property="level3Percent" column="level_3_percent"></result>
	</resultMap>

	<resultMap id="goods4AgentVo" type="selling.sunshine.model.goods.Goods4Agent">
		<result property="goodsId" column="goods_id"></result>
		<result property="name" column="goods_name"></result>
		<result property="description" column="goods_description"></result>
		<result property="agentPrice" column="agent_price"></result>
		<result property="blockFlag" column="block_flag"></result>
		<result property="createAt" column="create_time"></result>
	</resultMap>
	
	<resultMap id="agentLiteVo" type="selling.sunshine.model.lite.Agent">
        <result property="agentId" column="agent_id"></result>
        <result property="name" column="agent_name"></result>
        <result property="phone" column="agent_phone"></result>
    </resultMap>

	<resultMap id="agentVo" type="selling.sunshine.model.Agent">
		<result property="agentId" column="agent_id"></result>
		<result property="name" column="agent_name"></result>
		<result property="gender" column="agent_gender"></result>
		<result property="phone" column="agent_phone"></result>
		<result property="address" column="agent_address"></result>
		<result property="wechat" column="agent_wechat"></result>
		<result property="password" column="agent_password"></result>
		<result property="granted" column="agent_granted"></result>
		<result property="agentRefund" column="agent_refund"></result>
		<result property="coffer" column="agent_coffer"></result>
		<result property="blockFlag" column="block_flag"></result>
		<result property="createAt" column="create_time"></result>
		<association property="upperAgent" column="agentId = upper_agent_id" select="agentLiteQuery"></association>
	</resultMap>

    <resultMap id="orderPoolVo" type="selling.sunshine.model.OrderPool">
        <result property="orderPoolId" column="pool_id"></result>
        <result property="quantity" column="quantity"></result>
        <result property="price" column="price"></result>
        <result property="refundAmount" column="refund_amount"></result>
        <result property="poolDate" column="pool_date"></result>
        <result property="blockFlag" column="block_flag"></result>
        <result property="createAt" column="create_time"></result>
        <association property="agent" column="agentId = agent_id" select="agentQuery"></association>
		<association property="goods" column="goodsId = goods_id" select="goods4AgentQuery"></association>
		<association property="refundConfig" column="refundConfigId = refund_config_id" select="refundConfigQuery"></association>
    </resultMap>
    
    <resultMap id="sumOrderVo" type="java.util.Map">
        <result property="agent" column="agent"></result>
        <result property="goods" column="goods"></result>
        <result property="quantity" column="quantity"></result>
        <result property="price" column="price"></result>
    </resultMap>
    
    <resultMap id="orderQuantityVo" type="java.util.Map">
        <result property="quantity" column="quantity"></result>
    </resultMap>
    <resultMap id=""customerOrderQuantityVo"" type="java.util.Map">
        <result property="quantity" column="quantity"></result>
    </resultMap>

	<select id="refundConfigQuery" parameterType="java.util.Map" resultMap="refundConfigVo">
		SELECT refund_config_id, refund_trigger_amount, level_1_percent,level_2_percent,level_3_percent<commit_msg> Changes to be committed: 	modified:   src/main/java/selling/sunshine/mapper/orderpool.xml<commit_after><?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="selling.order.pool">

	<resultMap id="refundConfigVo" type="selling.sunshine.model.RefundConfig">
		<result property="refundConfigId" column="refund_config_id"></result>
		<result property="amountTrigger" column="refund_trigger_amount"></result>
		<result property="level1Percent" column="level_1_percent"></result>
		<result property="level2Percent" column="level_2_percent"></result>
		<result property="level3Percent" column="level_3_percent"></result>
	</resultMap>

	<resultMap id="goods4AgentVo" type="selling.sunshine.model.goods.Goods4Agent">
		<result property="goodsId" column="goods_id"></result>
		<result property="name" column="goods_name"></result>
		<result property="description" column="goods_description"></result>
		<result property="agentPrice" column="agent_price"></result>
		<result property="blockFlag" column="block_flag"></result>
		<result property="createAt" column="create_time"></result>
	</resultMap>
	
	<resultMap id="agentLiteVo" type="selling.sunshine.model.lite.Agent">
        <result property="agentId" column="agent_id"></result>
        <result property="name" column="agent_name"></result>
        <result property="phone" column="agent_phone"></result>
    </resultMap>

	<resultMap id="agentVo" type="selling.sunshine.model.Agent">
		<result property="agentId" column="agent_id"></result>
		<result property="name" column="agent_name"></result>
		<result property="gender" column="agent_gender"></result>
		<result property="phone" column="agent_phone"></result>
		<result property="address" column="agent_address"></result>
		<result property="wechat" column="agent_wechat"></result>
		<result property="password" column="agent_password"></result>
		<result property="granted" column="agent_granted"></result>
		<result property="agentRefund" column="agent_refund"></result>
		<result property="coffer" column="agent_coffer"></result>
		<result property="blockFlag" column="block_flag"></result>
		<result property="createAt" column="create_time"></result>
		<association property="upperAgent" column="agentId = upper_agent_id" select="agentLiteQuery"></association>
	</resultMap>

    <resultMap id="orderPoolVo" type="selling.sunshine.model.OrderPool">
        <result property="orderPoolId" column="pool_id"></result>
        <result property="quantity" column="quantity"></result>
        <result property="price" column="price"></result>
        <result property="refundAmount" column="refund_amount"></result>
        <result property="poolDate" column="pool_date"></result>
        <result property="blockFlag" column="block_flag"></result>
        <result property="createAt" column="create_time"></result>
        <association property="agent" column="agentId = agent_id" select="agentQuery"></association>
		<association property="goods" column="goodsId = goods_id" select="goods4AgentQuery"></association>
		<association property="refundConfig" column="refundConfigId = refund_config_id" select="refundConfigQuery"></association>
    </resultMap>
    
    <resultMap id="sumOrderVo" type="java.util.Map">
        <result property="agent" column="agent"></result>
        <result property="goods" column="goods"></result>
        <result property="quantity" column="quantity"></result>
        <result property="price" column="price"></result>
    </resultMap>
    
    <resultMap id="orderQuantityVo" type="java.util.Map">
        <result property="quantity" column="quantity"></result>
    </resultMap>
    <resultMap id="customerOrderQuantityVo" type="java.util.Map">
        <result property="quantity" column="quantity"></result>
    </resultMap>

	<select id="refundConfigQuery" parameterType="java.util.Map" resultMap="refundConfigVo">
		SELECT refund_config_id, refund_trigger_amount, level_1_percent,level_2_percent,level_3_percent
{'fraction_non_alphanumeric': 0.16627343847013534, 'fraction_numerical': 0.004470383707934931, 'mean_word_length': 6.341841385597083, 'pattern_counts': {'":': 0, '<': 215, '<?xml version=': 2, '>': 215, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 3}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '1686730', 'n_tokens_mistral': 2448, 'n_tokens_neox': 2339, 'n_words': 383}