| author | Tero Marttila <terom@fixme.fi> |
| Fri, 21 Jan 2011 04:44:30 +0200 | |
| changeset 61 | ce1d012d02fe |
| parent 59 | de6abcbd3c03 |
| permissions | -rw-r--r-- |
| 48 | 1 |
# coding: utf-8 |
2 |
||
3 |
from svv import database as db |
|
4 |
from svv.controllers import PageHandler |
|
5 |
from svv.html import tags as html |
|
6 |
from svv.forms import BaseForm, FormError |
|
7 |
||
8 |
import logging |
|
9 |
||
10 |
log = logging.getLogger('svv.items')
|
|
11 |
||
12 |
class Item (object) : |
|
13 |
""" |
|
14 |
Data-mapping for the items table |
|
15 |
""" |
|
16 |
||
|
59
de6abcbd3c03
items: add inventory-import script, and tweak listing
Tero Marttila <terom@fixme.fi>
parents:
57
diff
changeset
|
17 |
def __init__ (self, name, detail=None, quantity=None, parent=None) : |
|
de6abcbd3c03
items: add inventory-import script, and tweak listing
Tero Marttila <terom@fixme.fi>
parents:
57
diff
changeset
|
18 |
|
|
de6abcbd3c03
items: add inventory-import script, and tweak listing
Tero Marttila <terom@fixme.fi>
parents:
57
diff
changeset
|
19 |
self.name = name |
|
de6abcbd3c03
items: add inventory-import script, and tweak listing
Tero Marttila <terom@fixme.fi>
parents:
57
diff
changeset
|
20 |
self.detail = detail |
|
de6abcbd3c03
items: add inventory-import script, and tweak listing
Tero Marttila <terom@fixme.fi>
parents:
57
diff
changeset
|
21 |
self.quantity = quantity |
|
de6abcbd3c03
items: add inventory-import script, and tweak listing
Tero Marttila <terom@fixme.fi>
parents:
57
diff
changeset
|
22 |
self.parent = parent |
|
de6abcbd3c03
items: add inventory-import script, and tweak listing
Tero Marttila <terom@fixme.fi>
parents:
57
diff
changeset
|
23 |
|
| 48 | 24 |
db.mapper(Item, db.items, properties=dict( |
25 |
# forward ref to parent |
|
26 |
parent = db.relation(Item, remote_side=db.items.c.id, |
|
27 |
backref = db.backref('children', remote_side=db.items.c.parent_id)
|
|
28 |
), |
|
29 |
)) |
|
30 |
||
31 |
||
32 |
class ItemForm (BaseForm) : |
|
33 |
""" |
|
34 |
Form for editing item |
|
35 |
""" |
|
36 |
||
37 |
def __init__ (self, session) : |
|
38 |
""" |
|
39 |
Use given database session for rendering form. |
|
40 |
""" |
|
41 |
||
42 |
super(ItemForm, self).__init__() |
|
43 |
||
44 |
self.session = session |
|
45 |
||
46 |
def defaults (self) : |
|
47 |
self.item_id = None |
|
48 |
self.item_name = None |
|
49 |
self.item_detail = None |
|
50 |
self.item_quantity = None |
|
51 |
||
52 |
self.item_parent_id = None |
|
53 |
||
54 |
def load (self, item) : |
|
55 |
""" |
|
56 |
Load info from existing item for editing |
|
57 |
""" |
|
58 |
||
59 |
self.item_id = item.id |
|
60 |
self.item_name = item.name |
|
61 |
self.item_detail = item.detail |
|
62 |
self.item_quantity = item.quantity |
|
63 |
||
64 |
self.item_parent_id = item.parent.id if item.parent else None |
|
65 |
||
66 |
def render_parent_select (self, name, parent_id) : |
|
67 |
""" |
|
68 |
Render <select> for parent |
|
69 |
""" |
|
70 |
||
71 |
# existing items suitable as parents |
|
72 |
# XXX: currently only top-level items, as a heuristic |
|
73 |
parent_items = self.session.query(Item.id, Item.name).filter(Item.parent == None).all() |
|
74 |
||
75 |
return ( |
|
76 |
# <select> with options and selected= |
|
77 |
self.render_select_input(name, [(0, u"---")] + parent_items, parent_id) |
|
78 |
) |
|
79 |
||
|
53
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
80 |
def render (self, action, legend=u"Laitetiedot", return_url=None) : |
| 48 | 81 |
""" |
82 |
Render <form> HTML |
|
83 |
||
84 |
return_url - URL for reset button |
|
85 |
""" |
|
86 |
||
|
53
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
87 |
return html.form(action=action, method='POST')( |
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
88 |
html.fieldset( |
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
89 |
html.legend(legend), |
| 48 | 90 |
|
|
53
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
91 |
html.ol( |
| 56 | 92 |
self.render_form_field('item_parent', u"Sijainti", u"Missä laite sijaitsee", (
|
|
53
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
93 |
self.render_parent_select('item_parent', self.item_parent_id)
|
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
94 |
)), |
| 48 | 95 |
|
|
53
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
96 |
self.render_form_field('item_name', u"Nimi", u"Lyhyt nimi", (
|
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
97 |
self.render_text_input('item_name', self.item_name)
|
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
98 |
)), |
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
99 |
|
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
100 |
self.render_form_field('item_detail', u"Kuvaus", u"Tarkempi kuvaus", (
|
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
101 |
self.render_text_input('item_detail', self.item_detail, multiline=True)
|
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
102 |
)), |
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
103 |
|
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
104 |
self.render_form_field('item_quantity', u"Kappalemäärä", u"Jos on esim. useampi piuha/adapter, kirjaa niitten määrä; muuten jätä tyhjäksi", (
|
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
105 |
self.render_text_input('item_quantity', self.item_quantity)
|
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
106 |
)), |
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
107 |
|
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
108 |
html.li( |
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
109 |
self.render_submit_button(u"Tallenna"), |
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
110 |
self.render_reset_button(u"Palaa inventaariin", return_url) if return_url else None, |
| 48 | 111 |
), |
112 |
), |
|
113 |
), |
|
114 |
) |
|
115 |
||
116 |
def process (self, data) : |
|
117 |
""" |
|
118 |
Process incoming POST data |
|
119 |
""" |
|
120 |
||
121 |
# bind |
|
122 |
self.data = data |
|
123 |
||
124 |
self.do_delete = self.process_action_field('delete')
|
|
125 |
||
126 |
if not self.do_delete : |
|
127 |
try : |
|
128 |
# XXX: self.process_id_field? |
|
129 |
self.item_parent_id = self.process_integer_field('item_parent')
|
|
130 |
||
131 |
except FormError, e : |
|
132 |
self.fail_field(e, 'item_parent') |
|
133 |
||
134 |
try : |
|
135 |
self.item_name = self.process_text_field('item_name', required=True)
|
|
136 |
||
137 |
except FormError, e : |
|
138 |
self.fail_field(e, 'item_name') |
|
139 |
||
140 |
try : |
|
141 |
self.item_detail = self.process_text_field('item_detail')
|
|
142 |
||
143 |
except FormError, e : |
|
144 |
self.fail_field(e, 'item_detail') |
|
145 |
||
146 |
try : |
|
147 |
self.item_quantity = self.process_integer_field('item_quantity')
|
|
148 |
||
149 |
except FormError, e : |
|
150 |
self.fail_field(e, 'item_quantity') |
|
151 |
||
152 |
||
153 |
# ok? |
|
154 |
return not self.errors |
|
155 |
||
156 |
class DeleteItemForm (BaseForm) : |
|
157 |
""" |
|
158 |
Display a list of items to delete, and confirm |
|
159 |
""" |
|
160 |
||
161 |
def __init__ (self, session) : |
|
162 |
""" |
|
163 |
Use given database session for rendering form. |
|
164 |
""" |
|
165 |
||
166 |
super(DeleteItemForm, self).__init__() |
|
167 |
||
168 |
self.session = session |
|
169 |
||
170 |
# list of items to delete |
|
171 |
self.items = [] |
|
172 |
||
|
53
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
173 |
def load (self, items) : |
| 48 | 174 |
""" |
|
53
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
175 |
Init set of items to delete |
| 48 | 176 |
""" |
177 |
||
|
53
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
178 |
self.items = items |
| 48 | 179 |
|
|
53
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
180 |
def render_items_list (self, name, items, visible=None) : |
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
181 |
""" |
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
182 |
Render list of items to delete. |
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
183 |
|
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
184 |
visible - display list of items in addition the rendering the <input>'s |
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
185 |
""" |
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
186 |
|
|
55
433842c04ab1
items: inventory table #id links, fix up DeleteItemForm
Tero Marttila <terom@fixme.fi>
parents:
53
diff
changeset
|
187 |
|
|
433842c04ab1
items: inventory table #id links, fix up DeleteItemForm
Tero Marttila <terom@fixme.fi>
parents:
53
diff
changeset
|
188 |
def render_items (items, with_list, with_input) : |
|
433842c04ab1
items: inventory table #id links, fix up DeleteItemForm
Tero Marttila <terom@fixme.fi>
parents:
53
diff
changeset
|
189 |
""" Item <ul> or <input>s """ |
|
433842c04ab1
items: inventory table #id links, fix up DeleteItemForm
Tero Marttila <terom@fixme.fi>
parents:
53
diff
changeset
|
190 |
|
|
53
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
191 |
if not items : |
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
192 |
# blank |
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
193 |
return None |
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
194 |
|
|
55
433842c04ab1
items: inventory table #id links, fix up DeleteItemForm
Tero Marttila <terom@fixme.fi>
parents:
53
diff
changeset
|
195 |
elif with_list : |
|
53
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
196 |
# nested list |
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
197 |
return html.ul( |
|
55
433842c04ab1
items: inventory table #id links, fix up DeleteItemForm
Tero Marttila <terom@fixme.fi>
parents:
53
diff
changeset
|
198 |
render_item(item, True, with_input) for item in items |
|
53
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
199 |
) |
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
200 |
|
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
201 |
else : |
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
202 |
# just the controls |
|
55
433842c04ab1
items: inventory table #id links, fix up DeleteItemForm
Tero Marttila <terom@fixme.fi>
parents:
53
diff
changeset
|
203 |
return [render_item(item, False, with_input) for item in items] |
|
53
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
204 |
|
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
205 |
|
|
55
433842c04ab1
items: inventory table #id links, fix up DeleteItemForm
Tero Marttila <terom@fixme.fi>
parents:
53
diff
changeset
|
206 |
def render_item (item, with_list, with_input) : |
|
433842c04ab1
items: inventory table #id links, fix up DeleteItemForm
Tero Marttila <terom@fixme.fi>
parents:
53
diff
changeset
|
207 |
""" Item <li> or <input> """ |
|
433842c04ab1
items: inventory table #id links, fix up DeleteItemForm
Tero Marttila <terom@fixme.fi>
parents:
53
diff
changeset
|
208 |
|
|
433842c04ab1
items: inventory table #id links, fix up DeleteItemForm
Tero Marttila <terom@fixme.fi>
parents:
53
diff
changeset
|
209 |
if with_input : |
|
433842c04ab1
items: inventory table #id links, fix up DeleteItemForm
Tero Marttila <terom@fixme.fi>
parents:
53
diff
changeset
|
210 |
# the form field |
|
433842c04ab1
items: inventory table #id links, fix up DeleteItemForm
Tero Marttila <terom@fixme.fi>
parents:
53
diff
changeset
|
211 |
input = html.input(type='hidden', name='items', value=item.id), |
|
433842c04ab1
items: inventory table #id links, fix up DeleteItemForm
Tero Marttila <terom@fixme.fi>
parents:
53
diff
changeset
|
212 |
else : |
|
433842c04ab1
items: inventory table #id links, fix up DeleteItemForm
Tero Marttila <terom@fixme.fi>
parents:
53
diff
changeset
|
213 |
# no field |
|
433842c04ab1
items: inventory table #id links, fix up DeleteItemForm
Tero Marttila <terom@fixme.fi>
parents:
53
diff
changeset
|
214 |
input = None |
|
433842c04ab1
items: inventory table #id links, fix up DeleteItemForm
Tero Marttila <terom@fixme.fi>
parents:
53
diff
changeset
|
215 |
|
|
433842c04ab1
items: inventory table #id links, fix up DeleteItemForm
Tero Marttila <terom@fixme.fi>
parents:
53
diff
changeset
|
216 |
if with_list : |
|
53
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
217 |
return html.li( |
|
55
433842c04ab1
items: inventory table #id links, fix up DeleteItemForm
Tero Marttila <terom@fixme.fi>
parents:
53
diff
changeset
|
218 |
input, |
|
53
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
219 |
|
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
220 |
item.name if visible else None, |
|
55
433842c04ab1
items: inventory table #id links, fix up DeleteItemForm
Tero Marttila <terom@fixme.fi>
parents:
53
diff
changeset
|
221 |
|
|
433842c04ab1
items: inventory table #id links, fix up DeleteItemForm
Tero Marttila <terom@fixme.fi>
parents:
53
diff
changeset
|
222 |
# don't recurse inputs |
|
433842c04ab1
items: inventory table #id links, fix up DeleteItemForm
Tero Marttila <terom@fixme.fi>
parents:
53
diff
changeset
|
223 |
render_items(item.children, with_list, with_input=False), |
|
53
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
224 |
) |
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
225 |
else : |
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
226 |
# just the input |
|
55
433842c04ab1
items: inventory table #id links, fix up DeleteItemForm
Tero Marttila <terom@fixme.fi>
parents:
53
diff
changeset
|
227 |
return input |
|
433842c04ab1
items: inventory table #id links, fix up DeleteItemForm
Tero Marttila <terom@fixme.fi>
parents:
53
diff
changeset
|
228 |
|
|
433842c04ab1
items: inventory table #id links, fix up DeleteItemForm
Tero Marttila <terom@fixme.fi>
parents:
53
diff
changeset
|
229 |
## Render <div> or <input>s |
|
53
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
230 |
if visible : |
|
55
433842c04ab1
items: inventory table #id links, fix up DeleteItemForm
Tero Marttila <terom@fixme.fi>
parents:
53
diff
changeset
|
231 |
# <div> with nested <li>s |
|
53
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
232 |
return html.div(class_='value')( |
|
55
433842c04ab1
items: inventory table #id links, fix up DeleteItemForm
Tero Marttila <terom@fixme.fi>
parents:
53
diff
changeset
|
233 |
render_items(items, with_list=True, with_input=True), |
| 48 | 234 |
) |
|
55
433842c04ab1
items: inventory table #id links, fix up DeleteItemForm
Tero Marttila <terom@fixme.fi>
parents:
53
diff
changeset
|
235 |
|
|
53
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
236 |
else : |
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
237 |
# just the <input>s |
|
55
433842c04ab1
items: inventory table #id links, fix up DeleteItemForm
Tero Marttila <terom@fixme.fi>
parents:
53
diff
changeset
|
238 |
return render_items(items, with_list=False, with_input=True) |
| 48 | 239 |
|
|
53
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
240 |
def render (self, legend=None, delete_action=None, confirm_action=None, return_url=None, item_listing=None) : |
| 48 | 241 |
""" |
242 |
Render form with list of target items, and a confirm button |
|
|
53
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
243 |
|
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
244 |
legend - form title |
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
245 |
delete_action - URL for initial confirm stage submit |
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
246 |
confirm_action - URL for final delete stage submit |
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
247 |
reutrn_url - URL for cancel button |
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
248 |
item_listing - display recursive item listing for confirmation |
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
249 |
|
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
250 |
Supply either delete_action or confirm_action, but not both |
| 48 | 251 |
""" |
252 |
||
|
53
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
253 |
action = delete_action or confirm_action |
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
254 |
|
| 48 | 255 |
return html.form(action=action, method='POST')( |
256 |
html.fieldset( |
|
|
53
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
257 |
html.legend(legend), |
| 48 | 258 |
|
|
55
433842c04ab1
items: inventory table #id links, fix up DeleteItemForm
Tero Marttila <terom@fixme.fi>
parents:
53
diff
changeset
|
259 |
# raw field with just the <input>s |
|
433842c04ab1
items: inventory table #id links, fix up DeleteItemForm
Tero Marttila <terom@fixme.fi>
parents:
53
diff
changeset
|
260 |
(self.render_items_list('items', self.items, visible=False)) if not item_listing else None,
|
|
433842c04ab1
items: inventory table #id links, fix up DeleteItemForm
Tero Marttila <terom@fixme.fi>
parents:
53
diff
changeset
|
261 |
|
| 48 | 262 |
html.ol( |
|
55
433842c04ab1
items: inventory table #id links, fix up DeleteItemForm
Tero Marttila <terom@fixme.fi>
parents:
53
diff
changeset
|
263 |
# full UI field |
|
433842c04ab1
items: inventory table #id links, fix up DeleteItemForm
Tero Marttila <terom@fixme.fi>
parents:
53
diff
changeset
|
264 |
(self.render_form_field('items', u"Poistettavat laitteet", u"Kaikki listatut laitteet poistetaan inventaarista", (
|
|
433842c04ab1
items: inventory table #id links, fix up DeleteItemForm
Tero Marttila <terom@fixme.fi>
parents:
53
diff
changeset
|
265 |
self.render_items_list('items', self.items, visible=True)
|
|
433842c04ab1
items: inventory table #id links, fix up DeleteItemForm
Tero Marttila <terom@fixme.fi>
parents:
53
diff
changeset
|
266 |
)) if item_listing else None), |
| 48 | 267 |
|
268 |
html.li( |
|
|
53
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
269 |
self.render_submit_button(u"Poista") if delete_action else None, |
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
270 |
self.render_submit_button(u"Varmista", 'confirm') if confirm_action else None, |
| 48 | 271 |
|
|
53
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
272 |
self.render_reset_button(u"Peruuta", return_url) if return_url else None, |
| 48 | 273 |
), |
274 |
) |
|
275 |
) |
|
276 |
) |
|
277 |
||
278 |
def process_items_list (self, name) : |
|
279 |
""" |
|
280 |
Uses the incoming list of id's to build the list of Item's to delete. |
|
281 |
""" |
|
282 |
||
283 |
# incoming ids |
|
284 |
item_ids = self.process_list_field('items', type=int)
|
|
285 |
||
286 |
# look up |
|
287 |
items = self.session.query(Item).filter(Item.id.in_(item_ids)).all() |
|
288 |
||
289 |
# make sure they all exist |
|
290 |
found = [item_id for item_id in item_ids if item_id in set(item.id for item in items)] |
|
291 |
||
292 |
if set(found) != set(item_ids) : |
|
293 |
raise FormError(name, found, "Some items were not found") |
|
294 |
||
295 |
if not items : |
|
296 |
raise FormError(name, [], "No items were given") |
|
297 |
||
298 |
# ok |
|
299 |
return items |
|
300 |
||
301 |
def process (self, data) : |
|
302 |
""" |
|
303 |
Look up list of Item's to delete. |
|
304 |
||
305 |
Returns True if the delete is confirmed, False otherwise. |
|
306 |
""" |
|
307 |
||
308 |
# bind |
|
309 |
self.data = data |
|
310 |
||
311 |
# load items |
|
312 |
try : |
|
313 |
self.items = self.process_items_list('items')
|
|
314 |
||
315 |
except FormError, e : |
|
316 |
self.fail_field(e, 'items') |
|
317 |
||
318 |
# confirm? |
|
319 |
confirm = self.process_action_field('confirm')
|
|
320 |
||
321 |
return not self.errors and confirm |
|
322 |
||
323 |
class ItemView (PageHandler) : |
|
324 |
""" |
|
325 |
Display/edit info for a single item |
|
326 |
""" |
|
327 |
||
328 |
def update (self, item, form) : |
|
329 |
""" |
|
330 |
Update item data from form |
|
331 |
""" |
|
332 |
||
333 |
# lookup |
|
334 |
item.parent = self.session.query(Item).get(form.item_parent_id) |
|
335 |
||
336 |
# modify |
|
337 |
item.name = form.item_name |
|
338 |
item.detail = form.item_detail |
|
339 |
item.quantity = form.item_quantity |
|
340 |
||
341 |
# update |
|
342 |
self.session.commit() |
|
343 |
||
344 |
def process (self, id) : |
|
345 |
""" |
|
346 |
Update item data if POST'd |
|
347 |
""" |
|
348 |
||
349 |
# db |
|
350 |
self.session = self.app.session() |
|
351 |
||
352 |
# item in concern |
|
353 |
self.item = self.session.query(Item).get(id) |
|
354 |
||
355 |
# form |
|
356 |
self.form = ItemForm(self.session) |
|
357 |
self.form.load(self.item) |
|
358 |
||
359 |
# process? |
|
360 |
if self.POST : |
|
361 |
if self.form.process(self.POST) : |
|
362 |
# update |
|
363 |
self.update(self.item, self.form) |
|
364 |
||
365 |
# ok, done with item, redirect to full list view... |
|
366 |
return self.redirect_for(InventoryView, fragment=('item-%d' % self.item.id))
|
|
367 |
||
368 |
else : |
|
369 |
# re-render form |
|
370 |
return |
|
371 |
||
|
53
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
372 |
def render_subitems_table (self, subitems) : |
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
373 |
""" |
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
374 |
Render listing of child items in this item |
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
375 |
""" |
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
376 |
|
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
377 |
return ItemTable(self).render(subitems, parent=self.item) |
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
378 |
|
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
379 |
|
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
380 |
def render_delete_form (self) : |
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
381 |
""" |
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
382 |
Render delete form for this item |
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
383 |
""" |
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
384 |
|
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
385 |
form = DeleteItemForm(self.session) |
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
386 |
form.load([self.item]) |
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
387 |
|
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
388 |
return form.render( |
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
389 |
legend = u"Poistaminen", |
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
390 |
|
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
391 |
delete_action = self.url_for(DeleteItemView), |
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
392 |
|
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
393 |
item_listing = False, |
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
394 |
) |
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
395 |
|
| 48 | 396 |
def render_content (self, id) : |
397 |
""" |
|
398 |
View item's info |
|
399 |
""" |
|
|
53
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
400 |
|
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
401 |
# ourselves |
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
402 |
item = self.item |
| 48 | 403 |
|
|
53
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
404 |
# items in this item |
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
405 |
subitems = item.children |
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
406 |
|
| 48 | 407 |
return ( |
|
53
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
408 |
html.h1("(#%d) %s" % (item.id, item.name)),
|
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
409 |
|
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
410 |
html.h3( |
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
411 |
html.raw(u"Sijaitsee %s:ssa" % ( |
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
412 |
html.a(href=self.url_for(ItemView, id=item.parent.id))(item.parent.name) |
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
413 |
)), |
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
414 |
) if item.parent else None, |
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
415 |
|
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
416 |
self.render_subitems_table(subitems) if subitems else None, |
| 48 | 417 |
|
418 |
self.form.render( |
|
419 |
action = self.url_for(ItemView, id=id), |
|
420 |
return_url = self.url_for(InventoryView), |
|
421 |
), |
|
|
53
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
422 |
|
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
423 |
# delete form |
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
424 |
self.render_delete_form(), |
| 48 | 425 |
) |
426 |
||
427 |
class NewItemView (PageHandler) : |
|
428 |
""" |
|
429 |
Create new item |
|
430 |
""" |
|
431 |
||
432 |
def create (self, form) : |
|
433 |
""" |
|
434 |
Create and return new item from ItemForm data. |
|
435 |
""" |
|
436 |
||
437 |
item = Item() |
|
438 |
||
439 |
# validate and lookup parent |
|
440 |
item.parent = self.session.query(Item).get(form.item_parent_id) |
|
441 |
||
442 |
# store |
|
443 |
item.name = form.item_name |
|
444 |
item.detail = form.item_detail |
|
445 |
item.quantity = form.item_quantity |
|
446 |
||
447 |
# insert |
|
448 |
self.session.add(item) |
|
449 |
self.session.commit() |
|
450 |
||
451 |
# ok |
|
452 |
return item |
|
453 |
||
454 |
def process (self) : |
|
455 |
# db |
|
456 |
self.session = self.app.session() |
|
457 |
||
458 |
self.form = ItemForm(self.session) |
|
459 |
||
460 |
# load POST |
|
461 |
if self.POST : |
|
462 |
if self.form.process(self.POST) : |
|
463 |
# create |
|
464 |
item = self.create(self.form) |
|
465 |
||
466 |
# redirect to full list view... |
|
467 |
return self.redirect_for(InventoryView, fragment=('item-%d' % item.id))
|
|
468 |
||
469 |
else : |
|
470 |
# fail, just render... |
|
471 |
return |
|
472 |
||
473 |
else : |
|
474 |
# render blank form |
|
475 |
self.form.defaults() |
|
476 |
||
477 |
def render_content (self) : |
|
478 |
""" |
|
479 |
Render the proecss()'d form |
|
480 |
""" |
|
481 |
||
482 |
return ( |
|
| 57 | 483 |
self.form.render(action=self.url_for(NewItemView), legend=u"Lisää uusi") |
| 48 | 484 |
) |
485 |
||
486 |
class DeleteItemView (PageHandler) : |
|
487 |
""" |
|
488 |
Confirm deletion of items. |
|
489 |
""" |
|
490 |
||
491 |
def delete (self, form) : |
|
492 |
""" |
|
493 |
Delete items from form |
|
494 |
""" |
|
495 |
||
496 |
# list of root Item's to delete, along with children |
|
497 |
items = form.items |
|
498 |
||
499 |
for item in items : |
|
|
55
433842c04ab1
items: inventory table #id links, fix up DeleteItemForm
Tero Marttila <terom@fixme.fi>
parents:
53
diff
changeset
|
500 |
# XXX: we shouldn't actually DELETE these; rather, mark them as removed |
|
433842c04ab1
items: inventory table #id links, fix up DeleteItemForm
Tero Marttila <terom@fixme.fi>
parents:
53
diff
changeset
|
501 |
# messes up existing orders like this... |
| 48 | 502 |
self.session.delete(item) |
503 |
||
504 |
# ok |
|
505 |
self.session.commit() |
|
506 |
||
507 |
def process (self) : |
|
508 |
# db |
|
509 |
self.session = self.app.session() |
|
510 |
||
511 |
# form |
|
512 |
self.form = DeleteItemForm(self.session) |
|
513 |
||
514 |
# process |
|
515 |
if self.form.process(self.POST) : |
|
516 |
# delete |
|
517 |
self.delete(self.form) |
|
518 |
||
519 |
# redirect back |
|
520 |
return self.redirect_for(InventoryView) |
|
521 |
||
522 |
else : |
|
523 |
# render |
|
524 |
pass |
|
525 |
||
526 |
def render_content (self) : |
|
527 |
return ( |
|
|
53
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
528 |
self.form.render( |
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
529 |
legend = u"Poistettavat laitteet", |
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
530 |
|
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
531 |
confirm_action = self.url_for(DeleteItemView), |
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
532 |
|
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
533 |
return_url = self.url_for(InventoryView), |
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
534 |
|
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
535 |
item_listing = True, |
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
536 |
) |
| 48 | 537 |
) |
538 |
||
|
53
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
539 |
class ItemTable (object) : |
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
540 |
""" |
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
541 |
Table of items |
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
542 |
""" |
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
543 |
|
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
544 |
def __init__ (self, handler) : |
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
545 |
""" |
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
546 |
handler - the AppHandler we are running under, used for url_for etc. |
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
547 |
""" |
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
548 |
|
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
549 |
self.handler = handler |
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
550 |
|
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
551 |
def url_for (self, *args, **kwargs) : |
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
552 |
""" |
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
553 |
Proxy to handler |
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
554 |
""" |
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
555 |
|
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
556 |
return self.handler.url_for(*args, **kwargs) |
|
59
de6abcbd3c03
items: add inventory-import script, and tweak listing
Tero Marttila <terom@fixme.fi>
parents:
57
diff
changeset
|
557 |
|
|
de6abcbd3c03
items: add inventory-import script, and tweak listing
Tero Marttila <terom@fixme.fi>
parents:
57
diff
changeset
|
558 |
def render_rows (self, items, parent=None) : |
|
de6abcbd3c03
items: add inventory-import script, and tweak listing
Tero Marttila <terom@fixme.fi>
parents:
57
diff
changeset
|
559 |
""" |
|
de6abcbd3c03
items: add inventory-import script, and tweak listing
Tero Marttila <terom@fixme.fi>
parents:
57
diff
changeset
|
560 |
Render induvidual rows |
|
de6abcbd3c03
items: add inventory-import script, and tweak listing
Tero Marttila <terom@fixme.fi>
parents:
57
diff
changeset
|
561 |
""" |
|
de6abcbd3c03
items: add inventory-import script, and tweak listing
Tero Marttila <terom@fixme.fi>
parents:
57
diff
changeset
|
562 |
|
|
de6abcbd3c03
items: add inventory-import script, and tweak listing
Tero Marttila <terom@fixme.fi>
parents:
57
diff
changeset
|
563 |
for row, item in enumerate(items) : |
|
de6abcbd3c03
items: add inventory-import script, and tweak listing
Tero Marttila <terom@fixme.fi>
parents:
57
diff
changeset
|
564 |
yield html.tr(id=('item-%d' % item.id), class_=('alternate' if row % 2 else None))(
|
|
de6abcbd3c03
items: add inventory-import script, and tweak listing
Tero Marttila <terom@fixme.fi>
parents:
57
diff
changeset
|
565 |
html.td( |
|
de6abcbd3c03
items: add inventory-import script, and tweak listing
Tero Marttila <terom@fixme.fi>
parents:
57
diff
changeset
|
566 |
html.a(href=self.url_for(InventoryView, fragment=('item-%d' % item.id)))(
|
|
de6abcbd3c03
items: add inventory-import script, and tweak listing
Tero Marttila <terom@fixme.fi>
parents:
57
diff
changeset
|
567 |
u'#%d' % item.id |
|
de6abcbd3c03
items: add inventory-import script, and tweak listing
Tero Marttila <terom@fixme.fi>
parents:
57
diff
changeset
|
568 |
) |
|
de6abcbd3c03
items: add inventory-import script, and tweak listing
Tero Marttila <terom@fixme.fi>
parents:
57
diff
changeset
|
569 |
), |
|
de6abcbd3c03
items: add inventory-import script, and tweak listing
Tero Marttila <terom@fixme.fi>
parents:
57
diff
changeset
|
570 |
|
|
de6abcbd3c03
items: add inventory-import script, and tweak listing
Tero Marttila <terom@fixme.fi>
parents:
57
diff
changeset
|
571 |
( |
|
de6abcbd3c03
items: add inventory-import script, and tweak listing
Tero Marttila <terom@fixme.fi>
parents:
57
diff
changeset
|
572 |
html.td( |
|
de6abcbd3c03
items: add inventory-import script, and tweak listing
Tero Marttila <terom@fixme.fi>
parents:
57
diff
changeset
|
573 |
html.a(href=self.url_for(ItemView, id=item.parent.id))( |
|
de6abcbd3c03
items: add inventory-import script, and tweak listing
Tero Marttila <terom@fixme.fi>
parents:
57
diff
changeset
|
574 |
item.parent.name |
|
de6abcbd3c03
items: add inventory-import script, and tweak listing
Tero Marttila <terom@fixme.fi>
parents:
57
diff
changeset
|
575 |
) if item.parent else None |
|
de6abcbd3c03
items: add inventory-import script, and tweak listing
Tero Marttila <terom@fixme.fi>
parents:
57
diff
changeset
|
576 |
), |
|
de6abcbd3c03
items: add inventory-import script, and tweak listing
Tero Marttila <terom@fixme.fi>
parents:
57
diff
changeset
|
577 |
) if not parent else None, |
|
de6abcbd3c03
items: add inventory-import script, and tweak listing
Tero Marttila <terom@fixme.fi>
parents:
57
diff
changeset
|
578 |
|
|
de6abcbd3c03
items: add inventory-import script, and tweak listing
Tero Marttila <terom@fixme.fi>
parents:
57
diff
changeset
|
579 |
html.td( |
|
de6abcbd3c03
items: add inventory-import script, and tweak listing
Tero Marttila <terom@fixme.fi>
parents:
57
diff
changeset
|
580 |
html.a(href=self.url_for(ItemView, id=item.id))( |
|
de6abcbd3c03
items: add inventory-import script, and tweak listing
Tero Marttila <terom@fixme.fi>
parents:
57
diff
changeset
|
581 |
item.name |
|
de6abcbd3c03
items: add inventory-import script, and tweak listing
Tero Marttila <terom@fixme.fi>
parents:
57
diff
changeset
|
582 |
) |
|
de6abcbd3c03
items: add inventory-import script, and tweak listing
Tero Marttila <terom@fixme.fi>
parents:
57
diff
changeset
|
583 |
), |
|
de6abcbd3c03
items: add inventory-import script, and tweak listing
Tero Marttila <terom@fixme.fi>
parents:
57
diff
changeset
|
584 |
|
|
de6abcbd3c03
items: add inventory-import script, and tweak listing
Tero Marttila <terom@fixme.fi>
parents:
57
diff
changeset
|
585 |
html.td( |
|
de6abcbd3c03
items: add inventory-import script, and tweak listing
Tero Marttila <terom@fixme.fi>
parents:
57
diff
changeset
|
586 |
item.detail |
|
de6abcbd3c03
items: add inventory-import script, and tweak listing
Tero Marttila <terom@fixme.fi>
parents:
57
diff
changeset
|
587 |
), |
|
de6abcbd3c03
items: add inventory-import script, and tweak listing
Tero Marttila <terom@fixme.fi>
parents:
57
diff
changeset
|
588 |
|
|
de6abcbd3c03
items: add inventory-import script, and tweak listing
Tero Marttila <terom@fixme.fi>
parents:
57
diff
changeset
|
589 |
html.td( |
|
de6abcbd3c03
items: add inventory-import script, and tweak listing
Tero Marttila <terom@fixme.fi>
parents:
57
diff
changeset
|
590 |
"%d kpl" % item.quantity if item.quantity else None |
|
de6abcbd3c03
items: add inventory-import script, and tweak listing
Tero Marttila <terom@fixme.fi>
parents:
57
diff
changeset
|
591 |
), |
|
de6abcbd3c03
items: add inventory-import script, and tweak listing
Tero Marttila <terom@fixme.fi>
parents:
57
diff
changeset
|
592 |
) |
|
53
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
593 |
|
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
594 |
def render (self, items, parent=None) : |
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
595 |
""" |
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
596 |
Render table for given set of items. If parent is given, those items are assumed to be the children of that |
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
597 |
item. |
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
598 |
""" |
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
599 |
|
|
59
de6abcbd3c03
items: add inventory-import script, and tweak listing
Tero Marttila <terom@fixme.fi>
parents:
57
diff
changeset
|
600 |
return html.table(class_='with-borders')( |
|
53
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
601 |
html.caption( |
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
602 |
u"Kalustolistaus", |
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
603 |
( |
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
604 |
html.a(href=self.url_for(ItemView, id=parent.id))( |
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
605 |
parent.name |
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
606 |
) if parent else None |
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
607 |
), |
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
608 |
), |
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
609 |
|
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
610 |
html.thead( |
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
611 |
html.tr( |
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
612 |
html.th(title) for title in ( |
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
613 |
u"#ID", |
| 56 | 614 |
u"Sijainti" if not parent else None, |
|
53
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
615 |
u"Nimi", |
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
616 |
u"Kuvaus", |
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
617 |
u"Määrä", |
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
618 |
) if title |
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
619 |
), |
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
620 |
), |
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
621 |
|
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
622 |
html.tbody( |
|
59
de6abcbd3c03
items: add inventory-import script, and tweak listing
Tero Marttila <terom@fixme.fi>
parents:
57
diff
changeset
|
623 |
self.render_rows(items, parent) |
|
53
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
624 |
) |
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
625 |
) |
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
626 |
|
|
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
627 |
|
| 48 | 628 |
class InventoryView (PageHandler) : |
629 |
""" |
|
630 |
Display overview of all items |
|
631 |
""" |
|
632 |
||
633 |
def process (self) : |
|
634 |
# db |
|
635 |
self.session = self.app.session() |
|
636 |
||
637 |
def render_item_table (self) : |
|
638 |
""" |
|
639 |
Render HTML for full <table> of all items, sorted heirarchially (by parent) |
|
640 |
""" |
|
641 |
||
642 |
# listing of inventory items |
|
|
59
de6abcbd3c03
items: add inventory-import script, and tweak listing
Tero Marttila <terom@fixme.fi>
parents:
57
diff
changeset
|
643 |
# group items together by parent; along with the parent item itself |
|
de6abcbd3c03
items: add inventory-import script, and tweak listing
Tero Marttila <terom@fixme.fi>
parents:
57
diff
changeset
|
644 |
# XXX: this only works correctly for top-level parents |
|
de6abcbd3c03
items: add inventory-import script, and tweak listing
Tero Marttila <terom@fixme.fi>
parents:
57
diff
changeset
|
645 |
items = self.session.query(Item).order_by(db.functions.coalesce(Item.parent_id, Item.id), Item.id).all() |
| 48 | 646 |
|
|
53
06dad873204d
items: use DeleteItemForm for ItemView as well
Tero Marttila <terom@fixme.fi>
parents:
48
diff
changeset
|
647 |
return ItemTable(self).render(items) |
| 48 | 648 |
|
649 |
def render_item_form (self) : |
|
650 |
""" |
|
651 |
Render ItemForm for creating a new item |
|
652 |
""" |
|
653 |
||
654 |
form = ItemForm(self.session) |
|
655 |
form.defaults() |
|
656 |
||
657 |
return form.render(action=self.url_for(NewItemView), legend=u"Lisää uusi") |
|
658 |
||
659 |
def render_content (self) : |
|
660 |
""" |
|
661 |
Full listing of all inventory |
|
662 |
""" |
|
663 |
||
664 |
return ( |
|
665 |
html.h1(u"Inventaari"), |
|
666 |
||
667 |
self.render_item_table(), |
|
668 |
||
669 |
self.render_item_form(), |
|
670 |
) |
|
671 |