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

org.apache.torque.util.Criteria.addJoin()
This is the way that you should add a join of two tables. For example:
AND PROJECT.PROJECT_ID=FOO.PROJECT_ID
left = PROJECT.PROJECT_ID right = FOO.PROJECT_ID @param left A String with the left side of the join. @param right A String with the right side of the join. @return A modified Criteria object.


      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

        }
        context.put ("entries", results);


      }else if (reportid==10){
        
        criteria.addJoin(LocationPeer.LOCATION_ID, DorderItemPeer.LOCATION_ID);
        criteria.addJoin(DorderPeer.DORDER_ID, DorderItemPeer.DORDER_ID);
        criteria.addJoin(DistributorPeer.DISTRIBUTOR_ID, DorderPeer.DISTRIBUTOR_ID);
        criteria.addJoin(DcontractPeer.DCONTRACT_ID, DorderPeer.DCONTRACT_ID);
        criteria.addJoin(DcontractItemPeer.DCONTRACT_ID, DcontractPeer.DCONTRACT_ID);
        criteria.addJoin(CostTypePeer.COST_TYPE_ID, DcontractItemPeer.COST_TYPE_ID);

View Full Code Here

        context.put ("entries", results);


      }else if (reportid==10){
        
        criteria.addJoin(LocationPeer.LOCATION_ID, DorderItemPeer.LOCATION_ID);
        criteria.addJoin(DorderPeer.DORDER_ID, DorderItemPeer.DORDER_ID);
        criteria.addJoin(DistributorPeer.DISTRIBUTOR_ID, DorderPeer.DISTRIBUTOR_ID);
        criteria.addJoin(DcontractPeer.DCONTRACT_ID, DorderPeer.DCONTRACT_ID);
        criteria.addJoin(DcontractItemPeer.DCONTRACT_ID, DcontractPeer.DCONTRACT_ID);
        criteria.addJoin(CostTypePeer.COST_TYPE_ID, DcontractItemPeer.COST_TYPE_ID);
        criteria.addJoin(SalesDistrictPeer.SALES_DISTRICT_ID, LocationPeer.SALES_DISTRICT_ID);

View Full Code Here


      }else if (reportid==10){
        
        criteria.addJoin(LocationPeer.LOCATION_ID, DorderItemPeer.LOCATION_ID);
        criteria.addJoin(DorderPeer.DORDER_ID, DorderItemPeer.DORDER_ID);
        criteria.addJoin(DistributorPeer.DISTRIBUTOR_ID, DorderPeer.DISTRIBUTOR_ID);
        criteria.addJoin(DcontractPeer.DCONTRACT_ID, DorderPeer.DCONTRACT_ID);
        criteria.addJoin(DcontractItemPeer.DCONTRACT_ID, DcontractPeer.DCONTRACT_ID);
        criteria.addJoin(CostTypePeer.COST_TYPE_ID, DcontractItemPeer.COST_TYPE_ID);
        criteria.addJoin(SalesDistrictPeer.SALES_DISTRICT_ID, LocationPeer.SALES_DISTRICT_ID);
        criteria.addJoin(SalesAreaPeer.SALES_AREA_ID, SalesDistrictPeer.SALES_AREA_ID);

View Full Code Here

      }else if (reportid==10){
        
        criteria.addJoin(LocationPeer.LOCATION_ID, DorderItemPeer.LOCATION_ID);
        criteria.addJoin(DorderPeer.DORDER_ID, DorderItemPeer.DORDER_ID);
        criteria.addJoin(DistributorPeer.DISTRIBUTOR_ID, DorderPeer.DISTRIBUTOR_ID);
        criteria.addJoin(DcontractPeer.DCONTRACT_ID, DorderPeer.DCONTRACT_ID);
        criteria.addJoin(DcontractItemPeer.DCONTRACT_ID, DcontractPeer.DCONTRACT_ID);
        criteria.addJoin(CostTypePeer.COST_TYPE_ID, DcontractItemPeer.COST_TYPE_ID);
        criteria.addJoin(SalesDistrictPeer.SALES_DISTRICT_ID, LocationPeer.SALES_DISTRICT_ID);
        criteria.addJoin(SalesAreaPeer.SALES_AREA_ID, SalesDistrictPeer.SALES_AREA_ID);
        criteria.addJoin(ProductPeer.PRODUCT_ID, DorderPeer.PRODUCT_ID);

View Full Code Here

        
        criteria.addJoin(LocationPeer.LOCATION_ID, DorderItemPeer.LOCATION_ID);
        criteria.addJoin(DorderPeer.DORDER_ID, DorderItemPeer.DORDER_ID);
        criteria.addJoin(DistributorPeer.DISTRIBUTOR_ID, DorderPeer.DISTRIBUTOR_ID);
        criteria.addJoin(DcontractPeer.DCONTRACT_ID, DorderPeer.DCONTRACT_ID);
        criteria.addJoin(DcontractItemPeer.DCONTRACT_ID, DcontractPeer.DCONTRACT_ID);
        criteria.addJoin(CostTypePeer.COST_TYPE_ID, DcontractItemPeer.COST_TYPE_ID);
        criteria.addJoin(SalesDistrictPeer.SALES_DISTRICT_ID, LocationPeer.SALES_DISTRICT_ID);
        criteria.addJoin(SalesAreaPeer.SALES_AREA_ID, SalesDistrictPeer.SALES_AREA_ID);
        criteria.addJoin(ProductPeer.PRODUCT_ID, DorderPeer.PRODUCT_ID);
        criteria.addJoin(ProjectPeer.PROJECT_ID, DorderPeer.PROJECT_ID);

View Full Code Here

        criteria.addJoin(LocationPeer.LOCATION_ID, DorderItemPeer.LOCATION_ID);
        criteria.addJoin(DorderPeer.DORDER_ID, DorderItemPeer.DORDER_ID);
        criteria.addJoin(DistributorPeer.DISTRIBUTOR_ID, DorderPeer.DISTRIBUTOR_ID);
        criteria.addJoin(DcontractPeer.DCONTRACT_ID, DorderPeer.DCONTRACT_ID);
        criteria.addJoin(DcontractItemPeer.DCONTRACT_ID, DcontractPeer.DCONTRACT_ID);
        criteria.addJoin(CostTypePeer.COST_TYPE_ID, DcontractItemPeer.COST_TYPE_ID);
        criteria.addJoin(SalesDistrictPeer.SALES_DISTRICT_ID, LocationPeer.SALES_DISTRICT_ID);
        criteria.addJoin(SalesAreaPeer.SALES_AREA_ID, SalesDistrictPeer.SALES_AREA_ID);
        criteria.addJoin(ProductPeer.PRODUCT_ID, DorderPeer.PRODUCT_ID);
        criteria.addJoin(ProjectPeer.PROJECT_ID, DorderPeer.PROJECT_ID);

View Full Code Here

        criteria.addJoin(DorderPeer.DORDER_ID, DorderItemPeer.DORDER_ID);
        criteria.addJoin(DistributorPeer.DISTRIBUTOR_ID, DorderPeer.DISTRIBUTOR_ID);
        criteria.addJoin(DcontractPeer.DCONTRACT_ID, DorderPeer.DCONTRACT_ID);
        criteria.addJoin(DcontractItemPeer.DCONTRACT_ID, DcontractPeer.DCONTRACT_ID);
        criteria.addJoin(CostTypePeer.COST_TYPE_ID, DcontractItemPeer.COST_TYPE_ID);
        criteria.addJoin(SalesDistrictPeer.SALES_DISTRICT_ID, LocationPeer.SALES_DISTRICT_ID);
        criteria.addJoin(SalesAreaPeer.SALES_AREA_ID, SalesDistrictPeer.SALES_AREA_ID);
        criteria.addJoin(ProductPeer.PRODUCT_ID, DorderPeer.PRODUCT_ID);
        criteria.addJoin(ProjectPeer.PROJECT_ID, DorderPeer.PROJECT_ID);
    
        criteria.addSelectColumn("SUM("  + DorderItemPeer.UNSOLD_QTY + ")");

View Full Code Here

        criteria.addJoin(DistributorPeer.DISTRIBUTOR_ID, DorderPeer.DISTRIBUTOR_ID);
        criteria.addJoin(DcontractPeer.DCONTRACT_ID, DorderPeer.DCONTRACT_ID);
        criteria.addJoin(DcontractItemPeer.DCONTRACT_ID, DcontractPeer.DCONTRACT_ID);
        criteria.addJoin(CostTypePeer.COST_TYPE_ID, DcontractItemPeer.COST_TYPE_ID);
        criteria.addJoin(SalesDistrictPeer.SALES_DISTRICT_ID, LocationPeer.SALES_DISTRICT_ID);
        criteria.addJoin(SalesAreaPeer.SALES_AREA_ID, SalesDistrictPeer.SALES_AREA_ID);
        criteria.addJoin(ProductPeer.PRODUCT_ID, DorderPeer.PRODUCT_ID);
        criteria.addJoin(ProjectPeer.PROJECT_ID, DorderPeer.PROJECT_ID);
    
        criteria.addSelectColumn("SUM("  + DorderItemPeer.UNSOLD_QTY + ")");
        criteria.addSelectColumn("SUM("  + DorderItemPeer.SHIPPED_QTY + " * "  + DorderPeer.UNIT_PRICE + ")");

View Full Code Here

        criteria.addJoin(DcontractPeer.DCONTRACT_ID, DorderPeer.DCONTRACT_ID);
        criteria.addJoin(DcontractItemPeer.DCONTRACT_ID, DcontractPeer.DCONTRACT_ID);
        criteria.addJoin(CostTypePeer.COST_TYPE_ID, DcontractItemPeer.COST_TYPE_ID);
        criteria.addJoin(SalesDistrictPeer.SALES_DISTRICT_ID, LocationPeer.SALES_DISTRICT_ID);
        criteria.addJoin(SalesAreaPeer.SALES_AREA_ID, SalesDistrictPeer.SALES_AREA_ID);
        criteria.addJoin(ProductPeer.PRODUCT_ID, DorderPeer.PRODUCT_ID);
        criteria.addJoin(ProjectPeer.PROJECT_ID, DorderPeer.PROJECT_ID);
    
        criteria.addSelectColumn("SUM("  + DorderItemPeer.UNSOLD_QTY + ")");
        criteria.addSelectColumn("SUM("  + DorderItemPeer.SHIPPED_QTY + " * "  + DorderPeer.UNIT_PRICE + ")");
        criteria.addSelectColumn("SUM("  + DorderItemPeer.SHIPPED_QTY + " * "  + DorderPeer.UNIT_WEIGHT + ")");

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

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.