📄 index.php
字号:
<?
include_once("inc/auth.php");
include_once("inc/utility_all.php");
?>
<html>
<head>
<title>新建工作计划</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<script Language="JavaScript">
function CheckForm()
{
if((document.form1.TO_ID.value=="")&& document.form1.COPY_TO_ID.value=="")
{ alert("请指定发布范围(部门或人员)或参与人不能同时为空！");
return (false);
}
if(document.form1.NAME.value=="")
{ alert("工作计划的标题不能为空！");
return (false);
}
if(document.form1.CONTENT.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_temp.substring(Pos+1,file_temp.length);
document.form1.ATTACHMENT_NAME.value=file_name;
}
document.form1.OP.value="0";
return true;
}
function upload_attach()
{
if(CheckForm())
{
document.form1.OP.value="1";
document.form1.submit();
}
}
function clear_dept()
{
document.form1.TO_NAME.value="";
document.form1.TO_ID.value="";
}
function LoadWindow()
{
URL="/module/dept_select";
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:1;status:0;help:0;resizable:1;dialogWidth:400px;dialogHeight:330px;dialogTop:"+loc_y+"px;dialogLeft:"+loc_x+"px");
}
function clear_user1()
{
document.form1.SECRET_TO_NAME.value="";
document.form1.SECRET_TO_ID.value="";
}
function LoadWindow1()
{
URL="/module/user_select?ID=1";
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 clear_user2()
{
document.form1.COPY_TO_NAME.value="";
document.form1.COPY_TO_ID.value="";
}
function LoadWindow2()
{
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 clear_user3()
{
document.form1.TO_ID3.value="";
document.form1.TO_NAME3.value="";
}
function LoadWindow3()
{
URL="/module/user_select?ID=3";
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 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="+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"];
}
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 * 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 * 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 * 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 * from USER where USER_ID='$TOK'";
$cursor1= exequery($connection,$query1);
if($ROW1=mysql_fetch_array($cursor1))
$SECRET_TO_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"><span class="big3"> <?=$TITLE?></span>
</td>
</tr>
</table>
<br>
<table border="0" width="600" cellpadding="2" cellspacing="1" align="center" bgcolor="#000000" class="small">
<form enctype="multipart/form-data" action="submit.php" method="post" name="form1" onsubmit="return CheckForm();">
<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">
<textarea cols=40 name="CONTENT" rows=3 class="BigINPUT" wrap="yes"><?=$CONTENT?></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" 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" 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";
$connection=OpenConnection();
$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">
<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>
<input type="button" value="添 加" class="SmallButton" onClick="LoadWindow()" title="添加部门" name="button">
<input type="button" value="清 空" class="SmallButton" onClick="clear_dept()" title="清空部门" name="button">
</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>
<input type="button" value="添 加" class="SmallButton" onClick="LoadWindow3()" name="button">
<input type="button" value="清 空" class="SmallButton" onClick="clear_user3()" name="button">
</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>
<input type="button" value="添 加" class="SmallButton" onClick="LoadWindow2()" name="button">
<input type="button" value="清 空" class="SmallButton" onClick="clear_user2()" name="button">
</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>
<input type="button" value="添 加" class="SmallButton" onClick="LoadWindow1()" name="button">
<input type="button" value="清 空" class="SmallButton" onClick="clear_user1()" name="button">
</td>
</tr>
<tr>
<td nowrap class="TableContent">附件：</td>
<td class="TableData">
<?
if($ATTACHMENT_NAME=="")
echo "无";
else
{
$ATTACHMENT_ID_ARRAY=explode(",",$ATTACHMENT_ID);
$ATTACHMENT_NAME_ARRAY=explode("*",$ATTACHMENT_NAME);
$ARRAY_COUNT=sizeof($ATTACHMENT_ID_ARRAY);
for($I=0;$I<$ARRAY_COUNT;$I++)
{
if($ATTACHMENT_ID_ARRAY[$I]=="")
break;
$ATTACH_SIZE=attach_size($ATTACHMENT_ID_ARRAY[$I],$ATTACHMENT_NAME_ARRAY[$I]);
$ATTACH_SIZE=number_format($ATTACH_SIZE,0, ".",",");
?>
<img src="/images/email_atta.gif" align="absmiddle"><a href="/inc/attach.php?ATTACHMENT_ID=<?=$ATTACHMENT_ID_ARRAY[$I]*3+2?>&ATTACHMENT_NAME=<?=urlencode($ATTACHMENT_NAME_ARRAY[$I])?>" target="_blank"><?=$ATTACHMENT_NAME_ARRAY[$I]?></a>
<?
if(stristr($ATTACHMENT_NAME_ARRAY[$I],".doc")||stristr($ATTACHMENT_NAME_ARRAY[$I],".ppt")||stristr($ATTACHMENT_NAME_ARRAY[$I],".xls"))
{
?>
<input type="button" value="阅读" class="SmallButton" onClick="window.open('/module/OC?ATTACHMENT_ID=<?=$ATTACHMENT_ID_ARRAY[$I]*3+2?>&ATTACHMENT_NAME=<?=urlencode($ATTACHMENT_NAME_ARRAY[$I])?>&OP=5','<?=$ATTACHMENT_ID_ARRAY[$I]?>','menubar=0,toolbar=0,status=1,scrollbars=1,resizable=1');">
<input type="button" value="编辑" class="SmallButton" onClick="window.open('/module/OC?ATTACHMENT_ID=<?=$ATTACHMENT_ID_ARRAY[$I]*3+2?>&ATTACHMENT_NAME=<?=urlencode($ATTACHMENT_NAME_ARRAY[$I])?>&OP=4','<?=$ATTACHMENT_ID_ARRAY[$I]?>','menubar=0,toolbar=0,status=1,scrollbars=1,resizable=1');">
<?
}
else if(is_media($ATTACHMENT_NAME_ARRAY[$I]))
{
?>
<input type="button" value="播放" class="SmallButton" onClick="window.open('/module/mediaplayer/index.php?MEDIA_NAME=<?=urlencode($ATTACHMENT_NAME_ARRAY[$I])?>&MEDIA_URL=<?=urlencode("/inc/attach.php?ATTACHMENT_ID=".($ATTACHMENT_ID_ARRAY[$I]*3+2)."&ATTACHMENT_NAME=".urlencode($ATTACHMENT_NAME_ARRAY[$I]))?>','media<?=$ATTACHMENT_ID_ARRAY[$I]?>','menubar=0,toolbar=0,status=1,scrollbars=1,resizable=1');">
<?
}
?>
<input type="button" value="删除" class="SmallButton" onClick="delete_attach('<?=$ATTACHMENT_ID_ARRAY[$I]?>','<?=$ATTACHMENT_NAME_ARRAY[$I]?>');">
(<?=$ATTACH_SIZE?>字节)<br>
<?
}
}
?>
</td>
</tr>
<tr>
<td nowrap class="TableContent">附件上传：</td>
<td class="TableData">
<input type="file" name="ATTACHMENT" size="30" class="BigInput" title="选择附件文件">
<input type="button" value="上传附件" class="BigButton" onclick="upload_attach();" title="上传附件">
<input type="hidden" name="ATTACHMENT_ID_OLD" value="<?=$ATTACHMENT_ID?>">
<input type="hidden" name="ATTACHMENT_NAME_OLD" value="<?=$ATTACHMENT_NAME?>">
</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="TableData">提醒：</td>
<td class="TableData">
<input type="checkbox" name="SMS_REMIND" id="SMS_REMIND" 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,12)) //检查该模块是否允许手机提醒
{
?>
<input type="checkbox" name="SMS2_REMIND" id="SMS2_REMIND"><label for="SMS2_REMIND">使用手机短信提醒用户</label>
<?
}
?>
</td>
</tr>
<tr align="center" class="TableControl">
<td colspan="2" nowrap>
<input type="hidden" name="ATTACHMENT_NAME">
<input type="hidden" name="OP" 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="submit" value="提交" class="BigButton">
<input type="reset" value="重填" class="BigButton">
<input type="button" value="返回" class="BigButton" onClick="location='../'">
</td>
</tr>
</table>
</form>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -