private AttributesImpl createProcessBinding(AttributesImpl atts, X_AD_Process m_Process) {
String sql = null;
String name = null;
atts.clear();
if (m_Process.getAD_Process_ID() <= PackOut.MAX_OFFICIAL_ID)
atts.addAttribute(
"", "", "AD_Process_ID", "CDATA", Integer.toString(m_Process.getAD_Process_ID()));
atts.addAttribute(
"", "", "Name", "CDATA", (m_Process.getName() != null ? m_Process.getName() : ""));
if (m_Process.getAD_Workflow_ID() > 0) {
sql = "SELECT Name FROM AD_Workflow WHERE AD_Workflow_ID=?";
name = DB.getSQLValueString(null, sql, m_Process.getAD_Workflow_ID());
atts.addAttribute("", "", "ADWorkflowNameID", "CDATA", name);
} else atts.addAttribute("", "", "ADWorkflowNameID", "CDATA", "");
if (m_Process.getAD_Process_ID() > 0) {
sql = "SELECT Name FROM AD_Process WHERE AD_Process_ID=?";
name = DB.getSQLValueString(null, sql, m_Process.getAD_Process_ID());
atts.addAttribute("", "", "ADProcessNameID", "CDATA", name);
} else atts.addAttribute("", "", "ADProcessNameID", "CDATA", "");
if (m_Process.getAD_PrintFormat_ID() > 0) {
sql = "SELECT Name FROM AD_PrintFormat WHERE AD_PrintFormat_ID=?";
name = DB.getSQLValueString(null, sql, m_Process.getAD_PrintFormat_ID());
atts.addAttribute("", "", "ADPrintFormatNameID", "CDATA", name);
} else atts.addAttribute("", "", "ADPrintFormatNameID", "CDATA", "");
if (m_Process.getAD_ReportView_ID() > 0) {
sql = "SELECT Name FROM AD_ReportView WHERE AD_ReportView_ID=?";
name = DB.getSQLValueString(null, sql, m_Process.getAD_ReportView_ID());
atts.addAttribute("", "", "ADReportViewNameID", "CDATA", name);
} else atts.addAttribute("", "", "ADReportViewNameID", "CDATA", "");
if (m_Process.getAD_Form_ID() > 0) {
sql = "SELECT Name FROM AD_Form WHERE AD_Form_ID=?";
name = DB.getSQLValueString(null, sql, m_Process.getAD_Form_ID());
atts.addAttribute("", "", "ADFormNameID", "CDATA", name);
} else atts.addAttribute("", "", "ADFormNameID", "CDATA", "");
if (m_Process.getAD_Browse_ID() > 0) {
sql = "SELECT Name FROM AD_Browse WHERE AD_Browse_ID=?";
name = DB.getSQLValueString(null, sql, m_Process.getAD_Browse_ID());
atts.addAttribute("", "", "ADBrowseNameID", "CDATA", name);
} else atts.addAttribute("", "", "ADBrowseNameID", "CDATA", "");
atts.addAttribute(
"",
"",
"AccessLevel",
"CDATA",
(m_Process.getAccessLevel() != null ? m_Process.getAccessLevel() : ""));
atts.addAttribute(
"",
"",
"Classname",
"CDATA",
(m_Process.getClassname() != null ? m_Process.getClassname() : ""));
atts.addAttribute(
"",
"",
"Description",
"CDATA",
(m_Process.getDescription() != null ? m_Process.getDescription() : ""));
atts.addAttribute(
"",
"",
"EntityType",
"CDATA",
(m_Process.getEntityType() != null ? m_Process.getEntityType() : ""));
atts.addAttribute(
"", "", "Help", "CDATA", (m_Process.getHelp() != null ? m_Process.getHelp() : ""));
atts.addAttribute(
"",
"",
"isBetaFunctionality",
"CDATA",
(m_Process.isBetaFunctionality() == true ? "true" : "false"));
atts.addAttribute(
"", "", "isDirectPrint", "CDATA", (m_Process.isDirectPrint() == true ? "true" : "false"));
atts.addAttribute(
"", "", "isReport", "CDATA", (m_Process.isReport() == true ? "true" : "false"));
atts.addAttribute(
"", "", "isActive", "CDATA", (m_Process.isActive() == true ? "true" : "false"));
atts.addAttribute(
"",
"",
"ProcedureName",
"CDATA",
(m_Process.getProcedureName() != null ? m_Process.getProcedureName() : ""));
atts.addAttribute("", "", "StatisticCount", "CDATA", "0");
atts.addAttribute("", "", "StatisticSeconds", "CDATA", "0");
atts.addAttribute(
"", "", "Value", "CDATA", (m_Process.getValue() != null ? m_Process.getValue() : ""));
atts.addAttribute(
"",
"",
"WorkflowValue",
"CDATA",
(m_Process.getWorkflowValue() != null ? m_Process.getWorkflowValue() : ""));
atts.addAttribute(
"",
"",
"ShowHelp",
"CDATA",
(m_Process.getShowHelp() != null ? m_Process.getShowHelp() : ""));
atts.addAttribute(
"",
"",
"JasperReport",
"CDATA",
(m_Process.getJasperReport() != null ? m_Process.getJasperReport() : ""));
return atts;
}
public void create(Properties ctx, TransformerHandler document) throws SAXException {
int AD_Process_ID = Env.getContextAsInt(ctx, "AD_Process_ID");
if (processes.contains(AD_Process_ID)) return;
processes.add(AD_Process_ID);
PackOut packOut = (PackOut) ctx.get("PackOutProcess");
String sqlW = "SELECT AD_Process_ID FROM AD_PROCESS WHERE AD_PROCESS_ID = " + AD_Process_ID;
AttributesImpl atts = new AttributesImpl();
PreparedStatement pstmt1 = null;
pstmt1 = DB.prepareStatement(sqlW, getTrxName(ctx));
try {
ResultSet rs1 = pstmt1.executeQuery();
while (rs1.next()) {
X_AD_Process m_Process = new X_AD_Process(ctx, rs1.getInt("AD_Process_ID"), null);
log.log(Level.INFO, "AD_ReportView_ID: " + m_Process.getAD_Process_ID());
if (m_Process.isReport() && m_Process.getAD_ReportView_ID() > 0) {
packOut.createReportview(m_Process.getAD_ReportView_ID(), document);
}
if (m_Process.isReport() && m_Process.getAD_PrintFormat_ID() > 0) {
packOut.createPrintFormat(m_Process.getAD_PrintFormat_ID(), document);
}
if (m_Process.getAD_Workflow_ID() > 0) {
packOut.createWorkflow(m_Process.getAD_Workflow_ID(), document);
}
if (m_Process.getAD_Form_ID() > 0) {
packOut.createForm(m_Process.getAD_Form_ID(), document);
}
if (m_Process.getAD_Browse_ID() > 0) {
packOut.createBrowse(m_Process.getAD_Browse_ID(), document);
}
createProcessBinding(atts, m_Process);
document.startElement("", "", "process", atts);
// processpara tags
String sqlP =
"SELECT * FROM AD_PROCESS_PARA WHERE AD_PROCESS_ID = "
+ AD_Process_ID
+ " ORDER BY "
+ X_AD_Process_Para.COLUMNNAME_SeqNo
+ ","
+ X_AD_Process_Para.COLUMNNAME_AD_Process_Para_ID;
PreparedStatement pstmtP = null;
pstmtP = DB.prepareStatement(sqlP, getTrxName(ctx));
try {
ResultSet rsP = pstmtP.executeQuery();
while (rsP.next()) {
if (rsP.getInt("AD_Reference_ID") > 0)
packOut.createReference(rsP.getInt("AD_Reference_ID"), document);
if (rsP.getInt("AD_Reference_Value_ID") > 0)
packOut.createReference(rsP.getInt("AD_Reference_Value_ID"), document);
if (rsP.getInt("AD_Val_Rule_ID") > 0)
packOut.createDynamicRuleValidation(rsP.getInt("AD_Val_Rule_ID"), document);
createProcessPara(ctx, document, rsP.getInt("AD_Process_Para_ID"));
}
rsP.close();
pstmtP.close();
pstmtP = null;
} catch (Exception e) {
log.log(Level.SEVERE, "getProcess_Para", e);
if (e instanceof SAXException) throw (SAXException) e;
else if (e instanceof SQLException)
throw new DatabaseAccessException("Failed to export process.", e);
else if (e instanceof RuntimeException) throw (RuntimeException) e;
else throw new RuntimeException("Failed to export process.", e);
} finally {
try {
if (pstmtP != null) pstmtP.close();
} catch (Exception e) {
}
pstmtP = null;
}
document.endElement("", "", "process");
}
rs1.close();
pstmt1.close();
pstmt1 = null;
} catch (Exception e) {
log.log(Level.SEVERE, "getProcess", e);
} finally {
try {
if (pstmt1 != null) pstmt1.close();
} catch (Exception e) {
}
pstmt1 = null;
}
}
