I suggest using a metric measure for your volumes which as base 10 will be easier to work with than the different scales between oz pints and gallons. You can then convert your metric measure to an imperial amount via a helper. What ever way you do it you'll need to maintain the same unit of measure. I'd suggest using litres as unit of measure.
Mike Karthauser Brightstorm limited Tel: 07939252144 On 2 Dec 2009, at 18:03, fly2279 <kennethf...@gmail.com> wrote: > I need guidance on how to setup an inventory system. The inventory I > am managing is in liquid form and will be added/subtracted in > different units. For example Product A will be added from the supplier > in gallons, distributed out the door in pints, and applied in fluid > ounces. I thought about having a quantity field in the products table > to keep track of this but the only problem I see is which unit do I > store it in? If it's stored in gallons and you subtract only a few > ounces then it won't be very accurate to have a huge decimal number > i.e. you had 5 gallons and subtracted a few ounces so now you have > 4.966 gallons left. I could store it in ounces to avoid that but each > product will have different units and it might be difficult to keep > track of all that. > > Any suggestions on a good way to handle this? Are there any examples > of inventory/inventory management systems for cake? > > Check out the new CakePHP Questions site http://cakeqs.org and help > others with their CakePHP related questions. > > You received this message because you are subscribed to the Google > Groups "CakePHP" group. > To post to this group, send email to cake-php@googlegroups.com > To unsubscribe from this group, send email to > cake-php+unsubscr...@googlegroups.com For more options, visit this > group at http://groups.google.com/group/cake-php?hl=en > Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions. You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en
