[Drupal] How to add members with administrator role in Drupal Commerce store?
https://www.zyxware.com/sites/default/files/styles/user_image/public/default_images/index.png?itok=2YmREnrP
BY antony.glen
4 years ago
Drupal
0 comments comment

This article focuses on how to add new members to Drupal commerce store. Usually, when a new user created with admin role tries to access the store, the action will be restricted with an "Access denied" message. For a user to access the commerce store, he should be a member of the store. Let's find out how to resolve this issue.

On creating a store 'member_id' and 'user_id' will be created in 'commerce_store_role' table. In hook_entity_insert(), collect all the administrative user id's from user's table along with member_id and admin id. Insert the user id and member id or admin id in table 'commerce_store_user_role' so that user can access commerce store.

Inside the hook_entity_insert() implementation, we need to fetch users in commerce store who has the administrator role, and also fetch the members in store with role administrator. The constant 'COMMERCE_STORE_ADMINISTRATOR_ROLE' stands for a role name of store administrator.

/**
 * Implements hook_entity_insert().
 */
function custom_module_entity_insert($entity, $type) {
  if ($type == 'commerce_store') {
    $query = db_select('users', 'users');
    $query->innerJoin('users_roles', 'users_roles', 'users_roles.uid = users.uid');
    $query->innerJoin('role', 'role', 'role.rid = users_roles.rid');
    $query->condition('role.name', 'administrator');
    $query->fields('users', array('uid'));
    $rows = $query->execute();
    $admin_users_list = $rows->fetchAll();
    $query = db_select('commerce_store_role', 'com_str_rol');
    $query->condition('com_str_rol.name', array(COMMERCE_STORE_AUTHENTICATED_ROLE));
    $query->condition('com_str_rol.store_id', $entity->id);
    $query->fields('com_str_rol', array('rid'));
    $member_rid_query = $query->execute();
    $member_rid_lists = $member_rid_query->fetchAll();

    foreach ($member_rid_lists as $member_rid_list) {
      $member_rid = $member_rid_list->rid;
    }

    $query = db_select('commerce_store_role', 'com_str_rol');
    $query->condition('com_str_rol.name', array(COMMERCE_STORE_ADMINISTRATOR_ROLE));
    $query->condition('com_str_rol.store_id', $entity->id);
    $query->fields('com_str_rol', array('rid'));
    $admin_rid_query = $query->execute();
    $admin_rid_lists = $admin_rid_query->fetchAll();
    foreach ($admin_rid_lists as $admin_rid_list) {
      $admin_rid = $admin_rid_list->rid;
    }

    foreach ($admin_users_list as $admin_user) {
      $admin_users[] = $admin_user->uid;
      if ((isset($member_rid)) || (isset($admin_rid))) {
        db_insert('commerce_store_user_role')->fields(array('uid' => $admin_user->uid, 'rid' => $member_rid))->execute();
        db_insert('commerce_store_user_role')->fields(array('uid' => $admin_user->uid, 'rid' => $admin_rid))->execute();
        commerce_store_access_rebuild_permissions(array($entity->id));
      }
    }
  }
}

The constant 'COMMERCE_STORE_AUTHENTICATED_ROLE' is the role name of store member. We will get the users with admin roles from the '$admin_users_list' variable and member id from '$member_rid' in the above code snippet. Finally, we will insert the user id 'uid' to 'commerce_store_user_role' table. After it is done, call 'commerce_store_access_rebuild_permissions()' function to rebuild store access permissions.

Following the above steps permission will be add to the newly created store user. We may find out the permission added to user not displayed in the listing page. For updating store members list page use hook_entity_presave(). Here we will be once again fetching all users with role 'administrator' and assigns the admin id as commerce store target id.

/**
 * Implements hook_entity_presave().
 */
function custom_module_entity_presave($entity, $type) {
  if ($type == 'commerce_store') {
    $members = array();
    if (isset($entity->cmp_m_store[LANGUAGE_NONE])) {
      foreach ($entity->cmp_m_store[LANGUAGE_NONE] as $item) {
        if (isset($item['target_id'])) {
          $members[] = $item['target_id'];
        }
      }
    }

    $query = db_select('users', 'users');
    $query->innerJoin('users_roles', 'users_roles', 'users_roles.uid = users.uid');
    $query->innerJoin('role', 'role', 'role.rid = users_roles.rid');
    $query->condition('role.name', 'administrator');
    $query->fields('users', array('uid'));
    $rows = $query->execute();
    $admin_users_list = $rows->fetchAll();

    foreach ($admin_users_list as $admin_user) {
      if (!in_array($admin_user->uid, $members)) {
        $entity->cmp_m_store[LANGUAGE_NONE][]['target_id'] = $admin_user->uid;
      }
    }
  }
}

Implement hook_module_implements_alter hook for our purpose, we should ensure two things:

  1. Make sure entity_insert runs last when hook_entity_insert is invoked.
  2. Make sure entity_presave runs last when hook_entity_presave is invoked.
/**
 * Implement hook_module_implements_alter().
 */
function custom_module_module_implements_alter(&$implementations, $hook) {
  // Testing with isset is only necessary if module doesn't implement the hook.
  if ($hook == 'entity_insert') {
    // Move our hook implementations to the bottom.
    $group = $implementations['custom_module'];
    unset($implementations['custom_module']);
    $implementations['custom_module'] = $group;
  }
  if ($hook == 'entity_presave') {
    // Move our hook implementations to the bottom.
    $group = $implementations['custom_module'];
    unset($implementations['custom_module']);
    $implementations['custom_module'] = $group;
  }
}

The above hook implementation helps to order the implementation in reverse order, using &$implementations we could get the module implementations done here in our example, say 'example_custom', which will be stored inside the $group variable. After we will unset all the implementations in 'custom_module', the re-assigns the implementations stored in '$group'.

Following this method, we could add members in commerce store with admin role.

We can help you further in Setting up and configuring Ubercart and Drupal Commerce in your Drupal Site. We offer a wide range of Drupal services to help you maintain and manage your Drupal websites. Get in touch with us to find more.


RELATED ARTICLE

/themes/custom/zyxpro_light/images/placeholder.png
close

on 01st January 2008 / by webmaster
We have added a few new modules to our site recently. Open Source Web Development Drupal Blogging Free Software Drupalgive Leave a reply Your email address will not be published. Required fields are marked * Sean (not verified) access_time 23 Sep 2019 - 05:58 Hi there, I uploaded the files, enabled the modules to use SU, and now I see the link, but there is no icon... How can I fix this? Thanks, Sean webmaster access_time 23 Sep 2019 - 05:58 In reply to Icon doesn't show by Sean (not verified) What do you see when you view the source? Search for stumblethis_button and you should be able to see the code for the image and the URL. Then you should be able to troubleshoot from there. Juicy Couture Addict (not verified) access_time 23 Sep 2019 - 05:58 thanks for the post. would love to hear more of you. by the way, drupal's really popular nowadays as it has easy and fast features. you agree with me? thanks. Add new comment
/themes/custom/zyxpro_light/images/placeholder.png
more_horiz
close

on 16th January 2008 / by webmaster
Most webmasters do not realize this, but a lot of the content on lot of websites can be accessed from multiple URLs. A simple example would be where www.example.com and example.com leads to the same page. This is a fatal mistake in Search Engine Optimization and search engines penalize you for duplicate content. The correct configuration would be where the above two urls will lead you to the same page but example.com will redirect you to www.example.com with a 301 (Moved permanently) status which will not result in search engines penalizing the page. It is very easy to configure 301 redirects using Apache .htaccess file and the process is the same for a Drupal installation also. Web Development Drupal SEO Drupal Planet Leave a reply Your email address will not be published. Required fields are marked * Anonymous (not verified) access_time 23 Sep 2019 - 14:27 Hello. I'm trying to make example.com show as www.example.com, and I'm running into difficulties. I'm on Apache 2.0 and using the following lines in my httpd.conf file: RewriteEngine on RewriteCond %{HTTP_HOST} ^xxxxxxxxxx\.com$ [NC] RewriteRule ^(.*)$ http://www.xxxxxxxxxx.com/$1 [L,R=301] When I go to http://xxxxxxxxxx.com, I get http://www.xxxxxxxxxx.com (as expected). However, when I go to http://xxxxxxxxxx.com/node/1 (it's a Drupal site), I get a 404 thrown and the URL changes to xxxxxxxxxx.com/var/www/drupal/node/1. Same thing with www.xxxxxxxxxx.com/node/1. Any suggestions? I want to run without Drupal's .htaccess file (instead incorporating these calls into my httpd.conf file). webmaster access_time 23 Sep 2019 - 14:27 In reply to Rewrite including filesystem path by Anonymous (not verified) I think the problem is with the base path which results in the redirection to /var/www/ part. The best approach I would think is to start with drupal htaccess and then strip out parts and move to httpd SNVC (not verified) access_time 23 Sep 2019 - 14:27 This is definitely a good guide. Thanks for this. wellyson access_time 23 Sep 2019 - 14:27 This is really nice and helpful. Add new comment
/themes/custom/zyxpro_light/images/placeholder.png
close

on 07th January 2008 / by webmaster
We have volunteered to take up the maintenance of a very useful Drupal module - Search404. As of today we are the official maintainers of this very useful Drupal module. We know that this is going to be a challenge for us, being a young company and with a young team. But we do feel that it is our responsibility to give back to the Drupal community at least some part of what it has given us. Open Source Web Development Drupal Leave a reply Your email address will not be published. Required fields are marked * ian douglas (not verified) access_time 23 Sep 2019 - 05:58 I notice your updates on the Drupal modules page has some patch files, but they are patches for an older version of the 5.x branch of search404. Do you have any expectation on when a version for Drupal 6 will be ready? webmaster access_time 23 Sep 2019 - 05:58 In reply to when will search404 for drupal 6 be ready? by ian douglas (not verified) Hi Ian, We are currently working on moving Search404 to Drupal 6. The port has already been done and we should have a release up on drupal.org by tomorrow or worst case by monday. Cheers Anoop John Team Zyxware Dejan (not verified) access_time 23 Sep 2019 - 05:58 In reply to when will search404 for drupal 6 be ready? by ian douglas (not verified) I think that's been up for a while... did you check the download page? Add new comment
Leave a reply
Your email address will not be published. Required fields are marked *

Filtered HTML

  • Web page addresses and email addresses turn into links automatically.
  • Allowed HTML tags: <a href hreflang> <em> <strong> <cite> <blockquote cite> <code> <ul type> <ol start type='1 A I'> <li> <dl> <dt> <dd> <h2 id='jump-*'> <h3 id> <h4 id> <h5 id> <h6 id>
  • Lines and paragraphs break automatically.
The content of this field is kept private and will not be shown publicly.
CAPTCHA This question is for testing whether or not you are a human visitor and to prevent automated spam submissions.