export.php

来自「通达OA2007SE源代码 非常好的」· PHP 代码 · 共 165 行

PHP
165 行
字号 
<?
  include_once 'inc/auth.php';
  include_once 'inc/check_type.php';
  include_once 'inc/utility_all.php';
  echo '
<html>
<head>
<title>日程安排导出</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
';
  echo '<S';
  echo 'TYLE type=text/css>.HdrPaddingTop {
	PADDING-TOP: 5px
}
.HdrPaddingBttm {
	PADDING-BOTTOM: 5px
}
BODY {
	MARGIN-TOP: 2px; MARGIN-LEFT: 0px; COLOR: #000000; MARGIN-RIGHT: 0px
}
A {
	FONT-SIZE: 9pt; FONT-FAMILY: 宋体,MS SONG,SimSun,tahoma,sans-serif
}
BODY {
	FONT-SIZE: 9pt; FONT-FAMILY: 宋体,MS SONG,SimSun,tahoma,sans-serif
}
TABLE {
	FONT-SIZE: 9pt; FONT-FAMILY: 宋体,MS SONG,SimSun';
  echo ',tahoma,sans-serif
}
TD {
	FONT-SIZE: 9pt; FONT-FAMILY: 宋体,MS SONG,SimSun,tahoma,sans-serif
}
TR {
	FONT-SIZE: 9pt; FONT-FAMILY: 宋体,MS SONG,SimSun,tahoma,sans-serif
}
TABLE {
	BORDER-RIGHT: 0px; BORDER-TOP: 0px; BORDER-LEFT: 0px; BORDER-BOTTOM: 0px
}
.FF {
	COLOR: #000000
}
</STYLE>
';
  $query1 = (((''.'SELECT * from USER where USER_ID=\'').$LOGIN_USER_ID).'\'');
  $cursor1 = exequery ($connection, $query1);
  if ($ROW = mysql_fetch_array ($cursor1))
  {
    $USER_NAME = $ROW['USER_NAME'];
  }
  echo '<body>
<P>
<TABLE cellSpacing=0 cellPadding=3 width=640 align=center border=0>
  <TBODY>
  <TR>
    <TD style="BORDER-BOTTOM: #000099 1px solid" colSpan="2"></TD>
  </TR>
  <TR>
    <TD noWrap><FONT class=FF>';
  echo $USER_NAME;
  echo ' &lt;';
  echo $LOGIN_USER_ID;
  echo '&gt;</FONT></TD>
    <TD noWrap align=right><FONT class=FF>已打印： ';
  echo date ('Y年m月d日 H:i:s', time ());
  echo ' 
  </FONT></TD></TR></TR>
  <TR>
    <TD colSpan=2></TD>
  </TR>
  <TR>
    <TD colSpan=2>
      <HR color=#808080 SIZE=3>
    </TD>
  </TR>
  </TBODY>
</TABLE>
<TABLE cellSpacing=0 cellPadding=0 width=640 align=center border=0>
  <TBODY>
  <TR>
    <TD class=HdrPaddingBttm width="100%">
';
  $CUR_DATE = date ('Y-m-d', time ());
  $CUR_TIME = date ('Y-m-d H:i:s', time ());
  if (($SEND_TIME_MIN != ''))
  {
    $TIME_OK = is_date ($SEND_TIME_MIN);
    if (!$TIME_OK)
    {
      message ('错误', ('"日期"的格式不对，应形如 '.$CUR_DATE));
      button_back ();
      exit ();
    }
    $SEND_TIME_MIN = ($SEND_TIME_MIN.' 00:00:00');
  }
  if (($SEND_TIME_MAX != ''))
  {
    $TIME_OK = is_date ($SEND_TIME_MAX);
    if (!$TIME_OK)
    {
      message ('错误', ('"日期"的格式不对，应形如 '.$CUR_DATE));
      button_back ();
      exit ();
    }
    $SEND_TIME_MAX = ($SEND_TIME_MAX.' 23:59:59');
  }
  $CONDITION_STR = '';
  if (($CAL_TYPE != ''))
  {
    ($CONDITION_STR .= ((''.' and CAL_TYPE=').$CAL_TYPE));
  }
  if (($CONTENT != ''))
  {
    ($CONDITION_STR .= ((' and CONTENT like \'%'.$CONTENT).'%\''));
  }
  if (($SEND_TIME_MIN != ''))
  {
    ($CONDITION_STR .= (((''.' and CAL_TIME>=\'').$SEND_TIME_MIN).'\''));
  }
  if (($SEND_TIME_MAX != ''))
  {
    ($CONDITION_STR .= (((''.' and END_TIME<=\'').$SEND_TIME_MAX).'\''));
  }
  $query = (((((''.'SELECT * from CALENDAR where USER_ID=\'').$LOGIN_USER_ID).'\'').$CONDITION_STR).' order by CAL_TIME,END_TIME');
  $CUR_DATE = '';
  $cursor = exequery ($connection, $query);
  $CAL_COUNT = 0;
  while ($ROW = mysql_fetch_array ($cursor))
  {
    ++$CAL_COUNT;
    $CAL_ID = $ROW['CAL_ID'];
    $CAL_TIME = $ROW['CAL_TIME'];
    $END_TIME = $ROW['END_TIME'];
    $CAL_TYPE = $ROW['CAL_TYPE'];
    $CONTENT = $ROW['CONTENT'];
    $MANAGER_ID = $ROW['MANAGER_ID'];
    $MANAGER_NAME = '';
    if (($MANAGER_ID != ''))
    {
      $query = (((''.'SELECT * from USER where USER_ID=\'').$MANAGER_ID).'\'');
      $cursor1 = exequery ($connection, $query);
      if ($ROW1 = mysql_fetch_array ($cursor1))
      {
        $MANAGER_NAME = (('(安排人：'.$ROW1['USER_NAME']).')');
      }
    }
    $CONTENT = htmlspecialchars ($CONTENT);
    $CAL_DATE = substr ($CAL_TIME, 0, 10);
    if (($CAL_DATE != $CUR_DATE))
    {
      echo (('<br><b>'.$CAL_DATE).'：</b><br>');
      $CUR_DATE = $CAL_DATE;
    }
    echo (((((((('&nbsp;&nbsp;&nbsp;'.substr ($CAL_TIME, 11, 5)).' - ').substr ($END_TIME, 11, 5)).'&nbsp;&nbsp;&nbsp;').$CONTENT).' ').$MANAGER_NAME).'<br>');
  }
  echo '    </TD>
  </TR>
  </TBODY>
</TABLE>
</body>
</html>
';
?>

export.php - 源码说明

本页面展示了「通达OA2007SE源代码 非常好的」中的 export.php 源码文件，采用 PHP 编程语言编写，共 165 行代码。您可以在线阅读完整代码内容，也可以返回资源详情页下载完整源码包进行本地学习和开发。

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

⌨️ 快捷键说明

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