public void loadStudents(List<Enrollment> enrs) {
lstStudents.removeAllItems();
for (Enrollment enr : enrs) {
lstStudents.addItem(enr);
StringBuffer caption = new StringBuffer();
PhysicalPerson person = enr.getAdmissionAct().getStudent().getPhysicalPerson();
if (person.getIdentificationNumber() != null) {
caption.append(person.getIdentificationNumber() + "-");
} else {
caption.append("-- ");
}
if (person.getLastName() != null) {
caption.append(person.getLastName() + ", ");
} else {
caption.append("--");
}
if (person.getName() != null) {
caption.append(person.getName());
} else {
caption.append("--");
}
lstStudents.setItemCaption(enr, caption.toString());
}
}
private void populatePaymentCategories() {
try {
List<CategoryType> svcCategories = accSvc.getCategoriesForSheet(balSheet);
categories = new LinkedHashMap<>(svcCategories.size());
paymentCategories.removeAllItems();
if (typeFrm != null) ((Select) typeFrm.getField(ADD_TYPE_FLD_CAT)).removeAllItems();
for (CategoryType cat : svcCategories) {
categories.put(cat.getName(), cat);
paymentCategories.addItem(cat.getName());
if (typeFrm != null) ((Select) typeFrm.getField(ADD_TYPE_FLD_CAT)).addItem(cat.getName());
}
Set<String> keys = categories.keySet();
if (keys.size() > 0) paymentCategories.select(keys.iterator().next());
} catch (AccountsSheetException e) {
close();
Messenger.genericMessage(
MessageSeverity.ERROR,
STRINGS.getString(AccountsMessages.MSGR_UNRECOVERABLE_ERROR),
"Failed trying to query Payment Categories for Balance Sheet",
e);
}
}
public void loadStudentsSelecteds(List<Enrollment> enrsSel) {
lstStudentSelecteds.removeAllItems();
for (Enrollment enr : enrsSel) {
lstStudentSelecteds.addItem(enr);
}
removeItemLeftIfExistRight();
}
private void populatePaymentTypes(CategoryType selectedCategory) {
try {
List<PaymentType> svcTypes = accSvc.getTypesForCategory(selectedCategory);
types = new LinkedHashMap<>();
paymentTypes.removeAllItems();
for (PaymentType type : svcTypes) {
types.put(type.getName(), type);
paymentTypes.addItem(type.getName());
}
} catch (AccountsSheetException e) {
close();
Messenger.genericMessage(
MessageSeverity.ERROR,
STRINGS.getString(AccountsMessages.MSGR_UNRECOVERABLE_ERROR),
"Failed trying to query Payment Types for Balance Sheet",
e);
}
}
private Panel designMainPanel() {
// positioning indices
final int leftStart = 450, topStart = 10, space = 100;
// create the panel that will hold all components
Panel pnlURIsProperties = new Panel("URI Display");
pnlURIsProperties.setWidth("100%");
pnlURIsProperties.setHeight("100%");
// Create absolute layout specifying its properties
final AbsoluteLayout layout = new AbsoluteLayout();
layout.setWidth("100%");
layout.setHeight("100%");
layout.setSizeFull();
// Create components Objects and specify their properties
Button btnCorrect = new Button("Correct");
Button btnIncorrect = new Button("Incorrect");
Button btnUnsure = new Button("Unsure");
Button btnGetProperties = new Button("Get properties");
final NativeSelect cmbSourceEndpoint = new NativeSelect("Source Endpoint");
final NativeSelect cmbDestinationEndpoint = new NativeSelect("Destination Endpoint");
final ListSelect lstSuggestedProperties = new ListSelect("Lookup Properties");
// to load properties of loaded resources automatically
final CheckBox chkAutomaticPropertiesLoad =
new CheckBox("Automatic Properties loading (next time)");
chkAutomaticPropertiesLoad.setValue(false);
cmbSourceEndpoint.setNullSelectionAllowed(false);
cmbDestinationEndpoint.setNullSelectionAllowed(false);
lstSuggestedProperties.setRows(4);
lstSuggestedProperties.setNullSelectionAllowed(false);
source = new Label("Source URI");
destination = new Label("Destination URI");
final Table tblSourcePropertiesMapping = new Table("Source Properties");
final Table tblDestinationPropertiesMapping = new Table("Destination Properties");
tblSourcePropertiesParam = tblSourcePropertiesMapping;
tblDestinationPropertiesParam = tblDestinationPropertiesMapping;
tblSourcePropertiesMapping.setWidth("50%");
tblDestinationPropertiesMapping.setWidth("100%");
tblSourcePropertiesMapping.setSelectable(true);
tblDestinationPropertiesMapping.setSelectable(true);
/* Define the names and data types of columns.
* The "default value" parameter is meaningless here. */
tblSourcePropertiesMapping.addContainerProperty("Property", String.class, null);
tblSourcePropertiesMapping.addContainerProperty("Value", String.class, null);
tblDestinationPropertiesMapping.addContainerProperty("Property", String.class, null);
tblDestinationPropertiesMapping.addContainerProperty("Value", String.class, null);
tblDestinationPropertiesMapping.setMultiSelect(true);
/// get data for comboboxes
SQLContainer cmbContainer = connectToDB("root", "mofo", "Endpoints");
// fill endpoints
cmbSourceEndpoint.setContainerDataSource(cmbContainer);
cmbDestinationEndpoint.setContainerDataSource(cmbContainer);
cmbSourceEndpoint.setValue(cmbSourceEndpoint.getItemIds().iterator().next());
cmbDestinationEndpoint.setValue(cmbDestinationEndpoint.getItemIds().iterator().next());
SQLContainer lstContainer = getSuggestedProperties("root", "mofo");
int lstSize = lstContainer.size();
int i = 0;
for (Object cityItemId : lstContainer.getItemIds()) {
lstSuggestedProperties.addItem(i);
String g = lstContainer.getItem(cityItemId).getItemProperty("property").getValue().toString();
lstSuggestedProperties.setItemCaption(i, g);
i++;
}
lstSuggestedProperties.setValue(lstSuggestedProperties.getItemIds().iterator().next());
btnCorrect.addClickListener(
new Button.ClickListener() {
@Override
public void buttonClick(ClickEvent event) {
try {
Object rowId = tblSourceDestinationparam.getValue();
Item myitem = tblSourceDestinationparam.getItem(tblSourceDestinationparam.getValue());
lEndTime = System.currentTimeMillis();
long lEllapsedTime = lEndTime - lStartTime;
tblSourceDestinationparam.setEditable(true);
tblSourceDestinationparam.getContainerProperty(rowId, "decision").setValue("Correct");
tblSourceDestinationparam
.getContainerProperty(rowId, "time")
.setValue(String.valueOf(lEllapsedTime));
tblSourceDestinationparam.setEditable(false);
SQLContainer c = (SQLContainer) tblSourceDestinationparam.getContainerDataSource();
try {
c.commit();
} catch (UnsupportedOperationException | SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
int maxindex = tblSourceDestination.size();
SQLContainer s = (SQLContainer) tblSourceDestination.getContainerDataSource();
// Item x=s.getItem(tblSourceDestination.getValue());
if (!(tblSourceDestination.getValue().equals(tblSourceDestination.lastItemId()))) {
int index = s.indexOfId(tblSourceDestination.getValue());
index++;
tblSourceDestination.setValue(s.getIdByIndex(index));
try {
Object rowId2 = tblSourceDestination.getValue();
Property sourceProperty =
tblSourceDestination.getContainerProperty(rowId2, "sourceURI");
Property destinationProperty =
tblSourceDestination.getContainerProperty(rowId2, "destinationURI");
source.setValue(sourceProperty.toString());
destination.setValue(destinationProperty.toString());
tblSourcePropertiesParam.removeAllItems();
tblDestinationPropertiesParam.removeAllItems();
Notification loadURI = new Notification("");
loadURI.show("Links' URIs are successfully loaded ");
if (chkAutomaticPropertiesLoad.getValue()) // the automatic buton i schecked
{
// load the properties automatically
String sourceEndpoint = "", destinationEndpoint = "";
sourceEndpoint = cmbSourceEndpoint.getItemCaption(cmbSourceEndpoint.getValue());
destinationEndpoint =
cmbDestinationEndpoint.getItemCaption(cmbDestinationEndpoint.getValue());
try {
String sparqlQuery = source.getValue();
getURIProperties(sparqlQuery, sourceEndpoint, tblSourcePropertiesMapping);
sparqlQuery = destination.getValue();
getURIProperties(
sparqlQuery, destinationEndpoint, tblDestinationPropertiesMapping);
} catch (Exception e) {
Notification.show("ERROR");
}
lStartTime = System.currentTimeMillis();
// start time for next one
}
} catch (Exception e) {
Notification error = new Notification("Error");
error.show("You did not select an item in the links table");
}
}
} catch (Exception e) {
Notification.show(e.getMessage());
}
///////////////////////////////////
}
});
btnIncorrect.addClickListener(
new Button.ClickListener() {
@Override
public void buttonClick(ClickEvent event) {
try {
Object rowId = tblSourceDestinationparam.getValue();
Item myitem = tblSourceDestinationparam.getItem(tblSourceDestinationparam.getValue());
lEndTime = System.currentTimeMillis();
long lEllapsedTime = lEndTime - lStartTime;
tblSourceDestinationparam.setEditable(true);
tblSourceDestinationparam
.getContainerProperty(rowId, "decision")
.setValue("Incorrect");
tblSourceDestinationparam
.getContainerProperty(rowId, "time")
.setValue(String.valueOf(lEllapsedTime));
tblSourceDestinationparam.setEditable(false);
SQLContainer c = (SQLContainer) tblSourceDestinationparam.getContainerDataSource();
try {
c.commit();
} catch (UnsupportedOperationException | SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
int maxindex = tblSourceDestination.size();
SQLContainer s = (SQLContainer) tblSourceDestination.getContainerDataSource();
// Item x=s.getItem(tblSourceDestination.getValue());
if (!(tblSourceDestination.getValue().equals(tblSourceDestination.lastItemId()))) {
int index = s.indexOfId(tblSourceDestination.getValue());
index++;
tblSourceDestination.setValue(s.getIdByIndex(index));
try {
Object rowId2 = tblSourceDestination.getValue();
Property sourceProperty =
tblSourceDestination.getContainerProperty(rowId2, "sourceURI");
Property destinationProperty =
tblSourceDestination.getContainerProperty(rowId2, "destinationURI");
source.setValue(sourceProperty.toString());
destination.setValue(destinationProperty.toString());
tblSourcePropertiesParam.removeAllItems();
tblDestinationPropertiesParam.removeAllItems();
Notification loadURI = new Notification("");
loadURI.show("Links' URIs are successfully loaded ");
if (chkAutomaticPropertiesLoad.getValue()) // the automatic buton i schecked
{
// load the properties automatically
String sourceEndpoint = "", destinationEndpoint = "";
sourceEndpoint = cmbSourceEndpoint.getItemCaption(cmbSourceEndpoint.getValue());
destinationEndpoint =
cmbDestinationEndpoint.getItemCaption(cmbDestinationEndpoint.getValue());
try {
String sparqlQuery = source.getValue();
getURIProperties(sparqlQuery, sourceEndpoint, tblSourcePropertiesMapping);
sparqlQuery = destination.getValue();
getURIProperties(
sparqlQuery, destinationEndpoint, tblDestinationPropertiesMapping);
} catch (Exception e) {
Notification.show("ERROR Not Properties queried");
}
lStartTime = System.currentTimeMillis();
// start time for next one
}
} catch (Exception e) {
Notification error = new Notification("Error");
error.show("You did not select an item in the links table");
}
}
} catch (Exception e) {
Notification.show(e.getMessage());
}
///////////////////////////////////
}
});
btnUnsure.addClickListener(
new Button.ClickListener() {
@Override
public void buttonClick(ClickEvent event) {
try {
Object rowId = tblSourceDestinationparam.getValue();
Item myitem = tblSourceDestinationparam.getItem(tblSourceDestinationparam.getValue());
lEndTime = System.currentTimeMillis();
float lEllapsedTime = lEndTime - lStartTime;
String elapsedTime = String.valueOf(lEllapsedTime);
tblSourceDestinationparam.setEditable(true);
tblSourceDestinationparam.getContainerProperty(rowId, "decision").setValue("Unsure");
tblSourceDestinationparam.getContainerProperty(rowId, "time").setValue(elapsedTime);
tblSourceDestinationparam.setEditable(false);
SQLContainer c = (SQLContainer) tblSourceDestinationparam.getContainerDataSource();
try {
c.commit();
} catch (UnsupportedOperationException | SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
// int selectedId=Integer.parseInt(tblSourceDestination.getValue().toString());
int maxindex = tblSourceDestination.size();
SQLContainer s = (SQLContainer) tblSourceDestination.getContainerDataSource();
// Item x=s.getItem(tblSourceDestination.getValue());
if (!(tblSourceDestination.getValue().equals(tblSourceDestination.lastItemId()))) {
int index = s.indexOfId(tblSourceDestination.getValue());
index++;
tblSourceDestination.setValue(s.getIdByIndex(index));
try {
Object rowId2 = tblSourceDestination.getValue();
Property sourceProperty =
tblSourceDestination.getContainerProperty(rowId2, "sourceURI");
Property destinationProperty =
tblSourceDestination.getContainerProperty(rowId2, "destinationURI");
source.setValue(sourceProperty.toString());
destination.setValue(destinationProperty.toString());
tblSourcePropertiesParam.removeAllItems();
tblDestinationPropertiesParam.removeAllItems();
Notification loadURI = new Notification("");
loadURI.show("Links' URIs are successfully loaded ");
if (chkAutomaticPropertiesLoad.getValue()) // the automatic buton i schecked
{
// load the properties automatically
String sourceEndpoint = "", destinationEndpoint = "";
sourceEndpoint = cmbSourceEndpoint.getItemCaption(cmbSourceEndpoint.getValue());
destinationEndpoint =
cmbDestinationEndpoint.getItemCaption(cmbDestinationEndpoint.getValue());
try {
String sparqlQuery = source.getValue();
getURIProperties(sparqlQuery, sourceEndpoint, tblSourcePropertiesMapping);
sparqlQuery = destination.getValue();
getURIProperties(
sparqlQuery, destinationEndpoint, tblDestinationPropertiesMapping);
} catch (Exception e) {
Notification.show("ERROR Not Properties queried");
}
lStartTime = System.currentTimeMillis();
// start time for next one
}
} catch (Exception e) {
Notification error = new Notification("Error");
error.show("You did not select an item in the links table");
}
}
} catch (Exception e) {
Notification.show(e.getMessage());
}
}
});
btnGetProperties.addClickListener(
new Button.ClickListener() {
@Override
public void buttonClick(ClickEvent event) {
String sourceEndpoint = "", destinationEndpoint = "";
sourceEndpoint = cmbSourceEndpoint.getItemCaption(cmbSourceEndpoint.getValue());
destinationEndpoint =
cmbDestinationEndpoint.getItemCaption(cmbDestinationEndpoint.getValue());
lStartTime = System.currentTimeMillis();
try {
String sparqlQuery = source.getValue();
getURIProperties(sparqlQuery, sourceEndpoint, tblSourcePropertiesMapping);
sparqlQuery = destination.getValue();
getURIProperties(sparqlQuery, destinationEndpoint, tblDestinationPropertiesMapping);
} catch (Exception e) {
Notification.show(
"ERROR while sparqling the endpoint for resources' properties (Are they selected/loaded ?)");
}
// cachingForTriples(tblSourceDestination, sourceEndpoint);
}
});
lstSuggestedProperties.addValueChangeListener(
new ValueChangeListener() {
@Override
public void valueChange(final ValueChangeEvent event) {
final String valueString = String.valueOf(event.getProperty().getValue());
// Notification.show(valueString);
List<Object> Ids = new ArrayList<Object>();
Object first = null;
for (Iterator i = tblSourcePropertiesMapping.getItemIds().iterator(); i.hasNext(); ) {
// Get the current item identifier, which is an integer.
first = i.next();
int iid = (Integer) first;
String other =
tblSourcePropertiesMapping.getItem(iid).getItemProperty("Property").toString();
// Notification.show(other);
if (other.equals(valueString)) // if(other.equals(property))
{
Ids.add(iid);
break;
}
}
tblSourcePropertiesMapping.setImmediate(true);
tblSourcePropertiesMapping.setValue(Ids);
tblDestinationPropertiesMapping.setCurrentPageFirstItemId(first);
}
});
tblSourcePropertiesMapping.addItemClickListener(
new ItemClickEvent.ItemClickListener() {
@Override
public void itemClick(ItemClickEvent event) {
String property =
tblSourcePropertiesMapping
.getContainerProperty(event.getItemId(), event.getPropertyId())
.toString();
List<String> res = getRelatedProperties(property);
if (res == null) {
Notification.show("No related Properties");
return;
}
boolean Found = false;
List<Object> Ids = new ArrayList<Object>();
Object first = null;
int x = 0;
for (String relatedProperty : res) {
for (Iterator i = tblDestinationPropertiesMapping.getItemIds().iterator();
i.hasNext(); ) {
// Get the current item identifier, which is an integer.
Object theId = i.next();
int iid = (Integer) theId;
String other =
tblDestinationPropertiesMapping
.getItem(iid)
.getItemProperty(event.getPropertyId())
.toString();
if (other.equals(relatedProperty)) // if(other.equals(property))
{
Ids.add(iid);
if (x == 0) {
first = theId;
x = 1;
}
Found = true;
}
}
}
if (!Found)
Notification.show(
"Related property is not Found in destination table try manual search");
else {
Notification.show("Found in destination table");
tblDestinationPropertiesMapping.setValue(Ids);
tblDestinationPropertiesMapping.setCurrentPageFirstItemId(first);
}
}
});
// add component to the layout specifying its position on the layout
layout.addComponent(btnCorrect, "left: " + leftStart + "px; top: " + (topStart + 450) + "px;");
layout.addComponent(
btnIncorrect, "left: " + (leftStart + space) + "px; top: " + (topStart + 450) + "px;");
layout.addComponent(
btnUnsure, "left: " + (leftStart + 2 * space) + "px; top: " + (topStart + 450) + "px;");
layout.addComponent(
btnGetProperties,
"left: " + (leftStart + 3 * space + 50) + "px; top: " + (topStart + 450) + "px;");
layout.addComponent(
chkAutomaticPropertiesLoad,
"left: " + (leftStart + 3 * space + 250) + "px; top: " + (topStart + 450) + "px;");
/*layout.addComponent(sourceURI,"left: "+(leftStart-space/2)+"px; top: "+(topStart+space/2)+"px;");
layout.addComponent(destinationURI,"left: "+(leftStart+2*space)+"px; top: "+(topStart+space/2)+"px;");*/
layout.addComponent(source, "left: 30px; top: " + (topStart + space / 2) + "px;");
layout.addComponent(
destination,
"left: " + (leftStart + 3 * space + 200) + "px; top: " + (topStart + space / 2) + "px;");
layout.addComponent(cmbSourceEndpoint, "left: 50px; top: " + (topStart + 20) + "px;");
layout.addComponent(
cmbDestinationEndpoint,
"left: " + (leftStart + 3 * space + 200) + "px; top: " + (topStart + 20) + "px;");
layout.addComponent(
lstSuggestedProperties,
"left: " + (leftStart + 100) + "px; top: " + (topStart + 20) + "px;");
layout.addComponent(
tblSourcePropertiesMapping, "left: 10px; top: " + (topStart + space) + "px;");
layout.addComponent(
tblDestinationPropertiesMapping,
"left: " + (leftStart + 3 * space + 200) + "px; top: " + (topStart + space) + "px;");
pnlURIsProperties.setContent(layout);
return pnlURIsProperties;
}
/**
* Add an item to listselect Framework.
*
* @param annotation
*/
public void addItemToListSelectFramework(BoaAnnotation annotation) {
listSelectGoldstandard.addItem(annotation);
}
/**
* Add an item to listselect Annotation.
*
* @param annotation
*/
public void addItemToListSelectAnnotation(BoaAnnotation annotation) {
listSelectAnnotation.addItem(annotation);
}