1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
|
from django.shortcuts import get_object_or_404
from django.utils.translation import ugettext_lazy as _
from django.shortcuts import render_to_response
from django.http import HttpResponse
from django.db.models import Q
import models
from django.core.mail import mail_admins
def home(request):
return render_to_response('home.html')
def item(request, selectedid):
p = get_object_or_404(models.Barcode, pk=selectedid.upper())
parentpath = []
temp_parentpath = []
x = p.item
parentpath.append(x)
x = x.parent
while x:
parentpath.append(x)
if x.temp_parent:
x = x.temp_parent
else:
x = x.parent
x = p.item
while x:
temp_parentpath.append(x)
if x.temp_parent:
x = x.temp_parent
else:
x = x.parent
temp_parentpath.reverse()
parentpath.reverse()
parameters = {
"user": request.user,
"id": p.item.id,
"image": p.item.image,
"name": p.item.name,
"codes": p.item.barcodes(),
"description": p.item.description,
"in_use": p.item.inUse,
"parent": p.item.parent,
"temporary_parent": p.item.temp_parent,
"parentpath": parentpath,
"temporary_parentpath": temp_parentpath,
"children": models.Item.objects.filter(Q(parent = p.item.id) | Q(temp_parent = p.item.id)),
"tags": p.item.tag.all(),
"owner": p.item.owner,
}
return render_to_response('item.html', parameters)
def search(request, term):
results = models.Item.objects.filter(Q(name__contains = term) | Q(description__contains = term))
return render_to_response('search.html', {
"term": term,
"results": results
})
def graph(request):
items = models.Item.objects.all()
result = render_to_response('graph.txt', {"items": items})
result['Content-Type'] = "text/plain; charset=utf-8"
return result
def stats(request):
return render_to_response('stats.html', {
"number_of_codes": models.Barcode.objects.count(),
"number_of_items": models.Item.objects.count(),
"number_of_items_with_parent": models.Item.objects.filter(parent__isnull=False).count(),
"number_of_items_without_parent": models.Item.objects.filter(parent__isnull=True).count(),
"max_barcodes_item": models.Item.objects.raw('SELECT inventory_item.*, COUNT(inventory_barcode.item_id) AS number_of_attached_barcodes FROM inventory_item INNER JOIN inventory_barcode ON inventory_barcode.item_id = inventory_item.id GROUP BY inventory_barcode.item_id ORDER BY COUNT(inventory_barcode.item_id) DESC LIMIT 1;')[0],
})
|