public function lstQuantity_Change($strFormId, $strControlId, $strParameter)
{
$lstQuantity = $this->GetControl($strControlId);
$objFormProduct = FormProduct::Load($strParameter);
$objSignupProduct = SignupProduct::LoadBySignupEntryIdFormProductId($this->objSignupEntry->Id, $objFormProduct->Id);
if (!$objSignupProduct) {
if ($lstQuantity->SelectedValue) {
$this->objSignupEntry->AddProduct($objFormProduct, $lstQuantity->SelectedValue);
}
} else {
if ($lstQuantity->SelectedValue) {
$objSignupProduct->Quantity = $lstQuantity->SelectedValue;
$objSignupProduct->Save();
} else {
$objSignupProduct->Delete();
}
$this->objSignupEntry->RefreshAmounts();
}
$this->RefreshForm();
}
/**
* Deletes all associated SignupProducts
* @return void
*/
public function DeleteAllSignupProducts()
{
if (is_null($this->intId)) {
throw new QUndefinedPrimaryKeyException('Unable to call UnassociateSignupProduct on this unsaved SignupEntry.');
}
// Get the Database Object for this Class
$objDatabase = SignupEntry::GetDatabase();
// Journaling
if ($objDatabase->JournalingDatabase) {
foreach (SignupProduct::LoadArrayBySignupEntryId($this->intId) as $objSignupProduct) {
$objSignupProduct->Journal('DELETE');
}
}
// Perform the SQL Query
$objDatabase->NonQuery('
DELETE FROM
`signup_product`
WHERE
`signup_entry_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 SignupProductMetaControl
* @param integer $intId primary key value
* @param QMetaControlCreateType $intCreateType rules governing SignupProduct object creation - defaults to CreateOrEdit
* @return SignupProductMetaControl
*/
public static function Create($objParentObject, $intId = null, $intCreateType = QMetaControlCreateType::CreateOrEdit)
{
// Attempt to Load from PK Arguments
if (strlen($intId)) {
$objSignupProduct = SignupProduct::Load($intId);
// SignupProduct was found -- return it!
if ($objSignupProduct) {
return new SignupProductMetaControl($objParentObject, $objSignupProduct);
} else {
if ($intCreateType != QMetaControlCreateType::CreateOnRecordNotFound) {
throw new QCallerException('Could not find a SignupProduct 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 SignupProductMetaControl($objParentObject, new SignupProduct());
}
/**
* Adds a product selection to this signup entry
* @param FormProduct $objFormProduct
* @param integer $intQuantity only specify if we are dealing with an "optional" product, otherwise we assume 1
* @param float $fltAmount only specify if we are allowed a variable amount to specify (e.g. for a donation), otherwise leave blank
* @return SignupProduct
*/
public function AddProduct(FormProduct $objFormProduct, $intQuantity = 1, $fltAmount = 0)
{
$objSignupProduct = new SignupProduct();
$objSignupProduct->SignupEntry = $this;
$objSignupProduct->FormProduct = $objFormProduct;
switch ($objFormProduct->FormProductTypeId) {
case FormProductType::Required:
$objSignupProduct->Quantity = 1;
break;
case FormProductType::RequiredWithChoice:
$objSignupProduct->Quantity = 1;
break;
case FormProductType::Optional:
if ($intQuantity < $objFormProduct->MinimumQuantity || $intQuantity > $objFormProduct->MaximumQuantity) {
$intQuantity = $objFormProduct->MinimumQuantity;
}
$objSignupProduct->Quantity = $intQuantity;
break;
default:
throw new Exception('Unhandled FormProductTypeId: ' . $objFormProduct->FormProductTypeId);
}
switch ($objFormProduct->FormPaymentTypeId) {
case FormPaymentType::PayInFull:
$objSignupProduct->Amount = $objFormProduct->Cost;
break;
case FormPaymentType::DepositRequired:
$objSignupProduct->Amount = $objFormProduct->Cost;
$objSignupProduct->Deposit = $objFormProduct->Deposit;
break;
case FormPaymentType::Donation:
if ($fltAmount < 0) {
throw new QCallerException('Invalid Amount entered for Donation');
}
$objSignupProduct->Amount = $fltAmount;
break;
default:
throw new Exception('Unhandled FormPaymentTypeId: ' . $objFormProduct->FormPaymentTypeId);
}
$objSignupProduct->Save();
$this->RefreshAmounts();
return $objSignupProduct;
}
/**
* @return boolean whether or not the save was successful
*/
protected function PerformSignupProductSave()
{
/**
* @var SignupEntry
*/
$objSignupEntry = $this->mctSignupEntry->SignupEntry;
/**
* @var FormProduct
*/
$objFormProduct = $this->objSignupProduct->FormProduct;
// Delete the "other" required w/ choice items if we are switching it
if ($objFormProduct->FormProductTypeId == FormProductType::RequiredWithChoice) {
foreach ($objSignupEntry->GetSignupProductArray() as $objSignupProduct) {
if ($objSignupProduct->FormProduct->FormProductTypeId == FormProductType::RequiredWithChoice && $objSignupProduct->Id != $this->objSignupProduct->Id) {
$objSignupProduct->Delete();
}
}
}
$this->objSignupProduct->Quantity = $this->lstListbox->SelectedValue;
$this->objSignupProduct->Amount = $this->txtFloat->Text;
$this->objSignupProduct->Save();
return true;
}
/**
* 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 = SignupProduct::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 SignupProduct, given the clauses above
$this->DataSource = SignupProduct::QueryArray($objCondition, $objClauses);
}
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);
print ",";
$strReturn = '';
public function RenderProductQuantity(SignupEntry $objSignupEntry, $intFormProductId)
{
$objSignupProduct = SignupProduct::LoadBySignupEntryIdFormProductId($objSignupEntry->Id, $intFormProductId);
if (!$objSignupProduct) {
return;
}
return $objSignupProduct->Quantity;
}