📄 vote_data.php

📁 通达OA2007SE源代码非常好的
💻 PHP
字号:
<?
  function parseitemname ($ITEM_NAME, $ITEM_ID, $COUNT = 1)
  {
    $POS = strpos ($ITEM_NAME, '{');
    if (($POS === false))
    {
      return $ITEM_NAME;
    }
    if ((substr ($ITEM_NAME, $POS, 6) == '{text}'))
    {
      return ((((((substr ($ITEM_NAME, 0, $POS).'<a href="#INPUT_ITEM_').$ITEM_ID).'_').$COUNT++).'" style="text-decoration: underline;">？？？</a>').parseitemname (substr ($ITEM_NAME, ($POS + 6)), $ITEM_ID, $COUNT));
    }
    if ((substr ($ITEM_NAME, $POS, 8) == '{number}'))
    {
      return ((((((substr ($ITEM_NAME, 0, $POS).'<a href="#INPUT_ITEM_').$ITEM_ID).'_').$COUNT++).'" style="text-decoration: underline;">？？？</a>').parseitemname (substr ($ITEM_NAME, ($POS + 8)), $ITEM_ID, $COUNT));
    }
    if ((substr ($ITEM_NAME, $POS, 10) == '{textarea}'))
    {
      return ((((((substr ($ITEM_NAME, 0, $POS).'<a href="#INPUT_ITEM_').$ITEM_ID).'_').$COUNT++).'" style="text-decoration: underline;">？？？</a>').parseitemname (substr ($ITEM_NAME, ($POS + 10)), $ITEM_ID, $COUNT));
    }
    return (substr ($ITEM_NAME, 0, ($POS + 1)).parseitemname (substr ($ITEM_NAME, ($POS + 1)), $ITEM_ID));
  }
  function parseitemname2 ($ITEM_NAME, &$ARRAY)
  {
    $POS = strpos ($ITEM_NAME, '{');
    if (($POS === false))
    {
      return null;
    }
    if ((substr ($ITEM_NAME, $POS, 6) == '{text}'))
    {
      $ARRAY[count ($ARRAY)] = 'text';
      parseitemname2 (substr ($ITEM_NAME, ($POS + 6)), &$ARRAY);
    }
    else
    {
      if ((substr ($ITEM_NAME, $POS, 8) == '{number}'))
      {
        $ARRAY[count ($ARRAY)] = 'number';
        parseitemname2 (substr ($ITEM_NAME, ($POS + 8)), &$ARRAY);
      }
      else
      {
        if ((substr ($ITEM_NAME, $POS, 10) == '{textarea}'))
        {
          $ARRAY[count ($ARRAY)] = 'textarea';
          parseitemname2 (substr ($ITEM_NAME, ($POS + 10)), &$ARRAY);
        }
        else
        {
          parseitemname2 (substr ($ITEM_NAME, ($POS + 1)), &$ARRAY);
        }
      }
    }
  }
  include_once 'inc/auth.php';
  echo '<html>
<head>
<title>投票数据</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body class="bodycolor" topmargin="5">
';
  $query = ((''.'SELECT SUBJECT,PARENT_ID from VOTE_TITLE where VOTE_ID=').$VOTE_ID);
  $cursor2 = exequery ($connection, $query);
  if ($ROW2 = mysql_fetch_array ($cursor2))
  {
    $SUBJECT = $ROW2['SUBJECT'];
    $PARENT_ID = $ROW2['PARENT_ID'];
    $query = ((''.'SELECT ANONYMITY from VOTE_TITLE where VOTE_ID=').$PARENT_ID);
    $cursor2 = exequery ($connection, $query);
    if ($ROW2 = mysql_fetch_array ($cursor2))
    {
      $ANONYMITY = $ROW2['ANONYMITY'];
    }
  }
  echo '<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
  <tr>
    <td class="Big3" align="center">';
  echo $SUBJECT;
  echo '</td>
    </td>
  </tr>
</table>
  <table border="0" width="100%" cellpadding="3" cellspacing="1" bgcolor="#000000" class="small" align="center">
';
  $query = ((''.'SELECT * from VOTE_ITEM where VOTE_ID=').$VOTE_ID);
  $cursor2 = exequery ($connection, $query);
  while ($ROW2 = mysql_fetch_array ($cursor2))
  {
    $ITEM_ID = $ROW2['ITEM_ID'];
    $ITEM_NAME = $ROW2['ITEM_NAME'];
    if (((!strstr ($ITEM_NAME, '{text}') AND !strstr ($ITEM_NAME, '{number}')) AND !strstr ($ITEM_NAME, '{textarea}')))
    {
      continue;
    }
    else
    {
      $ARRAY = array ();
      parseitemname2 ($ITEM_NAME, &$ARRAY);
      $ITEM_NAME = parseitemname ($ITEM_NAME, $ITEM_ID);
      echo '    <tr class="TableHeader">
      <td colspan="2">
        ';
      echo $ITEM_NAME;
      echo '      </td>
    </tr>
    <tr class="TableData">
      <td>
';
      for ($I = 0; ($I < count ($ARRAY)); ++$I)
      {
        echo '        <a name="INPUT_ITEM_';
        echo $ITEM_ID;
        echo '_';
        echo ($I + 1);
        echo '"><b>【输入项';
        echo ($I + 1);
        echo '】：</b></a><br>
';
        if (($ARRAY[$I] == 'number'))
        {
          $query = (((((''.'SELECT FIELD_DATA,count(*) from VOTE_DATA where ITEM_ID=\'').$ITEM_ID).'\' and FIELD_NAME=\'').($I + 1)).'\' group by FIELD_DATA');
          $cursor1 = exequery ($connection, $query);
          while ($ROW1 = mysql_fetch_array ($cursor1))
          {
            echo (((('<li>'.$ROW1[0]).'(').$ROW1[1]).'票)</li><br>');
          }
          echo (('【输入项'.($I + 1)).'详细信息】：<br>');
        }
        $query = (((((''.'SELECT * from VOTE_DATA where ITEM_ID=\'').$ITEM_ID).'\' and FIELD_NAME=\'').($I + 1)).'\'');
        $cursor1 = exequery ($connection, $query);
        while ($ROW1 = mysql_fetch_array ($cursor1))
        {
          $USER_ID = $ROW1['USER_ID'];
          $FIELD_DATA = $ROW1['FIELD_DATA'];
          if (($USER_ID != ''))
          {
            $query = (((''.'SELECT * from USER where USER_ID=\'').$USER_ID).'\'');
            $cursor = exequery ($connection, $query);
            if ($ROW = mysql_fetch_array ($cursor))
            {
              $USER_ID = (('【'.$ROW['USER_NAME']).'】');
            }
          }
          echo '       <li>';
          echo $USER_ID;
          echo $FIELD_DATA;
          echo '</li><br>
';
        }
      }
      echo '      </td>
    </tr>
';
      continue;
    }
  }
  echo '    <tr align="center" class="TableControl">
      <td colspan="2">
        <input type="button" value="关闭" class="BigButton" onClick="javascript:window.close();">
      </td>
    </tr>
  </table>
</body>
</html>';
?>
⌨️ 快捷键说明

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