def get_address():
"""[서비스] user가 주문시 이전 배송지 존재하면 가져오기
Author:
Ji Yoon Lee
Args:
- token(str) : 로그인 user의 token이 header에 담겨 들어와 로그인 유효성 검사를 거침
Returns:
- 200:
{ 'message' : 'SUCCESS',
'result' : {
'data' : 배송지 목록
}
}
- 400: 요청 실패시 '요청에 실패하였습니다'
"""
connection = None
try:
user_id = g.token_info['user_id']
connection = connect_db()
if connection:
order_service = OrderService()
address_option = order_service.get_address(user_id, connection)
return address_option
except Exception as e:
raise ApiException(400, REQUEST_FAILED)
finally:
if connection:
connection.close()
def get_order_detail(order_item_id):
# 주문 상세정보 가져오는 엔드포인트
order_service = OrderService()
order_filter = {'order_item_id': order_item_id}
# # 셀러일 경우 필터에 seller_id 추가
# if g.token_info['account_type_id'] == 2:
# order_filter['seller_id'] = g.token_info['seller_id']
connection = None
try:
connection = connect_db()
order_detail = order_service.get_order_detail(
connection, order_filter)
return jsonify(order_detail), 200
except Exception as e:
return jsonify({"message": f"{e}"}), 400
finally:
try:
if connection:
connection.close()
except Exception as e:
return jsonify({"message": f"{e}"}), 500
def get_shipping_memo():
"""[서비스] user가 주문시 배송메모 선택하는 드롭박스
Author:
Ji Yoon Lee
Returns:
- 200:
{ 'message' : 'SUCCESS',
'result' : {
'data' : 배송 메모 리스트
}
}
- 400: 요청 실패시 '요청에 실패하였습니다'
"""
connection = None
try:
connection = connect_db()
if connection:
order_service = OrderService()
memo_option = order_service.get_shipping_memo(connection)
return memo_option
except Exception as e:
raise ApiException(400, REQUEST_FAILED)
finally:
if connection:
connection.close()
def update_order_status(*args):
# 주문 id를 리스트로 받아서 일괄적으로 주문 상태를 업데이트하는 엔드포인트
order_service = OrderService()
update_status = {
'editor_id': g.token_info['account_id'],
'order_item_id': args[0],
'order_status_id': args[1],
'order_action_id': args[2]
}
connection = None
try:
connection = connect_db()
number_of_orders_updated = order_service.update_order_status(
connection, update_status)
connection.commit()
return jsonify({
"message":
f"{number_of_orders_updated} order(s) successfully updated"
}), 201
except Exception as e:
connection.rollback()
return jsonify({"message": f"{e}"}), 400
finally:
try:
if connection:
connection.close()
except Exception as e:
return jsonify({"message": f"{e}"}), 500
def post_order_confirmation_direct():
""" [서비스] 제품 상세페이지에서 바로결제로 주문 (배송정보 입력페이지로 넘어가는 부분)
Author:
Ji Yoon Lee
Args:
- token(str): 로그인 user의 token이 header에 담겨 들어와 로그인 유효성 검사를 거침
- body(dict): 바로결제 할 상품의 'productId', 상품정보 담긴 'products'
Returns:
- 200:
{ 'message': 'SUCCESS',
'result': {
'data': 주문 id (orderId)
}
}
- 400: 필수 parameter 미입력시 '** 정보를 입력해 주세요'
"""
connection = None
try:
data = request.json
# request로 들어온 데이터 검증
if 'productId' not in data:
raise ApiException(400, PRODUCT_MISSING)
if 'products' not in data:
raise ApiException(400, PRODUCT_INFO_MISSING)
products = data['products']
for product in products:
if 'color' not in product:
raise ApiException(400, COLOR_NOT_IN_INPUT)
if 'size' not in product:
raise ApiException(400, SIZE_NOT_IN_INPUT)
order_info = {
'user_id': g.token_info['user_id'],
'product_id': data['productId'],
'order_status_type_id': 3
# 바로결제 시도시 order_status_type_id = 3
}
connection = connect_db()
if connection:
order_service = OrderService()
order_id = order_service.direct_purchase(order_info, products, connection)
connection.commit()
return order_id
except Exception as e:
connection.rollback()
raise e
finally:
if connection:
connection.close()
def post_address():
""" [서비스] user가 주문시 새로운 배송지 추가
Author:
Ji Yoon Lee
Args:
- token(str) : 로그인 user의 token이 header에 담겨 들어와 로그인 유효성 검사를 거침
- body(dict) : 'name', 'phone', 'postal', 'address', 'addressDetail', 'isDefault'(optional)
Returns:
- 200 :
{ 'message' : 'SUCCESS',
'result' : {
'data' : 새로 등록된 주소 id (address_id)
}
}
- 400 : 필수 parameter 미입력시 '** 정보를 입력해 주세요'
Note:
- 배송지의 address, address_detail이 동일한 주소는 중복 등록 불가
"""
connection = None
# try:
data = request.json
if 'name' not in data:
raise ApiException(400, NAME_MISSING)
if 'phone' not in data:
raise ApiException(400, PHONE_MISSING)
if 'postal' not in data:
raise ApiException(400, POSTAL_MISSING)
if 'address' not in data:
raise ApiException(400, ADDRESS_MISSING)
if 'addressDetail' not in data:
raise ApiException(400, ADDRESS_DETAIL_MISSING)
address_info = {
'user_id' : g.token_info['user_id'],
'recipient_name' : data['name'],
'recipient_phone' : data['phone'],
'recipient_postal_code' : data['postal'],
'recipient_address' : data['address'],
'recipient_address_detail' : data['addressDetail'],
'is_default' : data.get('isDefault', 0)
}
connection = connect_db()
if connection:
order_service = OrderService()
post_address = order_service.post_address(address_info, connection)
connection.commit()
return post_address
def post_cart():
""" [서비스] 카트에 상품 담기
Author:
Mark Hasung Kim
Returns:
{
"custom_message": "SUCCESS",
"result": "POST
}
"""
connection = None
try:
data = request.json
user_id = g.token_info['user_id']
products = data['products']
if 'products' not in data:
raise ApiException(400, INVALID_INPUT)
if 'productId' not in data:
raise ApiException(400, INVALID_INPUT)
if not products:
raise ApiException(400, INVALID_INPUT)
for product in products:
if 'color' not in product:
raise ApiException(400, COLOR_NOT_IN_INPUT)
if 'size' not in product:
raise ApiException(400, SIZE_NOT_IN_INPUT)
if 'quantity' not in product:
raise ApiException(400, QUANTITY_NOT_IN_INPUT)
if 'price' not in product:
raise ApiException(400, PRICE_NOT_IN_INPUT)
order_info = {
'user_id': user_id,
'product_id': data['productId']
}
connection = connect_db()
order_service = OrderService()
order_service.post_cart(order_info, products, connection)
connection.commit()
return {'custom_message': 'SUCCESS', 'result': 'POST'}
except ApiException as e:
if connection:
connection.rollback()
raise e
finally:
if connection:
connection.close()
def delete_address():
""" [서비스] user가 주문시 기존 배송지 삭제
Author:
Ji Yoon Lee
Args:
- token(str) : 로그인 user의 token이 header에 담겨 들어와 로그인 유효성 검사를 거침
- body(dict) : 삭제할 주소의 'addressId'
Returns:
- 200 :
{ 'message' : 'SUCCESS',
'result' : {
'data' : 삭제된 주소 id (address_id)
}
}
- 400 : 필수 parameter 미입력시 '** 정보를 입력해 주세요'
"""
connection = None
try:
data = request.json
if 'addressId' not in data:
raise ApiException(400, SELECT_ADDRESS_TO_DELETE)
address_info = {
'user_id' : g.token_info['user_id'],
'address_id' : data['addressId']
}
connection = connect_db()
if connection:
order_service = OrderService()
address_id = order_service.delete_address(address_info, connection)
connection.commit()
return address_id
except Exception as e:
connection.rollback()
raise ApiException(400, REQUEST_FAILED)
finally:
if connection:
connection.close()
def get_order_list(*args):
# 주문상태별 주문 리스트 필터하여 보내주는 엔드포인트
order_service = OrderService()
# page parameter에 0이나 음수가 들어올 경우 키에러
if args[12] and args[12] <= 0:
return jsonify({"key error": "Page cannot be negative"}), 400
order_filter = {
'order_status_id': args[0],
'order_number': args[1],
'detailed_order_number': args[2],
'buyer_name': args[3],
'phone_number': args[4],
'seller_name': args[5],
'product_name': args[6],
'start_date': args[7],
'end_date': args[8],
'seller_type_id': args[9],
# 디폴트값: 최신주문일순, 50개씩 보기
'limit': args[10] if args[10] else 50,
'order_by': args[11] if args[11] else 'desc',
'page': args[12] if args[12] else 1
}
# 셀러일 경우 필터에 seller_id 추가
if g.token_info['account_type_id'] == 2:
order_filter['seller_id'] = g.token_info['seller_id']
connection = None
try:
connection = connect_db()
order_list = order_service.get_order_list(connection, order_filter)
return jsonify(order_list), 200
except Exception as e:
return jsonify({"message": f"{e}"}), 400
finally:
try:
if connection:
connection.close()
except Exception as e:
return jsonify({"message": f"{e}"}), 500
def get_filter_options(order_status_id):
# 주문관리 페이지에서 셀러속성 리스트와 주문상태 변경 버튼 보내주는 엔드포인트
order_service = OrderService()
connection = None
try:
connection = connect_db()
filter_options = order_service.get_filter_options(
connection, order_status_id)
return jsonify(filter_options), 200
except Exception as e:
return jsonify({"message": f'{e}'}), 400
finally:
try:
if connection:
connection.close()
except Exception as e:
return jsonify({"message": f'{e}'}), 500
def update_order_detail(*args):
# 주문 상세정보(주문상태, 연락처, 배송지 정보)를 업데이트하고 업데이트된 정보를 리턴
order_service = OrderService()
order_filter = {'order_item_id': args[0]}
update_order = {
'editor_id': g.token_info['account_id'],
'order_item_id': args[0],
'new_order_status_id': args[1],
'phone_number': args[2],
'address_1': args[3],
'address_2': args[4],
'zip_code': args[5],
'delivery_instruction': args[6],
}
# 셀러일 경우 필터에 seller_id 추가
if g.token_info['account_type_id'] == 2:
order_filter['seller_id'] = g.token_info['seller_id']
connection = None
try:
connection = connect_db()
order_service.update_order_detail(connection, update_order)
updated_order_detail = order_service.get_order_detail(
connection, order_filter)
connection.commit()
return jsonify({"updated_order_detail": updated_order_detail}), 201
except Exception as e:
connection.rollback()
return jsonify({"message": f"{e}"}), 400
finally:
try:
if connection:
connection.close()
except Exception as e:
return jsonify({"message": f"{e}"})
def get_cart():
""" [서비스] 유저의 모든 카트들을 가져오기
Author:
Mark Hasung Kim
Returns:
cart_details (유저의 모든 카트 정보)
"""
connection = None
try:
user_id = g.token_info['user_id']
order_info = {'user_id': user_id}
connection = connect_db()
order_service = OrderService()
cart_details = order_service.get_cart(order_info, connection)
return cart_details
except Exception as e:
raise e
finally:
if connection:
connection.close()
def delete_cart():
""" [서비스] 카트 삭제 하기 (is_delete = 1)
Author:
Mark Hasung Kim
Returns:
{
"custom_message": "SUCCESS",
"result": "DELETE"
}
"""
user_id = g.token_info['user_id']
connection = None
try:
data = request.json
if 'productOptionIds' not in data:
raise ApiException(400, PRODUCT_OPTION_NOT_IN_INPUT)
order_info = {
'user_id': user_id,
'product_option_ids': data['productOptionIds']
}
connection = connect_db()
order_service = OrderService()
order_service.delete_cart(order_info, connection)
connection.commit()
return {'custom_message': 'SUCCESS', 'result': 'DELETE'}
except ApiException as e:
if connection:
connection.rollback()
raise e
finally:
if connection:
connection.close()
from flask import Blueprint, request
from wtforms import Form, StringField, validators, IntegerField, FloatField
from service.order_service import OrderService
from utils.resp_utils import ResponseUtil
from utils.common_utils import validate_form
order = Blueprint('order', __name__)
order_service = OrderService()
@order.route('/do', methods=['POST'])
def do_order():
"""
下单接口
@:param username, password
:return:
{"msg": "34e3f953ee814a66a62b2cc2c02b1968", "code": 0, "data": null}
"""
form = DoOrderForm.from_json(formdata=request.json,
meta={'locales': ['zh_CN', 'zh']})
try:
validate_form(form)
order_service.generate_order(form.data)
except Exception as e:
return ResponseUtil.error_response(msg=str(e))
return ResponseUtil.success_response(msg='success')
def post_order_confirmation():
""" [서비스] 결제페이지 (배송정보 입력 후 결제 버튼 누른 다음)
Author:
Ji Yoon Lee
Args:
- token(str): 로그인 user의 token이 header에 담겨 들어와 로그인 유효성 검사를 거침
- body(dict): 'orderId', 'orderName', 'orderPhone', 'orderEmail',
'shippingMemoTypeId', 'shippingInfoId', 'items'(각 아이템의 카트넘버), 'totalPrice'
Returns:
- 200 :
{ 'message': 'SUCCESS',
'result': {
'data': 주문 id (order_id)
}
}
- 400: 필수 parameter 미입력시 '** 정보를 입력해 주세요'
"""
connection = None
try:
data = request.json
if 'orderId' not in data:
raise ApiException(400, ORDER_MISSING)
if 'orderName' not in data:
raise ApiException(400, NAME_MISSING)
if 'orderPhone' not in data:
raise ApiException(400, PHONE_MISSING)
if 'orderEmail' not in data:
raise ApiException(400, EMAIL_MISSING)
if 'shippingMemoTypeId' not in data:
raise ApiException(400, SHIPPING_MEMO_MISSING)
if 'shippingInfoId' not in data:
raise ApiException(400, SHIPPING_INFO_MISSING)
if 'items' not in data:
raise ApiException(400, PRODUCT_MISSING)
if 'totalPrice' not in data:
raise ApiException(400, PRICE_MISSING)
order_info = {
'user_id': g.token_info['user_id'],
'order_id': data['orderId'],
'order_name': data['orderName'],
'order_phone': data['orderPhone'],
'order_email': data['orderEmail'],
'shipping_memo_type_id': data.get('shippingMemoTypeId'),
'shipping_info_id': data['shippingInfoId'],
'items': data['items'],
'total_price': data['totalPrice']
}
connection = connect_db()
if connection:
order_service = OrderService()
order_confirm = order_service.order_confirm(order_info, connection)
connection.commit()
return order_confirm
except Exception as e:
connection.rollback()
raise ApiException(400, REQUEST_FAILED)
finally:
if connection:
connection.close()