/** 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 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
*
* @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 */
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
