def handle(self, *args, **options):
dest = settings.FILE_UPLOAD_PATH
if not os.path.exists(dest):
os.makedirs(dest)
files = tickets_files.objects.exclude(content_type__icontains='image')
for non in non_previewable_contenttypes:
files = files.exclude(content_type__icontains=non)
for file in files:
src = '%s%s.dat' % (settings.FILE_UPLOAD_PATH, file.id)
if os.path.isfile(src):
if not os.path.isfile('%s%s.preview' % (dest, file.id)):
self.stdout.write(file.content_type)
self.stdout.write(src)
if 'pdf' in file.content_type:
convertPDFtoImg('%s%s.dat' % (dest, file.id),
'%s%s.preview' % (dest, file.id))
else:
if 'image' not in file.content_type:
tmp = convertOfficeTpPDF('%s%s.dat' %
(dest, file.id))
convertPDFtoImg(tmp,
'%s%s.preview' % (dest, file.id))
if os.path.isfile(tmp):
os.unlink(tmp)
self.stdout.write('done')
def handle(self, *args, **options):
dest = settings.FILE_UPLOAD_PATH
if not os.path.exists(dest):
os.makedirs(dest)
files = tickets_files.objects.exclude(content_type__icontains='image')
for non in non_previewable_contenttypes:
files = files.exclude(content_type__icontains=non)
for file in files:
src = '%s%s.dat' % (settings.FILE_UPLOAD_PATH, file.id)
if os.path.isfile(src):
if not os.path.isfile('%s%s.preview' % (dest, file.id)):
self.stdout.write(file.content_type)
self.stdout.write(src)
if 'pdf' in file.content_type:
convertPDFtoImg('%s%s.dat' % (dest, file.id), '%s%s.preview' % (dest, file.id))
else:
if 'image' not in file.content_type:
tmp = convertOfficeTpPDF('%s%s.dat' % (dest, file.id))
convertPDFtoImg(tmp, '%s%s.preview' % (dest, file.id))
if os.path.isfile(tmp):
os.unlink(tmp)
self.stdout.write('done')
def handle(self, *args, **options):
if options['username']:
username = options['username']
else:
raise CommandError('missing username')
if options['server']:
server = options['server']
else:
raise CommandError('missing server')
if options['yatsuser']:
yatsuser = options['yatsuser']
else:
raise CommandError('missing yatsuser')
password = self._get_pass()
user = get_user_model().objects.get(username=yatsuser)
url = furl(server)
url.password = password
url.username = username
rpc_srv = xmlrpclib.ServerProxy(url.tostr(), allow_none=True, use_datetime=True)
documents = rpc_srv.wiki.getAllPages()
for doc in documents:
if doc.startswith('Trac'):
continue
if doc.startswith('Wiki'):
continue
page = rpc_srv.wiki.getPage(doc)
info = rpc_srv.wiki.getPageInfo(doc)
# print info
d = docs()
d.caption = doc
d.text = convert(page, '/docs/').strip()
d.u_date = info['lastModified']
d.save(user=user)
atts = rpc_srv.wiki.listAttachments(doc)
for att in atts:
print '=> %s' % att
path, filename = os.path.split(att)
file = rpc_srv.wiki.getAttachment(att)
mimetype = mimetypes.guess_type(filename)
f = docs_files()
f.name = filename
f.size = 0
f.content_type = mimetype[0] if mimetype[0] else ''
f.doc_id = d.id
f.public = True
f.save(user=user)
dest = get_doc_files_folder()
if not os.path.exists(dest):
os.makedirs(dest)
with open('%s%s.dat' % (dest, f.id), 'wb') as destination:
destination.write(file.data)
destination.close()
hash_md5 = hashlib.md5()
with open('%s%s.dat' % (dest, f.id), "rb") as fo:
for chunk in iter(lambda: fo.read(4096), b""):
hash_md5.update(chunk)
f.checksum = hash_md5.hexdigest()
f.save(user=user)
if 'pdf' in f.content_type:
convertPDFtoImg('%s/%s.dat' % (dest, f.id), '%s/%s.preview' % (dest, f.id))
else:
if 'image' not in f.content_type and isPreviewable(f.content_type):
tmp = convertOfficeTpPDF('%s/%s.dat' % (dest, f.id))
convertPDFtoImg(tmp, '%s/%s.preview' % (dest, f.id))
if os.path.isfile(tmp):
os.unlink(tmp)
self.stdout.write('%s => %s' % (doc, d.pk))
def action(request, mode, ticket):
mod_path, cls_name = settings.TICKET_CLASS.rsplit('.', 1)
mod_path = mod_path.split('.').pop(0)
tic = apps.get_model(mod_path, cls_name).objects.get(pk=ticket)
if hasattr(settings, 'KEEP_IT_SIMPLE') and settings.KEEP_IT_SIMPLE:
keep_it_simple = True
else:
keep_it_simple = False
if mode == 'view':
if request.method == 'POST':
form = CommentForm(request.POST)
if form.is_valid():
com = tickets_comments()
com.comment = form.cleaned_data['comment']
com.ticket_id = ticket
com.action = 6
com.save(user=request.user)
check_references(request, com)
touch_ticket(request.user, ticket)
add_history(request, tic, 6, com.comment)
mail_comment(request, com.pk)
jabber_comment(request, com.pk)
else:
if 'resolution' in request.POST:
if request.POST['resolution'] and int(
request.POST['resolution']) > 0:
tic.resolution_id = request.POST['resolution']
tic.closed = True
tic.close_date = timezone.now()
tic.state = get_flow_end()
tic.save(user=request.user)
com = tickets_comments()
com.comment = _(
'ticket closed - resolution: %(resolution)s\n\n%(comment)s'
) % {
'resolution':
ticket_resolution.objects.get(
pk=request.POST['resolution']).name,
'comment':
request.POST.get('close_comment', '')
}
com.ticket_id = ticket
com.action = 1
com.save(user=request.user)
check_references(request, com)
touch_ticket(request.user, ticket)
add_history(request, tic, 1,
request.POST.get('close_comment', ''))
mail_comment(request, com.pk)
jabber_comment(request, com.pk)
else:
messages.add_message(request, messages.ERROR,
_('no resolution selected'))
else:
messages.add_message(request, messages.ERROR,
_('comment invalid'))
# reload ticket => last_action date has changed
tic = apps.get_model(mod_path, cls_name).objects.get(pk=ticket)
excludes = []
form = TicketsForm(exclude_list=excludes,
is_stuff=request.user.is_staff,
user=request.user,
instance=tic,
customer=request.organisation.id,
view_only=True)
close = TicketCloseForm()
reassign = TicketReassignForm(initial={
'assigned': tic.assigned_id,
'state': tic.state
})
flows = list(
ticket_flow_edges.objects.select_related('next').filter(
now=tic.state).exclude(next__type=2).values_list('next',
flat=True))
flows.append(tic.state_id)
reassign.fields['state'].queryset = reassign.fields[
'state'].queryset.filter(id__in=flows)
participants = tickets_participants.objects.select_related(
'user').filter(ticket=ticket)
comments = tickets_comments.objects.select_related('c_user').filter(
ticket=ticket).order_by('c_date')
close_allowed = ticket_flow_edges.objects.select_related(
'next').filter(now=tic.state, next__type=2).count() > 0
files = tickets_files.objects.filter(ticket=ticket, active_record=True)
paginator = Paginator(files, 10)
page = request.GET.get('page')
try:
files_lines = paginator.page(page)
except PageNotAnInteger:
# If page is not an integer, deliver first page.
files_lines = paginator.page(1)
except EmptyPage:
# If page is out of range (e.g. 9999), deliver last page of results.
files_lines = paginator.page(paginator.num_pages)
add_breadcrumbs(request, ticket, '#', caption=tic.caption[:20])
if 'YATSE' in request.GET and 'isUsingYATSE' not in request.session:
request.session['isUsingYATSE'] = True
return render(
request, 'tickets/view.html', {
'layout':
'horizontal',
'ticket':
tic,
'form':
form,
'close':
close,
'reassign':
reassign,
'files':
files_lines,
'comments':
comments,
'participants':
participants,
'close_allowed':
close_allowed,
'keep_it_simple':
keep_it_simple,
'last_action_date':
http_date(time.mktime(tic.last_action_date.timetuple()))
})
elif mode == 'gallery':
images = tickets_files.objects.filter(ticket=ticket,
active_record=True)
return render(request, 'tickets/gallery.html', {
'layout': 'horizontal',
'ticket': tic,
'images': images
})
elif mode == 'history':
history = tickets_history.objects.filter(ticket=ticket)
return render(
request, 'tickets/history.html', {
'layout': 'horizontal',
'ticket': tic,
'history': history,
'keep_it_simple': keep_it_simple
})
elif mode == 'reopen':
if tic.closed:
tic.closed = False
tic.state = get_flow_start()
tic.resolution = None
tic.close_date = None
tic.save(user=request.user)
com = tickets_comments()
com.comment = _('ticket reopend - resolution deleted')
com.ticket_id = ticket
com.action = 2
com.save(user=request.user)
check_references(request, com)
touch_ticket(request.user, ticket)
add_history(request, tic, 2, None)
mail_comment(request, com.pk)
jabber_comment(request, com.pk)
return HttpResponseRedirect('/tickets/view/%s/' % ticket)
elif mode == 'move':
if not tic.closed:
old_state = tic.state
tic.state = ticket_flow.objects.get(pk=request.POST['state'])
tic.save(user=request.user)
touch_ticket(request.user, ticket)
oldUser = str(User.objects.get(
pk=tic.assigned_id)) if tic.assigned_id else None
history_data = {
'old': {
'comment': '',
'assigned': oldUser,
'state': str(old_state)
},
'new': {
'comment': _('ticket moved'),
'assigned': oldUser,
'state': str(tic.state)
}
}
add_history(request, tic, 7, history_data)
return HttpResponse('OK')
elif mode == 'reassign':
if not tic.closed:
if 'assigned' in request.POST:
if request.POST['assigned'] and int(
request.POST['assigned']) > 0:
old_assigned_user = tic.assigned
old_state = tic.state
tic.assigned_id = request.POST['assigned']
tic.state = ticket_flow.objects.get(
pk=request.POST['state'])
tic.save(user=request.user)
newUser = User.objects.get(pk=request.POST['assigned'])
com = tickets_comments()
com.comment = _(
'ticket reassigned to %(user)s\nstate now: %(state)s\n\n%(comment)s'
) % {
'user': newUser,
'comment': request.POST.get('reassign_comment', ''),
'state': tic.state
}
com.ticket_id = ticket
com.action = 7
com.save(user=request.user)
check_references(request, com)
touch_ticket(request.user, ticket)
if request.POST['assigned']:
touch_ticket(newUser, ticket)
mail_comment(request, com.pk)
jabber_comment(request, com.pk)
history_data = {
'old': {
'comment': '',
'assigned': str(old_assigned_user),
'state': str(old_state)
},
'new': {
'comment':
request.POST.get('reassign_comment', ''),
'assigned':
str(User.objects.get(pk=request.POST['assigned'])),
'state':
str(tic.state)
}
}
add_history(request, tic, 7, history_data)
else:
messages.add_message(request, messages.ERROR,
_('missing assigned user'))
return HttpResponseRedirect('/tickets/view/%s/' % ticket)
elif mode == 'edit' or (mode == 'simple' and
(not tic.keep_it_simple or tic.closed)
and keep_it_simple):
excludes = ['resolution']
if request.method == 'POST':
form = TicketsForm(request.POST,
exclude_list=excludes,
is_stuff=request.user.is_staff,
user=request.user,
instance=tic,
customer=request.organisation.id)
if form.is_valid():
tic = form.save()
if tic.keep_it_simple:
tic.keep_it_simple = False
tic.save(user=request.user)
assigned = form.cleaned_data.get('assigned')
if assigned:
touch_ticket(assigned, tic.pk)
mail_ticket(request, tic.pk, form)
jabber_ticket(request, tic.pk, form)
remember_changes(request, form, tic)
touch_ticket(request.user, tic.pk)
return HttpResponseRedirect('/tickets/view/%s/' % ticket)
else:
form = TicketsForm(exclude_list=excludes,
is_stuff=request.user.is_staff,
user=request.user,
instance=tic,
customer=request.organisation.id)
if 'state' in form.fields:
form.fields['state'].queryset = form.fields[
'state'].queryset.exclude(type=2)
return render(request, 'tickets/edit.html', {
'ticket': tic,
'layout': 'horizontal',
'form': form
})
elif mode == 'simple':
if request.method == 'POST':
form = SimpleTickets(request.POST,
initial={
'caption': tic.caption,
'description': tic.description,
'priority': tic.priority,
'assigned': tic.assigned
})
if form.is_valid():
cd = form.cleaned_data
tic.caption = cd['caption']
tic.description = cd['description'].replace(u"\u00A0", " ")
tic.priority = cd['priority']
tic.assigned = cd['assigned']
tic.deadline = cd['deadline']
tic.show_start = cd['show_start']
tic.component = cd['component']
tic.save(user=request.user)
if cd['assigned']:
touch_ticket(cd['assigned'], tic.pk)
remember_changes(request, form, tic)
touch_ticket(request.user, tic.pk)
mail_ticket(request, tic.pk, form)
jabber_ticket(request, tic.pk, form)
return HttpResponseRedirect('/tickets/view/%s/' % ticket)
else:
form = SimpleTickets(
initial={
'caption': tic.caption,
'description': tic.description,
'priority': tic.priority,
'assigned': tic.assigned,
'deadline': tic.deadline,
'show_start': tic.show_start,
'component': tic.component,
})
return render(request, 'tickets/edit.html', {
'ticket': tic,
'layout': 'horizontal',
'form': form,
'mode': mode
})
elif mode == 'download':
fileid = request.GET.get('file', -1)
file_data = tickets_files.objects.get(id=fileid, ticket=ticket)
src = '%s%s.dat' % (settings.FILE_UPLOAD_PATH, fileid)
content_type = file_data.content_type
if request.GET.get('preview') == 'yes' and os.path.isfile(
'%s%s.preview' % (settings.FILE_UPLOAD_PATH, fileid)):
src = '%s%s.preview' % (settings.FILE_UPLOAD_PATH, fileid)
content_type = 'imgae/png'
if request.GET.get(
'resize',
'no') == 'yes' and ('image' in file_data.content_type
or 'pdf' in file_data.content_type):
img = resize_image('%s' % (src), (200, 150), 75)
output = io.BytesIO()
img.save(output, 'PNG')
output.seek(0)
response = StreamingHttpResponse(output, content_type='image/png')
else:
response = StreamingHttpResponse(open('%s' % (src), "rb"),
content_type=content_type)
if 'noDisposition' not in request.GET:
if request.GET.get('preview') == 'yes' and os.path.isfile(
'%s%s.preview' % (settings.FILE_UPLOAD_PATH, fileid)):
response[
'Content-Disposition'] = 'attachment;filename="%s"' % content_type
else:
response[
'Content-Disposition'] = 'attachment;filename="%s"' % smart_str(
file_data.name)
return response
elif mode == 'upload':
if request.method == 'POST':
form = UploadFileForm(request.POST, request.FILES)
if form.is_valid():
if tickets_files.objects.filter(
active_record=True,
ticket=ticket,
checksum=request.FILES['file'].hash).count() > 0:
messages.add_message(
request, messages.ERROR,
_('File already exists: %s') %
request.FILES['file'].name)
if request.GET.get('Ajax') == '1':
return HttpResponse('OK')
return HttpResponseRedirect('/tickets/view/%s/' % ticket)
f = tickets_files()
f.name = request.FILES['file'].name
f.size = request.FILES['file'].size
f.checksum = request.FILES['file'].hash
f.content_type = request.FILES['file'].content_type
f.ticket_id = ticket
f.public = True
f.save(user=request.user)
touch_ticket(request.user, ticket)
add_history(request, tic, 5, request.FILES['file'].name)
mail_file(request, f.pk)
jabber_file(request, f.pk)
dest = settings.FILE_UPLOAD_PATH
if not os.path.exists(dest):
os.makedirs(dest)
with open('%s%s.dat' % (dest, f.id), 'wb+') as destination:
for chunk in request.FILES['file'].chunks():
destination.write(chunk)
if 'pdf' in f.content_type:
convertPDFtoImg('%s/%s.dat' % (dest, f.id),
'%s/%s.preview' % (dest, f.id))
else:
if 'image' not in f.content_type and isPreviewable(
f.content_type):
tmp = convertOfficeTpPDF('%s/%s.dat' % (dest, f.id))
convertPDFtoImg(tmp, '%s/%s.preview' % (dest, f.id))
if os.path.isfile(tmp):
os.unlink(tmp)
return HttpResponseRedirect('/tickets/view/%s/' % tic.pk)
else:
msg = unicode(form.errors['file'])
msg = re.sub('<[^<]+?>', '', msg)
messages.add_message(request, messages.ERROR, msg)
if request.GET.get('Ajax') == '1':
return HttpResponse('OK')
return HttpResponseRedirect('/tickets/view/%s/' % ticket)
elif request.method == 'PUT':
# /tickets/upload/XXX/?filename=test1.txt
upload_handlers = request.upload_handlers
content_type = str(request.META.get('CONTENT_TYPE', ""))
content_length = int(request.META.get('CONTENT_LENGTH', 0))
if content_type == "":
return HttpResponse('missing ContentType', status=400)
if content_length == 0:
# both returned 0
return HttpResponse('missing ContentLength', status=400)
content_type = content_type.split(";")[0].strip()
try:
charset = content_type.split(";")[1].strip()
except IndexError:
charset = ""
# we can get the file name via the path, we don't actually
file_name = request.GET['filename']
field_name = file_name
counters = [0] * len(upload_handlers)
for handler in upload_handlers:
result = handler.handle_raw_input("", request.META,
content_length, "", "")
from django.core.files.uploadhandler import StopFutureHandlers
for handler in upload_handlers:
try:
handler.new_file(field_name, file_name, content_type,
content_length, charset)
except StopFutureHandlers:
break
for i, handler in enumerate(upload_handlers):
while True:
chunk = request.read(handler.chunk_size)
if chunk:
handler.receive_data_chunk(chunk, counters[i])
counters[i] += len(chunk)
else:
# no chunk
break
for i, handler in enumerate(upload_handlers):
file_obj = handler.file_complete(counters[i])
if file_obj:
if settings.FILE_UPLOAD_VIRUS_SCAN and pyclamd:
# virus scan
try:
if not hasattr(pyclamd, 'scan_stream'):
cd = pyclamd.ClamdUnixSocket()
else:
pyclamd.init_network_socket('localhost', 3310)
cd = pyclamd
# We need to get a file object for clamav. We might have a path or we might
# have to read the data into memory.
if hasattr(file_obj, 'temporary_file_path'):
os.chmod(file_obj.temporary_file_path(), 0664)
result = cd.scan_file(
file_obj.temporary_file_path())
else:
if hasattr(file_obj, 'read'):
result = cd.scan_stream(file_obj.read())
else:
result = cd.scan_stream(
file_obj['content'])
except:
from socket import gethostname
raise Exception(
_(u'unable to initialize scan engine on host %s'
) % gethostname())
if result:
msg = ' '.join(result[result.keys()[0]]).replace(
'FOUND ', '')
raise Exception(
_(u"file is infected by virus: %s") % msg)
hasher = hashlib.md5()
# We need to get a file object for clamav. We might have a path or we might
# have to read the data into memory.
if hasattr(file_obj, 'temporary_file_path'):
with open(file_obj.temporary_file_path(),
'rb') as afile:
buf = afile.read()
hasher.update(buf)
hash = hasher.hexdigest()
else:
if hasattr(file_obj, 'read'):
file_obj.seek(0)
buf = file_obj.read()
hasher.update(buf)
else:
hasher.update(file_obj['content'].read())
hash = hasher.hexdigest()
if tickets_files.objects.filter(active_record=True,
ticket=ticket,
checksum=hash).count() > 0:
raise Exception(
'duplicate hash value - file already exists in this ticket %s'
% ticket)
# todo: virusscan
f = tickets_files()
f.name = file_obj.name
f.size = file_obj.size
f.checksum = hash
f.content_type = content_type
f.ticket_id = ticket
f.public = True
f.save(user=request.user)
touch_ticket(request.user, ticket)
add_history(request, tic, 5, file_obj.name)
mail_file(request, f.pk)
jabber_file(request, f.pk)
dest = settings.FILE_UPLOAD_PATH
if not os.path.exists(dest):
os.makedirs(dest)
with open('%s%s.dat' % (dest, f.id), 'wb+') as destination:
for chunk in file_obj.chunks():
destination.write(chunk)
if 'pdf' in f.content_type:
convertPDFtoImg('%s/%s.dat' % (dest, f.id),
'%s/%s.preview' % (dest, f.id))
else:
if 'image' not in f.content_type and isPreviewable(
f.content_type):
try:
tmp = convertOfficeTpPDF('%s/%s.dat' %
(dest, f.id))
convertPDFtoImg(tmp,
'%s/%s.preview' % (dest, f.id))
if os.path.isfile(tmp):
os.unlink(tmp)
except:
pass
if 'audio' in f.content_type:
try:
# https://realpython.com/python-speech-recognition/
import speech_recognition as sr
AUDIO_FILE = '%s%s.dat' % (dest, f.id)
r = sr.Recognizer()
with sr.AudioFile(AUDIO_FILE) as source:
audio = r.record(
source) # read the entire audio file
text = r.recognize_google(audio,
language='de-DE')
if text:
com = tickets_comments()
com.comment = text
com.ticket_id = ticket
com.action = 6
com.save(user=request.user)
except:
pass
return HttpResponse(status=201)
else:
# some indication this didn't work?
return HttpResponse(status=500)
else:
form = UploadFileForm()
return render(request, 'tickets/file.html', {
'ticketid': ticket,
'layout': 'horizontal',
'form': form
})
elif mode == 'delfile':
file = tickets_files.objects.get(pk=request.GET['fileid'],
ticket=ticket)
file.delete(user=request.user)
touch_ticket(request.user, ticket)
add_history(request, tic, 8, file.name)
return HttpResponseRedirect('/tickets/view/%s/#files' % tic.pk)
elif mode == 'notify':
tickets_participants.objects.filter(
ticket=tic, user=request.user).update(seen=True)
return HttpResponse('OK')
elif mode == 'sleep':
interval = request.GET.get('interval')
if interval in ['1', '2', '3', '4', '5', '6', '7', '14', '21', '30']:
old = tic.show_start
tic.show_start = timezone.now() + datetime.timedelta(
days=int(interval))
tic.save(user=request.user)
touch_ticket(request.user, ticket)
add_history(request, tic, 10, (tic.show_start, old))
return HttpResponse('OK')
else:
raise Exception('no interval given')
elif mode == 'ignore':
ig = tickets_ignorants()
ig.ticket = tic
ig.user = request.user
ig.save()
return HttpResponse('OK')
elif mode == 'todo':
class local:
counter = 0
def ToDoDone(match):
local.counter += 1
group = match.groups()
if local.counter == pos:
return u'[X]'
else:
return u'[%s]' % group[0]
def ToDoUnDone(match):
local.counter += 1
group = match.groups()
if local.counter == pos:
return u'[ ]'
else:
return u'[%s]' % group[0]
form = ToDo(request.POST)
if form.is_valid():
desc = tic.description
cd = form.cleaned_data
text = cd['text']
pos = cd['item']
set = cd['set']
if set:
tic.description = re.sub(r'\[([ Xx])\]', ToDoDone, desc)
old = _('undone: %s') % text
new = _('done: %s') % text
else:
tic.description = re.sub(r'\[([ Xx])\]', ToDoUnDone, desc)
new = _('undone: %s') % text
old = _('done: %s') % text
tic.save(user=request.user)
touch_ticket(request.user, ticket)
add_history(request, tic, 9, (new, old))
data = {
'set': set,
'item': pos,
'text': text,
}
return JsonResponse(data, safe=False)
elif mode == 'update_comment':
if request.method == 'POST':
comment_id = request.GET.get("comment_id")
comment = tickets_comments.objects.get(pk=comment_id)
if comment.c_user == request.user:
comment.comment = request.POST.get("comment_body", "")
comment.edited = True
comment.save(user=request.user)
return HttpResponseRedirect("/tickets/view/%s/#comment_id-%s" %
(ticket, comment_id))
elif mode == 'last_modified':
if_modified_since = request.META.get('HTTP_IF_MODIFIED_SINCE')
if if_modified_since:
if_modified_since = parse_http_date_safe(if_modified_since)
if time.mktime(
tic.last_action_date.timetuple()) > if_modified_since:
return HttpResponse('outdated', status=200)
else:
return HttpResponse('not modified', status=304)
else:
return HttpResponse('unknown', status=412)
def action(request, mode, ticket):
mod_path, cls_name = settings.TICKET_CLASS.rsplit('.', 1)
mod_path = mod_path.split('.').pop(0)
tic = apps.get_model(mod_path, cls_name).objects.get(pk=ticket)
if hasattr(settings, 'KEEP_IT_SIMPLE') and settings.KEEP_IT_SIMPLE:
keep_it_simple = True
else:
keep_it_simple = False
if mode == 'view':
if request.method == 'POST':
form = CommentForm(request.POST)
if form.is_valid():
com = tickets_comments()
com.comment = form.cleaned_data['comment']
com.ticket_id = ticket
com.action = 6
com.save(user=request.user)
check_references(request, com)
touch_ticket(request.user, ticket)
add_history(request, tic, 6, com.comment)
mail_comment(request, com.pk)
jabber_comment(request, com.pk)
else:
if 'resolution' in request.POST:
if request.POST['resolution'] and int(request.POST['resolution']) > 0:
tic.resolution_id = request.POST['resolution']
tic.closed = True
tic.close_date = timezone.now()
tic.state = get_flow_end()
tic.save(user=request.user)
com = tickets_comments()
com.comment = _('ticket closed - resolution: %(resolution)s\n\n%(comment)s') % {'resolution': ticket_resolution.objects.get(pk=request.POST['resolution']).name, 'comment': request.POST.get('close_comment', '')}
com.ticket_id = ticket
com.action = 1
com.save(user=request.user)
check_references(request, com)
touch_ticket(request.user, ticket)
add_history(request, tic, 1, request.POST.get('close_comment', ''))
mail_comment(request, com.pk)
jabber_comment(request, com.pk)
else:
messages.add_message(request, messages.ERROR, _('no resolution selected'))
else:
messages.add_message(request, messages.ERROR, _('comment invalid'))
excludes = []
form = TicketsForm(exclude_list=excludes, is_stuff=request.user.is_staff, user=request.user, instance=tic, customer=request.organisation.id, view_only=True)
close = TicketCloseForm()
reassign = TicketReassignForm(initial={'assigned': tic.assigned_id, 'state': tic.state})
flows = list(ticket_flow_edges.objects.select_related('next').filter(now=tic.state).exclude(next__type=2).values_list('next', flat=True))
flows.append(tic.state_id)
reassign.fields['state'].queryset = reassign.fields['state'].queryset.filter(id__in=flows)
participants = tickets_participants.objects.select_related('user').filter(ticket=ticket)
comments = tickets_comments.objects.select_related('c_user').filter(ticket=ticket).order_by('c_date')
close_allowed = ticket_flow_edges.objects.select_related('next').filter(now=tic.state, next__type=2).count() > 0
files = tickets_files.objects.filter(ticket=ticket, active_record=True)
paginator = Paginator(files, 10)
page = request.GET.get('page')
try:
files_lines = paginator.page(page)
except PageNotAnInteger:
# If page is not an integer, deliver first page.
files_lines = paginator.page(1)
except EmptyPage:
# If page is out of range (e.g. 9999), deliver last page of results.
files_lines = paginator.page(paginator.num_pages)
add_breadcrumbs(request, ticket, '#', caption=tic.caption[:20])
if 'YATSE' in request.GET and 'isUsingYATSE' not in request.session:
request.session['isUsingYATSE'] = True
return render(request, 'tickets/view.html', {'layout': 'horizontal', 'ticket': tic, 'form': form, 'close': close, 'reassign': reassign, 'files': files_lines, 'comments': comments, 'participants': participants, 'close_allowed': close_allowed, 'keep_it_simple': keep_it_simple, 'last_action_date': http_date(time.mktime(tic.last_action_date.timetuple()))})
elif mode == 'gallery':
images = tickets_files.objects.filter(ticket=ticket, active_record=True)
return render(request, 'tickets/gallery.html', {'layout': 'horizontal', 'ticket': tic, 'images': images})
elif mode == 'history':
history = tickets_history.objects.filter(ticket=ticket)
return render(request, 'tickets/history.html', {'layout': 'horizontal', 'ticket': tic, 'history': history, 'keep_it_simple': keep_it_simple})
elif mode == 'reopen':
if tic.closed:
tic.closed = False
tic.state = get_flow_start()
tic.resolution = None
tic.close_date = None
tic.save(user=request.user)
com = tickets_comments()
com.comment = _('ticket reopend - resolution deleted')
com.ticket_id = ticket
com.action = 2
com.save(user=request.user)
check_references(request, com)
touch_ticket(request.user, ticket)
add_history(request, tic, 2, None)
mail_comment(request, com.pk)
jabber_comment(request, com.pk)
return HttpResponseRedirect('/tickets/view/%s/' % ticket)
elif mode == 'move':
if not tic.closed:
old_state = tic.state
tic.state = ticket_flow.objects.get(pk=request.POST['state'])
tic.save(user=request.user)
touch_ticket(request.user, ticket)
oldUser = str(User.objects.get(pk=tic.assigned_id)) if tic.assigned_id else None
history_data = {
'old': {'comment': '', 'assigned': oldUser, 'state': str(old_state)},
'new': {'comment': _('ticket moved'), 'assigned': oldUser, 'state': str(tic.state)}
}
add_history(request, tic, 7, history_data)
return HttpResponse('OK')
elif mode == 'reassign':
if not tic.closed:
if 'assigned' in request.POST:
if request.POST['assigned'] and int(request.POST['assigned']) > 0:
old_assigned_user = tic.assigned
old_state = tic.state
tic.assigned_id = request.POST['assigned']
tic.state = ticket_flow.objects.get(pk=request.POST['state'])
tic.save(user=request.user)
newUser = User.objects.get(pk=request.POST['assigned'])
com = tickets_comments()
com.comment = _('ticket reassigned to %(user)s\nstate now: %(state)s\n\n%(comment)s') % {'user': newUser, 'comment': request.POST.get('reassign_comment', ''), 'state': tic.state}
com.ticket_id = ticket
com.action = 7
com.save(user=request.user)
check_references(request, com)
touch_ticket(request.user, ticket)
if request.POST['assigned']:
touch_ticket(newUser, ticket)
mail_comment(request, com.pk)
jabber_comment(request, com.pk)
history_data = {
'old': {'comment': '', 'assigned': str(old_assigned_user), 'state': str(old_state)},
'new': {'comment': request.POST.get('reassign_comment', ''), 'assigned': str(User.objects.get(pk=request.POST['assigned'])), 'state': str(tic.state)}
}
add_history(request, tic, 7, history_data)
else:
messages.add_message(request, messages.ERROR, _('missing assigned user'))
return HttpResponseRedirect('/tickets/view/%s/' % ticket)
elif mode == 'edit' or (mode == 'simple' and (not tic.keep_it_simple or tic.closed) and keep_it_simple):
excludes = ['resolution']
if request.method == 'POST':
form = TicketsForm(request.POST, exclude_list=excludes, is_stuff=request.user.is_staff, user=request.user, instance=tic, customer=request.organisation.id)
if form.is_valid():
tic = form.save()
if tic.keep_it_simple:
tic.keep_it_simple = False
tic.save(user=request.user)
assigned = form.cleaned_data.get('assigned')
if assigned:
touch_ticket(assigned, tic.pk)
mail_ticket(request, tic.pk, form)
jabber_ticket(request, tic.pk, form)
remember_changes(request, form, tic)
touch_ticket(request.user, tic.pk)
return HttpResponseRedirect('/tickets/view/%s/' % ticket)
else:
form = TicketsForm(exclude_list=excludes, is_stuff=request.user.is_staff, user=request.user, instance=tic, customer=request.organisation.id)
if 'state' in form.fields:
form.fields['state'].queryset = form.fields['state'].queryset.exclude(type=2)
return render(request, 'tickets/edit.html', {'ticket': tic, 'layout': 'horizontal', 'form': form})
elif mode == 'simple':
if request.method == 'POST':
form = SimpleTickets(request.POST, initial={
'caption': tic.caption,
'description': tic.description,
'priority': tic.priority,
'assigned': tic.assigned
})
if form.is_valid():
cd = form.cleaned_data
tic.caption = cd['caption']
tic.description = cd['description'].replace(u"\u00A0", " ")
tic.priority = cd['priority']
tic.assigned = cd['assigned']
tic.deadline = cd['deadline']
tic.show_start = cd['show_start']
tic.component = cd['component']
tic.save(user=request.user)
if cd['assigned']:
touch_ticket(cd['assigned'], tic.pk)
remember_changes(request, form, tic)
touch_ticket(request.user, tic.pk)
mail_ticket(request, tic.pk, form)
jabber_ticket(request, tic.pk, form)
return HttpResponseRedirect('/tickets/view/%s/' % ticket)
else:
form = SimpleTickets(initial={
'caption': tic.caption,
'description': tic.description,
'priority': tic.priority,
'assigned': tic.assigned,
'deadline': tic.deadline,
'show_start': tic.show_start,
'component': tic.component,
})
return render(request, 'tickets/edit.html', {'ticket': tic, 'layout': 'horizontal', 'form': form, 'mode': mode})
elif mode == 'download':
fileid = request.GET.get('file', -1)
file_data = tickets_files.objects.get(id=fileid, ticket=ticket)
src = '%s%s.dat' % (settings.FILE_UPLOAD_PATH, fileid)
content_type = file_data.content_type
if request.GET.get('preview') == 'yes' and os.path.isfile('%s%s.preview' % (settings.FILE_UPLOAD_PATH, fileid)):
src = '%s%s.preview' % (settings.FILE_UPLOAD_PATH, fileid)
content_type = 'imgae/png'
if request.GET.get('resize', 'no') == 'yes' and ('image' in file_data.content_type or 'pdf' in file_data.content_type):
img = resize_image('%s' % (src), (200, 150), 75)
output = io.BytesIO()
img.save(output, 'PNG')
output.seek(0)
response = StreamingHttpResponse(output, content_type='image/png')
else:
response = StreamingHttpResponse(open('%s' % (src), "rb"), content_type=content_type)
if 'noDisposition' not in request.GET:
if request.GET.get('preview') == 'yes' and os.path.isfile('%s%s.preview' % (settings.FILE_UPLOAD_PATH, fileid)):
response['Content-Disposition'] = 'attachment;filename="%s"' % content_type
else:
response['Content-Disposition'] = 'attachment;filename="%s"' % smart_str(file_data.name)
return response
elif mode == 'upload':
if request.method == 'POST':
form = UploadFileForm(request.POST, request.FILES)
if form.is_valid():
if tickets_files.objects.filter(active_record=True, ticket=ticket, checksum=request.FILES['file'].hash).count() > 0:
messages.add_message(request, messages.ERROR, _('File already exists: %s') % request.FILES['file'].name)
if request.GET.get('Ajax') == '1':
return HttpResponse('OK')
return HttpResponseRedirect('/tickets/view/%s/' % ticket)
f = tickets_files()
f.name = request.FILES['file'].name
f.size = request.FILES['file'].size
f.checksum = request.FILES['file'].hash
f.content_type = request.FILES['file'].content_type
f.ticket_id = ticket
f.public = True
f.save(user=request.user)
touch_ticket(request.user, ticket)
add_history(request, tic, 5, request.FILES['file'].name)
mail_file(request, f.pk)
jabber_file(request, f.pk)
dest = settings.FILE_UPLOAD_PATH
if not os.path.exists(dest):
os.makedirs(dest)
with open('%s%s.dat' % (dest, f.id), 'wb+') as destination:
for chunk in request.FILES['file'].chunks():
destination.write(chunk)
if 'pdf' in f.content_type:
convertPDFtoImg('%s/%s.dat' % (dest, f.id), '%s/%s.preview' % (dest, f.id))
else:
if 'image' not in f.content_type and isPreviewable(f.content_type):
tmp = convertOfficeTpPDF('%s/%s.dat' % (dest, f.id))
convertPDFtoImg(tmp, '%s/%s.preview' % (dest, f.id))
if os.path.isfile(tmp):
os.unlink(tmp)
return HttpResponseRedirect('/tickets/view/%s/' % tic.pk)
else:
msg = unicode(form.errors['file'])
msg = re.sub('<[^<]+?>', '', msg)
messages.add_message(request, messages.ERROR, msg)
if request.GET.get('Ajax') == '1':
return HttpResponse('OK')
return HttpResponseRedirect('/tickets/view/%s/' % ticket)
elif request.method == 'PUT':
# /tickets/upload/XXX/?filename=test1.txt
upload_handlers = request.upload_handlers
content_type = str(request.META.get('CONTENT_TYPE', ""))
content_length = int(request.META.get('CONTENT_LENGTH', 0))
if content_type == "":
return HttpResponse('missing ContentType', status=400)
if content_length == 0:
# both returned 0
return HttpResponse('missing ContentLength', status=400)
content_type = content_type.split(";")[0].strip()
try:
charset = content_type.split(";")[1].strip()
except IndexError:
charset = ""
# we can get the file name via the path, we don't actually
file_name = request.GET['filename']
field_name = file_name
counters = [0]*len(upload_handlers)
for handler in upload_handlers:
result = handler.handle_raw_input("", request.META, content_length, "", "")
from django.core.files.uploadhandler import StopFutureHandlers
for handler in upload_handlers:
try:
handler.new_file(field_name, file_name,
content_type, content_length, charset)
except StopFutureHandlers:
break
for i, handler in enumerate(upload_handlers):
while True:
chunk = request.read(handler.chunk_size)
if chunk:
handler.receive_data_chunk(chunk, counters[i])
counters[i] += len(chunk)
else:
# no chunk
break
for i, handler in enumerate(upload_handlers):
file_obj = handler.file_complete(counters[i])
if file_obj:
if settings.FILE_UPLOAD_VIRUS_SCAN and pyclamd:
# virus scan
try:
if not hasattr(pyclamd, 'scan_stream'):
cd = pyclamd.ClamdUnixSocket()
else:
pyclamd.init_network_socket('localhost', 3310)
cd = pyclamd
# We need to get a file object for clamav. We might have a path or we might
# have to read the data into memory.
if hasattr(file_obj, 'temporary_file_path'):
os.chmod(file_obj.temporary_file_path(), 0664)
result = cd.scan_file(file_obj.temporary_file_path())
else:
if hasattr(file_obj, 'read'):
result = cd.scan_stream(file_obj.read())
else:
result = cd.scan_stream(file_obj['content'])
except:
from socket import gethostname
raise Exception(_(u'unable to initialize scan engine on host %s') % gethostname())
if result:
msg = ' '.join(result[result.keys()[0]]).replace('FOUND ', '')
raise Exception(_(u"file is infected by virus: %s") % msg)
hasher = hashlib.md5()
# We need to get a file object for clamav. We might have a path or we might
# have to read the data into memory.
if hasattr(file_obj, 'temporary_file_path'):
with open(file_obj.temporary_file_path(), 'rb') as afile:
buf = afile.read()
hasher.update(buf)
hash = hasher.hexdigest()
else:
if hasattr(file_obj, 'read'):
file_obj.seek(0)
buf = file_obj.read()
hasher.update(buf)
else:
hasher.update(file_obj['content'].read())
hash = hasher.hexdigest()
if tickets_files.objects.filter(active_record=True, ticket=ticket, checksum=hash).count() > 0:
raise Exception('duplicate hash value - file already exists in this ticket %s' % ticket)
# todo: virusscan
f = tickets_files()
f.name = file_obj.name
f.size = file_obj.size
f.checksum = hash
f.content_type = content_type
f.ticket_id = ticket
f.public = True
f.save(user=request.user)
touch_ticket(request.user, ticket)
add_history(request, tic, 5, file_obj.name)
mail_file(request, f.pk)
jabber_file(request, f.pk)
dest = settings.FILE_UPLOAD_PATH
if not os.path.exists(dest):
os.makedirs(dest)
with open('%s%s.dat' % (dest, f.id), 'wb+') as destination:
for chunk in file_obj.chunks():
destination.write(chunk)
if 'pdf' in f.content_type:
convertPDFtoImg('%s/%s.dat' % (dest, f.id), '%s/%s.preview' % (dest, f.id))
else:
if 'image' not in f.content_type and isPreviewable(f.content_type):
try:
tmp = convertOfficeTpPDF('%s/%s.dat' % (dest, f.id))
convertPDFtoImg(tmp, '%s/%s.preview' % (dest, f.id))
if os.path.isfile(tmp):
os.unlink(tmp)
except:
pass
if 'audio' in f.content_type:
try:
# https://realpython.com/python-speech-recognition/
import speech_recognition as sr
AUDIO_FILE = '%s%s.dat' % (dest, f.id)
r = sr.Recognizer()
with sr.AudioFile(AUDIO_FILE) as source:
audio = r.record(source) # read the entire audio file
text = r.recognize_google(audio, language='de-DE')
if text:
com = tickets_comments()
com.comment = text
com.ticket_id = ticket
com.action = 6
com.save(user=request.user)
except:
pass
return HttpResponse(status=201)
else:
# some indication this didn't work?
return HttpResponse(status=500)
else:
form = UploadFileForm()
return render(request, 'tickets/file.html', {'ticketid': ticket, 'layout': 'horizontal', 'form': form})
elif mode == 'delfile':
file = tickets_files.objects.get(pk=request.GET['fileid'], ticket=ticket)
file.delete(user=request.user)
touch_ticket(request.user, ticket)
add_history(request, tic, 8, file.name)
return HttpResponseRedirect('/tickets/view/%s/#files' % tic.pk)
elif mode == 'notify':
tickets_participants.objects.filter(ticket=tic, user=request.user).update(seen=True)
return HttpResponse('OK')
elif mode == 'sleep':
interval = request.GET.get('interval')
if interval in ['1', '7', '30']:
old = tic.show_start
tic.show_start = timezone.now() + datetime.timedelta(days=int(interval))
tic.save(user=request.user)
touch_ticket(request.user, ticket)
add_history(request, tic, 10, (tic.show_start, old))
return HttpResponse('OK')
else:
raise Exception('no interval given')
elif mode == 'ignore':
ig = tickets_ignorants()
ig.ticket = tic
ig.user = request.user
ig.save()
return HttpResponse('OK')
elif mode == 'todo':
class local:
counter = 0
def ToDoDone(match):
local.counter += 1
group = match.groups()
if local.counter == pos:
return u'[X]'
else:
return u'[%s]' % group[0]
def ToDoUnDone(match):
local.counter += 1
group = match.groups()
if local.counter == pos:
return u'[ ]'
else:
return u'[%s]' % group[0]
form = ToDo(request.POST)
if form.is_valid():
desc = tic.description
cd = form.cleaned_data
text = cd['text']
pos = cd['item']
set = cd['set']
if set:
tic.description = re.sub(r'\[([ Xx])\]', ToDoDone, desc)
old = _('undone: %s') % text
new = _('done: %s') % text
else:
tic.description = re.sub(r'\[([ Xx])\]', ToDoUnDone, desc)
new = _('undone: %s') % text
old = _('done: %s') % text
tic.save(user=request.user)
touch_ticket(request.user, ticket)
add_history(request, tic, 9, (new, old))
data = {
'set': set,
'item': pos,
'text': text,
}
return JsonResponse(data, safe=False)
elif mode == 'update_comment':
if request.method == 'POST':
comment_id = request.GET.get("comment_id")
comment = tickets_comments.objects.get(pk=comment_id)
if comment.c_user == request.user:
comment.comment = request.POST.get("comment_body", "")
comment.edited = True
comment.save(user=request.user)
return HttpResponseRedirect("/tickets/view/%s/#comment_id-%s" % (ticket, comment_id))
elif mode == 'last_modified':
if_modified_since = request.META.get('HTTP_IF_MODIFIED_SINCE')
if if_modified_since:
if_modified_since = parse_http_date_safe(if_modified_since)
if time.mktime(tic.last_action_date.timetuple()) > if_modified_since:
return HttpResponse('outdated', status=200)
else:
return HttpResponse('not modified', status=304)
else:
return HttpResponse('unknown', status=412)
def docs_action(request, mode, docid):
doc = docs.objects.get(pk=docid)
if mode == 'view':
form = DocsForm(user=request.user, instance=doc, view_only=True)
add_breadcrumbs(request, docid, '*', caption=doc.caption[:20])
files = docs_files.objects.filter(doc=doc, active_record=True)
paginator = Paginator(files, 10)
page = request.GET.get('page')
try:
files_lines = paginator.page(page)
except PageNotAnInteger:
# If page is not an integer, deliver first page.
files_lines = paginator.page(1)
except EmptyPage:
# If page is out of range (e.g. 9999), deliver last page of results.
files_lines = paginator.page(paginator.num_pages)
return render(request, 'docs/view.html', {'layout': 'horizontal', 'form': form, 'doc': doc, 'files': files_lines})
elif mode == 'edit':
if request.method == 'POST':
form = DocsForm(request.POST, user=request.user, instance=doc)
if form.is_valid():
doc = form.save()
return HttpResponseRedirect('/docs/view/%s/' % doc.pk)
form = DocsForm(user=request.user, instance=doc)
return render(request, 'docs/edit.html', {'layout': 'horizontal', 'form': form, 'doc': doc})
elif mode == 'delete':
doc.delete(user=request.user)
return HttpResponseRedirect('/search/?q=%s&models=yats.docs&models=web.test' % request.session.get('last_fulltextsearch', '*'))
elif mode == 'ticket':
ticket = get_ticket_model()
tic = ticket()
tic.caption = doc.caption
tic.description = doc.text
if hasattr(settings, 'KEEP_IT_SIMPLE_DEFAULT_CUSTOMER') and settings.KEEP_IT_SIMPLE_DEFAULT_CUSTOMER:
if settings.KEEP_IT_SIMPLE_DEFAULT_CUSTOMER == -1:
tic.customer = request.organisation
else:
tic.customer_id = settings.KEEP_IT_SIMPLE_DEFAULT_CUSTOME
if not tic.component_id and hasattr(settings, 'KEEP_IT_SIMPLE_DEFAULT_COMPONENT') and settings.KEEP_IT_SIMPLE_DEFAULT_COMPONENT:
tic.component_id = settings.KEEP_IT_SIMPLE_DEFAULT_COMPONENT
tic.save(user=request.user)
add_breadcrumbs(request, str(tic.pk), '#', caption=tic.caption[:20])
if hasattr(settings, 'KEEP_IT_SIMPLE') and settings.KEEP_IT_SIMPLE:
return HttpResponseRedirect('/tickets/simple/%s/' % tic.pk)
else:
return HttpResponseRedirect('/tickets/edit/%s/' % tic.pk)
elif mode == 'download':
fileid = request.GET.get('file', -1)
file_data = docs_files.objects.get(id=fileid, doc=doc)
src = '%s%s.dat' % (get_doc_files_folder(), fileid)
content_type = file_data.content_type
if request.GET.get('preview') == 'yes' and os.path.isfile('%s%s.preview' % (get_doc_files_folder(), fileid)):
src = '%s%s.preview' % (get_doc_files_folder(), fileid)
content_type = 'imgae/png'
if request.GET.get('resize', 'no') == 'yes' and ('image' in file_data.content_type or 'pdf' in file_data.content_type):
img = resize_image('%s' % (src), (200, 150), 75)
output = io.BytesIO()
img.save(output, 'PNG')
output.seek(0)
response = StreamingHttpResponse(output, content_type='image/png')
else:
response = StreamingHttpResponse(open('%s' % (src), "rb"), content_type=content_type)
if 'noDisposition' not in request.GET:
if request.GET.get('preview') == 'yes' and os.path.isfile('%s%s.preview' % (get_doc_files_folder(), fileid)):
response['Content-Disposition'] = 'attachment;filename=%s' % content_type
else:
response['Content-Disposition'] = 'attachment;filename=%s' % smart_str(file_data.name)
return response
elif mode == 'upload':
if request.method == 'POST':
form = UploadFileForm(request.POST, request.FILES)
if form.is_valid():
if docs_files.objects.filter(active_record=True, doc=doc, checksum=request.FILES['file'].hash).count() > 0:
messages.add_message(request, messages.ERROR, _('File already exists: %s') % request.FILES['file'].name)
if request.GET.get('Ajax') == '1':
return HttpResponse('OK')
return HttpResponseRedirect('/docs/view/%s/' % doc.id)
f = docs_files()
f.name = request.FILES['file'].name
f.size = request.FILES['file'].size
f.checksum = request.FILES['file'].hash
f.content_type = request.FILES['file'].content_type
f.doc_id = doc.id
f.public = True
f.save(user=request.user)
#add_history(request, tic, 5, request.FILES['file'].name)
dest = get_doc_files_folder()
if not os.path.exists(dest):
os.makedirs(dest)
with open('%s%s.dat' % (dest, f.id), 'wb+') as destination:
for chunk in request.FILES['file'].chunks():
destination.write(chunk)
if 'pdf' in f.content_type:
convertPDFtoImg('%s/%s.dat' % (dest, f.id), '%s/%s.preview' % (dest, f.id))
else:
if 'image' not in f.content_type and isPreviewable(f.content_type):
tmp = convertOfficeTpPDF('%s/%s.dat' % (dest, f.id))
convertPDFtoImg(tmp, '%s/%s.preview' % (dest, f.id))
if os.path.isfile(tmp):
os.unlink(tmp)
return HttpResponseRedirect('/docs/view/%s/' % doc.pk)
else:
msg = unicode(form.errors['file'])
msg = re.sub('<[^<]+?>', '', msg)
messages.add_message(request, messages.ERROR, msg)
if request.GET.get('Ajax') == '1':
return HttpResponse('OK')
return HttpResponseRedirect('/docs/view/%s/' % doc.pk)
else:
form = UploadFileForm()
return render(request, 'docs/file.html', {'docid': doc, 'layout': 'horizontal', 'form': form})
elif mode == 'delfile':
file = docs_files.objects.get(pk=request.GET['fileid'], doc=doc)
file.delete(user=request.user)
#add_history(request, tic, 8, file.name)
return HttpResponseRedirect('/docs/view/%s/#files' % doc.pk)
def action(request, mode, ticket):
mod_path, cls_name = settings.TICKET_CLASS.rsplit('.', 1)
mod_path = mod_path.split('.').pop(0)
tic = apps.get_model(mod_path, cls_name).objects.get(pk=ticket)
if hasattr(settings, 'KEEP_IT_SIMPLE') and settings.KEEP_IT_SIMPLE:
keep_it_simple = True
else:
keep_it_simple = False
if mode == 'view':
if request.method == 'POST':
form = CommentForm(request.POST)
if form.is_valid():
com = tickets_comments()
com.comment = form.cleaned_data['comment']
com.ticket_id = ticket
com.action = 6
com.save(user=request.user)
check_references(request, com)
touch_ticket(request.user, ticket)
add_history(request, tic, 6, com.comment)
mail_comment(request, com.pk)
else:
if 'resolution' in request.POST:
if request.POST['resolution'] and int(request.POST['resolution']) > 0:
tic.resolution_id = request.POST['resolution']
tic.closed = True
tic.close_date = timezone.now()
tic.state = get_flow_end()
tic.save(user=request.user)
com = tickets_comments()
com.comment = _('ticket closed - resolution: %(resolution)s\n\n%(comment)s') % {'resolution': ticket_resolution.objects.get(pk=request.POST['resolution']).name, 'comment': request.POST.get('close_comment', '')}
com.ticket_id = ticket
com.action = 1
com.save(user=request.user)
check_references(request, com)
touch_ticket(request.user, ticket)
add_history(request, tic, 1, request.POST.get('close_comment', ''))
mail_comment(request, com.pk)
else:
messages.add_message(request, messages.ERROR, _('no resolution selected'))
else:
messages.add_message(request, messages.ERROR, _('comment invalid'))
excludes = []
form = TicketsForm(exclude_list=excludes, is_stuff=request.user.is_staff, user=request.user, instance=tic, customer=request.organisation.id, view_only=True)
close = TicketCloseForm()
reassign = TicketReassignForm(initial={'assigned': tic.assigned_id, 'state': tic.state})
flows = list(ticket_flow_edges.objects.select_related('next').filter(now=tic.state).exclude(next__type=2).values_list('next', flat=True))
flows.append(tic.state_id)
reassign.fields['state'].queryset = reassign.fields['state'].queryset.filter(id__in=flows)
participants = tickets_participants.objects.select_related('user').filter(ticket=ticket)
comments = tickets_comments.objects.select_related('c_user').filter(ticket=ticket).order_by('c_date')
close_allowed = ticket_flow_edges.objects.select_related('next').filter(now=tic.state, next__type=2).count() > 0
files = tickets_files.objects.filter(ticket=ticket, active_record=True)
paginator = Paginator(files, 10)
page = request.GET.get('page')
try:
files_lines = paginator.page(page)
except PageNotAnInteger:
# If page is not an integer, deliver first page.
files_lines = paginator.page(1)
except EmptyPage:
# If page is out of range (e.g. 9999), deliver last page of results.
files_lines = paginator.page(paginator.num_pages)
add_breadcrumbs(request, ticket, '#')
if 'YATSE' in request.GET and 'isUsingYATSE' not in request.session:
request.session['isUsingYATSE'] = True
return render(request, 'tickets/view.html', {'layout': 'horizontal', 'ticket': tic, 'form': form, 'close': close, 'reassign': reassign, 'files': files_lines, 'comments': comments, 'participants': participants, 'close_allowed': close_allowed, 'keep_it_simple': keep_it_simple})
elif mode == 'history':
history = tickets_history.objects.filter(ticket=ticket)
return render(request, 'tickets/history.html', {'layout': 'horizontal', 'ticket': tic, 'history': history, 'keep_it_simple': keep_it_simple})
elif mode == 'reopen':
if tic.closed:
tic.closed = False
tic.state = get_flow_start()
tic.resolution = None
tic.close_date = None
tic.save(user=request.user)
com = tickets_comments()
com.comment = _('ticket reopend - resolution deleted')
com.ticket_id = ticket
com.action = 2
com.save(user=request.user)
check_references(request, com)
touch_ticket(request.user, ticket)
add_history(request, tic, 2, None)
mail_comment(request, com.pk)
return HttpResponseRedirect('/tickets/view/%s/' % ticket)
elif mode == 'reassign':
if not tic.closed:
if 'assigned' in request.POST:
if request.POST['assigned'] and int(request.POST['assigned']) > 0:
old_assigned_user = tic.assigned
old_state = tic.state
tic.assigned_id = request.POST['assigned']
tic.state = ticket_flow.objects.get(pk=request.POST['state'])
tic.save(user=request.user)
newUser = User.objects.get(pk=request.POST['assigned'])
com = tickets_comments()
com.comment = _('ticket reassigned to %(user)s\nstate now: %(state)s\n\n%(comment)s') % {'user': newUser, 'comment': request.POST.get('reassign_comment', ''), 'state': tic.state}
com.ticket_id = ticket
com.action = 7
com.save(user=request.user)
check_references(request, com)
touch_ticket(request.user, ticket)
if request.POST['assigned']:
touch_ticket(newUser, ticket)
history_data = {
'old': {'comment': '', 'assigned': str(old_assigned_user), 'state': str(old_state)},
'new': {'comment': request.POST.get('reassign_comment', ''), 'assigned': str(User.objects.get(pk=request.POST['assigned'])), 'state': str(tic.state)}
}
add_history(request, tic, 7, history_data)
mail_comment(request, com.pk)
else:
messages.add_message(request, messages.ERROR, _('missing assigned user'))
return HttpResponseRedirect('/tickets/view/%s/' % ticket)
elif mode == 'edit' or (mode == 'simple' and (not tic.keep_it_simple or tic.closed) and keep_it_simple):
excludes = ['resolution']
if request.method == 'POST':
form = TicketsForm(request.POST, exclude_list=excludes, is_stuff=request.user.is_staff, user=request.user, instance=tic, customer=request.organisation.id)
if form.is_valid():
tic = form.save()
if tic.keep_it_simple:
tic.keep_it_simple = False
tic.save(user=request.user)
assigned = form.cleaned_data.get('assigned')
if assigned:
touch_ticket(assigned, tic.pk)
remember_changes(request, form, tic)
touch_ticket(request.user, tic.pk)
mail_ticket(request, tic.pk, form)
return HttpResponseRedirect('/tickets/view/%s/' % ticket)
else:
form = TicketsForm(exclude_list=excludes, is_stuff=request.user.is_staff, user=request.user, instance=tic, customer=request.organisation.id)
if 'state' in form.fields:
form.fields['state'].queryset = form.fields['state'].queryset.exclude(type=2)
return render(request, 'tickets/edit.html', {'ticket': tic, 'layout': 'horizontal', 'form': form})
elif mode == 'simple':
if request.method == 'POST':
form = SimpleTickets(request.POST, initial={
'caption': tic.caption,
'description': tic.description,
'priority': tic.priority,
'assigned': tic.assigned
})
if form.is_valid():
cd = form.cleaned_data
tic.caption = cd['caption']
tic.description = cd['description']
tic.priority = cd['priority']
tic.assigned = cd['assigned']
tic.deadline = cd['deadline']
tic.save(user=request.user)
if cd['assigned']:
touch_ticket(cd['assigned'], tic.pk)
remember_changes(request, form, tic)
touch_ticket(request.user, tic.pk)
mail_ticket(request, tic.pk, form)
return HttpResponseRedirect('/tickets/view/%s/' % ticket)
else:
form = SimpleTickets(initial={
'caption': tic.caption,
'description': tic.description,
'priority': tic.priority,
'assigned': tic.assigned,
'deadline': tic.deadline,
})
return render(request, 'tickets/edit.html', {'ticket': tic, 'layout': 'horizontal', 'form': form, 'mode': mode})
elif mode == 'download':
fileid = request.GET.get('file', -1)
file_data = tickets_files.objects.get(id=fileid, ticket=ticket)
src = '%s%s.dat' % (settings.FILE_UPLOAD_PATH, fileid)
content_type = file_data.content_type
if request.GET.get('preview') == 'yes' and os.path.isfile('%s%s.preview' % (settings.FILE_UPLOAD_PATH, fileid)):
src = '%s%s.preview' % (settings.FILE_UPLOAD_PATH, fileid)
content_type = 'imgae/png'
if request.GET.get('resize', 'no') == 'yes' and ('image' in file_data.content_type or 'pdf' in file_data.content_type):
img = resize_image('%s' % (src), (200, 150), 75)
output = io.BytesIO()
img.save(output, 'PNG')
output.seek(0)
response = StreamingHttpResponse(output, content_type='image/png')
else:
response = StreamingHttpResponse(open('%s' % (src), "rb"), content_type=content_type)
if request.GET.get('preview') == 'yes' and os.path.isfile('%s%s.preview' % (settings.FILE_UPLOAD_PATH, fileid)):
response['Content-Disposition'] = 'attachment;filename=%s' % content_type
else:
response['Content-Disposition'] = 'attachment;filename=%s' % smart_str(file_data.name)
return response
elif mode == 'upload':
if request.method == 'POST':
form = UploadFileForm(request.POST, request.FILES)
if form.is_valid():
if tickets_files.objects.filter(active_record=True, ticket=ticket, checksum=request.FILES['file'].hash).count() > 0:
messages.add_message(request, messages.ERROR, _('File already exists: %s') % request.FILES['file'].name)
if request.GET.get('Ajax') == '1':
return HttpResponse('OK')
return HttpResponseRedirect('/tickets/view/%s/' % ticket)
f = tickets_files()
f.name = request.FILES['file'].name
f.size = request.FILES['file'].size
f.checksum = request.FILES['file'].hash
f.content_type = request.FILES['file'].content_type
f.ticket_id = ticket
f.public = True
f.save(user=request.user)
touch_ticket(request.user, ticket)
add_history(request, tic, 5, request.FILES['file'].name)
mail_file(request, f.pk)
dest = settings.FILE_UPLOAD_PATH
if not os.path.exists(dest):
os.makedirs(dest)
with open('%s%s.dat' % (dest, f.id), 'wb+') as destination:
for chunk in request.FILES['file'].chunks():
destination.write(chunk)
if 'pdf' in f.content_type:
convertPDFtoImg('%s/%s.dat' % (dest, f.id), '%s/%s.preview' % (dest, f.id))
else:
if 'image' not in f.content_type:
tmp = convertOfficeTpPDF('%s/%s.dat' % (dest, f.id))
convertPDFtoImg(tmp, '%s/%s.preview' % (dest, f.id))
os.unlink(tmp)
return HttpResponseRedirect('/tickets/view/%s/' % tic.pk)
else:
msg = unicode(form.errors['file'])
msg = re.sub('<[^<]+?>', '', msg)
messages.add_message(request, messages.ERROR, msg)
if request.GET.get('Ajax') == '1':
return HttpResponse('OK')
return HttpResponseRedirect('/tickets/view/%s/' % ticket)
else:
form = UploadFileForm()
return render(request, 'tickets/file.html', {'ticketid': ticket, 'layout': 'horizontal', 'form': form})
elif mode == 'delfile':
file = tickets_files.objects.get(pk=request.GET['fileid'], ticket=ticket)
file.delete(user=request.user)
touch_ticket(request.user, ticket)
add_history(request, tic, 8, file.name)
return HttpResponseRedirect('/tickets/view/%s/#files' % tic.pk)
elif mode == 'remove':
del_breadcrumbs(request)
return HttpResponse('OK')
def docs_action(request, mode, docid):
doc = docs.objects.get(pk=docid)
if mode == 'view':
form = DocsForm(user=request.user, instance=doc, view_only=True)
add_breadcrumbs(request, docid, '*', caption=doc.caption[:20])
files = docs_files.objects.filter(doc=doc, active_record=True)
paginator = Paginator(files, 10)
page = request.GET.get('page')
try:
files_lines = paginator.page(page)
except PageNotAnInteger:
# If page is not an integer, deliver first page.
files_lines = paginator.page(1)
except EmptyPage:
# If page is out of range (e.g. 9999), deliver last page of results.
files_lines = paginator.page(paginator.num_pages)
return render(request, 'docs/view.html', {'layout': 'horizontal', 'form': form, 'doc': doc, 'files': files_lines})
elif mode == 'edit':
if request.method == 'POST':
form = DocsForm(request.POST, user=request.user, instance=doc)
if form.is_valid():
doc = form.save()
return HttpResponseRedirect('/docs/view/%s/' % doc.pk)
form = DocsForm(user=request.user, instance=doc)
return render(request, 'docs/edit.html', {'layout': 'horizontal', 'form': form, 'doc': doc})
elif mode == 'delete':
doc.delete(user=request.user)
return HttpResponseRedirect('/search/?q=%s&models=yats.docs&models=web.test' % request.session.get('last_fulltextsearch', '*'))
elif mode == 'ticket':
ticket = get_ticket_model()
tic = ticket()
tic.caption = doc.caption
tic.description = doc.text
if hasattr(settings, 'KEEP_IT_SIMPLE_DEFAULT_CUSTOMER') and settings.KEEP_IT_SIMPLE_DEFAULT_CUSTOMER:
if settings.KEEP_IT_SIMPLE_DEFAULT_CUSTOMER == -1:
tic.customer = request.organisation
else:
tic.customer_id = settings.KEEP_IT_SIMPLE_DEFAULT_CUSTOME
if not tic.component_id and hasattr(settings, 'KEEP_IT_SIMPLE_DEFAULT_COMPONENT') and settings.KEEP_IT_SIMPLE_DEFAULT_COMPONENT:
tic.component_id = settings.KEEP_IT_SIMPLE_DEFAULT_COMPONENT
tic.save(user=request.user)
# add ref to doc
com = tickets_comments()
com.comment = _('see §%s') % doc.pk
com.ticket_id = tic
com.action = 3
com.save(user=request.user)
add_breadcrumbs(request, str(tic.pk), '#', caption=tic.caption[:20])
if hasattr(settings, 'KEEP_IT_SIMPLE') and settings.KEEP_IT_SIMPLE:
return HttpResponseRedirect('/tickets/simple/%s/' % tic.pk)
else:
return HttpResponseRedirect('/tickets/edit/%s/' % tic.pk)
elif mode == 'download':
fileid = request.GET.get('file', -1)
file_data = docs_files.objects.get(id=fileid, doc=doc)
src = '%s%s.dat' % (get_doc_files_folder(), fileid)
content_type = file_data.content_type
if request.GET.get('preview') == 'yes' and os.path.isfile('%s%s.preview' % (get_doc_files_folder(), fileid)):
src = '%s%s.preview' % (get_doc_files_folder(), fileid)
content_type = 'imgae/png'
if request.GET.get('resize', 'no') == 'yes' and ('image' in file_data.content_type or 'pdf' in file_data.content_type):
img = resize_image('%s' % (src), (200, 150), 75)
output = io.BytesIO()
img.save(output, 'PNG')
output.seek(0)
response = StreamingHttpResponse(output, content_type='image/png')
else:
response = StreamingHttpResponse(open('%s' % (src), "rb"), content_type=content_type)
if 'noDisposition' not in request.GET:
if request.GET.get('preview') == 'yes' and os.path.isfile('%s%s.preview' % (get_doc_files_folder(), fileid)):
response['Content-Disposition'] = 'attachment;filename=%s' % content_type
else:
response['Content-Disposition'] = 'attachment;filename=%s' % smart_str(file_data.name)
return response
elif mode == 'upload':
if request.method == 'POST':
form = UploadFileForm(request.POST, request.FILES)
if form.is_valid():
if docs_files.objects.filter(active_record=True, doc=doc, checksum=request.FILES['file'].hash).count() > 0:
messages.add_message(request, messages.ERROR, _('File already exists: %s') % request.FILES['file'].name)
if request.GET.get('Ajax') == '1':
return HttpResponse('OK')
return HttpResponseRedirect('/docs/view/%s/' % doc.id)
f = docs_files()
f.name = request.FILES['file'].name
f.size = request.FILES['file'].size
f.checksum = request.FILES['file'].hash
f.content_type = request.FILES['file'].content_type
f.doc_id = doc.id
f.public = True
f.save(user=request.user)
#add_history(request, tic, 5, request.FILES['file'].name)
dest = get_doc_files_folder()
if not os.path.exists(dest):
os.makedirs(dest)
with open('%s%s.dat' % (dest, f.id), 'wb+') as destination:
for chunk in request.FILES['file'].chunks():
destination.write(chunk)
if 'pdf' in f.content_type:
convertPDFtoImg('%s/%s.dat' % (dest, f.id), '%s/%s.preview' % (dest, f.id))
else:
if 'image' not in f.content_type and isPreviewable(f.content_type):
tmp = convertOfficeTpPDF('%s/%s.dat' % (dest, f.id))
convertPDFtoImg(tmp, '%s/%s.preview' % (dest, f.id))
if os.path.isfile(tmp):
os.unlink(tmp)
return HttpResponseRedirect('/docs/view/%s/' % doc.pk)
else:
msg = unicode(form.errors['file'])
msg = re.sub('<[^<]+?>', '', msg)
messages.add_message(request, messages.ERROR, msg)
if request.GET.get('Ajax') == '1':
return HttpResponse('OK')
return HttpResponseRedirect('/docs/view/%s/' % doc.pk)
else:
form = UploadFileForm()
return render(request, 'docs/file.html', {'docid': doc, 'layout': 'horizontal', 'form': form})
elif mode == 'delfile':
file = docs_files.objects.get(pk=request.GET['fileid'], doc=doc)
file.delete(user=request.user)
#add_history(request, tic, 8, file.name)
return HttpResponseRedirect('/docs/view/%s/#files' % doc.pk)