Mercurial > hg > LGToc

diff check_sections_details.php @ 0:723a162b6627

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
first commit
author Zoe Hong <zhong@mpiwg-berlin.mpg.de>
date Thu, 19 Mar 2015 15:06:34 +0100
parents
children 373c8ecad8b4
line wrap: on
line diff
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/check_sections_details.php	Thu Mar 19 15:06:34 2015 +0100
@@ -0,0 +1,206 @@
+<?php
+include_once('Lib_mb_utf8.php');
+include_once('config.php');
+include_once('edit_section_db.php');
+set_time_limit(0);
+ini_set('memory_limit', '-1');
+
+$link_mysql = mysql_connect($mysql_server, $mysql_user, $mysql_password);
+mysql_query("SET NAMES utf8");
+
+if (!$link_mysql) {
+    die('Could not connect: ' . mysql_error());
+}
+
+$db_selected = mysql_select_db($mysql_database, $link_mysql);
+if (!$db_selected) {
+    die ('Can\'t use foo : ' . mysql_error());
+}
+function getBookInfo($bookId){
+        $query="SELECT * FROM books WHERE id=".$bookId;
+	$result=mysql_query($query);
+	$bookInfo=mysql_fetch_assoc($result);
+	return $bookInfo;
+}
+function printBookInfo($bookInfo){
+	$str="<table>";
+	$str.="<tr><td class='bookId'>book id
+		<td class='bookName'>book name
+		<td class='level1'>level1
+		<td class='level2'>level2
+		<td class='period'>period
+		<td class='bookId'>pages
+		<td class='bookId'>version
+		<td class='bookName'>editor
+		<td class='bookName'>date";
+	$str.="<tr>";
+	$str.="<td>".$bookInfo['id'];
+	$str.="<td>".$bookInfo['name'];
+	$str.="<td>".$bookInfo['level1'];
+	$str.="<td>".$bookInfo['level2'];
+	$str.="<td>".$bookInfo['period'];
+	$str.="<td>".$bookInfo['line'];
+	$str.="<td>".$bookInfo['version'];
+	$str.="<td>".$bookInfo['editor'];
+	$str.="<td>".$bookInfo['date'];
+	$str.="</table>";
+	echo $str;
+}
+function printSectionArray($sectionArray,$missingPageArray){
+	$str="<div id='bookContainer'>";
+	echo $str;
+	$i=0;
+	foreach($sectionArray as $idx=>$row){
+		/*
+		$flag="";
+		if($i!=sizeof($pageArray) && $pageArray[$i]['start_page']==$row['start_page'] && $pageArray[$i]['end_page']==$row['end_page']){
+			$flag="overlapper";
+			$i++;
+		}
+		if($i!=0 && $pageArray[$i-1]['start_page']==$row['start_page'] && $pageArray[$i-1]['end_page']==$row['end_page']){
+			$flag="overlapper";
+		}*/
+		if(!($idx!=0 && $sectionArray[$idx-1]['start_page']==$row['start_page'] && $sectionArray[$idx-1]['end_page']==$row['end_page'])
+			&& $i<sizeof($missingPageArray) && $missingPageArray[$i]['end_page']==$row['start_page']){
+			$str="<div class='missingPageContainer'><div class='missingPage'>Missing pages: ".$missingPageArray[$i]['start_page']." - ".$missingPageArray[$i]['end_page']."</div></div>";
+			//$str.="<br>";
+			$i++;
+			echo $str;
+		}
+		
+		$str="<div class='entry level".$row['level']." ".$row['flag']." ".$row['deleted']."'>";
+			$str.="<div class='hiddenInfo'>";
+				$str.="<div class='id'>".$row['id']."</div>";
+				$str.="<div class='booksId'>".sprintf("%05d",$row['books_id'])."</div>";
+				$str.="<div class='splitFrom'>".$row['split_from']."</div>";
+				$str.="<div class='sectionAfter'>".$row['section_after']."</div>";
+			$str.="</div>";//end of hiddenInfo
+			$str.="<div class='sequence'>".($idx+1)."</div>";
+			$str.="<div class='name'>".$row['name']."</div>";
+			$str.="<div class='page'>";
+				$str.="<div class='startPage'>".$row['start_page']."</div>";
+				$str.=" - ";
+				$str.="<div class='endPage'>".$row['end_page']."</div>";
+			$str.="</div>";//end of page
+		$str.="</div>";	//end of class entry
+		echo $str;
+		
+	}
+	if($i<sizeof($missingPageArray)){
+		$str="<div class='missingPage'>Missing pages: ".$missingPageArray[$i]['start_page']." - ".$missingPageArray[$i]['end_page']."</div>";
+                echo $str;
+	}
+	$str="</div>";
+	echo $str;
+}
+
+?>
+
+<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
+<html>
+        <head>
+                <meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
+                <link href="https://code.jquery.com/ui/1.10.4/themes/smoothness/jquery-ui.css" type="text/css" rel="stylesheet"/>
+                <link href="css/check_sections.css" type="text/css" rel="stylesheet"/>
+                <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.6.2/jquery.min.js" type="text/javascript"></script>
+                <script src="js/check_sections_details.js" type="text/javascript"></script>
+                <script src="https://code.jquery.com/ui/1.10.4/jquery-ui.js" type="text/javascript"></script>
+                <!--<script src="js/check_sections.js" charset="utf-8"></script>!-->
+        </head>
+        <body>
+		<div id="loading">...</div>
+		<div id="container">
+                <?php
+			$version=0;
+			$editor="";
+			$date="";
+                        if(isset($_GET['book_id']) && isset($_GET['count']) && is_numeric($_GET['count'])){
+				$bookId=$_GET['book_id'];
+				$count=$_GET['count'];
+				$bookInfo=getBookInfo($bookId);
+				$info=checkSectionInfo($bookId);
+				$version=$info['version'];
+				$editor=$info['editor'];
+				$date=$info['date'];
+				$bookInfo=array_merge($bookInfo,["version"=>$version,"editor"=>$editor,"date"=>$date]);
+                                printBookInfo($bookInfo);
+				//echo "version: ".$version."<br>last editor: ".$editor;
+				$missingPageArray=checkMissingPage($bookInfo,$info);
+		?>
+
+		<table>
+			<thead>Show editing records:
+				<button id="show_all">Show all</button>
+				<button id="close">Close</button>
+			</thead>
+			<tbody>
+				<tr>
+					<td id="editor_th"></td>
+					<td id="date_th"></td>
+				</tr>
+				<tr>
+					<td><div id="editor"></div></td>
+					<td><div id="date"></div></td>
+				</tr>
+			</tbody>
+		</table>
+
+
+
+                	<div id="searchResults">
+		<?php
+				$sectionArray=getSectionArray($bookId,$count,$info);
+				printSectionArray($sectionArray,$missingPageArray);
+                        }else{
+				echo "Cannot process the data due to incomplete input.";
+			}
+                ?>
+                	</div>
+		</div>
+		<div id="panel"></div>
+		<script>var version=<?php echo $version;?>;</script>
+
+		<script type="text/javascript">
+
+		document.getElementById("show_all").onclick = function(){showAll()};
+
+		function showAll() {
+			document.getElementById("editor_th").innerHTML = "Editor(version)";
+			document.getElementById("date_th").innerHTML = "Date/Time";
+
+			<?php
+				$editors = "";
+				$editing_time = "";
+
+				$query_editor = "(SELECT editor, date, version from sections_versions WHERE books_id='".$bookId."' ORDER BY version DESC)";
+				$result = mysql_query($query_editor);
+				
+				while ($row = mysql_fetch_assoc($result)) {
+					$editor = $row['editor'];
+					$edit_time = $row['date'];
+					$version = $row['version'];
+					?>
+					document.getElementById("editor").innerHTML += '<?php echo $editor; ?>' +'('+'<?php echo $version;?>' +')<br>';
+					document.getElementById("date").innerHTML += '<?php echo $edit_time; ?>' + '<br>';
+					<?php
+		
+				}
+			?>
+
+		}
+
+		document.getElementById("close").onclick = function(){closeAll()};
+
+		function closeAll() {
+			document.getElementById("editor_th").innerHTML = "";
+			document.getElementById("date_th").innerHTML = "";
+			document.getElementById("editor").innerHTML = "";
+			document.getElementById("date").innerHTML = "";
+		}
+    		</script>
+
+
+        </body>
+
+</html>
+