Examples with MQuery org.compiere.model.MQuery used on opensource projects

Example 61 with MQuery

use of org.compiere.model.MQuery in project adempiere by adempiere.

the class ADServiceImpl method createQuery.

/*
	public WindowTabDataDocument getWindowTabData(int WindowNo, int AD_Window_ID, int AD_Menu_ID, int TabNo, int PrevTabNo, int PrevRecNo, boolean getData)	{
		return getWindowTabData(WindowNo, AD_Window_ID, AD_Menu_ID, TabNo, PrevTabNo, PrevRecNo, getData, 0, -1); 
	}
	
    public WindowTabDataDocument getWindowTabData(int WindowNo, int AD_Window_ID, int AD_Menu_ID, int TabNo, int PrevTabNo, int PrevRecNo, boolean getData, int RowStart, int RowCount)  
    {
    	return null; //TODO
    	
    }*/
private MQuery createQuery(String table_name, DataRow dr) {
    MQuery q = new MQuery(table_name);
    DataField[] df = dr.getFieldArray();
    for (int i = 0; i < df.length; i++) {
        if (df[i].getVal() != null && df[i].getVal().length() > 0) {
            q.addRestriction("UPPER(" + df[i].getColumn() + ")", MQuery.LIKE, df[i].getVal().toUpperCase(), df[i].getColumn(), df[i].getVal().toUpperCase());
        }
    }
    return q;
}

Example 62 with MQuery

use of org.compiere.model.MQuery in project adempiere by adempiere.

the class Process method startFinReport.

//	startCheckPrint
/**
	 *	Start Financial Report.
	 *  @param pi Process Info
	 *  @return true if OK
	 */
public static ReportEngine startFinReport(ProcessInfo pi) {
    int AD_Client_ID = Env.getAD_Client_ID(Env.getCtx());
    //  Create Query from Parameters
    String TableName = pi.getAD_Process_ID() == 202 ? "T_Report" : "T_ReportStatement";
    MQuery query = MQuery.get(Env.getCtx(), pi.getAD_PInstance_ID(), TableName);
    //	Get PrintFormat
    MPrintFormat format = (MPrintFormat) pi.getTransientObject();
    if (format == null)
        format = (MPrintFormat) pi.getSerializableObject();
    if (format == null) {
        log.log(Level.SEVERE, "startFinReport - No PrintFormat");
        return null;
    }
    PrintInfo info = new PrintInfo(pi);
    ReportEngine re = new ReportEngine(Env.getCtx(), format, query, info);
    //new Viewer(re);
    return re;
}

Example 63 with MQuery

use of org.compiere.model.MQuery in project adempiere by adempiere.

the class MRPDetailed method zoom.

/**
	 * Zoom for any Document
	 */
public void zoom() {
    log.info("InfoMRPDetailed.zoom");
    Integer PP_MPR_ID = getSelectedRowKey();
    AD_Window_ID = 0;
    if (PP_MPR_ID == null)
        return;
    query = null;
    MPPMRP mrp = new MPPMRP(getCtx(), PP_MPR_ID.intValue(), null);
    String ordertype = mrp.getOrderType();
    if (X_PP_MRP.ORDERTYPE_PurchaseOrder.equals(ordertype)) {
        AD_Window_ID = MTable.get(getCtx(), I_C_Order.Table_ID).getPO_Window_ID();
        query = new MQuery(I_C_Order.Table_Name);
        query.addRestriction(I_C_Order.COLUMNNAME_C_Order_ID, MQuery.EQUAL, mrp.getC_Order_ID());
    } else if (X_PP_MRP.ORDERTYPE_SalesOrder.equals(ordertype)) {
        AD_Window_ID = MTable.get(getCtx(), I_C_Order.Table_ID).getAD_Window_ID();
        query = new MQuery(I_C_Order.Table_Name);
        query.addRestriction(I_C_Order.COLUMNNAME_C_Order_ID, MQuery.EQUAL, mrp.getC_Order_ID());
    } else if (X_PP_MRP.ORDERTYPE_ManufacturingOrder.equals(ordertype)) {
        AD_Window_ID = MTable.get(getCtx(), I_PP_Order.Table_ID).getAD_Window_ID();
        query = new MQuery(I_PP_Order.Table_Name);
        query.addRestriction(I_PP_Order.COLUMNNAME_PP_Order_ID, MQuery.EQUAL, mrp.getPP_Order_ID());
    } else if (X_PP_MRP.ORDERTYPE_MaterialRequisition.equals(ordertype)) {
        AD_Window_ID = MTable.get(getCtx(), I_M_Requisition.Table_ID).getAD_Window_ID();
        ;
        query = new MQuery(I_M_Requisition.Table_Name);
        query.addRestriction(I_M_Requisition.COLUMNNAME_M_Requisition_ID, MQuery.EQUAL, mrp.getM_Requisition_ID());
    } else if (X_PP_MRP.ORDERTYPE_Forecast.equals(ordertype)) {
        AD_Window_ID = MTable.get(getCtx(), I_M_Forecast.Table_ID).getAD_Window_ID();
        ;
        query = new MQuery(I_M_Forecast.Table_Name);
        query.addRestriction(I_M_Forecast.COLUMNNAME_M_Forecast_ID, MQuery.EQUAL, mrp.getM_Forecast_ID());
    }
    if (X_PP_MRP.ORDERTYPE_DistributionOrder.equals(ordertype)) {
        AD_Window_ID = MTable.get(getCtx(), I_DD_Order.Table_ID).getAD_Window_ID();
        query = new MQuery(MDDOrder.Table_Name);
        query.addRestriction(MDDOrder.COLUMNNAME_DD_Order_ID, MQuery.EQUAL, mrp.getDD_Order_ID());
    }
    if (AD_Window_ID == 0)
        return;
    log.info("AD_WindowNo " + AD_Window_ID);
    zoom(AD_Window_ID, query);
}

Example 64 with MQuery

use of org.compiere.model.MQuery in project adempiere by adempiere.

the class WPrintDocument method print.

public void print(PO document, String printFormantName, int windowNo) {
    boolean retValue = true;
    if (FDialog.ask(windowNo, SessionManager.getAppDesktop().getComponent(), "PrintShipments")) {
        do {
            try {
                String keyColumnName = document.get_KeyColumns()[0];
                MPrintFormat format = MPrintFormat.get(Env.getCtx(), MPrintFormat.getPrintFormat_ID(printFormantName, document.get_Table_ID(), 0), false);
                MQuery query = new MQuery(document.get_TableName());
                query.addRestriction(keyColumnName, MQuery.EQUAL, document.get_ValueAsInt(keyColumnName));
                //	Engine
                PrintInfo info = new PrintInfo(document.get_TableName(), document.get_Table_ID(), document.get_ValueAsInt(keyColumnName));
                ReportEngine re = new ReportEngine(Env.getCtx(), format, query, info);
                if (re != null) {
                    SimplePDFViewer win = new SimplePDFViewer(printFormantName, new FileInputStream(re.getPDF()));
                    SessionManager.getAppDesktop().showWindow(win, "center");
                }
            } catch (Exception e) {
            } finally {
                retValue = FDialog.ask(windowNo, SessionManager.getAppDesktop().getComponent(), Msg.getMsg(Env.getCtx(), "PrintoutOK?"));
            }
        } while (!retValue);
    }
}

Example 65 with MQuery

use of org.compiere.model.MQuery in project adempiere by adempiere.

the class ReleaseInOutBound method getReportEngine.

/*
	 * get the a Report Engine Instance using the view table 
	 * @param tableName
	 */
private ReportEngine getReportEngine(String formatName, String tableName, int recordId) {
    // Get Format & Data
    int formatId = MPrintFormat.getPrintFormat_ID(formatName, MTable.getTable_ID(tableName), getAD_Client_ID());
    MPrintFormat format = MPrintFormat.get(getCtx(), formatId, true);
    if (format == null) {
        addLog("@NotFound@ @AD_PrintFormat_ID@");
        return null;
    }
    // query
    MQuery query = new MQuery(tableName);
    query.addRestriction(MDDOrder.COLUMNNAME_DD_Order_ID, MQuery.EQUAL, recordId);
    // Engine
    PrintInfo info = new PrintInfo(tableName, MTable.getTable_ID(tableName), recordId);
    ReportEngine reportEngine = new ReportEngine(getCtx(), format, query, info);
    return reportEngine;
}