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

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

		if ($subop == "edit") {

			$filter_id = db_escape_string($_REQUEST["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)\"
					 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 || $action_id == 7) ? "" : "display : none";

			print "<span id=\"filter_dlg_param_box\" style=\"$param_hidden\">";
			print " " . __("with parameters:") . " ";

			$param_int_hidden = ($action_id != 7) ? "" : "display : none";

			print "<input size=\"20\" style=\"$param_int_hidden\"
					onkeypress=\"return filterCR(event, filterEditSave)\"		
					name=\"action_param\" value=\"$action_param\">";

			$param_int_hidden = ($action_id == 7) ? "" : "display : none";

			print_label_select($link, "action_param_label", $action_param, 
				$param_int_hidden);

			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 "<button onclick='return removeFilter($filter_id, \"$reg_exp\")'>".
				__('Remove')."</button>";
			print "</div>";

			print "<button onclick=\"return filterEditSave()\">".
				__('Save')."</button> ";

			print "<button onclick=\"return filterEditCancel()\">".
				__('Cancel')."</button>";

			print "</div>";

			return;
		}


		if ($subop == "editSave") {

			global $memcache;

			if ($memcache) $memcache->flush();

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

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

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

			/* When processing 'assign label' filters, action_param_label dropbox
			 * overrides action_param */

			if ($action_id == 7) {
				$action_param = $action_param_label;
			}

			$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") {
			
			if ($memcache) $memcache->flush();

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

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

		if ($subop == "add") {

			if ($memcache) $memcache->flush();

			$regexp = db_escape_string(trim($_REQUEST["reg_exp"]));
			$filter_type = db_escape_string(trim($_REQUEST["filter_type"]));
			$feed_id = db_escape_string($_REQUEST["feed_id"]);
			$action_id = db_escape_string($_REQUEST["action_id"]); 
			$action_param = db_escape_string($_REQUEST["action_param"]); 
			$action_param_label = db_escape_string($_REQUEST["action_param_label"]); 
			$inverse = checkbox_to_sql_bool(db_escape_string($_REQUEST["inverse"]));

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

			if (!$regexp) return;

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

			/* When processing 'assign label' filters, action_param_label dropbox
			 * overrides action_param */

			if ($action_id == 7) {
				$action_param = $action_param_label;
			}

			$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($_REQUEST["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($_REQUEST["search"]);

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

		print "<div style='float : right'>
			<input id=\"filter_search\" size=\"20\" type=\"search\"
				onfocus=\"javascript:disableHotkeys();\" 
				onblur=\"javascript:enableHotkeys();\"
				onchange=\"javascript:updateFilterList()\" value=\"$filter_search\">
			<button onclick=\"javascript:updateFilterList()\">".__('Search')."</button>
			&nbsp;
			<a class='helpLinkPic' href=\"javascript:displayHelpInfobox(2)\">
			<img style='vertical-align : top;' src='".theme_image($link, "images/sign_quest.png")."'></a>
		</div>";

		print "<button onclick=\"return quickAddFilter()\">".
			__('Create filter')."</button> "; 

		print "<button onclick=\"return editSelectedFilter()\">".
			__('Edit')."</button> ";

		print "<button onclick=\"return removeSelectedFilters()\">".
			__('Remove')."</button> ";

		print "<button onclick=\"rescore_all_feeds()\">".
			__('Rescore articles')."</button> "; 

		if ($filter_search) {
			$filter_search = split(' ', db_escape_string($filter_search));

			$tokens = array();

			foreach ($filter_search as $token) {
				$token = trim($token);

				array_push($tokens, "(
					UPPER(ttrss_filter_actions.description) LIKE UPPER('%$token%') OR 
					UPPER(reg_exp) LIKE UPPER('%$token%') OR 
					UPPER(action_param) LIKE UPPER('%$token%') OR 
					UPPER(ttrss_feeds.title) LIKE UPPER('%$token%') OR
					UPPER(ttrss_filter_types.description) LIKE UPPER('%$token%'))");
			}

			$filter_search_query = "(" . join($tokens, " AND ") . ") 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)) {
	
				$filter_id = $line["id"];
				$edit_filter_id = $_REQUEST["id"];

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

				$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>"; 

					$lnum = 0;
				}

				$class = ($lnum % 2) ? "even" : "odd";

				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 = theme_image($link,
						"images/" . get_score_pic($line["action_param"]));

					$score_pic = "<img class='hlScorePic' src=\"$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["action_name"] == 'label') {

					$tmp_result = db_query($link, "SELECT fg_color, bg_color
						FROM ttrss_labels2 WHERE caption = '".
							db_escape_string($line["action_param"])."' AND
							owner_uid = " . $_SESSION["uid"]);

					$fg_color = db_fetch_result($tmp_result, 0, "fg_color");
					$bg_color = db_fetch_result($tmp_result, 0, "bg_color");

					$tmp = "<div class='labelColorIndicator' id='LICID-$id' 
						style='color : $fg_color; background-color : $bg_color'>
						&alpha;";
					$tmp .= "</div>";

					$line["action_param"] = "$tmp " . $line["action_param"];
				}

				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>";

		} else {

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

		}
	}

	function print_label_select($link, $name, $value, $style = "") {

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

		print "<select default=\"$value\" name=\"$name\" style=\"$style\" 
			onchange=\"labelSelectOnChange(this)\" >";

		while ($line = db_fetch_assoc($result)) {

			$issel = ($line["caption"] == $value) ? "selected" : "";

			print "<option $issel>" . $line["caption"] . "</option>";

		}

		print "<option value=\"ADD_LABEL\">" .__("Add label...") . "</option>";

		print "</select>";


	}
?>
Commit	Line	Data
ef8be8ea AD	1	<?php
ef8be8ea AD	2	function module_pref_filters($link) {
b4e75b2a AD	3	$subop = $_REQUEST["subop"];
b4e75b2a AD	4	$quiet = $_REQUEST["quiet"];
ef8be8ea AD	5
	6	if ($subop == "edit") {
	7
b4e75b2a	8	$filter_id = db_escape_string($_REQUEST["id"]);
ef8be8ea AD	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	46	if ($filter_type != 5) {
df00fb80	47	$date_ops_invisible = 'style="display : none"';
6e278744 AD	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	62	print "<input onkeypress=\"return filterCR(event, filterEditSave)\"
10fa6615 AD	63	name=\"reg_exp\" size=\"30\" value=\"$reg_exp\">";
10fa6615 AD	64
6e278744 AD	65	print "<span id=\"filter_dlg_date_chk_box\" $date_ops_invisible>";
	66	print " <input class=\"button\"
	67	type=\"submit\" onclick=\"return filterDlgCheckDate()\"
	68	value=\"".__('Check it')."\">";
	69	print "</span>";
	70
	71	print "<br/> " . __("on field") . " ";
	72	print_select_hash("filter_type", $filter_type, $filter_types,
	73	'onchange="filterDlgCheckType(this)"');
10fa6615 AD	74
	75	print "<br/>";
	76
	77	print __("in") . " ";
	78	print_feed_select($link, "feed_id", $feed_id);
	79
	80	print "</div>";
	81
ecace165	82	print "<div class=\"dlgSec\">".__("Perform Action")."</div>";
10fa6615 AD	83
	84	print "<div class=\"dlgSecCont\">";
	85
	86	print "<select name=\"action_id\"
	87	onchange=\"filterDlgCheckAction(this)\">";
	88
	89	$result = db_query($link, "SELECT id,description FROM ttrss_filter_actions
	90	ORDER BY name");
	91
	92	while ($line = db_fetch_assoc($result)) {
	93	$is_sel = ($line["id"] == $action_id) ? "selected" : "";
	94	printf("<option value='%d' $is_sel>%s</option>", $line["id"], __($line["description"]));
	95	}
	96
	97	print "</select>";
	98
ceb30ba4	99	$param_hidden = ($action_id == 4 \|\| $action_id == 6 \|\| $action_id == 7) ? "" : "display : none";
10fa6615	100
143a4973 AD	101	print "<span id=\"filter_dlg_param_box\" style=\"$param_hidden\">";
143a4973 AD	102	print " " . __("with parameters:") . " ";
ceb30ba4 AD	103
	104	$param_int_hidden = ($action_id != 7) ? "" : "display : none";
	105
	106	print "<input size=\"20\" style=\"$param_int_hidden\"
074bf20c	107	onkeypress=\"return filterCR(event, filterEditSave)\"
143a4973	108	name=\"action_param\" value=\"$action_param\">";
ceb30ba4 AD	109
	110	$param_int_hidden = ($action_id == 7) ? "" : "display : none";
	111
	112	print_label_select($link, "action_param_label", $action_param,
	113	$param_int_hidden);
	114
143a4973	115	print "</span>";
10fa6615	116
143a4973	117	print " "; // tiny layout hack
10fa6615 AD	118
	119	print "</div>";
	120
	121	print "<div class=\"dlgSec\">".__("Options")."</div>";
	122	print "<div class=\"dlgSecCont\">";
	123
ecace165 AD	124	print "<div style=\"line-height : 100%\">";
ecace165 AD	125
10fa6615 AD	126	if ($enabled) {
	127	$checked = "checked";
	128	} else {
	129	$checked = "";
	130	}
	131
	132	print "<input type=\"checkbox\" name=\"enabled\" id=\"enabled\" $checked>
	133	<label for=\"enabled\">".__('Enabled')."</label><br/>";
	134
	135	if ($inverse) {
	136	$checked = "checked";
	137	} else {
	138	$checked = "";
	139	}
	140
	141	print "<input type=\"checkbox\" name=\"inverse\" id=\"inverse\" $checked>
	142	<label for=\"inverse\">".__('Inverse match')."</label>";
	143
	144	print "</div>";
ecace165	145	print "</div>";
10fa6615 AD	146
10fa6615 AD	147	print "<div class=\"dlgButtons\">";
ef8be8ea	148
ddb61e79	149	$reg_exp = htmlspecialchars($reg_exp, ENT_QUOTES); // second escaping seems to be needed for javascript
143a4973 AD	150
143a4973 AD	151	print "<div style=\"float : left\">";
577399e8 AD	152	print "<button onclick='return removeFilter($filter_id, \"$reg_exp\")'>".
577399e8 AD	153	__('Remove')."</button>";
143a4973 AD	154	print "</div>";
143a4973 AD	155
577399e8 AD	156	print "<button onclick=\"return filterEditSave()\">".
577399e8 AD	157	__('Save')."</button> ";
ef8be8ea	158
577399e8 AD	159	print "<button onclick=\"return filterEditCancel()\">".
577399e8 AD	160	__('Cancel')."</button>";
ef8be8ea AD	161
	162	print "</div>";
	163
	164	return;
	165	}
	166
	167
	168	if ($subop == "editSave") {
	169
b8ffa322 AD	170	global $memcache;
	171
	172	if ($memcache) $memcache->flush();
	173
b4e75b2a AD	174	$reg_exp = db_escape_string(trim($_REQUEST["reg_exp"]));
	175	$filter_type = db_escape_string(trim($_REQUEST["filter_type"]));
	176	$filter_id = db_escape_string($_REQUEST["id"]);
	177	$feed_id = db_escape_string($_REQUEST["feed_id"]);
	178	$action_id = db_escape_string($_REQUEST["action_id"]);
	179	$action_param = db_escape_string($_REQUEST["action_param"]);
	180	$action_param_label = db_escape_string($_REQUEST["action_param_label"]);
	181	$enabled = checkbox_to_sql_bool(db_escape_string($_REQUEST["enabled"]));
	182	$inverse = checkbox_to_sql_bool(db_escape_string($_REQUEST["inverse"]));
ef8be8ea	183
44d0e774	184	# for the time being, no other filters use params anyway...
b4e75b2a	185	$filter_param = db_escape_string($_REQUEST["filter_date_modifier"]);
44d0e774	186
ef8be8ea AD	187	if (!$feed_id) {
	188	$feed_id = 'NULL';
	189	} else {
	190	$feed_id = sprintf("'%s'", db_escape_string($feed_id));
	191	}
ceb30ba4 AD	192
	193	/* When processing 'assign label' filters, action_param_label dropbox
	194	* overrides action_param */
	195
	196	if ($action_id == 7) {
	197	$action_param = $action_param_label;
	198	}
	199
ef8be8ea AD	200	$result = db_query($link, "UPDATE ttrss_filters SET
	201	reg_exp = '$reg_exp',
	202	feed_id = $feed_id,
	203	action_id = '$action_id',
	204	filter_type = '$filter_type',
073ca0e6	205	enabled = $enabled,
3f2ff803	206	inverse = $inverse,
44d0e774 AD	207	action_param = '$action_param',
44d0e774 AD	208	filter_param = '$filter_param'
4dccf1ed	209	WHERE id = '$filter_id' AND owner_uid = " . $_SESSION["uid"]);
5e6f933a AD	210
	211	if (db_affected_rows($link, $result) != 0) {
	212	print_notice(T_sprintf("Saved filter <b>%s</b>", htmlspecialchars($reg_exp)));
	213	}
	214
ef8be8ea AD	215	}
	216
	217	if ($subop == "remove") {
a522a767 AD	218
a522a767 AD	219	if ($memcache) $memcache->flush();
ef8be8ea	220
b4e75b2a	221	$ids = split(",", db_escape_string($_REQUEST["ids"]));
ef8be8ea	222
4dccf1ed AD	223	foreach ($ids as $id) {
4dccf1ed AD	224	db_query($link, "DELETE FROM ttrss_filters WHERE id = '$id' AND owner_uid = ". $_SESSION["uid"]);
ef8be8ea AD	225	}
	226	}
	227
	228	if ($subop == "add") {
a522a767 AD	229
	230	if ($memcache) $memcache->flush();
	231
b4e75b2a AD	232	$regexp = db_escape_string(trim($_REQUEST["reg_exp"]));
	233	$filter_type = db_escape_string(trim($_REQUEST["filter_type"]));
	234	$feed_id = db_escape_string($_REQUEST["feed_id"]);
	235	$action_id = db_escape_string($_REQUEST["action_id"]);
	236	$action_param = db_escape_string($_REQUEST["action_param"]);
	237	$action_param_label = db_escape_string($_REQUEST["action_param_label"]);
	238	$inverse = checkbox_to_sql_bool(db_escape_string($_REQUEST["inverse"]));
4dccf1ed	239
44d0e774	240	# for the time being, no other filters use params anyway...
b4e75b2a	241	$filter_param = db_escape_string($_REQUEST["filter_date_modifier"]);
44d0e774	242
4dccf1ed AD	243	if (!$regexp) return;
	244
	245	if (!$feed_id) {
	246	$feed_id = 'NULL';
	247	} else {
	248	$feed_id = sprintf("'%s'", db_escape_string($feed_id));
	249	}
	250
db34a63e AD	251	/* When processing 'assign label' filters, action_param_label dropbox
	252	* overrides action_param */
	253
	254	if ($action_id == 7) {
	255	$action_param = $action_param_label;
	256	}
	257
4dccf1ed AD	258	$result = db_query($link,
4dccf1ed AD	259	"INSERT INTO ttrss_filters (reg_exp,filter_type,owner_uid,feed_id,
a8732d0c	260	action_id, action_param, inverse, filter_param)
4dccf1ed AD	261	VALUES
4dccf1ed AD	262	('$regexp', '$filter_type','".$_SESSION["uid"]."',
a8732d0c	263	$feed_id, '$action_id', '$action_param', $inverse, '$filter_param')");
4dccf1ed	264
5e6f933a AD	265	if (db_affected_rows($link, $result) != 0) {
	266	print T_sprintf("Created filter <b>%s</b>", htmlspecialchars($regexp));
	267	}
	268
	269	return;
ef8be8ea AD	270	}
	271
	272	if ($quiet) return;
	273
fe8d2059 AD	274	set_pref($link, "_PREFS_ACTIVE_TAB", "filterConfig");
fe8d2059 AD	275
b4e75b2a	276	$sort = db_escape_string($_REQUEST["sort"]);
ef8be8ea AD	277
	278	if (!$sort \|\| $sort == "undefined") {
	279	$sort = "reg_exp";
	280	}
	281
	282	// print "<div id=\"infoBoxShadow\"><div id=\"infoBox\">PLACEHOLDER</div></div>";
	283
	284	$result = db_query($link, "SELECT id,description
	285	FROM ttrss_filter_types ORDER BY description");
	286
	287	$filter_types = array();
	288
	289	while ($line = db_fetch_assoc($result)) {
	290	//array_push($filter_types, $line["description"]);
	291	$filter_types[$line["id"]] = $line["description"];
	292	}
	293
9c87d75c	294
b4e75b2a	295	$filter_search = db_escape_string($_REQUEST["search"]);
9c87d75c	296
b4e75b2a	297	if (array_key_exists("search", $_REQUEST)) {
9c87d75c AD	298	$_SESSION["prefs_filter_search"] = $filter_search;
	299	} else {
	300	$filter_search = $_SESSION["prefs_filter_search"];
	301	}
	302
577399e8	303	print "<div style='float : right'>
9c87d75c	304	<input id=\"filter_search\" size=\"20\" type=\"search\"
4cf6fc6a AD	305	onfocus=\"javascript:disableHotkeys();\"
4cf6fc6a AD	306	onblur=\"javascript:enableHotkeys();\"
9c87d75c	307	onchange=\"javascript:updateFilterList()\" value=\"$filter_search\">
577399e8	308	<button onclick=\"javascript:updateFilterList()\">".__('Search')."</button>
1e5548db AD	309
1e5548db AD	310	<a class='helpLinkPic' href=\"javascript:displayHelpInfobox(2)\">
883fee8d	311	<img style='vertical-align : top;' src='".theme_image($link, "images/sign_quest.png")."'></a>
577399e8	312	</div>";
9c87d75c	313
3393238d	314	print "<button onclick=\"return quickAddFilter()\">".
577399e8	315	__('Create filter')."</button> ";
0d32b41e	316
577399e8 AD	317	print "<button onclick=\"return editSelectedFilter()\">".
577399e8 AD	318	__('Edit')."</button> ";
ef8be8ea	319
577399e8 AD	320	print "<button onclick=\"return removeSelectedFilters()\">".
577399e8 AD	321	__('Remove')."</button> ";
1e5548db	322
577399e8 AD	323	print "<button onclick=\"rescore_all_feeds()\">".
577399e8 AD	324	__('Rescore articles')."</button> ";
95a948a5	325
9c87d75c	326	if ($filter_search) {
1638fc4e AD	327	$filter_search = split(' ', db_escape_string($filter_search));
	328
	329	$tokens = array();
	330
	331	foreach ($filter_search as $token) {
	332	$token = trim($token);
	333
	334	array_push($tokens, "(
	335	UPPER(ttrss_filter_actions.description) LIKE UPPER('%$token%') OR
	336	UPPER(reg_exp) LIKE UPPER('%$token%') OR
	337	UPPER(action_param) LIKE UPPER('%$token%') OR
	338	UPPER(ttrss_feeds.title) LIKE UPPER('%$token%') OR
	339	UPPER(ttrss_filter_types.description) LIKE UPPER('%$token%'))");
	340	}
	341
	342	$filter_search_query = "(" . join($tokens, " AND ") . ") AND ";
	343
9c87d75c AD	344	} else {
	345	$filter_search_query = "";
	346	}
	347
ef8be8ea AD	348	$result = db_query($link, "SELECT
	349	ttrss_filters.id AS id,reg_exp,
	350	ttrss_filter_types.name AS filter_type_name,
	351	ttrss_filter_types.description AS filter_type_descr,
	352	enabled,
3f2ff803	353	inverse,
ef8be8ea	354	feed_id,
7f94284b	355	filter_param,
1b74062f	356	filter_type,
ef8be8ea	357	ttrss_filter_actions.description AS action_description,
ff6e357a AD	358	ttrss_feeds.title AS feed_title,
	359	ttrss_filter_actions.name AS action_name,
	360	ttrss_filters.action_param AS action_param
ef8be8ea AD	361	FROM
	362	ttrss_filter_types,ttrss_filter_actions,ttrss_filters LEFT JOIN
	363	ttrss_feeds ON (ttrss_filters.feed_id = ttrss_feeds.id)
	364	WHERE
	365	filter_type = ttrss_filter_types.id AND
9c87d75c	366	$filter_search_query
ef8be8ea AD	367	ttrss_filter_actions.id = action_id AND
ef8be8ea AD	368	ttrss_filters.owner_uid = ".$_SESSION["uid"]."
a82dc5e4	369	ORDER by action_description, $sort");
ef8be8ea AD	370
	371	if (db_num_rows($result) != 0) {
	372
ef8be8ea AD	373	print "<p><table width=\"100%\" cellspacing=\"0\" class=\"prefFilterList\"
	374	id=\"prefFilterList\">";
	375
	376	print "<tr><td class=\"selectPrompt\" colspan=\"8\">
e8d0177d AD	377	".__('Select:')."
	378	<a href=\"javascript:selectPrefRows('filter', true)\">".__('All')."</a>,
	379	<a href=\"javascript:selectPrefRows('filter', false)\">".__('None')."</a>
ef8be8ea AD	380	</td</tr>";
ef8be8ea AD	381
ef8be8ea	382	$lnum = 0;
a82dc5e4 AD	383
	384	$cur_action_description = "";
	385
ef8be8ea AD	386	while ($line = db_fetch_assoc($result)) {
ef8be8ea AD	387
ef8be8ea	388	$filter_id = $line["id"];
b4e75b2a	389	$edit_filter_id = $_REQUEST["id"];
ef8be8ea AD	390
ef8be8ea AD	391	$enabled = sql_bool_to_bool($line["enabled"]);
3f2ff803 AD	392	$inverse = sql_bool_to_bool($line["inverse"]);
3f2ff803 AD	393
ef9cab23	394	$this_row_id = "id=\"FILRR-$filter_id\"";
a82dc5e4 AD	395
	396	$line["filter_type_descr"] = __($line["filter_type_descr"]);
	397	$line["action_description"] = __($line["action_description"]);
	398
	399	if ($line["action_description"] != $cur_action_description) {
	400	$cur_action_description = $line["action_description"];
	401
	402	print "<tr><td class='filterEditCat' colspan='6'>$cur_action_description</td></tr>";
	403
	404	print "<tr class=\"title\">
	405	<td align='center' width=\"5%\"> </td>
defaccde	406	<td width=\"20%\"><a href=\"javascript:updateFilterList('reg_exp')\">".__('Match')."</a></td>
a82dc5e4	407	<td width=\"\"><a href=\"javascript:updateFilterList('feed_title')\">".__('Feed')."</a></td>
defaccde	408	<td width=\"20%\"><a href=\"javascript:updateFilterList('filter_type')\">".__('Field')."</a></td>
08e618f7	409	<td width=\"20%\"><a href=\"javascript:updateFilterList('action_param')\">".__('Params')."</a></td>";
a82dc5e4	410
ef9cab23	411	$lnum = 0;
a82dc5e4 AD	412	}
a82dc5e4 AD	413
ef9cab23 AD	414	$class = ($lnum % 2) ? "even" : "odd";
ef9cab23 AD	415
ef8be8ea AD	416	print "<tr class=\"$class\" $this_row_id>";
ef8be8ea AD	417
47439031	418	$line["reg_exp"] = htmlspecialchars($line["reg_exp"]);
ef8be8ea	419
a3c159c4	420	if (!$line["feed_title"]) $line["feed_title"] = __("All feeds");
0966ea37 AD	421
0966ea37 AD	422	if (!$line["action_param"]) {
08e618f7	423	$line["action_param"] = "—";
0966ea37 AD	424	} else if ($line["action_name"] == "score") {
0966ea37 AD	425
883fee8d AD	426	$score_pic = theme_image($link,
883fee8d AD	427	"images/" . get_score_pic($line["action_param"]));
0966ea37	428
883fee8d	429	$score_pic = "<img class='hlScorePic' src=\"$score_pic\">";
0966ea37 AD	430
	431	$line["action_param"] = "$score_pic " . $line["action_param"];
	432
	433	}
ef8be8ea	434
47439031	435	$line["feed_title"] = htmlspecialchars($line["feed_title"]);
ef8be8ea AD	436
	437	print "<td align='center'><input onclick='toggleSelectPrefRow(this, \"filter\");'
	438	type=\"checkbox\" id=\"FICHK-".$line["id"]."\"></td>";
	439
7f94284b AD	440	$filter_params = array(
	441	"before" => __("before"),
	442	"after" => __("after"));
a970edb1 AD	443
	444	if ($line["action_name"] == 'label') {
	445
	446	$tmp_result = db_query($link, "SELECT fg_color, bg_color
	447	FROM ttrss_labels2 WHERE caption = '".
	448	db_escape_string($line["action_param"])."' AND
	449	owner_uid = " . $_SESSION["uid"]);
	450
	451	$fg_color = db_fetch_result($tmp_result, 0, "fg_color");
	452	$bg_color = db_fetch_result($tmp_result, 0, "bg_color");
	453
	454	$tmp = "<div class='labelColorIndicator' id='LICID-$id'
	455	style='color : $fg_color; background-color : $bg_color'>
	456	α";
	457	$tmp .= "</div>";
	458
	459	$line["action_param"] = "$tmp " . $line["action_param"];
	460	}
	461
7f94284b AD	462	if ($line["filter_type"] == 5) {
	463
	464	if (!strtotime($line["reg_exp"])) {
	465	$line["reg_exp"] = "<span class=\"filterDateError\">" .
	466	$line["reg_exp"] . "</span>";
	467	}
	468
	469	$line["reg_exp"] = __("Date") . " " .
	470	$filter_params[$line['filter_param']] . " " .
	471	$line["reg_exp"];
	472	}
	473
ef8be8ea AD	474	if (!$enabled) {
ef8be8ea AD	475	$line["reg_exp"] = "<span class=\"insensitive\">" .
a3c159c4	476	$line["reg_exp"] . " " . __("(Disabled)")."</span>";
ef8be8ea AD	477	$line["feed_title"] = "<span class=\"insensitive\">" .
	478	$line["feed_title"] . "</span>";
	479	$line["filter_type_descr"] = "<span class=\"insensitive\">" .
	480	$line["filter_type_descr"] . "</span>";
	481	$line["action_description"] = "<span class=\"insensitive\">" .
	482	$line["action_description"] . "</span>";
a82dc5e4 AD	483	$line["action_param"] = "<span class=\"insensitive\">" .
a82dc5e4 AD	484	$line["action_param"] . "</span>";
ef8be8ea	485	}
a95da136 AD	486
	487	$onclick = "onclick='editFilter($filter_id)' title='".__('Click to edit')."'";
	488
3f2ff803 AD	489	$inverse_label = "";
	490
	491	if ($inverse) {
a3c159c4	492	$inverse_label = " <span class='insensitive'>".__('(Inverse)')."</span>";
3f2ff803	493	}
1b74062f AD	494
	495	print "<td $onclick>" . $line["reg_exp"] . "$inverse_label</td>";
	496	print "<td $onclick>" . $line["feed_title"] . "</td>";
ef8be8ea	497
1b74062f	498	print "<td $onclick>" . $line["filter_type_descr"] . "</td>";
08e618f7	499	print "<td $onclick>" . $line["action_param"] . "</td>";
ff6e357a	500
ef8be8ea AD	501	print "</tr>";
	502
	503	++$lnum;
	504	}
a5bd7bf0	505
ef8be8ea AD	506	print "</table>";
ef8be8ea AD	507
ef8be8ea AD	508	} else {
ef8be8ea AD	509
9c87d75c	510	print "<p>";
9c87d75c	511	if (!$filter_search) {
cea04d61	512	print_warning(__('No filters defined.'));
9c87d75c	513	} else {
cea04d61	514	print_warning(__('No matching filters found.'));
9c87d75c	515	}
9c87d75c	516	print "</p>";
ef8be8ea AD	517
	518	}
	519	}
ceb30ba4 AD	520
	521	function print_label_select($link, $name, $value, $style = "") {
	522
	523	$result = db_query($link, "SELECT caption FROM ttrss_labels2
	524	WHERE owner_uid = '".$_SESSION["uid"]."' ORDER BY caption");
	525
1c31e190 AD	526	print "<select default=\"$value\" name=\"$name\" style=\"$style\"
1c31e190 AD	527	onchange=\"labelSelectOnChange(this)\" >";
ceb30ba4 AD	528
	529	while ($line = db_fetch_assoc($result)) {
	530
	531	$issel = ($line["caption"] == $value) ? "selected" : "";
	532
	533	print "<option $issel>" . $line["caption"] . "</option>";
	534
	535	}
	536
1c31e190 AD	537	print "<option value=\"ADD_LABEL\">" .__("Add label...") . "</option>";
1c31e190 AD	538
ceb30ba4 AD	539	print "</select>";
	540
	541
	542	}
ef8be8ea	543	?>