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

<?php
	function module_pref_filters($link) {
		$subop = $_GET["subop"];
		$quiet = $_GET["quiet"];

		if ($subop == "edit") {

			$filter_id = db_escape_string($_GET["id"]);

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

			$reg_exp = htmlspecialchars(db_fetch_result($result, 0, "reg_exp"));
			$filter_type = db_fetch_result($result, 0, "filter_type");
			$feed_id = db_fetch_result($result, 0, "feed_id");
			$action_id = db_fetch_result($result, 0, "action_id");
			$action_param = db_fetch_result($result, 0, "action_param");
			$filter_param = db_fetch_result($result, 0, "filter_param");

			$enabled = sql_bool_to_bool(db_fetch_result($result, 0, "enabled"));
			$inverse = sql_bool_to_bool(db_fetch_result($result, 0, "inverse"));

			print "<div id=\"infoBoxTitle\">".__('Filter Editor')."</div>";
			print "<div class=\"infoBoxContents\">";

			print "<form id=\"filter_edit_form\" onsubmit='return false'>";

			print "<input type=\"hidden\" name=\"op\" value=\"pref-filters\">";
			print "<input type=\"hidden\" name=\"id\" value=\"$filter_id\">";
			print "<input type=\"hidden\" name=\"subop\" value=\"editSave\">"; 
			
			$result = db_query($link, "SELECT id,description 
				FROM ttrss_filter_types ORDER BY description");
	
			$filter_types = array();
	
			while ($line = db_fetch_assoc($result)) {
				//array_push($filter_types, $line["description"]);
				$filter_types[$line["id"]] = __($line["description"]);
			}

			print "<div class=\"dlgSec\">".__("Match")."</div>";

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

			if ($filter_type != 5) {
				$date_ops_invisible = 'style=\"display : none\"';
			}

			print "<span id=\"filter_dlg_date_mod_box\" $date_ops_invisible>";
			print __("Date") . " ";

			$filter_params = array(
				"before" => __("before"),
				"after" => __("after"));

			print_select_hash("filter_date_modifier", $filter_param,
				$filter_params);

			print "&nbsp;</span>";

			print "<input onkeypress=\"return filterCR(event, filterEditSave)\"
					 onkeyup=\"toggleSubmitNotEmpty(this, 'infobox_submit')\"
					 onchange=\"toggleSubmitNotEmpty(this, 'infobox_submit')\"
					 name=\"reg_exp\" size=\"30\" value=\"$reg_exp\">";

			print "<span id=\"filter_dlg_date_chk_box\" $date_ops_invisible>";			
			print "&nbsp;<input class=\"button\"
				type=\"submit\" onclick=\"return filterDlgCheckDate()\" 
				value=\"".__('Check it')."\">";
			print "</span>";

			print "<br/> " . __("on field") . " ";
			print_select_hash("filter_type", $filter_type, $filter_types,
				'onchange="filterDlgCheckType(this)"');

			print "<br/>";

			print __("in") . " ";
			print_feed_select($link, "feed_id", $feed_id);

			print "</div>";

			print "<div class=\"dlgSec\">".__("Perform Action")."</div>";

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

			print "<select name=\"action_id\"
				onchange=\"filterDlgCheckAction(this)\">";
	
			$result = db_query($link, "SELECT id,description FROM ttrss_filter_actions 
				ORDER BY name");

			while ($line = db_fetch_assoc($result)) {
				$is_sel = ($line["id"] == $action_id) ? "selected" : "";			
				printf("<option value='%d' $is_sel>%s</option>", $line["id"], __($line["description"]));
			}
	
			print "</select>";

			$param_hidden = ($action_id == 4 || $action_id == 6) ? "" : "display : none";

			print "<span id=\"filter_dlg_param_box\" style=\"$param_hidden\">";
			print " " . __("with parameters:") . " ";
			print "<input size=\"20\"
					onkeypress=\"return filterCR(event, filterEditSave)\"		
					name=\"action_param\" value=\"$action_param\">";
			print "</span>";

			print "&nbsp;"; // tiny layout hack

			print "</div>";

			print "<div class=\"dlgSec\">".__("Options")."</div>";
			print "<div class=\"dlgSecCont\">";

			print "<div style=\"line-height : 100%\">";

			if ($enabled) {
				$checked = "checked";
			} else {
				$checked = "";
			}

			print "<input type=\"checkbox\" name=\"enabled\" id=\"enabled\" $checked>
					<label for=\"enabled\">".__('Enabled')."</label><br/>";

			if ($inverse) {
				$checked = "checked";
			} else {
				$checked = "";
			}

			print "<input type=\"checkbox\" name=\"inverse\" id=\"inverse\" $checked>
				<label for=\"inverse\">".__('Inverse match')."</label>";

			print "</div>";
			print "</div>";

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

			$reg_exp = htmlspecialchars($reg_exp, ENT_QUOTES); // second escaping seems to be needed for javascript

			print "<div style=\"float : left\">";
			print "<input type=\"submit\" 
				class=\"button\" onclick='return removeFilter($filter_id, \"$reg_exp\")' 
				value=\"".__('Remove')."\"> ";
			print "</div>";

			print "<input type=\"submit\" 
				id=\"infobox_submit\"
				class=\"button\" onclick=\"return filterEditSave()\" 
				value=\"".__('Save')."\"> ";

			print "<input class=\"button\"
				type=\"submit\" onclick=\"return filterEditCancel()\" 
				value=\"".__('Cancel')."\">";

			print "</div>";

			return;
		}


		if ($subop == "editSave") {

			$reg_exp = db_escape_string(trim($_GET["reg_exp"]));
			$filter_type = db_escape_string(trim($_GET["filter_type"]));
			$filter_id = db_escape_string($_GET["id"]);
			$feed_id = db_escape_string($_GET["feed_id"]);
			$action_id = db_escape_string($_GET["action_id"]); 
			$action_param = db_escape_string($_GET["action_param"]); 
			$enabled = checkbox_to_sql_bool(db_escape_string($_GET["enabled"]));
			$inverse = checkbox_to_sql_bool(db_escape_string($_GET["inverse"]));

			# for the time being, no other filters use params anyway...
			$filter_param = db_escape_string($_GET["filter_date_modifier"]);

			if (!$feed_id) {
				$feed_id = 'NULL';
			} else {
				$feed_id = sprintf("'%s'", db_escape_string($feed_id));
			}
			
			$result = db_query($link, "UPDATE ttrss_filters SET 
					reg_exp = '$reg_exp', 
					feed_id = $feed_id,
					action_id = '$action_id',
					filter_type = '$filter_type',
					enabled = $enabled,
					inverse = $inverse,
					action_param = '$action_param',
					filter_param = '$filter_param'
					WHERE id = '$filter_id' AND owner_uid = " . $_SESSION["uid"]);

			if (db_affected_rows($link, $result) != 0) {
				print_notice(T_sprintf("Saved filter <b>%s</b>", htmlspecialchars($reg_exp)));
			}

		}

		if ($subop == "remove") {

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

			foreach ($ids as $id) {
				db_query($link, "DELETE FROM ttrss_filters WHERE id = '$id' AND owner_uid = ". $_SESSION["uid"]);
			}
		}

		if ($subop == "add") {
		
			$regexp = db_escape_string(trim($_GET["reg_exp"]));
			$filter_type = db_escape_string(trim($_GET["filter_type"]));
			$feed_id = db_escape_string($_GET["feed_id"]);
			$action_id = db_escape_string($_GET["action_id"]); 
			$action_param = db_escape_string($_GET["action_param"]); 
			$inverse = checkbox_to_sql_bool(db_escape_string($_GET["inverse"]));

			# for the time being, no other filters use params anyway...
			$filter_param = db_escape_string($_GET["filter_date_modifier"]);

			if (!$regexp) return;

			if (!$feed_id) {
				$feed_id = 'NULL';
			} else {
				$feed_id = sprintf("'%s'", db_escape_string($feed_id));
			}

			$result = db_query($link,
				"INSERT INTO ttrss_filters (reg_exp,filter_type,owner_uid,feed_id,
					action_id, action_param, inverse, filter_param) 
				VALUES 
					('$regexp', '$filter_type','".$_SESSION["uid"]."', 
						$feed_id, '$action_id', '$action_param', $inverse, '$filter_param')");

			if (db_affected_rows($link, $result) != 0) {
				print T_sprintf("Created filter <b>%s</b>", htmlspecialchars($regexp));
			}

			return;
		}

		if ($quiet) return;

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

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

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

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

		$result = db_query($link, "SELECT id,description 
			FROM ttrss_filter_types ORDER BY description");

		$filter_types = array();

		while ($line = db_fetch_assoc($result)) {
			//array_push($filter_types, $line["description"]);
			$filter_types[$line["id"]] = $line["description"];
		}


		$filter_search = db_escape_string($_GET["search"]);

		if (array_key_exists("search", $_GET)) {
			$_SESSION["prefs_filter_search"] = $filter_search;
		} else {
			$filter_search = $_SESSION["prefs_filter_search"];
		}

		print "<div class=\"feedEditSearch\">
			<input id=\"filter_search\" size=\"20\" type=\"search\"
				onfocus=\"javascript:disableHotkeys();\" 
				onblur=\"javascript:enableHotkeys();\"
				onchange=\"javascript:updateFilterList()\" value=\"$filter_search\">
			<input type=\"submit\" class=\"button\" 
			onclick=\"javascript:updateFilterList()\" value=\"".__('Search')."\">
			<p<a class='helpLinkPic' href=\"javascript:displayHelpInfobox(2)\">
			<img src='images/sign_quest.gif'></a></p>
			</div>";


		print "<input type=\"submit\" 
			class=\"button\" 
			onclick=\"return displayDlg('quickAddFilter', false)\" 
			id=\"create_filter_btn\"
			value=\"".__('Create filter')."\">"; 

		print "&nbsp;";

		print "<input type=\"submit\" 
			class=\"button\" 
			onclick=\"rescore_all_feeds()\" 
			value=\"".__('Rescore articles')."\">"; 

		if ($filter_search) {
			$filter_search = db_escape_string($filter_search);
			$filter_search_query = "(
				UPPER(ttrss_filter_actions.description) LIKE UPPER('%$filter_search%') OR 
				UPPER(reg_exp) LIKE UPPER('%$filter_search%') OR 
				UPPER(ttrss_feeds.title) LIKE UPPER('%$filter_search%') OR
				UPPER(ttrss_filter_types.description) LIKE UPPER('%$filter_search%')) AND";
		} else {
			$filter_search_query = "";
		}

		$result = db_query($link, "SELECT 
				ttrss_filters.id AS id,reg_exp,
				ttrss_filter_types.name AS filter_type_name,
				ttrss_filter_types.description AS filter_type_descr,
				enabled,
				inverse,
				feed_id,
				filter_param,
				filter_type,
				ttrss_filter_actions.description AS action_description,
				ttrss_feeds.title AS feed_title,
				ttrss_filter_actions.name AS action_name,
				ttrss_filters.action_param AS action_param
			FROM 
				ttrss_filter_types,ttrss_filter_actions,ttrss_filters LEFT JOIN
					ttrss_feeds ON (ttrss_filters.feed_id = ttrss_feeds.id)
			WHERE
				filter_type = ttrss_filter_types.id AND
				$filter_search_query
				ttrss_filter_actions.id = action_id AND
				ttrss_filters.owner_uid = ".$_SESSION["uid"]."
			ORDER by action_description, $sort");

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

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

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

			$lnum = 0;

			$cur_action_description = "";

			while ($line = db_fetch_assoc($result)) {
	
				$class = ($lnum % 2) ? "even" : "odd";
	
				$filter_id = $line["id"];
				$edit_filter_id = $_GET["id"];

				$enabled = sql_bool_to_bool($line["enabled"]);
				$inverse = sql_bool_to_bool($line["inverse"]);

				if ($subop == "edit" && $filter_id != $edit_filter_id) {
					$class .= "Grayed";
					$this_row_id = "";
				} else {
					$this_row_id = "id=\"FILRR-$filter_id\"";
				}

				$line["filter_type_descr"] = __($line["filter_type_descr"]);
				$line["action_description"] = __($line["action_description"]);

				if ($line["action_description"] != $cur_action_description) {
					$cur_action_description = $line["action_description"];

					print "<tr><td class='filterEditCat' colspan='6'>$cur_action_description</td></tr>";

					print "<tr class=\"title\">
						<td align='center' width=\"5%\">&nbsp;</td>
						<td width=\"20%\"><a href=\"javascript:updateFilterList('reg_exp')\">".__('Match')."</a></td>
						<td width=\"\"><a href=\"javascript:updateFilterList('feed_title')\">".__('Feed')."</a></td>
						<td width=\"20%\"><a href=\"javascript:updateFilterList('filter_type')\">".__('Field')."</a></td>
						<td width=\"20%\"><a href=\"javascript:updateFilterList('action_param')\">".__('Params')."</a></td>"; 

				}

				print "<tr class=\"$class\" $this_row_id>";
	
				$line["reg_exp"] = htmlspecialchars($line["reg_exp"]);
	
				if (!$line["feed_title"]) $line["feed_title"] = __("All feeds");

				if (!$line["action_param"]) {
					$line["action_param"] = "&mdash;";
				} else if ($line["action_name"] == "score") {

					$score_pic = get_score_pic($line["action_param"]);

					$score_pic = "<img class='hlScorePic' src=\"images/$score_pic\">";

					$line["action_param"] = "$score_pic " . $line["action_param"];

				}

				$line["feed_title"] = htmlspecialchars($line["feed_title"]);

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

				$filter_params = array(
					"before" => __("before"),
					"after" => __("after"));
	
				if ($line["filter_type"] == 5) {

					if (!strtotime($line["reg_exp"])) {
						$line["reg_exp"] = "<span class=\"filterDateError\">" . 
							$line["reg_exp"] . "</span>";
					}

					$line["reg_exp"] = __("Date") . " " . 
						$filter_params[$line['filter_param']] . " " .
						$line["reg_exp"];
				}

				if (!$enabled) {
					$line["reg_exp"] = "<span class=\"insensitive\">" . 
						$line["reg_exp"] . " " .  __("(Disabled)")."</span>";
					$line["feed_title"] = "<span class=\"insensitive\">" . 
						$line["feed_title"] . "</span>";
					$line["filter_type_descr"] = "<span class=\"insensitive\">" . 
						$line["filter_type_descr"] . "</span>";
					$line["action_description"] = "<span class=\"insensitive\">" . 
						$line["action_description"] . "</span>";
					$line["action_param"] = "<span class=\"insensitive\">" . 
						$line["action_param"] . "</span>";
				}	

				$onclick = "onclick='editFilter($filter_id)' title='".__('Click to edit')."'";

				$inverse_label = "";

				if ($inverse) {
					$inverse_label = " <span class='insensitive'>".__('(Inverse)')."</span>";
				}

				print "<td $onclick>" . $line["reg_exp"] . "$inverse_label</td>";		
				print "<td $onclick>" . $line["feed_title"] . "</td>";			
	
				print "<td $onclick>" . $line["filter_type_descr"] . "</td>";
				print "<td $onclick>" . $line["action_param"] . "</td>";

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

			print "</table>";

			print "<p id=\"filterOpToolbar\">";

			print "<input type=\"submit\" class=\"button\" disabled=\"true\"
					onclick=\"return editSelectedFilter()\" value=\"".__('Edit')."\">
				<input type=\"submit\" class=\"button\" disabled=\"true\"
					onclick=\"return removeSelectedFilters()\" value=\"".__('Remove')."\">";

			print "</p>";

		} else {

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

		}
	}
?>
Commit	Line	Data
ef8be8ea AD	1	<?php
	2	function module_pref_filters($link) {
	3	$subop = $_GET["subop"];
	4	$quiet = $_GET["quiet"];
	5
	6	if ($subop == "edit") {
	7
	8	$filter_id = db_escape_string($_GET["id"]);
	9
	10	$result = db_query($link,
	11	"SELECT * FROM ttrss_filters WHERE id = '$filter_id' AND owner_uid = " . $_SESSION["uid"]);
	12
47439031	13	$reg_exp = htmlspecialchars(db_fetch_result($result, 0, "reg_exp"));
ef8be8ea AD	14	$filter_type = db_fetch_result($result, 0, "filter_type");
	15	$feed_id = db_fetch_result($result, 0, "feed_id");
	16	$action_id = db_fetch_result($result, 0, "action_id");
073ca0e6	17	$action_param = db_fetch_result($result, 0, "action_param");
44d0e774	18	$filter_param = db_fetch_result($result, 0, "filter_param");
ef8be8ea AD	19
ef8be8ea AD	20	$enabled = sql_bool_to_bool(db_fetch_result($result, 0, "enabled"));
3f2ff803	21	$inverse = sql_bool_to_bool(db_fetch_result($result, 0, "inverse"));
ef8be8ea	22
ecace165	23	print "<div id=\"infoBoxTitle\">".__('Filter Editor')."</div>";
ef8be8ea AD	24	print "<div class=\"infoBoxContents\">";
ef8be8ea AD	25
e6312f6c	26	print "<form id=\"filter_edit_form\" onsubmit='return false'>";
ef8be8ea AD	27
	28	print "<input type=\"hidden\" name=\"op\" value=\"pref-filters\">";
	29	print "<input type=\"hidden\" name=\"id\" value=\"$filter_id\">";
	30	print "<input type=\"hidden\" name=\"subop\" value=\"editSave\">";
ef8be8ea AD	31
	32	$result = db_query($link, "SELECT id,description
	33	FROM ttrss_filter_types ORDER BY description");
	34
	35	$filter_types = array();
	36
	37	while ($line = db_fetch_assoc($result)) {
	38	//array_push($filter_types, $line["description"]);
89cb787e	39	$filter_types[$line["id"]] = __($line["description"]);
ef8be8ea AD	40	}
ef8be8ea AD	41
10fa6615 AD	42	print "<div class=\"dlgSec\">".__("Match")."</div>";
	43
	44	print "<div class=\"dlgSecCont\">";
	45
6e278744 AD	46	if ($filter_type != 5) {
	47	$date_ops_invisible = 'style=\"display : none\"';
	48	}
	49
	50	print "<span id=\"filter_dlg_date_mod_box\" $date_ops_invisible>";
	51	print __("Date") . " ";
44d0e774 AD	52
	53	$filter_params = array(
	54	"before" => __("before"),
	55	"after" => __("after"));
	56
	57	print_select_hash("filter_date_modifier", $filter_param,
	58	$filter_params);
	59
	60	print " </span>";
6e278744	61
10fa6615 AD	62	print "<input onkeypress=\"return filterCR(event, filterEditSave)\"
	63	onkeyup=\"toggleSubmitNotEmpty(this, 'infobox_submit')\"
	64	onchange=\"toggleSubmitNotEmpty(this, 'infobox_submit')\"
	65	name=\"reg_exp\" size=\"30\" value=\"$reg_exp\">";
	66
6e278744 AD	67	print "<span id=\"filter_dlg_date_chk_box\" $date_ops_invisible>";
	68	print " <input class=\"button\"
	69	type=\"submit\" onclick=\"return filterDlgCheckDate()\"
	70	value=\"".__('Check it')."\">";
	71	print "</span>";
	72
	73	print "<br/> " . __("on field") . " ";
	74	print_select_hash("filter_type", $filter_type, $filter_types,
	75	'onchange="filterDlgCheckType(this)"');
10fa6615 AD	76
	77	print "<br/>";
	78
	79	print __("in") . " ";
	80	print_feed_select($link, "feed_id", $feed_id);
	81
	82	print "</div>";
	83
ecace165	84	print "<div class=\"dlgSec\">".__("Perform Action")."</div>";
10fa6615 AD	85
	86	print "<div class=\"dlgSecCont\">";
	87
	88	print "<select name=\"action_id\"
	89	onchange=\"filterDlgCheckAction(this)\">";
	90
	91	$result = db_query($link, "SELECT id,description FROM ttrss_filter_actions
	92	ORDER BY name");
	93
	94	while ($line = db_fetch_assoc($result)) {
	95	$is_sel = ($line["id"] == $action_id) ? "selected" : "";
	96	printf("<option value='%d' $is_sel>%s</option>", $line["id"], __($line["description"]));
	97	}
	98
	99	print "</select>";
	100
143a4973	101	$param_hidden = ($action_id == 4 \|\| $action_id == 6) ? "" : "display : none";
10fa6615	102
143a4973 AD	103	print "<span id=\"filter_dlg_param_box\" style=\"$param_hidden\">";
	104	print " " . __("with parameters:") . " ";
	105	print "<input size=\"20\"
074bf20c	106	onkeypress=\"return filterCR(event, filterEditSave)\"
143a4973 AD	107	name=\"action_param\" value=\"$action_param\">";
143a4973 AD	108	print "</span>";
10fa6615	109
143a4973	110	print " "; // tiny layout hack
10fa6615 AD	111
	112	print "</div>";
	113
	114	print "<div class=\"dlgSec\">".__("Options")."</div>";
	115	print "<div class=\"dlgSecCont\">";
	116
ecace165 AD	117	print "<div style=\"line-height : 100%\">";
ecace165 AD	118
10fa6615 AD	119	if ($enabled) {
	120	$checked = "checked";
	121	} else {
	122	$checked = "";
	123	}
	124
	125	print "<input type=\"checkbox\" name=\"enabled\" id=\"enabled\" $checked>
	126	<label for=\"enabled\">".__('Enabled')."</label><br/>";
	127
	128	if ($inverse) {
	129	$checked = "checked";
	130	} else {
	131	$checked = "";
	132	}
	133
	134	print "<input type=\"checkbox\" name=\"inverse\" id=\"inverse\" $checked>
	135	<label for=\"inverse\">".__('Inverse match')."</label>";
	136
	137	print "</div>";
ecace165	138	print "</div>";
10fa6615 AD	139
10fa6615 AD	140	print "<div class=\"dlgButtons\">";
ef8be8ea	141
ddb61e79	142	$reg_exp = htmlspecialchars($reg_exp, ENT_QUOTES); // second escaping seems to be needed for javascript
143a4973 AD	143
	144	print "<div style=\"float : left\">";
	145	print "<input type=\"submit\"
	146	class=\"button\" onclick='return removeFilter($filter_id, \"$reg_exp\")'
	147	value=\"".__('Remove')."\"> ";
	148	print "</div>";
	149
ef8be8ea AD	150	print "<input type=\"submit\"
	151	id=\"infobox_submit\"
	152	class=\"button\" onclick=\"return filterEditSave()\"
a3c159c4	153	value=\"".__('Save')."\"> ";
ef8be8ea AD	154
	155	print "<input class=\"button\"
	156	type=\"submit\" onclick=\"return filterEditCancel()\"
a3c159c4	157	value=\"".__('Cancel')."\">";
ef8be8ea AD	158
	159	print "</div>";
	160
	161	return;
	162	}
	163
	164
	165	if ($subop == "editSave") {
	166
	167	$reg_exp = db_escape_string(trim($_GET["reg_exp"]));
	168	$filter_type = db_escape_string(trim($_GET["filter_type"]));
	169	$filter_id = db_escape_string($_GET["id"]);
	170	$feed_id = db_escape_string($_GET["feed_id"]);
	171	$action_id = db_escape_string($_GET["action_id"]);
073ca0e6	172	$action_param = db_escape_string($_GET["action_param"]);
ef8be8ea	173	$enabled = checkbox_to_sql_bool(db_escape_string($_GET["enabled"]));
3f2ff803	174	$inverse = checkbox_to_sql_bool(db_escape_string($_GET["inverse"]));
ef8be8ea	175
44d0e774 AD	176	# for the time being, no other filters use params anyway...
	177	$filter_param = db_escape_string($_GET["filter_date_modifier"]);
	178
ef8be8ea AD	179	if (!$feed_id) {
	180	$feed_id = 'NULL';
	181	} else {
	182	$feed_id = sprintf("'%s'", db_escape_string($feed_id));
	183	}
	184
	185	$result = db_query($link, "UPDATE ttrss_filters SET
	186	reg_exp = '$reg_exp',
	187	feed_id = $feed_id,
	188	action_id = '$action_id',
	189	filter_type = '$filter_type',
073ca0e6	190	enabled = $enabled,
3f2ff803	191	inverse = $inverse,
44d0e774 AD	192	action_param = '$action_param',
44d0e774 AD	193	filter_param = '$filter_param'
4dccf1ed	194	WHERE id = '$filter_id' AND owner_uid = " . $_SESSION["uid"]);
5e6f933a AD	195
	196	if (db_affected_rows($link, $result) != 0) {
	197	print_notice(T_sprintf("Saved filter <b>%s</b>", htmlspecialchars($reg_exp)));
	198	}
	199
ef8be8ea AD	200	}
	201
	202	if ($subop == "remove") {
	203
4dccf1ed	204	$ids = split(",", db_escape_string($_GET["ids"]));
ef8be8ea	205
4dccf1ed AD	206	foreach ($ids as $id) {
4dccf1ed AD	207	db_query($link, "DELETE FROM ttrss_filters WHERE id = '$id' AND owner_uid = ". $_SESSION["uid"]);
ef8be8ea AD	208	}
	209	}
	210
	211	if ($subop == "add") {
	212
4dccf1ed AD	213	$regexp = db_escape_string(trim($_GET["reg_exp"]));
	214	$filter_type = db_escape_string(trim($_GET["filter_type"]));
	215	$feed_id = db_escape_string($_GET["feed_id"]);
	216	$action_id = db_escape_string($_GET["action_id"]);
	217	$action_param = db_escape_string($_GET["action_param"]);
4dccf1ed AD	218	$inverse = checkbox_to_sql_bool(db_escape_string($_GET["inverse"]));
4dccf1ed AD	219
44d0e774 AD	220	# for the time being, no other filters use params anyway...
	221	$filter_param = db_escape_string($_GET["filter_date_modifier"]);
	222
4dccf1ed AD	223	if (!$regexp) return;
	224
	225	if (!$feed_id) {
	226	$feed_id = 'NULL';
	227	} else {
	228	$feed_id = sprintf("'%s'", db_escape_string($feed_id));
	229	}
	230
	231	$result = db_query($link,
	232	"INSERT INTO ttrss_filters (reg_exp,filter_type,owner_uid,feed_id,
a8732d0c	233	action_id, action_param, inverse, filter_param)
4dccf1ed AD	234	VALUES
4dccf1ed AD	235	('$regexp', '$filter_type','".$_SESSION["uid"]."',
a8732d0c	236	$feed_id, '$action_id', '$action_param', $inverse, '$filter_param')");
4dccf1ed	237
5e6f933a AD	238	if (db_affected_rows($link, $result) != 0) {
	239	print T_sprintf("Created filter <b>%s</b>", htmlspecialchars($regexp));
	240	}
	241
	242	return;
ef8be8ea AD	243	}
	244
	245	if ($quiet) return;
	246
fe8d2059 AD	247	set_pref($link, "_PREFS_ACTIVE_TAB", "filterConfig");
fe8d2059 AD	248
ef8be8ea AD	249	$sort = db_escape_string($_GET["sort"]);
	250
	251	if (!$sort \|\| $sort == "undefined") {
	252	$sort = "reg_exp";
	253	}
	254
	255	// print "<div id=\"infoBoxShadow\"><div id=\"infoBox\">PLACEHOLDER</div></div>";
	256
	257	$result = db_query($link, "SELECT id,description
	258	FROM ttrss_filter_types ORDER BY description");
	259
	260	$filter_types = array();
	261
	262	while ($line = db_fetch_assoc($result)) {
	263	//array_push($filter_types, $line["description"]);
	264	$filter_types[$line["id"]] = $line["description"];
	265	}
	266
9c87d75c AD	267
	268	$filter_search = db_escape_string($_GET["search"]);
	269
	270	if (array_key_exists("search", $_GET)) {
	271	$_SESSION["prefs_filter_search"] = $filter_search;
	272	} else {
	273	$filter_search = $_SESSION["prefs_filter_search"];
	274	}
	275
	276	print "<div class=\"feedEditSearch\">
	277	<input id=\"filter_search\" size=\"20\" type=\"search\"
4cf6fc6a AD	278	onfocus=\"javascript:disableHotkeys();\"
4cf6fc6a AD	279	onblur=\"javascript:enableHotkeys();\"
9c87d75c AD	280	onchange=\"javascript:updateFilterList()\" value=\"$filter_search\">
9c87d75c AD	281	<input type=\"submit\" class=\"button\"
112d2aec AD	282	onclick=\"javascript:updateFilterList()\" value=\"".__('Search')."\">
112d2aec AD	283	<p<a class='helpLinkPic' href=\"javascript:displayHelpInfobox(2)\">
a3f4e4d3	284	<img src='images/sign_quest.gif'></a></p>
9c87d75c AD	285	</div>";
9c87d75c AD	286
0d32b41e	287
ef8be8ea AD	288	print "<input type=\"submit\"
	289	class=\"button\"
	290	onclick=\"return displayDlg('quickAddFilter', false)\"
	291	id=\"create_filter_btn\"
a3c159c4	292	value=\"".__('Create filter')."\">";
ef8be8ea	293
95a948a5 AD	294	print " ";
	295
	296	print "<input type=\"submit\"
	297	class=\"button\"
	298	onclick=\"rescore_all_feeds()\"
	299	value=\"".__('Rescore articles')."\">";
	300
9c87d75c AD	301	if ($filter_search) {
	302	$filter_search = db_escape_string($filter_search);
	303	$filter_search_query = "(
a3f4e4d3 AD	304	UPPER(ttrss_filter_actions.description) LIKE UPPER('%$filter_search%') OR
	305	UPPER(reg_exp) LIKE UPPER('%$filter_search%') OR
	306	UPPER(ttrss_feeds.title) LIKE UPPER('%$filter_search%') OR
	307	UPPER(ttrss_filter_types.description) LIKE UPPER('%$filter_search%')) AND";
9c87d75c AD	308	} else {
	309	$filter_search_query = "";
	310	}
	311
ef8be8ea AD	312	$result = db_query($link, "SELECT
	313	ttrss_filters.id AS id,reg_exp,
	314	ttrss_filter_types.name AS filter_type_name,
	315	ttrss_filter_types.description AS filter_type_descr,
	316	enabled,
3f2ff803	317	inverse,
ef8be8ea	318	feed_id,
7f94284b	319	filter_param,
1b74062f	320	filter_type,
ef8be8ea	321	ttrss_filter_actions.description AS action_description,
ff6e357a AD	322	ttrss_feeds.title AS feed_title,
	323	ttrss_filter_actions.name AS action_name,
	324	ttrss_filters.action_param AS action_param
ef8be8ea AD	325	FROM
	326	ttrss_filter_types,ttrss_filter_actions,ttrss_filters LEFT JOIN
	327	ttrss_feeds ON (ttrss_filters.feed_id = ttrss_feeds.id)
	328	WHERE
	329	filter_type = ttrss_filter_types.id AND
9c87d75c	330	$filter_search_query
ef8be8ea AD	331	ttrss_filter_actions.id = action_id AND
ef8be8ea AD	332	ttrss_filters.owner_uid = ".$_SESSION["uid"]."
a82dc5e4	333	ORDER by action_description, $sort");
ef8be8ea AD	334
	335	if (db_num_rows($result) != 0) {
	336
ef8be8ea AD	337	print "<p><table width=\"100%\" cellspacing=\"0\" class=\"prefFilterList\"
	338	id=\"prefFilterList\">";
	339
	340	print "<tr><td class=\"selectPrompt\" colspan=\"8\">
e8d0177d AD	341	".__('Select:')."
	342	<a href=\"javascript:selectPrefRows('filter', true)\">".__('All')."</a>,
	343	<a href=\"javascript:selectPrefRows('filter', false)\">".__('None')."</a>
ef8be8ea AD	344	</td</tr>";
ef8be8ea AD	345
ef8be8ea	346	$lnum = 0;
a82dc5e4 AD	347
	348	$cur_action_description = "";
	349
ef8be8ea AD	350	while ($line = db_fetch_assoc($result)) {
	351
	352	$class = ($lnum % 2) ? "even" : "odd";
	353
	354	$filter_id = $line["id"];
	355	$edit_filter_id = $_GET["id"];
	356
	357	$enabled = sql_bool_to_bool($line["enabled"]);
3f2ff803 AD	358	$inverse = sql_bool_to_bool($line["inverse"]);
3f2ff803 AD	359
ef8be8ea AD	360	if ($subop == "edit" && $filter_id != $edit_filter_id) {
	361	$class .= "Grayed";
	362	$this_row_id = "";
	363	} else {
	364	$this_row_id = "id=\"FILRR-$filter_id\"";
	365	}
a82dc5e4 AD	366
	367	$line["filter_type_descr"] = __($line["filter_type_descr"]);
	368	$line["action_description"] = __($line["action_description"]);
	369
	370	if ($line["action_description"] != $cur_action_description) {
	371	$cur_action_description = $line["action_description"];
	372
	373	print "<tr><td class='filterEditCat' colspan='6'>$cur_action_description</td></tr>";
	374
	375	print "<tr class=\"title\">
	376	<td align='center' width=\"5%\"> </td>
defaccde	377	<td width=\"20%\"><a href=\"javascript:updateFilterList('reg_exp')\">".__('Match')."</a></td>
a82dc5e4	378	<td width=\"\"><a href=\"javascript:updateFilterList('feed_title')\">".__('Feed')."</a></td>
defaccde	379	<td width=\"20%\"><a href=\"javascript:updateFilterList('filter_type')\">".__('Field')."</a></td>
08e618f7	380	<td width=\"20%\"><a href=\"javascript:updateFilterList('action_param')\">".__('Params')."</a></td>";
a82dc5e4 AD	381
	382	}
	383
ef8be8ea AD	384	print "<tr class=\"$class\" $this_row_id>";
ef8be8ea AD	385
47439031	386	$line["reg_exp"] = htmlspecialchars($line["reg_exp"]);
ef8be8ea	387
a3c159c4	388	if (!$line["feed_title"]) $line["feed_title"] = __("All feeds");
0966ea37 AD	389
0966ea37 AD	390	if (!$line["action_param"]) {
08e618f7	391	$line["action_param"] = "—";
0966ea37 AD	392	} else if ($line["action_name"] == "score") {
0966ea37 AD	393
e7002fc3	394	$score_pic = get_score_pic($line["action_param"]);
0966ea37 AD	395
	396	$score_pic = "<img class='hlScorePic' src=\"images/$score_pic\">";
	397
	398	$line["action_param"] = "$score_pic " . $line["action_param"];
	399
	400	}
ef8be8ea	401
47439031	402	$line["feed_title"] = htmlspecialchars($line["feed_title"]);
ef8be8ea AD	403
	404	print "<td align='center'><input onclick='toggleSelectPrefRow(this, \"filter\");'
	405	type=\"checkbox\" id=\"FICHK-".$line["id"]."\"></td>";
	406
7f94284b AD	407	$filter_params = array(
	408	"before" => __("before"),
	409	"after" => __("after"));
	410
	411	if ($line["filter_type"] == 5) {
	412
	413	if (!strtotime($line["reg_exp"])) {
	414	$line["reg_exp"] = "<span class=\"filterDateError\">" .
	415	$line["reg_exp"] . "</span>";
	416	}
	417
	418	$line["reg_exp"] = __("Date") . " " .
	419	$filter_params[$line['filter_param']] . " " .
	420	$line["reg_exp"];
	421	}
	422
ef8be8ea AD	423	if (!$enabled) {
ef8be8ea AD	424	$line["reg_exp"] = "<span class=\"insensitive\">" .
a3c159c4	425	$line["reg_exp"] . " " . __("(Disabled)")."</span>";
ef8be8ea AD	426	$line["feed_title"] = "<span class=\"insensitive\">" .
	427	$line["feed_title"] . "</span>";
	428	$line["filter_type_descr"] = "<span class=\"insensitive\">" .
	429	$line["filter_type_descr"] . "</span>";
	430	$line["action_description"] = "<span class=\"insensitive\">" .
	431	$line["action_description"] . "</span>";
a82dc5e4 AD	432	$line["action_param"] = "<span class=\"insensitive\">" .
a82dc5e4 AD	433	$line["action_param"] . "</span>";
ef8be8ea	434	}
a95da136 AD	435
	436	$onclick = "onclick='editFilter($filter_id)' title='".__('Click to edit')."'";
	437
3f2ff803 AD	438	$inverse_label = "";
	439
	440	if ($inverse) {
a3c159c4	441	$inverse_label = " <span class='insensitive'>".__('(Inverse)')."</span>";
3f2ff803	442	}
1b74062f AD	443
	444	print "<td $onclick>" . $line["reg_exp"] . "$inverse_label</td>";
	445	print "<td $onclick>" . $line["feed_title"] . "</td>";
ef8be8ea	446
1b74062f	447	print "<td $onclick>" . $line["filter_type_descr"] . "</td>";
08e618f7	448	print "<td $onclick>" . $line["action_param"] . "</td>";
ff6e357a	449
ef8be8ea AD	450	print "</tr>";
	451
	452	++$lnum;
	453	}
a5bd7bf0	454
ef8be8ea AD	455	print "</table>";
ef8be8ea AD	456
ef8be8ea	457	print "<p id=\"filterOpToolbar\">";
2d1a44af	458
a3c159c4 AD	459	print "<input type=\"submit\" class=\"button\" disabled=\"true\"
a3c159c4 AD	460	onclick=\"return editSelectedFilter()\" value=\"".__('Edit')."\">
ef8be8ea	461	<input type=\"submit\" class=\"button\" disabled=\"true\"
a3c159c4	462	onclick=\"return removeSelectedFilters()\" value=\"".__('Remove')."\">";
ef8be8ea AD	463
	464	print "</p>";
	465
	466	} else {
	467
9c87d75c	468	print "<p>";
9c87d75c AD	469	if (!$filter_search) {
	470	print __('No filters defined.');
	471	} else {
	472	print __('No matching filters found.');
	473	}
9c87d75c	474	print "</p>";
ef8be8ea AD	475
	476	}
	477	}
	478	?>