第三阶段

李林

2023-12-28 0545e868ee2c01615dec8e10746bf3699f8f6a2e

第三阶段

 data-server/src/main/java/com/yuanchu/mom/mapper/FinanceSubmitMapper.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,23 @@
package com.yuanchu.mom.mapper;

import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.yuanchu.mom.pojo.FansSubmit;
import com.yuanchu.mom.pojo.FinanceSubmit;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;

/**
* @author Administrator
* @description é’ˆå¯¹è¡¨ã€finance_submit】的数据库操作Mapper
* @createDate 2023-12-25 01:48:05
* @Entity com.yuanchu.mom.pojo.FinanceSubmit
*/
public interface FinanceSubmitMapper extends BaseMapper<FinanceSubmit> {

    IPage<FinanceSubmit> selectFinanceSubmitPageList(IPage<FinanceSubmit> page, QueryWrapper<FinanceSubmit> ew);

}





 data-server/src/main/java/com/yuanchu/mom/pojo/FinanceSubmit.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,113 @@
package com.yuanchu.mom.pojo;

import javax.validation.constraints.NotBlank;
import javax.validation.constraints.Size;
import javax.validation.constraints.NotNull;

import java.io.Serializable;

import java.math.BigDecimal;
import java.time.LocalDateTime;
import java.util.Date;

import com.baomidou.mybatisplus.annotation.*;
import com.fasterxml.jackson.annotation.JsonFormat;
import com.yuanchu.mom.annotation.ValueTableShow;
import io.swagger.annotations.ApiModelProperty;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
import org.hibernate.validator.constraints.Length;

/**
* 
* @TableName finance_submit
*/
@TableName(value ="finance_submit")
@Data
@AllArgsConstructor
@NoArgsConstructor
public class FinanceSubmit implements Serializable {

    /**
    * ä¸»é”®
    */
    @NotNull(message="[主键]不能为空")
    @ApiModelProperty("主键")
    @TableId(type = IdType.AUTO)
    private Integer id;
    /**
    * è´¦æˆ·å
    */
    @ValueTableShow
    @Size(max= 255,message="编码长度不能超过255")
    @ApiModelProperty("账户名")
    @Length(max= 255,message="编码长度不能超过255")
    private String name;
    /**
    * ä»£ç†å…¬å¸
    */
    @ValueTableShow
    @Size(max= 255,message="编码长度不能超过255")
    @ApiModelProperty("代理公司")
    @Length(max= 255,message="编码长度不能超过255")
    private String company;
    /**
    * æ¶ˆè´¹é‡‘额
    */
    @ValueTableShow
    @ApiModelProperty("消费金额")
    private BigDecimal consumption;
    /**
    * å……值金额
    */
    @ValueTableShow
    @ApiModelProperty("充值金额")
    private BigDecimal recharge;
    /**
    * é€€æ¬¾é‡‘额
    */
    @ValueTableShow
    @ApiModelProperty("退款金额")
    private BigDecimal refund;
    /**
    * ä»£ç†è¿”点
    */
    @ValueTableShow
    @ApiModelProperty("代理返点")
    private BigDecimal agentRebate;
    /**
     * åˆ›å»ºæ—¶é—´
     */
    @ApiModelProperty("登记时间")
    @TableField(fill = FieldFill.INSERT)
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    @ValueTableShow(6)
    private LocalDateTime createTime;
    /**
     *
     */
    @ApiModelProperty("系统时间")
    @ValueTableShow(0)
    @TableField(fill = FieldFill.INSERT_UPDATE)
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    private LocalDateTime updateTime;
    /**
     *
     */
    @ApiModelProperty("登记人id")
    @TableField(fill = FieldFill.INSERT)
    private Integer createUser;

    @ValueTableShow(5)
    @ApiModelProperty("登记人")
    private String createUserName;
    /**
     *
     */
    @ApiModelProperty("更新用户id")
    @TableField(fill = FieldFill.INSERT_UPDATE)
    private Integer updateUser;


}

 data-server/src/main/java/com/yuanchu/mom/service/FinanceSubmitService.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,25 @@
package com.yuanchu.mom.service;

import com.baomidou.mybatisplus.core.metadata.IPage;
import com.yuanchu.mom.pojo.FansSubmit;
import com.yuanchu.mom.pojo.FinanceSubmit;
import com.baomidou.mybatisplus.extension.service.IService;

import java.util.Map;

/**
* @author Administrator
* @description é’ˆå¯¹è¡¨ã€finance_submit】的数据库操作Service
* @createDate 2023-12-25 01:48:05
*/
public interface FinanceSubmitService extends IService<FinanceSubmit> {

    Map<String, Object> selectFinanceSubmitList(IPage<FinanceSubmit> page, FinanceSubmit financeSubmit);

    int delFinanceSubmit(Integer id);

    int updateFinanceSubmit(FinanceSubmit financeSubmit);

    int addFinanceSubmit(FinanceSubmit financeSubmit);

}

 data-server/src/main/java/com/yuanchu/mom/service/impl/FinanceSubmitServiceImpl.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,60 @@
package com.yuanchu.mom.service.impl;

import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.yuanchu.mom.common.GetLook;
import com.yuanchu.mom.common.PrintChina;
import com.yuanchu.mom.pojo.FansSubmit;
import com.yuanchu.mom.pojo.FinanceSubmit;
import com.yuanchu.mom.service.FinanceSubmitService;
import com.yuanchu.mom.mapper.FinanceSubmitMapper;
import com.yuanchu.mom.utils.QueryWrappers;
import lombok.AllArgsConstructor;
import org.springframework.stereotype.Service;

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

/**
* @author Administrator
* @description é’ˆå¯¹è¡¨ã€finance_submit】的数据库操作Service实现
* @createDate 2023-12-25 01:48:05
*/
@Service
@AllArgsConstructor
public class FinanceSubmitServiceImpl extends ServiceImpl<FinanceSubmitMapper, FinanceSubmit>
    implements FinanceSubmitService{

    private FinanceSubmitMapper financeSubmitMapper;

    private GetLook getLook;

    @Override
    public Map<String, Object> selectFinanceSubmitList(IPage<FinanceSubmit> page, FinanceSubmit financeSubmit) {
        Map<String, Object> map = new HashMap<>();
        map.put("head", PrintChina.printChina(FinanceSubmit.class));
        Map<String, Integer> map1 = getLook.selectPowerByMethodAndUserId("selectDataReportingList");
        if(map1.get("look")==1) financeSubmit.setCreateUser(map1.get("userId"));
        map.put("body", financeSubmitMapper.selectFinanceSubmitPageList(page, QueryWrappers.queryWrappers(financeSubmit)));
        return map;
    }

    @Override
    public int delFinanceSubmit(Integer id) {
        return financeSubmitMapper.deleteById(id);
    }

    @Override
    public int updateFinanceSubmit(FinanceSubmit financeSubmit) {
        return financeSubmitMapper.updateById(financeSubmit);
    }

    @Override
    public int addFinanceSubmit(FinanceSubmit financeSubmit) {
        return financeSubmitMapper.insert(financeSubmit);
    }
}





 data-server/src/main/resources/mapper/FinanceSubmitMapper.xml

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,30 @@
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.yuanchu.mom.mapper.FinanceSubmitMapper">

    <resultMap id="BaseResultMap" type="com.yuanchu.mom.pojo.FinanceSubmit">
            <id property="id" column="id" jdbcType="INTEGER"/>
            <result property="name" column="name" jdbcType="VARCHAR"/>
            <result property="company" column="company" jdbcType="VARCHAR"/>
            <result property="consumption" column="consumption" jdbcType="DECIMAL"/>
            <result property="recharge" column="recharge" jdbcType="DECIMAL"/>
            <result property="refund" column="refund" jdbcType="DECIMAL"/>
            <result property="agentRebate" column="agent_rebate" jdbcType="DECIMAL"/>
            <result property="createTime" column="create_time" jdbcType="TIMESTAMP"/>
            <result property="updateTime" column="update_time" jdbcType="TIMESTAMP"/>
            <result property="createUser" column="create_user" jdbcType="INTEGER"/>
            <result property="updateUser" column="update_user" jdbcType="INTEGER"/>
    </resultMap>

    <select id="selectFinanceSubmitPageList" resultType="com.yuanchu.mom.pojo.FinanceSubmit">
        select * from (
        select fs.*, u.name create_user_name from finance_submit fs, user u
        where fs.create_user = u.id
        ) a
        <if test="ew.customSqlSegment != null and ew.customSqlSegment != ''">
            ${ew.customSqlSegment}
        </if>
    </select>
</mapper>

 user-server/src/main/java/com/yuanchu/mom/mapper/PowerMapper.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,18 @@
package com.yuanchu.mom.mapper;

import com.yuanchu.mom.pojo.Power;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;

/**
* @author Administrator
* @description é’ˆå¯¹è¡¨ã€power(用户id)】的数据库操作Mapper
* @createDate 2023-12-27 02:37:38
* @Entity com.yuanchu.mom.pojo.Power
*/
public interface PowerMapper extends BaseMapper<Power> {

}





 user-server/src/main/java/com/yuanchu/mom/pojo/Menu.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,57 @@
package com.yuanchu.mom.pojo;

import javax.validation.constraints.NotBlank;
import javax.validation.constraints.Size;
import javax.validation.constraints.NotNull;

import java.io.Serializable;

import java.util.Date;

import com.fasterxml.jackson.annotation.JsonFormat;
import io.swagger.annotations.ApiModelProperty;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
import org.hibernate.validator.constraints.Length;

/**
* èœå•æƒé™
* @TableName menu
*/

@Data
@AllArgsConstructor
@NoArgsConstructor
public class Menu implements Serializable {

    /**
    * æ–¹æ³•å
    */
    @NotBlank(message="[方法名]不能为空")
    @Size(max= 150,message="编码长度不能超过150")
    @ApiModelProperty("方法名")
    @Length(max= 150,message="编码长度不能超过150")
    private String method;
    /**
    * æè¿°
    */
    @Size(max= 255,message="编码长度不能超过255")
    @ApiModelProperty("描述")
    @Length(max= 255,message="编码长度不能超过255")
    private String remark;
    /**
    * ç±»åž‹
    */
    @Size(max= 255,message="编码长度不能超过255")
    @ApiModelProperty("类型")
    @Length(max= 255,message="编码长度不能超过255")
    private String type;
    /**
    * åˆ›å»ºæ—¶é—´
    */
    @ApiModelProperty("创建时间")
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    private Date createTime;

}

 user-server/src/main/java/com/yuanchu/mom/pojo/Power.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,58 @@
package com.yuanchu.mom.pojo;

import com.baomidou.mybatisplus.annotation.*;

import java.io.Serializable;
import java.time.LocalDateTime;
import java.util.Date;

import com.fasterxml.jackson.annotation.JsonFormat;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;

/**
 * ç”¨æˆ·id
 * @TableName power
 */
@TableName(value ="power")
@Data
public class Power implements Serializable {
    /**
     * 
     */
    @TableId(type = IdType.AUTO)
    private Integer id;

    /**
     * è§’色id
     */
    private Integer roleId;

    /**
     * èœå•
     */
    private String menuMethod;

    /**
     * æ˜¯å¦åªæŸ¥çœ‹è‡ªå·±çš„数据 1：是；0：否
     */
    private Integer look = 0;

    /**
     * 
     */
    @ApiModelProperty(value = "创建日期")
    @TableField(fill = FieldFill.INSERT)
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    private LocalDateTime createTime;

    /**
     * 
     */
    @ApiModelProperty(value = "创建用户")
    @TableField(fill = FieldFill.INSERT)
    private Integer createUser;

    @TableField(exist = false)
    private static final long serialVersionUID = 1L;
}

 user-server/src/main/java/com/yuanchu/mom/service/PowerService.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,17 @@
package com.yuanchu.mom.service;

import com.yuanchu.mom.pojo.Power;
import com.baomidou.mybatisplus.extension.service.IService;

import java.util.List;

/**
* @author Administrator
* @description é’ˆå¯¹è¡¨ã€power(用户id)】的数据库操作Service
* @createDate 2023-12-27 02:37:38
*/
public interface PowerService extends IService<Power> {

    List<Power> selectPowerByRoleId(Integer roleId);

}

 user-server/src/main/java/com/yuanchu/mom/service/imp/PowerServiceImpl.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,40 @@
package com.yuanchu.mom.service.imp;

import cn.hutool.json.JSONUtil;
import com.baomidou.mybatisplus.core.toolkit.Wrappers;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.yuanchu.mom.mapper.UserMapper;
import com.yuanchu.mom.pojo.Power;
import com.yuanchu.mom.service.PowerService;
import com.yuanchu.mom.mapper.PowerMapper;
import com.yuanchu.mom.utils.Jwt;
import com.yuanchu.mom.utils.ServletUtils;
import lombok.AllArgsConstructor;
import org.springframework.stereotype.Service;

import java.util.List;

/**
* @author Administrator
* @description é’ˆå¯¹è¡¨ã€power(用户id)】的数据库操作Service实现
* @createDate 2023-12-27 02:37:38
*/
@Service
@AllArgsConstructor
public class PowerServiceImpl extends ServiceImpl<PowerMapper, Power>
    implements PowerService{

    private PowerMapper powerMapper;

    private UserMapper userMapper;

    @Override
    public List<Power> selectPowerByRoleId(Integer roleId) {
        return powerMapper.selectList(Wrappers.<Power>lambdaQuery().eq(Power::getRoleId, roleId));
    }

}





 user-server/src/main/resources/mapper/PowerMapper.xml

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,15 @@
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.yuanchu.mom.mapper.PowerMapper">

    <resultMap id="BaseResultMap" type="com.yuanchu.mom.pojo.Power">
            <id property="id" column="id" jdbcType="INTEGER"/>
            <result property="roleId" column="role_id" jdbcType="INTEGER"/>
            <result property="menuMethod" column="menu_method" jdbcType="VARCHAR"/>
            <result property="look" column="look" jdbcType="TINYINT"/>
            <result property="createTime" column="create_time" jdbcType="TIMESTAMP"/>
            <result property="createUser" column="create_user" jdbcType="INTEGER"/>
    </resultMap>
</mapper>