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

annotate develop/models/extractapp.php @ 25:4b6d2d7e706e

update for the integration

author	Zoe Hong <zhong@mpiwg-berlin.mpg.de>
date	Mon, 02 Mar 2015 16:16:54 +0100
parents	b55f5d3564c4
children	579f03f8bee5

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;
25 4b6d2d7e706e update for the integration Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 24 diff changeset	28
4b6d2d7e706e update for the integration Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 24 diff changeset	29
4b6d2d7e706e update for the integration Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 24 diff changeset	30 // TODO: get info from LGService
4b6d2d7e706e update for the integration Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 24 diff changeset	31 $this->section_name = $_postdata['sectionName'];
4b6d2d7e706e update for the integration Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 24 diff changeset	32 $this->book_id = $_postdata['bookId'];
4b6d2d7e706e update for the integration Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 24 diff changeset	33 $this->book_name = $_postdata['bookName'];
4b6d2d7e706e update for the integration Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 24 diff changeset	34
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	35
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting 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 // 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	37 $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	38 $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	39
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting 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 $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	41 $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	42 $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	43 $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	44 $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	45
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting 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->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	47
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting 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
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting 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 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	51
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting 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 $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	53 $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	54 $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	55
25 4b6d2d7e706e update for the integration Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 24 diff changeset	56 // TODO: get info from LGService
4b6d2d7e706e update for the integration Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 24 diff changeset	57 $this->section_name = $_postdata['sectionName'];
4b6d2d7e706e update for the integration Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 24 diff changeset	58 $this->book_id = $_postdata['bookId'];
4b6d2d7e706e update for the integration Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 24 diff changeset	59 $this->book_name = $_postdata['bookName'];
4b6d2d7e706e update for the integration Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 24 diff changeset	60
4b6d2d7e706e update for the integration Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 24 diff changeset	61
4b6d2d7e706e update for the integration Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 24 diff changeset	62
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	63 // 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	64 $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	65 $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	66
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting 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 $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	68 $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	69 $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	70 $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	71 $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	72 $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	73
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting 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 $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	75 }
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting 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
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting 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 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	78 $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	79 $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	80 $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	81
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting 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 }
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting 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 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	85
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting 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 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	87 $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	88 }
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	89 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	90 $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	91 }
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	92 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	93 $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	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 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	96 $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	97 }
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting 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 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	99 $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	100 }
21 c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	101 if ($_postdata['topic_id']) {
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	102 $this->topic = $_postdata['topic_id'];
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	103 }
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	104
25 4b6d2d7e706e update for the integration Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 24 diff changeset	105 // TODO: LGService
4b6d2d7e706e update for the integration Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 24 diff changeset	106 if ($_postdata['sectionName']) {
4b6d2d7e706e update for the integration Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 24 diff changeset	107 $this->section_name = $_postdata['sectionName'];
4b6d2d7e706e update for the integration Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 24 diff changeset	108 }
4b6d2d7e706e update for the integration Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 24 diff changeset	109 if ($_postdata['bookName']) {
4b6d2d7e706e update for the integration Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 24 diff changeset	110 $this->book_name = $_postdata['bookName'];
4b6d2d7e706e update for the integration Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 24 diff changeset	111 }
4b6d2d7e706e update for the integration Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 24 diff changeset	112 if ($_postdata['bookId']) {
4b6d2d7e706e update for the integration Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 24 diff changeset	113 $this->book_id = $_postdata['bookId'];
4b6d2d7e706e update for the integration Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 24 diff changeset	114 }
4b6d2d7e706e update for the integration Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 24 diff changeset	115
21 c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	116 $this->messages .= "Info: ";
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	117 $this->messages .= "file_id=".$this->file_id.", section_id=".$this->section_id;
25 4b6d2d7e706e update for the integration Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 24 diff changeset	118 $this->messages .= ", user_id=".$this->user_id.", branch_id=".$this->branch_id.", topic_id=".$this->topic;
4b6d2d7e706e update for the integration Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 24 diff changeset	119 $this->messages .= ", book_id=".$this->book_id.", book_name=".$this->book_name.", section_name=".$this->section_name."<br>";
4b6d2d7e706e update for the integration Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 24 diff changeset	120
4b6d2d7e706e update for the integration Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 24 diff changeset	121
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	122
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting 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 }
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting 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 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	125 $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	126 $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	127 $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	128
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting 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 $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	130 $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	131 $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	132 $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	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 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	135 // 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	136 $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	137 } 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	138 // 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	139 $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	140 } 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	141 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	142 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	143 }
6 63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	144
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	145
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting 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 $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	147
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	148 /*
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	149 $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	150 $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	151 $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	152 */
6 63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	153
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	154 // 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	155 $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	156 $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	157 $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	158 $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	159 $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	160 $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	161
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	162 $this->lg_text = $lg_text;
6 63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	163
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	164
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	165 }
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	166
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting 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 // === 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	168 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	169
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	170 // $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	171
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	172 $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	173 $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	174
6 63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	175
10 54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	176 //$taglistArray = $this->GetTaglistArray();
54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	177 //for GetTaglistByTopicID:
54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	178 $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	179 // topic list
10 54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	180 $topiclistArray = $this->GetTopiclistArray();
9 584b1623e9ef TOC correction list page updated Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	181
6 63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	182
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	183 $wordlistArray = $this->GetWordlistArray();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	184
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	185 $data = array();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	186 $data['stringInput'] = $stringInput;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	187 $data['taglistArray'] = $taglistArray;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	188 $data['wordlistArray'] = $wordlistArray;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	189 $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	190 $data['topiclistArray'] = $topiclistArray;
54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	191 $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	192 $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	193 $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	194
25 4b6d2d7e706e update for the integration Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 24 diff changeset	195 $data['info'] = array('file_id'=>$this->file_id, 'user_id'=>$this->user_id, 'branch_id'=>$this->branch_id, 'section_id'=>$this->section_id, 'book_id'=>$this->book_id, 'book_name'=>$this->book_name, 'section_name'=>$this->section_name);
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	196 $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	197
6 63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	198 return $data;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	199
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	200 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	201
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	202 public function SaveFullText($postdata) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	203 if ($postdata['text']){
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	204 $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	205 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	206 $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	207 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	208 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	209
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	210 if (get_magic_quotes_gpc()) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	211 $require = stripslashes($postdata['text']);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	212 } else {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	213 $require = $postdata['text'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	214 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	215
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	216 $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	217 $require = preg_replace('/&/u', "&", $require);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	218 $require = preg_replace("/○/u", " ", $require);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	219 $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	220 $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	221 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	222 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	223
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	224 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	225
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	226 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	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 $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	229 $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	230
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	231 $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	232 $this->branch_id = (string)$response_branch["id"];
25 4b6d2d7e706e update for the integration Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 24 diff changeset	233
4b6d2d7e706e update for the integration Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 24 diff changeset	234
4b6d2d7e706e update for the integration Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 24 diff changeset	235
4b6d2d7e706e update for the integration Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 24 diff changeset	236 $status = (string)$response["status"];
4b6d2d7e706e update for the integration Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 24 diff changeset	237 if ($status == "ok") {
4b6d2d7e706e update for the integration Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 24 diff changeset	238 $this->messages .= "saving success.";
4b6d2d7e706e update for the integration Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 24 diff changeset	239
4b6d2d7e706e update for the integration Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 24 diff changeset	240 } else if ($status == "error") {
4b6d2d7e706e update for the integration Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 24 diff changeset	241 // saving not success
4b6d2d7e706e update for the integration Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 24 diff changeset	242 $this->messages .= "saving does not success! ".(string)$response["message"];
24 b55f5d3564c4 add some regular expressions and wordlist for topic ?? Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 23 diff changeset	243
25 4b6d2d7e706e update for the integration Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 24 diff changeset	244
4b6d2d7e706e update for the integration Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 24 diff changeset	245 }
4b6d2d7e706e update for the integration Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 24 diff changeset	246
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	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 }
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting 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 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	250 // 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	251
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting 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 // --------
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting 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 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	254 $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	255 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	256 $oldFile = file_get_contents("data/parsing_files/".$_postdata['sectionId'].".txt");
25 4b6d2d7e706e update for the integration Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 24 diff changeset	257 //saving in my local machine in developing phrase
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	258 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	259 }
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	260
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting 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 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	262 $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	263 } 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	264 $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	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 $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	268 $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	269 $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	270 $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	271 $require = preg_replace("/<br>/u", "\n", $require);
25 4b6d2d7e706e update for the integration Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 24 diff changeset	272 //saving in my local machine in developing phrase
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	273 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	274 }
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting 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
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting 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 // ------
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting 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
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting 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
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting 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 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	280 // 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	281 $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	282 //"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	283 "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	284 "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	285 "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	286 "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	287 );
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting 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 $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	289
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting 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 } 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	291 // 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	292 echo "saveNew!";
25 4b6d2d7e706e update for the integration Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 24 diff changeset	293 if ($_postdata['userId']) {
4b6d2d7e706e update for the integration Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 24 diff changeset	294 $user_id = $_postdata['userId'];
4b6d2d7e706e update for the integration Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 24 diff changeset	295 } else {
4b6d2d7e706e update for the integration Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 24 diff changeset	296 $user_id = "12";
4b6d2d7e706e update for the integration Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 24 diff changeset	297 }
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	298 $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	299 //"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	300 "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	301 "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	302 //"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	303 // TODO: change userId when we can query by sectionId from LGService using search
25 4b6d2d7e706e update for the integration Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 24 diff changeset	304 "userId" => $user_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	305 "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	306 // 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	307 //"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	308 );
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	309 $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	310 }
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	311
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	312
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	313
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	314
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	315 // 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	316 $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	317 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	318 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	319 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	320 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	321 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	322 //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	323 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	324 '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	325 ));
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	326
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	327 // 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	328
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	329 $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	330
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	331 // 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	332 //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	333
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	334 // 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	335 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	336
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	337 $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	338 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	339
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	340 }
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	341
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 // --- 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	343 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	344 $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	345 $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	346 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	347 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	348 }
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
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 $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	351 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	352 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	353 }
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	354
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	355 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	356 }
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	357 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	358
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	359 // 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	360 $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	361
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	362 // 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	363 $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	364 $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	365 $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	366 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	367 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	368 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	369 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	370 $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	371 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	372 }
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	373 }
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	374 }
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	375 }
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	376 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	377 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	378 }
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	379
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	380
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	381 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	382 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	383 /*
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	384 $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	385 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	386 $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	387 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	388 }
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	389 */
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	390 $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	391
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	392 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	393 $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	394 } 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	395 $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	396 }
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	397
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	398 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	399
04db1dd9d10d update topic_regex_relation table when saving (new) regex file Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 19 diff changeset	400 // 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	401 $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	402 $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	403 $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	404 $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	405 if (!$result) {
04db1dd9d10d update topic_regex_relation table when saving (new) regex file Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 19 diff changeset	406 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	407 }
04db1dd9d10d update topic_regex_relation table when saving (new) regex file Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 19 diff changeset	408
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	409 }
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	410 }
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	411
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	412
6 63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	413 // === 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	414 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	415 // $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	416
6 63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	417 $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	418 $topic = $postdata['topic'];
21 c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	419 $section_id = $postdata['sectionId'];
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	420
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	421 //$section_id = $this->section_id;
6 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
25 4b6d2d7e706e update for the integration Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 24 diff changeset	424 // TODO: this should be get from LGService: sectionName, bookId, bookName
4b6d2d7e706e update for the integration Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 24 diff changeset	425 $sectionName = $postdata['sectionName'];
4b6d2d7e706e update for the integration Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 24 diff changeset	426 $bookId = $postdata['bookId'];
4b6d2d7e706e update for the integration Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 24 diff changeset	427 $bookName = $postdata['bookName'];
4b6d2d7e706e update for the integration Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 24 diff changeset	428
4b6d2d7e706e update for the integration Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 24 diff changeset	429
4b6d2d7e706e update for the integration Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 24 diff changeset	430 // --- replace if get info from LGService
4b6d2d7e706e update for the integration Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 24 diff changeset	431 /*
6 63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	432 $section_info = $this->GetSectionInfo();
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 $sectionName = $section_info['sectionName'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	435 $bookId = $section_info['bookId'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	436
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	437 $books_info = $this->GetBooksInfo($bookId);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	438 $bookName = $books_info['bookName'];
25 4b6d2d7e706e update for the integration Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 24 diff changeset	439 */
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	440 // =====
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	441
6 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 $outputTableArray = array();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	444
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	445 //$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	446 $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	447
6 63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	448 $outputTableArray[0]=array();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	449 $outputTableArray[0][0]=array();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	450 $outputTableArray[0][1]=array();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	451 foreach ( $taglistArray as $value ) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	452 $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	453 $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	454 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	455 $outputTableArray[0]["other"] = "其他";
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	456 $outputTableArray[0]["page"] = "頁數";
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	457 $outputTableArray[0]["full"] = "全文";
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	458
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	459 foreach ( $taglistArray as $tagValue ) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	460 $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	461 $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	462 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	463
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	464 $contentLineArray = explode( "<br>", $content );
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	465
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	466 $count=0;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	467 $pageNow=NULL;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	468 foreach ( $contentLineArray as $value ) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	469 $count++;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	470 $recordString = $value;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	471 $otherString = $recordString;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	472 //echo $recordString."<br>\n";
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	473 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	474 $pageNow = $matches[2];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	475 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	476 foreach ( $taglistArray as $tagValue ) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	477 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	478 foreach ( $matches as $matchesValue ) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	479 $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	480 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	481 foreach ( $matches2 as $matches2Value ) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	482 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	483 $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	484 } else {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	485 $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	486 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	487 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	488 } else {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	489 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	490 $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	491 } else {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	492 $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	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 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	496 $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	497 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	498 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	499 $otherString = preg_replace("/○/u", "", $otherString);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	500 $outputTableArray[$count]["other"] = $otherString;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	501 $outputTableArray[$count]["page"] = $pageNow;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	502 $value = preg_replace("/>/u", ">", $value);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	503 $value = preg_replace("/</u", "<", $value);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	504 $outputTableArray[$count]["full"] = $value;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	505 }
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	506 /*
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	507 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	508 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	509 */
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	510
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	511 $topic_tag = $this->GetTopicTag($topic);
6 63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	512
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	513 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	514 // 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	515 // 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	516 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	517 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	518 }
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	519
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	520 /*
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	521 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	522 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	523 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	524 }
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	525 } 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	526
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	527 // 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	528 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	529 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	530 }
6 63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	531 }
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	532 */
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	533
6 63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	534 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	535
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	536 $data = array();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	537
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	538 $data['outputTableArray'] = $outputTableArray;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	539 $data['bookId'] = $bookId;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	540 $data['section_id'] = $section_id;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	541 $data['bookName'] = $bookName;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	542 $data['sectionName'] = $sectionName;
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 return $data;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	545
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	546 }
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 // === 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	549 public function EditTaglist($_postdata) {
22 a8ae5cbc3364 update topic_tag_relation table when adding new tag Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 21 diff changeset	550 $query = "SELECT AUTO_INCREMENT FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME='taglist'";
a8ae5cbc3364 update topic_tag_relation table when adding new tag Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 21 diff changeset	551 $result = mysql_query($query);
a8ae5cbc3364 update topic_tag_relation table when adding new tag Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 21 diff changeset	552 if (!$result) {
a8ae5cbc3364 update topic_tag_relation table when adding new tag Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 21 diff changeset	553 echo json_encode(mysql_error());
a8ae5cbc3364 update topic_tag_relation table when adding new tag Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 21 diff changeset	554 }
a8ae5cbc3364 update topic_tag_relation table when adding new tag Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 21 diff changeset	555 $row = mysql_fetch_assoc($result);
a8ae5cbc3364 update topic_tag_relation table when adding new tag Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 21 diff changeset	556 $largest_id = $row['AUTO_INCREMENT'];
a8ae5cbc3364 update topic_tag_relation table when adding new tag Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 21 diff changeset	557
21 c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	558
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	559 $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	560 $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	561
82f8c6bd2b69 add new tag will based on the current topic_id, insert new element into (1)taglist table and (2)topic_tag_relation table Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 15 diff changeset	562 $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	563 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	564 $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	565 //$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	566 // 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	567 }
82f8c6bd2b69 add new tag will based on the current topic_id, insert new element into (1)taglist table and (2)topic_tag_relation table Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 15 diff changeset	568
82f8c6bd2b69 add new tag will based on the current topic_id, insert new element into (1)taglist table and (2)topic_tag_relation table Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 15 diff changeset	569 /*
82f8c6bd2b69 add new tag will based on the current topic_id, insert new element into (1)taglist table and (2)topic_tag_relation table Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 15 diff changeset	570 //$result = $this->GetTaglist();
6 63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	571 $taglistArray = array();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	572 while ($row = mysql_fetch_assoc($result)) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	573 $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	574 }
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	575 */
6 63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	576
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	577 $data = array();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	578 $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	579 $data['topic_id'] = $topic_id;
21 c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	580 $data['largest_id'] = $largest_id;
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	581
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	582
6 63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	583 return $data;
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 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	586
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	587 private function _GetTag($_postdata) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	588 if (get_magic_quotes_gpc()) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	589 $id = stripslashes($_postdata['id']);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	590 $name = stripslashes($_postdata['name']);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	591 $tag = stripslashes($_postdata['tag']);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	592 $color = stripslashes($_postdata['color']);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	593 } else {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	594 $id = $_postdata['id'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	595 $name = $_postdata['name'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	596 $tag = $_postdata['tag'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	597 $color = $_postdata['color'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	598 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	599 return array($id, $name, $tag, $color);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	600 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	601
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	602 public function NewTagElement($postdata) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	603 if ($postdata['id']){
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	604 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	605
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	606 $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	607 $this->GetSQLValueString($id, "int"),
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	608 $this->GetSQLValueString($name, "text"),
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	609 $this->GetSQLValueString($tag, "text"),
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	610 $this->GetSQLValueString($color, "text"),
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	611 $this->GetSQLValueString($this->systemNAME, "text"));
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	612 $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	613
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	614
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	615 // 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	616 $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	617
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	618 // 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	619 $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	620 $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	621 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	622 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	623 }
6 63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	624 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	625
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	626 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	627
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	628 public function SaveTagElement($postdata) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	629 if ($postdata['id']){
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	630 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	631
19 f60969462226 save tag modification of topic configration into topic_tag_relation table Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 17 diff changeset	632 $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	633 $this->GetSQLValueString($name, "text"),
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	634 $this->GetSQLValueString($tag, "text"),
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	635 $this->GetSQLValueString($color, "text"),
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	636 $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	637 $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	638
6 63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	639 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	640
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	641 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	642
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	643 public function DeleteTag($postdata) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	644 if ($postdata['id']) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	645 $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	646 $resultInsert = mysql_query($queryInsert);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	647 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	648
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	649 }
9 584b1623e9ef TOC correction list page updated Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	650
10 54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	651 // === 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	652 public function ConfigTagsInTopic($postdata) {
24 b55f5d3564c4 add some regular expressions and wordlist for topic ?? Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 23 diff changeset	653 $topic = $postdata['topic'];
b55f5d3564c4 add some regular expressions and wordlist for topic ?? Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 23 diff changeset	654 $result = $this->GetTopicByID($topic);
b55f5d3564c4 add some regular expressions and wordlist for topic ?? Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 23 diff changeset	655 $row = mysql_fetch_assoc($result);
b55f5d3564c4 add some regular expressions and wordlist for topic ?? Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 23 diff changeset	656 $topic_name = $row['name'];
b55f5d3564c4 add some regular expressions and wordlist for topic ?? Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 23 diff changeset	657
b55f5d3564c4 add some regular expressions and wordlist for topic ?? Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 23 diff changeset	658 /*
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	659 $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	660 $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	661 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	662 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	663 }
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	664 $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	665 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	666 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	667 }
24 b55f5d3564c4 add some regular expressions and wordlist for topic ?? Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 23 diff changeset	668 */
21 c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	669
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	670 // ------
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	671 $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	672 $result = mysql_query($query);
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	673 if (!$result) {
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	674 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	675 }
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	676
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	677 $tag_intopic = array();
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	678 $tag_others = array();
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	679 $tag_tmp_others = array();
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	680 while ($row = mysql_fetch_assoc($result)) {
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	681 if ($row['topic_id'] == $topic) {
23 a879f6b9d166 modification for select-move-taglist: tags don't appear to be duplicated in other topics. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 22 diff changeset	682 array_push($tag_intopic, array('id'=>$row['id'],'name'=>$row['name'], 'tag'=>$row['tag'], 'color'=>$row['color'], 'topic_id'=>$row['topic_id']));
21 c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	683 } else {
23 a879f6b9d166 modification for select-move-taglist: tags don't appear to be duplicated in other topics. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 22 diff changeset	684 array_push($tag_tmp_others, array('id'=>$row['id'],'name'=>$row['name'], 'tag'=>$row['tag'], 'color'=>$row['color'], 'topic_id'=>$row['topic_id']));
21 c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	685 }
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
24 b55f5d3564c4 add some regular expressions and wordlist for topic ?? Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 23 diff changeset	688 // --- check if there's any duplicated tags in tag_tmp_others. remove the duplicated tags
23 a879f6b9d166 modification for select-move-taglist: tags don't appear to be duplicated in other topics. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 22 diff changeset	689 $num_others = count($tag_tmp_others);
a879f6b9d166 modification for select-move-taglist: tags don't appear to be duplicated in other topics. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 22 diff changeset	690 for ($i=0; $i < $num_others; $i++) {
a879f6b9d166 modification for select-move-taglist: tags don't appear to be duplicated in other topics. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 22 diff changeset	691 $cnt = 0;
a879f6b9d166 modification for select-move-taglist: tags don't appear to be duplicated in other topics. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 22 diff changeset	692 for ($j=$i+1; $j < $num_others; $j++) {
a879f6b9d166 modification for select-move-taglist: tags don't appear to be duplicated in other topics. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 22 diff changeset	693 if ($tag_tmp_others[$i]['tag'] == $tag_tmp_others[$j]['tag']) {
a879f6b9d166 modification for select-move-taglist: tags don't appear to be duplicated in other topics. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 22 diff changeset	694 break;
a879f6b9d166 modification for select-move-taglist: tags don't appear to be duplicated in other topics. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 22 diff changeset	695 } else {
a879f6b9d166 modification for select-move-taglist: tags don't appear to be duplicated in other topics. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 22 diff changeset	696 $cnt++;
a879f6b9d166 modification for select-move-taglist: tags don't appear to be duplicated in other topics. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 22 diff changeset	697 }
a879f6b9d166 modification for select-move-taglist: tags don't appear to be duplicated in other topics. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 22 diff changeset	698 }
a879f6b9d166 modification for select-move-taglist: tags don't appear to be duplicated in other topics. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 22 diff changeset	699 if ($cnt == ($num_others-$i-1) ) {
a879f6b9d166 modification for select-move-taglist: tags don't appear to be duplicated in other topics. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 22 diff changeset	700 $row = $tag_tmp_others[$i];
a879f6b9d166 modification for select-move-taglist: tags don't appear to be duplicated in other topics. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 22 diff changeset	701 array_push($tag_others, array('id'=>$row['id'],'name'=>$row['name'], 'tag'=>$row['tag'], 'color'=>$row['color'], 'topic_id'=>$row['topic_id']) );
a879f6b9d166 modification for select-move-taglist: tags don't appear to be duplicated in other topics. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 22 diff changeset	702 }
a879f6b9d166 modification for select-move-taglist: tags don't appear to be duplicated in other topics. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 22 diff changeset	703 }
a879f6b9d166 modification for select-move-taglist: tags don't appear to be duplicated in other topics. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 22 diff changeset	704
24 b55f5d3564c4 add some regular expressions and wordlist for topic ?? Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 23 diff changeset	705 // --- remove duplicated tags in tag_others that is duplicated with tags in tag_intopic
23 a879f6b9d166 modification for select-move-taglist: tags don't appear to be duplicated in other topics. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 22 diff changeset	706 $tag_tmp_others = $tag_others;
a879f6b9d166 modification for select-move-taglist: tags don't appear to be duplicated in other topics. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 22 diff changeset	707 $tag_others = array();
21 c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	708
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	709 foreach ($tag_tmp_others as $tmp) {
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	710 $cnt = 0;
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	711 foreach ($tag_intopic as $intopic) {
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	712 if ($tmp['tag'] == $intopic['tag']) {
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	713 break;
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	714 } else {
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	715 $cnt ++;
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 if ($cnt == count($tag_intopic)) {
23 a879f6b9d166 modification for select-move-taglist: tags don't appear to be duplicated in other topics. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 22 diff changeset	719 // not appear in $tag_intopic
21 c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	720 array_push($tag_others, $tmp);
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	721 }
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	722 }
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	723
24 b55f5d3564c4 add some regular expressions and wordlist for topic ?? Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 23 diff changeset	724 // -----
b55f5d3564c4 add some regular expressions and wordlist for topic ?? Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 23 diff changeset	725
b55f5d3564c4 add some regular expressions and wordlist for topic ?? Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 23 diff changeset	726
b55f5d3564c4 add some regular expressions and wordlist for topic ?? Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 23 diff changeset	727 $data = array();
b55f5d3564c4 add some regular expressions and wordlist for topic ?? Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 23 diff changeset	728 //$data['taglistArray'] = $taglistArray;
b55f5d3564c4 add some regular expressions and wordlist for topic ?? Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 23 diff changeset	729 $data['topic'] = $topic;
b55f5d3564c4 add some regular expressions and wordlist for topic ?? Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 23 diff changeset	730 $data['topic_name'] = $topic_name;
21 c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	731
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	732 $data['tag_intopic'] = $tag_intopic;
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	733 $data['tag_others'] = $tag_others;
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	734
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	735 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	736 }
21 c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	737
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	738
19 f60969462226 save tag modification of topic configration into topic_tag_relation table Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 17 diff changeset	739 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	740 $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	741 $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	742
f60969462226 save tag modification of topic configration into topic_tag_relation table Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 17 diff changeset	743 // 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	744 // --- add new topic_tag_relation ---
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	745 foreach ($tag_ids as $tag_id) {
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	746 $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	747 $result = mysql_query($query);
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	748 if (!$result) {
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	749 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	750 }
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	751 $topic_tag = array();
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	752 $flag = false;
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	753 while ($row = mysql_fetch_assoc($result)) {
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	754 if ($row['topic_id'] == $topic_id) {
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	755 $flag = true;
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	756 break;
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	757 }
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	758 }
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	759 if (!$flag) {
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	760 // 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	761 $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	762 $resultUpdate = mysql_query($queryUpdate);
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	763 if (!$resultUpdate) {
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	764 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	765 }
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	766 }
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	767
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	768 }
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	769
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	770 // --- remove tags from this topic ---
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	771 $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	772 $result = mysql_query($query);
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	773 if (!$result) {
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	774 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	775 }
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	776
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	777 while ($row = mysql_fetch_assoc($result)) {
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	778 $cnt = 0;
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	779 foreach ($tag_ids as $tag_id) {
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	780 if ($row['tag_id'] == $tag_id) {
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	781 break;
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	782 } else {
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	783 $cnt ++;
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	784 }
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	785 }
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	786 $_id = $row['id'];
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	787 if ($cnt == count($tag_ids)) {
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	788 // 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	789 $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	790 $resultDelete = mysql_query($queryDelete);
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	791 if (!$resultDelete) {
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	792 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	793 }
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	794 }
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	795 }
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	796
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	797
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	798
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	799 /*
23 a879f6b9d166 modification for select-move-taglist: tags don't appear to be duplicated in other topics. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 22 diff changeset	800 $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	801 $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	802 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	803 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	804 }
f60969462226 save tag modification of topic configration into topic_tag_relation table Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 17 diff changeset	805 $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	806 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	807 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	808 }
f60969462226 save tag modification of topic configration into topic_tag_relation table Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 17 diff changeset	809
21 c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	810
19 f60969462226 save tag modification of topic configration into topic_tag_relation table Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 17 diff changeset	811 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	812 $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	813 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	814 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	815 //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	816 $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	817 $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	818 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	819 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	820 }
f60969462226 save tag modification of topic configration into topic_tag_relation table Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 17 diff changeset	821 $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	822 break;
f60969462226 save tag modification of topic configration into topic_tag_relation table Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 17 diff changeset	823 }
f60969462226 save tag modification of topic configration into topic_tag_relation table Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 17 diff changeset	824 }
f60969462226 save tag modification of topic configration into topic_tag_relation table Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 17 diff changeset	825 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	826 // 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	827 $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	828 $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	829 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	830 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	831 }
f60969462226 save tag modification of topic configration into topic_tag_relation table Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 17 diff changeset	832 }
f60969462226 save tag modification of topic configration into topic_tag_relation table Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 17 diff changeset	833 }
21 c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	834 */
19 f60969462226 save tag modification of topic configration into topic_tag_relation table Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 17 diff changeset	835
f60969462226 save tag modification of topic configration into topic_tag_relation table Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 17 diff changeset	836 }
f60969462226 save tag modification of topic configration into topic_tag_relation table Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 17 diff changeset	837
9 584b1623e9ef TOC correction list page updated Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	838
584b1623e9ef TOC correction list page updated Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	839 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	840 $taglistArray = array();
54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	841 // 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	842 $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	843 $result = mysql_query($query);
584b1623e9ef TOC correction list page updated Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	844 if (!$result) {
10 54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	845 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	846 }
10 54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	847 $taglist_ids = array();
9 584b1623e9ef TOC correction list page updated Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	848
584b1623e9ef TOC correction list page updated Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	849 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	850 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	851 }
54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	852
54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	853 // select taglist by tag ids
54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	854 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	855 $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	856 $result = mysql_query($query);
54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	857 if (!$result) {
54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	858 echo mysql_error();
9 584b1623e9ef TOC correction list page updated Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	859 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	860 }
10 54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	861
54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	862 $row = mysql_fetch_assoc($result);
54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	863 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	864
9 584b1623e9ef TOC correction list page updated Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	865 }
584b1623e9ef TOC correction list page updated Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	866 return $taglistArray;
10 54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	867 }
9 584b1623e9ef TOC correction list page updated Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	868
10 54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	869 public function SetTopic($topic) {
54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	870 $this->topic = $topic;
54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	871 }
9 584b1623e9ef TOC correction list page updated Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	872
10 54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	873 public function GetTopic() {
54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	874 return $this->topic;
54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	875 }
9 584b1623e9ef TOC correction list page updated Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	876
10 54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	877 private function GetTopiclistArray() {
54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	878 $topiclistArray = array();
54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	879 $result = $this->GetTopiclist();
54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	880 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	881 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	882 }
54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	883 return $topiclistArray;
54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	884 }
9 584b1623e9ef TOC correction list page updated Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	885
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	886
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	887 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	888 $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	889 $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	890 $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	891 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	892
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	893 }
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	894 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	895 $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	896 $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	897 $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	898 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	899
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	900 }
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	901
19 f60969462226 save tag modification of topic configration into topic_tag_relation table Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 17 diff changeset	902
6 63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	903 // ===========================
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	904
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	905 // === 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	906 public function EditWordlist() {
6 63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	907 $result = $this->GetWordlist();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	908 $wordlistArray = array();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	909 while ($row = mysql_fetch_assoc($result)) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	910 $wordlistArray[$row['id']] = $row['name'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	911 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	912
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	913 $data = array();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	914 $data['wordlistArray'] = $wordlistArray;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	915 return $data;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	916 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	917
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	918
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	919 public function AddNewList($postdata) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	920 if ($postdata['text']){
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	921 if (get_magic_quotes_gpc()) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	922 $name = stripslashes($postdata['text']);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	923 } else {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	924 $name = $postdata['text'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	925 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	926
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	927 $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	928 $this->GetSQLValueString($name, "text"),
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	929 $this->GetSQLValueString($this->systemNAME, "text"));
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	930 $result1 = mysql_query($query1);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	931 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	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
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	935
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	936 public function SaveWordlist($postdata) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	937
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	938 if ($postdata['text']){
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	939 $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	940 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	941 $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	942 $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	943 file_put_contents($filename, $oldFile);
24 b55f5d3564c4 add some regular expressions and wordlist for topic ?? Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 23 diff changeset	944 }
b55f5d3564c4 add some regular expressions and wordlist for topic ?? Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 23 diff changeset	945 /*else {
6 63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	946 $filename = "data/wordlist/".$postdata['filename'].".txt";
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	947 }
24 b55f5d3564c4 add some regular expressions and wordlist for topic ?? Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 23 diff changeset	948 */
6 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
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	951 if (get_magic_quotes_gpc()) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	952 $require = stripslashes($postdata['text']);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	953 } else {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	954 $require = $postdata['text'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	955 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	956
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	957 $require = preg_replace("/<br>/u", "<br>", $require);
24 b55f5d3564c4 add some regular expressions and wordlist for topic ?? Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 23 diff changeset	958 file_put_contents("data/wordlist/".$postdata['filename'].".txt", $require);
6 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 /*
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	961 if ($postdata['text']){
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	962 $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	963 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	964 $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	965 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	966 }
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 if (get_magic_quotes_gpc()) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	969 $require = stripslashes($postdata['text']);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	970 } else {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	971 $require = $postdata['text'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	972 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	973
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	974 // $require = preg_replace("/<br>/u", "", $require);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	975 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	976 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	977 */
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	978 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	979
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	980
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	981 // =======================================
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	982
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	983 public function sortFunction($a,$b) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	984 return strlen($b)-strlen($a);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	985 }
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 // TODO: delete this
6 63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	988 private function SetSectionId($_urlvalues) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	989 // TODO: maybe get user info also
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	990 // get book id from url
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	991 if ($_urlvalues['id'] != "") {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	992 $section_id = $_urlvalues['id'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	993 } else {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	994 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	995 /* ???? */
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	996 /*
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	997 $get_book_id = $urlvalues['book'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	998 $get_start = $urlvalues['start'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	999 $get_end = $urlvalues['end'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1000 */
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1001 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1002 $this->section_id = $section_id;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1003
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1004 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1005
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1006 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	1007
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	1008 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	1009 return $this->section_id;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1010 } else {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1011 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	1012 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1013 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1014
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1015 private function GetSectionInfo() {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1016 $section_id = $this->GetSectionId();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1017 if (!is_numeric($section_id)){
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1018 return $section_id;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1019 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1020
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1021 $result = $this->GetSectionsByID($section_id);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1022
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 while ($row = mysql_fetch_assoc($result)) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1025 $bookId=$row['books_id'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1026 $startPage=$row['start_page'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1027 $endPage=$row['end_page'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1028 $sectionName = $row['name'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1029 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1030
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1031 $data = array();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1032 $data['bookId'] = $bookId;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1033 $data['startPage'] = $startPage;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1034 $data['endPage'] = $endPage;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1035 $data['sectionName'] = $sectionName;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1036
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	1037
6 63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1038 return $data;
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
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1041 private function GetSectionContent() {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1042 $section_id = $this->GetSectionId();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1043 $section_info = $this->GetSectionInfo();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1044
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1045 $bookId = $section_info['bookId'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1046 $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	1047 $endPage = $section_info['endPage'];
6 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 $contentString="";
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1050 $data_path = $this->GetDataPath();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1051 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	1052 $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	1053 $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	1054
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	1055 // 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	1056 $stringInput = preg_replace("/ /u", "○", $stringInput);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1057 $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	1058 $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	1059 } else {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1060 $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	1061 $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	1062 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	1063 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	1064 }
6 63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1065 while ($row = mysql_fetch_assoc($result)) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1066 $contentString.="【".$row['line']."】".$row['content']."\n";
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1067 }
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	1068
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	1069 // the text is from database
6 63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1070 $stringInput = $contentString;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1071 $stringInput = preg_replace("/<(.*?)>/u", "○", $stringInput);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1072 $stringInput = preg_replace("/ /u", "○", $stringInput);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1073 $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	1074 $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	1075 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1076
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1077 return $stringInput;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1078 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1079
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1080 private function GetDataPath() {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1081 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	1082 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1083
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1084 private function GetTaglistArray() {
10 54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	1085 $taglistArray = array();
6 63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1086 $result = $this->GetTaglist();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1087 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	1088 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	1089 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1090
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1091 return $taglistArray;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1092 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1093
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1094 private function GetWordlistArray() {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1095 $wordlistArray="";
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1096 $result = $this->GetWordlist();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1097 while ($row = mysql_fetch_assoc($result)) {
24 b55f5d3564c4 add some regular expressions and wordlist for topic ?? Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 23 diff changeset	1098 $listString = file_get_contents("data/wordlist/".$row['id'].".txt");
6 63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1099 $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	1100 $listString = preg_replace("/<\/div>/u", "", $listString);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1101 $listString = preg_replace("/<span(.*?)>/u", "", $listString);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1102 $listString = preg_replace("/<\/span>/u", "", $listString);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1103 //$listString = preg_replace("/\n/u", "\|", $listString);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1104
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1105 $wordlistArray2 = explode( "\n", $listString );
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1106 usort($wordlistArray2,'sortFunction');
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1107 foreach ( $wordlistArray2 as $index=>$value ) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1108 $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	1109 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1110 foreach ( $wordlistArray2 as $index=>$value ) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1111 if ($value=="") unset($wordlistArray2[$index]);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1112
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1113 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1114 $listString = implode("\|", $wordlistArray2);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1115
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1116 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	1117 $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	1118 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1119
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1120
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1121 return $wordlistArray;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1122
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1123 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1124
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1125 protected function GetBooksInfo($bookId) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1126 $result = $this->GetSectionsByID($bookId);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1127 while ($row = mysql_fetch_assoc($result)) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1128 $bookName = $row['name'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1129 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1130
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1131 $data = array();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1132 $data['bookName'] = $bookName;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1133
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1134 return $data;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1135 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1136
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1137
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1138 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1139
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1140
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1141
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1142 ?>

Mercurial > hg > extraction-interface

annotate develop/models/extractapp.php @ 25:4b6d2d7e706e