Mercurial > hg > extraction-interface

comparison interface/check_sections.php @ 7:0e9a7c69f22c

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
add editing records/log into TOC correction list page, more editing records could be shown on the TOC page
author Zoe Hong <zhong@mpiwg-berlin.mpg.de>
date Fri, 06 Feb 2015 09:44:17 +0100
parents 883ad980a43b
children da10158c6d0a
comparison
equal deleted inserted replaced
6:63e08b98032f 7:0e9a7c69f22c
68 68
69 69
70 // sorting by the $sort_by parameter 70 // sorting by the $sort_by parameter
71 function checkSections_sort_by($sort_by){ 71 function checkSections_sort_by($sort_by){
72 switch ($sort_by) { 72 switch ($sort_by) {
73 case 'time': 73 case '_time':
74 $query="(SELECT name AS book_name,level1,level2,period,dynasty,start_year,id from books ORDER BY start_year)"; 74 $query="(SELECT name AS book_name,level1,level2,period,dynasty,start_year,id from books ORDER BY start_year)";
75 $result = mysql_query($query); 75 $result = mysql_query($query);
76 if (!$result){
77 echo ("Failed during selecting books table.");
78 }
79
80
76 echo mysql_num_rows($result)." result(s)<br><br>"; 81 echo mysql_num_rows($result)." result(s)<br><br>";
77 echo "<table>"; 82 echo "<table>";
78 echo "<tr>"; 83 echo "<tr>";
79 echo "<td class='bookName'>book name<td class='level1'>level1<td class='level2'>level2<td class='period'>period<td class='dynasty'>dynasty<td class='start_year'>start_year"; 84 echo "<td class='bookName'>book name<td class='level1'>level1<td class='level2'>level2<td class='period'>period<td class='dynasty'>dynasty<td class='start_year'>start_year";
80 while ($row = mysql_fetch_assoc($result)) { 85 while ($row = mysql_fetch_assoc($result)) {
89 echo $str; 94 echo $str;
90 } 95 }
91 echo "</table>"; 96 echo "</table>";
92 break; 97 break;
93 98
99 case 'time':
100 $query="(SELECT name AS book_name,level1,level2,period,dynasty,start_year,id from books ORDER BY start_year)";
101 $result = mysql_query($query);
102 if (!$result){
103 echo ("Failed during selecting books table.");
104 }
105
106
107 echo mysql_num_rows($result)." result(s)<br><br>";
108 echo "<table>";
109 echo "<tr>";
110 echo "<td class='bookName'>book name<td class='level1'>level1<td class='level2'>level2 <td class='period'>period<td class='dynasty'>dynasty<td class='start_year'>start_year<td class='last_editor'>last_editor<td class='edit_time'>edit_time";
111 while ($row = mysql_fetch_assoc($result)) {
112 $str="<tr>";
113 $str.="<td>".$row['book_name'];
114 $str.="<td>".$row['level1'];
115 $str.="<td>".$row['level2'];
116 $str.="<td>".$row['period'];
117 $str.="<td>".$row['dynasty'];
118 $str.="<td>".$row['start_year'];
119
120 // query last_editor and last_edit_time
121 $query_editor = "(SELECT editor, date from sections_versions WHERE books_id='".$row['id']."' ORDER BY version DESC)";
122 $row_sections_versions = mysql_fetch_assoc(mysql_query($query_editor)); // the first one
123 $last_editor = $row_sections_versions['editor'];
124 $last_edit_time = $row_sections_versions['date'];
125 $str.="<td>".$last_editor;
126 $str.="<td>".$last_edit_time;
127
128 $str.="<td><a href='check_sections_details.php?book_id=".$row['id']."&count=100"."' target='_blank'>"."click here"."</a>";
129 echo $str;
130 }
131 echo "</table>";
132 break;
133
94 default: 134 default:
95 # code... 135 # code...
96 echo "no sorting parameter set"; 136 echo "no sorting parameter set";
97 break; 137 break;
98 } 138 }
99 } 139 }
140
100 141
101 ?> 142 ?>
102 143
103 144
104 145