PHP QQN::FormProduct方法代码示例

 public function MoveDown()
 {
     $blnFound = false;
     foreach (FormProduct::LoadArrayBySignupFormIdFormProductTypeId($this->intSignupFormId, $this->intFormProductTypeId, QQ::OrderBy(QQN::FormProduct()->OrderNumber)) as $objFormProduct) {
         if ($blnFound) {
             break;
         }
         if ($objFormProduct->Id == $this->Id) {
             $blnFound = true;
         }
     }
     $this->OrderNumber++;
     $this->Save();
     if ($objFormProduct) {
         $objFormProduct->OrderNumber--;
         $objFormProduct->Save();
     }
     self::RefreshOrderNumber($this->intSignupFormId, $this->intFormProductTypeId);
 }

 public function dtgProducts_Bind()
 {
     $arrDataSource = array();
     // First add any required products
     foreach ($this->objSignupForm->GetFormProductArrayByType(FormProductType::Required, QQ::OrderBy(QQN::FormProduct()->OrderNumber)) as $objProduct) {
         if ($objProduct->IsAvailableRightNow()) {
             $arrDataSource[] = $objProduct;
         }
     }
     // If there are any valid "Required with Choice" products, add the row for it
     foreach ($this->objSignupForm->GetFormProductArrayByType(FormProductType::RequiredWithChoice, QQ::OrderBy(QQN::FormProduct()->OrderNumber)) as $objProduct) {
         if ($objProduct->IsAvailableRightNow()) {
             $arrDataSource[] = -1;
             break;
         }
     }
     // Add any optional products
     foreach ($this->objSignupForm->GetFormProductArrayByType(FormProductType::Optional, QQ::OrderBy(QQN::FormProduct()->OrderNumber)) as $objProduct) {
         if ($objProduct->IsAvailableRightNow()) {
             $arrDataSource[] = $objProduct;
         }
     }
     // Add any payments
     $arrDataSource = array_merge($arrDataSource, $this->objSignupEntry->GetSignupPaymentArray(QQ::OrderBy(QQN::SignupPayment()->TransactionDate)));
     // Add "Balance Due"
     $arrDataSource[] = null;
     $this->dtgProducts->DataSource = $arrDataSource;
 }

 protected function dtgFormProducts_Bind()
 {
     $this->dtgFormProducts->DataSource = $this->objSignupForm->GetFormProductArray(QQ::OrderBy(QQN::FormProduct()->FormProductTypeId, QQN::FormProduct()->OrderNumber));
 }

 /**
  * Used internally by the Meta-based Add Column tools.
  *
  * Given a QQNode or a Text String, this will return a FormProduct-based QQNode.
  * It will also verify that it is a proper FormProduct-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 == 'form_product') {
             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 "form_product".');
         }
     } else {
         if (is_string($mixContent)) {
             switch ($mixContent) {
                 case 'Id':
                     return QQN::FormProduct()->Id;
                 case 'SignupFormId':
                     return QQN::FormProduct()->SignupFormId;
                 case 'SignupForm':
                     return QQN::FormProduct()->SignupForm;
                 case 'OrderNumber':
                     return QQN::FormProduct()->OrderNumber;
                 case 'FormProductTypeId':
                     return QQN::FormProduct()->FormProductTypeId;
                 case 'FormPaymentTypeId':
                     return QQN::FormProduct()->FormPaymentTypeId;
                 case 'Name':
                     return QQN::FormProduct()->Name;
                 case 'Description':
                     return QQN::FormProduct()->Description;
                 case 'DateStart':
                     return QQN::FormProduct()->DateStart;
                 case 'DateEnd':
                     return QQN::FormProduct()->DateEnd;
                 case 'MinimumQuantity':
                     return QQN::FormProduct()->MinimumQuantity;
                 case 'MaximumQuantity':
                     return QQN::FormProduct()->MaximumQuantity;
                 case 'Cost':
                     return QQN::FormProduct()->Cost;
                 case 'Deposit':
                     return QQN::FormProduct()->Deposit;
                 case 'ViewFlag':
                     return QQN::FormProduct()->ViewFlag;
                 default:
                     throw new QCallerException('Simple Property not found in FormProductDataGrid 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');
             }
         }
     }
 }

                 break;
             case FormQuestionType::Number:
             case FormQuestionType::Age:
                 print $objAnswer->IntegerValue;
                 break;
             case FormQuestionType::DateofBirth:
                 if ($objAnswer->DateValue) {
                     print $objAnswer->DateValue->ToString('M/D/YYYY');
                 }
                 break;
         }
     }
     print ",";
 }
 if ($objSignupForm->CountFormProducts() > 0) {
     foreach ($objSignupForm->GetFormProductArray(QQ::OrderBy(QQN::FormProduct()->FormProductTypeId, QQN::FormProduct()->OrderNumber)) as $objFormProduct) {
         if ($objFormProduct->ViewFlag) {
             $objSignupProduct = SignupProduct::LoadBySignupEntryIdFormProductId($objSignupEntry->Id, $objFormProduct->Id);
             if ($objSignupProduct) {
                 print QApplication::DisplayCurrency($objSignupProduct->Amount);
             } else {
                 print " ";
             }
             print ",";
         }
     }
     print QApplication::DisplayCurrency($objSignupEntry->AmountTotal);
     print ",";
     print QApplication::DisplayCurrency($objSignupEntry->AmountPaid);
     print ",";
     print QApplication::DisplayCurrency($objSignupEntry->AmountBalance);

 public function dtgSignupEntries_SetupColumns()
 {
     $this->dtgSignupEntries->RemoveAllColumns();
     $this->dtgSignupEntries->MetaAddColumn(QQN::SignupEntry()->Person->LastName, 'Name=Name', 'Html=<?= $_FORM->RenderName($_ITEM); ?>', 'HtmlEntities=false');
     //			$this->dtgSignupEntries->MetaAddTypeColumn('SignupEntryStatusTypeId', 'SignupEntryStatusType', 'Name=Status');
     foreach ($this->objSignupForm->GetFormQuestionArray(QQ::OrderBy(QQN::FormQuestion()->OrderNumber)) as $objFormQuestion) {
         if ($objFormQuestion->ViewFlag) {
             $this->dtgSignupEntries->AddColumn(new QDataGridColumn($objFormQuestion->ShortDescription, '<?= $_FORM->RenderAnswer($_ITEM, ' . $objFormQuestion->Id . ',' . $objFormQuestion->FormQuestionTypeId . '); ?>', 'HtmlEntities=false'));
         }
     }
     foreach ($this->objSignupForm->GetFormProductArray(QQ::OrderBy(QQN::FormProduct()->FormProductTypeId, QQN::FormProduct()->OrderNumber)) as $objFormProduct) {
         if ($objFormProduct->ViewFlag) {
             /* $this->dtgSignupEntries->AddColumn(new QDataGridColumn($objFormProduct->Name. ' Quantity', '<?= $_FORM->RenderProductQuantity($_ITEM, ' . $objFormProduct->Id . '); ?>', 'HtmlEntities=false'));*/
             $this->dtgSignupEntries->AddColumn(new QDataGridColumn($objFormProduct->Name, '<?= $_FORM->RenderProductAmount($_ITEM, ' . $objFormProduct->Id . '); ?>', 'HtmlEntities=false'));
         }
     }
     if ($this->objSignupForm->CountFormProducts()) {
         $this->dtgSignupEntries->MetaAddColumn(QQN::SignupEntry()->AmountPaid, 'Name=Paid', 'Html=<?= $_FORM->RenderAmount($_ITEM->AmountPaid); ?>');
         $this->dtgSignupEntries->MetaAddColumn(QQN::SignupEntry()->AmountBalance, 'Name=Balance', 'Html=<?= $_FORM->RenderAmount($_ITEM->AmountBalance); ?>');
         $this->dtgSignupEntries->AddColumn(new QDataGridColumn('Payment Type', '<?= $_FORM->RenderPaymentType($_ITEM); ?>', 'HtmlEntities=false'));
     }
     $this->dtgSignupEntries->MetaAddColumn(QQN::SignupEntry()->DateSubmitted, 'Name=Submitted', 'Html=<?= $_ITEM->DateSubmitted ? $_ITEM->DateSubmitted->ToString("MMM D YYYY") : null; ?>');
 }

 public function dtgProducts_Bind(QDataGrid $dtgProducts)
 {
     $intFormProductTypeId = $dtgProducts->Name;
     $dtgProducts->DataSource = FormProduct::LoadArrayBySignupFormIdFormProductTypeId($this->objSignupForm->Id, $intFormProductTypeId, QQ::OrderBy(QQN::FormProduct()->OrderNumber));
 }

 /**
  * @param integer $intFormProductTypeId
  * @param QClause[] $objClauses
  * @return integer
  */
 public function CountFormProductsByType($intFormProductTypeId, $objClauses = array())
 {
     return FormProduct::QueryCount(QQ::AndCondition(QQ::Equal(QQN::FormProduct()->SignupFormId, $this->Id), QQ::Equal(QQN::FormProduct()->FormProductTypeId, $intFormProductTypeId)), $objClauses);
 }

 /**
  * Count FormProducts
  * by FormPaymentTypeId Index(es)
  * @param integer $intFormPaymentTypeId
  * @return int
  */
 public static function CountByFormPaymentTypeId($intFormPaymentTypeId, $objOptionalClauses = null)
 {
     // Call FormProduct::QueryCount to perform the CountByFormPaymentTypeId query
     return FormProduct::QueryCount(QQ::Equal(QQN::FormProduct()->FormPaymentTypeId, $intFormPaymentTypeId), $objOptionalClauses);
 }