def show_csv_order(request, file_key):
try:
csv = CSVBlobReader(file_key,encoding='utf-8', delimiter=';', quotechar='"')
order_date = csv.blob_info.creation
logging.info('showing csv order (submit date %s, key "%s")' % (order_date,file_key))
list = []
row = csv.next()
if row:
list.append([row,None])
logging.info(row)
for row in csv:
logging.info(row)
o = OrderItem()
o.from_csv_row(row)
logging.info('order item = %s'% o)
list.append([row,o])
cols = max([ len(r[0]) for r in list ])
logging.info('cols = %d' % cols)
except BlobNotFoundError:
logging.info('BlobNotFoundError')
raise Http404
return render_to_response('vital/show_csv_order.html', RequestContext(request, { 'file_key': file_key, 'list': list, 'cols':range(cols) }))
def register_csv_order(request, file_key):
try:
csv = CSVBlobReader(file_key,encoding='utf-8', delimiter=';', quotechar='"')
order_date = csv.blob_info.creation
logging.info('registering csv order (submit date %s, key "%s")' % (order_date,file_key))
csv.next()
order_group = getOrderGroup(order_date)
order = Order(parent=order_group)
order.set_info(csv.blob_info)
order.save()
for row in csv:
logging.info(row)
for c in range(abs(int(row[0]))):
order_item = OrderItem(parent=order)
if order_item.from_csv_row(row):
order_item.save()
logging.info('order item = %s'% order_item)
except BlobNotFoundError:
logging.info('BlobNotFoundError')
raise Http404
return render_to_response('vital/register_csv_order.html', RequestContext(request, { 'file_key': file_key, 'order_group': order_group }))
def extra(request):
if request.method == 'POST':
form = ExtraOrderForm(request.POST)
if form.is_valid():
date = datetime.datetime.utcnow()
date = datetime.datetime(date.year,date.month,date.day)
eo = getExtraOrder(date)
order_item = OrderItem(parent=eo)
order_item.extra = True
form = ExtraOrderForm(request.POST, instance=order_item)
if form.is_valid():
form.save(commit=False)
logging.info('extra order item = %s',order_item)
order_item.save()
return redirect('/vital/')
else:
form = ExtraOrderForm()
return render_to_response('vital/extra.html', RequestContext(request, { 'form': form}))
def clearance_edit(request, clearance_id):
clearance = Clearance.get_by_id(int(clearance_id))
if clearance is None:
raise Http404
if getConfig('CLEARANCE_ALL_ORDER_ITEMS',0):
logging.info('showing all order items!')
order_item_query = OrderItem.objects.all().filter('date =', clearance.date)
else:
order_item_query = OrderItem.objects.all().filter('date =', clearance.date).filter('clearance_item_ref =', None)
c_pick_form = None
c_give_form = None
c_del_form = None
c_clear_form = None
c_load_form = None
c_deposit_form = None
pick_accounts = Account.objects.all().filter('purpose =', 'user').fetch(100)
give_accounts = Account.objects.all().filter('purpose =', 'credit').fetch(100)
if request.method == 'POST':
logging.info(request.POST)
if request.POST['action'] == 'update':
c_form = ClearanceForm(request.POST)
if c_form.is_valid():
clearance.date = c_form.cleaned_data['date']
clearance.desc = c_form.cleaned_data['desc']
clearance.save()
if request.POST['action'] == 'pick_item':
order_items = order_item_query.fetch(100)
c_pick_form = ClearanceItemPickForm(request.POST,accounts=pick_accounts,order_items=order_items)
if c_pick_form.is_valid():
logging.info('c_pick_form is valid!')
order_item = OrderItem.get(c_pick_form.cleaned_data['order_item_id'])
account = Account.get(c_pick_form.cleaned_data['account_id'])
logging.info('account = %s'%account)
logging.info('order_item = %s'%order_item)
if order_item is None:
raise Http404
if account is None:
raise Http404
ci = ClearanceItem(parent=clearance)
ci.account = account
ci.order_item = order_item
ci.cost = order_item.cost
ci.desc = order_item.name
ci.purpose='pick'
ci.save()
order_item.clearance_item_ref = ci.key()
order_item.save()
c_pick_form = None
if request.POST['action'] == 'give_item':
c_give_form = ClearanceItemGiveForm(request.POST, give_accounts)
if c_give_form.is_valid():
logging.info('c_give_form is valid!')
account = Account.get(c_give_form.cleaned_data['account_id'])
logging.info('account = %s'%account)
if account is None:
raise Http404
ci = ClearanceItem(parent=clearance)
ci.account = account
ci.cost = int(c_give_form.cleaned_data['cost'])
ci.purpose='give'
ci.save()
c_give_form = None
if request.POST['action'] == 'load_item':
c_load_form = ClearanceItemLoadForm(request.POST, give_accounts)
if c_load_form.is_valid():
logging.info('c_load_form is valid!')
account = Account.get(c_load_form.cleaned_data['account_id'])
logging.info('account = %s'%account)
if account is None:
raise Http404
ci = ClearanceItem(parent=clearance)
ci.account = account
ci.cost = int(c_load_form.cleaned_data['cost'])
ci.purpose='load'
ci.desc = c_load_form.cleaned_data['desc']
ci.save()
c_load_form = None
if request.POST['action'] == 'deposit_item':
c_deposit_form = ClearanceItemDepositForm(request.POST, pick_accounts)
if c_deposit_form.is_valid():
logging.info('c_deposit_form is valid!')
account = Account.get(c_deposit_form.cleaned_data['account_id'])
logging.info('account = %s'%account)
if account is None:
raise Http404
ci = ClearanceItem(parent=clearance)
ci.account = account
ci.cost = int(c_deposit_form.cleaned_data['cost'])
ci.purpose='deposit'
ci.desc = c_deposit_form.cleaned_data['desc']
ci.save()
c_deposit_form = None
if request.POST['action'] == 'del_item':
c_list = ClearanceItem.objects.all().ancestor(clearance).fetch(100)
c_del_form = ClearanceItemDelForm(request.POST, items = c_list)
if c_del_form.is_valid():
logging.info('c_del_form is valid!')
clearance_item = ClearanceItem.get(c_del_form.cleaned_data['item_id'])
if clearance_item is None:
raise Http404
if not (clearance_item.order_item is None):
logging.info('unmark %s'%clearance_item.order_item)
clearance_item.order_item.clearance_item_ref=None
clearance_item.order_item.save()
clearance_item.delete()
c_del_form = None
if request.POST['action'] == 'clear_item':
c_list = ClearanceItem.objects.all().ancestor(clearance).fetch(100)
c_clear_form = ClearanceItemClearForm(request.POST, items = c_list)
if c_clear_form.is_valid():
logging.info('c_clear_form is valid!')
clearance_item = ClearanceItem.get(c_clear_form.cleaned_data['item_id'])
if clearance_item is None:
raise Http404
c_clear_form = None
c_form = ClearanceForm({'date':clearance.date, 'desc':clearance.desc})
c_list = ClearanceItem.objects.all().ancestor(clearance).fetch(100)
cost_pick = sum([i.cost for i in c_list if i.purpose=='pick'])
cost_give = sum([i.cost for i in c_list if i.purpose=='give'])
cost_load = sum([i.cost for i in c_list if i.purpose=='load'])
cost_deposit = sum([i.cost for i in c_list if i.purpose=='deposit'])
cost_diff = cost_pick - cost_give
cost_put_diff = cost_deposit - cost_load
logging.info('cost_pick=%d, cost_give=%d'%(cost_pick,cost_give))
if c_pick_form is None:
order_items = order_item_query.fetch(100)
c_pick_form = ClearanceItemPickForm(accounts=pick_accounts,order_items=order_items)
if c_give_form is None:
c_give_form = ClearanceItemGiveForm(accounts=give_accounts,cost = cost_pick-cost_give)
if c_del_form is None:
c_del_form = ClearanceItemDelForm(items = c_list)
if c_clear_form is None:
c_clear_form = ClearanceItemClearForm(items = c_list)
if c_load_form is None:
c_load_form = ClearanceItemLoadForm(accounts=give_accounts, cost = cost_put_diff)
if c_deposit_form is None:
c_deposit_form = ClearanceItemDepositForm(accounts=pick_accounts)
return render_to_response('vital/clearance_edit.html', RequestContext(request,
{'c_form':c_form, 'c_list':c_list, 'c_pick_form': c_pick_form, 'c_give_form': c_give_form, 'c_del_form':c_del_form,
'cost_pick':cost_pick, 'cost_give':cost_give, 'cost_diff':cost_diff, 'c_clear_form':c_clear_form,
'c_load_form':c_load_form, 'c_deposit_form':c_deposit_form,
'cost_load':cost_load, 'cost_deposit':cost_deposit, 'cost_put_diff':cost_put_diff,
}))
