/**
* Deletes a meeting from the database
*
* <p>- Requires a cookie for the session user - Requires a meetingId request parameter for the
* HTTP GET
*
* @param req The HTTP Request
* @param res The HTTP Response
*/
public void deletemeetingAction(HttpServletRequest req, HttpServletResponse res) {
// Ensure there is a cookie for the session user
if (AccountController.redirectIfNoCookie(req, res)) return;
if (req.getMethod() == HttpMethod.Get) {
// Get the meeting
int meetingId = Integer.parseInt(req.getParameter("meetingId"));
MeetingManager meetingMan = new MeetingManager();
Meeting meeting = meetingMan.get(meetingId);
meetingMan.deleteMeeting(meetingId);
// Update the User Session to remove meeting
HttpSession session = req.getSession();
Session userSession = (Session) session.getAttribute("userSession");
List<Meeting> adminMeetings = userSession.getUser().getMeetings();
for (int i = 0; i < adminMeetings.size(); i++) {
Meeting m = adminMeetings.get(i);
if (m.getId() == meeting.getId()) {
adminMeetings.remove(i);
break;
}
}
redirectToLocal(req, res, "/home/dashboard");
return;
} else if (req.getMethod() == HttpMethod.Post) {
httpNotFound(req, res);
}
}
public void test(List<Datum> testData) {
File file = new File("../baseline.out");
// if file doesnt exists, then create it
try {
if (!file.exists()) {
file.createNewFile();
}
FileWriter fw = new FileWriter(file.getAbsoluteFile());
BufferedWriter bw = new BufferedWriter(fw);
for (int i = 0; i < testData.size(); i++) {
String testWord = testData.get(i).word;
String trueLabel = testData.get(i).label;
String predictedLabel = "O";
for (int j = 0; j < trainData.size(); j++) {
if (testWord.equals(trainData.get(j).word)) {
predictedLabel = trainData.get(j).label;
break;
}
}
// write result to text file
bw.write(testWord + "\t" + trueLabel + "\t" + predictedLabel + "\n");
}
bw.close();
} catch (Exception e) {
}
}
/** Creates a <code>StatisticalSignificance</code> object. */
public StatisticalSignificance(
File goldFile, File baselineFile, File preferredFile, int n, double c, String stat)
throws IOException, IndexOutOfBoundsException {
this.stat = stat;
logger.debug("StatisticalSignificance.StatisticalSignificance: ");
logger.debug("gold:" + goldFile);
logger.debug("baseline:" + baselineFile);
logger.debug("preferred:" + preferredFile);
iterations = n;
confidence = c;
List gold = read(goldFile);
List baseline = read(baselineFile);
List preferred = read(preferredFile);
logger.info("gold.size:" + gold.size());
logger.debug("baseline.size:" + baseline.size());
logger.debug("preferred.size:" + preferred.size());
double t = test(baseline, preferred, gold);
if (t < confidence)
logger.info(t + " < " + confidence + " reject null hyphotesis (significant)");
else logger.info(t + " >= " + confidence + " accept null hyphotesis (insignificant)");
} // end constructor
/** Method to show the frame sequence */
public void show() {
if (shown != true) {
// set it to true
shown = true;
// if there is a picture show the last one
if (pictureList.size() > 0)
pictureFrame = new PictureFrame((Picture) pictureList.get(pictureList.size() - 1));
else
System.out.println(
"There are no frames to show yet. When you add a frame it will be shown");
}
}
public CharPos charat(Coord c) {
if (c.y < -sb.val) {
if (msgs.size() < 1) return (null);
Message msg = msgs.get(0);
if (!(msg.text() instanceof RichText)) return (null);
RichText.TextPart fp = null;
for (RichText.Part part = ((RichText) msg.text()).parts; part != null; part = part.next) {
if (part instanceof RichText.TextPart) {
fp = (RichText.TextPart) part;
break;
}
}
if (fp == null) return (null);
return (new CharPos(msg, fp, TextHitInfo.leading(0)));
}
Coord hc = new Coord();
Message msg = messageat(c, hc);
if ((msg == null) || !(msg.text() instanceof RichText)) return (null);
RichText rt = (RichText) msg.text();
RichText.Part p = rt.partat(hc);
if (p == null) {
RichText.TextPart lp = null;
for (RichText.Part part = ((RichText) msg.text()).parts; part != null; part = part.next) {
if (part instanceof RichText.TextPart) lp = (RichText.TextPart) part;
}
if (lp == null) return (null);
return (new CharPos(msg, lp, TextHitInfo.trailing(lp.end - lp.start - 1)));
}
if (!(p instanceof RichText.TextPart)) return (null);
RichText.TextPart tp = (RichText.TextPart) p;
return (new CharPos(msg, tp, tp.charat(hc)));
}
public List retrieveAttachmentsByCustomerId(long customerId) throws RemoteException {
List attachments = new ArrayList();
AttachmentDAO attachmentDAO = new AttachmentDAO(conn);
attachments = attachmentDAO.retrieveAttachmentsByCustomerId(customerId);
USFEnv.getLog().writeDebug("attachments size is......" + attachments.size(), this, null);
return attachments;
}
public final void populateDivisionColumn() throws SQLException {
Sql sql = sqlhand.als_mysoftsql();
if (sql == null) return;
List<GroovyRowResult> tlist = null;
String sqlstm =
"select distinct stock_cat from stockmasterdetails where item_type='Service Item' and nominal_code like '5%' order by stock_cat";
try {
tlist = sql.rows(sqlstm);
sql.close();
} catch (SQLException e) {
}
if (tlist.size() == 0) return;
Listbox newlb = lbhand.makeVWListbox(division_holder, blankish_lb_headers, division_lbid, 20);
newlb.addEventListener("onSelect", new divisionOnClick());
String[] strarray = new String[1];
String tp_division = luhand.getRec_Origid("TP_DIVISIONS"); // hardcoded
// debugLabel.setValue("getrec_origid: " + tp_division);
for (GroovyRowResult ilist : tlist) {
strarray[0] =
luhand.matchLookup_ReturnStr("TP_DIVISIONS", (String) ilist.get("stock_cat"), 1);
// strarray[0] = (String)ilist.get("stock_cat");
lbhand.insertListItems(newlb, strarray, "true", "");
}
} // end of populateDivisionColumn()
// Populate division column - refer to mysoft.stockmasterdetails.stock_cat
// nominal_code=glcode=5xxxxx = services we sell
// istock_cat = as in stockmasterdetails.stock_cat
public final void populateSectionColumn(String istock_cat) {
Sql sql = sqlhand.als_mysoftsql();
if (sql == null) return;
String sqlstm =
"select distinct groupcode from stockmasterdetails where item_type='Service Item' and nominal_code like '5%' "
+ "and stock_cat='"
+ istock_cat
+ "' order by groupcode";
List<GroovyRowResult> tlist = null;
try {
tlist = sql.rows(sqlstm);
sql.close();
} catch (SQLException e) {
}
if (tlist == null) return;
selected_category = istock_cat; // save for later usage
if (tlist.size() == 0) return;
Listbox newlb = lbhand.makeVWListbox(section_holder, blankish_lb_headers, section_lbid, 20);
newlb.addEventListener("onSelect", new sectionOnClick());
String[] strarray = new String[1];
for (GroovyRowResult ilist : tlist) {
strarray[0] = (String) ilist.get("groupcode");
lbhand.insertListItems(newlb, strarray, "true", "");
}
} // end of populateSectionColumn()
private MarketSnapshot toMarketDepth(String line) throws JBookTraderException, ParseException {
List<String> tokens = fastSplit(line);
if (tokens.size() != COLUMNS) {
String msg = "The line should contain exactly " + COLUMNS + " comma-separated columns.";
throw new JBookTraderException(msg);
}
String dateTime = tokens.get(0) + tokens.get(1);
String dateTimeWithoutSeconds = dateTime.substring(0, 10);
if (dateTimeWithoutSeconds.equals(previousDateTimeWithoutSeconds)) {
// only seconds need to be set
int milliSeconds = 1000 * Integer.parseInt(dateTime.substring(10));
long previousMilliSeconds = previousTime % 60000;
time = previousTime + (milliSeconds - previousMilliSeconds);
} else {
time = sdf.parse(dateTime).getTime();
previousDateTimeWithoutSeconds = dateTimeWithoutSeconds;
}
if (time <= previousTime) {
String msg =
"Timestamp of this line is before or the same as the timestamp of the previous line.";
throw new JBookTraderException(msg);
}
double balance = Double.parseDouble(tokens.get(2));
double price = Double.parseDouble(tokens.get(3));
int volume = Integer.parseInt(tokens.get(4));
return new MarketSnapshot(time, balance, price, volume);
}
static String[] animate(int speed, String init) {
List<List<Particle>> lists = new ArrayList<>();
List<String> res = new ArrayList<>();
for (int i = 0; i < init.length(); i++) {
lists.add(new ArrayList<>());
char c = init.charAt(i);
if (c == 'R') {
lists.get(i).add(new Particle(speed));
} else if (c == 'L') {
lists.get(i).add(new Particle(-speed));
}
}
while (checkRemain(lists)) {
res.add(convert(lists));
lists = nextStep(lists);
}
res.add(convert(lists));
String[] result = new String[res.size()];
int index = 0;
for (String s : res) {
result[index++] = s;
}
return result;
}
public void removeNotLastModifications() {
List<String> uniquePaths = getUniquePaths();
for (String path : uniquePaths) {
int lastRevision = getLastModificationRevisionForPath(path);
int count = logEntries.size();
int i = 0;
while (i < count) {
LogEntry entry = logEntries.get(i);
if (entry.getRevision() < lastRevision) {
entry.removeEntriesWithPath(path);
if (entry.isEmpty()) {
logEntries.remove(entry);
count--;
i--;
}
}
i++;
}
}
isOrdered = false;
}
/**
* Get the total value for the index. All indexes must be numbers. The list must be a list of
* String arrays.
*
* @param list List: the list to average
* @param precision int: the result decimal precision
* @return String[]: the averages as strings
*/
public static String[] averageAll(List list, int precision) {
String[] tmp = (String[]) list.get(0);
String[] res = new String[tmp.length];
double[] d = new double[tmp.length];
for (int i = 0; i < d.length; i++) {
d[i] = 0.0;
}
int size = list.size();
for (int i = 0; i < size; i++) {
String[] sa = (String[]) list.get(i);
for (int j = 0; j < sa.length; j++) {
if (!sa[j].equals("")) {
d[j] += Double.parseDouble(sa[j]);
}
}
}
NumberFormat nf = NumberFormat.getInstance();
nf.setMaximumFractionDigits(precision);
nf.setMinimumFractionDigits(precision);
nf.setMinimumIntegerDigits(1);
for (int i = 0; i < d.length; i++) {
res[i] = nf.format(d[i] / size);
}
return res;
}
private List copy(List in) {
List out = new ArrayList();
for (int i = 0; i < in.size(); i++) out.add(in.get(i));
return out;
} // end copy
public CFSecuritySecDeviceBuff[] readBuffByUserIdx(
CFSecurityAuthorization Authorization, UUID SecUserId) {
final String S_ProcName = "readBuffByUserIdx";
ResultSet resultSet = null;
try {
Connection cnx = schema.getCnx();
String sql =
"call "
+ schema.getLowerDbSchemaName()
+ ".sp_read_secdev_by_useridx( ?, ?, ?, ?, ?"
+ ", "
+ "?"
+ " )";
if (stmtReadBuffByUserIdx == null) {
stmtReadBuffByUserIdx = cnx.prepareStatement(sql);
}
int argIdx = 1;
stmtReadBuffByUserIdx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtReadBuffByUserIdx.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecUserId().toString());
stmtReadBuffByUserIdx.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecSessionId().toString());
stmtReadBuffByUserIdx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtReadBuffByUserIdx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecTenantId());
stmtReadBuffByUserIdx.setString(argIdx++, SecUserId.toString());
try {
resultSet = stmtReadBuffByUserIdx.executeQuery();
} catch (SQLException e) {
if (e.getErrorCode() != 1329) {
throw e;
}
resultSet = null;
}
List<CFSecuritySecDeviceBuff> buffList = new LinkedList<CFSecuritySecDeviceBuff>();
while ((resultSet != null) && resultSet.next()) {
CFSecuritySecDeviceBuff buff = unpackSecDeviceResultSetToBuff(resultSet);
buffList.add(buff);
}
int idx = 0;
CFSecuritySecDeviceBuff[] retBuff = new CFSecuritySecDeviceBuff[buffList.size()];
Iterator<CFSecuritySecDeviceBuff> iter = buffList.iterator();
while (iter.hasNext()) {
retBuff[idx++] = iter.next();
}
return (retBuff);
} catch (SQLException e) {
throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
} finally {
if (resultSet != null) {
try {
resultSet.close();
} catch (SQLException e) {
}
resultSet = null;
}
}
}
public String getPackedVersionString() {
ICFLibAnyObj scopeDef;
ICFBamVersionObj versionLeafDef = getVersionLeaf();
List<String> invertedNodeNames = new ArrayList<String>();
while (versionLeafDef != null) {
invertedNodeNames.add(getVersionStringForLeafDef(versionLeafDef));
scopeDef = versionLeafDef.getObjScope();
if (scopeDef == null) {
versionLeafDef = null;
} else if (scopeDef instanceof ICFBamMinorVersionObj) {
versionLeafDef = (ICFBamMinorVersionObj) scopeDef;
} else if (scopeDef instanceof ICFBamMajorVersionObj) {
versionLeafDef = (ICFBamMajorVersionObj) scopeDef;
} else if (scopeDef instanceof ICFBamVersionObj) {
versionLeafDef = (ICFBamVersionObj) scopeDef;
} else {
versionLeafDef = null;
}
}
String ret = "";
for (int idx = invertedNodeNames.size() - 1; idx >= 0; idx--) {
if (ret.length() == 0) {
ret = invertedNodeNames.get(idx);
} else {
ret = ret + invertedNodeNames.get(idx);
}
}
return (ret);
}
public void removeEntriesWithPathForAuthor(String path, String author) {
if (logEntries == null || logEntries.isEmpty()) {
return;
}
int count = logEntries.size();
int i = 0;
while (i < count) {
LogEntry logEntry = logEntries.get(i);
if (!logEntry.getAuthor().equals(author)) {
i++;
continue;
}
logEntry.removeEntriesWithPath(path);
if (logEntry.isEmpty()) {
logEntries.remove(logEntry);
count--;
continue;
}
i++;
}
isOrdered = false;
}
public CFSecurityISOCountryLanguageBuff[] readAllBuff(CFSecurityAuthorization Authorization) {
final String S_ProcName = "readAllBuff";
if (!schema.isTransactionOpen()) {
throw CFLib.getDefaultExceptionFactory()
.newUsageException(getClass(), S_ProcName, "Transaction not open");
}
ResultSet resultSet = null;
try {
Connection cnx = schema.getCnx();
String sql =
"call " + schema.getLowerDbSchemaName() + ".sp_read_iso_cntrylng_all( ?, ?, ?, ?, ? )";
if (stmtReadAllBuff == null) {
stmtReadAllBuff = cnx.prepareStatement(sql);
}
int argIdx = 1;
stmtReadAllBuff.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtReadAllBuff.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecUserId().toString());
stmtReadAllBuff.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecSessionId().toString());
stmtReadAllBuff.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtReadAllBuff.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecTenantId());
try {
resultSet = stmtReadAllBuff.executeQuery();
} catch (SQLException e) {
if (e.getErrorCode() != 1329) {
throw e;
}
resultSet = null;
}
List<CFSecurityISOCountryLanguageBuff> buffList =
new LinkedList<CFSecurityISOCountryLanguageBuff>();
while ((resultSet != null) && resultSet.next()) {
CFSecurityISOCountryLanguageBuff buff = unpackISOCountryLanguageResultSetToBuff(resultSet);
buffList.add(buff);
}
int idx = 0;
CFSecurityISOCountryLanguageBuff[] retBuff =
new CFSecurityISOCountryLanguageBuff[buffList.size()];
Iterator<CFSecurityISOCountryLanguageBuff> iter = buffList.iterator();
while (iter.hasNext()) {
retBuff[idx++] = iter.next();
}
return (retBuff);
} catch (SQLException e) {
throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
} finally {
if (resultSet != null) {
try {
resultSet.close();
} catch (SQLException e) {
}
resultSet = null;
}
}
}
/**
* Returns the index of the source contact, in the list of recent messages.
*
* @param messageSourceContact
* @return
*/
int getIndex(MessageSourceContact messageSourceContact) {
synchronized (recentMessages) {
for (int i = 0; i < recentMessages.size(); i++)
if (recentMessages.get(i).equals(messageSourceContact)) return i;
return -1;
}
}
public int getMaxLogEntryRevision() {
if (isEmpty()) {
return -1;
}
List<LogEntry> logEntries = getOrderedLogEntries();
return logEntries.get(logEntries.size() - 1).getRevision();
}
public CFSecurityISOTimezoneBuff[] readBuffByOffsetIdx(
CFSecurityAuthorization Authorization, short TZHourOffset, short TZMinOffset) {
final String S_ProcName = "readBuffByOffsetIdx";
ResultSet resultSet = null;
try {
Connection cnx = schema.getCnx();
String sql =
"SELECT * FROM "
+ schema.getLowerDbSchemaName()
+ ".sp_read_isotz_by_offsetidx( ?, ?, ?, ?, ?"
+ ", "
+ "?"
+ ", "
+ "?"
+ " )";
if (stmtReadBuffByOffsetIdx == null) {
stmtReadBuffByOffsetIdx = cnx.prepareStatement(sql);
}
int argIdx = 1;
stmtReadBuffByOffsetIdx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtReadBuffByOffsetIdx.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecUserId().toString());
stmtReadBuffByOffsetIdx.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecSessionId().toString());
stmtReadBuffByOffsetIdx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtReadBuffByOffsetIdx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecTenantId());
stmtReadBuffByOffsetIdx.setShort(argIdx++, TZHourOffset);
stmtReadBuffByOffsetIdx.setShort(argIdx++, TZMinOffset);
resultSet = stmtReadBuffByOffsetIdx.executeQuery();
List<CFSecurityISOTimezoneBuff> buffList = new LinkedList<CFSecurityISOTimezoneBuff>();
while (resultSet.next()) {
CFSecurityISOTimezoneBuff buff = unpackISOTimezoneResultSetToBuff(resultSet);
buffList.add(buff);
}
int idx = 0;
CFSecurityISOTimezoneBuff[] retBuff = new CFSecurityISOTimezoneBuff[buffList.size()];
Iterator<CFSecurityISOTimezoneBuff> iter = buffList.iterator();
while (iter.hasNext()) {
retBuff[idx++] = iter.next();
}
return (retBuff);
} catch (SQLException e) {
throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
} finally {
if (resultSet != null) {
try {
resultSet.close();
} catch (SQLException e) {
}
resultSet = null;
}
}
}
public CFCrmMemoDataBuff[] readBuffByMemoDataCtcIdx(
CFSecurityAuthorization Authorization, long TenantId, long ContactId) {
final String S_ProcName = "readBuffByMemoDataCtcIdx";
ResultSet resultSet = null;
try {
Connection cnx = schema.getCnx();
String sql =
"{ call sp_read_memodata_by_memodatactcidx( ?, ?, ?, ?, ?"
+ ", "
+ "?"
+ ", "
+ "?"
+ " ) }";
if (stmtReadBuffByMemoDataCtcIdx == null) {
stmtReadBuffByMemoDataCtcIdx = cnx.prepareStatement(sql);
}
int argIdx = 1;
stmtReadBuffByMemoDataCtcIdx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtReadBuffByMemoDataCtcIdx.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecUserId().toString());
stmtReadBuffByMemoDataCtcIdx.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecSessionId().toString());
stmtReadBuffByMemoDataCtcIdx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtReadBuffByMemoDataCtcIdx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecTenantId());
stmtReadBuffByMemoDataCtcIdx.setLong(argIdx++, TenantId);
stmtReadBuffByMemoDataCtcIdx.setLong(argIdx++, ContactId);
resultSet = stmtReadBuffByMemoDataCtcIdx.executeQuery();
List<CFCrmMemoDataBuff> buffList = new LinkedList<CFCrmMemoDataBuff>();
if (resultSet != null) {
while (resultSet.next()) {
CFCrmMemoDataBuff buff = unpackMemoDataResultSetToBuff(resultSet);
buffList.add(buff);
}
}
int idx = 0;
CFCrmMemoDataBuff[] retBuff = new CFCrmMemoDataBuff[buffList.size()];
Iterator<CFCrmMemoDataBuff> iter = buffList.iterator();
while (iter.hasNext()) {
retBuff[idx++] = iter.next();
}
return (retBuff);
} catch (SQLException e) {
throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
} finally {
if (resultSet != null) {
try {
resultSet.close();
} catch (SQLException e) {
}
resultSet = null;
}
}
}
private String listSupportFiles(List<File> toDelete) throws Exception {
Formatter f = new Formatter();
try {
if (toDelete == null) {
toDelete = new ArrayList<File>();
}
int precount = toDelete.size();
File confFile = IO.getFile(platform.getConfigFile()).getCanonicalFile();
if (confFile.exists()) {
f.format(" * %s \t0 Config file%n", confFile);
toDelete.add(confFile);
}
String result = (toDelete.size() > precount) ? f.toString() : null;
return result;
} finally {
f.close();
}
}
/**
* Return a string that describes the statistics for the top n entries, sorted by descending
* order of total time spent dealing with the query. This will always include the totals entry
* in the first position.
*
* @param n the desired number of entries to describe
* @return a string describing the statistics for the top n entries
*/
public synchronized String toStringTop(int n) {
StringBuilder out = new StringBuilder();
List<Entry> list = entries();
if (list.isEmpty()) return "<no queries executed>";
Collections.sort(list, TOTAL_TIME_DESCENDING);
int maxCountLength = COUNT_FORMAT.format(list.get(0).numQueries).length();
double totalDuration = list.get(0).queryTime;
for (Entry entry : list.subList(0, Math.min(n, list.size())))
out.append(entry.toString(maxCountLength, totalDuration)).append('\n');
return out.toString();
}
public static void load(String libDir, String mainClass, String[] args) throws Exception {
Iterable<File> it = new FileIterator(libDir);
List<URL> jars = new ArrayList<URL>();
SimpleDateFormat sdf = new SimpleDateFormat("yyyy/MM/dd HH:mm:ss");
for (File f : it) {
if (f.isDirectory()) {
continue;
}
if (f.getName().toLowerCase().endsWith(".jar")) {
System.out.println(
"add " + f.getAbsolutePath() + " \t " + sdf.format(new Date(f.lastModified())));
jars.add(f.toURI().toURL());
}
}
System.out.println(
"jar cnt=" + jars.size() + " run " + mainClass + " " + Arrays.deepToString(args));
new URLClassLoader(jars.toArray(new URL[jars.size()]), Loader.class.getClassLoader())
.loadClass(mainClass)
.getMethod("main", new Class[] {String[].class})
.invoke(null, new Object[] {args});
}
public CFSecurityTSecGroupBuff[] readBuffByTenantVisIdx(
CFSecurityAuthorization Authorization, long TenantId, boolean IsVisible) {
final String S_ProcName = "readBuffByTenantVisIdx";
ResultSet resultSet = null;
try {
Connection cnx = schema.getCnx();
String sql = "exec sp_read_tsecgrp_by_tenantvisidx ?, ?, ?, ?, ?" + ", " + "?" + ", " + "?";
if (stmtReadBuffByTenantVisIdx == null) {
stmtReadBuffByTenantVisIdx = cnx.prepareStatement(sql);
}
int argIdx = 1;
stmtReadBuffByTenantVisIdx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtReadBuffByTenantVisIdx.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecUserId().toString());
stmtReadBuffByTenantVisIdx.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecSessionId().toString());
stmtReadBuffByTenantVisIdx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtReadBuffByTenantVisIdx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecTenantId());
stmtReadBuffByTenantVisIdx.setLong(argIdx++, TenantId);
if (IsVisible) {
stmtReadBuffByTenantVisIdx.setString(argIdx++, "Y");
} else {
stmtReadBuffByTenantVisIdx.setString(argIdx++, "N");
}
resultSet = stmtReadBuffByTenantVisIdx.executeQuery();
List<CFSecurityTSecGroupBuff> buffList = new LinkedList<CFSecurityTSecGroupBuff>();
while (resultSet.next()) {
CFSecurityTSecGroupBuff buff = unpackTSecGroupResultSetToBuff(resultSet);
buffList.add(buff);
}
int idx = 0;
CFSecurityTSecGroupBuff[] retBuff = new CFSecurityTSecGroupBuff[buffList.size()];
Iterator<CFSecurityTSecGroupBuff> iter = buffList.iterator();
while (iter.hasNext()) {
retBuff[idx++] = iter.next();
}
return (retBuff);
} catch (SQLException e) {
throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
} finally {
if (resultSet != null) {
try {
resultSet.close();
} catch (SQLException e) {
}
resultSet = null;
}
}
}
public CFSecurityISOLanguageBuff[] readBuffByCode2Idx(
CFSecurityAuthorization Authorization, String ISO6391Code) {
final String S_ProcName = "readBuffByCode2Idx";
ResultSet resultSet = null;
try {
Connection cnx = schema.getCnx();
final String sql = "CALL sp_read_iso_lang_by_code2idx( ?, ?, ?, ?, ?" + ", " + "?" + " )";
if (stmtReadBuffByCode2Idx == null) {
stmtReadBuffByCode2Idx = cnx.prepareStatement(sql);
}
int argIdx = 1;
stmtReadBuffByCode2Idx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtReadBuffByCode2Idx.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecUserId().toString());
stmtReadBuffByCode2Idx.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecSessionId().toString());
stmtReadBuffByCode2Idx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtReadBuffByCode2Idx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecTenantId());
if (ISO6391Code != null) {
stmtReadBuffByCode2Idx.setString(argIdx++, ISO6391Code);
} else {
stmtReadBuffByCode2Idx.setNull(argIdx++, java.sql.Types.VARCHAR);
}
resultSet = stmtReadBuffByCode2Idx.executeQuery();
List<CFSecurityISOLanguageBuff> buffList = new LinkedList<CFSecurityISOLanguageBuff>();
while (resultSet.next()) {
CFSecurityISOLanguageBuff buff = unpackISOLanguageResultSetToBuff(resultSet);
buffList.add(buff);
}
int idx = 0;
CFSecurityISOLanguageBuff[] retBuff = new CFSecurityISOLanguageBuff[buffList.size()];
Iterator<CFSecurityISOLanguageBuff> iter = buffList.iterator();
while (iter.hasNext()) {
retBuff[idx++] = iter.next();
}
return (retBuff);
} catch (SQLException e) {
throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
} finally {
if (resultSet != null) {
try {
resultSet.close();
} catch (SQLException e) {
}
resultSet = null;
}
}
}
private void swap(List y, List z, Random rdm) {
int count = 0;
for (int i = 0; i < y.size(); i++) {
double p = rdm.nextDouble();
if (p < 0.5) {
Object t = y.get(i);
y.set(i, z.get(i));
z.set(i, t);
count++;
}
} // end for i
// logger.info("swapped " + count + " out of " + y.size());
} // end swap
@RequestMapping(
value = "/getCityApi",
method = {RequestMethod.GET, RequestMethod.POST})
public String getCityApi(
HttpServletRequest request,
@RequestParam(value = "locationname") String locationname,
ModelMap model) {
Map<Object, Object> map = new HashMap<Object, Object>();
JSONArray jSONArray = new JSONArray();
try {
String status = "active";
List<City> cityList = cityService.getCityApi(locationname, status);
if (cityList != null && cityList.size() > 0) {
for (int i = 0; i < cityList.size(); i++) {
City city = (City) cityList.get(i);
String cityName = (String) city.getCity();
String stateName = (String) city.getState();
int ID = (Integer) (city.getId());
JSONObject jSONObject = new JSONObject();
jSONObject.put("id", ID);
jSONObject.put("text", cityName);
jSONArray.put(jSONObject);
}
utilities.setSuccessResponse(response, jSONArray.toString());
} else {
throw new ConstException(ConstException.ERR_CODE_NO_DATA, ConstException.ERR_MSG_NO_DATA);
}
} catch (Exception ex) {
logger.error("getCity :" + ex.getMessage());
utilities.setErrResponse(ex, response);
}
model.addAttribute("model", jSONArray.toString());
return "home";
}
public CFBamAccessFrequencyBuff[] readAllBuff(CFSecurityAuthorization Authorization) {
final String S_ProcName = "readAllBuff";
if (!schema.isTransactionOpen()) {
throw CFLib.getDefaultExceptionFactory()
.newUsageException(getClass(), S_ProcName, "Transaction not open");
}
ResultSet resultSet = null;
try {
Connection cnx = schema.getCnx();
final String sql = "CALL sp_read_accfreq_all( ?, ?, ?, ?, ? )";
if (stmtReadAllBuff == null) {
stmtReadAllBuff = cnx.prepareStatement(sql);
}
int argIdx = 1;
stmtReadAllBuff.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtReadAllBuff.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecUserId().toString());
stmtReadAllBuff.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecSessionId().toString());
stmtReadAllBuff.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtReadAllBuff.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecTenantId());
resultSet = stmtReadAllBuff.executeQuery();
List<CFBamAccessFrequencyBuff> buffList = new LinkedList<CFBamAccessFrequencyBuff>();
while (resultSet.next()) {
CFBamAccessFrequencyBuff buff = unpackAccessFrequencyResultSetToBuff(resultSet);
buffList.add(buff);
}
int idx = 0;
CFBamAccessFrequencyBuff[] retBuff = new CFBamAccessFrequencyBuff[buffList.size()];
Iterator<CFBamAccessFrequencyBuff> iter = buffList.iterator();
while (iter.hasNext()) {
retBuff[idx++] = iter.next();
}
return (retBuff);
} catch (SQLException e) {
throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
} finally {
if (resultSet != null) {
try {
resultSet.close();
} catch (SQLException e) {
}
resultSet = null;
}
}
}
/**
* Get the average value for the index. The list must be a list of String arrays.
*
* @param list List: the list to average
* @param index int: the index to average
* @param precision int: the result decimal precision
* @return String: the average as a string
*/
public static String average(List list, int index, int precision) {
double d = 0.0;
int size = list.size();
for (int i = 0; i < size; i++) {
String[] sa = (String[]) list.get(i);
if (!sa[index].equals("")) {
d += Double.parseDouble(sa[index]);
}
}
NumberFormat nf = NumberFormat.getInstance();
nf.setMaximumFractionDigits(precision);
nf.setMinimumFractionDigits(precision);
nf.setMinimumIntegerDigits(1);
return nf.format(d / size);
}