Commit @31 - jhleem/egov

Files
Commit

이다솜 2022-02-14 @31

[20220214 이다솜] 배너 코밋

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 (nonexistent) +++ base3.10/src/main/java/egovframework/com/uss/ion/bnr/web/EgovBannerController.java (revision 31) @@ -0,0 +1,298 @@ +/** + * 개요 + * - 배너에 대한 controller 클래스를 정의한다. + * + * 상세내용 + * - 배너에 대한 등록, 수정, 삭제, 조회, 반영확인 기능을 제공한다. + * - 배너의 조회기능은 목록조회, 상세조회로 구분된다. + * @author lee.m.j + * @version 1.0 + * @created 03-8-2009 오후 2:07:11 + * * <pre> + * << 개정이력(Modification Information) >> + * + * 수정일 수정자 수정내용 + * ------- -------- --------------------------- + * 2009.8.3 lee.m.j 최초 생성 + * 2011.8.26 정진오 IncludedInfo annotation 추가 + * + * </pre> + */ + +package egovframework.com.uss.ion.bnr.web; + +import java.util.List; + +import javax.annotation.Resource; + +import org.springframework.beans.factory.annotation.Autowired; +import org.springframework.stereotype.Controller; +import org.springframework.ui.ModelMap; +import org.springframework.validation.BindingResult; +import org.springframework.web.bind.annotation.ModelAttribute; +import org.springframework.web.bind.annotation.RequestMapping; +import org.springframework.web.bind.annotation.RequestParam; +import org.springframework.web.bind.support.SessionStatus; +import org.springframework.web.multipart.MultipartHttpServletRequest; +import org.springframework.web.servlet.mvc.support.RedirectAttributes; +import org.springmodules.validation.commons.DefaultBeanValidator; + +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; +import egovframework.com.uss.ion.bnr.service.EgovBannerService; +import egovframework.rte.fdl.idgnr.EgovIdGnrService; +import egovframework.rte.ptl.mvc.tags.ui.pagination.PaginationInfo; + +@Controller +public class EgovBannerController { + + @Resource(name="egovMessageSource") + EgovMessageSource egovMessageSource; + +// @Resource(name="EgovFileMngService") +// private EgovFileMngService fileMngService; + +// @Resource(name="EgovFileMngUtil") +// private EgovFileMngUtil fileUtil; + + @Resource(name = "egovBannerService") + private EgovBannerService egovBannerService; + + /** Message ID Generation */ + @Resource(name="egovBannerIdGnrService") + private EgovIdGnrService egovBannerIdGnrService; + + @Autowired + private DefaultBeanValidator beanValidator; + + /** + * 배너 목록화면 이동 + * @return String + * @exception Exception + */ + @RequestMapping("/uss/ion/bnr/selectBannerListView.do") + public String selectBannerListView() throws Exception { + + return "egovframework/com/uss/ion/bnr/EgovBannerList"; + } + + /** + * 배너를 관리하기 위해 등록된 배너목록을 조회한다. + * @param bannerVO - 배너 VO + * @return String - 리턴 URL + * @throws Exception + */ +// @IncludedInfo(name="배너관리", order = 740 ,gid = 50) + @RequestMapping(value="/uss/ion/bnr/selectBannerList.do") + public String selectBannerList(@ModelAttribute("bannerVO") BannerVO bannerVO, + ModelMap model) throws Exception{ + + /** paging */ + PaginationInfo paginationInfo = new PaginationInfo(); + paginationInfo.setCurrentPageNo(bannerVO.getPageIndex()); + paginationInfo.setRecordCountPerPage(bannerVO.getPageUnit()); + paginationInfo.setPageSize(bannerVO.getPageSize()); + + bannerVO.setFirstIndex(paginationInfo.getFirstRecordIndex()); + bannerVO.setLastIndex(paginationInfo.getLastRecordIndex()); + bannerVO.setRecordCountPerPage(paginationInfo.getRecordCountPerPage()); + + bannerVO.setBannerList(egovBannerService.selectBannerList(bannerVO)); + + model.addAttribute("bannerList", bannerVO.getBannerList()); + + int totCnt = egovBannerService.selectBannerListTotCnt(bannerVO); + paginationInfo.setTotalRecordCount(totCnt); + model.addAttribute("paginationInfo", paginationInfo); + + return ".adminLayout/배너관리/com/uss/ion/bnr/EgovBannerList"; + } + + /** + * 등록된 배너의 상세정보를 조회한다. + * @param bannerVO - 배너 Vo + * @return String - 리턴 Url + */ + @RequestMapping(value="/uss/ion/bnr/getBanner.do") + public String selectBanner(@RequestParam("bannerId") String bannerId, + @ModelAttribute("bannerVO") BannerVO bannerVO, + ModelMap model) throws Exception { + + bannerVO.setBannerId(bannerId); + + model.addAttribute("banner", egovBannerService.selectBanner(bannerVO)); + return ".adminLayout/배너관리/com/uss/ion/bnr/EgovBannerUpdt"; + } + + /** + * 배너등록 화면으로 이동한다. + * @param banner - 배너 model + * @return String - 리턴 Url + */ + @RequestMapping(value="/uss/ion/bnr/addViewBanner.do") + public String insertViewBanner(@ModelAttribute("bannerVO") BannerVO bannerVO, + ModelMap model) throws Exception { + + model.addAttribute("banner", bannerVO); + return ".adminLayout/배너관리/com/uss/ion/bnr/EgovBannerRegist"; + } + + /** + * 배너정보를 신규로 등록한다. + * @param banner - 배너 model + * @return String - 리턴 Url + */ + @SuppressWarnings("unused") + @RequestMapping(value="/uss/ion/bnr/addBanner.do") + public String insertBanner(final MultipartHttpServletRequest multiRequest, + @ModelAttribute("banner") Banner banner, + @ModelAttribute("bannerVO") BannerVO bannerVO, + BindingResult bindingResult, + SessionStatus status, + ModelMap model) throws Exception { + + beanValidator.validate(banner, bindingResult); //validation 수행 + + if (bindingResult.hasErrors()) { + model.addAttribute("bannerVO", bannerVO); + return ".adminLayout/배너관리/com/uss/ion/bnr/EgovBannerRegist"; + } else { + List<FileVO> result = null; + String bannerImage = ""; + + LoginVO user = (LoginVO)EgovUserDetailsHelper.getAuthenticatedUser(); + + banner.setBannerId(egovBannerIdGnrService.getNextStringId()); + banner.setBannerImage(bannerImage); + banner.setUserId(user.getId()); + bannerVO.setBannerId(banner.getBannerId()); + status.setComplete(); + egovBannerService.insertBanner(banner, bannerVO); + + return "redirect:/uss/ion/bnr/selectBannerList.do"; + + } + } + + /** + * 기 등록된 배너정보를 수정한다. + * @param banner - 배너 model + * @return String - 리턴 Url + */ + @SuppressWarnings("unused") + @RequestMapping(value="/uss/ion/bnr/updtBanner.do") + public String updateBanner(final MultipartHttpServletRequest multiRequest, + @ModelAttribute("banner") Banner banner, + BindingResult bindingResult, + SessionStatus status, + ModelMap model) throws Exception { + beanValidator.validate(banner, bindingResult); //validation 수행 + + if (bindingResult.hasErrors()) { + model.addAttribute("bannerVO", banner); + return ".adminLayout/배너관리/com/uss/ion/bnr/EgovBannerUpdt"; + } else { + String bannerImage = ""; + + LoginVO user = (LoginVO) EgovUserDetailsHelper.getAuthenticatedUser(); + banner.setBannerImage(bannerImage); + banner.setUserId(user.getId()); + + egovBannerService.updateBanner(banner); + return "redirect:/uss/ion/bnr/selectBannerList.do"; + + } + } + + /** + * 기 등록된 배너정보를 삭제한다. + * @param banner Banner + * @return String + * @exception Exception + */ + @RequestMapping(value="/uss/ion/bnr/removeBanner.do") + public String deleteBanner(@RequestParam("bannerId") String bannerId, + @ModelAttribute("banner") Banner banner, + SessionStatus status, RedirectAttributes redirectAttributes, + ModelMap model) throws Exception { + + banner.setBannerId(bannerId); + egovBannerService.deleteBanner(banner); + status.setComplete(); + redirectAttributes.addFlashAttribute("message", egovMessageSource.getMessage("success.common.delete")); + return "redirect:/uss/ion/bnr/selectBannerList.do"; + } + + /** + * 기 등록된 배너정보목록을 일괄 삭제한다. + * @param banners String + * @param banner Banner + * @return String + * @exception Exception + */ + @RequestMapping(value="/uss/ion/bnr/removeBannerList.do") + public String deleteBannerList(@RequestParam("bannerIds") String bannerIds, + @ModelAttribute("banner") Banner banner, + SessionStatus status, + ModelMap model) throws Exception { + + String [] strBannerIds = bannerIds.split(";"); + + for(int i=0; i<strBannerIds.length;i++) { + banner.setBannerId(strBannerIds[i]); + egovBannerService.deleteBanner(banner); + } + + status.setComplete(); + model.addAttribute("message", egovMessageSource.getMessage("success.common.delete")); + return "redirect:/uss/ion/bnr/selectBannerList.do"; + } + + /** + * 배너가 특정화면에 반영된 결과를 조회한다. + * @param bannerVO - 배너 VO + * @return String - 리턴 Url + */ + @RequestMapping(value="/uss/ion/bnr/getBannerImage.do") + public String selectBannerResult(@ModelAttribute("bannerVO") BannerVO bannerVO, + ModelMap model) throws Exception { + + List<BannerVO> fileList = egovBannerService.selectBannerResult(bannerVO); + model.addAttribute("fileList", fileList); + model.addAttribute("resultType", bannerVO.getResultType()); + + return "egovframework/com/uss/ion/bnr/EgovBannerView"; + } + + /** + * MyPage에 배너정보를 제공하기 위해 목록을 조회한다. + * @param bannerVO - 배너 VO + * @return String - 리턴 URL + * @throws Exception + */ +// @IncludedInfo(name="MYPAGE배너관리", order = 741 ,gid = 50) + @RequestMapping(value="/uss/ion/bnr/selectBannerMainList.do") + public String selectBannerMainList(@ModelAttribute("bannerVO") BannerVO bannerVO, + ModelMap model) throws Exception{ + + /** paging */ + PaginationInfo paginationInfo = new PaginationInfo(); + paginationInfo.setCurrentPageNo(bannerVO.getPageIndex()); + paginationInfo.setRecordCountPerPage(5); + paginationInfo.setPageSize(bannerVO.getPageSize()); + + bannerVO.setFirstIndex(paginationInfo.getFirstRecordIndex()); + bannerVO.setLastIndex(paginationInfo.getLastRecordIndex()); + bannerVO.setRecordCountPerPage(paginationInfo.getRecordCountPerPage()); + + bannerVO.setBannerList(egovBannerService.selectBannerList(bannerVO)); + + model.addAttribute("bannerList", bannerVO.getBannerList()); + + return ".adminLayout/배너관리/com/uss/ion/bnr/EgovBannerMainList"; + } +} Property changes on: base3.10/src/main/java/egovframework/com/uss/ion/bnr/web/EgovBannerController.java ___________________________________________________________________ Added: svn:mime-type + text/plain Index: base3.10/src/main/java/egovframework/com/uss/ion/bnr/service/EgovBannerService.java =================================================================== --- base3.10/src/main/java/egovframework/com/uss/ion/bnr/service/EgovBannerService.java (nonexistent) +++ base3.10/src/main/java/egovframework/com/uss/ion/bnr/service/EgovBannerService.java (revision 31) @@ -0,0 +1,86 @@ +/** + * 개요 + * - 배너에 대한 Service Interface를 정의한다. + * + * 상세내용 + * - 배너에 대한 등록, 수정, 삭제, 조회, 반영확인 기능을 제공한다. + * - 배너의 조회기능은 목록조회, 상세조회로 구분된다. + * @author 이문준 + * @version 1.0 + * @created 03-8-2009 오후 2:07:12 + */ + +package egovframework.com.uss.ion.bnr.service; + +import java.util.List; + +public interface EgovBannerService { + + /** + * 배너를 관리하기 위해 등록된 배너목록을 조회한다. + * @param bannerVO - 배너 Vo + * @return List - 배너 목록 + * + * @param bannerVO + */ + public List<BannerVO> selectBannerList(BannerVO bannerVO) throws Exception; + + /** + * 배너목록 총 갯수를 조회한다. + * @param bannerVO - 배너 Vo + * @return int - 배너 카운트 수 + * + * @param bannerVO + */ + public int selectBannerListTotCnt(BannerVO bannerVO) throws Exception; + + /** + * 등록된 배너의 상세정보를 조회한다. + * @param bannerVO - 배너 Vo + * @return BannerVO - 배너 Vo + * + * @param bannerVO + */ + public BannerVO selectBanner(BannerVO bannerVO) throws Exception; + + /** + * 배너정보를 신규로 등록한다. + * @param banner - 배너 model + * + * @param banner + */ + public BannerVO insertBanner(Banner banner, BannerVO bannerVO) throws Exception; + + /** + * 기 등록된 배너정보를 수정한다. + * @param banner - 배너 model + * + * @param banner + */ + public void updateBanner(Banner banner) throws Exception; + + /** + * 기 등록된 배너정보를 삭제한다. + * @param banner - 배너 model + * + * @param banner + */ + public void deleteBanner(Banner banner) throws Exception; + + /** + * 기 등록된 배너정보의 이미지파일을 삭제한다. + * @param banner - 배너 model + * + * @param banner + */ + public void deleteBannerFile(Banner banner) throws Exception; + + /** + * 배너가 특정화면에 반영된 결과를 조회한다. + * @param bannerVO - 배너 Vo + * @return BannerVO - 배너 Vo + * + * @param bannerVO + */ + public List<BannerVO> selectBannerResult(BannerVO bannerVO) throws Exception; +} Property changes on: base3.10/src/main/java/egovframework/com/uss/ion/bnr/service/EgovBannerService.java ___________________________________________________________________ Added: svn:mime-type + text/plain 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 (nonexistent) +++ base3.10/src/main/java/egovframework/com/uss/ion/bnr/service/impl/EgovBannerServiceImpl.java (revision 31) @@ -0,0 +1,108 @@ +/** + * 개요 + * - 배너에 대한 ServiceImpl 클래스를 정의한다. + * + * 상세내용 + * - 배너에 대한 등록, 수정, 삭제, 조회, 반영확인 기능을 제공한다. + * - 배너의 조회기능은 목록조회, 상세조회로 구분된다. + * @author 이문준 + * @version 1.0 + * @created 03-8-2009 오후 2:07:12 + */ + +package egovframework.com.uss.ion.bnr.service.impl; + +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 javax.annotation.Resource; + +import org.springframework.stereotype.Service; + +@Service("egovBannerService") +public class EgovBannerServiceImpl extends EgovAbstractServiceImpl implements EgovBannerService { + + @Resource(name="bannerDAO") + private BannerDAO bannerDAO; + + /** + * 배너를 관리하기 위해 등록된 배너목록을 조회한다. + * @param bannerVO - 배너 VO + * @return List - 배너 목록 + */ + public List<BannerVO> selectBannerList(BannerVO bannerVO) throws Exception{ + return bannerDAO.selectBannerList(bannerVO); + } + + /** + * 배너목록 총 갯수를 조회한다. + * @param bannerVO - 배너 VO + * @return int - 배너 카운트 수 + */ + public int selectBannerListTotCnt(BannerVO bannerVO) throws Exception { + return bannerDAO.selectBannerListTotCnt(bannerVO); + } + + /** + * 등록된 배너의 상세정보를 조회한다. + * @param bannerVO - 배너 VO + * @return BannerVO - 배너 VO + */ + public BannerVO selectBanner(BannerVO bannerVO) throws Exception{ + return bannerDAO.selectBanner(bannerVO); + } + + /** + * 배너정보를 신규로 등록한다. + * @param banner - 배너 model + */ + public BannerVO insertBanner(Banner banner, BannerVO bannerVO) throws Exception{ + bannerDAO.insertBanner(banner); + bannerVO.setBannerId(banner.getBannerId()); + return selectBanner(bannerVO); + } + + /** + * 기 등록된 배너정보를 수정한다. + * @param banner - 배너 model + */ + public void updateBanner(Banner banner) throws Exception{ + bannerDAO.updateBanner(banner); + } + + /** + * 기 등록된 배너정보를 삭제한다. + * @param banner - 배너 model + */ + public void deleteBanner(Banner banner) throws Exception { + deleteBannerFile(banner); + bannerDAO.deleteBanner(banner); + } + + /** + * 기 등록된 배너정보의 이미지파일을 삭제한다. + * @param banner - 배너 model + */ + public void deleteBannerFile(Banner banner) throws Exception{ + FileVO fileVO = (FileVO)bannerDAO.selectBannerFile(banner); + File file = new File(fileVO.getFileStreCours()+fileVO.getStreFileNm()); + file.delete(); + } + + /** + * 배너가 특정화면에 반영된 결과를 조회한다. + * @param bannerVO - 배너 VO + * @return BannerVO - 배너 VO + */ + public List<BannerVO> selectBannerResult(BannerVO bannerVO) throws Exception{ + return bannerDAO.selectBannerResult(bannerVO); + } + +} \ No newline at end of file Property changes on: base3.10/src/main/java/egovframework/com/uss/ion/bnr/service/impl/EgovBannerServiceImpl.java ___________________________________________________________________ Added: svn:mime-type + text/plain 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 (nonexistent) +++ base3.10/src/main/java/egovframework/com/uss/ion/bnr/service/impl/BannerDAO.java (revision 31) @@ -0,0 +1,103 @@ +/** + * 개요 + * - 배너에 대한 DAO 클래스를 정의한다. + * + * 상세내용 + * - 배너에 대한 등록, 수정, 삭제, 조회, 반영확인 기능을 제공한다. + * - 배너의 조회기능은 목록조회, 상세조회로 구분된다. + * @author 이문준 + * @version 1.0 + * @created 03-8-2009 오후 2:07:11 + */ + +package egovframework.com.uss.ion.bnr.service.impl; + +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 org.springframework.stereotype.Repository; + +@Repository("bannerDAO") +public class BannerDAO extends EgovComAbstractDAO { + + /** + * 배너를 관리하기 위해 등록된 배너목록을 조회한다. + * @param bannerVO - 배너 Vo + * @return List - 배너 목록 + * @exception Exception + */ + public List<BannerVO> selectBannerList(BannerVO bannerVO) throws Exception { + return selectList("bannerDAO.selectBannerList", bannerVO); + } + + /** + * 배너목록 총 갯수를 조회한다. + * @param bannerVO BannerVO + * @return int + * @exception Exception + */ + public int selectBannerListTotCnt(BannerVO bannerVO) throws Exception { + return selectOne("bannerDAO.selectBannerListTotCnt", bannerVO); + } + + /** + * 등록된 배너의 상세정보를 조회한다. + * @param bannerVO - 배너 Vo + * @return BannerVO - 배너 Vo + * + * @param bannerVO + */ + public BannerVO selectBanner(BannerVO bannerVO) throws Exception { + return selectOne("bannerDAO.selectBanner", bannerVO); + } + + /** + * 배너정보를 신규로 등록한다. + * @param banner - 배너 model + */ + public void insertBanner(Banner banner) throws Exception { + insert("bannerDAO.insertBanner", banner); + } + + /** + * 기 등록된 배너정보를 수정한다. + * @param banner - 배너 model + */ + public void updateBanner(Banner banner) throws Exception { + update("bannerDAO.updateBanner", banner); + } + + /** + * 기 등록된 배너정보를 삭제한다. + * @param banner - 배너 model + * + * @param banner + */ + public void deleteBanner(Banner banner) throws Exception { + delete("bannerDAO.deleteBanner", banner); + } + + /** + * 기 등록된 배너정보의 이미지파일을 삭제하기 위해 파일정보를 조회한다. + * @param banner - 배너 model + * @return FileVO - 파일 VO + */ + public FileVO selectBannerFile(Banner banner) throws Exception { + return selectOne("bannerDAO.selectBannerFile", banner); + } + + /** + * 배너가 특정화면에 반영된 결과를 조회한다. + * @param bannerVO - 배너 VO + * @return BannerVO - 배너 VO + * @exception Exception + */ + public List<BannerVO> selectBannerResult(BannerVO bannerVO) throws Exception { + return selectList("bannerDAO.selectBannerResult", bannerVO); + } + +} Property changes on: base3.10/src/main/java/egovframework/com/uss/ion/bnr/service/impl/BannerDAO.java ___________________________________________________________________ Added: svn:mime-type + text/plain Index: base3.10/src/main/java/egovframework/com/uss/ion/bnr/service/Banner.java =================================================================== --- base3.10/src/main/java/egovframework/com/uss/ion/bnr/service/Banner.java (nonexistent) +++ base3.10/src/main/java/egovframework/com/uss/ion/bnr/service/Banner.java (revision 31) @@ -0,0 +1,200 @@ +/** + * 개요 + * - 배너에 대한 model 클래스를 정의한다. + * + * 상세내용 + * - 배너의 일련번호, 배너명, 링크URL, 배너설명, 반영여부 항목을 관리한다. + * @author 이문준 + * @version 1.0 + * @created 03-8-2009 오후 2:07:10 + */ + +package egovframework.com.uss.ion.bnr.service; + +import egovframework.com.cmm.ComDefaultVO; + +public class Banner extends ComDefaultVO { + + /** + * serialVersionUID + */ + private static final long serialVersionUID = 1L; + /** + * 배너 ID + */ + private String bannerId; + /** + * 배너 명 + */ + private String bannerNm; + /** + * 링크 URL + */ + private String linkUrl; + /** + * 배너 이미지 + */ + private String bannerImage; + /** + * 배너 이미지 파일 + */ + private String bannerImageFile; + /** + * 배너 설명 + */ + private String bannerDc; + /** + * 정렬 순서 + */ + private String sortOrdr; + /** + * 반영여부 + */ + private String reflctAt; + /** + * 사용자 ID + */ + private String userId; + /** + * 등록일자 + */ + private String regDate; + /** + * 파일첨부여부 + */ + private boolean isAtchFile; + + /** + * @return the bannerId + */ + public String getBannerId() { + return bannerId; + } + /** + * @param bannerId the bannerId to set + */ + public void setBannerId(String bannerId) { + this.bannerId = bannerId; + } + /** + * @return the bannerNm + */ + public String getBannerNm() { + return bannerNm; + } + /** + * @param bannerNm the bannerNm to set + */ + public void setBannerNm(String bannerNm) { + this.bannerNm = bannerNm; + } + /** + * @return the linkUrl + */ + public String getLinkUrl() { + return linkUrl; + } + /** + * @param linkUrl the linkUrl to set + */ + public void setLinkUrl(String linkUrl) { + this.linkUrl = linkUrl; + } + /** + * @return the bannerImage + */ + public String getBannerImage() { + return bannerImage; + } + /** + * @param bannerImage the bannerImage to set + */ + public void setBannerImage(String bannerImage) { + this.bannerImage = bannerImage; + } + /** + * @return the bannerImageFile + */ + public String getBannerImageFile() { + return bannerImageFile; + } + /** + * @param bannerImageFile the bannerImageFile to set + */ + public void setBannerImageFile(String bannerImageFile) { + this.bannerImageFile = bannerImageFile; + } + /** + * @return the bannerDc + */ + public String getBannerDc() { + return bannerDc; + } + /** + * @param bannerDc the bannerDc to set + */ + public void setBannerDc(String bannerDc) { + this.bannerDc = bannerDc; + } + /** + * @return the sortOrdr + */ + public String getSortOrdr() { + return sortOrdr; + } + /** + * @param sortOrdr the sortOrdr to set + */ + public void setSortOrdr(String sortOrdr) { + this.sortOrdr = sortOrdr; + } + /** + * @return the reflctAt + */ + public String getReflctAt() { + return reflctAt; + } + /** + * @param reflctAt the reflctAt to set + */ + public void setReflctAt(String reflctAt) { + this.reflctAt = reflctAt; + } + /** + * @return the userId + */ + public String getUserId() { + return userId; + } + /** + * @param userId the userId to set + */ + public void setUserId(String userId) { + this.userId = userId; + } + /** + * @return the regDate + */ + public String getRegDate() { + return regDate; + } + /** + * @param regDate the regDate to set + */ + public void setRegDate(String regDate) { + this.regDate = regDate; + } + /** + * @return the isAtchFile + */ + public boolean isAtchFile() { + return isAtchFile; + } + /** + * @param isAtchFile the isAtchFile to set + */ + public void setAtchFile(boolean isAtchFile) { + this.isAtchFile = isAtchFile; + } + +} Property changes on: base3.10/src/main/java/egovframework/com/uss/ion/bnr/service/Banner.java ___________________________________________________________________ Added: svn:mime-type + text/plain Index: base3.10/src/main/java/egovframework/com/uss/ion/bnr/service/BannerVO.java =================================================================== --- base3.10/src/main/java/egovframework/com/uss/ion/bnr/service/BannerVO.java (nonexistent) +++ base3.10/src/main/java/egovframework/com/uss/ion/bnr/service/BannerVO.java (revision 31) @@ -0,0 +1,102 @@ +/** + * 개요 + * - 배너에 대한 Vo 클래스를 정의한다. + * + * 상세내용 + * - 배너의 목록 항목을 관리한다. + * @author 이문준 + * @version 1.0 + * @created 03-8-2009 오후 2:07:13 + */ + +package egovframework.com.uss.ion.bnr.service; + +import java.util.ArrayList; +import java.util.List; + +public class BannerVO extends Banner { + + /** + * serialVersionUID + */ + private static final long serialVersionUID = 1L; + /** + * 배너 목록 + */ + List<BannerVO> bannerList; + /** + * 삭제대상 목록 + */ + String[] delYn; + /** + * 결과 반영 타입 + * vertical : 세로 + * horizontal : 가로 + */ + String resultType = "horizontal"; + + /** + * @return the bannerList + */ + public List<BannerVO> getBannerList() { + if (this.bannerList == null) { + return null; + } else { + List<BannerVO> list = new ArrayList<>(); + list.addAll(this.bannerList); + return list; + } + } + /** + * @param bannerList the bannerList to set + */ + public void setBannerList(List<BannerVO> bannerList) { + if (bannerList != null) { + this.bannerList = new ArrayList<BannerVO>(); + for (BannerVO vo : bannerList) { + this.bannerList.add(vo); + } + } + } + /** + * @return the delYn + */ + public String[] getDelYn() { + if (delYn == null) { + return null; + } else { + int cnt = delYn.length; + String[] list = new String[cnt]; + for (int i = 0; i < cnt; i++) { + list[i] = delYn[i]; + } + return list; + } + } + /** + * @param delYn the delYn to set + */ + public void setDelYn(String[] delYn) { + if (delYn != null) { + int cnt = delYn.length; + this.delYn = new String[cnt]; + for (int i = 0; i < cnt; i++) { + this.delYn[i] = delYn[i]; + } + } + } + /** + * @return the resultType + */ + public String getResultType() { + return resultType; + } + /** + * @param resultType the resultType to set + */ + public void setResultType(String resultType) { + this.resultType = resultType; + } + + +} Property changes on: base3.10/src/main/java/egovframework/com/uss/ion/bnr/service/BannerVO.java ___________________________________________________________________ Added: svn:mime-type + text/plain Index: base3.10/src/main/resources/egovframework/mapper/com/uss/ion/bnr/EgovBanner_SQL_mysql.xml =================================================================== --- base3.10/src/main/resources/egovframework/mapper/com/uss/ion/bnr/EgovBanner_SQL_mysql.xml (nonexistent) +++ base3.10/src/main/resources/egovframework/mapper/com/uss/ion/bnr/EgovBanner_SQL_mysql.xml (revision 31) @@ -0,0 +1,161 @@ +<?xml version="1.0" encoding="UTF-8"?> +<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> + +<mapper namespace="bannerDAO"> + + <resultMap id="banner" type="egovframework.com.uss.ion.bnr.service.BannerVO"> + <result property="bannerId" column="BANNER_ID" /> + <result property="bannerNm" column="BANNER_NM" /> + <result property="linkUrl" column="LINK_URL" /> + <result property="bannerImage" column="BANNER_IMAGE" /> + <result property="bannerImageFile" column="BANNER_IMAGE_FILE" /> + <result property="bannerDc" column="BANNER_DC" /> + <result property="sortOrdr" column="SORT_ORDR" /> + <result property="reflctAt" column="REFLCT_AT" /> + <result property="userId" column="FRST_REGISTER_ID" /> + <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> + + <select id="selectBannerList" parameterType="egovframework.com.uss.ion.bnr.service.BannerVO" resultMap="banner"> + <![CDATA[ + SELECT BANNER_ID, + BANNER_NM, + LINK_URL, + BANNER_IMAGE, + BANNER_IMAGE_FILE, + BANNER_DC, + SORT_ORDR, + REFLCT_AT, + FRST_REGISTER_ID, + FRST_REGIST_PNTTM + FROM COMTNBANNER + WHERE 1=1 + ]]> + <if test="searchCondition != null and searchCondition == 1" > + AND BANNER_NM LIKE CONCAT('%' , #{searchKeyword}, '%') + </if> + <![CDATA[ + ORDER BY FRST_REGIST_PNTTM DESC + LIMIT #{recordCountPerPage} OFFSET #{firstIndex} + ]]> + </select> + + <select id="selectBannerListTotCnt" parameterType="egovframework.com.uss.ion.bnr.service.BannerVO" resultType="int"> + + SELECT COUNT(*) totcnt + FROM COMTNBANNER + WHERE 1=1 + <if test="searchCondition != null and searchCondition == 1" > + AND BANNER_NM LIKE CONCAT('%' , #{searchKeyword}, '%') + </if> + </select> + + <select id="selectBanner" resultMap="banner"> + <![CDATA[ + SELECT BANNER_ID, + BANNER_NM, + LINK_URL, + BANNER_IMAGE, + BANNER_IMAGE_FILE, + BANNER_DC, + SORT_ORDR, + REFLCT_AT, + FRST_REGISTER_ID, + FRST_REGIST_PNTTM + FROM COMTNBANNER + WHERE BANNER_ID = #{bannerId} + ]]> + </select> + + <insert id="insertBanner" parameterType="egovframework.com.uss.ion.bnr.service.BannerVO"> + <![CDATA[ + INSERT INTO COMTNBANNER + (BANNER_ID, + BANNER_NM, + LINK_URL, + BANNER_IMAGE, + BANNER_IMAGE_FILE, + BANNER_DC, + SORT_ORDR, + REFLCT_AT, + FRST_REGISTER_ID, + FRST_REGIST_PNTTM) + VALUES (#{bannerId}, + #{bannerNm}, + #{linkUrl}, + #{bannerImage}, + #{bannerImageFile}, + #{bannerDc}, + #{sortOrdr}, + #{reflctAt}, + #{userId}, + now()) + ]]> + </insert> + + <update id="updateBanner" parameterType="egovframework.com.uss.ion.bnr.service.BannerVO"> + UPDATE COMTNBANNER + SET BANNER_NM = #{bannerNm}, + LINK_URL = #{linkUrl}, + BANNER_IMAGE = #{bannerImage}, + BANNER_IMAGE_FILE = #{bannerImageFile}, + BANNER_DC = #{bannerDc}, + SORT_ORDR = #{sortOrdr}, + REFLCT_AT = #{reflctAt}, + LAST_UPDUSR_ID = #{userId}, + LAST_UPDT_PNTTM = now() + WHERE BANNER_ID = #{bannerId} + </update> + + <delete id="deleteBanner" parameterType="egovframework.com.uss.ion.bnr.service.BannerVO"> + <![CDATA[ + DELETE FROM COMTNBANNER + WHERE BANNER_ID = #{bannerId} + ]]> + </delete> + + <select id="selectBannerResult" resultMap="bannerImage"> + <![CDATA[ + SELECT BANNER_IMAGE_FILE, + LINK_URL + FROM COMTNBANNER + WHERE REFLCT_AT = 'Y' + ORDER BY SORT_ORDR + ]]> + </select> + + <select id="selectBannerFile" parameterType="egovframework.com.uss.ion.bnr.service.BannerVO" resultMap="bannerImageFile"> + <![CDATA[ + SELECT B.FILE_STRE_COURS AS FILE_STRE_COURS, + B.STRE_FILE_NM AS STRE_FILE_NM + FROM COMTNBANNER A, + COMTNFILEDETAIL B + WHERE 1 = 1 + AND A.BANNER_ID = #{bannerId} + AND A.BANNER_IMAGE_FILE = B.ATCH_FILE_ID + ]]> + </select> +</mapper> \ No newline at end of file Property changes on: base3.10/src/main/resources/egovframework/mapper/com/uss/ion/bnr/EgovBanner_SQL_mysql.xml ___________________________________________________________________ Added: svn:mime-type + text/plain Index: base3.10/src/main/resources/egovframework/mapper/com/uss/ion/bnr/EgovBanner_SQL_sqlite.xml =================================================================== --- base3.10/src/main/resources/egovframework/mapper/com/uss/ion/bnr/EgovBanner_SQL_sqlite.xml (nonexistent) +++ base3.10/src/main/resources/egovframework/mapper/com/uss/ion/bnr/EgovBanner_SQL_sqlite.xml (revision 31) @@ -0,0 +1,163 @@ +<?xml version="1.0" encoding="UTF-8"?> +<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> + +<mapper namespace="bannerDAO"> + + <resultMap id="banner" type="egovframework.com.uss.ion.bnr.service.BannerVO"> + <result property="bannerId" column="BANNER_ID" /> + <result property="bannerNm" column="BANNER_NM" /> + <result property="linkUrl" column="LINK_URL" /> + <result property="bannerImage" column="BANNER_IMAGE" /> + <result property="bannerImageFile" column="BANNER_IMAGE_FILE" /> + <result property="bannerDc" column="BANNER_DC" /> + <result property="sortOrdr" column="SORT_ORDR" /> + <result property="reflctAt" column="REFLCT_AT" /> + <result property="userId" column="FRST_REGISTER_ID" /> + <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> + + <select id="selectBannerList" parameterType="egovframework.com.uss.ion.bnr.service.BannerVO" resultMap="banner"> + <![CDATA[ + SELECT BANNER_ID, + BANNER_NM, + LINK_URL, + BANNER_IMAGE, + BANNER_IMAGE_FILE, + BANNER_DC, + SORT_ORDR, + REFLCT_AT, + FRST_REGISTER_ID, + FRST_REGIST_PNTTM + FROM COMTNBANNER + WHERE 1=1 + ]]> + <if test="searchCondition != null and searchCondition == 1" > + AND BANNER_NM LIKE CONCAT('%' , #{searchKeyword}, '%') + </if> + <![CDATA[ + ORDER BY FRST_REGIST_PNTTM DESC + LIMIT #{recordCountPerPage} OFFSET #{firstIndex} + ]]> + </select> + + <select id="selectBannerListTotCnt" parameterType="egovframework.com.uss.ion.bnr.service.BannerVO" resultType="int"> + + SELECT COUNT(*) totcnt + FROM COMTNBANNER + WHERE 1=1 + <if test="searchCondition != null and searchCondition == 1" > + AND BANNER_NM LIKE CONCAT('%' , #{searchKeyword}, '%') + </if> + </select> + + <select id="selectBanner" resultMap="banner"> + <![CDATA[ + SELECT BANNER_ID, + BANNER_NM, + LINK_URL, + BANNER_IMAGE, + BANNER_IMAGE_FILE, + BANNER_DC, + SORT_ORDR, + REFLCT_AT, + FRST_REGISTER_ID, + FRST_REGIST_PNTTM + FROM COMTNBANNER + WHERE BANNER_ID = #{bannerId} + ]]> + </select> + + <insert id="insertBanner" parameterType="egovframework.com.uss.ion.bnr.service.BannerVO"> + <![CDATA[ + INSERT INTO COMTNBANNER + (BANNER_ID, + BANNER_NM, + LINK_URL, + BANNER_IMAGE, + BANNER_IMAGE_FILE, + BANNER_DC, + SORT_ORDR, + REFLCT_AT, + FRST_REGISTER_ID, + FRST_REGIST_PNTTM) + VALUES (#{bannerId}, + #{bannerNm}, + #{linkUrl}, + #{bannerImage}, + #{bannerImageFile}, + #{bannerDc}, + #{sortOrdr}, + #{reflctAt}, + #{userId}, + now()) + ]]> + </insert> + + <update id="updateBanner" parameterType="egovframework.com.uss.ion.bnr.service.BannerVO"> + UPDATE COMTNBANNER + SET BANNER_NM = #{bannerNm}, + LINK_URL = #{linkUrl}, + <if test="isAtchFile != null and isAtchFile == true"> + BANNER_IMAGE = #{bannerImage}, + BANNER_IMAGE_FILE = #{bannerImageFile}, + </if> + BANNER_DC = #{bannerDc}, + SORT_ORDR = #{sortOrdr}, + REFLCT_AT = #{reflctAt}, + LAST_UPDUSR_ID = #{userId}, + LAST_UPDT_PNTTM = now() + WHERE BANNER_ID = #{bannerId} + </update> + + <delete id="deleteBanner" parameterType="egovframework.com.uss.ion.bnr.service.BannerVO"> + <![CDATA[ + DELETE FROM COMTNBANNER + WHERE BANNER_ID = #{bannerId} + ]]> + </delete> + + <select id="selectBannerResult" resultMap="bannerImage"> + <![CDATA[ + SELECT BANNER_IMAGE_FILE, + LINK_URL + FROM COMTNBANNER + WHERE REFLCT_AT = 'Y' + ORDER BY SORT_ORDR + ]]> + </select> + + <select id="selectBannerFile" parameterType="egovframework.com.uss.ion.bnr.service.BannerVO" resultMap="bannerImageFile"> + <![CDATA[ + SELECT B.FILE_STRE_COURS AS FILE_STRE_COURS, + B.STRE_FILE_NM AS STRE_FILE_NM + FROM COMTNBANNER A, + COMTNFILEDETAIL B + WHERE 1 = 1 + AND A.BANNER_ID = #{bannerId} + AND A.BANNER_IMAGE_FILE = B.ATCH_FILE_ID + ]]> + </select> +</mapper> \ No newline at end of file Property changes on: base3.10/src/main/resources/egovframework/mapper/com/uss/ion/bnr/EgovBanner_SQL_sqlite.xml ___________________________________________________________________ Added: svn:mime-type + text/plain Index: base3.10/src/main/resources/egovframework/mapper/com/uss/ion/bnr/EgovBanner_SQL_cubrid.xml =================================================================== --- base3.10/src/main/resources/egovframework/mapper/com/uss/ion/bnr/EgovBanner_SQL_cubrid.xml (nonexistent) +++ base3.10/src/main/resources/egovframework/mapper/com/uss/ion/bnr/EgovBanner_SQL_cubrid.xml (revision 31) @@ -0,0 +1,174 @@ +<?xml version="1.0" encoding="UTF-8"?> + +<!DOCTYPE sqlMap PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN" "http://ibatis.apache.org/dtd/sql-map-2.dtd"> + +<sqlMap namespace="Banner"> + + <typeAlias alias="Banner" type="egovframework.com.uss.ion.bnr.service.Banner"/> + <typeAlias alias="BannerVO" type="egovframework.com.uss.ion.bnr.service.BannerVO"/> + + <resultMap id="banner" class="egovframework.com.uss.ion.bnr.service.BannerVO"> + <result property="bannerId" column="BANNER_ID" columnIndex="1"/> + <result property="bannerNm" column="BANNER_NM" columnIndex="2"/> + <result property="linkUrl" column="LINK_URL" columnIndex="3"/> + <result property="bannerImage" column="BANNER_IMAGE" columnIndex="4"/> + <result property="bannerImageFile" column="BANNER_IMAGE_FILE" columnIndex="5"/> + <result property="bannerDc" column="BANNER_DC" columnIndex="6"/> + <result property="sortOrdr" column="SORT_ORDR" columnIndex="7"/> + <result property="reflctAt" column="REFLCT_AT" columnIndex="8"/> + <result property="userId" column="FRST_REGISTER_ID" columnIndex="9"/> + <result property="regDate" column="FRST_REGIST_PNTTM" columnIndex="10"/> + </resultMap> + + <resultMap id="fileList" class="egovframework.com.cmm.service.FileVO"> + <result property="atchFileId" column="ATCH_FILE_ID" columnIndex="1"/> + <result property="fileCn" column="FILE_CN" columnIndex="2"/> + <result property="fileExtsn" column="FILE_EXTSN" columnIndex="3"/> + <result property="fileMg" column="FILE_SIZE" columnIndex="4"/> + <result property="fileSn" column="FILE_SN" columnIndex="5"/> + <result property="fileStreCours" column="FILE_STRE_COURS" columnIndex="6"/> + <result property="orignlFileNm" column="ORIGNL_FILE_NM" columnIndex="7"/> + <result property="streFileNm" column="STRE_FILE_NM" columnIndex="8"/> + <result property="creatDt" column="CREAT_DT" columnIndex="9"/> + </resultMap> + + <resultMap id="bannerImage" class="egovframework.com.uss.ion.bnr.service.BannerVO"> + <result property="bannerImageFile" column="BANNER_IMAGE_FILE" columnIndex="1"/> + <result property="linkUrl" column="LINK_URL" columnIndex="2"/> + </resultMap> + + <resultMap id="bannerImageFile" class="egovframework.com.cmm.service.FileVO"> + <result property="fileStreCours" column="FILE_STRE_COURS" columnIndex="1"/> + <result property="streFileNm" column="STRE_FILE_NM" columnIndex="2"/> + </resultMap> + + <select id="bannerDAO.selectBannerList" parameterClass="BannerVO" resultMap="banner"> + <![CDATA[ + SELECT * + FROM ( + SELECT ROWNUM RNUM, ALL_LIST.* + FROM ( + + SELECT BANNER_ID, + BANNER_NM, + LINK_URL, + BANNER_IMAGE, + BANNER_IMAGE_FILE, + BANNER_DC, + SORT_ORDR, + REFLCT_AT, + FRST_REGISTER_ID, + FRST_REGIST_PNTTM + FROM COMTNBANNER + WHERE 1=1 + ]]> + <isEqual prepend="AND" property="searchCondition" compareValue="1"> + BANNER_NM LIKE '%'||#searchKeyword#||'%' + </isEqual> + <![CDATA[ + ORDER BY FRST_REGIST_PNTTM DESC + ) ALL_LIST + ) Z + WHERE RNUM > #firstIndex# + AND RNUM <= #firstIndex# + #recordCountPerPage# + ]]> + </select> + + <select id="bannerDAO.selectBannerListTotCnt" parameterClass="BannerVO" resultClass="int"> + + SELECT COUNT(*) totcnt + FROM COMTNBANNER + WHERE 1=1 + <isEqual prepend="AND" property="searchCondition" compareValue="1"> + BANNER_NM LIKE '%'||#searchKeyword#||'%' + </isEqual> + </select> + + <select id="bannerDAO.selectBanner" resultMap="banner"> + <![CDATA[ + SELECT BANNER_ID, + BANNER_NM, + LINK_URL, + BANNER_IMAGE, + BANNER_IMAGE_FILE, + BANNER_DC, + SORT_ORDR, + REFLCT_AT, + FRST_REGISTER_ID, + FRST_REGIST_PNTTM + FROM COMTNBANNER + WHERE BANNER_ID = #bannerId# + ]]> + </select> + + <insert id="bannerDAO.insertBanner" parameterClass="Banner"> + <![CDATA[ + INSERT INTO COMTNBANNER + (BANNER_ID, + BANNER_NM, + LINK_URL, + BANNER_IMAGE, + BANNER_IMAGE_FILE, + BANNER_DC, + SORT_ORDR, + REFLCT_AT, + FRST_REGISTER_ID, + FRST_REGIST_PNTTM) + VALUES (#bannerId#, + #bannerNm#, + #linkUrl#, + #bannerImage#, + #bannerImageFile#, + #bannerDc#, + #sortOrdr#, + #reflctAt#, + #userId#, + SYSDATETIME) + ]]> + </insert> + + <update id="bannerDAO.updateBanner" parameterClass="Banner"> + UPDATE COMTNBANNER + SET BANNER_NM = #bannerNm#, + LINK_URL = #linkUrl#, + <isEqual property="isAtchFile" compareValue="true"> + BANNER_IMAGE = #bannerImage#, + BANNER_IMAGE_FILE = #bannerImageFile#, + </isEqual> + BANNER_DC = #bannerDc#, + SORT_ORDR = #sortOrdr#, + REFLCT_AT = #reflctAt#, + LAST_UPDUSR_ID = #userId#, + LAST_UPDT_PNTTM = SYSDATETIME + WHERE BANNER_ID = #bannerId# + </update> + + <delete id="bannerDAO.deleteBanner" parameterClass="Banner"> + <![CDATA[ + DELETE FROM COMTNBANNER + WHERE BANNER_ID = #bannerId# + ]]> + </delete> + + <select id="bannerDAO.selectBannerResult" resultMap="bannerImage"> + <![CDATA[ + SELECT BANNER_IMAGE_FILE, + LINK_URL + FROM COMTNBANNER + WHERE REFLCT_AT = 'Y' + ORDER BY SORT_ORDR + ]]> + </select> + + <select id="bannerDAO.selectBannerFile" parameterClass="Banner" resultMap="bannerImageFile"> + <![CDATA[ + SELECT B.FILE_STRE_COURS AS FILE_STRE_COURS, + B.STRE_FILE_NM AS STRE_FILE_NM + FROM COMTNBANNER A, + COMTNFILEDETAIL B + WHERE 1 = 1 + AND A.BANNER_ID = #bannerId# + AND A.BANNER_IMAGE_FILE = B.ATCH_FILE_ID + ]]> + </select> +</sqlMap> \ No newline at end of file Property changes on: base3.10/src/main/resources/egovframework/mapper/com/uss/ion/bnr/EgovBanner_SQL_cubrid.xml ___________________________________________________________________ Added: svn:mime-type + text/plain Index: base3.10/src/main/resources/egovframework/mapper/com/uss/ion/bnr/EgovBanner_SQL_oracle.xml =================================================================== --- base3.10/src/main/resources/egovframework/mapper/com/uss/ion/bnr/EgovBanner_SQL_oracle.xml (nonexistent) +++ base3.10/src/main/resources/egovframework/mapper/com/uss/ion/bnr/EgovBanner_SQL_oracle.xml (revision 31) @@ -0,0 +1,170 @@ +<?xml version="1.0" encoding="UTF-8"?> +<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> + +<mapper namespace="bannerDAO"> + <resultMap id="banner" type="egovframework.com.uss.ion.bnr.service.BannerVO"> + <result property="bannerId" column="BANNER_ID" /> + <result property="bannerNm" column="BANNER_NM" /> + <result property="linkUrl" column="LINK_URL" /> + <result property="bannerImage" column="BANNER_IMAGE" /> + <result property="bannerImageFile" column="BANNER_IMAGE_FILE" /> + <result property="bannerDc" column="BANNER_DC" /> + <result property="sortOrdr" column="SORT_ORDR" /> + <result property="reflctAt" column="REFLCT_AT" /> + <result property="userId" column="FRST_REGISTER_ID" /> + <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> + + <select id="selectBannerList" parameterType="egovframework.com.uss.ion.bnr.service.BannerVO" resultMap="banner"> + <![CDATA[ + SELECT * + FROM ( + SELECT ROWNUM RNUM, ALL_LIST.* + FROM ( + + SELECT BANNER_ID, + BANNER_NM, + LINK_URL, + BANNER_IMAGE, + BANNER_IMAGE_FILE, + BANNER_DC, + SORT_ORDR, + REFLCT_AT, + FRST_REGISTER_ID, + FRST_REGIST_PNTTM + FROM COMTNBANNER + WHERE 1=1 + ]]> + <if test="searchCondition != null and searchCondition == 1" > + AND BANNER_NM LIKE '%'||#{searchKeyword}||'%' + </if> + <![CDATA[ + ORDER BY FRST_REGIST_PNTTM DESC + ) ALL_LIST + ) + WHERE RNUM > #{firstIndex} + AND RNUM <= #{firstIndex} + #{recordCountPerPage} + ]]> + </select> + + <select id="selectBannerListTotCnt" parameterType="egovframework.com.uss.ion.bnr.service.BannerVO" resultType="int"> + SELECT COUNT(*) totcnt + FROM COMTNBANNER + WHERE 1=1 + <if test="searchCondition != null and searchCondition == 1" > + AND BANNER_NM LIKE '%'||#{searchKeyword}||'%' + </if> + </select> + + <select id="selectBanner" resultMap="banner"> + <![CDATA[ + SELECT BANNER_ID, + BANNER_NM, + LINK_URL, + BANNER_IMAGE, + BANNER_IMAGE_FILE, + BANNER_DC, + SORT_ORDR, + REFLCT_AT, + FRST_REGISTER_ID, + FRST_REGIST_PNTTM + FROM COMTNBANNER + WHERE BANNER_ID = #{bannerId} + ]]> + </select> + + <insert id="insertBanner" parameterType="egovframework.com.uss.ion.bnr.service.BannerVO"> + <![CDATA[ + INSERT INTO COMTNBANNER + (BANNER_ID, + BANNER_NM, + LINK_URL, + BANNER_IMAGE, + BANNER_IMAGE_FILE, + BANNER_DC, + SORT_ORDR, + REFLCT_AT, + FRST_REGISTER_ID, + FRST_REGIST_PNTTM) + VALUES (#{bannerId}, + #{bannerNm}, + #{linkUrl}, + #{bannerImage}, + #{bannerImageFile}, + #{bannerDc}, + #{sortOrdr}, + #{reflctAt}, + #{userId}, + SYSDATE) + ]]> + </insert> + + <update id="updateBanner" parameterType="egovframework.com.uss.ion.bnr.service.BannerVO"> + UPDATE COMTNBANNER + SET BANNER_NM = #{bannerNm}, + LINK_URL = #{linkUrl}, + <if test="isAtchFile != null and isAtchFile == true"> + BANNER_IMAGE = #{bannerImage}, + BANNER_IMAGE_FILE = #{bannerImageFile}, + </if> + BANNER_DC = #{bannerDc}, + SORT_ORDR = #{sortOrdr}, + REFLCT_AT = #{reflctAt}, + LAST_UPDUSR_ID = #{userId}, + LAST_UPDT_PNTTM = SYSDATE + WHERE BANNER_ID = #{bannerId} + </update> + + <delete id="deleteBanner" parameterType="egovframework.com.uss.ion.bnr.service.BannerVO"> + <![CDATA[ + DELETE FROM COMTNBANNER + WHERE BANNER_ID = #{bannerId} + ]]> + </delete> + + <select id="selectBannerResult" resultMap="bannerImage"> + <![CDATA[ + SELECT BANNER_IMAGE_FILE, + LINK_URL, + BANNER_NM + FROM COMTNBANNER + WHERE REFLCT_AT = 'Y' + ORDER BY SORT_ORDR + ]]> + </select> + + <select id="selectBannerFile" parameterType="egovframework.com.uss.ion.bnr.service.BannerVO" resultMap="bannerImageFile"> + <![CDATA[ + SELECT B.FILE_STRE_COURS AS FILE_STRE_COURS, + B.STRE_FILE_NM AS STRE_FILE_NM + FROM COMTNBANNER A, + COMTNFILEDETAIL B + WHERE 1 = 1 + AND A.BANNER_ID = #{bannerId} + AND A.BANNER_IMAGE_FILE = B.ATCH_FILE_ID + ]]> + </select> +</mapper> \ No newline at end of file Property changes on: base3.10/src/main/resources/egovframework/mapper/com/uss/ion/bnr/EgovBanner_SQL_oracle.xml ___________________________________________________________________ Added: svn:mime-type + text/plain Index: base3.10/src/main/resources/egovframework/mapper/com/uss/ion/bnr/EgovBanner_SQL_altibase.xml =================================================================== --- base3.10/src/main/resources/egovframework/mapper/com/uss/ion/bnr/EgovBanner_SQL_altibase.xml (nonexistent) +++ base3.10/src/main/resources/egovframework/mapper/com/uss/ion/bnr/EgovBanner_SQL_altibase.xml (revision 31) @@ -0,0 +1,174 @@ +<?xml version="1.0" encoding="UTF-8"?> + +<!DOCTYPE sqlMap PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN" "http://ibatis.apache.org/dtd/sql-map-2.dtd"> + +<sqlMap namespace="Banner"> + + <typeAlias alias="Banner" type="egovframework.com.uss.ion.bnr.service.Banner"/> + <typeAlias alias="BannerVO" type="egovframework.com.uss.ion.bnr.service.BannerVO"/> + + <resultMap id="banner" class="egovframework.com.uss.ion.bnr.service.BannerVO"> + <result property="bannerId" column="BANNER_ID" columnIndex="1"/> + <result property="bannerNm" column="BANNER_NM" columnIndex="2"/> + <result property="linkUrl" column="LINK_URL" columnIndex="3"/> + <result property="bannerImage" column="BANNER_IMAGE" columnIndex="4"/> + <result property="bannerImageFile" column="BANNER_IMAGE_FILE" columnIndex="5"/> + <result property="bannerDc" column="BANNER_DC" columnIndex="6"/> + <result property="sortOrdr" column="SORT_ORDR" columnIndex="7"/> + <result property="reflctAt" column="REFLCT_AT" columnIndex="8"/> + <result property="userId" column="FRST_REGISTER_ID" columnIndex="9"/> + <result property="regDate" column="FRST_REGIST_PNTTM" columnIndex="10"/> + </resultMap> + + <resultMap id="fileList" class="egovframework.com.cmm.service.FileVO"> + <result property="atchFileId" column="ATCH_FILE_ID" columnIndex="1"/> + <result property="fileCn" column="FILE_CN" columnIndex="2"/> + <result property="fileExtsn" column="FILE_EXTSN" columnIndex="3"/> + <result property="fileMg" column="FILE_SIZE" columnIndex="4"/> + <result property="fileSn" column="FILE_SN" columnIndex="5"/> + <result property="fileStreCours" column="FILE_STRE_COURS" columnIndex="6"/> + <result property="orignlFileNm" column="ORIGNL_FILE_NM" columnIndex="7"/> + <result property="streFileNm" column="STRE_FILE_NM" columnIndex="8"/> + <result property="creatDt" column="CREAT_DT" columnIndex="9"/> + </resultMap> + + <resultMap id="bannerImage" class="egovframework.com.uss.ion.bnr.service.BannerVO"> + <result property="bannerImageFile" column="BANNER_IMAGE_FILE" columnIndex="1"/> + <result property="linkUrl" column="LINK_URL" columnIndex="2"/> + </resultMap> + + <resultMap id="bannerImageFile" class="egovframework.com.cmm.service.FileVO"> + <result property="fileStreCours" column="FILE_STRE_COURS" columnIndex="1"/> + <result property="streFileNm" column="STRE_FILE_NM" columnIndex="2"/> + </resultMap> + + <select id="bannerDAO.selectBannerList" parameterClass="BannerVO" resultMap="banner"> + <![CDATA[ + SELECT * + FROM ( + SELECT ROWNUM RNUM, ALL_LIST.* + FROM ( + + SELECT BANNER_ID, + BANNER_NM, + LINK_URL, + BANNER_IMAGE, + BANNER_IMAGE_FILE, + BANNER_DC, + SORT_ORDR, + REFLCT_AT, + FRST_REGISTER_ID, + FRST_REGIST_PNTTM + FROM COMTNBANNER + WHERE 1=1 + ]]> + <isEqual prepend="AND" property="searchCondition" compareValue="1"> + BANNER_NM LIKE '%'||#searchKeyword#||'%' + </isEqual> + <![CDATA[ + ORDER BY FRST_REGIST_PNTTM DESC + ) ALL_LIST + ) + WHERE RNUM > #firstIndex# + AND RNUM <= #firstIndex# + #recordCountPerPage# + ]]> + </select> + + <select id="bannerDAO.selectBannerListTotCnt" parameterClass="BannerVO" resultClass="int"> + + SELECT COUNT(*) totcnt + FROM COMTNBANNER + WHERE 1=1 + <isEqual prepend="AND" property="searchCondition" compareValue="1"> + BANNER_NM LIKE '%'||#searchKeyword#||'%' + </isEqual> + </select> + + <select id="bannerDAO.selectBanner" resultMap="banner"> + <![CDATA[ + SELECT BANNER_ID, + BANNER_NM, + LINK_URL, + BANNER_IMAGE, + BANNER_IMAGE_FILE, + BANNER_DC, + SORT_ORDR, + REFLCT_AT, + FRST_REGISTER_ID, + FRST_REGIST_PNTTM + FROM COMTNBANNER + WHERE BANNER_ID = #bannerId# + ]]> + </select> + + <insert id="bannerDAO.insertBanner" parameterClass="Banner"> + <![CDATA[ + INSERT INTO COMTNBANNER + (BANNER_ID, + BANNER_NM, + LINK_URL, + BANNER_IMAGE, + BANNER_IMAGE_FILE, + BANNER_DC, + SORT_ORDR, + REFLCT_AT, + FRST_REGISTER_ID, + FRST_REGIST_PNTTM) + VALUES (#bannerId#, + #bannerNm#, + #linkUrl#, + #bannerImage#, + #bannerImageFile#, + #bannerDc#, + #sortOrdr#, + #reflctAt#, + #userId#, + SYSDATE) + ]]> + </insert> + + <update id="bannerDAO.updateBanner" parameterClass="Banner"> + UPDATE COMTNBANNER + SET BANNER_NM = #bannerNm#, + LINK_URL = #linkUrl#, + <isEqual property="isAtchFile" compareValue="true"> + BANNER_IMAGE = #bannerImage#, + BANNER_IMAGE_FILE = #bannerImageFile#, + </isEqual> + BANNER_DC = #bannerDc#, + SORT_ORDR = #sortOrdr#, + REFLCT_AT = #reflctAt#, + LAST_UPDUSR_ID = #userId#, + LAST_UPDT_PNTTM = SYSDATE + WHERE BANNER_ID = #bannerId# + </update> + + <delete id="bannerDAO.deleteBanner" parameterClass="Banner"> + <![CDATA[ + DELETE FROM COMTNBANNER + WHERE BANNER_ID = #bannerId# + ]]> + </delete> + + <select id="bannerDAO.selectBannerResult" resultMap="bannerImage"> + <![CDATA[ + SELECT BANNER_IMAGE_FILE, + LINK_URL + FROM COMTNBANNER + WHERE REFLCT_AT = 'Y' + ORDER BY SORT_ORDR + ]]> + </select> + + <select id="bannerDAO.selectBannerFile" parameterClass="Banner" resultMap="bannerImageFile"> + <![CDATA[ + SELECT B.FILE_STRE_COURS AS FILE_STRE_COURS, + B.STRE_FILE_NM AS STRE_FILE_NM + FROM COMTNBANNER A, + COMTNFILEDETAIL B + WHERE 1 = 1 + AND A.BANNER_ID = #bannerId# + AND A.BANNER_IMAGE_FILE = B.ATCH_FILE_ID + ]]> + </select> +</sqlMap> \ No newline at end of file Property changes on: base3.10/src/main/resources/egovframework/mapper/com/uss/ion/bnr/EgovBanner_SQL_altibase.xml ___________________________________________________________________ Added: svn:mime-type + text/plain Index: base3.10/src/main/resources/egovframework/mapper/com/uss/ion/bnr/EgovBanner_SQL_tibero.xml =================================================================== --- base3.10/src/main/resources/egovframework/mapper/com/uss/ion/bnr/EgovBanner_SQL_tibero.xml (nonexistent) +++ base3.10/src/main/resources/egovframework/mapper/com/uss/ion/bnr/EgovBanner_SQL_tibero.xml (revision 31) @@ -0,0 +1,174 @@ +<?xml version="1.0" encoding="UTF-8"?> + +<!DOCTYPE sqlMap PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN" "http://ibatis.apache.org/dtd/sql-map-2.dtd"> + +<sqlMap namespace="Banner"> + + <typeAlias alias="Banner" type="egovframework.com.uss.ion.bnr.service.Banner"/> + <typeAlias alias="BannerVO" type="egovframework.com.uss.ion.bnr.service.BannerVO"/> + + <resultMap id="banner" class="egovframework.com.uss.ion.bnr.service.BannerVO"> + <result property="bannerId" column="BANNER_ID" columnIndex="1"/> + <result property="bannerNm" column="BANNER_NM" columnIndex="2"/> + <result property="linkUrl" column="LINK_URL" columnIndex="3"/> + <result property="bannerImage" column="BANNER_IMAGE" columnIndex="4"/> + <result property="bannerImageFile" column="BANNER_IMAGE_FILE" columnIndex="5"/> + <result property="bannerDc" column="BANNER_DC" columnIndex="6"/> + <result property="sortOrdr" column="SORT_ORDR" columnIndex="7"/> + <result property="reflctAt" column="REFLCT_AT" columnIndex="8"/> + <result property="userId" column="FRST_REGISTER_ID" columnIndex="9"/> + <result property="regDate" column="FRST_REGIST_PNTTM" columnIndex="10"/> + </resultMap> + + <resultMap id="fileList" class="egovframework.com.cmm.service.FileVO"> + <result property="atchFileId" column="ATCH_FILE_ID" columnIndex="1"/> + <result property="fileCn" column="FILE_CN" columnIndex="2"/> + <result property="fileExtsn" column="FILE_EXTSN" columnIndex="3"/> + <result property="fileMg" column="FILE_SIZE" columnIndex="4"/> + <result property="fileSn" column="FILE_SN" columnIndex="5"/> + <result property="fileStreCours" column="FILE_STRE_COURS" columnIndex="6"/> + <result property="orignlFileNm" column="ORIGNL_FILE_NM" columnIndex="7"/> + <result property="streFileNm" column="STRE_FILE_NM" columnIndex="8"/> + <result property="creatDt" column="CREAT_DT" columnIndex="9"/> + </resultMap> + + <resultMap id="bannerImage" class="egovframework.com.uss.ion.bnr.service.BannerVO"> + <result property="bannerImageFile" column="BANNER_IMAGE_FILE" columnIndex="1"/> + <result property="linkUrl" column="LINK_URL" columnIndex="2"/> + </resultMap> + + <resultMap id="bannerImageFile" class="egovframework.com.cmm.service.FileVO"> + <result property="fileStreCours" column="FILE_STRE_COURS" columnIndex="1"/> + <result property="streFileNm" column="STRE_FILE_NM" columnIndex="2"/> + </resultMap> + + <select id="bannerDAO.selectBannerList" parameterClass="BannerVO" resultMap="banner"> + <![CDATA[ + SELECT * + FROM ( + SELECT ROWNUM RNUM, ALL_LIST.* + FROM ( + + SELECT BANNER_ID, + BANNER_NM, + LINK_URL, + BANNER_IMAGE, + BANNER_IMAGE_FILE, + BANNER_DC, + SORT_ORDR, + REFLCT_AT, + FRST_REGISTER_ID, + FRST_REGIST_PNTTM + FROM COMTNBANNER + WHERE 1=1 + ]]> + <isEqual prepend="AND" property="searchCondition" compareValue="1"> + BANNER_NM LIKE '%'||#searchKeyword#||'%' + </isEqual> + <![CDATA[ + ORDER BY FRST_REGIST_PNTTM DESC + ) ALL_LIST + ) + WHERE RNUM > #firstIndex# + AND RNUM <= #firstIndex# + #recordCountPerPage# + ]]> + </select> + + <select id="bannerDAO.selectBannerListTotCnt" parameterClass="BannerVO" resultClass="int"> + + SELECT COUNT(*) totcnt + FROM COMTNBANNER + WHERE 1=1 + <isEqual prepend="AND" property="searchCondition" compareValue="1"> + BANNER_NM LIKE '%'||#searchKeyword#||'%' + </isEqual> + </select> + + <select id="bannerDAO.selectBanner" resultMap="banner"> + <![CDATA[ + SELECT BANNER_ID, + BANNER_NM, + LINK_URL, + BANNER_IMAGE, + BANNER_IMAGE_FILE, + BANNER_DC, + SORT_ORDR, + REFLCT_AT, + FRST_REGISTER_ID, + FRST_REGIST_PNTTM + FROM COMTNBANNER + WHERE BANNER_ID = #bannerId# + ]]> + </select> + + <insert id="bannerDAO.insertBanner" parameterClass="Banner"> + <![CDATA[ + INSERT INTO COMTNBANNER + (BANNER_ID, + BANNER_NM, + LINK_URL, + BANNER_IMAGE, + BANNER_IMAGE_FILE, + BANNER_DC, + SORT_ORDR, + REFLCT_AT, + FRST_REGISTER_ID, + FRST_REGIST_PNTTM) + VALUES (#bannerId#, + #bannerNm#, + #linkUrl#, + #bannerImage#, + #bannerImageFile#, + #bannerDc#, + #sortOrdr#, + #reflctAt#, + #userId#, + SYSDATE) + ]]> + </insert> + + <update id="bannerDAO.updateBanner" parameterClass="Banner"> + UPDATE COMTNBANNER + SET BANNER_NM = #bannerNm#, + LINK_URL = #linkUrl#, + <isEqual property="isAtchFile" compareValue="true"> + BANNER_IMAGE = #bannerImage#, + BANNER_IMAGE_FILE = #bannerImageFile#, + </isEqual> + BANNER_DC = #bannerDc#, + SORT_ORDR = #sortOrdr#, + REFLCT_AT = #reflctAt#, + LAST_UPDUSR_ID = #userId#, + LAST_UPDT_PNTTM = SYSDATE + WHERE BANNER_ID = #bannerId# + </update> + + <delete id="bannerDAO.deleteBanner" parameterClass="Banner"> + <![CDATA[ + DELETE FROM COMTNBANNER + WHERE BANNER_ID = #bannerId# + ]]> + </delete> + + <select id="bannerDAO.selectBannerResult" resultMap="bannerImage"> + <![CDATA[ + SELECT BANNER_IMAGE_FILE, + LINK_URL + FROM COMTNBANNER + WHERE REFLCT_AT = 'Y' + ORDER BY SORT_ORDR + ]]> + </select> + + <select id="bannerDAO.selectBannerFile" parameterClass="Banner" resultMap="bannerImageFile"> + <![CDATA[ + SELECT B.FILE_STRE_COURS AS FILE_STRE_COURS, + B.STRE_FILE_NM AS STRE_FILE_NM + FROM COMTNBANNER A, + COMTNFILEDETAIL B + WHERE 1 = 1 + AND A.BANNER_ID = #bannerId# + AND A.BANNER_IMAGE_FILE = B.ATCH_FILE_ID + ]]> + </select> +</sqlMap> \ No newline at end of file Property changes on: base3.10/src/main/resources/egovframework/mapper/com/uss/ion/bnr/EgovBanner_SQL_tibero.xml ___________________________________________________________________ Added: svn:mime-type + text/plain 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 (nonexistent) +++ base3.10/src/main/resources/egovframework/mapper/com/uss/ion/bnr/EgovBanner_SQL_postgres.xml (revision 31) @@ -0,0 +1,161 @@ +<?xml version="1.0" encoding="UTF-8"?> +<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> + +<mapper namespace="bannerDAO"> + + <resultMap id="banner" type="egovframework.com.uss.ion.bnr.service.BannerVO"> + <result property="bannerId" column="BANNER_ID" /> + <result property="bannerNm" column="BANNER_NM" /> + <result property="linkUrl" column="LINK_URL" /> + <result property="bannerImage" column="BANNER_IMAGE" /> + <result property="bannerImageFile" column="BANNER_IMAGE_FILE" /> + <result property="bannerDc" column="BANNER_DC" /> + <result property="sortOrdr" column="SORT_ORDR" /> + <result property="reflctAt" column="REFLCT_AT" /> + <result property="userId" column="FRST_REGISTER_ID" /> + <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> + + <select id="selectBannerList" parameterType="egovframework.com.uss.ion.bnr.service.BannerVO" resultMap="banner"> + <![CDATA[ + SELECT BANNER_ID, + BANNER_NM, + LINK_URL, + BANNER_IMAGE, + BANNER_IMAGE_FILE, + BANNER_DC, + SORT_ORDR, + REFLCT_AT, + FRST_REGISTER_ID, + FRST_REGIST_PNTTM + FROM COMTNBANNER + WHERE 1=1 + ]]> + <if test="searchCondition != null and searchCondition == 1" > + AND BANNER_NM LIKE CONCAT('%' , #{searchKeyword}, '%') + </if> + <![CDATA[ + ORDER BY FRST_REGIST_PNTTM DESC + LIMIT #{recordCountPerPage} OFFSET #{firstIndex} + ]]> + </select> + + <select id="selectBannerListTotCnt" parameterType="egovframework.com.uss.ion.bnr.service.BannerVO" resultType="int"> + + SELECT COUNT(*) "totcnt" + FROM COMTNBANNER + WHERE 1=1 + <if test="searchCondition != null and searchCondition == 1" > + AND BANNER_NM LIKE CONCAT('%' , #{searchKeyword}, '%') + </if> + </select> + + <select id="selectBanner" resultMap="banner"> + <![CDATA[ + SELECT BANNER_ID, + BANNER_NM, + LINK_URL, + BANNER_IMAGE, + BANNER_IMAGE_FILE, + BANNER_DC, + SORT_ORDR, + REFLCT_AT, + FRST_REGISTER_ID, + FRST_REGIST_PNTTM + FROM COMTNBANNER + WHERE BANNER_ID = #{bannerId} + ]]> + </select> + + <insert id="insertBanner" parameterType="egovframework.com.uss.ion.bnr.service.BannerVO"> + <![CDATA[ + INSERT INTO COMTNBANNER + (BANNER_ID, + BANNER_NM, + LINK_URL, + BANNER_IMAGE, + BANNER_IMAGE_FILE, + BANNER_DC, + SORT_ORDR, + REFLCT_AT, + FRST_REGISTER_ID, + FRST_REGIST_PNTTM) + VALUES (#{bannerId}, + #{bannerNm}, + #{linkUrl}, + #{bannerImage}, + #{bannerImageFile}, + #{bannerDc}, + #{sortOrdr}::numeric, + #{reflctAt}, + #{userId}, + now()) + ]]> + </insert> + + <update id="updateBanner" parameterType="egovframework.com.uss.ion.bnr.service.BannerVO"> + UPDATE COMTNBANNER + SET BANNER_NM = #{bannerNm}, + LINK_URL = #{linkUrl}, + BANNER_IMAGE = #{bannerImage}, + BANNER_IMAGE_FILE = #{bannerImageFile}, + BANNER_DC = #{bannerDc}, + SORT_ORDR = #{sortOrdr}::numeric, + REFLCT_AT = #{reflctAt}, + LAST_UPDUSR_ID = #{userId}, + LAST_UPDT_PNTTM = now() + WHERE BANNER_ID = #{bannerId} + </update> + + <delete id="deleteBanner" parameterType="egovframework.com.uss.ion.bnr.service.BannerVO"> + <![CDATA[ + DELETE FROM COMTNBANNER + WHERE BANNER_ID = #{bannerId} + ]]> + </delete> + + <select id="selectBannerResult" resultMap="bannerImage"> + <![CDATA[ + SELECT BANNER_IMAGE_FILE, + LINK_URL + FROM COMTNBANNER + WHERE REFLCT_AT = 'Y' + ORDER BY SORT_ORDR + ]]> + </select> + + <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 + FROM COMTNBANNER A, + TNFILE B + WHERE 1 = 1 + AND A.BANNER_ID = #{bannerId} + AND A.BANNER_IMAGE_FILE = B.FILE_ID + ]]> + </select> +</mapper> \ No newline at end of file Property changes on: base3.10/src/main/resources/egovframework/mapper/com/uss/ion/bnr/EgovBanner_SQL_postgres.xml ___________________________________________________________________ Added: svn:mime-type + text/plain Index: base3.10/src/main/resources/egovframework/validator/com/uss/ion/bnr/EgovBanner.xml =================================================================== --- base3.10/src/main/resources/egovframework/validator/com/uss/ion/bnr/EgovBanner.xml (nonexistent) +++ base3.10/src/main/resources/egovframework/validator/com/uss/ion/bnr/EgovBanner.xml (revision 31) @@ -0,0 +1,32 @@ +<?xml version="1.0" encoding="UTF-8"?> +<!DOCTYPE form-validation PUBLIC + "-//Apache Software Foundation//DTD Commons Validator Rules Configuration 1.1//EN" + "http://jakarta.apache.org/commons/dtds/validator_1_1.dtd"> + +<form-validation> + + <formset> + <form name="banner"> + <field property="bannerNm" depends="required, maxlength"> + <arg0 key="배너 명" resource="false"/> + <arg1 key="30" resource="false"/> + <var> + <var-name>maxlength</var-name> + <var-value>30</var-value> + </var> + </field> + <field property="linkUrl" depends="required"> + <arg0 key="링크URL" resource="false"/> + </field> + <field property="sortOrdr" depends="required, maxlength, integer"> + <arg0 key="정렬순서" resource="false"/> + <arg1 key="100" resource="false"/> + <var> + <var-name>maxlength</var-name> + <var-value>100</var-value> + </var> + </field> + </form> + </formset> + +</form-validation> \ No newline at end of file Property changes on: base3.10/src/main/resources/egovframework/validator/com/uss/ion/bnr/EgovBanner.xml ___________________________________________________________________ Added: svn:mime-type + text/plain Index: base3.10/src/main/resources/egovframework/egovProps/globals.properties =================================================================== --- base3.10/src/main/resources/egovframework/egovProps/globals.properties (revision 30) +++ base3.10/src/main/resources/egovframework/egovProps/globals.properties (revision 31) @@ -72,7 +72,7 @@ #postgreSQL Globals.postgres.DriverClassName=org.postgresql.Driver -Globals.postgres.Url=jdbc:postgresql://127.0.0.1:15432/base +Globals.postgres.Url=jdbc:postgresql://192.168.0.56:15432/base Globals.postgres.UserName=allinone Globals.postgres.Password=TEFwH5ptn081t8kwtx7zFg%3D%3D Index: base3.10/src/main/resources/egovframework/message/com/uss/bnr/message_en.properties =================================================================== --- base3.10/src/main/resources/egovframework/message/com/uss/bnr/message_en.properties (nonexistent) +++ base3.10/src/main/resources/egovframework/message/com/uss/bnr/message_en.properties (revision 31) @@ -0,0 +1,38 @@ +#Banner Management# +ussIonBnr.bannerList.bannerList=Banner Management List +ussIonBnr.bannerList.bannerNm=Banner Name +ussIonBnr.bannerList.linkUrl=Link URL +ussIonBnr.bannerList.bannerDc=Banner Description +ussIonBnr.bannerList.reflctAtt=Applicability +ussIonBnr.bannerList.noBanner=No Banner selected. +ussIonBnr.bannerList.failInquire=No results were inquired. +ussIonBnr.bannerList.deleteImage=Will you delete it? + +ussIonBnr.bannerRegist.bannerRegist=Banner Management Regist +ussIonBnr.bannerRegist.bannerNm=Banner Name +ussIonBnr.bannerRegist.bannerImage=Banner Image +ussIonBnr.bannerRegist.bannerId=Banner ID +ussIonBnr.bannerRegist.linkUrl=Link URL +ussIonBnr.bannerRegist.bannerDc=Banner Description +ussIonBnr.bannerRegist.sortOrdr=Sort Order +ussIonBnr.bannerRegist.reflctAtt=Applicability +ussIonBnr.bannerRegist.regDate=Registration date +ussIonBnr.bannerRegist.saveImage=Do you want to save it? +ussIonBnr.bannerRegist.ImageReq=Banner Image is required. +ussIonBnr.bannerRegist.deleteImage=Will you delete it? + +ussIonBnr.bannerUpdt.bannerUpdt=Banner Management Update +ussIonBnr.bannerUpdt.bannerNm=Banner Name +ussIonBnr.bannerUpdt.bannerImage=Banner Image +ussIonBnr.bannerUpdt.bannerId=Banner ID +ussIonBnr.bannerUpdt.linkUrl=Link URL +ussIonBnr.bannerUpdt.bannerDc=Banner Description +ussIonBnr.bannerUpdt.sortOrdr=Sort Order +ussIonBnr.bannerUpdt.reflctAtt=Applicability +ussIonBnr.bannerUpdt.regDate=Registration date +ussIonBnr.bannerUpdt.saveImage=Do you want to save it? +ussIonBnr.bannerUpdt.deleteImage=Will you delete it? + +ussIonBnr.bannerMainList.bannerMainList=MYPAGE Banner Management +ussIonBnr.bannerMainList.EgovBannerDc=This page is where 740. images registered in Banner Management are reflected. +ussIonBnr.bannerMainList.bannerNm=Banner Name \ No newline at end of file Property changes on: base3.10/src/main/resources/egovframework/message/com/uss/bnr/message_en.properties ___________________________________________________________________ Added: svn:mime-type + text/plain Index: base3.10/src/main/resources/egovframework/message/com/uss/bnr/message_ko.properties =================================================================== --- base3.10/src/main/resources/egovframework/message/com/uss/bnr/message_ko.properties (nonexistent) +++ base3.10/src/main/resources/egovframework/message/com/uss/bnr/message_ko.properties (revision 31) @@ -0,0 +1,12 @@ +#\ubc30\ub108\uad00\ub9ac# + +comUssIonBnr.bannerVO.title = \ubc30\ub108\uad00\ub9ac + +comUssIonBnr.bannerVO.bannerId = \ubc30\ub108ID +comUssIonBnr.bannerVO.bannerNm = \ubc30\ub108\uba85 +comUssIonBnr.bannerVO.linkUrl = \ub9c1\ud06cURL +comUssIonBnr.bannerVO.bannerImage = \ubc30\ub108\uc774\ubbf8\uc9c0 +comUssIonBnr.bannerVO.bannerDc = \ubc30\ub108\uc124\uba85 +comUssIonBnr.bannerVO.sortOrdr = \uc815\ub82c\uc21c\uc11c +comUssIonBnr.bannerVO.reflctAt = \ubc18\uc601\uc5ec\ubd80 + Property changes on: base3.10/src/main/resources/egovframework/message/com/uss/bnr/message_ko.properties ___________________________________________________________________ Added: svn:mime-type + text/plain Index: base3.10/src/main/resources/egovframework/spring/com/idgn/context-idgn-Banner.xml =================================================================== --- base3.10/src/main/resources/egovframework/spring/com/idgn/context-idgn-Banner.xml (nonexistent) +++ base3.10/src/main/resources/egovframework/spring/com/idgn/context-idgn-Banner.xml (revision 31) @@ -0,0 +1,20 @@ +<?xml version="1.0" encoding="UTF-8"?> +<beans xmlns="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" + xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.0.xsd"> + +  + <bean name="egovBannerIdGnrService" class="egovframework.rte.fdl.idgnr.impl.EgovTableIdGnrServiceImpl" destroy-method="destroy"> + <property name="dataSource" ref="egov.dataSource" /> + <property name="strategy" ref="bannerIdStrategy" /> + <property name="blockSize" value="10"/> + <property name="table" value="COMTECOPSEQ"/> + <property name="tableName" value="BANNER_ID"/> + </bean> + <bean name="bannerIdStrategy" class="egovframework.rte.fdl.idgnr.impl.strategy.EgovIdGnrStrategyImpl"> + <property name="prefix" value="BANNER_" /> + <property name="cipers" value="13" /> + <property name="fillChar" value="0" /> + </bean> +  + +</beans> \ No newline at end of file Property changes on: base3.10/src/main/resources/egovframework/spring/com/idgn/context-idgn-Banner.xml ___________________________________________________________________ Added: svn:mime-type + text/plain Index: base3.10/src/main/webapp/WEB-INF/jsp/egovframework/com/uss/ion/bnr/EgovBannerView.jsp =================================================================== --- base3.10/src/main/webapp/WEB-INF/jsp/egovframework/com/uss/ion/bnr/EgovBannerView.jsp (nonexistent) +++ base3.10/src/main/webapp/WEB-INF/jsp/egovframework/com/uss/ion/bnr/EgovBannerView.jsp (revision 31) @@ -0,0 +1,183 @@ +<%-- +/** + * @Class Name : EgovBannerView.jsp + * @Description : EgovBannerView.jsp + * @Modification Information + * @ + * @ 수정일 수정자 수정내용 + * @ ---------- -------- --------------------------- + * @ 2009.02.01 lee.m.j 최초 생성 + * @ 2014.03.31 유지보수 fileSn=0 삭제(파일 수정시 오류) + * + * @author lee.m.j + * @since 2009.03.11 + * @version 1.0 + * @see + * + * Copyright (C) 2009 by MOPAS All right reserved. + */ + --%> + +<%@ page contentType="text/html; charset=utf-8"%> +<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %> +<%@ taglib prefix="ui" uri="http://egovframework.gov/ctl/ui"%> +<%@ taglib prefix="fn" uri="http://java.sun.com/jsp/jstl/functions" %> +<%@ taglib prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt"%> +<%@ taglib prefix="spring" uri="http://www.springframework.org/tags" %> +<%@ taglib prefix="form" uri="http://www.springframework.org/tags/form" %> +<%@ taglib prefix="validator" uri="http://www.springmodules.org/tags/commons-validator" %> + +<c:if test="${not empty fileList and resultType == 'horizontal'}"> + + +<div class="banner_box"> +  + + <div class="RollDiv"> + + <div> + <c:forEach var="fileVO" items="${fileList}" varStatus="status"> + <a href="<c:out value="${fileVO.linkUrl}"/>" target="_blank" title="<c:out value="${fileVO.bannerNm }"/>" ><img alt="<c:out value="${fileVO.bannerNm }"/>" src='<c:url value='http://gkom.ihubiz.com/cmm/fms/getImage.do'/>?atchFileId=<c:out value="${fileVO.bannerImageFile}"/>' width="100%" ></a> + </c:forEach> + </div> + + </div> + + </div> + +<%-- <div class="swiper-container banner" > + <div class="swiper-wrapper"> + <c:forEach var="fileVO" items="${fileList}" varStatus="status"> + <div class="swiper-slide"> + <a href="<c:out value="${fileVO.linkUrl}"/>" target="_blank" title="<c:out value="${fileVO.bannerNm }"/>" ><img alt="<c:out value="${fileVO.bannerNm }"/>" src='<c:url value='http://gkom.ihubiz.com/cmm/fms/getImage.do'/>?atchFileId=<c:out value="${fileVO.bannerImageFile}"/>' width="100%" ></a> + </div> + </c:forEach> + </div> +</div> --%> +</c:if> + +<script> + var moveType = 0; + // 이동시간간격 3초 + var moveSpeed = 3000; + // 움직이는 작업중 다시 명령 받지 않음 + var moveWork = false; + // 일시정지 flag + var movePause = false; + function imgMove(){ + if(moveWork==false){ + // 0d\일경우 left방향 + if(moveType==0){ + // 맨처음 이미지의 폭 + var aWidth = $(".RollDiv > div > a:first").width(); + // 롤링마지막에 맨처음의 a태그 추가 + $(".RollDiv > div").append("<a href=\""+$(".RollDiv > div > a:first").attr("href")+"\">" + $(".RollDiv > div > a:first").html()+ "</a>"); + // 맨처음이미지를 왼쪽으로 이동시킨다. + $(".RollDiv > div > a:first").animate({marginLeft:-aWidth},{duration:moveSpeed,step:function(){ + // 이동중 만약 일시정지 flag가 true라면 + if(movePause==true){ + // 이동을 멈춘다 + $(this).stop(); + } + },complete:function(){ + // 이동을 마친후 첫번째 a태그를 지워버린다 + $(this).remove(); + // 이미지 움직이는것을 다시 실행 + imgMove(); + }}); + }else{ + // 마지막 a태그의 폭 + var aWidth = $(".RollDiv > div > a:last").width(); + // a태그 앞에 마지막의 a태그를 생성한다 단 스타일은 마지막 a태그의 폭만큼 빼준다 + $("<a href=\"" + $(".RollDiv > div > a:last").attr("href")+ "\" style=\"margin-left:-" + aWidth + "px\">" + $(".RollDiv > div > a:last").html()+ "</a>").insertBefore(".RollDiv > div > a:first") + // 맨처음 a태그의 margin-left를 다시 0으로 맞춰준다. + $(".RollDiv > div > a:first").animate({marginLeft:0},{duration:moveSpeed,step:function(){ + // 이동중 만약 일시정지 flag가 true라면 + if(movePause==true){ + // 이동을 멈춘다 + $(this).stop(); + } + },complete:function(){ + // 이동을 마친후 마지막 a태그를 지워버린다 + $(".RollDiv > div > a:last").remove(); + // 이미지 움직이는것을 다시 실행 + imgMove(); + }}); + } + } + } + function goMove(){ + // 일시정지가 풀려있을 경우를 대비하여 일시정지를 풀러준다 + movePause=false; + // 0d\일경우 left방향 + if(moveType==0){ + imgMove(); + }else{ + $(".RollDiv > div > a:first").animate({marginLeft:0},{duration:moveSpeed,step:function(){ + // 이동중 만약 일시정지 flag가 true라면 + if(movePause==true){ + // 이동을 멈춘다 + $(this).stop(); + } + },complete:function(){ + // 이동을 마친후 마지막 a태그를 지워버린다 + //$(".RollDiv > div > a:last").remove(); + // 이미지 움직이는것을 다시 실행 + imgMove(); + }}); + } + + } + imgMove(); + </script> + + + \ No newline at end of file Property changes on: base3.10/src/main/webapp/WEB-INF/jsp/egovframework/com/uss/ion/bnr/EgovBannerView.jsp ___________________________________________________________________ Added: svn:mime-type + text/plain Index: base3.10/src/main/webapp/WEB-INF/jsp/egovframework/com/uss/ion/bnr/EgovBannerRegist.jsp =================================================================== --- base3.10/src/main/webapp/WEB-INF/jsp/egovframework/com/uss/ion/bnr/EgovBannerRegist.jsp (nonexistent) +++ base3.10/src/main/webapp/WEB-INF/jsp/egovframework/com/uss/ion/bnr/EgovBannerRegist.jsp (revision 31) @@ -0,0 +1,189 @@ +<%-- +/** + * @Class Name : EgovBannerRegist.jsp + * @Description : EgovBannerRegist.jsp + * @Modification Information + * @ + * @ 수정일 수정자 수정내용 + * @ ------- -------- --------------------------- + * @ 2009.02.01 lee.m.j 최초 생성 + * + * @author lee.m.j + * @since 2009.03.11 + * @version 1.0 + * @see + * + * Copyright (C) 2009 by MOPAS All right reserved. + */ + --%> +<%@ page contentType="text/html; charset=utf-8"%> +<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%> +<%@ taglib prefix="ui" uri="http://egovframework.gov/ctl/ui"%> +<%@ taglib prefix="fn" uri="http://java.sun.com/jsp/jstl/functions"%> +<%@ taglib prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt"%> +<%@ taglib prefix="spring" uri="http://www.springframework.org/tags"%> +<%@ taglib prefix="form" uri="http://www.springframework.org/tags/form"%> +<%@ taglib prefix="validator" uri="http://www.springmodules.org/tags/commons-validator"%> + +<c:set var="pageTitle"><spring:message code="comUssIonBnr.bannerVO.title"/></c:set> +<script type="text/javascript" src="<c:url value="/validator.do"/>"></script> +<validator:javascript formName="banner" staticJavascript="false" xhtml="true" cdata="false" /> +<script type="text/javaScript" language="javascript"> + function fncSelectBannerList() { + var varFrom = document.getElementById("banner"); + varFrom.action = "<c:url value='/uss/ion/bnr/selectBannerList.do'/>"; + varFrom.submit(); + } + + function fncBannerInsert() { + var varFrom = document.getElementById("banner"); + varFrom.action = "<c:url value='/uss/ion/bnr/addBanner.do'/>"; + + if(confirm("<spring:message code="common.save.msg" />")){ + if (!validateBanner(varFrom)) { + return; + } else { + if (varFrom.bannerImageFile.value != '') { + varFrom.submit(); + } else { + alert("배너이미지는 필수 입력값입니다."); + return; + } + } + } + } + + function fncOnChangeImage() { + var varFrom = document.getElementById("banner"); + varFrom.bannerImage.value = varFrom.file_1.value; + } + + function fncBannerDelete() { + var varFrom = document.getElementById("banner"); + varFrom.action = "<c:url value='/uss/ion/bnr/removeBanner.do'/>"; + if(confirm("<spring:message code="common.delete.msg" />")){ + varFrom.submit(); + } + } + // 파일업로드 + $(function() { + var options = { + fileListDivId : 'bannerFileList', + inputFileId : 'egovComFileUploader', + hiddenFileName : 'bannerImageFile', + progress : 'progress', + maxSize : 1, // 첨부파일 등록개수 + fileAllowedTypes: ['png', 'jpg', 'jpeg'], // 확장자 체크 ['png', 'pdf'] + fileMaxSize: 10 // 첨부파일 사이즈 + } + var defaultsDom = function(html) { + var fileIcon = fileExtIcon(html.fileExtsn); + var fileSize = fileSizeConvert(html.fileSize); + + var dom = '<li id=' + html.fileId + '>'; + dom += '<img alt="배너 이미지" src="' + html.link + '">'; + dom += '<div class="btn">'; + dom += '<a class="btn_sq_s btn_delete" href="javascript:void(0)" title="삭제"><span class="blind">삭제</span></a>'; + dom += '<a class="btn_sq_s btn_filedown" href="' + html.link + '" title="다운로드"><span class="blind">다운로드</span></a>'; + dom += '</div>'; + dom += '</li>'; + return dom; + } + + $.initFileUpload(options, defaultsDom); + }); +</script> +<noscript class="noScriptTitle">자바스크립트를 지원하지 않는 브라우저에서는 일부 기능을 사용하실 수 없습니다.</noscript> +<div class="board_header"> + <h3>${pageTitle } + <spring:message code="title.create" /> + </h3> +</div> +<form:form commandName="banner" method="post" action="${pageContext.request.contextPath}/uss/ion/bnr/addBanner.do' />" enctype="multipart/form-data"> + <form:hidden path="bannerImageFile"/> + <div class="board_body"> + <p class="must_text"><em>＊</em>는 필수 입력사항입니다.</p> + <table class="table_write" summary="<spring:message code="common.summary.list" arguments="${pageTitle}" />"> + <caption>배너등록 - 배너명, 링크URL, 배너이미지, 배너설명, 정렬순서, 반영여부로 구성</caption> + <colgroup> + <col class="width200" /> + <col /> + </colgroup> + <tbody> + <tr> + <th scope="row" class="must"><label for="bannerNm"><spring:message code="comUssIonBnr.bannerVO.bannerNm"/></label></th> + <td> + <input name="bannerNm" id="bannerNm" title="<spring:message code="comUssIonBnr.bannerVO.bannerNm"/>" type="text" value="<c:out value='${banner.bannerNm}'/>" maxLength="10" size="30" class="width100p inputText"> + <form:errors path="bannerNm" /> + </td> + </tr> + <tr> + <th scope="row" class="must"><label for="linkUrl"><spring:message code="comUssIonBnr.bannerVO.linkUrl"/></label></th> + <td> + <input name="linkUrl" id="linkUrl" title="<spring:message code="comUssIonBnr.bannerVO.linkUrl"/>" type="text" value="<c:out value='${banner.linkUrl}'/>" maxLength="255" size="50" class="width100p inputText"> + <form:errors path="linkUrl" /> + </td> + </tr> + <tr> + <th scope="row" class="must"><label for="egovComFileUploader"><spring:message code="comUssIonBnr.bannerVO.bannerImage"/></label></th> + <td> + <div class="file_up"> + <label for="egovComFileUploader">파일선택</label> + <input class="upload-name blind" disabled="disabled"> + <input type="file" name="file_1" id="egovComFileUploader" title="<spring:message code="comUssIonBnr.bannerVO.bannerImage"/>"> + </div> + <em class="exp filenote">※ 파일당 10MB까지 첨부 가능합니다.</em> + <div id="progress" class="progress mt-3" style="display: none;"> + <div class="progress-bar" style="width: 0%;">0%</div> + </div> + <ul class="file_img" id="bannerFileList" style="display:none;"></ul> + </td> + </tr> + <tr> + <th scope="row" class="must"><label for="bannerDc"><spring:message code="comUssIonBnr.bannerVO.bannerDc"/></label></th> + <td><input name="bannerDc" id="bannerDc" title="<spring:message code="comUssIonBnr.bannerVO.bannerDc"/>" type="text" value="<c:out value='${banner.bannerDc}'/>" maxLength="100" size="80" class="width100p inputText"></td> + </tr> + <tr> + <th scope="row" class="must"><label for="sortOrdr"><spring:message code="comUssIonBnr.bannerVO.sortOrdr"/></label></th> + <td> + <input name="sortOrdr" id="sortOrdr" type="text" title="<spring:message code="comUssIonBnr.bannerVO.sortOrdr"/>" value="<c:out value='${banner.sortOrdr}'/>" maxLength="5" size="10" class="onlyNumber width100p inputText"> + <form:errors path="sortOrdr" /> + </td> + </tr> + <tr> + <th scope="row" class="must"><label for="reflctAt"><spring:message code="comUssIonBnr.bannerVO.reflctAt"/></label></th> + <td><select name="reflctAt" id="reflctAt" title="<spring:message code="comUssIonBnr.bannerVO.reflctAt"/>" class="select"> + <option value="Y" <c:if test="${banner.reflctAt == 'Y'}">selected</c:if>>Y</option> + <option value="N" <c:if test="${banner.reflctAt == 'N'}">selected</c:if>>N</option> + </select></td> + </tr> + <%-- <tr> + <th scope="row"><label for="regDate">등록일시</label><img src="<c:url value='/images/egovframework/com/cmm/icon/no_required.gif' />" width="15" height="15" alt="선택입력표시"></th> + <td><input name="regDate" id="regDate" title="등록일시" type="text" value="<c:out value="${banner.regDate}"/>" maxLength="20" size="20" class="readOnlyClass" readonly></td> + </tr> --%> + </tbody> + </table> + </div> +  + <input type="hidden" name="searchCondition" value="<c:out value='${bannerVO.searchCondition}'/>"> + <input type="hidden" name="searchKeyword" value="<c:out value='${bannerVO.searchKeyword}'/>"> + <input type="hidden" name="pageIndex" value="<c:out value='${bannerVO.pageIndex}'/>"> + <input type="hidden" name="bannerId" value="<c:out value='${banner.bannerId}'/>"> +  +  + <div class="board_footer"> + <div class="fl bottom_wrap"> + <button class="btn_s" type="button" onclick="fncSelectBannerList();" title="<spring:message code="button.list" /> <spring:message code="input.button" />"> + <spring:message code="button.list" /> + </button> + </div> + <div class="fr bottom_wrap"> + <button class="btn_s" type="button" onclick="fncBannerInsert(); return false;" title="<spring:message code="button.create" /> <spring:message code="input.button" />"> + <spring:message code="button.create" /> + </button> + <%-- <span class="btn_s"><a href="<c:url value='/cop/bbs/selectBBSMasterInfs.do' />" title="<spring:message code="button.list" /> <spring:message code="input.button" />"><spring:message code="button.list" /></a></span> --%> + </div> + </div> +</form:form> + + Property changes on: base3.10/src/main/webapp/WEB-INF/jsp/egovframework/com/uss/ion/bnr/EgovBannerRegist.jsp ___________________________________________________________________ Added: svn:mime-type + text/plain Index: base3.10/src/main/webapp/WEB-INF/jsp/egovframework/com/uss/ion/bnr/EgovBannerMainList.jsp =================================================================== --- base3.10/src/main/webapp/WEB-INF/jsp/egovframework/com/uss/ion/bnr/EgovBannerMainList.jsp (nonexistent) +++ base3.10/src/main/webapp/WEB-INF/jsp/egovframework/com/uss/ion/bnr/EgovBannerMainList.jsp (revision 31) @@ -0,0 +1,70 @@ +<%@ page contentType="text/html; charset=utf-8" pageEncoding="utf-8"%> +<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %> +<%@ taglib prefix="ui" uri="http://egovframework.gov/ctl/ui"%> +<%@ taglib uri="http://java.sun.com/jsp/jstl/functions" prefix="fn" %> +<%@ taglib prefix="spring" uri="http://www.springframework.org/tags"%> +<% + +/** + * @Class Name : EgovBannerMainList.java + * @Description : EgovBannerMainList jsp + * @Modification Information + * @ + * @ 수정일 수정자 수정내용 + * @ --------- -------- --------------------------- + * @ 2009.02.01 lee.m.j 최초 생성 + * + * @author lee.m.j + * @since 2009.03.21 + * @version 1.0 + * @see + * + * Copyright (C) 2009 by MOPAS All right reserved. + */ + +%> +<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> +<html lang="ko"> +<head> +<meta http-equiv="Content-Type" content="text/html; charset=utf-8"> +<title>메인화면 배너 목록조회</title> +<style type="text/css"> + h1 {font-size:12px;} + caption {visibility:hidden; font-size:0; height:0; margin:0; padding:0; line-height:0;} +</style> +<script type="text/javaScript" language="javascript" defer="defer"> + +</script> + +</head> +<body> +<form name="items" method="post" action="<c:url value='/uss/ion/bnr/getBanner.do'/>"> +<div id="all" style="margin:0 auto;width:200px;"> +<table width="200" cellpadding="8" class="table-line" summary="메인화면에서 배너에 대한 목록을 제공한다."> + <caption>메인화면 배너 목록조회</caption> + <tbody> + <c:forEach var="banner" items="${bannerList}" varStatus="status"> + <tr> + <td class="lt_text6" nowrap> + <span class="link"> + <input type="submit" name="bannerNm" id="bannerNm" value="<c:out value="${banner.bannerNm}"/>" onclick="fncSelectBanner('<c:out value="${banner.bannerId}"/>');return false;"/> + </span> + </td> + </tr> + </c:forEach> + </tbody> +</table> +</div> +<input type="hidden" name="bannerId" value=""> +<input type="hidden" name="pageIndex" value="1"> +<input type="hidden" name="searchCondition" value="1"> +<input type="hidden" name="searchKeyword" value=""> +</form> +</body> +</html> Property changes on: base3.10/src/main/webapp/WEB-INF/jsp/egovframework/com/uss/ion/bnr/EgovBannerMainList.jsp ___________________________________________________________________ Added: svn:mime-type + text/plain Index: base3.10/src/main/webapp/WEB-INF/jsp/egovframework/com/uss/ion/bnr/EgovBannerUpdt.jsp =================================================================== --- base3.10/src/main/webapp/WEB-INF/jsp/egovframework/com/uss/ion/bnr/EgovBannerUpdt.jsp (nonexistent) +++ base3.10/src/main/webapp/WEB-INF/jsp/egovframework/com/uss/ion/bnr/EgovBannerUpdt.jsp (revision 31) @@ -0,0 +1,178 @@ +<%-- +/** + * @Class Name : EgovBannerUpdt.jsp + * @Description : EgovBannerUpdt.jsp + * @Modification Information + * @ + * @ 수정일 수정자 수정내용 + * @ ------- -------- --------------------------- + * @ 2009.02.01 lee.m.j 최초 생성 + * + * @author lee.m.j + * @since 2009.03.11 + * @version 1.0 + * @see + * + * Copyright (C) 2009 by MOPAS All right reserved. + */ + --%> + +<%@ page contentType="text/html; charset=utf-8"%> +<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %> +<%@ taglib prefix="ui" uri="http://egovframework.gov/ctl/ui"%> +<%@ taglib prefix="fn" uri="http://java.sun.com/jsp/jstl/functions" %> +<%@ taglib prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt"%> +<%@ taglib prefix="spring" uri="http://www.springframework.org/tags" %> +<%@ taglib prefix="form" uri="http://www.springframework.org/tags/form" %> +<%@ taglib prefix="validator" uri="http://www.springmodules.org/tags/commons-validator" %> + +<c:set var="pageTitle"><spring:message code="comUssIonBnr.bannerVO.title"/></c:set> +<script type="text/javascript" src="<c:url value="/validator.do"/>"></script> +<validator:javascript formName="banner" staticJavascript="false" xhtml="true" cdata="false"/> +<script type="text/javaScript" language="javascript"> + +function fncSelectBannerList() { + var varFrom = document.getElementById("banner"); + varFrom.action = "<c:url value='/uss/ion/bnr/selectBannerList.do'/>"; + varFrom.submit(); +} + +function fncBannerUpdate() { + var varFrom = document.getElementById("banner"); + varFrom.action = "<c:url value='/uss/ion/bnr/updtBanner.do'/>"; + + if(confirm("<spring:message code="common.update.msg" />")){ + if(!validateBanner(varFrom)){ + return; + }else{ + varFrom.submit(); + } + } +} + +function fncBannerDelete() { + var varFrom = document.getElementById("banner"); + varFrom.action = "<c:url value='/uss/ion/bnr/removeBanner.do'/>"; + if(confirm("<spring:message code="common.delete.msg" />")){ + varFrom.submit(); + } +} +$(function() { + var options = { + fileListDivId : 'bannerFileList', + inputFileId : 'egovComFileUploader', + hiddenFileName : 'bannerImageFile', + progress : 'progress', + maxSize : 1, // 첨부파일 등록개수 + fileAllowedTypes: ['png', 'jpg', 'jpeg'], // 확장자 체크 ['png', 'pdf'] + fileMaxSize: 10 // 첨부파일 사이즈 + } + var defaultsDom = function(html) { + var fileIcon = fileExtIcon(html.fileExtsn); + var fileSize = fileSizeConvert(html.fileSize); + + var dom = '<li class="file_list file_img mt5" id=' + html.fileId + '>'; + dom += '<img alt="배너 이미지" src="' + html.link + '" >'; + dom += '<div class="btn">'; + dom += '<a class="btn_sq_s btn_delete" href="javascript:void(0)" title="삭제"><span class="blind">삭제</span></a>'; + dom += '<a class="btn_sq_s btn_filedown" href="' + html.link + '" title="다운로드"><span class="blind">다운로드</span></a>'; + dom += '</div>'; + dom += '</li>'; + return dom; + } + $.initFileUpload(options, defaultsDom); +}); +</script> +<noscript class="noScriptTitle">자바스크립트를 지원하지 않는 브라우저에서는 일부 기능을 사용하실 수 없습니다.</noscript> +<div class="board_header"> + <h3 >${pageTitle } + <spring:message code="title.update" /> + </h3> +</div> +<form:form commandName="banner" method="post" action="${pageContext.request.contextPath}/uss/ion/bnr/updtBanner.do" enctype="multipart/form-data"> + <form:hidden path="bannerImageFile"/> + <div class="board_body"> + <p class="must_text"><em>＊</em>는 필수 입력사항입니다.</p> + <table class="table_write" summary="<spring:message code="common.summary.list" arguments="${pageTitle}" />"> + <caption>배너수정 - 배너명, 링크URL, 배너이미지, 배너설명, 정렬순서, 반영여부로 구성</caption> + <colgroup> + <col class="width200"><col> + </colgroup> + <tbody> + <tr> + <th scope="row" class="must"><label for="bannerNm"><spring:message code="comUssIonBnr.bannerVO.bannerNm"/></label></th> + <td> + <input name="bannerNm" id="bannerNm" title="<spring:message code="comUssIonBnr.bannerVO.bannerNm"/>" type="text" value="<c:out value='${banner.bannerNm}'/>" maxLength="10" size="30" class="width100p inputText"> + <form:errors path="bannerNm" /> + </td> + </tr> + <tr> + <th scope="row" class="must"><label for="linkUrl"><spring:message code="comUssIonBnr.bannerVO.linkUrl"/></label></th> + <td> + <input name="linkUrl" id="linkUrl" title="<spring:message code="comUssIonBnr.bannerVO.linkUrl"/>" type="text" value="<c:out value='${banner.linkUrl}'/>" maxLength="255" size="50" class="width100p inputText"> + <form:errors path="linkUrl" /> + </td> + </tr> + <tr> + <th scope="row" class="must"><label for="egovComFileUploader"><spring:message code="comUssIonBnr.bannerVO.bannerImage"/></label></th> + <td> + <div class="file_up"> + <label for="egovComFileUploader">파일선택</label> + <input class="upload-name blind" disabled="disabled"> + <input type="file" name="file_1" id="egovComFileUploader" title="<spring:message code="comUssIonBnr.bannerVO.bannerImage"/>"> + </div> + <em class="exp filenote">※ 파일당 10MB까지 첨부 가능합니다.</em> + <div id="progress" class="progress mt-3" style="display: none;"> + <div class="progress-bar" style="width: 0%;">0%</div> + </div> + <ul class="file_img" id="bannerFileList" style="display:none;"></ul> + </td> + </tr> + <tr> + <th scope="row" class="must"><label for="bannerDc"><spring:message code="comUssIonBnr.bannerVO.bannerDc"/></label></th> + <td><input name="bannerDc" id="bannerDc" title="<spring:message code="comUssIonBnr.bannerVO.bannerDc"/>" type="text" value="<c:out value='${banner.bannerDc}'/>" maxLength="100" size="80" class="width100p inputText"></td> + </tr> + <tr> + <th scope="row" class="must"><label for="sortOrdr"><spring:message code="comUssIonBnr.bannerVO.sortOrdr"/></label></th> + <td> + <input name="sortOrdr" id="sortOrdr" type="text" title="<spring:message code="comUssIonBnr.bannerVO.sortOrdr"/>" value="<c:out value='${banner.sortOrdr}'/>" maxLength="5" size="10" class="onlyNumber width100p inputText"> + <form:errors path="sortOrdr" /> + </td> + </tr> + <tr> + <th scope="row" class="must"><label for="reflctAt"><spring:message code="comUssIonBnr.bannerVO.reflctAt"/></label></th> + <td><select name="reflctAt" id="reflctAt" title="<spring:message code="comUssIonBnr.bannerVO.reflctAt"/>" class="select"> + <option value="Y" <c:if test="${banner.reflctAt == 'Y'}">selected</c:if>>Y</option> + <option value="N" <c:if test="${banner.reflctAt == 'N'}">selected</c:if>>N</option> + </select></td> + </tr> + <%-- <tr> + <th scope="row"><label for="regDate">등록일시</label><img src="<c:url value='/images/egovframework/com/cmm/icon/no_required.gif' />" width="15" height="15" alt="선택입력표시"></th> + <td><input name="regDate" id="regDate" title="등록일시" type="text" value="<c:out value="${banner.regDate}"/>" maxLength="20" size="20" class="readOnlyClass" readonly></td> + </tr> --%> + </tbody> + </table> + </div> +  + <input type="hidden" name="searchCondition" value="<c:out value='${bannerVO.searchCondition}'/>"> + <input type="hidden" name="searchKeyword" value="<c:out value='${bannerVO.searchKeyword}'/>"> + <input type="hidden" name="pageIndex" value="<c:out value='${bannerVO.pageIndex}'/>"> + <input type="hidden" name="bannerId" value="<c:out value='${banner.bannerId}'/>" > +  +  + <div class="board_footer"> + <div class="fl bottom_wrap"> + <button class="btn_s" type="button" onclick="fncSelectBannerList(); return false;" title="<spring:message code="button.list" /> <spring:message code="input.button" />"> + <spring:message code="button.list" /> + </button> + </div> + <div class="fr bottom_wrap"> + <button class="btn_s" type="button" onclick="fncBannerDelete(); return false;" title="<spring:message code="button.delete" /> <spring:message code="input.button" />"> + <spring:message code="button.delete" /> + </button> + <button class="btn_s" type="button" onclick="fncBannerUpdate(); return false;" title="<spring:message code="button.save" /> <spring:message code="input.button" />"> + <spring:message code="button.save" /> + </button> + </div> + </div> +</form:form> \ No newline at end of file Property changes on: base3.10/src/main/webapp/WEB-INF/jsp/egovframework/com/uss/ion/bnr/EgovBannerUpdt.jsp ___________________________________________________________________ Added: svn:mime-type + text/plain Index: base3.10/src/main/webapp/WEB-INF/jsp/egovframework/com/uss/ion/bnr/EgovBannerList.jsp =================================================================== --- base3.10/src/main/webapp/WEB-INF/jsp/egovframework/com/uss/ion/bnr/EgovBannerList.jsp (nonexistent) +++ base3.10/src/main/webapp/WEB-INF/jsp/egovframework/com/uss/ion/bnr/EgovBannerList.jsp (revision 31) @@ -0,0 +1,212 @@ +<%@ page contentType="text/html; charset=utf-8" pageEncoding="utf-8"%> +<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %> +<%@ taglib prefix="ui" uri="http://egovframework.gov/ctl/ui"%> +<%@ taglib uri="http://java.sun.com/jsp/jstl/functions" prefix="fn" %> +<%@ taglib prefix="spring" uri="http://www.springframework.org/tags"%> + +<c:set var="pageTitle"><spring:message code="comUssIonBnr.bannerVO.title"/></c:set> +<% + +/** + * @Class Name : EgovBannerList.java + * @Description : EgovBannerList jsp + * @Modification Information + * @ + * @ 수정일 수정자 수정내용 + * @ --------- -------- --------------------------- + * @ 2009.02.01 lee.m.j 최초 생성 + * + * @author lee.m.j + * @since 2009.03.21 + * @version 1.0 + * @see + * + * Copyright (C) 2009 by MOPAS All right reserved. + */ + +%> +<script type="text/javaScript" language="javascript" defer="defer"> + +</script> + +<noscript class="noScriptTitle">자바스크립트를 지원하지 않는 브라우저에서는 일부 기능을 사용하실 수 없습니다.</noscript> +<form name="listForm" action="<c:url value='/uss/ion/bnr/selectBannerList.do'/>" method="post"> + <div class="board_header"> + <h3>${pageTitle } <spring:message code="title.list"/></h3> +  + <div class="search_box" title="<spring:message code="common.searchCondition.msg" />"> +  + <input class="inputText" name="searchKeyword" type="text" size="35" title="<spring:message code="title.search" /> <spring:message code="input.input" />" value='<c:out value="${bannerVO.searchKeyword}"/>' maxlength="155" placeholder="검색어를 입력하세요"> + <button type="button" class="btn_board" style="margin-left:3px;" onclick="fncSelectBannerList('1'); return false;"><spring:message code="button.inquire" /></button> + </div> + </div> + <input type="hidden" name="bannerId"> + <input type="hidden" name="pageIndex" value="<c:if test="${empty bannerVO.pageIndex }">1</c:if><c:if test="${!empty bannerVO.pageIndex }"><c:out value='${bannerVO.pageIndex}'/></c:if>"> + <input type="hidden" name="searchCondition" value="1"> + <div class="board_body"> + <div class="board_infomation"> + <p>총 : <span>${paginationInfo.totalRecordCount}</span>건, 쪽번호 : <span>${paginationInfo.currentPageNo }</span> / <span>${paginationInfo.totalPageCount }</span></p> + </div> +  + <table class="table_list"> + <colgroup> + <col style="width: 5%;"> + <col> + <col style="width: 20%;"> + <col style="width: 20%;"> + <col style="width: 8%;"> + </colgroup> + <thead> + <tr> + <th scope="col"><spring:message code="table.num" /></th> + <th scope="col" class="board_th_link"><spring:message code="comUssIonBnr.bannerVO.bannerNm"/></th> + <th scope="col"><spring:message code="comUssIonBnr.bannerVO.linkUrl"/></th> + <th scope="col"><spring:message code="comUssIonBnr.bannerVO.bannerDc"/></th> + <th scope="col"><spring:message code="comUssIonBnr.bannerVO.reflctAt"/></th> + </tr> + </thead> + <tbody> + <c:if test="${fn:length(bannerList) == 0}"> + <tr> + <td colspan="5"><spring:message code="common.nodata.msg" /></td> + </tr> + </c:if> + <c:forEach items="${bannerList}" var="banner" varStatus="status"> + <tr> + <td><c:out value="${paginationInfo.totalRecordCount - ((paginationInfo.currentPageNo-1) * paginationInfo.recordCountPerPage + status.index) }"/></td> + <td class="alignL"><a href="#" onclick="fncSelectBanner('<c:out value="${banner.bannerId}"/>'); return false;"><c:out value="${banner.bannerNm}"/></a></td> + <td class="alignL"><c:out value="${banner.linkUrl}"/></td> + <td><c:out value='${banner.bannerDc}'/></td> + <td><c:out value='${banner.reflctAt}'/></td> + </tr> + </c:forEach> + </tbody> + </table> + </div> + <div class="board_footer"> +  + <div class="page" role="group" aria-label="..."> + <ul> + <ui:pagination paginationInfo="${paginationInfo}" type="admin" jsFunction="linkPage" /> + </ul> + </div> + <div class="fr bottom_wrap"> + <button type="button" onclick="fncAddBannerInsert(); return false;" class="btn_s"><spring:message code="button.create" /></button> + </div> + </div> +</form> + Property changes on: base3.10/src/main/webapp/WEB-INF/jsp/egovframework/com/uss/ion/bnr/EgovBannerList.jsp ___________________________________________________________________ Added: svn:mime-type + text/plain

Add a comment

List

Delete comment