index.php
来自「通达OA2007SE源代码 非常好的」· PHP 代码 · 共 268 行
PHP
268 行
<?
function datediff ($interval, $date1, $date2)
{
$timedifference = (y_m_d ($date2) - y_m_d ($date1));
switch ($interval)
{
case 'w':
{
$retval = bcdiv ($timedifference, 604800, 0);
break;
}
case 'd':
{
$retval = bcdiv ($timedifference, 86400, 0);
break;
}
case 'h':
{
$retval = bcdiv ($timedifference, 3600, 0);
break;
}
case 'n':
{
$retval = bcdiv ($timedifference, 60, 0);
break;
}
case 's':
{
$retval = $timedifference;
break;
}
}
return ($retval + 1);
}
function y_m_d ($date)
{
$STR = strtok ($date, '-');
$YEAR = $STR;
$STR = strtok ('-');
$MONTH = $STR;
$STR = strtok (' ');
$DAY = $STR;
$TIME = mktime (0, 0, 0, $MONTH, $DAY, $YEAR);
return $TIME;
}
include_once 'inc/auth.php';
$query = 'select * from SMS2_PRIV';
$cursor2 = exequery ($connection, $query);
if ($ROW = mysql_fetch_array ($cursor2))
{
$TYPE_PRIV = $ROW['TYPE_PRIV'];
}
$query = 'select * from SYS_PARA where PARA_NAME=\'SMS_REMIND\'';
$cursor = exequery ($connection, $query);
if ($ROW = mysql_fetch_array ($cursor))
{
$PARA_VALUE = $ROW['PARA_VALUE'];
}
$SMS2_REMIND = substr ($PARA_VALUE, (strpos ($PARA_VALUE, '|') + 1));
echo '
<html>
<head>
<title>请假</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
';
echo '<s';
echo 'cript Language=JavaScript>
window.setTimeout(\'this.location.reload();\',30000);
function leave_confirm(LEAVE_ID)
{
';
if (find_id ($TYPE_PRIV, 6))
{
echo ' if(document.all("LEAVE_SMS2_REMIND"+LEAVE_ID).checked)
MOBILE_FLAG=1;
else
';
}
echo ' MOBILE_FLAG=0;
URL="back.php?LEAVE_ID="+LEAVE_ID+"&MOBILE_FLAG="+MOBILE_FLAG;
window.location=URL;
}
</script>
</head>
<body class="bodycolor" topmargin="5">
';
$CUR_DATE = date ('Y-m-d', time ());
$query = (((''.'SELECT LEAVE_TYPE from HRMS where USER_ID=\'').$LOGIN_USER_ID).'\'');
$cursor = exequery ($connection, $query);
if ($ROW = mysql_fetch_array ($cursor))
{
$LEAVE_TYPE1 = $ROW['LEAVE_TYPE'];
}
$BEGIN_TIME = (substr ($CUR_DATE, 0, 4).'-01-01 00:00:01');
$END_TIME = (substr ($CUR_DATE, 0, 4).'-12-30 23:59:59');
$query = (((((((''.'SELECT * from ATTEND_LEAVE where USER_ID=\'').$LOGIN_USER_ID).'\' and (STATUS!=\'0\' or STATUS!=\'2\') and LEAVE_DATE1 >=\'').$BEGIN_TIME).'\' and LEAVE_DATE2 <=\'').$END_TIME).'\'');
$cursor = exequery ($connection, $query);
while ($ROW = mysql_fetch_array ($cursor))
{
$LEAVE_DATE1 = $ROW['LEAVE_DATE1'];
$LEAVE_DATE2 = $ROW['LEAVE_DATE2'];
$DIFF = datediff ('d', $LEAVE_DATE1, $LEAVE_DATE2);
$DAYS = ($DAYS + $DIFF);
}
$MY_DAYS = ($LEAVE_TYPE1 - $DAYS);
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"> 请假登记 (你的年假还剩 <font color="red">';
echo $MY_DAYS;
echo '</font>)</span><br>
</td>
</tr>
</table>
<br>
<div align="center">
<input type="button" value="新建请假登记" class="BigButton" onClick="location=\'new\';" title="新建请假登记">
<input type="button" value="请假历史记录" class="BigButton" onClick="location=\'history.php\';" title="查看过往的请假记录">
<br>
<br>
<table border="0" cellspacing="1" width="95%" class="small" bgcolor="#00';
echo '0000" cellpadding="3">
';
$LEAVE_COUNT = 0;
$query = (((''.'SELECT * from ATTEND_LEAVE where USER_ID=\'').$LOGIN_USER_ID).'\' and STATUS=\'1\'');
$cursor = exequery ($connection, $query);
while ($ROW = mysql_fetch_array ($cursor))
{
++$LEAVE_COUNT;
$LEAVE_ID = $ROW['LEAVE_ID'];
$LEADER_ID = $ROW['LEADER_ID'];
$LEAVE_DATE1 = $ROW['LEAVE_DATE1'];
$LEAVE_DATE2 = $ROW['LEAVE_DATE2'];
$LEAVE_TYPE = $ROW['LEAVE_TYPE'];
$REASON = $ROW['REASON'];
$DESTROY_TIME = $ROW['DESTROY_TIME'];
if (($DESTROY_TIME == '0000-00-00 00:00:00'))
{
$DESTROY_TIME = '';
}
$LEAVE_TYPE = str_replace ('<', '<', $LEAVE_TYPE);
$LEAVE_TYPE = str_replace ('>', '>', $LEAVE_TYPE);
$LEAVE_TYPE = stripslashes ($LEAVE_TYPE);
$ALLOW = $ROW['ALLOW'];
if (($ALLOW == '0'))
{
$ALLOW_DESC = '待批';
}
else
{
if (($ALLOW == '1'))
{
$ALLOW_DESC = '已批准';
}
else
{
if (($ALLOW == '2'))
{
$ALLOW_DESC = '未批准';
}
else
{
if (($ALLOW == '3'))
{
$ALLOW_DESC = '申请销假';
}
}
}
}
$LEADER_NAME = '';
$query1 = (((''.'SELECT * from USER where USER_ID=\'').$LEADER_ID).'\'');
$cursor1 = exequery ($connection, $query1);
if ($ROW = mysql_fetch_array ($cursor1))
{
$LEADER_NAME = $ROW['USER_NAME'];
}
echo ' <tr class="TableData">
<td nowrap align="center">';
echo $LEAVE_TYPE;
echo '</td>
<td nowrap align="center">';
echo $LEADER_NAME;
echo '</td>
<td nowrap align="center">';
echo $LEAVE_DATE1;
echo '</td>
<td nowrap align="center">';
echo $LEAVE_DATE2;
echo '</td>
<td nowrap align="center">';
echo $DESTROY_TIME;
echo '</td>
<td nowrap align="center" title="';
if (($ALLOW == 2))
{
echo ('原因：
'.$REASON);
}
echo '" style="cursor:hand;">';
echo $ALLOW_DESC;
echo '</td>
<td nowrap align="center">
';
if ((($ALLOW == '0') OR ($ALLOW == '2')))
{
echo ' <a href="delete.php?LEAVE_ID=';
echo $LEAVE_ID;
echo '">删除</a>
';
}
else
{
if (($ALLOW == '1'))
{
if (find_id ($TYPE_PRIV, 6))
{
echo ' <input type="checkbox" name="LEAVE_SMS2_REMIND';
echo $LEAVE_ID;
echo '" id="LEAVE_SMS2_REMIND';
echo $LEAVE_ID;
echo '" ';
if (find_id ($SMS2_REMIND, '6'))
{
echo 'checked';
}
echo '><label for="LEAVE_SMS2_REMIND';
echo $LEAVE_ID;
echo '">使用手机短信提醒</label>
';
}
echo ' <a href="javascript:leave_confirm(\'';
echo $LEAVE_ID;
echo '\');">申请销假</a>
';
}
else
{
if (($ALLOW == '3'))
{
echo '无';
}
}
}
echo ' </td>
</tr>
';
}
if ((0 < $LEAVE_COUNT))
{
echo ' <thead 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">申请销假时间</td>
<td nowrap align="center">状态</td>
<td nowrap align="center">操作</td>
</thead>
';
}
echo '</table>
</div>
</body>
</html>
';
?>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?