Examples with RModel org.compiere.report.core.RModel used on opensource projects

Search in sources :

Example 1 with RModel

use of org.compiere.report.core.RModel in project adempiere by adempiere.

the class WAcctViewerData method query.

//  getButtonRecordID
/**************************************************************************
	/**
	 *  Create Query and submit
	 *  @return Report Model
	 */
protected RModel query() {
    //  Set Where Clause
    StringBuffer whereClause = new StringBuffer();
    if (C_AcctSchema_ID != 0)
        whereClause.append(RModel.TABLE_ALIAS).append(".C_AcctSchema_ID=").append(C_AcctSchema_ID);
    if (PostingType != null && PostingType.length() > 0) {
        if (whereClause.length() > 0)
            whereClause.append(" AND ");
        whereClause.append(RModel.TABLE_ALIAS).append(".PostingType='").append(PostingType).append("'");
    }
    if (documentQuery) {
        if (whereClause.length() > 0)
            whereClause.append(" AND ");
        whereClause.append(RModel.TABLE_ALIAS).append(".AD_Table_ID=").append(AD_Table_ID).append(" AND ").append(RModel.TABLE_ALIAS).append(".Record_ID=").append(Record_ID);
    } else {
        //  get values (Queries)
        Iterator<String> it = whereInfo.values().iterator();
        while (it.hasNext()) {
            String where = it.next();
            if (//  add only if not empty
            where != null && where.length() > 0) {
                if (whereClause.length() > 0)
                    whereClause.append(" AND ");
                whereClause.append(RModel.TABLE_ALIAS).append(".").append(where);
            }
        }
        if (DateFrom != null || DateTo != null) {
            if (whereClause.length() > 0)
                whereClause.append(" AND ");
            if (DateFrom != null && DateTo != null)
                whereClause.append("TRUNC(").append(RModel.TABLE_ALIAS).append(".DateAcct, 'DD') BETWEEN ").append(DB.TO_DATE(DateFrom)).append(" AND ").append(DB.TO_DATE(DateTo));
            else if (DateFrom != null)
                whereClause.append("TRUNC(").append(RModel.TABLE_ALIAS).append(".DateAcct, 'DD') >= ").append(DB.TO_DATE(DateFrom));
            else
                //  DateTo != null
                whereClause.append("TRUNC(").append(RModel.TABLE_ALIAS).append(".DateAcct, 'DD') <= ").append(DB.TO_DATE(DateTo));
        }
        if (AD_Org_ID != 0) {
            if (whereClause.length() > 0)
                whereClause.append(" AND ");
            whereClause.append(RModel.TABLE_ALIAS).append(".AD_Org_ID=").append(AD_Org_ID);
        }
    }
    //  Set Order By Clause
    StringBuffer orderClause = new StringBuffer();
    if (sortBy1.length() > 0)
        orderClause.append(RModel.TABLE_ALIAS).append(".").append(sortBy1);
    if (sortBy2.length() > 0) {
        if (orderClause.length() > 0)
            orderClause.append(",");
        orderClause.append(RModel.TABLE_ALIAS).append(".").append(sortBy2);
    }
    if (sortBy3.length() > 0) {
        if (orderClause.length() > 0)
            orderClause.append(",");
        orderClause.append(RModel.TABLE_ALIAS).append(".").append(sortBy3);
    }
    if (sortBy4.length() > 0) {
        if (orderClause.length() > 0)
            orderClause.append(",");
        orderClause.append(RModel.TABLE_ALIAS).append(".").append(sortBy4);
    }
    if (orderClause.length() == 0)
        orderClause.append(RModel.TABLE_ALIAS).append(".Fact_Acct_ID");
    RModel rm = getRModel();
    if (group1 && sortBy1.length() > 0)
        rm.setGroup(sortBy1);
    if (group2 && sortBy2.length() > 0)
        rm.setGroup(sortBy2);
    if (group3 && sortBy3.length() > 0)
        rm.setGroup(sortBy3);
    if (group4 && sortBy4.length() > 0)
        rm.setGroup(sortBy4);
    //  Totals
    rm.setFunction("AmtAcctDr", RModel.FUNCTION_SUM);
    rm.setFunction("AmtAcctCr", RModel.FUNCTION_SUM);
    rm.query(Env.getCtx(), whereClause.toString(), orderClause.toString());
    return rm;
}
Also used : RModel(org.compiere.report.core.RModel)

Example 2 with RModel

use of org.compiere.report.core.RModel in project adempiere by adempiere.

the class WAcctViewerData method getRModel.

// query
/**
	 *  Create Report Model (Columns)
	 *  @return Report Model
	 */
private RModel getRModel() {
    Properties ctx = Env.getCtx();
    RModel rm = new RModel("Fact_Acct");
    //  Add Key (Lookups)
    ArrayList<String> keys = createKeyColumns();
    int max = m_leadingColumns;
    if (max == 0)
        max = keys.size();
    for (int i = 0; i < max; i++) {
        String column = keys.get(i);
        if (column != null && column.startsWith("Date"))
            rm.addColumn(new RColumn(ctx, column, DisplayType.Date));
        else if (column != null && column.endsWith("_ID"))
            rm.addColumn(new RColumn(ctx, column, DisplayType.TableDir));
    }
    //  Main Info
    rm.addColumn(new RColumn(ctx, "AmtAcctDr", DisplayType.Amount));
    rm.addColumn(new RColumn(ctx, "AmtAcctCr", DisplayType.Amount));
    if (displaySourceAmt) {
        if (!keys.contains("DateTrx"))
            rm.addColumn(new RColumn(ctx, "DateTrx", DisplayType.Date));
        rm.addColumn(new RColumn(ctx, "C_Currency_ID", DisplayType.TableDir));
        rm.addColumn(new RColumn(ctx, "AmtSourceDr", DisplayType.Amount));
        rm.addColumn(new RColumn(ctx, "AmtSourceCr", DisplayType.Amount));
        rm.addColumn(new RColumn(ctx, "Rate", DisplayType.Amount, "CASE WHEN (AmtSourceDr + AmtSourceCr) = 0 THEN 0" + " ELSE (AmtAcctDr + AmtAcctCr) / (AmtSourceDr + AmtSourceCr) END"));
    }
    for (int i = max; i < keys.size(); i++) {
        String column = keys.get(i);
        if (column != null && column.startsWith("Date"))
            rm.addColumn(new RColumn(ctx, column, DisplayType.Date));
        else if (column.startsWith("UserElement")) {
            if (column.indexOf('1') != -1)
                rm.addColumn(new RColumn(ctx, column, DisplayType.TableDir, null, 0, m_ref1));
            else
                rm.addColumn(new RColumn(ctx, column, DisplayType.TableDir, null, 0, m_ref2));
        } else if (column != null && column.endsWith("_ID"))
            rm.addColumn(new RColumn(ctx, column, DisplayType.TableDir));
    }
    if (!keys.contains("DateAcct"))
        rm.addColumn(new RColumn(ctx, "DateAcct", DisplayType.Date));
    if (!keys.contains("C_Period_ID"))
        rm.addColumn(new RColumn(ctx, "C_Period_ID", DisplayType.TableDir));
    if (displayQty) {
        rm.addColumn(new RColumn(ctx, "C_UOM_ID", DisplayType.TableDir));
        rm.addColumn(new RColumn(ctx, "Qty", DisplayType.Quantity));
    }
    if (displayDocumentInfo) {
        rm.addColumn(new RColumn(ctx, "AD_Table_ID", DisplayType.TableDir));
        rm.addColumn(new RColumn(ctx, "Record_ID", DisplayType.ID));
        rm.addColumn(new RColumn(ctx, "Description", DisplayType.String));
    }
    if (PostingType == null || PostingType.length() == 0)
        rm.addColumn(new // teo_sarca, [ 1664208 ]
        RColumn(// teo_sarca, [ 1664208 ]
        ctx, // teo_sarca, [ 1664208 ]
        "PostingType", // teo_sarca, [ 1664208 ]
        DisplayType.List, RModel.TABLE_ALIAS + ".PostingType", MFactAcct.POSTINGTYPE_AD_Reference_ID, null));
    return rm;
}
Also used : RModel(org.compiere.report.core.RModel) RColumn(org.compiere.report.core.RColumn) Properties(java.util.Properties)

Example 3 with RModel

use of org.compiere.report.core.RModel in project adempiere by adempiere.

the class AcctViewer method exportExcel.

//  actionRePost
/**
	 * Export to Excel
	 */
private void exportExcel() {
    RModel model = table.getRModel();
    if (model == null) {
        return;
    }
    try {
        RModelExcelExporter exporter = new RModelExcelExporter((RModel) model);
        exporter.export(null, null);
    } catch (Exception e) {
        ADialog.error(0, this, "Error", e.getLocalizedMessage());
        if (CLogMgt.isLevelFinest())
            e.printStackTrace();
    }
}
Also used : RModelExcelExporter(org.compiere.report.core.RModelExcelExporter) RModel(org.compiere.report.core.RModel)

Example 4 with RModel

use of org.compiere.report.core.RModel in project adempiere by adempiere.

the class AcctViewerData method query.

//  getButtonRecordID
/**************************************************************************

	/**
	 *  Create Query and submit
	 *  @return Report Model
	 */
protected RModel query() {
    //  Set Where Clause
    StringBuffer whereClause = new StringBuffer();
    //  Add Organization
    if (C_AcctSchema_ID != 0)
        whereClause.append(RModel.TABLE_ALIAS).append(".C_AcctSchema_ID=").append(C_AcctSchema_ID);
    //	Posting Type Selected
    if (PostingType != null && PostingType.length() > 0) {
        if (whereClause.length() > 0)
            whereClause.append(" AND ");
        whereClause.append(RModel.TABLE_ALIAS).append(".PostingType='").append(PostingType).append("'");
    }
    //
    if (documentQuery) {
        if (whereClause.length() > 0)
            whereClause.append(" AND ");
        whereClause.append(RModel.TABLE_ALIAS).append(".AD_Table_ID=").append(AD_Table_ID).append(" AND ").append(RModel.TABLE_ALIAS).append(".Record_ID=").append(Record_ID);
    } else {
        //  get values (Queries)
        Iterator<String> it = whereInfo.values().iterator();
        while (it.hasNext()) {
            String where = (String) it.next();
            if (//  add only if not empty
            where != null && where.length() > 0) {
                if (whereClause.length() > 0)
                    whereClause.append(" AND ");
                whereClause.append(RModel.TABLE_ALIAS).append(".").append(where);
            }
        }
        if (DateFrom != null || DateTo != null) {
            if (whereClause.length() > 0)
                whereClause.append(" AND ");
            if (DateFrom != null && DateTo != null)
                whereClause.append("TRUNC(").append(RModel.TABLE_ALIAS).append(".DateAcct, 'DD') BETWEEN ").append(DB.TO_DATE(DateFrom)).append(" AND ").append(DB.TO_DATE(DateTo));
            else if (DateFrom != null)
                whereClause.append("TRUNC(").append(RModel.TABLE_ALIAS).append(".DateAcct, 'DD') >= ").append(DB.TO_DATE(DateFrom));
            else
                //  DateTo != null
                whereClause.append("TRUNC(").append(RModel.TABLE_ALIAS).append(".DateAcct, 'DD') <= ").append(DB.TO_DATE(DateTo));
        }
        //  Add Organization
        if (AD_Org_ID != 0) {
            if (whereClause.length() > 0)
                whereClause.append(" AND ");
            whereClause.append(RModel.TABLE_ALIAS).append(".AD_Org_ID=").append(AD_Org_ID);
        }
    }
    RModel rm = getRModel();
    //  Set Order By Clause
    StringBuffer orderClause = new StringBuffer();
    if (sortBy1.length() > 0) {
        RColumn col = rm.getRColumn(sortBy1);
        if (col != null)
            orderClause.append(col.getDisplaySQL());
        else
            orderClause.append(RModel.TABLE_ALIAS).append(".").append(sortBy1);
    }
    if (sortBy2.length() > 0) {
        if (orderClause.length() > 0)
            orderClause.append(",");
        RColumn col = rm.getRColumn(sortBy2);
        if (col != null)
            orderClause.append(col.getDisplaySQL());
        else
            orderClause.append(RModel.TABLE_ALIAS).append(".").append(sortBy2);
    }
    if (sortBy3.length() > 0) {
        if (orderClause.length() > 0)
            orderClause.append(",");
        RColumn col = rm.getRColumn(sortBy3);
        if (col != null)
            orderClause.append(col.getDisplaySQL());
        else
            orderClause.append(RModel.TABLE_ALIAS).append(".").append(sortBy3);
    }
    if (sortBy4.length() > 0) {
        if (orderClause.length() > 0)
            orderClause.append(",");
        RColumn col = rm.getRColumn(sortBy4);
        if (col != null)
            orderClause.append(col.getDisplaySQL());
        else
            orderClause.append(RModel.TABLE_ALIAS).append(".").append(sortBy4);
    }
    if (orderClause.length() == 0)
        orderClause.append(RModel.TABLE_ALIAS).append(".Fact_Acct_ID");
    //  Groups
    if (group1 && sortBy1.length() > 0)
        rm.setGroup(sortBy1);
    if (group2 && sortBy2.length() > 0)
        rm.setGroup(sortBy2);
    if (group3 && sortBy3.length() > 0)
        rm.setGroup(sortBy3);
    if (group4 && sortBy4.length() > 0)
        rm.setGroup(sortBy4);
    //  Totals
    rm.setFunction("AmtAcctDr", RModel.FUNCTION_SUM);
    rm.setFunction("AmtAcctCr", RModel.FUNCTION_SUM);
    rm.query(Env.getCtx(), whereClause.toString(), orderClause.toString());
    return rm;
}
Also used : RModel(org.compiere.report.core.RModel) RColumn(org.compiere.report.core.RColumn)

Example 5 with RModel

use of org.compiere.report.core.RModel in project adempiere by adempiere.

the class AcctViewerData method getRModel.

//  query
/**
	 *  Create Report Model (Columns)
	 *  @return Report Model
	 */
private RModel getRModel() {
    Properties ctx = Env.getCtx();
    RModel rm = new RModel("Fact_Acct");
    //  Add Key (Lookups)
    ArrayList<String> keys = createKeyColumns();
    int max = m_leadingColumns;
    if (max == 0)
        max = keys.size();
    for (int i = 0; i < max; i++) {
        String column = (String) keys.get(i);
        if (column != null && column.startsWith("Date"))
            rm.addColumn(new RColumn(ctx, column, DisplayType.Date));
        else if (column != null && column.endsWith("_ID"))
            rm.addColumn(new RColumn(ctx, column, DisplayType.TableDir));
    }
    //  Main Info
    rm.addColumn(new RColumn(ctx, "AmtAcctDr", DisplayType.Amount));
    rm.addColumn(new RColumn(ctx, "AmtAcctCr", DisplayType.Amount));
    if (displaySourceAmt) {
        if (!keys.contains("DateTrx"))
            rm.addColumn(new RColumn(ctx, "DateTrx", DisplayType.Date));
        rm.addColumn(new RColumn(ctx, "C_Currency_ID", DisplayType.TableDir));
        rm.addColumn(new RColumn(ctx, "AmtSourceDr", DisplayType.Amount));
        rm.addColumn(new RColumn(ctx, "AmtSourceCr", DisplayType.Amount));
        rm.addColumn(new RColumn(ctx, "Rate", DisplayType.Amount, "CASE WHEN (AmtSourceDr + AmtSourceCr) = 0 THEN 0" + " ELSE (AmtAcctDr + AmtAcctCr) / (AmtSourceDr + AmtSourceCr) END"));
    }
    //	Remaining Keys
    for (int i = max; i < keys.size(); i++) {
        String column = (String) keys.get(i);
        if (column != null && column.startsWith("Date"))
            rm.addColumn(new RColumn(ctx, column, DisplayType.Date));
        else if (column.startsWith("UserElement")) {
            if (column.indexOf('1') != -1)
                rm.addColumn(new RColumn(ctx, column, DisplayType.TableDir, null, 0, m_ref1));
            else
                rm.addColumn(new RColumn(ctx, column, DisplayType.TableDir, null, 0, m_ref2));
        } else if (column != null && column.endsWith("_ID"))
            rm.addColumn(new RColumn(ctx, column, DisplayType.TableDir));
    }
    //	Info
    if (!keys.contains("DateAcct"))
        rm.addColumn(new RColumn(ctx, "DateAcct", DisplayType.Date));
    if (!keys.contains("C_Period_ID"))
        rm.addColumn(new RColumn(ctx, "C_Period_ID", DisplayType.TableDir));
    if (displayQty) {
        rm.addColumn(new RColumn(ctx, "C_UOM_ID", DisplayType.TableDir));
        rm.addColumn(new RColumn(ctx, "Qty", DisplayType.Quantity));
    }
    if (displayDocumentInfo) {
        rm.addColumn(new RColumn(ctx, "AD_Table_ID", DisplayType.TableDir));
        rm.addColumn(new RColumn(ctx, "Record_ID", DisplayType.ID));
        rm.addColumn(new RColumn(ctx, "Description", DisplayType.String));
    }
    if (PostingType == null || PostingType.length() == 0)
        rm.addColumn(new // teo_sarca, [ 1664208 ]
        RColumn(// teo_sarca, [ 1664208 ]
        ctx, // teo_sarca, [ 1664208 ]
        "PostingType", // teo_sarca, [ 1664208 ]
        DisplayType.List, RModel.TABLE_ALIAS + ".PostingType", MFactAcct.POSTINGTYPE_AD_Reference_ID, null));
    return rm;
}
Also used : RModel(org.compiere.report.core.RModel) RColumn(org.compiere.report.core.RColumn) Properties(java.util.Properties)

Aggregations

RModel (org.compiere.report.core.RModel)7 RColumn (org.compiere.report.core.RColumn)4 Properties (java.util.Properties)2 RModelExcelExporter (org.compiere.report.core.RModelExcelExporter)2 File (java.io.File)1 Timestamp (java.sql.Timestamp)1 ArrayList (java.util.ArrayList)1 ListModelTable (org.adempiere.webui.component.ListModelTable)1 WListItemRenderer (org.adempiere.webui.component.WListItemRenderer)1 MAcctSchema (org.compiere.model.MAcctSchema)1 MAcctSchemaElement (org.compiere.model.MAcctSchemaElement)1 KeyNamePair (org.compiere.util.KeyNamePair)1 ValueNamePair (org.compiere.util.ValueNamePair)1 Listhead (org.zkoss.zul.Listhead)1 Listheader (org.zkoss.zul.Listheader)1 Listitem (org.zkoss.zul.Listitem)1
About Me
UseOf

Java Tutorials :

Simple Java RabbitMQ Example with Spring
Simple Springboot JPA Eclipeslink Example
Simple SpringBoot JPA Hibernate Example
Jackson JSON @JsonIgnore and @JsonIgnoreProperties Examples
Java Infinite recursion (StackOverflowError) Jackson solutions
Simple Java Jackson Serialize Objects to JSON and convert them back To Object
ElasticSearch 5 - Upload files using Java API in binary field Example
Java JAXB marshall unmarshall Examples from String and Stream
Java 8 forEach List and Map examples
ElasticSearch 5 Java API SearchRequestBuilder examples
Java ElasticSearch 5 examples with node index and mapping - running local
Convert String to int or Integer Java 8
Java 9 in action - JShell - Ubuntu
Java - removing invalid characters from a file name
Hello world!? or Hello Tutorial