public function index() { global_run(); init_app_page(); $GLOBALS['tmpl']->assign("no_nav", true); //无分类下拉 if (empty($GLOBALS['user_info'])) { app_redirect(url("index", "user#login")); } require_once APP_ROOT_PATH . "system/model/review.php"; $order_item_id = intval($_REQUEST['order_item_id']); //订单商品ID $youhui_log_id = intval($_REQUEST['youhui_log_id']); //优惠券领取日志ID $event_submit_id = intval($_REQUEST['event_submit_id']); //活动报名日志ID if ($order_item_id > 0) { $deal_id = intval($GLOBALS['db']->getOne("select deal_id from " . DB_PREFIX . "deal_order_item where id = " . $order_item_id)); } else { $deal_id = intval($_REQUEST['deal_id']); } if ($youhui_log_id > 0) { $youhui_id = intval($GLOBALS['db']->getOne("select youhui_id from " . DB_PREFIX . "youhui_log where id = " . $youhui_log_id)); } else { $youhui_id = intval($_REQUEST['youhui_id']); } if ($event_submit_id > 0) { $event_id = intval($GLOBALS['db']->getOne("select event_id from " . DB_PREFIX . "event_submit where id = " . $event_submit_id)); } else { $event_id = intval($_REQUEST['event_id']); } $location_id = intval($_REQUEST['location_id']); if ($deal_id > 0) { require_once APP_ROOT_PATH . "system/model/deal.php"; $deal_info = get_deal($deal_id); if ($deal_info) { //验证是否可以点评 $checker = check_dp_status($GLOBALS['user_info']['id'], array("deal_id" => $deal_id, "order_item_id" => $order_item_id)); if (!$checker['status']) { showErr($checker['info'], 0, $deal_info['url']); } $dp_data = load_dp_info(array("deal_id" => $deal_id)); if ($deal_info['is_shop'] == 1) { $dp_cfg = load_dp_cfg(array("scate_id" => $deal_info['shop_cate_id'])); } else { $dp_cfg = load_dp_cfg(array("cate_id" => $deal_info['cate_id'])); } $item_info['id'] = $deal_info['id']; $item_info['key'] = 'deal_id'; $item_info['ex_key'] = 'order_item_id'; $item_info['ex_id'] = $order_item_id; $item_info['name'] = $deal_info['sub_name']; $item_info['detail'] = $deal_info['name']; $item_info['url'] = $deal_info['url']; $item_info['image'] = $deal_info['icon']; $GLOBALS['tmpl']->assign("dp_data", $dp_data); $GLOBALS['tmpl']->assign("dp_cfg", $dp_cfg); $GLOBALS['tmpl']->assign("item_info", $item_info); //print_r($dp_cfg); //输出导航 $site_nav[] = array('name' => $GLOBALS['lang']['HOME_PAGE'], 'url' => url("index")); $site_nav[] = array('name' => $deal_info['sub_name'], 'url' => url("index", "review", array("deal_id" => $deal_info['id']))); $GLOBALS['tmpl']->assign("site_nav", $site_nav); //输出seo $page_title = ""; $page_keyword = ""; $page_description = ""; if ($deal_info['supplier_info']['name']) { $page_title .= "[" . $deal_info['supplier_info']['name'] . "]"; $page_keyword .= $deal_info['supplier_info']['name'] . ","; $page_description .= $deal_info['supplier_info']['name'] . ","; } $page_title .= $deal_info['sub_name']; $page_keyword .= $deal_info['sub_name']; $page_description .= $deal_info['sub_name']; $GLOBALS['tmpl']->assign("page_title", $page_title); $GLOBALS['tmpl']->assign("page_keyword", $page_keyword); $GLOBALS['tmpl']->assign("page_description", $page_description); //输出右侧的其他团购 if ($deal_info['is_shop'] == 0) { $side_deal_list = get_deal_list(5, array(DEAL_ONLINE, DEAL_NOTICE), array("cid" => $deal_info['cate_id'], "city_id" => $GLOBALS['city']['id']), "", " d.buy_type <> 1 and d.is_shop = 0 and d.id<>" . $deal_info['id']); } elseif ($deal_info['is_shop'] == 1) { if ($deal_info['buy_type'] == 1) { $side_deal_list = get_goods_list(5, array(DEAL_ONLINE, DEAL_NOTICE), array("cid" => $deal_info['shop_cate_id'], "city_id" => $GLOBALS['city']['id']), "", " d.buy_type = 1 and d.is_shop = 1 and d.id<>" . $deal_info['id']); } else { $side_deal_list = get_goods_list(5, array(DEAL_ONLINE, DEAL_NOTICE), array("cid" => $deal_info['shop_cate_id'], "city_id" => $GLOBALS['city']['id']), "", " d.buy_type <> 1 and d.is_shop = 1 and d.id<>" . $deal_info['id']); } } //$side_deal_list = get_deal_list(4,array(DEAL_ONLINE)); $GLOBALS['tmpl']->assign("side_deal_list", $side_deal_list['list']); } else { showErr("你要点评的商品不存在"); } } elseif ($youhui_id > 0) { require_once APP_ROOT_PATH . "system/model/youhui.php"; $youhui_info = get_youhui($youhui_id); if ($youhui_info) { //验证是否可以点评 $checker = check_dp_status($GLOBALS['user_info']['id'], array("youhui_id" => $youhui_id, "youhui_log_id" => $youhui_log_id)); if (!$checker['status']) { showErr($checker['info'], 0, $youhui_info['url']); } $dp_data = load_dp_info(array("youhui_id" => $youhui_id)); $dp_cfg = load_dp_cfg(array("cate_id" => $youhui_info['deal_cate_id'])); $item_info['id'] = $youhui_info['id']; $item_info['key'] = 'youhui_id'; $item_info['ex_key'] = 'youhui_log_id'; $item_info['ex_id'] = $youhui_log_id; $item_info['name'] = $youhui_info['name']; $item_info['url'] = $youhui_info['url']; $item_info['image'] = $youhui_info['icon']; $GLOBALS['tmpl']->assign("dp_data", $dp_data); $GLOBALS['tmpl']->assign("dp_cfg", $dp_cfg); $GLOBALS['tmpl']->assign("item_info", $item_info); //输出导航 $site_nav[] = array('name' => $GLOBALS['lang']['HOME_PAGE'], 'url' => url("index")); $site_nav[] = array('name' => $youhui_info['name'], 'url' => url("index", "review", array("youhui_id" => $youhui_info['id']))); $GLOBALS['tmpl']->assign("site_nav", $site_nav); //输出seo $page_title = ""; $page_keyword = ""; $page_description = ""; if ($youhui_info['supplier_info']['name']) { $page_title .= "[" . $youhui_info['supplier_info']['name'] . "]"; $page_keyword .= $youhui_info['supplier_info']['name'] . ","; $page_description .= $youhui_info['supplier_info']['name'] . ","; } $page_title .= $youhui_info['name']; $page_keyword .= $youhui_info['name']; $page_description .= $youhui_info['name']; $GLOBALS['tmpl']->assign("page_title", $page_title); $GLOBALS['tmpl']->assign("page_keyword", $page_keyword); $GLOBALS['tmpl']->assign("page_description", $page_description); } else { showErr("你要点评的优惠券不存在"); } } elseif ($location_id > 0) { require_once APP_ROOT_PATH . "system/model/supplier.php"; $location_info = get_location($location_id); if ($location_info) { //验证是否可以点评 $checker = check_dp_status($GLOBALS['user_info']['id'], array("location_id" => $location_id)); if (!$checker['status']) { showErr($checker['info'], 0, $location_info['url']); } $dp_data = load_dp_info(array("location_id" => $location_id)); $dp_cfg = load_dp_cfg(array("cate_id" => $location_info['deal_cate_id'])); $item_info['id'] = $location_info['id']; $item_info['key'] = 'location_id'; $item_info['name'] = $location_info['name']; $item_info['url'] = $location_info['url']; $item_info['image'] = $location_info['preview']; $GLOBALS['tmpl']->assign("dp_data", $dp_data); $GLOBALS['tmpl']->assign("dp_cfg", $dp_cfg); $GLOBALS['tmpl']->assign("item_info", $item_info); //输出导航 $site_nav[] = array('name' => $GLOBALS['lang']['HOME_PAGE'], 'url' => url("index")); $site_nav[] = array('name' => $location_info['name'], 'url' => url("index", "review", array("location_id" => $location_info['id']))); $GLOBALS['tmpl']->assign("site_nav", $site_nav); //输出seo $page_title = ""; $page_keyword = ""; $page_description = ""; if ($location_info['supplier_info']['name']) { $page_title .= "[" . $location_info['supplier_info']['name'] . "]"; $page_keyword .= $location_info['supplier_info']['name'] . ","; $page_description .= $location_info['supplier_info']['name'] . ","; } $page_title .= $location_info['name']; $page_keyword .= $location_info['name']; $page_description .= $location_info['name']; $GLOBALS['tmpl']->assign("page_title", $page_title); $GLOBALS['tmpl']->assign("page_keyword", $page_keyword); $GLOBALS['tmpl']->assign("page_description", $page_description); } else { showErr("你要点评的商家不存在"); } } elseif ($event_id > 0) { require_once APP_ROOT_PATH . "system/model/event.php"; $event_info = get_event($event_id); if ($event_info) { //验证是否可以点评 $checker = check_dp_status($GLOBALS['user_info']['id'], array("event_id" => $event_id, "event_submit_id" => $event_submit_id)); if (!$checker['status']) { showErr($checker['info'], 0, $event_info['url']); } $dp_data = load_dp_info(array("event_id" => $event_id)); $dp_cfg = load_dp_cfg(array("ecate_id" => $event_info['cate_id'])); $item_info['id'] = $event_info['id']; $item_info['key'] = 'event_id'; $item_info['ex_key'] = 'event_submit_id'; $item_info['ex_id'] = $event_submit_id; $item_info['name'] = $event_info['name']; $item_info['url'] = $event_info['url']; $item_info['image'] = $event_info['icon']; $GLOBALS['tmpl']->assign("dp_data", $dp_data); $GLOBALS['tmpl']->assign("dp_cfg", $dp_cfg); $GLOBALS['tmpl']->assign("item_info", $item_info); //输出导航 $site_nav[] = array('name' => $GLOBALS['lang']['HOME_PAGE'], 'url' => url("index")); $site_nav[] = array('name' => $event_info['name'], 'url' => url("index", "review", array("event_id" => $event_info['id']))); $GLOBALS['tmpl']->assign("site_nav", $site_nav); //输出seo $page_title = ""; $page_keyword = ""; $page_description = ""; if ($event_info['supplier_info']['name']) { $page_title .= "[" . $event_info['supplier_info']['name'] . "]"; $page_keyword .= $event_info['supplier_info']['name'] . ","; $page_description .= $event_info['supplier_info']['name'] . ","; } $page_title .= $event_info['name']; $page_keyword .= $event_info['name']; $page_description .= $event_info['name']; $GLOBALS['tmpl']->assign("page_title", $page_title); $GLOBALS['tmpl']->assign("page_keyword", $page_keyword); $GLOBALS['tmpl']->assign("page_description", $page_description); } else { showErr("你要点评的活动不存在"); } } else { app_redirect(url("index")); } $GLOBALS['tmpl']->display("review.html"); }
public function index() { $type = strim($GLOBALS['request']['type']); $id = intval($GLOBALS['request']['id']); $city_name = strim($GLOBALS['request']['city_name']); //城市名称 $deal_id = 0; $youhui_id = 0; $location_id = 0; $event_id = 0; $tech_id = 0; if ($type == "deal") { $deal_id = $id; require_once APP_ROOT_PATH . "system/model/deal.php"; $deal_info = get_deal($deal_id); $relate_data_name = $deal_info['name']; } elseif ($type == "supplier") { $location_id = $id; require_once APP_ROOT_PATH . "system/model/supplier.php"; $location_info = get_location($location_id); $relate_data_name = $location_info['name']; } elseif ($type == "youhui") { $youhui_id = $id; require_once APP_ROOT_PATH . "system/model/youhui.php"; $youhui_info = get_youhui($youhui_id); $relate_data_name = $youhui_info['name']; } elseif ($type == "event") { $event_id = $id; require_once APP_ROOT_PATH . "system/model/event.php"; $event_info = get_event($event_id); $relate_data_name = $event_info['name']; } elseif ($type == "tech") { $tech_id = $id; require_once APP_ROOT_PATH . "system/model/tech.php"; $tech_info = get_tech($tech_id); $relate_data_name = $tech_info['name']; } $page = intval($GLOBALS['request']['page']); /*分页*/ $city_name = strim($GLOBALS['request']['city_name']); //城市分类ID //检查用户,用户密码 $user = $GLOBALS['user_info']; $user_id = intval($user['id']); $root = array(); $root['return'] = 1; $page = $page == 0 ? 1 : $page; $page_size = PAGE_SIZE; $limit = ($page - 1) * $page_size . "," . $page_size; // $message_re=m_get_message_list($limit," m.rel_table = 'deal' and m.rel_id=".$tuan_id." and m.is_buy = 1",0);/*购买评论*/ require_once APP_ROOT_PATH . "system/model/review.php"; require_once APP_ROOT_PATH . "system/model/user.php"; $message_re = get_dp_list($limit, $param = array("deal_id" => $deal_id, "youhui_id" => $youhui_id, "event_id" => $event_id, "location_id" => $location_id, "tech_id" => $tech_id, "tag" => ""), "", ""); foreach ($message_re['list'] as $k => $v) { $message_re['list'][$k]['width'] = $v['point'] / 5 * 100; $message_re['list'][$k]['create_time'] = to_date($v['create_time']); $uinfo = load_user($v['user_id']); $message_re['list'][$k]['user_name'] = $uinfo['user_name']; foreach ($message_re['list'][$k]['images'] as $kk => $vv) { $message_re['list'][$k]['images'][$kk] = get_abs_img_root(get_spec_image($vv, 60, 60, 1)); $message_re['list'][$k]['oimages'][$kk] = get_abs_img_root($vv); } } $root['message_list'] = $message_re['list']; if (count($message_re['list']) > 0) { $sql = "select count(*) from " . DB_PREFIX . "supplier_location_dp where " . $message_re['condition']; $message_re['count'] = $GLOBALS['db']->getOne($sql); } $root['message_count'] = $message_re['count']; //$deal = get_deal($tuan_id); $dp_info = load_dp_info(array("deal_id" => $deal_id, "youhui_id" => $youhui_id, "event_id" => $event_id, "location_id" => $location_id, "tech_id" => $tech_id)); $root['name'] = $relate_data_name; //星级点评数 $root['star_1'] = $dp_info['dp_count_1']; $root['star_2'] = $dp_info['dp_count_2']; $root['star_3'] = $dp_info['dp_count_3']; $root['star_4'] = $dp_info['dp_count_4']; $root['star_5'] = $dp_info['dp_count_5']; $root['star_dp_width_1'] = $dp_info['avg_point_1_percent']; $root['star_dp_width_2'] = $dp_info['avg_point_2_percent']; $root['star_dp_width_3'] = $dp_info['avg_point_3_percent']; $root['star_dp_width_4'] = $dp_info['avg_point_4_percent']; $root['star_dp_width_5'] = $dp_info['avg_point_5_percent']; $buy_dp_sum = 0.0; // $buy_dp_group = $GLOBALS['db']->getAll("select point,count(*) as num from ".DB_PREFIX."message where rel_id = ".$tuan_id." and rel_table = 'deal' and pid = 0 and is_buy = 1 group by point"); // foreach($buy_dp_group as $dp_k=>$dp_v) // { // $star = intval($dp_v['point']); // if ($star >= 1 && $star <= 5){ // $root['star_'.$star] = $dp_v['num']; // $buy_dp_sum += $star * $dp_v['num']; // $root['star_dp_width_'.$star] = (round($dp_v['num']/ $message_re['count'],1)) * 100; // } // } //点评平均分 $root['buy_dp_sum'] = $dp_info['dp_count']; $root['buy_dp_avg'] = $dp_info['avg_point']; $root['buy_dp_width'] = $dp_info['avg_point'] / 5 * 100; $page_total = ceil($message_re['count'] / $page_size); $root['page'] = array("page" => $page, "page_total" => $page_total, "page_size" => $page_size); $root['allow_dp'] = 0; //0:不允许点评;1:允许点评 //判断用户是否购买了这个商品 if ($user_id > 0) { // $sql = "select count(*) from ".DB_PREFIX."deal_order_item as doi left join ".DB_PREFIX."deal_order as do on doi.order_id = do.id where doi.deal_id = ".intval($tuan_id)." and do.user_id = ".intval($user_id)." and do.pay_status = 2"; // //$root['sql'] = $sql; // if($GLOBALS['db']->getOne($sql)>0) // { // $root['allow_dp'] = 1; // } $dp_status = check_dp_status($user_id, array("deal_id" => $deal_id, "youhui_id" => $youhui_id, "event_id" => $event_id, "location_id" => $location_id)); if ($dp_status['status']) { $root['allow_dp'] = 1; } if ($type == "tech" && $user_id == $id) { //技师本身不能给自己点评 $root['allow_dp'] = 0; } } $root['type'] = $type; $root['id'] = $id; $root['page_title'] = "点评列表"; $root['city_name'] = $city_name; output($root); }
/** * 加载点评详细列表 */ public function load_review_list() { $deal_id = intval($_REQUEST['deal_id']); $youhui_id = intval($_REQUEST['youhui_id']); $event_id = intval($_REQUEST['event_id']); $supplier_id = intval($_REQUEST['supplier_id']); $location_id = intval($_REQUEST['location_id']); $item_array = array("deal_id" => $deal_id, "youhui_id" => $youhui_id, "event_id" => $event_id, "supplier_id" => $supplier_id, "location_id" => $location_id); require_once APP_ROOT_PATH . "system/model/review.php"; require_once APP_ROOT_PATH . "app/Lib/page.php"; $dp_data = load_dp_info($item_array); $GLOBALS['tmpl']->assign("dp_data", $dp_data); //排序行 $sort_field = intval($_REQUEST['sort_field']); $sort_type = strim($_REQUEST['sort_type']); $filter = intval($_REQUEST['filter']); $is_img = intval($_REQUEST['is_img']); $is_content = intval($_REQUEST['is_content']); $sort_data['sort_field'] = $sort_field; $sort_data['sort_type'] = $sort_type; $sort_data['filter'] = $filter; $sort_data['is_img'] = $is_img; $sort_data['is_content'] = $is_content; $GLOBALS['tmpl']->assign("sort_data", $sort_data); $ext_condition = ""; if ($filter == 1) { $ext_condition = " point >= 4 "; } elseif ($filter == 2) { $ext_condition = " point >= 2 and point < 4 "; } elseif ($filter == 3) { $ext_condition = " point < 2 "; } if ($is_img == 1) { if ($ext_condition != "") { $ext_condition .= " and "; } $ext_condition .= " is_img = 1 "; } if ($is_content == 1) { if ($ext_condition != "") { $ext_condition .= " and "; } $ext_condition .= " is_content = 1 "; } //排序 $orderby = ""; if ($sort_field > 0) { if ($sort_field == 1) { if ($sort_type == "asc") { $orderby = " point asc "; } else { $orderby = " point desc "; } } elseif ($sort_field == 2) { if ($sort_type == "asc") { $orderby = " point desc "; } else { $orderby = " point asc "; } } } //tag行 $tag = strim($_REQUEST['tag']); $GLOBALS['tmpl']->assign("filter_tag", $tag); $gid = intval($_REQUEST['gid']); $GLOBALS['tmpl']->assign("gid", $gid); //分页 $page_size = 5; $page = intval($_REQUEST['p']); if ($page == 0) { $page = 1; } $limit = ($page - 1) * $page_size . "," . $page_size; $list_item_array = $item_array; $list_item_array['tag'] = $tag; $dp_res = get_dp_list($limit, $list_item_array, $ext_condition, $orderby); $dp_list = $dp_res['list']; $total = $GLOBALS['db']->getOne("select count(*) from " . DB_PREFIX . "supplier_location_dp where " . $dp_res['condition']); $page = new Page($total, $page_size); //初始化分页对象 $p = $page->show(); $GLOBALS['tmpl']->assign('pages', $p); $GLOBALS['tmpl']->assign('dp_list', $dp_list); require_once APP_ROOT_PATH . "system/model/topic.php"; $data['html'] = decode_topic_without_img($GLOBALS['tmpl']->fetch("inc/review_list.html")); ajax_return($data); }