織夢所有文章列表看最新更新時間修改

2024-07-12 09:10:21

字體：大中小

來源：轉載

供稿：網友

第一步：找到織夢后臺默認的dede/templets里面分別覆蓋：dede/templets下面的這個文件：content_list.htm以及dede/這個目錄下面的：content_list.php

content_list.php：直接復制即可：

<?php

/**

* 內容列表

* content_s_list.php、content_i_list.php、content_select_list.php

* 均使用本文件作為實際處理代碼，只是使用的模板不同，如有相關變動，只需改本文件及相關模板即可

* @version $Id: content_list.php 1 14:31 2010年7月12日Z tianya $

* @package DedeCMS.Administrator

* @license http://help.dedecms.com/usersguide/license.html

* @link http://www.dedecms.com

require_once(dirname(__FILE__).'/config.php');

require_once(DEDEINC.'/typelink.class.php');

require_once(DEDEINC.'/datalistcp.class.php');

require_once(DEDEADMIN.'/inc/inc_list_functions.php');

$cid = isset($cid) ? intval($cid) : 0;

$channelid = isset($channelid) ? intval($channelid) : 0;

$mid = isset($mid) ? intval($mid) : 0;

if(!isset($keyword)) $keyword = '';

if(!isset($flag)) $flag = '';

if(!isset($arcrank)) $arcrank = '';

if(!isset($dopost)) $dopost = '';

//檢查權限許可，總權限

CheckPurview('a_List,a_AccList,a_MyList');

//欄目瀏覽許可

$userCatalogSql = '';

if(TestPurview('a_List'))

{

;

}

else if(TestPurview('a_AccList'))

{

if($cid==0 && $cfg_admin_channel == 'array')

{

$admin_catalog = join(',', $admin_catalogs);

$userCatalogSql = " arc.typeid IN($admin_catalog) ";

}

else

{

CheckCatalog($cid, '你無權瀏覽非指定欄目的內容！');

}

if(TestPurview('a_MyList')) $mid = $cuserLogin->getUserID();

}

$adminid = $cuserLogin->getUserID();

$maintable = 'zuimoban_archives';

setcookie('ENV_GOBACK_URL', $dedeNowurl, time()+3600, '/');

$tl = new TypeLink($cid);

//----------------------------------------

//在不指定排序條件和關鍵字的情況下直接統計微表

//----------------------------------------

if(empty($totalresult) && empty($keyword) && empty($orderby) && empty($flag))

{

$tinyQuerys = array();

if(!empty($userCatalogSql))

{

$tinyQuerys[] = str_replace('arc.', '', $userCatalogSql);

}

if(!empty($channelid) && empty($cid))

{

$tinyQuerys[] = " channel = '$channelid' ";

}

else

{

$tinyQuerys[] = " channel>0 ";

}

if(!empty($arcrank))

{

$tinyQuerys[] = " arcrank='$arcrank' ";

}

else

{

$tinyQuerys[] = " arcrank > -2 ";

}

if(!empty($mid))

{

$tinyQuerys[] = " mid='$mid' ";

}

if(!empty($cid))

{

$tinyQuerys[] = " typeid in(".GetSonIds($cid).") ";

}

if(count($tinyQuerys)>0)

{

$tinyQuery = "WHERE ".join(' AND ',$tinyQuerys);

}

// 緩存處理

$sql = "SELECT COUNT(*) AS dd FROM `zuimoban_arctiny` $tinyQuery ";

$cachekey = md5($sql);

$arr = GetCache('listcache', $cachekey);

if (empty($arr))

{

$arr = $dsql->GetOne($sql);

SetCache('listcache', $cachekey, $arr);

}

$totalresult = $arr['dd'];

}

if($cid==0)

{

if($channelid==0)

{

$positionname = '所有欄目>';

}

else

{

$row = $tl->dsql->GetOne("SELECT id,typename,maintable FROM `zuimoban_channeltype` WHERE id='$channelid'");

$positionname = $row['typename']." > ";

$maintable = $row['maintable'];

$channelid = $row['id'];

}

else

{

$positionname = str_replace($cfg_list_symbol," > ",$tl->GetPositionName())." > ";

}

//當選擇的是單表模型欄目時，直接跳轉到單表模型管理區

if(empty($channelid)

&& isset($tl->TypeInfos['channeltype']))

{

$channelid = $tl->TypeInfos['channeltype'];

}

if($channelid < -1 )

{

header("location:content_sg_list.php?cid=$cid&channelid=$channelid&keyword=$keyword");

exit();

}

// 欄目大于800則需要緩存數據

$optHash = md5($cid.$admin_catalogs.$channelid);

$optCache = DEDEDATA."/tplcache/inc_option_$optHash.inc";

$typeCount = 0;

if (file_exists($cache1)) require_once($cache1);

else $cfg_Cs = array();

$typeCount = count($cfg_Cs);

if ( $typeCount > 800)

{

if (file_exists($optCache))

{

$optionarr = file_get_contents($optCache);

} else {

$optionarr = $tl->GetOptionArray($cid, $admin_catalogs, $channelid);

file_put_contents($optCache, $optionarr);

}

} else {

$optionarr = $tl->GetOptionArray($cid, $admin_catalogs, $channelid);

}

$whereSql = empty($channelid) ? " WHERE arc.channel > 0 AND arc.arcrank > -2 " : " WHERE arc.channel = '$channelid' AND arc.arcrank > -2 ";

$flagsArr = '';

$dsql->Execute('f', 'SELECT * FROM `zuimoban_arcatt` ORDER BY sortid ASC');

while($frow = $dsql->GetArray('f'))

{

$flagsArr .= ($frow['att']==$flag ? "<option value='{$frow['att']}' selected>{$frow['attname']}</option> " : "<option value='{$frow['att']}'>{$frow['attname']}</option> ");

}

if(!empty($userCatalogSql))

{

$whereSql .= " AND ".$userCatalogSql;

}

if(!empty($mid))

{

$whereSql .= " AND arc.mid = '$mid' ";

}

if($keyword != '' && intval($keyword) > 1)

{

$whereSql .= " AND arc.dutyadmin LIKE '$keyword' ";

}

elseif($keyword != ''){

$whereSql .= " AND arc.title LIKE '%$keyword%' ";

}

if($flag != '')

{

$whereSql .= " AND FIND_IN_SET('$flag', arc.flag) ";

}

if($cid != 0)

{

$whereSql .= ' AND arc.typeid IN ('.GetSonIds($cid).')';

}

if($arcrank != '')

{

$whereSql .= " AND arc.arcrank = '$arcrank' ";

$CheckUserSend = "<input type='button' class='coolbg np' onClick="location='catalog_do.php?cid=".$cid."&dopost=listArchives&gurl=content_list.php';" value='所有文檔' />";

}

else

{

$CheckUserSend = "<input type='button' class='coolbg np' onClick="location='catalog_do.php?cid=".$cid."&dopost=listArchives&arcrank=-1&gurl=content_list.php';" value='稿件審核' />";

}

$orderby = empty($orderby) ? 'id' : preg_replace("#[^a-z0-9]#", "", $orderby);

$orderbyField = 'arc.'.$orderby;

$query = "SELECT arc.id,arc.typeid,arc.senddate,arc.flag,arc.ismake,

arc.channel,arc.arcrank,arc.click,arc.title,arc.color,arc.litpic,arc.pubdate,arc.mid,arc.dutyadmin

FROM `$maintable` arc

$whereSql

ORDER BY $orderbyField DESC";

if(empty($f) || !preg_match("#form#", $f)) $f = 'form1.arcid1';

//初始化

$dlist = new DataListCP();

$dlist->pageSize = 30;

//GET參數

$dlist->SetParameter('dopost', 'listArchives');

$dlist->SetParameter('keyword', $keyword);

if(!empty($mid)) $dlist->SetParameter('mid', $mid);

$dlist->SetParameter('cid', $cid);

$dlist->SetParameter('flag', $flag);

$dlist->SetParameter('orderby', $orderby);

$dlist->SetParameter('arcrank', $arcrank);

$dlist->SetParameter('channelid', $channelid);

$dlist->SetParameter('f', $f);

//模板

if(empty($s_tmplets)) $s_tmplets = 'templets/content_list.htm';

$dlist->SetTemplate(DEDEADMIN.'/'.$s_tmplets);

//查詢

$dlist->SetSource($query);

//顯示

$dlist->Display();

// echo $dlist->queryTime;

$dlist->Close();

content_list.htm：直接復制即可：

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<head>

</head>

<tr>

<tr>

{dede:if $adminid==$mid }

{else}

<input type='button' class="coolbg np" onClick="location='content_list.php?cid={dede:global.cid/}&mid=<?php echo $cuserLogin->getUserID(); ?>';" value='我的文檔' />

{/dede:if}

{dede:global.CheckUserSend/}

</td>

</tr>

</table>

</td>

</tr>

</table>

◆ {dede:global.positionname/}文檔列表  (使用鼠標右鍵彈出菜單)

</td>

</tr>