Coding/전자정부프레임
3.사용자 예약프로그램 만들기
by 찡콩찡
2022. 9. 21.
package egovframework.let.rsv.web;
import java.util.List;
import javax.annotation.Resource;
import javax.servlet.http.HttpServletRequest;
import org.springframework.stereotype.Controller;
import org.springframework.ui.ModelMap;
import org.springframework.web.bind.annotation.ModelAttribute;
import org.springframework.web.bind.annotation.RequestMapping;
import egovframework.com.cmm.LoginVO;
import egovframework.com.cmm.util.EgovUserDetailsHelper;
import egovframework.let.rsv.service.ReservationService;
import egovframework.let.rsv.service.ReservationVO;
import egovframework.rte.psl.dataaccess.util.EgovMap;
import egovframework.rte.ptl.mvc.tags.ui.pagination.PaginationInfo;
@Controller
public class ReservationController {
@Resource(name="reservationService")
private ReservationService reservationService;
@RequestMapping(value="/rsv/selectList.do")
public String rsvSelectList(@ModelAttribute("searchVO") ReservationVO searchVO, HttpServletRequest request, ModelMap model) throws Exception{
PaginationInfo paginationInfo = new PaginationInfo();
paginationInfo.setCurrentPageNo(searchVO.getPageIndex());
paginationInfo.setRecordCountPerPage(searchVO.getPageUnit());
paginationInfo.setPageSize(searchVO.getPageSize());
searchVO.setFirstIndex(paginationInfo.getFirstRecordIndex());
searchVO.setLastIndex(paginationInfo.getLastRecordIndex());
searchVO.setRecordCountPerPage(paginationInfo.getRecordCountPerPage());
List<EgovMap> resultList = reservationService.selectReservationList(searchVO);
model.addAttribute("resultList" , resultList );
int totCnt = reservationService.selectReservationListCnt(searchVO);
paginationInfo.setTotalRecordCount(totCnt);
model.addAttribute("paginationInfo", paginationInfo);
LoginVO user = (LoginVO)EgovUserDetailsHelper.getAuthenticatedUser();
model.addAttribute("USER_INFO", user);
return "/rsv/RsvSelectList";
}
}
<%@ page language="java" 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="fmt" uri="http://java.sun.com/jsp/jstl/fmt" %>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Language" content="ko">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width,initial-scale=1.0,minimum-scale=1.0,maximum-scale=1.0,user-scalable=no"/>
<title>수업용 게시판</title>
<!-- BBS Style -->
<link href="/asset/study/BBSTMP_0000000000001/style.css" rel="stylesheet"/>
<!-- 공통 style -->
<link href="/asset/study/LYTTMP_0000000000000/style.css" rel="stylesheet"/>
<script src="http://code.jquery.com/jquery-latest.min.js"></script>
<!-- JQUERY UI -->
<script src="https://code.jquery.com/ui/1.12.1/jquery-ui.js"></script>
<link rel="stylesheet" href="//code.jquery.com/ui/1.12.1/themes/base/jquery-ui.css">
<script src="//cdnjs.cloudflare.com/ajax/libs/timepicker/1.3.5/jquery.timepicker.min.js"></script>
<link rel="stylesheet" href="//cdnjs.cloudflare.com/ajax/libs/timepicker/1.3.5/jquery.timepicker.mis.css">
</head>
<body>
<c:choose>
<c:when test="${not empty searchVO.resveId}">
<c:set var="actionUrl" value="/admin/rsv/rsvUpdate.do"/>
</c:when>
<c:otherwise>
<c:set var="actionUrl" value="/admin/rsv/rsvInsert.do"/>
</c:otherwise>
</c:choose>
<%--기본url --%>
<c:url var="_BASE_PARAM" value="">
<c:param name="searchCondition" value="${searchVO.searchCondition}"/>
<c:if test="${not empty searchVO.searchKeyword}">
<c:param name="searchKeyword" value="${searchVO.searchKeyword}"/>
</c:if>
</c:url>
<!-- content 시작 -->
<div id="content">
<div class="container">
<div id="contents">
<!-- 검색영역 -->
<div id="bbs_search">
<form name="frm" method="post" action="/rsv/selectList.do">
<fieldset>
<legend>검색조건입력폼</legend>
<label for="ftext" class="hdn">검색분류선택</label>
<select name="searchCondition" id="ftext">
<option value="0" <c:if test="${searchVO.searchCondition eq '0'}">selected="selected"</c:if>>프로그램명</option>
<option value="1" <c:if test="${searchVO.searchCondition eq '1'}">selected="selected"</c:if>>내용</option>
</select>
<label for="inp_text" class="hdn">검색어입력</label>
<input name="searchKeyword" value="<c:out value="${searchVO.searchKeyword}"/>" type="text" class="inp_s" id="inp_text"/>
<span class="bbtn_s"><input type="submit" value="검색" title="검색(수업용 예약관리 게시물 내)"/></span>
</fieldset>
</form>
</div>
<!-- 목록영역 -->
<div id="bbs_wrap">
<div class="total">
총 게시물
<strong><c:out value="${paginationInfo.totalRecordCount}"/></strong>건 |
현재페이지<strong><c:out value="${paginationInfo.currentPageNo}"/></strong>/
<c:out value="${paginationInfo.totalPageCount}"/>
</div>
<div class="bbs_list">
<table class="list_table">
<thead>
<tr>
<th class="num" scope="col">번호</th>
<th class="tit" scope="col">프로그램명</th>
<th scope="col">신청유형</th>
<th scope="col">신청기간</th>
<th scope="col">운영일</th>
<th scope="col">운영시간</th>
<th scope="col">강사명</th>
<th scope="col">상태</th>
</tr>
</thead>
<tbody>
<c:forEach var="result" items="${resultList}" varStatus="status">
<tr>
<td class="num"><c:out value="${paginationInfo.totalRecordCount - ((searchVO.pageIndex-1) * searchVO.pageUnit) - (status.count - 1)}"/>
</td>
<td class="tit">
<c:url var="viewUrl" value="/rsv/rsvSelect.do${_BASE_PARAM}">
<c:param name="resveId" value="${result.resveId}"/>
<c:param name="pageIndex" value="${searchVO.pageIndex}"/>
</c:url>
<a href="${viewUrl}">
<c:out value="${result.resveSj}"/>
</a>
</td>
<td>
<c:choose>
<c:when test="${result.resveSeCode eq 'TYPE01'}">선착순</c:when>
<c:when test="${result.resveSeCode eq 'TYPE02'}">승인관리</c:when>
<c:otherwise>-</c:otherwise>
</c:choose>
</td>
<td>
<c:out value="${result.reqstBgnde}"/>~<br/>
<c:out value="${result.reqstEndde}"/>
</td>
<td>
<c:out value="${result.useBeginDt}"/>~<br/>
<c:out value="${result.useEndDt}"/>
</td>
<td><c:out value="${result.useBeginTime}~${result.useEndTime}"/></td>
<td><c:out value="${result.recNm}"/></td>
<td>
<c:choose>
<c:when test="${result.applyStatus eq '1'}">접수대기중</c:when>
<c:when test="${result.applyStatus eq '2'}">접수중</c:when>
<c:when test="${result.applyStatus eq '3'}">접수마감</c:when>
<c:when test="${result.applyStatus eq '4'}">운영중</c:when>
<c:otherwise>종료</c:otherwise>
</c:choose>
</td>
</tr>
</c:forEach>
<!-- 글이 없는 경우 -->
<c:if test="${fn:length(resultList)==0}">
<tr class="empty"><td colspan="8">검색 데이터가 없습니다.</td></tr>
</c:if>
</tbody>
</table>
</div>
<div id="paging">
<c:url var="pageUrl" value="/rsv/selectList.do${_BASE_PARAM}"/>
<c:set var="pagingParam"><c:out value="${pageUrl}"/></c:set>
<ui:pagination paginationInfo="${paginationInfo}" type="image" jsFunction="${pagingParam}"/>
</div>
</div>
</div>
</div>
</div>
<!-- content끝 -->
<script>
<c:if test="${not empty message}">
alert("${message}");
</c:if>
</script>
</body>
</html>
