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"];
array_push($newBookList, array($book, $sum));
$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 "
";
}
return ($newBookList);
//查找这些词出现在哪些书中结束
}
switch ($op) {
case "pre": //预查询
{
$time_start = microtime_float();
$searching = $arrWordList[count($arrWordList) - 1];
PDO_Connect( _FILE_DB_RESRES_INDEX_);
if (count($arrWordList) > 1) {
echo "";
foreach ($arrWordList as $oneword) {
echo $oneword . "+";
}
echo "
";
}
$query = "SELECT title from \""._TABLE_RES_INDEX_."\" where (title_en like " . $PDO->quote("%" . $searching . '%') . " OR title like " . $PDO->quote("%" . $searching . '%') . ") group by title limit 20";
$Fetch = PDO_FetchAll($query);
$queryTime = (microtime_float() - $time_start) * 1000;
$iFetch = count($Fetch);
if ($iFetch > 0) {
for ($i = 0; $i < $iFetch; $i++) {
$word = $Fetch[$i]["title"];
echo "$word";
}
}
break;
}
case "search":
{
$time_start = microtime_float();
echo "";
//主显示区开始
echo "
";
//主显示区左侧开始
echo "
";
echo "
";
$queryTime = (microtime_float() - $time_start) * 1000;
echo "
";
//查找这些词出现在哪些书中
echo "
";
$booklist = render_book_list($_GET["word"]);
echo "
";
$wordInBookCounter = 0;
$strFirstBookList = "(";
foreach ($booklist as $onebook) {
$wordInBookCounter += $onebook[1];
$strFirstBookList .= "'" . $onebook[0] . "',";
if ($wordInBookCounter >= 20) {
break;
}
}
$strFirstBookList = mb_substr($strFirstBookList, 0, mb_strlen($strFirstBookList, "UTF-8") - 1, "UTF-8");
$strFirstBookList .= ")";
echo "
";
//黑体字主显示区左侧结束
//黑体字主显示区右侧开始
echo "
";
//前20条记录
$time_start = microtime_float();
PDO_Connect( _FILE_DB_RESRES_INDEX_);
if (isset($_GET["booklist"])) {
$query = "SELECT * from \""._TABLE_RES_INDEX_."\" where (title_en like " . $PDO->quote("%" . $_GET["word"] . '%') . " OR title like " . $PDO->quote("%" . $_GET["word"] . '%') . ") and book in {$_GET["booklist"]} limit 50";
} else {
$query = "SELECT * from \""._TABLE_RES_INDEX_."\" where title_en like " . $PDO->quote("%" . $_GET["word"] . '%') . " OR title like " . $PDO->quote("%" . $_GET["word"] . '%') . " limit 50";
}
$Fetch = PDO_FetchAll($query);
$queryTime = (microtime_float() - $time_start) * 1000;
$iFetch = count($Fetch);
if ($iFetch > 0) {
PDO_Connect( _FILE_DB_PALITEXT_);
for ($i = 0; $i < $iFetch; $i++) {
$title = $Fetch[$i]["title"];
$book = $Fetch[$i]["book"];
$paragraph = $Fetch[$i]["paragraph"];
echo "
";
echo "
";
$bookInfo = _get_book_info($book);
$bookname = $bookInfo->title;
$c1 = $bookInfo->c1;
$c2 = $bookInfo->c2;
$c3 = $bookInfo->c3;
$path_1 = $c1 . ">";
if ($c2 !== "") {
$path_1 = $path_1 . $c2 . ">";
}
if ($c3 !== "") {
$path_1 = $path_1 . $c3 . ">";
}
$path_1 = $path_1 . "《{$bookname}》>";
$path = _get_para_path($book, $paragraph);
echo $path_1 . $path;
$query = "select chapter_len from "._TABLE_PALI_TEXT_." where book = ? and paragraph = ? limit 1";
$chapter_len = PDO_FetchAll($query,array($book,$paragraph));
$chapter_len = $chapter_len[0]["chapter_len"];
$query = "select text from "._TABLE_PALI_TEXT_." where book = ? and (paragraph > ? and paragraph <= ?) limit 3";
$FetchPaliText = PDO_FetchAll($query,array($book,$paragraph,($paragraph + $chapter_len)));
$paliContent = "";
foreach ($FetchPaliText as $text) {
$paliContent .= $text["text"];
}
$paliContent = mb_substr($paliContent, 0, 200, "UTF-8");
echo "
{$paliContent}
";
echo "
";
echo "
";
}
}
$queryTime = (microtime_float() - $time_start) * 1000;
echo "
搜索时间:$queryTime
";
echo "
";
//黑体字主显示区右侧结束
echo "
";
echo "
";
echo "
";
//黑体字主显示区结束
echo "
";
//查黑体字结束
echo "";
break;
}
case "update":
$target = $_GET["target"];
switch ($target) {
case "bold";
$wordlist = $_GET["wordlist"];
$booklist = $_GET["booklist"];
$aBookList = ltrim($booklist, "(");
$aBookList = rtrim($aBookList, ")");
$aBookList = str_replace("'", "", $aBookList);
$aBookList = str_getcsv($aBookList);
$arrBookType = json_decode(file_get_contents("../public/book_name/booktype.json"));
//查找这些词出现在哪些书中
$newBookList = render_book_list($wordlist, $aBookList);
//前20条记录
$time_start = microtime_float();
PDO_Connect(_FILE_DB_PALI_INDEX_);
$query = "SELECT * from "._TABLE_WORD_." where \"wordindex\" in $wordlist and \"book\" in $booklist group by book,paragraph limit 20";
$Fetch = PDO_FetchAll($query);
//echo "$query
";
$queryTime = (microtime_float() - $time_start) * 1000;
echo "搜索时间:$queryTime
";
$iFetch = count($Fetch);
if ($iFetch > 0) {
PDO_Connect(_FILE_DB_PALITEXT_);
for ($i = 0; $i < $iFetch; $i++) {
$paliword = $Fetch[$i]["wordindex"];
//$paliword=$wordlist["{$paliwordid}"];
$book = $Fetch[$i]["book"];
$bookInfo = _get_book_info($book);
$bookname = $bookInfo->title;
$c1 = $bookInfo->c1;
$c2 = $bookInfo->c2;
$c3 = $bookInfo->c3;
$paragraph = $Fetch[$i]["paragraph"];
$path_1 = $c1 . ">";
if ($c2 !== "") {
$path_1 = $path_1 . $c2 . ">";
}
if ($c3 !== "") {
$path_1 = $path_1 . $c3 . ">";
}
$path_1 = $path_1 . "《{$bookname}》>";
echo "";
echo "
《{$bookname}》 $c1 $c2
";
echo "
$paliword
";
$query = "SELECT * from "._TABLE_PALI_TEXT_." where book = ? and paragraph = ? limit 20";
$FetchPaliText = PDO_FetchAll($query,array($book,$paragraph));
$countPaliText = count($FetchPaliText);
if ($countPaliText > 0) {
for ($iPali = 0; $iPali < $countPaliText; $iPali++) {
$path = "";
$parent = $FetchPaliText[0]["parent"];
$deep = 0;
$sFirstParentTitle = "";
while ($parent > -1) {
$query = "SELECT * from "._TABLE_PALI_TEXT_." where book = ? and paragraph = ? limit 1";
$FetParent = PDO_FetchAll($query,array($book,$parent));
if ($sFirstParentTitle == "") {
$sFirstParentTitle = $FetParent[0]["toc"];
}
$path = "{$FetParent[0]["toc"]}>{$path}";
$parent = $FetParent[0]["parent"];
$deep++;
if ($deep > 5) {
break;
}
}
$path = $path_1 . $path . "No. " . $paragraph;
echo "
$path
";
//echo "
$paliword
";
if (substr($paliword, -1) == "n") {
$paliword = substr($paliword, 0, -1);
}
$light_text = str_replace($paliword, "
{$paliword}", $FetchPaliText[$iPali]["html"]);
echo "
{$light_text}
";
echo "
";
}
}
echo "
";
}
}
break;
}
break;
}