def userSubmitBooking():
cookieValue = request.cookies.get("sessionId")
# 檢查使用者是否有cookie，正常回復(True, 使用者相關資料, 查詢當下再延長的expendTime)
checkResult = checkUserStatus(cookieValue)
if checkResult == False:
resp = make_response(jsonify(error=True, message="未登入系統，拒絕存取"), 403)
return resp
# searchResult(user_id, name, email)
searchResult = checkResult[1]
expendTime = checkResult[2]
# request.get_json()取得post過來的資料
bookingData = request.get_json()
attractionId = bookingData["attractionId"]
bookingDate = bookingData["date"]
bookingTime = bookingData["time"]
bookingPrice = bookingData["price"]
# 檢查使用者提供資料正確性
checkBookingDataResult = checkBookingData(attractionId, bookingDate,
bookingTime, bookingPrice)
if checkBookingDataResult == False:
resp = make_response(jsonify(error=True, message="建立失敗，輸入資料錯誤"), 400)
return resp
# 將訂單資料送進資料庫
submitResult = submitBookingData(searchResult[0], attractionId,
bookingDate, bookingTime, bookingPrice)
respBody = jsonify(submitResult)
if "error" in submitResult:
resp = make_response(respBody, 500)
return resp
else:
resp = make_response(respBody, 200)
resp.set_cookie(key="sessionId", value=cookieValue, expires=expendTime)
return resp
def dataOrderNumber(orderNumber):
cookieValue = request.cookies.get("sessionId")
# 檢查使用者是否有cookie，正常回復(True, (user_id, name, email), 查詢當下再延長的expendTime)
checkResult = checkUserStatus(cookieValue)
expendTime = checkResult[2]
if checkResult == False:
resp = make_response(jsonify(error=True, message="未登入系統，拒絕存取"), 403)
return resp
# 取得該訂單資料
result = getOrderData(orderNumber)
respBody = jsonify(result)
if "error" in result:
# 回傳伺服器內部錯誤訊息
resp = make_response(respBody)
return resp
resp = make_response(respBody, 200)
resp.set_cookie(key="sessionId", value=cookieValue, expires=expendTime)
return resp
def userGetBooking():
cookieValue = request.cookies.get("sessionId")
# 檢查使用者是否有cookie，正常回復(True, 使用者相關資料, 查詢當下再延長的expendTime)
checkResult = checkUserStatus(cookieValue)
if checkResult == False:
resp = make_response(jsonify(error=True, message="未登入系統，拒絕存取"), 403)
return resp
# searchResult(user_id, name, email)
searchResult = checkResult[1]
expendTime = checkResult[2]
# 由資料庫中取出所需資料
getAttractionDataResult = getAttractionData(searchResult[0])
respBody = jsonify(getAttractionDataResult)
if "error" in getAttractionDataResult:
resp = make_response(respBody, 500)
return resp
else:
resp = make_response(respBody, 200)
resp.set_cookie(key="sessionId", value=cookieValue, expires=expendTime)
return resp
def userGetData():
cookieValue = request.cookies.get("sessionId")
# 正常回復(True, searchResult, expendTime)
checkResult = checkUserStatus(cookieValue)
if checkResult == False:
resp = make_response(jsonify({"data": None}), 200)
return resp
else:
searchResult = checkResult[1]
expendTime = checkResult[2]
resp = make_response(
jsonify({
"data": {
"id": searchResult[0],
"name": searchResult[1],
"email": searchResult[2]
}
}), 200)
resp.set_cookie(key="sessionId",
value=cookieValue,
expires=expendTime,
samesite="Strict")
return resp
def dataForOrder():
cookieValue = request.cookies.get("sessionId")
# 檢查使用者是否有cookie，正常回復(True, (user_id, name, email), 查詢當下再延長的expendTime)
checkResult = checkUserStatus(cookieValue)
if checkResult == False:
resp = make_response(jsonify(error=True, message="未登入系統，拒絕存取"), 403)
return resp
userId = checkResult[1][0]
expendTime = checkResult[2]
# request.get_json()取得post過來的資料
orderData = request.get_json()
primeValue = orderData["prime"]
attractionId = orderData["order"]["trip"]["id"]
orderPrice = orderData["order"]["price"]
orderDate = orderData["order"]["date"]
orderTime = orderData["order"]["time"]
name = orderData["contact"]["name"]
email = orderData["contact"]["email"]
phone = orderData["contact"]["phone"]
# 檢查使用者提供資料正確性
checkDataResult = checkOrderData(primeValue, attractionId, orderPrice, orderDate, orderTime, name, email, phone)
if checkDataResult == False:
resp = make_response(jsonify(error=True, message="建立失敗，輸入資料錯誤"), 400)
return resp
# 建立訂單編號和資料，付款狀態為未付款(payment_status=1)
insertResult = submitorderingData(userId, attractionId, orderDate, orderTime, orderPrice, name, email, phone, payment_status=1)
if "error" in insertResult:
# 回傳伺服器內部錯誤訊息
resp = make_response(jsonify(insertResult))
return resp
# 獲得orderSerialNumber(當下日期+8碼整數)，亦為銀行端訂單編號
bank_transaction_id = insertResult
# POST TapPay API 完成付款動作
# 1.將request部分資料存到payment_query table，並刪除booking table資料
merchantId = os.getenv("merchantId")
tappayNumber = randint(0,999)
detail = "Taipei Trip"
insertResult = submitpaymentData(bank_transaction_id, merchantId, orderPrice, tappayNumber, detail)
if "error" in insertResult:
# 回傳伺服器內部錯誤訊息
resp = make_response(jsonify(insertResult))
return resp
# fetchone得到(queryID, )
queryId = insertResult[0]
# 刪除booking table資料
deleteResult = deletePreData(userId)
if "error" in deleteResult:
# 回傳伺服器內部錯誤訊息
resp = make_response(jsonify(deleteResult))
return resp
# 2.建立requestData
requestData = json.dumps({
"prime":primeValue,
"partner_key":os.getenv("tappay_key"),
"merchant_id":merchantId,
"amount":orderPrice,
#TapPay識別，可重複
"order_number":tappayNumber,
#銀行端訂單編號
"bank_transaction_id":bank_transaction_id,
"details":detail,
"cardholder":{
"phone_number":"+886"+phone[1:],
"name":name,
"email":email
}
})
requestHeader = {
"Content-Type":"application/json",
"x-api-key":os.getenv("tappay_key")
}
apiurl = "https://sandbox.tappaysdk.com/tpc/payment/pay-by-prime"
response = requests.post(url=apiurl, headers=requestHeader, data=requestData)
response = response.json()
# 3.將tap pay API回復部分資料存到payment_response table
insertResult = submitresponseData(response, queryId)
if "error" in insertResult:
# 回傳伺服器內部錯誤訊息
resp = make_response(jsonify(insertResult))
return resp
# 4.tap pay API回復交易結果，更新ordering table該筆訂單為付款狀態(payment_status=0成交 payment_status=*錯誤代碼)
updateResult = updateStatus(response["status"] ,bank_transaction_id)
if "error" in updateResult:
# 回傳伺服器內部錯誤訊息
resp = make_response(jsonify(updateResult))
return resp
# 5.回復API資料給前端
message = response["msg"]
if response["status"] == 0:
message = "付款成功"
responseData={
"data":{
"number":bank_transaction_id,
"payment":{
"status":response["status"],
"message":message
}
}
}
resp = make_response(jsonify(responseData), 200)
resp.set_cookie(key="sessionId", value=cookieValue, expires=expendTime)
return resp