From 7c4214af1e58eb176dfac580383e07c93bfdd521 Mon Sep 17 00:00:00 2001
From: 邱宇豪 <qyh123230312>
Date: 星期二, 28 十一月 2023 14:39:33 +0800
Subject: [PATCH] 20231128_qiuyh_修改导出时间格式
---
hd/pipe/secure/src/main/java/com/thhy/secure/modules/biz/integralAccount/entity/IntegralDetailEntity.java | 3 ++-
hd/pipe/StaffManage/src/main/resources/mapping/PlatUserMapper.xml | 2 +-
hd/pipe/secure/src/main/java/com/thhy/secure/modules/biz/hiddenDanger/service/impl/HiddenDangerServiceImpl.java | 1 -
hd/pipe/secure/src/main/resources/mapping/IntegralDetailMapper.xml | 7 ++++---
4 files changed, 7 insertions(+), 6 deletions(-)
diff --git a/hd/pipe/StaffManage/src/main/resources/mapping/PlatUserMapper.xml b/hd/pipe/StaffManage/src/main/resources/mapping/PlatUserMapper.xml
index d932fb5..d8e6366 100644
--- a/hd/pipe/StaffManage/src/main/resources/mapping/PlatUserMapper.xml
+++ b/hd/pipe/StaffManage/src/main/resources/mapping/PlatUserMapper.xml
@@ -114,7 +114,7 @@
</if>
</trim>
</where>
-
+ order by spu.create_time desc
</select>
<select id="queryForPullDownDorm" resultType="com.thhy.staff.modules.biz.platuser.entity.PlatUserPullDown">
diff --git a/hd/pipe/secure/src/main/java/com/thhy/secure/modules/biz/hiddenDanger/service/impl/HiddenDangerServiceImpl.java b/hd/pipe/secure/src/main/java/com/thhy/secure/modules/biz/hiddenDanger/service/impl/HiddenDangerServiceImpl.java
index 5bed478..fcfa191 100644
--- a/hd/pipe/secure/src/main/java/com/thhy/secure/modules/biz/hiddenDanger/service/impl/HiddenDangerServiceImpl.java
+++ b/hd/pipe/secure/src/main/java/com/thhy/secure/modules/biz/hiddenDanger/service/impl/HiddenDangerServiceImpl.java
@@ -171,7 +171,6 @@
public BasicResult examine(HiddenDangerEntity hiddenDangerEntity) {
SysUserInfo sysUserInfo = UserInfoUtils.getInstance().getUserInfo();
String platUserId = regionInspectionRecordMapper.selectPlatUserId(hiddenDangerEntity.getCreateUser());
-
Map platUser = regionInspectionRecordMapper.getPlatUser(platUserId);
int user_type = (int) platUser.get("user_type");
Map account = new HashMap();
diff --git a/hd/pipe/secure/src/main/java/com/thhy/secure/modules/biz/integralAccount/entity/IntegralDetailEntity.java b/hd/pipe/secure/src/main/java/com/thhy/secure/modules/biz/integralAccount/entity/IntegralDetailEntity.java
index 142f0e1..4f9834e 100644
--- a/hd/pipe/secure/src/main/java/com/thhy/secure/modules/biz/integralAccount/entity/IntegralDetailEntity.java
+++ b/hd/pipe/secure/src/main/java/com/thhy/secure/modules/biz/integralAccount/entity/IntegralDetailEntity.java
@@ -32,8 +32,9 @@
private Double changeIntegral;//变量在积分超市 修改前的变量
- @Excel(sort = 1,title = "时间")
private Date createTime;
+ @Excel(sort = 1,title = "时间")
+ private String createDate;
@Excel(sort = 2,title = "人员类别")
private String userTypeName;
@Excel(sort = 3,title = "人员姓名")
diff --git a/hd/pipe/secure/src/main/resources/mapping/IntegralDetailMapper.xml b/hd/pipe/secure/src/main/resources/mapping/IntegralDetailMapper.xml
index 49fd4d7..6409c6a 100644
--- a/hd/pipe/secure/src/main/resources/mapping/IntegralDetailMapper.xml
+++ b/hd/pipe/secure/src/main/resources/mapping/IntegralDetailMapper.xml
@@ -236,8 +236,9 @@
SELECT
t.*,
spu.real_name realName,
- spu.user_type userTypeName
- FROM t_integral_detail t
+ spu.user_type userTypeName,
+ DATE_FORMAT(t.createTime, '%Y-%m-%d %H:%m:%s') createDate
+ FROM t_integral_detail t
LEFT JOIN sys_plat_user spu on spu.user_id = t.userId
WHERE t.isUse = 1 and t.type = 2 and t.companyId = #{companyId}
<if test="userId != null and userId !=''">
@@ -280,7 +281,7 @@
<select id="selectSafeIntegralInfo" resultType="com.thhy.secure.modules.biz.integralAccount.entity.IntegralDetailDto">
SELECT
t.*,
- DATE_FORMAT(t.createTime, '%Y-%m-%d') createDate
+ DATE_FORMAT(t.createTime, '%Y-%m-%d %H:%m:%s') createDate
FROM t_integral_detail t
WHERE t.isUse = 1
<if test="companyId != null and companyId !=''">
--
Gitblit v1.9.3