my_dict_list.php 4.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170
  1. <?php
  2. require_once '../studio/index_head.php';
  3. ?>
  4. <body id="file_list_body" onLoad="course_list()">
  5. <script >
  6. var gCurrPage="udict";
  7. </script>
  8. <style>
  9. #udict {
  10. background-color: var(--btn-border-color);
  11. }
  12. #udict:hover{
  13. background-color: var(--btn-border-color);
  14. color: var(--btn-color);
  15. cursor:auto;
  16. }
  17. #word_list{
  18. width:unset;
  19. }
  20. </style>
  21. <?php
  22. require_once '../studio/index_tool_bar.php';
  23. ?>
  24. <div class="index_inner" style=" margin-left: 18em;margin-top: 5em;">
  25. <div id="word_list" class="file_list_block">
  26. <div class="tool_bar">
  27. <div>
  28. <?php echo $_local->gui->userdict;?>
  29. </div>
  30. <div>
  31. <span class="icon_btn_div">
  32. <span class="icon_btn_tip"><?php echo $_local->gui->add;?></span>
  33. <button id="file_add" type="button" class="icon_btn" title=" ">
  34. <a href="../course/my_channal_new.php">
  35. <svg class="icon">
  36. <use xlink:href="../studio/svg/icon.svg#ic_add_circle"></use>
  37. </svg>
  38. </a>
  39. </button>
  40. </span>
  41. <span class="icon_btn_div">
  42. <span class="icon_btn_tip"><?php echo $_local->gui->recycle_bin;?></span>
  43. <button id="to_recycle" type="button" class="icon_btn" onclick="file_del()" title=" ">
  44. <svg class="icon">
  45. <use xlink:href="../studio/svg/icon.svg#ic_delete"></use>
  46. </svg>
  47. </button>
  48. </span>
  49. </div>
  50. </div>
  51. <div id="userfilelist">
  52. <?php
  53. //
  54. require_once "../path.php";
  55. require_once "../public/_pdo.php";
  56. require_once '../public/load_lang.php';
  57. require_once '../ucenter/function.php';
  58. if(isset($_GET["page"])){
  59. $iCurrPage=$_GET["page"];
  60. }
  61. else{
  62. $iCurrPage=0;
  63. }
  64. $iOnePage=300;
  65. $db_file = _FILE_DB_WBW_;
  66. PDO_Connect("sqlite:$db_file");
  67. $query = "select count(word_index) as co from user_index where user_id={$UID}";
  68. $allWord = PDO_FetchOne($query);
  69. $iCountWords=$allWord;
  70. if($iCountWords==0){
  71. echo "<div id='setting_user_dict_count'>您的用户字典中没有单词。</div>";
  72. }
  73. else{
  74. echo "<div>search:<span style='display:inline-block;width:20em;'><input type='input' /></span></div>";
  75. $iPages=ceil($iCountWords/$iOnePage);
  76. if($iCurrPage>$iPages){
  77. $iCurrPage=$iPages;
  78. }
  79. $begin=$iCurrPage*$iOnePage;
  80. $query = "select word_index from user_index where user_id={$UID} order by id DESC limit {$begin},{$iOnePage} ";
  81. $allWord = PDO_FetchAll($query);
  82. $strQuery="('";
  83. foreach($allWord as $one){
  84. $strQuery .= $one["word_index"]."','";
  85. }
  86. $strQuery = substr($strQuery,0,strlen($strQuery)-2);
  87. $strQuery .= ")";
  88. $query = "select * from dict where id in {$strQuery} order by time DESC";
  89. $allWords = PDO_FetchAll($query);
  90. ?>
  91. <div id="setting_user_dict_nav" style="backgroud-color:gray">
  92. <?php
  93. if($iCurrPage==0){
  94. echo "第一页 | ";
  95. echo "上一页";
  96. }
  97. else{
  98. echo "<a href=\"../udict/my_dict_list.phpphp?page=0\">第一页</a>";
  99. $prevPage=$iCurrPage-1;
  100. echo "<a href=\"../udict/my_dict_list.php?page={$prevPage}\">上一页</a>";
  101. }
  102. echo "第<span style='display:inline-block;width:4em;'><input type=\"input\" value=\"".($iCurrPage+1)."\" size=\"4\" /></span>页";
  103. echo "共{$iPages}页";
  104. if($iCurrPage<$iPages-1){
  105. echo "<a href=\"../udict/my_dict_list.php?page=".($iCurrPage+1)."\">下一页</a>";
  106. echo "<a href=\"../udict/my_dict_list.php?page=".($iPages-1)."\">最后一页</a>";
  107. }
  108. else{
  109. echo "下一页 | 最后一页";
  110. }
  111. echo "<span id='setting_user_dict_count'>总计{$iCountWords}</span>";
  112. ?>
  113. </div>
  114. <div>
  115. <div style="display:flex;">
  116. <div><input type="checkbox" /></div>
  117. <div>拼写</div>
  118. <div>类型</div>
  119. <div>语法</div>
  120. <div>意思</div>
  121. <div>语基</div>
  122. <div>状态</div>
  123. <div>引用</div>
  124. <div></div>
  125. </div>
  126. <?php
  127. foreach($allWords as $word){
  128. echo '<div class="file_list_row" style="padding:5px;">';
  129. echo "<div style='flex:1;'><input type=\"checkbox\" /></div>";
  130. echo "<div style='flex:3;'>{$word["pali"]}</div>";
  131. echo "<div style='flex:1;'>{$word["type"]}</div>";
  132. echo "<div style='flex:1;'>{$word["gramma"]}</div>";
  133. echo "<div style='flex:3;'>{$word["mean"]}</div>";
  134. echo "<div style='flex:3;'>{$word["parent"]}</div>";
  135. if($word["creator"]==$UID){
  136. echo "<div style='flex:1;'>原创</div>";
  137. }
  138. else{
  139. echo "<div style='flex:1;'>引用</div>";
  140. }
  141. echo "<div style='flex:1;'>{$word["ref_counter"]}</div>";
  142. echo "<div style='width:1em;;'>...</div>";
  143. echo "</div>";
  144. }
  145. }
  146. ?>
  147. </div>
  148. <?php
  149. require_once '../studio/index_foot.php';
  150. ?>