Mercurial > hg > LGToc
annotate check_sections_details.php @ 20:ae69cfe4f9d2 default tip
new version, remove session mechanism,
after all server side save data without session in previous version, check_sections_detail.php
| author | Calvin Yeh <cyeh@mpiwg-berlin.mpg.de> |
|---|---|
| date | Mon, 25 Sep 2017 14:32:47 +0200 |
| parents | a15320882b30 |
| children |
| 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); | |
|
18
a15320882b30
modified version list area, make it more neat.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents:
17
diff
changeset
|
16 |
| 0 | 17 if (!$db_selected) { |
| 18 die ('Can\'t use foo : ' . mysql_error()); | |
| 19 } | |
|
18
a15320882b30
modified version list area, make it more neat.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents:
17
diff
changeset
|
20 |
| 0 | 21 function getBookInfo($bookId){ |
| 22 $query="SELECT * FROM books WHERE id=".$bookId; | |
| 23 $result=mysql_query($query); | |
| 24 $bookInfo=mysql_fetch_assoc($result); | |
| 25 return $bookInfo; | |
| 26 } | |
|
18
a15320882b30
modified version list area, make it more neat.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents:
17
diff
changeset
|
27 |
| 0 | 28 function printBookInfo($bookInfo){ |
|
18
a15320882b30
modified version list area, make it more neat.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents:
17
diff
changeset
|
29 |
|
a15320882b30
modified version list area, make it more neat.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents:
17
diff
changeset
|
30 $str="<table class='bookInfo'><tr> |
|
a15320882b30
modified version list area, make it more neat.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents:
17
diff
changeset
|
31 <th class='bookId'>book id</th> |
|
a15320882b30
modified version list area, make it more neat.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents:
17
diff
changeset
|
32 <th class='bookName'>book name</th> |
|
a15320882b30
modified version list area, make it more neat.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents:
17
diff
changeset
|
33 <th class='level1'>level1</th> |
|
a15320882b30
modified version list area, make it more neat.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents:
17
diff
changeset
|
34 <th class='level2'>level2</th> |
|
a15320882b30
modified version list area, make it more neat.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents:
17
diff
changeset
|
35 <th class='period'>period</th> |
|
a15320882b30
modified version list area, make it more neat.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents:
17
diff
changeset
|
36 <th class='bookId'>pages</th> |
|
a15320882b30
modified version list area, make it more neat.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents:
17
diff
changeset
|
37 <th class='bookId'>version</th> |
|
a15320882b30
modified version list area, make it more neat.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents:
17
diff
changeset
|
38 <th class='bookName'>editor</th> |
|
a15320882b30
modified version list area, make it more neat.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents:
17
diff
changeset
|
39 <th class='bookName'>date</th></tr>"; |
|
a15320882b30
modified version list area, make it more neat.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents:
17
diff
changeset
|
40 |
| 0 | 41 $str.="<tr>"; |
| 42 $str.="<td>".$bookInfo['id']; | |
|
18
a15320882b30
modified version list area, make it more neat.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents:
17
diff
changeset
|
43 $str.="</td><td>".$bookInfo['name']; |
|
a15320882b30
modified version list area, make it more neat.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents:
17
diff
changeset
|
44 $str.="</td><td>".$bookInfo['level1']; |
|
a15320882b30
modified version list area, make it more neat.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents:
17
diff
changeset
|
45 $str.="</td><td>".$bookInfo['level2']; |
|
a15320882b30
modified version list area, make it more neat.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents:
17
diff
changeset
|
46 $str.="</td><td>".$bookInfo['period']; |
|
a15320882b30
modified version list area, make it more neat.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents:
17
diff
changeset
|
47 $str.="</td><td>".$bookInfo['line']; |
|
a15320882b30
modified version list area, make it more neat.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents:
17
diff
changeset
|
48 $str.="</td><td>".$bookInfo['version']; |
|
a15320882b30
modified version list area, make it more neat.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents:
17
diff
changeset
|
49 $str.="</td><td>".$bookInfo['editor']; |
|
a15320882b30
modified version list area, make it more neat.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents:
17
diff
changeset
|
50 $str.="</td><td>".$bookInfo['date']; |
|
a15320882b30
modified version list area, make it more neat.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents:
17
diff
changeset
|
51 $str.="</td></tr></table>"; |
|
a15320882b30
modified version list area, make it more neat.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents:
17
diff
changeset
|
52 |
| 0 | 53 echo $str; |
| 54 } | |
|
18
a15320882b30
modified version list area, make it more neat.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents:
17
diff
changeset
|
55 |
| 0 | 56 function printSectionArray($sectionArray,$missingPageArray){ |
| 57 $str="<div id='bookContainer'>"; | |
| 58 echo $str; | |
| 59 $i=0; | |
| 60 foreach($sectionArray as $idx=>$row){ | |
| 61 /* | |
| 62 $flag=""; | |
| 63 if($i!=sizeof($pageArray) && $pageArray[$i]['start_page']==$row['start_page'] && $pageArray[$i]['end_page']==$row['end_page']){ | |
| 64 $flag="overlapper"; | |
| 65 $i++; | |
| 66 } | |
| 67 if($i!=0 && $pageArray[$i-1]['start_page']==$row['start_page'] && $pageArray[$i-1]['end_page']==$row['end_page']){ | |
| 68 $flag="overlapper"; | |
| 69 }*/ | |
| 70 if(!($idx!=0 && $sectionArray[$idx-1]['start_page']==$row['start_page'] && $sectionArray[$idx-1]['end_page']==$row['end_page']) | |
| 71 && $i<sizeof($missingPageArray) && $missingPageArray[$i]['end_page']==$row['start_page']){ | |
| 72 $str="<div class='missingPageContainer'><div class='missingPage'>Missing pages: ".$missingPageArray[$i]['start_page']." - ".$missingPageArray[$i]['end_page']."</div></div>"; | |
| 73 //$str.="<br>"; | |
| 74 $i++; | |
| 75 echo $str; | |
| 76 } | |
|
18
a15320882b30
modified version list area, make it more neat.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents:
17
diff
changeset
|
77 |
| 0 | 78 $str="<div class='entry level".$row['level']." ".$row['flag']." ".$row['deleted']."'>"; |
| 79 $str.="<div class='hiddenInfo'>"; | |
| 80 $str.="<div class='id'>".$row['id']."</div>"; | |
| 81 $str.="<div class='booksId'>".sprintf("%05d",$row['books_id'])."</div>"; | |
| 82 $str.="<div class='splitFrom'>".$row['split_from']."</div>"; | |
| 83 $str.="<div class='sectionAfter'>".$row['section_after']."</div>"; | |
| 84 $str.="</div>";//end of hiddenInfo | |
| 85 $str.="<div class='sequence'>".($idx+1)."</div>"; | |
| 86 $str.="<div class='name'>".$row['name']."</div>"; | |
| 87 $str.="<div class='page'>"; | |
| 88 $str.="<div class='startPage'>".$row['start_page']."</div>"; | |
| 89 $str.=" - "; | |
| 90 $str.="<div class='endPage'>".$row['end_page']."</div>"; | |
| 91 $str.="</div>";//end of page | |
| 92 $str.="</div>"; //end of class entry | |
| 93 echo $str; | |
|
18
a15320882b30
modified version list area, make it more neat.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents:
17
diff
changeset
|
94 |
| 0 | 95 } |
| 96 if($i<sizeof($missingPageArray)){ | |
| 97 $str="<div class='missingPage'>Missing pages: ".$missingPageArray[$i]['start_page']." - ".$missingPageArray[$i]['end_page']."</div>"; | |
| 98 echo $str; | |
| 99 } | |
| 100 $str="</div>"; | |
| 101 echo $str; | |
| 102 } | |
| 103 | |
|
5
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
104 if (isset($_GET['sessionId'])) { |
|
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
105 // 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
|
106 $session_id = $_GET['sessionId']; |
|
7
3abf39f0eb46
bug fixed: sessionId from LGServices
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
6
diff
changeset
|
107 |
|
3abf39f0eb46
bug fixed: sessionId from LGServices
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
6
diff
changeset
|
108 global $lgserver_url; |
|
3abf39f0eb46
bug fixed: sessionId from LGServices
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
6
diff
changeset
|
109 $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
|
110 //$lg_url = "http://localgazetteers-dev/LGServices/rest/utils/getUser?sessionId=".$session_id; // url to get username from LGService |
|
18
a15320882b30
modified version list area, make it more neat.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents:
17
diff
changeset
|
111 $output = file_get_contents($lg_url); |
|
a15320882b30
modified version list area, make it more neat.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents:
17
diff
changeset
|
112 $user_info = json_decode($output, true); |
|
a15320882b30
modified version list area, make it more neat.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents:
17
diff
changeset
|
113 |
|
a15320882b30
modified version list area, make it more neat.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents:
17
diff
changeset
|
114 if(strcmp($user_info['status'], "ok") === 0 && isset($user_info['userName'])){ |
|
a15320882b30
modified version list area, make it more neat.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents:
17
diff
changeset
|
115 |
|
a15320882b30
modified version list area, make it more neat.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents:
17
diff
changeset
|
116 $current_editor = (string)$user_info['userName']; |
|
a15320882b30
modified version list area, make it more neat.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents:
17
diff
changeset
|
117 |
|
a15320882b30
modified version list area, make it more neat.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents:
17
diff
changeset
|
118 if($current_editor == "" || strcmp($current_editor, "") === 0){ |
|
a15320882b30
modified version list area, make it more neat.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents:
17
diff
changeset
|
119 |
|
a15320882b30
modified version list area, make it more neat.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents:
17
diff
changeset
|
120 // redirect to LGServices homepage |
|
a15320882b30
modified version list area, make it more neat.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents:
17
diff
changeset
|
121 header("Location: ".$lgserver_url); |
|
a15320882b30
modified version list area, make it more neat.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents:
17
diff
changeset
|
122 |
|
a15320882b30
modified version list area, make it more neat.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents:
17
diff
changeset
|
123 exit; |
|
a15320882b30
modified version list area, make it more neat.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents:
17
diff
changeset
|
124 |
|
a15320882b30
modified version list area, make it more neat.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents:
17
diff
changeset
|
125 } |
|
a15320882b30
modified version list area, make it more neat.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents:
17
diff
changeset
|
126 } else { |
|
a15320882b30
modified version list area, make it more neat.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents:
17
diff
changeset
|
127 |
|
a15320882b30
modified version list area, make it more neat.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents:
17
diff
changeset
|
128 // redirect to LGServices homepage |
|
a15320882b30
modified version list area, make it more neat.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents:
17
diff
changeset
|
129 header("Location: ".$lgserver_url); |
|
a15320882b30
modified version list area, make it more neat.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents:
17
diff
changeset
|
130 |
|
a15320882b30
modified version list area, make it more neat.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents:
17
diff
changeset
|
131 exit; |
|
a15320882b30
modified version list area, make it more neat.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents:
17
diff
changeset
|
132 } |
|
5
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
133 |
|
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
134 } else { |
|
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
135 // test locally |
|
8
7258ccd8ef7d
new: user need to login in LGServices
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
7
diff
changeset
|
136 // redirect to LGServices homepage |
|
18
a15320882b30
modified version list area, make it more neat.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents:
17
diff
changeset
|
137 header("Location: ".$lgserver_url); |
|
a15320882b30
modified version list area, make it more neat.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents:
17
diff
changeset
|
138 exit; |
|
5
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
139 } |
|
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
140 |
|
12
7e04cbe8b2a0
add required libraries to server
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
11
diff
changeset
|
141 |
| 0 | 142 ?> |
| 143 | |
| 144 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> | |
| 145 <html> | |
|
5
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
146 <head> |
|
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
147 <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
|
148 |
|
7e04cbe8b2a0
add required libraries to server
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
11
diff
changeset
|
149 <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
|
150 <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
|
151 <script src="js/jquery/jquery-ui.js" type="text/javascript"></script> |
|
18
a15320882b30
modified version list area, make it more neat.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents:
17
diff
changeset
|
152 |
|
a15320882b30
modified version list area, make it more neat.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents:
17
diff
changeset
|
153 <link href="css/check_sections.css?v=18" type="text/css" rel="stylesheet"/> |
|
a15320882b30
modified version list area, make it more neat.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents:
17
diff
changeset
|
154 <script src="js/check_sections_details.js?v=18" type="text/javascript"></script> |
|
12
7e04cbe8b2a0
add required libraries to server
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
11
diff
changeset
|
155 |
|
5
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
156 </head> |
|
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
157 <body> |
| 0 | 158 <div id="loading">...</div> |
| 159 <div id="container"> | |
|
5
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
160 <?php |
| 0 | 161 $version=0; |
| 162 $editor=""; | |
| 163 $date=""; | |
|
5
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
164 if(isset($_GET['book_id']) && isset($_GET['count']) && is_numeric($_GET['count'])){ |
| 0 | 165 $bookId=$_GET['book_id']; |
| 166 $count=$_GET['count']; | |
| 167 $bookInfo=getBookInfo($bookId); | |
| 168 $info=checkSectionInfo($bookId); | |
| 169 $version=$info['version']; | |
| 170 $editor=$info['editor']; | |
| 171 $date=$info['date']; | |
| 172 $bookInfo=array_merge($bookInfo,["version"=>$version,"editor"=>$editor,"date"=>$date]); | |
| 173 printBookInfo($bookInfo); | |
| 174 //echo "version: ".$version."<br>last editor: ".$editor; | |
| 175 $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
|
176 ?> |
| 0 | 177 |
|
18
a15320882b30
modified version list area, make it more neat.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents:
17
diff
changeset
|
178 <table id="history_table"> |
|
a15320882b30
modified version list area, make it more neat.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents:
17
diff
changeset
|
179 <thead> |
|
a15320882b30
modified version list area, make it more neat.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents:
17
diff
changeset
|
180 <button id="show_all" style="display:block;">Show history</button> |
|
a15320882b30
modified version list area, make it more neat.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents:
17
diff
changeset
|
181 <button id="close" style="display:none;margin-bottom:10px;">Close</button> |
|
5
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
182 </thead> |
|
18
a15320882b30
modified version list area, make it more neat.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents:
17
diff
changeset
|
183 <tbody id="history_body"> |
|
a15320882b30
modified version list area, make it more neat.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents:
17
diff
changeset
|
184 |
|
5
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
185 </tbody> |
|
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
186 </table> |
|
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
187 <div id="searchResults"> |
|
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
188 <?php |
| 0 | 189 $sectionArray=getSectionArray($bookId,$count,$info); |
| 190 printSectionArray($sectionArray,$missingPageArray); | |
|
5
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
191 }else{ |
| 0 | 192 echo "Cannot process the data due to incomplete input."; |
| 193 } | |
|
5
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
194 ?> |
|
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
195 </div> |
| 0 | 196 </div> |
| 197 <div id="panel"></div> | |
| 13 | 198 <script> |
|
17
2e6bf16b0be3
Commit from test site
Calvin Yeh <cyeh@mpipw-berlin.mpg.com>
parents:
14
diff
changeset
|
199 var version=<?php echo $version;?>; |
|
2e6bf16b0be3
Commit from test site
Calvin Yeh <cyeh@mpipw-berlin.mpg.com>
parents:
14
diff
changeset
|
200 var session_id = "<?php echo $_GET['sessionId'];?>"; |
| 0 | 201 |
|
5
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
202 function setCurrentEditor() { |
|
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
203 // 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
|
204 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
|
205 if (current_editor != "") { |
|
5
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
206 $("#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
|
207 } else { |
| 13 | 208 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
|
209 $("#loading").show(); |
|
5
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
210 } |
|
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
211 } |
| 0 | 212 |
| 213 function showAll() { | |
| 214 | |
| 215 <?php | |
| 216 | |
| 217 $query_editor = "(SELECT editor, date, version from sections_versions WHERE books_id='".$bookId."' ORDER BY version DESC)"; | |
| 218 $result = mysql_query($query_editor); | |
|
18
a15320882b30
modified version list area, make it more neat.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents:
17
diff
changeset
|
219 |
|
a15320882b30
modified version list area, make it more neat.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents:
17
diff
changeset
|
220 while ($row = mysql_fetch_assoc($result)) { |
|
a15320882b30
modified version list area, make it more neat.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents:
17
diff
changeset
|
221 $history[] = $row; |
|
a15320882b30
modified version list area, make it more neat.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents:
17
diff
changeset
|
222 } |
|
a15320882b30
modified version list area, make it more neat.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents:
17
diff
changeset
|
223 |
|
a15320882b30
modified version list area, make it more neat.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents:
17
diff
changeset
|
224 $struct = array("data" => $history); |
|
a15320882b30
modified version list area, make it more neat.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents:
17
diff
changeset
|
225 print "var histories=".json_encode($struct) .";"; |
|
a15320882b30
modified version list area, make it more neat.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents:
17
diff
changeset
|
226 |
| 0 | 227 ?> |
| 228 | |
|
18
a15320882b30
modified version list area, make it more neat.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents:
17
diff
changeset
|
229 var tableData = '<tr><td>Editor</td><td>Version</td><td>Saved Time</td></tr>'; |
|
a15320882b30
modified version list area, make it more neat.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents:
17
diff
changeset
|
230 |
|
a15320882b30
modified version list area, make it more neat.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents:
17
diff
changeset
|
231 $.each(histories.data, function(index, data) { |
|
a15320882b30
modified version list area, make it more neat.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents:
17
diff
changeset
|
232 tableData += '<tr><td>'+data.editor+'</td><td>'+data.version+'</td><td>'+data.date+'</td><</tr>'; |
|
a15320882b30
modified version list area, make it more neat.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents:
17
diff
changeset
|
233 }); |
|
a15320882b30
modified version list area, make it more neat.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents:
17
diff
changeset
|
234 |
|
a15320882b30
modified version list area, make it more neat.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents:
17
diff
changeset
|
235 $('#history_body').html(tableData); |
|
a15320882b30
modified version list area, make it more neat.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents:
17
diff
changeset
|
236 |
|
a15320882b30
modified version list area, make it more neat.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents:
17
diff
changeset
|
237 document.getElementById("show_all").style.display = "none"; |
|
a15320882b30
modified version list area, make it more neat.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents:
17
diff
changeset
|
238 document.getElementById("close").style.display = "block"; |
|
a15320882b30
modified version list area, make it more neat.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents:
17
diff
changeset
|
239 |
| 0 | 240 } |
| 241 | |
|
18
a15320882b30
modified version list area, make it more neat.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents:
17
diff
changeset
|
242 document.getElementById("show_all").onclick = showAll; |
| 0 | 243 |
| 244 function closeAll() { | |
|
18
a15320882b30
modified version list area, make it more neat.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents:
17
diff
changeset
|
245 |
|
a15320882b30
modified version list area, make it more neat.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents:
17
diff
changeset
|
246 $('#history_body').html(""); |
|
a15320882b30
modified version list area, make it more neat.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents:
17
diff
changeset
|
247 |
|
a15320882b30
modified version list area, make it more neat.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents:
17
diff
changeset
|
248 document.getElementById("show_all").style.display = "block"; |
|
a15320882b30
modified version list area, make it more neat.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents:
17
diff
changeset
|
249 document.getElementById("close").style.display = "none"; |
| 0 | 250 } |
|
18
a15320882b30
modified version list area, make it more neat.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents:
17
diff
changeset
|
251 |
|
a15320882b30
modified version list area, make it more neat.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents:
17
diff
changeset
|
252 document.getElementById("close").onclick = closeAll; |
|
a15320882b30
modified version list area, make it more neat.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents:
17
diff
changeset
|
253 |
|
5
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
254 |
|
12
7e04cbe8b2a0
add required libraries to server
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
11
diff
changeset
|
255 // --- timeout reminder --- |
|
7e04cbe8b2a0
add required libraries to server
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
11
diff
changeset
|
256 var timeoutID; |
|
7e04cbe8b2a0
add required libraries to server
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
11
diff
changeset
|
257 delayedAlert(); |
|
7e04cbe8b2a0
add required libraries to server
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
11
diff
changeset
|
258 function delayedAlert() { |
|
18
a15320882b30
modified version list area, make it more neat.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents:
17
diff
changeset
|
259 timeoutID = window.setTimeout(slowAlert, 1200*1000); |
|
12
7e04cbe8b2a0
add required libraries to server
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
11
diff
changeset
|
260 } |
|
7e04cbe8b2a0
add required libraries to server
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
11
diff
changeset
|
261 function slowAlert() { |
|
18
a15320882b30
modified version list area, make it more neat.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents:
17
diff
changeset
|
262 if (confirm("Reminder: It's been 20 mins. Remember saving your work to prevent data lost. \n\nKeep working? \n(Press Cancel will turn off this reminder.)")) { |
|
a15320882b30
modified version list area, make it more neat.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents:
17
diff
changeset
|
263 |
|
12
7e04cbe8b2a0
add required libraries to server
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
11
diff
changeset
|
264 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
|
265 |
|
7e04cbe8b2a0
add required libraries to server
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
11
diff
changeset
|
266 $.post(lg_url, function(data) { |
| 13 | 267 console.log("renew session."); |
|
18
a15320882b30
modified version list area, make it more neat.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents:
17
diff
changeset
|
268 |
| 14 | 269 }).done(function(data){ |
| 270 console.log(data); | |
| 271 console.log("login as: " + data['userName']); | |
| 272 | |
| 273 if (data['userName'] == "") { | |
|
18
a15320882b30
modified version list area, make it more neat.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents:
17
diff
changeset
|
274 alert("Error!! You have to re-login from LGService!"); |
| 14 | 275 $("#loading").show(); |
| 276 } else { | |
|
18
a15320882b30
modified version list area, make it more neat.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents:
17
diff
changeset
|
277 timeoutID = window.setTimeout(slowAlert, 1200*1000); |
| 14 | 278 } |
| 279 | |
| 280 }).fail(function(){ | |
| 281 console.log("fail to renew session."); | |
|
12
7e04cbe8b2a0
add required libraries to server
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
11
diff
changeset
|
282 }); |
|
7e04cbe8b2a0
add required libraries to server
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
11
diff
changeset
|
283 } |
|
18
a15320882b30
modified version list area, make it more neat.
Calvin Yeh <cyeh@mpiwg-berlin.mpg.de>
parents:
17
diff
changeset
|
284 |
|
12
7e04cbe8b2a0
add required libraries to server
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
11
diff
changeset
|
285 } |
|
7e04cbe8b2a0
add required libraries to server
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
11
diff
changeset
|
286 |
|
7e04cbe8b2a0
add required libraries to server
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
11
diff
changeset
|
287 |
|
7e04cbe8b2a0
add required libraries to server
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
11
diff
changeset
|
288 |
|
5
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
289 </script> |
| 0 | 290 |
| 291 | |
|
5
26ed9d1d6957
New: get user name from LGService by sessionId
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
4
diff
changeset
|
292 </body> |
| 0 | 293 |
| 294 </html> |
