?? 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>
function plan_detail(PLAN_ID)
{
URL="../show/plan_detail.php?PLAN_ID="+PLAN_ID;
myleft=(screen.availWidth-500)/2;
window.open(URL,"read_work_plan","height=400,width=500,status=1,toolbar=no,menubar=no,location=no,scrollbars=yes,top=150,left="+myleft+",resizable=yes");
}
function delete_work_plan(PLAN_ID)
{
msg='確認要刪除該項工作計劃么？';
if(window.confirm(msg))
{
URL="delete.php?PLAN_ID=" + PLAN_ID;
window.location=URL;
}
}
function delete_all()
{
msg='確認要刪除所有工作計劃么？';
if(window.confirm(msg))
{
URL="delete_all.php";
window.location=URL;
}
}
</script>
</head>
<body class="bodycolor" topmargin="5">
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
<tr>
<td class="Big"><img src="/images/notify_new.gif" align="absmiddle"><span class="big3"> 新建工作計劃</span><br>
</td>
</tr>
</table>
<div align="center">
<input type="button" value="新建工作計劃" class="BigButton" onClick="location='new';" title="撰寫工作計劃，并指定發布范圍">
</div>
<br>
<table width="95%" border="0" cellspacing="0" cellpadding="0" height="3">
<tr>
<td background="/images/dian1.gif" width="100%"></td>
</tr>
</table>
<?
$connection=OpenConnection();
// $CUR_TIME=date("Y-m-d H:i:s",time());
if($LOGIN_USER_PRIV!="1")
$query = "SELECT count(*) from WORK_PLAN where CREATOR='$LOGIN_USER_ID'";
else
$query = "SELECT count(*) from WORK_PLAN";
$cursor= exequery($connection,$query);
$WORK_PLAN_COUNT=0;
if($ROW=mysql_fetch_array($cursor))
$WORK_PLAN_COUNT=$ROW[0];
if($WORK_PLAN_COUNT==0)
{
?>
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
<tr>
<td class="Big"><img src="/images/menu/work_plan.gif" align="absmiddle"><span class="big3"> 管理工作計劃</span><br>
</td>
</tr>
</table>
<br>
<?
Message("","無工作計劃");
exit;
}
?>
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
<tr>
<td class="Big"><img src="/images/menu/work_plan.gif" height="22" width="22"><span class="big3"> 管理工作計劃</span><br>
</td>
<td valign="bottom" class="small1">共<span class="big4"> <?=$WORK_PLAN_COUNT?></span> 條工作計劃
</td>
</tr>
</table>
<table border="0" cellspacing="1" width="95%" class="small" bgcolor="#000000" cellpadding="3">
<tr class="TableHeader">
<td nowrap align="center">計劃名稱</td>
<td nowrap align="center">開始時間</td>
<td nowrap align="center">結束時間</td>
<td nowrap align="center">計劃類別</td>
<td nowrap align="center">開放部門</td>
<td nowrap align="center">開放人員</td>
<td nowrap align="center">負責人</td>
<td nowrap align="center">附件</td>
<td nowrap align="center">狀態</td>
<td nowrap align="center">操作</td>
</tr>
<?
//============================ 顯示已發布公告 =======================================
$CUR_DATE=date("Y-m-d",time());
if($LOGIN_USER_PRIV!="1")
$query = "SELECT * from WORK_PLAN where CREATOR='$LOGIN_USER_ID' order by CREATE_DATE desc";
else
$query = "SELECT * from WORK_PLAN order by CREATE_DATE desc";
$cursor= exequery($connection,$query);
$WORK_PLAN_COUNT=0;
while($ROW=mysql_fetch_array($cursor))
{
$WORK_PLAN_COUNT++;
$PLAN_ID=$ROW["PLAN_ID"];
$NAME=$ROW["NAME"];
$BEGIN_DATE=$ROW["BEGIN_DATE"];
$END_DATE=$ROW["END_DATE"];
$TYPE=$ROW["TYPE"];
$TO_ID=$ROW["TO_ID"];
$MANAGER=$ROW["MANAGER"];
$ATTACHMENT_ID=$ROW["ATTACHMENT_ID"];
$ATTACHMENT_NAME=$ROW["ATTACHMENT_NAME"];
$TO_PERSON_ID=$ROW["TO_PERSON_ID"];
$query = "SELECT * from PLAN_TYPE where TYPE_ID='$TYPE'";
$cursor1= exequery($connection,$query);
if($ROW1=mysql_fetch_array($cursor1))
$TYPE_DESC=$ROW1["TYPE_NAME"];
if($TO_ID=="ALL_DEPT")
$TO_NAME="全體部門";
else
{
$TO_NAME="";
$TOK=strtok($TO_ID,",");
while($TOK!="")
{
if($TO_NAME!="")
$TO_NAME.="，";
$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(",");
}
}
$TO_PERSON_NAME="";
$TOK=strtok($TO_PERSON_ID,",");
while($TOK!="")
{
if($TO_PERSON_NAME!="")
$TO_PERSON_NAME.="，";
$query1="select * from USER where USER_ID='$TOK'";
$cursor1= exequery($connection,$query1);
if($ROW1=mysql_fetch_array($cursor1))
{
$DEPT_ID=$ROW1["DEPT_ID"];
$DEPT_NAME=dept_long_name($DEPT_ID);
$TO_PERSON_NAME.="<u title=\"部門：".$DEPT_NAME."\" style=\"cursor:hand\">".$ROW1["USER_NAME"]."</u>";
}
$TOK=strtok(",");
}
$PARTICIPATOR_NAME="";
$TOK=strtok($PARTICIPATOR,",");
while($TOK!="")
{
if($PARTICIPATOR_NAME!="")
$PARTICIPATOR_NAME.="，";
$query1="select * from USER where USER_ID='$TOK'";
$cursor1= exequery($connection,$query1);
if($ROW1=mysql_fetch_array($cursor1))
$PARTICIPATOR_NAME.=$ROW1["USER_NAME"];
$TOK=strtok(",");
}
$MANAGE_NAME="";
$TOK=strtok($MANAGER,",");
while($TOK!="")
{
if($MANAGE_NAME!="")
$MANAGE_NAME.="，";
$query1="select * from USER where USER_ID='$TOK'";
$cursor1= exequery($connection,$query1);
if($ROW1=mysql_fetch_array($cursor1))
{
$DEPT_ID=$ROW1["DEPT_ID"];
$DEPT_NAME=dept_long_name($DEPT_ID);
$MANAGE_NAME.="<u title=\"部門：".$DEPT_NAME."\" style=\"cursor:hand\">".$ROW1["USER_NAME"]."</u>";
}
$TOK=strtok(",");
}
$MANAGE_NAME=substr($MANAGE_NAME,0,-1);
if(strlen($TO_NAME)>20)
$TO_NAME=csubstr($TO_NAME,0,20)."...";
if(strlen($PARTICIPATOR_NAME)>20)
$PARTICIPATOR_NAME=csubstr($PARTICIPATOR_NAME,0,20)."...";
if(compare_date($CUR_DATE,$BEGIN_DATE)<0)
{
$STATUS=1;
$STATUS_DESC="待生效";
}
else
{
$STATUS=2;
$STATUS_DESC="<font color='#00AA00'><b>已生效</span>";
}
if($END_DATE!="0000-00-00")
{
if(compare_date($CUR_DATE,$END_DATE)>0)
{
$STATUS=3;
$STATUS_DESC="<font color='#FF0000'><b>已終止</span>";
}
}
if($WORK_PLAN_COUNT%2==1)
$TableLine="TableLine1";
else
$TableLine="TableLine2";
if($END_DATE=="0000-00-00")
$END_DATE="";
?>
<tr class="<?=$TableLine?>">
<td align="center"><a href="javascript:plan_detail('<?=$PLAN_ID?>');"><?=$NAME?></a></td>
<td nowrap align="center"><?=$BEGIN_DATE?></td>
<td nowrap align="center"><?=$END_DATE?></a></td>
<td nowrap align="center"><?=$TYPE_DESC?></td>
<td align="center"><?=$TO_NAME?></td>
<td align="center"><?=$TO_PERSON_NAME?></td>
<td align="center"><?=$MANAGE_NAME?></td>
<td align="left">
<?
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>
<td nowrap align="center"><?=$STATUS_DESC?></td>
<td nowrap align="center">
<a href="new?PLAN_ID=<?=$PLAN_ID?>"> 修改</a>
<a href="javascript:delete_work_plan('<?=$PLAN_ID?>');"> 刪除</a>
<?
if($STATUS==1)
{
?>
<a href="manage.php?PLAN_ID=<?=$PLAN_ID?>&OPERATION=1"> 立即生效</a>
<?
}
else if($STATUS==2)
{
?>
<a href="manage.php?PLAN_ID=<?=$PLAN_ID?>&OPERATION=2"> 立即終止</a>
<?
}
else if($STATUS==3)
{
?>
<a href="manage.php?PLAN_ID=<?=$PLAN_ID?>&OPERATION=3"> 恢復生效</a>
<?
}
?>
</td>
</tr>
<?
}
?>
<tr class="TableControl">
<td colspan="10" align="center">
<input type="button" value="全部刪除" class="SmallButton" onClick="delete_all()" title="刪除所有自己發布的工作計劃">
</td>
</tr>
</table>
</body>
</html>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -