📄 待办事宜.php

📁 极限网络智能办公系统 Office Automation V3.0官方100％源代码.
💻 PHP
字号:
<!-------------------- 待办事宜 ----------------------->

<?
 $USER_FUNC_ID_STR=$LOGIN_FUNC_STR;
?>
<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" 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/workflow.jpg) no-repeat bottom right">
    <td colspan=2 height="60">
<?
 $FLOW_COUNT=0;
 $MAX_COUNT=intVal($_COOKIE[$LOGIN_USER_ID."_my_".$MODULE_ID."_nums"]);
 if($MAX_COUNT<=0 || $MAX_COUNT>=1000)
    $MAX_COUNT=10;
 $CUR_DATE=date("Y-m-d",time());
 //------------------------------------------ 个人考勤 --------------------------------------------
 if(find_id($USER_FUNC_ID_STR,"7"))
 {
   $FLOW_COUNT++;
   if($FLOW_COUNT>$MAX_COUNT)
      break;
?>

个人考勤：<a href="/general/attendance/personal">上下班登记</a><br>

<?
 }

 //------------------------------------------ 出差 --------------------------------------------
 if(find_id($USER_FUNC_ID_STR,"7"))
 {
   $query = "SELECT * from ATTEND_EVECTION where STATUS='1' and ALLOW='1' and USER_ID='$LOGIN_USER_ID' order by EVECTION_DATE1";
   $cursor= exequery($connection,$query);
   while($ROW=mysql_fetch_array($cursor))
   {
      $FLOW_COUNT++;
      if($FLOW_COUNT>$MAX_COUNT)
         break;
      $EVECTION_ID=$ROW["EVECTION_ID"];
      $EVECTION_DATE1=$ROW["EVECTION_DATE1"];
      $EVECTION_DATE2=$ROW["EVECTION_DATE2"];
      $EVECTION_DEST=$ROW["EVECTION_DEST"];
      $EVECTION_DATE1=strtok($EVECTION_DATE1," ");
      $EVECTION_DATE2=strtok($EVECTION_DATE2," ");
      $EVECTION_DEST=htmlspecialchars($EVECTION_DEST);
?>

出差：<a href="/general/attendance/personal/evection/"><?=$EVECTION_DEST?></a> (<?=$EVECTION_DATE1?> 至 <?=$EVECTION_DATE2?>)<br>

<?
   }
 }

 //------------------------------------------ 外出 --------------------------------------------
 if(find_id($USER_FUNC_ID_STR,"7"))
 {
   $query = "SELECT * from ATTEND_OUT where STATUS='0' and ALLOW='1' and USER_ID='$LOGIN_USER_ID' order by SUBMIT_TIME";
   $cursor= exequery($connection,$query);
   while($ROW=mysql_fetch_array($cursor))
   {
      $FLOW_COUNT++;
      if($FLOW_COUNT>$MAX_COUNT)
         break;
      $SUBMIT_TIME=$ROW["SUBMIT_TIME"];
      $OUT_TIME1=$ROW["OUT_TIME1"];
      $OUT_TIME2=$ROW["OUT_TIME2"];
      $OUT_TYPE=$ROW["OUT_TYPE"];
      $SUBMIT_TIME=strtok($SUBMIT_TIME," ");
      $OUT_TYPE=htmlspecialchars($OUT_TYPE);
?>

外出：<a href="/general/attendance/personal/out/"><?=$OUT_TYPE?></a> (<?if($SUBMIT_TIME!=$CUR_DATE) echo $SUBMIT_TIME." ";?><?=$OUT_TIME1?> - <?=$OUT_TIME2?>)<br>

<?
   }
 }

 //----------------------------------------- 今日外出、请假批示 ----------------------------------------
 if(find_id($USER_FUNC_ID_STR,"26"))
 {
   $query = "SELECT * from ATTEND_OUT,USER where ATTEND_OUT.USER_ID=USER.USER_ID and LEADER_ID='$LOGIN_USER_ID' and to_days(SUBMIT_TIME)=to_days('$CUR_DATE') and ALLOW='0'";
   $cursor= exequery($connection,$query);

   while($ROW=mysql_fetch_array($cursor))
   {
      $FLOW_COUNT++;
      if($FLOW_COUNT>$MAX_COUNT)
         break;

      $USER_NAME=$ROW["USER_NAME"];
?>

考勤管理：<a href="/general/attendance/manage">批示<?=$USER_NAME?>的外出申请</a><br>

<?
   }

   $query = "SELECT * from ATTEND_LEAVE,USER where ATTEND_LEAVE.USER_ID=USER.USER_ID and LEADER_ID='$LOGIN_USER_ID' and status='1' and allow in('0','3')";
   $cursor= exequery($connection,$query);
   while($ROW=mysql_fetch_array($cursor))
   {
      $FLOW_COUNT++;
      if($FLOW_COUNT>$MAX_COUNT)
         break;

      $USER_NAME=$ROW["USER_NAME"];
      $ALLOW=$ROW["ALLOW"];

      if($ALLOW=="0")
         $ALLOW="批示".$USER_NAME."的请假申请";
      else
         $ALLOW="批示".$USER_NAME."的销假申请";
?>

考勤管理：<a href="/general/attendance/manage"><?=$ALLOW?></a><br>

<?
   }
 }

 //------------------------------------------ 工资上报 --------------------------------------------
 if(find_id($USER_FUNC_ID_STR,"28"))
 {
   $query = "SELECT * from SAL_FLOW where to_days(BEGIN_DATE)<=to_days('$CUR_DATE') and to_days(END_DATE)>=to_days('$CUR_DATE') order by BEGIN_DATE desc";
   $cursor= exequery($connection,$query);
   while($ROW=mysql_fetch_array($cursor))
   {
      $FLOW_COUNT++;
      if($FLOW_COUNT>$MAX_COUNT)
         break;

      $FLOW_ID=$ROW["FLOW_ID"];
      $CONTENT=$ROW["CONTENT"];
?>

工资上报：<a href="/general/salary/submit/"><?=$CONTENT?></a><br>

<?
   }
 }

 //------------------------------------------ 工作流 ------------------------------------------
 $query = "SELECT * from FLOW_RUN_PRCS,FLOW_RUN,FLOW_TYPE WHERE FLOW_RUN_PRCS.RUN_ID=FLOW_RUN.RUN_ID and FLOW_RUN.FLOW_ID=FLOW_TYPE.FLOW_ID and USER_ID='$LOGIN_USER_ID' and prcs_flag<>'4' order by FLOW_RUN_PRCS.PRCS_FLAG,PRCS_TIME desc";
 $cursor = exequery($connection,$query);

 while($ROW=mysql_fetch_array($cursor))
 {
    $FLOW_COUNT++;
    if($FLOW_COUNT>$MAX_COUNT)
       break;

    $PRCS_ID = $ROW["PRCS_ID"];
    $RUN_ID = $ROW["RUN_ID"];
    $FLOW_ID = $ROW["FLOW_ID"];
    $PRCS_FLAG = $ROW["PRCS_FLAG"];
    $FLOW_PRCS = $ROW["FLOW_PRCS"];

    if($PRCS_FLAG=="1")
       $STATUS="<img src='/images/email_close.gif' alt='未接收' align='absmiddle'>";
    else if($PRCS_FLAG=="2")
       $STATUS="<img src='/images/email_open.gif' alt='已接收' align='absmiddle'>";
    else
       $STATUS="<img src='/images/flow_next.gif' alt='已办结' align='absmiddle'>";

    $query = "SELECT * from FLOW_RUN WHERE RUN_ID=$RUN_ID";
    $cursor1= exequery($connection,$query);
    if($ROW=mysql_fetch_array($cursor1))
    {
       $FLOW_ID=$ROW["FLOW_ID"];
       $RUN_NAME=$ROW["RUN_NAME"];
    }

    $query = "SELECT * from FLOW_TYPE WHERE FLOW_ID=$FLOW_ID";
    $cursor1= exequery($connection,$query);
    if($ROW=mysql_fetch_array($cursor1))
       $FLOW_NAME=$ROW["FLOW_NAME"];
?>

工作流：<?=$STATUS?>
<?
    if($PRCS_FLAG!="3")
    {
?>
     <a href="/general/workflow/list/input_form?RUN_ID=<?=$RUN_ID?>&FLOW_ID=<?=$FLOW_ID?>&PRCS_ID=<?=$PRCS_ID?>&FLOW_PRCS=<?=$FLOW_PRCS?>"><?=$FLOW_NAME?> - <?=$RUN_NAME?></a><br>
<?
    }
    else
    {
?>
     <a href="/general/workflow/list/"><?=$FLOW_NAME?> - <?=$RUN_NAME?></a><br>
<?
    }
 }

 if($FLOW_COUNT==0)
 {
 	echo "无待办事宜";
 }

 if($FLOW_COUNT>$MAX_COUNT)
    $FLOW_COUNT=$MAX_COUNT;
?>
 </td>
</tr>
<thead>
 <td id="module_<?=$MODULE_ID?>_head" class="TableHeader" width="58%"><img src="/images/menu/workflow.gif" WIDTH="18" HEIGHT="18" align="absmiddle"> 待办事宜</td>
 <td class="TableControl" id="module_<?=$MODULE_ID?>_more" align="center">
 <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">共 <span class="big4" id="FLOW_COUNT"><?=$FLOW_COUNT?></span>&nbsp;项</div>
 </td>
</thead>
</table>
</div>
⌨️ 快捷键说明

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