| | |
| | | import com.xcong.excoin.modules.yunding.vo.YdProductVo; |
| | | import org.apache.ibatis.annotations.Param; |
| | | |
| | | import java.util.List; |
| | | |
| | | public interface YdProductDao extends BaseMapper<YdProductEntity> { |
| | | |
| | | IPage<YdProductVo> getProductList(Page<YdProductVo> page, @Param("record") YdProductListDto ydProductListDto); |
| | | |
| | | YdProductVo findProductInfoById(@Param("id")Long id); |
| | | |
| | | List<YdProductEntity> selectXchProductList(); |
| | | } |
| | |
| | | @Transactional(rollbackFor = Exception.class) |
| | | public void xchProfitDistributor(BigDecimal totalProfit) { |
| | | Date currentDate = new Date(); |
| | | List<YdProductEntity> products = ydProductDao.selectList(null); |
| | | List<YdProductEntity> products = ydProductDao.selectXchProductList(); |
| | | if (CollUtil.isNotEmpty(products)) { |
| | | BigDecimal totalCount = BigDecimal.ZERO; |
| | | for (YdProductEntity product : products) { |
| | |
| | | <id column="p_id" property="id" /> |
| | | <result column="pro_unit" property="proUnit" /> |
| | | <result column="manage_expense" property="manageExpense" /> |
| | | <result column="pro_num" property="proNum" /> |
| | | </association> |
| | | </resultMap> |
| | | |
| | |
| | | select a.*, c.id p_id, c.pro_unit, c.pro_num |
| | | from yd_order a |
| | | inner join (select * from member a where find_in_set(#{inviteId}, a.referer_ids) or invite_id=#{inviteId}) b on a.member_id=b.id |
| | | inner join yd_product c on c.id = a.product_id |
| | | inner join yd_product c on c.id = a.product_id and c.pro_unit!='节点' |
| | | where a.type=1 |
| | | </select> |
| | | |
| | |
| | | |
| | | <mapper namespace="com.xcong.excoin.modules.yunding.dao.YdProductDao"> |
| | | |
| | | <select id="selectXchProductList" resultType="com.xcong.excoin.modules.yunding.entity.YdProductEntity"> |
| | | select * from yd_product where coin = 'XCH' |
| | | </select> |
| | | |
| | | <select id="getProductList" resultType="com.xcong.excoin.modules.yunding.vo.YdProductVo"> |
| | | select |
| | | * |