def busca_usuarios(self):
form = self.request.form
result = None
if 'SearchSubmit' in form.keys():
form_values, departamento = self.getBusca()
self.form_dados = form_values
check_form = [i for i in form_values if i.values() != [u'']]
if departamento or check_form:
fields = {}
for di in check_form:
for i in di:
fields[i] = '%%%s%%' % (di[i])
if departamento:
fields['unidadeprincipal'] = departamento
result = FuncDetails.get_FuncDetailsByField(fields, if_empty_return_all=False)
return [self._username_to_infouser(r) for r in result if r]
def update(self):
context = self.context
form = self.request.form
self.portal = context.portal_url.getPortalObject()
self.catalog_tool = getToolByName(context, 'portal_catalog')
self.reference_tool = getToolByName(context, 'reference_catalog')
self.all_structures = []
itens_dict = []
key = ''
query = {}
references = {}
unit_locations = []
structures_selected = []
self.result = []
has_searchable_text = False
context_path = form.get('path')
if context_path:
query['path'] = {'query':context_path }
else:
query['path'] = {'query':'/'.join(self.portal.getPhysicalPath()), 'depth': 99}
query['portal_type'] = ['File',]
start = False
end = False
if form.get('portal-type') == 'Pessoas':
filter = {}
for item in form.items():
field, values = item[0], item[1]
field = field.replace('[', '').replace(']', '')
if values:
if isinstance(values, list):
values_filter = []
for value in values:
values_filter.append('%'+value+'%')
else:
values_filter = '%'+values+'%'
if field == 'cargo':
filter['cargos'] = values_filter
elif field == 'activity':
filter['atividades'] = values_filter
elif field == 'main-structure':
filter['unidadeprincipal'] = values_filter
elif field == 'SearchableText':
filter['name'] = values_filter
users = FuncDetails.get_FuncDetailsByField(filter)
for user in users:
if not isinstance(user,unicode) and not isinstance(user,str):
user = user.username
user = unicode(user)
self.result.append(user)
else:
for item in form.items():
field, values = item[0], item[1]
field = field.replace('[', '').replace(']', '')
if values:
if str(values) in key:
continue
key += '%s:' % values
if field == 'document-type':
if 'all' in values:
values = self.getAllKeyword('tipo')
values = values.keys()
query['tipo'] = values
elif field == 'document-status':
if 'all' in values or isinstance(values, list):
continue
query['getStatus'] = eval(values)
elif field == 'date-start':
start = datetime.strptime(values, '%d/%m/%Y')
elif field == 'date-end':
end = datetime.strptime(values, '%d/%m/%Y')
elif field == 'SearchableText':
query['SearchableText'] = '*%s*' % values
elif field == 'document-theme':
query['ThemeNews'] = values
elif field == 'document-format':
query['content_type'] = eval(values)
elif field == 'document-subject':
query['Subject'] = values
elif field == 'unit-type':
if 'all' in values:
values = self.getAllKeyword('tipounidade')
values = values.keys()
query['tipounidade'] = values
elif field == 'structure-owner':
if not isinstance(values, list): values = [values]
if 'all' in values:
if self.all_structures:
objs = self.all_structures
else:
self.all_structures = self.getAllStructures()
objs = self.all_structures
else:
objs = [uuidToObject(uuid) for uuid in values if uuid]
references['structures'] = objs
elif field == 'structure-client':
if not isinstance(values, list): values = [values]
if 'all' in values:
if self.all_structures:
objs = self.all_structures
else:
self.all_structures = self.getAllStructures()
objs = self.all_structures
else:
objs = [uuidToObject(uuid) for uuid in values if uuid]
references['structuresClient'] = objs
elif field == 'unit-location':
if not isinstance(values, list): values = [values]
if 'all' in values:
unit_locations = self.getAllUnits()
else:
unit_locations = [uuidToObject(uuid) for uuid in values if uuid]
elif field == 'structure-selected':
structures_selected.append(uuidToObject(values))
# query['path']['query'] = '/'.join(uuidToObject(values).getPhysicalPath())
elif field == 'portal-type':
try:
if isinstance(values, str):
values = eval(values)
except NameError:
values = [values]
query['portal_type'] = values
key = 'Biblioteca:searchfilter::%s' % key
cached_data = get_redis_cache(key)
if not cached_data:
if start or end:
if not start:
query['effective'] = {'query':end, 'range': 'max'}
elif not end:
query['effective'] = {'query':start, 'range': 'min'}
else:
query['effective'] = {'query':(start, end), 'range': 'min:max'}
if not 'File' in query.get('portal_type'):
query['review_state'] = ['published', 'internally_published', 'external']
files = self.catalog_tool(**query)
files = [i.UID for i in files]
if query.get('tipo') or \
query.get('classificacao') or \
query.get('effective') or \
query.get('SearchableText') or \
query.get('tipounidade'):
self.result = files
aux_list_structures = []
for reference in references.items():
relationship, objs = reference[0], reference[1]
for obj in objs:
refs = self.reference_tool.getBackReferences(obj, relationship)
for ref in refs:
ref_obj = ref.getSourceObject()
if query.get('SearchableText'):
has_searchable_text = True
if ref_obj.UID() in self.result and \
ref_obj.portal_type in query.get('portal_type'):
aux_list_structures.append(ref_obj.UID())
else:
if ref_obj.UID() not in self.result and \
ref_obj.portal_type in query.get('portal_type'):
self.result.append(ref_obj.UID())
if has_searchable_text and references:
self.result = aux_list_structures
return
aux_list_units = []
for location in unit_locations:
refs = self.reference_tool.getBackReferences(location, 'units')
for ref in refs:
ref_obj = ref.getSourceObject()
if query.get('SearchableText'):
if ref_obj.UID() in self.result and \
ref_obj.portal_type in query.get('portal_type'):
aux_list_units.append(ref_obj.UID())
else:
if ref_obj.UID() not in self.result and \
ref_obj.portal_type in query.get('portal_type'):
self.result.append(ref_obj.UID())
if has_searchable_text and unit_locations:
self.result = aux_list_structures
return
#verificar a logica disso
if not self.result and \
not unit_locations and \
not references:
self.result = files
if structures_selected:
result_structures = []
for structure_selected in structures_selected:
for item in self.result:
obj = uuidToObject(item)
if obj:
try:
if structure_selected == obj.getStructures():
result_structures.append(item)
except AttributeError:
continue
self.result = result_structures
set_redis_cache(key,'Biblioteca:searchfilter:keys', self.result, 600) #Tempo em segundos
else:
self.result = cached_data
return
