| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869 |
- <?php
- /*
- 获取我的文档 文件列表
- */
- include "../path.php";
- include "../public/_pdo.php";
- include "../public/function.php";
- if (isset($_GET["keyword"])) {
- $keyword = $_GET["keyword"];
- } else {
- $keyword = "";
- }
- if (isset($_GET["status"])) {
- $status = $_GET["status"];
- } else {
- $status = "all";
- }
- if (isset($_GET["currLanguage"])) {
- $currLanguage = $_GET["currLanguage"];
- }
- if (isset($_GET["orderby"])) {
- $order_by = $_GET["orderby"];
- } else {
- $order_by = "accese_time";
- }
- if (isset($_GET["order"])) {
- $order = $_GET["order"];
- } else {
- $order = "desc";
- }
- if ($_COOKIE["uid"]) {
- $uid = $_COOKIE["uid"];
- } else {
- echo "尚未登录";
- exit;
- }
- PDO_Connect( _FILE_DB_FILEINDEX_);
- switch ($order_by) {
- case "accese_time":
- case "create_time":
- case "modify_time":
- $time_show = $order_by;
- break;
- default:
- $time_show = "accese_time";
- break;
- }
- switch ($status) {
- case "all":
- $query = "select * from fileindex where user_id='$uid' AND title like '%$keyword%' and status>0 order by $order_by $order";
- break;
- case "share":
- $query = "select * from fileindex where user_id='$uid' AND title like '%$keyword%' and status>0 and share=1 order by $order_by $order";
- break;
- case "recycle":
- $query = "select * from fileindex where user_id='$uid' AND title like '%$keyword%' and status=0 order by $order_by $order";
- break;
- }
- $Fetch = PDO_FetchAll($query);
- for ($i = 0; $i < count($Fetch); $i++) {
- $Fetch[$i]["path"] = _get_para_path($Fetch[$i]["book"], $Fetch[$i]["paragraph"]);
- }
- echo json_encode($Fetch, JSON_UNESCAPED_UNICODE);
|