def checkUser(self, user):
#p= Pesquisa()
#p.setSelect("json_reg")
#p.setSelect("id_reg")
query = Search()
query.literal = " str_login = '******' and str_password = '******' ".format(user.str_login, user.str_password )
query.limit = 1
base = json2base(User.__json__())
collection = DocumentREST("http://api.brlight.net/api", base).get_collection(query)
if collection.result_count:
user_login = collection.results[0]
return Srov(True, user_login ,"Usuario logado com sucesso")
else:
return Srov(False, user ,"Usuário ou senha incorretos")
def json_user(request):
try:
# recebe os parametros do datatable
offset = request.GET['iDisplayStart']
limit = request.GET['iDisplayLength']
#order_by = request.GET['iSortCol_0']
sEcho = request.GET['sEcho']
sSearch = request.GET['sSearch']
query = Search()
query.select = ['mimetype', 'filename', 'id_doc']
query.limit = int(limit)
query.offset = int(offset)
if sSearch :
query.literal = "UPPER(texto_doc) like '%{}%' OR UPPER(filename) like like '%{}%'".format(sSearch)
dict_data = FileBR().getListFiles(query)
datatable_return = {}
# json_data = json_data.replace('offset','iDisplayStart')\
# .replace('limit','DisplayLength')\
# .replace('result_count','iTotalDisplayRecords')\
# .replace('results','aaData')
datatable_return['iDisplayStart'] = dict_data['offset']
datatable_return['DisplayLength'] = dict_data['limit']
datatable_return['iTotalDisplayRecords'] = dict_data['result_count']
datatable_return['aaData'] = dict_data['results']
return datatable_return
#return Response(json_data, content_type='application/json')
except Exception as e:
print(str(traceback.format_exc()))
dict_data = {'aaData': [], "sEcho": sEcho,"iTotalRecords": limit ,"iTotalDisplayRecords": 0 }
json_data = json.dumps(dict_data)
return Response(json_data, content_type='application/json')
