From 0545e868ee2c01615dec8e10746bf3699f8f6a2e Mon Sep 17 00:00:00 2001 From: 李林 <z1292839451@163.com> Date: 星期四, 28 十二月 2023 11:24:41 +0800 Subject: [PATCH] 第三阶段 --- user-server/src/main/java/com/yuanchu/mom/service/PowerService.java | 17 ++ user-server/src/main/java/com/yuanchu/mom/pojo/Power.java | 58 +++++++ data-server/src/main/java/com/yuanchu/mom/service/impl/FinanceSubmitServiceImpl.java | 60 +++++++ data-server/src/main/resources/mapper/FinanceSubmitMapper.xml | 30 +++ user-server/src/main/java/com/yuanchu/mom/mapper/PowerMapper.java | 18 ++ data-server/src/main/java/com/yuanchu/mom/mapper/FinanceSubmitMapper.java | 23 ++ user-server/src/main/java/com/yuanchu/mom/service/imp/PowerServiceImpl.java | 40 +++++ data-server/src/main/java/com/yuanchu/mom/service/FinanceSubmitService.java | 25 +++ user-server/src/main/resources/mapper/PowerMapper.xml | 15 + user-server/src/main/java/com/yuanchu/mom/pojo/Menu.java | 57 +++++++ data-server/src/main/java/com/yuanchu/mom/pojo/FinanceSubmit.java | 113 ++++++++++++++ 11 files changed, 456 insertions(+), 0 deletions(-) diff --git a/data-server/src/main/java/com/yuanchu/mom/mapper/FinanceSubmitMapper.java b/data-server/src/main/java/com/yuanchu/mom/mapper/FinanceSubmitMapper.java new file mode 100644 index 0000000..e97bebf --- /dev/null +++ b/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 閽堝琛ㄣ�恌inance_submit銆戠殑鏁版嵁搴撴搷浣淢apper +* @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); + +} + + + + diff --git a/data-server/src/main/java/com/yuanchu/mom/pojo/FinanceSubmit.java b/data-server/src/main/java/com/yuanchu/mom/pojo/FinanceSubmit.java new file mode 100644 index 0000000..cd5080b --- /dev/null +++ b/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; + /** + * 浠g悊鍏徃 + */ + @ValueTableShow + @Size(max= 255,message="缂栫爜闀垮害涓嶈兘瓒呰繃255") + @ApiModelProperty("浠g悊鍏徃") + @Length(max= 255,message="缂栫爜闀垮害涓嶈兘瓒呰繃255") + private String company; + /** + * 娑堣垂閲戦 + */ + @ValueTableShow + @ApiModelProperty("娑堣垂閲戦") + private BigDecimal consumption; + /** + * 鍏呭�奸噾棰� + */ + @ValueTableShow + @ApiModelProperty("鍏呭�奸噾棰�") + private BigDecimal recharge; + /** + * 閫�娆鹃噾棰� + */ + @ValueTableShow + @ApiModelProperty("閫�娆鹃噾棰�") + private BigDecimal refund; + /** + * 浠g悊杩旂偣 + */ + @ValueTableShow + @ApiModelProperty("浠g悊杩旂偣") + 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("鐧昏浜篿d") + @TableField(fill = FieldFill.INSERT) + private Integer createUser; + + @ValueTableShow(5) + @ApiModelProperty("鐧昏浜�") + private String createUserName; + /** + * + */ + @ApiModelProperty("鏇存柊鐢ㄦ埛id") + @TableField(fill = FieldFill.INSERT_UPDATE) + private Integer updateUser; + + +} diff --git a/data-server/src/main/java/com/yuanchu/mom/service/FinanceSubmitService.java b/data-server/src/main/java/com/yuanchu/mom/service/FinanceSubmitService.java new file mode 100644 index 0000000..b730773 --- /dev/null +++ b/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 閽堝琛ㄣ�恌inance_submit銆戠殑鏁版嵁搴撴搷浣淪ervice +* @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); + +} diff --git a/data-server/src/main/java/com/yuanchu/mom/service/impl/FinanceSubmitServiceImpl.java b/data-server/src/main/java/com/yuanchu/mom/service/impl/FinanceSubmitServiceImpl.java new file mode 100644 index 0000000..fcbf884 --- /dev/null +++ b/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 閽堝琛ㄣ�恌inance_submit銆戠殑鏁版嵁搴撴搷浣淪ervice瀹炵幇 +* @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); + } +} + + + + diff --git a/data-server/src/main/resources/mapper/FinanceSubmitMapper.xml b/data-server/src/main/resources/mapper/FinanceSubmitMapper.xml new file mode 100644 index 0000000..e811df5 --- /dev/null +++ b/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> diff --git a/user-server/src/main/java/com/yuanchu/mom/mapper/PowerMapper.java b/user-server/src/main/java/com/yuanchu/mom/mapper/PowerMapper.java new file mode 100644 index 0000000..c2cbfe3 --- /dev/null +++ b/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 閽堝琛ㄣ�恜ower(鐢ㄦ埛id)銆戠殑鏁版嵁搴撴搷浣淢apper +* @createDate 2023-12-27 02:37:38 +* @Entity com.yuanchu.mom.pojo.Power +*/ +public interface PowerMapper extends BaseMapper<Power> { + +} + + + + diff --git a/user-server/src/main/java/com/yuanchu/mom/pojo/Menu.java b/user-server/src/main/java/com/yuanchu/mom/pojo/Menu.java new file mode 100644 index 0000000..e130837 --- /dev/null +++ b/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; + +} diff --git a/user-server/src/main/java/com/yuanchu/mom/pojo/Power.java b/user-server/src/main/java/com/yuanchu/mom/pojo/Power.java new file mode 100644 index 0000000..1dbadbb --- /dev/null +++ b/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; +} \ No newline at end of file diff --git a/user-server/src/main/java/com/yuanchu/mom/service/PowerService.java b/user-server/src/main/java/com/yuanchu/mom/service/PowerService.java new file mode 100644 index 0000000..5de900d --- /dev/null +++ b/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 閽堝琛ㄣ�恜ower(鐢ㄦ埛id)銆戠殑鏁版嵁搴撴搷浣淪ervice +* @createDate 2023-12-27 02:37:38 +*/ +public interface PowerService extends IService<Power> { + + List<Power> selectPowerByRoleId(Integer roleId); + +} diff --git a/user-server/src/main/java/com/yuanchu/mom/service/imp/PowerServiceImpl.java b/user-server/src/main/java/com/yuanchu/mom/service/imp/PowerServiceImpl.java new file mode 100644 index 0000000..f33391f --- /dev/null +++ b/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 閽堝琛ㄣ�恜ower(鐢ㄦ埛id)銆戠殑鏁版嵁搴撴搷浣淪ervice瀹炵幇 +* @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)); + } + +} + + + + diff --git a/user-server/src/main/resources/mapper/PowerMapper.xml b/user-server/src/main/resources/mapper/PowerMapper.xml new file mode 100644 index 0000000..e87e79e --- /dev/null +++ b/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> -- Gitblit v1.9.3