今日计划.php

极限网络智能办公系统 Office Automation V3.0官方100％源代码.

<!-------------------- 工作计划 ----------------------->
<script>
function plan_detail(PLAN_ID)
{
 URL="/general/work_plan/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");
}
</script>
<div id="module_<?=$MODULE_ID?>"  style="position: relative;padding-bottom:10px;">
<table border="0" cellspacing="1" width="100%" class="small" bgcolor="#000000" cellpadding="3">
 <tr class="TableControl">
   <td id="module_<?=$MODULE_ID?>_head" class="TableHeader" width="58%"><img src="/images/menu/work_plan.gif" WIDTH="18" HEIGHT="16" align="absmiddle"> 今日计划</td>
   <td id="module_<?=$MODULE_ID?>_more" align="right">
   <div id="module_<?=$MODULE_ID?>_op" style="float:left;display:none;"><a href="javascript:_edit('<?=$MODULE_ID?>');"><img border="0" src="/images/edit.gif" alt="设置显示条数"></a><?if($VIEW_TYPE!="2"){?><a id="module_<?=$MODULE_ID?>_url" href="#" onclick="_del('<?=$MODULE_ID?>');"><img border="0" src="/images/x.gif" alt="不显示该模块"></a><?}?></div>
   <div style="float:right"><a href="/general/work_plan/show"> <img src="/images/green_arrow.gif" border="0" align="absmiddle"> 全部</a>&nbsp;</div>
   </td>
 </tr>
 <tr class="TableControl" id="module_<?=$MODULE_ID?>_edit" style="display:none;">
   <td colspan="2" align="right">
     <div id="module_<?=$MODULE_ID?>_info" style="float:left;"></div>
     显示条数：<input type="input" size="3" class="SmallInput" value="<?=$_COOKIE[$LOGIN_USER_ID."_my_".$MODULE_ID."_nums"]?>" name="MODULE_NUM_<?=$MODULE_ID?>">&nbsp;
     <a href="javascript:SetNums('<?=$MODULE_ID?>');" title="保存设置">设置</a>
     <a href="javascript:_edit('<?=$MODULE_ID?>');" title="关闭">关闭</a>
    </td>
  </tr>
 <tr style="background:#FFFFFF url(/images/water/work_plan.jpg) no-repeat bottom right">
    <td colspan=2 height="50">
<?
 $MAX_COUNT=intVal($_COOKIE[$LOGIN_USER_ID."_my_".$MODULE_ID."_nums"]);
 if($MAX_COUNT<=0 || $MAX_COUNT>=1000)
    $MAX_COUNT=10;
 $RANGE_STR="(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";
 $CUR_DATE=date("Y-m-d",time());
 $DATE_STR="BEGIN_DATE<='$CUR_DATE' and (END_DATE>='$CUR_DATE' or END_DATE='0000-00-00')";

 $query = "SELECT count(*) from WORK_PLAN where ".$RANGE_STR." and ".$DATE_STR;
 $cursor= exequery($connection,$query);
 $WORK_PLAN_COUNT=0;
 if($ROW=mysql_fetch_array($cursor))
    $WORK_PLAN_COUNT=$ROW[0];
    
 if($WORK_PLAN_COUNT==0)
   echo "·暂无工作计划";
 else
 {
 $PLAN_COUNT=0;
 //============================ 显示已发布工作计划 =======================================
 $query = "SELECT * from WORK_PLAN where ".$RANGE_STR." and ".$DATE_STR ." order by CREATE_DATE desc";
 $cursor= exequery($connection,$query);
 while($ROW=mysql_fetch_array($cursor))
 {
    $PLAN_COUNT++;
    if($PLAN_COUNT>$MAX_COUNT)
      break;

    $PLAN_ID=$ROW["PLAN_ID"];
    $NAME=$ROW["NAME"];
    $BEGIN_DATE=$ROW["BEGIN_DATE"];
    $END_DATE=$ROW["END_DATE"];
    $TYPE=$ROW["TYPE"];

    $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($END_DATE=="0000-00-00")
       $END_DATE="";
?>
      <?=$TYPE_DESC?>：<a href="javascript:plan_detail('<?=$PLAN_ID?>');"><?=$NAME?></a> (<?=$BEGIN_DATE?> - <?=$END_DATE?>)
      <?=$STATUS_DESC?><br>
<?
 }
}
?>
 </td>
</tr>
</table>
</div>