# HG changeset patch # User Calvin Yeh # Date 1506613530 -7200 # Node ID e6b516fa7b60a0cfd13f1587537d8893e2e9a2a9 # Parent 0ef426b5a1b996039e1730cf12833a1382a4a931 1. add new columns : book year and edition year. 2. remove duplicate column : time. diff -r 0ef426b5a1b9 -r e6b516fa7b60 views/Extractapp/ExportTable.php --- a/views/Extractapp/ExportTable.php Thu Sep 28 17:43:13 2017 +0200 +++ b/views/Extractapp/ExportTable.php Thu Sep 28 17:45:30 2017 +0200 @@ -16,9 +16,9 @@ * You should have received a copy of the GNU General Public License * along with Extraction-interface. If not, see . */ -/*! \file +/*! \file * This is the view for ExportTable. - * It shows a html table with each row as a topic object and each column as a tag/attribute. + * It shows a html table with each row as a topic object and each column as a tag/attribute. */ // --- initialize --- @@ -34,41 +34,53 @@ + + - + $trValue ) { echo ""; if ( $trIndex==0 ) { - echo ""; + echo ""; echo ""; echo ""; echo ""; echo ""; + echo ""; + echo ""; echo ""; echo ""; // longitude echo ""; // latitude echo ""; // description - + } else { - echo ""; + echo ""; echo ""; echo ""; echo ""; echo ""; + echo ""; + echo ""; + echo ""; echo ""; echo ""; echo ""; echo ""; // description for LGMap - + } if ( isset( $trValue["page"] ) ) { - echo ""; + echo ""; } else { echo ""; } @@ -82,24 +94,24 @@ } */ foreach ( $outputTableArray[0][0] as $index => $value ) { - if ( $index == "time" ) { + //if ( $index == "time" ) { + //if ( isset( $trValue[0][$index] ) ) { + // echo ""; + // echo ""; + //} else { + // echo ""; + // echo ""; + //} + //} else { if ( isset( $trValue[0][$index] ) ) { - echo ""; - echo ""; - } else { - echo ""; - echo ""; - } - } else { - if ( isset( $trValue[0][$index] ) ) { - echo ""; + echo ""; } else { echo ""; } - } + //} } - + /* remove other, full columns if ( isset( $trValue["other"] ) ) { echo ""; } else { @@ -110,7 +122,8 @@ } else { echo ""; } - + */ + echo ""; }
##Book IDSection ID方志Book YearEdition Year方志地點經度(x)緯度(y)Description".$count++."".$count++."".$bookId."".$sectionid."".$bookName."".$sectionName."".$bookMeta->book_year."".$bookMeta->edition_year."".$sectionName."".$bookMeta->place_name."".$bookMeta->x."".$bookMeta->y."".$bookName."_".$sectionName."".$trValue["page"]."".$trValue["page"]." ".$trValue[0][$index]."".$trValue[0][$index]."  ".$trValue[0][$index]."".$trValue[0][$index]."  ".$trValue[0][$index]."".$trValue[0][$index]." ".$trValue["other"]."