Mercurial > hg > extraction-interface

annotate interface/check_sections_20150120.php @ 28:e6e9bdc4f256

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
update the saving response from LGService between different file version
author Zoe Hong <zhong@mpiwg-berlin.mpg.de>
date Tue, 03 Mar 2015 18:13:20 +0100
parents ef6d0c6a13d7
children
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
1
ef6d0c6a13d7 (1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
1 <?php
ef6d0c6a13d7 (1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
2 include_once('Lib_mb_utf8.php');
ef6d0c6a13d7 (1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
3 include_once('config.php');
ef6d0c6a13d7 (1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
4 include_once('edit_section_db.php');
ef6d0c6a13d7 (1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
5 set_time_limit(0);
ef6d0c6a13d7 (1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
6 ini_set('memory_limit', '-1');
ef6d0c6a13d7 (1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
7
ef6d0c6a13d7 (1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
8 $link_mysql = mysql_connect($mysql_server, $mysql_user, $mysql_password);
ef6d0c6a13d7 (1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
9 mysql_query("SET NAMES utf8");
ef6d0c6a13d7 (1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
10
ef6d0c6a13d7 (1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
11 if (!$link_mysql) {
ef6d0c6a13d7 (1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
12 die('Could not connect: ' . mysql_error());
ef6d0c6a13d7 (1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
13 }
ef6d0c6a13d7 (1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
14
ef6d0c6a13d7 (1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
15 $db_selected = mysql_select_db($mysql_database, $link_mysql);
ef6d0c6a13d7 (1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
16 if (!$db_selected) {
ef6d0c6a13d7 (1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
17 die ('Can\'t use foo : ' . mysql_error());
ef6d0c6a13d7 (1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
18 }
ef6d0c6a13d7 (1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
19
ef6d0c6a13d7 (1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
20 function checkSections($count){
ef6d0c6a13d7 (1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
21
ef6d0c6a13d7 (1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
22 /* $query="SELECT books.name AS book_name, books.level1, books.level2, books.period, books.id, sections.name, start_page, end_page, COUNT( * ) AS count
ef6d0c6a13d7 (1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
23 FROM sections
ef6d0c6a13d7 (1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
24 JOIN books ON sections.books_id = books.id
ef6d0c6a13d7 (1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
25 WHERE NOT EXISTS
ef6d0c6a13d7 (1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
26 (SELECT 1 FROM sections_versions WHERE books_id=sections.books_id)
ef6d0c6a13d7 (1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
27 GROUP BY books_id, start_page, end_page
ef6d0c6a13d7 (1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
28 HAVING COUNT( * ) >=".$count."
ef6d0c6a13d7 (1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
29 ORDER BY COUNT( * ) DESC ";*/
ef6d0c6a13d7 (1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
30 $query="(SELECT books.name AS book_name, books.level1, books.level2, books.period, books.id, sections.name, start_page, end_page, COUNT( * ) AS count
ef6d0c6a13d7 (1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
31 FROM sections
ef6d0c6a13d7 (1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
32 JOIN books ON sections.books_id = books.id
ef6d0c6a13d7 (1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
33 WHERE NOT EXISTS
ef6d0c6a13d7 (1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
34 (SELECT 1 FROM sections_versions WHERE books_id=sections.books_id)
ef6d0c6a13d7 (1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
35 GROUP BY books_id, start_page, end_page
ef6d0c6a13d7 (1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
36 HAVING COUNT( * ) >=".$count.")
ef6d0c6a13d7 (1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
37 UNION
ef6d0c6a13d7 (1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
38 (SELECT books.name AS book_name, books.level1, books.level2, books.period, books.id, sections_revisions.name, start_page, end_page, COUNT( * ) AS count
ef6d0c6a13d7 (1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
39 FROM sections_revisions
ef6d0c6a13d7 (1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
40 JOIN books ON sections_revisions.books_id = books.id
ef6d0c6a13d7 (1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
41 JOIN (
ef6d0c6a13d7 (1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
42 SELECT sections_versions.id
ef6d0c6a13d7 (1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
43 FROM sections_versions WHERE sections_versions.version=(SELECT MAX(version) FROM sections_versions)
ef6d0c6a13d7 (1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
44 GROUP BY books_id
ef6d0c6a13d7 (1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
45 ) AS t ON t.id=sections_revisions.versions_id
ef6d0c6a13d7 (1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
46 WHERE deleted=0
ef6d0c6a13d7 (1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
47 GROUP BY books_id, versions_id,start_page, end_page
ef6d0c6a13d7 (1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
48 HAVING COUNT( * ) >=".$count.")
ef6d0c6a13d7 (1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
49 ORDER BY count DESC ";
ef6d0c6a13d7 (1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
50 $result = mysql_query($query);
ef6d0c6a13d7 (1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
51 echo mysql_num_rows($result)." result(s)<br><br>";
ef6d0c6a13d7 (1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
52 echo "<table>";
ef6d0c6a13d7 (1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
53 echo "<tr>";
ef6d0c6a13d7 (1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
54 echo "<td class='bookName'>book name<td class='level1'>level1<td class='level2'>level2<td class='period'>period<td class='sectionName'>section name<td class='sectionName'>page<td class='page'>count";
ef6d0c6a13d7 (1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
55 while ($row = mysql_fetch_assoc($result)) {
ef6d0c6a13d7 (1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
56 $str="<tr>";
ef6d0c6a13d7 (1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
57 $str.="<td>".$row['book_name'];
ef6d0c6a13d7 (1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
58 $str.="<td>".$row['level1'];
ef6d0c6a13d7 (1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
59 $str.="<td>".$row['level2'];
ef6d0c6a13d7 (1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
60 $str.="<td>".$row['period'];
ef6d0c6a13d7 (1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
61 $str.="<td><a href='tagging_text.php?id=".$row['id']."' target='_blank'>".$row['name']."</a>";
ef6d0c6a13d7 (1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
62 $str.="<td>p".$row['start_page']."-".$row['end_page'];
ef6d0c6a13d7 (1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
63 $str.="<td><a href='check_sections_details.php?book_id=".$row['id']."&count=".$count."' target='_blank'>".$row['count']."</a>";
ef6d0c6a13d7 (1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
64 echo $str;
ef6d0c6a13d7 (1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
65 }
ef6d0c6a13d7 (1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
66 echo "</table>";
ef6d0c6a13d7 (1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
67 }
ef6d0c6a13d7 (1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
68
ef6d0c6a13d7 (1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
69 ?>
ef6d0c6a13d7 (1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
70
ef6d0c6a13d7 (1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
71 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
ef6d0c6a13d7 (1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
72 <html>
ef6d0c6a13d7 (1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
73 <head>
ef6d0c6a13d7 (1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
74 <meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
ef6d0c6a13d7 (1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
75 <link href="css/search.css" type="text/css" rel="stylesheet"/>
ef6d0c6a13d7 (1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
76 <script src="http://ajax.googleapis.com/ajax/libs/jquery/1.6.2/jquery.min.js" type="text/javascript"></script>
ef6d0c6a13d7 (1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
77 <!--<script src="js/check_sections.js" charset="utf-8"></script>!-->
ef6d0c6a13d7 (1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
78 </head>
ef6d0c6a13d7 (1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
79 <body>
ef6d0c6a13d7 (1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
80 <form action='check_sections.php' method='GET'>
ef6d0c6a13d7 (1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
81 find sections overlapping more than <input type="text" name="count"> other sections
ef6d0c6a13d7 (1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
82 <input type="submit" name="find" value="find">
ef6d0c6a13d7 (1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
83 </form>
ef6d0c6a13d7 (1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
84 <br>
ef6d0c6a13d7 (1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
85 <div id="search_result">
ef6d0c6a13d7 (1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
86 <?php
ef6d0c6a13d7 (1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
87 if(isset($_GET['find']) && $_GET['count']!='' && is_numeric($_GET['count'])){
ef6d0c6a13d7 (1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
88 checkSections($_GET['count']);
ef6d0c6a13d7 (1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
89 }
ef6d0c6a13d7 (1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
90 ?>
ef6d0c6a13d7 (1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
91 </div>
ef6d0c6a13d7 (1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
92 </body>
ef6d0c6a13d7 (1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
93 </html>
ef6d0c6a13d7 (1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
94