스파르타코딩클럽 4주차
from flask import Flask, render_template, jsonify, request
app = Flask(__name__)
from pymongo import MongoClient
client = MongoClient('localhost', 27017)
db = client.dbhomework
## HTML 화면 보여주기
@app.route('/')
def homework():
return render_template('index.html')
# 주문하기(POST) API
@app.route('/order', methods=['POST'])
def save_order():
name_receive = request.form['name_give']
count_receive = request.form['count_give']
address_receive = request.form['address_give']
pnum_receive = request.form['pnum_give']
doc = {
'name': name_receive,
'count': count_receive,
'address': address_receive,
'pnum': pnum_receive
}
db.mall.insert_one(doc)
return jsonify({'msg': '저장 완료!'})
# 주문 목록보기(Read) API
@app.route('/order', methods=['GET'])
def view_orders():
orders = list(db.mall.find({},{'_id':False}))
return jsonify({'all_orders': orders})
if __name__ == '__main__':
app.run('0.0.0.0', port=5000, debug=True)
<!doctype html>
<html lang="en">
<head>
<!-- IBM Plex Sans KR -->
<link rel="preconnect" href="https://fonts.googleapis.com">
<link rel="preconnect" href="https://fonts.gstatic.com" crossorigin>
<link href="https://fonts.googleapis.com/css2?family=IBM+Plex+Sans+KR:wght@500&display=swap" rel="stylesheet">
<!-- Required meta tags -->
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
<!-- Bootstrap CSS -->
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0/css/bootstrap.min.css"
integrity="sha384-Gn5384xqQ1aoWXA+058RXPxPg6fy4IWvTNh0E263XmFcJlSAwiGgFAW/dAiS6JXm" crossorigin="anonymous">
<!-- Optional JavaScript -->
<!-- jQuery first, then Popper.js, then Bootstrap JS -->
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.12.9/umd/popper.min.js"
integrity="sha384-ApNbgh9B+Y1QKtv3Rn7W3mgPxhU9K/ScQsAP7hUibX39j7fakFPskvXusvfa0b4Q"
crossorigin="anonymous"></script>
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0/js/bootstrap.min.js"
integrity="sha384-JZR6Spejh4U02d8jOt6vLEHfe/JQGiRRSQQxSfFWpi1MquVdAyjUar5+76PVCmYl"
crossorigin="anonymous"></script>
<title>스파르타코딩클럽 | 부트스트랩 연습하기</title>
<style>
* {
font-family: 'IBM Plex Sans KR', sans-serif;
color: dimgrey;
}
.wrap {
width: 500px;
margin: auto;
border: 1px gainsboro solid;
padding: 27px;
}
.img-style {
width: 300px;
height: 320px;
margin: auto;
margin-bottom: 30px;
background-image: url("http://img.danawa.com/prod_img/500000/601/270/img/6270601_1.jpg?shrink=330:330&_v=20200716141933");
background-size: cover;
background-position: center;
}
.large-font {
font-size: 32px;
font-weight: bold;
color: black;
}
.font-color {
color: royalblue;
}
.div-btn {
width: 100px;
margin: auto;
display: block;
padding-bottom: 50px;
}
.align-center {
text-align: center;
}
</style>
<script>
$(document).ready(function () {
Exchange();
showOrder();
});
function Exchange() {
$('#exchange_rate').empty();
$.ajax({
type: "GET",
url: "http://spartacodingclub.shop/sparta_api/rate",
data: {},
success: function (response) {
let rate = response['rate'];
let temp_html = `<p class="font-color">달러 - 원 환율 : ${rate}</p>`;
$('#exchange_rate').append(temp_html);
}
})
}
function addOrder() {
let name = $('#name').val()
let count = $('#inputGroupSelect01').val()
let address = $('#address').val()
let pnum = $('#pnum').val()
$.ajax({
type: "POST",
url: "/order",
data: {name_give:name, count_give:count, address_give:address, pnum_give:pnum},
success: function (response) {
alert(response["msg"]);
window.location.reload();
}
})
}
function showOrder() {
$.ajax({
type: "GET",
url: "/order",
data: {},
success: function (response) {
let orders = response['all_orders']
for (let i = 0; i < orders.length; i++) {
let name = orders[i]['name']
let count = orders[i]['count']
let address = orders[i]['address']
let pnum = orders[i]['pnum']
let temp_html = `<tr>
<th scope="col">${name}</th>
<td scope="col">${count}</td>
<td scope="col">${address}</td>
<td scope="col">${pnum}</td>
</tr>`
$('#order-list').append(temp_html)
}
}
})
}
</script>
</head>
<body>
<div class="wrap">
<div class="img-style"></div>
<p><span class="large-font">마니커 버팔로윙 1kg</span>     가격 : 12000원 / 개</p>
<p>부드러운 닭윙으로 만든 버팔로윙입니다. 전통 훈제방식으로 만들어진 버팔로윙은 쫄깃하고 부드러우며 훈제향이 짙습니다. 간식, 술안주로 좋은 제품입니다.</p>
<div id="exchange_rate"></div>
<p class="large-font">주문하기</p>
<div class="input-group mb-3">
<div class="input-group-prepend">
<span class="input-group-text" id="inputGroup-sizing-default">성함</span>
</div>
<input type="text" class="form-control" id="name" aria-label="Default" aria-describedby="inputGroup-sizing-default">
</div>
<div class="input-group mb-3">
<div class="input-group-prepend">
<label class="input-group-text" for="inputGroupSelect01">수량</label>
</div>
<select class="custom-select" id="inputGroupSelect01">
<option selected>수량을 선택하세요. (최대 7개)</option>
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
<option value="6">6</option>
<option value="7">7</option>
</select>
</div>
<div class="input-group mb-3">
<div class="input-group-prepend">
<span class="input-group-text" id="inputGroup-sizing-default">주소</span>
</div>
<input type="text" class="form-control" id="address" aria-label="Default" aria-describedby="inputGroup-sizing-default">
</div>
<div class="input-group mb-3">
<div class="input-group-prepend">
<span class="input-group-text" id="inputGroup-sizing-default">전화번호</span>
</div>
<input type="text" class="form-control" id="pnum" aria-label="Default" aria-describedby="inputGroup-sizing-default">
</div>
<div class="div-btn">
<button onclick="addOrder()" type="button" class="btn btn-success">주문하기</button>
</div>
<div class="align-center">
<table class="table" id="order-list">
<thead class="thead-light">
<tr>
<th scope="col">이름</th>
<th scope="col">수량</th>
<th scope="col">주소</th>
<th scope="col">전화번호</th>
</tr>
</thead>
<tbody>
<tr>
<th>마니커</th>
<td>3</td>
<td>서울특별시 동작구</td>
<td>010-0000-0000</td>
</tr>
</tbody>
</table>
</div>
</div>
</body>
</html>
결과
주문 리스트 추가