📄 list.php

📁 通达OA2007SE源代码非常好的
💻 PHP
📖 第 1 页 / 共 2 页
字号:
12 下一页
<?
  include_once 'inc/auth.php';
  include_once 'inc/utility_all.php';
  echo '<s';
  echo 'cript>
function show_reader(GROUP_ID,FLOW_ID,ANONYMITY)
{
 URL="query.php?GROUP_ID="+GROUP_ID+"&FLOW_ID=" + FLOW_ID+"&ANONYMITY="+ANONYMITY;
 myleft=(screen.availWidth-500)/2;
 window.open(URL,"read_vote","height=500,width=500,status=0,toolbar=no,menubar=no,location=no,scrollbars=yes,top=150,left="+myleft+",resizable=yes");
}
function show_static(GROUP_ID,FLOW_ID)
{
 URL="statics.php?';
  echo 'GROUP_ID="+GROUP_ID+"&FLOW_ID=" + FLOW_ID;
 myleft=(screen.availWidth-500)/2-100;
 window.open(URL,"read_vote","height=600,width=800,status=0,toolbar=no,menubar=no,location=no,scrollbars=yes,top=100,left="+myleft+",resizable=yes");
}
function show_reader1(GROUP_ID)
{
 URL="show_reader.php?GROUP_ID="+GROUP_ID;
 myleft=(screen.availWidth-500)/2;
 window.open(URL,"read_vote","height=500,wid';
  echo 'th=500,status=0,toolbar=no,menubar=no,location=no,scrollbars=yes,top=150,left="+myleft+",resizable=yes");
}
function delete_vote(FLOW_ID,CUR_PAGE)
{
 msg=\'确认要删除该考核任务？考核数据将被删除且不可恢复！！\';
 if(window.confirm(msg))
 {
  URL="delete.php?FLOW_ID=" + FLOW_ID + "&CUR_PAGE=" + CUR_PAGE;
  window.location=URL;
 }
}
function show_man(FLOW_ID,FLAG)
{
 URL="show_man.php?F';
  echo 'LOW_ID="+FLOW_ID+"&type="+FLAG;
 myleft=(screen.availWidth-500)/2;
 window.open(URL,"read_vote","height=500,width=500,status=0,toolbar=no,menubar=no,location=no,scrollbars=yes,top=150,left="+myleft+",resizable=yes");
}
</script>
<html>
<head>
<title>考核数据查询</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body class="bodycolor" topmargin="5">
';
  $CUR_DATE = date ('Y-m-d', time ());
  if (($FLOWTITLE != ''))
  {
    if (($WHERE_STR == ''))
    {
      ($WHERE_STR .= ((' where FLOW_TITLE like \'%'.$FLOWTITLE).'%\''));
    }
    else
    {
      ($WHERE_STR .= ((' and FLOW_TITLE like \'%'.$FLOWTITLE).'%\''));
    }
  }
  if (($SECRET_TO_ID != ''))
  {
    if (($WHERE_STR == ''))
    {
      $TEMP_ARRAY = explode (',', $SECRET_TO_ID);
      $ARRAY_COUNT = sizeof ($TEMP_ARRAY);
      if (($TEMP_ARRAY[($ARRAY_COUNT - 1)] == ''))
      {
        --$ARRAY_COUNT;
      }
      ($WHERE_STR .= (((''.' where (find_in_set(\'').$TEMP_ARRAY['0']).'\', PARTICIPANT)'));
      for ($I = 1; ($I < $ARRAY_COUNT); ++$I)
      {
        ($WHERE_STR .= (((''.' or find_in_set(\'').$TEMP_ARRAY[$I]).'\', PARTICIPANT)'));
      }
      ($WHERE_STR .= ')');
    }
    else
    {
      $TEMP_ARRAY = explode (',', $SECRET_TO_ID);
      $ARRAY_COUNT = sizeof ($TEMP_ARRAY);
      if (($TEMP_ARRAY[($ARRAY_COUNT - 1)] == ''))
      {
        --$ARRAY_COUNT;
      }
      ($WHERE_STR .= (((''.'  and (find_in_set(\'').$TEMP_ARRAY['0']).'\', PARTICIPANT)'));
      for ($I = 1; ($I < $ARRAY_COUNT); ++$I)
      {
        ($WHERE_STR .= (((''.' or find_in_set(\'').$TEMP_ARRAY[$I]).'\', PARTICIPANT)'));
      }
      ($WHERE_STR .= ')');
    }
  }
  if (($TO_ID != ''))
  {
    if (($WHERE_STR == ''))
    {
      $TEMP_ARRAY = explode (',', $TO_ID);
      $ARRAY_COUNT = sizeof ($TEMP_ARRAY);
      if (($TEMP_ARRAY[($ARRAY_COUNT - 1)] == ''))
      {
        --$ARRAY_COUNT;
      }
      ($WHERE_STR .= (((''.' where (find_in_set(\'').$TEMP_ARRAY['0']).'\', RANKMAN)'));
      for ($I = 1; ($I < $ARRAY_COUNT); ++$I)
      {
        ($WHERE_STR .= (((''.' or find_in_set(\'').$TEMP_ARRAY[$I]).'\', RANKMAN)'));
      }
      ($WHERE_STR .= ')');
    }
    else
    {
      $TEMP_ARRAY = explode (',', $TO_ID);
      $ARRAY_COUNT = sizeof ($TEMP_ARRAY);
      if (($TEMP_ARRAY[($ARRAY_COUNT - 1)] == ''))
      {
        --$ARRAY_COUNT;
      }
      ($WHERE_STR .= (((''.'  and (find_in_set(\'').$TEMP_ARRAY['0']).'\', RANKMAN)'));
      for ($I = 1; ($I < $ARRAY_COUNT); ++$I)
      {
        ($WHERE_STR .= (((''.' or find_in_set(\'').$TEMP_ARRAY[$I]).'\', RANKMAN)'));
      }
      ($WHERE_STR .= ')');
    }
  }
  if (($GROUP != ''))
  {
    if (($WHERE_STR == ''))
    {
      ($WHERE_STR .= (((''.' where GROUP_ID=\'').$GROUP).'\''));
    }
    else
    {
      ($WHERE_STR .= (((''.' and GROUP_ID=\'').$GROUP).'\''));
    }
  }
  if (($BEGIN_FROM_DATE != ''))
  {
    if (($WHERE_STR == ''))
    {
      ($WHERE_STR .= (((''.' where BEGIN_DATE>=\'').$BEGIN_FROM_DATE).'\''));
    }
    else
    {
      ($WHERE_STR .= (((''.' and BEGIN_DATE>=\'').$BEGIN_FROM_DATE).'\''));
    }
  }
  if (($BEGIN_TO_DATE != ''))
  {
    if (($WHERE_STR == ''))
    {
      ($WHERE_STR .= (((''.' where BEGIN_DATE<=\'').$BEGIN_TO_DATE).'\''));
    }
    else
    {
      ($WHERE_STR .= (((''.' and BEGIN_DATE<=\'').$BEGIN_TO_DATE).'\''));
    }
  }
  if (($END_FROM_DATE != ''))
  {
    if (($WHERE_STR == ''))
    {
      ($WHERE_STR .= (((''.' where END_DATE>=\'').$END_FROM_DATE).'\''));
    }
    else
    {
      ($WHERE_STR .= (((''.' and END_DATE>=\'').$END_FROM_DATE).'\''));
    }
  }
  if (($END_TO_DATE != ''))
  {
    if (($WHERE_STR == ''))
    {
      ($WHERE_STR .= (((''.' where END_DATE<=\'').$END_TO_DATE).'\''));
    }
    else
    {
      ($WHERE_STR .= (((''.' and END_DATE<=\'').$END_TO_DATE).'\''));
    }
  }
  if (($c1 == '2'))
  {
    if (($WHERE_STR == ''))
    {
      ($WHERE_STR .= (((''.' where END_DATE<=\'').$CUR_DATE).'\' and  END_DATE<>\'0000-00-00\''));
    }
    else
    {
      ($WHERE_STR .= (((''.' and END_DATE<=\'').$CUR_DATE).'\' and  END_DATE<>\'0000-00-00\''));
    }
  }
  $query = ('SELECT count(*) from SCORE_FLOW'.$WHERE_STR);
  $cursor = exequery ($connection, $query);
  $VOTE_COUNT = 0;
  if ($ROW = mysql_fetch_array ($cursor))
  {
    $VOTE_COUNT = $ROW[0];
  }
  if (($VOTE_COUNT == 0))
  {
    echo '<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
  <tr>
    <td class="Big"><img src="/images/menu/infofind.gif" WIDTH="25" HEIGHT="25" align="absmiddle">';
    echo '<s';
    echo 'pan class="big3">&nbsp;&nbsp;考核任务查询结果</span><br>
    </td>
  </tr>
</table>
<br>
';
    message ('', '无满足条件的考核任务');
    button_back ();
    exit ();
  }
  $PER_PAGE = 5;
  $PAGES = 10;
  $PAGE_COUNT = ceil (($VOTE_COUNT / $PER_PAGE));
  if ((($CUR_PAGE <= 0) OR ($CUR_PAGE == '')))
  {
    $CUR_PAGE = 1;
  }
  if (($PAGE_COUNT < $CUR_PAGE))
  {
    $CUR_PAGE = $PAGE_COUNT;
  }
  echo '
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
  <tr>
    <td class="Big"><img src="/images/menu/infofind.gif" WIDTH="25" HEIGHT="25" align="absmiddle">';
  echo '<s';
  echo 'pan class="big3">&nbsp;&nbsp;考核任务查询结果</span><br>
    </td>
    <td align="right" valign="bottom" class="small1">共';
  echo '<s';
  echo 'pan class="big4">&nbsp;';
  echo $VOTE_COUNT;
  echo '</span>&nbsp;条
    </td>
    <td align="right" valign="bottom" class="small1">
       <a class="A1" href="list.php?CUR_PAGE=1&FLOWTITLE=';
  echo $FLOWTITLE;
  echo '&SECRET_TO_ID=';
  echo $SECRET_TO_ID;
  echo '&TO_ID=';
  echo $TO_ID;
  echo '&GROUP=';
  echo $GROUP;
  echo '&BEGIN_FROM_DATE=';
  echo $BEGIN_FROM_DATE;
  echo '&BEGIN_TO_DATE=';
  echo $BEGIN_TO_DATE;
  echo '&END_FROM_DATE=';
  echo $END_FROM_DATE;
  echo '&END_TO_DATE=';
  echo $END_TO_DATE;
  echo '&c1=';
  echo $c1;
  echo '">首页</a>&nbsp;
       <a class="A1" href="list.php?CUR_PAGE=';
  echo $PAGE_COUNT;
  echo '&FLOWTITLE=';
  echo $FLOWTITLE;
  echo '&SECRET_TO_ID=';
  echo $SECRET_TO_ID;
  echo '&TO_ID=';
  echo $TO_ID;
  echo '&GROUP=';
  echo $GROUP;
  echo '&BEGIN_FROM_DATE=';
  echo $BEGIN_FROM_DATE;
  echo '&BEGIN_TO_DATE=';
  echo $BEGIN_TO_DATE;
  echo '&END_FROM_DATE=';
  echo $END_FROM_DATE;
  echo '&END_TO_DATE=';
  echo $END_TO_DATE;
  echo '&c1=';
  echo $c1;
  echo '">末页</a>&nbsp;&nbsp;
';
  if ((($CUR_PAGE % $PAGES) == 0))
  {
    $J = $PAGES;
  }
  else
  {
    $J = ($CUR_PAGE % $PAGES);
  }
  if (($PAGES < $CUR_PAGE))
  {
    echo '       <a class="A1" href="list.php?CUR_PAGE=';
    echo ((($CUR_PAGE - $J) - $PAGES) + 1);
    echo '&FLOWTITLE=';
    echo $FLOWTITLE;
    echo '&SECRET_TO_ID=';
    echo $SECRET_TO_ID;
    echo '&TO_ID=';
    echo $TO_ID;
    echo '&GROUP=';
    echo $GROUP;
    echo '&BEGIN_FROM_DATE=';
    echo $BEGIN_FROM_DATE;
    echo '&BEGIN_TO_DATE=';
    echo $BEGIN_TO_DATE;
    echo '&END_FROM_DATE=';
    echo $END_FROM_DATE;
    echo '&END_TO_DATE=';
    echo $END_TO_DATE;
    echo '&c1=';
    echo $c1;
12 下一页
⌨️ 快捷键说明

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