public static Integer getOrgParentID(Properties ctx, Integer orgID, String trxName) {
return DB.getSQLValue(
trxName,
"select getnodepadre(?, ?, '" + X_AD_Tree.TREETYPE_Organization + "')",
Env.getAD_Client_ID(ctx),
orgID);
}
/**
* Get Linked BPartner
*
* @return C_BPartner_ID
*/
public int getLinkedC_BPartner_ID() {
if (m_linkedBPartner == null) {
int C_BPartner_ID =
DB.getSQLValue(
null,
"SELECT C_BPartner_ID FROM C_BPartner WHERE AD_OrgBP_ID=?",
Integer.toString(getAD_Org_ID()));
if (C_BPartner_ID < 0) { // not found = -1
C_BPartner_ID = 0;
}
m_linkedBPartner = new Integer(C_BPartner_ID);
}
return m_linkedBPartner.intValue();
} // getLinkedC_BPartner_ID
/**
* Get the next Line No
*
* @return next line no
*/
private int getNextLine() {
return DB.getSQLValue(
"MPC_ProfileBOMLine",
"SELECT COALESCE(MAX(Line),0)+10 FROM MPC_ProfileBOMLine WHERE MPC_ProfileBOM_ID=?",
getMPC_ProfileBOM_ID());
} // getLineFromProject
private Integer getVisualOptionReferenceID() {
return DB.getSQLValue(
null,
"SELECT ad_reference_id FROM ad_reference WHERE ad_componentobjectuid = 'CORE-AD_Reference-1010236'");
}
/** Descripción de Método */
private void cmd_find() {
setCursor(Cursor.getPredefinedCursor(Cursor.WAIT_CURSOR));
int AD_Table_ID = m_reportEngine.getPrintFormat().getAD_Table_ID();
String title = null;
String tableName = null;
// Get Find Tab Info
String sql =
"SELECT t.AD_Tab_ID "
// ,w.Name, t.Name, w.IsDefault, t.SeqNo, ABS (tt.AD_Window_ID-t.AD_Window_ID)
+ "FROM AD_Tab t"
+ " INNER JOIN AD_Window w ON (t.AD_Window_ID=w.AD_Window_ID)"
+ " INNER JOIN AD_Table tt ON (t.AD_Table_ID=tt.AD_Table_ID) "
+ "WHERE t.AD_Table_ID=? "
+ "ORDER BY w.IsDefault DESC, t.SeqNo, ABS (tt.AD_Window_ID-t.AD_Window_ID)";
int AD_Tab_ID = DB.getSQLValue(null, sql, AD_Table_ID);
//
sql = "SELECT Name, TableName FROM AD_Tab_v WHERE AD_Tab_ID=?";
if (!Env.isBaseLanguage(Env.getCtx(), "AD_Tab")) {
sql =
"SELECT Name, TableName FROM AD_Tab_vt WHERE AD_Tab_ID=?"
+ " AND AD_Language='"
+ Env.getAD_Language(Env.getCtx())
+ "'";
}
try {
PreparedStatement pstmt = DB.prepareStatement(sql);
pstmt.setInt(1, AD_Tab_ID);
ResultSet rs = pstmt.executeQuery();
//
if (rs.next()) {
title = rs.getString(1);
tableName = rs.getString(2);
}
//
rs.close();
pstmt.close();
} catch (SQLException e) {
log.log(Level.SEVERE, "MTabVO.create(1)", e);
}
MField[] findFields = null;
if (tableName != null) {
findFields = MField.createFields(m_ctx, m_WindowNo, 0, AD_Tab_ID);
}
if (findFields == null) { // No Tab for Table exists
bFind.setEnabled(false);
} else {
Find find = new Find(this, m_WindowNo, title, AD_Table_ID, tableName, "", findFields, 1);
m_reportEngine.setQuery(find.getQuery());
revalidate();
}
cmd_drill(); // setCursor
} // cmd_find