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 "
";
?>
全部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 "
已经完成Done ";
}
else if($one["stage"]==$curr_stage){
echo "正在进行Runing
完成Done ";
}
else{
echo "尚未开始 Not Ready";
}
echo"
";
}
break;
}
?>