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

📄 index.php

📁 极限网络智能办公系统 Office Automation V3.0官方100％源代码.
💻 PHP
字号:
🔍 
<?
include_once("inc/auth.php");

$query = "select * from SMS2_PRIV";
$cursor1=exequery($connection,$query);
if($ROW=mysql_fetch_array($cursor1))
   $TYPE_PRIV=$ROW["TYPE_PRIV"];
?>

<html>
<head>
<title>考勤管理</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<script Language=JavaScript>
window.setTimeout('this.location.reload();',60000);
function LoadWindow2(STATUS,LEAVE_ID,USER_ID)
{
<?
if(find_id($TYPE_PRIV,6)) //检查该模块是否允许手机提醒
{
?>
	if(document.all("LEAVE_SMS2_REMIND"+LEAVE_ID).checked)
	MOBILE_FLAG=1;
  else
<?
}
?>
  MOBILE_FLAG=0;
  URL="back.php?STATUS="+STATUS+"&LEAVE_ID="+LEAVE_ID+"&USER_ID="+USER_ID+"&MOBILE_FLAG="+MOBILE_FLAG;
  myleft=(screen.availWidth-650)/2;
  window.open(URL,"formul_edit","height=350,width=650,status=0,toolbar=no,menubar=no,location=no,scrollbars=yes,top=150,left="+myleft+",resizable=yes");
}
function out_confirm(CONFIRM,USER_ID,SUBMIT_TIME,count)
{
<?
if(find_id($TYPE_PRIV,6)) //检查该模块是否允许手机提醒
{
?>
	if(document.all("OUT_SMS2_REMIND"+count).checked)
	MOBILE_FLAG=1;
  else
<?
}
?>
  MOBILE_FLAG=0;
  URL="out_confirm.php?CONFIRM="+CONFIRM+"&USER_ID="+USER_ID+"&SUBMIT_TIME="+SUBMIT_TIME+"&MOBILE_FLAG="+MOBILE_FLAG;
  window.location=URL;
}
function leave_confirm(CONFIRM,USER_ID,LEAVE_ID)
{
<?
if(find_id($TYPE_PRIV,6)) //检查该模块是否允许手机提醒
{
?>
	if(document.all("LEAVE_SMS2_REMIND"+LEAVE_ID).checked)
	MOBILE_FLAG=1;
  else
<?
}
?>
  MOBILE_FLAG=0;
  URL="leave_confirm.php?CONFIRM="+CONFIRM+"&USER_ID="+USER_ID+"&MOBILE_FLAG="+MOBILE_FLAG+"&LEAVE_ID="+LEAVE_ID;
  window.location=URL;
}

function evection_confirm(CONFIRM,EVECTION_ID,USER_ID)
{
<?
if(find_id($TYPE_PRIV,6)) //检查该模块是否允许手机提醒
{
?>
	if(document.all("EVECTION_SMS2_REMIND"+EVECTION_ID).checked)
	MOBILE_FLAG=1;
  else
<?
}
?>
  MOBILE_FLAG=0;
  URL="evection_confirm.php?CONFIRM="+CONFIRM+"&USER_ID="+USER_ID+"&MOBILE_FLAG="+MOBILE_FLAG+"&EVECTION_ID="+EVECTION_ID;
  window.location=URL;
}
</script>
</head>
<body class="bodycolor" topmargin="5">

<?
$CUR_DATE=date("Y-m-d",time());
?>

<!------------------------------------- 今日外出审批 ------------------------------->

<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>

<?
 if($LOGIN_USER_ID=="admin")
    $query = "SELECT * from ATTEND_OUT,USER where ATTEND_OUT.USER_ID=USER.USER_ID and ALLOW='0' order by USER.USER_ID";
 else
    $query = "SELECT * from ATTEND_OUT,USER where ATTEND_OUT.USER_ID=USER.USER_ID and LEADER_ID='$LOGIN_USER_ID' and ALLOW='0' order by USER.USER_ID";
 $cursor= exequery($connection,$query);
 $OUT_COUNT=0;
 while($ROW=mysql_fetch_array($cursor))
 {
   $OUT_COUNT++;
   $USER_ID=$ROW["USER_ID"];
   $USER_NAME=$ROW["USER_NAME"];
   $OUT_TYPE=$ROW["OUT_TYPE"];
   $OUT_TIME1=$ROW["OUT_TIME1"];
   $OUT_TIME2=$ROW["OUT_TIME2"];
   $ALLOW=$ROW["ALLOW"];
   $CREATE_DATE1=$ROW["CREATE_DATE"];
   $DEPT_ID=$ROW["DEPT_ID"];
   $SUBMIT_TIME=$ROW["SUBMIT_TIME"];
   $SUBMIT_TIME1=substr($SUBMIT_TIME,0,10);
   $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($OUT_COUNT==1)
    {
?>
    <table border="0" cellspacing="1" width="95%" class="small" bgcolor="#000000" cellpadding="3">
<?
    }

    if($OUT_COUNT%2==1)
       $TableLine="TableLine1";
    else
       $TableLine="TableLine2";
?>
    <tr class="<?=$TableLine?>">
      <td nowrap align="center"><?=$USER_DEPT_NAME?></td>
      <td nowrap align="center"><?=$USER_NAME?></td>
      <td nowrap align="center"><?=$CREATE_DATE1?></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">
<?
if(find_id($TYPE_PRIV,6)) //检查该模块是否允许手机提醒
{
?>
       <input type="checkbox" name="OUT_SMS2_REMIND<?=$OUT_COUNT?>" id="OUT_SMS2_REMIND<?=$OUT_COUNT?>" <?if($SMS2_REMIND=="1") echo "checked";?>><label for="OUT_SMS2_REMIND<?=$OUT_COUNT?>">手机提醒</label>
<?
}
?>
       <a href="javascript:out_confirm('1','<?=$USER_ID?>','<?=$SUBMIT_TIME?>','<?=$OUT_COUNT?>');">批准</a>
       <a href="javascript:out_confirm('2','<?=$USER_ID?>','<?=$SUBMIT_TIME?>','<?=$OUT_COUNT?>');">不批准</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>
<?
 }
 else
    message("","无外出审批申请");
?>

<br>
<table width="95%" border="0" cellspacing="0" cellpadding="0" height="3">
 <tr>
   <td background="/images/dian1.gif" width="100%"></td>
 </tr>
</table>

<!------------------------------------- 请假审批 ------------------------------->

<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>

<?
 if($LOGIN_USER_ID=="admin")
    $query = "SELECT * from ATTEND_LEAVE,USER where ATTEND_LEAVE.USER_ID=USER.USER_ID and status='1' and allow in('0','3')";
 else
    $query = "SELECT * from ATTEND_LEAVE,USER where ATTEND_LEAVE.USER_ID=USER.USER_ID and LEADER_ID='$LOGIN_USER_ID' and status='1' and allow in('0','3')";
 $cursor= exequery($connection,$query);
 $LEAVE_COUNT=0;
 while($ROW=mysql_fetch_array($cursor))
 {
   $LEAVE_COUNT++;
   $LEAVE_ID=$ROW["LEAVE_ID"];
   $USER_ID=$ROW["USER_ID"];
   $USER_NAME=$ROW["USER_NAME"];

   $LEAVE_DATE1=$ROW["LEAVE_DATE1"];

   $LEAVE_DATE2=$ROW["LEAVE_DATE2"];

   $LEAVE_TYPE=$ROW["LEAVE_TYPE"];

   $ALLOW=$ROW["ALLOW"];

   $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"];

   if($LEAVE_COUNT==1)
   {
?>

    <table border="0" cellspacing="1" width="95%" class="small" bgcolor="#000000" cellpadding="3">

<?
   }

    if($LEAVE_COUNT%2==1)
       $TableLine="TableLine1";
    else
       $TableLine="TableLine2";
?>
    <tr class="<?=$TableLine?>">
      <td nowrap align="center"><?=$USER_DEPT_NAME?></td>
      <td nowrap align="center"><?=$USER_NAME?></td>
      <td nowrap align="center"><?=$LEAVE_TYPE?></td>
      <td nowrap align="center"><?=$LEAVE_DATE1?></td>
      <td nowrap align="center"><?=$LEAVE_DATE2?></td>
<?
      if($ALLOW=="0")
      {
?>
      <td nowrap align="center">请假申请</td>
      <td nowrap align="center">
<?
$query = "select * from SMS2_PRIV";
$cursor1=exequery($connection,$query);
if($ROW=mysql_fetch_array($cursor1))
   $TYPE_PRIV=$ROW["TYPE_PRIV"];

if(find_id($TYPE_PRIV,6)) //检查该模块是否允许手机提醒
{
?>
       <input type="checkbox" name="LEAVE_SMS2_REMIND<?=$LEAVE_ID?>" id="LEAVE_SMS2_REMIND<?=$LEAVE_ID?>" <?if($SMS2_REMIND=="1") echo "checked";?>><label for="LEAVE_SMS2_REMIND<?=$LEAVE_ID?>">手机提醒</label>
<?
}
?>

          <a href="javascript:leave_confirm('1','<?=$USER_ID?>','<?=$LEAVE_ID?>');">批准</a>
          <a href="javascript:leave_confirm('2','<?=$USER_ID?>','<?=$LEAVE_ID?>');">不批准</a>
<?
      }
      else
      {
?>
      <td nowrap align="center">销假申请</td>
      <td nowrap align="center">
<?
$query = "select * from SMS2_PRIV";
$cursor1=exequery($connection,$query);
if($ROW=mysql_fetch_array($cursor1))
   $TYPE_PRIV=$ROW["TYPE_PRIV"];

if(find_id($TYPE_PRIV,6)) //检查该模块是否允许手机提醒
{
?>
       <input type="checkbox" name="LEAVE_SMS2_REMIND<?=$LEAVE_ID?>" id="LEAVE_SMS2_REMIND<?=$LEAVE_ID?>" <?if($SMS2_REMIND=="1") echo "checked";?>><label for="LEAVE_SMS2_REMIND<?=$LEAVE_ID?>">手机提醒</label>
<?
}
?>
          <a href="javascript:LoadWindow2('2','<?=$LEAVE_ID?>','<?=$USER_ID?>');">销假</a>
      </td>
<?
      }
?>
      </td>
    </tr>
<?
 }

 if($LEAVE_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>
<?
 }
 else
    message("","无请假审批申请");
?>


<br>
<table width="95%" border="0" cellspacing="0" cellpadding="0" height="3">
 <tr>
   <td background="/images/dian1.gif" width="100%"></td>
 </tr>
</table>

<!------------------------------------- 出差审批 ------------------------------->

<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>

<?
 if($LOGIN_USER_ID=="admin")
    $query = "SELECT * from ATTEND_EVECTION,USER where ATTEND_EVECTION.USER_ID=USER.USER_ID and status='1' and allow='0'";
 else
    $query = "SELECT * from ATTEND_EVECTION,USER where ATTEND_EVECTION.USER_ID=USER.USER_ID and LEADER_ID='$LOGIN_USER_ID' and status='1' and allow='0'";
 $cursor= exequery($connection,$query);
 $EVECTION_COUNT=0;
 while($ROW=mysql_fetch_array($cursor))
 {
   $EVECTION_COUNT++;
   $EVECTION_ID=$ROW["EVECTION_ID"];
   $USER_ID=$ROW["USER_ID"];
   $USER_NAME=$ROW["USER_NAME"];
   $REASON=$ROW["REASON"];

   $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"];

   $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"];

   if($EVECTION_COUNT==1)
   {
?>
    <table border="0" cellspacing="1" width="95%" class="small" bgcolor="#000000" cellpadding="3">
<?
   }

    if($EVECTION_COUNT%2==1)
       $TableLine="TableLine1";
    else
       $TableLine="TableLine2";
?>
    <tr class="<?=$TableLine?>">
      <td nowrap align="center"><?=$USER_DEPT_NAME?></td>
      <td nowrap align="center"><?=$USER_NAME?></td>
      <td nowrap align="center"><?=$EVECTION_DEST?></td>
      <td nowrap align="center"><?=$REASON?></td>
      <td nowrap align="center"><?=$EVECTION_DATE1?></td>
      <td nowrap align="center"><?=$EVECTION_DATE2?></td>
      <td nowrap align="center">
<?
$query = "select * from SMS2_PRIV";
$cursor1=exequery($connection,$query);
if($ROW=mysql_fetch_array($cursor1))
   $TYPE_PRIV=$ROW["TYPE_PRIV"];

if(find_id($TYPE_PRIV,6)) //检查该模块是否允许手机提醒
{
?>
       <input type="checkbox" name="EVECTION_SMS2_REMIND<?=$EVECTION_ID?>" id="EVECTION_SMS2_REMIND<?=$EVECTION_ID?>" <?if($SMS2_REMIND=="1") echo "checked";?>><label for="EVECTION_SMS2_REMIND<?=$EVECTION_ID?>">手机提醒</label>
<?
}
?>
       <a href="javascript:evection_confirm('1','<?=$EVECTION_ID?>','<?=$USER_ID?>');">批准</a>
       <a href="javascript:evection_confirm('2','<?=$EVECTION_ID?>','<?=$USER_ID?>');">不批准</a>
      </td>
    </tr>
<?
 }

 if($EVECTION_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>
<?
 }
 else
    message("","无出差审批申请");
?>

</body>
</html>

⌨️ 快捷键说明

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