extraction-interface: models/extractapp.php annotate

annotate models/extractapp.php @ 54:f9e7119339b2 extractapp

bug fixed: when addTagTitle, removing self-closing tag which causes error in coloring tag

author	Zoe Hong <zhong@mpiwg-berlin.mpg.de>
date	Mon, 30 Mar 2015 15:34:47 +0200
parents	f9594c240826
children	e930eb88b547

rev	line source
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	2
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	3 <?php
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	4
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	5 class ExtractappModel extends BaseModel{
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	6
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	7 public function Index() {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	8 return array("Index Value 1", "Value 2", "Value 3");
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	9 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	10
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	11 protected $section_id = 0, $data_path, $file_id = 0, $current_fileId=0,
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	12 $branch_id = 0, $user_id = 0, $lg_text = "", $topic, $taglist_infile = "", $book_meta = "";
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	13 public $messages = "";
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	14
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	15 private function Initialize($_urlvalues) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	16 $this->SetSectionId($_urlvalues);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	17
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	18 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	19
53 f9594c240826 get/update text after saving, for xml file consistency Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 52 diff changeset	20 public function GetTextFromFileId() { // remove $_postdata as input
f9594c240826 get/update text after saving, for xml file consistency Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 52 diff changeset	21 /*
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	22 $this->file_id = $_postdata['fileId'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	23 $branch_id = $_postdata['branchId'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	24 $section_id = $_postdata['sectionId'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	25
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	26 $this->branch_id = $branch_id;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	27 $this->user_id = $_postdata['userId'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	28 $this->section_id = $section_id;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	29
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	30 $this->section_name = $_postdata['sectionName'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	31 $this->book_id = $_postdata['bookId'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	32 $this->book_name = $_postdata['bookName'];
53 f9594c240826 get/update text after saving, for xml file consistency Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 52 diff changeset	33 */
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	34
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	35 // get from URL with file_id
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	36 $lg_text_url = $this->get_text_from_fileId_url.$this->file_id;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	37 //$lg_text = file_get_contents($lg_text_url);
51 840cdb52f476 add book_meta into file Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 48 diff changeset	38 // --- get/set text and parsing meta data from text file
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	39 $lg_text = $this->ParseMetaData($lg_text_url);
51 840cdb52f476 add book_meta into file Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 48 diff changeset	40 // TODO: maybe need to check if the book_meta is updated. compare the book_meta in text file and from _post (most up-to-date)
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	41
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	42 // ----
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	43
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	44
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	45 $stringInput = $lg_text;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	46 $stringInput = preg_replace("/ /u", "○", $stringInput);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	47 $stringInput = preg_replace("/\n/u", "<br>", $stringInput);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 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);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	49 $lg_text = $stringInput;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	50
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	51 $this->lg_text = $lg_text;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	52
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	53 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	54
53 f9594c240826 get/update text after saving, for xml file consistency Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 52 diff changeset	55 public function GetTextFromSectionId() { // remove $_postdata as input
f9594c240826 get/update text after saving, for xml file consistency Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 52 diff changeset	56 /*
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	57 $section_id = $_postdata['sectionId'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	58 $this->section_id = $section_id;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	59 $this->user_id = $_postdata['userId'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	60
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	61 $this->section_name = $_postdata['sectionName'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	62 $this->book_id = $_postdata['bookId'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	63 $this->book_name = $_postdata['bookName'];
53 f9594c240826 get/update text after saving, for xml file consistency Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 52 diff changeset	64 */
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	65
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	66 // get from URL with file_id
53 f9594c240826 get/update text after saving, for xml file consistency Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 52 diff changeset	67 // $lg_text_url = $this->get_text_from_sectionId_url.$section_id;
f9594c240826 get/update text after saving, for xml file consistency Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 52 diff changeset	68 $lg_text_url = $this->get_text_from_sectionId_url.$this->section_id;
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	69 $lg_text = file_get_contents($lg_text_url);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	70
51 840cdb52f476 add book_meta into file Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 48 diff changeset	71 // TODO: get book_meta from $_postdata and set $this->book_meta: book_id,book_name,author,year,pagenumber
840cdb52f476 add book_meta into file Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 48 diff changeset	72 $book_meta = array();
53 f9594c240826 get/update text after saving, for xml file consistency Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 52 diff changeset	73 array_push($book_meta, array($this->book_id,$this->book_name,"no_data","no_data","no_data")); // missing author,year,pagenumber
51 840cdb52f476 add book_meta into file Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 48 diff changeset	74
840cdb52f476 add book_meta into file Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 48 diff changeset	75 $this->book_meta = $book_meta;
840cdb52f476 add book_meta into file Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 48 diff changeset	76
840cdb52f476 add book_meta into file Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 48 diff changeset	77
840cdb52f476 add book_meta into file Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 48 diff changeset	78
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	79 $stringInput = $lg_text;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	80 $stringInput = preg_replace("/<(.*?)>/u", "○", $stringInput);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	81 $stringInput = preg_replace("/ /u", "○", $stringInput);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	82 $stringInput = preg_replace("/\n/u", "<br>", $stringInput);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	83 $stringInput = preg_replace("/【(.*?)】/u", "【<a href=\"review_index_xml_images.php?books_id=".$bookId."&pages=\\1&entry=0\" target=\"_bookImg\">\\1</a>】", $stringInput);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	84 $lg_text = $stringInput;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	85
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	86 $this->lg_text = $lg_text;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	87 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	88
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	89 public function GetTextFromLocal($_id){
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	90 $this->section_id = $_id;
54 f9e7119339b2 bug fixed: when addTagTitle, removing self-closing tag which causes error in coloring tag Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 53 diff changeset	91 $this->branch_id = 1; // local test sets branch_id to 1
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	92 $this->messages .= "DEBUG: from my local"."<br>";
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	93 $this->lg_text = $this->GetSectionContent();
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	94
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	95 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	96
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	97 public function GetInfoFromPreviousPage($_postdata) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	98
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	99 if ($_postdata['fileId']) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	100 $this->file_id = $_postdata['fileId'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	101 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	102 if ($_postdata['sectionId']) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	103 $this->section_id = $_postdata['sectionId'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	104 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	105 if ($_postdata['text']) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	106 $this->lg_text = $_postdata['text'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	107 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	108 if ($_postdata['branchId']) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	109 $this->branch_id = $_postdata['branchId'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	110 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	111 if ($_postdata['userId']) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	112 $this->user_id = $_postdata['userId'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	113 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	114 if ($_postdata['topic_id']) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	115 $this->topic = $_postdata['topic_id'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	116 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	117
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	118 if ($_postdata['sectionName']) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	119 $this->section_name = $_postdata['sectionName'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	120 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	121 if ($_postdata['bookName']) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	122 $this->book_name = $_postdata['bookName'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	123 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	124 if ($_postdata['bookId']) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	125 $this->book_id = $_postdata['bookId'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	126 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	127 if ($_postdata['currentFileId']) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	128 $this->current_fileId = $_postdata['currentFileId'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	129 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	130 if ($_postdata['taglistArray']) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	131 $this->taglist_infile = json_decode($_postdata['taglistArray']);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	132 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	133 if ($_postdata['book_meta']) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	134 $this->book_meta = json_decode($_postdata['book_meta']);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	135 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	136
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	137 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	138 public function InitData($_postdata) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	139 $file_id = $_postdata['fileId'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	140 $branch_id = $_postdata['branchId'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	141 $section_id = $_postdata['sectionId'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	142
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	143 $this->branch_id = $branch_id;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	144 $this->file_id = $file_id;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	145 $this->user_id = $_postdata['userId'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	146 $this->section_id = $section_id;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	147
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	148 if ($file_id != 0 && $branch_id != 0) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	149 // get from URL with file_id
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	150 $lg_text_url = $this->get_text_from_fileId_url.$file_id;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	151 } else if ($section_id != 0) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	152 // get from URL with section_id
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	153 $lg_text_url = $this->get_text_from_sectionId_url.$section_id;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	154 } else {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	155 echo "wrong url!!";
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	156 return;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	157 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	158
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	159
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	160 $lg_text = file_get_contents($lg_text_url);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	161
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	162 /*
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	163 $stringInput = preg_replace("/ /u", "○", $stringInput);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	164 $stringInput = preg_replace("/\n/u", "<br>", $stringInput);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	165 $stringInput = preg_replace("/【(.*?)】/u", "【<a href=\"review_index_xml_images.php?books_id=".$bookId."&pages=\\1&entry=0\" target=\"_bookImg\">\\1</a>】", $stringInput);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	166 */
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	167
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	168 // the text is from database
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	169 $stringInput = $lg_text;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	170 $stringInput = preg_replace("/<(.*?)>/u", "○", $stringInput);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	171 $stringInput = preg_replace("/ /u", "○", $stringInput);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	172 $stringInput = preg_replace("/\n/u", "<br>", $stringInput);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	173 $stringInput = preg_replace("/【(.*?)】/u", "【<a href=\"review_index_xml_images.php?books_id=".$bookId."&pages=\\1&entry=0\" target=\"_bookImg\">\\1</a>】", $stringInput);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	174 $lg_text = $stringInput;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	175
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	176 $this->lg_text = $lg_text;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	177
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	178
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	179 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	180 /*
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	181 public function Reload($_postdata) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	182
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	183 // update text using $this->current_fileId
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	184 // getTextbyFileId
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	185 $current_fileId = $_postdata['currentFileId'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	186 //$this->file_id = $_postdata['currentFileId'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	187 //$this->GetTextFromFileId($_postdata);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	188 //$latest_editing = $this->lg_text;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	189 // get from URL with file_id
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	190
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	191 $lg_text_url = $this->get_text_from_fileId_url.$current_fileId;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	192 $lg_text = file_get_contents($lg_text_url);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	193
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	194 $stringInput = $lg_text;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	195 $stringInput = preg_replace("/ /u", "○", $stringInput);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	196 $stringInput = preg_replace("/\n/u", "<br>", $stringInput);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	197 $stringInput = preg_replace("/【(.*?)】/u", "【<a href=\"review_index_xml_images.php?books_id=".$bookId."&pages=\\1&entry=0\" target=\"_bookImg\">\\1</a>】", $stringInput);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	198 $lg_text = $stringInput;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	199
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	200
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	201 //var_dump($lg_text);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	202
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	203 echo json_encode($lg_text);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	204 //var_dump($this->file_id);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	205
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	206 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	207 */
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	208
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	209
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	210 // TODO: comparison not correct
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	211 private function Taglist_infileUpToDate($taglistArray) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	212 // compare $this->taglist_infile is the same as $taglistArray
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	213 $taglist_infile = $this->taglist_infile;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	214 if (count($taglist_infile) != count($taglistArray)) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	215 return false;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	216 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	217
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	218 foreach ($taglistArray as $row_indb) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	219 $cnt = 0;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	220 foreach ($taglist_infile as $row) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	221 //$taglistArray: array( $row['id'], $row['name'], $row['tag'], $row['color'] )
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	222 if ($row[0] == $row_indb[0] && $row[1] == $row_indb[1] && $row[2] == $row_indb[2] && $row[3] == $row_indb[3]) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	223
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	224 } else {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	225 $cnt ++;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	226 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	227 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	228 if ($cnt == count($row)) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	229 return false;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	230 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	231 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	232 return true;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	233 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	234 // === for tagging ===
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	235 public function StartTagging() {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	236
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	237 $section_id = $this->section_id;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	238 $stringInput = $this->lg_text;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	239
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	240 $data = array(); // data array to be passed to view
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	241
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	242 //$taglistArray = $this->GetTaglistArray();
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	243 //for GetTaglistByTopicID:
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	244 $taglistArray = $this->GetTaglistByTopicID($this->GetTopic());
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	245
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	246 $data['taglist_infile'] = $this->taglist_infile;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	247 // TODO: check if taglist_infile is up-to-date
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	248 /*
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	249 if ( !$this->Taglist_infileUpToDate($taglistArray)) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	250 $data['taglist_infile'] = $this->taglist_infile;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	251 } else {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	252 $data['taglist_infile'] = "";
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	253 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	254 */
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	255
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	256 // book_meta
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	257 $data['book_meta'] = $this->book_meta;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	258
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	259 // topic list
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	260 $topiclistArray = $this->GetTopiclistArray();
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	261
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	262
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	263 $wordlistArray = $this->GetWordlistArray();
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	264
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	265 $data['stringInput'] = $stringInput;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	266 $data['taglistArray'] = $taglistArray;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	267 $data['wordlistArray'] = $wordlistArray;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	268 $data['section_id'] = $section_id;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	269 $data['topiclistArray'] = $topiclistArray;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	270 $data['default_topic_id'] = $this->GetTopic();
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	271 $data['topic_tag'] = $this->GetTopicTag($this->GetTopic());
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	272 $data['topic_name'] = $this->GetTopicName($this->GetTopic());
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	273
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	274
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	275 $data['info'] = array('file_id'=>$this->file_id, 'user_id'=>$this->user_id,
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	276 'branch_id'=>$this->branch_id, 'section_id'=>$this->section_id, 'book_id'=>$this->book_id,
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	277 'book_name'=>$this->book_name, 'section_name'=>$this->section_name,
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	278 'current_fileId'=>$this->current_fileId);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	279 //'current_fileId'=>$this->file_id);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	280 //'current_fileId'=>'123');
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	281
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	282 $this->messages .= "Info: ";
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	283 $this->messages .= "file_id=".$this->file_id.", section_id=".$this->section_id;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	284 $this->messages .= ", user_id=".$this->user_id.", branch_id=".$this->branch_id.", topic_id=".$this->topic;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	285 $this->messages .= ", book_id=".$this->book_id.", book_name=".$this->book_name.", section_name=".$this->section_name;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	286 $this->messages .= ", current_fileId=".$this->current_fileId."<br>";
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	287
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	288 $data['messages'] = $this->messages;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	289
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	290 return $data;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	291
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	292 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	293
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	294 public function SaveFullText($postdata) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	295 if ($postdata['text']){
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	296 $date = date('Y_m_d_H_i_s', time());
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	297 if ( file_exists("data/parsing_files/".$postdata['filename'].".txt") ) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	298 $oldFile = file_get_contents("data/parsing_files/".$postdata['filename'].".txt");
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	299 file_put_contents("data/parsing_files/".$postdata['filename']."_".$date.".txt", $oldFile);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	300 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	301
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	302 if (get_magic_quotes_gpc()) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	303 $require = stripslashes($postdata['text']);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	304 } else {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	305 $require = $postdata['text'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	306 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	307
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	308 $require = preg_replace("/【<a(.?)>(.?)<\/a>】/u", "【\\2】", $require);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	309 $require = preg_replace('/&/u', "&", $require);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	310 $require = preg_replace("/○/u", " ", $require);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	311 $require = preg_replace("/<br>/u", "\n", $require);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	312 $require = preg_replace("/<br>/u", "\n", $require);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	313 file_put_contents("data/parsing_files/".$postdata['filename'].".txt", $require);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	314 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	315
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	316 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	317
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	318 public function UpdateInfoByResponseFromLGService($response) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	319
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	320 /*
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	321 $response_file = $response["file"];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	322 $response_branch = $response["branch"];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	323
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	324
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	325 $status = (string)$response["status"];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	326
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	327 if ((string)$response["status"] == "error") {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	328 $response_currentFile = $response["currentFile"];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	329
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	330 $this->current_fileId = (string)$response_currentFile['id'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	331 $this->messages .= "saving does not success! ".(string)$response["message"];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	332
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	333
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	334 } else {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	335
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	336 $this->messages .= "saving success.";
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	337 var_dump((string)$response_file["id"]);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	338
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	339 $this->file_id = (string)$response_file["id"];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	340 $this->branch_id = (string)$response_branch["id"];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	341
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	342 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	343 */
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	344
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	345
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	346 $response_file = $response["file"];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	347 $response_branch = $response["branch"];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	348
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	349 $status = (string)$response["status"];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	350 if ($status == "ok") {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	351 $this->messages .= "saving success.";
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	352 $this->file_id = (string)$response_file["id"];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	353 $this->branch_id = (string)$response_branch["id"];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	354
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	355 } else if ($status == "error") {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	356 // saving not success
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	357 $this->messages .= "saving does not success! ".(string)$response["message"];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	358 $response_currentFile = $response["currentFile"];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	359 //$this->current_fileId = $response["currentFileId"];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	360 $this->current_fileId = (string)$response_currentFile["id"];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	361
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	362 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	363
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	364
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	365 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	366 private function AppendMetaData($text_content) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	367 $text = '<?xml version="1.0" encoding="UTF-8"?>';
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	368 $text .= "\n<text>\n";
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	369 // topic
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	370 $text .= "<topic>".$this->topic."</topic>\n";
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	371 // book meta data
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	372 $book = $this->book_meta;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	373 foreach ($book as $b) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	374 $text .= "<book>\n";
51 840cdb52f476 add book_meta into file Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 48 diff changeset	375 $text .= "<id>".$b[0]."</id>\n";
840cdb52f476 add book_meta into file Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 48 diff changeset	376 $text .= "<name>".$b[1]."</name>\n";
840cdb52f476 add book_meta into file Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 48 diff changeset	377 $text .= "<author>".$b[2]."</author>\n";
840cdb52f476 add book_meta into file Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 48 diff changeset	378 $text .= "<year>".$b[3]."</year>\n";
840cdb52f476 add book_meta into file Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 48 diff changeset	379 $text .= "<pagenumber>".$b[4]."</pagenumber>\n";
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	380 $text .= "</book>\n";
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	381 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	382 // taglist
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	383 $taglist = $this->taglist_infile;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	384 foreach ($taglist as $tagitem) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	385 $text .= "<tagitem>\n";
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	386 $text .= "<id>".$tagitem[0]."</id>\n";
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	387 $text .= "<name>".$tagitem[1]."</name>\n";
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	388 $text .= "<tag>".$tagitem[2]."</tag>\n";
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	389 $text .= "<color>".$tagitem[3]."</color>\n";
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	390 $text .= "</tagitem>\n";
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	391 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	392
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	393 // text_content
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	394 $text .= $text_content;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	395 $text .= "\n</text>";
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	396
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	397 return $text;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	398 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	399 public function SaveFullTextToLGService($_postdata) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	400 // save tagged text (full text) by Jorge's API to lg service
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	401 // --------
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	402 if ($_postdata['text']){
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	403 $date = date('Y_m_d_H_i_s', time());
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	404 if ( file_exists("data/parsing_files/".$_postdata['sectionId'].".txt") ) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	405 $oldFile = file_get_contents("data/parsing_files/".$_postdata['sectionId'].".txt");
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	406 //saving in my local machine in developing phrase
54 f9e7119339b2 bug fixed: when addTagTitle, removing self-closing tag which causes error in coloring tag Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 53 diff changeset	407 file_put_contents("data/parsing_files/".$_postdata['sectionId']."_".$date.".txt", $oldFile);
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	408 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	409
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	410 if (get_magic_quotes_gpc()) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	411 $require = stripslashes($_postdata['text']);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	412 } else {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	413 $require = $_postdata['text'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	414 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	415
54 f9e7119339b2 bug fixed: when addTagTitle, removing self-closing tag which causes error in coloring tag Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 53 diff changeset	416 echo "Debug: (full text before) ". $require;
f9e7119339b2 bug fixed: when addTagTitle, removing self-closing tag which causes error in coloring tag Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 53 diff changeset	417
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	418 $require = preg_replace("/【<a(.?)>(.?)<\/a>】/u", "【\\2】", $require);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	419 $require = preg_replace('/&/u', "&", $require);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	420 $require = preg_replace("/○/u", " ", $require);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	421 $require = preg_replace("/<br>/u", "\n", $require);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	422 //$require = preg_replace("/<br>/u", "\n", $require);
54 f9e7119339b2 bug fixed: when addTagTitle, removing self-closing tag which causes error in coloring tag Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 53 diff changeset	423
f9e7119339b2 bug fixed: when addTagTitle, removing self-closing tag which causes error in coloring tag Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 53 diff changeset	424 echo "----------------------------------<br>";
f9e7119339b2 bug fixed: when addTagTitle, removing self-closing tag which causes error in coloring tag Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 53 diff changeset	425 echo "Debug: (full text after) ". $require;
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	426
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	427 if ($_postdata['branchId'] == 0) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	428 // -- new branch case
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	429 $require = "<text_content>\n".$require."</text_content>\n";
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	430 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	431 $require = $this->AppendMetaData($require);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	432
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	433 //saving in my local machine in developing phrase
54 f9e7119339b2 bug fixed: when addTagTitle, removing self-closing tag which causes error in coloring tag Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 53 diff changeset	434 file_put_contents("data/parsing_files/".$_postdata['sectionId'].".txt", $require);
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	435 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	436
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	437 // ------
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	438
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	439
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	440 if ($_postdata['branchId'] != 0) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	441 // -- exiting branch case
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	442 $postfields = array(
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	443 "text" => $require,
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	444 "branchId" => $_postdata['branchId'],
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	445 "userId" => $_postdata['userId'],
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	446 "userPreviousFileId" => $_postdata['fileId'],
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	447 );
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	448 $save_url = $this->save_to_LGService_url;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	449
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	450 } else {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	451 // -- new branch case
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	452 echo "saveNew!";
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	453 $user_id = "0";
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	454 if ($_postdata['userId']) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	455 $user_id = $_postdata['userId'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	456 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	457
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	458 $postfields = array(
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	459 "text" => $require,
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	460 "sectionId" => $_postdata['sectionId'],
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	461 "userId" => $user_id,
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	462 "label" => $_postdata['label'],
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	463 );
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	464 $save_url = $this->save_new_to_LGService_url;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	465 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	466
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	467
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	468 // set up the curl resource
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	469 $ch = curl_init();
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	470 curl_setopt($ch, CURLOPT_URL, $save_url);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	471 curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	472 curl_setopt($ch, CURLOPT_CUSTOMREQUEST, "POST");
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	473 curl_setopt($ch, CURLOPT_POST, true);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	474 curl_setopt($ch, CURLOPT_POSTFIELDS, $postfields);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	475 //curl_setopt($ch, CURLOPT_HEADER, true);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	476 curl_setopt($ch, CURLOPT_HTTPHEADER, array(
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	477 'Content-type: multipart/form-data;charset=utf-8'
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	478 ));
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	479
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	480 // execute the request
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	481 // ** commended to DEBUG *
54 f9e7119339b2 bug fixed: when addTagTitle, removing self-closing tag which causes error in coloring tag Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 53 diff changeset	482 //$output = curl_exec($ch);
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	483 // *****
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	484
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	485 // output the profile information - includes the header
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	486 //echo($output) . PHP_EOL;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	487
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	488 // close curl resource to free up system resources
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	489 curl_close($ch);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	490
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	491 $response = json_decode($output, true);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	492 return $response;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	493
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	494 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	495
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	496 // --- for regex ----
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	497 public function GetRegexFilenameById($topic_id) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	498 $query = sprintf("SELECT regex_filename FROM `topic_regex_relation` WHERE topic_id=\"%s\"", $topic_id);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	499 $result = mysql_query($query);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	500 if (!$result) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	501 return json_encode("Failed during selecting topic_regex_relation table.");
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	502 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	503
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	504 $filenames = array();
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	505 while ($row = mysql_fetch_assoc($result)) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	506 array_push($filenames, $row['regex_filename']);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	507 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	508
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	509 return $filenames;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	510 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	511 public function SmartRegexLoad($topic_id) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	512
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	513 // Load regex file based on current topic. Only shows the regex in this topic --
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	514 $filenames = $this->GetRegexFilenameById($topic_id);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	515
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	516 // Get regex file from filesystem ----
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	517 $data_path = "./data/"; // get the current file path, which is getcwd(), and concatenate with "/data/"
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	518 $returnArray = array();
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	519 $files1 = scandir($data_path."regex_files");
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	520 foreach ( $files1 as $file ) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	521 if ( $file != "." && $file != ".." && $file != ".DS_Store") {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	522 foreach ($filenames as $filename) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	523 if ($file == $filename) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	524 $returnArray[preg_replace("/\.txt/", "", $file)] = file_get_contents( $data_path."regex_files/".$file );
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	525 break;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	526 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	527 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	528 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	529 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	530 echo json_encode($returnArray);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	531 return;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	532 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	533
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	534
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	535 public function SmartRegexSave($_postdata) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	536 if ($_postdata['text']){
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	537
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	538 // --- update topic_regex_relation table ---
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	539 $topic_id = $_postdata['topic_id'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	540 $filename = $_postdata['filename'].'.txt';
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	541
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	542 // check if already existing a record for this regex file
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	543 $query = "SELECT * FROM topic_regex_relation WHERE topic_id=".$topic_id." AND regex_filename='".$filename."'";
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	544 $result = mysql_query($query);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	545 if (!$result) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	546 echo json_encode("ErrorDB");
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	547 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	548 while ($row = mysql_fetch_assoc($result)) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	549 if ($row && !$_postdata['forcesave']) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	550 // promt user a comfirm to force saving or not
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	551 echo json_encode("ForceSave");
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	552 return;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	553 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	554 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	555
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	556
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	557 if (!$_postdata['forcesave']) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	558 $query = "INSERT INTO topic_regex_relation (topic_id, regex_filename) VALUES (".$topic_id.",'".$filename."')";
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	559 $result = mysql_query($query);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	560 if (!$result) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	561 echo json_encode("ErrorDB");
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	562 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	563 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	564 // --- write to filesystem ---
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	565
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	566 /*
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	567 $date = date('Y_m_d_H_i_s', time());
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	568 if ( file_exists("regex_files/".$_POST['filename'].".txt") ) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	569 $oldFile = file_get_contents("regex_files/".$_POST['filename'].".txt");
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	570 file_put_contents("regex_files/".$_POST['filename']."_".$date.".txt", $oldFile);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	571 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	572 */
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	573 $data_path = "./data/"; // get the current file path, which is getcwd(), and concatenate with "/data/"
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	574
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	575 if (get_magic_quotes_gpc()) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	576 $require = stripslashes($_postdata['text']);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	577 } else {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	578 $require = $_postdata['text'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	579 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	580
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	581 file_put_contents( $data_path."regex_files/".$_postdata['filename'].".txt", $require);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	582
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	583
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	584 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	585 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	586
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	587
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	588 // === for export table ===
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	589 public function ExportTable($postdata) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	590 // $this->Initialize($urlvalues);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	591
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	592 $content = $postdata['content'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	593 $topic = $postdata['topic'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	594 $section_id = $postdata['sectionId'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	595
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	596 //$section_id = $this->section_id;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	597
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	598
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	599 // TODO: this should be get from LGService: sectionName, bookId, bookName
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	600 $sectionName = $postdata['sectionName'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	601 $bookId = $postdata['bookId'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	602 $bookName = $postdata['bookName'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	603
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	604
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	605 // --- replace if get info from LGService
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	606 /*
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	607 $section_info = $this->GetSectionInfo();
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	608
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	609 $sectionName = $section_info['sectionName'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	610 $bookId = $section_info['bookId'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	611
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	612 $books_info = $this->GetBooksInfo($bookId);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	613 $bookName = $books_info['bookName'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	614 */
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	615 // =====
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	616
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	617
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	618 $outputTableArray = array();
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	619
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	620 //$taglistArray = $this->GetTaglistArray();
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	621 $taglistArray = $this->GetTaglistByTopicID($topic);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	622
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	623 $outputTableArray[0]=array();
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	624 $outputTableArray[0][0]=array();
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	625 $outputTableArray[0][1]=array();
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	626 foreach ( $taglistArray as $value ) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	627 $outputTableArray[0][0][$value[2]] = $value[1];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	628 $outputTableArray[0][1][$value[2]] = $value[1]."(Title)";
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	629 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	630 $outputTableArray[0]["other"] = "其他";
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	631 $outputTableArray[0]["page"] = "頁數";
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	632 $outputTableArray[0]["full"] = "全文";
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	633
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	634 foreach ( $taglistArray as $tagValue ) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	635 $content = preg_replace("/<\/".$tagValue[2].">○*<".$tagValue[2].">/u", "", $content);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	636 $content = preg_replace("/<".$tagValue[2].">[ ]*<\/".$tagValue[2].">/u", "", $content);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	637 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	638
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	639 $contentLineArray = explode( "<br>", $content );
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	640
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	641 $count=0;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	642 $pageNow=NULL;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	643 foreach ( $contentLineArray as $value ) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	644 $count++;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	645 $recordString = $value;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	646 $otherString = $recordString;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	647 //echo $recordString."<br>\n";
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	648 if ( preg_match("/【<a(.?)>(.?)<\/a>】/u", $recordString, $matches) ) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	649 $pageNow = $matches[2];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	650 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	651 foreach ( $taglistArray as $tagValue ) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	652 if ( preg_match_all("/<".$tagValue[2].">(.*?)<\/".$tagValue[2].">/u", $recordString, $matches, PREG_SET_ORDER) ) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	653 foreach ( $matches as $matchesValue ) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	654 $matchesValue[1] = preg_replace("/○/u", "", $matchesValue[1]);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	655 if ( preg_match_all("/〈(.*?)〉/u", $matchesValue[1], $matches2, PREG_SET_ORDER) ) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	656 foreach ( $matches2 as $matches2Value ) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	657 if ( isset($outputTableArray[$count][0][$tagValue[2]]) ) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	658 $outputTableArray[$count][0][$tagValue[2]] .= ";".$matches2Value[1];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	659 } else {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	660 $outputTableArray[$count][0][$tagValue[2]] = $matches2Value[1];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	661 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	662 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	663 } else {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	664 if ( isset($outputTableArray[$count][0][$tagValue[2]]) ) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	665 $outputTableArray[$count][0][$tagValue[2]] .= ";".$matchesValue[1];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	666 } else {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	667 $outputTableArray[$count][0][$tagValue[2]] = $matchesValue[1];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	668 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	669 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	670 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	671 $otherString = preg_replace("/<".$tagValue[2].">(.*?)<\/".$tagValue[2].">/u", "　", $otherString);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	672 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	673 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	674 $otherString = preg_replace("/○/u", "", $otherString);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	675 $outputTableArray[$count]["other"] = $otherString;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	676 $outputTableArray[$count]["page"] = $pageNow;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	677 $value = preg_replace("/>/u", ">", $value);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	678 $value = preg_replace("/</u", "<", $value);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	679 $outputTableArray[$count]["full"] = $value;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	680 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	681 /*
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	682 echo "<br>"."DEBUG: outputTableArray:"."<br>";
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	683 var_dump($outputTableArray);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	684 */
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	685
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	686 $topic_tag = $this->GetTopicTag($topic);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	687
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	688 foreach ( $outputTableArray as $arrayIndex => $arrayValue ) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	689 // output each row which the topic tag
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	690 // e.g. the original version is for 'person'
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	691 if ( !isset($arrayValue[0][$topic_tag]) ) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	692 unset($outputTableArray[$arrayIndex]);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	693 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	694
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	695 /*
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	696 if ($topic == 1) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	697 if ( !isset($arrayValue[0]["person"]) ) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	698 unset($outputTableArray[$arrayIndex]);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	699 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	700 } else if ($topic == 2) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	701
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	702 // for object topic
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	703 if ( !isset($arrayValue[0]["object"]) ) { // only the record with the tag of 'object' will become a row
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	704 unset($outputTableArray[$arrayIndex]);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	705 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	706 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	707 */
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	708
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	709 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	710
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	711 $data = array();
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	712
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	713 $data['outputTableArray'] = $outputTableArray;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	714 $data['bookId'] = $bookId;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	715 $data['section_id'] = $section_id;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	716 $data['bookName'] = $bookName;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	717 $data['sectionName'] = $sectionName;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	718
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	719 return $data;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	720
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	721 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	722
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	723 // === for manage tag list ===
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	724 public function EditTaglist($_postdata) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	725 $query = "SELECT AUTO_INCREMENT FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME='taglist'";
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	726 $result = mysql_query($query);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	727 if (!$result) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	728 echo json_encode(mysql_error());
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	729 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	730 $row = mysql_fetch_assoc($result);
51 840cdb52f476 add book_meta into file Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 48 diff changeset	731 $largest_id = $row['AUTO_INCREMENT']-1;
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	732
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	733
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	734 $topic_id = $_postdata['topic_id'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	735 $result = $this->GetTaglistByTopicID($topic_id);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	736
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	737 $taglistArray = array();
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	738
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	739 foreach ($result as $row) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	740 $taglistArray[$row[0]] = array($row[1], $row[2], $row[3]);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	741 //$taglistArray[$row['id']] = array($row['name'], $row['tag'], $row['color']);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	742 // TODO: the format is not good, so I use $row[0], $row[1],... This could be changed some time.
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	743 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	744
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	745 $topic_tag_name = $this->GetTopicTag($topic_id);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	746
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	747 $query = "SELECT id FROM taglist WHERE taglist.tag='".$topic_tag_name."'";
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	748 $result = mysql_query($query);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	749 if (!$result) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	750 echo json_encode(mysql_error());
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	751 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	752 $row = mysql_fetch_assoc($result);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	753 $topic_tag_id = $row['id'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	754
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	755 $data = array();
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	756 $data['taglistArray'] = $taglistArray;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	757 $data['topic_id'] = $topic_id;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	758 $data['largest_id'] = $largest_id;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	759 $data['topic_tag_id'] = $topic_tag_id;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	760
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	761
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	762 return $data;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	763
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	764 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	765
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	766 private function _GetTag($_postdata) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	767 if (get_magic_quotes_gpc()) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	768 $id = stripslashes($_postdata['id']);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	769 $name = stripslashes($_postdata['name']);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	770 $tag = stripslashes($_postdata['tag']);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	771 $color = stripslashes($_postdata['color']);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	772 } else {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	773 $id = $_postdata['id'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	774 $name = $_postdata['name'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	775 $tag = $_postdata['tag'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	776 $color = $_postdata['color'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	777 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	778 return array($id, $name, $tag, $color);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	779 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	780
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	781 public function NewTagElement($postdata) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	782 if ($postdata['id']){
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	783 list($id, $name, $tag, $color) = $this->_GetTag($postdata);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	784
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	785 $query1 = sprintf("INSERT INTO `taglist` (`id`, `name`, `tag`, `color`, `systemName`) VALUES (%s, %s, %s, %s, %s)",
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	786 $this->GetSQLValueString($id, "int"),
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	787 $this->GetSQLValueString($name, "text"),
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	788 $this->GetSQLValueString($tag, "text"),
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	789 $this->GetSQLValueString($color, "text"),
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	790 $this->GetSQLValueString($this->systemNAME, "text"));
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	791 $result1 = mysql_query($query1);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	792
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	793
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	794 // add it to topic_tag_relation table
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	795 $topic_id = $postdata['topic_id'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	796
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	797 // tag_id is $id;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	798 $query = sprintf("INSERT INTO `topic_tag_relation` (`topic_id`,`tag_id`) VALUES (%s,%s)", $topic_id, $id);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	799 $result = mysql_query($query);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	800 if (!$result) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	801 echo json_encode("error when insert into topic_tag_relation table");
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	802 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	803 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	804
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	805 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	806
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	807 public function SaveTagElement($postdata) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	808 if ($postdata['id']){
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	809 list($id, $name, $tag, $color) = $this->_GetTag($postdata);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	810
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	811 $query = sprintf("UPDATE taglist SET `name`=%s, `tag`=%s, `color`=%s WHERE `id`=%s",
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	812 $this->GetSQLValueString($name, "text"),
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	813 $this->GetSQLValueString($tag, "text"),
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	814 $this->GetSQLValueString($color, "text"),
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	815 $this->GetSQLValueString($id, "int"));
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	816 $result = mysql_query($query);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	817
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	818 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	819
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	820 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	821
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	822 public function DeleteTag($postdata) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	823 if ($postdata['id']) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	824 $queryInsert = sprintf("DELETE FROM `taglist` WHERE `id` = %s", stripslashes($postdata['id']));
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	825 $resultInsert = mysql_query($queryInsert);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	826 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	827
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	828 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	829
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	830 // === for config topic ===
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	831 public function ConfigTagsInTopic($postdata) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	832 $topic = $postdata['topic'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	833 $result = $this->GetTopicByID($topic);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	834 $row = mysql_fetch_assoc($result);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	835 $topic_name = $row['name'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	836
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	837 /*
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	838 $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`";
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	839 $result = mysql_query($query);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	840 if (!$result) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	841 return json_encode("Failed during selecting/joining taglist and topic_tag_relation table.");
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	842 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	843 $taglistArray = array();
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	844 while ($row = mysql_fetch_assoc($result)) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	845 array_push($taglistArray, array('id'=>$row['id'],'name'=>$row['name'], 'tag'=>$row['tag'], 'color'=>$row['color'], 'topic_id'=>$row['topic_id']) );
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	846 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	847 */
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	848
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	849 // ------
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	850 $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`";
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	851 $result = mysql_query($query);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	852 if (!$result) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	853 return json_encode("Failed during selecting/joining taglist and topic_tag_relation table.");
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	854 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	855
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	856 $tag_intopic = array();
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	857 $tag_others = array();
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	858 $tag_tmp_others = array();
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	859 while ($row = mysql_fetch_assoc($result)) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	860 if ($row['topic_id'] == $topic) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	861 array_push($tag_intopic, array('id'=>$row['id'],'name'=>$row['name'], 'tag'=>$row['tag'], 'color'=>$row['color'], 'topic_id'=>$row['topic_id']));
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	862 } else {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	863 array_push($tag_tmp_others, array('id'=>$row['id'],'name'=>$row['name'], 'tag'=>$row['tag'], 'color'=>$row['color'], 'topic_id'=>$row['topic_id']));
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	864 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	865 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	866
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	867 // --- check if there's any duplicated tags in tag_tmp_others. remove the duplicated tags
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	868 $num_others = count($tag_tmp_others);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	869 for ($i=0; $i < $num_others; $i++) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	870 $cnt = 0;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	871 for ($j=$i+1; $j < $num_others; $j++) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	872 if ($tag_tmp_others[$i]['tag'] == $tag_tmp_others[$j]['tag']) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	873 break;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	874 } else {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	875 $cnt++;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	876 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	877 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	878 if ($cnt == ($num_others-$i-1) ) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	879 $row = $tag_tmp_others[$i];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	880 array_push($tag_others, array('id'=>$row['id'],'name'=>$row['name'], 'tag'=>$row['tag'], 'color'=>$row['color'], 'topic_id'=>$row['topic_id']) );
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	881 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	882 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	883
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	884 // --- remove duplicated tags in tag_others that is duplicated with tags in tag_intopic
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	885 $tag_tmp_others = $tag_others;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	886 $tag_others = array();
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	887
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	888 foreach ($tag_tmp_others as $tmp) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	889 $cnt = 0;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	890 foreach ($tag_intopic as $intopic) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	891 if ($tmp['tag'] == $intopic['tag']) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	892 break;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	893 } else {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	894 $cnt ++;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	895 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	896 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	897 if ($cnt == count($tag_intopic)) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	898 // not appear in $tag_intopic
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	899 array_push($tag_others, $tmp);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	900 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	901 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	902
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	903 // -----
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	904
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	905
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	906 $data = array();
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	907 //$data['taglistArray'] = $taglistArray;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	908 $data['topic'] = $topic;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	909 $data['topic_name'] = $topic_name;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	910
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	911 $data['tag_intopic'] = $tag_intopic;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	912 $data['tag_others'] = $tag_others;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	913
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	914 return $data;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	915 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	916
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	917
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	918 public function UpdateTagsInTopic($_postdata) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	919 $topic_id = $_postdata['topic_id'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	920 $tag_ids = json_decode(str_replace('\\', '', $_postdata['ids']));
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	921
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	922 // update topic_tag_relation by tags_ids array as `tag_id` and topic_id as `topic_id`
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	923 // --- add new topic_tag_relation ---
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	924 foreach ($tag_ids as $tag_id) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	925 $query = "SELECT * FROM topic_tag_relation WHERE tag_id=".$tag_id;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	926 $result = mysql_query($query);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	927 if (!$result) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	928 echo json_encode("error when select from topic_tag_relation");
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	929 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	930 $topic_tag = array();
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	931 $flag = false;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	932 while ($row = mysql_fetch_assoc($result)) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	933 if ($row['topic_id'] == $topic_id) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	934 $flag = true;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	935 break;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	936 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	937 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	938 if (!$flag) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	939 // insert a row into topic_tag_relation table
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	940 $queryUpdate = "INSERT INTO topic_tag_relation (topic_id, tag_id) VALUES (".$topic_id.",".$tag_id.")";
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	941 $resultUpdate = mysql_query($queryUpdate);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	942 if (!$resultUpdate) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	943 return json_encode("error when insert topic_tag_relation table");
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	944 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	945 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	946
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	947 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	948
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	949 // --- remove tags from this topic ---
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	950 $query = "SELECT * FROM topic_tag_relation WHERE topic_id=".$topic_id;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	951 $result = mysql_query($query);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	952 if (!$result) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	953 echo json_encode("error when select from topic_tag_relation");
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	954 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	955
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	956 while ($row = mysql_fetch_assoc($result)) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	957 $cnt = 0;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	958 foreach ($tag_ids as $tag_id) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	959 if ($row['tag_id'] == $tag_id) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	960 break;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	961 } else {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	962 $cnt ++;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	963 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	964 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	965 $_id = $row['id'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	966 if ($cnt == count($tag_ids)) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	967 // delete row with (topic_id, tag_ids)
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	968 $queryDelete = "DELETE FROM topic_tag_relation WHERE id=".$_id;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	969 $resultDelete = mysql_query($queryDelete);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	970 if (!$resultDelete) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	971 echo json_encode("error when delete from topic_tag_relation");
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	972 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	973 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	974 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	975
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	976
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	977
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	978 /*
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	979 $query = "SELECT * FROM topic_tag_relation";
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	980 $result = mysql_query($query);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	981 if (!$result) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	982 echo json_encode("error when select from topic_tag_relation");
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	983 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	984 $topic_tag = array();
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	985 while ($row = mysql_fetch_assoc($result)) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	986 array_push($topic_tag, array('tag_id'=>$row['tag_id'], 'topic_id'=>$row['topic_id']));
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	987 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	988
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	989
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	990 foreach ($topic_tag as $value) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	991 $flag = false;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	992 foreach ($tag_ids as $tag_id) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	993 if ($value['tag_id'] == $tag_id) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	994 //update its topic_id to $topic_id
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	995 $queryUpdate = "UPDATE topic_tag_relation SET topic_id=".$topic_id." WHERE tag_id=".$tag_id;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	996 $resultUpdate = mysql_query($queryUpdate);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	997 if (!$resultUpdate) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	998 return json_encode("error when update topic_tag_relation table");
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	999 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1000 $flag = true;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1001 break;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1002 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1003 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1004 if (!$flag && $value['topic_id'] == $topic_id) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1005 // set its topic_id to 0, indicating unsigned
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1006 $queryUpdate = "UPDATE topic_tag_relation SET topic_id=0 WHERE tag_id=".$value['tag_id'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1007 $resultUpdate = mysql_query($queryUpdate);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1008 if (!$resultUpdate) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1009 return json_encode("error when update topic_tag_relation table");
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1010 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1011 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1012 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1013 */
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1014
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1015 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1016
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1017
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1018 private function GetTaglistByTopicID($topic_id) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1019 $taglistArray = array();
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1020 // select taglist ids from topic_tag_relation table
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1021 $query = sprintf("SELECT * FROM `topic_tag_relation` WHERE `topic_id`='%s'", $topic_id);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1022 $result = mysql_query($query);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1023 if (!$result) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1024 return json_encode("Failed during selecting topic_tag_relation table.");
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1025 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1026 $taglist_ids = array();
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1027
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1028 while ($row = mysql_fetch_assoc($result)) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1029 array_push($taglist_ids, $row['tag_id']);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1030 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1031
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1032 // select taglist by tag ids
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1033 foreach ($taglist_ids as $tag_id) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1034 $query = sprintf("SELECT * FROM `taglist` WHERE `id`='%s'", $tag_id);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1035 $result = mysql_query($query);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1036 if (!$result) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1037 echo mysql_error();
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1038 return json_encode("Failed during selecting taglist table.");
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1039 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1040
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1041 $row = mysql_fetch_assoc($result);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1042 array_push($taglistArray, array( $row['id'], $row['name'], $row['tag'], $row['color'] ));
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1043
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1044 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1045 return $taglistArray;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1046 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1047
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1048 public function SetTopic($topic) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1049 $this->topic = $topic;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1050 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1051
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1052 public function GetTopic() {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1053 return $this->topic;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1054 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1055
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1056 private function GetTopiclistArray() {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1057 $topiclistArray = array();
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1058 $result = $this->GetTopiclist();
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1059 while ($row = mysql_fetch_assoc($result)) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1060 array_push($topiclistArray, array('id'=>$row['id'],'name'=>$row['name'],'tag'=>$row['tag']));
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1061 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1062 return $topiclistArray;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1063 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1064
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1065
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1066 private function GetTopicTag($topic_id) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1067 $result = $this->GetTopicByID($topic_id);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1068 $row = mysql_fetch_assoc($result);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1069 $tag = $row['tag'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1070 return $tag;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1071
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1072 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1073 private function GetTopicName($topic_id) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1074 $result = $this->GetTopicByID($topic_id);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1075 $row = mysql_fetch_assoc($result);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1076 $name = $row['name'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1077 return $name;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1078
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1079 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1080
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1081
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1082 // ===========================
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1083
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1084 // === for manage wordlist ===
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1085 public function EditWordlist() {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1086 $result = $this->GetWordlist();
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1087 $wordlistArray = array();
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1088 while ($row = mysql_fetch_assoc($result)) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1089 $wordlistArray[$row['id']] = $row['name'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1090 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1091
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1092 $data = array();
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1093 $data['wordlistArray'] = $wordlistArray;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1094 return $data;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1095 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1096
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1097
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1098 public function AddNewList($postdata) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1099 if ($postdata['text']){
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1100 if (get_magic_quotes_gpc()) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1101 $name = stripslashes($postdata['text']);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1102 } else {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1103 $name = $postdata['text'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1104 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1105
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1106 $query1 = sprintf("INSERT INTO `wordlist` (`name`, `systemName`) VALUES (%s, %s)",
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1107 $this->GetSQLValueString($name, "text"),
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1108 $this->GetSQLValueString($this->systemNAME, "text"));
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1109 $result1 = mysql_query($query1);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1110 file_put_contents( "data/wordlist/".mysql_insert_id().".txt", "(empty now)");
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1111 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1112 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1113
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1114
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1115 public function SaveWordlist($postdata) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1116
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1117 if ($postdata['text']){
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1118 $date = date('Y_m_d_H_i_s', time());
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1119 if ( file_exists("data/wordlist/".$postdata['filename'].".txt") ) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1120 $filename = "data/wordlist/".$postdata['filename']."_".$date.".txt";
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1121 $oldFile = file_get_contents("data/wordlist/".$postdata['filename'].".txt");
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1122 file_put_contents($filename, $oldFile);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1123 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1124 /*else {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1125 $filename = "data/wordlist/".$postdata['filename'].".txt";
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1126 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1127 */
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1128
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1129
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1130 if (get_magic_quotes_gpc()) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1131 $require = stripslashes($postdata['text']);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1132 } else {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1133 $require = $postdata['text'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1134 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1135
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1136 $require = preg_replace("/<br>/u", "<br>", $require);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1137 file_put_contents("data/wordlist/".$postdata['filename'].".txt", $require);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1138 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1139 /*
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1140 if ($postdata['text']){
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1141 $date = date('Y_m_d_H_i_s', time());
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1142 if ( file_exists("data/wordlist/".$postdata['filename'].".txt") ) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1143 $oldFile = file_get_contents("data/wordlist/".$postdata['filename'].".txt");
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1144 file_put_contents("data/wordlist/".$postdata['filename']."_".$date.".txt", $oldFile);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1145 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1146
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1147 if (get_magic_quotes_gpc()) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1148 $require = stripslashes($postdata['text']);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1149 } else {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1150 $require = $postdata['text'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1151 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1152
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1153 // $require = preg_replace("/<br>/u", "", $require);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1154 file_put_contents("data/wordlist/".$postdata['filename'].".txt", $require);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1155 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1156 */
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1157 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1158
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1159
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1160 // =======================================
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1161
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1162 public function sortFunction($a,$b) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1163 return strlen($b)-strlen($a);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1164 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1165
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1166 // TODO: delete this
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1167 private function SetSectionId($_urlvalues) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1168 // TODO: maybe get user info also
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1169 // get book id from url
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1170 if ($_urlvalues['id'] != "") {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1171 $section_id = $_urlvalues['id'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1172 } else {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1173 return json_encode("Error: No section id");
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1174 /* ???? */
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1175 /*
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1176 $get_book_id = $urlvalues['book'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1177 $get_start = $urlvalues['start'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1178 $get_end = $urlvalues['end'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1179 */
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1180 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1181 $this->section_id = $section_id;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1182
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1183 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1184
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1185 private function GetSectionId() {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1186
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1187 if (is_numeric($this->section_id)) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1188 return $this->section_id;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1189 } else {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1190 return json_encode("Error: No section id");
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1191 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1192 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1193
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1194 private function GetSectionInfo() {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1195 $section_id = $this->GetSectionId();
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1196 if (!is_numeric($section_id)){
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1197 return $section_id;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1198 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1199
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1200 $result = $this->GetSectionsByID($section_id);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1201
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1202
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1203 while ($row = mysql_fetch_assoc($result)) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1204 $bookId=$row['books_id'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1205 $startPage=$row['start_page'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1206 $endPage=$row['end_page'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1207 $sectionName = $row['name'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1208 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1209
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1210 $data = array();
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1211 $data['bookId'] = $bookId;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1212 $data['startPage'] = $startPage;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1213 $data['endPage'] = $endPage;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1214 $data['sectionName'] = $sectionName;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1215
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1216
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1217 return $data;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1218 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1219
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1220 private function ParseMetaData($filename) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1221 $text = file_get_contents($filename);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1222 $xml = simplexml_load_string($text); //or die("Error: Cannot load from xml string");
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1223 if (!$xml) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1224 // when file created by section_id, read the plain text from file_get_contents
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1225 return $text;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1226 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1227
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1228 $this->topic = (string)$xml->topic; // set topic id
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1229
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1230 // get taglist in file
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1231 $taglist_infile = $xml->tagitem;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1232 $taglistArray = array();
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1233 foreach ($taglist_infile as $row) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1234 array_push($taglistArray, array((string)$row->id,(string)$row->name,(string)$row->tag,(string)$row->color ));
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1235 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1236 if ($taglistArray) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1237 $this->taglist_infile = $taglistArray;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1238 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1239
51 840cdb52f476 add book_meta into file Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 48 diff changeset	1240 // get book meta data from file
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1241 $book_meta = $xml->book;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1242 $book_metaArray = array();
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1243 foreach ($book_meta as $row) {
51 840cdb52f476 add book_meta into file Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 48 diff changeset	1244 array_push($book_metaArray, array((string)$row->id,(string)$row->name,(string)$row->author,(string)$row->year,(string)$row->pagenumber ));
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1245 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1246 if ($book_metaArray) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1247 $this->book_meta = $book_metaArray;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1248 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1249
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1250 // echo $taglist->name.", ".$taglist->tag."," .$taglist->color;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1251 // --- detect if the taglist set is up-to-date or not ---
54 f9e7119339b2 bug fixed: when addTagTitle, removing self-closing tag which causes error in coloring tag Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 53 diff changeset	1252
f9e7119339b2 bug fixed: when addTagTitle, removing self-closing tag which causes error in coloring tag Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 53 diff changeset	1253 $contentString = (string)($xml->text_content->asXML());
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1254 //$removed_str = array("<text_content>","</text_content>");
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1255 //$new_contentString = str_replace($removed_str, "", $contentString);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1256
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1257 return $contentString;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1258 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1259 private function GetSectionContent() {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1260 $section_id = $this->GetSectionId();
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1261 $section_info = $this->GetSectionInfo();
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1262
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1263 $bookId = $section_info['bookId'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1264 $startPage = $section_info['startPage'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1265 $endPage = $section_info['endPage'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1266
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1267 $contentString="";
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1268 $data_path = $this->GetDataPath();
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1269 if ( file_exists($data_path."parsing_files/".$section_id.".txt") ) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1270 $filename = $data_path."parsing_files/".$section_id.".txt";
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1271
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1272 // --- parsing meta data
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1273 $stringInput = $this->ParseMetaData($filename);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1274 // ----
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1275
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1276 // if the text is from file system
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1277 $stringInput = preg_replace("/ /u", "○", $stringInput);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1278 $stringInput = preg_replace("/\n/u", "<br>", $stringInput);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1279 $stringInput = preg_replace("/【(.*?)】/u", "【<a href=\"review_index_xml_images.php?books_id=".$bookId."&pages=\\1&entry=0\" target=\"_bookImg\">\\1</a>】", $stringInput);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1280 } else {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1281 $query = sprintf("SELECT `content`, `line`, `books_id` FROM `contents` WHERE `books_id`=\"%s\" AND `line`>=%d AND `line`<=%d", $bookId, $startPage, $endPage);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1282 $result = mysql_query($query);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1283 if (!$result) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1284 return json_encode("Failed during selecting content table.");
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1285 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1286 while ($row = mysql_fetch_assoc($result)) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1287 $contentString.="【".$row['line']."】".$row['content']."\n";
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1288 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1289
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1290 // the text is from database
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1291 $stringInput = $contentString;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1292 $stringInput = preg_replace("/<(.*?)>/u", "○", $stringInput);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1293 $stringInput = preg_replace("/ /u", "○", $stringInput);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1294 $stringInput = preg_replace("/\n/u", "<br>", $stringInput);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1295 $stringInput = preg_replace("/【(.*?)】/u", "【<a href=\"review_index_xml_images.php?books_id=".$bookId."&pages=\\1&entry=0\" target=\"_bookImg\">\\1</a>】", $stringInput);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1296 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1297
51 840cdb52f476 add book_meta into file Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 48 diff changeset	1298 // get book_meta from books table
840cdb52f476 add book_meta into file Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 48 diff changeset	1299 $book_meta = array();
840cdb52f476 add book_meta into file Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 48 diff changeset	1300 $books_result = $this->GetBooksByID($bookId);
840cdb52f476 add book_meta into file Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 48 diff changeset	1301 while ($row = mysql_fetch_assoc($books_result)) {
840cdb52f476 add book_meta into file Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 48 diff changeset	1302 array_push($book_meta, array($row['id'],$row['name'],$row['author'],(string)$row['start_year'],(string)$row['line']));
840cdb52f476 add book_meta into file Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 48 diff changeset	1303 // use 'start_year' as year, 'line' is pagenumber
840cdb52f476 add book_meta into file Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 48 diff changeset	1304 }
840cdb52f476 add book_meta into file Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 48 diff changeset	1305
840cdb52f476 add book_meta into file Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 48 diff changeset	1306 $this->book_meta = $book_meta;
840cdb52f476 add book_meta into file Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 48 diff changeset	1307
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1308 return $stringInput;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1309 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1310
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1311 private function GetDataPath() {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1312 return getcwd()."/data/"; // get the current file path, which is getcwd(), and concatenate with "/data/"
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1313 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1314
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1315 private function GetTaglistArray() {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1316 $taglistArray = array();
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1317 $result = $this->GetTaglist();
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1318 while ($row = mysql_fetch_assoc($result)) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1319 array_push($taglistArray, array( $row['id'], $row['name'], $row['tag'], $row['color'] ));
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1320 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1321
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1322 return $taglistArray;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1323 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1324
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1325 private function GetWordlistArray() {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1326 $wordlistArray="";
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1327 $result = $this->GetWordlist();
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1328 while ($row = mysql_fetch_assoc($result)) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1329 $listString = file_get_contents("data/wordlist/".$row['id'].".txt");
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1330 $listString = preg_replace("/<div>/u", "\n", $listString);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1331 $listString = preg_replace("/<\/div>/u", "", $listString);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1332 $listString = preg_replace("/<span(.*?)>/u", "", $listString);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1333 $listString = preg_replace("/<\/span>/u", "", $listString);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1334 //$listString = preg_replace("/\n/u", "\|", $listString);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1335
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1336 $wordlistArray2 = explode( "\n", $listString );
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1337 usort($wordlistArray2,'sortFunction');
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1338 foreach ( $wordlistArray2 as $index=>$value ) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1339 $wordlistArray2[$index] = implode("○?", preg_split("/(?<!^)(?!$)/u", $value));
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1340 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1341 foreach ( $wordlistArray2 as $index=>$value ) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1342 if ($value=="") unset($wordlistArray2[$index]);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1343
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1344 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1345 $listString = implode("\|", $wordlistArray2);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1346
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1347 if ( $listString[0]=="\|" ) $listString = substr($listString, 1);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1348 $wordlistArray[] = array( $row['id'], $row['name'], $listString );
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1349 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1350
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1351
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1352 return $wordlistArray;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1353
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1354 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1355
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1356 protected function GetBooksInfo($bookId) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1357 $result = $this->GetSectionsByID($bookId);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1358 while ($row = mysql_fetch_assoc($result)) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1359 $bookName = $row['name'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1360 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1361
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1362 $data = array();
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1363 $data['bookName'] = $bookName;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1364
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1365 return $data;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1366 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1367
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1368
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1369 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1370
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1371
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1372
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1373 ?>

Mercurial > hg > extraction-interface

annotate models/extractapp.php @ 54:f9e7119339b2 extractapp