Mercurial > hg > extraction-interface
diff interface/check_sections.php @ 7:0e9a7c69f22c
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 |
line wrap: on
line diff
--- a/interface/check_sections.php Thu Feb 05 16:07:53 2015 +0100 +++ b/interface/check_sections.php Fri Feb 06 09:44:17 2015 +0100 @@ -70,9 +70,14 @@ // sorting by the $sort_by parameter function checkSections_sort_by($sort_by){ switch ($sort_by) { - case 'time': + case '_time': $query="(SELECT name AS book_name,level1,level2,period,dynasty,start_year,id from books ORDER BY start_year)"; $result = mysql_query($query); + if (!$result){ + echo ("Failed during selecting books table."); + } + + echo mysql_num_rows($result)." result(s)<br><br>"; echo "<table>"; echo "<tr>"; @@ -91,6 +96,41 @@ echo "</table>"; break; + case 'time': + $query="(SELECT name AS book_name,level1,level2,period,dynasty,start_year,id from books ORDER BY start_year)"; + $result = mysql_query($query); + if (!$result){ + echo ("Failed during selecting books table."); + } + + + echo mysql_num_rows($result)." result(s)<br><br>"; + echo "<table>"; + echo "<tr>"; + 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"; + while ($row = mysql_fetch_assoc($result)) { + $str="<tr>"; + $str.="<td>".$row['book_name']; + $str.="<td>".$row['level1']; + $str.="<td>".$row['level2']; + $str.="<td>".$row['period']; + $str.="<td>".$row['dynasty']; + $str.="<td>".$row['start_year']; + + // query last_editor and last_edit_time + $query_editor = "(SELECT editor, date from sections_versions WHERE books_id='".$row['id']."' ORDER BY version DESC)"; + $row_sections_versions = mysql_fetch_assoc(mysql_query($query_editor)); // the first one + $last_editor = $row_sections_versions['editor']; + $last_edit_time = $row_sections_versions['date']; + $str.="<td>".$last_editor; + $str.="<td>".$last_edit_time; + + $str.="<td><a href='check_sections_details.php?book_id=".$row['id']."&count=100"."' target='_blank'>"."click here"."</a>"; + echo $str; + } + echo "</table>"; + break; + default: # code... echo "no sorting parameter set"; @@ -98,6 +138,7 @@ } } + ?>