Merge branch '2.0' of http://120.76.84.145:10101/gitblit/r/java/PlayPai into 2.0
| | |
| | | userPointsMerchandise.setPayStatus(2); |
| | | userPointsMerchandise.setPaymentTime(new Date()); |
| | | userPointsMerchandise.setOrderNumber(tradeNo); |
| | | userPointsMerchandise.setPayType(2); |
| | | userPointsMerchandise.setCashPayType(2); |
| | | userPointsMerchandise.setInsertTime(null); |
| | | userPointsMerchandise.setUserId(null); |
| | | mcClient.updateDetailsUserPointMercase(userPointsMerchandise); |
| | |
| | | userPointsMerchandise.setPayStatus(2); |
| | | userPointsMerchandise.setPaymentTime(new Date()); |
| | | userPointsMerchandise.setOrderNumber(transaction_id); |
| | | userPointsMerchandise.setPayType(1); |
| | | userPointsMerchandise.setCashPayType(1); |
| | | mcClient.updateDetailsUserPointMercase(userPointsMerchandise); |
| | | |
| | | TAppUser tAppUser = baseMapper.selectById(userPointsMerchandise.getUserId()); |
| | |
| | | if (ToolUtil.isNotEmpty(pointMercharsPayedVo.getStatus())) { |
| | | userPointsMerchandiseLambdaQueryWrapper.eq(UserPointsMerchandise::getStatus, pointMercharsPayedVo.getStatus()); |
| | | } |
| | | List<UserPointsMerchandise> list = upmseService.list(userPointsMerchandiseLambdaQueryWrapper); |
| | | List<UserPointsMerchandise> list = upmseService.list(userPointsMerchandiseLambdaQueryWrapper.orderByDesc(UserPointsMerchandise::getPaymentTime)); |
| | | System.out.println(list); |
| | | SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); |
| | | if (list.size() > 0) { |
| | |
| | | map.put("total", 0); |
| | | return map; |
| | | } |
| | | List<WorldCupPaymentParticipant> list1 = this.list(new QueryWrapper<WorldCupPaymentParticipant>().in("worldCupPaymentId", collect)); |
| | | List<WorldCupPaymentParticipant> list1 = this.list(new QueryWrapper<WorldCupPaymentParticipant>().in("worldCupPaymentId", collect).orderByDesc("createTime")); |
| | | List<Map<String, Object>> list2 = new ArrayList<>(); |
| | | SimpleDateFormat sdf = new SimpleDateFormat("yyyy"); |
| | | SimpleDateFormat sdf1 = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); |
| | | for (WorldCupPaymentParticipant on : list1) { |
| | | WorldCupPayment worldCupPayment = worldCupPaymentService.getById(on.getWorldCupPaymentId()); |
| | | Map<String, Object> map1 = new HashMap<>(); |
| | |
| | | map1.put("phone", ToolUtil.isEmpty(tStudent.getPhone()) ? appUser.getPhone() : tStudent.getPhone()); |
| | | map1.put("idcard", tStudent.getIdCard()); |
| | | map1.put("state", worldCupPayment.getPayStatus() - 1); |
| | | map1.put("insertTime", sdf1.format(worldCupPayment.getPayTime())); |
| | | }else{ |
| | | Participant participant = participantClient.getParticipant(on.getParticipantId()); |
| | | if(ToolUtil.isNotEmpty(name) && participant.getName().indexOf(name) == -1){ |
| | |
| | | map1.put("phone", ToolUtil.isNotEmpty(participant.getPhone()) ? participant.getPhone() : appUser.getPhone()); |
| | | map1.put("idcard", participant.getIdcard()); |
| | | map1.put("state", worldCupPayment.getPayStatus() - 1); |
| | | map1.put("insertTime", sdf1.format(worldCupPayment.getPayTime())); |
| | | } |
| | | list2.add(map1); |
| | | } |
| | |
| | | package com.dsh.competition.feignclient.model; |
| | | |
| | | import com.fasterxml.jackson.annotation.JsonFormat; |
| | | import lombok.Data; |
| | | |
| | | import java.util.Date; |
| | | |
| | | @Data |
| | | public class CompetitionUser { |
| | |
| | | private String phone; |
| | | private String idCard; |
| | | private Integer state; |
| | | @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8") |
| | | private Date insertTime; |
| | | } |
| | |
| | | if(null != paymentCompetition){ |
| | | competitionUser.setState(paymentCompetition.getPayStatus()); |
| | | } |
| | | competitionUser.setInsertTime(userCompetition.getInsertTime()); |
| | | list.add(competitionUser); |
| | | } |
| | | Page<CompetitionUser> page = new Page<>(); |
| | |
| | | </springProfile> |
| | | |
| | | <springProfile name="prod"> |
| | | <root level="warn"> |
| | | <root level="info"> |
| | | <!-- 生产环境最好不配置console写文件 --> |
| | | <appender-ref ref="DEBUG_FILE"/> |
| | | <appender-ref ref="INFO_FILE"/> |
| | |
| | | </select> |
| | | |
| | | <select id="getPeopleFromId1" resultType="com.dsh.competition.entity.UserCompetition"> |
| | | select * from ( |
| | | select |
| | | a.* |
| | | from t_user_competition a |
| | | left join t_payment_competition b on (a.paymentCompetitionId = b.id) |
| | | where b.state = 1 and b.payStatus != 1 and a.competitionId = #{id} |
| | | select * from t_user_competition where competitionId = #{id} and paymentCompetitionId in ( |
| | | select id from t_payment_competition where state = 1 and payStatus != 1 |
| | | <if test="null != state and state == 1"> |
| | | and b.payStatus = 2 |
| | | and payStatus = 2 |
| | | </if> |
| | | <if test="null != state and state == 3"> |
| | | and b.payStatus = 3 |
| | | and payStatus = 3 |
| | | </if> |
| | | group by a.id |
| | | ) as aa where aa.id is not null order by aa.insertTime desc limit #{offset}, #{limit} |
| | | ) order by insertTime desc limit #{offset}, #{limit} |
| | | </select> |
| | | |
| | | <select id="getPeopleFromIdCount" resultType="java.lang.Integer"> |
| | | select |
| | | count(*) |
| | | from ( |
| | | select |
| | | a.id |
| | | from t_user_competition a |
| | | left join t_payment_competition b on (a.paymentCompetitionId = b.id) |
| | | where b.state = 1 and b.payStatus != 1 and a.competitionId = #{id} |
| | | select count(1) from t_user_competition where competitionId = #{id} and paymentCompetitionId in ( |
| | | select id from t_payment_competition where state = 1 and payStatus != 1 |
| | | <if test="null != state and state == 1"> |
| | | and b.payStatus = 2 |
| | | and payStatus = 2 |
| | | </if> |
| | | <if test="null != state and state == 3"> |
| | | and b.payStatus = 3 |
| | | and payStatus = 3 |
| | | </if> |
| | | group by a.id |
| | | ) as aa where aa.id is not null |
| | | ) |
| | | </select> |
| | | |
| | | |
| | |
| | | package com.dsh.course.feignClient.competition.model; |
| | | |
| | | import com.fasterxml.jackson.annotation.JsonFormat; |
| | | import lombok.Data; |
| | | |
| | | import java.util.Date; |
| | | |
| | | @Data |
| | | public class CompetitionUser { |
| | |
| | | private String phone; |
| | | private String idCard; |
| | | private Integer state; |
| | | @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8") |
| | | private Date insertTime; |
| | | } |
| | |
| | | <form class="m-t" role="form" action="${ctxPath}/login" method="post"> |
| | | <div class="item"> |
| | | <img src="${ctxPath}/img/account.png" /> |
| | | <input class="itemInput" type="text" name="username" id="username" placeholder="请输入账号" required="" value="admin"> |
| | | <input class="itemInput" type="text" name="username" id="username" placeholder="请输入账号" required="" value=""> |
| | | </div> |
| | | <div class="item"> |
| | | <img src="${ctxPath}/img/password.png" /> |
| | | <input class="itemInput" type="password" name="password" id="password" placeholder="请输入密码" required="" value="123456"> |
| | | <input class="itemInput" type="password" name="password" id="password" placeholder="请输入密码" required="" value=""> |
| | | </div> |
| | | |
| | | <div class="form-group" style="float: left;"> |
| | | <div class="col-sm-8" style="padding-left: 0px; padding-right: 0px;"> |
| | | <input class="form-control" type="text" name="kaptcha" placeholder="验证码" required="" value="111111"> |
| | | <input class="form-control" type="text" name="kaptcha" placeholder="验证码" required="" value=""> |
| | | </div> |
| | | <div class="col-sm-4" style="padding-left: 0px; padding-right: 0px;"> |
| | | <img src="${ctxPath}/kaptcha" id="kaptcha" width="90px" height="34px"/> |
| | |
| | | }, |
| | | {title: '身份证号', field: 'idCard', visible: true, align: 'center', valign: 'middle',width:'8%', |
| | | }, |
| | | {title: '报名时间', field: 'insertTime', visible: true, align: 'center', valign: 'middle',width:'8%', |
| | | }, |
| | | {title: '状态', field: 'state', visible: true, align: 'center', valign: 'middle',width:'8%', |
| | | formatter:function (data) { |
| | | return {1:"正常",2:"正常",3:"已取消"}[data] |
| | |
| | | return '<a href="#" onclick="RegisteredPersonnel.openQRCode(' + item.id + ', ' + item.isStudent + ',\'' + item.name + '\')" style="color:blue;">查看</a>' |
| | | } |
| | | }, |
| | | {title: '报名时间', field: 'insertTime', visible: true, align: 'center', valign: 'middle'}, |
| | | {title: '状态', field: 'state', visible: true, align: 'center', valign: 'middle', |
| | | formatter:function (data) { |
| | | return {1:"正常",2:"已取消"}[data] |