duty_edit.php

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

PHP
298 行
字号 
<?
  include_once 'inc/auth.php';
  include_once 'inc/utility_all.php';
  echo '
<html>
<head>
<title>上下班登记修改</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body class="bodycolor" topmargin="5">
';
  $query = ((''.'SELECT * from ATTEND_CONFIG where DUTY_TYPE=').$DUTY_TYPE);
  $cursor = exequery ($connection, $query);
  if ($ROW = mysql_fetch_array ($cursor))
  {
    $DUTY_NAME = $ROW['DUTY_NAME'];
    $DUTY_TIME1 = $ROW['DUTY_TIME1'];
    $DUTY_TIME2 = $ROW['DUTY_TIME2'];
    $DUTY_TIME3 = $ROW['DUTY_TIME3'];
    $DUTY_TIME4 = $ROW['DUTY_TIME4'];
    $DUTY_TIME5 = $ROW['DUTY_TIME5'];
    $DUTY_TIME6 = $ROW['DUTY_TIME6'];
    $DUTY_TYPE1 = $ROW['DUTY_TYPE1'];
    $DUTY_TYPE2 = $ROW['DUTY_TYPE2'];
    $DUTY_TYPE3 = $ROW['DUTY_TYPE3'];
    $DUTY_TYPE4 = $ROW['DUTY_TYPE4'];
    $DUTY_TYPE5 = $ROW['DUTY_TYPE5'];
    $DUTY_TYPE6 = $ROW['DUTY_TYPE6'];
  }
  $query = (((''.'SELECT * from USER where USER_ID=\'').$USER_ID).'\'');
  $cursor = exequery ($connection, $query);
  if ($ROW = mysql_fetch_array ($cursor))
  {
    $USER_NAME = $ROW['USER_NAME'];
    $DEPT_ID = $ROW['DEPT_ID'];
  }
  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"> 上下班登记修改 - ';
  echo $USER_NAME;
  echo ' - ';
  echo format_date ($SOME_DATE);
  echo '</span><br>
    </td>
  </tr>
</table>
<br>
';
  message ('注意', '输入的时间格式要形如 12:12:12，不填写则代表未登记');
  echo '
<form action="duty_update.php" name="form1">
<table border="0" cellspacing="1" width="95%" class="small" bgcolor="#000000" cellpadding="3" align="center">
  <tr class="TableHeader">
';
  if (($DUTY_TIME1 != ''))
  {
    if (($DUTY_TYPE1 == '1'))
    {
      $DUTY_TYPE_DESC = '上班';
    }
    else
    {
      $DUTY_TYPE_DESC = '下班';
    }
    echo '    <td nowrap align="center">';
    echo $DUTY_TYPE_DESC;
    echo ' (';
    echo $DUTY_TIME1;
    echo ')</td>
';
  }
  if (($DUTY_TIME2 != ''))
  {
    if (($DUTY_TYPE2 == '1'))
    {
      $DUTY_TYPE_DESC = '上班';
    }
    else
    {
      $DUTY_TYPE_DESC = '下班';
    }
    echo '    <td nowrap align="center">';
    echo $DUTY_TYPE_DESC;
    echo ' (';
    echo $DUTY_TIME2;
    echo ')</td>
';
  }
  if (($DUTY_TIME3 != ''))
  {
    if (($DUTY_TYPE3 == '1'))
    {
      $DUTY_TYPE_DESC = '上班';
    }
    else
    {
      $DUTY_TYPE_DESC = '下班';
    }
    echo '    <td nowrap align="center">';
    echo $DUTY_TYPE_DESC;
    echo ' (';
    echo $DUTY_TIME3;
    echo ')</td>
';
  }
  if (($DUTY_TIME4 != ''))
  {
    if (($DUTY_TYPE4 == '1'))
    {
      $DUTY_TYPE_DESC = '上班';
    }
    else
    {
      $DUTY_TYPE_DESC = '下班';
    }
    echo '    <td nowrap align="center">';
    echo $DUTY_TYPE_DESC;
    echo ' (';
    echo $DUTY_TIME4;
    echo ')</td>
';
  }
  if (($DUTY_TIME5 != ''))
  {
    if (($DUTY_TYPE5 == '1'))
    {
      $DUTY_TYPE_DESC = '上班';
    }
    else
    {
      $DUTY_TYPE_DESC = '下班';
    }
    echo '    <td nowrap align="center">';
    echo $DUTY_TYPE_DESC;
    echo ' (';
    echo $DUTY_TIME5;
    echo ')</td>
';
  }
  if (($DUTY_TIME6 != ''))
  {
    if (($DUTY_TYPE6 == '1'))
    {
      $DUTY_TYPE_DESC = '上班';
    }
    else
    {
      $DUTY_TYPE_DESC = '下班';
    }
    echo '    <td nowrap align="center">';
    echo $DUTY_TYPE_DESC;
    echo ' (';
    echo $DUTY_TIME6;
    echo ')</td>
  </tr>
';
  }
  $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 ((($USER_COUNT % 2) == 1))
  {
    $TableLine = 'TableLine1';
  }
  else
  {
    $TableLine = 'TableLine2';
  }
  echo '    <tr class="';
  echo $TableLine;
  echo '">
';
  if (($DUTY_TIME1 != ''))
  {
    $query = (((((''.'SELECT * from ATTEND_DUTY where USER_ID=\'').$USER_ID).'\' and to_days(REGISTER_TIME)=to_days(\'').$SOME_DATE).'\') and REGISTER_TYPE=\'1\'');
    $cursor = exequery ($connection, $query);
    if ($ROW = mysql_fetch_array ($cursor))
    {
      $REGISTER_TIME1 = $ROW['REGISTER_TIME'];
      $REGISTER_TIME1 = strtok ($REGISTER_TIME1, ' ');
      $REGISTER_TIME1 = strtok (' ');
    }
    echo '      <td nowrap align="center">
      <input name="REGISTER_TIME1" value="';
    echo $REGISTER_TIME1;
    echo '" class="SmallInput" size="8">
      </td>
';
  }
  if (($DUTY_TIME2 != ''))
  {
    $query = (((((''.'SELECT * from ATTEND_DUTY where USER_ID=\'').$USER_ID).'\' and to_days(REGISTER_TIME)=to_days(\'').$SOME_DATE).'\') and REGISTER_TYPE=\'2\'');
    $cursor = exequery ($connection, $query);
    if ($ROW = mysql_fetch_array ($cursor))
    {
      $REGISTER_TIME2 = $ROW['REGISTER_TIME'];
      $REGISTER_TIME2 = strtok ($REGISTER_TIME2, ' ');
      $REGISTER_TIME2 = strtok (' ');
    }
    echo '      <td nowrap align="center">
      <input name="REGISTER_TIME2" value="';
    echo $REGISTER_TIME2;
    echo '" class="SmallInput" size="8">
      </td>
';
  }
  if (($DUTY_TIME3 != ''))
  {
    $query = (((((''.'SELECT * from ATTEND_DUTY where USER_ID=\'').$USER_ID).'\' and to_days(REGISTER_TIME)=to_days(\'').$SOME_DATE).'\') and REGISTER_TYPE=\'3\'');
    $cursor = exequery ($connection, $query);
    if ($ROW = mysql_fetch_array ($cursor))
    {
      $REGISTER_TIME3 = $ROW['REGISTER_TIME'];
      $REGISTER_TIME3 = strtok ($REGISTER_TIME3, ' ');
      $REGISTER_TIME3 = strtok (' ');
    }
    echo '      <td nowrap align="center">
      <input name="REGISTER_TIME3" value="';
    echo $REGISTER_TIME3;
    echo '" class="SmallInput" size="8">
      </td>
';
  }
  if (($DUTY_TIME4 != ''))
  {
    $query = (((((''.'SELECT * from ATTEND_DUTY where USER_ID=\'').$USER_ID).'\' and to_days(REGISTER_TIME)=to_days(\'').$SOME_DATE).'\') and REGISTER_TYPE=\'4\'');
    $cursor = exequery ($connection, $query);
    if ($ROW = mysql_fetch_array ($cursor))
    {
      $REGISTER_TIME4 = $ROW['REGISTER_TIME'];
      $REGISTER_TIME4 = strtok ($REGISTER_TIME4, ' ');
      $REGISTER_TIME4 = strtok (' ');
    }
    echo '      <td nowrap align="center">
      <input name="REGISTER_TIME4" value="';
    echo $REGISTER_TIME4;
    echo '" class="SmallInput" size="8">
      </td>
';
  }
  if (($DUTY_TIME5 != ''))
  {
    $query = (((((''.'SELECT * from ATTEND_DUTY where USER_ID=\'').$USER_ID).'\' and to_days(REGISTER_TIME)=to_days(\'').$SOME_DATE).'\') and REGISTER_TYPE=\'5\'');
    $cursor = exequery ($connection, $query);
    if ($ROW = mysql_fetch_array ($cursor))
    {
      $REGISTER_TIME5 = $ROW['REGISTER_TIME'];
      $REGISTER_TIME5 = strtok ($REGISTER_TIME5, ' ');
      $REGISTER_TIME5 = strtok (' ');
    }
    echo '      <td nowrap align="center">
      <input name="REGISTER_TIME5" value="';
    echo $REGISTER_TIME5;
    echo '" class="SmallInput" size="8">
      </td>
';
  }
  if (($DUTY_TIME6 != ''))
  {
    $query = (((((''.'SELECT * from ATTEND_DUTY where USER_ID=\'').$USER_ID).'\' and to_days(REGISTER_TIME)=to_days(\'').$SOME_DATE).'\') and REGISTER_TYPE=\'6\'');
    $cursor = exequery ($connection, $query);
    if ($ROW = mysql_fetch_array ($cursor))
    {
      $REGISTER_TIME6 = $ROW['REGISTER_TIME'];
      $REGISTER_TIME6 = strtok ($REGISTER_TIME6, ' ');
      $REGISTER_TIME6 = strtok (' ');
    }
    echo '      <td nowrap align="center">
      <input name="REGISTER_TIME6" value="';
    echo $REGISTER_TIME6;
    echo '" class="SmallInput" size="8">
      </td>
';
  }
  echo '   </tr>
</table>
<br>
<div align="center">
  <input type="hidden" name="USER_ID" value="';
  echo $USER_ID;
  echo '">
  <input type="hidden" name="SOME_DATE" value="';
  echo $SOME_DATE;
  echo '">
  <input type="submit"  value="保存" class="BigButton">&nbsp;&nbsp;
  <input type="button"  value="返回" class="BigButton" onClick="history.back();">
</div>
</form>
</body>
</html>';
?>

duty_edit.php - 源码说明

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

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

⌨️ 快捷键说明

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