<?php
		require_once(__DIR__ . '/../../../vendor/autoload.php');
		use Orchard\Mysqli\QueryData;
		use Orchard\Mysqli\Wrapper as MysqliWrapper;

		$wrapperObj = new MysqliWrapper($mysqli);

		// first make sure that the saved search is of the right type and belongs to the logged in user.
		$current_user_id = $_SESSION["S_USERID"];
		$sql = 'select saved_query_id, orchadmin_user_id, query_type, orchadmin_sub_type, query_name, description 
		        from orchadmin_user_saved_query
		        WHERE saved_query_id = ? AND orchadmin_user_id = ? AND query_type = "search"';

		if(!empty($search_type))
		    $sql .= ' AND orchadmin_sub_type = ?';

		$data_Params = new QueryData();
		$data_Params->addDataParam('i', $saved_search_id);
		$data_Params->addDataParam('i', $current_user_id);
		$data_Params->addDataParam('s', $search_type);
		$check_saved_search = $wrapperObj->executeQuery($sql, $data_Params);

		if ($check_saved_search === false) {
		    showierror($sql);
		}

		if (count($check_saved_search) <= 0) {
			$fatal_error = true;
			$fatal_error_msg .= "Invalid Saved Search ID provided.";
		}
		else
		{
			$saved_search_query = 'select saved_query_criteria_id, saved_query_id, criteria_name, criteria_value
			                    from orchadmin_user_saved_query_criteria 
			                    WHERE saved_query_id = ?';
			$data_Params = new QueryData();
			$data_Params->addDataParam('i', $saved_search_id);
			$saved_search_result = $wrapperObj->executeQuery($saved_search_query, $data_Params);
			if ($saved_search_result === false) {
			    showierror($saved_search_query);
			}
			$saved_search_variables = array();
			foreach ($saved_search_result as $saved_row) {
				$pattern = "/\[\]$/";
				if(preg_match($pattern, $saved_row["criteria_name"]))
				{
					$temp_var_name = preg_replace($pattern, "", $saved_row["criteria_name"]);
					$$temp_var_name = explode(",",$saved_row["criteria_value"]);
					$saved_search_variables[$temp_var_name] = $$temp_var_name;
				}
				else
				{
					$$saved_row["criteria_name"] = $saved_row["criteria_value"];
					$saved_search_variables[$saved_row["criteria_name"]] = $$saved_row["criteria_name"];
				}
			}
			$sql = 'UPDATE orchadmin_user_saved_query SET last_run = NOW() WHERE saved_query_id = ?';
			$data_Params = new QueryData();
			$data_Params->addDataParam('i', $saved_search_id);
			if ($wrapperObj->executeQuery($sql, $data_Params, MysqliWrapper::RETURN_AFFECTED_ROWS) === false) {
			    showierror($sql);
			}
		}
?>