public function index()
{
$root = array();
$email = strim($GLOBALS['request']['biz_email']);
//用户名或邮箱
$pwd = strim($GLOBALS['request']['biz_pwd']);
//密码
//检查用户,用户密码
$biz_user = biz_check($email, $pwd);
$supplier_id = intval($biz_user['supplier_id']);
$deal_id = intval($GLOBALS['request']['deal_id']);
//团购商品id
if ($supplier_id > 0) {
$root['user_login_status'] = 1;
//用户登陆状态：1:成功登陆;0：未成功登陆
$sql = "update " . DB_PREFIX . "message set is_read = 1 where is_read = 0 and rel_id = " . $deal_id . " and rel_table = 'deal' and pid = 0 and is_buy = 1";
//$root['sql'] = $sql;
$GLOBALS['db']->query($sql);
$root['return'] = 1;
} else {
$root['return'] = 0;
$root['user_login_status'] = 0;
//用户登陆状态：1:成功登陆;0：未成功登陆
$root['info'] = "商户不存在或密码错误";
}
output($root);
}
public function index()
{
$root = array();
$email = strim($GLOBALS['request']['biz_email']);
//用户名或邮箱
$pwd = strim($GLOBALS['request']['biz_pwd']);
//密码
//检查用户,用户密码
$biz_user = biz_check($email, $pwd);
$supplier_id = intval($biz_user['supplier_id']);
$deal_id = intval($GLOBALS['request']['deal_id']);
//团购商品id
if ($supplier_id > 0) {
$page = intval($GLOBALS['request']['page']);
if ($page == 0) {
$page = 1;
}
$limit = ($page - 1) * PAGE_SIZE . "," . PAGE_SIZE;
$list = $GLOBALS['db']->getAll("select d.sn,d.password,d.confirm_time from " . DB_PREFIX . "deal_coupon as d where d.confirm_account > 0 and d.is_valid = 1 and d.is_delete = 0 and d.deal_id = " . $deal_id . " and d.supplier_id = " . $supplier_id . " order by d.confirm_time desc limit " . $limit);
foreach ($list as $k => $v) {
$list[$k]['confirm_time_format'] = to_date($v['confirm_time'], 'Y-m-d H:i');
}
$count = $GLOBALS['db']->getOne("select count(*) from " . DB_PREFIX . "deal_coupon as d where d.confirm_account > 0 and d.is_valid = 1 and d.is_delete = 0 and d.deal_id = " . $deal_id . " and d.supplier_id = " . $supplier_id);
$root['page'] = array("page" => $page, "page_total" => ceil($count / PAGE_SIZE), "page_size" => PAGE_SIZE);
$root['item'] = $list;
$root['return'] = 1;
}
output($root);
}
public function index()
{
$email = strim($GLOBALS['request']['biz_email']);
//用户名或邮箱
$pwd = strim($GLOBALS['request']['biz_pwd']);
//密码
$city_name = strim($GLOBALS['request']['city_name']);
//城市名称
$root['page_title'] = '验证及消费登记';
//检查用户,用户密码
$biz_user = biz_check($email, $pwd);
$supplier_id = intval($biz_user['supplier_id']);
if ($supplier_id > 0) {
$root['return'] = 1;
$root['user_login_status'] = 1;
//用户登陆状态：1:成功登陆;0：未成功登陆
$root['info'] = "商家登陆成功";
$root['status'] = 1;
$root['biz_login_status'] = 1;
//用户登陆状态：1:成功登陆;0：未成功登陆
} else {
$root['info'] = "请先登陆";
$root['return'] = 0;
$root['status'] = 0;
$root['user_login_status'] = 0;
//用户登陆状态：1:成功登陆;0：未成功登陆
$root['biz_login_status'] = 0;
$root['uid'] = 0;
$root['user_name'] = $email;
}
$root['city_name'] = $city_name;
output($root);
}
public function index()
{
$root = array();
$email = strim($GLOBALS['request']['biz_email']);
//用户名或邮箱
$pwd = strim($GLOBALS['request']['biz_pwd']);
//密码
//检查用户,用户密码
$biz_user = biz_check($email, $pwd);
$supplier_id = intval($biz_user['supplier_id']);
$type = strim($GLOBALS['request']['type']);
//0:全部评价;1:差评;2:未读
$deal_id = strim($GLOBALS['request']['deal_id']);
//团购商品id
if ($supplier_id > 0) {
$root['user_login_status'] = 1;
//用户登陆状态：1:成功登陆;0：未成功登陆
$page = intval($GLOBALS['request']['page']);
if ($page == 0) {
$page = 1;
}
$limit = ($page - 1) * PAGE_SIZE . "," . PAGE_SIZE;
$sql = "select m.id,m.content,m.create_time,m.update_time, m.point,m.admin_reply,m.admin_id,u.user_name from " . DB_PREFIX . "message m left join fanwe_user u on u.id = m.user_id where m.rel_id = " . $deal_id . " and m.rel_table = 'deal' and m.pid = 0 and m.is_buy = 1";
$count_sql = "select count(*) from " . DB_PREFIX . "message m left join fanwe_user u on u.id = m.user_id where m.rel_id = " . $deal_id . " and m.rel_table = 'deal' and m.pid = 0 and m.is_buy = 1";
//0:全部评价;1:差评;2:未读
if ($type == 1) {
$sql .= " and m.point <= 2 ";
$count_sql .= " and m.point <= 2 ";
} else {
if ($type == 2) {
$sql .= " and m.is_read = 0 ";
$count_sql .= " and m.is_read = 0 ";
}
}
$count = $GLOBALS['db']->getOne($count_sql);
$sql .= " order by m.create_time desc limit " . $limit;
$deal_list = $GLOBALS['db']->getAll($sql);
//$root['sql'] = $sql;
//echo $sql; exit;
foreach ($deal_list as $k => $v) {
$deal_list[$k]['create_time_format'] = to_date($v['create_time'], 'Y-m-d H:i');
$deal_list[$k]['update_time_format'] = to_date($v['update_time'], 'Y-m-d H:i');
}
$root['page'] = array("page" => $page, "page_total" => ceil($count / PAGE_SIZE), "page_size" => PAGE_SIZE);
if ($deal_list == false || $deal_list == null) {
$deal_list = array();
}
//$root['count'] = count($deal_list);
//$root['22'] = print_r($deal_list,1);
$root['item'] = $deal_list;
$root['return'] = 1;
} else {
$root['return'] = 0;
$root['user_login_status'] = 0;
//用户登陆状态：1:成功登陆;0：未成功登陆
$root['info'] = "商户不存在或密码错误";
}
output($root);
}
public function index()
{
$root = array();
$email = strim($GLOBALS['request']['biz_email']);
//用户名或邮箱
$pwd = strim($GLOBALS['request']['biz_pwd']);
//密码
//检查用户,用户密码
$biz_user = biz_check($email, $pwd);
$supplier_id = intval($biz_user['supplier_id']);
if ($supplier_id > 0) {
$title = strim($GLOBALS['request']['title']);
//前台，老板，财务，其它
$content = strim($GLOBALS['request']['content']);
//意见反馈
$contact = strim($GLOBALS['request']['contact']);
//联系方式
$reply_data = array();
$reply_data['title'] = $title;
$reply_data['content'] = $content;
$reply_data['create_time'] = get_gmtime();
$reply_data['rel_table'] = 'feedback';
$reply_data['rel_id'] = 0;
$reply_data['user_id'] = 0;
$reply_data['pid'] = 0;
$reply_data['is_effect'] = 1;
$reply_data['city_id'] = 0;
$reply_data['is_buy'] = 0;
$reply_data['contact_name'] = 0;
$reply_data['contact'] = $contact;
$reply_data['point'] = 0;
$reply_data['is_read'] = 0;
$GLOBALS['db']->autoExecute(DB_PREFIX . "message", $reply_data);
$msg_id = intval($GLOBALS['db']->insert_id());
if ($msg_id > 0) {
$root['return'] = 1;
$root['info'] = "反馈成功";
} else {
$root['return'] = 0;
$root['info'] = "反馈失败";
}
} else {
$root['return'] = 0;
$root['user_login_status'] = 0;
//用户登陆状态：1:成功登陆;0：未成功登陆
$root['info'] = "商户不存在或密码错误";
}
output($root);
}
public function index()
{
$email = strim($GLOBALS['request']['biz_email']);
//用户名或邮箱
$pwd = strim($GLOBALS['request']['biz_pwd']);
//密码
$city_name = strim($GLOBALS['request']['city_name']);
//城市名称
$root['page_title'] = '商户登陆';
$root['city_name'] = $city_name;
if (empty($email) || empty($pwd)) {
$root['return'] = 0;
output($root);
exit;
}
//检查用户,用户密码
$biz_user = biz_check($email, $pwd);
$supplier_id = intval($biz_user['supplier_id']);
if ($supplier_id > 0) {
$root['return'] = 1;
$root['user_login_status'] = 1;
//用户登陆状态：1:成功登陆;0：未成功登陆
$root['info'] = "商家登陆成功";
$root['supplier_id'] = $biz_user['supplier_id'];
$root['supplier_name'] = $biz_user['name'];
$root['account_name'] = $biz_user['account_name'];
$root['biz_email'] = $email;
$root['biz_pwd'] = $biz_user['account_password'];
$root['status'] = 1;
$root['biz_login_status'] = 1;
//用户登陆状态：1:成功登陆;0：未成功登陆
} else {
$err = "商户不存在或密码错误";
$root['return'] = 0;
$root['status'] = 0;
$root['user_login_status'] = 0;
//用户登陆状态：1:成功登陆;0：未成功登陆
$root['biz_login_status'] = 0;
$root['info'] = $err;
$root['uid'] = 0;
$root['user_name'] = $email;
}
output($root);
}
public function index()
{
$GLOBALS['lang'] = (require APP_ROOT_PATH . "app/Lang/zh-cn/lang.php");
$email = strim($GLOBALS['request']['biz_email']);
//用户名或邮箱
$pwd = strim($GLOBALS['request']['biz_pwd']);
//密码
//检查用户,用户密码
$biz_user = biz_check($email, $pwd);
$supplier_id = intval($biz_user['supplier_id']);
if ($supplier_id > 0) {
$root['user_login_status'] = 1;
//用户登陆状态：1:成功登陆;0：未成功登陆
require_once APP_ROOT_PATH . "system/model/biz_verify.php";
//$sn = htmlspecialchars(addslashes(trim($GLOBALS['request']['coupon_sn'])));
$pwd = htmlspecialchars(addslashes(trim($GLOBALS['request']['coupon_pwd'])));
//$result = biz_check_coupon($biz_user,null,$pwd);
$location_id = $GLOBALS['db']->getOne("select id from " . DB_PREFIX . "supplier_location where supplier_id=" . $supplier_id . " and is_main=1 and is_effect=1");
$result = biz_check_coupon($biz_user, $pwd, $location_id);
$root['return'] = 1;
$root['status'] = $result['status'];
if ($result['status'] == 1) {
$root['info'] = $result['sub_msg'];
//可消费的团购券数量，现按单发短信时，只能一次性消费掉所有的团购券
$root['max_num'] = $result['number'];
$root['min_num'] = $result['number'];
} else {
$root['info'] = $result['msg'];
//'此密码错误,不能接待。请与消费者确认提供的密码是否正确';
//可消费的团购券数量
$root['max_num'] = 0;
$root['min_num'] = 0;
}
} else {
$root['return'] = 0;
$root['user_login_status'] = 0;
//用户登陆状态：1:成功登陆;0：未成功登陆
$root['info'] = "商户不存在或密码错误";
}
output($root);
}
public function index()
{
$root = array();
$email = strim($GLOBALS['request']['biz_email']);
//用户名或邮箱
$pwd = strim($GLOBALS['request']['biz_pwd']);
//密码
//检查用户,用户密码
$biz_user = biz_check($email, $pwd);
$supplier_id = intval($biz_user['supplier_id']);
$id = intval($GLOBALS['request']['id']);
//消息id
$deal_id = intval($GLOBALS['request']['deal_id']);
//团购商品id
$admin_reply = strim($GLOBALS['request']['admin_reply']);
//回复内容
if (empty($admin_reply)) {
$root['return'] = 0;
$root['user_login_status'] = 0;
//用户登陆状态：1:成功登陆;0：未成功登陆
$root['info'] = "回复不能为空";
} else {
if ($supplier_id > 0) {
$root['user_login_status'] = 1;
//用户登陆状态：1:成功登陆;0：未成功登陆
$sql = "update " . DB_PREFIX . "message set admin_reply = '" . $admin_reply . "',admin_id={$supplier_id},update_time=" . get_gmtime() . " where id = " . $id . " and rel_id = " . $deal_id . " and rel_table = 'deal' and pid = 0 and is_buy = 1";
//echo $sql;exit;
//$root['sql'] = $sql;
$GLOBALS['db']->query($sql);
$root['return'] = 1;
} else {
$root['return'] = 0;
$root['user_login_status'] = 0;
//用户登陆状态：1:成功登陆;0：未成功登陆
$root['info'] = "商户不存在或密码错误";
}
}
output($root);
}
public function index()
{
$GLOBALS['lang'] = (require APP_ROOT_PATH . "app/Lang/zh-cn/lang.php");
$email = strim($GLOBALS['request']['biz_email']);
//用户名或邮箱
$pwd = strim($GLOBALS['request']['biz_pwd']);
//密码
//检查用户,用户密码
$biz_user = biz_check($email, $pwd);
$supplier_id = intval($biz_user['supplier_id']);
if ($supplier_id > 0) {
$root['user_login_status'] = 1;
//用户登陆状态：1:成功登陆;0：未成功登陆
require_once APP_ROOT_PATH . "system/model/biz_verify.php";
//使用数量
$use_num = intval($GLOBALS['request']['use_num']);
if ($use_num <= 0) {
$use_num = 1;
}
$pwd = htmlspecialchars(addslashes(trim($GLOBALS['request']['coupon_pwd'])));
$result = biz_use_coupon($biz_user, null, $pwd, $use_num);
$root['return'] = 1;
$root['status'] = $result['status'];
if ($result['status'] == 1) {
$root['info'] = $result['sub_msg'];
} else {
$root['info'] = $result['msg'];
}
} else {
$root['return'] = 0;
$root['user_login_status'] = 0;
//用户登陆状态：1:成功登陆;0：未成功登陆
$root['info'] = "商户不存在或密码错误";
}
output($root);
}
public function index()
{
require_once APP_ROOT_PATH . "system/model/user.php";
$root = array();
$email = strim($GLOBALS['request']['biz_email']);
//用户名或邮箱
$pwd = strim($GLOBALS['request']['biz_pwd']);
//密码
//检查用户,用户密码
$biz_user = biz_check($email, $pwd);
$supplier_id = intval($biz_user['supplier_id']);
$type = strim($GLOBALS['request']['type']);
//0:消费者评价;1:消费统计
if ($supplier_id > 0) {
$root['user_login_status'] = 1;
//用户登陆状态：1:成功登陆;0：未成功登陆
$page = intval($GLOBALS['request']['page']);
if ($page == 0) {
$page = 1;
}
$limit = ($page - 1) * PAGE_SIZE . "," . PAGE_SIZE;
if ($type == 1) {
$sql = "select DISTINCT d.id,d.begin_time,d.current_price,d.sub_name,d.name,d.img from " . DB_PREFIX . "deal as d left join " . DB_PREFIX . "deal_location_link as l on l.deal_id = d.id where d.is_shop in (0,2) and l.location_id in (" . implode(",", $biz_user['location_ids']) . ") and d.is_delete = 0 and d.supplier_id = " . $supplier_id . " order by d.id desc limit " . $limit;
} else {
$sql = "select DISTINCT d.id,d.begin_time,d.current_price,d.sub_name,d.name,d.img from " . DB_PREFIX . "deal as d left join " . DB_PREFIX . "deal_location_link as l on l.deal_id = d.id where d.is_shop = 0 and l.location_id in (" . implode(",", $biz_user['location_ids']) . ") and d.is_delete = 0 and d.supplier_id = " . $supplier_id . " order by d.id desc limit " . $limit;
}
//print_r($biz_user);
//echo $sql; exit;
$deal_list = $GLOBALS['db']->getAll($sql);
foreach ($deal_list as $k => $v) {
$deal_list[$k]['begin_time_format'] = to_date($v['begin_time'], 'Y-m-d');
$deal_list[$k]['current_price_format'] = format_price($v['current_price']);
//$deal_list[$k]['begin_time_format'] = to_date($v['begin_time'], 'Y-m-d');
if ($type == 1) {
//已售团购券数量
$deal_list[$k]['coupon_count'] = intval($GLOBALS['db']->getOne("select count(*) from " . DB_PREFIX . "deal_coupon as dc where dc.deal_id = " . $v['id'] . " and dc.is_valid = 1 and dc.is_delete = 0 "));
//已消费团购券数量
$deal_list[$k]['confirm_count'] = intval($GLOBALS['db']->getOne("select count(*) from " . DB_PREFIX . "deal_coupon as dc where dc.deal_id = " . $v['id'] . " and dc.is_valid = 1 and dc.is_delete = 0 and dc.confirm_account <> 0"));
$deal_list[$k]['img'] = get_abs_img_root(get_spec_image($v['img'], 160, 160, 0));
//$deal_list[$k]['img2'] = get_domain().APP_ROOT;
} else {
//购买点评数量
$deal_list[$k]['buy_dp_count'] = intval($GLOBALS['db']->getOne("select count(*) from " . DB_PREFIX . "message where rel_id = " . $v['id'] . " and rel_table = 'deal' and pid = 0 and is_buy = 1"));
//购买点评未读数
$deal_list[$k]['buy_dp_no_read_count'] = intval($GLOBALS['db']->getOne("select count(*) from " . DB_PREFIX . "message where rel_id = " . $v['id'] . " and rel_table = 'deal' and pid = 0 and is_buy = 1 and is_read = 0"));
//购买差评数
$deal_list[$k]['buy_dp_low_point_count'] = intval($GLOBALS['db']->getOne("select count(*) from " . DB_PREFIX . "message where rel_id = " . $v['id'] . " and rel_table = 'deal' and pid = 0 and is_buy = 1 and point <= 2"));
//星级点评数
$deal_list[$k]['star_1'] = 0;
$deal_list[$k]['star_2'] = 0;
$deal_list[$k]['star_3'] = 0;
$deal_list[$k]['star_4'] = 0;
$deal_list[$k]['star_5'] = 0;
$buy_dp_sum = 0.0;
$buy_dp_group = $GLOBALS['db']->getAll("select point,count(*) as num from " . DB_PREFIX . "message where rel_id = " . $v['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) {
$deal_list[$k]['star_' . $star] = $dp_v['num'];
$buy_dp_sum += $star * $dp_v['num'];
}
}
//点评平均分
$deal_list[$k]['buy_dp_avg'] = round($buy_dp_sum / $deal_list[$k]['buy_dp_count'], 1);
}
}
$deal_count = $GLOBALS['db']->getOne("select count(*) from " . DB_PREFIX . "deal as d left join " . DB_PREFIX . "deal_location_link as l on l.deal_id = d.id where l.location_id in (" . implode(",", $biz_user['location_ids']) . ") and d.is_delete = 0 and d.supplier_id = " . $supplier_id);
$root['page'] = array("page" => $page, "page_total" => ceil($deal_count / PAGE_SIZE), "page_size" => PAGE_SIZE);
if ($deal_list == false || $deal_list == null) {
$deal_list = array();
}
$root['item'] = $deal_list;
$root['return'] = 1;
} else {
$root['return'] = 0;
$root['user_login_status'] = 0;
//用户登陆状态：1:成功登陆;0：未成功登陆
$root['info'] = "商户不存在或密码错误";
}
output($root);
}
public function index()
{
//file_put_contents("../auto_order.txt",print_r($GLOBALS['request']));
require_once APP_ROOT_PATH . "system/libs/user.php";
$root = array();
$email = strim($GLOBALS['request']['biz_email']);
//用户名或邮箱
$pwd = strim($GLOBALS['request']['biz_pwd']);
//密码
$user_qrcode = strim($GLOBALS['request']['user_qrcode']);
//会员二维码
$num = intval($GLOBALS['request']['num']);
//购买数量
if ($num == 0) {
$num = 1;
}
$deal_id = intval($GLOBALS['request']['deal_id']);
//购买的商品id
$money = floatval($GLOBALS['request']['money']);
//消费总金额;
//检查用户,用户密码
$biz_user = biz_check($email, $pwd);
$supplier_id = intval($biz_user['supplier_id']);
if ($supplier_id > 0) {
$root['user_login_status'] = 1;
$time = get_gmtime();
$sql = "select id, user_name, user_qrcode, qrcode_end from " . DB_PREFIX . "user where user_qrcode = '" . $user_qrcode . "' limit 1";
$user = $GLOBALS['db']->getRow($sql);
if (!$user) {
$root['return'] = 0;
$root['info'] = "会员卡不存在";
output($root);
} else {
if ($user['qrcode_end'] < $time) {
$root['return'] = 0;
$root['info'] = "会员卡已过期";
output($root);
}
}
$sql = "select d.id,d.name,d.sub_name,d.icon, d.buy_type, d.current_price, d.return_score, d.return_qrcode_money from " . DB_PREFIX . "deal as d where d.supplier_id =" . $supplier_id . " and d.id = " . $deal_id;
$deal = $GLOBALS['db']->getRow($sql);
if (!$deal) {
$root['return'] = 0;
$root['info'] = "商品不存在:" . $deal_id;
output($root);
}
$user_id = $user['id'];
if ($money == 0) {
$money = $deal['current_price'] * $num;
}
$root['status'] = 1;
//验证成功
//开始生成订单
$now = get_gmtime();
$order['type'] = 0;
//普通订单
$order['user_id'] = $user_id;
$order['user_name'] = $user['user_name'];
$order['create_time'] = $now;
$order['total_price'] = $money;
//应付总额 商品价 - 会员折扣 + 运费 + 支付手续费
$order['pay_amount'] = $money;
$order['pay_status'] = 2;
//线下支付，直接支付成功
$order['delivery_status'] = 5;
$order['order_status'] = 0;
//新单都为零， 等下面的流程同步订单状态
$order['return_total_score'] = 0;
//结单后送的积分
$order['return_total_money'] = $deal['return_qrcode_money'] * $num;
//结单后送的现金
$order['memo'] = '会员卡扫描下单,金额为:' . format_price($money);
$order['deal_total_price'] = $money;
//团购商品总价
$order['discount_price'] = 0;
$order['delivery_fee'] = 0;
$order['ecv_money'] = 0;
$order['account_money'] = 0;
$order['ecv_sn'] = '';
$order['delivery_id'] = 0;
//线下支付
$order['payment_id'] = 0;
$order['payment_fee'] = 0;
$order['bank_id'] = 0;
$order['is_auto_order'] = 1;
//门店自主下单标识
do {
$order['order_sn'] = to_date(get_gmtime(), "Ymdhis") . rand(10, 99);
$GLOBALS['db']->autoExecute(DB_PREFIX . "deal_order", $order, 'INSERT', '', 'SILENT');
$order_id = intval($GLOBALS['db']->insert_id());
} while ($order_id == 0);
if ($order_id > 0) {
$deal_id = intval($deal['id']);
$goods_item = array();
$goods_item['deal_id'] = $deal_id;
$goods_item['number'] = $num;
$goods_item['unit_price'] = $money;
$goods_item['total_price'] = $money;
$goods_item['name'] = $deal['name'];
$goods_item['sub_name'] = $deal['sub_name'];
$goods_item['attr'] = '0';
$goods_item['verify_code'] = md5($deal_id . "_0");
$goods_item['order_id'] = $order_id;
$goods_item['return_score'] = $deal['return_score'];
$goods_item['return_total_score'] = $order['return_total_score'];
$goods_item['return_money'] = $deal['return_qrcode_money'];
$goods_item['return_total_money'] = $order['return_total_money'];
$goods_item['buy_type'] = $deal['buy_type'];
$goods_item['attr_str'] = '';
//$deal['attr_str'];
$goods_item['balance_unit_price'] = 0;
$goods_item['balance_total_price'] = 0;
$GLOBALS['db']->autoExecute(DB_PREFIX . "deal_order_item", $goods_item, 'INSERT', '', 'SILENT');
if ($order['return_total_money'] != 0) {
$msg = sprintf($GLOBALS['lang']['ORDER_RETURN_MONEY'], $order['order_sn']);
modify_account(array('money' => $order['return_total_money'], 'score' => 0), $order['user_id'], $msg);
}
if ($order['return_total_score'] != 0) {
$msg = sprintf($GLOBALS['lang']['ORDER_RETURN_SCORE'], $order['order_sn']);
modify_account(array('money' => 0, 'score' => $order['return_total_score']), $order['user_id'], $msg);
}
$sql = "update " . DB_PREFIX . "deal set buy_count = buy_count + " . $num . ",user_count = user_count + 1 where id=" . $deal_id;
$GLOBALS['db']->query($sql);
//增加商品的发货量
}
$root['order_id'] = $order_id;
$root['info'] = '交易完成,共获得:' . format_price($order['return_total_money']) . " 返利";
} else {
$root['user_login_status'] = 0;
$root['info'] = '请先登陆';
}
output($root);
}
public function index()
{
require_once APP_ROOT_PATH . "system/libs/user.php";
$root = array();
$email = strim($GLOBALS['request']['biz_email']);
//用户名或邮箱
$pwd = strim($GLOBALS['request']['biz_pwd']);
//密码
$user_qrcode = strim($GLOBALS['request']['user_qrcode']);
//会员二维码
$page = intval($GLOBALS['request']['page']);
//分页
if ($page == 0) {
$page = 1;
}
$limit = ($page - 1) * PAGE_SIZE . "," . PAGE_SIZE;
$keyword = strim($GLOBALS['request']['keyword']);
//查询关键字
//检查用户,用户密码
$biz_user = biz_check($email, $pwd);
$supplier_id = intval($biz_user['supplier_id']);
if ($supplier_id > 0) {
$root['user_login_status'] = 1;
//用户登陆状态：1:成功登陆;0：未成功登陆
$time = get_gmtime();
$sql = "select id, user_name, user_qrcode, qrcode_end from " . DB_PREFIX . "user where user_qrcode = '" . $user_qrcode . "' limit 1";
$user = $GLOBALS['db']->getRow($sql);
if (!$user) {
$root['return'] = 0;
$root['info'] = "会员卡不存在";
output($root);
} else {
if ($user['qrcode_end'] < $time) {
$root['return'] = 0;
$root['info'] = "会员卡已过期";
output($root);
}
}
$root['user_id'] = $user['id'];
$root['user_qrcode'] = $user['user_qrcode'];
$root['user_name'] = $user['user_name'];
$sql = "select d.id,d.name,d.sub_name,d.icon, d.current_price,d.return_qrcode_money from " . DB_PREFIX . "deal as d left join " . DB_PREFIX . "deal_location_link as l on l.deal_id = d.id where ";
$count_sql = "select count(d.id) from " . DB_PREFIX . "deal as d left join " . DB_PREFIX . "deal_location_link as l on l.deal_id = d.id where ";
$condition = " d.is_shop in (0,1) and l.location_id in (" . implode(",", $biz_user['location_ids']) . ") and d.is_delete = 0 and d.supplier_id = " . $supplier_id . " and d.buy_type = 0 and d.publish_wait = 0 ";
$condition .= " and ((" . $time . ">= d.begin_time or d.begin_time = 0) and (" . $time . "< d.end_time or d.end_time = 0) and d.buy_status <> 2) ";
//$condition .= " and d.return_qrcode_money > 0";
if ($keyword) {
$kws_div = div_str($keyword);
foreach ($kws_div as $k => $item) {
$kws[$k] = str_to_unicode_string($item);
}
$ukeyword = implode(" ", $kws);
$condition .= " and (match(d.tag_match,d.name_match,d.locate_match,d.deal_cate_match) against('" . $ukeyword . "' IN BOOLEAN MODE) or d.name like '%" . $keyword . "%') ";
}
$sql .= $condition . " order by d.id desc limit " . $limit;
//$root['sql'] = $sql;
$count_sql .= $condition;
//print_r($biz_user);
//echo $sql; exit;
$deal_list = $GLOBALS['db']->getAll($sql);
foreach ($deal_list as $k => $v) {
$deal_list[$k]['icon'] = get_abs_img_root(get_spec_image($v['icon'], 360, 288, 0));
$deal_list[$k]['current_price_format'] = format_price($v['current_price']);
$deal_list[$k]['return_qrcode_money_format'] = format_price($v['return_qrcode_money']);
$deal_list[$k]['allow_edit_total_money'] = 1;
//允许下单时，直接编辑商品总价
}
$deal_count = $GLOBALS['db']->getOne($count_sql);
$root['page'] = array("page" => $page, "page_total" => ceil($deal_count / PAGE_SIZE), "page_size" => PAGE_SIZE);
if ($deal_list == false || $deal_list == null) {
$deal_list = array();
}
$root['item'] = $deal_list;
$root['return'] = 1;
$root['info'] = "商品列表";
} else {
$root['return'] = 0;
$root['user_login_status'] = 0;
//用户登陆状态：1:成功登陆;0：未成功登陆
$root['info'] = "商户不存在或密码错误";
}
output($root);
}