new.php

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

PHP
408 行
字号 
<?
  include_once 'inc/auth.php';
  include_once 'inc/utility_all.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'];
  }
  $SMS_REMIND = substr ($PARA_VALUE, 0, strpos ($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">
function IsNumber(str)
{
   return str.match(/^[0-9]*$/)!=null;
}
function CheckForm()
{
   if(document.form1.V_ID.value=="")
   { alert("请指车辆！");
     return (false);
   }
   if(document.form1.VU_START.value=="")
   { alert("起始时间不能为空！");
     return (false);
   }
   if (document.form1.VU_MILEAGE.value!=""&&!IsNumber(document.form1.VU';
  echo '_MILEAGE.value))
   { alert("里程应为数字！");
     return (false);
   }
   if(document.form1.VU_OPERATOR.value=="")
   { alert("请指定调度人员！");
     return (false);
   }
   form1.submit();
}
function showDetail()
{
   var tem1 =form1.V_ID.value.indexOf("*");
   var tem2 =form1.V_ID.value.substr(0,tem1);
   var tem3 =form1.V_ID.value.substr(tem1+1); 
   form1.VU_DRIVER.v';
  echo 'alue=tem3;
   document.all("vehicle_detail").src="show_detail.php?V_ID="+tem2;
}
function LoadWindow(id,desc)
{
  URL="/module/dept_select_single?ID="+id+"&DESC="+desc;
  loc_x=document.body.scrollLeft+event.clientX-event.offsetX-100;
  loc_y=document.body.scrollTop+event.clientY-event.offsetY+170;
  window.showModalDialog(URL,self,"edge:raised;scroll:1;status:0;help:0;resizable:1;dialog';
  echo 'Width:200px;dialogHeight:350px;dialogTop:"+loc_y+"px;dialogLeft:"+loc_x+"px");
}
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;dialogH';
  echo 'eight:215px;dialogTop:"+mytop+"px;dialogLeft:"+myleft+"px");
}
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:';
  echo '"+mytop+"px;dialogLeft:"+myleft+"px");
}
function LoadWindow2()
{
  URL="/module/user_select_single";
  loc_x=document.body.scrollLeft+event.clientX-event.offsetX-100;
  loc_y=document.body.scrollTop+event.clientY-event.offsetY+200;
  window.showModalDialog(URL,self,"edge:raised;scroll:0;status:0;help:0;resizable:1;dialogWidth:350px;dialogHeight:350px;dialogTop:"+loc_y+"px;dialogLeft:"+lo';
  echo 'c_x+"px");
}
</script>
</head>
<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_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" HEIGHT="20">';
  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="add.php" method="post" name="form1">
    <tr>
      <td nowrap class="TableContent" width="80"> 车 牌 号：</td>
      <td class="TableData" width="230">
        ';
  echo '<s';
  echo 'elect name="V_ID" class="BigSelect" onchange="showDetail();">
';
  $query = 'SELECT * from VEHICLE order by V_NUM';
  $cursor1 = exequery ($connection, $query);
  while ($ROW1 = mysql_fetch_array ($cursor1))
  {
    $V_ID1 = $ROW1['V_ID'];
    $V_NUM = $ROW1['V_NUM'];
    $V_DRIVER = $ROW1['V_DRIVER'];
    echo '          <option value="';
    echo $V_ID1;
    echo '*';
    echo $V_DRIVER;
    echo '" ';
    if (($V_ID == $V_ID1))
    {
      echo 'selected';
    }
    echo '>';
    echo $V_NUM;
    echo '</option>
';
  }
  echo '        </select>
      &nbsp;<a href="javascript:;" onClick="window.open(\'prearrange.php\',\'\',\'height=500,width=820,status=1,toolbar=no,menubar=no,location=no,scrollbars=yes,top=150,left=100,resizable=yes\');">预约情况</a>        
      </td>
      <td nowrap class="TableContent" width="80"> 司　　机：</td>
      <td class="TableData" width="230"><input type="text" name="VU_DRIVER" size="11" maxlength=';
  echo '"100" class="BigInput" value="';
  echo $VU_DRIVER;
  echo '">
      </td>
    </tr>
    <tr>
      <td nowrap class="TableContent" width="80"> 用 车 人：</td>
      <td class="TableData">
        <input type="text" name="VU_USER" size="20" maxlength="100" class="BigInput" value="';
  echo $VU_USER;
  echo '">
      </td>
      <td nowrap class="TableContent" width="80"> 用车部门：</td>
      <td class="TableData">
        <input type="hidden" name="VU_DEPT" value="';
  echo $VU_DEPT;
  echo '">
        <input type="text" name="VU_DEPT_FIELD_DESC" value="';
  echo $VU_DEPT_FIELD_DESC;
  echo '" class=BigStatic size=20 maxlength=100 readonly>
        <input type=button value=\'选 择\' class=SmallButton style=height:22px onClick=LoadWindow(\'VU_DEPT\',\'VU_DEPT_FIELD_DESC\') title=选择 name=button>
      </td>
    </tr>
    <tr>
      <td nowrap class="TableContent" width="80"> 起始时间：</td>
      <td class="TableData">
        <input type="text" name="VU_START" size="20" maxlength="19" class';
  echo '="BigInput" value="';
  echo $VU_START;
  echo '">
        <img src="/images/menu/calendar.gif" border="0" align="absMiddle" style="cursor:hand" onclick="td_calendar(\'form1.VU_START\');">
        <img src="/images/menu/clock.gif" border="0" align="absMiddle" style="cursor:hand" onclick="td_clock(\'form1.VU_START\');">
      </td>
      <td nowrap class="TableContent" width="80"> 结束时间：</td>
      <td class="TableData">
        <input type="text';
  echo '" 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">
        <input type="hidden" name="TO_ID" value="';
  echo $DEPT_MANAGER;
  echo '"> 	
        <input type="text" name="TO_NAME" size="13" class="BigStatic" value="';
  echo $DEPT_MANAGER_NAME;
  echo '" readonly>&nbsp;
        <input type="button" value="指 定" class="SmallButton" onClick="LoadWindow2()" title="为空时，直接由调度员审批; 不为空时，先交给部门审批人审批，再由调度员审批" name="button"><br>
      </td>
      <td nowrap class="TableContent" width="80"> 调 度 员：</td>
      <td class="TableData">
        ';
  echo '<s';
  echo 'elect name="VU_OPERATOR" class="BigSelect">
';
  $ONLINE_LIMIT = ($ONLINE_REF_SEC + 5);
  $query = ((((''.'SELECT * from USER where UNIX_TIMESTAMP(\'').$CUR_TIME).'\')-UNIX_TIMESTAMP(LAST_VISIT_TIME)<').$ONLINE_LIMIT);
  $cursor = exequery ($connection, $query);
  while ($ROW = mysql_fetch_array ($cursor))
  {
    ($ONLINE_USER_ID .= ($ROW['USER_ID'].','));
  }
  $query = 'SELECT * from VEHICLE_OPERATOR where OPERATOR_ID=1';
  $cursor1 = exequery ($connection, $query);
  if ($ROW1 = mysql_fetch_array ($cursor1))
  {
    $OPERATOR_NAME = $ROW1['OPERATOR_NAME'];
    $query = (((''.'SELECT * from USER where USER_ID!=\'\' and find_in_set(USER_ID,\'').$OPERATOR_NAME).'\') order by USER_NO,USER_NAME');
    $cursor = exequery ($connection, $query);
    while ($ROW = mysql_fetch_array ($cursor))
    {
      $USER_ID = $ROW['USER_ID'];
      $USER_NAME = $ROW['USER_NAME'];
      if (find_id ($ONLINE_USER_ID, $USER_ID))
      {
        ($ONLINE_USER_NAME .= ($USER_NAME.'，'));
      }
      echo '          <option value="';
      echo $USER_ID;
      echo '" ';
      if (($VU_OPERATOR == $USER_ID))
      {
        echo 'selected';
      }
      echo '>';
      echo $USER_NAME;
      echo '</option>
';
    }
  }
  echo '        </select>  (注：负责审批)
      </td>
    </tr>
    <tr>
      <td nowrap class="TableContent" width="80"> 在线调度<br>人员：</td>
      <td class="TableData" colspan="3">
';
  echo substr ($ONLINE_USER_NAME, 0, -2);
  echo '     </td>
    </tr>   
    <tr>
      <td nowrap class="TableContent" width="80"> 事　　由：</td>
      <td class="TableData" colspan="3">
        <textarea name="VU_REASON" class="BigInput" cols="74" rows="2">';
  echo $VU_REASON;
  echo '</textarea>
      </td>
    </tr>
    <tr>
      <td nowrap class="TableContent" width="80"> 备　　注：</td>
      <td class="TableData" colspan="3">
        <textarea name="VU_REMARK" class="BigInput" cols="74" rows="2">';
  echo $VU_REMARK;
  echo '</textarea>
      </td>
    </tr>
    <tr>
      <td nowrap class="TableContent" width="80"> 提醒调度员：</td>
      <td class="TableData" colspan="3">
    	  <input type="checkbox" name="SMS_REMIND1" id="SMS_REMIND1"';
  if (find_id ($SMS_REMIND, '9'))
  {
    echo ' checked';
  }
  echo '><label for="SMS_REMIND1">使用内部短信提醒</label>&nbsp;
';
  $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, 9))
  {
    echo '       <input type="checkbox" name="SMS2_REMIND1" id="SMS2_REMIND1"';
    if (find_id ($SMS2_REMIND, '9'))
    {
      echo ' checked';
    }
    echo '><label for="SMS2_REMIND1">使用手机短信提醒</label>
';
  }
  echo '    </td>
  </tr>
  <tr>
    <td nowrap class="TableContent" width="80">通知申请人：</td>
    <td class="TableData" colspan="3">
';
  echo sms_remind (9);
  echo '  </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" name="VU_PROPOSER" value="';
  echo $LOGIN_USER_ID;
  echo '">
        <input type="hidden" name="VU_REQUEST_DATE" value="';
  echo $VU_REQUEST_DATE;
  echo '">
        <input type="hidden" name="VU_PROPOSER_NAME" value="';
  echo $VU_PROPOSER_NAME;
  echo '">
        <input type="button" value="保存" class="BigButton" onclick="CheckForm();">&nbsp;&nbsp;
        <input type="reset" value="重填" class="BigButton">&nbsp;&nbsp;
';
  if (($VU_ID != ''))
  {
    echo '        <input type="button" value="返回" class="BigButton" onclick="location=\'query.php?VU_STATUS=';
    echo $VU_STATUS;
    echo '\'">
';
  }
  echo '      </td>
    </tr>
    </table>
</form>
<iframe id="vehicle_detail" width="626" height="200" src="show_detail.php" frameBorder="0" frameSpacing="0" scrolling="yes" align="center"></iframe>
';
  echo '<s';
  echo 'cript>
   var tem1 =form1.V_ID.value.indexOf("*");
   var tem2 =form1.V_ID.value.substr(0,tem1);	
   document.all("vehicle_detail").src="show_detail.php?V_ID="+tem2;
</script>
</body>
</html>';
?>

new.php - 源码说明

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

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

⌨️ 快捷键说明

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