From e8a72ebe25e054107b76bde858ae970e24c94cf0 Mon Sep 17 00:00:00 2001
From: Fancy <Fancy.fx@outlook.com>
Date: 星期五, 18 十月 2024 16:23:47 +0800
Subject: [PATCH] command

---
 pms-parent/pms-web-platform/src/main/java/com/dy/pmsPlatform/tstCommand/TstCommandSv.java |   14 ++++---
 pms-parent/pms-global/src/main/java/com/dy/pmsGlobal/pojoTst/TstCommand.java              |   10 +++-
 pms-parent/pms-global/src/main/resources/mapper/TstCommandMapper.xml                      |   38 ++++++++++---------
 3 files changed, 35 insertions(+), 27 deletions(-)

diff --git a/pms-parent/pms-global/src/main/java/com/dy/pmsGlobal/pojoTst/TstCommand.java b/pms-parent/pms-global/src/main/java/com/dy/pmsGlobal/pojoTst/TstCommand.java
index 8a8121a..b65c6f4 100644
--- a/pms-parent/pms-global/src/main/java/com/dy/pmsGlobal/pojoTst/TstCommand.java
+++ b/pms-parent/pms-global/src/main/java/com/dy/pmsGlobal/pojoTst/TstCommand.java
@@ -54,6 +54,7 @@
     /**
      * 鏄惁鍒犻櫎锛�1鏄紝0鍚�
      */
+    @JSONField(serialize = false)
     public Boolean deleted;
 
     /**
@@ -62,20 +63,23 @@
     public String remark;
 
     /**
-     * 鏄惁绂佺敤锛�1鏄紝0鍚�
+     * 鏄惁鍒犻櫎锛�1鏄紝0鍚�
      */
+    @JSONField(serialize = false)
     public Boolean disabled;
 
     /**
      * 鍒涘缓浜�
      */
     @JSONField(serializeUsing= ObjectWriterImplToString.class)
-    public Long createBy;
+    public Long creator;
+    @TableField(exist = false)
+    public String creatorName;
 
     /**
      * 鍒涘缓鏃堕棿
      */
-    public Date createDate;
+    public Date dt;
 
     /**
      * 鏇存柊浜�
diff --git a/pms-parent/pms-global/src/main/resources/mapper/TstCommandMapper.xml b/pms-parent/pms-global/src/main/resources/mapper/TstCommandMapper.xml
index 553b47c..ae65b18 100644
--- a/pms-parent/pms-global/src/main/resources/mapper/TstCommandMapper.xml
+++ b/pms-parent/pms-global/src/main/resources/mapper/TstCommandMapper.xml
@@ -13,17 +13,19 @@
             <result property="deleted" column="deleted"  typeHandler="com.dy.common.mybatis.BooleanTypeHandler"/>
             <result property="disabled" column="disabled" typeHandler="com.dy.common.mybatis.BooleanTypeHandler"/>
             <result property="remark" column="remark" jdbcType="VARCHAR"/>
-            <result property="createBy" column="create_by" jdbcType="BIGINT"/>
-            <result property="createDate" column="create_date" jdbcType="TIMESTAMP"/>
+            <result property="creator" column="creator" jdbcType="VARCHAR"/>
+            <result property="dt" column="dt" jdbcType="TIMESTAMP"/>
             <result property="updatedBy" column="updated_by" jdbcType="BIGINT"/>
             <result property="updatedDate" column="updated_date" jdbcType="TIMESTAMP"/>
+            <association property="creatorName" column="creator" javaType="java.lang.Long"
+                     select="com.dy.pmsGlobal.daoBa.BaUserMapper.selectNameByUserId" fetchType="eager"/>
     </resultMap>
 
     <sql id="Base_Column_List">
         id,pro_id,type,
         name,value,deleted,
-        remark,disabled,create_by,
-        create_date,updated_by,updated_date
+        remark,disabled,creator,
+        dt,updated_by,updated_date
     </sql>
 
     <select id="selectByPrimaryKey" parameterType="java.lang.Long" resultMap="BaseResultMap">
@@ -99,13 +101,13 @@
         insert into tst_command
         ( id,pro_id,type
         ,name,value,deleted
-        ,remark,disabled,create_by
-        ,create_date,updated_by,updated_date
+        ,remark,disabled,creator
+        ,dt,updated_by,updated_date
         )
         values (#{id,jdbcType=BIGINT},#{proId,jdbcType=BIGINT},#{type,jdbcType=TINYINT}
         ,#{name,jdbcType=VARCHAR},#{value,jdbcType=VARCHAR},#{deleted,jdbcType=TINYINT}
-        ,#{remark,jdbcType=VARCHAR},#{disabled,jdbcType=TINYINT},#{createBy,jdbcType=BIGINT}
-        ,#{createDate,jdbcType=TIMESTAMP},#{updatedBy,jdbcType=BIGINT},#{updatedDate,jdbcType=TIMESTAMP}
+        ,#{remark,jdbcType=VARCHAR},#{disabled,jdbcType=TINYINT},#{creator,jdbcType=VARCHAR}
+        ,#{dt,jdbcType=TIMESTAMP},#{updatedBy,jdbcType=BIGINT},#{updatedDate,jdbcType=TIMESTAMP}
         )
     </insert>
     <insert id="insertSelective" keyColumn="id" keyProperty="id" parameterType="com.dy.pmsGlobal.pojoTst.TstCommand" useGeneratedKeys="true">
@@ -119,8 +121,8 @@
                 <if test="deleted != null">deleted,</if>
                 <if test="remark != null">remark,</if>
                 <if test="disabled != null">disabled,</if>
-                <if test="createBy != null">create_by,</if>
-                <if test="createDate != null">create_date,</if>
+                <if test="creator != null and creator !=''">creator,</if>
+                <if test="dt != null">dt,</if>
                 <if test="updatedBy != null">updated_by,</if>
                 <if test="updatedDate != null">updated_date,</if>
         </trim>
@@ -133,8 +135,8 @@
                 <if test="deleted != null">#{deleted,jdbcType=TINYINT},</if>
                 <if test="remark != null">#{remark,jdbcType=VARCHAR},</if>
                 <if test="disabled != null">#{disabled,jdbcType=TINYINT},</if>
-                <if test="createBy != null">#{createBy,jdbcType=BIGINT},</if>
-                <if test="createDate != null">#{createDate,jdbcType=TIMESTAMP},</if>
+                <if test="creator != null and creator !=''">#{creator,jdbcType=VARCHAR},</if>
+                <if test="dt != null">#{dt,jdbcType=TIMESTAMP},</if>
                 <if test="updatedBy != null">#{updatedBy,jdbcType=BIGINT},</if>
                 <if test="updatedDate != null">#{updatedDate,jdbcType=TIMESTAMP},</if>
         </trim>
@@ -163,11 +165,11 @@
                 <if test="disabled != null">
                     disabled = #{disabled,jdbcType=TINYINT},
                 </if>
-                <if test="createBy != null">
-                    create_by = #{createBy,jdbcType=BIGINT},
+                <if test="creator != null and creator !=''">
+                    creator = #{creator,jdbcType=VARCHAR},
                 </if>
-                <if test="createDate != null">
-                    create_date = #{createDate,jdbcType=TIMESTAMP},
+                <if test="dt != null">
+                    dt = #{dt,jdbcType=TIMESTAMP},
                 </if>
                 <if test="updatedBy != null">
                     updated_by = #{updatedBy,jdbcType=BIGINT},
@@ -188,8 +190,8 @@
             deleted =  #{deleted,jdbcType=TINYINT},
             remark =  #{remark,jdbcType=VARCHAR},
             disabled =  #{disabled,jdbcType=TINYINT},
-            create_by =  #{createBy,jdbcType=BIGINT},
-            create_date =  #{createDate,jdbcType=TIMESTAMP},
+            creator =  #{creator,jdbcType=VARCHAR},
+            dt =  #{dt,jdbcType=TIMESTAMP},
             updated_by =  #{updatedBy,jdbcType=BIGINT},
             updated_date =  #{updatedDate,jdbcType=TIMESTAMP}
         where   id = #{id,jdbcType=BIGINT} 
diff --git a/pms-parent/pms-web-platform/src/main/java/com/dy/pmsPlatform/tstCommand/TstCommandSv.java b/pms-parent/pms-web-platform/src/main/java/com/dy/pmsPlatform/tstCommand/TstCommandSv.java
index e1ae498..39b6518 100644
--- a/pms-parent/pms-web-platform/src/main/java/com/dy/pmsPlatform/tstCommand/TstCommandSv.java
+++ b/pms-parent/pms-web-platform/src/main/java/com/dy/pmsPlatform/tstCommand/TstCommandSv.java
@@ -1,7 +1,9 @@
 package com.dy.pmsPlatform.tstCommand;
 
+import com.dy.common.webFilter.UserTokenContext;
 import com.dy.common.webUtil.QueryResultVo;
 import com.dy.pmsGlobal.daoTst.TstCommandMapper;
+import com.dy.pmsGlobal.pojoBa.BaUser;
 import com.dy.pmsGlobal.pojoTst.TstCommand;
 import com.dy.pmsGlobal.util.UserUtil;
 import lombok.extern.slf4j.Slf4j;
@@ -36,11 +38,11 @@
         }
         command.disabled = false;
         command.deleted = false;
-     /*   BaUser loginUser = userUtil.getUser(UserTokenContext.get());
+        BaUser loginUser = userUtil.getUser(UserTokenContext.get());
         if (loginUser != null) {
-            command.createBy = loginUser.id;
-        }*/
-        command.createDate = new Date();
+            command.creator = loginUser.id;
+        }
+        command.dt = new Date();
         int count = dao.insertSelective(command);
         return count;
     }
@@ -61,10 +63,10 @@
         if(dao.selectByNameId(command.id,command.proId,command.name)>0){
             throw new RuntimeException("鎸囦护鍚嶇О宸插瓨鍦�");
         }
-        /*   BaUser loginUser = userUtil.getUser(UserTokenContext.get());
+        BaUser loginUser = userUtil.getUser(UserTokenContext.get());
         if (loginUser != null) {
             command.updatedBy = loginUser.id;
-        }*/
+        }
         command.updatedDate = new Date();
         int count = dao.updateByPrimaryKeySelective(command);
         return count;

--
Gitblit v1.8.0