StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO3 Tiered Ordering Application using Django Admin
primarykey
Id
12744646
data
AcceptedAnswerId
0
AnswerCount
1
ClosedDate
2012-10-09T05:08:34.547
CommentCount
0
CommunityOwnedDate
CreationDate
2012-10-05T10:49:45.330
FavoriteCount
0
LastActivityDate
2012-10-05T11:19:15.567
LastEditDate
2017-05-23T12:30:34.560
LastEditorUserId
-1
OwnerUserId
176166
ParentId
0
PostTypeId
1
Score
0
ViewCount
286
LastEditorDisplayName
text
Body
<blockquote> Possible Duplicate: <a href="https://stackoverflow.com/questions/3681258/nested-inlines-in-the-django-admin">Nested inlines in the Django admin?</a> </blockquote> I'm developing an application for a catering company, using Python, Django and PostgreSQL. I have tried to use the Django Admin module as a way to add orders. I want to be able to do everything on one page. I am starting to believe it may not be possible. Do not worry, only office staff will be using this part of the software, not the general public. Our pricing structure works on the number of items per person, multiplied by the people being catered for. Here is an example: <hr> Order for "Fake Company": <ul> <li>Morning Tea of 2 items at $8.00 x 10ppl:     #This is what we call a deal, items have no price. <ul> <li>Gluten Free Biscuits x1</li> <li>Sausage Roll x10 </li> <li>Biscuits x9  </li> </ul></li> <li>Lunch of 3 items at $10.00 x 10ppl: <ul> <li>Sausage Roll x5 </li> <li>Sushi x5 </li> <li>Sandwich x10 </li> <li>Sweet Platter x10</li> </ul></li> </ul> <hr> Total: $180 <hr>   The way each order is structured in the database is like this: -COMPANY   -SALE (One-TO-One relationship with COMPANY)     -DEAL_INSTANCE (One-To-One relationship with both SALE and a DEAL)       -ITEM (Many-TO-Many relationship with DEAL_INSTANCE through a join table, as an item quantity                   field is required) I have managed to get everything but adding items to a DEAL_INSTANCE, on one page. Due to Django Admin not really liking Many-To-Many Relationships defined with the 'through' attribute. Here is a link to a screenshot of what I already have, just to clarify things (just copy image location to view fullsize): <img src="https://i.stack.imgur.com/VL7BT.png" alt="What I have so far."> So in closing, I ask is it possible to have this whole process on one page using Django Admin? If not, what's the best way to go about it using Django and should I change the layout of my database? Thanks in advance, I know this is a bit of an odd situation to get your head around. I am a Django newbie, but proficient in Python; so you may need to hold my hand when it comes to Django.
Tags
<python><django><postgresql>
Title
3 Tiered Ordering Application using Django Admin
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USCommunity
UserOwnerUserId
1. USCharles Ritchie
plurals
PostLinksPostIdRelatedPostId
1. PL
 singulars
 LinkTypeLinkTypeId
 LTLinked
2. PL
 singulars
 LinkTypeLinkTypeId
 LTDuplicate
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.