function index()
{
$segmentor_name1 = 'segmentor.scws';
$segmentor_name2 = 'segmentor.ckip';
$segmentor_name3 = 'segmentor.yahoo';
$text = '今天今天繼續做昨天未完成的投影片。然後接續D11進度把Authorize Manager跟Context加入Domain跟Webpage中。';
$test_eng = 'Since learning English is very popular in non-English speaking countries, developing modern assisted-learning tools that support effective English learning is a critical issue in the English-language education field.';
$ex = '';
//$ex = '';
$text_scws1 = '今天 今天 繼續 做 昨天 未 完成 投影片 然後 接續 D11 進度 Authorize Manager 跟 Context 加入 Domain 跟 Webpage 中';
$text_scws2 = '今天/n 今天/n 繼續/vn 做/v 昨天/n 未/d 完成/un 投影片/n 然後/d 接續/v D11/en 進度/n Authorize/en Manager/en 跟/v Context/en 加入/un Domain/en 跟/v Webpage/en 中/f';
$text_ckip1 = '今天 今天 繼續 做 昨天 未 完成 的 投影片 。 然後 接續 D 11 進度 把 Authorize Manager 跟 Context 加入 Domain 跟 Webpage 中 。';
$text_ckip2 = '今天/N 今天/N 繼續/Vt 做/Vt 昨天/N 未/ADV 完成/Vt 的/T 投影片/N 。/PERIODCATEGORY 然後/ADV 接續/Vt D/FW 11/DET 進度/N 把/P Authorize/FW Manager/FW 跟/P Context/FW 加入/Vt Domain/FW 跟/P Webpage/FW 中/N 。/PERIODCATEGORY';
/*
$segmentor = Segmentor_factory::create($segmentor_name1);
$this->unit->run($segmentor->get_name()
, $segmentor_name1
, '測試Segmentor的get_name()');
$this->unit->run($segmentor->ignore_stopword
, FALSE
, '測試Segmentor的ignore_stopword');
$segmentor->set_ignore_stopword(TRUE);
$this->unit->run($segmentor->ignore_stopword
, TRUE
, '測試Segmentor的set_ignore_stopword()');
$this->unit->run($segmentor->text_to_segment($text, FALSE)
, $text_scws1.$ex
, '測試SCWS斷詞器');
$this->unit->run($segmentor->text_to_segment($text, TRUE)
, $text_scws2.$ex
, '測試SCWS斷詞器，包含詞性');
$segmentor = Segmentor_factory::create($segmentor_name2);
$this->unit->run($segmentor->text_to_segment($text, FALSE)
, $text_ckip1.$ex
, '測試CKIP斷詞器');
$this->unit->run($segmentor->text_to_segment($text, TRUE)
, $text_ckip2.$ex
, '測試CKIP斷詞器，包含詞性');
*/
$segmentor = Segmentor_factory::create($segmentor_name3);
$this->unit->run($segmentor->text_to_segment($text, FALSE), $text_ckip1 . $ex, '測試CKIP斷詞器');
$this->unit->run($segmentor->text_to_segment($text, TRUE), $text_ckip2 . $ex, '測試CKIP斷詞器，包含詞性');
$segmentor = Segmentor_factory::create('segmentor.disable');
$this->unit->run($segmentor->text_to_segment($text, FALSE), NULL, '測試disable斷詞器');
$this->unit->run($segmentor->text_to_segment($text, TRUE), NULL, '測試disable斷詞器，包含詞性');
// $this->unit->run($test_result
// , $expected_result
// , $test_name);
unit_test_report($this);
}
protected function _post_construct($table_name = NULL, $id = NULL)
{
$this->_CI_load('library', 'scope/Segmentor_factory', 'segmentor_factory');
$this->segmentor = Segmentor_factory::create();
$this->_CI_load('library', 'scope/Segmentor', 'segmentor');
}
private function _load_segmentor()
{
if (is_null($this->segmentor)) {
$this->_CI_load('library', 'scope/Segmentor_factory', 'segmentor_factory');
$this->segmentor = Segmentor_factory::create();
}
return $this;
}
public function setup_search()
{
//--------------------------------------------------
// 先取得設定，再進行查詢
//------------------------------------
//第一關 check auth * 設定
$annotation_type_id = NULL;
$action_id = NULL;
$current_user_id = NULL;
$current_user_type_id = NULL;
$current_group_id_list = array();
$current_group_type_id = NULL;
if ($this->check_auth === TRUE) {
//SELECT *
//FROM annotation
//LEFT JOIN policy
// ON policy.resource_id = annotation.annotation_id
// AND policy.resource_type_id = 3
// AND policy.action_id = 5
//LEFT JOIN policy2actor
// ON policy.policy_id = policy2actor.policy_id
// AND policy2actor.actor_type_id = 1
//WHERE
// (policy2actor.actor_id IS NULL OR
// policy2actor.actor_id = 123)
$this->_CI_load('library', 'kals_resource/Annotation', 'annotation');
$annotation_type_id = $this->CI->annotation->get_type_id();
$this->_CI_load('library', 'policy/Action_annotation_read', 'action_annotation_read');
$action_id = $this->CI->action_annotation_read->get_id();
$current_user = get_context_user();
if (is_class($current_user, 'User')) {
$current_user_id = $current_user->get_id();
$current_user_type_id = $current_user->get_type_id();
$groups = $current_user->get_parent_groups();
foreach ($groups as $group) {
if (is_null($current_group_type_id)) {
$current_group_type_id = $group->get_type_id();
}
$current_group_id_list[] = $group->get_id();
}
}
}
//if ($this->check_auth)
//-------------------------------------
//第三關 target_scope * 設定
$target_scope_in_sql = NULL;
if (isset($this->target_scope) && $this->target_scope->length() > 0) {
//SELECT annotation.annotation_id
//FROM annotation
//JOIN
// (SELECT distinct a2s.annotation_id
// FROM annotation
// JOIN annotation2scope AS a2s
// ON a2s.annotation_id = annotation.annotation_id
// LEFT OUTER JOIN scope AS s1
// ON s1.scope_id = a2s.scope_id
// AND s1.from_index = 3
// AND s1.to_index = 20
// LEFT OUTER JOIN scope AS s2
// ON s2.scope_id = a2s.scope_id
// AND s2.from_index = 26
// AND s2.to_index = 40
// GROUP BY a2s.annotation_id
// HAVING count(a2s.annotation_id) >= 2 )
//AS target_scope ON annotation.annotation_id = target_scope.annotation_id
$in_sql = 'SELECT DISTINCT a2s.annotation_id ' . ' FROM annotation2scope AS a2s ';
$where = '';
foreach ($this->target_scope as $key => $scope) {
$from = $scope->get_from_index();
$to = $scope->get_to_index();
$webpage_id = $scope->get_webpage_id();
$table_name = 's' . $key;
$in_sql = $in_sql . ' LEFT JOIN scope AS ' . $table_name . ' ON ' . $table_name . '.scope_id = a2s.scope_id' . ' AND ' . $table_name . '.webpage_id = ' . $webpage_id . ' AND ' . $table_name . '.from_index = ' . $from . ' AND ' . $table_name . '.to_index = ' . $to;
if ($where != '') {
$where .= ' OR ';
}
$where .= $table_name . '.scope_id IS NOT NULL ';
}
$in_sql = $in_sql . ' WHERE ' . $where . ' GROUP BY a2s.annotation_id ' . ' HAVING count(a2s.annotation_id) = ' . $this->target_scope->length();
$target_scope_in_sql = $in_sql;
}
//------------------------------------------------------
// 第四關 exclude_scope * 設定
$exclude_scope_in_sql = NULL;
if (isset($this->exclude_scope) && $this->exclude_scope->length() > 0) {
$in_sql = 'SELECT DISTINCT a2s.annotation_id ' . ' FROM annotation2scope AS a2s ';
$where = '';
foreach ($this->exclude_scope as $key => $scope) {
$from = $scope->get_from_index();
$to = $scope->get_to_index();
$webpage_id = $scope->get_webpage_id();
$table_name = 's' . $key;
$in_sql = $in_sql . ' LEFT JOIN scope AS ' . $table_name . ' ON ' . $table_name . '.scope_id = a2s.scope_id' . ' AND ' . $table_name . '.webpage_id = ' . $webpage_id . ' AND ' . $table_name . '.from_index = ' . $from . ' AND ' . $table_name . '.to_index = ' . $to;
if ($where != '') {
$where .= ' OR ';
}
$where .= $table_name . '.scope_id IS NOT NULL ';
}
$in_sql = $in_sql . ' WHERE ' . $where . ' GROUP BY a2s.annotation_id ' . ' HAVING count(a2s.annotation_id) = ' . $this->exclude_scope->length();
//減去現有的查詢
$in_sql = 'SELECT annotation.annotation_id FROM annotation EXCEPT ' . $in_sql;
$exclude_scope_in_sql = $in_sql;
}
//if (isset($this->exclude_scope))
//------------------------------------------------
// 第五關 overlap_scope * 設定
$overlap_scope_where = NULL;
$overlap_scope_join = array();
if (isset($this->overlap_scope) && $this->overlap_scope->length()) {
//SELECT distinct annotation.annotation_id
//FROM annotation
//JOIN annotation2scope AS a2s
// ON a2s.annotation_id = annotation.annotation_id
//JOIN scope AS s1
// ON s1.scope_id = a2s.scope_id
// AND ( (s1.from_index >= 23 AND s1.from_index <= 44)
// OR (s1.to_index >= 23 AND s1.to_index <= 44)
// OR (s1.from_index <= 23 AND s1.to_index >= 44))
$where = '';
$join_scopes = array();
foreach ($this->overlap_scope as $key => $scope) {
$webpage_id = $scope->get_webpage_id();
$from = $scope->get_from_index();
$to = $scope->get_to_index();
$table = 'overlap_scope_' . $key;
$join_scopes[] = array('webpage_id' => $webpage_id, 'from' => $from, 'to' => $to, 'table' => $table);
if ($where != '') {
$where .= ' OR ';
}
$where .= $table . '.scope_id IS NOT NULL ';
}
$overlap_scope_where = $where;
$overlap_scope_join = $join_scopes;
}
//------------------------------------------------
//第十關 search_note * 設定
//test_msg($this->search_note); //this->search_note空值
$search_note_query = NULL;
if (isset($this->search_note)) {
$query = $this->search_note;
$query_with_segment = TRUE;
if ($query_with_segment) {
if (is_null($this->segmentor)) {
$this->_CI_load('library', 'scope/Segmentor_factory', 'segmentor_factory');
$this->segmentor = Segmentor_factory::create_search_segmentor();
}
$query = $this->segmentor->text_to_query($query);
} else {
$this->_CI_load('library', 'scope/Segmentor', 'segmentor');
$query = Segmentor::segment_to_query($query);
}
$search_note_query = $query;
}
//------------------------------------------------
// 第十二關 search_anchor_text * 設定
$search_anchor_text_query = NULL;
$segmentor = $this->CI->config->item('segmentor.default');
if ($segmentor !== "segmentor.disable" && isset($this->search_anchor_text)) {
$query = $this->search_anchor_text;
$query_with_segment = TRUE;
if ($query_with_segment) {
if (is_null($this->segmentor)) {
$this->_CI_load('library', 'scope/Segmentor_factory', 'segmentor_factory');
$this->segmentor = Segmentor_factory::create_search_segmentor();
}
$query = $this->segmentor->text_to_query($query);
} else {
$this->_CI_load('library', 'scope/Segmentor', 'segmentor');
$query = Segmentor::segment_to_query($query);
}
$search_anchor_text_query = $query;
}
//if (isset($this->search_anchor_text))
//------------------------------------------------
// 第十三關 target_over_score * 設定
$target_over_score_type_id = NULL;
if (isset($this->target_over_score) && $this->target_over_score > 0) {
$this->_CI_load('library', 'score/Annotation_score_integrated', 'annotation_score_integrated');
$score_type_id = $this->CI->annotation_score_integrated->get_type_id();
$target_over_score_type_id = $score_type_id;
}
//-----------------------------------------------
//接著才是進入查詢
$db = $this->db;
//$db->from('annotation');
$db->where('annotation.deleted', 'FALSE');
if (isset($this->limit)) {
$db->limit($this->limit);
}
if (isset($this->offset)) {
$db->offset($this->offset);
}
//------------------------------------
//第一關 check auth * 查詢
if ($this->check_auth === TRUE) {
$db->join('policy', 'policy.resource_id = annotation.annotation_id ' . 'AND policy.resource_type_id = ' . $annotation_type_id . ' ' . 'AND policy.action_id = ' . $action_id, 'left');
$db->join('policy2actor', 'policy.policy_id = policy2actor.policy_id ', 'left');
if (isset($current_user_id)) {
$where = '(policy2actor.actor_id IS NULL ' . 'OR (policy2actor.actor_type_id = ' . $current_user_type_id . ' AND policy2actor.actor_id = ' . $current_user_id . ')';
foreach ($current_group_id_list as $group_id) {
$where .= ' OR (policy2actor.actor_type_id = ' . $current_group_type_id . 'AND policy2actor.actor_id = ' . $group_id . ' )';
}
$where .= ')';
$db->where($where);
} else {
$db->where('policy2actor.actor_id IS NULL');
}
}
//if ($this->check_auth)
//-------------------------------------
// 第二關 設定webpage_id(取得目前的webpage_id資料)
if (isset($this->target_webpage_id)) {
$db->join('webpage2annotation', 'webpage2annotation.annotation_id = annotation.annotation_id ' . ' AND webpage2annotation.webpage_id = ' . $this->target_webpage_id);
}
//if (isset($this->webpage_id))
//-------------------------------------
//第三關 target_scope * 查詢
if (isset($target_scope_in_sql)) {
$db->join('(' . $target_scope_in_sql . ') AS target_scope', 'target_scope.annotation_id = annotation.annotation_id');
}
//if (isset($this->target_scope))
//------------------------------------------------------
// 第四關 exclude_scope * 查詢
if (isset($exclude_scope_in_sql)) {
$db->join('(' . $exclude_scope_in_sql . ') AS exclude_scope', 'annotation.annotation_id = exclude_scope.annotation_id');
}
//if (isset($this->exclude_scope))
//------------------------------------------------
// 第五關 overlap_scope * 查詢
if (isset($overlap_scope_where)) {
$db->join('annotation2scope AS overlap_scope_annotation2scope', 'overlap_scope_annotation2scope.annotation_id = annotation.annotation_id');
$where = $overlap_scope_where;
$join_scopes = $overlap_scope_join;
foreach ($join_scopes as $scope) {
$webpage_id = $scope['webpage_id'];
$from = $scope['from'];
$to = $scope['to'];
$table = $scope['table'];
$db->join('scope AS ' . $table, $table . '.scope_id = overlap_scope_annotation2scope.scope_id ' . ' AND ' . $table . '.webpage_id = ' . $webpage_id . ' AND (' . ' (' . $table . '.from_index >= ' . $from . ' AND ' . $table . '.from_index <= ' . $to . ') ' . ' OR (' . $table . '.to_index >= ' . $from . ' AND ' . $table . '.to_index <= ' . $to . ') ' . ' OR (' . $table . '.from_index <= ' . $from . ' AND ' . $table . '.to_index >= ' . $to . ') ' . ' ) ', 'left');
}
$db->where('(' . $where . ')');
}
//if (isset($this->overlap_scope))
//------------------------------------------------
// 第六關 target_type_id
if (isset($this->target_type_id)) {
$db->where('annotation.annotation_type_id', $this->target_type_id);
}
//if (isset($this->target_type_id))
//------------------------------------------------
// 第6.5關 exclude_type_id_list
if (count($this->exclude_type_id_list) > 0) {
$db->where_not_in('annotation.annotation_type_id', $this->exclude_type_id_list);
}
//if (isset($this->target_type_id))
//------------------------------------------------
// 第七關 target_user_id
if (isset($this->target_user_id)) {
$db->where('annotation.user_id', $this->target_user_id);
}
//if (isset($this->target_type_id))
//------------------------------------------------
// 第八關 exclude_user_id
if (isset($this->exclude_user_id)) {
$db->where('annotation.user_id != ' . $this->exclude_user_id);
}
//if (isset($this->exclude_user_id))
//------------------------------------------------
// 第九關 exclude_annotaiton_id
if (isset($this->exclude_annotation_id)) {
$db->where('annotation.annotation_id != ' . $this->exclude_annotation_id);
}
//if (isset($this->exclude_annotation_id))
//------------------------------------------------
//第十關 search_note * 查詢 -分成使用斷詞器和不使用的情況(參考search_anchor_text)
//1.使用斷詞器
/* if (isset($this->search_note))
{
test_msg($this->search_note);
}
else {
$this->search_note = 0;
echo $this->search_note;
}*/
if ($segmentor !== "segmentor.disable" && isset($search_note_query)) {
$query = $search_note_query;
//$db->from('to_tsquery(\''.$query.'\') search_note_query');
$this->other_from[] = 'to_tsquery(\'' . $query . '\') search_note_query';
$db->where('annotation.note_index @@ search_note_query', NULL, FALSE);
}
//if (isset($this->search_note))
//2.不使用斷詞器的情況
//test_msg(array($segmentor, $this->search_note));
if ($segmentor === "segmentor.disable" && isset($this->search_note)) {
$db->like('note', $this->search_note);
// 生成: WHERE title LIKE '%match%'
//$db->limit(10);
//判斷this->search_note裡面有抓到值嗎？
/*if (isset($this->search_note))
{
test_msg($this->search_note);
}
else {
$this->search_note = 0;
echo $this->search_note;
}*/
}
//------------------------------------------------
// 第十一關 target_over_like 查詢
if (isset($this->target_over_like_count) && $this->target_over_like_count > 0) {
$db->join('annotation2like_count AS target_over_like', 'annotation.annotation_id = target_over_like.annotation_id ' . ' AND target_over_like.like_count > ' . $this->target_over_like_count);
}
//------------------------------------------------
// 第十二關 search_anchor_text * 查詢
if ($segmentor !== "segmentor.disable" && isset($search_anchor_text_query)) {
$query = $this->search_anchor_text_query;
$db->join('annotation2anchor_text AS search_anchor_text', 'search_anchor_text.annotation_id = annotation.annotation_id ' . 'AND search_anchor_text.indexed @@ to_tsquery(\'' . $query . '\')');
$this->other_from[] = 'to_tsquery(\'' . $query . '\') search_anchor_text_query';
}
//如果不使用斷詞器，就直接使用$this->search_anchor_text進行查詢，不使用query，搭配第二關 target_url 查詢使用
//test_msg(array($segmentor, $this->search_anchor_text));
if ($segmentor === "segmentor.disable" && isset($this->search_anchor_text)) {
$db->join('annotation2anchor_text AS search_anchor_text', 'search_anchor_text.annotation_id = annotation.annotation_id ' . "AND search_anchor_text.text like '%" . $this->search_anchor_text . "%'");
$db->limit(5);
//echo $this->webpage_id;
}
//if (isset($this->search_anchor_text))
//------------------------------------------------
// 第十三關 target_over_score * 查詢
if (isset($this->target_over_score) && $this->target_over_score > 0) {
$score_type_id = $target_over_score_type_id;
$db->join('score AS target_over_score', 'annotation.annotation_id = target_over_score.annotation_id ' . ' AND target_over_score.score_type_id = ' . $score_type_id . ' AND target_over_score.score >= ' . $this->target_over_score);
}
//------------------------------------------------
// 第十四關 target_newer_update * 查詢
if (isset($this->target_newer_update)) {
$db->where("annotation.update_timestamp > TIMESTAMP WITH TIME ZONE 'epoch' + " . $this->target_newer_update . " * INTERVAL '1 second'");
}
if (isset($this->target_newer_create)) {
$db->where("annotation.create_timestamp > TIMESTAMP WITH TIME ZONE 'epoch' + " . $this->target_newer_create . " * INTERVAL '1 second'");
}
if (isset($this->target_older_create)) {
$db->where("annotation.create_timestamp < TIMESTAMP WITH TIME ZONE 'epoch' + " . $this->target_older_create . " * INTERVAL '1 second'");
}
//------------------------------------------------
// 第十五關 target_topic * 查詢
if (isset($this->target_topic)) {
if ($this->target_topic === TRUE) {
$db->where("annotation.topic_id IS NULL");
} else {
$db->where("annotation.topic_id IS NOT NULL");
}
}
//------------------------------------------------
// 第十五.5關 target_topic_id * 查詢
if (isset($this->target_topic_id)) {
$db->where("annotation.topic_id", $this->target_topic_id);
}
//------------------------------------------------
// 第十六關 target_like * 查詢
if (isset($this->target_like)) {
if ($this->target_like === TRUE) {
$db->join('annotation2like AS target_like', 'annotation.annotation_id = target_like.annotation_id ' . ' AND target_like.user_id = ' . $this->target_like_user_id . ' AND target_like.canceled IS FALSE');
} else {
/*
$db->join('annotation2like AS target_like'
, 'annotation.annotation_id = annotation.annotation_id '
, 'left');
$db->where('((annotation.annotation_id = target_like.annotation_id '
. ' AND target_like.user_id = ' . $this->target_like_user_id
. ' AND target_like.canceled IS TRUE)'
. ' OR (target_like.annotation2like_id IS NULL))');
*/
$db->join('annotation2like AS target_like', 'annotation.annotation_id = target_like.annotation_id ', 'left');
/*
$db->where('( ( ( (target_like.user_id != ' . $this->target_like_user_id . ') OR'
. '( target_like.user_id = ' . $this->target_like_user_id . ' AND target_like.canceled IS TRUE) )'
. ' OR (target_like.annotation2like_id IS NULL) ) )');
*
*/
$db->where('( target_like.annotation_id IS NULL OR target_like.annotation_id NOT IN (SELECT annotation_id FROM annotation2like WHERE user_id = ' . $this->target_like_user_id . ' AND canceled = FALSE) )');
}
}
//------------------------------------------------
// 第十七關 target_url 查詢
//if (isset($this->target_url))
//{
//1.要把url轉成id再搜尋：先從表中用url找出webpage_id->使用filter_webpage_object來轉換url->webpage_id
//in webpage.php
//$this->webpage_id = $this->CI->webpage->filter_webpage_id($this->target_url);
//2.設定search條件
/* $db->join('webpage2annotation', 'webpage2annotation.annotation_id = annotation.annotation_id'
. 'AND webpage2annotation.webpage_id = '.$this->webpage_id);*/
//}
//------------------------------------------------
//第十八關 search_username 查詢
if (isset($this->search_username)) {
$db->join('user AS search_username', 'search_username.user_id = annotation.user_id ' . "AND search_username.name like '%" . $this->search_username . "%'");
// 20131113 Pudding Chen
// 為什麼要在這裡加limit？
//$db->limit(15);
}
//------------------------------------------------
// 大魔王 order *
$this->order_coll->setup_order($db);
return $db;
}
