extraction-interface: models/extractapp.php annotate

annotate models/extractapp.php @ 95:9a29e9d28ece extractapp

new: create new topic

author	Zoe Hong <zhong@mpiwg-berlin.mpg.de>
date	Wed, 11 Nov 2015 14:12:55 +0100
parents	b0cecc104639
children	c1bb174a22f3

rev	line source
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1 <?php
81 f1f849d31272 book_id as string Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 79 diff changeset	2 /*
f1f849d31272 book_id as string Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 79 diff changeset	3 * extractapp.php
f1f849d31272 book_id as string Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 79 diff changeset	4 * This file is part of Extraction-interface.
f1f849d31272 book_id as string Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 79 diff changeset	5 *
f1f849d31272 book_id as string Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 79 diff changeset	6 * Extraction-interface is free software: you can redistribute it and/or modify
f1f849d31272 book_id as string Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 79 diff changeset	7 * it under the terms of the GNU General Public License as published by
f1f849d31272 book_id as string Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 79 diff changeset	8 * the Free Software Foundation, either version 3 of the License, or
f1f849d31272 book_id as string Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 79 diff changeset	9 * (at your option) any later version.
f1f849d31272 book_id as string Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 79 diff changeset	10 *
f1f849d31272 book_id as string Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 79 diff changeset	11 * Extraction-interface is distributed in the hope that it will be useful,
f1f849d31272 book_id as string Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 79 diff changeset	12 * but WITHOUT ANY WARRANTY; without even the implied warranty of
f1f849d31272 book_id as string Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 79 diff changeset	13 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
f1f849d31272 book_id as string Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 79 diff changeset	14 * GNU General Public License for more details.
f1f849d31272 book_id as string Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 79 diff changeset	15 *
f1f849d31272 book_id as string Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 79 diff changeset	16 * You should have received a copy of the GNU General Public License
f1f849d31272 book_id as string Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 79 diff changeset	17 * along with Extraction-interface. If not, see <http://www.gnu.org/licenses/>.
f1f849d31272 book_id as string Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 79 diff changeset	18 */
77 97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	19 /**
81 f1f849d31272 book_id as string Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 79 diff changeset	20 * ExtractappModel class is extended from the BaseModel class.
f1f849d31272 book_id as string Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 79 diff changeset	21 * This is where we implement the functions/models to prepare data that been sent to views.
f1f849d31272 book_id as string Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 79 diff changeset	22 * ExtractappModel is notified by Extractapp controller when there has been a change in its state,
f1f849d31272 book_id as string Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 79 diff changeset	23 * and produces the output/data to the corresponding view in "views/Extractapp/".
f1f849d31272 book_id as string Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 79 diff changeset	24 *
77 97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	25 */
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	26
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	27 class ExtractappModel extends BaseModel{
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 protected $section_id = 0, $data_path, $file_id = 0, $current_fileId=0,
87 fb5049fc5dd7 New:(1)UI(2)generate simple regex by examples(3)coordinates in book metadata Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 86 diff changeset	30 $branch_id = 0, $user_id = 0, $lg_text = "", $topic, $taglist_infile = "",
fb5049fc5dd7 New:(1)UI(2)generate simple regex by examples(3)coordinates in book metadata Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 86 diff changeset	31 $book_meta = "", $book_dynasty = "";
fb5049fc5dd7 New:(1)UI(2)generate simple regex by examples(3)coordinates in book metadata Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 86 diff changeset	32
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	33 public $messages = array('info'=>"",'error'=>"",'warning'=>"",'debug'=>"");
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
81 f1f849d31272 book_id as string Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 79 diff changeset	36 public function SetTextFromFileId() { // remove $_postdata as input
f1f849d31272 book_id as string Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 79 diff changeset	37 /**
f1f849d31272 book_id as string Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 79 diff changeset	38 * Get text content from LGService by $this->file_id.
f1f849d31272 book_id as string Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 79 diff changeset	39 * After preprocessing the text string (replace space to circle symbol, link for page number, etc),
f1f849d31272 book_id as string Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 79 diff changeset	40 * set $this->lg_text to the processed text gotten from LGService.
f1f849d31272 book_id as string Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 79 diff changeset	41 */
f1f849d31272 book_id as string Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 79 diff changeset	42
53 f9594c240826 get/update text after saving, for xml file consistency Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 52 diff changeset	43 /*
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	44 $this->file_id = $_postdata['fileId'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	45 $branch_id = $_postdata['branchId'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	46 $section_id = $_postdata['sectionId'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	47
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	48 $this->branch_id = $branch_id;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	49 $this->user_id = $_postdata['userId'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	50 $this->section_id = $section_id;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	51
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	52 $this->section_name = $_postdata['sectionName'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	53 $this->book_id = $_postdata['bookId'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	54 $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	55 */
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	56
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	57 // get from URL with file_id
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	58 $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	59 //$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	60 // --- 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	61 $lg_text = $this->ParseDataInFile($lg_text_url);
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	62
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	63
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	64 $stringInput = $lg_text;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	65 $stringInput = preg_replace("/ /u", "○", $stringInput);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	66 $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	67 $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	68 $lg_text = $stringInput;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	69
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	70 $this->lg_text = $lg_text;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	71
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
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	74 public function SetBookMetadataBySectionId() {
67 3ada9334ebfc New: check taglist is deprecated or not Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 66 diff changeset	75
69 edb8a2e8ce84 New: save book meta_data in file Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 67 diff changeset	76 // 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	77 $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	78 $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	79
69 edb8a2e8ce84 New: save book meta_data in file Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 67 diff changeset	80 $b = $section_meta['section']['book'];
86 0141df465205 New: add chinese characters to pinyin Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 84 diff changeset	81
0141df465205 New: add chinese characters to pinyin Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 84 diff changeset	82 $this->book_name = $b['name'];
0141df465205 New: add chinese characters to pinyin Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 84 diff changeset	83 $this->book_id = $b['id'];
0141df465205 New: add chinese characters to pinyin Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 84 diff changeset	84 /*
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	85 $book_meta = array();
69 edb8a2e8ce84 New: save book meta_data in file Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 67 diff changeset	86 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	87 $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	88 $b['volume'],$b['author'], $b['edition'],$b['in_jibengujiku'], $b['admin_type'])); // missing author,year,pagenumber
86 0141df465205 New: add chinese characters to pinyin Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 84 diff changeset	89 */
0141df465205 New: add chinese characters to pinyin Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 84 diff changeset	90 /*
0141df465205 New: add chinese characters to pinyin Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 84 diff changeset	91 $book_meta = array('id'=>$b['id'],'name'=>$b['name'],'level1'=>$b['level1'],'level2'=>$b['level2'],
0141df465205 New: add chinese characters to pinyin Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 84 diff changeset	92 'period'=>$b['period'],'dynasty'=>$b['dynasty'],'start_year'=>$b['start_year'], 'end_year'=>$b['end_year'],'line'=>$b['line'],
0141df465205 New: add chinese characters to pinyin Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 84 diff changeset	93 'volume'=>$b['volume'],'author'=>$b['author'],'edition'=>$b['edition'],
0141df465205 New: add chinese characters to pinyin Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 84 diff changeset	94 'in_jibengujiku'=>$b['in_jibengujiku'],'admin_type'=>$b['admin_type']); // missing author,year,pagenumber
0141df465205 New: add chinese characters to pinyin Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 84 diff changeset	95 */
0141df465205 New: add chinese characters to pinyin Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 84 diff changeset	96
0141df465205 New: add chinese characters to pinyin Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 84 diff changeset	97 $book_meta->id = $b['id'];
0141df465205 New: add chinese characters to pinyin Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 84 diff changeset	98 $book_meta->name = $b['name'];
0141df465205 New: add chinese characters to pinyin Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 84 diff changeset	99 $book_meta->level1 = $b['level1'];
0141df465205 New: add chinese characters to pinyin Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 84 diff changeset	100 $book_meta->level2 = $b['level2'];
0141df465205 New: add chinese characters to pinyin Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 84 diff changeset	101 $book_meta->period = $b['period'];
0141df465205 New: add chinese characters to pinyin Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 84 diff changeset	102 $book_meta->dynasty = $b['dynasty'];
0141df465205 New: add chinese characters to pinyin Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 84 diff changeset	103 $book_meta->start_year = $b['start_year'];
0141df465205 New: add chinese characters to pinyin Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 84 diff changeset	104 $book_meta->end_year = $b['end_year'];
0141df465205 New: add chinese characters to pinyin Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 84 diff changeset	105 $book_meta->line = $b['line'];
0141df465205 New: add chinese characters to pinyin Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 84 diff changeset	106 $book_meta->volume = $b['volume'];
0141df465205 New: add chinese characters to pinyin Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 84 diff changeset	107 $book_meta->author = $b['author'];
0141df465205 New: add chinese characters to pinyin Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 84 diff changeset	108 $book_meta->edition = $b['edition'];
0141df465205 New: add chinese characters to pinyin Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 84 diff changeset	109 $book_meta->in_jibengujiku = $b['in_jibengujiku'];
0141df465205 New: add chinese characters to pinyin Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 84 diff changeset	110 $book_meta->admin_type = $b['admin_type'];
0141df465205 New: add chinese characters to pinyin Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 84 diff changeset	111
87 fb5049fc5dd7 New:(1)UI(2)generate simple regex by examples(3)coordinates in book metadata Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 86 diff changeset	112 $coordinates = $section_meta['section']['coordinates_books'];
fb5049fc5dd7 New:(1)UI(2)generate simple regex by examples(3)coordinates in book metadata Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 86 diff changeset	113 $book_meta->x = $coordinates['x'];
fb5049fc5dd7 New:(1)UI(2)generate simple regex by examples(3)coordinates in book metadata Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 86 diff changeset	114 $book_meta->y = $coordinates['y'];
fb5049fc5dd7 New:(1)UI(2)generate simple regex by examples(3)coordinates in book metadata Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 86 diff changeset	115 $book_meta->place_name = $coordinates['place_name'];
fb5049fc5dd7 New:(1)UI(2)generate simple regex by examples(3)coordinates in book metadata Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 86 diff changeset	116
fb5049fc5dd7 New:(1)UI(2)generate simple regex by examples(3)coordinates in book metadata Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 86 diff changeset	117
86 0141df465205 New: add chinese characters to pinyin Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 84 diff changeset	118
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	119 $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	120
3395385476d1 bug fixed: popup tag window is closed automatically when saving text file Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 62 diff changeset	121 }
3395385476d1 bug fixed: popup tag window is closed automatically when saving text file Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 62 diff changeset	122
81 f1f849d31272 book_id as string Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 79 diff changeset	123 public function SetTextFromSectionId() { // remove $_postdata as input
f1f849d31272 book_id as string Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 79 diff changeset	124 /**
f1f849d31272 book_id as string Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 79 diff changeset	125 * Get text content from LGService by $this->section_id.
f1f849d31272 book_id as string Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 79 diff changeset	126 * After preprocessing the text string (replace space to circle symbol, link for page number, etc),
f1f849d31272 book_id as string Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 79 diff changeset	127 * set $this->lg_text to the processed text gotten from LGService.
f1f849d31272 book_id as string Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 79 diff changeset	128 */
f1f849d31272 book_id as string Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 79 diff changeset	129
53 f9594c240826 get/update text after saving, for xml file consistency Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 52 diff changeset	130 /*
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	131 $section_id = $_postdata['sectionId'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	132 $this->section_id = $section_id;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	133 $this->user_id = $_postdata['userId'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	134
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	135 $this->section_name = $_postdata['sectionName'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	136 $this->book_id = $_postdata['bookId'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	137 $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	138 */
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	139
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	140 // 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	141 // $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	142 $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	143 $lg_text = file_get_contents($lg_text_url);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	144
51 840cdb52f476 add book_meta into file Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 48 diff changeset	145
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	146 $stringInput = $lg_text;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	147 $stringInput = preg_replace("/<(.*?)>/u", "○", $stringInput);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	148 $stringInput = preg_replace("/ /u", "○", $stringInput);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	149 $stringInput = preg_replace("/\n/u", "<br>", $stringInput);
73 2daef8e36214 minor modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 71 diff changeset	150 $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	151 $lg_text = $stringInput;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	152
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	153 $this->lg_text = $lg_text;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	154 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	155
74 60b5a94163c3 New: retrieve book meta data from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 73 diff changeset	156 // This is only used on localhost
81 f1f849d31272 book_id as string Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 79 diff changeset	157 public function SetTextFromLocal($_id){
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	158 $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	159 //$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	160 $this->messages['debug'] .= "[Debug] from my local"."<br>";
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	161 $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	162 }
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	163
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	164
81 f1f849d31272 book_id as string Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 79 diff changeset	165 public function SetInfoFromPreviousPage($_postdata) {
f1f849d31272 book_id as string Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 79 diff changeset	166 /**
f1f849d31272 book_id as string Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 79 diff changeset	167 * Get information from post data passsed by the previous page, and set variables in $this.
f1f849d31272 book_id as string Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 79 diff changeset	168 * The previous page could be:
f1f849d31272 book_id as string Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 79 diff changeset	169 *
f1f849d31272 book_id as string Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 79 diff changeset	170 * (1) LGService: the first time user enters Extraction-interface, which should linked from LGService.
f1f849d31272 book_id as string Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 79 diff changeset	171 *
f1f849d31272 book_id as string Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 79 diff changeset	172 * (2) Extraction-interface itself: changing topic then continue to tag, saving text to LGService, reload the text from LGService.
f1f849d31272 book_id as string Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 79 diff changeset	173 *
f1f849d31272 book_id as string Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 79 diff changeset	174 */
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	175
71 26d8c4c43d86 minor checking for variable/index in php Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 70 diff changeset	176 if (isset($_postdata['fileId'])) {
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	177 $this->file_id = $_postdata['fileId'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	178 }
71 26d8c4c43d86 minor checking for variable/index in php Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 70 diff changeset	179 if (isset($_postdata['sectionId'])) {
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	180 $this->section_id = $_postdata['sectionId'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	181 }
71 26d8c4c43d86 minor checking for variable/index in php Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 70 diff changeset	182 if (isset($_postdata['text'])) {
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	183 $this->lg_text = $_postdata['text'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	184 }
71 26d8c4c43d86 minor checking for variable/index in php Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 70 diff changeset	185 if (isset($_postdata['branchId'])) {
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	186 $this->branch_id = $_postdata['branchId'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	187 }
71 26d8c4c43d86 minor checking for variable/index in php Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 70 diff changeset	188 if (isset($_postdata['userId'])) {
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	189 $this->user_id = $_postdata['userId'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	190 }
95 9a29e9d28ece new: create new topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 94 diff changeset	191 if (isset($_postdata['topic'])) {
9a29e9d28ece new: create new topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 94 diff changeset	192 $this->topic = $_postdata['topic'];
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	193 }
95 9a29e9d28ece new: create new topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 94 diff changeset	194
71 26d8c4c43d86 minor checking for variable/index in php Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 70 diff changeset	195 if (isset($_postdata['sectionName'])) {
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	196 $this->section_name = $_postdata['sectionName'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	197 }
71 26d8c4c43d86 minor checking for variable/index in php Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 70 diff changeset	198 if (isset($_postdata['bookName'])) {
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	199 $this->book_name = $_postdata['bookName'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	200 }
71 26d8c4c43d86 minor checking for variable/index in php Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 70 diff changeset	201 if (isset($_postdata['bookId'])) {
83 7b05275b7a70 book_id as string in postdata Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 82 diff changeset	202 $this->book_id = $_postdata['bookId'];
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	203 }
71 26d8c4c43d86 minor checking for variable/index in php Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 70 diff changeset	204 if (isset($_postdata['currentFileId'])) {
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	205 $this->current_fileId = $_postdata['currentFileId'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	206 }
71 26d8c4c43d86 minor checking for variable/index in php Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 70 diff changeset	207 if (isset($_postdata['taglistArray'])) {
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	208 $this->taglist_infile = json_decode($_postdata['taglistArray']);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	209 }
71 26d8c4c43d86 minor checking for variable/index in php Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 70 diff changeset	210 if (isset($_postdata['book_meta'])) {
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	211 $this->book_meta = json_decode($_postdata['book_meta']);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	212 }
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
67 3ada9334ebfc New: check taglist is deprecated or not Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 66 diff changeset	216
3ada9334ebfc New: check taglist is deprecated or not Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 66 diff changeset	217 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	218 // 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	219 $cnt_list1 = count($list1);
3ada9334ebfc New: check taglist is deprecated or not Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 66 diff changeset	220 $cnt_list2 = count($list2);
3ada9334ebfc New: check taglist is deprecated or not Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 66 diff changeset	221
3ada9334ebfc New: check taglist is deprecated or not Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 66 diff changeset	222 if ($cnt_list1 > $cnt_list2) {
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	223 return false;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	224 }
67 3ada9334ebfc New: check taglist is deprecated or not Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 66 diff changeset	225 foreach ($list1 as $v1) {
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	226 $cnt = 0;
67 3ada9334ebfc New: check taglist is deprecated or not Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 66 diff changeset	227 foreach ($list2 as $v2) {
3ada9334ebfc New: check taglist is deprecated or not Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 66 diff changeset	228 $num_field = count($v2);
3ada9334ebfc New: check taglist is deprecated or not Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 66 diff changeset	229 $matched = true;
3ada9334ebfc New: check taglist is deprecated or not Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 66 diff changeset	230 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	231 if ($v1[$i] != $v2[$i]) {
3ada9334ebfc New: check taglist is deprecated or not Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 66 diff changeset	232 $matched = false;
3ada9334ebfc New: check taglist is deprecated or not Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 66 diff changeset	233 break;
3ada9334ebfc New: check taglist is deprecated or not Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 66 diff changeset	234 }
3ada9334ebfc New: check taglist is deprecated or not Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 66 diff changeset	235 }
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	236
67 3ada9334ebfc New: check taglist is deprecated or not Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 66 diff changeset	237 if (!$matched) {
3ada9334ebfc New: check taglist is deprecated or not Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 66 diff changeset	238 // not match with this v2
3ada9334ebfc New: check taglist is deprecated or not Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 66 diff changeset	239 $cnt += 1;
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	240 } else {
67 3ada9334ebfc New: check taglist is deprecated or not Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 66 diff changeset	241 break;
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	242 }
67 3ada9334ebfc New: check taglist is deprecated or not Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 66 diff changeset	243
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	244 }
67 3ada9334ebfc New: check taglist is deprecated or not Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 66 diff changeset	245 if ($cnt == $cnt_list2) {
3ada9334ebfc New: check taglist is deprecated or not Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 66 diff changeset	246 return false;
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	247 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	248 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	249 return true;
67 3ada9334ebfc New: check taglist is deprecated or not Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 66 diff changeset	250
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	251 }
86 0141df465205 New: add chinese characters to pinyin Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 84 diff changeset	252
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	253 // === for tagging ===
94 b0cecc104639 new: modified tags can work on tagged text Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 91 diff changeset	254 private function ReplaceLgTextWithLatestTag() {
b0cecc104639 new: modified tags can work on tagged text Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 91 diff changeset	255 // modify $this->lg_text with the latest tags from database
b0cecc104639 new: modified tags can work on tagged text Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 91 diff changeset	256 // can do it by getting the tag's id using tag's information in the file, then by the id to get latest tag (in db)
b0cecc104639 new: modified tags can work on tagged text Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 91 diff changeset	257 $lg_text = $this->lg_text;
b0cecc104639 new: modified tags can work on tagged text Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 91 diff changeset	258
b0cecc104639 new: modified tags can work on tagged text Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 91 diff changeset	259 $taglist_indb = $this->GetTaglistByTopicId($this->GetTopic());
b0cecc104639 new: modified tags can work on tagged text Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 91 diff changeset	260 $taglist_infile = $this->taglist_infile;
b0cecc104639 new: modified tags can work on tagged text Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 91 diff changeset	261
b0cecc104639 new: modified tags can work on tagged text Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 91 diff changeset	262 if ($taglist_infile == "") return;
b0cecc104639 new: modified tags can work on tagged text Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 91 diff changeset	263
b0cecc104639 new: modified tags can work on tagged text Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 91 diff changeset	264 $count_tag_indb = count($taglist_indb);
b0cecc104639 new: modified tags can work on tagged text Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 91 diff changeset	265
b0cecc104639 new: modified tags can work on tagged text Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 91 diff changeset	266 foreach ($taglist_infile as $t1) {
b0cecc104639 new: modified tags can work on tagged text Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 91 diff changeset	267 $id = $t1[0];
b0cecc104639 new: modified tags can work on tagged text Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 91 diff changeset	268 $tag = $t1[2];
b0cecc104639 new: modified tags can work on tagged text Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 91 diff changeset	269 $latest_tag = "";
b0cecc104639 new: modified tags can work on tagged text Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 91 diff changeset	270
b0cecc104639 new: modified tags can work on tagged text Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 91 diff changeset	271 $cnt = 0;
b0cecc104639 new: modified tags can work on tagged text Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 91 diff changeset	272 foreach ($taglist_indb as $t2) {
b0cecc104639 new: modified tags can work on tagged text Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 91 diff changeset	273 if ($t2[0] == $id) {
b0cecc104639 new: modified tags can work on tagged text Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 91 diff changeset	274 $latest_tag = $t2[2];
b0cecc104639 new: modified tags can work on tagged text Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 91 diff changeset	275 }
b0cecc104639 new: modified tags can work on tagged text Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 91 diff changeset	276
b0cecc104639 new: modified tags can work on tagged text Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 91 diff changeset	277 if ($tag != $t2[2]) {
b0cecc104639 new: modified tags can work on tagged text Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 91 diff changeset	278 // not match with this t2
b0cecc104639 new: modified tags can work on tagged text Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 91 diff changeset	279 $cnt += 1;
b0cecc104639 new: modified tags can work on tagged text Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 91 diff changeset	280 } else {
b0cecc104639 new: modified tags can work on tagged text Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 91 diff changeset	281 break;
b0cecc104639 new: modified tags can work on tagged text Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 91 diff changeset	282 }
b0cecc104639 new: modified tags can work on tagged text Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 91 diff changeset	283
b0cecc104639 new: modified tags can work on tagged text Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 91 diff changeset	284 }
b0cecc104639 new: modified tags can work on tagged text Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 91 diff changeset	285 if ($cnt == $count_tag_indb) {
b0cecc104639 new: modified tags can work on tagged text Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 91 diff changeset	286 if ($latest_tag == "") {
b0cecc104639 new: modified tags can work on tagged text Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 91 diff changeset	287 // tag has been deleted in the db
b0cecc104639 new: modified tags can work on tagged text Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 91 diff changeset	288 // delele the tag in $this->lg_text
b0cecc104639 new: modified tags can work on tagged text Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 91 diff changeset	289 //echo "tag been deleted";
b0cecc104639 new: modified tags can work on tagged text Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 91 diff changeset	290
b0cecc104639 new: modified tags can work on tagged text Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 91 diff changeset	291 $lg_text = preg_replace("/<\/".$tag.">/u", "", $lg_text);
b0cecc104639 new: modified tags can work on tagged text Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 91 diff changeset	292 $lg_text = preg_replace("/<".$tag.">/u", "", $lg_text);
b0cecc104639 new: modified tags can work on tagged text Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 91 diff changeset	293
b0cecc104639 new: modified tags can work on tagged text Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 91 diff changeset	294 } else {
b0cecc104639 new: modified tags can work on tagged text Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 91 diff changeset	295 // replace all tags $tag into $latest_tag in $this->lg_text
b0cecc104639 new: modified tags can work on tagged text Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 91 diff changeset	296 //echo "replace tag: ".$tag." into ".$latest_tag."<br>";
b0cecc104639 new: modified tags can work on tagged text Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 91 diff changeset	297 $lg_text = preg_replace("/".$tag."/u", $latest_tag, $lg_text);
b0cecc104639 new: modified tags can work on tagged text Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 91 diff changeset	298 }
b0cecc104639 new: modified tags can work on tagged text Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 91 diff changeset	299 }
b0cecc104639 new: modified tags can work on tagged text Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 91 diff changeset	300 }
b0cecc104639 new: modified tags can work on tagged text Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 91 diff changeset	301
b0cecc104639 new: modified tags can work on tagged text Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 91 diff changeset	302
b0cecc104639 new: modified tags can work on tagged text Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 91 diff changeset	303 $this->lg_text = $lg_text;
b0cecc104639 new: modified tags can work on tagged text Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 91 diff changeset	304
b0cecc104639 new: modified tags can work on tagged text Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 91 diff changeset	305 }
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	306 public function StartTagging() {
81 f1f849d31272 book_id as string Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 79 diff changeset	307 /**
f1f849d31272 book_id as string Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 79 diff changeset	308 * This is the main method for tagging text. It passes all the information to "views/Extractapp/TaggingText.php" view.
f1f849d31272 book_id as string Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 79 diff changeset	309 * The information contain the text string, taglist array, wordlis array, topic, etc.
f1f849d31272 book_id as string Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 79 diff changeset	310 */
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	311
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	312 $section_id = $this->section_id;
94 b0cecc104639 new: modified tags can work on tagged text Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 91 diff changeset	313
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	314 $data = array(); // data array to be passed to view
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	315
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	316 //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	317 $taglistArray = $this->GetTaglistByTopicId($this->GetTopic());
86 0141df465205 New: add chinese characters to pinyin Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 84 diff changeset	318
67 3ada9334ebfc New: check taglist is deprecated or not Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 66 diff changeset	319 // $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	320 // $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	321 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	322 $this->taglist_infile = "";
94 b0cecc104639 new: modified tags can work on tagged text Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 91 diff changeset	323
b0cecc104639 new: modified tags can work on tagged text Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 91 diff changeset	324 } else {
b0cecc104639 new: modified tags can work on tagged text Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 91 diff changeset	325 // taglist_infile is out-to-date
b0cecc104639 new: modified tags can work on tagged text Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 91 diff changeset	326 // replace all the old tag with new ones in database
b0cecc104639 new: modified tags can work on tagged text Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 91 diff changeset	327 // replace old tags for $this->lg_text with the latest tags from db
b0cecc104639 new: modified tags can work on tagged text Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 91 diff changeset	328 $this->ReplaceLgTextWithLatestTag();
b0cecc104639 new: modified tags can work on tagged text Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 91 diff changeset	329
b0cecc104639 new: modified tags can work on tagged text Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 91 diff changeset	330 }
b0cecc104639 new: modified tags can work on tagged text Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 91 diff changeset	331 $stringInput = $this->lg_text;
b0cecc104639 new: modified tags can work on tagged text Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 91 diff changeset	332
b0cecc104639 new: modified tags can work on tagged text Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 91 diff changeset	333
67 3ada9334ebfc New: check taglist is deprecated or not Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 66 diff changeset	334 $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
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	335
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	336 // book_meta
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	337 $data['book_meta'] = $this->book_meta;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	338
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	339 // topic list
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	340 $topiclistArray = $this->GetTopiclistArray();
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	341
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	342
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	343 $wordlistArray = $this->GetWordlistArray();
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	344
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	345 $data['stringInput'] = $stringInput;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	346 $data['taglistArray'] = $taglistArray;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	347 $data['wordlistArray'] = $wordlistArray;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	348 $data['section_id'] = $section_id;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	349 $data['topiclistArray'] = $topiclistArray;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	350 $data['default_topic_id'] = $this->GetTopic();
86 0141df465205 New: add chinese characters to pinyin Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 84 diff changeset	351 $topic_id = $this->GetTopic();
0141df465205 New: add chinese characters to pinyin Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 84 diff changeset	352
0141df465205 New: add chinese characters to pinyin Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 84 diff changeset	353 $data['topic_tag'] = $this->GetTopicTag($topic_id);
0141df465205 New: add chinese characters to pinyin Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 84 diff changeset	354 $data['topic_name'] = $this->GetTopicName($topic_id);
0141df465205 New: add chinese characters to pinyin Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 84 diff changeset	355 $data['topic_tag_ch'] = $this->GetTopicTagName($topic_id);
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	356
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	357 $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	358 'branch_id'=>$this->branch_id, 'section_id'=>$this->section_id, 'book_id'=>$this->book_id,
86 0141df465205 New: add chinese characters to pinyin Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 84 diff changeset	359 'book_name'=>$this->book_name,'section_name'=>$this->section_name, 'period'=>$this->book_meta->period,
91 3e11a9c5a672 new: explore table for using on LGMap Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 90 diff changeset	360 'current_fileId'=>$this->current_fileId);
3e11a9c5a672 new: explore table for using on LGMap Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 90 diff changeset	361
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	362
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 $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	364 $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	365 $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	366 $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	367 $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	368
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	369 $this->messages['info'] .= "[Info] book name: ".$this->book_name;
91 3e11a9c5a672 new: explore table for using on LGMap Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 90 diff changeset	370 $this->messages['info'] .= ", period: ".$this->book_meta->period;
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	371 $this->messages['info'] .= ", section id: ". $this->section_id;
91 3e11a9c5a672 new: explore table for using on LGMap Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 90 diff changeset	372 $this->messages['info'] .= ", section name: ".$this->section_name;
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	373 $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	374 $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	375 $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	376
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	377
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	378 $data['messages'] = $this->messages;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	379
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	380 return $data;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	381
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	382 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	383
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	384 public function SaveFullText($postdata) {
81 f1f849d31272 book_id as string Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 79 diff changeset	385 // locally
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	386 if ($postdata['text']){
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	387 $date = date('Y_m_d_H_i_s', time());
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	388 if ( file_exists("data/parsing_files/".$postdata['filename'].".txt") ) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	389 $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	390 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	391 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	392
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	393 if (get_magic_quotes_gpc()) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	394 $require = stripslashes($postdata['text']);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	395 } else {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	396 $require = $postdata['text'];
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 $require = preg_replace("/【<a(.?)>(.?)<\/a>】/u", "【\\2】", $require);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	400 $require = preg_replace('/&/u', "&", $require);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	401 $require = preg_replace("/○/u", " ", $require);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	402 $require = preg_replace("/<br>/u", "\n", $require);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	403 $require = preg_replace("/<br>/u", "\n", $require);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	404 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	405 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	406
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
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	409 public function UpdateInfoResponsedFromLGService($response) {
81 f1f849d31272 book_id as string Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 79 diff changeset	410 /**
86 0141df465205 New: add chinese characters to pinyin Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 84 diff changeset	411 *
81 f1f849d31272 book_id as string Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 79 diff changeset	412 */
f1f849d31272 book_id as string Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 79 diff changeset	413
73 2daef8e36214 minor modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 71 diff changeset	414 if (isset($response["file"])) {
2daef8e36214 minor modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 71 diff changeset	415 $response_file = $response["file"];
2daef8e36214 minor modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 71 diff changeset	416 }
2daef8e36214 minor modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 71 diff changeset	417 if (isset($response["branch"])) {
2daef8e36214 minor modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 71 diff changeset	418 $response_branch = $response["branch"];
2daef8e36214 minor modification Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 71 diff changeset	419 }
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	420
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	421 $status = (string)$response["status"];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	422 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	423 $this->messages['info'] .= "[Info] Saving success. <br>";
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	424 $this->file_id = (string)$response_file["id"];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	425 $this->branch_id = (string)$response_branch["id"];
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 } else if ($status == "error") {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	428 // 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	429 $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	430 $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	431
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	432 $response_currentFile = $response["currentFile"];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	433 $this->current_fileId = (string)$response_currentFile["id"];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	434
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	435 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	436
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	437
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	438 }
57 5cf9720a2e25 New: add reloadText to load the latest version Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 56 diff changeset	439
5cf9720a2e25 New: add reloadText to load the latest version Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 56 diff changeset	440 public function ReloadSetting() {
5cf9720a2e25 New: add reloadText to load the latest version Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 56 diff changeset	441 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	442 $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	443 $this->current_fileId = 0;
5cf9720a2e25 New: add reloadText to load the latest version Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 56 diff changeset	444 }
5cf9720a2e25 New: add reloadText to load the latest version Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 56 diff changeset	445 }
5cf9720a2e25 New: add reloadText to load the latest version Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 56 diff changeset	446
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	447 // 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	448 private function AppendMetadata($text_content) {
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	449 $text = '<?xml version="1.0" encoding="UTF-8"?>';
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	450 $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	451 // --- topic ---
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	452 $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	453 // --- book meta data ---
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	454 $book = $this->book_meta;
86 0141df465205 New: add chinese characters to pinyin Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 84 diff changeset	455
0141df465205 New: add chinese characters to pinyin Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 84 diff changeset	456 $text .= "<book>\n";
87 fb5049fc5dd7 New:(1)UI(2)generate simple regex by examples(3)coordinates in book metadata Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 86 diff changeset	457 $text .= "<id>".$book->id."</id>\n";
fb5049fc5dd7 New:(1)UI(2)generate simple regex by examples(3)coordinates in book metadata Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 86 diff changeset	458 $text .= "<name>".$book->name."</name>\n";
fb5049fc5dd7 New:(1)UI(2)generate simple regex by examples(3)coordinates in book metadata Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 86 diff changeset	459 $text .= "<level1>".$book->level1."</level1>\n";
fb5049fc5dd7 New:(1)UI(2)generate simple regex by examples(3)coordinates in book metadata Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 86 diff changeset	460 $text .= "<level2>".$book->level2."</level2>\n";
fb5049fc5dd7 New:(1)UI(2)generate simple regex by examples(3)coordinates in book metadata Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 86 diff changeset	461 $text .= "<period>".$book->period."</period>\n";
fb5049fc5dd7 New:(1)UI(2)generate simple regex by examples(3)coordinates in book metadata Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 86 diff changeset	462 $text .= "<dynasty>".$book->dynasty."</dynasty>\n";
fb5049fc5dd7 New:(1)UI(2)generate simple regex by examples(3)coordinates in book metadata Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 86 diff changeset	463 $text .= "<start_year>".$book->start_year."</start_year>\n";
fb5049fc5dd7 New:(1)UI(2)generate simple regex by examples(3)coordinates in book metadata Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 86 diff changeset	464 $text .= "<end_year>".$book->end_year."</end_year>\n";
fb5049fc5dd7 New:(1)UI(2)generate simple regex by examples(3)coordinates in book metadata Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 86 diff changeset	465 $text .= "<line>".$book->line."</line>\n";
fb5049fc5dd7 New:(1)UI(2)generate simple regex by examples(3)coordinates in book metadata Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 86 diff changeset	466 $text .= "<volume>".$book->volume."</volume>\n";
fb5049fc5dd7 New:(1)UI(2)generate simple regex by examples(3)coordinates in book metadata Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 86 diff changeset	467 $text .= "<author>".$book->author."</author>\n";
fb5049fc5dd7 New:(1)UI(2)generate simple regex by examples(3)coordinates in book metadata Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 86 diff changeset	468 $text .= "<edition>".$book->edition."</edition>\n";
fb5049fc5dd7 New:(1)UI(2)generate simple regex by examples(3)coordinates in book metadata Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 86 diff changeset	469 $text .= "<in_jibengujiku>".$book->in_jibengujiku."</in_jibengujiku>\n";
fb5049fc5dd7 New:(1)UI(2)generate simple regex by examples(3)coordinates in book metadata Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 86 diff changeset	470 $text .= "<admin_type>".$book->admin_type."</admin_type>\n";
fb5049fc5dd7 New:(1)UI(2)generate simple regex by examples(3)coordinates in book metadata Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 86 diff changeset	471
fb5049fc5dd7 New:(1)UI(2)generate simple regex by examples(3)coordinates in book metadata Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 86 diff changeset	472 $text .= "<place_name>".$book->place_name."</place_name>\n";
fb5049fc5dd7 New:(1)UI(2)generate simple regex by examples(3)coordinates in book metadata Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 86 diff changeset	473 $text .= "<x>".$book->x."</x>\n";
fb5049fc5dd7 New:(1)UI(2)generate simple regex by examples(3)coordinates in book metadata Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 86 diff changeset	474 $text .= "<y>".$book->y."</y>\n";
86 0141df465205 New: add chinese characters to pinyin Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 84 diff changeset	475 $text .= "</book>\n";
0141df465205 New: add chinese characters to pinyin Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 84 diff changeset	476
0141df465205 New: add chinese characters to pinyin Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 84 diff changeset	477
77 97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	478 // --- section info ---
97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	479 $text .= "<section>\n";
97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	480 $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	481 $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	482 $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	483
75233b09c580 saving latest taglist from db according to topic (even when changing topic) Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 74 diff changeset	484 // ---- 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	485 // $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	486 // obtain the latest taglist from db
94 b0cecc104639 new: modified tags can work on tagged text Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 91 diff changeset	487 // TDOO: possible bug: when taglist is modified by other user, the latest taglist from db of course will be changed.
b0cecc104639 new: modified tags can work on tagged text Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 91 diff changeset	488 // As the result, here the taglist we get from db will be inconsistent with the tag in file.
b0cecc104639 new: modified tags can work on tagged text Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 91 diff changeset	489 // which means the information in <tagitem> nodes are inconsistent with the text in <text_content> node.
b0cecc104639 new: modified tags can work on tagged text Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 91 diff changeset	490
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	491 $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	492
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	493 foreach ($taglist as $tagitem) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	494 $text .= "<tagitem>\n";
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	495 $text .= "<id>".$tagitem[0]."</id>\n";
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	496 $text .= "<name>".$tagitem[1]."</name>\n";
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	497 $text .= "<tag>".$tagitem[2]."</tag>\n";
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	498 $text .= "<color>".$tagitem[3]."</color>\n";
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	499 $text .= "</tagitem>\n";
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	500 }
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	501 // ----
75233b09c580 saving latest taglist from db according to topic (even when changing topic) Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 74 diff changeset	502 // --- text_content ---
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	503 $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	504 $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	505 // ----
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	506
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	507 return $text;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	508 }
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	509
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	510 public function SaveFullTextToLGService($_postdata) {
81 f1f849d31272 book_id as string Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 79 diff changeset	511 /**
f1f849d31272 book_id as string Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 79 diff changeset	512 * It saves the full tagged text string in postdata to LGService.
f1f849d31272 book_id as string Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 79 diff changeset	513 * The responses returned by LGService will later be handled in
f1f849d31272 book_id as string Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 79 diff changeset	514 */
f1f849d31272 book_id as string Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 79 diff changeset	515
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	516 // --------
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	517 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	518
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	519 if ($_postdata['text']){
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	520 $date = date('Y_m_d_H_i_s', time());
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	521 if ( file_exists("data/parsing_files/".$_postdata['sectionId'].".txt") ) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	522 $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	523 //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	524 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	525 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	526 }
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	527 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	528
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	529 if (get_magic_quotes_gpc()) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	530 $require = stripslashes($_postdata['text']);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	531 } else {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	532 $require = $_postdata['text'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	533 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	534
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	535 $require = preg_replace("/【<a(.?)>(.?)<\/a>】/u", "【\\2】", $require);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	536 $require = preg_replace('/&/u', "&", $require);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	537 $require = preg_replace("/○/u", " ", $require);
79 e6e213b26454 Bug fixed: file crashed after saving (preg_replace remove unnecessary symbols within br tag Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 78 diff changeset	538 $require = preg_replace("/<br(.*?)>/u", "\n", $require);
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	539 //$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	540
76 c49192885290 Bug fixed: ambiguous tag occured at Editing-text mode Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 75 diff changeset	541 $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	542
c49192885290 Bug fixed: ambiguous tag occured at Editing-text mode Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 75 diff changeset	543 /*
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	544 if ($_postdata['branchId'] == 0) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	545 // -- 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	546 $require = "<text_content>".$require."</text_content>\n";
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	547 }
76 c49192885290 Bug fixed: ambiguous tag occured at Editing-text mode Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 75 diff changeset	548 */
c49192885290 Bug fixed: ambiguous tag occured at Editing-text mode Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 75 diff changeset	549
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	550 $require = $this->AppendMetadata($require);
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	551
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	552 //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	553 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	554 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	555 }
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	556 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	557
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
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	560
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	561 if ($_postdata['branchId'] != 0) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	562 // -- exiting branch case
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	563 $postfields = array(
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	564 "text" => $require,
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	565 "branchId" => $_postdata['branchId'],
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	566 "userId" => $_postdata['userId'],
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	567 "userPreviousFileId" => $_postdata['fileId'],
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 $save_url = $this->save_to_LGService_url;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	570
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	571 } else {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	572 // -- 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	573 // echo "saveNew!";
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	574 $user_id = "0";
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	575 if ($_postdata['userId']) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	576 $user_id = $_postdata['userId'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	577 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	578
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	579 $postfields = array(
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	580 "text" => $require,
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	581 "sectionId" => $_postdata['sectionId'],
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	582 "userId" => $user_id,
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	583 "label" => $_postdata['label'],
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	584 );
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	585 $save_url = $this->save_new_to_LGService_url;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	586 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	587
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	588
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	589 // set up the curl resource
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	590 $ch = curl_init();
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	591 curl_setopt($ch, CURLOPT_URL, $save_url);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	592 curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	593 curl_setopt($ch, CURLOPT_CUSTOMREQUEST, "POST");
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	594 curl_setopt($ch, CURLOPT_POST, true);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	595 curl_setopt($ch, CURLOPT_POSTFIELDS, $postfields);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	596 //curl_setopt($ch, CURLOPT_HEADER, true);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	597 curl_setopt($ch, CURLOPT_HTTPHEADER, array(
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	598 'Content-type: multipart/form-data;charset=utf-8'
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	599 ));
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	600
90 94ad33739fa4 modify the position of buttons in sidebar Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 89 diff changeset	601 //if (!$AT_LOCAL) {
94ad33739fa4 modify the position of buttons in sidebar Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 89 diff changeset	602 // execute the request
94ad33739fa4 modify the position of buttons in sidebar Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 89 diff changeset	603 $output = curl_exec($ch);
94ad33739fa4 modify the position of buttons in sidebar Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 89 diff changeset	604 //}
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	605
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	606
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	607 // output the profile information - includes the header
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	608 //echo($output) . PHP_EOL;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	609
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	610 // close curl resource to free up system resources
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	611 curl_close($ch);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	612
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	613 $response = json_decode($output, true);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	614 return $response;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	615
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	616 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	617
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	618 // --- 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	619 private function GetRegexFilenameById($topic_id) {
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	620 $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	621 $result = mysql_query($query);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	622 if (!$result) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	623 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	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 $filenames = array();
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	627 while ($row = mysql_fetch_assoc($result)) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	628 array_push($filenames, $row['regex_filename']);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	629 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	630
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	631 return $filenames;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	632 }
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	633 public function LoadSmartRegex($topic_id) {
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	634
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	635 // 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	636 $filenames = $this->GetRegexFilenameById($topic_id);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	637
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	638 // Get regex file from filesystem ----
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	639 $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	640 $returnArray = array();
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	641 $files1 = scandir($data_path."regex_files");
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	642 foreach ( $files1 as $file ) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	643 if ( $file != "." && $file != ".." && $file != ".DS_Store") {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	644 foreach ($filenames as $filename) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	645 if ($file == $filename) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	646 $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	647 break;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	648 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	649 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	650 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	651 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	652 echo json_encode($returnArray);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	653 return;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	654 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	655
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	656
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	657 public function SaveSmartRegex($_postdata) {
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	658 if ($_postdata['text']){
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	659
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	660 // --- update topic_regex_relation table ---
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	661 $topic_id = $_postdata['topic_id'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	662 $filename = $_postdata['filename'].'.txt';
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	663
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	664 // 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	665 $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	666 $result = mysql_query($query);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	667 if (!$result) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	668 echo json_encode("ErrorDB");
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	669 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	670 while ($row = mysql_fetch_assoc($result)) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	671 if ($row && !$_postdata['forcesave']) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	672 // promt user a comfirm to force saving or not
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	673 echo json_encode("ForceSave");
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	674 return;
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
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	679 if (!$_postdata['forcesave']) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	680 $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	681 $result = mysql_query($query);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	682 if (!$result) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	683 echo json_encode("ErrorDB");
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	684 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	685 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	686 // --- write to filesystem ---
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 /*
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	689 $date = date('Y_m_d_H_i_s', time());
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	690 if ( file_exists("regex_files/".$_POST['filename'].".txt") ) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	691 $oldFile = file_get_contents("regex_files/".$_POST['filename'].".txt");
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	692 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	693 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	694 */
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	695 $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	696
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	697 if (get_magic_quotes_gpc()) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	698 $require = stripslashes($_postdata['text']);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	699 } else {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	700 $require = $_postdata['text'];
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
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	703 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	704
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	705
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	706 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	707 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	708
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	709
77 97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	710 private function GetTableArray($_taglistArray, $_topic_tag, $_content) {
47 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 $outputTableArray = array();
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	713 $outputTableArray[0]=array();
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	714 $outputTableArray[0][0]=array();
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	715 $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	716 foreach ( $_taglistArray as $value ) {
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	717 $outputTableArray[0][0][$value[2]] = $value[1];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	718 $outputTableArray[0][1][$value[2]] = $value[1]."(Title)";
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	719 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	720 $outputTableArray[0]["other"] = "其他";
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	721 $outputTableArray[0]["page"] = "頁數";
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	722 $outputTableArray[0]["full"] = "全文";
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	723
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	724 // 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	725 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	726 $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	727 $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	728 $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	729 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	730
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	731 $contentLineArray = explode( "<br>", $content );
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	732
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	733 $count=0;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	734 $pageNow=NULL;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	735 foreach ( $contentLineArray as $value ) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	736 $count++;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	737 $recordString = $value;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	738 $otherString = $recordString;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	739 //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	740 // find hyper link in pattern with <a>...</a>
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	741 if ( preg_match("/【<a(.?)>(.?)<\/a>】/u", $recordString, $matches) ) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	742 $pageNow = $matches[2];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	743 }
77 97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	744 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	745 $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	746
960ba96efce1 Update: click to popup remove-tag-window; select to popup tag-window Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 77 diff changeset	747 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	748 foreach ( $matches as $matchesValue ) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	749 $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	750
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	751 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	752 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	753 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	754 $outputTableArray[$count][0][$tag_name] .= ";".$matches2Value[1];
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	755 } 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	756 $outputTableArray[$count][0][$tag_name] = $matches2Value[1];
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	757 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	758 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	759 } 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	760 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	761 $outputTableArray[$count][0][$tag_name] .= ";".$matchesValue[1];
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	762 } 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	763 $outputTableArray[$count][0][$tag_name] = $matchesValue[1];
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	764 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	765 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	766 }
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	767 $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	768 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	769 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	770 $otherString = preg_replace("/○/u", "", $otherString);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	771 $outputTableArray[$count]["other"] = $otherString;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	772 $outputTableArray[$count]["page"] = $pageNow;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	773 $value = preg_replace("/>/u", ">", $value);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	774 $value = preg_replace("/</u", "<", $value);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	775 $outputTableArray[$count]["full"] = $value;
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
77 97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	778
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	779
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	780 foreach ( $outputTableArray as $arrayIndex => $arrayValue ) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	781 // output each row which the topic tag
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	782 // 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	783 if ( !isset($arrayValue[0][$_topic_tag]) ) {
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	784 unset($outputTableArray[$arrayIndex]);
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 }
77 97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	788 // -----
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	789
77 97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	790 return $outputTableArray;
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
97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	793 // === for export table ===
97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	794 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	795 if ($isFromFile) {
97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	796 $content = $this->lg_text;
97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	797 $topic = $this->topic;
84 ecc4b22e9b05 Bug fixed: missing section id variable in export table from LGservice. Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 83 diff changeset	798 $section_id = $this->section_id;
77 97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	799 $sectionName = $this->section_name;
97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	800 $bookId = $this->book_id;
97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	801 $bookName = $this->book_name;
97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	802
97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	803 $taglistArray = $this->taglist_infile;
97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	804
97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	805 } else {
97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	806 $content = $postdata['content'];
97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	807 $topic = $postdata['topic'];
97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	808 $section_id = $postdata['sectionId'];
97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	809 $sectionName = $postdata['sectionName'];
97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	810 $bookId = $postdata['bookId'];
97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	811 $bookName = $postdata['bookName'];
97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	812
97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	813 //$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	814 $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	815 }
97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	816 // =====
97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	817
97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	818 $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	819
97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	820 // 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	821 $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	822
97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	823
97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	824
91 3e11a9c5a672 new: explore table for using on LGMap Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 90 diff changeset	825 $bookMeta = $this->book_meta; // just added
3e11a9c5a672 new: explore table for using on LGMap Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 90 diff changeset	826
77 97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	827 // data for view
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	828 $data = array();
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	829 $data['outputTableArray'] = $outputTableArray;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	830 $data['bookId'] = $bookId;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	831 $data['section_id'] = $section_id;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	832 $data['bookName'] = $bookName;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	833 $data['sectionName'] = $sectionName;
91 3e11a9c5a672 new: explore table for using on LGMap Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 90 diff changeset	834 $data['bookMeta'] = $bookMeta;
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	835
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	836 return $data;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	837
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	838 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	839 // === for manage tag list ===
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	840 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	841 /**
97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	842 */
97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	843
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	844 $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	845 $result = mysql_query($query);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	846 if (!$result) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	847 echo json_encode(mysql_error());
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	848 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	849 $row = mysql_fetch_assoc($result);
51 840cdb52f476 add book_meta into file Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 48 diff changeset	850 $largest_id = $row['AUTO_INCREMENT']-1;
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	851
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	852
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	853 $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	854 $result = $this->GetTaglistByTopicId($topic_id);
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	855
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	856 $taglistArray = array();
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	857
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	858 foreach ($result as $row) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	859 $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	860 //$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	861 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	862
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	863 $topic_tag_name = $this->GetTopicTag($topic_id);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	864
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	865 $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	866 $result = mysql_query($query);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	867 if (!$result) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	868 echo json_encode(mysql_error());
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	869 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	870 $row = mysql_fetch_assoc($result);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	871 $topic_tag_id = $row['id'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	872
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	873 $data = array();
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	874 $data['taglistArray'] = $taglistArray;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	875 $data['topic_id'] = $topic_id;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	876 $data['largest_id'] = $largest_id;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	877 $data['topic_tag_id'] = $topic_tag_id;
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 return $data;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	881
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	882 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	883
67 3ada9334ebfc New: check taglist is deprecated or not Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 66 diff changeset	884 private function GetTag($_postdata) {
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	885 if (get_magic_quotes_gpc()) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	886 $id = stripslashes($_postdata['id']);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	887 $name = stripslashes($_postdata['name']);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	888 $tag = stripslashes($_postdata['tag']);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	889 $color = stripslashes($_postdata['color']);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	890 } else {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	891 $id = $_postdata['id'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	892 $name = $_postdata['name'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	893 $tag = $_postdata['tag'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	894 $color = $_postdata['color'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	895 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	896 return array($id, $name, $tag, $color);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	897 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	898
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	899 public function NewTagElement($postdata) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	900 if ($postdata['id']){
67 3ada9334ebfc New: check taglist is deprecated or not Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 66 diff changeset	901 list($id, $name, $tag, $color) = $this->GetTag($postdata);
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	902
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	903 $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	904 $this->GetSQLValueString($id, "int"),
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	905 $this->GetSQLValueString($name, "text"),
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	906 $this->GetSQLValueString($tag, "text"),
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	907 $this->GetSQLValueString($color, "text"),
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	908 $this->GetSQLValueString($this->systemNAME, "text"));
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	909 $result1 = mysql_query($query1);
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 // add it to topic_tag_relation table
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	913 $topic_id = $postdata['topic_id'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	914
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	915 // tag_id is $id;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	916 $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	917 $result = mysql_query($query);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	918 if (!$result) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	919 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	920 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	921 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	922
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	923 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	924
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	925 public function SaveTagElement($postdata) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	926 if ($postdata['id']){
67 3ada9334ebfc New: check taglist is deprecated or not Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 66 diff changeset	927 list($id, $name, $tag, $color) = $this->GetTag($postdata);
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	928
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	929 $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	930 $this->GetSQLValueString($name, "text"),
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	931 $this->GetSQLValueString($tag, "text"),
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	932 $this->GetSQLValueString($color, "text"),
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	933 $this->GetSQLValueString($id, "int"));
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	934 $result = mysql_query($query);
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 public function DeleteTag($postdata) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	941 if ($postdata['id']) {
94 b0cecc104639 new: modified tags can work on tagged text Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 91 diff changeset	942 $tag_id = $postdata['id'];
b0cecc104639 new: modified tags can work on tagged text Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 91 diff changeset	943
b0cecc104639 new: modified tags can work on tagged text Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 91 diff changeset	944 // delete record in 'taglist' table
b0cecc104639 new: modified tags can work on tagged text Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 91 diff changeset	945 $query = sprintf("DELETE FROM `taglist` WHERE `id` = %s", stripslashes($tag_id));
b0cecc104639 new: modified tags can work on tagged text Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 91 diff changeset	946 $result = mysql_query($query);
b0cecc104639 new: modified tags can work on tagged text Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 91 diff changeset	947
b0cecc104639 new: modified tags can work on tagged text Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 91 diff changeset	948 // delete record in 'topic_tag_relation' table
b0cecc104639 new: modified tags can work on tagged text Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 91 diff changeset	949 $topic_id = $postdata['topic_id'];
b0cecc104639 new: modified tags can work on tagged text Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 91 diff changeset	950 $query = sprintf("DELETE FROM `topic_tag_relation` WHERE `tag_id` = %s and `topic_id` = %s", stripslashes($tag_id), stripcslashes($topic_id));
b0cecc104639 new: modified tags can work on tagged text Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 91 diff changeset	951 $result = mysql_query($query);
b0cecc104639 new: modified tags can work on tagged text Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 91 diff changeset	952
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	953 }
94 b0cecc104639 new: modified tags can work on tagged text Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 91 diff changeset	954
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	955 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	956
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	957 // === for config topic ===
95 9a29e9d28ece new: create new topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 94 diff changeset	958 public function CreateNewTopic($_postdata) {
9a29e9d28ece new: create new topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 94 diff changeset	959 $new_topic_id = "2"; // default topic_id=1 for 'person' topic
9a29e9d28ece new: create new topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 94 diff changeset	960
9a29e9d28ece new: create new topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 94 diff changeset	961 // get user input data from postdata
9a29e9d28ece new: create new topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 94 diff changeset	962 $new_topic_name_en = $_postdata['new_topic_name_en'];
9a29e9d28ece new: create new topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 94 diff changeset	963 $new_topic_name_ch = $_postdata['new_topic_name_ch'];
9a29e9d28ece new: create new topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 94 diff changeset	964 $new_topic_name_pi = $_postdata['new_topic_name_pi'];
9a29e9d28ece new: create new topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 94 diff changeset	965 $new_topic_tag = $_postdata['new_topic_tag'];
9a29e9d28ece new: create new topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 94 diff changeset	966 $new_topic_tag_name = $_postdata['new_topic_tag_name'];
9a29e9d28ece new: create new topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 94 diff changeset	967
9a29e9d28ece new: create new topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 94 diff changeset	968 // -- Start Transaction --
9a29e9d28ece new: create new topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 94 diff changeset	969 mysql_query("BEGIN");
9a29e9d28ece new: create new topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 94 diff changeset	970
9a29e9d28ece new: create new topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 94 diff changeset	971 // create records for the new topic in database
9a29e9d28ece new: create new topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 94 diff changeset	972 /* In table:
9a29e9d28ece new: create new topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 94 diff changeset	973 taglist: name, tag, color (default, user can change later in the editing page)
9a29e9d28ece new: create new topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 94 diff changeset	974 topics: tag, name_en, name_ch, name_pinyin
9a29e9d28ece new: create new topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 94 diff changeset	975 topic_tag_relation: topic_id (new), tag_id (new)
9a29e9d28ece new: create new topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 94 diff changeset	976
9a29e9d28ece new: create new topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 94 diff changeset	977 - need transaction for the following actions:
9a29e9d28ece new: create new topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 94 diff changeset	978 taglist.name: topic_tag name in chinese
9a29e9d28ece new: create new topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 94 diff changeset	979 taglist.tag: topic_tag name in eng
9a29e9d28ece new: create new topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 94 diff changeset	980 topics.tag: (the same a taglist.tag)
9a29e9d28ece new: create new topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 94 diff changeset	981 topics.name_en:
9a29e9d28ece new: create new topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 94 diff changeset	982 topics.name_ch:
9a29e9d28ece new: create new topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 94 diff changeset	983 topics.name_pinyin:
9a29e9d28ece new: create new topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 94 diff changeset	984
9a29e9d28ece new: create new topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 94 diff changeset	985
9a29e9d28ece new: create new topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 94 diff changeset	986 topic_tag_relation.topic_id = new_topic_id
9a29e9d28ece new: create new topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 94 diff changeset	987 topic_tag_relation.tag_id = new_tag_id
9a29e9d28ece new: create new topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 94 diff changeset	988 which are the new record that just been created in the 'taglist' and 'topics' table
9a29e9d28ece new: create new topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 94 diff changeset	989 */
9a29e9d28ece new: create new topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 94 diff changeset	990
9a29e9d28ece new: create new topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 94 diff changeset	991 // new record in topics table
9a29e9d28ece new: create new topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 94 diff changeset	992 $query="INSERT INTO topics (tag, name_en, name_ch, name_pinyin) VALUES ('".$new_topic_tag."','".$new_topic_name_en."','".$new_topic_name_ch."','".$new_topic_name_pi."')";
9a29e9d28ece new: create new topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 94 diff changeset	993 $result_topics=mysql_query($query);
9a29e9d28ece new: create new topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 94 diff changeset	994 if($result_topics){
9a29e9d28ece new: create new topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 94 diff changeset	995 $new_topic_id = mysql_insert_id();
9a29e9d28ece new: create new topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 94 diff changeset	996 } else {
9a29e9d28ece new: create new topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 94 diff changeset	997 //echo mysql_error();
9a29e9d28ece new: create new topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 94 diff changeset	998 }
9a29e9d28ece new: create new topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 94 diff changeset	999
9a29e9d28ece new: create new topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 94 diff changeset	1000 // new record in taglist table
9a29e9d28ece new: create new topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 94 diff changeset	1001 $query="INSERT INTO taglist (name, tag, color, systemName) VALUES ('".$new_topic_tag_name."','".$new_topic_tag."','rgb(255, 0, 174)','interface')";
9a29e9d28ece new: create new topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 94 diff changeset	1002 $result_taglist=mysql_query($query);
9a29e9d28ece new: create new topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 94 diff changeset	1003 if($result_taglist){
9a29e9d28ece new: create new topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 94 diff changeset	1004 $new_tag_id = mysql_insert_id();
9a29e9d28ece new: create new topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 94 diff changeset	1005 } else {
9a29e9d28ece new: create new topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 94 diff changeset	1006 //echo mysql_error();
9a29e9d28ece new: create new topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 94 diff changeset	1007 }
9a29e9d28ece new: create new topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 94 diff changeset	1008
9a29e9d28ece new: create new topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 94 diff changeset	1009 // new record in topic_tag_relation
9a29e9d28ece new: create new topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 94 diff changeset	1010 $query="INSERT INTO topic_tag_relation (topic_id, tag_id) VALUES ('".$new_topic_id."','".$new_tag_id."')";
9a29e9d28ece new: create new topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 94 diff changeset	1011 $result_topic_tag_relation=mysql_query($query);
9a29e9d28ece new: create new topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 94 diff changeset	1012 if($result_topic_tag_relation){
9a29e9d28ece new: create new topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 94 diff changeset	1013
9a29e9d28ece new: create new topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 94 diff changeset	1014 } else {
9a29e9d28ece new: create new topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 94 diff changeset	1015 //echo mysql_error();
9a29e9d28ece new: create new topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 94 diff changeset	1016 }
9a29e9d28ece new: create new topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 94 diff changeset	1017
9a29e9d28ece new: create new topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 94 diff changeset	1018
9a29e9d28ece new: create new topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 94 diff changeset	1019 // --- End Transaction ---
9a29e9d28ece new: create new topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 94 diff changeset	1020 if ($result_taglist && $result_topics && $result_topic_tag_relation) {
9a29e9d28ece new: create new topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 94 diff changeset	1021 mysql_query("COMMIT");
9a29e9d28ece new: create new topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 94 diff changeset	1022
9a29e9d28ece new: create new topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 94 diff changeset	1023 } else {
9a29e9d28ece new: create new topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 94 diff changeset	1024 mysql_query("ROLLBACK");
9a29e9d28ece new: create new topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 94 diff changeset	1025 return "error";
9a29e9d28ece new: create new topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 94 diff changeset	1026 }
9a29e9d28ece new: create new topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 94 diff changeset	1027
9a29e9d28ece new: create new topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 94 diff changeset	1028
9a29e9d28ece new: create new topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 94 diff changeset	1029 $_postdata['topic'] = $new_topic_id;
9a29e9d28ece new: create new topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 94 diff changeset	1030 return $_postdata;
9a29e9d28ece new: create new topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 94 diff changeset	1031 }
9a29e9d28ece new: create new topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 94 diff changeset	1032
9a29e9d28ece new: create new topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 94 diff changeset	1033 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	1034 /**
97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	1035 *
97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	1036 */
97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	1037
95 9a29e9d28ece new: create new topic Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 94 diff changeset	1038 $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	1039 $result = $this->GetTopicById($topic);
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1040 $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	1041 $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	1042 $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	1043 $topic_name_pinyin = $row['name_pinyin'];
47 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 $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	1047 $result = mysql_query($query);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1048 if (!$result) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1049 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	1050 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1051 $taglistArray = array();
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1052 while ($row = mysql_fetch_assoc($result)) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1053 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	1054 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1055 */
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1056
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1057 // ------
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1058 $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	1059 $result = mysql_query($query);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1060 if (!$result) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1061 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	1062 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1063
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1064 $tag_intopic = array();
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1065 $tag_others = array();
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1066 $tag_tmp_others = array();
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1067 while ($row = mysql_fetch_assoc($result)) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1068 if ($row['topic_id'] == $topic) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1069 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	1070 } else {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1071 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	1072 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1073 }
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 // --- 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	1076 $num_others = count($tag_tmp_others);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1077 for ($i=0; $i < $num_others; $i++) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1078 $cnt = 0;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1079 for ($j=$i+1; $j < $num_others; $j++) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1080 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	1081 break;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1082 } else {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1083 $cnt++;
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 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1086 if ($cnt == ($num_others-$i-1) ) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1087 $row = $tag_tmp_others[$i];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1088 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	1089 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1090 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1091
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1092 // --- 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	1093 $tag_tmp_others = $tag_others;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1094 $tag_others = array();
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1095
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1096 foreach ($tag_tmp_others as $tmp) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1097 $cnt = 0;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1098 foreach ($tag_intopic as $intopic) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1099 if ($tmp['tag'] == $intopic['tag']) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1100 break;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1101 } else {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1102 $cnt ++;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1103 }
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 if ($cnt == count($tag_intopic)) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1106 // not appear in $tag_intopic
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1107 array_push($tag_others, $tmp);
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
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1111 // -----
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1112
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1113
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1114 $data = array();
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1115 //$data['taglistArray'] = $taglistArray;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1116 $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	1117 $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	1118
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1119 $data['tag_intopic'] = $tag_intopic;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1120 $data['tag_others'] = $tag_others;
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 return $data;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1123 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1124
94 b0cecc104639 new: modified tags can work on tagged text Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 91 diff changeset	1125
47 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 public function UpdateTagsInTopic($_postdata) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1128 $topic_id = $_postdata['topic_id'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1129 $tag_ids = json_decode(str_replace('\\', '', $_postdata['ids']));
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1130
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1131 // 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	1132 // --- add new topic_tag_relation ---
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1133 foreach ($tag_ids as $tag_id) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1134 $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	1135 $result = mysql_query($query);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1136 if (!$result) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1137 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	1138 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1139 $topic_tag = array();
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1140 $flag = false;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1141 while ($row = mysql_fetch_assoc($result)) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1142 if ($row['topic_id'] == $topic_id) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1143 $flag = true;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1144 break;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1145 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1146 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1147 if (!$flag) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1148 // insert a row into topic_tag_relation table
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1149 $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	1150 $resultUpdate = mysql_query($queryUpdate);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1151 if (!$resultUpdate) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1152 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	1153 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1154 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1155
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1156 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1157
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1158 // --- remove tags from this topic ---
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1159 $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	1160 $result = mysql_query($query);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1161 if (!$result) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1162 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	1163 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1164
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1165 while ($row = mysql_fetch_assoc($result)) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1166 $cnt = 0;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1167 foreach ($tag_ids as $tag_id) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1168 if ($row['tag_id'] == $tag_id) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1169 break;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1170 } else {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1171 $cnt ++;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1172 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1173 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1174 $_id = $row['id'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1175 if ($cnt == count($tag_ids)) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1176 // delete row with (topic_id, tag_ids)
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1177 $queryDelete = "DELETE FROM topic_tag_relation WHERE id=".$_id;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1178 $resultDelete = mysql_query($queryDelete);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1179 if (!$resultDelete) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1180 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	1181 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1182 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1183 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1184
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1185
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 /*
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1188 $query = "SELECT * FROM topic_tag_relation";
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1189 $result = mysql_query($query);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1190 if (!$result) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1191 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	1192 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1193 $topic_tag = array();
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1194 while ($row = mysql_fetch_assoc($result)) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1195 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	1196 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1197
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1198
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1199 foreach ($topic_tag as $value) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1200 $flag = false;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1201 foreach ($tag_ids as $tag_id) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1202 if ($value['tag_id'] == $tag_id) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1203 //update its topic_id to $topic_id
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1204 $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	1205 $resultUpdate = mysql_query($queryUpdate);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1206 if (!$resultUpdate) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1207 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	1208 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1209 $flag = true;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1210 break;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1211 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1212 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1213 if (!$flag && $value['topic_id'] == $topic_id) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1214 // set its topic_id to 0, indicating unsigned
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1215 $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	1216 $resultUpdate = mysql_query($queryUpdate);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1217 if (!$resultUpdate) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1218 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	1219 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1220 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1221 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1222 */
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1223
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1224 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1225
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1226
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	1227 private function GetTaglistByTopicId($topic_id) {
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1228 $taglistArray = array();
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1229 // select taglist ids from topic_tag_relation table
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1230 $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	1231 $result = mysql_query($query);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1232 if (!$result) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1233 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	1234 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1235 $taglist_ids = array();
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1236
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1237 while ($row = mysql_fetch_assoc($result)) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1238 array_push($taglist_ids, $row['tag_id']);
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
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1241 // select taglist by tag ids
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1242 foreach ($taglist_ids as $tag_id) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1243 $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	1244 $result = mysql_query($query);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1245 if (!$result) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1246 echo mysql_error();
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1247 return json_encode("Failed during selecting taglist table.");
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1248 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1249
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1250 $row = mysql_fetch_assoc($result);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1251 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	1252
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1253 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1254 return $taglistArray;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1255 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1256
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1257 public function SetTopic($topic) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1258 $this->topic = $topic;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1259 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1260
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	1261 private function GetTopic() {
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1262 return $this->topic;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1263 }
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 private function GetTopiclistArray() {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1266 $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	1267 $result = $this->GetTopicList();
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1268 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	1269 //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	1270 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	1271 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1272 return $topiclistArray;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1273 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1274
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1275
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1276 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	1277 $result = $this->GetTopicById($topic_id);
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1278 $row = mysql_fetch_assoc($result);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1279 $tag = $row['tag'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1280 return $tag;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1281 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1282 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	1283 $result = $this->GetTopicById($topic_id);
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1284 $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	1285 //$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	1286 $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	1287 return $name;
86 0141df465205 New: add chinese characters to pinyin Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 84 diff changeset	1288 }
0141df465205 New: add chinese characters to pinyin Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 84 diff changeset	1289 private function GetTopicTagName($topic_id) {
0141df465205 New: add chinese characters to pinyin Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 84 diff changeset	1290 $topic_tag = $this->GetTopicTag($topic_id);
0141df465205 New: add chinese characters to pinyin Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 84 diff changeset	1291 $query = "SELECT * FROM `taglist` WHERE tag='".$topic_tag."'";
0141df465205 New: add chinese characters to pinyin Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 84 diff changeset	1292 $result = mysql_query($query);
0141df465205 New: add chinese characters to pinyin Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 84 diff changeset	1293 $row = mysql_fetch_assoc($result);
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1294
86 0141df465205 New: add chinese characters to pinyin Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 84 diff changeset	1295 return $row['name'];
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1296 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1297
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1298
86 0141df465205 New: add chinese characters to pinyin Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 84 diff changeset	1299
0141df465205 New: add chinese characters to pinyin Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 84 diff changeset	1300
47 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
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1303 // === for manage wordlist ===
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1304 public function EditWordlist() {
77 97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	1305 /**
97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	1306 * 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	1307 * 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	1308 */
97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	1309
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1310 $result = $this->GetWordlist();
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1311 $wordlistArray = array();
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1312 while ($row = mysql_fetch_assoc($result)) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1313 $wordlistArray[$row['id']] = $row['name'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1314 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1315
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1316 $data = array();
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1317 $data['wordlistArray'] = $wordlistArray;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1318 return $data;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1319 }
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 public function AddNewList($postdata) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1323 if ($postdata['text']){
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1324 if (get_magic_quotes_gpc()) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1325 $name = stripslashes($postdata['text']);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1326 } else {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1327 $name = $postdata['text'];
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
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1330 $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	1331 $this->GetSQLValueString($name, "text"),
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1332 $this->GetSQLValueString($this->systemNAME, "text"));
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1333 $result1 = mysql_query($query1);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1334 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	1335 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1336 }
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 public function SaveWordlist($postdata) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1340
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1341 if ($postdata['text']){
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1342 $date = date('Y_m_d_H_i_s', time());
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1343 if ( file_exists("data/wordlist/".$postdata['filename'].".txt") ) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1344 $filename = "data/wordlist/".$postdata['filename']."_".$date.".txt";
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1345 $oldFile = file_get_contents("data/wordlist/".$postdata['filename'].".txt");
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1346 file_put_contents($filename, $oldFile);
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 /*else {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1349 $filename = "data/wordlist/".$postdata['filename'].".txt";
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1350 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1351 */
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1352
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1353
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1354 if (get_magic_quotes_gpc()) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1355 $require = stripslashes($postdata['text']);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1356 } else {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1357 $require = $postdata['text'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1358 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1359
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1360 $require = preg_replace("/<br>/u", "<br>", $require);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1361 file_put_contents("data/wordlist/".$postdata['filename'].".txt", $require);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1362 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1363 /*
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1364 if ($postdata['text']){
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1365 $date = date('Y_m_d_H_i_s', time());
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1366 if ( file_exists("data/wordlist/".$postdata['filename'].".txt") ) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1367 $oldFile = file_get_contents("data/wordlist/".$postdata['filename'].".txt");
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1368 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	1369 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1370
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1371 if (get_magic_quotes_gpc()) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1372 $require = stripslashes($postdata['text']);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1373 } else {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1374 $require = $postdata['text'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1375 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1376
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1377 // $require = preg_replace("/<br>/u", "", $require);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1378 file_put_contents("data/wordlist/".$postdata['filename'].".txt", $require);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1379 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1380 */
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1381 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1382
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1383
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1384 // =======================================
79 e6e213b26454 Bug fixed: file crashed after saving (preg_replace remove unnecessary symbols within br tag Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 78 diff changeset	1385
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	1386 private function sortFunction($a,$b) {
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1387 return strlen($b)-strlen($a);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1388 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1389
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1390 private function GetSectionId() {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1391
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1392 if (is_numeric($this->section_id)) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1393 return $this->section_id;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1394 } else {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1395 return json_encode("Error: No section id");
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1396 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1397 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1398
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1399 private function GetSectionInfo() {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1400 $section_id = $this->GetSectionId();
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1401 if (!is_numeric($section_id)){
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1402 return $section_id;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1403 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1404
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	1405 $result = $this->GetSectionsById($section_id);
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1406
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1407
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1408 while ($row = mysql_fetch_assoc($result)) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1409 $bookId=$row['books_id'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1410 $startPage=$row['start_page'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1411 $endPage=$row['end_page'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1412 $sectionName = $row['name'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1413 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1414
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1415 $data = array();
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1416 $data['bookId'] = $bookId;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1417 $data['startPage'] = $startPage;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1418 $data['endPage'] = $endPage;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1419 $data['sectionName'] = $sectionName;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1420
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1421
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1422 return $data;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1423 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1424
74 60b5a94163c3 New: retrieve book meta data from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 73 diff changeset	1425 private function ParseDataInFile($filename) {
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1426 $text = file_get_contents($filename);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1427 $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	1428 if (!$xml) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1429 // 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	1430 return $text;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1431 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1432
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1433 $this->topic = (string)$xml->topic; // set topic id
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1434
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1435 // get taglist in file
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1436 $taglist_infile = $xml->tagitem;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1437 $taglistArray = array();
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1438 foreach ($taglist_infile as $row) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1439 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	1440 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1441 if ($taglistArray) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1442 $this->taglist_infile = $taglistArray;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1443 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1444
74 60b5a94163c3 New: retrieve book meta data from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 73 diff changeset	1445 // --- 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	1446 /*
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1447 $book_meta = $xml->book;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1448 $book_metaArray = array();
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1449 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	1450 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	1451 (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	1452 (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	1453 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1454 if ($book_metaArray) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1455 $this->book_meta = $book_metaArray;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1456 }
74 60b5a94163c3 New: retrieve book meta data from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 73 diff changeset	1457 */
60b5a94163c3 New: retrieve book meta data from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 73 diff changeset	1458 // -----
94 b0cecc104639 new: modified tags can work on tagged text Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 91 diff changeset	1459 // get section_id, section_name from file
77 97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	1460 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	1461 if ($xml->section) {
97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	1462 $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	1463 $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	1464 }
97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	1465 }
97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	1466 // book meta data
97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	1467 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	1468 $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	1469 $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	1470 }
97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	1471
97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	1472
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	1473
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	1474 $contentString = (string)($xml->text_content->asXML());
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1475
76 c49192885290 Bug fixed: ambiguous tag occured at Editing-text mode Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 75 diff changeset	1476 $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	1477 $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	1478
94 b0cecc104639 new: modified tags can work on tagged text Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 91 diff changeset	1479
76 c49192885290 Bug fixed: ambiguous tag occured at Editing-text mode Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 75 diff changeset	1480 return $new_contentString;
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1481 }
74 60b5a94163c3 New: retrieve book meta data from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 73 diff changeset	1482
60b5a94163c3 New: retrieve book meta data from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 73 diff changeset	1483
77 97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	1484 private function GetSectionContent() {
81 f1f849d31272 book_id as string Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 79 diff changeset	1485 /** This is only been called by SetTextFromLocal().
77 97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	1486 */
97c1e5102a22 New: export table for a file from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 76 diff changeset	1487
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1488 $section_id = $this->GetSectionId();
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1489 $section_info = $this->GetSectionInfo();
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1490
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1491 $bookId = $section_info['bookId'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1492 $startPage = $section_info['startPage'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1493 $endPage = $section_info['endPage'];
86 0141df465205 New: add chinese characters to pinyin Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 84 diff changeset	1494 $this->section_name = $section_info['sectionName'];
0141df465205 New: add chinese characters to pinyin Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 84 diff changeset	1495
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1496
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1497 $contentString="";
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1498 $data_path = $this->GetDataPath();
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1499 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	1500 $filename = $data_path."parsing_files/".$section_id.".txt";
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1501
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1502 // --- parsing meta data
74 60b5a94163c3 New: retrieve book meta data from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 73 diff changeset	1503 $stringInput = $this->ParseDataInFile($filename);
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1504 // ----
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1505
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1506 // if the text is from file system
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1507 $stringInput = preg_replace("/ /u", "○", $stringInput);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1508 $stringInput = preg_replace("/\n/u", "<br>", $stringInput);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1509 $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	1510
3395385476d1 bug fixed: popup tag window is closed automatically when saving text file Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 62 diff changeset	1511 $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	1512
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1513 } else {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1514 $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	1515 $result = mysql_query($query);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1516 if (!$result) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1517 return json_encode("Failed during selecting content table.");
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1518 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1519 while ($row = mysql_fetch_assoc($result)) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1520 $contentString.="【".$row['line']."】".$row['content']."\n";
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1521 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1522
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1523 // the text is from database
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1524 $stringInput = $contentString;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1525 $stringInput = preg_replace("/<(.*?)>/u", "○", $stringInput);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1526 $stringInput = preg_replace("/ /u", "○", $stringInput);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1527 $stringInput = preg_replace("/\n/u", "<br>", $stringInput);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1528 $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	1529 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1530
69 edb8a2e8ce84 New: save book meta_data in file Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 67 diff changeset	1531 /*
74 60b5a94163c3 New: retrieve book meta data from LGService Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 73 diff changeset	1532 // 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	1533 $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	1534 $books_result = $this->GetBooksById($bookId);
51 840cdb52f476 add book_meta into file Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 48 diff changeset	1535 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	1536 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	1537 // 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	1538 }
69 edb8a2e8ce84 New: save book meta_data in file Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 67 diff changeset	1539 $this->book_meta = $book_meta;
edb8a2e8ce84 New: save book meta_data in file Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 67 diff changeset	1540 */
51 840cdb52f476 add book_meta into file Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 48 diff changeset	1541
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1542 return $stringInput;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1543 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1544
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1545 private function GetDataPath() {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1546 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	1547 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1548
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1549 private function GetTaglistArray() {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1550 $taglistArray = array();
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1551 $result = $this->GetTaglist();
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1552 while ($row = mysql_fetch_assoc($result)) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1553 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	1554 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1555
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1556 return $taglistArray;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1557 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1558
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1559 private function GetWordlistArray() {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1560 $wordlistArray="";
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1561 $result = $this->GetWordlist();
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1562 while ($row = mysql_fetch_assoc($result)) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1563 $listString = file_get_contents("data/wordlist/".$row['id'].".txt");
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1564 $listString = preg_replace("/<div>/u", "\n", $listString);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1565 $listString = preg_replace("/<\/div>/u", "", $listString);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1566 $listString = preg_replace("/<span(.*?)>/u", "", $listString);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1567 $listString = preg_replace("/<\/span>/u", "", $listString);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1568 //$listString = preg_replace("/\n/u", "\|", $listString);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1569
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1570 $wordlistArray2 = explode( "\n", $listString );
71 26d8c4c43d86 minor checking for variable/index in php Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: 70 diff changeset	1571 //usort($wordlistArray2,'sortFunction');
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1572 foreach ( $wordlistArray2 as $index=>$value ) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1573 $wordlistArray2[$index] = implode("○?", preg_split("/(?<!^)(?!$)/u", $value));
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1574 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1575 foreach ( $wordlistArray2 as $index=>$value ) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1576 if ($value=="") unset($wordlistArray2[$index]);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1577
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1578 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1579 $listString = implode("\|", $wordlistArray2);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1580
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1581 if ( $listString[0]=="\|" ) $listString = substr($listString, 1);
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1582 $wordlistArray[] = array( $row['id'], $row['name'], $listString );
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1583 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1584
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1585
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1586 return $wordlistArray;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1587
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1588 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1589
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	1590 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	1591 $result = $this->GetSectionsById($bookId);
47 886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1592 while ($row = mysql_fetch_assoc($result)) {
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1593 $bookName = $row['name'];
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1594 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1595
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1596 $data = array();
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1597 $data['bookName'] = $bookName;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1598
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1599 return $data;
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1600 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1601
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1602
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1603 }
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1604
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1605
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1606
886f43b26ee2 move/remove develop folder Zoe Hong <zhong@mpiwg-berlin.mpg.de> parents: diff changeset	1607 ?>

Mercurial > hg > extraction-interface

annotate models/extractapp.php @ 95:9a29e9d28ece extractapp