def sync_tables():
desks = mysql.get_all('desks')
logic.desks = set()
logic.tables = {}
for one in desks:
logic.desks.add(one['desk'])
logic.tables[one['desk']] = logic.Table(one['desk'])
def update_desk():
global desks
t = mysql.get_all('desks')
desks = map(lambda x: x['desk'], t)
desks.sort()
for desk in desks:
tables[desk] = Table(desk)
def post(self):
fid = self.get_argument('fid')
#print fid
results = []
if fid == 'all':
faculty = mysql.get_all('faculty')
for one in faculty:
if one['role'].find('cook') >= 0:
results.append({
'fid':
one['fid'],
'name':
one['name'],
'diet':
logic_manager.get_cook_range(one['fid'])
})
else:
name = logic.faculty.get(fid)['name']
results.append({
'fid': fid,
'name': name,
'diet': logic_manager.get_cook_range(fid)
})
response = {'status': 'ok', 'result': results}
self.write(json_encode(response))
def __init__(self):
self.content = set()
self.stamp = time.time()
self.waiters = set()
result = mysql.get_all('mask')
for one in result:
self.content.add(one['did'])
def post(self):
pid = self.get_argument('order')
pid = int(pid)
sql = 'select order_history.uid as uid,diet.name as name,num,order_history.price as price,cook_history.fid as cook,cash_history.fid as cashier,status from cash_history,order_history,cook_history,diet where cash_history.uid=order_history.uid and order_history.uid=cook_history.uid and order_history.did=diet.did and order_history.pid=%s' % pid
result = mysql.query(sql)
print result
result2 = mysql.get_all('faculty')
faculty = {}
for one in result2:
faculty[one['fid']] = one['name']
total = 0
for one in result:
one['price'] = one['num'] * one['price']
one['cook'] = faculty[one['cook']]
one['cashier'] = faculty[one['cashier']]
if one['status'] == 'success':
total += one['price']
result.append({
'name': '',
'num': 'all',
'price': total,
'cook': '',
'cashier': '',
'status': ''
})
response = {'status': 'ok', 'pid': pid, 'items': result}
self.write(json_encode(response))
def post(self):
role = self.get_cookie('role')
if role != 'manager':
return
faculty_list = mysql.get_all('faculty')
faculty_list.sort(key=lambda x: x['fid'])
#print faculty_list
response = {'status': 'ok', 'faculty': faculty_list}
self.write(json_encode(response))
def sync_cookdo():
cook_do = mysql.get_all('cook_do')
logic.cook_do = {}
for one in cook_do:
if one['fid'] not in logic.cook_do:
logic.cook_do[one['fid']] = set()
logic.cook_do.get(one['fid']).add(one['did'])
for k, v in logic.cook_do.items():
if u'all' in v:
v = set([u'all'])
def post(self):
cid = json_decode(self.get_argument('cid'))
con = {'cid': int(cid)}
res = mysql.delete('category', con)
if res:
response = {'status': 'ok'}
data.category = mysql.get_all('category')
else:
response = {'status': 'err'}
self.finish(json_encode(response))
def post(self):
did = int(json_decode(self.get_argument('did')))
res = mysql.get('diet', {'did': did})
if res and res[0]:
picture = res[0]['picture']
full_path = os.path.join(os.path.dirname(__file__),
'static/pictures/' + picture)
os.remove(full_path)
mysql.delete('diet', {'did': did})
data.diet = mysql.get_all('diet')
response = {'status': 'ok'}
self.finish(json_encode(response))
return
response = {'status': 'err'}
self.finish(json_encode(response))
def post(self):
#attention to variable type
did = int(self.get_argument('did'))
name = str(self.get_argument('name'))
price = float(self.get_argument('price'))
base = float(self.get_argument('base'))
cid = int(self.get_argument('cid'))
order = int(self.get_argument('order'))
desc = str(self.get_argument('desc'))
picture = ''
if self.request.files:
metas = self.request.files['picture']
for meta in metas:
file_name = meta['filename']
content = meta['body']
ext = os.path.splitext(file_name)[-1]
picture = str(uuid.uuid4()) + ext
full_path = os.path.join(os.path.dirname(__file__),
'static/pictures/' + picture)
with open(full_path, 'wb') as f:
f.write(content)
# store into database
res = mysql.insert(
'diet', {
'did': did,
'name': name,
'price': price,
'base': base,
'cid': cid,
'ord': order,
'description': desc,
'picture': picture
})
if res:
data.diet = mysql.get_all('diet')
response = {'status': 'ok'}
else:
os.remove(
os.path.join(os.path.dirname(__file__),
'static/pictures/' + picture))
response = {'status': 'error'}
self.finish(json_encode(response))
def post(self):
cid = json_decode(self.get_argument('cid'))
name = json_decode(self.get_argument('name'))
order = json_decode(self.get_argument('order'))
desc = json_decode(self.get_argument('desc'))
row = {
'cid': int(cid),
'name': name,
'ord': int(order),
'description': desc
}
res = mysql.insert('category', row)
if res:
data.category = mysql.get_all('category')
response = {'status': 'ok'}
else:
response = {'status': 'err'}
self.finish(json_encode(response))
def post(self):
desks = mysql.get_all('desks')
desks.sort(key=lambda x: x['desk'])
response = {'status': 'ok', 'desks': desks}
self.write(json_encode(response))
def post(self):
result = mysql.get_all('category')
result.sort(key=lambda one: one['cid'])
response = {'status': 'ok', 'category': result}
self.write(json_encode(response))
def get_all(table):
res = mysql.get_all(table)
return res
def sync_faculty():
faculty = mysql.get_all('faculty')
for one in faculty:
logic.faculty[one['fid']] = one
def get_all(table):
if table in ('diet', 'category', 'faculty'):
res = mysql.get_all(table)
else:
res = myredis.get_all(table)
return res
def sync_category():
category = mysql.get_all('category')
logic.category = {}
for one in category:
logic.category[one['cid']] = one
def sync_diet():
diet = mysql.get_all('diet')
logic.diet = {}
for one in diet:
logic.diet[one['did']] = one
def post(self):
t = mysql.get_all('faculty')
response = {'status': 'ok', 'faculty': t}
self.finish(json_encode(response))
def post(self):
printers = mysql.get_all('printers')
response = {'status': 'ok', 'printers': printers}
self.write(json_encode(response))
{'fid': '0004', 'uid': '2', 'did': 2, 'num': 1, 'stamp': util.strtostamp('2015.1.8')},
{'fid': '0005', 'uid': '3', 'did': 3, 'num': 1, 'stamp': util.strtostamp('2015.2.8')},
{'fid': '0005', 'uid': '4', 'did': 4, 'num': 1, 'stamp': util.strtostamp('2015.3.8')}]
feedback = [{'uid': '2', 'did': 2, 'num': 1, 'fb': -1, 'stamp': util.strtostamp('2015.1.8')},
{'uid': '2', 'did': 2, 'num': 1, 'fb': 1, 'stamp': util.strtostamp('2015.1.8')},
{'uid': '2', 'did': 3, 'num': 1, 'fb': 1, 'stamp': util.strtostamp('2015.1.8')},
{'uid': '2', 'did': 3, 'num': 1, 'fb': 1, 'stamp': util.strtostamp('2015.1.8')}]
comment = [{'session': 'ss', 'comment': 'ssss', 'stamp': util.strtostamp('2015.1.8')}]
#diet_stat = [{'id': 1, 'name': 'ss', 'price': 88, 'num': 1, 'stamp_from': time.time(), 'stamp_to': time.time()}]
#cook_stat = [{'fid': 'ff', 'name': 'dd', 'num': 1, 'val': 88, 'stamp_from': time.time(), 'stamp_to': time.time()}]
mysql.insert('category', categories[0])
mysql.insert_many('category', categories[1:])
print mysql.get_all('category')
mysql.insert('diet', diet[0])
mysql.insert_many('diet', diet[1:])
print mysql.get_all('diet')
mysql.insert('faculty', faculty[0])
mysql.insert_many('faculty', faculty[1:])
print mysql.get_all('faculty')
mysql.insert('order_history', order_history[0])
mysql.insert_many('order_history', order_history[1:])
print mysql.get_all('order_history')
mysql.insert('cook_history', cook_history[0])
#cook_stat = [{'fid': 'ff', 'name': 'dd', 'num': 1, 'val': 88, 'stamp_from': time.time(), 'stamp_to': time.time()}]
'''
mysql.insert('category', categories[0])
mysql.insert_many('category', categories[1:])
print mysql.get_all('category')
mysql.insert('diet', diet[0])
mysql.insert_many('diet', diet[1:])
print mysql.get_all('diet')
mysql.insert('faculty', faculty[0])
mysql.insert_many('faculty', faculty[1:])
print mysql.get_all('faculty')
mysql.insert('order_history', order_history[0])
mysql.insert_many('order_history', order_history[1:])
print mysql.get_all('order_history')
mysql.insert('cook_history', cook_history[0])
mysql.insert_many('cook_history', cook_history[1:])
print mysql.get_all('cook_history')
mysql.insert('feedback', feedback[0])
mysql.insert_many('feedback', feedback[1:])
'''
print mysql.get_all('feedback')
cursor.close()
conn.close()
def prepare():
data.category = mysql.get_all('category')
data.diet = mysql.get_all('diet')
data.update_desk()
def post(self):
diet = mysql.get_all('diet')
diet.sort(key=lambda one: one['did'])
response = {'status': 'ok', 'diet': diet}
self.write(json_encode(response))
def sync_printers():
printers = mysql.get_all('printers')
logic.printers = {}
for one in printers:
logic.printers[one['name']] = one['ip']
