extraction-interface: models/extractapp.php annotate

annotate models/extractapp.php @ 78:960ba96efce1 extractapp

Update: click to popup remove-tag-window; select to popup tag-window

author	Zoe Hong <zhong@mpiwg-berlin.mpg.de>
date	Mon, 20 Apr 2015 15:44:54 +0200
parents	97c1e5102a22
children	e6e213b26454

rev	line source
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1 <?php
77 97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	2 /**
97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	3 * ExtractappModel is extended from the BaseModel.
97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	4 * This is where we implement the functions/models that related to extraction-interface.
97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	5 */
47 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 class ExtractappModel extends BaseModel{
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	8
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	9 protected $section_id = 0, $data_path, $file_id = 0, $current_fileId=0,
63 3395385476d1 bug fixed: popup tag window is closed automatically when saving text file Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 62 diff changeset	10 $branch_id = 0, $user_id = 0, $lg_text = "", $topic, $taglist_infile = "", $book_meta = "",$book_dynasty="";
58 a11f9103b8db New: 1.display messages 2.handle saving conflict:up-to-date or reload text Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 57 diff changeset	11 public $messages = array('info'=>"",'error'=>"",'warning'=>"",'debug'=>"");
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	12
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	13
53 f9594c240826 get/update text after saving, for xml file consistency Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 52 diff changeset	14 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	15 /*
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	16 $this->file_id = $_postdata['fileId'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	17 $branch_id = $_postdata['branchId'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	18 $section_id = $_postdata['sectionId'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	19
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	20 $this->branch_id = $branch_id;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	21 $this->user_id = $_postdata['userId'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	22 $this->section_id = $section_id;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	23
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	24 $this->section_name = $_postdata['sectionName'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	25 $this->book_id = $_postdata['bookId'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	26 $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	27 */
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	28
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	29 // get from URL with file_id
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	30 $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	31 //$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	32 // --- get/set text and parsing meta data from text file
74 60b5a94163c3 New: retrieve book meta data from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 73 diff changeset	33 $lg_text = $this->ParseDataInFile($lg_text_url);
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
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	36 $stringInput = $lg_text;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	37 $stringInput = preg_replace("/ /u", "○", $stringInput);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	38 $stringInput = preg_replace("/\n/u", "<br>", $stringInput);
71 26d8c4c43d86 minor checking for variable/index in php Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 70 diff changeset	39 $stringInput = preg_replace("/【(.*?)】/u", "【<a href=\"review_index_xml_images.php?books_id=".$this->book_id."&pages=\\1&entry=0\" target=\"_bookImg\">\\1</a>】", $stringInput);
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	40 $lg_text = $stringInput;
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 $this->lg_text = $lg_text;
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
78 960ba96efce1 Update: click to popup remove-tag-window; select to popup tag-window Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 77 diff changeset	46 public function SetBookMetadataBySectionId() {
67 3ada9334ebfc New: check taglist is deprecated or not Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 66 diff changeset	47
69 edb8a2e8ce84 New: save book meta_data in file Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 67 diff changeset	48 // get book_meta from $$this->get_section_metadata_by_sectionId_url
67 3ada9334ebfc New: check taglist is deprecated or not Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 66 diff changeset	49 $section_meta_url = $this->get_section_metadata_by_sectionId_url.$this->section_id;
69 edb8a2e8ce84 New: save book meta_data in file Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 67 diff changeset	50 $section_meta = json_decode(file_get_contents($section_meta_url), true);
67 3ada9334ebfc New: check taglist is deprecated or not Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 66 diff changeset	51
69 edb8a2e8ce84 New: save book meta_data in file Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 67 diff changeset	52 $b = $section_meta['section']['book'];
63 3395385476d1 bug fixed: popup tag window is closed automatically when saving text file Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 62 diff changeset	53
3395385476d1 bug fixed: popup tag window is closed automatically when saving text file Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 62 diff changeset	54 $book_meta = array();
69 edb8a2e8ce84 New: save book meta_data in file Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 67 diff changeset	55 array_push($book_meta, array($b['id'],$b['name'],$b['level1'],$b['level2'],
edb8a2e8ce84 New: save book meta_data in file Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 67 diff changeset	56 $b['period'],$b['dynasty'], $b['start_year'], $b['end_year'],$b['line'],
edb8a2e8ce84 New: save book meta_data in file Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 67 diff changeset	57 $b['volume'],$b['author'], $b['edition'],$b['in_jibengujiku'], $b['admin_type'])); // missing author,year,pagenumber
63 3395385476d1 bug fixed: popup tag window is closed automatically when saving text file Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 62 diff changeset	58 $this->book_meta = $book_meta;
3395385476d1 bug fixed: popup tag window is closed automatically when saving text file Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 62 diff changeset	59
3395385476d1 bug fixed: popup tag window is closed automatically when saving text file Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 62 diff changeset	60 }
3395385476d1 bug fixed: popup tag window is closed automatically when saving text file Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 62 diff changeset	61
53 f9594c240826 get/update text after saving, for xml file consistency Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 52 diff changeset	62 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	63 /*
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	64 $section_id = $_postdata['sectionId'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	65 $this->section_id = $section_id;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	66 $this->user_id = $_postdata['userId'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	67
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	68 $this->section_name = $_postdata['sectionName'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	69 $this->book_id = $_postdata['bookId'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	70 $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	71 */
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	72
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	73 // 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	74 // $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	75 $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	76 $lg_text = file_get_contents($lg_text_url);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	77
51 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);
73 2daef8e36214 minor modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 71 diff changeset	83 $stringInput = preg_replace("/【(.*?)】/u", "【<a href=\"review_index_xml_images.php?books_id=".$this->book_id."&pages=\\1&entry=0\" target=\"_bookImg\">\\1</a>】", $stringInput);
47 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
74 60b5a94163c3 New: retrieve book meta data from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 73 diff changeset	89 // This is only used on localhost
60b5a94163c3 New: retrieve book meta data from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 73 diff changeset	90 public function GetTextFromLocal($_id){
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	91 $this->section_id = $_id;
63 3395385476d1 bug fixed: popup tag window is closed automatically when saving text file Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 62 diff changeset	92 //$this->branch_id = 1; // local test sets branch_id to 1
58 a11f9103b8db New: 1.display messages 2.handle saving conflict:up-to-date or reload text Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 57 diff changeset	93 $this->messages['debug'] .= "[Debug] from my local"."<br>";
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	94 $this->lg_text = $this->GetSectionContent();
74 60b5a94163c3 New: retrieve book meta data from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 73 diff changeset	95 }
47 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
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	98 public function GetInfoFromPreviousPage($_postdata) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	99
71 26d8c4c43d86 minor checking for variable/index in php Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 70 diff changeset	100 if (isset($_postdata['fileId'])) {
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	101 $this->file_id = $_postdata['fileId'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	102 }
71 26d8c4c43d86 minor checking for variable/index in php Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 70 diff changeset	103 if (isset($_postdata['sectionId'])) {
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	104 $this->section_id = $_postdata['sectionId'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	105 }
71 26d8c4c43d86 minor checking for variable/index in php Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 70 diff changeset	106 if (isset($_postdata['text'])) {
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	107 $this->lg_text = $_postdata['text'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	108 }
71 26d8c4c43d86 minor checking for variable/index in php Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 70 diff changeset	109 if (isset($_postdata['branchId'])) {
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	110 $this->branch_id = $_postdata['branchId'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	111 }
71 26d8c4c43d86 minor checking for variable/index in php Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 70 diff changeset	112 if (isset($_postdata['userId'])) {
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	113 $this->user_id = $_postdata['userId'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	114 }
71 26d8c4c43d86 minor checking for variable/index in php Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 70 diff changeset	115 if (isset($_postdata['topic_id'])) {
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	116 $this->topic = $_postdata['topic_id'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	117 }
71 26d8c4c43d86 minor checking for variable/index in php Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 70 diff changeset	118 if (isset($_postdata['sectionName'])) {
47 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 }
71 26d8c4c43d86 minor checking for variable/index in php Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 70 diff changeset	121 if (isset($_postdata['bookName'])) {
47 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 }
71 26d8c4c43d86 minor checking for variable/index in php Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 70 diff changeset	124 if (isset($_postdata['bookId'])) {
47 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 }
71 26d8c4c43d86 minor checking for variable/index in php Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 70 diff changeset	127 if (isset($_postdata['currentFileId'])) {
47 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 }
71 26d8c4c43d86 minor checking for variable/index in php Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 70 diff changeset	130 if (isset($_postdata['taglistArray'])) {
47 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 }
71 26d8c4c43d86 minor checking for variable/index in php Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 70 diff changeset	133 if (isset($_postdata['book_meta'])) {
47 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
67 3ada9334ebfc New: check taglist is deprecated or not Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 66 diff changeset	139
3ada9334ebfc New: check taglist is deprecated or not Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 66 diff changeset	140 private function TaglistSubsetIn($list1, $list2) { // $l1 is a subset of $l2 or not
3ada9334ebfc New: check taglist is deprecated or not Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 66 diff changeset	141 // l1 and l2: array( $row['id'], $row['name'], $row['tag'], $row['color'] )
3ada9334ebfc New: check taglist is deprecated or not Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 66 diff changeset	142 $cnt_list1 = count($list1);
3ada9334ebfc New: check taglist is deprecated or not Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 66 diff changeset	143 $cnt_list2 = count($list2);
3ada9334ebfc New: check taglist is deprecated or not Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 66 diff changeset	144
3ada9334ebfc New: check taglist is deprecated or not Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 66 diff changeset	145 if ($cnt_list1 > $cnt_list2) {
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	146 return false;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	147 }
67 3ada9334ebfc New: check taglist is deprecated or not Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 66 diff changeset	148 foreach ($list1 as $v1) {
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	149 $cnt = 0;
67 3ada9334ebfc New: check taglist is deprecated or not Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 66 diff changeset	150 foreach ($list2 as $v2) {
3ada9334ebfc New: check taglist is deprecated or not Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 66 diff changeset	151 $num_field = count($v2);
3ada9334ebfc New: check taglist is deprecated or not Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 66 diff changeset	152 $matched = true;
3ada9334ebfc New: check taglist is deprecated or not Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 66 diff changeset	153 for ($i=0; $i < $num_field; $i++) {
3ada9334ebfc New: check taglist is deprecated or not Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 66 diff changeset	154 if ($v1[$i] != $v2[$i]) {
3ada9334ebfc New: check taglist is deprecated or not Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 66 diff changeset	155 $matched = false;
3ada9334ebfc New: check taglist is deprecated or not Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 66 diff changeset	156 break;
3ada9334ebfc New: check taglist is deprecated or not Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 66 diff changeset	157 }
3ada9334ebfc New: check taglist is deprecated or not Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 66 diff changeset	158 }
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	159
67 3ada9334ebfc New: check taglist is deprecated or not Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 66 diff changeset	160 if (!$matched) {
3ada9334ebfc New: check taglist is deprecated or not Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 66 diff changeset	161 // not match with this v2
3ada9334ebfc New: check taglist is deprecated or not Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 66 diff changeset	162 $cnt += 1;
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	163 } else {
67 3ada9334ebfc New: check taglist is deprecated or not Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 66 diff changeset	164 break;
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	165 }
67 3ada9334ebfc New: check taglist is deprecated or not Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 66 diff changeset	166
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	167 }
67 3ada9334ebfc New: check taglist is deprecated or not Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 66 diff changeset	168 if ($cnt == $cnt_list2) {
3ada9334ebfc New: check taglist is deprecated or not Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 66 diff changeset	169 return false;
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	170 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	171 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	172 return true;
67 3ada9334ebfc New: check taglist is deprecated or not Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 66 diff changeset	173
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	174 }
67 3ada9334ebfc New: check taglist is deprecated or not Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 66 diff changeset	175
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	176 // === for tagging ===
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	177 public function StartTagging() {
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 $section_id = $this->section_id;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	180 $stringInput = $this->lg_text;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	181
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	182 $data = array(); // data array to be passed to view
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	183
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	184 //$taglistArray = $this->GetTaglistArray();
78 960ba96efce1 Update: click to popup remove-tag-window; select to popup tag-window Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 77 diff changeset	185 //for GetTaglistByTopicId:
960ba96efce1 Update: click to popup remove-tag-window; select to popup tag-window Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 77 diff changeset	186 $taglistArray = $this->GetTaglistByTopicId($this->GetTopic());
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	187
67 3ada9334ebfc New: check taglist is deprecated or not Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 66 diff changeset	188 // $this->taglist_infile is set (1) from file or (2) from _postdata['taglistArray'] which comes from frontend that user decided
3ada9334ebfc New: check taglist is deprecated or not Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 66 diff changeset	189 // $this->taglist_infile is the most up-to-date taglist decided by user. Should be written into file.
3ada9334ebfc New: check taglist is deprecated or not Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 66 diff changeset	190 if( $this->TaglistSubsetIn($this->taglist_infile, $taglistArray) ) { // TaglistSubsetIn($l1,$l2): $l1 is a subset of $l2 or not
3ada9334ebfc New: check taglist is deprecated or not Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 66 diff changeset	191 $this->taglist_infile = "";
3ada9334ebfc New: check taglist is deprecated or not Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 66 diff changeset	192 }
3ada9334ebfc New: check taglist is deprecated or not Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 66 diff changeset	193 $data['taglist_infile'] = $this->taglist_infile; // if taglist_infile == "" means taglist in file is up-to-date (will use taglist in db), otherwise means the taglist in file
3ada9334ebfc New: check taglist is deprecated or not Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 66 diff changeset	194
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	195
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	196 // book_meta
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	197 $data['book_meta'] = $this->book_meta;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	198
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	199 // topic list
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	200 $topiclistArray = $this->GetTopiclistArray();
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	201
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 $wordlistArray = $this->GetWordlistArray();
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	204
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	205 $data['stringInput'] = $stringInput;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	206 $data['taglistArray'] = $taglistArray;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	207 $data['wordlistArray'] = $wordlistArray;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	208 $data['section_id'] = $section_id;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	209 $data['topiclistArray'] = $topiclistArray;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	210 $data['default_topic_id'] = $this->GetTopic();
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	211 $data['topic_tag'] = $this->GetTopicTag($this->GetTopic());
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	212 $data['topic_name'] = $this->GetTopicName($this->GetTopic());
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	213
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	214
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	215 $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	216 '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	217 '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	218 'current_fileId'=>$this->current_fileId);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	219
58 a11f9103b8db New: 1.display messages 2.handle saving conflict:up-to-date or reload text Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 57 diff changeset	220 $this->messages['debug'] .= "[Debug] ";
a11f9103b8db New: 1.display messages 2.handle saving conflict:up-to-date or reload text Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 57 diff changeset	221 $this->messages['debug'] .= "file_id=".$this->file_id.", section_id=".$this->section_id;
a11f9103b8db New: 1.display messages 2.handle saving conflict:up-to-date or reload text Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 57 diff changeset	222 $this->messages['debug'] .= ", user_id=".$this->user_id.", branch_id=".$this->branch_id.", topic_id=".$this->topic;
a11f9103b8db New: 1.display messages 2.handle saving conflict:up-to-date or reload text Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 57 diff changeset	223 $this->messages['debug'] .= ", book_id=".$this->book_id.", book_name=".$this->book_name.", section_name=".$this->section_name;
a11f9103b8db New: 1.display messages 2.handle saving conflict:up-to-date or reload text Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 57 diff changeset	224 $this->messages['debug'] .= ", current_fileId=".$this->current_fileId."<br>";
a11f9103b8db New: 1.display messages 2.handle saving conflict:up-to-date or reload text Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 57 diff changeset	225
a11f9103b8db New: 1.display messages 2.handle saving conflict:up-to-date or reload text Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 57 diff changeset	226 $this->messages['info'] .= "[Info] book name: ".$this->book_name;
a11f9103b8db New: 1.display messages 2.handle saving conflict:up-to-date or reload text Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 57 diff changeset	227 $this->messages['info'] .= ", section id: ". $this->section_id;
a11f9103b8db New: 1.display messages 2.handle saving conflict:up-to-date or reload text Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 57 diff changeset	228 $this->messages['info'] .= ", branch id: ".$this->branch_id;
60 3239979f6673 New: 1.display messages(style) 2.handle saving conflict:up-to-date or reload text Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 59 diff changeset	229 $this->messages['info'] .= ", file id: ".$this->file_id;
58 a11f9103b8db New: 1.display messages 2.handle saving conflict:up-to-date or reload text Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 57 diff changeset	230 $this->messages['info'] .= "<br>";
a11f9103b8db New: 1.display messages 2.handle saving conflict:up-to-date or reload text Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 57 diff changeset	231
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	232
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	233 $data['messages'] = $this->messages;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	234
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	235 return $data;
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 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	238
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	239 public function SaveFullText($postdata) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	240 if ($postdata['text']){
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	241 $date = date('Y_m_d_H_i_s', time());
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	242 if ( file_exists("data/parsing_files/".$postdata['filename'].".txt") ) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	243 $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	244 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	245 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	246
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	247 if (get_magic_quotes_gpc()) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	248 $require = stripslashes($postdata['text']);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	249 } else {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	250 $require = $postdata['text'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	251 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	252
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	253 $require = preg_replace("/【<a(.?)>(.?)<\/a>】/u", "【\\2】", $require);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	254 $require = preg_replace('/&/u', "&", $require);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	255 $require = preg_replace("/○/u", " ", $require);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	256 $require = preg_replace("/<br>/u", "\n", $require);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	257 $require = preg_replace("/<br>/u", "\n", $require);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	258 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	259 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	260
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
78 960ba96efce1 Update: click to popup remove-tag-window; select to popup tag-window Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 77 diff changeset	263 public function UpdateInfoResponsedFromLGService($response) {
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	264
73 2daef8e36214 minor modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 71 diff changeset	265 if (isset($response["file"])) {
2daef8e36214 minor modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 71 diff changeset	266 $response_file = $response["file"];
2daef8e36214 minor modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 71 diff changeset	267 }
2daef8e36214 minor modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 71 diff changeset	268 if (isset($response["branch"])) {
2daef8e36214 minor modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 71 diff changeset	269 $response_branch = $response["branch"];
2daef8e36214 minor modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 71 diff changeset	270 }
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	271
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	272 $status = (string)$response["status"];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	273 if ($status == "ok") {
58 a11f9103b8db New: 1.display messages 2.handle saving conflict:up-to-date or reload text Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 57 diff changeset	274 $this->messages['info'] .= "[Info] Saving success. <br>";
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	275 $this->file_id = (string)$response_file["id"];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	276 $this->branch_id = (string)$response_branch["id"];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	277
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	278 } else if ($status == "error") {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	279 // saving not success
61 c6fa7f83c5bf New: 1.display messages(style) 2.handle saving conflict:up-to-date or reload text Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 60 diff changeset	280 $this->messages['error'] .= "[Error] Saving Failed! ".(string)$response["message"]."<br>";
66 e71a437ae49f New: responsive. some css style Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 65 diff changeset	281 $this->messages['warning'] .= "[Warning] Please check branch ".$this->branch_id." in LGService, and modify from the latest version.";
58 a11f9103b8db New: 1.display messages 2.handle saving conflict:up-to-date or reload text Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 57 diff changeset	282
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	283 $response_currentFile = $response["currentFile"];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	284 $this->current_fileId = (string)$response_currentFile["id"];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	285
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	286 }
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
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	289 }
57 5cf9720a2e25 New: add reloadText to load the latest version Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 56 diff changeset	290
5cf9720a2e25 New: add reloadText to load the latest version Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 56 diff changeset	291 public function ReloadSetting() {
5cf9720a2e25 New: add reloadText to load the latest version Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 56 diff changeset	292 if ($this->current_fileId != 0) {
5cf9720a2e25 New: add reloadText to load the latest version Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 56 diff changeset	293 $this->file_id = $this->current_fileId;
5cf9720a2e25 New: add reloadText to load the latest version Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 56 diff changeset	294 $this->current_fileId = 0;
5cf9720a2e25 New: add reloadText to load the latest version Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 56 diff changeset	295 }
5cf9720a2e25 New: add reloadText to load the latest version Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 56 diff changeset	296 }
5cf9720a2e25 New: add reloadText to load the latest version Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 56 diff changeset	297
75 75233b09c580 saving latest taglist from db according to topic (even when changing topic) Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 74 diff changeset	298 // This is only called by SaveFullTextToLGService()
78 960ba96efce1 Update: click to popup remove-tag-window; select to popup tag-window Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 77 diff changeset	299 private function AppendMetadata($text_content) {
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	300 $text = '<?xml version="1.0" encoding="UTF-8"?>';
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	301 $text .= "\n<text>\n";
75 75233b09c580 saving latest taglist from db according to topic (even when changing topic) Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 74 diff changeset	302 // --- topic ---
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	303 $text .= "<topic>".$this->topic."</topic>\n";
75 75233b09c580 saving latest taglist from db according to topic (even when changing topic) Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 74 diff changeset	304 // --- book meta data ---
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	305 $book = $this->book_meta;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	306 foreach ($book as $b) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	307 $text .= "<book>\n";
51 840cdb52f476 add book_meta into file Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 48 diff changeset	308 $text .= "<id>".$b[0]."</id>\n";
840cdb52f476 add book_meta into file Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 48 diff changeset	309 $text .= "<name>".$b[1]."</name>\n";
69 edb8a2e8ce84 New: save book meta_data in file Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 67 diff changeset	310 $text .= "<level1>".$b[2]."</level1>\n";
edb8a2e8ce84 New: save book meta_data in file Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 67 diff changeset	311 $text .= "<level2>".$b[3]."</level2>\n";
edb8a2e8ce84 New: save book meta_data in file Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 67 diff changeset	312 $text .= "<period>".$b[4]."</period>\n";
63 3395385476d1 bug fixed: popup tag window is closed automatically when saving text file Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 62 diff changeset	313 $text .= "<dynasty>".$b[5]."</dynasty>\n";
69 edb8a2e8ce84 New: save book meta_data in file Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 67 diff changeset	314 $text .= "<start_year>".$b[6]."</start_year>\n";
edb8a2e8ce84 New: save book meta_data in file Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 67 diff changeset	315 $text .= "<end_year>".$b[7]."</end_year>\n";
edb8a2e8ce84 New: save book meta_data in file Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 67 diff changeset	316 $text .= "<line>".$b[8]."</line>\n";
edb8a2e8ce84 New: save book meta_data in file Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 67 diff changeset	317 $text .= "<volume>".$b[9]."</volume>\n";
edb8a2e8ce84 New: save book meta_data in file Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 67 diff changeset	318 $text .= "<author>".$b[10]."</author>\n";
edb8a2e8ce84 New: save book meta_data in file Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 67 diff changeset	319 $text .= "<edition>".$b[11]."</edition>\n";
edb8a2e8ce84 New: save book meta_data in file Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 67 diff changeset	320 $text .= "<in_jibengujiku>".$b[12]."</in_jibengujiku>\n";
edb8a2e8ce84 New: save book meta_data in file Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 67 diff changeset	321 $text .= "<admin_type>".$b[13]."</admin_type>\n";
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	322 $text .= "</book>\n";
69 edb8a2e8ce84 New: save book meta_data in file Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 67 diff changeset	323
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	324 }
77 97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	325 // --- section info ---
97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	326 $text .= "<section>\n";
97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	327 $text .= "<id>".$this->section_id."</id>\n";
97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	328 $text .= "<name>".$this->section_name."</name>\n";
97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	329 $text .= "</section>\n";
75 75233b09c580 saving latest taglist from db according to topic (even when changing topic) Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 74 diff changeset	330
75233b09c580 saving latest taglist from db according to topic (even when changing topic) Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 74 diff changeset	331 // ---- taglist ---
75233b09c580 saving latest taglist from db according to topic (even when changing topic) Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 74 diff changeset	332 // $taglist = $this->taglist_infile;
75233b09c580 saving latest taglist from db according to topic (even when changing topic) Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 74 diff changeset	333 // obtain the latest taglist from db
78 960ba96efce1 Update: click to popup remove-tag-window; select to popup tag-window Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 77 diff changeset	334 $taglist = $this->GetTaglistByTopicId($this->GetTopic());
75 75233b09c580 saving latest taglist from db according to topic (even when changing topic) Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 74 diff changeset	335
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	336 foreach ($taglist as $tagitem) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	337 $text .= "<tagitem>\n";
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	338 $text .= "<id>".$tagitem[0]."</id>\n";
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	339 $text .= "<name>".$tagitem[1]."</name>\n";
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	340 $text .= "<tag>".$tagitem[2]."</tag>\n";
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	341 $text .= "<color>".$tagitem[3]."</color>\n";
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	342 $text .= "</tagitem>\n";
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	343 }
75 75233b09c580 saving latest taglist from db according to topic (even when changing topic) Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 74 diff changeset	344 // ----
75233b09c580 saving latest taglist from db according to topic (even when changing topic) Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 74 diff changeset	345 // --- text_content ---
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	346 $text .= $text_content;
65 f9ae94a9b041 New: adding topic names: name_en, name_ch, name_pinyin Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	347 $text .= "</text>";
75 75233b09c580 saving latest taglist from db according to topic (even when changing topic) Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 74 diff changeset	348 // ----
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	349
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	350 return $text;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	351 }
78 960ba96efce1 Update: click to popup remove-tag-window; select to popup tag-window Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 77 diff changeset	352
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	353 public function SaveFullTextToLGService($_postdata) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	354 // 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	355 // --------
58 a11f9103b8db New: 1.display messages 2.handle saving conflict:up-to-date or reload text Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 57 diff changeset	356 global $AT_LOCAL;
a11f9103b8db New: 1.display messages 2.handle saving conflict:up-to-date or reload text Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 57 diff changeset	357
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	358 if ($_postdata['text']){
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	359 $date = date('Y_m_d_H_i_s', time());
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	360 if ( file_exists("data/parsing_files/".$_postdata['sectionId'].".txt") ) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	361 $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	362 //saving in my local machine in developing phrase
58 a11f9103b8db New: 1.display messages 2.handle saving conflict:up-to-date or reload text Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 57 diff changeset	363 if ($AT_LOCAL) {
a11f9103b8db New: 1.display messages 2.handle saving conflict:up-to-date or reload text Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 57 diff changeset	364 file_put_contents("data/parsing_files/".$_postdata['sectionId']."_".$date.".txt", $oldFile);
a11f9103b8db New: 1.display messages 2.handle saving conflict:up-to-date or reload text Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 57 diff changeset	365 }
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	366 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	367
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	368 if (get_magic_quotes_gpc()) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	369 $require = stripslashes($_postdata['text']);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	370 } else {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	371 $require = $_postdata['text'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	372 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	373
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	374 $require = preg_replace("/【<a(.?)>(.?)<\/a>】/u", "【\\2】", $require);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	375 $require = preg_replace('/&/u', "&", $require);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	376 $require = preg_replace("/○/u", " ", $require);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	377 $require = preg_replace("/<br>/u", "\n", $require);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	378 //$require = preg_replace("/<br>/u", "\n", $require);
55 e930eb88b547 bug fixed: when addTagTitle, removing self-closing tag which causes error in coloring tag Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 54 diff changeset	379
76 c49192885290 Bug fixed: ambiguous tag occured at Editing-text mode Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 75 diff changeset	380 $require = "<text_content>".$require."</text_content>\n";
c49192885290 Bug fixed: ambiguous tag occured at Editing-text mode Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 75 diff changeset	381
c49192885290 Bug fixed: ambiguous tag occured at Editing-text mode Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 75 diff changeset	382 /*
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	383 if ($_postdata['branchId'] == 0) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	384 // -- new branch case
65 f9ae94a9b041 New: adding topic names: name_en, name_ch, name_pinyin Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	385 $require = "<text_content>".$require."</text_content>\n";
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	386 }
76 c49192885290 Bug fixed: ambiguous tag occured at Editing-text mode Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 75 diff changeset	387 */
c49192885290 Bug fixed: ambiguous tag occured at Editing-text mode Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 75 diff changeset	388
78 960ba96efce1 Update: click to popup remove-tag-window; select to popup tag-window Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 77 diff changeset	389 $require = $this->AppendMetadata($require);
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	390
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	391 //saving in my local machine in developing phrase
58 a11f9103b8db New: 1.display messages 2.handle saving conflict:up-to-date or reload text Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 57 diff changeset	392 if ($AT_LOCAL) {
a11f9103b8db New: 1.display messages 2.handle saving conflict:up-to-date or reload text Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 57 diff changeset	393 file_put_contents("data/parsing_files/".$_postdata['sectionId'].".txt", $require);
a11f9103b8db New: 1.display messages 2.handle saving conflict:up-to-date or reload text Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 57 diff changeset	394 }
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	395 }
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 // ------
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
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	400 if ($_postdata['branchId'] != 0) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	401 // -- exiting branch case
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	402 $postfields = array(
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	403 "text" => $require,
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	404 "branchId" => $_postdata['branchId'],
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	405 "userId" => $_postdata['userId'],
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	406 "userPreviousFileId" => $_postdata['fileId'],
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	407 );
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	408 $save_url = $this->save_to_LGService_url;
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 } else {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	411 // -- new branch case
59 6e44605eb4f6 New: 1.display messages 2.handle saving conflict:up-to-date or reload text Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 58 diff changeset	412 // echo "saveNew!";
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	413 $user_id = "0";
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	414 if ($_postdata['userId']) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	415 $user_id = $_postdata['userId'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	416 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	417
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	418 $postfields = array(
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	419 "text" => $require,
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	420 "sectionId" => $_postdata['sectionId'],
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	421 "userId" => $user_id,
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	422 "label" => $_postdata['label'],
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	423 );
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	424 $save_url = $this->save_new_to_LGService_url;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	425 }
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
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	428 // set up the curl resource
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	429 $ch = curl_init();
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	430 curl_setopt($ch, CURLOPT_URL, $save_url);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	431 curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	432 curl_setopt($ch, CURLOPT_CUSTOMREQUEST, "POST");
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	433 curl_setopt($ch, CURLOPT_POST, true);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	434 curl_setopt($ch, CURLOPT_POSTFIELDS, $postfields);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	435 //curl_setopt($ch, CURLOPT_HEADER, true);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	436 curl_setopt($ch, CURLOPT_HTTPHEADER, array(
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	437 'Content-type: multipart/form-data;charset=utf-8'
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
58 a11f9103b8db New: 1.display messages 2.handle saving conflict:up-to-date or reload text Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 57 diff changeset	440 if (!$AT_LOCAL) {
a11f9103b8db New: 1.display messages 2.handle saving conflict:up-to-date or reload text Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 57 diff changeset	441 // execute the request
a11f9103b8db New: 1.display messages 2.handle saving conflict:up-to-date or reload text Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 57 diff changeset	442 $output = curl_exec($ch);
a11f9103b8db New: 1.display messages 2.handle saving conflict:up-to-date or reload text Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 57 diff changeset	443 }
a11f9103b8db New: 1.display messages 2.handle saving conflict:up-to-date or reload text Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 57 diff changeset	444
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	445
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	446 // output the profile information - includes the header
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	447 //echo($output) . PHP_EOL;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	448
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	449 // close curl resource to free up system resources
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	450 curl_close($ch);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	451
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	452 $response = json_decode($output, true);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	453 return $response;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	454
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	455 }
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 // --- for regex ----
78 960ba96efce1 Update: click to popup remove-tag-window; select to popup tag-window Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 77 diff changeset	458 private function GetRegexFilenameById($topic_id) {
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	459 $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	460 $result = mysql_query($query);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	461 if (!$result) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	462 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	463 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	464
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	465 $filenames = array();
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	466 while ($row = mysql_fetch_assoc($result)) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	467 array_push($filenames, $row['regex_filename']);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	468 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	469
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	470 return $filenames;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	471 }
78 960ba96efce1 Update: click to popup remove-tag-window; select to popup tag-window Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 77 diff changeset	472 public function LoadSmartRegex($topic_id) {
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	473
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	474 // 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	475 $filenames = $this->GetRegexFilenameById($topic_id);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	476
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	477 // Get regex file from filesystem ----
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	478 $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	479 $returnArray = array();
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	480 $files1 = scandir($data_path."regex_files");
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	481 foreach ( $files1 as $file ) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	482 if ( $file != "." && $file != ".." && $file != ".DS_Store") {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	483 foreach ($filenames as $filename) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	484 if ($file == $filename) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	485 $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	486 break;
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 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	489 }
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 echo json_encode($returnArray);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	492 return;
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
78 960ba96efce1 Update: click to popup remove-tag-window; select to popup tag-window Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 77 diff changeset	496 public function SaveSmartRegex($_postdata) {
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	497 if ($_postdata['text']){
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	498
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	499 // --- update topic_regex_relation table ---
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	500 $topic_id = $_postdata['topic_id'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	501 $filename = $_postdata['filename'].'.txt';
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 // 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	504 $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	505 $result = mysql_query($query);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	506 if (!$result) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	507 echo json_encode("ErrorDB");
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 while ($row = mysql_fetch_assoc($result)) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	510 if ($row && !$_postdata['forcesave']) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	511 // promt user a comfirm to force saving or not
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	512 echo json_encode("ForceSave");
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	513 return;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	514 }
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
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	517
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	518 if (!$_postdata['forcesave']) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	519 $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	520 $result = mysql_query($query);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	521 if (!$result) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	522 echo json_encode("ErrorDB");
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	523 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	524 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	525 // --- write to filesystem ---
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 $date = date('Y_m_d_H_i_s', time());
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	529 if ( file_exists("regex_files/".$_POST['filename'].".txt") ) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	530 $oldFile = file_get_contents("regex_files/".$_POST['filename'].".txt");
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	531 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	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 $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	535
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	536 if (get_magic_quotes_gpc()) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	537 $require = stripslashes($_postdata['text']);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	538 } else {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	539 $require = $_postdata['text'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	540 }
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 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	543
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	544
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	545 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	546 }
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
77 97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	549 private function GetTableArray($_taglistArray, $_topic_tag, $_content) {
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	550
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	551 $outputTableArray = array();
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	552 $outputTableArray[0]=array();
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	553 $outputTableArray[0][0]=array();
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	554 $outputTableArray[0][1]=array();
77 97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	555 foreach ( $_taglistArray as $value ) {
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	556 $outputTableArray[0][0][$value[2]] = $value[1];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	557 $outputTableArray[0][1][$value[2]] = $value[1]."(Title)";
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	558 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	559 $outputTableArray[0]["other"] = "其他";
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	560 $outputTableArray[0]["page"] = "頁數";
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	561 $outputTableArray[0]["full"] = "全文";
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	562
78 960ba96efce1 Update: click to popup remove-tag-window; select to popup tag-window Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 77 diff changeset	563 // id, name, tag, color in _taglistArray
77 97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	564 foreach ( $_taglistArray as $tagValue ) {
78 960ba96efce1 Update: click to popup remove-tag-window; select to popup tag-window Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 77 diff changeset	565 $tag_name = $tagValue[2]; // $tagValue[2] is tag_name
960ba96efce1 Update: click to popup remove-tag-window; select to popup tag-window Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 77 diff changeset	566 $content = preg_replace("/<\/".$tag_name.">○*<".$tag_name.">/u", "", $_content);
960ba96efce1 Update: click to popup remove-tag-window; select to popup tag-window Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 77 diff changeset	567 $content = preg_replace("/<".$tag_name.">[ ]*<\/".$tag_name.">/u", "", $_content);
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	568 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	569
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	570 $contentLineArray = explode( "<br>", $content );
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 $count=0;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	573 $pageNow=NULL;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	574 foreach ( $contentLineArray as $value ) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	575 $count++;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	576 $recordString = $value;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	577 $otherString = $recordString;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	578 //echo $recordString."<br>\n";
78 960ba96efce1 Update: click to popup remove-tag-window; select to popup tag-window Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 77 diff changeset	579 // find hyper link in pattern with <a>...</a>
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	580 if ( preg_match("/【<a(.?)>(.?)<\/a>】/u", $recordString, $matches) ) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	581 $pageNow = $matches[2];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	582 }
77 97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	583 foreach ( $_taglistArray as $tagValue ) {
78 960ba96efce1 Update: click to popup remove-tag-window; select to popup tag-window Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 77 diff changeset	584 $tag_name = $tagValue[2]; // $tagValue[2] is tag_name
960ba96efce1 Update: click to popup remove-tag-window; select to popup tag-window Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 77 diff changeset	585
960ba96efce1 Update: click to popup remove-tag-window; select to popup tag-window Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 77 diff changeset	586 if ( preg_match_all("/<".$tag_name.">(.*?)<\/".$tag_name.">/u", $recordString, $matches, PREG_SET_ORDER) ) {
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	587 foreach ( $matches as $matchesValue ) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	588 $matchesValue[1] = preg_replace("/○/u", "", $matchesValue[1]);
78 960ba96efce1 Update: click to popup remove-tag-window; select to popup tag-window Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 77 diff changeset	589
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	590 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	591 foreach ( $matches2 as $matches2Value ) {
78 960ba96efce1 Update: click to popup remove-tag-window; select to popup tag-window Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 77 diff changeset	592 if ( isset($outputTableArray[$count][0][$tag_name]) ) {
960ba96efce1 Update: click to popup remove-tag-window; select to popup tag-window Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 77 diff changeset	593 $outputTableArray[$count][0][$tag_name] .= ";".$matches2Value[1];
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	594 } else {
78 960ba96efce1 Update: click to popup remove-tag-window; select to popup tag-window Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 77 diff changeset	595 $outputTableArray[$count][0][$tag_name] = $matches2Value[1];
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	596 }
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 } else {
78 960ba96efce1 Update: click to popup remove-tag-window; select to popup tag-window Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 77 diff changeset	599 if ( isset($outputTableArray[$count][0][$tag_name]) ) {
960ba96efce1 Update: click to popup remove-tag-window; select to popup tag-window Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 77 diff changeset	600 $outputTableArray[$count][0][$tag_name] .= ";".$matchesValue[1];
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	601 } else {
78 960ba96efce1 Update: click to popup remove-tag-window; select to popup tag-window Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 77 diff changeset	602 $outputTableArray[$count][0][$tag_name] = $matchesValue[1];
47 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 }
78 960ba96efce1 Update: click to popup remove-tag-window; select to popup tag-window Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 77 diff changeset	606 $otherString = preg_replace("/<".$tag_name.">(.*?)<\/".$tag_name.">/u", "　", $otherString);
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	607 }
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 $otherString = preg_replace("/○/u", "", $otherString);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	610 $outputTableArray[$count]["other"] = $otherString;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	611 $outputTableArray[$count]["page"] = $pageNow;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	612 $value = preg_replace("/>/u", ">", $value);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	613 $value = preg_replace("/</u", "<", $value);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	614 $outputTableArray[$count]["full"] = $value;
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
77 97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	617
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	618
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	619 foreach ( $outputTableArray as $arrayIndex => $arrayValue ) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	620 // output each row which the topic tag
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	621 // e.g. the original version is for 'person'
77 97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	622 if ( !isset($arrayValue[0][$_topic_tag]) ) {
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	623 unset($outputTableArray[$arrayIndex]);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	624 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	625
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	626 }
77 97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	627 // -----
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	628
77 97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	629 return $outputTableArray;
97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	630 }
97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	631
97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	632 // === for export table ===
97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	633
97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	634 public function ExportTable($postdata, $isFromFile) {
97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	635 if ($isFromFile) {
97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	636 $content = $this->lg_text;
97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	637 $topic = $this->topic;
97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	638 $sectionId = $this->section_id;
97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	639 $sectionName = $this->section_name;
97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	640 $bookId = $this->book_id;
97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	641 $bookName = $this->book_name;
97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	642
97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	643 $taglistArray = $this->taglist_infile;
97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	644
97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	645 } else {
97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	646 $content = $postdata['content'];
97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	647 $topic = $postdata['topic'];
97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	648
97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	649 $section_id = $postdata['sectionId'];
97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	650 $sectionName = $postdata['sectionName'];
97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	651 $bookId = $postdata['bookId'];
97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	652 $bookName = $postdata['bookName'];
97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	653
97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	654 //$taglistArray = $this->GetTaglistArray();
78 960ba96efce1 Update: click to popup remove-tag-window; select to popup tag-window Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 77 diff changeset	655 $taglistArray = $this->GetTaglistByTopicId($topic);
77 97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	656 }
97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	657 // =====
97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	658
97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	659 $topic_tag = $this->GetTopicTag($topic);
97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	660
97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	661 // input data: taglistArray, topic_tag, content; output: outputTableArray
97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	662 $outputTableArray = $this->GetTableArray($taglistArray, $topic_tag, $content);
97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	663
97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	664
97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	665
97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	666 // data for view
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	667 $data = array();
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	668 $data['outputTableArray'] = $outputTableArray;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	669 $data['bookId'] = $bookId;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	670 $data['section_id'] = $section_id;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	671 $data['bookName'] = $bookName;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	672 $data['sectionName'] = $sectionName;
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 return $data;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	675
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	676 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	677
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	678 // === for manage tag list ===
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	679 public function EditTaglist($_postdata) {
77 97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	680 /**
97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	681 */
97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	682
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	683 $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	684 $result = mysql_query($query);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	685 if (!$result) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	686 echo json_encode(mysql_error());
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 $row = mysql_fetch_assoc($result);
51 840cdb52f476 add book_meta into file Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 48 diff changeset	689 $largest_id = $row['AUTO_INCREMENT']-1;
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	690
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	691
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	692 $topic_id = $_postdata['topic_id'];
78 960ba96efce1 Update: click to popup remove-tag-window; select to popup tag-window Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 77 diff changeset	693 $result = $this->GetTaglistByTopicId($topic_id);
47 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 $taglistArray = array();
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	696
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	697 foreach ($result as $row) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	698 $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	699 //$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	700 }
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 $topic_tag_name = $this->GetTopicTag($topic_id);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	703
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	704 $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	705 $result = mysql_query($query);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	706 if (!$result) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	707 echo json_encode(mysql_error());
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 $row = mysql_fetch_assoc($result);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	710 $topic_tag_id = $row['id'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	711
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	712 $data = array();
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	713 $data['taglistArray'] = $taglistArray;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	714 $data['topic_id'] = $topic_id;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	715 $data['largest_id'] = $largest_id;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	716 $data['topic_tag_id'] = $topic_tag_id;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	717
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
67 3ada9334ebfc New: check taglist is deprecated or not Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 66 diff changeset	723 private function GetTag($_postdata) {
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	724 if (get_magic_quotes_gpc()) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	725 $id = stripslashes($_postdata['id']);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	726 $name = stripslashes($_postdata['name']);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	727 $tag = stripslashes($_postdata['tag']);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	728 $color = stripslashes($_postdata['color']);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	729 } else {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	730 $id = $_postdata['id'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	731 $name = $_postdata['name'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	732 $tag = $_postdata['tag'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	733 $color = $_postdata['color'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	734 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	735 return array($id, $name, $tag, $color);
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
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	738 public function NewTagElement($postdata) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	739 if ($postdata['id']){
67 3ada9334ebfc New: check taglist is deprecated or not Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 66 diff changeset	740 list($id, $name, $tag, $color) = $this->GetTag($postdata);
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	741
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	742 $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	743 $this->GetSQLValueString($id, "int"),
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	744 $this->GetSQLValueString($name, "text"),
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	745 $this->GetSQLValueString($tag, "text"),
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	746 $this->GetSQLValueString($color, "text"),
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	747 $this->GetSQLValueString($this->systemNAME, "text"));
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	748 $result1 = mysql_query($query1);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	749
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	750
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	751 // add it to topic_tag_relation table
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	752 $topic_id = $postdata['topic_id'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	753
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	754 // tag_id is $id;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	755 $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	756 $result = mysql_query($query);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	757 if (!$result) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	758 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	759 }
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 }
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 public function SaveTagElement($postdata) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	765 if ($postdata['id']){
67 3ada9334ebfc New: check taglist is deprecated or not Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 66 diff changeset	766 list($id, $name, $tag, $color) = $this->GetTag($postdata);
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	767
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	768 $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	769 $this->GetSQLValueString($name, "text"),
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	770 $this->GetSQLValueString($tag, "text"),
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	771 $this->GetSQLValueString($color, "text"),
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	772 $this->GetSQLValueString($id, "int"));
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	773 $result = mysql_query($query);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	774
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	775 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	776
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
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	779 public function DeleteTag($postdata) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	780 if ($postdata['id']) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	781 $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	782 $resultInsert = mysql_query($queryInsert);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	783 }
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 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	786
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	787 // === for config topic ===
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	788 public function ConfigTagsInTopic($postdata) {
77 97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	789 /**
97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	790 *
97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	791 */
97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	792
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	793 $topic = $postdata['topic'];
78 960ba96efce1 Update: click to popup remove-tag-window; select to popup tag-window Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 77 diff changeset	794 $result = $this->GetTopicById($topic);
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	795 $row = mysql_fetch_assoc($result);
65 f9ae94a9b041 New: adding topic names: name_en, name_ch, name_pinyin Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	796 $topic_name_en = $row['name_en'];
f9ae94a9b041 New: adding topic names: name_en, name_ch, name_pinyin Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	797 $topic_name_ch = $row['name_ch'];
f9ae94a9b041 New: adding topic names: name_en, name_ch, name_pinyin Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	798 $topic_name_pinyin = $row['name_pinyin'];
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	799
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	800 /*
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	801 $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	802 $result = mysql_query($query);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	803 if (!$result) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	804 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	805 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	806 $taglistArray = array();
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	807 while ($row = mysql_fetch_assoc($result)) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	808 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	809 }
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
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	812 // ------
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	813 $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	814 $result = mysql_query($query);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	815 if (!$result) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	816 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	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 $tag_intopic = array();
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	820 $tag_others = array();
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	821 $tag_tmp_others = array();
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	822 while ($row = mysql_fetch_assoc($result)) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	823 if ($row['topic_id'] == $topic) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	824 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	825 } else {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	826 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	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 // --- 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	831 $num_others = count($tag_tmp_others);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	832 for ($i=0; $i < $num_others; $i++) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	833 $cnt = 0;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	834 for ($j=$i+1; $j < $num_others; $j++) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	835 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	836 break;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	837 } else {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	838 $cnt++;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	839 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	840 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	841 if ($cnt == ($num_others-$i-1) ) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	842 $row = $tag_tmp_others[$i];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	843 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	844 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	845 }
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 // --- 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	848 $tag_tmp_others = $tag_others;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	849 $tag_others = array();
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	850
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	851 foreach ($tag_tmp_others as $tmp) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	852 $cnt = 0;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	853 foreach ($tag_intopic as $intopic) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	854 if ($tmp['tag'] == $intopic['tag']) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	855 break;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	856 } else {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	857 $cnt ++;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	858 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	859 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	860 if ($cnt == count($tag_intopic)) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	861 // not appear in $tag_intopic
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	862 array_push($tag_others, $tmp);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	863 }
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
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	868
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	869 $data = array();
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	870 //$data['taglistArray'] = $taglistArray;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	871 $data['topic'] = $topic;
65 f9ae94a9b041 New: adding topic names: name_en, name_ch, name_pinyin Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	872 $data['topic_name'] = array('name_en'=>$topic_name_en,'name_ch'=>$topic_name_ch,'name_pinyin'=>$topic_name_pinyin);
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	873
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	874 $data['tag_intopic'] = $tag_intopic;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	875 $data['tag_others'] = $tag_others;
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 return $data;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	878 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	879
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	880
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	881 public function UpdateTagsInTopic($_postdata) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	882 $topic_id = $_postdata['topic_id'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	883 $tag_ids = json_decode(str_replace('\\', '', $_postdata['ids']));
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	884
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	885 // 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	886 // --- add new topic_tag_relation ---
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	887 foreach ($tag_ids as $tag_id) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	888 $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	889 $result = mysql_query($query);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	890 if (!$result) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	891 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	892 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	893 $topic_tag = array();
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	894 $flag = false;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	895 while ($row = mysql_fetch_assoc($result)) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	896 if ($row['topic_id'] == $topic_id) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	897 $flag = true;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	898 break;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	899 }
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 if (!$flag) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	902 // insert a row into topic_tag_relation table
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	903 $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	904 $resultUpdate = mysql_query($queryUpdate);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	905 if (!$resultUpdate) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	906 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	907 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	908 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	909
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
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	912 // --- remove tags from this topic ---
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	913 $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	914 $result = mysql_query($query);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	915 if (!$result) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	916 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	917 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	918
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	919 while ($row = mysql_fetch_assoc($result)) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	920 $cnt = 0;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	921 foreach ($tag_ids as $tag_id) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	922 if ($row['tag_id'] == $tag_id) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	923 break;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	924 } else {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	925 $cnt ++;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	926 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	927 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	928 $_id = $row['id'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	929 if ($cnt == count($tag_ids)) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	930 // delete row with (topic_id, tag_ids)
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	931 $queryDelete = "DELETE FROM topic_tag_relation WHERE id=".$_id;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	932 $resultDelete = mysql_query($queryDelete);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	933 if (!$resultDelete) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	934 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	935 }
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
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	939
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	940
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	941 /*
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	942 $query = "SELECT * FROM topic_tag_relation";
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	943 $result = mysql_query($query);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	944 if (!$result) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	945 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	946 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	947 $topic_tag = array();
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	948 while ($row = mysql_fetch_assoc($result)) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	949 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	950 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	951
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	952
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	953 foreach ($topic_tag as $value) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	954 $flag = false;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	955 foreach ($tag_ids as $tag_id) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	956 if ($value['tag_id'] == $tag_id) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	957 //update its topic_id to $topic_id
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	958 $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	959 $resultUpdate = mysql_query($queryUpdate);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	960 if (!$resultUpdate) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	961 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	962 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	963 $flag = true;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	964 break;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	965 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	966 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	967 if (!$flag && $value['topic_id'] == $topic_id) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	968 // set its topic_id to 0, indicating unsigned
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	969 $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	970 $resultUpdate = mysql_query($queryUpdate);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	971 if (!$resultUpdate) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	972 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	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
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	980
78 960ba96efce1 Update: click to popup remove-tag-window; select to popup tag-window Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 77 diff changeset	981 private function GetTaglistByTopicId($topic_id) {
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	982 $taglistArray = array();
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	983 // select taglist ids from topic_tag_relation table
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	984 $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	985 $result = mysql_query($query);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	986 if (!$result) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	987 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	988 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	989 $taglist_ids = array();
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	990
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	991 while ($row = mysql_fetch_assoc($result)) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	992 array_push($taglist_ids, $row['tag_id']);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	993 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	994
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	995 // select taglist by tag ids
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	996 foreach ($taglist_ids as $tag_id) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	997 $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	998 $result = mysql_query($query);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	999 if (!$result) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1000 echo mysql_error();
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1001 return json_encode("Failed during selecting taglist table.");
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 $row = mysql_fetch_assoc($result);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1005 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	1006
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1007 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1008 return $taglistArray;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1009 }
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 public function SetTopic($topic) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1012 $this->topic = $topic;
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
78 960ba96efce1 Update: click to popup remove-tag-window; select to popup tag-window Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 77 diff changeset	1015 private function GetTopic() {
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1016 return $this->topic;
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
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1019 private function GetTopiclistArray() {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1020 $topiclistArray = array();
78 960ba96efce1 Update: click to popup remove-tag-window; select to popup tag-window Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 77 diff changeset	1021 $result = $this->GetTopicList();
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1022 while ($row = mysql_fetch_assoc($result)) {
65 f9ae94a9b041 New: adding topic names: name_en, name_ch, name_pinyin Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	1023 //array_push($topiclistArray, array('id'=>$row['id'],'name'=>$row['name'],'tag'=>$row['tag']));
f9ae94a9b041 New: adding topic names: name_en, name_ch, name_pinyin Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	1024 array_push($topiclistArray, array('id'=>$row['id'],'tag'=>$row['tag'],'name_en'=>$row['name_en'],'name_ch'=>$row['name_ch'],'name_pinyin'=>$row['name_pinyin'],));
47 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 return $topiclistArray;
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
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1029
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1030 private function GetTopicTag($topic_id) {
78 960ba96efce1 Update: click to popup remove-tag-window; select to popup tag-window Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 77 diff changeset	1031 $result = $this->GetTopicById($topic_id);
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1032 $row = mysql_fetch_assoc($result);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1033 $tag = $row['tag'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1034 return $tag;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1035
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1036 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1037 private function GetTopicName($topic_id) {
78 960ba96efce1 Update: click to popup remove-tag-window; select to popup tag-window Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 77 diff changeset	1038 $result = $this->GetTopicById($topic_id);
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1039 $row = mysql_fetch_assoc($result);
65 f9ae94a9b041 New: adding topic names: name_en, name_ch, name_pinyin Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	1040 //$name = $row['name'];
f9ae94a9b041 New: adding topic names: name_en, name_ch, name_pinyin Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 63 diff changeset	1041 $name = array('name_en'=>$row['name_en'], 'name_ch'=>$row['name_ch'], 'name_pinyin'=>$row['name_pinyin']);
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1042 return $name;
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
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
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1049 // === for manage wordlist ===
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1050 public function EditWordlist() {
77 97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	1051 /**
97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	1052 * EditWordlist shows the wordlist in a new window.
97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	1053 * User can view each one of the wordlist and edit it, also s/he can create a new wordlist here.
97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	1054 */
97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	1055
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1056 $result = $this->GetWordlist();
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1057 $wordlistArray = array();
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1058 while ($row = mysql_fetch_assoc($result)) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1059 $wordlistArray[$row['id']] = $row['name'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1060 }
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 $data = array();
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1063 $data['wordlistArray'] = $wordlistArray;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1064 return $data;
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
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1067
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1068 public function AddNewList($postdata) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1069 if ($postdata['text']){
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1070 if (get_magic_quotes_gpc()) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1071 $name = stripslashes($postdata['text']);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1072 } else {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1073 $name = $postdata['text'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1074 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1075
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1076 $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	1077 $this->GetSQLValueString($name, "text"),
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1078 $this->GetSQLValueString($this->systemNAME, "text"));
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1079 $result1 = mysql_query($query1);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1080 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	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
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1085 public function SaveWordlist($postdata) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1086
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1087 if ($postdata['text']){
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1088 $date = date('Y_m_d_H_i_s', time());
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1089 if ( file_exists("data/wordlist/".$postdata['filename'].".txt") ) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1090 $filename = "data/wordlist/".$postdata['filename']."_".$date.".txt";
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1091 $oldFile = file_get_contents("data/wordlist/".$postdata['filename'].".txt");
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1092 file_put_contents($filename, $oldFile);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1093 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1094 /*else {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1095 $filename = "data/wordlist/".$postdata['filename'].".txt";
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
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1099
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 $require = 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 $require = $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 $require = preg_replace("/<br>/u", "<br>", $require);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1107 file_put_contents("data/wordlist/".$postdata['filename'].".txt", $require);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1108 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1109 /*
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1110 if ($postdata['text']){
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1111 $date = date('Y_m_d_H_i_s', time());
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1112 if ( file_exists("data/wordlist/".$postdata['filename'].".txt") ) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1113 $oldFile = file_get_contents("data/wordlist/".$postdata['filename'].".txt");
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1114 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	1115 }
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 (get_magic_quotes_gpc()) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1118 $require = stripslashes($postdata['text']);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1119 } else {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1120 $require = $postdata['text'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1121 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1122
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1123 // $require = preg_replace("/<br>/u", "", $require);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1124 file_put_contents("data/wordlist/".$postdata['filename'].".txt", $require);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1125 }
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 // =======================================
78 960ba96efce1 Update: click to popup remove-tag-window; select to popup tag-window Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 77 diff changeset	1131
960ba96efce1 Update: click to popup remove-tag-window; select to popup tag-window Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 77 diff changeset	1132 private function sortFunction($a,$b) {
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1133 return strlen($b)-strlen($a);
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 private function GetSectionId() {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1137
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1138 if (is_numeric($this->section_id)) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1139 return $this->section_id;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1140 } else {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1141 return json_encode("Error: No section id");
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1142 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1143 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1144
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1145 private function GetSectionInfo() {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1146 $section_id = $this->GetSectionId();
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1147 if (!is_numeric($section_id)){
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1148 return $section_id;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1149 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1150
78 960ba96efce1 Update: click to popup remove-tag-window; select to popup tag-window Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 77 diff changeset	1151 $result = $this->GetSectionsById($section_id);
47 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
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1154 while ($row = mysql_fetch_assoc($result)) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1155 $bookId=$row['books_id'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1156 $startPage=$row['start_page'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1157 $endPage=$row['end_page'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1158 $sectionName = $row['name'];
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 $data = array();
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1162 $data['bookId'] = $bookId;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1163 $data['startPage'] = $startPage;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1164 $data['endPage'] = $endPage;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1165 $data['sectionName'] = $sectionName;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1166
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1167
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1168 return $data;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1169 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1170
74 60b5a94163c3 New: retrieve book meta data from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 73 diff changeset	1171 private function ParseDataInFile($filename) {
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1172 $text = file_get_contents($filename);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1173 $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	1174 if (!$xml) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1175 // 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	1176 return $text;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1177 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1178
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1179 $this->topic = (string)$xml->topic; // set topic id
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 // get taglist in file
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1182 $taglist_infile = $xml->tagitem;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1183 $taglistArray = array();
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1184 foreach ($taglist_infile as $row) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1185 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	1186 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1187 if ($taglistArray) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1188 $this->taglist_infile = $taglistArray;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1189 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1190
74 60b5a94163c3 New: retrieve book meta data from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 73 diff changeset	1191 // --- get book meta data from file, replaced by SetBookMetaDataBySectionId(), which retrives book meta data from LGService
60b5a94163c3 New: retrieve book meta data from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 73 diff changeset	1192 /*
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1193 $book_meta = $xml->book;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1194 $book_metaArray = array();
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1195 foreach ($book_meta as $row) {
69 edb8a2e8ce84 New: save book meta_data in file Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 67 diff changeset	1196 array_push($book_metaArray, array((string)$row->id,(string)$row->name,(string)$row->level1,(string)$row->level2,
70 359f48d58cbc New: hover on regex elem Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 69 diff changeset	1197 (string)$row->period,(string)$row->dynasty,(string)$row->start_year,(string)$row->end_year,(string)$row->line,
69 edb8a2e8ce84 New: save book meta_data in file Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 67 diff changeset	1198 (string)$row->volume,(string)$row->author,(string)$row->edition,(string)$row->in_jibengujiku,(string)$row->admin_type ));
47 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 if ($book_metaArray) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1201 $this->book_meta = $book_metaArray;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1202 }
74 60b5a94163c3 New: retrieve book meta data from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 73 diff changeset	1203 */
60b5a94163c3 New: retrieve book meta data from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 73 diff changeset	1204 // -----
77 97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	1205 // TODO: get section_id, section_name from file
97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	1206 if ($this->section_id == 0 && isset($xml->section)) {
97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	1207 if ($xml->section) {
97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	1208 $this->section_id = (string)$xml->section->id;
97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	1209 $this->section_name = (string)$xml->section->name;
97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	1210 }
97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	1211 }
97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	1212 // book meta data
97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	1213 if (!isset($this->book_id) && isset($xml->book)) {
97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	1214 $this->book_id = (string)$xml->book->id;
97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	1215 $this->book_name = (string)$xml->book->name;
97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	1216 }
97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	1217
97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	1218
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	1219
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	1220 $contentString = (string)($xml->text_content->asXML());
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1221
76 c49192885290 Bug fixed: ambiguous tag occured at Editing-text mode Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 75 diff changeset	1222 $removed_str = array("<text_content>","</text_content>");
c49192885290 Bug fixed: ambiguous tag occured at Editing-text mode Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 75 diff changeset	1223 $new_contentString = str_replace($removed_str, "", $contentString);
c49192885290 Bug fixed: ambiguous tag occured at Editing-text mode Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 75 diff changeset	1224
c49192885290 Bug fixed: ambiguous tag occured at Editing-text mode Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 75 diff changeset	1225 return $new_contentString;
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1226 }
74 60b5a94163c3 New: retrieve book meta data from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 73 diff changeset	1227
60b5a94163c3 New: retrieve book meta data from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 73 diff changeset	1228
77 97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	1229 private function GetSectionContent() {
97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	1230 /** This is only been called by GetTextFromLocal().
97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	1231 */
97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	1232
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1233 $section_id = $this->GetSectionId();
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1234 $section_info = $this->GetSectionInfo();
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 $bookId = $section_info['bookId'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1237 $startPage = $section_info['startPage'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1238 $endPage = $section_info['endPage'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1239
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1240 $contentString="";
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1241 $data_path = $this->GetDataPath();
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1242 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	1243 $filename = $data_path."parsing_files/".$section_id.".txt";
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1244
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1245 // --- parsing meta data
74 60b5a94163c3 New: retrieve book meta data from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 73 diff changeset	1246 $stringInput = $this->ParseDataInFile($filename);
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1247 // ----
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 // if the text is from file system
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1250 $stringInput = preg_replace("/ /u", "○", $stringInput);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1251 $stringInput = preg_replace("/\n/u", "<br>", $stringInput);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1252 $stringInput = preg_replace("/【(.*?)】/u", "【<a href=\"review_index_xml_images.php?books_id=".$bookId."&pages=\\1&entry=0\" target=\"_bookImg\">\\1</a>】", $stringInput);
63 3395385476d1 bug fixed: popup tag window is closed automatically when saving text file Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 62 diff changeset	1253
3395385476d1 bug fixed: popup tag window is closed automatically when saving text file Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 62 diff changeset	1254 $this->branch_id = 1; // testing at local
3395385476d1 bug fixed: popup tag window is closed automatically when saving text file Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 62 diff changeset	1255
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1256 } else {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1257 $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	1258 $result = mysql_query($query);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1259 if (!$result) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1260 return json_encode("Failed during selecting content table.");
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1261 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1262 while ($row = mysql_fetch_assoc($result)) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1263 $contentString.="【".$row['line']."】".$row['content']."\n";
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1264 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1265
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1266 // the text is from database
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1267 $stringInput = $contentString;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1268 $stringInput = preg_replace("/<(.*?)>/u", "○", $stringInput);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1269 $stringInput = preg_replace("/ /u", "○", $stringInput);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1270 $stringInput = preg_replace("/\n/u", "<br>", $stringInput);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1271 $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	1272 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1273
69 edb8a2e8ce84 New: save book meta_data in file Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 67 diff changeset	1274 /*
74 60b5a94163c3 New: retrieve book meta data from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 73 diff changeset	1275 // get book_meta from books table in db on localhost
51 840cdb52f476 add book_meta into file Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 48 diff changeset	1276 $book_meta = array();
78 960ba96efce1 Update: click to popup remove-tag-window; select to popup tag-window Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 77 diff changeset	1277 $books_result = $this->GetBooksById($bookId);
51 840cdb52f476 add book_meta into file Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 48 diff changeset	1278 while ($row = mysql_fetch_assoc($books_result)) {
63 3395385476d1 bug fixed: popup tag window is closed automatically when saving text file Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 62 diff changeset	1279 array_push($book_meta, array($row['id'],$row['name'],$row['author'],(string)$row['start_year'],(string)$row['line'],(string)$row['dynasty']));
51 840cdb52f476 add book_meta into file Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 48 diff changeset	1280 // 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	1281 }
69 edb8a2e8ce84 New: save book meta_data in file Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 67 diff changeset	1282 $this->book_meta = $book_meta;
edb8a2e8ce84 New: save book meta_data in file Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 67 diff changeset	1283 */
51 840cdb52f476 add book_meta into file Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 48 diff changeset	1284
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1285 return $stringInput;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1286 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1287
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1288 private function GetDataPath() {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1289 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	1290 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1291
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1292 private function GetTaglistArray() {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1293 $taglistArray = array();
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1294 $result = $this->GetTaglist();
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1295 while ($row = mysql_fetch_assoc($result)) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1296 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	1297 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1298
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1299 return $taglistArray;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1300 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1301
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1302 private function GetWordlistArray() {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1303 $wordlistArray="";
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1304 $result = $this->GetWordlist();
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1305 while ($row = mysql_fetch_assoc($result)) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1306 $listString = file_get_contents("data/wordlist/".$row['id'].".txt");
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1307 $listString = preg_replace("/<div>/u", "\n", $listString);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1308 $listString = preg_replace("/<\/div>/u", "", $listString);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1309 $listString = preg_replace("/<span(.*?)>/u", "", $listString);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1310 $listString = preg_replace("/<\/span>/u", "", $listString);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1311 //$listString = preg_replace("/\n/u", "\|", $listString);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1312
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1313 $wordlistArray2 = explode( "\n", $listString );
71 26d8c4c43d86 minor checking for variable/index in php Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 70 diff changeset	1314 //usort($wordlistArray2,'sortFunction');
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1315 foreach ( $wordlistArray2 as $index=>$value ) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1316 $wordlistArray2[$index] = implode("○?", preg_split("/(?<!^)(?!$)/u", $value));
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1317 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1318 foreach ( $wordlistArray2 as $index=>$value ) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1319 if ($value=="") unset($wordlistArray2[$index]);
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 $listString = implode("\|", $wordlistArray2);
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 if ( $listString[0]=="\|" ) $listString = substr($listString, 1);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1325 $wordlistArray[] = array( $row['id'], $row['name'], $listString );
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1326 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1327
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1328
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1329 return $wordlistArray;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1330
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1331 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1332
78 960ba96efce1 Update: click to popup remove-tag-window; select to popup tag-window Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 77 diff changeset	1333 private function GetBooksInfo($bookId) {
960ba96efce1 Update: click to popup remove-tag-window; select to popup tag-window Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 77 diff changeset	1334 $result = $this->GetSectionsById($bookId);
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1335 while ($row = mysql_fetch_assoc($result)) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1336 $bookName = $row['name'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1337 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1338
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1339 $data = array();
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1340 $data['bookName'] = $bookName;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1341
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1342 return $data;
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
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
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1348
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 ?>

Mercurial > hg > extraction-interface

annotate models/extractapp.php @ 78:960ba96efce1 extractapp