本文整理汇总了PHP中Asset::LoadArrayByParentAssetId方法的典型用法代码示例。如果您正苦于以下问题:PHP Asset::LoadArrayByParentAssetId方法的具体用法?PHP Asset::LoadArrayByParentAssetId怎么用?PHP Asset::LoadArrayByParentAssetId使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类Asset
的用法示例。
在下文中一共展示了Asset::LoadArrayByParentAssetId方法的5个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: RefreshChildAssets
public function RefreshChildAssets()
{
if ($this->objAsset->AssetId != null) {
$this->ctlAssetEdit->objChildAssetArray = Asset::LoadArrayByParentAssetId($this->objAsset->AssetId);
$this->ctlAssetEdit->objRemovedChildAssetArray = array();
// Hide the column with checkboxes
$this->dtgChildAssets->GetColumn(0)->Display = false;
$this->dtgChildAssets_Bind();
}
}
示例2: btnSave_Click
public function btnSave_Click($strFormId, $strControlId, $strParameter)
{
try {
// Get an instance of the database
$objDatabase = QApplication::$Database[1];
// Begin a MySQL Transaction to be either committed or rolled back
$objDatabase->TransactionBegin();
// Generate a new AssetCode based on the MinAssetCode value
// This happens whether or not they are creating a new one or editing an existing one
if ($this->chkAutoGenerateAssetCode->Checked) {
$this->txtAssetCode->Text = Asset::GenerateAssetCode();
}
$this->objAsset->AssetCode = $this->txtAssetCode->Text;
$this->objAsset->AssetModelId = $this->lstAssetModel->SelectedValue;
$blnError = false;
// If a new asset is being created
if (!$this->blnEditMode) {
// Do not allow creation of an asset if asset limit will be exceeded
$intAssetLimit = is_numeric(QApplication::$TracmorSettings->AssetLimit) ? QApplication::$TracmorSettings->AssetLimit : false;
if (!$this->blnEditMode) {
if ($intAssetLimit && Asset::CountActive() >= $intAssetLimit) {
$blnError = true;
$this->txtAssetCode->Warning = "Your asset limit has been reached.";
}
}
// Check to see if the asset code already exists
$AssetDuplicate = Asset::LoadByAssetCode($this->txtAssetCode->Text);
if ($AssetDuplicate) {
$blnError = true;
$this->txtAssetCode->Warning = "That asset code is already in use. Please try another.";
}
if (!$blnError && $this->txtParentAssetCode->Text) {
if ($this->txtParentAssetCode->Text != $this->objAsset->AssetCode) {
$objParentAsset = Asset::LoadByAssetCode($this->txtParentAssetCode->Text);
if (!$objParentAsset) {
$blnError = true;
$this->txtParentAssetCode->Warning = "That asset code does not exist. Please try another.";
} else {
if ($this->chkLockToParent->Checked && $objParentAsset->LocationId != $this->lstLocation->SelectedValue) {
// If locking child to parent, make sure assets are at the same location
$blnError = true;
$this->chkLockToParent->Warning = 'Cannot lock to parent asset at another location.';
} else {
if ($this->chkLockToParent->Checked && ($objParentAsset->CheckedOutFlag || $objParentAsset->ReservedFlag || $objParentAsset->ArchivedFlag || $objParentAsset->LocationId == 2 || $objParentAsset->LocationId == 5 || AssetTransaction::PendingTransaction($objParentAsset->AssetId))) {
$blnError = true;
$this->chkLockToParent->Warning = "Parent asset code (" . $objParentAsset->AssetCode . ") must not be currently Archived, Checked Out, Pending Shipment, Shipped/TBR, or Reserved.";
} else {
$this->objAsset->ParentAssetId = $objParentAsset->AssetId;
if ($this->chkLockToParent->Checked) {
$this->objAsset->LinkedFlag = 1;
}
}
}
}
} else {
$blnError = true;
$this->txtParentAssetCode->Warning = "Parent asset code must not be the same as asset code. Please try another.";
}
} else {
// If txtParentAssetCode is empty
$this->objAsset->LinkedFlag = false;
$this->objAsset->ParentAssetId = null;
}
if (!$blnError) {
// Location can only be decided when creating an asset. Otherwise they must conduct a transaction.
if (!$this->blnEditMode) {
$this->objAsset->LocationId = $this->lstLocation->SelectedValue;
}
// Save child assets
$this->SaveChildAssets();
// Object should be saved only if it is new, to obtain the proper AssetId to add to the custom field tables
$this->objAsset->Save();
$this->objParentObject->RefreshChildAssets();
}
}
// Assign input values to custom fields
if ($this->arrCustomFields && !$blnError) {
// Save the values from all of the custom field controls to save the asset
CustomField::SaveControls($this->objAsset->objCustomFieldArray, $this->blnEditMode, $this->arrCustomFields, $this->objAsset->AssetId, 1);
}
if ($this->blnEditMode) {
// Check to see if the asset code already exists (and is not the asset code of the asset that the user is currently editing
$AssetDuplicate = Asset::LoadByAssetCode($this->txtAssetCode->Text);
if ($AssetDuplicate && $AssetDuplicate->AssetId != $this->objAsset->AssetId) {
$blnError = true;
$this->txtAssetCode->Warning = "That asset code is already in use. Please try another.";
}
if (!$blnError && $this->txtParentAssetCode->Text) {
// Check if the parent asset code is already a child asset of this asset
$arrChildAsset = Asset::LoadArrayByParentAssetId($this->objAsset->AssetId);
foreach ($arrChildAsset as $objChildAsset) {
if ($objChildAsset->AssetCode == $this->txtParentAssetCode->Text) {
$blnError = true;
$this->txtParentAssetCode->Warning = "Parent asset code is already a child of this asset. Please try another.";
break;
}
}
if (!$blnError) {
if ($this->txtParentAssetCode->Text != $this->objAsset->AssetCode) {
$objParentAsset = Asset::LoadByAssetCode($this->txtParentAssetCode->Text);
//.........这里部分代码省略.........
示例3: btnApply_Click
public function btnApply_Click($strFormId, $strControlId, $strParameter)
{
$this->EnableSelectedControls();
$this->ClearWarnings();
$blnError = false;
// Make sure at least one checkbox is checked
if (!$this->chkModel->Checked && !$this->chkParentAssetCode->Checked && !$this->chkChkLockToParent->Checked) {
$blnChecked = false;
foreach ($this->arrCheckboxes as $objCheckBox) {
if ($objCheckBox->Checked) {
$blnChecked = true;
break;
}
}
if (!$blnChecked) {
$blnError = true;
$this->btnCancel->Warning = 'You must select at least one field to edit.';
return;
}
}
// If Model is checked, make sure a model is selected
if ($this->chkModel->Checked && $this->lstModel->SelectedValue == null) {
$blnError = true;
$this->lstModel->Warning = 'You must select a Model.';
return;
}
// Get an instance of the database
$objDatabase = QApplication::$Database[1];
// Begin a MySQL Transaction to be either committed or rolled back
$objDatabase->TransactionBegin();
$set = array(sprintf('`modified_by`= %s', QApplication::$objUserAccount->UserAccountId));
if (count($this->arrCustomFields) > 0) {
$customFieldIdArray = array();
foreach ($this->arrCustomFields as $field) {
if ($this->arrCheckboxes[$field['input']->strControlId]->Checked) {
if ($field['input'] instanceof QTextBox && $field['input']->Required && $field['input']->Text == null || $field['input'] instanceof QListBox && $field['input']->Required && $field['input']->SelectedValue == null) {
$blnError = true;
$field['input']->Warning = "Required.";
} else {
$this->arrCustomFieldsToEdit[] = $field;
$customFieldIdArray[] = (int) str_replace('cf', '', $field['input']->strControlId);
}
}
}
}
foreach ($this->arrAssetToEdit as $intAssetToEditId) {
$objAsset = Asset::Load($intAssetToEditId);
// First check that the user is authorized to edit this asset
if (!QApplication::AuthorizeEntityBoolean($objAsset, 2)) {
$blnError = true;
$this->btnCancel->Warning = 'You are not authorized to edit one or more of the selected assets.';
break;
}
if ($this->chkParentAssetCode->Checked && $this->txtParentAssetCode->Text) {
// Check if the parent asset tag is already a child asset of this asset
$arrChildAsset = Asset::LoadArrayByParentAssetId($intAssetToEditId);
foreach ($arrChildAsset as $objChildAsset) {
if ($objChildAsset->AssetCode == $this->txtParentAssetCode->Text) {
$blnError = true;
$this->txtParentAssetCode->Warning = "Parent asset tag is already a child of this asset.";
break 2;
}
}
if ($this->txtParentAssetCode->Text != $objAsset->AssetCode) {
$objParentAsset = Asset::LoadByAssetCode($this->txtParentAssetCode->Text);
if (!$objParentAsset) {
$blnError = true;
$this->txtParentAssetCode->Warning = "That asset tag does not exist.";
break;
} else {
if ($this->chkLockToParent->Checked && !($objAsset->ParentAssetId == $objParentAsset->AssetId && $objAsset->LinkedFlag == 1) && $objParentAsset->LocationId != $objAsset->LocationId) {
// If locking child to parent, make sure assets are at the same location
$blnError = true;
$this->chkLockToParent->Warning = 'Cannot lock to parent asset at another location.';
break;
} else {
if ($this->chkLockToParent->Checked && !($objAsset->ParentAssetId == $objParentAsset->AssetId && $objAsset->LinkedFlag == 1) && ($objParentAsset->CheckedOutFlag || $objParentAsset->ReservedFlag || $objParentAsset->ArchivedFlag || $objParentAsset->LocationId == 2 || $objParentAsset->LocationId == 5 || AssetTransaction::PendingTransaction($objParentAsset->AssetId))) {
$blnError = true;
$this->chkLockToParent->Warning = "Parent asset tag (" . $objParentAsset->AssetCode . ") must not be currently Archived, Checked Out, Pending Shipment, Shipped/TBR, or Reserved.";
break;
} else {
if ($this->chkLockToParent->Checked && !($objAsset->ParentAssetId == $objParentAsset->AssetId && $objAsset->LinkedFlag == 1) && ($objAsset->CheckedOutFlag || $objAsset->ReservedFlag || $objAsset->ArchivedFlag || $objAsset->LocationId == 2 || $objAsset->LocationId == 5 || AssetTransaction::PendingTransaction($objAsset->AssetId))) {
$blnError = true;
$this->chkLockToParent->Warning .= "Child asset must not be currently Archived, Checked Out, Pending Shipment, Shipped/TBR, or Reserved.";
break;
} else {
$objAsset->ParentAssetId = $objParentAsset->AssetId;
if ($this->chkLockToParent->Checked) {
$objAsset->LinkedFlag = 1;
} else {
$objAsset->LinkedFlag = 0;
}
}
}
}
}
} else {
$blnError = true;
$this->txtParentAssetCode->Warning = "Asset cannot be assigned as its own parent.";
break;
//.........这里部分代码省略.........
示例4: btnSave_Click
//.........这里部分代码省略.........
$this->txtParentAssetCode->Warning = "Parent asset tag must not be the same as asset tag. Please try another.";
}
} else {
// If txtParentAssetCode is empty
$this->objAsset->LinkedFlag = false;
$this->objAsset->ParentAssetId = null;
}
if (!$blnError) {
// Location can only be decided when creating an asset. Otherwise they must conduct a transaction.
if (!$this->blnEditMode) {
$this->objAsset->LocationId = $this->lstLocation->SelectedValue;
}
// Save child assets
$this->SaveChildAssets();
// Object should be saved only if it is new, to obtain the proper AssetId to add to the custom field tables
$this->objAsset->Save();
$this->objParentObject->RefreshChildAssets();
}
}
// Assign input values to custom fields
if (is_array($this->arrCustomFields) && count($this->arrCustomFields) > 0 && !$blnError) {
// Save the values from all of the custom field controls to save the asset
CustomField::SaveControls($this->objAsset->objCustomFieldArray, $this->blnEditMode, $this->arrCustomFields, $this->objAsset->AssetId, 1);
}
if ($this->blnEditMode) {
// Check to see if the asset tag already exists (and is not the asset tag of the asset that the user is currently editing
$AssetDuplicate = Asset::LoadByAssetCode($this->txtAssetCode->Text);
if ($AssetDuplicate && $AssetDuplicate->AssetId != $this->objAsset->AssetId) {
$blnError = true;
$this->txtAssetCode->Warning = "That asset tag is already in use. Please try another.";
}
if (!$blnError && $this->txtParentAssetCode->Text) {
// Check if the parent asset tag is already a child asset of this asset
$arrChildAsset = Asset::LoadArrayByParentAssetId($this->objAsset->AssetId);
foreach ($arrChildAsset as $objChildAsset) {
if ($objChildAsset->AssetCode == $this->txtParentAssetCode->Text) {
$blnError = true;
$this->txtParentAssetCode->Warning = "Parent asset tag is already a child of this asset. Please try another.";
break;
}
}
if (!$blnError) {
if ($this->txtParentAssetCode->Text != $this->objAsset->AssetCode) {
$objParentAsset = Asset::LoadByAssetCode($this->txtParentAssetCode->Text);
if (!$objParentAsset) {
$blnError = true;
$this->txtParentAssetCode->Warning = "That asset tag does not exist. Please try another.";
} else {
if ($this->chkLockToParent->Checked && !($this->objAsset->ParentAssetId == $objParentAsset->AssetId && $this->objAsset->LinkedFlag == 1) && $objParentAsset->LocationId != $this->objAsset->LocationId) {
// If locking child to parent, make sure assets are at the same location
$blnError = true;
$this->chkLockToParent->Warning = 'Cannot lock to parent asset at another location.';
} else {
if ($this->chkLockToParent->Checked && !($this->objAsset->ParentAssetId == $objParentAsset->AssetId && $this->objAsset->LinkedFlag == 1) && ($objParentAsset->CheckedOutFlag || $objParentAsset->ReservedFlag || $objParentAsset->ArchivedFlag || $objParentAsset->LocationId == 2 || $objParentAsset->LocationId == 5 || AssetTransaction::PendingTransaction($objParentAsset->AssetId))) {
$blnError = true;
$this->chkLockToParent->Warning = "Parent asset tag (" . $objParentAsset->AssetCode . ") must not be currently Archived, Checked Out, Pending Shipment, Shipped/TBR, or Reserved.";
} else {
if ($this->chkLockToParent->Checked && !($this->objAsset->ParentAssetId == $objParentAsset->AssetId && $this->objAsset->LinkedFlag == 1) && ($this->objAsset->CheckedOutFlag || $this->objAsset->ReservedFlag || $this->objAsset->ArchivedFlag || $this->objAsset->LocationId == 2 || $this->objAsset->LocationId == 5 || AssetTransaction::PendingTransaction($this->objAsset->AssetId))) {
$blnError = true;
$this->chkLockToParent->Warning .= "Child asset must not be currently Archived, Checked Out, Pending Shipment, Shipped/TBR, or Reserved.";
} else {
$this->objAsset->ParentAssetId = $objParentAsset->AssetId;
if ($this->chkLockToParent->Checked) {
$this->objAsset->LinkedFlag = 1;
} else {
$this->objAsset->LinkedFlag = 0;
示例5: DeleteAllChildAssets
/**
* Deletes all associated ChildAssets
* @return void
*/
public function DeleteAllChildAssets()
{
if (is_null($this->intAssetId)) {
throw new QUndefinedPrimaryKeyException('Unable to call UnassociateChildAsset on this unsaved Asset.');
}
// Get the Database Object for this Class
$objDatabase = Asset::GetDatabase();
// Journaling
if ($objDatabase->JournalingDatabase) {
foreach (Asset::LoadArrayByParentAssetId($this->intAssetId) as $objAsset) {
$objAsset->Journal('DELETE');
}
}
// Perform the SQL Query
$objDatabase->NonQuery('
DELETE FROM
`asset`
WHERE
`parent_asset_id` = ' . $objDatabase->SqlVariable($this->intAssetId) . '
');
}