Django inlineformset autocomplete and autopopulate by ajax

[Ajay Kumar]

I'm trying to do this following link feature in django,
http://demo.smarttutorials.net/jquery-autocomplete/

Here by choosing country the rest of the fields will be auto populated, 
like this i'm trying to achieve in django, If any idea pls tell me it will 
be very great for me


This is Product table,by this i will add many products
*models.py*
class Product(models.Model):
     store = models.ForeignKey(Store)
     code = models.CharField(verbose_name='Product Code', max_length=128, 
blank=False)
     name = models.CharField(verbose_name='Product Name', max_length=128, 
blank=False)
     unit_price = models.FloatField(verbose_name='Unit Price', blank=False)
     in_stock = models.IntegerField(verbose_name='In Stock', default=0, 
blank=False)


This is Invoice order table, in this i will get customer details
class Invoice(models.Model):
     customer = models.ForeignKey(Customer)
     date = models.DateTimeField(auto_now=True, blank=False)


This in Invoice Item order table which is in inline formset 
class InvoiceItem(models.Model):
     invoice = models.ForeignKey(Invoice)
     product = models.ForeignKey(Product)
     particular = models.CharField(verbose_name='Particular', max_length=128
, blank=False)
     quantity = models.IntegerField(verbose_name='Quantity', default=0)
     unit_price = models.FloatField(verbose_name='Unit Price', blank=False)
     tax_rate_percentage = models.FloatField(verbose_name='Tax Rate 
Percentage', blank=False)

*views.py*
I'm trying to raise invoice by autopopulate feature.
def add_invoice(request):
  store = Store.objects.get(id=pk)
  product = Product.objects.filter(store=store)
  context =  RequestContext(request)
  InvoiceItemInlineFormSet = inlineformset_factory(Invoice, InvoiceItem, 
extra = 1,exclude=('invoice',))
  if request.method == 'POST':
    invoiceform = InvoiceForm(request.POST)
    invoiceformset =  InvoiceItemInlineFormSet(request.POST)
    if invoiceform.is_valid() and invoiceformset.is_valid():
       invoice = invoiceform.save(commit=False)
       invoice.store = store
       invoice.save()
       invoiceformset.save(commit=False)
       invoiceformset.instance = invoice
       invoiceformset.save()
       return HttpResponseRedirect('/store_invoice/%s/invoice/'% pk)
   else:
      invoiceform = InvoiceForm()
      invoiceformset =  InvoiceItemInlineFormSet()
   args = {}
   args.update(csrf(request))
  args = {'email':email,'store':store,'invoiceform':invoiceform, 
'invoiceformset':invoiceformset}
  return render_to_response('invoice/invoice_add.html',args,context)


*invoice_add.html*

{% extends "base_site.html" %}
{% load staticfiles %}
{% block title %}Add New Order | Finvoicez{% endblock %}
{% block page-heading %}Add New Order{% endblock %}
{% block content %}
<script src="{{ STATIC_URL }}js/jquery-1.3.2.min.js"></script>
<script type="text/javascript">
        $(function() {
            $(".inline.{{ invoiceformset.prefix }}").formset({
                prefix: "{{ invoiceformset.prefix }}",
            })
        })
    </script>
<div class="the-box no-border">
    <form action="/store_invoice/{{store.id}}/invoice/add/"  method="post">{% 
csrf_token %}
        <div class="row">
            <div class="col-sm-4">
                <label>Customer</label>
                {{invoiceform}}
            </div>
        </div>
        <fieldset>
            <legend>Order Items</legend>
            {{ invoiceformset.management_form }}
            {{ invoiceformset.non_form_errors }}
            {% for form in invoiceformset %}
                {{ form.id }}
                <div class="inline {{ invoiceformset.prefix }}">
                    {{form}}
                </div>
            {% endfor %}
        </fieldset>
        <button type="submit" class="btn btn-success">Add Order</button>
    </form>
</div>
{% endblock %}


Here i'm trying to bring when i'm adding Invoice Item , by selecting the 
product code the rest of fields want to be autopopulate by corresponding 
Product details(Particular,unit price and tax) and it must be in 
inlineformset, for every 'add another' it must be autopopulate, like above 
reference link.
thanks in advance

<https://lh4.googleusercontent.com/-CBWl2IHpxMM/VNyO5GBTYZI/AAAAAAAAAUw/DDvqIlYXmkk/s1600/Screenshot%2Bfrom%2B2015-02-12%2B11%3A30%3A21.png>

-- 
You received this message because you are subscribed to the Google Groups 
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-users+unsubscr...@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at http://groups.google.com/group/django-users.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-users/bdab6549-0749-4ec4-8f67-c85a93cd5c2a%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.