<?php // (2021.1.13, 차재복, Cha Jae Bok, cjbword@gmailcom)
# 특정 검색 선택 처리 함수
function choice ($ch) {
// 선택
switch ($ch) {
case ('comp') :
case ('1') :
$query = "select a.*,b.*,date_format(b.sujung,'%Y-%m-%d') as date from dict_word_list a join cjb_dict b on a.no=b.no where a.word like '%비교' or a.word like '%차이' group by a.no order by a.word";
$title = "비교 리스트";
break;
case ('type') :
case ('2') :
$query = "select a.*,b.*,date_format(b.sujung,'%Y-%m-%d') as date from dict_word_list a join cjb_dict b on a.no=b.no where a.word like '%구분' or a.word like '%종류' group by a.no order by a.word";
$title = "구분/종류 리스트";
break;
case ('formula') :
case ('3') :
$query = "select a.*,b.*,date_format(b.sujung,'%Y-%m-%d') as date from dict_word_list a join cjb_dict b on a.no=b.no where a.word like '% 공식' or a.word like '% 방정식' group by a.no order by a.word";
$title = "공식/방정식 리스트";
break;
case ('law') :
case ('4') :
$query = "select a.*,b.*,date_format(b.sujung,'%Y-%m-%d') as date from dict_word_list a join cjb_dict b on a.no=b.no where a.word like '% 법칙' group by a.no order by a.word";
$title = "법칙 리스트";
break;
case ('theory') :
case ('5') :
$query = "select a.*,b.*,date_format(b.sujung,'%Y-%m-%d') as date from dict_word_list a join cjb_dict b on a.no=b.no where a.word like '% 이론' group by a.no order by a.word";
$title = "이론 리스트";
break;
case ('principle') :
case ('6') :
$query = "select a.*,b.*,date_format(b.sujung,'%Y-%m-%d') as date from dict_word_list a join cjb_dict b on a.no=b.no where a.word like '% 원리' group by a.no order by a.word";
$title = "원리 리스트";
break;
case ('theorem') :
case ('7') :
$query = "select a.*,b.*,date_format(b.sujung,'%Y-%m-%d') as date from dict_word_list a join cjb_dict b on a.no=b.no where a.word like '% 정리' group by a.no order by a.word";
$title = "정리 리스트";
break;
case ('discipline') :
case ('8') :
$query = "select a.*,b.*,date_format(b.sujung,'%Y-%m-%d') as date from dict_word_list a join cjb_dict b on a.no=b.no where a.word like '%학' group by a.no order by a.word";
$title = "학문 리스트";
break;
case ('mode') :
case ('9') :
$query = "select a.*,b.*,date_format(b.sujung,'%Y-%m-%d') as date from dict_word_list a join cjb_dict b on a.no=b.no where a.word like '%모드%' group by a.no order by a.word";
$title = "모드 리스트";
break;
case ('function') :
case ('10') :
$query = "select a.*,b.*,date_format(b.sujung,'%Y-%m-%d') as date from dict_word_list a join cjb_dict b on a.no=b.no where a.word like '%함수' group by a.no order by a.word";
$title = "함수 리스트";
break;
case ('ratio') :
case ('11') :
$query = "select a.*,b.*,date_format(b.sujung,'%Y-%m-%d') as date from dict_word_list a join cjb_dict b on a.no=b.no where (a.word like '%율' or a.word like '%률' or a.word like '%비') and not (a.word like '%효율' or a.word like '%확률' or a.word like '%적률' or a.word like '%법률' or a.word like '%일률' or a.word like '%능률' or a.word like '%설비' or a.word like '%장비' or a.word like '%좀비' or a.word like '%유지비' or a.word like '%공사비' or a.word like '%상각비' or a.word like '%지그비') group by a.no order by a.word";
$title = "율/률/비 리스트";
break;
case ('coef') :
case ('12') :
$query = "select a.*,b.*,date_format(b.sujung,'%Y-%m-%d') as date from dict_word_list a join cjb_dict b on a.no=b.no where (a.word like '%계수') group by a.no order by a.word";
$title = "계수 리스트";
break;
case ('constant') :
case ('13') :
$query = "select a.*,b.*,date_format(b.sujung,'%Y-%m-%d') as date from dict_word_list a join cjb_dict b on a.no=b.no where (a.word like '%상수' or a.word like '%정수') group by a.no order by a.word";
$title = "정수/상수 리스트";
break;
case ('factor') :
case ('14') :
$query = "select a.*,b.*,date_format(b.sujung,'%Y-%m-%d') as date from dict_word_list a join cjb_dict b on a.no=b.no where ((a.word like '%인수') or (a.word like '%인자') or (a.word like '%인수 분해') or (a.word like '% factor')) and not (a.word like '%라인수' or a.word like '%합병 인수' or a.word like '%품질 인자') group by a.no order by a.word";
$title = "인수/인자,율/률 (factor) 리스트";
break;
case ('order') :
case ('15') :
$query = "select a.*,b.*,date_format(b.sujung,'%Y-%m-%d') as date from dict_word_list a join cjb_dict b on a.no=b.no where (a.word like '%order%') and (a.word like '%zero%' or a.word like '%first%' or a.word like '%second%' or a.word like '%tree%' or a.word like '%equation%') and not (a.word like '%byte%' or a.word like '%ordered%') group by a.no order by a.word";
$title = "차수/계수 (order) 리스트";
break;
case ('density') :
case ('16') :
$query = "select a.*,b.*,date_format(b.sujung,'%Y-%m-%d') as date from dict_word_list a join cjb_dict b on a.no=b.no where (a.word like '%밀도%') and not (a.word like '%정밀도%') group by a.no order by a.word";
$title = "밀도(density) 리스트";
break;
case ('degree') :
case ('17') :
$query = "select a.*,b.*,date_format(b.sujung,'%Y-%m-%d') as date from dict_word_list a join cjb_dict b on a.no=b.no where (a.word like '%degree%') group by a.no order by a.word";
$title = "차수/계수(degree) 리스트";
break;
case ('energy') :
case ('18') :
$query = "select a.*,b.*,date_format(b.sujung,'%Y-%m-%d') as date from dict_word_list a join cjb_dict b on a.no=b.no where (a.word like '%에너지%') group by a.no order by a.word";
$title = "에너지 리스트";
break;
case ('power') :
case ('19') :
$query = "select a.*,b.*,date_format(b.sujung,'%Y-%m-%d') as date from dict_word_list a join cjb_dict b on a.no=b.no where (a.word like '%전력%') and not (a.word like '%회전력%') group by a.no order by a.word";
$title = "전력 리스트";
break;
case ('velocity') :
case ('20') :
$query = "select a.*,b.*,date_format(b.sujung,'%Y-%m-%d') as date from dict_word_list a join cjb_dict b on a.no=b.no where (a.word like '%속도' or a.word like '%속도 벡터' or a.word like '%속도장' or a.word like '%속도계' or a.word like '%광속 불변%') group by a.no order by a.word";
$title = "속도 리스트";
break;
case ('field') :
case ('21') :
$query = "select a.*,b.*,date_format(b.sujung,'%Y-%m-%d') as date
from dict_word_list a join cjb_dict b on a.no=b.no
where concat(',',full_name,',',extra_keyword,',') like '%field,%'
and concat(',',full_name,',',korean,',',extra_keyword,',') like '%장,%'
group by a.no order by a.word";
$title = "장(場) 리스트";
break;
case ('reform') :
$title = "개선 진행중";
break;
case ('coding') :
$title = "작성중 (코딩이란?)";
break;
default :
exit;
}
return array('title'=>$title, 'query'=>$query);
}
# 특정 검색 선택 처리 함수
function choice_v2 () {
return [
"1" => [
"query" => "select a.*,b.*,date_format(b.sujung,'%Y-%m-%d') as date
from dict_word_list a join cjb_dict b on a.no=b.no
where a.word like '%비교' or a.word like '%차이'
group by a.no order by a.word",
"title" => "비교 리스트",
"alias" => "비교",
"desc" => "유사 용어들 간의 비교 (같음/닮음/다름)"
],
"2" => [
"query" => "select a.*,b.*,date_format(b.sujung,'%Y-%m-%d') as date
from dict_word_list a join cjb_dict b on a.no=b.no
where a.word like '%구분' or a.word like '%종류'
group by a.no order by a.word",
"title" => "구분/종류 리스트",
"alias" => "종류",
"desc" => "특정 기술 용어별 종류/구분 등"
],
"3" => [
"query" => "select a.*,b.*,date_format(b.sujung,'%Y-%m-%d') as date
from dict_word_list a join cjb_dict b on a.no=b.no
where a.word like '% 공식' or a.word like '% 방정식'
group by a.no order by a.word",
"title" => "공식/방정식 리스트",
"alias" => "공식",
"desc" => "각종 주요 공식,방정식 등"
],
"4" => [
"query" => "select a.*,b.*,date_format(b.sujung,'%Y-%m-%d') as date
from dict_word_list a join cjb_dict b on a.no=b.no
where a.word like '% 법칙'
group by a.no order by a.word",
"title" => "법칙 리스트",
"alias" => "법칙",
"desc" => "자연과학 법칙들"
],
"5" => [
"query" => "select a.*,b.*,date_format(b.sujung,'%Y-%m-%d') as date
from dict_word_list a join cjb_dict b on a.no=b.no
where a.word like '% 이론'
group by a.no order by a.word",
"title" => "이론 리스트",
"alias" => "이론",
"desc" => "자연과학 이론들"
],
"6" => [
"query" => "select a.*,b.*,date_format(b.sujung,'%Y-%m-%d') as date
from dict_word_list a join cjb_dict b on a.no=b.no
where a.word like '% 원리'
group by a.no order by a.word",
"title" => "원리 리스트",
"alias" => "원리",
"desc" => "주요 원리들"
],
"7" => [
"query" => "select a.*,b.*,date_format(b.sujung,'%Y-%m-%d') as date
from dict_word_list a join cjb_dict b on a.no=b.no
where a.word like '% 정리'
group by a.no order by a.word",
"title" => "정리 리스트",
"alias" => "정리",
"desc" => "주요 정리들"
],
"8" => [
"query" => "select a.*,b.*,date_format(b.sujung,'%Y-%m-%d') as date
from dict_word_list a join cjb_dict b on a.no=b.no
where a.word like '%학'
group by a.no order by a.word",
"title" => "학문 리스트",
"alias" => "학문",
"desc" => "학문 분야 구분"
],
"9" => [
"query" => "select a.*,b.*,date_format(b.sujung,'%Y-%m-%d') as date
from dict_word_list a join cjb_dict b on a.no=b.no
where a.word like '%모드%'
group by a.no order by a.word",
"title" => "모드 리스트",
"alias" => "모드",
"desc" => "( mode )"
],
"10" => [
"query" => "select a.*,b.*,date_format(b.sujung,'%Y-%m-%d') as date
from dict_word_list a join cjb_dict b on a.no=b.no
where a.word like '%함수'
group by a.no order by a.word",
"title" => "함수 리스트",
"alias" => "함수",
"desc" => "( function )"
],
"11" => [
"query" => "select a.*,b.*,date_format(b.sujung,'%Y-%m-%d') as date
from dict_word_list a join cjb_dict b on a.no=b.no
where (a.word like '%율' or a.word like '%률' or a.word like '%비') and not (a.word like '%효율' or a.word like '%확률' or a.word like '%적률' or a.word like '%법률' or a.word like '%일률' or a.word like '%능률' or a.word like '%설비' or a.word like '%장비' or a.word like '%좀비' or a.word like '%유지비' or a.word like '%공사비' or a.word like '%상각비' or a.word like '%지그비')
group by a.no order by a.word",
"title" => "율/률/비 리스트",
"alias" => "율/률/비",
"desc" => "( ratio/proportion/rate fraction percentage concentration )"
],
"13" => [
"query" => "select a.*,b.*,date_format(b.sujung,'%Y-%m-%d') as date
from dict_word_list a join cjb_dict b on a.no=b.no
where (a.word like '%상수' or a.word like '%정수')
group by a.no order by a.word",
"title" => "정수/상수 리스트",
"alias" => "정수/상수",
"desc" => "( constant )"
],
"14" => [
"query" => "select a.*,b.*,date_format(b.sujung,'%Y-%m-%d') as date
from dict_word_list a join cjb_dict b on a.no=b.no
where ((a.word like '%인수') or (a.word like '%인자') or (a.word like '%인수 분해') or (a.word like '% factor')) and not (a.word like '%라인수' or a.word like '%합병 인수' or a.word like '%품질 인자')
group by a.no order by a.word",
"title" => "인수/인자,율/률 (factor) 리스트",
"alias" => "인자(factor)",
"desc" => "( factor )"
],
"12" => [
"query" => "select a.*,b.*,date_format(b.sujung,'%Y-%m-%d') as date
from dict_word_list a join cjb_dict b on a.no=b.no
where (a.word like '%계수')
group by a.no order by a.word",
"title" => "계수 리스트",
"alias" => "계수(coefficient)",
"desc" => "( coefficient )"
],
"15" => [
"query" => "select a.*,b.*,date_format(b.sujung,'%Y-%m-%d') as date
from dict_word_list a join cjb_dict b on a.no=b.no
where (a.word like '%order%') and (a.word like '%zero%' or a.word like '%first%' or a.word like '%second%' or a.word like '%tree%' or a.word like '%equation%') and not (a.word like '%byte%' or a.word like '%ordered%')
group by a.no order by a.word",
"title" => "차수/계수 (order) 리스트",
"alias" => "계수(order)",
"desc" => "( order )"
],
"17" => [
"query" => "select a.*,b.*,date_format(b.sujung,'%Y-%m-%d') as date
from dict_word_list a join cjb_dict b on a.no=b.no
where (a.word like '%degree%')
group by a.no order by a.word",
"title" => "차수/계수 (degree) 리스트",
"alias" => "차수(degree)",
"desc" => "( degree )"
],
"16" => [
"query" => "select a.*,b.*,date_format(b.sujung,'%Y-%m-%d') as date
from dict_word_list a join cjb_dict b on a.no=b.no
where (a.word like '%밀도%') and not (a.word like '%정밀도%')
group by a.no order by a.word",
"title" => "밀도 (density) 리스트",
"alias" => "밀도",
"desc" => "( density )"
],
"18" => [
"query" => "select a.*,b.*,date_format(b.sujung,'%Y-%m-%d') as date
from dict_word_list a join cjb_dict b on a.no=b.no
where (a.word like '%에너지%')
group by a.no order by a.word",
"title" => "에너지 리스트",
"alias" => "에너지",
"desc" => "( energy )"
],
"19" => [
"query" => "select a.*,b.*,date_format(b.sujung,'%Y-%m-%d') as date
from dict_word_list a join cjb_dict b on a.no=b.no
where (a.word like '%전력%') and not (a.word like '%회전력%')
group by a.no order by a.word",
"title" => "전력 리스트",
"alias" => "전력",
"desc" => "( power )"
],
"20" => [
"query" => "select a.*,b.*,date_format(b.sujung,'%Y-%m-%d') as date
from dict_word_list a join cjb_dict b on a.no=b.no
where (a.word like '%속도' or a.word like '%속도 벡터' or a.word like '%속도장' or a.word like '%속도계' or a.word like '%광속 불변%')
group by a.no order by a.word",
"title" => "속도 리스트",
"alias" => "속도",
"desc" => "( velocity )"
],
"21" => [
"query" => "select a.*,b.*,date_format(b.sujung,'%Y-%m-%d') as date
from dict_word_list a join cjb_dict b on a.no=b.no
where concat(',',full_name,',',extra_keyword,',') like '%field,%' and concat(',',full_name,',',korean,',',extra_keyword,',') like '%장,%'
group by a.no order by a.word",
"title" => "장(場) 리스트",
"alias" => "장(場)",
"desc" => "( field )"
]
];
}
?>