/**
* Get waiting User name;
*
* @return An waiter ArrayList
*/
public static ArrayList<String> getWaiter() throws SQLException {
ArrayList<String> waiterArray = new ArrayList<String>();
Connection conn = DBConn.GetConnection();
PreparedStatement st = conn.prepareStatement("SELECT * FROM cs_conversion where isstart=?");
st.setInt(1, 1);
ResultSet rs = st.executeQuery();
while (rs.next()) {
if (rs.getString("username").length() != 0) {
if (waiterArray.size() == 0) {
waiterArray.add(rs.getString("username"));
} else {
for (int i = 0; i < waiterArray.size(); i++) {
if (!rs.getString("username").equals(waiterArray.get(i).toString())) {
waiterArray.add(rs.getString("username"));
}
}
}
}
}
rs.close();
st.close();
conn.close();
return waiterArray;
}
// 일사용량(7일)
public ArrayList<ArrayList<String>> get7dayUsage(String umdong) {
ArrayList<ArrayList<String>> datas = new ArrayList<ArrayList<String>>();
String sql =
"select sum(CONSUMED), sum(PREDICTED) from CONSUMPTION where CODE in(select CODE from USER where UMDONG = \'"
+ umdong
+ "\') and DATE between '2015-02-22' and '2015-02-28' group by DATE order by DATE DESC;";
try {
pstmt = conn.prepareStatement(sql);
ResultSet rs = pstmt.executeQuery();
while (rs.next()) {
ArrayList<String> usage = new ArrayList<String>();
usage.add(rs.getString("sum(CONSUMED)"));
usage.add(rs.getString("sum(PREDICTED)"));
datas.add(usage);
}
rs.close();
} catch (SQLException e) {
e.printStackTrace();
}
return datas;
}
public static ArrayList<String> getPasser_zone(String zone) throws SQLException {
ArrayList<String> passerArray = new ArrayList<String>();
Connection conn = DBConn.GetConnection();
PreparedStatement st =
conn.prepareStatement(
"SELECT * FROM cs_conversion LEFT JOIN cs_user ON cs_user.username=cs_conversion.username WHERE cs_conversion.isstart=? AND cs_user.zone=? ");
st.setInt(1, 0);
st.setString(2, zone);
ResultSet rs = st.executeQuery();
while (rs.next()) {
if (rs.getString("username").length() != 0) {
if (passerArray.size() == 0) {
passerArray.add(rs.getString("username"));
} else {
if (!passerArray.contains(rs.getString("username"))) {
passerArray.add(rs.getString("username"));
}
}
}
}
rs.close();
st.close();
conn.close();
return passerArray;
}
public static ArrayList getFjList(String sid) {
ArrayList result = new ArrayList();
String strSql =
"select SID,File_Name,Ext_Name,File_Size from t_docs_fj where state='1' and parent_sid="
+ sid;
CommonDao dao = CommonDao.GetOldDatabaseDao();
List lst = dao.fetchAll(strSql);
if (lst != null && lst.size() > 0) {
for (int i = 0; i < lst.size(); i++) {
Object[] arr = (Object[]) lst.get(i);
result.add(arr[1]);
result.add(arr[2]);
if (arr[3] != null) {
Float fileSize = Float.parseFloat(arr[3].toString()) * 1000;
result.add(fileSize);
} else {
result.add(0);
}
result.add(arr[0]);
}
}
dao.getSessionFactory().close();
return result;
/*Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
ArrayList result = new ArrayList();
String strSql = "select * from t_docs_fj where state='1' and parent_sid="
+ sid;
try {
conn = DataManager.getConnection();
stmt = conn.createStatement();
rs = stmt.executeQuery(strSql);
while (rs.next()) {
result.add(rs.getString("File_Name"));
result.add(rs.getString("Ext_Name"));
result.add(""
+ Float.valueOf(rs.getString("File_Size")).floatValue()
* 1000.0);
result.add(rs.getString("SID"));
result.add(FileUtil.getDocumentPath());
}
} catch (Exception ex) {
ex.printStackTrace();
}
finally {
try {
if (rs != null)
rs.close();
if (stmt != null)
stmt.close();
if (conn != null)
conn.close();
} catch (Exception ex) {
ex.printStackTrace();
}
}*/
}
/**
* @param request
* @param tableCategoryId
* @paqram includeAction if true, will load webactions also
* @return elements are Table or WebAction
*/
public List getChildrenOfTableCategory(
HttpServletRequest request, int tableCategoryId, boolean includeAction) {
TableManager manager = TableManager.getInstance();
WebAction action;
ArrayList cats = new ArrayList();
Connection conn = null;
HashMap webActionEnv = null;
Table table;
UserWebImpl userWeb =
((UserWebImpl)
WebUtils.getSessionContextManager(request.getSession())
.getActor(nds.util.WebKeys.USER));
TableCategory tc = manager.getTableCategory(tableCategoryId);
List children = tc.children();
ArrayList catschild = new ArrayList();
try {
if (includeAction) {
conn = QueryEngine.getInstance().getConnection();
webActionEnv = new HashMap();
webActionEnv.put("connection", conn);
webActionEnv.put("httpservletrequest", request);
webActionEnv.put("userweb", userWeb);
}
for (int j = 0; j < children.size(); j++) {
if (children.get(j) instanceof Table) {
table = (Table) children.get(j);
if (!table.isMenuObject()) {
continue;
}
try {
WebUtils.checkTableQueryPermission(table.getName(), request);
} catch (NDSSecurityException e) {
continue;
}
// table is ok for current user to list
catschild.add(table);
} else if (children.get(j) instanceof WebAction) {
if (includeAction) {
action = (WebAction) children.get(j);
if (action.canDisplay(webActionEnv)) catschild.add(action);
}
} else {
throw new NDSRuntimeException(
"Unsupported element in TableCategory children:" + children.get(j).getClass());
}
}
} catch (Throwable t) {
logger.error("Fail to load subsystem tree", t);
} finally {
try {
if (conn != null) conn.close();
} catch (Throwable e) {
}
}
return catschild;
}
/**
* Get viewable subsystem list
*
* @param request
* @return never null, elements are nds.schema.SubSystem
*/
public List getSubSystems(HttpServletRequest request) {
UserWebImpl userWeb =
((UserWebImpl)
WebUtils.getSessionContextManager(request.getSession())
.getActor(nds.util.WebKeys.USER));
ArrayList subs = new ArrayList();
if (userWeb.getUserId() == userWeb.GUEST_ID) {
return subs;
}
List al = (List) userWeb.getProperty("subsystems"); // elements are subystem.id
TableManager manager = TableManager.getInstance();
if (al != null) {
for (int i = 0; i < al.size(); i++) {
int sid = ((Integer) al.get(i)).intValue();
SubSystem ss = manager.getSubSystem(sid);
if (ss != null) subs.add(ss);
}
} else {
// search all tablecategoris for subsystem
// add users subsystems param
al = new ArrayList();
String[] sub_list;
try {
String subsystems =
(String)
QueryEngine.getInstance()
.doQueryOne("SELECT subsystems from users where id=" + userWeb.getUserId());
if (Validator.isNotNull(subsystems)) {
sub_list = subsystems.split(",");
for (int m = 0; m < sub_list.length; m++) {
SubSystem usersub = manager.getSubSystem(sub_list[m].trim());
if (usersub != null) {
if (usersub.getId() == 10) continue;
al.add(new Integer(usersub.getId()));
subs.add(usersub);
}
}
userWeb.setProperty("subsystems", al);
return subs;
}
} catch (QueryException e) {
logger.error("Fail to load subsystems from users", e);
}
for (int i = 0; i < manager.getSubSystems().size(); i++) {
SubSystem ss = (SubSystem) manager.getSubSystems().get(i);
if (containsViewableChildren(request, ss)) {
al.add(new Integer(ss.getId()));
subs.add(ss);
}
}
userWeb.setProperty("subsystems", al);
}
return subs;
}
public void addBatch() throws SQLException {
if (batch == null) {
batch = new ArrayList(args.length);
}
if (args.length == 0) {
batch.add(new BatchArg(null, false));
} else {
for (int i = 0; i < args.length; i++) {
batch.add(new BatchArg(args[i], blobs[i]));
}
}
}
/**
* MU_FAVORITE
*
* @throws Exception cyl
* @param request
* @return elements are Table or WebAction and menu list
* @paqram includeAction if true?not now
*/
public List getSubSystemsOfmufavorite(HttpServletRequest request) throws Exception {
ArrayList mufavorite = new ArrayList();
TableManager manager = TableManager.getInstance();
// Table table;
try {
UserWebImpl userWeb =
((UserWebImpl)
WebUtils.getSessionContextManager(request.getSession())
.getActor(nds.util.WebKeys.USER));
int userid = userWeb.getUserId();
List al =
QueryEngine.getInstance()
.doQueryList(
"select t.ad_table_id,t.fa_menu,t.menu_re,t.IS_REPORT from MU_FAVORITE t where t.ownerid="
+ String.valueOf(userid)
+ " group by t.ad_table_id,t.menu_no,t.fa_menu,t.menu_re,t.IS_REPORT,t.creationdate order by t.menu_no,t.creationdate asc");
logger.debug("MU_FAVORITE size is " + String.valueOf(al.size()));
if (al.size() > 0) {
for (int i = 0; i < al.size(); i++) {
// ArrayList catschild= new ArrayList();
List als = (List) al.get(i);
String fa_menu = (String) als.get(1);
String menu_re = (String) als.get(2);
String isreport = (String) als.get(3);
int table_id = Tools.getInt(als.get(0), -1);
Table table = manager.getTable(table_id);
logger.debug(table.getName());
/*
if(!table.isMenuObject()){
continue;
//because many table is webaction not ismenuobject
}*/
try {
WebUtils.checkTableQueryPermission(table.getName(), request);
} catch (NDSSecurityException e) {
continue;
}
logger.debug("add_table ->" + table.getName());
ArrayList row = new ArrayList();
row.add(fa_menu);
row.add(menu_re);
row.add(isreport);
row.add(table);
mufavorite.add(row);
}
}
} catch (Throwable t) {
logger.error("Fail to load mufavorite", t);
}
return mufavorite;
}
/**
* Is standard Period Open for Document Base Type
*
* @param header header document record
* @param lines document lines optional
* @param DateAcct accounting date
* @param DocBaseType document base type
* @return error message or null
*/
@Deprecated
public static String isOpen(PO header, PO[] lines, Timestamp DateAcct, String DocBaseType) {
// Get All Orgs
ArrayList<Integer> orgs = new ArrayList<Integer>();
orgs.add(header.getAD_Org_ID());
if (lines != null) {
for (PO line : lines) {
int AD_Org_ID = line.getAD_Org_ID();
if (!orgs.contains(AD_Org_ID)) orgs.add(AD_Org_ID);
}
}
return isOpen(header.getCtx(), header.getAD_Client_ID(), orgs, DateAcct, DocBaseType);
} // isOpen
public void listerArticles() {
Connection con = null;
Statement st = null;
ResultSet rs = null;
try {
Class.forName(driver).newInstance();
con = DriverManager.getConnection(url, usr, passwd);
st = con.createStatement();
rs = st.executeQuery("SELECT id, nom, quantite FROM articles");
// remise à 0 de la liste - utile pour les mises à jour
list.clear();
// Stocker les enregistrements dans la liste
while (rs.next()) {
int id = rs.getInt(1);
String nom = new String(rs.getString(2));
int quantite = rs.getInt(3);
list.add(new ElementBDD(nom, quantite)); // ajout
System.out.println(nom + " " + quantite);
}
} catch (Exception e) {
System.err.println("Exception: " + e.getMessage());
} finally {
try {
if (rs != null) rs.close();
if (st != null) st.close();
if (con != null) con.close();
} catch (SQLException e) {
}
}
}
public ArrayList<Empleado> listarEmpleado() {
ArrayList<Empleado> emple = new ArrayList<Empleado>();
try {
cn = Conexion.realizarConexion();
st = cn.createStatement();
String sql = "select * from empleado";
rs = st.executeQuery(sql);
while (rs.next()) {
emple.add(
new Empleado(
rs.getString(1),
rs.getString(2),
rs.getString(3),
rs.getString(4),
rs.getString(5),
rs.getString(6),
rs.getString(7),
rs.getString(8)));
}
} catch (ClassNotFoundException ex) {
showMessageDialog(null, ex.getMessage(), "Excepción", 0);
} catch (SQLException ex) {
showMessageDialog(null, ex.getMessage(), "Excepción", 0);
} finally {
try {
rs.close();
st.close();
cn.close();
} catch (Exception ex) {
showMessageDialog(null, ex.getMessage(), "Excepción", 0);
}
}
return emple;
}
// 根据用户的id，获得用户的所有电影
public ArrayList<MovieInfo> getMovieByUserId(long userID) {
ArrayList<MovieInfo> movieList = new ArrayList<MovieInfo>();
try {
String sql =
"select m.name,m.published_year,m.type,mp.preference from movie_preferences mp,movies m where mp.movieID=m.id and mp.userID="
+ userID
+ " order by preference desc";
conn = ConnectToMySQL.getConnection();
ps = conn.prepareStatement(sql);
rs = ps.executeQuery();
while (rs.next()) {
MovieInfo movieInfo = new MovieInfo();
movieInfo.setName(rs.getString(1));
movieInfo.setPublishedYear(rs.getString(2));
movieInfo.setType(rs.getString(3));
movieInfo.setPreference(rs.getInt(4));
movieList.add(movieInfo);
}
} catch (Exception e) {
// TODO: handle exception
e.printStackTrace();
} finally {
closeAll();
}
return movieList;
}
// 根据推荐的movie的ID，获得movie的详细信息
public ArrayList<MovieInfo> getMovieByMovieId(List<RecommendedItem> recommendations) {
ArrayList<MovieInfo> movieList = new ArrayList<MovieInfo>();
try {
String sql = "";
conn = ConnectToMySQL.getConnection();
for (int i = 0; i < recommendations.size(); i++) {
sql =
"select m.name,m.published_year,m.type from movies m where m.id="
+ recommendations.get(i).getItemID()
+ "";
ps = conn.prepareStatement(sql);
rs = ps.executeQuery();
while (rs.next()) {
MovieInfo movieInfo = new MovieInfo();
movieInfo.setName(rs.getString(1));
movieInfo.setPublishedYear(rs.getString(2));
movieInfo.setType(rs.getString(3));
movieInfo.setPreference(recommendations.get(i).getValue());
movieList.add(movieInfo);
}
}
} catch (Exception e) {
// TODO: handle exception
e.printStackTrace();
} finally {
closeAll();
}
return movieList;
}
/** Load data. */
private ArrayList loadData() {
try {
ArrayList vos = new ArrayList();
BufferedReader br =
new BufferedReader(new InputStreamReader(new FileInputStream("orders.txt")));
String line = null;
SimpleDateFormat sdf = new SimpleDateFormat("dd/MM/yyyy");
OrdersVO vo = null;
String[] t = null;
while ((line = br.readLine()) != null) {
t = line.split(";");
vo = new OrdersVO();
vos.add(vo);
vo.setOrderDate(sdf.parse(t[0]));
vo.setCategory(t[1]);
vo.setSubCategory(t[2]);
vo.setCountry(t[3]);
vo.setZone(t[4]);
vo.setAgent(t[5]);
vo.setItem(t[6]);
vo.setSellQty(new BigDecimal(t[7]));
vo.setSellAmount(new BigDecimal(t[8]));
}
br.close();
return vos;
} catch (Exception ex) {
ex.printStackTrace();
return new ArrayList();
}
}
public ArrayList<VentasBean> obtenerMensajes() {
Connection cn = null;
ArrayList<VentasBean> mensaje = null;
Statement st;
ResultSet rs;
try {
cn = getConnection();
st = cn.createStatement();
String tsql;
tsql = "select * from ventas";
rs = st.executeQuery(tsql);
mensaje = new ArrayList<VentasBean>();
while (rs.next()) {
VentasBean m =
new VentasBean(
rs.getInt("id_venta"),
rs.getInt("id_linea"),
rs.getString("fecha_venta"),
rs.getString("descripcion"));
mensaje.add(m);
}
cn.close();
} catch (Exception e) {
e.printStackTrace();
}
return (mensaje);
}
// metoda za pretragu po broju stanovnika
public ArrayList<Country> SearchCountryPopulation(long Population) {
ArrayList<Country> countries = new ArrayList<Country>();
try {
Connection connection = getConnected("world");
PreparedStatement statement =
connection.prepareStatement(
"SELECT * FROM country WHERE Population <= " + Population + ";");
ResultSet result = statement.executeQuery();
while (result.next()) {
countries.add(
new Country(
result.getString("Code"),
result.getString("Name"),
result.getString("Continent"),
result.getString("Region"),
result.getDouble("SurfaceArea"),
result.getInt("IndepYear"),
result.getLong("Population"),
result.getDouble("LifeExpectancy"),
result.getDouble("GNP"),
result.getDouble("GNPOld"),
result.getString("LocalName"),
result.getString("GovernmentForm"),
result.getString("HeadOfState"),
result.getInt("Capital"),
result.getString("Code2")));
}
connection.close();
} catch (Exception e) {
System.out.println(e.toString());
return null;
}
return countries;
}
/**
* Get Accessible Goals
*
* @param ctx context
* @return array of goals
*/
public static MGoal[] getGoals(Ctx ctx) {
ArrayList<MGoal> list = new ArrayList<MGoal>();
String sql = "SELECT * FROM PA_Goal WHERE IsActive='Y' " + "ORDER BY SeqNo";
sql =
MRole.getDefault(ctx, false)
.addAccessSQL(sql, "PA_Goal", false, true); // RW to restrict Access
PreparedStatement pstmt = null;
ResultSet rs = null;
try {
pstmt = DB.prepareStatement(sql, (Trx) null);
rs = pstmt.executeQuery();
while (rs.next()) {
MGoal goal = new MGoal(ctx, rs, null);
goal.updateGoal(false);
list.add(goal);
}
} catch (Exception e) {
s_log.log(Level.SEVERE, sql, e);
} finally {
DB.closeStatement(pstmt);
DB.closeResultSet(rs);
}
MGoal[] retValue = new MGoal[list.size()];
list.toArray(retValue);
return retValue;
} // getGoals
/**
* Get Restriction Lines
*
* @param reload reload data
* @return array of lines
*/
public MGoalRestriction[] getRestrictions(boolean reload) {
if (m_restrictions != null && !reload) return m_restrictions;
ArrayList<MGoalRestriction> list = new ArrayList<MGoalRestriction>();
//
String sql =
"SELECT * FROM PA_GoalRestriction "
+ "WHERE PA_Goal_ID=? AND IsActive='Y' "
+ "ORDER BY Org_ID, C_BPartner_ID, M_Product_ID";
PreparedStatement pstmt = null;
ResultSet rs = null;
try {
pstmt = DB.prepareStatement(sql, get_Trx());
pstmt.setInt(1, getPA_Goal_ID());
rs = pstmt.executeQuery();
while (rs.next()) list.add(new MGoalRestriction(getCtx(), rs, get_Trx()));
} catch (Exception e) {
log.log(Level.SEVERE, sql, e);
} finally {
DB.closeStatement(pstmt);
DB.closeResultSet(rs);
}
//
m_restrictions = new MGoalRestriction[list.size()];
list.toArray(m_restrictions);
return m_restrictions;
} // getRestrictions
public List getEntries(int startIndex, int endIndex) {
// User code starts here
if (agentName.initTopo()) {
ArrayList arrayList = new ArrayList();
int noOfObj = getCount();
String[] name = {""}; // No I18N
for (int i = 0; i < noOfObj; i++) {
if (name[0].trim().equals("")) // No I18N
{
getFirstMo(name);
} else {
getNextMo(name);
}
if ((i + 1 >= startIndex) && (i + 1 <= endIndex)) {
Object[] indx = new Object[] {name[0]};
arrayList.add(indx);
if (i + 1 == endIndex) break;
}
}
return arrayList;
}
// User code ends here
return null;
}
private double[] getSparkModelInfoFromHDFS(Path location, Configuration conf) throws Exception {
FileSystem fileSystem = FileSystem.get(location.toUri(), conf);
FileStatus[] files = fileSystem.listStatus(location);
if (files == null) throw new Exception("Couldn't find Spark Truck ML weights at: " + location);
ArrayList<Double> modelInfo = new ArrayList<Double>();
for (FileStatus file : files) {
if (file.getPath().getName().startsWith("_")) {
continue;
}
InputStream stream = fileSystem.open(file.getPath());
StringWriter writer = new StringWriter();
IOUtils.copy(stream, writer, "UTF-8");
String raw = writer.toString();
for (String str : raw.split("\n")) {
modelInfo.add(Double.valueOf(str));
}
}
return Doubles.toArray(modelInfo);
}
public List<ICFAccTaxObj> readAllTax(boolean forceRead) {
final String S_ProcName = "readAllTax";
if ((allTax == null) || forceRead) {
Map<CFAccTaxPKey, ICFAccTaxObj> map = new HashMap<CFAccTaxPKey, ICFAccTaxObj>();
allTax = map;
CFAccTaxBuff[] buffList =
((ICFAccSchema) schema.getBackingStore())
.getTableTax()
.readAllDerived(schema.getAuthorization());
CFAccTaxBuff buff;
ICFAccTaxObj obj;
for (int idx = 0; idx < buffList.length; idx++) {
buff = buffList[idx];
obj = newInstance();
obj.setPKey(((ICFAccSchema) schema.getBackingStore()).getFactoryTax().newPKey());
obj.setBuff(buff);
ICFAccTaxObj realized = (ICFAccTaxObj) obj.realize();
}
}
Comparator<ICFAccTaxObj> cmp =
new Comparator<ICFAccTaxObj>() {
public int compare(ICFAccTaxObj lhs, ICFAccTaxObj rhs) {
if (lhs == null) {
if (rhs == null) {
return (0);
} else {
return (-1);
}
} else if (rhs == null) {
return (1);
} else {
CFAccTaxPKey lhsPKey = lhs.getPKey();
CFAccTaxPKey rhsPKey = rhs.getPKey();
int ret = lhsPKey.compareTo(rhsPKey);
return (ret);
}
}
};
int len = allTax.size();
ICFAccTaxObj arr[] = new ICFAccTaxObj[len];
Iterator<ICFAccTaxObj> valIter = allTax.values().iterator();
int idx = 0;
while ((idx < len) && valIter.hasNext()) {
arr[idx++] = valIter.next();
}
if (idx < len) {
throw CFLib.getDefaultExceptionFactory()
.newArgumentUnderflowException(getClass(), S_ProcName, 0, "idx", idx, len);
} else if (valIter.hasNext()) {
throw CFLib.getDefaultExceptionFactory()
.newArgumentOverflowException(getClass(), S_ProcName, 0, "idx", idx, len);
}
Arrays.sort(arr, cmp);
ArrayList<ICFAccTaxObj> arrayList = new ArrayList<ICFAccTaxObj>(len);
for (idx = 0; idx < len; idx++) {
arrayList.add(arr[idx]);
}
List<ICFAccTaxObj> sortedList = arrayList;
return (sortedList);
}
/** Expand the current node and return the list of leaves (MaterialVO objects). */
private ArrayList getComponents(DefaultMutableTreeNode node) {
ArrayList list = new ArrayList();
for (int i = 0; i < node.getChildCount(); i++)
list.addAll(getComponents((DefaultMutableTreeNode) node.getChildAt(i)));
if (node.isLeaf()) list.add(node.getUserObject());
return list;
}
/**
* ************************************************************************ Lineas de Remesa
*
* @param whereClause where clause or null (starting with AND)
* @return lines
*/
public MRemesaLine[] getLines(String whereClause, String orderClause) {
ArrayList list = new ArrayList();
StringBuffer sql = new StringBuffer("SELECT * FROM C_RemesaLine WHERE C_Remesa_ID=? ");
if (whereClause != null) sql.append(whereClause);
if (orderClause != null) sql.append(" ").append(orderClause);
PreparedStatement pstmt = null;
try {
pstmt = DB.prepareStatement(sql.toString(), get_TrxName());
pstmt.setInt(1, getC_Remesa_ID());
ResultSet rs = pstmt.executeQuery();
while (rs.next()) list.add(new MRemesaLine(getCtx(), rs));
rs.close();
pstmt.close();
pstmt = null;
} catch (Exception e) {
log.saveError("getLines - " + sql, e);
} finally {
try {
if (pstmt != null) pstmt.close();
} catch (Exception e) {
}
pstmt = null;
}
//
MRemesaLine[] lines = new MRemesaLine[list.size()];
list.toArray(lines);
return lines;
} // getLines
/**
* Is standard Period closed for all Document Base Types
*
* @param ctx context for AD_Client
* @param DateAcct accounting date
* @return true if closed
*/
public static boolean isClosed(Ctx ctx, Timestamp DateAcct) {
if (DateAcct == null) return false;
MAcctSchema as = MClient.get(ctx, ctx.getAD_Client_ID()).getAcctSchema();
if (as.isAutoPeriodControl()) return !as.isAutoPeriodControlOpen(DateAcct);
// Get all Calendars in line with Organizations
MClientInfo cInfo = MClientInfo.get(ctx, ctx.getAD_Client_ID(), null);
ArrayList<Integer> calendars = new ArrayList<Integer>();
MOrg[] orgs = MOrg.getOfClient(cInfo);
for (MOrg org : orgs) {
MOrgInfo info = MOrgInfo.get(ctx, org.getAD_Org_ID(), null);
int C_Calendar_ID = info.getC_Calendar_ID();
if (C_Calendar_ID == 0) C_Calendar_ID = cInfo.getC_Calendar_ID();
if (!calendars.contains(C_Calendar_ID)) calendars.add(C_Calendar_ID);
}
// Should not happen
if (calendars.size() == 0) throw new IllegalArgumentException("@NotFound@ @C_Calendar_ID@");
// For all Calendars get Periods
for (int i = 0; i < calendars.size(); i++) {
int C_Calendar_ID = calendars.get(i);
MPeriod period = MPeriod.getOfCalendar(ctx, C_Calendar_ID, DateAcct);
// Period not found
if (period == null) return false;
if (!period.isClosed()) return false;
}
return true; // closed
} // isClosed
private static void readLinkFile(boolean isHighway) {
System.out.println("read link file...");
int debug = 0;
try {
FileInputStream fstream =
new FileInputStream(root + "/" + (isHighway ? highwayLinkFile : arterialLinkFile));
DataInputStream in = new DataInputStream(fstream);
BufferedReader br = new BufferedReader(new InputStreamReader(in));
String strLine;
while ((strLine = br.readLine()) != null) {
debug++;
String[] nodes = strLine.split(";");
int linkId = Integer.parseInt(nodes[0]);
String allDir = nodes[1];
String streetName = nodes[2];
int funcClass = Integer.parseInt(nodes[3]);
ArrayList<PairInfo> nodeList = getPairListFromStr(nodes[4]);
int speedCat = Integer.parseInt(nodes[5]);
String dirTravel = nodes[6];
int startNode = Integer.parseInt(nodes[7]);
int endNode = Integer.parseInt(nodes[8]);
LinkInfo linkInfo =
new LinkInfo(
linkId,
funcClass,
streetName,
startNode,
endNode,
nodeList,
dirTravel,
speedCat,
allDir);
if (isHighway) highwayLinkList.add(linkInfo);
else arterialLinkList.add(linkInfo);
if (debug % 100000 == 0) System.out.println("record " + debug + " finish!");
}
} catch (Exception e) {
// TODO: handle exception
e.printStackTrace();
System.err.println("Error Code: " + debug);
}
System.out.println("read link file finish!");
}
/**
* 事实表和关联报表属于当前传入数组的交叉报表
*
* @param request
* @return elements are ArrayList, first is cxtab id, second is cxtab name
*/
public List getCxtabs(HttpServletRequest request, int tableCategoryId) {
List tables = getChildrenOfTableCategory(request, tableCategoryId, false);
ArrayList<Integer> al = new ArrayList();
for (int i = 0; i < tables.size(); i++) {
al.add(((Table) tables.get(i)).getId());
}
return getCxtabs(request, al);
}
/**
* Returnerar en lista över namnen på användarens kortsamlingar.
*
* @return stränglista innehållande namnen på användarens kortsamlingar
*/
@Override
public ArrayList<String> getUserCollections() {
ArrayList<String> userTables = new ArrayList<String>();
for (CardCollection cc : cardCollections) {
userTables.add(cc.getCollectionName()); // lägg till samling i namnlista
}
return userTables; // return namnlista över kortsamlingar
}
public void closeConnection(Connection conn) throws SQLException {
synchronized (pool) {
if (pool.size() < pool_size) {
pool.add(conn);
return;
}
}
conn.close();
}
private static ArrayList<PairInfo> getPairListFromStr(String str) {
String[] nodes = str.split(":");
ArrayList<PairInfo> pairList = new ArrayList<PairInfo>();
for (int i = 0; i < nodes.length; i++) {
PairInfo pair = getPairFromStr(nodes[i]);
pairList.add(pair);
}
return pairList;
}
public ArrayList getSelectedMessages() {
ArrayList list = new ArrayList();
for (int i = 0; i < table.getRowCount(); i++) {
if (((Boolean) table.getValueAt(i, 0)) == true) {
list.add(msgID[i]);
}
}
return list;
}