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

📄 index.php

📁 通达OA官方提供的30源代码,感觉很实在
💻 PHP
字号:
🔍 
<?
include_once("inc/auth.php");
include_once("inc/utility_all.php");
include_once("inc/utility_file.php");
include_once("inc/editor.php");
?>

<html>
<head>
<title>新建工作计划</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312"><script src="/inc/js/module.js"></script>
<script src="/inc/js/utility.js"></script>
<script src="/inc/js/attach.js"></script>
<script Language="JavaScript">
var upload_limit=<?=$UPLOAD_LIMIT?>,limit_type="<?=strtolower($UPLOAD_LIMIT_TYPE)?>";
function CheckForm()
{
   if(document.form1.TO_ID.value==""&& document.form1.TO_ID3.value==""&& document.form1.COPY_TO_ID.value=="")
   { alert("发布范围(部门或人员)与参与人不能同时为空！");
     return (false);
   }

   if(document.form1.NAME.value=="")
   { alert("工作计划的标题不能为空！");
     return (false);
   }

   document.form1.OP.value="0";

   return true;
}

function InsertImage(src)
{
   TDeditorAPI.GetInstance('CONTENT').InsertHtml('<img src="'+src+'">');
}
function sendForm(publish)
{
 document.form1.PUBLISH.value=publish;
 if(CheckForm())
 {
    document.form1.OP.value="0";
    document.form1.submit();
  }
}

function upload_attach()
{
  if(CheckForm())
  {
     document.form1.OP.value="1";
     document.form1.submit();
  }
}
function delete_attach(ATTACHMENT_ID,ATTACHMENT_NAME)
{
  msg="确定要删除文件 '"+ ATTACHMENT_NAME +"' 吗?";
  if(window.confirm(msg))
  {
    URL="delete_attach.php?PLAN_ID=<?=$PLAN_ID?>&ATTACHMENT_ID="+ATTACHMENT_ID+"&ATTACHMENT_NAME="+URLSpecialChars(ATTACHMENT_NAME);
    window.location=URL;
  }
}

</script>
</head>
<?
if($PLAN_ID!="")
{
 $CUR_DATE=date("Y-m-d",time());

 $query = "SELECT * from WORK_PLAN where PLAN_ID=$PLAN_ID";
 $cursor= exequery($connection,$query);
 if($ROW=mysql_fetch_array($cursor))
 {
    $PLAN_ID=$ROW["PLAN_ID"];
    $NAME=$ROW["NAME"];
    $CONTENT=$ROW["CONTENT"];
    $BEGIN_DATE=$ROW["BEGIN_DATE"];
    $END_DATE=$ROW["END_DATE"];
    $TYPE=$ROW["TYPE"];
    $TO_ID=$ROW["TO_ID"];
    $MANAGER=$ROW["MANAGER"];
    $PARTICIPATOR=$ROW["PARTICIPATOR"];
    $ATTACHMENT_ID=$ROW["ATTACHMENT_ID"];
    $ATTACHMENT_NAME=$ROW["ATTACHMENT_NAME"];
    $ATTACHMENT_COMMENT=$ROW["ATTACHMENT_COMMENT"];
    $REMARK=$ROW["REMARK"];
    $TO_PERSON_ID=$ROW["TO_PERSON_ID"];
    $OPINION_LEADER=$ROW["OPINION_LEADER"];

 }

 if($BEGIN_DATE=="0000-00-00")
    $BEGIN_DATE="";
 if($END_DATE=="0000-00-00")
    $END_DATE="";

 $TO_NAME="";
 $TOK=strtok($TO_ID,",");
 while($TOK!="")
 {
   $query1="select DEPT_NAME from DEPARTMENT where DEPT_ID='$TOK'";
   $cursor1= exequery($connection,$query1);
   if($ROW1=mysql_fetch_array($cursor1))
      $TO_NAME.=$ROW1["DEPT_NAME"].",";

   $TOK=strtok(",");
 }
 if($TO_ID=="ALL_DEPT")
    $TO_NAME="全体部门";

 $COPY_TO_NAME="";
 $TOK=strtok($PARTICIPATOR,",");
 while($TOK!="")
 {
   $query1="select USER_NAME from USER where USER_ID='$TOK'";
   $cursor1= exequery($connection,$query1);
   if($ROW1=mysql_fetch_array($cursor1))
      $COPY_TO_NAME.=$ROW1["USER_NAME"].",";

   $TOK=strtok(",");
 }

 $TO_PERSON_NAME="";
 $TOK=strtok($TO_PERSON_ID,",");
 while($TOK!="")
 {
   $query1="select USER_NAME from USER where USER_ID='$TOK'";
   $cursor1= exequery($connection,$query1);
   if($ROW1=mysql_fetch_array($cursor1))
      $TO_PERSON_NAME.=$ROW1["USER_NAME"].",";

   $TOK=strtok(",");
 }

 $SECRET_TO_NAME="";
 $TOK=strtok($MANAGER,",");
 while($TOK!="")
 {
   $query1="select USER_NAME from USER where USER_ID='$TOK'";
   $cursor1= exequery($connection,$query1);
   if($ROW1=mysql_fetch_array($cursor1))
      $SECRET_TO_NAME.=$ROW1["USER_NAME"].",";

   $TOK=strtok(",");
 }

 $OPINION_LEADER_NAME="";
 $TOK=strtok($OPINION_LEADER,",");
 while($TOK!="")
 {
   $query1="select USER_NAME from USER where USER_ID='$TOK'";
   $cursor1= exequery($connection,$query1);
   if($ROW1=mysql_fetch_array($cursor1))
      $OPINION_LEADER_NAME.=$ROW1["USER_NAME"].",";

   $TOK=strtok(",");
 }
}
?>
<body class="bodycolor" topmargin="5">
<?
if($PLAN_ID=="")
   $TITLE="新建工作计划";
else
   $TITLE="编辑工作计划";
?>
<table border="0" width="90%" cellspacing="0" cellpadding="3" class="small">
  <tr>
    <td class="Big"><img src="/images/notify_new.gif" align="absmiddle" width="22" height="20"><span class="big3"> <?=$TITLE?></span>
    </td>
  </tr>
</table>

<br>

<form enctype="multipart/form-data" action="submit.php"  method="post" name="form1">
<table class="TableBlock" width="90%" align="center">
    <tr>
      <td nowrap class="TableContent"> 计划名称：</td>
      <td class="TableData">
        <input type="text" name="NAME" size="36" maxlength="200" class="BigInput" value="<?=$NAME?>">
      </td>
    </tr>
    <tr>
      <td nowrap class="TableContent">发布范围(部门)：</td>
      <td class="TableData">
        <input type="hidden" name="TO_ID" value="<?=$TO_ID?>">
        <textarea cols=45 name="TO_NAME" rows=2 class="BigStatic" wrap="yes" readonly><?=$TO_NAME?></textarea>
        <a href="javascript:;" class="orgAdd" onClick="SelectDept()">添加</a>
       <a href="javascript:;" class="orgClear" onClick="ClearUser()">清空</a>
      </td>
    </tr>
    <tr>
      <td nowrap class="TableContent">发布范围(人员)：</td>
      <td class="TableData">
        <input type="hidden" name="TO_ID3" value="<?=$TO_PERSON_ID?>">
        <textarea cols=45 name="TO_NAME3" rows="2" class="BigStatic" wrap="yes" readonly><?=$TO_PERSON_NAME?></textarea>
        <a href="javascript:;" class="orgAdd" onClick="SelectUser('','TO_ID3', 'TO_NAME3')">添加</a>
        <a href="javascript:;" class="orgClear" onClick="ClearUser('TO_ID3', 'TO_NAME3')">清空</a>
      </td>
    </tr>
    <tr>
      <td nowrap class="TableContent">参与人：</td>
      <td class="TableData">
        <input type="hidden" name="COPY_TO_ID" value="<?=$PARTICIPATOR?>">
        <textarea cols=45 name="COPY_TO_NAME" rows="2" class="BigStatic" wrap="yes" readonly><?=$COPY_TO_NAME?></textarea>
        <a href="javascript:;" class="orgAdd" onClick="SelectUser('','COPY_TO_ID', 'COPY_TO_NAME')">添加</a>
        <a href="javascript:;" class="orgClear" onClick="ClearUser('COPY_TO_ID', 'COPY_TO_NAME')">清空</a>
      </td>
    </tr>
    <tr>
      <td nowrap class="TableContent">负责人：</td>
      <td class="TableData">
        <input type="hidden" name="SECRET_TO_ID" value="<?=$MANAGER?>">
        <textarea cols=45 name="SECRET_TO_NAME" rows="2" class="BigStatic" wrap="yes" readonly><?=$SECRET_TO_NAME?></textarea>
        <a href="javascript:;" class="orgAdd" onClick="SelectUser('','SECRET_TO_ID', 'SECRET_TO_NAME')">添加</a>
        <a href="javascript:;" class="orgClear" onClick="ClearUser('SECRET_TO_ID', 'SECRET_TO_NAME')">清空</a>
      </td>
    </tr>
    <tr>
      <td nowrap class="TableContent">批注领导：</td>
      <td class="TableData">
        <input type="hidden" name="TO_ID4" value="<?=$OPINION_LEADER?>">
        <textarea cols=45 name="TO_NAME4" rows="2" class="BigStatic" wrap="yes" readonly><?=$OPINION_LEADER_NAME?></textarea>
        <a href="javascript:;" class="orgAdd" onClick="SelectUser('','TO_ID4', 'TO_NAME4')">添加</a>
        <a href="javascript:;" class="orgClear" onClick="ClearUser('TO_ID4', 'TO_NAME4')">清空</a>
      </td>
    </tr>
    <tr>
      <td nowrap class="TableContent">说明：</td>
      <td class="TableData">
      	发布范围：指在“工作计划查询”中，可以查询到该工作计划的人员。<br>
      	参与人：指该工作计划的执行人员，可以写进度日志。<br>
      	负责人：指执行、管理该工作计划的人员，可以写进度日志。<br>   
      	批注领导：默认包括负责人、创建人。批注领导对该工作计划有批注权。  	      	
      </td>
    </tr>    
    <tr>
      <td nowrap class="TableContent">附件：</td>
      <td class="TableData">
<?
      if($ATTACHMENT_NAME=="")
         echo "无";
      else
         echo attach_link($ATTACHMENT_ID,$ATTACHMENT_NAME,1,1,1,1,1,1,0,0);
?>
      </td>
    </tr>
    <tr height="25">
      <td nowrap class="TableContent">附件选择：</td>
      <td class="TableData">
         <script>ShowAddFile();ShowAddImage();</script>
      </td>
    </tr>
    <tr>
      <td nowrap class="TableContent"> 附件说明：</td>
      <td class="TableData">
        <textarea cols=45 name="ATTACHMENT_COMMENT" rows=3 class="BigINPUT" wrap="yes"><?=$ATTACHMENT_COMMENT?></textarea>
      </td>
    </tr>
    <tr>
      <td nowrap class="TableContent"> 备注：</td>
      <td class="TableData">
        <textarea cols=45 name="REMARK" rows=3 class="BigINPUT" wrap="yes"><?=$REMARK?></textarea>
      </td>
    </tr>
    <tr>
      <td nowrap class="TableContent"> 有效期：</td>
      <td class="TableData">
        开始日期：<input type="text" name="BEGIN_DATE" size="10" maxlength="10" class="BigInput" value="<?=$BEGIN_DATE?>">
        <img src="/images/menu/calendar.gif" align="absMiddle" border="0" style="cursor:hand" onclick="td_calendar('form1.BEGIN_DATE');">
        为空为立即生效<br>
        结束日期：<input type="text" name="END_DATE" size="10" maxlength="10" class="BigInput" value="<?=$END_DATE?>">
        <img src="/images/menu/calendar.gif" align="absMiddle" border="0" style="cursor:hand" onclick="td_calendar('form1.END_DATE');">
        为空为手动终止
      </td>
    </tr>
    <tr>
      <td nowrap class="TableContent"> 计划类型：</td>
      <td class="TableData">
        <select name="TYPE" class="BigSelect">
<?
 $query = "SELECT * from PLAN_TYPE order by TYPE_NO";
 $cursor= exequery($connection,$query);
 while($ROW=mysql_fetch_array($cursor))
 {
    $TYPE_ID=$ROW["TYPE_ID"];
    $TYPE_NAME=$ROW["TYPE_NAME"];
?>
        <option value="<?=$TYPE_ID?>" <?if($TYPE==$TYPE_ID) echo "selected";?>><?=$TYPE_NAME?></option>
<?
 }
?>
        </select>
      </td>
    </tr>
    <tr>
      <td nowrap class="TableContent">提醒：</td>
      <td class="TableData">
         <?=sms_remind(12);?>
      </td>
    </tr>
    <tr>
      <td class="TableContent" colspan="2">计划内容：</td>
    </tr>
    <tr id="EDITOR">
      <td class="TableData" colspan="4">
<?
$editor = new Editor('CONTENT') ;
$editor->Value = $CONTENT ;
$editor->Create() ;
?>
      </td>
    </tr>
    <tr align="center" class="TableControl">
      <td colspan="2" nowrap>
        <input type="hidden" name="OP" value="">
        <input type="hidden" name="PUBLISH" value="">
        <input type="hidden" name="PLAN_ID" value="<?=$PLAN_ID?>">
        <input type="hidden" name="CREATOR" value="<?=$LOGIN_USER_ID?>">
        <input type="hidden" name="CREATE_DATE" value="<?=date('Y-m-d')?>">
        <input type="hidden" name="ATTACHMENT_ID_OLD" value="<?=$ATTACHMENT_ID?>">
        <input type="hidden" name="ATTACHMENT_NAME_OLD" value="<?=$ATTACHMENT_NAME?>">
        <input type="button" value="提交" class="BigButton" onclick="sendForm('1');">&nbsp;&nbsp;
        <input type="button" value="保存" class="BigButton" onclick="sendForm('0');">&nbsp;&nbsp;
<?
if($PLAN_ID!="")
{
?>
        <input type="button" value="返回" class="BigButton" onclick="history.back();">
<?
}
?>
      </td>
    </tr>
  </table>
</form>

</body>
</html>

⌨️ 快捷键说明

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