]>
git.wh0rd.org - tt-rss.git/blob - modules/pref-labels.php
2 function module_pref_labels($link) {
4 $subop = $_REQUEST["subop"];
6 if ($subop == "color-set") {
7 $kind = db_escape_string($_REQUEST["kind"]);
8 $ids = split(',', db_escape_string($_REQUEST["ids"]));
9 $color = db_escape_string($_REQUEST["color"]);
10 $fg = db_escape_string($_REQUEST["fg"]);
11 $bg = db_escape_string($_REQUEST["bg"]);
13 foreach ($ids as $id) {
15 if ($kind == "fg" ||
$kind == "bg") {
16 db_query($link, "UPDATE ttrss_labels2 SET
17 ${kind}_color = '$color' WHERE id = '$id'
18 AND owner_uid = " . $_SESSION["uid"]);
20 db_query($link, "UPDATE ttrss_labels2 SET
21 fg_color = '$fg', bg_color = '$bg' WHERE id = '$id'
22 AND owner_uid = " . $_SESSION["uid"]);
29 if ($subop == "color-reset") {
30 $ids = split(',', db_escape_string($_REQUEST["ids"]));
32 foreach ($ids as $id) {
33 db_query($link, "UPDATE ttrss_labels2 SET
34 fg_color = '', bg_color = '' WHERE id = '$id'
35 AND owner_uid = " . $_SESSION["uid"]);
40 if ($subop == "save") {
42 $id = db_escape_string($_REQUEST["id"]);
43 $caption = db_escape_string(trim($_REQUEST["value"]));
45 db_query($link, "BEGIN");
47 $result = db_query($link, "SELECT caption FROM ttrss_labels2
48 WHERE id = '$id' AND owner_uid = ". $_SESSION["uid"]);
50 if (db_num_rows($result) != 0) {
51 $old_caption = db_fetch_result($result, 0, "caption");
53 $result = db_query($link, "SELECT id FROM ttrss_labels2
54 WHERE caption = '$caption' AND owner_uid = ". $_SESSION["uid"]);
56 if (db_num_rows($result) == 0) {
58 $result = db_query($link, "UPDATE ttrss_labels2 SET
59 caption = '$caption' WHERE id = '$id' AND
60 owner_uid = " . $_SESSION["uid"]);
62 /* Update filters that reference label being renamed */
64 $old_caption = db_escape_string($old_caption);
66 db_query($link, "UPDATE ttrss_filters SET
67 action_param = '$caption' WHERE action_param = '$old_caption'
69 AND owner_uid = " . $_SESSION["uid"]);
71 print $_REQUEST["value"];
80 db_query($link, "COMMIT");
85 if ($subop == "remove") {
87 $ids = split(",", db_escape_string($_REQUEST["ids"]));
89 foreach ($ids as $id) {
90 label_remove($link, $id, $_SESSION["uid"]);
95 if ($subop == "add") {
97 $caption = db_escape_string($_REQUEST["caption"]);
101 if (label_create($link, $caption)) {
102 print T_sprintf("Created label <b>%s</b>", htmlspecialchars($caption));
110 set_pref($link, "_PREFS_ACTIVE_TAB", "labelConfig");
112 $sort = db_escape_string($_REQUEST["sort"]);
114 if (!$sort ||
$sort == "undefined") {
118 $label_search = db_escape_string($_REQUEST["search"]);
120 if (array_key_exists("search", $_REQUEST)) {
121 $_SESSION["prefs_label_search"] = $label_search;
123 $label_search = $_SESSION["prefs_label_search"];
126 print "<div class=\"feedEditSearch\">
127 <input id=\"label_search\" size=\"20\" type=\"search\"
128 onfocus=\"javascript:disableHotkeys();\"
129 onblur=\"javascript:enableHotkeys();\"
130 onchange=\"javascript:updateLabelList()\" value=\"$label_search\">
131 <input type=\"submit\" class=\"button\"
132 onclick=\"javascript:updateLabelList()\" value=\"".__('Search')."\">
135 print "<div class=\"prefGenericAddBox\">";
137 print"<input type=\"submit\" class=\"button\"
138 id=\"label_create_btn\"
139 onclick=\"return addLabel()\"
140 value=\"".__('Create label')."\"> ";
142 print "<input type=\"submit\" class=\"button\"
143 onclick=\"javascript:removeSelectedLabels()\" value=\"".__('Remove')."\">";
146 /* print " <input type=\"submit\" class=\"button\" disabled=\"true\"
147 onclick=\"labelColorSet('fg')\" value=\"".__('Fg')."\"> ";
148 print "<input type=\"submit\" class=\"button\" disabled=\"true\"
149 onclick=\"labelColorSet('bg')\" value=\"".__('Bg')."\"> "; */
150 print "<input type=\"submit\" class=\"button\"
151 onclick=\"labelColorReset()\" value=\"".__('Clear colors')."\">";
158 $label_search = split(" ", $label_search);
161 foreach ($label_search as $token) {
163 $token = trim($token);
164 array_push($tokens, "(UPPER(caption) LIKE UPPER('%$token%'))");
168 $label_search_query = "(" . join($tokens, " AND ") . ") AND ";
171 $label_search_query = "";
174 $result = db_query($link, "SELECT
180 owner_uid = ".$_SESSION["uid"]."
183 // print "<div id=\"infoBoxShadow\"><div id=\"infoBox\">PLACEHOLDER</div></div>";
185 if (db_num_rows($result) != 0) {
187 print "<p><table width=\"100%\" cellspacing=\"0\"
188 class=\"prefLabelList\" id=\"prefLabelList\">";
190 print "<tr><td class=\"selectPrompt\" colspan=\"8\">
192 <a href=\"javascript:selectPrefRows('label', true)\">".__('All')."</a>,
193 <a href=\"javascript:selectPrefRows('label', false)\">".__('None')."</a>
196 /* print "<tr class=\"title\">
197 <td width=\"5%\"> </td>
198 <td width=\"95%\"><a href=\"javascript:updateLabelList('caption')\">".__('Caption')."</a></td>
204 while ($line = db_fetch_assoc($result)) {
206 $class = ($lnum %
2) ?
"even" : "odd";
208 $label_id = $line["id"];
209 $this_row_id = "id=\"LILRR-$label_id\"";
211 print "<tr class=\"$class\" $this_row_id>";
213 $line["caption"] = htmlspecialchars($line["caption"]);
215 $fg_color = $line["fg_color"];
216 $bg_color = $line["bg_color"];
218 if (!$fg_color) $fg_color = "";
219 if (!$bg_color) $bg_color = "";
221 print "<td width='5%' align='center'><input
222 onclick='toggleSelectPrefRow(this, \"label\");'
223 type=\"checkbox\" id=\"LICHK-".$line["id"]."\"></td>";
229 print "<div class='labelColorIndicator' id='LICID-$id'
230 style='color : $fg_color; background-color : $bg_color'
231 title='".__('Click to change color')."'
232 onclick=\"colorPicker('$id', '$fg_color', '$bg_color')\">α";
233 print_color_picker($id);
237 print "<span class='prefsLabelEntry'
238 id=\"LILT-".$line["id"]."\">" . $line["caption"] .
253 if (!$label_search) {
254 print_warning(__('No labels defined.'));
256 print_warning(__('No matching labels found.'));
263 function print_color_picker($id) {
265 print "<div id=\"colorPicker-$id\"
266 onmouseover=\"colorPickerActive(true)\"
267 onmouseout=\"colorPickerActive(false)\"
268 class=\"colorPicker\" style='display : none'>";
270 $color_picker_pairs = array(
271 array('#ff0000', '#ffffff'),
272 array('#009000', '#ffffff'),
273 array('#0000ff', '#ffffff'),
274 array('#ff00ff', '#ffffff'),
275 array('#009090', '#ffffff'),
277 array('#ffffff', '#ff0000'),
278 array('#000000', '#00ff00'),
279 array('#ffffff', '#0000ff'),
280 array('#ffffff', '#ff00ff'),
281 array('#000000', '#00ffff'),
283 array('#7b07e1', '#ffffff'),
284 array('#0091b4', '#ffffff'),
285 array('#00aa71', '#ffffff'),
286 array('#7d9e01', '#ffffff'),
287 array('#e14a00', '#ffffff'),
289 array('#ffffff', '#7b07e1'),
290 array('#ffffff', '#00b5e1'),
291 array('#ffffff', '#00e196'),
292 array('#ffffff', '#b3e100'),
293 array('#ffffff', '#e14a00'),
295 array('#000000', '#ffffff'),
296 array('#ffffff', '#000000'),
297 array('#ffffff', '#909000'),
298 array('#063064', '#fff7d5'),
299 array('#ffffff', '#4E4E90'),
302 foreach ($color_picker_pairs as $c) {
306 print "<div class='colorPickerEntry'
307 style='color : $fg_color; background-color : $bg_color;'
308 onclick=\"colorPickerDo('$id', '$fg_color', '$bg_color')\">α</div>";
312 print "<br clear='both'>";
314 print "<br/><b>".__('custom color:')."</b>";
315 print "<div class=\"ccPrompt\" onclick=\"labelColorAsk('$id', 'fg')\">".__("foreground")."</div>";
316 print "<div class=\"ccPrompt\" onclick=\"labelColorAsk('$id', 'bg')\">".__("background")."</div>";