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

annotate develop/models/extractapp.php @ 38:4b3da4802998 extractapp

config for localgazetteers-dev

author	Zoe Hong <zhong@mpiwg-berlin.mpg.de>
date	Fri, 06 Mar 2015 17:56:48 +0100
parents	fc7342914cdf
children	8347776a44fc

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
28 e6e9bdc4f256 update the saving response from LGService between different file version Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 27 diff changeset	11 protected $section_id = 0, $data_path, $file_id = 0, $current_fileId=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) {
29 fc7342914cdf develop_v0 Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 28 diff changeset	20 /*
28 e6e9bdc4f256 update the saving response from LGService between different file version Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 27 diff changeset	21 if ($this->current_fileId != 0) {
e6e9bdc4f256 update the saving response from LGService between different file version Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 27 diff changeset	22 $this->file_id = $this->current_fileId;
e6e9bdc4f256 update the saving response from LGService between different file version Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 27 diff changeset	23 } else {
e6e9bdc4f256 update the saving response from LGService between different file version Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 27 diff changeset	24 $this->file_id = $_postdata['fileId'];
e6e9bdc4f256 update the saving response from LGService between different file version Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 27 diff changeset	25 }
29 fc7342914cdf develop_v0 Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 28 diff changeset	26 */
fc7342914cdf develop_v0 Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 28 diff changeset	27 $this->file_id = $_postdata['fileId'];
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	28 $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	29 $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	30
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	31 $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	32 $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	33 $this->section_id = $section_id;
25 4b6d2d7e706e update for the integration Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 24 diff changeset	34
4b6d2d7e706e update for the integration Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 24 diff changeset	35
4b6d2d7e706e update for the integration Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 24 diff changeset	36 $this->section_name = $_postdata['sectionName'];
4b6d2d7e706e update for the integration Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 24 diff changeset	37 $this->book_id = $_postdata['bookId'];
4b6d2d7e706e update for the integration Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 24 diff changeset	38 $this->book_name = $_postdata['bookName'];
4b6d2d7e706e update for the integration Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 24 diff changeset	39
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	40
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	41 // get from URL with file_id
28 e6e9bdc4f256 update the saving response from LGService between different file version Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 27 diff changeset	42 $lg_text_url = $this->get_text_from_fileId_url.$this->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	43 $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	44
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	45 $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	46 $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	47 $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	48 $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	49 $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	50
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting 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 $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	52
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	53 }
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting 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
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting 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 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	56
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	57 $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	58 $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	59 $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	60
25 4b6d2d7e706e update for the integration Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 24 diff changeset	61 $this->section_name = $_postdata['sectionName'];
4b6d2d7e706e update for the integration Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 24 diff changeset	62 $this->book_id = $_postdata['bookId'];
4b6d2d7e706e update for the integration Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 24 diff changeset	63 $this->book_name = $_postdata['bookName'];
4b6d2d7e706e update for the integration Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 24 diff changeset	64
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	65 // 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	66 $lg_text_url = $this->get_text_from_sectionId_url.$section_id;
38 4b3da4802998 config for localgazetteers-dev Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 29 diff changeset	67
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	68 $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	69
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	70 $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	71 $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	72 $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	73 $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	74 $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	75 $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	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 $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	78 }
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	79
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting 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 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	81 $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	82 $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	83 $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	84
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting 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
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting 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 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	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['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	90 $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	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['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	93 $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	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['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	96 $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	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['branchId']) {
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	99 $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	100 }
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	101 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	102 $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	103 }
21 c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	104 if ($_postdata['topic_id']) {
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	105 $this->topic = $_postdata['topic_id'];
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	106 }
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	107
25 4b6d2d7e706e update for the integration Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 24 diff changeset	108 if ($_postdata['sectionName']) {
4b6d2d7e706e update for the integration Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 24 diff changeset	109 $this->section_name = $_postdata['sectionName'];
4b6d2d7e706e update for the integration Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 24 diff changeset	110 }
4b6d2d7e706e update for the integration Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 24 diff changeset	111 if ($_postdata['bookName']) {
4b6d2d7e706e update for the integration Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 24 diff changeset	112 $this->book_name = $_postdata['bookName'];
4b6d2d7e706e update for the integration Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 24 diff changeset	113 }
4b6d2d7e706e update for the integration Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 24 diff changeset	114 if ($_postdata['bookId']) {
4b6d2d7e706e update for the integration Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 24 diff changeset	115 $this->book_id = $_postdata['bookId'];
4b6d2d7e706e update for the integration Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 24 diff changeset	116 }
28 e6e9bdc4f256 update the saving response from LGService between different file version Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 27 diff changeset	117 if ($_postdata['currentFileId']) {
e6e9bdc4f256 update the saving response from LGService between different file version Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 27 diff changeset	118 $this->current_fileId = $_postdata['currentFileId'];
e6e9bdc4f256 update the saving response from LGService between different file version Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 27 diff changeset	119 }
25 4b6d2d7e706e update for the integration Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 24 diff changeset	120
28 e6e9bdc4f256 update the saving response from LGService between different file version Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 27 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 }
29 fc7342914cdf develop_v0 Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 28 diff changeset	166 /*
fc7342914cdf develop_v0 Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 28 diff changeset	167 public function Reload($_postdata) {
fc7342914cdf develop_v0 Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 28 diff changeset	168
fc7342914cdf develop_v0 Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 28 diff changeset	169 // update text using $this->current_fileId
fc7342914cdf develop_v0 Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 28 diff changeset	170 // getTextbyFileId
fc7342914cdf develop_v0 Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 28 diff changeset	171 $current_fileId = $_postdata['currentFileId'];
fc7342914cdf develop_v0 Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 28 diff changeset	172 //$this->file_id = $_postdata['currentFileId'];
fc7342914cdf develop_v0 Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 28 diff changeset	173 //$this->GetTextFromFileId($_postdata);
fc7342914cdf develop_v0 Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 28 diff changeset	174 //$latest_editing = $this->lg_text;
fc7342914cdf develop_v0 Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 28 diff changeset	175 // get from URL with file_id
fc7342914cdf develop_v0 Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 28 diff changeset	176
fc7342914cdf develop_v0 Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 28 diff changeset	177 $lg_text_url = $this->get_text_from_fileId_url.$current_fileId;
fc7342914cdf develop_v0 Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 28 diff changeset	178 $lg_text = file_get_contents($lg_text_url);
fc7342914cdf develop_v0 Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 28 diff changeset	179
fc7342914cdf develop_v0 Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 28 diff changeset	180 $stringInput = $lg_text;
fc7342914cdf develop_v0 Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 28 diff changeset	181 $stringInput = preg_replace("/ /u", "○", $stringInput);
fc7342914cdf develop_v0 Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 28 diff changeset	182 $stringInput = preg_replace("/\n/u", "<br>", $stringInput);
fc7342914cdf develop_v0 Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 28 diff changeset	183 $stringInput = preg_replace("/【(.*?)】/u", "【<a href=\"review_index_xml_images.php?books_id=".$bookId."&pages=\\1&entry=0\" target=\"_bookImg\">\\1</a>】", $stringInput);
fc7342914cdf develop_v0 Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 28 diff changeset	184 $lg_text = $stringInput;
fc7342914cdf develop_v0 Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 28 diff changeset	185
fc7342914cdf develop_v0 Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 28 diff changeset	186
fc7342914cdf develop_v0 Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 28 diff changeset	187 //var_dump($lg_text);
fc7342914cdf develop_v0 Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 28 diff changeset	188
fc7342914cdf develop_v0 Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 28 diff changeset	189 echo json_encode($lg_text);
fc7342914cdf develop_v0 Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 28 diff changeset	190 //var_dump($this->file_id);
fc7342914cdf develop_v0 Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 28 diff changeset	191
fc7342914cdf develop_v0 Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 28 diff changeset	192 }
fc7342914cdf develop_v0 Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 28 diff changeset	193 */
fc7342914cdf develop_v0 Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 28 diff changeset	194
fc7342914cdf develop_v0 Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 28 diff changeset	195
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	196
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	197 // === 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	198 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	199
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	200 // $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	201
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	202 $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	203 $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	204
6 63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	205
10 54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	206 //$taglistArray = $this->GetTaglistArray();
54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	207 //for GetTaglistByTopicID:
54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	208 $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	209 // topic list
10 54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	210 $topiclistArray = $this->GetTopiclistArray();
9 584b1623e9ef TOC correction list page updated Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	211
6 63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	212
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	213 $wordlistArray = $this->GetWordlistArray();
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 $data = array();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	216 $data['stringInput'] = $stringInput;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	217 $data['taglistArray'] = $taglistArray;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	218 $data['wordlistArray'] = $wordlistArray;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	219 $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	220 $data['topiclistArray'] = $topiclistArray;
54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	221 $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	222 $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	223 $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	224
28 e6e9bdc4f256 update the saving response from LGService between different file version Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 27 diff changeset	225
26 579f03f8bee5 merge table books_info into table books (execute Home/Test) Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 25 diff changeset	226 $data['info'] = array('file_id'=>$this->file_id, 'user_id'=>$this->user_id,
579f03f8bee5 merge table books_info into table books (execute Home/Test) Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 25 diff changeset	227 'branch_id'=>$this->branch_id, 'section_id'=>$this->section_id, 'book_id'=>$this->book_id,
579f03f8bee5 merge table books_info into table books (execute Home/Test) Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 25 diff changeset	228 'book_name'=>$this->book_name, 'section_name'=>$this->section_name,
579f03f8bee5 merge table books_info into table books (execute Home/Test) Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 25 diff changeset	229 'current_fileId'=>$this->current_fileId);
28 e6e9bdc4f256 update the saving response from LGService between different file version Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 27 diff changeset	230 //'current_fileId'=>$this->file_id);
e6e9bdc4f256 update the saving response from LGService between different file version Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 27 diff changeset	231 //'current_fileId'=>'123');
e6e9bdc4f256 update the saving response from LGService between different file version Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 27 diff changeset	232
e6e9bdc4f256 update the saving response from LGService between different file version Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 27 diff changeset	233 $this->messages .= "Info: ";
e6e9bdc4f256 update the saving response from LGService between different file version Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 27 diff changeset	234 $this->messages .= "file_id=".$this->file_id.", section_id=".$this->section_id;
e6e9bdc4f256 update the saving response from LGService between different file version Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 27 diff changeset	235 $this->messages .= ", user_id=".$this->user_id.", branch_id=".$this->branch_id.", topic_id=".$this->topic;
e6e9bdc4f256 update the saving response from LGService between different file version Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 27 diff changeset	236 $this->messages .= ", book_id=".$this->book_id.", book_name=".$this->book_name.", section_name=".$this->section_name;
e6e9bdc4f256 update the saving response from LGService between different file version Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 27 diff changeset	237 $this->messages .= ", current_fileId=".$this->current_fileId."<br>";
27 4a29bccb6c59 modify the SmartRegexSave method to prevent duplicated records in topic_regex_relation table and provide better promting to user to force saving regex file or not Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 26 diff changeset	238
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	239 $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	240
6 63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	241 return $data;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	242
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	243 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	244
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	245 public function SaveFullText($postdata) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	246 if ($postdata['text']){
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	247 $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	248 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	249 $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	250 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	251 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	252
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	253 if (get_magic_quotes_gpc()) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	254 $require = stripslashes($postdata['text']);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	255 } else {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	256 $require = $postdata['text'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	257 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	258
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	259 $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	260 $require = preg_replace('/&/u', "&", $require);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	261 $require = preg_replace("/○/u", " ", $require);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	262 $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	263 $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	264 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	265 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	266
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	267 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	268
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	269 public function UpdateInfoByResponseFromLGService($response) {
29 fc7342914cdf develop_v0 Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 28 diff changeset	270
fc7342914cdf develop_v0 Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 28 diff changeset	271 /*
fc7342914cdf develop_v0 Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 28 diff changeset	272 $response_file = $response["file"];
fc7342914cdf develop_v0 Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 28 diff changeset	273 $response_branch = $response["branch"];
fc7342914cdf develop_v0 Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 28 diff changeset	274
28 e6e9bdc4f256 update the saving response from LGService between different file version Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 27 diff changeset	275
29 fc7342914cdf develop_v0 Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 28 diff changeset	276 $status = (string)$response["status"];
fc7342914cdf develop_v0 Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 28 diff changeset	277
fc7342914cdf develop_v0 Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 28 diff changeset	278 if ((string)$response["status"] == "error") {
28 e6e9bdc4f256 update the saving response from LGService between different file version Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 27 diff changeset	279 $response_currentFile = $response["currentFile"];
e6e9bdc4f256 update the saving response from LGService between different file version Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 27 diff changeset	280
e6e9bdc4f256 update the saving response from LGService between different file version Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 27 diff changeset	281 $this->current_fileId = (string)$response_currentFile['id'];
e6e9bdc4f256 update the saving response from LGService between different file version Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 27 diff changeset	282 $this->messages .= "saving does not success! ".(string)$response["message"];
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	283
28 e6e9bdc4f256 update the saving response from LGService between different file version Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 27 diff changeset	284
e6e9bdc4f256 update the saving response from LGService between different file version Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 27 diff changeset	285 } else {
29 fc7342914cdf develop_v0 Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 28 diff changeset	286
fc7342914cdf develop_v0 Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 28 diff changeset	287 $this->messages .= "saving success.";
fc7342914cdf develop_v0 Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 28 diff changeset	288 var_dump((string)$response_file["id"]);
28 e6e9bdc4f256 update the saving response from LGService between different file version Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 27 diff changeset	289
e6e9bdc4f256 update the saving response from LGService between different file version Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 27 diff changeset	290 $this->file_id = (string)$response_file["id"];
e6e9bdc4f256 update the saving response from LGService between different file version Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 27 diff changeset	291 $this->branch_id = (string)$response_branch["id"];
e6e9bdc4f256 update the saving response from LGService between different file version Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 27 diff changeset	292
e6e9bdc4f256 update the saving response from LGService between different file version Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 27 diff changeset	293 }
29 fc7342914cdf develop_v0 Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 28 diff changeset	294 */
28 e6e9bdc4f256 update the saving response from LGService between different file version Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 27 diff changeset	295
29 fc7342914cdf develop_v0 Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 28 diff changeset	296
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	297 $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	298 $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	299
25 4b6d2d7e706e update for the integration Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 24 diff changeset	300 $status = (string)$response["status"];
4b6d2d7e706e update for the integration Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 24 diff changeset	301 if ($status == "ok") {
4b6d2d7e706e update for the integration Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 24 diff changeset	302 $this->messages .= "saving success.";
28 e6e9bdc4f256 update the saving response from LGService between different file version Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 27 diff changeset	303 $this->file_id = (string)$response_file["id"];
e6e9bdc4f256 update the saving response from LGService between different file version Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 27 diff changeset	304 $this->branch_id = (string)$response_branch["id"];
25 4b6d2d7e706e update for the integration Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 24 diff changeset	305
4b6d2d7e706e update for the integration Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 24 diff changeset	306 } else if ($status == "error") {
4b6d2d7e706e update for the integration Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 24 diff changeset	307 // saving not success
4b6d2d7e706e update for the integration Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 24 diff changeset	308 $this->messages .= "saving does not success! ".(string)$response["message"];
29 fc7342914cdf develop_v0 Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 28 diff changeset	309 $response_currentFile = $response["currentFile"];
fc7342914cdf develop_v0 Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 28 diff changeset	310 //$this->current_fileId = $response["currentFileId"];
fc7342914cdf develop_v0 Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 28 diff changeset	311 $this->current_fileId = (string)$response_currentFile["id"];
fc7342914cdf develop_v0 Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 28 diff changeset	312
25 4b6d2d7e706e update for the integration Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 24 diff changeset	313 }
4b6d2d7e706e update for the integration Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 24 diff changeset	314
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	315
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting 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 }
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting 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 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	318 // 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	319
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting 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 // --------
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting 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 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	322 $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	323 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	324 $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	325 //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	326 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	327 }
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting 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 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	330 $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	331 } 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	332 $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	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
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting 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 $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	336 $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	337 $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	338 $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	339 $require = preg_replace("/<br>/u", "\n", $require);
25 4b6d2d7e706e update for the integration Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 24 diff changeset	340 //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	341 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	342 }
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	343
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	344 // ------
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	345
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	346
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	347 if ($_postdata['branchId'] != 0) {
28 e6e9bdc4f256 update the saving response from LGService between different file version Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 27 diff changeset	348 // -- exiting branch case
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	349 $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	350 "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	351 "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	352 "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	353 "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	354 );
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	355 $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	356
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	357 } else {
28 e6e9bdc4f256 update the saving response from LGService between different file version Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 27 diff changeset	358 // -- new branch case
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	359 echo "saveNew!";
25 4b6d2d7e706e update for the integration Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 24 diff changeset	360 if ($_postdata['userId']) {
4b6d2d7e706e update for the integration Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 24 diff changeset	361 $user_id = $_postdata['userId'];
4b6d2d7e706e update for the integration Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 24 diff changeset	362 } else {
4b6d2d7e706e update for the integration Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 24 diff changeset	363 $user_id = "12";
4b6d2d7e706e update for the integration Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 24 diff changeset	364 }
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	365 $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	366 "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	367 "sectionId" => $_postdata['sectionId'],
25 4b6d2d7e706e update for the integration Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 24 diff changeset	368 "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	369 "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	370 );
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	371 $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	372 }
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	373
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	374
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	375 // 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	376 $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	377 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	378 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	379 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	380 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	381 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	382 //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	383 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	384 '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	385 ));
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	386
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	387 // execute the request
29 fc7342914cdf develop_v0 Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 28 diff changeset	388 $output = curl_exec($ch);
28 e6e9bdc4f256 update the saving response from LGService between different file version Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 27 diff changeset	389
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	390
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	391 // output the profile information - includes the header
29 fc7342914cdf develop_v0 Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 28 diff changeset	392 //echo($output) . PHP_EOL;
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	393
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	394 // 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	395 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	396
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	397 $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	398 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	399
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	400 }
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	401
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	402 // --- 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	403 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	404 $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	405 $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	406 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	407 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	408 }
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 $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	411 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	412 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	413 }
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	414
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	415 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	416 }
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	417 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	418
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	419 // 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	420 $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	421
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	422 // 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	423 $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	424 $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	425 $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	426 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	427 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	428 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	429 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	430 $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	431 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	432 }
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	433 }
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	434 }
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	435 }
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	436 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	437 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	438 }
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	439
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	440
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	441 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	442 if ($_postdata['text']){
27 4a29bccb6c59 modify the SmartRegexSave method to prevent duplicated records in topic_regex_relation table and provide better promting to user to force saving regex file or not Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 26 diff changeset	443
4a29bccb6c59 modify the SmartRegexSave method to prevent duplicated records in topic_regex_relation table and provide better promting to user to force saving regex file or not Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 26 diff changeset	444 // --- update topic_regex_relation table ---
4a29bccb6c59 modify the SmartRegexSave method to prevent duplicated records in topic_regex_relation table and provide better promting to user to force saving regex file or not Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 26 diff changeset	445 $topic_id = $_postdata['topic_id'];
4a29bccb6c59 modify the SmartRegexSave method to prevent duplicated records in topic_regex_relation table and provide better promting to user to force saving regex file or not Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 26 diff changeset	446 $filename = $_postdata['filename'].'.txt';
4a29bccb6c59 modify the SmartRegexSave method to prevent duplicated records in topic_regex_relation table and provide better promting to user to force saving regex file or not Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 26 diff changeset	447
4a29bccb6c59 modify the SmartRegexSave method to prevent duplicated records in topic_regex_relation table and provide better promting to user to force saving regex file or not Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 26 diff changeset	448 // check if already existing a record for this regex file
4a29bccb6c59 modify the SmartRegexSave method to prevent duplicated records in topic_regex_relation table and provide better promting to user to force saving regex file or not Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 26 diff changeset	449 $query = "SELECT * FROM topic_regex_relation WHERE topic_id=".$topic_id." AND regex_filename='".$filename."'";
4a29bccb6c59 modify the SmartRegexSave method to prevent duplicated records in topic_regex_relation table and provide better promting to user to force saving regex file or not Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 26 diff changeset	450 $result = mysql_query($query);
4a29bccb6c59 modify the SmartRegexSave method to prevent duplicated records in topic_regex_relation table and provide better promting to user to force saving regex file or not Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 26 diff changeset	451 if (!$result) {
4a29bccb6c59 modify the SmartRegexSave method to prevent duplicated records in topic_regex_relation table and provide better promting to user to force saving regex file or not Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 26 diff changeset	452 echo json_encode("ErrorDB");
4a29bccb6c59 modify the SmartRegexSave method to prevent duplicated records in topic_regex_relation table and provide better promting to user to force saving regex file or not Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 26 diff changeset	453 }
4a29bccb6c59 modify the SmartRegexSave method to prevent duplicated records in topic_regex_relation table and provide better promting to user to force saving regex file or not Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 26 diff changeset	454 while ($row = mysql_fetch_assoc($result)) {
4a29bccb6c59 modify the SmartRegexSave method to prevent duplicated records in topic_regex_relation table and provide better promting to user to force saving regex file or not Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 26 diff changeset	455 if ($row && !$_postdata['forcesave']) {
4a29bccb6c59 modify the SmartRegexSave method to prevent duplicated records in topic_regex_relation table and provide better promting to user to force saving regex file or not Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 26 diff changeset	456 // promt user a comfirm to force saving or not
4a29bccb6c59 modify the SmartRegexSave method to prevent duplicated records in topic_regex_relation table and provide better promting to user to force saving regex file or not Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 26 diff changeset	457 echo json_encode("ForceSave");
4a29bccb6c59 modify the SmartRegexSave method to prevent duplicated records in topic_regex_relation table and provide better promting to user to force saving regex file or not Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 26 diff changeset	458 return;
4a29bccb6c59 modify the SmartRegexSave method to prevent duplicated records in topic_regex_relation table and provide better promting to user to force saving regex file or not Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 26 diff changeset	459 }
4a29bccb6c59 modify the SmartRegexSave method to prevent duplicated records in topic_regex_relation table and provide better promting to user to force saving regex file or not Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 26 diff changeset	460 }
4a29bccb6c59 modify the SmartRegexSave method to prevent duplicated records in topic_regex_relation table and provide better promting to user to force saving regex file or not Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 26 diff changeset	461
4a29bccb6c59 modify the SmartRegexSave method to prevent duplicated records in topic_regex_relation table and provide better promting to user to force saving regex file or not Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 26 diff changeset	462
4a29bccb6c59 modify the SmartRegexSave method to prevent duplicated records in topic_regex_relation table and provide better promting to user to force saving regex file or not Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 26 diff changeset	463 if (!$_postdata['forcesave']) {
4a29bccb6c59 modify the SmartRegexSave method to prevent duplicated records in topic_regex_relation table and provide better promting to user to force saving regex file or not Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 26 diff changeset	464 $query = "INSERT INTO topic_regex_relation (topic_id, regex_filename) VALUES (".$topic_id.",'".$filename."')";
4a29bccb6c59 modify the SmartRegexSave method to prevent duplicated records in topic_regex_relation table and provide better promting to user to force saving regex file or not Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 26 diff changeset	465 $result = mysql_query($query);
4a29bccb6c59 modify the SmartRegexSave method to prevent duplicated records in topic_regex_relation table and provide better promting to user to force saving regex file or not Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 26 diff changeset	466 if (!$result) {
4a29bccb6c59 modify the SmartRegexSave method to prevent duplicated records in topic_regex_relation table and provide better promting to user to force saving regex file or not Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 26 diff changeset	467 echo json_encode("ErrorDB");
4a29bccb6c59 modify the SmartRegexSave method to prevent duplicated records in topic_regex_relation table and provide better promting to user to force saving regex file or not Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 26 diff changeset	468 }
4a29bccb6c59 modify the SmartRegexSave method to prevent duplicated records in topic_regex_relation table and provide better promting to user to force saving regex file or not Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 26 diff changeset	469 }
4a29bccb6c59 modify the SmartRegexSave method to prevent duplicated records in topic_regex_relation table and provide better promting to user to force saving regex file or not Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 26 diff changeset	470 // --- write to filesystem ---
4a29bccb6c59 modify the SmartRegexSave method to prevent duplicated records in topic_regex_relation table and provide better promting to user to force saving regex file or not Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 26 diff changeset	471
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	472 /*
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	473 $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	474 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	475 $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	476 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	477 }
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	478 */
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	479 $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	480
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	481 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	482 $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	483 } 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	484 $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	485 }
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	486
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	487 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	488
04db1dd9d10d update topic_regex_relation table when saving (new) regex file Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 19 diff changeset	489
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	490 }
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	491 }
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	492
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	493
6 63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	494 // === 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	495 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	496 // $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	497
6 63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	498 $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	499 $topic = $postdata['topic'];
21 c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	500 $section_id = $postdata['sectionId'];
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	501
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	502 //$section_id = $this->section_id;
6 63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	503
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	504
25 4b6d2d7e706e update for the integration Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 24 diff changeset	505 // 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	506 $sectionName = $postdata['sectionName'];
4b6d2d7e706e update for the integration Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 24 diff changeset	507 $bookId = $postdata['bookId'];
4b6d2d7e706e update for the integration Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 24 diff changeset	508 $bookName = $postdata['bookName'];
4b6d2d7e706e update for the integration Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 24 diff changeset	509
4b6d2d7e706e update for the integration Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 24 diff changeset	510
4b6d2d7e706e update for the integration Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 24 diff changeset	511 // --- replace if get info from LGService
4b6d2d7e706e update for the integration Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 24 diff changeset	512 /*
6 63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	513 $section_info = $this->GetSectionInfo();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	514
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	515 $sectionName = $section_info['sectionName'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	516 $bookId = $section_info['bookId'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	517
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	518 $books_info = $this->GetBooksInfo($bookId);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	519 $bookName = $books_info['bookName'];
25 4b6d2d7e706e update for the integration Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 24 diff changeset	520 */
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	521 // =====
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	522
6 63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	523
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	524 $outputTableArray = array();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	525
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	526 //$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	527 $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	528
6 63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	529 $outputTableArray[0]=array();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	530 $outputTableArray[0][0]=array();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	531 $outputTableArray[0][1]=array();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	532 foreach ( $taglistArray as $value ) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	533 $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	534 $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	535 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	536 $outputTableArray[0]["other"] = "其他";
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	537 $outputTableArray[0]["page"] = "頁數";
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	538 $outputTableArray[0]["full"] = "全文";
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	539
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	540 foreach ( $taglistArray as $tagValue ) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	541 $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	542 $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	543 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	544
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	545 $contentLineArray = explode( "<br>", $content );
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 $count=0;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	548 $pageNow=NULL;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	549 foreach ( $contentLineArray as $value ) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	550 $count++;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	551 $recordString = $value;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	552 $otherString = $recordString;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	553 //echo $recordString."<br>\n";
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	554 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	555 $pageNow = $matches[2];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	556 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	557 foreach ( $taglistArray as $tagValue ) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	558 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	559 foreach ( $matches as $matchesValue ) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	560 $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	561 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	562 foreach ( $matches2 as $matches2Value ) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	563 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	564 $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	565 } else {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	566 $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	567 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	568 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	569 } else {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	570 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	571 $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	572 } else {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	573 $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	574 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	575 }
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 $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	578 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	579 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	580 $otherString = preg_replace("/○/u", "", $otherString);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	581 $outputTableArray[$count]["other"] = $otherString;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	582 $outputTableArray[$count]["page"] = $pageNow;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	583 $value = preg_replace("/>/u", ">", $value);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	584 $value = preg_replace("/</u", "<", $value);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	585 $outputTableArray[$count]["full"] = $value;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	586 }
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	587 /*
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	588 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	589 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	590 */
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	591
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	592 $topic_tag = $this->GetTopicTag($topic);
6 63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	593
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	594 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	595 // 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	596 // 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	597 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	598 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	599 }
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	600
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	601 /*
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	602 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	603 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	604 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	605 }
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	606 } 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	607
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	608 // 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	609 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	610 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	611 }
6 63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	612 }
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	613 */
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	614
6 63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	615 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	616
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	617 $data = array();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	618
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	619 $data['outputTableArray'] = $outputTableArray;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	620 $data['bookId'] = $bookId;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	621 $data['section_id'] = $section_id;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	622 $data['bookName'] = $bookName;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	623 $data['sectionName'] = $sectionName;
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 return $data;
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
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	629 // === 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	630 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	631 $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	632 $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	633 if (!$result) {
a8ae5cbc3364 update topic_tag_relation table when adding new tag Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 21 diff changeset	634 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	635 }
a8ae5cbc3364 update topic_tag_relation table when adding new tag Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 21 diff changeset	636 $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	637 $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	638
21 c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	639
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	640 $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	641 $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	642
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	643 $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	644 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	645 $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	646 //$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	647 // 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	648 }
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	649
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	650 /*
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	651 //$result = $this->GetTaglist();
6 63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	652 $taglistArray = array();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	653 while ($row = mysql_fetch_assoc($result)) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	654 $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	655 }
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	656 */
6 63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	657
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	658 $data = array();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	659 $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	660 $data['topic_id'] = $topic_id;
21 c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	661 $data['largest_id'] = $largest_id;
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	662
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	663
6 63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	664 return $data;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	665
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	666 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	667
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	668 private function _GetTag($_postdata) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	669 if (get_magic_quotes_gpc()) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	670 $id = stripslashes($_postdata['id']);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	671 $name = stripslashes($_postdata['name']);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	672 $tag = stripslashes($_postdata['tag']);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	673 $color = stripslashes($_postdata['color']);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	674 } else {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	675 $id = $_postdata['id'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	676 $name = $_postdata['name'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	677 $tag = $_postdata['tag'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	678 $color = $_postdata['color'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	679 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	680 return array($id, $name, $tag, $color);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	681 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	682
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	683 public function NewTagElement($postdata) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	684 if ($postdata['id']){
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	685 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	686
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	687 $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	688 $this->GetSQLValueString($id, "int"),
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	689 $this->GetSQLValueString($name, "text"),
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	690 $this->GetSQLValueString($tag, "text"),
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	691 $this->GetSQLValueString($color, "text"),
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	692 $this->GetSQLValueString($this->systemNAME, "text"));
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	693 $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	694
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	695
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	696 // 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	697 $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	698
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	699 // 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	700 $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	701 $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	702 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	703 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	704 }
6 63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	705 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	706
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	707 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	708
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	709 public function SaveTagElement($postdata) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	710 if ($postdata['id']){
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	711 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	712
19 f60969462226 save tag modification of topic configration into topic_tag_relation table Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 17 diff changeset	713 $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	714 $this->GetSQLValueString($name, "text"),
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	715 $this->GetSQLValueString($tag, "text"),
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	716 $this->GetSQLValueString($color, "text"),
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	717 $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	718 $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	719
6 63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	720 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	721
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	722 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	723
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	724 public function DeleteTag($postdata) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	725 if ($postdata['id']) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	726 $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	727 $resultInsert = mysql_query($queryInsert);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	728 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	729
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	730 }
9 584b1623e9ef TOC correction list page updated Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	731
10 54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	732 // === 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	733 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	734 $topic = $postdata['topic'];
b55f5d3564c4 add some regular expressions and wordlist for topic ?? Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 23 diff changeset	735 $result = $this->GetTopicByID($topic);
b55f5d3564c4 add some regular expressions and wordlist for topic ?? Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 23 diff changeset	736 $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	737 $topic_name = $row['name'];
b55f5d3564c4 add some regular expressions and wordlist for topic ?? Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 23 diff changeset	738
b55f5d3564c4 add some regular expressions and wordlist for topic ?? Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 23 diff changeset	739 /*
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	740 $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	741 $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	742 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	743 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	744 }
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	745 $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	746 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	747 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	748 }
24 b55f5d3564c4 add some regular expressions and wordlist for topic ?? Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 23 diff changeset	749 */
21 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 // ------
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	752 $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	753 $result = mysql_query($query);
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	754 if (!$result) {
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	755 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	756 }
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 $tag_intopic = array();
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	759 $tag_others = array();
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	760 $tag_tmp_others = array();
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	761 while ($row = mysql_fetch_assoc($result)) {
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	762 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	763 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	764 } 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	765 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	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
24 b55f5d3564c4 add some regular expressions and wordlist for topic ?? Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 23 diff changeset	769 // --- 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	770 $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	771 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	772 $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	773 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	774 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	775 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	776 } 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	777 $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	778 }
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	779 }
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	780 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	781 $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	782 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	783 }
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	784 }
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	785
24 b55f5d3564c4 add some regular expressions and wordlist for topic ?? Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 23 diff changeset	786 // --- 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	787 $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	788 $tag_others = array();
21 c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	789
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	790 foreach ($tag_tmp_others as $tmp) {
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	791 $cnt = 0;
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	792 foreach ($tag_intopic as $intopic) {
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	793 if ($tmp['tag'] == $intopic['tag']) {
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	794 break;
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	795 } else {
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	796 $cnt ++;
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 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	800 // not appear in $tag_intopic
21 c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	801 array_push($tag_others, $tmp);
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	802 }
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	803 }
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	804
24 b55f5d3564c4 add some regular expressions and wordlist for topic ?? Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 23 diff changeset	805 // -----
b55f5d3564c4 add some regular expressions and wordlist for topic ?? Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 23 diff changeset	806
b55f5d3564c4 add some regular expressions and wordlist for topic ?? Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 23 diff changeset	807
b55f5d3564c4 add some regular expressions and wordlist for topic ?? Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 23 diff changeset	808 $data = array();
b55f5d3564c4 add some regular expressions and wordlist for topic ?? Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 23 diff changeset	809 //$data['taglistArray'] = $taglistArray;
b55f5d3564c4 add some regular expressions and wordlist for topic ?? Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 23 diff changeset	810 $data['topic'] = $topic;
b55f5d3564c4 add some regular expressions and wordlist for topic ?? Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 23 diff changeset	811 $data['topic_name'] = $topic_name;
21 c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	812
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	813 $data['tag_intopic'] = $tag_intopic;
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	814 $data['tag_others'] = $tag_others;
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	815
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	816 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	817 }
21 c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	818
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	819
19 f60969462226 save tag modification of topic configration into topic_tag_relation table Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 17 diff changeset	820 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	821 $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	822 $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	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 // 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	825 // --- add new topic_tag_relation ---
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	826 foreach ($tag_ids as $tag_id) {
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	827 $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	828 $result = mysql_query($query);
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	829 if (!$result) {
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	830 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	831 }
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	832 $topic_tag = array();
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	833 $flag = false;
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	834 while ($row = mysql_fetch_assoc($result)) {
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	835 if ($row['topic_id'] == $topic_id) {
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	836 $flag = true;
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	837 break;
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	838 }
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	839 }
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	840 if (!$flag) {
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	841 // 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	842 $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	843 $resultUpdate = mysql_query($queryUpdate);
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	844 if (!$resultUpdate) {
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	845 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	846 }
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	847 }
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	848
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	849 }
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	850
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	851 // --- remove tags from this topic ---
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	852 $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	853 $result = mysql_query($query);
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	854 if (!$result) {
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	855 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	856 }
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	857
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	858 while ($row = mysql_fetch_assoc($result)) {
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	859 $cnt = 0;
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	860 foreach ($tag_ids as $tag_id) {
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	861 if ($row['tag_id'] == $tag_id) {
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	862 break;
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	863 } else {
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	864 $cnt ++;
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	865 }
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	866 }
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	867 $_id = $row['id'];
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	868 if ($cnt == count($tag_ids)) {
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	869 // 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	870 $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	871 $resultDelete = mysql_query($queryDelete);
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	872 if (!$resultDelete) {
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	873 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	874 }
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	875 }
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	876 }
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	877
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	878
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	879
c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	880 /*
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	881 $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	882 $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	883 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	884 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	885 }
f60969462226 save tag modification of topic configration into topic_tag_relation table Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 17 diff changeset	886 $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	887 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	888 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	889 }
f60969462226 save tag modification of topic configration into topic_tag_relation table Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 17 diff changeset	890
21 c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	891
19 f60969462226 save tag modification of topic configration into topic_tag_relation table Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 17 diff changeset	892 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	893 $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	894 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	895 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	896 //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	897 $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	898 $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	899 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	900 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	901 }
f60969462226 save tag modification of topic configration into topic_tag_relation table Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 17 diff changeset	902 $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	903 break;
f60969462226 save tag modification of topic configration into topic_tag_relation table Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 17 diff changeset	904 }
f60969462226 save tag modification of topic configration into topic_tag_relation table Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 17 diff changeset	905 }
f60969462226 save tag modification of topic configration into topic_tag_relation table Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 17 diff changeset	906 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	907 // 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	908 $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	909 $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	910 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	911 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	912 }
f60969462226 save tag modification of topic configration into topic_tag_relation table Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 17 diff changeset	913 }
f60969462226 save tag modification of topic configration into topic_tag_relation table Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 17 diff changeset	914 }
21 c805470cefee Remove bootstrap.TaggingText UI layout modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 20 diff changeset	915 */
19 f60969462226 save tag modification of topic configration into topic_tag_relation table Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 17 diff changeset	916
f60969462226 save tag modification of topic configration into topic_tag_relation table Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 17 diff changeset	917 }
f60969462226 save tag modification of topic configration into topic_tag_relation table Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 17 diff changeset	918
9 584b1623e9ef TOC correction list page updated Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	919
584b1623e9ef TOC correction list page updated Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	920 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	921 $taglistArray = array();
54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	922 // 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	923 $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	924 $result = mysql_query($query);
584b1623e9ef TOC correction list page updated Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	925 if (!$result) {
10 54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	926 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	927 }
10 54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	928 $taglist_ids = array();
9 584b1623e9ef TOC correction list page updated Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	929
584b1623e9ef TOC correction list page updated Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	930 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	931 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	932 }
54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	933
54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	934 // select taglist by tag ids
54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	935 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	936 $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	937 $result = mysql_query($query);
54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	938 if (!$result) {
54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	939 echo mysql_error();
9 584b1623e9ef TOC correction list page updated Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	940 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	941 }
10 54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	942
54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	943 $row = mysql_fetch_assoc($result);
54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	944 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	945
9 584b1623e9ef TOC correction list page updated Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	946 }
584b1623e9ef TOC correction list page updated Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	947 return $taglistArray;
10 54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	948 }
9 584b1623e9ef TOC correction list page updated Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	949
10 54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	950 public function SetTopic($topic) {
54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	951 $this->topic = $topic;
54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	952 }
9 584b1623e9ef TOC correction list page updated Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	953
10 54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	954 public function GetTopic() {
54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	955 return $this->topic;
54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	956 }
9 584b1623e9ef TOC correction list page updated Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	957
10 54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	958 private function GetTopiclistArray() {
54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	959 $topiclistArray = array();
54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	960 $result = $this->GetTopiclist();
54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	961 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	962 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	963 }
54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	964 return $topiclistArray;
54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	965 }
9 584b1623e9ef TOC correction list page updated Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 6 diff changeset	966
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	967
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	968 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	969 $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	970 $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	971 $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	972 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	973
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	974 }
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	975 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	976 $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	977 $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	978 $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	979 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	980
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	981 }
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	982
19 f60969462226 save tag modification of topic configration into topic_tag_relation table Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 17 diff changeset	983
6 63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	984 // ===========================
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 // === 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	987 public function EditWordlist() {
6 63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	988 $result = $this->GetWordlist();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	989 $wordlistArray = array();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	990 while ($row = mysql_fetch_assoc($result)) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	991 $wordlistArray[$row['id']] = $row['name'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	992 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	993
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	994 $data = array();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	995 $data['wordlistArray'] = $wordlistArray;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	996 return $data;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	997 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	998
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	999
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1000 public function AddNewList($postdata) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1001 if ($postdata['text']){
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1002 if (get_magic_quotes_gpc()) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1003 $name = stripslashes($postdata['text']);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1004 } else {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1005 $name = $postdata['text'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1006 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1007
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1008 $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	1009 $this->GetSQLValueString($name, "text"),
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1010 $this->GetSQLValueString($this->systemNAME, "text"));
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1011 $result1 = mysql_query($query1);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1012 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	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
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1016
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1017 public function SaveWordlist($postdata) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1018
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1019 if ($postdata['text']){
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1020 $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	1021 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	1022 $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	1023 $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	1024 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	1025 }
b55f5d3564c4 add some regular expressions and wordlist for topic ?? Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 23 diff changeset	1026 /*else {
6 63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1027 $filename = "data/wordlist/".$postdata['filename'].".txt";
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1028 }
24 b55f5d3564c4 add some regular expressions and wordlist for topic ?? Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 23 diff changeset	1029 */
6 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
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1032 if (get_magic_quotes_gpc()) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1033 $require = stripslashes($postdata['text']);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1034 } else {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1035 $require = $postdata['text'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1036 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1037
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1038 $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	1039 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	1040 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1041 /*
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1042 if ($postdata['text']){
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1043 $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	1044 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	1045 $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	1046 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	1047 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1048
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1049 if (get_magic_quotes_gpc()) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1050 $require = stripslashes($postdata['text']);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1051 } else {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1052 $require = $postdata['text'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1053 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1054
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1055 // $require = preg_replace("/<br>/u", "", $require);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1056 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	1057 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1058 */
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1059 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1060
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1061
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1062 // =======================================
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1063
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1064 public function sortFunction($a,$b) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1065 return strlen($b)-strlen($a);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1066 }
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 // TODO: delete this
6 63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1069 private function SetSectionId($_urlvalues) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1070 // TODO: maybe get user info also
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1071 // get book id from url
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1072 if ($_urlvalues['id'] != "") {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1073 $section_id = $_urlvalues['id'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1074 } else {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1075 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	1076 /* ???? */
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1077 /*
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1078 $get_book_id = $urlvalues['book'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1079 $get_start = $urlvalues['start'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1080 $get_end = $urlvalues['end'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1081 */
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 $this->section_id = $section_id;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1084
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1085 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1086
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1087 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	1088
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	1089 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	1090 return $this->section_id;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1091 } else {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1092 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	1093 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1094 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1095
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1096 private function GetSectionInfo() {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1097 $section_id = $this->GetSectionId();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1098 if (!is_numeric($section_id)){
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1099 return $section_id;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1100 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1101
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1102 $result = $this->GetSectionsByID($section_id);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1103
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 while ($row = mysql_fetch_assoc($result)) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1106 $bookId=$row['books_id'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1107 $startPage=$row['start_page'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1108 $endPage=$row['end_page'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1109 $sectionName = $row['name'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1110 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1111
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1112 $data = array();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1113 $data['bookId'] = $bookId;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1114 $data['startPage'] = $startPage;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1115 $data['endPage'] = $endPage;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1116 $data['sectionName'] = $sectionName;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1117
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	1118
6 63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1119 return $data;
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
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1122 private function GetSectionContent() {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1123 $section_id = $this->GetSectionId();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1124 $section_info = $this->GetSectionInfo();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1125
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1126 $bookId = $section_info['bookId'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1127 $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	1128 $endPage = $section_info['endPage'];
6 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 $contentString="";
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1131 $data_path = $this->GetDataPath();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1132 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	1133 $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	1134 $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	1135
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	1136 // 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	1137 $stringInput = preg_replace("/ /u", "○", $stringInput);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1138 $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	1139 $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	1140 } else {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1141 $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	1142 $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	1143 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	1144 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	1145 }
6 63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1146 while ($row = mysql_fetch_assoc($result)) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1147 $contentString.="【".$row['line']."】".$row['content']."\n";
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1148 }
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	1149
e82ca7375e93 Integration with LocalGazetteerService (LGService), getting text from LGService and saving text to LGService. Adjust the control flow (controller). Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 11 diff changeset	1150 // the text is from database
6 63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1151 $stringInput = $contentString;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1152 $stringInput = preg_replace("/<(.*?)>/u", "○", $stringInput);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1153 $stringInput = preg_replace("/ /u", "○", $stringInput);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1154 $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	1155 $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	1156 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1157
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1158 return $stringInput;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1159 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1160
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1161 private function GetDataPath() {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1162 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	1163 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1164
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1165 private function GetTaglistArray() {
10 54a235d43694 add topic choosing in the TaggingText page Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 9 diff changeset	1166 $taglistArray = array();
6 63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1167 $result = $this->GetTaglist();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1168 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	1169 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	1170 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1171
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1172 return $taglistArray;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1173 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1174
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1175 private function GetWordlistArray() {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1176 $wordlistArray="";
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1177 $result = $this->GetWordlist();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1178 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	1179 $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	1180 $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	1181 $listString = preg_replace("/<\/div>/u", "", $listString);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1182 $listString = preg_replace("/<span(.*?)>/u", "", $listString);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1183 $listString = preg_replace("/<\/span>/u", "", $listString);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1184 //$listString = preg_replace("/\n/u", "\|", $listString);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1185
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1186 $wordlistArray2 = explode( "\n", $listString );
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1187 usort($wordlistArray2,'sortFunction');
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1188 foreach ( $wordlistArray2 as $index=>$value ) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1189 $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	1190 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1191 foreach ( $wordlistArray2 as $index=>$value ) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1192 if ($value=="") unset($wordlistArray2[$index]);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1193
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1194 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1195 $listString = implode("\|", $wordlistArray2);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1196
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1197 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	1198 $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	1199 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1200
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1201
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1202 return $wordlistArray;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1203
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1204 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1205
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1206 protected function GetBooksInfo($bookId) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1207 $result = $this->GetSectionsByID($bookId);
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1208 while ($row = mysql_fetch_assoc($result)) {
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1209 $bookName = $row['name'];
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1210 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1211
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1212 $data = array();
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1213 $data['bookName'] = $bookName;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1214
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1215 return $data;
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1216 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1217
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1218
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1219 }
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1220
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1221
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1222
63e08b98032f rewrite extraction interface into PHP MVC architecture. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1223 ?>

Mercurial > hg > extraction-interface

annotate develop/models/extractapp.php @ 38:4b3da4802998 extractapp