private $query_main;
private $query_membership;
private $query_staff;
+
private $query_nomination_process_donations;
private $query_nomination_process_gift_receipt;
+ private $query_nomination_process_adhoc;
+
+ private $query_discussion_process_donations;
+ private $query_discussion_process_gift_receipt;
+ private $query_discussion_process_adhoc;
/**
- * Date for determining whether someone may participate in board nomination
- * process
+ * SQL query parameters, or variables that help determine which attributes
+ * someone has
*/
+ private $fsf_org_id;
+ private $gift_redeem_page_id;
+
+ private $nomination_process_active;
private $nomination_process_contrib_start_date;
private $nomination_process_contrib_end_date;
+ private $nomination_process_adhoc_access_group_id;
+ private $membership_monthly_rate;
+ private $student_membership_monthly_rate;
+
+ private $discussion_process_active;
+ private $discussion_process_contrib_start_date;
+ private $discussion_process_contrib_end_date;
+ private $discussion_process_adhoc_access_group_id;
+ private $discussion_process_adhoc_no_access_group_id;
/**
* Constructor for this authentication source.
parent::__construct($info, $config);
// Make sure that all required parameters are present.
- foreach (['dsn', 'username', 'password', 'query_main', 'query_membership', 'query_staff', 'query_nomination_process_donations', 'query_nomination_process_gift_receipt', 'nomination_process_contrib_start_date', 'nomination_process_contrib_end_date'] as $param) {
+ foreach (['dsn',
+ 'username',
+ 'password',
+
+ 'query_main',
+ 'query_membership',
+ 'query_staff',
+
+ 'query_nomination_process_donations',
+ 'query_nomination_process_gift_receipt',
+ 'query_nomination_process_adhoc',
+
+ 'fsf_org_id',
+ 'gift_redeem_page_id',
+
+ 'nomination_process_active',
+ 'nomination_process_contrib_start_date',
+ 'nomination_process_contrib_end_date',
+ 'nomination_process_adhoc_access_group_id',
+ 'membership_monthly_rate',
+ 'student_membership_monthly_rate',
+
+ 'query_discussion_process_donations',
+ 'query_discussion_process_gift_receipt',
+ 'query_discussion_process_adhoc',
+
+ 'discussion_process_active',
+ 'discussion_process_contrib_start_date',
+ 'discussion_process_contrib_end_date',
+ 'discussion_process_adhoc_access_group_id',
+ 'discussion_process_adhoc_no_access_group_id',]
+ as $param) {
+
if (!array_key_exists($param, $config)) {
throw new Exception('Missing required attribute \''.$param.
'\' for authentication source '.$this->authId);
' to be a string. Instead it was: '.
var_export($config[$param], true));
}
+
+ $this->$param = $config[$param];
}
- $this->dsn = $config['dsn'];
- $this->username = $config['username'];
- $this->password = $config['password'];
- $this->query_main = $config['query_main'];
- $this->query_membership = $config['query_membership'];
- $this->query_staff = $config['query_staff'];
- $this->query_nomination_process_donations = $config['query_nomination_process_donations'];
- $this->query_nomination_process_gift_receipt = $config['query_nomination_process_gift_receipt'];
- $this->nomination_process_contrib_start_date = $config['nomination_process_contrib_start_date'];
- $this->nomination_process_contrib_end_date = $config['nomination_process_contrib_end_date'];
if (isset($config['options'])) {
$this->options = $config['options'];
}
$return_value = proc_close($process);
//Logger::debug('fsfdrupalauth:'.$this->authId.': authenticator stdout: '.$result);
-
+
$errors_found_yet = false;
if ($errors != "") {
Logger::error('fsfdrupalauth:'.$this->authId.': authenticator stderr: '.$errors);
$errors_found_yet = true;
}
-
+
if ($return_value != 0) {
Logger::error('fsfdrupalauth:'.$this->authId.': authenticator non-zero return code: '.$return_value);
$errors_found_yet = true;
}
-
+
return (!$errors_found_yet && is_string($result) && rtrim($result) == "true");
} else {
}
//
- // query for access to board nomination process
+ // helper functions for access to board nomination / discussion process
//
- $start_date = $this->nomination_process_contrib_start_date;
- $end_date = $this->nomination_process_contrib_end_date;
-
/**
* @param string $query_name Name of query in authsources
- * @param number $amount Amount to compare result to
- * @param boolean $all_contribs Pass as 'all_contribs' param. The var may also be null to exclude it
- * @param boolean $gift_redeem_page Pass as 'gift_redeem_page' param. The var may also be null to exclude it
+ * @param array $extra_params Associative array of parameters to include in query
*/
- $meets_a_donation_criterion = function ($query_name, $amount, $all_contribs, $gift_redeem_page)
- use ($username, $start_date, $end_date, $attributes) {
+ $donation_query = function ($query_name, $extra_params)
+ use ($username) {
- $parameters =
- ['username' => $username,
- 'start_date' => $start_date,
- 'end_date' => $end_date];
+ $parameters = ['username' => $username];
- if ($all_contribs !== null) {
- $parameters['all_contribs'] = $all_contribs;
- }
- if ($gift_redeem_page !== null) {
- $parameters['gift_redeem_page'] = $gift_redeem_page;
+ foreach ($extra_params as $key => $value) {
+ $parameters[$key] = $value;
}
- $result = $this->query_db($query_name, $parameters);
+ return $this->query_db($query_name, $parameters);
+ };
+ $compare_res = function ($result, $amount) {
foreach ($result[0] as $key => $value) {
- if ($value < $amount) {
- continue;
- } elseif ($attributes['is_member'] == ['true']) {
- return true;
- }
+ if (intval($value) >= $amount) {
+ return true;
+ }
}
+ return false;
+ };
+ // looks for memberships / comparable donations in time window. also
+ // looks for a membership or donation (included as a param) that
+ // occurred up to a year before, and that would have carried over into
+ // the time window with a single donation. this approximates whether
+ // the person was, or would have been, a member during the configured
+ // time window.
+ $nomination_process_analyze_history = function ($selective_donations_history)
+ use ($start_date, $end_date) {
+
+ $eligible = false;
+
+ $start_date_obj = new \DateTime($start_date);
+ $end_date_obj = new \DateTime($end_date);
+
+ foreach ($selective_donations_history as $row) {
+
+ $amount = intval($row['amount']);
+ $member_type_id = $row['member_type_id'];
+ $receive_date_obj = new \DateTime($row['receive_date']);
+
+ if ($amount < 5) {
+ continue;
+
+ } elseif ($receive_date_obj >= $start_date_obj and $receive_date_obj <= $end_date_obj) {
+ return true;
+
+ } elseif ($receive_date_obj < $start_date_obj) {
+ switch ($member_type_id) {
+ case '1':
+ case '2':
+ $rate = intval($this->student_membership_monthly_rate);
+ break;
+ case '8':
+ case '9':
+ case null:
+ default:
+ $rate = intval($this->membership_monthly_rate);
+ break;
+ }
+ $membership_end_date_obj = new \DateTime($row['receive_date']);
+ $membership_end_date_obj->add(new \DateInterval("P" . ceil($amount / $rate) . "M"));
+
+ if ($membership_end_date_obj >= $start_date_obj) {
+ return true;
+ }
+ }
+ }
return false;
};
- if ($meets_a_donation_criterion('query_nomination_process_donations', 5, true, null)
- || $meets_a_donation_criterion('query_nomination_process_donations', 5, false, null)
- || $meets_a_donation_criterion('query_nomination_process_gift_receipt', 1, null, 63)) {
+ $discussion_process_analyze_history = function ($selective_donations_history)
+ use ($start_date, $end_date) {
+
+ $eligible = false;
+ $total = 0;
+
+ $start_date_obj = new \DateTime($start_date);
+ $end_date_obj = new \DateTime($end_date);
+
+ foreach ($selective_donations_history as $row) {
+
+ $amount = intval($row['amount']);
+ $member_type_id = $row['member_type_id'];
+ $receive_date_obj = new \DateTime($row['receive_date']);
+
+ if (($receive_date_obj > $start_date_obj) && ($receive_date < $end_date_obj)) {
+ $total += $amount;
+ }
+ }
+
+ if ($total >= 120) {
+ return true;
+ } else {
+ return false;
+ }
+ };
+
+ //
+ // nomination form participation specific checks
+ //
+
+ $start_date = $this->nomination_process_contrib_start_date;
+ $end_date = $this->nomination_process_contrib_end_date;
+
+ $donation_params = ['start_date' => $start_date, 'end_date' => $end_date];
+ $gift_member_params = ['start_date' => $start_date, 'end_date' => $end_date, 'gift_redeem_page_id' => intval($this->gift_redeem_page_id)];
+ $adhoc_params = ['adhoc_access_group_id' => intval($this->nomination_process_adhoc_access_group_id)];
+
+ if ($this->nomination_process_active != 'true' ) {
+ $attributes['nomination_process'] = ['false'];
+
+ } elseif ($compare_res($donation_query('query_nomination_process_adhoc', $adhoc_params), 1)) {
+ $attributes['nomination_process'] = ['true'];
+
+ } elseif ($attributes['is_member'] != ['true']) {
+ Logger::debug('fsfdrupalauth:'.$this->authId.
+ ': Not a member / comparable donor during window for board process.');
+ $attributes['nomination_process'] = ['false'];
+
+ } elseif ($nomination_process_analyze_history($donation_query('query_nomination_process_donations', $donation_params))
+ || $compare_res($donation_query('query_nomination_process_gift_receipt', $gift_member_params), 1)) {
$attributes['nomination_process'] = ['true'];
+
} else {
+ Logger::debug('fsfdrupalauth:'.$this->authId.
+ ': Not a member / comparable donor during window for board process.');
$attributes['nomination_process'] = ['false'];
}
+ //
+ // discussion form participation specific checks
+ //
+
+ $start_date = $this->discussion_process_contrib_start_date;
+ $end_date = $this->discussion_process_contrib_end_date;
+
+ $donation_params = ['start_date' => $start_date, 'end_date' => $end_date];
+ $gift_member_params = ['start_date' => $start_date, 'end_date' => $end_date, 'gift_redeem_page_id' => intval($this->gift_redeem_page_id)];
+ $adhoc_params = ['adhoc_access_group_id' => intval($this->discussion_process_adhoc_access_group_id)];
+ $adhoc_params_no = ['adhoc_access_group_id' => intval($this->discussion_process_adhoc_no_access_group_id)];
+
+ if ($this->discussion_process_active != 'true' ) {
+ $attributes['discussion_process'] = ['false'];
+
+ } elseif ($compare_res($donation_query('query_discussion_process_adhoc', $adhoc_params_no), 1)) {
+ Logger::debug('fsfdrupalauth:'.$this->authId.
+ ': Nominee not eligible for board nominee discussion process.');
+ $attributes['discussion_process'] = ['false'];
+
+ } elseif ($compare_res($donation_query('query_discussion_process_adhoc', $adhoc_params), 1)) {
+ $attributes['discussion_process'] = ['true'];
+
+ } elseif ($attributes['is_member'] != ['true']) {
+ Logger::debug('fsfdrupalauth:'.$this->authId.
+ ': Not eligible for board nominee discussion process.');
+ $attributes['discussion_process'] = ['false'];
+
+ } elseif ($discussion_process_analyze_history($donation_query('query_discussion_process_donations', $donation_params))
+ || $compare_res($donation_query('query_discussion_process_gift_receipt', $gift_member_params), 1)) {
+
+ $attributes['discussion_process'] = ['true'];
+
+ } else {
+ Logger::debug('fsfdrupalauth:'.$this->authId.
+ ': Not eligible for board nominee discussion process.');
+ $attributes['discussion_process'] = ['false'];
+ }
+
//
// query on staff
//
- $staff_data = $this->query_db('query_staff', ['username' => $username]);
+ $staff_data = $this->query_db('query_staff', ['username' => $username, 'fsf_org_id' => $this->fsf_org_id]);
if (count($staff_data) === 0) {
// No rows returned - invalid username
}
$value = (string) $value;
- if ($value === $username) {
+ if (strtolower($value) === strtolower($username)) {
// they are staff
- $attributes[$key] = ['true'];
+ $attributes['is_fsf_staff'] = ['true'];
break;
}
}