⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 list.php

📁 泛微协同办公系统标准版E-office V5.5的源代码内含泛微办公系统V5.5自动注册文件。
💻 PHP
📖 第 1 页 / 共 2 页
字号:
🔍
12 
	}
	else
	{
		$WHERE_STR .= " and MOBILE like '%".$MOBILE."%'";
	}
}
if ( $EMAIL != "" )
{
	if ( $WHERE_STR == "" )
	{
		$WHERE_STR .= " where EMAIL like '%".$EMAIL."%'";
	}
	else
	{
		$WHERE_STR .= " and EMAIL like '%".$EMAIL."%'";
	}
}
if ( $OICQ != "" )
{
	if ( $WHERE_STR == "" )
	{
		$WHERE_STR .= " where OICQ like '%".$OICQ."%'";
	}
	else
	{
		$WHERE_STR .= " and OICQ like '%".$OICQ."%'";
	}
}
if ( $ICQ != "" )
{
	if ( $WHERE_STR == "" )
	{
		$WHERE_STR .= " where ICQ like '%".$ICQ."%'";
	}
	else
	{
		$WHERE_STR .= " and ICQ like '%".$ICQ."%'";
	}
}
if ( $WHERE_STR != "" )
{
	$query = "SELECT * from LINKMAN ".$WHERE_STR." and LINKMAN_ID IN(".$str_LINKMAN_ID.")";
}
else
{
	$query = "SELECT * from LINKMAN WHERE LINKMAN_ID IN(".$str_LINKMAN_ID.")";
}
switch ( $_REQUEST['order'] )
{
case "linkman_name" :
	$query .= " order by LINKMAN_NAME";
	break;
case "sex" :
	$query .= " order by SEX";
	break;
case "birthday" :
	$query .= " order by BIRTHDAY";
	break;
case "tel_no_work" :
	$query .= " order by TEL_NO_WORK";
	break;
case "mobile" :
	$query .= " order by MOBILE";
	break;
case "email" :
	$query .= " order by EMAIL";
	break;
default :
	$query .= " order by LINKMAN_ID";
	break;
}
$query .= $_REQUEST['sens'] ? " ASC" : " DESC";
$query = page( $query, 15 );
$cursor = exequery( $connection, $query );
$sens = $_REQUEST['sens'] ? 0 : 1;
$sensimg = $_REQUEST['sens'] ? "arrow_up.gif" : "arrow_down.gif";
$sensimg = "/images/".$sensimg;
$sufurl = $_SERVER['PHP_SELF']."?sens=".$sens;
echo "<table border=\"0\" cellspacing=\"1\" width=\"100%\" class=\"small\" cellpadding=\"5\">\r\n  <tr class=\"TableHeader\">\r\n\t  <td width=\"3%\" align=\"center\" style=\"color:#FF0000;\" title=\"联系人状态\">!</td>\r\n      <td ><a href=\"";
echo $sufurl;
echo "&order=linkman_name&cur_page=";
echo $cur_page;
echo "&CUSTOMER_ID=";
echo $_REQUEST['CUSTOMER_ID'];
echo "&LINKMAN_NAME=";
echo $_REQUEST['LINKMAN_NAME'];
echo "&BIRTHDAY=";
echo $_REQUEST['BIRTHDAY'];
echo "&POST_PRIV=";
echo $_REQUEST['POST_PRIV'];
echo "&HOBBY=";
echo $_REQUEST['HOBBY'];
echo "&ADD_HOME=";
echo $_REQUEST['ADD_HOME'];
echo "&POSTALCODE_HOME=";
echo $_REQUEST['POSTALCODE_HOME'];
echo "&TEL_NO_WORK=";
echo $_REQUEST['TEL_NO_WORK'];
echo "&TEL_NO_HOME=";
echo $_REQUEST['TEL_NO_HOME'];
echo "&MOBILE=";
echo $_REQUEST['MOBILE'];
echo "&EMAIL=";
echo $_REQUEST['EMAIL'];
echo "&OICQ=";
echo $_REQUEST['OICQ'];
echo "&ICQ=";
echo $_REQUEST['ICQ'];
echo "\">姓名";
if ( $_REQUEST['order'] == "linkman_name" )
{
	echo "<img src='".$sensimg."' border='0'>";
}
echo "</a></td>\r\n      <td><a href=\"";
echo $sufurl;
echo "&order=sex&cur_page=";
echo $cur_page;
echo "&CUSTOMER_ID=";
echo $_REQUEST['CUSTOMER_ID'];
echo "&LINKMAN_NAME=";
echo $_REQUEST['LINKMAN_NAME'];
echo "&BIRTHDAY=";
echo $_REQUEST['BIRTHDAY'];
echo "&POST_PRIV=";
echo $_REQUEST['POST_PRIV'];
echo "&HOBBY=";
echo $_REQUEST['HOBBY'];
echo "&ADD_HOME=";
echo $_REQUEST['ADD_HOME'];
echo "&POSTALCODE_HOME=";
echo $_REQUEST['POSTALCODE_HOME'];
echo "&TEL_NO_WORK=";
echo $_REQUEST['TEL_NO_WORK'];
echo "&TEL_NO_HOME=";
echo $_REQUEST['TEL_NO_HOME'];
echo "&MOBILE=";
echo $_REQUEST['MOBILE'];
echo "&EMAIL=";
echo $_REQUEST['EMAIL'];
echo "&OICQ=";
echo $_REQUEST['OICQ'];
echo "&ICQ=";
echo $_REQUEST['ICQ'];
echo "\">性别";
if ( $_REQUEST['order'] == "sex" )
{
	echo "<img src='".$sensimg."' border='0'>";
}
echo "</a></td>\r\n      <td><a href=\"";
echo $sufurl;
echo "&order=birthday&cur_page=";
echo $cur_page;
echo "&CUSTOMER_ID=";
echo $_REQUEST['CUSTOMER_ID'];
echo "&LINKMAN_NAME=";
echo $_REQUEST['LINKMAN_NAME'];
echo "&BIRTHDAY=";
echo $_REQUEST['BIRTHDAY'];
echo "&POST_PRIV=";
echo $_REQUEST['POST_PRIV'];
echo "&HOBBY=";
echo $_REQUEST['HOBBY'];
echo "&ADD_HOME=";
echo $_REQUEST['ADD_HOME'];
echo "&POSTALCODE_HOME=";
echo $_REQUEST['POSTALCODE_HOME'];
echo "&TEL_NO_WORK=";
echo $_REQUEST['TEL_NO_WORK'];
echo "&TEL_NO_HOME=";
echo $_REQUEST['TEL_NO_HOME'];
echo "&MOBILE=";
echo $_REQUEST['MOBILE'];
echo "&EMAIL=";
echo $_REQUEST['EMAIL'];
echo "&OICQ=";
echo $_REQUEST['OICQ'];
echo "&ICQ=";
echo $_REQUEST['ICQ'];
echo "\">生日";
if ( $_REQUEST['order'] == "birthday" )
{
	echo "<img src='".$sensimg."' border='0'>";
}
echo "</a></td>\r\n      <td>所属客户</td>\r\n      <td><a href=\"";
echo $sufurl;
echo "&order=tel_no_work&cur_page=";
echo $cur_page;
echo "&CUSTOMER_ID=";
echo $_REQUEST['CUSTOMER_ID'];
echo "&LINKMAN_NAME=";
echo $_REQUEST['LINKMAN_NAME'];
echo "&BIRTHDAY=";
echo $_REQUEST['BIRTHDAY'];
echo "&POST_PRIV=";
echo $_REQUEST['POST_PRIV'];
echo "&HOBBY=";
echo $_REQUEST['HOBBY'];
echo "&ADD_HOME=";
echo $_REQUEST['ADD_HOME'];
echo "&POSTALCODE_HOME=";
echo $_REQUEST['POSTALCODE_HOME'];
echo "&TEL_NO_WORK=";
echo $_REQUEST['TEL_NO_WORK'];
echo "&TEL_NO_HOME=";
echo $_REQUEST['TEL_NO_HOME'];
echo "&MOBILE=";
echo $_REQUEST['MOBILE'];
echo "&EMAIL=";
echo $_REQUEST['EMAIL'];
echo "&OICQ=";
echo $_REQUEST['OICQ'];
echo "&ICQ=";
echo $_REQUEST['ICQ'];
echo "\">工作电话";
if ( $_REQUEST['order'] == "tel_no_work" )
{
	echo "<img src='".$sensimg."' border='0'>";
}
echo "</a></td>\r\n      <td><a href=\"";
echo $sufurl;
echo "&order=mobile&cur_page=";
echo $cur_page;
echo "&CUSTOMER_ID=";
echo $_REQUEST['CUSTOMER_ID'];
echo "&LINKMAN_NAME=";
echo $_REQUEST['LINKMAN_NAME'];
echo "&BIRTHDAY=";
echo $_REQUEST['BIRTHDAY'];
echo "&POST_PRIV=";
echo $_REQUEST['POST_PRIV'];
echo "&HOBBY=";
echo $_REQUEST['HOBBY'];
echo "&ADD_HOME=";
echo $_REQUEST['ADD_HOME'];
echo "&POSTALCODE_HOME=";
echo $_REQUEST['POSTALCODE_HOME'];
echo "&TEL_NO_WORK=";
echo $_REQUEST['TEL_NO_WORK'];
echo "&TEL_NO_HOME=";
echo $_REQUEST['TEL_NO_HOME'];
echo "&MOBILE=";
echo $_REQUEST['MOBILE'];
echo "&EMAIL=";
echo $_REQUEST['EMAIL'];
echo "&OICQ=";
echo $_REQUEST['OICQ'];
echo "&ICQ=";
echo $_REQUEST['ICQ'];
echo "\">手机";
if ( $_REQUEST['order'] == "mobile" )
{
	echo "<img src='".$sensimg."' border='0'>";
}
echo "</a></td>\r\n      <td><a href=\"";
echo $sufurl;
echo "&order=email&cur_page=";
echo $cur_page;
echo "&CUSTOMER_ID=";
echo $_REQUEST['CUSTOMER_ID'];
echo "&LINKMAN_NAME=";
echo $_REQUEST['LINKMAN_NAME'];
echo "&BIRTHDAY=";
echo $_REQUEST['BIRTHDAY'];
echo "&POST_PRIV=";
echo $_REQUEST['POST_PRIV'];
echo "&HOBBY=";
echo $_REQUEST['HOBBY'];
echo "&ADD_HOME=";
echo $_REQUEST['ADD_HOME'];
echo "&POSTALCODE_HOME=";
echo $_REQUEST['POSTALCODE_HOME'];
echo "&TEL_NO_WORK=";
echo $_REQUEST['TEL_NO_WORK'];
echo "&TEL_NO_HOME=";
echo $_REQUEST['TEL_NO_HOME'];
echo "&MOBILE=";
echo $_REQUEST['MOBILE'];
echo "&EMAIL=";
echo $_REQUEST['EMAIL'];
echo "&OICQ=";
echo $_REQUEST['OICQ'];
echo "&ICQ=";
echo $_REQUEST['ICQ'];
echo "\">电子邮件";
if ( $_REQUEST['order'] == "email" )
{
	echo "<img src='".$sensimg."' border='0'>";
}
echo "</a></td>\r\n      <td width='9%'>操作</td>\r\n  </tr>\r\n\r\n";
$LINKMAN_COUNT = 0;
while ( $ROW = mysql_fetch_array( $cursor ) )
{
	++$LINKMAN_COUNT;
	$LINKMAN_ID = $ROW['LINKMAN_ID'];
	$CUSTOMER_ID1 = $ROW['CUSTOMER_ID'];
	$LINKMAN_NAME1 = $ROW['LINKMAN_NAME'];
	$SEX1 = $ROW['SEX'];
	$BIRTHDAY1 = $ROW['BIRTHDAY'];
	$POST_PRIV1 = $ROW['POST_PRIV'];
	$HOBBY1 = $ROW['HOBBY'];
	$ADD_HOME1 = $ROW['ADD_HOME'];
	$POSTALCODE_HOME1 = $ROW['POSTALCODE_HOME'];
	$TEL_NO_WORK1 = $ROW['TEL_NO_WORK'];
	$TEL_NO_HOME1 = $ROW['TEL_NO_HOME'];
	$MOBILE1 = $ROW['MOBILE'];
	$EMAIL1 = $ROW['EMAIL'];
	$OICQ1 = $ROW['OICQ'];
	$ICQ1 = $ROW['ICQ'];
	$mostly_linkman = $ROW['MOSTLY_LINKMAN'];
	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'>";
	}
	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'>";
	}
	if ( $SEX1 == "0" )
	{
		$SEX_DESC = "男";
	}
	else
	{
		$SEX_DESC = "女";
	}
	$query2 = "SELECT * from customer where CUSTOMER_ID={$CUSTOMER_ID1}";
	$cursor2 = exequery( $connection, $query2 );
	if ( $ROW2 = mysql_fetch_array( $cursor2 ) )
	{
		$old_customer_name = $ROW2['CUSTOMER_NAME'];
		$manage_user = $ROW2['MANAGE_USER'];
		$customer_id = $ROW2['CUSTOMER_ID'];
		$manage_user = $ROW2['MANAGE_USER'];
		$purview = $ROW2['PURVIEW'];
		$purview_dept = $ROW2['PURVIEW_DEPT'];
		$purview_role = $ROW2['PURVIEW_ROLE'];
		$purview_user = $ROW2['PURVIEW_USER'];
	}
	$customer_name = strlen( $old_customer_name ) <= 15 ? $old_customer_name : substr( $old_customer_name, 0, 15 ).chr( 0 )."...";
	$query3 = "select USER_ID from USER where USER_ID='".$manage_user."'";
	$cursor3 = exequery( $connection, $query3 );
	if ( $row3 = mysql_fetch_row( $cursor3 ) )
	{
		$user_id = $row3[0];
	}
	if ( $LINKMAN_COUNT % 2 == 1 )
	{
		$TableLine = "TableLine1";
	}
	else
	{
		$TableLine = "TableLine2";
	}
	switch ( $purview )
	{
	case "1" :
		$purview_ses = default_validate( );
		break;
	case "2" :
		$purview_ses = "<a href=\"#\" onclick=\"customer_detail('".$customer_id."');\">".$customer_name."</a>";
		break;
	case "3" :
		$dept_validate = dept_validate( );
		$role_validate = role_validate( );
		$user_validate = user_validate( );
		if ( ( $dept_validate || $role_validate || $user_validate ) === false )
		{
			$purview_ses = default_validate( );
		}
		else
		{
			$purview_ses = "<a href=\"#\" onclick=\"customer_detail('".$customer_id."');\">".$customer_name."</a>";
		}
	}
	if ( $manage_user == $_SESSION['LOGIN_USER_ID'] || $manage_user == "" )
	{
		$purview_ses = "<a href=\"#\" onclick=\"customer_detail('".$customer_id."');\">".$customer_name."</a>";
	}
	if ( $purview_ses == false )
	{
	}
	else
	{
		$sqllm = "SELECT COUNT(LINKMAN_ID) AS cnt FROM contact WHERE LINKMAN_ID LIKE '".$LINKMAN_ID."'";
		$rslm = exequery( $connection, $sqllm );
		$rowlm = mysql_fetch_array( $rslm );
		$cntlm = $rowlm['cnt'];
		echo "\r\n    <tr class=\"";
		echo $TableLine;
		echo "\">\r\n\t  <td title=\"";
		echo $c_title;
		echo "\">";
		echo $c_img;
		echo "</td>\r\n      <td title='";
		echo $LINKMAN_NAME1;
		echo "'><a href=\"#\" onClick=\"linkman_detail('";
		echo $LINKMAN_ID;
		echo "')\">";
		echo strlen( $LINKMAN_NAME1 ) <= 30 ? $LINKMAN_NAME1 : substr( $LINKMAN_NAME1, 0, 30 ).chr( 0 )."...";
		echo "</a></td>\r\n      <td>";
		echo $SEX_DESC;
		echo "</td>\r\n      <td>";
		echo $BIRTHDAY1;
		echo "</td>\r\n      <td width='14%' title='";
		echo $old_customer_name;
		echo "'>";
		echo $purview_ses;
		echo "</td>\r\n      <td title='";
		echo $TEL_NO_WORK1;
		echo "'>";
		echo $TEL_NO_WORK1;
		echo "</td>\r\n      <td title='";
		echo $MOBILE1;
		echo "'>";
		echo strlen( $MOBILE1 ) <= 15 ? $MOBILE1 : substr( $MOBILE1, 0, 15 ).chr( 0 )."...";
		echo "</td>\r\n      <td title='";
		echo $EMAIL1;
		echo "'>";
		echo strlen( $EMAIL1 ) <= 15 ? $EMAIL1 : substr( $EMAIL1, 0, 15 ).chr( 0 )."...";
		echo "</td>\r\n      <td>\r\n\t  ";
		if ( $_SESSION['LOGIN_USER_ID'] == $manage_user || $manage_user == "" )
		{
			echo "\t  <a href=\"edit.php?linkman_id=";
			echo $LINKMAN_ID;
			echo "&edit_types=edit_types&sens=";
			echo $_REQUEST['sens'];
			echo "&order=";
			echo $_REQUEST['order'];
			echo "&cur_page=";
			echo $cur_page;
			echo "&CUSTOMER_ID=";
			echo $_REQUEST['CUSTOMER_ID'];
			echo "&LINKMAN_NAME=";
			echo $_REQUEST['LINKMAN_NAME'];
			echo "&BIRTHDAY=";
			echo $_REQUEST['BIRTHDAY'];
			echo "&POST_PRIV=";
			echo $_REQUEST['POST_PRIV'];
			echo "&HOBBY=";
			echo $_REQUEST['HOBBY'];
			echo "&ADD_HOME=";
			echo $_REQUEST['ADD_HOME'];
			echo "&POSTALCODE_HOME=";
			echo $_REQUEST['POSTALCODE_HOME'];
			echo "&TEL_NO_WORK=";
			echo $_REQUEST['TEL_NO_WORK'];
			echo "&TEL_NO_HOME=";
			echo $_REQUEST['TEL_NO_HOME'];
			echo "&MOBILE=";
			echo $_REQUEST['MOBILE'];
			echo "&EMAIL=";
			echo $_REQUEST['EMAIL'];
			echo "&OICQ=";
			echo $_REQUEST['OICQ'];
			echo "&ICQ=";
			echo $_REQUEST['ICQ'];
			echo "\">编辑 </a>\r\n\t  \t\t";
			if ( !( 0 < $cntlm ) )
			{
				echo "\t  <a href=\"javascript:delete_linkman(";
				echo $LINKMAN_ID;
				echo ");\">删除 </a>\r\n\t\t";
			}
			echo "\t  ";
		}
		echo "\t  </td>\r\n    </tr>\r\n";
	}
}
echo "<center>";
if ( $LINKMAN_COUNT == 0 )
{
	message( "提示", "暂无记录" );
	exit( );
}
echo "</center>";
echo "</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']."&cur_page=".$_REQUEST['cur_page']."&order=".$_REQUEST['order']."&CUSTOMER_ID2=".$_REQUEST['CUSTOMER_ID']."&LINKMAN_NAME2=".$_REQUEST['LINKMAN_NAME']."&BIRTHDAY=".$_REQUEST['BIRTHDAY']."&POST_PRIV=".$_REQUEST['POST_PRIV']."&HOBBY=".$_REQUEST['HOBBY']."&ADD_HOME=".$_REQUEST['ADD_HOME']."&POSTALCODE_HOME=".$_REQUEST['POSTALCODE_HOME']."&TEL_NO_WORK=".$_REQUEST['TEL_NO_WORK']."&TEL_NO_HOME=".$_REQUEST['TEL_NO_HOME']."&MOBILE=".$_REQUEST['MOBILE']."&EMAIL=".$_REQUEST['EMAIL']."&OICQ=".$_REQUEST['OICQ']."&ICQ=".$_REQUEST['ICQ']."" );
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>\r\n";
?>
12

⌨️ 快捷键说明

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