view src/main/webapp/pages/books.jsp @ 95:b27a99201cbe

New feature: new full text search with MySQL ngram parser (5.7.6 above)
author Calvin Yeh <cyeh@mpipw-berlin.mpg.com>
date Mon, 03 Jul 2017 23:48:53 +0200
parents 85e27da9b18a
children 6a508b605b5f
line wrap: on
line source

<%@page import="de.mpiwg.gazetteer.bo.LGBranch"%>
<%@page import="org.apache.commons.lang.StringUtils"%>
<%@page import="de.mpiwg.gazetteer.db.DBSection"%>
<%@page import="de.mpiwg.gazetteer.db.DBBook"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>

<jsp:useBean id="sessionBean" class="de.mpiwg.web.jsp.SessionBean" scope="session" />

<html>

<head>

	<jsp:include page="../componentes/headContent.jsp"/>

<script>

	function setComment(t) {
		var notes = t.value;
		//var bookId = t.name;

		var theForm = document.forms['booksForm'];
	    var input = document.createElement('input');
	    input.type = 'hidden';
	    input.name = 'bookComment';
	    input.value = notes;
	    theForm.appendChild(input);
	}

</script>
</head>

<body>
	<jsp:include page="../componentes/template2.jsp"/>
	<div id="page">
		<form name="booksForm"
				action="<%=sessionBean.getApplicationBean().getRootServer()%>/proxy.jsp"
				method="post"
				class="contentForm">
		<input name="bean" type="hidden" value="booksBean" />

		<% if(sessionBean.getUser() == null) { %>
            <label class="subTitel">Please login or create a new account above</label>
		<% } else {
			if (sessionBean.getBooksPage().getCompleteBookList() == null){
				sessionBean.getBooksPage().loadParameters(request, response);
				sessionBean.getBooksPage().loadBooks();
			}

		%>

		<div class="subTitel">List of Books
			<input type="image"
					onclick="setAction('forceReloadBooks', 'booksForm');"
			src="<%=sessionBean.getApplicationBean().getRefreshImage()%>" width="20" height="20"/>

			<p class="label"><%= sessionBean.getBooksPage().getBookNumber() %> books in Chinese Local Gazetteers </p>
			<p class="label"><%= (StringUtils.isNotEmpty(sessionBean.getBooksPage().getFilteringMessage())) ? sessionBean.getBooksPage().getFilteringMessage() : ""%> </p>
		</div>

			<jsp:include page="../componentes/paginator.jsp">
				<jsp:param name="formName" value="booksForm"/>
			</jsp:include>

			<div class="tableDiv double-scroll">
				<table class="pageTable">
					<tr>
						<td>
							<table class="sortTable">
								<tr>
									<td><label class="tableTitle">Book ID</label></td>
									<td>
										<table>
											<tr><td>
												<input type="image"
													onclick="setAction('sortByBookIdUp', 'booksForm');"
													src="<%=sessionBean.getApplicationBean().getUpImage()%>"/>
											</td></tr>
											<tr><td>
												<input type="image"
													onclick="setAction('sortByBookIdDown', 'booksForm');"
													src="<%=sessionBean.getApplicationBean().getDownImage()%>"/>
											</td></tr>
										</table>
									</td>
								</tr>
							</table>

						</td>
						<td>
							<table class="sortTable">
								<tr>
									<td><label class="tableTitle">Book Name</label></td>
									<td>
										<table>
											<tr><td>
												<input type="image"
													onclick="setAction('sortByBookNameUp', 'booksForm');"
													src="<%=sessionBean.getApplicationBean().getUpImage()%>"/>
											</td></tr>
											<tr><td>
												<input type="image"
													onclick="setAction('sortByBookNameDown', 'booksForm');"
													src="<%=sessionBean.getApplicationBean().getDownImage()%>"/>
											</td></tr>
										</table>
									</td>
								</tr>
								<tr>
									<td>
										<input type="text" name="bookNameFilter" value="<%= sessionBean.getBooksPage().getBookNameFilter()%>" size="10"/>
									</td>
									<td>
										<input type="image"
											onclick="setAction('filter', 'booksForm');"
											src="<%=sessionBean.getApplicationBean().getFilterImage()%>"/>
									</td>
								</tr>
							</table>
						</td>
						<td>
							<table class="sortTable">
								<tr>
									<td><label class="tableTitle">Edition</label></td>
									<td>
										<table>
											<tr><td>
												<input type="image"
													onclick="setAction('sortByEditionUp', 'booksForm');"
													src="<%=sessionBean.getApplicationBean().getUpImage()%>"/>
											</td></tr>
											<tr><td>
												<input type="image"
													onclick="setAction('sortByEditionDown', 'booksForm');"
													src="<%=sessionBean.getApplicationBean().getDownImage()%>"/>
											</td></tr>
										</table>
									</td>
								</tr>
								<tr>
									<td>
										<input type="text" name="editionFilter" value="<%= sessionBean.getBooksPage().getEditionFilter()%>" size="10"/>
									</td>
									<td>
										<input type="image"
											onclick="setAction('filter', 'booksForm');"
											src="<%=sessionBean.getApplicationBean().getFilterImage()%>"/>
									</td>
								</tr>
							</table>
						</td>
						<td>
							<table class="sortTable">
								<tr>
									<td><label class="tableTitle">Level 1</label></td>
									<td>
										<table>
											<tr><td>
												<input type="image"
													onclick="setAction('sortByLevel1Up', 'booksForm');"
													src="<%=sessionBean.getApplicationBean().getUpImage()%>"/>
											</td></tr>
											<tr><td>
												<input type="image"
													onclick="setAction('sortByLevel1Down', 'booksForm');"
													src="<%=sessionBean.getApplicationBean().getDownImage()%>"/>
											</td></tr>
										</table>
									</td>
								</tr>
								<tr>
									<td>
										<input type="text" name="level1Filter" value="<%= sessionBean.getBooksPage().getLevel1Filter()%>" size="5"/>
									</td>
									<td>
										<input type="image"
											onclick="setAction('filter', 'booksForm');"
											src="<%=sessionBean.getApplicationBean().getFilterImage()%>"/>
									</td>
								</tr>
							</table>
						</td>
						<td>
							<table class="sortTable">
								<tr>
									<td><label class="tableTitle">Level 2</label></td>
									<td>
										<table>
											<tr><td>
												<input type="image"
													onclick="setAction('sortByLevel2Up', 'booksForm');"
													src="<%=sessionBean.getApplicationBean().getUpImage()%>"/>
											</td></tr>
											<tr><td>
												<input type="image"
													onclick="setAction('sortByLevel2Down', 'booksForm');"
													src="<%=sessionBean.getApplicationBean().getDownImage()%>"/>
											</td></tr>
										</table>
									</td>
								</tr>
								<tr>
									<td>
										<input type="text" name="level2Filter" value="<%= sessionBean.getBooksPage().getLevel2Filter()%>" size="5"/>
									</td>
									<td>
										<input type="image"
											onclick="setAction('filter', 'booksForm');"
											src="<%=sessionBean.getApplicationBean().getFilterImage()%>"/>
									</td>
								</tr>
							</table>
						</td>
						<td>
							<table class="sortTable">
								<tr>
									<td><label class="tableTitle">Period</label></td>
									<td>
										<table>
											<tr><td>
												<input type="image"
													onclick="setAction('sortByPeriodUp', 'booksForm');"
													src="<%=sessionBean.getApplicationBean().getUpImage()%>"/>
											</td></tr>
											<tr><td>
												<input type="image"
													onclick="setAction('sortByPeriodDown', 'booksForm');"
													src="<%=sessionBean.getApplicationBean().getDownImage()%>"/>
											</td></tr>
										</table>
									</td>
								</tr>
								<tr>
									<td>
										<input type="text" name="periodFilter" value="<%= sessionBean.getBooksPage().getPeriodFilter()%>" size="5"/>
									</td>
									<td>
										<input type="image"
											onclick="setAction('filter', 'booksForm');"
											src="<%=sessionBean.getApplicationBean().getFilterImage()%>"/>
									</td>
								</tr>
							</table>
						</td>
						<td>
							<table class="sortTable">
								<tr>
									<td><label class="tableTitle">Dynasty</label></td>
									<td>
										<table>
											<tr><td>
												<input type="image"
													onclick="setAction('sortByDynastyUp', 'booksForm');"
													src="<%=sessionBean.getApplicationBean().getUpImage()%>"/>
											</td></tr>
											<tr><td>
												<input type="image"
													onclick="setAction('sortByDynastyDown', 'booksForm');"
													src="<%=sessionBean.getApplicationBean().getDownImage()%>"/>
											</td></tr>
										</table>
									</td>
								</tr>
								<tr>
									<td>
										<input type="text" name="dynastyFilter" value="<%= sessionBean.getBooksPage().getDynastyFilter()%>" size="5"/>
									</td>
									<td>
										<input type="image"
											onclick="setAction('filter', 'booksForm');"
											src="<%=sessionBean.getApplicationBean().getFilterImage()%>"/>
									</td>
								</tr>
							</table>
						</td>
						<td>
							<table class="sortTable">
								<tr>
									<td><label class="tableTitle">Admin Type</label></td>
									<td>
										<table>
											<tr><td>
												<input type="image"
													onclick="setAction('sortByAdminTypeUp', 'booksForm');"
													src="<%=sessionBean.getApplicationBean().getUpImage()%>"/>
											</td></tr>
											<tr><td>
												<input type="image"
													onclick="setAction('sortByAdminTypeDown', 'booksForm');"
													src="<%=sessionBean.getApplicationBean().getDownImage()%>"/>
											</td></tr>
										</table>
									</td>
								</tr>
								<tr>
									<td>
										<input type="text" name="adminTypeFilter" value="<%= sessionBean.getBooksPage().getAdminTypeFilter()%>" size="5"/>
									</td>
									<td>
										<input type="image"
											onclick="setAction('filter', 'booksForm');"
											src="<%=sessionBean.getApplicationBean().getFilterImage()%>"/>
									</td>
								</tr>
							</table>
						</td>
						<td>
							<table class="sortTable">
								<tr>
									<td><label class="tableTitle">Book Year</label></td>
									<td>
										<table>
											<tr><td>
												<input type="image"
													onclick="setAction('sortByBookYearUp', 'booksForm');"
													src="<%=sessionBean.getApplicationBean().getUpImage()%>"/>
											</td></tr>
											<tr><td>
												<input type="image"
													onclick="setAction('sortByBookYearDown', 'booksForm');"
													src="<%=sessionBean.getApplicationBean().getDownImage()%>"/>
											</td></tr>
										</table>
									</td>
								</tr>
								<tr>
									<td>
										<input type="text" name="bookYearFilter" value="<%= sessionBean.getBooksPage().getBookYearFilter()%>" size="5"/>
									</td>
									<td>
										<input type="image"
											onclick="setAction('filter', 'booksForm');"
											src="<%=sessionBean.getApplicationBean().getFilterImage()%>"/>
									</td>
								</tr>
							</table>
						</td>
						<td>
							<table class="sortTable">
								<tr>
									<td><label class="tableTitle">Edition Year</label></td>
									<td>
										<table>
											<tr><td>
												<input type="image"
													onclick="setAction('sortByEditionYearUp', 'booksForm');"
													src="<%=sessionBean.getApplicationBean().getUpImage()%>"/>
											</td></tr>
											<tr><td>
												<input type="image"
													onclick="setAction('sortByEditionYearDown', 'booksForm');"
													src="<%=sessionBean.getApplicationBean().getDownImage()%>"/>
											</td></tr>
										</table>
									</td>
								</tr>
								<tr>
									<td>
										<input type="text" name="editionYearFilter" value="<%= sessionBean.getBooksPage().getEditionYearFilter()%>" size="5"/>
									</td>
									<td>
										<input type="image"
											onclick="setAction('filter', 'booksForm');"
											src="<%=sessionBean.getApplicationBean().getFilterImage()%>"/>
									</td>
								</tr>
							</table>
						</td>
						<td>
							<table class="sortTable">
								<tr>
									<td><label class="tableTitle">Source</label></td>
									<td>
										<table>
											<tr><td>
												<input type="image"
													onclick="setAction('sortBySourceUp', 'booksForm');"
													src="<%=sessionBean.getApplicationBean().getUpImage()%>"/>
											</td></tr>
											<tr><td>
												<input type="image"
													onclick="setAction('sortBySourceDown', 'booksForm');"
													src="<%=sessionBean.getApplicationBean().getDownImage()%>"/>
											</td></tr>
										</table>
									</td>
								</tr>
								<tr>
									<td>
										<input type="text" name="sourceFilter" value="<%= sessionBean.getBooksPage().getSourceFilter()%>" size="5"/>
									</td>
									<td>
										<input type="image"
											onclick="setAction('filter', 'booksForm');"
											src="<%=sessionBean.getApplicationBean().getFilterImage()%>"/>
									</td>
								</tr>
							</table>
						</td>

						<td><label class="tableTitle">Edit TOC</label></td> <!-- go to toc page -->
						<td>
							<table class="sortTable">
								<tr>
									<td><label class="tableTitle">TOC Done

										</label>
									</td>
									<td>
										<table>
											<tr><td>
												<input type="image"
													onclick="setAction('sortByTocCorrectionUp', 'booksForm');"
													src="<%=sessionBean.getApplicationBean().getUpImage()%>"/>
											</td></tr>
											<tr><td>
												<input type="image"
													onclick="setAction('sortByTocCorrectionDown', 'booksForm');"
													src="<%=sessionBean.getApplicationBean().getDownImage()%>"/>
											</td></tr>
										</table>
									</td>
								</tr>
							</table>
						</td> <!-- finished or not -->
						<td>
							<table class="sortTable">
								<tr>
									<td><label class="tableTitle">Last Editor</label></td>
									<td>
										<table>
											<tr><td>
												<input type="image"
													onclick="setAction('sortByEditorUp', 'booksForm');"
													src="<%=sessionBean.getApplicationBean().getUpImage()%>"/>
											</td></tr>
											<tr><td>
												<input type="image"
													onclick="setAction('sortByEditorDown', 'booksForm');"
													src="<%=sessionBean.getApplicationBean().getDownImage()%>"/>
											</td></tr>
										</table>
									</td>
								</tr>
								<tr>
									<td>
										<input type="text" name="lastEditorFilter" value="<%= sessionBean.getBooksPage().getLastEditorFilter()%>" size="7"/>
									</td>
									<td>
										<input type="image"
											onclick="setAction('filter', 'booksForm');"
											src="<%=sessionBean.getApplicationBean().getFilterImage()%>"/>
									</td>
								</tr>
							</table>
						</td>
						<td>
							<table class="sortTable">
								<tr>
									<td><label class="tableTitle">Edit Time</label></td>
									<td>
										<table>
											<tr><td>
												<input type="image"
													onclick="setAction('sortByDateUp', 'booksForm');"
													src="<%=sessionBean.getApplicationBean().getUpImage()%>"/>
											</td></tr>
											<tr><td>
												<input type="image"
													onclick="setAction('sortByDateDown', 'booksForm');"
													src="<%=sessionBean.getApplicationBean().getDownImage()%>"/>
											</td></tr>
										</table>
									</td>
								</tr>
								<tr>
									<td>
										<input type="text" name="editTimeFilter" value="<%= sessionBean.getBooksPage().getEditTimeFilter()%>" size="9"/>
									</td>
									<td>
										<input type="image"
											onclick="setAction('filter', 'booksForm');"
											src="<%=sessionBean.getApplicationBean().getFilterImage()%>"/>
									</td>
								</tr>
							</table>
						</td>
						<td>
							<table class="sortTable">
								<tr>
									<td><label class="tableTitle">Comments</label></td>

								</tr>
							</table>
						</td>


					</tr>


					<% for (DBBook book : sessionBean.getBooksPage().getDisplayBookList() ) {%>

					<tr>
						<!-- books info -->
						<td><%=book.getId() %></td>
						<td><%=book.getName() %></td>
						<td><%=book.getEdition() %></td>
						<td><%=book.getLevel1()%></td>
						<td><%=book.getLevel2() %></td>
						<td><%=book.getPeriod() %></td>
						<td><%=book.getDynasty() %></td>
						<td><%=book.getAdmin_type() %></td>
						<td><%=book.getBookYear() %></td>
						<td><%=book.getEditionYear() %></td>
						<td><%=book.getSource() %></td>
						<td><a href="<%=sessionBean.getApplicationBean().getTocInterfaceUrl()%>/check_sections_details.php?book_id=<%=book.getId() %>&amp;count=10000&amp;sessionId=<%= session.getId()%>" target="blank">
						Edit TOC</a></td>

						<td>

						<% if ( book.getTocCorrection().equals("1") ) { %>
							<input type="image"	onclick="setAction0('unSetTocCorrection', 'booksForm', 'tocBookId', '<%=book.getId() %>');"
								src="<%=sessionBean.getApplicationBean().getCheckboxCheckedImage()%>" width="20" height="20"/>

						<% } else { %>
							<input type="image" onclick="setAction0('setTocCorrection', 'booksForm', 'tocBookId', '<%=book.getId() %>');"
								src="<%=sessionBean.getApplicationBean().getCheckboxUncheckedImage()%>" width="20" height="20"/>

						<% } %>

						</td>

						<td><%= (book.getCurrentSectionVersion() == null) ? "" : book.getCurrentSectionVersion().getEditor() %></td>
						<td><%= (book.getCurrentSectionVersion() == null) ? "" : book.getCurrentSectionVersion().getDate() %></td>

						<td>
							<textarea rows="2" cols="15" maxlength="100" name='<%=book.getId()%>' onchange="setComment(this)" ><%=book.getComments()%></textarea>
							<input type="image" alt="save comment"
								onclick="setAction0('saveComment', 'booksForm', 'currentBookId', '<%=book.getId()%>');"
								src="<%=sessionBean.getApplicationBean().getSaveImage()%>" width="20" height="20"/>

						</td>

					</tr>

					<% } %>
				</table>

				<jsp:include page="../componentes/paginator.jsp">
					<jsp:param name="formName" value="booksForm"/>
				</jsp:include>

			</div>


		<% } %>
		</form>
	</div>

</body>
</html>