Mercurial > hg > extraction-interface

annotate interface/check_sections.php @ 44:3163d8ca0b62 default

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
closing default branch, we use extractapp branch
author Zoe Hong <zhong@mpiwg-berlin.mpg.de>
date Fri, 13 Mar 2015 09:55:07 +0100
parents 584b1623e9ef
children
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
0
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
1 <?php
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
2 include_once('Lib_mb_utf8.php');
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
3 include_once('config.php');
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
4 include_once('edit_section_db.php');
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
5 set_time_limit(0);
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
6 ini_set('memory_limit', '-1');
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
7
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
8 $link_mysql = mysql_connect($mysql_server, $mysql_user, $mysql_password);
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
9 mysql_query("SET NAMES utf8");
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
10
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
11 if (!$link_mysql) {
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
12 die('Could not connect: ' . mysql_error());
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
13 }
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
14
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
15 $db_selected = mysql_select_db($mysql_database, $link_mysql);
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
16 if (!$db_selected) {
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
17 die ('Can\'t use foo : ' . mysql_error());
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
18 }
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
19
8
da10158c6d0a add toc_correction status in books table. On TOC correction list page, providing the status checking box for users.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 7
diff changeset
20 if (isset($_POST['func'])){
da10158c6d0a add toc_correction status in books table. On TOC correction list page, providing the status checking box for users.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 7
diff changeset
21 switch ($_POST['func']) {
da10158c6d0a add toc_correction status in books table. On TOC correction list page, providing the status checking box for users.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 7
diff changeset
22 case 'UpdateTOCstatus':
da10158c6d0a add toc_correction status in books table. On TOC correction list page, providing the status checking box for users.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 7
diff changeset
23 UpdateTOCstatus($_POST['id'],$_POST['status']);
da10158c6d0a add toc_correction status in books table. On TOC correction list page, providing the status checking box for users.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 7
diff changeset
24 break;
9
584b1623e9ef TOC correction list page updated
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 8
diff changeset
25 case 'UpdateTOCcomments':
584b1623e9ef TOC correction list page updated
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 8
diff changeset
26 UpdateTOCcomments($_POST['id'],$_POST['notes']);
584b1623e9ef TOC correction list page updated
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 8
diff changeset
27 break;
8
da10158c6d0a add toc_correction status in books table. On TOC correction list page, providing the status checking box for users.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 7
diff changeset
28 default:
da10158c6d0a add toc_correction status in books table. On TOC correction list page, providing the status checking box for users.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 7
diff changeset
29 # code...
da10158c6d0a add toc_correction status in books table. On TOC correction list page, providing the status checking box for users.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 7
diff changeset
30 break;
da10158c6d0a add toc_correction status in books table. On TOC correction list page, providing the status checking box for users.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 7
diff changeset
31 }
da10158c6d0a add toc_correction status in books table. On TOC correction list page, providing the status checking box for users.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 7
diff changeset
32 }
da10158c6d0a add toc_correction status in books table. On TOC correction list page, providing the status checking box for users.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 7
diff changeset
33
9
584b1623e9ef TOC correction list page updated
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 8
diff changeset
34 function UpdateTOCcomments($id, $notes) {
584b1623e9ef TOC correction list page updated
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 8
diff changeset
35 $query = "UPDATE books SET comments='".$notes."' WHERE id='".$id."'";
584b1623e9ef TOC correction list page updated
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 8
diff changeset
36
584b1623e9ef TOC correction list page updated
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 8
diff changeset
37 $result = mysql_query($query);
584b1623e9ef TOC correction list page updated
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 8
diff changeset
38 if (!$result){
584b1623e9ef TOC correction list page updated
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 8
diff changeset
39 echo mysql_error();
584b1623e9ef TOC correction list page updated
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 8
diff changeset
40 echo ("Failed during updating books table.");
584b1623e9ef TOC correction list page updated
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 8
diff changeset
41 }
584b1623e9ef TOC correction list page updated
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 8
diff changeset
42
584b1623e9ef TOC correction list page updated
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 8
diff changeset
43 }
584b1623e9ef TOC correction list page updated
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 8
diff changeset
44
8
da10158c6d0a add toc_correction status in books table. On TOC correction list page, providing the status checking box for users.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 7
diff changeset
45 function UpdateTOCstatus($id, $status) {
da10158c6d0a add toc_correction status in books table. On TOC correction list page, providing the status checking box for users.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 7
diff changeset
46
da10158c6d0a add toc_correction status in books table. On TOC correction list page, providing the status checking box for users.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 7
diff changeset
47 $query = "UPDATE books SET toc_correction='".$status."' WHERE id='".$id."'";
da10158c6d0a add toc_correction status in books table. On TOC correction list page, providing the status checking box for users.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 7
diff changeset
48
da10158c6d0a add toc_correction status in books table. On TOC correction list page, providing the status checking box for users.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 7
diff changeset
49 $result = mysql_query($query);
da10158c6d0a add toc_correction status in books table. On TOC correction list page, providing the status checking box for users.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 7
diff changeset
50 if (!$result){
da10158c6d0a add toc_correction status in books table. On TOC correction list page, providing the status checking box for users.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 7
diff changeset
51 echo mysql_error();
da10158c6d0a add toc_correction status in books table. On TOC correction list page, providing the status checking box for users.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 7
diff changeset
52 echo ("Failed during updating books table.");
da10158c6d0a add toc_correction status in books table. On TOC correction list page, providing the status checking box for users.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 7
diff changeset
53 }
da10158c6d0a add toc_correction status in books table. On TOC correction list page, providing the status checking box for users.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 7
diff changeset
54
da10158c6d0a add toc_correction status in books table. On TOC correction list page, providing the status checking box for users.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 7
diff changeset
55 }
da10158c6d0a add toc_correction status in books table. On TOC correction list page, providing the status checking box for users.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 7
diff changeset
56
0
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
57 function checkSections($count){
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
58
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
59 /* $query="SELECT books.name AS book_name, books.level1, books.level2, books.period, books.id, sections.name, start_page, end_page, COUNT( * ) AS count
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
60 FROM sections
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
61 JOIN books ON sections.books_id = books.id
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
62 WHERE NOT EXISTS
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
63 (SELECT 1 FROM sections_versions WHERE books_id=sections.books_id)
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
64 GROUP BY books_id, start_page, end_page
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
65 HAVING COUNT( * ) >=".$count."
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
66 ORDER BY COUNT( * ) DESC ";*/
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
67 $query="(SELECT books.name AS book_name, books.level1, books.level2, books.period, books.id, sections.name, start_page, end_page, COUNT( * ) AS count
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
68 FROM sections
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
69 JOIN books ON sections.books_id = books.id
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
70 WHERE NOT EXISTS
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
71 (SELECT 1 FROM sections_versions WHERE books_id=sections.books_id)
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
72 GROUP BY books_id, start_page, end_page
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
73 HAVING COUNT( * ) >=".$count.")
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
74 UNION
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
75 (SELECT books.name AS book_name, books.level1, books.level2, books.period, books.id, sections_revisions.name, start_page, end_page, COUNT( * ) AS count
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
76 FROM sections_revisions
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
77 JOIN books ON sections_revisions.books_id = books.id
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
78 JOIN (
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
79 SELECT sections_versions.id
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
80 FROM sections_versions WHERE sections_versions.version=(SELECT MAX(version) FROM sections_versions)
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
81 GROUP BY books_id
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
82 ) AS t ON t.id=sections_revisions.versions_id
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
83 WHERE deleted=0
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
84 GROUP BY books_id, versions_id,start_page, end_page
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
85 HAVING COUNT( * ) >=".$count.")
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
86 ORDER BY count DESC ";
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
87 $result = mysql_query($query);
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
88 echo mysql_num_rows($result)." result(s)<br><br>";
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
89 echo "<table>";
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
90 echo "<tr>";
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
91 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";
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
92 while ($row = mysql_fetch_assoc($result)) {
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
93 $str="<tr>";
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
94 $str.="<td>".$row['book_name'];
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
95 $str.="<td>".$row['level1'];
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
96 $str.="<td>".$row['level2'];
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
97 $str.="<td>".$row['period'];
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
98 $str.="<td><a href='tagging_text.php?id=".$row['id']."' target='_blank'>".$row['name']."</a>";
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
99 $str.="<td>p".$row['start_page']."-".$row['end_page'];
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
100 $str.="<td><a href='check_sections_details.php?book_id=".$row['id']."&count=".$count."' target='_blank'>".$row['count']."</a>";
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
101 echo $str;
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
102 }
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
103 echo "</table>";
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
104 }
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
105
1
ef6d0c6a13d7 (1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 0
diff changeset
106
ef6d0c6a13d7 (1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 0
diff changeset
107 // sorting by the $sort_by parameter
ef6d0c6a13d7 (1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 0
diff changeset
108 function checkSections_sort_by($sort_by){
ef6d0c6a13d7 (1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 0
diff changeset
109 switch ($sort_by) {
8
da10158c6d0a add toc_correction status in books table. On TOC correction list page, providing the status checking box for users.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 7
diff changeset
110 case 'time':
9
584b1623e9ef TOC correction list page updated
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 8
diff changeset
111 $query="(SELECT name AS book_name,level1,level2,period,dynasty,start_year,id, toc_correction, comments from books ORDER BY start_year)";
1
ef6d0c6a13d7 (1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 0
diff changeset
112 $result = mysql_query($query);
7
0e9a7c69f22c add editing records/log into TOC correction list page, more editing records could be shown on the TOC page
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 4
diff changeset
113 if (!$result){
0e9a7c69f22c add editing records/log into TOC correction list page, more editing records could be shown on the TOC page
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 4
diff changeset
114 echo ("Failed during selecting books table.");
0e9a7c69f22c add editing records/log into TOC correction list page, more editing records could be shown on the TOC page
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 4
diff changeset
115 }
0e9a7c69f22c add editing records/log into TOC correction list page, more editing records could be shown on the TOC page
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 4
diff changeset
116
8
da10158c6d0a add toc_correction status in books table. On TOC correction list page, providing the status checking box for users.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 7
diff changeset
117 echo mysql_num_rows($result)." result(s)<br><br>";
7
0e9a7c69f22c add editing records/log into TOC correction list page, more editing records could be shown on the TOC page
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 4
diff changeset
118
8
da10158c6d0a add toc_correction status in books table. On TOC correction list page, providing the status checking box for users.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 7
diff changeset
119 echo "<form autocomplete='off'>";
7
0e9a7c69f22c add editing records/log into TOC correction list page, more editing records could be shown on the TOC page
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 4
diff changeset
120 echo "<table>";
0e9a7c69f22c add editing records/log into TOC correction list page, more editing records could be shown on the TOC page
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 4
diff changeset
121 echo "<tr>";
9
584b1623e9ef TOC correction list page updated
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 8
diff changeset
122 echo "<td class='bookName'>book name<td class='level1'>level1<td class='level2'>level2
584b1623e9ef TOC correction list page updated
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 8
diff changeset
123 <td class='period'>period<td class='dynasty'>dynasty<td class='start_year'>start_year
584b1623e9ef TOC correction list page updated
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 8
diff changeset
124 <td class='last_editor'>last_editor<td class='level1'>edit_time
584b1623e9ef TOC correction list page updated
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 8
diff changeset
125 <td> <td> <td> Some notes for the book (optional)";
7
0e9a7c69f22c add editing records/log into TOC correction list page, more editing records could be shown on the TOC page
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 4
diff changeset
126 while ($row = mysql_fetch_assoc($result)) {
0e9a7c69f22c add editing records/log into TOC correction list page, more editing records could be shown on the TOC page
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 4
diff changeset
127 $str="<tr>";
0e9a7c69f22c add editing records/log into TOC correction list page, more editing records could be shown on the TOC page
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 4
diff changeset
128 $str.="<td>".$row['book_name'];
0e9a7c69f22c add editing records/log into TOC correction list page, more editing records could be shown on the TOC page
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 4
diff changeset
129 $str.="<td>".$row['level1'];
0e9a7c69f22c add editing records/log into TOC correction list page, more editing records could be shown on the TOC page
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 4
diff changeset
130 $str.="<td>".$row['level2'];
0e9a7c69f22c add editing records/log into TOC correction list page, more editing records could be shown on the TOC page
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 4
diff changeset
131 $str.="<td>".$row['period'];
0e9a7c69f22c add editing records/log into TOC correction list page, more editing records could be shown on the TOC page
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 4
diff changeset
132 $str.="<td>".$row['dynasty'];
0e9a7c69f22c add editing records/log into TOC correction list page, more editing records could be shown on the TOC page
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 4
diff changeset
133 $str.="<td>".$row['start_year'];
8
da10158c6d0a add toc_correction status in books table. On TOC correction list page, providing the status checking box for users.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 7
diff changeset
134 $id = $row['id'];
da10158c6d0a add toc_correction status in books table. On TOC correction list page, providing the status checking box for users.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 7
diff changeset
135
7
0e9a7c69f22c add editing records/log into TOC correction list page, more editing records could be shown on the TOC page
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 4
diff changeset
136 // query last_editor and last_edit_time
0e9a7c69f22c add editing records/log into TOC correction list page, more editing records could be shown on the TOC page
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 4
diff changeset
137 $query_editor = "(SELECT editor, date from sections_versions WHERE books_id='".$row['id']."' ORDER BY version DESC)";
0e9a7c69f22c add editing records/log into TOC correction list page, more editing records could be shown on the TOC page
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 4
diff changeset
138 $row_sections_versions = mysql_fetch_assoc(mysql_query($query_editor)); // the first one
0e9a7c69f22c add editing records/log into TOC correction list page, more editing records could be shown on the TOC page
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 4
diff changeset
139 $last_editor = $row_sections_versions['editor'];
0e9a7c69f22c add editing records/log into TOC correction list page, more editing records could be shown on the TOC page
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 4
diff changeset
140 $last_edit_time = $row_sections_versions['date'];
0e9a7c69f22c add editing records/log into TOC correction list page, more editing records could be shown on the TOC page
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 4
diff changeset
141 $str.="<td>".$last_editor;
0e9a7c69f22c add editing records/log into TOC correction list page, more editing records could be shown on the TOC page
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 4
diff changeset
142 $str.="<td>".$last_edit_time;
0e9a7c69f22c add editing records/log into TOC correction list page, more editing records could be shown on the TOC page
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 4
diff changeset
143
0e9a7c69f22c add editing records/log into TOC correction list page, more editing records could be shown on the TOC page
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 4
diff changeset
144 $str.="<td><a href='check_sections_details.php?book_id=".$row['id']."&count=100"."' target='_blank'>"."click here"."</a>";
8
da10158c6d0a add toc_correction status in books table. On TOC correction list page, providing the status checking box for users.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 7
diff changeset
145
da10158c6d0a add toc_correction status in books table. On TOC correction list page, providing the status checking box for users.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 7
diff changeset
146 //$str.="<td> <input type='radio' name='books'".$row['id']." value='no'/> NotFinished";
da10158c6d0a add toc_correction status in books table. On TOC correction list page, providing the status checking box for users.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 7
diff changeset
147 switch ($row['toc_correction']) {
da10158c6d0a add toc_correction status in books table. On TOC correction list page, providing the status checking box for users.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 7
diff changeset
148 case '0':
9
584b1623e9ef TOC correction list page updated
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 8
diff changeset
149 $str.="<td> <input type='checkbox' name='".$id."' onchange='toc_status(this)' /> Finished";
8
da10158c6d0a add toc_correction status in books table. On TOC correction list page, providing the status checking box for users.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 7
diff changeset
150 break;
da10158c6d0a add toc_correction status in books table. On TOC correction list page, providing the status checking box for users.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 7
diff changeset
151 case '1':
9
584b1623e9ef TOC correction list page updated
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 8
diff changeset
152 $str.="<td> <input type='checkbox' name='".$id."' onchange='toc_status(this)' checked='true' /> Finished";
8
da10158c6d0a add toc_correction status in books table. On TOC correction list page, providing the status checking box for users.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 7
diff changeset
153 break;
da10158c6d0a add toc_correction status in books table. On TOC correction list page, providing the status checking box for users.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 7
diff changeset
154 default:
da10158c6d0a add toc_correction status in books table. On TOC correction list page, providing the status checking box for users.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 7
diff changeset
155 break;
da10158c6d0a add toc_correction status in books table. On TOC correction list page, providing the status checking box for users.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 7
diff changeset
156 }
9
584b1623e9ef TOC correction list page updated
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 8
diff changeset
157 // comments for book
584b1623e9ef TOC correction list page updated
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 8
diff changeset
158 $comments = $row['comments'];
584b1623e9ef TOC correction list page updated
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 8
diff changeset
159 if ($comments != "") {
584b1623e9ef TOC correction list page updated
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 8
diff changeset
160 $str.="<td> <textarea rows='1' cols='30' name='".$id."' maxlength='100' onchange='toc_comments(this)'>".$comments."</textarea>";
584b1623e9ef TOC correction list page updated
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 8
diff changeset
161 } else {
584b1623e9ef TOC correction list page updated
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 8
diff changeset
162 $str.="<td> <textarea rows='1' cols='30' name='".$id."' maxlength='100' onchange='toc_comments(this)'></textarea>";
584b1623e9ef TOC correction list page updated
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 8
diff changeset
163 }
7
0e9a7c69f22c add editing records/log into TOC correction list page, more editing records could be shown on the TOC page
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 4
diff changeset
164 echo $str;
0e9a7c69f22c add editing records/log into TOC correction list page, more editing records could be shown on the TOC page
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 4
diff changeset
165 }
0e9a7c69f22c add editing records/log into TOC correction list page, more editing records could be shown on the TOC page
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 4
diff changeset
166 echo "</table>";
8
da10158c6d0a add toc_correction status in books table. On TOC correction list page, providing the status checking box for users.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 7
diff changeset
167 echo "</form>";
7
0e9a7c69f22c add editing records/log into TOC correction list page, more editing records could be shown on the TOC page
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 4
diff changeset
168 break;
0e9a7c69f22c add editing records/log into TOC correction list page, more editing records could be shown on the TOC page
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 4
diff changeset
169
1
ef6d0c6a13d7 (1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 0
diff changeset
170 default:
ef6d0c6a13d7 (1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 0
diff changeset
171 # code...
ef6d0c6a13d7 (1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 0
diff changeset
172 echo "no sorting parameter set";
ef6d0c6a13d7 (1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 0
diff changeset
173 break;
ef6d0c6a13d7 (1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 0
diff changeset
174 }
ef6d0c6a13d7 (1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 0
diff changeset
175 }
ef6d0c6a13d7 (1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 0
diff changeset
176
7
0e9a7c69f22c add editing records/log into TOC correction list page, more editing records could be shown on the TOC page
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 4
diff changeset
177
0
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
178 ?>
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
179
1
ef6d0c6a13d7 (1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 0
diff changeset
180
ef6d0c6a13d7 (1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 0
diff changeset
181
0
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
182 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
183 <html>
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
184 <head>
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
185 <meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
186 <link href="css/search.css" type="text/css" rel="stylesheet"/>
4
883ad980a43b add dynasty column to table books
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 1
diff changeset
187 <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.6.2/jquery.min.js" type="text/javascript"></script>
0
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
188 <!--<script src="js/check_sections.js" charset="utf-8"></script>!-->
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
189 </head>
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
190 <body>
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
191 <form action='check_sections.php' method='GET'>
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
192 find sections overlapping more than <input type="text" name="count"> other sections
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
193 <input type="submit" name="find" value="find">
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
194 </form>
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
195 <br>
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
196 <div id="search_result">
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
197 <?php
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
198 if(isset($_GET['find']) && $_GET['count']!='' && is_numeric($_GET['count'])){
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
199 checkSections($_GET['count']);
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
200 }
1
ef6d0c6a13d7 (1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 0
diff changeset
201 else if(isset($_GET['sort_by'])){
ef6d0c6a13d7 (1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 0
diff changeset
202 checkSections_sort_by($_GET['sort_by']);
ef6d0c6a13d7 (1)Add 'sort_by' time entry in main page. (check_sections.php)
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 0
diff changeset
203 }
0
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
204 ?>
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
205 </div>
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
206 </body>
8
da10158c6d0a add toc_correction status in books table. On TOC correction list page, providing the status checking box for users.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 7
diff changeset
207
da10158c6d0a add toc_correction status in books table. On TOC correction list page, providing the status checking box for users.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 7
diff changeset
208
da10158c6d0a add toc_correction status in books table. On TOC correction list page, providing the status checking box for users.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 7
diff changeset
209 <script type="text/javascript">
9
584b1623e9ef TOC correction list page updated
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 8
diff changeset
210
8
da10158c6d0a add toc_correction status in books table. On TOC correction list page, providing the status checking box for users.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 7
diff changeset
211 function toc_status(t) {
da10158c6d0a add toc_correction status in books table. On TOC correction list page, providing the status checking box for users.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 7
diff changeset
212 var id = t.name;
9
584b1623e9ef TOC correction list page updated
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 8
diff changeset
213 var val;
584b1623e9ef TOC correction list page updated
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 8
diff changeset
214
584b1623e9ef TOC correction list page updated
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 8
diff changeset
215 if (t.checked) {
584b1623e9ef TOC correction list page updated
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 8
diff changeset
216 val = '1';
584b1623e9ef TOC correction list page updated
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 8
diff changeset
217 } else {
584b1623e9ef TOC correction list page updated
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 8
diff changeset
218 val = '0';
584b1623e9ef TOC correction list page updated
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 8
diff changeset
219 }
8
da10158c6d0a add toc_correction status in books table. On TOC correction list page, providing the status checking box for users.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 7
diff changeset
220
9
584b1623e9ef TOC correction list page updated
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 8
diff changeset
221 $.ajax({
584b1623e9ef TOC correction list page updated
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 8
diff changeset
222 url : './check_sections.php',
584b1623e9ef TOC correction list page updated
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 8
diff changeset
223 async : false,
584b1623e9ef TOC correction list page updated
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 8
diff changeset
224 type : 'POST',
584b1623e9ef TOC correction list page updated
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 8
diff changeset
225 data : 'func=UpdateTOCstatus'+'&id='+id+'&status='+val,
584b1623e9ef TOC correction list page updated
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 8
diff changeset
226 complete: function(){
584b1623e9ef TOC correction list page updated
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 8
diff changeset
227 switch (val){
584b1623e9ef TOC correction list page updated
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 8
diff changeset
228 case '0':
584b1623e9ef TOC correction list page updated
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 8
diff changeset
229 alert('You update the status of book to "Not Finished"!');
584b1623e9ef TOC correction list page updated
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 8
diff changeset
230 break;
584b1623e9ef TOC correction list page updated
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 8
diff changeset
231 case '1':
584b1623e9ef TOC correction list page updated
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 8
diff changeset
232 alert('You update the status of book to "Finished"!');
584b1623e9ef TOC correction list page updated
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 8
diff changeset
233 break;
584b1623e9ef TOC correction list page updated
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 8
diff changeset
234 }
584b1623e9ef TOC correction list page updated
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 8
diff changeset
235
584b1623e9ef TOC correction list page updated
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 8
diff changeset
236 },
584b1623e9ef TOC correction list page updated
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 8
diff changeset
237 error:function() {
584b1623e9ef TOC correction list page updated
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 8
diff changeset
238 console.log("error to update toc status");
584b1623e9ef TOC correction list page updated
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 8
diff changeset
239 alert('You have NOT updated the status of book. If this issue remains, please contact us. Thanks.');
584b1623e9ef TOC correction list page updated
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 8
diff changeset
240 }
584b1623e9ef TOC correction list page updated
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 8
diff changeset
241 });
8
da10158c6d0a add toc_correction status in books table. On TOC correction list page, providing the status checking box for users.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 7
diff changeset
242
9
584b1623e9ef TOC correction list page updated
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 8
diff changeset
243 }
584b1623e9ef TOC correction list page updated
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 8
diff changeset
244
584b1623e9ef TOC correction list page updated
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 8
diff changeset
245 function toc_comments(t) {
584b1623e9ef TOC correction list page updated
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 8
diff changeset
246 console.log(t.value);
584b1623e9ef TOC correction list page updated
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 8
diff changeset
247 var text = t.value;
584b1623e9ef TOC correction list page updated
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 8
diff changeset
248 var id = t.name;
8
da10158c6d0a add toc_correction status in books table. On TOC correction list page, providing the status checking box for users.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 7
diff changeset
249
9
584b1623e9ef TOC correction list page updated
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 8
diff changeset
250 $.ajax({
584b1623e9ef TOC correction list page updated
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 8
diff changeset
251 url: './check_sections.php',
584b1623e9ef TOC correction list page updated
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 8
diff changeset
252 async : false,
584b1623e9ef TOC correction list page updated
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 8
diff changeset
253 type: 'POST',
584b1623e9ef TOC correction list page updated
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 8
diff changeset
254 data: 'func=UpdateTOCcomments'+'&id='+id+'&notes='+text,
584b1623e9ef TOC correction list page updated
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 8
diff changeset
255 complete: function(){
584b1623e9ef TOC correction list page updated
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 8
diff changeset
256 console.log('You update the comments of book!');
584b1623e9ef TOC correction list page updated
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 8
diff changeset
257 },
584b1623e9ef TOC correction list page updated
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 8
diff changeset
258 error:function() {
584b1623e9ef TOC correction list page updated
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 8
diff changeset
259 console.log("error to update toc comments");
584b1623e9ef TOC correction list page updated
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 8
diff changeset
260 alert('You have NOT updated the status of book. If this issue remains, please contact us. Thanks.');
584b1623e9ef TOC correction list page updated
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 8
diff changeset
261 }
584b1623e9ef TOC correction list page updated
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 8
diff changeset
262 });
8
da10158c6d0a add toc_correction status in books table. On TOC correction list page, providing the status checking box for users.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 7
diff changeset
263
da10158c6d0a add toc_correction status in books table. On TOC correction list page, providing the status checking box for users.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 7
diff changeset
264 }
da10158c6d0a add toc_correction status in books table. On TOC correction list page, providing the status checking box for users.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 7
diff changeset
265
da10158c6d0a add toc_correction status in books table. On TOC correction list page, providing the status checking box for users.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 7
diff changeset
266 </script>
da10158c6d0a add toc_correction status in books table. On TOC correction list page, providing the status checking box for users.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 7
diff changeset
267
da10158c6d0a add toc_correction status in books table. On TOC correction list page, providing the status checking box for users.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 7
diff changeset
268
da10158c6d0a add toc_correction status in books table. On TOC correction list page, providing the status checking box for users.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 7
diff changeset
269
0
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
270 </html>
b12c99b7c3f0 commit for previous development
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff changeset
271
8
da10158c6d0a add toc_correction status in books table. On TOC correction list page, providing the status checking box for users.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 7
diff changeset
272
da10158c6d0a add toc_correction status in books table. On TOC correction list page, providing the status checking box for users.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents: 7
diff changeset
273