📄 export.php

📁 极限网络智能办公系统 Office Automation V3.0官方100％源代码.

💻 PHP

字号:

<?
include_once("inc/auth.php");
include_once("inc/utility_all.php");

 ob_end_clean();
 Header("Cache-control: private");
 Header("Content-type: application/vnd.ms-excel");
 Header("Content-Disposition: attachment; filename= $LOGIN_USER_ID.xls");
?>

<html>
<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; font-weight: bold;">
        <td nowrap align="center">日期</td>
        <td nowrap align="center">日志类型</td>
        <td nowrap align="center">日志内容</td>
        <td nowrap align="center">点评</td>
      </tr>
<?
 $cursor= exequery($connection,$QUERY_DIARY);

 while($ROW=mysql_fetch_array($cursor))
 {
    $DIA_ID=$ROW["DIA_ID"];
    $DIA_DATE=$ROW["DIA_DATE"];
    $DIA_DATE=strtok($DIA_DATE," ");
    $DIA_TYPE=$ROW["DIA_TYPE"];
    $CONTENT=$ROW["CONTENT"];
    $FLAG=0;
    if($KEY1!="" && stristr(strip_tags($CONTENT),$KEY1))
       $FLAG++;
    if($KEY2!="" && stristr(strip_tags($CONTENT),$KEY2))
       $FLAG++;
    if($KEY3!="" && stristr(strip_tags($CONTENT),$KEY3))
       $FLAG++;
    
    if($FLAG==0&&($KEY1!=""||$KEY2!=""||$KEY3!=""))
       continue;

    $CONTENT_COMENT="";
    $query = "SELECT * from DIARY_COMMENT where DIA_ID=$DIA_ID order by SEND_TIME desc";
    $cursor1= exequery($connection,$query);
    while($ROW=mysql_fetch_array($cursor1))
    {
       $USER_ID=$ROW["USER_ID"];
       $SEND_TIME=$ROW["SEND_TIME"];
       $CONTENT1=$ROW["CONTENT"];
       $CONTENT1=str_replace("\"","'",$CONTENT1);
       
       $query = "SELECT * from USER where USER_ID='$USER_ID'";
       $cursor2= exequery($connection,$query);
       if($ROW1=mysql_fetch_array($cursor2))
          $USER_NAME=$ROW1["USER_NAME"];
       
       $CONTENT_COMENT.="<font color=\"#0000FF\">".$USER_NAME."&nbsp;&nbsp;".$SEND_TIME."</font><br>".$CONTENT1."<br><br>";
    }

    switch($DIA_TYPE)
    {
     case "1":
         $DIA_TYPE_DESC="工作日志";
         break;
     case "2":
         $DIA_TYPE_DESC="个人日志";
         break;
    }
?>
    <tr style="BACKGROUND: #FFFFFF;">
      <td nowrap align="center" width="100"><?=$DIA_DATE?></td>
      <td nowrap align="center" width="100"><?=$DIA_TYPE_DESC?></td>
      <td><?=$CONTENT?></td>
      <td><?=$CONTENT_COMENT?></td>
    </tr>
<?
 }
?>
  </table>

</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -