define('IN_ODINXU_SYSTEM', true);
include dirname(__FILE__) . '/include/config.php';
include SYSDIR_INCLUDE . '/smarty_init.php';
include SYSDIR_INCLUDE . '/class/database.php';
include SYSDIR_INCLUDE . '/class/cache.php';
$page = intval($_REQUEST['page']);
$page = max(1,$page);
$page = min(1000,$page);
$pagesize = 10;
$start = ($page -1) * $pagesize;
$db = ConnectDatabase($DB_CONFIG_DEDE_READ, false);
//获取投诉总数
$sql = "SELECT COUNT(`ID`) AS c FROM `dede_tousu` LIMIT 1";
$query = $db->sql_query($sql);
$row = $db->sql_fetchrow($query);
$total = $row['c'];
if($total>0)
{
//获取投诉列表
$sql = "SELECT `ID`,`Title`,`Content`,`AddTime` FROM `dede_tousu` ORDER BY `ID` DESC LIMIT {$start},{$pagesize}";
$rows = GetFromCacheOrFetchRowSet($sql);
if(is_array($rows) && !empty($rows))
{
foreach($rows as $k => $v)
{
$tousulist[$k]['Title'] = $v['Title'];
$tousulist[$k]['Desc'] = mb_strlen($v['Content'])>140 ? mb_substr($v['Content'],0,140,'GBK').'...' : $v['Content'];
$tousulist[$k]['AddTime'] = date('Y-m-d H:i:s',$v['AddTime']);
$tousulist[$k]['url'] = "/315/tousu_{$v['ID']}.htm";
}
}
$pagelist = getPages($page,$total);
}
//靓车展
$sql = "SELECT maintable.`id`,maintable.`title`,maintable.`typeid`,maintable.`senddate`,maintable.`ismake`,maintable.`arcrank`,maintable.`litpic`,maintable.`money`,maintable.`filename`,arctype.`namerule`,arctype.`typedir`,arctype.`moresite`,arctype.`siteurl`,arctype.`sitepath` ".
" FROM `dede_archives` maintable ".
" LEFT JOIN `dede_arctype` arctype ON arctype.id=maintable.typeid ".
" WHERE maintable.channel=1 AND maintable.arcrank!=-1 AND (arctype.`id` = 413 OR arctype.`topid` = 413) AND FIND_IN_SET('c',maintable.`flag`) AND FIND_IN_SET('p',maintable.`flag`) ".
" ORDER BY maintable.pubdate DESC ".
" LIMIT 0,4";
$rows = GetFromCacheOrFetchRowSet($sql);
if(is_array($rows) && !empty($rows))
{
foreach($rows as $k => $v)
{
$chezhanlist[$k]['title'] = $v['title'];
$chezhanlist[$k]['litpic'] = $v['litpic'];
$chezhanlist[$k]['arcurl'] = GetFileUrl($v["id"],$v["senddate"],$v["typedir"],$v['filename'],$v["siteurl"]);
}
}
//香车养女
$sql = "SELECT maintable.`id`,maintable.`title`,maintable.`typeid`,maintable.`senddate`,maintable.`ismake`,maintable.`arcrank`,maintable.`litpic`,maintable.`money`,maintable.`filename`,arctype.`namerule`,arctype.`typedir`,arctype.`moresite`,arctype.`siteurl`,arctype.`sitepath` ".
" FROM `dede_archives` maintable ".
" LEFT JOIN `dede_arctype` arctype ON arctype.id=maintable.typeid ".
" WHERE maintable.channel=1 AND maintable.arcrank!=-1 AND (arctype.`id` = 13 OR arctype.`topid` = 13) AND FIND_IN_SET('c',maintable.`flag`) AND FIND_IN_SET('p',maintable.`flag`) ".
" ORDER BY maintable.pubdate DESC ".
" LIMIT 0,4";
$rows = GetFromCacheOrFetchRowSet($sql);
if(is_array($rows) && !empty($rows))
{
foreach($rows as $k => $v)
{
$meinvlist[$k]['title'] = $v['title'];
$meinvlist[$k]['litpic'] = $v['litpic'];
$meinvlist[$k]['arcurl'] = 'http://car.qi-che.com/picture/girl_pic/s0/t15';
$p = $v['id'] % 8;
$p>0 && $meinvlist[$k]['arcurl'] .= "_p{$p}.html";
}
}
$db->sql_close();
$smarty->assign("chezhanlist", $chezhanlist);
$smarty->assign("meinvlist", $meinvlist);
$smarty->assign("tousulist", $tousulist);
$smarty->assign("pagelist", $pagelist);
$smarty->display('tousulist.tpl');
//分页
function getPages($page, $total, $pagesize = 10, $offset = 5) {
$total_page = (int)ceil($total / $pagesize);
$total_page = min(100,$total_page);
if ($total_page < 2)
return null;
$start = ($page > $offset) ? ($page - $offset) : 1;
$end = $start + $offset * 2;
if ($end > $total_page)
{
$end = $total_page;
$start = $end - $offset * 2;
$start = max(1,$start);
}
$url_format = '/315/tousu_list_%d.htm';
$pageer = '';
if($page>1)
{
$pager .= "首页";
$pager .= "上页";
}
else
{
$pager .= "首页";
$pager .= "上页";
}
for ($i = $start; $i <= $end; $i++)
{
if ($i == $page)
{
$pager .= "{$i}";
}
else
{
$pager .= "{$i}";
}
}
if($page<$total_page)
{
$pager .= "下页";
$pager .= "末页";
}
else
{
$pager .= "下页";
$pager .= "末页";
}
return $pager;
}
//栏目目录规则
function MfTypedir($typedir)
{
$typedir = str_replace("{cmspath}",'',$typedir);
$typedir = ereg_replace("/{1,}","/",$typedir);
$typedir = rtrim($typedir,'/') . '/';
return $typedir;
}
//获得文章链接
function GetFileUrl($id,$senddate,$typedir,$filename,$siteurl)
{
$url = $siteurl ? $siteurl : 'http://www.qi-che.com';
$typedir = MfTypedir($typedir);
$url .= $typedir;
if($filename)
{
$url .= $filename;
}
else
{
$url .= date('Ymd',$senddate) . $id;
}
$url .= '.html';
return $url;
}
?>