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