?? index.php
字號(hào):
<?php
function default_validate( )
{
global $connection;
global $customer_id;
global $customer_name;
global $manage_user;
$query2 = "select up.* from user_priv as up, user as u where up.USER_PRIV=u.USER_PRIV and u.USER_ID='".$manage_user."'";
$cursor2 = exequery( $connection, $query2 );
if ( $row2 = mysql_fetch_array( $cursor2 ) )
{
$priv_no = $row2['PRIV_NO'];
}
$query3 = "select up.* from user_priv as up, user as u where up.USER_PRIV=u.USER_PRIV and u.USER_ID='".$_SESSION['LOGIN_USER_ID']."'";
$cursor3 = exequery( $connection, $query3 );
if ( $row3 = mysql_fetch_array( $cursor3 ) )
{
$login_priv_no = $row3['PRIV_NO'];
}
if ( $login_priv_no < $priv_no )
{
$purview_ses = "<a href=\"#\" onclick=\"customer_detail('".$customer_id."');\">".$customer_name."</a>";
}
else
{
$purview_ses = false;
}
return $purview_ses;
}
function dept_validate( )
{
global $connection;
global $purview_dept;
if ( $purview_dept == "ALL_DEPT" )
{
return true;
}
$query2 = "select d.* from department as d, user as u where u.DEPT_ID=d.DEPT_ID and u.USER_ID='".$_SESSION['LOGIN_USER_ID']."'";
$cursor2 = exequery( $connection, $query2 );
if ( $row2 = mysql_fetch_array( $cursor2 ) )
{
$dept_id = $row2['DEPT_ID'];
}
if ( array_search( $dept_id, explode( ",", $purview_dept ) ) !== false )
{
return true;
}
else
{
return false;
}
}
function role_validate( )
{
global $connection;
global $purview_role;
$query2 = "select up.* from user_priv as up, user as u where up.USER_PRIV=u.USER_PRIV and u.USER_ID='".$_SESSION['LOGIN_USER_ID']."'";
$cursor2 = exequery( $connection, $query2 );
if ( $row2 = mysql_fetch_array( $cursor2 ) )
{
$login_priv_no = $row2['USER_PRIV'];
}
if ( array_search( $login_priv_no, explode( ",", $purview_role ) ) !== false )
{
return true;
}
else
{
return false;
}
}
function user_validate( )
{
global $connection;
global $purview_user;
if ( array_search( $_SESSION['LOGIN_USER_ID'], explode( ",", $purview_user ) ) !== false )
{
return true;
}
else
{
return false;
}
}
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'];
}
$query = "SELECT c.*, ct.*, l.* FROM customer as c, contact as ct, linkman as l WHERE ct.CUSTOMER_ID=c.CUSTOMER_ID and c.CUSTOMER_ID=l.CUSTOMER_ID group by ct.CONTACT_ID";
switch ( $_REQUEST['order'] )
{
case "contact_content" :
$query .= " order by ct.CONTACT_CONTENT";
break;
case "contact_date" :
$query .= " order by ct.CONTACT_DATE";
break;
case "customer_name" :
$query .= " order by c.CUSTOMER_NAME";
break;
case "linkman_name" :
$query .= " order by ct.LINKMAN_NAME";
break;
default :
$query .= " order by ct.CONTACT_ID";
break;
}
$query .= $_REQUEST['sens'] ? " ASC" : " DESC";
$cursor = exequery( $connection, $query );
while ( $row = mysql_fetch_array( $cursor ) )
{
$contact_id = $row['CONTACT_ID'];
$customer_id = $row['CUSTOMER_ID'];
$old_customer_name = $row['CUSTOMER_NAME'];
$linkman_name = $row['LINKMAN_NAME'];
$linkman_id = $row['LINKMAN_ID'];
$contact_content = $row['CONTACT_CONTENT'];
$contact_date = $row['CONTACT_DATE'];
$contact_date_end = $row['CONTACT_DATE_END'];
$create_user = $row['CREATE_USER'];
$manage_user = $row['MANAGE_USER'];
$purview = $row['PURVIEW'];
$purview_dept = $row['PURVIEW_DEPT'];
$purview_role = $row['PURVIEW_ROLE'];
$purview_user = $row['PURVIEW_USER'];
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
{
$str_contact_id .= $contact_id.",";
}
}
$str_contact_id = substr( $str_contact_id, 0, -1 );
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\tvar url\t= \"search.php\";\r\n\tlocation = url;\r\n}\r\n\r\nfunction del(contact_id)\r\n{\r\n\tvar msg\t= \"你確認(rèn)要?jiǎng)h除所選記錄嗎?\";\r\n\tif(window.confirm(msg))\r\n\t{\r\n\t\tvar url\t= \"delete.php?contact_id=\"+contact_id+\"&cur_page=";
echo $cur_page;
echo "&sens=";
echo $_REQUEST['sens'];
echo "&order=";
echo $_REQUEST['order'];
echo "&del_r=index_r\";\r\n\t\tlocation = url;\r\n\t}\r\n}\r\n\r\nfunction edt(contact_id, customer_id,linkman_id)\r\n{\r\n\tvar url\t= \"edit.php?contact_id=\"+contact_id+\"&linkman_id=\"+linkman_id+\"&customer_id=\"+customer_id+\"&cur_page=";
echo $cur_page;
echo "&sens=";
echo $_REQUEST['sens'];
echo "&order=";
echo $_REQUEST['order'];
echo "\";\r\n\tlocation = url;\r\n}\r\n\r\nfunction contact_detail(contact_id)\r\n{\r\n\tURL=\"detail.php?CONTACT_ID=\"+contact_id;\r\n\tmyleft=(screen.availWidth-500)/2;\r\n\twindow.open(URL,\"read_notify\",\"height=500,width=500,status=1,toolbar=no,menubar=no,location=no,scrollbars=yes,top=150,left=\"+myleft+\",resizable=yes\");\r\n}\r\n\r\nfunction customer_detail(customer_id)\r\n{\r\n\tvar url\t= \"../customer/detail.php?CUSTOMER_ID=\"+custo";
echo "mer_id;\r\n\twindow.open(url,\"\",\"height=650,width=900,status=1,toolbar=no,menubar=no,location=no,scrollbars=yes,top=30,left=30,resizable=yes\");\r\n}\r\n\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+\"";
echo ",resizable=yes\");\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=\"location='new.php';\" title=\"新建聯(lián)系人\"><table><tr valign=top ><td><img src=\"/images/littlegif/b";
echo "_u.gif\" align=\"center\"></td> <td>";
echo "<s";
echo "pan id=\"showallid\">新建交往信息</span></td></tr></table></BUTTON> <BUTTON class=btn onClick=\"search_click();\" title=\"查詢\"><table><tr valign=top ><td><img src=\"/images/littlegif/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";
$str_contact_id = $str_contact_id == "" ? 0 : $str_contact_id;
$query = "SELECT c.*, ct.*, l.LINKMAN_ID,l.LINKMAN_NAME FROM customer as c, contact as ct, linkman as l WHERE ct.CUSTOMER_ID=c.CUSTOMER_ID and c.CUSTOMER_ID=l.CUSTOMER_ID and ct.CONTACT_ID IN(".$str_contact_id.") and l.LINKMAN_ID=ct.LINKMAN_ID group by ct.CONTACT_ID";
switch ( $_REQUEST['order'] )
{
case "contact_content" :
$query .= " order by ct.CONTACT_CONTENT";
break;
case "contact_date" :
$query .= " order by ct.CONTACT_DATE";
break;
case "customer_name" :
$query .= " order by c.CUSTOMER_NAME";
break;
case "linkman_name" :
$query .= " order by ct.LINKMAN_NAME";
break;
default :
$query .= " order by ct.CONTACT_ID";
break;
}
$query .= $_REQUEST['sens'] ? " ASC" : " DESC";
$query = page( $query, 15 );
$cursor = exequery( $connection, $query );
$count = 0;
echo "<table border=\"0\" cellspacing=\"1\" width=\"100%\" cellpadding=\"5\" class=\"small\">\r\n";
while ( $row = mysql_fetch_array( $cursor ) )
{
++$count;
$contact_id = $row['CONTACT_ID'];
$customer_id = $row['CUSTOMER_ID'];
$old_customer_name = $row['CUSTOMER_NAME'];
$linkman_name = $row['LINKMAN_NAME'];
$linkman_id = $row['LINKMAN_ID'];
$contact_content = $row['CONTACT_CONTENT'];
$contact_date = $row['CONTACT_DATE'];
$contact_date_end = $row['CONTACT_DATE_END'];
$create_user = $row['CREATE_USER'];
$manage_user = $row['MANAGE_USER'];
$purview = $row['PURVIEW'];
$purview_dept = $row['PURVIEW_DEPT'];
$purview_role = $row['PURVIEW_ROLE'];
$purview_user = $row['PURVIEW_USER'];
$customer_name = strlen( $old_customer_name ) <= 35 ? $old_customer_name : substr( $old_customer_name, 0, 35 ).chr( 0 )."...";
if ( $count % 2 == 1 )
{
$TableLine = "TableLine1";
}
else
{
$TableLine = "TableLine2";
}
$length = 30;
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
{
if ( $create_user != "" )
{
$sqlcu = "SELECT USER_NAME FROM user WHERE USER_ID='".$create_user."'";
$rscu = exequery( $connection, $sqlcu );
$rowcu = mysql_fetch_array( $rscu );
$create_name = $rowcu['USER_NAME'];
}
else
{
$create_name = "";
}
echo "<tr class=\"";
echo $TableLine;
echo "\">\r\n\t\t<td title=\"";
echo $contact_content;
echo "\"><a href=\"#\" onClick=\"contact_detail('";
echo $contact_id;
echo "');\">";
echo strlen( $contact_content ) <= $length ? $contact_content : substr( $contact_content, 0, $length ).chr( 0 )."...";
echo "</a></td>\r\n\t\t<td title='";
echo $old_customer_name;
echo "'>";
echo $purview_ses;
echo "</td>\r\n\t\t<td><a href=\"#\" onClick=\"linkman_detail('";
echo $linkman_id;
echo "');\">";
echo $linkman_name;
echo "</a></td>\r\n\t\t<td>";
echo $contact_date." 至 ".$contact_date_end;
echo "</td>\r\n\t\t<td>";
echo $create_name;
echo "</td>\r\n\t\t<td>\r\n\t\t";
if ( $_SESSION['LOGIN_USER_ID'] == $create_user || $create_user == "" )
{
echo "\t\t<a href=\"javascript:edt('";
echo $contact_id;
echo "','";
echo $customer_id;
echo "','";
echo $linkman_id;
echo "');\">編輯 </a>\r\n <a href=\"javascript:del('";
echo $contact_id;
echo "');\">刪除 </a></td>\r\n\t\t";
}
echo "\t</tr>\r\n";
}
}
echo "<center>";
if ( $count == 0 )
{
message( "提示", "暫無(wú)記錄" );
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><a href=\"";
echo $sufurl;
echo "&order=contact_content&cur_page=";
echo $cur_page;
echo "\">交往內(nèi)容";
if ( $_REQUEST['order'] == "contact_content" )
{
echo "<img src='".$sensimg."' border='0'>";
}
echo "</a></td>\r\n\t\t<td><a href=\"";
echo $sufurl;
echo "&order=customer_name&cur_page=";
echo $cur_page;
echo "\">所屬客戶";
if ( $_REQUEST['order'] == "customer_name" )
{
echo "<img src='".$sensimg."' border='0'>";
}
echo "</a></td>\r\n\t\t<td><a href=\"";
echo $sufurl;
echo "&order=linkman_name&cur_page=";
echo $cur_page;
echo "\">聯(lián)系人";
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=contact_date&cur_page=";
echo $cur_page;
echo "\">交往日期";
if ( $_REQUEST['order'] == "contact_date" )
{
echo "<img src='".$sensimg."' border='0'>";
}
echo "</a></td>\r\n\t\t<td>創(chuàng)建人</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'] );
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";
?>
?? 快捷鍵說(shuō)明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -