📄 appellation.php

📁 泛微协同办公系统标准版E-office V5.5的源代码内含泛微办公系统V5.5自动注册文件。
💻 PHP
字号:
<?php

include_once( "inc/auth.php" );
$connection = openconnection( );
echo "\r\n<html>\r\n<head>\r\n<title>选择名称</title>\r\n";
echo "<s";
echo "cript>\r\nvar parent_window = parent.dialogArguments;\r\nfunction showone(appellation_id, appellation, stockpile, appellation_number, sort_number){\r\n\tparent_window.form1.appellation_id.value\t\t= appellation_id;\r\n    parent_window.form1.appellation.value\t\t\t= appellation;\r\n\tparent_window.form1.storeroom_stockpile.value\t= stockpile;\r\n\tparent_window.document.getElementById('appellation_number').innerHTML\t=";
echo " appellation_number;\r\n\tparent_window.document.getElementById('sort_number').innerHTML\t\t\t= sort_number;\r\n}\r\n\r\nfunction showtwo(appellation_id, appellation, stockpile){\r\n\tparent_window.form1.appellation_id.value\t\t= appellation_id;\r\n    parent_window.form1.appellation.value\t\t\t= appellation;\r\n\tparent_window.form1.storeroom_stockpile.value\t= stockpile;\r\n}\r\n</script>\r\n</head>\r\n\r\n<body>\r\n<table border=\"0\" wi";
echo "dth=\"100%\" class=\"small\" cellspacing=\"1\" cellpadding=\"5\">\r\n";
$count = 0;
if ( $_REQUEST['sort_id'] )
{
	if ( $_REQUEST['selectType'] == true )
	{
		$query = "select APPELLATION_ID, APPELLATION, APPELLATION_NUMBER, SORT_ID from officeitem_appellation where sort_id=".$_REQUEST['sort_id']." ";
	}
	else
	{
		$query = "select APPELLATION_ID, APPELLATION, APPELLATION_NUMBER, SORT_ID from officeitem_appellation where sort_id=".$_REQUEST['sort_id']."";
	}
	$cursor = exequery( $connection, $query );
	while ( $row = mysql_fetch_row( $cursor ) )
	{
		++$count;
		$appellation_id = $row[0];
		$appellation = $row[1];
		$appellation_number = $row[2];
		$sort_id = $row[3];
		$query2 = "select STOCKPILE from officeitem_appellation where APPELLATION_ID=".$appellation_id;
		$cursor2 = exequery( $connection, $query2 );
		if ( $row2 = mysql_fetch_row( $cursor2 ) )
		{
			$stockpile = $row2[0];
		}
		$query3 = "select SORT_NUMBER from officeitem_sort where SORT_ID=".$sort_id;
		$cursor3 = exequery( $connection, $query3 );
		if ( $row3 = mysql_fetch_row( $cursor3 ) )
		{
			$sort_number = $row3[0];
		}
		if ( $_REQUEST['selectType'] == true )
		{
			echo "\t\t\t\t<tr class=\"TableLine2\" style=\"cursor:hand\">\r\n\t\t\t\t\t<td onclick=\"javascript:showone(";
			echo $appellation_id;
			echo ", '";
			echo $appellation;
			echo "', ";
			echo $stockpile;
			echo ", '";
			echo $appellation_number;
			echo "','";
			echo $sort_number;
			echo "')\">";
			echo $appellation;
			echo "</td>\r\n\t\t\t\t</tr>\r\n";
		}
		else
		{
			echo "\t\t\t\t<tr class=\"TableLine2\" style=\"cursor:hand\">\r\n\t\t\t\t\t<td onclick=\"javascript:showtwo(";
			echo $appellation_id;
			echo ", '";
			echo $appellation;
			echo "', ";
			echo $stockpile;
			echo ")\">";
			echo $appellation;
			echo "</td>\r\n\t\t\t\t</tr>\r\n";
		}
	}
}
else
{
	if ( $_REQUEST['selectType'] == true )
	{
		$query = "select APPELLATION_ID, APPELLATION, APPELLATION_NUMBER, SORT_ID from officeitem_appellation ";
	}
	else
	{
		$query = "select APPELLATION_ID, APPELLATION, APPELLATION_NUMBER, SORT_ID from officeitem_appellation";
	}
	$cursor = exequery( $connection, $query );
	while ( $row = mysql_fetch_row( $cursor ) )
	{
		++$count;
		$appellation_id = $row[0];
		$appellation = $row[1];
		$appellation_number = $row[2];
		$sort_id = $row[3];
		$query2 = "select STOCKPILE from officeitem_appellation where APPELLATION_ID=".$appellation_id;
		$cursor2 = exequery( $connection, $query2 );
		if ( $row2 = mysql_fetch_row( $cursor2 ) )
		{
			$stockpile = $row2[0];
		}
		$query3 = "select SORT_NUMBER from officeitem_sort where SORT_ID=".$sort_id;
		$cursor3 = exequery( $connection, $query3 );
		if ( $row3 = mysql_fetch_row( $cursor3 ) )
		{
			$sort_number = $row3[0];
		}
		if ( $_REQUEST['selectType'] == true )
		{
			echo "\t\t\t<tr class=\"TableLine2\" style=\"cursor:hand\">\r\n\t\t\t\t<td onclick=\"javascript:showone(";
			echo $appellation_id;
			echo ", '";
			echo $appellation;
			echo "', ";
			echo $stockpile;
			echo ", '";
			echo $appellation_number;
			echo "','";
			echo $sort_number;
			echo "')\">";
			echo $appellation;
			echo "</td>\r\n\t\t\t</tr>\r\n";
		}
		else
		{
			echo "\t\t\t<tr class=\"TableLine2\" style=\"cursor:hand\">\r\n\t\t\t\t<td onclick=\"javascript:showtwo(";
			echo $appellation_id;
			echo ", '";
			echo $appellation;
			echo "', ";
			echo $stockpile;
			echo ")\">";
			echo $appellation;
			echo "</td>\r\n\t\t\t</tr>\r\n";
		}
	}
}
if ( $count == 0 )
{
	message( "提示", "暂无记录" );
	exit( );
}
echo "</table>\r\n</body>\r\n</html>";
?>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -