public function index() { global_run(); init_app_page(); $GLOBALS['tmpl']->assign("no_nav", true); //无分类下拉 $id = intval($_REQUEST['id']); require_once APP_ROOT_PATH . 'system/model/topic.php'; $topic = get_topic_item($id); if ($id > 0 && !empty($topic)) { // } else { app_redirect(url("index")); } if ($topic['group_id'] > 0) { $GLOBALS['tmpl']->assign('topic_group', get_topic_group($topic['group_id'])); } $title = $topic['forum_title']; $content = decode_topic($topic['content']); $is_fav = $GLOBALS['db']->getOne("select count(*) from " . DB_PREFIX . "topic where (fav_id = " . $id . " or (origin_id = " . $id . " and fav_id <> 0)) and user_id = " . intval($GLOBALS['user_info']['id'])); $GLOBALS['tmpl']->assign("topic", $topic); $GLOBALS['tmpl']->assign("title", $title); $GLOBALS['tmpl']->assign("content", $content); $GLOBALS['tmpl']->assign("is_fav", $is_fav); $GLOBALS['tmpl']->assign("page_title", $title); $GLOBALS['tmpl']->assign("page_keyword", $title . ","); $GLOBALS['tmpl']->assign("page_description", $title . ","); $GLOBALS['tmpl']->assign('user_auth', get_user_auth()); $GLOBALS['tmpl']->display("topic_index.html"); }
public function index() { global_run(); init_app_page(); $GLOBALS['tmpl']->assign("no_nav", true); //无分类下拉 $GLOBALS['tmpl']->caching = true; $GLOBALS['tmpl']->cache_lifetime = 600; //缓存10分钟 $cache_id = md5(MODULE_NAME . ACTION_NAME); if (!$GLOBALS['tmpl']->is_cached('daren_index.html', $cache_id)) { require_once APP_ROOT_PATH . 'system/model/topic.php'; $title = $GLOBALS['lang']['DAREN_SHOW']; $site_nav[] = array('name' => $GLOBALS['lang']['HOME_PAGE'], 'url' => url("index", "index")); $site_nav[] = array('name' => $title, 'url' => url("index", "daren")); $GLOBALS['tmpl']->assign("site_nav", $site_nav); $user_id = intval($GLOBALS['user_info']['id']); //输出所有达人推荐 $rnd_daren_list = get_rand_user(42, 1); $GLOBALS['tmpl']->assign("rnd_daren_list", $rnd_daren_list); $daren_list = get_rand_user(8, 1); foreach ($daren_list as $kk => $vv) { $focus_uid = intval($vv['id']); $focus_data = $GLOBALS['db']->getRow("select * from " . DB_PREFIX . "user_focus where focus_user_id = " . $user_id . " and focused_user_id = " . $focus_uid); if ($focus_data) { $daren_list[$kk]['focused'] = 1; } } $GLOBALS['tmpl']->assign("daren_list", $daren_list); //获取推荐的 达人分享6条 $topic_list = get_topic_list(6, array("cid" => 0, "tag" => ""), "", "is_recommend = 1"); $topic_list = $topic_list['list']; //$topic_list = $GLOBALS['db']->getAll("select t.* from ".DB_PREFIX."topic as t where t.is_effect = 1 and t.is_delete = 0 and t.is_recommend = 1 order by t.create_time desc limit 6"); foreach ($topic_list as $kk => $vv) { $vv['content'] = msubstr($vv['content'], 0, 30); $topic_list[$kk] = format_topic_item($vv); $topic_list[$kk]['content'] = decode_topic($topic_list[$kk]['content']); $topic_user_info = $GLOBALS['db']->getRow("select * from " . DB_PREFIX . "user where id = " . $vv['user_id'] . " and is_effect =1 and is_delete = 0"); $focus_uid = intval($topic_user_info['id']); $focus_data = $GLOBALS['db']->getRow("select * from " . DB_PREFIX . "user_focus where focus_user_id = " . $user_id . " and focused_user_id = " . $focus_uid); if ($focus_data) { $topic_user_info['focused'] = 1; } $topic_list[$kk]['user_info'] = $topic_user_info; } $GLOBALS['tmpl']->assign("topic_list", $topic_list); $cate_list = $GLOBALS['db']->getAll("select * from " . DB_PREFIX . "topic_tag_cate where showin_web = 1 order by sort asc limit 7"); foreach ($cate_list as $k => $v) { //获取分类下的推荐分享 $cate_list[$k]['topic_list'] = get_topic_list(4, array("cid" => 0, "tag" => ""), " left join " . DB_PREFIX . "topic_cate_link as l on l.topic_id = t.id ", "l.cate_id = " . $v['id'] . " and t.is_recommend = 1"); $cate_list[$k]['topic_list'] = $cate_list[$k]['topic_list']['list']; //$cate_list[$k]['topic_list'] = $GLOBALS['db']->getAll("select t.* from ".DB_PREFIX."topic as t left join ".DB_PREFIX."topic_cate_link as l on l.topic_id = t.id where l.cate_id = ".$v['id']." and t.is_effect = 1 and t.is_delete = 0 and t.is_recommend = 1 order by t.create_time desc limit 4"); foreach ($cate_list[$k]['topic_list'] as $kk => $vv) { $vv['content'] = msubstr($vv['content'], 0, 30); $cate_list[$k]['topic_list'][$kk] = format_topic_item($vv); $cate_list[$k]['topic_list'][$kk]['content'] = decode_topic($cate_list[$k]['topic_list'][$kk]['content']); $topic_user_info = $GLOBALS['db']->getRow("select * from " . DB_PREFIX . "user where id = " . $vv['user_id'] . " and is_effect =1 and is_delete = 0"); $focus_uid = intval($topic_user_info['id']); $focus_data = $GLOBALS['db']->getRow("select * from " . DB_PREFIX . "user_focus where focus_user_id = " . $user_id . " and focused_user_id = " . $focus_uid); if ($focus_data) { $topic_user_info['focused'] = 1; } $cate_list[$k]['topic_list'][$kk]['user_info'] = $topic_user_info; } $cate_list[$k]['daren_list'] = $GLOBALS['db']->getAll("select u.* from " . DB_PREFIX . "user as u left join " . DB_PREFIX . "user_cate_link as l on l.user_id = u.id where l.cate_id = " . $v['id'] . " and u.is_effect = 1 and u.is_delete = 0 and u.is_daren = 1 order by rand() limit 8"); foreach ($cate_list[$k]['daren_list'] as $kk => $vv) { $focus_uid = intval($vv['id']); $focus_data = $GLOBALS['db']->getRow("select * from " . DB_PREFIX . "user_focus where focus_user_id = " . $user_id . " and focused_user_id = " . $focus_uid); if ($focus_data) { $cate_list[$k]['daren_list'][$kk]['focused'] = 1; } } //print_r($cate_list);exit; } $GLOBALS['tmpl']->assign("cate_list", $cate_list); $GLOBALS['tmpl']->assign("page_title", $title); $GLOBALS['tmpl']->assign("page_keyword", $title . ","); $GLOBALS['tmpl']->assign("page_description", $title . ","); } $GLOBALS['tmpl']->display("daren_index.html", $cache_id); }
public function index() { $GLOBALS['tmpl']->caching = true; $GLOBALS['tmpl']->cache_lifetime = 600; //缓存10分钟 $cache_id = md5(MODULE_NAME . ACTION_NAME . $GLOBALS['deal_city']['id']); if (!$GLOBALS['tmpl']->is_cached('daren_index.html', $cache_id)) { $title = $GLOBALS['lang']['DAREN_SHOW']; $site_nav[] = array('name' => $GLOBALS['lang']['HOME_PAGE'], 'url' => APP_ROOT . "/"); $site_nav[] = array('name' => $title, 'url' => url("shop", "daren")); $GLOBALS['tmpl']->assign("site_nav", $site_nav); $GLOBALS['tmpl']->assign("page_title", $title); $GLOBALS['tmpl']->assign("page_keyword", $title . ","); $GLOBALS['tmpl']->assign("page_description", $title . ","); $user_id = intval($GLOBALS['user_info']['id']); //输出所有达人推荐 $rnd_daren_list = get_rand_user(42, 1); $GLOBALS['tmpl']->assign("rnd_daren_list", $rnd_daren_list); $daren_list = get_rand_user(8, 1); foreach ($daren_list as $kk => $vv) { $focus_uid = intval($vv['id']); $focus_data = $GLOBALS['db']->getRow("select * from " . DB_PREFIX . "user_focus where focus_user_id = " . $user_id . " and focused_user_id = " . $focus_uid); if ($focus_data) { $daren_list[$kk]['focused'] = 1; } } $GLOBALS['tmpl']->assign("daren_list", $daren_list); $topic_list = $GLOBALS['db']->getAll("select t.* from " . DB_PREFIX . "topic as t where t.is_effect = 1 and t.is_delete = 0 and t.is_recommend = 1 order by t.create_time desc limit 6"); foreach ($topic_list as $kk => $vv) { $vv['content'] = msubstr($vv['content'], 0, 30); $topic_list[$kk] = get_topic_item($vv); $topic_user_info = $GLOBALS['db']->getRow("select * from " . DB_PREFIX . "user where id = " . $vv['user_id'] . " and is_effect =1 and is_delete = 0"); $focus_uid = intval($topic_user_info['id']); $focus_data = $GLOBALS['db']->getRow("select * from " . DB_PREFIX . "user_focus where focus_user_id = " . $user_id . " and focused_user_id = " . $focus_uid); if ($focus_data) { $topic_user_info['focused'] = 1; } $topic_list[$kk]['user_info'] = $topic_user_info; } $GLOBALS['tmpl']->assign("topic_list", $topic_list); $cate_list = $GLOBALS['db']->getAll("select * from " . DB_PREFIX . "topic_tag_cate where showin_web = 1 order by sort desc limit 7"); foreach ($cate_list as $k => $v) { //获取分类下的推荐分享 $cate_list[$k]['topic_list'] = $GLOBALS['db']->getAll("select t.* from " . DB_PREFIX . "topic as t left join " . DB_PREFIX . "topic_cate_link as l on l.topic_id = t.id where l.cate_id = " . $v['id'] . " and t.is_effect = 1 and t.is_delete = 0 and t.is_recommend = 1 order by t.create_time desc limit 4"); foreach ($cate_list[$k]['topic_list'] as $kk => $vv) { $vv['content'] = msubstr($vv['content'], 0, 30); $cate_list[$k]['topic_list'][$kk] = get_topic_item($vv); $topic_user_info = $GLOBALS['db']->getRow("select * from " . DB_PREFIX . "user where id = " . $vv['user_id'] . " and is_effect =1 and is_delete = 0"); $focus_uid = intval($topic_user_info['id']); $focus_data = $GLOBALS['db']->getRow("select * from " . DB_PREFIX . "user_focus where focus_user_id = " . $user_id . " and focused_user_id = " . $focus_uid); if ($focus_data) { $topic_user_info['focused'] = 1; } $cate_list[$k]['topic_list'][$kk]['user_info'] = $topic_user_info; } $cate_list[$k]['daren_list'] = $GLOBALS['db']->getAllCached("select u.* from " . DB_PREFIX . "user as u left join " . DB_PREFIX . "user_cate_link as l on l.user_id = u.id where l.cate_id = " . $v['id'] . " and u.is_effect = 1 and u.is_delete = 0 and u.is_daren = 1 order by rand() limit 8"); foreach ($cate_list[$k]['daren_list'] as $kk => $vv) { $focus_uid = intval($vv['id']); $focus_data = $GLOBALS['db']->getRow("select * from " . DB_PREFIX . "user_focus where focus_user_id = " . $user_id . " and focused_user_id = " . $focus_uid); if ($focus_data) { $cate_list[$k]['daren_list'][$kk]['focused'] = 1; } } } $GLOBALS['tmpl']->assign("cate_list", $cate_list); $daren_html = decode_topic($GLOBALS['tmpl']->fetch("inc/daren_show_item.html")); $GLOBALS['tmpl']->assign("daren_html", $daren_html); } $GLOBALS['tmpl']->display("daren_index.html", $cache_id); }
function load_reply_list() { return decode_topic($GLOBALS['tmpl']->fetch("inc/topic_page_reply_list.html")); }
public function detail() { $dp_id = intval($_REQUEST['id']); $page = intval($_REQUEST['p']); $review_item = $GLOBALS['db']->getRow("select * from " . DB_PREFIX . "supplier_location_dp where id = " . $dp_id); if (!$review_item) { app_redirect(url("index", "index")); } //验证是否为当前商家会员管理的点评 $s_account_info = es_session::get("account_info"); if (in_array($review_item['supplier_location_id'], $s_account_info['location_ids']) && $review_item['from_data'] != "") { $is_admin = 1; $GLOBALS['tmpl']->assign("is_admin", $is_admin); } $review_item = sys_get_dp_detail($review_item); $store_info = $GLOBALS['db']->getRow("select * from " . DB_PREFIX . "supplier_location where id = " . $review_item['supplier_location_id']); //供应商的地址列表 //定义location_id $locations = $GLOBALS['db']->getAll("select * from " . DB_PREFIX . "supplier_location where id = " . $review_item['supplier_location_id']); $json_location = array(); $location_ids = array(0); foreach ($locations as $litem) { $location_ids[] = $litem['id']; $arr = array(); $arr['title'] = $litem['name']; $arr['address'] = $litem['address']; $arr['tel'] = $litem['tel']; $arr['lng'] = $litem['xpoint']; $arr['lat'] = $litem['ypoint']; $json_location[] = $arr; } $GLOBALS['tmpl']->assign("json_location", json_encode($json_location)); $GLOBALS['tmpl']->assign("locations", $locations); $GLOBALS['tmpl']->assign("store_info", $store_info); //输出回应列表 $sql_count = "select count(*) from " . DB_PREFIX . "supplier_location_dp_reply where dp_id = " . $dp_id; $count = $GLOBALS['db']->getOne($sql_count); $page_size = app_conf("PAGE_SIZE"); if ($page == 0) { $page = 1; } $limit = ($page - 1) * $page_size . "," . $page_size; $sql = "select * from " . DB_PREFIX . "supplier_location_dp_reply where dp_id = " . $dp_id . " order by create_time desc limit " . $limit; $reply_list = $GLOBALS['db']->getAll($sql); foreach ($reply_list as $k => $v) { $reply_list[$k]['user_name'] = $GLOBALS['db']->getOne("select user_name from " . DB_PREFIX . "user where id = " . $v['user_id']); $reply_list[$k]['create_time_format'] = pass_date($v['create_time']); } $page = new Page($count, $page_size); //初始化分页对象 $p = $page->show(); $GLOBALS['tmpl']->assign('pages', $p); $GLOBALS['tmpl']->assign('reply_list', $reply_list); $GLOBALS['tmpl']->assign('user_auth', get_user_auth()); $review_list_html = decode_topic($GLOBALS['tmpl']->fetch('inc/review/reply_list.html')); $GLOBALS['tmpl']->assign('review_list_html', $review_list_html); $GLOBALS['tmpl']->assign('review_item', $review_item); $GLOBALS['tmpl']->display('review_detail.html'); }
public function index() { $id = intval($_REQUEST['id']); $message_item = $GLOBALS['db']->getRow("select * from " . DB_PREFIX . "topic where id = " . $id . " and is_effect= 1 and is_delete=0"); if (!$message_item) { app_redirect(url("shop")); //showErr($GLOBALS['lang']['TOPIC_NULL']); } if (check_ipop_limit(get_client_ip(), "topic", intval(app_conf("SUBMIT_DELAY")), $id)) { $GLOBALS['db']->query("update " . DB_PREFIX . "topic set click_count = click_count + 1 where id = " . $id); } $message_item = get_topic_item($message_item); $group_item = $message_item['topic_group']; $GLOBALS['tmpl']->assign("group_info", $group_item); if ($group_item) { $user_join_group = $GLOBALS['db']->getOne("select group_concat(group_id) from " . DB_PREFIX . "user_topic_group where user_id = " . intval($message_item['user_id']) . " limit 6"); if (!$user_join_group) { $user_join_group = "0"; } $user_joing_group = $GLOBALS['db']->getAll("select * from " . DB_PREFIX . "topic_group where is_effect = 1 and (id in (" . $user_join_group . ") or user_id = " . intval($message_item['user_id']) . ") limit 6"); $GLOBALS['tmpl']->assign("user_joing_group", $user_joing_group); //小组其他主题 $group_topic_rec_list = $GLOBALS['db']->getAll("select * from " . DB_PREFIX . "topic where id <> " . $message_item['id'] . " and group_id = " . $message_item['group_id'] . " and is_best = 1 order by create_time desc limit 5 "); $GLOBALS['tmpl']->assign("group_topic_rec_list", $group_topic_rec_list); $message_item['group_name'] = $group_item['name']; } $message_item['content'] = decode_topic($message_item['content']); if ($message_item['origin']) { $message_item['origin']['content'] = decode_topic($message_item['origin']['content']); } $title = $message_item['title'] == '' ? $GLOBALS['lang']['TOPIC_SHOW'] : $message_item['title']; $muid = intval($message_item['user_id']); $muser_info = $GLOBALS['db']->getRow("select * from " . DB_PREFIX . "user where id = " . $muid . " and is_effect= 1 and is_delete = 0"); $uid = intval($GLOBALS['user_info']['id']); $focus_data = $GLOBALS['db']->getRow("select * from " . DB_PREFIX . "user_focus where focus_user_id = " . $uid . " and focused_user_id = " . intval($muser_info['id'])); if ($focus_data) { $muser_info['focused'] = 1; } $region_list = load_auto_cache("cache_region_conf"); // $province_str = $GLOBALS['db']->getOne("select name from ".DB_PREFIX."region_conf where id = ".intval($muser_info['province_id'])); $province_str = $region_list[intval($muser_info['province_id'])]['name']; //$city_str = $GLOBALS['db']->getOne("select name from ".DB_PREFIX."region_conf where id = ".intval($muser_info['city_id'])); $city_str = $region_list[intval($muser_info['city_id'])]['name']; if ($province_str . $city_str == '') { $user_location = $GLOBALS['lang']['LOCATION_NULL']; } else { $user_location = $province_str . $city_str; } $muser_info['user_location'] = $user_location; $GLOBALS['tmpl']->assign("muser_info", $muser_info); $site_nav[] = array('name' => $GLOBALS['lang']['HOME_PAGE'], 'url' => APP_ROOT . "/"); if ($message_item['group_id'] > 0) { $site_nav[] = array('name' => $message_item['group_name'], 'url' => url("shop", "group#forum", array("id" => $message_item['group_id']))); } $site_nav[] = array('name' => $title, 'url' => url("shop", "topic", array("id" => $message_item['id']))); $GLOBALS['tmpl']->assign("site_nav", $site_nav); $GLOBALS['tmpl']->assign("message_item", $message_item); if (trim($message_item['group_name']) != "") { $title = $message_item['group_name'] . " - " . $title; } if (trim($message_item['title']) != "") { $title = $message_item['title'] . " - " . $title; } if (trim($message_item['forum_title']) != "") { $title = $message_item['forum_title'] . " - " . $title; } $GLOBALS['tmpl']->assign("page_title", $title); $GLOBALS['tmpl']->assign("page_keyword", $title . ","); $GLOBALS['tmpl']->assign("page_description", $title . ","); $GLOBALS['tmpl']->assign('user_auth', get_user_auth()); $GLOBALS['tmpl']->display("topic_index.html"); }