-
Notifications
You must be signed in to change notification settings - Fork 0
/
popup.jsp
147 lines (138 loc) · 7.06 KB
/
popup.jsp
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
<%
if(hasId) {
_id = Integer.parseInt(request.getParameter("id"));
String _author = "";
Integer _rating = 0;
Integer _price = 0;
String _publisher = "";
String _genres = "";
String _synopsis = "";
String _sample = "";
String _series = "";
Book book = null;
query = "SELECT * FROM products WHERE product_id = " + _id;
result = statement.executeQuery(query);
if(result.next()){
_title = result.getString(2);
_volume = result.getInt(3);
_thumbnail = result.getString(4);
_author = result.getString(5);
_rating = result.getInt(6);
_price = result.getInt(7);
_publisher = result.getString(8);
_genres = result.getString(9);
_synopsis = result.getString(10);
_sample = result.getString(11);
_series = result.getString(12);
book = new Book(_id, _title, _volume, _thumbnail, _author, _rating, _price, _publisher, _genres, _synopsis, _sample, _series);
}
int currPage = 1;
if(request.getParameter("page") != null)
currPage = Integer.parseInt(request.getParameter("page"));
int perPage = 5;
int offSet = (currPage - 1) * perPage;
Vector<Book> series = new Vector<Book>();
query = "SELECT * FROM products WHERE product_series = '"+_series+"' LIMIT "+offSet+","+perPage+"";
result = statement.executeQuery(query);
while(result.next()){
_id = result.getInt(1);
_title = result.getString(2);
_volume = result.getInt(3);
_thumbnail = result.getString(4);
series.add(new Book(_id, _title, _volume, _thumbnail));
}
String backUrl = "";
String seriesUrl = "";
if(search_key != null){
backUrl = seriesUrl = "./search_result.jsp?search_key="+search_key+"&search_category="+search_category+"&";
}
else if(search_category != null){
backUrl = seriesUrl = "./items.jsp?category="+category;
}
else{
backUrl = seriesUrl = "./index.jsp?";
}
%>
<div class="manga_detail_popup">
<div class="detail_container">
<div class="close_btn">
<a class='fas fa-times' href='<%= backUrl%>'></a>
</div>
<div class="manga_detail">
<div class="title_author_star">
<div class="title_wrapper">
<div class="cell_title">Title</div>
<div class="cell_value"><%= book.title +" - Volume "+ book.volume %></div>
</div>
<div class="author_wrapper">
<div class="cell_title">Author</div>
<div class="cell_value"><%= book.author %></div>
</div>
<span class="star_wrapper" value="<%= book.rating %>">
<i class="fas fa-star"></i>
<i class="fas fa-star"></i>
<i class="fas fa-star"></i>
<i class="fas fa-star"></i>
<i class="fas fa-star"></i>
<!-- <span class="manga_rating">()</span> -->
</span>
</div>
<div class="price_wrapper">
<div class="cell_title">Price</div>
<div class="cell_value">Rp. <%= book.price %>,00 (tax included)</div>
</div>
<div class="publisher_genre">
<div class="publisher_wrapper">
<div class="cell_title">Publisher</div>
<div class="cell_value"><%= book.publisher%></div>
</div>
<div class="genre_wrapper">
<div class="cell_title">Genres</div>
<div class="cell_value"><%= book.genres %></div>
</div>
</div>
<div class="synopsis_wrapper">
<div class="cell_title">Synopsis</div>
<div class="cell_value">
<%= book.synopsis %>
</div>
</div>
<div class="button_wrapper">
<a class="button button_1" href="<%= book.sample%>" target="_blank">FREE SAMPLE</a>
<a class="button button_2" href="payment_confirmation.jsp?id=<%= book.id%>">BUY NOW</a>
</div>
</div>
<div class="manga_series item_list" id="list_series">
<div class="list_title">Series</div>
<div class="item_container col5_eq">
<% for(int i=0; i < series.size(); i++){ %>
<a class="item" href='<%= seriesUrl+"id="+ series.get(i).id %>'>
<div class="thumbnail" style="background-image:url(<%= series.get(i).thumbnail %>);"></div>
<div class="label">
<div class="item_label"><%= series.get(i).title.length() > 40? series.get(i).title.substring(0,40)+"..." : series.get(i).title %></div>
<div class="volume_label">Volume <%= series.get(i).volume %></div>
</div>
</a>
<%}%>
<%
query = "SELECT COUNT(*) FROM products WHERE product_series = '" + book.series +"'";
result = statement.executeQuery(query);
int totalBook = 0;
int totalPage = 0;
if(result.next()){
totalBook = result.getInt(1);
totalPage = totalBook/perPage;
}
if(totalBook%perPage != 0)
totalPage++;
int next = (currPage) < totalPage ? (currPage+1) : currPage ;
int prev = (currPage) > 1 ? (currPage-1) : currPage;
%>
<a class="next" href='<%= seriesUrl+"id="+ book.id +"&page="+next %>' style='display: <%= (currPage==next) ? "none" : "block" %>;'><i class="fas fa-chevron-right centerize"></i></a>
<a class="prev" href='<%= seriesUrl+"id="+ book.id +"&page="+prev %>' style='display: <%= (currPage==prev) ? "none" : "block" %>;'><i class="fas fa-chevron-left centerize"></i></a>
</div>
</div>
</div>
<div class="thumbnail_container" style="background-image:url(<%= book.thumbnail %>);"></div>
</div>
<% } %>