public function lstCompany_Change()
{
// Clear out the items from lstAddress
$this->lstAddress->RemoveAllItems();
if ($this->lstCompany->SelectedValue) {
// Load the selected company
$objCompany = Company::Load($this->lstCompany->SelectedValue);
// Get all available addresses for that company
if ($objCompany) {
$objAddressArray = $objCompany->GetAddressArray();
$this->lstAddress->Enabled = true;
} else {
$objAddressArray = null;
$this->lstAddress->Enabled = false;
}
} else {
// Or load all addresses for all companies
$objAddressArray = Address::LoadAll(QQ::Clause(QQ::OrderBy(QQN::Address()->ShortDescription)));
$this->lstAddress->Enabled = true;
}
$this->lstAddress->AddItem('- Select One -', null);
if ($objAddressArray) {
foreach ($objAddressArray as $objAddress) {
$objListItem = new QListItem($objAddress->__toString(), $objAddress->AddressId);
$this->lstAddress->AddItem($objListItem);
}
}
}
protected function lstToAddress_Create()
{
$this->lstToAddress = new QListBox($this);
$this->lstToAddress->Name = QApplication::Translate('To Address');
$this->lstToAddress->Required = true;
if (!$this->blnEditMode) {
$this->lstToAddress->AddItem(QApplication::Translate('- Select One -'), null);
}
$objToAddressArray = Address::LoadAll();
if ($objToAddressArray) {
foreach ($objToAddressArray as $objToAddress) {
$objListItem = new QListItem($objToAddress->__toString(), $objToAddress->AddressId);
if ($this->objShipment->ToAddress && $this->objShipment->ToAddress->AddressId == $objToAddress->AddressId) {
$objListItem->Selected = true;
}
$this->lstToAddress->AddItem($objListItem);
}
}
}
/**
* Refresh this MetaControl with Data from the local Shipment object.
* @param boolean $blnReload reload Shipment from the database
* @return void
*/
public function Refresh($blnReload = false)
{
if ($blnReload) {
$this->objShipment->Reload();
}
if ($this->lblShipmentId) {
if ($this->blnEditMode) {
$this->lblShipmentId->Text = $this->objShipment->ShipmentId;
}
}
if ($this->txtShipmentNumber) {
$this->txtShipmentNumber->Text = $this->objShipment->ShipmentNumber;
}
if ($this->lblShipmentNumber) {
$this->lblShipmentNumber->Text = $this->objShipment->ShipmentNumber;
}
if ($this->lstTransaction) {
$this->lstTransaction->RemoveAllItems();
if (!$this->blnEditMode) {
$this->lstTransaction->AddItem(QApplication::Translate('- Select One -'), null);
}
$objTransactionArray = Transaction::LoadAll();
if ($objTransactionArray) {
foreach ($objTransactionArray as $objTransaction) {
$objListItem = new QListItem($objTransaction->__toString(), $objTransaction->TransactionId);
if ($this->objShipment->Transaction && $this->objShipment->Transaction->TransactionId == $objTransaction->TransactionId) {
$objListItem->Selected = true;
}
$this->lstTransaction->AddItem($objListItem);
}
}
}
if ($this->lblTransactionId) {
$this->lblTransactionId->Text = $this->objShipment->Transaction ? $this->objShipment->Transaction->__toString() : null;
}
if ($this->lstFromCompany) {
$this->lstFromCompany->RemoveAllItems();
if (!$this->blnEditMode) {
$this->lstFromCompany->AddItem(QApplication::Translate('- Select One -'), null);
}
$objFromCompanyArray = Company::LoadAll();
if ($objFromCompanyArray) {
foreach ($objFromCompanyArray as $objFromCompany) {
$objListItem = new QListItem($objFromCompany->__toString(), $objFromCompany->CompanyId);
if ($this->objShipment->FromCompany && $this->objShipment->FromCompany->CompanyId == $objFromCompany->CompanyId) {
$objListItem->Selected = true;
}
$this->lstFromCompany->AddItem($objListItem);
}
}
}
if ($this->lblFromCompanyId) {
$this->lblFromCompanyId->Text = $this->objShipment->FromCompany ? $this->objShipment->FromCompany->__toString() : null;
}
if ($this->lstFromContact) {
$this->lstFromContact->RemoveAllItems();
if (!$this->blnEditMode) {
$this->lstFromContact->AddItem(QApplication::Translate('- Select One -'), null);
}
$objFromContactArray = Contact::LoadAll();
if ($objFromContactArray) {
foreach ($objFromContactArray as $objFromContact) {
$objListItem = new QListItem($objFromContact->__toString(), $objFromContact->ContactId);
if ($this->objShipment->FromContact && $this->objShipment->FromContact->ContactId == $objFromContact->ContactId) {
$objListItem->Selected = true;
}
$this->lstFromContact->AddItem($objListItem);
}
}
}
if ($this->lblFromContactId) {
$this->lblFromContactId->Text = $this->objShipment->FromContact ? $this->objShipment->FromContact->__toString() : null;
}
if ($this->lstFromAddress) {
$this->lstFromAddress->RemoveAllItems();
if (!$this->blnEditMode) {
$this->lstFromAddress->AddItem(QApplication::Translate('- Select One -'), null);
}
$objFromAddressArray = Address::LoadAll();
if ($objFromAddressArray) {
foreach ($objFromAddressArray as $objFromAddress) {
$objListItem = new QListItem($objFromAddress->__toString(), $objFromAddress->AddressId);
if ($this->objShipment->FromAddress && $this->objShipment->FromAddress->AddressId == $objFromAddress->AddressId) {
$objListItem->Selected = true;
}
$this->lstFromAddress->AddItem($objListItem);
}
}
}
if ($this->lblFromAddressId) {
$this->lblFromAddressId->Text = $this->objShipment->FromAddress ? $this->objShipment->FromAddress->__toString() : null;
}
if ($this->lstToCompany) {
$this->lstToCompany->RemoveAllItems();
if (!$this->blnEditMode) {
$this->lstToCompany->AddItem(QApplication::Translate('- Select One -'), null);
}
$objToCompanyArray = Company::LoadAll();
if ($objToCompanyArray) {
foreach ($objToCompanyArray as $objToCompany) {
$objListItem = new QListItem($objToCompany->__toString(), $objToCompany->CompanyId);
if ($this->objShipment->ToCompany && $this->objShipment->ToCompany->CompanyId == $objToCompany->CompanyId) {
$objListItem->Selected = true;
}
$this->lstToCompany->AddItem($objListItem);
}
}
}
if ($this->lblToCompanyId) {
$this->lblToCompanyId->Text = $this->objShipment->ToCompany ? $this->objShipment->ToCompany->__toString() : null;
}
if ($this->lstToContact) {
$this->lstToContact->RemoveAllItems();
if (!$this->blnEditMode) {
$this->lstToContact->AddItem(QApplication::Translate('- Select One -'), null);
}
$objToContactArray = Contact::LoadAll();
if ($objToContactArray) {
foreach ($objToContactArray as $objToContact) {
$objListItem = new QListItem($objToContact->__toString(), $objToContact->ContactId);
if ($this->objShipment->ToContact && $this->objShipment->ToContact->ContactId == $objToContact->ContactId) {
$objListItem->Selected = true;
}
$this->lstToContact->AddItem($objListItem);
}
}
}
if ($this->lblToContactId) {
$this->lblToContactId->Text = $this->objShipment->ToContact ? $this->objShipment->ToContact->__toString() : null;
}
if ($this->lstToAddress) {
$this->lstToAddress->RemoveAllItems();
if (!$this->blnEditMode) {
$this->lstToAddress->AddItem(QApplication::Translate('- Select One -'), null);
}
$objToAddressArray = Address::LoadAll();
if ($objToAddressArray) {
foreach ($objToAddressArray as $objToAddress) {
$objListItem = new QListItem($objToAddress->__toString(), $objToAddress->AddressId);
if ($this->objShipment->ToAddress && $this->objShipment->ToAddress->AddressId == $objToAddress->AddressId) {
$objListItem->Selected = true;
}
$this->lstToAddress->AddItem($objListItem);
}
}
}
if ($this->lblToAddressId) {
$this->lblToAddressId->Text = $this->objShipment->ToAddress ? $this->objShipment->ToAddress->__toString() : null;
}
if ($this->lstCourier) {
$this->lstCourier->RemoveAllItems();
$this->lstCourier->AddItem(QApplication::Translate('- Select One -'), null);
$objCourierArray = Courier::LoadAll();
if ($objCourierArray) {
foreach ($objCourierArray as $objCourier) {
$objListItem = new QListItem($objCourier->__toString(), $objCourier->CourierId);
if ($this->objShipment->Courier && $this->objShipment->Courier->CourierId == $objCourier->CourierId) {
$objListItem->Selected = true;
}
$this->lstCourier->AddItem($objListItem);
}
}
}
if ($this->lblCourierId) {
$this->lblCourierId->Text = $this->objShipment->Courier ? $this->objShipment->Courier->__toString() : null;
}
if ($this->txtTrackingNumber) {
$this->txtTrackingNumber->Text = $this->objShipment->TrackingNumber;
}
if ($this->lblTrackingNumber) {
$this->lblTrackingNumber->Text = $this->objShipment->TrackingNumber;
}
if ($this->calShipDate) {
$this->calShipDate->DateTime = $this->objShipment->ShipDate;
}
if ($this->lblShipDate) {
$this->lblShipDate->Text = sprintf($this->objShipment->ShipDate) ? $this->objShipment->__toString($this->strShipDateDateTimeFormat) : null;
}
if ($this->chkShippedFlag) {
$this->chkShippedFlag->Checked = $this->objShipment->ShippedFlag;
}
if ($this->lblShippedFlag) {
$this->lblShippedFlag->Text = $this->objShipment->ShippedFlag ? QApplication::Translate('Yes') : QApplication::Translate('No');
}
if ($this->lstCreatedByObject) {
$this->lstCreatedByObject->RemoveAllItems();
$this->lstCreatedByObject->AddItem(QApplication::Translate('- Select One -'), null);
$objCreatedByObjectArray = UserAccount::LoadAll();
if ($objCreatedByObjectArray) {
foreach ($objCreatedByObjectArray as $objCreatedByObject) {
$objListItem = new QListItem($objCreatedByObject->__toString(), $objCreatedByObject->UserAccountId);
if ($this->objShipment->CreatedByObject && $this->objShipment->CreatedByObject->UserAccountId == $objCreatedByObject->UserAccountId) {
$objListItem->Selected = true;
}
$this->lstCreatedByObject->AddItem($objListItem);
}
}
}
if ($this->lblCreatedBy) {
$this->lblCreatedBy->Text = $this->objShipment->CreatedByObject ? $this->objShipment->CreatedByObject->__toString() : null;
}
if ($this->calCreationDate) {
$this->calCreationDate->DateTime = $this->objShipment->CreationDate;
}
if ($this->lblCreationDate) {
$this->lblCreationDate->Text = sprintf($this->objShipment->CreationDate) ? $this->objShipment->__toString($this->strCreationDateDateTimeFormat) : null;
}
if ($this->lstModifiedByObject) {
$this->lstModifiedByObject->RemoveAllItems();
$this->lstModifiedByObject->AddItem(QApplication::Translate('- Select One -'), null);
$objModifiedByObjectArray = UserAccount::LoadAll();
if ($objModifiedByObjectArray) {
foreach ($objModifiedByObjectArray as $objModifiedByObject) {
$objListItem = new QListItem($objModifiedByObject->__toString(), $objModifiedByObject->UserAccountId);
if ($this->objShipment->ModifiedByObject && $this->objShipment->ModifiedByObject->UserAccountId == $objModifiedByObject->UserAccountId) {
$objListItem->Selected = true;
}
$this->lstModifiedByObject->AddItem($objListItem);
}
}
}
if ($this->lblModifiedBy) {
$this->lblModifiedBy->Text = $this->objShipment->ModifiedByObject ? $this->objShipment->ModifiedByObject->__toString() : null;
}
if ($this->lblModifiedDate) {
if ($this->blnEditMode) {
$this->lblModifiedDate->Text = $this->objShipment->ModifiedDate;
}
}
if ($this->lstShipmentCustomFieldHelper) {
$this->lstShipmentCustomFieldHelper->RemoveAllItems();
$this->lstShipmentCustomFieldHelper->AddItem(QApplication::Translate('- Select One -'), null);
$objShipmentCustomFieldHelperArray = ShipmentCustomFieldHelper::LoadAll();
if ($objShipmentCustomFieldHelperArray) {
foreach ($objShipmentCustomFieldHelperArray as $objShipmentCustomFieldHelper) {
$objListItem = new QListItem($objShipmentCustomFieldHelper->__toString(), $objShipmentCustomFieldHelper->ShipmentId);
if ($objShipmentCustomFieldHelper->ShipmentId == $this->objShipment->ShipmentId) {
$objListItem->Selected = true;
}
$this->lstShipmentCustomFieldHelper->AddItem($objListItem);
}
}
// Because ShipmentCustomFieldHelper's ShipmentCustomFieldHelper is not null, if a value is already selected, it cannot be changed.
if ($this->lstShipmentCustomFieldHelper->SelectedValue) {
$this->lstShipmentCustomFieldHelper->Enabled = false;
} else {
$this->lstShipmentCustomFieldHelper->Enabled = true;
}
}
if ($this->lblShipmentCustomFieldHelper) {
$this->lblShipmentCustomFieldHelper->Text = $this->objShipment->ShipmentCustomFieldHelper ? $this->objShipment->ShipmentCustomFieldHelper->__toString() : null;
}
}
protected function lstAddress_Create()
{
$this->lstAddress = new QListBox($this);
$this->lstAddress->Name = QApplication::Translate('Address');
$this->lstAddress->AddItem(QApplication::Translate('- Select One -'), null);
$objAddressArray = Address::LoadAll();
if ($objAddressArray) {
foreach ($objAddressArray as $objAddress) {
$objListItem = new QListItem($objAddress->__toString(), $objAddress->AddressId);
if ($this->objCompany->Address && $this->objCompany->Address->AddressId == $objAddress->AddressId) {
$objListItem->Selected = true;
}
$this->lstAddress->AddItem($objListItem);
}
}
}
<?php
ini_set('memory_limit', '1024M');
$objMySqli = new mysqli('localhost', 'root', '', 'alcf_address');
QDataGen::DisplayForEachTaskStart('Cleaning Addresses', Address::CountAll());
foreach (Address::LoadAll() as $objAddress) {
QDataGen::DisplayForEachTaskNext('Cleaning Addresses');
$strQuery = sprintf("SELECT id FROM address WHERE address_1 %s AND address_2 %s AND address_3 %s AND city %s AND state %s AND zip_code %s;", is_null($objAddress->Address1) ? 'IS NULL' : "='" . $objMySqli->escape_string($objAddress->Address1) . "'", is_null($objAddress->Address2) ? 'IS NULL' : "='" . $objMySqli->escape_string($objAddress->Address2) . "'", is_null($objAddress->Address3) ? 'IS NULL' : "='" . $objMySqli->escape_string($objAddress->Address3) . "'", is_null($objAddress->City) ? 'IS NULL' : "='" . $objMySqli->escape_string($objAddress->City) . "'", is_null($objAddress->State) ? 'IS NULL' : "='" . $objMySqli->escape_string($objAddress->State) . "'", is_null($objAddress->ZipCode) ? 'IS NULL' : "='" . $objMySqli->escape_string($objAddress->ZipCode) . "'");
$objResult = $objMySqli->Query($strQuery);
if ($objRow = $objResult->fetch_array()) {
$objResult = $objMySqli->Query('SELECT * FROM corrected_address WHERE address_id=' . $objRow['id']);
$objRow = $objResult->fetch_array();
if ($objRow['status_flag'] == 1) {
$objAddress->Address1 = $objRow['address_1'];
$objAddress->Address2 = $objRow['address_2'];
$objAddress->City = $objRow['city'];
$objAddress->State = $objRow['state'];
$objAddress->ZipCode = $objRow['zip_code'];
$objAddress->InvalidFlag = false;
$objAddress->VerificationCheckedFlag = true;
} else {
$objAddress->InvalidFlag = true;
}
$objAddress->Save();
} else {
if (!$objAddress->ValidateUsps()) {
print "NONE FOUND FOR - " . $objAddress->Id . "\r\n";
$objAddress->InvalidFlag = true;
$objAddress->Save();
}
}
protected function dtgAddress_Bind()
{
// Because we want to enable pagination AND sorting, we need to setup the $objClauses array to send to LoadAll()
// Remember! We need to first set the TotalItemCount, which will affect the calcuation of LimitClause below
$this->dtgAddress->TotalItemCount = Address::CountAll();
// Setup the $objClauses Array
$objClauses = array();
// 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->dtgAddress->OrderByClause) {
array_push($objClauses, $objClause);
}
// Add the LimitClause information, as well
if ($objClause = $this->dtgAddress->LimitClause) {
array_push($objClauses, $objClause);
}
// Set the DataSource to be the array of all Address objects, given the clauses above
$this->dtgAddress->DataSource = Address::LoadAll($objClauses);
}
/**
* Refresh this MetaControl with Data from the local Contact object.
* @param boolean $blnReload reload Contact from the database
* @return void
*/
public function Refresh($blnReload = false)
{
if ($blnReload) {
$this->objContact->Reload();
}
if ($this->lblContactId) {
if ($this->blnEditMode) {
$this->lblContactId->Text = $this->objContact->ContactId;
}
}
if ($this->lstCompany) {
$this->lstCompany->RemoveAllItems();
if (!$this->blnEditMode) {
$this->lstCompany->AddItem(QApplication::Translate('- Select One -'), null);
}
$objCompanyArray = Company::LoadAll();
if ($objCompanyArray) {
foreach ($objCompanyArray as $objCompany) {
$objListItem = new QListItem($objCompany->__toString(), $objCompany->CompanyId);
if ($this->objContact->Company && $this->objContact->Company->CompanyId == $objCompany->CompanyId) {
$objListItem->Selected = true;
}
$this->lstCompany->AddItem($objListItem);
}
}
}
if ($this->lblCompanyId) {
$this->lblCompanyId->Text = $this->objContact->Company ? $this->objContact->Company->__toString() : null;
}
if ($this->lstAddress) {
$this->lstAddress->RemoveAllItems();
$this->lstAddress->AddItem(QApplication::Translate('- Select One -'), null);
$objAddressArray = Address::LoadAll();
if ($objAddressArray) {
foreach ($objAddressArray as $objAddress) {
$objListItem = new QListItem($objAddress->__toString(), $objAddress->AddressId);
if ($this->objContact->Address && $this->objContact->Address->AddressId == $objAddress->AddressId) {
$objListItem->Selected = true;
}
$this->lstAddress->AddItem($objListItem);
}
}
}
if ($this->lblAddressId) {
$this->lblAddressId->Text = $this->objContact->Address ? $this->objContact->Address->__toString() : null;
}
if ($this->txtFirstName) {
$this->txtFirstName->Text = $this->objContact->FirstName;
}
if ($this->lblFirstName) {
$this->lblFirstName->Text = $this->objContact->FirstName;
}
if ($this->txtLastName) {
$this->txtLastName->Text = $this->objContact->LastName;
}
if ($this->lblLastName) {
$this->lblLastName->Text = $this->objContact->LastName;
}
if ($this->txtTitle) {
$this->txtTitle->Text = $this->objContact->Title;
}
if ($this->lblTitle) {
$this->lblTitle->Text = $this->objContact->Title;
}
if ($this->txtEmail) {
$this->txtEmail->Text = $this->objContact->Email;
}
if ($this->lblEmail) {
$this->lblEmail->Text = $this->objContact->Email;
}
if ($this->txtPhoneOffice) {
$this->txtPhoneOffice->Text = $this->objContact->PhoneOffice;
}
if ($this->lblPhoneOffice) {
$this->lblPhoneOffice->Text = $this->objContact->PhoneOffice;
}
if ($this->txtPhoneHome) {
$this->txtPhoneHome->Text = $this->objContact->PhoneHome;
}
if ($this->lblPhoneHome) {
$this->lblPhoneHome->Text = $this->objContact->PhoneHome;
}
if ($this->txtPhoneMobile) {
$this->txtPhoneMobile->Text = $this->objContact->PhoneMobile;
}
if ($this->lblPhoneMobile) {
$this->lblPhoneMobile->Text = $this->objContact->PhoneMobile;
}
if ($this->txtFax) {
$this->txtFax->Text = $this->objContact->Fax;
}
if ($this->lblFax) {
$this->lblFax->Text = $this->objContact->Fax;
}
if ($this->txtDescription) {
$this->txtDescription->Text = $this->objContact->Description;
}
if ($this->lblDescription) {
$this->lblDescription->Text = $this->objContact->Description;
}
if ($this->lstCreatedByObject) {
$this->lstCreatedByObject->RemoveAllItems();
$this->lstCreatedByObject->AddItem(QApplication::Translate('- Select One -'), null);
$objCreatedByObjectArray = UserAccount::LoadAll();
if ($objCreatedByObjectArray) {
foreach ($objCreatedByObjectArray as $objCreatedByObject) {
$objListItem = new QListItem($objCreatedByObject->__toString(), $objCreatedByObject->UserAccountId);
if ($this->objContact->CreatedByObject && $this->objContact->CreatedByObject->UserAccountId == $objCreatedByObject->UserAccountId) {
$objListItem->Selected = true;
}
$this->lstCreatedByObject->AddItem($objListItem);
}
}
}
if ($this->lblCreatedBy) {
$this->lblCreatedBy->Text = $this->objContact->CreatedByObject ? $this->objContact->CreatedByObject->__toString() : null;
}
if ($this->calCreationDate) {
$this->calCreationDate->DateTime = $this->objContact->CreationDate;
}
if ($this->lblCreationDate) {
$this->lblCreationDate->Text = sprintf($this->objContact->CreationDate) ? $this->objContact->__toString($this->strCreationDateDateTimeFormat) : null;
}
if ($this->lstModifiedByObject) {
$this->lstModifiedByObject->RemoveAllItems();
$this->lstModifiedByObject->AddItem(QApplication::Translate('- Select One -'), null);
$objModifiedByObjectArray = UserAccount::LoadAll();
if ($objModifiedByObjectArray) {
foreach ($objModifiedByObjectArray as $objModifiedByObject) {
$objListItem = new QListItem($objModifiedByObject->__toString(), $objModifiedByObject->UserAccountId);
if ($this->objContact->ModifiedByObject && $this->objContact->ModifiedByObject->UserAccountId == $objModifiedByObject->UserAccountId) {
$objListItem->Selected = true;
}
$this->lstModifiedByObject->AddItem($objListItem);
}
}
}
if ($this->lblModifiedBy) {
$this->lblModifiedBy->Text = $this->objContact->ModifiedByObject ? $this->objContact->ModifiedByObject->__toString() : null;
}
if ($this->lblModifiedDate) {
if ($this->blnEditMode) {
$this->lblModifiedDate->Text = $this->objContact->ModifiedDate;
}
}
if ($this->lstContactCustomFieldHelper) {
$this->lstContactCustomFieldHelper->RemoveAllItems();
$this->lstContactCustomFieldHelper->AddItem(QApplication::Translate('- Select One -'), null);
$objContactCustomFieldHelperArray = ContactCustomFieldHelper::LoadAll();
if ($objContactCustomFieldHelperArray) {
foreach ($objContactCustomFieldHelperArray as $objContactCustomFieldHelper) {
$objListItem = new QListItem($objContactCustomFieldHelper->__toString(), $objContactCustomFieldHelper->ContactId);
if ($objContactCustomFieldHelper->ContactId == $this->objContact->ContactId) {
$objListItem->Selected = true;
}
$this->lstContactCustomFieldHelper->AddItem($objListItem);
}
}
// Because ContactCustomFieldHelper's ContactCustomFieldHelper is not null, if a value is already selected, it cannot be changed.
if ($this->lstContactCustomFieldHelper->SelectedValue) {
$this->lstContactCustomFieldHelper->Enabled = false;
} else {
$this->lstContactCustomFieldHelper->Enabled = true;
}
}
if ($this->lblContactCustomFieldHelper) {
$this->lblContactCustomFieldHelper->Text = $this->objContact->ContactCustomFieldHelper ? $this->objContact->ContactCustomFieldHelper->__toString() : null;
}
}
/**
* Refresh this MetaControl with Data from the local FormAnswer object.
* @param boolean $blnReload reload FormAnswer from the database
* @return void
*/
public function Refresh($blnReload = false)
{
if ($blnReload) {
$this->objFormAnswer->Reload();
}
if ($this->lblId) {
if ($this->blnEditMode) {
$this->lblId->Text = $this->objFormAnswer->Id;
}
}
if ($this->lstSignupEntry) {
$this->lstSignupEntry->RemoveAllItems();
if (!$this->blnEditMode) {
$this->lstSignupEntry->AddItem(QApplication::Translate('- Select One -'), null);
}
$objSignupEntryArray = SignupEntry::LoadAll();
if ($objSignupEntryArray) {
foreach ($objSignupEntryArray as $objSignupEntry) {
$objListItem = new QListItem($objSignupEntry->__toString(), $objSignupEntry->Id);
if ($this->objFormAnswer->SignupEntry && $this->objFormAnswer->SignupEntry->Id == $objSignupEntry->Id) {
$objListItem->Selected = true;
}
$this->lstSignupEntry->AddItem($objListItem);
}
}
}
if ($this->lblSignupEntryId) {
$this->lblSignupEntryId->Text = $this->objFormAnswer->SignupEntry ? $this->objFormAnswer->SignupEntry->__toString() : null;
}
if ($this->lstFormQuestion) {
$this->lstFormQuestion->RemoveAllItems();
if (!$this->blnEditMode) {
$this->lstFormQuestion->AddItem(QApplication::Translate('- Select One -'), null);
}
$objFormQuestionArray = FormQuestion::LoadAll();
if ($objFormQuestionArray) {
foreach ($objFormQuestionArray as $objFormQuestion) {
$objListItem = new QListItem($objFormQuestion->__toString(), $objFormQuestion->Id);
if ($this->objFormAnswer->FormQuestion && $this->objFormAnswer->FormQuestion->Id == $objFormQuestion->Id) {
$objListItem->Selected = true;
}
$this->lstFormQuestion->AddItem($objListItem);
}
}
}
if ($this->lblFormQuestionId) {
$this->lblFormQuestionId->Text = $this->objFormAnswer->FormQuestion ? $this->objFormAnswer->FormQuestion->__toString() : null;
}
if ($this->txtTextValue) {
$this->txtTextValue->Text = $this->objFormAnswer->TextValue;
}
if ($this->lblTextValue) {
$this->lblTextValue->Text = $this->objFormAnswer->TextValue;
}
if ($this->lstAddress) {
$this->lstAddress->RemoveAllItems();
$this->lstAddress->AddItem(QApplication::Translate('- Select One -'), null);
$objAddressArray = Address::LoadAll();
if ($objAddressArray) {
foreach ($objAddressArray as $objAddress) {
$objListItem = new QListItem($objAddress->__toString(), $objAddress->Id);
if ($this->objFormAnswer->Address && $this->objFormAnswer->Address->Id == $objAddress->Id) {
$objListItem->Selected = true;
}
$this->lstAddress->AddItem($objListItem);
}
}
}
if ($this->lblAddressId) {
$this->lblAddressId->Text = $this->objFormAnswer->Address ? $this->objFormAnswer->Address->__toString() : null;
}
if ($this->lstPhone) {
$this->lstPhone->RemoveAllItems();
$this->lstPhone->AddItem(QApplication::Translate('- Select One -'), null);
$objPhoneArray = Phone::LoadAll();
if ($objPhoneArray) {
foreach ($objPhoneArray as $objPhone) {
$objListItem = new QListItem($objPhone->__toString(), $objPhone->Id);
if ($this->objFormAnswer->Phone && $this->objFormAnswer->Phone->Id == $objPhone->Id) {
$objListItem->Selected = true;
}
$this->lstPhone->AddItem($objListItem);
}
}
}
if ($this->lblPhoneId) {
$this->lblPhoneId->Text = $this->objFormAnswer->Phone ? $this->objFormAnswer->Phone->__toString() : null;
}
if ($this->lstEmail) {
$this->lstEmail->RemoveAllItems();
$this->lstEmail->AddItem(QApplication::Translate('- Select One -'), null);
$objEmailArray = Email::LoadAll();
if ($objEmailArray) {
foreach ($objEmailArray as $objEmail) {
$objListItem = new QListItem($objEmail->__toString(), $objEmail->Id);
if ($this->objFormAnswer->Email && $this->objFormAnswer->Email->Id == $objEmail->Id) {
$objListItem->Selected = true;
}
$this->lstEmail->AddItem($objListItem);
}
}
}
if ($this->lblEmailId) {
$this->lblEmailId->Text = $this->objFormAnswer->Email ? $this->objFormAnswer->Email->__toString() : null;
}
if ($this->txtIntegerValue) {
$this->txtIntegerValue->Text = $this->objFormAnswer->IntegerValue;
}
if ($this->lblIntegerValue) {
$this->lblIntegerValue->Text = $this->objFormAnswer->IntegerValue;
}
if ($this->chkBooleanValue) {
$this->chkBooleanValue->Checked = $this->objFormAnswer->BooleanValue;
}
if ($this->lblBooleanValue) {
$this->lblBooleanValue->Text = $this->objFormAnswer->BooleanValue ? QApplication::Translate('Yes') : QApplication::Translate('No');
}
if ($this->calDateValue) {
$this->calDateValue->DateTime = $this->objFormAnswer->DateValue;
}
if ($this->lblDateValue) {
$this->lblDateValue->Text = sprintf($this->objFormAnswer->DateValue) ? $this->objFormAnswer->__toString($this->strDateValueDateTimeFormat) : null;
}
}
public function dtgAddress_Bind()
{
// Get Total Count b/c of Pagination
$this->dtgAddress->TotalItemCount = Address::CountAll();
$objClauses = array();
if ($objClause = $this->dtgAddress->OrderByClause) {
array_push($objClauses, $objClause);
}
if ($objClause = $this->dtgAddress->LimitClause) {
array_push($objClauses, $objClause);
}
$this->dtgAddress->DataSource = Address::LoadAll($objClauses);
}
/**
* Refresh this MetaControl with Data from the local Person object.
* @param boolean $blnReload reload Person from the database
* @return void
*/
public function Refresh($blnReload = false)
{
if ($blnReload) {
$this->objPerson->Reload();
}
if ($this->lblId) {
if ($this->blnEditMode) {
$this->lblId->Text = $this->objPerson->Id;
}
}
if ($this->lstMembershipStatusType) {
$this->lstMembershipStatusType->SelectedValue = $this->objPerson->MembershipStatusTypeId;
}
if ($this->lblMembershipStatusTypeId) {
$this->lblMembershipStatusTypeId->Text = $this->objPerson->MembershipStatusTypeId ? MembershipStatusType::$NameArray[$this->objPerson->MembershipStatusTypeId] : null;
}
if ($this->lstMaritalStatusType) {
$this->lstMaritalStatusType->SelectedValue = $this->objPerson->MaritalStatusTypeId;
}
if ($this->lblMaritalStatusTypeId) {
$this->lblMaritalStatusTypeId->Text = $this->objPerson->MaritalStatusTypeId ? MaritalStatusType::$NameArray[$this->objPerson->MaritalStatusTypeId] : null;
}
if ($this->txtFirstName) {
$this->txtFirstName->Text = $this->objPerson->FirstName;
}
if ($this->lblFirstName) {
$this->lblFirstName->Text = $this->objPerson->FirstName;
}
if ($this->txtMiddleName) {
$this->txtMiddleName->Text = $this->objPerson->MiddleName;
}
if ($this->lblMiddleName) {
$this->lblMiddleName->Text = $this->objPerson->MiddleName;
}
if ($this->txtLastName) {
$this->txtLastName->Text = $this->objPerson->LastName;
}
if ($this->lblLastName) {
$this->lblLastName->Text = $this->objPerson->LastName;
}
if ($this->txtMailingLabel) {
$this->txtMailingLabel->Text = $this->objPerson->MailingLabel;
}
if ($this->lblMailingLabel) {
$this->lblMailingLabel->Text = $this->objPerson->MailingLabel;
}
if ($this->txtPriorLastNames) {
$this->txtPriorLastNames->Text = $this->objPerson->PriorLastNames;
}
if ($this->lblPriorLastNames) {
$this->lblPriorLastNames->Text = $this->objPerson->PriorLastNames;
}
if ($this->txtNickname) {
$this->txtNickname->Text = $this->objPerson->Nickname;
}
if ($this->lblNickname) {
$this->lblNickname->Text = $this->objPerson->Nickname;
}
if ($this->txtTitle) {
$this->txtTitle->Text = $this->objPerson->Title;
}
if ($this->lblTitle) {
$this->lblTitle->Text = $this->objPerson->Title;
}
if ($this->txtSuffix) {
$this->txtSuffix->Text = $this->objPerson->Suffix;
}
if ($this->lblSuffix) {
$this->lblSuffix->Text = $this->objPerson->Suffix;
}
if ($this->txtGender) {
$this->txtGender->Text = $this->objPerson->Gender;
}
if ($this->lblGender) {
$this->lblGender->Text = $this->objPerson->Gender;
}
if ($this->calDateOfBirth) {
$this->calDateOfBirth->DateTime = $this->objPerson->DateOfBirth;
}
if ($this->lblDateOfBirth) {
$this->lblDateOfBirth->Text = sprintf($this->objPerson->DateOfBirth) ? $this->objPerson->__toString($this->strDateOfBirthDateTimeFormat) : null;
}
if ($this->chkDobYearApproximateFlag) {
$this->chkDobYearApproximateFlag->Checked = $this->objPerson->DobYearApproximateFlag;
}
if ($this->lblDobYearApproximateFlag) {
$this->lblDobYearApproximateFlag->Text = $this->objPerson->DobYearApproximateFlag ? QApplication::Translate('Yes') : QApplication::Translate('No');
}
if ($this->chkDobGuessedFlag) {
$this->chkDobGuessedFlag->Checked = $this->objPerson->DobGuessedFlag;
}
if ($this->lblDobGuessedFlag) {
$this->lblDobGuessedFlag->Text = $this->objPerson->DobGuessedFlag ? QApplication::Translate('Yes') : QApplication::Translate('No');
}
if ($this->txtAge) {
$this->txtAge->Text = $this->objPerson->Age;
}
if ($this->lblAge) {
$this->lblAge->Text = $this->objPerson->Age;
}
if ($this->chkDeceasedFlag) {
$this->chkDeceasedFlag->Checked = $this->objPerson->DeceasedFlag;
}
if ($this->lblDeceasedFlag) {
$this->lblDeceasedFlag->Text = $this->objPerson->DeceasedFlag ? QApplication::Translate('Yes') : QApplication::Translate('No');
}
if ($this->calDateDeceased) {
$this->calDateDeceased->DateTime = $this->objPerson->DateDeceased;
}
if ($this->lblDateDeceased) {
$this->lblDateDeceased->Text = sprintf($this->objPerson->DateDeceased) ? $this->objPerson->__toString($this->strDateDeceasedDateTimeFormat) : null;
}
if ($this->lstCurrentHeadShot) {
$this->lstCurrentHeadShot->RemoveAllItems();
$this->lstCurrentHeadShot->AddItem(QApplication::Translate('- Select One -'), null);
$objCurrentHeadShotArray = HeadShot::LoadAll();
if ($objCurrentHeadShotArray) {
foreach ($objCurrentHeadShotArray as $objCurrentHeadShot) {
$objListItem = new QListItem($objCurrentHeadShot->__toString(), $objCurrentHeadShot->Id);
if ($this->objPerson->CurrentHeadShot && $this->objPerson->CurrentHeadShot->Id == $objCurrentHeadShot->Id) {
$objListItem->Selected = true;
}
$this->lstCurrentHeadShot->AddItem($objListItem);
}
}
}
if ($this->lblCurrentHeadShotId) {
$this->lblCurrentHeadShotId->Text = $this->objPerson->CurrentHeadShot ? $this->objPerson->CurrentHeadShot->__toString() : null;
}
if ($this->lstMailingAddress) {
$this->lstMailingAddress->RemoveAllItems();
$this->lstMailingAddress->AddItem(QApplication::Translate('- Select One -'), null);
$objMailingAddressArray = Address::LoadAll();
if ($objMailingAddressArray) {
foreach ($objMailingAddressArray as $objMailingAddress) {
$objListItem = new QListItem($objMailingAddress->__toString(), $objMailingAddress->Id);
if ($this->objPerson->MailingAddress && $this->objPerson->MailingAddress->Id == $objMailingAddress->Id) {
$objListItem->Selected = true;
}
$this->lstMailingAddress->AddItem($objListItem);
}
}
}
if ($this->lblMailingAddressId) {
$this->lblMailingAddressId->Text = $this->objPerson->MailingAddress ? $this->objPerson->MailingAddress->__toString() : null;
}
if ($this->lstStewardshipAddress) {
$this->lstStewardshipAddress->RemoveAllItems();
$this->lstStewardshipAddress->AddItem(QApplication::Translate('- Select One -'), null);
$objStewardshipAddressArray = Address::LoadAll();
if ($objStewardshipAddressArray) {
foreach ($objStewardshipAddressArray as $objStewardshipAddress) {
$objListItem = new QListItem($objStewardshipAddress->__toString(), $objStewardshipAddress->Id);
if ($this->objPerson->StewardshipAddress && $this->objPerson->StewardshipAddress->Id == $objStewardshipAddress->Id) {
$objListItem->Selected = true;
}
$this->lstStewardshipAddress->AddItem($objListItem);
}
}
}
if ($this->lblStewardshipAddressId) {
$this->lblStewardshipAddressId->Text = $this->objPerson->StewardshipAddress ? $this->objPerson->StewardshipAddress->__toString() : null;
}
if ($this->lstPrimaryPhone) {
$this->lstPrimaryPhone->RemoveAllItems();
$this->lstPrimaryPhone->AddItem(QApplication::Translate('- Select One -'), null);
$objPrimaryPhoneArray = Phone::LoadAll();
if ($objPrimaryPhoneArray) {
foreach ($objPrimaryPhoneArray as $objPrimaryPhone) {
$objListItem = new QListItem($objPrimaryPhone->__toString(), $objPrimaryPhone->Id);
if ($this->objPerson->PrimaryPhone && $this->objPerson->PrimaryPhone->Id == $objPrimaryPhone->Id) {
$objListItem->Selected = true;
}
$this->lstPrimaryPhone->AddItem($objListItem);
}
}
}
if ($this->lblPrimaryPhoneId) {
$this->lblPrimaryPhoneId->Text = $this->objPerson->PrimaryPhone ? $this->objPerson->PrimaryPhone->__toString() : null;
}
if ($this->lstPrimaryEmail) {
$this->lstPrimaryEmail->RemoveAllItems();
$this->lstPrimaryEmail->AddItem(QApplication::Translate('- Select One -'), null);
$objPrimaryEmailArray = Email::LoadAll();
if ($objPrimaryEmailArray) {
foreach ($objPrimaryEmailArray as $objPrimaryEmail) {
$objListItem = new QListItem($objPrimaryEmail->__toString(), $objPrimaryEmail->Id);
if ($this->objPerson->PrimaryEmail && $this->objPerson->PrimaryEmail->Id == $objPrimaryEmail->Id) {
$objListItem->Selected = true;
}
$this->lstPrimaryEmail->AddItem($objListItem);
}
}
}
if ($this->lblPrimaryEmailId) {
$this->lblPrimaryEmailId->Text = $this->objPerson->PrimaryEmail ? $this->objPerson->PrimaryEmail->__toString() : null;
}
if ($this->chkCanMailFlag) {
$this->chkCanMailFlag->Checked = $this->objPerson->CanMailFlag;
}
if ($this->lblCanMailFlag) {
$this->lblCanMailFlag->Text = $this->objPerson->CanMailFlag ? QApplication::Translate('Yes') : QApplication::Translate('No');
}
if ($this->chkCanPhoneFlag) {
$this->chkCanPhoneFlag->Checked = $this->objPerson->CanPhoneFlag;
}
if ($this->lblCanPhoneFlag) {
$this->lblCanPhoneFlag->Text = $this->objPerson->CanPhoneFlag ? QApplication::Translate('Yes') : QApplication::Translate('No');
}
if ($this->chkCanEmailFlag) {
$this->chkCanEmailFlag->Checked = $this->objPerson->CanEmailFlag;
}
if ($this->lblCanEmailFlag) {
$this->lblCanEmailFlag->Text = $this->objPerson->CanEmailFlag ? QApplication::Translate('Yes') : QApplication::Translate('No');
}
if ($this->txtPrimaryAddressText) {
$this->txtPrimaryAddressText->Text = $this->objPerson->PrimaryAddressText;
}
if ($this->lblPrimaryAddressText) {
$this->lblPrimaryAddressText->Text = $this->objPerson->PrimaryAddressText;
}
if ($this->txtPrimaryCityText) {
$this->txtPrimaryCityText->Text = $this->objPerson->PrimaryCityText;
}
if ($this->lblPrimaryCityText) {
$this->lblPrimaryCityText->Text = $this->objPerson->PrimaryCityText;
}
if ($this->txtPrimaryStateText) {
$this->txtPrimaryStateText->Text = $this->objPerson->PrimaryStateText;
}
if ($this->lblPrimaryStateText) {
$this->lblPrimaryStateText->Text = $this->objPerson->PrimaryStateText;
}
if ($this->txtPrimaryZipCodeText) {
$this->txtPrimaryZipCodeText->Text = $this->objPerson->PrimaryZipCodeText;
}
if ($this->lblPrimaryZipCodeText) {
$this->lblPrimaryZipCodeText->Text = $this->objPerson->PrimaryZipCodeText;
}
if ($this->txtPrimaryPhoneText) {
$this->txtPrimaryPhoneText->Text = $this->objPerson->PrimaryPhoneText;
}
if ($this->lblPrimaryPhoneText) {
$this->lblPrimaryPhoneText->Text = $this->objPerson->PrimaryPhoneText;
}
if ($this->chkPublicCreationFlag) {
$this->chkPublicCreationFlag->Checked = $this->objPerson->PublicCreationFlag;
}
if ($this->lblPublicCreationFlag) {
$this->lblPublicCreationFlag->Text = $this->objPerson->PublicCreationFlag ? QApplication::Translate('Yes') : QApplication::Translate('No');
}
if ($this->lstCoPrimaryObject) {
$this->lstCoPrimaryObject->RemoveAllItems();
$this->lstCoPrimaryObject->AddItem(QApplication::Translate('- Select One -'), null);
$objCoPrimaryObjectArray = Person::LoadAll();
if ($objCoPrimaryObjectArray) {
foreach ($objCoPrimaryObjectArray as $objCoPrimaryObject) {
$objListItem = new QListItem($objCoPrimaryObject->__toString(), $objCoPrimaryObject->Id);
if ($this->objPerson->CoPrimaryObject && $this->objPerson->CoPrimaryObject->Id == $objCoPrimaryObject->Id) {
$objListItem->Selected = true;
}
$this->lstCoPrimaryObject->AddItem($objListItem);
}
}
}
if ($this->lblCoPrimary) {
$this->lblCoPrimary->Text = $this->objPerson->CoPrimaryObject ? $this->objPerson->CoPrimaryObject->__toString() : null;
}
if ($this->lstHouseholdAsHead) {
$this->lstHouseholdAsHead->RemoveAllItems();
$this->lstHouseholdAsHead->AddItem(QApplication::Translate('- Select One -'), null);
$objHouseholdArray = Household::LoadAll();
if ($objHouseholdArray) {
foreach ($objHouseholdArray as $objHousehold) {
$objListItem = new QListItem($objHousehold->__toString(), $objHousehold->Id);
if ($objHousehold->HeadPersonId == $this->objPerson->Id) {
$objListItem->Selected = true;
}
$this->lstHouseholdAsHead->AddItem($objListItem);
}
}
// Because Household's HouseholdAsHead is not null, if a value is already selected, it cannot be changed.
if ($this->lstHouseholdAsHead->SelectedValue) {
$this->lstHouseholdAsHead->Enabled = false;
} else {
$this->lstHouseholdAsHead->Enabled = true;
}
}
if ($this->lblHouseholdAsHead) {
$this->lblHouseholdAsHead->Text = $this->objPerson->HouseholdAsHead ? $this->objPerson->HouseholdAsHead->__toString() : null;
}
if ($this->lstPublicLogin) {
$this->lstPublicLogin->RemoveAllItems();
$this->lstPublicLogin->AddItem(QApplication::Translate('- Select One -'), null);
$objPublicLoginArray = PublicLogin::LoadAll();
if ($objPublicLoginArray) {
foreach ($objPublicLoginArray as $objPublicLogin) {
$objListItem = new QListItem($objPublicLogin->__toString(), $objPublicLogin->Id);
if ($objPublicLogin->PersonId == $this->objPerson->Id) {
$objListItem->Selected = true;
}
$this->lstPublicLogin->AddItem($objListItem);
}
}
}
if ($this->lblPublicLogin) {
$this->lblPublicLogin->Text = $this->objPerson->PublicLogin ? $this->objPerson->PublicLogin->__toString() : null;
}
if ($this->lstCheckingAccountLookups) {
$this->lstCheckingAccountLookups->RemoveAllItems();
$objAssociatedArray = $this->objPerson->GetCheckingAccountLookupArray();
$objCheckingAccountLookupArray = CheckingAccountLookup::LoadAll();
if ($objCheckingAccountLookupArray) {
foreach ($objCheckingAccountLookupArray as $objCheckingAccountLookup) {
$objListItem = new QListItem($objCheckingAccountLookup->__toString(), $objCheckingAccountLookup->Id);
foreach ($objAssociatedArray as $objAssociated) {
if ($objAssociated->Id == $objCheckingAccountLookup->Id) {
$objListItem->Selected = true;
}
}
$this->lstCheckingAccountLookups->AddItem($objListItem);
}
}
}
if ($this->lblCheckingAccountLookups) {
$objAssociatedArray = $this->objPerson->GetCheckingAccountLookupArray();
$strItems = array();
foreach ($objAssociatedArray as $objAssociated) {
$strItems[] = $objAssociated->__toString();
}
$this->lblCheckingAccountLookups->Text = implode($strGlue, $strItems);
}
if ($this->lstCommunicationLists) {
$this->lstCommunicationLists->RemoveAllItems();
$objAssociatedArray = $this->objPerson->GetCommunicationListArray();
$objCommunicationListArray = CommunicationList::LoadAll();
if ($objCommunicationListArray) {
foreach ($objCommunicationListArray as $objCommunicationList) {
$objListItem = new QListItem($objCommunicationList->__toString(), $objCommunicationList->Id);
foreach ($objAssociatedArray as $objAssociated) {
if ($objAssociated->Id == $objCommunicationList->Id) {
$objListItem->Selected = true;
}
}
$this->lstCommunicationLists->AddItem($objListItem);
}
}
}
if ($this->lblCommunicationLists) {
$objAssociatedArray = $this->objPerson->GetCommunicationListArray();
$strItems = array();
foreach ($objAssociatedArray as $objAssociated) {
$strItems[] = $objAssociated->__toString();
}
$this->lblCommunicationLists->Text = implode($strGlue, $strItems);
}
if ($this->lstNameItems) {
$this->lstNameItems->RemoveAllItems();
$objAssociatedArray = $this->objPerson->GetNameItemArray();
$objNameItemArray = NameItem::LoadAll();
if ($objNameItemArray) {
foreach ($objNameItemArray as $objNameItem) {
$objListItem = new QListItem($objNameItem->__toString(), $objNameItem->Id);
foreach ($objAssociatedArray as $objAssociated) {
if ($objAssociated->Id == $objNameItem->Id) {
$objListItem->Selected = true;
}
}
$this->lstNameItems->AddItem($objListItem);
}
}
}
if ($this->lblNameItems) {
$objAssociatedArray = $this->objPerson->GetNameItemArray();
$strItems = array();
foreach ($objAssociatedArray as $objAssociated) {
$strItems[] = $objAssociated->__toString();
}
$this->lblNameItems->Text = implode($strGlue, $strItems);
}
}
/**
* Refresh this MetaControl with Data from the local AddressCustomFieldHelper object.
* @param boolean $blnReload reload AddressCustomFieldHelper from the database
* @return void
*/
public function Refresh($blnReload = false)
{
if ($blnReload) {
$this->objAddressCustomFieldHelper->Reload();
}
if ($this->lstAddress) {
$this->lstAddress->RemoveAllItems();
if (!$this->blnEditMode) {
$this->lstAddress->AddItem(QApplication::Translate('- Select One -'), null);
}
$objAddressArray = Address::LoadAll();
if ($objAddressArray) {
foreach ($objAddressArray as $objAddress) {
$objListItem = new QListItem($objAddress->__toString(), $objAddress->AddressId);
if ($this->objAddressCustomFieldHelper->Address && $this->objAddressCustomFieldHelper->Address->AddressId == $objAddress->AddressId) {
$objListItem->Selected = true;
}
$this->lstAddress->AddItem($objListItem);
}
}
}
if ($this->lblAddressId) {
$this->lblAddressId->Text = $this->objAddressCustomFieldHelper->Address ? $this->objAddressCustomFieldHelper->Address->__toString() : null;
}
}
/**
* Refresh this MetaControl with Data from the local Phone object.
* @param boolean $blnReload reload Phone from the database
* @return void
*/
public function Refresh($blnReload = false)
{
if ($blnReload) {
$this->objPhone->Reload();
}
if ($this->lblId) {
if ($this->blnEditMode) {
$this->lblId->Text = $this->objPhone->Id;
}
}
if ($this->lstPhoneType) {
$this->lstPhoneType->SelectedValue = $this->objPhone->PhoneTypeId;
}
if ($this->lblPhoneTypeId) {
$this->lblPhoneTypeId->Text = $this->objPhone->PhoneTypeId ? PhoneType::$NameArray[$this->objPhone->PhoneTypeId] : null;
}
if ($this->lstAddress) {
$this->lstAddress->RemoveAllItems();
$this->lstAddress->AddItem(QApplication::Translate('- Select One -'), null);
$objAddressArray = Address::LoadAll();
if ($objAddressArray) {
foreach ($objAddressArray as $objAddress) {
$objListItem = new QListItem($objAddress->__toString(), $objAddress->Id);
if ($this->objPhone->Address && $this->objPhone->Address->Id == $objAddress->Id) {
$objListItem->Selected = true;
}
$this->lstAddress->AddItem($objListItem);
}
}
}
if ($this->lblAddressId) {
$this->lblAddressId->Text = $this->objPhone->Address ? $this->objPhone->Address->__toString() : null;
}
if ($this->lstPerson) {
$this->lstPerson->RemoveAllItems();
$this->lstPerson->AddItem(QApplication::Translate('- Select One -'), null);
$objPersonArray = Person::LoadAll();
if ($objPersonArray) {
foreach ($objPersonArray as $objPerson) {
$objListItem = new QListItem($objPerson->__toString(), $objPerson->Id);
if ($this->objPhone->Person && $this->objPhone->Person->Id == $objPerson->Id) {
$objListItem->Selected = true;
}
$this->lstPerson->AddItem($objListItem);
}
}
}
if ($this->lblPersonId) {
$this->lblPersonId->Text = $this->objPhone->Person ? $this->objPhone->Person->__toString() : null;
}
if ($this->lstMobileProvider) {
$this->lstMobileProvider->RemoveAllItems();
$this->lstMobileProvider->AddItem(QApplication::Translate('- Select One -'), null);
$objMobileProviderArray = MobileProvider::LoadAll();
if ($objMobileProviderArray) {
foreach ($objMobileProviderArray as $objMobileProvider) {
$objListItem = new QListItem($objMobileProvider->__toString(), $objMobileProvider->Id);
if ($this->objPhone->MobileProvider && $this->objPhone->MobileProvider->Id == $objMobileProvider->Id) {
$objListItem->Selected = true;
}
$this->lstMobileProvider->AddItem($objListItem);
}
}
}
if ($this->lblMobileProviderId) {
$this->lblMobileProviderId->Text = $this->objPhone->MobileProvider ? $this->objPhone->MobileProvider->__toString() : null;
}
if ($this->txtNumber) {
$this->txtNumber->Text = $this->objPhone->Number;
}
if ($this->lblNumber) {
$this->lblNumber->Text = $this->objPhone->Number;
}
}
<div class='text-recherche'>
<h1> Trouvez votre medecin </h1>
<p> Et prenez rendez vous immédiatement </p>
<div class="form-recherche">
<form method="post" action="traitement.php">
<input type="text" name="spe" placeholder="Spécialité">
<input type="text" name="ville" placeholder="Ville">
<input type="text" name="adresse" id="pac-input" placeholder="Adresse" onFocus="geolocate()">
<input type="submit" name="Rechercher" value="Rechercher" /><!--onclick="popupGPS()"-->
</form>
</div>
</div>
<?php
$geocoder = "http://maps.googleapis.com/maps/api/geocode/json?address=%s&sensor=false";
$arrAddresses = Address::LoadAll();
// Notre collection d'objets Address
foreach ($arrAddresses as $address) {
if (strlen($address->Lat) == 0 && strlen($address->Lng) == 0) {
$adresse = $address->Rue;
$adresse .= ', ' . $address->CodePostal;
$adresse .= ', ' . $address->Ville;
// Requête envoyée à l'API Geocoding
$query = sprintf($geocoder, urlencode(utf8_encode($adresse)));
$result = json_decode(file_get_contents($query));
$json = $result->results[0];
$adress->Lat = (string) $json->geometry->location->lat;
$adress->Lng = (string) $json->geometry->location->lng;
$adress->Save();
}
}
