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; }