| | |
| | | userWithdraw.setWithStatus(Integer.valueOf(0)); |
| | | BigDecimal withfee = siteSetting.getWithFeePercent().multiply(new BigDecimal(amt)).add(new BigDecimal(siteSetting.getWithFeeSingle().intValue())); |
| | | userWithdraw.setWithFee(withfee); |
| | | log.info(userWithdraw.toString()); |
| | | int insertCount = this.userWithdrawMapper.insert(userWithdraw); |
| | | if (insertCount > 0) { |
| | | return ServerResponse.createBySuccessMsg("提现成功",request); |
| | |
| | | public static void main(String[] args) { |
| | | String encryptData = encryptFromString("zdm321123.", Mode.CBC, Padding.ZeroPadding); |
| | | System.out.println("加密:" + encryptData); |
| | | String decryptData = decryptFromString("rcjjhE1g+WSu+SL0EKuKQA==", Mode.CBC, Padding.ZeroPadding); |
| | | String decryptData = decryptFromString("MXvZr8iRBQUQFShywDjmpw==", Mode.CBC, Padding.ZeroPadding); |
| | | System.out.println("解密:" + decryptData); |
| | | } |
| | | |
| | |
| | | delete from user_withdraw |
| | | where id = #{id,jdbcType=INTEGER} |
| | | </delete> |
| | | <insert id="insert" parameterType="com.nq.pojo.UserWithdraw" > |
| | | insert into user_withdraw (id, user_id, nick_name, |
| | | agent_id, with_amt, apply_time, |
| | | trans_time, with_name, bank_no, |
| | | bank_name, bank_address, with_status, |
| | | with_fee, with_msg) |
| | | values (#{id,jdbcType=INTEGER}, #{userId,jdbcType=INTEGER}, #{nickName,jdbcType=VARCHAR}, |
| | | #{agentId,jdbcType=INTEGER}, #{withAmt,jdbcType=DECIMAL}, #{applyTime,jdbcType=TIMESTAMP}, |
| | | #{transTime,jdbcType=TIMESTAMP}, #{withName,jdbcType=VARCHAR}, #{bankNo,jdbcType=VARCHAR}, |
| | | #{bankName,jdbcType=VARCHAR}, #{bankAddress,jdbcType=VARCHAR}, #{withStatus,jdbcType=INTEGER}, |
| | | #{withFee,jdbcType=DECIMAL}, #{withMsg,jdbcType=VARCHAR}) |
| | | </insert> |
| | | <insert id="insertSelective" parameterType="com.nq.pojo.UserWithdraw" > |
| | | insert into user_withdraw |
| | | <trim prefix="(" suffix=")" suffixOverrides="," > |
| | |
| | | |
| | | <select id="listByAdmin" resultMap="BaseResultMap" parameterType="map"> |
| | | SELECT |
| | | <include refid="Base_Column_List"/> |
| | | * |
| | | FROM user_withdraw |
| | | where 1=1 |
| | | <if test="agentId != null and agentId != ''"> |