1 package org.campware.cream.om; 2 3 import java.math.BigDecimal ; 4 import java.sql.Connection ; 5 import java.sql.SQLException ; 6 import java.util.ArrayList ; 7 import java.util.Date ; 8 import java.util.Iterator ; 9 import java.util.LinkedList ; 10 import java.util.List ; 11 12 import org.apache.torque.NoRowsException; 13 import org.apache.torque.TooManyRowsException; 14 import org.apache.torque.Torque; 15 import org.apache.torque.TorqueException; 16 import org.apache.torque.map.MapBuilder; 17 import org.apache.torque.map.TableMap; 18 import org.apache.torque.om.DateKey; 19 import org.apache.torque.om.NumberKey; 20 import org.apache.torque.om.StringKey; 21 import org.apache.torque.om.ObjectKey; 22 import org.apache.torque.om.SimpleKey; 23 import org.apache.torque.util.BasePeer; 24 import org.apache.torque.util.Criteria; 25 26 import com.workingdogs.village.DataSetException; 27 import com.workingdogs.village.QueryDataSet; 28 import com.workingdogs.village.Record; 29 30 import org.campware.cream.om.map.*; 32 33 34 35 36 37 43 public abstract class BaseProductPeer 44 extends BasePeer 45 { 46 47 48 public static final String DATABASE_NAME = "cream"; 49 50 51 public static final String TABLE_NAME = "PRODUCT"; 52 53 58 public static MapBuilder getMapBuilder() 59 throws TorqueException 60 { 61 return getMapBuilder(ProductMapBuilder.CLASS_NAME); 62 } 63 64 65 public static final String PRODUCT_ID; 66 67 public static final String PRODUCT_CODE; 68 69 public static final String STATUS; 70 71 public static final String PRIORITY; 72 73 public static final String PRODUCT_TYPE; 74 75 public static final String PRODUCT_CAT_ID; 76 77 public static final String PRODUCT_DESCRIPTION; 78 79 public static final String PRODUCT_DISPLAY; 80 81 public static final String BASE_PRICE; 82 83 public static final String UOM_ID; 84 85 public static final String WEB_URL; 86 87 public static final String SHOW_ON_PRICELIST; 88 89 public static final String VENDOR_ID; 90 91 public static final String VENDORS_CODE; 92 93 public static final String EAN_UPC_CODE; 94 95 public static final String LOCATION; 96 97 public static final String CUSTOM_1; 98 99 public static final String CUSTOM_2; 100 101 public static final String CUSTOM_3; 102 103 public static final String CUSTOM_4; 104 105 public static final String CUSTOM_5; 106 107 public static final String CUSTOM_6; 108 109 public static final String NOTES; 110 111 public static final String CREATED; 112 113 public static final String MODIFIED; 114 115 public static final String CREATED_BY; 116 117 public static final String MODIFIED_BY; 118 119 static 120 { 121 PRODUCT_ID = "PRODUCT.PRODUCT_ID"; 122 PRODUCT_CODE = "PRODUCT.PRODUCT_CODE"; 123 STATUS = "PRODUCT.STATUS"; 124 PRIORITY = "PRODUCT.PRIORITY"; 125 PRODUCT_TYPE = "PRODUCT.PRODUCT_TYPE"; 126 PRODUCT_CAT_ID = "PRODUCT.PRODUCT_CAT_ID"; 127 PRODUCT_DESCRIPTION = "PRODUCT.PRODUCT_DESCRIPTION"; 128 PRODUCT_DISPLAY = "PRODUCT.PRODUCT_DISPLAY"; 129 BASE_PRICE = "PRODUCT.BASE_PRICE"; 130 UOM_ID = "PRODUCT.UOM_ID"; 131 WEB_URL = "PRODUCT.WEB_URL"; 132 SHOW_ON_PRICELIST = "PRODUCT.SHOW_ON_PRICELIST"; 133 VENDOR_ID = "PRODUCT.VENDOR_ID"; 134 VENDORS_CODE = "PRODUCT.VENDORS_CODE"; 135 EAN_UPC_CODE = "PRODUCT.EAN_UPC_CODE"; 136 LOCATION = "PRODUCT.LOCATION"; 137 CUSTOM_1 = "PRODUCT.CUSTOM_1"; 138 CUSTOM_2 = "PRODUCT.CUSTOM_2"; 139 CUSTOM_3 = "PRODUCT.CUSTOM_3"; 140 CUSTOM_4 = "PRODUCT.CUSTOM_4"; 141 CUSTOM_5 = "PRODUCT.CUSTOM_5"; 142 CUSTOM_6 = "PRODUCT.CUSTOM_6"; 143 NOTES = "PRODUCT.NOTES"; 144 CREATED = "PRODUCT.CREATED"; 145 MODIFIED = "PRODUCT.MODIFIED"; 146 CREATED_BY = "PRODUCT.CREATED_BY"; 147 MODIFIED_BY = "PRODUCT.MODIFIED_BY"; 148 if (Torque.isInit()) 149 { 150 try 151 { 152 getMapBuilder(ProductMapBuilder.CLASS_NAME); 153 } 154 catch (Exception e) 155 { 156 log.error("Could not initialize Peer", e); 157 } 158 } 159 else 160 { 161 Torque.registerMapBuilder(ProductMapBuilder.CLASS_NAME); 162 } 163 } 164 165 166 public static final int numColumns = 27; 167 168 169 protected static final String CLASSNAME_DEFAULT = 170 "org.campware.cream.om.Product"; 171 172 173 protected static final Class CLASS_DEFAULT = initClass(CLASSNAME_DEFAULT); 174 175 181 private static Class initClass(String className) 182 { 183 Class c = null; 184 try 185 { 186 c = Class.forName(className); 187 } 188 catch (Throwable t) 189 { 190 log.error("A FATAL ERROR has occurred which should not " 191 + "have happened under any circumstance. Please notify " 192 + "the Torque developers <torque-dev@db.apache.org> " 193 + "and give as many details as possible (including the error " 194 + "stack trace).", t); 195 196 if (t instanceof Error ) 198 { 199 throw (Error ) t.fillInStackTrace(); 200 } 201 } 202 return c; 203 } 204 205 215 public static List resultSet2Objects(java.sql.ResultSet results) 216 throws TorqueException 217 { 218 try 219 { 220 QueryDataSet qds = null; 221 List rows = null; 222 try 223 { 224 qds = new QueryDataSet(results); 225 rows = getSelectResults(qds); 226 } 227 finally 228 { 229 if (qds != null) 230 { 231 qds.close(); 232 } 233 } 234 235 return populateObjects(rows); 236 } 237 catch (SQLException e) 238 { 239 throw new TorqueException(e); 240 } 241 catch (DataSetException e) 242 { 243 throw new TorqueException(e); 244 } 245 } 246 247 248 249 256 public static ObjectKey doInsert(Criteria criteria) 257 throws TorqueException 258 { 259 return BaseProductPeer 260 .doInsert(criteria, (Connection ) null); 261 } 262 263 273 public static ObjectKey doInsert(Criteria criteria, Connection con) 274 throws TorqueException 275 { 276 277 setDbName(criteria); 278 279 if (con == null) 280 { 281 return BasePeer.doInsert(criteria); 282 } 283 else 284 { 285 return BasePeer.doInsert(criteria, con); 286 } 287 } 288 289 296 public static void addSelectColumns(Criteria criteria) 297 throws TorqueException 298 { 299 criteria.addSelectColumn(PRODUCT_ID); 300 criteria.addSelectColumn(PRODUCT_CODE); 301 criteria.addSelectColumn(STATUS); 302 criteria.addSelectColumn(PRIORITY); 303 criteria.addSelectColumn(PRODUCT_TYPE); 304 criteria.addSelectColumn(PRODUCT_CAT_ID); 305 criteria.addSelectColumn(PRODUCT_DESCRIPTION); 306 criteria.addSelectColumn(PRODUCT_DISPLAY); 307 criteria.addSelectColumn(BASE_PRICE); 308 criteria.addSelectColumn(UOM_ID); 309 criteria.addSelectColumn(WEB_URL); 310 criteria.addSelectColumn(SHOW_ON_PRICELIST); 311 criteria.addSelectColumn(VENDOR_ID); 312 criteria.addSelectColumn(VENDORS_CODE); 313 criteria.addSelectColumn(EAN_UPC_CODE); 314 criteria.addSelectColumn(LOCATION); 315 criteria.addSelectColumn(CUSTOM_1); 316 criteria.addSelectColumn(CUSTOM_2); 317 criteria.addSelectColumn(CUSTOM_3); 318 criteria.addSelectColumn(CUSTOM_4); 319 criteria.addSelectColumn(CUSTOM_5); 320 criteria.addSelectColumn(CUSTOM_6); 321 criteria.addSelectColumn(NOTES); 322 criteria.addSelectColumn(CREATED); 323 criteria.addSelectColumn(MODIFIED); 324 criteria.addSelectColumn(CREATED_BY); 325 criteria.addSelectColumn(MODIFIED_BY); 326 } 327 328 337 public static Product row2Object(Record row, 338 int offset, 339 Class cls) 340 throws TorqueException 341 { 342 try 343 { 344 Product obj = (Product) cls.newInstance(); 345 ProductPeer.populateObject(row, offset, obj); 346 obj.setModified(false); 347 obj.setNew(false); 348 349 return obj; 350 } 351 catch (InstantiationException e) 352 { 353 throw new TorqueException(e); 354 } 355 catch (IllegalAccessException e) 356 { 357 throw new TorqueException(e); 358 } 359 } 360 361 370 public static void populateObject(Record row, 371 int offset, 372 Product obj) 373 throws TorqueException 374 { 375 try 376 { 377 obj.setProductId(row.getValue(offset + 0).asInt()); 378 obj.setProductCode(row.getValue(offset + 1).asString()); 379 obj.setStatus(row.getValue(offset + 2).asInt()); 380 obj.setPriority(row.getValue(offset + 3).asInt()); 381 obj.setProductType(row.getValue(offset + 4).asInt()); 382 obj.setProductCatId(row.getValue(offset + 5).asInt()); 383 obj.setProductDescription(row.getValue(offset + 6).asString()); 384 obj.setProductDisplay(row.getValue(offset + 7).asString()); 385 obj.setBasePrice(row.getValue(offset + 8).asDouble()); 386 obj.setUomId(row.getValue(offset + 9).asInt()); 387 obj.setWebUrl(row.getValue(offset + 10).asString()); 388 obj.setShowOnPricelist(row.getValue(offset + 11).asInt()); 389 obj.setVendorId(row.getValue(offset + 12).asInt()); 390 obj.setVendorsCode(row.getValue(offset + 13).asString()); 391 obj.setEanUpcCode(row.getValue(offset + 14).asString()); 392 obj.setLocation(row.getValue(offset + 15).asString()); 393 obj.setCustom1(row.getValue(offset + 16).asString()); 394 obj.setCustom2(row.getValue(offset + 17).asString()); 395 obj.setCustom3(row.getValue(offset + 18).asString()); 396 obj.setCustom4(row.getValue(offset + 19).asString()); 397 obj.setCustom5(row.getValue(offset + 20).asString()); 398 obj.setCustom6(row.getValue(offset + 21).asString()); 399 obj.setNotes(row.getValue(offset + 22).asString()); 400 obj.setCreated(row.getValue(offset + 23).asUtilDate()); 401 obj.setModified(row.getValue(offset + 24).asUtilDate()); 402 obj.setCreatedBy(row.getValue(offset + 25).asString()); 403 obj.setModifiedBy(row.getValue(offset + 26).asString()); 404 } 405 catch (DataSetException e) 406 { 407 throw new TorqueException(e); 408 } 409 } 410 411 419 public static List doSelect(Criteria criteria) throws TorqueException 420 { 421 return populateObjects(doSelectVillageRecords(criteria)); 422 } 423 424 433 public static List doSelect(Criteria criteria, Connection con) 434 throws TorqueException 435 { 436 return populateObjects(doSelectVillageRecords(criteria, con)); 437 } 438 439 449 public static List doSelectVillageRecords(Criteria criteria) 450 throws TorqueException 451 { 452 return BaseProductPeer 453 .doSelectVillageRecords(criteria, (Connection ) null); 454 } 455 456 465 public static List doSelectVillageRecords(Criteria criteria, Connection con) 466 throws TorqueException 467 { 468 if (criteria.getSelectColumns().size() == 0) 469 { 470 addSelectColumns(criteria); 471 } 472 473 474 setDbName(criteria); 475 476 if (con == null) 479 { 480 return BasePeer.doSelect(criteria); 481 } 482 else 483 { 484 return BasePeer.doSelect(criteria, con); 485 } 486 } 487 488 495 public static List populateObjects(List records) 496 throws TorqueException 497 { 498 List results = new ArrayList (records.size()); 499 500 for (int i = 0; i < records.size(); i++) 502 { 503 Record row = (Record) records.get(i); 504 results.add(ProductPeer.row2Object(row, 1, 505 ProductPeer.getOMClass())); 506 } 507 return results; 508 } 509 510 511 519 public static Class getOMClass() 520 throws TorqueException 521 { 522 return CLASS_DEFAULT; 523 } 524 525 533 public static void doUpdate(Criteria criteria) throws TorqueException 534 { 535 BaseProductPeer 536 .doUpdate(criteria, (Connection ) null); 537 } 538 539 550 public static void doUpdate(Criteria criteria, Connection con) 551 throws TorqueException 552 { 553 Criteria selectCriteria = new Criteria(DATABASE_NAME, 2); 554 selectCriteria.put(PRODUCT_ID, criteria.remove(PRODUCT_ID)); 555 556 setDbName(criteria); 557 558 if (con == null) 559 { 560 BasePeer.doUpdate(selectCriteria, criteria); 561 } 562 else 563 { 564 BasePeer.doUpdate(selectCriteria, criteria, con); 565 } 566 } 567 568 575 public static void doDelete(Criteria criteria) throws TorqueException 576 { 577 ProductPeer 578 .doDelete(criteria, (Connection ) null); 579 } 580 581 591 public static void doDelete(Criteria criteria, Connection con) 592 throws TorqueException 593 { 594 595 setDbName(criteria); 596 597 if (con == null) 598 { 599 BasePeer.doDelete(criteria); 600 } 601 else 602 { 603 BasePeer.doDelete(criteria, con); 604 } 605 } 606 607 613 public static List doSelect(Product obj) throws TorqueException 614 { 615 return doSelect(buildSelectCriteria(obj)); 616 } 617 618 624 public static void doInsert(Product obj) throws TorqueException 625 { 626 obj.setPrimaryKey(doInsert(buildCriteria(obj))); 627 obj.setNew(false); 628 obj.setModified(false); 629 } 630 631 636 public static void doUpdate(Product obj) throws TorqueException 637 { 638 doUpdate(buildCriteria(obj)); 639 obj.setModified(false); 640 } 641 642 647 public static void doDelete(Product obj) throws TorqueException 648 { 649 doDelete(buildSelectCriteria(obj)); 650 } 651 652 662 public static void doInsert(Product obj, Connection con) 663 throws TorqueException 664 { 665 obj.setPrimaryKey(doInsert(buildCriteria(obj), con)); 666 obj.setNew(false); 667 obj.setModified(false); 668 } 669 670 680 public static void doUpdate(Product obj, Connection con) 681 throws TorqueException 682 { 683 doUpdate(buildCriteria(obj), con); 684 obj.setModified(false); 685 } 686 687 697 public static void doDelete(Product obj, Connection con) 698 throws TorqueException 699 { 700 doDelete(buildSelectCriteria(obj), con); 701 } 702 703 710 public static void doDelete(ObjectKey pk) throws TorqueException 711 { 712 BaseProductPeer 713 .doDelete(pk, (Connection ) null); 714 } 715 716 726 public static void doDelete(ObjectKey pk, Connection con) 727 throws TorqueException 728 { 729 doDelete(buildCriteria(pk), con); 730 } 731 732 733 public static Criteria buildCriteria( ObjectKey pk ) 734 { 735 Criteria criteria = new Criteria(); 736 criteria.add(PRODUCT_ID, pk); 737 return criteria; 738 } 739 740 741 public static Criteria buildCriteria( Product obj ) 742 { 743 Criteria criteria = new Criteria(DATABASE_NAME); 744 if (!obj.isNew()) 745 criteria.add(PRODUCT_ID, obj.getProductId()); 746 criteria.add(PRODUCT_CODE, obj.getProductCode()); 747 criteria.add(STATUS, obj.getStatus()); 748 criteria.add(PRIORITY, obj.getPriority()); 749 criteria.add(PRODUCT_TYPE, obj.getProductType()); 750 criteria.add(PRODUCT_CAT_ID, obj.getProductCatId()); 751 criteria.add(PRODUCT_DESCRIPTION, obj.getProductDescription()); 752 criteria.add(PRODUCT_DISPLAY, obj.getProductDisplay()); 753 criteria.add(BASE_PRICE, obj.getBasePrice()); 754 criteria.add(UOM_ID, obj.getUomId()); 755 criteria.add(WEB_URL, obj.getWebUrl()); 756 criteria.add(SHOW_ON_PRICELIST, obj.getShowOnPricelist()); 757 criteria.add(VENDOR_ID, obj.getVendorId()); 758 criteria.add(VENDORS_CODE, obj.getVendorsCode()); 759 criteria.add(EAN_UPC_CODE, obj.getEanUpcCode()); 760 criteria.add(LOCATION, obj.getLocation()); 761 criteria.add(CUSTOM_1, obj.getCustom1()); 762 criteria.add(CUSTOM_2, obj.getCustom2()); 763 criteria.add(CUSTOM_3, obj.getCustom3()); 764 criteria.add(CUSTOM_4, obj.getCustom4()); 765 criteria.add(CUSTOM_5, obj.getCustom5()); 766 criteria.add(CUSTOM_6, obj.getCustom6()); 767 criteria.add(NOTES, obj.getNotes()); 768 criteria.add(CREATED, obj.getCreated()); 769 criteria.add(MODIFIED, obj.getModified()); 770 criteria.add(CREATED_BY, obj.getCreatedBy()); 771 criteria.add(MODIFIED_BY, obj.getModifiedBy()); 772 return criteria; 773 } 774 775 776 public static Criteria buildSelectCriteria( Product obj ) 777 { 778 Criteria criteria = new Criteria(DATABASE_NAME); 779 if (!obj.isNew()) 780 criteria.add(PRODUCT_ID, obj.getProductId()); 781 criteria.add(PRODUCT_CODE, obj.getProductCode()); 782 criteria.add(STATUS, obj.getStatus()); 783 criteria.add(PRIORITY, obj.getPriority()); 784 criteria.add(PRODUCT_TYPE, obj.getProductType()); 785 criteria.add(PRODUCT_CAT_ID, obj.getProductCatId()); 786 criteria.add(PRODUCT_DESCRIPTION, obj.getProductDescription()); 787 criteria.add(PRODUCT_DISPLAY, obj.getProductDisplay()); 788 criteria.add(BASE_PRICE, obj.getBasePrice()); 789 criteria.add(UOM_ID, obj.getUomId()); 790 criteria.add(WEB_URL, obj.getWebUrl()); 791 criteria.add(SHOW_ON_PRICELIST, obj.getShowOnPricelist()); 792 criteria.add(VENDOR_ID, obj.getVendorId()); 793 criteria.add(VENDORS_CODE, obj.getVendorsCode()); 794 criteria.add(EAN_UPC_CODE, obj.getEanUpcCode()); 795 criteria.add(LOCATION, obj.getLocation()); 796 criteria.add(CUSTOM_1, obj.getCustom1()); 797 criteria.add(CUSTOM_2, obj.getCustom2()); 798 criteria.add(CUSTOM_3, obj.getCustom3()); 799 criteria.add(CUSTOM_4, obj.getCustom4()); 800 criteria.add(CUSTOM_5, obj.getCustom5()); 801 criteria.add(CUSTOM_6, obj.getCustom6()); 802 criteria.add(NOTES, obj.getNotes()); 803 criteria.add(CREATED, obj.getCreated()); 804 criteria.add(MODIFIED, obj.getModified()); 805 criteria.add(CREATED_BY, obj.getCreatedBy()); 806 criteria.add(MODIFIED_BY, obj.getModifiedBy()); 807 return criteria; 808 } 809 810 811 820 public static Product retrieveByPK(int pk) 821 throws TorqueException, NoRowsException, TooManyRowsException 822 { 823 return retrieveByPK(SimpleKey.keyFor(pk)); 824 } 825 826 836 public static Product retrieveByPK(int pk, Connection con) 837 throws TorqueException, NoRowsException, TooManyRowsException 838 { 839 return retrieveByPK(SimpleKey.keyFor(pk), con); 840 } 841 842 851 public static Product retrieveByPK(ObjectKey pk) 852 throws TorqueException, NoRowsException, TooManyRowsException 853 { 854 Connection db = null; 855 Product retVal = null; 856 try 857 { 858 db = Torque.getConnection(DATABASE_NAME); 859 retVal = retrieveByPK(pk, db); 860 } 861 finally 862 { 863 Torque.closeConnection(db); 864 } 865 return(retVal); 866 } 867 868 878 public static Product retrieveByPK(ObjectKey pk, Connection con) 879 throws TorqueException, NoRowsException, TooManyRowsException 880 { 881 Criteria criteria = buildCriteria(pk); 882 List v = doSelect(criteria, con); 883 if (v.size() == 0) 884 { 885 throw new NoRowsException("Failed to select a row."); 886 } 887 else if (v.size() > 1) 888 { 889 throw new TooManyRowsException("Failed to select only one row."); 890 } 891 else 892 { 893 return (Product)v.get(0); 894 } 895 } 896 897 904 public static List retrieveByPKs(List pks) 905 throws TorqueException 906 { 907 Connection db = null; 908 List retVal = null; 909 try 910 { 911 db = Torque.getConnection(DATABASE_NAME); 912 retVal = retrieveByPKs(pks, db); 913 } 914 finally 915 { 916 Torque.closeConnection(db); 917 } 918 return(retVal); 919 } 920 921 929 public static List retrieveByPKs( List pks, Connection dbcon ) 930 throws TorqueException 931 { 932 List objs = null; 933 if (pks == null || pks.size() == 0) 934 { 935 objs = new LinkedList (); 936 } 937 else 938 { 939 Criteria criteria = new Criteria(); 940 criteria.addIn( PRODUCT_ID, pks ); 941 objs = doSelect(criteria, dbcon); 942 } 943 return objs; 944 } 945 946 947 948 949 950 951 952 953 954 955 966 protected static List doSelectJoinProductCategory(Criteria criteria) 967 throws TorqueException 968 { 969 setDbName(criteria); 970 971 ProductPeer.addSelectColumns(criteria); 972 int offset = numColumns + 1; 973 ProductCategoryPeer.addSelectColumns(criteria); 974 975 976 criteria.addJoin(ProductPeer.PRODUCT_CAT_ID, 977 ProductCategoryPeer.PRODUCT_CAT_ID); 978 979 980 981 List rows = BasePeer.doSelect(criteria); 982 List results = new ArrayList (); 983 984 for (int i = 0; i < rows.size(); i++) 985 { 986 Record row = (Record) rows.get(i); 987 988 Class omClass = ProductPeer.getOMClass(); 989 Product obj1 = (Product) ProductPeer 990 .row2Object(row, 1, omClass); 991 omClass = ProductCategoryPeer.getOMClass(); 992 ProductCategory obj2 = (ProductCategory)ProductCategoryPeer 993 .row2Object(row, offset, omClass); 994 995 boolean newObject = true; 996 for (int j = 0; j < results.size(); j++) 997 { 998 Product temp_obj1 = (Product)results.get(j); 999 ProductCategory temp_obj2 = (ProductCategory)temp_obj1.getProductCategory(); 1000 if (temp_obj2.getPrimaryKey().equals(obj2.getPrimaryKey())) 1001 { 1002 newObject = false; 1003 temp_obj2.addProduct(obj1); 1004 break; 1005 } 1006 } 1007 if (newObject) 1008 { 1009 obj2.initProducts(); 1010 obj2.addProduct(obj1); 1011 } 1012 results.add(obj1); 1013 } 1014 return results; 1015 } 1016 1017 1018 1019 1020 1031 protected static List doSelectJoinUom(Criteria criteria) 1032 throws TorqueException 1033 { 1034 setDbName(criteria); 1035 1036 ProductPeer.addSelectColumns(criteria); 1037 int offset = numColumns + 1; 1038 UomPeer.addSelectColumns(criteria); 1039 1040 1041 criteria.addJoin(ProductPeer.UOM_ID, 1042 UomPeer.UOM_ID); 1043 1044 1045 1046 List rows = BasePeer.doSelect(criteria); 1047 List results = new ArrayList (); 1048 1049 for (int i = 0; i < rows.size(); i++) 1050 { 1051 Record row = (Record) rows.get(i); 1052 1053 Class omClass = ProductPeer.getOMClass(); 1054 Product obj1 = (Product) ProductPeer 1055 .row2Object(row, 1, omClass); 1056 omClass = UomPeer.getOMClass(); 1057 Uom obj2 = (Uom)UomPeer 1058 .row2Object(row, offset, omClass); 1059 1060 boolean newObject = true; 1061 for (int j = 0; j < results.size(); j++) 1062 { 1063 Product temp_obj1 = (Product)results.get(j); 1064 Uom temp_obj2 = (Uom)temp_obj1.getUom(); 1065 if (temp_obj2.getPrimaryKey().equals(obj2.getPrimaryKey())) 1066 { 1067 newObject = false; 1068 temp_obj2.addProduct(obj1); 1069 break; 1070 } 1071 } 1072 if (newObject) 1073 { 1074 obj2.initProducts(); 1075 obj2.addProduct(obj1); 1076 } 1077 results.add(obj1); 1078 } 1079 return results; 1080 } 1081 1082 1083 1084 1085 1096 protected static List doSelectJoinVendor(Criteria criteria) 1097 throws TorqueException 1098 { 1099 setDbName(criteria); 1100 1101 ProductPeer.addSelectColumns(criteria); 1102 int offset = numColumns + 1; 1103 VendorPeer.addSelectColumns(criteria); 1104 1105 1106 criteria.addJoin(ProductPeer.VENDOR_ID, 1107 VendorPeer.VENDOR_ID); 1108 1109 1110 1111 List rows = BasePeer.doSelect(criteria); 1112 List results = new ArrayList (); 1113 1114 for (int i = 0; i < rows.size(); i++) 1115 { 1116 Record row = (Record) rows.get(i); 1117 1118 Class omClass = ProductPeer.getOMClass(); 1119 Product obj1 = (Product) ProductPeer 1120 .row2Object(row, 1, omClass); 1121 omClass = VendorPeer.getOMClass(); 1122 Vendor obj2 = (Vendor)VendorPeer 1123 .row2Object(row, offset, omClass); 1124 1125 boolean newObject = true; 1126 for (int j = 0; j < results.size(); j++) 1127 { 1128 Product temp_obj1 = (Product)results.get(j); 1129 Vendor temp_obj2 = (Vendor)temp_obj1.getVendor(); 1130 if (temp_obj2.getPrimaryKey().equals(obj2.getPrimaryKey())) 1131 { 1132 newObject = false; 1133 temp_obj2.addProduct(obj1); 1134 break; 1135 } 1136 } 1137 if (newObject) 1138 { 1139 obj2.initProducts(); 1140 obj2.addProduct(obj1); 1141 } 1142 results.add(obj1); 1143 } 1144 return results; 1145 } 1146 1147 1148 1149 1150 1151 1152 1153 1154 1165 protected static List doSelectJoinAllExceptProductCategory(Criteria criteria) 1166 throws TorqueException 1167 { 1168 setDbName(criteria); 1169 1170 addSelectColumns(criteria); 1171 int offset2 = numColumns + 1; 1172 1173 1174 UomPeer.addSelectColumns(criteria); 1175 int offset3 = offset2 + UomPeer.numColumns; 1176 1177 VendorPeer.addSelectColumns(criteria); 1178 int offset4 = offset3 + VendorPeer.numColumns; 1179 1180 List rows = BasePeer.doSelect(criteria); 1181 List results = new ArrayList (); 1182 1183 for (int i = 0; i < rows.size(); i++) 1184 { 1185 Record row = (Record)rows.get(i); 1186 1187 Class omClass = ProductPeer.getOMClass(); 1188 Product obj1 = (Product)ProductPeer 1189 .row2Object(row, 1, omClass); 1190 1191 1192 1193 1194 1195 omClass = UomPeer.getOMClass(); 1196 Uom obj2 = (Uom)UomPeer 1197 .row2Object( row, offset2, omClass); 1198 1199 boolean newObject = true; 1200 for (int j = 0; j < results.size(); j++) 1201 { 1202 Product temp_obj1 = (Product)results.get(j); 1203 Uom temp_obj2 = (Uom)temp_obj1.getUom(); 1204 if (temp_obj2.getPrimaryKey().equals(obj2.getPrimaryKey())) 1205 { 1206 newObject = false; 1207 temp_obj2.addProduct(obj1); 1208 break; 1209 } 1210 } 1211 if (newObject) 1212 { 1213 obj2.initProducts(); 1214 obj2.addProduct(obj1); 1215 } 1216 1217 1218 1219 1220 omClass = VendorPeer.getOMClass(); 1221 Vendor obj3 = (Vendor)VendorPeer 1222 .row2Object( row, offset3, omClass); 1223 1224 newObject = true; 1225 for (int j = 0; j < results.size(); j++) 1226 { 1227 Product temp_obj1 = (Product)results.get(j); 1228 Vendor temp_obj3 = (Vendor)temp_obj1.getVendor(); 1229 if (temp_obj3.getPrimaryKey().equals(obj3.getPrimaryKey())) 1230 { 1231 newObject = false; 1232 temp_obj3.addProduct(obj1); 1233 break; 1234 } 1235 } 1236 if (newObject) 1237 { 1238 obj3.initProducts(); 1239 obj3.addProduct(obj1); 1240 } 1241 results.add(obj1); 1242 } 1243 return results; 1244 } 1245 1246 1247 1248 1249 1250 1261 protected static List doSelectJoinAllExceptUom(Criteria criteria) 1262 throws TorqueException 1263 { 1264 setDbName(criteria); 1265 1266 addSelectColumns(criteria); 1267 int offset2 = numColumns + 1; 1268 1269 ProductCategoryPeer.addSelectColumns(criteria); 1270 int offset3 = offset2 + ProductCategoryPeer.numColumns; 1271 1272 1273 VendorPeer.addSelectColumns(criteria); 1274 int offset4 = offset3 + VendorPeer.numColumns; 1275 1276 List rows = BasePeer.doSelect(criteria); 1277 List results = new ArrayList (); 1278 1279 for (int i = 0; i < rows.size(); i++) 1280 { 1281 Record row = (Record)rows.get(i); 1282 1283 Class omClass = ProductPeer.getOMClass(); 1284 Product obj1 = (Product)ProductPeer 1285 .row2Object(row, 1, omClass); 1286 1287 1288 1289 1290 omClass = ProductCategoryPeer.getOMClass(); 1291 ProductCategory obj2 = (ProductCategory)ProductCategoryPeer 1292 .row2Object( row, offset2, omClass); 1293 1294 boolean newObject = true; 1295 for (int j = 0; j < results.size(); j++) 1296 { 1297 Product temp_obj1 = (Product)results.get(j); 1298 ProductCategory temp_obj2 = (ProductCategory)temp_obj1.getProductCategory(); 1299 if (temp_obj2.getPrimaryKey().equals(obj2.getPrimaryKey())) 1300 { 1301 newObject = false; 1302 temp_obj2.addProduct(obj1); 1303 break; 1304 } 1305 } 1306 if (newObject) 1307 { 1308 obj2.initProducts(); 1309 obj2.addProduct(obj1); 1310 } 1311 1312 1313 1314 1315 1316 omClass = VendorPeer.getOMClass(); 1317 Vendor obj3 = (Vendor)VendorPeer 1318 .row2Object( row, offset3, omClass); 1319 1320 newObject = true; 1321 for (int j = 0; j < results.size(); j++) 1322 { 1323 Product temp_obj1 = (Product)results.get(j); 1324 Vendor temp_obj3 = (Vendor)temp_obj1.getVendor(); 1325 if (temp_obj3.getPrimaryKey().equals(obj3.getPrimaryKey())) 1326 { 1327 newObject = false; 1328 temp_obj3.addProduct(obj1); 1329 break; 1330 } 1331 } 1332 if (newObject) 1333 { 1334 obj3.initProducts(); 1335 obj3.addProduct(obj1); 1336 } 1337 results.add(obj1); 1338 } 1339 return results; 1340 } 1341 1342 1343 1344 1345 1346 1357 protected static List doSelectJoinAllExceptVendor(Criteria criteria) 1358 throws TorqueException 1359 { 1360 setDbName(criteria); 1361 1362 addSelectColumns(criteria); 1363 int offset2 = numColumns + 1; 1364 1365 ProductCategoryPeer.addSelectColumns(criteria); 1366 int offset3 = offset2 + ProductCategoryPeer.numColumns; 1367 1368 UomPeer.addSelectColumns(criteria); 1369 int offset4 = offset3 + UomPeer.numColumns; 1370 1371 1372 List rows = BasePeer.doSelect(criteria); 1373 List results = new ArrayList (); 1374 1375 for (int i = 0; i < rows.size(); i++) 1376 { 1377 Record row = (Record)rows.get(i); 1378 1379 Class omClass = ProductPeer.getOMClass(); 1380 Product obj1 = (Product)ProductPeer 1381 .row2Object(row, 1, omClass); 1382 1383 1384 1385 1386 omClass = ProductCategoryPeer.getOMClass(); 1387 ProductCategory obj2 = (ProductCategory)ProductCategoryPeer 1388 .row2Object( row, offset2, omClass); 1389 1390 boolean newObject = true; 1391 for (int j = 0; j < results.size(); j++) 1392 { 1393 Product temp_obj1 = (Product)results.get(j); 1394 ProductCategory temp_obj2 = (ProductCategory)temp_obj1.getProductCategory(); 1395 if (temp_obj2.getPrimaryKey().equals(obj2.getPrimaryKey())) 1396 { 1397 newObject = false; 1398 temp_obj2.addProduct(obj1); 1399 break; 1400 } 1401 } 1402 if (newObject) 1403 { 1404 obj2.initProducts(); 1405 obj2.addProduct(obj1); 1406 } 1407 1408 1409 1410 1411 omClass = UomPeer.getOMClass(); 1412 Uom obj3 = (Uom)UomPeer 1413 .row2Object( row, offset3, omClass); 1414 1415 newObject = true; 1416 for (int j = 0; j < results.size(); j++) 1417 { 1418 Product temp_obj1 = (Product)results.get(j); 1419 Uom temp_obj3 = (Uom)temp_obj1.getUom(); 1420 if (temp_obj3.getPrimaryKey().equals(obj3.getPrimaryKey())) 1421 { 1422 newObject = false; 1423 temp_obj3.addProduct(obj1); 1424 break; 1425 } 1426 } 1427 if (newObject) 1428 { 1429 obj3.initProducts(); 1430 obj3.addProduct(obj1); 1431 } 1432 1433 results.add(obj1); 1434 } 1435 return results; 1436 } 1437 1438 1439 1446 protected static TableMap getTableMap() 1447 throws TorqueException 1448 { 1449 return Torque.getDatabaseMap(DATABASE_NAME).getTable(TABLE_NAME); 1450 } 1451 1452 private static void setDbName(Criteria crit) 1453 { 1454 if (crit.getDbName() == Torque.getDefaultDB()) 1458 { 1459 crit.setDbName(DATABASE_NAME); 1460 } 1461 } 1462} 1463
| Popular Tags
|