public function register_device()
{
$device = isset($_POST['device']) ? (int) htmlspecialchars($_POST['device']) : '';
//1 android 2 ios
$dev_id = isset($_POST['dev_id']) ? htmlspecialchars($_POST['dev_id']) : '';
$session_id = $_POST['session_id'];
$member_id = $this->session_handle->getsession_userid($session_id, 1);
$systemid = CommonController::getSystemUserid($member_id['id'], $member_id['type']);
if (empty($device) || $device != '1' || $device != '2') {
$this->jsonUtils->echo_json_msg(4, '设备不正确');
exit;
}
if (empty($dev_id)) {
$this->jsonUtils->echo_json_msg(4, '设备号为空');
exit;
}
$db = M('Device');
//判断
$data = $db->where(array('dev_id' => $dev_id, 'device' => $device))->getField('id');
if ($data) {
}
}
/**
* 商家详情
*
* @return [type] [description]
*/
public function getMerchant()
{
$mer_session_id = isset($_POST['mer_session_id']) ? htmlspecialchars(trim($_POST['mer_session_id'])) : '';
$merchant_id = isset($_POST['merchant_id']) ? htmlspecialchars($_POST['merchant_id']) : '';
if (empty($merchant_id)) {
if (!empty($mer_session_id)) {
$merchant = $this->session_handle->getsession_userid($mer_session_id, 1);
$merchant_id = $merchant['id'];
} else {
$this->jsonUtils->echo_json_msg(6, '商家id为空');
}
}
$arr = $this->dao->field(" id as merchant_id,wifi_enable,merchant_name,header,manager,business_time,tel,intro,address,pics,collect_count,comment_count,business_time,mobile,area_id ")->where("id={$merchant_id}")->select();
if ($arr) {
$systemid = CommonController::getSystemUserid($merchant_id, 2);
if ($arr[0]['pics']) {
$json_obj = json_decode($arr[0]['pics'], true);
$arr[0]['pics'] = imgUrl($json_obj);
}
$arr[0]['header'] = imgUrl($arr[0]['header']);
$star = MerchantController::getMerCommentStar($merchant_id);
$arr[0]['system_user_id'] = $systemid;
$arr[0]['service_quality'] = $star['service_quality'];
$arr[0]['service_attitude'] = $star['service_attitude'];
$arr[0]['merchant_setting'] = $star['merchant_setting'];
$this->jsonUtils->echo_json_data(0, "ok", $arr[0]);
exit;
} else {
$this->jsonUtils->echo_json_msg(1, '获取商家信息错误！');
exit;
}
}
/**
* 举报 system_user_id
* type 1 色情 2暴力 3 发动 4 广告 5 骚扰信息 6资料不当 7 侵犯版权 8 其他
*
* position 1 举报问题 2 举报问题回复 3举报问题评论 4举报遇见 5 举报遇见的评论 6举报个人
* obj_id 1 问题id 2 回复id 3评论id 4 遇见id 5遇见评论id 6 system_user_id
*/
public function report()
{
$session_id = isset($_POST['session_id']) ? htmlspecialchars($_POST['session_id']) : '';
$member_id = $this->session_handle->getsession_userid($session_id, 1);
$systemid = CommonController::getSystemUserid($member_id['id'], $member_id['type']);
$position = isset($_POST['position']) ? htmlspecialchars($_POST['position']) : '';
$type = isset($_POST['type']) ? htmlspecialchars($_POST['type']) : '';
//
$obj_id = isset($_POST['obj_id']) ? htmlspecialchars($_POST['obj_id']) : '';
if (empty($position)) {
$this->jsonUtils->echo_json_msg(4, '举报来源为空...');
exit;
}
if (empty($type)) {
$this->jsonUtils->echo_json_msg(4, '举报分类为空...');
exit;
}
if (empty($obj_id)) {
$this->jsonUtils->echo_json_msg(4, '举报对象为空...');
exit;
}
$db = M('Report');
$unique = $db->where(array('reporter' => $systemid, 'position' => $position, 'obj_id' => $obj_id))->getField('id');
if ($unique) {
$this->jsonUtils->echo_json_msg(0, '你已举报过');
exit;
} else {
$data = $db->add(array('reporter' => $systemid, 'position' => $position, 'obj_id' => $obj_id, 'type' => $type, 'addtime' => time()));
if ($data) {
$this->jsonUtils->echo_json_msg(0, '举报成功');
exit;
} else {
$this->jsonUtils->echo_json_msg(1, '举报失败');
exit;
}
}
}
public function jpush()
{
$jid = isset($_REQUEST['jid']) ? htmlspecialchars($_REQUEST['jid']) : '';
$content = isset($_POST['content']) ? htmlspecialchars($_POST['content']) : '';
$session_id = isset($_POST['session_id']) ? htmlspecialchars($_POST['session_id']) : '';
$member_id = $this->session_handle->getsession_userid($session_id, 1);
$systemid = CommonController::getSystemUserid($member_id['id'], $member_id['type']);
$user = M('SystemUser')->where(array('id' => $jid))->field('type,name')->find();
//jpush
$jpush = new \App\Model\JpushModel();
$jpush->user = $user['type'];
$string = $content;
$jpush->push(5, array($jid), array('content' => $string, 'jid' => $systemid, 'title' => $user['name']));
$this->jsonUtils->echo_json_msg(0, 'ok');
exit;
}
public function get_order()
{
$order_no = isset($_POST['order_no']) ? htmlspecialchars($_POST['order_no']) : '';
$member_session_id = $_POST['member_session_id'];
$member_id = $this->session_handle->getsession_userid($member_session_id);
if (empty($order_no)) {
$this->jsonUtils->echo_json_msg(4, '订单号为空...');
exit;
}
$arr = $this->dao->table(C('DB_PREFIX') . "order as a")->field("a.order_no,a.addtime,b.id as merchant_id,b.header,b.merchant_name,a.reach_time,a.cart_data,a.member_remark,a.merchant_remark,a.total_price,a.total_time,a.type,a.sub_data,a.member_comment,a.merchant_comment,a.fail_content,a.status,b.tel")->join(C('DB_PREFIX') . 'merchant as b on a.merchant_id = b.id')->where("a.order_no={$order_no} and a.member_id = {$member_id} ")->find();
if ($arr) {
$cart = json_decode($arr['cart_data'], true);
unset($arr['cart_data']);
$arr['system_user_id'] = CommonController::getSystemUserid($arr['merchant_id'], 2);
$arr['header'] = imgUrl($arr['header']);
$arr['cart_model'] = $cart['cart_model'];
$arr['reach_time'] = date('Y-m-d H:i:s', $arr['reach_time']);
$arr['addtime'] = date('Y-m-d H:i:s', $arr['addtime']);
// $arr ['header'] = imgUrl ( $arr ['header'] );
$model = new Model();
$sub_data = json_decode($arr['sub_data'], true);
switch ($arr['type']) {
// 0 预约 1需求 2活动
case '0':
$arr['pics'] = imgUrl($sub_data['pics']);
// $arr ['distance'] = '';
$arr['list'] = $sub_data['list'];
break;
case '1' or '3':
// 需求
$arr['pics'] = imgUrl($sub_data['pics']);
// $arr ['distance'] = $sub_data ['distance'];
$arr['list'] = $sub_data['list'];
break;
case '2':
// 活动
// $arr ['distance'] = '';
$arr['list'] = array();
break;
default:
$this->jsonUtils->echo_json_msg(4, '数据异常');
exit;
break;
}
unset($arr['sub_data']);
if ($arr['status'] != 0) {
if ($arr['member_comment'] > 0) {
$sql = "select a.desc,c.header,c.nick_name,a.pics,from_unixtime(a.addtime,'%Y-%m-%d %H:%i:%s') as addtime,\r\n\t\t\t\t\ta.service_attitude,a.service_quality,a.merchant_setting\r\n\t\t\t\t\tfrom " . C('DB_PREFIX') . "comment as a left join\r\n\t\t\t\t\t" . C('DB_PREFIX') . "member as c on a.member_id=c.id\r\n\t\t\t\t\twhere a.order_no={$arr['order_no']} and type=0 limit 1";
$arro = $this->dao->query($sql);
$arro[0]['header'] = imgUrl($arro[0]['header']);
$arro[0]['pics'] = imgUrl(json_decode($arro[0]['pics'], true));
$arr['member_comment'] = '1';
$arr['member_comment_info'] = empty($arro[0]) ? '' : $arro[0];
} else {
$arr['member_comment'] = '0';
$arr['member_comment_info'] = '';
}
if ($arr['merchant_comment'] > 0) {
$sql = "select a.desc,c.header,a.pics,c.merchant_name as nick_name,a.service_attitude,from_unixtime(a.addtime,'%Y-%m-%d %H:%i:%s') as addtime \r\n\t\t\t\t\tfrom " . C('DB_PREFIX') . "comment as a left join " . C('DB_PREFIX') . "merchant as c \r\n\t\t\t\t\ton a.merchant_id=c.id where a.order_no={$arr['order_no']} and type=2 limit 1";
$arro = $this->dao->query($sql);
$arro[0]['header'] = imgUrl($arro[0]['header']);
$arro[0]['pics'] = imgUrl(json_decode($arro[0]['pics'], true));
$arr['merchant_comment'] = '1';
$arr['merchant_comment_info'] = empty($arro[0]) ? '' : $arro[0];
} else {
$arr['merchant_comment'] = '0';
$arr['merchant_comment_info'] = '';
}
} else {
$arr['merchant_comment_info'] = '';
$arr['member_comment_info'] = '';
}
$this->jsonUtils->echo_json_data(0, 'ok', $arr);
exit;
} else {
$this->jsonUtils->echo_json_msg(1, '该订单不存在..');
exit;
}
}
/**
* 收藏列表
*/
public function collect_listV2()
{
$member_session_id = $_POST['session_id'];
$page = isset($_POST['page']) ? htmlspecialchars($_POST['page']) : '1';
$num = isset($_POST['num']) ? htmlspecialchars($_POST['num']) : '6';
// 1 收藏商家 3用户收藏问答 4 商家收藏问答
$type = isset($_POST['type']) ? htmlspecialchars($_POST['type']) : '1';
$limit = ($page - 1) * $num . ',' . $num;
if ($type == 1) {
$member_id = $this->session_handle->getsession_userid($member_session_id);
$model = new Model();
$sql = "select b.id as merchant_id ,b.header,b.merchant_name,d.name as city_name,c.name as area_name,b.address\r\n\t\t\tfrom " . C('DB_PREFIX') . "collect as a left join\r\n\t\t\t" . C('DB_PREFIX') . "merchant as b on a.obj_id=b.id\r\n\t\t\tleft join " . C('DB_PREFIX') . "city as c on c.id=b.area_id\r\n\t\t\tleft join " . C('DB_PREFIX') . "city as d on d.id=b.city_id\r\n\t\t\twhere a.member_id={$member_id} and a.type = 1 limit {$limit}";
$arr = $model->query($sql);
if ($arr) {
foreach ($arr as $key => $value) {
$arr[$key]['header'] = imgUrl($value['header']);
}
$data['list'] = $arr;
$this->jsonUtils->echo_json_data(0, 'ok', $data);
exit;
} else {
$data['list'] = array();
$this->jsonUtils->echo_json_msg(0, 'ok', $data);
exit;
}
} elseif ($type == 3 || $type == 4) {
$member_id = $this->session_handle->getsession_userid($member_session_id, 1);
$systemid = CommonController::getSystemUserid($member_id['id'], $member_id['type']);
$model = new Model();
$sql = "select c.title,c.id as problem_id,d.name as category_name,e.header,b.id as reply_id,b.reply_content,b.laud_count,b.collect_count\r\n\t\t\tfrom " . C('DB_PREFIX') . "collect as a left join\r\n\t\t\t" . C('DB_PREFIX') . "answer_reply as b on a.obj_id=b.id\r\n\t\t\tleft join " . C('DB_PREFIX') . "system_user as e on e.id=b.reply_id\r\n\t\t\tleft join " . C('DB_PREFIX') . "answer_problem as c on c.id=b.issue_id\r\n\t\t\tleft join " . C('DB_PREFIX') . "answer_category as d on d.id=c.pid\r\n\t\t\twhere a.member_id={$systemid} and a.type = {$type} order by a.addtime desc limit {$limit}";
$arr = $model->query($sql);
if (!$arr) {
$arr = array();
} else {
foreach ($arr as $key => $row) {
$arr[$key]['header'] = imgUrl($row['header']);
}
}
$data['list'] = $arr;
$this->jsonUtils->echo_json_data(0, 'ok', $data);
exit;
}
}
/**
* 用户查看需求详情
*/
public function get_demand()
{
$id = isset($_POST['id']) ? htmlspecialchars($_POST['id']) : '';
$merchant_id = isset($_POST['merchant_id']) ? htmlspecialchars($_POST['merchant_id']) : '';
$member_session_id = isset($_POST['member_session_id']) ? htmlspecialchars($_POST['member_session_id']) : '';
//
$member_id = $this->session_handle->getsession_userid($member_session_id);
if (empty($id)) {
$this->jsonUtils->echo_json_msg(4, '需求ID为空...');
exit;
}
// 判断是否有改需求
$bidding_arr = $this->dao->where("id={$id} and member_id = {$member_id} and member_del = 0")->find();
if ($bidding_arr == false) {
$this->jsonUtils->echo_json_msg(1, '该需求不存在...');
exit;
}
if ($bidding_arr['is_bidding']) {
$longitude = $_POST['longitude'];
$latitude = $_POST['latitude'];
if (empty($longitude) || empty($latitude)) {
$this->jsonUtils->echo_json_msg(4, '经度或者纬度为空...');
exit;
}
if (empty($merchant_id)) {
$this->jsonUtils->echo_json_msg(4, '商家id为空...');
exit;
}
// 需求项目列表信息
// 查询某个商家对用户需求的所有报价
$bidding = $this->getMerchantBiddingBy($id, $merchant_id, $bidding_arr['publish']);
$total_price = 0;
$total_time = 0;
foreach ($bidding as $key => $row) {
if ($row['price'] > 0) {
$total_price += $row['price'];
}
if ($row['time'] > 0) {
$total_time += $row['time'];
}
}
$model = new Model();
// 需求报价总价格和总服务时间
$cart = json_decode($bidding_arr['cart_data'], true);
$data['cart_model'] = $cart['cart_model'];
$data['reach_time'] = date('Y-m-d H:i:s', $bidding_arr['reach_time']);
$data['pics'] = imgUrl(json_decode($bidding_arr['pics'], true));
$data['description'] = $bidding_arr['description'];
$data['list'] = $bidding;
$data["total_price"] = (string) $total_price;
$data['total_time'] = (string) $total_time;
$data['demand_status'] = $bidding_arr['status'];
// 1 已过期 0 未过期
$is_expire = time() - $bidding_arr['expire_time'] > 0 ? '1' : '0';
if ($is_expire) {
if ($bidding_arr['status'] == 0) {
$data['demand_status'] = '3';
//过期
}
}
// 商家备注
$remark_arr = $model->query("select remark from " . C('DB_PREFIX') . "merchant_bidding_remark where demand_id={$id} and merchant_id = {$merchant_id}");
$data['remark'] = $remark_arr[0]['remark'] == null ? '' : $remark_arr[0]['remark'];
// 商家信息
$merchant_arr = $model->query("select id,merchant_name,header,intro,longitude,latitude,tel from " . C('DB_PREFIX') . "merchant where id={$merchant_id}");
$merchant_arr[0]['header'] = imgUrl($merchant_arr[0]['header']);
$merchant_arr[0]['system_user_id'] = CommonController::getSystemUserid($merchant_arr[0]['id'], 2);
$data['merchant_info'] = $merchant_arr[0];
$distance = getDistance($latitude, $longitude, $merchant_arr[0]['latitude'], $merchant_arr[0]['longitude']);
$data['merchant_info']['distance'] = $distance;
$this->jsonUtils->echo_json_data(0, 'ok', $data);
exit;
} else {
if ($bidding_arr['pics']) {
$data['pics'] = imgUrl(json_decode($bidding_arr['pics'], true));
}
$cart = json_decode($bidding_arr['cart_data'], true);
$data['id'] = $bidding_arr['id'];
$data['title'] = $bidding_arr['title'];
$data['reach_time'] = date('Y-m-d H:i:s', $bidding_arr['reach_time']);
$data['cart_model'] = $cart['cart_model'];
$data['description'] = $bidding_arr['description'];
$data['province_id'] = CityController::getName($bidding_arr['province_id']);
$data['city_id'] = CityController::getName($bidding_arr['city_id']);
$data['area_id'] = CityController::getName($bidding_arr['area_id']);
$data['demand_status'] = $bidding_arr['status'];
// 1 已过期 0 未过期
$is_expire = time() - $bidding_arr['expire_time'] > 0 ? '1' : '0';
if ($is_expire) {
if ($bidding_arr['status'] == 0) {
$data['demand_status'] = '3';
//过期
}
}
$this->jsonUtils->echo_json_data(0, 'ok', $data);
exit;
}
}
/**
* 获取某人动态
* 公共查看
*/
public function getSomeoneRecentV2()
{
$session_id = isset($_POST['session_id']) ? htmlspecialchars($_POST['session_id']) : '';
if (!empty($session_id)) {
$member_id = $this->session_handle->getsession_userid($session_id, 1);
$systemid = CommonController::getSystemUserid($member_id['id'], $member_id['type']);
}
$system_user_id = isset($_POST['system_user_id']) ? (int) htmlspecialchars($_POST['system_user_id']) : '';
$longitude = isset($_POST['longitude']) ? htmlspecialchars($_POST['longitude']) : '';
$latitude = isset($_POST['latitude']) ? htmlspecialchars($_POST['latitude']) : '';
$page = isset($_POST['page']) ? htmlspecialchars($_POST['page']) : '1';
$num = isset($_POST['num']) ? htmlspecialchars($_POST['num']) : '6';
if (empty($system_user_id) && empty($systemid)) {
$this->jsonUtils->echo_json_msg(4, '参数不全');
exit;
}
if (empty($system_user_id) && !empty($systemid)) {
$system_user_id = $systemid;
}
if (!empty($longitude) && !empty($latitude)) {
$disable = true;
} else {
$disable = false;
}
$time = time();
$db = M('AnswerUserRecent');
$count = $db->where(array('system_user_id' => $system_user_id, 'status' => 0))->count();
$data = $db->table(C('DB_PREFIX') . "answer_user_recent as a")->join(C('DB_PREFIX') . "system_user as b on b.id = a.system_user_id")->join(C('DB_PREFIX') . "member as c on (c.id = b.sub_id and b.type = 0)")->where(array('a.system_user_id' => $system_user_id, 'a.status' => 0))->field('a.id,a.system_user_id,a.content,a.pics,a.addtime,a.laud_count,a.comment_count,a.longitude,a.latitude,b.name,b.header,b.brand_icon,c.gender')->page($page)->order('addtime desc')->limit($num)->select();
if ($data) {
if ($disable) {
foreach ($data as $key => $row) {
$data[$key]['addtime'] = dealtime($row['addtime']);
$data[$key]['header'] = imgUrl($row['header']);
$data[$key]['gender'] = !empty($row['gender']) ? $row['gender'] : '0';
$data[$key]['brand_icon'] = imgUrl($row['brand_icon']);
$data[$key]['pics'] = imgUrl(json_decode($row['pics'], true));
$data[$key]['distance'] = getDistance($longitude, $latitude, $row['longitude'], $row['latitude']);
unset($data[$key]['longitude']);
unset($data[$key]['latitude']);
}
} else {
foreach ($data as $key => $row) {
$data[$key]['addtime'] = date('Y-m-d H:i:s', $row['addtime']);
$data[$key]['header'] = imgUrl($row['header']);
$data[$key]['gender'] = !empty($row['gender']) ? $row['gender'] : '0';
$data[$key]['brand_icon'] = imgUrl($row['brand_icon']);
$data[$key]['pics'] = imgUrl(json_decode($row['pics'], true));
}
}
} else {
$data = array();
}
$arr['count'] = empty($count) ? 0 : $count;
$arr['list'] = $data;
$this->jsonUtils->echo_json_data(0, 'ok', $arr);
exit;
}