📄 history.php

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

💻 PHP

字号:

<?php

include_once( "inc/auth.php" );
echo "<html>\r\n<head>\r\n<title>项目审批</title>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">\r\n<script src=\"/inc/js/module.js\"></script>\r\n<script type=\"text/javascript\">\r\nfunction showProj(PROJ_ID)\r\n{\r\n\tmyleft=(screen.availWidth-800)/2;\r\n  window.open(\"../proj/project.php?PROJ_ID=\"+PROJ_ID,\"\",\"status=0,toolbar=no,menubar=no,location=no,scrollbars=yes,resizable=yes,width=800,height=600,left=\"+myleft+\",top=50\");\r\n}\r\n</script>\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    <img src=\"/images/menu/project.gif\" align=\"absmiddle\"/>\r\n    <span class=\"big3\">项目审批</span>\r\n\t<td></tr>\r\n</table>\r\n\r\n<table class=\"TableList\" width=\"100%\">\r\n";
$query = "select a.*,b.USER_NAME FROM PROJ_PROJECT AS a LEFT JOIN USER AS b ON (a.PROJ_OWNER=b.USER_ID) where PROJ_STATUS in(2,3,4) AND PROJ_MANAGER='".$LOGIN_USER_ID."' ORDER BY PROJ_UPDATE_TIME DESC";
$cursor = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
	++$COUNT;
	$DIFF_DAY = floor( ( strtotime( $ROW['PROJ_END_TIME'] ) - strtotime( $ROW['PROJ_START_TIME'] ) ) / 86400 ) + 1;
	$END_TIME = $ROW['PROJ_ACT_END_TIME'];
	if ( $END_TIME == "" || $END_TIME == "0000-00-00" )
	{
		$END_TIME = "<font color=green>尚未结束</font>";
	}
	if ( $COUNT == 1 )
	{
		echo "\r\n  <tr class=\"TableHeader\">\r\n    <td nowrap align=\"center\" width=\"80\">项目编号</td>\r\n    <td nowrap align=\"center\">项目名称</td>\r\n    <td nowrap align=\"center\">申请人</td>\r\n    <td nowrap align=\"center\" width=\"120px\">开始日期</td>\r\n    <td nowrap align=\"center\" width=\"120px\">工期</td>\r\n    <td nowrap align=\"center\" width=\"120px\">结束日期</td>\r\n    <td nowrap align=\"center\" width=\"120px\">实际结束日期</td>\r\n  </tr>";
	}
	if ( $COUNT % 2 == 0 )
	{
		$TableLine = "TableLine1";
	}
	else
	{
		$TableLine = "TableLine2";
	}
	echo "<tr class=\"".$TableLine."\">\t  \r\n\t  <td nowrap align=\"center\">".$ROW['PROJ_NUM']."</td>\r\n\t  <td nowrap align=\"center\"><a href=\"#\" onclick=showProj(\"".$ROW['PROJ_ID']."\")>".$ROW['PROJ_NAME']."</a></td>\r\n\t  <td nowrap align=\"center\">".$ROW['USER_NAME']."</td>\r\n\t  <td nowrap align=\"center\">".$ROW['PROJ_START_TIME']."</td>\r\n\t  <td nowrap align=\"center\">".$DIFF_DAY."工作日</td>\r\n\t  <td nowrap align=\"center\">".$ROW['PROJ_END_TIME']."</td>\r\n\t  <td nowrap align=\"center\">".$END_TIME."</td></tr>";
}
echo "\t\r\n</table>\r\n";
if ( $COUNT == 0 )
{
	message( "提示", "没有审批记录！" );
}
echo "</body>\r\n</html>";
?>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -