public function actionBuild() { $batch_data = []; $date_now = date("Y-m-d H:i:s"); $this->echoLog("=========start build({$date_now})=========="); /*build blog*/ $post_list = Posts::find()->where(['status' => 1])->orderBy("id asc")->all(); if ($post_list) { foreach ($post_list as $_post_info) { $tmp_search_key = $_post_info['title'] . "#@#" . $_post_info['tags']; $batch_data[] = ["title" => $_post_info['title'], "description" => strip_tags($_post_info['content']), "book_id" => 0, "post_id" => $_post_info['id'], "search_key" => $tmp_search_key, "image" => $_post_info['image_url']]; } } $book_list = Book::find()->where(['status' => 1])->orderBy("id asc")->all(); if ($book_list) { foreach ($book_list as $_book_info) { $tmp_search_key = $_book_info['subtitle'] . "#@#" . $_book_info['tags']; $batch_data[] = ["title" => $_book_info['subtitle'], "description" => $_book_info['summary'], "book_id" => $_book_info['id'], "post_id" => 0, "search_key" => $tmp_search_key, "image" => GlobalUrlService::buildPic1Static($_book_info['image_url'], ['w' => 600])]; } } if ($batch_data && count($batch_data) > 0) { //批量插入速度快 foreach ($batch_data as $_item) { if (!$_item['post_id'] && !$_item['book_id']) { $this->echoLog("skip"); continue; } $query = IndexSearch::find(); if ($_item['post_id']) { $query->where(['post_id' => $_item['post_id']]); } else { $query->where(['book_id' => $_item['book_id']]); } $tmp_info = $query->one(); if ($tmp_info) { $model_index_search = $tmp_info; } else { $model_index_search = new IndexSearch(); $model_index_search->created_time = $date_now; } $tmp_description = str_replace(" ", " ", $_item['description']); $model_index_search->title = $_item['title']; $model_index_search->description = $tmp_description; $model_index_search->book_id = $_item['book_id']; $model_index_search->post_id = $_item['post_id']; $model_index_search->search_key = $_item['search_key']; $model_index_search->image = $_item['image']; $model_index_search->updated_time = $date_now; $model_index_search->save(0); } } }
public function actionDo() { $kw = trim($this->get("kw", "")); $p = intval($this->get("p", 1)); if (!$p) { $p = 1; } $data = []; if (!$kw) { return $this->redirect("/"); } $this->setTitle($kw); $pagesize = 10; $offset = ($p - 1) * $pagesize; $search_key = ['LIKE', 'search_key', '%' . strtr($kw, ['%' => '\\%', '_' => '\\_', '\\' => '\\\\']) . '%', false]; $query = IndexSearch::find()->where($search_key); $total_count = $query->count(); $list = $query->orderBy("id desc")->limit($pagesize)->offset($offset)->all(); if ($list) { $book_mapping = DataHelper::getDicByRelateID($list, Book::className(), "book_id", "id", ["subtitle", "summary", "origin_image_url", "tags"]); $post_mapping = DataHelper::getDicByRelateID($list, Posts::className(), "post_id", "id", ["title", "content", "tags"]); foreach ($list as $_item) { if ($_item['book_id']) { $tmp_target = $book_mapping[$_item['book_id']]; $tmp_content = mb_substr($tmp_target['summary'], 0, 105, "utf-8"); $tmp_title = DataHelper::encode($tmp_target['subtitle']); $tmp_view_url = Url::toRoute("/library/detail/{$_item['book_id']}"); } else { $tmp_target = $post_mapping[$_item['post_id']]; $tmp_content = UtilHelper::blog_summary($tmp_target['content'], 105); $tmp_title = DataHelper::encode($tmp_target['title']); $tmp_view_url = Url::toRoute("/default/{$_item['post_id']}"); } $tags = explode(",", $tmp_target['tags']); $data[] = ['title' => $tmp_title, 'content' => nl2br($tmp_content), 'tags' => $tags, 'date' => date("Y年m月d日"), 'view_url' => $tmp_view_url]; } } $page_info = DataHelper::ipagination(["total_count" => $total_count, "page_size" => $pagesize, "page" => $p, "display" => 5]); return $this->render("result", ["data" => $data, "page_info" => $page_info, "urls" => ["page_base" => Url::toRoute(["/search/do", "kw" => $kw])]]); }
public function actionDo() { $data = []; $kw = $this->get("kw", ""); if ($kw) { $this->setTitle($kw); $search_key = ['LIKE', 'search_key', '%' . strtr($kw, ['%' => '\\%', '_' => '\\_', '\\' => '\\\\']) . '%', false]; $query = IndexSearch::find()->where($search_key); $list = $query->orderBy("id desc")->all(); if ($list) { foreach ($list as $_item) { if ($_item['book_id']) { $tmp_title = DataHelper::encode($_item['title']); $tmp_view_url = UrlService::buildWapUrl("/library/info", ['id' => $_item['book_id']]); } else { $tmp_title = DataHelper::encode($_item['title']); $tmp_view_url = UrlService::buildWapUrl("/default/info", ['id' => $_item['post_id']]); } $data[] = ['title' => $tmp_title, 'content' => nl2br(UtilHelper::blog_short($_item['description'], 200)), 'image_url' => $_item['image'], 'view_url' => $tmp_view_url]; } } } return $this->render("do", ["post_list" => $data, 'kw' => $kw]); }
private function getDataByKeyword($keyword, $fromUsername = '') { $search_key = ['LIKE', 'search_key', '%' . strtr($keyword, ['%' => '\\%', '_' => '\\_', '\\' => '\\\\']) . '%', false]; $mixed_list = IndexSearch::find()->where($search_key)->orderBy("id desc")->limit(5)->all(); $list = []; if ($mixed_list) { $domain_static = \Yii::$app->params['domains']['static']; foreach ($mixed_list as $_item) { $tmp_image = "{$domain_static}/wx/" . mt_rand(1, 7) . ".jpg"; if ($_item['image']) { $tmp_image = $_item['image']; } if ($_item['post_id']) { $tmp_url = GlobalUrlService::buildWapUrl("/default/info", ['id' => $_item['post_id'], 'woid' => trim($fromUsername)]); } else { $tmp_url = GlobalUrlService::buildWapUrl("/library/info", ['id' => $_item['book_id'], 'woid' => trim($fromUsername)]); } $list[] = ["title" => $_item['title'], "description" => $_item['title'], "picurl" => $tmp_image, "url" => $tmp_url]; } } $data = $list ? $this->getRichXml($list) : $this->help(); $type = $list ? "rich" : "text"; return ['type' => $type, "data" => $data]; }