function dispalyManage($actionName, $lableTitle, $nPageSize, $addSql)
{
handlePower('显示' . $lableTitle);
//管理权限处理
loadWebConfig();
$content = '';
$i = '';
$s = '';
$c = '';
$fieldNameList = '';
$sql = '';
$action = '';
$x = '';
$url = '';
$nCount = '';
$nPage = '';
$idInputName = '';
$tableName = '';
$j = '';
$splxx = '';
$fieldName = '';
//字段名称
$splFieldName = '';
//分割字段
$searchfield = '';
$keyWord = '';
//搜索字段，搜索关键词
$parentid = '';
//栏目id
$replaceStr = '';
//替换字符
$tableName = lCase($actionName);
//表名称
$searchfield = @$_REQUEST['searchfield'];
//获得搜索字段值
$keyWord = @$_REQUEST['keyword'];
//获得搜索关键词值
if (@$_POST['parentid'] != '') {
$parentid = @$_POST['parentid'];
} else {
$parentid = @$_GET['parentid'];
}
$id = '';
$focusid = '';
//是判断传过来的id是否在当前列表中是交点20160715 home
$id = rq('id');
$focusid = rq('focusid');
$fieldNameList = getHandleFieldList($GLOBALS['db_PREFIX'] . $tableName, '字段列表');
$fieldNameList = specialStrReplace($fieldNameList);
//特殊字符处理
$splFieldName = aspSplit($fieldNameList, ',');
//字段分割成数组
//读模板
$content = getTemplateContent('manage_' . $tableName . '.html');
$action = getStrCut($content, '[list]', '[/list]', 2);
//网站栏目单独处理 栏目不一样20160301
if ($actionName == 'WebColumn') {
$action = getStrCut($content, '[action]', '[/action]', 1);
$content = replace($content, $action, showColumnList(-1, 'WebColumn', 'columnname', '', 0, $action));
} else {
if ($actionName == 'ListMenu') {
$action = getStrCut($content, '[action]', '[/action]', 1);
$content = replace($content, $action, showColumnList(-1, 'listmenu', 'title', '', 0, $action));
} else {
if ($keyWord != '' && $searchfield != '') {
$addSql = getWhereAnd(' where ' . $searchfield . ' like \'%' . $keyWord . '%\' ', $addSql);
}
if ($parentid != '') {
$addSql = getWhereAnd(' where parentid=' . $parentid . ' ', $addSql);
}
//call echo(tableName,addsql)
$sql = 'select * from ' . $GLOBALS['db_PREFIX'] . $tableName . ' ' . $addSql;
//检测SQL
if (checkSql($sql) == false) {
errorLog('出错提示：<br>action=' . $action . '<hr>sql=' . $sql . '<br>');
return '';
}
$rsObj = $GLOBALS['conn']->query($sql);
$nCount = @mysql_num_rows($rsObj);
$nPage = @$_REQUEST['page'];
$content = replace($content, '[$pageInfo$]', webPageControl($nCount, $nPageSize, $nPage, $url, ''));
$content = replace($content, '[$accessSql$]', $sql);
if (EDITORTYPE == 'asp') {
$x = getRsPageNumber($rs, $nCount, $nPageSize, $nPage);
//获得Rs页数 '记录总数
} else {
if ($nPage != '') {
$nPage = $nPage - 1;
}
$sql = 'select * from ' . $GLOBALS['db_PREFIX'] . '' . $tableName . ' ' . $addSql . ' limit ' . $nPageSize * $nPage . ',' . $nPageSize;
$rsObj = $GLOBALS['conn']->query($sql);
$x = @mysql_num_rows($rsObj);
}
for ($i = 1; $i <= $x; $i++) {
$rs = mysql_fetch_array($rsObj);
//给PHP用，因为在 asptophp转换不完善 特殊
$s = replace($action, '[$id$]', $rs['id']);
for ($j = 0; $j <= uBound($splFieldName); $j++) {
if ($splFieldName[$j] != '') {
$splxx = aspSplit($splFieldName[$j] . '|||', '|');
$fieldName = $splxx[0];
$replaceStr = $rs[$fieldName] . '';
//对文章旗处理
if ($fieldName == 'flags') {
$replaceStr = displayFlags($replaceStr);
}
//call echo("fieldname",fieldname)
//s = Replace(s, "[$" & fieldName & "$]", replaceStr)
$s = replaceValueParam($s, $fieldName, $replaceStr);
}
}
$idInputName = 'id';
$s = replace($s, '[$selectid$]', '<input type=\'checkbox\' name=\'' . $idInputName . '\' id=\'' . $idInputName . '\' value=\'' . $rs['id'] . '\' >');
$s = replace($s, '[$phpArray$]', '');
$url = '【NO】';
if ($actionName == 'ArticleDetail') {
$url = WEB_VIEWURL . '?act=detail&id=' . $rs['id'];
} else {
if ($actionName == 'OnePage') {
$url = WEB_VIEWURL . '?act=onepage&id=' . $rs['id'];
//给评论加预览=文章 20160129
} else {
if ($actionName == 'TableComment') {
$url = WEB_VIEWURL . '?act=detail&id=' . $rs['itemid'];
}
}
}
//必需有自定义字段
if (inStr($fieldNameList, 'customaurl') > 0) {
//自定义网址
if (aspTrim($rs['customaurl']) != '') {
$url = aspTrim($rs['customaurl']);
}
}
$s = replace($s, '[$viewWeb$]', $url);
$s = replaceValueParam($s, 'cfg_websiteurl', $GLOBALS['cfg_webSiteUrl']);
//call echo(focusid & "/" & rs("id"),IIF(focusid=cstr(rs("id")),"true","false"))
$s = replaceValueParam($s, 'focusid', $focusid);
$c = $c . $s;
}
$content = replace($content, '[list]' . $action . '[/list]', $c);
//表单提交处理，parentid(栏目ID) searchfield(搜索字段) keyword(关键词) addsql(排序)
$url = '?page=[id]&addsql=' . @$_REQUEST['addsql'] . '&keyword=' . @$_REQUEST['keyword'] . '&searchfield=' . @$_REQUEST['searchfield'] . '&parentid=' . @$_REQUEST['parentid'];
$url = getUrlAddToParam(getUrl(), $url, 'replace');
//call echo("url",url)
$content = replace($content, '[list]' . $action . '[/list]', $c);
}
}
if (inStr($content, '[$input_parentid$]') > 0) {
$action = '[list]<option value="[$id$]"[$selected$]>[$selectcolumnname$]</option>[/list]';
$c = '<select name="parentid" id="parentid"><option value="">≡ 选择栏目 ≡</option>' . showColumnList(-1, 'webcolumn', 'columnname', $parentid, 0, $action) . vbCrlf() . '</select>';
$content = replace($content, '[$input_parentid$]', $c);
//上级栏目
}
$content = replaceValueParam($content, 'searchfield', @$_REQUEST['searchfield']);
//搜索字段
$content = replaceValueParam($content, 'keyword', @$_REQUEST['keyword']);
//搜索关键词
$content = replaceValueParam($content, 'nPageSize', @$_REQUEST['nPageSize']);
//每页显示条数
$content = replaceValueParam($content, 'addsql', @$_REQUEST['addsql']);
//追加sql值条数
$content = replaceValueParam($content, 'tableName', $tableName);
//表名称
$content = replaceValueParam($content, 'actionType', @$_REQUEST['actionType']);
//动作类型
$content = replaceValueParam($content, 'lableTitle', @$_REQUEST['lableTitle']);
//动作标题
$content = replaceValueParam($content, 'id', $id);
//id
$content = replaceValueParam($content, 'page', @$_REQUEST['page']);
//页
$content = replaceValueParam($content, 'parentid', @$_REQUEST['parentid']);
//栏目id
$content = replaceValueParam($content, 'focusid', $focusid);
$url = getUrlAddToParam(getThisUrl(), '?parentid=&keyword=&searchfield=&page=', 'delete');
$content = replaceValueParam($content, 'position', '系统管理 > <a href=\'' . $url . '\'>' . $lableTitle . '列表</a>');
//position位置
$content = replace($content, '{$EDITORTYPE$}', EDITORTYPE);
//asp与phh
$content = replace($content, '{$WEB_VIEWURL$}', WEB_VIEWURL);
//前端浏览网址
$content = replace($content, '{$Web_Title$}', $GLOBALS['cfg_webTitle']);
$content = $content . stat2016(true);
$content = handleDisplayLanguage($content, 'handleDisplayLanguage');
//语言处理
Rw($content);
}
function getDetailList($action, $content, $actionName, $lableTitle, $fieldNameList, $nPageSize, $nPage, $addSql)
{
$GLOBALS['conn='] = OpenConn();
$defaultStr = '';
$i = '';
$s = '';
$c = '';
$tableName = '';
$j = '';
$splxx = '';
$sql = '';
$x = '';
$url = '';
$nCount = '';
$pageInfo = '';
$modI = '';
$startStr = '';
$endStr = '';
$fieldName = '';
//字段名称
$splFieldName = '';
//分割字段
$replaceStr = '';
//替换字符
$tableName = lCase($actionName);
//表名称
$listFileName = '';
//列表文件名称
$listFileName = RParam($action, 'listFileName');
$abcolorStr = '';
//A加粗和颜色
$atargetStr = '';
//A链接打开方式
$atitleStr = '';
//A链接的title20160407
$anofollowStr = '';
//A链接的nofollow
$id = '';
$idPage = '';
$id = rq('id');
checkIDSQL(@$_REQUEST['id']);
if ($fieldNameList == '*') {
$fieldNameList = getHandleFieldList($GLOBALS['db_PREFIX'] . $tableName, '字段列表');
}
$fieldNameList = specialStrReplace($fieldNameList);
//特殊字符处理
$splFieldName = aspSplit($fieldNameList, ',');
//字段分割成数组
$defaultStr = getStrCut($content, '<!--#body start#-->', '<!--#body end#-->', 2);
$pageInfo = getStrCut($content, '[page]', '[/page]', 1);
if ($pageInfo != '') {
$content = replace($content, $pageInfo, '');
}
//call eerr("pageInfo",pageInfo)
$sql = 'select * from ' . $GLOBALS['db_PREFIX'] . $tableName . ' ' . $addSql;
//检测SQL
if (checkSql($sql) == false) {
errorLog('出错提示：<br>sql=' . $sql . '<br>');
return '';
}
$rsObj = $GLOBALS['conn']->query($sql);
$rs = mysql_fetch_array($rsObj);
$nCount = @mysql_num_rows($rsObj);
//为动态翻页网址
if ($GLOBALS['isMakeHtml'] == true) {
$url = '';
if (len($listFileName) > 5) {
$url = mid($listFileName, 1, len($listFileName) - 5) . '[id].html';
$url = urlAddHttpUrl($GLOBALS['cfg_webSiteUrl'], $url);
}
} else {
$url = getUrlAddToParam(getUrl(), '?page=[id]', 'replace');
}
$content = replace($content, '[$pageInfo$]', webPageControl($nCount, $nPageSize, $nPage, $url, $pageInfo));
if (EDITORTYPE == 'asp') {
$x = getRsPageNumber($rs, $nCount, $nPageSize, $nPage);
//获得Rs页数 '记录总数
} else {
if ($nPage != '') {
$nPage = $nPage - 1;
}
$sql = 'select * from ' . $GLOBALS['db_PREFIX'] . '' . $tableName . ' ' . $addSql . ' limit ' . $nPageSize * $nPage . ',' . $nPageSize;
$rsObj = $GLOBALS['conn']->query($sql);
$rs = mysql_fetch_array($rsObj);
$x = @mysql_num_rows($rsObj);
}
//call echo("sql",sql)
for ($i = 1; $i <= $x; $i++) {
$rs = mysql_fetch_array($rsObj);
//给PHP用，因为在 asptophp转换不完善
$startStr = '[list-' . $i . ']';
$endStr = '[/list-' . $i . ']';
//在最后时排序当前交点20160202
if ($i == $x) {
$startStr = '[list-end]';
$endStr = '[/list-end]';
}
//例[list-mod2] [/list-mod2] 20150112
for ($modI = 6; $modI >= 2; $modI--) {
if (inStr($defaultStr, $startStr) == false && $i % $modI == 0) {
$startStr = '[list-mod' . $modI . ']';
$endStr = '[/list-mod' . $modI . ']';
if (inStr($defaultStr, $startStr) > 0) {
break;
}
}
}
//没有则用默认
if (inStr($defaultStr, $startStr) == false || $startStr == '') {
$startStr = '[list]';
$endStr = '[/list]';
}
if (inStr($defaultStr, $startStr) > 0 && inStr($defaultStr, $endStr) > 0) {
$s = StrCut($defaultStr, $startStr, $endStr, 2);
//s = defaultStr
$s = replace($s, '[$id$]', $rs['id']);
for ($j = 0; $j <= uBound($splFieldName); $j++) {
if ($splFieldName[$j] != '') {
$splxx = aspSplit($splFieldName[$j] . '|||', '|');
$fieldName = $splxx[0];
$replaceStr = $rs[$fieldName] . '';
$s = replaceValueParam($s, $fieldName, $replaceStr);
}
if ($GLOBALS['isMakeHtml'] == true) {
$url = getHandleRsUrl($rs['filename'], $rs['customaurl'], '/detail/detail' . $rs['id']);
} else {
$url = handleWebUrl('?act=detail&id=' . $rs['id']);
if ($rs['customaurl'] != '') {
$url = $rs['customaurl'];
}
}
//A链接添加颜色
$abcolorStr = '';
if (inStr($fieldNameList, ',titlecolor,') > 0) {
//A链接颜色
if ($rs['titlecolor'] != '') {
$abcolorStr = 'color:' . $rs['titlecolor'] . ';';
}
}
if (inStr($fieldNameList, ',flags,') > 0) {
//A链接加粗
if (inStr($rs['flags'], '|b|') > 0) {
$abcolorStr = $abcolorStr . 'font-weight:bold;';
}
}
if ($abcolorStr != '') {
$abcolorStr = ' style="' . $abcolorStr . '"';
}
//打开方式2016
if (inStr($fieldNameList, ',target,') > 0) {
$atargetStr = IIF($rs['target'] != '', ' target="' . $rs['target'] . '"', '');
}
//A的title
if (inStr($fieldNameList, ',title,') > 0) {
$atitleStr = IIF($rs['title'] != '', ' title="' . $rs['title'] . '"', '');
}
//A的nofollow
if (inStr($fieldNameList, ',nofollow,') > 0) {
$anofollowStr = IIF($rs['nofollow'] != 0, ' rel="nofollow"', '');
}
$s = replaceValueParam($s, 'url', $url);
$s = replaceValueParam($s, 'abcolor', $abcolorStr);
//A链接加颜色与加粗
$s = replaceValueParam($s, 'atitle', $atitleStr);
//A链接title
$s = replaceValueParam($s, 'anofollow', $anofollowStr);
//A链接nofollow
$s = replaceValueParam($s, 'atarget', $atargetStr);
//A链接打开方式
}
}
//call echo("tableName",tableName)
$idPage = getThisIdPage($GLOBALS['db_PREFIX'] . $tableName, $rs['id'], 10);
//【留言】
if ($tableName == 'guestbook') {
$url = WEB_ADMINURL . '?act=addEditHandle&actionType=GuestBook&lableTitle=留言&nPageSize=10&parentid=&searchfield=bodycontent&keyword=&addsql=&page=' . $idPage . '&id=' . $rs['id'] . '&n=' . getRnd(11);
//【默认显示文章】
} else {
$url = WEB_ADMINURL . '?act=addEditHandle&actionType=ArticleDetail&lableTitle=分类信息&nPageSize=10&page=' . $idPage . '&parentid=' . $rs['parentid'] . '&id=' . $rs['id'] . '&n=' . getRnd(11);
}
$s = handleDisplayOnlineEditDialog($url, $s, '', 'div|li|span');
$c = $c . $s;
}
$content = replace($content, '<!--#body start#-->' . $defaultStr . '<!--#body end#-->', $c);
if ($GLOBALS['isMakeHtml'] == true) {
$url = '';
if (len($listFileName) > 5) {
$url = mid($listFileName, 1, len($listFileName) - 5) . '[id].html';
$url = urlAddHttpUrl($GLOBALS['cfg_webSiteUrl'], $url);
}
} else {
$url = getUrlAddToParam(getUrl(), '?page=[id]', 'replace');
}
$getDetailList = $content;
return @$getDetailList;
}
