Jump to content
Larry Ullman's Book Forums

Delete Which Is An Update


Recommended Posts

Hello,

 

I'd like to set the "Delete item" link given by default by the CRUD generator in order to make it just update a field of the database with a varchar string instead of really delleting the record.

In practice my "delete" function would be an "update" one.

Unfortunately i couldn't help myself reading in the YII book (which i bought some months ago) and trying a serach on the internet.

Maybe some of you can help even just pointing me to a link or documentation that cold halp me.

What I wish to obtain is the following:

 

I have a field in my table called "record_status" which has to be set to one of the 3 values UPD, NEW or CANC accordingly if I Update a record, create a new one or delete a record.

The record, though, shouldn't be deleted.

 

I can't find what code to use and where to put the conditionals and possible hidden fields in order to realize this.

 

Anyone have any advice?

 

SO far I have put the follwing code in the rules section of the Model "journal.php".

 

array('stato_record', 'default',
          'value' => 'NEW',
          'setOnEmpty' => false, 'on' => 'insert'),
array('stato_record', 'default',
          'value' => 'UPD',
          'setOnEmpty' => false, 'on' => 'update')
        
        );

 

How can i tell this bit of code that if the record is updated it has to save the "UPD" string and if "deleted" it has to save the "CANC" string?

 

Thank you for any help you can give.

 

And sorry in advance for my english and/or not being engouh clear...

 

Fabrizio

Link to post
Share on other sites

I think it'd probably help if you didn't use the word "delete" here since you're never actually deleting anything. You just want to do an update via Ajax, to one of three possible values. So to set it to the "delete" value, you can either change where the delete link points to or change the underlying method so that it updates the column value accordingly.

Link to post
Share on other sites
  • 2 weeks later...

Hello Larry,

 

thank you for your reply and sorry for the delay.

Unfortunately I already tried in many ways to do something like what you suggest but obviously there still is something wrong in my approach to the code to implement this functionality.

I'll try to have a look again.

 

Thanks.

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...