def search(request):
searchable_fields = settings.TICKET_SEARCH_FIELDS
if request.method == 'POST' and 'reportname' in request.POST and request.POST['reportname']:
rep = tickets_reports()
rep.name = request.POST['reportname']
rep.search = json.dumps(request.session['last_search'], cls=DjangoJSONEncoder)
rep.save(user=request.user)
request.session['last_search'] = convert_sarch(clean_search_values(request.session['last_search']))
request.session['last_search_caption'] = request.POST['reportname']
return table(request, search=request.session['last_search'], list_caption=request.session['last_search_caption'])
if request.method == 'POST':
form = SearchForm(request.POST, include_list=searchable_fields, is_stuff=request.user.is_staff, user=request.user, customer=request.organisation.id)
form.is_valid()
request.session['last_search'] = convert_sarch(clean_search_values(form.cleaned_data))
request.session['last_search_caption'] = ''
return table(request, search=request.session['last_search'])
if 'last_search' in request.session and 'new' not in request.GET:
return table(request, search=request.session['last_search'], list_caption=request.session.get('last_search_caption', ''))
return HttpResponseRedirect('/tickets/search/extended/')
def search(request):
searchable_fields = settings.TICKET_SEARCH_FIELDS
if request.method == 'POST' and 'reportname' in request.POST and request.POST['reportname']:
rep = tickets_reports()
rep.name = request.POST['reportname']
rep.search = json.dumps(request.session['last_search'], cls=DjangoJSONEncoder)
rep.save(user=request.user)
request.session['last_search'] = clean_search_values(request.session['last_search'])
request.session['last_search_caption'] = request.POST['reportname']
return table(request, search=request.session['last_search'], list_caption=request.session['last_search_caption'])
if request.method == 'POST':
form = SearchForm(request.POST, include_list=searchable_fields, is_stuff=request.user.is_staff, user=request.user, customer=request.organisation.id)
form.is_valid()
request.session['last_search'] = clean_search_values(form.cleaned_data)
request.session['last_search_caption'] = ''
return table(request, search=request.session['last_search'])
if 'last_search' in request.session and not 'new' in request.GET:
return table(request, search=request.session['last_search'], list_caption=request.session.get('last_search_caption', ''))
form = SearchForm(include_list=searchable_fields, is_stuff=request.user.is_staff, user=request.user, customer=request.organisation.id)
return render_to_response('tickets/search.html', {'layout': 'horizontal', 'form': form}, RequestContext(request))
def search(request):
searchable_fields = settings.TICKET_SEARCH_FIELDS
if request.method == 'POST' and 'reportname' in request.POST and request.POST['reportname']:
rep = tickets_reports()
rep.name = request.POST['reportname']
rep.search = json.dumps(request.session['last_search'], cls=DjangoJSONEncoder)
rep.save(user=request.user)
request.session['last_search'] = convert_sarch(clean_search_values(request.session['last_search']))
request.session['last_search_caption'] = request.POST['reportname']
return table(request, search=request.session['last_search'], list_caption=request.session['last_search_caption'])
if request.method == 'POST':
form = SearchForm(request.POST, include_list=searchable_fields, is_stuff=request.user.is_staff, user=request.user, customer=request.organisation.id)
form.is_valid()
request.session['last_search'] = convert_sarch(clean_search_values(form.cleaned_data))
request.session['last_search_caption'] = ''
return table(request, search=request.session['last_search'])
if 'last_search' in request.session and 'new' not in request.GET:
return table(request, search=request.session['last_search'], list_caption=request.session.get('last_search_caption', ''))
return HttpResponseRedirect('/tickets/search/extended/')
def convertOldStyleSearch(apps, schema_editor):
reports = apps.get_model('yats', 'tickets_reports')
for rep in reports.objects.all():
search = json.loads(rep.search)
rep.search = json.dumps(convert_sarch(clean_search_values(search)),
cls=DjangoJSONEncoder)
rep.save()
def convertOldStyleSearch(apps, schema_editor):
boards = apps.get_model('yats', 'boards')
for board in boards.objects.all():
if board.columns:
columns = json.loads(board.columns)
for column in columns:
search = column['query']
column['query'] = convert_sarch(clean_search_values(search))
board.columns = json.dumps(columns, cls=DjangoJSONEncoder)
board.save()
def convertOldStyleSearch(apps, schema_editor):
boards = apps.get_model('yats', 'boards')
for board in boards.objects.all():
if board.columns:
columns = json.loads(board.columns)
for column in columns:
search = column['query']
column['query'] = convert_sarch(clean_search_values(search))
board.columns = json.dumps(columns, cls=DjangoJSONEncoder)
board.save()
def YATSSearch(request):
def ValuesQuerySetToDict(vqs):
return [item for item in vqs]
tic = get_ticket_model().objects.select_related('type', 'state', 'assigned', 'priority', 'customer').all()
data = json.loads(request.body)
if 'extra_filter' in data:
extra_filter = data['extra_filter']
del data['extra_filter']
else:
extra_filter = None
if 'days' in data:
days = data['days']
del data['days']
else:
days = None
if 'exclude_own' in data:
exclude_own = data['exclude_own']
del data['exclude_own']
else:
exclude_own = False
POST = QueryDict(mutable=True)
POST.update(data)
form = SearchForm(POST, include_list=settings.TICKET_SEARCH_FIELDS, is_stuff=request.user.is_staff, user=request.user, customer=request.organisation.id)
form.is_valid()
for err in form._errors:
field = form.fields[err]
# b = type(field)
if err in ['c_user', 'assigned']:
try:
form.cleaned_data[err] = field.choices.queryset.get(username=data[err]).pk
except:
form.cleaned_data[err] = -1
else:
try:
form.cleaned_data[err] = field.choices.queryset.get(name=data[err]).pk
except:
form.cleaned_data[err] = -1
search_params, base_query = build_ticket_search(request, tic, {}, clean_search_values(form.cleaned_data))
if extra_filter:
if extra_filter == '1': # days since closed
base_query = base_query.filter(close_date__gte=datetime.date.today() - datetime.timedelta(days=days)).exclude(close_date=None)
if extra_filter == '2': # days since created
base_query = base_query.filter(c_date__gte=datetime.date.today() - datetime.timedelta(days=days))
if extra_filter == '3': # days since last changed
base_query = base_query.filter(u_date__gte=datetime.date.today() - datetime.timedelta(days=days))
if extra_filter == '4': # days since last action
base_query = base_query.filter(last_action_date__gte=datetime.date.today() - datetime.timedelta(days=days))
if extra_filter == '5': # days since falling due
base_query = base_query.filter(deadline__lte=timezone.now() - datetime.timedelta(days=days)).filter(deadline__isnull=False)
if exclude_own:
base_query = base_query.exclude(assigned=request.user)
seen = tickets_participants.objects.filter(user=request.user, ticket__in=base_query.values_list('id', flat=True)).values_list('ticket_id', 'seen')
seen_elements = {}
for see in seen:
seen_elements[see[0]] = see[1]
neededColumns = ['id', 'caption', 'c_date', 'type__name', 'state__name', 'assigned__username', 'deadline', 'closed', 'priority__color', 'customer__name', 'customer__hourly_rate', 'billing_estimated_time', 'close_date', 'last_action_date']
"""
availableColumns = []
tickets = get_ticket_model()
t = tickets()
for field in t._meta.fields:
if field.name in neededColumns:
availableColumns.append(field.name)
"""
result = ValuesQuerySetToDict(base_query.values(*neededColumns))
for ele in result:
ele['seen'] = 0
if ele['id'] in seen_elements:
if seen_elements[ele['id']]:
ele['seen'] = 2
else:
ele['seen'] = 1
return result
def convertOldStyleSearch(apps, schema_editor):
reports = apps.get_model('yats', 'tickets_reports')
for rep in reports.objects.all():
search = json.loads(rep.search)
rep.search = json.dumps(convert_sarch(clean_search_values(search)), cls=DjangoJSONEncoder)
rep.save()
