$guid = $item->addChild('guid', $job->id . '@' . BASE_URL);
$guid->addAttribute('isPermaLink', "false");
$item->addChild('pubDate', date(DATE_RSS, strtotime($job->created)));
}
$dom = new DOMDocument();
$dom->preserveWhiteSpace = false;
$dom->formatOutput = true;
$dom->loadXML($xml->asXML());
echo $dom->saveXML();
});
// get category jobs
$app->get('/:id(/:name(/:page))', function ($id, $name = null, $page = 1) use($app) {
global $lang;
$id = (int) $id;
$cat = new Categories($id);
$categ = $cat->findCategory();
if (isset($categ) && $categ) {
$start = getPaginationStart($page);
$count = $cat->countCategoryJobs();
$number_of_pages = ceil($count / LIMIT);
$jobs = $cat->findCategoryJobs($start, LIMIT);
$seo_title = $categ->name . ' | ' . APP_NAME;
$seo_desc = excerpt($categ->description);
$seo_url = BASE_URL . "categories/{$id}/{$name}";
$app->render(THEME_PATH . 'categories.php', array('lang' => $lang, 'seo_url' => $seo_url, 'seo_title' => $seo_title, 'seo_desc' => $seo_desc, 'categ' => $categ, 'jobs' => $jobs, 'id' => $id, 'number_of_pages' => $number_of_pages, 'current_page' => $page, 'page_name' => 'categories'));
} else {
$app->flash('danger', $lang->t('alert|page_not_found'));
$app->redirect(BASE_URL, 404);
}
});
});
$is_series_list = false;
$timestamp = 0;
$is_cached = false;
$error_message = null;
$page = 1;
$number_of_pages = 1;
$number_of_results = -1;
$columns = [];
$datapoints = [];
if (!empty($_REQUEST['query'])) {
$query = $_REQUEST['query'];
$query = autoLimit($query);
$feedback = getDatabaseResults($query);
$columns = $feedback['results']['columns'];
$datapoints = $feedback['results']['datapoints'];
$timestamp = $feedback['timestamp'];
$is_cached = $feedback['is_cached'];
$page = $feedback['page'];
$is_series_list = isSeriesList($query);
$number_of_pages = $feedback['number_of_pages'];
$number_of_results = $feedback['number_of_results'];
$error_message = $feedback['error_message'];
}
debug("Timestamp column is: " . getTimestampColumn($columns));
// set template variables
// render template
$pagination_start = getPaginationStart($page, $number_of_pages);
echo $template->render(array('title' => 'Results', 'query' => $query, 'datapoints' => $datapoints, 'columns' => $columns, 'is_series_list' => $is_series_list, 'timestamp' => $timestamp, 'is_cached' => $is_cached, 'error_message' => $error_message, 'page' => $page, 'number_of_pages' => $number_of_pages, 'start_pagination' => $pagination_start, 'end_pagination' => getPaginationEnd($number_of_pages, $pagination_start), 'number_of_results' => $number_of_results, 'user' => $_SESSION['user'], 'host' => $_SESSION['host'], 'database' => $_SESSION['database'], 'timestamp_column' => getTimestampColumn($columns)));
} catch (Exception $e) {
die('ERROR: ' . $e->getMessage());
}
