<?php

function dml_setcooperation( &$edb, &$nd, &$einfo, $parr )
{
	$term = true;
	while ( $term )
	{
		$sql = "UPDATE COOPERATION SET TITLE = '".$parr['title']."'";
		$sql .= " , CONTENT = '".$parr['content']."'";
		if ( $edb->executequery( $sql ) )
		{
			break;
		}
		$einfo = "更新錯誤";
		$term = false;
		break;
	}
	return $term;
}

function dml_searchcooperation( &$edb, &$nd, &$einfo, $parr )
{
	$term = true;
	while ( $term )
	{
		$sql = "SELECT TITLE,CONTENT FROM COOPERATION";
		if ( !$edb->executequery( $sql ) )
		{
			$einfo = "沒有任何協作區數據";
			$term = false;
			$nd = false;
		}
		else
		{
			$term = $edb->getrecordset( );
			break;
		}
	}
	return $term;
}

function dml_searchboard( &$edb, &$nd, &$einfo, $parr )
{
	$term = true;
	while ( $term )
	{
		$sql = "SELECT DISTINCT B.ID,B.TITLE,B.MANAGER,B.MEMBER,B.CREATE_DATE,B.END_DATE";
		$sql .= " FROM CO_BOARD B ";
		$sql .= " WHERE B.ABLE <> 0";
		if ( !$edb->executequery( $sql ) )
		{
			$einfo = "沒有任何版面數據";
			$term = false;
			$nd = false;
		}
		else
		{
			if ( ( $term = $edb->getrecordset( ) ) )
			{
				break;
			}
			$nd = 0;
			break;
		}
	}
	return $term;
}

function dml_boarduser( &$edb, &$nd, &$einfo, $parr )
{
	$term = true;
	while ( $term )
	{
		$sql = "SELECT MANAGER,MEMBER,USER_NAME FROM BOARD_USER,USER";
		$sql .= " WHERE BOARD = '".$parr['board']."' AND TYPE = '".$parr['type']."'";
		if ( !$edb->executequery( $sql ) )
		{
			$einfo = "查詢錯誤";
			$term = false;
		}
		else
		{
			$term = $edb->getrecordset( );
			break;
		}
	}
	return $term;
}

function dml_boardinfo( &$edb, &$nd, &$einfo, $parr )
{
	$term = true;
	while ( $term )
	{
		$sql = "SELECT ID,TITLE,MANAGER,MEMBER,CREATE_DATE,END_DATE";
		$sql .= " FROM CO_BOARD WHERE ID = ".$parr['id']." AND ABLE <> 0";
		if ( !$edb->executequery( $sql ) )
		{
			$einfo = "查詢錯誤";
			$term = false;
		}
		else
		{
			if ( ( $term = $edb->getrecordset( ) ) )
			{
				break;
			}
			$einfo = "沒有更新任何數據";
			$term = false;
			break;
		}
	}
	return $term;
}

function dml_setboard( &$edb, &$nd, &$einfo, $parr )
{
	$term = true;
	while ( $term )
	{
		$sql = "INSERT INTO CO_BOARD(ID,TITLE,CREATOR,MANAGER,MEMBER,CREATE_DATE, ";
		$sql .= " END_DATE,ABLE,ABLED,ABLER) VALUES(0,";
		$sql .= "'".$parr['title']."','".$parr['creator']."',";
		$sql .= " '".$parr['manager']."','".$parr['member']."',NOW(),'".$parr['end_date']."'";
		$sql .= " ,'1',NOW(),'".$parr['creator']."')";
		if ( !$edb->executequery( $sql ) )
		{
			$einfo = "更新協作區錯誤";
			$term = false;
		}
		else
		{
			if ( ( $rows = $edb->getaffectedrows( ) ) )
			{
				break;
			}
			$rows = 0;
			$term = false;
			$einfo = "沒有作任何修改,請返回";
			break;
		}
	}
	return $term;
}

function dml_modifyboard( &$edb, &$nd, &$einfo, $parr )
{
	$term = true;
	while ( $term )
	{
		$sql = "UPDATE CO_BOARD SET TITLE='".$parr['title']."',MANAGER='".$parr['manager']."'";
		$sql .= " ,MEMBER = '".$parr['member']."' WHERE ID = ".$parr['id']." AND ABLE <> 0";
		if ( $edb->executequery( $sql ) )
		{
			break;
		}
		$einfo = "修改協作區錯誤";
		$term = false;
		break;
	}
	return $term;
}

function dml_boardtopic( &$edb, &$nd, &$einfo, $parr )
{
	$term = true;
	while ( $term )
	{
		$sql = "SELECT COUNT(T.ID) ID FROM CO_TOPIC T,CO_BOARD B";
		$sql .= " WHERE T.BOARD = B.ID AND B.ID = ".$parr['id']." AND T.ABLE <> 0";
		if ( !$edb->executequery( $sql ) )
		{
			$einfo = "查詢錯誤";
			$term = false;
			$nd = false;
		}
		else
		{
			$term = $edb->getrecordset( );
			break;
		}
	}
	return $term;
}

function dml_delboard( &$edb, &$nd, &$einfo, $parr )
{
	$term = true;
	while ( $term )
	{
		$sql = "UPDATE CO_BOARD SET ABLE = 0 WHERE";
		$sql .= " ID = ".$parr['id']."";
		if ( !$edb->executequery( $sql ) )
		{
			$einfo = "刪除錯誤";
			$term = false;
		}
		else
		{
			if ( ( $rows = $edb->getaffectedrows( ) ) )
			{
				break;
			}
			$rows = 0;
			$term = false;
			$einfo = "沒有作任何修改,請返回";
			break;
		}
	}
	return $term;
}

?>