mint/app/pali_text/function.php

<?php
require_once "../config.php";
require_once "../db/table.php";

class PaliText extends Table
{
    function __construct($redis=false) {
		parent::__construct(_FILE_DB_PALITEXT_, _TABLE_PALI_TEXT_, "", "",$redis);
    }
	
	public function getPath($book,$para){
		if($this->redis!==false){
			$path = $this->redis->hGet("pali_text://path",$book."-".$para);
			if($path!==FALSE){
				return json_decode($path,true);
			}
		}
		$path = array();
		$parent = $para;
		$deep = 0;
		$sFirstParentTitle = "";
		//循环查找父标题 得到整条路径
		while ($parent > -1) {
			$query = "SELECT * from "._TABLE_PALI_TEXT_." where \"book\" = ? and \"paragraph\" = ? ";
			$stmt = $this->dbh->prepare($query);
			$stmt->execute(array($book, $parent));
			$FetParent = $stmt->fetch(PDO::FETCH_ASSOC);
			if($FetParent){
				$toc =array("book"=>$book,"para"=>$parent,"level"=>$FetParent["level"],"title"=>$FetParent["toc"]);

				$path[] = $toc;

				$parent = $FetParent["parent"];
				$deep++;
				if ($deep > 5) {
					break;
				}				
			}else{
				break;
			}

		}
		if($this->redis){
			$this->redis->hSet("pali_text://path",$book."-".$para,json_encode($path,JSON_UNESCAPED_UNICODE));
		}
		return ($path);
	}

	public function getPathHtml($arrPath){
		$path="";
		foreach ($arrPath as $key => $value) {
			# code...
			$toc = "<chapter book='{$value["book"]}' para='{$value["para"]}' title='{$value["title"]}'>{$value["title"]}</chapter>";
			if ($path == "") {
				if ($value["level"] < 100) {
					$path = $toc;
				} else {
					$path = "<para book='{$value["book"]}' para='{$value["para"]}' title='{$value["title"]}'>{$value["para"]}</para>";
				}
			} else {
				$path = $toc . $path;
			}
		}
		return $path;
	}
}

class PaliBook extends Table
{
    function __construct($redis=false) {
		parent::__construct(_FILE_DB_PALITEXT_, _TABLE_PALI_BOOK_NAME_, "", "",$redis);
    }
	
	public function getBookTitle($book,$para){
		/*
		if($this->redis!==false){
			$result = $this->redis->hGet("pali_text://book",$book."-".$para);
			if($result!==FALSE){
				return $result;
			}
		}
		*/
		$query = "SELECT title from "._TABLE_PALI_BOOK_NAME_." where book = ? and paragraph = ? limit 1";
		$stmt = $this->dbh->prepare($query);
		$stmt->execute(array($book, $para));
		$book = $stmt->fetch(PDO::FETCH_ASSOC);
		if($book){
			if($this->redis){
				//$this->redis->hSet("pali_text://book",$book."-".$para,$book["title"]);
			}
			return $book["title"];
		}
		else{
			return false;
		}
	}
}

?>