Mercurial > hg > LGToc
annotate check_sections_details.php @ 17:2e6bf16b0be3
Commit from test site
| author | Calvin Yeh <cyeh@mpipw-berlin.mpg.com> |
|---|---|
| date | Tue, 21 Mar 2017 18:05:52 +0100 |
| parents | 6ea0f9030f72 |
| children | a15320882b30 |
| 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']; |
|
7
3abf39f0eb46
bug fixed: sessionId from LGServices
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
6
diff
changeset
|
100 |
|
3abf39f0eb46
bug fixed: sessionId from LGServices
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
6
diff
changeset
|
101 global $lgserver_url; |
|
3abf39f0eb46
bug fixed: sessionId from LGServices
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
6
diff
changeset
|
102 $lg_url = $lgserver_url."rest/utils/getUser?sessionId=".$session_id; // url to get username from LGService |
|
3abf39f0eb46
bug fixed: sessionId from LGServices
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
6
diff
changeset
|
103 //$lg_url = "http://localgazetteers-dev/LGServices/rest/utils/getUser?sessionId=".$session_id; // url to get username from LGService |
|
5
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
104 $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
|
105 $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
|
106 $current_editor = (string)$user_info['userName']; |
|
17
2e6bf16b0be3
Commit from test site
Calvin Yeh <cyeh@mpipw-berlin.mpg.com>
parents:
14
diff
changeset
|
107 |
| 13 | 108 if ($current_editor == null || $current_editor == "" || strcmp($current_editor, "") === 0 || strcmp($user_info['status'], "ok") !== 0) { |
|
8
7258ccd8ef7d
new: user need to login in LGServices
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
7
diff
changeset
|
109 // redirect to LGServices homepage |
|
11
0a03c75499e6
bug fixed: sessionId after saving
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
10
diff
changeset
|
110 header("Location: "+$lgserver_url+"LGServices"); |
|
17
2e6bf16b0be3
Commit from test site
Calvin Yeh <cyeh@mpipw-berlin.mpg.com>
parents:
14
diff
changeset
|
111 //header('Location: http://localgazetteers/LGServices'); |
|
8
7258ccd8ef7d
new: user need to login in LGServices
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
7
diff
changeset
|
112 } |
|
5
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
113 |
|
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
114 } else { |
|
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
115 // test locally |
|
8
7258ccd8ef7d
new: user need to login in LGServices
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
7
diff
changeset
|
116 // redirect to LGServices homepage |
|
11
0a03c75499e6
bug fixed: sessionId after saving
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
10
diff
changeset
|
117 header("Location: "+$lgserver_url+"LGServices"); |
|
5
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
118 } |
|
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
119 |
|
12
7e04cbe8b2a0
add required libraries to server
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
11
diff
changeset
|
120 |
| 0 | 121 ?> |
| 122 | |
| 123 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> | |
| 124 <html> | |
|
5
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
125 <head> |
|
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
126 <meta http-equiv="Content-Type" content="text/html; charset=utf-8"/> |
|
12
7e04cbe8b2a0
add required libraries to server
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
11
diff
changeset
|
127 |
|
7e04cbe8b2a0
add required libraries to server
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
11
diff
changeset
|
128 <link href="css/jquery-ui/jquery-ui.css" type="text/css" rel="stylesheet"/> |
|
7e04cbe8b2a0
add required libraries to server
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
11
diff
changeset
|
129 <script src="js/jquery/1.6.2/jquery.min.js" type="text/javascript"></script> |
|
7e04cbe8b2a0
add required libraries to server
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
11
diff
changeset
|
130 <script src="js/jquery/jquery-ui.js" type="text/javascript"></script> |
|
7e04cbe8b2a0
add required libraries to server
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
11
diff
changeset
|
131 |
|
5
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
132 <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
|
133 <script src="js/check_sections_details.js" type="text/javascript"></script> |
|
12
7e04cbe8b2a0
add required libraries to server
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
11
diff
changeset
|
134 |
|
7e04cbe8b2a0
add required libraries to server
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
11
diff
changeset
|
135 <!-- |
|
7e04cbe8b2a0
add required libraries to server
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
11
diff
changeset
|
136 <link href="https://code.jquery.com/ui/1.10.4/themes/smoothness/jquery-ui.css" type="text/css" rel="stylesheet"/> |
|
7e04cbe8b2a0
add required libraries to server
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
11
diff
changeset
|
137 <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.6.2/jquery.min.js" type="text/javascript"></script> |
|
5
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
138 <script src="https://code.jquery.com/ui/1.10.4/jquery-ui.js" type="text/javascript"></script> |
|
12
7e04cbe8b2a0
add required libraries to server
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
11
diff
changeset
|
139 --> |
|
5
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
140 <!--<script src="js/check_sections.js" charset="utf-8"></script>!--> |
|
12
7e04cbe8b2a0
add required libraries to server
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
11
diff
changeset
|
141 |
|
5
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
142 </head> |
|
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
143 <body> |
| 0 | 144 <div id="loading">...</div> |
| 145 <div id="container"> | |
|
5
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
146 <?php |
| 0 | 147 $version=0; |
| 148 $editor=""; | |
| 149 $date=""; | |
|
5
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
150 if(isset($_GET['book_id']) && isset($_GET['count']) && is_numeric($_GET['count'])){ |
| 0 | 151 $bookId=$_GET['book_id']; |
| 152 $count=$_GET['count']; | |
| 153 $bookInfo=getBookInfo($bookId); | |
| 154 $info=checkSectionInfo($bookId); | |
| 155 $version=$info['version']; | |
| 156 $editor=$info['editor']; | |
| 157 $date=$info['date']; | |
| 158 $bookInfo=array_merge($bookInfo,["version"=>$version,"editor"=>$editor,"date"=>$date]); | |
| 159 printBookInfo($bookInfo); | |
| 160 //echo "version: ".$version."<br>last editor: ".$editor; | |
| 161 $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
|
162 ?> |
| 0 | 163 |
|
5
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
164 <table> |
|
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
165 <thead>Show editing records: |
|
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
166 <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
|
167 <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
|
168 </thead> |
|
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
169 <tbody> |
|
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
170 <tr> |
|
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
171 <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
|
172 <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
|
173 </tr> |
|
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
174 <tr> |
|
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
175 <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
|
176 <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
|
177 </tr> |
|
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
178 </tbody> |
|
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
179 </table> |
| 0 | 180 |
|
5
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
181 <div id="searchResults"> |
|
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
182 <?php |
| 0 | 183 $sectionArray=getSectionArray($bookId,$count,$info); |
| 184 printSectionArray($sectionArray,$missingPageArray); | |
|
5
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
185 }else{ |
| 0 | 186 echo "Cannot process the data due to incomplete input."; |
| 187 } | |
|
5
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
188 ?> |
|
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
189 </div> |
| 0 | 190 </div> |
| 191 <div id="panel"></div> | |
| 13 | 192 <script> |
|
17
2e6bf16b0be3
Commit from test site
Calvin Yeh <cyeh@mpipw-berlin.mpg.com>
parents:
14
diff
changeset
|
193 var version=<?php echo $version;?>; |
|
2e6bf16b0be3
Commit from test site
Calvin Yeh <cyeh@mpipw-berlin.mpg.com>
parents:
14
diff
changeset
|
194 var session_id = "<?php echo $_GET['sessionId'];?>"; |
|
10
2c35af0d78f3
bug fixed: sessionId after saving
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
8
diff
changeset
|
195 </script> |
| 0 | 196 |
| 197 <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
|
198 function setCurrentEditor() { |
|
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
199 // 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
|
200 var current_editor = <?php echo json_encode($current_editor) ?>; |
|
17
2e6bf16b0be3
Commit from test site
Calvin Yeh <cyeh@mpipw-berlin.mpg.com>
parents:
14
diff
changeset
|
201 if (current_editor != "") { |
|
5
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
202 $("#saveBook .editor").val(current_editor); |
|
8
7258ccd8ef7d
new: user need to login in LGServices
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
7
diff
changeset
|
203 } else { |
| 13 | 204 alert("Error!! You have to login from LGService!"); |
|
17
2e6bf16b0be3
Commit from test site
Calvin Yeh <cyeh@mpipw-berlin.mpg.com>
parents:
14
diff
changeset
|
205 $("#loading").show(); |
|
5
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
206 } |
|
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
207 } |
| 0 | 208 |
| 209 document.getElementById("show_all").onclick = function(){showAll()}; | |
| 210 | |
| 211 function showAll() { | |
|
10
2c35af0d78f3
bug fixed: sessionId after saving
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
8
diff
changeset
|
212 closeAll(); |
| 0 | 213 document.getElementById("editor_th").innerHTML = "Editor(version)"; |
| 214 document.getElementById("date_th").innerHTML = "Date/Time"; | |
| 215 | |
| 216 <?php | |
| 217 $editors = ""; | |
| 218 $editing_time = ""; | |
| 219 | |
| 220 $query_editor = "(SELECT editor, date, version from sections_versions WHERE books_id='".$bookId."' ORDER BY version DESC)"; | |
| 221 $result = mysql_query($query_editor); | |
| 222 | |
| 223 while ($row = mysql_fetch_assoc($result)) { | |
| 224 $editor = $row['editor']; | |
| 225 $edit_time = $row['date']; | |
| 226 $version = $row['version']; | |
| 227 ?> | |
| 228 document.getElementById("editor").innerHTML += '<?php echo $editor; ?>' +'('+'<?php echo $version;?>' +')<br>'; | |
| 229 document.getElementById("date").innerHTML += '<?php echo $edit_time; ?>' + '<br>'; | |
| 230 <?php | |
| 231 | |
| 232 } | |
| 233 ?> | |
| 234 | |
| 235 } | |
| 236 | |
| 237 document.getElementById("close").onclick = function(){closeAll()}; | |
| 238 | |
| 239 function closeAll() { | |
| 240 document.getElementById("editor_th").innerHTML = ""; | |
| 241 document.getElementById("date_th").innerHTML = ""; | |
| 242 document.getElementById("editor").innerHTML = ""; | |
| 243 document.getElementById("date").innerHTML = ""; | |
| 244 } | |
|
5
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
245 |
|
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
246 |
|
12
7e04cbe8b2a0
add required libraries to server
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
11
diff
changeset
|
247 // --- timeout reminder --- |
|
7e04cbe8b2a0
add required libraries to server
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
11
diff
changeset
|
248 var timeoutID; |
|
7e04cbe8b2a0
add required libraries to server
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
11
diff
changeset
|
249 delayedAlert(); |
|
7e04cbe8b2a0
add required libraries to server
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
11
diff
changeset
|
250 function delayedAlert() { |
|
17
2e6bf16b0be3
Commit from test site
Calvin Yeh <cyeh@mpipw-berlin.mpg.com>
parents:
14
diff
changeset
|
251 timeoutID = window.setTimeout(slowAlert, 3600*1000); |
|
12
7e04cbe8b2a0
add required libraries to server
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
11
diff
changeset
|
252 } |
|
7e04cbe8b2a0
add required libraries to server
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
11
diff
changeset
|
253 function slowAlert() { |
|
17
2e6bf16b0be3
Commit from test site
Calvin Yeh <cyeh@mpipw-berlin.mpg.com>
parents:
14
diff
changeset
|
254 if (confirm("Reminder: It's been 1 hour. Remember saving your work to prevent data lost. \n\nKeep working? \n(Press Cancel will turn off this reminder.)")) { |
|
12
7e04cbe8b2a0
add required libraries to server
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
11
diff
changeset
|
255 |
|
7e04cbe8b2a0
add required libraries to server
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
11
diff
changeset
|
256 var lg_url = "<?php echo $lgserver_url?>" + "rest/utils/getUser?sessionId=" + session_id; |
|
7e04cbe8b2a0
add required libraries to server
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
11
diff
changeset
|
257 |
|
7e04cbe8b2a0
add required libraries to server
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
11
diff
changeset
|
258 $.post(lg_url, function(data) { |
| 13 | 259 console.log("renew session."); |
| 14 | 260 |
| 261 }).done(function(data){ | |
| 262 console.log(data); | |
| 263 console.log("login as: " + data['userName']); | |
| 264 | |
| 265 if (data['userName'] == "") { | |
| 266 alert("Error!! You have to login from LGService!"); | |
| 267 $("#loading").show(); | |
| 268 } else { | |
| 269 timeoutID = window.setTimeout(slowAlert, 3600*1000); | |
| 270 } | |
| 271 | |
| 272 }).fail(function(){ | |
| 273 console.log("fail to renew session."); | |
|
12
7e04cbe8b2a0
add required libraries to server
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
11
diff
changeset
|
274 }); |
|
7e04cbe8b2a0
add required libraries to server
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
11
diff
changeset
|
275 } |
|
17
2e6bf16b0be3
Commit from test site
Calvin Yeh <cyeh@mpipw-berlin.mpg.com>
parents:
14
diff
changeset
|
276 |
|
12
7e04cbe8b2a0
add required libraries to server
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
11
diff
changeset
|
277 } |
|
7e04cbe8b2a0
add required libraries to server
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
11
diff
changeset
|
278 |
|
7e04cbe8b2a0
add required libraries to server
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
11
diff
changeset
|
279 |
|
7e04cbe8b2a0
add required libraries to server
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
11
diff
changeset
|
280 |
|
5
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
281 </script> |
| 0 | 282 |
| 283 | |
|
5
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
284 </body> |
| 0 | 285 |
| 286 </html> | |
| 287 |