-
蔬菜鮮果配送類網站織夢...
-
營銷型無縫鋼管定制生產...
-
食品百貨英文外貿類網站...
-
財稅記賬工商注冊認證類...
-
裝飾建材公司類網站織夢...
-
中英雙語律師事務所類網...
-
玩具動漫類網站織夢模板...
-
儀器儀表科技公司類網站...
-
水利工程施工類網站織夢...
-
鋼結構崗亭營銷型織夢網...
-
手游APP軟件下載類網站織...
-
儀器分析儀類網站織夢模...
-
電腦系統(tǒng)軟件下載類網站...
-
電子元件電路板類網站織...
-
人力資源管理類網站織夢...
-
精工機械軸承生產廠家類...
-
網站模板資源下載類網站...
-
展覽展會信息類網站織夢...
-
貂絨大衣服裝設計類網站...
-
物流快運速遞類網站織夢...
我們需要操作的就是修改織夢內核的文件
教程如下
打開include/arc.listview.class.php,找到:
//假如不消默認的sortrank或id排序,利用連系查詢(數據量大時很是遲鈍)if(preg_match('/hot|click|lastpost|title/', $orderby)){$query = "SELECT arc.*,tp.typedir,tp.typename,tp.isdefault,tp.defaultname,tp.namerule,tp.namerule2,tp.ispart,tp.moresite,tp.siteurl,tp.sitepath$addFieldFROM `js_archives` arcLEFT JOIN `js_arctype` tp ON arc.typeid=tp.id$addJoinWHERE {$this->addSql} $ordersql LIMIT $limitstart,$row";}//普通環(huán)境先從arctiny表查出ID,然后按ID查詢(速度很是快)else{$t1 = ExecTime();$ids = array();$query = "SELECT id FROM `js_arctiny` arc WHERE {$this->addSql} $ordersql LIMIT $limitstart,$row ";$this->dsql->SetQuery($query);$this->dsql->Execute();while($arr=$this->dsql->GetArray()){$ids[] = $arr['id'];}$idstr = join(',',$ids);if($idstr==''){return '';}else{$query = "SELECT arc.*,tp.typedir,tp.typename,tp.corank,tp.isdefault,tp.defaultname,tp.namerule,tp.namerule2,tp.ispart,tp.moresite,tp.siteurl,tp.sitepath$addFieldFROM `js_archives` arc LEFT JOIN `js_arctype` tp ON arc.typeid=tp.id$addJoinWHERE arc.id in($idstr) $ordersql ";}$t2 = ExecTime();//echo $t2-$t1;}
改成
if($orderby=="default"){$t1 = ExecTime();$ids = array();$query = "SELECT id FROM `js_arctiny` arc WHERE {$this->addSql} $ordersql LIMIT $limitstart,$row ";$this->dsql->SetQuery($query);$this->dsql->Execute();while($arr=$this->dsql->GetArray()){$ids[] = $arr['id'];}$idstr = join(',',$ids);if($idstr==''){return '';}else{$query = "SELECT arc.*,tp.typedir,tp.typename,tp.corank,tp.isdefault,tp.defaultname,tp.namerule,tp.namerule2,tp.ispart,tp.moresite,tp.siteurl,tp.sitepath$addFieldFROM `js_archives` arc LEFT JOIN `js_arctype` tp ON arc.typeid=tp.id$addJoinWHERE arc.id in($idstr) $ordersql ";}$t2 = ExecTime();//echo $t2-$t1;}else{$query = "SELECT arc.*,tp.typedir,tp.typename,tp.isdefault,tp.defaultname,tp.namerule,tp.namerule2,tp.ispart,tp.moresite,tp.siteurl,tp.sitepath$addFieldFROM `js_archives` arcLEFT JOIN `js_arctype` tp ON arc.typeid=tp.id$addJoinWHERE {$this->addSql} $ordersql LIMIT $limitstart,$row";}
再找到
else {$ordersql=" ORDER BY arc.sortrank $orderWay";}
改成
else if($orderby=="default"){$ordersql=" ORDER BY arc.sortrank $orderWay";}else{$ordersql=" ORDER BY ".$orderby.",arc.sortrank $orderWay";}
前端模板代碼如下
{dede:list pagesize='10' orderby='arc.title desc,arc.id'}