def insert_hq():
insert = request.vars.insert
data = {'title' : request.vars.hq_title,
'description' : request.vars.hq_description,
'year' : request.vars.hq_year,
'characters' : json2.loads(request.vars.hq_character)}
if insert == 'true':
if len(db.executesql("SELECT id FROM hq WHERE hq_title='{0}' AND deleted='F'".format(data['title']),as_dict=True)) == 0:
query = """INSERT INTO hq (created, hq_title, hq_description, hq_year, deleted)
VALUES ('{0}', '{1}', '{2}', '{3}', 'F') RETURNING id""".format(request.now, data['title'], data['description'], data['year'])
else:
return XML(json('erro'))
else:
item_edit = request.vars.item_edit
if len(db.executesql("SELECT id FROM hq WHERE hq_title='{0}' AND id != {1} AND deleted='F'".format(data['title'],item_edit),as_dict=True)) == 0:
query = """UPDATE hq SET hq_title='{0}', hq_description='{1}', hq_year='{2}' WHERE id={3} RETURNING id""".format(data['title'],
data['description'],
data['year'],
item_edit)
else:
return XML(json('erro'))
try:
id_hq = db.executesql(query,as_dict=True)
id_hq = id_hq[0]['id']
if insert == 'true':
for c in data['characters']:
db.executesql("""INSERT INTO hq_character (created, marvel_character, hq, deleted)
VALUES ('{0}', {1}, {2}, 'F')""".format(request.now, c, id_hq))
else:
aux = ''
for c in data['characters']:
aux += c + ','
if len(db.executesql("""SELECT id FROM hq_character
WHERE hq={0} AND marvel_character={1} AND deleted='F'""".format(id_hq, c),as_dict=True)) == 0:
db.executesql("""INSERT INTO hq_character (created, marvel_character, hq, deleted)
VALUES ('{0}', {1}, {2}, 'F')""".format(request.now, c, id_hq))
aux = aux[0:-1]
db.executesql("UPDATE hq_character SET deleted='T' WHERE hq={0} AND marvel_character NOT IN ({1})".format(id_hq, aux))
ret = {'hqs' : db.executesql("SELECT id, hq_title, hq_description, hq_year FROM hq WHERE deleted='F'",as_dict=True),
'hqs_characters' : db.executesql("SELECT id, marvel_character, hq FROM hq_character WHERE deleted='F'",as_dict=True)}
db.commit()
except Exception as wE:
db.rollback()
ret = 'erro'
return XML(json(ret))
def autotags():
from serializers import json
key = request.vars.term
limit = int(request.vars.limit or 10)
rows = db(db.tag.name.startswith(key)).select(
db.tag.id,db.tag.name,distinct=True,limitby=(0,limit))
items = [dict(id=r.id,value=r.name,label=r.name) for r in rows]
return json(items)
def autotags():
from serializers import json
key = request.vars.term
limit = int(request.vars.limit or 10)
rows = db(db.tag.name.startswith(key)).select(db.tag.id,
db.tag.name,
distinct=True,
limitby=(0, limit))
items = [dict(id=r.id, value=r.name, label=r.name) for r in rows]
return json(items)
def autogroups():
from serializers import json
key = request.vars.term
limit = int(request.vars.limit or 10)
group = db.auth_group
rows = db(group.role.startswith(key)).select(
group.id,group.role,limitby=(0,limit))
items = [dict(id=r.id,value=r.role,label=r.role) for r in rows]
if 'everybody'.startswith(key):
items.insert(0,dict(id=0, value='everybody',label='everybody'))
return json(items)
def verification_person():
keypoint = request.vars.keypoints
session.current_company_id = 1
query = """
SELECT id,created, last_update, full_name, birth_date,cpf,rg,email,keypoints1,keypoints2,sex,street_number,
comp_person,neigh,street,zipcode,marital_status,deleted,cellphone,city_person
FROM auth_user
WHERE deleted='F'"""
person_data = db.executesql(query,as_dict=True)
if person_data != None or person_data != '':
for i in range(0,len(person_data)):
get_person = authentication(person_data[i]['keypoints1'],person_data[i]['keypoints2'],keypoint)
if get_person == 1:
session.full_name = person_data[0]['full_name']
return XML(json({'info':'OK', 'person':person_data[0]}))
else:
return XML(json({'info':'Ocorreu um erro! Tente Novamente!', 'person':''}))
else:
return XML(json({'info':'Ocorreu um erro! Tente Novamente!', 'person':''}))
def autogroups():
from serializers import json
key = request.vars.term
limit = int(request.vars.limit or 10)
group = db.auth_group
rows = db(group.role.startswith(key)).select(group.id,
group.role,
limitby=(0, limit))
items = [dict(id=r.id, value=r.role, label=r.role) for r in rows]
if 'everybody'.startswith(key):
items.insert(0, dict(id=0, value='everybody', label='everybody'))
return json(items)
def delete_hq():
id_del = request.vars.delete
try:
db.executesql("UPDATE hq SET deleted='T' WHERE id={0}".format(id_del))
ret = {'hqs' : db.executesql("SELECT id, hq_title, hq_description, hq_year FROM hq WHERE deleted='F'",as_dict=True),
'hqs_characters' : db.executesql("SELECT id, marvel_character, hq FROM hq_character WHERE deleted='F'",as_dict=True)}
db.commit()
except Exception as wE:
db.rollback()
ret = 'erro'
return XML(json(ret))
def insert_news():
news = {'title' : request.vars['data[news_title]'],
'link' : request.vars['data[news_url]'],
'text' : request.vars['data[news_text]']}
insert = request.vars.insert
try:
if insert == 'true':
query = """INSERT INTO news (created, news_title, news_url, news_text, deleted)
VALUES (now(), '{0}', '{1}', '{2}', 'F')""".format(news['title'], news['link'], news['text'])
else:
query = """UPDATE news SET news_title='{0}', news_url='{1}', news_text='{2}'
WHERE id={3}""".format(news['title'], news['link'], news['text'], insert)
db.executesql(query)
db.commit()
return ''
except Exception as wE:
db.rollback()
ret = 'erro'
return XML(json(ret))
def json(self, data, default=None):
return json(data, default=default or custom_json)
def json(self, data):
return json(data)
def json(self, data, default=None):
return json(data, default=default or custom_json)
def json(self, data):
return json(data)
def getNews():
news = db.executesql("""SELECT id, news_title, created, news_text, news_url, deleted, news_image2, news_image3, news_image1
FROM news WHERE deleted='F'""",as_dict=True)
return XML(json(news))
