📄 showalllinkman.php

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

💻 PHP

字号:

<?php

include_once( "inc/auth.php" );
echo "\r\n<html>\r\n<head>\r\n<title>联系人信息管理</title>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">\r\n";
echo "<s";
echo "cript>\r\nfunction linkman_detail(linkman_id)\r\n{\r\n\tURL=\"../linkman/detail.php?linkman_id=\"+linkman_id;\r\n\tmyleft=(screen.availWidth-500)/2;\r\n\twindow.open(URL,\"\",\"height=550,width=450,status=1,toolbar=no,menubar=no,location=no,scrollbars=yes,top=100,left=\"+myleft+\",resizable=yes\");\r\n}\r\n</script>\r\n</head>\r\n\r\n<body style=\"background-color: transparent\" class=\"bodycolor\" topmargin=\"5\">\r\n";
$connection = openconnection( );
$query = "SELECT l.*, c.CUSTOMER_NAME, c.CUSTOMER_ID, c.MANAGE_USER FROM linkman as l,customer as c where c.CUSTOMER_ID=l.CUSTOMER_ID and c.CUSTOMER_ID=".$_REQUEST['CUSTOMER_ID']." order by l.LINKMAN_ID desc";
$cursor = exequery( $connection, $query );
$count = 0;
echo "<table border=\"0\" cellspacing=\"1\" width=\"100%\" cellpadding=\"5\">\r\n";
while ( $row = mysql_fetch_array( $cursor ) )
{
	++$count;
	$customer_id = $row['CUSTOMER_ID'];
	$linkman_id = $row['LINKMAN_ID'];
	$linkman_name = $row['LINKMAN_NAME'];
	$customer_name = $row['CUSTOMER_NAME'];
	$customer_id = $row['CUSTOMER_ID'];
	$email = $row['EMAIL'];
	$tel_no_work = $row['TEL_NO_WORK'];
	$mostly_linkman = $row['MOSTLY_LINKMAN'];
	$manage_user = $row['MANAGE_USER'];
	if ( $mostly_linkman == 1 )
	{
		$c_title = "主联系人";
		$c_img = "<span id='MLmark' style='color:#FF0000;width:10px;' ><B>!</B></span>";
	}
	else
	{
		$c_title = "联系人";
		$c_img = "";
	}
	$query2 = "select USER_ID from USER where USER_ID='".$manage_user."'";
	$cursor2 = exequery( $connection, $query2 );
	if ( $row2 = mysql_fetch_row( $cursor2 ) )
	{
		$user_id = $row2[0];
	}
	if ( $count % 2 == 1 )
	{
		$TableLine = "TableLine1";
	}
	else
	{
		$TableLine = "TableLine2";
	}
	echo "<tr class=\"";
	echo $TableLine;
	echo "\">\r\n\t\t<td title=\"";
	echo $c_title;
	echo "\">";
	echo $c_img;
	echo "</td>\r\n\t\t<td title='";
	echo $linkman_name;
	echo "'><a href=\"#\" onClick=\"linkman_detail('";
	echo $linkman_id;
	echo "')\">";
	echo strlen( $linkman_name ) <= 20 ? $linkman_name : substr( $linkman_name, 0, 20 ).chr( 0 )."...";
	echo "</a></td>\r\n\t\t<td>";
	echo $tel_no_work;
	echo "</td>\r\n\t\t<td>";
	echo $email;
	echo "</td>\r\n\r\n\t</tr>\r\n";
}
echo "<center>";
if ( $count == 0 )
{
	message( "提示", "暂无记录" );
	exit( );
}
echo "</center>";
echo "</table>\r\n</body>\r\n</html>";
?>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -