public function index() { $merchant_id = intval($GLOBALS['request']['merchant_id']); /*商家ID*/ $page = intval($GLOBALS['request']['page']); /*分页*/ //检查用户,用户密码 $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; $supplier_locationinfo = $GLOBALS['db']->getRow("select name,id,new_dp_count_time from " . DB_PREFIX . "supplier_location where id = " . $merchant_id); syn_supplier_locationcount($supplier_locationinfo); $condition = " dp.status = 1 and dp.supplier_location_id = " . $merchant_id . " "; $sql_count = "select count(*) from " . DB_PREFIX . "supplier_location_dp dp where " . $condition; $total = $GLOBALS['db']->getOne($sql_count); $page_total = ceil($total / $page_size); //$root['sql_count'] = $sql_count; $sql = "select dp.*,u.user_name from " . DB_PREFIX . "supplier_location_dp as dp left outer join " . DB_PREFIX . "user as u on u.id = dp.user_id where " . $condition . " order by dp.is_top desc, dp.create_time desc limit " . $limit; $root['sql'] = $sql; $list = $GLOBALS['db']->getAll($sql); foreach ($list as $k => $v) { $list[$k]['merchant_id'] = $v['supplier_location_id']; $list[$k]['create_time_format'] = getBeforeTimelag($v['create_time']); $list[$k]['width'] = $v['point'] / 5 * 100; } //星级点评数 $root['star_1'] = 0; $root['star_2'] = 0; $root['star_3'] = 0; $root['star_4'] = 0; $root['star_5'] = 0; $root['star_dp_width_1'] = 0; $root['star_dp_width_2'] = 0; $root['star_dp_width_3'] = 0; $root['star_dp_width_4'] = 0; $root['star_dp_width_5'] = 0; $buy_dp_sum = 0.0; $buy_dp_group = $GLOBALS['db']->getAll("select point,count(*) as num from " . DB_PREFIX . "supplier_location_dp where supplier_location_id = " . $merchant_id . " 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'] / $total, 1) * 100; } } //点评平均分 $root['buy_dp_sum'] = $buy_dp_sum; $root['buy_dp_avg'] = round($buy_dp_sum / $total, 1); $root['buy_dp_width'] = round($buy_dp_sum / $total, 1) / 5 * 100; $root['page'] = array("page" => $page, "page_total" => $page_total, "page_size" => $page_size); $root['message_list'] = $list; $root['merchant_id'] = $merchant_id; $root['page_title'] = "点评列表"; output($root); }
function op_dp_del($id, $change, $reason, $check = false) { $dp = $GLOBALS['db']->getRow("select * from " . DB_PREFIX . "supplier_location_dp where id = " . $id); if ($check) { $result['status'] = 1; return $result; } if (check_user_auth("dp", "del")) { $sql = "delete from " . DB_PREFIX . "supplier_location_dp where id = " . $id; $GLOBALS['db']->query($sql); $GLOBALS['db']->query("delete from " . DB_PREFIX . "supplier_location_dp_reply where dp_id = " . $id); if ($dp['status'] == 1) { $merchant_info = $GLOBALS['db']->getRow("select * from " . DB_PREFIX . "supplier_location where id = " . $dp['supplier_location_id']); syn_supplier_locationcount($merchant_info); } $GLOBALS['db']->query("update " . DB_PREFIX . "user set dp_count = dp_count - 1 where id = " . intval($dp['user_id'])); $GLOBALS['db']->query("delete from " . DB_PREFIX . "supplier_location_dp_point_result where dp_id = " . $id); $GLOBALS['db']->query("delete from " . DB_PREFIX . "supplier_location_dp_tag_result where dp_id = " . $id); $o_reason = $reason; $reason .= "商户点评(" . $dp['title'] . ")被删除"; if ($change == 1) { modify_account(get_op_change("dp", "del"), $dp['user_id'], $reason); $reason .= get_op_change_show("dp", "del"); } if ($change == 1 || $o_reason != "") { send_msg($dp['user_id'], $reason, "notify", 0); } $cache_id = md5("store" . "view" . $dp['supplier_location_id']); $GLOBALS['tmpl']->clear_cache('store_view.html', $cache_id); $result['status'] = 1; } else { $result['status'] = 0; $result['info'] = "没有权限"; } return $result; }
public function index() { $root = array(); $root['return'] = 1; $yh_id = intval($GLOBALS['request']['yh_id']); $merchant_id = intval($GLOBALS['request']['merchant_id']); $city_name = strim($GLOBALS['request']['city_name']); //城市分类ID //添加点评数据 $content = addslashes(trim($GLOBALS['request']['content'])); if ($GLOBALS['request']['from'] == "wap") { if ($content != null && $content != "") { //检查用户,用户密码 $user = $GLOBALS['user_info']; $user_id = intval($user['id']); if ($merchant_id > 0) { $supplier_location_id = $merchant_id; $merchant_youhui_comment = array('user_id' => $user_id, 'supplier_location_id' => $supplier_location_id, 'title' => $content, 'content' => $content, 'status' => 1, 'create_time' => get_gmtime()); $GLOBALS['db']->autoExecute(DB_PREFIX . "supplier_location_dp", $merchant_youhui_comment, 'INSERT'); } else { $rel_table = 'youhui'; $rel_id = $yh_id; if ($yh_id == 0) { //$rel_id = $merchant_id; //rel_table = 'supplier_location'; } else { //$supplier_location_id = intval($GLOBALS['db']->getOne("select supplier_location_id from ".DB_PREFIX."youhui where id='".$yh_id."'")); } $merchant_youhui_comment = array('user_id' => $user_id, 'rel_id' => $rel_id, 'rel_table' => $rel_table, 'title' => $content, 'content' => $content, 'is_effect' => 1, 'create_time' => get_gmtime()); $GLOBALS['db']->autoExecute(DB_PREFIX . "message", $merchant_youhui_comment, 'INSERT'); } } } else { if ($content) { //检查用户,用户密码 $user = $GLOBALS['user_info']; $user_id = intval($user['id']); if ($merchant_id > 0) { $supplier_location_id = $merchant_id; $merchant_youhui_comment = array('user_id' => $user_id, 'supplier_location_id' => $supplier_location_id, 'title' => $content, 'content' => $content, 'status' => 1, 'create_time' => get_gmtime()); $GLOBALS['db']->autoExecute(DB_PREFIX . "supplier_location_dp", $merchant_youhui_comment, 'INSERT'); } else { $rel_table = 'youhui'; $rel_id = $yh_id; if ($yh_id == 0) { //$rel_id = $merchant_id; //rel_table = 'supplier_location'; } else { //$supplier_location_id = intval($GLOBALS['db']->getOne("select supplier_location_id from ".DB_PREFIX."youhui where id='".$yh_id."'")); } $merchant_youhui_comment = array('user_id' => $user_id, 'rel_id' => $rel_id, 'rel_table' => $rel_table, 'title' => $content, 'content' => $content, 'is_effect' => 1, 'create_time' => get_gmtime()); $GLOBALS['db']->autoExecute(DB_PREFIX . "message", $merchant_youhui_comment, 'INSERT'); } } $id = $GLOBALS['db']->insert_id(); $root['id'] = $id; if ($id > 0) { $root['status'] = 1; $root['info'] = "添加成功"; } else { $root['status'] = 0; $root['info'] = "添加失败"; } } // Fwb add 2014-08-27 $page = intval($GLOBALS['request']['page']); //分页 $page = $page == 0 ? 1 : $page; $page_size = PAGE_SIZE; $limit = ($page - 1) * $page_size . "," . $page_size; $youhui_comment_list = array(); if ($merchant_id > 0) { $supplier_locationinfo = $GLOBALS['db']->getRow("select name,id,new_dp_count_time from " . DB_PREFIX . "supplier_location where id = " . $merchant_id); syn_supplier_locationcount($supplier_locationinfo); $condition = " dp.status = 1 and dp.supplier_location_id = " . $merchant_id . " "; $sql_count = "select count(*) from " . DB_PREFIX . "supplier_location_dp dp where " . $condition; $total = $GLOBALS['db']->getOne($sql_count); $page_total = ceil($total / $page_size); //$root['sql_count'] = $sql_count; $sql = "select dp.*,u.user_name from " . DB_PREFIX . "supplier_location_dp as dp left outer join " . DB_PREFIX . "user as u on u.id = dp.user_id where " . $condition . " order by dp.is_top desc, dp.create_time desc limit " . $limit; $root['sql'] = $sql; $list = $GLOBALS['db']->getAll($sql); foreach ($list as $item) { $youhui_comment_list[] = array("id" => $item['id'], "merchant_id" => $item['supplier_location_id'], "content" => trim($item['content']), "point" => intval($item['point']), "user_name" => trim($item['user_name']), "create_time" => $item['create_time'], "create_time_format" => getBeforeTimelag($item['create_time'])); } } else { $sql_count = "select count(*) from " . DB_PREFIX . "message as a " . " left outer join " . DB_PREFIX . "youhui as b on b.id = a.rel_id " . " left outer join " . DB_PREFIX . "user as c on c.id = a.user_id "; $sql = "select a.id, a.rel_id as yh_id, a.content,a.create_time, c.user_name from " . DB_PREFIX . "message as a " . " left outer join " . DB_PREFIX . "user as c on c.id = a.user_id "; $where = " a.is_effect = 1 and a.rel_table = 'youhui' and a.rel_id = {$yh_id}"; $sql_count .= " where " . $where; $sql .= " where " . $where . " order by a.create_time desc"; $sql .= " limit " . $limit; $total = $GLOBALS['db']->getOne($sql_count); $page_total = ceil($total / $page_size); $list = $GLOBALS['db']->getAll($sql); foreach ($list as $item) { /* $title = trim($item['youhui_title']); if ($title == "" || empty($title)){ $title = trim($item['m_name']); } */ $youhui_comment_list[] = array("id" => $item['id'], "yh_id" => $item['yh_id'], "content" => trim($item['content']), "user_name" => trim($item['user_name']), "create_time" => $item['create_time'], "create_time_format" => getBeforeTimelag($item['create_time'])); } } //echo $sql; exit; $root['item'] = $youhui_comment_list; $root['page'] = array("page" => $page, "page_total" => $page_total, "page_size" => $page_size); $root['merchant_id'] = $merchant_id; //fwb add 2014-08-27 $root['yh_id'] = $yh_id; $root['page_title'] = "评论详情"; $root['city_name'] = $city_name; output($root); }
/** * * @param $dp_title 点评的标题 * @param $dp_content 内容 * @param $location_id 点评的门店 * @param $point 评分 1-5 * @param $is_buy 是否购买点评 * @param $from 来源 (event/tuan/youhui/daijin) * @param $url_route 网址参数 * @param $message_id 其他部份留言的ID,用于同步 */ function insert_dp($dp_title, $dp_content, $location_id, $point = 0, $is_buy = 0, $from = "", $url_route = array(), $message_id = 0) { $dp_data = array(); $dp_data['title'] = valid_str($dp_title); $dp_data['content'] = valid_str($dp_content); $dp_data['create_time'] = get_gmtime(); $dp_data['point'] = $point; $dp_data['user_id'] = intval($GLOBALS['user_info']['id']); $dp_data['supplier_location_id'] = $location_id; $dp_data['status'] = 1; $dp_data['from_data'] = $from; $dp_data['is_buy'] = $is_buy; $dp_data['message_id'] = $message_id; foreach ($url_route as $k => $v) { $dp_data[$k] = $v; } $GLOBALS['db']->autoExecute(DB_PREFIX . "supplier_location_dp", $dp_data, "INSERT"); $dp_id = $GLOBALS['db']->insert_id(); if ($dp_id > 0) { $GLOBALS['db']->query("update " . DB_PREFIX . "user set dp_count = dp_count + 1 where id = " . intval($GLOBALS['user_info']['id'])); $supplier_info = $GLOBALS['db']->getRow("select * from " . DB_PREFIX . "supplier_location where id = " . $dp_data['supplier_location_id']); //更新统计 syn_supplier_locationcount($supplier_info); $cache_id = md5("store" . "view" . $supplier_info['id']); $GLOBALS['tmpl']->clear_cache('store_view.html', $cache_id); } return $dp_id; }
/** * 提交保存点评 * @param unknown_type $user_id 提交点评的会员 * @param unknown_type $param 参数 详细规则见 check_dp_status函数说明 * @param unknown_type $content 点评文字内容 * @param unknown_type $dp_point 总评分 * @param unknown_type $dp_image 点评的图片数组 array("./public/...","./public/....."); * @param unknown_type $tag_group 点评标签(二维数组),格式如下 * array( * "group_id" = array("tag","tag") * ); 其中group_id为分组的ID,第二维为每个分组中的tag * @param unknown_type $point_group 点评评分分组数据,格式如下 * array( * "group_id" => "point" * ); 其中group_id为分组的ID,point为对应分组的评分 * * 返回 array("status"=>bool, "info"=>"消息","location_id"=>"门店的ID","deal_id"=>"","youhui_id"=>"","event_id"=>""); */ function save_review($user_id, $param = array("deal_id" => 0, "youhui_id" => 0, "event_id" => 0, "location_id" => 0, "order_item_id" => 0, "youhui_log_id" => 0, "event_submit_id" => 0), $content, $dp_point, $dp_image = array(), $tag_group = array(), $point_group = array()) { //获取参数 $order_item_id = intval($param['order_item_id']); //订单商品ID $youhui_log_id = intval($param['youhui_log_id']); //优惠券领取日志ID $event_submit_id = intval($param['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($param['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($param['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($param['event_id']); } $location_id = intval($param['location_id']); //部份初始化的变量 $is_buy = 0; //默认的点评为非购物点评 $avg_price = 0; //均价为0 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']) { return array("status" => false, "info" => $checker['info']); } else { $supplier_location_id = $checker['supplier_location_id']; } $is_buy = 1; $avg_price = $checker['avg_price']; } else { return array("status" => false, "info" => "你要点评的商品不存在"); } } 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']) { return array("status" => false, "info" => $checker['info']); } else { $supplier_location_id = $checker['supplier_location_id']; } } else { return array("status" => false, "info" => "你要点评的优惠券不存在"); } } 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']) { return array("status" => false, "info" => $checker['info']); } else { $supplier_location_id = $checker['supplier_location_id']; } } else { return array("status" => false, "info" => "你要点评的活动不存在"); } } 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']) { return array("status" => false, "info" => $checker['info']); } else { $supplier_location_id = $checker['supplier_location_id']; } } else { return array("status" => false, "info" => "你要点评的商家不存在"); } } if ($deal_id == 0 && $youhui_id == 0 && $event_id == 0 && $location_id == 0) { return array("status" => false, "info" => "非法的数据"); } //点评入库 $supplier_info = $GLOBALS['db']->getRow("select name,id,new_dp_count_time,supplier_id from " . DB_PREFIX . "supplier_location where id = " . intval($supplier_location_id)); $supplier_id = $supplier_info['supplier_id']; $dp_data = array(); if ($content != "") { $dp_data['is_content'] = 1; $dp_data['content'] = $content; } $dp_data['create_time'] = NOW_TIME; $dp_data['point'] = $dp_point; $dp_data['user_id'] = $user_id; $dp_data['supplier_location_id'] = $supplier_location_id; $dp_data['youhui_id'] = $youhui_id; $dp_data['event_id'] = $event_id; $dp_data['deal_id'] = $deal_id; $dp_data['images_cache'] = serialize($dp_image); $dp_data['supplier_id'] = $supplier_id; $dp_data['status'] = 1; if (count($dp_image) > 0) { $dp_data['is_img'] = 1; } $dp_data['avg_price'] = floatval($avg_price); $GLOBALS['db']->autoExecute(DB_PREFIX . "supplier_location_dp", $dp_data, "INSERT"); $dp_id = $GLOBALS['db']->insert_id(); if ($dp_id > 0) { if ($checker['order_item_id']) { $GLOBALS['db']->query("update " . DB_PREFIX . "deal_order_item set dp_id = " . $dp_id . " where id = '" . $checker['order_item_id'] . "'"); $order_id = intval($GLOBALS['db']->getOne("select order_id from " . DB_PREFIX . "deal_order_item where id = " . $checker['order_item_id'])); update_order_cache($order_id); require_once APP_ROOT_PATH . "system/model/deal_order.php"; distribute_order($order_id); } if ($checker['youhui_log_id']) { $GLOBALS['db']->query("update " . DB_PREFIX . "youhui_log set dp_id = " . $dp_id . " where id = '" . $checker['youhui_log_id'] . "'"); } if ($checker['event_submit_id']) { $GLOBALS['db']->query("update " . DB_PREFIX . "event_submit set dp_id = " . $dp_id . " where id = '" . $checker['event_submit_id'] . "'"); } increase_user_active($user_id, "发表了一则点评"); $GLOBALS['db']->query("update " . DB_PREFIX . "user set dp_count = dp_count + 1 where id = " . $user_id); //创建点评图库 if (count($dp_image) > 0) { foreach ($dp_image as $pkey => $photo) { //点评图片不入商户图片库 // $c_data = array(); // $c_data['image'] = $photo; // $c_data['sort'] = 10; // $c_data['create_time'] = NOW_TIME; // $c_data['user_id'] = $user_id; // $c_data['supplier_location_id'] = $supplier_location_id; // $c_data['dp_id'] = $dp_id; // $c_data['status'] = 0; // $GLOBALS['db']->autoExecute(DB_PREFIX."supplier_location_images", $c_data,"INSERT"); $c_data = array(); $c_data['image'] = $photo; $c_data['dp_id'] = $dp_id; $c_data['create_time'] = NOW_TIME; $c_data['location_id'] = $supplier_location_id; $c_data['supplier_id'] = $supplier_id; $GLOBALS['db']->autoExecute(DB_PREFIX . "supplier_location_dp_images", $c_data, "INSERT"); } } //创建点评评分 foreach ($point_group as $group_id => $point) { $point_data = array(); $point_data['group_id'] = $group_id; $point_data['dp_id'] = $dp_id; $point_data['supplier_location_id'] = $supplier_location_id; $point_data['point'] = $point; $GLOBALS['db']->autoExecute(DB_PREFIX . "supplier_location_dp_point_result", $point_data, "INSERT"); //创建商品点评数据 if ($dp_data['deal_id'] > 0) { $point_data = array(); $point_data['group_id'] = $group_id; $point_data['dp_id'] = $dp_id; $point_data['deal_id'] = $dp_data['deal_id']; $point_data['point'] = $point; $GLOBALS['db']->autoExecute(DB_PREFIX . "deal_dp_point_result", $point_data, "INSERT"); } //创建优惠券点评数据 if ($dp_data['youhui_id'] > 0) { $point_data = array(); $point_data['group_id'] = $group_id; $point_data['dp_id'] = $dp_id; $point_data['youhui_id'] = $dp_data['youhui_id']; $point_data['point'] = $point; $GLOBALS['db']->autoExecute(DB_PREFIX . "youhui_dp_point_result", $point_data, "INSERT"); } //创建活动点评数据 if ($dp_data['event_id'] > 0) { $point_data = array(); $point_data['group_id'] = $group_id; $point_data['dp_id'] = $dp_id; $point_data['event_id'] = $dp_data['event_id']; $point_data['point'] = $point; $GLOBALS['db']->autoExecute(DB_PREFIX . "event_dp_point_result", $point_data, "INSERT"); } } //创建点评分组的标签 foreach ($tag_group as $group_id => $tag_row_arr) { foreach ($tag_row_arr as $tag_row) { $tag_row_data = array(); $tag_row_data['tags'] = $tag_row; $tag_row_data['dp_id'] = $dp_id; $tag_row_data['supplier_location_id'] = $supplier_location_id; $tag_row_data['group_id'] = $group_id; $GLOBALS['db']->autoExecute(DB_PREFIX . "supplier_location_dp_tag_result", $tag_row_data, "INSERT"); insert_match_item($tag_row, "supplier_location_dp", $dp_id, "tags_match"); //更新点评的索引 review_supplier_location_match($supplier_location_id, $tag_row, $group_id); //创建商品点评数据 if ($dp_data['deal_id'] > 0) { $tag_row_data = array(); $tag_row_data['tags'] = $tag_row; $tag_row_data['dp_id'] = $dp_id; $tag_row_data['deal_id'] = $dp_data['deal_id']; $tag_row_data['group_id'] = $group_id; $GLOBALS['db']->autoExecute(DB_PREFIX . "deal_dp_tag_result", $tag_row_data, "INSERT"); } //创建优惠券点评数据 if ($dp_data['youhui_id'] > 0) { $tag_row_data = array(); $tag_row_data['tags'] = $tag_row; $tag_row_data['dp_id'] = $dp_id; $tag_row_data['youhui_id'] = $dp_data['youhui_id']; $tag_row_data['group_id'] = $group_id; $GLOBALS['db']->autoExecute(DB_PREFIX . "youhui_dp_tag_result", $tag_row_data, "INSERT"); } //创建活动点评数据 if ($dp_data['event_id'] > 0) { $tag_row_data = array(); $tag_row_data['tags'] = $tag_row; $tag_row_data['dp_id'] = $dp_id; $tag_row_data['event_id'] = $dp_data['event_id']; $tag_row_data['group_id'] = $group_id; $GLOBALS['db']->autoExecute(DB_PREFIX . "event_dp_tag_result", $tag_row_data, "INSERT"); } } } //更新统计 syn_supplier_locationcount($supplier_info); cache_store_point($supplier_info['id']); //统计商品点评数据 if ($dp_data['deal_id'] > 0) { //计算总点评1-5星人数 $item_data = $GLOBALS['db']->getRow("select * from " . DB_PREFIX . "deal where id = " . $dp_data['deal_id']); $sql = "select count(*) as total,point from " . DB_PREFIX . "supplier_location_dp where deal_id = " . $item_data['id'] . " group by point "; $data_result = $GLOBALS['db']->getAll($sql); foreach ($data_result as $k => $v) { $item_data['dp_count_' . $v['point']] = $v['total']; } $GLOBALS['db']->autoExecute(DB_PREFIX . "deal", $item_data, "UPDATE", " id = " . $item_data['id'] . " "); syn_deal_review_count($item_data['id']); } //创建优惠券点评数据 if ($dp_data['youhui_id'] > 0) { //计算总点评1-5星人数 $item_data = $GLOBALS['db']->getRow("select * from " . DB_PREFIX . "youhui where id = " . $dp_data['youhui_id']); $sql = "select count(*) as total,point from " . DB_PREFIX . "supplier_location_dp where youhui_id = " . $item_data['id'] . " group by point "; $data_result = $GLOBALS['db']->getAll($sql); foreach ($data_result as $k => $v) { $item_data['dp_count_' . $v['point']] = $v['total']; } $GLOBALS['db']->autoExecute(DB_PREFIX . "youhui", $item_data, "UPDATE", " id = " . $item_data['id'] . " "); syn_youhui_review_count($item_data['id']); } //创建活动点评数据 if ($dp_data['event_id'] > 0) { //计算总点评1-5星人数 $item_data = $GLOBALS['db']->getRow("select * from " . DB_PREFIX . "event where id = " . $dp_data['event_id']); $sql = "select count(*) as total,point from " . DB_PREFIX . "supplier_location_dp where event_id = " . $item_data['id'] . " group by point "; $data_result = $GLOBALS['db']->getAll($sql); foreach ($data_result as $k => $v) { $item_data['dp_count_' . $v['point']] = $v['total']; } $GLOBALS['db']->autoExecute(DB_PREFIX . "event", $item_data, "UPDATE", " id = " . $item_data['id'] . " "); syn_event_review_count($item_data['id']); } $return['location_id'] = $supplier_location_id; $return['deal_id'] = $dp_data['deal_id']; $return['youhui_id'] = $dp_data['youhui_id']; $return['event_id'] = $dp_data['event_id']; $return['status'] = 1; $return['info'] = "发表成功"; return $return; } else { $return['status'] = 0; $return['info'] = "数据库异常,提交失败"; return $return; } }
public function delete() { if ($_REQUEST['pid'] > 0 && intval($_REQUEST['id']) > 0) { $s_account_info = es_session::get("account_info"); if (!in_array(intval($_POST['pid']), $s_account_info['location_ids'])) { showErr("门店不存在或者没有编辑该门店的权限"); } $image = $GLOBALS['db']->getOne(" SELECT `image` FROM " . DB_PREFIX . "supplier_location_images WHERE id = " . intval($_REQUEST['pid'])); @unlink(APP_ROOT_PATH . $image); $GLOBALS['db']->query("DELETE FROM " . DB_PREFIX . "supplier_location_images WHERE id = " . intval($_REQUEST['pid'])); //更新统计 $supplier_info['id'] = $_REQUEST['id']; syn_supplier_locationcount($supplier_info); $cache_id = md5("store" . "view" . $_REQUEST['id']); $GLOBALS['tmpl']->clear_cache('store_view.html', $cache_id); showSuccess($GLOBALS['lang']['DELETE_SUCCESS'], 0, url("biz", "publish#images", array("id" => intval($_REQUEST['id'])))); } else { app_redirect(url("biz")); } }
function update() { //B('FilterString'); $name = $this->getActionName(); $model = D($name); if (false === ($data = $model->create())) { $this->error($model->getError()); } $id = $data[$model->getPk()]; if ($data['reply_content'] != "" && $data['reply_time'] == "") { $data['reply_time'] = NOW_TIME; } // 更新数据 $list = $model->save($data); $dp = $model->getById($id); if (false !== $list) { //成功提示 $group_points = $_REQUEST['group_point']; foreach ($group_points as $group_id => $point) { $model->query("update " . DB_PREFIX . "supplier_location_dp_point_result set point = " . $point . " where group_id = " . $group_id . " and dp_id = " . $id . " and supplier_location_id = " . $dp['supplier_location_id']); M()->query("update " . DB_PREFIX . "deal_dp_point_result set point = " . $point . " where group_id = " . $group_id . " and dp_id = " . $id . " and deal_id = " . $dp['deal_id']); M()->query("update " . DB_PREFIX . "youhui_dp_point_result set point = " . $point . " where group_id = " . $group_id . " and dp_id = " . $id . " and youhui_id = " . $dp['youhui_id']); M()->query("update " . DB_PREFIX . "event_dp_point_result set point = " . $point . " where group_id = " . $group_id . " and dp_id = " . $id . " and event_id = " . $dp['event_id']); } $group_tags = $_REQUEST['group_tag']; M()->query("update " . DB_PREFIX . "supplier_location_dp set tags_match = '',tags_match_row='' where id = " . $id); foreach ($group_tags as $group_id => $tags) { $model->query("update " . DB_PREFIX . "supplier_location_dp_tag_result set tags = '" . $tags . "' where group_id = " . $group_id . " and dp_id = " . $id . " and supplier_location_id = " . $dp['supplier_location_id']); M()->query("update " . DB_PREFIX . "deal_dp_tag_result set tags = '" . $tags . "' where group_id = " . $group_id . " and dp_id = " . $id . " and deal_id = " . $dp['deal_id']); M()->query("update " . DB_PREFIX . "youhui_dp_tag_result set tags = '" . $tags . "' where group_id = " . $group_id . " and dp_id = " . $id . " and youhui_id = " . $dp['youhui_id']); M()->query("update " . DB_PREFIX . "event_dp_tag_result set tags = '" . $tags . "' where group_id = " . $group_id . " and dp_id = " . $id . " and event_id = " . $dp['event_id']); insert_match_item($tags, "supplier_location_dp", $id, "tags_match"); //更新点评的索引 } $count = M("SupplierLocationDpReply")->where("dp_id=" . $id)->count(); $model->where("id=" . $id)->setField("reply_count", $count); $supplier_info['id'] = $dp['supplier_location_id']; syn_supplier_locationcount($supplier_info); save_log($dp . L("UPDATE_SUCCESS"), 1); $this->assign('jumpUrl', Cookie::get('_currentUrl_')); $this->success(L('UPDATE_SUCCESS')); } else { //错误提示 $dbErr = M()->getDbError(); save_log($dp . L("UPDATE_FAILED") . $dbErr, 0); $this->error(L('EDIT_ERROR')); } }
public function do_sign() { if ($GLOBALS['user_info']) { $point = intval($_REQUEST['point']); $id = intval($_REQUEST['id']); $user_id = intval($GLOBALS['user_info']['id']); if ($point <= 0 || $point > 5) { ajax_return(array("status" => false, "message" => "请点击星星为商家打分,最高5颗星")); } $store_info = $GLOBALS['db']->getRow("select * from " . DB_PREFIX . "supplier_location where id = " . $id . " and is_effect = 1"); if ($store_info) { $begin_time = get_gmtime() - 3 * 24 * 3600; $end_time = get_gmtime() + 3 * 24 * 3600; $sign_data_count = $GLOBALS['db']->getOne("select count(*) from " . DB_PREFIX . "supplier_location_sign_log where user_id = " . $user_id . " and location_id = " . $id . " and (sign_time between {$begin_time} and {$end_time})"); if ($sign_data_count) { ajax_return(array("status" => false, "message" => "最近一周您已经签到过了")); } else { $sign_data['user_id'] = $user_id; $sign_data['location_id'] = $id; $sign_data['point'] = $point; $sign_data['sign_time'] = get_gmtime(); $GLOBALS['db']->autoExecute(DB_PREFIX . "supplier_location_sign_log", $sign_data); syn_supplier_locationcount($store_info); $cache_id = md5("store" . "view" . $store_info['id']); $GLOBALS['tmpl']->clear_cache('store_view.html', $cache_id); ajax_return(array("status" => true, "message" => "签到成功")); } } else { ajax_return(array("status" => false, "message" => "商户不存在")); } } else { ajax_return(array("status" => false, "message" => "请先登录")); } }
public function savereview() { $return["status"] = 0; if (!$GLOBALS['user_info']) { $return["status"] = 2; $return["message"] = $GLOBALS['LANG']["PLEASE_LOGIN_FIRST"]; ajax_return($return); exit; } //验证码 if (app_conf("VERIFY_IMAGE") == 1) { $verify = md5(trim($_REQUEST['verify'])); $session_verify = es_session::get('verify'); if ($verify != $session_verify) { $return["message"] = $GLOBALS['lang']['VERIFY_CODE_ERROR']; ajax_return($return); exit; } } es_session::delete("verify"); //创建基础点评数据 $dp_data = array(); $dp_data['title'] = addslashes(htmlspecialchars($_REQUEST['dp_title'])); $dp_data['content'] = addslashes(htmlspecialchars($_REQUEST['content'])); $dp_data['create_time'] = get_gmtime(); $dp_data['point'] = intval($_REQUEST['dp_point']); $dp_data['user_id'] = intval($GLOBALS['user_info']['id']); $dp_data['supplier_location_id'] = intval($_REQUEST['supplier_location_id']); $dp_data['status'] = 1; if (count($_REQUEST['pics']) > 0) { $dp_data['is_img'] = 1; } $dp_data['avg_price'] = floatval($_REQUEST['avg_price']); $GLOBALS['db']->autoExecute(DB_PREFIX . "supplier_location_dp", $dp_data, "INSERT"); $dp_id = $GLOBALS['db']->insert_id(); if ($dp_id > 0) { increase_user_active(intval($GLOBALS['user_info']['id']), "发表了一则商户点评"); $GLOBALS['db']->query("update " . DB_PREFIX . "user set dp_count = dp_count + 1 where id = " . intval($GLOBALS['user_info']['id'])); //创建点评图库 if (isset($_REQUEST['pics']) && is_array($_REQUEST['pics']) && count($_REQUEST['pics']) > 0) { $photos = $_REQUEST['pics']; foreach ($photos as $pkey => $photo) { $c_data = array(); $c_data['image'] = $photo; $c_data['sort'] = 10; $c_data['create_time'] = get_gmtime(); $c_data['user_id'] = intval($GLOBALS['user_info']['id']); $c_data['supplier_location_id'] = intval($_REQUEST['supplier_location_id']); $c_data['dp_id'] = $dp_id; $c_data['brief'] = addslashes(htmlspecialchars($_REQUEST['brief'][$pkey])); $c_data['status'] = 0; $c_data['image_type'] = intval($_REQUEST['type'][$pkey]); $GLOBALS['db']->autoExecute(DB_PREFIX . "supplier_location_images", $c_data, "INSERT"); } } //创建点评评分 $point_Group = $_REQUEST['dp_point_group']; foreach ($point_Group as $group_id => $point) { $point_data = array(); $point_data['group_id'] = $group_id; $point_data['dp_id'] = $dp_id; $point_data['supplier_location_id'] = intval($_REQUEST['supplier_location_id']); $point_data['point'] = intval($point); $GLOBALS['db']->autoExecute(DB_PREFIX . "supplier_location_dp_point_result", $point_data, "INSERT"); } //创建点评分组的标签 $tag_group = $_REQUEST['dp_tags']; foreach ($tag_group as $group_id => $tag_row) { if (trim($tag_row) != '') { $arr_rer = array(",", ","); $arr_rep = array(" ", " "); $tag_row = str_replace($arr_rer, $arr_rep, $tag_row); $tag_row_data = array(); $tag_row_data['tags'] = $tag_row; $tag_row_data['dp_id'] = $dp_id; $tag_row_data['supplier_location_id'] = intval($_REQUEST['supplier_location_id']); $tag_row_data['group_id'] = $group_id; $GLOBALS['db']->autoExecute(DB_PREFIX . "supplier_location_dp_tag_result", $tag_row_data, "INSERT"); review_supplier_location_match(intval($_REQUEST['supplier_location_id']), $tag_row, $group_id); } } //分享 $supplier_info = $GLOBALS['db']->getRow("select name,id,new_dp_count_time from " . DB_PREFIX . "supplier_location where id = " . $dp_data['supplier_location_id']); $title = "对" . $supplier_info['name'] . "发表了点评"; $url_route = array('rel_app_index' => 'youhui', 'rel_route' => 'store#view', 'rel_param' => 'id=' . $supplier_info['id']); $tid = insert_topic($dp_data['content'], $title, "slocationcomment", $group = "", $relay_id = 0, $fav_id = 0, $group_data = "", $attach_list = array(), $url_route); if ($tid) { $GLOBALS['db']->query("update " . DB_PREFIX . "topic set source_name = '网站' where id = " . intval($tid)); } //更新统计 syn_supplier_locationcount($supplier_info); cache_store_point($supplier_info['id']); $cache_id = md5("store" . "view" . $supplier_info['id']); $GLOBALS['tmpl']->clear_cache('store_view.html', $cache_id); $return['status'] = 1; } else { $return['message'] = "数据库异常,提交失败"; } ajax_return($return); exit; }
public function foreverdelete() { //删除指定记录 $ajax = intval($_REQUEST['ajax']); $id = $_REQUEST['id']; if (!empty($id)) { $name = $this->getActionName(); $model = D($name); $pk = $model->getPk(); $ids = explode(',', $id); $condition = array($pk => array('in', $ids)); $list = $model->where($condition)->findAll(); if (false !== $model->where($condition)->delete()) { //循环删除数据 foreach ($list as $k => $v) { @unlink(APP_ROOT . $v['image']); $supplier_info['id'] = $v['supplier_location_id']; syn_supplier_locationcount($supplier_info); update_supplier_location_img($supplier_info['id']); } save_log($ids . l("FOREVER_DELETE_SUCCESS"), 1); $this->success(l("FOREVER_DELETE_SUCCESS"), $ajax); } else { save_log($ids . l("FOREVER_DELETE_FAILED"), 0); $this->error(l("FOREVER_DELETE_FAILED"), $ajax); } } else { $this->error(l("INVALID_OPERATION"), $ajax); } }
function update() { //B('FilterString'); $name = $this->getActionName(); $model = D($name); if (false === ($data = $model->create())) { $this->error($model->getError()); } $id = $data[$model->getPk()]; // 更新数据 $list = $model->save(); $dp = $model->getById($id); if (false !== $list) { //成功提示 $group_points = $_REQUEST['group_point']; foreach ($group_points as $group_id => $point) { $model->query("update " . DB_PREFIX . "supplier_location_dp_point_result set point = " . $point . " where group_id = " . $group_id . " and dp_id = " . $id . " and supplier_location_id = " . $dp['supplier_location_id']); } $group_tags = $_REQUEST['group_tag']; foreach ($group_tags as $group_id => $tags) { $model->query("update " . DB_PREFIX . "supplier_location_dp_tag_result set tags = '" . $tags . "' where group_id = " . $group_id . " and dp_id = " . $id . " and supplier_location_id = " . $dp['supplier_location_id']); } $count = M("SupplierLocationDpReply")->where("dp_id=" . $id)->count(); $model->where("id=" . $id)->setField("reply_count", $count); $supplier_info['id'] = $dp['supplier_location_id']; syn_supplier_locationcount($supplier_info); save_log($dp . L("UPDATE_SUCCESS"), 1); $this->assign('jumpUrl', Cookie::get('_currentUrl_')); $this->success(L('UPDATE_SUCCESS')); } else { //错误提示 $dbErr = M()->getDbError(); save_log($dp . L("UPDATE_FAILED") . $dbErr, 0); $this->error(L('EDIT_ERROR')); } }
public function update() { if (intval($_POST['id']) == 0) { showErr($GLOBALS['lang']['ERROR_TITLE'], 0, url("biz", "profile")); exit; } $id = intval($_POST['id']); $s_account_info = es_session::get("account_info"); $location_ids = $s_account_info['location_ids']; $info = $GLOBALS['db']->getRow(" SELECT * FROM " . DB_PREFIX . "supplier_location WHERE id = " . intval($id) . " and id in (" . implode(",", $s_account_info['location_ids']) . ")"); if (!$info) { showErr("门店不存在或者没有编辑该门店的权限"); } $data['preview'] = str_replace(get_domain() . APP_ROOT, ".", addslashes(htmlspecialchars(trim($_POST['preview'])))); $data['tags'] = addslashes(htmlspecialchars(trim($_POST['tags']))); $data['address'] = addslashes(htmlspecialchars(trim($_POST['address']))); $data['route'] = addslashes(htmlspecialchars(trim($_POST['route']))); $data['tel'] = addslashes(htmlspecialchars(trim($_POST['tel']))); $data['contact'] = addslashes(htmlspecialchars(trim($_POST['contact']))); $data['open_time'] = addslashes(htmlspecialchars(trim($_POST['open_time']))); $data['api_address'] = addslashes(htmlspecialchars(trim($_POST['api_address']))); $data['xpoint'] = $_POST['xpoint']; $data['ypoint'] = $_POST['ypoint']; $data['sms_content'] = addslashes(htmlspecialchars(trim($_POST['sms_content']))); $data['brief'] = addslashes(trim(replace_public($_POST['brief']))); $data['brief'] = valid_tag($data['brief']); $data['id'] = intval($_POST['id']); $data['seo_title'] = addslashes(htmlspecialchars(trim($_POST['seo_title']))); $data['seo_keyword'] = addslashes(htmlspecialchars(trim($_POST['seo_keyword']))); $data['seo_description'] = addslashes(htmlspecialchars(trim($_POST['seo_description']))); $rs = $GLOBALS['db']->autoExecute(DB_PREFIX . "supplier_location", $data, "UPDATE", " id = " . intval($_POST['id'])); if ($rs) { //更新统计 syn_supplier_locationcount($data); syn_supplier_location_match($data['id']); $cache_id = md5("store" . "view" . $data['id']); $GLOBALS['tmpl']->clear_cache('store_view.html', $cache_id); showSuccess($GLOBALS['lang']['SUPPLIER_MODIFY_SUCCESS'], 0, url("biz", "profile#modify", array("id" => intval($_POST['id'])))); } }