def get_contacts(request, company): """ creates contact on the fly (while creating bill on the terminal) contact data is in request.POST """ try: c = Company.objects.get(url_name=company) except Company.DoesNotExist: return JsonError(_("Company does not exist.")) # permissions if not has_permission(request.user, c, 'contact', 'edit'): return JsonError(_("You have no permission to add contacts")) data = JsonParse(request.POST.get('data')) my_contacts = Contact.objects.filter( Q(company_name__icontains=data['search_term']) | Q(first_name__icontains=data['search_term']) | Q(last_name__icontains=data['search_term']) | Q(street_address__icontains=data['search_term']) | Q(postcode__icontains=data['search_term']) | Q(city__icontains=data['search_term']) | Q(state__icontains=data['search_term']) | Q(country__icontains=data['search_term']) | Q(email__icontains=data['search_term']) | Q(vat__icontains=data['search_term']), company=c, ) durs_contacts = ContactRegistry.objects.filter( Q(company_name__icontains=data['search_term']) | Q(first_name__icontains=data['search_term']) | Q(last_name__icontains=data['search_term']) | Q(street_address__icontains=data['search_term']) | Q(postcode__icontains=data['search_term']) | Q(city__icontains=data['search_term']) | Q(state__icontains=data['search_term']) | Q(country__icontains=data['search_term']) | Q(email__icontains=data['search_term']) | Q(vat__icontains=data['search_term']) ) my_contacts = json.dumps([contact_to_dict(request.user, c, mc) for mc in my_contacts]) durs_contacts = json.dumps([contact_to_dict(request.user, c, dc) for dc in durs_contacts]) return JsonOk(extra={"my_contacts": my_contacts, "durs_contacts": durs_contacts})
def bill_to_dict(user, company, bill): # fields in bill: # company # type # recipient_contact > FK contact # note # sub_total | # discount | decimal fields, with everything calculated # tax | # timestamp # status > choices in g.BILL_STATUS b = { "id": bill.id, "issuer": company_to_dict(user, bill.issuer), "register": register_to_dict(user, company, bill.register), "user_id": bill.user_id, "user_name": bill.user_name, "serial": bill.serial, "serial_prefix": bill.serial_prefix, "serial_number": bill.serial_number, "notes": bill.notes, "discount_amount": format_number(user, company, bill.discount_amount), "discount_type": bill.discount_type, "currency": bill.payment.currency, # prices "base": format_number(user, company, bill.base), "discount": format_number(user, company, bill.discount), "tax": format_number(user, company, bill.tax), "total": format_number(user, company, bill.total), "timestamp": format_date(user, company, bill.timestamp) + " " + format_time(user, company, bill.timestamp), } if bill.contact: b["contact"] = contact_to_dict(user, company, bill.contact) # get items items = list(BillItem.objects.filter(bill=bill)) # gather tax rates for all items grouped_taxes = group_tax_rates(items) tax_rates = grouped_taxes["rates"] tax_sums = grouped_taxes["sums"] for rate in tax_rates: rate["amount"] = format_number(user, company, rate["amount"]) rate["tax_sum"] = format_number(user, company, rate["tax_sum"]) rate["net_sum"] = format_number(user, company, rate["net_sum"]) rate["gross_sum"] = format_number(user, company, rate["gross_sum"]) tax_sums["tax_sum"] = format_number(user, company, tax_sums["tax_sum"]) tax_sums["net_sum"] = format_number(user, company, tax_sums["net_sum"]) tax_sums["gross_sum"] = format_number(user, company, tax_sums["gross_sum"]) b["tax_rates"] = tax_rates b["tax_sums"] = tax_sums # format all items i = [] for item in items: i.append(bill_item_to_dict(user, company, item)) b["items"] = i b["payment"] = payment_to_dict(user, company, bill.payment) return b
def mobile_sync_db(request, company_id): try: company = Company.objects.get(id=company_id) except Company.DoesNotExist: return JsonError(_("Company does not exist")) data = JsonParse(request.POST['data']) seq = data['database_version'] device_id = data['device_id'] sync_objects = Sync.objects.only('seq')\ .filter(company=company).order_by('-seq') last_key = 0 if len(sync_objects) > 0: last_key = sync_objects[0].seq ret = {'version': last_key} if seq == 0 or last_key - 5000 > seq or seq > last_key: # if first sync or sync outdated, why not load whole DB ret['updated'] = False ret['drop'] = True # get taxes ret['taxes'] = get_all_taxes(request.user, company) # get contacts contacts = Contact.objects.filter(company=company) cs = [] for contact in contacts: cs.append(contact_to_dict(request.user, company, contact)) ret['contacts'] = cs # get categories categories = Category.objects.filter(company=company) ct = [] for category in categories: ct.append(category_to_dict(category, android=True)) ret['categories'] = ct # get discounts discounts = Discount.objects.filter(company=company) ds = [] for discount in discounts: ds.append(discount_to_dict(request.user, company, discount, android=True)) ret['discounts'] = ds # get products products = Product.objects.filter(company=company) pr = [] for product in products: pr.append(product_to_dict(request.user, company, product, android=True)) ret['products'] = pr try: register = Register.objects.get(company=company, device_id=device_id) ret['register'] = register_to_dict(request.user, company, register) except Register.DoesNotExist: ret['register'] = None ret['company'] = company_to_dict(request.user, company, android=True, with_config=True) elif seq < last_key: ret['updated'] = False ret['drop'] = False seq_list = Sync.objects.filter(company=company, seq__lte=last_key).order_by('seq') items = [] for seq_item in seq_list: item_ret = {'action': seq_item.action, 'model': seq_item.model, 'object_id': seq_item.object_id} if seq_item.action == 'save': if seq_item.model == 'Category': c = Category.objects.get(id=seq_item.object_id) item_ret['item'] = category_to_dict(c, android=True) elif seq_item.model == 'Product': p = Product.objects.get(id=seq_item.object_id) item_ret['item'] = product_to_dict(request.user, company, p, android=True) elif seq_item.model == 'Tax': t = Tax.objects.get(id=seq_item.object_id) item_ret['item'] = tax_to_dict(request.user, company, t) elif seq_item.model == 'Discount': d = Discount.objects.get(id=seq_item.object_id) item_ret['item'] = discount_to_dict(request.user, company, d, android=True) elif seq_item.model == 'Contact': con = Contact.objects.get(id=seq_item.object_id) item_ret['item'] = contact_to_dict(request.user, company, con) elif seq_item.model == 'Register': r = Register.objects.get(id=seq_item.object_id) item_ret['item'] = register_to_dict(request.user, company, r) elif seq_item.model == 'Company': item_ret['item'] = company_to_dict(request.user, company, android=True, with_config=True) items.append(item_ret) ret['items'] = items else: ret['updated'] = True return JsonOk(extra=ret, safe=False)