some_day.php
来自「通达OA2007SE源代码 非常好的」· PHP 代码 · 共 95 行
PHP
95 行
<?
include_once 'inc/auth.php';
include_once 'inc/utility_all.php';
echo '
<html>
<head>
<title>上下班登记查询</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
';
echo '<s';
echo 'cript language="JavaScript">
function remark(USER_ID,REGISTER_TYPE,REGISTER_TIME)
{
URL="remark.php?USER_ID="+USER_ID+"®ISTER_TYPE="+REGISTER_TYPE+"®ISTER_TIME="+REGISTER_TIME;
myleft=(screen.availWidth-650)/2;
window.open(URL,"formul_edit","height=250,width=450,status=0,toolbar=no,menubar=no,location=no,scrollbars=yes,top=150,left="+myleft+",resizable=yes");
}
</script>
</head';
echo '>
<body class="bodycolor" topmargin="5">
';
$query1 = (((''.'select * from USER where USER_ID=\'').$USER_ID).'\'');
$cursor1 = exequery ($connection, $query1);
if ($ROW = mysql_fetch_array ($cursor1))
{
$DUTY_TYPE = $ROW['DUTY_TYPE'];
$USER_NAME = $ROW['USER_NAME'];
}
$query = ((''.'SELECT * from ATTEND_CONFIG where DUTY_TYPE=').$DUTY_TYPE);
$cursor = exequery ($connection, $query);
if ($ROW = mysql_fetch_array ($cursor))
{
$DUTY_NAME = $ROW['DUTY_NAME'];
$GENERAL = $ROW['GENERAL'];
$DUTY_TIME1 = $ROW['DUTY_TIME1'];
$DUTY_TIME2 = $ROW['DUTY_TIME2'];
$DUTY_TIME3 = $ROW['DUTY_TIME3'];
$DUTY_TIME4 = $ROW['DUTY_TIME4'];
$DUTY_TIME5 = $ROW['DUTY_TIME5'];
$DUTY_TIME6 = $ROW['DUTY_TIME6'];
$DUTY_TYPE1 = $ROW['DUTY_TYPE1'];
$DUTY_TYPE2 = $ROW['DUTY_TYPE2'];
$DUTY_TYPE3 = $ROW['DUTY_TYPE3'];
$DUTY_TYPE4 = $ROW['DUTY_TYPE4'];
$DUTY_TYPE5 = $ROW['DUTY_TYPE5'];
$DUTY_TYPE6 = $ROW['DUTY_TYPE6'];
}
$WEEK = date ('w', strtotime ($SOME_DATE));
$HOLIDAY = '';
$query = (((((''.'select * from ATTEND_HOLIDAY where BEGIN_DATE <=\'').$SOME_DATE).'\' and END_DATE>=\'').$SOME_DATE).'\'');
$cursor = exequery ($connection, $query);
if ($ROW = mysql_fetch_array ($cursor))
{
$HOLIDAY = '<font color=\'#008000\'>节假日</font>';
}
else
{
if (find_id ($GENERAL, $WEEK))
{
$HOLIDAY = '<font color=\'#008000\'>公休日</font>';
}
}
if (($HOLIDAY == ''))
{
$query = (((((((''.'select * from ATTEND_EVECTION where USER_ID=\'').$USER_ID).'\' and ALLOW=\'1\' and to_days(EVECTION_DATE1)<=to_days(\'').$SOME_DATE).'\') and to_days(EVECTION_DATE2)>=to_days(\'').$SOME_DATE).'\')');
$cursor = exequery ($connection, $query);
if ($ROW = mysql_fetch_array ($cursor))
{
$HOLIDAY = '<font color=\'#008000\'>出差</font>';
}
}
echo '
<!---- 上下班登记 ---->
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
<tr>
<td class="Big"><img src="/images/menu/attendance.gif" WIDTH="22" HEIGHT="20" align="absmiddle">
';
echo '<s';
echo 'pan class="big3"> 上下班登记查询 (';
echo $DUTY_NAME;
echo ') ';
echo $SOME_DATE;
echo '</span><br>
</td>
</tr>
</table>
<br>
<table border="0" cellspacing="1" width="95%" class="small" bgcolor="#000000" cellpadding="2" align="center">
<tr class="TableHeader">
<td nowrap align="center">登记次序</td>
<td nowrap align="center">登记类型</td>
<td nowrap align="center">规定时间</td>
<td nowrap align="center">登记时间</td>
<td nowrap align="center">登
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?