public JournalFilterFrame() {
try {
jbInit();
// set domain in combo box...
ClientApplet applet =
((ApplicationClientFacade) MDIFrame.getInstance().getClientFacade()).getMainClass();
ButtonCompanyAuthorizations bca = applet.getAuthorizations().getCompanyBa();
ArrayList companiesList = bca.getCompaniesList("ACC05");
Domain domain = new Domain("DOMAIN_ACC05");
for (int i = 0; i < companiesList.size(); i++) {
if (applet
.getAuthorizations()
.getCompanyBa()
.isInsertEnabled("ACC05", companiesList.get(i).toString()))
domain.addDomainPair(companiesList.get(i), companiesList.get(i).toString());
}
controlCompaniesCombo.setDomain(domain);
controlCompaniesCombo.getComboBox().setSelectedIndex(0);
setSize(400, 200);
MDIFrame.getInstance().add(this);
} catch (Exception e) {
e.printStackTrace();
}
}
public EmpGridFrame(EmpGridFrameController controller) {
this.controller = controller;
try {
jbInit();
setSize(770, 300);
grid.setController(controller);
grid.setGridDataLocator(controller);
setTitle("Employees");
} catch (Exception e) {
e.printStackTrace();
}
}
public UsersGridFrame(Connection conn, UsersGridFrameController controller) {
super.setDefaultCloseOperation(super.EXIT_ON_CLOSE);
this.conn = conn;
try {
jbInit();
setSize(750, 300);
grid.setController(controller);
grid.setGridDataLocator(controller);
} catch (Exception e) {
e.printStackTrace();
}
}
public SaleCreditDocFrame(SaleCreditDocController controller) {
this.controller = controller;
try {
jbInit();
setSize(750, 630);
setMinimumSize(new Dimension(750, 630));
setTitle(ClientSettings.getInstance().getResources().getResource("credit note"));
// CustomizedControls customizedControls = new
// CustomizedControls(tabbedPane,headerFormPanel,ApplicationConsts.ID_SALE_ESTIMATE);
//
// saleCustomerHeadPanel1.getCustomerDataLocator().getLookupFrameParams().put(ApplicationConsts.SUBJECT_TYPE,ApplicationConsts.SUBJECT_PEOPLE_CUSTOMER);
//
// saleCustomerHeadPanel1.getCustomerDataLocator().getLookupValidationParameters().put(ApplicationConsts.SUBJECT_TYPE,ApplicationConsts.SUBJECT_PEOPLE_CUSTOMER);
init();
} catch (Exception e) {
e.printStackTrace();
}
}
public WarehouseDetailFrame(WarehouseController controller) {
try {
jbInit();
setSize(750, 450);
setMinimumSize(new Dimension(750, 450));
// link the parent grid to the current Form...
HashSet pk = new HashSet();
pk.add("companyCodeSys01WAR01");
pk.add("warehouseCodeWAR01");
warehouseForm.linkGrid(
controller.getGridFrame().getGrid(), pk, true, true, true, navigatorBar);
warehouseForm.setFormController(controller);
CustomizedControls customizedControls =
new CustomizedControls(tabbedPane, warehouseForm, new BigDecimal(462));
} catch (Exception e) {
e.printStackTrace();
}
}
/** Load data from server and construct panel content. */
public final void reloadData(DocumentsFrame frame) {
try {
// remove all panel content...
clearData();
frame.getGrid().getOtherGridParams().put(ApplicationConsts.PROPERTIES_FILTER, filters);
// retrieve customized input controls list...
GridParams gridParams = new GridParams();
DefaultMutableTreeNode node = frame.getHierarTreePanel().getSelectedNode();
if (node != null) {
HierarchyLevelVO vo = (HierarchyLevelVO) node.getUserObject();
HierarchyLevelVO root =
(HierarchyLevelVO) ((DefaultMutableTreeNode) node.getRoot()).getUserObject();
gridParams
.getOtherGridParams()
.put(ApplicationConsts.PROGRESSIVE_HIE01, vo.getProgressiveHIE01());
gridParams
.getOtherGridParams()
.put(ApplicationConsts.ROOT_PROGRESSIVE_HIE01, root.getProgressiveHIE01());
} else gridParams.getOtherGridParams().remove(ApplicationConsts.PROGRESSIVE_HIE01);
gridParams
.getOtherGridParams()
.put(
ApplicationConsts.PROGRESSIVE_HIE02,
frame.getHierarTreePanel().getProgressiveHIE02());
gridParams.getOtherGridParams().put(ApplicationConsts.LOAD_ANCIENTS, Boolean.TRUE);
Response res = ClientUtils.getData("loadLevelProperties", gridParams);
if (res.isError()) {
JOptionPane.showMessageDialog(
ClientUtils.getParentFrame(this),
ClientSettings.getInstance().getResources().getResource("Error while loading data")
+ ":\n"
+ res.getErrorMessage(),
ClientSettings.getInstance().getResources().getResource("Loading Data Error"),
JOptionPane.ERROR_MESSAGE);
return;
}
ArrayList rows = ((VOListResponse) res).getRows();
if (rows.size() > 0) {
// adding customized input controls...
LevelPropertyVO inputControlInfo = null;
int row = 0;
int col = 0;
LabelControl labelControl = null;
TextControl textControl = null;
DateControl dateControl = null;
NumericControl numericControl = null;
for (int i = 0; i < rows.size(); i++) {
inputControlInfo = (LevelPropertyVO) rows.get(i);
labelControl = new LabelControl();
labelControl.setText(inputControlInfo.getDescriptionSYS10());
innerPanel.add(
labelControl,
new GridBagConstraints(
col++,
row,
1,
1,
0.0,
0.0,
GridBagConstraints.WEST,
GridBagConstraints.NONE,
new Insets(5, 5, 5, 5),
0,
0));
if (inputControlInfo.getPropertyTypeDOC21().equals(ApplicationConsts.TYPE_TEXT)) {
textControl = new TextControl();
textControl.setMaxCharacters(255);
textControl.setLinkLabel(labelControl);
innerPanel.add(
textControl,
new GridBagConstraints(
col,
row,
1,
1,
1.0,
0.0,
GridBagConstraints.WEST,
GridBagConstraints.HORIZONTAL,
new Insets(5, 5, 5, 15),
0,
0));
textControl.addFocusListener(new ControlFocusListener(inputControlInfo, textControl));
} else if (inputControlInfo.getPropertyTypeDOC21().equals(ApplicationConsts.TYPE_DATE)) {
dateControl = new DateControl();
dateControl.setLinkLabel(labelControl);
innerPanel.add(
dateControl,
new GridBagConstraints(
col,
row,
1,
1,
1.0,
0.0,
GridBagConstraints.WEST,
GridBagConstraints.NONE,
new Insets(5, 5, 5, 15),
0,
0));
dateControl.addFocusListener(new ControlFocusListener(inputControlInfo, dateControl));
} else if (inputControlInfo.getPropertyTypeDOC21().equals(ApplicationConsts.TYPE_NUM)) {
numericControl = new NumericControl();
numericControl.setDecimals(5);
numericControl.setLinkLabel(labelControl);
innerPanel.add(
numericControl,
new GridBagConstraints(
col,
row,
1,
1,
1.0,
0.0,
GridBagConstraints.WEST,
GridBagConstraints.HORIZONTAL,
new Insets(5, 5, 5, 15),
0,
0));
numericControl.addFocusListener(
new ControlFocusListener(inputControlInfo, numericControl));
}
col++;
if (col >= 2) {
innerPanel.add(
new JPanel(),
new GridBagConstraints(
col,
row,
1,
1,
1.0,
0.0,
GridBagConstraints.WEST,
GridBagConstraints.HORIZONTAL,
new Insets(5, 5, 5, 5),
0,
0));
row++;
col = 0;
}
}
row++;
innerPanel.add(
new JPanel(),
new GridBagConstraints(
col,
row,
1,
1,
0.0,
0.0,
GridBagConstraints.WEST,
GridBagConstraints.NONE,
new Insets(5, 5, 5, 5),
0,
0));
innerPanel.add(
new JPanel(),
new GridBagConstraints(
0,
row,
1,
1,
0.0,
1.0,
GridBagConstraints.WEST,
GridBagConstraints.VERTICAL,
new Insets(5, 5, 5, 5),
0,
0));
this.revalidate();
this.repaint();
}
} catch (Exception ex) {
ex.printStackTrace();
}
}
/**
* This method must be overridden by the subclass to retrieve data and return the valorized value
* object.
*
* @param valueObjectClass value object class
* @return a VOResponse object if data loading is successfully completed, or an ErrorResponse
* object if an error occours
*/
public Response loadData(Class valueObjectClass) {
try {
// since this method could be invoked also when selecting another row on the linked grid,
// the pk attribute must be recalculated from the grid...
int row = gridFrame.getGrid().getSelectedRow();
if (row != -1) {
GridEmpVO gridVO =
(GridEmpVO) gridFrame.getGrid().getVOListTableModel().getObjectForRow(row);
pk = gridVO.getEmpCode();
}
String sql =
"select EMP.EMP_CODE,EMP.FIRST_NAME, EMP.LAST_NAME,EMP.DEPT_CODE,DEPT.DESCRIPTION,EMP.TASK_CODE,TASKS.DESCRIPTION,EMP.SEX,EMP.HIRE_DATE,EMP.SALARY,EMP.NOTE "
+ "from EMP,DEPT,TASKS where EMP.DEPT_CODE=DEPT.DEPT_CODE and EMP.TASK_CODE=TASKS.TASK_CODE and EMP.EMP_CODE='"
+ pk
+ "'";
// mapping between attributes and database fields...
Map attribute2dbField = new HashMap();
attribute2dbField.put("empCode", "EMP.EMP_CODE");
attribute2dbField.put("firstName", "EMP.FIRST_NAME");
attribute2dbField.put("lastName", "EMP.LAST_NAME");
attribute2dbField.put("deptCode", "EMP.DEPT_CODE");
attribute2dbField.put("deptDescription", "DEPT.DESCRIPTION");
attribute2dbField.put("taskCode", "EMP.TASK_CODE");
attribute2dbField.put("taskDescription", "TASKS.DESCRIPTION");
attribute2dbField.put("sex", "EMP.SEX");
attribute2dbField.put("hireDate", "EMP.HIRE_DATE");
attribute2dbField.put("salary", "EMP.SALARY");
attribute2dbField.put("note", "EMP.NOTE");
return QueryUtil.getQuery(
conn,
sql,
new ArrayList(), // list of values linked to "?" parameters in sql
attribute2dbField,
EmpVO.class, // v.o. to dinamically create for each row...
"Y",
"N",
true // log query...
);
} catch (Exception ex) {
ex.printStackTrace();
return new ErrorResponse(ex.getMessage());
}
/*
// an alternative way: you can define your own business logic to retrieve data and adding filtering/sorting conditions at hand...
Statement stmt = null;
try {
stmt = conn.createStatement();
ResultSet rset = stmt.executeQuery(
"select EMP.EMP_CODE,EMP.FIRST_NAME, EMP.LAST_NAME,EMP.DEPT_CODE,DEPT.DESCRIPTION,EMP.TASK_CODE,TASKS.DESCRIPTION,EMP.SEX,EMP.HIRE_DATE,EMP.SALARY,EMP.NOTE "+
"from EMP,DEPT,TASKS where EMP.DEPT_CODE=DEPT.DEPT_CODE and EMP.TASK_CODE=TASKS.TASK_CODE and EMP.EMP_CODE='"+pk+"'"
);
if (rset.next()) {
EmpVO vo = new EmpVO();
vo.setEmpCode(rset.getString(1));
vo.setFirstName(rset.getString(2));
vo.setLastName(rset.getString(3));
vo.setDeptCode(rset.getString(4));
vo.setDeptDescription(rset.getString(5));
vo.setTaskCode(rset.getString(6));
vo.setTaskDescription(rset.getString(7));
vo.setSex(rset.getString(8));
vo.setHireDate(rset.getDate(9));
vo.setSalary(rset.getBigDecimal(10));
vo.setNote(rset.getString(11));
return new VOResponse(vo);
}
else
return new ErrorResponse("No data found.");
}
catch (SQLException ex) {
ex.printStackTrace();
return new ErrorResponse(ex.getMessage());
}
finally {
try {
stmt.close();
}
catch (SQLException ex1) {
}
}
*/
}
/**
* Method called by the Form panel to insert new data.
*
* @param newValueObject value object to save
* @return an ErrorResponse value object in case of errors, VOResponse if the operation is
* successfully completed
*/
public Response insertRecord(ValueObject newPersistentObject) throws Exception {
// mapping between attributes and database fields...
Map attribute2dbField = new HashMap();
attribute2dbField.put("empCode", "EMP_CODE");
attribute2dbField.put("firstName", "FIRST_NAME");
attribute2dbField.put("lastName", "LAST_NAME");
attribute2dbField.put("deptCode", "DEPT_CODE");
attribute2dbField.put("taskCode", "TASK_CODE");
attribute2dbField.put("sex", "SEX");
attribute2dbField.put("hireDate", "HIRE_DATE");
attribute2dbField.put("salary", "SALARY");
attribute2dbField.put("note", "NOTE");
Response res =
QueryUtil.insertTable(conn, newPersistentObject, "EMP", attribute2dbField, "Y", "N", true);
if (res.isError()) {
conn.rollback();
return res;
} else {
// insert 7 records in WORKING_DAYS, one for each day of week...
PreparedStatement pstmt = null;
try {
pstmt = conn.prepareStatement("insert into WORKING_DAYS(EMP_CODE,DAY) values(?,?)");
pstmt.setString(1, ((EmpVO) newPersistentObject).getEmpCode());
pstmt.setInt(2, Calendar.SUNDAY);
pstmt.execute();
pstmt.setString(1, ((EmpVO) newPersistentObject).getEmpCode());
pstmt.setInt(2, Calendar.MONDAY);
pstmt.execute();
pstmt.setString(1, ((EmpVO) newPersistentObject).getEmpCode());
pstmt.setInt(2, Calendar.TUESDAY);
pstmt.execute();
pstmt.setString(1, ((EmpVO) newPersistentObject).getEmpCode());
pstmt.setInt(2, Calendar.WEDNESDAY);
pstmt.execute();
pstmt.setString(1, ((EmpVO) newPersistentObject).getEmpCode());
pstmt.setInt(2, Calendar.THURSDAY);
pstmt.execute();
pstmt.setString(1, ((EmpVO) newPersistentObject).getEmpCode());
pstmt.setInt(2, Calendar.FRIDAY);
pstmt.execute();
pstmt.setString(1, ((EmpVO) newPersistentObject).getEmpCode());
pstmt.setInt(2, Calendar.SATURDAY);
pstmt.execute();
conn.commit();
frame
.getGrid()
.getOtherGridParams()
.put("empCode", ((EmpVO) newPersistentObject).getEmpCode());
frame.getGrid().reloadData();
return res;
} catch (Exception ex) {
conn.rollback();
return new ErrorResponse(ex.getMessage());
} finally {
try {
pstmt.close();
} catch (Exception ex1) {
}
}
}
/*
// an alternative way: you can define your own business logic to store data at hand...
PreparedStatement stmt = null;
try {
stmt = conn.prepareStatement("insert into EMP(EMP_CODE,FIRST_NAME,LAST_NAME,DEPT_CODE,TASK_CODE,SEX,HIRE_DATE,SALARY,NOTE) values(?,?,?,?,?,?,?,?,?)");
EmpVO vo = (EmpVO)newPersistentObject;
stmt.setString(1,vo.getEmpCode());
stmt.setString(2,vo.getFirstName());
stmt.setString(3,vo.getLastName());
stmt.setString(4,vo.getDeptCode());
stmt.setString(5,vo.getTaskCode());
stmt.setString(6,vo.getSex());
stmt.setDate(7,vo.getHireDate());
stmt.setBigDecimal(8,vo.getSalary());
stmt.setString(9,vo.getNote());
stmt.execute();
pk = vo.getEmpCode();
gridFrame.reloadData();
return new VOResponse(vo);
}
catch (SQLException ex) {
ex.printStackTrace();
return new ErrorResponse(ex.getMessage());
}
finally {
try {
stmt.close();
conn.commit();
}
catch (SQLException ex1) {
}
}
*/
}
public OperationsGridFrame(GridController controller) {
try {
jbInit();
setSize(750, 550);
setMinimumSize(new Dimension(750, 550));
operationsGridControl.setController(controller);
operationsGridControl.setGridDataLocator(opGridDataLocator);
opGridDataLocator.setServerMethodName("loadOperations");
// task lookup...
taskDataLocator.setGridMethodName("loadTasks");
taskDataLocator.setValidationMethodName("validateTaskCode");
colTaskCode.setLookupController(taskController);
colTaskCode.setControllerMethodName("getTasksList");
taskController.setLookupDataLocator(taskDataLocator);
taskController.setFrameTitle("tasks");
taskController.setLookupValueObjectClassName("org.jallinone.registers.task.java.TaskVO");
taskController.addLookup2ParentLink("taskCodeREG07", "taskCodeReg07PRO04");
taskController.addLookup2ParentLink("descriptionSYS10", "taskDescriptionSYS10");
taskController.setAllColumnVisible(false);
taskController.setVisibleColumn("taskCodeREG07", true);
taskController.setVisibleColumn("descriptionSYS10", true);
taskController.addLookupListener(
new LookupListener() {
public void codeValidated(boolean validated) {}
public void codeChanged(ValueObject parentVO, Collection parentChangedAttributes) {}
public void beforeLookupAction(ValueObject parentVO) {
OperationVO vo = (OperationVO) parentVO;
taskDataLocator
.getLookupFrameParams()
.put(ApplicationConsts.COMPANY_CODE_SYS01, vo.getCompanyCodeSys01PRO04());
taskDataLocator
.getLookupValidationParameters()
.put(ApplicationConsts.COMPANY_CODE_SYS01, vo.getCompanyCodeSys01PRO04());
}
public void forceValidate() {}
});
new CustomizedColumns(new BigDecimal(192), taskController);
// machineries lookup...
macDataLocator.setGridMethodName("loadMachineries");
macDataLocator.setValidationMethodName("validateMachineryCode");
colMachCode.setLookupController(macController);
colMachCode.setControllerMethodName("getMachineriesList");
macController.setLookupDataLocator(macDataLocator);
macController.setFrameTitle("machineries");
macController.setLookupValueObjectClassName(
"org.jallinone.production.machineries.java.MachineryVO");
macController.addLookup2ParentLink("machineryCodePRO03", "machineryCodePro03PRO04");
macController.addLookup2ParentLink("descriptionSYS10", "machineryDescriptionSYS10");
macController.setAllColumnVisible(false);
macController.setVisibleColumn("machineryCodePRO03", true);
macController.setVisibleColumn("descriptionSYS10", true);
macController.addLookupListener(
new LookupListener() {
public void codeValidated(boolean validated) {}
public void codeChanged(ValueObject parentVO, Collection parentChangedAttributes) {}
public void beforeLookupAction(ValueObject parentVO) {
OperationVO vo = (OperationVO) parentVO;
macDataLocator
.getLookupFrameParams()
.put(ApplicationConsts.COMPANY_CODE_SYS01, vo.getCompanyCodeSys01PRO04());
macDataLocator
.getLookupValidationParameters()
.put(ApplicationConsts.COMPANY_CODE_SYS01, vo.getCompanyCodeSys01PRO04());
}
public void forceValidate() {}
});
} catch (Exception e) {
e.printStackTrace();
}
}
/**
* This method must be overridden by the subclass to retrieve data and return the valorized value
* object.
*
* @param valueObjectClass value object class
* @return a VOResponse object if data loading is successfully completed, or an ErrorResponse
* object if an error occours
*/
public Response loadData(Class valueObjectClass) {
Statement stmt = null;
try {
// since this method could be invoked also when selecting another row on the linked grid,
// the pk attribute must be recalculated from the grid...
int row = gridFrame.getGrid().getSelectedRow();
if (row != -1) {
TestVO gridVO = (TestVO) gridFrame.getGrid().getVOListTableModel().getObjectForRow(row);
pk = gridVO.getStringValue();
}
stmt = conn.createStatement();
ResultSet rset =
stmt.executeQuery(
"select DEMO4.TEXT,DEMO4.DECNUM,DEMO4.CURRNUM,DEMO4.THEDATE,DEMO4.COMBO,DEMO4.CHECK_BOX,DEMO4.RADIO,DEMO4.CODE,"
+ "DEMO4_LOOKUP.DESCRCODE,DEMO4.TA,DEMO4.FORMATTED_TEXT,DEMO4.URI,DEMO4.LINK_LABEL,DEMO4.YEAR,DEMO4.FILENAME "
+ "from DEMO4,DEMO4_LOOKUP where TEXT='"
+ pk
+ "' and DEMO4.CODE=DEMO4_LOOKUP.CODE");
if (rset.next()) {
DetailTestVO vo = new DetailTestVO();
vo.setCheckValue(
rset.getObject(6) == null || !rset.getObject(6).equals("Y")
? Boolean.FALSE
: Boolean.TRUE);
vo.setCombo(new ComboVO());
vo.getCombo().setCode(rset.getString(5));
// this is a simplification: in a real situation combo v.o. will be retrieved from the
// database...
Domain d = ClientSettings.getInstance().getDomain("ORDERSTATE");
if (vo.getCombo().getCode().equals("O")) vo.getCombo().setDescription("opened");
else if (vo.getCombo().getCode().equals("S")) vo.getCombo().setDescription("sospended");
else if (vo.getCombo().getCode().equals("D")) vo.getCombo().setDescription("delivered");
else if (vo.getCombo().getCode().equals("C")) vo.getCombo().setDescription("closed");
vo.setCurrencyValue(rset.getBigDecimal(3));
vo.setDateValue(rset.getDate(4));
vo.setNumericValue(rset.getBigDecimal(2));
vo.setRadioButtonValue(
rset.getObject(7) == null || !rset.getObject(7).equals("Y")
? Boolean.FALSE
: Boolean.TRUE);
vo.setStringValue(rset.getString(1));
vo.setLookupValue(rset.getString(8));
vo.setDescrLookupValue(rset.getString(9));
vo.setTaValue(rset.getString(10));
vo.setFormattedTextValue(rset.getString(11));
vo.setUri(rset.getString(12));
vo.setLinkLabel(rset.getString(13));
vo.setYear(rset.getBigDecimal(14));
vo.setFilename(rset.getString(15));
vo.setTooltipURI(vo.getUri());
try {
if (vo.getFilename() != null) {
File f = new File(vo.getFilename());
BufferedInputStream in = new BufferedInputStream(new FileInputStream(f));
byte[] bytes = new byte[(int) f.length()];
in.read(bytes);
in.close();
vo.setFile(bytes);
}
} catch (Exception ex) {
ex.printStackTrace();
}
stmt.close();
stmt = conn.createStatement();
rset =
stmt.executeQuery(
"select DEMO4_LIST_VALUES.CODE from DEMO4_LIST_VALUES where TEXT='" + pk + "'");
ArrayList codes = new ArrayList();
while (rset.next()) {
codes.add(rset.getString(1));
}
vo.setListValues(codes);
return new VOResponse(vo);
} else return new ErrorResponse("No data found.");
} catch (SQLException ex) {
ex.printStackTrace();
return new ErrorResponse(ex.getMessage());
} finally {
try {
stmt.close();
} catch (Exception ex1) {
}
}
}
/**
* Method called by the Form panel to update existing data.
*
* @param oldPersistentObject original value object, previous to the changes
* @param persistentObject value object to save
* @return an ErrorResponse value object in case of errors, VOResponse if the operation is
* successfully completed
*/
public Response updateRecord(ValueObject oldPersistentObject, ValueObject persistentObject)
throws Exception {
PreparedStatement stmt = null;
try {
stmt =
conn.prepareStatement(
"update DEMO4 set TEXT=?,DECNUM=?,CURRNUM=?,THEDATE=?,COMBO=?,CHECK_BOX=?,RADIO=?,CODE=?,TA=?,FORMATTED_TEXT=?,URI=?,LINK_LABEL=?,YEAR=?,FILENAME=? where TEXT=?");
DetailTestVO vo = (DetailTestVO) persistentObject;
DetailTestVO oldVO = (DetailTestVO) oldPersistentObject;
stmt.setObject(
6, vo.getCheckValue() == null || !vo.getCheckValue().booleanValue() ? "N" : "Y");
stmt.setString(5, vo.getCombo().getCode());
stmt.setBigDecimal(3, vo.getCurrencyValue());
stmt.setDate(4, vo.getDateValue());
stmt.setBigDecimal(2, vo.getNumericValue());
stmt.setObject(
7,
vo.getRadioButtonValue() == null || !vo.getRadioButtonValue().booleanValue() ? "N" : "Y");
stmt.setString(1, vo.getStringValue());
stmt.setString(8, vo.getLookupValue());
stmt.setString(9, vo.getTaValue());
stmt.setString(10, vo.getFormattedTextValue());
stmt.setString(11, vo.getUri());
stmt.setString(12, vo.getLinkLabel());
stmt.setBigDecimal(13, vo.getYear());
stmt.setString(14, vo.getFilename());
stmt.setString(15, oldVO.getStringValue());
stmt.execute();
stmt.close();
stmt = conn.prepareStatement("delete from DEMO4_LIST_VALUES where TEXT=?");
stmt.setString(1, pk);
stmt.execute();
if (vo.getListValues() != null) {
stmt.close();
stmt = conn.prepareStatement("insert into DEMO4_LIST_VALUES(TEXT,CODE) values(?,?)");
for (int i = 0; i < vo.getListValues().size(); i++) {
stmt.setString(1, pk);
stmt.setString(2, vo.getListValues().get(i).toString());
stmt.execute();
}
}
try {
if (vo.getFilename() != null && vo.getFile() != null) {
File f = new File(vo.getFilename());
BufferedOutputStream out = new BufferedOutputStream(new FileOutputStream(f));
out.write(vo.getFile());
out.close();
}
} catch (Exception ex) {
ex.printStackTrace();
}
// this instruction is no more needed: the grid has been linked to the Form (see Form.linkGrid
// method...)
// gridFrame.reloadData();
return new VOResponse(vo);
} catch (SQLException ex) {
ex.printStackTrace();
return new ErrorResponse(ex.getMessage());
} finally {
try {
stmt.close();
conn.commit();
} catch (SQLException ex1) {
}
}
}
/**
* Constructor called by sale doc header frames.
*
* @param form sale doc header form
* @param showDocRefLookup <code>true</code> to show combo+lookup used to select a linked document
* (e.g. a sale document in an invoice document); <code>false</code> to hide combo+lookup and
* show doc. ref. nr. input control
* @param showSectional <code>true</code> to show the sectional field (for invoice documents);
* <code>false</code> to hide that field
*/
public SaleIdHeadPanel(Form form, boolean showDocRefLookup, boolean showSectional) {
this.showDocRefLookup = showDocRefLookup;
this.showSectional = showSectional;
try {
jbInit();
// doc. ref. lookup...
docRefDataLocator.setGridMethodName("loadSaleDocs");
docRefDataLocator.setValidationMethodName("validateSaleDocNumber");
controlDocRifLookup.setLookupController(docRefController);
docRefController.setForm(form);
docRefController.setLookupDataLocator(docRefDataLocator);
docRefController.setFrameTitle("documents");
docRefController.setLookupValueObjectClassName(
"org.jallinone.sales.documents.java.GridSaleDocVO");
docRefController.addLookup2ParentLink("companyCodeSys01DOC01", "companyCodeSys01Doc01DOC01");
docRefController.addLookup2ParentLink("docTypeDOC01", "docTypeDoc01DOC01");
docRefController.addLookup2ParentLink("docYearDOC01", "docYearDoc01DOC01");
docRefController.addLookup2ParentLink("docNumberDOC01", "docNumberDoc01DOC01");
docRefController.addLookup2ParentLink("docSequenceDOC01", "docSequenceDoc01DOC01");
docRefController.setAllColumnVisible(false);
docRefController.setDomainColumn("docTypeDOC01", "SALE_DOC_TYPE");
docRefController.setPreferredWidthColumn("docStateDOC01", 60);
docRefController.setPreferredWidthColumn("docTypeDOC01", 60);
docRefController.setPreferredWidthColumn("docYearDOC01", 60);
docRefController.setPreferredWidthColumn("docSequenceDOC01", 90);
docRefController.setPreferredWidthColumn("name_1REG04", 150);
docRefController.setPreferredWidthColumn("name_2REG04", 140);
docRefController.setPreferredWidthColumn("docDateDOC01", 80);
docRefController.setSortedColumn("companyCodeSys01DOC01", "ASC", 1);
docRefController.setSortedColumn("docTypeDOC01", "ASC", 2);
docRefController.setSortedColumn("docYearDOC01", "ASC", 3);
docRefController.setSortedColumn("docSequenceDOC01", "ASC", 4);
docRefController.setVisibleColumn("companyCodeSys01DOC01", true);
docRefController.setVisibleColumn("docTypeDOC01", true);
docRefController.setVisibleColumn("docYearDOC01", true);
docRefController.setVisibleColumn("docSequenceDOC01", true);
docRefController.setVisibleColumn("name_1REG04", true);
docRefController.setVisibleColumn("name_2REG04", true);
docRefController.setVisibleColumn("docDateDOC01", true);
docRefController.setFramePreferedSize(new Dimension(700, 500));
docRefController.addLookupListener(
new LookupListener() {
public void codeValidated(boolean validated) {}
public void codeChanged(ValueObject parentVO, Collection parentChangedAttributes) {}
public void beforeLookupAction(ValueObject parentVO) {
docRefDataLocator
.getLookupFrameParams()
.put(ApplicationConsts.DOC_TYPE, controlDocTypeRef.getValue());
docRefDataLocator
.getLookupValidationParameters()
.put(ApplicationConsts.DOC_TYPE, controlDocTypeRef.getValue());
// filter sale documents having state confirmed, i.e. not yet invoiced, except for
// sale desk docs...
if (ApplicationConsts.SALE_DESK_DOC_TYPE.equals(controlDocTypeRef.getValue())) {
docRefDataLocator
.getLookupFrameParams()
.put(ApplicationConsts.DOC_STATE, ApplicationConsts.CLOSED);
docRefDataLocator
.getLookupValidationParameters()
.put(ApplicationConsts.DOC_STATE, ApplicationConsts.CLOSED);
} else {
docRefDataLocator
.getLookupFrameParams()
.put(ApplicationConsts.DOC_STATE, ApplicationConsts.CONFIRMED);
docRefDataLocator
.getLookupValidationParameters()
.put(ApplicationConsts.DOC_STATE, ApplicationConsts.CONFIRMED);
}
}
public void forceValidate() {}
});
} catch (Exception e) {
e.printStackTrace();
}
}
public SupplierDetailFrame(final SupplierController controller) {
try {
jbInit();
setSize(750, 550);
setMinimumSize(new Dimension(750, 550));
supplierPanel.setFormController(controller);
supplierPanel.setInsertButton(insertButton);
supplierPanel.setEditButton(editButton);
supplierPanel.setReloadButton(reloadButton);
supplierPanel.setDeleteButton(deleteButton);
supplierPanel.setSaveButton(saveButton);
supplierPanel.setFunctionId("PUR01");
organizationPanel.setFunctionId("PUR01");
// link the parent grid to the current Form...
HashSet pk = new HashSet();
pk.add("companyCodeSys01REG04");
pk.add("progressiveREG04");
supplierPanel.linkGrid(
controller.getGridFrame().getGrid(), pk, true, true, true, navigatorBar);
// banks lookup...
bankDataLocator.setGridMethodName("loadBanks");
bankDataLocator.setValidationMethodName("validateBankCode");
controlBank.setLookupController(bankController);
controlBank.setControllerMethodName("getBanksList");
bankController.setLookupDataLocator(bankDataLocator);
bankController.setFrameTitle("banks");
bankController.setLookupValueObjectClassName("org.jallinone.registers.bank.java.BankVO");
bankController.addLookup2ParentLink("bankCodeREG12", "bankCodeReg12PUR01");
bankController.addLookup2ParentLink("descriptionREG12", "descriptionREG12");
bankController.setAllColumnVisible(false);
bankController.setVisibleColumn("bankCodeREG12", true);
bankController.setVisibleColumn("descriptionREG12", true);
bankController.setPreferredWidthColumn("descriptionREG12", 200);
new CustomizedColumns(new BigDecimal(232), bankController);
// payments lookup...
payDataLocator.setGridMethodName("loadPayments");
payDataLocator.setValidationMethodName("validatePaymentCode");
controlPayment.setLookupController(payController);
controlPayment.setControllerMethodName("getPaymentsList");
payController.setLookupDataLocator(payDataLocator);
payController.setFrameTitle("payments");
payController.setLookupValueObjectClassName(
"org.jallinone.registers.payments.java.PaymentVO");
payController.addLookup2ParentLink("paymentCodeREG10", "paymentCodeReg10PUR01");
payController.addLookup2ParentLink("descriptionSYS10", "paymentDescriptionSYS10");
payController.setAllColumnVisible(false);
payController.setVisibleColumn("paymentCodeREG10", true);
payController.setVisibleColumn("descriptionSYS10", true);
payController.setPreferredWidthColumn("descriptionSYS10", 200);
new CustomizedColumns(new BigDecimal(212), payController);
payController.addLookupListener(
new LookupListener() {
public void beforeLookupAction(
org.openswing.swing.message.receive.java.ValueObject parentVO) {
DetailSupplierVO vo = (DetailSupplierVO) parentVO;
payDataLocator
.getLookupValidationParameters()
.put(ApplicationConsts.COMPANY_CODE_SYS01, vo.getCompanyCodeSys01REG04());
payDataLocator
.getLookupFrameParams()
.put(ApplicationConsts.COMPANY_CODE_SYS01, vo.getCompanyCodeSys01REG04());
}
public void codeChanged(
org.openswing.swing.message.receive.java.ValueObject parentVO,
Collection parentChangedAttributes) {}
public void codeValidated(boolean validated) {}
public void forceValidate() {}
});
// items lookup...
itemDataLocator.setGridMethodName("loadItems");
itemDataLocator.setValidationMethodName("validateItemCode");
colItemCode.setLookupController(itemController);
colItemCode.setControllerMethodName("getItemsList");
itemController.setLookupDataLocator(itemDataLocator);
itemController.setFrameTitle("items");
itemController.setLookupValueObjectClassName("org.jallinone.items.java.GridItemVO");
itemController.addLookup2ParentLink("companyCodeSys01ITM01", "companyCodeSys01PUR02");
itemController.addLookup2ParentLink("itemCodeITM01", "itemCodeItm01PUR02");
itemController.addLookup2ParentLink("descriptionSYS10", "descriptionSYS10");
itemController.setAllColumnVisible(false);
itemController.setVisibleColumn("itemCodeITM01", true);
itemController.setVisibleColumn("descriptionSYS10", true);
itemController.setPreferredWidthColumn("descriptionSYS10", 200);
new CustomizedColumns(ApplicationConsts.ID_ITEMS_GRID, itemController);
itemController.addLookupListener(
new LookupListener() {
public void codeValidated(boolean validated) {}
public void codeChanged(ValueObject parentVO, Collection parentChangedAttributes) {
GridItemVO vo = (GridItemVO) itemController.getLookupVO();
if (vo.getItemCodeITM01() != null) {
SupplierItemVO supplierVO = (SupplierItemVO) parentVO;
supplierVO.setSupplierItemCodePUR02(vo.getItemCodeITM01());
}
}
public void beforeLookupAction(ValueObject parentVO) {}
public void forceValidate() {}
});
// purchase um lookup...
umDataLocator.setGridMethodName("loadMeasures");
umDataLocator.setValidationMethodName("validateMeasureCode");
colUmCode.setLookupController(umController);
colUmCode.setControllerMethodName("getMeasureUnitsList");
umController.setLookupDataLocator(umDataLocator);
umController.setFrameTitle("measures");
umController.setLookupValueObjectClassName("org.jallinone.registers.measure.java.MeasureVO");
umController.addLookup2ParentLink("umCodeREG02", "umCodeReg02PUR02");
umController.addLookup2ParentLink("decimalsREG02", "decimalsREG02");
umController.setAllColumnVisible(false);
umController.setVisibleColumn("umCodeREG02", true);
umController.setVisibleColumn("decimalsREG02", true);
new CustomizedColumns(ApplicationConsts.ID_UM_GRID, umController);
umController.addLookupListener(
new LookupListener() {
public void codeValidated(boolean validated) {}
public void codeChanged(ValueObject parentVO, Collection parentChangedAttributes) {
MeasureVO vo = (MeasureVO) umController.getLookupVO();
if (vo.getUmCodeREG02() != null) {
colMinQty.setDecimals(vo.getDecimalsREG02().intValue());
colMultipleQty.setDecimals(vo.getDecimalsREG02().intValue());
SupplierItemVO supplierVO = (SupplierItemVO) parentVO;
if (supplierVO.getMinPurchaseQtyPUR02() != null)
supplierVO.setMinPurchaseQtyPUR02(
supplierVO
.getMinPurchaseQtyPUR02()
.setScale(vo.getDecimalsREG02().intValue(), BigDecimal.ROUND_HALF_UP));
if (supplierVO.getMultipleQtyPUR02() != null)
supplierVO.setMultipleQtyPUR02(
supplierVO
.getMultipleQtyPUR02()
.setScale(vo.getDecimalsREG02().intValue(), BigDecimal.ROUND_HALF_UP));
}
}
public void beforeLookupAction(ValueObject parentVO) {}
public void forceValidate() {}
});
itemsGrid.setController(new SupplierItemsController(this));
itemsGrid.setGridDataLocator(itemsGridDataLocator);
itemsGridDataLocator.setServerMethodName("loadSupplierItems");
treePanel.addHierarTreeListener(
new HierarTreeListener() {
public void loadDataCompleted(boolean error) {
if (treePanel.getTree().getRowCount() > 0) treePanel.getTree().setSelectionRow(0);
if (treePanel.getTree().getSelectionPath() != null)
controller.leftClick(
(DefaultMutableTreeNode)
treePanel.getTree().getSelectionPath().getLastPathComponent());
}
});
treePanel.setTreeController(controller);
treePanel.setFunctionId("PUR01");
init();
itemsGrid.enableDrag(ApplicationConsts.ID_SUPPLIER_ITEMS_GRID.toString());
// debit account code lookup...
controlDebitsCode.setLookupController(debitController);
controlDebitsCode.setControllerMethodName("getAccounts");
debitController.setLookupDataLocator(debitDataLocator);
debitDataLocator.setGridMethodName("loadAccounts");
debitDataLocator.setValidationMethodName("validateAccountCode");
debitController.setFrameTitle("accounts");
debitController.setAllowTreeLeafSelectionOnly(false);
debitController.setLookupValueObjectClassName(
"org.jallinone.accounting.accounts.java.AccountVO");
debitController.addLookup2ParentLink("accountCodeACC02", "debitAccountCodeAcc02PUR01");
debitController.addLookup2ParentLink("descriptionSYS10", "debitAccountDescrPUR01");
debitController.setFramePreferedSize(new Dimension(400, 400));
debitController.setAllColumnVisible(false);
debitController.setVisibleColumn("accountCodeACC02", true);
debitController.setVisibleColumn("descriptionSYS10", true);
debitController.setFilterableColumn("accountCodeACC02", true);
debitController.setFilterableColumn("descriptionSYS10", true);
debitController.setSortedColumn("accountCodeACC02", "ASC", 1);
debitController.setSortableColumn("accountCodeACC02", true);
debitController.setSortableColumn("descriptionSYS10", true);
debitController.setPreferredWidthColumn("accountCodeACC02", 100);
debitController.setPreferredWidthColumn("descriptionSYS10", 290);
debitController.addLookupListener(
new LookupListener() {
public void codeValidated(boolean validated) {}
public void codeChanged(ValueObject parentVO, Collection parentChangedAttributes) {}
public void beforeLookupAction(ValueObject parentVO) {
debitDataLocator
.getLookupFrameParams()
.put(ApplicationConsts.COMPANY_CODE_SYS01, controlCompanyCode.getValue());
debitDataLocator
.getLookupValidationParameters()
.put(ApplicationConsts.COMPANY_CODE_SYS01, controlCompanyCode.getValue());
}
public void forceValidate() {}
});
// costs account code lookup...
controlCostsCode.setLookupController(costsController);
controlCostsCode.setControllerMethodName("getAccounts");
costsController.setLookupDataLocator(costsDataLocator);
costsDataLocator.setGridMethodName("loadAccounts");
costsDataLocator.setValidationMethodName("validateAccountCode");
costsController.setFrameTitle("accounts");
costsController.setAllowTreeLeafSelectionOnly(false);
costsController.setLookupValueObjectClassName(
"org.jallinone.accounting.accounts.java.AccountVO");
costsController.addLookup2ParentLink("accountCodeACC02", "costsAccountCodeAcc02PUR01");
costsController.addLookup2ParentLink("descriptionSYS10", "costsAccountDescrPUR01");
costsController.setFramePreferedSize(new Dimension(400, 400));
costsController.setAllColumnVisible(false);
costsController.setVisibleColumn("accountCodeACC02", true);
costsController.setVisibleColumn("descriptionSYS10", true);
costsController.setFilterableColumn("accountCodeACC02", true);
costsController.setFilterableColumn("descriptionSYS10", true);
costsController.setSortedColumn("accountCodeACC02", "ASC", 1);
costsController.setSortableColumn("accountCodeACC02", true);
costsController.setSortableColumn("descriptionSYS10", true);
costsController.setPreferredWidthColumn("accountCodeACC02", 100);
costsController.setPreferredWidthColumn("descriptionSYS10", 290);
costsController.addLookupListener(
new LookupListener() {
public void codeValidated(boolean validated) {}
public void codeChanged(ValueObject parentVO, Collection parentChangedAttributes) {}
public void beforeLookupAction(ValueObject parentVO) {
costsDataLocator
.getLookupFrameParams()
.put(ApplicationConsts.COMPANY_CODE_SYS01, controlCompanyCode.getValue());
costsDataLocator
.getLookupValidationParameters()
.put(ApplicationConsts.COMPANY_CODE_SYS01, controlCompanyCode.getValue());
}
public void forceValidate() {}
});
CustomizedControls customizedControls =
new CustomizedControls(tabbedPane, supplierPanel, ApplicationConsts.ID_SUPPLIER_GRID);
} catch (Exception e) {
e.printStackTrace();
}
}