amcy_main.inc

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

<?php

function insertalbumsubject( &$nd, &$nodata, &$error, &$parr )
{
	$term = true;
	while ( $term )
	{
		$sql = "INSERT INTO ALBUM_SUBJECT(PID,ALBUM_CATEGORY,USR,TITLE,CREATE_DATA)VALUES(";
		$sql .= " 0,".$parr['pid'].",'".$parr['user_id']."','".$parr['albumtitle']."',NOW())";
		if ( !$nd->executequery( $sql ) )
		{
			$nodata = false;
			$term = false;
		}
		else
		{
			$sql = "SELECT PID FROM ALBUM_SUBJECT WHERE PID = LAST_INSERT_ID()";
			if ( !$nd->executequery( $sql ) )
			{
				$nodata = false;
				$term = false;
			}
			else
			{
				$res = $nd->getrecordset( );
				$spid = $res[0]['PID'];
				$sql = "SELECT MANAGER FROM ALBUM_CATEGORY WHERE PID = '".$parr['pid']."'";
				if ( !$nd->executequery( $sql ) )
				{
					$nodata = false;
					$term = false;
				}
				else
				{
					$mres = $nd->getrecordset( );
					if ( $mres[0]['MANAGER'] != "" )
					{
						$muser = $mres[0]['MANAGER'].$parr['user_id'];
						$muser = explode( ",", $muser );
						$ures = array_unique( $muser );
					}
					else
					{
						$ures = $parr['user_id'];
					}
					$i = 0;
					do
					{
						do
						{
							if ( $i < count( $ures ) )
							{
								break;
							}
							++$i;
						} while ( 1 );
						$sql = "SELECT PID, C1,LAYSEQ FROM ALBUM_LAYOUT WHERE USR = '".$ures[$i]."'";
						if ( !$nd->executequery( $sql ) )
						{
							$nodata = false;
							$term = false;
							break;
						}
						else
						{
							$res = $nd->getrecordset( );
							$olayseq = $res[0]['LAYSEQ'];
							$olayoutpid = $res[0]['PID'];
							$oc1 = $res[0]['C1'];
							$nlayseq = $olayseq.$spid.",";
							$nc1 = $oc1.$spid.",";
							if ( $olayoutpid == "" )
							{
								$sql = "INSERT INTO ALBUM_LAYOUT(PID,USR,C1,LAYSEQ)";
								$sql .= "VALUES(0,'".$ures[$i]."','".$nc1."','".$nlayseq."')";
							}
							else
							{
								$sql = "UPDATE ALBUM_LAYOUT SET C1 = '".$nc1."',LAYSEQ = '".$nlayseq."'";
								$sql .= " WHERE PID = ".$olayoutpid."";
							}
							if ( !$nd->executequery( $sql ) )
							{
								$nodata = false;
								$term = false;
								break;
							}
						}
					} while ( 1 );
					break;
				}
			}
		}
	}
	echo $spid;
	return $term;
}

function dml_inserttopic( &$nd, &$nodata, &$error, &$parr )
{
	$term = true;
	while ( $term )
	{
		$sql = "INSERT INTO ALBUM_TOPIC(PID,USR,ALBUM_PHOTO,CONTENT,CREATE_DATE)";
		$sql .= " VALUES(0,'".$parr['user_id']."',".$parr['album_photo'].",'".$parr['content']."',";
		$sql .= " NOW())";
		if ( !$nd->executequery( $sql ) )
		{
			$nodata = false;
			$term = false;
		}
		else
		{
			$sql = "SELECT COUNT(*) CPID FROM ALBUM_TOPIC WHERE ALBUM_PHOTO = ".$parr['album_photo']."";
			if ( !$nd->executequery( $sql ) )
			{
				$nodata = false;
				$term = false;
			}
			else
			{
				$term = $nd->getrecordset( );
				echo $parr['album_photo']."|".$term[0]['CPID'];
				break;
			}
		}
	}
	return $term;
}

function dml_searchtopic( &$nd, &$nodata, &$error, &$parr )
{
	$term = true;
	while ( $term )
	{
		$sql = "SELECT A.*,U.USER_NAME FROM ALBUM_TOPIC A,USER U WHERE A.USR = U.USER_ID AND ";
		$sql .= "  A.ALBUM_PHOTO = ".$parr['album_photo']." ORDER BY A.PID DESC";
		if ( !$nd->executequery( $sql ) )
		{
			$nodata = false;
			$term = false;
		}
		else
		{
			$term = $nd->getrecordset( );
			break;
		}
	}
	return $term;
}

function dml_seartopic( &$nd, &$nodata, &$error, &$parr )
{
	$term = true;
	while ( $term )
	{
		$sql = "SELECT COUNT(*) CPID FROM ALBUM_TOPIC WHERE ALBUM_PHOTO = ".$parr['album_photo']."";
		if ( !$nd->executequery( $sql ) )
		{
			$nodata = false;
			$term = false;
		}
		else
		{
			$term = $nd->getrecordset( );
			break;
		}
	}
	return $term;
}

function dml_modifytopic( &$nd, &$nodata, &$error, &$parr )
{
	$term = true;
	while ( $term )
	{
		$sql = "UPDATE ALBUM_TOPIC SET CONTENT = '".$parr['content']."',CREATE_DATE = NOW()";
		$sql .= " WHERE PID = ".$parr['pid']."";
		if ( $nd->executequery( $sql ) )
		{
			break;
		}
		$nodata = false;
		$term = false;
		break;
	}
	return $term;
}

function dml_deltopic( &$nd, &$nodata, &$error, &$parr )
{
	$term = true;
	while ( $term )
	{
		$sql = "DELETE FROM ALBUM_TOPIC WHERE PID = ".$parr['pid']."";
		if ( $nd->executequery( $sql ) )
		{
			break;
		}
		$nodata = false;
		$term = false;
		break;
	}
	return $term;
}

function dml_delalbum( &$nd, &$nodata, &$error, &$parr )
{
	$term = true;
	while ( $term )
	{
		$sql = "DELETE FROM ALBUM_SUBJECT WHERE PID = ".$parr['pid']."";
		if ( !$nd->executequery( $sql ) )
		{
			$nodata = false;
			$term = false;
		}
		else
		{
			$sql = "SELECT MANAGER FROM ALBUM_CATEGORY WHERE PID = '".$parr['cid']."'";
			if ( !$nd->executequery( $sql ) )
			{
				$nodata = false;
				$term = false;
			}
			else
			{
				$mres = $nd->getrecordset( );
				if ( $mres[0]['MANAGER'] != "" )
				{
					$muser = explode( ",", $mres[0]['MANAGER'] );
					array_push( $muser, $parr['user_id'] );
					$ures = array_unique( $muser );
				}
				else
				{
					$ures = $parr['user_id'];
				}
				$str = $parr['pid'].",";
				$i = 0;
				for ( ;	$i < count( $ures ) - 1;	++$i	)
				{
					$sql = "UPDATE ALBUM_LAYOUT SET C1 = REPLACE(C1,'".$str."', ''),";
					$sql .= " C2 = REPLACE(C2,'".$str."', ''),";
					$sql .= " C3 = REPLACE(C3,'".$str."', ''), ";
					$sql .= " C4 = REPLACE(C4,'".$str."', ''), ";
					$sql .= " LAYSEQ = REPLACE(LAYSEQ,'".$str."', '') ";
					$sql .= " WHERE USR = '".$ures[$i]."'";
					if ( !$nd->executequery( $sql ) )
					{
						$nodata = false;
						$term = false;
						break;
					}
				}
				$sql = "SELECT PID,ATTACHMENT FROM ALBUM_PHOTO WHERE ALBUM_SUBJECT = ".$parr['pid']."";
				if ( !$nd->executequery( $sql ) )
				{
					$nodata = false;
					$term = false;
				}
				else
				{
					$res = $nd->getrecordset( );
					$i = 0;
					for ( ;	$i < count( $res );	++$i	)
					{
						$photoid[$i] = $res[$i]['PID'];
						$ait[$i] = $res[$i]['ATTACHMENT'];
					}
					$album_photo = implode( ",", $photoid );
					$album_ait = implode( ",", $ait );
					$parr['album_photo'] = str_replace( ",", "','", $album_photo );
					$parr['album_ait'] = str_replace( ",", "','", $album_ait );
					$sql = "DELETE FROM ALBUM_PHOTO WHERE ALBUM_SUBJECT = ".$parr['pid']."";
					if ( !$nd->executequery( $sql ) )
					{
						$nodata = false;
						$term = false;
					}
					else
					{
						$sql = "DELETE FROM ALBUM_TOPIC WHERE ALBUM_PHOTO IN ('".$parr['album_photo']."')";
						if ( !$nd->executequery( $sql ) )
						{
							$nodata = false;
							$term = false;
						}
						else
						{
							$sql = "DELETE FROM ALBUM_ATTACHMENT WHERE PID IN ('".$parr['album_ait']."')";
							if ( $nd->executequery( $sql ) )
							{
								break;
							}
							$nodata = false;
							$term = false;
							break;
						}
					}
				}
			}
		}
	}
	return $term;
}

function dml_topicitem( &$nd, &$nodata, &$error, &$parr )
{
	$term = true;
	while ( $term )
	{
		$sql = "SELECT A.*,U.USER_NAME FROM ALBUM_TOPIC A,USER U WHERE A.USR = U.USER_ID AND ";
		$sql .= " A.PID = ".$parr['pid']." ";
		if ( !$nd->executequery( $sql ) )
		{
			$nodata = false;
			$term = false;
		}
		else
		{
			$term = $nd->getrecordset( );
			break;
		}
	}
	return $term;
}

function dml_getimageinfo( $img )
{
	$img_info = getimagesize( $img );
	$new_img_info = array(
		"width" => $img_info[0],
		"height" => $img_info[1]
	);
	return $new_img_info;
}

?>