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

📄 new.php

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

if($PARENT_ID!="" && $PARENT_ID!="0")
{
 $query = "SELECT * from VOTE_TITLE where VOTE_ID='$PARENT_ID'";
 $cursor= exequery($connection,$query);
 if($ROW=mysql_fetch_array($cursor))
 {
    $TO_ID=$ROW["TO_ID"];
    $PRIV_ID=$ROW["PRIV_ID"];
    $COPY_TO_ID=$ROW["USER_ID"];
    $TYPE=$ROW["TYPE"];
    $MAX_NUM=$ROW["MAX_NUM"];
	$MIN_NUM=$ROW["MIN_NUM"];
    $ANONYMITY=$ROW["ANONYMITY"];
    $VIEW_PRIV=$ROW["VIEW_PRIV"];
    $BEGIN_DATE=$ROW["BEGIN_DATE"];
    $END_DATE=$ROW["END_DATE"];

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

    if($TO_ID=="ALL_DEPT")
       $TO_NAME="全体部门";
    else
    {
      $TO_NAME="";
      $TOK=strtok($TO_ID,",");
      while($TOK!="")
      {
        $query1="select DEPT_NAME from DEPARTMENT where DEPT_ID='$TOK'";
        $cursor1= exequery($connection,$query1);
        if($ROW=mysql_fetch_array($cursor1))
           $TO_NAME.=$ROW["DEPT_NAME"].",";

        $TOK=strtok(",");
      }
    }

    $PRIV_NAME="";
    $query1="select PRIV_NAME from USER_PRIV where find_in_set(USER_PRIV,'$PRIV_ID')";
    $cursor1= exequery($connection,$query1);
    while($ROW=mysql_fetch_array($cursor1))
       $PRIV_NAME.=$ROW["PRIV_NAME"].",";

    $COPY_TO_NAME="";
    $query1="select USER_NAME from USER where find_in_set(USER_ID,'$COPY_TO_ID')";
    $cursor1= exequery($connection,$query1);
    while($ROW=mysql_fetch_array($cursor1))
       $COPY_TO_NAME.=$ROW["USER_NAME"].",";
 }
}

if($VOTE_ID!="")
{
 $query = "SELECT * from VOTE_TITLE where VOTE_ID='$VOTE_ID'";
 $cursor= exequery($connection,$query);
 if($ROW=mysql_fetch_array($cursor))
 {
    $TO_ID=$ROW["TO_ID"];
    $PARENT_ID=$ROW["PARENT_ID"];
    $PRIV_ID=$ROW["PRIV_ID"];
    $COPY_TO_ID=$ROW["USER_ID"];
    $SUBJECT=$ROW["SUBJECT"];
    $CONTENT=$ROW["CONTENT"];
    $TYPE=$ROW["TYPE"];
    $MAX_NUM=$ROW["MAX_NUM"];
	$MIN_NUM=$ROW["MIN_NUM"];
    $ANONYMITY=$ROW["ANONYMITY"];
    $VIEW_PRIV=$ROW["VIEW_PRIV"];
    $BEGIN_DATE=$ROW["BEGIN_DATE"];
    $END_DATE=$ROW["END_DATE"];
    $PUBLISH=$ROW["PUBLISH"];
    $VOTE_NO=$ROW["VOTE_NO"];
	$ATTACHMENT_ID=$ROW["ATTACHMENT_ID"];
	$ATTACHMENT_NAME=$ROW["ATTACHMENT_NAME"];
	
    if($BEGIN_DATE=="0000-00-00")
       $BEGIN_DATE="";
    if($END_DATE=="0000-00-00")
       $END_DATE="";

    if($TO_ID=="ALL_DEPT")
       $TO_NAME="全体部门";
    else
    {
      $TO_NAME="";
      $TOK=strtok($TO_ID,",");
      while($TOK!="")
      {
        $query1="select DEPT_NAME from DEPARTMENT where DEPT_ID='$TOK'";
        $cursor1= exequery($connection,$query1);
        if($ROW=mysql_fetch_array($cursor1))
           $TO_NAME.=$ROW["DEPT_NAME"].",";

        $TOK=strtok(",");
      }
    }

    $PRIV_NAME="";
    $query1="select PRIV_NAME from USER_PRIV where find_in_set(USER_PRIV,'$PRIV_ID')";
    $cursor1= exequery($connection,$query1);
    while($ROW=mysql_fetch_array($cursor1))
       $PRIV_NAME.=$ROW["PRIV_NAME"].",";

    $COPY_TO_NAME="";
    $query1="select USER_NAME from USER where find_in_set(USER_ID,'$COPY_TO_ID')";
    $cursor1= exequery($connection,$query1);
    while($ROW=mysql_fetch_array($cursor1))
       $COPY_TO_NAME.=$ROW["USER_NAME"].",";
 }
}
?>

<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(flag)
{
<?
if($PARENT_ID=="" || $PARENT_ID=="0")
{
?>
   if(document.form1.TO_ID.value=="" && document.form1.PRIV_ID.value=="" && document.form1.COPY_TO_ID.value=="")
   { alert("请至少指定一种发布范围！");
     return (false);
   }
<?
}
?>
   if(document.form1.SUBJECT.value=="")
   { alert("投票的标题不能为空！");
     return (false);
   }
   
   if(document.form1.TYPE.value=="1")
   {
      if (document.getElementById("MIN_NUM").value>document.getElementById("MAX_NUM").value)
	  {
	     alert("多选类型中，最少允许选择项应小于最多允许选择项！");
         return (false);
	  }
   }
   
   if (flag=="0")
   {
      if(document.form1.PUBLISH.value=="")
        document.form1.PUBLISH.value="0";
	  document.form1.OP.value="3";
   }
	 
   if (flag=="1")
     document.form1.PUBLISH.value="1";

   document.form1.submit();
}

function upload_attach()
{
  if (document.form1.PUBLISH.value=="")
     document.form1.PUBLISH.value="0";
 
  <?
  if($PARENT_ID=="" || $PARENT_ID=="0")
  {
  ?>
     if(document.form1.TO_ID.value=="" && document.form1.PRIV_ID.value=="" && document.form1.COPY_TO_ID.value=="")
     { 
	    alert("请至少指定一种发布范围！");
        return;
      }
  <?
  }
  ?>
   if(document.form1.SUBJECT.value=="")
   { 
      alert("投票的标题不能为空！");
      return;
   }
   
   document.form1.OP.value="0";
   document.form1.submit();
  
}

function change_type()
{
   if(document.form1.TYPE.value=="1")
      document.getElementById("MAX_NUM_DESC").style.display="";
   else
      document.getElementById("MAX_NUM_DESC").style.display="none";
}

function delete_attach(ATTACHMENT_ID,ATTACHMENT_NAME)
{
  msg="确定要删除文件 '"+ ATTACHMENT_NAME +"' 吗?";
  if(window.confirm(msg))
  {
    URL="delete_attach.php?VOTE_ID=<?=$VOTE_ID?>&ATTACHMENT_ID="+ATTACHMENT_ID+"&ATTACHMENT_NAME="+URLSpecialChars(ATTACHMENT_NAME);
    window.location=URL;
  }
}

</script>
</head>

<body class="bodycolor" topmargin="5" onLoad="javascript:form1.SUBJECT.focus();">
<?
if($MAX_NUM=="")
   $MAX_NUM=0;
if($MIN_NUM=="")
   $MIN_NUM=0;
?>
<table border="0" width="90%" cellspacing="0" cellpadding="3" class="small">
  <tr>
    <td class="Big"><img src="/images/notify_new.gif" align="absmiddle"><span class="big3"> <?if($VOTE_ID!="")echo "修改";else echo "新建";?>投票</span>
    </td>
  </tr>
</table>

<form enctype="multipart/form-data" action="add.php"  method="post" name="form1">
<table class="TableBlock" width="70%" align="center">
<?
if($PARENT_ID=="" || $PARENT_ID=="0")
{
?>
    <tr>
      <td nowrap class="TableData">发布范围（部门）：</td>
      <td class="TableData">
        <input type="hidden" name="TO_ID" value="<?=$TO_ID?>">
        <textarea cols=40 name="TO_NAME" rows=2 class="BigStatic" wrap="yes" readonly><?=$TO_NAME?></textarea>
        <a href="javascript:;" class="orgAdd" onClick="SelectDept('7')">添加</a>
       <a href="javascript:;" class="orgClear" onClick="ClearUser()">清空</a>
      </td>
    </tr>
    <tr>
      <td nowrap class="TableData">发布范围（角色）：</td>
      <td class="TableData">
        <input type="hidden" name="PRIV_ID" value="<?=$PRIV_ID?>">
        <textarea cols=40 name="PRIV_NAME" rows=2 class="BigStatic" wrap="yes" readonly><?=$PRIV_NAME?></textarea>
        <a href="javascript:;" class="orgAdd" onClick="SelectPriv('7')">添加</a>
        <a href="javascript:;" class="orgClear" onClick="ClearUser('PRIV_ID', 'PRIV_NAME')">清空</a>
      </td>
   </tr>
   <tr>
      <td nowrap class="TableData">发布范围（人员）：</td>
      <td class="TableData">
        <input type="hidden" name="COPY_TO_ID" value="<?=$COPY_TO_ID?>">
        <textarea cols=40 name="COPY_TO_NAME" rows=2 class="BigStatic" wrap="yes" readonly><?=$COPY_TO_NAME?></textarea>
        <a href="javascript:;" class="orgAdd" onClick="SelectUser('7','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="TableData"> 标题：</td>
      <td class="TableData">
        <input type="text" name="SUBJECT" size="40" maxlength="100" class="BigInput" value="<?=$SUBJECT?>">
      </td>
    </tr>
    <tr>
      <td nowrap class="TableData">投票描述：</td>
      <td class="TableData">
        <textarea name="CONTENT" class="BigInput" cols="50" rows="3"><?=$CONTENT?></textarea>
      </td>
    </tr>
<?
if($PARENT_ID)
{
?>
    <tr>
      <td nowrap class="TableData"> 排序号：</td>
      <td class="TableData">
        <input type="text" name="VOTE_NO" size="10" maxlength="20" class="BigInput" value="<?=$VOTE_NO?>">
      </td>
    </tr>
<?
}
?>
    <tr>
      <td nowrap class="TableData"> 类型：</td>
      <td class="TableData">
        <select name="TYPE" class="BigSelect" onChange="change_type();">
          <option value="0" <?if($TYPE=="0") echo "selected";?>>单选</option>
          <option value="1" <?if($TYPE=="1") echo "selected";?>>多选</option>
          <option value="2" <?if($TYPE=="2") echo "selected";?>>文本输入</option>
        </select>
        <span id="MAX_NUM_DESC" style="display:<?if($TYPE!="1") echo "none";?>">最多允许选择 <input type="input" name="MAX_NUM" value="<?=$MAX_NUM?>" size="2" class="SmallInput"> 项，&nbsp;最少允许选择 <input type="input" name="MIN_NUM" value="<?=$MIN_NUM?>" size="2" class="SmallInput"> 项，0则不限制</span>
      </td>
    </tr>
<?
if($PARENT_ID=="" || $PARENT_ID=="0")
{
?>
    <tr>
      <td nowrap class="TableData"> 查看投票结果：</td>
      <td class="TableData">
        <select name="VIEW_PRIV" class="BigSelect">
          <option value="0" <?if($VIEW_PRIV=="0") echo "selected";?>>投票后允许查看</option>
          <option value="1" <?if($VIEW_PRIV=="1") echo "selected";?>>投票前允许查看</option>
          <option value="2" <?if($VIEW_PRIV=="2") echo "selected";?>>不允许查看</option>
        </select>
      </td>
    </tr>
    <tr>
      <td nowrap class="TableData"> 匿名投票：</td>
      <td class="TableData">
        <input type="checkbox" name="ANONYMITY" id="ANONYMITY" <?if($ANONYMITY=="1") echo "checked";?>><label for="ANONYMITY">允许匿名投票</label>
      </td>
    </tr>
    <tr>
      <td nowrap class="TableData"> 有效期：</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 class="TableData">
      <td nowrap>附件文档：</td>
      <td nowrap><?=attach_link($ATTACHMENT_ID,$ATTACHMENT_NAME,1,1,1,0,1,1)?></td>
    </tr>
    <tr height="25">
      <td nowrap class="TableData">附件选择：</td>
      <td class="TableData">
         <script>ShowAddFile();</script>
         <script>$("ATTACHMENT_upload_div").innerHTML='<a href="javascript:upload_attach();">上传附件</a>'</script>
      </td>
    </tr>
    <?
    if ($VOTE_ID!="")
	{
	?>
    <tr>
      <td nowrap class="TableData"> 短消息提醒：</td>
      <td class="TableData">
<?=sms_remind(11);?>
      </td>
    </tr>
<?
   }
}
?>
    <tr align="center" class="TableControl">
      <td colspan="2" nowrap>
        <input type="hidden" name="VOTE_ID" value="<?=$VOTE_ID?>">
        <input type="hidden" name="start" value="<?=$start?>">
        <input type="hidden" name="PARENT_ID" value="<?=$PARENT_ID?>">
        <input type="hidden" name="PUBLISH" value="<?=$PUBLISH?>">
        <input type="hidden" name="OP" value="">
        <input type="hidden" name="ATTACHMENT_ID_OLD" value="<?=$ATTACHMENT_ID?>">
        <input type="hidden" name="ATTACHMENT_NAME_OLD" value="<?=$ATTACHMENT_NAME?>">
<?
if(($VOTE_ID!="")&&($PARENT_ID=="" || $PARENT_ID=="0")&&($PUBLISH!="1"))
{
?>
        <input type="button" value="发布" class="BigButton" onClick="CheckForm('1');">&nbsp;&nbsp;
<?
}
?>
        <input type="button" value="保存" class="BigButton" onClick="CheckForm('0');">&nbsp;&nbsp;
        <input type="reset" value="重填" class="BigButton">&nbsp;&nbsp;
<?
if($VOTE_ID!=""&&($PARENT_ID=="" || $PARENT_ID=="0"))
{
?>
        <input type="button" value="返回" class="BigButton" onClick="location='index1.php?start=<?=$start?>'">
<?
}

if($PARENT_ID!=""&&$PARENT_ID!="0")
{
?>
        <input type="button" value="返回" class="BigButton" onClick="location='vote.php?PARENT_ID=<?=$PARENT_ID?>&start=<?=$start?>'">
<?
}
?>
      </td>
    </tr>
  </table>
</form>

</body>
</html>

⌨️ 快捷键说明

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