[civicrm-core.git] / CRM / Core / BAO / CMSUser.php

<?php
/*
 +--------------------------------------------------------------------+
 | CiviCRM version 4.5                                                |
 +--------------------------------------------------------------------+
 | Copyright CiviCRM LLC (c) 2004-2014                                |
 +--------------------------------------------------------------------+
 | This file is a part of CiviCRM.                                    |
 |                                                                    |
 | CiviCRM is free software; you can copy, modify, and distribute it  |
 | under the terms of the GNU Affero General Public License           |
 | Version 3, 19 November 2007 and the CiviCRM Licensing Exception.   |
 |                                                                    |
 | CiviCRM is distributed in the hope that it will be useful, but     |
 | WITHOUT ANY WARRANTY; without even the implied warranty of         |
 | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.               |
 | See the GNU Affero General Public License for more details.        |
 |                                                                    |
 | You should have received a copy of the GNU Affero General Public   |
 | License and the CiviCRM Licensing Exception along                  |
 | with this program; if not, contact CiviCRM LLC                     |
 | at info[AT]civicrm[DOT]org. If you have questions about the        |
 | GNU Affero General Public License or the licensing of CiviCRM,     |
 | see the CiviCRM license FAQ at http://civicrm.org/licensing        |
 +--------------------------------------------------------------------+
*/

/**
 *
 * @package CRM
 * @copyright CiviCRM LLC (c) 2004-2014
 * $Id$
 *
 */

/**
 *  this file contains functions for synchronizing cms users with CiviCRM contacts
 */

require_once 'DB.php';

/**
 * Class CRM_Core_BAO_CMSUser
 */
class CRM_Core_BAO_CMSUser {

  /**
   * Function for synchronizing cms users with CiviCRM contacts
   *
   * @param bool $is_interactive whether to show statuses & perform redirects
   *   This behavior is misplaced in the BAO layer, but we'll preserve it to avoid
   *   contract changes in the middle of the support cycle. In the next major
   *   release, we should remove & document it.
   *
   * @return void
   *
   * @static
   * @access public
   */
  static function synchronize($is_interactive = TRUE) {
    //start of schronization code
    $config = CRM_Core_Config::singleton();

    // Build an array of rows from UF users table.
    $rows = array();
    if ($config->userSystem->is_drupal == '1') {
      $id   = 'uid';
      $mail = 'mail';
      $name = 'name';

      $result = db_query("SELECT uid, mail, name FROM {users} where mail != ''");

      if ($config->userFramework == 'Drupal') {
        while ($row = $result->fetchAssoc()) {
          $rows[] = $row;
        }
      }
      elseif ($config->userFramework == 'Drupal6') {
        while ($row = db_fetch_array($result)) {
          $rows[] = $row;
        }
      }
    }
    elseif ($config->userFramework == 'Joomla') {
      $id   = 'id';
      $mail = 'email';
      $name = 'name';
      // TODO: Insert code here to populate $rows for Joomla;
    }
    elseif ($config->userFramework == 'WordPress') {
      $id = 'ID';
      $mail = 'user_email';
    }
    else {
      CRM_Core_Error::fatal('CMS user creation not supported for this framework');
    }

    set_time_limit(300);

    if ($config->userSystem->is_drupal == '1') {
      $user            = new StdClass();
      $uf              = $config->userFramework;
      $contactCount    = 0;
      $contactCreated  = 0;
      $contactMatching = 0;
      foreach ($rows as $row) {
        $user->$id   = $row[$id];
        $user->$mail = $row[$mail];
        $user->$name = $row[$name];
        $contactCount++;
        if ($match = CRM_Core_BAO_UFMatch::synchronizeUFMatch($user, $row[$id], $row[$mail], $uf, 1, 'Individual', TRUE)) {
          $contactCreated++;
        }
        else {
          $contactMatching++;
        }
        if (is_object($match)) {
          $match->free();
        }
      }
    }
    elseif ($config->userFramework == 'Joomla') {

      $JUserTable = &JTable::getInstance('User', 'JTable');

      $db = $JUserTable->getDbo();
      $query = $db->getQuery(TRUE);
      $query->select($id . ', ' . $mail . ', ' . $name);
      $query->from($JUserTable->getTableName());
      $query->where($mail != '');

      $db->setQuery($query, 0, $limit);
      $users = $db->loadObjectList();

      $user            = new StdClass();
      $uf              = $config->userFramework;
      $contactCount    = 0;
      $contactCreated  = 0;
      $contactMatching = 0;
      for ($i = 0; $i < count($users); $i++) {
        $user->$id   = $users[$i]->$id;
        $user->$mail = $users[$i]->$mail;
        $user->$name = $users[$i]->$name;
        $contactCount++;
        if ($match = CRM_Core_BAO_UFMatch::synchronizeUFMatch($user,
            $users[$i]->$id,
            $users[$i]->$mail,
            $uf,
            1,
            'Individual',
            TRUE
          )) {
          $contactCreated++;
        }
        else {
          $contactMatching++;
        }
        if (is_object($match)) {
          $match->free();
        }
      }
    }
    elseif ($config->userFramework == 'WordPress') {
      $uf              = $config->userFramework;
      $contactCount    = 0;
      $contactCreated  = 0;
      $contactMatching = 0;

      global $wpdb;
      $wpUserIds = $wpdb->get_col("SELECT $wpdb->users.ID FROM $wpdb->users");

      foreach ($wpUserIds as $wpUserId) {
        $wpUserData = get_userdata($wpUserId);
        $contactCount++;
        if ($match = CRM_Core_BAO_UFMatch::synchronizeUFMatch($wpUserData,
            $wpUserData->$id,
            $wpUserData->$mail,
            $uf,
            1,
            'Individual',
            TRUE
          )) {
          $contactCreated++;
        }
        else {
          $contactMatching++;
        }
        if (is_object($match)) {
          $match->free();
        }
      }
    }
    //end of synchronization code

    if ($is_interactive) {
      $status = ts('Synchronize Users to Contacts completed.');
      $status .= ' ' . ts('Checked one user record.',
        array(
          'count' => $contactCount,
          'plural' => 'Checked %count user records.'
        )
      );
      if ($contactMatching) {
        $status .= ' ' . ts('Found one matching contact record.',
          array(
            'count' => $contactMatching,
            'plural' => 'Found %count matching contact records.'
          )
        );
      }

      $status .= ' ' . ts('Created one new contact record.',
        array(
          'count' => $contactCreated,
          'plural' => 'Created %count new contact records.'
        )
      );
      CRM_Core_Session::setStatus($status, ts('Saved'), 'success');
      CRM_Utils_System::redirect(CRM_Utils_System::url('civicrm/admin', 'reset=1'));
    }
  }

  /**
   * Function to create CMS user using Profile
   *
   * @param array  $params associated array
   * @param string $mail email id for cms user
   *
   * @return int contact id that has been created
   * @access public
   * @static
   */
  static function create(&$params, $mail) {
    $config = CRM_Core_Config::singleton();

    $ufID = $config->userSystem->createUser($params, $mail);

    //if contact doesn't already exist create UF Match
    if ($ufID !== FALSE &&
      isset($params['contactID'])
    ) {
      // create the UF Match record
      $ufmatch             = new CRM_Core_DAO_UFMatch();
      $ufmatch->domain_id  = CRM_Core_Config::domainID();
      $ufmatch->uf_id      = $ufID;
      $ufmatch->contact_id = $params['contactID'];
      $ufmatch->uf_name    = $params[$mail];

      if (!$ufmatch->find(TRUE)) {
        $ufmatch->save();
      }
    }

    return $ufID;
  }

  /**
   * Function to create Form for CMS user using Profile
   *
   * @param object $form
   * @param integer $gid id of group of profile
   * @param bool $emailPresent true if the profile field has email(primary)
   * @param \const|int $action
   *
   * @return FALSE|void WTF
   *
   * @access public
   * @static
   */
  static function buildForm(&$form, $gid, $emailPresent, $action = CRM_Core_Action::NONE) {
    $config = CRM_Core_Config::singleton();
    $showCMS = FALSE;

    $isDrupal    = $config->userSystem->is_drupal;
    $isJoomla    = ucfirst($config->userFramework) == 'Joomla' ? TRUE : FALSE;
    $isWordPress = $config->userFramework == 'WordPress' ? TRUE : FALSE;

    //if CMS is configured for not to allow creating new CMS user,
    //don't build the form,Fixed for CRM-4036
    if ($isJoomla) {
      $userParams = JComponentHelper::getParams('com_users');
      if (!$userParams->get('allowUserRegistration')) {
        return FALSE;
      }
    }
    elseif ($isDrupal && !variable_get('user_register', TRUE)) {
      return FALSE;
    }
    elseif ($isWordPress && !get_option('users_can_register')) {
      return FALSE;
    }

    if ($gid) {
      $isCMSUser = CRM_Core_DAO::getFieldValue('CRM_Core_DAO_UFGroup', $gid, 'is_cms_user');
    }

    // $cms is true when there is email(primary location) is set in the profile field.
    $session = CRM_Core_Session::singleton();
    $userID = $session->get('userID');
    $showUserRegistration = FALSE;
    if ($action) {
      $showUserRegistration = TRUE;
    }
    elseif (!$action && !$userID) {
      $showUserRegistration = TRUE;
    }

    if ($isCMSUser && $emailPresent) {
      if ($showUserRegistration) {
        if ($isCMSUser != 2) {
          $extra = array(
            'onclick' => "return showHideByValue('cms_create_account','','details','block','radio',false );",
          );
          $form->addElement('checkbox', 'cms_create_account', ts('Create an account?'), NULL, $extra);
          $required = FALSE;
        }
        else {
          $form->add('hidden', 'cms_create_account', 1);
          $required = TRUE;
        }

        $form->assign('isCMS', $required);
        if (!$userID || $action & CRM_Core_Action::PREVIEW || $action & CRM_Core_Action::PROFILE) {
          $form->add('text', 'cms_name', ts('Username'), NULL, $required);
          if (($isDrupal && !variable_get('user_email_verification', TRUE)) OR ($isJoomla) OR ($isWordPress)) {
            $form->add('password', 'cms_pass', ts('Password'));
            $form->add('password', 'cms_confirm_pass', ts('Confirm Password'));
          }

          $form->addFormRule(array('CRM_Core_BAO_CMSUser', 'formRule'), $form);
        }
        $showCMS = TRUE;
      }
    }

    $destination = $config->userSystem->getLoginDestination($form);
    $loginURL = $config->userSystem->getLoginURL($destination);
    $form->assign('loginURL', $loginURL);
    $form->assign('showCMS', $showCMS);
  }

  /*
   * Checks that there is a valid username & email
   *  optionally checks password is present & matches DB & gets the CMS to validate
   *
   *  @params array $fields Posted values of form
   *  @param  array $files uploaded files if any
   *  @param array $self reference to form object
   *
   */
  /**
   * @param $fields
   * @param $files
   * @param $self
   *
   * @return array|bool
   */
  static function formRule($fields, $files, $self) {
    if (empty($fields['cms_create_account'])) {
      return TRUE;
    }

    $config = CRM_Core_Config::singleton();

    $isDrupal    = $config->userSystem->is_drupal;
    $isJoomla    = ucfirst($config->userFramework) == 'Joomla' ? TRUE : FALSE;
    $isWordPress = $config->userFramework == 'WordPress' ? TRUE : FALSE;

    $errors = array();
    if ($isDrupal || $isJoomla || $isWordPress) {
      $emailName = NULL;
      if (!empty($self->_bltID) && array_key_exists("email-{$self->_bltID}", $fields)) {
        // this is a transaction related page
        $emailName = 'email-' . $self->_bltID;
      } else {
        // find the email field in a profile page
        foreach ($fields as $name => $dontCare) {
          if (substr($name, 0, 5) == 'email') {
            $emailName = $name;
            break;
          }
        }
      }

      if ($emailName == NULL) {
        $errors['_qf_default'] == ts('Could not find an email address.');
        return $errors;
      }

      if (empty($fields['cms_name'])) {
        $errors['cms_name'] = ts('Please specify a username.');
      }

      if (empty($fields[$emailName])) {
        $errors[$emailName] = ts('Please specify a valid email address.');
      }

      if (($isDrupal && !variable_get('user_email_verification', TRUE)) OR ($isJoomla) OR ($isWordPress)) {
        if (empty($fields['cms_pass']) ||
          empty($fields['cms_confirm_pass'])
        ) {
          $errors['cms_pass'] = ts('Please enter a password.');
        }
        if ($fields['cms_pass'] != $fields['cms_confirm_pass']) {
          $errors['cms_pass'] = ts('Password and Confirm Password values are not the same.');
        }
      }

      if (!empty($errors)) {
        return $errors;
      }

      // now check that the cms db does not have the user name and/or email
      if ($isDrupal OR $isJoomla OR $isWordPress) {
        $params = array(
          'name' => $fields['cms_name'],
          'mail' => $fields[$emailName],
        );
      }

      $config->userSystem->checkUserNameEmailExists($params, $errors, $emailName);
    }
    return (!empty($errors)) ? $errors : TRUE;
  }

  /**
   * Function to check if a cms user already exists.
   *
   * @param  Array $contact array of contact-details
   *
   * @return uid if user exists, false otherwise
   *
   * @access public
   * @static
   */
  static function userExists(&$contact) {
    $config = CRM_Core_Config::singleton();

    $isDrupal    = $config->userSystem->is_drupal;
    $isJoomla    = ucfirst($config->userFramework) == 'Joomla' ? TRUE : FALSE;
    $isWordPress = $config->userFramework == 'WordPress' ? TRUE : FALSE;

    if (!$isDrupal && !$isJoomla && !$isWordPress) {
      die('Unknown user framework');
    }

    // Use UF native framework to fetch data from UF user table
    if ($isDrupal) {
      $uid = db_query(
        "SELECT uid FROM {users} where mail = :email",
        array(':email' => $contact['email'])
      )->fetchField();

      if ($uid) {
        $contact['user_exists'] = TRUE;
        $result = $uid;
      }
    }
    elseif ($isJoomla) {
      $mail = $contact['email'];

      $JUserTable = &JTable::getInstance('User', 'JTable');

      $db = $JUserTable->getDbo();
      $query = $db->getQuery(TRUE);
      $query->select('username, email');
      $query->from($JUserTable->getTableName());
      $query->where('(LOWER(email) = LOWER(\'' . $email . '\'))');
      $db->setQuery($query, 0, $limit);
      $users = $db->loadAssocList();

      $row = array();;
      if (count($users)) {
        $row = $users[0];
      }

      if (!empty($row)) {
        $uid = CRM_Utils_Array::value('id', $row);
        $contact['user_exists'] = TRUE;
        $result = $uid;
      }
    }
    elseif ($isWordPress) {
      if (email_exists($params['mail'])) {
        $contact['user_exists'] = TRUE;
        $userObj = get_user_by('email', $params['mail']);
        return $userObj->ID;
      }
    }

    return $result;
  }

  /**
   * @param $config
   *
   * @return object
   */
  static function &dbHandle(&$config) {
    $errorScope = CRM_Core_TemporaryErrorScope::ignoreException();
    $db_uf = DB::connect($config->userFrameworkDSN);
    unset($errorScope);
    if (!$db_uf ||
      DB::isError($db_uf)
    ) {
      $session = CRM_Core_Session::singleton();
      $session->pushUserContext(CRM_Utils_System::url('civicrm/admin', 'reset=1'));
      CRM_Core_Error::statusBounce(ts("Cannot connect to UF db via %1. Please check the CIVICRM_UF_DSN value in your civicrm.settings.php file",
          array(1 => $db_uf->getMessage())
        ));
    }
    $db_uf->query('/*!40101 SET NAMES utf8 */');
    return $db_uf;
  }
}
Commit	Line	Data
6a488035 TO	1	<?php
	2	/*
	3	+--------------------------------------------------------------------+
06b69b18	4	\| CiviCRM version 4.5 \|
6a488035	5	+--------------------------------------------------------------------+
06b69b18	6	\| Copyright CiviCRM LLC (c) 2004-2014 \|
6a488035 TO	7	+--------------------------------------------------------------------+
	8	\| This file is a part of CiviCRM. \|
	9	\| \|
	10	\| CiviCRM is free software; you can copy, modify, and distribute it \|
	11	\| under the terms of the GNU Affero General Public License \|
	12	\| Version 3, 19 November 2007 and the CiviCRM Licensing Exception. \|
	13	\| \|
	14	\| CiviCRM is distributed in the hope that it will be useful, but \|
	15	\| WITHOUT ANY WARRANTY; without even the implied warranty of \|
	16	\| MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. \|
	17	\| See the GNU Affero General Public License for more details. \|
	18	\| \|
	19	\| You should have received a copy of the GNU Affero General Public \|
	20	\| License and the CiviCRM Licensing Exception along \|
	21	\| with this program; if not, contact CiviCRM LLC \|
	22	\| at info[AT]civicrm[DOT]org. If you have questions about the \|
	23	\| GNU Affero General Public License or the licensing of CiviCRM, \|
	24	\| see the CiviCRM license FAQ at http://civicrm.org/licensing \|
	25	+--------------------------------------------------------------------+
	26	*/
	27
	28	/**
	29	*
	30	* @package CRM
06b69b18	31	* @copyright CiviCRM LLC (c) 2004-2014
6a488035 TO	32	* $Id$
	33	*
	34	*/
	35
	36	/**
	37	* this file contains functions for synchronizing cms users with CiviCRM contacts
	38	*/
	39
	40	require_once 'DB.php';
b5c2afd0 EM	41
	42	/**
	43	* Class CRM_Core_BAO_CMSUser
	44	*/
6a488035 TO	45	class CRM_Core_BAO_CMSUser {
	46
	47	/**
	48	* Function for synchronizing cms users with CiviCRM contacts
	49	*
a1f7c05f TO	50	* @param bool $is_interactive whether to show statuses & perform redirects
	51	* This behavior is misplaced in the BAO layer, but we'll preserve it to avoid
	52	* contract changes in the middle of the support cycle. In the next major
	53	* release, we should remove & document it.
6a488035 TO	54	*
	55	* @return void
	56	*
	57	* @static
	58	* @access public
	59	*/
a1f7c05f	60	static function synchronize($is_interactive = TRUE) {
6a488035 TO	61	//start of schronization code
	62	$config = CRM_Core_Config::singleton();
	63
	64	// Build an array of rows from UF users table.
	65	$rows = array();
	66	if ($config->userSystem->is_drupal == '1') {
	67	$id = 'uid';
	68	$mail = 'mail';
	69	$name = 'name';
	70
	71	$result = db_query("SELECT uid, mail, name FROM {users} where mail != ''");
	72
	73	if ($config->userFramework == 'Drupal') {
	74	while ($row = $result->fetchAssoc()) {
	75	$rows[] = $row;
	76	}
	77	}
	78	elseif ($config->userFramework == 'Drupal6') {
	79	while ($row = db_fetch_array($result)) {
	80	$rows[] = $row;
	81	}
	82	}
	83	}
	84	elseif ($config->userFramework == 'Joomla') {
	85	$id = 'id';
	86	$mail = 'email';
	87	$name = 'name';
	88	// TODO: Insert code here to populate $rows for Joomla;
	89	}
	90	elseif ($config->userFramework == 'WordPress') {
	91	$id = 'ID';
	92	$mail = 'user_email';
	93	}
	94	else {
	95	CRM_Core_Error::fatal('CMS user creation not supported for this framework');
	96	}
	97
	98	set_time_limit(300);
	99
	100	if ($config->userSystem->is_drupal == '1') {
	101	$user = new StdClass();
	102	$uf = $config->userFramework;
	103	$contactCount = 0;
	104	$contactCreated = 0;
	105	$contactMatching = 0;
	106	foreach ($rows as $row) {
	107	$user->$id = $row[$id];
	108	$user->$mail = $row[$mail];
	109	$user->$name = $row[$name];
	110	$contactCount++;
	111	if ($match = CRM_Core_BAO_UFMatch::synchronizeUFMatch($user, $row[$id], $row[$mail], $uf, 1, 'Individual', TRUE)) {
	112	$contactCreated++;
	113	}
	114	else {
	115	$contactMatching++;
	116	}
	117	if (is_object($match)) {
	118	$match->free();
	119	}
	120	}
	121	}
	122	elseif ($config->userFramework == 'Joomla') {
	123
	124	$JUserTable = &JTable::getInstance('User', 'JTable');
125
126	$db = $JUserTable->getDbo();
127	$query = $db->getQuery(TRUE);
128	$query->select($id . ', ' . $mail . ', ' . $name);
129	$query->from($JUserTable->getTableName());
130	$query->where($mail != '');
131
132	$db->setQuery($query, 0, $limit);
133	$users = $db->loadObjectList();
134
135	$user = new StdClass();
136	$uf = $config->userFramework;
137	$contactCount = 0;
138	$contactCreated = 0;
139	$contactMatching = 0;
140	for ($i = 0; $i < count($users); $i++) {
141	$user->$id = $users[$i]->$id;
142	$user->$mail = $users[$i]->$mail;
143	$user->$name = $users[$i]->$name;
144	$contactCount++;
145	if ($match = CRM_Core_BAO_UFMatch::synchronizeUFMatch($user,
146	$users[$i]->$id,
147	$users[$i]->$mail,
148	$uf,
149	1,
150	'Individual',
151	TRUE
152	)) {
153	$contactCreated++;
154	}
155	else {
156	$contactMatching++;
157	}
158	if (is_object($match)) {
159	$match->free();
160	}
161	}
162	}
163	elseif ($config->userFramework == 'WordPress') {
164	$uf = $config->userFramework;
165	$contactCount = 0;
166	$contactCreated = 0;
167	$contactMatching = 0;
168
169	global $wpdb;
82d5bb05	170	$wpUserIds = $wpdb->get_col("SELECT $wpdb->users.ID FROM $wpdb->users");
6a488035 TO	171
	172	foreach ($wpUserIds as $wpUserId) {
	173	$wpUserData = get_userdata($wpUserId);
	174	$contactCount++;
	175	if ($match = CRM_Core_BAO_UFMatch::synchronizeUFMatch($wpUserData,
	176	$wpUserData->$id,
	177	$wpUserData->$mail,
	178	$uf,
	179	1,
	180	'Individual',
	181	TRUE
	182	)) {
	183	$contactCreated++;
	184	}
	185	else {
	186	$contactMatching++;
	187	}
	188	if (is_object($match)) {
	189	$match->free();
	190	}
	191	}
	192	}
a1f7c05f TO	193	//end of synchronization code
	194
	195	if ($is_interactive) {
	196	$status = ts('Synchronize Users to Contacts completed.');
	197	$status .= ' ' . ts('Checked one user record.',
6a488035	198	array(
a1f7c05f TO	199	'count' => $contactCount,
a1f7c05f TO	200	'plural' => 'Checked %count user records.'
6a488035 TO	201	)
6a488035 TO	202	);
a1f7c05f TO	203	if ($contactMatching) {
	204	$status .= ' ' . ts('Found one matching contact record.',
	205	array(
	206	'count' => $contactMatching,
	207	'plural' => 'Found %count matching contact records.'
	208	)
	209	);
	210	}
6a488035	211
a1f7c05f TO	212	$status .= ' ' . ts('Created one new contact record.',
	213	array(
	214	'count' => $contactCreated,
	215	'plural' => 'Created %count new contact records.'
	216	)
	217	);
	218	CRM_Core_Session::setStatus($status, ts('Saved'), 'success');
	219	CRM_Utils_System::redirect(CRM_Utils_System::url('civicrm/admin', 'reset=1'));
	220	}
6a488035 TO	221	}
	222
	223	/**
	224	* Function to create CMS user using Profile
	225	*
	226	* @param array $params associated array
	227	* @param string $mail email id for cms user
	228	*
	229	* @return int contact id that has been created
	230	* @access public
	231	* @static
	232	*/
	233	static function create(&$params, $mail) {
	234	$config = CRM_Core_Config::singleton();
	235
	236	$ufID = $config->userSystem->createUser($params, $mail);
	237
	238	//if contact doesn't already exist create UF Match
	239	if ($ufID !== FALSE &&
	240	isset($params['contactID'])
	241	) {
	242	// create the UF Match record
	243	$ufmatch = new CRM_Core_DAO_UFMatch();
	244	$ufmatch->domain_id = CRM_Core_Config::domainID();
	245	$ufmatch->uf_id = $ufID;
	246	$ufmatch->contact_id = $params['contactID'];
	247	$ufmatch->uf_name = $params[$mail];
	248
	249	if (!$ufmatch->find(TRUE)) {
	250	$ufmatch->save();
	251	}
	252	}
	253
	254	return $ufID;
	255	}
	256
	257	/**
	258	* Function to create Form for CMS user using Profile
	259	*
fd31fa4c	260	* @param object $form
6a488035 TO	261	* @param integer $gid id of group of profile
6a488035 TO	262	* @param bool $emailPresent true if the profile field has email(primary)
da3c7979	263	* @param \const\|int $action
fd31fa4c	264	*
6a488035 TO	265	* @return FALSE\|void WTF
	266	*
	267	* @access public
	268	* @static
	269	*/
	270	static function buildForm(&$form, $gid, $emailPresent, $action = CRM_Core_Action::NONE) {
	271	$config = CRM_Core_Config::singleton();
	272	$showCMS = FALSE;
	273
	274	$isDrupal = $config->userSystem->is_drupal;
	275	$isJoomla = ucfirst($config->userFramework) == 'Joomla' ? TRUE : FALSE;
	276	$isWordPress = $config->userFramework == 'WordPress' ? TRUE : FALSE;
	277
	278	//if CMS is configured for not to allow creating new CMS user,
	279	//don't build the form,Fixed for CRM-4036
	280	if ($isJoomla) {
	281	$userParams = JComponentHelper::getParams('com_users');
	282	if (!$userParams->get('allowUserRegistration')) {
	283	return FALSE;
	284	}
	285	}
	286	elseif ($isDrupal && !variable_get('user_register', TRUE)) {
	287	return FALSE;
	288	}
	289	elseif ($isWordPress && !get_option('users_can_register')) {
	290	return FALSE;
	291	}
	292
	293	if ($gid) {
	294	$isCMSUser = CRM_Core_DAO::getFieldValue('CRM_Core_DAO_UFGroup', $gid, 'is_cms_user');
	295	}
	296
	297	// $cms is true when there is email(primary location) is set in the profile field.
	298	$session = CRM_Core_Session::singleton();
	299	$userID = $session->get('userID');
	300	$showUserRegistration = FALSE;
	301	if ($action) {
	302	$showUserRegistration = TRUE;
	303	}
	304	elseif (!$action && !$userID) {
	305	$showUserRegistration = TRUE;
	306	}
	307
	308	if ($isCMSUser && $emailPresent) {
	309	if ($showUserRegistration) {
	310	if ($isCMSUser != 2) {
	311	$extra = array(
	312	'onclick' => "return showHideByValue('cms_create_account','','details','block','radio',false );",
	313	);
	314	$form->addElement('checkbox', 'cms_create_account', ts('Create an account?'), NULL, $extra);
	315	$required = FALSE;
	316	}
	317	else {
	318	$form->add('hidden', 'cms_create_account', 1);
	319	$required = TRUE;
	320	}
	321
	322	$form->assign('isCMS', $required);
	323	if (!$userID \|\| $action & CRM_Core_Action::PREVIEW \|\| $action & CRM_Core_Action::PROFILE) {
	324	$form->add('text', 'cms_name', ts('Username'), NULL, $required);
	325	if (($isDrupal && !variable_get('user_email_verification', TRUE)) OR ($isJoomla) OR ($isWordPress)) {
	326	$form->add('password', 'cms_pass', ts('Password'));
	327	$form->add('password', 'cms_confirm_pass', ts('Confirm Password'));
	328	}
329
330	$form->addFormRule(array('CRM_Core_BAO_CMSUser', 'formRule'), $form);
331	}
332	$showCMS = TRUE;
333	}
334	}
335
336	$destination = $config->userSystem->getLoginDestination($form);
337	$loginURL = $config->userSystem->getLoginURL($destination);
338	$form->assign('loginURL', $loginURL);
339	$form->assign('showCMS', $showCMS);
340	}
341
342	/*
343	* Checks that there is a valid username & email
344	* optionally checks password is present & matches DB & gets the CMS to validate
345	*
346	* @params array $fields Posted values of form
347	* @param array $files uploaded files if any
348	* @param array $self reference to form object
349	*
350	*/
b5c2afd0 EM	351	/**
	352	* @param $fields
	353	* @param $files
	354	* @param $self
	355	*
	356	* @return array\|bool
	357	*/
6a488035	358	static function formRule($fields, $files, $self) {
a7488080	359	if (empty($fields['cms_create_account'])) {
6a488035 TO	360	return TRUE;
	361	}
	362
	363	$config = CRM_Core_Config::singleton();
	364
	365	$isDrupal = $config->userSystem->is_drupal;
	366	$isJoomla = ucfirst($config->userFramework) == 'Joomla' ? TRUE : FALSE;
	367	$isWordPress = $config->userFramework == 'WordPress' ? TRUE : FALSE;
	368
	369	$errors = array();
	370	if ($isDrupal \|\| $isJoomla \|\| $isWordPress) {
	371	$emailName = NULL;
	372	if (!empty($self->_bltID) && array_key_exists("email-{$self->_bltID}", $fields)) {
	373	// this is a transaction related page
	374	$emailName = 'email-' . $self->_bltID;
	375	} else {
	376	// find the email field in a profile page
	377	foreach ($fields as $name => $dontCare) {
	378	if (substr($name, 0, 5) == 'email') {
	379	$emailName = $name;
	380	break;
	381	}
	382	}
	383	}
	384
	385	if ($emailName == NULL) {
	386	$errors['_qf_default'] == ts('Could not find an email address.');
	387	return $errors;
	388	}
	389
	390	if (empty($fields['cms_name'])) {
	391	$errors['cms_name'] = ts('Please specify a username.');
	392	}
	393
	394	if (empty($fields[$emailName])) {
	395	$errors[$emailName] = ts('Please specify a valid email address.');
	396	}
	397
	398	if (($isDrupal && !variable_get('user_email_verification', TRUE)) OR ($isJoomla) OR ($isWordPress)) {
	399	if (empty($fields['cms_pass']) \|\|
	400	empty($fields['cms_confirm_pass'])
	401	) {
	402	$errors['cms_pass'] = ts('Please enter a password.');
	403	}
	404	if ($fields['cms_pass'] != $fields['cms_confirm_pass']) {
	405	$errors['cms_pass'] = ts('Password and Confirm Password values are not the same.');
	406	}
	407	}
	408
	409	if (!empty($errors)) {
	410	return $errors;
	411	}
	412
	413	// now check that the cms db does not have the user name and/or email
	414	if ($isDrupal OR $isJoomla OR $isWordPress) {
	415	$params = array(
	416	'name' => $fields['cms_name'],
	417	'mail' => $fields[$emailName],
	418	);
	419	}
	420
	421	$config->userSystem->checkUserNameEmailExists($params, $errors, $emailName);
	422	}
	423	return (!empty($errors)) ? $errors : TRUE;
424	}
425
426	/**
427	* Function to check if a cms user already exists.
428	*
429	* @param Array $contact array of contact-details
430	*
431	* @return uid if user exists, false otherwise
432	*
433	* @access public
434	* @static
435	*/
436	static function userExists(&$contact) {
437	$config = CRM_Core_Config::singleton();
438
439	$isDrupal = $config->userSystem->is_drupal;
440	$isJoomla = ucfirst($config->userFramework) == 'Joomla' ? TRUE : FALSE;
441	$isWordPress = $config->userFramework == 'WordPress' ? TRUE : FALSE;
442
443	if (!$isDrupal && !$isJoomla && !$isWordPress) {
444	die('Unknown user framework');
445	}
446
447	// Use UF native framework to fetch data from UF user table
448	if ($isDrupal) {
449	$uid = db_query(
450	"SELECT uid FROM {users} where mail = :email",
451	array(':email' => $contact['email'])
452	)->fetchField();
453
454	if ($uid) {
455	$contact['user_exists'] = TRUE;
456	$result = $uid;
457	}
458	}
459	elseif ($isJoomla) {
460	$mail = $contact['email'];
461
462	$JUserTable = &JTable::getInstance('User', 'JTable');
463
464	$db = $JUserTable->getDbo();
465	$query = $db->getQuery(TRUE);
466	$query->select('username, email');
467	$query->from($JUserTable->getTableName());
468	$query->where('(LOWER(email) = LOWER(\'' . $email . '\'))');
469	$db->setQuery($query, 0, $limit);
470	$users = $db->loadAssocList();
471
472	$row = array();;
473	if (count($users)) {
474	$row = $users[0];
475	}
476
477	if (!empty($row)) {
478	$uid = CRM_Utils_Array::value('id', $row);
479	$contact['user_exists'] = TRUE;
480	$result = $uid;
481	}
482	}
483	elseif ($isWordPress) {
484	if (email_exists($params['mail'])) {
485	$contact['user_exists'] = TRUE;
486	$userObj = get_user_by('email', $params['mail']);
487	return $userObj->ID;
488	}
489	}
490
491	return $result;
492	}
493
b5c2afd0 EM	494	/**
	495	* @param $config
	496	*
	497	* @return object
	498	*/
6a488035	499	static function &dbHandle(&$config) {
6a4257d4	500	$errorScope = CRM_Core_TemporaryErrorScope::ignoreException();
6a488035	501	$db_uf = DB::connect($config->userFrameworkDSN);
6a4257d4	502	unset($errorScope);
6a488035 TO	503	if (!$db_uf \|\|
	504	DB::isError($db_uf)
	505	) {
	506	$session = CRM_Core_Session::singleton();
	507	$session->pushUserContext(CRM_Utils_System::url('civicrm/admin', 'reset=1'));
	508	CRM_Core_Error::statusBounce(ts("Cannot connect to UF db via %1. Please check the CIVICRM_UF_DSN value in your civicrm.settings.php file",
	509	array(1 => $db_uf->getMessage())
	510	));
	511	}
	512	$db_uf->query('/!40101 SET NAMES utf8 /');
	513	return $db_uf;
	514	}
	515	}
	516