jhleem / egov star

이다솜 이다솜 2022-02-22 @136

[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
List