mint/app/pcdl/search.php

<?php
require_once "../public/config.php";
require_once "../public/_pdo.php";
require_once "../public/function.php";

if(isset($_GET["op"])){
	$op=$_GET["op"];
}
else{
	echo "no op";
	exit;
}
if(isset($_GET["word"])){
	$word=$_GET["word"];
}
else{
	echo "no word";
	exit;
}
_load_book_index();
	$db_file = _FILE_DB_RESRES_INDEX_;
	PDO_Connect("sqlite:$db_file");
switch($op){
	case "pre":
	//查作者
	$query = "select count(*) from 'author' where name like '%$word%'";
	$count = PDO_FetchOne($query);
	if($count>0){
		$query = "select * from 'author' where name like '%$word%' limit 0,5";
		$Fetch = PDO_FetchAll($query);
		$iFetch=count($Fetch);
		if($iFetch>0){
			echo "<div class='search_list_div'><div class='search_type'>作者($count)</div></div>";
			for($i=0;$i<$iFetch;$i++){
				echo "<div class='search_list_div' onclick=\"pre_search('author','".$Fetch[$i]["name"]."')\"><div class='search_item'>".$Fetch[$i]["name"]."</div></div>";
			}
		}
	}

	//查标题
	$query = "select count(*) from 'index'  where  title_en like '%$word%' or title like '%$word%'";
	$count = PDO_FetchOne($query);
	$query = "select * from 'index'  where  title_en like '%$word%' or title like '%$word%' limit 0,20";
	$Fetch = PDO_FetchAll($query);
	$iFetch=count($Fetch);
	if($iFetch>0){
		$dictFileName = _FILE_DB_PALITEXT_;
		PDO_Connect("sqlite:$dictFileName");	
		$arrBookType=json_decode(file_get_contents("../public/book_name/booktype.json"));
		echo "<div class='search_list_div'><div class='search_type'>标题({$count})</div></div>";
		for($i=0;$i<$iFetch;$i++){
			$book=$Fetch[$i]["book"];
			if(substr($book,0,1)=='p'){
				$book=substr($book,1);
			}
			$book--;
			$open_link="onclick='index_render_res_list(".$Fetch[$i]["book"].",".$Fetch[$i]["album"].",".$Fetch[$i]["paragraph"].")'";
			$bookid=$Fetch[$i]["book"];
			$t1=$arrBookType[$bookid-1]->c1;
			$t2=$arrBookType[$bookid-1]->c2;
			$t3=$arrBookType[$bookid-1]->c3;
			$bookInfo = _get_book_info($bookid);
			$bookname=$bookInfo->title;
				
			echo "<div class='search_list_div'>";
			echo "<div class='search_item' $open_link><b>{$Fetch[$i]["title"]}</b>";
			echo "<br><span class='media_type'>{$t1}</span>";
			//echo "<span class='media_type'>{$t2}</span> <span class='media_type'>{$t3}</span>";
			$path="";
			$parent =$Fetch[$i]["paragraph"];
			$deep=0;
			$sFirstParentTitle="";
			//循环查找父标题 得到整条路径
			
			while($parent>-1){
				$query = "select * from pali_text where \"book\" = '{$bookid}' and \"paragraph\" = '{$parent}' limit 0,1";
				$FetParent = PDO_FetchAll($query);
				if($deep>0){
				$path="{$FetParent[0]["toc"]}>{$path}";
				}
				if($sFirstParentTitle==""){
					$sFirstParentTitle = $FetParent[0]["toc"];
				}						
				$parent = $FetParent[0]["parent"];
				$deep++;
				if($deep>5){
					break;
				}
			}
			if(strlen($path)>0){
				$path = substr($path,0,-1);
			}
			echo "<i>{$bookname}</i> > {$path}";
			echo "</div>";
				
			
			echo "</div>";
		}
	}
	$db_file = _FILE_DB_RESRES_INDEX_;
	PDO_Connect("sqlite:$db_file");	
	//查标签
	$query = "select count(*) from 'index' where tag like '%$word%'";
	$count = PDO_FetchOne($query);
	
	$query = "select * from 'index' where tag like '%$word%' limit 0,10";
	$Fetch = PDO_FetchAll($query);
	$iFetch=count($Fetch);
	if($iFetch>0){
		echo "<ul class='search_list'>";
		echo "<li class='title'><div>标签($count)</div><div class='ui-icon ui-icon-carat-r'></div></li>";
		for($i=0;$i<$iFetch;$i++){
			$open_link="onclick='index_render_res_list(".$Fetch[$i]["book"].",".$Fetch[$i]["album"].",".$Fetch[$i]["paragraph"].")'";

			echo "<li $open_link><div>".$Fetch[$i]["title"]."-{$Fetch[$i]["book"]}</div><div class='ui-icon ui-icon-carat-r'></div></li>";
		}
		echo "</ul>";
	}
	break;
	case "author":
		echo "<div id='search_author'>";
		echo "<div id='author_name'>$word</div>";
		echo "<div id='search_body'>";
			//author id
			$query = "select id from 'author' where name = '$word'";
			$arr_author = PDO_FetchAll($query);
			if(count($arr_author)>0){
				$author_id=$arr_author[0]["id"];
			}

			//查album
			$query = "select count(*) from 'album' where author = '$author_id'";
			$count = PDO_FetchOne($query);
			if($count>0){
				$query = "select * from 'album' where author = '$author_id' limit 0,10";
				$Fetch = PDO_FetchAll($query);
				$iFetch=count($Fetch);
				if($iFetch>0){
					echo "<div class='search_list_div'><div class='search_type'>专辑($count)</div></div>";
					for($i=0;$i<$iFetch;$i++){
						$open_link="onclick='index_render_res_list(".$Fetch[$i]["book"].",".$Fetch[$i]["id"].",-1)'";
						echo "<div class='search_list_div'><div class='search_item' $open_link>".$Fetch[$i]["title"]."</div></div>";
					}
				}		
			}
			
			//查资源
			$query = "select count(*) from 'index' where author = '$author_id'";
			$count = PDO_FetchOne($query);
			if($count>0){
				$query = "select * from 'index' where author = '$author_id' limit 0,10";

				$Fetch = PDO_FetchAll($query);
				$iFetch=count($Fetch);
				if($iFetch>0){
					echo "<div class='search_list_div'><div class='search_type'>标题($count)</div></div>";
					for($i=0;$i<$iFetch;$i++){
						$open_link="onclick='index_render_res_list(".$Fetch[$i]["book"].",".$Fetch[$i]["album"].",".$Fetch[$i]["paragraph"].")'";

						echo "<div class='search_list_div' $open_link><div class='search_item'>".$Fetch[$i]["title"]."</div></div>";
					}
				}		
			}
		echo "</div>";
		echo "</div>";
	break;
	case "album":
	break;
}

?>