Hi, there are some questions which you have to answer if you want to design this app.
1) sizes are connected to the type or to the design, or to the combinatioin of design&type? a) all posters have size A5 and A6 (no matter which design), all banners has size A6, A7 (no matter which design) b) design D1 can have size A2, A3, A4 (no matter which type) c) design D2 on banner can have size A4,A5, A6; design D2 on Flyer can have sizes A5,A6, A7 2) quantity is connected only to the size? Or to the combinations of the size & type? On 24 čnc, 18:08, Micoto <mich...@micoto.co.uk> wrote: > This is more of a 'how would I go about it' rather than a specific > symfony question, but as I am using symfony to develop this, here > goes! > > I have a website I would like to set up whereby a person can login, > choose a design and then (admin configurable) be able to choose either > a Flyer, Poster or Banner depending on what they choose they will be > able to order a different quantity. > > i.e. Person logs in - > They pick a design > They pick a media Type (Flyers, Posters, Banners) > They pick A siz (A5,A6, A7) > They pick a quantity (determined by admin on a per size scale, they > can choose from 100,200 on A5 flyers; 500 or 1000 on A6 flyers, 1 or 2 > A2 Posters or 3 or 4 A3 Posters. And then a configurable option if > they can choose to provide their own quantity. > > In the backend I want to be able to add one design and then be able to > add different quantities for different sizes and media types. > > I have thought that I would need 3 tables, one for designs, one for > media types and one for sizes. > > I would then have a serialized field in the designs with say A2:1,2,3- > N|A5:100,200,500-Y which would then populate the settings for the > design. > A2 being file size (but relational to the media types table), 1,2,3 > being the quantities allowed (again relational to the stored > quantities table) and the -N or -Y if they are allowed to provide > there own quantity. > > I would really appreciate input from other people as it's kind of > challenging to get my head around the logic of it. Any other ideas? -- If you want to report a vulnerability issue on symfony, please send it to security at symfony-project.com You received this message because you are subscribed to the Google Groups "symfony users" group. To post to this group, send email to symfony-users@googlegroups.com To unsubscribe from this group, send email to symfony-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en