[20220222 이다솜] bbs log 추가 코밋
Index: base3.10/src/main/java/egovframework/com/sym/log/blg/service/impl/BbsLogServiceImpl.java
===================================================================
--- base3.10/src/main/java/egovframework/com/sym/log/blg/service/impl/BbsLogServiceImpl.java (nonexistent)
+++ base3.10/src/main/java/egovframework/com/sym/log/blg/service/impl/BbsLogServiceImpl.java (revision 136)
@@ -0,0 +1,41 @@
+package egovframework.com.sym.log.blg.service.impl;
+
+import javax.annotation.Resource;
+
+import org.springframework.stereotype.Service;
+
+import egovframework.com.sym.log.blg.service.BbsLog;
+import egovframework.com.sym.log.blg.service.BbsLogService;
+import egovframework.rte.fdl.cmmn.EgovAbstractServiceImpl;
+import egovframework.rte.fdl.cmmn.exception.EgovBizException;
+import egovframework.rte.fdl.cmmn.exception.FdlException;
+import egovframework.rte.fdl.idgnr.EgovIdGnrService;
+
+/**
+ * 게시글 로그 service imple
+ * @author 이다솜
+ *
+ */
+@Service("BbsLogService")
+public class BbsLogServiceImpl extends EgovAbstractServiceImpl implements BbsLogService {
+
+ /** ID Generation */
+ @Resource(name="egovBbsLogIdGnrService")
+ private EgovIdGnrService egovBbsLogIdGnrService;
+
+ /** 게시글 로그 dao */
+ @Resource(name="BbsLogDAO")
+ private BbsLogDAO bbsLogDAO;
+
+ /**
+ * 게시글 로그 등록
+ * @throws FdlException
+ */
+ @Override
+ public void insertBbslog(BbsLog bbsLog) throws EgovBizException, FdlException {
+ String requstId = egovBbsLogIdGnrService.getNextStringId();
+ bbsLog.setRequstId(requstId);
+ bbsLogDAO.insertBbslog(bbsLog);
+ }
+
+}
Property changes on: base3.10/src/main/java/egovframework/com/sym/log/blg/service/impl/BbsLogServiceImpl.java
___________________________________________________________________
Added: svn:mime-type
+ text/plain
Index: base3.10/src/main/java/egovframework/com/sym/log/blg/service/impl/BbsLogDAO.java
===================================================================
--- base3.10/src/main/java/egovframework/com/sym/log/blg/service/impl/BbsLogDAO.java (nonexistent)
+++ base3.10/src/main/java/egovframework/com/sym/log/blg/service/impl/BbsLogDAO.java (revision 136)
@@ -0,0 +1,23 @@
+package egovframework.com.sym.log.blg.service.impl;
+
+import org.springframework.stereotype.Repository;
+
+import egovframework.com.cmm.service.impl.EgovComAbstractDAO;
+import egovframework.com.sym.log.blg.service.BbsLog;
+
+/**
+ * 게시글 log DAO
+ * @author 이다솜
+ *
+ */
+@Repository("BbsLogDAO")
+public class BbsLogDAO extends EgovComAbstractDAO {
+
+ /**
+ * 게시글 로그를 저장한다.
+ * @param bbsLog
+ */
+ public void insertBbslog(BbsLog bbsLog) {
+ insert("BbsLogDAO.insertBbslog", bbsLog);
+ }
+}
Property changes on: base3.10/src/main/java/egovframework/com/sym/log/blg/service/impl/BbsLogDAO.java
___________________________________________________________________
Added: svn:mime-type
+ text/plain
Index: base3.10/src/main/java/egovframework/com/sym/log/blg/service/BbslogAspect.java
===================================================================
--- base3.10/src/main/java/egovframework/com/sym/log/blg/service/BbslogAspect.java (nonexistent)
+++ base3.10/src/main/java/egovframework/com/sym/log/blg/service/BbslogAspect.java (revision 136)
@@ -0,0 +1,58 @@
+package egovframework.com.sym.log.blg.service;
+
+import java.util.Locale;
+
+import javax.annotation.Resource;
+import javax.servlet.http.HttpServletRequest;
+
+import org.springframework.web.context.request.RequestContextHolder;
+import org.springframework.web.context.request.ServletRequestAttributes;
+
+import egovframework.com.cmm.LoginVO;
+import egovframework.com.cmm.util.EgovUserDetailsHelper;
+import egovframework.com.cop.bbs.service.BoardVO;
+
+/**
+ * 게시글 로그 aspect
+ * @author 이다솜
+ *
+ */
+public class BbslogAspect {
+
+ /** 게시글 로그 service */
+ @Resource(name="BbsLogService")
+ private BbsLogService bbsLogService;
+
+ /**
+ * 게시글 로그 등록
+ * @param obj
+ */
+ public void afterReturning(BoardVO obj) {
+ HttpServletRequest request = ((ServletRequestAttributes) RequestContextHolder.getRequestAttributes()).getRequest();
+ BbsLog bbsLog = new BbsLog();
+
+ String uniqId = "";
+ String ip = "";
+
+ /* Authenticated */
+ Boolean isAuthenticated = EgovUserDetailsHelper.isAuthenticated();
+ if(isAuthenticated.booleanValue()) {
+ LoginVO user = (LoginVO)EgovUserDetailsHelper.getAuthenticatedUser();
+ uniqId = (user == null || user.getUniqId() == null) ? "" : user.getUniqId();
+ ip = (user == null || user.getIp() == null) ? "" : user.getIp();
+ }
+
+ Locale locale = request.getLocale();
+ bbsLog.setRqesterId(uniqId);
+ bbsLog.setRqesterIp(ip);
+ bbsLog.setNttId(obj.getNttId());
+ bbsLog.setNtnNm(locale.getDisplayCountry(new Locale("ko")));
+
+ try {
+ bbsLogService.insertBbslog(bbsLog);
+ } catch (Exception e) {
+ e.printStackTrace();
+ }
+
+ }
+}
Property changes on: base3.10/src/main/java/egovframework/com/sym/log/blg/service/BbslogAspect.java
___________________________________________________________________
Added: svn:mime-type
+ text/plain
Index: base3.10/src/main/java/egovframework/com/sym/log/blg/service/BbsLogService.java
===================================================================
--- base3.10/src/main/java/egovframework/com/sym/log/blg/service/BbsLogService.java (nonexistent)
+++ base3.10/src/main/java/egovframework/com/sym/log/blg/service/BbsLogService.java (revision 136)
@@ -0,0 +1,20 @@
+package egovframework.com.sym.log.blg.service;
+
+import egovframework.rte.fdl.cmmn.exception.EgovBizException;
+import egovframework.rte.fdl.cmmn.exception.FdlException;
+
+/**
+ * 게시글 로그 service
+ * @author 이다솜
+ *
+ */
+public interface BbsLogService {
+
+ /**
+ * 게시글 로그 등록
+ * @param bbsLog
+ * @throws Exception
+ */
+ public void insertBbslog(BbsLog bbsLog) throws EgovBizException, FdlException;
+
+}
Property changes on: base3.10/src/main/java/egovframework/com/sym/log/blg/service/BbsLogService.java
___________________________________________________________________
Added: svn:mime-type
+ text/plain
Index: base3.10/src/main/java/egovframework/com/sym/log/blg/service/BbsLog.java
===================================================================
--- base3.10/src/main/java/egovframework/com/sym/log/blg/service/BbsLog.java (nonexistent)
+++ base3.10/src/main/java/egovframework/com/sym/log/blg/service/BbsLog.java (revision 136)
@@ -0,0 +1,68 @@
+package egovframework.com.sym.log.blg.service;
+
+import java.io.Serializable;
+
+import org.apache.ibatis.type.Alias;
+
+/**
+ * 게시글 로그 vo
+ * @author 이다솜
+ *
+ */
+@Alias("BbsLog")
+public class BbsLog implements Serializable {
+ /**
+ *
+ */
+ private static final long serialVersionUID = 1L;
+
+ /** 요청ID */
+ private String requstId;
+ /** 게시글ID */
+ private Long nttId;
+ /** 발생일 */
+ private String occrrncDe;
+ /** 국가명 */
+ private String ntnNm;
+ /** 요청자IP */
+ private String rqesterIp;
+ /** 요청자ID */
+ private String rqesterId;
+
+ public String getRequstId() {
+ return requstId;
+ }
+ public void setRequstId(String requstId) {
+ this.requstId = requstId;
+ }
+ public Long getNttId() {
+ return nttId;
+ }
+ public void setNttId(Long nttId) {
+ this.nttId = nttId;
+ }
+ public String getOccrrncDe() {
+ return occrrncDe;
+ }
+ public void setOccrrncDe(String occrrncDe) {
+ this.occrrncDe = occrrncDe;
+ }
+ public String getNtnNm() {
+ return ntnNm;
+ }
+ public void setNtnNm(String ntnNm) {
+ this.ntnNm = ntnNm;
+ }
+ public String getRqesterIp() {
+ return rqesterIp;
+ }
+ public void setRqesterIp(String rqesterIp) {
+ this.rqesterIp = rqesterIp;
+ }
+ public String getRqesterId() {
+ return rqesterId;
+ }
+ public void setRqesterId(String rqesterId) {
+ this.rqesterId = rqesterId;
+ }
+}
Property changes on: base3.10/src/main/java/egovframework/com/sym/log/blg/service/BbsLog.java
___________________________________________________________________
Added: svn:mime-type
+ text/plain
Index: base3.10/src/main/resources/egovframework/mapper/com/sym/log/blg/BbsLog_SQL_postgres.xml
===================================================================
--- base3.10/src/main/resources/egovframework/mapper/com/sym/log/blg/BbsLog_SQL_postgres.xml (nonexistent)
+++ base3.10/src/main/resources/egovframework/mapper/com/sym/log/blg/BbsLog_SQL_postgres.xml (revision 136)
@@ -0,0 +1,39 @@
+<?xml version="1.0" encoding="UTF-8"?><!--Converted at: Wed May 11 15:50:41 KST 2016
+ 수정일 수정자 수정내용
+ ========= ======= =================================================
+ 2017.09.19 이정은 날짜로 검색 시 시분초 추가, 로그삭제기한 210일 -> 6개월로 변경
+ -->
+<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
+"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
+<mapper namespace="BbsLogDAO">
+
+ <!-- 게시글 로그 -->
+ <resultMap id="SysLogVO" type="BbsLog">
+ <result property="requstId" column="REQUST_ID"/>
+ <result property="nttId" column="NTT_ID"/>
+ <result property="occrrncDe" column="OCCRRNC_DE"/>
+ <result property="ntnNm" column="NTN_NM"/>
+ <result property="rqesterIp" column="RQESTER_IP"/>
+ <result property="rqesterId" column="RQESTER_ID"/>
+ </resultMap>
+
+ <!-- 게시글 로그 등록 -->
+ <insert id="insertBbslog" parameterType="BbsLog">
+ <![CDATA[
+ INSERT INTO COMTNBBSLOG
+ ( REQUST_ID
+ , NTT_ID
+ , NTN_NM
+ , RQESTER_ID
+ , RQESTER_IP
+ , OCCRRNC_DE )
+ VALUES ( #{requstId}
+ , #{nttId}
+ , #{ntnNm}
+ , #{rqesterId}
+ , #{rqesterIp}
+ , NOW())
+ ]]>
+ </insert>
+
+</mapper>
\ No newline at end of file
Property changes on: base3.10/src/main/resources/egovframework/mapper/com/sym/log/blg/BbsLog_SQL_postgres.xml
___________________________________________________________________
Added: svn:mime-type
+ text/plain
Index: base3.10/src/main/resources/egovframework/spring/com/idgn/context-idgn-BbsLog.xml
===================================================================
--- base3.10/src/main/resources/egovframework/spring/com/idgn/context-idgn-BbsLog.xml (nonexistent)
+++ base3.10/src/main/resources/egovframework/spring/com/idgn/context-idgn-BbsLog.xml (revision 136)
@@ -0,0 +1,20 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<beans xmlns="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
+ xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.0.xsd">
+
+ <!-- 게시글 로그 START-->
+ <bean name="egovBbsLogIdGnrService" class="egovframework.rte.fdl.idgnr.impl.EgovTableIdGnrServiceImpl" destroy-method="destroy">
+ <property name="dataSource" ref="egov.dataSource" />
+ <property name="strategy" ref="bbsLogStrategy" />
+ <property name="blockSize" value="10"/>
+ <property name="table" value="COMTECOPSEQ"/>
+ <property name="tableName" value="BBSLOG_ID"/>
+ </bean>
+ <bean name="bbsLogStrategy" class="egovframework.rte.fdl.idgnr.impl.strategy.EgovIdGnrStrategyImpl">
+ <property name="prefix" value="BBSLOG_" />
+ <property name="cipers" value="13" />
+ <property name="fillChar" value="0" />
+ </bean>
+ <!-- 게시글 로그... END-->
+
+</beans>
\ No newline at end of file
Property changes on: base3.10/src/main/resources/egovframework/spring/com/idgn/context-idgn-BbsLog.xml
___________________________________________________________________
Added: svn:mime-type
+ text/plain
Index: base3.10/src/main/resources/egovframework/spring/com/context-bbslogaop.xml
===================================================================
--- base3.10/src/main/resources/egovframework/spring/com/context-bbslogaop.xml (nonexistent)
+++ base3.10/src/main/resources/egovframework/spring/com/context-bbslogaop.xml (revision 136)
@@ -0,0 +1,18 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<beans xmlns="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
+ xmlns:aop="http://www.springframework.org/schema/aop"
+ xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.0.xsd
+ http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-4.0.xsd">
+
+ <!-- 게시글 로그 Aspect -->
+ <bean id="syslog" class="egovframework.com.sym.log.blg.service.BbslogAspect" />
+
+ <aop:config>
+ <aop:aspect id="sysLogAspect" ref="syslog">
+<!-- select로 시작되는 service Method -->
+ <aop:pointcut expression="execution(public * egovframework.com..impl.*Impl.selectArticleDetail*(..))" id="logSelect" />
+ <aop:after-returning pointcut-ref="logSelect" method="afterReturning" returning="obj" />
+ </aop:aspect>
+ </aop:config>
+
+</beans>
\ No newline at end of file
Property changes on: base3.10/src/main/resources/egovframework/spring/com/context-bbslogaop.xml
___________________________________________________________________
Added: svn:mime-type
+ text/plain
Add a comment
Delete comment
Once you delete this comment, you won't be able to recover it. Are you sure you want to delete this comment?