def get_order(id):
"""
提交我的订单
"""
user_id = session['user_id']
begin_date = datetime.datetime.strptime(request.form.get('start_date'),
'%Y-%m-%d')
end_date = datetime.datetime.strptime(request.form.get('end_date'),
'%Y-%m-%d')
times = end_date - begin_date
days = times.days + 1
house = House.query.get(id)
price = house.price
amount = days * price
order = Order()
order.user_id = user_id
order.house_id = id
order.begin_date = begin_date
order.end_date = end_date
order.days = days
order.house_price = price
order.amount = amount
order.add_update()
return jsonify(code=status_code.OK)
def create_order():
house_id = request.form.get('house_id')
# 对前端传过来的时间值进行处理成可以做加法运算的
begin_date = datetime.strptime(request.form.get('begin_date'), '%Y-%m-%d')
end_date = datetime.strptime(request.form.get('end_date'), '%Y-%m-%d')
user_id = session['user_id']
# 验证是否有填写时间
if not all([begin_date, end_date]):
return jsonify(status_code.ORDER_BEGIN_END_DATA_NOT_NULL)
# 验证初始时间是否大于结束时间
if not begin_date < end_date:
return jsonify(status_code.ORDER_BEGIN_DATA_GT_END_DATA_ERROE)
# 获取房屋信息
try:
house = House.query.get(house_id)
except:
return jsonify(status_code.DATABASE_ERROR)
# 创建订单对象
order = Order()
order.house_id = house_id
order.end_date = end_date
order.begin_date = begin_date
order.user_id = user_id
order.days = (end_date - begin_date).days + 1
order.house_price = house.price
order.amount = order.days * order.house_price
order.add_update()
return jsonify(status_code.SUCCESS)
def post(self):
user_id = session['u_id']
house_id = request.form.get('house_id')
price = request.form.get('price')
begin_date = datetime.strptime(request.form.get('begin_date'),
'%Y-%m-%d')
end_date = datetime.strptime(request.form.get('end_date'), '%Y-%m-%d')
if not all([house_id, begin_date, end_date]):
return jsonify(status_code.DATA_NOT_FULL)
if begin_date > end_date:
return jsonify(status_code.CREATE_ORDER_END_DATA_ERROR)
order = Order()
order.user_id = user_id
order.house_id = house_id
order.begin_date = begin_date
order.end_date = end_date
order.days = (end_date - begin_date).days + 1
order.house_price = int(price)
order.amount = order.days * order.house_price
try:
order.add_update()
except Exception as e:
return jsonify(status_code.DATABASE_ERROR)
return jsonify(status_code.SUCCESS)
def post_order():
order_dict = request.form
house_id = order_dict.get('house_id')
start_time = datetime.strptime(order_dict.get('start_time'), '%Y-%m-%d')
end_time = datetime.strptime(order_dict.get('end_time'), '%Y-%m-%d')
if not all([house_id, start_time, end_time]):
return jsonify(status_code.PARAMS_ERROR)
if start_time > end_time:
return jsonify(status_code.ORDER_START_TIME_GT_END_TIME)
house = House.query.get(house_id)
order = Order()
order.user_id = session['user_id']
order.house_id = house_id
order.begin_date = start_time
order.end_date = end_time
order.house_price = house.price
order.days = (end_time - start_time).days + 1
order.amount = order.days * order.house_price
try:
order.add_update()
return jsonify(code=status_code.OK)
except Exception as e:
return jsonify(status_code.DATABASE_ERROR)
def create_order():
begin_date = datetime.strptime(request.form.get('begin_date'), '%Y-%m-%d')
end_date = datetime.strptime(request.form.get('end_date'), '%Y-%m-%d')
house_id = request.form.get('house_id')
user_id = session['user_id']
if not all([begin_date, end_date]):
return jsonify(status_code.ORDER_BEGIN_END_DATA_NOT_NULL)
if begin_date > end_date:
return jsonify(status_code.ORDER_BEGIN_DATA_GT_END_DATE_ERROR)
house = House.query.get(house_id)
order = Order()
order.user_id = user_id
order.house_id = house_id
order.begin_date = begin_date
order.end_date = end_date
order.days = (end_date - begin_date).days + 1
order.house_price = house.price
order.amount = order.days * order.house_price
order.add_update()
return jsonify(status_code.SUCCESS)
def get_order():
house_id = request.form.get('house_id')
begin_date = request.form.get('start_date')
end_date = request.form.get('end_date')
if not all([house_id, begin_date, end_date]):
return jsonify(status_code.PARAMS_ERROR)
x = (datetime.strptime(end_date, '%Y-%m-%d') - datetime.strptime(begin_date, '%Y-%m-%d')).days
# 如果开始时间大于结束时间. 进行判断 返回参数错误
if x < 0:
return jsonify(status_code.END_TIME_IS_ERROR)
days = x + 1
house_price = House.query.filter_by(id=house_id).first().price
amout = days * house_price
# 创建订单
order = Order()
order.user_id = session['user_id']
order.house_id = house_id
order.begin_date = begin_date
order.end_date = end_date
order.days = days
order.house_price = house_price
order.amout = amout
try:
order.add_update()
return jsonify(status_code.SUCCESS)
except:
return jsonify(status_code.DATABASE_ERROR)
def order():
# 接收参数
dict = request.form
house_id = int(dict.get('house_id'))
start_date = datetime.strptime(dict.get('start_date'), '%Y-%m-%d')
end_date = datetime.strptime(dict.get('end_date'), '%Y-%m-%d')
# 验证有效性
if not all([house_id, start_date, end_date]):
return jsonify(status_code.PARAMS_ERROR)
if start_date > end_date:
return jsonify(status_code.ORDER_START_END_TIME_ERROR)
# 查询房屋对象
try:
house = House.query.get(house_id)
except:
return jsonify(status_code.DATABASE_ERROR)
# 创建订单对象
order = Order()
order.user_id = session['user_id']
order.house_id = house_id
order.begin_date = start_date
order.end_date = end_date
order.days = (end_date - start_date).days + 1
order.house_price = house.price
order.amount = order.days * order.house_price
try:
order.add_update()
except:
return jsonify(status_code.DATABASE_ERROR)
# 返回信息
return jsonify(code=status_code.OK)
def create_order():
if request.method == "POST":
house_id = request.form.get('house_id')
# 对前端传过来的时间值进行处理成可以做加法运算的
print(request.form.get('begin_date'))
begin_date = datetime.strptime(request.form.get('begin_date'),
'%Y-%m-%d')
end_date = datetime.strptime(request.form.get('end_date'), '%Y-%m-%d')
print(begin_date, end_date)
user_id = session['user_id']
# 验证是否有填写时间
if not all([begin_date, end_date]):
return jsonify(status_code.ORDER_BEGIN_END_DATA_NOT_NULL)
# 验证初始时间是否大于结束时间
if begin_date > end_date:
return jsonify(status_code.ORDER_BEGIN_DATA_GT_END_DATA_ERROE)
# 获取房屋信息
try:
house = House.query.get(house_id)
except:
return jsonify(code=status_code.DATABASE_ERROR)
# 创建订单对象
order = Order()
order.house_id = house_id
order.end_date = end_date
order.begin_date = begin_date
order.user_id = user_id
order.days = (end_date - begin_date).days + 1
order.house_price = house.price
order.amount = order.days * order.house_price
order.add_update()
data = {"order_id": order.id, "order_amount": order.amount}
print(data)
return jsonify(code=status_code.ok, data=data)
else:
id = request.args.get('id')
amount = request.args.get('amount')
print(id, amount)
return render_template('order_success.html',
data={
'id': id,
'amount': amount
})
def post(self):
list_ = []
parse = parser.parse_args()
staff_id = parse.get('staff_id')
number = parse.get('number')
price = parse.get('price')
address = parse.get('address')
phone = parse.get('phone')
consignee = parse.get('consignee')
datetime_now = datetime.datetime.now()
date_stamp = str(int(time.mktime(datetime_now.timetuple())))
data_microsecond = str("%06d" % datetime_now.microsecond)
date_stamp = date_stamp + data_microsecond
order = Order()
order.order_no = date_stamp
order.price = price
order.user_id = staff_id
order.number = number
order.address = address
order.phone = phone
order.consignee = consignee
db.session.add(order)
db.session.commit()
point = Point.query.filter(Point.staff_id == staff_id).first()
orders = Order.query.filter(Order.user_id == staff_id).all()
if orders:
for order in orders:
list_.append(order.price)
prices = sum(list_)
print(prices)
point.sumprice = prices
print(point.sumprice)
db.session.commit()
else:
pass
return jsonify({'msg': '添加成功'})
def bookings_post(id):
start_date = request.form.get('start_date')
end_date = request.form.get('end_date')
live_time = datetime.strptime(end_date, '%Y-%m-%d') - datetime.strptime(
start_date, '%Y-%m-%d')
if live_time.days < 0:
return jsonify(status_code.ORDER_DATE_IS_INVALID)
house = House.query.filter_by(id=id).first()
order = Order()
order.user_id = session['user_id']
order.house_id = id
order.begin_date = start_date
order.end_date = end_date
order.days = live_time.days
order.house_price = house.price
order.amount = live_time.days * house.price
try:
order.add_update()
except Exception as e:
db.session.rollback()
return jsonify(status_code.DATABASE_ERROR)
return jsonify({'code': '200'})
def shopping(request):
if request.GET.get('pid'):
product = Product.objects.get(pid=request.GET.get('pid'))
if request.user.orders and product.order:
if request.GET.get('deletepid'):
order = product.order
product = Product.objects.get(order_id=order.id)
product.order_id = None
product.save()
order.delete()
if request.user.orders.first():
object_list = [
Product.objects.filter(status=1,
is_delete=0,
type=0,
inventory__gt=0),
Product.objects.filter(status=1,
is_delete=0,
type=1,
inventory__gt=0),
Product.objects.filter(status=1,
is_delete=0,
type=2,
inventory__gt=0),
[
i.products.first() for i in Order.objects.filter(
order_status=1, user_id=request.user.uid)
],
[
int(
sum([
i.products.first().price * i.productnum
for i in Order.objects.filter(
order_status=1,
user_id=request.user.uid)
])) - request.user.score / 10,
len([
i.products.first()
for i in Order.objects.filter(
order_status=1, user_id=request.user.uid)
]), request.user.score / 10
]
]
return render(request, 'shopping.html', locals())
else:
return redirect(reverse('app:index'))
order = product.order
order.productnum += int(request.GET.get('num'))
order.save()
print([
i.products.first().price * i.productnum
for i in Order.objects.filter(order_status=1,
user_id=request.user.uid)
])
object_list = [
Product.objects.filter(status=1,
is_delete=0,
type=0,
inventory__gt=0),
Product.objects.filter(status=1,
is_delete=0,
type=1,
inventory__gt=0),
Product.objects.filter(status=1,
is_delete=0,
type=2,
inventory__gt=0),
# Product.objects.filter(order=order.id)[0]
[
i.products.first()
for i in Order.objects.filter(order_status=1,
user_id=request.user.uid)
],
[
int(
sum([
i.products.first().price * i.productnum
for i in Order.objects.filter(
order_status=1, user_id=request.user.uid)
])) - request.user.score / 10,
len([
i.products.first()
for i in Order.objects.filter(order_status=1,
user_id=request.user.uid)
]), request.user.score / 10
]
]
return render(request, 'shopping.html', locals())
order = Order()
order.user_id = request.user
order.create_time = datetime.now()
order.order_status = 1
order.productnum = request.GET.get('num')
order.total = int(product.price) * int(request.GET.get('num'))
order.save()
product.order = order
product.save()
object_list = [
Product.objects.filter(status=1,
is_delete=0,
type=0,
inventory__gt=0),
Product.objects.filter(status=1,
is_delete=0,
type=1,
inventory__gt=0),
Product.objects.filter(status=1,
is_delete=0,
type=2,
inventory__gt=0),
# Product.objects.filter(order=order.id)[0]
[
i.products.first()
for i in Order.objects.filter(order_status=1,
user_id=request.user.uid)
],
[
int(
sum([
i.products.first().price * i.productnum
for i in Order.objects.filter(order_status=1,
user_id=request.user.uid)
])) - request.user.score / 10,
len([
i.products.first()
for i in Order.objects.filter(order_status=1,
user_id=request.user.uid)
]), request.user.score / 10
]
]
return render(request, 'shopping.html', locals())
else:
print(1111111111111111111)
object_list = [
Product.objects.filter(status=1,
is_delete=0,
type=0,
inventory__gt=0),
Product.objects.filter(status=1,
is_delete=0,
type=1,
inventory__gt=0),
Product.objects.filter(status=1,
is_delete=0,
type=2,
inventory__gt=0),
# Product.objects.filter(order=order.id)[0]
[
i.products.first()
for i in Order.objects.filter(order_status=1,
user_id=request.user.uid)
],
[
int(
sum([
i.products.first().price * i.productnum
for i in Order.objects.filter(order_status=1,
user_id=request.user.uid)
])) - request.user.score / 10,
len([
i.products.first()
for i in Order.objects.filter(order_status=1,
user_id=request.user.uid)
]), request.user.score / 10
]
]
return render(request, 'shopping.html', locals())