2
0

get_para.php 3.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129
  1. <?php
  2. require_once "../public/_pdo.php";
  3. require_once "../path.php";
  4. require_once "../redis/function.php";
  5. require_once "../db/pali_sent.php";
  6. require_once "../db/pali_sim_sent.php";
  7. $mRedis = redis_connect();
  8. define("_MAX_CHAPTER_LEN_", 20000);
  9. if (isset($_GET["book"])) {
  10. $_book = $_GET["book"];
  11. } else {
  12. $_book = 0;
  13. }
  14. if (isset($_GET["para"])) {
  15. $_para = $_GET["para"];
  16. } else {
  17. $_para = 0;
  18. }
  19. if (isset($_GET["begin"])) {
  20. $_begin = $_GET["begin"];
  21. }
  22. if (isset($_GET["end"])) {
  23. $_end = $_GET["end"];
  24. }
  25. $_view = $_GET["view"];
  26. $output["toc"] = array();
  27. $output["sentences"] = array();
  28. $output["head"] = 0;
  29. if ($_view == "sent") {
  30. $output["sentences"] = array(array("book" => $_book, "paragraph" => $_para, "begin" => $_begin, "end" => $_end));
  31. echo json_encode($output, JSON_UNESCAPED_UNICODE);
  32. exit;
  33. }
  34. if ($_view == "sim") {
  35. $mPaliSent = new PaliSentence($mRedis);
  36. $mPaliSim = new PaliSimSentence($mRedis);
  37. if(!isset($_GET["id"])){
  38. $id = $mPaliSent->getId($_book,$_para,$_begin,$_end);
  39. }
  40. else{
  41. $id = $_GET["id"];
  42. }
  43. {
  44. $sent_list[] = $mPaliSent->getInfo($id);
  45. $arrList = $mPaliSim->getSimById($id);
  46. if($arrList){
  47. foreach ($arrList as $key => $value) {
  48. # code...
  49. $sent_list[] = $mPaliSent->getInfo($value["id"]);
  50. }
  51. $output["sentences"] = $sent_list;
  52. echo json_encode($output, JSON_UNESCAPED_UNICODE);
  53. }
  54. }
  55. exit;
  56. }
  57. $paraBegin=0;
  58. $paraEnd=0;
  59. PDO_Connect(_FILE_DB_PALITEXT_);
  60. $query = "SELECT level , parent, chapter_len FROM 'pali_text' WHERE book= ? AND paragraph= ?";
  61. $FetchParInfo = PDO_FetchRow($query, array($_book, $_para));
  62. if ($FetchParInfo) {
  63. switch ($_view) {
  64. case 'chapter':
  65. # code...
  66. if($FetchParInfo["level"]>0 && $FetchParInfo["level"]<8){
  67. $paraBegin = $_para;
  68. $paraEnd = $_para + $FetchParInfo["chapter_len"] - 1;
  69. }
  70. else{
  71. $paraBegin = $FetchParInfo["parent"];
  72. $query = "SELECT chapter_len FROM 'pali_text' WHERE book= ? AND paragraph= ?";
  73. $FetchParInfo = PDO_FetchRow($query, array($_book, $paraBegin));
  74. $paraEnd = $paraBegin + $FetchParInfo["chapter_len"] - 1;
  75. }
  76. break;
  77. case 'para':
  78. $paraBegin = $_para;
  79. $paraEnd = $_para;
  80. # code...
  81. break;
  82. case "sim":
  83. break;
  84. default:
  85. # code...
  86. $paraBegin = $_para;
  87. $paraEnd = $_para;
  88. break;
  89. }
  90. //获取下级目录
  91. $query = "SELECT level,paragraph,toc FROM 'pali_text' WHERE book= ? AND (paragraph BETWEEN ?AND ? ) AND level < 8 ";
  92. $output["toc"] = PDO_FetchAll($query, array($_book, $paraBegin, $paraEnd));
  93. if ($FetchParInfo["chapter_strlen"] > _MAX_CHAPTER_LEN_ && $_view === "chapter" && count($output["toc"]) > 1) {
  94. if ($output["toc"][1]["paragraph"] - $_para > 1) {
  95. # 中间有间隔
  96. $paraBegin = $_para;
  97. $paraEnd = $output["toc"][1]["paragraph"] - 1;
  98. $output["head"] = 1;
  99. } else {
  100. #中间无间隔
  101. echo json_encode($output, JSON_UNESCAPED_UNICODE);
  102. exit;
  103. }
  104. }
  105. PDO_Connect(_FILE_DB_PALI_SENTENCE_);
  106. $query = "SELECT book,paragraph,begin, end FROM 'pali_sent' WHERE book= ? AND (paragraph BETWEEN ?AND ? ) ";
  107. $sent_list = PDO_FetchAll($query, array($_book, $paraBegin, $paraEnd));
  108. $output["sentences"] = $sent_list;
  109. echo json_encode($output, JSON_UNESCAPED_UNICODE);
  110. } else {
  111. echo json_encode($output, JSON_UNESCAPED_UNICODE);
  112. }