Package org.apache.torque.util

Examples of org.apache.torque.util.Criteria.addJoin()

135
136
137
138
139
140
141
142
143
144
145
            throws Exception
    {
        Criteria criteria = new Criteria();
        criteria.add(RolePermissionPeer.ROLE_ID,
                ((TurbineRole) role).getPrimaryKey());
        criteria.addJoin(RolePermissionPeer.PERMISSION_ID,
                PermissionPeer.PERMISSION_ID);
        return retrieveSet(criteria);
    }

    /**
 
View Full Code Here
132
133
134
135
136
137
138
139
140
141
142
        Criteria criteria = new Criteria();
        criteria.add(UserGroupRolePeer.USER_ID,
                ((Persistent) user).getPrimaryKey());
        criteria.add(UserGroupRolePeer.GROUP_ID,
                ((Persistent) group).getPrimaryKey());
        criteria.addJoin(UserGroupRolePeer.ROLE_ID, RolePeer.ROLE_ID);
        return retrieveSet(criteria);
    }

    /**
     * Issues a select based on a criteria.
View Full Code Here
347
348
349
350
351
352
353
354
355
356
357
    /** Build a Criteria object from an ObjectKey */
    public static Criteria buildCriteria(ObjectKey pk)
    {
        Criteria criteria = new Criteria();
        criteria.add(PORTLET_ID, pk);
        criteria.addJoin(PORTLET_MEDIA_ID, MEDIA_ID);
        return criteria;
    }
    /** Build a Criteria object from the data object for this peer */
    public static Criteria buildCriteria(BasePortletEntry obj)
    {
View Full Code Here
119
120
121
122
123
124
125
126
127
128
129
      distribcrit.addAscendingOrderByColumn(DistributorPeer.DISTRIBUTOR_DISPLAY);
      context.put("distributors", DistributorPeer.doSelect(distribcrit));

      Criteria saldicrit = new Criteria();
      saldicrit.add(SalesDistrictPeer.SALES_DISTRICT_ID, 999, Criteria.GREATER_THAN);
      saldicrit.addJoin(SalesAreaPeer.SALES_AREA_ID, SalesDistrictPeer.SALES_AREA_ID);
      saldicrit.addAscendingOrderByColumn(SalesAreaPeer.SALES_AREA_NAME);
      saldicrit.addAscendingOrderByColumn(SalesDistrictPeer.SALES_DISTRICT_NAME);
      context.put("salesdistricts", SalesDistrictPeer.doSelect(saldicrit));

View Full Code Here
74
75
76
77
78
79
80
81
82
83
84
            context.put("contracts", DcontractPeer.doSelect(criteria));

      Criteria loccrit = new Criteria();
      loccrit.add(LocationPeer.DISTRIBUTOR_ID, myId);
      loccrit.add(LocationPeer.STATUS, 30, Criteria.EQUAL);
      loccrit.addJoin(SalesDistrictPeer.SALES_DISTRICT_ID, LocationPeer.SALES_DISTRICT_ID);
      loccrit.addAscendingOrderByColumn(SalesDistrictPeer.SALES_DISTRICT_NAME);
      loccrit.addAscendingOrderByColumn(LocationPeer.LOCATION_DISPLAY);
      context.put("locations", LocationPeer.doSelect(loccrit));

            return true;
View Full Code Here
74
75
76
77
78
79
80
81
82
83
84
      context.put("entry", entry);

      Criteria orditemcrit = new Criteria();
      orditemcrit.add(DorderItemPeer.DORDER_ID, entry.getDorderId());

      orditemcrit.addJoin(LocationPeer.LOCATION_ID, DorderItemPeer.LOCATION_ID);
      orditemcrit.addJoin(SalesDistrictPeer.SALES_DISTRICT_ID, LocationPeer.SALES_DISTRICT_ID);

      orditemcrit.addAscendingOrderByColumn(SalesDistrictPeer.SALES_DISTRICT_NAME);
      orditemcrit.addAscendingOrderByColumn(LocationPeer.LOCATION_DISPLAY);
      context.put("entryitems", DorderItemPeer.doSelect(orditemcrit));
View Full Code Here
75
76
77
78
79
80
81
82
83
84
85
      Criteria orditemcrit = new Criteria();
      orditemcrit.add(DorderItemPeer.DORDER_ID, entry.getDorderId());

      orditemcrit.addJoin(LocationPeer.LOCATION_ID, DorderItemPeer.LOCATION_ID);
      orditemcrit.addJoin(SalesDistrictPeer.SALES_DISTRICT_ID, LocationPeer.SALES_DISTRICT_ID);

      orditemcrit.addAscendingOrderByColumn(SalesDistrictPeer.SALES_DISTRICT_NAME);
      orditemcrit.addAscendingOrderByColumn(LocationPeer.LOCATION_DISPLAY);
      context.put("entryitems", DorderItemPeer.doSelect(orditemcrit));
View Full Code Here
78
79
80
81
82
83
84
85
86
87
88
//      context.put("entryitems", DorderItemPeer.doSelect(orditemcrit));

      Criteria orditemcrit = new Criteria();
      orditemcrit.add(DorderItemPeer.DORDER_ID, entry.getDorderId());

      orditemcrit.addJoin(LocationPeer.LOCATION_ID, DorderItemPeer.LOCATION_ID);
      orditemcrit.addJoin(SalesDistrictPeer.SALES_DISTRICT_ID, LocationPeer.SALES_DISTRICT_ID);

      orditemcrit.addAscendingOrderByColumn(SalesDistrictPeer.SALES_DISTRICT_NAME);
      orditemcrit.addAscendingOrderByColumn(LocationPeer.LOCATION_DISPLAY);
      context.put("entryitems", DorderItemPeer.doSelect(orditemcrit));
View Full Code Here
79
80
81
82
83
84
85
86
87
88
89
      Criteria orditemcrit = new Criteria();
      orditemcrit.add(DorderItemPeer.DORDER_ID, entry.getDorderId());

      orditemcrit.addJoin(LocationPeer.LOCATION_ID, DorderItemPeer.LOCATION_ID);
      orditemcrit.addJoin(SalesDistrictPeer.SALES_DISTRICT_ID, LocationPeer.SALES_DISTRICT_ID);

      orditemcrit.addAscendingOrderByColumn(SalesDistrictPeer.SALES_DISTRICT_NAME);
      orditemcrit.addAscendingOrderByColumn(LocationPeer.LOCATION_DISPLAY);
      context.put("entryitems", DorderItemPeer.doSelect(orditemcrit));
View Full Code Here
78
79
80
81
82
83
84
85
86
87
88
//      context.put("entryitems", DorderItemPeer.doSelect(orditemcrit));

      Criteria orditemcrit = new Criteria();
      orditemcrit.add(DorderItemPeer.DORDER_ID, entry.getDorderId());

      orditemcrit.addJoin(LocationPeer.LOCATION_ID, DorderItemPeer.LOCATION_ID);
      orditemcrit.addJoin(SalesDistrictPeer.SALES_DISTRICT_ID, LocationPeer.SALES_DISTRICT_ID);

      orditemcrit.addAscendingOrderByColumn(SalesDistrictPeer.SALES_DISTRICT_NAME);
      orditemcrit.addAscendingOrderByColumn(LocationPeer.LOCATION_DISPLAY);
      context.put("entryitems", DorderItemPeer.doSelect(orditemcrit));
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. 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.