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

annotate develop/models/extractapp.php @ 22:a8ae5cbc3364

update topic_tag_relation table when adding new tag

author	Zoe Hong <zhong@mpiwg-berlin.mpg.de>
date	Tue, 24 Feb 2015 17:29:56 +0100
parents	c805470cefee
children	a879f6b9d166

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
21 c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	11 protected $section_id = 0, $data_path, $file_id = 0, $branch_id = 0, $user_id = 0, $lg_text = "", $topic = 0;
14 ac77748bb813 - Load regex files based on current topic. Only show the regex in this topic. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 13 diff changeset	12 public $messages = "";
6 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
12 e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	19 public function GetTextFromFileId($_postdata) {
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	20 $file_id = $_postdata['fileId'];
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	21 $branch_id = $_postdata['branchId'];
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	22 $section_id = $_postdata['sectionId'];
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	23
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	24 $this->branch_id = $branch_id;
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	25 $this->file_id = $file_id;
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	26 $this->user_id = $_postdata['userId'];
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	27 $this->section_id = $section_id;
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	28
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	29 // get from URL with file_id
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	30 $lg_text_url = $this->get_text_from_fileId_url.$file_id;
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	31 $lg_text = file_get_contents($lg_text_url);
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	32
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	33 $stringInput = $lg_text;
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	34 $stringInput = preg_replace("/ /u", "○", $stringInput);
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	35 $stringInput = preg_replace("/\n/u", "<br>", $stringInput);
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	36 $stringInput = preg_replace("/【(.*?)】/u", "【<a href=\"review_index_xml_images.php?books_id=".$bookId."&pages=\\1&entry=0\" target=\"_bookImg\">\\1</a>】", $stringInput);
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	37 $lg_text = $stringInput;
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	38
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	39 $this->lg_text = $lg_text;
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	40
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	41 }
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	42
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	43 public function GetTextFromSectionId($_postdata) {
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	44
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	45 $section_id = $_postdata['sectionId'];
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	46 $this->section_id = $section_id;
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	47 $this->user_id = $_postdata['userId'];
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	48
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	49 // get from URL with file_id
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	50 $lg_text_url = $this->get_text_from_sectionId_url.$section_id;
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	51 $lg_text = file_get_contents($lg_text_url);
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	52
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	53 $stringInput = $lg_text;
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	54 $stringInput = preg_replace("/<(.*?)>/u", "○", $stringInput);
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	55 $stringInput = preg_replace("/ /u", "○", $stringInput);
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	56 $stringInput = preg_replace("/\n/u", "<br>", $stringInput);
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	57 $stringInput = preg_replace("/【(.*?)】/u", "【<a href=\"review_index_xml_images.php?books_id=".$bookId."&pages=\\1&entry=0\" target=\"_bookImg\">\\1</a>】", $stringInput);
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	58 $lg_text = $stringInput;
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	59
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	60 $this->lg_text = $lg_text;
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	61 }
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	62
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	63 public function GetTextFromLocal($_id){
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	64 $this->section_id = $_id;
14 ac77748bb813 - Load regex files based on current topic. Only show the regex in this topic. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 13 diff changeset	65 $this->messages .= "DEBUG: from my local"."<br>";
12 e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	66 $this->lg_text = $this->GetSectionContent();
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	67
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	68 }
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	69
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	70 public function GetInfoFromPreviousPage($_postdata) {
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	71
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	72 if ($_postdata['fileId']) {
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	73 $this->file_id = $_postdata['fileId'];
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	74 }
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	75 if ($_postdata['sectionId']) {
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	76 $this->section_id = $_postdata['sectionId'];
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	77 }
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	78 if ($_postdata['text']) {
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	79 $this->lg_text = $_postdata['text'];
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	80 }
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	81 if ($_postdata['branchId']) {
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	82 $this->branch_id = $_postdata['branchId'];
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	83 }
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	84 if ($_postdata['userId']) {
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	85 $this->user_id = $_postdata['userId'];
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	86 }
21 c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	87 if ($_postdata['topic_id']) {
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	88 $this->topic = $_postdata['topic_id'];
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	89 }
12 e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	90
21 c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	91 $this->messages .= "Info: ";
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	92 $this->messages .= "file_id=".$this->file_id.", section_id=".$this->section_id;
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	93 $this->messages .= ", user_id=".$this->user_id.", branch_id=".$this->branch_id.", topic_id=".$this->topic."<br>";
12 e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	94
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	95 }
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	96 public function InitData($_postdata) {
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	97 $file_id = $_postdata['fileId'];
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	98 $branch_id = $_postdata['branchId'];
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	99 $section_id = $_postdata['sectionId'];
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	100
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	101 $this->branch_id = $branch_id;
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	102 $this->file_id = $file_id;
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	103 $this->user_id = $_postdata['userId'];
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	104 $this->section_id = $section_id;
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	105
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	106 if ($file_id != 0 && $branch_id != 0) {
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	107 // get from URL with file_id
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	108 $lg_text_url = $this->get_text_from_fileId_url.$file_id;
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	109 } else if ($section_id != 0) {
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	110 // get from URL with section_id
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	111 $lg_text_url = $this->get_text_from_sectionId_url.$section_id;
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	112 } else {
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	113 echo "wrong url!!";
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	114 return;
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	115 }
6 63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	116
12 e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	117
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	118 $lg_text = file_get_contents($lg_text_url);
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	119
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	120 /*
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	121 $stringInput = preg_replace("/ /u", "○", $stringInput);
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	122 $stringInput = preg_replace("/\n/u", "<br>", $stringInput);
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	123 $stringInput = preg_replace("/【(.*?)】/u", "【<a href=\"review_index_xml_images.php?books_id=".$bookId."&pages=\\1&entry=0\" target=\"_bookImg\">\\1</a>】", $stringInput);
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	124 */
6 63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	125
12 e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	126 // the text is from database
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	127 $stringInput = $lg_text;
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	128 $stringInput = preg_replace("/<(.*?)>/u", "○", $stringInput);
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	129 $stringInput = preg_replace("/ /u", "○", $stringInput);
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	130 $stringInput = preg_replace("/\n/u", "<br>", $stringInput);
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	131 $stringInput = preg_replace("/【(.*?)】/u", "【<a href=\"review_index_xml_images.php?books_id=".$bookId."&pages=\\1&entry=0\" target=\"_bookImg\">\\1</a>】", $stringInput);
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	132 $lg_text = $stringInput;
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	133
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	134 $this->lg_text = $lg_text;
6 63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	135
12 e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	136
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	137 }
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	138
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	139 // === for tagging ===
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	140 public function StartTagging() {
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	141
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	142 // $this->Initialize($urlvalues);
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	143
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	144 $section_id = $this->section_id;
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	145 $stringInput = $this->lg_text;
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	146
6 63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	147
10 54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	148 //$taglistArray = $this->GetTaglistArray();
54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	149 //for GetTaglistByTopicID:
54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	150 $taglistArray = $this->GetTaglistByTopicID($this->GetTopic());
12 e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	151 // topic list
10 54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	152 $topiclistArray = $this->GetTopiclistArray();
9 584b1623e9ef TOC correction list page updated Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	153
6 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 $wordlistArray = $this->GetWordlistArray();
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 $data = array();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	158 $data['stringInput'] = $stringInput;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	159 $data['taglistArray'] = $taglistArray;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	160 $data['wordlistArray'] = $wordlistArray;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	161 $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	162 $data['topiclistArray'] = $topiclistArray;
54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	163 $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	164 $data['topic_tag'] = $this->GetTopicTag($this->GetTopic());
15 1f98c92ebbfb first version of UI layout. Very roughly, but works in the fixed sidebar, head line, popups and so on. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 14 diff changeset	165 $data['topic_name'] = $this->GetTopicName($this->GetTopic());
1f98c92ebbfb first version of UI layout. Very roughly, but works in the fixed sidebar, head line, popups and so on. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 14 diff changeset	166
12 e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	167 $data['info'] = array('file_id'=>$this->file_id, 'user_id'=>$this->user_id, 'branch_id'=>$this->branch_id, 'section_id'=>$this->section_id);
14 ac77748bb813 - Load regex files based on current topic. Only show the regex in this topic. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 13 diff changeset	168 $data['messages'] = $this->messages;
ac77748bb813 - Load regex files based on current topic. Only show the regex in this topic. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 13 diff changeset	169
6 63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	170 return $data;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	171
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	172 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	173
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	174 public function SaveFullText($postdata) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	175 if ($postdata['text']){
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	176 $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	177 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	178 $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	179 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	180 }
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 if (get_magic_quotes_gpc()) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	183 $require = stripslashes($postdata['text']);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	184 } else {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	185 $require = $postdata['text'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	186 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	187
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	188 $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	189 $require = preg_replace('/&/u', "&", $require);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	190 $require = preg_replace("/○/u", " ", $require);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	191 $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	192 $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	193 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	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 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	197
13 cc36a20a68ab automatically decide which rows (what data) should be shown in the exporting table based on the topic. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 12 diff changeset	198 public function UpdateInfoByResponseFromLGService($response) {
12 e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	199
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	200 $response_file = $response["file"];
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	201 $response_branch = $response["branch"];
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	202
14 ac77748bb813 - Load regex files based on current topic. Only show the regex in this topic. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 13 diff changeset	203 $this->file_id = (string)$response_file["id"];
12 e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	204 $this->branch_id = (string)$response_branch["id"];
14 ac77748bb813 - Load regex files based on current topic. Only show the regex in this topic. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 13 diff changeset	205
ac77748bb813 - Load regex files based on current topic. Only show the regex in this topic. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 13 diff changeset	206 $this->messages .= "file_id: ".$this->file_id."<br>";
ac77748bb813 - Load regex files based on current topic. Only show the regex in this topic. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 13 diff changeset	207 $this->messages .= "branch_id: ".$this->branch_id."<br>";
12 e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	208
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	209 }
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	210 public function SaveFullTextToLGService($_postdata) {
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	211 // save tagged text (full text) by Jorge's API to lg service
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	212
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	213 // --------
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	214 // saving in my local machine in developing phrase
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	215 if ($_postdata['text']){
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	216 $date = date('Y_m_d_H_i_s', time());
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	217 if ( file_exists("data/parsing_files/".$_postdata['sectionId'].".txt") ) {
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	218 $oldFile = file_get_contents("data/parsing_files/".$_postdata['sectionId'].".txt");
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	219 file_put_contents("data/parsing_files/".$_postdata['sectionId']."_".$date.".txt", $oldFile);
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	220 }
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	221
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	222 if (get_magic_quotes_gpc()) {
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	223 $require = stripslashes($_postdata['text']);
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	224 } else {
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	225 $require = $_postdata['text'];
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	226 }
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	227
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	228 $require = preg_replace("/【<a(.?)>(.?)<\/a>】/u", "【\\2】", $require);
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	229 $require = preg_replace('/&/u', "&", $require);
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	230 $require = preg_replace("/○/u", " ", $require);
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	231 $require = preg_replace("/<br>/u", "\n", $require);
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	232 $require = preg_replace("/<br>/u", "\n", $require);
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	233 file_put_contents("data/parsing_files/".$_postdata['sectionId'].".txt", $require);
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	234 }
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	235
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	236 // ------
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	237
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	238
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	239 if ($_postdata['branchId'] != 0) {
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	240 // exiting branch case
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	241 $postfields = array(
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	242 //"text" => $_postdata['text'],
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	243 "text" => $require,
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	244 "branchId" => $_postdata['branchId'],
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	245 "userId" => $_postdata['userId'],
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	246 "userPreviousFileId" => $_postdata['fileId'],
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	247 );
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	248 $save_url = $this->save_to_LGService_url;
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	249
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	250 } else {
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	251 // new branch case
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	252 echo "saveNew!";
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	253 $postfields = array(
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	254 //"text" => $_postdata['text'],
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	255 "text" => $require,
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	256 "sectionId" => $_postdata['sectionId'],
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	257 //"userId" => $_postdata['userId'],
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	258 // TODO: change userId when we can query by sectionId from LGService using search
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	259 "userId" => "12",
14 ac77748bb813 - Load regex files based on current topic. Only show the regex in this topic. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 13 diff changeset	260 "label" => $_postdata['label'],
12 e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	261 // TODO: ask user for lable
14 ac77748bb813 - Load regex files based on current topic. Only show the regex in this topic. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 13 diff changeset	262 //"label" => "label for section ".$_postdata['sectionId'],
12 e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	263 );
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	264 $save_url = $this->save_new_to_LGService_url;
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	265 }
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	266
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	267
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	268
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	269
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	270 // set up the curl resource
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	271 $ch = curl_init();
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	272 curl_setopt($ch, CURLOPT_URL, $save_url);
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	273 curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	274 curl_setopt($ch, CURLOPT_CUSTOMREQUEST, "POST");
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	275 curl_setopt($ch, CURLOPT_POST, true);
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	276 curl_setopt($ch, CURLOPT_POSTFIELDS, $postfields);
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	277 //curl_setopt($ch, CURLOPT_HEADER, true);
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	278 curl_setopt($ch, CURLOPT_HTTPHEADER, array(
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	279 'Content-type: multipart/form-data;charset=utf-8'
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	280 ));
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	281
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	282 // execute the request
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	283
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	284 $output = curl_exec($ch);
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	285
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	286 // output the profile information - includes the header
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	287 //echo($output) . PHP_EOL;
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	288
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	289 // close curl resource to free up system resources
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	290 curl_close($ch);
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	291
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	292 $response = json_decode($output, true);
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	293 return $response;
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	294
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	295 }
14 ac77748bb813 - Load regex files based on current topic. Only show the regex in this topic. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 13 diff changeset	296
ac77748bb813 - Load regex files based on current topic. Only show the regex in this topic. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 13 diff changeset	297 // --- for regex ----
ac77748bb813 - Load regex files based on current topic. Only show the regex in this topic. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 13 diff changeset	298 public function GetRegexFilenameById($topic_id) {
ac77748bb813 - Load regex files based on current topic. Only show the regex in this topic. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 13 diff changeset	299 $query = sprintf("SELECT regex_filename FROM `topic_regex_relation` WHERE topic_id=\"%s\"", $topic_id);
ac77748bb813 - Load regex files based on current topic. Only show the regex in this topic. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 13 diff changeset	300 $result = mysql_query($query);
ac77748bb813 - Load regex files based on current topic. Only show the regex in this topic. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 13 diff changeset	301 if (!$result) {
ac77748bb813 - Load regex files based on current topic. Only show the regex in this topic. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 13 diff changeset	302 return json_encode("Failed during selecting topic_regex_relation table.");
ac77748bb813 - Load regex files based on current topic. Only show the regex in this topic. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 13 diff changeset	303 }
ac77748bb813 - Load regex files based on current topic. Only show the regex in this topic. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 13 diff changeset	304
ac77748bb813 - Load regex files based on current topic. Only show the regex in this topic. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 13 diff changeset	305 $filenames = array();
ac77748bb813 - Load regex files based on current topic. Only show the regex in this topic. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 13 diff changeset	306 while ($row = mysql_fetch_assoc($result)) {
ac77748bb813 - Load regex files based on current topic. Only show the regex in this topic. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 13 diff changeset	307 array_push($filenames, $row['regex_filename']);
ac77748bb813 - Load regex files based on current topic. Only show the regex in this topic. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 13 diff changeset	308 }
ac77748bb813 - Load regex files based on current topic. Only show the regex in this topic. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 13 diff changeset	309
ac77748bb813 - Load regex files based on current topic. Only show the regex in this topic. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 13 diff changeset	310 return $filenames;
ac77748bb813 - Load regex files based on current topic. Only show the regex in this topic. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 13 diff changeset	311 }
ac77748bb813 - Load regex files based on current topic. Only show the regex in this topic. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 13 diff changeset	312 public function SmartRegexLoad($topic_id) {
ac77748bb813 - Load regex files based on current topic. Only show the regex in this topic. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 13 diff changeset	313
ac77748bb813 - Load regex files based on current topic. Only show the regex in this topic. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 13 diff changeset	314 // Load regex file based on current topic. Only shows the regex in this topic --
ac77748bb813 - Load regex files based on current topic. Only show the regex in this topic. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 13 diff changeset	315 $filenames = $this->GetRegexFilenameById($topic_id);
ac77748bb813 - Load regex files based on current topic. Only show the regex in this topic. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 13 diff changeset	316
ac77748bb813 - Load regex files based on current topic. Only show the regex in this topic. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 13 diff changeset	317 // Get regex file from filesystem ----
ac77748bb813 - Load regex files based on current topic. Only show the regex in this topic. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 13 diff changeset	318 $data_path = "./data/"; // get the current file path, which is getcwd(), and concatenate with "/data/"
ac77748bb813 - Load regex files based on current topic. Only show the regex in this topic. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 13 diff changeset	319 $returnArray = array();
ac77748bb813 - Load regex files based on current topic. Only show the regex in this topic. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 13 diff changeset	320 $files1 = scandir($data_path."regex_files");
ac77748bb813 - Load regex files based on current topic. Only show the regex in this topic. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 13 diff changeset	321 foreach ( $files1 as $file ) {
ac77748bb813 - Load regex files based on current topic. Only show the regex in this topic. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 13 diff changeset	322 if ( $file != "." && $file != ".." && $file != ".DS_Store") {
ac77748bb813 - Load regex files based on current topic. Only show the regex in this topic. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 13 diff changeset	323 foreach ($filenames as $filename) {
ac77748bb813 - Load regex files based on current topic. Only show the regex in this topic. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 13 diff changeset	324 if ($file == $filename) {
ac77748bb813 - Load regex files based on current topic. Only show the regex in this topic. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 13 diff changeset	325 $returnArray[preg_replace("/\.txt/", "", $file)] = file_get_contents( $data_path."regex_files/".$file );
ac77748bb813 - Load regex files based on current topic. Only show the regex in this topic. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 13 diff changeset	326 break;
ac77748bb813 - Load regex files based on current topic. Only show the regex in this topic. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 13 diff changeset	327 }
ac77748bb813 - Load regex files based on current topic. Only show the regex in this topic. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 13 diff changeset	328 }
ac77748bb813 - Load regex files based on current topic. Only show the regex in this topic. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 13 diff changeset	329 }
ac77748bb813 - Load regex files based on current topic. Only show the regex in this topic. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 13 diff changeset	330 }
ac77748bb813 - Load regex files based on current topic. Only show the regex in this topic. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 13 diff changeset	331 echo json_encode($returnArray);
ac77748bb813 - Load regex files based on current topic. Only show the regex in this topic. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 13 diff changeset	332 return;
ac77748bb813 - Load regex files based on current topic. Only show the regex in this topic. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 13 diff changeset	333 }
ac77748bb813 - Load regex files based on current topic. Only show the regex in this topic. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 13 diff changeset	334
ac77748bb813 - Load regex files based on current topic. Only show the regex in this topic. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 13 diff changeset	335
ac77748bb813 - Load regex files based on current topic. Only show the regex in this topic. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 13 diff changeset	336 public function SmartRegexSave($_postdata) {
ac77748bb813 - Load regex files based on current topic. Only show the regex in this topic. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 13 diff changeset	337 if ($_postdata['text']){
ac77748bb813 - Load regex files based on current topic. Only show the regex in this topic. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 13 diff changeset	338 /*
ac77748bb813 - Load regex files based on current topic. Only show the regex in this topic. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 13 diff changeset	339 $date = date('Y_m_d_H_i_s', time());
ac77748bb813 - Load regex files based on current topic. Only show the regex in this topic. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 13 diff changeset	340 if ( file_exists("regex_files/".$_POST['filename'].".txt") ) {
ac77748bb813 - Load regex files based on current topic. Only show the regex in this topic. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 13 diff changeset	341 $oldFile = file_get_contents("regex_files/".$_POST['filename'].".txt");
ac77748bb813 - Load regex files based on current topic. Only show the regex in this topic. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 13 diff changeset	342 file_put_contents("regex_files/".$_POST['filename']."_".$date.".txt", $oldFile);
ac77748bb813 - Load regex files based on current topic. Only show the regex in this topic. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 13 diff changeset	343 }
ac77748bb813 - Load regex files based on current topic. Only show the regex in this topic. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 13 diff changeset	344 */
ac77748bb813 - Load regex files based on current topic. Only show the regex in this topic. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 13 diff changeset	345 $data_path = "./data/"; // get the current file path, which is getcwd(), and concatenate with "/data/"
ac77748bb813 - Load regex files based on current topic. Only show the regex in this topic. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 13 diff changeset	346
ac77748bb813 - Load regex files based on current topic. Only show the regex in this topic. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 13 diff changeset	347 if (get_magic_quotes_gpc()) {
ac77748bb813 - Load regex files based on current topic. Only show the regex in this topic. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 13 diff changeset	348 $require = stripslashes($_postdata['text']);
ac77748bb813 - Load regex files based on current topic. Only show the regex in this topic. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 13 diff changeset	349 } else {
ac77748bb813 - Load regex files based on current topic. Only show the regex in this topic. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 13 diff changeset	350 $require = $_postdata['text'];
ac77748bb813 - Load regex files based on current topic. Only show the regex in this topic. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 13 diff changeset	351 }
ac77748bb813 - Load regex files based on current topic. Only show the regex in this topic. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 13 diff changeset	352
ac77748bb813 - Load regex files based on current topic. Only show the regex in this topic. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 13 diff changeset	353 file_put_contents( $data_path."regex_files/".$_postdata['filename'].".txt", $require);
20 04db1dd9d10d update topic_regex_relation table when saving (new) regex file Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 19 diff changeset	354
04db1dd9d10d update topic_regex_relation table when saving (new) regex file Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 19 diff changeset	355 // update topic_regex_relation table
04db1dd9d10d update topic_regex_relation table when saving (new) regex file Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 19 diff changeset	356 $topic_id = $_postdata['topic_id'];
04db1dd9d10d update topic_regex_relation table when saving (new) regex file Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 19 diff changeset	357 $filename = $_postdata['filename'].'.txt';
04db1dd9d10d update topic_regex_relation table when saving (new) regex file Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 19 diff changeset	358 $query = "INSERT INTO topic_regex_relation (topic_id, regex_filename) VALUES (".$topic_id.",'".$filename."')";
04db1dd9d10d update topic_regex_relation table when saving (new) regex file Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 19 diff changeset	359 $result = mysql_query($query);
04db1dd9d10d update topic_regex_relation table when saving (new) regex file Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 19 diff changeset	360 if (!$result) {
04db1dd9d10d update topic_regex_relation table when saving (new) regex file Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 19 diff changeset	361 echo json_encode("error");
04db1dd9d10d update topic_regex_relation table when saving (new) regex file Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 19 diff changeset	362 }
04db1dd9d10d update topic_regex_relation table when saving (new) regex file Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 19 diff changeset	363
14 ac77748bb813 - Load regex files based on current topic. Only show the regex in this topic. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 13 diff changeset	364 }
ac77748bb813 - Load regex files based on current topic. Only show the regex in this topic. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 13 diff changeset	365 }
ac77748bb813 - Load regex files based on current topic. Only show the regex in this topic. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 13 diff changeset	366
ac77748bb813 - Load regex files based on current topic. Only show the regex in this topic. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 13 diff changeset	367
6 63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	368 // === for export table ===
13 cc36a20a68ab automatically decide which rows (what data) should be shown in the exporting table based on the topic. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 12 diff changeset	369 public function ExportTable($postdata) {
12 e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	370 // $this->Initialize($urlvalues);
13 cc36a20a68ab automatically decide which rows (what data) should be shown in the exporting table based on the topic. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 12 diff changeset	371
6 63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	372 $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	373 $topic = $postdata['topic'];
21 c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	374 $section_id = $postdata['sectionId'];
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	375
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	376 //$section_id = $this->section_id;
6 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
13 cc36a20a68ab automatically decide which rows (what data) should be shown in the exporting table based on the topic. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 12 diff changeset	379 // TODO: this should be get from LGServic: sectionName, bookId, bookName
6 63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	380 $section_info = $this->GetSectionInfo();
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 $sectionName = $section_info['sectionName'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	383 $bookId = $section_info['bookId'];
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 $books_info = $this->GetBooksInfo($bookId);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	386 $bookName = $books_info['bookName'];
13 cc36a20a68ab automatically decide which rows (what data) should be shown in the exporting table based on the topic. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 12 diff changeset	387 // =====
cc36a20a68ab automatically decide which rows (what data) should be shown in the exporting table based on the topic. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 12 diff changeset	388
6 63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	389
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	390 $outputTableArray = array();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	391
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	392 //$taglistArray = $this->GetTaglistArray();
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	393 $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	394
6 63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	395 $outputTableArray[0]=array();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	396 $outputTableArray[0][0]=array();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	397 $outputTableArray[0][1]=array();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	398 foreach ( $taglistArray as $value ) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	399 $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	400 $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	401 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	402 $outputTableArray[0]["other"] = "其他";
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	403 $outputTableArray[0]["page"] = "頁數";
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	404 $outputTableArray[0]["full"] = "全文";
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	405
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	406 foreach ( $taglistArray as $tagValue ) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	407 $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	408 $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	409 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	410
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	411 $contentLineArray = explode( "<br>", $content );
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 $count=0;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	414 $pageNow=NULL;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	415 foreach ( $contentLineArray as $value ) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	416 $count++;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	417 $recordString = $value;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	418 $otherString = $recordString;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	419 //echo $recordString."<br>\n";
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	420 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	421 $pageNow = $matches[2];
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 foreach ( $taglistArray as $tagValue ) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	424 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	425 foreach ( $matches as $matchesValue ) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	426 $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	427 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	428 foreach ( $matches2 as $matches2Value ) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	429 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	430 $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	431 } else {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	432 $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	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 } else {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	436 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	437 $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	438 } else {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	439 $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	440 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	441 }
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 $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	444 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	445 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	446 $otherString = preg_replace("/○/u", "", $otherString);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	447 $outputTableArray[$count]["other"] = $otherString;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	448 $outputTableArray[$count]["page"] = $pageNow;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	449 $value = preg_replace("/>/u", ">", $value);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	450 $value = preg_replace("/</u", "<", $value);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	451 $outputTableArray[$count]["full"] = $value;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	452 }
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	453 /*
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	454 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	455 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	456 */
13 cc36a20a68ab automatically decide which rows (what data) should be shown in the exporting table based on the topic. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 12 diff changeset	457
cc36a20a68ab automatically decide which rows (what data) should be shown in the exporting table based on the topic. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 12 diff changeset	458 $topic_tag = $this->GetTopicTag($topic);
6 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 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	461 // output each row which the topic tag
13 cc36a20a68ab automatically decide which rows (what data) should be shown in the exporting table based on the topic. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 12 diff changeset	462 // e.g. the original version is for 'person'
cc36a20a68ab automatically decide which rows (what data) should be shown in the exporting table based on the topic. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 12 diff changeset	463 if ( !isset($arrayValue[0][$topic_tag]) ) {
cc36a20a68ab automatically decide which rows (what data) should be shown in the exporting table based on the topic. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 12 diff changeset	464 unset($outputTableArray[$arrayIndex]);
cc36a20a68ab automatically decide which rows (what data) should be shown in the exporting table based on the topic. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 12 diff changeset	465 }
cc36a20a68ab automatically decide which rows (what data) should be shown in the exporting table based on the topic. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 12 diff changeset	466
cc36a20a68ab automatically decide which rows (what data) should be shown in the exporting table based on the topic. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 12 diff changeset	467 /*
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	468 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	469 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	470 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	471 }
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	472 } 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	473
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	474 // 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	475 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	476 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	477 }
6 63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	478 }
13 cc36a20a68ab automatically decide which rows (what data) should be shown in the exporting table based on the topic. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 12 diff changeset	479 */
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	480
6 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 $data = array();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	484
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	485 $data['outputTableArray'] = $outputTableArray;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	486 $data['bookId'] = $bookId;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	487 $data['section_id'] = $section_id;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	488 $data['bookName'] = $bookName;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	489 $data['sectionName'] = $sectionName;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	490
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	491 return $data;
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 }
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 // === for manage tag list ===
17 82f8c6bd2b69 add new tag will based on the current topic_id, insert new element into (1)taglist table and (2)topic_tag_relation table Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 15 diff changeset	496 public function EditTaglist($_postdata) {
22 a8ae5cbc3364 update topic_tag_relation table when adding new tag Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 21 diff changeset	497 $query = "SELECT AUTO_INCREMENT FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME='taglist'";
a8ae5cbc3364 update topic_tag_relation table when adding new tag Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 21 diff changeset	498 $result = mysql_query($query);
a8ae5cbc3364 update topic_tag_relation table when adding new tag Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 21 diff changeset	499 if (!$result) {
a8ae5cbc3364 update topic_tag_relation table when adding new tag Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 21 diff changeset	500 echo json_encode(mysql_error());
a8ae5cbc3364 update topic_tag_relation table when adding new tag Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 21 diff changeset	501 }
a8ae5cbc3364 update topic_tag_relation table when adding new tag Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 21 diff changeset	502 $row = mysql_fetch_assoc($result);
a8ae5cbc3364 update topic_tag_relation table when adding new tag Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 21 diff changeset	503 $largest_id = $row['AUTO_INCREMENT'];
a8ae5cbc3364 update topic_tag_relation table when adding new tag Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 21 diff changeset	504
21 c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	505
17 82f8c6bd2b69 add new tag will based on the current topic_id, insert new element into (1)taglist table and (2)topic_tag_relation table Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 15 diff changeset	506 $topic_id = $_postdata['topic_id'];
82f8c6bd2b69 add new tag will based on the current topic_id, insert new element into (1)taglist table and (2)topic_tag_relation table Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 15 diff changeset	507 $result = $this->GetTaglistByTopicID($topic_id);
82f8c6bd2b69 add new tag will based on the current topic_id, insert new element into (1)taglist table and (2)topic_tag_relation table Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 15 diff changeset	508
82f8c6bd2b69 add new tag will based on the current topic_id, insert new element into (1)taglist table and (2)topic_tag_relation table Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 15 diff changeset	509 $taglistArray = array();
82f8c6bd2b69 add new tag will based on the current topic_id, insert new element into (1)taglist table and (2)topic_tag_relation table Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 15 diff changeset	510 foreach ($result as $row) {
82f8c6bd2b69 add new tag will based on the current topic_id, insert new element into (1)taglist table and (2)topic_tag_relation table Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 15 diff changeset	511 $taglistArray[$row[0]] = array($row[1], $row[2], $row[3]);
82f8c6bd2b69 add new tag will based on the current topic_id, insert new element into (1)taglist table and (2)topic_tag_relation table Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 15 diff changeset	512 //$taglistArray[$row['id']] = array($row['name'], $row['tag'], $row['color']);
82f8c6bd2b69 add new tag will based on the current topic_id, insert new element into (1)taglist table and (2)topic_tag_relation table Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 15 diff changeset	513 // TODO: the format is not good, so I use $row[0], $row[1],... This could be changed some time.
82f8c6bd2b69 add new tag will based on the current topic_id, insert new element into (1)taglist table and (2)topic_tag_relation table Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 15 diff changeset	514 }
82f8c6bd2b69 add new tag will based on the current topic_id, insert new element into (1)taglist table and (2)topic_tag_relation table Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 15 diff changeset	515
82f8c6bd2b69 add new tag will based on the current topic_id, insert new element into (1)taglist table and (2)topic_tag_relation table Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 15 diff changeset	516 /*
82f8c6bd2b69 add new tag will based on the current topic_id, insert new element into (1)taglist table and (2)topic_tag_relation table Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 15 diff changeset	517 //$result = $this->GetTaglist();
6 63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	518 $taglistArray = array();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	519 while ($row = mysql_fetch_assoc($result)) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	520 $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	521 }
17 82f8c6bd2b69 add new tag will based on the current topic_id, insert new element into (1)taglist table and (2)topic_tag_relation table Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 15 diff changeset	522 */
6 63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	523
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	524 $data = array();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	525 $data['taglistArray'] = $taglistArray;
17 82f8c6bd2b69 add new tag will based on the current topic_id, insert new element into (1)taglist table and (2)topic_tag_relation table Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 15 diff changeset	526 $data['topic_id'] = $topic_id;
21 c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	527 $data['largest_id'] = $largest_id;
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	528
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	529
6 63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	530 return $data;
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 private function _GetTag($_postdata) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	535 if (get_magic_quotes_gpc()) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	536 $id = stripslashes($_postdata['id']);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	537 $name = stripslashes($_postdata['name']);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	538 $tag = stripslashes($_postdata['tag']);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	539 $color = stripslashes($_postdata['color']);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	540 } else {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	541 $id = $_postdata['id'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	542 $name = $_postdata['name'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	543 $tag = $_postdata['tag'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	544 $color = $_postdata['color'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	545 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	546 return array($id, $name, $tag, $color);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	547 }
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 public function NewTagElement($postdata) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	550 if ($postdata['id']){
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	551 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	552
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	553 $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	554 $this->GetSQLValueString($id, "int"),
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	555 $this->GetSQLValueString($name, "text"),
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	556 $this->GetSQLValueString($tag, "text"),
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	557 $this->GetSQLValueString($color, "text"),
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	558 $this->GetSQLValueString($this->systemNAME, "text"));
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	559 $result1 = mysql_query($query1);
17 82f8c6bd2b69 add new tag will based on the current topic_id, insert new element into (1)taglist table and (2)topic_tag_relation table Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 15 diff changeset	560
82f8c6bd2b69 add new tag will based on the current topic_id, insert new element into (1)taglist table and (2)topic_tag_relation table Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 15 diff changeset	561
82f8c6bd2b69 add new tag will based on the current topic_id, insert new element into (1)taglist table and (2)topic_tag_relation table Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 15 diff changeset	562 // add it to topic_tag_relation table
82f8c6bd2b69 add new tag will based on the current topic_id, insert new element into (1)taglist table and (2)topic_tag_relation table Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 15 diff changeset	563 $topic_id = $postdata['topic_id'];
19 f60969462226 save tag modification of topic configration into topic_tag_relation table Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 17 diff changeset	564
17 82f8c6bd2b69 add new tag will based on the current topic_id, insert new element into (1)taglist table and (2)topic_tag_relation table Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 15 diff changeset	565 // tag_id is $id;
82f8c6bd2b69 add new tag will based on the current topic_id, insert new element into (1)taglist table and (2)topic_tag_relation table Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 15 diff changeset	566 $query = sprintf("INSERT INTO `topic_tag_relation` (`topic_id`,`tag_id`) VALUES (%s,%s)", $topic_id, $id);
82f8c6bd2b69 add new tag will based on the current topic_id, insert new element into (1)taglist table and (2)topic_tag_relation table Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 15 diff changeset	567 $result = mysql_query($query);
82f8c6bd2b69 add new tag will based on the current topic_id, insert new element into (1)taglist table and (2)topic_tag_relation table Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 15 diff changeset	568 if (!$result) {
82f8c6bd2b69 add new tag will based on the current topic_id, insert new element into (1)taglist table and (2)topic_tag_relation table Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 15 diff changeset	569 echo json_encode("error when insert into topic_tag_relation table");
82f8c6bd2b69 add new tag will based on the current topic_id, insert new element into (1)taglist table and (2)topic_tag_relation table Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 15 diff changeset	570 }
6 63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	571 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	572
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	573 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	574
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	575 public function SaveTagElement($postdata) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	576 if ($postdata['id']){
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	577 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	578
19 f60969462226 save tag modification of topic configration into topic_tag_relation table Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 17 diff changeset	579 $query = sprintf("UPDATE taglist SET `name`=%s, `tag`=%s, `color`=%s WHERE `id`=%s",
6 63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	580 $this->GetSQLValueString($name, "text"),
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	581 $this->GetSQLValueString($tag, "text"),
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	582 $this->GetSQLValueString($color, "text"),
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	583 $this->GetSQLValueString($id, "int"));
19 f60969462226 save tag modification of topic configration into topic_tag_relation table Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 17 diff changeset	584 $result = mysql_query($query);
f60969462226 save tag modification of topic configration into topic_tag_relation table Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 17 diff changeset	585
6 63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	586 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	587
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	588 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	589
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	590 public function DeleteTag($postdata) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	591 if ($postdata['id']) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	592 $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	593 $resultInsert = mysql_query($queryInsert);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	594 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	595
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	596 }
9 584b1623e9ef TOC correction list page updated Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	597
10 54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	598 // === for config topic ===
12 e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	599 public function ConfigTagsInTopic($postdata) {
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	600
12 e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	601 $query = "SELECT taglist.*, topic_tag_relation.topic_id FROM taglist LEFT JOIN topic_tag_relation ON taglist.id = topic_tag_relation.tag_id ORDER BY `topic_id`";
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	602 $result = mysql_query($query);
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	603 if (!$result) {
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	604 return json_encode("Failed during selecting/joining taglist and topic_tag_relation table.");
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	605 }
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	606 $taglistArray = array();
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	607 while ($row = mysql_fetch_assoc($result)) {
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	608 array_push($taglistArray, array('id'=>$row['id'],'name'=>$row['name'], 'tag'=>$row['tag'], 'color'=>$row['color'], 'topic_id'=>$row['topic_id']) );
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	609 }
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	610
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	611 $topic = $postdata['topic'];
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	612 $result = $this->GetTopicByID($topic);
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	613 $row = mysql_fetch_assoc($result);
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	614 $topic_name = $row['name'];
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	615
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	616 $data = array();
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	617 $data['taglistArray'] = $taglistArray;
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	618 $data['topic'] = $topic;
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	619 $data['topic_name'] = $topic_name;
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	620
21 c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	621
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	622
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	623
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	624 // ------
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	625 $query = "SELECT taglist.*, topic_tag_relation.topic_id FROM taglist LEFT JOIN topic_tag_relation ON taglist.id = topic_tag_relation.tag_id ORDER BY `topic_id`";
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	626 $result = mysql_query($query);
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	627 if (!$result) {
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	628 return json_encode("Failed during selecting/joining taglist and topic_tag_relation table.");
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	629 }
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	630
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	631 $tag_intopic = array();
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	632 $tag_others = array();
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	633 $tag_tmp_others = array();
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	634 while ($row = mysql_fetch_assoc($result)) {
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	635 if ($row['topic_id'] == $topic) {
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	636 array_push($tag_intopic, array('id=>'=>$row['id'],'name'=>$row['name'], 'tag'=>$row['tag'], 'color'=>$row['color'], 'topic_id'=>$row['topic_id']));
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	637 } else {
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	638 array_push($tag_tmp_others, array('id=>'=>$row['id'],'name'=>$row['name'], 'tag'=>$row['tag'], 'color'=>$row['color'], 'topic_id'=>$row['topic_id']));
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	639 }
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	640 }
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	641
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	642
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	643 foreach ($tag_tmp_others as $tmp) {
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	644 $cnt = 0;
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	645 foreach ($tag_intopic as $intopic) {
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	646 if ($tmp['tag'] == $intopic['tag']) {
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	647 break;
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	648 } else {
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	649 $cnt ++;
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	650 }
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	651 }
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	652 if ($cnt == count($tag_intopic)) {
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	653 array_push($tag_others, $tmp);
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	654 }
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	655 }
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	656
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	657
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	658 $data['tag_intopic'] = $tag_intopic;
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	659 $data['tag_others'] = $tag_others;
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	660
12 e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	661 return $data;
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	662 }
21 c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	663
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	664
19 f60969462226 save tag modification of topic configration into topic_tag_relation table Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 17 diff changeset	665 public function UpdateTagsInTopic($_postdata) {
f60969462226 save tag modification of topic configration into topic_tag_relation table Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 17 diff changeset	666 $topic_id = $_postdata['topic_id'];
f60969462226 save tag modification of topic configration into topic_tag_relation table Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 17 diff changeset	667 $tag_ids = json_decode(str_replace('\\', '', $_postdata['ids']));
f60969462226 save tag modification of topic configration into topic_tag_relation table Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 17 diff changeset	668
f60969462226 save tag modification of topic configration into topic_tag_relation table Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 17 diff changeset	669 // update topic_tag_relation by tags_ids array as `tag_id` and topic_id as `topic_id`
21 c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	670 // --- add new topic_tag_relation ---
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	671 foreach ($tag_ids as $tag_id) {
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	672 $query = "SELECT * FROM topic_tag_relation WHERE tag_id=".$tag_id;
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	673 $result = mysql_query($query);
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	674 if (!$result) {
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	675 echo json_encode("error when select from topic_tag_relation");
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	676 }
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	677 $topic_tag = array();
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	678 $flag = false;
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	679 while ($row = mysql_fetch_assoc($result)) {
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	680 if ($row['topic_id'] == $topic_id) {
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	681 $flag = true;
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	682 break;
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	683 }
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	684 }
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	685 if (!$flag) {
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	686 // insert a row into topic_tag_relation table
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	687 $queryUpdate = "INSERT INTO topic_tag_relation (topic_id, tag_id) VALUES (".$topic_id.",".$tag_id.")";
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	688 $resultUpdate = mysql_query($queryUpdate);
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	689 if (!$resultUpdate) {
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	690 return json_encode("error when insert topic_tag_relation table");
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	691 }
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	692 }
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	693
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	694 }
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	695
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	696 // --- remove tags from this topic ---
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	697 $query = "SELECT * FROM topic_tag_relation WHERE topic_id=".$topic_id;
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	698 $result = mysql_query($query);
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	699 if (!$result) {
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	700 echo json_encode("error when select from topic_tag_relation");
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	701 }
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	702
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	703 while ($row = mysql_fetch_assoc($result)) {
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	704 $cnt = 0;
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	705 foreach ($tag_ids as $tag_id) {
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	706 if ($row['tag_id'] == $tag_id) {
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	707 break;
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	708 } else {
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	709 $cnt ++;
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	710 }
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	711 }
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	712 $_id = $row['id'];
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	713 if ($cnt == count($tag_ids)) {
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	714 // delete row with (topic_id, tag_ids)
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	715 $queryDelete = "DELETE FROM topic_tag_relation WHERE id=".$_id;
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	716 $resultDelete = mysql_query($queryDelete);
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	717 if (!$resultDelete) {
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	718 echo json_encode("error when delete from topic_tag_relation");
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	719 }
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	720 }
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	721 }
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	722
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	723
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	724
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	725 /*
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	726 § $query = "SELECT * FROM topic_tag_relation";
19 f60969462226 save tag modification of topic configration into topic_tag_relation table Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 17 diff changeset	727 $result = mysql_query($query);
f60969462226 save tag modification of topic configration into topic_tag_relation table Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 17 diff changeset	728 if (!$result) {
f60969462226 save tag modification of topic configration into topic_tag_relation table Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 17 diff changeset	729 echo json_encode("error when select from topic_tag_relation");
f60969462226 save tag modification of topic configration into topic_tag_relation table Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 17 diff changeset	730 }
f60969462226 save tag modification of topic configration into topic_tag_relation table Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 17 diff changeset	731 $topic_tag = array();
f60969462226 save tag modification of topic configration into topic_tag_relation table Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 17 diff changeset	732 while ($row = mysql_fetch_assoc($result)) {
f60969462226 save tag modification of topic configration into topic_tag_relation table Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 17 diff changeset	733 array_push($topic_tag, array('tag_id'=>$row['tag_id'], 'topic_id'=>$row['topic_id']));
f60969462226 save tag modification of topic configration into topic_tag_relation table Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 17 diff changeset	734 }
f60969462226 save tag modification of topic configration into topic_tag_relation table Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 17 diff changeset	735
21 c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	736
19 f60969462226 save tag modification of topic configration into topic_tag_relation table Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 17 diff changeset	737 foreach ($topic_tag as $value) {
f60969462226 save tag modification of topic configration into topic_tag_relation table Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 17 diff changeset	738 $flag = false;
f60969462226 save tag modification of topic configration into topic_tag_relation table Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 17 diff changeset	739 foreach ($tag_ids as $tag_id) {
f60969462226 save tag modification of topic configration into topic_tag_relation table Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 17 diff changeset	740 if ($value['tag_id'] == $tag_id) {
f60969462226 save tag modification of topic configration into topic_tag_relation table Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 17 diff changeset	741 //update its topic_id to $topic_id
f60969462226 save tag modification of topic configration into topic_tag_relation table Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 17 diff changeset	742 $queryUpdate = "UPDATE topic_tag_relation SET topic_id=".$topic_id." WHERE tag_id=".$tag_id;
f60969462226 save tag modification of topic configration into topic_tag_relation table Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 17 diff changeset	743 $resultUpdate = mysql_query($queryUpdate);
f60969462226 save tag modification of topic configration into topic_tag_relation table Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 17 diff changeset	744 if (!$resultUpdate) {
f60969462226 save tag modification of topic configration into topic_tag_relation table Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 17 diff changeset	745 return json_encode("error when update topic_tag_relation table");
f60969462226 save tag modification of topic configration into topic_tag_relation table Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 17 diff changeset	746 }
f60969462226 save tag modification of topic configration into topic_tag_relation table Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 17 diff changeset	747 $flag = true;
f60969462226 save tag modification of topic configration into topic_tag_relation table Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 17 diff changeset	748 break;
f60969462226 save tag modification of topic configration into topic_tag_relation table Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 17 diff changeset	749 }
f60969462226 save tag modification of topic configration into topic_tag_relation table Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 17 diff changeset	750 }
f60969462226 save tag modification of topic configration into topic_tag_relation table Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 17 diff changeset	751 if (!$flag && $value['topic_id'] == $topic_id) {
f60969462226 save tag modification of topic configration into topic_tag_relation table Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 17 diff changeset	752 // set its topic_id to 0, indicating unsigned
f60969462226 save tag modification of topic configration into topic_tag_relation table Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 17 diff changeset	753 $queryUpdate = "UPDATE topic_tag_relation SET topic_id=0 WHERE tag_id=".$value['tag_id'];
f60969462226 save tag modification of topic configration into topic_tag_relation table Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 17 diff changeset	754 $resultUpdate = mysql_query($queryUpdate);
f60969462226 save tag modification of topic configration into topic_tag_relation table Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 17 diff changeset	755 if (!$resultUpdate) {
f60969462226 save tag modification of topic configration into topic_tag_relation table Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 17 diff changeset	756 return json_encode("error when update topic_tag_relation table");
f60969462226 save tag modification of topic configration into topic_tag_relation table Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 17 diff changeset	757 }
f60969462226 save tag modification of topic configration into topic_tag_relation table Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 17 diff changeset	758 }
f60969462226 save tag modification of topic configration into topic_tag_relation table Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 17 diff changeset	759 }
21 c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	760 */
19 f60969462226 save tag modification of topic configration into topic_tag_relation table Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 17 diff changeset	761
f60969462226 save tag modification of topic configration into topic_tag_relation table Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 17 diff changeset	762 }
f60969462226 save tag modification of topic configration into topic_tag_relation table Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 17 diff changeset	763
9 584b1623e9ef TOC correction list page updated Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	764
584b1623e9ef TOC correction list page updated Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	765 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	766 $taglistArray = array();
54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	767 // 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	768 $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	769 $result = mysql_query($query);
584b1623e9ef TOC correction list page updated Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	770 if (!$result) {
10 54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	771 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	772 }
10 54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	773 $taglist_ids = array();
9 584b1623e9ef TOC correction list page updated Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	774
584b1623e9ef TOC correction list page updated Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	775 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	776 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	777 }
54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	778
54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	779 // select taglist by tag ids
54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	780 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	781 $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	782 $result = mysql_query($query);
54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	783 if (!$result) {
54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	784 echo mysql_error();
9 584b1623e9ef TOC correction list page updated Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	785 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	786 }
10 54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	787
54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	788 $row = mysql_fetch_assoc($result);
54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	789 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	790
9 584b1623e9ef TOC correction list page updated Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	791 }
584b1623e9ef TOC correction list page updated Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	792 return $taglistArray;
10 54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	793 }
9 584b1623e9ef TOC correction list page updated Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	794
10 54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	795 public function SetTopic($topic) {
54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	796 $this->topic = $topic;
54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	797 }
9 584b1623e9ef TOC correction list page updated Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	798
10 54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	799 public function GetTopic() {
54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	800 return $this->topic;
54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	801 }
9 584b1623e9ef TOC correction list page updated Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	802
10 54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	803 private function GetTopiclistArray() {
54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	804 $topiclistArray = array();
54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	805 $result = $this->GetTopiclist();
54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	806 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	807 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	808 }
54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	809 return $topiclistArray;
54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	810 }
9 584b1623e9ef TOC correction list page updated Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	811
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	812
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	813 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	814 $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	815 $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	816 $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	817 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	818
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	819 }
15 1f98c92ebbfb first version of UI layout. Very roughly, but works in the fixed sidebar, head line, popups and so on. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 14 diff changeset	820 private function GetTopicName($topic_id) {
1f98c92ebbfb first version of UI layout. Very roughly, but works in the fixed sidebar, head line, popups and so on. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 14 diff changeset	821 $result = $this->GetTopicByID($topic_id);
1f98c92ebbfb first version of UI layout. Very roughly, but works in the fixed sidebar, head line, popups and so on. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 14 diff changeset	822 $row = mysql_fetch_assoc($result);
1f98c92ebbfb first version of UI layout. Very roughly, but works in the fixed sidebar, head line, popups and so on. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 14 diff changeset	823 $name = $row['name'];
1f98c92ebbfb first version of UI layout. Very roughly, but works in the fixed sidebar, head line, popups and so on. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 14 diff changeset	824 return $name;
1f98c92ebbfb first version of UI layout. Very roughly, but works in the fixed sidebar, head line, popups and so on. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 14 diff changeset	825
1f98c92ebbfb first version of UI layout. Very roughly, but works in the fixed sidebar, head line, popups and so on. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 14 diff changeset	826 }
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	827
19 f60969462226 save tag modification of topic configration into topic_tag_relation table Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 17 diff changeset	828
6 63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	829 // ===========================
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	830
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	831 // === for manage wordlist ===
14 ac77748bb813 - Load regex files based on current topic. Only show the regex in this topic. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 13 diff changeset	832 public function EditWordlist() {
6 63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	833 $result = $this->GetWordlist();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	834 $wordlistArray = array();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	835 while ($row = mysql_fetch_assoc($result)) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	836 $wordlistArray[$row['id']] = $row['name'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	837 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	838
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	839 $data = array();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	840 $data['wordlistArray'] = $wordlistArray;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	841 return $data;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	842 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	843
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	844
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	845 public function AddNewList($postdata) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	846 if ($postdata['text']){
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	847 if (get_magic_quotes_gpc()) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	848 $name = stripslashes($postdata['text']);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	849 } else {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	850 $name = $postdata['text'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	851 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	852
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	853 $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	854 $this->GetSQLValueString($name, "text"),
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	855 $this->GetSQLValueString($this->systemNAME, "text"));
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	856 $result1 = mysql_query($query1);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	857 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	858 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	859 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	860
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	861
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	862 public function SaveWordlist($postdata) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	863
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	864 if ($postdata['text']){
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	865 $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	866 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	867 $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	868 $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	869 file_put_contents($filename, $oldFile);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	870 } else {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	871 $filename = "data/wordlist/".$postdata['filename'].".txt";
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	872 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	873
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	874
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	875 if (get_magic_quotes_gpc()) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	876 $require = stripslashes($postdata['text']);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	877 } else {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	878 $require = $postdata['text'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	879 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	880
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	881 $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	882 file_put_contents($filename, $require);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	883 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	884 /*
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	885 if ($postdata['text']){
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	886 $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	887 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	888 $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	889 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	890 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	891
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	892 if (get_magic_quotes_gpc()) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	893 $require = stripslashes($postdata['text']);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	894 } else {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	895 $require = $postdata['text'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	896 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	897
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	898 // $require = preg_replace("/<br>/u", "", $require);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	899 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	900 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	901 */
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	902 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	903
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	904
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	905 // =======================================
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	906
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	907 public function sortFunction($a,$b) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	908 return strlen($b)-strlen($a);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	909 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	910
12 e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	911 // TODO: delete this
6 63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	912 private function SetSectionId($_urlvalues) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	913 // TODO: maybe get user info also
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	914 // get book id from url
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	915 if ($_urlvalues['id'] != "") {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	916 $section_id = $_urlvalues['id'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	917 } else {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	918 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	919 /* ???? */
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	920 /*
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	921 $get_book_id = $urlvalues['book'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	922 $get_start = $urlvalues['start'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	923 $get_end = $urlvalues['end'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	924 */
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	925 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	926 $this->section_id = $section_id;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	927
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	928 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	929
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	930 private function GetSectionId() {
12 e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	931
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	932 if (is_numeric($this->section_id)) {
6 63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	933 return $this->section_id;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	934 } else {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	935 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	936 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	937 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	938
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	939 private function GetSectionInfo() {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	940 $section_id = $this->GetSectionId();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	941 if (!is_numeric($section_id)){
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	942 return $section_id;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	943 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	944
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	945 $result = $this->GetSectionsByID($section_id);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	946
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	947
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	948 while ($row = mysql_fetch_assoc($result)) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	949 $bookId=$row['books_id'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	950 $startPage=$row['start_page'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	951 $endPage=$row['end_page'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	952 $sectionName = $row['name'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	953 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	954
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	955 $data = array();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	956 $data['bookId'] = $bookId;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	957 $data['startPage'] = $startPage;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	958 $data['endPage'] = $endPage;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	959 $data['sectionName'] = $sectionName;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	960
12 e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	961
6 63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	962 return $data;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	963 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	964
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	965 private function GetSectionContent() {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	966 $section_id = $this->GetSectionId();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	967 $section_info = $this->GetSectionInfo();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	968
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	969 $bookId = $section_info['bookId'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	970 $startPage = $section_info['startPage'];
12 e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	971 $endPage = $section_info['endPage'];
6 63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	972
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	973 $contentString="";
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	974 $data_path = $this->GetDataPath();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	975 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	976 $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	977 $stringInput = $contentString;
12 e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	978
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	979 // if the text is from file system
6 63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	980 $stringInput = preg_replace("/ /u", "○", $stringInput);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	981 $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	982 $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	983 } else {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	984 $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	985 $result = mysql_query($query);
12 e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	986 if (!$result) {
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	987 return json_encode("Failed during selecting content table.");
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	988 }
6 63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	989 while ($row = mysql_fetch_assoc($result)) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	990 $contentString.="【".$row['line']."】".$row['content']."\n";
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	991 }
12 e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	992
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	993 // the text is from database
6 63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	994 $stringInput = $contentString;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	995 $stringInput = preg_replace("/<(.*?)>/u", "○", $stringInput);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	996 $stringInput = preg_replace("/ /u", "○", $stringInput);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	997 $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	998 $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	999 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1000
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1001 return $stringInput;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1002 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1003
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1004 private function GetDataPath() {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1005 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	1006 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1007
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1008 private function GetTaglistArray() {
10 54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	1009 $taglistArray = array();
6 63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1010 $result = $this->GetTaglist();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1011 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	1012 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	1013 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1014
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1015 return $taglistArray;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1016 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1017
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1018 private function GetWordlistArray() {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1019 $wordlistArray="";
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1020 $result = $this->GetWordlist();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1021 while ($row = mysql_fetch_assoc($result)) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1022 $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	1023 $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	1024 $listString = preg_replace("/<\/div>/u", "", $listString);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1025 $listString = preg_replace("/<span(.*?)>/u", "", $listString);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1026 $listString = preg_replace("/<\/span>/u", "", $listString);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1027 //$listString = preg_replace("/\n/u", "\|", $listString);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1028
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1029 $wordlistArray2 = explode( "\n", $listString );
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1030 usort($wordlistArray2,'sortFunction');
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1031 foreach ( $wordlistArray2 as $index=>$value ) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1032 $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	1033 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1034 foreach ( $wordlistArray2 as $index=>$value ) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1035 if ($value=="") unset($wordlistArray2[$index]);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1036
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1037 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1038 $listString = implode("\|", $wordlistArray2);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1039
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1040 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	1041 $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	1042 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1043
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1044
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1045 return $wordlistArray;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1046
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1047 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1048
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1049 protected function GetBooksInfo($bookId) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1050 $result = $this->GetSectionsByID($bookId);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1051 while ($row = mysql_fetch_assoc($result)) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1052 $bookName = $row['name'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1053 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1054
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1055 $data = array();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1056 $data['bookName'] = $bookName;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1057
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1058 return $data;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1059 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1060
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1061
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1062 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1063
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1064
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1065
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1066 ?>

Mercurial > hg > extraction-interface

annotate develop/models/extractapp.php @ 22:a8ae5cbc3364