amcy_list.inc

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

<?php

function getalbumlist( &$nd, &$nodata, &$error, &$parr )
{
	$term = true;
	while ( $term )
	{
		$sql = "SELECT S.*,DATE_FORMAT(S.CREATE_DATA,'%Y-%m-%d') CREATE_DATA  ";
		$sql .= " FROM ALBUM_SUBJECT S JOIN ALBUM_CATEGORY A ON S.ALBUM_CATEGORY = A.PID ";
		$sql .= " WHERE S.ALBUM_CATEGORY = ".$_REQUEST['pid']."";
		$sql .= " AND (S.USR = '".$parr['user_id']."'";
		$sql .= " OR LOCATE('".$parr['user_id']."',A.MANAGER)) ";
		$sql .= " ORDER BY S.TITLE ".$parr['ord']."";
		if ( !$nd->executequery( $sql ) )
		{
			$nodata = false;
			$term = false;
		}
		else
		{
			$term = $nd->getrecordset( );
			break;
		}
	}
	return $term;
}

function dml_getallalbumlist( &$nd, &$nodata, &$error, &$parr )
{
	$term = true;
	while ( $term )
	{
		$sql = "SELECT S.*,DATE_FORMAT(S.CREATE_DATA,'%Y-%m-%d') CREATE_DATA   ";
		$sql .= "FROM ALBUM_SUBJECT S JOIN ALBUM_CATEGORY A ON S.ALBUM_CATEGORY = A.PID ";
		$sql .= " WHERE S.USR = '".$parr['user_id']."'";
		$sql .= " OR LOCATE('".$parr['user_id']."',A.MANAGER) ";
		$sql .= " ORDER BY S.TITLE ".$parr['ord']."";
		if ( !$nd->executequery( $sql ) )
		{
			$nodata = false;
			$term = false;
		}
		else
		{
			$term = $nd->getrecordset( );
			break;
		}
	}
	return $term;
}

function getsharealbum( &$nd, &$nodata, &$error, &$parr )
{
	$term = true;
	while ( $term )
	{
		$sql = "SELECT *,DATE_FORMAT(CREATE_DATA,'%Y-%m-%d') CREATE_DATA FROM ALBUM_SUBJECT ";
		$sql .= " WHERE USR <> '".$parr['user_id']."'  AND LOCATE('".$parr['user_id']."', SHARE_USER)";
		$sql .= " ORDER BY TITLE ".$parr['ord']."";
		if ( !$nd->executequery( $sql ) )
		{
			$nodata = false;
			$term = false;
		}
		else
		{
			$term = $nd->getrecordset( );
			break;
		}
	}
	return $term;
}

function setalbumflag( &$nd, &$nodata, &$error, &$parr )
{
	$term = true;
	while ( $term )
	{
		$sql = " SELECT FLAGOR FROM ALBUM_SUBJECT WHERE PID = ".$parr['pid']."";
		$nd->executequery( $sql );
		$term = $nd->getrecordset( );
		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 ALBUM_SUBJECT SET FLAGOR = '".$userids."' WHERE ";
		$sql .= " PID = ".$parr['pid']."";
		if ( $nd->executequery( $sql ) )
		{
			break;
		}
		$nodata = false;
		$term = false;
		break;
	}
	echo $parr['pid'];
	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_getgcategorymax_space( &$nd, &$nodata, &$error, &$parr )
{
	$term = true;
	while ( $term )
	{
		$sql = "SELECT MAX_SPACE FROM ALBUM_CATEGORY WHERE PID = ".$parr['pid']."";
		if ( !$nd->executequery( $sql ) )
		{
			$nodata = false;
			$term = false;
		}
		else
		{
			$term = $nd->getrecordset( );
			break;
		}
	}
	return $term;
}

function dml_getalbumnums( &$nd, &$nodata, &$error, &$parr )
{
	$term = true;
	while ( $term )
	{
		$sql = "SELECT COUNT(S.PID) NC_CNT  ";
		$sql .= " FROM ALBUM_SUBJECT S JOIN ALBUM_CATEGORY A ON S.ALBUM_CATEGORY = A.PID ";
		$sql .= " WHERE S.ALBUM_CATEGORY = ".$_REQUEST['pid']."";
		$sql .= " AND (S.USR = '".$parr['user_id']."'";
		$sql .= " OR LOCATE('".$parr['user_id']."',A.MANAGER)) ";
		if ( !$nd->executequery( $sql ) )
		{
			$nodata = false;
			$term = false;
		}
		else
		{
			$term = $nd->getrecordset( );
			return $term[0]['NC_CNT'];
		}
	}
	return $term;
}

function dml_getalbumlistpage( &$nd, &$nodata, &$error, &$parr )
{
	$term = true;
	while ( $term )
	{
		$sql = "SELECT S.*,DATE_FORMAT(S.CREATE_DATA,'%Y-%m-%d') CREATE_DATA,U.USER_NAME  ";
		$sql .= " FROM ALBUM_SUBJECT S JOIN ALBUM_CATEGORY A ON S.ALBUM_CATEGORY = A.PID ";
		$sql .= " JOIN USER U ON S.USR = U.USER_ACCOUNTS";
		$sql .= " WHERE S.ALBUM_CATEGORY = ".$_REQUEST['pid']."";
		$sql .= " AND (S.USR = '".$parr['user_id']."'";
		$sql .= " OR LOCATE('".$parr['user_id']."',A.MANAGER)) ";
		$sql .= " ORDER BY S.TITLE ".$parr['ord']."";
		$sql .= " LIMIT ".( $parr['page_no'] - 1 ) * $parr['page_record'].", ".$parr['page_record'];
		if ( !$nd->executequery( $sql ) )
		{
			$nodata = false;
			$term = false;
		}
		else
		{
			$term = $nd->getrecordset( );
			break;
		}
	}
	return $term;
}

function dml_getallalbumnums( &$nd, &$nodata, &$error, &$parr )
{
	$term = true;
	while ( $term )
	{
		$sql = "SELECT COUNT(S.PID) NC_CNT ";
		$sql .= "FROM ALBUM_SUBJECT S JOIN ALBUM_CATEGORY A ON S.ALBUM_CATEGORY = A.PID ";
		$sql .= " WHERE S.USR = '".$parr['user_id']."'";
		$sql .= " OR LOCATE('".$parr['user_id']."',A.MANAGER) ";
		if ( !$nd->executequery( $sql ) )
		{
			$nodata = false;
			$term = false;
		}
		else
		{
			$term = $nd->getrecordset( );
			return $term[0]['NC_CNT'];
		}
	}
	return $term;
}

function dml_getallalbumlistpage( &$nd, &$nodata, &$error, &$parr )
{
	$term = true;
	while ( $term )
	{
		$sql = "SELECT S.*,DATE_FORMAT(S.CREATE_DATA,'%Y-%m-%d') CREATE_DATA,U.USER_NAME   ";
		$sql .= "FROM ALBUM_SUBJECT S JOIN ALBUM_CATEGORY A ON S.ALBUM_CATEGORY = A.PID ";
		$sql .= " JOIN USER U ON S.USR = U.USER_ACCOUNTS";
		$sql .= " WHERE S.USR = '".$parr['user_id']."'";
		$sql .= " OR LOCATE('".$parr['user_id']."',A.MANAGER) ";
		$sql .= " ORDER BY S.TITLE ".$parr['ord']."";
		$sql .= " LIMIT ".( $parr['page_no'] - 1 ) * $parr['page_record'].", ".$parr['page_record'];
		if ( !$nd->executequery( $sql ) )
		{
			$nodata = false;
			$term = false;
		}
		else
		{
			$term = $nd->getrecordset( );
			break;
		}
	}
	return $term;
}

function dml_getsharealbumnums( &$nd, &$nodata, &$error, &$parr )
{
	$term = true;
	while ( $term )
	{
		$sql = "SELECT COUNT(PID) NC_CNT FROM ALBUM_SUBJECT ";
		$sql .= " WHERE USR <> '".$parr['user_id']."'  AND LOCATE('".$parr['user_id']."', SHARE_USER)";
		$sql .= " ORDER BY TITLE ".$parr['ord']."";
		if ( !$nd->executequery( $sql ) )
		{
			$nodata = false;
			$term = false;
		}
		else
		{
			$term = $nd->getrecordset( );
			return $term[0]['NC_CNT'];
		}
	}
	return $term;
}

function getsharealbumpage( &$nd, &$nodata, &$error, &$parr )
{
	$term = true;
	while ( $term )
	{
		$sql = "SELECT S.*,DATE_FORMAT(S.CREATE_DATA,'%Y-%m-%d') CREATE_DATA,U.USER_NAME FROM ALBUM_SUBJECT S,USER U ";
		$sql .= " WHERE S.USR = U.USER_ACCOUNTS AND S.USR <> '".$parr['user_id']."'  AND LOCATE('".$parr['user_id']."', S.SHARE_USER)";
		$sql .= " ORDER BY S.TITLE ".$parr['ord']."";
		$sql .= " LIMIT ".( $parr['page_no'] - 1 ) * $parr['page_record'].", ".$parr['page_record'];
		if ( !$nd->executequery( $sql ) )
		{
			$nodata = false;
			$term = false;
		}
		else
		{
			$term = $nd->getrecordset( );
			break;
		}
	}
	return $term;
}

?>