📄 new.php

📁 极限网络智能办公系统 Office Automation V3.0官方100％源代码.
💻 PHP
字号:
<?
include_once("inc/auth.php");
?>

<html>
<head>
<title>会议申请</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<script Language="JavaScript">

function CheckForm()
{
 if(document.form1.M_NAME.value=="")
 {  alert("请指定会议名称！");
    return (false);
 }
 if(document.form1.M_START.value==document.form1.M_END.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.value=="")
 {  alert("请指定会议室管理员！");
    return (false);
 }

 form1.submit();
}

function clear_user()
{
  document.form1.COPY_TO_NAME.value="";
  document.form1.COPY_TO_ID.value="";
}

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:350px;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;dialogHeight:215px;dialogTop:"+mytop+"px;dialogLeft:"+myleft+"px");
}

function td_clock(fieldname,pare)
{
  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>

<body class="bodycolor" topmargin="5">

<?
$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($CUR_TIME>=$M_START3)
    {
      exequery($connection,"UPDATE MEETING SET M_STATUS= '2' WHERE M_ID=$M_ID3");
    }
}

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_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"];
    $SMS_REMIND=$ROW["SMS_REMIND"];
    $SMS2_REMIND=$ROW["SMS2_REMIND"];

    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" || $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(",");
}
?>

<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
  <tr>
    <td class="Big"><img src="/images/notify_new.gif" HEIGHT="20"><span 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="TableContent" width="80">名    称：</td>
    <td class="TableData" colspan="3">
      <input type="text" name="M_NAME" size="40" maxlength="100" class="BigInput" value="<?=$M_NAME?>">
    </td>
  </tr>
  <tr>
    <td nowrap class="TableContent" width="80"> 主    题：</td>
    <td class="TableData" colspan="3">
      <input type="text" name="M_TOPIC" size="40" maxlength="100" class="BigInput" value="<?=$M_TOPIC?>">
    </td>
  </tr>
  <tr>
    <td nowrap class="TableContent" width="80"> 描    述：</td>
    <td class="TableData" colspan="3">
      <textarea name="M_DESC" class="BigInput" cols="50" rows="3"><?=$M_DESC?></textarea>
    </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"><?=$M_ATTENDEE_OUT?></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="<?=$M_ATTENDEE?>">
      <textarea name="COPY_TO_NAME" class="BigStatic" cols="50" rows="3" class="BigStatic" wrap="yes" readonly><?=$USER_NAME2?></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">
    	<select 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"];
?>
      <option value="<?=$MR_ID?>" <? if($M_ROOM==$MR_ID) echo "selected";?>><?=$MR_NAME?></option>
<?
}
?>
      </select>
   </td>

  <td nowrap class="TableContent" width="85"> 会议室管理员：</td>
    <td class="TableData">
    	<select 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"];
?>
        <option value="<?=$USER_ID?>" <? if($M_MANAGER==$USER_ID) echo "selected";?>><?=$USER_NAME?></option>
<?
 }
}
?>
      </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="<?=$M_START?>">
      <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" size="18" maxlength="19" class="BigInput" value="<?=$M_END?>">
      <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">
    	 <input type="checkbox" name="SMS_REMIND1" id="SMS_REMIND1" checked><label for="SMS_REMIND1">使用内部短信</label>
<?
$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)) //检查该模块是否允许手机提醒
{
?>
       <input type="checkbox" name="SMS2_REMIND1" id="SMS2_REMIND1"><label for="SMS2_REMIND1">使用手机短信</label>
<?
}
?>
  </td>
  </tr>
  <tr>
    <td nowrap class="TableContent" width="80">通知出席<br>人员：</td>
    <td class="TableData" colspan="3">
    	 <input type="checkbox" name="SMS_REMIND" id="SMS_REMIND" <?if($SMS_REMIND=="1") echo "checked";?>><label for="SMS_REMIND">使用内部短信</label>
<?
$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)) //检查该模块是否允许手机提醒
{
?>
       <input type="checkbox" name="SMS2_REMIND" id="SMS2_REMIND" <?if($SMS2_REMIND=="1") echo "checked";?>><label for="SMS2_REMIND">使用手机短信</label><br>说明：会议管理员批准时会按照您指定的方式通知出席人员
<?
}
?>
  </td>
  </tr>
  <tr class="TableControl">
    <td nowrap colspan="4" align="center">
    	<input type="hidden" value="<?=$M_ID?>" name="M_ID">
    	<input type="hidden" value="<?=$CUR_TIME?>" name="M_REQUEST_TIME">
    	<input type="hidden" value="<?=$LOGIN_USER_ID?>" name="M_PROPOSER">
      <input type="button" value="确定" class="BigButton" onclick="CheckForm();">&nbsp;&nbsp;&nbsp;
<?
if($FLAG==1)
{
?>
      <input type="button" class="BigButton" value="返回" onclick="history.back();">
<?
}
?>
    </td>
  </tr>
  </table>
</form>
</body>
</html>
💿 文件大小 24085 K
👤 上传用户 happy_christina
📂 所属分类 OA系统
🏷️ 相关标签

#Automation #Office #3.0 #100
⌨️ 快捷键说明

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