@Override
protected void resetFields() {
logger.info(
"Company ID : "
+ companyid
+ " | User Name : "
+ username
+ " > "
+ "Resetting the UI controls");
tfEnqNo.setReadOnly(false);
tfEnqNo.setValue("");
cbEnqStatus.setValue(null);
listEnqDtls = new ArrayList<SmsPurEnqDtlDM>();
tblSmsEnqDtl.removeAllItems();
cbBranch.setValue(branchId);
cbBranch.setComponentError(null);
lsVendorName.setValue(null);
lsVendorName.setComponentError(null);
dfDueDate.setValue(null);
dfEnqDate.setValue(null);
taEnqRem.setValue("");
taEnqDtlRem.setValue("");
dfEnqDate.setValue(new Date());
cbEnqStatus.setValue(cbEnqStatus.getItemIds().iterator().next());
cbUom.setReadOnly(true);
dfDueDate.setValue(addDays(new Date(), 7));
}
private void enqDtlresetFields() {
logger.info(
"Company ID : "
+ companyid
+ " | User Name : "
+ username
+ " > "
+ "Resetting the UI controls");
lsProduct.setValue(null);
tfEnqQty.setValue("0");
taEnqDtlRem.setValue("");
cbUom.setReadOnly(false);
cbUom.setValue("");
cbUom.setReadOnly(true);
cbEnqDtlStatus.setValue(cbEnqDtlStatus.getItemIds().iterator().next());
cbUom.setComponentError(null);
btnaddSpec.setCaption("Add");
tfEnqQty.setComponentError(null);
}
private void editSmsPurDetail() {
logger.info(
"Company ID : "
+ companyid
+ " | User Name : "
+ username
+ " > "
+ "Editing the selected record");
hlUserInputLayout.setVisible(true);
if (tblSmsEnqDtl.getValue() != null) {
SmsPurEnqDtlDM purEnqDtlDM = beanPurEnqDtlDM.getItem(tblSmsEnqDtl.getValue()).getBean();
lsProduct.setValue(null);
Long prodid = purEnqDtlDM.getProductId();
Collection<?> prodids = lsProduct.getItemIds();
for (Iterator<?> iterator = prodids.iterator(); iterator.hasNext(); ) {
Object itemId = (Object) iterator.next();
BeanItem<?> item = (BeanItem<?>) lsProduct.getItem(itemId);
// Get the actual bean and use the data
ProductDM st = (ProductDM) item.getBean();
if (prodid != null && prodid.equals(st.getProdid())) {
lsProduct.select(itemId);
}
}
if (cbUom.getValue() != null) {
cbUom.setReadOnly(false);
cbUom.setValue(purEnqDtlDM.getProductUom());
cbUom.setReadOnly(true);
}
if (tfEnqQty.getValue() != null) {
tfEnqQty.setValue(purEnqDtlDM.getEnquiryQty().toString());
}
if (purEnqDtlDM.getRemarks() != null) {
taEnqDtlRem.setValue(purEnqDtlDM.getRemarks().toString());
}
if (purEnqDtlDM.getEnqDtlStaus() != null) {
cbEnqDtlStatus.setValue(purEnqDtlDM.getEnqDtlStaus());
}
}
}
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;
}
