use of pl.x3E.adInterface.WindowTabData in project adempiere by adempiere.
the class ModelADServiceImpl method queryData.
public WindowTabDataDocument queryData(ModelCRUDRequestDocument req) throws XFireFault {
WindowTabDataDocument ret = WindowTabDataDocument.Factory.newInstance();
WindowTabData resp = ret.addNewWindowTabData();
ModelCRUD modelCRUD = req.getModelCRUDRequest().getModelCRUD();
String serviceType = modelCRUD.getServiceType();
/** 2014-12-04 Carlos Parada Add Support for Paginate Records */
/** Current Page*/
int currentPage = req.getModelCRUDRequest().getModelCRUD().getPageNo();
/** Records per Page*/
int m_RecByPage = MSysConfig.getIntValue("WS_RECORDS_BY_PAGE", 1);
/** Quantity Pages*/
int qtyPages = 0;
log.info("Current Page " + currentPage);
/** 2014-12-04 Carlos Parada */
ADLoginRequest reqlogin = req.getModelCRUDRequest().getADLoginRequest();
String err = modelLogin(reqlogin, webServiceName, "queryData", serviceType);
if (err != null && err.length() > 0) {
resp.setError(err);
return ret;
}
// Validate parameters vs service type
validateCRUD(modelCRUD);
Properties ctx = m_cs.getM_ctx();
String tableName = modelCRUD.getTableName();
// get the PO for the tablename and record ID
MTable table = MTable.get(ctx, tableName);
if (table == null)
throw new XFireFault("Web service type " + m_webservicetype.getValue() + ": table " + tableName + " not found", new QName("queryData"));
int roleid = reqlogin.getRoleID();
MRole role = new MRole(ctx, roleid, null);
// 2014-12-04 Carlos Parada Replace ResultSet For Query
List<PO> records = null;
String key = m_cs.getM_AD_User_ID() + "_" + serviceType;
if (currentPage != 0)
records = (List<PO>) s_cache.get(key);
//"SELECT * FROM " + tableName;
String sqlWhere = "";
//sqlquery = role.addAccessSQL(sqlquery, tableName, true, true);
for (DataField field : modelCRUD.getDataRow().getFieldList()) {
if (m_webservicetype.isInputColumnNameAllowed(field.getColumn())) {
sqlWhere += (sqlWhere.equals("") ? "" : " AND ") + field.getColumn() + "=?";
} else {
throw new XFireFault("Web service type " + m_webservicetype.getValue() + ": input column " + field.getColumn() + " not allowed", new QName("queryData"));
}
}
if (modelCRUD.getFilter() != null && modelCRUD.getFilter().length() > 0)
sqlWhere += " AND " + modelCRUD.getFilter();
POInfo poinfo = POInfo.getPOInfo(ctx, table.getAD_Table_ID());
int cnt = 0;
try {
if (records == null) {
Query query = new Query(ctx, poinfo.getTableName(), sqlWhere, null);
Object[] parameters = new Object[modelCRUD.getDataRow().getFieldList().size()];
int p = 1;
int i = 0;
for (DataField field : modelCRUD.getDataRow().getFieldList()) {
parameters[i] = field.getVal();
i++;
}
if (parameters.length > 0)
query.setParameters(parameters);
records = query.setApplyAccessFilter(true).list();
}
// Angelo Dabala' (genied) must create just one DataSet, moved outside of the while loop
DataSet ds = resp.addNewDataSet();
// Set Quantity of Pages
if (records.size() != 0)
qtyPages = new BigDecimal(records.size()).divide(new BigDecimal(m_RecByPage)).setScale(0, BigDecimal.ROUND_UP).intValue();
int begin = 0, end = 0;
begin = currentPage * m_RecByPage;
end = (((currentPage + 1) * m_RecByPage) > records.size() ? records.size() : ((currentPage + 1) * m_RecByPage));
for (int j = begin; j < end; j++) {
PO record = records.get(j);
cnt++;
DataRow dr = ds.addNewDataRow();
for (int i = 0; i < poinfo.getColumnCount(); i++) {
String columnName = poinfo.getColumnName(i);
if (m_webservicetype.isOutputColumnNameAllowed(columnName)) {
DataField dfid = dr.addNewField();
dfid.setColumn(columnName);
dfid.setLval(record.get_ValueAsString(columnName));
}
}
}
} catch (Exception e) {
e.printStackTrace();
// ignore this exception
}
resp.setSuccess(true);
resp.setRowCount(cnt);
resp.setNumRows(cnt);
resp.setTotalRows(cnt);
resp.setStartRow(1);
resp.setQtyPages(qtyPages);
return ret;
}
use of pl.x3E.adInterface.WindowTabData in project adempiere by adempiere.
the class ADServiceImpl method updateDataRow.
public WindowTabDataDocument updateDataRow(int WindowNo, int TabNo, int RowNo, WindowTabDataDocument data) throws XFireFault {
authenticate(webServiceName, "updateDataRow");
WindowTabDataDocument ret = WindowTabDataDocument.Factory.newInstance();
WindowTabData wd = ret.addNewWindowTabData();
DataSet ds = wd.addNewDataSet();
DataRow ret_dr = ds.addNewDataRow();
WWindowStatus ws = WWindowStatus.get(WindowStatusMap, WindowNo, true, TabNo, true, RowNo);
if (ws != null) {
DataRow[] dr = data.getWindowTabData().getDataSet().getDataRowArray();
if (dr.length == 1) {
DataRow dr0 = dr[0];
boolean err = updateFields(ws, dr0);
if (ws.ads.m_is_error) {
wd.setError(ws.ads.m_error_message);
wd.setErrorInfo(ws.ads.m_error_info);
}
wd.setStatus(ws.ads.m_status_data);
wd.setStatusError(ws.ads.m_is_status_error);
//ws.curTab.dataRefresh();
fillDataRow(ret_dr, ws, true, false);
}
}
return ret;
}
use of pl.x3E.adInterface.WindowTabData in project adempiere by adempiere.
the class ADServiceImpl method deleteDataRow.
public WindowTabDataDocument deleteDataRow(int WindowNo, int TabNo, int RowNo) throws XFireFault {
authenticate(webServiceName, "deleteDataRow");
WindowTabDataDocument ret = WindowTabDataDocument.Factory.newInstance();
WindowTabData wd = ret.addNewWindowTabData();
DataSet ds = wd.addNewDataSet();
WWindowStatus ws = WWindowStatus.get(WindowStatusMap, WindowNo, false, 0, true, RowNo);
if (ws != null) {
wd.setSuccess(ws.curTab.dataDelete());
DataRow ret_dr = ds.addNewDataRow();
fillDataRow(ret_dr, ws, true, false);
if (ws.ads.m_is_error) {
wd.setError(ws.ads.m_error_message);
wd.setErrorInfo(ws.ads.m_error_info);
}
wd.setStatus(ws.ads.m_status_data);
wd.setStatusError(ws.ads.m_is_status_error);
updateRecIDMap(ws);
}
return ret;
}
use of pl.x3E.adInterface.WindowTabData in project adempiere by adempiere.
the class ADServiceImpl method ignoreDataRow.
public WindowTabDataDocument ignoreDataRow(int WindowNo, int TabNo, int RowNo) throws XFireFault {
authenticate(webServiceName, "ignoreDataRow");
WindowTabDataDocument ret = WindowTabDataDocument.Factory.newInstance();
WindowTabData wd = ret.addNewWindowTabData();
DataSet ds = wd.addNewDataSet();
WWindowStatus ws = WWindowStatus.get(WindowStatusMap, WindowNo, false, 0, true, RowNo);
if (ws != null) {
ws.curTab.dataIgnore();
wd.setSuccess(true);
DataRow ret_dr = ds.addNewDataRow();
fillDataRow(ret_dr, ws, true, false);
if (ws.ads.m_is_error) {
wd.setError(ws.ads.m_error_message);
wd.setErrorInfo(ws.ads.m_error_info);
}
wd.setStatus(ws.ads.m_status_data);
wd.setStatusError(ws.ads.m_is_status_error);
updateRecIDMap(ws);
}
return ret;
}
use of pl.x3E.adInterface.WindowTabData in project adempiere by adempiere.
the class ADServiceImpl method refreshDataRow.
public WindowTabDataDocument refreshDataRow(int WindowNo, int TabNo, int RowNo) throws XFireFault {
authenticate(webServiceName, "refreshDataRow");
WindowTabDataDocument ret = WindowTabDataDocument.Factory.newInstance();
WindowTabData wd = ret.addNewWindowTabData();
DataSet ds = wd.addNewDataSet();
WWindowStatus ws = WWindowStatus.get(WindowStatusMap, WindowNo, false, 0, true, RowNo);
if (ws != null) {
ws.curTab.dataRefresh();
wd.setSuccess(true);
DataRow ret_dr = ds.addNewDataRow();
fillDataRow(ret_dr, ws, true, false);
if (ws.ads.m_is_error) {
wd.setError(ws.ads.m_error_message);
wd.setErrorInfo(ws.ads.m_error_info);
}
wd.setStatus(ws.ads.m_status_data);
wd.setStatusError(ws.ads.m_is_status_error);
}
return ret;
}
Aggregations