Re: [fw-db] MultiCheckBox Populate form, Insert/Update db how to?

Thanks again.

I appreciate all the help.

 

-R

 

On 12/9/08, Bart McLeod <mcleod@spaceweb.nl> wrote:

Raavi Raaj schreef:

Thanks for the help. I will read and try to understand this :)

 

One quick question: Since I have no checks like allowed roles etc. Can't I just delete all rows for the news_id in news2newstpe table and then insert the new data from the form. Or is this a bad idea?

You know your business logic best. Personally, I would have an exists() method or some other kind of check to see if the relationship exists, if it does, do not add it (skip it), if it does not, add it. But your way will work too and may be faster.
-Bart

 

-R

 

On 12/9/08, Bart McLeod <mcleod@spaceweb.nl> wrote:

Need some direction/help/sample code to achieve...
1. Save the relationship to the article2tags table when creating a new article

//example from user2role relationship:
    protected function processRoles($username){
        $roles_changed = false;
        $userRole = new CmsUserRole();
        $role = new CmsRole();
        $roles = ListProvider::get('role');
        $role_ids = array_keys($roles);
        $current_user_roles = $userRole->getRolesForUser($username);
        $submitted_roles = $this->getRequest()->getParam('roles');
        if(! is_array($submitted_roles)){
            $submitted_roles = array();
        }
        foreach ($role_ids as $role_id) {
            $role->populate(array('id' => $role_id));
            $role->read(null, true);
            $user_role_data = array(
                'username' => $username,
                'role_id'  => $role_id
            );
            if(in_array($role_id, $submitted_roles)){
                //the user has or gets the role
                if(in_array($role_id, $current_user_roles)){
                    //the user already has the role
                }else{
                    //the user gets the role
                    if(Admin_RolesController::isSuperUser($role_id)){
                        $this->view->message = $this->view->translate("You can't assign the Superuser role.");
                        return false;
                    }
                    $userRole->populate($user_role_data);
                    if(! $userRole->create()){
                        //@todo: improve messaging, allow for multiple errors
                        $this->view->message = $this->view->translate("Could not assing role $role->role to user '$username'");
                    }else{
                        $roles_changed = true;
                    }
                }
            }else{
                //the user has not or loses the rule
                if(in_array($role_id, $current_user_roles)){
                    if(Admin_RolesController::isSuperUser($role_id)){
                        $this->view->message = $this->view->translate("You can't unassign the Superuser role.");
                        return false;
                    }                   
                    //the user loses the role
                    $userRole->populate($user_role_data);
                    if($userRole->delete() !== 1){
                        //@todo: improve messaging, allow for multiple errors
                        $this->view->message = $this->view->translate("Could not remove role $role->role from user '$username'");
                    }else{
                        $roles_changed = true;                 
                    }
                }else{
                    //the user did not have the role to begin with
                }               
            }
        }
        return $roles_changed;
    }   

//oops, that one was quite long, it is called when creating or updating a user, so it applies to question 3 too.

2. Populate form with tags selected (check boxes) when editing the article
//example of checking the roles that apply to the user:
    protected  function populateForm($form, $user){
        $userRole = new CmsUserRole();
        $current_roles = $userRole->getRolesForUser($user->username);
        $role_data = array('roles' => $current_roles);
        $form->populate(array_merge($user->getData(), $role_data));
        $form->addExists();
        $this->_exists = true;//important for grouping!
        $form->getElement('delete')->setAttrib('disabled',null);
       
        if ($this->isUserSuperuser($user->username)) {
              //the user being edited here is a Superuser, you may not delete it, change him etc, unless you are the superuser yourselfs
              $form->getElement('roles')->setAttrib('disabled', true);
              $form->getElement('delete')->setAttrib('disabled', true);
              $form->getElement('save')->setAttrib('disabled', true);
              $form->getElement('password')->setAttrib('disabled', true);
              $form->getElement('is_locked')->setAttrib('disabled', true);
        }
       
        return $form;
    } 
3. Insert/Update the "article2tags" on updating the article
see example 1

Hope this gives you a hint,

-Bart

Raavi Raaj schreef:

Thanks guys.

@ Bart: Yes, i'd like to see a few examples. And yes can wait for your reply.

-R

On Mon, Dec 8, 2008 at 1:08 AM, Bart McLeod <mcleod@spaceweb.nl> wrote:

personally, I process the related records in a separte function, I have quite a few examples if you are interested, but will not have time before tomorrow,
Bart

Raavi Raaj schreef:

Hi,

I have three tables...
1. article
2. tags
3. article2tags".

The "article2tags" stores a a many-to-many relationship (made up of article_id and tag_id).

While creating/editing an article:
Need some direction/help/sample code to achieve...
1. Save the relationship to the article2tags table when creating a new article
2. Populate form with tags selected (check boxes) when editing the article
3. Insert/Update the "article2tags" on updating the article

All help is appreciated.

regards,
-R

P.S. My tables are MyISAM.