getfilelist.php 1.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869
  1. <?php
  2. /*
  3. 获取我的文档 文件列表
  4. */
  5. include "../config.php";
  6. include "../public/_pdo.php";
  7. include "../public/function.php";
  8. if (isset($_GET["keyword"])) {
  9. $keyword = $_GET["keyword"];
  10. } else {
  11. $keyword = "";
  12. }
  13. if (isset($_GET["status"])) {
  14. $status = $_GET["status"];
  15. } else {
  16. $status = "all";
  17. }
  18. if (isset($_GET["currLanguage"])) {
  19. $currLanguage = $_GET["currLanguage"];
  20. }
  21. if (isset($_GET["orderby"])) {
  22. $order_by = $_GET["orderby"];
  23. } else {
  24. $order_by = "accese_time";
  25. }
  26. if (isset($_GET["order"])) {
  27. $order = $_GET["order"];
  28. } else {
  29. $order = "desc";
  30. }
  31. if ($_COOKIE["uid"]) {
  32. $uid = $_COOKIE["uid"];
  33. } else {
  34. echo "尚未登录";
  35. exit;
  36. }
  37. PDO_Connect( _FILE_DB_FILEINDEX_);
  38. switch ($order_by) {
  39. case "accese_time":
  40. case "create_time":
  41. case "modify_time":
  42. $time_show = $order_by;
  43. break;
  44. default:
  45. $time_show = "accese_time";
  46. break;
  47. }
  48. switch ($status) {
  49. case "all":
  50. $query = "SELECT * from "._TABLE_FILEINDEX_." where user_id='$uid' AND title like '%$keyword%' and status>0 order by $order_by $order";
  51. break;
  52. case "share":
  53. $query = "SELECT * from "._TABLE_FILEINDEX_." where user_id='$uid' AND title like '%$keyword%' and status>0 and share=1 order by $order_by $order";
  54. break;
  55. case "recycle":
  56. $query = "SELECT * from "._TABLE_FILEINDEX_." where user_id='$uid' AND title like '%$keyword%' and status=0 order by $order_by $order";
  57. break;
  58. }
  59. $Fetch = PDO_FetchAll($query);
  60. for ($i = 0; $i < count($Fetch); $i++) {
  61. $Fetch[$i]["path"] = _get_para_path($Fetch[$i]["book"], $Fetch[$i]["paragraph"]);
  62. }
  63. echo json_encode($Fetch, JSON_UNESCAPED_UNICODE);