/** * 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); }