public function invokeHandler(RequestData $data, $search = "")
{
$order_by = $data->get("order_by", "updated");
$search_by = $data->get("search_by", "title");
$categories = $data->get("categories", array());
$language = $data->get("language", "");
$type = $data->get("type", "");
$stories = new Stories();
$stories->RELEVANCE = empty($search) ? 0 : 0.1;
$stories->setCategories($categories);
$stories->setClasses($type, $language);
if ($search_by == 'title') {
$stories_results = $stories->searchByTitle($search, 0, $order_by);
} else {
if ($search_by == 'text') {
$stories_results = $stories->searchByText($search, 0, $order_by);
} else {
$stories_results = $stories->searchByAll($search, 0, $order_by);
}
}
if (count($stories_results)) {
// echo "REPLACE INTO search_cache(search_text) values(".$search.")";
$RDb = DBService::getDB();
$res = $RDb->update("REPLACE INTO search_cache(search_text) values('" . $search . "')");
}
// print_r($stories->get(0));
return $stories_results;
}
/**
*
* @param Smarty $viewModel
* @param Header $header
* @param DataModel $dataModel
* @param User $user
* @param string $view
* @param string $module
* @return string
*/
public function invokeHandler(User $user, $view = "empty", $module = "index_page", RequestData $data, $info = "NO")
{
if ($info == "STATS") {
return new WebSite();
} else {
if ($info == "CATEGORIES") {
return new Categories();
} else {
if ($info == "CLASSES") {
$RDb = DBService::getDB();
return $RDb->fetchAll("SELECT class_id id, class_name name, classtype_id, classtype_name,classtype_title\n\t\t\t\t\tFROM `fanfiction_classes` as c,fanfiction_classtypes as ct \n\t\t\t\t\tWHERE ct.classtype_id=c.class_type");
}
}
}
return $data;
}
public function invokeHandler(RequestData $data)
{
$search = $data->get("search", "");
$response = array();
$RDb = DBService::getDB();
$res = $RDb->fetchAll("SELECT * FROM search_cache\n\t\t\t\tWHERE UPPER(search_text) like UPPER(%s)\n\t\t\t\tORDER BY search_text", "'%" . $search . "%'");
if (count($res) == 0) {
$res = $RDb->fetchAll("SELECT title as search_text FROM fanfiction_stories\n\t\t\t\t\tWHERE UPPER(title) like UPPER(%s)\n\t\t\t\t\tORDER BY title", "'%" . $search . "%'");
}
if (count($res) == 0) {
$response['error'] = true;
return false;
} else {
$response['data'] = $res;
$response['error'] = false;
return $response;
}
}
