public function getFrontVoteSubject()
{
$_sql = "select * from vote where state=1 and pid=0 order by id desc limit 1";
return parent::getFirstResult($_sql);
}
/**
* 1：通栏广告
* 2：banner
* 3：slider
* 4：sidebar
* @param string $_flag
* @return multitype: */
public function getFrontAd($_flag)
{
if ($_flag == 'banner') {
$_sql = "select * from ad where type=2 and state=1 order by id desc limit 1";
return parent::getFirstResult($_sql);
} elseif ($_flag == 'fullcolumn') {
$_sql = "select * from ad where type=1 and state=1 order by id desc limit 1";
return parent::getFirstResult($_sql);
} elseif ($_flag == 'sidebar') {
$_sql = "select * from ad where type=4 and state=1 order by id desc limit 1";
return parent::getFirstResult($_sql);
} elseif ($_flag == 'slider') {
$_sql = "select * from ad where type=3 and state=1 order by id desc limit " . SLIDER_NUM;
return parent::getAllResult($_sql);
}
}
public function getFirstCourse()
{
$_sql = "select * from course order by id desc ";
return parent::getFirstResult($_sql);
}