티스토리 뷰

코딩/spring

[21주 2일차] 프로젝트

ehzim 2024. 2. 27. 19:35

 

 

 

 

변경사항 1.

이전 경기 표기할 시 각 팀의 이름을 변수처리하여 불러와주었다.

 

변경사항 2.

Score Board에서 또한 같은 작업을 해주었다.

 

<div class="site-section mt-5">
      <div class="container">
        <div class="row">
          <div class="col-lg-6">
            <div class="widget-next-match">
              <div class="widget-title col-md-6">
                <h3 class="heading">이전 경기</h3>
              </div>
              <div class="widget-body mb-3">
                <div class="widget-vs">
                  <div class="d-flex align-items-center justify-content-around justify-content-between w-100">
                    <div class="team-1 text-center">
                      <!-- <img src="images/logo_1.png" alt="Image"> -->
                      <h3>${game.teamName1}(win)</h3>
                    </div>
                    <div>
                      <span class="vs"><span>VS</span></span>
                    </div>
                    <div class="team-2 text-center">
                      <!-- <img src="images/logo_2.png" alt="Image"> -->
                      <h3>${match.teamName } (loss)</h3>
                    </div>
                  </div>
                </div>
              </div>

              <div class="text-center widget-vs-contents mb-4">
                <h4>Tournament Event</h4>
                <p class="mb-5">
                  <span class="d-block">December 20th, 2020</span>
                  <span class="d-block">9:30 AM GMT+0</span>
                  <h1><strong class="text-primary"><span>4</span> : <span style="color:#185da7!important;">3</span></strong></h1>
                </p>
              </div>
            </div>
          </div>
          <div class="col-lg-6">
            
             <div>
              <table class="table custom-table">
                <thead>
                  <tr>  
	                <th 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="teamWinning" items="${winningList}">
                  <tr>
                    <td><strong>${teamWinning.rank}</strong></td>
                    <td><img src="<c:url value='/resources/images/${teamWinning.fileName}'/>" alt="${teamWinning.teamName} Image" style="width: 1.6rem;"><strong>${teamWinning.teamName}</strong> </td>
	                <td>${teamWinning.matches}</td>
	                <td>${teamWinning.totalWins}</td>
	                <td>${teamWinning.totalTie}</td>
	                <td>${teamWinning.totalLose}</td>
	                <td>${teamWinning.rate}</td>
                  </tr>
                  </c:forEach>
                </tbody>
              </table>
            </div>
          </div>
        </div>
      </div>
    </div> <!-- .site-section -->
          </div>
        </div>
      </div>
    </div> <!-- .site-section -->

    <div class="site-section p-5 shadow-sm bg-body-tertiary rounded">
      <div class="container">
        <div class="row">
          <div class="col-6 title-section">
            <h2 class="heading">Score Board</h2>
          </div>
            <table class="table table-borderless" style="width: 100%;">
              <thead>
                <tr>
                  <th scope="col">팀명…</th>
                  <th scope="col">1</th>
                  <th scope="col">2</th>
                  <th scope="col">3</th>
                  <th scope="col">4</th>
                  <th scope="col">5</th>
                  <th scope="col">6</th>
                  <th scope="col">7</th>
                  <th scope="col">8</th>
                  <th scope="col">9</th>
                  <th scope="col">R</th>
                  <th scope="col">H</th>
                  <th scope="col">E</th>
                  <th scope="col">B</th>
                </tr>
              </thead>
              <tbody>
                <tr>
                  <th scope="row">${game.teamName1}</th>
                  <td>0</td>
                  <td>0</td>
                  <td>0</td>
                  <td>0</td>
                  <td>0</td>
                  <td>0</td>
                  <td>0</td>
                  <td>0</td>
                  <td>0</td>
                  <td>0</td>
                  <td>0</td>
                  <td>0</td>
                  <td>0</td>
                </tr>
                <tr>
                  <th scope="row">${match.teamName }</th>
                  <td>0</td>
                  <td>0</td>
                  <td>0</td>
                  <td>0</td>
                  <td>0</td>
                  <td>0</td>
                  <td>0</td>
                  <td>0</td>
                  <td>0</td>
                  <td>0</td>
                  <td>0</td>
                  <td>0</td>
                  <td>0</td>
                </tr>
              </tbody>
            </table>
          </div>
        </div>

 

 

 

 

 

 

변경 사항 1.

구단 등록시 구단 설명글을 작성할 수 있도록 db를 변경해주었다.

 

 

 

   drop table team;

    create table if not EXISTS team(
		t_id varchar(20) NOT NULL primary key,
        t_name varchar(10) NOT NULL,
        t_people tinyint,
        t_number char(20),
        t_leader char(10),
        t_place char(10),
        t_filename varchar(30),
        description varchar(500)
    )default charset=utf8;

 

 

 

 

 

 

 

 

 

 

문제1.

팀 상세보기 페이지에 메인 사진이 출력 안된다.

경로 문제가 아닌것같다. (이미지의 url이 정상적으로 들어가있음)

어떠한 문제인지 확인해봐야할듯

 

문제2.

팀 상세보기 페이지의 뷰가 수정 필요해보인다.

 

	<!-- ================ end banner area ================= -->
	<div class="container">
		<nav class="bread_c" style="--bs-breadcrumb-divider: '>';" aria-label="breadcrumb">
			<ol class="breadcrumb breadhospital">
			  <li class="breadcrumb-item"><a href="#">팀목록</a></li>
			  <li class="breadcrumb-item active" aria-current="page">${tb.teamName}</li>
			</ol>
		</nav>
	</div>

  <!--================Single Product Area =================-->
	<div class="product_image_area">
		<div class="container">
			<div class="row s_product_inner">
				<div class="col-lg-6">
					<div class="owl-carousel owl-theme s_Product_carousel">
						<div class="single-prd-item">
							<img src="<c:url value='/resources/images/${tb.fileName}'/>" style="width: 50%"/>
						</div>
					</div>
				</div>
				<div class="col-lg-5 offset-lg-1">
					<div class="s_product_text">
						<h3>${tb.teamId}</h3>
						<h2>${tb.teamName }</h2>
						<ul class="list">
							<li>대표번호 : ${tb.phoneNumber }</li>
							<li>선호지역 : ${tb.prefArea }</li>
						</ul>                       
						<p>${tb.description }</p>
						<div class="product_count">
                            <input type="date" name="birth" id="b" min="1996-12-30"  style="width:150px;font-size:15px;">
							<a href='<c:url value="/team/result/winning?id=${tb.teamId}"/>' class="btn btn-sm btn-primary" >경기결과</a>      
							<a href="<c:url value='/team/result/add?id=${tb.teamId}'/>" class="btn btn-sm btn-primary" >가입신청</a>
							<a href="<c:url value='/team/result/add?id=${tb.teamId}'/>" class="btn btn-sm btn-primary" >경기결과수정</a>
							<a href="<c:url value='/team/delete?id=${tb.teamId}'/>" class="btn btn-sm btn-primary" onclick="return deleteConfirm('${tb.teamId}')">삭제</a>
							<a href='<c:url value="/team/result/recent?id=${tb.teamId}"/>' class="btn btn-sm btn-primary" >최근경기결과</a>
							<a href='<c:url value="/team/update?id=${tb.teamId}"/>' class="btn btn-sm btn-primary" >수정</a>
						</div>
						<div class="card_area d-flex align-items-center">
							<a class="icon_btn" href="#"><i class="lnr lnr lnr-diamond"></i></a>
							<a class="icon_btn" href="#"><i class="lnr lnr lnr-heart"></i></a>
						</div>
					</div>
				</div>
			</div>
		</div>
	</div>
	<!--================End Single Product Area =================-->	

<div class="tab-pane fade show active" id="review" role="tabpanel" aria-labelledby="review-tab">
					<div class="row">
						<div class="col-lg-6">
							<div class="row total_rate">
								<div class="col-6">
									<div class="box_total">
									<img src="<c:url value='/resources/images/${tb.fileName}'/>" style="width: 50%"/>
										<h5>${tb.teamName}</h5>
										<!-- <h4>4.0</h4> -->
									</div>	
								</div>
								<div class="col-6">
									<div class="rating_list">
										<ul class="list">
											<li><a href="#">5 Star <i class="fa fa-star"></i><i class="fa fa-star"></i><i class="fa fa-star"></i><i
													 class="fa fa-star"></i><i class="fa fa-star"></i> 01</a></li>
											<li><a href="#">4 Star <i class="fa fa-star"></i><i class="fa fa-star"></i><i class="fa fa-star"></i><i
													 class="fa fa-star"></i><i class="fa fa-star"></i> 01</a></li>
											<li><a href="#">3 Star <i class="fa fa-star"></i><i class="fa fa-star"></i><i class="fa fa-star"></i><i
													 class="fa fa-star"></i><i class="fa fa-star"></i> 01</a></li>
											<li><a href="#">2 Star <i class="fa fa-star"></i><i class="fa fa-star"></i><i class="fa fa-star"></i><i
													 class="fa fa-star"></i><i class="fa fa-star"></i> 01</a></li>
											<li><a href="#">1 Star <i class="fa fa-star"></i><i class="fa fa-star"></i><i class="fa fa-star"></i><i
													 class="fa fa-star"></i><i class="fa fa-star"></i> 01</a></li>
										</ul>
									</div>
								</div>
							</div>
							<br>
							<!-- card-->
					        <div class="card mb-3" style="width: 60%;">
					            <div class="row g-0">
						            <div class="col-md-4 ">
						                <!-- <img src="..." class="img-fluid rounded-start" alt="..."> -->
						                <i class="fa fa-star"></i>
						            </div>
						            <div class="col-md-8">
						                <div class="card-body">           
						                <p class="card-text">총 게임수</p>
						                <span class="fw-semibold">${totalGames}</span>
						                </div>
						            </div>
					            </div>
    					    </div>
    					    <div class="card mb-3" style="width: 60%;">
					            <div class="row g-0">
						            <div class="col-md-4 ">
						                <!-- <img src="..." class="img-fluid rounded-start" alt="..."> -->
						                <i class="fa fa-star"></i>
						            </div>
						            <div class="col-md-8">
						                <div class="card-body">           
						                <p class="card-text">총 이긴 게임 수</p>
						                <span class="fw-semibold">${totalWins}</span>
						                </div>
						            </div>
					            </div>
    					    </div>
    					    <div class="card mb-3" style="width: 60%;">
					            <div class="row g-0">
						            <div class="col-md-4 ">
						                <!-- <img src="..." class="img-fluid rounded-start" alt="..."> -->
						                <i class="fa fa-star"></i>
						            </div>
						            <div class="col-md-8">
						                <div class="card-body">           
						                <p class="card-text">무승부</p>
						                <span class="fw-semibold">${totalTies}</span>
						                </div>
						            </div>
					            </div>
    					    </div>
    					    <div class="card mb-3" style="width: 60%;">
					            <div class="row g-0">
						            <div class="col-md-4 ">
						                <!-- <img src="..." class="img-fluid rounded-start" alt="..."> -->
						                <i class="fa fa-star"></i>
						            </div>
						            <div class="col-md-8">
						                <div class="card-body">           
						                <p class="card-text">패배</p>
						                <span class="fw-semibold">${totalLosses}</span>
						                </div>
						            </div>
					            </div>
    					    </div>
    					    <div class="card mb-3" style="width: 60%;">
					            <div class="row g-0">
						            <div class="col-md-4 ">
						                <!-- <img src="..." class="img-fluid rounded-start" alt="..."> -->
						                <i class="fa fa-star"></i>
						            </div>
						            <div class="col-md-8">
						                <div class="card-body">           
						                <p class="card-text">승률</p>
						                <span class="fw-semibold">${winningRate}</span>
						                </div>
						            </div>
					            </div>
    					    </div>
							<!-- <div class="review_list">
								<div class="review_item">
								
								</div>
							</div> -->
						</div>
						
						<div class="col-lg-6">
							<div class="review_box">
								<h4>가입신청</h4>
				                <form action="#/" class="form-contact form-review mt-3">
				                  <div class="form-group">
				                    <input class="form-control" name="name" type="text" placeholder="이름을 입력하세요." required>
				                  </div>
				                  <div class="form-group">
				                    <input class="form-control" name="email" type="email" placeholder="이메일을 입력하세요." required>
				                  </div>
				                  <div class="form-group">
				                    <input class="form-control" name="subject" type="text" placeholder="제목을 입력하세요.">
				                  </div>
				                  <div class="form-group">
				                    <textarea class="form-control different-control w-100" name="textarea" id="textarea" cols="30" rows="5" placeholder="글을 작성하세요."></textarea>
				                  </div>
				                  <div class="form-group text-center text-md-right mt-3">
				                    <button type="submit" class="button button--active button-review">등록</button>
				                  </div>
				                </form>
							</div>
						</div>
					</div>
				</div>
			</div>
		</div>
	</section>
	<!--================End Product Description Area =================-->

 

 

 

 

 

해야할 일

멤버 테이블 구성을 다시 해야할 것같다.

그리고.... 가입시 구단을 검색하는 기능이 있으면 좋을것같다는 생각...

공지사항
최근에 올라온 글
최근에 달린 댓글
Total
Today
Yesterday