albumindex.inc

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

<?php

function dml_getalbumtag( &$nd, &$nodata, &$error, &$parr )
{
	$term = true;
	while ( $term )
	{
		$sql = "SELECT * FROM ALBUM_CATEGORY WHERE (";
		$sql .= " LOCATE('".$parr['user_id']."',MANAGER) ";
		$sql .= " OR LOCATE('".$parr['user_id']."',BROWSE)) ";
		if ( !$nd->executequery( $sql ) )
		{
			$nodata = false;
			$term = false;
		}
		else
		{
			$term = $nd->getrecordset( );
			break;
		}
	}
	return $term;
}

function dml_getalbumcategoryphoto( &$nd, &$nodata, &$error, &$parr )
{
	$term = true;
	while ( $term )
	{
		$sql = "SELECT P.PID,P.USR,P.ALBUM_SUBJECT,P.ATTACHMENT,P.COVER,";
		$sql .= " P.TITLE,A.HTTP_URL,A.SERVER_PATH,ENCRYPT_NAME ";
		$sql .= " FROM ALBUM_PHOTO P,ALBUM_ATTACHMENT A WHERE  ";
		$sql .= " P.ATTACHMENT = A.PID AND P.ALBUM_SUBJECT = ".$parr['album_subject']."";
		if ( !$nd->executequery( $sql ) )
		{
			$nodata = false;
			$term = false;
		}
		else
		{
			$term = $nd->getrecordset( );
			break;
		}
	}
	return $term;
}

function dml_getalbumlayout( &$nd, &$nodata, &$error, &$parr )
{
	$term = true;
	while ( $term )
	{
		$sql = "SELECT * FROM ALBUM_LAYOUT WHERE USR = '".$parr['user_id']."' ";
		if ( !$nd->executequery( $sql ) )
		{
			$nodata = false;
			$term = false;
		}
		else
		{
			$term = $nd->getrecordset( );
			break;
		}
	}
	return $term;
}

function dml_searalbuminfo( &$nd, &$nodata, &$error, &$parr )
{
	$term = true;
	while ( $term )
	{
		$sql = "SELECT * FROM ALBUM_SUBJECT WHERE PID = ".$parr['album_subject']."";
		if ( !$nd->executequery( $sql ) )
		{
			$nodata = false;
			$term = false;
		}
		else
		{
			$term = $nd->getrecordset( );
			break;
		}
	}
	return $term;
}

function dml_setalbumindexseq( &$nd, &$nodata, &$error, &$parr )
{
	$term = true;
	while ( $term )
	{
		$sql = "UPDATE ALBUM_LAYOUT SET C1= '".$parr['c1']."',";
		$sql .= " C2 = '".$parr['c2']."',C3 = '".$parr['c3']."',C4 = '".$parr['c4']."',";
		$sql .= " LAYSEQ = '".$parr['layseq']."' WHERE USR = '".$parr['user_id']."'";
		if ( $nd->executequery( $sql ) )
		{
			break;
		}
		$nodata = false;
		$term = false;
		break;
	}
	return $term;
}

function dml_getalbumlistseq( &$nd, &$nodata, &$error, &$parr )
{
	$term = true;
	while ( $term )
	{
		$sql = "SELECT PID,ALBUM_CATEGORY,TITLE, FIND_IN_SET(PID,'".$parr['albumlayout']."') AS PID2 ";
		$sql .= " FROM ALBUM_SUBJECT  WHERE PID IN(".$parr['albumlayout'].") ORDER BY PID2";
		if ( !$nd->executequery( $sql ) )
		{
			$nodata = false;
			$term = false;
		}
		else
		{
			$term = $nd->getrecordset( );
			break;
		}
	}
	return $term;
}

function dml_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.USR = '".$parr['user_id']."'";
		$sql .= " OR LOCATE('".$parr['user_id']."',A.MANAGER) ";
		if ( !$nd->executequery( $sql ) )
		{
			$nodata = false;
			$term = false;
		}
		else
		{
			$term = $nd->getrecordset( );
			break;
		}
	}
	return $term;
}

function dml_getalbumrole( &$nd, &$nodata, &$error, &$parr )
{
	$term = true;
	while ( $term )
	{
		$sql = "SELECT PID,MANAGER,BROWSE FROM ALBUM_CATEGORY";
		$sql .= " WHERE PID = ".$parr['pid']."";
		if ( !$nd->executequery( $sql ) )
		{
			$nodata = false;
			$term = false;
		}
		else
		{
			$term = $nd->getrecordset( );
			break;
		}
	}
	return $term;
}

?>