att_stat.php

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

			{
				$REGISTER_TIME = $ROW['REGISTER_TIME'];
				$REGISTER_TIME = strtok( $REGISTER_TIME, " " );
				$REGISTER_TIME = strtok( " " );
				$STATE = $ROW['STATE'];
				if ( $DUTY_TYPE == "1" )
				{
					++$DUTY_ON_COUNT;
					if ( $STATE == 1 )
					{
						++$LATE_COUNT;
					}
				}
				if ( $DUTY_TYPE == "2" )
				{
					++$DUTY_OFF_COUNT;
					if ( $STATE == 2 )
					{
						++$EARLY_COUNT;
					}
				}
			}
		}
	}
	$sql_ot = "SELECT COUNT(USER_ID) AS ucnt FROM ATTEND_OUT\r\n\t\t\t\t\t   WHERE USER_ID='".$user_id."'\r\n\t\t\t\t\t\t  AND to_days(SUBMIT_TIME)>=to_days('{$date_start}') \r\n\t\t\t\t\t\t  AND to_days(SUBMIT_TIME)<=to_days('{$date_end}') \r\n\t\t\t\t\t\t  ";
	$rs_ot = exequery( $connection, $sql_ot );
	$row_ot = mysql_fetch_array( $rs_ot );
	$out_count = $row_ot['ucnt'];
	if ( $out_count == 0 )
	{
		$out_count = "";
	}
	$sql_lt = "SELECT COUNT(USER_ID) AS lcnt FROM ATTEND_LEAVE\r\n\t\t               WHERE USER_ID='".$user_id."' \r\n\t\t\t\t\t       AND ((to_days(LEAVE_DATE1)>=to_days('{$date_start}') \r\n\t\t\t\t\t\t   AND to_days(LEAVE_DATE1)<=to_days('{$date_end}')) \r\n\t\t\t\t\t\t   OR (to_days(LEAVE_DATE2)>=to_days('{$date_start}') \r\n\t\t\t\t\t\t   AND to_days(LEAVE_DATE2)<=to_days('{$date_end}')) \r\n\t\t\t\t\t\t   OR (to_days(LEAVE_DATE1)<=to_days('{$date_start}') \r\n\t\t\t\t\t\t   AND to_days(LEAVE_DATE2)>=to_days('{$date_end}'))) \r\n\t\t\t\t\t\t   AND allow in('1','3')";
	$rs_lt = exequery( $connection, $sql_lt );
	$row_lt = mysql_fetch_array( $rs_lt );
	$lvt_count = $row_lt['lcnt'];
	if ( $lvt_count == 0 )
	{
		$lvt_count = "";
	}
	$sql_ev = "SELECT COUNT(USER_ID) AS ecnt FROM ATTEND_EVECTION\r\n\t\t               WHERE USER_ID='".$user_id."' \r\n\t\t\t\t\t       AND ((to_days(EVECTION_DATE1)>=to_days('{$date_start}') \r\n\t\t\t\t\t\t   AND to_days(EVECTION_DATE1)<=to_days('{$date_end}')) \r\n\t\t\t\t\t\t   OR (to_days(EVECTION_DATE2)>=to_days('{$date_start}') \r\n\t\t\t\t\t\t   AND to_days(EVECTION_DATE2)<=to_days('{$date_end}')) \r\n\t\t\t\t\t\t   OR (to_days(EVECTION_DATE1)<=to_days('{$date_start}') \r\n\t\t\t\t\t\t   AND to_days(EVECTION_DATE2)>=to_days('{$date_end}'))) \r\n\t\t\t\t\t\t   ";
	$rs_ev = exequery( $connection, $sql_ev );
	$row_ev = mysql_fetch_array( $rs_ev );
	$evt_count = $row_ev['ecnt'];
	if ( $evt_count == 0 )
	{
		$evt_count = "";
	}
	$trclass = $u_cnt % 2 == 1 ? "TableLine2" : "TableLine1";
	++$u_cnt;
	echo "\r\n\t  \r\n      <tr class=\"";
	echo $trclass;
	echo "\">\r\n        <td><a href=\"att_stat_user_detail.php?user_id=";
	echo $user_id;
	echo "&date_start=";
	echo $date_start;
	echo "&date_end=";
	echo $date_end;
	echo "\">";
	echo $user_name;
	echo "</a></td>\r\n\t\t<td><a href=\"";
	echo $_SERVER['PHP_SELF'];
	echo "?s_dept_id=";
	echo $dept_id;
	echo "&date_start=";
	echo $date_start;
	echo "&date_end=";
	echo $date_end;
	echo "\">";
	echo $dept_name;
	echo "</a></td>\r\n        <td><a href=\"att_stat_ev_detail.php?user_id=";
	echo $user_id;
	echo "&date_start=";
	echo $date_start;
	echo "&date_end=";
	echo $date_end;
	echo "\">";
	echo $LATE_COUNT;
	echo "</a></td>\r\n        <td><a href=\"att_stat_re_detail.php?user_id=";
	echo $user_id;
	echo "&date_start=";
	echo $date_start;
	echo "&date_end=";
	echo $date_end;
	echo "\">";
	echo $EARLY_COUNT;
	echo "</a></td>\r\n        <td>";
	echo $DUTY_ON_TOTAL - $DUTY_ON_COUNT + $DUTY_OFF_TOTAL - $DUTY_OFF_COUNT;
	echo "</td>\r\n        <td><a href=\"att_stat_out_detail.php?user_id=";
	echo $user_id;
	echo "&date_start=";
	echo $date_start;
	echo "&date_end=";
	echo $date_end;
	echo "\">";
	echo $out_count;
	echo "</a></td>\r\n        <td><a href=\"att_stat_eml_detail.php?user_id=";
	echo $user_id;
	echo "&date_start=";
	echo $date_start;
	echo "&date_end=";
	echo $date_end;
	echo "\">";
	echo $lvt_count;
	echo "</a></td>\r\n        <td><a href=\"att_stat_che_detail.php?user_id=";
	echo $user_id;
	echo "&date_start=";
	echo $date_start;
	echo "&date_end=";
	echo $date_end;
	echo "\">";
	echo $evt_count;
	echo "</a></td>\r\n      </tr>\t  \r\n\t\t ";
	$late_count_total += $LATE_COUNT;
	$earpl_count_total += $EARLY_COUNT;
	$duty_count_total += $DUTY_ON_TOTAL - $DUTY_ON_COUNT + $DUTY_OFF_TOTAL - $DUTY_OFF_COUNT;
	$out_count_total += $out_count;
	$lvt_count_total += $lvt_count;
	$evt_count_total += $evt_count;
}
echo "\t\r\n      <thead class=\"TableHeader\">\r\n  <td>&nbsp;</td>\r\n\t\t<td width=\"20%\">&nbsp;</td>\r\n    <td width=\"10%\">迟到 (";
echo $late_count_total;
echo ")</td>\r\n    <td width=\"10%\">早退 (";
echo $earpl_count_total;
echo ")</td>\r\n        <td width=\"10%\">未登记</td>\r\n    <td width=\"10%\">外出(<a href=\"att_stat_out_total.php?date_start=";
echo $date_start;
echo "&date_end=";
echo $date_end;
echo "\">";
echo $out_count_total;
echo "</a>)</td>\r\n        <td width=\"10%\">请假(<a href=\"att_stat_eml_total.php?date_start=";
echo $date_start;
echo "&date_end=";
echo $date_end;
echo "\">";
echo $lvt_count_total;
echo "</a>)</td>\r\n        <td width=\"10%\">出差(<a href=\"att_stat_che_total.php?date_start=";
echo $date_start;
echo "&date_end=";
echo $date_end;
echo "\">";
echo $evt_count_total;
echo "</a>)</td>\r\n      </thead>\t    \r\n</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>";
?>