⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 att_stat_user_detail.php

📁 泛微协同办公系统标准版E-office V5.5的源代码内含泛微办公系统V5.5自动注册文件。
💻 PHP
📖 第 1 页 / 共 2 页
字号:
🔍
12 
		$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( " " );
			$STATE4 = $ROW['STATE'];
			if ( $DUTY_TYPE4 == "1" && $STATE4 == 1 )
			{
				$REGISTER_TIME4 .= " 迟到";
			}
			if ( $DUTY_TYPE4 == "2" && $STATE4 == 2 )
			{
				$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( " " );
			$STATE5 = $ROW['STATE'];
			if ( $DUTY_TYPE5 == "1" && $STATE5 == 1 )
			{
				$REGISTER_TIME5 .= " 迟到";
			}
			if ( $DUTY_TYPE5 == "2" && $STATE5 == 2 )
			{
				$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( " " );
			$STATE6 = $ROW['STATE'];
			if ( $DUTY_TYPE6 == "1" && $STATE6 == 1 )
			{
				$REGISTER_TIME6 .= " 迟到";
			}
			if ( $DUTY_TYPE6 == "2" && $STATE6 == 2 )
			{
				$REGISTER_TIME6 .= " 早退";
			}
		}
		else
		{
			$REGISTER_TIME6 = "未登记";
		}
		echo "      <td nowrap >";
		echo $REGISTER_TIME6;
		echo "</td>\r\n    ";
	}
	echo "  </tr>\r\n  ";
}
echo "</table>\r\n<br>\r\n<table width=\"100%\" border=\"0\" cellspacing=\"1\" cellpadding=\"5\">\r\n  <tr>\r\n    <td colspan=\"4\"><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 "<s";
echo "trong>外出</strong></a></td>\r\n  </tr>\r\n</table>\r\n<table border=\"0\" cellspacing=\"1\" width=\"100%\" class=\"small\"  cellpadding=\"3\">\r\n  <tr class=\"TableHeader\">\r\n    <td width=\"23%\" nowrap >外出原因</td>\r\n    <td width=\"23%\" nowrap >申请时间</td>\r\n    <td width=\"23%\" nowrap >外出时间</td>\r\n    <td width=\"23%\" nowrap >预计归来时间</td>\r\n    <td nowrap >状态</td>\r\n  </tr>\r\n  ";
$query = "SELECT * from ATTEND_OUT,USER,DEPARTMENT where DEPARTMENT.DEPT_ID=USER.DEPT_ID and ATTEND_OUT.USER_ID=USER.USER_ID and to_days(SUBMIT_TIME)>=to_days('{$date_start}') and to_days(SUBMIT_TIME)<=to_days('{$date_end}') and USER.USER_ID='".$user_id."' order by DEPT_NO,USER.USER_ID";
$cursor = exequery( $connection, $query );
$OUT_COUNT = 0;
$LINE_COUNT = 0;
while ( $ROW = mysql_fetch_array( $cursor ) )
{
	++$LINE_COUNT;
	++$OUT_COUNT;
	$USER_ID = $ROW['USER_ID'];
	$USER_NAME = $ROW['USER_NAME'];
	$OUT_TYPE = $ROW['OUT_TYPE'];
	$SUBMIT_TIME = $ROW['SUBMIT_TIME'];
	$OUT_TIME1 = $ROW['OUT_TIME1'];
	$OUT_TIME2 = $ROW['OUT_TIME2'];
	$ALLOW = $ROW['ALLOW'];
	$STATUS = $ROW['STATUS'];
	if ( $STATUS == "0" )
	{
		$STATUS_DESC = "外出";
	}
	else if ( $STATUS == "1" )
	{
		$STATUS_DESC = "已归来";
	}
	if ( $ALLOW == "0" )
	{
		$STATUS_DESC = "待批";
	}
	if ( $ALLOW == "2" )
	{
		$STATUS_DESC = "不批准";
	}
	$DEPT_ID = $ROW['DEPT_ID'];
	$query1 = "select * from DEPARTMENT where DEPT_ID={$DEPT_ID}";
	$cursor1 = exequery( $connection, $query1 );
	if ( $ROW = mysql_fetch_array( $cursor1 ) )
	{
		$USER_DEPT_NAME = $ROW['DEPT_NAME'];
	}
	echo "  ";
	if ( $LINE_COUNT % 2 == 1 )
	{
		$TableLine = "TableLine1";
	}
	else
	{
		$TableLine = "TableLine2";
	}
	echo "  <tr class=\"";
	echo $TableLine;
	echo "\">\r\n    <td nowrap >";
	echo $OUT_TYPE;
	echo "</td>\r\n    <td nowrap >";
	echo $SUBMIT_TIME;
	echo "</td>\r\n    <td nowrap >";
	echo $OUT_TIME1;
	echo "</td>\r\n    <td nowrap >";
	echo $OUT_TIME2;
	echo "</td>\r\n    <td nowrap >";
	echo $STATUS_DESC;
	echo "</td>\r\n  </tr>\r\n  ";
}
echo "</table>\r\n<br>\r\n<table width=\"100%\" border=\"0\" cellspacing=\"1\" cellpadding=\"5\">\r\n  <tr>\r\n    <td colspan=\"4\"><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 "<s";
echo "trong>请假</strong></a></td>\r\n  </tr>\r\n</table>\r\n<table border=\"0\" cellspacing=\"1\" width=\"100%\" class=\"small\"  cellpadding=\"3\">\r\n  <tr class=\"TableHeader\">\r\n    <td width=\"23%\" nowrap >请假原因</td>\r\n    <td width=\"23%\" nowrap >开始日期</td>\r\n    <td width=\"23%\" nowrap >结束日期</td>\r\n    <td width=\"15%\" nowrap >状态</td>\r\n    <td nowrap >操作</td>\r\n  </tr>\r\n  ";
$query = "SELECT * from ATTEND_LEAVE,USER,DEPARTMENT where DEPARTMENT.DEPT_ID=USER.DEPT_ID and ATTEND_LEAVE.USER_ID=USER.USER_ID and ((to_days(LEAVE_DATE1)>=to_days('{$date_start}') and to_days(LEAVE_DATE1)<=to_days('{$date_end}')) or (to_days(LEAVE_DATE2)>=to_days('{$date_start}') and to_days(LEAVE_DATE2)<=to_days('{$date_end}')) or (to_days(LEAVE_DATE1)<=to_days('{$date_start}') and to_days(LEAVE_DATE2)>=to_days('{$date_end}'))) and allow in('1','3') and USER.USER_ID='".$user_id."' order by DEPT_NO,USER.USER_ID";
$cursor = exequery( $connection, $query );
$LEAVE_COUNT = 0;
$lINE_COUNT = 0;
while ( $ROW = mysql_fetch_array( $cursor ) )
{
	++$LINE_COUNT;
	++$LEAVE_COUNT;
	$USER_ID = $ROW['USER_ID'];
	$DEPT_ID = $ROW['DEPT_ID'];
	$USER_NAME = $ROW['USER_NAME'];
	$LEAVE_ID = $ROW['LEAVE_ID'];
	$LEAVE_DATE1 = $ROW['LEAVE_DATE1'];
	$LEAVE_DATE2 = $ROW['LEAVE_DATE2'];
	$LEAVE_TYPE = $ROW['LEAVE_TYPE'];
	switch ( $LEAVE_TYPE )
	{
	case 1 :
		$LEAVE_TYPE = "事假";
		break;
	case 2 :
		$LEAVE_TYPE = "病假";
		break;
	case 3 :
		$LEAVE_TYPE = "婚假";
		break;
	case 4 :
		$LEAVE_TYPE = "产假";
		break;
	case 5 :
		$LEAVE_TYPE = "其它";
	}
	$STATUS = $ROW['STATUS'];
	if ( $STATUS == 1 )
	{
		$STATUS = "已批准";
	}
	else
	{
		$STATUS = "已销假";
	}
	$query1 = "select * from DEPARTMENT where DEPT_ID={$DEPT_ID}";
	$cursor1 = exequery( $connection, $query1 );
	if ( $ROW = mysql_fetch_array( $cursor1 ) )
	{
		$USER_DEPT_NAME = $ROW['DEPT_NAME'];
	}
	if ( $LINE_COUNT % 2 == 1 )
	{
		$TableLine = "TableLine1";
	}
	else
	{
		$TableLine = "TableLine2";
	}
	echo "  <tr class=\"";
	echo $TableLine;
	echo "\">\r\n    <td nowrap >";
	echo $LEAVE_TYPE;
	echo "</td>\r\n    <td nowrap >";
	echo $LEAVE_DATE1;
	echo "</td>\r\n    <td nowrap >";
	echo $LEAVE_DATE2;
	echo "</td>\r\n    <td nowrap >";
	echo $STATUS;
	echo "</td>\r\n    <td nowrap ><a href=\"delete_leave.php?LEAVE_ID=";
	echo $LEAVE_ID;
	echo "&user_id=";
	echo $user_id;
	echo "&date_start=";
	echo $date_start;
	echo "&date_end=";
	echo $date_end;
	echo "\">删除</a></td>\r\n  </tr>\r\n  ";
}
echo "</table>\r\n<br>\r\n<table width=\"100%\" border=\"0\" cellspacing=\"1\" cellpadding=\"5\">\r\n  <tr>\r\n    <td colspan=\"4\"><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 "<s";
echo "trong>出差</strong></a></td>\r\n  </tr>\r\n</table>\r\n<table border=\"0\" cellspacing=\"1\" width=\"100%\" class=\"small\"  cellpadding=\"3\">\r\n  <tr class=\"TableHeader\">\r\n  <td width=\"23%\" nowrap >出差地点</td>\r\n    <td width=\"23%\" nowrap >开始日期</td>\r\n    <td width=\"23%\" nowrap >结束日期</td>\r\n    <td width=\"15%\" nowrap >状态</td>\r\n    <td nowrap >操作</td>\r\n  </tr>\r\n";
$query = "SELECT * from ATTEND_EVECTION,USER,DEPARTMENT where DEPARTMENT.DEPT_ID=USER.DEPT_ID and ATTEND_EVECTION.USER_ID=USER.USER_ID and ((to_days(EVECTION_DATE1)>=to_days('{$date_start}') and to_days(EVECTION_DATE1)<=to_days('{$date_end}')) or (to_days(EVECTION_DATE2)>=to_days('{$date_start}') and to_days(EVECTION_DATE2)<=to_days('{$date_end}')) or (to_days(EVECTION_DATE1)<=to_days('{$date_start}') and to_days(EVECTION_DATE2)>=to_days('{$date_end}'))) and USER.USER_ID='".$user_id."' order by DEPT_NO,USER.USER_ID";
$cursor = exequery( $connection, $query );
$EVECTION_COUNT = 0;
$LINE_COUNT = 0;
while ( $ROW = mysql_fetch_array( $cursor ) )
{
	++$LINE_COUNT;
	++$EVECTION_COUNT;
	$USER_ID = $ROW['USER_ID'];
	$DEPT_ID = $ROW['DEPT_ID'];
	$USER_NAME = $ROW['USER_NAME'];
	$EVECTION_ID = $ROW['EVECTION_ID'];
	$EVECTION_DATE1 = $ROW['EVECTION_DATE1'];
	$EVECTION_DATE1 = strtok( $EVECTION_DATE1, " " );
	$EVECTION_DATE2 = $ROW['EVECTION_DATE2'];
	$EVECTION_DATE2 = strtok( $EVECTION_DATE2, " " );
	$EVECTION_DEST = $ROW['EVECTION_DEST'];
	$STATUS = $ROW['STATUS'];
	if ( $STATUS == "1" )
	{
		$STATUS = "在外";
	}
	else
	{
		$STATUS = "归来";
	}
	$query1 = "select * from DEPARTMENT where DEPT_ID={$DEPT_ID}";
	$cursor1 = exequery( $connection, $query1 );
	if ( $ROW = mysql_fetch_array( $cursor1 ) )
	{
		$USER_DEPT_NAME = $ROW['DEPT_NAME'];
	}
	if ( $LINE_COUNT % 2 == 1 )
	{
		$TableLine = "TableLine1";
	}
	else
	{
		$TableLine = "TableLine2";
	}
	echo "  <tr class=\"";
	echo $TableLine;
	echo "\">\r\n    <td nowrap >";
	echo $EVECTION_DEST;
	echo "</td>\r\n    <td nowrap >";
	echo $EVECTION_DATE1;
	echo "</td>\r\n    <td nowrap >";
	echo $EVECTION_DATE2;
	echo "</td>\r\n    <td nowrap >";
	echo $STATUS;
	echo "</td>\r\n    <td nowrap ><a href=\"delete_evection.php?EVECTION_ID=";
	echo $EVECTION_ID;
	echo "&user_id=";
	echo $user_id;
	echo "&date_start=";
	echo $date_start;
	echo "&date_end=";
	echo $date_end;
	echo "\">删除</a></td>\r\n  </tr>\r\n  ";
}
echo "</table>\r\n\r\n</body>\r\n</html>";
?>
12

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -