public function index()
{
$pay_status = intval($GLOBALS['request']['pay_status']);
/*0:未付款 、部分,2:已付款*/
$city_name = strim($GLOBALS['request']['city_name']);
//城市名称
//检查用户,用户密码
$user = $GLOBALS['user_info'];
$user_id = intval($user['id']);
$root = array();
$root['return'] = 1;
if ($user_id > 0) {
require_once APP_ROOT_PATH . "system/model/deal_order.php";
$order_table_name = get_user_order_table_name($user_id);
$root['user_login_status'] = 1;
if ($pay_status == 2) {
$pay_status_and = " and pay_status=2 ";
} else {
$pay_status_and = " and pay_status in(0,1) ";
}
//$nowPage = intval($GLOBALS['request']['page']); //当前分页
$nowPage = intval($GLOBALS['request']['page']) ? intval($GLOBALS['request']['page']) : 1;
//当前分页
$totalRows = intval($GLOBALS['request']['totalRows']);
//总记录数
$pageRows = PAGE_SIZE;
//每页显示记录数
$limit = ($nowPage - 1) * $pageRows . "," . $pageRows;
if ($totalRows == 0) {
$totalRows = $GLOBALS['db']->getOne("select count(*) from " . $order_table_name . " where user_id = " . $user_id . " and type = 0 and is_delete = 0 {$pay_status_and}");
}
$totalPages = ceil($totalRows / $pageRows);
//总页数
//$root = array();
$root['totalPages'] = $totalPages;
//总页数
$root['pageRows'] = $pageRows;
//页记录数
$root['nowPage'] = $nowPage;
//当前页
$root['totalRows'] = $totalRows;
//总记录数
$list = $GLOBALS['db']->getAll("select * from " . $order_table_name . " where user_id = " . $user_id . " and type = 0 and is_delete = 0 {$pay_status_and} order by create_time desc limit " . $limit);
$root['return'] = 1;
$orderlist = array();
foreach ($list as $item) {
$orderlist[] = get_order_goods($item);
}
$root['item'] = $orderlist;
if ($pay_status < 2) {
$root['not_pay_count'] = $totalRows;
}
$root['page'] = array("page" => $nowPage, "page_total" => $totalPages, "page_size" => PAGE_SIZE);
} else {
$root['user_login_status'] = 0;
}
$root['city_name'] = $city_name;
$root['page_title'] = '订单列表';
output($root);
}
function get_user_incharge($limit, $user_id)
{
$user_id = intval($user_id);
require_once APP_ROOT_PATH . "system/model/deal_order.php";
$order_table_name = get_user_order_table_name($user_id);
$list = $GLOBALS['db']->getAll("select * from " . $order_table_name . " where user_id = " . $user_id . " and type = 1 and is_delete = 0 order by create_time desc limit " . $limit);
$count = $GLOBALS['db']->getOne("select count(*) from " . $order_table_name . " where user_id = " . $user_id . " and type = 1 and is_delete = 0");
foreach ($list as $k => $v) {
$list[$k]['payment_notice'] = $GLOBALS['db']->getRow("select * from " . DB_PREFIX . "payment_notice where order_id = " . $v['id']);
$list[$k]['payment'] = $GLOBALS['db']->getRow("select * from " . DB_PREFIX . "payment where id = " . $v['payment_id']);
}
return array("list" => $list, 'count' => $count);
}
public function index()
{
global_run();
init_app_page();
$GLOBALS['tmpl']->assign("no_nav", true);
//无分类下拉
if (check_save_login() != LOGIN_STATUS_LOGINED) {
app_redirect(url("index", "user#login"));
}
$did = intval($_REQUEST['did']);
require_once APP_ROOT_PATH . "app/Lib/page.php";
$page_size = 10;
$page = intval($_REQUEST['p']);
if ($page == 0) {
$page = 1;
}
$limit = ($page - 1) * $page_size . "," . $page_size;
$user_id = $GLOBALS['user_info']['id'];
require_once APP_ROOT_PATH . "system/model/deal_order.php";
$order_item_table = get_user_order_item_table_name($user_id);
$order_table = get_user_order_table_name($user_id);
if ($did > 0) {
$order_deal_item = $GLOBALS['db']->getRow("select doi.* from " . $order_item_table . " as doi left join " . $order_table . " as do on doi.order_id = do.id where doi.id = " . $did . " and doi.is_coupon = 1 and do.user_id = " . $user_id);
$deal = load_auto_cache("deal", array("id" => $order_deal_item['deal_id']));
$order_deal_item['url'] = $deal['url'];
}
if ($order_deal_item) {
$sql = "select doi.sub_name,doi.name,doi.number,c.* from " . DB_PREFIX . "deal_coupon as c left join " . $order_item_table . " as doi on doi.id = c.order_deal_id where c.is_valid > 0 and " . " c.user_id = " . $user_id . " and doi.id = " . $order_deal_item['id'] . " order by c.id desc limit " . $limit;
$sql_count = "select count(*) from " . DB_PREFIX . "deal_coupon as c where c.is_valid > 0 and " . " c.user_id = " . $user_id . " and c.order_deal_id = " . $order_deal_item['id'];
$GLOBALS['tmpl']->assign("deal", $order_deal_item);
} else {
$sql = "select doi.sub_name,doi.name,doi.number,c.* from " . DB_PREFIX . "deal_coupon as c left join " . DB_PREFIX . "deal_order_item as doi on doi.id = c.order_deal_id where c.is_valid > 0 and " . " c.user_id = " . $user_id . " order by c.id desc limit " . $limit;
$sql_count = "select count(*) from " . DB_PREFIX . "deal_coupon as c where c.is_valid > 0 and " . " c.user_id = " . $user_id;
}
$list = $GLOBALS['db']->getAll($sql);
foreach ($list as $k => $v) {
$list[$k]['deal'] = load_auto_cache("deal", array("id" => $v['deal_id']));
}
$count = $GLOBALS['db']->getOne($sql_count);
$page = new Page($count, $page_size);
//初始化分页对象
$p = $page->show();
$GLOBALS['tmpl']->assign('pages', $p);
$GLOBALS['tmpl']->assign("list", $list);
$GLOBALS['tmpl']->assign("NOW_TIME", NOW_TIME);
$GLOBALS['tmpl']->assign("page_title", "我的团购券");
assign_uc_nav_list();
$GLOBALS['tmpl']->display("uc/uc_coupon_index.html");
}
public function index()
{
$city_name = strim($GLOBALS['request']['city_name']);
//城市名称
//检查用户,用户密码
$user = $GLOBALS['user_info'];
$user_id = intval($user['id']);
$root = array();
$root['return'] = 1;
if ($user_id > 0) {
$root['user_login_status'] = 1;
$order_id = intval($GLOBALS['request']['id']);
require_once APP_ROOT_PATH . "system/model/deal_order.php";
$order_table_name = get_user_order_table_name($user_id);
//echo $order_id; exit;
$sql = "select o.*,r1.name as r1_name, r2.name as r2_name, r3.name as r3_name, r4.name as r4_name from " . $order_table_name . " as o " . "left outer join " . DB_PREFIX . "delivery_region as r1 on r1.id = o.region_lv1 " . "left outer join " . DB_PREFIX . "delivery_region as r2 on r2.id = o.region_lv2 " . "left outer join " . DB_PREFIX . "delivery_region as r3 on r3.id = o.region_lv3 " . "left outer join " . DB_PREFIX . "delivery_region as r4 on r4.id = o.region_lv4 " . " where o.is_delete = 0 and o.user_id = {$user_id} and o.id = {$order_id} limit 1";
$order_info = $GLOBALS['db']->getRow($sql);
if ($order_info) {
$root = get_order_goods($order_info);
$root['return'] = 1;
$root['user_login_status'] = 1;
$deliveryAddr = array();
$deliveryAddr['consignee'] = $order_info['consignee'];
//联系人姓名
$deliveryAddr['delivery'] = $order_info['r1_name'] . $order_info['r2_name'] . $order_info['r3_name'] . $order_info['r4_name'];
$deliveryAddr['region_lv1'] = $order_info['region_lv1'];
//国家
$deliveryAddr['region_lv2'] = $order_info['region_lv2'];
//省
$deliveryAddr['region_lv3'] = $order_info['region_lv3'];
//城市
$deliveryAddr['region_lv4'] = $order_info['region_lv4'];
//地区/县
$deliveryAddr['delivery_detail'] = $order_info['address'];
//详细地址
$deliveryAddr['phone'] = $order_info['mobile'];
//手机号码
$deliveryAddr['postcode'] = $order_info['zip'];
//邮编
$root['deliveryAddr'] = $deliveryAddr;
$root['delivery_status_2'] = $order_info['delivery_status'];
$root['content'] = $order_info['memo'];
//订单备注
$root['send_mobile'] = $user['mobile'];
//团购券手机
$root['tax_title'] = $order_info['tax_title'];
//发票抬头
$root['tax_id'] = 0;
//发票内容
$root['deliver_time_id'] = 0;
//配送日期ID 默认没有这个参数，所以填0
$root['delivery_list'] = $GLOBALS['m_config']['delivery_list'];
//$default_payment_id = $GLOBALS['m_config']['select_payment_id'];
if ($GLOBALS['request']['payment_id']) {
$default_payment_id = intval($GLOBALS['request']['payment_id']);
} else {
$default_payment_id = $order_info['payment_id'];
}
//$default_payment_id = $order_info['payment_id'];
$root['payment_id'] = $default_payment_id;
//支付方式
$root['order_parm'] = init_order_parm($GLOBALS['m_config']);
$root['order_parm']['has_ecv'] = 0;
//订单付款不支持代金券
$root['evc_sn'] = '';
//优惠券序号
$root['evc_pwd'] = '';
//优惠券序号
$order_item_table_name = get_user_order_item_table_name($user_id);
$goods_list = $GLOBALS['db']->getAll("select * from " . $order_item_table_name . " where order_id = " . $order_id);
$ids = array();
$cart_ids = array();
$root['dp_able'] = 0;
$root['goods_list'] = $goods_list;
foreach ($goods_list as $cart_goods) {
array_push($ids, $cart_goods['deal_id']);
array_push($cart_ids, $cart_goods['id']);
if (empty($cart_goods['dp_id'])) {
if ($root['pay_status'] == 2 && $root['order_status'] == 1 && ($root['delivery_status_code'] == 2 || $root['delivery_status_code'] == 5)) {
$root['dp_able'] = 1;
$root['dp_deal_id'] = $cart_goods['id'];
}
}
}
$ids_str = implode(",", $ids);
$cart_ids_str = implode(",", $cart_ids);
$is_delivery = intval($GLOBALS['db']->getOne("select is_delivery from " . DB_PREFIX . "deal where is_delivery = 1 and id in (" . $ids_str . ")"));
if ($is_delivery == 0) {
$delivery_id = 0;
$root['order_parm']['has_delivery'] = 0;
} else {
if ($GLOBALS['request']['delivery_id']) {
$delivery_id = intval($GLOBALS['request']['delivery_id']);
} else {
$delivery_id = $order_info['delivery_id'];
//配送方式;
}
//$delivery_id = $order_info['delivery_id'];
$root['order_parm']['has_delivery'] = 1;
}
$root['delivery_id'] = $delivery_id;
//配送方式
$has_coupon = intval($GLOBALS['db']->getOne("select count(*) from " . DB_PREFIX . "deal where is_coupon = 1 and id in (" . $ids_str . ")"));
if ($has_coupon == 0) {
$root['order_parm']['has_moblie'] = 0;
$root['order_parm']['has_mcod'] = 1;
} else {
$root['order_parm']['has_moblie'] = 1;
$root['order_parm']['has_mcod'] = 0;
//有团购券商品,不能做：货到付款
}
foreach ($root['order_parm']['payment_list'] as $k => $v) {
if ($v['code'] == 'Mcod' && $root['order_parm']['has_mcod'] == 0) {
unset($root['order_parm']['payment_list'][$k]);
}
}
$forbid_payment = $GLOBALS['db']->getAll("select payment_id from " . DB_PREFIX . "deal_payment where deal_id in (" . $ids_str . ")");
foreach ($forbid_payment as $forbid_payment_item) {
foreach ($root['order_parm']['payment_list'] as $k => $v) {
if ($v['id'] == $forbid_payment_item['payment_id']) {
unset($root['order_parm']['payment_list'][$k]);
}
}
}
$forbid_delivery = $GLOBALS['db']->getAll("select delivery_id from " . DB_PREFIX . "deal_delivery where deal_id in (" . $ids_str . ")");
foreach ($forbid_delivery as $forbid_delivery_item) {
foreach ($root['order_parm']['delivery_list'] as $k => $v) {
if ($v['id'] == $forbid_payment_item['delivery_id']) {
unset($root['order_parm']['delivery_list'][$k]);
}
}
}
//数组按顺序排序
$payment_list = array();
foreach ($root['order_parm']['payment_list'] as $k => $v) {
$payment_list[] = $v;
}
$root['order_parm']['payment_list'] = $payment_list;
$delivery_list = array();
foreach ($root['order_parm']['delivery_list'] as $k => $v) {
$delivery_list[] = $v;
}
$root['order_parm']['delivery_list'] = $delivery_list;
$region4_id = intval($order_info['region_lv4']);
$region3_id = intval($order_info['region_lv3']);
$region2_id = intval($order_info['region_lv2']);
$region1_id = intval($order_info['region_lv1']);
if ($region4_id == 0) {
if ($region3_id == 0) {
if ($region2_id == 0) {
$region_id = $region1_id;
} else {
$region_id = $region2_id;
}
} else {
$region_id = $region3_id;
}
} else {
$region_id = $region4_id;
}
require_once APP_ROOT_PATH . "system/model/cart.php";
//订单的显示参数
if ($order_info['pay_status'] == 0) {
$root['has_cancel'] = 1;
} else {
$root['has_cancel'] = 0;
}
$delivery_notice = $GLOBALS['db']->getRow("select * from " . DB_PREFIX . "delivery_notice where order_item_id in (" . $cart_ids_str . ") order by delivery_time desc limit 1");
if ($delivery_notice) {
$express = $GLOBALS['db']->getRow("select * from " . DB_PREFIX . "express where id = " . intval($delivery_notice['express_id']));
$express['config'] = unserialize($express['config']);
$root['kd_com'] = $express['config']['app_code'];
if ($root['kd_com']) {
$root['kd_sn'] = $delivery_notice['notice_sn'];
}
}
if ($order_info['pay_status'] != 2) {
if ($root['order_parm']['has_delivery'] == 1) {
$root['has_edit_delivery'] = 1;
} else {
$root['has_edit_delivery'] = 0;
}
$root['has_edit_delivery_time'] = 0;
$root['has_edit_invoice'] = 0;
$root['has_edit_ecv'] = 0;
$root['has_edit_message'] = 1;
if ($root['order_parm']['has_moblie'] == 1) {
$root['has_edit_moblie'] = 1;
} else {
$root['has_edit_moblie'] = 0;
}
$GLOBALS['user_info']['id'] = $user_id;
$account_pay = $GLOBALS['db']->getRow("select * from " . DB_PREFIX . "payment where class_name = 'Account'");
if ($account_pay) {
$data = count_buy_total($region_id, $delivery_id, $default_payment_id, $account_money = 0, $all_account_money = 1, '', '', $goods_list, $order_info['account_money'], $order_info['ecv_money']);
} else {
$data = count_buy_total($region_id, $delivery_id, $default_payment_id, $account_money = 0, $all_account_money = 0, '', '', $goods_list, $order_info['account_money'], $order_info['ecv_money']);
}
//print_r($data);exit;
if ($data['pay_price'] == 0) {
if ($data['account_money'] > 0 || $data['ecv_money'] > 0) {
$root['has_pay'] = 1;
$root['use_user_money'] = $data['account_price'];
} else {
$root['has_pay'] = 0;
$root['use_user_money'] = 0;
}
$root['pay_money'] = 0;
//还需要支付金额
} else {
$root['has_pay'] = 1;
$root['pay_money'] = $data['pay_price'];
//还需要支付金额
$root['use_user_money'] = 0;
}
if ($root['has_pay'] == 0) {
$root['has_edit_delivery'] = 0;
$root['has_edit_delivery_time'] = 0;
$root['has_edit_invoice'] = 0;
$root['has_edit_ecv'] = 0;
$root['has_edit_message'] = 0;
$root['has_edit_moblie'] = 0;
}
$root['feeinfo'] = getFeeItem($data);
} else {
$root['has_pay'] = 0;
$root['has_edit_delivery'] = 0;
$root['has_edit_delivery_time'] = 0;
$root['has_edit_invoice'] = 0;
$root['has_edit_ecv'] = 0;
$root['has_edit_message'] = 0;
$root['has_edit_moblie'] = 0;
$data['pay_total_price'] = $order_info['total_price'];
$data['return_total_score'] = $order_info['return_total_score'];
$data['total_price'] = $order_info['deal_total_price'];
$data['delivery_fee'] = $order_info['delivery_fee'];
$data['account_money'] = $order_info['account_money'];
$data['ecv_money'] = $order_info['ecv_money'];
$root['pay_money'] = 0;
//还需要支付金额
$root['use_user_money'] = 0;
$root['feeinfo'] = getFeeItem($data);
//有团购券,再显示团购券列表
$couponlist = $GLOBALS['db']->getAll("select * from " . DB_PREFIX . "deal_coupon where user_id = {$user_id} and order_id = " . $order_id);
foreach ($couponlist as $k => $v) {
$list[$k]['couponSn'] = $v['sn'];
$list[$k]['couponPw'] = $v['password'];
$list[$k]['qrcode'] = str_replace('sjmapi', '', get_domain() . gen_qrcode($v['password']));
}
$root['couponlist'] = $couponlist;
}
$root['complain_status'] = 0;
$complain = $GLOBALS['db']->getRow("SELECT * FROM " . DB_PREFIX . "deal_order_complain WHERE order_id=" . $order_id . " AND user_id=" . $user_id);
if (!empty($complain)) {
$root['complain_status'] = 1;
$root['complain_id'] = $complain['id'];
}
$order_item_info = $GLOBALS['db']->getRow("SELECT * FROM " . DB_PREFIX . "deal_order_item WHERE order_id=" . $order_id . " ");
$root['order_item_info'] = $order_item_info;
} else {
$root['return'] = 0;
$root['info'] = "订单不存在.";
}
} else {
$root['user_login_status'] = 0;
}
$root['pay_status'] = $order_info['pay_status'];
$root['refund_status'] = $order_info['refund_status'];
$root['page_title'] = '订单明细';
$root['city_name'] = $city_name;
output($root);
}
/**
* 生成会员数据
* @param $user_data 提交[post或get]的会员数据
* @param $mode 处理的方式，注册或保存
* 返回：data中返回出错的字段信息，包括field_name, 可能存在的field_show_name 以及 error 错误常量
* 不会更新保存的字段为：score,money,verify,pid
*/
function save_user($user_data, $mode = 'INSERT')
{
//开始数据验证
$res = array('status' => 1, 'info' => '', 'data' => '');
//用于返回的数据
if (trim($user_data['user_name']) == '') {
$field_item['field_name'] = 'user_name';
$field_item['error'] = EMPTY_ERROR;
$res['status'] = 0;
$res['data'] = $field_item;
return $res;
}
// if(!check_username($user_data['user_name']))
// {
// $field_item['field_name'] = 'user_name';
// $field_item['error'] = FORMAT_ERROR;
// $res['status'] = 0;
// $res['data'] = $field_item;
// return $res;
// }
if ($GLOBALS['db']->getOne("select count(*) from " . DB_PREFIX . "user where (user_name = '" . trim($user_data['user_name']) . "' or mobile = '" . trim($user_data['user_name']) . "' or email = '" . trim($user_data['user_name']) . "') and id <> " . intval($user_data['id'])) > 0) {
$field_item['field_name'] = 'user_name';
$field_item['error'] = EXIST_ERROR;
$res['status'] = 0;
$res['data'] = $field_item;
return $res;
}
if ($GLOBALS['db']->getOne("select count(*) from " . DB_PREFIX . "user where (user_name = '" . trim($user_data['email']) . "' or mobile = '" . trim($user_data['email']) . "' or email = '" . trim($user_data['email']) . "') and id <> " . intval($user_data['id'])) > 0) {
$field_item['field_name'] = 'email';
$field_item['error'] = EXIST_ERROR;
$res['status'] = 0;
$res['data'] = $field_item;
return $res;
}
if (trim($user_data['email']) == '') {
$field_item['field_name'] = 'email';
$field_item['error'] = EMPTY_ERROR;
$res['status'] = 0;
$res['data'] = $field_item;
return $res;
}
// if(!check_email(trim($user_data['email'])))
// {
// $field_item['field_name'] = 'email';
// $field_item['error'] = FORMAT_ERROR;
// $res['status'] = 0;
// $res['data'] = $field_item;
// return $res;
// }
if (!check_mobile(trim($user_data['mobile']))) {
$field_item['field_name'] = 'mobile';
$field_item['error'] = FORMAT_ERROR;
$res['status'] = 0;
$res['data'] = $field_item;
return $res;
}
if ($user_data['mobile'] != '' && $GLOBALS['db']->getOne("select count(*) from " . DB_PREFIX . "user where (user_name = '" . trim($user_data['mobile']) . "' or mobile = '" . trim($user_data['mobile']) . "' or email = '" . trim($user_data['mobile']) . "') and id <> " . intval($user_data['id'])) > 0) {
$field_item['field_name'] = 'mobile';
$field_item['error'] = EXIST_ERROR;
$res['status'] = 0;
$res['data'] = $field_item;
return $res;
}
//验证结束开始插入数据
if (isset($user_data['service_level_id']) && $user_data['service_level_id'] != NULL) {
$user['service_level_id'] = $user_data['service_level_id'];
}
if (isset($user_data['belong_to_manager_id']) && $user_data['belong_to_manager_id'] != NULL) {
$user['p_id'] = $user_data['belong_to_manager_id'];
if ($user_data['belong_to_manager_id'] == 'set_null') {
$user['p_id'] = NULL;
}
}
$user['service_type_id'] = $user_data['service_type_id'];
$user['user_name'] = $user_data['user_name'];
$user['create_time'] = NOW_TIME;
$user['update_time'] = NOW_TIME;
$user['pid'] = $user_data['pid'];
if (isset($user_data['province_id'])) {
$user['province_id'] = intval($user_data['province_id']);
}
if (isset($user_data['city_id'])) {
$user['city_id'] = intval($user_data['city_id']);
}
if (isset($user_data['addr_detail'])) {
$user['addr_detail'] = $user_data['addr_detail'];
}
if (isset($user_data['technician_certif'])) {
$user['technician_certif'] = $user_data['technician_certif'];
}
if (isset($user_data['manage_area'])) {
$user['manage_area'] = $user_data['manage_area'];
}
if (isset($user_data['sex'])) {
$user['sex'] = intval($user_data['sex']);
}
$user['my_intro'] = strim($user_data['my_intro']);
if (isset($user_data['byear'])) {
$user['byear'] = intval($user_data['byear']);
}
if (isset($user_data['bmonth'])) {
$user['bmonth'] = intval($user_data['bmonth']);
}
if (isset($user_data['bday'])) {
$user['bday'] = intval($user_data['bday']);
}
if (isset($user_data['is_merchant'])) {
$user['is_merchant'] = intval($user_data['is_merchant']);
$user['merchant_name'] = $user_data['merchant_name'];
}
if (isset($user_data['is_daren'])) {
$user['is_daren'] = intval($user_data['is_daren']);
$user['daren_title'] = $user_data['daren_title'];
}
//自动获取会员分组
if (intval($user_data['group_id']) != 0) {
$user['group_id'] = $user_data['group_id'];
} else {
if ($mode == 'INSERT') {
//获取默认会员组, 即升级积分最小的会员组
$user['group_id'] = $GLOBALS['db']->getOne("select id from " . DB_PREFIX . "user_group order by score asc limit 1");
}
}
//会员状态
if (intval($user_data['is_effect']) != 0) {
$user['is_effect'] = $user_data['is_effect'];
} else {
if ($mode == 'INSERT') {
$user['is_effect'] = app_conf("USER_VERIFY");
}
}
$user['email'] = $user_data['email'];
$user['mobile'] = $user_data['mobile'];
if ($mode == 'INSERT') {
$user['code'] = '';
//默认不使用code, 该值用于其他系统导入时的初次认证
} else {
$db_user = $GLOBALS['db']->getRow("select user_name,is_tmp,code from " . DB_PREFIX . "user where id =" . $user_data['id']);
$user['code'] = $db_user['code'];
if ($db_user['is_tmp'] == 0) {
$user['user_name'] = $db_user['user_name'];
} else {
$user['is_tmp'] = 0;
}
}
if (isset($user_data['user_pwd']) && $user_data['user_pwd'] != '') {
$user['user_pwd'] = md5($user_data['user_pwd'] . $user['code']);
}
$res['user_pwd'] = $user['user_pwd'];
//载入会员整合
$integrate_code = strim(app_conf("INTEGRATE_CODE"));
if ($integrate_code != '') {
$integrate_file = APP_ROOT_PATH . "system/integrate/" . $integrate_code . "_integrate.php";
if (file_exists($integrate_file)) {
require_once $integrate_file;
$integrate_class = $integrate_code . "_integrate";
$integrate_obj = new $integrate_class();
}
}
//同步整合
if ($integrate_obj) {
if ($mode == 'INSERT') {
$res = $integrate_obj->add_user($user_data['user_name'], $user_data['user_pwd'], $user_data['email']);
$user['integrate_id'] = intval($res['data']);
} else {
$add_res = $integrate_obj->add_user($user_data['user_name'], $user_data['user_pwd'], $user_data['email']);
if (intval($add_res['status'])) {
$GLOBALS['db']->query("update " . DB_PREFIX . "user set integrate_id = " . intval($add_res['data']) . " where id = " . intval($user_data['id']));
} else {
if (isset($user_data['user_pwd']) && $user_data['user_pwd'] != '') {
$status = $integrate_obj->edit_user($user, $user_data['user_pwd']);
if ($status <= 0) {
//修改密码失败
$res['status'] = 0;
}
}
}
}
if (intval($res['status']) == 0) {
return $res;
}
}
if ($user['email'] == "") {
unset($user['email']);
}
if ($user['mobile'] == "") {
unset($user['mobile']);
}
if ($mode == 'INSERT') {
$s_api_user_info = es_session::get("api_user_info");
$user[$s_api_user_info['field']] = $s_api_user_info['id'];
es_session::delete("api_user_info");
$where = '';
} else {
unset($user['pid']);
$where = "id=" . intval($user_data['id']);
}
if ($GLOBALS['db']->autoExecute(DB_PREFIX . "user", $user, $mode, $where)) {
if ($mode == 'INSERT') {
$user_id = $GLOBALS['db']->insert_id();
$register_money = doubleval(app_conf("USER_REGISTER_MONEY"));
$register_score = intval(app_conf("USER_REGISTER_SCORE"));
$register_point = intval(app_conf("USER_REGISTER_POINT"));
if ($register_money > 0 || $register_score > 0 || $register_point > 0) {
$user_get['score'] = $register_score;
$user_get['money'] = $register_money;
$user_get['point'] = $register_point;
modify_account($user_get, intval($user_id), "在" . to_date(NOW_TIME) . "注册成功");
}
} else {
$user_id = $user_data['id'];
$GLOBALS['db']->query("update " . DB_PREFIX . "deal_order set user_name = '" . $user_data['user_name'] . "' where user_id = " . $user_id);
require_once APP_ROOT_PATH . "system/model/deal_order.php";
$user_order_table_name = get_user_order_table_name($user_id);
$GLOBALS['db']->query("update " . $user_order_table_name . " set user_name = '" . $user_data['user_name'] . "' where user_id = " . $user_id);
}
}
$res['data'] = $user_id;
//开始更新处理扩展字段
if ($mode == 'INSERT') {
foreach ($user_field as $field_item) {
$extend = array();
$extend['user_id'] = $user_id;
$extend['field_id'] = $field_item['id'];
$extend['value'] = $user_data[$field_item['field_name']];
$GLOBALS['db']->autoExecute(DB_PREFIX . "user_extend", $extend, $mode);
}
} else {
foreach ($user_field as $field_item) {
$extend = $GLOBALS['db']->getRow("select * from " . DB_PREFIX . "user_extend where user_id=" . $user_id . " and field_id =" . $field_item['id']);
if ($extend) {
$extend['value'] = $user_data[$field_item['field_name']];
$where = 'id=' . $extend['id'];
$GLOBALS['db']->autoExecute(DB_PREFIX . "user_extend", $extend, $mode, $where);
} else {
$extend = array();
$extend['user_id'] = $user_id;
$extend['field_id'] = $field_item['id'];
$extend['value'] = $user_data[$field_item['field_name']];
$GLOBALS['db']->autoExecute(DB_PREFIX . "user_extend", $extend, "INSERT");
}
}
}
load_user($user_id, true);
return $res;
}
/**
* 删除订单至回收站(历史订单)
* @param unknown_type $order_id
* 返回:true/false
*/
function del_order($order_id)
{
$order_info = $GLOBALS['db']->getRow("select * from " . DB_PREFIX . "deal_order where id = " . $order_id . " and order_status = 1");
if ($order_info) {
unset($order_info['id']);
unset($order_info['deal_order_item']);
$order_items = $GLOBALS['db']->getAll("select * from " . DB_PREFIX . "deal_order_item where order_id = " . $order_id);
$order_info['history_deal_order_item'] = serialize($order_items);
$order_info['history_deal_coupon'] = serialize($GLOBALS['db']->getAll("select * from " . DB_PREFIX . "deal_coupon where order_id = " . $order_id));
$order_info['history_deal_order_log'] = serialize($GLOBALS['db']->getAll("select * from " . DB_PREFIX . "deal_order_log where order_id = " . $order_id));
$order_info['history_delivery_notice'] = serialize($GLOBALS['db']->getAll("select * from " . DB_PREFIX . "delivery_notice where order_id = " . $order_id));
$order_info['history_payment_notice'] = serialize($GLOBALS['db']->getAll("select * from " . DB_PREFIX . "payment_notice where order_id = " . $order_id));
$order_info['history_message'] = serialize($GLOBALS['db']->getAll("select * from " . DB_PREFIX . "message where rel_table = 'deal_order' and rel_id = " . $order_id));
$GLOBALS['db']->autoExecute(DB_PREFIX . "deal_order_history", $order_info, 'INSERT', '', 'SILENT');
if ($GLOBALS['db']->insert_id()) {
//删除会员相关分表
$user_order_table = get_user_order_table_name($order_info['user_id']);
$user_order_item_table = get_user_order_item_table_name($order_info['user_id']);
$GLOBALS['db']->query("delete from " . $user_order_table . " where id = " . $order_id);
$GLOBALS['db']->query("delete from " . $user_order_item_table . " where order_id = " . $order_id);
//删除商户相关表
foreach ($order_items as $item) {
$supplier_order_table = get_supplier_order_table_name($item['supplier_id']);
$supplier_order_item_table = get_supplier_order_item_table_name($item['supplier_id']);
$GLOBALS['db']->query("delete from " . $supplier_order_table . " where id = " . $order_id);
$GLOBALS['db']->query("delete from " . $supplier_order_item_table . " where order_id = " . $order_id);
}
$GLOBALS['db']->query("delete from " . DB_PREFIX . "deal_order where id = " . $order_id);
$GLOBALS['db']->query("delete from " . DB_PREFIX . "deal_order_item where order_id = " . $order_id);
//$GLOBALS['db']->query("delete from ".DB_PREFIX."deal_coupon where order_id = ".$order_id);
$GLOBALS['db']->query("update " . DB_PREFIX . "deal_coupon set order_id = -1 where order_id = " . $order_id);
$GLOBALS['db']->query("delete from " . DB_PREFIX . "deal_order_log where order_id = " . $order_id);
$GLOBALS['db']->query("delete from " . DB_PREFIX . "delivery_notice where order_id = " . $order_id);
$GLOBALS['db']->query("delete from " . DB_PREFIX . "payment_notice where order_id = " . $order_id);
$GLOBALS['db']->query("delete from " . DB_PREFIX . "message where rel_table='deal_order' and rel_id = " . $order_id);
return true;
} else {
return false;
}
} else {
return false;
}
}
public function refuse_delivery()
{
global_run();
if (check_save_login() != LOGIN_STATUS_LOGINED) {
$data['status'] = 1000;
ajax_return($data);
} else {
$id = intval($_REQUEST['id']);
$user_id = intval($GLOBALS['user_info']['id']);
require_once APP_ROOT_PATH . "system/model/deal_order.php";
$order_table_name = get_user_order_table_name($user_id);
$content = strim($_REQUEST['content']);
if ($content == "") {
$data['status'] = 0;
$data['info'] = "请输入具体说明";
ajax_return($data);
}
$delivery_notice = $GLOBALS['db']->getRow("select n.* from " . DB_PREFIX . "delivery_notice as n left join " . $order_table_name . " as o on n.order_id = o.id where n.order_item_id = " . $id . " and o.user_id = " . $user_id . " and is_arrival = 0 order by delivery_time desc");
if ($delivery_notice) {
require_once APP_ROOT_PATH . "system/model/deal_order.php";
$res = refuse_delivery($delivery_notice['notice_sn'], $id);
if ($res) {
$msg = array();
$msg['rel_table'] = "deal_order";
$msg['rel_id'] = $delivery_notice['order_id'];
$msg['title'] = "订单维权";
$msg['content'] = "订单维权：" . $content;
$msg['create_time'] = NOW_TIME;
$msg['user_id'] = $GLOBALS['user_info']['id'];
$GLOBALS['db']->autoExecute(DB_PREFIX . "message", $msg);
$data['status'] = true;
$data['info'] = "维权提交成功";
ajax_return($data);
} else {
$data['status'] = 0;
$data['info'] = "维权提交失败";
ajax_return($data);
}
} else {
$data['status'] = 0;
$data['info'] = "订单未发货";
ajax_return($data);
}
}
}
