protected function getParentRecordIds(dmProjectModule $module, dmProjectModule $parentModule) { /* * if parent is local relation for module, * we can prepare parent records */ if ($module->hasLocal($parentModule)) { $local = $module->getTable()->getRelationHolder()->getLocalByClass($parentModule->getModel())->getLocal(); $query = sprintf('SELECT r.id, r.%s FROM %s r WHERE EXISTS (SELECT page.id FROM dm_page page WHERE page.module = ? AND page.action = ? AND page.record_id = r.%s)', $local, $module->getTable()->getTableName(), $local); $_parentRecordIds = dmDb::pdo($query, array($parentModule->getKey(), 'show'))->fetchAll(PDO::FETCH_NUM); $parentRecordIds = array(); foreach ($_parentRecordIds as $_parentRecordId) { $parentRecordIds[$_parentRecordId[0]] = $_parentRecordId[1]; } } elseif ($module->hasAssociation($parentModule)) { $association = $module->getTable()->getRelationHolder()->getAssociationByClass($parentModule->getModel()); $query = sprintf('SELECT association.%s, association.%s FROM %s association WHERE EXISTS (SELECT page.id FROM dm_page page WHERE page.module = ? AND page.action = ? AND page.record_id = association.%s) GROUP BY association.%s', $association->getForeign(), $association->getLocal(), $association->getAssociationTable()->getTableName(), $association->getForeign(), $association->getLocal()); $_parentRecordIds = dmDb::pdo($query, array($parentModule->getKey(), 'show'))->fetchAll(PDO::FETCH_NUM); $parentRecordIds = array(); foreach ($_parentRecordIds as $value) { $parentRecordIds[$value[1]] = $value[0]; } } else { $parentRecordIds = false; } return $parentRecordIds; }