public void doPost(HttpServletRequest req, HttpServletResponse resp)
throws IOException, ServletException {
log.info("########## START EDIT EVENT POST ###########");
// Check for valid user session
lpo.User user = UserManager.GetUser();
if (user == null) resp.sendRedirect("WelcomePage.jsp");
// get event from datastore
String eventKey = req.getParameter("k");
// pull the event object out
lpo.Event event = EventManager.GetEvent(eventKey);
String eventName = req.getParameter("eventName").trim();
String description = req.getParameter("description").trim();
boolean formIsComplete = true;
int minParticipants = 0;
try {
minParticipants = Integer.parseInt(req.getParameter("minParticipants"));
} catch (Exception e) {
log.info("ERROR PARSING MIN PARTICIPANTS: " + e.toString());
formIsComplete = false;
}
log.info("FORM VARS : " + eventName + " " + description + " " + minParticipants);
if (eventName == null
|| eventName.isEmpty()
|| description == null
|| description.isEmpty()
|| minParticipants < 1) {
formIsComplete = false;
}
if (formIsComplete) {
// create event and populate available attributes
event.setName(eventName);
event.setDescription(description);
event.setMinParticipants(minParticipants);
// persist to database
DataAccessManager.UpdateEvent(event);
resp.sendRedirect("/Menu");
} else {
// reshow the same jsp page with error message :
req.getRequestDispatcher("/WEB-INF/EditEvent.jsp").forward(req, resp);
}
return;
}
public void doPost(HttpServletRequest req, HttpServletResponse res)
throws IOException, ServletException {
ArrayList<String> ar = new ArrayList<String>();
boolean flag = false;
Cookie[] cArr = req.getCookies();
if (cArr != null) {
for (int i = 0; i < cArr.length; i++) {
Cookie c0 = cArr[i];
if (c0.getName().equals("Name") && !c0.getValue().equals("Logout")) {
res.sendRedirect("index.html");
flag = true;
}
}
}
if (flag == false) res.sendRedirect("Login.html");
}
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
EstacionBombeoModule module = (EstacionBombeoModule) context.getBean("estacionBombeoModule");
try {
String presionSalida = request.getParameter("presionSalida");
int presionSalidaObj = Integer.parseInt(presionSalida);
String presionEntrada = request.getParameter("presionEntrada");
int presionEntradaObj = Integer.parseInt(presionEntrada);
String cantidadBombas = request.getParameter("cantidadBombas");
int cantidadBombasObj = Integer.parseInt(cantidadBombas);
String capacidadMaxima = request.getParameter("capacidadMaxima");
int capacidadMaximaObj = Integer.parseInt(cantidadBombas);
String idAcueducto = request.getParameter("idAcueducto");
int idAcueductoObj = Integer.parseInt(idAcueducto);
String encargado = request.getParameter("encargado");
String tipo = request.getParameter("tipo");
String telefono = request.getParameter("telefono");
String nombreEstacion = request.getParameter("nombreEstacion");
module.insertar(
presionSalidaObj,
tipo,
capacidadMaximaObj,
cantidadBombasObj,
encargado,
telefono,
presionEntradaObj,
idAcueductoObj,
nombreEstacion);
response.sendRedirect("listaEstacionBombeos");
} catch (Exception e) {
request.setAttribute("mensaje", e.getMessage());
forward(e.getMessage(), request, response);
}
}
public synchronized void service(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();
ServletContext application;
HttpSession session = request.getSession();
nseer_db_backup1 finance_db = new nseer_db_backup1(dbApplication);
try {
if (finance_db.conn((String) dbSession.getAttribute("unit_db_name"))) {
String finance_cheque_id = request.getParameter("finance_cheque_id");
String sql = "delete from finance_bill where id='" + finance_cheque_id + "'";
finance_db.executeUpdate(sql);
finance_db.commit();
finance_db.close();
} else {
response.sendRedirect("error_conn.htm");
}
} catch (Exception ex) {
ex.printStackTrace();
}
}
private void handleRemoveFeedPost(Request request, HttpServletResponse httpServletResponse)
throws Exception {
LOG.info("removing feed");
User user = userHelpers.getUser(request);
try {
if (user == null) {
LOG.error("User not found");
return;
}
String feedId = request.getParameter(PARAM_FEED_ID);
LOG.info(String.format("Removing feed %s for user %s", feedId, user));
// ttt1 add some validation; probably best try to actually get data, set the title, ...
if (feedId == null || feedId.equals("")) {
LOG.error("feed not specified");
// ttt1 show some error
return;
}
if (user.feedIds.remove(
feedId)) { // ttt2 clean up the global feed table; that's probably better done if nobody
// accesses a feed for 3 months or so
userDb.updateFeeds(user);
LOG.info(String.format("Removed feed %s for user %s", feedId, user));
} else {
LOG.info(String.format("No feed found with ID %s for user %s", feedId, user));
}
} finally {
httpServletResponse.sendRedirect(PATH_FEED_ADMIN);
}
}
private void handleOpenArticle(
Request request, HttpServletResponse httpServletResponse, String target) throws Exception {
try {
int k1 = target.indexOf('/', 1);
int k2 = target.indexOf('/', k1 + 1);
String feedId = target.substring(k1 + 1, k2);
String strSeq = target.substring(k2 + 1);
int seq = Integer.parseInt(strSeq);
Article article = articleDb.get(feedId, seq);
LoginInfo loginInfo = userHelpers.getLoginInfo(request);
// ttt2 using the link from a non-authenticated browser causes a NPE; maybe do something
// better, e.g. sign up
ReadArticlesColl readArticlesColl = readArticlesCollDb.get(loginInfo.userId, feedId);
if (readArticlesColl == null) {
readArticlesColl = new ReadArticlesColl(loginInfo.userId, feedId);
}
if (!readArticlesColl.isRead(seq)) {
readArticlesColl.markRead(seq, Config.getConfig().maxSizeForReadArticles);
readArticlesCollDb.add(readArticlesColl);
}
String s =
URIUtil.encodePath(article.url)
.replace("%3F", "?")
.replace("%23", "#"); // ttt2 see how to do this right
httpServletResponse.sendRedirect(s);
} catch (Exception e) {
WebUtils.showResult(
String.format("Failed to get article for path %s. %s", target, e),
"/",
request,
httpServletResponse);
}
}
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
ProfesorRepository profesores = (ProfesorRepository) context.getBean("profesorRepository");
try {
String id = request.getParameter("id");
int idProf = Integer.parseInt(id);
String cedula = request.getParameter("cedula");
String nombre = request.getParameter("nombre");
String titulo = request.getParameter("titulo");
String area = request.getParameter("area");
String telefono = request.getParameter("telefono");
Profesor prof = profesores.findProfesor(idProf);
try {
if (cedula != null) prof.setCedula(cedula);
if (nombre != null) prof.setNombre(nombre);
if (titulo != null) prof.setTitulo(titulo);
if (area != null) prof.setArea(area);
if (telefono != null) prof.setTelefono(telefono);
profesores.updateProfesor(prof);
} catch (Exception e) {
}
response.sendRedirect("listaProfesores");
} catch (Exception e) {
request.setAttribute("mensaje", e.getMessage());
forward("/paginaError.jsp", request, response);
}
}
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
try {
response.setContentType("text/html");
PrintWriter out = response.getWriter();
/*String n=request.getParameter("username");
out.print("Welcome "+n);*/
String name = request.getParameter("name");
String dob = request.getParameter("dob");
String address = request.getParameter("address");
String email = request.getParameter("email");
HttpSession session = request.getSession(true);
String userid = (String) session.getAttribute("theName");
int AccNo = 0;
String AccMsg = "";
DbCommunication db_comm = new DbCommunication();
AccNo = db_comm.accountCreation(name, dob, address, email, userid);
// db_comm.accountCreation(name,email);
AccMsg = "Account created successfully. Account number is:" + AccNo;
// out.println(AccMsg);
String redirectURL = "accountCreationPage.jsp";
response.sendRedirect(redirectURL);
session.setAttribute("AccCreationalMsgStatus", "set");
session.setAttribute("AccCreationalMsg", AccMsg);
} catch (Exception e) {
System.out.println(e);
}
}
public void doGet(HttpServletRequest req, HttpServletResponse res)
throws ServletException, IOException {
res.setContentType("text/html");
PrintWriter out = res.getWriter();
Enumeration values = req.getParameterNames();
String name = "";
String value = "";
String id = "";
while (values.hasMoreElements()) {
name = ((String) values.nextElement()).trim();
value = req.getParameter(name).trim();
if (name.equals("id")) id = value;
}
if (url.equals("")) {
url = getServletContext().getInitParameter("url");
cas_url = getServletContext().getInitParameter("cas_url");
}
HttpSession session = null;
session = req.getSession(false);
if (session != null) {
session.invalidate();
}
res.sendRedirect(cas_url);
return;
}
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
request.setCharacterEncoding("gb2312");
String delete = request.getParameter("delete");
Login loginBean = null;
HttpSession session = request.getSession(true);
try {
loginBean = (Login) session.getAttribute("loginBean");
boolean b = loginBean.getLogname() == null || loginBean.getLogname().length() == 0;
if (b) response.sendRedirect("login.jsp"); // 重定向到登录页面
LinkedList<String> car = loginBean.getCar();
car.remove(delete);
} catch (Exception exp) {
response.sendRedirect("login.jsp"); // 重定向到登录页面
}
RequestDispatcher dispatcher = request.getRequestDispatcher("lookShoppingCar.jsp");
dispatcher.forward(request, response); // 转发
}
private void handleSignupPost(Request request, HttpServletResponse httpServletResponse)
throws Exception {
String userId = request.getParameter(PARAM_USER_ID);
String userName = request.getParameter(PARAM_USER_NAME);
String email = request.getParameter(PARAM_EMAIL);
String stringPassword = request.getParameter(PARAM_PASSWORD);
String stringPasswordConfirm = request.getParameter(PARAM_PASSWORD_CONFIRM);
if (!stringPassword.equals(stringPasswordConfirm)) {
WebUtils.redirectToError(
"Mismatch between password and password confirmation", request, httpServletResponse);
return;
}
SecureRandom secureRandom = new SecureRandom();
String salt = "" + secureRandom.nextLong();
byte[] password = User.computeHashedPassword(stringPassword, salt);
User user = userDb.get(userId);
if (user != null) {
WebUtils.redirectToError(
"There already exists a user with the ID " + userId, request, httpServletResponse);
return;
}
user =
new User(
userId,
userName,
password,
salt,
email,
new ArrayList<String>(),
Config.getConfig().activateAccountsAtCreation,
false);
// ttt2 add confirmation by email, captcha, ...
List<String> fieldErrors = user.checkFields();
if (!fieldErrors.isEmpty()) {
StringBuilder bld =
new StringBuilder("Invalid values when trying to create user with ID ")
.append(userId)
.append("<br/>");
for (String s : fieldErrors) {
bld.append(s).append("<br/>");
}
WebUtils.redirectToError(bld.toString(), request, httpServletResponse);
return;
}
// ttt2 2 clients can add the same userId simultaneously
userDb.add(user);
httpServletResponse.sendRedirect("/");
}
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
String key = request.getParameter("keyname");
String keyvalue = request.getParameter("value");
// Add the task to the default queue.
Queue queue = QueueFactory.getDefaultQueue();
queue.add(
TaskOptions.Builder.withUrl("/worker").param("keyname", key).param("value", keyvalue));
response.sendRedirect("/done.html");
}
static void media(HttpServletRequest request, HttpServletResponse response) throws Exception {
String bucket = request.getParameter("bucket");
String key = request.getParameter("key");
String retUrl = request.getParameter(S3Servlet.URL_PARAM);
if (retUrl == null && !S3Servlet.testing)
throw new Exception("Recieved no launch presentation return url");
AmazonS3Client s3 = new AmazonS3Client(S3Servlet.cred);
int[] dim = MediaHandler.getMediaDimensions(bucket, key, s3);
int width = dim[0];
int height = dim[1];
response.sendRedirect(MediaHandler.getMediaRedirect(bucket, key, retUrl, width, height, s3));
} // image//
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
HttpSession session = request.getSession(false);
if (session == null) {
response.sendRedirect("login.html");
return;
}
String userName = (String) session.getAttribute("userName");
if (isMissing(userName)) {
response.sendRedirect("login.html");
return;
}
String title = request.getParameter("title");
String link = request.getParameter("link");
String description = request.getParameter("description");
session.setAttribute("title", title);
session.setAttribute("link", link);
session.setAttribute("description", description);
String address = "WEB-INF/view/SaveBookmarkPage.jsp";
String urlEncoding = response.encodeURL(address);
RequestDispatcher dispatcher = request.getRequestDispatcher(urlEncoding);
dispatcher.forward(request, response);
}
public void doGet(HttpServletRequest req, HttpServletResponse resp)
throws ServletException, IOException {
log.info("########## START EDIT EVENT GET ###########");
// Check for valid user session
lpo.User user = UserManager.GetUser();
if (user == null) resp.sendRedirect("WelcomePage.jsp");
// get event from datastore
String eventKey = req.getParameter("k");
// pull the event object out
lpo.Event event = EventManager.GetEvent(eventKey);
req.setAttribute("event", event);
// build display page
req.getRequestDispatcher("/WEB-INF/EditEvent.jsp").forward(req, resp);
}
static void returnOembed(HttpServletRequest request, HttpServletResponse response)
throws Exception {
String url = request.getParameter("url");
if (url == null) throw new Exception("No subject URL found.");
String retUrl = request.getParameter(S3Servlet.URL_PARAM);
if (retUrl == null && !S3Servlet.testing)
throw new Exception("Recieved no launch presentation return url");
Enumeration<String> en = request.getParameterNames();
ArrayList<String> keys = new ArrayList<String>(), vals = new ArrayList<String>();
String key, value;
while (en.hasMoreElements()) {
key = en.nextElement();
if ("action".equals(key)) continue;
if ("launch_presentation_return_url".equals(key)) continue;
if ("url".equals(key)) continue;
if ((value = request.getParameter(key)) != null) {
keys.add(key);
vals.add(value);
} // if//
} // while//
String endpoint =
S3Servlet.makeUrl(
S3Servlet.server + S3Servlet.prefix + "/" + S3Action.oembed,
keys.toArray(new String[keys.size()]),
vals.toArray(new String[vals.size()]));
String oembedUrl =
S3Servlet.makeUrl(
retUrl,
new String[] {"embed_type", "endpoint", "url"},
new String[] {"oembed", endpoint, url});
response.reset();
response.sendRedirect(oembedUrl);
} // returnOembed//
public void doGet(HttpServletRequest req, HttpServletResponse res)
throws ServletException, IOException {
res.setContentType("text/html");
PrintWriter out = res.getWriter();
int i, j;
String amount = req.getParameter("amount");
String from = req.getParameter("from");
String to = req.getParameter("to");
String ch = req.getParameter("choice");
String answer, answer1, answer2, answer3;
if ("INFO".equals(ch)) {
Redirect_info newurl = (Redirect_info) getServletContext().getAttribute("redirect");
res.sendRedirect(newurl.getUrl());
} else {
out.println("<html>");
out.println("<title>Currency Converter</title>");
String addr = "http://www.google.com/ig/calculator?hl=en&q=" + amount + from + "=?" + to;
URL convert = new URL(addr);
BufferedReader in = new BufferedReader(new InputStreamReader(convert.openStream()));
answer = in.readLine();
answer = new String(answer.getBytes("ISO-8859-1"), "ISO-8859-7");
from = new String(from.getBytes("ISO-8859-1"), "ISO-8859-7");
to = new String(to.getBytes("ISO-8859-1"), "ISO-8859-7");
amount = new String(amount.getBytes("ISO-8859-1"), "ISO-8859-7");
in.close();
i = answer.indexOf('"');
answer = answer.substring(i + 1);
i = answer.indexOf('"');
answer = answer.substring(i + 1);
i = answer.indexOf('"');
answer = answer.substring(i + 1);
i = answer.indexOf('"');
answer = answer.substring(0, i);
out.println("<p ALIGN=CENTER>" + amount + " " + from + " == " + answer + "(" + to + ")</p>");
out.println("</body>");
out.println("</html>");
}
}
private void handleAddFeedPost(Request request, HttpServletResponse httpServletResponse)
throws Exception {
LOG.info("adding feed");
User user = userHelpers.getUser(request);
try {
if (user == null) {
LOG.error("User not found");
return;
}
String url = request.getParameter(PARAM_NEW_FEED_URL);
// ttt1 add some validation; probably best try to actually get data, set the title, ...
if (url == null || url.equals("")) {
LOG.error("New feed not specified");
// ttt1 show some error
return;
}
MessageDigest digest = MessageDigest.getInstance("MD5");
String feedId = PrintUtils.byteArrayAsUrlString(digest.digest(url.getBytes("UTF-8")));
feedId = feedId.substring(0, Config.getConfig().feedIdSize);
Feed feed = feedDb.get(feedId);
if (feed == null) {
feed = new Feed(feedId, url);
feedDb.add(feed);
}
if (user.feedIds.contains(feedId)) {
LOG.error(String.format("Trying to add existing feed %s to user %s", feedId, user));
} else {
user.feedIds.add(feedId);
userDb.updateFeeds(user);
}
} finally {
httpServletResponse.sendRedirect(PATH_FEED_ADMIN);
}
}
/** Metodo para actualizar un servicio existente */
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
AveriaRepository averias = (AveriaRepository) context.getBean("averiaRepository");
try {
String codAveria = request.getParameter("codAveria");
String descripcion = request.getParameter("descripcion");
String fecha = request.getParameter("fecha");
String servicio_codServicio = request.getParameter("servicio_codServicio");
Averia obj = averias.findAveria(codAveria);
try {
if (codAveria != null) obj.setCodAveria(codAveria);
if (descripcion != null) obj.setDescripcion(descripcion);
if (fecha != null) obj.setFecha(fecha);
if (servicio_codServicio != null) obj.setServicioCodServicio(servicio_codServicio);
} catch (Exception e) {
}
response.sendRedirect("listaAverias");
} catch (Exception e) {
request.setAttribute("mensaje", e.getMessage());
forward("/paginaError.jsp", request, response);
}
}
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
TuberiaModule module = (TuberiaModule) context.getBean("tuberiaModule");
try {
String id = request.getParameter("id");
int idObj = Integer.parseInt(id);
String diametro = request.getParameter("diametro");
int diametroObj = Integer.parseInt(diametro);
String largo = request.getParameter("largo");
int largoObj = Integer.parseInt(largo);
String presionMaxima = request.getParameter("presionMaxima");
int presionMaximaObj = Integer.parseInt(presionMaxima);
String idAcueducto = request.getParameter("idAcueducto");
int idAcueductoObj = Integer.parseInt(idAcueducto);
String material = request.getParameter("material");
String tipo = request.getParameter("tipo");
String fechaInstalacion = request.getParameter("fechaInstalacion");
String fechaUltimaInspeccion = request.getParameter("fechaUltimaInspeccion");
String estado = request.getParameter("estado");
module.actualizar(
idObj,
material,
diametroObj,
tipo,
largoObj,
presionMaximaObj,
fechaInstalacion,
fechaUltimaInspeccion,
estado,
idAcueductoObj);
response.sendRedirect("listaTuberias");
} catch (Exception e) {
request.setAttribute("mensaje", e.getMessage());
forward("/paginaError.jsp", request, response);
}
}
static void returnLink(HttpServletRequest request, HttpServletResponse response)
throws Exception {
String url = request.getParameter("url");
if (url == null) throw new Exception("No subject URL found.");
String text = request.getParameter("text");
if (text == null) throw new Exception("No link text found.");
String retUrl = request.getParameter(S3Servlet.URL_PARAM);
if (retUrl == null && !S3Servlet.testing)
throw new Exception("Recieved no launch presentation return url");
String title = request.getParameter("title");
String target = request.getParameter("target") == null ? "null" : "_blank";
String oembedUrl =
S3Servlet.makeUrl(
retUrl,
new String[] {"embed_type", "url", "title", "text", "target"},
new String[] {"link", url, title, text, target});
response.reset();
response.sendRedirect(oembedUrl);
} // returnLink//
public synchronized void service(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();
PrintWriter out = response.getWriter();
ServletContext application;
HttpSession session = request.getSession();
nseer_db_backup1 finance_db = new nseer_db_backup1(dbApplication);
ValidataNumber validata = new ValidataNumber();
try {
if (finance_db.conn((String) dbSession.getAttribute("unit_db_name"))) {
String file_id = request.getParameter("file_id");
String balance_sum = request.getParameter("balance_sum");
String balance_sum1 = request.getParameter("balance_sum1");
if (validata.validata(balance_sum) && validata.validata(balance_sum1)) {
String sql2 = "select id from finance_bill where tag='1' and file_id='" + file_id + "'";
ResultSet rs2 = finance_db.executeQuery(sql2);
String sql = "";
if (rs2.next()) {
sql =
"update finance_bill set debit_subtotal='"
+ balance_sum1
+ "' where tag='1' and file_id='"
+ file_id
+ "'";
} else {
sql =
"insert into finance_bill(debit_subtotal,file_id,tag) values('"
+ balance_sum1
+ "','"
+ file_id
+ "','1')";
}
finance_db.executeUpdate(sql);
sql2 =
"select id from finance_voucher where account_period='18' and chain_id='"
+ file_id
+ "'";
rs2 = finance_db.executeQuery(sql2);
if (rs2.next()) {
sql =
"update finance_voucher set debit_subtotal='"
+ balance_sum
+ "' where account_period='18' and chain_id='"
+ file_id
+ "'";
} else {
sql =
"insert into finance_voucher(debit_subtotal,chain_id,account_period) values('"
+ balance_sum
+ "','"
+ file_id
+ "','18')";
}
finance_db.executeUpdate(sql);
finance_db.commit();
finance_db.close();
} else {
out.println("1");
}
} else {
response.sendRedirect("error_conn.htm");
}
} catch (Exception ex) {
ex.printStackTrace();
}
}
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 void _jspService(HttpServletRequest request, HttpServletResponse response)
throws java.io.IOException, ServletException {
JspFactory _jspxFactory = null;
PageContext pageContext = null;
HttpSession session = null;
ServletContext application = null;
ServletConfig config = null;
JspWriter out = null;
Object page = this;
JspWriter _jspx_out = null;
PageContext _jspx_page_context = null;
try {
_jspxFactory = JspFactory.getDefaultFactory();
response.setContentType("text/html");
pageContext = _jspxFactory.getPageContext(this, request, response, null, true, 8192, true);
_jspx_page_context = pageContext;
application = pageContext.getServletContext();
config = pageContext.getServletConfig();
session = pageContext.getSession();
out = pageContext.getOut();
_jspx_out = out;
out.write("\n\n\n\n\n");
boolean exportUsers = request.getParameter("exportUsers") != null;
boolean success = request.getParameter("success") != null;
boolean exportToFile = ParamUtils.getBooleanParameter(request, "exporttofile", true);
ImportExportPlugin plugin =
(ImportExportPlugin)
XMPPServer.getInstance().getPluginManager().getPlugin("userimportexport");
String exportText = "";
Map<String, String> errors = new HashMap<String, String>();
if (exportUsers) {
if (exportToFile) {
String file = ParamUtils.getParameter(request, "exportFile");
if ((file == null) || (file.length() <= 0)) {
errors.put("missingFile", "missingFile");
} else {
response.sendRedirect("export-file.jsp?fileName=" + file);
}
} else {
try {
exportText = plugin.exportUsersToString();
} catch (IOException e) {
errors.put("IOException", "IOException");
}
}
}
out.write(
"\n\n<html>\n <head>\n <title>Export User Data</title>\n <meta name=\"pageID\" content=\"import-export-selection\"/>\n </head>\n <body>\n\n");
if (errors.size() > 0) {
out.write(
"\n\n <div class=\"jive-error\">\n <table cellpadding=\"0\" cellspacing=\"0\" border=\"0\">\n <tbody>\n <tr>\n <td class=\"jive-icon\"><img src=\"images/error-16x16.gif\" width=\"16\" height=\"16\" border=\"0\"></td>\n <td class=\"jive-icon-label\">\n ");
if (errors.containsKey("missingFile")) {
out.write("\n Missing or bad file name.\n ");
} else if (errors.containsKey("IOException") || errors.containsKey("fileNotCreated")) {
out.write("\n Couldn't create export file.\n ");
}
out.write(
"\n </td>\n </tr>\n </tbody>\n </table>\n </div>\n <br>\n\n");
} else if (ParamUtils.getBooleanParameter(request, "success")) {
out.write(
"\n\n <div class=\"jive-success\">\n <table cellpadding=\"0\" cellspacing=\"0\" border=\"0\">\n <tbody>\n <tr>\n <td class=\"jive-icon\"><img src=\"images/success-16x16.gif\" width=\"16\" height=\"16\" border=\"0\"></td>\n <td class=\"jive-icon-label\">User data successfully exported.</td>\n </tr>\n </tbody>\n </table>\n </div>\n <br>\n \n");
}
out.write(
"\n\n<form action=\"export-user-data.jsp?exportUsers\" method=\"post\">\n\n<div class=\"jive-contentBoxHeader\">Export Options</div>\n<div class=\"jive-contentBox\">\n <p>\n Select the radio button next to the desired export option and then click on the Export button.\n </p>\n \n <table cellpadding=\"3\" cellspacing=\"0\" border=\"0\" width=\"100%\">\n <tbody>\n <tr>\n <td width=\"1%\"><input type=\"radio\" name=\"exporttofile\" value=\"true\" ");
out.print(exportToFile ? "checked" : "");
out.write(
" id=\"rb01\"></td>\n <td width=\"99%\"><label for=\"rb01\"><b>To File</b></label> - Save user data to the specified file location.</td>\n </tr>\n <tr>\n <td width=\"1%\"> </td>\n <td width=\"99%\">Export File Name: <input type=\"text\" size=\"30\" maxlength=\"150\" name=\"exportFile\"></td>\n </tr>\n <tr>\n <td width=\"1%\"><input type=\"radio\" name=\"exporttofile\" value=\"false\" ");
out.print(!exportToFile ? "checked" : "");
out.write(
" id=\"rb02\"></td>\n <td width=\"99%\"><label for=\"rb02\"><b>To Screen</b></label> - Display user data in the text area below.</td> \n </tr>\n <tr>\n <td width=\"1%\"> </td>\n <td width=\"99%\"><textarea cols=\"80\" rows=\"20\" wrap=off>");
out.print(exportText);
out.write(
"</textarea></td>\n </tr>\n </tbody>\n </table>\n</div>\n\n<input type=\"submit\" value=\"Export\">\n</form>\n\n</body>\n</html>");
} catch (Throwable t) {
if (!(t instanceof SkipPageException)) {
out = _jspx_out;
if (out != null && out.getBufferSize() != 0) out.clearBuffer();
if (_jspx_page_context != null) _jspx_page_context.handlePageException(t);
}
} finally {
if (_jspxFactory != null) _jspxFactory.releasePageContext(_jspx_page_context);
}
}
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
// Variable initializations.
HttpSession session = request.getSession();
FileItem image_file = null;
int record_id = 0;
int image_id;
// Check if a record ID has been entered.
if (request.getParameter("recordID") == null || request.getParameter("recordID").equals("")) {
// If no ID has been entered, send message to jsp.
response_message =
"<p><font color=FF0000>No Record ID Detected, Please Enter One.</font></p>";
session.setAttribute("msg", response_message);
response.sendRedirect("UploadImage.jsp");
}
try {
// Parse the HTTP request to get the image stream.
DiskFileUpload fu = new DiskFileUpload();
// Will get multiple image files if that happens and can be accessed through FileItems.
List<FileItem> FileItems = fu.parseRequest(request);
// Connect to the database and create a statement.
conn = getConnected(drivername, dbstring, username, password);
stmt = conn.createStatement();
// Process the uploaded items, assuming only 1 image file uploaded.
Iterator<FileItem> i = FileItems.iterator();
while (i.hasNext()) {
FileItem item = (FileItem) i.next();
// Test if item is a form field and matches recordID.
if (item.isFormField()) {
if (item.getFieldName().equals("recordID")) {
// Covert record id from string to integer.
record_id = Integer.parseInt(item.getString());
String sql = "select count(*) from radiology_record where record_id = " + record_id;
int count = 0;
try {
rset = stmt.executeQuery(sql);
while (rset != null && rset.next()) {
count = (rset.getInt(1));
}
} catch (SQLException e) {
response_message = e.getMessage();
}
// Check if recordID is in the database.
if (count == 0) {
// Invalid recordID, send message to jsp.
response_message =
"<p><font color=FF0000>Record ID Does Not Exist In Database.</font></p>";
session.setAttribute("msg", response_message);
// Close connection.
conn.close();
response.sendRedirect("UploadImage.jsp");
}
}
} else {
image_file = item;
if (image_file.getName().equals("")) {
// No file, send message to jsp.
response_message = "<p><font color=FF0000>No File Selected For Record ID.</font></p>";
session.setAttribute("msg", response_message);
// Close connection.
conn.close();
response.sendRedirect("UploadImage.jsp");
}
}
}
// Get the image stream.
InputStream instream = image_file.getInputStream();
BufferedImage full_image = ImageIO.read(instream);
BufferedImage thumbnail = shrink(full_image, 10);
BufferedImage regular_image = shrink(full_image, 5);
// First, to generate a unique img_id using an SQL sequence.
rset1 = stmt.executeQuery("SELECT image_id_sequence.nextval from dual");
rset1.next();
image_id = rset1.getInt(1);
// Insert an empty blob into the table first. Note that you have to
// use the Oracle specific function empty_blob() to create an empty blob.
stmt.execute(
"INSERT INTO pacs_images VALUES("
+ record_id
+ ","
+ image_id
+ ", empty_blob(), empty_blob(), empty_blob())");
// to retrieve the lob_locator
// Note that you must use "FOR UPDATE" in the select statement
String cmd = "SELECT * FROM pacs_images WHERE image_id = " + image_id + " FOR UPDATE";
rset = stmt.executeQuery(cmd);
rset.next();
BLOB myblobFull = ((OracleResultSet) rset).getBLOB(5);
BLOB myblobThumb = ((OracleResultSet) rset).getBLOB(3);
BLOB myblobRegular = ((OracleResultSet) rset).getBLOB(4);
// Write the full size image to the blob object.
OutputStream fullOutstream = myblobFull.getBinaryOutputStream();
ImageIO.write(full_image, "jpg", fullOutstream);
// Write the thumbnail size image to the blob object.
OutputStream thumbOutstream = myblobThumb.getBinaryOutputStream();
ImageIO.write(thumbnail, "jpg", thumbOutstream);
// Write the regular size image to the blob object.
OutputStream regularOutstream = myblobRegular.getBinaryOutputStream();
ImageIO.write(regular_image, "jpg", regularOutstream);
// Commit the changes to database.
stmt.executeUpdate("commit");
response_message = "<p><font color=00CC00>Upload Successful.</font></p>";
session.setAttribute("msg", response_message);
instream.close();
fullOutstream.close();
thumbOutstream.close();
regularOutstream.close();
// Close connection.
conn.close();
response.sendRedirect("UploadImage.jsp");
instream.close();
fullOutstream.close();
thumbOutstream.close();
regularOutstream.close();
// Close connection.
conn.close();
} catch (Exception ex) {
response_message = ex.getMessage();
}
}
/**
* Allows one to forward the following request and response using the request dispatcher.
*
* @param resource the resource to forward the request/response to.
* @param request the http request to forward.
* @param response the http response to forward.
* @throws javax.servlet.ServletException
* @throws java.io.IOException
*/
protected void redirect(String resource, HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.sendRedirect(response.encodeRedirectURL(resource));
}
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 service(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 {
HttpSession session = request.getSession();
PrintWriter out = response.getWriter();
nseer_db_backup1 fund_db = new nseer_db_backup1(dbApplication);
nseer_db_backup1 fund_db1 = new nseer_db_backup1(dbApplication);
if (fund_db.conn((String) dbSession.getAttribute("unit_db_name"))
&& fund_db1.conn((String) dbSession.getAttribute("unit_db_name"))) {
counter count = new counter(dbApplication);
ValidataRecordNumber vrn = new ValidataRecordNumber();
ValidataTag vt = new ValidataTag();
ValidataNumber validata = new ValidataNumber();
try {
String time = "";
java.util.Date now = new java.util.Date();
SimpleDateFormat formatter = new SimpleDateFormat("yyyyMMdd");
time = formatter.format(now);
String apply_pay_ID = request.getParameter("apply_pay_ID");
String register_time = request.getParameter("register_time");
String register = request.getParameter("register");
String register_ID = request.getParameter("register_ID");
String bodyc = new String(request.getParameter("remark").getBytes("UTF-8"), "UTF-8");
String remark = exchange.toHtml(bodyc);
String amount = request.getParameter("amount");
String[] file_kind = request.getParameterValues("file_kind");
String[] cost_price_subtotal = request.getParameterValues("cost_price_subtotal");
int p = 0;
String file_kinda = ",";
for (int j = 1; j < file_kind.length; j++) {
file_kinda += file_kind[j] + ",";
if (cost_price_subtotal[j].equals("")) cost_price_subtotal[j] = "0";
StringTokenizer tokenTO4 = new StringTokenizer(cost_price_subtotal[j], ",");
String cost_price_subtotal1 = "";
while (tokenTO4.hasMoreTokens()) {
cost_price_subtotal1 += tokenTO4.nextToken();
}
if (!validata.validata(cost_price_subtotal1)) {
p++;
}
}
int n = 0;
for (int i = 1; i <= Integer.parseInt(amount); i++) {
String tem_file_kind = "file_kind" + i;
String file_kind2 = request.getParameter(tem_file_kind);
if (file_kinda.indexOf(file_kind2) != -1) n++;
}
if (n == 0) {
if (p == 0) {
if (vt.validata(
(String) dbSession.getAttribute("unit_db_name"),
"fund_apply_pay",
"apply_pay_ID",
apply_pay_ID,
"check_tag")
.equals("5")
|| vt.validata(
(String) dbSession.getAttribute("unit_db_name"),
"fund_apply_pay",
"apply_pay_ID",
apply_pay_ID,
"check_tag")
.equals("9")) {
String currency_name = "";
String personal_unit = "";
String chain_ID = "";
String chain_name = "";
String funder = "";
String funder_ID = "";
String sql11 =
"select * from fund_apply_pay where apply_pay_ID='" + apply_pay_ID + "'";
ResultSet rs11 = fund_db.executeQuery(sql11);
while (rs11.next()) {
chain_ID = rs11.getString("chain_ID");
chain_name = rs11.getString("chain_name");
funder = rs11.getString("human_name");
funder_ID = rs11.getString("human_ID");
currency_name = rs11.getString("currency_name");
personal_unit = rs11.getString("personal_unit");
}
int expenses_amount = 0;
String sql6 =
"select count(*) from fund_apply_pay_details where apply_pay_ID='"
+ apply_pay_ID
+ "'";
ResultSet rs6 = fund_db.executeQuery(sql6);
if (rs6.next()) {
expenses_amount = rs6.getInt("count(*)");
}
double demand_cost_price_sum = 0.0d;
for (int i = 1; i <= expenses_amount; i++) {
String tem_cost_price_subtotal = "cost_price_subtotal" + i;
String cost_price_subtotal2 = request.getParameter(tem_cost_price_subtotal);
demand_cost_price_sum += Double.parseDouble(cost_price_subtotal2);
sql6 =
"update fund_apply_pay_details set cost_price_subtotal='"
+ cost_price_subtotal2
+ "' where apply_pay_ID='"
+ apply_pay_ID
+ "' and details_number='"
+ i
+ "'";
fund_db.executeUpdate(sql6);
}
for (int i = 1; i < file_kind.length; i++) {
StringTokenizer tokenTO1 = new StringTokenizer(file_kind[i], "/");
String file_chain_ID = "";
String file_chain_name = "";
while (tokenTO1.hasMoreTokens()) {
file_chain_ID = tokenTO1.nextToken();
file_chain_name = tokenTO1.nextToken();
}
StringTokenizer tokenTO4 = new StringTokenizer(cost_price_subtotal[i], ",");
String cost_price_subtotal1 = "";
while (tokenTO4.hasMoreTokens()) {
cost_price_subtotal1 += tokenTO4.nextToken();
}
demand_cost_price_sum += Double.parseDouble(cost_price_subtotal1);
expenses_amount++;
String sql1 =
"insert into fund_apply_pay_details(apply_pay_ID,details_number,file_chain_ID,file_chain_name,cost_price_subtotal) values ('"
+ apply_pay_ID
+ "','"
+ expenses_amount
+ "','"
+ file_chain_ID
+ "','"
+ file_chain_name
+ "','"
+ cost_price_subtotal1
+ "')";
fund_db.executeUpdate(sql1);
}
String sql =
"update fund_apply_pay set demand_cost_price_sum='"
+ demand_cost_price_sum
+ "',check_tag='2',register_time='"
+ register_time
+ "',register='"
+ register
+ "',remark='"
+ remark
+ "' where apply_pay_ID='"
+ apply_pay_ID
+ "'";
fund_db.executeUpdate(sql);
response.sendRedirect("draft/fund/applyPayExpenses_ok.jsp?finished_tag=2");
} else {
response.sendRedirect("draft/fund/applyPayExpenses_ok.jsp?finished_tag=3");
}
} else {
response.sendRedirect("draft/fund/applyPayExpenses_ok.jsp?finished_tag=6");
}
} else {
response.sendRedirect("draft/fund/applyPayExpenses_ok.jsp?finished_tag=7");
}
} catch (Exception ex) {
ex.printStackTrace();
}
fund_db.commit();
fund_db1.commit();
fund_db.close();
fund_db1.close();
} else {
response.sendRedirect("error_conn.htm");
}
} catch (Exception ex) {
ex.printStackTrace();
}
}
public void _jspService(HttpServletRequest request, HttpServletResponse response)
throws java.io.IOException, ServletException {
JspFactory _jspxFactory = null;
PageContext pageContext = null;
HttpSession session = null;
ServletContext application = null;
ServletConfig config = null;
JspWriter out = null;
Object page = this;
JspWriter _jspx_out = null;
PageContext _jspx_page_context = null;
try {
_jspxFactory = JspFactory.getDefaultFactory();
response.setContentType("text/html");
pageContext =
_jspxFactory.getPageContext(this, request, response, "error.jsp", true, 8192, true);
_jspx_page_context = pageContext;
application = pageContext.getServletContext();
config = pageContext.getServletConfig();
session = pageContext.getSession();
out = pageContext.getOut();
_jspx_out = out;
out.write("\r\n\r\n\r\n\r\n\r\n");
PresencePlugin plugin =
(PresencePlugin) XMPPServer.getInstance().getPluginManager().getPlugin("presence");
// Get parameters
boolean save = request.getParameter("save") != null;
boolean success = request.getParameter("success") != null;
boolean presencePublic = ParamUtils.getBooleanParameter(request, "presencePublic");
String unavailableStatus =
ParamUtils.getParameter(request, "presenceUnavailableStatus", false);
if (unavailableStatus == null) {
unavailableStatus = plugin.getUnavailableStatus();
}
// Handle a save
if (save) {
plugin.setPresencePublic(presencePublic);
plugin.setUnavailableStatus(unavailableStatus);
response.sendRedirect("presence-service.jsp?success=true");
return;
}
presencePublic = plugin.isPresencePublic();
out.write(
"\r\n\r\n<html>\r\n <head>\r\n <title>Presence Service</title>\r\n <meta name=\"pageID\" content=\"presence-service\"/>\r\n </head>\r\n <body>\r\n\r\n<div class=\"information\">\r\n ");
String serverName = XMPPServer.getInstance().getServerInfo().getXMPPDomain();
int port = JiveGlobals.getXMLProperty("adminConsole.port", -1);
int securePort = JiveGlobals.getXMLProperty("adminConsole.securePort", -1);
boolean secureOnly = (port == -1);
out.write("\r\n\r\n Presence Service URL:<br>\r\n <tt>");
out.print(secureOnly ? "https" : "http");
out.write(':');
out.write('/');
out.write('/');
out.print(serverName);
out.write(':');
out.print(secureOnly ? securePort : port);
out.write("/plugins/presence/status</tt>\r\n <br><br>\r\n Example:<br>\r\n <tt>");
out.print(secureOnly ? "https" : "http");
out.write(':');
out.write('/');
out.write('/');
out.print(serverName);
out.write(':');
out.print(secureOnly ? securePort : port);
out.write("/plugins/presence/status?jid=admin@");
out.print(serverName);
out.write(
"</tt> \r\n\r\n\r\n</div>\r\n\r\n<p>\r\nUse the form below to configure user presence visibility. By default, user\r\npresence should only be visible to those users that are authorized.<br>\r\n</p>\r\n\r\n");
if (success) {
out.write(
"\r\n\r\n <div class=\"jive-success\">\r\n <table cellpadding=\"0\" cellspacing=\"0\" border=\"0\">\r\n <tbody>\r\n <tr><td class=\"jive-icon\"><img src=\"images/success-16x16.gif\" width=\"16\" height=\"16\" border=\"0\"></td>\r\n <td class=\"jive-icon-label\">\r\n Presence service properties edited successfully.\r\n </td></tr>\r\n </tbody>\r\n </table>\r\n </div><br>\r\n");
}
out.write(
"\r\n\r\n<form action=\"presence-service.jsp?save\" method=\"post\">\r\n\r\n<fieldset>\r\n <legend>Presence visibility</legend>\r\n <div>\r\n <p>\r\n For security reasons, users control which users are authorized to see their presence. However,\r\n it is posible to configure the service so that anyone has access to all presence information.\r\n Use this option with caution.\r\n </p>\r\n <table cellpadding=\"3\" cellspacing=\"0\" border=\"0\" width=\"100%\">\r\n <tbody>\r\n <tr>\r\n <td width=\"1%\">\r\n <input type=\"radio\" name=\"presencePublic\" value=\"true\" id=\"rb01\"\r\n ");
out.print(((presencePublic) ? "checked" : ""));
out.write(
">\r\n </td>\r\n <td width=\"99%\">\r\n <label for=\"rb01\"><b>Anyone</b> - Anyone may get presence information.</label>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td width=\"1%\">\r\n <input type=\"radio\" name=\"presencePublic\" value=\"false\" id=\"rb02\"\r\n ");
out.print(((!presencePublic) ? "checked" : ""));
out.write(
">\r\n </td>\r\n <td width=\"99%\">\r\n <label for=\"rb02\"><b>Subscribed</b> - Presence information is only visibile to authorized users.</label>\r\n </td>\r\n </tr>\r\n </tbody>\r\n </table>\r\n </div>\r\n</fieldset>\r\n\r\n<br>\r\n \r\n<fieldset>\r\n <legend>Plain Text 'Unavailable' Status Message</legend>\r\n <div>\r\n <p>\r\n In "text" mode the status message for unavailable users is "Unavailable"\r\n by default. It is possible to change the unavailable status message by setting this property.\r\n </p>\r\n <p>\r\n <input type=\"text\" name=\"presenceUnavailableStatus\" value=\"");
out.print(unavailableStatus);
out.write(
"\">\r\n </p>\r\n </div>\r\n</fieldset>\r\n\r\n<br><br>\r\n\r\n<input type=\"submit\" value=\"Save Properties\">\r\n</form>\r\n\r\n</body>\r\n</html>");
} catch (Throwable t) {
if (!(t instanceof SkipPageException)) {
out = _jspx_out;
if (out != null && out.getBufferSize() != 0) out.clearBuffer();
if (_jspx_page_context != null) _jspx_page_context.handlePageException(t);
}
} finally {
if (_jspxFactory != null) _jspxFactory.releasePageContext(_jspx_page_context);
}
}
public void _jspService(HttpServletRequest request, HttpServletResponse response)
throws java.io.IOException, ServletException {
PageContext pageContext = null;
HttpSession session = null;
ServletContext application = null;
ServletConfig config = null;
JspWriter out = null;
Object page = this;
JspWriter _jspx_out = null;
PageContext _jspx_page_context = null;
try {
response.setContentType("text/html;charset=utf-8");
pageContext = _jspxFactory.getPageContext(this, request, response, null, true, 8192, true);
_jspx_page_context = pageContext;
application = pageContext.getServletContext();
config = pageContext.getServletConfig();
session = pageContext.getSession();
out = pageContext.getOut();
_jspx_out = out;
out.write("\r\n");
out.write("\r\n");
out.write("<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\">\r\n");
out.write("<html>\r\n");
out.write(" <head>\r\n");
out.write(" <style type=\"text/css\">\r\n");
out.write("<!--\r\n");
out.write("body {\r\n");
out.write("\tbackground-image: url(images/bb286.gif);\r\n");
out.write("\tbackground-repeat: repeat-y;\r\n");
out.write("\tbackground-position: center;\r\n");
out.write("}\r\n");
out.write(".STYLE3 {\r\n");
out.write("\tcolor: #000080;\r\n");
out.write("\tfont-weight: bold;\r\n");
out.write("}\r\n");
out.write("-->\r\n");
out.write(" </style>\r\n");
out.write(" <title>增加课程</title>\r\n");
out.write(" <SCRIPT LANGUAGE = \"JavaScript\"> \r\n");
out.write("function check()\r\n");
out.write("{\r\n");
out.write("var numb1= document.addcourse.name.value;\r\n");
out.write("var numb2= document.addcourse.course_id.value;\r\n");
out.write("if (numb1==\"\"&&numb2==\"\")\r\n");
out.write("{\r\n");
out.write(" alert(\"课程名和课程号不能为空！\");\r\n");
out.write("return false;\r\n");
out.write("}\r\n");
out.write("else if (numb1==\"\")\r\n");
out.write("{\r\n");
out.write(" alert(\"课程名不能为空！\");\r\n");
out.write("return false;\r\n");
out.write("}\r\n");
out.write("else if (numb2==\"\")\r\n");
out.write("{\r\n");
out.write("\t alert(\"课程号不能为空！\");\r\n");
out.write("return false;\r\n");
out.write("}\r\n");
out.write("else \r\n");
out.write("\treturn true;\r\n");
out.write("\r\n");
out.write("}\r\n");
out.write("\r\n");
out.write("</SCRIPT>\r\n");
out.write(" </head>\r\n");
out.write(" <body>\r\n");
String admin_id = (String) session.getAttribute("id");
if (admin_id == null) {
response.sendRedirect("./adm_login.jsp");
}
out.write("\r\n");
out.write(
"<form name=\"addcourse\" onSubmit=\"return check()\" method=\"post\" action=\"addcourse\">\r\n");
out.write(" <p> </p>\r\n");
out.write(" <div align=\"center\"></div>\r\n");
out.write(" <br>\r\n");
out.write(" <br>\r\n");
out.write(" <table width=\"37%\" border=\"1\" align=\"center\">\r\n");
out.write(" <tr> \r\n");
out.write(" <td width=\"37%\">课程名</td>\r\n");
out.write(" <td width=\"63%\"><input name=\"name\" type=\"text\"></td>\r\n");
out.write(" </tr>\r\n");
out.write(" <tr> \r\n");
out.write(" <td>课程号</td>\r\n");
out.write(" <td><input name=\"course_id\" type=\"text\"></td>\r\n");
out.write(" </tr>\r\n");
out.write(" <tr> \r\n");
out.write(" <td>学分</td>\r\n");
out.write(" <td><select name=\"mark\" size=\"1\" id=\"mark\">\r\n");
out.write(" <option value=\"1\">1</option>\r\n");
out.write(" <option value=\"2\">2</option>\r\n");
out.write(" <option value=\"3\">3</option>\r\n");
out.write(" <option value=\"4\">4</option>\r\n");
out.write(" </select></td>\r\n");
out.write(" </tr>\r\n");
out.write(" <tr> \r\n");
out.write(" <td>开课学院</td>\r\n");
out.write(" <td><select name=\"dep\" size=\"1\">\r\n");
out.write(" <option>软件学院</option>\r\n");
out.write(" <option>人文学院</option>\r\n");
out.write(" <option>外语学院</option>\r\n");
out.write(" <option>经贸学院</option>\r\n");
out.write(" <option>理学院</option>\r\n");
out.write(" <option>法学院</option>\r\n");
out.write(" <option>教科学院</option>\r\n");
out.write(" <option>政管学院</option>\r\n");
out.write(" <option>健行学院</option>\r\n");
out.write(" <option>生环学院</option>\r\n");
out.write(" \t <option>机械学院</option>\r\n");
out.write(" \t <option>信息学院</option>\r\n");
out.write(" \t <option>化材学院</option>\r\n");
out.write(" \t <option>国际学院</option>\r\n");
out.write(" \t <option>药学院</option>\r\n");
out.write(" \t <option>艺术学院</option>\r\n");
out.write(" \t <option>建工学院</option>\r\n");
out.write(" \t <option>之江学院</option>\r\n");
out.write(" </select></td>\r\n");
out.write(" </tr>\r\n");
out.write(" </table>\r\n");
out.write(" <p align=\"center\"> \r\n");
out.write(" <input type=\"submit\" name=\"submit\" value=\"提交\">\r\n");
out.write(" </p>\r\n");
out.write(" </form>\r\n");
out.write(" </body>\r\n");
out.write("</html>\r\n");
} catch (Throwable t) {
if (!(t instanceof SkipPageException)) {
out = _jspx_out;
if (out != null && out.getBufferSize() != 0)
try {
out.clearBuffer();
} catch (java.io.IOException e) {
}
if (_jspx_page_context != null) _jspx_page_context.handlePageException(t);
}
} finally {
_jspxFactory.releasePageContext(_jspx_page_context);
}
}
