待办事宜.php

来自「通达OA2007SE源代码 非常好的」· PHP 代码 · 共 368 行

<?
  echo '<!-------------------- 待办事宜 ----------------------->
';
  $USER_FUNC_ID_STR = $LOGIN_FUNC_STR;
  echo '<div id="module_';
  echo $MODULE_ID;
  echo '"  style="position: relative;padding-bottom:10px;">
<table border="0" cellspacing="1" width="100%" class="small" bgcolor="#000000" cellpadding="3">
 <tr class="TableControl" id="module_';
  echo $MODULE_ID;
  echo '_edit" style="display:none;">
   <td colspan="2" align="right">
     <div id="module_';
  echo $MODULE_ID;
  echo '_info" style="float:left;"></div>
     显示条数：<input type="input" size="3" class="SmallInput" value="';
  echo $_COOKIE[((($LOGIN_USER_ID.'_my_').$MODULE_ID).'_nums')];
  echo '" name="MODULE_NUM_';
  echo $MODULE_ID;
  echo '">&nbsp;
     <a href="javascript:SetNums(\'';
  echo $MODULE_ID;
  echo '\');" title="保存设置">设置</a>
     <a href="javascript:_edit(\'';
  echo $MODULE_ID;
  echo '\');" 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) OR (1000 <= $MAX_COUNT)))
  {
    $MAX_COUNT = 10;
  }
  $CUR_DATE = date ('Y-m-d', time ());
  $CUR_TIME = date ('Y-m-d H:i:s', time ());
  if (find_id ($USER_FUNC_ID_STR, '7'))
  {
    if (($MAX_COUNT < $FLOW_COUNT))
    {
      break;
    }
    $query1 = (((''.'select DUTY_TYPE from USER where USER_ID=\'').$LOGIN_USER_ID).'\'');
    $cursor1 = exequery ($connection, $query1);
    if ($ROW = mysql_fetch_array ($cursor1))
    {
      $DUTY_TYPE = $ROW['DUTY_TYPE'];
    }
    $query = ((''.'SELECT * from ATTEND_CONFIG where DUTY_TYPE=').$DUTY_TYPE);
    $cursor = exequery ($connection, $query);
    if ($ROW = mysql_fetch_array ($cursor))
    {
      $DUTY_TIME1 = $ROW['DUTY_TIME1'];
      $DUTY_TIME2 = $ROW['DUTY_TIME2'];
      $DUTY_TIME3 = $ROW['DUTY_TIME3'];
      $DUTY_TIME4 = $ROW['DUTY_TIME4'];
      $DUTY_TIME5 = $ROW['DUTY_TIME5'];
      $DUTY_TIME6 = $ROW['DUTY_TIME6'];
      $DUTY_TYPE1 = $ROW['DUTY_TYPE1'];
      $DUTY_TYPE2 = $ROW['DUTY_TYPE2'];
      $DUTY_TYPE3 = $ROW['DUTY_TYPE3'];
      $DUTY_TYPE4 = $ROW['DUTY_TYPE4'];
      $DUTY_TYPE5 = $ROW['DUTY_TYPE5'];
      $DUTY_TYPE6 = $ROW['DUTY_TYPE6'];
    }
    $query = 'SELECT * from SYS_PARA where PARA_NAME=\'DUTY_INTERVAL_BEFORE1\'';
    $cursor = exequery ($connection, $query);
    if ($ROW = mysql_fetch_array ($cursor))
    {
      $DUTY_INTERVAL_BEFORE1 = $ROW['PARA_VALUE'];
    }
    $query = 'SELECT * from SYS_PARA where PARA_NAME=\'DUTY_INTERVAL_AFTER1\'';
    $cursor = exequery ($connection, $query);
    if ($ROW = mysql_fetch_array ($cursor))
    {
      $DUTY_INTERVAL_AFTER1 = $ROW['PARA_VALUE'];
    }
    $query = 'SELECT * from SYS_PARA where PARA_NAME=\'DUTY_INTERVAL_BEFORE2\'';
    $cursor = exequery ($connection, $query);
    if ($ROW = mysql_fetch_array ($cursor))
    {
      $DUTY_INTERVAL_BEFORE2 = $ROW['PARA_VALUE'];
    }
    $query = 'SELECT * from SYS_PARA where PARA_NAME=\'DUTY_INTERVAL_AFTER2\'';
    $cursor = exequery ($connection, $query);
    if ($ROW = mysql_fetch_array ($cursor))
    {
      $DUTY_INTERVAL_AFTER2 = $ROW['PARA_VALUE'];
    }
    $REGISTER_TIME1 = (($CUR_DATE.' ').$DUTY_TIME1);
    $REGISTER_TIME2 = (($CUR_DATE.' ').$DUTY_TIME2);
    $REGISTER_TIME3 = (($CUR_DATE.' ').$DUTY_TIME3);
    $REGISTER_TIME4 = (($CUR_DATE.' ').$DUTY_TIME4);
    $REGISTER_TIME5 = (($CUR_DATE.' ').$DUTY_TIME5);
    $REGISTER_TIME6 = (($CUR_DATE.' ').$DUTY_TIME6);
    $DUTY_INTERVAL_BEFORE11 = ('DUTY_INTERVAL_BEFORE'.$DUTY_TYPE1);
    $DUTY_INTERVAL_AFTER11 = ('DUTY_INTERVAL_AFTER'.$DUTY_TYPE1);
    $DUTY_INTERVAL_BEFORE22 = ('DUTY_INTERVAL_BEFORE'.$DUTY_TYPE2);
    $DUTY_INTERVAL_AFTER22 = ('DUTY_INTERVAL_AFTER'.$DUTY_TYPE2);
    $DUTY_INTERVAL_BEFORE33 = ('DUTY_INTERVAL_BEFORE'.$DUTY_TYPE3);
    $DUTY_INTERVAL_AFTER33 = ('DUTY_INTERVAL_AFTER'.$DUTY_TYPE3);
    $DUTY_INTERVAL_BEFORE44 = ('DUTY_INTERVAL_BEFORE'.$DUTY_TYPE4);
    $DUTY_INTERVAL_AFTER44 = ('DUTY_INTERVAL_AFTER'.$DUTY_TYPE4);
    $DUTY_INTERVAL_BEFORE55 = ('DUTY_INTERVAL_BEFORE'.$DUTY_TYPE5);
    $DUTY_INTERVAL_AFTER55 = ('DUTY_INTERVAL_AFTER'.$DUTY_TYPE5);
    $DUTY_INTERVAL_BEFORE66 = ('DUTY_INTERVAL_BEFORE'.$DUTY_TYPE6);
    $DUTY_INTERVAL_AFTER66 = ('DUTY_INTERVAL_AFTER'.$DUTY_TYPE6);
    if (((((((((strtotime ($REGISTER_TIME1) - strtotime ($CUR_TIME)) <= ($$DUTY_INTERVAL_BEFORE11 * 60)) AND ((strtotime ($CUR_TIME) - strtotime ($REGISTER_TIME1)) <= ($$DUTY_INTERVAL_AFTER11 * 60))) OR (((strtotime ($REGISTER_TIME2) - strtotime ($CUR_TIME)) <= ($$DUTY_INTERVAL_BEFORE22 * 60)) AND ((strtotime ($CUR_TIME) - strtotime ($REGISTER_TIME2)) <= ($$DUTY_INTERVAL_AFTER22 * 60)))) OR (((strtotime ($REGISTER_TIME3) - strtotime ($CUR_TIME)) <= ($$DUTY_INTERVAL_BEFORE33 * 60)) AND ((strtotime ($CUR_TIME) - strtotime ($REGISTER_TIME3)) <= ($$DUTY_INTERVAL_AFTER33 * 60)))) OR (((strtotime ($REGISTER_TIME4) - strtotime ($CUR_TIME)) <= ($$DUTY_INTERVAL_BEFORE44 * 60)) AND ((strtotime ($CUR_TIME) - strtotime ($REGISTER_TIME4)) <= ($$DUTY_INTERVAL_AFTER44 * 60)))) OR (((strtotime ($REGISTER_TIME5) - strtotime ($CUR_TIME)) <= ($$DUTY_INTERVAL_BEFORE55 * 60)) AND ((strtotime ($CUR_TIME) - strtotime ($REGISTER_TIME5)) <= ($$DUTY_INTERVAL_AFTER55 * 60)))) OR (((strtotime ($REGISTER_TIME6) - strtotime ($CUR_TIME)) <= ($$DUTY_INTERVAL_BEFORE66 * 60)) AND ((strtotime ($CUR_TIME) - strtotime ($REGISTER_TIME6)) <= ($$DUTY_INTERVAL_AFTER66 * 60)))))
    {
      ++$FLOW_COUNT;
      echo '个人考勤：<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=\'0\' and LEADER_ID=\'').$LOGIN_USER_ID).'\' order by EVECTION_DATE1 limit 0,').$MAX_COUNT);
    $cursor = exequery ($connection, $query);
    while ($ROW = mysql_fetch_array ($cursor))
    {
      ++$FLOW_COUNT;
      if (($MAX_COUNT < $FLOW_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);
      echo '
出差审批：<a href="/general/attendance/manage/confirm/">';
      echo $EVECTION_DEST;
      echo '</a> (';
      echo $EVECTION_DATE1;
      echo ' 至 ';
      echo $EVECTION_DATE2;
      echo ')<br>
';
    }
    $query = ((((''.'SELECT * from ATTEND_EVECTION where STATUS=\'1\' and ALLOW=\'1\' and USER_ID=\'').$LOGIN_USER_ID).'\' order by EVECTION_DATE1 limit 0,').$MAX_COUNT);
    $cursor = exequery ($connection, $query);
    while ($ROW = mysql_fetch_array ($cursor))
    {
      ++$FLOW_COUNT;
      if (($MAX_COUNT < $FLOW_COUNT))
      {
        break;
      }
      echo '
个人考勤：<a href="/general/attendance/personal/evection/">出差归来</a><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 limit 0,').$MAX_COUNT);
    $cursor = exequery ($connection, $query);
    while ($ROW = mysql_fetch_array ($cursor))
    {
      ++$FLOW_COUNT;
      if (($MAX_COUNT < $FLOW_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);
      echo '
个人考勤：<a href="/general/attendance/personal/out/">外出归来</a><br>
';
    }
  }
  if (find_id ($USER_FUNC_ID_STR, '26'))
  {
    $query = ((((((''.'SELECT USER_NAME 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\' limit 0,').$MAX_COUNT);
    $cursor = exequery ($connection, $query);
    while ($ROW = mysql_fetch_array ($cursor))
    {
      ++$FLOW_COUNT;
      if (($MAX_COUNT < $FLOW_COUNT))
      {
        break;
      }
      $USER_NAME = $ROW['USER_NAME'];
      echo '
考勤管理：<a href="/general/attendance/manage">批示';
      echo $USER_NAME;
      echo '的外出申请</a><br>
';
    }
    $query = ((((''.'SELECT USER_NAME,ALLOW 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\') limit 0,').$MAX_COUNT);
    $cursor = exequery ($connection, $query);
    while ($ROW = mysql_fetch_array ($cursor))
    {
      ++$FLOW_COUNT;
      if (($MAX_COUNT < $FLOW_COUNT))
      {
        break;
      }
      $USER_NAME = $ROW['USER_NAME'];
      $ALLOW = $ROW['ALLOW'];
      if (($ALLOW == '0'))
      {
        $ALLOW = (('批示'.$USER_NAME).'的请假申请');
      }
      else
      {
        $ALLOW = (('批示'.$USER_NAME).'的销假申请');
      }
      echo '
考勤管理：<a href="/general/attendance/manage">';
      echo $ALLOW;
      echo '</a><br>
';
    }
    $query = ((((''.'SELECT * from ATTEND_LEAVE where USER_ID=\'').$LOGIN_USER_ID).'\' and status=\'1\' and ALLOW=\'1\' limit 0,').$MAX_COUNT);
    $cursor = exequery ($connection, $query);
    while ($ROW = mysql_fetch_array ($cursor))
    {
      ++$FLOW_COUNT;
      if (($MAX_COUNT < $FLOW_COUNT))
      {
        break;
      }
      echo '
个人考勤：<a href="/general/attendance/personal/leave/">申请销假</a><br>
';
    }
  }
  if (find_id ($USER_FUNC_ID_STR, '28'))
  {
    $query = ((((((''.'SELECT FLOW_ID,CONTENT 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 limit 0,').$MAX_COUNT);
    $cursor = exequery ($connection, $query);
    while ($ROW = mysql_fetch_array ($cursor))
    {
      ++$FLOW_COUNT;
      if (($MAX_COUNT < $FLOW_COUNT))
      {
        break;
      }
      $FLOW_ID = $ROW['FLOW_ID'];
      $CONTENT = $ROW['CONTENT'];
      echo '
工资上报：<a href="/general/salary/submit/">';
      echo $CONTENT;
      echo '</a><br>
';
    }
  }
  $query = ((((''.'SELECT FLOW_RUN_PRCS.PRCS_ID,FLOW_RUN.RUN_ID,FLOW_RUN.FLOW_ID,PRCS_FLAG,FLOW_PRCS,FLOW_NAME,RUN_NAME 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 limit 0,').$MAX_COUNT);
  $cursor = exequery ($connection, $query);
  while ($ROW = mysql_fetch_array ($cursor))
  {
    ++$FLOW_COUNT;
    if (($MAX_COUNT < $FLOW_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'];
    $FLOW_NAME = $ROW['FLOW_NAME'];
    $RUN_NAME = $ROW['RUN_NAME'];
    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\'>';
      }
    }
    echo '
工作流：';
    echo $STATUS;
    if (($PRCS_FLAG != '3'))
    {
      echo '     <a href="/general/workflow/list/input_form?RUN_ID=';
      echo $RUN_ID;
      echo '&FLOW_ID=';
      echo $FLOW_ID;
      echo '&PRCS_ID=';
      echo $PRCS_ID;
      echo '&FLOW_PRCS=';
      echo $FLOW_PRCS;
      echo '">';
      echo $FLOW_NAME;
      echo ' - ';
      echo $RUN_NAME;
      echo '</a><br>
';
      continue;
    }
    else
    {
      echo '     <a href="/general/workflow/list/print?RUN_ID=';
      echo $RUN_ID;
      echo '&FLOW_ID=';
      echo $FLOW_ID;
      echo '" target="_blank">';
      echo $FLOW_NAME;
      echo ' - ';
      echo $RUN_NAME;
      echo '</a><br>
';
      continue;
    }
  }
  if (($FLOW_COUNT == 0))
  {
    echo '·暂无待办事宜';
  }
  if (($MAX_COUNT < $FLOW_COUNT))
  {
    $FLOW_COUNT = $MAX_COUNT;
  }
  echo ' </td>
</tr>
<thead>
 <td id="module_';
  echo $MODULE_ID;
  echo '_head" class="TableHeader" width="58%"><img src="/images/menu/workflow.gif" WIDTH="18" HEIGHT="18" align="absmiddle"> 待办事宜</td>
 <td class="TableControl" id="module_';
  echo $MODULE_ID;
  echo '_more" align="center">
 <div id="module_';
  echo $MODULE_ID;
  echo '_op" style="float:left;display:none;"><a href="javascript:_edit(\'';
  echo $MODULE_ID;
  echo '\');"><img border="0" src="/images/edit.gif" alt="设置显示条数"></a>';
  if (($VIEW_TYPE != '2'))
  {
    echo '<a id="module_';
    echo $MODULE_ID;
    echo '_url" href="#" onclick="_del(\'';
    echo $MODULE_ID;
    echo '\');"><img border="0" src="/images/x.gif" alt="不显示该模块"></a>';
  }
  echo '</div>
 <div style="float:right">共 ';
  echo '<s';
  echo 'pan class="big4" id="FLOW_COUNT">';
  echo $FLOW_COUNT;
  echo '</span>&nbsp;项</div>
 </td>
</thead>
</table>
</div>
';
?>