@SuppressWarnings("unchecked")
public ResidentConverter(List<ObjectConverter.ColumnInfo> allColumns) throws java.io.IOException {
Optional<ObjectConverter.ColumnInfo> column;
final java.util.List<ObjectConverter.ColumnInfo> columns =
allColumns
.stream()
.filter(
it ->
"mixinReference".equals(it.typeSchema) && "Resident_entity".equals(it.typeName))
.collect(Collectors.toList());
columnCount = columns.size();
readers = new ObjectConverter.Reader[columnCount];
for (int i = 0; i < readers.length; i++) {
readers[i] = (instance, rdr, ctx) -> StringConverter.skip(rdr, ctx);
}
final java.util.List<ObjectConverter.ColumnInfo> columnsExtended =
allColumns
.stream()
.filter(
it ->
"mixinReference".equals(it.typeSchema)
&& "-ngs_Resident_type-".equals(it.typeName))
.collect(Collectors.toList());
columnCountExtended = columnsExtended.size();
readersExtended = new ObjectConverter.Reader[columnCountExtended];
for (int i = 0; i < readersExtended.length; i++) {
readersExtended[i] = (instance, rdr, ctx) -> StringConverter.skip(rdr, ctx);
}
column = columns.stream().filter(it -> "id".equals(it.columnName)).findAny();
if (!column.isPresent())
throw new java.io.IOException(
"Unable to find 'id' column in mixinReference Resident_entity. Check if DB is in sync");
__index___id = (int) column.get().order - 1;
column = columnsExtended.stream().filter(it -> "id".equals(it.columnName)).findAny();
if (!column.isPresent())
throw new java.io.IOException(
"Unable to find 'id' column in mixinReference Resident. Check if DB is in sync");
__index__extended_id = (int) column.get().order - 1;
column = columns.stream().filter(it -> "birth".equals(it.columnName)).findAny();
if (!column.isPresent())
throw new java.io.IOException(
"Unable to find 'birth' column in mixinReference Resident_entity. Check if DB is in sync");
__index___birth = (int) column.get().order - 1;
column = columnsExtended.stream().filter(it -> "birth".equals(it.columnName)).findAny();
if (!column.isPresent())
throw new java.io.IOException(
"Unable to find 'birth' column in mixinReference Resident. Check if DB is in sync");
__index__extended_birth = (int) column.get().order - 1;
}
// create from a dataset
public VariableBean(Variable vs) {
this.vs = vs;
// vs = (v instanceof VariableEnhanced) ? (VariableEnhanced) v : new VariableStandardized( v);
setName(vs.getShortName());
setDescription(vs.getDescription());
setUnits(vs.getUnitsString());
setDataType(vs.getDataType().toString());
// Attribute csAtt = vs.findAttribute("_coordSystems");
// if (csAtt != null)
// setCoordSys( csAtt.getStringValue());
// collect dimensions
StringBuilder lens = new StringBuilder();
StringBuilder names = new StringBuilder();
java.util.List dims = vs.getDimensions();
for (int j = 0; j < dims.size(); j++) {
ucar.nc2.Dimension dim = (ucar.nc2.Dimension) dims.get(j);
if (j > 0) {
lens.append(",");
names.append(",");
}
String name = dim.isShared() ? dim.getName() : "anon";
names.append(name);
lens.append(dim.getLength());
}
setDimensions(names.toString());
setShape(lens.toString());
}
public void parseGroup(Group g) throws Hdf5Exception, EndOfSequenceException {
startGroup(g);
java.util.List members = g.getMemberList();
// NOTE: parsing contents twice to ensure subgroups are handled before datasets
// This is mainly because synapse_props groups will need to be parsed before dataset of
// connections
for (int j = 0; j < members.size(); j++) {
HObject obj = (HObject) members.get(j);
if (obj instanceof Group) {
Group subGroup = (Group) obj;
logger.logComment("--------- Found a sub group: " + subGroup.getName());
parseGroup(subGroup);
}
}
for (int j = 0; j < members.size(); j++) {
HObject obj = (HObject) members.get(j);
if (obj instanceof Dataset) {
Dataset ds = (Dataset) obj;
logger.logComment("Found a dataset: " + ds.getName());
dataSet(ds);
}
}
endGroup(g);
}
/** Generate ParseException. */
public ParseException generateParseException() {
jj_expentries.clear();
boolean[] la1tokens = new boolean[11];
if (jj_kind >= 0) {
la1tokens[jj_kind] = true;
jj_kind = -1;
}
for (int i = 0; i < 3; i++) {
if (jj_la1[i] == jj_gen) {
for (int j = 0; j < 32; j++) {
if ((jj_la1_0[i] & (1 << j)) != 0) {
la1tokens[j] = true;
}
}
}
}
for (int i = 0; i < 11; i++) {
if (la1tokens[i]) {
jj_expentry = new int[1];
jj_expentry[0] = i;
jj_expentries.add(jj_expentry);
}
}
jj_endpos = 0;
jj_rescan_token();
jj_add_error_token(0, 0);
int[][] exptokseq = new int[jj_expentries.size()][];
for (int i = 0; i < jj_expentries.size(); i++) {
exptokseq[i] = jj_expentries.get(i);
}
return new ParseException(token, exptokseq, tokenImage);
}
private int writeHTML(PrintWriter out, int level, ReportData rd) throws ReportException {
/* no ReportData */
if (rd == null) {
return 0;
}
/* simple report */
if (!rd.isSingleDeviceOnly() || (rd.getDeviceCount() <= 1)) {
return this._writeHTML(out, level, rd, -1);
}
/* multiple per-device reports */
ReportDeviceList rdl = rd.getReportDeviceList();
java.util.List<ReportDeviceList.DeviceHolder> dhList = rdl.getDeviceHolderList(true);
rdl.clear();
int rcdCount = 0;
int devCount = dhList.size();
for (int i = 0; i < devCount; i++) {
if (i > 0) {
out.print("<br>\n");
}
rdl.setDevice(null, dhList.get(i));
rcdCount += this._writeHTML(out, level, rd, i);
}
return rcdCount;
}
private Locale getLocale() {
java.util.List result = new java.util.ArrayList();
String language = "";
String country = "";
String variant = "";
// -----------------------------------------------------------------
// <locale language="en" country="GB" variant="J" />
// -----------------------------------------------------------------
result = PM_XML_Utils.getElementListe(document, "//" + TAG_LOCALE);
if (result.size() == 1) {
Element el = (Element) result.get(0);
language = PM_XML_Utils.getAttribute(el, ATTR_LOCALE_LANGUAGE);
country = PM_XML_Utils.getAttribute(el, ATTR_LOCALE_COUNTRY);
variant = PM_XML_Utils.getAttribute(el, ATTR_LOCALE_VARIANT);
}
if (language.length() == 0) {
return null;
}
// if (country.length() == 0) {
// return new Locale(language);
// }
// if (variant.length() == 0) {
// return new Locale(language, country);
// }
return new Locale(language, country, variant);
}
/* return status codes for account/device */
public static int[] getStatusCodes(String accountID, String deviceID) throws DBException {
/* account-id specified? */
if (StringTools.isBlank(accountID)) {
return new int[0];
}
/* device-id specified? */
if (StringTools.isBlank(deviceID)) {
deviceID = ALL_DEVICES;
}
/* select */
// DBSelect: SELECT statucCode FROM StatusCode WHERE (accountID='acct') AND (deviceID='*') ORDER
// BY statucCode
DBSelect<StatusCode> dsel = new DBSelect<StatusCode>(StatusCode.getFactory());
dsel.setSelectedFields(StatusCode.FLD_statusCode);
DBWhere dwh = dsel.createDBWhere();
dsel.setWhere(
dwh.WHERE_(
dwh.AND(
dwh.EQ(StatusCode.FLD_accountID, accountID),
dwh.EQ(StatusCode.FLD_deviceID, deviceID))));
dsel.setOrderByFields(StatusCode.FLD_statusCode);
/* get list */
java.util.List<Integer> codeList = new Vector<Integer>();
Statement stmt = null;
ResultSet rs = null;
try {
stmt = DBConnection.getDefaultConnection().execute(dsel.toString());
rs = stmt.getResultSet();
while (rs.next()) {
int code = rs.getInt(StatusCode.FLD_statusCode);
codeList.add(new Integer(code));
}
} catch (SQLException sqe) {
throw new DBException("Getting StatusCode List", sqe);
} finally {
if (rs != null) {
try {
rs.close();
} catch (Throwable t) {
}
}
if (stmt != null) {
try {
stmt.close();
} catch (Throwable t) {
}
}
}
/* return array of status codes */
int codeListInt[] = new int[codeList.size()];
for (int i = 0; i < codeListInt.length; i++) {
codeListInt[i] = codeList.get(i).intValue();
}
return codeListInt;
}
private void setMpeg() {
java.util.List result = new java.util.ArrayList();
// -----------------------------------------------------------------
// <diashow>
// -----------------------------------------------------------------
result = PM_XML_Utils.getElementListe(document, "//" + TAG_VDR);
if (result.size() == 1) {
// support vdr (make for example mpeg files)
mpeg = true;
}
}
// =====================================================
// private: setDatumJahrVonBis()
//
// <datum jahr-von="1998" jahr-bis="2007"/>
//
// =====================================================
private void setDateFromTo() {
java.util.List result = new java.util.ArrayList();
// -----------------------------------------------------------------
// <datum>
// -----------------------------------------------------------------
result = PM_XML_Utils.getElementListe(document, "//" + TAG_DATUM);
if (result.size() == 1) {
Element elDatum = (Element) result.get(0);
datumJahrVon = PM_XML_Utils.getAttributeInt(elDatum, ATTR_DATUM_JAHR_VON);
datumJahrBis = PM_XML_Utils.getAttributeInt(elDatum, ATTR_DATUM_JAHR_BIS);
}
}
// =====================================================
// private: setPreftch()
//
// <prefetch plus="2" minus="0"/>
//
// =====================================================
private void setPrefetch() {
java.util.List result = new java.util.ArrayList();
// -----------------------------------------------------------------
// <datum>
// -----------------------------------------------------------------
result = PM_XML_Utils.getElementListe(document, "//" + TAG_PREFETCH);
if (result.size() == 1) {
Element elPrefetch = (Element) result.get(0);
prefetchPlus = PM_XML_Utils.getAttributeInt(elPrefetch, ATTR_PREFETCH_PLUS);
prefetchMinus = PM_XML_Utils.getAttributeInt(elPrefetch, ATTR_PREFETCH_MINUS);
}
}
private void setSlideshow() {
java.util.List result = new java.util.ArrayList();
// -----------------------------------------------------------------
// <diashow>
// -----------------------------------------------------------------
result = PM_XML_Utils.getElementListe(document, "//" + TAG_DIASHOW);
if (result.size() == 1) {
Element el = (Element) result.get(0);
slideshowText1 = PM_XML_Utils.getAttribute(el, ATTR_DIASHOW_TEXT1);
slideshowText2 = PM_XML_Utils.getAttribute(el, ATTR_DIASHOW_TEXT2);
slideshowText3 = PM_XML_Utils.getAttribute(el, ATTR_DIASHOW_TEXT3);
}
}
void drawScribbles(Graphics g) {
if ((scribbles == null) || (scribbles.size() == 0)) {
return;
}
DrawObject L = (DrawObject) scribbles.get(0);
int scribbleCounter = L.scribbleNum;
g.setColor(scribbleColor);
((Graphics2D) g).setStroke(new BasicStroke(2f));
int prevX = L.scribbleX;
int prevY = L.scribbleY;
for (int i = 1; i < scribbles.size(); i++) {
L = (DrawObject) scribbles.get(i);
if (L.scribbleNum == scribbleCounter) {
// Keep drawing.
g.drawLine(prevX, prevY, L.scribbleX, L.scribbleY);
prevX = L.scribbleX;
prevY = L.scribbleY;
} else {
scribbleCounter = L.scribbleNum;
prevX = L.scribbleX;
prevY = L.scribbleY;
}
}
}
String[] getContactList() {
java.util.List cl = new java.util.LinkedList();
StringTokenizer st = new StringTokenizer(contactList.getText());
StringBuffer sb = new StringBuffer();
StringBuffer dbg = new StringBuffer("test applet contactlist: ");
while (st.hasMoreTokens()) {
String loginId = st.nextToken().trim();
if (loginId.length() == 0) continue;
dbg.append("'" + loginId + "' ");
cl.add(loginId);
sb.append(loginId).append('\n');
}
CAT.info(dbg.toString());
contactList.setText(sb.toString());
return (String[]) cl.toArray(new String[cl.size()]);
}
private File getHomeFile() {
File home = null;
java.util.List result = new java.util.ArrayList();
String value = null;
// -----------------------------------------------------------------
// <bilder>
// -----------------------------------------------------------------
result = PM_XML_Utils.getElementListe(document, "//" + TAG_HOME + "/" + TAG_BILDER);
if (result.size() == 1) {
value = ((Element) result.get(0)).getTextTrim();
value = PM_Utils.removeLastSeparatorChar(value);
home = new File(value);
if (!home.isDirectory()) {
home = null;
}
}
return home;
}
@Override
protected void setUp() throws Exception {
super.setUp();
myNestedFormLoader = new MyNestedFormLoader();
final String swingPath = PathUtil.getJarPathForClass(AbstractButton.class);
java.util.List<URL> cp = new ArrayList<URL>();
appendPath(cp, JBTabbedPane.class);
appendPath(cp, TIntObjectHashMap.class);
appendPath(cp, UIUtil.class);
appendPath(cp, SystemInfoRt.class);
appendPath(cp, ApplicationManager.class);
appendPath(cp, PathManager.getResourceRoot(this.getClass(), "/messages/UIBundle.properties"));
appendPath(cp, PathManager.getResourceRoot(this.getClass(), "/RuntimeBundle.properties"));
appendPath(cp, GridLayoutManager.class); // forms_rt
appendPath(cp, DataProvider.class);
myClassFinder =
new MyClassFinder(
new URL[] {new File(swingPath).toURI().toURL()}, cp.toArray(new URL[cp.size()]));
}
/** Business logic to execute. */
public final Response executeCommand(
Object inputPar,
UserSessionParameters userSessionPars,
HttpServletRequest request,
HttpServletResponse response,
HttpSession userSession,
ServletContext context) {
String serverLanguageId = ((JAIOUserSessionParameters) userSessionPars).getServerLanguageId();
Connection conn = null;
Statement stmt = null;
try {
conn = ConnectionManager.getConnection(context);
// fires the GenericEvent.CONNECTION_CREATED event...
EventsManager.getInstance()
.processEvent(
new GenericEvent(
this,
getRequestName(),
GenericEvent.CONNECTION_CREATED,
(JAIOUserSessionParameters) userSessionPars,
request,
response,
userSession,
context,
conn,
inputPar,
null));
java.util.List list = (ArrayList) inputPar;
HierarItemDiscountVO vo = null;
ResultSet rset = null;
stmt = conn.createStatement();
for (int i = 0; i < list.size(); i++) {
vo = (HierarItemDiscountVO) list.get(i);
vo.setDiscountTypeSAL03(ApplicationConsts.DISCOUNT_CUSTOMER);
// retrieve COMPANY_CODE from progressiveHIE01...
rset =
stmt.executeQuery(
"select COMPANY_CODE_SYS01 from ITM02_ITEM_TYPES where PROGRESSIVE_HIE02 in "
+ "(select PROGRESSIVE_HIE02 from HIE01_LEVELS where PROGRESSIVE="
+ vo.getProgressiveHie01SAL05()
+ ")");
if (rset.next()) vo.setCompanyCodeSys01SAL03(rset.getString(1));
else {
rset.close();
conn.rollback();
return new ErrorResponse("Item hierarchy not found.");
}
rset.close();
DiscountBean.insertDiscount(conn, vo);
stmt.execute(
"insert into SAL05_ITEM_HIERAR_DISCOUNTS(COMPANY_CODE_SYS01,PROGRESSIVE_HIE01,DISCOUNT_CODE_SAL03) "
+ "values('"
+ vo.getCompanyCodeSys01SAL03()
+ "',"
+ vo.getProgressiveHie01SAL05()
+ ",'"
+ vo.getDiscountCodeSAL03()
+ "')");
}
Response answer = new VOListResponse(list, false, list.size());
// fires the GenericEvent.BEFORE_COMMIT event...
EventsManager.getInstance()
.processEvent(
new GenericEvent(
this,
getRequestName(),
GenericEvent.BEFORE_COMMIT,
(JAIOUserSessionParameters) userSessionPars,
request,
response,
userSession,
context,
conn,
inputPar,
answer));
conn.commit();
// fires the GenericEvent.AFTER_COMMIT event...
EventsManager.getInstance()
.processEvent(
new GenericEvent(
this,
getRequestName(),
GenericEvent.AFTER_COMMIT,
(JAIOUserSessionParameters) userSessionPars,
request,
response,
userSession,
context,
conn,
inputPar,
answer));
return answer;
} catch (Throwable ex) {
Logger.error(
userSessionPars.getUsername(),
this.getClass().getName(),
"executeCommand",
"Error while inserting hierarchy item discounts",
ex);
try {
conn.rollback();
} catch (Exception ex3) {
}
return new ErrorResponse(ex.getMessage());
} finally {
try {
stmt.close();
} catch (Exception ex2) {
}
try {
ConnectionManager.releaseConnection(conn, context);
} catch (Exception ex1) {
}
}
}
/**
* Gets number of the FtPerson property <b>person</b>.
*
* @return int
*/
public int sizePerson() {
return (person_.size());
}
/**
* Gets child RNodes.
*
* @return IRNode[]
*/
public IRNode[] getRNodes() {
java.util.List classNodes = new java.util.ArrayList();
IRNode[] nodes = new IRNode[classNodes.size()];
return ((IRNode[]) classNodes.toArray(nodes));
}
/**
* Gets the IFtContentMixMixed property <b>content</b>.
*
* @return IFtContentMixMixed[]
*/
public IFtContentMixMixed[] getContent() {
IFtContentMixMixed[] array = new IFtContentMixMixed[content_.size()];
return ((IFtContentMixMixed[]) content_.toArray(array));
}
/** Business logic to execute. */
public final Response executeCommand(
Object inputPar,
UserSessionParameters userSessionPars,
HttpServletRequest request,
HttpServletResponse response,
HttpSession userSession,
ServletContext context) {
Connection conn = null;
PreparedStatement pstmt = null;
try {
conn = ConnectionManager.getConnection(context);
// fires the GenericEvent.CONNECTION_CREATED event...
EventsManager.getInstance()
.processEvent(
new GenericEvent(
this,
getRequestName(),
GenericEvent.CONNECTION_CREATED,
(JAIOUserSessionParameters) userSessionPars,
request,
response,
userSession,
context,
conn,
inputPar,
null));
Response responseVO =
bean.insertItem(
conn,
(JournalHeaderVO) inputPar,
userSessionPars,
request,
response,
userSession,
context);
if (responseVO.isError()) {
conn.rollback();
return responseVO;
}
if (inputPar instanceof JournalHeaderWithVatVO) {
JournalHeaderWithVatVO vo = (JournalHeaderWithVatVO) inputPar;
// insert vat rows in the specified vat register...
Response regRes =
vatRegisterAction.insertVatRows(
conn, vo.getVats(), userSessionPars, request, response, userSession, context);
if (regRes.isError()) {
conn.rollback();
return regRes;
}
// retrieve payment instalments...
Response payRes =
payAction.executeCommand(
new LookupValidationParams(vo.getPaymentCodeREG10(), new HashMap()),
userSessionPars,
request,
response,
userSession,
context);
if (payRes.isError()) {
conn.rollback();
return payRes;
}
PaymentVO payVO = (PaymentVO) ((VOListResponse) payRes).getRows().get(0);
GridParams gridParams = new GridParams();
gridParams
.getOtherGridParams()
.put(ApplicationConsts.PAYMENT_CODE_REG10, vo.getPaymentCodeREG10());
payRes =
paysAction.executeCommand(
gridParams, userSessionPars, request, response, userSession, context);
if (payRes.isError()) {
conn.rollback();
return payRes;
}
java.util.List rows = ((VOListResponse) payRes).getRows();
// create expirations in DOC19 ONLY if:
// - there are more than one instalment OR
// - there is only one instalment and this instalment has more than 0 instalment days
if (rows.size() > 1
|| (rows.size() == 1
&& ((PaymentInstalmentVO) rows.get(0)).getInstalmentDaysREG17().intValue() > 0)) {
// retrieve internationalization settings (Resources object)...
ServerResourcesFactory factory =
(ServerResourcesFactory) context.getAttribute(Controller.RESOURCES_FACTORY);
Resources resources = factory.getResources(userSessionPars.getLanguageId());
PaymentInstalmentVO inVO = null;
pstmt =
conn.prepareStatement(
"insert into DOC19_EXPIRATIONS(COMPANY_CODE_SYS01,DOC_TYPE,DOC_YEAR,DOC_NUMBER,DOC_SEQUENCE,PROGRESSIVE,DOC_DATE,EXPIRATION_DATE,NAME_1,NAME_2,VALUE,PAYED,DESCRIPTION,CUSTOMER_SUPPLIER_CODE,PROGRESSIVE_REG04,CURRENCY_CODE_REG03) values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)");
long startTime = vo.getItemDateACC05().getTime(); // item date...
if (payVO.getStartDayREG10().equals(ApplicationConsts.START_DAY_END_MONTH)) {
Calendar cal = Calendar.getInstance();
if (cal.get(cal.MONTH) == 10
|| cal.get(cal.MONTH) == 3
|| cal.get(cal.MONTH) == 5
|| cal.get(cal.MONTH) == 8) cal.set(cal.DAY_OF_MONTH, 30);
else if (cal.get(cal.MONTH) == 1) {
if (cal.get(cal.YEAR) % 4 == 0) cal.set(cal.DAY_OF_MONTH, 29);
else cal.set(cal.DAY_OF_MONTH, 28);
} else cal.set(cal.DAY_OF_MONTH, 31);
startTime = cal.getTime().getTime();
}
BigDecimal amount = null;
for (int i = 0; i < rows.size(); i++) {
inVO = (PaymentInstalmentVO) rows.get(i);
pstmt.setString(1, vo.getCompanyCodeSys01ACC05());
pstmt.setString(2, vo.getDocTypeDOC19());
pstmt.setBigDecimal(3, vo.getItemYearACC05());
pstmt.setBigDecimal(4, null);
pstmt.setBigDecimal(5, vo.getDocSequenceDOC19());
pstmt.setBigDecimal(
6,
ProgressiveUtils.getConsecutiveProgressive(
"DOC19_EXPIRATIONS", "PROGRESSIVE", conn));
pstmt.setDate(7, vo.getItemDateACC05());
pstmt.setDate(
8,
new java.sql.Date(
startTime
+ inVO.getInstalmentDaysREG17().longValue()
* 86400
* 1000)); // expiration date
pstmt.setString(9, vo.getName_1REG04());
pstmt.setString(10, vo.getName_2REG04());
amount =
vo.getTotalValue()
.multiply(inVO.getPercentageREG17())
.divide(new BigDecimal(100), BigDecimal.ROUND_HALF_UP)
.setScale(vo.getTotalValue().scale(), BigDecimal.ROUND_HALF_UP); // value
pstmt.setBigDecimal(11, amount);
pstmt.setString(12, "N");
if (vo.getDocTypeDOC19().equals(ApplicationConsts.SALE_GENERIC_INVOICE))
pstmt.setString(
13,
resources.getResource("sale generic document")
+ " "
+ vo.getDocSequenceDOC19()
+ "/"
+ vo.getItemYearACC05()
+ " - "
+ resources.getResource("valueREG01")
+ " "
+ resources.getResource("rateNumberREG17")
+ " "
+ (i + 1)
+ " - "
+ inVO.getPaymentTypeDescriptionSYS10()); // description
else
pstmt.setString(
13,
resources.getResource("purchase generic document")
+ " "
+ vo.getDocSequenceDOC19()
+ "/"
+ vo.getItemYearACC05()
+ " - "
+ resources.getResource("valueREG01")
+ " "
+ resources.getResource("rateNumberREG17")
+ " "
+ (i + 1)
+ " - "
+ inVO.getPaymentTypeDescriptionSYS10()); // description
pstmt.setString(14, vo.getCustomerCodeSAL07());
pstmt.setBigDecimal(15, vo.getProgressiveREG04());
pstmt.setString(16, vo.getCurrencyCodeREG01());
pstmt.execute();
}
pstmt.close();
}
// create an item registration for proceeds, according to expiration settings (e.g. retail
// selling):
// there must be only one instalment and this instalment has 0 instalment days
if (rows.size() == 1
&& ((PaymentInstalmentVO) rows.get(0)).getInstalmentDaysREG17().intValue() == 0) {
// retrieve internationalization settings (Resources object)...
ServerResourcesFactory factory =
(ServerResourcesFactory) context.getAttribute(Controller.RESOURCES_FACTORY);
Resources resources = factory.getResources(userSessionPars.getLanguageId());
HashMap map = new HashMap();
map.put(ApplicationConsts.COMPANY_CODE_SYS01, vo.getCompanyCodeSys01ACC05());
map.put(ApplicationConsts.PARAM_CODE, ApplicationConsts.CASE_ACCOUNT);
Response res =
userParamAction.executeCommand(
map, userSessionPars, request, response, userSession, context);
if (res.isError()) {
conn.rollback();
return res;
}
String caseAccountCode = ((VOResponse) res).getVo().toString();
JournalHeaderVO jhVO = new JournalHeaderVO();
jhVO.setCompanyCodeSys01ACC05(vo.getCompanyCodeSys01ACC05());
if (vo.getDocTypeDOC19().equals(ApplicationConsts.SALE_GENERIC_INVOICE)) {
jhVO.setDescriptionACC05(
resources.getResource("sale generic document")
+ " "
+ vo.getDocSequenceDOC19()
+ "/"
+ vo.getItemYearACC05()
+ " - "
+ resources.getResource("customer")
+ " "
+ vo.getName_1REG04()
+ " "
+ (vo.getName_2REG04() == null ? "" : vo.getName_2REG04()));
jhVO.setAccountingMotiveCodeAcc03ACC05(ApplicationConsts.MOTIVE_INVOICE_PROCEEDS);
} else {
jhVO.setDescriptionACC05(
resources.getResource("purchase generic document")
+ " "
+ vo.getDocSequenceDOC19()
+ "/"
+ vo.getItemYearACC05()
+ " - "
+ resources.getResource("supplier")
+ " "
+ vo.getName_1REG04()
+ " "
+ (vo.getName_2REG04() == null ? "" : vo.getName_2REG04()));
jhVO.setAccountingMotiveCodeAcc03ACC05(ApplicationConsts.MOTIVE_PURCHASE_INVOICE_PAYED);
}
jhVO.setItemDateACC05(new java.sql.Date(System.currentTimeMillis()));
jhVO.setItemYearACC05(new BigDecimal(Calendar.getInstance().get(Calendar.YEAR)));
JournalRowVO jrVO = new JournalRowVO();
jrVO.setCompanyCodeSys01ACC06(jhVO.getCompanyCodeSys01ACC05());
if (vo.getDocTypeDOC19().equals(ApplicationConsts.SALE_GENERIC_INVOICE)) {
jrVO.setAccountCodeAcc02ACC06(vo.getCreditAccountCodeAcc02SAL07());
jrVO.setAccountCodeACC06(vo.getCustomerCodeSAL07());
jrVO.setAccountCodeTypeACC06(ApplicationConsts.ACCOUNT_TYPE_CUSTOMER);
jrVO.setCreditAmountACC06(vo.getTotalValue());
} else {
jrVO.setAccountCodeAcc02ACC06(vo.getDebitAccountCodeAcc02PUR01());
jrVO.setAccountCodeACC06(vo.getSupplierCodePUR01());
jrVO.setAccountCodeTypeACC06(ApplicationConsts.ACCOUNT_TYPE_SUPPLIER);
jrVO.setDebitAmountACC06(vo.getTotalValue());
}
jrVO.setDescriptionACC06("");
jrVO.setItemYearAcc05ACC06(jhVO.getItemYearACC05());
jrVO.setProgressiveAcc05ACC06(jhVO.getProgressiveACC05());
jhVO.addJournalRow(jrVO);
jrVO = new JournalRowVO();
jrVO.setCompanyCodeSys01ACC06(jhVO.getCompanyCodeSys01ACC05());
jrVO.setAccountCodeAcc02ACC06(caseAccountCode);
jrVO.setAccountCodeACC06(caseAccountCode);
jrVO.setAccountCodeTypeACC06(ApplicationConsts.ACCOUNT_TYPE_ACCOUNT);
if (vo.getDocTypeDOC19().equals(ApplicationConsts.SALE_GENERIC_INVOICE)) {
jrVO.setDebitAmountACC06(vo.getTotalValue());
} else {
jrVO.setCreditAmountACC06(vo.getTotalValue());
}
jrVO.setDescriptionACC06("");
jrVO.setItemYearAcc05ACC06(jhVO.getItemYearACC05());
jrVO.setProgressiveAcc05ACC06(jhVO.getProgressiveACC05());
jhVO.addJournalRow(jrVO);
Response proceedsRes =
bean.insertItem(conn, jhVO, userSessionPars, request, response, userSession, context);
if (proceedsRes.isError()) {
conn.rollback();
return proceedsRes;
}
}
}
Response answer = responseVO;
// fires the GenericEvent.BEFORE_COMMIT event...
EventsManager.getInstance()
.processEvent(
new GenericEvent(
this,
getRequestName(),
GenericEvent.BEFORE_COMMIT,
(JAIOUserSessionParameters) userSessionPars,
request,
response,
userSession,
context,
conn,
inputPar,
answer));
conn.commit();
// fires the GenericEvent.AFTER_COMMIT event...
EventsManager.getInstance()
.processEvent(
new GenericEvent(
this,
getRequestName(),
GenericEvent.AFTER_COMMIT,
(JAIOUserSessionParameters) userSessionPars,
request,
response,
userSession,
context,
conn,
inputPar,
answer));
return answer;
} catch (Throwable ex) {
Logger.error(
userSessionPars.getUsername(),
this.getClass().getName(),
"executeCommand",
"Error while inserting a new item in the journal",
ex);
try {
conn.rollback();
} catch (Exception ex3) {
}
return new ErrorResponse(ex.getMessage());
} finally {
try {
pstmt.close();
} catch (Exception ex2) {
}
try {
ConnectionManager.releaseConnection(conn, context);
} catch (Exception ex1) {
}
}
}
/**
* Gets number of the FtNotice property <b>notice</b>.
*
* @return int
*/
public int sizeNotice() {
return (notice_.size());
}
/**
* Gets the FtNotice property <b>notice</b>.
*
* @return FtNotice[]
*/
public FtNotice[] getNotice() {
FtNotice[] array = new FtNotice[notice_.size()];
return ((FtNotice[]) notice_.toArray(array));
}
/** Business logic to execute. */
public VOListResponse loadOutDeliveryNotesForSaleDoc(
GridParams pars, String serverLanguageId, String username, ArrayList companiesList)
throws Throwable {
PreparedStatement pstmt = null;
Connection conn = null;
try {
if (this.conn == null) conn = getConn();
else conn = this.conn;
// retrieve companies list...
String companies = "";
for (int i = 0; i < companiesList.size(); i++)
companies += "'" + companiesList.get(i).toString() + "',";
companies = companies.substring(0, companies.length() - 1);
String sql =
"select DOC08_DELIVERY_NOTES.COMPANY_CODE_SYS01,DOC08_DELIVERY_NOTES.DOC_TYPE,"
+ "DOC08_DELIVERY_NOTES.DOC_YEAR,DOC08_DELIVERY_NOTES.DOC_NUMBER,DOC08_DELIVERY_NOTES.DOC_DATE, "
+ "DOC08_DELIVERY_NOTES.DESTINATION_CODE_REG18,DOC08_DELIVERY_NOTES.DESCRIPTION,"
+ "DOC08_DELIVERY_NOTES.DOC_SEQUENCE "
+ " from DOC08_DELIVERY_NOTES where "
+ "DOC08_DELIVERY_NOTES.COMPANY_CODE_SYS01 in ("
+ companies
+ ") and "
+ "DOC08_DELIVERY_NOTES.ENABLED='Y' and "
+ "DOC08_DELIVERY_NOTES.DOC_TYPE=? and "
+ "DOC08_DELIVERY_NOTES.DOC_STATE=? and "
+ "(DOC08_DELIVERY_NOTES.COMPANY_CODE_SYS01,DOC08_DELIVERY_NOTES.DOC_TYPE,DOC08_DELIVERY_NOTES.DOC_YEAR,DOC08_DELIVERY_NOTES.DOC_NUMBER) "
+ " in (select DOC10_OUT_DELIVERY_NOTE_ITEMS.COMPANY_CODE_SYS01,DOC10_OUT_DELIVERY_NOTE_ITEMS.DOC_TYPE,DOC10_OUT_DELIVERY_NOTE_ITEMS.DOC_YEAR,DOC10_OUT_DELIVERY_NOTE_ITEMS.DOC_NUMBER "
+ " from DOC10_OUT_DELIVERY_NOTE_ITEMS where "
+ " DOC10_OUT_DELIVERY_NOTE_ITEMS.COMPANY_CODE_SYS01=? and "
+ " DOC10_OUT_DELIVERY_NOTE_ITEMS.DOC_TYPE_DOC01=? and "
+ " DOC10_OUT_DELIVERY_NOTE_ITEMS.DOC_YEAR_DOC01=? and "
+ " DOC10_OUT_DELIVERY_NOTE_ITEMS.DOC_NUMBER_DOC01=? ";
DetailSaleDocVO docVO =
(DetailSaleDocVO)
pars.getOtherGridParams().get(ApplicationConsts.SALE_DOC_VO); // invoice document...
if (docVO.getDocNumberDOC01() == null)
sql +=
" and DOC10_OUT_DELIVERY_NOTE_ITEMS.QTY-DOC10_OUT_DELIVERY_NOTE_ITEMS.INVOICE_QTY>0)";
else sql += ")";
Map attribute2dbField = new HashMap();
attribute2dbField.put("companyCodeSys01DOC08", "DOC08_DELIVERY_NOTES.COMPANY_CODE_SYS01");
attribute2dbField.put("docTypeDOC08", "DOC08_DELIVERY_NOTES.DOC_TYPE");
attribute2dbField.put("docYearDOC08", "DOC08_DELIVERY_NOTES.DOC_YEAR");
attribute2dbField.put("docNumberDOC08", "DOC08_DELIVERY_NOTES.DOC_NUMBER");
attribute2dbField.put("docDateDOC08", "DOC08_DELIVERY_NOTES.DOC_DATE");
attribute2dbField.put(
"destinationCodeReg18DOC08", "DOC08_DELIVERY_NOTES.DESTINATION_CODE_REG18");
attribute2dbField.put("descriptionDOC08", "DOC08_DELIVERY_NOTES.DESCRIPTION");
attribute2dbField.put("docSequenceDOC08", "DOC08_DELIVERY_NOTES.DOC_SEQUENCE");
ArrayList values = new ArrayList();
values.add(ApplicationConsts.OUT_DELIVERY_NOTE_DOC_TYPE);
values.add(ApplicationConsts.CLOSED);
values.add(docVO.getCompanyCodeSys01DOC01());
values.add(docVO.getDocTypeDoc01DOC01());
values.add(docVO.getDocYearDoc01DOC01());
values.add(docVO.getDocNumberDoc01DOC01());
// read from DOC08 table...
Response res =
QueryUtil.getQuery(
conn,
new UserSessionParameters(username),
sql,
values,
attribute2dbField,
OutDeliveryNotesVO.class,
"Y",
"N",
null,
pars,
true);
if (res.isError()) throw new Exception(res.getErrorMessage());
// check if the invoice document has been already created and there exists delivery notes
// linked to it...
if (docVO.getDocNumberDOC01() != null) {
pstmt =
conn.prepareStatement(
"select DOC08_DELIVERY_NOTES.DOC_NUMBER from DOC08_DELIVERY_NOTES where "
+ "DOC08_DELIVERY_NOTES.COMPANY_CODE_SYS01 in ("
+ companies
+ ") and "
+ "DOC08_DELIVERY_NOTES.ENABLED='Y' and "
+ "DOC08_DELIVERY_NOTES.DOC_TYPE=? and "
+ "DOC08_DELIVERY_NOTES.DOC_STATE=? and "
+ "(DOC08_DELIVERY_NOTES.COMPANY_CODE_SYS01,DOC08_DELIVERY_NOTES.DOC_TYPE,DOC08_DELIVERY_NOTES.DOC_YEAR,DOC08_DELIVERY_NOTES.DOC_NUMBER) "
+ " in (select DOC10_OUT_DELIVERY_NOTE_ITEMS.COMPANY_CODE_SYS01,DOC10_OUT_DELIVERY_NOTE_ITEMS.DOC_TYPE,DOC10_OUT_DELIVERY_NOTE_ITEMS.DOC_YEAR,DOC10_OUT_DELIVERY_NOTE_ITEMS.DOC_NUMBER "
+ " from DOC10_OUT_DELIVERY_NOTE_ITEMS,DOC02_SELLING_ITEMS where "
+ " DOC10_OUT_DELIVERY_NOTE_ITEMS.COMPANY_CODE_SYS01=? and "
+ " DOC10_OUT_DELIVERY_NOTE_ITEMS.DOC_TYPE_DOC01=? and "
+ " DOC10_OUT_DELIVERY_NOTE_ITEMS.DOC_YEAR_DOC01=? and "
+ " DOC10_OUT_DELIVERY_NOTE_ITEMS.DOC_NUMBER_DOC01=? and "
+ " DOC10_OUT_DELIVERY_NOTE_ITEMS.COMPANY_CODE_SYS01=DOC02_SELLING_ITEMS.COMPANY_CODE_SYS01 and "
+ " DOC02_SELLING_ITEMS.DOC_TYPE=? and "
+ " DOC02_SELLING_ITEMS.DOC_YEAR=? and "
+ " DOC02_SELLING_ITEMS.DOC_NUMBER=? and "
+ " DOC10_OUT_DELIVERY_NOTE_ITEMS.ITEM_CODE_ITM01=DOC02_SELLING_ITEMS.ITEM_CODE_ITM01)");
pstmt.setString(1, ApplicationConsts.OUT_DELIVERY_NOTE_DOC_TYPE);
pstmt.setString(2, ApplicationConsts.CLOSED);
pstmt.setString(3, docVO.getCompanyCodeSys01DOC01());
pstmt.setString(4, docVO.getDocTypeDoc01DOC01());
pstmt.setBigDecimal(5, docVO.getDocYearDoc01DOC01());
pstmt.setBigDecimal(6, docVO.getDocNumberDoc01DOC01());
pstmt.setString(7, docVO.getDocTypeDOC01());
pstmt.setBigDecimal(8, docVO.getDocYearDOC01());
pstmt.setBigDecimal(9, docVO.getDocNumberDOC01());
HashSet docNumberDOC08s = new HashSet();
ResultSet rset = pstmt.executeQuery();
while (rset.next()) docNumberDOC08s.add(rset.getBigDecimal(1));
rset.close();
java.util.List rows = ((VOListResponse) res).getRows();
OutDeliveryNotesVO vo = null;
for (int i = 0; i < rows.size(); i++) {
vo = (OutDeliveryNotesVO) rows.get(i);
if (docNumberDOC08s.contains(vo.getDocNumberDOC08())) vo.setSelected(Boolean.TRUE);
}
}
Response answer = res;
if (answer.isError()) throw new Exception(answer.getErrorMessage());
else return (VOListResponse) answer;
} catch (Throwable ex) {
Logger.error(
username,
this.getClass().getName(),
"executeCommand",
"Error while fetching out delivery notes list, related to the specified sale document",
ex);
throw new Exception(ex.getMessage());
} finally {
try {
pstmt.close();
} catch (Exception exx) {
}
try {
if (this.conn == null && conn != null) {
// close only local connection
conn.commit();
conn.close();
}
} catch (Exception exx) {
}
}
}
/** Business logic to execute. */
public VOListResponse loadItemVariants(GridParams pars, String serverLanguageId, String username)
throws Throwable {
PreparedStatement pstmt = null;
Connection conn = null;
try {
if (this.conn == null) conn = getConn();
else conn = this.conn;
String tableName = (String) pars.getOtherGridParams().get(ApplicationConsts.TABLE_NAME);
ItemPK pk = (ItemPK) pars.getOtherGridParams().get(ApplicationConsts.ITEM_PK);
String productVariant = (String) productVariants.get(tableName);
String variantType = (String) variantTypes.get(tableName);
String variantTypeJoin = (String) variantTypeJoins.get(tableName);
String variantCodeJoin = (String) variantCodeJoins.get(tableName);
String sql =
"select "
+ tableName
+ "."
+ variantTypeJoin
+ ","
+ tableName
+ ".VARIANT_CODE,A.DESCRIPTION,B.DESCRIPTION, "
+ tableName
+ ".PROGRESSIVE_SYS10,"
+ variantType
+ ".PROGRESSIVE_SYS10 "
+ "from "
+ tableName
+ ","
+ variantType
+ ",SYS10_COMPANY_TRANSLATIONS A,SYS10_COMPANY_TRANSLATIONS B "
+ "where "
+ tableName
+ ".COMPANY_CODE_SYS01=? and "
+ tableName
+ ".COMPANY_CODE_SYS01="
+ variantType
+ ".COMPANY_CODE_SYS01 and "
+ tableName
+ "."
+ variantTypeJoin
+ "="
+ variantType
+ ".VARIANT_TYPE and "
+ tableName
+ ".COMPANY_CODE_SYS01=A.COMPANY_CODE_SYS01 and "
+ tableName
+ ".PROGRESSIVE_SYS10=A.PROGRESSIVE and A.LANGUAGE_CODE=? and "
+ variantType
+ ".COMPANY_CODE_SYS01=B.COMPANY_CODE_SYS01 and "
+ variantType
+ ".PROGRESSIVE_SYS10=B.PROGRESSIVE and B.LANGUAGE_CODE=? and "
+ tableName
+ ".ENABLED='Y' and "
+ variantType
+ ".ENABLED='Y' and "
+ // and not "+tableName+"."+variantTypeJoin+"=? and "+
"not "
+ tableName
+ ".VARIANT_CODE=? "
+ "order by "
+ tableName
+ "."
+ variantTypeJoin
+ ","
+ tableName
+ ".CODE_ORDER";
Map attribute2dbField = new HashMap();
attribute2dbField.put("variantType", tableName + "." + variantTypeJoin);
attribute2dbField.put("variantCode", tableName + ".VARIANT_CODE");
attribute2dbField.put("variantDesc", "A.DESCRIPTION");
attribute2dbField.put("variantTypeDesc", "B.DESCRIPTION");
attribute2dbField.put("variantProgressiveSys10", tableName + ".PROGRESSIVE_SYS10");
attribute2dbField.put("variantTypeProgressiveSys10", variantType + ".PROGRESSIVE_SYS10");
ArrayList values = new ArrayList();
values.add(pk.getCompanyCodeSys01ITM01());
values.add(serverLanguageId);
values.add(serverLanguageId);
// values.add(ApplicationConsts.JOLLY);
values.add(ApplicationConsts.JOLLY);
// read from ITMxxx table...
Response answer =
QueryUtil.getQuery(
conn,
new UserSessionParameters(username),
sql,
values,
attribute2dbField,
ItemVariantVO.class,
"Y",
"N",
null,
pars,
50,
true);
if (!answer.isError()) {
java.util.List vos = ((VOListResponse) answer).getRows();
HashMap map = new HashMap();
ItemVariantVO vo = null;
for (int i = 0; i < vos.size(); i++) {
vo = (ItemVariantVO) vos.get(i);
vo.setCompanyCodeSys01(pk.getCompanyCodeSys01ITM01());
vo.setItemCodeItm01(pk.getItemCodeITM01());
vo.setTableName(tableName);
map.put(vo.getVariantType() + "." + vo.getVariantCode(), vo);
}
pstmt =
conn.prepareStatement(
"select "
+ productVariant
+ "."
+ variantTypeJoin
+ ","
+ productVariant
+ "."
+ variantCodeJoin
+ " "
+ "from "
+ productVariant
+ " "
+ "where "
+ productVariant
+ ".COMPANY_CODE_SYS01=? and "
+ productVariant
+ ".ITEM_CODE_ITM01=? and "
+ productVariant
+ ".ENABLED='Y' ");
pstmt.setString(1, pk.getCompanyCodeSys01ITM01());
pstmt.setString(2, pk.getItemCodeITM01());
ResultSet rset = pstmt.executeQuery();
while (rset.next()) {
vo = (ItemVariantVO) map.get(rset.getString(1) + "." + rset.getString(2));
if (vo != null) vo.setSelected(Boolean.TRUE);
}
rset.close();
pstmt.close();
}
if (answer.isError()) throw new Exception(answer.getErrorMessage());
else return (VOListResponse) answer;
} catch (Throwable ex) {
Logger.error(
username,
this.getClass().getName(),
"getItemVariants",
"Error while fetching item variants list",
ex);
throw new Exception(ex.getMessage());
} finally {
try {
pstmt.close();
} catch (Exception ex2) {
}
try {
if (this.conn == null && conn != null) {
// close only local connection
conn.commit();
conn.close();
}
} catch (Exception exx) {
}
}
}
/** Business logic to execute. */
public final Response executeCommand(
Object inputPar,
UserSessionParameters userSessionPars,
HttpServletRequest request,
HttpServletResponse response,
HttpSession userSession,
ServletContext context) {
String serverLanguageId = ((JAIOUserSessionParameters) userSessionPars).getServerLanguageId();
Connection conn = null;
PreparedStatement pstmt = null;
try {
conn = ConnectionManager.getConnection(context);
// fires the GenericEvent.CONNECTION_CREATED event...
EventsManager.getInstance()
.processEvent(
new GenericEvent(
this,
getRequestName(),
GenericEvent.CONNECTION_CREATED,
(JAIOUserSessionParameters) userSessionPars,
request,
response,
userSession,
context,
conn,
inputPar,
null));
DetailSaleDocVO docVO = (DetailSaleDocVO) inputPar;
// retrieve internationalization settings (Resources object)...
ServerResourcesFactory factory =
(ServerResourcesFactory) context.getAttribute(Controller.RESOURCES_FACTORY);
Resources resources = factory.getResources(userSessionPars.getLanguageId());
// insert header...
docVO.setDocStateDOC01(ApplicationConsts.HEADER_BLOCKED);
Response res =
insDocBean.insertSaleDoc(
conn, docVO, userSessionPars, request, response, userSession, context);
if (res.isError()) {
conn.rollback();
return res;
}
SaleDocPK refPK =
new SaleDocPK(
docVO.getCompanyCodeSys01Doc01DOC01(),
docVO.getDocTypeDoc01DOC01(),
docVO.getDocYearDoc01DOC01(),
docVO.getDocNumberDoc01DOC01());
// retrieve ref. document item rows...
GridParams gridParams = new GridParams();
gridParams.getOtherGridParams().put(ApplicationConsts.SALE_DOC_PK, refPK);
res =
rowsAction.executeCommand(
gridParams, userSessionPars, request, response, userSession, context);
if (res.isError()) {
conn.rollback();
return res;
}
java.util.List rows = ((VOListResponse) res).getRows();
// create rows..
GridSaleDocRowVO gridRowVO = null;
DetailSaleDocRowVO rowVO = null;
java.util.List discRows = null;
SaleDocRowPK docRowPK = null;
SaleItemDiscountVO itemDiscVO = null;
gridParams = new GridParams();
for (int i = 0; i < rows.size(); i++) {
gridRowVO = (GridSaleDocRowVO) rows.get(i);
// retrieve row detail...
docRowPK =
new SaleDocRowPK(
gridRowVO.getCompanyCodeSys01DOC02(),
gridRowVO.getDocTypeDOC02(),
gridRowVO.getDocYearDOC02(),
gridRowVO.getDocNumberDOC02(),
gridRowVO.getItemCodeItm01DOC02(),
gridRowVO.getVariantTypeItm06DOC02(),
gridRowVO.getVariantCodeItm11DOC02(),
gridRowVO.getVariantTypeItm07DOC02(),
gridRowVO.getVariantCodeItm12DOC02(),
gridRowVO.getVariantTypeItm08DOC02(),
gridRowVO.getVariantCodeItm13DOC02(),
gridRowVO.getVariantTypeItm09DOC02(),
gridRowVO.getVariantCodeItm14DOC02(),
gridRowVO.getVariantTypeItm10DOC02(),
gridRowVO.getVariantCodeItm15DOC02());
res =
rowAction.executeCommand(
docRowPK, userSessionPars, request, response, userSession, context);
if (res.isError()) {
conn.rollback();
return res;
}
rowVO = (DetailSaleDocRowVO) ((VOResponse) res).getVo();
rowVO.setDocTypeDOC02(docVO.getDocTypeDOC01());
rowVO.setDocNumberDOC02(docVO.getDocNumberDOC01());
if (rowVO.getInvoiceQtyDOC02().doubleValue() < rowVO.getQtyDOC02().doubleValue()
&& rowVO.getQtyDOC02().doubleValue() == rowVO.getOutQtyDOC02().doubleValue()) {
rowVO.setQtyDOC02(
rowVO
.getQtyDOC02()
.subtract(
rowVO
.getInvoiceQtyDOC02()
.setScale(
rowVO.getDecimalsReg02DOC02().intValue(), BigDecimal.ROUND_HALF_UP)));
rowVO.setTaxableIncomeDOC02(
rowVO
.getQtyDOC02()
.multiply(rowVO.getValueSal02DOC02())
.setScale(docVO.getDecimalsREG03().intValue(), BigDecimal.ROUND_HALF_UP));
rowVO.setTotalDiscountDOC02(new BigDecimal(0));
// calculate row vat...
double vatPerc =
rowVO.getValueReg01DOC02().doubleValue()
* (1d - rowVO.getDeductibleReg01DOC02().doubleValue() / 100d)
/ 100;
rowVO.setVatValueDOC02(
rowVO
.getTaxableIncomeDOC02()
.multiply(new BigDecimal(vatPerc))
.setScale(docVO.getDecimalsREG03().intValue(), BigDecimal.ROUND_HALF_UP));
// calculate row total...
rowVO.setValueDOC02(rowVO.getTaxableIncomeDOC02().add(rowVO.getVatValueDOC02()));
res =
insRowBean.insertSaleItem(
conn, rowVO, userSessionPars, request, response, userSession, context);
if (res.isError()) {
conn.rollback();
return res;
}
// create item discounts...
gridParams.getOtherGridParams().put(ApplicationConsts.SALE_DOC_ROW_PK, docRowPK);
res =
itemDiscAction.executeCommand(
gridParams, userSessionPars, request, response, userSession, context);
if (res.isError()) {
conn.rollback();
return res;
}
discRows = ((VOListResponse) res).getRows();
for (int j = 0; j < discRows.size(); j++) {
itemDiscVO = (SaleItemDiscountVO) discRows.get(j);
itemDiscVO.setDocTypeDOC04(docVO.getDocTypeDOC01());
itemDiscVO.setDocNumberDOC04(docVO.getDocNumberDOC01());
res =
insItemDiscBean.insertSaleDocRowDiscount(
conn, itemDiscVO, userSessionPars, request, response, userSession, context);
if (res.isError()) {
conn.rollback();
return res;
}
}
}
}
// create charges...
gridParams = new GridParams();
gridParams.getOtherGridParams().put(ApplicationConsts.SALE_DOC_PK, refPK);
res =
chargesAction.executeCommand(
gridParams, userSessionPars, request, response, userSession, context);
SaleDocChargeVO chargeVO = null;
if (res.isError()) {
conn.rollback();
return res;
}
rows = ((VOListResponse) res).getRows();
for (int i = 0; i < rows.size(); i++) {
chargeVO = (SaleDocChargeVO) rows.get(i);
chargeVO.setDocTypeDOC03(docVO.getDocTypeDOC01());
chargeVO.setDocNumberDOC03(docVO.getDocNumberDOC01());
if (chargeVO.getValueDOC03() == null
|| chargeVO.getValueDOC03() != null
&& chargeVO.getInvoicedValueDOC03().doubleValue()
< chargeVO.getValueDOC03().doubleValue()) {
if (chargeVO.getValueDOC03() != null)
chargeVO.setValueDOC03(
chargeVO
.getValueDOC03()
.subtract(chargeVO.getInvoicedValueDOC03())
.setScale(docVO.getDecimalsREG03().intValue(), BigDecimal.ROUND_HALF_UP));
res =
insChargeBean.insertSaleDocCharge(
conn, chargeVO, userSessionPars, request, response, userSession, context);
if (res.isError()) {
conn.rollback();
return res;
}
}
}
// create activities...
res =
actAction.executeCommand(
gridParams, userSessionPars, request, response, userSession, context);
if (res.isError()) {
conn.rollback();
return res;
}
SaleDocActivityVO actVO = null;
rows = ((VOListResponse) res).getRows();
for (int i = 0; i < rows.size(); i++) {
actVO = (SaleDocActivityVO) rows.get(i);
actVO.setDocTypeDOC13(docVO.getDocTypeDOC01());
actVO.setDocNumberDOC13(docVO.getDocNumberDOC01());
if (actVO.getInvoicedValueDOC13().doubleValue() < actVO.getValueDOC13().doubleValue()) {
actVO.setValueDOC13(
actVO
.getValueDOC13()
.subtract(actVO.getInvoicedValueDOC13())
.setScale(docVO.getDecimalsREG03().intValue(), BigDecimal.ROUND_HALF_UP));
res =
insActBean.insertSaleActivity(
conn, actVO, userSessionPars, request, response, userSession, context);
if (res.isError()) {
conn.rollback();
return res;
}
}
}
// create header discounts...
res =
discAction.executeCommand(
gridParams, userSessionPars, request, response, userSession, context);
if (res.isError()) {
conn.rollback();
return res;
}
SaleDocDiscountVO discVO = null;
rows = ((VOListResponse) res).getRows();
for (int i = 0; i < rows.size(); i++) {
discVO = (SaleDocDiscountVO) rows.get(i);
discVO.setDocTypeDOC05(docVO.getDocTypeDOC01());
discVO.setDocNumberDOC05(docVO.getDocNumberDOC01());
res =
insDiscBean.insertSaleDocDiscount(
conn, discVO, userSessionPars, request, response, userSession, context);
if (res.isError()) {
conn.rollback();
return res;
}
}
// recalculate all taxable incomes, vats, totals...
SaleDocPK pk =
new SaleDocPK(
docVO.getCompanyCodeSys01DOC01(),
docVO.getDocTypeDOC01(),
docVO.getDocYearDOC01(),
docVO.getDocNumberDOC01());
res =
totals.updateTaxableIncomes(
conn, pk, userSessionPars, request, response, userSession, context);
if (res.isError()) {
conn.rollback();
return res;
}
// reload doc header with updated totals...
Response answer =
docAction.loadSaleDoc(conn, pk, userSessionPars, request, response, userSession, context);
// fires the GenericEvent.BEFORE_COMMIT event...
EventsManager.getInstance()
.processEvent(
new GenericEvent(
this,
getRequestName(),
GenericEvent.BEFORE_COMMIT,
(JAIOUserSessionParameters) userSessionPars,
request,
response,
userSession,
context,
conn,
inputPar,
answer));
conn.commit();
// fires the GenericEvent.AFTER_COMMIT event...
EventsManager.getInstance()
.processEvent(
new GenericEvent(
this,
getRequestName(),
GenericEvent.AFTER_COMMIT,
(JAIOUserSessionParameters) userSessionPars,
request,
response,
userSession,
context,
conn,
inputPar,
answer));
return answer;
} catch (Throwable ex) {
Logger.error(
userSessionPars.getUsername(),
this.getClass().getName(),
"executeCommand",
"Error while creating a sale invoice from a sale document",
ex);
try {
conn.rollback();
} catch (Exception ex3) {
}
return new ErrorResponse(ex.getMessage());
} finally {
try {
pstmt.close();
} catch (Exception ex2) {
}
try {
ConnectionManager.releaseConnection(conn, context);
} catch (Exception ex1) {
}
}
}
private VirtualMachine launch(DebuggerInfo info) throws DebuggerException {
// create process & read password for local debugging
// create main class & arguments ...............................................
StringBuffer sb = new StringBuffer();
sb.append(mainClassName);
String[] infoArgs = info.getArguments();
int i, k = infoArgs.length;
for (i = 0; i < k; i++) sb.append(" \"").append(infoArgs[i]).append('"'); // NOI18N
String main = new String(sb);
// create connector ..............................................................
VirtualMachineManager vmm = Bootstrap.virtualMachineManager();
java.util.List lcs = vmm.launchingConnectors();
k = lcs.size();
for (i = 0; i < k; i++)
if (((LaunchingConnector) lcs.get(i)).name().indexOf("RawCommandLineLaunch") >= 0) // NOI18N
break;
if (i == k) {
finishDebugger();
throw new DebuggerException(
new MessageFormat(bundle.getString("EXC_Cannot_find_launcher"))
.format(
new Object[] {
"RawCommandLineLaunch" // NOI18N
}));
}
LaunchingConnector lc = (LaunchingConnector) lcs.get(i);
String transport = lc.transport().name();
// create commandLine & NbProcessDescriptor ..............................
NbProcessDescriptor debugerProcess;
if (info instanceof ProcessDebuggerInfo)
debugerProcess = ((ProcessDebuggerInfo) info).getDebuggerProcess();
else debugerProcess = ProcessDebuggerType.DEFAULT_DEBUGGER_PROCESS;
// generate password
String password;
if (transport.equals("dt_shmem")) { // NOI18N
connector = getAttachingConnectorFor("dt_shmem");
password = generatePassword();
args = connector.defaultArguments();
((Argument) args.get("name")).setValue(password);
} else {
try {
java.net.ServerSocket ss = new java.net.ServerSocket(0);
password = "" + ss.getLocalPort(); // NOI18N
ss.close();
} catch (java.io.IOException e) {
finishDebugger();
throw new DebuggerException(
new MessageFormat(bundle.getString("EXC_Cannot_find_empty_local_port"))
.format(new Object[] {e.toString()}));
}
connector = getAttachingConnectorFor("dt_socket");
args = connector.defaultArguments();
((Argument) args.get("port")).setValue(password);
}
HashMap map =
Utils.processDebuggerInfo(
info,
"-Xdebug -Xnoagent -Xrunjdwp:transport="
+ // NOI18N
transport
+ ",address="
+ // NOI18N
password
+ ",suspend=y ", // NOI18N
main);
MapFormat format = new MapFormat(map);
String commandLine =
format.format(
debugerProcess.getProcessName()
+ " "
+ // NOI18N
debugerProcess.getArguments());
println(commandLine, ERR_OUT);
/*
We mus wait on process start to connect...
try {
process = debugerProcess.exec (format);
} catch (java.io.IOException exc) {
finishDebugger ();
throw new DebuggerException (
new MessageFormat (bundle.getString ("EXC_While_create_debuggee")).
format (new Object[] {
debugerProcess.getProcessName (),
exc.toString ()
}),
exc
);
}
return connect (
null,
connector,
args
);*/
/* S ystem.out.println ("attaching: ");
Utils.showConnectors (vmm.attachingConnectors ());
S ystem.out.println ("launching: ");
Utils.showConnectors (vmm.launchingConnectors ());
S ystem.out.println ("listening: ");
Utils.showConnectors (vmm.listeningConnectors ());*/
// set debugger-start arguments
Map params = lc.defaultArguments();
((Argument) params.get("command"))
.setValue( // NOI18N
commandLine);
((Argument) params.get("address"))
.setValue( // NOI18N
password);
// launch VM
try {
return lc.launch(params);
} catch (VMStartException exc) {
showOutput(process = exc.process(), ERR_OUT, ERR_OUT);
finishDebugger();
throw new DebuggerException(
new MessageFormat(bundle.getString("EXC_While_create_debuggee"))
.format(
new Object[] {format.format(debugerProcess.getProcessName()), exc.toString()}),
exc);
} catch (Exception exc) {
finishDebugger();
throw new DebuggerException(
new MessageFormat(bundle.getString("EXC_While_create_debuggee"))
.format(
new Object[] {format.format(debugerProcess.getProcessName()), exc.toString()}),
exc);
}
}
/**
* Gets number of the IFtContentMixMixed property <b>content</b>.
*
* @return int
*/
public int sizeContent() {
return (content_.size());
}
private void refresh(int index) {
GridBagConstraints c = new GridBagConstraints();
// No connector ................
if (acs.size() == 0) {
add(new JLabel(bundle.getString("CTL_No_Connector")), c);
return;
}
// Connector switch ................
if (acs.size() > 1) {
c.insets = new Insets(0, 0, 3, 3);
add(new JLabel(bundle.getString("CTL_Connector")), c);
cbConnectors = new JComboBox();
int i, k = acs.size();
for (i = 0; i < k; i++) {
AttachingConnector ac = (AttachingConnector) acs.get(i);
int jj = ac.name().lastIndexOf('.');
String s = (jj < 0) ? ac.name() : ac.name().substring(jj + 1);
cbConnectors.addItem(s + " (" + ac.description() + ")");
}
c = new GridBagConstraints();
c.insets = new Insets(0, 3, 3, 0);
c.weightx = 1.0;
c.fill = java.awt.GridBagConstraints.HORIZONTAL;
c.gridwidth = 0;
cbConnectors.setSelectedIndex(index);
cbConnectors.setActionCommand("SwitchMe!");
cbConnectors.addActionListener(this);
add(cbConnectors, c);
}
ac = (AttachingConnector) acs.get(index);
// Transport ................
c = new GridBagConstraints();
c.insets = new Insets(3, 0, 0, 3);
add(new JLabel(bundle.getString("CTL_Transport")), c);
JTextField tfTransport = new JTextField(ac.transport().name());
tfTransport.setEnabled(false);
c = new GridBagConstraints();
c.gridwidth = 0;
c.insets = new Insets(3, 3, 0, 0);
c.fill = java.awt.GridBagConstraints.HORIZONTAL;
c.weightx = 1.0;
add(tfTransport, c);
// Other params ................
args = ac.defaultArguments();
tfParams = new JTextField[args.size()];
Iterator it = args.keySet().iterator();
int i = 0;
while (it.hasNext()) {
String name = (String) it.next();
Argument a = (Argument) args.get(name);
c = new GridBagConstraints();
c.insets = new Insets(6, 0, 0, 3);
c.anchor = GridBagConstraints.WEST;
add(new JLabel(a.label() + ": "), c);
JTextField tfParam = new JTextField(a.value());
tfParams[i++] = tfParam;
tfParam.setName(name);
c = new GridBagConstraints();
c.gridwidth = 0;
c.insets = new Insets(6, 3, 0, 0);
c.fill = java.awt.GridBagConstraints.HORIZONTAL;
c.weightx = 1.0;
add(tfParam, c);
}
c = new GridBagConstraints();
c.weighty = 1.0;
JPanel p = new JPanel();
p.setPreferredSize(new Dimension(1, 1));
add(p, c);
}
/** Business logic to execute. */
public VOListResponse loadCharges(
GridParams gridParams,
String serverLanguageId,
String username,
ArrayList companiesList,
ArrayList customizedFields)
throws Throwable {
PreparedStatement pstmt = null;
Connection conn = null;
try {
if (this.conn == null) conn = getConn();
else conn = this.conn;
// retrieve companies list...
String companies =
(String)
gridParams
.getOtherGridParams()
.get(ApplicationConsts.COMPANY_CODE_SYS01); // used in lookup grid...
if (companies == null) {
companies = "";
for (int i = 0; i < companiesList.size(); i++)
companies += "'" + companiesList.get(i).toString() + "',";
companies = companies.substring(0, companies.length() - 1);
} else companies = "'" + companies + "'";
String sql =
"select SAL06_CHARGES.COMPANY_CODE_SYS01,SAL06_CHARGES.CHARGE_CODE,SAL06_CHARGES.PROGRESSIVE_SYS10,"
+ "SYS10_TRANSLATIONS.DESCRIPTION,SAL06_CHARGES.VALUE,SAL06_CHARGES.PERC,SAL06_CHARGES.VAT_CODE_REG01,"
+ "SAL06_CHARGES.CURRENCY_CODE_REG03,SAL06_CHARGES.ENABLED"
+ " from SAL06_CHARGES,SYS10_TRANSLATIONS where "
+ "SAL06_CHARGES.PROGRESSIVE_SYS10=SYS10_TRANSLATIONS.PROGRESSIVE and "
+ "SYS10_TRANSLATIONS.LANGUAGE_CODE=? and "
+ "SAL06_CHARGES.ENABLED='Y' and "
+ "SAL06_CHARGES.COMPANY_CODE_SYS01 in ("
+ companies
+ ")";
Map attribute2dbField = new HashMap();
attribute2dbField.put("companyCodeSys01SAL06", "SAL06_CHARGES.COMPANY_CODE_SYS01");
attribute2dbField.put("chargeCodeSAL06", "SAL06_CHARGES.CHARGE_CODE");
attribute2dbField.put("descriptionSYS10", "SYS10_TRANSLATIONS.DESCRIPTION");
attribute2dbField.put("progressiveSys10SAL06", "SAL06_CHARGES.PROGRESSIVE_SYS10");
attribute2dbField.put("valueSAL06", "SAL06_CHARGES.VALUE");
attribute2dbField.put("percSAL06", "SAL06_CHARGES.PERC");
attribute2dbField.put("vatCodeReg01SAL06", "SAL06_CHARGES.VAT_CODE_REG01");
attribute2dbField.put("currencyCodeReg03SAL06", "SAL06_CHARGES.CURRENCY_CODE_REG03");
attribute2dbField.put("enabledSAL06", "SAL06_CHARGES.ENABLED");
ArrayList values = new ArrayList();
values.add(serverLanguageId);
// read from SAL06 table...
Response res =
CustomizeQueryUtil.getQuery(
conn,
new UserSessionParameters(username),
sql,
values,
attribute2dbField,
ChargeVO.class,
"Y",
"N",
null,
gridParams,
50,
true,
customizedFields);
if (res.isError()) throw new Exception(res.getErrorMessage());
java.util.List list = ((VOListResponse) res).getRows();
ChargeVO vo = null;
sql =
"select SYS10_TRANSLATIONS.DESCRIPTION,REG01_VATS.VALUE,REG01_VATS.DEDUCTIBLE "
+ "from SYS10_TRANSLATIONS,REG01_VATS where "
+ "REG01_VATS.PROGRESSIVE_SYS10=SYS10_TRANSLATIONS.PROGRESSIVE and "
+ "SYS10_TRANSLATIONS.LANGUAGE_CODE=? and "
+ "REG01_VATS.VAT_CODE=?";
pstmt = conn.prepareStatement(sql);
ResultSet rset = null;
for (int i = 0; i < list.size(); i++) {
vo = (ChargeVO) list.get(i);
if (vo.getVatCodeReg01SAL06() != null) {
// retrieve vat data from REG01...
pstmt.setString(1, serverLanguageId);
pstmt.setString(2, vo.getVatCodeReg01SAL06());
rset = pstmt.executeQuery();
if (rset.next()) {
vo.setVatDescriptionSYS10(rset.getString(1));
vo.setVatValueREG01(rset.getBigDecimal(2));
vo.setVatDeductibleREG01(rset.getBigDecimal(3));
}
rset.close();
}
}
Response answer = res;
if (answer.isError()) throw new Exception(answer.getErrorMessage());
else return (VOListResponse) answer;
} catch (Throwable ex) {
Logger.error(
username,
this.getClass().getName(),
"executeCommand",
"Error while fetching charges list",
ex);
throw new Exception(ex.getMessage());
} finally {
try {
pstmt.close();
} catch (Exception exx) {
}
try {
if (this.conn == null && conn != null) {
// close only local connection
conn.commit();
conn.close();
}
} catch (Exception exx) {
}
}
}
/**
* Gets the FtPerson property <b>person</b>.
*
* @return FtPerson[]
*/
public FtPerson[] getPerson() {
FtPerson[] array = new FtPerson[person_.size()];
return ((FtPerson[]) person_.toArray(array));
}
