query.php

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

<?php

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 (PROJ_OWNER='".$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))";
}
else if ( $RANGE == 1 )
{
	$query .= " AND (PROJ_OWNER='".$LOGIN_USER_ID."' OR FIND_IN_SET('{$LOGIN_USER_ID}',PROJ_MANAGER))";
}
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 ( $STATUS != "ALL" )
{
	$query .= " AND PROJ_STATUS='".$STATUS."'";
}
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_ID";
$limit = $endrecord - $startrecord + 1;
$start = $startrecord - 1;
$query .= " limit ".$start.",{$limit}";
$COUNT = 0;
$USER_NAME_ARRAY = 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_START_TIME = $ROW['PROJ_START_TIME'];
	$PROJ_END_TIME = $ROW['PROJ_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'];
		}
	}
	$PROJ_OWNER_NAME = $USER_NAME_ARRAY["{$PROJ_OWNER}"];
	$PROJ_ACT_END_TIME = $ROW['PROJ_ACT_END_TIME'];
	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 ( $ROW['PROJ_STATUS'] == 2 && compare_date( $CUR_DATE, $ROW['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\">项目编号</td>\r\n       <td nowrap align=\"center\">项目名称</td>\r\n       <td nowrap align=\"center\">负责人</td>\r\n       <td nowrap align=\"center\" width=\"120\">开始</td>\r\n       <td nowrap align=\"center\" width=\"120\">结束(计划)</td>\r\n       <td nowrap align=\"center\" width=\"120\">结束(实际)</td>\r\n       <td nowrap align=\"center\">状态</td>";
		if ( $LOGIN_USER_PRIV == 1 || $PROJ_OWNER == $LOGIN_USER_ID || $PROJ_MANAGER == $LOGIN_USER_ID )
		{
			$OUTPUT .= "<td nowrap align=\"center\">操作</td>";
		}
		$OUTPUT .= "</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=\"center\">".$PROJ_NUM."</td>\r\n\t  <td nowrap align=\"center\"><a href=\"#\" onclick=show_proj(\"".$PROJ_ID."\")>".$PROJ_NAME."</a></td>\r\n\t  <td nowrap align=\"center\">".$PROJ_OWNER_NAME."</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>&nbsp;\r\n\t  \t            <a href=\"#\" onclick=delete_proj(\"".$PROJ_ID."\")>删除</a>&nbsp;";
		}
		else if ( $PROJ_STATUS == 2 )
		{
			$OUTPUT .= "<a href=\"#\" onclick=edit_proj(\"".$PROJ_ID."\",\"1\")>项目变更</a>&nbsp;";
		}
		else
		{
			$OUTPUT .= "-";
		}
	}
	else
	{
		$OUTPUT .= "-";
	}
	$OUTPUT .= "</td></tr>";
}
if ( 0 < $COUNT )
{
	$OUTPUT .= "</tbody>";
	if ( $LOGIN_USER_PRIV == 1 )
	{
		$OUTPUT .= "\r\n     <tfoot 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>&nbsp;\r\n        <a href=\"javascript:delete_proj();\" title=\"删除所选\"><img src=\"/images/delete.gif\" align=\"absMiddle\">删除</a>&nbsp;\r\n    \t </td>\r\n     </tfoot>";
	}
	$OUTPUT .= "</table>";
}
echo $OUTPUT;
?>