Group
";
$query = "select * from \"group_member\" where user_id='{$UID}' ";
$Fetch = PDO_FetchAll($query);
$iFetch = count($Fetch);
$sGroupId = "('";
if ($iFetch > 0) {
foreach ($Fetch as $group_id) {
$sGroupId .= "{$group_id["group_id"]}','";
}
$sGroupId = substr($sGroupId, 0, -2);
$sGroupId .= ")";
$query = "select * from \"group_info\" where id in {$sGroupId} ";
$Fetch = PDO_FetchAll($query);
foreach ($Fetch as $group) {
echo "
";
}
}
break;
case "group_info":
echo "
";
if (isset($_GET["group"])) {
$group = $_GET["group"];
} else {
$group = "0";
}
$query = "select * from \"group_info\" where id = '{$group}' ";
$Fetch = PDO_FetchAll($query);
$group_name = $Fetch[0]["name"];
if (count($Fetch) > 0) {
echo "
{$group_name} ";
echo "
";
echo "建立Create Time {$Fetch[0]["create_time"]} 文件Files {$Fetch[0]["file_number"]} 成员Member {$Fetch[0]["member_number"]} ";
foreach ($userlist as $user) {
echo "{$user["nickname"]}
";
}
break;
case "project";
if (isset($_GET["group"])) {
$group = $_GET["group"];
} else {
$group = "0";
}
$query = "select group_name from \"group_member\" where group_id = \"{$group}\" AND user_id=\"{$UID}\"";
$group_name = PDO_FetchOne($query);
if ($group_name == "") {
$query = "select name from \"group_info\" where group_id = \"{$group}\" ";
$group_name = PDO_FetchOne($query);
}
echo "
";
echo "
群组Group >> {$group_name}";
echo "
";
$query = "select file_id from \"group_file_power\" where group_id = \"{$group}\" AND user_id='{$UID}' group by file_id";
$Fetch = PDO_FetchAll($query);
$sFileId = "('";
foreach ($Fetch as $file) {
$sFileId .= "{$file["file_id"]}','";
}
$sFileId = substr($sFileId, 0, -2);
$sFileId .= ")";
$query = "select project , count(*) as co from \"group_file\" where id in {$sFileId} group by project";
$Fetch = PDO_FetchAll($query);
echo "
";
echo "Project File Number ";
echo "{$project["project"]} {$project["co"]} ";
echo " ";
}
echo "
";
break;
case "file":
if (isset($_GET["group"])) {
$group = $_GET["group"];
} else {
$group = "0";
}
if (isset($_GET["project"])) {
$project = $_GET["project"];
} else {
$project = "0";
}
$query = "select group_name from \"group_member\" where group_id = \"{$group}\" AND user_id=\"{$UID}\"";
$group_name = PDO_FetchOne($query);
if ($group_name == "") {
$query = "select name from \"group_info\" where group_id = \"{$group}\" ";
$group_name = PDO_FetchOne($query);
}
echo "
";
?>
gui->all; //全部 ?>
gui->shared; //已共享 ?>
gui->recycle_bin; //回收站 ?>
gui->order_by; //排序方式 ?>
gui->accessed; //訪問 ?>
gui->modified; //修改 ?>
gui->created; //創建 ?>
gui->title; //標題 ?>
gui->desc; //降序 ?>
gui->asc; //升序 ?>
选择
全部All";
foreach ($stage as $one) {
$aStage[$one["stage"]] = $one["name"];
echo "
{$one["name"]} ";
}
$query = "select file_id from \"group_file_power\" where group_id = \"{$group}\" AND user_id='{$UID}' group by file_id";
$Fetch = PDO_FetchAll($query);
$sFileId = "('";
foreach ($Fetch as $file) {
$sFileId .= "{$file["file_id"]}','";
}
$sFileId = substr($sFileId, 0, -2);
$sFileId .= ")";
$query = "select * from \"group_file\" where id in {$sFileId} AND project = \"{$project}\"";
$Fetch = PDO_FetchAll($query);
echo "
";
echo "Title File Size Date Stage ";
echo "{$file["file_title"]} {$file["file_size"]} ";
echo "{$file["modify_time"]} ";
$stage_name = $aStage["{$file["stage"]}"];
echo "{$stage_name} 详情Details ";
}
echo "
";
break;
case "stage":
if (isset($_GET["file"])) {
$file_id = $_GET["file"];
} else {
$file_id = "0";
}
$query = "select * from \"group_file\" where id = {$file_id} ";
$Fetch = PDO_FetchAll($query);
$group_id = $Fetch[0]["group_id"];
$file_title = $Fetch[0]["file_title"];
$project = $Fetch[0]["project"];
$curr_stage = $Fetch[0]["stage"];
$query = "select name from \"group_info\" where id = \"{$group_id}\" ";
$group_name = PDO_FetchOne($query);
$query = "select group_name from \"group_member\" where group_id = \"{$group_id}\" AND user_id='{$UID}' ";
$my_group_name = PDO_FetchOne($query);
if (empty($my_group_name)) {
$my_group_name = $group_name;
}
$query = "select * from \"group_process\" where group_id = \"{$group_id}\" ";
$stage = PDO_FetchAll($query);
echo "
";
echo "
{$file_title} ";
foreach ($stage as $one) {
echo "
{$one["stage"]} {$one["name"]}-";
if ($one["stage"] < $curr_stage) {
echo "
{$_local->gui->already_over} ";
} else if ($one["stage"] == $curr_stage) {
echo "{$_local->gui->in_progress}
完成Done ";
} else {
echo "尚未开始 Not Ready";
}
echo "
";
}
break;
}
?>