def put(self, user_id, column_name, new_value):
if int(current_user.get_id()) != int(user_id): return
us = UserSettings.query.filter_by(user_id=user_id).first()
if us:
exec("us.%s = '%s' " % (column_name, new_value))
db.session.commit()
return
def put(self, table_id, user):
print(user)
if int(current_user.get_id()) != int(user): return
updateTurn = RequestList.query.filter_by(
table_id=int(table_id)).limit(1)
print(updateTurn)
for row in updateTurn:
row.status = 2
db.session.commit()
return {'api_num': table_id}
def put(self, user_id):
if int(current_user.get_id()) != int(user_id): return
turnQuery = RequestList.query.filter_by(user_id=user_id)
if turnQuery:
for row in turnQuery:
if row.status == 1:
row.status += 1
elif row.status == 0:
row.status += 2
db.session.commit()
def get(self, user_id):
if int(current_user.get_id()) != int(user_id): return
listOfTurn = list()
turnQuery = RequestList.query.filter(RequestList.status.in_(
(0, 1))).filter_by(user_id=user_id).limit(10)
if turnQuery:
for row in turnQuery:
dictOfTurn = dict(table_id=row.table_id,
number=row.number,
status=row.status,
cust_name=row.cust_name,
user_id=row.user_id,
request_type=row.request_type)
listOfTurn.append(dictOfTurn)
listOfSettings = list()
us = UserSettings.query.filter_by(user_id=user_id).first()
if us:
dictOfSettings = {
'column_turn': us.column_turn,
'column_custname': us.column_custname,
'column_type': us.column_type
}
listOfSettings.append(dictOfSettings)
return jsonify({'allTurn': listOfTurn, 'settings': listOfSettings})
def before_request():
g.user = current_user.get_id()