⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 excel_list_view.php

📁 极限网络智能办公系统 Office Automation V3.0官方100％源代码.
💻 PHP
字号:
🔍 
<?
  include_once 'inc/auth.php';
  include_once 'inc/utility_html.php';
  $LIST_VIEW_STR = urldecode ($LIST_VIEW_STR);
  $ITEM_NAME = strtok ($LIST_VIEW_STR, '~');
  $ITEM_ID = strtok ('~');
  $LV_TITLE = strtok ('~');
  $EXCEL_NAME = '鍒楄〃椤癸細' . $ITEM_NAME . ' - 鏁版嵁鎶ヨ〃';
  $LETTER_STR = '\\,/,:,*,?,",<,>,|';
  $MY_ARRAY = explode (',', $LETTER_STR);
  $ARRAY_COUNT = sizeof ($MY_ARRAY);
  if ($MY_ARRAY[$ARRAY_COUNT - 1] == '')
  {
    --$ARRAY_COUNT;
  }

  for ($I = 0; $I < $ARRAY_COUNT; ++$I)
  {
    $EXCEL_NAME = str_replace ($MY_ARRAY[$I], '', $EXCEL_NAME);
  }

  ob_end_clean ();
  header ('Cache-control: private');
  header ('Content-type: application/vnd.ms-excel');
  header ('' . 'Content-Disposition: attachment; filename= ' . $EXCEL_NAME . '.xls');
  echo '
<html xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns="http://www.w3.org/TR/REC-html40">
<head>
<title></title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body topmargin="5">

<table border="1" cellspacing="1" width="95%" class="small" cellpadding="3">
   <tr style="BACKGROUND: #D3E5FA; color: #000000; f';
  echo 'ont-weight: bold;">
';
  $MY_ARRAY = explode ('`', $LV_TITLE);
  $ARRAY_COUNT_TITLE = sizeof ($MY_ARRAY);
  if ($MY_ARRAY[$ARRAY_COUNT_TITLE - 1] == '')
  {
    --$ARRAY_COUNT_TITLE;
  }

  for ($K = 0; $K < $ARRAY_COUNT_TITLE; ++$K)
  {
    echo '  <TD>';
    echo $MY_ARRAY[$K];
    echo '</TD>
';
  }

  echo ' </tr>

';
  $RUN_ARRAY = explode (',', $RUN_ID_STR);
  $RUN_ARRAY_COUNT = sizeof ($RUN_ARRAY);
  if ($RUN_ARRAY[$RUN_ARRAY_COUNT - 1] == '')
  {
    --$RUN_ARRAY_COUNT;
  }

  for ($I = 0; $I < $RUN_ARRAY_COUNT; ++$I)
  {
    $query = '' . 'SELECT * from FLOW_RUN_DATA where RUN_ID=\'' . $RUN_ARRAY[$I] . '\' and ITEM_ID=\'' . $ITEM_ID . '\'';
    $cursor = exequery ($connection, $query);
    if ($ROW = mysql_fetch_array ($cursor))
    {
      $ITEM_DATA = $ROW['ITEM_DATA'];
    }
    else
    {
      $ITEM_DATA = '';
    }

    if ($ITEM_DATA == '')
    {
      continue;
    }
    else
    {
      $MY_ARRAY = explode ('
', $ITEM_DATA);
      $ARRAY_COUNT = sizeof ($MY_ARRAY);
      if ($MY_ARRAY[$ARRAY_COUNT - 1] == '')
      {
        --$ARRAY_COUNT;
      }

      $ITEM_VALUE = '';
      for ($K = 0; $K < $ARRAY_COUNT; ++$K)
      {
        $ITEM_VALUE .= '<tr>
';
        $TR_DATA = $MY_ARRAY[$K];
        $MY_ARRAY1 = explode ('`', $TR_DATA);
        for ($L = 0; $L < $ARRAY_COUNT_TITLE; ++$L)
        {
          $TD_DATA = $MY_ARRAY1[$L];
          if ($TD_DATA == '')
          {
            $TD_DATA = '&nbsp;';
          }

          $ITEM_VALUE .= '<td>' . $TD_DATA . '</td>
';
        }

        $ITEM_VALUE .= '</tr>
';
      }

      echo $ITEM_VALUE;
      continue;
    }
  }

  echo '
</table>';
?>

⌨️ 快捷键说明

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