?? new.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"> 項， 最少允許選擇 <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');">
<?
}
?>
<input type="button" value="保存" class="BigButton" onClick="CheckForm('0');">
<input type="reset" value="重填" class="BigButton">
<?
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 + -