extraction-interface: develop/models/extractapp.php annotate

annotate develop/models/extractapp.php @ 9:584b1623e9ef

TOC correction list page updated

author	Zoe Hong <zhong@mpiwg-berlin.mpg.de>
date	Mon, 09 Feb 2015 18:59:24 +0100
parents	63e08b98032f
children	54a235d43694

rev	line source
6 63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	2
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	3 <?php
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	4
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	5 class ExtractappModel extends BaseModel{
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	6
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	7 public function Index() {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	8 return array("Index Value 1", "Value 2", "Value 3");
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	9 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	10
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	11 protected $section_id, $data_path;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	12
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	13
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	14 private function Initialize($_urlvalues) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	15 $this->SetSectionId($_urlvalues);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	16 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	17
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	18 // === for tagging ===
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	19 public function StartTagging($urlvalues) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	20
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	21 $this->Initialize($urlvalues);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	22
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	23 $section_id = $this->GetSectionId();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	24
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	25 $stringInput = $this->GetSectionContent();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	26
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	27 $taglistArray = $this->GetTaglistArray();
9 584b1623e9ef TOC correction list page updated Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	28 // test for GetTaglistByTopicID:
584b1623e9ef TOC correction list page updated Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	29 // $taglistArray = $this->GetTaglistByTopicID(1);
584b1623e9ef TOC correction list page updated Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	30
6 63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	31
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	32 $wordlistArray = $this->GetWordlistArray();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	33
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	34 $data = array();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	35 $data['stringInput'] = $stringInput;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	36 $data['taglistArray'] = $taglistArray;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	37 $data['wordlistArray'] = $wordlistArray;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	38 $data['section_id'] = $section_id;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	39
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	40
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	41 return $data;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	42
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	43 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	44
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	45 public function SaveFullText($postdata) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	46 if ($postdata['text']){
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	47 $date = date('Y_m_d_H_i_s', time());
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	48 if ( file_exists("data/parsing_files/".$postdata['filename'].".txt") ) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	49 $oldFile = file_get_contents("data/parsing_files/".$postdata['filename'].".txt");
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	50 file_put_contents("data/parsing_files/".$postdata['filename']."_".$date.".txt", $oldFile);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	51 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	52
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	53 if (get_magic_quotes_gpc()) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	54 $require = stripslashes($postdata['text']);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	55 } else {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	56 $require = $postdata['text'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	57 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	58
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	59 $require = preg_replace("/【<a(.?)>(.?)<\/a>】/u", "【\\2】", $require);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	60 $require = preg_replace('/&/u', "&", $require);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	61 $require = preg_replace("/○/u", " ", $require);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	62 $require = preg_replace("/<br>/u", "\n", $require);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	63 $require = preg_replace("/<br>/u", "\n", $require);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	64 file_put_contents("data/parsing_files/".$postdata['filename'].".txt", $require);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	65 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	66
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	67 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	68
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	69
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	70
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	71 // === for export table ===
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	72 public function ExportTable($urlvalues, $postdata) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	73 $this->Initialize($urlvalues);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	74 $content = $postdata['content'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	75
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	76
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	77 // outputTableArray:
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	78 $section_id = $this->GetSectionId();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	79
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	80 $section_info = $this->GetSectionInfo();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	81
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	82 $sectionName = $section_info['sectionName'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	83 $bookId = $section_info['bookId'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	84
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	85 $books_info = $this->GetBooksInfo($bookId);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	86 $bookName = $books_info['bookName'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	87
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	88 $outputTableArray = array();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	89
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	90 $taglistArray = $this->GetTaglistArray();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	91
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	92 $outputTableArray[0]=array();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	93 $outputTableArray[0][0]=array();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	94 $outputTableArray[0][1]=array();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	95 foreach ( $taglistArray as $value ) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	96 $outputTableArray[0][0][$value[2]] = $value[1];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	97 $outputTableArray[0][1][$value[2]] = $value[1]."(Title)";
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	98 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	99 $outputTableArray[0]["other"] = "其他";
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	100 $outputTableArray[0]["page"] = "頁數";
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	101 $outputTableArray[0]["full"] = "全文";
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	102
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	103 foreach ( $taglistArray as $tagValue ) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	104 $content = preg_replace("/<\/".$tagValue[2].">○*<".$tagValue[2].">/u", "", $content);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	105 $content = preg_replace("/<".$tagValue[2].">[ ]*<\/".$tagValue[2].">/u", "", $content);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	106 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	107
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	108 $contentLineArray = explode( "<br>", $content );
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	109
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	110 $count=0;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	111 $pageNow=NULL;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	112 foreach ( $contentLineArray as $value ) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	113 $count++;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	114 $recordString = $value;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	115 $otherString = $recordString;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	116 //echo $recordString."<br>\n";
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	117 if ( preg_match("/【<a(.?)>(.?)<\/a>】/u", $recordString, $matches) ) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	118 $pageNow = $matches[2];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	119 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	120 foreach ( $taglistArray as $tagValue ) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	121 if ( preg_match_all("/<".$tagValue[2].">(.*?)<\/".$tagValue[2].">/u", $recordString, $matches, PREG_SET_ORDER) ) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	122 foreach ( $matches as $matchesValue ) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	123 $matchesValue[1] = preg_replace("/○/u", "", $matchesValue[1]);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	124 if ( preg_match_all("/〈(.*?)〉/u", $matchesValue[1], $matches2, PREG_SET_ORDER) ) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	125 foreach ( $matches2 as $matches2Value ) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	126 if ( isset($outputTableArray[$count][0][$tagValue[2]]) ) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	127 $outputTableArray[$count][0][$tagValue[2]] .= ";".$matches2Value[1];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	128 } else {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	129 $outputTableArray[$count][0][$tagValue[2]] = $matches2Value[1];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	130 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	131 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	132 } else {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	133 if ( isset($outputTableArray[$count][0][$tagValue[2]]) ) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	134 $outputTableArray[$count][0][$tagValue[2]] .= ";".$matchesValue[1];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	135 } else {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	136 $outputTableArray[$count][0][$tagValue[2]] = $matchesValue[1];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	137 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	138 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	139 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	140 $otherString = preg_replace("/<".$tagValue[2].">(.*?)<\/".$tagValue[2].">/u", "　", $otherString);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	141 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	142 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	143 $otherString = preg_replace("/○/u", "", $otherString);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	144 $outputTableArray[$count]["other"] = $otherString;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	145 $outputTableArray[$count]["page"] = $pageNow;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	146 $value = preg_replace("/>/u", ">", $value);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	147 $value = preg_replace("/</u", "<", $value);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	148 $outputTableArray[$count]["full"] = $value;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	149 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	150
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	151 foreach ( $outputTableArray as $arrayIndex => $arrayValue ) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	152 if ( !isset($arrayValue[0]["person"]) ) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	153 unset($outputTableArray[$arrayIndex]);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	154 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	155 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	156
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	157
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	158 $data = array();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	159
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	160 $data['outputTableArray'] = $outputTableArray;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	161 $data['bookId'] = $bookId;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	162 $data['section_id'] = $section_id;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	163 $data['bookName'] = $bookName;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	164 $data['sectionName'] = $sectionName;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	165
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	166 return $data;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	167
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	168 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	169
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	170 // === for manage tag list ===
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	171 public function EditTaglist($urlvalues) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	172 $this->Initialize($urlvalues);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	173 $result = $this->GetTaglist();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	174 $taglistArray = array();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	175 while ($row = mysql_fetch_assoc($result)) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	176 $taglistArray[$row['id']] = array($row['name'], $row['tag'], $row['color']);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	177 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	178
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	179 $data = array();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	180 $data['taglistArray'] = $taglistArray;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	181 return $data;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	182
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	183 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	184
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	185 private function _GetTag($_postdata) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	186 if (get_magic_quotes_gpc()) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	187 $id = stripslashes($_postdata['id']);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	188 $name = stripslashes($_postdata['name']);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	189 $tag = stripslashes($_postdata['tag']);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	190 $color = stripslashes($_postdata['color']);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	191 } else {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	192 $id = $_postdata['id'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	193 $name = $_postdata['name'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	194 $tag = $_postdata['tag'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	195 $color = $_postdata['color'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	196 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	197 return array($id, $name, $tag, $color);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	198 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	199
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	200 public function NewTagElement($postdata) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	201 if ($postdata['id']){
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	202 list($id, $name, $tag, $color) = $this->_GetTag($postdata);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	203
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	204 $query1 = sprintf("INSERT INTO `taglist` (`id`, `name`, `tag`, `color`, `systemName`) VALUES (%s, %s, %s, %s, %s)",
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	205 $this->GetSQLValueString($id, "int"),
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	206 $this->GetSQLValueString($name, "text"),
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	207 $this->GetSQLValueString($tag, "text"),
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	208 $this->GetSQLValueString($color, "text"),
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	209 $this->GetSQLValueString($this->systemNAME, "text"));
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	210 $result1 = mysql_query($query1);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	211 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	212
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	213 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	214
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	215 public function SaveTagElement($postdata) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	216 if ($postdata['id']){
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	217 list($id, $name, $tag, $color) = $this->_GetTag($postdata);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	218
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	219 $queryInsert = sprintf("UPDATE taglist SET `name`=%s, `tag`=%s, `color`=%s WHERE `id`=%s",
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	220 $this->GetSQLValueString($name, "text"),
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	221 $this->GetSQLValueString($tag, "text"),
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	222 $this->GetSQLValueString($color, "text"),
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	223 $this->GetSQLValueString($id, "int"));
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	224 $resultInsert = mysql_query($queryInsert);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	225
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	226 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	227
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	228 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	229
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	230 public function DeleteTag($postdata) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	231 if ($postdata['id']) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	232 $queryInsert = sprintf("DELETE FROM `taglist` WHERE `id` = %s", stripslashes($postdata['id']));
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	233 $resultInsert = mysql_query($queryInsert);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	234 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	235
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	236 }
9 584b1623e9ef TOC correction list page updated Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	237
584b1623e9ef TOC correction list page updated Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	238
584b1623e9ef TOC correction list page updated Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	239 // TODO: get taglist by choosen topic
584b1623e9ef TOC correction list page updated Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	240 private function GetTaglistByTopicID($topic_id) {
584b1623e9ef TOC correction list page updated Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	241 $taglistArray = "";
584b1623e9ef TOC correction list page updated Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	242
584b1623e9ef TOC correction list page updated Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	243 $query = "SELECT * FROM topic_tag_relation WHERE topic_id=".$topic_id;
584b1623e9ef TOC correction list page updated Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	244 $result = mysql_query($query);
584b1623e9ef TOC correction list page updated Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	245 if (!$result) {
584b1623e9ef TOC correction list page updated Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	246 return json_encode("Failed during selecting topics table.");
584b1623e9ef TOC correction list page updated Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	247 }
584b1623e9ef TOC correction list page updated Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	248
584b1623e9ef TOC correction list page updated Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	249 while ($row = mysql_fetch_assoc($result)) {
584b1623e9ef TOC correction list page updated Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	250 $tag_id = $row['tag_id'];
584b1623e9ef TOC correction list page updated Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	251 $query = "SELECT * FROM taglist WHERE id=".$tag_id;
584b1623e9ef TOC correction list page updated Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	252 $tag_result = mysql_query($query);
584b1623e9ef TOC correction list page updated Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	253 if ($tag_result) {
584b1623e9ef TOC correction list page updated Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	254 return json_encode("Failed during selecting taglist table.");
584b1623e9ef TOC correction list page updated Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	255 }
584b1623e9ef TOC correction list page updated Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	256 $row = mysql_fetch_assoc($tag_result));
584b1623e9ef TOC correction list page updated Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	257 $taglistArray[] = array( $row['id'], $row['name'], $row['tag'], $row['color'] );
584b1623e9ef TOC correction list page updated Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	258 // array_push($taglistArray, array( $row['id'], $row['name'], $row['tag'], $row['color'] ));
584b1623e9ef TOC correction list page updated Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	259 }
584b1623e9ef TOC correction list page updated Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	260
584b1623e9ef TOC correction list page updated Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	261
584b1623e9ef TOC correction list page updated Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	262 return $taglistArray;
584b1623e9ef TOC correction list page updated Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	263
584b1623e9ef TOC correction list page updated Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	264
584b1623e9ef TOC correction list page updated Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	265
584b1623e9ef TOC correction list page updated Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	266
584b1623e9ef TOC correction list page updated Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	267
584b1623e9ef TOC correction list page updated Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	268 }
6 63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	269 // ===========================
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	270
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	271 // === for manage wordlist ===
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	272 public function EditWordlist($urlvalues) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	273 $this->Initialize($urlvalues);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	274 $result = $this->GetWordlist();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	275 $wordlistArray = array();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	276 while ($row = mysql_fetch_assoc($result)) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	277 $wordlistArray[$row['id']] = $row['name'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	278 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	279
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	280 $data = array();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	281 $data['wordlistArray'] = $wordlistArray;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	282 return $data;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	283 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	284
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	285
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	286 public function AddNewList($postdata) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	287 if ($postdata['text']){
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	288 if (get_magic_quotes_gpc()) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	289 $name = stripslashes($postdata['text']);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	290 } else {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	291 $name = $postdata['text'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	292 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	293
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	294 $query1 = sprintf("INSERT INTO `wordlist` (`name`, `systemName`) VALUES (%s, %s)",
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	295 $this->GetSQLValueString($name, "text"),
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	296 $this->GetSQLValueString($this->systemNAME, "text"));
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	297 $result1 = mysql_query($query1);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	298 file_put_contents( "data/wordlist/".mysql_insert_id().".txt", "(empty now)");
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	299 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	300 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	301
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	302
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	303 public function SaveWordlist($postdata) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	304
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	305 if ($postdata['text']){
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	306 $date = date('Y_m_d_H_i_s', time());
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	307 if ( file_exists("data/wordlist/".$postdata['filename'].".txt") ) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	308 $filename = "data/wordlist/".$postdata['filename']."_".$date.".txt";
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	309 $oldFile = file_get_contents("data/wordlist/".$postdata['filename'].".txt");
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	310 file_put_contents($filename, $oldFile);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	311 } else {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	312 $filename = "data/wordlist/".$postdata['filename'].".txt";
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	313 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	314
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	315
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	316 if (get_magic_quotes_gpc()) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	317 $require = stripslashes($postdata['text']);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	318 } else {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	319 $require = $postdata['text'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	320 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	321
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	322 $require = preg_replace("/<br>/u", "<br>", $require);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	323 file_put_contents($filename, $require);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	324 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	325 /*
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	326 if ($postdata['text']){
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	327 $date = date('Y_m_d_H_i_s', time());
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	328 if ( file_exists("data/wordlist/".$postdata['filename'].".txt") ) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	329 $oldFile = file_get_contents("data/wordlist/".$postdata['filename'].".txt");
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	330 file_put_contents("data/wordlist/".$postdata['filename']."_".$date.".txt", $oldFile);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	331 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	332
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	333 if (get_magic_quotes_gpc()) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	334 $require = stripslashes($postdata['text']);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	335 } else {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	336 $require = $postdata['text'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	337 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	338
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	339 // $require = preg_replace("/<br>/u", "", $require);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	340 file_put_contents("data/wordlist/".$postdata['filename'].".txt", $require);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	341 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	342 */
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	343 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	344
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	345
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	346 // =======================================
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	347
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	348 public function sortFunction($a,$b) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	349 return strlen($b)-strlen($a);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	350 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	351
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	352
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	353 private function SetSectionId($_urlvalues) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	354 // TODO: maybe get user info also
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	355 // get book id from url
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	356 if ($_urlvalues['id'] != "") {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	357 $section_id = $_urlvalues['id'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	358 } else {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	359 return json_encode("Error: No section id");
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	360 /* ???? */
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	361 /*
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	362 $get_book_id = $urlvalues['book'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	363 $get_start = $urlvalues['start'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	364 $get_end = $urlvalues['end'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	365 */
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	366 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	367 $this->section_id = $section_id;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	368
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	369 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	370
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	371 private function GetSectionId() {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	372 if ($this->section_id) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	373 return $this->section_id;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	374 } else {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	375 return json_encode("Error: No section id");
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	376 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	377 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	378
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	379 private function GetSectionInfo() {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	380 $section_id = $this->GetSectionId();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	381 if (!is_numeric($section_id)){
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	382 return $section_id;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	383 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	384
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	385 $result = $this->GetSectionsByID($section_id);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	386
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	387
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	388 while ($row = mysql_fetch_assoc($result)) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	389 $bookId=$row['books_id'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	390 $startPage=$row['start_page'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	391 $endPage=$row['end_page'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	392 $sectionName = $row['name'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	393 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	394
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	395 $data = array();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	396 $data['bookId'] = $bookId;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	397 $data['startPage'] = $startPage;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	398 $data['endPage'] = $endPage;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	399 $data['sectionName'] = $sectionName;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	400
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	401 return $data;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	402 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	403
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	404 private function GetSectionContent() {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	405 $section_id = $this->GetSectionId();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	406 $section_info = $this->GetSectionInfo();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	407
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	408 $bookId = $section_info['bookId'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	409 $startPage = $section_info['startPage'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	410 $endPage = $section_id['endPage'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	411
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	412
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	413 $contentString="";
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	414 $data_path = $this->GetDataPath();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	415 if ( file_exists($data_path."parsing_files/".$section_id.".txt") ) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	416 $contentString=file_get_contents($data_path."parsing_files/".$section_id.".txt");
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	417 $stringInput = $contentString;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	418 $stringInput = preg_replace("/ /u", "○", $stringInput);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	419 $stringInput = preg_replace("/\n/u", "<br>", $stringInput);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	420 $stringInput = preg_replace("/【(.*?)】/u", "【<a href=\"review_index_xml_images.php?books_id=".$bookId."&pages=\\1&entry=0\" target=\"_bookImg\">\\1</a>】", $stringInput);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	421 } else {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	422 $query = sprintf("SELECT `content`, `line`, `books_id` FROM `contents` WHERE `books_id`=\"%s\" AND `line`>=%d AND `line`<=%d", $bookId, $startPage, $endPage);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	423 $result = mysql_query($query);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	424 while ($row = mysql_fetch_assoc($result)) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	425 $contentString.="【".$row['line']."】".$row['content']."\n";
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	426 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	427 $stringInput = $contentString;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	428 $stringInput = preg_replace("/<(.*?)>/u", "○", $stringInput);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	429 $stringInput = preg_replace("/ /u", "○", $stringInput);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	430 $stringInput = preg_replace("/\n/u", "<br>", $stringInput);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	431 $stringInput = preg_replace("/【(.*?)】/u", "【<a href=\"review_index_xml_images.php?books_id=".$bookId."&pages=\\1&entry=0\" target=\"_bookImg\">\\1</a>】", $stringInput);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	432 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	433
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	434 return $stringInput;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	435 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	436
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	437 private function GetDataPath() {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	438 return getcwd()."/data/"; // get the current file path, which is getcwd(), and concatenate with "/data/"
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	439 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	440
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	441 private function GetTaglistArray() {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	442 $taglistArray="";
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	443 $result = $this->GetTaglist();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	444 while ($row = mysql_fetch_assoc($result)) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	445 $taglistArray[] = array( $row['id'], $row['name'], $row['tag'], $row['color'] );
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	446
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	447 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	448
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	449 return $taglistArray;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	450
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	451 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	452
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	453 private function GetWordlistArray() {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	454 $wordlistArray="";
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	455 $result = $this->GetWordlist();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	456 while ($row = mysql_fetch_assoc($result)) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	457 $listString = file_get_contents("wordlist/".$row['id'].".txt");
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	458 $listString = preg_replace("/<div>/u", "\n", $listString);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	459 $listString = preg_replace("/<\/div>/u", "", $listString);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	460 $listString = preg_replace("/<span(.*?)>/u", "", $listString);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	461 $listString = preg_replace("/<\/span>/u", "", $listString);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	462 //$listString = preg_replace("/\n/u", "\|", $listString);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	463
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	464 $wordlistArray2 = explode( "\n", $listString );
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	465 usort($wordlistArray2,'sortFunction');
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	466 foreach ( $wordlistArray2 as $index=>$value ) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	467 $wordlistArray2[$index] = implode("○?", preg_split("/(?<!^)(?!$)/u", $value));
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	468 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	469 foreach ( $wordlistArray2 as $index=>$value ) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	470 if ($value=="") unset($wordlistArray2[$index]);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	471
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	472 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	473 $listString = implode("\|", $wordlistArray2);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	474
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	475 if ( $listString[0]=="\|" ) $listString = substr($listString, 1);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	476 $wordlistArray[] = array( $row['id'], $row['name'], $listString );
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	477 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	478
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	479
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	480 return $wordlistArray;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	481
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	482 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	483
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	484 protected function GetBooksInfo($bookId) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	485 $result = $this->GetSectionsByID($bookId);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	486 while ($row = mysql_fetch_assoc($result)) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	487 $bookName = $row['name'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	488 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	489
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	490 $data = array();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	491 $data['bookName'] = $bookName;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	492
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	493 return $data;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	494 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	495
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	496
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	497 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	498
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	499
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	500
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	501 ?>

Mercurial > hg > extraction-interface

annotate develop/models/extractapp.php @ 9:584b1623e9ef