index.php

来自「通达OA2007SE源代码 非常好的」· PHP 代码 · 共 289 行

PHP
289 行
字号 
<?
  include_once 'inc/auth.php';
  $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();\',180000);
</script>
';
  echo '<s';
  echo 'cript>
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-';
  echo '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");
}
function td_clock(fieldname,pare)
{
  myleft=document.body.scrollLeft+event.clientX-event.offsetX-';
  echo '80;
  mytop=document.body.scrollTop+event.clientY-event.offsetY+140;
  window.showModalDialog("../clock.php?FIELDNAME="+fieldname,self,"edge:raised;scroll:0;status:0;help:0;resizable:1;dialogWidth:280px;dialogHeight:120px;dialogTop:"+mytop+"px;dialogLeft:"+myleft+"px");
}
</script>
</head>
<body class="bodycolor" topmargin="5">
<table border="0" width="100%" cellspacing="0" cellpadding="3" ';
  echo '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>
<div align="center">
';
  $CUR_TIME = date ('H:i', time ());
  $CUR_DAY = date ('Y-m-d', time ());
  echo '  <form action="out.php"  method="post" name="form1" class="big1" onsubmit="return CheckForm();">
  <b>
    因 <textarea name="OUT_TYPE" class="BigInput" cols="60" rows="3">';
  echo $OUT_TYPE;
  echo '</textarea>
    <br>
    日期 <input type="text" name="OUT_DATE" size="15" maxlength="5" class="BigStatic" readonly value="';
  echo $CUR_DAY;
  echo '">
         <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="';
  echo $CUR_TIME;
  echo '">
       <img src="/images/menu/clock.gif" border="0" align="absMiddle" style="cursor:hand" onclick="td_clock(\'form1.OUT_TIME1\');">
    至 <input type="text" name="OUT_TIME2" size="5" maxlength="5" class="BigInput" value="';
  echo $CUR_TIME;
  echo '">
       <img src="/images/menu/clock.gif" border="0" align="absMiddle" style="cursor:hand" onclick="td_clock(\'form1.OUT_TIME2\');"><br>
    向 ';
  echo '<s';
  echo 'elect 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'];
    if (($LOGIN_USER_ID == $USER_ID))
    {
      continue;
    }
    else
    {
      echo '       <option value="';
      echo $USER_ID;
      echo '">';
      echo $USER_NAME;
      echo '</option>
';
      continue;
    }
  }
  $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'];
    echo '       <option value="';
    echo $USER_ID;
    echo '">';
    echo $USER_NAME;
    echo '</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'];
      echo '          <option value="';
      echo $USER_ID;
      echo '">';
      echo $USER_NAME;
      echo '</option>
';
    }
  }
  echo '        </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))
  {
    echo '       <input type="checkbox" name="SMS2_REMIND" id="SMS2_REMIND" ';
    if (find_id ($SMS2_REMIND, '6'))
    {
      echo 'checked';
    }
    echo '><label for="SMS2_REMIND">使用手机短信提醒</label>
';
  }
  echo '    <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'];
    $REASON = $ROW['REASON'];
    $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 ('<', '&lt', $OUT_TYPE);
    $OUT_TYPE = str_replace ('>', '&gt', $OUT_TYPE);
    $OUT_TYPE = stripslashes ($OUT_TYPE);
    if (($ALLOW == '0'))
    {
      $ALLOW_DESC = '待批';
    }
    else
    {
      if (($ALLOW == '1'))
      {
        $ALLOW_DESC = '已批准';
      }
      else
      {
        if (($ALLOW == '2'))
        {
          $ALLOW_DESC = '未批准';
        }
      }
    }
    echo '    <tr class="TableData">
      <td nowrap align="center">';
    echo $CREATE_DATE;
    echo '</td>
      <td nowrap align="center">';
    echo $USER_NAME;
    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" 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')) OR (($ALLOW == '1') AND ($CUR_DATE < $SUBMIT_TIME1))))
    {
      echo '      <a href="delete.php?SUBMIT_TIME=';
      echo $SUBMIT_TIME;
      echo '">删除</a>
';
    }
    else
    {
      echo '      <a href="back.php?SUBMIT_TIME=';
      echo $SUBMIT_TIME;
      echo '">外出归来</a>
';
    }
    echo '    </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>
';
  }
  echo '</table>
</div>
</body>
</html>';
?>

index.php - 源码说明

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

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

⌨️ 快捷键说明

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