index.php
来自「通达OA2007SE源代码 非常好的」· PHP 代码 · 共 395 行
PHP
395 行
<?
include_once 'inc/auth.php';
echo '
<html>
<head>
<title>通讯簿</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
';
echo '<s';
echo 'cript>
function add_detail(ADD_ID)
{
URL="add_detail.php?ADD_ID="+ADD_ID;
myleft=(screen.availWidth-500)/2;
window.open(URL,"detail","height=550,width=400,status=1,toolbar=no,menubar=no,location=no,scrollbars=yes,top=50,left="+myleft+",resizable=yes");
}
function delete_add(ADD_ID)
{
msg=\'确认要删除该联系人么?\';
if(window.confirm(msg))
{
URL="delete.php?ADD_ID=" + ADD_ID;
';
echo ' window.location=URL;
}
}
function check_all()
{
for (i=0;i<document.all("address_select").length;i++)
{
if(allbox.checked)
document.all("address_select").item(i).checked=true;
else
document.all("address_select").item(i).checked=false;
}
if(i==0)
{
if(allbox.checked)
document.all("address_select").checked=true;
else
document.all("addres';
echo 's_select").checked=false;
}
}
function check_one(el)
{
if(!el.checked)
allbox.checked=false;
}
function delete_address()
{
delete_str="";
for(i=0;i<document.all("address_select").length;i++)
{
el=document.all("address_select").item(i);
if(el.checked)
{ val=el.value;
delete_str+=val + ",";
}
}
if(i==0)
{
el=do';
echo 'cument.all("address_select");
if(el.checked)
{ val=el.value;
delete_str+=val + ",";
}
}
if(delete_str=="")
{
alert("要删除联系人,请至少选择其中一个。");
return;
}
msg=\'确认要删除所选联系人么?\';
if(window.confirm(msg))
{
url="delete.php?DELETE_STR="+ delete_str;
location=url;
}
}
function order_by(field,asc_desc';
echo ')
{
window.location="index.php?GROUP_ID=';
echo $GROUP_ID;
echo '&PUBLIC_FLAG=';
echo $PUBLIC_FLAG;
echo '&FIELD="+field+"&ASC_DESC="+asc_desc;
}
</script>
</head>
<body class="bodycolor" topmargin="5">
';
$query = (((''.'SELECT * from ADDRESS_GROUP where GROUP_ID=\'').$GROUP_ID).'\'');
$cursor = exequery ($connection, $query);
if ($ROW = mysql_fetch_array ($cursor))
{
$GROUP_NAME = $ROW['GROUP_NAME'];
}
if (($GROUP_ID == 0))
{
$GROUP_NAME = '默认';
}
if (($PUBLIC_FLAG == 0))
{
echo '<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
<tr>
<td class="Big"><img src="/images/menu/address.gif" align="absmiddle">';
echo '<s';
echo 'pan class="big3"> 新建联系人(';
echo $GROUP_NAME;
echo ')</span><br>
</td>
</tr>
</table>
<div align="center">
<input type="button" value="新建联系人" class="BigButton" onClick="location=\'new.php?GROUP_ID=';
echo $GROUP_ID;
echo '\';" title="在“';
echo $GROUP_NAME;
echo '”分组中创建新的联系人,录入相关信息">
</div>
<br>
<table width="95%" border="0" cellspacing="0" cellpadding="0" height="3">
<tr>
<td background="/images/dian1.gif" width="100%"></td>
</tr>
</table>
';
}
echo '<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
<tr>
<td class="Big"><img src="/images/menu/address.gif" align="absmiddle">';
echo '<s';
echo 'pan class="big3"> 管理联系人(';
echo $GROUP_NAME;
echo ')</span>
</td>
</tr>
</table>
<br>
';
if (($ASC_DESC == ''))
{
$ASC_DESC = '0';
}
if (($FIELD == ''))
{
$FIELD = 'PSN_NAME';
}
$query = (((((''.'SELECT * from ADDRESS where (USER_ID=\'').$LOGIN_USER_ID).'\' or USER_ID=\'\') and GROUP_ID=\'').$GROUP_ID).'\'');
($query .= ((''.' order by ').$FIELD));
if (($ASC_DESC == '1'))
{
($query .= ' desc');
}
else
{
($query .= ' asc');
}
if (($ASC_DESC == '0'))
{
$ORDER_IMG = '<img border=0 src="/images/arrow_up.gif" width="11" height="10">';
}
else
{
$ORDER_IMG = '<img border=0 src="/images/arrow_down.gif" width="11" height="10">';
}
$cursor = exequery ($connection, $query);
$ADD_COUNT = 0;
while ($ROW = mysql_fetch_array ($cursor))
{
++$ADD_COUNT;
$ADD_ID = $ROW['ADD_ID'];
$PSN_NAME = $ROW['PSN_NAME'];
$SEX = $ROW['SEX'];
$TEL_NO_DEPT = $ROW['TEL_NO_DEPT'];
$DEPT_NAME = $ROW['DEPT_NAME'];
$TEL_NO_HOME = $ROW['TEL_NO_HOME'];
$MOBIL_NO = $ROW['MOBIL_NO'];
$EMAIL = $ROW['EMAIL'];
$USER_ID = $ROW['USER_ID'];
if (($MOBIL_NO != ''))
{
($MOBIL_NO_STR .= ($MOBIL_NO.','));
}
if (($SEX == '0'))
{
$SEX = '男';
}
else
{
if (($SEX == '1'))
{
$SEX = '女';
}
else
{
$SEX = '';
}
}
if (($ADD_COUNT == 1))
{
echo '
<table border="0" cellspacing="1" width="95%" class="small" bgcolor="#000000" cellpadding="3">
';
}
echo ' <tr class="TableData">
<td align="center">
';
$MY_COUNT = 0;
if ((($PUBLIC_FLAG == 0) AND ($USER_ID == $LOGIN_USER_ID)))
{
++$MY_COUNT;
echo ' <input type="checkbox" name="address_select" value="';
echo $ADD_ID;
echo '" onClick="check_one(self);">
';
}
echo ' </td>
<td nowrap align="center"><a href="javascript:add_detail(\'';
echo $ADD_ID;
echo '\');">';
echo $PSN_NAME;
echo '</a></td>
<td nowrap align="center">';
echo $SEX;
echo '</td>
<td nowrap align="center">';
echo $DEPT_NAME;
echo '</td>
<td nowrap align="center">';
echo $TEL_NO_DEPT;
echo '</td>
<td nowrap align="center">';
echo $TEL_NO_HOME;
echo '</td>
<td nowrap align="center"><A href="/general/mobile_sms?TO_ID1=';
echo $MOBIL_NO;
echo ',">';
echo $MOBIL_NO;
echo '</A></td>
<td nowrap align="center"><a href="mailto:';
echo $EMAIL;
echo '">';
echo $EMAIL;
echo '</a></td>
<td nowrap align="center" width="100">
<a href="javascript:add_detail(\'';
echo $ADD_ID;
echo '\');"> 详情</a>
';
if ((($PUBLIC_FLAG == 0) AND ($USER_ID == $LOGIN_USER_ID)))
{
echo ' <a href="edit.php?ADD_ID=';
echo $ADD_ID;
echo '"> 编辑</a>
<a href="javascript:delete_add(';
echo $ADD_ID;
echo ');"> 删除</a>
';
}
echo ' </td>
</tr>
';
}
if (($ADD_COUNT == 0))
{
message ('', '通讯簿尚无记录');
exit ();
}
else
{
echo ' <thead class="TableHeader">
<td nowrap align="center">选择</td>
<td nowrap align="center" onclick="order_by(\'PSN_NAME\',\'';
if ((($FIELD == 'PSN_NAME') OR ($FIELD == '')))
{
echo (1 - $ASC_DESC);
}
else
{
echo '1';
}
echo '\');" style="cursor:hand;" width="30%"><u>姓名</u>';
if ((($FIELD == 'PSN_NAME') OR ($FIELD == '')))
{
echo $ORDER_IMG;
}
echo '</td>
<td nowrap align="center" onclick="order_by(\'SEX\',\'';
if (($FIELD == 'SEX'))
{
echo (1 - $ASC_DESC);
}
else
{
echo '1';
}
echo '\');" style="cursor:hand;"><u>性别</u>';
if (($FIELD == 'SEX'))
{
echo $ORDER_IMG;
}
echo '</td>
<td nowrap align="center" onclick="order_by(\'DEPT_NAME\',\'';
if (($FIELD == 'DEPT_NAME'))
{
echo (1 - $ASC_DESC);
}
else
{
echo '1';
}
echo '\');" style="cursor:hand;"><u>单位名称</u>';
if (($FIELD == 'DEPT_NAME'))
{
echo $ORDER_IMG;
}
echo '</td>
<td nowrap align="center">单位电话</td>
<td nowrap align="center">家庭电话</td>
<td nowrap align="center">手机 <a href="javascript:form1.submit();">群发</a></td>
<td nowrap align="center">电子邮件</td>
<td nowrap align="center">操作</td>
</thead>
';
$CUR_MON = date ('m', time ());
$CUR_DAY = date ('d', time ());
$query = ((((((''.'SELECT * from ADDRESS where USER_ID=\'').$LOGIN_USER_ID).'\' and Month(BIRTHDAY)=').$CUR_MON).' and DAYOFMONTH(BIRTHDAY)=').$CUR_DAY);
$cursor = exequery ($connection, $query);
$ADD_COUNT = 0;
while ($ROW = mysql_fetch_array ($cursor))
{
++$ADD_COUNT;
$ADD_ID = $ROW['ADD_ID'];
$PSN_NAME = $ROW['PSN_NAME'];
$SEX = $ROW['SEX'];
switch ($SEX)
{
case '0':
{
$SEX = '男';
break;
}
case '1':
{
$SEX = '女';
break;
}
}
($PERSON_STR .= (((((((''.'<A href=\'javascript:add_detail(').$ADD_ID).');\'>').$PSN_NAME).'(').$SEX).')</A>    '));
if (($ADD_COUNT == 1))
{
echo ' <tr class="TableData">
<td nowrap align="center" style="color:#46A718" >今天生日:</td>
<td nowrap align="center" colspan="20">
<marquee style="color:#FF6600;" behavior=scroll scrollamount=3 scrolldelay=120 onmouseover=\'this.stop()\' onmouseout=\'this.start()\' border=0>
';
echo $PERSON_STR;
echo ' </marquee>
</td>
</tr>
';
continue;
}
}
if ((($PUBLIC_FLAG == 0) AND ($MY_COUNT != 0)))
{
echo '<tr class="TableControl">
<td colspan="9">
<table width="100%" class="small">
<tr>
<td>
<input type="checkbox" name="allbox" id="allbox_for" onClick="check_all();"><label for="allbox_for">全选</label>
<input type="button" value="删除" class="SmallButton" onClick="delete_address();">
</tr>
</table>
</td>
</tr>
';
}
}
echo '
</table>
<form name="form1" method="post" action="/general/mobile_sms/new/index.php">
<input type="hidden" name="TO_ID1" value="';
echo $MOBIL_NO_STR;
echo '">
</form>
</body>
</html>';
?>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?