private void printPageButtonFS( HttpServletResponse response, VariablesSecureApp vars, String strProcessId, String path) throws IOException, ServletException { log4j.debug("Output: Frames action button"); response.setContentType("text/html; charset=UTF-8"); PrintWriter out = response.getWriter(); XmlDocument xmlDocument = xmlEngine .readXmlTemplate("org/openbravo/erpCommon/ad_actionButton/ActionButtonDefaultFrames") .createXmlDocument(); xmlDocument.setParameter("processId", strProcessId); xmlDocument.setParameter("trlFormType", "PROCESS"); xmlDocument.setParameter("language", "defaultLang = \"" + vars.getLanguage() + "\";\n"); xmlDocument.setParameter("type", strDireccion + path); out.println(xmlDocument.print()); out.close(); }
private void printPageEdit( HttpServletResponse response, HttpServletRequest request, VariablesSecureApp vars, boolean boolNew, String strC_BP_Group_ID, TableSQLData tableSQL) throws IOException, ServletException { if (log4j.isDebugEnabled()) log4j.debug("Output: edit"); HashMap<String, String> usedButtonShortCuts; usedButtonShortCuts = new HashMap<String, String>(); String strOrderByFilter = vars.getSessionValue(tabId + "|orderby"); String orderClause = " C_BP_Group.Value"; if (strOrderByFilter == null || strOrderByFilter.equals("")) strOrderByFilter = orderClause; /*{ if (!strOrderByFilter.equals("") && !orderClause.equals("")) strOrderByFilter += ", "; strOrderByFilter += orderClause; }*/ String strCommand = null; BusinessPartnerCategoryData[] data = null; XmlDocument xmlDocument = null; FieldProvider dataField = vars.getEditionData(tabId); vars.removeEditionData(tabId); String strParamName = vars.getSessionValue(tabId + "|paramName"); boolean hasSearchCondition = false; hasSearchCondition = (tableSQL.hasInternalFilter() && ("").equals(strParamName)) || !(("").equals(strParamName) || ("%").equals(strParamName)); String strParamSessionDate = vars.getGlobalVariable( "inpParamSessionDate", Utility.getTransactionalDate(this, vars, windowId), ""); String buscador = ""; String[] discard = {"", "isNotTest"}; if (vars.getSessionValue("#ShowTest", "N").equals("Y")) discard[1] = new String("isTest"); if (dataField == null) { if (!boolNew) { discard[0] = new String("newDiscard"); data = BusinessPartnerCategoryData.selectEdit( this, vars.getSessionValue("#AD_SqlDateTimeFormat"), vars.getLanguage(), strC_BP_Group_ID, Utility.getContext(this, vars, "#User_Client", windowId), Utility.getContext(this, vars, "#AccessibleOrgTree", windowId, accesslevel)); if (!strC_BP_Group_ID.equals("") && (data == null || data.length == 0)) { response.sendRedirect(strDireccion + request.getServletPath() + "?Command=RELATION"); return; } refreshSessionEdit(vars, data); strCommand = "EDIT"; } if (boolNew || data == null || data.length == 0) { discard[0] = new String("editDiscard"); strCommand = "NEW"; data = new BusinessPartnerCategoryData[0]; } else { discard[0] = new String("newDiscard"); } } else { if (dataField.getField("cBpGroupId") == null || dataField.getField("cBpGroupId").equals("")) { discard[0] = new String("editDiscard"); strCommand = "NEW"; boolNew = true; } else { discard[0] = new String("newDiscard"); strCommand = "EDIT"; } } if (dataField == null) { if (boolNew || data == null || data.length == 0) { refreshSessionNew(vars); data = BusinessPartnerCategoryData.set( "", Utility.getDefault( this, vars, "AD_Client_ID", "@AD_CLIENT_ID@", "192", "", dataField), Utility.getDefault(this, vars, "AD_Org_ID", "@AD_Org_ID@", "192", "", dataField), "Y", Utility.getDefault(this, vars, "CreatedBy", "", "192", "", dataField), BusinessPartnerCategoryData.selectDef4966_0( this, Utility.getDefault(this, vars, "CreatedBy", "", "192", "", dataField)), Utility.getDefault(this, vars, "UpdatedBy", "", "192", "", dataField), BusinessPartnerCategoryData.selectDef4968_1( this, Utility.getDefault(this, vars, "UpdatedBy", "", "192", "", dataField)), Utility.getDefault(this, vars, "Value", "", "192", "", dataField), Utility.getDefault(this, vars, "Name", "", "192", "", dataField), Utility.getDefault(this, vars, "Description", "", "192", "", dataField), Utility.getDefault(this, vars, "IsDefault", "", "192", "N", dataField)); } } String currentOrg = (boolNew ? "" : (dataField != null ? dataField.getField("adOrgId") : data[0].getField("adOrgId"))); if (!currentOrg.equals("") && !currentOrg.startsWith("'")) currentOrg = "'" + currentOrg + "'"; String currentClient = (boolNew ? "" : (dataField != null ? dataField.getField("adClientId") : data[0].getField("adClientId"))); if (!currentClient.equals("") && !currentClient.startsWith("'")) currentClient = "'" + currentClient + "'"; boolean hasReadOnlyAccess = org.openbravo.erpCommon.utility.WindowAccessData.hasReadOnlyAccess( this, vars.getRole(), tabId); boolean editableTab = (!hasReadOnlyAccess && (currentOrg.equals("") || Utility.isElementInList( Utility.getContext(this, vars, "#User_Org", windowId, accesslevel), currentOrg)) && (currentClient.equals("") || Utility.isElementInList( Utility.getContext(this, vars, "#User_Client", windowId, accesslevel), currentClient))); if (editableTab) xmlDocument = xmlEngine .readXmlTemplate( "org/openbravo/erpWindows/BusinessPartnerCategory/BusinessPartnerCategory_Edition", discard) .createXmlDocument(); else xmlDocument = xmlEngine .readXmlTemplate( "org/openbravo/erpWindows/BusinessPartnerCategory/BusinessPartnerCategory_NonEditable", discard) .createXmlDocument(); xmlDocument.setParameter("tabId", tabId); ToolBar toolbar = new ToolBar( this, editableTab, vars.getLanguage(), "BusinessPartnerCategory", (strCommand.equals("NEW") || boolNew || (dataField == null && (data == null || data.length == 0))), "document.frmMain.inpcBpGroupId", "", "..", "".equals("Y"), "BusinessPartnerCategory", strReplaceWith, true, false, false, Utility.hasTabAttachments(this, vars, tabId, strC_BP_Group_ID), !hasReadOnlyAccess); toolbar.setTabId(tabId); toolbar.setDeleteable(true); toolbar.prepareEditionTemplate( "N".equals("Y"), hasSearchCondition, vars.getSessionValue("#ShowTest", "N").equals("Y"), "STD", Utility.getContext(this, vars, "ShowAudit", windowId).equals("Y")); xmlDocument.setParameter("toolbar", toolbar.toString()); // set updated timestamp to manage locking mechanism if (!boolNew) { xmlDocument.setParameter( "updatedTimestamp", (dataField != null ? dataField.getField("updatedTimeStamp") : data[0].getField("updatedTimeStamp"))); } boolean concurrentSave = vars.getSessionValue(tabId + "|concurrentSave").equals("true"); if (concurrentSave) { // after concurrent save error, force autosave xmlDocument.setParameter("autosave", "Y"); } else { xmlDocument.setParameter("autosave", "N"); } vars.removeSessionValue(tabId + "|concurrentSave"); try { WindowTabs tabs = new WindowTabs(this, vars, tabId, windowId, true, (strCommand.equalsIgnoreCase("NEW"))); xmlDocument.setParameter("parentTabContainer", tabs.parentTabs()); xmlDocument.setParameter("mainTabContainer", tabs.mainTabs()); // if (!strC_BP_Group_ID.equals("")) xmlDocument.setParameter("childTabContainer", // tabs.childTabs(false)); // else xmlDocument.setParameter("childTabContainer", tabs.childTabs(true)); xmlDocument.setParameter("childTabContainer", tabs.childTabs(false)); String hideBackButton = vars.getGlobalVariable("hideMenu", "#Hide_BackButton", ""); NavigationBar nav = new NavigationBar( this, vars.getLanguage(), "BusinessPartnerCategory_Relation.html", "BusinessPartnerCategory", "W", strReplaceWith, tabs.breadcrumb(), hideBackButton.equals("true"), !concurrentSave); xmlDocument.setParameter("navigationBar", nav.toString()); LeftTabsBar lBar = new LeftTabsBar( this, vars.getLanguage(), "BusinessPartnerCategory_Relation.html", strReplaceWith); xmlDocument.setParameter("leftTabs", lBar.editionTemplate(strCommand.equals("NEW"))); } catch (Exception ex) { throw new ServletException(ex); } xmlDocument.setParameter("commandType", strCommand); xmlDocument.setParameter("buscador", buscador); xmlDocument.setParameter("windowId", windowId); xmlDocument.setParameter("changed", ""); xmlDocument.setParameter("language", "defaultLang=\"" + vars.getLanguage() + "\";"); xmlDocument.setParameter("theme", vars.getTheme()); final String strMappingName = Utility.getTabURL(tabId, "E", false); xmlDocument.setParameter("mappingName", strMappingName); xmlDocument.setParameter("confirmOnChanges", Utility.getJSConfirmOnChanges(vars, windowId)); // xmlDocument.setParameter("buttonReference", Utility.messageBD(this, "Reference", // vars.getLanguage())); xmlDocument.setParameter("paramSessionDate", strParamSessionDate); xmlDocument.setParameter("directory", "var baseDirectory = \"" + strReplaceWith + "/\";\n"); OBError myMessage = vars.getMessage(tabId); vars.removeMessage(tabId); if (myMessage != null) { xmlDocument.setParameter("messageType", myMessage.getType()); xmlDocument.setParameter("messageTitle", myMessage.getTitle()); xmlDocument.setParameter("messageMessage", myMessage.getMessage()); } xmlDocument.setParameter("displayLogic", getDisplayLogicContext(vars, boolNew)); if (dataField == null) { xmlDocument.setData("structure1", data); } else { FieldProvider[] dataAux = new FieldProvider[1]; dataAux[0] = dataField; xmlDocument.setData("structure1", dataAux); } try { ComboTableData comboTableData = null; String userOrgList = ""; if (editableTab) userOrgList = Utility.getContext(this, vars, "#User_Org", windowId, accesslevel); // editable record else userOrgList = currentOrg; comboTableData = new ComboTableData( vars, this, "19", "AD_Org_ID", "", "", userOrgList, Utility.getContext(this, vars, "#User_Client", windowId), 0); Utility.fillSQLParameters( this, vars, (dataField == null ? data[0] : dataField), comboTableData, windowId, (dataField == null ? data[0].getField("adOrgId") : dataField.getField("adOrgId"))); xmlDocument.setData( "reportAD_Org_ID", "liststructure", comboTableData.select(!strCommand.equals("NEW"))); comboTableData = null; xmlDocument.setParameter("Created_Format", vars.getSessionValue("#AD_SqlDateTimeFormat")); xmlDocument.setParameter( "Created_Maxlength", Integer.toString(vars.getSessionValue("#AD_SqlDateTimeFormat").length())); xmlDocument.setParameter("Updated_Format", vars.getSessionValue("#AD_SqlDateTimeFormat")); xmlDocument.setParameter( "Updated_Maxlength", Integer.toString(vars.getSessionValue("#AD_SqlDateTimeFormat").length())); } catch (Exception ex) { ex.printStackTrace(); throw new ServletException(ex); } xmlDocument.setParameter("scriptOnLoad", getShortcutScript(usedButtonShortCuts)); final String refererURL = vars.getSessionValue(tabId + "|requestURL"); vars.removeSessionValue(tabId + "|requestURL"); if (!refererURL.equals("")) { final Boolean failedAutosave = (Boolean) vars.getSessionObject(tabId + "|failedAutosave"); vars.removeSessionValue(tabId + "|failedAutosave"); if (failedAutosave != null && failedAutosave) { final String jsFunction = "continueUserAction('" + refererURL + "');"; xmlDocument.setParameter("failedAutosave", jsFunction); } } if (strCommand.equalsIgnoreCase("NEW")) { vars.removeSessionValue(tabId + "|failedAutosave"); vars.removeSessionValue(strMappingName + "|hash"); } response.setContentType("text/html; charset=UTF-8"); PrintWriter out = response.getWriter(); out.println(xmlDocument.print()); out.close(); }
private void printPageDataSheet( HttpServletResponse response, VariablesSecureApp vars, String strC_BP_Group_ID, TableSQLData tableSQL) throws IOException, ServletException { if (log4j.isDebugEnabled()) log4j.debug("Output: dataSheet"); String strParamName = vars.getSessionValue(tabId + "|paramName"); boolean hasSearchCondition = false; vars.removeEditionData(tabId); hasSearchCondition = (tableSQL.hasInternalFilter() && ("").equals(strParamName)) || !(("").equals(strParamName) || ("%").equals(strParamName)); String strOffset = vars.getSessionValue(tabId + "|offset"); String selectedRow = "0"; if (!strC_BP_Group_ID.equals("")) { selectedRow = Integer.toString(getKeyPosition(vars, strC_BP_Group_ID, tableSQL)); } String[] discard = {"isNotFiltered", "isNotTest"}; if (hasSearchCondition) discard[0] = new String("isFiltered"); if (vars.getSessionValue("#ShowTest", "N").equals("Y")) discard[1] = new String("isTest"); XmlDocument xmlDocument = xmlEngine .readXmlTemplate( "org/openbravo/erpWindows/BusinessPartnerCategory/BusinessPartnerCategory_Relation", discard) .createXmlDocument(); boolean hasReadOnlyAccess = org.openbravo.erpCommon.utility.WindowAccessData.hasReadOnlyAccess( this, vars.getRole(), tabId); ToolBar toolbar = new ToolBar( this, true, vars.getLanguage(), "BusinessPartnerCategory", false, "document.frmMain.inpcBpGroupId", "grid", "..", "".equals("Y"), "BusinessPartnerCategory", strReplaceWith, false, false, false, false, !hasReadOnlyAccess); toolbar.setTabId(tabId); toolbar.setDeleteable(true && !hasReadOnlyAccess); toolbar.prepareRelationTemplate( "N".equals("Y"), hasSearchCondition, !vars.getSessionValue("#ShowTest", "N").equals("Y"), false, Utility.getContext(this, vars, "ShowAudit", windowId).equals("Y")); xmlDocument.setParameter("toolbar", toolbar.toString()); StringBuffer orderByArray = new StringBuffer(); vars.setSessionValue(tabId + "|newOrder", "1"); String positions = vars.getSessionValue(tabId + "|orderbyPositions"); orderByArray.append("var orderByPositions = new Array(\n"); if (!positions.equals("")) { StringTokenizer tokens = new StringTokenizer(positions, ","); boolean firstOrder = true; while (tokens.hasMoreTokens()) { if (!firstOrder) orderByArray.append(",\n"); orderByArray.append("\"").append(tokens.nextToken()).append("\""); firstOrder = false; } } orderByArray.append(");\n"); String directions = vars.getSessionValue(tabId + "|orderbyDirections"); orderByArray.append("var orderByDirections = new Array(\n"); if (!positions.equals("")) { StringTokenizer tokens = new StringTokenizer(directions, ","); boolean firstOrder = true; while (tokens.hasMoreTokens()) { if (!firstOrder) orderByArray.append(",\n"); orderByArray.append("\"").append(tokens.nextToken()).append("\""); firstOrder = false; } } orderByArray.append(");\n"); // } xmlDocument.setParameter( "selectedColumn", "\nvar selectedRow = " + selectedRow + ";\n" + orderByArray.toString()); xmlDocument.setParameter("directory", "var baseDirectory = \"" + strReplaceWith + "/\";\n"); xmlDocument.setParameter("windowId", windowId); xmlDocument.setParameter("KeyName", "cBpGroupId"); xmlDocument.setParameter("language", "defaultLang=\"" + vars.getLanguage() + "\";"); xmlDocument.setParameter("theme", vars.getTheme()); // xmlDocument.setParameter("buttonReference", Utility.messageBD(this, "Reference", // vars.getLanguage())); try { WindowTabs tabs = new WindowTabs(this, vars, tabId, windowId, false); xmlDocument.setParameter("parentTabContainer", tabs.parentTabs()); xmlDocument.setParameter("mainTabContainer", tabs.mainTabs()); xmlDocument.setParameter("childTabContainer", tabs.childTabs()); String hideBackButton = vars.getGlobalVariable("hideMenu", "#Hide_BackButton", ""); NavigationBar nav = new NavigationBar( this, vars.getLanguage(), "BusinessPartnerCategory_Relation.html", "BusinessPartnerCategory", "W", strReplaceWith, tabs.breadcrumb(), hideBackButton.equals("true")); xmlDocument.setParameter("navigationBar", nav.toString()); LeftTabsBar lBar = new LeftTabsBar( this, vars.getLanguage(), "BusinessPartnerCategory_Relation.html", strReplaceWith); xmlDocument.setParameter("leftTabs", lBar.relationTemplate()); } catch (Exception ex) { throw new ServletException(ex); } { OBError myMessage = vars.getMessage(tabId); vars.removeMessage(tabId); if (myMessage != null) { xmlDocument.setParameter("messageType", myMessage.getType()); xmlDocument.setParameter("messageTitle", myMessage.getTitle()); xmlDocument.setParameter("messageMessage", myMessage.getMessage()); } } xmlDocument.setParameter("grid", Utility.getContext(this, vars, "#RecordRange", windowId)); xmlDocument.setParameter("grid_Offset", strOffset); xmlDocument.setParameter("grid_SortCols", positions); xmlDocument.setParameter("grid_SortDirs", directions); xmlDocument.setParameter("grid_Default", selectedRow); response.setContentType("text/html; charset=UTF-8"); PrintWriter out = response.getWriter(); out.println(xmlDocument.print()); out.close(); }
public void doPost(HttpServletRequest request, HttpServletResponse response) throws IOException, ServletException { TableSQLData tableSQL = null; VariablesSecureApp vars = new VariablesSecureApp(request); Boolean saveRequest = (Boolean) request.getAttribute("autosave"); if (saveRequest != null && saveRequest) { String currentOrg = vars.getStringParameter("inpadOrgId"); String currentClient = vars.getStringParameter("inpadClientId"); boolean editableTab = (!org.openbravo.erpCommon.utility.WindowAccessData.hasReadOnlyAccess( this, vars.getRole(), tabId) && (currentOrg.equals("") || Utility.isElementInList( Utility.getContext(this, vars, "#User_Org", windowId, accesslevel), currentOrg)) && (currentClient.equals("") || Utility.isElementInList( Utility.getContext(this, vars, "#User_Client", windowId, accesslevel), currentClient))); OBError myError = new OBError(); String commandType = request.getParameter("inpCommandType"); String strcBpGroupId = request.getParameter("inpcBpGroupId"); if (editableTab) { int total = 0; if (commandType.equalsIgnoreCase("EDIT") && !strcBpGroupId.equals("")) total = saveRecord(vars, myError, 'U'); else total = saveRecord(vars, myError, 'I'); if (!myError.isEmpty() && total == 0) throw new OBException(myError.getMessage()); } vars.setSessionValue(request.getParameter("mappingName") + "|hash", vars.getPostDataHash()); vars.setSessionValue(tabId + "|Header.view", "EDIT"); return; } try { tableSQL = new TableSQLData( vars, this, tabId, Utility.getContext(this, vars, "#AccessibleOrgTree", windowId, accesslevel), Utility.getContext(this, vars, "#User_Client", windowId), Utility.getContext(this, vars, "ShowAudit", windowId).equals("Y")); } catch (Exception ex) { ex.printStackTrace(); } String strOrderBy = vars.getSessionValue(tabId + "|orderby"); if (!strOrderBy.equals("")) { vars.setSessionValue(tabId + "|newOrder", "1"); } if (vars.commandIn("DEFAULT")) { String strC_BP_Group_ID = vars.getGlobalVariable("inpcBpGroupId", windowId + "|C_BP_Group_ID", ""); String strView = vars.getSessionValue(tabId + "|BusinessPartnerCategory.view"); if (strView.equals("")) { strView = defaultTabView; if (strView.equals("EDIT")) { if (strC_BP_Group_ID.equals("")) strC_BP_Group_ID = firstElement(vars, tableSQL); if (strC_BP_Group_ID.equals("")) strView = "RELATION"; } } if (strView.equals("EDIT")) printPageEdit(response, request, vars, false, strC_BP_Group_ID, tableSQL); else printPageDataSheet(response, vars, strC_BP_Group_ID, tableSQL); } else if (vars.commandIn("DIRECT")) { String strC_BP_Group_ID = vars.getStringParameter("inpDirectKey"); if (strC_BP_Group_ID.equals("")) strC_BP_Group_ID = vars.getRequiredGlobalVariable("inpcBpGroupId", windowId + "|C_BP_Group_ID"); else vars.setSessionValue(windowId + "|C_BP_Group_ID", strC_BP_Group_ID); vars.setSessionValue(tabId + "|BusinessPartnerCategory.view", "EDIT"); printPageEdit(response, request, vars, false, strC_BP_Group_ID, tableSQL); } else if (vars.commandIn("TAB")) { String strView = vars.getSessionValue(tabId + "|BusinessPartnerCategory.view"); String strC_BP_Group_ID = ""; if (strView.equals("")) { strView = defaultTabView; if (strView.equals("EDIT")) { strC_BP_Group_ID = firstElement(vars, tableSQL); if (strC_BP_Group_ID.equals("")) strView = "RELATION"; } } if (strView.equals("EDIT")) { if (strC_BP_Group_ID.equals("")) strC_BP_Group_ID = firstElement(vars, tableSQL); printPageEdit(response, request, vars, false, strC_BP_Group_ID, tableSQL); } else printPageDataSheet(response, vars, "", tableSQL); } else if (vars.commandIn("SEARCH")) { vars.getRequestGlobalVariable("inpParamName", tabId + "|paramName"); vars.getRequestGlobalVariable("inpParamUpdated", tabId + "|paramUpdated"); vars.getRequestGlobalVariable("inpParamUpdatedBy", tabId + "|paramUpdatedBy"); vars.getRequestGlobalVariable("inpParamCreated", tabId + "|paramCreated"); vars.getRequestGlobalVariable("inpparamCreatedBy", tabId + "|paramCreatedBy"); vars.removeSessionValue(windowId + "|C_BP_Group_ID"); String strC_BP_Group_ID = ""; String strView = vars.getSessionValue(tabId + "|BusinessPartnerCategory.view"); if (strView.equals("")) strView = defaultTabView; if (strView.equals("EDIT")) { strC_BP_Group_ID = firstElement(vars, tableSQL); if (strC_BP_Group_ID.equals("")) { // filter returns empty set strView = "RELATION"; // switch to grid permanently until the user changes the view again vars.setSessionValue(tabId + "|BusinessPartnerCategory.view", strView); } } if (strView.equals("EDIT")) printPageEdit(response, request, vars, false, strC_BP_Group_ID, tableSQL); else printPageDataSheet(response, vars, strC_BP_Group_ID, tableSQL); } else if (vars.commandIn("RELATION")) { String strC_BP_Group_ID = vars.getGlobalVariable("inpcBpGroupId", windowId + "|C_BP_Group_ID", ""); vars.setSessionValue(tabId + "|BusinessPartnerCategory.view", "RELATION"); printPageDataSheet(response, vars, strC_BP_Group_ID, tableSQL); } else if (vars.commandIn("NEW")) { printPageEdit(response, request, vars, true, "", tableSQL); } else if (vars.commandIn("EDIT")) { @SuppressWarnings("unused") // In Expense Invoice tab this variable is not used, to be fixed String strC_BP_Group_ID = vars.getGlobalVariable("inpcBpGroupId", windowId + "|C_BP_Group_ID", ""); vars.setSessionValue(tabId + "|BusinessPartnerCategory.view", "EDIT"); setHistoryCommand(request, "EDIT"); printPageEdit(response, request, vars, false, strC_BP_Group_ID, tableSQL); } else if (vars.commandIn("NEXT")) { String strC_BP_Group_ID = vars.getRequiredStringParameter("inpcBpGroupId"); String strNext = nextElement(vars, strC_BP_Group_ID, tableSQL); printPageEdit(response, request, vars, false, strNext, tableSQL); } else if (vars.commandIn("PREVIOUS")) { String strC_BP_Group_ID = vars.getRequiredStringParameter("inpcBpGroupId"); String strPrevious = previousElement(vars, strC_BP_Group_ID, tableSQL); printPageEdit(response, request, vars, false, strPrevious, tableSQL); } else if (vars.commandIn("FIRST_RELATION")) { vars.setSessionValue(tabId + "|BusinessPartnerCategory.initRecordNumber", "0"); response.sendRedirect(strDireccion + request.getServletPath() + "?Command=RELATION"); } else if (vars.commandIn("PREVIOUS_RELATION")) { String strInitRecord = vars.getSessionValue(tabId + "|BusinessPartnerCategory.initRecordNumber"); String strRecordRange = Utility.getContext(this, vars, "#RecordRange", windowId); int intRecordRange = strRecordRange.equals("") ? 0 : Integer.parseInt(strRecordRange); if (strInitRecord.equals("") || strInitRecord.equals("0")) { vars.setSessionValue(tabId + "|BusinessPartnerCategory.initRecordNumber", "0"); } else { int initRecord = (strInitRecord.equals("") ? 0 : Integer.parseInt(strInitRecord)); initRecord -= intRecordRange; strInitRecord = ((initRecord < 0) ? "0" : Integer.toString(initRecord)); vars.setSessionValue(tabId + "|BusinessPartnerCategory.initRecordNumber", strInitRecord); } vars.removeSessionValue(windowId + "|C_BP_Group_ID"); response.sendRedirect(strDireccion + request.getServletPath() + "?Command=RELATION"); } else if (vars.commandIn("NEXT_RELATION")) { String strInitRecord = vars.getSessionValue(tabId + "|BusinessPartnerCategory.initRecordNumber"); String strRecordRange = Utility.getContext(this, vars, "#RecordRange", windowId); int intRecordRange = strRecordRange.equals("") ? 0 : Integer.parseInt(strRecordRange); int initRecord = (strInitRecord.equals("") ? 0 : Integer.parseInt(strInitRecord)); if (initRecord == 0) initRecord = 1; initRecord += intRecordRange; strInitRecord = ((initRecord < 0) ? "0" : Integer.toString(initRecord)); vars.setSessionValue(tabId + "|BusinessPartnerCategory.initRecordNumber", strInitRecord); vars.removeSessionValue(windowId + "|C_BP_Group_ID"); response.sendRedirect(strDireccion + request.getServletPath() + "?Command=RELATION"); } else if (vars.commandIn("FIRST")) { String strFirst = firstElement(vars, tableSQL); printPageEdit(response, request, vars, false, strFirst, tableSQL); } else if (vars.commandIn("LAST_RELATION")) { String strLast = lastElement(vars, tableSQL); printPageDataSheet(response, vars, strLast, tableSQL); } else if (vars.commandIn("LAST")) { String strLast = lastElement(vars, tableSQL); printPageEdit(response, request, vars, false, strLast, tableSQL); } else if (vars.commandIn("SAVE_NEW_RELATION", "SAVE_NEW_NEW", "SAVE_NEW_EDIT")) { OBError myError = new OBError(); int total = saveRecord(vars, myError, 'I'); if (!myError.isEmpty()) { response.sendRedirect(strDireccion + request.getServletPath() + "?Command=NEW"); } else { if (myError.isEmpty()) { myError = Utility.translateError(this, vars, vars.getLanguage(), "@CODE=RowsInserted"); myError.setMessage(total + " " + myError.getMessage()); vars.setMessage(tabId, myError); } if (vars.commandIn("SAVE_NEW_NEW")) response.sendRedirect(strDireccion + request.getServletPath() + "?Command=NEW"); else if (vars.commandIn("SAVE_NEW_EDIT")) response.sendRedirect(strDireccion + request.getServletPath() + "?Command=EDIT"); else response.sendRedirect(strDireccion + request.getServletPath() + "?Command=RELATION"); } } else if (vars.commandIn( "SAVE_EDIT_RELATION", "SAVE_EDIT_NEW", "SAVE_EDIT_EDIT", "SAVE_EDIT_NEXT")) { String strC_BP_Group_ID = vars.getRequiredGlobalVariable("inpcBpGroupId", windowId + "|C_BP_Group_ID"); OBError myError = new OBError(); int total = saveRecord(vars, myError, 'U'); if (!myError.isEmpty()) { response.sendRedirect(strDireccion + request.getServletPath() + "?Command=EDIT"); } else { if (myError.isEmpty()) { myError = Utility.translateError(this, vars, vars.getLanguage(), "@CODE=RowsUpdated"); myError.setMessage(total + " " + myError.getMessage()); vars.setMessage(tabId, myError); } if (vars.commandIn("SAVE_EDIT_NEW")) response.sendRedirect(strDireccion + request.getServletPath() + "?Command=NEW"); else if (vars.commandIn("SAVE_EDIT_EDIT")) response.sendRedirect(strDireccion + request.getServletPath() + "?Command=EDIT"); else if (vars.commandIn("SAVE_EDIT_NEXT")) { String strNext = nextElement(vars, strC_BP_Group_ID, tableSQL); vars.setSessionValue(windowId + "|C_BP_Group_ID", strNext); response.sendRedirect(strDireccion + request.getServletPath() + "?Command=EDIT"); } else response.sendRedirect(strDireccion + request.getServletPath() + "?Command=RELATION"); } } else if (vars.commandIn("DELETE")) { String strC_BP_Group_ID = vars.getRequiredStringParameter("inpcBpGroupId"); // BusinessPartnerCategoryData data = getEditVariables(vars); int total = 0; OBError myError = null; if (org.openbravo.erpCommon.utility.WindowAccessData.hasNotDeleteAccess( this, vars.getRole(), tabId)) { myError = Utility.translateError( this, vars, vars.getLanguage(), Utility.messageBD(this, "NoWriteAccess", vars.getLanguage())); vars.setMessage(tabId, myError); } else { try { total = BusinessPartnerCategoryData.delete( this, strC_BP_Group_ID, Utility.getContext(this, vars, "#User_Client", windowId, accesslevel), Utility.getContext(this, vars, "#User_Org", windowId, accesslevel)); } catch (ServletException ex) { myError = Utility.translateError(this, vars, vars.getLanguage(), ex.getMessage()); if (!myError.isConnectionAvailable()) { bdErrorConnection(response); return; } else vars.setMessage(tabId, myError); } if (myError == null && total == 0) { myError = Utility.translateError( this, vars, vars.getLanguage(), Utility.messageBD(this, "NoWriteAccess", vars.getLanguage())); vars.setMessage(tabId, myError); } vars.removeSessionValue(windowId + "|cBpGroupId"); vars.setSessionValue(tabId + "|BusinessPartnerCategory.view", "RELATION"); } if (myError == null) { myError = Utility.translateError(this, vars, vars.getLanguage(), "@CODE=RowsDeleted"); myError.setMessage(total + " " + myError.getMessage()); vars.setMessage(tabId, myError); } response.sendRedirect(strDireccion + request.getServletPath()); } else if (vars.commandIn("SAVE_XHR")) { OBError myError = new OBError(); JSONObject result = new JSONObject(); String commandType = vars.getStringParameter("inpCommandType"); char saveType = "NEW".equals(commandType) ? 'I' : 'U'; try { int total = saveRecord(vars, myError, saveType); if (myError.isEmpty()) { myError = Utility.translateError(this, vars, vars.getLanguage(), "@CODE=RowsUpdated"); myError.setMessage(total + " " + myError.getMessage()); myError.setType("Success"); } result.put("oberror", myError.toMap()); result.put("tabid", vars.getStringParameter("tabID")); result.put("redirect", strDireccion + request.getServletPath() + "?Command=" + commandType); } catch (Exception e) { log4j.error("Error saving record (XHR request): " + e.getMessage(), e); myError.setType("Error"); myError.setMessage(e.getMessage()); } response.setContentType("application/json"); PrintWriter out = response.getWriter(); out.print(result.toString()); out.flush(); out.close(); } else if (vars.getCommand().toUpperCase().startsWith("BUTTON") || vars.getCommand().toUpperCase().startsWith("SAVE_BUTTON")) { pageErrorPopUp(response); } else pageError(response); }