proj_detail.php

通达网络办公 - Office Anywhere 2008 增强版100％源码(3.4.081216) 内含 通达OA2008增強版接近完美破解补丁20081216集 及 最新通达OA2008ADV(

<?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'];
}
if ( $PROJ_END_TIME && $PROJ_START_TIME )
{
	$DIFF_DAY = floor( ( strtotime( $ROW['PROJ_END_TIME'] ) - strtotime( $ROW['PROJ_START_TIME'] ) ) / 86400 );
}
$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 "\r\n<table class=\"TableList\" width=\"95%\" align=\"center\">\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\"> ";
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\"> ";
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\">";
echo $PROJ_START_TIME;
echo "&nbsp;至&nbsp;";
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\">";
echo $DIFF_DAY;
echo "&nbsp;天</td>\r\n  </tr>\r\n  <tr>\r\n    <td nowrap class=\"TableContent\">项目描述：</td>\r\n  \t<td class=\"TableData\">";
echo $PROJ_DESCRIPTION;
echo "</td>\r\n  </tr>\r\n  <tr>\r\n    <td nowrap class=\"TableContent\">项目成员信息：</td>\r\n    <td class=\"TableData\">\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 "[".$PRIV_NAME."]：".$PROJ_USER_NAME."<br>";
	}
}
echo " \r\n  </td> \r\n  </tr>\r\n</table>\r\n</body>\r\n</html>\r\n\t";
?>