export.php

来自「通达OA官方提供的30源代码,感觉很实在」· PHP 代码 · 共 82 行

PHP

82 行

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

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

<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>
        <td nowrap align="center">点评</td>
        <td nowrap align="center">附件名称</td>
      </tr>
<?

$query = "SELECT DIA_ID,DIA_DATE,SUBJECT,DIA_TYPE,ATTACHMENT_ID,ATTACHMENT_NAME,CONTENT from DIARY where USER_ID='$USER_ID' and DIA_TYPE!='2' ".str_replace("`","'",$WHERE_STR)." order by DIA_DATE desc,DIA_ID desc";
$cursor= exequery($connection,$query);
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"];
   $SUBJECT=$ROW["SUBJECT"];
   $CONTENT=$ROW["CONTENT"];
   $ATTACHMENT_ID=$ROW["ATTACHMENT_ID"];
   $ATTACHMENT_NAME=$ROW["ATTACHMENT_NAME"];
   
   $CONTENT_COMENT="";
   $query = "SELECT USER.USER_NAME,DIARY_COMMENT.SEND_TIME,DIARY_COMMENT.CONTENT from DIARY_COMMENT,USER where DIARY_COMMENT.DIA_ID='$DIA_ID' and DIARY_COMMENT.USER_ID = USER.USER_ID order by DIARY_COMMENT.SEND_TIME desc";
   $cursor1= exequery($connection,$query);
   while($ROW=mysql_fetch_array($cursor1))
   {
      $USER_NAME=$ROW["USER_NAME"];     
      $SEND_TIME=$ROW["SEND_TIME"];
      $CONTENT1=$ROW["CONTENT"];
      $CONTENT1=str_replace("\"","'",$CONTENT1);
      
      $CONTENT_COMENT.="<font color=\"#0000FF\">".$USER_NAME."&nbsp;&nbsp;".$SEND_TIME."</font><br>".$CONTENT1."<br><br>";
   }

   $DIA_TYPE_DESC=get_code_name($DIA_TYPE,"DIARY_TYPE");
?>
   <tr style="BACKGROUND: #FFFFFF;">
     <td nowrap align="center" width="100"><?=$DIA_DATE?></td>
     <td nowrap align="center" width="100"><?=$DIA_TYPE_DESC?></td>
     <td><?=$SUBJECT?></td>
     <td><?=$CONTENT?></td>
     <td><?=$CONTENT_COMENT?></td>
     <td>
<?
  $ATTACHMENT_NAME_ARRAY=explode("*",$ATTACHMENT_NAME);
  $ARRAY_COUNT=sizeof($ATTACHMENT_NAME_ARRAY);
  for($I=0;$I<$ARRAY_COUNT;$I++)
  {
     if($ATTACHMENT_NAME_ARRAY[$I]=="")
        continue;
     echo $ATTACHMENT_NAME_ARRAY[$I]."<br>";
  }
?>
     </td>
   </tr>
<?
}
?>
  </table>

</body>
</html>

export.php - 源码说明

本页面展示了「通达OA官方提供的30源代码,感觉很实在」中的 export.php 源码文件，采用 PHP 编程语言编写，共 82 行代码。您可以在线阅读完整代码内容，也可以返回资源详情页下载完整源码包进行本地学习和开发。

虫虫下载站收录了大量与源代码相关的技术资源，包括源代码、技术文档、电路图等，是电子工程师和嵌入式开发者的专业学习平台。

⌨️ 快捷键说明

复制代码Ctrl + C

搜索代码Ctrl + F

全屏模式F11

增大字号Ctrl + =

减小字号Ctrl + -

显示快捷键?