?? excel_list_view.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 = ' ';
}
$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 + -