Index: base3.10/src/main/java/froala/editor/EditorFileVO.java
===================================================================
--- base3.10/src/main/java/froala/editor/EditorFileVO.java (revision 79)
+++ base3.10/src/main/java/froala/editor/EditorFileVO.java (revision 80)
@@ -4,12 +4,15 @@
import java.util.ArrayList;
import java.util.List;
+import org.apache.ibatis.type.Alias;
+
/**
* 에디터파일 VO
* @author 임종호
*
*/
@SuppressWarnings("serial")
+@Alias("EditorFileVO")
public class EditorFileVO implements Serializable{
// 파일ID
private String fileId;
Index: base3.10/src/main/java/egovframework/com/cmm/service/FileVO.java
===================================================================
--- base3.10/src/main/java/egovframework/com/cmm/service/FileVO.java (revision 79)
+++ base3.10/src/main/java/egovframework/com/cmm/service/FileVO.java (nonexistent)
@@ -1,240 +0,0 @@
-package egovframework.com.cmm.service;
-
-import java.io.Serializable;
-
-import org.apache.commons.lang3.builder.ToStringBuilder;
-
-/**
- * @Class Name : FileVO.java
- * @Description : 파일정보 처리를 위한 VO 클래스
- * @Modification Information
- *
- * 수정일 수정자 수정내용
- * ------- ------- -------------------
- * 2009. 3. 25. 이삼섭
- *
- * @author 공통 서비스 개발팀 이삼섭
- * @since 2009. 3. 25.
- * @version
- * @see
- *
- */
-@SuppressWarnings("serial")
-public class FileVO implements Serializable {
-
- /**
- * 첨부파일 아이디
- */
- public String atchFileId = "";
- /**
- * 생성일자
- */
- public String creatDt = "";
- /**
- * 파일내용
- */
- public String fileCn = "";
- /**
- * 파일확장자
- */
- public String fileExtsn = "";
- /**
- * 파일크기
- */
- public String fileMg = "";
- /**
- * 파일연번
- */
- public String fileSn = "";
- /**
- * 파일저장경로
- */
- public String fileStreCours = "";
- /**
- * 원파일명
- */
- public String orignlFileNm = "";
- /**
- * 저장파일명
- */
- public String streFileNm = "";
-
- /**
- * atchFileId attribute를 리턴한다.
- *
- * @return the atchFileId
- */
- public String getAtchFileId() {
- return atchFileId;
- }
-
- /**
- * atchFileId attribute 값을 설정한다.
- *
- * @param atchFileId
- * the atchFileId to set
- */
- public void setAtchFileId(String atchFileId) {
- this.atchFileId = atchFileId;
- }
-
- /**
- * creatDt attribute를 리턴한다.
- *
- * @return the creatDt
- */
- public String getCreatDt() {
- return creatDt;
- }
-
- /**
- * creatDt attribute 값을 설정한다.
- *
- * @param creatDt
- * the creatDt to set
- */
- public void setCreatDt(String creatDt) {
- this.creatDt = creatDt;
- }
-
- /**
- * fileCn attribute를 리턴한다.
- *
- * @return the fileCn
- */
- public String getFileCn() {
- return fileCn;
- }
-
- /**
- * fileCn attribute 값을 설정한다.
- *
- * @param fileCn
- * the fileCn to set
- */
- public void setFileCn(String fileCn) {
- this.fileCn = fileCn;
- }
-
- /**
- * fileExtsn attribute를 리턴한다.
- *
- * @return the fileExtsn
- */
- public String getFileExtsn() {
- return fileExtsn;
- }
-
- /**
- * fileExtsn attribute 값을 설정한다.
- *
- * @param fileExtsn
- * the fileExtsn to set
- */
- public void setFileExtsn(String fileExtsn) {
- this.fileExtsn = fileExtsn;
- }
-
- /**
- * fileMg attribute를 리턴한다.
- *
- * @return the fileMg
- */
- public String getFileMg() {
- return fileMg;
- }
-
- /**
- * fileMg attribute 값을 설정한다.
- *
- * @param fileMg
- * the fileMg to set
- */
- public void setFileMg(String fileMg) {
- this.fileMg = fileMg;
- }
-
- /**
- * fileSn attribute를 리턴한다.
- *
- * @return the fileSn
- */
- public String getFileSn() {
- return fileSn;
- }
-
- /**
- * fileSn attribute 값을 설정한다.
- *
- * @param fileSn
- * the fileSn to set
- */
- public void setFileSn(String fileSn) {
- this.fileSn = fileSn;
- }
-
- /**
- * fileStreCours attribute를 리턴한다.
- *
- * @return the fileStreCours
- */
- public String getFileStreCours() {
- return fileStreCours;
- }
-
- /**
- * fileStreCours attribute 값을 설정한다.
- *
- * @param fileStreCours
- * the fileStreCours to set
- */
- public void setFileStreCours(String fileStreCours) {
- this.fileStreCours = fileStreCours;
- }
-
- /**
- * orignlFileNm attribute를 리턴한다.
- *
- * @return the orignlFileNm
- */
- public String getOrignlFileNm() {
- return orignlFileNm;
- }
-
- /**
- * orignlFileNm attribute 값을 설정한다.
- *
- * @param orignlFileNm
- * the orignlFileNm to set
- */
- public void setOrignlFileNm(String orignlFileNm) {
- this.orignlFileNm = orignlFileNm;
- }
-
- /**
- * streFileNm attribute를 리턴한다.
- *
- * @return the streFileNm
- */
- public String getStreFileNm() {
- return streFileNm;
- }
-
- /**
- * streFileNm attribute 값을 설정한다.
- *
- * @param streFileNm
- * the streFileNm to set
- */
- public void setStreFileNm(String streFileNm) {
- this.streFileNm = streFileNm;
- }
-
- /**
- * toString 메소드를 대치한다.
- */
- public String toString() {
- return ToStringBuilder.reflectionToString(this);
- }
-
-}
Index: base3.10/src/main/java/egovframework/com/cmm/service/impl/FileManageDAO.java
===================================================================
--- base3.10/src/main/java/egovframework/com/cmm/service/impl/FileManageDAO.java (revision 79)
+++ base3.10/src/main/java/egovframework/com/cmm/service/impl/FileManageDAO.java (nonexistent)
@@ -1,181 +0,0 @@
-package egovframework.com.cmm.service.impl;
-
-import java.util.Iterator;
-import java.util.List;
-
-import egovframework.com.cmm.service.FileVO;
-
-import org.springframework.stereotype.Repository;
-
-/**
- * @Class Name : EgovFileMngDAO.java
- * @Description : 파일정보 관리를 위한 데이터 처리 클래스
- * @Modification Information
- *
- * 수정일 수정자 수정내용
- * ------- ------- -------------------
- * 2009. 3. 25. 이삼섭 최초생성
- *
- * @author 공통 서비스 개발팀 이삼섭
- * @since 2009. 3. 25.
- * @version
- * @see
- *
- */
-@Repository("FileManageDAO")
-public class FileManageDAO extends EgovComAbstractDAO {
-
- /**
- * 여러 개의 파일에 대한 정보(속성 및 상세)를 등록한다.
- *
- * @param fileList
- * @return
- * @throws Exception
- */
- public String insertFileInfs(List<?> fileList) throws Exception {
- FileVO vo = (FileVO) fileList.get(0);
- String atchFileId = vo.getAtchFileId();
-
- insert("FileManageDAO.insertFileMaster", vo);
-
- Iterator<?> iter = fileList.iterator();
- while (iter.hasNext()) {
- vo = (FileVO) iter.next();
-
- insert("FileManageDAO.insertFileDetail", vo);
- }
-
- return atchFileId;
- }
-
- /**
- * 하나의 파일에 대한 정보(속성 및 상세)를 등록한다.
- *
- * @param vo
- * @throws Exception
- */
- public void insertFileInf(FileVO vo) throws Exception {
- insert("FileManageDAO.insertFileMaster", vo);
- insert("FileManageDAO.insertFileDetail", vo);
- }
-
- /**
- * 여러 개의 파일에 대한 정보(속성 및 상세)를 수정한다.
- *
- * @param fileList
- * @throws Exception
- */
- public void updateFileInfs(List<?> fileList) throws Exception {
- FileVO vo;
- Iterator<?> iter = fileList.iterator();
- while (iter.hasNext()) {
- vo = (FileVO) iter.next();
- insert("FileManageDAO.insertFileDetail", vo);
- }
- }
-
- /**
- * 여러 개의 파일을 삭제한다.
- *
- * @param fileList
- * @throws Exception
- */
- public void deleteFileInfs(List<?> fileList) throws Exception {
- Iterator<?> iter = fileList.iterator();
- FileVO vo;
- while (iter.hasNext()) {
- vo = (FileVO) iter.next();
-
- delete("FileManageDAO.deleteFileDetail", vo);
- }
- }
-
- /**
- * 하나의 파일을 삭제한다.
- *
- * @param fvo
- * @throws Exception
- */
- public void deleteFileInf(FileVO fvo) throws Exception {
- delete("FileManageDAO.deleteFileDetail", fvo);
- }
-
- /**
- * 파일에 대한 목록을 조회한다.
- *
- * @param vo
- * @return
- * @throws Exception
- */
- @SuppressWarnings("unchecked")
- public List<FileVO> selectFileInfs(FileVO vo) throws Exception {
- return (List<FileVO>) list("FileManageDAO.selectFileList", vo);
- }
-
- /**
- * 파일 구분자에 대한 최대값을 구한다.
- *
- * @param fvo
- * @return
- * @throws Exception
- */
- public int getMaxFileSN(FileVO fvo) throws Exception {
- return (Integer) selectOne("FileManageDAO.getMaxFileSN", fvo);
- }
-
- /**
- * 파일에 대한 상세정보를 조회한다.
- *
- * @param fvo
- * @return
- * @throws Exception
- */
- public FileVO selectFileInf(FileVO fvo) throws Exception {
- return (FileVO) selectOne("FileManageDAO.selectFileInf", fvo);
- }
-
- /**
- * 전체 파일을 삭제한다.
- *
- * @param fvo
- * @throws Exception
- */
- public void deleteAllFileInf(FileVO fvo) throws Exception {
- update("FileManageDAO.deleteCOMTNFILE", fvo);
- }
-
- /**
- * 파일명 검색에 대한 목록을 조회한다.
- *
- * @param vo
- * @return
- * @throws Exception
- */
- @SuppressWarnings("unchecked")
- public List<FileVO> selectFileListByFileNm(FileVO fvo) throws Exception {
- return (List<FileVO>) list("FileManageDAO.selectFileListByFileNm", fvo);
- }
-
- /**
- * 파일명 검색에 대한 목록 전체 건수를 조회한다.
- *
- * @param fvo
- * @return
- * @throws Exception
- */
- public int selectFileListCntByFileNm(FileVO fvo) throws Exception {
- return (Integer) selectOne("FileManageDAO.selectFileListCntByFileNm", fvo);
- }
-
- /**
- * 이미지 파일에 대한 목록을 조회한다.
- *
- * @param vo
- * @return
- * @throws Exception
- */
- @SuppressWarnings("unchecked")
- public List<FileVO> selectImageFileList(FileVO vo) throws Exception {
- return (List<FileVO>) list("FileManageDAO.selectImageFileList", vo);
- }
-}
Index: base3.10/src/main/java/egovframework/com/cop/bbs/web/EgovArticleController.java
===================================================================
--- base3.10/src/main/java/egovframework/com/cop/bbs/web/EgovArticleController.java (revision 79)
+++ base3.10/src/main/java/egovframework/com/cop/bbs/web/EgovArticleController.java (revision 80)
@@ -22,7 +22,6 @@
import egovframework.com.cmm.EgovMessageSource;
import egovframework.com.cmm.LoginVO;
-import egovframework.com.cmm.service.FileVO;
import egovframework.com.cmm.util.EgovUserDetailsHelper;
import egovframework.com.cmm.util.EgovXssChecker;
import egovframework.com.cop.bbs.service.Board;
@@ -339,16 +338,6 @@
}
if (isAuthenticated) {
- List<FileVO> result = null;
- String atchFileId = "";
-
- //final Map<String, MultipartFile> files = multiRequest.getFileMap();
- final List<MultipartFile> files = multiRequest.getFiles("file_1");
- if (!files.isEmpty()) {
-// result = fileUtil.parseFileInf(files, "BBS_", 0, "", "");
-// atchFileId = fileMngService.insertFileInfs(result);
- }
- board.setAtchFileId(boardVO.getAtchFileId());
board.setFrstRegisterId((user == null || user.getUniqId() == null) ? "" : user.getUniqId());
board.setBbsId(boardVO.getBbsId());
board.setBlogId(boardVO.getBlogId());
@@ -597,8 +586,6 @@
// @ XSS 대응 권한체크 체크 END
//--------------------------------------------------------------------------------------------
- String atchFileId = boardVO.getAtchFileId();
-
beanValidator.validate(board, bindingResult);
if (bindingResult.hasErrors()) {
@@ -620,23 +607,6 @@
}
if (isAuthenticated) {
-
- //final Map<String, MultipartFile> files = multiRequest.getFileMap();
- final List<MultipartFile> files = multiRequest.getFiles("file_1");
- if (!files.isEmpty()) {
- if (atchFileId == null || "".equals(atchFileId)) {
-// List<FileVO> result = fileUtil.parseFileInf(files, "BBS_", 0, atchFileId, "");
-// atchFileId = fileMngService.insertFileInfs(result);
- board.setAtchFileId(atchFileId);
- } else {
- FileVO fvo = new FileVO();
- fvo.setAtchFileId(atchFileId);
-// int cnt = fileMngService.getMaxFileSN(fvo);
-// List<FileVO> _result = fileUtil.parseFileInf(files, "BBS_", cnt, atchFileId, "");
-// fileMngService.updateFileInfs(_result);
- }
- }
-
board.setLastUpdusrId((user == null || user.getUniqId() == null) ? "" : user.getUniqId());
board.setNtcrNm(""); // dummy 오류 수정 (익명이 아닌 경우 validator 처리를 위해 dummy로 지정됨)
Index: base3.10/src/main/java/egovframework/com/cop/bbs/service/impl/EgovArticleServiceImpl.java
===================================================================
--- base3.10/src/main/java/egovframework/com/cop/bbs/service/impl/EgovArticleServiceImpl.java (revision 79)
+++ base3.10/src/main/java/egovframework/com/cop/bbs/service/impl/EgovArticleServiceImpl.java (revision 80)
@@ -8,7 +8,6 @@
import org.springframework.stereotype.Service;
-import egovframework.com.cmm.service.FileVO;
import egovframework.com.cop.bbs.service.Board;
import egovframework.com.cop.bbs.service.BoardVO;
import egovframework.com.cop.bbs.service.EgovArticleService;
@@ -102,10 +101,6 @@
@Override
public void deleteArticle(Board board) throws Exception {
- FileVO fvo = new FileVO();
-
- fvo.setAtchFileId(board.getAtchFileId());
-
board.setNttSj("이 글은 작성자에 의해서 삭제되었습니다.");
egovArticleDao.deleteArticle(board);
Index: base3.10/src/main/java/egovframework/com/uss/ion/bnr/web/EgovBannerController.java
===================================================================
--- base3.10/src/main/java/egovframework/com/uss/ion/bnr/web/EgovBannerController.java (revision 79)
+++ base3.10/src/main/java/egovframework/com/uss/ion/bnr/web/EgovBannerController.java (revision 80)
@@ -39,7 +39,6 @@
import egovframework.com.cmm.EgovMessageSource;
import egovframework.com.cmm.LoginVO;
-import egovframework.com.cmm.service.FileVO;
import egovframework.com.cmm.util.EgovUserDetailsHelper;
import egovframework.com.uss.ion.bnr.service.Banner;
import egovframework.com.uss.ion.bnr.service.BannerVO;
@@ -161,7 +160,6 @@
model.addAttribute("bannerVO", bannerVO);
return ".adminLayout/배너관리/com/uss/ion/bnr/EgovBannerRegist";
} else {
- List<FileVO> result = null;
String bannerImage = "";
LoginVO user = (LoginVO)EgovUserDetailsHelper.getAuthenticatedUser();
Index: base3.10/src/main/java/egovframework/com/uss/ion/bnr/service/impl/EgovBannerServiceImpl.java
===================================================================
--- base3.10/src/main/java/egovframework/com/uss/ion/bnr/service/impl/EgovBannerServiceImpl.java (revision 79)
+++ base3.10/src/main/java/egovframework/com/uss/ion/bnr/service/impl/EgovBannerServiceImpl.java (revision 80)
@@ -15,12 +15,12 @@
import java.io.File;
import java.util.List;
-import egovframework.com.cmm.service.FileVO;
import egovframework.com.uss.ion.bnr.service.Banner;
import egovframework.com.uss.ion.bnr.service.BannerVO;
import egovframework.com.uss.ion.bnr.service.EgovBannerService;
import egovframework.rte.fdl.cmmn.EgovAbstractServiceImpl;
+import froala.editor.EditorFileVO;
import javax.annotation.Resource;
@@ -91,8 +91,8 @@
* @param banner - 배너 model
*/
public void deleteBannerFile(Banner banner) throws Exception{
- FileVO fileVO = (FileVO)bannerDAO.selectBannerFile(banner);
- File file = new File(fileVO.getFileStreCours()+fileVO.getStreFileNm());
+ EditorFileVO fileVO = (EditorFileVO)bannerDAO.selectBannerFile(banner);
+ File file = new File(fileVO.getFullPath());
file.delete();
}
Index: base3.10/src/main/java/egovframework/com/uss/ion/bnr/service/impl/BannerDAO.java
===================================================================
--- base3.10/src/main/java/egovframework/com/uss/ion/bnr/service/impl/BannerDAO.java (revision 79)
+++ base3.10/src/main/java/egovframework/com/uss/ion/bnr/service/impl/BannerDAO.java (revision 80)
@@ -14,10 +14,10 @@
import java.util.List;
-import egovframework.com.cmm.service.FileVO;
import egovframework.com.cmm.service.impl.EgovComAbstractDAO;
import egovframework.com.uss.ion.bnr.service.Banner;
import egovframework.com.uss.ion.bnr.service.BannerVO;
+import froala.editor.EditorFileVO;
import org.springframework.stereotype.Repository;
@@ -86,7 +86,7 @@
* @param banner - 배너 model
* @return FileVO - 파일 VO
*/
- public FileVO selectBannerFile(Banner banner) throws Exception {
+ public EditorFileVO selectBannerFile(Banner banner) throws Exception {
return selectOne("bannerDAO.selectBannerFile", banner);
}
Index: base3.10/src/main/resources/egovframework/mapper/com/cmm/fms/EgovFile_SQL_mysql.xml
===================================================================
--- base3.10/src/main/resources/egovframework/mapper/com/cmm/fms/EgovFile_SQL_mysql.xml (revision 79)
+++ base3.10/src/main/resources/egovframework/mapper/com/cmm/fms/EgovFile_SQL_mysql.xml (nonexistent)
@@ -1,169 +0,0 @@
-<?xml version="1.0" encoding="UTF-8"?><!--Converted at: Wed May 11 15:49:38 KST 2016-->
-<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
-"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
-<mapper namespace="FileManageDAO">
-
- <resultMap id="fileList" type="egovframework.com.cmm.service.FileVO">
- <result property="atchFileId" column="ATCH_FILE_ID"/>
- <result property="fileCn" column="FILE_CN"/>
- <result property="fileExtsn" column="FILE_EXTSN"/>
- <result property="fileMg" column="FILE_SIZE"/>
- <result property="fileSn" column="FILE_SN"/>
- <result property="fileStreCours" column="FILE_STRE_COURS"/>
- <result property="orignlFileNm" column="ORIGNL_FILE_NM"/>
- <result property="streFileNm" column="STRE_FILE_NM"/>
- <result property="creatDt" column="CREAT_DT"/>
- </resultMap>
-
- <resultMap id="fileDetail" type="egovframework.com.cmm.service.FileVO">
- <result property="atchFileId" column="ATCH_FILE_ID"/>
- <result property="fileCn" column="FILE_CN"/>
- <result property="fileExtsn" column="FILE_EXTSN"/>
- <result property="fileMg" column="FILE_SIZE"/>
- <result property="fileSn" column="FILE_SN"/>
- <result property="fileStreCours" column="FILE_STRE_COURS"/>
- <result property="orignlFileNm" column="ORIGNL_FILE_NM"/>
- <result property="streFileNm" column="STRE_FILE_NM"/>
- </resultMap>
-
-
- <select id="selectFileList" parameterType="FileVO" resultMap="fileList">
-
- SELECT
- a.ATCH_FILE_ID, b.FILE_CN, b.FILE_SN, b.FILE_STRE_COURS, b.STRE_FILE_NM,
- b.FILE_EXTSN, b.ORIGNL_FILE_NM, b.FILE_SIZE, a.CREAT_DT
- FROM
- COMTNFILE a, COMTNFILEDETAIL b
- WHERE
- a.ATCH_FILE_ID = #{atchFileId}
- AND
- a.ATCH_FILE_ID = b.ATCH_FILE_ID
- AND
- a.USE_AT = 'Y'
- ORDER BY b.FILE_SN
-
- </select>
-
- <insert id="insertFileMaster" parameterType="FileVO">
-
- INSERT INTO COMTNFILE
- (ATCH_FILE_ID, CREAT_DT, USE_AT)
- VALUES
- ( #{atchFileId}, SYSDATE(), 'Y')
-
- </insert>
-
- <insert id="insertFileDetail" parameterType="FileVO">
-
- INSERT INTO COMTNFILEDETAIL
- ( ATCH_FILE_ID, FILE_SN, FILE_STRE_COURS, STRE_FILE_NM,
- ORIGNL_FILE_NM, FILE_EXTSN, FILE_SIZE, FILE_CN )
- VALUES
- ( #{atchFileId}, #{fileSn}, #{fileStreCours}, #{streFileNm},
- #{orignlFileNm}, #{fileExtsn}, #{fileMg}, #{fileCn} )
-
- </insert>
-
- <delete id="deleteFileDetail" parameterType="FileVO">
-
- DELETE FROM COMTNFILEDETAIL
- WHERE
- ATCH_FILE_ID = #{atchFileId}
- AND
- FILE_SN = #{fileSn}
-
- </delete>
-
- <select id="getMaxFileSN" parameterType="FileVO" resultType="java.lang.Integer">
-
- SELECT IFNULL(MAX(FILE_SN),0)+1 AS FILE_SN
- FROM COMTNFILEDETAIL
- WHERE ATCH_FILE_ID = #{atchFileId}
-
- </select>
-
- <select id="selectFileInf" parameterType="FileVO" resultMap="fileDetail">
-
- SELECT
- ATCH_FILE_ID, FILE_CN, FILE_SN, FILE_STRE_COURS, STRE_FILE_NM,
- FILE_EXTSN, ORIGNL_FILE_NM, FILE_SIZE
- FROM
- COMTNFILEDETAIL
- WHERE
- ATCH_FILE_ID = #{atchFileId}
- AND
- FILE_SN = #{fileSn}
-
- </select>
-
- <update id="deleteCOMTNFILE" parameterType="FileVO">
-
- UPDATE COMTNFILE
- SET USE_AT = 'N'
- WHERE ATCH_FILE_ID = #{atchFileId}
-
- </update>
-
- <select id="selectFileListByFileNm" parameterType="FileVO" resultMap="fileList">
-
- SELECT
- a.ATCH_FILE_ID, b.FILE_CN, b.FILE_SN, b.FILE_STRE_COURS, b.STRE_FILE_NM,
- b.FILE_EXTSN, b.ORIGNL_FILE_NM, b.FILE_SIZE, a.CREAT_DT
- FROM
- COMTNFILE a, COMTNFILEDETAIL b
- WHERE
- a.ATCH_FILE_ID = b.ATCH_FILE_ID
- AND
- a.USE_AT = 'Y'
-
- <if test="searchCnd == 'streFileNm'">AND
- b.STRE_FILE_NM LIKE CONCAT ('%', #{searchWrd},'%')
- </if>
- <if test="searchCnd == 'orignlFileNm'">AND
- b.ORIGNL_FILE_NM LIKE CONCAT ('%', #{searchWrd},'%')
- </if>
-
- ORDER BY a.ATCH_FILE_ID, b.FILE_SN
- LIMIT #{recordCountPerPage} OFFSET #{firstIndex}
-
- </select>
-
- <select id="selectFileListCntByFileNm" parameterType="FileVO" resultType="java.lang.Integer">
-
- SELECT
- COUNT(a.ATCH_FILE_ID)
- FROM
- COMTNFILE a, COMTNFILEDETAIL b
- WHERE
- a.ATCH_FILE_ID = b.ATCH_FILE_ID
- AND
- a.USE_AT = 'Y'
-
- <if test="searchCnd == 'streFileNm'">AND
- b.STRE_FILE_NM LIKE CONCAT ('%', #{searchWrd},'%')
- </if>
- <if test="searchCnd == 'orignlFileNm'">AND
- b.ORIGNL_FILE_NM LIKE CONCAT ('%', #{searchWrd},'%')
- </if>
- </select>
-
- <select id="selectImageFileList" parameterType="FileVO" resultMap="fileList">
-
- SELECT
- a.ATCH_FILE_ID, b.FILE_CN, b.FILE_SN, b.FILE_STRE_COURS, b.STRE_FILE_NM,
- b.FILE_EXTSN, b.ORIGNL_FILE_NM, b.FILE_SIZE, a.CREAT_DT
- FROM
- COMTNFILE a, COMTNFILEDETAIL b
- WHERE
- a.ATCH_FILE_ID = #{atchFileId}
- AND
- a.ATCH_FILE_ID = b.ATCH_FILE_ID
- AND
- UPPER(b.FILE_EXTSN) IN ('GIF','JPG','BMP','PNG')
- AND
- a.USE_AT = 'Y'
- ORDER BY b.FILE_SN
-
- </select>
-
-</mapper>
\ No newline at end of file
Index: base3.10/src/main/resources/egovframework/mapper/com/cmm/fms/EgovFile_SQL_cubrid.xml
===================================================================
--- base3.10/src/main/resources/egovframework/mapper/com/cmm/fms/EgovFile_SQL_cubrid.xml (revision 79)
+++ base3.10/src/main/resources/egovframework/mapper/com/cmm/fms/EgovFile_SQL_cubrid.xml (nonexistent)
@@ -1,170 +0,0 @@
-<?xml version="1.0" encoding="UTF-8"?><!--Converted at: Wed May 11 15:49:38 KST 2016-->
-<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
-"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
-<mapper namespace="FileManageDAO">
-
- <resultMap id="fileList" type="egovframework.com.cmm.service.FileVO">
- <result property="atchFileId" column="ATCH_FILE_ID"/>
- <result property="fileCn" column="FILE_CN"/>
- <result property="fileExtsn" column="FILE_EXTSN"/>
- <result property="fileMg" column="FILE_SIZE"/>
- <result property="fileSn" column="FILE_SN"/>
- <result property="fileStreCours" column="FILE_STRE_COURS"/>
- <result property="orignlFileNm" column="ORIGNL_FILE_NM"/>
- <result property="streFileNm" column="STRE_FILE_NM"/>
- <result property="creatDt" column="CREAT_DT"/>
- </resultMap>
-
- <resultMap id="fileDetail" type="egovframework.com.cmm.service.FileVO">
- <result property="atchFileId" column="ATCH_FILE_ID"/>
- <result property="fileCn" column="FILE_CN"/>
- <result property="fileExtsn" column="FILE_EXTSN"/>
- <result property="fileMg" column="FILE_SIZE"/>
- <result property="fileSn" column="FILE_SN"/>
- <result property="fileStreCours" column="FILE_STRE_COURS"/>
- <result property="orignlFileNm" column="ORIGNL_FILE_NM"/>
- <result property="streFileNm" column="STRE_FILE_NM"/>
- </resultMap>
-
-
- <select id="selectFileList" parameterType="FileVO" resultMap="fileList">
-
- SELECT
- a.ATCH_FILE_ID, b.FILE_CN, b.FILE_SN, b.FILE_STRE_COURS, b.STRE_FILE_NM,
- b.FILE_EXTSN, b.ORIGNL_FILE_NM, b.FILE_SIZE, a.CREAT_DT
- FROM
- COMTNFILE a, COMTNFILEDETAIL b
- WHERE
- a.ATCH_FILE_ID = #{atchFileId}
- AND
- a.ATCH_FILE_ID = b.ATCH_FILE_ID
- AND
- a.USE_AT = 'Y'
- ORDER BY b.FILE_SN
-
- </select>
-
- <insert id="insertFileMaster" parameterType="FileVO">
-
- INSERT INTO COMTNFILE
- (ATCH_FILE_ID, CREAT_DT, USE_AT)
- VALUES
- ( #{atchFileId}, SYSDATETIME, 'Y')
-
- </insert>
-
- <insert id="insertFileDetail" parameterType="FileVO">
-
- INSERT INTO COMTNFILEDETAIL
- ( ATCH_FILE_ID, FILE_SN, FILE_STRE_COURS, STRE_FILE_NM,
- ORIGNL_FILE_NM, FILE_EXTSN, FILE_SIZE, FILE_CN )
- VALUES
- ( #{atchFileId}, #{fileSn}, #{fileStreCours}, #{streFileNm},
- #{orignlFileNm}, #{fileExtsn}, #{fileMg}, #{fileCn} )
-
- </insert>
-
- <delete id="deleteFileDetail" parameterType="FileVO">
-
- DELETE FROM COMTNFILEDETAIL
- WHERE
- ATCH_FILE_ID = #{atchFileId}
- AND
- FILE_SN = #{fileSn}
-
- </delete>
-
- <select id="getMaxFileSN" parameterType="FileVO" resultType="java.lang.Integer">
-
- SELECT NVL(MAX(FILE_SN),0)+1 AS FILE_SN
- FROM COMTNFILEDETAIL
- WHERE ATCH_FILE_ID = #{atchFileId}
-
- </select>
-
- <select id="selectFileInf" parameterType="FileVO" resultMap="fileDetail">
-
- SELECT
- ATCH_FILE_ID, FILE_CN, FILE_SN, FILE_STRE_COURS, STRE_FILE_NM,
- FILE_EXTSN, ORIGNL_FILE_NM, FILE_SIZE
- FROM
- COMTNFILEDETAIL
- WHERE
- ATCH_FILE_ID = #{atchFileId}
- AND
- FILE_SN = #{fileSn}
-
- </select>
-
- <update id="deleteCOMTNFILE" parameterType="FileVO">
-
- UPDATE COMTNFILE
- SET USE_AT = 'N'
- WHERE ATCH_FILE_ID = #{atchFileId}
-
- </update>
-
- <select id="selectFileListByFileNm" parameterType="FileVO" resultMap="fileList">
-
- SELECT * FROM ( SELECT rownum rn, TB.* FROM (
- SELECT
- a.ATCH_FILE_ID, b.FILE_CN, b.FILE_SN, b.FILE_STRE_COURS, b.STRE_FILE_NM,
- b.FILE_EXTSN, b.ORIGNL_FILE_NM, b.FILE_SIZE, a.CREAT_DT
- FROM
- COMTNFILE a, COMTNFILEDETAIL b
- WHERE
- a.ATCH_FILE_ID = b.ATCH_FILE_ID
- AND
- a.USE_AT = 'Y'
-
- <if test="searchCnd == 'streFileNm'">AND
- b.STRE_FILE_NM LIKE '%' || #{searchWrd} || '%'
- </if>
- <if test="searchCnd == 'orignlFileNm'">AND
- b.ORIGNL_FILE_NM LIKE '%' || #{searchWrd} || '%'
- </if>
-
- ORDER BY a.ATCH_FILE_ID, b.FILE_SN
- ) TB ) Z WHERE rn BETWEEN #{firstIndex} + 1 AND #{firstIndex} + #{recordCountPerPage}
-
- </select>
-
- <select id="selectFileListCntByFileNm" parameterType="FileVO" resultType="java.lang.Integer">
-
- SELECT
- COUNT(a.ATCH_FILE_ID)
- FROM
- COMTNFILE a, COMTNFILEDETAIL b
- WHERE
- a.ATCH_FILE_ID = b.ATCH_FILE_ID
- AND
- a.USE_AT = 'Y'
-
- <if test="searchCnd == 'streFileNm'">AND
- b.STRE_FILE_NM LIKE '%' || #{searchWrd} || '%'
- </if>
- <if test="searchCnd == 'orignlFileNm'">AND
- b.ORIGNL_FILE_NM LIKE '%' || #{searchWrd} || '%'
- </if>
- </select>
-
- <select id="selectImageFileList" parameterType="FileVO" resultMap="fileList">
-
- SELECT
- a.ATCH_FILE_ID, b.FILE_CN, b.FILE_SN, b.FILE_STRE_COURS, b.STRE_FILE_NM,
- b.FILE_EXTSN, b.ORIGNL_FILE_NM, b.FILE_SIZE, a.CREAT_DT
- FROM
- COMTNFILE a, COMTNFILEDETAIL b
- WHERE
- a.ATCH_FILE_ID = #{atchFileId}
- AND
- a.ATCH_FILE_ID = b.ATCH_FILE_ID
- AND
- UPPER(b.FILE_EXTSN) IN ('GIF','JPG','BMP','PNG')
- AND
- a.USE_AT = 'Y'
- ORDER BY b.FILE_SN
-
- </select>
-
-</mapper>
\ No newline at end of file
Index: base3.10/src/main/resources/egovframework/mapper/com/cmm/fms/EgovFile_SQL_oracle.xml
===================================================================
--- base3.10/src/main/resources/egovframework/mapper/com/cmm/fms/EgovFile_SQL_oracle.xml (revision 79)
+++ base3.10/src/main/resources/egovframework/mapper/com/cmm/fms/EgovFile_SQL_oracle.xml (nonexistent)
@@ -1,170 +0,0 @@
-<?xml version="1.0" encoding="UTF-8"?><!--Converted at: Wed May 11 15:49:38 KST 2016-->
-<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
-"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
-<mapper namespace="FileManageDAO">
-
- <resultMap id="fileList" type="egovframework.com.cmm.service.FileVO">
- <result property="atchFileId" column="ATCH_FILE_ID"/>
- <result property="fileCn" column="FILE_CN"/>
- <result property="fileExtsn" column="FILE_EXTSN"/>
- <result property="fileMg" column="FILE_SIZE"/>
- <result property="fileSn" column="FILE_SN"/>
- <result property="fileStreCours" column="FILE_STRE_COURS"/>
- <result property="orignlFileNm" column="ORIGNL_FILE_NM"/>
- <result property="streFileNm" column="STRE_FILE_NM"/>
- <result property="creatDt" column="CREAT_DT"/>
- </resultMap>
-
- <resultMap id="fileDetail" type="egovframework.com.cmm.service.FileVO">
- <result property="atchFileId" column="ATCH_FILE_ID"/>
- <result property="fileCn" column="FILE_CN"/>
- <result property="fileExtsn" column="FILE_EXTSN"/>
- <result property="fileMg" column="FILE_SIZE"/>
- <result property="fileSn" column="FILE_SN"/>
- <result property="fileStreCours" column="FILE_STRE_COURS"/>
- <result property="orignlFileNm" column="ORIGNL_FILE_NM"/>
- <result property="streFileNm" column="STRE_FILE_NM"/>
- </resultMap>
-
-
- <select id="selectFileList" parameterType="FileVO" resultMap="fileList">
-
- SELECT
- a.ATCH_FILE_ID, b.FILE_CN, b.FILE_SN, b.FILE_STRE_COURS, b.STRE_FILE_NM,
- b.FILE_EXTSN, b.ORIGNL_FILE_NM, b.FILE_SIZE, a.CREAT_DT
- FROM
- COMTNFILE a, COMTNFILEDETAIL b
- WHERE
- a.ATCH_FILE_ID = #{atchFileId}
- AND
- a.ATCH_FILE_ID = b.ATCH_FILE_ID
- AND
- a.USE_AT = 'Y'
- ORDER BY b.FILE_SN
-
- </select>
-
- <insert id="insertFileMaster" parameterType="FileVO">
-
- INSERT INTO COMTNFILE
- (ATCH_FILE_ID, CREAT_DT, USE_AT)
- VALUES
- ( #{atchFileId}, SYSDATE, 'Y')
-
- </insert>
-
- <insert id="insertFileDetail" parameterType="FileVO">
-
- INSERT INTO COMTNFILEDETAIL
- ( ATCH_FILE_ID, FILE_SN, FILE_STRE_COURS, STRE_FILE_NM,
- ORIGNL_FILE_NM, FILE_EXTSN, FILE_SIZE, FILE_CN )
- VALUES
- ( #{atchFileId}, #{fileSn}, #{fileStreCours}, #{streFileNm},
- #{orignlFileNm}, #{fileExtsn}, #{fileMg}, #{fileCn} )
-
- </insert>
-
- <delete id="deleteFileDetail" parameterType="FileVO">
-
- DELETE FROM COMTNFILEDETAIL
- WHERE
- ATCH_FILE_ID = #{atchFileId}
- AND
- FILE_SN = #{fileSn}
-
- </delete>
-
- <select id="getMaxFileSN" parameterType="FileVO" resultType="java.lang.Integer">
-
- SELECT NVL(MAX(FILE_SN),0)+1 AS FILE_SN
- FROM COMTNFILEDETAIL
- WHERE ATCH_FILE_ID = #{atchFileId}
-
- </select>
-
- <select id="selectFileInf" parameterType="FileVO" resultMap="fileDetail">
-
- SELECT
- ATCH_FILE_ID, FILE_CN, FILE_SN, FILE_STRE_COURS, STRE_FILE_NM,
- FILE_EXTSN, ORIGNL_FILE_NM, FILE_SIZE
- FROM
- COMTNFILEDETAIL
- WHERE
- ATCH_FILE_ID = #{atchFileId}
- AND
- FILE_SN = #{fileSn}
-
- </select>
-
- <update id="deleteCOMTNFILE" parameterType="FileVO">
-
- UPDATE COMTNFILE
- SET USE_AT = 'N'
- WHERE ATCH_FILE_ID = #{atchFileId}
-
- </update>
-
- <select id="selectFileListByFileNm" parameterType="FileVO" resultMap="fileList">
-
- SELECT * FROM ( SELECT rownum rn, TB.* FROM (
- SELECT
- a.ATCH_FILE_ID, b.FILE_CN, b.FILE_SN, b.FILE_STRE_COURS, b.STRE_FILE_NM,
- b.FILE_EXTSN, b.ORIGNL_FILE_NM, b.FILE_SIZE, a.CREAT_DT
- FROM
- COMTNFILE a, COMTNFILEDETAIL b
- WHERE
- a.ATCH_FILE_ID = b.ATCH_FILE_ID
- AND
- a.USE_AT = 'Y'
-
- <if test="searchCnd == 'streFileNm'">AND
- b.STRE_FILE_NM LIKE '%' || #{searchWrd} || '%'
- </if>
- <if test="searchCnd == 'orignlFileNm'">AND
- b.ORIGNL_FILE_NM LIKE '%' || #{searchWrd} || '%'
- </if>
-
- ORDER BY a.ATCH_FILE_ID, b.FILE_SN
- ) TB ) WHERE rn BETWEEN #{firstIndex} + 1 AND #{firstIndex} + #{recordCountPerPage}
-
- </select>
-
- <select id="selectFileListCntByFileNm" parameterType="FileVO" resultType="java.lang.Integer">
-
- SELECT
- COUNT(a.ATCH_FILE_ID)
- FROM
- COMTNFILE a, COMTNFILEDETAIL b
- WHERE
- a.ATCH_FILE_ID = b.ATCH_FILE_ID
- AND
- a.USE_AT = 'Y'
-
- <if test="searchCnd == 'streFileNm'">AND
- b.STRE_FILE_NM LIKE '%' || #{searchWrd} || '%'
- </if>
- <if test="searchCnd == 'orignlFileNm'">AND
- b.ORIGNL_FILE_NM LIKE '%' || #{searchWrd} || '%'
- </if>
- </select>
-
- <select id="selectImageFileList" parameterType="FileVO" resultMap="fileList">
-
- SELECT
- a.ATCH_FILE_ID, b.FILE_CN, b.FILE_SN, b.FILE_STRE_COURS, b.STRE_FILE_NM,
- b.FILE_EXTSN, b.ORIGNL_FILE_NM, b.FILE_SIZE, a.CREAT_DT
- FROM
- COMTNFILE a, COMTNFILEDETAIL b
- WHERE
- a.ATCH_FILE_ID = #{atchFileId}
- AND
- a.ATCH_FILE_ID = b.ATCH_FILE_ID
- AND
- UPPER(b.FILE_EXTSN) IN ('GIF','JPG','BMP','PNG')
- AND
- a.USE_AT = 'Y'
- ORDER BY b.FILE_SN
-
- </select>
-
-</mapper>
\ No newline at end of file
Index: base3.10/src/main/resources/egovframework/mapper/com/cmm/fms/EgovFile_SQL_maria.xml
===================================================================
--- base3.10/src/main/resources/egovframework/mapper/com/cmm/fms/EgovFile_SQL_maria.xml (revision 79)
+++ base3.10/src/main/resources/egovframework/mapper/com/cmm/fms/EgovFile_SQL_maria.xml (nonexistent)
@@ -1,169 +0,0 @@
-<?xml version="1.0" encoding="UTF-8"?><!--Converted at: Wed May 11 15:49:38 KST 2016-->
-<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
-"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
-<mapper namespace="FileManageDAO">
-
- <resultMap id="fileList" type="egovframework.com.cmm.service.FileVO">
- <result property="atchFileId" column="ATCH_FILE_ID"/>
- <result property="fileCn" column="FILE_CN"/>
- <result property="fileExtsn" column="FILE_EXTSN"/>
- <result property="fileMg" column="FILE_SIZE"/>
- <result property="fileSn" column="FILE_SN"/>
- <result property="fileStreCours" column="FILE_STRE_COURS"/>
- <result property="orignlFileNm" column="ORIGNL_FILE_NM"/>
- <result property="streFileNm" column="STRE_FILE_NM"/>
- <result property="creatDt" column="CREAT_DT"/>
- </resultMap>
-
- <resultMap id="fileDetail" type="egovframework.com.cmm.service.FileVO">
- <result property="atchFileId" column="ATCH_FILE_ID"/>
- <result property="fileCn" column="FILE_CN"/>
- <result property="fileExtsn" column="FILE_EXTSN"/>
- <result property="fileMg" column="FILE_SIZE"/>
- <result property="fileSn" column="FILE_SN"/>
- <result property="fileStreCours" column="FILE_STRE_COURS"/>
- <result property="orignlFileNm" column="ORIGNL_FILE_NM"/>
- <result property="streFileNm" column="STRE_FILE_NM"/>
- </resultMap>
-
-
- <select id="selectFileList" parameterType="FileVO" resultMap="fileList">
-
- SELECT
- a.ATCH_FILE_ID, b.FILE_CN, b.FILE_SN, b.FILE_STRE_COURS, b.STRE_FILE_NM,
- b.FILE_EXTSN, b.ORIGNL_FILE_NM, b.FILE_SIZE, a.CREAT_DT
- FROM
- COMTNFILE a, COMTNFILEDETAIL b
- WHERE
- a.ATCH_FILE_ID = #{atchFileId}
- AND
- a.ATCH_FILE_ID = b.ATCH_FILE_ID
- AND
- a.USE_AT = 'Y'
- ORDER BY b.FILE_SN
-
- </select>
-
- <insert id="insertFileMaster" parameterType="FileVO">
-
- INSERT INTO COMTNFILE
- (ATCH_FILE_ID, CREAT_DT, USE_AT)
- VALUES
- ( #{atchFileId}, SYSDATE(), 'Y')
-
- </insert>
-
- <insert id="insertFileDetail" parameterType="FileVO">
-
- INSERT INTO COMTNFILEDETAIL
- ( ATCH_FILE_ID, FILE_SN, FILE_STRE_COURS, STRE_FILE_NM,
- ORIGNL_FILE_NM, FILE_EXTSN, FILE_SIZE, FILE_CN )
- VALUES
- ( #{atchFileId}, #{fileSn}, #{fileStreCours}, #{streFileNm},
- #{orignlFileNm}, #{fileExtsn}, #{fileMg}, #{fileCn} )
-
- </insert>
-
- <delete id="deleteFileDetail" parameterType="FileVO">
-
- DELETE FROM COMTNFILEDETAIL
- WHERE
- ATCH_FILE_ID = #{atchFileId}
- AND
- FILE_SN = #{fileSn}
-
- </delete>
-
- <select id="getMaxFileSN" parameterType="FileVO" resultType="java.lang.Integer">
-
- SELECT IFNULL(MAX(FILE_SN),0)+1 AS FILE_SN
- FROM COMTNFILEDETAIL
- WHERE ATCH_FILE_ID = #{atchFileId}
-
- </select>
-
- <select id="selectFileInf" parameterType="FileVO" resultMap="fileDetail">
-
- SELECT
- ATCH_FILE_ID, FILE_CN, FILE_SN, FILE_STRE_COURS, STRE_FILE_NM,
- FILE_EXTSN, ORIGNL_FILE_NM, FILE_SIZE
- FROM
- COMTNFILEDETAIL
- WHERE
- ATCH_FILE_ID = #{atchFileId}
- AND
- FILE_SN = #{fileSn}
-
- </select>
-
- <update id="deleteCOMTNFILE" parameterType="FileVO">
-
- UPDATE COMTNFILE
- SET USE_AT = 'N'
- WHERE ATCH_FILE_ID = #{atchFileId}
-
- </update>
-
- <select id="selectFileListByFileNm" parameterType="FileVO" resultMap="fileList">
-
- SELECT
- a.ATCH_FILE_ID, b.FILE_CN, b.FILE_SN, b.FILE_STRE_COURS, b.STRE_FILE_NM,
- b.FILE_EXTSN, b.ORIGNL_FILE_NM, b.FILE_SIZE, a.CREAT_DT
- FROM
- COMTNFILE a, COMTNFILEDETAIL b
- WHERE
- a.ATCH_FILE_ID = b.ATCH_FILE_ID
- AND
- a.USE_AT = 'Y'
-
- <if test="searchCnd == 'streFileNm'">AND
- b.STRE_FILE_NM LIKE CONCAT ('%', #{searchWrd},'%')
- </if>
- <if test="searchCnd == 'orignlFileNm'">AND
- b.ORIGNL_FILE_NM LIKE CONCAT ('%', #{searchWrd},'%')
- </if>
-
- ORDER BY a.ATCH_FILE_ID, b.FILE_SN
- LIMIT #{recordCountPerPage} OFFSET #{firstIndex}
-
- </select>
-
- <select id="selectFileListCntByFileNm" parameterType="FileVO" resultType="java.lang.Integer">
-
- SELECT
- COUNT(a.ATCH_FILE_ID)
- FROM
- COMTNFILE a, COMTNFILEDETAIL b
- WHERE
- a.ATCH_FILE_ID = b.ATCH_FILE_ID
- AND
- a.USE_AT = 'Y'
-
- <if test="searchCnd == 'streFileNm'">AND
- b.STRE_FILE_NM LIKE CONCAT ('%', #{searchWrd},'%')
- </if>
- <if test="searchCnd == 'orignlFileNm'">AND
- b.ORIGNL_FILE_NM LIKE CONCAT ('%', #{searchWrd},'%')
- </if>
- </select>
-
- <select id="selectImageFileList" parameterType="FileVO" resultMap="fileList">
-
- SELECT
- a.ATCH_FILE_ID, b.FILE_CN, b.FILE_SN, b.FILE_STRE_COURS, b.STRE_FILE_NM,
- b.FILE_EXTSN, b.ORIGNL_FILE_NM, b.FILE_SIZE, a.CREAT_DT
- FROM
- COMTNFILE a, COMTNFILEDETAIL b
- WHERE
- a.ATCH_FILE_ID = #{atchFileId}
- AND
- a.ATCH_FILE_ID = b.ATCH_FILE_ID
- AND
- UPPER(b.FILE_EXTSN) IN ('GIF','JPG','BMP','PNG')
- AND
- a.USE_AT = 'Y'
- ORDER BY b.FILE_SN
-
- </select>
-
-</mapper>
\ No newline at end of file
Index: base3.10/src/main/resources/egovframework/mapper/com/cmm/fms/EgovFile_SQL_altibase.xml
===================================================================
--- base3.10/src/main/resources/egovframework/mapper/com/cmm/fms/EgovFile_SQL_altibase.xml (revision 79)
+++ base3.10/src/main/resources/egovframework/mapper/com/cmm/fms/EgovFile_SQL_altibase.xml (nonexistent)
@@ -1,170 +0,0 @@
-<?xml version="1.0" encoding="UTF-8"?><!--Converted at: Wed May 11 15:49:38 KST 2016-->
-<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
-"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
-<mapper namespace="FileManageDAO">
-
- <resultMap id="fileList" type="egovframework.com.cmm.service.FileVO">
- <result property="atchFileId" column="ATCH_FILE_ID"/>
- <result property="fileCn" column="FILE_CN"/>
- <result property="fileExtsn" column="FILE_EXTSN"/>
- <result property="fileMg" column="FILE_SIZE"/>
- <result property="fileSn" column="FILE_SN"/>
- <result property="fileStreCours" column="FILE_STRE_COURS"/>
- <result property="orignlFileNm" column="ORIGNL_FILE_NM"/>
- <result property="streFileNm" column="STRE_FILE_NM"/>
- <result property="creatDt" column="CREAT_DT"/>
- </resultMap>
-
- <resultMap id="fileDetail" type="egovframework.com.cmm.service.FileVO">
- <result property="atchFileId" column="ATCH_FILE_ID"/>
- <result property="fileCn" column="FILE_CN"/>
- <result property="fileExtsn" column="FILE_EXTSN"/>
- <result property="fileMg" column="FILE_SIZE"/>
- <result property="fileSn" column="FILE_SN"/>
- <result property="fileStreCours" column="FILE_STRE_COURS"/>
- <result property="orignlFileNm" column="ORIGNL_FILE_NM"/>
- <result property="streFileNm" column="STRE_FILE_NM"/>
- </resultMap>
-
-
- <select id="selectFileList" parameterType="FileVO" resultMap="fileList">
-
- SELECT
- a.ATCH_FILE_ID, b.FILE_CN, b.FILE_SN, b.FILE_STRE_COURS, b.STRE_FILE_NM,
- b.FILE_EXTSN, b.ORIGNL_FILE_NM, b.FILE_SIZE, a.CREAT_DT
- FROM
- COMTNFILE a, COMTNFILEDETAIL b
- WHERE
- a.ATCH_FILE_ID = #{atchFileId}
- AND
- a.ATCH_FILE_ID = b.ATCH_FILE_ID
- AND
- a.USE_AT = 'Y'
- ORDER BY b.FILE_SN
-
- </select>
-
- <insert id="insertFileMaster" parameterType="FileVO">
-
- INSERT INTO COMTNFILE
- (ATCH_FILE_ID, CREAT_DT, USE_AT)
- VALUES
- ( #{atchFileId}, SYSDATE, 'Y')
-
- </insert>
-
- <insert id="insertFileDetail" parameterType="FileVO">
-
- INSERT INTO COMTNFILEDETAIL
- ( ATCH_FILE_ID, FILE_SN, FILE_STRE_COURS, STRE_FILE_NM,
- ORIGNL_FILE_NM, FILE_EXTSN, FILE_SIZE, FILE_CN )
- VALUES
- ( #{atchFileId}, #{fileSn}, #{fileStreCours}, #{streFileNm},
- #{orignlFileNm}, #{fileExtsn}, #{fileMg}, #{fileCn} )
-
- </insert>
-
- <delete id="deleteFileDetail" parameterType="FileVO">
-
- DELETE FROM COMTNFILEDETAIL
- WHERE
- ATCH_FILE_ID = #{atchFileId}
- AND
- FILE_SN = #{fileSn}
-
- </delete>
-
- <select id="getMaxFileSN" parameterType="FileVO" resultType="java.lang.Integer">
-
- SELECT NVL(MAX(FILE_SN),0)+1 AS FILE_SN
- FROM COMTNFILEDETAIL
- WHERE ATCH_FILE_ID = #{atchFileId}
-
- </select>
-
- <select id="selectFileInf" parameterType="FileVO" resultMap="fileDetail">
-
- SELECT
- ATCH_FILE_ID, FILE_CN, FILE_SN, FILE_STRE_COURS, STRE_FILE_NM,
- FILE_EXTSN, ORIGNL_FILE_NM, FILE_SIZE
- FROM
- COMTNFILEDETAIL
- WHERE
- ATCH_FILE_ID = #{atchFileId}
- AND
- FILE_SN = #{fileSn}
-
- </select>
-
- <update id="deleteCOMTNFILE" parameterType="FileVO">
-
- UPDATE COMTNFILE
- SET USE_AT = 'N'
- WHERE ATCH_FILE_ID = #{atchFileId}
-
- </update>
-
- <select id="selectFileListByFileNm" parameterType="FileVO" resultMap="fileList">
-
- SELECT * FROM ( SELECT rownum rn, TB.* FROM (
- SELECT
- a.ATCH_FILE_ID, b.FILE_CN, b.FILE_SN, b.FILE_STRE_COURS, b.STRE_FILE_NM,
- b.FILE_EXTSN, b.ORIGNL_FILE_NM, b.FILE_SIZE, a.CREAT_DT
- FROM
- COMTNFILE a, COMTNFILEDETAIL b
- WHERE
- a.ATCH_FILE_ID = b.ATCH_FILE_ID
- AND
- a.USE_AT = 'Y'
-
- <if test="searchCnd == 'streFileNm'">AND
- b.STRE_FILE_NM LIKE '%' || #{searchWrd} || '%'
- </if>
- <if test="searchCnd == 'orignlFileNm'">AND
- b.ORIGNL_FILE_NM LIKE '%' || #{searchWrd} || '%'
- </if>
-
- ORDER BY a.ATCH_FILE_ID, b.FILE_SN
- ) TB ) WHERE rn BETWEEN #{firstIndex} + 1 AND #{firstIndex} + #{recordCountPerPage}
-
- </select>
-
- <select id="selectFileListCntByFileNm" parameterType="FileVO" resultType="java.lang.Integer">
-
- SELECT
- COUNT(a.ATCH_FILE_ID) as cnt
- FROM
- COMTNFILE a, COMTNFILEDETAIL b
- WHERE
- a.ATCH_FILE_ID = b.ATCH_FILE_ID
- AND
- a.USE_AT = 'Y'
-
- <if test="searchCnd == 'streFileNm'">AND
- b.STRE_FILE_NM LIKE '%' || #{searchWrd} || '%'
- </if>
- <if test="searchCnd == 'orignlFileNm'">AND
- b.ORIGNL_FILE_NM LIKE '%' || #{searchWrd} || '%'
- </if>
- </select>
-
- <select id="selectImageFileList" parameterType="FileVO" resultMap="fileList">
-
- SELECT
- a.ATCH_FILE_ID, b.FILE_CN, b.FILE_SN, b.FILE_STRE_COURS, b.STRE_FILE_NM,
- b.FILE_EXTSN, b.ORIGNL_FILE_NM, b.FILE_SIZE, a.CREAT_DT
- FROM
- COMTNFILE a, COMTNFILEDETAIL b
- WHERE
- a.ATCH_FILE_ID = #{atchFileId}
- AND
- a.ATCH_FILE_ID = b.ATCH_FILE_ID
- AND
- UPPER(b.FILE_EXTSN) IN ('GIF','JPG','BMP','PNG')
- AND
- a.USE_AT = 'Y'
- ORDER BY b.FILE_SN
-
- </select>
-
-</mapper>
\ No newline at end of file
Index: base3.10/src/main/resources/egovframework/mapper/com/cmm/fms/EgovFile_SQL_tibero.xml
===================================================================
--- base3.10/src/main/resources/egovframework/mapper/com/cmm/fms/EgovFile_SQL_tibero.xml (revision 79)
+++ base3.10/src/main/resources/egovframework/mapper/com/cmm/fms/EgovFile_SQL_tibero.xml (nonexistent)
@@ -1,170 +0,0 @@
-<?xml version="1.0" encoding="UTF-8"?><!--Converted at: Wed May 11 15:49:38 KST 2016-->
-<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
-"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
-<mapper namespace="FileManageDAO">
-
- <resultMap id="fileList" type="egovframework.com.cmm.service.FileVO">
- <result property="atchFileId" column="ATCH_FILE_ID"/>
- <result property="fileCn" column="FILE_CN"/>
- <result property="fileExtsn" column="FILE_EXTSN"/>
- <result property="fileMg" column="FILE_SIZE"/>
- <result property="fileSn" column="FILE_SN"/>
- <result property="fileStreCours" column="FILE_STRE_COURS"/>
- <result property="orignlFileNm" column="ORIGNL_FILE_NM"/>
- <result property="streFileNm" column="STRE_FILE_NM"/>
- <result property="creatDt" column="CREAT_DT"/>
- </resultMap>
-
- <resultMap id="fileDetail" type="egovframework.com.cmm.service.FileVO">
- <result property="atchFileId" column="ATCH_FILE_ID"/>
- <result property="fileCn" column="FILE_CN"/>
- <result property="fileExtsn" column="FILE_EXTSN"/>
- <result property="fileMg" column="FILE_SIZE"/>
- <result property="fileSn" column="FILE_SN"/>
- <result property="fileStreCours" column="FILE_STRE_COURS"/>
- <result property="orignlFileNm" column="ORIGNL_FILE_NM"/>
- <result property="streFileNm" column="STRE_FILE_NM"/>
- </resultMap>
-
-
- <select id="selectFileList" parameterType="FileVO" resultMap="fileList">
-
- SELECT
- a.ATCH_FILE_ID, b.FILE_CN, b.FILE_SN, b.FILE_STRE_COURS, b.STRE_FILE_NM,
- b.FILE_EXTSN, b.ORIGNL_FILE_NM, b.FILE_SIZE, a.CREAT_DT
- FROM
- COMTNFILE a, COMTNFILEDETAIL b
- WHERE
- a.ATCH_FILE_ID = #{atchFileId}
- AND
- a.ATCH_FILE_ID = b.ATCH_FILE_ID
- AND
- a.USE_AT = 'Y'
- ORDER BY b.FILE_SN
-
- </select>
-
- <insert id="insertFileMaster" parameterType="FileVO">
-
- INSERT INTO COMTNFILE
- (ATCH_FILE_ID, CREAT_DT, USE_AT)
- VALUES
- ( #{atchFileId}, SYSDATE, 'Y')
-
- </insert>
-
- <insert id="insertFileDetail" parameterType="FileVO">
-
- INSERT INTO COMTNFILEDETAIL
- ( ATCH_FILE_ID, FILE_SN, FILE_STRE_COURS, STRE_FILE_NM,
- ORIGNL_FILE_NM, FILE_EXTSN, FILE_SIZE, FILE_CN )
- VALUES
- ( #{atchFileId}, #{fileSn}, #{fileStreCours}, #{streFileNm},
- #{orignlFileNm}, #{fileExtsn}, #{fileMg}, #{fileCn} )
-
- </insert>
-
- <delete id="deleteFileDetail" parameterType="FileVO">
-
- DELETE FROM COMTNFILEDETAIL
- WHERE
- ATCH_FILE_ID = #{atchFileId}
- AND
- FILE_SN = #{fileSn}
-
- </delete>
-
- <select id="getMaxFileSN" parameterType="FileVO" resultType="java.lang.Integer">
-
- SELECT NVL(MAX(FILE_SN),0)+1 AS FILE_SN
- FROM COMTNFILEDETAIL
- WHERE ATCH_FILE_ID = #{atchFileId}
-
- </select>
-
- <select id="selectFileInf" parameterType="FileVO" resultMap="fileDetail">
-
- SELECT
- ATCH_FILE_ID, FILE_CN, FILE_SN, FILE_STRE_COURS, STRE_FILE_NM,
- FILE_EXTSN, ORIGNL_FILE_NM, FILE_SIZE
- FROM
- COMTNFILEDETAIL
- WHERE
- ATCH_FILE_ID = #{atchFileId}
- AND
- FILE_SN = #{fileSn}
-
- </select>
-
- <update id="deleteCOMTNFILE" parameterType="FileVO">
-
- UPDATE COMTNFILE
- SET USE_AT = 'N'
- WHERE ATCH_FILE_ID = #{atchFileId}
-
- </update>
-
- <select id="selectFileListByFileNm" parameterType="FileVO" resultMap="fileList">
-
- SELECT * FROM ( SELECT rownum rn, TB.* FROM (
- SELECT
- a.ATCH_FILE_ID, b.FILE_CN, b.FILE_SN, b.FILE_STRE_COURS, b.STRE_FILE_NM,
- b.FILE_EXTSN, b.ORIGNL_FILE_NM, b.FILE_SIZE, a.CREAT_DT
- FROM
- COMTNFILE a, COMTNFILEDETAIL b
- WHERE
- a.ATCH_FILE_ID = b.ATCH_FILE_ID
- AND
- a.USE_AT = 'Y'
-
- <if test="searchCnd == 'streFileNm'">AND
- b.STRE_FILE_NM LIKE '%' || #{searchWrd} || '%'
- </if>
- <if test="searchCnd == 'orignlFileNm'">AND
- b.ORIGNL_FILE_NM LIKE '%' || #{searchWrd} || '%'
- </if>
-
- ORDER BY a.ATCH_FILE_ID, b.FILE_SN
- ) TB ) WHERE rn BETWEEN #{firstIndex} + 1 AND #{firstIndex} + #{recordCountPerPage}
-
- </select>
-
- <select id="selectFileListCntByFileNm" parameterType="FileVO" resultType="java.lang.Integer">
-
- SELECT
- COUNT(a.ATCH_FILE_ID)
- FROM
- COMTNFILE a, COMTNFILEDETAIL b
- WHERE
- a.ATCH_FILE_ID = b.ATCH_FILE_ID
- AND
- a.USE_AT = 'Y'
-
- <if test="searchCnd == 'streFileNm'">AND
- b.STRE_FILE_NM LIKE '%' || #{searchWrd} || '%'
- </if>
- <if test="searchCnd == 'orignlFileNm'">AND
- b.ORIGNL_FILE_NM LIKE '%' || #{searchWrd} || '%'
- </if>
- </select>
-
- <select id="selectImageFileList" parameterType="FileVO" resultMap="fileList">
-
- SELECT
- a.ATCH_FILE_ID, b.FILE_CN, b.FILE_SN, b.FILE_STRE_COURS, b.STRE_FILE_NM,
- b.FILE_EXTSN, b.ORIGNL_FILE_NM, b.FILE_SIZE, a.CREAT_DT
- FROM
- COMTNFILE a, COMTNFILEDETAIL b
- WHERE
- a.ATCH_FILE_ID = #{atchFileId}
- AND
- a.ATCH_FILE_ID = b.ATCH_FILE_ID
- AND
- UPPER(b.FILE_EXTSN) IN ('GIF','JPG','BMP','PNG')
- AND
- a.USE_AT = 'Y'
- ORDER BY b.FILE_SN
-
- </select>
-
-</mapper>
\ No newline at end of file
Index: base3.10/src/main/resources/egovframework/mapper/com/cmm/fms/EgovFile_SQL_postgres.xml
===================================================================
--- base3.10/src/main/resources/egovframework/mapper/com/cmm/fms/EgovFile_SQL_postgres.xml (revision 79)
+++ base3.10/src/main/resources/egovframework/mapper/com/cmm/fms/EgovFile_SQL_postgres.xml (nonexistent)
@@ -1,169 +0,0 @@
-<?xml version="1.0" encoding="UTF-8"?><!--Converted at: Wed May 11 15:49:38 KST 2016-->
-<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
-"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
-<mapper namespace="FileManageDAO">
-
- <resultMap id="fileList" type="egovframework.com.cmm.service.FileVO">
- <result property="atchFileId" column="ATCH_FILE_ID"/>
- <result property="fileCn" column="FILE_CN"/>
- <result property="fileExtsn" column="FILE_EXTSN"/>
- <result property="fileMg" column="FILE_SIZE"/>
- <result property="fileSn" column="FILE_SN"/>
- <result property="fileStreCours" column="FILE_STRE_COURS"/>
- <result property="orignlFileNm" column="ORIGNL_FILE_NM"/>
- <result property="streFileNm" column="STRE_FILE_NM"/>
- <result property="creatDt" column="CREAT_DT"/>
- </resultMap>
-
- <resultMap id="fileDetail" type="egovframework.com.cmm.service.FileVO">
- <result property="atchFileId" column="ATCH_FILE_ID"/>
- <result property="fileCn" column="FILE_CN"/>
- <result property="fileExtsn" column="FILE_EXTSN"/>
- <result property="fileMg" column="FILE_SIZE"/>
- <result property="fileSn" column="FILE_SN"/>
- <result property="fileStreCours" column="FILE_STRE_COURS"/>
- <result property="orignlFileNm" column="ORIGNL_FILE_NM"/>
- <result property="streFileNm" column="STRE_FILE_NM"/>
- </resultMap>
-
-
- <select id="selectFileList" parameterType="FileVO" resultMap="fileList">
-
- SELECT
- a.ATCH_FILE_ID, b.FILE_CN, b.FILE_SN, b.FILE_STRE_COURS, b.STRE_FILE_NM,
- b.FILE_EXTSN, b.ORIGNL_FILE_NM, b.FILE_SIZE, a.CREAT_DT
- FROM
- COMTNFILE a, COMTNFILEDETAIL b
- WHERE
- a.ATCH_FILE_ID = #{atchFileId}
- AND
- a.ATCH_FILE_ID = b.ATCH_FILE_ID
- AND
- a.USE_AT = 'Y'
- ORDER BY b.FILE_SN
-
- </select>
-
- <insert id="insertFileMaster" parameterType="FileVO">
-
- INSERT INTO COMTNFILE
- (ATCH_FILE_ID, CREAT_DT, USE_AT)
- VALUES
- ( #{atchFileId}, NOW(), 'Y')
-
- </insert>
-
- <insert id="insertFileDetail" parameterType="FileVO">
-
- INSERT INTO COMTNFILEDETAIL
- ( ATCH_FILE_ID, FILE_SN, FILE_STRE_COURS, STRE_FILE_NM,
- ORIGNL_FILE_NM, FILE_EXTSN, FILE_SIZE, FILE_CN )
- VALUES
- ( #{atchFileId}, CAST(#{fileSn} AS NUMERIC), #{fileStreCours}, #{streFileNm},
- #{orignlFileNm}, #{fileExtsn}, CAST(#{fileMg} AS NUMERIC), #{fileCn} )
-
- </insert>
-
- <delete id="deleteFileDetail" parameterType="FileVO">
-
- DELETE FROM COMTNFILEDETAIL
- WHERE
- ATCH_FILE_ID = #{atchFileId}
- AND
- FILE_SN = CAST(#{fileSn} AS NUMERIC)
-
- </delete>
-
- <select id="getMaxFileSN" parameterType="FileVO" resultType="java.lang.Integer">
-
- SELECT COALESCE(MAX(FILE_SN),0)+1 AS FILE_SN
- FROM COMTNFILEDETAIL
- WHERE ATCH_FILE_ID = #{atchFileId}
-
- </select>
-
- <select id="selectFileInf" parameterType="FileVO" resultMap="fileDetail">
-
- SELECT
- ATCH_FILE_ID, FILE_CN, FILE_SN, FILE_STRE_COURS, STRE_FILE_NM,
- FILE_EXTSN, ORIGNL_FILE_NM, FILE_SIZE
- FROM
- COMTNFILEDETAIL
- WHERE
- ATCH_FILE_ID = #{atchFileId}
- AND
- FILE_SN = CAST(#{fileSn} AS NUMERIC)
-
- </select>
-
- <update id="deleteCOMTNFILE" parameterType="FileVO">
-
- UPDATE COMTNFILE
- SET USE_AT = 'N'
- WHERE ATCH_FILE_ID = #{atchFileId}
-
- </update>
-
- <select id="selectFileListByFileNm" parameterType="FileVO" resultMap="fileList">
-
- SELECT
- a.ATCH_FILE_ID, b.FILE_CN, b.FILE_SN, b.FILE_STRE_COURS, b.STRE_FILE_NM,
- b.FILE_EXTSN, b.ORIGNL_FILE_NM, b.FILE_SIZE, a.CREAT_DT
- FROM
- COMTNFILE a, COMTNFILEDETAIL b
- WHERE
- a.ATCH_FILE_ID = b.ATCH_FILE_ID
- AND
- a.USE_AT = 'Y'
-
- <if test="searchCnd == 'streFileNm'">AND
- b.STRE_FILE_NM LIKE CONCAT ('%', #{searchWrd},'%')
- </if>
- <if test="searchCnd == 'orignlFileNm'">AND
- b.ORIGNL_FILE_NM LIKE CONCAT ('%', #{searchWrd},'%')
- </if>
-
- ORDER BY a.ATCH_FILE_ID, b.FILE_SN
- LIMIT #{recordCountPerPage} OFFSET #{firstIndex}
-
- </select>
-
- <select id="selectFileListCntByFileNm" parameterType="FileVO" resultType="java.lang.Integer">
-
- SELECT
- COUNT(a.ATCH_FILE_ID)
- FROM
- COMTNFILE a, COMTNFILEDETAIL b
- WHERE
- a.ATCH_FILE_ID = b.ATCH_FILE_ID
- AND
- a.USE_AT = 'Y'
-
- <if test="searchCnd == 'streFileNm'">AND
- b.STRE_FILE_NM LIKE CONCAT ('%', #{searchWrd},'%')
- </if>
- <if test="searchCnd == 'orignlFileNm'">AND
- b.ORIGNL_FILE_NM LIKE CONCAT ('%', #{searchWrd},'%')
- </if>
- </select>
-
- <select id="selectImageFileList" parameterType="FileVO" resultMap="fileList">
-
- SELECT
- a.ATCH_FILE_ID, b.FILE_CN, b.FILE_SN, b.FILE_STRE_COURS, b.STRE_FILE_NM,
- b.FILE_EXTSN, b.ORIGNL_FILE_NM, b.FILE_SIZE, a.CREAT_DT
- FROM
- COMTNFILE a, COMTNFILEDETAIL b
- WHERE
- a.ATCH_FILE_ID = #{atchFileId}
- AND
- a.ATCH_FILE_ID = b.ATCH_FILE_ID
- AND
- UPPER(b.FILE_EXTSN) IN ('GIF','JPG','BMP','PNG')
- AND
- a.USE_AT = 'Y'
- ORDER BY b.FILE_SN
-
- </select>
-
-</mapper>
\ No newline at end of file
Index: base3.10/src/main/resources/egovframework/mapper/com/uss/ion/bnr/EgovBanner_SQL_postgres.xml
===================================================================
--- base3.10/src/main/resources/egovframework/mapper/com/uss/ion/bnr/EgovBanner_SQL_postgres.xml (revision 79)
+++ base3.10/src/main/resources/egovframework/mapper/com/uss/ion/bnr/EgovBanner_SQL_postgres.xml (revision 80)
@@ -16,27 +16,14 @@
<result property="regDate" column="FRST_REGIST_PNTTM" />
</resultMap>
- <resultMap id="fileList" type="egovframework.com.cmm.service.FileVO">
- <result property="atchFileId" column="ATCH_FILE_ID" />
- <result property="fileCn" column="FILE_CN" />
- <result property="fileExtsn" column="FILE_EXTSN" />
- <result property="fileMg" column="FILE_SIZE" />
- <result property="fileSn" column="FILE_SN" />
- <result property="fileStreCours" column="FILE_STRE_COURS" />
- <result property="orignlFileNm" column="ORIGNL_FILE_NM" />
- <result property="streFileNm" column="STRE_FILE_NM" />
- <result property="creatDt" column="CREAT_DT" />
- </resultMap>
-
<resultMap id="bannerImage" type="egovframework.com.uss.ion.bnr.service.BannerVO">
<result property="bannerImageFile" column="BANNER_IMAGE_FILE" />
<result property="linkUrl" column="LINK_URL" />
<result property="bannerNm" column="BANNER_NM" />
</resultMap>
- <resultMap id="bannerImageFile" type="egovframework.com.cmm.service.FileVO">
- <result property="fileStreCours" column="FILE_STRE_COURS" />
- <result property="streFileNm" column="STRE_FILE_NM" />
+ <resultMap id="bannerImageFile" type="EditorFileVO">
+ <result property="fullPath" column="FULL_PATH" />
</resultMap>
<select id="selectBannerList" parameterType="egovframework.com.uss.ion.bnr.service.BannerVO" resultMap="banner">
@@ -149,8 +136,7 @@
<select id="selectBannerFile" parameterType="egovframework.com.uss.ion.bnr.service.BannerVO" resultMap="bannerImageFile">
<![CDATA[
- SELECT B.FULL_PATH AS FILE_STRE_COURS,
- B.SYS_FILE_NM AS STRE_FILE_NM
+ SELECT B.FULL_PATH
FROM COMTNBANNER A,
TNFILE B
WHERE 1 = 1
Index: base3.10/src/main/resources/egovframework/mapper/config/mapper-config.xml
===================================================================
--- base3.10/src/main/resources/egovframework/mapper/config/mapper-config.xml (revision 79)
+++ base3.10/src/main/resources/egovframework/mapper/config/mapper-config.xml (revision 80)
@@ -14,10 +14,10 @@
<!-- Type Aliases 설정-->
<typeAliases>
<typeAlias alias="egovMap" type="egovframework.rte.psl.dataaccess.util.EgovMap" />
- <typeAlias alias="FileVO" type="egovframework.com.cmm.service.FileVO" />
<typeAlias alias="ComDefaultCodeVO" type="egovframework.com.cmm.ComDefaultCodeVO" />
<typeAlias alias="comDefaultVO" type="egovframework.com.cmm.ComDefaultVO" />
<package name="egovframework.com"/>
+ <package name="froala.editor"/>
</typeAliases>
</configuration>
\ No newline at end of file
Index: base3.10/src/main/webapp/css/admin/admin.css
===================================================================
--- base3.10/src/main/webapp/css/admin/admin.css (revision 79)
+++ base3.10/src/main/webapp/css/admin/admin.css (revision 80)
@@ -30,7 +30,7 @@
.flex_start { justify-content:flex-start; display: -webkit-box; display: -webkit-flex; display: -moz-box; display: -ms-flexbox; display:flex; }
/*top bar*/
-.logo { width:300px; height:140px; position:absolute; top:0; left:0; z-index:9; background: url(../../images/admin/logo_v.svg) 50% 50% no-repeat; background-size:150px; text-indent:-5000px; transition:all 0.3s;}
+.logo { width:300px; height:175px; position:absolute; top:0; left:0; z-index:9; background: url(../../images/user/logo_fff.svg) 50% 50% no-repeat; background-size:240px; text-indent:-5000px; transition:all 0.3s;}
.logo a { width:100%; height:100%; display:block; text-indent:-5000px;}
.topBar { width:calc(100% - 300px); float:right; height:85px; padding:43px 30px 0 0; z-index:99999; display: -webkit-box; display: -webkit-flex; display: -moz-box; display: -ms-flexbox; display:flex; justify-content:space-between; }
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?