use of org.compiere.model.MColumn in project adempiere by adempiere.
the class ModelADServiceImpl method getList.
public WindowTabDataDocument getList(ModelGetListRequestDocument req) throws XFireFault {
WindowTabDataDocument resdoc = WindowTabDataDocument.Factory.newInstance();
WindowTabData res = resdoc.addNewWindowTabData();
DataSet ds = res.addNewDataSet();
ModelGetList modelGetList = req.getModelGetListRequest().getModelGetList();
String serviceType = modelGetList.getServiceType();
int cnt = 0;
ADLoginRequest reqlogin = req.getModelGetListRequest().getADLoginRequest();
String err = modelLogin(reqlogin, webServiceName, "getList", serviceType);
if (err != null && err.length() > 0) {
res.setError(err);
res.setErrorInfo(err);
res.setSuccess(false);
return resdoc;
}
int roleid = reqlogin.getRoleID();
// Validate parameters
modelGetList.setADReferenceID(validateParameter("AD_Reference_ID", modelGetList.getADReferenceID()));
modelGetList.setFilter(validateParameter("Filter", modelGetList.getFilter()));
int ref_id = modelGetList.getADReferenceID();
String filter = modelGetList.getFilter();
if (filter == null || filter.length() == 0)
filter = "";
else
filter = " AND " + filter;
Properties ctx = m_cs.getM_ctx();
X_AD_Reference ref = new X_AD_Reference(ctx, ref_id, null);
String sql = null;
ArrayList<String> listColumnNames = new ArrayList<String>();
PreparedStatement pstmt = null;
ResultSet rs = null;
if (X_AD_Reference.VALIDATIONTYPE_ListValidation.equals(ref.getValidationType())) {
// Fill List Reference
String ad_language = Env.getAD_Language(ctx);
boolean isBaseLanguage = Env.isBaseLanguage(ad_language, "AD_Ref_List");
sql = isBaseLanguage ? "SELECT AD_Ref_List.AD_Ref_List_ID, AD_Ref_List.Value, AD_Ref_List.Name, AD_Ref_List.Description " + "FROM AD_Ref_List " + "WHERE AD_Ref_List.AD_Reference_ID=? AND AD_Ref_List.IsActive='Y' " + filter + " ORDER BY AD_Ref_List.Name" : "SELECT AD_Ref_List.AD_Ref_List_ID, AD_Ref_List.Value, AD_Ref_List_Trl.Name, AD_Ref_List_Trl.Description " + "FROM AD_Ref_List, AD_Ref_List_Trl " + "WHERE AD_Ref_List.AD_Reference_ID=? AND AD_Ref_List.IsActive='Y' AND AD_Ref_List_Trl.AD_Language=? AND AD_Ref_List.AD_Ref_List_ID=AD_Ref_List_Trl.AD_Ref_List_ID " + filter + " ORDER BY AD_Ref_List_Trl.Name";
listColumnNames.add("AD_Ref_List_ID");
listColumnNames.add("Value");
listColumnNames.add("Name");
listColumnNames.add("Description");
try {
pstmt = DB.prepareStatement(sql, null);
pstmt.setInt(1, ref_id);
if (!isBaseLanguage)
pstmt.setString(2, ad_language);
rs = pstmt.executeQuery();
} catch (SQLException e) {
res.setError(e.getMessage());
res.setErrorInfo(sql);
res.setSuccess(false);
DB.close(rs, pstmt);
rs = null;
pstmt = null;
throw new XFireFault(e.getClass().toString() + " " + e.getMessage() + " sql=" + sql, e.getCause(), new QName("getList"));
}
} else if (X_AD_Reference.VALIDATIONTYPE_TableValidation.equals(ref.getValidationType())) {
// Fill values from a reference table
MRole role = new MRole(ctx, roleid, null);
String sqlrt = "SELECT * FROM AD_Ref_Table WHERE AD_Reference_ID=?";
MRefTable rt = null;
PreparedStatement pstmtrt = null;
ResultSet rsrt = null;
try {
pstmtrt = DB.prepareStatement(sqlrt, null);
pstmtrt.setInt(1, ref_id);
rsrt = pstmtrt.executeQuery();
if (rsrt.next())
rt = new MRefTable(ctx, rsrt, null);
} catch (Exception e) {
// ignore this exception
} finally {
DB.close(rsrt, pstmtrt);
rsrt = null;
pstmtrt = null;
}
if (rt == null)
throw new XFireFault("Web service type " + m_webservicetype.getValue() + ": reference table " + ref_id + " not found", new QName("getList"));
MTable table = new MTable(ctx, rt.getAD_Table_ID(), null);
MColumn column = new MColumn(ctx, rt.getAD_Key(), null);
// TODO: if any value or identifier column is translated, then get them from trl table (and client has multilanguage documents enabled)
sql = "SELECT " + column.getColumnName();
listColumnNames.add(column.getColumnName());
if (rt.isValueDisplayed()) {
sql += ",Value";
listColumnNames.add("Value");
}
String sqlident = "SELECT ColumnName FROM AD_Column WHERE AD_Table_ID=? AND IsActive='Y' AND IsIdentifier='Y' ORDER BY SeqNo";
PreparedStatement pstmtident = null;
ResultSet rsident = null;
try {
pstmtident = DB.prepareStatement(sqlident, null);
pstmtident.setInt(1, rt.getAD_Table_ID());
rsident = pstmtident.executeQuery();
while (rsident.next()) {
String colnameident = rsident.getString("ColumnName");
if (rt.isValueDisplayed() && colnameident.equalsIgnoreCase("Value")) {
// Value already added
} else {
sql += "," + colnameident;
listColumnNames.add(colnameident);
}
}
} catch (Exception e) {
// ignore this exception
} finally {
DB.close(rsident, pstmtident);
rsident = null;
pstmtident = null;
}
sql += " FROM " + table.getTableName() + " WHERE IsActive='Y'";
/** 2014-11-05 Carlos Parada Change for ReadOnly SQL Access */
//sql = role.addAccessSQL(sql, table.getTableName(), true, true);
sql = role.addAccessSQL(sql, table.getTableName(), true, false);
/** End Carlos Parada */
sql += filter;
if (rt.getWhereClause() != null && rt.getWhereClause().length() > 0)
sql += " AND " + rt.getWhereClause();
if (rt.getOrderByClause() != null && rt.getOrderByClause().length() > 0)
sql += " ORDER BY " + rt.getOrderByClause();
try {
pstmt = DB.prepareStatement(sql, null);
rs = pstmt.executeQuery();
} catch (SQLException e) {
res.setError(e.getMessage());
res.setErrorInfo(sql);
res.setSuccess(false);
DB.close(rs, pstmt);
rs = null;
pstmt = null;
throw new XFireFault(e.getClass().toString() + " " + e.getMessage() + " sql=" + sql, e.getCause(), new QName("getList"));
}
} else {
// Don't fill - wrong type
}
if (rs != null) {
try {
while (rs.next()) {
cnt++;
// Add values to the dataset
DataRow dr = ds.addNewDataRow();
for (String listColumnName : listColumnNames) {
if (m_webservicetype.isOutputColumnNameAllowed(listColumnName)) {
DataField dfid = dr.addNewField();
dfid.setColumn(listColumnName);
dfid.setVal(rs.getString(listColumnName));
}
}
}
res.setSuccess(true);
} catch (SQLException e) {
res.setError(e.getMessage());
res.setErrorInfo(sql);
res.setSuccess(false);
throw new XFireFault(e.getClass().toString() + " " + e.getMessage() + " sql=" + sql, e.getCause(), new QName("getList"));
} finally {
DB.close(rs, pstmt);
rs = null;
pstmt = null;
}
}
res.setRowCount(cnt);
res.setNumRows(cnt);
res.setTotalRows(cnt);
res.setStartRow(1);
return resdoc;
}
use of org.compiere.model.MColumn in project adempiere by adempiere.
the class MWFActivity method performWork.
// run
/**
* Perform Work.
* Set Text Msg.
* @param trx transaction
* @return true if completed, false otherwise
* @throws Exception if error
*/
private boolean performWork(Trx trx) throws Exception {
log.info(m_node + " [" + trx.getTrxName() + "]");
m_docStatus = null;
if (// overwrite priority if defined
m_node.getPriority() != 0)
setPriority(m_node.getPriority());
String action = m_node.getAction();
/****** Sleep (Start/End) ******/
if (MWFNode.ACTION_WaitSleep.equals(action)) {
log.fine("Sleep:WaitTime=" + m_node.getWaitTime());
if (m_node.getWaitingTime() == 0)
// done
return true;
Calendar cal = Calendar.getInstance();
cal.add(m_node.getDurationCalendarField(), m_node.getWaitTime());
setEndWaitTime(new Timestamp(cal.getTimeInMillis()));
// not done
return false;
} else /****** Document Action ******/
if (MWFNode.ACTION_DocumentAction.equals(action)) {
log.fine("DocumentAction=" + m_node.getDocAction());
getPO(trx);
if (m_po == null)
throw new Exception("Persistent Object not found - AD_Table_ID=" + getAD_Table_ID() + ", Record_ID=" + getRecord_ID());
boolean success = false;
String processMsg = null;
DocAction doc = null;
if (m_po instanceof DocAction) {
doc = (DocAction) m_po;
//
try {
// ** Do the work
success = doc.processIt(m_node.getDocAction());
setTextMsg(doc.getSummary());
processMsg = doc.getProcessMsg();
// the rest of methods return boolean, so doc status must not be taken into account when not successful
if (DocAction.ACTION_Prepare.equals(m_node.getDocAction()) || DocAction.ACTION_Complete.equals(m_node.getDocAction()) || success)
m_docStatus = doc.getDocStatus();
} catch (Exception e) {
if (m_process != null)
m_process.setProcessMsg(e.getLocalizedMessage());
throw e;
}
if (m_process != null)
m_process.setProcessMsg(processMsg);
} else
throw new IllegalStateException("Persistent Object not DocAction - " + m_po.getClass().getName() + " - AD_Table_ID=" + getAD_Table_ID() + ", Record_ID=" + getRecord_ID());
//
if (!m_po.save()) {
success = false;
processMsg = "SaveError";
}
if (!success) {
if (processMsg == null || processMsg.length() == 0) {
processMsg = "PerformWork Error - " + m_node.toStringX();
if (// problem: status will be rolled back
doc != null)
processMsg += " - DocStatus=" + doc.getDocStatus();
}
throw new Exception(processMsg);
}
return success;
} else /****** Report ******/
if (MWFNode.ACTION_AppsReport.equals(action)) {
log.fine("Report:AD_Process_ID=" + m_node.getAD_Process_ID());
// Process
MProcess process = MProcess.get(getCtx(), m_node.getAD_Process_ID());
process.set_TrxName(trx != null ? trx.getTrxName() : null);
if (!process.isReport() || process.getAD_ReportView_ID() == 0)
throw new IllegalStateException("Not a Report AD_Process_ID=" + m_node.getAD_Process_ID());
//
ProcessInfo pi = new ProcessInfo(m_node.getName(true), m_node.getAD_Process_ID(), getAD_Table_ID(), getRecord_ID());
pi.setAD_User_ID(getAD_User_ID());
pi.setAD_Client_ID(getAD_Client_ID());
MPInstance pInstance = new MPInstance(process, getRecord_ID());
pInstance.set_TrxName(trx != null ? trx.getTrxName() : null);
fillParameter(pInstance, trx);
pi.setAD_PInstance_ID(pInstance.getAD_PInstance_ID());
// Report
ReportEngine re = ReportEngine.get(getCtx(), pi);
if (re == null)
throw new IllegalStateException("Cannot create Report AD_Process_ID=" + m_node.getAD_Process_ID());
File report = re.getPDF();
// Notice
// HARDCODED WorkflowResult
int AD_Message_ID = 753;
MNote note = new MNote(getCtx(), AD_Message_ID, getAD_User_ID(), trx.getTrxName());
note.setTextMsg(m_node.getName(true));
note.setDescription(m_node.getDescription(true));
note.setRecord(getAD_Table_ID(), getRecord_ID());
note.saveEx();
// Attachment
MAttachment attachment = new MAttachment(getCtx(), MNote.Table_ID, note.getAD_Note_ID(), get_TrxName());
attachment.addEntry(report);
attachment.setTextMsg(m_node.getName(true));
attachment.saveEx();
return true;
} else /****** Process ******/
if (MWFNode.ACTION_AppsProcess.equals(action)) {
log.fine("Process:AD_Process_ID=" + m_node.getAD_Process_ID());
// Process
MProcess process = MProcess.get(getCtx(), m_node.getAD_Process_ID());
MPInstance pInstance = new MPInstance(process, getRecord_ID());
fillParameter(pInstance, trx);
//
ProcessInfo pi = new ProcessInfo(m_node.getName(true), m_node.getAD_Process_ID(), getAD_Table_ID(), getRecord_ID());
pi.setAD_User_ID(getAD_User_ID());
pi.setAD_Client_ID(getAD_Client_ID());
pi.setAD_PInstance_ID(pInstance.getAD_PInstance_ID());
return process.processItWithoutTrxClose(pi, trx);
} else /****** EMail ******/
if (MWFNode.ACTION_EMail.equals(action)) {
log.fine("EMail:EMailRecipient=" + m_node.getEMailRecipient());
getPO(trx);
if (m_po == null)
throw new Exception("Persistent Object not found - AD_Table_ID=" + getAD_Table_ID() + ", Record_ID=" + getRecord_ID());
if (m_po instanceof DocAction) {
m_emails = new ArrayList<String>();
sendEMail();
setTextMsg(m_emails.toString());
} else {
MClient client = MClient.get(getCtx(), getAD_Client_ID());
MMailText mailtext = new MMailText(getCtx(), getNode().getR_MailText_ID(), null);
String subject = getNode().getDescription() + ": " + mailtext.getMailHeader();
String message = mailtext.getMailText(true) + "\n-----\n" + getNodeHelp();
String to = getNode().getEMail();
client.sendEMail(to, subject, message, null);
}
// done
return true;
} else /****** Set Variable ******/
if (MWFNode.ACTION_SetVariable.equals(action)) {
String value = m_node.getAttributeValue();
log.fine("SetVariable:AD_Column_ID=" + m_node.getAD_Column_ID() + " to " + value);
MColumn column = m_node.getColumn();
int dt = column.getAD_Reference_ID();
return setVariable(value, dt, null, trx);
} else /****** TODO Start WF Instance ******/
if (MWFNode.ACTION_SubWorkflow.equals(action)) {
log.warning("Workflow:AD_Workflow_ID=" + m_node.getAD_Workflow_ID());
log.warning("Start WF Instance is not implemented yet");
} else /****** User Choice ******/
if (MWFNode.ACTION_UserChoice.equals(action)) {
log.fine("UserChoice:AD_Column_ID=" + m_node.getAD_Column_ID());
// Approval
if (m_node.isUserApproval() && getPO(trx) instanceof DocAction) {
DocAction doc = (DocAction) m_po;
boolean autoApproval = false;
// Approval Hierarchy
if (isInvoker()) {
// Set Approver
int startAD_User_ID = Env.getAD_User_ID(getCtx());
if (startAD_User_ID == 0)
startAD_User_ID = doc.getDoc_User_ID();
int nextAD_User_ID = getApprovalUser(startAD_User_ID, doc.getC_Currency_ID(), doc.getApprovalAmt(), doc.getAD_Org_ID(), // own doc
startAD_User_ID == doc.getDoc_User_ID());
// same user = approved
autoApproval = startAD_User_ID == nextAD_User_ID;
if (!autoApproval)
setAD_User_ID(nextAD_User_ID);
} else // fixed Approver
{
MWFResponsible resp = getResponsible();
// [ 1742751 ] Workflow: User Choice is not working
if (resp.isHuman()) {
autoApproval = resp.getAD_User_ID() == Env.getAD_User_ID(getCtx());
if (!autoApproval && resp.getAD_User_ID() != 0)
setAD_User_ID(resp.getAD_User_ID());
} else if (resp.isRole()) {
MUserRoles[] urs = MUserRoles.getOfRole(getCtx(), resp.getAD_Role_ID());
for (int i = 0; i < urs.length; i++) {
if (urs[i].getAD_User_ID() == Env.getAD_User_ID(getCtx())) {
autoApproval = true;
break;
}
}
} else if (resp.isOrganization()) {
throw new AdempiereException("Support not implemented for " + resp);
} else {
throw new AdempiereException("@NotSupported@ " + resp);
}
// end MZ
}
if (autoApproval && doc.processIt(DocAction.ACTION_Approve) && doc.save())
// done
return true;
}
// wait for user
return false;
} else /****** User Form ******/
if (MWFNode.ACTION_UserForm.equals(action)) {
log.fine("Form:AD_Form_ID=" + m_node.getAD_Form_ID());
return false;
} else if (MWFNode.ACTION_SmartBrowse.equals(action)) {
log.fine("Form:AD_Browse_ID=" + m_node.getAD_Browse_ID());
return false;
} else /****** User Window ******/
if (MWFNode.ACTION_UserWindow.equals(action)) {
log.fine("Window:AD_Window_ID=" + m_node.getAD_Window_ID());
return false;
}
//
throw new IllegalArgumentException("Invalid Action (Not Implemented) =" + action);
}
use of org.compiere.model.MColumn in project adempiere by adempiere.
the class FieldRecordInfo method addLine.
// dynInit
/**
* Add Line
* @param AD_Column_ID column
* @param Updated updated
* @param UpdatedBy user
* @param OldValue old
* @param NewValue new
*/
private void addLine(int AD_Column_ID, Timestamp Updated, int UpdatedBy, String OldValue, String NewValue) {
Vector<String> line = new Vector<String>();
// Column
MColumn column = MColumn.get(Env.getCtx(), AD_Column_ID);
//
if (OldValue != null && OldValue.equals(MChangeLog.NULL))
OldValue = null;
String showOldValue = OldValue;
if (NewValue != null && NewValue.equals(MChangeLog.NULL))
NewValue = null;
String showNewValue = NewValue;
//
try {
if (DisplayType.isText(column.getAD_Reference_ID()))
;
else if (column.getAD_Reference_ID() == DisplayType.YesNo) {
if (OldValue != null) {
boolean yes = OldValue.equals("true") || OldValue.equals("Y");
showOldValue = Msg.getMsg(Env.getCtx(), yes ? "Y" : "N");
}
if (NewValue != null) {
boolean yes = NewValue.equals("true") || NewValue.equals("Y");
showNewValue = Msg.getMsg(Env.getCtx(), yes ? "Y" : "N");
}
} else if (column.getAD_Reference_ID() == DisplayType.Amount) {
if (OldValue != null)
showOldValue = m_amtFormat.format(new BigDecimal(OldValue));
if (NewValue != null)
showNewValue = m_amtFormat.format(new BigDecimal(NewValue));
} else if (column.getAD_Reference_ID() == DisplayType.Integer) {
if (OldValue != null)
showOldValue = m_intFormat.format(new Integer(OldValue));
if (NewValue != null)
showNewValue = m_intFormat.format(new Integer(NewValue));
} else if (DisplayType.isNumeric(column.getAD_Reference_ID())) {
if (OldValue != null)
showOldValue = m_numberFormat.format(new BigDecimal(OldValue));
if (NewValue != null)
showNewValue = m_numberFormat.format(new BigDecimal(NewValue));
} else if (column.getAD_Reference_ID() == DisplayType.Date) {
if (OldValue != null)
showOldValue = m_dateFormat.format(Timestamp.valueOf(OldValue));
if (NewValue != null)
showNewValue = m_dateFormat.format(Timestamp.valueOf(NewValue));
} else if (column.getAD_Reference_ID() == DisplayType.DateTime) {
if (OldValue != null)
showOldValue = m_dateTimeFormat.format(Timestamp.valueOf(OldValue));
if (NewValue != null)
showNewValue = m_dateTimeFormat.format(Timestamp.valueOf(NewValue));
} else if (DisplayType.isLookup(column.getAD_Reference_ID())) {
MLookup lookup = MLookupFactory.get(Env.getCtx(), 0, AD_Column_ID, column.getAD_Reference_ID(), Env.getLanguage(Env.getCtx()), column.getColumnName(), column.getAD_Reference_Value_ID(), column.isParent(), null);
if (OldValue != null) {
Object key = OldValue;
NamePair pp = lookup.get(key);
if (pp != null)
showOldValue = pp.getName();
}
if (NewValue != null) {
Object key = NewValue;
NamePair pp = lookup.get(key);
if (pp != null)
showNewValue = pp.getName();
}
} else if (DisplayType.isLOB(column.getAD_Reference_ID()))
;
} catch (Exception e) {
log.log(Level.WARNING, OldValue + "->" + NewValue, e);
}
//
line.add(showNewValue);
line.add(showOldValue);
// UpdatedBy
MUser user = MUser.get(Env.getCtx(), UpdatedBy);
line.add(user.getName());
// Updated
line.add(m_dateFormat.format(Updated));
m_data.add(line);
}
use of org.compiere.model.MColumn in project adempiere by adempiere.
the class TrifonTest method testMProductCreation.
public void testMProductCreation() {
boolean singleCommit = true;
MTable mTable = MTable.get(Env.getCtx(), MInvoice.Table_Name);
System.out.println("XML presentation... is: " + mTable.get_xmlDocument(false));
MColumn[] mcolumn = mTable.getColumns(true);
for (int i = 0; i < mcolumn.length; i++) {
System.out.println("Name............ is: " + mcolumn[i].getName());
System.out.println("ColumnName...... is: " + mcolumn[i].getColumnName());
System.out.println("Desc............ is: " + mcolumn[i].getDescription());
System.out.println("Length.......... is: " + mcolumn[i].getFieldLength());
System.out.println("Reference_ID.... is: " + mcolumn[i].getAD_Reference_ID());
X_AD_Reference reference = new X_AD_Reference(Env.getCtx(), mcolumn[i].getAD_Reference_ID(), getTrxName());
System.out.println("ReferenceName... is: " + reference.getName());
System.out.println("..............................");
}
assertTrue(this.getClass().getName(), true);
}
use of org.compiere.model.MColumn in project adempiere by adempiere.
the class VSortTab method getIdentifier.
// dynInit
/**
* get Identifier
* @param tableName
* @param columnName
* @param AD_Column_ID
* @param isTranslated
* @return Sql
*/
private String getIdentifier(String tableName, String columnName, Integer AD_Column_ID, boolean isTranslated) {
Language language = Language.getLanguage(Env.getAD_Language(Env.getCtx()));
StringBuilder sql = new StringBuilder("");
MColumn column = MColumn.get(Env.getCtx(), AD_Column_ID);
if (DisplayType.TableDir == column.getAD_Reference_ID() || DisplayType.Search == column.getAD_Reference_ID())
sql.append("(").append(MLookupFactory.getLookup_TableDirEmbed(language, columnName, "t")).append(")");
else if (DisplayType.Table == column.getAD_Reference_ID())
sql.append("(").append(MLookupFactory.getLookup_TableEmbed(language, column.getColumnName(), "t", column.getAD_Reference_Value_ID())).append(")");
else if (DisplayType.List == column.getAD_Reference_ID())
sql.append("(").append(MLookupFactory.getLookup_ListEmbed(language, column.getAD_Reference_Value_ID(), columnName)).append(")");
else
sql.append(isTranslated ? "tt." : "t.").append(columnName);
return sql.toString();
}
Aggregations