public void initCustomerIssues() {
EOFetchSpecification fs;
NSDictionary bindings = null;
Session s = (Session) session();
NSMutableArray qual = new NSMutableArray();
NSMutableArray qual1 = new NSMutableArray();
EOQualifier qualifier;
// 'Open items'
// qual.addObject(EOQualifier.qualifierWithQualifierFormat("bugStatus !='CLOSED'", null));
// qual.addObject(EOQualifier.qualifierWithQualifierFormat("bugStatus !='RESOLVED'", null));
// qual.addObject(EOQualifier.qualifierWithQualifierFormat("bugStatus !='VERIFIED'", null));
// Taser
qual1.addObject(EOQualifier.qualifierWithQualifierFormat("type = 'Prospect'", null));
qual1.addObject(EOQualifier.qualifierWithQualifierFormat("type = 'Customer'", null));
qual.addObject(new EOOrQualifier(qual1));
// Single Customer
if (customerId() != null) {
qual.addObject(EOQualifier.qualifierWithQualifierFormat("bugId=" + customerId(), null));
showProductSelector = true;
} else {
// Products
if (selectedProducts.count() == 1) {
if (selectedProducts.contains("Trusted Access")) {
qual.addObject(
EOQualifier.qualifierWithQualifierFormat(
"product.productName = 'Device: Trusted Access'", null));
} else if (selectedProducts.contains("Secure Storage")) {
qual.addObject(
EOQualifier.qualifierWithQualifierFormat(
"product.productName = 'Device: Secure Storage'", null));
}
}
}
Object orderings[] = {
EOSortOrdering.sortOrderingWithKey("version", EOSortOrdering.CompareAscending),
EOSortOrdering.sortOrderingWithKey("targetMilestone", EOSortOrdering.CompareAscending),
EOSortOrdering.sortOrderingWithKey(
"priority", EOSortOrdering.CompareCaseInsensitiveAscending),
EOSortOrdering.sortOrderingWithKey(
"bugSeverity", EOSortOrdering.CompareCaseInsensitiveAscending),
};
fs = new EOFetchSpecification("Item", new EOAndQualifier(qual), new NSArray(orderings));
fs.setRefreshesRefetchedObjects(true);
((EODatabaseDataSource) customerIssueDisplayGroup.dataSource()).setFetchSpecification(fs);
customerIssueDisplayGroup.fetch();
}
public NSArray customerIssues() {
NSMutableArray allChildren = new NSMutableArray();
NSMutableArray qual = new NSMutableArray();
Item customer;
Item child;
if (customerIssues == null) {
if (bugId() != null) {
qual.addObject(EOQualifier.qualifierWithQualifierFormat("bugId=" + bugId(), null));
EOFetchSpecification spec =
new EOFetchSpecification("Item", new EOAndQualifier(qual), null);
// Perform actual fetch
customerIssues =
(NSArray) session().defaultEditingContext().objectsWithFetchSpecification(spec);
} else {
Enumeration enumer = ((NSArray) customerIssueDisplayGroup.allObjects()).objectEnumerator();
// For each Customer
while (enumer.hasMoreElements()) {
customer = (Item) enumer.nextElement();
NSArray children = (NSArray) customer.valueForKey("allChildren");
// Add all of their issues (if they haven't been added already
Enumeration enumer2 = children.objectEnumerator();
while (enumer2.hasMoreElements()) {
child = (Item) enumer2.nextElement();
if (!allChildren.contains(child)) {
allChildren.addObject(child);
}
}
}
Object orderings[] = {
EOSortOrdering.sortOrderingWithKey("version", EOSortOrdering.CompareAscending),
EOSortOrdering.sortOrderingWithKey("targetMilestone", EOSortOrdering.CompareAscending),
EOSortOrdering.sortOrderingWithKey(
"priority", EOSortOrdering.CompareCaseInsensitiveAscending),
EOSortOrdering.sortOrderingWithKey(
"bugSeverity", EOSortOrdering.CompareCaseInsensitiveAscending),
};
// Sort the issues
customerIssues =
EOSortOrdering.sortedArrayUsingKeyOrderArray(allChildren, new NSArray(orderings));
}
}
return customerIssues;
}
/**
* Overrides the parent implementation to provide a more efficient mechanism for generating
* primary keys, while generating the primary key support on the fly.
*
* @param count the batch size
* @param entity the entity requesting primary keys
* @param channel open JDBCChannel
* @return NSArray of NSDictionary where each dictionary corresponds to a unique primary key value
*/
public NSArray newPrimaryKeys(int count, EOEntity entity, JDBCChannel channel) {
if (isPrimaryKeyGenerationNotSupported(entity)) {
return null;
}
EOAttribute attribute = (EOAttribute) entity.primaryKeyAttributes().lastObject();
String attrName = attribute.name();
boolean isIntType = "i".equals(attribute.valueType());
NSMutableArray results = new NSMutableArray(count);
String sequenceName = sequenceNameForEntity(entity);
DB2Expression expression = new DB2Expression(entity);
boolean succeeded = false;
for (int tries = 0; !succeeded && tries < 2; tries++) {
while (results.count() < count) {
try {
StringBuffer sql = new StringBuffer();
sql.append("SELECT ");
sql.append("next value for " + sequenceName + " AS KEY");
sql.append(" from sysibm.sysdummy1");
expression.setStatement(sql.toString());
channel.evaluateExpression(expression);
try {
NSDictionary row;
while ((row = channel.fetchRow()) != null) {
Enumeration pksEnum = row.allValues().objectEnumerator();
while (pksEnum.hasMoreElements()) {
Number pkObj = (Number) pksEnum.nextElement();
Number pk;
if (isIntType) {
pk = Integer.valueOf(pkObj.intValue());
} else {
pk = Long.valueOf(pkObj.longValue());
}
results.addObject(new NSDictionary(pk, attrName));
}
}
} finally {
channel.cancelFetch();
}
succeeded = true;
} catch (JDBCAdaptorException ex) {
throw ex;
}
}
}
if (results.count() != count) {
throw new IllegalStateException(
"Unable to generate primary keys from the sequence for " + entity + ".");
}
return results;
}
public NSArray<edu.umich.marketplace.eof.Advert> adverts(
EOQualifier qualifier, NSArray<EOSortOrdering> sortOrderings, boolean fetch) {
NSArray<edu.umich.marketplace.eof.Advert> results;
if (fetch) {
EOQualifier fullQualifier;
EOQualifier inverseQualifier =
new EOKeyValueQualifier(
edu.umich.marketplace.eof.Advert.CATEGORY_KEY,
EOQualifier.QualifierOperatorEqual,
this);
if (qualifier == null) {
fullQualifier = inverseQualifier;
} else {
NSMutableArray qualifiers = new NSMutableArray();
qualifiers.addObject(qualifier);
qualifiers.addObject(inverseQualifier);
fullQualifier = new EOAndQualifier(qualifiers);
}
results =
edu.umich.marketplace.eof.Advert.fetchAdverts(
editingContext(), fullQualifier, sortOrderings);
} else {
results = adverts();
if (qualifier != null) {
results =
(NSArray<edu.umich.marketplace.eof.Advert>)
EOQualifier.filteredArrayWithQualifier(results, qualifier);
}
if (sortOrderings != null) {
results =
(NSArray<edu.umich.marketplace.eof.Advert>)
EOSortOrdering.sortedArrayUsingKeyOrderArray(results, sortOrderings);
}
}
return results;
}
public NSArray<er.sync.eo.ERSyncPrincipal> principals(
EOQualifier qualifier, NSArray<EOSortOrdering> sortOrderings, boolean fetch) {
NSArray<er.sync.eo.ERSyncPrincipal> results;
if (fetch) {
EOQualifier fullQualifier;
EOQualifier inverseQualifier =
new EOKeyValueQualifier(
er.sync.eo.ERSyncPrincipal.DEVICE_TYPE_KEY, EOQualifier.QualifierOperatorEqual, this);
if (qualifier == null) {
fullQualifier = inverseQualifier;
} else {
NSMutableArray qualifiers = new NSMutableArray();
qualifiers.addObject(qualifier);
qualifiers.addObject(inverseQualifier);
fullQualifier = new EOAndQualifier(qualifiers);
}
results =
er.sync.eo.ERSyncPrincipal.fetchERSyncPrincipals(
editingContext(), fullQualifier, sortOrderings);
} else {
results = principals();
if (qualifier != null) {
results =
(NSArray<er.sync.eo.ERSyncPrincipal>)
EOQualifier.filteredArrayWithQualifier(results, qualifier);
}
if (sortOrderings != null) {
results =
(NSArray<er.sync.eo.ERSyncPrincipal>)
EOSortOrdering.sortedArrayUsingKeyOrderArray(results, sortOrderings);
}
}
return results;
}
public NSArray itemsWithMultipleParents() {
if (itemsWithMultipleParents == null) {
NSMutableArray temp = new NSMutableArray();
Enumeration enumer = customerIssues().objectEnumerator();
while (enumer.hasMoreElements()) {
Item taserIssue = (Item) enumer.nextElement();
NSArray parents =
(NSArray) taserIssue.topMostParents(); // will get some non-taser parents.
if ((parents != null) && (parents.count() > 1)) {
temp.addObject(taserIssue);
}
}
itemsWithMultipleParents = new NSArray(temp);
}
return itemsWithMultipleParents;
}
public NSArray topMostTaserParents() {
Enumeration enumer = anItem.topMostParents().objectEnumerator();
NSMutableArray temp = new NSMutableArray();
// System.out.println("Item - " + anItem.valueForKey("bugId") + " - " + anItem.shortDesc());
while (enumer.hasMoreElements()) {
Item tempEo = (Item) enumer.nextElement();
// System.out.println("\t\tparentA - " + tempEo.bugId() + " - " + tempEo.shortDesc());
if ((tempEo.type().equals("Prospect")) || (tempEo.type().equals("Customer"))) {
temp.addObject(tempEo);
// System.out.println("\t\tparentB - " + tempEo.bugId() + " - " + tempEo.shortDesc());
}
}
return temp;
}
public NSArray personList() {
NSArray forcedList = (NSArray) valueForBinding("forcedList");
NSMutableArray result =
(forcedList == null)
? new NSMutableArray()
: EOUtilities.localInstancesOfObjects(ec, forcedList).mutableClone();
NSArray personList = (NSArray) session().valueForKey("personList");
if (personList != null && personList.count() > 0) {
Enumeration enu = personList.objectEnumerator();
while (enu.hasMoreElements()) {
EOEnterpriseObject pers = (EOEnterpriseObject) enu.nextElement();
if (!result.contains(pers)
&& (entity().equals(pers.entityName()) || pers.entityName().equals(alterEntity())))
result.addObject(pers);
}
}
return result;
}
public void invalidateObjects(NSArray pObjects) {
// System.out.println("ReleasePlan.invalidateObjects()");
// Invalidate Objects
if (pObjects != null) {
// System.out.println("ReleasePlan.invalidateObjects() - 2");
Enumeration enumer = pObjects.objectEnumerator();
NSMutableArray temp = new NSMutableArray();
while (enumer.hasMoreElements()) {
Item i = (Item) enumer.nextElement();
i.invalidateAllChildren();
EOGlobalID id = (EOGlobalID) (session().defaultEditingContext().globalIDForObject(i));
if (id != null) {
temp.addObject(id);
}
}
session().defaultEditingContext().invalidateObjectsWithGlobalIDs((NSArray) temp);
}
}