");
}
else{
include $dir_language."default.php";
}
$op=$_GET["op"];
$word=mb_strtolower($_GET["word"],'UTF-8');
$org_word=$word;
$count_return=0;
$dict_list=array();
global $PDO;
switch($op){
case "pre"://预查询
$dictFileName=_FILE_DB_WORD_INDEX_;
PDO_Connect("sqlite:$dictFileName");
echo "";
$query = "select word,count from wordindex where \"word_en\" like ".$PDO->quote($word.'%')." OR \"word\" like ".$PDO->quote($word.'%')." limit 0,50";
echo $query;
$Fetch = PDO_FetchAll($query);
$iFetch=count($Fetch);
if($iFetch>0){
for($i=0;$i<$iFetch;$i++){
$word=$Fetch[$i]["word"];
$count=$Fetch[$i]["count"];
echo "
";
}
}
echo "
字典 ";
//获取书名
$arrBookName=json_decode(file_get_contents("../public/book_name/sc.json"));
echo "";
//加语尾
$arrNewWord=array();
for ($row = 0; $row < count($case); $row++) {
$len=mb_strlen($case[$row][0],"UTF-8");
$end=mb_substr($word, 0-$len,NULL,"UTF-8");
if($end==$case[$row][0]){
$newWord=mb_substr($word, 0,mb_strlen($word,"UTF-8")-$len,"UTF-8").$case[$row][1];
$arrNewWord[$newWord]=1;
}
}
//加连读词尾
$arrUnWord=array();
for ($row = 0; $row < count($union); $row++) {
$len=mb_strlen($union[$row][0],"UTF-8");
foreach($arrNewWord as $x=>$x_value){
$end=mb_substr($x, 0-$len,NULL,"UTF-8");
if($end==$union[$row][0]){
$newWord=mb_substr($x, 0,mb_strlen($x,"UTF-8")-$len,"UTF-8").$union[$row][1];
$arrUnWord[$newWord]=1;
}
}
}
//将连读词和$arrNewWord混合
foreach($arrUnWord as $x=>$x_value){
$arrNewWord[$x]=1;
}
if(count($arrNewWord)>0){
$strQueryWord="(";
foreach($arrNewWord as $x=>$x_value) {
$strQueryWord.="'{$x}',";
}
$strQueryWord=mb_substr($strQueryWord, 0,mb_strlen($strQueryWord,"UTF-8")-1,"UTF-8");
$strQueryWord.=")";
}
else{
$strQueryWord="('{$word}')";
}
//主显示区开始
echo "
";
//主显示区左侧开始
echo "
";
echo "
".$module_gui_str['search']['1001']." ";
/*查找实际出现的拼写
*/
$dictFileName=_FILE_DB_WORD_INDEX_;
PDO_Connect("sqlite:$dictFileName");
$query = "select id,word,count from wordindex where \"word\" in $strQueryWord";
$arrRealWordList = PDO_FetchAll($query);
$countWord=count($arrRealWordList);
echo "$word
共{$countWord}单词符合
";
$strQueryWordId="(";//实际出现的单词id查询字串
$aQueryWordList=array();//id 为键 拼写为值的数组
$aShowWordList=array();//拼写为键 个数为值的数组
$aShowWordIdList=array();//拼写为键 值Id的数组
for($i=0;$i<$countWord;$i++){
$value= $arrRealWordList[$i];
$strQueryWordId.="'{$value["id"]}',";
$aQueryWordList["{$value["id"]}"]=$value["word"];
$aShowWordList[$value["word"]]=$value["count"];
$aShowWordIdList[$value["word"]]=$value["id"];
}
$strQueryWordId=mb_substr($strQueryWordId, 0,mb_strlen($strQueryWordId,"UTF-8")-1,"UTF-8");
$strQueryWordId.=")";
//显示单词列表
echo "
";
echo "
全选
";
arsort($aShowWordList);
$i=0;
foreach($aShowWordList as $x=>$x_value) {
$wordid=$aShowWordIdList[$x];
echo "
";
echo "
";
echo $x.":".$x_value." ";
$i++;
}
echo "
";
echo "
";
//查找这些词出现在哪些书中
$dictFileName=_FILE_DB_BOOK_WORD_;
PDO_Connect("sqlite:$dictFileName");
$query = "SELECT book,sum(count) as co FROM bookword WHERE \"wordindex\" IN $strQueryWordId GROUP BY book LIMIT 0,217";
$Fetch = PDO_FetchAll($query);
$iFetch=count($Fetch);
if($iFetch>0){
$aWordInBook=array();
foreach($Fetch as $xBook){
$aWordInBook["{$xBook["book"]}"]=$xBook["co"];
}
arsort($aWordInBook);
echo "
";
echo "出现在{$iFetch}本书中：
";
echo "
全选
";
$i=0;
foreach($aWordInBook as $x=>$x_value) {
$book=$x;
$bookname=$arrBookName[$book-1]->title;
echo "
";
echo "
";
echo "《{$bookname}》:{$x_value}次 ";
$i++;
}
echo "
";
echo "
";
}
//查找这些词出现在哪些书中结束
echo "
";
//黑体字主显示区左侧结束
//黑体字主显示区右侧开始
echo "
";
//前20条记录
$dictFileName=_FILE_DB_WORD_INDEX_;
PDO_Connect("sqlite:$dictFileName");
$query = "SELECT book,paragraph, wordindex FROM word WHERE \"wordindex\" in $strQueryWordId LIMIT 0,20";
$Fetch = PDO_FetchAll($query);
$iFetch=count($Fetch);
if($iFetch>0){
$dictFileName=_FILE_DB_PALITEXT_;
PDO_Connect("sqlite:$dictFileName");
for($i=0;$i<$iFetch;$i++){
$paliwordid=$Fetch[$i]["wordindex"];
$paliword=$aQueryWordList["{$paliwordid}"];
$book=$Fetch[$i]["book"];
$paragraph=$Fetch[$i]["paragraph"];
$bookname=$arrBookName[$book-1]->title;
$c1=$arrBookName[$book-1]->c1;
echo "
";
echo "
《{$bookname}》 $c1
";
echo "
$paliword
";
{
$query = "select * from vri_text where \"book\" = '{$book}' and \"paragraph\" = '{$paragraph}' limit 0,1";
$FetchPaliText = PDO_FetchAll($query);
$countPaliText=count($FetchPaliText);
if($countPaliText>0){
for($iPali=0;$iPali<$countPaliText;$iPali++){
if(substr($paliword,-1)=="n"){
$paliword=substr($paliword,0,-1);
}
$light_text=str_replace($paliword,"
{$paliword} ",$FetchPaliText[$iPali]["vri_text"]);
echo "
{$light_text}
";
}
}
}
echo "
";
}
}
echo "
";
//黑体字主显示区右侧结束
echo "
";
//黑体字主显示区结束
echo "
$strDictTab
";
break;
case "update":
$target=$_GET["target"];
switch($target){
case "bold";
$arrBookName=json_decode(file_get_contents("../public/book_name/sc.json"));
$arrBookType=json_decode(file_get_contents("../public/book_name/booktype.json"));
$dictFileName=_FILE_DB_BOOK_WORD_;
PDO_Connect("sqlite:$dictFileName");
$wordlist=$_GET["wordlist"];
$booklist=$_GET["booklist"];
$aBookList=ltrim($booklist,"(");
$aBookList=rtrim($aBookList,")");
$aBookList=str_replace("'","",$aBookList);
$aBookList=str_getcsv($aBookList);
foreach($aBookList as $oneBook){
$aInputBook["{$oneBook}"]=1;
}
//查找这些词出现在哪些书中
$query = "select book,sum(count) as co from bookword where \"wordindex\" in $wordlist group by book order by co DESC";
$Fetch = PDO_FetchAll($query);
$iFetch=count($Fetch);
if($iFetch>0){
$booktypesum["vinaya"]=array(0,0);
$booktypesum["sutta"]=array(0,0);
$booktypesum["abhidhamma"]=array(0,0);
$booktypesum["anna"]=array(0,0);
$booktypesum["mula"]=array(0,0);
$booktypesum["atthakattha"]=array(0,0);
$booktypesum["tika"]=array(0,0);
$booktypesum["anna2"]=array(0,0);
for($i=0;$i<$iFetch;$i++){
$book=$Fetch[$i]["book"];
$sum=$Fetch[$i]["co"];
$t1=$arrBookType[$book-1]->c1;
$t2=$arrBookType[$book-1]->c2;
if(isset($booktypesum[$t1])){
$booktypesum[$t1][0]++;
$booktypesum[$t1][1]+=$sum;
}
else{
$booktypesum[$t1][0]=1;
$booktypesum[$t1][1]=$sum;
}
if(isset($booktypesum[$t2])){
$booktypesum[$t2][0]++;
$booktypesum[$t2][1]+=$sum;
}
else{
$booktypesum[$t2][0]=1;
$booktypesum[$t2][1]=$sum;
}
}
echo "";
}
//查找这些词出现在哪些书中结束
//前20条记录
$dictFileName=_FILE_DB_WORD_INDEX_;
PDO_Connect("sqlite:$dictFileName");
$query = "select * from word where \"wordindex\" in $wordlist and \"book\" in $booklist group by book,paragraph limit 0,20";
$Fetch = PDO_FetchAll($query);
$iFetch=count($Fetch);
if($iFetch>0){
$dictFileName=_FILE_DB_PALITEXT_;
PDO_Connect("sqlite:$dictFileName");
for($i=0;$i<$iFetch;$i++){
$paliword=$Fetch[$i]["wordindex"];
$book=$Fetch[$i]["book"];
$bookname=$arrBookName[$book-1]->title;
$c1=$arrBookName[$book-1]->c1;
$c2=$arrBookName[$book-1]->c2;
$paragraph=$Fetch[$i]["paragraph"];
echo "";
echo "
《{$bookname}》 $c1 $c2
";
echo "
$paliword
";
$query = "select * from vri_text where \"book\" = '{$book}' and \"paragraph\" = '{$paragraph}' limit 0,20";
$FetchPaliText = PDO_FetchAll($query);
$countPaliText=count($FetchPaliText);
if($countPaliText>0){
for($iPali=0;$iPali<$countPaliText;$iPali++){
if(substr($paliword,-1)=="n"){
$paliword=substr($paliword,0,-1);
}
$light_text=str_replace($paliword,"
{$paliword} ",$FetchPaliText[$iPali]["vri_text"]);
echo "
{$light_text}
";
}
}
echo "