def run(args, dbparams):
import MySQLdb
db=MySQLdb.connect(host=dbparams["host"], db=dbparams["db"], user=dbparams["user"], passwd=dbparams["passwd"])
db.autocommit(False)
c=db.cursor()
from au_user import getUserId
user = getUserId(c, args['user'], args['password'])
if user == -1:
data = {'pass': '******'}
c.close()
return data
c.execute("SELECT id FROM unitname WHERE name=%s", (args['unit'],))
res = c.fetchone()
unid = res[0]
c.execute("SELECT id FROM unit WHERE unid=%s AND prid=%s", (unid, int(args['prid'])))
res = c.fetchone()
uid = res[0]
c.execute("DELETE FROM menu WHERE uid=%s AND "
"user=%s AND time=%s",
(uid, user, int(args['time'])))
db.commit()
data = {'pass': '******'}
c.close()
return data
def run(args, dbparams):
import MySQLdb
db=MySQLdb.connect(host=dbparams["host"], db=dbparams["db"], user=dbparams["user"], passwd=dbparams["passwd"])
db.autocommit(False)
c=db.cursor()
data = {}
from au_user import getUserId
user_id = getUserId(c, args['user'], args['password'])
if user_id == -1:
data['pass'] = '******'
c.close()
return data
c.execute('SELECT id, pid FROM users WHERE name=%s',
(args['child'].lower(),))
res = c.fetchone()
if res != None and len(res) > 0 and res[1] == user_id:
c.execute('UPDATE users SET pid=0 WHERE id=%s',
(res[0]))
db.commit()
data['pass'] = '******'
else:
data['pass'] = '******'
c.close()
return data
def run(args, dbparams):
from au_user import getUserId, haveProductRight
import MySQLdb
db=MySQLdb.connect(host=dbparams["host"], db=dbparams["db"], user=dbparams["user"], passwd=dbparams["passwd"])
db.autocommit(False)
c=db.cursor()
user = getUserId(c, args['user'], args['password'])
if user == -1:
data['pass'] == 'false'
c.close()
return data
if args['unit'] != 'gramai' and haveProductRight(c, user, int(args['id'])):
c.execute("SELECT id FROM unitname WHERE name=%s", (args['unit'],))
unid = c.fetchone()[0]
c.execute("SELECT id FROM unit WHERE prid=%s AND unid=%s", (int(args['id']), unid))
uid = c.fetchone()[0]
c.execute("SELECT count(*) FROM complex WHERE uid=%s", (uid,))
count = c.fetchone()[0]
if count == 0:
c.execute("DELETE FROM unit WHERE id=%s", (uid,))
data = {'pass': '******'}
db.commit()
else:
data = {'pass': '******'}
else:
data = {'pass': '******'}
c.close()
return data
def run(args, dbparams):
import MySQLdb
db = MySQLdb.connect(host=dbparams["host"], db=dbparams["db"], user=dbparams["user"], passwd=dbparams["passwd"])
db.autocommit(False)
c = db.cursor()
data = {}
from au_user import getUserId
user_id = getUserId(c, args["user"], args["password"])
if user_id == -1:
data["pass"] = "******"
c.close()
return data
c.execute("SELECT id, pid FROM users WHERE name=%s", (args["child"].lower(),))
res = c.fetchone()
if res != None and len(res) > 0 and res[1] == user_id:
admin = 0
if args["admin"] == "true":
admin = 1
business = 0
if args["business"] == "true":
business = 1
c.execute("UPDATE users SET admin=%s, business=%s WHERE id=%s", (admin, business, res[0]))
db.commit()
data["pass"] = "******"
else:
data["pass"] = "******"
c.close()
return data
def run(args, dbparams):
parent = int(args['parent'])
import MySQLdb
db=MySQLdb.connect(host=dbparams["host"], db=dbparams["db"], user=dbparams["user"], passwd=dbparams["passwd"])
db.autocommit(False)
c=db.cursor()
from au_user import getUserId, haveRight
data = {}
id = getUserId(c, args['user'], args['password'])
if id == -1:
data['id'] == '0'
c.close()
return data
data['id'] = '0'
if haveRight(c, id, parent):
c.execute("INSERT INTO product(pid, aid, oid, mod_servant, mod_others) VALUES(%s, %s, %s, 1, 1)",
(parent, id, id))
data['id'] = str(db.insert_id())
c.execute("INSERT INTO unit(prid, unid, weight) VALUES(%s, 1, 1)",
(db.insert_id(),))
db.commit()
c.close()
return data
def run(args, dbparams):
import MySQLdb
db=MySQLdb.connect(host=dbparams["host"], db=dbparams["db"], user=dbparams["user"], passwd=dbparams["passwd"])
c=db.cursor()
data = {}
from au_user import getUserId
user_id = getUserId(c, args['user'], args['password'])
if user_id == -1:
data['pass'] = '******'
c.close()
return data
c.execute('SELECT name, admin, business FROM users WHERE pid=%s',
(user_id,))
res = c.fetchall()
from au_user import booltostr
data['users'] = []
for item in res:
user = {'name': item[0],
'admin': booltostr(item[1]),
'business': booltostr(item[2])}
data['users'].append(user)
data['pass'] = '******'
c.close()
return data
def run(args, dbparams):
parent = int(args['parent'])
import MySQLdb
db=MySQLdb.connect(host=dbparams["host"], db=dbparams["db"], user=dbparams["user"], passwd=dbparams["passwd"])
c=db.cursor()
from au_user import getUserId, haveRight, haveProductRight
user = -1
if args['user'] != '':
user = getUserId(c, args['user'], args['password'])
if user == -1:
data = {'pass': '******'}
c.close()
return data
c.execute("SELECT id, name FROM category WHERE pid=%s AND "
"id != 1 ORDER BY name", (parent,))
res = c.fetchall()
data = {}
data['list'] = []
for item in res:
name = str(item[1])
if len(name) == 0:
name = str(item[0])
element = {'id': str(item[0]), 'name': name, 'container': 'true'}
if user != -1 and haveRight(c, user, element['id']):
element['modify'] = 'true'
else:
element['modify'] = 'false'
data['list'].append(element)
c.execute("SELECT id, name, rieb, angl, balt FROM product WHERE PID=%s ORDER BY name", (parent,))
res = c.fetchall()
for item in res:
name = str(item[1])
if len(name) == 0:
name = str(item[0])
element = {'id': str(item[0]),
'name': name,
'rieb': str(item[2]),
'angl': str(item[3]),
'balt': str(item[4])}
if user != -1 and haveProductRight(c, user, element['id']):
element['modify'] = 'true'
else:
element['modify'] = 'false'
data['list'].append(element)
data['pass'] = '******'
c.close()
return data
def run(args, dbparams):
try:
amount = float(args["amount"])
except ValueError:
amount = 0.0
from au_user import getUserId, haveProductRight
import MySQLdb
db = MySQLdb.connect(host=dbparams["host"], db=dbparams["db"], user=dbparams["user"], passwd=dbparams["passwd"])
db.autocommit(False)
c = db.cursor()
user = getUserId(c, args["user"], args["password"])
if user == -1:
data = {"pass": "******"}
c.close()
return data
if haveProductRight(c, user, int(args["id"])):
c.execute("SELECT id FROM unitname WHERE name=%s", (args["unit"],))
res = c.fetchone()
unid = res[0]
c.execute("SELECT id FROM unit WHERE unid=%s AND prid=%s", (unid, int(args["prid"])))
res = c.fetchone()
uid = res[0]
c.execute("SELECT id FROM unitname WHERE name=%s", (args["oldunit"],))
res = c.fetchone()
unid = res[0]
c.execute("SELECT id FROM unit WHERE unid=%s AND prid=%s", (unid, int(args["prid"])))
res = c.fetchone()
old_uid = res[0]
c.execute(
"UPDATE complex SET uid=%s, amount=%s WHERE prid=%s AND uid=%s", (uid, amount, int(args["id"]), old_uid)
)
data = {"pass": "******"}
from au_calcBAR import calcBAR, updateComplex
elem = calcBAR(c, int(args["id"]))
updateComplex(c, int(args["id"]))
db.commit()
data["balt"] = elem[0]
data["angl"] = elem[1]
data["rieb"] = elem[2]
data["total"] = elem[3]
else:
data = {"pass": "******"}
c.close()
return data
def run(args, dbparams):
import MySQLdb
db=MySQLdb.connect(host=dbparams["host"], db=dbparams["db"], user=dbparams["user"], passwd=dbparams["passwd"])
db.autocommit(False)
c=db.cursor()
from au_user import getUserId, haveRight, haveProductRight, getCategoryParent, getProductParent
parent = 0
if args['container'] == 'true':
container = True
parent = getCategoryParent(c, int(args['id']))
else:
container = False
parent = getProductParent(c, int(args['id']))
if parent == 0:
data = {'pass': '******'}
c.close()
return data
id = getUserId(c, args['user'], args['password'])
if id == -1:
data = {'pass': '******'}
c.close()
return data
if args['container'] == 'true':
candelete = haveRight(c, id, int(args['id']))
else:
candelete = haveProductRight(c, id, int(args['id']))
if haveRight(c, id, parent) and candelete:
delete_list = []
if delete(c, int(args['id']), container, delete_list):
for item in delete_list:
if item['cat']:
c.execute("DELETE FROM category WHERE id=%s", (item['id'],))
else:
c.execute("DELETE FROM product WHERE id=%s", (item['id'],))
c.execute('DELETE FROM unit WHERE prid=%s', (item['id'],))
data = {'pass': '******'}
db.commit()
else:
data = {'pass': '******'}
c.close()
return data
def run(args, dbparams):
try:
weight = float(args['weight'])
except ValueError:
weight = 0.0
from au_user import getUserId, haveProductRight
import MySQLdb
db=MySQLdb.connect(host=dbparams["host"], db=dbparams["db"], user=dbparams["user"], passwd=dbparams["passwd"])
db.autocommit(False)
c=db.cursor()
data = {}
user = getUserId(c, args['user'], args['password'])
if user == -1 or len(args['unit']) == 0:
data['pass'] == 'false'
c.close()
return data
if args['unit'] != 'gramai' and haveProductRight(c, user, int(args['id'])):
c.execute("SELECT id FROM unitname WHERE name=%s", (args['unit'],))
res = c.fetchall()
unid = 0
if (len(res) == 0):
c.execute("INSERT INTO unitname(name) VALUES (%s)", (args['unit'],))
unid = db.insert_id()
else:
unid = res[0][0]
c.execute("SELECT id FROM unit WHERE prid=%s AND unid=%s",
(int(args['id']), unid))
uid = c.fetchone()
data = {'pass': '******'}
if uid != None and len(uid) > 0:
c.execute("UPDATE unit SET weight=%s WHERE id=%s",
(weight, uid[0]))
data['type'] = 'updated'
else:
c.execute("INSERT INTO unit(prid, unid, weight) VALUES (%s, %s, %s)",
(int(args['id']), unid, weight))
data['type'] = 'added'
db.commit()
else:
data = {'pass': '******'}
c.close()
return data
def run(args, dbparams):
from au_user import getUserId, haveProductRight
import MySQLdb
db=MySQLdb.connect(host=dbparams["host"], db=dbparams["db"], user=dbparams["user"], passwd=dbparams["passwd"])
db.autocommit(False)
c=db.cursor()
user = getUserId(c, args['user'], args['password'])
data = {}
if user == -1:
data['pass'] = '******'
c.close()
return data
if haveProductRight(c, user, int(args['id'])) and noCircularDep(c, int(args['id']), int(args['prid'])):
c.execute("SELECT count(*) FROM unit u, complex c "
"WHERE c.prid = %s AND c.uid = u.id AND u.prid = %s",
(int(args['id']), int(args['prid'])))
count = c.fetchone()[0];
if count == 0:
data['pass'] = '******'
data['list'] = []
c.execute("SELECT un.name, u.id FROM unit u, unitname un WHERE u.prid = %s AND u.unid = un.id",
(int(args['prid']),))
units = c.fetchall()
for u in units:
data['list'].append({'name': u[0]})
c.execute("INSERT INTO complex(prid, uid, amount) VALUES (%s, %s, %s)",
(int(args['id']), units[0][1], '0.0'))
from au_calcBAR import calcBAR, updateComplex
elem = calcBAR(c, int(args['id']))
updateComplex(c, int(args['id']))
db.commit()
data['balt'] = elem[0]
data['angl'] = elem[1]
data['rieb'] = elem[2]
data['total'] = elem[3]
else:
data['pass'] = '******'
else:
data['pass'] = '******'
c.close()
return data
def run(args, dbparams):
try:
amount = float(args['amount'])
except ValueError:
amount = 0.0
import MySQLdb
db=MySQLdb.connect(host=dbparams["host"], db=dbparams["db"], user=dbparams["user"], passwd=dbparams["passwd"])
db.autocommit(False)
c=db.cursor()
from au_user import getUserId
user = getUserId(c, args['user'], args['password'])
if user == -1:
data = {'pass': '******'}
c.close()
return data
c.execute("SELECT id FROM unitname WHERE name=%s", (args['unit'],))
res = c.fetchone()
unid = res[0]
c.execute("SELECT id FROM unit WHERE unid=%s AND prid=%s", (unid, int(args['prid'])))
res = c.fetchone()
uid = res[0]
c.execute("SELECT id FROM unitname WHERE name=%s", (args['oldunit'],))
res = c.fetchone()
unid = res[0]
c.execute("SELECT id FROM unit WHERE unid=%s AND prid=%s", (unid, int(args['prid'])))
res = c.fetchone()
old_uid = res[0]
c.execute("UPDATE menu SET uid=%s, amount=%s "
"WHERE uid=%s AND user=%s AND time=%s",
(uid, amount, old_uid,
user, int(args['time'])))
db.commit()
data = {'pass': '******'}
c.close()
return data
def run(args, dbparams):
import MySQLdb
db=MySQLdb.connect(host=dbparams["host"], db=dbparams["db"], user=dbparams["user"], passwd=dbparams["passwd"])
db.autocommit(False)
c=db.cursor()
data = {}
from au_user import getUserId
user = getUserId(c, args['user'], args['password'])
if user == -1:
data['pass'] = '******'
c.close()
return data
c.execute("SELECT count(*) FROM unit u, menu m "
"WHERE m.uid = u.id AND u.prid = %s AND "
"m.user=%s AND m.time=%s",
(int(args['prid']), user, int(args['time'])))
count = c.fetchone()[0];
if count == 0:
data['pass'] = '******'
data['list'] = []
c.execute("SELECT un.name, u.id FROM unit u, unitname un WHERE u.prid = %s AND u.unid = un.id",
(int(args['prid']),))
units = c.fetchall()
for u in units:
data['list'].append({'name': u[0]})
c.execute("INSERT INTO menu(user, time, uid, amount) VALUES (%s, %s, %s, %s)",
(user, int(args['time']), units[0][1], 0.0))
db.commit()
else:
data['pass'] = '******'
c.close()
return data
def run(args, dbparams):
from au_user import getUserId, haveProductRight
import MySQLdb
db=MySQLdb.connect(host=dbparams["host"], db=dbparams["db"], user=dbparams["user"], passwd=dbparams["passwd"])
db.autocommit(False)
c=db.cursor()
user = getUserId(c, args['user'], args['password'])
if user == -1:
data = {'pass': '******'}
c.close()
return data
if haveProductRight(c, user, int(args['id'])):
c.execute("SELECT id FROM unitname WHERE name=%s", (args['unit'],))
res = c.fetchone()
unid = res[0]
c.execute("SELECT id FROM unit WHERE unid=%s AND prid=%s", (unid, int(args['prid'])))
res = c.fetchone()
uid = res[0]
c.execute("DELETE FROM complex WHERE prid=%s AND uid=%s", (int(args['id']), uid))
data = {'pass': '******'}
from au_calcBAR import calcBAR, updateComplex
elem = calcBAR(c, int(args['id']))
updateComplex(c, int(args['id']))
db.commit()
data['balt'] = elem[0]
data['angl'] = elem[1]
data['rieb'] = elem[2]
data['total'] = elem[3]
else:
data = {'pass': '******'}
c.close()
return data
def run(args, dbparams):
import MySQLdb
from au_user import getUserId, haveRight, isCategoryOwner
db=MySQLdb.connect(host=dbparams["host"], db=dbparams["db"], user=dbparams["user"], passwd=dbparams["passwd"])
db.autocommit(False)
c=db.cursor()
user = getUserId(c, args['user'], args['password'])
if user == -1:
data = {'pass': '******'}
c.close()
return data
if haveRight(c, user, int(args['id'])):
c.execute("UPDATE category SET name=%s WHERE id=%s",
(args['name'], int(args['id'])))
else:
data = {'pass': '******'}
c.close()
return data
if isCategoryOwner(c, user, int(args['id'])):
mod_servant = 0
if args['mod_servant'] == 'true':
mod_servant = 1
mod_others = 0
if args['mod_others'] == 'true':
mod_others = 1
c.execute("UPDATE category SET mod_servant=%s, mod_others=%s WHERE id=%s",
(mod_servant, mod_others, int(args['id'])))
db.commit()
data = {'pass': '******'}
c.close()
return data
def run(args, dbparams):
import MySQLdb
db = MySQLdb.connect(host=dbparams["host"], db=dbparams["db"], user=dbparams["user"], passwd=dbparams["passwd"])
c = db.cursor()
data = {}
from au_user import getUserId
user = getUserId(c, args["user"], args["password"])
if user == -1:
data["pass"] = "******"
c.close()
return data
c.execute(
"SELECT p.id, p.name, un.name, m.amount "
"FROM product p, menu m, unit u, unitname un "
"WHERE m.uid = u.id AND u.unid = un.id AND u.prid = p.id AND "
"m.user=%s AND m.time=%s",
(user, int(args["time"])),
)
res = c.fetchall()
data["list"] = []
for item in res:
unit = {"id": str(item[0]), "product": item[1], "unit": item[2], "amount": str(item[3]), "units": []}
c.execute("SELECT un.name FROM unit u, unitname un WHERE u.prid = %s AND u.unid = un.id", (item[0],))
units = c.fetchall()
for u in units:
unit["units"].append({"name": u[0]})
data["list"].append(unit)
data["pass"] = "******"
c.close()
return data
def run(args, dbparams):
import MySQLdb
from au_user import getUserId, isUserParent
db = MySQLdb.connect(host=dbparams["host"], db=dbparams["db"], user=dbparams["user"], passwd=dbparams["passwd"])
db.autocommit(False)
c = db.cursor()
user = getUserId(c, args["user"], args["password"])
if user == -1:
data = {"pass": "******"}
c.close()
return data
if args["category"] == "true":
c.execute("SELECT oid FROM category WHERE id=%s", (int(args["id"]),))
oid = c.fetchone()[0]
if isUserParent(c, oid, user):
c.execute("UPDATE category SET oid=%s WHERE id=%s", (user, int(args["id"])))
data = {"pass": "******"}
else:
data = {"pass": "******"}
else:
c.execute("SELECT oid FROM product WHERE id=%s", (int(args["id"]),))
oid = c.fetchone()[0]
if isUserParent(c, oid, user):
c.execute("UPDATE product SET oid=%s WHERE id=%s", (user, int(args["id"])))
data = {"pass": "******"}
else:
data = {"pass": "******"}
db.commit()
c.close()
return data
def run(args, dbparams):
try:
balt = float(args['balt'])
except ValueError:
balt = 0.0
try:
rieb = float(args['rieb'])
except ValueError:
rieb = 0.0
try:
angl = float(args['angl'])
except ValueError:
angl = 0.0
import MySQLdb
from au_user import getUserId, haveProductRight, isProductOwner
db=MySQLdb.connect(host=dbparams["host"], db=dbparams["db"], user=dbparams["user"], passwd=dbparams["passwd"])
db.autocommit(False)
c=db.cursor()
user = getUserId(c, args['user'], args['password'])
if user == -1:
data = {'pass': '******'}
c.close()
return data
if haveProductRight(c, user, int(args['id'])):
complex = 0
if args['complex'] == 'true':
complex = 1
secret = 0
if args['secret'] == 'true':
secret = 1
c.execute("UPDATE product SET name=%s, balt=%s, rieb=%s, angl=%s, complex=%s, descr=%s, "
"secret=%s, linkdescr=%s, link=%s "
"WHERE id=%s",
(args['name'], balt, rieb, angl,
complex, args['descr'],
secret, args['linkdescr'], args['link'],
int(args['id'])))
from au_calcBAR import updateComplex
updateComplex(c, int(args['id']))
else:
data = {'pass': '******'}
c.close()
return data
if isProductOwner(c, user, int(args['id'])):
mod_servant = 0
if args['mod_servant'] == 'true':
mod_servant = 1
mod_others = 0
if args['mod_others'] == 'true':
mod_others = 1
c.execute("UPDATE product SET mod_servant=%s, mod_others=%s WHERE id=%s",
(mod_servant, mod_others, int(args['id'])))
db.commit()
data = {'pass': '******'}
c.close()
return data
def run(args, dbparams):
id = int(args['id'])
import MySQLdb
from au_user import getUserId, haveRight, haveProductRight, isUserParent, booltostr, \
getCategoryParent, getProductParent, isCategoryOwner, isProductOwner
db=MySQLdb.connect(host=dbparams["host"], db=dbparams["db"], user=dbparams["user"], passwd=dbparams["passwd"])
c=db.cursor()
user = getUserId(c, args['name'], args['password'])
if args['container'] == 'true':
c.execute("SELECT name, oid, mod_servant, mod_others FROM category WHERE id=%s", (id,))
res = c.fetchone()
data = {'name': res[0],
'mod_servant': booltostr(res[2]),
'mod_others': booltostr(res[3])}
data['owner'] = 'false'
data['parmod'] = 'false'
data['modify'] = 'false'
data['cantake'] = 'false'
if user != -1:
if isCategoryOwner(c, user, id):
data['owner'] = 'true'
if haveRight(c, user, id):
data['modify'] = 'true'
parent = getCategoryParent(c, id)
if parent != 0 and haveRight(c, user, parent) and data['modify'] == 'true':
data['parmod'] = 'true'
if isUserParent(c, res[1], user):
data['cantake'] = 'true'
else:
data['modify'] = 'false'
data['parmod'] = 'false'
else:
c.execute("SELECT name, complex, secret, balt, rieb, angl, descr, linkdescr, "
"link, mod_servant, mod_others, oid "
"FROM product WHERE id=%s", (id,))
res = c.fetchone()
oid = res[11]
data = {'name': res[0],
'complex': booltostr(res[1]),
'secret': booltostr(res[2]),
'balt': str(res[3]),
'rieb': str(res[4]),
'angl': str(res[5]),
'descr': res[6],
'linkdescr': res[7],
'link': res[8],
'mod_servant': booltostr(res[9]),
'mod_others': booltostr(res[10]),
'unit_list': []}
c.execute("SELECT un.name, u.weight FROM unit u, unitname un WHERE u.prid = %s AND u.unid = un.id",
(id,))
res = c.fetchall()
for item in res:
unit = {'unit': item[0], 'weight': str(item[1])}
data['unit_list'].append(unit)
data['modify'] = 'false'
data['owner'] = 'false'
data['parmod'] = 'false'
data['cantake'] = 'false'
if user != -1:
if haveProductRight(c, user, id):
data['modify'] = 'true'
if isProductOwner(c, user, id):
data['owner'] = 'true'
parent = getProductParent(c, id)
if parent != 0 and haveRight(c, user, parent) and data['modify'] == 'true':
data['parmod'] = 'true'
if isUserParent(c, oid, user):
data['cantake'] = 'true'
else:
data['modify'] = 'false'
data['parmod'] = 'false'
c.close()
return data
