📄 attach.php

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

include_once( "inc/auth.php" );
include_once( "inc/function_page_01.php" );
if ( $_REQUEST['cur_page'] == "" )
{
	$cur_page = 1;
}
else
{
	$cur_page = $_REQUEST['cur_page'];
}
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 search_click(){\r\n\turl\t= \"search.php\";\r\n\tlocation = url;\r\n}\r\n\r\nfunction edt(linkman_id)\r\n{\r\n\turl\t= \"edit.php?r_b=attach&linkman_id=\"+linkman_id+\"&cur_page=";
echo $cur_page;
echo "&sens=";
echo $_REQUEST['sens'];
echo "&order=";
echo $_REQUEST['order'];
echo "&customer_id3=";
echo $_REQUEST['customer_id'];
echo "\";\r\n\tlocation\t= url;\r\n}\r\n\r\nfunction del(linkman_id, customer_id)\r\n{\r\n\tvar msg\t= \"你确认要删除所选记录吗?\";\r\n\tif(window.confirm(msg))\r\n\t{\r\n\t\tvar url\t= \"delete.php?r_b=attach&linkman_id=\"+linkman_id+\"&customer_id=\"+customer_id+\"&cur_page=";
echo $cur_page;
echo "&sens=";
echo $_REQUEST['sens'];
echo "&order=";
echo $_REQUEST['order'];
echo "&customer_id2=";
echo $_REQUEST['customer_id'];
echo "\";\r\n\t\tlocation = url;\r\n\t}\r\n}\r\n</script>\r\n</head>\r\n\r\n<body class=\"bodycolor\" topmargin=\"5\">\r\n<table border=\"0\" width=\"100%\" cellspacing=\"1\" cellpadding=\"0\">\r\n\t<tr class=\"tablehead1\">\r\n\t\t<td><img src=\"/images/manage/news.gif\" align=\"absmiddle\">联系人信息</td>\r\n\t</tr>\r\n\t<tr class=\"tablehead2\">\r\n\t\t<td><BUTTON class=btn onClick=\"javascript:history.back();\" title=\"返回\"><table><tr valign=top ><td><img src=\"/images/litt";
echo "legif/b_u.gif\" align=\"center\"></td> <td>";
echo "<s";
echo "pan id=\"showallid\">返回</span></td></tr></table></BUTTON></td>\r\n\t</tr>\r\n</table>\r\n<br>\r\n";
$connection = openconnection( );
$query = "select CUSTOMER_NAME,MANAGE_USER from customer where CUSTOMER_ID=".$_REQUEST['customer_id'];
$cursor = exequery( $connection, $query );
if ( $row = mysql_fetch_array( $cursor ) )
{
	$customer_name2 = $row[0];
	$manage_user = $row['MANAGE_USER'];
}
$query2 = "SELECT c.*, l.* FROM linkman as l,customer as c where l.CUSTOMER_ID=c.CUSTOMER_ID and c.CUSTOMER_ID=".$_REQUEST['customer_id']."";
switch ( $_REQUEST['order'] )
{
case "customer_name" :
	$query2 .= " order by c.CUSTOMER_NAME";
	break;
case "tel_no_work" :
	$query2 .= " order by l.TEL_NO_WORK";
	break;
case "mobile" :
	$query2 .= " order by l.MOBILE";
	break;
case "email" :
	$query2 .= " order by l.EMAIL";
	break;
default :
	$query2 .= " order by l.LINKMAN_ID";
	break;
}
$query2 .= $_REQUEST['sens'] ? " DESC" : " ASC";
$query2 = page( $query2, 15 );
$cursor2 = exequery( $connection, $query2 );
$count = 0;
echo "<s";
echo "pan style=\"color:#999999;\">所属客户（";
echo strlen( $customer_name2 ) <= 100 ? $customer_name2 : substr( $customer_name2, 0, 100 ).chr( 0 )."...";
echo "）</span>\r\n<table border=\"0\" cellspacing=\"1\" width=\"100%\" cellpadding=\"5\" class=\"small\">\r\n";
while ( $row2 = mysql_fetch_array( $cursor2 ) )
{
	++$count;
	$customer_id = $row2['CUSTOMER_ID'];
	$linkman_id = $row2['LINKMAN_ID'];
	$linkman_name = $row2['LINKMAN_NAME'];
	$customer_name = $row2['CUSTOMER_NAME'];
	$email = $row2['EMAIL'];
	$tel_no_work = $row2['TEL_NO_WORK'];
	$mostly_linkman = $row2['MOSTLY_LINKMAN'];
	$mobile = $row2['MOBILE'];
	if ( $count % 2 == 1 )
	{
		$TableLine = "TableLine1";
	}
	else
	{
		$TableLine = "TableLine2";
	}
	if ( $mostly_linkman == 1 )
	{
		$c_title = "主联系人";
		$c_img = "<img src='../../../../images/littlegif/2-emphasis.gif' border='0'>";
	}
	else
	{
		$c_title = "次联系人";
		$c_img = "<img src='../../../../images/littlegif/3-latent.gif' border='0'>";
	}
	$query3 = "select USER_NAME from USER where USER_ID='".$manage_user."'";
	$cursor3 = exequery( $connection, $query3 );
	if ( $row3 = mysql_fetch_row( $cursor3 ) )
	{
		$user_name = $row3[0];
	}
	$query4 = "select LINKMAN_NAME from linkman where CUSTOMER_ID=".$customer_id;
	$cursor4 = exequery( $connection, $query4 );
	if ( $row4 = mysql_fetch_row( $cursor4 ) )
	{
		$linman_name = $row4[0];
	}
	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 "'>";
	echo strlen( $linkman_name ) <= 30 ? $linkman_name : substr( $linkman_name, 0, 30 ).chr( 0 )."...";
	echo "</td>\r\n\t\t<td title='";
	echo $mobile;
	echo "'>";
	echo strlen( $mobile ) <= 15 ? $mobile : substr( $mobile, 0, 15 ).chr( 0 )."...";
	echo "</td>\r\n\t\t<td title='";
	echo $email;
	echo "'>";
	echo strlen( $email ) <= 20 ? $email : substr( $email, 0, 20 ).chr( 0 )."...";
	echo "</td>\r\n\t\t<td title='";
	echo $tel_no_work;
	echo "'>";
	echo strlen( $tel_no_work ) <= 10 ? $tel_no_work : substr( $tel_no_work, 0, 10 ).chr( 0 )."...";
	echo "</td>\r\n\t\t<td>\r\n\t\t";
	if ( $manage_user == $_SESSION['LOGIN_USER_ID'] )
	{
		echo "\t\t<a href=\"javascript:edt('";
		echo $linkman_id;
		echo "');\">编辑 </a>\r\n        <a href=\"javascript:del('";
		echo $linkman_id;
		echo "','";
		echo $_REQUEST['customer_id'];
		echo "');\">删除 </a>\r\n\t\t";
	}
	echo "</td>\r\n\t</tr>\r\n";
}
echo "<center>";
if ( $count == 0 )
{
	message( "提示", "暂无记录" );
	exit( );
}
echo "</center>";
$sens = $_REQUEST['sens'] ? 0 : 1;
$sensimg = $_REQUEST['sens'] ? "arrow_up.gif" : "arrow_down.gif";
$sensimg = "/images/".$sensimg;
$sufurl = $_SERVER['PHP_SELF']."?sens=".$sens;
echo "\t<thead class=\"TableHeader\">\r\n\t\t<td width=\"3%\" align=\"center\" style=\"color:#FF0000;\" title=\"联系人状态\">!</td>\r\n\t\t<td><a href=\"";
echo $sufurl;
echo "&order=linkman_name&customer_id=";
echo $_REQUEST['customer_id'];
echo "\">联系人姓名";
if ( $_REQUEST['order'] == "linkman_name" )
{
	echo "<img src='".$sensimg."' border='0'>";
}
echo "</a></td>\r\n\t\t<td><a href=\"";
echo $sufurl;
echo "&order=mobile&customer_id=";
echo $_REQUEST['customer_id'];
echo "\">手机";
if ( $_REQUEST['order'] == "mobile" )
{
	echo "<img src='".$sensimg."' border='0'>";
}
echo "</a></td>\r\n\t\t<td><a href=\"";
echo $sufurl;
echo "&order=email&customer_id=";
echo $_REQUEST['customer_id'];
echo "\">Email";
if ( $_REQUEST['order'] == "email" )
{
	echo "<img src='".$sensimg."' border='0'>";
}
echo "</a></td>\r\n\t\t<td><a href=\"";
echo $sufurl;
echo "&order=tel_no_work&customer_id=";
echo $_REQUEST['customer_id'];
echo "\">电话";
if ( $_REQUEST['order'] == "tel_no_work" )
{
	echo "<img src='".$sensimg."' border='0'>";
}
echo "</a></td>\r\n\t\t<td width=\"9%\">操作</td>\r\n\t</thead>\r\n</table>\r\n<table width=\"100%\" border=\"0\" cellspacing=\"1\" cellpadding=\"5\">\r\n\t<tr>\r\n\t\t<td class=\"TableLine1\" nowrap align=\"right\">";
disp( "sens=".$_REQUEST['sens']."&order=".$_REQUEST['order']."&customer_id=".$_REQUEST['customer_id']."" );
echo "</td>\r\n\t</tr>\r\n</table>\r\n";
if ( 0 < ( $n = $_REQUEST['cur_page'] - $total_page_nums ) )
{
	$cur_page = $_REQUEST['cur_page'] - $n;
	header( "location:".$_SERVER['PHP_SELF']."?&order=".$_REQUEST['order']."&sens=".$_REQUEST['sens']."&cur_page=".$cur_page );
}
echo "</body>\r\n</html>";
?>
⌨️ 快捷键说明

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