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

📄 export.php

📁 极限网络智能办公系统 Office Automation V3.0官方100％源代码.
💻 PHP
字号:
🔍 
<?
include_once("inc/auth.php");
include_once("inc/check_type.php");
include_once("inc/utility_all.php");
?>

<html>
<head>
<title>日程安排导出</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<STYLE 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,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"];
?>
<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><?=$USER_NAME?> &lt;<?=$LOGIN_USER_ID?>&gt;</FONT></TD>
    <TD noWrap align=right><FONT class=FF>已打印： <?=date("Y年m月d日 H:i:s",time())?> 
  </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=str_replace("<","&lt",$CONTENT);
    $CONTENT=str_replace(">","&gt",$CONTENT);
    $CONTENT=stripslashes($CONTENT);
    
    switch($CAL_TYPE)
    {
     case "1":
         $CAL_TYPE="工作事务";
         break;
     case "2":
         $CAL_TYPE="个人事务";
         break;
    }
    
    $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>";
}
?>
    </TD>
  </TR>
  </TBODY>
</TABLE>
</body>

</html>

⌨️ 快捷键说明

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