Mercurial > hg > extraction-interface
annotate models/extractapp.php @ 108:025530e37dcd extractapp
for ssl protocol
| author | Calvin Yeh <cyeh@mpipw-berlin.mpg.com> |
|---|---|
| date | Tue, 21 Mar 2017 18:23:05 +0100 |
| parents | e542b161d907 |
| children | 7bdbc7fc7936 |
| 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 */ | |
|
77
97c1e5102a22
New: export table for a file from LGService
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
76
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, | |
| 23 * and produces the output/data to the corresponding view in "views/Extractapp/". | |
| 24 * | |
|
77
97c1e5102a22
New: export table for a file from LGService
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
76
diff
changeset
|
25 */ |
|
47
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
26 |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
27 class ExtractappModel extends BaseModel{ |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
28 |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
29 protected $section_id = 0, $data_path, $file_id = 0, $current_fileId=0, |
|
87
fb5049fc5dd7
New:(1)UI(2)generate simple regex by examples(3)coordinates in book metadata
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
86
diff
changeset
|
30 $branch_id = 0, $user_id = 0, $lg_text = "", $topic, $taglist_infile = "", |
|
fb5049fc5dd7
New:(1)UI(2)generate simple regex by examples(3)coordinates in book metadata
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
86
diff
changeset
|
31 $book_meta = "", $book_dynasty = ""; |
|
fb5049fc5dd7
New:(1)UI(2)generate simple regex by examples(3)coordinates in book metadata
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
86
diff
changeset
|
32 |
|
58
a11f9103b8db
New: 1.display messages 2.handle saving conflict:up-to-date or reload text
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
57
diff
changeset
|
33 public $messages = array('info'=>"",'error'=>"",'warning'=>"",'debug'=>""); |
|
47
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
34 |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
35 |
| 81 | 36 public function SetTextFromFileId() { // remove $_postdata as input |
| 37 /** | |
| 38 * Get text content from LGService by $this->file_id. | |
| 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']; |
|
86
0141df465205
New: add chinese characters to pinyin
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
84
diff
changeset
|
81 |
|
0141df465205
New: add chinese characters to pinyin
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
84
diff
changeset
|
82 $this->book_name = $b['name']; |
|
0141df465205
New: add chinese characters to pinyin
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
84
diff
changeset
|
83 $this->book_id = $b['id']; |
|
0141df465205
New: add chinese characters to pinyin
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
84
diff
changeset
|
84 /* |
|
63
3395385476d1
bug fixed: popup tag window is closed automatically when saving text file
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
62
diff
changeset
|
85 $book_meta = array(); |
|
69
edb8a2e8ce84
New: save book meta_data in file
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
67
diff
changeset
|
86 array_push($book_meta, array($b['id'],$b['name'],$b['level1'],$b['level2'], |
|
edb8a2e8ce84
New: save book meta_data in file
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
67
diff
changeset
|
87 $b['period'],$b['dynasty'], $b['start_year'], $b['end_year'],$b['line'], |
|
edb8a2e8ce84
New: save book meta_data in file
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
67
diff
changeset
|
88 $b['volume'],$b['author'], $b['edition'],$b['in_jibengujiku'], $b['admin_type'])); // missing author,year,pagenumber |
|
86
0141df465205
New: add chinese characters to pinyin
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
84
diff
changeset
|
89 */ |
|
0141df465205
New: add chinese characters to pinyin
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
84
diff
changeset
|
90 /* |
|
0141df465205
New: add chinese characters to pinyin
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
84
diff
changeset
|
91 $book_meta = array('id'=>$b['id'],'name'=>$b['name'],'level1'=>$b['level1'],'level2'=>$b['level2'], |
|
0141df465205
New: add chinese characters to pinyin
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
84
diff
changeset
|
92 'period'=>$b['period'],'dynasty'=>$b['dynasty'],'start_year'=>$b['start_year'], 'end_year'=>$b['end_year'],'line'=>$b['line'], |
|
0141df465205
New: add chinese characters to pinyin
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
84
diff
changeset
|
93 'volume'=>$b['volume'],'author'=>$b['author'],'edition'=>$b['edition'], |
|
0141df465205
New: add chinese characters to pinyin
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
84
diff
changeset
|
94 'in_jibengujiku'=>$b['in_jibengujiku'],'admin_type'=>$b['admin_type']); // missing author,year,pagenumber |
|
0141df465205
New: add chinese characters to pinyin
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
84
diff
changeset
|
95 */ |
|
0141df465205
New: add chinese characters to pinyin
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
84
diff
changeset
|
96 |
|
0141df465205
New: add chinese characters to pinyin
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
84
diff
changeset
|
97 $book_meta->id = $b['id']; |
|
0141df465205
New: add chinese characters to pinyin
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
84
diff
changeset
|
98 $book_meta->name = $b['name']; |
|
0141df465205
New: add chinese characters to pinyin
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
84
diff
changeset
|
99 $book_meta->level1 = $b['level1']; |
|
0141df465205
New: add chinese characters to pinyin
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
84
diff
changeset
|
100 $book_meta->level2 = $b['level2']; |
|
0141df465205
New: add chinese characters to pinyin
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
84
diff
changeset
|
101 $book_meta->period = $b['period']; |
|
0141df465205
New: add chinese characters to pinyin
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
84
diff
changeset
|
102 $book_meta->dynasty = $b['dynasty']; |
|
0141df465205
New: add chinese characters to pinyin
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
84
diff
changeset
|
103 $book_meta->start_year = $b['start_year']; |
|
0141df465205
New: add chinese characters to pinyin
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
84
diff
changeset
|
104 $book_meta->end_year = $b['end_year']; |
|
0141df465205
New: add chinese characters to pinyin
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
84
diff
changeset
|
105 $book_meta->line = $b['line']; |
|
0141df465205
New: add chinese characters to pinyin
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
84
diff
changeset
|
106 $book_meta->volume = $b['volume']; |
|
0141df465205
New: add chinese characters to pinyin
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
84
diff
changeset
|
107 $book_meta->author = $b['author']; |
|
0141df465205
New: add chinese characters to pinyin
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
84
diff
changeset
|
108 $book_meta->edition = $b['edition']; |
|
0141df465205
New: add chinese characters to pinyin
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
84
diff
changeset
|
109 $book_meta->in_jibengujiku = $b['in_jibengujiku']; |
|
0141df465205
New: add chinese characters to pinyin
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
84
diff
changeset
|
110 $book_meta->admin_type = $b['admin_type']; |
|
0141df465205
New: add chinese characters to pinyin
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
84
diff
changeset
|
111 |
|
87
fb5049fc5dd7
New:(1)UI(2)generate simple regex by examples(3)coordinates in book metadata
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
86
diff
changeset
|
112 $coordinates = $section_meta['section']['coordinates_books']; |
|
fb5049fc5dd7
New:(1)UI(2)generate simple regex by examples(3)coordinates in book metadata
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
86
diff
changeset
|
113 $book_meta->x = $coordinates['x']; |
|
fb5049fc5dd7
New:(1)UI(2)generate simple regex by examples(3)coordinates in book metadata
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
86
diff
changeset
|
114 $book_meta->y = $coordinates['y']; |
|
fb5049fc5dd7
New:(1)UI(2)generate simple regex by examples(3)coordinates in book metadata
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
86
diff
changeset
|
115 $book_meta->place_name = $coordinates['place_name']; |
|
fb5049fc5dd7
New:(1)UI(2)generate simple regex by examples(3)coordinates in book metadata
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
86
diff
changeset
|
116 |
|
fb5049fc5dd7
New:(1)UI(2)generate simple regex by examples(3)coordinates in book metadata
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
86
diff
changeset
|
117 |
|
86
0141df465205
New: add chinese characters to pinyin
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
84
diff
changeset
|
118 |
|
63
3395385476d1
bug fixed: popup tag window is closed automatically when saving text file
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
62
diff
changeset
|
119 $this->book_meta = $book_meta; |
|
3395385476d1
bug fixed: popup tag window is closed automatically when saving text file
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
62
diff
changeset
|
120 |
|
3395385476d1
bug fixed: popup tag window is closed automatically when saving text file
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
62
diff
changeset
|
121 } |
|
3395385476d1
bug fixed: popup tag window is closed automatically when saving text file
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
62
diff
changeset
|
122 |
| 81 | 123 public function SetTextFromSectionId() { // remove $_postdata as input |
| 124 /** | |
| 125 * Get text content from LGService by $this->section_id. | |
| 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 |
| 81 | 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. | |
| 168 * The previous page could be: | |
| 169 * | |
| 170 * (1) LGService: the first time user enters Extraction-interface, which should linked from LGService. | |
| 171 * | |
| 172 * (2) Extraction-interface itself: changing topic then continue to tag, saving text to LGService, reload the text from LGService. | |
| 173 * | |
| 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 } |
|
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
|
194 |
|
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; |
|
3ada9334ebfc
New: check taglist is deprecated or not
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
66
diff
changeset
|
231 for ($i=0; $i < $num_field; $i++) { |
|
3ada9334ebfc
New: check taglist is deprecated or not
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
66
diff
changeset
|
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) { |
|
3ada9334ebfc
New: check taglist is deprecated or not
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
66
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; |
|
67
3ada9334ebfc
New: check taglist is deprecated or not
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
66
diff
changeset
|
251 |
|
47
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
252 } |
|
86
0141df465205
New: add chinese characters to pinyin
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
84
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; |
|
b0cecc104639
new: modified tags can work on tagged text
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
91
diff
changeset
|
264 |
|
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 } |
|
b0cecc104639
new: modified tags can work on tagged text
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
91
diff
changeset
|
277 |
|
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 */ | |
|
47
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
312 |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
313 $section_id = $this->section_id; |
|
94
b0cecc104639
new: modified tags can work on tagged text
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
91
diff
changeset
|
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 |
|
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
|
317 //for GetTaglistByTopicId: |
|
960ba96efce1
Update: click to popup remove-tag-window; select to popup tag-window
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
77
diff
changeset
|
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 = ""; |
|
94
b0cecc104639
new: modified tags can work on tagged text
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
91
diff
changeset
|
324 |
|
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 |
|
47
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
336 |
|
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, |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
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, |
|
91
3e11a9c5a672
new: explore table for using on LGMap
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
90
diff
changeset
|
361 'current_fileId'=>$this->current_fileId); |
|
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; |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
383 |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
384 } |
|
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 } |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
394 |
|
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 } |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
400 |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
401 $require = preg_replace("/【<a(.*?)>(.*?)<\/a>】/u", "【\\2】", $require); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
402 $require = preg_replace('/&/u', "&", $require); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
403 $require = preg_replace("/○/u", " ", $require); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
404 $require = preg_replace("/<br>/u", "\n", $require); |
|
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 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
|
407 } |
|
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 |
|
104
e542b161d907
bug fixed: for only lowercase accepted in html tag.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
102
diff
changeset
|
411 |
|
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
|
412 public function UpdateInfoResponsedFromLGService($response) { |
| 81 | 413 /** |
|
86
0141df465205
New: add chinese characters to pinyin
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
84
diff
changeset
|
414 * |
| 81 | 415 */ |
| 416 | |
| 73 | 417 if (isset($response["file"])) { |
| 418 $response_file = $response["file"]; | |
| 419 } | |
| 420 if (isset($response["branch"])) { | |
| 421 $response_branch = $response["branch"]; | |
| 422 } | |
|
47
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
423 |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
424 $status = (string)$response["status"]; |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
425 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
|
426 $this->messages['info'] .= "[Info] Saving success. <br>"; |
|
47
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
427 $this->file_id = (string)$response_file["id"]; |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
428 $this->branch_id = (string)$response_branch["id"]; |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
429 |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
430 } else if ($status == "error") { |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
431 // 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
|
432 $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
|
433 $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
|
434 |
|
104
e542b161d907
bug fixed: for only lowercase accepted in html tag.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
102
diff
changeset
|
435 // 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
|
436 // 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
|
437 |
|
47
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
438 $response_currentFile = $response["currentFile"]; |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
439 $this->current_fileId = (string)$response_currentFile["id"]; |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
440 } |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
441 |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
442 |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
443 } |
|
57
5cf9720a2e25
New: add reloadText to load the latest version
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
56
diff
changeset
|
444 |
|
5cf9720a2e25
New: add reloadText to load the latest version
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
56
diff
changeset
|
445 public function ReloadSetting() { |
|
5cf9720a2e25
New: add reloadText to load the latest version
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
56
diff
changeset
|
446 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
|
447 $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
|
448 $this->current_fileId = 0; |
|
5cf9720a2e25
New: add reloadText to load the latest version
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
56
diff
changeset
|
449 } |
|
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 |
|
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
|
452 // 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
|
453 private function AppendMetadata($text_content) { |
|
47
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
454 $text = '<?xml version="1.0" encoding="UTF-8"?>'; |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
455 $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
|
456 // --- topic --- |
|
47
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
457 $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
|
458 // --- book meta data --- |
|
47
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
459 $book = $this->book_meta; |
|
86
0141df465205
New: add chinese characters to pinyin
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
84
diff
changeset
|
460 |
|
0141df465205
New: add chinese characters to pinyin
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
84
diff
changeset
|
461 $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
|
462 $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
|
463 $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
|
464 $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
|
465 $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
|
466 $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
|
467 $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
|
468 $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
|
469 $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
|
470 $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
|
471 $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
|
472 $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
|
473 $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
|
474 $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
|
475 $text .= "<admin_type>".$book->admin_type."</admin_type>\n"; |
|
fb5049fc5dd7
New:(1)UI(2)generate simple regex by examples(3)coordinates in book metadata
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
86
diff
changeset
|
476 |
|
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
|
477 $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
|
478 $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
|
479 $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
|
480 $text .= "</book>\n"; |
|
0141df465205
New: add chinese characters to pinyin
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
84
diff
changeset
|
481 |
|
0141df465205
New: add chinese characters to pinyin
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
84
diff
changeset
|
482 |
|
77
97c1e5102a22
New: export table for a file from LGService
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
76
diff
changeset
|
483 // --- section info --- |
|
97c1e5102a22
New: export table for a file from LGService
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
76
diff
changeset
|
484 $text .= "<section>\n"; |
|
97c1e5102a22
New: export table for a file from LGService
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
76
diff
changeset
|
485 $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
|
486 $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
|
487 $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
|
488 |
|
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 // ---- 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
|
490 // $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
|
491 // 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
|
492 // 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
|
493 // 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
|
494 // 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
|
495 |
|
78
960ba96efce1
Update: click to popup remove-tag-window; select to popup tag-window
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
77
diff
changeset
|
496 $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
|
497 |
|
47
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
498 foreach ($taglist as $tagitem) { |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
499 $text .= "<tagitem>\n"; |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
500 $text .= "<id>".$tagitem[0]."</id>\n"; |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
501 $text .= "<name>".$tagitem[1]."</name>\n"; |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
502 $text .= "<tag>".$tagitem[2]."</tag>\n"; |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
503 $text .= "<color>".$tagitem[3]."</color>\n"; |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
504 $text .= "</tagitem>\n"; |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
505 } |
|
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
|
506 // ---- |
|
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 // --- text_content --- |
|
47
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
508 $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
|
509 $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
|
510 // ---- |
|
47
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
511 |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
512 return $text; |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
513 } |
|
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
|
514 |
|
47
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
515 public function SaveFullTextToLGService($_postdata) { |
| 81 | 516 /** |
| 517 * It saves the full tagged text string in postdata to LGService. | |
| 518 * The responses returned by LGService will later be handled in | |
| 519 */ | |
| 520 | |
|
47
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
521 // -------- |
|
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
|
522 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
|
523 |
|
47
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
524 if ($_postdata['text']){ |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
525 $date = date('Y_m_d_H_i_s', time()); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
526 if ( file_exists("data/parsing_files/".$_postdata['sectionId'].".txt") ) { |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
527 $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
|
528 //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
|
529 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
|
530 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
|
531 } |
|
47
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
532 } |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
533 |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
534 if (get_magic_quotes_gpc()) { |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
535 $require = stripslashes($_postdata['text']); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
536 } else { |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
537 $require = $_postdata['text']; |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
538 } |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
539 |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
540 $require = preg_replace("/【<a(.*?)>(.*?)<\/a>】/u", "【\\2】", $require); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
541 $require = preg_replace('/&/u', "&", $require); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
542 $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
|
543 $require = preg_replace("/<br(.*?)>/u", "\n", $require); |
|
47
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
544 //$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
|
545 |
|
76
c49192885290
Bug fixed: ambiguous tag occured at Editing-text mode
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
75
diff
changeset
|
546 $require = "<text_content>".$require."</text_content>\n"; |
|
c49192885290
Bug fixed: ambiguous tag occured at Editing-text mode
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
75
diff
changeset
|
547 |
|
c49192885290
Bug fixed: ambiguous tag occured at Editing-text mode
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
75
diff
changeset
|
548 /* |
|
47
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
549 if ($_postdata['branchId'] == 0) { |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
550 // -- 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
|
551 $require = "<text_content>".$require."</text_content>\n"; |
|
47
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
552 } |
|
76
c49192885290
Bug fixed: ambiguous tag occured at Editing-text mode
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
75
diff
changeset
|
553 */ |
|
c49192885290
Bug fixed: ambiguous tag occured at Editing-text mode
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
75
diff
changeset
|
554 |
|
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
|
555 $require = $this->AppendMetadata($require); |
|
47
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
556 |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
557 //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
|
558 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
|
559 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
|
560 } |
|
47
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
561 } |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
562 |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
563 // ------ |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
564 |
|
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 if ($_postdata['branchId'] != 0) { |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
567 // -- exiting branch case |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
568 $postfields = array( |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
569 "text" => $require, |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
570 "branchId" => $_postdata['branchId'], |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
571 "userId" => $_postdata['userId'], |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
572 "userPreviousFileId" => $_postdata['fileId'], |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
573 ); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
574 $save_url = $this->save_to_LGService_url; |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
575 |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
576 } else { |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
577 // -- 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
|
578 // echo "saveNew!"; |
|
47
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
579 $user_id = "0"; |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
580 if ($_postdata['userId']) { |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
581 $user_id = $_postdata['userId']; |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
582 } |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
583 |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
584 $postfields = array( |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
585 "text" => $require, |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
586 "sectionId" => $_postdata['sectionId'], |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
587 "userId" => $user_id, |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
588 "label" => $_postdata['label'], |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
589 ); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
590 $save_url = $this->save_new_to_LGService_url; |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
591 } |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
592 |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
593 |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
594 // set up the curl resource |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
595 $ch = curl_init(); |
| 108 | 596 curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false); |
|
47
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
597 curl_setopt($ch, CURLOPT_URL, $save_url); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
598 curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
599 curl_setopt($ch, CURLOPT_CUSTOMREQUEST, "POST"); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
600 curl_setopt($ch, CURLOPT_POST, true); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
601 curl_setopt($ch, CURLOPT_POSTFIELDS, $postfields); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
602 //curl_setopt($ch, CURLOPT_HEADER, true); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
603 curl_setopt($ch, CURLOPT_HTTPHEADER, array( |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
604 'Content-type: multipart/form-data;charset=utf-8' |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
605 )); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
606 |
|
90
94ad33739fa4
modify the position of buttons in sidebar
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
89
diff
changeset
|
607 //if (!$AT_LOCAL) { |
|
94ad33739fa4
modify the position of buttons in sidebar
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
89
diff
changeset
|
608 // execute the request |
|
94ad33739fa4
modify the position of buttons in sidebar
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
89
diff
changeset
|
609 $output = curl_exec($ch); |
|
94ad33739fa4
modify the position of buttons in sidebar
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
89
diff
changeset
|
610 //} |
|
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
|
611 |
|
47
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
612 |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
613 // output the profile information - includes the header |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
614 //echo($output) . PHP_EOL; |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
615 |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
616 // close curl resource to free up system resources |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
617 curl_close($ch); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
618 |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
619 $response = json_decode($output, true); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
620 return $response; |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
621 |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
622 } |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
623 |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
624 // --- 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
|
625 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
|
626 $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
|
627 $result = mysql_query($query); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
628 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
|
629 return json_encode("Failed during selecting TopicRegexRelation table."); |
|
47
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
630 } |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
631 |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
632 $filenames = array(); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
633 while ($row = mysql_fetch_assoc($result)) { |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
634 array_push($filenames, $row['regex_filename']); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
635 } |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
636 |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
637 return $filenames; |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
638 } |
|
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
|
639 public function LoadSmartRegex($topic_id) { |
|
47
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
640 |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
641 // 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
|
642 $filenames = $this->GetRegexFilenameById($topic_id); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
643 |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
644 // Get regex file from filesystem ---- |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
645 $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
|
646 $returnArray = array(); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
647 $files1 = scandir($data_path."regex_files"); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
648 foreach ( $files1 as $file ) { |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
649 if ( $file != "." && $file != ".." && $file != ".DS_Store") { |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
650 foreach ($filenames as $filename) { |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
651 if ($file == $filename) { |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
652 $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
|
653 break; |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
654 } |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
655 } |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
656 } |
|
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 echo json_encode($returnArray); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
659 return; |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
660 } |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
661 |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
662 |
|
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
|
663 public function SaveSmartRegex($_postdata) { |
|
47
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
664 if ($_postdata['text']){ |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
665 |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
666 // --- update topic_regex_relation table --- |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
667 $topic_id = $_postdata['topic_id']; |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
668 $filename = $_postdata['filename'].'.txt'; |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
669 |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
670 // 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
|
671 $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
|
672 $result = mysql_query($query); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
673 if (!$result) { |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
674 echo json_encode("ErrorDB"); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
675 } |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
676 while ($row = mysql_fetch_assoc($result)) { |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
677 if ($row && !$_postdata['forcesave']) { |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
678 // promt user a comfirm to force saving or not |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
679 echo json_encode("ForceSave"); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
680 return; |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
681 } |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
682 } |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
683 |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
684 |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
685 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
|
686 $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
|
687 $result = mysql_query($query); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
688 if (!$result) { |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
689 echo json_encode("ErrorDB"); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
690 } |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
691 } |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
692 // --- write to filesystem --- |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
693 |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
694 /* |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
695 $date = date('Y_m_d_H_i_s', time()); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
696 if ( file_exists("regex_files/".$_POST['filename'].".txt") ) { |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
697 $oldFile = file_get_contents("regex_files/".$_POST['filename'].".txt"); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
698 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
|
699 } |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
700 */ |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
701 $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
|
702 |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
703 if (get_magic_quotes_gpc()) { |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
704 $require = stripslashes($_postdata['text']); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
705 } else { |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
706 $require = $_postdata['text']; |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
707 } |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
708 |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
709 file_put_contents( $data_path."regex_files/".$_postdata['filename'].".txt", $require); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
710 |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
711 |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
712 } |
|
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 |
|
77
97c1e5102a22
New: export table for a file from LGService
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
76
diff
changeset
|
716 private function GetTableArray($_taglistArray, $_topic_tag, $_content) { |
|
47
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
717 |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
718 $outputTableArray = array(); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
719 $outputTableArray[0]=array(); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
720 $outputTableArray[0][0]=array(); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
721 $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
|
722 foreach ( $_taglistArray as $value ) { |
|
47
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
723 $outputTableArray[0][0][$value[2]] = $value[1]; |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
724 $outputTableArray[0][1][$value[2]] = $value[1]."(Title)"; |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
725 } |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
726 $outputTableArray[0]["other"] = "其他"; |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
727 $outputTableArray[0]["page"] = "頁數"; |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
728 $outputTableArray[0]["full"] = "全文"; |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
729 |
|
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
|
730 // 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
|
731 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
|
732 $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
|
733 $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
|
734 $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
|
735 } |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
736 |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
737 $contentLineArray = explode( "<br>", $content ); |
|
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 $count=0; |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
740 $pageNow=NULL; |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
741 foreach ( $contentLineArray as $value ) { |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
742 $count++; |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
743 $recordString = $value; |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
744 $otherString = $recordString; |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
745 //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
|
746 // find hyper link in pattern with <a>...</a> |
|
47
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
747 if ( preg_match("/【<a(.*?)>(.*?)<\/a>】/u", $recordString, $matches) ) { |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
748 $pageNow = $matches[2]; |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
749 } |
|
77
97c1e5102a22
New: export table for a file from LGService
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
76
diff
changeset
|
750 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
|
751 $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
|
752 |
|
960ba96efce1
Update: click to popup remove-tag-window; select to popup tag-window
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
77
diff
changeset
|
753 if ( 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
|
754 foreach ( $matches as $matchesValue ) { |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
755 $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
|
756 |
|
47
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
757 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
|
758 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
|
759 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
|
760 $outputTableArray[$count][0][$tag_name] .= ";".$matches2Value[1]; |
|
47
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
761 } 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
|
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 } |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
764 } |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
765 } 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
|
766 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
|
767 $outputTableArray[$count][0][$tag_name] .= ";".$matchesValue[1]; |
|
47
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
768 } 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
|
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 } |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
771 } |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
772 } |
|
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
|
773 $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
|
774 } |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
775 } |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
776 $otherString = preg_replace("/○/u", "", $otherString); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
777 $outputTableArray[$count]["other"] = $otherString; |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
778 $outputTableArray[$count]["page"] = $pageNow; |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
779 $value = preg_replace("/>/u", ">", $value); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
780 $value = preg_replace("/</u", "<", $value); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
781 $outputTableArray[$count]["full"] = $value; |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
782 } |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
783 |
|
77
97c1e5102a22
New: export table for a file from LGService
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
76
diff
changeset
|
784 |
|
47
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
785 |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
786 foreach ( $outputTableArray as $arrayIndex => $arrayValue ) { |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
787 // output each row which the topic tag |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
788 // 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
|
789 if ( !isset($arrayValue[0][$_topic_tag]) ) { |
|
47
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
790 unset($outputTableArray[$arrayIndex]); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
791 } |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
792 |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
793 } |
|
77
97c1e5102a22
New: export table for a file from LGService
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
76
diff
changeset
|
794 // ----- |
|
47
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
795 |
|
77
97c1e5102a22
New: export table for a file from LGService
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
76
diff
changeset
|
796 return $outputTableArray; |
|
97c1e5102a22
New: export table for a file from LGService
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
76
diff
changeset
|
797 } |
|
97c1e5102a22
New: export table for a file from LGService
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
76
diff
changeset
|
798 |
|
97c1e5102a22
New: export table for a file from LGService
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
76
diff
changeset
|
799 // === for export table === |
|
97c1e5102a22
New: export table for a file from LGService
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
76
diff
changeset
|
800 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
|
801 if ($isFromFile) { |
|
97c1e5102a22
New: export table for a file from LGService
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
76
diff
changeset
|
802 $content = $this->lg_text; |
|
97c1e5102a22
New: export table for a file from LGService
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
76
diff
changeset
|
803 $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
|
804 $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
|
805 $sectionName = $this->section_name; |
|
97c1e5102a22
New: export table for a file from LGService
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
76
diff
changeset
|
806 $bookId = $this->book_id; |
|
97c1e5102a22
New: export table for a file from LGService
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
76
diff
changeset
|
807 $bookName = $this->book_name; |
|
97c1e5102a22
New: export table for a file from LGService
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
76
diff
changeset
|
808 |
|
97c1e5102a22
New: export table for a file from LGService
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
76
diff
changeset
|
809 $taglistArray = $this->taglist_infile; |
|
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 } else { |
|
97c1e5102a22
New: export table for a file from LGService
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
76
diff
changeset
|
812 $content = $postdata['content']; |
|
97c1e5102a22
New: export table for a file from LGService
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
76
diff
changeset
|
813 $topic = $postdata['topic']; |
|
97c1e5102a22
New: export table for a file from LGService
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
76
diff
changeset
|
814 $section_id = $postdata['sectionId']; |
|
97c1e5102a22
New: export table for a file from LGService
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
76
diff
changeset
|
815 $sectionName = $postdata['sectionName']; |
|
97c1e5102a22
New: export table for a file from LGService
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
76
diff
changeset
|
816 $bookId = $postdata['bookId']; |
|
97c1e5102a22
New: export table for a file from LGService
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
76
diff
changeset
|
817 $bookName = $postdata['bookName']; |
|
97c1e5102a22
New: export table for a file from LGService
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
76
diff
changeset
|
818 |
|
97c1e5102a22
New: export table for a file from LGService
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
76
diff
changeset
|
819 //$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
|
820 $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
|
821 } |
|
97c1e5102a22
New: export table for a file from LGService
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
76
diff
changeset
|
822 // ===== |
|
97c1e5102a22
New: export table for a file from LGService
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
76
diff
changeset
|
823 |
|
97c1e5102a22
New: export table for a file from LGService
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
76
diff
changeset
|
824 $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
|
825 |
|
97c1e5102a22
New: export table for a file from LGService
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
76
diff
changeset
|
826 // 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
|
827 $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
|
828 |
|
97c1e5102a22
New: export table for a file from LGService
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
76
diff
changeset
|
829 |
|
97c1e5102a22
New: export table for a file from LGService
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
76
diff
changeset
|
830 |
|
91
3e11a9c5a672
new: explore table for using on LGMap
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
90
diff
changeset
|
831 $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
|
832 |
|
77
97c1e5102a22
New: export table for a file from LGService
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
76
diff
changeset
|
833 // data for view |
|
47
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
834 $data = array(); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
835 $data['outputTableArray'] = $outputTableArray; |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
836 $data['bookId'] = $bookId; |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
837 $data['section_id'] = $section_id; |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
838 $data['bookName'] = $bookName; |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
839 $data['sectionName'] = $sectionName; |
|
91
3e11a9c5a672
new: explore table for using on LGMap
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
90
diff
changeset
|
840 $data['bookMeta'] = $bookMeta; |
|
47
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
841 |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
842 return $data; |
|
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 } |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
845 // === for manage tag list === |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
846 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
|
847 /** |
|
97c1e5102a22
New: export table for a file from LGService
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
76
diff
changeset
|
848 */ |
|
97c1e5102a22
New: export table for a file from LGService
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
76
diff
changeset
|
849 |
|
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
|
850 $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
|
851 $result = mysql_query($query); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
852 if (!$result) { |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
853 echo json_encode(mysql_error()); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
854 } |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
855 $row = mysql_fetch_assoc($result); |
|
51
840cdb52f476
add book_meta into file
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
48
diff
changeset
|
856 $largest_id = $row['AUTO_INCREMENT']-1; |
|
47
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
857 |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
858 |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
859 $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
|
860 $result = $this->GetTaglistByTopicId($topic_id); |
|
47
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
861 |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
862 $taglistArray = array(); |
|
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 foreach ($result as $row) { |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
865 $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
|
866 //$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
|
867 } |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
868 |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
869 $topic_tag_name = $this->GetTopicTag($topic_id); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
870 |
|
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
|
871 $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
|
872 $result = mysql_query($query); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
873 if (!$result) { |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
874 echo json_encode(mysql_error()); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
875 } |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
876 $row = mysql_fetch_assoc($result); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
877 $topic_tag_id = $row['id']; |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
878 |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
879 $data = array(); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
880 $data['taglistArray'] = $taglistArray; |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
881 $data['topic_id'] = $topic_id; |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
882 $data['largest_id'] = $largest_id; |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
883 $data['topic_tag_id'] = $topic_tag_id; |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
884 |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
885 |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
886 return $data; |
|
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 } |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
889 |
|
67
3ada9334ebfc
New: check taglist is deprecated or not
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
66
diff
changeset
|
890 private function GetTag($_postdata) { |
|
47
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
891 if (get_magic_quotes_gpc()) { |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
892 $id = stripslashes($_postdata['id']); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
893 $name = stripslashes($_postdata['name']); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
894 $tag = stripslashes($_postdata['tag']); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
895 $color = stripslashes($_postdata['color']); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
896 } else { |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
897 $id = $_postdata['id']; |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
898 $name = $_postdata['name']; |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
899 $tag = $_postdata['tag']; |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
900 $color = $_postdata['color']; |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
901 } |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
902 return array($id, $name, $tag, $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 |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
905 public function NewTagElement($postdata) { |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
906 if ($postdata['id']){ |
|
67
3ada9334ebfc
New: check taglist is deprecated or not
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
66
diff
changeset
|
907 list($id, $name, $tag, $color) = $this->GetTag($postdata); |
|
47
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
908 |
|
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
|
909 // 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
|
910 $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
|
911 |
|
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
|
912 $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
|
913 $this->GetSQLValueString($id, "int"), |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
914 $this->GetSQLValueString($name, "text"), |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
915 $this->GetSQLValueString($tag, "text"), |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
916 $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
|
917 $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
|
918 $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
|
919 //$this->GetSQLValueString($this->systemNAME, "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
|
920 |
|
47
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
921 $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
|
922 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
|
923 //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
|
924 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
|
925 return; |
|
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 } |
|
47
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
927 |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
928 // add it to topic_tag_relation table |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
929 $topic_id = $postdata['topic_id']; |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
930 |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
931 // 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
|
932 //$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
|
933 |
|
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`, `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
|
935 $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
|
936 $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
|
937 $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
|
938 $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
|
939 |
|
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 |
|
47
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
941 $result = mysql_query($query); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
942 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
|
943 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
|
944 //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
|
945 } |
|
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
|
946 |
|
47
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
947 } |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
948 |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
949 } |
|
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 public function SaveTagElement($postdata) { |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
952 if ($postdata['id']){ |
|
67
3ada9334ebfc
New: check taglist is deprecated or not
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
66
diff
changeset
|
953 list($id, $name, $tag, $color) = $this->GetTag($postdata); |
|
47
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
954 |
|
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
|
955 // 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
|
956 $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
|
957 |
|
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 $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
|
959 $this->GetSQLValueString($name, "text"), |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
960 $this->GetSQLValueString($tag, "text"), |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
961 $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
|
962 $this->GetSQLValueString($date, "date"), |
|
47
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
963 $this->GetSQLValueString($id, "int")); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
964 $result = mysql_query($query); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
965 |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
966 } |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
967 |
|
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 public function DeleteTag($postdata) { |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
971 if ($postdata['id']) { |
|
94
b0cecc104639
new: modified tags can work on tagged text
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
91
diff
changeset
|
972 $tag_id = $postdata['id']; |
|
b0cecc104639
new: modified tags can work on tagged text
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
91
diff
changeset
|
973 |
|
b0cecc104639
new: modified tags can work on tagged text
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
91
diff
changeset
|
974 // 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
|
975 $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
|
976 $result = mysql_query($query); |
|
b0cecc104639
new: modified tags can work on tagged text
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
91
diff
changeset
|
977 |
|
b0cecc104639
new: modified tags can work on tagged text
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
91
diff
changeset
|
978 // 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
|
979 $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
|
980 $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
|
981 $result = mysql_query($query); |
|
b0cecc104639
new: modified tags can work on tagged text
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
91
diff
changeset
|
982 |
|
47
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
983 } |
|
94
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 } |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
986 |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
987 // === for config topic === |
| 95 | 988 public function CreateNewTopic($_postdata) { |
| 989 $new_topic_id = "2"; // default topic_id=1 for 'person' topic | |
| 990 | |
| 991 // get user input data from postdata | |
| 992 $new_topic_name_en = $_postdata['new_topic_name_en']; | |
| 993 $new_topic_name_ch = $_postdata['new_topic_name_ch']; | |
| 994 $new_topic_name_pi = $_postdata['new_topic_name_pi']; | |
| 995 $new_topic_tag = $_postdata['new_topic_tag']; | |
| 996 $new_topic_tag_name = $_postdata['new_topic_tag_name']; | |
| 997 | |
| 998 // -- Start Transaction -- | |
| 999 mysql_query("BEGIN"); | |
| 1000 | |
| 1001 // create records for the new topic in database | |
| 1002 /* In table: | |
| 1003 taglist: name, tag, color (default, user can change later in the editing page) | |
| 1004 topics: tag, name_en, name_ch, name_pinyin | |
| 1005 topic_tag_relation: topic_id (new), tag_id (new) | |
| 1006 | |
| 1007 - need transaction for the following actions: | |
| 1008 taglist.name: topic_tag name in chinese | |
| 1009 taglist.tag: topic_tag name in eng | |
| 1010 topics.tag: (the same a taglist.tag) | |
| 1011 topics.name_en: | |
| 1012 topics.name_ch: | |
| 1013 topics.name_pinyin: | |
| 1014 | |
| 1015 | |
| 1016 topic_tag_relation.topic_id = new_topic_id | |
| 1017 topic_tag_relation.tag_id = new_tag_id | |
| 1018 which are the new record that just been created in the 'taglist' and 'topics' table | |
| 1019 */ | |
| 1020 | |
| 1021 // new record in topics 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
|
1022 $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 | 1023 $result_topics=mysql_query($query); |
| 1024 if($result_topics){ | |
| 1025 $new_topic_id = mysql_insert_id(); | |
| 1026 } else { | |
| 1027 //echo mysql_error(); | |
| 1028 } | |
| 1029 | |
| 1030 // new 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
|
1031 $query="INSERT INTO Taglist (name, tag, color) VALUES ('".$new_topic_tag_name."','".$new_topic_tag."','rgb(255, 0, 174)')"; |
| 95 | 1032 $result_taglist=mysql_query($query); |
| 1033 if($result_taglist){ | |
| 1034 $new_tag_id = mysql_insert_id(); | |
| 1035 } else { | |
| 1036 //echo mysql_error(); | |
| 1037 } | |
| 1038 | |
| 1039 // new record in topic_tag_relation | |
|
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
|
1040 $query="INSERT INTO TopicTagRelation (topicId, tagId) VALUES ('".$new_topic_id."','".$new_tag_id."')"; |
| 95 | 1041 $result_topic_tag_relation=mysql_query($query); |
| 1042 if($result_topic_tag_relation){ | |
| 1043 | |
| 1044 } else { | |
| 1045 //echo mysql_error(); | |
| 1046 } | |
| 1047 | |
| 1048 | |
| 1049 // --- End Transaction --- | |
| 1050 if ($result_taglist && $result_topics && $result_topic_tag_relation) { | |
| 1051 mysql_query("COMMIT"); | |
| 1052 | |
| 1053 } else { | |
| 1054 mysql_query("ROLLBACK"); | |
| 1055 return "error"; | |
| 1056 } | |
| 1057 | |
| 1058 | |
| 1059 $_postdata['topic'] = $new_topic_id; | |
| 1060 return $_postdata; | |
| 1061 } | |
| 1062 | |
| 1063 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
|
1064 /** |
|
97c1e5102a22
New: export table for a file from LGService
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
76
diff
changeset
|
1065 * |
|
97c1e5102a22
New: export table for a file from LGService
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
76
diff
changeset
|
1066 */ |
|
97c1e5102a22
New: export table for a file from LGService
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
76
diff
changeset
|
1067 |
| 95 | 1068 $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
|
1069 $result = $this->GetTopicById($topic); |
|
47
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1070 $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
|
1071 $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
|
1072 $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
|
1073 $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
|
1074 $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
|
1075 |
|
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 |
|
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 /* |
|
65
f9ae94a9b041
New: adding topic names: name_en, name_ch, name_pinyin
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
63
diff
changeset
|
1078 $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
|
1079 $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
|
1080 $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
|
1081 */ |
|
47
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1082 |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1083 /* |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1084 $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
|
1085 $result = mysql_query($query); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1086 if (!$result) { |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1087 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
|
1088 } |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1089 $taglistArray = array(); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1090 while ($row = mysql_fetch_assoc($result)) { |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1091 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
|
1092 } |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1093 */ |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1094 |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1095 // ------ |
|
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
|
1096 $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
|
1097 $result = mysql_query($query); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1098 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
|
1099 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
|
1100 } |
|
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 |
|
47
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1102 $tag_intopic = array(); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1103 $tag_others = array(); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1104 $tag_tmp_others = array(); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1105 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
|
1106 // 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
|
1107 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
|
1108 // 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
|
1109 } 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
|
1110 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
|
1111 } 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
|
1112 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
|
1113 } |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1114 } |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1115 |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1116 // --- 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
|
1117 $num_others = count($tag_tmp_others); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1118 for ($i=0; $i < $num_others; $i++) { |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1119 $cnt = 0; |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1120 for ($j=$i+1; $j < $num_others; $j++) { |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1121 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
|
1122 break; |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1123 } else { |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1124 $cnt++; |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1125 } |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1126 } |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1127 if ($cnt == ($num_others-$i-1) ) { |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1128 $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
|
1129 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
|
1130 } |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1131 } |
|
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 // --- 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
|
1134 $tag_tmp_others = $tag_others; |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1135 $tag_others = array(); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1136 |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1137 foreach ($tag_tmp_others as $tmp) { |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1138 $cnt = 0; |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1139 foreach ($tag_intopic as $intopic) { |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1140 if ($tmp['tag'] == $intopic['tag']) { |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1141 break; |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1142 } else { |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1143 $cnt ++; |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1144 } |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1145 } |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1146 if ($cnt == count($tag_intopic)) { |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1147 // not appear in $tag_intopic |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1148 array_push($tag_others, $tmp); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1149 } |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1150 } |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1151 |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1152 // ----- |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1153 |
|
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 $data = array(); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1156 //$data['taglistArray'] = $taglistArray; |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1157 $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
|
1158 $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
|
1159 |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1160 $data['tag_intopic'] = $tag_intopic; |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1161 $data['tag_others'] = $tag_others; |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1162 |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1163 return $data; |
|
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 |
|
94
b0cecc104639
new: modified tags can work on tagged text
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
91
diff
changeset
|
1166 |
|
47
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1167 |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1168 public function UpdateTagsInTopic($_postdata) { |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1169 $topic_id = $_postdata['topic_id']; |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1170 $tag_ids = json_decode(str_replace('\\', '', $_postdata['ids'])); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1171 |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1172 // 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
|
1173 |
|
c1bb174a22f3
Topic synchronization with LGServices. Adaption for moving table from Gazetteer to LGService.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
95
diff
changeset
|
1174 |
|
47
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1175 // --- add new topic_tag_relation --- |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1176 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
|
1177 $query = "SELECT * FROM TopicTagRelation WHERE tagId=".$tag_id; |
|
47
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1178 $result = mysql_query($query); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1179 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
|
1180 echo json_encode("error when select from TopicTagRelation"); |
|
47
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1181 } |
|
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 //$topic_tag = array(); |
|
47
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1183 $flag = false; |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1184 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
|
1185 if ($row['topicId'] == $topic_id) { |
|
47
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1186 $flag = true; |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1187 break; |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1188 } |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1189 } |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1190 if (!$flag) { |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1191 // 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
|
1192 // $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
|
1193 |
|
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 $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
|
1195 $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
|
1196 $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
|
1197 $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
|
1198 $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
|
1199 $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
|
1200 |
|
47
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1201 $resultUpdate = mysql_query($queryUpdate); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1202 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
|
1203 return json_encode("error when insert TopicTagRelation table"); |
|
47
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1204 } |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1205 } |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1206 |
|
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 |
|
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
|
1209 |
|
47
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1210 // --- 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
|
1211 // 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
|
1212 |
|
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 // 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
|
1214 $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
|
1215 $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
|
1216 |
|
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 //$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
|
1218 $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
|
1219 $result = mysql_query($query); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1220 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
|
1221 echo json_encode("error when select from TopicTagRelation"); |
|
47
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1222 } |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1223 |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1224 while ($row = mysql_fetch_assoc($result)) { |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1225 $cnt = 0; |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1226 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
|
1227 if ($row['tagId'] == $tag_id) { |
|
47
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1228 break; |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1229 } else { |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1230 $cnt ++; |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1231 } |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1232 } |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1233 $_id = $row['id']; |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1234 if ($cnt == count($tag_ids)) { |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1235 // 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
|
1236 $queryDelete = "DELETE FROM TopicTagRelation WHERE id=".$_id; |
|
47
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1237 $resultDelete = mysql_query($queryDelete); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1238 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
|
1239 echo json_encode("error when delete from TopicTagRelation"); |
|
47
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1240 } |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1241 } |
|
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 |
|
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
|
1248 private function GetTaglistByTopicId($topic_id) { |
|
47
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1249 $taglistArray = array(); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1250 // 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
|
1251 $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
|
1252 $result = mysql_query($query); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1253 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
|
1254 return json_encode("Failed during selecting TopicTagRelation table."); |
|
47
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1255 } |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1256 $taglist_ids = array(); |
|
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 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
|
1259 array_push($taglist_ids, $row['tagId']); |
|
47
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1260 } |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1261 |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1262 // select taglist by tag ids |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1263 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
|
1264 $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
|
1265 $result = mysql_query($query); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1266 if (!$result) { |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1267 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
|
1268 return json_encode("Failed during selecting Taglist table."); |
|
47
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1269 } |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1270 |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1271 $row = mysql_fetch_assoc($result); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1272 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
|
1273 |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1274 } |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1275 return $taglistArray; |
|
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 |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1278 public function SetTopic($topic) { |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1279 $this->topic = $topic; |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1280 } |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1281 |
|
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
|
1282 private function GetTopic() { |
|
47
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1283 return $this->topic; |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1284 } |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1285 |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1286 private function GetTopiclistArray() { |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1287 $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
|
1288 $result = $this->GetTopicList(); |
|
47
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1289 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
|
1290 //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
|
1291 //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
|
1292 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
|
1293 } |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1294 return $topiclistArray; |
|
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 |
|
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 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
|
1299 $result = $this->GetTopicById($topic_id); |
|
47
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1300 $row = mysql_fetch_assoc($result); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1301 $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
|
1302 |
|
e542b161d907
bug fixed: for only lowercase accepted in html tag.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
102
diff
changeset
|
1303 // 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
|
1304 // 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 |
|
e542b161d907
bug fixed: for only lowercase accepted in html tag.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
102
diff
changeset
|
1305 |
|
e542b161d907
bug fixed: for only lowercase accepted in html tag.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
102
diff
changeset
|
1306 $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
|
1307 return strtolower($tag); |
|
e542b161d907
bug fixed: for only lowercase accepted in html tag.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
102
diff
changeset
|
1308 |
|
e542b161d907
bug fixed: for only lowercase accepted in html tag.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
102
diff
changeset
|
1309 //return $tag; |
|
47
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1310 } |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1311 private function 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
|
1312 $result = $this->GetTopicById($topic_id); |
|
47
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1313 $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
|
1314 //$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
|
1315 $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
|
1316 return $name; |
|
86
0141df465205
New: add chinese characters to pinyin
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
84
diff
changeset
|
1317 } |
|
0141df465205
New: add chinese characters to pinyin
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
84
diff
changeset
|
1318 private function GetTopicTagName($topic_id) { |
|
0141df465205
New: add chinese characters to pinyin
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
84
diff
changeset
|
1319 $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
|
1320 $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
|
1321 $result = mysql_query($query); |
|
0141df465205
New: add chinese characters to pinyin
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
84
diff
changeset
|
1322 $row = mysql_fetch_assoc($result); |
|
47
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1323 |
|
86
0141df465205
New: add chinese characters to pinyin
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
84
diff
changeset
|
1324 return $row['name']; |
|
47
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1325 } |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1326 |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1327 |
|
86
0141df465205
New: add chinese characters to pinyin
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
84
diff
changeset
|
1328 |
|
0141df465205
New: add chinese characters to pinyin
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
84
diff
changeset
|
1329 |
|
47
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1330 // =========================== |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1331 |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1332 // === for manage wordlist === |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1333 public function EditWordlist() { |
|
77
97c1e5102a22
New: export table for a file from LGService
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
76
diff
changeset
|
1334 /** |
|
97c1e5102a22
New: export table for a file from LGService
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
76
diff
changeset
|
1335 * 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
|
1336 * 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
|
1337 */ |
|
97c1e5102a22
New: export table for a file from LGService
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
76
diff
changeset
|
1338 |
|
47
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1339 $result = $this->GetWordlist(); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1340 $wordlistArray = array(); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1341 while ($row = mysql_fetch_assoc($result)) { |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1342 $wordlistArray[$row['id']] = $row['name']; |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1343 } |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1344 |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1345 $data = array(); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1346 $data['wordlistArray'] = $wordlistArray; |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1347 return $data; |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1348 } |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1349 |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1350 |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1351 public function AddNewList($postdata) { |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1352 if ($postdata['text']){ |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1353 if (get_magic_quotes_gpc()) { |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1354 $name = stripslashes($postdata['text']); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1355 } else { |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1356 $name = $postdata['text']; |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1357 } |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1358 |
|
101
a264460c77ca
new: auto save and reload page after updating taglist.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
97
diff
changeset
|
1359 $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
|
1360 $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
|
1361 //$this->GetSQLValueString($this->systemNAME, "text")); |
|
47
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1362 $result1 = mysql_query($query1); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1363 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
|
1364 } |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1365 } |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1366 |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1367 |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1368 public function SaveWordlist($postdata) { |
|
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 if ($postdata['text']){ |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1371 $date = date('Y_m_d_H_i_s', time()); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1372 if ( file_exists("data/wordlist/".$postdata['filename'].".txt") ) { |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1373 $filename = "data/wordlist/".$postdata['filename']."_".$date.".txt"; |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1374 $oldFile = file_get_contents("data/wordlist/".$postdata['filename'].".txt"); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1375 file_put_contents($filename, $oldFile); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1376 } |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1377 /*else { |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1378 $filename = "data/wordlist/".$postdata['filename'].".txt"; |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1379 } |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1380 */ |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1381 |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1382 |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1383 if (get_magic_quotes_gpc()) { |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1384 $require = stripslashes($postdata['text']); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1385 } else { |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1386 $require = $postdata['text']; |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1387 } |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1388 |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1389 $require = preg_replace("/<br>/u", "<br>", $require); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1390 file_put_contents("data/wordlist/".$postdata['filename'].".txt", $require); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1391 } |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1392 /* |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1393 if ($postdata['text']){ |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1394 $date = date('Y_m_d_H_i_s', time()); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1395 if ( file_exists("data/wordlist/".$postdata['filename'].".txt") ) { |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1396 $oldFile = file_get_contents("data/wordlist/".$postdata['filename'].".txt"); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1397 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
|
1398 } |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1399 |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1400 if (get_magic_quotes_gpc()) { |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1401 $require = stripslashes($postdata['text']); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1402 } else { |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1403 $require = $postdata['text']; |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1404 } |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1405 |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1406 // $require = preg_replace("/<br>/u", "", $require); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1407 file_put_contents("data/wordlist/".$postdata['filename'].".txt", $require); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1408 } |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1409 */ |
|
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 // ======================================= |
|
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
|
1414 |
|
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
|
1415 private function sortFunction($a,$b) { |
|
47
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1416 return strlen($b)-strlen($a); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1417 } |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1418 |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1419 private function GetSectionId() { |
|
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 if (is_numeric($this->section_id)) { |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1422 return $this->section_id; |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1423 } else { |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1424 return json_encode("Error: No section id"); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1425 } |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1426 } |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1427 |
|
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
|
1428 |
|
c1bb174a22f3
Topic synchronization with LGServices. Adaption for moving table from Gazetteer to LGService.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
95
diff
changeset
|
1429 /* 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
|
1430 /* |
|
47
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1431 private function GetSectionInfo() { |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1432 $section_id = $this->GetSectionId(); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1433 if (!is_numeric($section_id)){ |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1434 return $section_id; |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1435 } |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1436 |
|
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
|
1437 $result = $this->GetSectionsById($section_id); |
|
47
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1438 |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1439 |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1440 while ($row = mysql_fetch_assoc($result)) { |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1441 $bookId=$row['books_id']; |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1442 $startPage=$row['start_page']; |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1443 $endPage=$row['end_page']; |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1444 $sectionName = $row['name']; |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1445 } |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1446 |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1447 $data = array(); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1448 $data['bookId'] = $bookId; |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1449 $data['startPage'] = $startPage; |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1450 $data['endPage'] = $endPage; |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1451 $data['sectionName'] = $sectionName; |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1452 |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1453 |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1454 return $data; |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1455 } |
|
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
|
1456 */ |
|
47
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1457 |
|
74
60b5a94163c3
New: retrieve book meta data from LGService
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
73
diff
changeset
|
1458 private function ParseDataInFile($filename) { |
|
47
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1459 $text = file_get_contents($filename); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1460 $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
|
1461 if (!$xml) { |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1462 // 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
|
1463 return $text; |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1464 } |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1465 |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1466 $this->topic = (string)$xml->topic; // set topic id |
|
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 // get taglist in file |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1469 $taglist_infile = $xml->tagitem; |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1470 $taglistArray = array(); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1471 foreach ($taglist_infile as $row) { |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1472 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
|
1473 } |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1474 if ($taglistArray) { |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1475 $this->taglist_infile = $taglistArray; |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1476 } |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1477 |
|
74
60b5a94163c3
New: retrieve book meta data from LGService
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
73
diff
changeset
|
1478 // --- 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
|
1479 /* |
|
47
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1480 $book_meta = $xml->book; |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1481 $book_metaArray = array(); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1482 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
|
1483 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
|
1484 (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
|
1485 (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
|
1486 } |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1487 if ($book_metaArray) { |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1488 $this->book_meta = $book_metaArray; |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1489 } |
|
74
60b5a94163c3
New: retrieve book meta data from LGService
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
73
diff
changeset
|
1490 */ |
|
60b5a94163c3
New: retrieve book meta data from LGService
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
73
diff
changeset
|
1491 // ----- |
|
94
b0cecc104639
new: modified tags can work on tagged text
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
91
diff
changeset
|
1492 // 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
|
1493 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
|
1494 if ($xml->section) { |
|
97c1e5102a22
New: export table for a file from LGService
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
76
diff
changeset
|
1495 $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
|
1496 $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
|
1497 } |
|
97c1e5102a22
New: export table for a file from LGService
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
76
diff
changeset
|
1498 } |
|
97c1e5102a22
New: export table for a file from LGService
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
76
diff
changeset
|
1499 // book meta data |
|
97c1e5102a22
New: export table for a file from LGService
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
76
diff
changeset
|
1500 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
|
1501 $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
|
1502 $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
|
1503 } |
|
97c1e5102a22
New: export table for a file from LGService
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
76
diff
changeset
|
1504 |
|
97c1e5102a22
New: export table for a file from LGService
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
76
diff
changeset
|
1505 |
|
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
|
1506 |
|
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
|
1507 $contentString = (string)($xml->text_content->asXML()); |
|
47
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1508 |
|
76
c49192885290
Bug fixed: ambiguous tag occured at Editing-text mode
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
75
diff
changeset
|
1509 $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
|
1510 $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
|
1511 |
|
94
b0cecc104639
new: modified tags can work on tagged text
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
91
diff
changeset
|
1512 |
|
76
c49192885290
Bug fixed: ambiguous tag occured at Editing-text mode
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
75
diff
changeset
|
1513 return $new_contentString; |
|
47
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1514 } |
|
74
60b5a94163c3
New: retrieve book meta data from LGService
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
73
diff
changeset
|
1515 |
|
60b5a94163c3
New: retrieve book meta data from LGService
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
73
diff
changeset
|
1516 |
|
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
|
1517 /** This is only been called by SetTextFromLocal(). |
|
c1bb174a22f3
Topic synchronization with LGServices. Adaption for moving table from Gazetteer to LGService.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
95
diff
changeset
|
1518 */ |
|
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 /* |
|
77
97c1e5102a22
New: export table for a file from LGService
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
76
diff
changeset
|
1520 private function GetSectionContent() { |
|
97c1e5102a22
New: export table for a file from LGService
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
76
diff
changeset
|
1521 |
|
47
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1522 $section_id = $this->GetSectionId(); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1523 $section_info = $this->GetSectionInfo(); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1524 |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1525 $bookId = $section_info['bookId']; |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1526 $startPage = $section_info['startPage']; |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1527 $endPage = $section_info['endPage']; |
|
86
0141df465205
New: add chinese characters to pinyin
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
84
diff
changeset
|
1528 $this->section_name = $section_info['sectionName']; |
|
0141df465205
New: add chinese characters to pinyin
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
84
diff
changeset
|
1529 |
|
47
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1530 |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1531 $contentString=""; |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1532 $data_path = $this->GetDataPath(); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1533 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
|
1534 $filename = $data_path."parsing_files/".$section_id.".txt"; |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1535 |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1536 // --- parsing meta data |
|
74
60b5a94163c3
New: retrieve book meta data from LGService
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
73
diff
changeset
|
1537 $stringInput = $this->ParseDataInFile($filename); |
|
47
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1538 // ---- |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1539 |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1540 // if the text is from file system |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1541 $stringInput = preg_replace("/ /u", "○", $stringInput); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1542 $stringInput = preg_replace("/\n/u", "<br>", $stringInput); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1543 $stringInput = preg_replace("/【(.*?)】/u", "【<a href=\"review_index_xml_images.php?books_id=".$bookId."&pages=\\1&entry=0\" target=\"_bookImg\">\\1</a>】", $stringInput); |
|
63
3395385476d1
bug fixed: popup tag window is closed automatically when saving text file
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
62
diff
changeset
|
1544 |
|
3395385476d1
bug fixed: popup tag window is closed automatically when saving text file
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
62
diff
changeset
|
1545 $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
|
1546 |
|
47
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1547 } else { |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1548 $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
|
1549 $result = mysql_query($query); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1550 if (!$result) { |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1551 return json_encode("Failed during selecting content table."); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1552 } |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1553 while ($row = mysql_fetch_assoc($result)) { |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1554 $contentString.="【".$row['line']."】".$row['content']."\n"; |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1555 } |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1556 |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1557 // the text is from database |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1558 $stringInput = $contentString; |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1559 $stringInput = preg_replace("/<(.*?)>/u", "○", $stringInput); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1560 $stringInput = preg_replace("/ /u", "○", $stringInput); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1561 $stringInput = preg_replace("/\n/u", "<br>", $stringInput); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1562 $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
|
1563 } |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1564 |
|
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
|
1565 return $stringInput; |
|
51
840cdb52f476
add book_meta into file
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
48
diff
changeset
|
1566 |
|
47
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1567 } |
|
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
|
1568 */ |
|
c1bb174a22f3
Topic synchronization with LGServices. Adaption for moving table from Gazetteer to LGService.
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
95
diff
changeset
|
1569 |
|
47
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1570 |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1571 private function GetDataPath() { |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1572 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
|
1573 } |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1574 |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1575 private function GetTaglistArray() { |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1576 $taglistArray = array(); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1577 $result = $this->GetTaglist(); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1578 while ($row = mysql_fetch_assoc($result)) { |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1579 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
|
1580 } |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1581 |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1582 return $taglistArray; |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1583 } |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1584 |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1585 private function GetWordlistArray() { |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1586 $wordlistArray=""; |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1587 $result = $this->GetWordlist(); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1588 while ($row = mysql_fetch_assoc($result)) { |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1589 $listString = file_get_contents("data/wordlist/".$row['id'].".txt"); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1590 $listString = preg_replace("/<div>/u", "\n", $listString); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1591 $listString = preg_replace("/<\/div>/u", "", $listString); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1592 $listString = preg_replace("/<span(.*?)>/u", "", $listString); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1593 $listString = preg_replace("/<\/span>/u", "", $listString); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1594 //$listString = preg_replace("/\n/u", "|", $listString); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1595 |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1596 $wordlistArray2 = explode( "\n", $listString ); |
|
71
26d8c4c43d86
minor checking for variable/index in php
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
70
diff
changeset
|
1597 //usort($wordlistArray2,'sortFunction'); |
|
47
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1598 foreach ( $wordlistArray2 as $index=>$value ) { |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1599 $wordlistArray2[$index] = implode("○?", preg_split("/(?<!^)(?!$)/u", $value)); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1600 } |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1601 foreach ( $wordlistArray2 as $index=>$value ) { |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1602 if ($value=="") unset($wordlistArray2[$index]); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1603 |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1604 } |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1605 $listString = implode("|", $wordlistArray2); |
|
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 if ( $listString[0]=="|" ) $listString = substr($listString, 1); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1608 $wordlistArray[] = array( $row['id'], $row['name'], $listString ); |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1609 } |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1610 |
|
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 return $wordlistArray; |
|
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 } |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1615 |
|
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
|
1616 |
|
47
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1617 } |
|
886f43b26ee2
move/remove develop folder
Zoe Hong <zhong@mpiwg-berlin.mpg.de>
parents:
diff
changeset
|
1618 |
|
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 ?> |