📄 index.php
字号:
<?php
include_once( "inc/auth.php" );
include_once( "inc/utility_all.php" );
$query = "select * from PROJ_PROJECT WHERE PROJ_ID='".$PROJ_ID."'";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$PROJ_NUM = $ROW['PROJ_NUM'];
$PROJ_NAME = $ROW['PROJ_NAME'];
$PROJ_TYPE = $ROW['PROJ_TYPE'];
$PROJ_DEPT = $ROW['PROJ_DEPT'];
$PROJ_START_TIME = $ROW['PROJ_START_TIME'];
$PROJ_END_TIME = $ROW['PROJ_END_TIME'];
$PROJ_DESCRIPTION = $ROW['PROJ_DESCRIPTION'];
$PROJ_OWNER = $ROW['PROJ_OWNER'];
$PROJ_OWNER = $ROW['PROJ_OWNER'];
$PROJ_USER = $ROW['PROJ_USER'];
$PROJ_PRIV = $ROW['PROJ_PRIV'];
$COST_MONEY = $ROW['COST_MONEY'];
$COST_MONEY = explode( ",", $COST_MONEY );
}
if ( $PROJ_END_TIME && $PROJ_START_TIME )
{
$DIFF_DAY = floor( ( strtotime( $ROW['PROJ_END_TIME'] ) - strtotime( $ROW['PROJ_START_TIME'] ) ) / 86400 ) + 1;
}
$query = "select USER_NAME from USER WHERE USER_ID='".$PROJ_OWNER."'";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$PROJ_OWNER_NAME = $ROW['USER_NAME'];
}
if ( $PROJ_DEPT )
{
if ( $PROJ_DEPT == "ALL_DEPT" )
{
$PROJ_DEPT_NAME = "全体部门";
}
else
{
$query = "select DEPT_NAME from DEPARTMENT WHERE FIND_IN_SET(DEPT_ID,'".$PROJ_DEPT."')";
$cursor = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
$PROJ_DEPT_NAME .= $ROW['DEPT_NAME'].",";
}
}
}
$PROJ_USER_ARRAY = explode( "|", $PROJ_USER );
$PROJ_PRIV_ARRAY = explode( "|", $PROJ_PRIV );
echo "<html>\r\n<head>\r\n<title>项目基本信息</title>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">\r\n</head>\r\n\r\n<body class=\"bodycolor\" topmargin=\"5\">\r\n<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"3\" class=\"small\">\r\n\t<tr><td>\r\n\t<img src=\"/images/menu/project.gif\" align=\"absmiddle\"/>\r\n\t<span class=\"big3\"> 项目基本信息</span>\r\n\t<td></tr>\r\n</table>\r\n<table class=\"TableList\" width=\"100%\" align=\"left\" topmargin=\"5\">\r\n\t<tr class=\"TableHeader\">\r\n <td colspan=5 height=20><div style=\"float:left;font-weight:bold;\"><img src=\"/images/green_arrow.gif\" align=\"absmiddle\"> 项目基本信息</div></td>\r\n </tr>\r\n\t<tr>\r\n \t<td nowrap class=\"TableContent\">项目编号:</td>\r\n \t<td class=\"TableData\">";
echo $PROJ_NUM;
echo "</td>\r\n </tr>\r\n\t<tr>\r\n \t<td nowrap class=\"TableContent\" width=100>项目名称:</td>\r\n \t<td class=\"TableData\" colspan=3> ";
echo $PROJ_NAME;
echo "</td> \t \t\r\n </tr>\r\n\t<tr>\r\n \t<td nowrap class=\"TableContent\" width=100>创建者:</td>\r\n \t<td class=\"TableData\" colspan=3> ";
echo $PROJ_OWNER_NAME;
echo "</td> \t \t\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableContent\">项目类别:</td>\r\n \t<td class=\"TableData\">";
echo get_code_name( $PROJ_TYPE, "PROJ_TYPE" );
echo "</td>\r\n </tr>\r\n <tr>\r\n \t<td nowrap class=\"TableContent\">参与部门:</td>\r\n \t<td class=\"TableData\">";
echo $PROJ_DEPT_NAME;
echo "</td>\r\n </tr>\r\n <tr>\r\n \t<td nowrap class=\"TableContent\">项目计划周期:</td>\r\n \t<td class=\"TableData\" colspan=3>";
echo $PROJ_START_TIME;
echo " 至 ";
echo $PROJ_END_TIME;
echo "</td>\r\n </tr>\r\n <tr>\r\n \t<td nowrap class=\"TableContent\">项目工期:</td>\r\n \t<td class=\"TableData\" colspan=3>";
echo $DIFF_DAY;
echo " 工作日</td>\r\n </tr>\r\n <tr>\r\n <td nowrap class=\"TableContent\">项目描述:</td>\r\n \t<td class=\"TableData\" colspan=3>";
echo $PROJ_DESCRIPTION;
echo "</td>\r\n </tr>\r\n <tr class=\"TableHeader\">\r\n <td colspan=5 height=20><div style=\"float:left;font-weight:bold;\"><img src=\"/images/green_arrow.gif\" align=\"absmiddle\"> 项目成员信息</div></td>\r\n </tr>\r\n";
$i = 0;
for ( ; $i < count( $PROJ_PRIV_ARRAY ); ++$i )
{
if ( !( $PROJ_PRIV_ARRAY[$i] == "" ) )
{
$PROJ_USER_NAME = "";
$PRIV_NAME = get_code_name( $PROJ_PRIV_ARRAY[$i], "PROJ_ROLE" );
$query = "select USER_NAME from USER WHERE FIND_IN_SET(USER_ID,'".$PROJ_USER_ARRAY[$i]."')";
$cursor = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
$PROJ_USER_NAME .= $ROW['USER_NAME'].",";
}
echo "\r\n \t <tr>\r\n <td class=\"TableContent\">".$PRIV_NAME.":</td>\r\n <td class=\"TableData\" colspan=3>".$PROJ_USER_NAME."</td> \t\r\n </tr>";
}
}
$COUNT = 0;
$query = "select CODE_NO,CODE_NAME from SYS_CODE where PARENT_NO='PROJ_COST_TYPE' order by CODE_ORDER";
$cursor = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
$CODE_NO = $ROW['CODE_NO'];
$CODE_NAME = $ROW['CODE_NAME'];
if ( $COST_MONEY[$COUNT] != "" )
{
if ( $COUNT == 0 )
{
echo " <tr class=\"TableHeader\">\r\n <td colspan=5 height=20><div style=\"float:left;font-weight:bold;\"><img src=\"/images/green_arrow.gif\" align=\"absmiddle\"> 项目预算成本</div></td>\r\n </tr>\r\n";
}
echo " <tr>\r\n <td class=\"TableContent\">";
echo $CODE_NAME;
echo ":</td>\r\n <td class=\"TableData\" nowrap colspan=3>";
echo $COST_MONEY[$COUNT];
echo "</td> \t\r\n </tr>\r\n";
$TOTAL += $COST_MONEY[$COUNT];
}
++$COUNT;
}
if ( $TOTAL )
{
echo " <tr>\r\n <td class=\"TableContent\">合计:</td>\r\n <td class=\"TableData\" nowrap colspan=3>";
echo $TOTAL;
echo "</td> \t\r\n </tr>\r\n";
}
echo "</table>\r\n</body>\r\n</html>\r\n\t";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -