mint/app/group/get.php

<?php
//查询group 列表

require_once "../path.php";
require_once "../public/_pdo.php";
require_once '../public/function.php';
require_once '../ucenter/function.php';

$output = array();
if (isset($_GET["id"])) {
    PDO_Connect("" . _FILE_DB_GROUP_);
    $id = $_GET["id"];
    $query = "SELECT * FROM group_info  WHERE id = ? ";
    $Fetch = PDO_FetchRow($query, array($id));
    if ($Fetch) {
        $output["info"] = $Fetch;
        if ($Fetch["parent"] == 0) {
            #顶级组 列出小组
            $query = "SELECT * FROM group_info  WHERE parent = ? ";
            $FetchList = PDO_FetchAll($query, array($id));
            $output["children"] = $FetchList;
        } else {
            $output["children"] = array();
            $query = "SELECT * FROM group_info  WHERE id = ? ";
            $parent_group = PDO_FetchRow($query, array($Fetch["parent"]));
            $output["parent"] = $parent_group;
        }
        #列出组文件
        {
            PDO_Connect("" . _FILE_DB_FILEINDEX_);
            $query = "SELECT * FROM power  WHERE user = ? ";
            $fileList = PDO_FetchAll($query, array($id));
            foreach ($fileList as $key => $value) {
                # code...
                $query = "SELECT title FROM fileindex  WHERE id = ? ";
                $file = PDO_FetchRow($query, array($value["doc_id"]));
                if ($file) {
                    $fileList[$key]["title"] = $file["title"];
                } else {
                    $fileList[$key]["title"] = "";
                }
            }
            $output["file"] = $fileList;
        }
    }
}
echo json_encode($output, JSON_UNESCAPED_UNICODE);