protected function Form_Create() { $this->objLocation = GrowthGroupLocation::Load(QApplication::PathInfo(0)); if (!$this->objLocation) { $this->objLocation = GrowthGroupLocation::Load(2); } $this->dtrGrowthGroups = new QDataRepeater($this, 'dtrgg'); $this->dtrGrowthGroups->Template = dirname(__FILE__) . '/dtrGrowthGroups.tpl.php'; $this->dtrGrowthGroups->SetDataBinder('dtrGrowthGroups_Bind'); $this->pnlNone = new QPanel($this, 'pnlnone'); $this->pnlNone->Text = 'No results found. Please use a less restrictive filter.'; $this->intMarkerArray = array(); $intMarkerNumber = 0; // Filter Out "inactive" groups //foreach ($this->objLocation->GetGrowthGroupArray(QQ::Equal(QQN::GrowthGroup()->Group->ActiveFlag, true), //QQ::Clause(QQ::OrderBy(QQN::GrowthGroup()->Group->Name))) as $objGroup) { foreach ($this->objLocation->GetGrowthGroupArray(QQ::OrderBy(QQN::GrowthGroup()->Group->Name)) as $objGroup) { if ($objGroup->Group->ActiveFlag == true) { $intMarkerNumber++; $this->intMarkerArray[$objGroup->GroupId] = $intMarkerNumber; } } $this->lstDays = new QListBox($this); $this->lstDays->AddItem('- View All Days -', null); $this->lstDays->AddAction(new QChangeEvent(), new QAjaxAction('dtrGrowthGroups_Bind')); foreach (GrowthGroupDayType::$NameArray as $intId => $strName) { $this->lstDays->AddItem($strName, $intId); } $this->lstTypes = new QListBox($this); $this->lstTypes->AddItem('- View All Types -', null); $this->lstTypes->AddAction(new QChangeEvent(), new QAjaxAction('dtrGrowthGroups_Bind')); foreach (GrowthGroupStructure::LoadAll(QQ::OrderBy(QQN::GrowthGroupStructure()->Name)) as $objStructure) { $this->lstTypes->AddItem($objStructure->Name, $objStructure->Id); } }
/** * Refresh this MetaControl with Data from the local GroupRegistrations object. * @param boolean $blnReload reload GroupRegistrations from the database * @return void */ public function Refresh($blnReload = false) { if ($blnReload) { $this->objGroupRegistrations->Reload(); } if ($this->lblId) { if ($this->blnEditMode) { $this->lblId->Text = $this->objGroupRegistrations->Id; } } if ($this->lstSourceList) { $this->lstSourceList->RemoveAllItems(); if (!$this->blnEditMode) { $this->lstSourceList->AddItem(QApplication::Translate('- Select One -'), null); } $objSourceListArray = SourceList::LoadAll(); if ($objSourceListArray) { foreach ($objSourceListArray as $objSourceList) { $objListItem = new QListItem($objSourceList->__toString(), $objSourceList->Id); if ($this->objGroupRegistrations->SourceList && $this->objGroupRegistrations->SourceList->Id == $objSourceList->Id) { $objListItem->Selected = true; } $this->lstSourceList->AddItem($objListItem); } } } if ($this->lblSourceListId) { $this->lblSourceListId->Text = $this->objGroupRegistrations->SourceList ? $this->objGroupRegistrations->SourceList->__toString() : null; } if ($this->calDateReceived) { $this->calDateReceived->DateTime = $this->objGroupRegistrations->DateReceived; } if ($this->lblDateReceived) { $this->lblDateReceived->Text = sprintf($this->objGroupRegistrations->DateReceived) ? $this->objGroupRegistrations->__toString($this->strDateReceivedDateTimeFormat) : null; } if ($this->txtFirstName) { $this->txtFirstName->Text = $this->objGroupRegistrations->FirstName; } if ($this->lblFirstName) { $this->lblFirstName->Text = $this->objGroupRegistrations->FirstName; } if ($this->txtLastName) { $this->txtLastName->Text = $this->objGroupRegistrations->LastName; } if ($this->lblLastName) { $this->lblLastName->Text = $this->objGroupRegistrations->LastName; } if ($this->txtGender) { $this->txtGender->Text = $this->objGroupRegistrations->Gender; } if ($this->lblGender) { $this->lblGender->Text = $this->objGroupRegistrations->Gender; } if ($this->txtAddress) { $this->txtAddress->Text = $this->objGroupRegistrations->Address; } if ($this->lblAddress) { $this->lblAddress->Text = $this->objGroupRegistrations->Address; } if ($this->txtPhone) { $this->txtPhone->Text = $this->objGroupRegistrations->Phone; } if ($this->lblPhone) { $this->lblPhone->Text = $this->objGroupRegistrations->Phone; } if ($this->txtEmail) { $this->txtEmail->Text = $this->objGroupRegistrations->Email; } if ($this->lblEmail) { $this->lblEmail->Text = $this->objGroupRegistrations->Email; } if ($this->txtComments) { $this->txtComments->Text = $this->objGroupRegistrations->Comments; } if ($this->lblComments) { $this->lblComments->Text = $this->objGroupRegistrations->Comments; } if ($this->lstGroupRole) { $this->lstGroupRole->RemoveAllItems(); $this->lstGroupRole->AddItem(QApplication::Translate('- Select One -'), null); $objGroupRoleArray = GroupRole::LoadAll(); if ($objGroupRoleArray) { foreach ($objGroupRoleArray as $objGroupRole) { $objListItem = new QListItem($objGroupRole->__toString(), $objGroupRole->Id); if ($this->objGroupRegistrations->GroupRole && $this->objGroupRegistrations->GroupRole->Id == $objGroupRole->Id) { $objListItem->Selected = true; } $this->lstGroupRole->AddItem($objListItem); } } } if ($this->lblGroupRoleId) { $this->lblGroupRoleId->Text = $this->objGroupRegistrations->GroupRole ? $this->objGroupRegistrations->GroupRole->__toString() : null; } if ($this->txtPreferredLocation1) { $this->txtPreferredLocation1->Text = $this->objGroupRegistrations->PreferredLocation1; } if ($this->lblPreferredLocation1) { $this->lblPreferredLocation1->Text = $this->objGroupRegistrations->PreferredLocation1; } if ($this->txtPreferredLocation2) { $this->txtPreferredLocation2->Text = $this->objGroupRegistrations->PreferredLocation2; } if ($this->lblPreferredLocation2) { $this->lblPreferredLocation2->Text = $this->objGroupRegistrations->PreferredLocation2; } if ($this->txtCity) { $this->txtCity->Text = $this->objGroupRegistrations->City; } if ($this->lblCity) { $this->lblCity->Text = $this->objGroupRegistrations->City; } if ($this->txtZipcode) { $this->txtZipcode->Text = $this->objGroupRegistrations->Zipcode; } if ($this->lblZipcode) { $this->lblZipcode->Text = $this->objGroupRegistrations->Zipcode; } if ($this->txtGroupDay) { $this->txtGroupDay->Text = $this->objGroupRegistrations->GroupDay; } if ($this->lblGroupDay) { $this->lblGroupDay->Text = $this->objGroupRegistrations->GroupDay; } if ($this->txtGroupsPlaced) { $this->txtGroupsPlaced->Text = $this->objGroupRegistrations->GroupsPlaced; } if ($this->lblGroupsPlaced) { $this->lblGroupsPlaced->Text = $this->objGroupRegistrations->GroupsPlaced; } if ($this->calDateProcessed) { $this->calDateProcessed->DateTime = $this->objGroupRegistrations->DateProcessed; } if ($this->lblDateProcessed) { $this->lblDateProcessed->Text = sprintf($this->objGroupRegistrations->DateProcessed) ? $this->objGroupRegistrations->__toString($this->strDateProcessedDateTimeFormat) : null; } if ($this->chkProcessedFlag) { $this->chkProcessedFlag->Checked = $this->objGroupRegistrations->ProcessedFlag; } if ($this->lblProcessedFlag) { $this->lblProcessedFlag->Text = $this->objGroupRegistrations->ProcessedFlag ? QApplication::Translate('Yes') : QApplication::Translate('No'); } if ($this->lstGrowthGroupStructuresAsGroupstructure) { $this->lstGrowthGroupStructuresAsGroupstructure->RemoveAllItems(); $objAssociatedArray = $this->objGroupRegistrations->GetGrowthGroupStructureAsGroupstructureArray(); $objGrowthGroupStructureArray = GrowthGroupStructure::LoadAll(); if ($objGrowthGroupStructureArray) { foreach ($objGrowthGroupStructureArray as $objGrowthGroupStructure) { $objListItem = new QListItem($objGrowthGroupStructure->__toString(), $objGrowthGroupStructure->Id); foreach ($objAssociatedArray as $objAssociated) { if ($objAssociated->Id == $objGrowthGroupStructure->Id) { $objListItem->Selected = true; } } $this->lstGrowthGroupStructuresAsGroupstructure->AddItem($objListItem); } } } if ($this->lblGrowthGroupStructuresAsGroupstructure) { $objAssociatedArray = $this->objGroupRegistrations->GetGrowthGroupStructureAsGroupstructureArray(); $strItems = array(); foreach ($objAssociatedArray as $objAssociated) { $strItems[] = $objAssociated->__toString(); } $this->lblGrowthGroupStructuresAsGroupstructure->Text = implode($strGlue, $strItems); } }
public function dtgGroups_Bind() { $objConditions = QQ::All(); $objClauses = array(); $objConditions = QQ::AndCondition($objConditions, QQ::Equal(QQN::GrowthGroup()->Group->ActiveFlag, true)); if ($this->chkDayOfWeek->Checked) { // Map to Days of Week $dayArray = array(); foreach (GrowthGroupDayType::$NameArray as $key => $value) { if (strpos(strtolower($this->objRegistrant->GroupDay), strtolower($value)) !== false) { $dayArray[] = $key; } } $objConditions = QQ::AndCondition($objConditions, QQ::In(QQN::GrowthGroup()->GrowthGroupDayTypeId, $dayArray)); } $growthGroupArray = GrowthGroup::QueryArray($objConditions); if ($this->chkGroupType->Checked) { $requestedGroupStructureArray = array(); foreach (GrowthGroupStructure::LoadAll() as $objGroupStructure) { if ($this->objRegistrant->IsGrowthGroupStructureAsGroupstructureAssociated($objGroupStructure)) { $requestedGroupStructureArray[] = $objGroupStructure; } } $newGrowthGroupArray = array(); foreach ($growthGroupArray as $objGroup) { foreach ($requestedGroupStructureArray as $objGroupStructure) { if ($objGroup->IsGrowthGroupStructureAssociated($objGroupStructure)) { $newGrowthGroupArray[] = $objGroup; break; } } } $growthGroupArray = $newGrowthGroupArray; } if ($this->chkAvailability->Checked) { $newGrowthGroupArray = array(); $intClosed = 0; foreach (AvailabilityStatus::LoadAll() as $objStatus) { if ($objStatus->Name == 'Closed') { $intClosed = $objStatus->Id; } } foreach ($growthGroupArray as $objGroup) { $intStatus = Group::Load($objGroup->GroupId)->Status; if ($intStatus != $intClosed) { $newGrowthGroupArray[] = $objGroup; } } $growthGroupArray = $newGrowthGroupArray; } if ($this->chkLocation->Checked) { // Map to our existing Growth Group Locations $locationIdArray = array(); $strLocationArray = array($this->objRegistrant->PreferredLocation1, $this->objRegistrant->PreferredLocation2); for ($i = 0; $i < 2; $i++) { if (null != $strLocationArray[$i]) { switch ($strLocationArray[$i]) { case 'Foster City': case 'San Bruno': case 'San Carlos': case 'San Mateo': case 'San Francisco': case 'South San Francisco': $locationIdArray[] = 1; break; case 'East Palo Alto': case 'Mountain View': case 'Menlo Park': case 'Palo Alto': case 'Redwood City': $locationIdArray[] = 2; break; case 'Campbell': case 'Cupertino': case 'Los Altos': case 'Sunnyvale': $locationIdArray[] = 3; break; case 'San Jose': case 'South San Jose': case 'Santa Clara': $locationIdArray[] = 4; break; case 'Fremont': case 'Milpitas': case 'Newark ': case 'Pleasanton': case 'Tracy': $locationIdArray[] = 5; break; case 'Oakland': case 'Clayton': $locationIdArray[] = 6; break; } } } $newGrowthGroupArray = array(); foreach ($growthGroupArray as $objGroup) { if (in_array($objGroup->GrowthGroupLocationId, $locationIdArray)) { $newGrowthGroupArray[] = $objGroup; } } $growthGroupArray = $newGrowthGroupArray; } $this->dtgGroups->DataSource = $growthGroupArray; }
/** * Refresh this MetaControl with Data from the local GrowthGroup object. * @param boolean $blnReload reload GrowthGroup from the database * @return void */ public function Refresh($blnReload = false) { if ($blnReload) { $this->objGrowthGroup->Reload(); } if ($this->lstGroup) { $this->lstGroup->RemoveAllItems(); if (!$this->blnEditMode) { $this->lstGroup->AddItem(QApplication::Translate('- Select One -'), null); } $objGroupArray = Group::LoadAll(); if ($objGroupArray) { foreach ($objGroupArray as $objGroup) { $objListItem = new QListItem($objGroup->__toString(), $objGroup->Id); if ($this->objGrowthGroup->Group && $this->objGrowthGroup->Group->Id == $objGroup->Id) { $objListItem->Selected = true; } $this->lstGroup->AddItem($objListItem); } } } if ($this->lblGroupId) { $this->lblGroupId->Text = $this->objGrowthGroup->Group ? $this->objGrowthGroup->Group->__toString() : null; } if ($this->lstGrowthGroupLocation) { $this->lstGrowthGroupLocation->RemoveAllItems(); if (!$this->blnEditMode) { $this->lstGrowthGroupLocation->AddItem(QApplication::Translate('- Select One -'), null); } $objGrowthGroupLocationArray = GrowthGroupLocation::LoadAll(); if ($objGrowthGroupLocationArray) { foreach ($objGrowthGroupLocationArray as $objGrowthGroupLocation) { $objListItem = new QListItem($objGrowthGroupLocation->__toString(), $objGrowthGroupLocation->Id); if ($this->objGrowthGroup->GrowthGroupLocation && $this->objGrowthGroup->GrowthGroupLocation->Id == $objGrowthGroupLocation->Id) { $objListItem->Selected = true; } $this->lstGrowthGroupLocation->AddItem($objListItem); } } } if ($this->lblGrowthGroupLocationId) { $this->lblGrowthGroupLocationId->Text = $this->objGrowthGroup->GrowthGroupLocation ? $this->objGrowthGroup->GrowthGroupLocation->__toString() : null; } if ($this->lstGrowthGroupDayType) { $this->lstGrowthGroupDayType->SelectedValue = $this->objGrowthGroup->GrowthGroupDayTypeId; } if ($this->lblGrowthGroupDayTypeId) { $this->lblGrowthGroupDayTypeId->Text = $this->objGrowthGroup->GrowthGroupDayTypeId ? GrowthGroupDayType::$NameArray[$this->objGrowthGroup->GrowthGroupDayTypeId] : null; } if ($this->txtMeetingBitmap) { $this->txtMeetingBitmap->Text = $this->objGrowthGroup->MeetingBitmap; } if ($this->lblMeetingBitmap) { $this->lblMeetingBitmap->Text = $this->objGrowthGroup->MeetingBitmap; } if ($this->txtStartTime) { $this->txtStartTime->Text = $this->objGrowthGroup->StartTime; } if ($this->lblStartTime) { $this->lblStartTime->Text = $this->objGrowthGroup->StartTime; } if ($this->txtEndTime) { $this->txtEndTime->Text = $this->objGrowthGroup->EndTime; } if ($this->lblEndTime) { $this->lblEndTime->Text = $this->objGrowthGroup->EndTime; } if ($this->txtAddress1) { $this->txtAddress1->Text = $this->objGrowthGroup->Address1; } if ($this->lblAddress1) { $this->lblAddress1->Text = $this->objGrowthGroup->Address1; } if ($this->txtAddress2) { $this->txtAddress2->Text = $this->objGrowthGroup->Address2; } if ($this->lblAddress2) { $this->lblAddress2->Text = $this->objGrowthGroup->Address2; } if ($this->txtCrossStreet1) { $this->txtCrossStreet1->Text = $this->objGrowthGroup->CrossStreet1; } if ($this->lblCrossStreet1) { $this->lblCrossStreet1->Text = $this->objGrowthGroup->CrossStreet1; } if ($this->txtCrossStreet2) { $this->txtCrossStreet2->Text = $this->objGrowthGroup->CrossStreet2; } if ($this->lblCrossStreet2) { $this->lblCrossStreet2->Text = $this->objGrowthGroup->CrossStreet2; } if ($this->txtZipCode) { $this->txtZipCode->Text = $this->objGrowthGroup->ZipCode; } if ($this->lblZipCode) { $this->lblZipCode->Text = $this->objGrowthGroup->ZipCode; } if ($this->txtLongitude) { $this->txtLongitude->Text = $this->objGrowthGroup->Longitude; } if ($this->lblLongitude) { $this->lblLongitude->Text = $this->objGrowthGroup->Longitude; } if ($this->txtLatitude) { $this->txtLatitude->Text = $this->objGrowthGroup->Latitude; } if ($this->lblLatitude) { $this->lblLatitude->Text = $this->objGrowthGroup->Latitude; } if ($this->txtAccuracy) { $this->txtAccuracy->Text = $this->objGrowthGroup->Accuracy; } if ($this->lblAccuracy) { $this->lblAccuracy->Text = $this->objGrowthGroup->Accuracy; } if ($this->txtDescription) { $this->txtDescription->Text = $this->objGrowthGroup->Description; } if ($this->lblDescription) { $this->lblDescription->Text = $this->objGrowthGroup->Description; } if ($this->lstGrowthGroupStructures) { $this->lstGrowthGroupStructures->RemoveAllItems(); $objAssociatedArray = $this->objGrowthGroup->GetGrowthGroupStructureArray(); $objGrowthGroupStructureArray = GrowthGroupStructure::LoadAll(); if ($objGrowthGroupStructureArray) { foreach ($objGrowthGroupStructureArray as $objGrowthGroupStructure) { $objListItem = new QListItem($objGrowthGroupStructure->__toString(), $objGrowthGroupStructure->Id); foreach ($objAssociatedArray as $objAssociated) { if ($objAssociated->Id == $objGrowthGroupStructure->Id) { $objListItem->Selected = true; } } $this->lstGrowthGroupStructures->AddItem($objListItem); } } } if ($this->lblGrowthGroupStructures) { $objAssociatedArray = $this->objGrowthGroup->GetGrowthGroupStructureArray(); $strItems = array(); foreach ($objAssociatedArray as $objAssociated) { $strItems[] = $objAssociated->__toString(); } $this->lblGrowthGroupStructures->Text = implode($strGlue, $strItems); } }
public function RenderGroupTypes(GroupRegistrations $objGroupRegistration) { $strReturn = ''; foreach (GrowthGroupStructure::LoadAll() as $objGrowthGroupStructure) { if ($objGroupRegistration->IsGrowthGroupStructureAsGroupstructureAssociated($objGrowthGroupStructure)) { $strReturn .= $objGrowthGroupStructure->Name . ', '; } } return substr($strReturn, 0, strlen($strReturn) - 2); }
print EscapeCsv($objGroupRegistrant->Address); print ","; print EscapeCsv($objGroupRegistrant->City); print ","; print EscapeCsv($objGroupRegistrant->Zipcode); print ","; print EscapeCsv($objGroupRegistrant->DateReceived->ToString('M/D/YYYY')); print ","; print EscapeCsv($objGroupRegistrant->PreferredLocation1); print ","; print EscapeCsv($objGroupRegistrant->PreferredLocation2); print ","; print EscapeCsv($objGroupRegistrant->GroupRole->Name); print ","; $strReturn = ''; foreach (GrowthGroupStructure::LoadAll() as $objGrowthGroupStructure) { if ($objGroupRegistrant->IsGrowthGroupStructureAsGroupstructureAssociated($objGrowthGroupStructure)) { $strReturn .= $objGrowthGroupStructure->Name . ', '; } } $strReturn = substr($strReturn, 0, strlen($strReturn) - 2); print EscapeCsv($strReturn); print ","; print EscapeCsv($objGroupRegistrant->GroupDay); print ","; print EscapeCsv(SourceList::Load($objGroupRegistrant->SourceListId)->Name); print ","; if ($objGroupRegistrant->ProcessedFlag) { print 'Yes'; } else { print 'No';