<?php
	require_once(__DIR__ . '/../../../vendor/autoload.php');
	use Orchard\Mysqli\QueryData;
	use Orchard\Mysqli\Wrapper as MysqliWrapper;
	use Orchard\Messages\WebMessage;
	$wrapperObj = new MysqliWrapper($mysqli);
	if($act == "save_search")
	{
		$err_msg = "";
		if(empty($search_type))
		{
			$err_msg = "<li>Error: Missing Search Type.</li>";
		}
		
		if(empty($title))
			$err_msg .= "<li>Please enter search title.</li>";
			
		if($err_msg == "")
		{
			$orchadmin_user_id  = $_SESSION["S_USERID"];
			// now go ahead and enter the script.
			$dataParams = new QueryData();
			$insert_search = 'insert into orchadmin_user_saved_query 
								(orchadmin_user_id, query_type, orchadmin_sub_type, query_name, description, date_created)
								values
								(?, "search", ?, ?, ?, NOW())';
			$dataParams->addDataParam('i', $orchadmin_user_id);
			$dataParams->addDataParam('s', $search_type);
			$dataParams->addDataParam('s', $title);
			$dataParams->addDataParam('s', $description);
			$saved_search_id = $wrapperObj->executeQuery($insert_search, $dataParams, MysqliWrapper::RETURN_INSERT_ID);
			//echo $insert_search;
			if ($saved_search_id === false) {
			    showierror($insert_search);
			}
			
			// now go ahead and enter all the criteria
			$search_criteria = unserialize($_SESSION['S_SEARCH_CRITERIA']);
			//var_dump($search_criteria);
			if(sizeof($search_criteria) > 0 && is_array($search_criteria))
			{
				$dataParams = new QueryData();
				$insert_search_criteria = "";
				foreach($search_criteria as $i => $v)
				{
				    $insert_search_criteria .= ', (?, ?, ?)';
				    $dataParams->addDataParam('i', $saved_search_id);
				    $dataParams->addDataParam('s', $v['name']); 
				    $dataParams->addDataParam('s', $v['value'] ? $v['value'] : 'NULL');
				}
				$insert_search_criteria = trim($insert_search_criteria, ",");
				$insert_search_criteria = 'insert into orchadmin_user_saved_query_criteria
											(saved_query_id, criteria_name, criteria_value)
											values' . $insert_search_criteria;
				
				//echo $insert_search_criteria;
				
				if ($wrapperObj->executeQuery($insert_search_criteria, $dataParams, MysqliWrapper::RETURN_INSERT_ID) === false) {
				    showierror($insert_search_criteria);
				}
			}
			
			$confirm_msg = 'fda32sd2';
			header("location: {$_SERVER['PHP_SELF']}?saved_search_id=$saved_search_id&confirm_msg=$confirm_msg");
			exit();
		}
		
	}
	elseif ($act == 'save_report') {
		$err_msg = "";
		if(empty($report_type))
		{
			$err_msg = "<li>Error: Missing Report Type.</li>";
		}
		
		if(empty($title))
			$err_msg .= "<li>Please enter report title.</li>";
			
		if($err_msg == "")
		{
			$orchadmin_user_id  = $_SESSION["S_USERID"];
			$dataParams = new QueryData();
			// now go ahead and enter the script.
			$insert_search = 'insert into orchadmin_user_saved_query 
								(orchadmin_user_id, query_type, orchadmin_sub_type, query_name, description, date_created)
								values
								(?, "report", ?, ?, ?, NOW())';
			//echo $insert_search;
			$dataParams->addDataParam('i', $orchadmin_user_id);
			$dataParams->addDataParam('s', $report_type);
			$dataParams->addDataParam('s', $title);
			$dataParams->addDataParam('s', $description);
			$saved_report_id = $wrapperObj->executeQuery($insert_search, $dataParams, MysqliWrapper::RETURN_INSERT_ID); 
			if ($saved_report_id === false) {
			    showierror($insert_search);
			}
			
			
			// now go ahead and enter all the criteria
			$search_criteria = unserialize($_SESSION['S_REPORT_CRITERIA']);
			//var_dump($search_criteria);
			if(sizeof($search_criteria) > 0 && is_array($search_criteria))
			{
				$insert_search_criteria = "";
				$dataParams = new QueryData();
				foreach($search_criteria as $i => $v)
				{
				    $insert_search_criteria .= ', (?, ?, ?)';
				    $dataParams->addDataParam('i', $saved_report_id);
				    $dataParams->addDataParam('s', $v['name']);
				    $dataParams->addDataParam('s', $v['value'] ? $v['value'] : 'NULL');
				}
				$insert_search_criteria = trim($insert_search_criteria, ",");
				$insert_search_criteria = 'insert into orchadmin_user_saved_query_criteria
											(saved_query_id, criteria_name, criteria_value)
											values' . $insert_search_criteria;
				
				//echo $insert_search_criteria;
				
				if ($wrapperObj->executeQuery($insert_search_criteria, $dataParams, MysqliWrapper::RETURN_INSERT_ID) === false) {
				    showierror($insert_search_criteria);
				}
			}
			
			$confirm_msg = 'fds554r5';
			header("location: {$_SERVER['PHP_SELF']}?saved_report_id=$saved_report_id&confirm_msg=$confirm_msg");
			exit();
		}
	}
?>