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

annotate develop/models/extractapp.php @ 11:3d6fba07bfbd

implemented for topic tag. tagging with topic tag (main tag) indicating each row when export to html.

author	Zoe Hong <zhong@mpiwg-berlin.mpg.de>
date	Wed, 11 Feb 2015 12:33:59 +0100
parents	54a235d43694
children	e82ca7375e93

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);
11 3d6fba07bfbd implemented for topic tag. tagging with topic tag (main tag) indicating each row when export to html. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 10 diff changeset	16
6 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
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	19 // === for tagging ===
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	20 public function StartTagging($urlvalues) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	21
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	22 $this->Initialize($urlvalues);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	23
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	24 $section_id = $this->GetSectionId();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	25
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	26 $stringInput = $this->GetSectionContent();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	27
10 54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	28 //$taglistArray = $this->GetTaglistArray();
54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	29 //for GetTaglistByTopicID:
54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	30
54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	31 $taglistArray = $this->GetTaglistByTopicID($this->GetTopic());
54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	32
54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	33 // topic list?
54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	34 $topiclistArray = $this->GetTopiclistArray();
9 584b1623e9ef TOC correction list page updated Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	35
6 63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	36
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	37 $wordlistArray = $this->GetWordlistArray();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	38
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	39 $data = array();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	40 $data['stringInput'] = $stringInput;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	41 $data['taglistArray'] = $taglistArray;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	42 $data['wordlistArray'] = $wordlistArray;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	43 $data['section_id'] = $section_id;
10 54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	44 $data['topiclistArray'] = $topiclistArray;
54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	45 $data['default_topic_id'] = $this->GetTopic();
11 3d6fba07bfbd implemented for topic tag. tagging with topic tag (main tag) indicating each row when export to html. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 10 diff changeset	46 $data['topic_tag'] = $this->GetTopicTag($this->GetTopic());
10 54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	47
6 63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	48 return $data;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	49
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	50 }
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 public function SaveFullText($postdata) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	53 if ($postdata['text']){
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	54 $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	55 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	56 $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	57 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	58 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	59
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	60 if (get_magic_quotes_gpc()) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	61 $require = stripslashes($postdata['text']);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	62 } else {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	63 $require = $postdata['text'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	64 }
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 $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	67 $require = preg_replace('/&/u', "&", $require);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	68 $require = preg_replace("/○/u", " ", $require);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	69 $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	70 $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	71 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	72 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	73
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	74 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	75
10 54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	76
6 63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	77 // === for export table ===
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	78 public function ExportTable($urlvalues, $postdata) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	79 $this->Initialize($urlvalues);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	80 $content = $postdata['content'];
11 3d6fba07bfbd implemented for topic tag. tagging with topic tag (main tag) indicating each row when export to html. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 10 diff changeset	81 $topic = $postdata['topic'];
6 63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	82
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	83 // outputTableArray:
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	84 $section_id = $this->GetSectionId();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	85
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	86 $section_info = $this->GetSectionInfo();
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 $sectionName = $section_info['sectionName'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	89 $bookId = $section_info['bookId'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	90
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	91 $books_info = $this->GetBooksInfo($bookId);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	92 $bookName = $books_info['bookName'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	93
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	94 $outputTableArray = array();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	95
11 3d6fba07bfbd implemented for topic tag. tagging with topic tag (main tag) indicating each row when export to html. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 10 diff changeset	96 //$taglistArray = $this->GetTaglistArray();
6 63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	97
11 3d6fba07bfbd implemented for topic tag. tagging with topic tag (main tag) indicating each row when export to html. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 10 diff changeset	98 $taglistArray = $this->GetTaglistByTopicID($topic);
3d6fba07bfbd implemented for topic tag. tagging with topic tag (main tag) indicating each row when export to html. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 10 diff changeset	99
6 63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	100 $outputTableArray[0]=array();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	101 $outputTableArray[0][0]=array();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	102 $outputTableArray[0][1]=array();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	103 foreach ( $taglistArray as $value ) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	104 $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	105 $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	106 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	107 $outputTableArray[0]["other"] = "其他";
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	108 $outputTableArray[0]["page"] = "頁數";
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	109 $outputTableArray[0]["full"] = "全文";
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	110
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	111 foreach ( $taglistArray as $tagValue ) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	112 $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	113 $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	114 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	115
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	116 $contentLineArray = explode( "<br>", $content );
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	117
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	118 $count=0;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	119 $pageNow=NULL;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	120 foreach ( $contentLineArray as $value ) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	121 $count++;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	122 $recordString = $value;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	123 $otherString = $recordString;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	124 //echo $recordString."<br>\n";
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	125 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	126 $pageNow = $matches[2];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	127 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	128 foreach ( $taglistArray as $tagValue ) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	129 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	130 foreach ( $matches as $matchesValue ) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	131 $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	132 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	133 foreach ( $matches2 as $matches2Value ) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	134 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	135 $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	136 } else {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	137 $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	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 } else {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	141 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	142 $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	143 } else {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	144 $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	145 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	146 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	147 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	148 $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	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 $otherString = preg_replace("/○/u", "", $otherString);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	152 $outputTableArray[$count]["other"] = $otherString;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	153 $outputTableArray[$count]["page"] = $pageNow;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	154 $value = preg_replace("/>/u", ">", $value);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	155 $value = preg_replace("/</u", "<", $value);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	156 $outputTableArray[$count]["full"] = $value;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	157 }
11 3d6fba07bfbd implemented for topic tag. tagging with topic tag (main tag) indicating each row when export to html. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 10 diff changeset	158 /*
3d6fba07bfbd implemented for topic tag. tagging with topic tag (main tag) indicating each row when export to html. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 10 diff changeset	159 echo "<br>"."DEBUG: outputTableArray:"."<br>";
3d6fba07bfbd implemented for topic tag. tagging with topic tag (main tag) indicating each row when export to html. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 10 diff changeset	160 var_dump($outputTableArray);
3d6fba07bfbd implemented for topic tag. tagging with topic tag (main tag) indicating each row when export to html. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 10 diff changeset	161 */
6 63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	162
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	163 foreach ( $outputTableArray as $arrayIndex => $arrayValue ) {
11 3d6fba07bfbd implemented for topic tag. tagging with topic tag (main tag) indicating each row when export to html. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 10 diff changeset	164 // output each row which the topic tag
3d6fba07bfbd implemented for topic tag. tagging with topic tag (main tag) indicating each row when export to html. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 10 diff changeset	165 // e.g. the original version is for 'person'
3d6fba07bfbd implemented for topic tag. tagging with topic tag (main tag) indicating each row when export to html. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 10 diff changeset	166
3d6fba07bfbd implemented for topic tag. tagging with topic tag (main tag) indicating each row when export to html. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 10 diff changeset	167 // TODO: choose topic tag based on the topic
3d6fba07bfbd implemented for topic tag. tagging with topic tag (main tag) indicating each row when export to html. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 10 diff changeset	168 // for person topic
3d6fba07bfbd implemented for topic tag. tagging with topic tag (main tag) indicating each row when export to html. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 10 diff changeset	169 if ($topic == 1) {
3d6fba07bfbd implemented for topic tag. tagging with topic tag (main tag) indicating each row when export to html. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 10 diff changeset	170 if ( !isset($arrayValue[0]["person"]) ) {
3d6fba07bfbd implemented for topic tag. tagging with topic tag (main tag) indicating each row when export to html. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 10 diff changeset	171 unset($outputTableArray[$arrayIndex]);
3d6fba07bfbd implemented for topic tag. tagging with topic tag (main tag) indicating each row when export to html. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 10 diff changeset	172 }
3d6fba07bfbd implemented for topic tag. tagging with topic tag (main tag) indicating each row when export to html. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 10 diff changeset	173 } else if ($topic == 2) {
3d6fba07bfbd implemented for topic tag. tagging with topic tag (main tag) indicating each row when export to html. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 10 diff changeset	174
3d6fba07bfbd implemented for topic tag. tagging with topic tag (main tag) indicating each row when export to html. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 10 diff changeset	175 // for object topic
3d6fba07bfbd implemented for topic tag. tagging with topic tag (main tag) indicating each row when export to html. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 10 diff changeset	176 if ( !isset($arrayValue[0]["object"]) ) { // only the record with the tag of 'object' will become a row
3d6fba07bfbd implemented for topic tag. tagging with topic tag (main tag) indicating each row when export to html. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 10 diff changeset	177 unset($outputTableArray[$arrayIndex]);
3d6fba07bfbd implemented for topic tag. tagging with topic tag (main tag) indicating each row when export to html. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 10 diff changeset	178 }
6 63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	179 }
11 3d6fba07bfbd implemented for topic tag. tagging with topic tag (main tag) indicating each row when export to html. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 10 diff changeset	180
6 63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	181 }
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 $data = array();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	185
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	186 $data['outputTableArray'] = $outputTableArray;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	187 $data['bookId'] = $bookId;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	188 $data['section_id'] = $section_id;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	189 $data['bookName'] = $bookName;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	190 $data['sectionName'] = $sectionName;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	191
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	192 return $data;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	193
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	194 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	195
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	196 // === for manage tag list ===
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	197 public function EditTaglist($urlvalues) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	198 $this->Initialize($urlvalues);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	199 $result = $this->GetTaglist();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	200 $taglistArray = array();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	201 while ($row = mysql_fetch_assoc($result)) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	202 $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	203 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	204
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	205 $data = array();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	206 $data['taglistArray'] = $taglistArray;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	207 return $data;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	208
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	209 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	210
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	211 private function _GetTag($_postdata) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	212 if (get_magic_quotes_gpc()) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	213 $id = stripslashes($_postdata['id']);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	214 $name = stripslashes($_postdata['name']);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	215 $tag = stripslashes($_postdata['tag']);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	216 $color = stripslashes($_postdata['color']);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	217 } else {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	218 $id = $_postdata['id'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	219 $name = $_postdata['name'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	220 $tag = $_postdata['tag'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	221 $color = $_postdata['color'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	222 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	223 return array($id, $name, $tag, $color);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	224 }
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 public function NewTagElement($postdata) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	227 if ($postdata['id']){
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	228 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	229
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	230 $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	231 $this->GetSQLValueString($id, "int"),
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	232 $this->GetSQLValueString($name, "text"),
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	233 $this->GetSQLValueString($tag, "text"),
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	234 $this->GetSQLValueString($color, "text"),
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	235 $this->GetSQLValueString($this->systemNAME, "text"));
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	236 $result1 = mysql_query($query1);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	237 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	238
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	239 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	240
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	241 public function SaveTagElement($postdata) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	242 if ($postdata['id']){
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	243 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	244
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	245 $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	246 $this->GetSQLValueString($name, "text"),
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	247 $this->GetSQLValueString($tag, "text"),
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	248 $this->GetSQLValueString($color, "text"),
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	249 $this->GetSQLValueString($id, "int"));
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	250 $resultInsert = mysql_query($queryInsert);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	251
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	252 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	253
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	254 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	255
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	256 public function DeleteTag($postdata) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	257 if ($postdata['id']) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	258 $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	259 $resultInsert = mysql_query($queryInsert);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	260 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	261
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	262 }
9 584b1623e9ef TOC correction list page updated Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	263
10 54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	264 // === for config topic ===
11 3d6fba07bfbd implemented for topic tag. tagging with topic tag (main tag) indicating each row when export to html. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 10 diff changeset	265 public function ConfigTagsInTopic($urlvalues, $postdata) {
3d6fba07bfbd implemented for topic tag. tagging with topic tag (main tag) indicating each row when export to html. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 10 diff changeset	266
3d6fba07bfbd implemented for topic tag. tagging with topic tag (main tag) indicating each row when export to html. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 10 diff changeset	267 }
9 584b1623e9ef TOC correction list page updated Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	268
584b1623e9ef TOC correction list page updated Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	269 private function GetTaglistByTopicID($topic_id) {
10 54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	270 $taglistArray = array();
54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	271 // select taglist ids from topic_tag_relation table
54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	272 $query = sprintf("SELECT * FROM `topic_tag_relation` WHERE `topic_id`='%s'", $topic_id);
9 584b1623e9ef TOC correction list page updated Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	273 $result = mysql_query($query);
584b1623e9ef TOC correction list page updated Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	274 if (!$result) {
10 54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	275 return json_encode("Failed during selecting topic_tag_relation table.");
9 584b1623e9ef TOC correction list page updated Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	276 }
10 54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	277 $taglist_ids = array();
9 584b1623e9ef TOC correction list page updated Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	278
584b1623e9ef TOC correction list page updated Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	279 while ($row = mysql_fetch_assoc($result)) {
10 54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	280 array_push($taglist_ids, $row['tag_id']);
54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	281 }
54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	282
54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	283 // select taglist by tag ids
54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	284 foreach ($taglist_ids as $tag_id) {
54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	285 $query = sprintf("SELECT * FROM `taglist` WHERE `id`='%s'", $tag_id);
54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	286 $result = mysql_query($query);
54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	287 if (!$result) {
54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	288 echo mysql_error();
9 584b1623e9ef TOC correction list page updated Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	289 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	290 }
10 54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	291
54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	292 $row = mysql_fetch_assoc($result);
54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	293 array_push($taglistArray, array( $row['id'], $row['name'], $row['tag'], $row['color'] ));
54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	294
9 584b1623e9ef TOC correction list page updated Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	295 }
584b1623e9ef TOC correction list page updated Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	296 return $taglistArray;
10 54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	297 }
9 584b1623e9ef TOC correction list page updated Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	298
10 54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	299 public function SetTopic($topic) {
54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	300 $this->topic = $topic;
54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	301 }
9 584b1623e9ef TOC correction list page updated Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	302
10 54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	303 public function GetTopic() {
54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	304 return $this->topic;
54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	305 }
9 584b1623e9ef TOC correction list page updated Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	306
10 54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	307 private function GetTopiclistArray() {
54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	308 $topiclistArray = array();
54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	309 $result = $this->GetTopiclist();
54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	310 while ($row = mysql_fetch_assoc($result)) {
11 3d6fba07bfbd implemented for topic tag. tagging with topic tag (main tag) indicating each row when export to html. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 10 diff changeset	311 array_push($topiclistArray, array('id'=>$row['id'],'name'=>$row['name'],'tag'=>$row['tag']));
10 54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	312 }
54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	313 return $topiclistArray;
54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	314 }
9 584b1623e9ef TOC correction list page updated Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	315
11 3d6fba07bfbd implemented for topic tag. tagging with topic tag (main tag) indicating each row when export to html. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 10 diff changeset	316
3d6fba07bfbd implemented for topic tag. tagging with topic tag (main tag) indicating each row when export to html. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 10 diff changeset	317 private function GetTopicTag($topic_id) {
3d6fba07bfbd implemented for topic tag. tagging with topic tag (main tag) indicating each row when export to html. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 10 diff changeset	318 $result = $this->GetTopicByID($topic_id);
3d6fba07bfbd implemented for topic tag. tagging with topic tag (main tag) indicating each row when export to html. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 10 diff changeset	319 $row = mysql_fetch_assoc($result);
3d6fba07bfbd implemented for topic tag. tagging with topic tag (main tag) indicating each row when export to html. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 10 diff changeset	320 $tag = $row['tag'];
3d6fba07bfbd implemented for topic tag. tagging with topic tag (main tag) indicating each row when export to html. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 10 diff changeset	321 return $tag;
3d6fba07bfbd implemented for topic tag. tagging with topic tag (main tag) indicating each row when export to html. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 10 diff changeset	322
3d6fba07bfbd implemented for topic tag. tagging with topic tag (main tag) indicating each row when export to html. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 10 diff changeset	323 }
3d6fba07bfbd implemented for topic tag. tagging with topic tag (main tag) indicating each row when export to html. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 10 diff changeset	324
6 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
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	327 // === for manage wordlist ===
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	328 public function EditWordlist($urlvalues) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	329 $this->Initialize($urlvalues);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	330 $result = $this->GetWordlist();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	331 $wordlistArray = array();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	332 while ($row = mysql_fetch_assoc($result)) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	333 $wordlistArray[$row['id']] = $row['name'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	334 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	335
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	336 $data = array();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	337 $data['wordlistArray'] = $wordlistArray;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	338 return $data;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	339 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	340
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 public function AddNewList($postdata) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	343 if ($postdata['text']){
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	344 if (get_magic_quotes_gpc()) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	345 $name = stripslashes($postdata['text']);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	346 } else {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	347 $name = $postdata['text'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	348 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	349
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	350 $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	351 $this->GetSQLValueString($name, "text"),
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	352 $this->GetSQLValueString($this->systemNAME, "text"));
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	353 $result1 = mysql_query($query1);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	354 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	355 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	356 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	357
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	358
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	359 public function SaveWordlist($postdata) {
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 if ($postdata['text']){
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	362 $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	363 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	364 $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	365 $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	366 file_put_contents($filename, $oldFile);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	367 } else {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	368 $filename = "data/wordlist/".$postdata['filename'].".txt";
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
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	372 if (get_magic_quotes_gpc()) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	373 $require = stripslashes($postdata['text']);
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 $require = $postdata['text'];
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 $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	379 file_put_contents($filename, $require);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	380 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	381 /*
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	382 if ($postdata['text']){
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	383 $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	384 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	385 $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	386 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	387 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	388
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	389 if (get_magic_quotes_gpc()) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	390 $require = stripslashes($postdata['text']);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	391 } else {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	392 $require = $postdata['text'];
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 // $require = preg_replace("/<br>/u", "", $require);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	396 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	397 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	398 */
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	399 }
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
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 public function sortFunction($a,$b) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	405 return strlen($b)-strlen($a);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	406 }
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
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	409 private function SetSectionId($_urlvalues) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	410 // TODO: maybe get user info also
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	411 // get book id from url
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	412 if ($_urlvalues['id'] != "") {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	413 $section_id = $_urlvalues['id'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	414 } else {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	415 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	416 /* ???? */
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	417 /*
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	418 $get_book_id = $urlvalues['book'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	419 $get_start = $urlvalues['start'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	420 $get_end = $urlvalues['end'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	421 */
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	422 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	423 $this->section_id = $section_id;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	424
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	425 }
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 private function GetSectionId() {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	428 if ($this->section_id) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	429 return $this->section_id;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	430 } else {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	431 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	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
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	435 private function GetSectionInfo() {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	436 $section_id = $this->GetSectionId();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	437 if (!is_numeric($section_id)){
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	438 return $section_id;
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 $result = $this->GetSectionsByID($section_id);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	442
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	443
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 $bookId=$row['books_id'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	446 $startPage=$row['start_page'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	447 $endPage=$row['end_page'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	448 $sectionName = $row['name'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	449 }
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 $data = array();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	452 $data['bookId'] = $bookId;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	453 $data['startPage'] = $startPage;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	454 $data['endPage'] = $endPage;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	455 $data['sectionName'] = $sectionName;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	456
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	457 return $data;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	458 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	459
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	460 private function GetSectionContent() {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	461 $section_id = $this->GetSectionId();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	462 $section_info = $this->GetSectionInfo();
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 $bookId = $section_info['bookId'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	465 $startPage = $section_info['startPage'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	466 $endPage = $section_id['endPage'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	467
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 $contentString="";
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	470 $data_path = $this->GetDataPath();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	471 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	472 $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	473 $stringInput = $contentString;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	474 $stringInput = preg_replace("/ /u", "○", $stringInput);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	475 $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	476 $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	477 } else {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	478 $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	479 $result = mysql_query($query);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	480 while ($row = mysql_fetch_assoc($result)) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	481 $contentString.="【".$row['line']."】".$row['content']."\n";
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 $stringInput = $contentString;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	484 $stringInput = preg_replace("/<(.*?)>/u", "○", $stringInput);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	485 $stringInput = preg_replace("/ /u", "○", $stringInput);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	486 $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	487 $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	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 return $stringInput;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	491 }
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 private function GetDataPath() {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	494 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	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 private function GetTaglistArray() {
10 54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	498 $taglistArray = array();
6 63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	499 $result = $this->GetTaglist();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	500 while ($row = mysql_fetch_assoc($result)) {
10 54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	501 array_push($taglistArray, array( $row['id'], $row['name'], $row['tag'], $row['color'] ));
6 63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	502 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	503
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	504 return $taglistArray;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	505 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	506
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	507 private function GetWordlistArray() {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	508 $wordlistArray="";
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	509 $result = $this->GetWordlist();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	510 while ($row = mysql_fetch_assoc($result)) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	511 $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	512 $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	513 $listString = preg_replace("/<\/div>/u", "", $listString);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	514 $listString = preg_replace("/<span(.*?)>/u", "", $listString);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	515 $listString = preg_replace("/<\/span>/u", "", $listString);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	516 //$listString = preg_replace("/\n/u", "\|", $listString);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	517
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	518 $wordlistArray2 = explode( "\n", $listString );
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	519 usort($wordlistArray2,'sortFunction');
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	520 foreach ( $wordlistArray2 as $index=>$value ) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	521 $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	522 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	523 foreach ( $wordlistArray2 as $index=>$value ) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	524 if ($value=="") unset($wordlistArray2[$index]);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	525
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	526 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	527 $listString = implode("\|", $wordlistArray2);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	528
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	529 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	530 $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	531 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	532
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	533
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	534 return $wordlistArray;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	535
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	536 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	537
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	538 protected function GetBooksInfo($bookId) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	539 $result = $this->GetSectionsByID($bookId);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	540 while ($row = mysql_fetch_assoc($result)) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	541 $bookName = $row['name'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	542 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	543
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	544 $data = array();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	545 $data['bookName'] = $bookName;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	546
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	547 return $data;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	548 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	549
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	550
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	551 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	552
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	553
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	554
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	555 ?>

Mercurial > hg > extraction-interface

annotate develop/models/extractapp.php @ 11:3d6fba07bfbd