📄 index.php
字号:
<?
include_once("inc/auth.php");
?>
<html>
<head>
<title>外出登记</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<script Language=JavaScript>
window.setTimeout('this.location.reload();',180000);
</script>
<script>
function CheckForm()
{
if(document.form1.OUT_TIME1.value=="" || document.form1.OUT_TIME2.value=="")
{ alert("外出起止时间不能为空！");
return (false);
}
if(document.form1.OUT_TYPE.value=="")
{ alert("外出原因不能为空！");
return (false);
}
return (true);
}
function td_calendar(fieldname)
{
myleft=document.body.scrollLeft+event.clientX-event.offsetX-80;
mytop=document.body.scrollTop+event.clientY-event.offsetY+140;
window.showModalDialog("/inc/calendar.php?FIELDNAME="+fieldname,self,"edge:raised;scroll:0;status:0;help:0;resizable:1;dialogWidth:280px;dialogHeight:215px;dialogTop:"+mytop+"px;dialogLeft:"+myleft+"px");
}
</script>
</head>
<body class="bodycolor" topmargin="5">
<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"><span class="big3"> 外出登记</span><br>
</td>
</tr>
</table>
<br>
<div align="center">
<?
$CUR_TIME=date("H:i",time());
$CUR_DAY=date("Y-m-d",time());
?>
<form action="out.php" method="post" name="form1" class="big1" onsubmit="return CheckForm();">
<b>
因 <input type="text" name="OUT_TYPE" size="42" maxlength="50" class="BigInput"><br>
日期 <input type="text" name="OUT_DATE" size="15" maxlength="5" class="BigStatic" readonly value="<?=$CUR_DAY?>">
<img src="/images/menu/calendar.gif" border="0" style="cursor:hand" onclick="td_calendar('form1.OUT_DATE');">
由 <input type="text" name="OUT_TIME1" size="5" maxlength="5" class="BigInput" value="<?=$CUR_TIME?>">
至 <input type="text" name="OUT_TIME2" size="5" maxlength="5" class="BigInput" value="<?=$CUR_TIME?>"><br>
向 <select name="LEADER_ID" class="BigSelect">
<?
$COUNT=0;
$query = "select * from ATTEND_MANAGER where MANAGER_ID=1";
$cursor=exequery($connection,$query);
if($ROW=mysql_fetch_array($cursor))
{
$MANAGER_ID=$ROW["MANAGER_ID"];
$MANAGERS=$ROW["MANAGERS"];
}
$query = "SELECT * from USER,USER_PRIV where DEPT_ID=$LOGIN_DEPT_ID and find_in_set(USER.USER_ID,'$MANAGERS') and USER.USER_PRIV=USER_PRIV.USER_PRIV order by PRIV_NO,USER_NO,USER_NAME";
$cursor=exequery($connection,$query);
while($ROW=mysql_fetch_array($cursor))
{
$COUNT++;
$USER_ID=$ROW["USER_ID"];
$USER_NAME=$ROW["USER_NAME"];
?>
<option value="<?=$USER_ID?>"><?=$USER_NAME?></option>
<?
}
$query = "SELECT * from USER,USER_PRIV where DEPT_ID!=$LOGIN_DEPT_ID and find_in_set(USER.USER_ID,'$MANAGERS') and USER.USER_PRIV=USER_PRIV.USER_PRIV order by PRIV_NO,USER_NO,USER_NAME";
$cursor=exequery($connection,$query);
while($ROW=mysql_fetch_array($cursor))
{
$COUNT++;
$USER_ID=$ROW["USER_ID"];
$USER_NAME=$ROW["USER_NAME"];
?>
<option value="<?=$USER_ID?>"><?=$USER_NAME?></option>
<?
}
if($COUNT==0)
{
$query = "SELECT * from USER_PRIV where USER_PRIV=$LOGIN_USER_PRIV";
$cursor= exequery($connection,$query);
if($ROW=mysql_fetch_array($cursor))
$PRIV_NO=$ROW["PRIV_NO"];
$query = "SELECT * from USER,USER_PRIV where USER.USER_PRIV=USER_PRIV.USER_PRIV and PRIV_NO<=$PRIV_NO order by PRIV_NO,USER_NO,USER_NAME";
$cursor= exequery($connection,$query);
while($ROW=mysql_fetch_array($cursor))
{
$USER_ID=$ROW["USER_ID"];
$USER_NAME=$ROW["USER_NAME"];
?>
<option value="<?=$USER_ID?>"><?=$USER_NAME?></option>
<?
}
}
?>
</select>
<?
$query = "select * from SMS2_PRIV";
$cursor=exequery($connection,$query);
if($ROW=mysql_fetch_array($cursor))
$TYPE_PRIV=$ROW["TYPE_PRIV"];
if(find_id($TYPE_PRIV,6)) //检查该模块是否允许手机提醒
{
?>
<input type="checkbox" name="SMS2_REMIND" id="SMS2_REMIND" <?if($SMS2_REMIND=="1") echo "checked";?>><label for="SMS2_REMIND">使用手机短信提醒</label>
<?
}
?>
<input type="submit" value="申请外出" class="BigButton" title="申请外出">
</b>
</form>
<br>
<table border="0" cellspacing="1" width="95%" class="small" bgcolor="#000000" cellpadding="3">
<?
//---- 查看外出登记情况 -----
$OUT_COUNT=0;
$CUR_DATE=date("Y-m-d",time());
$query = "SELECT * from ATTEND_OUT where USER_ID='$LOGIN_USER_ID' and STATUS='0' order by SUBMIT_TIME";
$cursor= exequery($connection,$query);
while($ROW=mysql_fetch_array($cursor))
{
$OUT_COUNT++;
$CREATE_DATE=$ROW["CREATE_DATE"];
$OUT_TIME1=$ROW["OUT_TIME1"];
$OUT_TIME2=$ROW["OUT_TIME2"];
$OUT_TYPE=$ROW["OUT_TYPE"];
$ALLOW=$ROW["ALLOW"];
$LEADER_ID=$ROW["LEADER_ID"];
$SUBMIT_TIME=$ROW["SUBMIT_TIME"];
$SUBMIT_TIME1=substr($SUBMIT_TIME,0,10);
$USER_NAME="";
$query = "SELECT * from USER where USER_ID='$LEADER_ID'";
$cursor1= exequery($connection,$query);
if($ROW=mysql_fetch_array($cursor1))
$USER_NAME=$ROW["USER_NAME"];
$OUT_TYPE=str_replace("<","<",$OUT_TYPE);
$OUT_TYPE=str_replace(">",">",$OUT_TYPE);
$OUT_TYPE=stripslashes($OUT_TYPE);
if($ALLOW=="0")
$ALLOW_DESC="待批";
else if($ALLOW=="1")
$ALLOW_DESC="已批准";
else if($ALLOW=="2")
$ALLOW_DESC="未批准";
?>
<tr class="TableData">
<td nowrap align="center"><?=$CREATE_DATE?></td>
<td nowrap align="center"><?=$USER_NAME?></td>
<td><?=$OUT_TYPE?></td>
<td nowrap align="center"><?=$SUBMIT_TIME1?> <?=$OUT_TIME1?></td>
<td nowrap align="center"><?=$SUBMIT_TIME1?> <?=$OUT_TIME2?></td>
<td nowrap align="center"><?=$ALLOW_DESC?></td>
<td nowrap align="center">
<?
if($ALLOW=="0" || $ALLOW=="2"||($ALLOW=="1" && $SUBMIT_TIME1>$CUR_DATE))
{
?>
<a href="delete.php?SUBMIT_TIME=<?=$SUBMIT_TIME?>">删除</a>
<?
}
else
{
?>
<a href="back.php?SUBMIT_TIME=<?=$SUBMIT_TIME?>">外出归来</a>
<?
}
?>
</td>
</tr>
<?
}
if($OUT_COUNT>0)
{
?>
<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>
<?
}
?>
</table>
</div>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -