def setCart(): resp = {'code':200, 'msg':'操作成功','data':{}} req = request.values course_id = int(req['id']) if 'id' in req else 0 number = int(req['number']) if 'number' in req else 0 if course_id <1 or number <1 : resp['code'] = -1 resp['msg'] = '课程注册失败' return jsonify(resp) member_info = session.member_info if not member_info: resp['code'] = -1 resp['msg'] ='会员信息加载失败' return jsonify(resp) course_info = Course.query.filter_by( id = course_id).first() if not course_info: resp['code'] = -1 resp['msg'] ='该课程已经下架' return jsonify(resp) if course_info.stock < number: resp['code'] = -1 resp['msg'] = '对不起,名额已经报满~~~' return jsonify(resp) #db member_id = member_info.id cart_info = MemberCart.query.filter_by(course_id=course_id, member_id=member_id).first() if cart_info: model_cart = cart_info model_cart.register_status = 1 else: model_cart = MemberCart() model_cart.member_id = member_id model_cart.created_time = getCurrentDate() model_cart.course_id = course_id model_cart.quantity = number model_cart.updated_time = getCurrentDate() db.session.add(model_cart) #报名后计算course totoal_count model_course = course_info model_course.total_count = MemberCart.query.filter_by(course_id=course_id,register_status=1).count() db.session.add(model_course) db.session.commit() return jsonify(resp)
def setItems(member_id=0, course_id=0, number=0): if member_id < 1 or course_id < 1 or number < 1: return False cart_info = MemberCart.query.filter_by(course_id=course_id, member_id=member_id).first() if cart_info: model_cart = cart_info else: model_cart = MemberCart() model_cart.member_id = member_id model_cart.created_time = getCurrentDate() model_cart.course_id = course_id model_cart.quantity = number model_cart.updated_time = getCurrentDate() db.session.add(model_cart) db.session.commit() return True