/**
* 显示版面的情况
* @param: NULL
* @return: NULL
* @access: public
*/
public function run()
{
//取得用户的id
$user_id = UserUtil::getUserId($this->db, $_SESSION['user']['name']);
$smarty = $this->getSmarty();
//取得站点的公告，并显示在页面上
$is_have_post = false;
$post_str = '';
if (PostUtil::haveNotExpirePost($this->getDB())) {
$is_have_post = true;
$post_array = PostUtil::getPost($this->getDB(), 3);
foreach ($post_array as $post_rows) {
$post_str .= '<a href=\'index.php?module=post&action=view&id=' . $post_rows['id'] . '\' title=\'' . $post_rows['title'] . '\'>' . utf8_substr($post_rows['title'], 0, 35) . '</a>' . ' ';
}
}
$smarty->assign('have_system_post', $is_have_post);
$smarty->assign('post_str', $post_str);
//公告显示结束
$q = $this->getParameterFromGET('q');
$encode_q = $q;
//取得查询字符串
if (!$q) {
//取得用户最后一次的动作时间
$last_time = UserUtil::getUserLastLogoutTime($this->db, $user_id);
//生成一个where语句
$q = " where last_access_date >='" . $last_time . "'";
$encode_q = base64_encode($q);
} else {
$q = base64_decode($q);
}
$smarty->assign('encode_q', $encode_q);
//生成所有的记录数
$sql = 'select count(*) as num from bbs_subject ' . $q;
$res = $this->db->Execute($sql);
$rows = $res->FetchRow();
$total_number = $rows['num'];
//求总公的页面
$total_page = ceil($total_number / $this->page_number);
//取得当前的页面
$page = $this->getParameter('page');
if (!$page || $page < 0) {
$page = 1;
}
if ($page > $total_page && $total_page > 0) {
$page = $total_page;
}
$begin_page = 1;
$end_page = $total_page;
if ($page <= 10 && $total_page >= 10) {
$end_page = 10;
} else {
if ($page > 10) {
if ($page % 10 == 0) {
//向前翻
$end_page = $page;
$begin_page = $end_page - 9;
} else {
if ($page % 10 == 1) {
//向后翻
//确定开始的页数
$begin_page = $page;
if ($begin_page > $total_page) {
$begin_page = $page - 9;
}
if ($begin_page + 9 > $total_page) {
$end_page = $total_page;
} else {
$end_page = $begin_page + 9;
}
} else {
$num = $page % 10;
$pre_num = floor($page / 10);
$begin_page = $pre_num * 10 + 1;
$end_page = $begin_page + 9;
}
}
}
}
if ($end_page > $total_page) {
$end_page = $total_page;
}
$nav_page_array = array();
for ($i = $begin_page; $i <= $end_page; $i++) {
array_push($nav_page_array, $i);
}
//帖子导航栏
$smarty->assign('nav_page', $nav_page_array);
//当前的页面
$smarty->assign('now_page', $page);
//共有的页面
$smarty->assign('total_page', $total_page);
//显示搜索结果
//求出偏移
$offset_number = ($page - 1) * $this->page_number;
$subject_array = LayoutUtil::getCacheSubjectInfo($this->db, $this->page_number, $offset_number, $q);
if ($total_page > 0) {
$smarty->assign('subject', $subject_array);
$smarty->assign('have_subject', 1);
}
$smarty->display('viewnew.tmpl');
}
/**
* 显示版面的情况
* @param: NULL
* @return: NULL
* @access: public
*/
public function run()
{
//取得用户的id
$user_id = UserUtil::getUserId($this->db, $_SESSION['user']['name']);
$smarty = $this->getSmarty();
//取得站点的公告，并显示在页面上
$is_have_post = false;
$post_str = '';
if (PostUtil::haveNotExpirePost($this->getDB())) {
$is_have_post = true;
$post_array = PostUtil::getPost($this->getDB(), 3);
foreach ($post_array as $post_rows) {
$post_str .= '<a href=\'index.php?module=post&action=view&id=' . $post_rows['id'] . '\' title=\'' . $post_rows['title'] . '\'>' . utf8_substr($post_rows['title'], 0, 35) . '</a>' . ' ';
}
}
$smarty->assign('have_system_post', $is_have_post);
$smarty->assign('post_str', $post_str);
//公告显示结束
$q = $this->getParameterFromGET('q');
$encode_q = urlencode($q);
//取得查询字符串
if (!$q) {
$where_sql = '';
//收集查询的变量
//按关键字查询
$word = $this->getParameter('word');
//按用户名来查询
$find_user = $this->getParameter('user');
if (!$find_user && !$word) {
$this->AlertAndBack(SR_NO_FIND_KEYWORD);
return;
}
$word = ltrim($word);
$word = rtrim($word);
//按空格拆分关键字
$word_array = preg_split("/[\\s,]+/", $word);
//看用户的搜索是按关键字，还是按帖子的内容
$is_topic = $this->getParameter('wordtarget');
if ($is_topic != 1 && $is_topic != 2) {
$is_topic = 1;
}
$i = 0;
if (count($word_array) > 1) {
$where_sql .= " and ( ";
foreach ($word_array as $value) {
if ($is_topic == 1) {
$where_sql .= " title like '%" . $value . "%' ";
if ($i < count($word_array) - 1) {
$where_sql .= " or ";
}
} else {
if ($is_topic == 2) {
$where_sql .= " MATCH(content) AGAINST('" . $value . "') ";
if ($i < count($word_array) - 1) {
$where_sql .= " or ";
}
}
}
$i = $i + 1;
}
$where_sql .= " ) ";
} else {
if (count($word_array) == 1 && $word) {
if ($is_topic == 1) {
$where_sql .= " and title like '%" . $word . "%' ";
} else {
if ($is_topic == 2) {
$where_sql .= " and match(content) against('" . $word . "')";
}
}
}
}
//是按用户名来搜索的
//收集用户名
$find_user = ltrim($find_user);
$find_user = rtrim($find_user);
$find_user_array = preg_split("/[\\s,]+/", $find_user);
$is_match = $this->getParameter('usermatch');
$i = 0;
if (count($find_user_array) > 1) {
$where_sql .= " and ( ";
foreach ($find_user_array as $value) {
if ($is_match) {
$where_sql .= " author='" . $value . "' ";
if ($i < count($find_user_array) - 1) {
$where_sql .= " or ";
}
} else {
$where_sql .= " author like '%" . $value . "%' ";
if ($i < count($find_user_array) - 1) {
$where_sql .= " or ";
}
}
$i = $i + 1;
}
$where_sql .= " ) ";
} else {
if (count($find_user_array) == 1 && $find_user) {
if ($is_match) {
$where_sql .= " and author ='" . $find_user . "' ";
} else {
$where_sql .= " and author like '%" . $find_user . "%' ";
}
}
}
//再收集用户是否选择了论坛进行搜索。
$layout = $this->getParameterFromPOST('layout');
if ($layout && !is_array($layout)) {
$this->AlertAndBack(SR_SYSTEM_REQUEST_ERROR);
return;
}
$i = 0;
if (count($layout) > 1) {
$where_sql .= " and ( ";
foreach ($layout as $value) {
$where_sql .= " layout_id='" . $value . "' ";
if ($i < count($layout) - 1) {
$where_sql .= " or ";
}
$i = $i + 1;
}
$where_sql .= " ) ";
} else {
if (count($layout) == 1) {
$where_sql .= " and layout_id='" . $layout . "' ";
}
}
$q = ' where 1 ' . $where_sql;
$encode_q = base64_encode($q);
$encode_q = urlencode($encode_q);
} else {
// $q = urldecode($q);
$q = base64_decode($q);
}
//求总的total number
$smarty->assign('encode_q', $encode_q);
//生成所有的记录数
$sql = 'select count(*) as num from bbs_subject ' . $q;
$res = $this->db->Execute($sql);
$rows = $res->FetchRow();
$total_number = $rows['num'];
//求总公的页面
$total_page = ceil($total_number / $this->page_number);
//取得当前的页面
$page = $this->getParameter('page');
if (!$page || $page < 0) {
$page = 1;
}
if ($page > $total_page && $total_page > 0) {
$page = $total_page;
}
$begin_page = 1;
$end_page = $total_page;
if ($page <= 10 && $total_page >= 10) {
$end_page = 10;
} else {
if ($page > 10) {
if ($page % 10 == 0) {
//向前翻
$end_page = $page;
$begin_page = $end_page - 9;
} else {
if ($page % 10 == 1) {
//向后翻
//确定开始的页数
$begin_page = $page;
if ($begin_page > $total_page) {
$begin_page = $page - 9;
}
if ($begin_page + 9 > $total_page) {
$end_page = $total_page;
} else {
$end_page = $begin_page + 9;
}
} else {
$num = $page % 10;
$pre_num = floor($page / 10);
$begin_page = $pre_num * 10 + 1;
$end_page = $begin_page + 9;
}
}
}
}
if ($end_page > $total_page) {
$end_page = $total_page;
}
$nav_page_array = array();
for ($i = $begin_page; $i <= $end_page; $i++) {
array_push($nav_page_array, $i);
}
//帖子导航栏
$smarty->assign('nav_page', $nav_page_array);
//当前的页面
$smarty->assign('now_page', $page);
//共有的页面
$smarty->assign('total_page', $total_page);
//显示搜索结果
//求出偏移
$offset_number = ($page - 1) * $this->page_number;
$subject_array = LayoutUtil::getCacheSubjectInfo($this->db, $this->page_number, $offset_number, $q);
if ($total_page > 0) {
$smarty->assign('subject', $subject_array);
$smarty->assign('have_subject', 1);
}
$smarty->display('bbssearchresult.tmpl');
}
