📄 search.php

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

include_once( "inc/auth.php" );
include_once( "inc/utility_all.php" );
$ITEMS_IN_PAGE = 20;
if ( !isset( $start ) )
{
	$start = 0;
}
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 src=\"/inc/sort_table.js\"></script>\r\n<script>\r\n\r\nfunction sms_run(TO_ID,TO_NAME)\r\n{\r\n   var sms_text=\"公告催查：请及时查看您的公告通知信息！\";\r\n   myleft=(screen.availWidth-600)/2;\r\n   window.open(\"sms_show.php?TO_ID=\"+TO_ID+\"&TO_NAME=\"+TO_NAME+\"&CONTENT=\"+sms_text,\"\",\"height=150,width=350,status=0,toolbar=no,menubar=no,location=no,scrollbars=yes,top=100,left=\"+myleft+\",resizable=yes\");\r\n}\r\n\r\n</script>\r\n</head>\r\n\r\n<body class=\"bodycolor\" topmargin=\"5\" onload=\"SortTable('beSortTable');\">\r\n\r\n";
$CUR_DATE = date( "Y-m-d", time( ) );
if ( $USER_NAME != "" )
{
	$WHERE_STR .= " and USER_NAME like '%".$USER_NAME."%'";
}
if ( $DEPT_ID != "all" )
{
	$WHERE_STR .= " and USER.DEPT_ID=".$DEPT_ID;
}
if ( $USER_PRIV != "" )
{
	$WHERE_STR .= " and USER.USER_PRIV=".$USER_PRIV;
}
if ( $SEX != "ALL" )
{
	$WHERE_STR .= " and SEX=".$SEX;
}
if ( $TEL_NO_DEPT != "" )
{
	$WHERE_STR .= " and TEL_NO_DEPT like '%".$TEL_NO_DEPT."%'";
}
if ( $EMAIL != "" )
{
	$WHERE_STR .= " and EMAIL like '%".$EMAIL."%'";
}
$WHERE_STR = " where USER.DEPT_ID=DEPARTMENT.DEPT_ID and USER_PRIV.USER_PRIV=USER.USER_PRIV and USER.DEPT_ID!=0 ".$WHERE_STR;
$query = "SELECT count(DISTINCT USER.USER_ID) from USER left join NOTIFY A on (A.TO_ID='ALL_DEPT' or find_in_set(USER.DEPT_ID,A.TO_ID) or find_in_set(USER.USER_PRIV,A.PRIV_ID) or find_in_set(USER.USER_ID,A.USER_ID)) and A.BEGIN_DATE<='".$CUR_DATE."' and (A.END_DATE>='{$CUR_DATE}' or A.END_DATE='0000-00-00') and A.PUBLISH='1' left join NOTIFY B on (B.TO_ID='ALL_DEPT' or find_in_set(USER.DEPT_ID,B.TO_ID) or find_in_set(USER.USER_PRIV,B.PRIV_ID) or find_in_set(USER.USER_ID,B.USER_ID)) and B.BEGIN_DATE<='{$CUR_DATE}' and (B.END_DATE>='{$CUR_DATE}' or B.END_DATE='0000-00-00') and B.PUBLISH='1' and find_in_set(USER.USER_ID,B.READERS),DEPARTMENT,USER_PRIV ".$WHERE_STR;
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
	$USER_COUNT = $ROW[0];
}
echo "<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"3\" class=\"small\">\r\n  <tr>\r\n    <td class=\"Big\"><img src=\"/images/menu/statistic.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";
$USER_COUNT = 0;
$WHERE_STR .= " GROUP BY USER.USER_ID ";
$query = "SELECT USER.*,PRIV_NAME,DEPT_NAME,COUNT(DISTINCT A.NOTIFY_ID) NOTIFY_COUNT,COUNT(DISTINCT B.NOTIFY_ID) NOTIFY_READ_COUNT from USER left join NOTIFY A on (A.TO_ID='ALL_DEPT' or find_in_set(USER.DEPT_ID,A.TO_ID) or find_in_set(USER.USER_PRIV,A.PRIV_ID) or find_in_set(USER.USER_ID,A.USER_ID)) and A.BEGIN_DATE<='".$CUR_DATE."' and (A.END_DATE>='{$CUR_DATE}' or A.END_DATE='0000-00-00') and A.PUBLISH='1' left join NOTIFY B on (B.TO_ID='ALL_DEPT' or find_in_set(USER.DEPT_ID,B.TO_ID) or find_in_set(USER.USER_PRIV,B.PRIV_ID) or find_in_set(USER.USER_ID,B.USER_ID)) and B.BEGIN_DATE<='{$CUR_DATE}' and (B.END_DATE>='{$CUR_DATE}' or B.END_DATE='0000-00-00') and B.PUBLISH='1' and find_in_set(USER.USER_ID,B.READERS),DEPARTMENT,USER_PRIV ".$WHERE_STR.( " order by DEPT_NO,PRIV_NO,USER_NO,USER_NAME limit ".$start.",{$ITEMS_IN_PAGE}" );
$cursor = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
	$USER_ID = $ROW['USER_ID'];
	$USER_NAME = $ROW['USER_NAME'];
	$DEPT_ID = $ROW['DEPT_ID'];
	$SEX = $ROW['SEX'];
	$TEL_NO_DEPT = $ROW['TEL_NO_DEPT'];
	$MOBIL_NO = $ROW['MOBIL_NO'];
	$EMAIL = $ROW['EMAIL'];
	$MOBIL_NO_HIDDEN = $ROW['MOBIL_NO_HIDDEN'];
	$USER_PRIV = $ROW['PRIV_NAME'];
	$DEPT_NAME = $ROW['DEPT_NAME'];
	$NOTIFY_COUNT = $ROW['NOTIFY_COUNT'];
	$NOTIFY_READ_COUNT = $ROW['NOTIFY_READ_COUNT'];
	if ( 0 < $NOTIFY_COUNT )
	{
		$COUNT = intval( $NOTIFY_READ_COUNT / $NOTIFY_COUNT * 100 );
	}
	else
	{
		$COUNT = 0;
	}
	if ( 0 < $COUNT1 && $COUNT < $COUNT1 || 0 < $COUNT2 && $COUNT2 < $COUNT )
	{
		++$USER_COUNT;
		$DEPT_LONG_NAME = dept_long_name( $DEPT_ID );
		if ( $SEX == 0 )
		{
			$SEX = "男";
		}
		else
		{
			$SEX = "女";
		}
		if ( $USER_COUNT == 1 )
		{
			$DEPT_ID1 = $DEPT_ID;
			echo "<table id=\"beSortTable\" border=\"0\" cellspacing=\"1\" width=\"100%\" class=\"small\" bgcolor=\"#000000\" cellpadding=\"3\">\r\n    <tr class=\"TableHeader\" align=\"center\">\r\n      <td nowrap><b>部门</b></td>\r\n      <td nowrap><b>角色</b></td>\r\n      <td nowrap><b>姓名</b></td>\r\n      <td nowrap><b>性别</b></td>\r\n      <td nowrap><b>公告阅读率</b></td>\r\n      <td nowrap><b>操作</b></td>\r\n    </tr>\r\n";
		}
		if ( $USER_COUNT % 2 == 1 )
		{
			$TableLine = "TableLine1";
		}
		else
		{
			$TableLine = "TableLine2";
		}
		$DEPT_ID1 = $DEPT_ID;
		echo "    <tr class=\"";
		echo $TableLine;
		echo "\" align=\"center\">\r\n      <td nowrap title=\"";
		echo $DEPT_LONG_NAME;
		echo "\">";
		echo $DEPT_NAME;
		echo "</td>\r\n      <td nowrap>";
		echo $USER_PRIV;
		echo "</td>\r\n      <td nowrap>";
		echo $USER_NAME;
		echo "</td>\r\n      <td nowrap>";
		echo $SEX;
		echo "</td>\r\n      <td nowrap>";
		echo $NOTIFY_COUNT;
		echo "/";
		echo $NOTIFY_READ_COUNT;
		echo "</td>\r\n      <td nowrap><a href=\"javascript:sms_run('";
		echo $USER_ID;
		echo "','";
		echo $USER_NAME;
		echo "');\">催查</a></td>\r\n    </tr>\r\n";
	}
}
if ( $USER_COUNT == 0 )
{
	message( "<br>提示", "没有符合条件的人员" );
	echo "<br>\r\n<div align=\"center\">\r\n <input type=\"button\"  value=\"返回\" class=\"BigButton\" onClick=\"history.back();\">\r\n</div>\r\n";
	exit( );
}
echo "\r\n</table>\r\n<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"3\" class=\"small\">\r\n  <tr>\r\n    <td align=\"right\" valign=\"bottom\" class=\"small1\">共";
echo $USER_COUNT;
echo "条记录 ";
echo page_bar( $start, $USER_COUNT, $ITEMS_IN_PAGE );
echo "</td>\r\n  </tr>\r\n</table>\r\n\r\n<br>\r\n<div align=\"center\">\r\n <input type=\"button\"  value=\"返回\" class=\"BigButton\" onClick=\"location='index.php'\">\r\n</div>\r\n\r\n</body>\r\n</html>";
?>
⌨️ 快捷键说明

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