📄 index.php

📁 极限网络智能办公系统 Office Automation V3.0官方100％源代码.
💻 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">&nbsp;<?=$WORK_PLAN_COUNT?></span>&nbsp;条工作计划
    </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');">&nbsp;
	     <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');">&nbsp;
<?
           }
           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');">&nbsp;
<?
           }
?>
	     <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>
💿 文件大小 24085 K
👤 上传用户 happy_christina
📂 所属分类 OA系统
🏷️ 相关标签

#Automation #Office #3.0 #100
⌨️ 快捷键说明

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