From bcab92b6a0c336ebee4f71f2762489a4c9172523 Mon Sep 17 00:00:00 2001
From: 无关风月 <443237572@qq.com>
Date: 星期一, 17 六月 2024 11:21:06 +0800
Subject: [PATCH] 提交mapper
---
ruoyi-service/ruoyi-management/src/main/resources/mapper/management/SysDictTypeMapper.xml | 23 +
ruoyi-service/ruoyi-management/src/main/resources/mapper/management/SysOperationLogMapper.xml | 23 +
ruoyi-service/ruoyi-management/src/main/resources/mapper/management/SysRoleDeptMapper.xml | 16 +
ruoyi-service/ruoyi-management/src/main/resources/mapper/management/SysMenuMapper.xml | 33 ++
ruoyi-service/ruoyi-management/src/main/resources/mapper/management/SysRoleMapper.xml | 32 ++
ruoyi-service/ruoyi-management/src/main/resources/mapper/management/SysUserRoleMapper.xml | 16 +
ruoyi-service/ruoyi-management/src/main/resources/mapper/management/TUserMapper.xml | 30 ++
ruoyi-service/ruoyi-management/src/main/resources/mapper/management/SysJobMapper.xml | 27 ++
ruoyi-service/ruoyi-management/src/main/resources/mapper/management/TPageMapper.xml | 17 +
ruoyi-service/ruoyi-management/src/main/resources/mapper/management/TOrderMapper.xml | 26 ++
ruoyi-service/ruoyi-management/src/main/resources/mapper/management/SysExpenseMapper.xml | 21 +
ruoyi-service/ruoyi-management/src/main/resources/mapper/management/TGoodsTypeMapper.xml | 17 +
ruoyi-service/ruoyi-management/src/main/resources/mapper/management/SysUserPostMapper.xml | 16 +
ruoyi-service/ruoyi-management/src/main/resources/mapper/management/TVipSetMapper.xml | 18 +
ruoyi-service/ruoyi-management/src/main/resources/mapper/management/TUseGuideMapper.xml | 37 +++
ruoyi-service/ruoyi-management/src/main/resources/mapper/management/TSysSetMapper.xml | 7
ruoyi-service/ruoyi-management/src/main/resources/mapper/management/SysNoticeMapper.xml | 24 ++
ruoyi-service/ruoyi-management/src/main/resources/mapper/management/TFeedbackMapper.xml | 39 +++
ruoyi-service/ruoyi-management/src/main/resources/mapper/management/SysPostMapper.xml | 24 ++
ruoyi-service/ruoyi-management/src/main/resources/mapper/management/SysLoginLogMapper.xml | 21 +
ruoyi-service/ruoyi-management/src/main/resources/mapper/management/SysJobLogMapper.xml | 22 +
ruoyi-service/ruoyi-management/src/main/resources/mapper/management/SysDeptMapper.xml | 36 +++
ruoyi-service/ruoyi-management/src/main/resources/mapper/management/SysUserMapper.xml | 36 +++
ruoyi-service/ruoyi-management/src/main/resources/mapper/management/SysDictDataMapper.xml | 28 ++
ruoyi-service/ruoyi-management/src/main/resources/mapper/management/SysLogininforMapper.xml | 20 +
ruoyi-service/ruoyi-management/src/main/resources/mapper/management/TGoodsMapper.xml | 28 ++
ruoyi-service/ruoyi-management/src/main/resources/mapper/management/SysRelationMapper.xml | 17 +
ruoyi-service/ruoyi-management/src/main/resources/mapper/management/TProtocolMapper.xml | 18 +
ruoyi-service/ruoyi-management/src/main/resources/mapper/management/SysDictMapper.xml | 20 +
ruoyi-service/ruoyi-management/src/main/resources/mapper/management/SysRoleMenuMapper.xml | 16 +
30 files changed, 708 insertions(+), 0 deletions(-)
diff --git a/ruoyi-service/ruoyi-management/src/main/resources/mapper/management/SysDeptMapper.xml b/ruoyi-service/ruoyi-management/src/main/resources/mapper/management/SysDeptMapper.xml
new file mode 100644
index 0000000..18739dc
--- /dev/null
+++ b/ruoyi-service/ruoyi-management/src/main/resources/mapper/management/SysDeptMapper.xml
@@ -0,0 +1,36 @@
+<?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.ruoyi.management.mapper.SysDeptMapper">
+
+ <!-- 通用查询映射结果 -->
+ <resultMap id="BaseResultMap" type="com.ruoyi.management.domain.SysDept">
+ <id column="dept_id" property="deptId" />
+ <result column="parent_id" property="parentId" />
+ <result column="ancestors" property="ancestors" />
+ <result column="dept_name" property="deptName" />
+ <result column="order_num" property="orderNum" />
+ <result column="leader" property="leader" />
+ <result column="phone" property="phone" />
+ <result column="email" property="email" />
+ <result column="status" property="status" />
+ <result column="del_flag" property="delFlag" />
+ <result column="create_by" property="createBy" />
+ <result column="create_time" property="createTime" />
+ <result column="update_by" property="updateBy" />
+ <result column="update_time" property="updateTime" />
+ </resultMap>
+
+ <!-- 通用查询结果列 -->
+ <sql id="Base_Column_List">
+ dept_id, parent_id, ancestors, dept_name, order_num, leader, phone, email, status, del_flag, create_by, create_time, update_by, update_time
+ </sql>
+ <select id="getList" resultType="com.ruoyi.management.domain.SysDept">
+ select t1.* from sys_dept t1
+ where 1=1
+ <if test="null != req.deptName and '' != req.deptName">
+ and t1.dept_name like CONCAT('%', #{req.deptName}, '%')
+ </if>
+ order by t1.create_time desc
+ </select>
+
+</mapper>
diff --git a/ruoyi-service/ruoyi-management/src/main/resources/mapper/management/SysDictDataMapper.xml b/ruoyi-service/ruoyi-management/src/main/resources/mapper/management/SysDictDataMapper.xml
new file mode 100644
index 0000000..0e3a377
--- /dev/null
+++ b/ruoyi-service/ruoyi-management/src/main/resources/mapper/management/SysDictDataMapper.xml
@@ -0,0 +1,28 @@
+<?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.ruoyi.management.mapper.SysDictDataMapper">
+
+ <!-- 通用查询映射结果 -->
+ <resultMap id="BaseResultMap" type="com.ruoyi.management.domain.SysDictData">
+ <id column="dict_code" property="dictCode" />
+ <result column="dict_sort" property="dictSort" />
+ <result column="dict_label" property="dictLabel" />
+ <result column="dict_value" property="dictValue" />
+ <result column="dict_type" property="dictType" />
+ <result column="css_class" property="cssClass" />
+ <result column="list_class" property="listClass" />
+ <result column="is_default" property="isDefault" />
+ <result column="status" property="status" />
+ <result column="create_by" property="createBy" />
+ <result column="create_time" property="createTime" />
+ <result column="update_by" property="updateBy" />
+ <result column="update_time" property="updateTime" />
+ <result column="remark" property="remark" />
+ </resultMap>
+
+ <!-- 通用查询结果列 -->
+ <sql id="Base_Column_List">
+ dict_code, dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark
+ </sql>
+
+</mapper>
diff --git a/ruoyi-service/ruoyi-management/src/main/resources/mapper/management/SysDictMapper.xml b/ruoyi-service/ruoyi-management/src/main/resources/mapper/management/SysDictMapper.xml
new file mode 100644
index 0000000..03659aa
--- /dev/null
+++ b/ruoyi-service/ruoyi-management/src/main/resources/mapper/management/SysDictMapper.xml
@@ -0,0 +1,20 @@
+<?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.ruoyi.management.mapper.SysDictMapper">
+
+ <!-- 通用查询映射结果 -->
+ <resultMap id="BaseResultMap" type="com.ruoyi.management.domain.SysDict">
+ <id column="id" property="id" />
+ <result column="num" property="num" />
+ <result column="pid" property="pid" />
+ <result column="name" property="name" />
+ <result column="tips" property="tips" />
+ <result column="code" property="code" />
+ </resultMap>
+
+ <!-- 通用查询结果列 -->
+ <sql id="Base_Column_List">
+ id, num, pid, name, tips, code
+ </sql>
+
+</mapper>
diff --git a/ruoyi-service/ruoyi-management/src/main/resources/mapper/management/SysDictTypeMapper.xml b/ruoyi-service/ruoyi-management/src/main/resources/mapper/management/SysDictTypeMapper.xml
new file mode 100644
index 0000000..b098ccc
--- /dev/null
+++ b/ruoyi-service/ruoyi-management/src/main/resources/mapper/management/SysDictTypeMapper.xml
@@ -0,0 +1,23 @@
+<?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.ruoyi.management.mapper.SysDictTypeMapper">
+
+ <!-- 通用查询映射结果 -->
+ <resultMap id="BaseResultMap" type="com.ruoyi.management.domain.SysDictType">
+ <id column="dict_id" property="dictId" />
+ <result column="dict_name" property="dictName" />
+ <result column="dict_type" property="dictType" />
+ <result column="status" property="status" />
+ <result column="create_by" property="createBy" />
+ <result column="create_time" property="createTime" />
+ <result column="update_by" property="updateBy" />
+ <result column="update_time" property="updateTime" />
+ <result column="remark" property="remark" />
+ </resultMap>
+
+ <!-- 通用查询结果列 -->
+ <sql id="Base_Column_List">
+ dict_id, dict_name, dict_type, status, create_by, create_time, update_by, update_time, remark
+ </sql>
+
+</mapper>
diff --git a/ruoyi-service/ruoyi-management/src/main/resources/mapper/management/SysExpenseMapper.xml b/ruoyi-service/ruoyi-management/src/main/resources/mapper/management/SysExpenseMapper.xml
new file mode 100644
index 0000000..922bc65
--- /dev/null
+++ b/ruoyi-service/ruoyi-management/src/main/resources/mapper/management/SysExpenseMapper.xml
@@ -0,0 +1,21 @@
+<?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.ruoyi.management.mapper.SysExpenseMapper">
+
+ <!-- 通用查询映射结果 -->
+ <resultMap id="BaseResultMap" type="com.ruoyi.management.domain.SysExpense">
+ <id column="id" property="id" />
+ <result column="money" property="money" />
+ <result column="desc" property="desc" />
+ <result column="createtime" property="createtime" />
+ <result column="state" property="state" />
+ <result column="userid" property="userid" />
+ <result column="processId" property="processId" />
+ </resultMap>
+
+ <!-- 通用查询结果列 -->
+ <sql id="Base_Column_List">
+ id, money, desc, createtime, state, userid, processId
+ </sql>
+
+</mapper>
diff --git a/ruoyi-service/ruoyi-management/src/main/resources/mapper/management/SysJobLogMapper.xml b/ruoyi-service/ruoyi-management/src/main/resources/mapper/management/SysJobLogMapper.xml
new file mode 100644
index 0000000..db4e91f
--- /dev/null
+++ b/ruoyi-service/ruoyi-management/src/main/resources/mapper/management/SysJobLogMapper.xml
@@ -0,0 +1,22 @@
+<?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.ruoyi.management.mapper.SysJobLogMapper">
+
+ <!-- 通用查询映射结果 -->
+ <resultMap id="BaseResultMap" type="com.ruoyi.management.domain.SysJobLog">
+ <id column="job_log_id" property="jobLogId" />
+ <result column="job_name" property="jobName" />
+ <result column="job_group" property="jobGroup" />
+ <result column="invoke_target" property="invokeTarget" />
+ <result column="job_message" property="jobMessage" />
+ <result column="status" property="status" />
+ <result column="exception_info" property="exceptionInfo" />
+ <result column="create_time" property="createTime" />
+ </resultMap>
+
+ <!-- 通用查询结果列 -->
+ <sql id="Base_Column_List">
+ job_log_id, job_name, job_group, invoke_target, job_message, status, exception_info, create_time
+ </sql>
+
+</mapper>
diff --git a/ruoyi-service/ruoyi-management/src/main/resources/mapper/management/SysJobMapper.xml b/ruoyi-service/ruoyi-management/src/main/resources/mapper/management/SysJobMapper.xml
new file mode 100644
index 0000000..0890f3f
--- /dev/null
+++ b/ruoyi-service/ruoyi-management/src/main/resources/mapper/management/SysJobMapper.xml
@@ -0,0 +1,27 @@
+<?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.ruoyi.management.mapper.SysJobMapper">
+
+ <!-- 通用查询映射结果 -->
+ <resultMap id="BaseResultMap" type="com.ruoyi.management.domain.SysJob">
+ <id column="job_id" property="jobId" />
+ <result column="job_name" property="jobName" />
+ <result column="job_group" property="jobGroup" />
+ <result column="invoke_target" property="invokeTarget" />
+ <result column="cron_expression" property="cronExpression" />
+ <result column="misfire_policy" property="misfirePolicy" />
+ <result column="concurrent" property="concurrent" />
+ <result column="status" property="status" />
+ <result column="create_by" property="createBy" />
+ <result column="create_time" property="createTime" />
+ <result column="update_by" property="updateBy" />
+ <result column="update_time" property="updateTime" />
+ <result column="remark" property="remark" />
+ </resultMap>
+
+ <!-- 通用查询结果列 -->
+ <sql id="Base_Column_List">
+ job_id, job_name, job_group, invoke_target, cron_expression, misfire_policy, concurrent, status, create_by, create_time, update_by, update_time, remark
+ </sql>
+
+</mapper>
diff --git a/ruoyi-service/ruoyi-management/src/main/resources/mapper/management/SysLoginLogMapper.xml b/ruoyi-service/ruoyi-management/src/main/resources/mapper/management/SysLoginLogMapper.xml
new file mode 100644
index 0000000..e76f9d4
--- /dev/null
+++ b/ruoyi-service/ruoyi-management/src/main/resources/mapper/management/SysLoginLogMapper.xml
@@ -0,0 +1,21 @@
+<?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.ruoyi.management.mapper.SysLoginLogMapper">
+
+ <!-- 通用查询映射结果 -->
+ <resultMap id="BaseResultMap" type="com.ruoyi.management.domain.SysLoginLog">
+ <id column="id" property="id" />
+ <result column="logname" property="logname" />
+ <result column="userid" property="userid" />
+ <result column="createtime" property="createtime" />
+ <result column="succeed" property="succeed" />
+ <result column="message" property="message" />
+ <result column="ip" property="ip" />
+ </resultMap>
+
+ <!-- 通用查询结果列 -->
+ <sql id="Base_Column_List">
+ id, logname, userid, createtime, succeed, message, ip
+ </sql>
+
+</mapper>
diff --git a/ruoyi-service/ruoyi-management/src/main/resources/mapper/management/SysLogininforMapper.xml b/ruoyi-service/ruoyi-management/src/main/resources/mapper/management/SysLogininforMapper.xml
new file mode 100644
index 0000000..dd6dccb
--- /dev/null
+++ b/ruoyi-service/ruoyi-management/src/main/resources/mapper/management/SysLogininforMapper.xml
@@ -0,0 +1,20 @@
+<?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.ruoyi.management.mapper.SysLogininforMapper">
+
+ <!-- 通用查询映射结果 -->
+ <resultMap id="BaseResultMap" type="com.ruoyi.management.domain.SysLogininfor">
+ <id column="info_id" property="infoId" />
+ <result column="user_name" property="userName" />
+ <result column="ipaddr" property="ipaddr" />
+ <result column="status" property="status" />
+ <result column="msg" property="msg" />
+ <result column="access_time" property="accessTime" />
+ </resultMap>
+
+ <!-- 通用查询结果列 -->
+ <sql id="Base_Column_List">
+ info_id, user_name, ipaddr, status, msg, access_time
+ </sql>
+
+</mapper>
diff --git a/ruoyi-service/ruoyi-management/src/main/resources/mapper/management/SysMenuMapper.xml b/ruoyi-service/ruoyi-management/src/main/resources/mapper/management/SysMenuMapper.xml
new file mode 100644
index 0000000..53d4fef
--- /dev/null
+++ b/ruoyi-service/ruoyi-management/src/main/resources/mapper/management/SysMenuMapper.xml
@@ -0,0 +1,33 @@
+<?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.ruoyi.management.mapper.SysMenuMapper">
+
+ <!-- 通用查询映射结果 -->
+ <resultMap id="BaseResultMap" type="com.ruoyi.management.domain.SysMenu">
+ <id column="menu_id" property="menuId" />
+ <result column="menu_name" property="menuName" />
+ <result column="parent_id" property="parentId" />
+ <result column="order_num" property="orderNum" />
+ <result column="path" property="path" />
+ <result column="component" property="component" />
+ <result column="query" property="query" />
+ <result column="is_frame" property="isFrame" />
+ <result column="is_cache" property="isCache" />
+ <result column="menu_type" property="menuType" />
+ <result column="visible" property="visible" />
+ <result column="status" property="status" />
+ <result column="perms" property="perms" />
+ <result column="icon" property="icon" />
+ <result column="create_by" property="createBy" />
+ <result column="create_time" property="createTime" />
+ <result column="update_by" property="updateBy" />
+ <result column="update_time" property="updateTime" />
+ <result column="remark" property="remark" />
+ </resultMap>
+
+ <!-- 通用查询结果列 -->
+ <sql id="Base_Column_List">
+ menu_id, menu_name, parent_id, order_num, path, component, query, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark
+ </sql>
+
+</mapper>
diff --git a/ruoyi-service/ruoyi-management/src/main/resources/mapper/management/SysNoticeMapper.xml b/ruoyi-service/ruoyi-management/src/main/resources/mapper/management/SysNoticeMapper.xml
new file mode 100644
index 0000000..906c41c
--- /dev/null
+++ b/ruoyi-service/ruoyi-management/src/main/resources/mapper/management/SysNoticeMapper.xml
@@ -0,0 +1,24 @@
+<?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.ruoyi.management.mapper.SysNoticeMapper">
+
+ <!-- 通用查询映射结果 -->
+ <resultMap id="BaseResultMap" type="com.ruoyi.management.domain.SysNotice">
+ <id column="notice_id" property="noticeId" />
+ <result column="notice_title" property="noticeTitle" />
+ <result column="notice_type" property="noticeType" />
+ <result column="notice_content" property="noticeContent" />
+ <result column="status" property="status" />
+ <result column="create_by" property="createBy" />
+ <result column="create_time" property="createTime" />
+ <result column="update_by" property="updateBy" />
+ <result column="update_time" property="updateTime" />
+ <result column="remark" property="remark" />
+ </resultMap>
+
+ <!-- 通用查询结果列 -->
+ <sql id="Base_Column_List">
+ notice_id, notice_title, notice_type, notice_content, status, create_by, create_time, update_by, update_time, remark
+ </sql>
+
+</mapper>
diff --git a/ruoyi-service/ruoyi-management/src/main/resources/mapper/management/SysOperationLogMapper.xml b/ruoyi-service/ruoyi-management/src/main/resources/mapper/management/SysOperationLogMapper.xml
new file mode 100644
index 0000000..1ce7d5d
--- /dev/null
+++ b/ruoyi-service/ruoyi-management/src/main/resources/mapper/management/SysOperationLogMapper.xml
@@ -0,0 +1,23 @@
+<?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.ruoyi.management.mapper.SysOperationLogMapper">
+
+ <!-- 通用查询映射结果 -->
+ <resultMap id="BaseResultMap" type="com.ruoyi.management.domain.SysOperationLog">
+ <id column="id" property="id" />
+ <result column="logtype" property="logtype" />
+ <result column="logname" property="logname" />
+ <result column="userid" property="userid" />
+ <result column="classname" property="classname" />
+ <result column="method" property="method" />
+ <result column="createtime" property="createtime" />
+ <result column="succeed" property="succeed" />
+ <result column="message" property="message" />
+ </resultMap>
+
+ <!-- 通用查询结果列 -->
+ <sql id="Base_Column_List">
+ id, logtype, logname, userid, classname, method, createtime, succeed, message
+ </sql>
+
+</mapper>
diff --git a/ruoyi-service/ruoyi-management/src/main/resources/mapper/management/SysPostMapper.xml b/ruoyi-service/ruoyi-management/src/main/resources/mapper/management/SysPostMapper.xml
new file mode 100644
index 0000000..dd6589e
--- /dev/null
+++ b/ruoyi-service/ruoyi-management/src/main/resources/mapper/management/SysPostMapper.xml
@@ -0,0 +1,24 @@
+<?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.ruoyi.management.mapper.SysPostMapper">
+
+ <!-- 通用查询映射结果 -->
+ <resultMap id="BaseResultMap" type="com.ruoyi.management.domain.SysPost">
+ <id column="post_id" property="postId" />
+ <result column="post_code" property="postCode" />
+ <result column="post_name" property="postName" />
+ <result column="post_sort" property="postSort" />
+ <result column="status" property="status" />
+ <result column="create_by" property="createBy" />
+ <result column="create_time" property="createTime" />
+ <result column="update_by" property="updateBy" />
+ <result column="update_time" property="updateTime" />
+ <result column="remark" property="remark" />
+ </resultMap>
+
+ <!-- 通用查询结果列 -->
+ <sql id="Base_Column_List">
+ post_id, post_code, post_name, post_sort, status, create_by, create_time, update_by, update_time, remark
+ </sql>
+
+</mapper>
diff --git a/ruoyi-service/ruoyi-management/src/main/resources/mapper/management/SysRelationMapper.xml b/ruoyi-service/ruoyi-management/src/main/resources/mapper/management/SysRelationMapper.xml
new file mode 100644
index 0000000..d2b295c
--- /dev/null
+++ b/ruoyi-service/ruoyi-management/src/main/resources/mapper/management/SysRelationMapper.xml
@@ -0,0 +1,17 @@
+<?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.ruoyi.management.mapper.SysRelationMapper">
+
+ <!-- 通用查询映射结果 -->
+ <resultMap id="BaseResultMap" type="com.ruoyi.management.domain.SysRelation">
+ <id column="id" property="id" />
+ <result column="menuid" property="menuid" />
+ <result column="roleid" property="roleid" />
+ </resultMap>
+
+ <!-- 通用查询结果列 -->
+ <sql id="Base_Column_List">
+ id, menuid, roleid
+ </sql>
+
+</mapper>
diff --git a/ruoyi-service/ruoyi-management/src/main/resources/mapper/management/SysRoleDeptMapper.xml b/ruoyi-service/ruoyi-management/src/main/resources/mapper/management/SysRoleDeptMapper.xml
new file mode 100644
index 0000000..fa44855
--- /dev/null
+++ b/ruoyi-service/ruoyi-management/src/main/resources/mapper/management/SysRoleDeptMapper.xml
@@ -0,0 +1,16 @@
+<?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.ruoyi.management.mapper.SysRoleDeptMapper">
+
+ <!-- 通用查询映射结果 -->
+ <resultMap id="BaseResultMap" type="com.ruoyi.management.domain.SysRoleDept">
+ <id column="role_id" property="roleId" />
+ <result column="dept_id" property="deptId" />
+ </resultMap>
+
+ <!-- 通用查询结果列 -->
+ <sql id="Base_Column_List">
+ role_id, dept_id
+ </sql>
+
+</mapper>
diff --git a/ruoyi-service/ruoyi-management/src/main/resources/mapper/management/SysRoleMapper.xml b/ruoyi-service/ruoyi-management/src/main/resources/mapper/management/SysRoleMapper.xml
new file mode 100644
index 0000000..74fa832
--- /dev/null
+++ b/ruoyi-service/ruoyi-management/src/main/resources/mapper/management/SysRoleMapper.xml
@@ -0,0 +1,32 @@
+<?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.ruoyi.management.mapper.SysRoleMapper">
+
+ <!-- 通用查询映射结果 -->
+ <resultMap id="BaseResultMap" type="com.ruoyi.management.domain.SysRole">
+ <id column="role_id" property="roleId" />
+ <result column="role_name" property="roleName" />
+ <result column="role_key" property="roleKey" />
+ <result column="role_sort" property="roleSort" />
+ <result column="data_scope" property="dataScope" />
+ <result column="menu_check_strictly" property="menuCheckStrictly" />
+ <result column="dept_check_strictly" property="deptCheckStrictly" />
+ <result column="status" property="status" />
+ <result column="del_flag" property="delFlag" />
+ <result column="create_by" property="createBy" />
+ <result column="create_time" property="createTime" />
+ <result column="update_by" property="updateBy" />
+ <result column="update_time" property="updateTime" />
+ <result column="remark" property="remark" />
+ <result column="carDataAuth" property="carDataAuth" />
+ <result column="carTrainOperAuth" property="carTrainOperAuth" />
+ <result column="contractDataAuth" property="contractDataAuth" />
+ <result column="companyId" property="companyId" />
+ </resultMap>
+
+ <!-- 通用查询结果列 -->
+ <sql id="Base_Column_List">
+ role_id, role_name, role_key, role_sort, data_scope, menu_check_strictly, dept_check_strictly, status, del_flag, create_by, create_time, update_by, update_time, remark, carDataAuth, carTrainOperAuth, contractDataAuth, companyId
+ </sql>
+
+</mapper>
diff --git a/ruoyi-service/ruoyi-management/src/main/resources/mapper/management/SysRoleMenuMapper.xml b/ruoyi-service/ruoyi-management/src/main/resources/mapper/management/SysRoleMenuMapper.xml
new file mode 100644
index 0000000..0d20ddb
--- /dev/null
+++ b/ruoyi-service/ruoyi-management/src/main/resources/mapper/management/SysRoleMenuMapper.xml
@@ -0,0 +1,16 @@
+<?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.ruoyi.management.mapper.SysRoleMenuMapper">
+
+ <!-- 通用查询映射结果 -->
+ <resultMap id="BaseResultMap" type="com.ruoyi.management.domain.SysRoleMenu">
+ <id column="role_id" property="roleId" />
+ <result column="menu_id" property="menuId" />
+ </resultMap>
+
+ <!-- 通用查询结果列 -->
+ <sql id="Base_Column_List">
+ role_id, menu_id
+ </sql>
+
+</mapper>
diff --git a/ruoyi-service/ruoyi-management/src/main/resources/mapper/management/SysUserMapper.xml b/ruoyi-service/ruoyi-management/src/main/resources/mapper/management/SysUserMapper.xml
new file mode 100644
index 0000000..eb8c026
--- /dev/null
+++ b/ruoyi-service/ruoyi-management/src/main/resources/mapper/management/SysUserMapper.xml
@@ -0,0 +1,36 @@
+<?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.ruoyi.management.mapper.SysUserMapper">
+
+ <!-- 通用查询映射结果 -->
+ <resultMap id="BaseResultMap" type="com.ruoyi.management.domain.SysUser">
+ <id column="user_id" property="userId" />
+ <result column="dept_id" property="deptId" />
+ <result column="user_name" property="userName" />
+ <result column="nick_name" property="nickName" />
+ <result column="user_type" property="userType" />
+ <result column="email" property="email" />
+ <result column="phonenumber" property="phonenumber" />
+ <result column="sex" property="sex" />
+ <result column="avatar" property="avatar" />
+ <result column="password" property="password" />
+ <result column="status" property="status" />
+ <result column="del_flag" property="delFlag" />
+ <result column="login_ip" property="loginIp" />
+ <result column="login_date" property="loginDate" />
+ <result column="roleType" property="roleType" />
+ <result column="passWordUpdate" property="passWordUpdate" />
+ <result column="objectId" property="objectId" />
+ <result column="create_by" property="createBy" />
+ <result column="create_time" property="createTime" />
+ <result column="update_by" property="updateBy" />
+ <result column="update_time" property="updateTime" />
+ <result column="remark" property="remark" />
+ </resultMap>
+
+ <!-- 通用查询结果列 -->
+ <sql id="Base_Column_List">
+ user_id, dept_id, user_name, nick_name, user_type, email, phonenumber, sex, avatar, password, status, del_flag, login_ip, login_date, roleType, passWordUpdate, objectId, create_by, create_time, update_by, update_time, remark
+ </sql>
+
+</mapper>
diff --git a/ruoyi-service/ruoyi-management/src/main/resources/mapper/management/SysUserPostMapper.xml b/ruoyi-service/ruoyi-management/src/main/resources/mapper/management/SysUserPostMapper.xml
new file mode 100644
index 0000000..3f1d9e8
--- /dev/null
+++ b/ruoyi-service/ruoyi-management/src/main/resources/mapper/management/SysUserPostMapper.xml
@@ -0,0 +1,16 @@
+<?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.ruoyi.management.mapper.SysUserPostMapper">
+
+ <!-- 通用查询映射结果 -->
+ <resultMap id="BaseResultMap" type="com.ruoyi.management.domain.SysUserPost">
+ <id column="user_id" property="userId" />
+ <result column="post_id" property="postId" />
+ </resultMap>
+
+ <!-- 通用查询结果列 -->
+ <sql id="Base_Column_List">
+ user_id, post_id
+ </sql>
+
+</mapper>
diff --git a/ruoyi-service/ruoyi-management/src/main/resources/mapper/management/SysUserRoleMapper.xml b/ruoyi-service/ruoyi-management/src/main/resources/mapper/management/SysUserRoleMapper.xml
new file mode 100644
index 0000000..468694c
--- /dev/null
+++ b/ruoyi-service/ruoyi-management/src/main/resources/mapper/management/SysUserRoleMapper.xml
@@ -0,0 +1,16 @@
+<?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.ruoyi.management.mapper.SysUserRoleMapper">
+
+ <!-- 通用查询映射结果 -->
+ <resultMap id="BaseResultMap" type="com.ruoyi.management.domain.SysUserRole">
+ <id column="user_id" property="userId" />
+ <result column="role_id" property="roleId" />
+ </resultMap>
+
+ <!-- 通用查询结果列 -->
+ <sql id="Base_Column_List">
+ user_id, role_id
+ </sql>
+
+</mapper>
diff --git a/ruoyi-service/ruoyi-management/src/main/resources/mapper/management/TFeedbackMapper.xml b/ruoyi-service/ruoyi-management/src/main/resources/mapper/management/TFeedbackMapper.xml
new file mode 100644
index 0000000..b70f6aa
--- /dev/null
+++ b/ruoyi-service/ruoyi-management/src/main/resources/mapper/management/TFeedbackMapper.xml
@@ -0,0 +1,39 @@
+<?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.ruoyi.management.mapper.TFeedbackMapper">
+
+ <!-- 通用查询映射结果 -->
+ <resultMap id="BaseResultMap" type="com.ruoyi.management.domain.TFeedback">
+ <id column="id" property="id" />
+ <result column="userId" property="userId" />
+ <result column="img" property="img" />
+ <result column="content" property="content" />
+ <result column="state" property="state" />
+ </resultMap>
+
+ <!-- 通用查询结果列 -->
+ <sql id="Base_Column_List">
+ id, userId, img, content, state
+ </sql>
+ <select id="listAll" resultType="com.ruoyi.management.vo.FeedbackVO">
+ select t1.*,t2.name as name ,t2.phone as phone
+ from t_feedback t1
+ left join t_user t2 on t1.userId = t2.id
+ where 1=1
+ <if test="null != req.userName and '' != req.userName">
+ and t2.name like CONCAT('%', #{req.userName}, '%')
+ </if>
+ <if test="null != req.phone and '' != req.phone">
+ and t2.phone like CONCAT('%', #{req.phone}, '%')
+ </if>
+ <if test="null != req.state">
+ and t1.state = #{req.state}
+ </if>
+ <if test="null != req.startTime">
+ and t1.createTime between #{req.startTime} and #{req.endTime}
+ </if>
+ order by t1.state,t1.createTime desc
+ </select>
+
+
+</mapper>
diff --git a/ruoyi-service/ruoyi-management/src/main/resources/mapper/management/TGoodsMapper.xml b/ruoyi-service/ruoyi-management/src/main/resources/mapper/management/TGoodsMapper.xml
new file mode 100644
index 0000000..a94739d
--- /dev/null
+++ b/ruoyi-service/ruoyi-management/src/main/resources/mapper/management/TGoodsMapper.xml
@@ -0,0 +1,28 @@
+<?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.ruoyi.management.mapper.TGoodsMapper">
+
+ <!-- 通用查询映射结果 -->
+ <resultMap id="BaseResultMap" type="com.ruoyi.goods.api.domain.TGoods">
+ <id column="id" property="id" />
+ <result column="name" property="name" />
+ <result column="price" property="price" />
+ <result column="total" property="total" />
+ <result column="surplus" property="surplus" />
+ <result column="userCount" property="userCount" />
+ <result column="typeIds" property="typeIds" />
+ <result column="coverImg" property="coverImg" />
+ <result column="detailImg" property="detailImg" />
+ <result column="detail" property="detail" />
+ <result column="isDelete" property="isDelete" />
+ <result column="type" property="type" />
+ <result column="integral" property="integral" />
+ </resultMap>
+
+ <!-- 通用查询结果列 -->
+ <sql id="Base_Column_List">
+ id, name,
+ price, total, surplus, userCount, typeIds, coverImg, detailImg, detail, isDelete, type,integral,
+ </sql>
+
+</mapper>
diff --git a/ruoyi-service/ruoyi-management/src/main/resources/mapper/management/TGoodsTypeMapper.xml b/ruoyi-service/ruoyi-management/src/main/resources/mapper/management/TGoodsTypeMapper.xml
new file mode 100644
index 0000000..3303ce3
--- /dev/null
+++ b/ruoyi-service/ruoyi-management/src/main/resources/mapper/management/TGoodsTypeMapper.xml
@@ -0,0 +1,17 @@
+<?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.ruoyi.management.mapper.TGoodsTypeMapper">
+
+ <!-- 通用查询映射结果 -->
+ <resultMap id="BaseResultMap" type="com.ruoyi.goods.api.domain.TGoodsType">
+ <id column="id" property="id" />
+ <result column="name" property="name" />
+ <result column="isDelete" property="isDelete" />
+ </resultMap>
+
+ <!-- 通用查询结果列 -->
+ <sql id="Base_Column_List">
+ id, name, isDelete
+ </sql>
+
+</mapper>
diff --git a/ruoyi-service/ruoyi-management/src/main/resources/mapper/management/TOrderMapper.xml b/ruoyi-service/ruoyi-management/src/main/resources/mapper/management/TOrderMapper.xml
new file mode 100644
index 0000000..061153b
--- /dev/null
+++ b/ruoyi-service/ruoyi-management/src/main/resources/mapper/management/TOrderMapper.xml
@@ -0,0 +1,26 @@
+<?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.ruoyi.management.mapper.TOrderMapper">
+
+ <!-- 通用查询映射结果 -->
+ <resultMap id="BaseResultMap" type="com.ruoyi.goods.api.domain.TOrder">
+ <id column="id" property="id" />
+ <result column="orderNumber" property="orderNumber" />
+ <result column="userId" property="userId" />
+ <result column="insertTime" property="insertTime" />
+ <result column="goodsId" property="goodsId" />
+ <result column="count" property="count" />
+ <result column="state" property="state" />
+ <result column="express" property="express" />
+ <result column="expressNumber" property="expressNumber" />
+ <result column="expressTime" property="expressTime" />
+ <result column="integral" property="integral" />
+ </resultMap>
+
+ <!-- 通用查询结果列 -->
+ <sql id="Base_Column_List">
+ id, orderNumber, userId, insertTime, goodsId, count, state, express, expressNumber, expressTime, integral
+ </sql>
+
+
+</mapper>
diff --git a/ruoyi-service/ruoyi-management/src/main/resources/mapper/management/TPageMapper.xml b/ruoyi-service/ruoyi-management/src/main/resources/mapper/management/TPageMapper.xml
new file mode 100644
index 0000000..4f27531
--- /dev/null
+++ b/ruoyi-service/ruoyi-management/src/main/resources/mapper/management/TPageMapper.xml
@@ -0,0 +1,17 @@
+<?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.ruoyi.management.mapper.TPageMapper">
+
+ <!-- 通用查询映射结果 -->
+ <resultMap id="BaseResultMap" type="com.ruoyi.management.domain.TPage">
+ <id column="id" property="id" />
+ <result column="img" property="img" />
+ <result column="type" property="type" />
+ </resultMap>
+
+ <!-- 通用查询结果列 -->
+ <sql id="Base_Column_List">
+ id, img, type
+ </sql>
+
+</mapper>
diff --git a/ruoyi-service/ruoyi-management/src/main/resources/mapper/management/TProtocolMapper.xml b/ruoyi-service/ruoyi-management/src/main/resources/mapper/management/TProtocolMapper.xml
new file mode 100644
index 0000000..f731c48
--- /dev/null
+++ b/ruoyi-service/ruoyi-management/src/main/resources/mapper/management/TProtocolMapper.xml
@@ -0,0 +1,18 @@
+<?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.ruoyi.management.mapper.TProtocolMapper">
+
+ <!-- 通用查询映射结果 -->
+ <resultMap id="BaseResultMap" type="com.ruoyi.management.domain.TProtocol">
+ <id column="id" property="id" />
+ <result column="content" property="content" />
+ <result column="type" property="type" />
+ <result column="insertTime" property="insertTime" />
+ </resultMap>
+
+ <!-- 通用查询结果列 -->
+ <sql id="Base_Column_List">
+ id, content, type, insertTime
+ </sql>
+
+</mapper>
diff --git a/ruoyi-service/ruoyi-management/src/main/resources/mapper/management/TSysSetMapper.xml b/ruoyi-service/ruoyi-management/src/main/resources/mapper/management/TSysSetMapper.xml
new file mode 100644
index 0000000..44a11d1
--- /dev/null
+++ b/ruoyi-service/ruoyi-management/src/main/resources/mapper/management/TSysSetMapper.xml
@@ -0,0 +1,7 @@
+<?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.ruoyi.management.mapper.TSysSetMapper">
+
+
+
+</mapper>
diff --git a/ruoyi-service/ruoyi-management/src/main/resources/mapper/management/TUseGuideMapper.xml b/ruoyi-service/ruoyi-management/src/main/resources/mapper/management/TUseGuideMapper.xml
new file mode 100644
index 0000000..6d3a176
--- /dev/null
+++ b/ruoyi-service/ruoyi-management/src/main/resources/mapper/management/TUseGuideMapper.xml
@@ -0,0 +1,37 @@
+<?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.ruoyi.management.mapper.TUseGuideMapper">
+
+ <!-- 通用查询映射结果 -->
+ <resultMap id="BaseResultMap" type="com.ruoyi.management.domain.TUseGuide">
+ <id column="id" property="id" />
+ <result column="title" property="title" />
+ <result column="sort" property="sort" />
+ <result column="answer" property="answer" />
+ <result column="insertTime" property="insertTime" />
+ </resultMap>
+
+ <!-- 通用查询结果列 -->
+ <sql id="Base_Column_List">
+ id, title, sort, isDelete, answer
+ </sql>
+ <select id="listAll" resultType="com.ruoyi.management.domain.TUseGuide">
+ select * from
+ t_use_guide where 1=1
+ <if test="null != req.title and '' != req.title">
+ and title like CONCAT('%', #{req.title}, '%')
+ </if>
+ order by insertTime desc
+ limit #{req.pageNumber}, #{req.pageSize}
+ </select>
+ <select id="listAllCount" resultType="com.ruoyi.management.domain.TUseGuide">
+ select * from
+ t_use_guide where 1=1
+ <if test="null != req.title and '' != req.title">
+ and title like CONCAT('%', #{req.title}, '%')
+ </if>
+ order by insertTtime desc
+
+ </select>
+
+</mapper>
diff --git a/ruoyi-service/ruoyi-management/src/main/resources/mapper/management/TUserMapper.xml b/ruoyi-service/ruoyi-management/src/main/resources/mapper/management/TUserMapper.xml
new file mode 100644
index 0000000..26d6e4b
--- /dev/null
+++ b/ruoyi-service/ruoyi-management/src/main/resources/mapper/management/TUserMapper.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.ruoyi.management.mapper.TUserMapper">
+
+ <!-- 通用查询映射结果 -->
+ <resultMap id="BaseResultMap" type="com.ruoyi.management.domain.TUser">
+ <id column="id" property="id" />
+ <result column="name" property="name" />
+ <result column="account" property="account" />
+ <result column="phone" property="phone" />
+ <result column="password" property="password" />
+ <result column="openId" property="openId" />
+ <result column="birthday" property="birthday" />
+ <result column="gender" property="gender" />
+ <result column="headImg" property="headImg" />
+ <result column="integral" property="integral" />
+ <result column="state" property="state" />
+ <result column="insertTime" property="insertTime" />
+ <result column="vipEndTime" property="vipEndTime" />
+ <result column="vipPayTime" property="vipPayTime" />
+
+ </resultMap>
+
+ <!-- 通用查询结果列 -->
+ <sql id="Base_Column_List">
+ id, name, account, phone, password, openId, birthday, gender, headImg, integral, state, insertTime, vipEndTime, vipPayTime, isBack, backTime
+ </sql>
+
+
+</mapper>
diff --git a/ruoyi-service/ruoyi-management/src/main/resources/mapper/management/TVipSetMapper.xml b/ruoyi-service/ruoyi-management/src/main/resources/mapper/management/TVipSetMapper.xml
new file mode 100644
index 0000000..a55a8ef
--- /dev/null
+++ b/ruoyi-service/ruoyi-management/src/main/resources/mapper/management/TVipSetMapper.xml
@@ -0,0 +1,18 @@
+<?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.ruoyi.management.mapper.TVipSetMapper">
+
+ <!-- 通用查询映射结果 -->
+ <resultMap id="BaseResultMap" type="com.ruoyi.management.domain.TVipSet">
+ <id column="id" property="id" />
+ <result column="amount" property="amount" />
+ <result column="time" property="time" />
+ <result column="info" property="info" />
+ </resultMap>
+
+ <!-- 通用查询结果列 -->
+ <sql id="Base_Column_List">
+ id, amount, time, info
+ </sql>
+
+</mapper>
--
Gitblit v1.7.1