/** Descripción de Método */ private void cmd_report() { KeyNamePair pp = (KeyNamePair) comboReport.getSelectedItem(); if (pp == null) { return; } // setCursor(Cursor.getPredefinedCursor(Cursor.WAIT_CURSOR)); MPrintFormat pf = null; int AD_PrintFormat_ID = pp.getKey(); // create new if (AD_PrintFormat_ID == -1) { int AD_ReportView_ID = m_reportEngine.getPrintFormat().getAD_ReportView_ID(); if (AD_ReportView_ID != 0) { String name = m_reportEngine.getName(); int index = name.lastIndexOf("_"); if (index != -1) { name = name.substring(0, index); } pf = MPrintFormat.createFromReportView(m_ctx, AD_ReportView_ID, name); } else { int AD_Table_ID = m_reportEngine.getPrintFormat().getAD_Table_ID(); pf = MPrintFormat.createFromTable(m_ctx, AD_Table_ID); } if (pf != null) { fillComboReport(pf.getID()); } else { return; } } else { pf = MPrintFormat.get(Env.getCtx(), AD_PrintFormat_ID, true); } m_reportEngine.setPrintFormat(pf); revalidate(); cmd_drill(); // setCursor } // cmd_report
/** * Descripción de Método * * @param args */ public static void main(String[] args) { Login.initTest(true); MQuery q = new MQuery("C_Invoice"); q.addRestriction("C_Invoice_ID", MQuery.EQUAL, new Integer(103)); // 102 = Invoice - 100 = Order PrintInfo i = new PrintInfo("test", X_C_Invoice.Table_ID, 102, 0); MPrintFormat f = MPrintFormat.get(Env.getCtx(), 102, false); ReportEngine re = new ReportEngine(Env.getCtx(), f, q, i); // MPrintFormat f = new MPrintFormat(Env.getCtx(), 101); // ReportEngine re = new ReportEngine(f, null); new Viewer(re); } // main
/** * Descripción de Método * * @param e */ public void windowStateChanged(WindowEvent e) { // The Customize Window was closed if ((e.getID() == WindowEvent.WINDOW_CLOSED) && (m_reportEngine != null)) { setCursor(Cursor.getPredefinedCursor(Cursor.WAIT_CURSOR)); log.info("Re-read PrintFormat"); int AD_PrintFormat_ID = m_reportEngine.getPrintFormat().getID(); Language language = m_reportEngine.getPrintFormat().getLanguage(); MPrintFormat pf = MPrintFormat.get(Env.getCtx(), AD_PrintFormat_ID, true); pf.setLanguage(language); // needs to be re-set - otherwise viewer will be blank pf.setTranslationLanguage(language); m_reportEngine.setPrintFormat(pf); revalidate(); cmd_drill(); // setCursor } } // windowStateChanged
/** Descripción de Método */ private void cmd_translate() { ArrayList list = new ArrayList(); ValueNamePair pp = null; String sql = "SELECT Name, AD_Language FROM AD_Language WHERE IsSystemLanguage='Y' ORDER BY 1"; try { PreparedStatement pstmt = DB.prepareStatement(sql); ResultSet rs = pstmt.executeQuery(); while (rs.next()) { list.add(new ValueNamePair(rs.getString(2), rs.getString(1))); } rs.close(); pstmt.close(); } catch (SQLException e) { log.log(Level.SEVERE, "", e); } if (list.size() == 0) { ADialog.warn(m_WindowNo, this, "NoTranslation"); return; } // Dialog String title = Msg.getMsg(Env.getCtx(), "PrintFormatTrl", true); String message = Msg.getMsg(Env.getCtx(), "PrintFormatTrl", false); int choice = JOptionPane.showOptionDialog( this, message, title, JOptionPane.OK_OPTION, JOptionPane.QUESTION_MESSAGE, null, list.toArray(), null); if (choice == JOptionPane.CLOSED_OPTION) { return; } // pp = (ValueNamePair) list.get(choice); String AD_Language = pp.getValue(); int AD_PrintFormat_ID = m_reportEngine.getPrintFormat().getID(); log.config(AD_Language + " - AD_PrintFormat_ID=" + AD_PrintFormat_ID); StringBuffer sb = new StringBuffer(); // English if (Language.isBaseLanguage(AD_Language)) { sb.append( "UPDATE AD_PrintFormatItem pfi " + "SET Name = (SELECT e.Name FROM AD_Element e, AD_Column c" + " WHERE e.AD_Element_ID=c.AD_Element_ID AND c.AD_Column_ID=pfi.AD_Column_ID)," + "PrintName = (SELECT e.PrintName FROM AD_Element e, AD_Column c" + " WHERE e.AD_Element_ID=c.AD_Element_ID AND c.AD_Column_ID=pfi.AD_Column_ID) " + "WHERE AD_PrintFormat_ID=") .append(AD_PrintFormat_ID) .append( " AND EXISTS (SELECT * FROM AD_Element e, AD_Column c" + " WHERE e.AD_Element_ID=c.AD_Element_ID AND c.AD_Column_ID=pfi.AD_Column_ID)"); } else { AD_Language = "'" + AD_Language + "'"; sb.append( "UPDATE AD_PrintFormatItem pfi " + "SET Name = (SELECT e.Name FROM AD_Element_Trl e, AD_Column c" + " WHERE e.AD_Language=") .append(AD_Language) .append( " AND e.AD_Element_ID=c.AD_Element_ID AND c.AD_Column_ID=pfi.AD_Column_ID), " + "PrintName = (SELECT e.PrintName FROM AD_Element_Trl e, AD_Column c" + " WHERE e.AD_Language=") .append(AD_Language) .append( " AND e.AD_Element_ID=c.AD_Element_ID AND c.AD_Column_ID=pfi.AD_Column_ID) " + "WHERE AD_PrintFormat_ID=") .append(AD_PrintFormat_ID) .append( " AND EXISTS (SELECT * FROM AD_Element_Trl e, AD_Column c" + " WHERE e.AD_Language=") .append(AD_Language) .append(" AND e.AD_Element_ID=c.AD_Element_ID AND c.AD_Column_ID=pfi.AD_Column_ID)"); } int count = DB.executeUpdate(sb.toString()); log.config("Count=" + count); // m_reportEngine.setPrintFormat(MPrintFormat.get(Env.getCtx(), AD_PrintFormat_ID, true)); revalidate(); } // cmd_translate