오류 및 문제점
1. 날짜 타입 변경
- 문제점: 입출고 날짜의 타입을 varchar에서 datetime으로 변경했다.
- 해결 방안: java에서 Timestamp를 사용한다.
private Timestamp warehousing_date;
Timestamp warehousing_date;
warehousing_date = rs.getTimestamp("unstoring_date");
<td><fmt:formatDate value="${warehousing.warehousing_date}" pattern="yyyy-MM-dd hh:mm:ss"/></td>
2. 상품 등록, 수정 시 카테고리 외래키 제한
- 문제점: 상품 카테고리를 select로 변경했기 때문에 선택이 되지 않은 경우를 제한해야 한다.
- 해결 방안: 등록 버튼을 눌렀을 때 input의 value가 카테고리 선택이면 submit이 되지 않도록 한다.
$("#productInsertBtn").on("click", function() {
if(confirm("정말 등록하시겠습니까?") === true) {
if($("#selectedInsertCategory").attr("value") != "카테고리 선택") {
return true;
} else {
alert("카테고리를 선택해주세요.");
}
}
return false;
});
진행 상황
1. index 화면 꾸미기
<style>
#product-service {
background-image: url("/img/product.png");
}
</style>
<div class="container-fluid" style="padding: 0px;">
<div id="carouselExampleAutoplaying" class="carousel slide" data-bs-ride="carousel">
<div class="carousel-inner">
<div class="carousel-item active">
<img src="/img/1.jpg" class="d-block w-100" alt="farm1">
</div>
<div class="carousel-item">
<img src="/img/2.jpg" class="d-block w-100" alt="farm2">
</div>
<div class="carousel-item">
<img src="/img/3.png" class="d-block w-100" alt="farm3">
</div>
<div class="carousel-item">
<img src="/img/4.png" class="d-block w-100" alt="item1">
</div>
<div class="carousel-item">
<img src="/img/5.png" class="d-block w-100" alt="item2">
</div>
</div>
<button class="carousel-control-prev" type="button" data-bs-target="#carouselExampleAutoplaying" data-bs-slide="prev">
<span class="carousel-control-prev-icon" aria-hidden="true"></span>
<span class="visually-hidden">Previous</span>
</button>
<button class="carousel-control-next" type="button" data-bs-target="#carouselExampleAutoplaying" data-bs-slide="next">
<span class="carousel-control-next-icon" aria-hidden="true"></span>
<span class="visually-hidden">Next</span>
</button>
</div>
<div id="index-content">
<div class="circle-container">
<h1>ITEM FARM's Service</h1>
<div class="container text-center">
<div class="row align-items-center">
<div class="col service-list">
<div class="circle" id="product-service"></div>
<span>상품</span>
</div>
<div class="col service-list">
<div class="circle" id="balju-service"></div>
<span>발주</span>
</div>
<div class="col service-list">
<div class="circle" id="storing-service"></div>
<span>입고</span>
</div>
<div class="col service-list">
<div class="circle" id="unstoring-service"></div>
<span>출고</span>
</div>
</div>
</div>
</div>
<h1 class="index-title">ITEM FARM's Special</h1>
<div class="d-flex">
<div class="p-2 w-50 text-center"><img src="/img/statistic.png" width="300"></div>
<div class="p-2 w-50 text-left align-self-center">
<p>일별 매출 통계</p>
<p>카테고리별 매출 통계</p>
<p>상품별 매출 통계</p>
</div>
</div>
<hr>
<div class="circle-container">
<h1 class="index-title">Contributors</h1>
<div class="container text-center">
<p><i class="fas fa-exclamation-triangle"></i> 이름을 누르면 github 페이지로 이동합니다.</p>
<div class="row align-items-center">
<div class="col service-list">
<div class="circle" id="ty-img"></div>
<div>
<a class="mr-2 d-none d-lg-inline text-gray-600" href="https://github.com/teon98" target="_blank">
<img src="/img/github.png" width="20"> <span>ty</span></a>
</div>
</div>
<div class="col service-list">
<div class="circle" id="yh-img"></div>
<div>
<a class="mr-2 d-none d-lg-inline text-gray-600" href="https://github.com/djdjdddd" target="_blank">
<img src="/img/github.png" width="20"> <span>yh</span></a>
</div>
</div>
<div class="col service-list">
<div class="circle" id="eb-img"></div>
<div>
<a class="mr-2 d-none d-lg-inline text-gray-600" href="https://github.com/svbean77" target="_blank">
<img src="/img/github.png" width="20"> <span>eb</span></a>
</div>
</div>
<div class="col service-list">
<div class="circle" id="ls-img"></div>
<div>
<a class="mr-2 d-none d-lg-inline text-gray-600" href="https://github.com/leessol" target="_blank">
<img src="/img/github.png" width="20"> <span>ls</span></a>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
참고 자료