Add database queries for FAS group mapping

1 files changed, 29 insertions, 1 deletions

diff --git a/authfas.module b/authfas.module
index f7f5c99..382c5cb 100644
--- a/authfas.module
+++ b/authfas.module
@@ -191,7 +191,35 @@ function authfas_form_user_admin_role_alter(&$form, $form_state) {
 
 // Next, add functions to update the database.
 function authfas_user_admin_role_submit($form, &$form_state) {
-  // FIXME: Add database queries here
+  $fasgroup = $form_state['values']['fasgroup'];
+  $rid = $form_state['values']['rid'];
+  $name = $form_state['values']['name'];
+  $op = $form_state['values']['op'];
+  $current = db_result(db_query("SELECT fasgroup FROM {authfas_ridmap} WHERE rid = %d;", $form_state['values']['rid']));
+
+  // If we're deleting a role or removing the FAS group, delete the row.
+  if (($op == t('Delete role')) or ($fasgroup == '')) {
+    $result = db_query("DELETE FROM {authfas_ridmap} WHERE rid = %d", $rid);
+    if ($result) {
+      drupal_set_message(t('The role has been removed from the FAS group map.'));
+    } else {
+      form_set_error("DB error");
+    }
+  } // End delete
+  // If we're saving a role, update the row.
+  else if (($op == t('Save role')) and (isset($fasgroup))) {
+    if ($current == '') { // Wasn't mapped before
+      $result = db_query("INSERT INTO {authfas_ridmap} (rid, fasgroup) VALUES (%d, '%s')", $rid, $fasgroup);
+      if ($result) {
+        drupal_set_message('The role has been mapped to FAS group '.$fasgroup.'.');
+      } else { form_set_error("DB error"); }
+    } else { // Was mapped before
+      $result = db_query("UPDATE {authfas_ridmap} SET fasgroup = '%s' WHERE rid = %d", $fasgroup, $rid);
+      if ($result) { 
+        drupal_set_message('The role has been mapped to FAS group '.$fasgroup.'.'); 
+      } else { form_set_error("DB error"); }
+    } // End mapped before
+  } // End insert/update
 }
 
 // Local variables: