爆款活动-退款处理

chenjiahe

2024-03-01 cfedbfad423aa6fd758da748967122819b1787e2

 phi_platform_common/src/main/java/com/hx/phip/tool/order/OrderTool.java

@@ -3,13 +3,17 @@
import com.hx.common.service.CommonService;
import com.hx.mybatisTool.SqlSentence;
import com.hx.phiappt.model.consume.ConsumePayItem;
import com.hx.phiappt.model.order.OrdersTotal;
import com.hx.phiappt.model.userMoney.UserMoneyUnclaimed;
import com.hx.phip.dao.mapper.ConsumePayItemMapper;
import com.hx.phip.dao.mapper.UserMoneyUnclaimedMapper;

import java.util.HashMap;
import java.util.List;
import java.util.Map;

/**订单工具类*/
/**订单工具类
 * @author CJH*/
public class OrderTool {

    /**获取一级子单的支付方式
@@ -26,5 +30,31 @@
        return commonService.selectList(ConsumePayItemMapper.class,sqlSentence);
    }

    /**获取活动赠送资金奖励记录*/
    public static UserMoneyUnclaimed getActivityGive(OrdersTotal ordersTotal, CommonService commonService){
        //查找领取记录释放存在
        //领取记录是否已领取
        SqlSentence sqlSentence = new SqlSentence();
        Map<String,Object> values = new HashMap<>();

        values.put("orderId",ordersTotal.getId());
        values.put("commonId",ordersTotal.getActivityPageCode());
        sqlSentence.sqlSentence("SELECT * FROM user_money_unclaimed WHERE isDel = 0 AND orderId = #{m.orderId} AND commonId = #{m.commonId}",values);
        return commonService.selectOne(UserMoneyUnclaimedMapper.class,sqlSentence);
    }

    /**获取用户活动赠送资金奖励记录-有效*/
    public static List<UserMoneyUnclaimed> getActivityGive(String userId,String commonId, CommonService commonService){
        //查找领取记录释放存在
        //领取记录是否已领取
        SqlSentence sqlSentence = new SqlSentence();
        Map<String,Object> values = new HashMap<>();

        values.put("userId",userId);
        values.put("commonId",commonId);
        sqlSentence.sqlSentence("SELECT * FROM user_money_unclaimed WHERE isDel = 0 AND isValid = 1 AND userId = #{m.userId} AND commonId = #{m.commonId}",values);
        return commonService.selectList(UserMoneyUnclaimedMapper.class,sqlSentence);
    }


}