?? query.php
字號:
<?
include_once("inc/auth.php");
include_once("inc/check_type.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="../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");
}
</script>
</head>
<body class="bodycolor" topmargin="5">
<?
$connection=OpenConnection();
$MANAGER=$SECRET_TO_ID;
$PARTICIPATOR=$COPY_TO_ID;
//----------- 合法性校驗 ---------
if($BEGIN_DATE!="")
{
$TIME_OK=is_date($BEGIN_DATE);
if(!$TIME_OK)
{ Message("錯誤","起始日期格式不對，應形如 1999-1-2");
Button_Back();
exit;
}
}
if($END_DATE!="")
{
$TIME_OK=is_date($END_DATE);
if(!$TIME_OK)
{ Message("錯誤","截止日期格式不對，應形如 1999-1-2");
Button_Back();
exit;
}
}
//------------------------ 生成條件字符串 ------------------
$CONDITION_STR="";
if($NAME!="")
$CONDITION_STR.="NAME like '%".$NAME."%'";
if($CONTENT!="")
{
if($CONDITION_STR!="")
$CONDITION_STR.=" and ";
$CONDITION_STR.="CONTENT like '%".$CONTENT."%'";
}
if($BEGIN_DATE!="")
{
if($CONDITION_STR!="")
$CONDITION_STR.=" and ";
$CONDITION_STR.="BEGIN_DATE>='".$BEGIN_DATE."'";
}
if($END_DATE!="")
{
if($CONDITION_STR!="")
$CONDITION_STR.=" and ";
$CONDITION_STR.="END_DATE<='".$END_DATE."'";
}
if($TYPE!="ALL_TYPE")
{
if($CONDITION_STR!="")
$CONDITION_STR.=" and ";
$CONDITION_STR.="TYPE like '%".$TYPE."%'";
}
if($TO_ID!="")
{
if($CONDITION_STR!="")
$CONDITION_STR.=" and ";
$CONDITION_STR.="TO_ID like '%".$TO_ID."%'";
}
if($TO_ID3!="")
{
if($CONDITION_STR!="")
$CONDITION_STR.=" and ";
$CONDITION_STR.="TO_PERSON_ID like '%".$TO_ID3."%'";
}
if($MANAGER!="")
{
if($CONDITION_STR!="")
$CONDITION_STR.=" and ";
$CONDITION_STR.="MANAGER like '%".$MANAGER."%'";
}
if($PARTICIPATOR!="")
{
if($CONDITION_STR!="")
$CONDITION_STR.=" and ";
$CONDITION_STR.="PARTICIPATOR like '%".$PARTICIPATOR."%'";
}
if($REMARK!="")
{
if($CONDITION_STR!="")
$CONDITION_STR.=" and ";
$CONDITION_STR.="REMARK like '%".$REMARK."%'";
}
$query = "SELECT * from USER where USER_ID='$LOGIN_USER_ID'";
$cursor= exequery($connection,$query);
if($ROW=mysql_fetch_array($cursor))
$POST_PRIV=$ROW["POST_PRIV"];
//------------------------------------------------------------------------------
if($LOGIN_USER_PRIV=="1")
{
if($CONDITION_STR!="")
$CONDITION_STR1=" where ".$CONDITION_STR;
}
else
{
$CONDITION_STR1=" where TO_ID='ALL_DEPT' or InStr(TO_ID,',$LOGIN_DEPT_ID,')>0 or InStr(TO_ID,'$LOGIN_DEPT_ID,')=1 or InStr(TO_PERSON_ID,',$LOGIN_USER_ID,')>0 or InStr(TO_PERSON_ID,'$LOGIN_USER_ID,')=1";
if($CONDITION_STR!="")
$CONDITION_STR1.=" and $CONDITION_STR";
}
$query = "SELECT count(*) from WORK_PLAN".$CONDITION_STR1;
$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("","無符合條件的工作計劃");
?>
<P align="center"><input type="button" value="返回" class="BigButton" onClick="location='index.php'"></P>
<?
exit;
}
?>
<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>
<td valign="bottom" class="small1">共<span class="big4"> <?=$WORK_PLAN_COUNT?></span> 條符合條件的工作計劃
</td>
</tr>
</table>
<br>
<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>
</tr>
<?
//============================ 顯示查詢結果 =======================================
$CUR_DATE=date("Y-m-d",time());
$query = "SELECT * from WORK_PLAN".$CONDITION_STR1." 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($ROW=mysql_fetch_array($cursor1))
$TO_NAME.=$ROW["DEPT_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);
$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(",");
}
if(strlen($TO_NAME)>20)
$TO_NAME=csubstr($TO_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 nowrap 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 nowrap align="center"><?=$TO_NAME?></td>
<td align="center"><?=$TO_PERSON_NAME?></td>
<td nowrap align="center"><?=$MANAGE_NAME?></td>
<td nowrap 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');">
<?
}
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');">
<?
}
?>
(<?=$ATTACH_SIZE?>字節)<br>
<?
}
}
?>
</td>
<td nowrap align="center"><?=$STATUS_DESC?></td>
</tr>
<?
}
?>
<tr class="TableControl">
<td colspan="9" align="center">
<input type="button" value="返回" class="BigButton" onClick="location='index.php'">
</td>
</tr>
</table>
</body>
</html>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -