/**
* Gets all associated RoleEntityQtypeCustomFieldAuthorizations as an array of RoleEntityQtypeCustomFieldAuthorization objects
* @param QQClause[] $objOptionalClauses additional optional QQClause objects for this query
* @return RoleEntityQtypeCustomFieldAuthorization[]
*/
public function GetRoleEntityQtypeCustomFieldAuthorizationArray($objOptionalClauses = null)
{
if (is_null($this->intEntityQtypeCustomFieldId)) {
return array();
}
try {
return RoleEntityQtypeCustomFieldAuthorization::LoadArrayByEntityQtypeCustomFieldId($this->intEntityQtypeCustomFieldId, $objOptionalClauses);
} catch (QCallerException $objExc) {
$objExc->IncrementOffset();
throw $objExc;
}
}
/**
* Deletes all associated RoleEntityQtypeCustomFieldAuthorizations
* @return void
*/
public function DeleteAllRoleEntityQtypeCustomFieldAuthorizations()
{
if (is_null($this->intEntityQtypeCustomFieldId)) {
throw new QUndefinedPrimaryKeyException('Unable to call UnassociateRoleEntityQtypeCustomFieldAuthorization on this unsaved EntityQtypeCustomField.');
}
// Get the Database Object for this Class
$objDatabase = EntityQtypeCustomField::GetDatabase();
// Journaling
if ($objDatabase->JournalingDatabase) {
foreach (RoleEntityQtypeCustomFieldAuthorization::LoadArrayByEntityQtypeCustomFieldId($this->intEntityQtypeCustomFieldId) as $objRoleEntityQtypeCustomFieldAuthorization) {
$objRoleEntityQtypeCustomFieldAuthorization->Journal('DELETE');
}
}
// Perform the SQL Query
$objDatabase->NonQuery('
DELETE FROM
`role_entity_qtype_custom_field_authorization`
WHERE
`entity_qtype_custom_field_id` = ' . $objDatabase->SqlVariable($this->intEntityQtypeCustomFieldId) . '
');
}
protected function DeleteEntityQtypeCustomFields()
{
$objEntityQtypeCustomFieldArray = EntityQtypeCustomField::LoadArrayByCustomFieldId($this->objCustomField->CustomFieldId);
if ($objEntityQtypeCustomFieldArray) {
foreach ($objEntityQtypeCustomFieldArray as $objEntityQtypeCustomField) {
// If the EntityQtype needs to be deleted, you must delete EntityQtypeId for all roles in RoleEntityQTypeCustomFieldAuthorization
$objRoleEntityCustomAuthArray = RoleEntityQtypeCustomFieldAuthorization::LoadArrayByEntityQtypeCustomFieldId($objEntityQtypeCustomField->EntityQtypeCustomFieldId);
if ($objRoleEntityCustomAuthArray) {
foreach ($objRoleEntityCustomAuthArray as $objRoleEntityCustomAuth) {
$objRoleEntityCustomAuth->Delete();
}
}
// If there was Asset Type Custom field Delete AssetCustomField
if ($objEntityQtypeCustomField->EntityQtypeId == 1) {
$this->DeleteAssetCustomFieldAssetModels();
}
// If the helper table exists for that EntityQtype delete the columns in the helper table
if ($strHelperTableArray = CustomFieldValue::GetHelperTableByEntityQtypeId($objEntityQtypeCustomField->EntityQtypeId)) {
$strHelperTable = $strHelperTableArray[0];
$objDatabase = CustomField::GetDatabase();
$strQuery = sprintf("ALTER TABLE %s DROP `cfv_%s`;", $strHelperTable, $objEntityQtypeCustomField->CustomFieldId);
$objDatabase->NonQuery($strQuery);
}
// Delete the EntityQtypeCustomField last
$objEntityQtypeCustomField->Delete();
}
}
}
protected function DeleteEntityQtypeCustomFields()
{
$objEntityQtypeCustomFieldArray = EntityQtypeCustomField::LoadArrayByCustomFieldId($this->objCustomField->CustomFieldId);
if ($objEntityQtypeCustomFieldArray) {
foreach ($objEntityQtypeCustomFieldArray as $objEntityQtypeCustomField) {
// If the EntityQtype needs to be deleted, you must delete EntityQtypeId for all roles in RoleEntityQTypeCustomFieldAuthorization
$objRoleEntityCustomAuthArray = RoleEntityQtypeCustomFieldAuthorization::LoadArrayByEntityQtypeCustomFieldId($objEntityQtypeCustomField->EntityQtypeCustomFieldId);
if ($objRoleEntityCustomAuthArray) {
foreach ($objRoleEntityCustomAuthArray as $objRoleEntityCustomAuth) {
$objRoleEntityCustomAuth->Delete();
}
}
// Delete the EntityQtypeCustomField last
//$objEntityQtypeCustomField->Delete();
}
}
}
