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); } } }