here is my model-
from django.db import models
import useraccounts
from librehatti.catalog.models import *
from django.contrib.auth.models import User
class QuotedOrder(models.Model):
quote_buyer_id = models.ForeignKey(User)
quote_is_debit = models.BooleanField()
quote_delivery_address = models.ForeignKey('useraccounts.Address')
quote_organisation =
models.ForeignKey('useraccounts.AdminOrganisations')
quote_date_time = models.DateTimeField(auto_now_add=True)
def __unicode__(self):
return '%s' % (self.quote_buyer_id) +' - ' '%s' %
(self.quote_date_time.strftime ('%b %d, %Y'))
class QuotedItem(models.Model):
quote_order = models.ForeignKey(PurchaseOrder)
quote_price = models.IntegerField()
quote_qty = models.IntegerField()
quote_discount= models.IntegerField()
quote_item = models.ForeignKey(Product)
status = models.IntegerField(default=0)
def save(self):
if not self.id:
self.quote_price = self.quote_item.price * self.quote_qty
super(QuotedItem,self).save()
def __unicode__(self):
return '%s' % (self.quote_item) + ' - ' '%s' % (self.quote_order)
here is my forms.py-
from django import forms
from librehatti.bills.models import *
#class ConfirmForm(forms.Form):
#quote_item = forms.CharField()
#quote_qty = forms.IntegerField()
class ConfirmForm(ModelForm):
class Meta:
model = QuotedItem
fields = ('quote_item', 'quote_qty')
here is my html-file-
<html>
<head>
<title>display items</title>
</head>
<body>
<h1>CONFIRM ITEMS</h1>
<form
action="/bills/confirm/final/{{quoted_order.quote_buyer_id.username}}/"
method="POST"> {% csrf_token %}
<table>
<tr>
<th>Item</th>
<th>Quantity</th>
</tr>
{% for i in quoted_item %}
<tr>
<td>Item:<input type="text" name = "quote_item"
value="{{i.quote_item.name}}"></td>
<td>Quantity:<input type="text" name="quote_qty"
value="{{i.quote_qty}}"></td>
</tr>
{% endfor %}
</table
<a href="/bills/confirm/final/{{quoted_order.quote_buyer_id.username}}">
<input type="submit" value="Submit" name="submit"/> </a>
</form>
</body>
</html>
here is catalog models, where i want to save the values, input by user in
form-
from django.db import models
from django.forms import ModelForm
import useraccounts
from django.contrib.auth.models import User
class Category(models.Model):
name = models.CharField(max_length=100)
parent = models.ForeignKey('self', blank=True, null=True)
def __unicode__(self):
return unicode(self.name)
class Product(models.Model):
name = models.CharField(max_length=100)
category = models.ForeignKey(Category)
price = models.IntegerField()
organisation = models.ForeignKey('useraccounts.AdminOrganisations')
def __unicode__(self):
return self.name
class Attributes(models.Model):
name = models.CharField(max_length=200)
is_number = models.BooleanField()
is_string = models.BooleanField()
def __unicode__(self):
return self.name
class PurchaseOrder(models.Model):
buyer_id = models.ForeignKey(User)
is_debit = models.BooleanField()
delivery_address = models.ForeignKey('useraccounts.Address')
organisation = models.ForeignKey('useraccounts.AdminOrganisations')
date_time = models.DateTimeField(auto_now_add=True)
def __unicode__(self):
return '%s' % (self.buyer_id) +' - ' '%s' % (self.date_time.strftime
('%b %d, %Y'))
class PurchasedItem(models.Model):
purchase_order = models.ForeignKey(PurchaseOrder)
price = models.IntegerField()
qty = models.IntegerField()
discount= models.IntegerField()
item = models.ForeignKey(Product)
def save(self):
if not self.id:
self.price = self.item.price * self.qty
super(PurchasedItem,self).save()
def __unicode__(self):
return '%s' % (self.item) + ' - ' '%s' % (self.purchase_order)
class Catalog(models.Model):
attribute = models.ForeignKey(Attributes)
value = models.CharField(max_length=200)
product = models.ForeignKey(Product)
def __unicode__(self):
return self.attribute.name;
how to save now? and to generate bills also?
here is bill.html-
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset='UTF-8'>
<link rel="stylesheet" type="text/css" href="style.css" />
<title>bill</title>
</head>
<body>
<div style="text-align:center">
<h1>{{quoted_order.quote_organisation.organisation_type}}</h1>
<p>{{quoted_order.quote_organisation.tagline}}</p>
<h1 style="font-sixe:14px">{{quoted_order.quote_organisation.title}}
</h1>
<p>{{quoted_order.quote_organisation.address}}</p>
<p><i>Website :</i> {{quoted_order.quoted_organisation.quote_url}}
<i>Email:</i>{{quoted_order.quoted_organisation.quote_email1}} <i>Ph
:</i>
{{quoted_order.quote_organisation.telephone}}
<i>Fax :</i> {{quoted_order.quote_organisation.fax}}</p>
<br><br>
<h2 style="text-align:center;font-size:175%;"> Bill</h2>
</div>
<div style="font-size:100%;">
<p>STC No. {{ STC_NO }}</P>
<p>PAN No. {{ PAN_No. }}
</div>
<div style="position:absolute;top:290px;left:35px;">
No. : GNDEC/TCC/B/{{ job_no }}</div>
<div style="position:absolute;top:290px;right:0px;">
Dated : {{quoted_order.date_time}} </div>
<br>
<br>
<br>
</br> To,
</br> {{quote_delivery_address}}
</br> Organisation:{{quote_organisation}}
</br> Buyer Id : {{ purchased_order.buyer_id.username }}
</br> Ref: Your Letter No.{{L_No.}},
dated:{{quoted_order.date_time}} , respectively.
</br>
</br>
</br>
<table>
<tr>
<th>S.no.</th>
<th>Charges For Following</th>
<th>Price</th>
<th>Per</th>
<th>Total</h>
</tr>
{% if QuotedItem %}
{% for i in QuotedItem %}
<tr>
<td>{{ forloop.counter }}</td>
<td>{{ i.quote_item }}</td>
<td>{{ i.quote_price }} </td>
<td>{{ i.quote_qty }}</td>
<td>{{ i.total }}</td>
</tr>
{% endfor %}
{% endif %}
<tr>
<td><b>Total </b></td>
<td colspan="3"></td>
<td align="right"> <b>{{total_cost}}</b></td>
</tr>
</br>
{% if bill.trans_total != None %}
<tr>
<td>Transportation Charges</td>
<td colspan="3"></td>
<td align="right">{{bill.trans_total}}</td>
</tr>
<tr>
<td>Total Amount</td>
<td colspan="3"></td>
<td align="right">{{bill.trans_net_total}}</td>
</tr>
{% endif %}
<tr>
<td>Service Tax @ {{ servicetaxprint }}% </td>
<td colspan="3"></td>
<td align="right">{{ bill.service_tax }}</td>
</tr>
<tr>
<td>Education Cess @ {{ educationtaxprint }}% </td>
<td colspan="3"></td>
<td align="right">{{ bill.education_tax }}</td>
</tr>
<tr>
<td><b>G.Total (Rupees {{ net_total_eng }} only)</b> </td>
<td colspan="3"></td>
<td align="right"><b>{{ cdftotal }} {{ bill.net_total}}</b></td>
</tr>
</table>
<div style="position:absolute;right:30px;top:1050px;">
<!-- Dean is liable to change-->
<p> Dean Training And Consultancy Cell </p>
</div>
<br><div style="position:absolute;top:1050px;">
I/We here by agree to the terms & conditions as mentioned above</div>
<div style="position:absolute;right:30px;top:1100px;">
(Signature of Client/Deptt. Representative)</div>
</body>
</html>
--
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/8326cb3a-e338-4649-bede-7bdc7ff1141c%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
