请教下项目协同的页面如何增加一个项目成员呢？

chenhuiba · 发表于 2010-8-13 15:03:32

本帖最后由 chenhuiba 于 2010-8-13 15:11 编辑

我用了论坛网友推荐的ZENDPJ开了源码。找到了相应的文件。也增加了相应表格的列。但是数据是用户名输出的。想转成中文。

if ( !array_key_exists( $PROJ_USER, $USER_NAME_ARRAYY) )
{
$query2 = "SELECT USER_NAME FROM USER WHERE USER_ID='".$ROW['PROJ_USER']."'";
$cursor2 = exequery( $connection, $query2);
if ( $ROW = mysql_fetch_array( $cursor2 ) )
{
$USER_NAME_ARRAYY["{$PROJ_USER}"] = $ROW['USER_NAME'];
}
}

复制代码

我增加了这一段的代码，但还是用户名。而不是真实姓名
请教一下大家。如何可以将真实姓名这样输出AAA,BBB,CCC,DDD
-------------------------------------------------------------------------

<?php
/*********************/
/* */
/* Version : 5.1.0 */
/* Author : RM */
/* Comment : 071223 */
/* */
/*********************/
include_once( "inc/auth.php" );
include_once( "inc/utility_all.php" );
ob_end_clean( );
$STATUS_ARR = array( "0" => "立项中", "1" => "审批中", "2" => "进行中", "3" => "已结束" );
$STATUS_COLOR = array( "0" => "#947BD1", "1" => "blue", "2" => "green", "3" => "red" );
$CUR_DATE = date( "Y-m-d", time( ) );
if ( $act == "count" )
{
$query = "select count(*) FROM PROJ_PROJECT WHERE 1=1";
}
else
{
$query = "select * FROM PROJ_PROJECT WHERE 1=1";
}
if ( $RANGE == 0 )
{
$query .= " AND (".$LOGIN_USER_PRIV."=1 OR PROJ_OWNER='{$LOGIN_USER_ID}' OR PROJ_USER='{$LOGIN_USER_ID}' OR FIND_IN_SET('{$LOGIN_USER_ID}',REPLACE(PROJ_USER,'|','')) OR FIND_IN_SET('{$LOGIN_USER_ID}',PROJ_VIWER) OR FIND_IN_SET('{$LOGIN_USER_ID}',PROJ_MANAGER))"; /*OR PROJ_USER='{$LOGIN_USER_ID}'*/
}
else if ( $RANGE == 1 )
{
$query .= " AND (".$LOGIN_USER_PRIV."=1 OR PROJ_OWNER='{$LOGIN_USER_ID}' OR PROJ_USER='{$LOGIN_USER_ID}' OR FIND_IN_SET('{$LOGIN_USER_ID}',PROJ_MANAGER))";/*OR PROJ_USER='{$LOGIN_USER_ID}'*/
}
else if ( $RANGE == 2 )
{
$query .= " AND (FIND_IN_SET('".$LOGIN_USER_ID."',REPLACE(PROJ_USER,'|','')) OR FIND_IN_SET('{$LOGIN_USER_ID}',PROJ_VIWER))";
}
if ( $PROJ_START_TIME )
{
$query .= " and PROJ_START_TIME>'".$PROJ_START_TIME."'";
}
if ( $PROJ_END_TIME )
{
$query .= " and PROJ_END_TIME<'".$PROJ_END_TIME."'";
}
if ( $FINISH_FLAG == "Y" )
{
$query .= " AND PROJ_STATUS='3'";
}
else if ( $STATUS == "" || $STATUS == "ALL" )
{
$query .= " AND PROJ_STATUS!='3'";
}
else
{
$query .= " AND PROJ_STATUS='".$STATUS."'";
}
if ( $PROJ_TYPE != "ALL" )
{
$query .= " AND PROJ_TYPE='".$PROJ_TYPE."'";
}
if ( $PROJ_NUM != "" )
{
$query .= " AND PROJ_NUM LIKE '%".$PROJ_NUM."%'";
}
if ( $PROJ_NAME != "" )
{
$query .= " AND PROJ_NAME LIKE '%".$PROJ_NAME."%'";
}
if ( $PROJ_OWNER != "" )
{
$query .= " AND PROJ_OWNER='".$PROJ_OWNER."'";
}
if ( $PROJ_USER != "" )
{
$query .= " AND PROJ_USER='".$PROJ_USER."'";
}
if ( $act == "count" )
{
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$PROJ_COUNT = $ROW[0];
}
echo $PROJ_COUNT;
exit( );
}
$query .= " ORDER BY PROJ_START_TIME DESC,PROJ_ID DESC";
$limit = $endrecord - $startrecord + 1;
$start = $startrecord - 1;
$query .= " limit ".$start.",{$limit}";
$COUNT = 0;
$USER_NAME_ARRAY = array( );
$USER_NAME_ARRAYY = array( );
$cursor = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
++$COUNT;
$PROJ_ID = $ROW['PROJ_ID'];
$PROJ_NUM = $ROW['PROJ_NUM'];
$PROJ_NAME = $ROW['PROJ_NAME'];
$PROJ_OWNER = $ROW['PROJ_OWNER'];
$PROJ_USER = $ROW['PROJ_USER'];
$PROJ_MANAGER = $ROW['PROJ_MANAGER'];
$PROJ_START_TIME = $ROW['PROJ_START_TIME'];
$PROJ_END_TIME = $ROW['PROJ_END_TIME'];
$PROJ_ACT_END_TIME = $ROW['PROJ_ACT_END_TIME'];
$PROJ_STATUS = $ROW['PROJ_STATUS'];
if ( !array_key_exists( $PROJ_OWNER, $USER_NAME_ARRAY) )
{
$query1 = "SELECT USER_NAME FROM USER WHERE USER_ID='".$ROW['PROJ_OWNER']."'";
$cursor1 = exequery( $connection, $query1);
if ( $ROW = mysql_fetch_array( $cursor1 ) )
{
$USER_NAME_ARRAY["{$PROJ_OWNER}"] = $ROW['USER_NAME'];
}
}
if ( !array_key_exists( $PROJ_USER, $USER_NAME_ARRAYY) )
{
$query2 = "SELECT USER_NAME FROM USER WHERE USER_ID='".$ROW['PROJ_USER']."'";
$cursor2 = exequery( $connection, $query2);
if ( $ROW = mysql_fetch_array( $cursor2 ) )
{
$USER_NAME_ARRAYY["{$PROJ_USER}"] = $ROW['USER_NAME'];
}
}
$PROJ_OWNER_NAME = $USER_NAME_ARRAY["{$PROJ_OWNER}"];
if ( $PROJ_ACT_END_TIME == "0000-00-00" || $PROJ_ACT_END_TIME == "" )
{
$PROJ_ACT_END_TIME = "-";
}
$PROJ_USER_NAME = $USER_NAME_ARRAYY["{$PROJ_USER}"];
if ( $PROJ_ACT_END_TIME == "0000-00-00" || $PROJ_ACT_END_TIME == "" )
{
$PROJ_ACT_END_TIME = "-";
}
$STATUS = "<font color="".$STATUS_COLOR[$PROJ_STATUS]."">".$STATUS_ARR[$PROJ_STATUS]."</font>";
if ( $PROJ_STATUS == 2 && compare_date( $CUR_DATE, $PROJ_END_TIME ) == 1 )
{
$STATUS = "<font color="red">已超时</font>";
}
if ( $COUNT == 1 )
{
$OUTPUT .= "\r\n\t <table id="proj_table" class="TableList" border="0" align="center" width="100%">\r\n <tr class="TableHeader">";
if ( $LOGIN_USER_PRIV == "1" )
{
$OUTPUT .= "<td nowrap align="center" width="40">选择</td>";
}
$OUTPUT .= "\r\n <td nowrap align="center" width="85"><a href="#">项目编号</a></td>\r\n <td nowrap align="center"><a href="#">项目名称</a></td>\r\n <td nowrap align="center"><a href="#">项目创建人</a></td>\r\n <td nowrap align="center"><a href="#">项目成员</a></td>\r\n <td nowrap align="center" width="80"><a href="#">开始</a></td>\r\n <td nowrap align="center" width="80"><a href="#">结束(计划)</a></td>\r\n <td nowrap align="center" width="80"><a href="#">结束(实际)</a></td>\r\n <td nowrap align="center"><a href="#">状态</a></td>\r\n <td nowrap align="center">操作</td>\r\n </tr><tbody>";
}
if ( $COUNT % 2 == 1 )
{
$OUTPUT .= "<tr class="TableLine1" id="".$PROJ_ID."">";
}
else
{
$OUTPUT .= "<tr class="TableLine2" id="".$PROJ_ID."">";
}
if ( $LOGIN_USER_PRIV == "1" )
{
$OUTPUT .= "\r\n <td nowrap align="center">\r\n <input type="checkbox" name="proj_select" value="".$PROJ_ID."" onClick="check_one(self);">\r\n </td>";
}
$OUTPUT .= "\r\n\t <td nowrap align="left">".$PROJ_NUM."</td>\r\n\t <td align="left"><a href="#" title="".$PROJ_NAME."" onclick=show_proj("".$PROJ_ID."")>".( 20 < strlen( $PROJ_NAME ) ? csubstr( $PROJ_NAME, 0, 20 )."..." : $PROJ_NAME )."</a></td>\r\n\t <td nowrap align="center">".$PROJ_OWNER_NAME."</td>\r\n\t <td nowrap align="center">".$PROJ_USER."</td>\r\n\t <td nowrap align="center">".$PROJ_START_TIME."</td>\r\n\t <td nowrap align="center">".$PROJ_END_TIME."</td>\r\n\t <td nowrap align="center">".$PROJ_ACT_END_TIME."</td>\r\n\t <td nowrap align="center">".$STATUS."</td>\r\n\t <td nowrap align="center">";
if ( $LOGIN_USER_PRIV == 1 || $PROJ_OWNER == $LOGIN_USER_ID || $PROJ_MANAGER == $LOGIN_USER_ID )
{
if ( $PROJ_STATUS == 0 )
{
$OUTPUT .= "<a href="#" onclick=edit_proj("".$PROJ_ID."","0")>编辑</a> \r\n\t \t <a href="#" onclick=delete_proj("".$PROJ_ID."")>删除</a> ";
}
else if ( $PROJ_STATUS == 2 || $PROJ_STATUS == 1 )
{
$OUTPUT .= "<a href="#" onclick=edit_proj("".$PROJ_ID."","1")>项目变更</a> ";
$OUTPUT .= "<a href="#" onclick=check_task_finished("".$PROJ_ID."")>结束</a> ";
}
else
{
$OUTPUT .= "<a href="#" onclick=resume_proj("".$PROJ_ID."")>恢复执行</a> ";
}
}
else
{
$OUTPUT .= "-";
}
$OUTPUT .= "</td></tr>";
}
if ( 0 < $COUNT )
{
$OUTPUT .= "</tbody></table>";
if ( $LOGIN_USER_PRIV == 1 )
{
$OUTPUT .= "\r\n <table class="TableList" width="100%" border="0" align="left" style="border-top:0;">\r\n <tr class="TableControl" >\r\n \t <td colspan=10>\r\n \t\t<input type="checkbox" name="allbox" id="allbox_for" onClick="check_all();">\r\n <label for="allbox_for">全选</label> \r\n <a href="javascript:delete_proj();" title="删除所选"><img src="/images/delete.gif" align="absMiddle">删除</a> \r\n \t </td>\r\n </tr>";
}
$OUTPUT .= "</table>";
}
echo $OUTPUT;
?>

复制代码

xoyo13 · 发表于 2011-4-9 20:40:19

到底怎么弄的阿简单说一下把，学习了

账号		自动登录	找回密码
密码			注册

在线客服

工作时间

热线电话

站长

[讨论] 请教下项目协同的页面如何增加一个项目成员呢？