jhleem / egov star

임종호 임종호 2022-02-17 @80


            
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
List