Here is the updated code. I've deciding on increasing or decreasing
in the calling controller. If you want to decrease the inventory
numbers than pass a negative $quantity. This was the interface I
chose because I will have several different controllers calling this
function to make updates to the inventory numbers, like when more
inventory is added.
I like the example on the weblink which is just using MySQL
functionality, it is very clever. Thanks for the help and push. My
code is working! I did like the security tricks I discovered for my
updates below to only pass a field list.
function updateInventory($id, $quantity) {
$inv = $this->getQuantity($id); <- function is in the same
model
$this->data['Model']['id'] = $id;
$this->data['Model']['inventory'] = $inv + $quantity;
if($this->save($this->data, array(
'validate' => 'false',
'fieldList' => array('id',
'inventory')))) {
... logic for return values ...
}
}
On Mar 1, 12:03 pm, cricket <[email protected]> wrote:
> On Tue, Mar 1, 2011 at 10:42 AM, lirc201 <[email protected]> wrote:
> > Hello,
>
> > I'm trying to perform an update to my model in order to reflect a
> > change in the inventory value. The values that I'm passing to $id,
> > and $quantity below are correct, but even with a hard coded value of 5
> > the database still gets updated with a 0 for the inventory field for
> > the given id. This leads me to think I'm not passing the information
> > correctly to $this->save as I was using an update example from the 1.3
> > book for Saving Data.
>
> > In Model:
>
> > function updateInventory($id, $quantity) {
>
> > $this->id = $id;
> > $this->inventory = '5';
> > if($this->save($this->data, array('validate' => 'false',
> > 'fieldList' => array('id',
> > 'inventory')))) {
> > .....
>
> > }
>
> There is no $inventory class member. There is an $id, though. What you
> need to do is construct an array and pass that to save(). Using
> $this->data is fine but it's not apparent here that it contains the
> correct data at all. The array should look like:
>
> array(
> 'YourModelName' => array(
> 'id' => $id,
> 'inventory' => $inventory
> )
> )
>
> But there are simpler ways to do
> this:http://nuts-and-bolts-of-cakephp.com/2008/05/22/incrementing-a-field-...
>
> Also, is the $quantity param the number of items that inventory has
> changed by? How are you deciding whether to increase or decrease by
> that amount?
--
Our newest site for the community: CakePHP Video Tutorials
http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.cakephp.org and help others
with their CakePHP related questions.
To unsubscribe from this group, send email to
[email protected] For more options, visit this group at
http://groups.google.com/group/cake-php
