comparison interface/check_sections_details.php @ 2:da5309d54083

add missing books to sections as dummy entries for further modification. (1) Alter "Auto_increment" to 5190896 for sections table in database. (2) Finds missing books (using mysql OR _select_distinct() in add_missing_books_to_sections.php (3) Put the missing_books.csv in intermediate_results. and execute: add_missing_books_to_sections.php
author Zoe Hong <zhong@mpiwg-berlin.mpg.de>
date Fri, 23 Jan 2015 19:00:57 +0100
parents ef6d0c6a13d7
children 883ad980a43b
comparison
equal deleted inserted replaced
1:ef6d0c6a13d7 2:da5309d54083
118 $date=""; 118 $date="";
119 if(isset($_GET['book_id']) && isset($_GET['count']) && is_numeric($_GET['count'])){ 119 if(isset($_GET['book_id']) && isset($_GET['count']) && is_numeric($_GET['count'])){
120 $bookId=$_GET['book_id']; 120 $bookId=$_GET['book_id'];
121 $count=$_GET['count']; 121 $count=$_GET['count'];
122 $bookInfo=getBookInfo($bookId); 122 $bookInfo=getBookInfo($bookId);
123
123 $info=checkSectionInfo($bookId); 124 $info=checkSectionInfo($bookId);
124 $version=$info['version']; 125 $version=$info['version'];
125 $editor=$info['editor']; 126 $editor=$info['editor'];
126 $date=$info['date']; 127 $date=$info['date'];
127 $bookInfo=array_merge($bookInfo,["version"=>$version,"editor"=>$editor,"date"=>$date]); 128 $bookInfo=array_merge($bookInfo,["version"=>$version,"editor"=>$editor,"date"=>$date]);
129 //echo "version: ".$version."<br>last editor: ".$editor; 130 //echo "version: ".$version."<br>last editor: ".$editor;
130 $missingPageArray=checkMissingPage($bookInfo,$info); 131 $missingPageArray=checkMissingPage($bookInfo,$info);
131 ?> 132 ?>
132 <div id="searchResults"> 133 <div id="searchResults">
133 <?php 134 <?php
135
134 $sectionArray=getSectionArray($bookId,$count,$info); 136 $sectionArray=getSectionArray($bookId,$count,$info);
135 printSectionArray($sectionArray,$missingPageArray); 137 printSectionArray($sectionArray,$missingPageArray);
136 }else{ 138 }else{
137 echo "Cannot process the data due to incomplete input."; 139 echo "Cannot process the data due to incomplete input.";
138 } 140 }
141 </div> 143 </div>
142 <div id="panel"></div> 144 <div id="panel"></div>
143 <script>var version=<?php echo $version;?>;</script> 145 <script>var version=<?php echo $version;?>;</script>
144 </body> 146 </body>
145 147
148
146 </html> 149 </html>
147 150