new.php

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

PHP
436 行
字号 
<?
  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 CheckForm()
{
  if(document.form1.M_NAME.value=="")
  {  alert("请指定会议名称！");
     return (false);
  }
  if(document.form1.M_START.value=="")
  {  alert("起始时间不能为空！");
     return (false);
  }
  if(document.form1.M_TOPIC.value=="")
  {  alert("请指定会议主题！");
     return (false);
  }
  if(document.form1.M_MANAGER.val';
  echo 'ue=="")
  {  alert("请指定会议室管理员！");
     return (false);
  }
  if(document.form1.M_START.value==document.form1.M_END.value)
  {  alert("开始时间与结束时间不能相等！");
     return (false);
  }
  if (document.form1.ATTACHMENT.value!="")
  {
    var file_temp=document.form1.ATTACHMENT.value,file_name;
    var Pos;
    Pos=file_temp.lastIndexOf("\\\\");
    file_name=file_te';
  echo 'mp.substring(Pos+1,file_temp.length);
    document.form1.ATTACHMENT_NAME.value=file_name;
  }
  document.form1.OP.value="1";
  return (true);
}
function sendForm()
{
  document.form1.M_DESC.value=EDIT_HTML.get_docHtml();
  if(CheckForm())
     document.form1.submit();
}
function clear_user()
{
  document.form1.COPY_TO_NAME.value="";
  document.form1.COPY_TO_ID.value="";
}
';
  echo '
function LoadWindow()
{
  URL="/module/user_select?ID=2";
  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:0;status:0;help:0;resizable:1;dialogWidth:400px;dialogHeight:350px;dialogTop:"+loc_y+"px;dialogLeft:"+loc_x+"px");
}
function td_calendar(fieldnam';
  echo 'e)
{
  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");
}
function td_clock(fieldname,pare)
{
  myleft=';
  echo '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");
}
function Load_Do()
{
  EDIT_HTML.insertHtml(document.form1.M_DES';
  echo 'C.value);
}
function upload_attach()
{
  document.form1.M_DESC.value=EDIT_HTML.get_docHtml();
  if(CheckForm())   
   {
     document.form1.OP.value="0";
     document.form1.submit();
   }   
}
function delete_attach(ATTACHMENT_ID,ATTACHMENT_NAME)
{
  msg="确定要删除文件 \'"+ ATTACHMENT_NAME +"\' 吗?";
  if(window.confirm(msg))
  {
    URL="delete_attach.php?M_ID=';
  echo $M_ID;
  echo '&ATTACHMENT_ID="+ATTACHMENT_ID+"&ATTACHMENT_NAME="+ATTACHMENT_NAME;
    window.location=URL;
  }
}
</script>
</head>
<body class="bodycolor" topmargin="5" onload="Load_Do();">
';
  $CUR_TIME = date ('Y-m-d H:i:s', time ());
  $query = 'SELECT * from MEETING  where M_STATUS=1';
  $cursor = exequery ($connection, $query);
  while ($ROW = mysql_fetch_array ($cursor))
  {
    $M_ID3 = $ROW['M_ID'];
    $M_START3 = $ROW['M_START'];
    if (($M_START3 <= $CUR_TIME))
    {
      exequery ($connection, ((''.'UPDATE MEETING SET M_STATUS= \'2\' WHERE M_ID=').$M_ID3));
      continue;
    }
  }
  $query = 'SELECT * from MEETING  where M_STATUS=2';
  $cursor = exequery ($connection, $query);
  while ($ROW = mysql_fetch_array ($cursor))
  {
    $M_ID3 = $ROW['M_ID'];
    $M_END3 = $ROW['M_END'];
    if (($M_END3 <= $CUR_TIME))
    {
      exequery ($connection, ((''.'UPDATE MEETING SET M_STATUS= \'4\' WHERE M_ID=').$M_ID3));
      continue;
    }
  }
  if (($M_ID != ''))
  {
    $query = ((''.'SELECT * from MEETING  where M_ID=').$M_ID);
    $cursor = exequery ($connection, $query);
    if ($ROW = mysql_fetch_array ($cursor))
    {
      $M_NAME = $ROW['M_NAME'];
      $M_TOPIC = $ROW['M_TOPIC'];
      $M_DESC = $ROW['M_DESC'];
      $M_DESC = htmlspecialchars ($M_DESC);
      $M_PROPOSER = $ROW['M_PROPOSER'];
      $M_REQUEST_TIME = $ROW['M_REQUEST_TIME'];
      $M_ATTENDEE = $ROW['M_ATTENDEE'];
      $M_START = $ROW['M_START'];
      $M_END = $ROW['M_END'];
      $M_ROOM = $ROW['M_ROOM'];
      $M_MANAGER = $ROW['M_MANAGER'];
      $M_ATTENDEE_OUT = $ROW['M_ATTENDEE_OUT'];
      $ATTACHMENT_ID = $ROW['ATTACHMENT_ID'];
      $ATTACHMENT_NAME = $ROW['ATTACHMENT_NAME'];
      if (($M_START == '0000-00-00 00:00:00'))
      {
        $M_START = '';
      }
      if (($M_END == '0000-00-00 00:00:00'))
      {
        $M_END = '';
      }
    }
  }
  else
  {
    $M_START = $CUR_TIME;
    $M_END = $CUR_TIME;
  }
  if ((($M_REQUEST_TIME == '0000-00-00 00:00:00') OR ($M_REQUEST_TIME == '')))
  {
    $M_REQUEST_TIME = $CUR_TIME;
  }
  if (($M_PROPOSER == ''))
  {
    $M_PROPOSER = $LOGIN_USER_ID;
  }
  $TOK = strtok ($M_ATTENDEE, ',');
  while (($TOK != ''))
  {
    $query2 = (((''.'SELECT * from USER where USER_ID=\'').$TOK).'\'');
    $cursor2 = exequery ($connection, $query2);
    if ($ROW = mysql_fetch_array ($cursor2))
    {
      ($USER_NAME2 .= ($ROW['USER_NAME'].','));
    }
    $TOK = strtok (',');
  }
  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"> 会议申请(<font size="2">申请之前,请查询“待批”,“已批准”,“进行中”三种状态的会议,以避免时间冲突</font>)</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="TableCo';
  echo 'ntent" width="80">名    称：</td>
    <td class="TableData" colspan="3">
      <input type="text" name="M_NAME" size="45" maxlength="100" class="BigInput" value="';
  echo $M_NAME;
  echo '">
    </td>
  </tr>
  <tr>
    <td nowrap class="TableContent" width="80"> 主    题：</td>
    <td class="TableData" colspan="3">
      <input type="text" name="M_TOPIC" size="45" maxlength="100" class="BigInput" value="';
  echo $M_TOPIC;
  echo '">
    </td>
  </tr>
  <tr>
    <td nowrap class="TableContent" width="70"> 出席人员：<br>(外部)</td>
    <td class="TableData" colspan="3">
      <textarea name="M_ATTENDEE_OUT" class="BigInput" cols="50" rows="3">';
  echo $M_ATTENDEE_OUT;
  echo '</textarea>
    </td>
  </tr>
  <tr>
    <td nowrap class="TableContent" width="70"> 出席人员：<br>(内部)</td>
    <td class="TableData" colspan="3">
    	<input type="hidden" name="COPY_TO_ID" value="';
  echo $M_ATTENDEE;
  echo '">
      <textarea name="COPY_TO_NAME" class="BigStatic" cols="50" rows="3" class="BigStatic" wrap="yes" readonly>';
  echo $USER_NAME2;
  echo '</textarea>
      &nbsp;<input type="button" value="添 加" class="SmallButton" onClick="LoadWindow()" title="添加出席人员" name="button">
      &nbsp;<input type="button" value="清 空" class="SmallButton" onClick="clear_user()" title="清空出席人员" name="button">
    </td>
  </tr>
  <tr>
    <td nowrap class="TableContent" width="70">会  议  室：</td>
    <td class="TableData">
    	';
  echo '<s';
  echo 'elect name="M_ROOM" class="BigSelect">
';
  $query = 'SELECT * from MEETING_ROOM';
  $cursor = exequery ($connection, $query);
  while ($ROW = mysql_fetch_array ($cursor))
  {
    $MR_ID = $ROW['MR_ID'];
    $MR_NAME = $ROW['MR_NAME'];
    echo '      <option value="';
    echo $MR_ID;
    echo '" ';
    if (($M_ROOM == $MR_ID))
    {
      echo 'selected';
    }
    echo '>';
    echo $MR_NAME;
    echo '</option>
';
  }
  echo '      </select>
      &nbsp;<a href="javascript:;" onClick="window.open(\'room_detail.php\',\'\',\'height=400,width=620,status=1,toolbar=no,menubar=no,location=no,scrollbars=yes,top=200,left=280,resizable=yes\');">详情</a>
      &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=ye';
  echo 's\');">预约情况</a>
   </td>
  <td nowrap class="TableContent" width="85"> 会议室管理员：</td>
    <td class="TableData">
    	';
  echo '<s';
  echo 'elect name="M_MANAGER" class="BigSelect">
';
  $query = 'SELECT * from SYS_PARA where PARA_NAME=\'MEETING_OPERATOR\'';
  $cursor1 = exequery ($connection, $query);
  if ($ROW1 = mysql_fetch_array ($cursor1))
  {
    $PARA_VALUE = $ROW1['PARA_VALUE'];
    $query = (((''.'SELECT * from USER where USER_ID!=\'\' and find_in_set(USER_ID,\'').$PARA_VALUE).'\') 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'];
      echo '        <option value="';
      echo $USER_ID;
      echo '" ';
      if (($M_MANAGER == $USER_ID))
      {
        echo 'selected';
      }
      echo '>';
      echo $USER_NAME;
      echo '</option>
';
    }
  }
  echo '      </select>
  </td>
  </tr>
   <tr>
    <td nowrap class="TableContent" width="70"> 开始时间：</td>
    <td class="TableData">
      <input type="text" name="M_START" size="18" maxlength="19" class="BigInput" value="';
  echo $M_START;
  echo '">
      <img src="/images/menu/calendar.gif" border="0" align="absMiddle" style="cursor:hand" onclick="td_calendar(\'form1.M_START\');">
      <img src="/images/menu/clock.gif" border="0" align="absMiddle" style="cursor:hand" onclick="td_clock(\'form1.M_START\');">
    </td>
    <td nowrap class="TableContent" width="70"> 结束时间：</td>
    <td class="TableData">
      <input type="text" name="M_END"';
  echo ' size="18" maxlength="19" class="BigInput" value="';
  echo $M_END;
  echo '">
      <img src="/images/menu/calendar.gif" border="0" align="absMiddle" style="cursor:hand" onclick="td_calendar(\'form1.M_END\');">
      <img src="/images/menu/clock.gif" border="0" align="absMiddle" style="cursor:hand" onclick="td_clock(\'form1.M_END\');">
    </td>
  </tr>
  <tr>
    <td nowrap class="TableContent" width="80"> 提醒会议<br>室管理员：</td>
    <td class="TableData" colspan="3">
  ';
  echo '  	 <input type="checkbox" name="SMS_REMIND1" id="SMS_REMIND1"';
  if (find_id ($SMS_REMIND, '8'))
  {
    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, 8))
  {
    echo '       <input type="checkbox" name="SMS2_REMIND1" id="SMS2_REMIND1"';
    if (find_id ($SMS2_REMIND, '8'))
    {
      echo ' checked';
    }
    echo '><label for="SMS2_REMIND1">使用手机短信提醒</label>
';
  }
  echo '  </td>
  </tr>
  <tr>
    <td nowrap class="TableContent" width="80">通知出席<br>人员：</td>
    <td class="TableData" colspan="3">
';
  echo sms_remind (8);
  echo '  </td>
  </tr>
  <tr>
    <td nowrap class="TableContent">附件文档：</td>
    <td nowrap class="TableData" colspan="3">
';
  if (($ATTACHMENT_ID == ''))
  {
    echo '无附件';
  }
  else
  {
    echo attach_link ($ATTACHMENT_ID, $ATTACHMENT_NAME, 1, 1, 1, 1, 1, 1, 0, 1);
  }
  echo '    </td>
  </tr>
  <tr>
    <td nowrap class="TableContent">';
  echo '<s';
  echo 'pan id="ATTACH_LABEL">附件上传：</span></td>
    <td class="TableData" colspan="3">
      <input type="file" name="ATTACHMENT" size="30" class="BigInput" title="选择附件文件">
      <input type="button" class="BigButton" value="上传文件" onclick="upload_attach();">
      <input type="hidden" name="ATTACHMENT_ID_OLD" value="';
  echo $ATTACHMENT_ID;
  echo '">
      <input type="hidden" name="ATTACHMENT_NAME_OLD" value="';
  echo $ATTACHMENT_NAME;
  echo '">
    </td>
  </tr>
  <tr>
    <td nowrap class="TableContent" colspan="4">';
  echo '<s';
  echo 'pan id="ATTACH_LABEL">会议描述：</span></td>
  </tr>
  <tr id="EDITOR">
    <td class="TableData" colspan="4">
      <input type="hidden" name="M_DESC" value="';
  echo $M_DESC;
  echo '">
      <iframe name="EDIT_HTML" style="BACKGROUND-COLOR: buttonface" src="/module/rte" width="100%" height="370" type="text/x-scriptlet" VIEWASTEXT></iframe>
    </td>
  </tr>
  <tr class="TableControl">
    <td nowrap colspan="4" align="center">
      <input type="hidden" name="OP" value="">   	
      <input type="hidden" name="ATTACHMENT_NAME" value="">
    	<input type="hidden" value="';
  echo $M_ID;
  echo '" name="M_ID">
      <input type="hidden" value="';
  echo $CUR_PAGE;
  echo '" name="CUR_PAGE">
    	<input type="hidden" value="';
  echo $CUR_TIME;
  echo '" name="M_REQUEST_TIME">
    	<input type="hidden" value="';
  echo $LOGIN_USER_ID;
  echo '" name="M_PROPOSER">
      <input type="button" value="确定" class="BigButton" onclick="sendForm();">&nbsp;&nbsp;&nbsp;
';
  if (($FLAG == 1))
  {
    echo '      <input type="button" class="BigButton" value="返回" onclick="history.back();">
';
  }
  echo '    </td>
  </tr>
  </table>
</form>
</body>
</html>';
?>

new.php - 源码说明

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

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

⌨️ 快捷键说明

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