public function SetupAsset($objCaller = null) { // Lookup Object PK information from Query String (if applicable) // Set mode to Edit or New depending on what's found // Overridden from AssetEditFormBase to add the $objCaller parameter $intAssetId = QApplication::QueryString('intAssetId'); if ($intAssetId) { //$objCaller->objAsset = Asset::Load($intAssetId); // To minimize the count of queries $objClauses = array(); array_push($objClauses, QQ::Expand(QQN::Asset()->AssetModel)); array_push($objClauses, QQ::Expand(QQN::Asset()->AssetModel->Category)); array_push($objClauses, QQ::Expand(QQN::Asset()->AssetModel->Manufacturer)); array_push($objClauses, QQ::Expand(QQN::Asset()->ParentAsset)); array_push($objClauses, QQ::Expand(QQN::Asset()->Location)); array_push($objClauses, QQ::Expand(QQN::Asset()->CreatedByObject)); $objCaller->objAsset = Asset::QuerySingle(QQ::Equal(QQN::Asset()->AssetId, $intAssetId), $objClauses); if (!$objCaller->objAsset) { throw new Exception('Could not find a Asset object with PK arguments: ' . $intAssetId); } $objCaller->strTitleVerb = QApplication::Translate('Edit'); $objCaller->blnEditMode = true; $this->blnEditChild = true; } else { $objCaller->objAsset = new Asset(); $objCaller->strTitleVerb = QApplication::Translate('Create'); $objCaller->blnEditMode = false; } QApplication::AuthorizeEntity($objCaller->objAsset, $objCaller->blnEditMode); }
/** * Load a single Asset object, * by AssetCode Index(es) * @param string $strAssetCode * @return Asset */ public static function LoadByAssetCode($strAssetCode) { return Asset::QuerySingle(QQ::Equal(QQN::Asset()->AssetCode, $strAssetCode)); }
protected function dtgAudit_Bind() { if ($this->rblDiscrepancy->SelectedValue == 'discrepancies') { $objConditions = QQ::AndCondition(QQ::Equal(QQN::AuditScan()->AuditId, $_GET['intAuditId']), QQ::NotEqual(QQN::AuditScan()->Count, QQN::AuditScan()->SystemCount)); } else { $objConditions = QQ::Equal(QQN::AuditScan()->AuditId, $_GET['intAuditId']); } $objAuditScanArray = AuditScan::QueryArray($objConditions, QQ::Clause(QQ::Expand(QQN::AuditScan()->Location), $this->dtgAudit->OrderByClause)); if ($objAuditScanArray) { foreach ($objAuditScanArray as $objAuditScan) { $objAuditScan->Asset = Asset::QuerySingle(QQ::Equal(QQN::Asset()->AssetId, $objAuditScan->EntityId), QQ::Clause(QQ::Expand(QQN::Asset()->AssetModel))); } } if (count($objAuditScanArray) == 0) { $this->dtgAudit->ShowHeader = false; } else { $this->dtgAudit->ShowHeader = true; } $this->dtgAudit->DataSource = $objAuditScanArray; }
/** * Load a single Asset object, * by AssetCode Index(es) * @param string $strAssetCode * @return Asset */ public static function LoadByAssetCode($strAssetCode, $objOptionalClauses = null) { return Asset::QuerySingle(QQ::Equal(QQN::Asset()->AssetCode, $strAssetCode), $objOptionalClauses); }