mint/app/studio/search_text.php

<?php
//pali 正文搜索
require 'casesuf.inc';
require 'dict_find_un.inc';
include "./config.php";
include "./_pdo.php";
include "book_list_zh.inc";

if(isset($_GET["language"])){
	$currLanguage=$_GET["language"];
	$_COOKIE["language"]=$currLanguage;
}
else{
	if(isset($_COOKIE["language"])){
		$currLanguage=$_COOKIE["language"];
	}
	else{
		$currLanguage="en";
		$_COOKIE["language"]=$currLanguage;
	}
}

//load language file
if(file_exists($dir_language.$currLanguage.".php")){
	require $dir_language.$currLanguage.".php";
}
else{
	include $dir_language."default.php";
}

if(isset($_GET["device"])){
	$currDevice=$_GET["device"];
}
else{
	if(isset($_COOKIE["device"])){
		$currDevice=$_COOKIE["device"];
	}
	else{
		$currDevice="computer";
	}
}

$op=$_GET["op"];
$word=mb_strtolower($_GET["word"],'UTF-8');
$org_word=$word;

$count_return=0;
$dict_list=array();

global $PDO;
$dictFileName=$dir_dict_system."word_index.db";
PDO_Connect("sqlite:$dictFileName");

switch($op){
	case "pre"://预查询
		$query = "select word,count as co from main_word_index where \"word_en\" like ".$PDO->quote($word.'%')." OR \"word\" like ".$PDO->quote($word.'%')." limit 0,100";
		//echo $query;
		$Fetch = PDO_FetchAll($query);
		$iFetch=count($Fetch);
		echo "<wordlist>";
		if($iFetch>0){
			for($i=0;$i<$iFetch;$i++){
				$outXml = "<word>";
				$word=$Fetch[$i]["word"];
				$outXml = $outXml."<pali>$word</pali>";
				$outXml = $outXml."<count>".$Fetch[$i]["co"]."</count>";
				$outXml = $outXml."</word>";
				echo $outXml;
			}
		}
		echo "</wordlist>";
		break;
	case "search":
		//直接查询
		//先查书籍单词总表 获取书号
		$word_string="'".str_replace(",","','",$word);
		$word_string=mb_substr($word_string,0,-2,"UTF-8");
		
		$query = "select word,book,sum(count) as co from word_in_book where \"word\" in (".$word_string.") group by book";
		
		$Fetch = PDO_FetchAll($query);
		$iFetch=count($Fetch);
		echo "<div id='search_result_index' style='flex:3;'>";
		if($iFetch>0){
			for($i=0;$i<$iFetch;$i++){
				$outXml = "<p>";
				$word=$Fetch[$i]["word"];
				//$outXml = $outXml."<pali>$word</pali>";
				$bookid=$Fetch[$i]["book"];
				$outXml = $outXml."<book>".$book[$bookid]."</book>-";
				$outXml = $outXml."<count>".$Fetch[$i]["co"]."</count>";
				$outXml = $outXml."</p>";
				echo $outXml;
			}
		}
		echo "</div>";
		
		echo "<div class='search_pali_text_prev' style='flex:7;'>";
		if($iFetch>0){
			for($i=0;$i<$iFetch;$i++){
				//遍历每一本书 获取段落号
				$bookid=$Fetch[$i]["book"];
				
				$db_file = "../appdata/palicanon/templet/".$bookid."_tpl.db3";
				//open database
				PDO_Connect("sqlite:$db_file");
				echo "<div><div class='search_code'>input:$org_word<br>";
				$word_string="\"real\" ='".str_replace(",","' or \"real\" = '",$org_word);
				//echo $word_string;
				$word_string=mb_substr($word_string,0,-14,"UTF-8");
				$query_pali="SELECT * FROM \"main\" WHERE ".$word_string ." group by paragraph";
				echo $query_pali."<br />";
				
				$Fetch_pali = PDO_FetchAll($query_pali);
				$iFetch_pali=count($Fetch_pali);
				echo "book:$bookid paragraph:".$iFetch_pali."<br /></div>";
				//var_dump($Fetch_pali);
				
				if($iFetch_pali>0){
					$db_file = "../appdata/palicanon/pali_text/".$bookid."_pali.db3";
					//open database
					PDO_Connect("sqlite:$db_file");
					
					for($j=0;$j<$iFetch_pali;$j++){
						echo "<div class='search_code'>par:".$Fetch_pali[$j]['paragraph']."<br>";
				$query_pali_text="SELECT * FROM \"data\" WHERE paragraph=".$Fetch_pali[$j]['paragraph'];
				$par=$Fetch_pali[$j]['paragraph'];
				echo $query_pali_text."<br />";
				
				$Fetch_pali_text = PDO_FetchAll($query_pali_text);
				$iFetch_pali_text=count($Fetch_pali_text);
				echo $iFetch_pali_text."<br /></div>";
				//var_dump($Fetch_pali);
				
				if($iFetch_pali_text>0){
					for($k=0;$k<$iFetch_pali_text;$k++){
					echo "<div class='paragraph'>";
					echo "<div class='book_title'>";
					echo "<div class='book_name' style='display:none'>".$book[$bookid]."</div>";
					echo "<div id='book_path#".$k."' class='book_path'>".$Fetch_pali_text[$k]['book']."#".$module_gui_str['editor_palicannon']['1014']."&nbsp;".$Fetch_pali_text[$k]['paragraph']."&nbsp;".$module_gui_str['editor_project']['1043']."</div>";
					echo "</div>";
					$newText=str_replace($word,"<span class='height_light'>$word</span>",$Fetch_pali_text[$k]['vri_text']);
					echo "<div class='par_text'>".$newText."</div>";
					echo "<div class='toolbar'><button onclick='search_edit($bookid,$par)'>Edit</button></div>";
					echo "</div>";
					}
				}
				//break;
					}
				}
				echo "</div>";
				/*
				//获取段落号结束
				
				$db_file = "../appdata/palicanon/pali_text/".$bookid."_pali.db3";
				//open database
				PDO_Connect("sqlite:$db_file");
				$query_pali="SELECT * FROM \"data\" WHERE \"text\"  like '%".$word."%'";
				echo $org_word;
				$word_string="\"text\" like '%".str_replace(",","%' or \"text\" like '%",$org_word);
				echo $word_string;
				$word_string=mb_substr($word_string,0,-18,"UTF-8");
				$query_pali="SELECT * FROM \"data\" WHERE ".$word_string;
				echo $query_pali."<br />";
				
				$Fetch_pali = PDO_FetchAll($query_pali);
				$iFetch_pali=count($Fetch_pali);
				echo $iFetch_pali."<br />";
				//var_dump($Fetch_pali);
				
				if($iFetch_pali>0){
					for($j=0;$j<$iFetch_pali;$j++){
					echo "<div class='paragraph'>";
					echo "<div class='book_title'>";
					echo "<div class='book_name'>".$book[$bookid]."</div>";
					echo "<div class='book_path'>"."path>path ".$Fetch_pali[$j]['book']."第".$Fetch_pali[$j]['paragraph']."段"."</div>";
					echo "</div>";
					$newText=str_replace($word,"<span class='height_light'>$word</span>",$Fetch_pali[$j]['text']);
					echo "<div class='par_text'>".$newText."</div>";
					echo "</div>";
					}
				}
				
				*/
			}
		}
		echo "</div>";
		
		break;
		
}


?>