index.php

来自「通达OA2007SE源代码 非常好的」· PHP 代码 · 共 574 行 · 第 1/2 页

PHP
574 行
字号
12
<?
  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'];
  }
  $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();\',60000);
function LoadWindow2(STATUS,LEAVE_ID,USER_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?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))
  {
    echo '	if(document.all("OUT_SMS2_REMIND"+count).checked)
     MOBILE_FLAG=1;
  else
';
  }
  echo '     MOBILE_FLAG=0;
  if(CONFIRM==2)
  {
     URL="out_reason.php?CONFIRM="+CONFIRM+"&USER_ID="+USER_ID+"&SUBMIT_TIME="+SUBMIT_TIME+"&MOBILE_FLAG="+MOBILE_FLAG;  	
     window.open(URL,"reason","height=500,width=600,status=1,toolbar=no,menubar=no,location=no,scrollbars=yes,left=200,top=60,resizable=yes");  
  }
  else
  {
     URL="out_confirm.php?CONFIRM="+CONFIRM+"&USER_ID="+USER_ID+"&';
  echo '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))
  {
    echo '	if(document.all("LEAVE_SMS2_REMIND"+LEAVE_ID).checked)
	   MOBILE_FLAG=1;
  else
';
  }
  echo '     MOBILE_FLAG=0;
  if(CONFIRM==2)
  {
     URL="leave_reason.php?CONFIRM="+CONFIRM+"&USER_ID="+USER_ID+"&MOBILE_FLAG="+MOBILE_FLAG+"&LEAVE_ID="+LEAVE_ID;  	
     window.open(URL,"reason","height=500,width=600,status=1,toolbar=no,menubar=no,location=no,scrollbars=yes,left=200,top=60,resizable=yes");  
  }
  else
  {
     URL="leave_confirm.php?CONFIRM="+CONFIRM+"&USER_ID="+USER_ID';
  echo '+"&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))
  {
    echo '	if(document.all("EVECTION_SMS2_REMIND"+EVECTION_ID).checked)
	   MOBILE_FLAG=1;
  else
';
  }
  echo '     MOBILE_FLAG=0;
  if(CONFIRM==2)
  {
     URL="evection_reason.php?CONFIRM="+CONFIRM+"&USER_ID="+USER_ID+"&MOBILE_FLAG="+MOBILE_FLAG+"&EVECTION_ID="+EVECTION_ID;  	
     window.open(URL,"reason","height=500,width=600,status=1,toolbar=no,menubar=no,location=no,scrollbars=yes,left=200,top=60,resizable=yes");  
  }
  else
  {
     URL="evection_confirm.php?CONFIRM="+CONFIRM+"&USER_ID="+';
  echo '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 ());
  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"> 外出审批</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))
    {
      echo '    <table border="0" cellspacing="1" width="95%" class="small" bgcolor="#000000" cellpadding="3">
';
    }
    if ((($OUT_COUNT % 2) == 1))
    {
      $TableLine = 'TableLine1';
    }
    else
    {
      $TableLine = 'TableLine2';
    }
    echo '    <tr class="';
    echo $TableLine;
    echo '">
      <td nowrap align="center">';
    echo $USER_DEPT_NAME;
    echo '</td>
      <td nowrap align="center">';
    echo $USER_NAME;
    echo '</td>
      <td nowrap align="center">';
    echo $CREATE_DATE1;
    echo '</td>
      <td>';
    echo $OUT_TYPE;
    echo '</td>
      <td nowrap align="center">';
    echo $SUBMIT_TIME1;
    echo ' ';
    echo $OUT_TIME1;
    echo '</td>
      <td nowrap align="center">';
    echo $SUBMIT_TIME1;
    echo ' ';
    echo $OUT_TIME2;
    echo '</td>
      <td nowrap align="center">
';
    if (find_id ($TYPE_PRIV, 6))
    {
      echo '       <input type="checkbox" name="OUT_SMS2_REMIND';
      echo $OUT_COUNT;
      echo '" id="OUT_SMS2_REMIND';
      echo $OUT_COUNT;
      echo '" ';
      if (find_id ($SMS2_REMIND, '6'))
      {
        echo 'checked';
      }
      echo '><label for="OUT_SMS2_REMIND';
      echo $OUT_COUNT;
      echo '">手机提醒</label>
';
    }
    echo '       <a href="javascript:out_confirm(\'1\',\'';
    echo $USER_ID;
    echo '\',\'';
    echo $SUBMIT_TIME;
    echo '\',\'';
    echo $OUT_COUNT;
    echo '\');">批准</a>
       <a href="javascript:out_confirm(\'2\',\'';
    echo $USER_ID;
    echo '\',\'';
    echo $SUBMIT_TIME;
    echo '\',\'';
    echo $OUT_COUNT;
    echo '\');">不批准</a>
      </td>
    </tr>
';
  }
  if ((0 < $OUT_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>
    </table>
';
  }
  else
  {
    message ('', '无外出审批申请');
  }
  echo '
<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" HE';
  echo 'IGHT="20" align="absmiddle">';
  echo '<s';
  echo 'pan 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'];
    $DESTROY_TIME = $ROW['DESTROY_TIME'];
    if (($DESTROY_TIME == '0000-00-00 00:00:00'))
    {
12

index.php - 源码说明

本页面展示了「通达OA2007SE源代码 非常好的」中的 index.php 源码文件，采用 PHP 编程语言编写，共 574 行代码。您可以在线阅读完整代码内容，也可以返回资源详情页下载完整源码包进行本地学习和开发。

虫虫下载站收录了大量与2007相关的技术资源，包括源代码、技术文档、电路图等，是电子工程师和嵌入式开发者的专业学习平台。

⌨️ 快捷键说明

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