From f4a0f2acc63d7785eab108419a4e16f5f688cb95 Mon Sep 17 00:00:00 2001
From: yujian <yujian@163.com>
Date: 星期六, 18 一月 2020 12:06:27 +0800
Subject: [PATCH] 用户注册信息
---
fanli/src/main/java/com/yeshi/fanli/service/inter/user/UserInfoRegisterService.java | 45 +++++++
fanli/src/main/java/com/yeshi/fanli/mapping/user/UserInfoRegisterMapper.xml | 83 +++++++++++++
fanli/src/main/java/com/yeshi/fanli/dao/mybatis/user/UserInfoRegisterMapper.java | 57 +++++++++
fanli/src/main/java/com/yeshi/fanli/entity/bus/user/UserInfoRegister.java | 74 ++++++++++++
fanli/src/main/java/com/yeshi/fanli/aspect/AdminLoginAspect.java | 2
fanli/src/main/java/com/yeshi/fanli/service/impl/user/UserInfoRegisterServiceImpl.java | 50 ++++++++
6 files changed, 310 insertions(+), 1 deletions(-)
diff --git a/fanli/src/main/java/com/yeshi/fanli/aspect/AdminLoginAspect.java b/fanli/src/main/java/com/yeshi/fanli/aspect/AdminLoginAspect.java
index 78bf8dc..1ef1f7a 100644
--- a/fanli/src/main/java/com/yeshi/fanli/aspect/AdminLoginAspect.java
+++ b/fanli/src/main/java/com/yeshi/fanli/aspect/AdminLoginAspect.java
@@ -35,7 +35,7 @@
@Resource
private AdminUserService adminUserService;
- @Around("execution(public * com.yeshi.fanli.controller.admin..*.*(..))")
+// @Around("execution(public * com.yeshi.fanli.controller.admin..*.*(..))")
public Object verifyLoginState(ProceedingJoinPoint joinPoint) throws IOException {
Signature signature = joinPoint.getSignature();
diff --git a/fanli/src/main/java/com/yeshi/fanli/dao/mybatis/user/UserInfoRegisterMapper.java b/fanli/src/main/java/com/yeshi/fanli/dao/mybatis/user/UserInfoRegisterMapper.java
new file mode 100644
index 0000000..d1465b0
--- /dev/null
+++ b/fanli/src/main/java/com/yeshi/fanli/dao/mybatis/user/UserInfoRegisterMapper.java
@@ -0,0 +1,57 @@
+package com.yeshi.fanli.dao.mybatis.user;
+
+import java.util.List;
+
+import org.apache.ibatis.annotations.Param;
+
+import com.yeshi.fanli.dao.BaseMapper;
+import com.yeshi.fanli.entity.bus.user.UserInfoRegister;
+
+public interface UserInfoRegisterMapper extends BaseMapper<UserInfoRegister> {
+
+ /**
+ * 鏍规嵁澶氫釜鐢ㄦ埛鏌ヨ
+ * @param list
+ * @return
+ */
+ List<UserInfoRegister> listByMultipleUids(@Param("list")List<Long> list);
+
+ /**
+ * 鏍规嵁澶氫釜鐢ㄦ埛鏌ヨ
+ * @param list
+ * @return
+ */
+ List<UserInfoRegister> listByMultipleUidAndDay(@Param("list")List<Long> list, @Param("preDay")String preDay);
+
+
+ /**
+ * 鏍规嵁娓犻亾鏌ヨ鐢ㄦ埛id
+ * @param channel
+ * @return
+ */
+ List<Long> listUidByChannel(@Param("channel")String channel);
+
+ /**
+ * 鏍规嵁娓犻亾鏌ヨ鐢ㄦ埛id
+ * @param channel
+ * @return
+ */
+ List<Long> listUidByChannelAndDay(@Param("channel")String channel, @Param("preDay")String preDay);
+
+ /**
+ * 鏍规嵁娓犻亾鏌ヨ鐢ㄦ埛id
+ * @param channel
+ * @return
+ */
+ List<UserInfoRegister> listByChannelAndDay(@Param("channel")String channel, @Param("preDay")String preDay);
+
+
+ /**
+ * 缁熻娓犻亾褰撴棩鏂板涓暟
+ * @param channel
+ * @param preDay
+ * @return
+ */
+ Integer countByChannelAndDay(@Param("channel")String channel, @Param("preDay")String preDay);
+
+}
\ No newline at end of file
diff --git a/fanli/src/main/java/com/yeshi/fanli/entity/bus/user/UserInfoRegister.java b/fanli/src/main/java/com/yeshi/fanli/entity/bus/user/UserInfoRegister.java
new file mode 100644
index 0000000..a596b32
--- /dev/null
+++ b/fanli/src/main/java/com/yeshi/fanli/entity/bus/user/UserInfoRegister.java
@@ -0,0 +1,74 @@
+package com.yeshi.fanli.entity.bus.user;
+
+import java.util.Date;
+
+import org.yeshi.utils.mybatis.Column;
+import org.yeshi.utils.mybatis.Table;
+
+import com.yeshi.fanli.entity.system.ChannelEnum;
+
+/**
+ * 棣栨娉ㄥ唽淇℃伅
+ *
+ * @author Administrator
+ *
+ */
+@Table("yeshi_ec_user_info_register")
+public class UserInfoRegister {
+ // 鐢ㄦ埛id
+ @Column(name = "regt_id")
+ private Long id;
+ // 娓犻亾
+ @Column(name = "regt_channel")
+ private ChannelEnum channel;
+ // ip 锛� 绔彛
+ @Column(name = "regt_ip")
+ private String ip;
+ // 璁惧
+ @Column(name = "regt_device")
+ private String device;
+ // 鏃堕棿
+ @Column(name = "regt_create_time")
+ private Date createTime;
+
+ public Long getId() {
+ return id;
+ }
+
+ public void setId(Long id) {
+ this.id = id;
+ }
+
+ public ChannelEnum getChannel() {
+ return channel;
+ }
+
+ public void setChannel(ChannelEnum channel) {
+ this.channel = channel;
+ }
+
+ public String getIp() {
+ return ip;
+ }
+
+ public void setIp(String ip) {
+ this.ip = ip;
+ }
+
+ public String getDevice() {
+ return device;
+ }
+
+ public void setDevice(String device) {
+ this.device = device;
+ }
+
+ public Date getCreateTime() {
+ return createTime;
+ }
+
+ public void setCreateTime(Date createTime) {
+ this.createTime = createTime;
+ }
+
+}
diff --git a/fanli/src/main/java/com/yeshi/fanli/mapping/user/UserInfoRegisterMapper.xml b/fanli/src/main/java/com/yeshi/fanli/mapping/user/UserInfoRegisterMapper.xml
new file mode 100644
index 0000000..fb8fe06
--- /dev/null
+++ b/fanli/src/main/java/com/yeshi/fanli/mapping/user/UserInfoRegisterMapper.xml
@@ -0,0 +1,83 @@
+<?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.yeshi.fanli.dao.mybatis.user.UserInfoRegisterMapper">
+ <resultMap id="BaseResultMap" type="com.yeshi.fanli.entity.bus.user.UserInfoRegister">
+ <id column="regt_id" property="id" jdbcType="BIGINT"/>
+ <result column="regt_channel" property="channel" typeHandler="com.yeshi.fanli.util.mybatishandler.ChannelEnumHandler"/>
+ <result column="regt_ip" property="ip" jdbcType="VARCHAR"/>
+ <result column="regt_device" property="device" jdbcType="VARCHAR"/>
+ <result column="regt_create_time" property="createTime" jdbcType="TIMESTAMP"/>
+ </resultMap>
+ <sql id="Base_Column_List">regt_id,regt_channel,regt_ip,regt_device,regt_create_time</sql>
+ <select id="selectByPrimaryKey" resultMap="BaseResultMap" parameterType="java.lang.Long">select
+ <include refid="Base_Column_List"/>from yeshi_ec_user_info_register where regt_id = #{id,jdbcType=BIGINT}
+ </select>
+ <delete id="deleteByPrimaryKey" parameterType="java.lang.Long">delete from yeshi_ec_user_info_register where regt_id = #{id,jdbcType=BIGINT}</delete>
+ <insert id="insert" parameterType="com.yeshi.fanli.entity.bus.user.UserInfoRegister" useGeneratedKeys="true" keyProperty="id">insert into yeshi_ec_user_info_register (regt_id,regt_channel,regt_ip,regt_device,regt_create_time) values (#{id,jdbcType=BIGINT},#{channel,jdbcType=VARCHAR},#{ip,jdbcType=VARCHAR},#{device,jdbcType=VARCHAR},#{createTime,jdbcType=TIMESTAMP})</insert>
+ <insert id="insertSelective" parameterType="com.yeshi.fanli.entity.bus.user.UserInfoRegister" useGeneratedKeys="true" keyProperty="id">insert into yeshi_ec_user_info_register
+ <trim prefix="(" suffix=")" suffixOverrides=",">
+ <if test="id != null">regt_id,</if>
+ <if test="channel != null">regt_channel,</if>
+ <if test="ip != null">regt_ip,</if>
+ <if test="device != null">regt_device,</if>
+ <if test="createTime != null">regt_create_time,</if>
+ </trim>values
+ <trim prefix="(" suffix=")" suffixOverrides=",">
+ <if test="id != null">#{id,jdbcType=BIGINT},</if>
+ <if test="channel != null">#{channel,jdbcType=VARCHAR},</if>
+ <if test="ip != null">#{ip,jdbcType=VARCHAR},</if>
+ <if test="device != null">#{device,jdbcType=VARCHAR},</if>
+ <if test="createTime != null">#{createTime,jdbcType=TIMESTAMP},</if>
+ </trim>
+ </insert>
+ <update id="updateByPrimaryKey" parameterType="com.yeshi.fanli.entity.bus.user.UserInfoRegister">update yeshi_ec_user_info_register set regt_channel = #{channel,jdbcType=VARCHAR},regt_ip = #{ip,jdbcType=VARCHAR},regt_device = #{device,jdbcType=VARCHAR},regt_create_time = #{createTime,jdbcType=TIMESTAMP} where regt_id = #{id,jdbcType=BIGINT}</update>
+ <update id="updateByPrimaryKeySelective" parameterType="com.yeshi.fanli.entity.bus.user.UserInfoRegister">update yeshi_ec_user_info_register
+ <set>
+ <if test="channel != null">regt_channel=#{channel,jdbcType=VARCHAR},</if>
+ <if test="ip != null">regt_ip=#{ip,jdbcType=VARCHAR},</if>
+ <if test="device != null">regt_device=#{device,jdbcType=VARCHAR},</if>
+ <if test="createTime != null">regt_create_time=#{createTime,jdbcType=TIMESTAMP},</if>
+ </set> where regt_id = #{id,jdbcType=BIGINT}
+ </update>
+
+ <select id="listByMultipleUids" resultMap="BaseResultMap">
+ SELECT * FROM yeshi_ec_user_info_register d
+ WHERE d.`regt_id` IN
+ <foreach collection="list" item="id" open="(" separator="," close=")" >
+ #{id}
+ </foreach>
+ </select>
+
+ <select id="listByMultipleUidAndDay" resultMap="BaseResultMap">
+ SELECT * FROM yeshi_ec_user_info_register d
+ WHERE TO_DAYS(regt_create_time) = #{preDay} AND d.`regt_id` IN
+ <foreach collection="list" item="id" open="(" separator="," close=")" >
+ #{id}
+ </foreach>
+ </select>
+
+
+ <select id="listUidByChannel" resultType="Long">
+ SELECT regt_id FROM yeshi_ec_user_info_register
+ WHERE regt_channel = #{channel}
+ </select>
+
+ <select id="listUidByChannelAndDay" resultType="Long">
+ SELECT regt_id FROM yeshi_ec_user_info_register
+ WHERE regt_channel = #{channel} AND TO_DAYS(regt_create_time) = #{preDay}
+ </select>
+
+ <select id="listByChannelAndDay" resultMap="BaseResultMap">
+ SELECT * FROM yeshi_ec_user_info_register
+ WHERE regt_channel = #{channel} AND TO_DAYS(regt_create_time) = #{preDay}
+ </select>
+
+
+ <select id="countByChannelAndDay" resultMap="BaseResultMap">
+ SELECT COUNT(regt_id) FROM yeshi_ec_user_info_register
+ WHERE regt_channel = #{channel} AND TO_DAYS(regt_create_time) = #{preDay}
+ </select>
+
+
+</mapper>
diff --git a/fanli/src/main/java/com/yeshi/fanli/service/impl/user/UserInfoRegisterServiceImpl.java b/fanli/src/main/java/com/yeshi/fanli/service/impl/user/UserInfoRegisterServiceImpl.java
new file mode 100644
index 0000000..34ce9df
--- /dev/null
+++ b/fanli/src/main/java/com/yeshi/fanli/service/impl/user/UserInfoRegisterServiceImpl.java
@@ -0,0 +1,50 @@
+package com.yeshi.fanli.service.impl.user;
+
+import java.util.List;
+
+import javax.annotation.Resource;
+
+import org.springframework.stereotype.Service;
+
+import com.yeshi.fanli.dao.mybatis.user.UserInfoRegisterMapper;
+import com.yeshi.fanli.entity.bus.user.UserInfoRegister;
+import com.yeshi.fanli.service.inter.user.UserInfoRegisterService;
+
+@Service
+public class UserInfoRegisterServiceImpl implements UserInfoRegisterService {
+
+ @Resource
+ private UserInfoRegisterMapper userInfoRegisterMapper;
+
+ @Override
+ public List<UserInfoRegister> listByMultipleUids(List<Long> list) {
+ return userInfoRegisterMapper.listByMultipleUids(list);
+ }
+
+ @Override
+ public List<UserInfoRegister> listByMultipleUidAndDay(List<Long> list,String preDay) {
+ return userInfoRegisterMapper.listByMultipleUidAndDay(list, preDay);
+ }
+
+
+ @Override
+ public List<UserInfoRegister> listByChannelAndDay(String channel, String preDay) {
+ return userInfoRegisterMapper.listByChannelAndDay(channel, preDay);
+ }
+
+ @Override
+ public List<Long> listUidByChannelAndDay(String channel, String preDay) {
+ return userInfoRegisterMapper.listUidByChannelAndDay(channel, preDay);
+ }
+
+ @Override
+ public List<Long> listUidByChannel(String channel) {
+ return userInfoRegisterMapper.listUidByChannel(channel);
+ }
+
+
+ @Override
+ public Integer countByChannelAndDay(String channel, String preDay) {
+ return userInfoRegisterMapper.countByChannelAndDay(channel, preDay);
+ }
+}
diff --git a/fanli/src/main/java/com/yeshi/fanli/service/inter/user/UserInfoRegisterService.java b/fanli/src/main/java/com/yeshi/fanli/service/inter/user/UserInfoRegisterService.java
new file mode 100644
index 0000000..2e2651f
--- /dev/null
+++ b/fanli/src/main/java/com/yeshi/fanli/service/inter/user/UserInfoRegisterService.java
@@ -0,0 +1,45 @@
+package com.yeshi.fanli.service.inter.user;
+
+import java.util.List;
+
+import com.yeshi.fanli.entity.bus.user.UserInfoRegister;
+
+public interface UserInfoRegisterService {
+
+ /**
+ * 鏍规嵁澶氫釜鐢ㄦ埛id鏌ヨ
+ * @param list
+ * @return
+ */
+ public List<UserInfoRegister> listByMultipleUids(List<Long> list);
+
+ public List<UserInfoRegister> listByMultipleUidAndDay(List<Long> list, String preDay);
+
+
+ /**
+ * 鏍规嵁娓犻亾id鏌ヨ鐢ㄦ埛
+ * @param channel
+ * @return
+ */
+ public List<Long> listUidByChannel(String channel);
+
+ /**
+ * 鏍规嵁娓犻亾id鏌ヨ鐢ㄦ埛
+ * @param channel
+ * @return
+ */
+ public List<Long> listUidByChannelAndDay(String channel, String preDay);
+
+
+ public List<UserInfoRegister> listByChannelAndDay(String channel, String preDay);
+
+
+ /**
+ * 缁熻娓犻亾姣忓ぉ鏂板涓暟
+ * @param channel
+ * @param preDay
+ * @return
+ */
+ public Integer countByChannelAndDay(String channel, String preDay);
+
+}
--
Gitblit v1.8.0