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

📄 modify.php

📁 通达OA2007SE源代码 非常好的
💻 PHP
字号:
<?
  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">
';
  echo '<s';
  echo 'cript Language="JavaScript">
function IsNumber(str)
{
   return str.match(/^[0-9]*$/)!=null;
}
function CheckForm()
{
   if(document.form1.VU_END.value=="")
   {
   	  alert("结束时间不能为空!");
      return (false);
   }
   if(document.form1.VU_MILEAGE.value!=""&&!IsNumber(document.form1.VU_MILEAGE.value))
   {
   	  alert("里程应为数字!");
      return (false);
   }
';
  echo '   form1.submit();
}
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");';
  echo '
}
function td_clock(fieldname)
{
  myleft=document.body.scrollLeft+event.clientX-event.offsetX-80;
  mytop=document.body.scrollTop+event.clientY-event.offsetY+140;
  window.showModalDialog("/inc/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>
';
  echo '
<body class="bodycolor" topmargin="5">
';
  $CUR_TIME = date ('Y-m-d H:i:s', time ());
  if (($VU_ID != ''))
  {
    $query = (((''.'SELECT * from VEHICLE_USAGE  where VU_ID=\'').$VU_ID).'\'');
    $cursor = exequery ($connection, $query);
    if ($ROW = mysql_fetch_array ($cursor))
    {
      $V_ID = $ROW['V_ID'];
      $VU_PROPOSER = $ROW['VU_PROPOSER'];
      $VU_REQUEST_DATE = $ROW['VU_REQUEST_DATE'];
      $VU_USER = $ROW['VU_USER'];
      $VU_REASON = $ROW['VU_REASON'];
      $VU_REASON = str_replace ('
', '<br>', $VU_REASON);
      $VU_START = $ROW['VU_START'];
      $VU_END = $ROW['VU_END'];
      $VU_MILEAGE = $ROW['VU_MILEAGE'];
      $VU_DEPT = $ROW['VU_DEPT'];
      $VU_STATUS = $ROW['VU_STATUS'];
      $VU_REMARK = $ROW['VU_REMARK'];
      $VU_DESTINATION = $ROW['VU_DESTINATION'];
      $VU_OPERATOR = $ROW['VU_OPERATOR'];
      $VU_DRIVER = $ROW['VU_DRIVER'];
      $DEPT_MANAGER = $ROW['DEPT_MANAGER'];
      $query = (((''.'SELECT * from USER where USER_ID=\'').$DEPT_MANAGER).'\'');
      $cursor = exequery ($connection, $query);
      if ($ROW = mysql_fetch_array ($cursor))
      {
        $DEPT_MANAGER_NAME = $ROW['USER_NAME'];
      }
      if (($VU_START == '0000-00-00 00:00:00'))
      {
        $VU_START = '';
      }
      if (($VU_END == '0000-00-00 00:00:00'))
      {
        $VU_END = '';
      }
    }
  }
  else
  {
    $VU_START = $CUR_TIME;
    $VU_END = $CUR_TIME;
  }
  if ((($VU_REQUEST_DATE == '0000-00-00 00:00:00') OR ($VU_REQUEST_DATE == '')))
  {
    $VU_REQUEST_DATE = $CUR_TIME;
  }
  if (($VU_PROPOSER == ''))
  {
    $VU_PROPOSER = $LOGIN_USER_ID;
  }
  $query = (((''.'SELECT * from USER  where USER_ID=\'').$VU_PROPOSER).'\'');
  $cursor = exequery ($connection, $query);
  if ($ROW = mysql_fetch_array ($cursor))
  {
    $VU_PROPOSER_NAME = $ROW['USER_NAME'];
  }
  if (($VU_DEPT != ''))
  {
    $query = ((''.'SELECT * from DEPARTMENT  where DEPT_ID=').$VU_DEPT);
    $cursor = exequery ($connection, $query);
    if ($ROW = mysql_fetch_array ($cursor))
    {
      $VU_DEPT_FIELD_DESC = $ROW['DEPT_NAME'];
    }
  }
  echo '
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
  <tr>
    <td class="Big"><img src="/images/notify_new.gif" align="absmiddle" width="22" height="18">';
  echo '<s';
  echo 'pan class="big3"> 车辆使用信息修改</span>
    </td>
  </tr>
</table>
<table align="center" border="0" width="620" cellpadding="2" cellspacing="1" align="center" bgcolor="#000000" class="small">
<form enctype="multipart/form-data" action="submit.php" method="post" name="form1">
    <tr>
      <td nowrap class="TableContent" width="80"> 车 牌 号:</td>
      <td class="TableData" width="230">
';
  $query = (((''.'SELECT * from VEHICLE where V_ID=\'').$V_ID).'\'');
  $cursor1 = exequery ($connection, $query);
  if ($ROW1 = mysql_fetch_array ($cursor1))
  {
    echo $V_NUM = $ROW1['V_NUM'];
  }
  echo '      </td>
      <td nowrap class="TableContent" width="80"> 司  机:</td>
      <td class="TableData" width="230">';
  echo $VU_DRIVER;
  echo '</td>
    </tr>
    <tr>
      <td nowrap class="TableContent" width="80"> 用 车 人:</td>
      <td class="TableData">';
  echo $VU_USER;
  echo '</td>
      <td nowrap class="TableContent" width="80"> 用车部门:</td>
      <td class="TableData">';
  echo $VU_DEPT_FIELD_DESC;
  echo '</td>
    </tr>
    <tr>
      <td nowrap class="TableContent" width="80"> 起始时间:</td>
      <td class="TableData">';
  echo $VU_START;
  echo '</td>
      <td nowrap class="TableContent" width="80"> 结束时间:</td>
      <td class="TableData">
        <input type="text" name="VU_END" size="20" maxlength="19" class="BigInput" value="';
  echo $VU_END;
  echo '">
        <img src="/images/menu/calendar.gif" border="0" align="absMiddle" style="cursor:hand" onclick="td_calendar(\'form1.VU_END\');">
        <img src="/images/menu/clock.gif" border="0" align="absMiddle" style="cursor:hand" onclick="td_clock(\'form1.VU_END\');">
      </td>
    </tr>
    <tr>
      <td nowrap class="TableContent" width="80"> 目 的 地:</td>
      <td class="TableData">
        <i';
  echo 'nput type="text" name="VU_DESTINATION" size="20" maxlength="100" class="BigInput" value="';
  echo $VU_DESTINATION;
  echo '">
      </td>
      <td nowrap class="TableContent" width="80"> 里  程:</td>
      <td class="TableData">
        <input type="text" name="VU_MILEAGE" size="10" maxlength="14" class="BigInput" value="';
  echo $VU_MILEAGE;
  echo '"> (公里)
      </td>
    </tr>
    <tr>
      <td nowrap class="TableContent" width="80"> 事  由:</td>
      <td class="TableData" colspan="3">';
  echo $VU_REASON;
  echo '      </td>
    </tr>
    <tr>
      <td nowrap class="TableContent" width="80"> 备  注:</td>
      <td class="TableData" colspan="3">
        <textarea name="VU_REMARK" class="BigInput" cols="74" rows="5">';
  echo $VU_REMARK;
  echo '</textarea>
      </td>
    </tr>
    <tr class="TableControl">
      <td nowrap colspan="4" align="center">
        <input type="hidden" value="';
  echo $VU_ID;
  echo '" name="VU_ID"> 
        <input type="hidden" value="';
  echo $VU_START;
  echo '" name="VU_START">              	
        <input type="button" value="保存" class="BigButton" onclick="CheckForm();">&nbsp;&nbsp;
        <input type="button" value="关闭" class="BigButton" onClick="window.close();" title="关闭窗口">
      </td>
    </tr>
    </table>
</form>
</body>
</html>';
?>

⌨️ 快捷键说明

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