/** Concatenate params for URL string */
static String concatParams(String p1, String p2) {
if (StringUtil.isNullString(p1)) {
return p2;
}
if (StringUtil.isNullString(p2)) {
return p1;
}
return p1 + "&" + p2;
}
/**
* Did the client provide the minimal parameters required?
*
* @return true If so
*/
private boolean verifyMinimumParameters() {
int count = 0;
if (!StringUtil.isNullString(getParameter(AP_E_PUBLICATION))) count++;
if (!StringUtil.isNullString(getParameter(AP_E_CLASSNAME))) count++;
if (!StringUtil.isNullString(getParameter(AP_E_PLUGIN))) count++;
return (count > 0);
}
/** Concatenate params for URL string */
String concatParams(Properties props) {
if (props == null) {
return null;
}
java.util.List list = new ArrayList();
for (Iterator iter = props.keySet().iterator(); iter.hasNext(); ) {
String key = (String) iter.next();
String val = props.getProperty(key);
if (!StringUtil.isNullString(val)) {
list.add(key + "=" + urlEncode(val));
}
}
return StringUtil.separatedString(list, "&");
}
/**
* A target system is required to create an AU - was it provided?
*
* @return true If at least one target was specified
*/
private boolean verifyTarget() {
if (!isCreateCommand()) {
return true;
}
return !StringUtil.isNullString(getParameter(AP_E_TARGET));
}
protected void logParams() {
Enumeration en = req.getParameterNames();
while (en.hasMoreElements()) {
String name = (String) en.nextElement();
String vals[];
String dispval;
if (StringUtil.indexOfIgnoreCase(name, "passw") >= 0) {
dispval = req.getParameter(name).length() == 0 ? "" : "********";
} else if (log.isDebug2() && (vals = req.getParameterValues(name)).length > 1) {
dispval = StringUtil.separatedString(vals, ", ");
} else {
dispval = req.getParameter(name);
}
log.debug(name + " = " + dispval);
}
}
/**
* Add javascript to page. Normally adds a link to the script file, but can be told to include the
* script directly in the page, to accomodate unit testing of individual servlets, when other
* fetches won't work.
*/
protected void addJavaScript(Composite comp) {
String include = (String) context.getAttribute(ATTR_INCLUDE_SCRIPT);
if (StringUtil.isNullString(include)) {
linkToJavaScript(comp);
} else {
includeJavaScript0(comp);
}
}
public String getPageIds(ClientRequest cr) {
HttpSession session = cr.getServletRequest().getSession();
PageState.AllPageInfo info = (PageState.AllPageInfo) session.getAttribute("fiz.PageState");
if (info == null) {
return "";
}
Object[] keys = info.keySet().toArray();
Arrays.sort(keys);
return StringUtil.join(keys, ", ");
}
private static synchronized String getJavascript() {
if (jstext == null) {
InputStream istr = null;
try {
ClassLoader loader = Thread.currentThread().getContextClassLoader();
istr = loader.getResourceAsStream(JAVASCRIPT_RESOURCE);
jstext = StringUtil.fromInputStream(istr);
istr.close();
} catch (Exception e) {
log.error("Can't load javascript", e);
} finally {
IOUtil.safeClose(istr);
}
}
return jstext;
}
/**
* Return a (possibly labelled) checkbox.
*
* @param label appears to right of checkbox if non null
* @param value value included in result set if box checked
* @param key form key to which result set is assigned
* @param checked if true, box is initially checked
* @return a checkbox Element
*/
Element checkBox(String label, String value, String key, boolean checked) {
Input in = new Input(Input.Checkbox, key, value);
if (checked) {
in.check();
}
setTabOrder(in);
if (StringUtil.isNullString(label)) {
return in;
} else {
Composite c = new Composite();
c.add(in);
c.add(" ");
c.add(label);
return c;
}
}
/**
* Are all of the "defining parameters" required to create an AU available?
*
* @return true If so
*/
private boolean verifyDefiningParameters() {
KeyedList parameters;
int size;
if (!isCreateCommand()) {
return true;
}
parameters = ParseUtils.getDynamicFields(getXmlUtils(), getRequestDocument(), AP_MD_AUDEFINING);
size = parameters.size();
for (int i = 0; i < size; i++) {
if (StringUtil.isNullString((String) parameters.getValue(i))) {
return false;
}
}
return true;
}
// 一周内的污染源在线脱机联机报表
public static void run7(HttpServletRequest req) throws Exception {
String gas_station_type = "2";
String water_station_type = "1";
String so2_col = "val01";
String cod_col = "val02";
Connection cn = null;
String sql = null;
List list = new ArrayList(); // 存储这周内的数据
List list2 = new ArrayList(); // 存储今天的数据
List list3 = new ArrayList(); // 存储脱机的数据
List l_temp = null;
List td_temp = null; // 存储今天的数据
String kv = null;
String kv_2 = null;
Map tmp = null;
Map tmp_2 = null;
Map tmp2 = new HashMap();
Map tmp3 = new HashMap();
Map data = null; // 存这周内有数据的站位
Map data2 = null; // 存储今天的数据
Map data3 = null; // 存储这周脱机的站位
List waterStationList = null;
List gasStationList = null;
// String date = req.getParameter("date");
String now = StringUtil.getNowDate() + "";
// String now = req.getParameter("date")+"";//黄宝修改
String date1, date2 = null;
// 从现在开始，退后7天。
Calendar cal = Calendar.getInstance();
Calendar cal2 = Calendar.getInstance();
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
cal.setTime(cal.getTime());
cal.add(Calendar.DAY_OF_MONTH, -7); // 退后7天
String now_7 = sdf.format(cal.getTime());
cal2.setTime(cal2.getTime());
cal2.add(Calendar.DAY_OF_MONTH, -1); // 退后1天
String now_1 = sdf.format(cal2.getTime()) + " 23:59:59";
;
date1 = sdf.format(cal2.getTime()) + " 23:59:59";
date2 = now_7 + "";
Map areaMap = null;
Map bean = new HashMap();
int i, num = 0;
Map m = null;
String area_id = null;
try {
area_id = req.getParameter("area_id");
if (area_id == null) {
area_id = "";
}
// date1 = req.getParameter("date1");
// date1 = req.getParameter("date1");
sql =
"select station_id,m_time,"
+ so2_col
+ ","
+ cod_col
+ " from "
+ req.getParameter("tableName");
sql = sql + " where m_time>='" + date2 + "' and m_time<='" + date1 + "'";
sql = sql + " and station_id in (";
sql =
sql
+ "select station_id from t_cfg_station_info where station_type in ('1','2') and area_id like '"
+ area_id
+ "%') order by m_time desc";
// System.out.println(sql);
cn = f.getConn();
// System.out.println(sql);
l_temp = f.query(cn, sql, null); // 最近一周的数据
num = l_temp.size();
for (i = 0; i < num; i++) {
tmp = (Map) l_temp.get(i);
kv = (String) tmp.get("station_id");
String station_id_t = (String) tmp2.get(kv);
if ("".equals(station_id_t) || station_id_t == null) {
list.add(tmp); // 最近一周都有的数据
tmp2.put(kv, kv);
}
}
// data = f.getListMap(list,"station_id");//最近一周都有的数据
// 查询今天有数据的站位
String now_time = StringUtil.getNowDate() + "";
date1 = now_time + "";
date2 = now_time + " 23:59:59";
sql =
"select station_id,m_time,"
+ so2_col
+ ","
+ cod_col
+ " from "
+ req.getParameter("tableName");
sql = sql + " where m_time>='" + date1 + "' and m_time<='" + date2 + "'";
sql = sql + " and station_id in (";
sql =
sql
+ "select station_id from t_cfg_station_info where station_type in ('1','2') and area_id like '"
+ area_id
+ "%') order by m_time desc";
td_temp = f.query(cn, sql, null); // 今天的数据
tmp2 = null;
num = td_temp.size();
for (i = 0; i < num; i++) {
tmp = (Map) td_temp.get(i);
kv = (String) tmp.get("station_id");
String station_id_t = (String) tmp3.get(kv);
if ("".equals(station_id_t) || station_id_t == null) {
list2.add(tmp); // 今天有数据的站位。
tmp3.put(kv, kv);
}
}
// 循环这一周内有数据的站位列表list，如果list中的站位不能在今天的站位信息列表中list2中找到的话，则表明是脱机
num = list.size();
int j = 0;
int num2 = list2.size();
String station_id_1 = "";
String station_id_2 = "";
int l = 0;
for (i = 0; i < num; i++) {
tmp = (Map) list.get(i);
station_id_1 = (String) tmp.get("station_id");
l = 0;
for (j = 0; j < num2; j++) {
tmp_2 = (Map) list2.get(j);
station_id_2 = (String) tmp_2.get("station_id");
if (station_id_1.equals(station_id_2)) {
l++;
}
}
if (l == 0) {
list3.add(tmp);
}
}
data = f.getListMap(list3, "station_id"); // 这周脱机的站位信息列表
l_temp = null;
tmp = null;
list2 = null;
list3 = null;
tmp_2 = null;
tmp3 = null;
sql =
"select station_id,station_desc,ep_type,area_id,station_bz from t_cfg_station_info where station_type='1' and area_id like '"
+ area_id
+ "%' order by area_id,station_desc";
waterStationList = f.query(cn, sql, null);
// System.out.println(sql);
sql =
"select station_id,station_desc,ep_type,area_id from t_cfg_station_info where station_type='2' and area_id like '"
+ area_id
+ "%' order by area_id,station_desc";
gasStationList = f.query(cn, sql, null);
// System.out.println(sql);
sql = "select area_id,area_name from t_cfg_area";
areaMap = f.getMap(cn, sql);
// System.out.println(sql);
num = waterStationList.size();
for (i = 0; i < num; i++) {
m = (Map) waterStationList.get(i);
area_id = (String) m.get("area_id");
m.put("area_name", areaMap.get(area_id));
}
num = gasStationList.size();
for (i = 0; i < num; i++) {
m = (Map) gasStationList.get(i);
area_id = (String) m.get("area_id");
m.put("area_name", areaMap.get(area_id));
}
// System.out.println("before close,cn="+cn);
f.close(cn);
// System.out.println("after close,cn="+cn);
int waterOnlineNum, gasOnlineNum, onlineNum = 0;
int waterOfflineNum, gasOfflineNum, offlineNum = 0;
int waterOfflineNumNation, gasOfflineNumNation, offlineNumNation = 0;
int waterZeroNum, gasZeroNum, zeroNum = 0;
int waterZeroNumNation, gasZeroNumNation, zeroNumNation = 0;
waterOnlineNum = OnlineReport.getOnlineNum(waterStationList, data);
gasOnlineNum = OnlineReport.getOnlineNum(gasStationList, data);
onlineNum = waterOnlineNum + gasOnlineNum;
// System.out.println(onlineNum);
waterOfflineNum = OnlineReport.getOfflineNum(waterStationList, data);
gasOfflineNum = OnlineReport.getOfflineNum(gasStationList, data);
offlineNum = waterOfflineNum + gasOfflineNum;
// System.out.println("zeroNumNation "+zeroNumNation);
waterOfflineNumNation = OnlineReport.getOfflineNumNation(waterStationList, data);
gasOfflineNumNation = OnlineReport.getOfflineNumNation(gasStationList, data);
offlineNumNation = waterOfflineNumNation + gasOfflineNumNation;
// System.out.println("offlineNumNation "+offlineNumNation);
waterZeroNum = OnlineReport.getZeroNum(waterStationList, data, cod_col);
gasZeroNum = OnlineReport.getZeroNum(gasStationList, data, so2_col);
zeroNum = waterZeroNum + gasZeroNum;
// System.out.println(zeroNum);
waterZeroNumNation = OnlineReport.getZeroNumNation(waterStationList, data, cod_col);
gasZeroNumNation = OnlineReport.getZeroNumNation(gasStationList, data, so2_col);
zeroNumNation = waterZeroNumNation + gasZeroNumNation;
// System.out.println(zeroNumNation);
bean.put("waterOnlineNum", waterOnlineNum + "");
bean.put("gasOnlineNum", gasOnlineNum + "");
bean.put("onlineNum", onlineNum + "");
bean.put("waterOfflineNum", waterOfflineNum + "");
bean.put("gasOfflineNum", gasOfflineNum + "");
bean.put("offlineNum", offlineNum + "");
bean.put("waterOfflineNumNation", waterOfflineNumNation + "");
bean.put("gasOfflineNumNation", gasOfflineNumNation + "");
bean.put("offlineNumNation", offlineNumNation + "");
bean.put("waterZeroNum", waterZeroNum + "");
bean.put("gasZeroNum", gasZeroNum + "");
bean.put("zeroNum", zeroNum + "");
bean.put("waterZeroNumNation", waterZeroNumNation + "");
bean.put("gasZeroNumNation", gasZeroNumNation + "");
bean.put("zeroNumNation", zeroNumNation + "");
date1 = now_7;
date2 = StringUtil.getNowDate() + "";
bean.put("date1", date2);
bean.put("date2", date1);
req.setAttribute("bean", bean);
list = getOfflineList2(waterStationList, data);
req.setAttribute("waterOfflineList", list);
list = getOfflineList2(gasStationList, data);
req.setAttribute("gasOfflineList", list);
list = getOfflineListNation(waterStationList, data);
req.setAttribute("waterOfflineListNation", list);
list = getOfflineListNation(gasStationList, data);
req.setAttribute("gasOfflineListNation", list);
list = getZeroListNation(waterStationList, data, cod_col);
req.setAttribute("waterZeroListNation", list);
list = getZeroListNation(gasStationList, data, so2_col);
req.setAttribute("gasZeroListNation", list);
} catch (Exception e) {
throw e;
} finally {
f.close(cn);
}
}
/** Query the daemon for information required to set up this command */
private boolean commandSetup() {
Configuration configuration = null;
Collection noEditKeys = null;
String key;
String value;
/*
* Configure a well known publication?
*/
if ((value = getParameter(AP_E_PUBLICATION)) != null) {
PluginProxy plugin = getTitlePlugin(value);
/*
* Set plugin and Title configuration information
*/
if (plugin == null) {
String message = "Unknown Publication:" + value;
log.warning(message);
return error(message);
}
setPlugin(plugin);
setTitleConfig(plugin.getTitleConfig(value));
configuration = getTitleConfig().getConfig();
noEditKeys = getNoEditKeys();
} else {
/*
* Lookup by Plugin or Class name - set the plugin
*
* NB: As of 23-Feb-04, this is not supported from AddAuPage.java. See
* AddAuWithCompleteFunctionalityPage.java for full support.
*/
if ((value = getParameter(AP_E_PLUGIN)) != null) {
key = RemoteApi.pluginKeyFromId(value);
} else if ((value = getParameter(AP_E_CLASSNAME)) != null) {
key = RemoteApi.pluginKeyFromId(value);
} else {
return error("Supply a Publication, Plugin, or Class name");
}
if (StringUtil.isNullString(key)) {
return error("Supply a valid Publication, Plugin, or Class name");
}
if (!pluginLoaded(key)) {
return error("Plugin is not loaded: " + key);
}
setPlugin(getPluginProxy(key));
}
/*
* Finally, return an XML rendition of the Plugin and AU key set up
*/
generateSetupXml(configuration, noEditKeys);
return true;
}
protected boolean hasNoRoleParsm(String roleName) {
String noRoleParam = noRoleParams.get(roleName);
return (noRoleParam != null && !StringUtil.isNullString(req.getParameter(noRoleParam)));
}
/** Common request handling. */
public void service(HttpServletRequest req, HttpServletResponse resp)
throws ServletException, IOException {
resetState();
boolean success = false;
HttpSession session = req.getSession(false);
try {
this.req = req;
this.resp = resp;
if (log.isDebug()) {
logParams();
}
resp.setContentType("text/html");
if (!mayPageBeCached()) {
resp.setHeader("pragma", "no-cache");
resp.setHeader("Cache-control", "no-cache");
}
reqURL = new URL(UrlUtil.getRequestURL(req));
clientAddr = getLocalIPAddr();
// check that current user has permission to run this servlet
if (!isServletAllowed(myServletDescr())) {
displayWarningInLieuOfPage("You are not authorized to use " + myServletDescr().heading);
return;
}
// check whether servlet is disabled
String reason = ServletUtil.servletDisabledReason(myServletDescr().getServletName());
if (reason != null) {
displayWarningInLieuOfPage("This function is disabled. " + reason);
return;
}
if (session != null) {
session.setAttribute(SESSION_KEY_RUNNING_SERVLET, getHeading());
String reqHost = req.getRemoteHost();
String forw = req.getHeader(HttpFields.__XForwardedFor);
if (!StringUtil.isNullString(forw)) {
reqHost += " (proxies for " + forw + ")";
}
session.setAttribute(SESSION_KEY_REQUEST_HOST, reqHost);
}
lockssHandleRequest();
success = (errMsg == null);
} catch (ServletException e) {
log.error("Servlet threw", e);
throw e;
} catch (IOException e) {
log.error("Servlet threw", e);
throw e;
} catch (RuntimeException e) {
log.error("Servlet threw", e);
throw e;
} finally {
if (session != null) {
session.setAttribute(SESSION_KEY_RUNNING_SERVLET, null);
session.setAttribute(LockssFormAuthenticator.__J_AUTH_ACTIVITY, TimeBase.nowMs());
}
if ("please".equalsIgnoreCase(req.getHeader("X-Lockss-Result"))) {
log.debug3("X-Lockss-Result: " + (success ? "Ok" : "Fail"));
resp.setHeader("X-Lockss-Result", success ? "Ok" : "Fail");
}
resetMyLocals();
resetLocals();
}
}
public String getPropertyNames(PageState state) {
Object[] keys = state.properties.keySet().toArray();
Arrays.sort(keys);
return StringUtil.join(keys, ", ");
}
