extraction-interface: interface/exportTable.php annotate

annotate interface/exportTable.php @ 30:022310a26cc5 extractapp

extractapp commit

author	Zoe Hong <zhong@mpiwg-berlin.mpg.de>
date	Thu, 05 Mar 2015 15:09:46 +0100
parents	b12c99b7c3f0
children

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 header("Content-Type: text/html;charset=utf-8");
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	3
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	4 if (isset($_POST['content'])) {
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	5 $content = $_POST['content'];
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	6 }
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	7 if (isset($_POST['sectionid'])) {
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	8 $sectionid = $_POST['sectionid'];
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	9 }
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 include_once('./Lib_mb_utf8.php');
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	12 include_once('config.php');
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 set_time_limit(0);
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	15 ini_set('memory_limit', '-1');
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	16
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	17 $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	18 mysql_query("SET NAMES utf8");
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	19
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	20 if (!$link_mysql) {
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	21 die('Could not connect: ' . mysql_error());
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	22 }
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	23
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	24 $db_selected = mysql_select_db($mysql_database, $link_mysql);
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	25 if (!$db_selected) {
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	26 die ('Can\'t use foo : ' . mysql_error());
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	27 }
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	28
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	29 if (!function_exists("GetSQLValueString")) {
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	30 function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	31 {
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	32 $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	33
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	34 $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	35
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	36 switch ($theType) {
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	37 case "text":
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	38 $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	39 break;
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	40 case "long":
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	41 case "int":
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	42 $theValue = ($theValue != "") ? intval($theValue) : "NULL";
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	43 break;
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	44 case "double":
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	45 $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	46 break;
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	47 case "date":
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	48 $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	49 break;
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	50 case "defined":
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	51 $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	52 break;
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	53 }
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	54 return $theValue;
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	55 }
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	56 }
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	57
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	58 $query = sprintf("SELECT * FROM `sections` WHERE id=\"%s\"", $sectionid);
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	59 $result = mysql_query($query);
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	60 while ($row = mysql_fetch_assoc($result)) {
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	61 $sectionName = $row['name'];
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	62 $bookId = $row['books_id'];
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	63 }
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	64
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	65 $query = sprintf("SELECT * FROM `books` WHERE id=\"%s\"", $bookId);
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	66 $result = mysql_query($query);
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	67 while ($row = mysql_fetch_assoc($result)) {
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	68 $bookName = $row['name'];
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	69 }
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	70
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	71 $outputTableArray = array();
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	72
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	73 $taglistArray="";
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	74 $query = sprintf("SELECT * FROM `taglist` ORDER BY `tag` ASC");
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	75 $result = mysql_query($query);
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	76 while ($row = mysql_fetch_assoc($result)) {
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	77 $taglistArray[] = array( $row['id'], $row['name'], $row['tag'], $row['color'] );
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	78 }
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	79
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	80
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	81 $outputTableArray[0]=array();
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	82 $outputTableArray[0][0]=array();
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	83 $outputTableArray[0][1]=array();
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	84 foreach ( $taglistArray as $value ) {
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	85 $outputTableArray[0][0][$value[2]] = $value[1];
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	86 $outputTableArray[0][1][$value[2]] = $value[1]."(Title)";
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	87 }
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	88 $outputTableArray[0]["other"] = "其他";
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	89 $outputTableArray[0]["page"] = "頁數";
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	90 $outputTableArray[0]["full"] = "全文";
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	91
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	92 foreach ( $taglistArray as $tagValue ) {
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	93 $content = preg_replace("/<\/".$tagValue[2].">○*<".$tagValue[2].">/u", "", $content);
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	94 $content = preg_replace("/<".$tagValue[2].">[ ]*<\/".$tagValue[2].">/u", "", $content);
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	95 }
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	96
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	97 $contentLineArray = explode( "<br>", $content );
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	98
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	99 $count=0;
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	100 $pageNow=NULL;
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	101 foreach ( $contentLineArray as $value ) {
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	102 $count++;
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	103 $recordString = $value;
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	104 $otherString = $recordString;
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	105 //echo $recordString."<br>\n";
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	106 if ( preg_match("/【<a(.?)>(.?)<\/a>】/u", $recordString, $matches) ) {
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	107 $pageNow = $matches[2];
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	108 }
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	109 foreach ( $taglistArray as $tagValue ) {
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	110 if ( preg_match_all("/<".$tagValue[2].">(.*?)<\/".$tagValue[2].">/u", $recordString, $matches, PREG_SET_ORDER) ) {
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	111 foreach ( $matches as $matchesValue ) {
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	112 $matchesValue[1] = preg_replace("/○/u", "", $matchesValue[1]);
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	113 if ( preg_match_all("/〈(.*?)〉/u", $matchesValue[1], $matches2, PREG_SET_ORDER) ) {
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	114 foreach ( $matches2 as $matches2Value ) {
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	115 if ( isset($outputTableArray[$count][0][$tagValue[2]]) ) {
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	116 $outputTableArray[$count][0][$tagValue[2]] .= ";".$matches2Value[1];
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	117 } else {
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	118 $outputTableArray[$count][0][$tagValue[2]] = $matches2Value[1];
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	119 }
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	120 }
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	121 } else {
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	122 if ( isset($outputTableArray[$count][0][$tagValue[2]]) ) {
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	123 $outputTableArray[$count][0][$tagValue[2]] .= ";".$matchesValue[1];
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	124 } else {
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	125 $outputTableArray[$count][0][$tagValue[2]] = $matchesValue[1];
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	126 }
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	127 }
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	128 }
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	129 $otherString = preg_replace("/<".$tagValue[2].">(.*?)<\/".$tagValue[2].">/u", "　", $otherString);
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	130 }
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	131 }
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	132 $otherString = preg_replace("/○/u", "", $otherString);
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	133 $outputTableArray[$count]["other"] = $otherString;
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	134 $outputTableArray[$count]["page"] = $pageNow;
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	135 $value = preg_replace("/>/u", ">", $value);
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	136 $value = preg_replace("/</u", "<", $value);
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	137 $outputTableArray[$count]["full"] = $value;
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	138 }
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	139
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	140 foreach ( $outputTableArray as $arrayIndex => $arrayValue ) {
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	141 if ( !isset($arrayValue[0]["person"]) ) {
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	142 unset($outputTableArray[$arrayIndex]);
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	143 }
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	144 }
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	145 ?>
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	146
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	147 <html>
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	148 <head>
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	149 <title></title>
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	150 <script src="./jquery-1.10.2.min.js"></script>
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	151
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	152 </head>
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	153
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	154 <body>
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	155 <table width="100%" border="1" id="tableMain">
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	156
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	157 <?php
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	158 $count=1;
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	159 foreach ( $outputTableArray as $trIndex =>$trValue ) {
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	160 echo "<tr>";
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	161 if ( $trIndex==0 ) {
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	162 echo "<td>#</td>";
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	163 echo "<td>Book ID</td>";
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	164 echo "<td>Section ID</td>";
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	165 echo "<td>方志</td>";
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	166 echo "<td>部</td>";
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	167 } else {
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	168 echo "<td>".$count++."</td>";
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	169 echo "<td>".$bookId."</td>";
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	170 echo "<td>".$sectionid."</td>";
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	171 echo "<td>".$bookName."</td>";
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	172 echo "<td>".$sectionName."</td>";
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	173 }
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	174 if ( isset( $trValue["page"] ) ) {
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	175 echo "<td>".$trValue["page"]."</td>";
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	176 } else {
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	177 echo "<td> </td>";
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 /*
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	180 foreach ( $outputTableArray[0][1] as $index => $value ) {
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	181 if ( isset( $trValue[1][$index] ) ) {
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	182 echo "<td>".$trValue[1][$index]."</td>";
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	183 } else {
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	184 echo "<td> </td>";
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	185 }
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	186 }
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	187 */
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	188 foreach ( $outputTableArray[0][0] as $index => $value ) {
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	189 if ( $index == "time" ) {
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	190 if ( isset( $trValue[0][$index] ) ) {
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	191 echo "<td>".$trValue[0][$index]."</td>";
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	192 echo "<td>".$trValue[0][$index]."</td>";
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	193 } else {
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	194 echo "<td> </td>";
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	195 echo "<td> </td>";
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	196 }
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	197 } else {
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	198 if ( isset( $trValue[0][$index] ) ) {
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	199 echo "<td>".$trValue[0][$index]."</td>";
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	200 } else {
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	201 echo "<td> </td>";
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	202 }
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	203 }
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 if ( isset( $trValue["other"] ) ) {
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	206 echo "<td>".$trValue["other"]."</td>";
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	207 } else {
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	208 echo "<td> </td>";
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	209 }
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	210 if ( isset( $trValue["full"] ) ) {
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	211 echo "<td>".$trValue["full"]."</td>";
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	212 } else {
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	213 echo "<td> </td>";
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	214 }
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	215 echo "</tr>";
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	216 }
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	217 ?>
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	218 </table>
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	219 </body>
b12c99b7c3f0 commit for previous development Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	220 </html>

Mercurial > hg > extraction-interface

annotate interface/exportTable.php @ 30:022310a26cc5 extractapp