<?php
	require_once(__DIR__ . '/../../../vendor/autoload.php');

	use Orchard\QueryWrapper;

		// 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"];
		$check_saved_search_query = '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 = "report"';

		$dataParams = [];
		$dataParams[] = $saved_report_id;
		$dataParams[] = $current_user_id;
		if (!empty($save_report_type)) {
		    $check_saved_search_query .= ' AND orchadmin_sub_type = ?';
		    $dataParams[] = $save_report_type;
		}
		$check_saved_search = $wrapperObj->executeQuery($check_saved_search_query, $dataParams);
		if ($check_saved_search === false) {
		    show_pdo_error($check_saved_search_query, $wrapperObj->getLastStatement());
		}
		if (count($check_saved_search) <= 0) {
			$fatal_error = true;	
			$fatal_error_msg .= "Invalid Saved Report 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 = ?';

			$saved_search_result = $wrapperObj->executeQuery($saved_search_query, [$saved_report_id]);
			if ($saved_search_result === false) {
			    show_pdo_error($saved_search_query, $wrapperObj->getLastStatement());
			}
			$saved_report_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_report_variables[$temp_var_name] = $$temp_var_name;
				}
				else
				{
					$$saved_row["criteria_name"] = $saved_row["criteria_value"];
					$saved_report_variables[$saved_row["criteria_name"]] = $$saved_row["criteria_name"];
				}
			}
			
			$sql = 'UPDATE orchadmin_user_saved_query SET last_run = NOW() WHERE saved_query_id = ?';
			if ($wrapperObj->executeQuery($sql, [$saved_report_id], QueryWrapper::RETURN_AFFECTED_ROWS) === false) {
			    show_pdo_error($sql, $wrapperObj->getLastStatement());
			}
		}
?>