= 0){
$query = "select toc from 'pali_text' where book='$book' and paragraph='$par_parent'";
$FetchToc = PDO_FetchAll($query);
if(count($FetchToc)>0){
$_parent_title = $FetchToc[0]["toc"];
}
}
}
//上一级
echo "
";
switch($_view){
case 1 :
break;
case 2:
break;
case 3:
break;
case 4:
break;
case 5:
break;
case 5:
break;
case 6:
break;
case "chapter":
if($par_parent >= 0){
echo "上一级
{$_parent_title}";
}
break;
case "para":
if($par_parent >= 0){
echo "上一级
{$_parent_title}";
}
break;
case 9:
break;
case 10:
break;
}
echo "
";
//生成一个段落空壳 等会儿查询数据，按照不同数据类型填充进去
PDO_Connect("sqlite:"._FILE_DB_PALI_SENTENCE_);
if($_view=="sent"){
$query = "select text, begin, end from 'pali_sent' where book='$book' and paragraph='$paragraph' and begin='{$_GET["begin"]}' and end ='{$_GET["end"]}'";
$FetchSent = PDO_FetchAll($query);
echo "
".$FetchSent[0]["text"]."
";
}
if($_display=="sent"){
//逐句显示
for($iPar=$par_begin;$iPar<=$par_end;$iPar++){
$query = "select text, begin, end from 'pali_sent' where book='$book' and paragraph='$iPar'";
$FetchSent = PDO_FetchAll($query);
echo "
";
echo "
$iPar";
foreach ($FetchSent as $key => $value) {
echo "
";
echo "".$value["text"]."";
echo "
";
echo "
";
echo "
";
echo "
";
echo "
";
}
echo "
";
}
}
else{
//段落显示
for($iPar=$par_begin;$iPar<=$par_end;$iPar++){
$query = "select text , begin, end from 'pali_sent' where book='$book' and paragraph='$iPar'";
$FetchSent = PDO_FetchAll($query);
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 "
";
}
}
if(isset($_GET["sent_mode"])){
}
PDO_Connect("sqlite:"._FILE_DB_SENTENCE_);
for($iPar=$par_begin;$iPar<=$par_end;$iPar++){
}
//查询句子译文内容
if($par_begin==-1){
$query="SELECT * FROM \"sentence\" WHERE book = '{$book}' ";
}
else{
$query="SELECT * FROM \"sentence\" WHERE book = '{$book}' and (\"paragraph\" BETWEEN ".$PDO->quote($par_begin)." AND ".$PDO->quote($par_end)." and length(text)>0) order by paragraph,begin ";
}
$FetchText = PDO_FetchAll($query);
$iFetchText=count($FetchText);
if($iFetchText>0){
for($i=0;$i<$iFetchText;$i++){
$currParNo=$FetchText[$i]["paragraph"];
$currParLevel=$FetchText[$i]["level"];
$par_level["$currParNo"]=$currParLevel;
echo "
".$FetchText[$i]["text"]."";
echo "";
}
}
//查询句子译文内容结束
if(isset($album)){
/*
//自动逐词译
$db_file = "../appdata/palicanon/templet/p".$book."_tpl.db3";
PDO_Connect("sqlite:$db_file");
for($iPar=$par_begin;$iPar<=$par_end;$iPar++){
$query="SELECT * FROM \"main\" WHERE (\"paragraph\" = ".$PDO->quote($iPar)." ) ";
$Fetch = PDO_FetchAll($query);
$iFetch=count($Fetch);
if($iFetch>0){
echo "
";
for($i=0;$i<$iFetch;$i++){
$type=$Fetch[$i]["type"];
if($type!=".ctl."){
echo "
";
echo "
".$Fetch[$i]["word"]."
";
echo "
".$Fetch[$i]["mean"]."
";
echo "
";
}
}
echo "
";
echo "";
}
}
////自动逐词译结束
*/
PDO_Connect("sqlite:"._FILE_DB_RESRES_INDEX_);
$query = "select * from 'album' where id='$album'";
$Fetch = PDO_FetchAll($query);
$iFetch=count($Fetch);
if($iFetch>0){
switch($Fetch[0]["type"]){
case 1://巴利原文
break;
case 2://逐词译
$db_file =_DIR_PALICANON_WBW_."/p{$book}_wbw.db3";
PDO_Connect("sqlite:$db_file");
for($iPar=$par_begin;$iPar<=$par_end;$iPar++){
$table="p{$book}_wbw_data";
$query="SELECT * FROM \"{$table}\" WHERE (\"paragraph\" = ".$PDO->quote($iPar)." ) and album_id={$album} ";
$Fetch = PDO_FetchAll($query);
$iFetch=count($Fetch);
if($iFetch>0){
echo "
";
for($i=0;$i<$iFetch;$i++){
$wordtype=$Fetch[$i]["type"];
if($wordtype!=".ctl."){
echo "
";
echo "
{$Fetch[$i]["word"]}
";
echo "
{$Fetch[$i]["mean"]}
";
echo "
{$wordtype}#{$Fetch[$i]["gramma"]}
";
echo "
";
}
}
echo "
";
echo "";
}
}
break;
case 3:
//译文
$tocHtml="";
//打开翻译数据文件
$db_file =_DIR_PALICANON_TRAN_."/p{$book}_translate.db3";
PDO_Connect("sqlite:{$db_file}");
$this_album_id=$album;
$table="p{$book}_translate_info";
if($par_begin==-1){
//全文
$query="SELECT * FROM '{$table}' WHERE album_id=$this_album_id ";
}
else{
//部分段落
$query="SELECT * FROM '{$table}' WHERE (\"paragraph\" BETWEEN ".$PDO->quote($par_begin)." AND ".$PDO->quote($par_end).") and album_id=$this_album_id ";
}
//查询翻译经文内容
$FetchText = PDO_FetchAll($query);
$iFetchText=count($FetchText);
if($iFetchText>0){
for($i=0;$i<$iFetchText;$i++){
$currParNo=$FetchText[$i]["paragraph"];
//查另一个表，获取段落文本。一句一条记录。有些是一段一条记录
$table_data="p{$book}_translate_data";
$query="SELECT * FROM '{$table_data}' WHERE info_id={$FetchText[$i]["id"]}";
$aParaText = PDO_FetchAll($query);
$par_text="";
foreach($aParaText as $sent){
$par_text.=$sent["text"];
}
//获取段落文本结束。
$par_text=str_replace("
","
",$par_text);
echo "
";
echo "
";
echo "
".$par_text."
";
echo "";
echo "
";
echo "";
//目录字符串
$tocLevel=$par_level["$currParNo"]+1-1;
if($tocLevel>0 && $tocLevel<8){
$tocHtml.="
";
}
}
//设置标题栏的经文名称
echo "";
}
break;
case 4:
break;
case 5:
break;
case 6:
break;
case 7:
break;
}
}
//添加注解
PDO_Connect("sqlite:"._FILE_DB_COMMENTS_);
if($par_begin==-1){
$query="SELECT * FROM \"comments\" WHERE album='$album' order by id DESC";
}
else{
$query="SELECT * FROM \"comments\" WHERE album='$album' AND (\"paragraph\" BETWEEN ".$PDO->quote($par_begin)." AND ".$PDO->quote($par_end).") order by id DESC ";
}
//查询注解内容
$FetchText = PDO_FetchAll($query);
$iFetchText=count($FetchText);
if($iFetchText>0){
for($i=0;$i<$iFetchText;$i++){
$currParNo=$FetchText[$i]["paragraph"];
$comm_id=$FetchText[$i]["id"];
echo "";
echo "";
}
}
if($par_next!=-1){
echo "
Next";
}
}
?>