query.php

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

<?php

include_once( "inc/auth.php" );
ob_end_clean( );
if ( $act == "count" )
{
	$query = "select count(*) from PROJ_TASK LEFT JOIN PROJ_PROJECT ON (PROJ_TASK.PROJ_ID=PROJ_PROJECT.PROJ_ID) WHERE PROJ_TASK.TASK_USER='".$LOGIN_USER_ID."' AND PROJ_PROJECT.PROJ_STATUS IN (2,3)";
}
else
{
	$query = "select PROJ_PROJECT.PROJ_NAME,PROJ_PROJECT.PROJ_ID,PROJ_NUM,PROJ_STATUS,TASK_ID,TASK_NAME,TASK_START_TIME,TASK_END_TIME,TASK_TIME from PROJ_TASK LEFT JOIN PROJ_PROJECT ON (PROJ_TASK.PROJ_ID=PROJ_PROJECT.PROJ_ID) WHERE PROJ_TASK.TASK_USER='".$LOGIN_USER_ID."' AND PROJ_PROJECT.PROJ_STATUS=2";
}
if ( $PROJ_ID != 0 )
{
	$query .= " AND PROJ_TASK.PROJ_ID='".$PROJ_ID."'";
}
if ( $RANGE != 0 )
{
	$WEEK_START = date( "Y-m-d", strtotime( "-".date( "w", time( ) )."days" ) );
	$WEEK_END = date( "Y-m-d", strtotime( "+6 days", strtotime( $WEEK_START ) ) );
	$MONTH_START = date( "Y-m", time( ) )."-01";
	$MONTH_END = date( "Y-m", time( ) )."-".date( "t" );
	$TODAY = date( "Y-m-d" );
	switch ( $RANGE )
	{
	case 1 :
		$query .= " AND TASK_END_TIME<='".$WEEK_END."' && TASK_END_TIME>='{$WEEK_START}'";
		break;
	case 2 :
		$query .= " AND TASK_END_TIME<='".$MONTH_END."' && TASK_END_TIME>='{$MONTH_START}'";
		break;
	case 3 :
		$query .= " AND TASK_START_TIME>='".$TODAY."'";
	}
}
if ( $act == "count" )
{
	$cursor = exequery( $connection, $query );
	if ( $ROW = mysql_fetch_array( $cursor ) )
	{
		$TASK_COUNT = $ROW[0];
	}
	echo $TASK_COUNT;
	exit( );
}
$query .= " ORDER BY TASK_LEVEL,TASK_END_TIME DESC";
$limit = $endrecord - $startrecord + 1;
$start = $startrecord - 1;
$query .= " limit ".$start.",{$limit}";
$COUNT = 0;
$cursor = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
	$TASK_ID = $ROW['TASK_ID'];
	$PROJ_ID = $ROW['PROJ_ID'];
	$PROJ_STATUS = $ROW['PROJ_STATUS'];
	$PROJ_NAME = $ROW['PROJ_NAME'];
	$PROJ_NUM = $ROW['PROJ_NUM'];
	$TASK_NAME = $ROW['TASK_NAME'];
	$TASK_START_TIME = $ROW['TASK_START_TIME'];
	$TASK_END_TIME = $ROW['TASK_END_TIME'];
	$TASK_TIME = $ROW['TASK_TIME'];
	++$COUNT;
	if ( $COUNT == 1 )
	{
		echo "<table class=\"TableList\" width=\"100%\">\r\n  <tr class=\"TableHeader\">\r\n    <td nowrap align=\"center\" width=\"100\">项目编号</td>\r\n    <td nowrap align=\"center\">项目名称</td>\r\n    <td nowrap align=\"center\">任务名称</td>\r\n    <td nowrap align=\"center\">开始日期</td>\r\n    <td nowrap align=\"center\">工期</td>\r\n    <td nowrap align=\"center\">结束日期</td>\r\n    <td nowrap align=\"center\">操作</td>\r\n  </tr>\r\n";
	}
	if ( $COUNT % 2 == 0 )
	{
		$TableLine = "TableLine1";
	}
	else
	{
		$TableLine = "TableLine2";
	}
	echo "\r\n\t      <tr class=\"".$TableLine."\">\r\n          <td nowrap align=\"center\">".$PROJ_NUM."</td>\r\n          <td nowrap align=\"center\"><a href=\"#\" onclick=projDetail(\"".$PROJ_ID."\")>".$PROJ_NAME."</a></td>\r\n          <td nowrap align=\"center\"><a href=\"#\" onclick=taskDetail(\"".$TASK_ID."\")>".$TASK_NAME."</a></td>\r\n          <td nowrap align=\"center\">".$TASK_START_TIME."</td>\r\n          <td nowrap align=\"center\">".$TASK_TIME."工作日</td>\r\n          <td nowrap align=\"center\">".$TASK_END_TIME."</td>";
	if ( $PROJ_STATUS == 2 )
	{
		echo "<td nowrap align=\"center\"><a href=\"index1.php?PROJ_ID=".$PROJ_ID."&TASK_ID=".$TASK_ID."\">办理</a></td></tr>";
	}
	else
	{
		echo "<font color=red>已结束</font></td></tr>";
	}
}
echo "</table>";
?>