/**
* Counts all many-to-many associated GroupRegistrationsesAsGroupstructure
* @return int
*/
public function CountGroupRegistrationsesAsGroupstructure()
{
if (is_null($this->intId)) {
return 0;
}
return GroupRegistrations::CountByGrowthGroupStructureAsGroupstructure($this->intId);
}
/**
* Deletes all associated GroupRegistrationses
* @return void
*/
public function DeleteAllGroupRegistrationses()
{
if (is_null($this->intId)) {
throw new QUndefinedPrimaryKeyException('Unable to call UnassociateGroupRegistrations on this unsaved GroupRole.');
}
// Get the Database Object for this Class
$objDatabase = GroupRole::GetDatabase();
// Journaling
if ($objDatabase->JournalingDatabase) {
foreach (GroupRegistrations::LoadArrayByGroupRoleId($this->intId) as $objGroupRegistrations) {
$objGroupRegistrations->Journal('DELETE');
}
}
// Perform the SQL Query
$objDatabase->NonQuery('
DELETE FROM
`group_registrations`
WHERE
`group_role_id` = ' . $objDatabase->SqlVariable($this->intId) . '
');
}
/**
* 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 GroupRegistrationsMetaControl
* @param integer $intId primary key value
* @param QMetaControlCreateType $intCreateType rules governing GroupRegistrations object creation - defaults to CreateOrEdit
* @return GroupRegistrationsMetaControl
*/
public static function Create($objParentObject, $intId = null, $intCreateType = QMetaControlCreateType::CreateOrEdit)
{
// Attempt to Load from PK Arguments
if (strlen($intId)) {
$objGroupRegistrations = GroupRegistrations::Load($intId);
// GroupRegistrations was found -- return it!
if ($objGroupRegistrations) {
return new GroupRegistrationsMetaControl($objParentObject, $objGroupRegistrations);
} else {
if ($intCreateType != QMetaControlCreateType::CreateOnRecordNotFound) {
throw new QCallerException('Could not find a GroupRegistrations 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 GroupRegistrationsMetaControl($objParentObject, new GroupRegistrations());
}
/**
* 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 = GroupRegistrations::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 GroupRegistrations, given the clauses above
$this->DataSource = GroupRegistrations::QueryArray($objCondition, $objClauses);
}
protected function lstGroupRegistrationsesAsGroupstructure_Update()
{
if ($this->lstGroupRegistrationsesAsGroupstructure) {
$this->objGrowthGroupStructure->UnassociateAllGroupRegistrationsesAsGroupstructure();
$objSelectedListItems = $this->lstGroupRegistrationsesAsGroupstructure->SelectedItems;
if ($objSelectedListItems) {
foreach ($objSelectedListItems as $objListItem) {
$this->objGrowthGroupStructure->AssociateGroupRegistrationsAsGroupstructure(GroupRegistrations::Load($objListItem->Value));
}
}
}
}
public static function GetSoapArrayFromArray($objArray)
{
if (!$objArray) {
return null;
}
$objArrayToReturn = array();
foreach ($objArray as $objObject) {
array_push($objArrayToReturn, GroupRegistrations::GetSoapObjectFromObject($objObject, true));
}
return unserialize(serialize($objArrayToReturn));
}
public function btnProcess_Clicked($strFormId, $strControlId, $strParameter)
{
$objGroupRegistrant = GroupRegistrations::Load($strParameter);
// Clear the panel and load it again
$this->pnlStep1->RemoveChildControls(true);
$this->pnlStep2->RemoveChildControls(true);
$pnlProjectView = new CpGroup_RegistrationStep1Panel($this->pnlStep1, $this->pnlStep2, $objGroupRegistrant, 'RefreshRegistrants');
}
require dirname(__FILE__) . '/../../includes/prepend.inc.php';
QApplication::Authenticate();
// Disable strict no-cache for IE due to IE issues with downloading no-cache items
if (QApplication::IsBrowser(QBrowserType::InternetExplorer)) {
header("Pragma:");
header("Expires:");
}
header('Content-Type: text/csv');
header('Content-Disposition: attachment; filename=gg_registrations.csv');
print "First Name,Last Name,E-mail,Address,City,Zip Code,Date Received,Preferred Location 1, Preferred Location 2, Requested Group Role, Requested Group Types, Requested Group Days, Source, Processed,Groups Placed, Placement Date\r\n";
$objGroupRegistrantCursor = GroupRegistrations::QueryCursor(QQ::All());
function EscapeCsv($strString)
{
return '"' . str_replace('"', '""', $strString) . '"';
}
while ($objGroupRegistrant = GroupRegistrations::InstantiateCursor($objGroupRegistrantCursor)) {
print EscapeCsv($objGroupRegistrant->FirstName);
print ",";
print EscapeCsv($objGroupRegistrant->LastName);
print ",";
print EscapeCsv($objGroupRegistrant->Email);
print ",";
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);
