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, }))