[tt-rss.git] / modules / pref-labels.php

<?php
	function module_pref_labels($link) {

		$subop = $_REQUEST["subop"];

		if ($subop == "color-set") {
			$kind = db_escape_string($_REQUEST["kind"]);
			$ids = split(',', db_escape_string($_REQUEST["ids"]));
			$color = db_escape_string($_REQUEST["color"]);
			$fg = db_escape_string($_REQUEST["fg"]);
			$bg = db_escape_string($_REQUEST["bg"]);

			foreach ($ids as $id) {

				if ($kind == "fg" || $kind == "bg") {
					db_query($link, "UPDATE ttrss_labels2 SET
						${kind}_color = '$color' WHERE id = '$id'
						AND owner_uid = " . $_SESSION["uid"]);			
				} else {
					db_query($link, "UPDATE ttrss_labels2 SET
						fg_color = '$fg', bg_color = '$bg' WHERE id = '$id'
						AND owner_uid = " . $_SESSION["uid"]);			
				}
			}

			return;
		}

		if ($subop == "color-reset") {
			$ids = split(',', db_escape_string($_REQUEST["ids"]));

			foreach ($ids as $id) {
				db_query($link, "UPDATE ttrss_labels2 SET
					fg_color = '', bg_color = '' WHERE id = '$id'
					AND owner_uid = " . $_SESSION["uid"]);			
			}

		}

		if ($subop == "save") {

			$id = db_escape_string($_REQUEST["id"]);
			$caption = db_escape_string(trim($_REQUEST["value"]));

			db_query($link, "BEGIN");

			$result = db_query($link, "SELECT caption FROM ttrss_labels2
				WHERE id = '$id' AND owner_uid = ". $_SESSION["uid"]);

			if (db_num_rows($result) != 0) {
				$old_caption = db_fetch_result($result, 0, "caption");

				$result = db_query($link, "SELECT id FROM ttrss_labels2
					WHERE caption = '$caption' AND owner_uid = ". $_SESSION["uid"]);

				if (db_num_rows($result) == 0) {
					if ($caption) {
						$result = db_query($link, "UPDATE ttrss_labels2 SET
							caption = '$caption' WHERE id = '$id' AND
							owner_uid = " . $_SESSION["uid"]);

						/* Update filters that reference label being renamed */

						$old_caption = db_escape_string($old_caption);

						db_query($link, "UPDATE ttrss_filters SET
							action_param = '$caption' WHERE action_param = '$old_caption'
							AND action_id = 7
							AND owner_uid = " . $_SESSION["uid"]);

						print $_REQUEST["value"];
					} else {
						print $old_caption;
					}
				} else {
					print $old_caption;
				}
			}

			db_query($link, "COMMIT");

			return;
		}

		if ($subop == "remove") {

			$ids = split(",", db_escape_string($_REQUEST["ids"]));

			foreach ($ids as $id) {
				label_remove($link, $id, $_SESSION["uid"]);
			}

		}

		if ($subop == "add") {

			$caption = db_escape_string($_REQUEST["caption"]);

			if ($caption) {

				if (label_create($link, $caption)) {
					print T_sprintf("Created label <b>%s</b>", htmlspecialchars($caption));
				}

			}

			return;
		}

		set_pref($link, "_PREFS_ACTIVE_TAB", "labelConfig");

		$sort = db_escape_string($_REQUEST["sort"]);

		if (!$sort || $sort == "undefined") {
			$sort = "caption";
		}

		$label_search = db_escape_string($_REQUEST["search"]);

		if (array_key_exists("search", $_REQUEST)) {
			$_SESSION["prefs_label_search"] = $label_search;
		} else {
			$label_search = $_SESSION["prefs_label_search"];
		}

		print "<div class=\"feedEditSearch\">
			<input id=\"label_search\" size=\"20\" type=\"search\"
				onfocus=\"javascript:disableHotkeys();\" 
				onblur=\"javascript:enableHotkeys();\"
				onchange=\"javascript:updateLabelList()\" value=\"$label_search\">
			<input type=\"submit\" class=\"button\" 
				onclick=\"javascript:updateLabelList()\" value=\"".__('Search')."\">
			</div>";

		print "<div class=\"prefGenericAddBox\">";

		print"<input type=\"submit\" class=\"button\" 
			id=\"label_create_btn\"
			onclick=\"return addLabel()\" 
			value=\"".__('Create label')."\"> ";

			print "<input type=\"submit\" class=\"button\"
				onclick=\"javascript:removeSelectedLabels()\" value=\"".__('Remove')."\">";

			print "&nbsp;";
/*			print "&nbsp;<input type=\"submit\" class=\"button\" disabled=\"true\"
				onclick=\"labelColorSet('fg')\" value=\"".__('Fg')."\">&nbsp;";
			print "<input type=\"submit\" class=\"button\" disabled=\"true\"
				onclick=\"labelColorSet('bg')\" value=\"".__('Bg')."\">&nbsp;"; */
			print "<input type=\"submit\" class=\"button\"
				onclick=\"labelColorReset()\" value=\"".__('Clear colors')."\">";


		print "</div>";

		if ($label_search) {

			$label_search = split(" ", $label_search);
			$tokens = array();

			foreach ($label_search as $token) {

				$token = trim($token);
				array_push($tokens, "(UPPER(caption) LIKE UPPER('%$token%'))");

			}

			$label_search_query = "(" . join($tokens, " AND ") . ") AND ";
			
		} else {
			$label_search_query = "";
		}

		$result = db_query($link, "SELECT 
				*
			FROM 
				ttrss_labels2
			WHERE 
				$label_search_query
				owner_uid = ".$_SESSION["uid"]."
			ORDER BY $sort");

//		print "<div id=\"infoBoxShadow\"><div id=\"infoBox\">PLACEHOLDER</div></div>";

		if (db_num_rows($result) != 0) {

			print "<p><table width=\"100%\" cellspacing=\"0\" 
				class=\"prefLabelList\" id=\"prefLabelList\">";

			print "<tr><td class=\"selectPrompt\" colspan=\"8\">
				".__('Select:')." 
					<a href=\"javascript:selectPrefRows('label', true)\">".__('All')."</a>,
					<a href=\"javascript:selectPrefRows('label', false)\">".__('None')."</a>
				</td</tr>";

/*			print "<tr class=\"title\">
						<td width=\"5%\">&nbsp;</td>
						<td width=\"95%\"><a href=\"javascript:updateLabelList('caption')\">".__('Caption')."</a></td>
						</td>
						</tr>"; */
			
			$lnum = 0;
			
			while ($line = db_fetch_assoc($result)) {
	
				$class = ($lnum % 2) ? "even" : "odd";
	
				$label_id = $line["id"];
				$this_row_id = "id=\"LILRR-$label_id\"";

				print "<tr class=\"$class\" $this_row_id>";
	
				$line["caption"] = htmlspecialchars($line["caption"]);

				$fg_color = $line["fg_color"];
				$bg_color = $line["bg_color"];

				if (!$fg_color) $fg_color = "";
				if (!$bg_color) $bg_color = "";

				print "<td width='5%' align='center'><input 
					onclick='toggleSelectPrefRow(this, \"label\");' 
					type=\"checkbox\" id=\"LICHK-".$line["id"]."\"></td>";
	
				$id = $line['id'];

				print "<td>";

				print "<div class='labelColorIndicator' id='LICID-$id' 
					style='color : $fg_color; background-color : $bg_color'
					title='".__('Click to change color')."'
					onclick=\"colorPicker('$id', '$fg_color', '$bg_color')\">&alpha;";
				print_color_picker($id);
				print "</div>";


				print "<span class='prefsLabelEntry' 
					id=\"LILT-".$line["id"]."\">" . $line["caption"] . 
					"</span>";

				print "</td>";

				print "</tr>";
	
				++$lnum;
			}

			print "</table>";
	

		} else {
			print "<p>";
			if (!$label_search) {
				print_warning(__('No labels defined.'));
			} else {
				print_warning(__('No matching labels found.'));
			}
			print "</p>";

		}
	}

	function print_color_picker($id) {

		print "<div id=\"colorPicker-$id\" 
			onmouseover=\"colorPickerActive(true)\"
			onmouseout=\"colorPickerActive(false)\"
			class=\"colorPicker\" style='display : none'>";

		$color_picker_pairs = array(
			array('#ff0000', '#ffffff'),
			array('#009000', '#ffffff'),
			array('#0000ff', '#ffffff'),	
			array('#ff00ff', '#ffffff'),				
			array('#009090', '#ffffff'),

			array('#ffffff', '#ff0000'),
			array('#000000', '#00ff00'),
			array('#ffffff', '#0000ff'),
			array('#ffffff', '#ff00ff'),
			array('#000000', '#00ffff'),

			array('#7b07e1', '#ffffff'),
			array('#0091b4', '#ffffff'),
			array('#00aa71', '#ffffff'),
			array('#7d9e01', '#ffffff'),
			array('#e14a00', '#ffffff'),

			array('#ffffff', '#7b07e1'),
			array('#ffffff', '#00b5e1'),
			array('#ffffff', '#00e196'),
			array('#ffffff', '#b3e100'),
			array('#ffffff', '#e14a00'),

			array('#000000', '#ffffff'),
			array('#ffffff', '#000000'),
			array('#ffffff', '#909000'),
			array('#063064', '#fff7d5'),
			array('#ffffff', '#4E4E90'),
		);

		foreach ($color_picker_pairs as $c) { 
			$fg_color = $c[0];
			$bg_color = $c[1];

			print "<div class='colorPickerEntry' 
				style='color : $fg_color; background-color : $bg_color;'
				onclick=\"colorPickerDo('$id', '$fg_color', '$bg_color')\">&alpha;</div>";

		}

		print "<br clear='both'>";

		print "<br/><b>".__('custom color:')."</b>";
		print "<div class=\"ccPrompt\" onclick=\"labelColorAsk('$id', 'fg')\">".__("foreground")."</div>";
		print "<div class=\"ccPrompt\" onclick=\"labelColorAsk('$id', 'bg')\">".__("background")."</div>";

		print "</div>";
	}

?>
Commit	Line	Data
ef8be8ea	1	<?php
ef8be8ea	2	function module_pref_labels($link) {
ef8be8ea	3
b4e75b2a	4	$subop = $_REQUEST["subop"];
ef8be8ea	5
b8776a07 AD	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"]);
b6ba48c1 AD	10	$fg = db_escape_string($_REQUEST["fg"]);
b6ba48c1 AD	11	$bg = db_escape_string($_REQUEST["bg"]);
b8776a07 AD	12
b8776a07 AD	13	foreach ($ids as $id) {
b6ba48c1 AD	14
	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"]);
	19	} else {
	20	db_query($link, "UPDATE ttrss_labels2 SET
	21	fg_color = '$fg', bg_color = '$bg' WHERE id = '$id'
	22	AND owner_uid = " . $_SESSION["uid"]);
	23	}
b8776a07 AD	24	}
b8776a07 AD	25
aec9df48 AD	26	return;
	27	}
	28
	29	if ($subop == "color-reset") {
	30	$ids = split(',', db_escape_string($_REQUEST["ids"]));
	31
	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"]);
	36	}
	37
b8776a07 AD	38	}
b8776a07 AD	39
ceb30ba4	40	if ($subop == "save") {
071ec48f	41
ceb30ba4	42	$id = db_escape_string($_REQUEST["id"]);
9c5e85fe	43	$caption = db_escape_string(trim($_REQUEST["value"]));
071ec48f	44
ceb30ba4	45	db_query($link, "BEGIN");
10fa6615	46
ceb30ba4 AD	47	$result = db_query($link, "SELECT caption FROM ttrss_labels2
ceb30ba4 AD	48	WHERE id = '$id' AND owner_uid = ". $_SESSION["uid"]);
ef8be8ea	49
ceb30ba4 AD	50	if (db_num_rows($result) != 0) {
ceb30ba4 AD	51	$old_caption = db_fetch_result($result, 0, "caption");
a4919a16	52
ceb30ba4 AD	53	$result = db_query($link, "SELECT id FROM ttrss_labels2
ceb30ba4 AD	54	WHERE caption = '$caption' AND owner_uid = ". $_SESSION["uid"]);
ef8be8ea	55
ceb30ba4 AD	56	if (db_num_rows($result) == 0) {
	57	if ($caption) {
	58	$result = db_query($link, "UPDATE ttrss_labels2 SET
	59	caption = '$caption' WHERE id = '$id' AND
	60	owner_uid = " . $_SESSION["uid"]);
ef8be8ea	61
ceb30ba4	62	/* Update filters that reference label being renamed */
ef8be8ea	63
7a13338b AD	64	$old_caption = db_escape_string($old_caption);
7a13338b AD	65
ceb30ba4 AD	66	db_query($link, "UPDATE ttrss_filters SET
	67	action_param = '$caption' WHERE action_param = '$old_caption'
	68	AND action_id = 7
	69	AND owner_uid = " . $_SESSION["uid"]);
ef8be8ea	70
9c5e85fe	71	print $_REQUEST["value"];
625acd1c AD	72	} else {
625acd1c AD	73	print $old_caption;
ceb30ba4 AD	74	}
	75	} else {
	76	print $old_caption;
ef8be8ea	77	}
ef8be8ea AD	78	}
ef8be8ea AD	79
ceb30ba4	80	db_query($link, "COMMIT");
ef8be8ea AD	81
	82	return;
	83	}
	84
ef8be8ea AD	85	if ($subop == "remove") {
ef8be8ea AD	86
b4e75b2a	87	$ids = split(",", db_escape_string($_REQUEST["ids"]));
ef8be8ea	88
f6f7817d	89	foreach ($ids as $id) {
1380f8ee	90	label_remove($link, $id, $_SESSION["uid"]);
ef8be8ea	91	}
f6f7817d	92
ef8be8ea AD	93	}
	94
	95	if ($subop == "add") {
ef8be8ea	96
b4e75b2a	97	$caption = db_escape_string($_REQUEST["caption"]);
ef8be8ea	98
ceb30ba4	99	if ($caption) {
caf1f12f	100
6b2ee18d AD	101	if (label_create($link, $caption)) {
6b2ee18d AD	102	print T_sprintf("Created label <b>%s</b>", htmlspecialchars($caption));
ceb30ba4	103	}
6b2ee18d	104
5e6f933a AD	105	}
	106
	107	return;
ef8be8ea AD	108	}
ef8be8ea AD	109
fe8d2059 AD	110	set_pref($link, "_PREFS_ACTIVE_TAB", "labelConfig");
fe8d2059 AD	111
b4e75b2a	112	$sort = db_escape_string($_REQUEST["sort"]);
ef8be8ea AD	113
ef8be8ea AD	114	if (!$sort \|\| $sort == "undefined") {
ceb30ba4	115	$sort = "caption";
ef8be8ea AD	116	}
ef8be8ea AD	117
b4e75b2a	118	$label_search = db_escape_string($_REQUEST["search"]);
112d2aec	119
b4e75b2a	120	if (array_key_exists("search", $_REQUEST)) {
112d2aec AD	121	$_SESSION["prefs_label_search"] = $label_search;
	122	} else {
	123	$label_search = $_SESSION["prefs_label_search"];
	124	}
	125
	126	print "<div class=\"feedEditSearch\">
	127	<input id=\"label_search\" size=\"20\" type=\"search\"
4cf6fc6a AD	128	onfocus=\"javascript:disableHotkeys();\"
4cf6fc6a AD	129	onblur=\"javascript:enableHotkeys();\"
112d2aec AD	130	onchange=\"javascript:updateLabelList()\" value=\"$label_search\">
	131	<input type=\"submit\" class=\"button\"
	132	onclick=\"javascript:updateLabelList()\" value=\"".__('Search')."\">
112d2aec	133	</div>";
0d32b41e	134
ef8be8ea AD	135	print "<div class=\"prefGenericAddBox\">";
	136
	137	print"<input type=\"submit\" class=\"button\"
	138	id=\"label_create_btn\"
ceb30ba4	139	onclick=\"return addLabel()\"
1e5548db AD	140	value=\"".__('Create label')."\"> ";
	141
	142	print "<input type=\"submit\" class=\"button\"
	143	onclick=\"javascript:removeSelectedLabels()\" value=\"".__('Remove')."\">";
	144
	145	print " ";
	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')."\">";
	152
	153
	154	print "</div>";
ef8be8ea	155
112d2aec	156	if ($label_search) {
1638fc4e AD	157
	158	$label_search = split(" ", $label_search);
	159	$tokens = array();
	160
	161	foreach ($label_search as $token) {
	162
	163	$token = trim($token);
	164	array_push($tokens, "(UPPER(caption) LIKE UPPER('%$token%'))");
	165
	166	}
	167
	168	$label_search_query = "(" . join($tokens, " AND ") . ") AND ";
	169
112d2aec AD	170	} else {
	171	$label_search_query = "";
	172	}
	173
ef8be8ea	174	$result = db_query($link, "SELECT
2eb9c95c	175	*
ef8be8ea	176	FROM
ceb30ba4	177	ttrss_labels2
ef8be8ea	178	WHERE
112d2aec	179	$label_search_query
ef8be8ea AD	180	owner_uid = ".$_SESSION["uid"]."
	181	ORDER BY $sort");
	182
	183	// print "<div id=\"infoBoxShadow\"><div id=\"infoBox\">PLACEHOLDER</div></div>";
	184
	185	if (db_num_rows($result) != 0) {
	186
ef8be8ea AD	187	print "<p><table width=\"100%\" cellspacing=\"0\"
	188	class=\"prefLabelList\" id=\"prefLabelList\">";
	189
	190	print "<tr><td class=\"selectPrompt\" colspan=\"8\">
e8d0177d AD	191	".__('Select:')."
	192	<a href=\"javascript:selectPrefRows('label', true)\">".__('All')."</a>,
	193	<a href=\"javascript:selectPrefRows('label', false)\">".__('None')."</a>
ef8be8ea AD	194	</td</tr>";
ef8be8ea AD	195
4d23f96e	196	/* print "<tr class=\"title\">
ef8be8ea	197	<td width=\"5%\"> </td>
4d23f96e	198	<td width=\"95%\"><a href=\"javascript:updateLabelList('caption')\">".__('Caption')."</a></td>
ef8be8ea	199	</td>
4d23f96e	200	</tr>"; */
ef8be8ea AD	201
	202	$lnum = 0;
	203
	204	while ($line = db_fetch_assoc($result)) {
	205
	206	$class = ($lnum % 2) ? "even" : "odd";
	207
	208	$label_id = $line["id"];
ceb30ba4 AD	209	$this_row_id = "id=\"LILRR-$label_id\"";
ceb30ba4 AD	210
ef8be8ea AD	211	print "<tr class=\"$class\" $this_row_id>";
ef8be8ea AD	212
ceb30ba4	213	$line["caption"] = htmlspecialchars($line["caption"]);
2eb9c95c AD	214
	215	$fg_color = $line["fg_color"];
	216	$bg_color = $line["bg_color"];
	217
aec9df48 AD	218	if (!$fg_color) $fg_color = "";
aec9df48 AD	219	if (!$bg_color) $bg_color = "";
2eb9c95c	220
4d23f96e	221	print "<td width='5%' align='center'><input
ceb30ba4	222	onclick='toggleSelectPrefRow(this, \"label\");'
ef8be8ea AD	223	type=\"checkbox\" id=\"LICHK-".$line["id"]."\"></td>";
ef8be8ea AD	224
76b2bc65	225	$id = $line['id'];
c17d514b	226
aec9df48 AD	227	print "<td>";
	228
	229	print "<div class='labelColorIndicator' id='LICID-$id'
2eb9c95c	230	style='color : $fg_color; background-color : $bg_color'
7daf349a	231	title='".__('Click to change color')."'
b6ba48c1 AD	232	onclick=\"colorPicker('$id', '$fg_color', '$bg_color')\">α";
	233	print_color_picker($id);
	234	print "</div>";
c17d514b	235
c17d514b	236
aec9df48	237	print "<span class='prefsLabelEntry'
2eb9c95c	238	id=\"LILT-".$line["id"]."\">" . $line["caption"] .
c17d514b AD	239	"</span>";
c17d514b AD	240
76b2bc65	241	print "</td>";
ef8be8ea AD	242
	243	print "</tr>";
	244
	245	++$lnum;
	246	}
a5bd7bf0	247
ef8be8ea	248	print "</table>";
ef8be8ea	249
ef8be8ea AD	250
ef8be8ea AD	251	} else {
a5bd7bf0 AD	252	print "<p>";
a5bd7bf0 AD	253	if (!$label_search) {
cea04d61	254	print_warning(__('No labels defined.'));
a5bd7bf0	255	} else {
cea04d61	256	print_warning(__('No matching labels found.'));
a5bd7bf0 AD	257	}
	258	print "</p>";
	259
ef8be8ea AD	260	}
ef8be8ea AD	261	}
1d4a2918 AD	262
	263	function print_color_picker($id) {
	264
	265	print "<div id=\"colorPicker-$id\"
	266	onmouseover=\"colorPickerActive(true)\"
	267	onmouseout=\"colorPickerActive(false)\"
	268	class=\"colorPicker\" style='display : none'>";
	269
	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'),
	276
	277	array('#ffffff', '#ff0000'),
	278	array('#000000', '#00ff00'),
	279	array('#ffffff', '#0000ff'),
	280	array('#ffffff', '#ff00ff'),
	281	array('#000000', '#00ffff'),
	282
	283	array('#7b07e1', '#ffffff'),
	284	array('#0091b4', '#ffffff'),
	285	array('#00aa71', '#ffffff'),
	286	array('#7d9e01', '#ffffff'),
	287	array('#e14a00', '#ffffff'),
	288
	289	array('#ffffff', '#7b07e1'),
	290	array('#ffffff', '#00b5e1'),
	291	array('#ffffff', '#00e196'),
	292	array('#ffffff', '#b3e100'),
	293	array('#ffffff', '#e14a00'),
	294
	295	array('#000000', '#ffffff'),
	296	array('#ffffff', '#000000'),
	297	array('#ffffff', '#909000'),
	298	array('#063064', '#fff7d5'),
	299	array('#ffffff', '#4E4E90'),
	300	);
	301
	302	foreach ($color_picker_pairs as $c) {
	303	$fg_color = $c[0];
	304	$bg_color = $c[1];
	305
	306	print "<div class='colorPickerEntry'
	307	style='color : $fg_color; background-color : $bg_color;'
	308	onclick=\"colorPickerDo('$id', '$fg_color', '$bg_color')\">α</div>";
	309
	310	}
	311
	312	print "<br clear='both'>";
	313
	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>";
	317
	318	print "</div>";
	319	}
	320
ef8be8ea	321	?>