";
//找到该位置对应的书
$query = "select paragraph,level,chapter_len,parent from 'pali_text' where book='$book' and paragraph='$paragraph'";
$FetchParInfo = PDO_FetchAll($query);
$deep = 0;
if(count($FetchParInfo)>0){
$para = $FetchParInfo[0]["paragraph"];
$level = $FetchParInfo[0]["level"];
$chapter_len = $FetchParInfo[0]["chapter_len"];
$parent = $FetchParInfo[0]["parent"];
$currParaBegin = $para;
$currParaEnd = $para + $chapter_len;
$currParaLevel = $level;
$currParaParentLevel = 0;
//循环查找父标题 找到level=1的段落 也就是书名
while($parent>-1){
$query = "select paragraph,level,parent,chapter_len from pali_text where \"book\" = '{$book}' and \"paragraph\" = '{$parent}' limit 0,1";
$FetParent = PDO_FetchAll($query);
if(count($FetParent)>0){
$para = $FetParent[0]["paragraph"];
$level = $FetParent[0]["level"];
$chapter_len = $FetParent[0]["chapter_len"];
$parent = $FetParent[0]["parent"];
if($currParaParentLevel==0){
$currParaParentLevel = $level;
}
}
$deep++;
if($deep>8){
break;
}
}
$paraBegin = $para+1;
$paraEnd = $para+$chapter_len;
$query = "SELECT toc,paragraph,level,chapter_len,parent FROM 'pali_text' WHERE book='$book' AND (paragraph BETWEEN '$paraBegin' AND '$paraEnd') and level<100";
$chapter_toc = PDO_FetchAll($query);
$tocMaxLevel = 0;
$tocMinLevel = 0;
$tocBegin = 0;
$tocEnd = 0;
$toc1Level = 0;
$toc2Level = 0;
echo "";
foreach ($chapter_toc as $key => $value) {
$tocList[$value["paragraph"]] = $value["level"];
$classCurrToc="";
$classCurrToc2 = "";
$classCurrTocTitle2="";
if($paragraph>=$value["paragraph"] && $paragraph<$value["paragraph"]+$value["chapter_len"]){
$classCurrToc = " curr_chapter";
$classCurrToc2 = " toc_curr_chapter2";
$classCurrTocTitle2=" curr_chapter_title2";
}
if($tocBegin==0 || ($tocBegin>0 && $value["paragraph"]>=$tocEnd)){
//开始新的标题1
$tocBegin =$value["paragraph"];
$tocEnd = $tocBegin + $value["chapter_len"];
$toc1Level = $value["level"];
if(isset($chapter_toc[$key+1])){
if($chapter_toc[$key+1]["level"]>$toc1Level){
$toc2Level = $chapter_toc[$key+1]["level"];
}
else{
$tocBegin=0;
}
}
$tocHtml .= "
";
$tocHtml .= "
{$value["toc"]}
";
}
else{
//下一级标题
if($value["level"]==$toc2Level ){
$tocHtml .= "
";
}
}
/*
if($tocMinLevel==0){
if($value["level"]>$tocMaxLevel){
$tocMinLevel = $value["level"];
$tocHtml .= "
";
}
else{
$tocHtml .= "
";
$tocHtml .= "
{$value["toc"]}
";
}
}
else{
if($value["level"] == $tocMaxLevel){
$tocHtml .= "
";
$tocHtml .= "
{$value["toc"]}
";
}
else if($value["level"] == $tocMinLevel){
$tocHtml .= "
";
}
}
*/
//右侧目录
if($value["paragraph"]>$currParaBegin && $value["paragraph"]<$currParaEnd){
//$tocList[$value["paragraph"]] = $value["level"];
$htmlToc2 .= "
";
}
}
echo "
";
echo "
$iPar";
foreach ($FetchSent as $key => $value) {
echo "
";
$pali_sent = str_replace("{","",$value["text"]);
$pali_sent = str_replace("}","",$pali_sent);
echo "".$pali_sent."";
echo "
";
echo "
";
echo "
";
echo "
";
echo "
";
}
echo "
";
echo "
";
echo "
$iPar";
foreach ($FetchSent as $key => $value) {
$sent_text = str_replace("{","
",$value["text"]) ;
$sent_text = str_replace("}","",$sent_text) ;
echo "
{$sent_text}";
}
echo "
";
echo "
";
echo "
";
echo "
";
echo "
";
echo "
";
echo "
";
echo "
"._get_para_path($value["book"],$value["paragraph"])."
";
}
}
}
if(isset($_GET["sent_mode"])){
}
PDO_Connect("sqlite:"._FILE_DB_SENTENCE_);
$dbh = new PDO("sqlite:"._FILE_DB_PALI_SENTENCE_, "", "");
$dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING);
for($iPar=$par_begin;$iPar<=$par_end;$iPar++){
if($_view=="sent"){
$FetchPaliSent = array(array("begin" => $_GET["begin"] , "end" => $_GET["end"]));
}
else{
$query = "select begin, end from 'pali_sent' where book='$book' and paragraph='$iPar'";
$stmt = $dbh->query($query);
$FetchPaliSent = $stmt->fetchAll(PDO::FETCH_ASSOC);
}
foreach ($FetchPaliSent as $key => $value) {
$begin = $value["begin"];
$end = $value["end"];
if($_view=="sent"){
$query="SELECT * FROM \"sentence\" WHERE (book = '{$book}' AND \"paragraph\" = ".$PDO->quote($iPar)." AND begin = '$begin' AND end = '$end' AND length(text)>0 ) order by modify_time DESC";
}
else{
$query = "SELECT * FROM \"sentence\" WHERE book = '{$book}' AND \"paragraph\" = ".$PDO->quote($iPar)." AND begin = '$begin' AND end = '$end' AND length(text)>0 order by modify_time DESC limit 0, 1";
}
$query_count = "SELECT count(book) FROM \"sentence\" WHERE book = '{$book}' AND \"paragraph\" = ".$PDO->quote($iPar)." AND begin = '$begin' AND end = '$end' AND length(text)>0 ";
$sent_count = PDO_FetchOne($query_count);
if($sent_count>9){
$sent_count = "9+";
}
$FetchText = PDO_FetchAll($query);
$iFetchText=count($FetchText);
if($iFetchText>0){
for($i=0;$i<$iFetchText;$i++){
$currParNo=$iPar;
if($_display=="sent"){
$sent_style = "display:block";
}
else{
$sent_style = "";
}
$tran_text = str_replace("[[","",$FetchText[$i]["text"]);
$tran_text = str_replace("]]","",$tran_text);
echo "".$tran_text;
if($_view!="sent" && $_display=="sent"){
echo "$sent_count";
}
echo "";
echo "";
}
}
}
}
//查询句子译文内容
//查询句子译文内容结束
echo "";
echo "
";
echo "
";
echo "$prev_para_link
";
echo "
$next_para_link";
echo "
";
echo "
";
echo "
=$tocMinLevel){
echo $htmlToc2;
}
?>