LGToc: check_sections_details.php annotate

annotate check_sections_details.php @ 12:7e04cbe8b2a0

add required libraries to server

author	Zoe Hong <zhong@mpiwg-berlin.mpg.de>
date	Wed, 24 Jun 2015 11:11:31 +0200
parents	0a03c75499e6
children	3d206aa0c77d

rev	line source
0 723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	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 723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	4 include_once('edit_section_db.php');
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	5 set_time_limit(0);
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	6 ini_set('memory_limit', '-1');
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	7
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	8 $link_mysql = mysql_connect($mysql_server, $mysql_user, $mysql_password);
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	9 mysql_query("SET NAMES utf8");
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	10
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	11 if (!$link_mysql) {
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	12 die('Could not connect: ' . mysql_error());
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	13 }
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	14
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	15 $db_selected = mysql_select_db($mysql_database, $link_mysql);
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	16 if (!$db_selected) {
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	17 die ('Can\'t use foo : ' . mysql_error());
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	18 }
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	19 function getBookInfo($bookId){
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	20 $query="SELECT * FROM books WHERE id=".$bookId;
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	21 $result=mysql_query($query);
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	22 $bookInfo=mysql_fetch_assoc($result);
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	23 return $bookInfo;
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	24 }
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	25 function printBookInfo($bookInfo){
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	26 $str="<table>";
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	27 $str.="<tr><td class='bookId'>book id
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	28 <td class='bookName'>book name
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	29 <td class='level1'>level1
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	30 <td class='level2'>level2
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	31 <td class='period'>period
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	32 <td class='bookId'>pages
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	33 <td class='bookId'>version
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	34 <td class='bookName'>editor
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	35 <td class='bookName'>date";
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	36 $str.="<tr>";
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	37 $str.="<td>".$bookInfo['id'];
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	38 $str.="<td>".$bookInfo['name'];
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	39 $str.="<td>".$bookInfo['level1'];
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	40 $str.="<td>".$bookInfo['level2'];
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	41 $str.="<td>".$bookInfo['period'];
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	42 $str.="<td>".$bookInfo['line'];
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	43 $str.="<td>".$bookInfo['version'];
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	44 $str.="<td>".$bookInfo['editor'];
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	45 $str.="<td>".$bookInfo['date'];
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	46 $str.="</table>";
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	47 echo $str;
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	48 }
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	49 function printSectionArray($sectionArray,$missingPageArray){
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	50 $str="<div id='bookContainer'>";
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	51 echo $str;
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	52 $i=0;
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	53 foreach($sectionArray as $idx=>$row){
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	54 /*
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	55 $flag="";
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	56 if($i!=sizeof($pageArray) && $pageArray[$i]['start_page']==$row['start_page'] && $pageArray[$i]['end_page']==$row['end_page']){
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	57 $flag="overlapper";
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	58 $i++;
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	59 }
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	60 if($i!=0 && $pageArray[$i-1]['start_page']==$row['start_page'] && $pageArray[$i-1]['end_page']==$row['end_page']){
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	61 $flag="overlapper";
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	62 }*/
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	63 if(!($idx!=0 && $sectionArray[$idx-1]['start_page']==$row['start_page'] && $sectionArray[$idx-1]['end_page']==$row['end_page'])
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	64 && $i<sizeof($missingPageArray) && $missingPageArray[$i]['end_page']==$row['start_page']){
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	65 $str="<div class='missingPageContainer'><div class='missingPage'>Missing pages: ".$missingPageArray[$i]['start_page']." - ".$missingPageArray[$i]['end_page']."</div></div>";
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	66 //$str.="<br>";
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	67 $i++;
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	68 echo $str;
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	69 }
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	70
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	71 $str="<div class='entry level".$row['level']." ".$row['flag']." ".$row['deleted']."'>";
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	72 $str.="<div class='hiddenInfo'>";
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	73 $str.="<div class='id'>".$row['id']."</div>";
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	74 $str.="<div class='booksId'>".sprintf("%05d",$row['books_id'])."</div>";
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	75 $str.="<div class='splitFrom'>".$row['split_from']."</div>";
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	76 $str.="<div class='sectionAfter'>".$row['section_after']."</div>";
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	77 $str.="</div>";//end of hiddenInfo
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	78 $str.="<div class='sequence'>".($idx+1)."</div>";
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	79 $str.="<div class='name'>".$row['name']."</div>";
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	80 $str.="<div class='page'>";
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	81 $str.="<div class='startPage'>".$row['start_page']."</div>";
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	82 $str.=" - ";
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	83 $str.="<div class='endPage'>".$row['end_page']."</div>";
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	84 $str.="</div>";//end of page
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	85 $str.="</div>"; //end of class entry
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	86 echo $str;
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	87
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	88 }
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	89 if($i<sizeof($missingPageArray)){
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	90 $str="<div class='missingPage'>Missing pages: ".$missingPageArray[$i]['start_page']." - ".$missingPageArray[$i]['end_page']."</div>";
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	91 echo $str;
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	92 }
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	93 $str="</div>";
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	94 echo $str;
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	95 }
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	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'];
8 7258ccd8ef7d new: user need to login in LGServices Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 7 diff changeset	107
12 7e04cbe8b2a0 add required libraries to server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	108 if ($current_editor == null \|\| strcmp($user_info['status'], "error") == 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");
0a03c75499e6 bug fixed: sessionId after saving Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 10 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");
0a03c75499e6 bug fixed: sessionId after saving Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 10 diff changeset	118 //header('Location: http://localgazetteers/LGServices');
5 26ed9d1d6957 New: get user name from LGService by sessionId Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 4 diff changeset	119 }
26ed9d1d6957 New: get user name from LGService by sessionId Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 4 diff changeset	120
12 7e04cbe8b2a0 add required libraries to server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	121
0 723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	122 ?>
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	123
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	124 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	125 <html>
5 26ed9d1d6957 New: get user name from LGService by sessionId Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 4 diff changeset	126 <head>
26ed9d1d6957 New: get user name from LGService by sessionId Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 4 diff changeset	127 <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	128
7e04cbe8b2a0 add required libraries to server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	129 <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	130 <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	131 <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	132
5 26ed9d1d6957 New: get user name from LGService by sessionId Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 4 diff changeset	133 <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	134 <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	135
7e04cbe8b2a0 add required libraries to server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	136 <!--
7e04cbe8b2a0 add required libraries to server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	137 <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	138 <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	139 <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	140 -->
5 26ed9d1d6957 New: get user name from LGService by sessionId Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 4 diff changeset	141 <!--<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	142
5 26ed9d1d6957 New: get user name from LGService by sessionId Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 4 diff changeset	143 </head>
26ed9d1d6957 New: get user name from LGService by sessionId Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 4 diff changeset	144 <body>
0 723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	145 <div id="loading">...</div>
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	146 <div id="container">
5 26ed9d1d6957 New: get user name from LGService by sessionId Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 4 diff changeset	147 <?php
0 723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	148 $version=0;
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	149 $editor="";
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	150 $date="";
5 26ed9d1d6957 New: get user name from LGService by sessionId Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 4 diff changeset	151 if(isset($_GET['book_id']) && isset($_GET['count']) && is_numeric($_GET['count'])){
0 723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	152 $bookId=$_GET['book_id'];
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	153 $count=$_GET['count'];
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	154 $bookInfo=getBookInfo($bookId);
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	155 $info=checkSectionInfo($bookId);
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	156 $version=$info['version'];
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	157 $editor=$info['editor'];
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	158 $date=$info['date'];
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	159 $bookInfo=array_merge($bookInfo,["version"=>$version,"editor"=>$editor,"date"=>$date]);
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	160 printBookInfo($bookInfo);
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	161 //echo "version: ".$version."<br>last editor: ".$editor;
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	162 $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	163 ?>
0 723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	164
5 26ed9d1d6957 New: get user name from LGService by sessionId Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 4 diff changeset	165 <table>
26ed9d1d6957 New: get user name from LGService by sessionId Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 4 diff changeset	166 <thead>Show editing records:
26ed9d1d6957 New: get user name from LGService by sessionId Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 4 diff changeset	167 <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	168 <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	169 </thead>
26ed9d1d6957 New: get user name from LGService by sessionId Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 4 diff changeset	170 <tbody>
26ed9d1d6957 New: get user name from LGService by sessionId Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 4 diff changeset	171 <tr>
26ed9d1d6957 New: get user name from LGService by sessionId Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 4 diff changeset	172 <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	173 <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	174 </tr>
26ed9d1d6957 New: get user name from LGService by sessionId Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 4 diff changeset	175 <tr>
26ed9d1d6957 New: get user name from LGService by sessionId Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 4 diff changeset	176 <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	177 <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	178 </tr>
26ed9d1d6957 New: get user name from LGService by sessionId Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 4 diff changeset	179 </tbody>
26ed9d1d6957 New: get user name from LGService by sessionId Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 4 diff changeset	180 </table>
0 723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	181
5 26ed9d1d6957 New: get user name from LGService by sessionId Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 4 diff changeset	182 <div id="searchResults">
26ed9d1d6957 New: get user name from LGService by sessionId Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 4 diff changeset	183 <?php
0 723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	184 $sectionArray=getSectionArray($bookId,$count,$info);
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	185 printSectionArray($sectionArray,$missingPageArray);
5 26ed9d1d6957 New: get user name from LGService by sessionId Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 4 diff changeset	186 }else{
0 723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	187 echo "Cannot process the data due to incomplete input.";
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	188 }
5 26ed9d1d6957 New: get user name from LGService by sessionId Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 4 diff changeset	189 ?>
26ed9d1d6957 New: get user name from LGService by sessionId Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 4 diff changeset	190 </div>
0 723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	191 </div>
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	192 <div id="panel"></div>
11 0a03c75499e6 bug fixed: sessionId after saving Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 10 diff changeset	193 <script>var version = <?php echo $version;?>;
0a03c75499e6 bug fixed: sessionId after saving Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 10 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 723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	196
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	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) ?>;
5 26ed9d1d6957 New: get user name from LGService by sessionId Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 4 diff changeset	201 if (current_editor != "") {
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 {
7258ccd8ef7d new: user need to login in LGServices Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 7 diff changeset	204 console.log("You have to login from LGService!");
5 26ed9d1d6957 New: get user name from LGService by sessionId Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 4 diff changeset	205 }
26ed9d1d6957 New: get user name from LGService by sessionId Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 4 diff changeset	206 }
0 723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	207
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	208 document.getElementById("show_all").onclick = function(){showAll()};
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	209
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	210 function showAll() {
10 2c35af0d78f3 bug fixed: sessionId after saving Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 8 diff changeset	211 closeAll();
0 723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	212 document.getElementById("editor_th").innerHTML = "Editor(version)";
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	213 document.getElementById("date_th").innerHTML = "Date/Time";
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	214
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	215 <?php
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	216 $editors = "";
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	217 $editing_time = "";
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	218
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	219 $query_editor = "(SELECT editor, date, version from sections_versions WHERE books_id='".$bookId."' ORDER BY version DESC)";
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	220 $result = mysql_query($query_editor);
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	221
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	222 while ($row = mysql_fetch_assoc($result)) {
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	223 $editor = $row['editor'];
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	224 $edit_time = $row['date'];
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	225 $version = $row['version'];
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	226 ?>
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	227 document.getElementById("editor").innerHTML += '<?php echo $editor; ?>' +'('+'<?php echo $version;?>' +')<br>';
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	228 document.getElementById("date").innerHTML += '<?php echo $edit_time; ?>' + '<br>';
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	229 <?php
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	230
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	231 }
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	232 ?>
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	233
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	234 }
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	235
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	236 document.getElementById("close").onclick = function(){closeAll()};
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	237
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	238 function closeAll() {
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	239 document.getElementById("editor_th").innerHTML = "";
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	240 document.getElementById("date_th").innerHTML = "";
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	241 document.getElementById("editor").innerHTML = "";
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	242 document.getElementById("date").innerHTML = "";
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	243 }
5 26ed9d1d6957 New: get user name from LGService by sessionId Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 4 diff changeset	244
26ed9d1d6957 New: get user name from LGService by sessionId Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 4 diff changeset	245
12 7e04cbe8b2a0 add required libraries to server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	246 /*
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() {
7e04cbe8b2a0 add required libraries to server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	251 timeoutID = window.setTimeout(slowAlert, 4000);
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() {
7e04cbe8b2a0 add required libraries to server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	254 if (confirm("Reminder: It's been 30 mins. Don't forget to save your work. \n\nKeep working? \n(Press Cancel will turn off this reminder.)")) {
7e04cbe8b2a0 add required libraries to server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	255 timeoutID = window.setTimeout(slowAlert, 4000);
7e04cbe8b2a0 add required libraries to server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	256 // renew session?
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 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	259 console.log(lg_url);
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 $.post(lg_url, function(data) {
7e04cbe8b2a0 add required libraries to server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	262
7e04cbe8b2a0 add required libraries to server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	263 ///console.log(data);
7e04cbe8b2a0 add required libraries to server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	264
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 }
7e04cbe8b2a0 add required libraries to server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	267 }
7e04cbe8b2a0 add required libraries to server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	268 */
7e04cbe8b2a0 add required libraries to server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	269
7e04cbe8b2a0 add required libraries to server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	270
7e04cbe8b2a0 add required libraries to server Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	271
5 26ed9d1d6957 New: get user name from LGService by sessionId Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 4 diff changeset	272 </script>
0 723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	273
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	274
5 26ed9d1d6957 New: get user name from LGService by sessionId Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 4 diff changeset	275 </body>
0 723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	276
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	277 </html>
723a162b6627 first commit Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	278

Mercurial > hg > LGToc

annotate check_sections_details.php @ 12:7e04cbe8b2a0