/** * 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 = AssetModel::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 AssetModel, given the clauses above $this->DataSource = AssetModel::QueryArray($objCondition, $objClauses); }
/** * Load an array of AssetModel objects, * by ModifiedBy Index(es) * @param integer $intModifiedBy * @param QQClause[] $objOptionalClauses additional optional QQClause objects for this query * @return AssetModel[] */ public static function LoadArrayByModifiedBy($intModifiedBy, $objOptionalClauses = null) { // Call AssetModel::QueryArray to perform the LoadArrayByModifiedBy query try { return AssetModel::QueryArray(QQ::Equal(QQN::AssetModel()->ModifiedBy, $intModifiedBy), $objOptionalClauses); } catch (QCallerException $objExc) { $objExc->IncrementOffset(); throw $objExc; } }
public function btnAssetModelSearchToolAdd_Click() { $this->ctlAssetModelSearchTool->lblWarning->Text = ""; $intSelectedAssetModelId = $this->ctlAssetModelSearchTool->ctlAssetModelSearch->dtgAssetModel->GetSelected("AssetModelId"); if (count($intSelectedAssetModelId) < 1) { $this->ctlAssetModelSearchTool->lblWarning->Text = "No selected models."; } else { $lblNewWarning = ""; foreach (AssetModel::QueryArray(QQ::In(QQN::AssetModel()->AssetModelId, $intSelectedAssetModelId)) as $objNewAssetModel) { $blnExists = false; foreach ($this->arrAssetModels as $objAssetModel) { if ($objAssetModel->AssetModelId == $objNewAssetModel->AssetModelId) { $blnExists = true; } } if ($blnExists) { $lblNewWarning .= sprintf("<br />%s - already in list", $objNewAssetModel->AssetModelCode); } else { $objAssetModelToAdd = new AssetCustomFieldAssetModel(); $objAssetModelToAdd->AssetModelId = $objNewAssetModel->AssetModelId; $objAssetModelToAdd->CustomFieldId = $this->objCustomField->CustomFieldId; array_push($this->arrAssetModels, $objAssetModelToAdd); } } $this->lstAddAssetModel->Warning = $lblNewWarning; $this->ctlAssetModelSearchTool->dlgAssetModelSearchTool->HideDialogBox(); } // Uncheck all items but SelectAll checkbox $this->UncheckAllItems(); $this->dtgAssetModels->Refresh(); }
/** * Load an array of AssetModel objects, * by DepreciationClassId Index(es) * @param integer $intDepreciationClassId * @param QQClause[] $objOptionalClauses additional optional QQClause objects for this query * @return AssetModel[] */ public static function LoadArrayByDepreciationClassId($intDepreciationClassId, $objOptionalClauses = null) { // Call AssetModel::QueryArray to perform the LoadArrayByDepreciationClassId query try { return AssetModel::QueryArray(QQ::Equal(QQN::AssetModel()->DepreciationClassId, $intDepreciationClassId), $objOptionalClauses); } catch (QCallerException $objExc) { $objExc->IncrementOffset(); throw $objExc; } }