";
//找到该位置对应的书
$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($value["paragraph"]>$currParaBegin && $value["paragraph"]<$currParaEnd){
//$tocList[$value["paragraph"]] = $value["level"];
$htmlToc2 .= "
";
}
}
echo "
";
if($_view=="chapter"){
echo "
$iPar";
}
foreach ($FetchSent as $key => $value) {
echo "
";
$pali_sent=$value["html"];
echo "".$pali_sent."";
echo "
";
echo "
";
echo "
";
echo "
";
echo "
";
}
echo "
";
echo "
";
if($_view=="chapter"){
echo "
$iPar";
}
foreach ($FetchSent as $key => $value) {
$pali_sent=$value["html"];
echo "
{$pali_sent}";
}
echo "
";
echo "
";
echo "
";
echo "
";
echo "
";
echo "
";
echo "
";
echo "
". $value["text"]."
";
$strSimSent .= "
";
}
}
}
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);
//查询channal数量
switch ($_view) {
case 'chapter':
$query = "SELECT channal from 'sentence' where book= ? and (paragraph between ? and ? ) group by channal";
$FetchChannal = PDO_FetchAll($query,array($book,$par_begin,$par_end));
break;
case 'para':
# code...
$query = "SELECT channal from 'sentence' where book= ? and paragraph = ? group by channal";
$FetchChannal = PDO_FetchAll($query,array($book,$par_begin));
break;
case 'sent':
# code...
$query = "SELECT channal from 'sentence' where book= ? and paragraph = ? AND begin = ? AND end = ? group by channal";
$FetchChannal = PDO_FetchAll($query,array($book,$par_begin,$_GET["begin"],$_GET["end"]));
break;
default:
$FetchChannal = array();
break;
}
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"];
$query_channal = "";
if(isset($_GET["channal"])){
$query_channal = " AND channal=".$PDO->quote($_GET["channal"]);
}
$sent_count = 1;
if($_view=="sent"){
//显示一个巴利句子 以及相应的译文
if(isset($_GET["sent"])){
//如果指定译文句子编号，只显示该句子（和后面的跟帖）
$query="SELECT * FROM \"sentence\" WHERE id = ".$PDO->quote($_GET["sent"]);
}
else{
$query="SELECT * FROM \"sentence\" WHERE (book = ".$PDO->quote($book)." AND \"paragraph\" = ".$PDO->quote($iPar)." AND begin = '$begin' AND end = '$end' AND strlen <> 0 AND (parent = '' OR parent IS NULL) ) {$query_channal} order by modify_time DESC";
}
}
else{
$query = "SELECT * FROM \"sentence\" WHERE book = ".$PDO->quote($book)." AND \"paragraph\" = ".$PDO->quote($iPar)." AND begin = '$begin' AND end = '$end' AND strlen <> 0 {$query_channal} order by modify_time DESC limit 0, 1";
$query_count = "SELECT count(book) FROM \"sentence\" WHERE book = ".$PDO->quote($book)." AND \"paragraph\" = ".$PDO->quote($iPar)." AND begin = '$begin' AND end = '$end' AND strlen > 0 {$query_channal} ";
$sent_count = PDO_FetchOne($query_count);
if($sent_count>9){
$sent_count = "9+";
}
}
$FetchText = PDO_FetchAll($query);
$i = 0;
foreach ($FetchText as $key => $value) {
$thisSent = $value;
$sentClass = "";
# 找出句子中 我贡献的，优先显示
if($_view != "sent"){
if(isset($_COOKIE["userid"])){
if($thisSent["editor"] !== $_COOKIE["userid"]){
$query="SELECT * FROM sentence WHERE parent = ".$PDO->quote($thisSent["id"])." AND editor = ".$PDO->quote($_COOKIE["userid"])." order by modify_time DESC limit 0,1";
$myText = PDO_FetchAll($query);
if(count($myText)>0){
$thisSent = $myText[0];
$sentClass = "mine";
}
}
}
}
echo render_sent($thisSent,$i,$_display,$sent_count,$sentClass);
$i++;
}
if(count($FetchText)>0){
if(isset($_GET["sent"])){
//如果指定句子译文编号，显示句子的跟帖
$query="SELECT * FROM \"sentence\" WHERE parent = ".$PDO->quote($_GET["sent"]);
$FetchChildren = PDO_FetchAll($query);
$i = 0;
echo "";
foreach ($FetchChildren as $key => $value) {
echo render_sent($value,$i,$_display,$sent_count);
$i++;
}
echo "
";
}
}
}
}
//查询句子译文内容结束
echo "";
echo "
";
echo "
";
echo "$prev_para_link
";
echo "
$next_para_link";
echo "
";
echo "
";
echo "
$name · {$channalInfo["name"]}|";
$output .= '
';
$output .= '
（0）|';
if($sent_data["editor"] == $_COOKIE["userid"]){
$output .= "
{$_local_arr["gui"]["revise"]}：";
}
else{
$output .= "
{$_local_arr["gui"]["revise"]}：";
}
$output .= "({$edit_count}) ";
if($sent_data["editor"] != $_COOKIE["userid"]){
$output .= "
采纳";
}
$output .="
=$tocMinLevel){
echo $htmlToc2;
}
echo "
Channal
";
echo "
";
foreach ($FetchChannal as $key => $value) {
# code...
echo "
";
}
?>