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

annotate develop/models/extractapp.php @ 21:c805470cefee

Remove bootstrap.TaggingText UI layout modification

author	Zoe Hong <zhong@mpiwg-berlin.mpg.de>
date	Tue, 24 Feb 2015 16:09:59 +0100
parents	04db1dd9d10d
children	a8ae5cbc3364

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) {
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	497
21 c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	498 $query = "SELECT `AUTO_INCREMENT` FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'taglist'";
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	499 $largest_id = mysql_query($query);
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	500
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	501 $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	502 $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	503
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	504 $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	505 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	506 $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	507 //$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	508 // 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	509 }
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
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 /*
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 //$result = $this->GetTaglist();
6 63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	513 $taglistArray = array();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	514 while ($row = mysql_fetch_assoc($result)) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	515 $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	516 }
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	517 */
6 63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	518
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	519 $data = array();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	520 $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	521 $data['topic_id'] = $topic_id;
21 c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	522 $data['largest_id'] = $largest_id;
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	523
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	524
6 63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	525 return $data;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	526
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	527 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	528
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	529 private function _GetTag($_postdata) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	530 if (get_magic_quotes_gpc()) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	531 $id = stripslashes($_postdata['id']);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	532 $name = stripslashes($_postdata['name']);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	533 $tag = stripslashes($_postdata['tag']);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	534 $color = stripslashes($_postdata['color']);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	535 } else {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	536 $id = $_postdata['id'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	537 $name = $_postdata['name'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	538 $tag = $_postdata['tag'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	539 $color = $_postdata['color'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	540 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	541 return array($id, $name, $tag, $color);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	542 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	543
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	544 public function NewTagElement($postdata) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	545 if ($postdata['id']){
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	546 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	547
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	548 $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	549 $this->GetSQLValueString($id, "int"),
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	550 $this->GetSQLValueString($name, "text"),
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	551 $this->GetSQLValueString($tag, "text"),
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	552 $this->GetSQLValueString($color, "text"),
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	553 $this->GetSQLValueString($this->systemNAME, "text"));
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	554 $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	555
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	556
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	557 // 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	558 $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	559
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 // 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	561 $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	562 $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	563 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	564 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	565 }
6 63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	566 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	567
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	568 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	569
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	570 public function SaveTagElement($postdata) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	571 if ($postdata['id']){
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	572 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	573
19 f60969462226 save tag modification of topic configration into topic_tag_relation table Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 17 diff changeset	574 $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	575 $this->GetSQLValueString($name, "text"),
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	576 $this->GetSQLValueString($tag, "text"),
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	577 $this->GetSQLValueString($color, "text"),
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	578 $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	579 $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	580
6 63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	581 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	582
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	583 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	584
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	585 public function DeleteTag($postdata) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	586 if ($postdata['id']) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	587 $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	588 $resultInsert = mysql_query($queryInsert);
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
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	591 }
9 584b1623e9ef TOC correction list page updated Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	592
10 54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	593 // === 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	594 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	595
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	596 $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	597 $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	598 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	599 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	600 }
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 $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	602 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	603 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	604 }
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 $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	607 $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	608 $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	609 $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	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 $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	612 $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	613 $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	614 $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	615
21 c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	616
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	617
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	618
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	619 // ------
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	620 $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	621 $result = mysql_query($query);
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	622 if (!$result) {
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	623 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	624 }
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	625
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	626 $tag_intopic = array();
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	627 $tag_others = array();
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	628 $tag_tmp_others = array();
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	629 while ($row = mysql_fetch_assoc($result)) {
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	630 if ($row['topic_id'] == $topic) {
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	631 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	632 } else {
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	633 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	634 }
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	635 }
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	636
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	637
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	638 foreach ($tag_tmp_others as $tmp) {
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	639 $cnt = 0;
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	640 foreach ($tag_intopic as $intopic) {
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	641 if ($tmp['tag'] == $intopic['tag']) {
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	642 break;
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	643 } else {
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	644 $cnt ++;
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	645 }
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	646 }
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	647 if ($cnt == count($tag_intopic)) {
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	648 array_push($tag_others, $tmp);
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	649 }
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
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	653 $data['tag_intopic'] = $tag_intopic;
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	654 $data['tag_others'] = $tag_others;
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	655
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	656 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	657 }
21 c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	658
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	659
19 f60969462226 save tag modification of topic configration into topic_tag_relation table Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 17 diff changeset	660 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	661 $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	662 $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	663
f60969462226 save tag modification of topic configration into topic_tag_relation table Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 17 diff changeset	664 // 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	665 // --- add new topic_tag_relation ---
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	666 foreach ($tag_ids as $tag_id) {
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	667 $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	668 $result = mysql_query($query);
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	669 if (!$result) {
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	670 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	671 }
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	672 $topic_tag = array();
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	673 $flag = false;
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	674 while ($row = mysql_fetch_assoc($result)) {
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	675 if ($row['topic_id'] == $topic_id) {
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	676 $flag = true;
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	677 break;
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	678 }
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	679 }
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	680 if (!$flag) {
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	681 // 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	682 $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	683 $resultUpdate = mysql_query($queryUpdate);
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	684 if (!$resultUpdate) {
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	685 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	686 }
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	687 }
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	688
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	689 }
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	690
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	691 // --- remove tags from this topic ---
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	692 $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	693 $result = mysql_query($query);
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	694 if (!$result) {
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	695 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	696 }
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	697
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	698 while ($row = mysql_fetch_assoc($result)) {
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	699 $cnt = 0;
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	700 foreach ($tag_ids as $tag_id) {
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	701 if ($row['tag_id'] == $tag_id) {
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	702 break;
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	703 } else {
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	704 $cnt ++;
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	705 }
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	706 }
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	707 $_id = $row['id'];
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	708 if ($cnt == count($tag_ids)) {
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	709 // 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	710 $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	711 $resultDelete = mysql_query($queryDelete);
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	712 if (!$resultDelete) {
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	713 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	714 }
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	715 }
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	716 }
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	717
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	718
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 § $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	722 $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	723 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	724 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	725 }
f60969462226 save tag modification of topic configration into topic_tag_relation table Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 17 diff changeset	726 $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	727 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	728 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	729 }
f60969462226 save tag modification of topic configration into topic_tag_relation table Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 17 diff changeset	730
21 c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	731
19 f60969462226 save tag modification of topic configration into topic_tag_relation table Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 17 diff changeset	732 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	733 $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	734 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	735 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	736 //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	737 $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	738 $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	739 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	740 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	741 }
f60969462226 save tag modification of topic configration into topic_tag_relation table Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 17 diff changeset	742 $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	743 break;
f60969462226 save tag modification of topic configration into topic_tag_relation table Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 17 diff changeset	744 }
f60969462226 save tag modification of topic configration into topic_tag_relation table Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 17 diff changeset	745 }
f60969462226 save tag modification of topic configration into topic_tag_relation table Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 17 diff changeset	746 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	747 // 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	748 $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	749 $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	750 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	751 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	752 }
f60969462226 save tag modification of topic configration into topic_tag_relation table Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 17 diff changeset	753 }
f60969462226 save tag modification of topic configration into topic_tag_relation table Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 17 diff changeset	754 }
21 c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	755 */
19 f60969462226 save tag modification of topic configration into topic_tag_relation table Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 17 diff changeset	756
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
9 584b1623e9ef TOC correction list page updated Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	759
584b1623e9ef TOC correction list page updated Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	760 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	761 $taglistArray = array();
54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	762 // 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	763 $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	764 $result = mysql_query($query);
584b1623e9ef TOC correction list page updated Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	765 if (!$result) {
10 54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	766 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	767 }
10 54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	768 $taglist_ids = array();
9 584b1623e9ef TOC correction list page updated Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	769
584b1623e9ef TOC correction list page updated Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	770 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	771 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	772 }
54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	773
54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	774 // select taglist by tag ids
54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	775 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	776 $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	777 $result = mysql_query($query);
54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	778 if (!$result) {
54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	779 echo mysql_error();
9 584b1623e9ef TOC correction list page updated Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	780 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	781 }
10 54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	782
54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	783 $row = mysql_fetch_assoc($result);
54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	784 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	785
9 584b1623e9ef TOC correction list page updated Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	786 }
584b1623e9ef TOC correction list page updated Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	787 return $taglistArray;
10 54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	788 }
9 584b1623e9ef TOC correction list page updated Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	789
10 54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	790 public function SetTopic($topic) {
54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	791 $this->topic = $topic;
54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	792 }
9 584b1623e9ef TOC correction list page updated Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	793
10 54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	794 public function GetTopic() {
54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	795 return $this->topic;
54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	796 }
9 584b1623e9ef TOC correction list page updated Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	797
10 54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	798 private function GetTopiclistArray() {
54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	799 $topiclistArray = array();
54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	800 $result = $this->GetTopiclist();
54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	801 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	802 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	803 }
54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	804 return $topiclistArray;
54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	805 }
9 584b1623e9ef TOC correction list page updated Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	806
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
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	808 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	809 $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	810 $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	811 $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	812 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	813
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 }
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	815 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	816 $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	817 $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	818 $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	819 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	820
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 }
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	822
19 f60969462226 save tag modification of topic configration into topic_tag_relation table Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 17 diff changeset	823
6 63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	824 // ===========================
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	825
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	826 // === 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	827 public function EditWordlist() {
6 63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	828 $result = $this->GetWordlist();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	829 $wordlistArray = array();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	830 while ($row = mysql_fetch_assoc($result)) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	831 $wordlistArray[$row['id']] = $row['name'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	832 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	833
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	834 $data = array();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	835 $data['wordlistArray'] = $wordlistArray;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	836 return $data;
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
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	840 public function AddNewList($postdata) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	841 if ($postdata['text']){
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	842 if (get_magic_quotes_gpc()) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	843 $name = stripslashes($postdata['text']);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	844 } else {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	845 $name = $postdata['text'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	846 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	847
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	848 $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	849 $this->GetSQLValueString($name, "text"),
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	850 $this->GetSQLValueString($this->systemNAME, "text"));
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	851 $result1 = mysql_query($query1);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	852 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	853 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	854 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	855
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	856
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	857 public function SaveWordlist($postdata) {
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 if ($postdata['text']){
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	860 $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	861 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	862 $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	863 $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	864 file_put_contents($filename, $oldFile);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	865 } else {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	866 $filename = "data/wordlist/".$postdata['filename'].".txt";
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	867 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	868
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	869
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	870 if (get_magic_quotes_gpc()) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	871 $require = stripslashes($postdata['text']);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	872 } else {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	873 $require = $postdata['text'];
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
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	876 $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	877 file_put_contents($filename, $require);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	878 }
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 if ($postdata['text']){
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	881 $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	882 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	883 $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	884 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	885 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	886
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	887 if (get_magic_quotes_gpc()) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	888 $require = stripslashes($postdata['text']);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	889 } else {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	890 $require = $postdata['text'];
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
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	893 // $require = preg_replace("/<br>/u", "", $require);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	894 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	895 }
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
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	899
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 public function sortFunction($a,$b) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	903 return strlen($b)-strlen($a);
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
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	906 // TODO: delete this
6 63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	907 private function SetSectionId($_urlvalues) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	908 // TODO: maybe get user info also
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	909 // get book id from url
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	910 if ($_urlvalues['id'] != "") {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	911 $section_id = $_urlvalues['id'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	912 } else {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	913 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	914 /* ???? */
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	915 /*
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	916 $get_book_id = $urlvalues['book'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	917 $get_start = $urlvalues['start'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	918 $get_end = $urlvalues['end'];
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 $this->section_id = $section_id;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	922
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	923 }
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 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	926
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	927 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	928 return $this->section_id;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	929 } else {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	930 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	931 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	932 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	933
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	934 private function GetSectionInfo() {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	935 $section_id = $this->GetSectionId();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	936 if (!is_numeric($section_id)){
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	937 return $section_id;
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
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	940 $result = $this->GetSectionsByID($section_id);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	941
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	942
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	943 while ($row = mysql_fetch_assoc($result)) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	944 $bookId=$row['books_id'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	945 $startPage=$row['start_page'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	946 $endPage=$row['end_page'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	947 $sectionName = $row['name'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	948 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	949
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	950 $data = array();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	951 $data['bookId'] = $bookId;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	952 $data['startPage'] = $startPage;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	953 $data['endPage'] = $endPage;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	954 $data['sectionName'] = $sectionName;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	955
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	956
6 63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	957 return $data;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	958 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	959
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	960 private function GetSectionContent() {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	961 $section_id = $this->GetSectionId();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	962 $section_info = $this->GetSectionInfo();
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 $bookId = $section_info['bookId'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	965 $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	966 $endPage = $section_info['endPage'];
6 63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	967
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	968 $contentString="";
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	969 $data_path = $this->GetDataPath();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	970 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	971 $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	972 $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	973
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	974 // 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	975 $stringInput = preg_replace("/ /u", "○", $stringInput);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	976 $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	977 $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	978 } else {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	979 $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	980 $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	981 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	982 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	983 }
6 63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	984 while ($row = mysql_fetch_assoc($result)) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	985 $contentString.="【".$row['line']."】".$row['content']."\n";
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	986 }
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	987
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 // the text is from database
6 63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	989 $stringInput = $contentString;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	990 $stringInput = preg_replace("/<(.*?)>/u", "○", $stringInput);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	991 $stringInput = preg_replace("/ /u", "○", $stringInput);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	992 $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	993 $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	994 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	995
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	996 return $stringInput;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	997 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	998
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	999 private function GetDataPath() {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1000 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	1001 }
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 private function GetTaglistArray() {
10 54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	1004 $taglistArray = array();
6 63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1005 $result = $this->GetTaglist();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1006 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	1007 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	1008 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1009
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1010 return $taglistArray;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1011 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1012
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1013 private function GetWordlistArray() {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1014 $wordlistArray="";
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1015 $result = $this->GetWordlist();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1016 while ($row = mysql_fetch_assoc($result)) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1017 $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	1018 $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	1019 $listString = preg_replace("/<\/div>/u", "", $listString);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1020 $listString = preg_replace("/<span(.*?)>/u", "", $listString);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1021 $listString = preg_replace("/<\/span>/u", "", $listString);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1022 //$listString = preg_replace("/\n/u", "\|", $listString);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1023
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1024 $wordlistArray2 = explode( "\n", $listString );
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1025 usort($wordlistArray2,'sortFunction');
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1026 foreach ( $wordlistArray2 as $index=>$value ) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1027 $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	1028 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1029 foreach ( $wordlistArray2 as $index=>$value ) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1030 if ($value=="") unset($wordlistArray2[$index]);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1031
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1032 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1033 $listString = implode("\|", $wordlistArray2);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1034
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1035 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	1036 $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	1037 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1038
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 return $wordlistArray;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1041
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 protected function GetBooksInfo($bookId) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1045 $result = $this->GetSectionsByID($bookId);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1046 while ($row = mysql_fetch_assoc($result)) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1047 $bookName = $row['name'];
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
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1050 $data = array();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1051 $data['bookName'] = $bookName;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1052
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1053 return $data;
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
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1056
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
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 ?>

Mercurial > hg > extraction-interface

annotate develop/models/extractapp.php @ 21:c805470cefee