/**
* 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 = OtherContactInfo::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 OtherContactInfo, given the clauses above
$this->DataSource = OtherContactInfo::QueryArray($objCondition, $objClauses);
}
/**
* Deletes all associated OtherContactInfos
* @return void
*/
public function DeleteAllOtherContactInfos()
{
if (is_null($this->intId)) {
throw new QUndefinedPrimaryKeyException('Unable to call UnassociateOtherContactInfo on this unsaved OtherContactMethod.');
}
// Get the Database Object for this Class
$objDatabase = OtherContactMethod::GetDatabase();
// Journaling
if ($objDatabase->JournalingDatabase) {
foreach (OtherContactInfo::LoadArrayByOtherContactMethodId($this->intId) as $objOtherContactInfo) {
$objOtherContactInfo->Journal('DELETE');
}
}
// Perform the SQL Query
$objDatabase->NonQuery('
DELETE FROM
`other_contact_info`
WHERE
`other_contact_method_id` = ' . $objDatabase->SqlVariable($this->intId) . '
');
}
public static function GetSoapArrayFromArray($objArray)
{
if (!$objArray) {
return null;
}
$objArrayToReturn = array();
foreach ($objArray as $objObject) {
array_push($objArrayToReturn, OtherContactInfo::GetSoapObjectFromObject($objObject, true));
}
return unserialize(serialize($objArrayToReturn));
}
protected static function GenerateAddressesAndPhonesForPerson(Person $objPerson)
{
$intAddressCount = rand(0, 5);
for ($i = 0; $i < $intAddressCount; $i++) {
$objAddress = new Address();
$objAddress->AddressTypeId = QDataGen::GenerateFromArray(array_keys(AddressType::$NameArray));
$objAddress->Person = $objPerson;
$objAddress->Address1 = QDataGen::GenerateStreetAddress();
if (rand(0, 1)) {
$objAddress->Address2 = QDataGen::GenerateAddressLine2();
}
$objAddress->City = QDataGen::GenerateCity();
$objAddress->State = QDataGen::GenerateUsState();
$objAddress->ZipCode = rand(10000, 99999);
$objAddress->Country = 'US';
$objAddress->InvalidFlag = false;
$objAddress->VerificationCheckedFlag = true;
switch ($objAddress->AddressTypeId) {
case AddressType::Temporary:
$objAddress->CurrentFlag = true;
$dttNextYear = QDateTime::Now();
$dttNextYear->Year++;
$objAddress->DateUntilWhen = QDataGen::GenerateDateTime(QDateTime::Now(), $dttNextYear);
break;
default:
$objAddress->CurrentFlag = rand(0, 1);
break;
}
$objAddress->Save();
}
$intPhoneCount = rand(0, 5);
$objPhoneArray = array();
for ($i = 0; $i < $intPhoneCount; $i++) {
$objPhone = new Phone();
$objPhone->PhoneTypeId = QDataGen::GenerateFromArray(array_keys(PhoneType::$NameArray));
while ($objPhone->PhoneTypeId == PhoneType::Home) {
$objPhone->PhoneTypeId = QDataGen::GenerateFromArray(array_keys(PhoneType::$NameArray));
}
$objPhone->Number = QDataGen::GeneratePhone();
$objPhone->Person = $objPerson;
$objPhone->Save();
$objPhoneArray[] = $objPhone;
}
if ($intPhoneCount && !rand(0, 2)) {
QDataGen::GenerateFromArray($objPhoneArray)->SetAsPrimary();
}
$intEmailCount = rand(0, 5);
$objEmailArray = array();
for ($i = 0; $i < $intEmailCount; $i++) {
$objEmail = new Email();
$objEmail->Address = QDataGen::GenerateEmail($objPerson->FirstName, $objPerson->LastName);
$objEmail->Person = $objPerson;
$objEmail->Save();
$objEmailArray[] = $objEmail;
}
if ($intEmailCount && !rand(0, 2)) {
QDataGen::GenerateFromArray($objEmailArray)->SetAsPrimary();
}
$intMaxId = OtherContactMethod::CountAll();
for ($intOtherContactMethodId = 1; $intOtherContactMethodId <= $intMaxId; $intOtherContactMethodId++) {
if (!rand(0, 2)) {
$objContactInfo = new OtherContactInfo();
$objContactInfo->Person = $objPerson;
$objContactInfo->OtherContactMethodId = $intOtherContactMethodId;
$objContactInfo->Value = QDataGen::GenerateUsername($objPerson->FirstName, $objPerson->LastName);
$objContactInfo->Save();
}
}
}
/**
* Static Helper Method to Create using PK arguments
* You must pass in the PK arguments on an object to load, or leave it blank to create a new one.
* If you want to load via QueryString or PathInfo, use the CreateFromQueryString or CreateFromPathInfo
* static helper methods. Finally, specify a CreateType to define whether or not we are only allowed to
* edit, or if we are also allowed to create a new one, etc.
*
* @param mixed $objParentObject QForm or QPanel which will be using this OtherContactInfoMetaControl
* @param integer $intId primary key value
* @param QMetaControlCreateType $intCreateType rules governing OtherContactInfo object creation - defaults to CreateOrEdit
* @return OtherContactInfoMetaControl
*/
public static function Create($objParentObject, $intId = null, $intCreateType = QMetaControlCreateType::CreateOrEdit)
{
// Attempt to Load from PK Arguments
if (strlen($intId)) {
$objOtherContactInfo = OtherContactInfo::Load($intId);
// OtherContactInfo was found -- return it!
if ($objOtherContactInfo) {
return new OtherContactInfoMetaControl($objParentObject, $objOtherContactInfo);
} else {
if ($intCreateType != QMetaControlCreateType::CreateOnRecordNotFound) {
throw new QCallerException('Could not find a OtherContactInfo object with PK arguments: ' . $intId);
}
}
// If EditOnly is specified, throw an exception
} else {
if ($intCreateType == QMetaControlCreateType::EditOnly) {
throw new QCallerException('No PK arguments specified');
}
}
// If we are here, then we need to create a new record
return new OtherContactInfoMetaControl($objParentObject, new OtherContactInfo());
}
