📄 signaturelist.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 "<html>\r\n<head>\r\n<title>签章管理</title>\r\n";
echo "<s";
echo "cript language=\"javascript\">\r\nfunction ConfirmDel(FileUrl){\r\n\tif (confirm('是否确定删除该签章！')){\r\n\t\tlocation.href=FileUrl;\r\n\t}\r\n}\r\n\r\nfunction DoMenu(MenuValue){\r\n    location.href=MenuValue;\r\n    return true;\r\n}\r\n\r\nfunction see_img(img_url){\twindow.open(img_url,'','height=600,width=800,top=30,left=30,status=yes,toolbar=no,menubar=no,location=no,scrollbars=yes,resizable=yes');\r\n\r\n\treturn true;\r\n";
echo "}\r\n</script>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\"></head>\r\n<body bgcolor=\"#ffffff\">\r\n<table border=\"0\" width=\"100%\" cellspacing=\"1\"  cellpadding=\"0\">\r\n   <tr class=\"tablehead1\">\r\n    <td ><img src=\"/images/workflow.gif\"  align=\"absmiddle\">签章管理\r\n    </td>\r\n  </tr>\r\n  <tr class=\"tablehead2\"><td>\r\n  <input type=\"image\" src=\"/images/button/addsign.gif\" border=\"0\" accesskey=\"N\" o";
echo "nclick=\"javascript:location.href='SignatureAddFrm.php'\" title=\"增加签章\">\r\n  \r\n  </td></tr>\r\n</table>\r\n<br>\r\n<table border=0  cellspacing='1' width=100% align=center class=\"small\" cellpadding=\"5\">\r\n";
$sens = $_REQUEST['sens'] ? 0 : 1;
$sensimg = $_REQUEST['sens'] ? "arrow_up.gif" : "arrow_down.gif";
$sensimg = "/images/".$sensimg;
$sufurl = $_SERVER['PHP_SELF']."?sens=".$sens;
echo "<tr class=\"TableHeader\">\r\n\t\t<td nowrap  ><a href=\"";
echo $sufurl;
echo "&order=MarkName&cur_page=";
echo $cur_page;
echo "\">印签名称";
if ( $_REQUEST['order'] == "MarkName" )
{
	echo "<img src='".$sensimg."' border='0'>";
}
echo "</a></td>\r\n\t\t<td nowrap  ><a href=\"";
echo $sufurl;
echo "&order=MarkFile&cur_page=";
echo $cur_page;
echo "\">印签组图";
if ( $_REQUEST['order'] == "MarkFile" )
{
	echo "<img src='".$sensimg."' border='0'>";
}
echo "</a></td>\r\n\t\t<td nowrap  ><a href=\"";
echo $sufurl;
echo "&order=USER_NAME&cur_page=";
echo $cur_page;
echo "\">所有者";
if ( $_REQUEST['order'] == "USER_NAME" )
{
	echo "<img src='".$sensimg."' border='0'>";
}
echo "</a></td>\r\n\t\t<td nowrap  >操作</td>\r\n</tr>\r\n\t";
$connection = openconnection( );
if ( $_SESSION['LOGIN_USER_PRIV'] == 1 )
{
	$query = "select S.SignatureID,S.UserName,S.MarkName,S.MarkType,S.MarkFile,U.USER_NAME from Signature S,USER U WHERE S.UserName = U.USER_ID";
}
else
{
	$query = "select S.SignatureID,S.UserName,S.MarkName,S.MarkType,S.MarkFile,U.USER_NAME from Signature S,USER U where UserName = '".$_SESSION['LOGIN_USER_ID']."' AND S.UserName = U.USER_ID";
}
switch ( $_REQUEST['order'] )
{
case "MarkName" :
	$query .= " order by S.MarkName";
	break;
case "MarkFile" :
	$query .= " order by S.MarkFile";
	break;
case "USER_NAME" :
	$query .= " order by U.USER_NAME";
	break;
default :
	$query .= " order by S.MarkName";
	break;
}
$query .= $_REQUEST['sens'] ? " DESC" : " ASC";
$query = page( $query, 15 );
$rs = mysql_query( $query );
$FLOW_COUNT = 0;
while ( $Row = mysql_fetch_array( $rs ) )
{
	$mSignatureID = $Row['SignatureID'];
	++$FLOW_COUNT;
	if ( $FLOW_COUNT % 2 == 1 )
	{
		$TableLine = "TableLine1";
	}
	else
	{
		$TableLine = "TableLine2";
	}
	$MarkFileUrl = "/attachment/".$Row['MarkFile'];
	if ( fopen( $_SERVER['DOCUMENT_ROOT'].$MarkFileUrl, "r" ) != false )
	{
		$see_img = "<br><a href='#' onclick=\"javascript:see_img('".$_SERVER['DOCUMENT_HOST'].$MarkFileUrl."');\">".$Row['MarkName'].$Row['MarkType']."</a>";
	}
	else
	{
		$see_img = "";
	}
	echo "\t<tr class=\"";
	echo $TableLine;
	echo "\">\t\t\r\n\t\t<td >";
	echo $Row['MarkName'];
	echo "&nbsp;</td>\r\n\t\t<td ><img border='0' src='";
	echo $_SERVER['DOCUMENT_HOST'].$MarkFileUrl;
	echo "' width='50' height='50'>&nbsp;";
	echo $see_img;
	echo "</td>\r\n\t\t<td >";
	echo $Row['USER_NAME'];
	echo "&nbsp;</td>\r\n\t\t<td  width=148 nowrap>\r\n\t\t\t<a href=\"SignatureEditFrm.php?SignatureID=";
	echo $mSignatureID;
	echo "\" >修改</a>\r\n\t\t\t<a href=\"#\" onclick=\"javascript:ConfirmDel('SignatureDel.php?SignatureID=";
	echo $mSignatureID;
	echo "');\">删除</a>\r\n\t\t</td>\r\n\t</tr>\r\n\t";
}
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']."&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";
?>
⌨️ 快捷键说明

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