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

Example 11 with Query

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

the class MHRPaySelectionCheck method get.

//	getOfPayment
/**************************************************************************
	 *  Payroll Get Checks of Payment Selection
	 *
	 *	@param ctx Context
	 *  @param HR_PaySelection_ID Payment Selection
	 *  @param PaymentRule Payment Rule
	 *  @param startDocumentNo start document no
	 *	@param trxName transaction
	 *  @return array of checks
	 */
public static List<MHRPaySelectionCheck> get(Properties ctx, int HR_PaySelection_ID, String PaymentRule, int startDocumentNo, String trxName) {
    s_log.fine("HR_PaySelection_ID=" + HR_PaySelection_ID + ", PaymentRule=" + PaymentRule + ", startDocumentNo=" + startDocumentNo);
    final String where = I_HR_PaySelectionCheck.COLUMNNAME_HR_PaySelection_ID + "=? AND " + I_HR_PaySelectionCheck.COLUMNNAME_PaymentRule + "=?";
    List<MHRPaySelectionCheck> pscs = new Query(ctx, I_HR_PaySelectionCheck.Table_Name, where, trxName).setClient_ID().setParameters(HR_PaySelection_ID, PaymentRule).list();
    int docNo = startDocumentNo;
    for (MHRPaySelectionCheck psc : pscs) {
        psc.setDocumentNo(String.valueOf(docNo++));
    }
    return pscs;
}

Example 12 with Query

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

the class MHRPayroll method getByValue.

/**
     * Get payroll by search key
     * @param ctx
     * @param payrollValue
     * @return
     */
public static MHRPayroll getByValue(Properties ctx, String payrollValue) {
    if (Util.isEmpty(payrollValue, true))
        return null;
    int clientId = Env.getAD_Client_ID(ctx);
    final String key = clientId + "#" + payrollValue;
    MHRPayroll payroll = payrollCacheValues.get(key);
    if (payroll != null && payroll.get_ID() > 0)
        return payroll;
    payroll = new Query(ctx, Table_Name, MHRPayroll.COLUMNNAME_Value + "=?", null).setClient_ID().setParameters(payrollValue).setOnlyActiveRecords(true).first();
    if (payroll != null && payroll.get_ID() > 0) {
        payrollCacheValues.put(key, payroll);
        payrollCacheIds.put(payroll.get_ID(), payroll);
    }
    return payroll;
}

Example 13 with Query

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

the class MHRPayroll method getPeriods.

/**
     * get period list based on range dates
     * @param from
     * @param to
     * @return
     */
public List<MHRPeriod> getPeriods(Timestamp from, Timestamp to) {
    StringBuilder where = new StringBuilder();
    where.append(COLUMNNAME_HR_Payroll_ID).append("=? AND ");
    where.append(MHRPeriod.COLUMNNAME_StartDate).append(">=?  AND  ");
    where.append(MHRPeriod.COLUMNNAME_EndDate).append("<=?");
    return new Query(getCtx(), MHRPeriod.Table_Name, where.toString(), get_TrxName()).setClient_ID().setParameters(getHR_Payroll_ID(), from, to).list();
}

Example 14 with Query

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

the class MHRPayroll method getPeriodByPeriodNo.

/**
     * Get HR period based on year and period no
     * @param year
     * @param periodNo
     * @return HR Period instance
     */
public MHRPeriod getPeriodByPeriodNo(String year, int periodNo) {
    StringBuilder where = new StringBuilder();
    // SELECT  * FROM HR_Period WHERE HR_Payroll_ID = ? AND PeriodNo=? AND
    // EXISTS (SELECT 1 FROM C_Period period INNER JOIN C_Year year ON (period.C_Year_ID=year.C_Year_ID)
    // WHERE period.C_Period_ID=HR_Period.C_Period_ID AND year.FiscalYear = ?)
    where.append(COLUMNNAME_HR_Payroll_ID).append("=? AND ").append(MHRPeriod.COLUMNNAME_PeriodNo).append("=? AND ").append("EXISTS (SELECT 1 FROM ").append(X_C_Period.Table_Name).append(" period ").append(" INNER JOIN ").append(X_C_Year.Table_Name).append(" year ON (period.").append(X_C_Period.COLUMNNAME_C_Year_ID).append("=").append("year.").append(X_C_Year.COLUMNNAME_C_Year_ID).append(") WHERE period.").append(X_C_Period.COLUMNNAME_C_Period_ID).append("=").append(MHRPeriod.Table_Name).append(".").append(MHRPeriod.COLUMNNAME_C_Period_ID).append(" AND year.").append(X_C_Year.COLUMNNAME_FiscalYear).append("=?)");
    return new Query(getCtx(), MHRPeriod.Table_Name, where.toString(), get_TrxName()).setClient_ID().setParameters(getHR_Payroll_ID(), periodNo, year).firstOnly();
}

Example 15 with Query

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

the class MHRLeaveAssign method getByLeaveType.

public static MHRLeaveAssign getByLeaveType(MHRLeaveType leaveType) {
    StringBuilder whereClause = new StringBuilder();
    whereClause.append(COLUMNNAME_HR_LeaveType_ID).append("=?");
    return new Query(leaveType.getCtx(), Table_Name, whereClause.toString(), leaveType.get_TrxName()).setClient_ID().setParameters(leaveType.getHR_LeaveType_ID()).first();
}