Esempio n. 1
0
def mobile_edit_register(request, company_id):
    # add a new register
    try:
        c = Company.objects.get(id=company_id)
    except Company.DoesNotExist:
        return JsonError(_("Company does not exist"))

    # check permissions: needs to be manager
    if not has_permission(request.user, c, 'register', 'edit'):
        return JsonError(_("You have no permission to edit registers"))

    data = JsonParse(request.POST['data'])

    try:
        register = Register.objects.get(id=int(data['id']), company=c)
    except Register.DoesNotExist:
        return JsonError(_("Register does not exists"))

    valid = validate_register(request.user, c, data, register=register)

    if not valid.get('status'):
        return JsonError(valid['message'])

    form = valid['form']
    register = form.save(False)
    register.company = c
    register.created_by = request.user
    register.device_id = data['device_id']

    register.save()

    return JsonOk(extra=register_to_dict(request.user, c, register))
Esempio n. 2
0
def mobile_get_register(request, company_id):
    try:
        c = Company.objects.get(id=company_id)
    except Company.DoesNotExist:
        return JsonError(_("Company does not exist"))

    user = request.user

    # check permissions: needs to be guest
    if not has_permission(request.user, c, 'register', 'view'):
        return JsonError(_("You have no permission to view registers"))

    data = JsonParse(request.POST['data'])
    device_id = data['device_id']

    try:
        register = Register.objects.get(company=c, device_id=device_id)
        r = {
            'register': register_to_dict(request.user, c, register)
        }
    except Register.DoesNotExist:
        r = {
            'register': None
        }

    return JsonOk(extra=r, safe=False)
Esempio n. 3
0
File: bill.py Progetto: rokj/sellout
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
Esempio n. 4
0
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)