[프로젝트] 웹 ITEM FARM - day09

_bean_·2023년 4월 27일
1
post-thumbnail

오류 및 문제점

1. 날짜 타입 변경

  • 문제점: 입출고 날짜의 타입을 varchar에서 datetime으로 변경했다.
  • 해결 방안: java에서 Timestamp를 사용한다.
// WarehousingVO.java
private Timestamp warehousing_date;

// WarehousingDAO.java
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;">
  <!-- image slide -->
  <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">
    <!-- service contents -->
    <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>
						
    <!-- special service -->
    <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>

참고 자료

profile
어쩌다 풀스택 :3

0개의 댓글