/**
* Load all ProvisionalPublicLogins
* @param QQClause[] $objOptionalClauses additional optional QQClause objects for this query
* @return ProvisionalPublicLogin[]
*/
public static function LoadAll($objOptionalClauses = null)
{
// Call ProvisionalPublicLogin::QueryArray to perform the LoadAll query
try {
return ProvisionalPublicLogin::QueryArray(QQ::All(), $objOptionalClauses);
} catch (QCallerException $objExc) {
$objExc->IncrementOffset();
throw $objExc;
}
}
/**
* This will create a provisional PublicLogin record, including setting up the hash.
* NOTE: If the PublicLogin record already exists AND it is a non-provisional one, then this will throw an error
* Otherwise, if the PublicLogin exists as a provisional one, it will simply overwrite the provisioned info.
*
* @param string $strUsername
* @param string $strEmailAddress
* @param string $strFirstName
* @param string $strLastName
* @return ProvisionalPublicLogin
*/
public static function CreateProvisional($strUsername, $strEmailAddress, $strFirstName, $strLastName)
{
$strEmailAddress = trim(strtolower($strEmailAddress));
$strUsername = QApplication::Tokenize($strUsername, false);
if (strlen($strUsername) < 4) {
throw new QCallerException('Username is too short: ' . $strUsername);
}
if (!self::IsProvisionalCreatableForUsername($strUsername)) {
throw new QCallerException('Username is already taken: ' . $strUsername);
}
// Perform the Creation Tasks within a Single Transaction
try {
PublicLogin::GetDatabase()->TransactionBegin();
// Delete any other provisional login using this email address with a different username
foreach (ProvisionalPublicLogin::QueryArray(QQ::Equal(QQN::ProvisionalPublicLogin()->EmailAddress, $strEmailAddress)) as $objProvisionalPublicLogin) {
if ($objProvisionalPublicLogin->PublicLogin->Username != $strUsername) {
$objPublicLogin = $objProvisionalPublicLogin->PublicLogin;
$objProvisionalPublicLogin->Delete();
$objPublicLogin->Delete();
}
}
// Be sure to reuse the username record if applicable
$objPublicLogin = PublicLogin::LoadByUsername($strUsername);
$blnChangeHash = true;
if ($objPublicLogin) {
if ($objPublicLogin->ProvisionalPublicLogin->EmailAddress == $strEmailAddress) {
$blnChangeHash = false;
}
$objProvisionalPublicLogin = $objPublicLogin->ProvisionalPublicLogin;
$objPublicLogin->DateRegistered = QDateTime::Now();
$objPublicLogin->Save();
} else {
$objPublicLogin = new PublicLogin();
$objPublicLogin->ActiveFlag = true;
$objPublicLogin->Username = $strUsername;
$objPublicLogin->DateRegistered = QDateTime::Now();
$objPublicLogin->Save();
$objProvisionalPublicLogin = new ProvisionalPublicLogin();
$objProvisionalPublicLogin->PublicLogin = $objPublicLogin;
}
// Update Values
$objProvisionalPublicLogin->FirstName = trim($strFirstName);
$objProvisionalPublicLogin->LastName = trim($strLastName);
$objProvisionalPublicLogin->EmailAddress = trim($strEmailAddress);
if ($blnChangeHash) {
$objProvisionalPublicLogin->UrlHash = md5(microtime());
$objProvisionalPublicLogin->ConfirmationCode = rand(1000, 9999);
}
$objProvisionalPublicLogin->Save();
PublicLogin::GetDatabase()->TransactionCommit();
$objProvisionalPublicLogin->SendConfirmationEmail();
return $objProvisionalPublicLogin;
} catch (Exception $objExc) {
PublicLogin::GetDatabase()->TransactionRollBack();
throw $objExc;
}
}
/**
* Main utility method to aid with data binding. It is used by the default BindAllRows() databinder but
* could and should be used by any custom databind methods that would be used for instances of this
* MetaDataGrid, by simply passing in a custom QQCondition and/or QQClause.
*
* If a paginator is set on this DataBinder, it will use it. If not, then no pagination will be used.
* It will also perform any sorting (if applicable).
*
* @param QQCondition $objConditions override the default condition of QQ::All() to the query, itself
* @param QQClause[] $objOptionalClauses additional optional QQClause object or array of QQClause objects for the query
* @return void
*/
public function MetaDataBinder(QQCondition $objCondition = null, $objOptionalClauses = null)
{
// Setup input parameters to default values if none passed in
if (!$objCondition) {
$objCondition = QQ::All();
}
$objClauses = $objOptionalClauses ? $objOptionalClauses : array();
// We need to first set the TotalItemCount, which will affect the calcuation of LimitClause below
if ($this->Paginator) {
$this->TotalItemCount = ProvisionalPublicLogin::QueryCount($objCondition, $objClauses);
}
// If a column is selected to be sorted, and if that column has a OrderByClause set on it, then let's add
// the OrderByClause to the $objClauses array
if ($objClause = $this->OrderByClause) {
array_push($objClauses, $objClause);
}
// Add the LimitClause information, as well
if ($objClause = $this->LimitClause) {
array_push($objClauses, $objClause);
}
// Set the DataSource to be a Query result from ProvisionalPublicLogin, given the clauses above
$this->DataSource = ProvisionalPublicLogin::QueryArray($objCondition, $objClauses);
}
