index.inc

泛微协同办公系统标准版E-office V5.5的源代码内含泛微办公系统V5.5自动注册文件。

<?php

function dml_topicuser( &$edb, &$nd, &$einfo, $parr )
{
	$term = true;
	while ( $term )
	{
		$sql = "SELECT DISTINCT C.ID,C.BOARD FROM TOPIC_USER T,CO_TOPIC C";
		$sql .= " WHERE T.TOPIC = C.ID AND T.USER_ID = '".$parr['user_id']."'";
		if ( !$edb->executequery( $sql ) )
		{
			$einfo = "查询错误";
			$term = false;
			$nd = false;
		}
		else
		{
			if ( ( $term = $edb->getrecordset( ) ) )
			{
				break;
			}
			$nd = 0;
			break;
		}
	}
	return $term;
}

function dml_boardinfo( &$edb, &$nd, &$einfo, $parr )
{
	$term = true;
	while ( $term )
	{
		$sql = "SELECT DISTINCT ID,TITLE,MANAGER,MEMBER";
		$sql .= " FROM CO_BOARD  WHERE ABLE <> 0";
		if ( !$edb->executequery( $sql ) )
		{
			$einfo = "查询版面数据错误";
			$term = false;
			$nd = false;
		}
		else
		{
			if ( ( $term = $edb->getrecordset( ) ) )
			{
				break;
			}
			$einfo = "没有任何数据";
			$term = fasle;
			break;
		}
	}
	return $term;
}

function dml_sboardinfo( &$edb, &$nd, &$einfo, $parr )
{
	$term = true;
	while ( $term )
	{
		$sql = "SELECT ID,TITLE,MANAGER,MEMBER FROM CO_BOARD WHERE";
		$sql .= " ID IN(".$parr['board_id'].") AND ABLE <> 0";
		if ( !$edb->executequery( $sql ) )
		{
			$einfo = "查询错误";
			$term = false;
			$nd = false;
		}
		$term = $edb->getrecordset( );
		break;
	}
	return $term;
}

function dml_topicinfo( &$edb, &$nd, &$einfo, $parr )
{
	$term = true;
	while ( $term )
	{
		$sql = "SELECT DISTINCT C.ID,C.BOARD,C.TITLE,C.CREATE_DATE,C.END_DATE,C.FLAGOR,";
		$sql .= " C.ISNEW,U.USER_NAME FROM CO_TOPIC C,TOPIC_USER T,USER U,CO_BOARD B ";
		$sql .= " WHERE C.ABLE <> 0 AND C.ID = T.TOPIC AND T.USER_ID = '".$parr['user_id']."'";
		$sql .= " AND C.CREATOR = U.USER_ID  ";
		$sql .= "  AND C.BOARD = B.ID AND B.ABLE <> 0 ORDER BY C.".$parr['ordertype']."  ".$parr['order']."";
		if ( !$edb->executequery( $sql ) )
		{
			$einfo = "查询错误";
			$term = false;
			$nd = false;
		}
		$term = $edb->getrecordset( );
		break;
	}
	return $term;
}

function dml_btopiclist( &$edb, &$nd, &$einfo, $parr )
{
	$term = true;
	while ( $term )
	{
		$sql = "SELECT DISTINCT C.ID,C.BOARD,C.TITLE,C.CREATE_DATE,C.END_DATE,C.FLAGOR,";
		$sql .= " C.ISNEW,U.USER_NAME FROM CO_TOPIC C,TOPIC_USER T,";
		$sql .= " USER U,CO_BOARD B WHERE C.ID = T.TOPIC ";
		$sql .= " AND T.USER_ID = '".$parr['user_id']."' AND C.CREATOR = U.USER_ID AND ";
		$sql .= "  C.ABLE <> 0 AND C.BOARD = ".$parr['board_id']." AND C.BOARD = B.ID";
		$sql .= "  AND B.ABLE <>0  ORDER BY C.".$parr['ordertype']."  ".$parr['order']."";
		if ( !$edb->executequery( $sql ) )
		{
			$einfo = "查询错误";
			$term = false;
			$nd = false;
		}
		$term = $edb->getrecordset( );
		break;
	}
	return $term;
}

function dml_atopicinfo( &$edb, &$nd, &$einfo, $parr )
{
	$term = true;
	while ( $term )
	{
		$sql = "SELECT ID,MANAGER FROM CO_BOARD WHERE ID = ".$parr['board_id']." ORDER BY ID DESC";
		if ( !$edb->executequery( $sql ) )
		{
			$einfo = "查询管理员错误";
			$term = false;
		}
		else
		{
			$term = $edb->getrecordset( );
			$board = $term[0]['ID'];
			if ( !find_id( $term[0]['MANAGER'], $_SESSION['LOGIN_USER_ID'] ) )
			{
				break;
			}
			$sql = "SELECT C.ID FROM CO_TOPIC C,TOPIC_USER T WHERE T.USER_ID = '".$parr['user_id']."'";
			$sql .= " AND C.BOARD = '".$board."' AND C.ID = T.TOPIC AND C.ABLE<>0";
			if ( !$edb->executequery( $sql ) )
			{
				$einfo = "查询主题错误";
				$term = false;
				$nd = false;
			}
			else
			{
				$term = $edb->getrecordset( );
				if ( $term[0]['ID'] == "" )
				{
					$sql = "SELECT DISTINCT C.ID,C.TITLE,C.CREATE_DATE,C.END_DATE,C.FLAGOR,C.ISNEW, ";
					$sql .= " C.CREATOR,U.USER_NAME FROM CO_TOPIC C,TOPIC_USER T,USER U";
					$sql .= " WHERE C.CREATOR = U.USER_ID ";
					$sql .= " AND C.BOARD = '".$board."' AND C.ID = T.TOPIC AND C.ABLE<>0";
					$edb->executequery( $sql );
					$term = $edb->getrecordset( );
				}
				else
				{
					$i = 0;
					for ( ;	$i < count( $term );	++$i	)
					{
						$topicid[$i] = $term[$i]['ID'];
					}
					$topic = implode( ",", $topicid );
					if ( !( trim( $topic ) != "" ) )
					{
						break;
					}
					$sql = "SELECT DISTINCT C.ID,C.TITLE,C.CREATE_DATE,C.END_DATE,C.FLAGOR,C.ISNEW,";
					$sql .= " C.CREATOR, U.USER_NAME FROM CO_TOPIC C,TOPIC_USER T,USER U";
					$sql .= " WHERE C.ID = T.TOPIC AND C.ID NOT IN (".$topic.") AND C.CREATOR = U.USER_ID";
					$sql .= " AND C.BOARD = ".$board." AND  C.ABLE <> 0 ORDER BY C.ID DESC";
					if ( !$edb->executequery( $sql ) )
					{
						$einfo = "查询主题错误";
						$term = false;
						$nd = false;
					}
					else
					{
						$term = $edb->getrecordset( );
						break;
					}
				}
			}
		}
	}
	return $term;
}

function dml_searchtopicinfo( &$edb, &$nd, &$einfo, $parr )
{
	$term = true;
	while ( $term )
	{
		$sql = "SELECT DISTINCT C.ID,C.BOARD,C.TITLE,C.CONTENT,";
		$sql .= " C.CREATE_DATE,C.END_DATE,C.CREATOR,C.FLAGOR,C.ISNEW,U.USER_NAME ";
		$sql .= " FROM CO_TOPIC C,TOPIC_USER T,USER U,CO_BOARD B WHERE C.CREATOR = U.USER_ID";
		$sql .= " AND C.ID = T.TOPIC AND T.USER_ID = '".$parr['user_id']."'";
		$sql .= " AND B.ID = C.BOARD AND B.ABLE <> 0";
		if ( $parr['title'] != "" )
		{
			$sql .= " AND C.TITLE LIKE '%".$parr['title']."%'";
		}
		if ( $parr['creator'] != "" )
		{
			$sql .= " AND C.CREATOR = '".$parr['creator']."'";
		}
		if ( $parr['START_DATE'] != "" || $parr['END_DATE'] != "" )
		{
			if ( $parr['START_DATE'] == $parr['END_DATE'] )
			{
				$sql .= " AND C.CREATE_DATE = '".$parr['START_DATE']."'";
			}
			else
			{
				$sql .= " AND C.CREATE_DATE BETWEEN '".$parr['CREATE_DATE']."' AND '".$parr['END_DATE']."'";
			}
		}
		if ( $parr['ESTART_DATE'] != "" || $parr['EEND_DATE'] != "" )
		{
			if ( $parr['ESTART_DATE'] == $parr['EEND_DATE'] )
			{
				$sql .= " AND C.END_DATE = '".$parr['ESTART_DATE']."'";
			}
			else
			{
				$sql .= " AND C.END_DATE BETWEEN '".$parr['ESTART_DATE']."' AND '".$parr['EEND_DATE']."'";
			}
		}
		if ( $parr['board_id'] != 0 )
		{
			$sql .= " AND C.BOARD = ".$parr['board_id']."";
		}
		if ( $parr['state'] != "" )
		{
			if ( $parr['state'] == 1 )
			{
				$sql .= " AND C.ABLE <> 0";
			}
			else
			{
				$sql .= " AND C.ABLE = 0";
			}
		}
		$sql .= "   ORDER BY C.ID DESC";
		if ( !$edb->executequery( $sql ) )
		{
			$einfo = "查询错误";
			$term = false;
			$nd = false;
		}
		else
		{
			$term = $edb->getrecordset( );
			break;
		}
	}
	return $term;
}

function dml_tsearchtopicinfo( &$edb, &$nd, &$einfo, $parr )
{
	$term = true;
	while ( $term )
	{
		$sql = "SELECT DISTINCT C.ID,C.BOARD,C.TITLE,C.CONTENT,";
		$sql .= " C.CREATE_DATE,C.END_DATE, C.CREATOR,C.FLAGOR,C.ISNEW,U.USER_NAME";
		$sql .= " FROM CO_TOPIC C,TOPIC_USER T,USER U,CO_BOARD B WHERE C.CREATOR = U.USER_ID";
		$sql .= " AND C.ID = T.TOPIC AND T.USER_ID = '".$parr['user_id']."' ";
		$sql .= " AND B.ID = C.BOARD ";
		if ( $parr['title'] != "" )
		{
			$sql .= " AND C.TITLE LIKE '%".$parr['title']."%'";
		}
		if ( $parr['creator'] != "" )
		{
			$sql .= " AND C.CREATOR = '".$parr['creator']."'";
		}
		if ( $parr['START_DATE'] != "" || $parr['END_DATE'] != "" )
		{
			if ( $parr['START_DATE'] == $parr['END_DATE'] )
			{
				$sql .= " AND C.CREATE_DATE = '".$parr['START_DATE']."'";
			}
			else
			{
				$sql .= " AND C.CREATE_DATE BETWEEN '".$parr['CREATE_DATE']."' AND '".$parr['END_DATE']."'";
			}
		}
		if ( $parr['ESTART_DATE'] != "" || $parr['EEND_DATE'] != "" )
		{
			if ( $parr['ESTART_DATE'] == $parr['EEND_DATE'] )
			{
				$sql .= " AND C.END_DATE = '".$parr['ESTART_DATE']."'";
			}
			else
			{
				$sql .= " AND C.END_DATE BETWEEN '".$parr['ESTART_DATE']."' AND '".$parr['EEND_DATE']."'";
			}
		}
		if ( $parr['board_id'] != 0 )
		{
			$sql .= " AND C.BOARD = ".$parr['board_id']."";
		}
		if ( $parr['state'] != "" )
		{
			if ( $parr['state'] == 1 )
			{
				$sql .= " AND C.ABLE <> 0";
			}
			else
			{
				$sql .= " AND C.ABLE = 0";
			}
		}
		$sql .= "  ORDER BY C.ID DESC";
		if ( !$edb->executequery( $sql ) )
		{
			$einfo = "查询错误";
			$term = false;
			$nd = false;
		}
		else
		{
			$term = $edb->getrecordset( );
			break;
		}
	}
	return $term;
}

function dml_modifylog( &$edb, &$nd, &$einfo, $parr )
{
	$term = true;
	while ( $term )
	{
		$isnew = $parr['isnew'];
		$userid = $parr['userid'].",";
		$userids = str_replace( $userid, "", $isnew );
		$sql = "UPDATE CO_TOPIC SET ISNEW = '".$userids."' WHERE ID = ".$parr['topic']."";
		if ( $edb->executequery( $sql ) )
		{
			break;
		}
		$term = false;
		$einfo = "增加数据错误";
		break;
	}
	return $term;
}

function find_str( $STRING, $ID )
{
	$MY_ARRAY = explode( ",", $STRING );
	$ARRAY_COUNT = sizeof( $MY_ARRAY );
	if ( $MY_ARRAY[$ARRAY_COUNT - 1] == "" )
	{
		--$ARRAY_COUNT;
	}
	$I = 0;
	for ( ;	$I < $ARRAY_COUNT;	++$I	)
	{
		if ( strcmp( $MY_ARRAY[$I], $ID ) == 0 || $MY_ARRAY[$I] == $ID )
		{
			return true;
		}
	}
	return false;
}

function dml_flag( &$edb, &$nd, &$einfo, $parr )
{
	$term = true;
	while ( $term )
	{
		$sql = " SELECT FLAGOR FROM CO_TOPIC WHERE ID = ".$parr['id']."";
		$edb->executequery( $sql );
		$term = $edb->getrecordset( );
		echo $term[0]['FLAGOR'];
		if ( trim( $term[0]['FLAGOR'] ) == "" )
		{
			$userids = $term[0]['FLAGOR'].$parr['userid'].",";
		}
		else if ( find_str( $term[0]['FLAGOR'], $parr['userid'] ) )
		{
			$str = $parr['userid'].",";
			$userids = str_replace( $str, "", $term[0]['FLAGOR'] );
		}
		else
		{
			$userids = $term[0]['FLAGOR'].$parr['userid'].",";
		}
		$sql = "UPDATE CO_TOPIC SET FLAGOR = '".$userids."'";
		$sql .= " WHERE ID = ".$parr['id']."";
		if ( $edb->executequery( $sql ) )
		{
			break;
		}
		$term = false;
		$einfo = "数据错误";
		break;
	}
	return $term;
}

?>