水库编辑增加操作日志

guoshilong

2024-04-09 7507862aade5b70f747963e5f14757bc5a5d2978

水库编辑增加操作日志

 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/AttResBaseMapper.java

@@ -91,5 +91,12 @@

    Boolean updateRsvr(@Param("attResBase") AttResBase attResBase);

    /**
     * 获取操作记录
     * @param guid
     * @return
     */
    String getUpdateLog(@Param("resGuid") String guid);

    int updateRelResUpdateLoc(@Param("resGuid") String guid,@Param("updateLog") String updateLog);
}

 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/mapper/AttResBaseMapper.xml

@@ -348,6 +348,11 @@
        </foreach>

    </update>
    <update id="updateRelResUpdateLoc">
        UPDATE SJZT_MD."rel_res_update_loc"
        SET "update_by" = #{updateLog}
        WHERE "res_code" = #{resGuid}
    </update>


    <!--根据水库名称、所在区域查询改水库的数量-->
@@ -517,6 +522,9 @@
            AND CONCAT(trmp1."user_phone",trmp2."user_phone",trmp3."user_phone",trmp4."user_phone",trmp5."user_phone") LIKE CONCAT('%',#{params.userPhone},'%')
        </if>
    </select>
    <select id="getUpdateLog" resultType="java.lang.String">
        SELECT "update_by" FROM  SJZT_MD."rel_res_update_loc" WHERE "res_code" = #{resGuid}
    </select>


</mapper>

 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/service/impl/AttResBaseServiceImpl.java

@@ -13,16 +13,16 @@
import com.baomidou.dynamic.datasource.annotation.DS;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import org.springblade.core.secure.BladeUser;
import org.springblade.core.secure.utils.AuthUtil;
import org.springblade.core.tool.utils.DateUtil;
import org.springblade.core.tool.utils.StringUtil;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
import org.springframework.web.bind.annotation.RequestParam;

import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import java.util.*;

/**
 * @ClassName AttResBaseServiceImpl
@@ -100,10 +100,41 @@
    public Boolean updateResBaseByGuid(AttResBase attResBase) {
        attResBase.setUpdateTime(DateUtil.now());

        String updateBy = baseMapper.getUpdateLog(attResBase.getGuid());
        if (StringUtil.isBlank(updateBy)){
            updateBy = "";
        }
        BladeUser user = AuthUtil.getUser();
        //修改人基础信息
        String account = user.getAccount();
        String userName = user.getUserName();
        String nowTime = DateUtil.format(DateUtil.now(),DateUtil.PATTERN_DATETIME);

        String updateUser = StringUtil.format("[{}-{}-{}]",account,userName,nowTime);

        //修改的东西
        String interiorAdGuid = attResBase.getInteriorAdGuid();
        String label = attResBase.getLabel();
        String heightBaseStdTp = attResBase.getHeightBaseStdTp();
        String isGate = attResBase.getIsGate();

        String updateLog = "";
        List<String> strList = new ArrayList<>();
        if (StringUtil.isNotBlank(interiorAdGuid)){
            strList.add("行政区划修改为"+ interiorAdGuid);
        }
        strList.add("标签修改为"+label);
        strList.add("高程基准面修改为"+heightBaseStdTp);
        strList.add("是否有闸修改为"+isGate);

        String updateContent = String.join("、",strList);

        updateLog = updateUser + updateContent + ";";
        updateBy = updateBy + updateLog;
        //向水库标签表中更新数据
        relResLabelService.updateEntity(attResBase.getGuid(),attResBase.getLabel());

        //向操作记录表中增加记录
        baseMapper.updateRelResUpdateLoc(attResBase.getGuid(),updateBy);
        return baseMapper.updateResBaseByGuid(attResBase);
    }