Mercurial > hg > LGToc
annotate check_sections_details.php @ 6:4d59439c8b46
New: get user name from LGService by sessionId
author | Zoe Hong <zhong@mpiwg-berlin.mpg.de> |
---|---|
date | Tue, 21 Apr 2015 15:00:19 +0200 |
parents | 26ed9d1d6957 |
children | 3abf39f0eb46 |
rev | line source |
---|---|
0 | 1 <?php |
4
373c8ecad8b4
deploy to development server
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
0
diff
changeset
|
2 include_once('config/Lib_mb_utf8.php'); |
373c8ecad8b4
deploy to development server
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
0
diff
changeset
|
3 include_once('config/config.php'); |
0 | 4 include_once('edit_section_db.php'); |
5 set_time_limit(0); | |
6 ini_set('memory_limit', '-1'); | |
7 | |
8 $link_mysql = mysql_connect($mysql_server, $mysql_user, $mysql_password); | |
9 mysql_query("SET NAMES utf8"); | |
10 | |
11 if (!$link_mysql) { | |
12 die('Could not connect: ' . mysql_error()); | |
13 } | |
14 | |
15 $db_selected = mysql_select_db($mysql_database, $link_mysql); | |
16 if (!$db_selected) { | |
17 die ('Can\'t use foo : ' . mysql_error()); | |
18 } | |
19 function getBookInfo($bookId){ | |
20 $query="SELECT * FROM books WHERE id=".$bookId; | |
21 $result=mysql_query($query); | |
22 $bookInfo=mysql_fetch_assoc($result); | |
23 return $bookInfo; | |
24 } | |
25 function printBookInfo($bookInfo){ | |
26 $str="<table>"; | |
27 $str.="<tr><td class='bookId'>book id | |
28 <td class='bookName'>book name | |
29 <td class='level1'>level1 | |
30 <td class='level2'>level2 | |
31 <td class='period'>period | |
32 <td class='bookId'>pages | |
33 <td class='bookId'>version | |
34 <td class='bookName'>editor | |
35 <td class='bookName'>date"; | |
36 $str.="<tr>"; | |
37 $str.="<td>".$bookInfo['id']; | |
38 $str.="<td>".$bookInfo['name']; | |
39 $str.="<td>".$bookInfo['level1']; | |
40 $str.="<td>".$bookInfo['level2']; | |
41 $str.="<td>".$bookInfo['period']; | |
42 $str.="<td>".$bookInfo['line']; | |
43 $str.="<td>".$bookInfo['version']; | |
44 $str.="<td>".$bookInfo['editor']; | |
45 $str.="<td>".$bookInfo['date']; | |
46 $str.="</table>"; | |
47 echo $str; | |
48 } | |
49 function printSectionArray($sectionArray,$missingPageArray){ | |
50 $str="<div id='bookContainer'>"; | |
51 echo $str; | |
52 $i=0; | |
53 foreach($sectionArray as $idx=>$row){ | |
54 /* | |
55 $flag=""; | |
56 if($i!=sizeof($pageArray) && $pageArray[$i]['start_page']==$row['start_page'] && $pageArray[$i]['end_page']==$row['end_page']){ | |
57 $flag="overlapper"; | |
58 $i++; | |
59 } | |
60 if($i!=0 && $pageArray[$i-1]['start_page']==$row['start_page'] && $pageArray[$i-1]['end_page']==$row['end_page']){ | |
61 $flag="overlapper"; | |
62 }*/ | |
63 if(!($idx!=0 && $sectionArray[$idx-1]['start_page']==$row['start_page'] && $sectionArray[$idx-1]['end_page']==$row['end_page']) | |
64 && $i<sizeof($missingPageArray) && $missingPageArray[$i]['end_page']==$row['start_page']){ | |
65 $str="<div class='missingPageContainer'><div class='missingPage'>Missing pages: ".$missingPageArray[$i]['start_page']." - ".$missingPageArray[$i]['end_page']."</div></div>"; | |
66 //$str.="<br>"; | |
67 $i++; | |
68 echo $str; | |
69 } | |
70 | |
71 $str="<div class='entry level".$row['level']." ".$row['flag']." ".$row['deleted']."'>"; | |
72 $str.="<div class='hiddenInfo'>"; | |
73 $str.="<div class='id'>".$row['id']."</div>"; | |
74 $str.="<div class='booksId'>".sprintf("%05d",$row['books_id'])."</div>"; | |
75 $str.="<div class='splitFrom'>".$row['split_from']."</div>"; | |
76 $str.="<div class='sectionAfter'>".$row['section_after']."</div>"; | |
77 $str.="</div>";//end of hiddenInfo | |
78 $str.="<div class='sequence'>".($idx+1)."</div>"; | |
79 $str.="<div class='name'>".$row['name']."</div>"; | |
80 $str.="<div class='page'>"; | |
81 $str.="<div class='startPage'>".$row['start_page']."</div>"; | |
82 $str.=" - "; | |
83 $str.="<div class='endPage'>".$row['end_page']."</div>"; | |
84 $str.="</div>";//end of page | |
85 $str.="</div>"; //end of class entry | |
86 echo $str; | |
87 | |
88 } | |
89 if($i<sizeof($missingPageArray)){ | |
90 $str="<div class='missingPage'>Missing pages: ".$missingPageArray[$i]['start_page']." - ".$missingPageArray[$i]['end_page']."</div>"; | |
91 echo $str; | |
92 } | |
93 $str="</div>"; | |
94 echo $str; | |
95 } | |
96 | |
5
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
97 if (isset($_GET['sessionId'])) { |
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
98 // check if get session info from LGService, to get username as editor |
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
99 $session_id = $_GET['sessionId']; |
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
100 $lg_url = "http://localgazetteers-dev/LGServices/rest/utils/getUser?sessionId=".$session_id; // url to get username from LGService |
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
101 $output = file_get_contents($lg_url); |
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
102 $user_info = json_decode($output, true); |
6
4d59439c8b46
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
5
diff
changeset
|
103 $current_editor = (string)$user_info['userName']; |
5
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
104 |
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
105 } else { |
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
106 // test locally |
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
107 } |
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
108 |
0 | 109 ?> |
110 | |
111 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> | |
112 <html> | |
5
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
113 <head> |
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
114 <meta http-equiv="Content-Type" content="text/html; charset=utf-8"/> |
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
115 <link href="https://code.jquery.com/ui/1.10.4/themes/smoothness/jquery-ui.css" type="text/css" rel="stylesheet"/> |
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
116 <link href="css/check_sections.css" type="text/css" rel="stylesheet"/> |
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
117 <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.6.2/jquery.min.js" type="text/javascript"></script> |
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
118 <script src="js/check_sections_details.js" type="text/javascript"></script> |
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
119 <script src="https://code.jquery.com/ui/1.10.4/jquery-ui.js" type="text/javascript"></script> |
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
120 <!--<script src="js/check_sections.js" charset="utf-8"></script>!--> |
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
121 </head> |
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
122 <body> |
0 | 123 <div id="loading">...</div> |
124 <div id="container"> | |
5
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
125 <?php |
0 | 126 $version=0; |
127 $editor=""; | |
128 $date=""; | |
5
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
129 if(isset($_GET['book_id']) && isset($_GET['count']) && is_numeric($_GET['count'])){ |
0 | 130 $bookId=$_GET['book_id']; |
131 $count=$_GET['count']; | |
132 $bookInfo=getBookInfo($bookId); | |
133 $info=checkSectionInfo($bookId); | |
134 $version=$info['version']; | |
135 $editor=$info['editor']; | |
136 $date=$info['date']; | |
137 $bookInfo=array_merge($bookInfo,["version"=>$version,"editor"=>$editor,"date"=>$date]); | |
138 printBookInfo($bookInfo); | |
139 //echo "version: ".$version."<br>last editor: ".$editor; | |
140 $missingPageArray=checkMissingPage($bookInfo,$info); | |
5
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
141 ?> |
0 | 142 |
5
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
143 <table> |
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
144 <thead>Show editing records: |
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
145 <button id="show_all">Show all</button> |
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
146 <button id="close">Close</button> |
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
147 </thead> |
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
148 <tbody> |
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
149 <tr> |
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
150 <td id="editor_th"></td> |
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
151 <td id="date_th"></td> |
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
152 </tr> |
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
153 <tr> |
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
154 <td><div id="editor"></div></td> |
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
155 <td><div id="date"></div></td> |
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
156 </tr> |
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
157 </tbody> |
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
158 </table> |
0 | 159 |
5
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
160 <div id="searchResults"> |
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
161 <?php |
0 | 162 $sectionArray=getSectionArray($bookId,$count,$info); |
163 printSectionArray($sectionArray,$missingPageArray); | |
5
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
164 }else{ |
0 | 165 echo "Cannot process the data due to incomplete input."; |
166 } | |
5
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
167 ?> |
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
168 </div> |
0 | 169 </div> |
170 <div id="panel"></div> | |
171 <script>var version=<?php echo $version;?>;</script> | |
172 | |
173 <script type="text/javascript"> | |
5
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
174 function setCurrentEditor() { |
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
175 // current_editor is gotten from LGService |
6
4d59439c8b46
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
5
diff
changeset
|
176 var current_editor = <?php echo json_encode($current_editor) ?>; |
5
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
177 if (current_editor != "") { |
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
178 $("#saveBook .editor").val(current_editor); |
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
179 } |
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
180 } |
0 | 181 |
182 document.getElementById("show_all").onclick = function(){showAll()}; | |
183 | |
184 function showAll() { | |
185 document.getElementById("editor_th").innerHTML = "Editor(version)"; | |
186 document.getElementById("date_th").innerHTML = "Date/Time"; | |
187 | |
188 <?php | |
189 $editors = ""; | |
190 $editing_time = ""; | |
191 | |
192 $query_editor = "(SELECT editor, date, version from sections_versions WHERE books_id='".$bookId."' ORDER BY version DESC)"; | |
193 $result = mysql_query($query_editor); | |
194 | |
195 while ($row = mysql_fetch_assoc($result)) { | |
196 $editor = $row['editor']; | |
197 $edit_time = $row['date']; | |
198 $version = $row['version']; | |
199 ?> | |
200 document.getElementById("editor").innerHTML += '<?php echo $editor; ?>' +'('+'<?php echo $version;?>' +')<br>'; | |
201 document.getElementById("date").innerHTML += '<?php echo $edit_time; ?>' + '<br>'; | |
202 <?php | |
203 | |
204 } | |
205 ?> | |
206 | |
207 } | |
208 | |
209 document.getElementById("close").onclick = function(){closeAll()}; | |
210 | |
211 function closeAll() { | |
212 document.getElementById("editor_th").innerHTML = ""; | |
213 document.getElementById("date_th").innerHTML = ""; | |
214 document.getElementById("editor").innerHTML = ""; | |
215 document.getElementById("date").innerHTML = ""; | |
216 } | |
5
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
217 |
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
218 |
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
219 |
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
220 </script> |
0 | 221 |
222 | |
5
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
223 </body> |
0 | 224 |
225 </html> | |
226 |