Mercurial > hg > extraction-interface

annotate views/Extractapp/ExportTable.php @ 122:a36bb5a48af4 extractapp tip

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
1. remove redundancy server side code. 2. All pop up sub-windows are made with dialog component of bootstrap v3.3.2
author Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
date Thu, 28 Sep 2017 22:26:48 +0200
parents e6b516fa7b60
children
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
47
886f43b26ee2 move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
1 <?php
81
f1f849d31272 book_id as string
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 78
diff changeset
2 /*
f1f849d31272 book_id as string
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 78
diff changeset
3 * ExportTable.php
f1f849d31272 book_id as string
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 78
diff changeset
4 * This file is part of Extraction-interface.
f1f849d31272 book_id as string
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 78
diff changeset
5 *
f1f849d31272 book_id as string
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 78
diff changeset
6 * Extraction-interface is free software: you can redistribute it and/or modify
f1f849d31272 book_id as string
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 78
diff changeset
7 * it under the terms of the GNU General Public License as published by
f1f849d31272 book_id as string
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 78
diff changeset
8 * the Free Software Foundation, either version 3 of the License, or
f1f849d31272 book_id as string
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 78
diff changeset
9 * (at your option) any later version.
f1f849d31272 book_id as string
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 78
diff changeset
10 *
f1f849d31272 book_id as string
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 78
diff changeset
11 * Extraction-interface is distributed in the hope that it will be useful,
f1f849d31272 book_id as string
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 78
diff changeset
12 * but WITHOUT ANY WARRANTY; without even the implied warranty of
f1f849d31272 book_id as string
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 78
diff changeset
13 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
f1f849d31272 book_id as string
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 78
diff changeset
14 * GNU General Public License for more details.
f1f849d31272 book_id as string
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 78
diff changeset
15 *
f1f849d31272 book_id as string
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 78
diff changeset
16 * You should have received a copy of the GNU General Public License
f1f849d31272 book_id as string
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 78
diff changeset
17 * along with Extraction-interface. If not, see <http://www.gnu.org/licenses/>.
f1f849d31272 book_id as string
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 78
diff changeset
18 */
117
e6b516fa7b60 1. add new columns : book year and edition year.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents: 94
diff changeset
19 /*! \file
78
960ba96efce1 Update: click to popup remove-tag-window; select to popup tag-window
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 77
diff changeset
20 * This is the view for ExportTable.
117
e6b516fa7b60 1. add new columns : book year and edition year.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents: 94
diff changeset
21 * It shows a html table with each row as a topic object and each column as a tag/attribute.
77
97c1e5102a22 New: export table for a file from LGService
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 47
diff changeset
22 */
97c1e5102a22 New: export table for a file from LGService
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 47
diff changeset
23
47
886f43b26ee2 move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
24 // --- initialize ---
886f43b26ee2 move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
25 $outputTableArray = $viewmodel['outputTableArray'];
886f43b26ee2 move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
26 $bookId = $viewmodel['bookId'];
886f43b26ee2 move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
27 $sectionid = $viewmodel['section_id'];
886f43b26ee2 move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
28 $bookName = $viewmodel['bookName'];
886f43b26ee2 move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
29 $sectionName = $viewmodel['sectionName'];
91
3e11a9c5a672 new: explore table for using on LGMap
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 81
diff changeset
30 $bookMeta = $viewmodel['bookMeta'];
47
886f43b26ee2 move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
31
886f43b26ee2 move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
32 ?>
886f43b26ee2 move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
33
886f43b26ee2 move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
34 <html>
886f43b26ee2 move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
35 <head>
886f43b26ee2 move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
36 <title></title>
117
e6b516fa7b60 1. add new columns : book year and edition year.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents: 94
diff changeset
37 <?php include 'views/maintemplate.php'; ?>
e6b516fa7b60 1. add new columns : book year and edition year.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents: 94
diff changeset
38 <style>
47
886f43b26ee2 move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
39
117
e6b516fa7b60 1. add new columns : book year and edition year.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents: 94
diff changeset
40 td {
e6b516fa7b60 1. add new columns : book year and edition year.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents: 94
diff changeset
41 padding: 0px 5px;
e6b516fa7b60 1. add new columns : book year and edition year.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents: 94
diff changeset
42 white-space: nowrap;
e6b516fa7b60 1. add new columns : book year and edition year.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents: 94
diff changeset
43 }
e6b516fa7b60 1. add new columns : book year and edition year.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents: 94
diff changeset
44 </style>
47
886f43b26ee2 move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
45 </head>
886f43b26ee2 move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
46
886f43b26ee2 move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
47 <body>
886f43b26ee2 move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
48 <table width="100%" border="1" id="tableMain">
117
e6b516fa7b60 1. add new columns : book year and edition year.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents: 94
diff changeset
49
47
886f43b26ee2 move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
50 <?php
886f43b26ee2 move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
51 $count=1;
886f43b26ee2 move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
52 foreach ( $outputTableArray as $trIndex =>$trValue ) {
886f43b26ee2 move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
53 echo "<tr>";
886f43b26ee2 move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
54 if ( $trIndex==0 ) {
117
e6b516fa7b60 1. add new columns : book year and edition year.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents: 94
diff changeset
55 echo "<td align='center'>#</td>";
47
886f43b26ee2 move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
56 echo "<td>Book ID</td>";
886f43b26ee2 move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
57 echo "<td>Section ID</td>";
886f43b26ee2 move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
58 echo "<td>方志</td>";
886f43b26ee2 move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
59 echo "<td>部</td>";
117
e6b516fa7b60 1. add new columns : book year and edition year.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents: 94
diff changeset
60 echo "<td>Book Year</td>";
e6b516fa7b60 1. add new columns : book year and edition year.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents: 94
diff changeset
61 echo "<td>Edition Year</td>";
91
3e11a9c5a672 new: explore table for using on LGMap
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 81
diff changeset
62 echo "<td>方志地點</td>";
3e11a9c5a672 new: explore table for using on LGMap
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 81
diff changeset
63 echo "<td>經度(x)</td>"; // longitude
3e11a9c5a672 new: explore table for using on LGMap
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 81
diff changeset
64 echo "<td>緯度(y)</td>"; // latitude
94
b0cecc104639 new: modified tags can work on tagged text
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 91
diff changeset
65 echo "<td>Description</td>"; // description
117
e6b516fa7b60 1. add new columns : book year and edition year.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents: 94
diff changeset
66
47
886f43b26ee2 move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
67 } else {
117
e6b516fa7b60 1. add new columns : book year and edition year.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents: 94
diff changeset
68 echo "<td align='center'>".$count++."</td>";
47
886f43b26ee2 move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
69 echo "<td>".$bookId."</td>";
886f43b26ee2 move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
70 echo "<td>".$sectionid."</td>";
886f43b26ee2 move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
71 echo "<td>".$bookName."</td>";
886f43b26ee2 move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
72 echo "<td>".$sectionName."</td>";
117
e6b516fa7b60 1. add new columns : book year and edition year.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents: 94
diff changeset
73 echo "<td>".$bookMeta->book_year."</td>";
e6b516fa7b60 1. add new columns : book year and edition year.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents: 94
diff changeset
74 echo "<td>".$bookMeta->edition_year."</td>";
e6b516fa7b60 1. add new columns : book year and edition year.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents: 94
diff changeset
75 echo "<td>".$sectionName."</td>";
91
3e11a9c5a672 new: explore table for using on LGMap
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 81
diff changeset
76 echo "<td>".$bookMeta->place_name."</td>";
3e11a9c5a672 new: explore table for using on LGMap
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 81
diff changeset
77 echo "<td>".$bookMeta->x."</td>";
3e11a9c5a672 new: explore table for using on LGMap
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 81
diff changeset
78 echo "<td>".$bookMeta->y."</td>";
94
b0cecc104639 new: modified tags can work on tagged text
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 91
diff changeset
79 echo "<td>".$bookName."_".$sectionName."</td>"; // description for LGMap
117
e6b516fa7b60 1. add new columns : book year and edition year.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents: 94
diff changeset
80
47
886f43b26ee2 move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
81 }
886f43b26ee2 move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
82 if ( isset( $trValue["page"] ) ) {
117
e6b516fa7b60 1. add new columns : book year and edition year.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents: 94
diff changeset
83 echo "<td >".$trValue["page"]."</td>";
47
886f43b26ee2 move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
84 } else {
886f43b26ee2 move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
85 echo "<td>&nbsp;</td>";
886f43b26ee2 move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
86 }
886f43b26ee2 move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
87 /*
886f43b26ee2 move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
88 foreach ( $outputTableArray[0][1] as $index => $value ) {
886f43b26ee2 move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
89 if ( isset( $trValue[1][$index] ) ) {
886f43b26ee2 move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
90 echo "<td>".$trValue[1][$index]."</td>";
886f43b26ee2 move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
91 } else {
886f43b26ee2 move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
92 echo "<td>&nbsp;</td>";
886f43b26ee2 move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
93 }
886f43b26ee2 move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
94 }
886f43b26ee2 move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
95 */
886f43b26ee2 move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
96 foreach ( $outputTableArray[0][0] as $index => $value ) {
117
e6b516fa7b60 1. add new columns : book year and edition year.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents: 94
diff changeset
97 //if ( $index == "time" ) {
e6b516fa7b60 1. add new columns : book year and edition year.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents: 94
diff changeset
98 //if ( isset( $trValue[0][$index] ) ) {
e6b516fa7b60 1. add new columns : book year and edition year.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents: 94
diff changeset
99 // echo "<td>".$trValue[0][$index]."</td>";
e6b516fa7b60 1. add new columns : book year and edition year.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents: 94
diff changeset
100 // echo "<td>".$trValue[0][$index]."</td>";
e6b516fa7b60 1. add new columns : book year and edition year.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents: 94
diff changeset
101 //} else {
e6b516fa7b60 1. add new columns : book year and edition year.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents: 94
diff changeset
102 // echo "<td>&nbsp;</td>";
e6b516fa7b60 1. add new columns : book year and edition year.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents: 94
diff changeset
103 // echo "<td>&nbsp;</td>";
e6b516fa7b60 1. add new columns : book year and edition year.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents: 94
diff changeset
104 //}
e6b516fa7b60 1. add new columns : book year and edition year.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents: 94
diff changeset
105 //} else {
47
886f43b26ee2 move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
106 if ( isset( $trValue[0][$index] ) ) {
117
e6b516fa7b60 1. add new columns : book year and edition year.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents: 94
diff changeset
107 echo "<td >".$trValue[0][$index]."</td>";
47
886f43b26ee2 move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
108 } else {
886f43b26ee2 move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
109 echo "<td>&nbsp;</td>";
886f43b26ee2 move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
110 }
117
e6b516fa7b60 1. add new columns : book year and edition year.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents: 94
diff changeset
111 //}
47
886f43b26ee2 move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
112 }
94
b0cecc104639 new: modified tags can work on tagged text
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 91
diff changeset
113
117
e6b516fa7b60 1. add new columns : book year and edition year.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents: 94
diff changeset
114 /* remove other, full columns
47
886f43b26ee2 move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
115 if ( isset( $trValue["other"] ) ) {
886f43b26ee2 move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
116 echo "<td>".$trValue["other"]."</td>";
886f43b26ee2 move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
117 } else {
886f43b26ee2 move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
118 echo "<td>&nbsp;</td>";
886f43b26ee2 move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
119 }
886f43b26ee2 move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
120 if ( isset( $trValue["full"] ) ) {
886f43b26ee2 move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
121 echo "<td>".$trValue["full"]."</td>";
886f43b26ee2 move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
122 } else {
886f43b26ee2 move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
123 echo "<td>&nbsp;</td>";
886f43b26ee2 move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
124 }
117
e6b516fa7b60 1. add new columns : book year and edition year.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents: 94
diff changeset
125 */
e6b516fa7b60 1. add new columns : book year and edition year.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents: 94
diff changeset
126
94
b0cecc104639 new: modified tags can work on tagged text
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 91
diff changeset
127
47
886f43b26ee2 move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
128 echo "</tr>";
886f43b26ee2 move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
129 }
886f43b26ee2 move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
130 ?>
886f43b26ee2 move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
131 </table>
886f43b26ee2 move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
132 </body>
886f43b26ee2 move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
133 </html>