Package org.ofbiz.entity.condition

Examples of org.ofbiz.entity.condition.EntityExpr

145
146
147
148
149
150
151
152
153
154
155
156
    dve.addMemberEntity("ProductFeatureAppl", "ProductFeatureAppl");
    dve.addViewLink("ProductFeature", "ProductFeatureAppl", Boolean.FALSE, UtilMisc.toList(new ModelKeyMap("productFeatureId", "productFeatureId")));
    dve.addAlias("ProductFeatureAppl", "productId", null, null, null, null, null);
    
    EntityCondition condition = new EntityConditionList(UtilMisc.toList(
        new EntityExpr("productFeatureTypeId", EntityOperator.EQUALS, productFeatureTypeId),
        new EntityExpr("productId", EntityOperator.EQUALS, productId)),
        EntityOperator.AND);
       
      List pfCol = EntityHelper.findByCondition( delegator, dve, condition, null );
       
        GenericValue[] pfGvs = (GenericValue[]) pfCol.toArray(new GenericValue[0]);
View Full Code Here
101
102
103
104
105
106
107
108
109
110
111
        EntityCondition condition = null;

        if ((accountId != null) && (accountId.length() > 0) &&
                (!accountId.equals("null"))) {
            condition = new EntityExpr( "accountId", EntityOperator.EQUALS, accountId);
        }

        try {
            return SecurityWrapper.findByCondition("Contact", condition,
                orderBy, userInfo,
View Full Code Here
126
127
128
129
130
131
132
133
134
135
136
                //find contacts for role
                Vector contactFields = new Vector();
                Vector contactValueVector = new Vector();
                Vector contactOps = new Vector();

                contactFields.add(new EntityExpr("roleId",
                        EntityOperator.EQUALS, roleId));

                List contacts = delegator.findByAnd("Contact", contactFields,
                        null);
                GenericValue[] contactValues = (GenericValue[]) contacts.toArray(new GenericValue[0]);
View Full Code Here
142
143
144
145
146
147
148
  }

  public void addCondition( String entityAlias, String attributeAlias, String attributeName, EntityComparisonOperator operator, Object value )
  {
    checkAttribute( entityAlias, attributeName, attributeAlias);
    entityConditions.add( new EntityExpr( attributeAlias, operator, value));
  }
View Full Code Here
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
    dve.addAlias("EntityAccess", "partyEntityType", null, null, null, null, null);
    dve.addAlias("EntityAccess", "entity", null, null, null, null, null);
    dve.addAlias("TeamMember", "tmPartyId", "partyId", null, null, null, null);
    
    EntityCondition condition = new EntityConditionList(UtilMisc.toList(
        new EntityExpr("entity", EntityOperator.EQUALS, "Deal"),
             new EntityExpr("partyEntityType", EntityOperator.EQUALS, "Team"),
        new EntityExpr("tmPartyId", EntityOperator.EQUALS, partyId),
        new EntityExpr("projectedCloseDate", EntityOperator.LESS_THAN_EQUAL_TO, endDate),
        new EntityExpr("projectedCloseDate", EntityOperator.GREATER_THAN_EQUAL_TO, beginDate),
        new EntityExpr("isInForecast", EntityOperator.EQUALS, "1")
        ),
        EntityOperator.AND);
               
    return EntityHelper.findByCondition( delegator, dve, condition, UtilMisc.toList("projectedCloseDate") );
    }
View Full Code Here
463
464
465
466
467
468
469
470
471
472
473
474
     
      if ( isOuterJoin )
      {
        queryInfo.addAlias("Address", "isPrimary", "isPrimary");
        queryInfo.addAlias("Address", "addressId", "addressId");
        queryInfo.addCondition( new EntityConditionList( UtilMisc.toList( new EntityExpr("isPrimary", EntityOperator.EQUALS, "Y"),
                      new EntityExpr("addressId", EntityOperator.EQUALS, null)), EntityOperator.OR));
      }
      else
        queryInfo.addCondition("Address", "isPrimary", EntityOperator.EQUALS, "Y");

        } else {
View Full Code Here
71
72
73
74
75
76
77
78
79
80
81
    dve.addMemberEntity("Code", "Code");
    dve.addViewLink("RoleType", "Code", Boolean.FALSE, UtilMisc.toList(new ModelKeyMap("roleTypeId", "codeId")));
    dve.addAlias("Code", "codeTypeId", null, null, null, null, null);
    
    EntityCondition condition = new EntityConditionList(UtilMisc.toList(
        new EntityExpr("codeTypeId", EntityOperator.EQUALS, "ROLE_TYPE_SFA")),
        EntityOperator.AND);
       
        try {
            return EntityHelper.getPrimaryGVLFromDynamicGVL(delegator, EntityHelper.findByCondition( delegator, dve, condition, orderBy ), "RoleType");
        } catch (Exception e) {
View Full Code Here
498
499
500
501
502
503
504
505
506
507
508
509
    dve.addMemberEntity("UiEntity", "UiEntity");
    dve.addViewLink("UiAttribute", "UiEntity", Boolean.FALSE, UtilMisc.toList(new ModelKeyMap("entityId", "entityId")));
    dve.addAlias("UiEntity", "entityName", null, null, null, null, null);
    
    EntityCondition condition = new EntityConditionList(UtilMisc.toList(
        new EntityExpr("attributeName", EntityOperator.EQUALS, searchAttribName),
        new EntityExpr("entityName", EntityOperator.EQUALS, searchEntityName)),
        EntityOperator.AND);
       
        List queryGVL = EntityHelper.findByCondition( delegator, dve, condition, null );

        if (queryGVL.size() == 0) {
View Full Code Here
112
113
114
115
116
117
118
119
120
121
122
      dve.addMemberEntity("UiScreenSectionEntity", "UiScreenSectionEntity");
      dve.addViewLink("UiAttribute", "UiScreenSectionEntity", Boolean.FALSE, UtilMisc.toList(new ModelKeyMap("entityId", "entityId")));
      dve.addAlias("UiScreenSectionEntity", "sectionId", null, null, null, null, null);
    
      EntityCondition condition = new EntityConditionList(UtilMisc.toList(
          new EntityExpr("sectionId", EntityOperator.EQUALS, sectionId)),
          EntityOperator.AND);

            try {
                return EntityHelper.findByCondition( delegator, dve, condition, orderBy);
            } catch (GenericEntityException e) {
View Full Code Here
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
     */
    public static List findByAnd(String entity, List entityExpressions,
        List orderBy, UserInfo userInfo, SecurityLinkInfo securityInfo,
        GenericDelegator delegator, String securityType) throws GenericEntityException {
        HashMap equalsMap = new HashMap();
        EntityExpr entityExpr = null;
        QueryInfo queryInfo = new QueryInfo( delegator, entity);

        //convert existing expressions into AND clauses.
        for (int i = 0; i < entityExpressions.size(); i++) {
            entityExpr = (EntityExpr) entityExpressions.get(i);

            Object lhs = (Object) entityExpr.getLhs();
            Object rhs = (Object) entityExpr.getRhs();
      EntityComparisonOperator op = (EntityComparisonOperator) entityExpr.getOperator();

            if (lhs instanceof EntityAttribute &&
                    rhs instanceof EntityAttribute) {
                lhs = (EntityAttribute) lhs;
                rhs = (EntityAttribute) rhs;
View Full Code Here
TOP

Related Classes of org.ofbiz.entity.condition.EntityExpr

  • com.sourcetap.sfa.lead.LeadHelper
  • com.sourcetap.sfa.opportunity.OpportunityHelper
  • com.sourcetap.sfa.product.ProductHelper
  • com.sourcetap.sfa.security.SecurityWrapper
  • com.sourcetap.sfa.ui.UIQuery
  • org.ofbiz.accounting.invoice.InvoiceWorker
  • org.ofbiz.accounting.payment.BillingAccountWorker
  • org.ofbiz.accounting.payment.PaymentGatewayServices
  • org.ofbiz.accounting.tax.TaxAuthorityServices
  • org.ofbiz.common.FindServices
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.