PHP QQN::SignupEntry方法代码示例

 public function dtgEvents_Bind()
 {
     $objCondition = QQ::AndCondition(QQ::Equal(QQN::SignupEntry()->PersonId, $this->objPerson->Id), QQ::In(QQN::SignupEntry()->SignupEntryStatusTypeId, array(SignupEntryStatusType::Complete, SignupEntryStatusType::Cancelled)));
     $this->dtgEvents->MetaDataBinder($objCondition);
     // Filter out any we are not allowed to see
     $objDataSource = array();
     foreach ($this->dtgEvents->DataSource as $objSignupEntry) {
         if ($objSignupEntry->SignupForm->IsLoginCanView(QApplication::$Login)) {
             $objDataSource[] = $objSignupEntry;
         }
     }
     $this->dtgEvents->DataSource = $objDataSource;
 }

 /**
  * Count SignupEntries
  * by CommunicationsEntryId Index(es)
  * @param integer $intCommunicationsEntryId
  * @return int
  */
 public static function CountByCommunicationsEntryId($intCommunicationsEntryId, $objOptionalClauses = null)
 {
     // Call SignupEntry::QueryCount to perform the CountByCommunicationsEntryId query
     return SignupEntry::QueryCount(QQ::Equal(QQN::SignupEntry()->CommunicationsEntryId, $intCommunicationsEntryId), $objOptionalClauses);
 }

 protected function btnDialogOkay_Click()
 {
     $objPerson = $this->pnlSelectPerson->Person;
     // Try and find any INCOMPLETE one for this person and redirect to there
     $objSignupEntryArray = SignupEntry::QueryArray(QQ::AndCondition(QQ::Equal(QQN::SignupEntry()->SignupFormId, $this->objSignupForm->Id), QQ::Equal(QQN::SignupEntry()->PersonId, $objPerson->Id)));
     foreach ($objSignupEntryArray as $objSignupEntry) {
         switch ($objSignupEntry->SignupEntryStatusTypeId) {
             case SignupEntryStatusType::Incomplete:
                 QApplication::Redirect(sprintf('/events/result.php/%s/%s', $this->objSignupForm->Id, $objSignupEntry->Id));
                 return;
         }
     }
     // If we are here ,then no incompletes were found -- go ahead and create and redirect to a new one
     $this->CreateAndRedirect($objPerson);
 }

 protected function PaymentDialogBox()
 {
     $this->dlgEdit->ShowDialogBox();
     $this->dlgEdit->Template = dirname(__FILE__) . '/dlgEditResult_Payment.tpl.php';
     $this->intEditTag = self::EditTagPayment;
     // Reset
     $this->ResetDialogControls();
     if (!$this->objPayment->Id) {
         $this->btnDelete->Visible = false;
     }
     $this->txtFloat->Name = 'Amount';
     $this->txtFloat->Required = true;
     $this->txtFloat->Minimum = 0;
     $this->txtFloat->Maximum = null;
     $this->txtTextbox->Text = null;
     $this->txtFloat->Text = null;
     // Setup the appropriate control
     switch ($this->objPayment->SignupPaymentTypeId) {
         case SignupPaymentType::Cash:
             $this->txtTextbox->Name = 'Note';
             break;
         case SignupPaymentType::Check:
             $this->txtTextbox->Name = 'Check Number';
             $this->txtTextbox->Required = true;
             break;
         case SignupPaymentType::CreditCard:
             $this->txtTextbox->Name = 'Transaction Confirmation';
             $this->txtTextbox->Required = true;
             break;
         case SignupPaymentType::Discount:
             $this->txtTextbox->Name = 'Note / Reason';
             $this->txtTextbox->Required = true;
             break;
         case SignupPaymentType::Other:
             $this->txtTextbox->Name = 'Note';
             break;
         case SignupPaymentType::Refund:
             $this->txtTextbox->Name = 'Note';
             $this->txtTextbox->Required = true;
             $this->txtFloat->Maximum = 0;
             $this->txtFloat->Minimum = null;
             break;
         case SignupPaymentType::Scholarship:
             $this->txtTextbox->Name = 'Note / Reason';
             $this->txtTextbox->Required = true;
             break;
         case SignupPaymentType::Transfer:
             $this->txtTextbox->Name = 'Note';
             $this->txtFloat->Maximum = 0;
             $this->txtFloat->Minimum = null;
             $this->lstListbox->Name = 'Transfer To';
             foreach ($this->mctSignupEntry->SignupEntry->SignupForm->GetSignupEntryArray(QQ::OrderBy(QQN::SignupEntry()->Person->LastName, QQN::SignupEntry()->Person->FirstName)) as $objSignupEntry) {
                 $this->lstListbox->AddItem($objSignupEntry->Person->Name, $objSignupEntry->Id);
             }
             $this->lstListbox->Required = true;
             break;
     }
 }

        print ", State And Zip Code";
    } else {
        print "," . EscapeCsv($objFormQuestion->ShortDescription);
    }
}
if ($objSignupForm->CountFormProducts() > 0) {
    foreach ($objSignupForm->GetFormProductArray(QQ::OrderBy(QQN::FormProduct()->FormProductTypeId, QQN::FormProduct()->OrderNumber)) as $objFormProduct) {
        if ($objFormProduct->ViewFlag) {
            print ",";
            print $objFormProduct->Name;
        }
    }
    print ",Total,Paid,Balance,Payment Type";
}
print ",Date Submitted\r\n";
$objCursor = SignupEntry::QueryCursor(QQ::Equal(QQN::SignupEntry()->SignupFormId, $objSignupForm->Id), QQ::OrderBy(QQN::SignupEntry()->DateSubmitted));
while ($objSignupEntry = SignupEntry::InstantiateCursor($objCursor)) {
    if ($objSignupEntry->SignupEntryStatusTypeId == SignupEntryStatusType::Complete) {
        print EscapeCsv($objSignupEntry->Person->FirstName);
        print ",";
        print EscapeCsv($objSignupEntry->Person->LastName);
        print ",";
        foreach ($objFormQuestionArray as $objFormQuestion) {
            $objAnswer = FormAnswer::LoadBySignupEntryIdFormQuestionId($objSignupEntry->Id, $objFormQuestion->Id);
            if ($objAnswer) {
                switch ($objFormQuestion->FormQuestionTypeId) {
                    case FormQuestionType::YesNo:
                        if ($objAnswer->BooleanValue) {
                            print 'Yes';
                        }
                        break;

 public function dtgSignupEntries_Bind()
 {
     $objCondition = QQ::Equal(QQN::SignupEntry()->SignupFormId, $this->objSignupForm->Id);
     $objCondition = QQ::AndCondition($objCondition, QQ::Equal(QQN::SignupEntry()->SignupEntryStatusTypeId, $this->lstStatus->SelectedValue));
     $this->dtgSignupEntries->MetaDataBinder($objCondition);
 }

 /**
  * Used internally by the Meta-based Add Column tools.
  *
  * Given a QQNode or a Text String, this will return a SignupEntry-based QQNode.
  * It will also verify that it is a proper SignupEntry-based QQNode, and will throw an exception otherwise.
  *
  * @param mixed $mixContent
  * @return QQNode
  */
 protected function ResolveContentItem($mixContent)
 {
     if ($mixContent instanceof QQNode) {
         if (!$mixContent->_ParentNode) {
             throw new QCallerException('Content QQNode cannot be a Top Level Node');
         }
         if ($mixContent->_RootTableName == 'signup_entry') {
             if ($mixContent instanceof QQReverseReferenceNode && !$mixContent->_PropertyName) {
                 throw new QCallerException('Content QQNode cannot go through any "To Many" association nodes.');
             }
             $objCurrentNode = $mixContent;
             while ($objCurrentNode = $objCurrentNode->_ParentNode) {
                 if (!$objCurrentNode instanceof QQNode) {
                     throw new QCallerException('Content QQNode cannot go through any "To Many" association nodes.');
                 }
                 if ($objCurrentNode instanceof QQReverseReferenceNode && !$objCurrentNode->_PropertyName) {
                     throw new QCallerException('Content QQNode cannot go through any "To Many" association nodes.');
                 }
             }
             return $mixContent;
         } else {
             throw new QCallerException('Content QQNode has a root table of "' . $mixContent->_RootTableName . '". Must be a root of "signup_entry".');
         }
     } else {
         if (is_string($mixContent)) {
             switch ($mixContent) {
                 case 'Id':
                     return QQN::SignupEntry()->Id;
                 case 'SignupFormId':
                     return QQN::SignupEntry()->SignupFormId;
                 case 'SignupForm':
                     return QQN::SignupEntry()->SignupForm;
                 case 'PersonId':
                     return QQN::SignupEntry()->PersonId;
                 case 'Person':
                     return QQN::SignupEntry()->Person;
                 case 'SignupByPersonId':
                     return QQN::SignupEntry()->SignupByPersonId;
                 case 'SignupByPerson':
                     return QQN::SignupEntry()->SignupByPerson;
                 case 'SignupEntryStatusTypeId':
                     return QQN::SignupEntry()->SignupEntryStatusTypeId;
                 case 'DateCreated':
                     return QQN::SignupEntry()->DateCreated;
                 case 'DateSubmitted':
                     return QQN::SignupEntry()->DateSubmitted;
                 case 'AmountTotal':
                     return QQN::SignupEntry()->AmountTotal;
                 case 'AmountPaid':
                     return QQN::SignupEntry()->AmountPaid;
                 case 'AmountBalance':
                     return QQN::SignupEntry()->AmountBalance;
                 case 'InternalNotes':
                     return QQN::SignupEntry()->InternalNotes;
                 case 'CommunicationsEntryId':
                     return QQN::SignupEntry()->CommunicationsEntryId;
                 case 'CommunicationsEntry':
                     return QQN::SignupEntry()->CommunicationsEntry;
                 case 'ClassRegistration':
                     return QQN::SignupEntry()->ClassRegistration;
                 default:
                     throw new QCallerException('Simple Property not found in SignupEntryDataGrid content: ' . $mixContent);
             }
         } else {
             if ($mixContent instanceof QQAssociationNode) {
                 throw new QCallerException('Content QQNode cannot go through any "To Many" association nodes.');
             } else {
                 throw new QCallerException('Invalid Content type');
             }
         }
     }
 }