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();
}
}
public void doInitBody() throws JspException {
try {
setAttribute();
} catch (Exception e) {
e.printStackTrace();
}
}
static {
try {
} catch (Exception e) {
e.printStackTrace();
throw new RuntimeException(e);
}
}
public int doStartTag() throws JspException {
try {
ncrMgr = (NcrMgr) pageContext.getSession().getAttribute("ncrMgr");
List attributeCodeList = null;
if (listType.equals("dmgType")) {
attributeCodeList = (List) ncrMgr.getCurrentNcrMeta().getDmgTypeList();
currentAttributeCode = (SelectionOption) ncrMgr.getCurrentNcr().getDmgType();
} else if (listType.equals("solType")) {
attributeCodeList = (List) ncrMgr.getCurrentNcrMeta().getSolTypeList();
currentAttributeCode = (SelectionOption) ncrMgr.getCurrentNcr().getSolType();
} else if (listType.equals("ncrType")) {
attributeCodeList = (List) ncrMgr.getCurrentNcrMeta().getNcrTypeList();
currentAttributeCode = (SelectionOption) ncrMgr.getCurrentNcr().getNcrType();
}
if (attributeCodeList == null || attributeCodeList.size() == 0) {
return Tag.SKIP_BODY;
}
iterator = attributeCodeList.iterator();
} catch (Exception e) {
e.printStackTrace();
}
return IterationTag.EVAL_BODY_AGAIN;
}
/** Holds value of propertys navigatorName. */
public int doStartTag() throws JspException {
try {
BomMgr bomMgr = (BomMgr) pageContext.getSession().getAttribute("bomMgr");
MfgProcess mfgProcess = bomMgr.getCurrentMfgProcess();
if (mfgProcess == null) {
return Tag.SKIP_BODY;
}
pageContext.setAttribute(
"processId", mfgProcess.getProcessId() == null ? "" : mfgProcess.getProcessId());
pageContext.setAttribute("processCode", mfgProcess.getProcessCode());
pageContext.setAttribute("processName", mfgProcess.getProcessName());
pageContext.setAttribute("description", mfgProcess.getDescription());
pageContext.setAttribute(
"processCodeError",
mfgProcess.isValid("processCode") ? "" : mfgProcess.getMessage("processCode"));
pageContext.setAttribute(
"processNameError",
mfgProcess.isValid("processName") ? "" : mfgProcess.getMessage("processName"));
pageContext.setAttribute("error", mfgProcess.hasMessage() ? mfgProcess.getMessage() : "");
pageContext.setAttribute("isSaved", mfgProcess.isSaved() ? "Y" : "N");
} catch (Exception e) {
e.printStackTrace();
}
return EVAL_BODY_INCLUDE;
}
public int doStartTag() throws JspException {
try {
comQuotationMgr = (ComQuotationMgr) pageContext.getSession().getAttribute("comQuotationMgr");
iterator = comQuotationMgr.getCurrentQuotation().getCustomer().getContactList().iterator();
if (!iterator.hasNext()) {
return Tag.SKIP_BODY;
}
} catch (Exception e) {
e.printStackTrace();
}
return IterationTag.EVAL_BODY_AGAIN;
}
public int doStartTag() throws JspException {
try {
List headChargeList =
((ProcessHandleTag) getParent()).getCurrentProcessHandleFor().getHeadChargeList();
iterator = headChargeList.iterator();
if (headChargeList.size() == 0) {
return SKIP_BODY;
}
} catch (Exception e) {
e.printStackTrace();
}
return IterationTag.EVAL_BODY_AGAIN;
}
public int doStartTag() throws JspException {
try {
mttMgr = (MttMgr) pageContext.getSession().getAttribute("mttMgr");
iterator =
mttMgr
.getCurrentmaterialTransactionTypeMeta()
.getMaterialTransactionTypeList()
.iterator();
if (mttMgr.getCurrentmaterialTransactionTypeMeta().getMaterialTransactionTypeList().size()
== 0) {
return SKIP_BODY;
}
} catch (Exception e) {
e.printStackTrace();
}
return IterationTag.EVAL_BODY_AGAIN;
}
public int doAfterBody() throws JspException {
if (iterator.hasNext()) {
try {
setAttribute();
} catch (Exception e) {
e.printStackTrace();
}
return IterationTag.EVAL_BODY_AGAIN;
} else {
try {
bodyContent.writeOut(bodyContent.getEnclosingWriter());
return SKIP_BODY;
} catch (IOException ioe) {
throw new JspTagException(ioe.getMessage());
}
}
}
private void setAttribute() {
try {
contact = (Contact) iterator.next();
pageContext.setAttribute(
"contactId", contact.getContactId() == null ? "" : contact.getContactId());
pageContext.setAttribute(
"contactName",
contact.getContactPersonName() == null ? "" : contact.getContactPersonName());
pageContext.setAttribute("phone", contact.getPhone() == null ? "" : contact.getPhone());
pageContext.setAttribute("email", contact.getEmail() == null ? "" : contact.getEmail());
} catch (Exception e) {
e.printStackTrace();
}
}
public int doStartTag() throws JspException {
try {
purchaseRequisitionMgr =
(PurchaseRequisitionMgr) pageContext.getSession().getAttribute("purchaseRequisitionMgr");
iterator = purchaseRequisitionMgr.getCurrentPurchaseRequest().getPrDetailList().iterator();
if (purchaseRequisitionMgr.getCurrentPurchaseRequest().getPrDetailList().size() == 0) {
return Tag.SKIP_BODY;
}
if (!iterator.hasNext()) {
return Tag.SKIP_BODY;
}
} catch (Exception e) {
e.printStackTrace();
}
return IterationTag.EVAL_BODY_AGAIN;
}
private PollerConfiguration getPollerConfiguration() {
PollerConfiguration pollconfig = null;
try {
PollerConfigFactory.init();
PollerConfigFactory.reload();
pollconfig = PollerConfigFactory.getInstance().getConfiguration();
} catch (MarshalException me) {
me.printStackTrace();
} catch (ValidationException ve) {
ve.printStackTrace();
} catch (IOException ioe) {
ioe.printStackTrace();
} catch (Exception e) {
e.printStackTrace();
}
return pollconfig;
}
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();
MakePdf mm = new MakePdf();
excel query = new excel();
getKeyColumn column = new getKeyColumn();
mm.setConfigFile("xml/stock/pdf_export.xml");
String sql = "";
String tablename = request.getParameter("tablename");
String condition = "";
String queue = "";
if (tablename.equals("stock_balance")) {
queue = "order by chain_ID";
condition = "where address_group!=''";
}
sql = "select * from " + tablename + " " + condition + " " + queue;
int a = sql.indexOf("*");
String sqla = sql.substring(0, a) + "count(*) as A" + sql.substring(a + 1, sql.length());
mm.make(
(String) dbSession.getAttribute("unit_db_name"),
tablename,
sqla,
sql,
"pdf_files/stock_data",
1500,
session);
int fileAmount = mm.fileAmount();
response.sendRedirect("stock/export/pdf_ok_a.jsp?file_amount=" + fileAmount + "");
} catch (Exception ex) {
ex.printStackTrace();
}
}
public int doStartTag() throws JspException {
try {
gosMemberMgr = (GosMemberMgr) pageContext.getSession().getAttribute("gosMemberMgr");
if (gosMemberMgr.getMemberCardTypeMeta().getMemberCardTypeList().size() > 0) {
iterator = gosMemberMgr.getMemberCardTypeMeta().getMemberCardTypeList().iterator();
} else {
return Tag.SKIP_BODY;
}
if (!iterator.hasNext()) {
return Tag.SKIP_BODY;
}
} catch (Exception e) {
e.printStackTrace();
}
return IterationTag.EVAL_BODY_AGAIN;
}
private void setPollerConfiguration(PollerConfiguration pollconfig) {
try {
pollconfig.validate();
BufferedWriter bw =
new BufferedWriter(
new FileWriter(
WTProperties.getValue("SNMPConfig.directory") + "poller-configuration.xml"));
pollconfig.marshal(bw);
bw.flush();
bw.close();
} catch (MarshalException me) {
me.printStackTrace();
} catch (ValidationException ve) {
ve.printStackTrace();
} catch (IOException ioe) {
ioe.printStackTrace();
} catch (Exception e) {
e.printStackTrace();
}
}
private void setAttribute() {
try {
this.materialTransactionType = (MaterialTransactionType) iterator.next();
pageContext.setAttribute(
"materialId",
materialTransactionType.getAttributeId() == null
? ""
: materialTransactionType.getAttributeId());
pageContext.setAttribute("materialCode", materialTransactionType.getAttributeCode());
pageContext.setAttribute("materialName", materialTransactionType.getAttributeName());
pageContext.setAttribute("materialDescription", materialTransactionType.getDescription());
pageContext.setAttribute(
"materialApprovedFlag",
materialTransactionType.getApprovedFlag() == null
? ""
: this.materialTransactionType.getApprovedFlag());
pageContext.setAttribute(
"isReturn",
materialTransactionType.getType() == null
? ""
: materialTransactionType.getType().equals("2") ? "Retrun" : "");
pageContext.setAttribute(
"isIssue",
materialTransactionType.getType() == null
? ""
: materialTransactionType.getType().equals("1") ? "Issue" : "");
pageContext.setAttribute(
"isTransfer",
materialTransactionType.getType() == null
? ""
: materialTransactionType.getType().equals("3") ? "Transfer" : "");
pageContext.setAttribute(
"isConsume",
materialTransactionType.getType() == null
? ""
: materialTransactionType.getType().equals("4") ? "Consume" : "");
} catch (Exception e) {
e.printStackTrace();
}
}
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();
nseer_db_backup1 stock_db = new nseer_db_backup1(dbApplication);
try {
if (stock_db.conn((String) dbSession.getAttribute("unit_db_name"))) {
int i;
int intRowCount;
String sqll =
"select * from stock_config_public_char where describe1='\u51fa\u5165\u5e93\u7406\u7531'";
ResultSet rs = stock_db.executeQuery(sqll);
rs.next();
rs.last();
intRowCount = rs.getRow();
String[] del = new String[intRowCount];
del = (String[]) dbSession.getAttribute("del");
if (del != null) {
for (i = 1; i <= intRowCount; i++) {
String sql = "delete from stock_config_public_char where id='" + del[i - 1] + "'";
stock_db.executeUpdate(sql);
}
}
stock_db.commit();
stock_db.close();
response.sendRedirect("stock/config/apply_gather_pay/reason.jsp");
} else {
response.sendRedirect("error_conn.htm");
}
} catch (Exception ex) {
ex.printStackTrace();
}
}
private void setAttribute() {
try {
memberCardType = (MemberCardType) iterator.next();
pageContext.setAttribute(
"memberCardTypeId",
memberCardType.getMemberCardTypeId() == null ? "" : memberCardType.getMemberCardTypeId());
pageContext.setAttribute("memberCardTypeCode", memberCardType.getMemberCardTypeCode());
pageContext.setAttribute("memberCardTypeName", memberCardType.getMemberCardTypeName());
pageContext.setAttribute("isSaved", memberCardType.isSaved() ? "Y" : "N");
pageContext.setAttribute("note", memberCardType.getNote());
// pageContext.setAttribute("memberCardTypeCodeError",
// memberCardType.isValid("memberCardTypeCode") ? "" :
// memberCardType.getMessage("memberCardTypeCode"));
// pageContext.setAttribute("memberCardTypeNameError",
// memberCardType.isValid("selectionName") ? "" : memberCardType.getMessage("selectionName"));
// pageContext.setAttribute("noteError", memberCardType.isValid("note") ? "" :
// memberCardType.getMessage("note"));
} catch (Exception e) {
e.printStackTrace();
}
}
public int doStartTag() throws JspException {
try {
purchaseRequisitionMgr =
(PurchaseRequisitionMgr) pageContext.getSession().getAttribute("purchaseRequisitionMgr");
PurchaseRequest purchaseRequest = purchaseRequisitionMgr.getCurrentPurchaseRequest();
pageContext.setAttribute(
"prId", purchaseRequest.getPrId() == null ? "" : purchaseRequest.getPrId());
pageContext.setAttribute(
"creationDate",
purchaseRequest.getCreationDate() == null ? "" : purchaseRequest.getCreationDate());
pageContext.setAttribute(
"createdBy",
purchaseRequest.getCreatedBy() == null ? "" : purchaseRequest.getCreatedBy());
pageContext.setAttribute("isSaved", purchaseRequest.isIsSaved() ? "Y" : "N");
pageContext.setAttribute("isSend", purchaseRequest.isIsSend() ? "Y" : "N");
pageContext.setAttribute("isClamant", purchaseRequest.isIsClamant() ? "Y" : "N");
pageContext.setAttribute("statusString", purchaseRequest.getStatusString());
pageContext.setAttribute(
"prStatus", purchaseRequest.getPrStatus() == null ? "" : purchaseRequest.getPrStatus());
pageContext.setAttribute("modifiedReason", purchaseRequest.getModifiedReason());
pageContext.setAttribute(
"modifiedReasonError",
purchaseRequest.isValid("modifiedReason")
? ""
: purchaseRequest.getMessage("modifiedReason"));
pageContext.setAttribute(
"prError", purchaseRequest.hasMessage() ? purchaseRequest.getMessage() : "");
} catch (Exception e) {
e.printStackTrace();
}
return Tag.EVAL_BODY_INCLUDE;
}
public int doStartTag() throws JspException {
try {
PurReportMgr purReportMgr =
(PurReportMgr) pageContext.getSession().getAttribute("purReportMgr");
ireportPurchaseOrder = purReportMgr.getCurrentIreport().getIreportPurchaseOrder();
pageContext.setAttribute(
"poNo", ireportPurchaseOrder.getPoNo() == null ? "" : ireportPurchaseOrder.getPoNo());
pageContext.setAttribute(
"poRefNo",
ireportPurchaseOrder.getPoRefNo() == null ? "" : ireportPurchaseOrder.getPoRefNo());
pageContext.setAttribute(
"creationDate",
ireportPurchaseOrder.getCreationDate() == null
? ""
: ireportPurchaseOrder.getCreationDate());
pageContext.setAttribute(
"createdBy",
ireportPurchaseOrder.getCreatedBy() == null ? "" : ireportPurchaseOrder.getCreatedBy());
} catch (Exception e) {
e.printStackTrace();
}
return Tag.EVAL_BODY_INCLUDE;
}
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 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();
session = request.getSession();
counter count = new counter(dbApplication);
ValidataNumber validata = new ValidataNumber();
ValidataRecord vr = new ValidataRecord();
ValidataTag vt = new ValidataTag();
getNameFromID getNameFromID = new getNameFromID();
getRateFromID getRateFromID = new getRateFromID();
nseer_db_backup1 purchase_db = new nseer_db_backup1(dbApplication);
if (purchase_db.conn((String) dbSession.getAttribute("unit_db_name"))) {
String register_ID = (String) session.getAttribute("human_IDD");
String config_id = request.getParameter("config_id");
String discussion_ID = request.getParameter("discussion_ID");
String provider_ID = request.getParameter("provider_ID");
String provider_name = request.getParameter("provider_name");
String demand_contact_person = request.getParameter("demand_contact_person");
String demand_contact_person_tel = request.getParameter("demand_contact_person_tel");
String demand_contact_person_fax = request.getParameter("demand_contact_person_fax");
String demand_pay_time = request.getParameter("demand_pay_time");
String check_time = request.getParameter("check_time");
String checker = request.getParameter("checker");
String checker_ID = request.getParameter("checker_ID");
String bodyc = new String(request.getParameter("remark").getBytes("UTF-8"), "UTF-8");
String remark = exchange.toHtml(bodyc);
String modify_tag = request.getParameter("modify_tag");
String product_amount = request.getParameter("product_amount");
int num = Integer.parseInt(product_amount);
int n = 0;
for (int i = 1; i <= num; i++) {
String tem_amount = "amount" + i;
String tem_off_discount = "off_discount" + i;
String tem_list_price = "list_price" + i;
String amount = request.getParameter(tem_amount);
String off_discount = request.getParameter(tem_off_discount);
String list_price2 = request.getParameter(tem_list_price);
StringTokenizer tokenTO2 = new StringTokenizer(list_price2, ",");
String list_price = "";
while (tokenTO2.hasMoreTokens()) {
String list_price1 = tokenTO2.nextToken();
list_price += list_price1;
}
if (!validata.validata(amount)
|| !validata.validata(off_discount)
|| !validata.validata(list_price)) {
n++;
}
}
String sql6 =
"select id from purchase_workflow where object_ID='"
+ discussion_ID
+ "' and ((check_tag='0' and config_id<'"
+ config_id
+ "') or (check_tag='1' and config_id='"
+ config_id
+ "'))";
ResultSet rs6 = purchase_db.executeQuery(sql6);
if (!rs6.next()) {
if (vt.validata(
(String) dbSession.getAttribute("unit_db_name"),
"purchase_discussion",
"discussion_ID",
discussion_ID,
"check_tag")
.equals("0")) {
if (n == 0) {
String time = "";
java.util.Date now = new java.util.Date();
SimpleDateFormat formatter = new SimpleDateFormat("yyyyMMdd");
time = formatter.format(now);
String sql =
"update purchase_discussion set discussion_ID='"
+ discussion_ID
+ "',provider_ID='"
+ provider_ID
+ "',provider_name='"
+ provider_name
+ "',demand_contact_person='"
+ demand_contact_person
+ "',demand_contact_person_tel='"
+ demand_contact_person_tel
+ "',demand_contact_person_fax='"
+ demand_contact_person_fax
+ "',check_time='"
+ check_time
+ "',checker='"
+ checker
+ "',checker_ID='"
+ checker_ID
+ "',remark='"
+ remark
+ "' where discussion_ID='"
+ discussion_ID
+ "'";
purchase_db.executeUpdate(sql);
try {
int service_count = 0;
int stock_number = 0;
int pay_amount_sum = 0;
double sale_price_sum = 0.0d;
double cost_price_sum = 0.0d;
double real_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_product_describe = "product_describe" + i;
String tem_amount = "amount" + i;
String tem_off_discount = "off_discount" + i;
String tem_list_price = "list_price" + i;
String tem_cost_price = "cost_price" + i;
String tem_real_cost_price = "real_cost_price" + 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 product_describe = request.getParameter(tem_product_describe);
String amount1 = request.getParameter(tem_amount);
String off_discount = request.getParameter(tem_off_discount);
String list_price2 = request.getParameter(tem_list_price);
StringTokenizer tokenTO2 = new StringTokenizer(list_price2, ",");
String list_price = "";
while (tokenTO2.hasMoreTokens()) {
String list_price1 = tokenTO2.nextToken();
list_price += list_price1;
}
String cost_price2 = request.getParameter(tem_cost_price);
StringTokenizer tokenTO3 = new StringTokenizer(cost_price2, ",");
String cost_price = "";
while (tokenTO3.hasMoreTokens()) {
String cost_price1 = tokenTO3.nextToken();
cost_price += cost_price1;
}
String real_cost_price2 = request.getParameter(tem_real_cost_price);
StringTokenizer tokenTO4 = new StringTokenizer(real_cost_price2, ",");
String real_cost_price = "";
while (tokenTO4.hasMoreTokens()) {
String real_cost_price1 = tokenTO4.nextToken();
real_cost_price += real_cost_price1;
}
String amount_unit = request.getParameter(tem_amount_unit);
double amount = 0.0d;
double subtotal =
Double.parseDouble(list_price)
* (1 - Double.parseDouble(off_discount) / 100)
* Double.parseDouble(amount1);
double cost_price_after_discount_sum =
Double.parseDouble(cost_price) * Double.parseDouble(amount1);
double real_cost_price_after_discount_sum =
Double.parseDouble(real_cost_price) * Double.parseDouble(amount1);
sale_price_sum += subtotal;
cost_price_sum += cost_price_after_discount_sum;
real_cost_price_sum += real_cost_price_after_discount_sum;
double order_sale_bonus_subtotal =
getRateFromID.getRateFromID(
(String) dbSession.getAttribute("unit_db_name"),
"design_file",
"product_ID",
product_ID,
"order_sale_bonus_rate")
* subtotal
/ 100;
double order_profit_bonus_subtotal = 0.0d;
String sql1 =
"update purchase_discussion_details set product_ID='"
+ product_ID
+ "',product_name='"
+ product_name
+ "',product_describe='"
+ product_describe
+ "',list_price='"
+ list_price
+ "',amount='"
+ amount1
+ "',cost_price='"
+ cost_price
+ "',off_discount='"
+ off_discount
+ "',subtotal='"
+ subtotal
+ "' where discussion_ID='"
+ discussion_ID
+ "' and details_number='"
+ i
+ "'";
purchase_db.executeUpdate(sql1);
String product_type = "";
String sql16 = "select * from design_file where product_ID='" + product_ID + "'";
ResultSet rs16 = purchase_db.executeQuery(sql16);
if (rs16.next()) {
product_type = rs16.getString("type");
}
if (product_type.equals("物料") || product_type.equals("外购商品")) {
stock_number += 1;
} else if (product_type.equals("商品")
|| product_type.equals("部件")
|| product_type.equals("委外部件")) {
stock_number += 1;
} else if (product_type.equals("服务型产品")) {
service_count++;
}
}
String sql2 =
"update purchase_workflow set checker='"
+ checker
+ "',checker_ID='"
+ checker_ID
+ "',check_time='"
+ check_time
+ "',check_tag='1' where object_ID='"
+ discussion_ID
+ "' and config_id='"
+ config_id
+ "'";
purchase_db.executeUpdate(sql2);
sql2 =
"select id from purchase_workflow where object_ID='"
+ discussion_ID
+ "' and check_tag='0'";
ResultSet rset = purchase_db.executeQuery(sql2);
if (!rset.next()) {
sql2 =
"update purchase_discussion set sale_price_sum='"
+ sale_price_sum
+ "',cost_price_sum='"
+ cost_price_sum
+ "',modify_tag='0',discussion_tag='1',discussion_status='等待',check_tag='1' where discussion_ID='"
+ discussion_ID
+ "'";
purchase_db.executeUpdate(sql2);
} else {
sql2 =
"update purchase_discussion set sale_price_sum='"
+ sale_price_sum
+ "',cost_price_sum='"
+ cost_price_sum
+ "',modify_tag='0' where discussion_ID='"
+ discussion_ID
+ "'";
purchase_db.executeUpdate(sql2);
}
} catch (Exception ex) {
ex.printStackTrace();
}
response.sendRedirect(
"purchase/discussion/check_choose_attachment.jsp?discussion_ID="
+ discussion_ID
+ "");
} else {
response.sendRedirect("purchase/discussion/check_ok.jsp?finished_tag=0");
}
} else {
response.sendRedirect("purchase/discussion/check_ok.jsp?finished_tag=1");
}
} else {
response.sendRedirect("purchase/discussion/check_ok.jsp?finished_tag=2");
}
purchase_db.commit();
purchase_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('\r');
out.write('\n');
try {
out.write("\r\n\r\n ");
String wgID = request.getParameter("wgID");
final WorkgroupManager workgroupManager = WorkgroupManager.getInstance();
Workgroup workgroup = workgroupManager.getWorkgroup(new JID(wgID));
OfflineSettingsManager offlineManager = new OfflineSettingsManager();
String redirectValue = request.getParameter("redirectToPage");
String statusMessage = "";
OfflineSettings offlineSettings = null;
boolean emailConfigured = false;
String property = JiveGlobals.getProperty("mail.configured");
if (ModelUtil.hasLength(property)) {
emailConfigured = true;
}
boolean delete = request.getParameter("delete") != null;
boolean save = request.getParameter("save") != null && !delete;
if (save) {
String emailAddress = request.getParameter("email");
String subject = request.getParameter("subject");
String header = request.getParameter("headerField");
offlineSettings =
offlineManager.saveOfflineSettings(
workgroup, redirectValue, emailAddress, subject, header);
if (offlineSettings != null) {
statusMessage = "Offline settings have been saved.";
}
} else if (delete) {
statusMessage = "Offline settings have been deleted.";
offlineSettings =
offlineManager.saveOfflineSettings(workgroup, redirectValue, "", "", "");
} else {
try {
offlineSettings = offlineManager.getOfflineSettings(workgroup);
} catch (OfflineSettingsNotFound offlineSettingsNotFound) {
offlineSettings = new OfflineSettings();
}
}
out.write("\r\n<html>\r\n <head>\r\n <title>");
out.print("Offline Settings for " + wgID);
out.write(
"</title>\r\n <meta name=\"subPageID\" content=\"workgroup-offline\"/>\r\n <meta name=\"extraParams\" content=\"");
out.print("wgID=" + wgID);
out.write(
"\"/>\r\n <!--<meta name=\"helpPage\" content=\"set_an_offline_policy_for_a_workgroup.html\"/>-->\r\n\r\n <script>\r\n function saveOfflineSettings(){\r\n var todo = document.offline.todo;\r\n if(todo[0].checked){\r\n var url = document.offline.redirectToPage.value;\r\n if(!Jtrim(url)){\r\n alert(\"Please specify the URL to forward to.\");\r\n document.offline.redirectToPage.focus();\r\n return;\r\n }\r\n document.offline.email.value = \"\";\r\n document.offline.subject.value = \"\";\r\n document.offline.headerField.value = \"\";\r\n\r\n document.offline.submit();\r\n }\r\n else if(todo[1].checked){\r\n var email = document.offline.email.value;\r\n var subject = document.offline.subject.value;\r\n var message = document.offline.headerField.value;\r\n document.offline.redirectToPage.value = '';\r\n");
out.write(
"\r\n if(!Jtrim(email) || !Jtrim(subject) || !Jtrim(message)){\r\n alert(\"All fields are required.\");\r\n return;\r\n }\r\n document.offline.submit();\r\n }\r\n }\r\n\r\n\r\n\r\n function Jtrim(st) {\r\n var len = st.length;\r\n var begin = 0, end = len - 1;\r\n while (st.charAt(begin) == \" \" && begin < len) {\r\n begin++;\r\n }\r\n while (st.charAt(end) == \" \" && end > begin) {\r\n end--;\r\n }\r\n return st.substring(begin, end + 1);\r\n }\r\n </script>\r\n </head>\r\n <body>\r\n Specify action to take when this workgroup has no available agents to take incoming chat requests.\r\n ");
if (statusMessage != null && !statusMessage.equals("")) {
out.write("\r\n <div class=\"success\">\r\n ");
out.print(statusMessage);
out.write("\r\n </div>\r\n ");
}
out.write("\r\n\r\n ");
if (!emailConfigured) {
out.write(
"\r\n <div class=\"error\">\r\n Email form will not be displayed until you configure your <a href=\"../../system-email.jsp\">email settings</a>.\r\n </div>\r\n ");
}
out.write("\r\n\r\n <div id=\"offline_message\">");
out.print(statusMessage);
out.write(
"</div>\r\n <p/>\r\n <form action=\"workgroup-offline.jsp\" method=\"get\" name=\"offline\">\r\n <input type=\"hidden\" name=\"wgID\" value=\"");
out.print(wgID);
out.write(
"\" />\r\n <div>\r\n <div class=\"jive-contentBoxHeader\">\r\n Offline Workgroup Action\r\n </div>\r\n <table width=\"100%\" cellpadding=\"3\" cellspacing=\"0\" border=\"0\" class=\"jive-contentBox\">\r\n <tr valign=\"top\">\r\n ");
String checked = offlineSettings.redirects() ? "checked" : "";
out.write(
"\r\n <td width=\"1%\">\r\n <input type=\"radio\" name=\"todo\" value=\"redirectToPage\" ");
out.print(checked);
out.write(
" />\r\n </td>\r\n <td nowrap><b>Redirect To Web Page</b>\r\n </td>\r\n <td class=\"c2\">\r\n <input type=\"text\" name=\"redirectToPage\" size=\"40\" value=\"");
out.print(offlineSettings.getRedirectURL());
out.write(
"\" /><br/>\r\n <span class=\"jive-description\">e.g. http://www.jivesoftware.com/contact.html</span>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td nowrap width=\"1%\">\r\n <input type=\"radio\" name=\"todo\" value=\"showEmailPage\" ");
out.print(!offlineSettings.redirects() ? "checked" : "");
out.write(
"/>\r\n <td><b>Display Email Form</b></td>\r\n </td>\r\n <td> </td>\r\n </tr>\r\n <!-- Email Address -->\r\n <tr valign=\"top\">\r\n <td> </td>\r\n <td>Email Address:</td>\r\n <td>\r\n <input type=\"text\" size=\"40\" name=\"email\" value=\"");
out.print(offlineSettings.getEmailAddress());
out.write(
"\" /><br/>\r\n <span class=\"jive-description\">Email address to send all offline messages to.</span>\r\n </td>\r\n </tr>\r\n <!-- End of Email Address -->\r\n <!-- Subject Line -->\r\n <tr valign=\"top\">\r\n <td> </td>\r\n <td>Subject:</td>\r\n <td>\r\n <input type=\"text\" size=\"40\" name=\"subject\" value=\"");
out.print(offlineSettings.getSubject());
out.write(
"\"/><br/>\r\n <span class=\"jive-description\">The subject of all offline email messages.</span>\r\n </td>\r\n </tr>\r\n <!-- End Of Subject Line -->\r\n <tr valign=\"top\">\r\n <td> </td>\r\n <td>Offline Text:</td>\r\n <td>\r\n <textarea name=\"headerField\" cols=\"40\" rows=\"5\">");
out.print(offlineSettings.getOfflineText());
out.write(
"</textarea><br/>\r\n <span class=\"jive-description\">Text to display to the user in the email form.</span>\r\n </td>\r\n </tr>\r\n <input type=\"hidden\" name=\"save\" value=\"save\">\r\n <tr>\r\n </tr>\r\n ");
out.write(
"\r\n </table>\r\n <table><tr>\r\n <td colspan=\"1\"> <input type=\"button\" name=\"save\" value=\"Save Changes\" onclick=\"return saveOfflineSettings();\" /></td>\r\n <td colspan=\"1\"> <input type=\"submit\" name=\"delete\" value=\"Delete Changes\" /></td>\r\n </tr></table>\r\n </div>\r\n </form>\r\n\r\n</body>\r\n</html>\r\n\r\n");
} catch (Exception ex) {
ex.printStackTrace();
}
} 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(
final javax.servlet.http.HttpServletRequest request,
final javax.servlet.http.HttpServletResponse response)
throws java.io.IOException, javax.servlet.ServletException {
final javax.servlet.jsp.PageContext pageContext;
javax.servlet.http.HttpSession session = null;
final javax.servlet.ServletContext application;
final javax.servlet.ServletConfig config;
javax.servlet.jsp.JspWriter out = null;
final java.lang.Object page = this;
javax.servlet.jsp.JspWriter _jspx_out = null;
javax.servlet.jsp.PageContext _jspx_page_context = null;
try {
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");
out.write("\n");
out.write("\n");
out.write("\n");
out.write("\n");
out.write("\n");
org.apache.jasper.runtime.JspRuntimeLibrary.include(
request,
response,
"sessionBoth.jsp"
+ (("sessionBoth.jsp").indexOf('?') > 0 ? '&' : '?')
+ org.apache.jasper.runtime.JspRuntimeLibrary.URLEncode(
"formName", request.getCharacterEncoding())
+ "="
+ org.apache.jasper.runtime.JspRuntimeLibrary.URLEncode(
"editItemDetails.jsp", request.getCharacterEncoding()),
out,
false);
out.write(" \n");
out.write("\n");
out.write("\n");
int site_id = 0;
DecimalFormat df = new DecimalFormat("###,###.00");
try {
site_id = (Integer) session.getAttribute("GlobalSiteId");
System.out.print("In : " + site_id);
} catch (Exception e) {
e.printStackTrace();
}
String i_code = "";
String ig_code = "";
String i_name = "";
String i_mrp = "";
String i_mrp2 = "";
String i_rate = "";
String i_rate2 = "";
String flag = "";
String paramList = "";
String changeParamList = "";
String i_tickflag = "";
String ibarcode = request.getParameter("ibarcode");
i_code = request.getParameter("icodeStartWith");
ig_code = request.getParameter("igcodeStartWith");
i_name = request.getParameter("inameStartWith");
i_mrp = request.getParameter("imrpStartWith");
i_rate = request.getParameter("irateStartWith");
i_mrp2 = request.getParameter("imrp2StartWith");
i_rate2 = request.getParameter("irate2StartWith");
flag = request.getParameter("flag");
i_tickflag = request.getParameter("i_tickflg");
item.ManageItem mi;
mi = new item.ManageItem("jdbc/js");
mi.listItem(
i_code, ig_code, i_name, i_mrp, i_mrp2, i_rate, i_rate2, i_tickflag, ibarcode, site_id);
out.write("\n");
out.write(" <style>\n");
out.write(" #id #tr:hover td{\n");
out.write(" \t\tbackground-color: white;\n");
out.write(" \t\tcursor: pointer;\n");
out.write(" }\n");
out.write(" #id td{\n");
out.write(" \t\tpadding: 3px 0px 3px 5px;\n");
out.write(" }\n");
out.write(" </style>\n");
out.write(
" <table border=\"1\" name=\"t\" id=\"id\" class=\"item3\" cellspacing = 0 cellpadding = 0 style=\"border-collapse: collapse; width: 96%;background-color: #ECFB99;\" bordercolor=black>\n");
out.write(" \n");
out.write(" \t <thead>\n");
out.write(" \t\t \t<tr align=\"left\">\n");
out.write("\t\t\t\t<td><b>Item Code</b></td>\n");
out.write("\t\t\t\t<td><b>Change Quantity</b></td>\n");
out.write("\t\t\t\t<td><b>Item Group</b></td>\n");
out.write("\t\t\t\t<td><b>Item Name</b></td>\n");
out.write("\t\t\t\t<td><b>Item Barcode</b></td>\n");
out.write("\t\t\t\t<td><b>Item Weight</b></td>\n");
out.write("\t\t\t\t<td><b>Item MRP</b></td>\n");
out.write("\t\t\t\t<td><b>Item Rate</b></td>\n");
out.write("\t\t\t\t<td><b>Deal Flag</b></td>\n");
out.write("\t\t\t\t<td><b>Ticker Flag</b></td>\n");
out.write("\t\t\t\t<td><b>Is bachka</b></td>\n");
out.write("\t\t\t\t<td><b>Mix Item</b></td>\n");
out.write("\t\t\t\t<td><b>Item History</b></td>\n");
out.write("\t\t\t</tr>\n");
out.write(" \t</thead>\t\n");
out.write("\t\t<tbody>\n");
while (mi.rs.next()) {
if (flag.equals("1")) {
paramList =
"EditItemForm.jsp?icode="
+ mi.rs.getString(1)
+ "&igcode="
+ mi.rs.getString(7)
+ "&iname="
+ mi.rs.getString(3)
+ "&iweight="
+ mi.rs.getString(4)
+ "&imrp="
+ mi.rs.getString(5)
+ "&irate="
+ mi.rs.getString(6)
+ "&id_type="
+ mi.rs.getString(10)
+ "&id_flag="
+ mi.rs.getString(9)
+ "&id_qty="
+ mi.rs.getString(11)
+ "&id_amt="
+ mi.rs.getString(12)
+ "&i_comm="
+ mi.rs.getString(13)
+ "&i_tickflag="
+ mi.rs.getString(14)
+ "&ibarcode="
+ mi.rs.getString(15)
+ "&box_qty="
+ mi.rs.getInt(16)
+ "&is_bachka="
+ mi.rs.getString("is_bachka")
+ "&is_mixture="
+ mi.rs.getString("mix_item")
+ "&groupCodeValue="
+ mi.rs.getString("item_group_code");
} else {
paramList =
"ItemDetails.jsp?icode="
+ mi.rs.getString(1)
+ "&igcode="
+ mi.rs.getString(7)
+ "&iname="
+ mi.rs.getString(3)
+ "&iweight="
+ mi.rs.getString(4)
+ "&imrp="
+ mi.rs.getString(5);
}
changeParamList =
"ChangeQuantityItemForm.jsp?icode="
+ mi.rs.getString(1)
+ "&igcode="
+ mi.rs.getString(7)
+ "&iname="
+ mi.rs.getString(3)
+ "&iweight="
+ mi.rs.getString(4)
+ "&imrp="
+ mi.rs.getString(5)
+ "&irate="
+ mi.rs.getString(6)
+ "&id_type="
+ mi.rs.getString(10)
+ "&id_flag="
+ mi.rs.getString(9)
+ "&id_qty="
+ mi.rs.getString(11)
+ "&id_amt="
+ mi.rs.getString(12)
+ "&i_comm="
+ mi.rs.getString(13)
+ "&i_tickflag="
+ mi.rs.getString(14)
+ "&ibarcode="
+ mi.rs.getString(15);
out.write("\n");
out.write("\t\t\t <tr id=\"tr\" align=\"left\">\t\t\n");
out.write("\t\t\t\t<td align=\"left\"><a href=\"");
out.print(paramList);
out.write('"');
out.write('>');
out.print(mi.rs.getString(1));
out.write("</a></td>\n");
out.write(" \t \t\t<td><a href=\"");
out.print(changeParamList);
out.write("\">Change Quantity</a></td>\n");
out.write(" \t \t\t<td>");
out.print(mi.rs.getString(7));
out.write("</td>\n");
out.write(" \t \t\t<td>");
out.print(mi.rs.getString(3));
out.write("</td>\n");
out.write(" \t \t\t<td>");
out.print(mi.rs.getString(15));
out.write("</td>\n");
out.write(" \t \t\t<td>");
out.print(mi.rs.getString(4));
out.write("</td>\n");
out.write(" \t \t\t<td>");
out.print(df.format(mi.rs.getFloat(5)));
out.write("</td>\n");
out.write(" \t \t\t<td>");
out.print(df.format(mi.rs.getFloat(6)));
out.write("</td>\n");
out.write(" \t \t\t");
out.write("\n");
out.write(" \t \t\t<td>\n");
String msg1 = mi.rs.getString(9);
if (msg1.equals("N")) {
out.println("No");
} else {
out.println("Yes");
}
out.write(" \n");
out.write(" \t\t</td><td>\n");
String msg2 = mi.rs.getString(14);
if (msg2.equals("N")) {
out.println("No");
} else {
out.println("Yes");
}
out.write(" \n");
out.write(" \t</td>\n");
out.write(" \t<td>");
out.print(mi.rs.getString("is_bachka"));
out.write("</td>\n");
out.write(" \t<td>");
out.print(mi.rs.getString("mix_item"));
out.write("</td><td> \n");
String msg = mi.rs.getString(8);
if (!msg.equals("NH")) {
out.write(" \n");
out.write(" \t <a href=\"ItemHistoryForm.jsp?icode=");
out.print(mi.rs.getString(1));
out.write("\">history\n");
}
out.write("\t\t\t\n");
out.write("\t\t\t\t\n");
out.write(" \t \n");
out.write("\t\t\t </td></tr>\n");
out.write("\t\t\t\n");
}
mi.closeAll();
out.write("\n");
out.write("\t\t\t <style type=\"text/css\">\n");
out.write("\t\t\t a:link {color: blue}\n");
out.write("\t\t\t a:hover {background: blue;color: white}\n");
out.write("\t\t\t a:active {background: blue;color: white}\n");
out.write("\t\t\t </style>\n");
out.write("\n");
out.write("\t</tbody>\n");
out.write("</table>\n");
out.write("\t\t\t\n");
out.write(" \t");
} catch (java.lang.Throwable t) {
if (!(t instanceof javax.servlet.jsp.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);
else throw new ServletException(t);
}
} finally {
_jspxFactory.releasePageContext(_jspx_page_context);
}
}
public void _jspService(
final javax.servlet.http.HttpServletRequest request,
final javax.servlet.http.HttpServletResponse response)
throws java.io.IOException, javax.servlet.ServletException {
final javax.servlet.jsp.PageContext pageContext;
javax.servlet.http.HttpSession session = null;
final javax.servlet.ServletContext application;
final javax.servlet.ServletConfig config;
javax.servlet.jsp.JspWriter out = null;
final java.lang.Object page = this;
javax.servlet.jsp.JspWriter _jspx_out = null;
javax.servlet.jsp.PageContext _jspx_page_context = null;
try {
response.setContentType("text/html");
pageContext =
_jspxFactory.getPageContext(
this,
request,
response,
"ReportErrorPage.jsp?page=EditTargetReportForm.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("\n");
out.write("\n");
out.write("\n");
out.write("\n");
out.write("\n");
org.apache.jasper.runtime.JspRuntimeLibrary.include(
request, response, "header.jsp", out, false);
out.write(' ');
out.write('\n');
out.write("\n");
out.write("\n");
out.write("\n");
out.write("\t<!-- files for JqxWidget grid -->\n");
out.write(
" <link rel=\"stylesheet\" href=\"js/jqwidgets/styles/jqx.base.css\" type=\"text/css\" />\n");
out.write(
" <link rel=\"stylesheet\" href=\"js/jqwidgets/styles/jqx.darkblue.css\" type=\"text/css\" />\n");
out.write(
"\t<link rel=\"stylesheet\" href=\"js/jqwidgets/styles/jqx.ui-redmond.css\" type=\"text/css\" />\n");
out.write("\t\n");
out.write(
" <script type=\"text/javascript\" src=\"js/jqwidgets/gettheme.js\"></script>\n");
out.write("\t<script type=\"text/javascript\" src=\"js/jquery-1.10.2.min.js\"></script>\n");
out.write(" <script type=\"text/javascript\" src=\"js/jqwidgets/jqxcore.js\"></script>\n");
out.write(" <script type=\"text/javascript\" src=\"js/jqwidgets/jqxdata.js\"></script>\n");
out.write(
" <script type=\"text/javascript\" src=\"js/jqwidgets/jqxbuttons.js\"></script>\n");
out.write(
" <script type=\"text/javascript\" src=\"js/jqwidgets/jqxscrollbar.js\"></script>\n");
out.write(
" <script type=\"text/javascript\" src=\"js/jqwidgets/jqxlistbox.js\"></script>\n");
out.write(
" <script type=\"text/javascript\" src=\"js/jqwidgets/jqxcalendar.js\"></script>\n");
out.write(
" <script type=\"text/javascript\" src=\"js/jqwidgets/jqxdatetimeinput.js\"></script>\n");
out.write(" <script type=\"text/javascript\" src=\"js/jqwidgets/jqxgrid.js\"></script>\n");
out.write(
" <script type=\"text/javascript\" src=\"js/jqwidgets/jqxgrid.filter.js\"></script>\n");
out.write(
" <script type=\"text/javascript\" src=\"js/jqwidgets/jqxgrid.selection.js\"></script>\n");
out.write(
" <script type=\"text/javascript\" src=\"js/jqwidgets/jqxgrid.sort.js\"></script>\n");
out.write(
" <script type=\"text/javascript\" src=\"js/jqwidgets/jqxgrid.pager.js\"></script>\n");
out.write(
" <script type=\"text/javascript\" src=\"js/jqwidgets/jqxmenu.js\"></script>\n");
out.write(
" <script type=\"text/javascript\" src=\"js/jqwidgets/jqxlistbox.js\"></script>\n");
out.write(
" <script type=\"text/javascript\" src=\"js/jqwidgets/jqxdropdownlist.js\"></script>\n");
out.write(
" <script type=\"text/javascript\" src=\"js/jqwidgets/jqxdata.export.js\"></script> \n");
out.write(
" <script type=\"text/javascript\" src=\"js/jqwidgets/jqxgrid.export.js\"></script> \n");
out.write(
" <script type=\"text/javascript\" src=\"js/jqwidgets/jqxgrid.aggregates.js\"></script> \n");
out.write(
" <script type=\"text/javascript\" src=\"js/jqwidgets/jqxgrid.grouping.js\"></script> \n");
out.write("\n");
out.write("\n");
out.write("\t\n");
out.write("\t");
session.getAttribute("UserName").toString();
// System.out.println("session bachka maapping : "+session +" \n user
// "+session.getAttribute("UserName").toString());
out.write("\n");
out.write("\n");
out.write("\n");
out.write("<script src=\"js/editCustomer_details.js\"> </script> \n");
out.write("\n");
out.write("<script type=\"text/javascript\" src=\"js/popup.js\"></script>\n");
out.write("<style>\n");
out.write("hr {\n");
out.write("color: #f00;\n");
out.write("background-color: #f00;\n");
out.write("height: 3px;\n");
out.write("}\n");
out.write("#selected_order{\n");
out.write("width: 40%;\n");
out.write("max-height: 300px;\n");
out.write("border: 1px solid black; \n");
out.write("background-color: #ECFB99;\n");
out.write("float: right;\n");
out.write("margin-top: 30px;\n");
out.write("overflow: auto;\n");
out.write("margin-right: 2%;\n");
out.write("padding: 5px;\n");
out.write("}\n");
out.write("</style>\n");
out.write("<script>\n");
out.write("\t\n");
out.write("\tfunction checkField(){\n");
out.write("\t\tif(document.myform.chckall.checked==true){\n");
out.write("\t\t\tshowHint();\n");
out.write("\t\t}\n");
out.write("\t\telse{\t\tvar c_date1,c_date2,u_date2,u_date1;\n");
out.write("\t\t\t\tif(!($(\"#createDate2\").jqxDateTimeInput('disabled'))){\n");
out.write("\t\t\t\tc_date1 = $('#createDate1').jqxDateTimeInput('getText');\n");
out.write("\t\t\t\tc_date2 = $('#createDate2').jqxDateTimeInput('getText');\n");
out.write("\t\t\t}\n");
out.write("\t\t\t\n");
out.write("\t\t\tif(!($(\"#updateDate2\").jqxDateTimeInput('disabled'))){\n");
out.write("\t\t\t\tu_date1 = $('#updateDate1').jqxDateTimeInput('getText');\n");
out.write("\t\t\t\tu_date2 = $('#updateDate2').jqxDateTimeInput('getText');\n");
out.write("\t\t\t}\t \n");
out.write("\t\t showHint();\t\t \n");
out.write("\t }\n");
out.write("\t}\n");
out.write("\tfunction showMsg(){\n");
out.write("\t \t document.myform.action=\"HomeForm.jsp\";\n");
out.write("\t \t document.myform.submit();\n");
out.write("\t}\n");
out.write("\tfunction Clear(){\n");
out.write("\t\t\n");
out.write("\t\ttry{\n");
out.write("\t\t\tdocument.getElementById(\"order_number\").focus();\n");
out.write("\t\t} catch (exp){}\n");
out.write("\t\t\n");
out.write("\t\t\n");
out.write("\t\t\n");
out.write("\t\tdocument.myform.custCode.value=\"\";\n");
out.write("\t\tdocument.myform.phonenumber.value=\"\";\n");
out.write("\t\tdocument.myform.custName.value=\"\";\n");
out.write("\t\tdocument.myform.nameString.value=\"\";\t\t\n");
out.write("\t\tdocument.myform.Building.value=\"\";\n");
out.write("\t\tdocument.myform.Building_no.value=\"\";\n");
out.write("\t\tdocument.myform.wing.value=\"\";\n");
out.write("\t\tdocument.myform.block.value=\"\";\n");
out.write("\t\tdocument.myform.add1.value=\"\";\n");
out.write("\t\tdocument.myform.add2.value=\"\";\n");
out.write("\t\tdocument.myform.area.value=\"\";\n");
out.write("\t\tdocument.myform.station.value=\"\";\n");
out.write("\t\t\n");
out.write("\t\tdocument.myform.selmonth.value=\"\";\n");
out.write("\t\t\n");
out.write(
"\t\t$(\"#createDate1\").jqxDateTimeInput({theme:'ui-redmond',width: '250px', height: '25px',max:new Date(),formatString: \"yyyy-MM-dd\"});\n");
out.write(
"\t\t$(\"#createDate2\").jqxDateTimeInput({theme:'ui-redmond',width: '250px', height: '25px',min:new Date(),max:new Date(),formatString: \"yyyy-MM-dd\",value:new Date()});\n");
out.write("\t\t$(\"#createDate2\").jqxDateTimeInput({disabled: true});\n");
out.write("\t\t\n");
out.write("\t\t\n");
out.write(
"\t\t$(\"#updateDate1\").jqxDateTimeInput({theme:'ui-redmond',width: '250px', height: '25px',max:new Date(),formatString: \"yyyy-MM-dd\"});\n");
out.write(
"\t\t$(\"#updateDate2\").jqxDateTimeInput({theme:'ui-redmond',width: '250px', height: '25px',min:new Date(),max:new Date(),formatString: \"yyyy-MM-dd\",value:new Date()});\n");
out.write("\t\t$(\"#updateDate2\").jqxDateTimeInput({disabled: true});\n");
out.write("\t\t\n");
out.write("\t\t$('#createDate1').on('close', function (event) {\n");
out.write("\t\t // Some code here. \n");
out.write("\t\t \t$(\"#createDate2\").jqxDateTimeInput({disabled: false});\n");
out.write(
"\t\t \t$(\"#createDate2\").jqxDateTimeInput({min: $('#createDate1').jqxDateTimeInput('getDate')});\n");
out.write(" \t\t}); \t\n");
out.write(" \t\t\n");
out.write(" \t\t$('#updateDate1').on('close', function (event) {\n");
out.write("\t\t // Some code here. \n");
out.write("\t\t \t$(\"#updateDate2\").jqxDateTimeInput({disabled: false});\n");
out.write(
"\t\t \t$(\"#updateDate2\").jqxDateTimeInput({min: $('#updateDate1').jqxDateTimeInput('getDate')});\n");
out.write(" \t\t}); \t\n");
out.write("\t\t\n");
out.write("\t\tfunEnabled();\n");
out.write("\t}\n");
out.write("\t\n");
out.write("function ckeckEmpty(){\n");
out.write("\tif(document.getElementById(\"order_number\").value == \"\"){\n");
out.write("\t\talert(\"Please Enter Order Number\");\n");
out.write("\t\tdocument.getElementById(\"order_number\").focus();\n");
out.write("\t\treturn false;\n");
out.write("\t} else {\n");
out.write("\t\treturn true;\n");
out.write("\t}\n");
out.write("}\n");
out.write("\n");
out.write("\n");
out.write("</script>\n");
String call_type = request.getParameter("call_type");
if (call_type == null) {
call_type = "";
}
if (call_type.equals("search_payment")) {
String m = "<< Show List";
out.write("\n");
out.write("\t\t\t<div id=\"selected_order\">\n");
out.write("\t\t\t\t<b>Selected orders</b>\n");
out.write(
"\t\t\t\t<form action=\"PrintSelectedCustPayment.jsp\" method=\"get\" id=\"submit_form\">\n");
out.write(
"\t\t\t\t<table style=\"width: 100%;border-collapse: collapse;\" border=1 id=\"selected_order_table\">\n");
out.write("\t\t\t\t<tr>\n");
out.write("\t\t\t\t\t<th style=\"width: 20%;\">Order Number</th>\n");
out.write("\t\t\t\t\t<th style=\"width: 35%;\">Cust Name</th>\n");
out.write("\t\t\t\t\t<th style=\"width: 20%;\">Balance</th>\n");
out.write("\t\t\t\t\t<th style=\"width: 25%;\"> </th>\n");
out.write("\t\t\t\t</tr>\n");
out.write("\t\t\t\t</table>\n");
out.write("\t\t\t\t<table style=\"width: 100%;\" border=1 id=\"insert_table\">\n");
out.write("\t\t\t\t</table>\n");
out.write(
"\t\t\t\t <input type=\"text\" readonly=\"readonly\" name=\"order_count\" id=\"order_count_id\" size=\"3\" value=\"0\" style=\"background-color :#ECFB99 ;\"/> orders selected to print.\n");
out.write(
"\t\t\t\t<input type=\"submit\" onclick=\" return printSelectedInformation()\" value=\"Print\" style=\"float: right;\"/>\n");
out.write("\t\t\t\t</form>\n");
out.write("\t\t\t</div>\n");
out.write("\t\t");
}
if (!call_type.equals("search_payment") || !call_type.equals("communication")) {
out.write("\n");
out.write("<center>\n");
}
out.write("\n");
out.write("<fieldset style=\"width: 55%;\"><legend>\n");
String msg = request.getParameter("msg");
if (call_type.equals("receive_payment")) {
out.print("<h3>Search Customer To Receive Payment</h3>");
} else if (call_type.equals("search_payment")) {
out.print("<h3>Search Customer To See Pending</h3>");
} else if (call_type.equals("communication")) {
out.print("<h3>Search Customer To Communicate</h3>");
} else {
out.print("<h3>Search Customer</h3>");
}
out.write("\n");
out.write("</legend>\n");
if (call_type.equals("receive_payment")) {
out.write("\n");
out.write(
"\t\t<input type = \"radio\" name = \"radio\" onclick=\"ChangeCriteria('order')\" checked=\"checked\"/>Search By Order Number\n");
out.write(
"\t\t<input type = \"radio\" name = \"radio\" onclick=\"ChangeCriteria('cust')\"/>Search By Customer Detail\n");
out.write("\t");
}
if (call_type.equals("receive_payment")) {
out.write("\n");
out.write("\t<br/><br/>\n");
out.write("<form id=\"myform1\" action=\"SearchCustUsingOrderNo.jsp\" method=\"get\">\n");
out.write("\t");
if (msg != null) {
out.print("<i><font color=red>No Matching Record Found</font></i><br/><br/>");
}
out.write("\n");
out.write(
"\tEnter Order Number : <input type = \"text\" name = \"order_number\" value=\"\" id =\"order_number\" onkeypress=\"return isNumberKey(event)\"/>\n");
out.write(
"\t<input type = \"submit\" value=\"Search\" onclick=\"return ckeckEmpty();\"/>\n");
out.write("\n");
out.write("<br/>\n");
out.write("</form>\n");
out.write("<form name=\"myform\" method=\"post\" id=\"myform\" style=\"display: none\">\n");
} else {
out.write("\n");
out.write("<form name=\"myform\" method=\"post\" id=\"myform\" >\n");
}
out.write("\n");
out.write("\t<table style=\"width: 100%;\">\n");
out.write("\t\t<tr style=\"width: 100%;\">\n");
out.write(
"\t\t\t<td align=\"center\" colspan=3><b><font color=\"blue\"> A</font>ll Customers List       \n");
out.write(
"\t\t\t<input type=\"CheckBox\" name=\"chckall\" accesskey=\"a\" onClick=\"funEnabled();\"></td>\n");
out.write("\t\t</tr>\t\t\n");
out.write("\t\t<tr style=\"width: 100%;\">\n");
out.write("\t\t\t<td colspan=3>\n");
out.write("\t\t\t<div id=\"div4\" style=\"width: 100%;\" >\n");
out.write("\t\t\t\t<table>\t\t\t\t\n");
out.write("\t\t\t\t\t<tr>\n");
out.write("\t\t\t\t\t\t<td style=\"width: 15%;\" align=\"left\">\n");
out.write("\t\t\t\t\t\t\t<b><font color=\"blue\">C</font>ustomer Code</b>\n");
out.write("\t\t\t\t\t\t</td>\n");
out.write("\t\t\t\t\t\t<td style=\"width: 1%;\" align=\"left\">:</td>\n");
out.write(
"\t\t\t\t\t\t<td style=\"width: 29%;\"><input style=\"width: 97%;\" type=\"text\" name=\"custCode\" accesskey=\"c\"></td>\n");
out.write("\t\t\t\t\t\t");
if (call_type.equals("search_payment") || call_type.equals("communication")) {
out.write("\n");
out.write("\t\t\t\t\t\t<td style=\"width: 8%;\" align=\"left\"></td>\n");
out.write("\t\t\t\t\t\t\n");
out.write("\t\t\t\t\t\t<td style=\"width: 15%;\" align=\"left\">\n");
out.write("\t\t\t\t\t\t\t<b>O<font color=\"blue\">r</font>der Number</b>\n");
out.write("\t\t\t\t\t\t</td>\n");
out.write("\t\t\t\t\t\t<td style=\"width: 1%;\" align=\"left\">:</td>\n");
out.write(
"\t\t\t\t\t\t<td style=\"width: 29%;\"><input style=\"width: 97%;\" type=\"text\" name=\"ordernumber\" accesskey=\"c\"></td>\n");
out.write("\t\t\t\t\t\t");
}
out.write("\n");
out.write("\t\t\t\t\t</tr>\n");
out.write("\t\t\t\t\t<tr>\n");
out.write(
"\t\t\t\t\t\t<td style=\"width: 15%;\" align=\"left\"><b>Customer <font color=\"blue\">N</font>ame</b></td>\n");
out.write("\t\t\t\t\t\t<td style=\"width: 1%;\" align=\"left\">:</td>\n");
out.write(
"\t\t\t\t\t\t<td style=\"width: 29%;\"><input style=\"width: 97%;\" type=\"text\" name=\"custName\" align=\"right\" accesskey=\"n\"></td>\n");
out.write("\t\t\t\t\t\t\n");
out.write("\t\t\t\t\t\t<td style=\"width: 8%;\" align=\"left\"></td>\n");
out.write("\t\t\t\t\t\t\n");
out.write(
"\t\t\t\t\t\t<td style=\"width: 15%;\" align=\"left\"><b><font color=\"blue\">P</font>hone Number</b></td>\n");
out.write("\t\t\t\t\t\t<td style=\"width: 1%;\" align=\"left\">:</td>\n");
out.write(
"\t\t\t\t\t\t<td style=\"width: 29%;\"><input style=\"width: 97%;\" type=\"text\" name=\"phonenumber\" size=\"22\" align=\"right\" colspan=\"2\" accesskey=\"p\"></td>\n");
out.write("\t\t\t\t\t\t\n");
out.write("\t\t\t\t\t</tr>\n");
out.write("\t\t\t\t\t<tr>\n");
out.write(
"\t\t\t\t\t\t<td style=\"width: 15%;\" align=\"left\"><b>M<font color=\"blue\">o</font>bile Number</b></td>\n");
out.write("\t\t\t\t\t\t<td style=\"width: 1%;\" align=\"left\">:</td>\n");
out.write(
"\t\t\t\t\t\t<td><input style=\"width: 97%;\" type=\"text\" name=\"mobilenumber\" size=\"22\" align=\"right\" colspan=\"2\" accesskey=\"o\"></td>\n");
out.write("\t\t\t\t\t\t\n");
out.write("\t\t\t\t\t\t<td style=\"width: 8%;\" align=\"left\"></td>\n");
out.write("\t\t\t\t\t\t\n");
out.write(
"\t\t\t\t\t\t<td style=\"width: 15%;\" align=\"left\"><b>Na<font color=\"blue\">m</font>e String</b></td>\n");
out.write("\t\t\t\t\t\t<td style=\"width: 1%;\" align=\"left\">:</td>\n");
out.write(
"\t\t\t\t\t\t<td><input style=\"width: 97%;\" style=\"width: 100%;\" type=\"text\" name=\"nameString\" size=\"22\" align=\"right\" accesskey=\"m\" colspan=\"2\"></td>\n");
out.write("\t\t\t\t\t</tr>\n");
out.write("\t\t\t\t\t<tr>\n");
out.write(
"\t\t\t\t\t\t<td style=\"width: 15%;\" align=\"left\"><b><font color=\"blue\">B</font>uilding</b></td>\n");
out.write("\t\t\t\t\t\t<td style=\"width: 1%;\" align=\"left\">:</td>\n");
out.write(
"\t\t\t\t\t\t<td><input style=\"width: 97%;\" type=\"text\" name=\"Building\" accesskey=\"b\" align=\"right\"></b></td>\n");
out.write("\t\t\t\t\t\t\n");
out.write("\t\t\t\t\t\t<td style=\"width: 8%;\" align=\"left\"></td>\n");
out.write("\t\t\t\t\t\t\n");
out.write(
"\t\t\t\t\t\t<td style=\"width: 15%;\" align=\"left\"><b>Building <font color=\"blue\">N</font>o.</b></td>\n");
out.write("\t\t\t\t\t\t<td style=\"width: 1%;\" align=\"left\">:</td>\n");
out.write(
"\t\t\t\t\t\t<td><input style=\"width: 97%;\" type=\"text\" name=\"Building_no\" size=\"22\" accesskey=\"o\"></b></td>\n");
out.write("\t\t\t\t\t</tr>\n");
out.write("\t\t\t\t\t<tr>\n");
out.write(
"\t\t\t\t\t <td style=\"width: 15%;\" align=\"left\"><b><font color=\"blue\">W</font>ing</b></td>\n");
out.write("\t\t\t\t\t <td style=\"width: 1%;\" align=\"left\">:</td>\n");
out.write(
"\t\t\t\t\t <td><input style=\"width: 97%;\" type =\"text\" name=\"wing\" accesskey=\"w\" ></td>\n");
out.write("\t\t\t\t\t \n");
out.write("\t\t\t\t\t <td style=\"width: 8%;\" align=\"left\"></td>\n");
out.write("\t\t\t\t\t \n");
out.write(
"\t\t\t\t\t\t<td style=\"width: 15%;\" align=\"left\"><b><font color=\"blue\">F</font>lat No.</b></td>\n");
out.write("\t\t\t\t\t\t<td style=\"width: 1%;\" align=\"left\">:</td>\n");
out.write(
"\t\t\t\t\t\t<td><input style=\"width: 97%;\" type =\"text\" name=\"block\" size=\"22\" accesskey=\"f\" align=\"right\">\n");
out.write("\t\t\t\t\t\t</tr>\n");
out.write("\t\t\t\t\t<tr>\n");
out.write(
"\t\t\t\t\t\t<td style=\"width: 15%;\" align=\"left\"><b>Addr<font color=\"blue\">e</font>ss1</b></td>\n");
out.write("\t\t\t\t\t\t<td style=\"width: 1%;\" align=\"left\">:</td>\n");
out.write(
"\t\t\t\t\t\t<td><input style=\"width: 97%;\" type =\"text\" accesskey=\"e\" name=\"add1\"></td>\n");
out.write("\t\t\t\t\t\t\n");
out.write("\t\t\t\t\t\t<td style=\"width: 8%;\" align=\"left\"></td>\n");
out.write("\t\t\t\t\t\t\n");
out.write(
"\t\t\t\t\t\t<td style=\"width: 15%;\" align=\"left\"><b>A<font color=\"blue\">d</font>dress2</b></td>\n");
out.write("\t\t\t\t\t\t<td style=\"width: 1%;\" align=\"left\">:</td>\n");
out.write(
"\t\t\t\t\t\t<td><input style=\"width: 97%;\" type =\"text\" accesskey=\"d\" name=\"add2\" size=\"22\"></td>\n");
out.write("\t\t\t\t\t</tr>\n");
out.write("\t\t\t\t\t<tr >\n");
out.write(
"\t\t\t\t\t\t<td style=\"width: 15%;\" align=\"left\"><b>A<font color=\"blue\">r</font>ea</b></td>\n");
out.write("\t\t\t\t\t\t<td style=\"width: 1%;\" align=\"left\">:</td>\n");
out.write("\t\t\t\t\t\t<td>\n");
out.write("\t\t\t\t\t\t");
String name;
try {
Context initContext = new InitialContext();
Context envContext = (Context) initContext.lookup("java:/comp/env");
// DataSource ds = (DataSource)envContext.lookup("jdbc/js");
DataSource ds = (DataSource) envContext.lookup("jdbc/re");
Connection conn = ds.getConnection();
Statement stmt = conn.createStatement();
ResultSet rs =
stmt.executeQuery(
"select value from code_table where category='AREA' order by value asc");
out.write("\n");
out.write("\t\t\t\t\t\t\t<SELECT style=\"width: 97%;\" name=\"area\">\n");
out.write("\t\t\t\t\t\t\t\t<OPTION VALUE=\"\"> Select Area </OPTION>\n");
out.write("\t\t\t\t\t\t");
while (rs.next()) {
name = rs.getString(1);
out.write("\n");
out.write("\t\t\t\t\t\t\t\t<OPTION VALUE=\"");
out.print(name);
out.write('"');
out.write('>');
out.write(' ');
out.print(name);
out.write(" </OPTION>\n");
out.write("\t\t\t\t\t\t");
}
out.write("\n");
out.write("\t\t\t\t\t\t\t</SELECT>\n");
out.write("\t\t\t\t\t\t</td>\t\n");
out.write("\t\t\t\t\t\t\n");
out.write("\t\t\t\t\t\t<td style=\"width: 8%;\" align=\"left\"></td>\n");
out.write("\t\t\t\n");
out.write(
"\t\t\t\t\t\t<td style=\"width: 15%;\" align=\"left\"><b>Payment Type</b></td>\n");
out.write("\t\t\t\t\t\t<td style=\"width: 1%;\" align=\"left\">:</td>\n");
out.write("\t\t\t\t\t\t<td>\n");
out.write("\t\t\t\t\t\t\t<SELECT style=\"width: 97%;\" name=\"payment\" align=\"left\">\n");
out.write("\t\t\t\t\t\t\t\t<OPTION selected VALUE=\"\"> Select Type </OPTION>\n");
out.write("\t\t\t\t\t\t\t\t<OPTION VALUE=\"NoType\"> No Type </OPTION>\n");
out.write("\t\t\t\t\t\t");
ResultSet rs2 =
stmt.executeQuery("SELECT payment_type_code, payment_type_desc FROM payment_type");
while (rs2.next()) {
out.write("\t\n");
out.write("\t\t\t\t\t\t\t\t<OPTION VALUE=\"");
out.print(rs2.getString(1));
out.write('"');
out.write('>');
out.write(' ');
out.print(rs2.getString(2));
out.write(" </OPTION>\n");
out.write("\t\t\t\t\t\t");
}
rs2.close();
stmt.close();
conn.close();
} catch (Exception e) {
e.getMessage();
e.printStackTrace();
}
out.write("\n");
out.write("\t\t\t\t\t\t\t</SELECT>\n");
out.write("\t\t\t\t\t\t</td>\n");
out.write("\t\t\t\t\t</tr>\n");
out.write("\t\t\t\t\t<tr>\n");
out.write(
"\t\t\t\t\t\t<td style=\"width: 15%;\" align=\"left\"><b>Create<font color=\"blue\">D</font>ate</b></td>\n");
out.write("\t\t\t\t\t\t<td style=\"width: 1%;\" align=\"left\">:</td>\n");
out.write("\t\t\t\t\t\t<td>\n");
out.write(
"\t\t\t\t\t\t\t<!-- <input type =\"text\" accesskey=\"d\" name=\"c_date1\" size=\"15\" style=\"width: 79%;\">\n");
out.write(
"\t\t\t\t\t\t\t<input type=\"button\" onClick=\"c1.popup('c_date1');\" value=\"...\" style=\"width: 15%;\"/> -->\n");
out.write("\t\t\t\t\t\t\t<div id='createDate1'></div>\n");
out.write("\t\t\t\t\t\t</td>\n");
out.write("\t\t\t\t\t\t\t\n");
out.write("\t\t\t\t\t\t<td style=\"width: 8%;\" align=\"left\"></td>\n");
out.write("\t\t\t\t\t\t\t\n");
out.write("\t\t\t\t\t\t<td style=\"width: 15%;\" align=\"left\"><b>And</b></td>\n");
out.write("\t\t\t\t\t\t<td style=\"width: 1%;\" align=\"left\">:</td>\n");
out.write("\t\t\t\t\t\t<td> \n");
out.write(
"\t\t\t\t\t\t\t<!-- <input type =\"text\" name=\"c_date2\" size=\"15\" style=\"width: 79%;\">\n");
out.write(
"\t\t\t\t\t\t\t<input type=\"button\" onClick=\"c1.popup('c_date2');\" value=\"...\" style=\"width: 15%;\"/> -->\n");
out.write("\t\t\t\t\t\t\t<div id='createDate2'></div>\n");
out.write("\t\t\t\t\t\t\t\n");
out.write("\t\t\t\t\t\t</td>\n");
out.write("\t\t\t\t\t</tr>\n");
out.write("\t\t\t\t\t<tr>\n");
out.write(
"\t\t\t\t\t\t<td style=\"width: 15%;\" align=\"left\"><b><font color=\"blue\">U</font>pdate Date</b></td>\n");
out.write("\t\t\t\t\t\t<td style=\"width: 1%;\" align=\"left\">:</td>\n");
out.write("\t\t\t\t\t\t<td>\n");
out.write(
"\t\t\t\t\t\t\t<!-- <input type =\"text\" accesskey=\"u\" name=\"u_date1\" size=\"15\" style=\"width: 79%;\"/>\n");
out.write(
"\t\t\t\t\t\t\t<input type=\"button\" onClick=\"c1.popup('u_date1');\" value=\"...\" style=\"width: 15%;\"/> -->\n");
out.write("\t\t\t\t\t\t\t<div id=\"updateDate1\"></div>\n");
out.write("\t\t\t\t\t\t</td>\n");
out.write("\t\t\t\t\t\t\t\n");
out.write("\t\t\t\t\t\t<td style=\"width: 8%;\" align=\"left\"></td>\n");
out.write("\t\t\t\t\t\t\t\n");
out.write("\t\t\t\t\t\t<td style=\"width: 15%;\" align=\"left\"><b>And</b></td>\n");
out.write("\t\t\t\t\t\t<td style=\"width: 1%;\" align=\"left\">:</td>\n");
out.write("\t\t\t\t\t\t<td> \n");
out.write(
"\t\t\t\t\t\t\t<!-- <input type =\"text\" name=\"u_date2\" size=\"15\" style=\"width: 79%;\"/>\n");
out.write(
"\t\t\t\t\t\t\t<input type=\"button\" onClick=\"c1.popup('u_date2');\" value=\"...\" style=\"width: 15%;\"/> -->\n");
out.write("\t\t\t\t\t\t\t<div id='updateDate2'></div>\n");
out.write("\t\t\t\t\t\t</td>\n");
out.write("\t\t\t\t\t</tr>\n");
out.write("\t\t\t\t\t<tr>\n");
out.write(
"\t\t\t\t\t<td style=\"width: 15%;\" align=\"left\"><b><font color=\"blue\">S</font>tation</b></td>\n");
out.write("\t\t\t\t\t<td style=\"width: 1%;\" align=\"left\">:</td>\n");
out.write(
"\t\t\t\t\t<td><input style=\"width: 97%;\" type =\"text\" size=\"22\" accesskey=\"d\" name=\"station\"></td>\n");
out.write("\t\t\t\t\t\t\n");
out.write("\t\t\t\t\t<td style=\"width: 8%;\" align=\"left\"></td>\n");
out.write("\t\t\t\t\t\t\n");
out.write("\t\t\t\t\t<td style=\"width: 15%;\" align=\"left\"><b>Last Order Days</b></td>\n");
out.write("\t\t\t\t\t<td style=\"width: 1%;\" align=\"left\">:</td>\n");
out.write(
"\t\t\t\t\t<td><input style=\"width: 97%;\" type=\"text\" name=\"selmonth\"/></td></tr>\n");
out.write("\t\t\t\t</table></div>\n");
out.write("\t\t\t</td>\n");
out.write("\t\t</tr>\n");
out.write("\t\t\t\n");
out.write("\t\t<tr>\n");
out.write("\t\t\t<td align=\"center\" colspan=4>\n");
out.write(
"\t\t\t\t<input type=\"submit\" name=\"search\" title=\"Press <Enter>\" value=\"Search <Enter>\" accesskey=\"s\" onclick=\"checkField();return false;\"/>\n");
out.write(
"\t\t\t\t<input type=\"reset\" name=\"clear\" title=\"Press <Alt+c>\" tabindex=\"1\" value=\"Clear <Alt+c>\" accesskey=\"c\" onclick=\"document.getElementById('txtHint').innerHTML='';\"/>\n");
out.write(
"\t\t\t\t<INPUT type=BUTTON value=\"Cancel <Alt+c>\" accesskey=\"c\" onClick=\"showMsg();\"/></center>\n");
out.write("\t\t\t</td>\n");
out.write("\t\t</tr>\n");
out.write("\t</table>\n");
out.write("\t</fieldset>\n");
out.write("\t<input type=\"hidden\" name=\"hchckall\" value=\"1\">\n");
out.write("\t<input type=\"hidden\" name=\"call_type\" value=\"");
out.print(call_type);
out.write("\"/>\n");
out.write("<script>\n");
out.write("function funEnabled(){\n");
out.write("\t if (document.myform.chckall.checked==true){\n");
out.write("\t\t\tdocument.getElementById('div4').style.visibility=\"hidden\";\n");
out.write("\t\t\tdocument.myform.hchckall.value=1;\t\t\n");
out.write("\t\t\t$(\"#createDate2\").jqxDateTimeInput({disabled: true});\n");
out.write("\t\t\t$(\"#updateDate2\").jqxDateTimeInput({disabled: true});\n");
out.write("\t\t\t\n");
out.write("\t\t}\n");
out.write("\t\telse{\n");
out.write("\t\t\tdocument.getElementById('div4').style.visibility=\"visible\";\n");
out.write("\t\t\tdocument.myform.hchckall.value=0;\t\t\t\n");
out.write("\t\t}\n");
out.write("\t}\n");
out.write("window.onload =Clear;\n");
out.write("\n");
out.write("function ChangeCriteria(str){\n");
out.write("\tif(str == \"cust\"){\n");
out.write("\t\tdocument.getElementById(\"myform\").style.display='block';\n");
out.write("\t\tdocument.getElementById(\"myform1\").style.display='none';\n");
out.write("\t}else if(str == \"order\"){\n");
out.write("\t\tdocument.getElementById(\"myform\").style.display='none';\n");
out.write("\t\tdocument.getElementById(\"myform1\").style.display='block';\n");
out.write("\t\tdocument.getElementById(\"txtHint\").innerHTML=\"\";\n");
out.write("\t\tdocument.getElementById(\"order_number\").focus();\n");
out.write("\t\tdocument.getElementById(\"order_number\").value=\"\";\n");
out.write("\t}\n");
out.write("}\n");
out.write("function isNumberKey(evt) {\n");
out.write("\tvar charCode = (evt.which) ? evt.which : event.keyCode;\n");
out.write("\tif (charCode != 46 && charCode > 31 && (charCode < 48 || charCode > 57))\n");
out.write("\t\treturn false;\n");
out.write("\telse\n");
out.write("\t\treturn true;\n");
out.write("}\n");
out.write("</script>\n");
out.write(
"\t<hr><center><div id=\"txtHint\" class=\"ddm1\" style=\"background-color: white;width: 100%;max-height: 400px;overflow: auto;\"></div></center>\n");
out.write("\t<br><br>\n");
out.write(
"\t<p><h1><center><div id=\"waitMessage\" style=\"cursor: sw-resize;\"></center></div></h1></p>\n");
String fromFromName = "";
if (request.getParameter("fromForm") != null) fromFromName = request.getParameter("fromForm");
// CustPmtHstry
out.write("\n");
out.write("\t<input type=\"hidden\" name=\"fromForm\" value=\"");
out.print(fromFromName);
out.write("\">\n");
out.write("</form>\n");
out.write("\n");
out.write(
"<div id=\"dispdiv\" align=\"center\" style=\"border:1px solid black; padding:25px; text-align:center; display:none; background-color:#FFF; overflow:auto; height:300px; width=200px;\"> </div>\n");
out.write("</body>\n");
out.write("</html>\n");
} catch (java.lang.Throwable t) {
if (!(t instanceof javax.servlet.jsp.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);
else throw new ServletException(t);
}
} finally {
_jspxFactory.releasePageContext(_jspx_page_context);
}
}
public void _jspService(HttpServletRequest request, HttpServletResponse response)
throws java.io.IOException, ServletException {
JspFactory _jspxFactory = null;
javax.servlet.jsp.PageContext pageContext = null;
HttpSession session = null;
ServletContext application = null;
ServletConfig config = null;
JspWriter out = null;
Object page = this;
JspWriter _jspx_out = null;
try {
_jspxFactory = JspFactory.getDefaultFactory();
response.setContentType("text/html;charset=ISO-8859-1");
pageContext = _jspxFactory.getPageContext(this, request, response, null, true, 8192, true);
application = pageContext.getServletContext();
config = pageContext.getServletConfig();
session = pageContext.getSession();
out = pageContext.getOut();
_jspx_out = out;
out.write("\n\n");
out.write("\n");
out.write("\n");
out.write("\n");
out.write("\n");
out.write("\n");
out.write("\n");
out.write("\n");
out.write("\n");
out.write("\n");
out.write("\n\n");
// This JSP handles cross context communications from wt-monitor
// to wt-core for use in accessing wt-core functionality that is
// needed in WTnav-tree.jsp.
// Assign a pooled DB connection handle
Context ctx = new InitialContext();
DataSource ds = (DataSource) ctx.lookup(WTConstants.WATCHTOWERDB_CONN);
int iIndex = 6100;
GraphViewManager graphman = new GraphViewManager(ds);
// Vector views = graphman.getViews();
Vector views = new Vector();
WTOrganization[] orgs = null;
WTAccountCredentials ac =
(WTAccountCredentials)
request.getSession().getAttribute(WTAccountCredentials.SESSION_ATTRIBUTE_AC);
if (ac != null) {
// WTOrganization[] orgs = null;
int selectedOrg = ac.getCurrentManagedId();
boolean siteUser = ac.getIsSiteUser();
int userId = ac.getUserId();
// Get list of organizations for the current user
if (siteUser) {
try {
orgs = DAOImpl.OrgDAO.getWTOrganization();
} catch (Exception e) {
e.printStackTrace();
}
} else {
if (!(userId < 0)) {
try {
orgs = DAOImpl.OrgDAO.getWTOrganizationsByUser(userId);
} catch (Exception e) {
e.printStackTrace();
}
}
}
// Get the list of actively managed nodes
if (selectedOrg == WTAccountCredentials.ALL_ORGS) {
if (siteUser) {
views = graphman.getViews();
} else {
if (orgs != null) {
int[] orgsIds = new int[orgs.length];
for (int i = 0; i < orgs.length; i++) {
orgsIds[i] = orgs[i].getID();
}
views = graphman.getViews(orgsIds);
}
}
} else {
views = graphman.getViews(selectedOrg);
}
}
// My Graph Views is an experimental feature and is commented out until all kinks are worked
// out. LS
String strOutput = null;
// if( views.size()==0 ) {
// strOutput = "nav.add(6100, 6000, 'My Graph Views', '/wt-monitor/report/index.jsp', 'My
// Customized Graph Views', 'mainContentsFrame', icon16_basedir + 'bs_chart.gif',
// icon16_basedir + 'bs_chart.gif', '');\r\n";
// } else {
// strOutput = "nav.add(6100, 6000, 'My Graph Views', '', 'My Customized Graph Views',
// 'mainContentsFrame', icon16_basedir + 'bs_chart.gif', icon16_basedir + 'bs_chart.gif',
// '');\r\n";
// }
// for (int i=0; i<views.size(); i++)
// {
// iIndex++;
// String strViewName = ((GraphViewJB)views.elementAt(i)).getName();
// int strOrgId = ((GraphViewJB)views.elementAt(i)).getOrgId();
// String orgName = null;
// for(int j=0;j<orgs.length;j++){
// if(orgs[j].getID() != -1 && orgs[j].getID() == strOrgId){
// orgName = orgs[j].getName();
// }
// }
//
// strOutput +="nav.add(" + iIndex +
// ", 6100, '" + strViewName +
// "', 'javascript:
// PopupCenteredWindow(\\'/wt-core/jsp/sysmon/graphview/GraphView.jsp?view=" + strViewName +
// "&orgname="+orgName +"&start=01&end=02" + "\\', \\'graphview\\', \\'yes\\', \\'yes\\',
// \\'yes\\', \\'900\\', \\'1010\\'); location.href=\\'/wt-monitor/wt-jsp/WTnav-tree.jsp\\';',
// 'Open " + strViewName + " Graph View', '', icon16_basedir + 'bs_chart.gif', icon16_basedir
// + 'bs_chart.gif', '');\r\n";
// }
out.write("\n\n");
out.write("\n");
out.write("\n");
out.write("\n");
out.write("\n\n");
out.print(strOutput);
out.write("\n");
} catch (Throwable t) {
out = _jspx_out;
if (out != null && out.getBufferSize() != 0) out.clearBuffer();
if (pageContext != null) pageContext.handlePageException(t);
} finally {
if (_jspxFactory != null) _jspxFactory.releasePageContext(pageContext);
}
}
public void _jspService(
final javax.servlet.http.HttpServletRequest request,
final javax.servlet.http.HttpServletResponse response)
throws java.io.IOException, javax.servlet.ServletException {
final java.lang.String _jspx_method = request.getMethod();
if (!"GET".equals(_jspx_method)
&& !"POST".equals(_jspx_method)
&& !"HEAD".equals(_jspx_method)
&& !javax.servlet.DispatcherType.ERROR.equals(request.getDispatcherType())) {
response.sendError(
HttpServletResponse.SC_METHOD_NOT_ALLOWED, "JSPs only permit GET POST or HEAD");
return;
}
final javax.servlet.jsp.PageContext pageContext;
javax.servlet.http.HttpSession session = null;
final javax.servlet.ServletContext application;
final javax.servlet.ServletConfig config;
javax.servlet.jsp.JspWriter out = null;
final java.lang.Object page = this;
javax.servlet.jsp.JspWriter _jspx_out = null;
javax.servlet.jsp.PageContext _jspx_page_context = null;
try {
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('\r');
out.write('\n');
String username = "";
if (session.getAttribute("login") != null) {
username = session.getAttribute("login").toString();
} else {
out.println("Invalid session! You must log back into the system.");
return;
}
String outputMsg = "TODO";
ResultSet employeeRevRes = null;
String JDBC_DRIVER = "com.mysql.jdbc.Driver";
String DB_URL = "jdbc:mysql://localhost:3306/SilkRoad 5.0";
String USER = "******";
String PASS = "******";
Statement stmt = null;
String sql = null;
Connection conn = null;
CallableStatement cs = null;
try {
// Register JDBC driver
Class.forName(JDBC_DRIVER).newInstance();
// Open a connection
conn = java.sql.DriverManager.getConnection(DB_URL, USER, PASS);
System.out.println("HERE");
cs = conn.prepareCall("call GetEmployeeRevenues()");
cs.execute();
employeeRevRes = cs.getResultSet();
// TODO. Error handling
out.write("\r\n");
out.write(" <html lang=\"en\">\r\n");
out.write(" <head>\r\n");
out.write(" <meta charset=\"utf-8\">\r\n");
out.write(" <meta http-equiv=\"X-UA-Compatible\" content=\"IE=edge\">\r\n");
out.write(
" <meta name=\"viewport\" content=\"width=device-width, initial-scale=1\">\r\n");
out.write(
" <!-- The above 3 meta tags *must* come first in the head; any other head content must come *after* these tags -->\r\n");
out.write(" <title>Silk Road 5.0</title>\r\n");
out.write(" <!-- Bootstrap -->\r\n");
out.write(" <link href=\"css/bootstrap.min.css\" rel=\"stylesheet\">\r\n");
out.write(" ");
out.write("\r\n");
out.write(
" <link href=\"css/responsive.bootstrap.min.css\" rel=\"stylesheet\" type=\"text/css\">\r\n");
out.write(
" <link href=\"https://cdnjs.cloudflare.com/ajax/libs/bootstrap3-dialog/1.34.5/css/bootstrap-dialog.min.css\" rel=\"stylesheet\" type=\"text/css\" />\r\n");
out.write(" <!-- Our own custom css -->\r\n");
out.write(
" <link href=\"css/stylesheet.css\" rel=\"stylesheet\" type=\"text/css\">\r\n");
out.write(
" <!-- HTML5 shim and Respond.js for IE8 support of HTML5 elements and media queries -->\r\n");
out.write(
" <!-- WARNING: Respond.js doesn't work if you view the page via file:// -->\r\n");
out.write(" <!--[if lt IE 9]>\r\n");
out.write(
" <script src=\"https://oss.maxcdn.com/html5shiv/3.7.2/html5shiv.min.js\"></script>\r\n");
out.write(
" <script src=\"https://oss.maxcdn.com/respond/1.4.2/respond.min.js\"></script>\r\n");
out.write(" <![endif]-->\r\n");
out.write(" <!-- jQuery (necessary for Bootstrap's JavaScript plugins) -->\r\n");
out.write(" <script src=\"js/jquery-1.11.3.min.js\"></script>\r\n");
out.write(" <script src=\"js/jquery.validate.js\"></script>\r\n");
out.write(" ");
out.write("\r\n");
out.write(
" <!-- Include all compiled plugins (below), or include individual files as needed -->\r\n");
out.write(" <script src=\"js/bootstrap.min.js\"></script>\r\n");
out.write(
" <script src=\"https://cdnjs.cloudflare.com/ajax/libs/bootstrap3-dialog/1.34.5/js/bootstrap-dialog.min.js\"></script>\r\n");
out.write(" <script src=\"js/pattern.js\"></script>\r\n");
out.write(" <script src=\"js/script.js\"></script>\r\n");
out.write(" <script src=\"js/editCustomer.js\"></script>\r\n");
out.write(" </head>\r\n");
out.write(" <nav class=\"navbar\">\r\n");
out.write(" <div class=\"container-fluid\">\r\n");
out.write(" <!-- Brand and toggle get grouped for better mobile display -->\r\n");
out.write(" <div class=\"navbar-header\">\r\n");
out.write(
" <button type=\"button\" class=\"navbar-toggle collapsed\" data-toggle=\"collapse\" data-target=\"#bs-example-navbar-collapse-1\" aria-expanded=\"false\">\r\n");
out.write(" <span class=\"sr-only\">Toggle navigation</span>\r\n");
out.write(" <span class=\"icon-bar\"></span>\r\n");
out.write(" <span class=\"icon-bar\"></span>\r\n");
out.write(" <span class=\"icon-bar\"></span>\r\n");
out.write(" </button>\r\n");
out.write(" </div>\r\n");
out.write(" <!-- navbar-header -->\r\n");
out.write(
" <!-- Collect the nav links, forms, and other content for toggling -->\r\n");
out.write(" <div class=\"myNavbar\">\r\n");
out.write(" <ul class=\"nav\">\r\n");
out.write(
" <li class=\"floatLeft\"><a href=\"ManagerInformation.jsp\">Home</a></li>\r\n");
out.write(
" <li class=\"dropdown navbar-right\" style=\"padding-left:125px;\">\r\n");
out.write(
" <a data-target=\"#collapseHelp\" data-toggle=\"collapse\">Help<span class=\"caret\"></span></a>\r\n");
out.write(" <ul>\r\n");
out.write(" <div id=\"collapseHelp\" class=\"dropdown-menu\">\r\n");
out.write(
" <li><a href=\"javascript:showEmployeeScreenHelp()\">Screens</a></li>\r\n");
out.write(" <br>\r\n");
out.write(
" <li><a href=\"javascript:showAuctionHelp()\">Auctions</a></li>\r\n");
out.write(" <br>\r\n");
out.write(" </div>\r\n");
out.write(" </ul>\r\n");
out.write(" </li>\r\n");
out.write(
" <li class=\"dropdown navbar-right\" style=\"padding-left:200px;\">\r\n");
out.write(
" <a data-target=\"#collapseMenu\" data-toggle=\"collapse\" >Menu<span class=\"caret\"></span></a>\r\n");
out.write(" <ul>\r\n");
out.write(" <div id=\"collapseMenu\" class=\"dropdown-menu\">\r\n");
out.write(" </div>\r\n");
out.write(" </ul>\r\n");
out.write(" </li>\r\n");
out.write(" </ul>\r\n");
out.write(" <!-- .nav -->\r\n");
out.write(" </div>\r\n");
out.write(" <!-- .myNavbar -->\r\n");
out.write(" </div>\r\n");
out.write(" <!-- .container-fluid -->\r\n");
out.write(" </nav>\r\n");
out.write(" <body class=\"auctionHouseBody\">\r\n");
out.write(
" <h4 class=\"auctionTableHeader\">Highest Grossing Employee</h4>\r\n");
out.write(
" <table id =\"bestSellersTable\" class=\"table table-striped table-bordered dt-responsive nowrap auctionHouseTable\">\r\n");
out.write(" <thead>\r\n");
out.write(" <tr>\r\n");
out.write(" <th>Employee ID</th>\r\n");
out.write(" <th>Username</th>\r\n");
out.write(" <th>Revenue</th>\r\n");
out.write(" </tr>\r\n");
out.write(" </thead>\r\n");
out.write(" <tbody>\r\n");
out.write(" ");
while (employeeRevRes.next()) {
out.write("\r\n");
out.write(" <tr>\r\n");
out.write(" <td>\r\n");
out.write(" ");
out.print(employeeRevRes.getString("EmployeeID"));
out.write("\r\n");
out.write(" </td>\r\n");
out.write(" <td>\r\n");
out.write(" ");
out.print(employeeRevRes.getString("Username"));
out.write("\r\n");
out.write(" </td>\r\n");
out.write(" <td>\r\n");
out.write(" ");
out.print(employeeRevRes.getDouble("Revenue"));
out.write("\r\n");
out.write(" </td>\r\n");
out.write(" </tr>\r\n");
out.write(" ");
}
out.write("\r\n");
out.write(" </tbody>\r\n");
out.write(" </table>\r\n");
out.write(" </body>\r\n");
out.write(" </html>\r\n");
out.write("\r\n");
out.write(" ");
} catch (Exception e) {
e.printStackTrace();
} finally {
try {
conn.close();
} catch (Exception ee) {
}
;
}
out.write('\r');
out.write('\n');
} catch (java.lang.Throwable t) {
if (!(t instanceof javax.servlet.jsp.SkipPageException)) {
out = _jspx_out;
if (out != null && out.getBufferSize() != 0)
try {
if (response.isCommitted()) {
out.flush();
} else {
out.clearBuffer();
}
} catch (java.io.IOException e) {
}
if (_jspx_page_context != null) _jspx_page_context.handlePageException(t);
else throw new ServletException(t);
}
} finally {
_jspxFactory.releasePageContext(_jspx_page_context);
}
}
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 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();
ServletContext context = session.getServletContext();
String path = context.getRealPath("/");
counter count = new counter(dbApplication);
SmartUpload mySmartUpload = new SmartUpload();
mySmartUpload.setCharset("UTF-8");
nseer_db_backup1 qcs_db = new nseer_db_backup1(dbApplication);
if (qcs_db.conn((String) dbSession.getAttribute("unit_db_name"))) {
mySmartUpload.initialize(pageContext);
String file_type = getFileLength.getFileType((String) session.getAttribute("unit_db_name"));
long d = getFileLength.getFileLength((String) session.getAttribute("unit_db_name"));
mySmartUpload.setMaxFileSize(d);
mySmartUpload.setAllowedFilesList(file_type);
try {
mySmartUpload.upload();
String qcs_id = mySmartUpload.getRequest().getParameter("qcs_id");
String config_id = mySmartUpload.getRequest().getParameter("config_id");
String[] item = mySmartUpload.getRequest().getParameterValues("item");
if (item != null) {
String[] file_name = new String[mySmartUpload.getFiles().getCount()];
String[] not_change = new String[mySmartUpload.getFiles().getCount()];
java.util.Date now = new java.util.Date();
SimpleDateFormat formatter = new SimpleDateFormat("yyyyMMdd");
String time = formatter.format(now);
String standard_id = mySmartUpload.getRequest().getParameter("standard_id");
String sqla =
"select attachment1 from qcs_intrmanufacture where qcs_id='"
+ qcs_id
+ "' and (check_tag='5' or check_tag='9')";
ResultSet rs = qcs_db.executeQuery(sqla);
if (!rs.next()) {
response.sendRedirect("draft/qcs/intrmanufacture_ok.jsp?finished_tag=1");
} else {
String[] attachment = mySmartUpload.getRequest().getParameterValues("attachment");
String[] delete_file_name = new String[0];
if (attachment != null) {
delete_file_name = new String[attachment.length];
for (int i = 0; i < attachment.length; i++) {
delete_file_name[i] = rs.getString(attachment[i]);
}
}
for (int i = 0; i < mySmartUpload.getFiles().getCount(); i++) {
com.jspsmart.upload.SmartFile file = mySmartUpload.getFiles().getFile(i);
if (file.isMissing()) {
file_name[i] = "";
int q = i + 1;
String field_name = "attachment" + q;
if (!rs.getString(field_name).equals("")) not_change[i] = "yes";
continue;
}
int filenum =
count.read(
(String) dbSession.getAttribute("unit_db_name"), "qcsAttachmentcount");
count.write(
(String) dbSession.getAttribute("unit_db_name"), "qcsAttachmentcount", filenum);
file_name[i] = filenum + file.getFileName();
file.saveAs(path + "qcs/file_attachments/" + filenum + file.getFileName());
}
String apply_id = mySmartUpload.getRequest().getParameter("apply_id");
String product_id = mySmartUpload.getRequest().getParameter("product_id");
String product_name = mySmartUpload.getRequest().getParameter("product_name");
String qcs_amount = mySmartUpload.getRequest().getParameter("qcs_amount");
String qcs_time = mySmartUpload.getRequest().getParameter("qcs_time");
String quality_way = mySmartUpload.getRequest().getParameter("quality_way");
String quality_solution = mySmartUpload.getRequest().getParameter("quality_solution");
String sampling_standard =
mySmartUpload.getRequest().getParameter("sampling_standard");
String sampling_amount = mySmartUpload.getRequest().getParameter("sampling_amount");
String accept = mySmartUpload.getRequest().getParameter("accept");
String reject = mySmartUpload.getRequest().getParameter("reject");
String qualified = mySmartUpload.getRequest().getParameter("qualified");
String unqualified = mySmartUpload.getRequest().getParameter("unqualified");
String qcs_result = mySmartUpload.getRequest().getParameter("qcs_result");
String checker = mySmartUpload.getRequest().getParameter("checker");
String checker_id = mySmartUpload.getRequest().getParameter("checker_id");
String check_time = mySmartUpload.getRequest().getParameter("check_time");
String changer = mySmartUpload.getRequest().getParameter("changer");
String changer_id = mySmartUpload.getRequest().getParameter("changer_id");
String change_time = mySmartUpload.getRequest().getParameter("change_time");
String bodyab =
new String(
mySmartUpload.getRequest().getParameter("remark").getBytes("UTF-8"), "UTF-8");
String remark = exchange.toHtml(bodyab);
sqla =
"update qcs_intrmanufacture set apply_id='"
+ apply_id
+ "',product_id='"
+ product_id
+ "',product_name='"
+ product_name
+ "',qcs_amount='"
+ qcs_amount
+ "',qcs_time='"
+ qcs_time
+ "',quality_way='"
+ quality_way
+ "',quality_solution='"
+ quality_solution
+ "',sampling_standard='"
+ sampling_standard
+ "',sampling_amount='"
+ sampling_amount
+ "',accept='"
+ accept
+ "',reject='"
+ reject
+ "',qualified='"
+ qualified
+ "',unqualified='"
+ unqualified
+ "',changer_id='"
+ changer_id
+ "',qcs_result='"
+ qcs_result
+ "',changer='"
+ changer
+ "',change_time='"
+ change_time
+ "',remark='"
+ remark
+ "',check_tag='5'";
String sqlb = " where qcs_id='" + qcs_id + "'";
if (attachment != null) {
for (int i = 0; i < attachment.length; i++) {
sqla = sqla + "," + attachment[i] + "=''";
java.io.File file =
new java.io.File(path + "qcs/file_attachments/" + delete_file_name[i]);
file.delete();
}
}
for (int i = 0; i < mySmartUpload.getFiles().getCount(); i++) {
if (not_change[i] != null && not_change[i].equals("yes")) continue;
int p = i + 1;
sqla = sqla + ",attachment" + p + "='" + file_name[i] + "'";
}
String sql = sqla + sqlb;
qcs_db.executeUpdate(sql);
sql = "delete from qcs_intrmanufacture_details where qcs_id='" + qcs_id + "'";
qcs_db.executeUpdate(sql);
String[] default_basis =
mySmartUpload.getRequest().getParameterValues("default_basis");
String[] ready_basis = mySmartUpload.getRequest().getParameterValues("ready_basis");
String[] quality_method =
mySmartUpload.getRequest().getParameterValues("quality_method");
String[] analyse_method =
mySmartUpload.getRequest().getParameterValues("analyse_method");
String[] standard_value =
mySmartUpload.getRequest().getParameterValues("standard_value");
String[] standard_max = mySmartUpload.getRequest().getParameterValues("standard_max");
String[] standard_min = mySmartUpload.getRequest().getParameterValues("standard_min");
String[] quality_value =
mySmartUpload.getRequest().getParameterValues("quality_value");
String[] sampling_amount_d =
mySmartUpload.getRequest().getParameterValues("sampling_amount_d");
String[] qualified_d = mySmartUpload.getRequest().getParameterValues("qualified_d");
String[] unqualified_d =
mySmartUpload.getRequest().getParameterValues("unqualified_d");
String[] quality_result =
mySmartUpload.getRequest().getParameterValues("quality_result");
String[] unqualified_reason =
mySmartUpload.getRequest().getParameterValues("unqualified_reason");
for (int i = 0; i < item.length; i++) {
if (!item[i].equals("")) {
sql =
"insert into qcs_intrmanufacture_details(qcs_id,item,default_basis,ready_basis,quality_method,analyse_method,standard_value,standard_max,standard_min,quality_value,sampling_amount_d,qualified_d,unqualified_d,quality_result,unqualified_reason,details_number) values('"
+ qcs_id
+ "','"
+ item[i]
+ "','"
+ default_basis[i]
+ "','"
+ ready_basis[i]
+ "','"
+ quality_method[i]
+ "','"
+ analyse_method[i]
+ "','"
+ standard_value[i]
+ "','"
+ standard_max[i]
+ "','"
+ standard_min[i]
+ "','"
+ quality_value[i]
+ "','"
+ sampling_amount_d[i]
+ "','"
+ qualified_d[i]
+ "','"
+ unqualified_d[i]
+ "','"
+ quality_result[i]
+ "','"
+ unqualified_reason[i]
+ "','"
+ i
+ "')";
qcs_db.executeUpdate(sql);
}
}
response.sendRedirect("draft/qcs/intrmanufacture_ok.jsp?finished_tag=0");
}
qcs_db.commit();
qcs_db.close();
} else {
response.sendRedirect("draft/qcs/intrmanufacture_ok.jsp?finished_tag=7");
}
} catch (Exception ex) {
response.sendRedirect("draft/qcs/intrmanufacture_ok.jsp?finished_tag=6");
}
} else {
response.sendRedirect("error_conn.htm");
}
} catch (Exception ex) {
ex.printStackTrace();
}
}
