<?				require_once(__DIR__ . '/../../../vendor/autoload.php');
				use Orchard\QueryWrapper;
				use Orchard\Messages\WebMessage;
				use Orchard\Mysqli\QueryData;
				use Orchard\Mysqli\Wrapper as MysqliWrapper;

				if (!isset($wrapperObj) || $wrapperObj === null) {
				    $wrapperObj = new MysqliWrapper($mysqli);
				}

				$orchadmin_user_id  = $_SESSION['S_USERID'];
				// 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, period, expiration_date)
				    values (?, "report", ?, ?, ?, NOW(), ?, ?)';
				if ($wrapperObj instanceof QueryWrapper) {
				    $dataParams = [];
				    $dataParams[] = $orchadmin_user_id;
				    $dataParams[] = $_SESSION['S_REPORT_TYPE'];
				    $dataParams[] = $report_title;
				    $dataParams[] = $description;
				    $dataParams[] = $duration;
				    $dataParams[] = $expiration_date;

				    $saved_report_id = $wrapperObj->executeQuery($insert_search, $dataParams, QueryWrapper::RETURN_INSERT_ID);
				    if ($saved_report_id === false) {
				        show_pdo_error($insert_search, $wrapperObj->getLastStatement());
				    }
				} else {
				    $dataParams = new QueryData();
				    $dataParams->addDataParam('i', $orchadmin_user_id);
				    $dataParams->addDataParam('s', $_SESSION['S_REPORT_TYPE']);
				    $dataParams->addDataParam('s', $report_title);
				    $dataParams->addDataParam('s', $description);
				    $dataParams->addDataParam('i', $duration);
				    $dataParams->addDataParam('s', $expiration_date);

				    $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']);
				if(sizeof($search_criteria) > 0 && is_array($search_criteria))
				{
					$insert_search_criteria = "";
					if ($wrapperObj instanceof QueryWrapper) {
					    $dataParams = [];
					    foreach($search_criteria as $i => $v) {
					        $insert_search_criteria .= ', (?, ?, ?)';
					        $dataParams[] = $saved_report_id;
					        $dataParams[] = $v['name'];
					        $dataParams[] = $v['value'];
					    }
					} else {
					    $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']);
					    }
					}
					$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;
					if ($wrapperObj instanceof QueryWrapper) {
					    if ($wrapperObj->executeQuery($insert_search_criteria, $dataParams, QueryWrapper::RETURN_INSERT_ID) === false) {
					        show_pdo_error($insert_search_criteria, $wrapperObj->getLastStatement());
					    }
					} else {
					    if ($wrapperObj->executeQuery($insert_search_criteria, $dataParams, MysqliWrapper::RETURN_INSERT_ID) === false) {
					        showierror($insert_search_criteria);
					    }
					}
				}

				$confirm_msg = 'fds554r5';
				header("location: /reports.php?confirm_msg=$confirm_msg");
				exit();
?>