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; } }