20221021

xiaoyong931011

2022-11-02 cd72d7e6c3acd087091c4b2d233f35765ddbfda7

20221021

 src/main/java/cc/mrbird/febs/dapp/mapper/IgtOnHookPlanOrderDao.java

@@ -27,4 +27,8 @@
    List<IgtOnHookPlanOrder> selectByCreateTime(@Param("createTime")String format);

    IPage<AdminIgtOnHookPlanOrderVo> findMemberPlanListInPage(Page<IgtOnHookPlanOrder> page, @Param("record")IgtOnHookPlanOrder igtOnHookPlanOrder);

    List<Long> selectIdsByState(@Param("state")int i);

    void updateByIds(List<Long> ids);
}

 src/main/java/cc/mrbird/febs/job/OnHookPlanJob.java

@@ -278,9 +278,11 @@
    @Scheduled(cron = "0 0/1 * * * ? ")
    public void updatePlanOrder(){
        Log.info("开始更新挂机主表状态");

        List<IgtOnHookPlanOrder> igtOnHookPlanOrders = igtOnHookPlanOrderDao.selectByState(3);
        if(CollUtil.isNotEmpty(igtOnHookPlanOrders)){
            List<Long> ids = igtOnHookPlanOrderDao.selectIdsByState(3);
            //更新状态避免重复查询
            igtOnHookPlanOrderDao.updateByIds(ids);
            for(IgtOnHookPlanOrder igtOnHookPlanOrder : igtOnHookPlanOrders){
                Long memberId = igtOnHookPlanOrder.getMemberId();
                BigDecimal planAmount = igtOnHookPlanOrder.getPlanAmount();

 src/main/resources/mapper/dapp/IgtOnHookPlanOrderDao.xml

@@ -81,4 +81,21 @@
        order by s.create_time desc
    </select>

    <select id="selectIdsByState" resultType="java.lang.Long">
        SELECT
            a.id
        FROM igt_on_hook_plan_order a
        where a.state = #{state}
    </select>

    <update id="updateByIds" parameterType="list">
            update igt_on_hook_plan_order
            set
                state = 2
            where 1=1
        <foreach collection="list" item="id">
              or id = #{id}
        </foreach>
    </update>

</mapper>

 src/main/resources/templates/febs/views/dapp/member.html

@@ -298,7 +298,7 @@
                    {type: 'checkbox'},
                    {type: 'numbers'},
                    {field: 'username', title: '用户名', minWidth: 130},
                    {field: 'identity', title: '会员等级',
                    {field: 'identity', title: '会员',
                        templet: function (d) {
                            if (d.identity === 'LEVEL_TM') {
                                return '<span>游客</span>'
@@ -308,6 +308,7 @@
                                return ''
                            }
                        }, minWidth: 100, align: 'center'},
                    {field: 'identity', title: '等级', minWidth: 100, align: 'center'},
                    // {field: 'address', title: '地址', minWidth: 130},
                    // {title: '余额(USDT)', templet: '#balance', minWidth: 120},
                    // {title: '授权列表', templet: '#approve-list', minWidth: 110},