/**
* 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);
}
}
/**
* Returns paths constructed by rewriting pathInfo using rules from the hosted site's mappings.
* Paths are ordered from most to least specific match.
*
* @param site The hosted site.
* @param pathInfo Path to be rewritten.
* @param queryString
* @return The rewritten path. May be either:
* <ul>
* <li>A path to a file in the Orion workspace, eg. <code>/ProjectA/foo/bar.txt</code>
* <li>An absolute URL pointing to another site, eg. <code>http://foo.com/bar.txt</code>
* </ul>
*
* @return The rewritten paths.
* @throws URISyntaxException
*/
private URI[] getMapped(IHostedSite site, IPath pathInfo, String queryString)
throws URISyntaxException {
final Map<String, List<String>> map = site.getMappings();
final IPath originalPath = pathInfo;
IPath path = originalPath.removeTrailingSeparator();
List<URI> uris = new ArrayList<URI>();
String rest = null;
final int count = path.segmentCount();
for (int i = 0; i <= count; i++) {
List<String> base = map.get(path.toString());
if (base != null) {
rest = originalPath.removeFirstSegments(count - i).toString();
for (int j = 0; j < base.size(); j++) {
URI uri =
rest.equals("") ? new URI(base.get(j)) : URIUtil.append(new URI(base.get(j)), rest);
uris.add(
new URI(
uri.getScheme(),
uri.getUserInfo(),
uri.getHost(),
uri.getPort(),
uri.getPath(),
queryString,
uri.getFragment()));
}
}
path = path.removeLastSegments(1);
}
if (uris.size() == 0)
// No mapping for /
return null;
else return uris.toArray(new URI[uris.size()]);
}
public void init() throws ServletException {
super.init();
// allow = ThreddsConfig.getBoolean("NetcdfSubsetService.allow", true);
// String radarLevel2Dir = ThreddsConfig.get("NetcdfSubsetService.radarLevel2DataDir",
// "/data/ldm/pub/native/radar/level2/");
// if (!allow) return;
contentPath = ServletUtil.getContentPath();
rm = new RadarMethods(contentPath, logServerStartup);
// read in radarCollections.xml catalog
InvCatalogFactory factory = InvCatalogFactory.getDefaultFactory(false); // no validation
cat = readCatalog(factory, getPath() + catName, contentPath + getPath() + catName);
if (cat == null) {
logServerStartup.info("cat initialization failed");
return;
}
// URI tmpURI = cat.getBaseURI();
cat.setBaseURI(catURI);
// get path and location from cat
List parents = cat.getDatasets();
for (int i = 0; i < parents.size(); i++) {
InvDataset top = (InvDataset) parents.get(i);
datasets = top.getDatasets(); // dataset scans
for (int j = 0; j < datasets.size(); j++) {
InvDatasetScan ds = (InvDatasetScan) datasets.get(j);
if (ds.getPath() != null) {
dataLocation.put(ds.getPath(), ds.getScanLocation());
logServerStartup.info("path =" + ds.getPath() + " location =" + ds.getScanLocation());
}
ds.setXlinkHref(ds.getPath() + "/dataset.xml");
}
}
logServerStartup.info(getClass().getName() + " initialization complete ");
} // end init
/**
* Returns the values of the named parameter as a String array, or null if the parameter was not
* sent. The array has one entry for each parameter field sent. If any field was sent without a
* value that entry is stored in the array as a null. The values are guaranteed to be in their
* normal, decoded form. A single value is returned as a one-element array.
*
* @param name the parameter name.
* @return the parameter values.
*/
public String[] getParameterValues(String name) {
List<String> values = parameters.get(name);
if (values == null || values.size() == 0) {
return null;
} else {
return values.toArray(new String[values.size()]);
}
}
/**
* Returns the value of the named parameter as a String, or null if the parameter was not sent or
* was sent without a value. The value is guaranteed to be in its normal, decoded form. If the
* parameter has multiple values, only the last one is returned (for backward compatibility). For
* parameters with multiple values, it's possible the last "value" may be null.
*
* @param name the parameter name.
* @return the parameter value.
*/
public String getParameter(String name) {
try {
List<String> values = parameters.get(name);
if (values == null || values.size() == 0) {
return null;
}
return values.get(values.size() - 1);
} catch (Exception e) {
return null;
}
}
protected static int processGet() throws NimbitsException {
final List<Entity> points = EntityServiceFactory.getInstance().getIdleEntities();
log.info("Processing " + points.size() + " potentially idle points");
for (final Entity p : points) {
try {
checkIdle((Point) p);
} catch (NimbitsException e) {
LogHelper.logException(IdlePointCron.class, e);
}
}
return points.size();
}
public static UIComponent findPersistent(
FacesContext context, ServletRequest req, UIComponent parent, String id) throws Exception {
if (context == null) context = FacesContext.getCurrentInstance();
BodyContent body = null;
if (parent == null) {
UIComponentClassicTagBase parentTag =
(UIComponentClassicTagBase) req.getAttribute("caucho.jsf.parent");
parent = parentTag.getComponentInstance();
body = parentTag.getBodyContent();
}
if (parent != null) {
List<UIComponent> children = parent.getChildren();
int size = children.size();
String prevId = null;
for (int i = 0; i < size; i++) {
UIComponent child = children.get(i);
if (id.equals(child.getId())) {
if (body != null) addVerbatim(parent, prevId, body);
return child;
}
if (child.getId() != null) prevId = child.getId();
}
}
return null;
}
void setFormData(WObject.FormData formData) {
if (!(formData.values.length == 0)) {
List<String> attributes = new ArrayList<String>();
attributes = new ArrayList<String>(Arrays.asList(formData.values[0].split(";")));
if (attributes.size() == 6) {
try {
this.volume_ = Double.parseDouble(attributes.get(0));
} catch (RuntimeException e) {
this.volume_ = -1;
}
try {
this.current_ = Double.parseDouble(attributes.get(1));
} catch (RuntimeException e) {
this.current_ = -1;
}
try {
this.duration_ = Double.parseDouble(attributes.get(2));
} catch (RuntimeException e) {
this.duration_ = -1;
}
this.playing_ = attributes.get(3).equals("0");
this.ended_ = attributes.get(4).equals("1");
try {
this.readyState_ = intToReadyState(Integer.parseInt(attributes.get(5)));
} catch (RuntimeException e) {
throw new WException(
"WAbstractMedia: error parsing: " + formData.values[0] + ": " + e.toString());
}
} else {
throw new WException("WAbstractMedia: error parsing: " + formData.values[0]);
}
}
}
public static boolean isZero(List list, String col) {
if (list == null) {
return false;
}
boolean b = false;
int i, num = 0;
String v = null;
Map m = null;
double dv = 0;
num = list.size();
for (i = 0; i < num; i++) {
m = (Map) list.get(i);
v = (String) m.get(col);
// if(f.empty(v)){return true;}
if (f.empty(v)) {
continue;
}
// System.out.println(v);
v = f.v(v);
dv = f.getDouble(v, 0);
// if(dv==0){return true;}
if (dv > 0) {
return false;
}
b = true;
}
return b;
}
static void decodeTouches(String str, List<Touch> result) {
if (str.length() == 0) {
return;
}
List<String> s = new ArrayList<String>();
s = new ArrayList<String>(Arrays.asList(str.split(";")));
if (s.size() % 9 != 0) {
logger.error(
new StringWriter()
.append("Could not parse touches array '")
.append(str)
.append("'")
.toString());
return;
}
try {
for (int i = 0; i < s.size(); i += 9) {
result.add(
new Touch(
asUInt(s.get(i + 0)),
asInt(s.get(i + 1)),
asInt(s.get(i + 2)),
asInt(s.get(i + 3)),
asInt(s.get(i + 4)),
asInt(s.get(i + 5)),
asInt(s.get(i + 6)),
asInt(s.get(i + 7)),
asInt(s.get(i + 8))));
}
} catch (NumberFormatException ee) {
logger.error(
new StringWriter()
.append("Could not parse touches array '")
.append(str)
.append("'")
.toString());
return;
}
}
@Test
public void receiveAnOrder() throws Exception {
when(request.getMethod()).thenReturn("POST");
when(request.getRequestURI()).thenReturn("/orders");
when(request.getParameter("order_code")).thenReturn("1234");
when(request.getParameter("article_code")).thenReturn("ABCD");
when(request.getParameter("address")).thenReturn("Some Place");
ordersController.service();
assertEquals(1, orders.size());
assertEquals(new Order("1234", "ABCD", "Some Place"), orders.get(0));
}
public StringBuilder listToCSV(List list) {
StringBuilder csv = new StringBuilder();
csv.append(
"Work Product,,Name,State,Owner,Plan Estimate,Task Estimate,Task Remaining,Time Spent\n");
for (int i = 0; i < list.size(); i++) {
Map map = (Map) list.get(i);
String type = (String) map.get("type");
String formattedId = (String) map.get("formattedId");
String name = (String) map.get("name");
String taskStatus = (String) map.get("taskStatus");
String owner = (String) map.get("owner");
String planEstimate = (String) map.get("planEstimate");
String taskEstimateTotal = (String) map.get("taskEstimateTotal");
String taskRemainingTotal = (String) map.get("taskRemainingTotal");
String taskTimeSpentTotal = (String) map.get("taskTimeSpentTotal");
if ("task".equals(type)) {
csv.append("," + formattedId + ",");
} else if ("userstory".equals(type)) {
csv.append(formattedId + ",,");
} else if ("iteration".equals(type)) {
csv.append(",,");
}
if (planEstimate == null) {
planEstimate = "";
}
if (taskEstimateTotal == null) {
taskEstimateTotal = "";
}
if (taskRemainingTotal == null) {
taskRemainingTotal = "";
}
csv.append("\"" + name + "\",");
csv.append(taskStatus + ",");
csv.append(owner + ",");
csv.append(planEstimate + ",");
csv.append(taskEstimateTotal + ",");
csv.append(taskRemainingTotal + ",");
csv.append(taskTimeSpentTotal + "\n");
}
return csv;
}
private void expand(int row, int column, int rowSpan, int columnSpan) {
int newRowCount = Math.max(this.getRowCount(), row + rowSpan);
int newColumnCount = Math.max(this.getColumnCount(), column + columnSpan);
int extraRows = newRowCount - this.getRowCount();
int extraColumns = newColumnCount - this.getColumnCount();
if (extraColumns > 0) {
for (int a_row = 0; a_row < this.getRowCount(); ++a_row) {
{
int insertPos = this.grid_.items_.get(a_row).size();
for (int ii = 0; ii < (extraColumns); ++ii)
this.grid_.items_.get(a_row).add(insertPos + ii, new Grid.Item());
}
;
}
{
int insertPos = this.grid_.columns_.size();
for (int ii = 0; ii < (extraColumns); ++ii)
this.grid_.columns_.add(insertPos + ii, new Grid.Section());
}
;
}
if (extraRows > 0) {
{
int insertPos = this.grid_.items_.size();
for (int ii = 0; ii < (extraRows); ++ii)
this.grid_.items_.add(insertPos + ii, new ArrayList<Grid.Item>());
}
;
for (int i = 0; i < extraRows; ++i) {
final List<Grid.Item> items =
this.grid_.items_.get(this.grid_.items_.size() - extraRows + i);
{
int insertPos = items.size();
for (int ii = 0; ii < (newColumnCount); ++ii) items.add(insertPos + ii, new Grid.Item());
}
;
}
{
int insertPos = this.grid_.rows_.size();
for (int ii = 0; ii < (extraRows); ++ii)
this.grid_.rows_.add(insertPos + ii, new Grid.Section());
}
;
}
}
private static void addChild(UIComponent parent, String prevId, UIComponent child) {
if (parent != null) {
List<UIComponent> children = parent.getChildren();
int size = children.size();
boolean hasPrev = prevId == null;
int i = 0;
for (; i < size; i++) {
UIComponent oldChild = children.get(i);
if (hasPrev && oldChild.getId() != null) {
children.add(i, child);
return;
} else if (prevId != null && prevId.equals(oldChild.getId())) hasPrev = true;
}
parent.getChildren().add(child);
}
}
public static int getZeroNum(List stationList, Map data, String col) {
int num = 0;
int i, stationNum = 0;
String station_id = null;
List list = null;
String ep_type = null;
Map m = null;
stationNum = stationList.size();
for (i = 0; i < stationNum; i++) {
m = (Map) stationList.get(i);
station_id = (String) m.get("station_id");
ep_type = (String) m.get("ep_type");
list = (List) data.get(station_id);
if (isZero(list, col)) {
num++;
}
}
return num;
}
public static List getOfflineList2(List stationList, Map data) {
List list = new ArrayList();
int i, stationNum = 0;
String station_id = null;
List tmp = null;
Map m = null;
stationNum = stationList.size();
for (i = 0; i < stationNum; i++) {
m = (Map) stationList.get(i);
station_id = (String) m.get("station_id");
tmp = (List) data.get(station_id);
if (tmp != null) {
list.add(m);
}
}
return list;
}
public static int getOfflineNum(List stationList, Map data) {
int num = 0;
int stationNum = 0;
int i = 0;
Map m = null;
String station_id = null;
List list = null;
stationNum = stationList.size();
for (i = 0; i < stationNum; i++) {
m = (Map) stationList.get(i);
station_id = (String) m.get("station_id");
list = (List) data.get(station_id);
if (list == null) {
num++;
}
}
return num;
}
/** Access catalog component and retrieve transportation data from the database */
public List searchTransportation(String origin, String destination, Locale locale)
throws HTMLActionException {
List transportation = null;
List transportationBean = new ArrayList();
// call catalog component
try {
CatalogFacade catalogFacade = new CatalogFacade();
transportation = catalogFacade.getTransportations(origin, destination, locale);
// Catch catalog exceptions and re-throw them as
// mini-app application defined exceptions.
} catch (Exception e) {
throw new HTMLActionException(
"Transportation Search Exception:: Catalog Exception accessing catalog component: " + e);
}
for (int i = 0; i < transportation.size(); ++i) {
transportationBean.add(
new TransportationBean(
((com.sun.j2ee.blueprints.catalog.Transportation) transportation.get(i))
.getTransportationId(),
((com.sun.j2ee.blueprints.catalog.Transportation) transportation.get(i)).getName(),
((com.sun.j2ee.blueprints.catalog.Transportation) transportation.get(i))
.getDescription(),
((com.sun.j2ee.blueprints.catalog.Transportation) transportation.get(i))
.getImageURI(),
((com.sun.j2ee.blueprints.catalog.Transportation) transportation.get(i)).getPrice(),
((com.sun.j2ee.blueprints.catalog.Transportation) transportation.get(i)).getOrigin(),
((com.sun.j2ee.blueprints.catalog.Transportation) transportation.get(i))
.getDestination(),
((com.sun.j2ee.blueprints.catalog.Transportation) transportation.get(i)).getCarrier(),
((com.sun.j2ee.blueprints.catalog.Transportation) transportation.get(i))
.getDepartureTime(),
((com.sun.j2ee.blueprints.catalog.Transportation) transportation.get(i))
.getArrivalTime(),
((com.sun.j2ee.blueprints.catalog.Transportation) transportation.get(i))
.getTravelClass()));
}
return transportationBean;
}
public StringBuilder listToCSVForUserView(List list) {
StringBuilder csv = new StringBuilder();
csv.append(
"Project,Iteration,Work Product,Name,State,Owner,Task Estimate,Task Remaining,Time Spent\n");
for (int i = 0; i < list.size(); i++) {
Map map = (Map) list.get(i);
String projectName = (String) map.get("projectName");
String iterationName = (String) map.get("iterationName");
String formattedId = (String) map.get("taskFormattedId");
String taskName = (String) map.get("taskName");
String taskState = (String) map.get("taskState");
String owner = (String) map.get("owner");
String taskEstimate = (String) map.get("taskEstimate");
String taskRemaining = (String) map.get("taskRemaining");
String taskTimeSpent = (String) map.get("hours");
if (taskEstimate == null) {
taskEstimate = "";
}
if (taskRemaining == null) {
taskRemaining = "";
}
csv.append("" + projectName + ",");
csv.append("\"" + iterationName + "\",");
csv.append(formattedId + ",");
csv.append(taskName + ",");
csv.append(taskState + ",");
csv.append(owner + ",");
csv.append(taskEstimate + ",");
csv.append(taskRemaining + ",");
csv.append(taskTimeSpent + "\n");
}
return csv;
}
public String buildServiceOptions(String rule) throws SQLException {
List services = NotificationFactory.getInstance().getServiceNames();
Collections.sort(
services,
new Comparator() {
public int compare(Object o1, Object o2) {
return ((String) o1).compareToIgnoreCase((String) o2);
}
});
StringBuffer buffer = new StringBuffer();
for (int i = 0; i < services.size(); i++) {
if (rule != null && rule.indexOf((String) services.get(i)) > 0) {
buffer.append(
"<option selected VALUE='" + services.get(i) + "'>" + services.get(i) + "</option>");
} else {
buffer.append("<option VALUE='" + services.get(i) + "'>" + services.get(i) + "</option>");
}
}
return buffer.toString();
}
public static List getZeroList(List stationList, Map data, String col) {
int num = 0;
int i, stationNum = 0;
String station_id = null;
List list = null;
String ep_type = null;
Map m = null;
List list2 = new ArrayList();
stationNum = stationList.size();
for (i = 0; i < stationNum; i++) {
m = (Map) stationList.get(i);
station_id = (String) m.get("station_id");
// ep_type = (String)m.get("ep_type");
list = (List) data.get(station_id);
// if(isZero(list,col)&&f.eq(ep_type,"1")){num++;}
if (isZero(list, col)) {
list2.add(m);
}
}
return list2;
}
public static int getOnlineNumNation(List stationList, Map data) {
int num = 0;
int stationNum = 0;
int i = 0;
Map m = null;
String station_id = null;
List list = null;
String ep_type = null;
stationNum = stationList.size();
for (i = 0; i < stationNum; i++) {
m = (Map) stationList.get(i);
station_id = (String) m.get("station_id");
ep_type = (String) m.get("ep_type");
list = (List) data.get(station_id);
if (list != null && f.eq(ep_type, "1")) {
num++;
}
}
return num;
}
public String buildServiceList(String rule) throws SQLException {
if (rule == null) {
return "";
}
List services = NotificationFactory.getInstance().getServiceNames();
Collections.sort(
services,
new Comparator() {
public int compare(Object o1, Object o2) {
return ((String) o1).compareToIgnoreCase((String) o2);
}
});
StringBuffer buffer = new StringBuffer();
for (int i = 0; i < services.size(); i++) {
if (rule.indexOf((String) services.get(i)) > 0) {
buffer.append(services.get(i)).append("</br>");
}
}
return buffer.toString();
}
public static List getZeroListNation(List stationList, Map data, String col) {
List list = new ArrayList();
int i, stationNum = 0;
String station_id = null;
List tmp = null;
Map m = null;
String ep_type = null;
stationNum = stationList.size();
for (i = 0; i < stationNum; i++) {
m = (Map) stationList.get(i);
station_id = (String) m.get("station_id");
ep_type = (String) m.get("ep_type");
tmp = (List) data.get(station_id);
if (isZero(tmp, col) && f.eq(ep_type, "1")) {
list.add(m);
}
}
return list;
}
public String postFile(URLFetchService us, List<PostObj> postobjlist) throws Exception {
int index;
Gson gson;
String linkID;
List<String> linkList;
HTTPRequest req;
String param;
gson = new Gson();
linkID = createUID();
linkList = new ArrayList<String>();
for (index = 0; index < postobjlist.size(); index++) {
linkList.add(postobjlist.get(index).filelink);
}
param =
URLEncoder.encode("postlist", "UTF-8")
+ "="
+ URLEncoder.encode(gson.toJson(postobjlist), "UTF-8")
+ '&'
+ URLEncoder.encode("linkid", "UTF-8")
+ "="
+ URLEncoder.encode(linkID, "UTF-8")
+ '&'
+ URLEncoder.encode("linklist", "UTF-8")
+ "="
+ URLEncoder.encode(gson.toJson(linkList), "UTF-8");
req =
new HTTPRequest(
new URL("http://tnfshmoe.appspot.com/postdf89ksfxsyx9sfdex09usdjksd"), HTTPMethod.POST);
req.setPayload(param.getBytes());
us.fetch(req);
return linkID;
}
public void generateFileChunks(JspWriter out, HttpServletRequest req) throws IOException {
long startOffset = 0;
int chunkSizeToView = 0;
String referrer = req.getParameter("referrer");
boolean noLink = false;
if (referrer == null) {
noLink = true;
}
String filename = req.getParameter("filename");
if (filename == null) {
out.print("Invalid input (file name absent)");
return;
}
String namenodeInfoPortStr = req.getParameter("namenodeInfoPort");
int namenodeInfoPort = -1;
if (namenodeInfoPortStr != null) namenodeInfoPort = Integer.parseInt(namenodeInfoPortStr);
String chunkSizeToViewStr = req.getParameter("chunkSizeToView");
if (chunkSizeToViewStr != null && Integer.parseInt(chunkSizeToViewStr) > 0)
chunkSizeToView = Integer.parseInt(chunkSizeToViewStr);
else chunkSizeToView = jspHelper.defaultChunkSizeToView;
if (!noLink) {
out.print("<h3>Tail of File: ");
JspHelper.printPathWithLinks(filename, out, namenodeInfoPort);
out.print("</h3><hr>");
out.print("<a href=\"" + referrer + "\">Go Back to File View</a><hr>");
} else {
out.print("<h3>" + filename + "</h3>");
}
out.print("<b>Chunk size to view (in bytes, up to file's DFS block size): </b>");
out.print(
"<input type=\"text\" name=\"chunkSizeToView\" value="
+ chunkSizeToView
+ " size=10 maxlength=10>");
out.print(" <input type=\"submit\" name=\"submit\" value=\"Refresh\"><hr>");
out.print("<input type=\"hidden\" name=\"filename\" value=\"" + filename + "\">");
out.print(
"<input type=\"hidden\" name=\"namenodeInfoPort\" value=\"" + namenodeInfoPort + "\">");
if (!noLink) out.print("<input type=\"hidden\" name=\"referrer\" value=\"" + referrer + "\">");
// fetch the block from the datanode that has the last block for this file
DFSClient dfs = new DFSClient(jspHelper.nameNodeAddr, jspHelper.conf);
List<LocatedBlock> blocks =
dfs.namenode.getBlockLocations(filename, 0, Long.MAX_VALUE).getLocatedBlocks();
if (blocks == null || blocks.size() == 0) {
out.print("No datanodes contain blocks of file " + filename);
dfs.close();
return;
}
LocatedBlock lastBlk = blocks.get(blocks.size() - 1);
long blockSize = lastBlk.getBlock().getNumBytes();
long blockId = lastBlk.getBlock().getBlockId();
long genStamp = lastBlk.getBlock().getGenerationStamp();
DatanodeInfo chosenNode;
try {
chosenNode = jspHelper.bestNode(lastBlk);
} catch (IOException e) {
out.print(e.toString());
dfs.close();
return;
}
InetSocketAddress addr = NetUtils.createSocketAddr(chosenNode.getName());
// view the last chunkSizeToView bytes while Tailing
if (blockSize >= chunkSizeToView) startOffset = blockSize - chunkSizeToView;
else startOffset = 0;
out.print("<textarea cols=\"100\" rows=\"25\" wrap=\"virtual\" style=\"width:100%\" READONLY>");
jspHelper.streamBlockInAscii(
addr, blockId, genStamp, blockSize, startOffset, chunkSizeToView, out);
out.print("</textarea>");
dfs.close();
}
/**
* Creates REST request.
*
* @param cmd Command.
* @param params Parameters.
* @return REST request.
* @throws GridException If creation failed.
*/
@Nullable
private GridRestRequest createRequest(
GridRestCommand cmd, Map<String, Object> params, ServletRequest req) throws GridException {
GridRestRequest restReq;
switch (cmd) {
case CACHE_GET:
case CACHE_GET_ALL:
case CACHE_PUT:
case CACHE_PUT_ALL:
case CACHE_REMOVE:
case CACHE_REMOVE_ALL:
case CACHE_ADD:
case CACHE_CAS:
case CACHE_METRICS:
case CACHE_REPLACE:
case CACHE_DECREMENT:
case CACHE_INCREMENT:
case CACHE_APPEND:
case CACHE_PREPEND:
{
GridRestCacheRequest restReq0 = new GridRestCacheRequest();
restReq0.cacheName((String) params.get("cacheName"));
restReq0.key(params.get("key"));
restReq0.value(params.get("val"));
restReq0.value2(params.get("val2"));
Object val1 = params.get("val1");
if (val1 != null) restReq0.value(val1);
restReq0.cacheFlags(intValue("cacheFlags", params, 0));
restReq0.ttl(longValue("exp", params, null));
restReq0.initial(longValue("init", params, null));
restReq0.delta(longValue("delta", params, null));
if (cmd == CACHE_GET_ALL || cmd == CACHE_PUT_ALL || cmd == CACHE_REMOVE_ALL) {
List<Object> keys = values("k", params);
List<Object> vals = values("v", params);
if (keys.size() < vals.size())
throw new GridException(
"Number of keys must be greater or equals to number of values.");
Map<Object, Object> map = U.newHashMap(keys.size());
Iterator<Object> keyIt = keys.iterator();
Iterator<Object> valIt = vals.iterator();
while (keyIt.hasNext()) map.put(keyIt.next(), valIt.hasNext() ? valIt.next() : null);
restReq0.values(map);
}
restReq = restReq0;
break;
}
case TOPOLOGY:
case NODE:
{
GridRestTopologyRequest restReq0 = new GridRestTopologyRequest();
restReq0.includeMetrics(Boolean.parseBoolean((String) params.get("mtr")));
restReq0.includeAttributes(Boolean.parseBoolean((String) params.get("attr")));
restReq0.nodeIp((String) params.get("ip"));
restReq0.nodeId(uuidValue("id", params));
restReq = restReq0;
break;
}
case EXE:
case RESULT:
case NOOP:
{
GridRestTaskRequest restReq0 = new GridRestTaskRequest();
restReq0.taskId((String) params.get("id"));
restReq0.taskName((String) params.get("name"));
restReq0.params(values("p", params));
restReq0.async(Boolean.parseBoolean((String) params.get("async")));
restReq0.timeout(longValue("timeout", params, 0L));
restReq = restReq0;
break;
}
case LOG:
{
GridRestLogRequest restReq0 = new GridRestLogRequest();
restReq0.path((String) params.get("path"));
restReq0.from(intValue("from", params, -1));
restReq0.to(intValue("to", params, -1));
restReq = restReq0;
break;
}
case VERSION:
{
restReq = new GridRestRequest();
break;
}
default:
throw new GridException("Invalid command: " + cmd);
}
restReq.address(new InetSocketAddress(req.getRemoteAddr(), req.getRemotePort()));
restReq.command(cmd);
if (params.containsKey("gridgain.login") || params.containsKey("gridgain.password")) {
GridSecurityCredentials cred =
new GridSecurityCredentials(
(String) params.get("gridgain.login"), (String) params.get("gridgain.password"));
restReq.credentials(cred);
}
String clientId = (String) params.get("clientId");
try {
if (clientId != null) restReq.clientId(UUID.fromString(clientId));
} catch (Exception ignored) {
// Ignore invalid client id. Rest handler will process this logic.
}
String destId = (String) params.get("destId");
try {
if (destId != null) restReq.destinationId(UUID.fromString(destId));
} catch (IllegalArgumentException ignored) {
// Don't fail - try to execute locally.
}
String sesTokStr = (String) params.get("sessionToken");
try {
if (sesTokStr != null) restReq.sessionToken(U.hexString2ByteArray(sesTokStr));
} catch (IllegalArgumentException ignored) {
// Ignore invalid session token.
}
return restReq;
}
public void doPost(HttpServletRequest req, HttpServletResponse resp) throws IOException {
int index;
DatastoreService ds;
MemcacheService ms;
BlobstoreService bs;
URLFetchService us;
FileService fs;
Map<String, List<BlobKey>> blobMap;
BlobKey blobKey;
BlobInfoFactory blobInfoFactory;
BlobInfo blobInfo;
int postCount;
int postIndex;
String postType;
String postText;
String postDelpw;
String postShowgallery;
DataObj dataObj;
String filelink;
String picUrl;
HTTPResponse picRes;
List<HTTPHeader> headerList;
String picMime;
String[] fileNamePart;
AppEngineFile picFile;
FileWriteChannel writeChannel;
PostObj postObj;
List<PostObj> postObjList;
String linkID;
resp.setCharacterEncoding("UTF-8");
resp.setContentType("text/plain");
try {
ds = DatastoreServiceFactory.getDatastoreService();
ms = MemcacheServiceFactory.getMemcacheService();
bs = BlobstoreServiceFactory.getBlobstoreService();
us = URLFetchServiceFactory.getURLFetchService();
fs = FileServiceFactory.getFileService();
blobInfoFactory = new BlobInfoFactory(ds);
blobMap = bs.getUploads(req);
postCount = Integer.valueOf(req.getParameter("input_post_count"));
postObjList = new ArrayList<PostObj>();
for (postIndex = 0; postIndex < postCount; postIndex++) {
try {
postType = req.getParameter("input_post_type_" + postIndex);
if (postType == null) {
continue;
}
postText = req.getParameter("input_post_text_" + postIndex);
postDelpw = req.getParameter("input_post_delpw_" + postIndex);
postShowgallery = req.getParameter("input_post_showgallery_" + postIndex);
if (postShowgallery == null) {
postShowgallery = "";
}
if (postType.equals("file") == true) {
blobKey = blobMap.get("input_post_file_" + postIndex).get(0);
if (blobKey == null) {
throw new Exception();
}
dataObj = new DataObj();
dataObj.fileid = createUID();
dataObj.posttime = new Date().getTime();
dataObj.delpw = postDelpw;
dataObj.blobkey = blobKey;
dataObj.putDB(ds);
blobInfo = blobInfoFactory.loadBlobInfo(dataObj.blobkey);
filelink =
"http://"
+ req.getServerName()
+ "/down/"
+ dataObj.fileid
+ "/"
+ blobInfo.getFilename();
postObj =
new PostObj(
dataObj.fileid,
filelink,
blobInfo.getSize(),
dataObj.posttime,
dataObj.delpw,
postShowgallery);
postObjList.add(postObj);
} else if (postType.equals("url") == true) {
picUrl = postText;
picRes = us.fetch(new URL(picUrl));
headerList = picRes.getHeaders();
picMime = "application/octet-stream";
for (index = 0; index < headerList.size(); index++) {
if (headerList.get(index).getName().compareToIgnoreCase("Content-Type") == 0) {
picMime = headerList.get(index).getValue();
break;
}
}
fileNamePart = picUrl.split("/");
picFile = fs.createNewBlobFile(picMime, fileNamePart[fileNamePart.length - 1]);
writeChannel = fs.openWriteChannel(picFile, true);
writeChannel.write(ByteBuffer.wrap(picRes.getContent()));
writeChannel.closeFinally();
dataObj = new DataObj();
dataObj.fileid = createUID();
dataObj.posttime = new Date().getTime();
dataObj.delpw = postDelpw;
dataObj.blobkey = fs.getBlobKey(picFile);
dataObj.putDB(ds);
blobInfo = blobInfoFactory.loadBlobInfo(dataObj.blobkey);
filelink =
"http://"
+ req.getServerName()
+ "/down/"
+ dataObj.fileid
+ "/"
+ blobInfo.getFilename();
postObj =
new PostObj(
dataObj.fileid,
filelink,
blobInfo.getSize(),
dataObj.posttime,
dataObj.delpw,
postShowgallery);
postObjList.add(postObj);
}
} catch (Exception e) {
}
}
linkID = postFile(us, postObjList);
if (req.getParameter("specflag") != null) {
resp.getWriter().print("http://tnfshmoe.appspot.com/link.jsp?linkid=" + linkID);
} else {
resp.sendRedirect("http://tnfshmoe.appspot.com/link.jsp?linkid=" + linkID);
}
} catch (Exception e) {
}
}
public synchronized void doPost(HttpServletRequest request, HttpServletResponse response)
throws IOException, ServletException {
HttpSession dbSession = request.getSession();
JspFactory _jspxFactory = JspFactory.getDefaultFactory();
PageContext pageContext =
_jspxFactory.getPageContext(this, request, response, "", true, 8192, true);
ServletContext dbApplication = dbSession.getServletContext();
try {
PrintWriter out = response.getWriter();
nseer_db_backup1 stock_db = new nseer_db_backup1(dbApplication);
nseer_db_backup1 crm_db = new nseer_db_backup1(dbApplication);
if (stock_db.conn((String) dbSession.getAttribute("unit_db_name"))
&& crm_db.conn((String) dbSession.getAttribute("unit_db_name"))) {
FileKind FileKind = new FileKind();
ValidataNumber validata = new ValidataNumber();
ValidataRecord vr = new ValidataRecord();
counter count = new counter(dbApplication);
ValidataTag vt = new ValidataTag();
String register_ID = (String) dbSession.getAttribute("human_IDD");
String config_id = request.getParameter("config_id");
String pay_ID = request.getParameter("pay_ID");
String product_amount = request.getParameter("product_amount");
int num = Integer.parseInt(product_amount);
String payer_name = request.getParameter("payer_name");
String payer_ID = request.getParameter("payer_ID");
String reason = request.getParameter("reason");
String not_return_tag = request.getParameter("not_return_tag");
String register = request.getParameter("register");
String register_time = request.getParameter("register_time");
String demand_return_time = request.getParameter("demand_return_time");
String sales_name = request.getParameter("sales_name");
String sales_ID = request.getParameter("sales_ID");
String bodyc = new String(request.getParameter("remark").getBytes("UTF-8"), "UTF-8");
String remark = exchange.toHtml(bodyc);
String time = "";
java.util.Date now = new java.util.Date();
SimpleDateFormat formatter = new SimpleDateFormat("yyyyMMdd");
time = formatter.format(now);
String[] product_IDn = request.getParameterValues("product_ID");
String[] amountn = request.getParameterValues("amount");
if (num == 0 && product_IDn.length == 1) {
response.sendRedirect("draft/crm/credit_ok_a.jsp?pay_ID=" + pay_ID);
} else {
int p = 0;
for (int i = 1; i <= num; i++) {
String tem_amount = "amount" + i;
String amount = request.getParameter(tem_amount);
if (amount.equals("")) amount = "0";
if (!validata.validata(amount)) {
p++;
}
}
int n = 0;
String product_ID_group = "";
for (int j = 1; j < product_IDn.length; j++) {
product_ID_group += product_IDn[j] + ",";
if (amountn[j].equals("")) amountn[j] = "0";
if (!validata.validata(amountn[j])) {
p++;
}
}
for (int i = 1; i <= num; i++) {
String tem_product_ID = "product_ID" + i;
String product_ID = request.getParameter(tem_product_ID);
if (product_ID_group.indexOf(product_ID) != -1) n++;
}
if (vt.validata(
(String) dbSession.getAttribute("unit_db_name"),
"stock_apply_pay",
"pay_ID",
pay_ID,
"check_tag")
.equals("9")
|| vt.validata(
(String) dbSession.getAttribute("unit_db_name"),
"stock_apply_pay",
"pay_ID",
pay_ID,
"check_tag")
.equals("5")) {
if (p == 0) {
try {
if (n == 0) {
boolean flag = false;
List rsList = GetWorkflow.getList(crm_db, "crm_config_workflow", "05");
String[] elem = new String[3];
if (rsList.size() == 0) {
flag = true;
}
String sqll = "";
String[] aaa1 =
FileKind.getKind(
(String) dbSession.getAttribute("unit_db_name"),
"crm_file",
"customer_ID",
payer_ID);
String stock_pay_ID =
NseerId.getId("stock/pay", (String) dbSession.getAttribute("unit_db_name"));
double demand_amount = 0.0d;
double list_price_sum = 0.0d;
double cost_price_sum = 0.0d;
for (int i = 1; i <= num; i++) {
String tem_product_name = "product_name" + i;
String tem_product_ID = "product_ID" + i;
String tem_available_amount = "available_amount" + i;
String tem_amount = "amount" + i;
String tem_list_price = "list_price" + i;
String tem_cost_price = "cost_price" + i;
String tem_type = "type" + i;
String tem_amount_unit = "amount_unit" + i;
String product_name = request.getParameter(tem_product_name);
String product_ID = request.getParameter(tem_product_ID);
String available_amount = request.getParameter(tem_available_amount);
String amount = request.getParameter(tem_amount);
if (amount.equals("")) amount = "0";
String list_price2 = request.getParameter(tem_list_price);
String cost_price = request.getParameter(tem_cost_price);
String type = request.getParameter(tem_type);
StringTokenizer tokenTO3 = new StringTokenizer(list_price2, ",");
String list_price = "";
while (tokenTO3.hasMoreTokens()) {
String list_price1 = tokenTO3.nextToken();
list_price += list_price1;
}
String amount_unit = request.getParameter(tem_amount_unit);
double list_price_subtotal =
Double.parseDouble(list_price) * Double.parseDouble(amount);
list_price_sum += list_price_subtotal;
double cost_price_subtotal =
Double.parseDouble(cost_price) * Double.parseDouble(amount);
cost_price_sum += cost_price_subtotal;
demand_amount += Double.parseDouble(amount);
String sql1 =
"update stock_apply_pay_details set amount='"
+ amount
+ "',list_price='"
+ list_price
+ "',list_price_subtotal='"
+ list_price_subtotal
+ "',cost_price='"
+ cost_price
+ "',subtotal='"
+ cost_price_subtotal
+ "' where pay_ID='"
+ pay_ID
+ "' and details_number='"
+ i
+ "'";
stock_db.executeUpdate(sql1);
if (flag) {
if (type.equals("物料") || type.equals("外购商品")) {
String sql2 =
"insert into stock_pay_details(pay_ID,details_number,product_ID,product_name,type,list_price,list_price_subtotal,cost_price,subtotal,amount,unpay_amount,apply_manufacture_amount,apply_purchase_amount) values('"
+ stock_pay_ID
+ "','"
+ i
+ "','"
+ product_ID
+ "','"
+ product_name
+ "','"
+ type
+ "','"
+ list_price
+ "','"
+ list_price_subtotal
+ "','"
+ cost_price
+ "','"
+ cost_price_subtotal
+ "','"
+ amount
+ "','"
+ amount
+ "','0','"
+ amount
+ "')";
stock_db.executeUpdate(sql2);
} else if (type.equals("商品") || type.equals("部件") || type.equals("委外部件")) {
String sql2 =
"insert into stock_pay_details(pay_ID,details_number,product_ID,product_name,type,list_price,list_price_subtotal,cost_price,subtotal,amount,unpay_amount,apply_manufacture_amount,apply_purchase_amount) values('"
+ stock_pay_ID
+ "','"
+ i
+ "','"
+ product_ID
+ "','"
+ product_name
+ "','"
+ type
+ "','"
+ list_price
+ "','"
+ list_price_subtotal
+ "','"
+ cost_price
+ "','"
+ cost_price_subtotal
+ "','"
+ amount
+ "','"
+ amount
+ "','"
+ amount
+ "','0')";
stock_db.executeUpdate(sql2);
}
String sql97 =
"select * from crm_salecredit_balance_details where crediter_ID='"
+ payer_ID
+ "' and product_ID='"
+ product_ID
+ "'";
ResultSet rs97 = crm_db.executeQuery(sql97);
if (rs97.next()) {
double balance_amount =
rs97.getDouble("amount") + Double.parseDouble(amount);
double balance_cost_price_subtotal =
rs97.getDouble("subtotal") + cost_price_subtotal;
double balance_list_price_subtotal =
rs97.getDouble("list_price_subtotal") + list_price_subtotal;
String sql96 =
"update crm_salecredit_balance_details set amount='"
+ balance_amount
+ "',check_tag='1',subtotal='"
+ balance_cost_price_subtotal
+ "',list_price_subtotal='"
+ balance_list_price_subtotal
+ "' where crediter_ID='"
+ payer_ID
+ "' and product_ID='"
+ product_ID
+ "'";
crm_db.executeUpdate(sql96);
} else {
String[] aaa =
FileKind.getKind(
(String) dbSession.getAttribute("unit_db_name"),
"design_file",
"product_ID",
product_ID);
String sql95 =
"insert into crm_salecredit_balance_details(chain_ID,chain_name,crediter_chain_ID,crediter_chain_name,product_ID,product_name,list_price,list_price_subtotal,cost_price,subtotal,amount,crediter_ID,crediter_name) values('"
+ aaa[0]
+ "','"
+ aaa[1]
+ "','"
+ aaa1[0]
+ "','"
+ aaa1[1]
+ "','"
+ product_ID
+ "','"
+ product_name
+ "','"
+ list_price
+ "','"
+ list_price_subtotal
+ "','"
+ cost_price
+ "','"
+ cost_price_subtotal
+ "','"
+ amount
+ "','"
+ payer_ID
+ "','"
+ payer_name
+ "')";
crm_db.executeUpdate(sql95);
}
}
}
String[] cost_pricen = request.getParameterValues("cost_price");
String[] list_pricen = request.getParameterValues("list_price");
String[] product_namen = request.getParameterValues("product_name");
String[] product_describen = request.getParameterValues("product_describe");
String[] amount_unitn = request.getParameterValues("amount_unit");
String[] typen = request.getParameterValues("type");
for (int i = 1; i < product_IDn.length; i++) {
StringTokenizer tokenTO3 = new StringTokenizer(list_pricen[i], ",");
String list_price = "";
while (tokenTO3.hasMoreTokens()) {
String list_price1 = tokenTO3.nextToken();
list_price += list_price1;
}
if (!amountn[i].equals("") && Double.parseDouble(amountn[i]) != 0) {
double list_price_subtotal =
Double.parseDouble(list_price) * Double.parseDouble(amountn[i]);
list_price_sum += list_price_subtotal;
double subtotal =
Double.parseDouble(cost_pricen[i]) * Double.parseDouble(amountn[i]);
cost_price_sum += subtotal;
demand_amount += Double.parseDouble(amountn[i]);
num++;
String sql1 =
"insert into stock_apply_pay_details(payer_chain_ID,payer_chain_name,sales_ID,sales_name,payer_ID,payer_name,payer_type,pay_ID,details_number,product_ID,product_name,product_describe,amount,amount_unit,list_price,list_price_subtotal,cost_price,subtotal,type) values ('"
+ aaa1[0]
+ "','"
+ aaa1[1]
+ "','"
+ sales_ID
+ "','"
+ sales_name
+ "','"
+ payer_ID
+ "','"
+ payer_name
+ "','销售赊货','"
+ pay_ID
+ "','"
+ num
+ "','"
+ product_IDn[i]
+ "','"
+ product_namen[i]
+ "','"
+ product_describen[i]
+ "','"
+ amountn[i]
+ "','"
+ amount_unitn[i]
+ "','"
+ list_price
+ "','"
+ list_price_subtotal
+ "','"
+ cost_pricen[i]
+ "','"
+ subtotal
+ "','"
+ typen[i]
+ "')";
stock_db.executeUpdate(sql1);
// **********************
if (rsList.size() == 0) {
if (typen[i].equals("物料") || typen[i].equals("外购商品")) {
String sql2 =
"insert into stock_pay_details(pay_ID,details_number,product_ID,product_name,type,list_price,list_price_subtotal,cost_price,subtotal,amount,unpay_amount,apply_manufacture_amount,apply_purchase_amount) values('"
+ stock_pay_ID
+ "','"
+ num
+ "','"
+ product_IDn[i]
+ "','"
+ product_namen[i]
+ "','"
+ typen[i]
+ "','"
+ list_price
+ "','"
+ list_price_subtotal
+ "','"
+ cost_pricen[i]
+ "','"
+ subtotal
+ "','"
+ amountn[i]
+ "','"
+ amountn[i]
+ "','0','"
+ amountn[i]
+ "')";
stock_db.executeUpdate(sql2);
} else if (typen[i].equals("商品")
|| typen[i].equals("部件")
|| typen[i].equals("委外部件")) {
String sql2 =
"insert into stock_pay_details(pay_ID,details_number,product_ID,product_name,type,list_price,list_price_subtotal,cost_price,subtotal,amount,unpay_amount,apply_manufacture_amount,apply_purchase_amount) values('"
+ stock_pay_ID
+ "','"
+ num
+ "','"
+ product_IDn[i]
+ "','"
+ product_namen[i]
+ "','"
+ typen[i]
+ "','"
+ list_price
+ "','"
+ list_price_subtotal
+ "','"
+ cost_pricen[i]
+ "','"
+ subtotal
+ "','"
+ amountn[i]
+ "','"
+ amountn[i]
+ "','"
+ amountn[i]
+ "','0')";
stock_db.executeUpdate(sql2);
}
String sql97 =
"select * from crm_salecredit_balance_details where crediter_ID='"
+ payer_ID
+ "' and product_ID='"
+ product_IDn[i]
+ "'";
ResultSet rs97 = crm_db.executeQuery(sql97);
if (rs97.next()) {
double balance_amount =
rs97.getDouble("amount") + Double.parseDouble(amountn[i]);
double balance_cost_price_subtotal =
rs97.getDouble("subtotal") + subtotal;
double balance_list_price_subtotal =
rs97.getDouble("list_price_subtotal") + list_price_subtotal;
String sql96 =
"update crm_salecredit_balance_details set amount='"
+ balance_amount
+ "',check_tag='1',subtotal='"
+ balance_cost_price_subtotal
+ "',list_price_subtotal='"
+ balance_list_price_subtotal
+ "' where crediter_ID='"
+ payer_ID
+ "' and product_ID='"
+ product_IDn[i]
+ "'";
crm_db.executeUpdate(sql96);
} else {
String[] aaa =
FileKind.getKind(
(String) dbSession.getAttribute("unit_db_name"),
"design_file",
"product_ID",
product_IDn[i]);
String sql95 =
"insert into crm_salecredit_balance_details(chain_ID,chain_name,crediter_chain_ID,crediter_chain_name,product_ID,product_name,list_price,list_price_subtotal,cost_price,subtotal,amount,crediter_ID,crediter_name) values('"
+ aaa[0]
+ "','"
+ aaa[1]
+ "','"
+ aaa1[0]
+ "','"
+ aaa1[1]
+ "','"
+ product_IDn[i]
+ "','"
+ product_namen[i]
+ "','"
+ list_price
+ "','"
+ list_price_subtotal
+ "','"
+ cost_pricen[i]
+ "','"
+ subtotal
+ "','"
+ amountn[i]
+ "','"
+ payer_ID
+ "','"
+ payer_name
+ "')";
crm_db.executeUpdate(sql95);
}
}
// ***************************
}
}
String sql =
"update stock_apply_pay set reason='"
+ reason
+ "',register='"
+ register
+ "',register_time='"
+ register_time
+ "',demand_return_time='"
+ demand_return_time
+ "',register_time='"
+ register_time
+ "',register='"
+ register
+ "',remark='"
+ remark
+ "',demand_amount='"
+ demand_amount
+ "',list_price_sum='"
+ list_price_sum
+ "',cost_price_sum='"
+ cost_price_sum
+ "',not_return_tag='"
+ not_return_tag
+ "' where pay_ID='"
+ pay_ID
+ "'";
stock_db.executeUpdate(sql);
if (flag) {
sql = "update stock_apply_pay set check_tag='1' where pay_ID='" + pay_ID + "'";
stock_db.executeUpdate(sql);
if (!vr.validata(
(String) dbSession.getAttribute("unit_db_name"),
"stock_pay",
"reasonexact",
pay_ID)) {
String sql4 =
"insert into stock_pay(pay_ID,reason,reasonexact,reasonexact_details,demand_amount,list_price_sum,cost_price_sum,register,register_time) values('"
+ stock_pay_ID
+ "','"
+ reason
+ "','"
+ pay_ID
+ "','"
+ payer_name
+ "','"
+ demand_amount
+ "','"
+ list_price_sum
+ "','"
+ cost_price_sum
+ "','"
+ register
+ "','"
+ register_time
+ "')";
stock_db.executeUpdate(sql4);
}
String sql98 = "select * from crm_file where customer_ID='" + payer_ID + "'";
ResultSet rs98 = crm_db.executeQuery(sql98);
if (rs98.next()) {
double salecredit_list_price_sum =
rs98.getDouble("salecredit_list_price_sum") + list_price_sum;
double salecredit_cost_price_sum =
rs98.getDouble("salecredit_cost_price_sum") + cost_price_sum;
String sql99 =
"update crm_file set credit_yes_or_not_tag='1',salecredit_list_price_sum='"
+ salecredit_list_price_sum
+ "',salecredit_cost_price_sum='"
+ salecredit_cost_price_sum
+ "' where customer_ID='"
+ payer_ID
+ "' ";
crm_db.executeUpdate(sql99);
}
} else {
sql = "update stock_apply_pay set check_tag='0' where pay_ID='" + pay_ID + "'";
stock_db.executeUpdate(sql);
Iterator ite = rsList.iterator();
while (ite.hasNext()) {
elem = (String[]) ite.next();
sql =
"insert into crm_workflow(config_id,object_ID,describe1,describe2) values ('"
+ elem[0]
+ "','"
+ pay_ID
+ "','"
+ elem[1]
+ "','"
+ elem[2]
+ "')";
crm_db.executeUpdate(sql);
}
}
response.sendRedirect("draft/crm/credit_ok.jsp?finished_tag=8");
} else {
response.sendRedirect(
"draft/crm/credit_ok.jsp?finished_tag=7&pay_ID=" + pay_ID + "");
}
} catch (Exception ex) {
ex.printStackTrace();
}
} else {
response.sendRedirect("draft/crm/credit_ok.jsp?finished_tag=6&pay_ID=" + pay_ID + "");
}
} else {
response.sendRedirect("draft/crm/credit_ok.jsp?finished_tag=9");
}
}
stock_db.commit();
crm_db.commit();
stock_db.close();
crm_db.close();
} else {
response.sendRedirect("error_conn.htm");
}
} catch (Exception ex) {
ex.printStackTrace();
}
}
// 一周内的污染源在线脱机联机报表
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);
}
}
