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

📄 search.php

📁 极限网络智能办公系统 - Office Automation 2008 官方100％ 源码
💻 PHP
字号:
🔍 
<?php
 

include_once( "inc/auth.php" );
include_once( "inc/check_type.php" );
include_once( "inc/utility_all.php" );
echo "\r\n<html>\r\n<head>\r\n<title>工作日志查询</title>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">\r\n<script>\r\nfunction SaveFile(ATTACHMENT_ID,ATTACHMENT_NAME)\r\n{\r\n  URL=\"/module/save_file?ATTACHMENT_ID=\"+ATTACHMENT_ID+\"&ATTACHMENT_NAME=\"+ATTACHMENT_NAME+\"&A=1\";\r\n  window.open(URL,null,\"height=180,width=400,status=1,toolbar=no,menubar=no,location=no,scrollbars=yes,resizable=yes\");\r\n}\r\nfunction check_all()\r\n{\r\n for (i=0;i<document.all(\"news_select\").length;i++)\r\n {\r\n   if(document.all(\"allbox\").checked)\r\n      {\r\n      \tif(!document.all(\"news_select\").item(i).disabled)\r\n      \t  document.all(\"news_select\").item(i).checked=true;\r\n      \telse\r\n      \t  document.all(\"news_select\").item(i).checked=false;\r\n      }\r\n   else\r\n      document.all(\"news_select\").item(i).checked=false;\r\n }\r\n\r\n if(i==0)\r\n {\r\n   if(document.all(\"allbox\").checked && document.all(\"news_select\").disabled==false)\r\n      document.all(\"news_select\").checked=true;\r\n   else\r\n      document.all(\"news_select\").checked=false;\r\n }\r\n}\r\n\r\nfunction check_one(el)\r\n{\r\n   if(!el.checked)\r\n      document.all(\"allbox\").checked=false;\r\n}\r\n\r\nfunction del_news()\r\n{\r\n  delete_str=\"\";\r\n  for(i=0;i<document.all(\"news_select\").length;i++)\r\n  {\r\n\r\n      el=document.all(\"news_select\").item(i);\r\n      if(el.checked)\r\n      {  val=el.value;\r\n         delete_str+=val + \",\";\r\n      }\r\n  }\r\n\r\n  if(i==0)\r\n  {\r\n      el=document.all(\"news_select\");\r\n      if(el.checked)\r\n      {  val=el.value;\r\n         delete_str+=val + \",\";\r\n      }\r\n  }\r\n\r\n  if(delete_str==\"\")\r\n  {\r\n     alert(\"要删除日志，请至少选择其中一条。\");\r\n     return;\r\n  }\r\n\r\n  msg='确认要删除所选日志么？';\r\n  if(window.confirm(msg))\r\n  {\r\n    url=\"del_diary.php?BEGIN_DATE=";
echo $BEGIN_DATE;
echo "&END_DATE=";
echo $END_DATE;
echo "&DIA_TYPE=";
echo $DIA_TYPE;
echo "&SUBJECT=";
echo $SUBJECT;
echo "&KEY1=";
echo $KEY1;
echo "&KEY2=";
echo $KEY2;
echo "&KEY3=";
echo $KEY3;
echo "&OP=1&DELETE_STR=\"+ delete_str;\r\n    location=url;\r\n  }\r\n\r\n}function delete_diary(DIA_ID)\r\n{\r\n msg='确认要删除该用户的工作日志么？';\r\n if(window.confirm(msg))\r\n {\r\n  URL=\"delete.php?DIA_ID=\" + DIA_ID;\r\n  window.location=URL;\r\n }\r\n}\r\n\r\n</script>\r\n</head>\r\n\r\n<body class=\"bodycolor\" topmargin=\"5\">\r\n\r\n";
if ( $BEGIN_DATE != "" )
{
	$TIME_OK = is_date( $BEGIN_DATE );
	if ( !$TIME_OK )
	{
		message( "错误", "起始日期格式不对，应形如 1999-1-2" );
		button_back( );
		exit( );
	}
}
if ( $END_DATE != "" )
{
	$TIME_OK = is_date( $END_DATE );
	if ( !$TIME_OK )
	{
		message( "错误", "截止日期格式不对，应形如 1999-1-2" );
		button_back( );
		exit( );
	}
}
echo "\r\n<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"3\" class=\"small\">\r\n  <tr>\r\n    <td class=\"Big\"><img src=\"/images/menu/diary.gif\" WIDTH=\"22\" HEIGHT=\"20\" align=\"absmiddle\"><span class=\"big3\"> 查询结果</span>\r\n    </td>\r\n  </tr>\r\n</table>\r\n\r\n<br>\r\n\r\n";
$CUR_DATE = date( "Y-m-d", time( ) );
$BEGIN_DATE1 = $BEGIN_DATE." 00:00:00";
$END_DATE1 = $END_DATE." 23:59:59";
$query1 = "SELECT * from SYS_PARA where PARA_NAME='LOCK_TIME'";
$cursor1 = exequery( $connection, $query1 );
if ( $ROW1 = mysql_fetch_array( $cursor1 ) )
{
	$PARA_VALUE = $ROW1['PARA_VALUE'];
}
if ( $PARA_VALUE != "" )
{
	$W_START = substr( $PARA_VALUE, 0, strpos( $PARA_VALUE, "," ) )." 00:00";
	$W_END = substr( $PARA_VALUE, strpos( $PARA_VALUE, "," ) + 1 )." 23:59";
}
$query = "SELECT * from SYS_PARA where PARA_NAME='LOCK_DATE_DAY'";
$cursor = exequery( $connection, $query );
if ( $ROW1 = mysql_fetch_array( $cursor ) )
{
	$LOCK_DATE_DAY = $ROW1['PARA_VALUE'];
}
$CUR_YEAR = date( "Y" );
$CUR_MON = date( "m" );
$CUR_DAY = date( "d" );
$LOCK_DATE_DAY = intval( $LOCK_DATE_DAY );
if ( 0 < $LOCK_DATE_DAY )
{
	$DATE = strtotime( $CUR_YEAR."-".$CUR_MON."-".$CUR_DAY );
	$DAY_END = strtotime( "-".$LOCK_DATE_DAY." days", $DATE );
	$W_END = date( "Y-m-d", $DAY_END )." 23:59";
}
$query = "SELECT * from DIARY where DIA_DATE>='".$BEGIN_DATE1."' and DIA_DATE<='{$END_DATE1}' and USER_ID='{$LOGIN_USER_ID}'";
if ( $DIA_TYPE != "0" )
{
	$query .= " and DIA_TYPE='".$DIA_TYPE."'";
}
if ( $SUBJECT != "0" )
{
	$query .= " and SUBJECT like '%".$SUBJECT."%'";
}
$query .= " order by DIA_DATE desc";
$cursor = exequery( $connection, $query );
$DIA_COUNT = 0;
while ( $ROW = mysql_fetch_array( $cursor ) )
{
	$DIA_ID = $ROW['DIA_ID'];
	$DIA_DATE = $ROW['DIA_DATE'];
	$DIA_DATE = substr( $DIA_DATE, 0, 16 );
	$DIA_TYPE1 = $ROW['DIA_TYPE'];
	$SUBJECT1 = $ROW['SUBJECT'];
	$CONTENT = $ROW['CONTENT'];
	$ATTACHMENT_ID = $ROW['ATTACHMENT_ID'];
	$ATTACHMENT_NAME = $ROW['ATTACHMENT_NAME'];
	if ( $SUBJECT1 == "" )
	{
		$SUBJECT1 = csubstr( strip_tags( $CONTENT ), 0, 50 ).( 50 < strlen( $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 != "" ) )
	{
		++$DIA_COUNT;
		$DIA_TYPE_DESC = get_code_name( $DIA_TYPE1, "DIARY_TYPE" );
		$query1 = "SELECT count(*) from DIARY_COMMENT where DIA_ID='".$DIA_ID."'";
		$cursor1 = exequery( $connection, $query1 );
		if ( $ROW1 = mysql_fetch_array( $cursor1 ) )
		{
			$COMMENT_COUNT = $ROW1[0];
		}
		if ( $DIA_COUNT == 1 )
		{
			echo "\r\n   <table border=\"0\" cellspacing=\"1\" width=\"95%\" class=\"small\" bgcolor=\"#000000\" cellpadding=\"3\">\r\n\r\n";
		}
		if ( $DIA_COUNT % 2 == 1 )
		{
			$TableLine = "TableLine1";
		}
		else
		{
			$TableLine = "TableLine2";
		}
		echo "   <tr class=\"";
		echo $TableLine;
		echo "\">\r\n      <td>\r\n ";
		if ( $PARA_VALUE == "" || $PARA_VALUE == "," )
		{
			echo "      \t&nbsp;<input type=\"checkbox\" name=\"news_select\" value=\"";
			echo $DIA_ID;
			echo "\" onClick=\"check_one(self);\">\r\n";
		}
		else if ( $W_START == "" && $W_END != "" && compare_date( $DIA_DATE, $W_END ) == 1 )
		{
			echo "      \t&nbsp;<input type=\"checkbox\" name=\"news_select\" value=\"";
			echo $DIA_ID;
			echo "\" onClick=\"check_one(self);\">\r\n";
		}
		else if ( $W_START != "" && $W_END == "" && compare_date( $W_START, $DIA_DATE ) == 1 )
		{
			echo "       \t&nbsp;<input type=\"checkbox\" name=\"news_select\" value=\"";
			echo $DIA_ID;
			echo "\" onClick=\"check_one(self);\">\r\n";
		}
		else if ( $W_START != "" && $W_END != "" && ( compare_date( $DIA_DATE, $W_END ) == 1 || compare_date( $W_START, $DIA_DATE ) == 1 ) )
		{
			echo "      \t&nbsp;<input type=\"checkbox\" name=\"news_select\" value=\"";
			echo $DIA_ID;
			echo "\" onClick=\"check_one(self);\">\r\n";
		}
		else
		{
			echo "      \t&nbsp;<input type=\"checkbox\" name=\"news_select\" value=\"";
			echo $DIA_ID;
			echo "\" disabled onClick=\"check_one(self);\">\r\n\r\n";
		}
		echo "     \t</td>\r\n     <td nowrap align=\"center\" width=\"100\">";
		echo $DIA_DATE;
		echo "</td>\r\n     <td nowrap align=\"center\" width=\"90\">";
		echo $DIA_TYPE_DESC;
		echo "</td>\r\n     <td><a href=\"read.php?BEGIN_DATE=";
		echo $BEGIN_DATE;
		echo "&END_DATE=";
		echo $END_DATE;
		echo "&DIA_TYPE=";
		echo $DIA_TYPE;
		echo "&SUBJECT=";
		echo $SUBJECT;
		echo "&KEY1=";
		echo $KEY1;
		echo "&KEY2=";
		echo $KEY2;
		echo "&KEY3=";
		echo $KEY3;
		echo "&DIA_ID=";
		echo $DIA_ID;
		echo "\">";
		echo $SUBJECT1;
		echo "</a></td>\r\n      <td>\r\n";
		if ( $ATTACHMENT_ID == "" )
		{
			echo "无";
		}
		else
		{
			echo attach_link( $ATTACHMENT_ID, $ATTACHMENT_NAME, 1, 1, 1, 1, 1, 0, 1, 0, "" );
		}
		echo "</td>\r\n      <td nowrap align=\"center\" width=\"40\">\r\n";
		if ( 0 < $COMMENT_COUNT )
		{
			echo "        <a href=\"read.php?DIA_ID=";
			echo $DIA_ID;
			echo "\">查看</a>\r\n";
		}
		echo "      </td>\r\n     <td nowrap align=\"center\" width=\"80\">\r\n";
		if ( $PARA_VALUE == "" || $PARA_VALUE == "," )
		{
			echo "          <a href=\"edit.php?DIA_ID=";
			echo $DIA_ID;
			echo "&BEGIN_DATE=";
			echo $BEGIN_DATE;
			echo "&END_DATE=";
			echo $END_DATE;
			echo "&DIA_TYPE=";
			echo $DIA_TYPE;
			echo "&SUBJECT=";
			echo $SUBJECT;
			echo "&KEY1=";
			echo $KEY1;
			echo "&KEY2=";
			echo $KEY2;
			echo "&KEY3=";
			echo $KEY3;
			echo "\">编辑</a>&nbsp;\r\n          <a href=\"javascript:delete_diary(";
			echo $DIA_ID;
			echo ");\"> 删除</a>\r\n";
		}
		else if ( $W_START == "" && $W_END != "" && compare_date( $DIA_DATE, $W_END ) == 1 )
		{
			echo "          <a href=\"edit.php?DIA_ID=";
			echo $DIA_ID;
			echo "&BEGIN_DATE=";
			echo $BEGIN_DATE;
			echo "&END_DATE=";
			echo $END_DATE;
			echo "&DIA_TYPE=";
			echo $DIA_TYPE;
			echo "&SUBJECT=";
			echo $SUBJECT;
			echo "&KEY1=";
			echo $KEY1;
			echo "&KEY2=";
			echo $KEY2;
			echo "&KEY3=";
			echo $KEY3;
			echo "\">编辑</a>&nbsp;\r\n          <a href=\"javascript:delete_diary(";
			echo $DIA_ID;
			echo ");\"> 删除</a>\r\n";
		}
		else if ( $W_START != "" && $W_END == "" && compare_date( $W_START, $DIA_DATE ) == 1 )
		{
			echo "          <a href=\"edit.php?DIA_ID=";
			echo $DIA_ID;
			echo "&BEGIN_DATE=";
			echo $BEGIN_DATE;
			echo "&END_DATE=";
			echo $END_DATE;
			echo "&DIA_TYPE=";
			echo $DIA_TYPE;
			echo "&SUBJECT=";
			echo $SUBJECT;
			echo "&KEY1=";
			echo $KEY1;
			echo "&KEY2=";
			echo $KEY2;
			echo "&KEY3=";
			echo $KEY3;
			echo "\">编辑</a>&nbsp;\r\n          <a href=\"javascript:delete_diary(";
			echo $DIA_ID;
			echo ");\"> 删除</a>\r\n";
		}
		else if ( $W_START != "" && $W_END != "" && ( compare_date( $DIA_DATE, $W_END ) == 1 || compare_date( $W_START, $DIA_DATE ) == 1 ) )
		{
			echo "          <a href=\"edit.php?DIA_ID=";
			echo $DIA_ID;
			echo "&BEGIN_DATE=";
			echo $BEGIN_DATE;
			echo "&END_DATE=";
			echo $END_DATE;
			echo "&DIA_TYPE=";
			echo $DIA_TYPE;
			echo "&SUBJECT=";
			echo $SUBJECT;
			echo "&KEY1=";
			echo $KEY1;
			echo "&KEY2=";
			echo $KEY2;
			echo "&KEY3=";
			echo $KEY3;
			echo "\">编辑</a>&nbsp;\r\n          <a href=\"javascript:delete_diary(";
			echo $DIA_ID;
			echo ");\"> 删除</a>\r\n";
		}
		echo "     </td>\r\n   </tr>\r\n";
	}
}
if ( $DIA_COUNT == 0 )
{
	message( "", "无符合条件的日志记录" );
}
else
{
	echo "<tr class=\"TableControl\">\r\n<td colspan=\"9\"> &nbsp;<input type=\"checkbox\" name=\"allbox\" id=\"allbox_for\" onClick=\"check_all();\">\r\n      <label for=\"allbox_for\">全选</label> \r\n      <input type=\"button\"  value=\"删除\" class=\"SmallButton\" onClick=\"del_news();\" title=\"删除所选日志\"> &nbsp;\r\n</td>\r\n</tr>\r\n  <thead class=\"TableHeader\">\r\n      <td nowrap align=\"center\">选择</td>\r\n     <td nowrap align=\"center\">日期 <img border=0 src=\"/images/arrow_down.gif\" width=\"11\" height=\"10\"></td>\r\n     <td nowrap align=\"center\">日志类型</td>\r\n     <td nowrap align=\"center\">日志标题</td>\r\n      <td nowrap align=\"center\">附件</td>\r\n     <td nowrap align=\"center\">点评</td>\r\n     <td nowrap align=\"center\">操作</td>\r\n  </thead>\r\n  </table>\r\n";
}
session_start( );
$QUERY_DIARY = $query;
if ( !session_is_registered( "QUERY_DIARY" ) )
{
	session_register( "QUERY_DIARY" );
}
if ( 0 < $DIA_COUNT )
{
	message( "", "共 ".$DIA_COUNT." 篇日志" );
}
echo "\r\n<div align=\"center\">\r\n";
if ( 0 < $DIA_COUNT )
{
	echo "<input type=\"button\"  value=\"导出\" class=\"BigButton\" onClick=\"window.open('export.php?KEY1=";
	echo $KEY1;
	echo "&KEY2=";
	echo $KEY2;
	echo "&KEY3=";
	echo $KEY3;
	echo "');\" title=\"导出word文件\">&nbsp;&nbsp;\r\n";
}
echo " <input type=\"button\"  value=\"返回\" class=\"BigButton\" onClick=\"location='query.php';\">\r\n</div>\r\n\r\n</body>\r\n</html>\r\n";
?>

⌨️ 快捷键说明

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