att_stat_ev_total.php

泛微协同办公系统标准版E-office V5.5的源代码内含泛微办公系统V5.5自动注册文件。

$query1 = "SELECT * from ATTEND_DUTY where to_days(REGISTER_TIME)>=to_days('{$date_start}') and to_days(REGISTER_TIME)<=to_days('{$date_end}') GROUP by to_days(REGISTER_TIME)";
$cursor1 = exequery( $connection, $query1 );
$LINE_COUNT = 0;
while ( $ROW = mysql_fetch_array( $cursor1 ) )
{
	++$LINE_COUNT;
	$REGISTER_TIME = $ROW['REGISTER_TIME'];
	$SOME_DATE = strtok( $REGISTER_TIME, " " );
	if ( $LINE_COUNT % 2 == 1 )
	{
		$TableLine = "TableLine1";
	}
	else
	{
		$TableLine = "TableLine2";
	}
	echo "  <tr class=\"";
	echo $TableLine;
	echo "\">\r\n    <td nowrap >";
	echo $SOME_DATE;
	echo "      （周\r\n        ";
	echo get_week( $SOME_DATE );
	echo "      ）</td>\r\n    ";
	if ( $DUTY_TIME1 != "" )
	{
		$query = "SELECT * from ATTEND_DUTY where USER_ID='{$user_id}' and to_days(REGISTER_TIME)=to_days('{$SOME_DATE}') and REGISTER_TYPE='1'";
		$cursor = exequery( $connection, $query );
		if ( $ROW = mysql_fetch_array( $cursor ) )
		{
			$REGISTER_TIME1 = $ROW['REGISTER_TIME'];
			$REGISTER_TIME1 = strtok( $REGISTER_TIME1, " " );
			$REGISTER_TIME1 = strtok( " " );
			if ( $DUTY_TYPE1 == "1" && compare_time( $REGISTER_TIME1, $DUTY_TIME1 ) == 1 )
			{
				$REGISTER_TIME1 .= " 迟到";
			}
			if ( $DUTY_TYPE1 == "2" && compare_time( $REGISTER_TIME1, $DUTY_TIME1 ) == 1 )
			{
				$REGISTER_TIME1 .= " 早退";
			}
		}
		else
		{
			$REGISTER_TIME1 = "未登记";
		}
		echo "    <td nowrap >";
		echo $REGISTER_TIME1;
		echo "</td>\r\n    ";
	}
	if ( $DUTY_TIME2 != "" )
	{
		$query = "SELECT * from ATTEND_DUTY where USER_ID='{$user_id}' and to_days(REGISTER_TIME)=to_days('{$SOME_DATE}') and REGISTER_TYPE='2'";
		$cursor = exequery( $connection, $query );
		if ( $ROW = mysql_fetch_array( $cursor ) )
		{
			$REGISTER_TIME2 = $ROW['REGISTER_TIME'];
			$REGISTER_TIME2 = strtok( $REGISTER_TIME2, " " );
			$REGISTER_TIME2 = strtok( " " );
			if ( $DUTY_TYPE2 == "1" && compare_time( $REGISTER_TIME2, $DUTY_TIME2 ) == 1 )
			{
				$REGISTER_TIME2 .= " 迟到";
			}
			if ( $DUTY_TYPE2 == "2" && compare_time( $REGISTER_TIME2, $DUTY_TIME2 ) == -1 )
			{
				$REGISTER_TIME2 .= " 早退";
			}
		}
		else
		{
			$REGISTER_TIME2 = "未登记";
		}
		echo "    <td nowrap >";
		echo $REGISTER_TIME2;
		echo "</td>\r\n    ";
	}
	if ( $DUTY_TIME3 != "" )
	{
		$query = "SELECT * from ATTEND_DUTY where USER_ID='{$user_id}' and to_days(REGISTER_TIME)=to_days('{$SOME_DATE}') and REGISTER_TYPE='3'";
		$cursor = exequery( $connection, $query );
		if ( $ROW = mysql_fetch_array( $cursor ) )
		{
			$REGISTER_TIME3 = $ROW['REGISTER_TIME'];
			$REGISTER_TIME3 = strtok( $REGISTER_TIME3, " " );
			$REGISTER_TIME3 = strtok( " " );
			if ( $DUTY_TYPE3 == "1" && compare_time( $REGISTER_TIME3, $DUTY_TIME3 ) == 1 )
			{
				$REGISTER_TIME3 .= " 迟到";
			}
			if ( $DUTY_TYPE3 == "2" && compare_time( $REGISTER_TIME3, $DUTY_TIME3 ) == -1 )
			{
				$REGISTER_TIME3 .= " 早退";
			}
		}
		else
		{
			$REGISTER_TIME3 = "未登记";
		}
		echo "    <td nowrap >";
		echo $REGISTER_TIME3;
		echo "</td>\r\n    ";
	}
	if ( $DUTY_TIME4 != "" )
	{
		$query = "SELECT * from ATTEND_DUTY where USER_ID='{$user_id}' and to_days(REGISTER_TIME)=to_days('{$SOME_DATE}') and REGISTER_TYPE='4'";
		$cursor = exequery( $connection, $query );
		if ( $ROW = mysql_fetch_array( $cursor ) )
		{
			$REGISTER_TIME4 = $ROW['REGISTER_TIME'];
			$REGISTER_TIME4 = strtok( $REGISTER_TIME4, " " );
			$REGISTER_TIME4 = strtok( " " );
			if ( $DUTY_TYPE4 == "1" && compare_time( $REGISTER_TIME4, $DUTY_TIME4 ) == 1 )
			{
				$REGISTER_TIME4 .= " 迟到";
			}
			if ( $DUTY_TYPE4 == "2" && compare_time( $REGISTER_TIME4, $DUTY_TIME4 ) == -1 )
			{
				$REGISTER_TIME4 .= " 早退";
			}
		}
		else
		{
			$REGISTER_TIME4 = "未登记";
		}
		echo "    <td nowrap >";
		echo $REGISTER_TIME4;
		echo "</td>\r\n    ";
	}
	if ( $DUTY_TIME5 != "" )
	{
		$query = "SELECT * from ATTEND_DUTY where USER_ID='{$user_id}' and to_days(REGISTER_TIME)=to_days('{$SOME_DATE}') and REGISTER_TYPE='5'";
		$cursor = exequery( $connection, $query );
		if ( $ROW = mysql_fetch_array( $cursor ) )
		{
			$REGISTER_TIME5 = $ROW['REGISTER_TIME'];
			$REGISTER_TIME5 = strtok( $REGISTER_TIME5, " " );
			$REGISTER_TIME5 = strtok( " " );
			if ( $DUTY_TYPE5 == "1" && compare_time( $REGISTER_TIME5, $DUTY_TIME5 ) == 1 )
			{
				$REGISTER_TIME5 .= " 迟到";
			}
			if ( $DUTY_TYPE5 == "2" && compare_time( $REGISTER_TIME5, $DUTY_TIME5 ) == -1 )
			{
				$REGISTER_TIME5 .= " 早退";
			}
		}
		else
		{
			$REGISTER_TIME5 = "未登记";
		}
		echo "    <td nowrap >";
		echo $REGISTER_TIME5;
		echo "</td>\r\n    ";
	}
	if ( $DUTY_TIME6 != "" )
	{
		$query = "SELECT * from ATTEND_DUTY where USER_ID='{$user_id}' and to_days(REGISTER_TIME)=to_days('{$SOME_DATE}') and REGISTER_TYPE='6'";
		$cursor = exequery( $connection, $query );
		if ( $ROW = mysql_fetch_array( $cursor ) )
		{
			$REGISTER_TIME6 = $ROW['REGISTER_TIME'];
			$REGISTER_TIME6 = strtok( $REGISTER_TIME6, " " );
			$REGISTER_TIME6 = strtok( " " );
			if ( $DUTY_TYPE6 == "1" && compare_time( $REGISTER_TIME6, $DUTY_TIME6 ) == 1 )
			{
				$REGISTER_TIME6 .= " 迟到";
			}
			if ( $DUTY_TYPE6 == "2" && compare_time( $REGISTER_TIME6, $DUTY_TIME6 ) == -1 )
			{
				$REGISTER_TIME6 .= " 早退";
			}
		}
		else
		{
			$REGISTER_TIME6 = "未登记";
		}
		echo "    <td nowrap >";
		echo $REGISTER_TIME6;
		echo "</td>\r\n    ";
	}
	echo "  </tr>\r\n  ";
}
echo "</table>\r\n</body>\r\n</html>\r\n\r\n";
echo "<s";
echo "cript>\r\n//imgtext.innerHTML = \"<img scr='/images/arrow_down.gif'>\";\r\nvar tableDesc,imgSRC,arrayTabelName;\r\ntableID = \"idTable\";\r\n\r\ntableDesc = ";
echo $desc;
echo ";\r\nif (tableDesc == 1){\r\n   imgSRC = \"/images/arrow_up.gif\";\r\n}\r\nelse{\r\n   imgSRC = \"/images/arrow_down.gif\";\r\n}\r\n\r\n";
$key = array_search( $tablecode, $array_table_code );
echo "\r\ncellsKey = ";
echo $key;
echo ";\r\n\r\nfor (var i=0;i";
echo "<";
echo count( $array_table_code );
echo ";i++){\r\n   var str = \"\";\r\n   var tableName = \"\";\r\n   var tableCode = \"\";\r\n   var linkHref = '';\r\n   var imgstr = \"\";\r\n   \r\n   tableName = arrayTableName[i];\r\n   tableCode = arrayTableCode[i];\r\n   if (cellsKey == i){\r\n       imgstr = \"<img src='\"+imgSRC+\"'>\";\r\n\t   strdesc = ";
echo $_REQUEST['desc'] ? 0 : 1;
echo "   }\r\n   else{\r\n       strdesc = 1;\r\n   }  \r\n   \r\n   \r\n   linkHref = \"<a href='";
echo $_SERVER['PHP_SELF'];
echo "?desc=\"+strdesc+\"&tablecode=\"+tableCode+\"&s_dept_id=";
echo $s_dept_id;
echo "&date_start=";
echo $date_start;
echo "&date_end=";
echo $date_end;
echo "' >\"+tableName+\"</a>\"; \r\n   \r\n\r\n   str = linkHref+imgstr;\r\n   \r\n   if (i < 2){\r\n\t  document.getElementById(tableID).rows[0].cells[i].innerHTML = str;\r\n   }\r\n   \r\n   \r\n   \r\n}\r\n\r\n</script>";
?>