/**
* 获得公司的分部
*
* @param con
* @param company_code
* @return
* @throws SQLException
*/
private static java.util.List<JUnit> getChildBranch(Connection con, String company_code)
throws SQLException {
java.util.List<JUnit> lsBranch = new java.util.ArrayList<JUnit>();
java.sql.PreparedStatement pstmt = null;
ResultSet rs = null;
String sql = null;
sql =
"select unit_id from t_unit "
+ " where (parent_code =? or parent_code =?) and is_branch = 1 "
+ " order by unit_index ";
pstmt = con.prepareStatement(sql);
pstmt.setString(1, company_code);
pstmt.setString(2, company_code + ".LX");
rs = pstmt.executeQuery();
while (rs.next()) {
JUnit uObj = JUnit.getUnit(rs.getString("unit_id"));
lsBranch.add(uObj);
}
/*
if(lsBranch.size() == 0)
{
lsBranch.add(JUnit.getUnitByCode(company_code));
}*/
rs.close();
pstmt.close();
return lsBranch;
}
/* 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;
}
public static void format(String kq_date) throws Exception {
Connection con = null;
try {
con = com.gemway.igo.JDatabase.getPkJDatabase().getConnection();
con.setAutoCommit(false);
for (JCompany comObj : JCompany.getFlCompanyList()) {
java.util.List<Branch> lsBranch =
com.gemway.igo.fl.Branch.getBranches(comObj.getCompany_id());
for (int i = 0; lsBranch != null && i < lsBranch.size(); i++) {
format(con, kq_date, lsBranch.get(i).getBranch_id());
}
}
con.commit();
} catch (Throwable e) {
JLog.getLogger().error("自动生成日度考勤服务出错：", e);
} finally {
if (con != null) {
try {
con.rollback();
con.close();
con = null;
} catch (Exception e) {
}
}
}
}
public java.util.List<JCompany> getOA_CompanyList() {
java.util.List<JCompany> ls = new java.util.ArrayList<JCompany>();
for (String id : lsOACompany) {
ls.add(JCompany.getCompanyById(id));
}
return ls;
}
// 取业务单位
public java.util.List<JCompany> getBiz_CompanyList() throws Exception {
java.util.List<JCompany> ls = new java.util.ArrayList<JCompany>();
for (int i = 0; i < lsBizCompany.size(); i++) {
JCompany obj = JCompany.getCompanyById(lsBizCompany.get(i));
ls.add(obj);
}
return ls;
}
public java.util.List<JCompany> getEnabledCompanyList() {
java.util.List<JCompany> ls = new java.util.ArrayList<JCompany>();
for (int i = 0; i < lsCompany.size(); i++) {
JCompany obj = lsCompany.get(i);
if (!obj.enabled() || obj.getCompany_code().equals("XT_517")) continue;
ls.add(obj);
}
return ls;
}
public static void format(Connection con, String kq_date) throws Exception {
for (JCompany comObj : JCompany.getFlCompanyList()) {
java.util.List<Branch> lsBranch =
com.gemway.igo.fl.Branch.getBranches(comObj.getCompany_id());
for (int i = 0; lsBranch != null && i < lsBranch.size(); i++) {
format(con, kq_date, lsBranch.get(i).getBranch_id());
}
}
}
/**
* @param accountStub AccountStub
* @return DataStorageStub
* @throws Exception
*/
protected static DataStorageStub getDataStorageStub(AccountStub accountStub) throws Exception {
java.util.List dataStorageList =
(List) ConfigManager.getDefault().getCfgData("StorageService", null);
if (dataStorageList == null) return null;
DataStorageStub dss = null;
String dataStorageID = accountStub.getDataStorageId();
for (int i = 0; i < dataStorageList.size(); i++) {
dss = (DataStorageStub) dataStorageList.get(i);
if (dataStorageID.equals(dss.getDataStorageId())) return dss;
}
return null;
}
public static String GetPropertyString_OBDII(long dtcFault[]) {
if (ListTools.isEmpty(dtcFault)) {
return GetPropertyString_OBDII("");
} else {
java.util.List<String> dtc = new Vector<String>();
for (int i = 0; i < dtcFault.length; i++) {
if (dtcFault[i] != 0L) {
dtc.add(GetFaultString(dtcFault[i]));
}
}
return GetPropertyString_OBDII(dtc);
}
}
/* return list of all Devices within the specified DeviceGroup (NOT SCALABLE BEYOND A FEW HUNDRED GROUPS) */
public static java.util.List<String> getUsersForGroup(String acctId, String groupId)
throws DBException {
/* valid account/groupId? */
if (StringTools.isBlank(acctId)) {
return null;
} else if (StringTools.isBlank(groupId)) {
return null;
}
/* get db selector */
DBSelect dsel = GroupList._getUserListSelect(acctId, groupId);
if (dsel == null) {
return null;
}
/* read users for group */
java.util.List<String> usrList = new Vector<String>();
DBConnection dbc = null;
Statement stmt = null;
ResultSet rs = null;
try {
dbc = DBConnection.getDefaultConnection();
stmt = dbc.execute(dsel.toString());
rs = stmt.getResultSet();
while (rs.next()) {
String usrId = rs.getString(GroupList.FLD_userID);
usrList.add(usrId);
}
} catch (SQLException sqe) {
throw new DBException("Get Group GroupeList", sqe);
} finally {
if (rs != null) {
try {
rs.close();
} catch (Throwable t) {
}
}
if (stmt != null) {
try {
stmt.close();
} catch (Throwable t) {
}
}
DBConnection.release(dbc);
}
/* return list */
return usrList;
}
/**
* @param loginStub LoginStub
* @return AccountStub
* @throws Exception
*/
protected static AccountStub getAccountStub(JParamObject loginStub) throws Exception {
java.util.List accountSetList =
(List) ConfigManager.getDefault().getCfgData("AccountSet", null);
if (accountSetList == null || accountSetList.size() == 0) return null;
AccountStub accountStub = null;
for (int i = 0; i < accountSetList.size(); i++) {
accountStub = (AccountStub) accountSetList.get(i);
if (accountStub.getDataStorageId().equals(loginStub.GetValueByEnvName("DataBaseName", null))
&& accountStub.getAccountId().equals(loginStub.GetValueByEnvName("DBNO", null))) {
return accountStub;
}
}
return null;
}
public java.util.List<JCompany> getCompanyListByBiz(String biz_type) {
/*
*留学/移民/团组/外语/华文
*/
if (biz_type.equals("游学") || biz_type.equals("国交")) biz_type = "团组";
if (biz_type.equals("出入境")) biz_type = "移民";
if (biz_type.equals("培训")) biz_type = "外语";
java.util.List<JCompany> ls = new java.util.ArrayList<JCompany>();
for (int i = 0; i < lsBizCompany.size(); i++) {
JCompany obj = JCompany.getCompanyById(lsBizCompany.get(i));
if (obj.hasBiz(biz_type)) ls.add(obj);
}
return ls;
}
public void loadData(boolean forceReload) {
ICFFreeSwitchSchemaObj schemaObj = swingSchema.getSchema();
if ((containingCluster == null) || forceReload) {
CFSecurityAuthorization auth = schemaObj.getAuthorization();
long containingClusterId = auth.getSecClusterId();
containingCluster = schemaObj.getClusterTableObj().readClusterByIdIdx(containingClusterId);
}
if ((listOfTenant == null) || forceReload) {
arrayOfTenant = null;
listOfTenant =
schemaObj
.getTenantTableObj()
.readTenantByClusterIdx(containingCluster.getRequiredId(), swingIsInitializing);
if (listOfTenant != null) {
Object objArray[] = listOfTenant.toArray();
if (objArray != null) {
int len = objArray.length;
arrayOfTenant = new ICFSecurityTenantObj[len];
for (int i = 0; i < len; i++) {
arrayOfTenant[i] = (ICFSecurityTenantObj) objArray[i];
}
Arrays.sort(arrayOfTenant, compareTenantByQualName);
}
}
}
}
public void addRioxxVersionSection(List upload, Item item) throws WingException {
String version = item.getMetadata("rioxxterms.version");
if (StringUtils.isNotBlank(version) && !"NA".equals(version)) {
try {
DCInputsReader a = new DCInputsReader();
java.util.List<String> pairs = a.getPairs("rioxxterms_version");
int humanReadable = pairs.indexOf(version) - 1;
version = pairs.get(humanReadable);
} catch (DCInputsReaderException e) {
log.error(e.getMessage(), e);
}
upload
.addItem("upload-rioxx-version-warning", "upload-rioxx-version-warning")
.addContent(T_rioxx_version.parameterize(version));
}
}
public static java.util.List<String> getLsIntCourse(Connection con, String cstm_id)
throws Exception {
PreparedStatement pstmt = null;
ResultSet rs = null;
String qry = null;
java.util.List<String> lsIntCourse = new java.util.Vector<String>();
qry = " select item_id from t_fl_interest_courses where cstm_id=? ";
pstmt = con.prepareStatement(qry);
pstmt.setString(1, cstm_id);
rs = pstmt.executeQuery();
while (rs.next()) {
lsIntCourse.add(JUtil.convertNull(rs.getString("item_id")));
}
rs.close();
pstmt.close();
return lsIntCourse;
}
/**
* @param ParamObject Object
* @param DataObject Object
* @param CustomObject Object
* @param AddeitiveObject Object
* @return Object
*/
public Object InitObject(
Object ParamObject, Object DataObject, Object CustomObject, Object AddeitiveObject) {
// ��ȡ��ݿ����б�
java.util.List dblist = PackageStub.getContentVector("databases");
if (dblist == null) {
return null;
}
StubObject SO = null;
for (int i = 0; i < dblist.size(); i++) {
SO = (StubObject) dblist.get(i);
if (SO == null) {
continue;
}
JDataSourceStub DSS = new JDataSourceStub();
DSS.DataBaseType =
SO.getString("id", null); // EAI.Registry.GetElementValue(DBElement,"DataBaseType");
DSS.classname =
SO.getString("class", null); // .Registry.GetElementValue(DBElement,"classname");
DSS.dbclass =
SO.getString("dbclass", null); // EAI.Registry.GetElementValue(DBElement,"dbclass");
DBList.add(DSS);
}
return null;
}
public void loadData(boolean forceReload) {
ICFBamSchemaObj schemaObj = swingSchema.getSchema();
if ((listOfAccessFrequency == null) || forceReload) {
arrayOfAccessFrequency = null;
listOfAccessFrequency =
schemaObj.getAccessFrequencyTableObj().readAllAccessFrequency(swingIsInitializing);
if (listOfAccessFrequency != null) {
Object objArray[] = listOfAccessFrequency.toArray();
if (objArray != null) {
int len = objArray.length;
arrayOfAccessFrequency = new ICFBamAccessFrequencyObj[len];
for (int i = 0; i < len; i++) {
arrayOfAccessFrequency[i] = (ICFBamAccessFrequencyObj) objArray[i];
}
Arrays.sort(arrayOfAccessFrequency, compareAccessFrequencyByQualName);
}
}
}
}
public void loadData(boolean forceReload) {
ICFSecuritySchemaObj schemaObj = swingSchema.getSchema();
if ((listOfISOTimezone == null) || forceReload) {
arrayOfISOTimezone = null;
listOfISOTimezone =
schemaObj.getISOTimezoneTableObj().readAllISOTimezone(swingIsInitializing);
if (listOfISOTimezone != null) {
Object objArray[] = listOfISOTimezone.toArray();
if (objArray != null) {
int len = objArray.length;
arrayOfISOTimezone = new ICFSecurityISOTimezoneObj[len];
for (int i = 0; i < len; i++) {
arrayOfISOTimezone[i] = (ICFSecurityISOTimezoneObj) objArray[i];
}
Arrays.sort(arrayOfISOTimezone, compareISOTimezoneByQualName);
}
}
}
}
private static java.util.List<FLSchoolMoney> getSkList(
Connection con, String stu_id, String sk_id) throws java.sql.SQLException {
java.util.List<FLSchoolMoney> ls = new java.util.Vector<FLSchoolMoney>();
FLSchoolMoney skObj = null;
String qry = null;
qry =
" select a.sk_id, a.stu_id, a.sk_pos_id, a.sk_date, a.invoice_type, "
+ " a.is_sk, a.sk_item, a.sk_money, a.currency, a.course_con_id, "
+ " a.sk_status, a.tk_pay_id, a.df_pay_id, a.ds_unit_id, a.sk_memo, "
+ " a.created, a.creater, a.confirm_date, a.confirmerName, "
+ " a.modified, a.modifier, a.company_code, a.branch_id, a.sk_type"
+ " from t_flschool_money a ";
if (sk_id != null) {
qry += " where a.sk_id=? ";
} else {
qry += " where a.stu_id=? order by sk_date ";
}
PreparedStatement pstmt = null;
ResultSet rs = null;
pstmt = con.prepareStatement(qry);
pstmt.setString(1, sk_id);
rs = pstmt.executeQuery();
while (rs.next()) {
skObj = new FLSchoolMoney();
ls.add(skObj);
skObj.sk_id = rs.getString("sk_id");
skObj.stu_id = rs.getString("stu_id");
skObj.sk_pos_id = rs.getString("sk_pos_id");
skObj.sk_date = JUtil.formatDate(rs.getDate("sk_date"), "YYYY-MM-DD");
skObj.invoice_type = JUtil.convertNull(rs.getString("invoice_type"));
skObj.is_sk = rs.getInt("is_sk");
skObj.sk_item = JUtil.convertNull(rs.getString("sk_item"));
skObj.sk_money = JUtil.convertNull(rs.getString("sk_money"));
skObj.currency = JUtil.convertNull(rs.getString("currency"));
skObj.course_con_id = JUtil.convertNull(rs.getString("course_con_id"));
skObj.sk_status = rs.getInt("sk_status");
skObj.tk_pay_id = JUtil.convertNull(rs.getString("tk_pay_id"));
skObj.df_pay_id = JUtil.convertNull(rs.getString("df_pay_id"));
skObj.ds_unit_id = JUtil.convertNull(rs.getString("ds_unit_id"));
skObj.sk_memo = JUtil.convertNull(rs.getString("sk_memo"));
skObj.created = rs.getTimestamp("created");
skObj.creater = rs.getString("creater");
skObj.confirmerName = JUtil.convertNull(rs.getString("confirmerName"));
java.sql.Date d = rs.getDate("confirm_date");
if (d != null) skObj.confirm_date = JUtil.formatDate(d, "YYYY-MM-DD");
skObj.modified = rs.getTimestamp("modified");
skObj.modifier = rs.getString("modifier");
skObj.company_code = rs.getString("company_code");
skObj.branch_id = JUtil.convertNull(rs.getString("branch_id"));
skObj.sk_type = JUtil.convertNull(rs.getString("sk_type"));
}
rs.close();
pstmt.close();
return ls;
}
private void loadCompany(Connection con, String unit_code) throws Exception {
PreparedStatement pstmt = null;
ResultSet rs = null;
String qry = null;
JCompany obj = null;
qry =
" select unit_id, unit_code, unit_name, biz_lx, biz_ym, biz_fl, biz_yx, biz_ch, "
+ " company_fullName, company_addr,company_district,unit_created "
+ " from t_unit "
+ " where unit_code=? ";
pstmt = con.prepareStatement(qry);
pstmt.setString(1, unit_code.toUpperCase());
rs = pstmt.executeQuery();
if (rs.next()) {
Set<String> bizSet = null;
String[] bizTypes = null;
String szId, szCode, szName;
bizSet = new HashSet<String>();
szId = rs.getString("unit_id");
szCode = rs.getString("unit_code");
szName = JUtil.convertNull(rs.getString("unit_name"));
{
if (rs.getInt("biz_lx") == 1) bizSet.add("留学");
if (rs.getInt("biz_ym") == 1) bizSet.add("移民");
if (rs.getInt("biz_yx") == 1) bizSet.add("团组");
if (rs.getInt("biz_fl") == 1) bizSet.add("外语");
if (rs.getInt("biz_ch") == 1) bizSet.add("华文");
bizTypes = new String[bizSet.size()];
int i = 0;
for (String biz : bizSet) {
bizTypes[i++] = biz;
}
}
obj = new JCompany(szId, szCode, szName, bizTypes);
obj.setCompany_fullName(rs.getString("company_fullName"));
obj.setCompany_address(rs.getString("company_addr"));
obj.setCompany_district(rs.getString("company_district"));
obj.setUnit_created(rs.getDate("unit_created"));
obj.setBranch(getChildBranch(con, szCode));
}
rs.close();
pstmt.close();
if (obj == null) return;
/** ******** 放到 列表 中 ****************** */
String szId = obj.getCompany_id();
String szCode = obj.getCompany_code();
lsBizCompany.remove(szId);
if (!szCode.startsWith("XT_NB.")) lsBizCompany.add(szId);
lsOACompany.contains(szId);
lsOACompany.add(szId);
mapCompany.put(obj.getCompany_code(), obj);
int idx = lsCompany.size();
for (int i = 0; i < lsCompany.size(); i++) {
JCompany com = lsCompany.get(i);
if (com.getCompany_id().equals(szId)) {
idx = i;
lsCompany.remove(i);
break;
}
}
lsCompany.add(idx, obj);
}
/** 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) {
}
}
}
public java.util.List<JCompany> getCompanyList() {
java.util.List<JCompany> ls = new java.util.ArrayList<JCompany>();
ls.addAll(lsCompany);
return ls;
}
/** 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) {
}
}
}
/** 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) {
}
}
}
static {
_jspx_dependants = new java.util.ArrayList(2);
_jspx_dependants.add("/admin/login_check.jsp");
_jspx_dependants.add("/bottom_line.jsp");
}
/** Sherpa romeo submission support */
public void make_sherpaRomeo_submission(Item item, Division divIn) throws WingException {
if (ConfigurationManager.getBooleanProperty(
"webui.submission.sherparomeo-policy-enabled", true)) {
SHERPASubmitService sherpaSubmitService =
new DSpace().getSingletonService(SHERPASubmitService.class);
if (sherpaSubmitService.hasISSNs(context, item)) {
List div = divIn.addList("submit-upload-new", List.TYPE_FORM);
div.setHead(T_sherpa_title);
// Since sherpa web service doesn't work reliable with more than 1 issn, perform the service
// for each issn
Set<String> issns = sherpaSubmitService.getISSNs(context, item);
Iterator<String> issnsIterator = issns.iterator();
int i = 0;
while (issnsIterator.hasNext()) {
SHERPAResponse shresp =
sherpaSubmitService.searchRelatedJournalsByISSN(issnsIterator.next());
java.util.List<SHERPAJournal> journals = shresp.getJournals();
java.util.List<SHERPAPublisher> publishers = shresp.getPublishers();
if (CollectionUtils.isNotEmpty(journals)) {
for (SHERPAJournal journ : journals) {
SHERPAPublisher pub = publishers.get(0);
List sherpaList = div.addList("sherpaList" + (i + 1), "simple", "sherpaList");
sherpaList
.addItem()
.addFigure(
contextPath + "/static/images/" + (i == 0 ? "romeosmall" : "clear") + ".gif",
"http://www.sherpa.ac.uk/romeo/",
"sherpaLogo");
sherpaList.addItem().addHighlight("sherpaBold").addContent(T_sherpa_journal);
sherpaList.addItem(journ.getTitle() + " (" + journ.getIssn() + ")");
sherpaList.addItem().addHighlight("sherpaBold").addContent(T_sherpa_publisher);
sherpaList.addItemXref(pub.getHomeurl(), pub.getName());
sherpaList.addItem().addHighlight("sherpaBold").addContent(T_sherpa_colour);
sherpaList
.addItem()
.addHighlight("sherpaStyle " + pub.getRomeocolour())
.addContent(message("xmlui.aspect.sherpa.submission." + pub.getRomeocolour()));
sherpaList
.addItem()
.addXref(
"http://www.sherpa.ac.uk/romeo/search.php?issn=" + journ.getIssn(),
T_sherpa_more,
"sherpaMoreInfo");
i = i + 1;
}
}
}
List sherpaList = div.addList("sherpaListEnd", "simple", "sherpaList");
sherpaList.addItem(T_sherpa_consult);
}
}
}
public static FLSchoolMoney getFLSchoolMoney(Connection con, String sk_id)
throws java.sql.SQLException {
java.util.List<FLSchoolMoney> ls = getSkList(con, null, sk_id);
if (ls.size() == 1) return ls.get(0);
else return null;
}
/** 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 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) {
}
}
}
/** 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) {
}
}
}
