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 38 39 40 46 public abstract class BaseSorderItemPeer 47 extends BasePeer 48 { 49 50 51 public static final String DATABASE_NAME = "cream"; 52 53 54 public static final String TABLE_NAME = "SORDER_ITEM"; 55 56 61 public static MapBuilder getMapBuilder() 62 throws TorqueException 63 { 64 return getMapBuilder(SorderItemMapBuilder.CLASS_NAME); 65 } 66 67 68 public static final String SORDER_ITEM_ID; 69 70 public static final String SORDER_ID; 71 72 public static final String CUSTOMER_ID; 73 74 public static final String RECIPIENT_ID; 75 76 public static final String PROJECT_ID; 77 78 public static final String PRODUCT_ID; 79 80 public static final String DESCRIPTION; 81 82 public static final String UNIT_PRICE; 83 84 public static final String CURRENCY_ID; 85 86 public static final String QUANTITY; 87 88 public static final String ITEM_CURR_TOTAL; 89 90 static 91 { 92 SORDER_ITEM_ID = "SORDER_ITEM.SORDER_ITEM_ID"; 93 SORDER_ID = "SORDER_ITEM.SORDER_ID"; 94 CUSTOMER_ID = "SORDER_ITEM.CUSTOMER_ID"; 95 RECIPIENT_ID = "SORDER_ITEM.RECIPIENT_ID"; 96 PROJECT_ID = "SORDER_ITEM.PROJECT_ID"; 97 PRODUCT_ID = "SORDER_ITEM.PRODUCT_ID"; 98 DESCRIPTION = "SORDER_ITEM.DESCRIPTION"; 99 UNIT_PRICE = "SORDER_ITEM.UNIT_PRICE"; 100 CURRENCY_ID = "SORDER_ITEM.CURRENCY_ID"; 101 QUANTITY = "SORDER_ITEM.QUANTITY"; 102 ITEM_CURR_TOTAL = "SORDER_ITEM.ITEM_CURR_TOTAL"; 103 if (Torque.isInit()) 104 { 105 try 106 { 107 getMapBuilder(SorderItemMapBuilder.CLASS_NAME); 108 } 109 catch (Exception e) 110 { 111 log.error("Could not initialize Peer", e); 112 } 113 } 114 else 115 { 116 Torque.registerMapBuilder(SorderItemMapBuilder.CLASS_NAME); 117 } 118 } 119 120 121 public static final int numColumns = 11; 122 123 124 protected static final String CLASSNAME_DEFAULT = 125 "org.campware.cream.om.SorderItem"; 126 127 128 protected static final Class CLASS_DEFAULT = initClass(CLASSNAME_DEFAULT); 129 130 136 private static Class initClass(String className) 137 { 138 Class c = null; 139 try 140 { 141 c = Class.forName(className); 142 } 143 catch (Throwable t) 144 { 145 log.error("A FATAL ERROR has occurred which should not " 146 + "have happened under any circumstance. Please notify " 147 + "the Torque developers <torque-dev@db.apache.org> " 148 + "and give as many details as possible (including the error " 149 + "stack trace).", t); 150 151 if (t instanceof Error ) 153 { 154 throw (Error ) t.fillInStackTrace(); 155 } 156 } 157 return c; 158 } 159 160 170 public static List resultSet2Objects(java.sql.ResultSet results) 171 throws TorqueException 172 { 173 try 174 { 175 QueryDataSet qds = null; 176 List rows = null; 177 try 178 { 179 qds = new QueryDataSet(results); 180 rows = getSelectResults(qds); 181 } 182 finally 183 { 184 if (qds != null) 185 { 186 qds.close(); 187 } 188 } 189 190 return populateObjects(rows); 191 } 192 catch (SQLException e) 193 { 194 throw new TorqueException(e); 195 } 196 catch (DataSetException e) 197 { 198 throw new TorqueException(e); 199 } 200 } 201 202 203 204 211 public static ObjectKey doInsert(Criteria criteria) 212 throws TorqueException 213 { 214 return BaseSorderItemPeer 215 .doInsert(criteria, (Connection ) null); 216 } 217 218 228 public static ObjectKey doInsert(Criteria criteria, Connection con) 229 throws TorqueException 230 { 231 232 setDbName(criteria); 233 234 if (con == null) 235 { 236 return BasePeer.doInsert(criteria); 237 } 238 else 239 { 240 return BasePeer.doInsert(criteria, con); 241 } 242 } 243 244 251 public static void addSelectColumns(Criteria criteria) 252 throws TorqueException 253 { 254 criteria.addSelectColumn(SORDER_ITEM_ID); 255 criteria.addSelectColumn(SORDER_ID); 256 criteria.addSelectColumn(CUSTOMER_ID); 257 criteria.addSelectColumn(RECIPIENT_ID); 258 criteria.addSelectColumn(PROJECT_ID); 259 criteria.addSelectColumn(PRODUCT_ID); 260 criteria.addSelectColumn(DESCRIPTION); 261 criteria.addSelectColumn(UNIT_PRICE); 262 criteria.addSelectColumn(CURRENCY_ID); 263 criteria.addSelectColumn(QUANTITY); 264 criteria.addSelectColumn(ITEM_CURR_TOTAL); 265 } 266 267 276 public static SorderItem row2Object(Record row, 277 int offset, 278 Class cls) 279 throws TorqueException 280 { 281 try 282 { 283 SorderItem obj = (SorderItem) cls.newInstance(); 284 SorderItemPeer.populateObject(row, offset, obj); 285 obj.setModified(false); 286 obj.setNew(false); 287 288 return obj; 289 } 290 catch (InstantiationException e) 291 { 292 throw new TorqueException(e); 293 } 294 catch (IllegalAccessException e) 295 { 296 throw new TorqueException(e); 297 } 298 } 299 300 309 public static void populateObject(Record row, 310 int offset, 311 SorderItem obj) 312 throws TorqueException 313 { 314 try 315 { 316 obj.setSorderItemId(row.getValue(offset + 0).asInt()); 317 obj.setSorderId(row.getValue(offset + 1).asInt()); 318 obj.setCustomerId(row.getValue(offset + 2).asInt()); 319 obj.setRecipientId(row.getValue(offset + 3).asInt()); 320 obj.setProjectId(row.getValue(offset + 4).asInt()); 321 obj.setProductId(row.getValue(offset + 5).asInt()); 322 obj.setDescription(row.getValue(offset + 6).asString()); 323 obj.setUnitPrice(row.getValue(offset + 7).asBigDecimal()); 324 obj.setCurrencyId(row.getValue(offset + 8).asInt()); 325 obj.setQuantity(row.getValue(offset + 9).asInt()); 326 obj.setItemCurrTotal(row.getValue(offset + 10).asBigDecimal()); 327 } 328 catch (DataSetException e) 329 { 330 throw new TorqueException(e); 331 } 332 } 333 334 342 public static List doSelect(Criteria criteria) throws TorqueException 343 { 344 return populateObjects(doSelectVillageRecords(criteria)); 345 } 346 347 356 public static List doSelect(Criteria criteria, Connection con) 357 throws TorqueException 358 { 359 return populateObjects(doSelectVillageRecords(criteria, con)); 360 } 361 362 372 public static List doSelectVillageRecords(Criteria criteria) 373 throws TorqueException 374 { 375 return BaseSorderItemPeer 376 .doSelectVillageRecords(criteria, (Connection ) null); 377 } 378 379 388 public static List doSelectVillageRecords(Criteria criteria, Connection con) 389 throws TorqueException 390 { 391 if (criteria.getSelectColumns().size() == 0) 392 { 393 addSelectColumns(criteria); 394 } 395 396 397 setDbName(criteria); 398 399 if (con == null) 402 { 403 return BasePeer.doSelect(criteria); 404 } 405 else 406 { 407 return BasePeer.doSelect(criteria, con); 408 } 409 } 410 411 418 public static List populateObjects(List records) 419 throws TorqueException 420 { 421 List results = new ArrayList (records.size()); 422 423 for (int i = 0; i < records.size(); i++) 425 { 426 Record row = (Record) records.get(i); 427 results.add(SorderItemPeer.row2Object(row, 1, 428 SorderItemPeer.getOMClass())); 429 } 430 return results; 431 } 432 433 434 442 public static Class getOMClass() 443 throws TorqueException 444 { 445 return CLASS_DEFAULT; 446 } 447 448 456 public static void doUpdate(Criteria criteria) throws TorqueException 457 { 458 BaseSorderItemPeer 459 .doUpdate(criteria, (Connection ) null); 460 } 461 462 473 public static void doUpdate(Criteria criteria, Connection con) 474 throws TorqueException 475 { 476 Criteria selectCriteria = new Criteria(DATABASE_NAME, 2); 477 selectCriteria.put(SORDER_ITEM_ID, criteria.remove(SORDER_ITEM_ID)); 478 479 setDbName(criteria); 480 481 if (con == null) 482 { 483 BasePeer.doUpdate(selectCriteria, criteria); 484 } 485 else 486 { 487 BasePeer.doUpdate(selectCriteria, criteria, con); 488 } 489 } 490 491 498 public static void doDelete(Criteria criteria) throws TorqueException 499 { 500 SorderItemPeer 501 .doDelete(criteria, (Connection ) null); 502 } 503 504 514 public static void doDelete(Criteria criteria, Connection con) 515 throws TorqueException 516 { 517 518 setDbName(criteria); 519 520 if (con == null) 521 { 522 BasePeer.doDelete(criteria); 523 } 524 else 525 { 526 BasePeer.doDelete(criteria, con); 527 } 528 } 529 530 536 public static List doSelect(SorderItem obj) throws TorqueException 537 { 538 return doSelect(buildSelectCriteria(obj)); 539 } 540 541 547 public static void doInsert(SorderItem obj) throws TorqueException 548 { 549 obj.setPrimaryKey(doInsert(buildCriteria(obj))); 550 obj.setNew(false); 551 obj.setModified(false); 552 } 553 554 559 public static void doUpdate(SorderItem obj) throws TorqueException 560 { 561 doUpdate(buildCriteria(obj)); 562 obj.setModified(false); 563 } 564 565 570 public static void doDelete(SorderItem obj) throws TorqueException 571 { 572 doDelete(buildSelectCriteria(obj)); 573 } 574 575 585 public static void doInsert(SorderItem obj, Connection con) 586 throws TorqueException 587 { 588 obj.setPrimaryKey(doInsert(buildCriteria(obj), con)); 589 obj.setNew(false); 590 obj.setModified(false); 591 } 592 593 603 public static void doUpdate(SorderItem obj, Connection con) 604 throws TorqueException 605 { 606 doUpdate(buildCriteria(obj), con); 607 obj.setModified(false); 608 } 609 610 620 public static void doDelete(SorderItem obj, Connection con) 621 throws TorqueException 622 { 623 doDelete(buildSelectCriteria(obj), con); 624 } 625 626 633 public static void doDelete(ObjectKey pk) throws TorqueException 634 { 635 BaseSorderItemPeer 636 .doDelete(pk, (Connection ) null); 637 } 638 639 649 public static void doDelete(ObjectKey pk, Connection con) 650 throws TorqueException 651 { 652 doDelete(buildCriteria(pk), con); 653 } 654 655 656 public static Criteria buildCriteria( ObjectKey pk ) 657 { 658 Criteria criteria = new Criteria(); 659 criteria.add(SORDER_ITEM_ID, pk); 660 return criteria; 661 } 662 663 664 public static Criteria buildCriteria( SorderItem obj ) 665 { 666 Criteria criteria = new Criteria(DATABASE_NAME); 667 if (!obj.isNew()) 668 criteria.add(SORDER_ITEM_ID, obj.getSorderItemId()); 669 criteria.add(SORDER_ID, obj.getSorderId()); 670 criteria.add(CUSTOMER_ID, obj.getCustomerId()); 671 criteria.add(RECIPIENT_ID, obj.getRecipientId()); 672 criteria.add(PROJECT_ID, obj.getProjectId()); 673 criteria.add(PRODUCT_ID, obj.getProductId()); 674 criteria.add(DESCRIPTION, obj.getDescription()); 675 criteria.add(UNIT_PRICE, obj.getUnitPrice()); 676 criteria.add(CURRENCY_ID, obj.getCurrencyId()); 677 criteria.add(QUANTITY, obj.getQuantity()); 678 criteria.add(ITEM_CURR_TOTAL, obj.getItemCurrTotal()); 679 return criteria; 680 } 681 682 683 public static Criteria buildSelectCriteria( SorderItem obj ) 684 { 685 Criteria criteria = new Criteria(DATABASE_NAME); 686 if (!obj.isNew()) 687 criteria.add(SORDER_ITEM_ID, obj.getSorderItemId()); 688 criteria.add(SORDER_ID, obj.getSorderId()); 689 criteria.add(CUSTOMER_ID, obj.getCustomerId()); 690 criteria.add(RECIPIENT_ID, obj.getRecipientId()); 691 criteria.add(PROJECT_ID, obj.getProjectId()); 692 criteria.add(PRODUCT_ID, obj.getProductId()); 693 criteria.add(DESCRIPTION, obj.getDescription()); 694 criteria.add(UNIT_PRICE, obj.getUnitPrice()); 695 criteria.add(CURRENCY_ID, obj.getCurrencyId()); 696 criteria.add(QUANTITY, obj.getQuantity()); 697 criteria.add(ITEM_CURR_TOTAL, obj.getItemCurrTotal()); 698 return criteria; 699 } 700 701 702 711 public static SorderItem retrieveByPK(int pk) 712 throws TorqueException, NoRowsException, TooManyRowsException 713 { 714 return retrieveByPK(SimpleKey.keyFor(pk)); 715 } 716 717 727 public static SorderItem retrieveByPK(int pk, Connection con) 728 throws TorqueException, NoRowsException, TooManyRowsException 729 { 730 return retrieveByPK(SimpleKey.keyFor(pk), con); 731 } 732 733 742 public static SorderItem retrieveByPK(ObjectKey pk) 743 throws TorqueException, NoRowsException, TooManyRowsException 744 { 745 Connection db = null; 746 SorderItem retVal = null; 747 try 748 { 749 db = Torque.getConnection(DATABASE_NAME); 750 retVal = retrieveByPK(pk, db); 751 } 752 finally 753 { 754 Torque.closeConnection(db); 755 } 756 return(retVal); 757 } 758 759 769 public static SorderItem retrieveByPK(ObjectKey pk, Connection con) 770 throws TorqueException, NoRowsException, TooManyRowsException 771 { 772 Criteria criteria = buildCriteria(pk); 773 List v = doSelect(criteria, con); 774 if (v.size() == 0) 775 { 776 throw new NoRowsException("Failed to select a row."); 777 } 778 else if (v.size() > 1) 779 { 780 throw new TooManyRowsException("Failed to select only one row."); 781 } 782 else 783 { 784 return (SorderItem)v.get(0); 785 } 786 } 787 788 795 public static List retrieveByPKs(List pks) 796 throws TorqueException 797 { 798 Connection db = null; 799 List retVal = null; 800 try 801 { 802 db = Torque.getConnection(DATABASE_NAME); 803 retVal = retrieveByPKs(pks, db); 804 } 805 finally 806 { 807 Torque.closeConnection(db); 808 } 809 return(retVal); 810 } 811 812 820 public static List retrieveByPKs( List pks, Connection dbcon ) 821 throws TorqueException 822 { 823 List objs = null; 824 if (pks == null || pks.size() == 0) 825 { 826 objs = new LinkedList (); 827 } 828 else 829 { 830 Criteria criteria = new Criteria(); 831 criteria.addIn( SORDER_ITEM_ID, pks ); 832 objs = doSelect(criteria, dbcon); 833 } 834 return objs; 835 } 836 837 838 839 840 841 842 843 844 845 846 857 protected static List doSelectJoinSorder(Criteria criteria) 858 throws TorqueException 859 { 860 setDbName(criteria); 861 862 SorderItemPeer.addSelectColumns(criteria); 863 int offset = numColumns + 1; 864 SorderPeer.addSelectColumns(criteria); 865 866 867 criteria.addJoin(SorderItemPeer.SORDER_ID, 868 SorderPeer.SORDER_ID); 869 870 871 872 List rows = BasePeer.doSelect(criteria); 873 List results = new ArrayList (); 874 875 for (int i = 0; i < rows.size(); i++) 876 { 877 Record row = (Record) rows.get(i); 878 879 Class omClass = SorderItemPeer.getOMClass(); 880 SorderItem obj1 = (SorderItem) SorderItemPeer 881 .row2Object(row, 1, omClass); 882 omClass = SorderPeer.getOMClass(); 883 Sorder obj2 = (Sorder)SorderPeer 884 .row2Object(row, offset, omClass); 885 886 boolean newObject = true; 887 for (int j = 0; j < results.size(); j++) 888 { 889 SorderItem temp_obj1 = (SorderItem)results.get(j); 890 Sorder temp_obj2 = (Sorder)temp_obj1.getSorder(); 891 if (temp_obj2.getPrimaryKey().equals(obj2.getPrimaryKey())) 892 { 893 newObject = false; 894 temp_obj2.addSorderItem(obj1); 895 break; 896 } 897 } 898 if (newObject) 899 { 900 obj2.initSorderItems(); 901 obj2.addSorderItem(obj1); 902 } 903 results.add(obj1); 904 } 905 return results; 906 } 907 908 909 910 911 922 protected static List doSelectJoinProduct(Criteria criteria) 923 throws TorqueException 924 { 925 setDbName(criteria); 926 927 SorderItemPeer.addSelectColumns(criteria); 928 int offset = numColumns + 1; 929 ProductPeer.addSelectColumns(criteria); 930 931 932 criteria.addJoin(SorderItemPeer.PRODUCT_ID, 933 ProductPeer.PRODUCT_ID); 934 935 936 937 List rows = BasePeer.doSelect(criteria); 938 List results = new ArrayList (); 939 940 for (int i = 0; i < rows.size(); i++) 941 { 942 Record row = (Record) rows.get(i); 943 944 Class omClass = SorderItemPeer.getOMClass(); 945 SorderItem obj1 = (SorderItem) SorderItemPeer 946 .row2Object(row, 1, omClass); 947 omClass = ProductPeer.getOMClass(); 948 Product obj2 = (Product)ProductPeer 949 .row2Object(row, offset, omClass); 950 951 boolean newObject = true; 952 for (int j = 0; j < results.size(); j++) 953 { 954 SorderItem temp_obj1 = (SorderItem)results.get(j); 955 Product temp_obj2 = (Product)temp_obj1.getProduct(); 956 if (temp_obj2.getPrimaryKey().equals(obj2.getPrimaryKey())) 957 { 958 newObject = false; 959 temp_obj2.addSorderItem(obj1); 960 break; 961 } 962 } 963 if (newObject) 964 { 965 obj2.initSorderItems(); 966 obj2.addSorderItem(obj1); 967 } 968 results.add(obj1); 969 } 970 return results; 971 } 972 973 974 975 976 987 protected static List doSelectJoinCustomerRelatedByCustomerId(Criteria criteria) 988 throws TorqueException 989 { 990 setDbName(criteria); 991 992 SorderItemPeer.addSelectColumns(criteria); 993 int offset = numColumns + 1; 994 CustomerPeer.addSelectColumns(criteria); 995 996 997 criteria.addJoin(SorderItemPeer.CUSTOMER_ID, 998 CustomerPeer.CUSTOMER_ID); 999 1000 1001 1002 List rows = BasePeer.doSelect(criteria); 1003 List results = new ArrayList (); 1004 1005 for (int i = 0; i < rows.size(); i++) 1006 { 1007 Record row = (Record) rows.get(i); 1008 1009 Class omClass = SorderItemPeer.getOMClass(); 1010 SorderItem obj1 = (SorderItem) SorderItemPeer 1011 .row2Object(row, 1, omClass); 1012 omClass = CustomerPeer.getOMClass(); 1013 Customer obj2 = (Customer)CustomerPeer 1014 .row2Object(row, offset, omClass); 1015 1016 boolean newObject = true; 1017 for (int j = 0; j < results.size(); j++) 1018 { 1019 SorderItem temp_obj1 = (SorderItem)results.get(j); 1020 Customer temp_obj2 = (Customer)temp_obj1.getCustomerRelatedByCustomerId(); 1021 if (temp_obj2.getPrimaryKey().equals(obj2.getPrimaryKey())) 1022 { 1023 newObject = false; 1024 temp_obj2.addSorderItemRelatedByCustomerId(obj1); 1025 break; 1026 } 1027 } 1028 if (newObject) 1029 { 1030 obj2.initSorderItemsRelatedByCustomerId(); 1031 obj2.addSorderItemRelatedByCustomerId(obj1); 1032 } 1033 results.add(obj1); 1034 } 1035 return results; 1036 } 1037 1038 1039 1040 1041 1052 protected static List doSelectJoinCustomerRelatedByRecipientId(Criteria criteria) 1053 throws TorqueException 1054 { 1055 setDbName(criteria); 1056 1057 SorderItemPeer.addSelectColumns(criteria); 1058 int offset = numColumns + 1; 1059 CustomerPeer.addSelectColumns(criteria); 1060 1061 1062 criteria.addJoin(SorderItemPeer.RECIPIENT_ID, 1063 CustomerPeer.CUSTOMER_ID); 1064 1065 1066 1067 List rows = BasePeer.doSelect(criteria); 1068 List results = new ArrayList (); 1069 1070 for (int i = 0; i < rows.size(); i++) 1071 { 1072 Record row = (Record) rows.get(i); 1073 1074 Class omClass = SorderItemPeer.getOMClass(); 1075 SorderItem obj1 = (SorderItem) SorderItemPeer 1076 .row2Object(row, 1, omClass); 1077 omClass = CustomerPeer.getOMClass(); 1078 Customer obj2 = (Customer)CustomerPeer 1079 .row2Object(row, offset, omClass); 1080 1081 boolean newObject = true; 1082 for (int j = 0; j < results.size(); j++) 1083 { 1084 SorderItem temp_obj1 = (SorderItem)results.get(j); 1085 Customer temp_obj2 = (Customer)temp_obj1.getCustomerRelatedByRecipientId(); 1086 if (temp_obj2.getPrimaryKey().equals(obj2.getPrimaryKey())) 1087 { 1088 newObject = false; 1089 temp_obj2.addSorderItemRelatedByRecipientId(obj1); 1090 break; 1091 } 1092 } 1093 if (newObject) 1094 { 1095 obj2.initSorderItemsRelatedByRecipientId(); 1096 obj2.addSorderItemRelatedByRecipientId(obj1); 1097 } 1098 results.add(obj1); 1099 } 1100 return results; 1101 } 1102 1103 1104 1105 1106 1117 protected static List doSelectJoinProject(Criteria criteria) 1118 throws TorqueException 1119 { 1120 setDbName(criteria); 1121 1122 SorderItemPeer.addSelectColumns(criteria); 1123 int offset = numColumns + 1; 1124 ProjectPeer.addSelectColumns(criteria); 1125 1126 1127 criteria.addJoin(SorderItemPeer.PROJECT_ID, 1128 ProjectPeer.PROJECT_ID); 1129 1130 1131 1132 List rows = BasePeer.doSelect(criteria); 1133 List results = new ArrayList (); 1134 1135 for (int i = 0; i < rows.size(); i++) 1136 { 1137 Record row = (Record) rows.get(i); 1138 1139 Class omClass = SorderItemPeer.getOMClass(); 1140 SorderItem obj1 = (SorderItem) SorderItemPeer 1141 .row2Object(row, 1, omClass); 1142 omClass = ProjectPeer.getOMClass(); 1143 Project obj2 = (Project)ProjectPeer 1144 .row2Object(row, offset, omClass); 1145 1146 boolean newObject = true; 1147 for (int j = 0; j < results.size(); j++) 1148 { 1149 SorderItem temp_obj1 = (SorderItem)results.get(j); 1150 Project temp_obj2 = (Project)temp_obj1.getProject(); 1151 if (temp_obj2.getPrimaryKey().equals(obj2.getPrimaryKey())) 1152 { 1153 newObject = false; 1154 temp_obj2.addSorderItem(obj1); 1155 break; 1156 } 1157 } 1158 if (newObject) 1159 { 1160 obj2.initSorderItems(); 1161 obj2.addSorderItem(obj1); 1162 } 1163 results.add(obj1); 1164 } 1165 return results; 1166 } 1167 1168 1169 1170 1171 1182 protected static List doSelectJoinCurrency(Criteria criteria) 1183 throws TorqueException 1184 { 1185 setDbName(criteria); 1186 1187 SorderItemPeer.addSelectColumns(criteria); 1188 int offset = numColumns + 1; 1189 CurrencyPeer.addSelectColumns(criteria); 1190 1191 1192 criteria.addJoin(SorderItemPeer.CURRENCY_ID, 1193 CurrencyPeer.CURRENCY_ID); 1194 1195 1196 1197 List rows = BasePeer.doSelect(criteria); 1198 List results = new ArrayList (); 1199 1200 for (int i = 0; i < rows.size(); i++) 1201 { 1202 Record row = (Record) rows.get(i); 1203 1204 Class omClass = SorderItemPeer.getOMClass(); 1205 SorderItem obj1 = (SorderItem) SorderItemPeer 1206 .row2Object(row, 1, omClass); 1207 omClass = CurrencyPeer.getOMClass(); 1208 Currency obj2 = (Currency)CurrencyPeer 1209 .row2Object(row, offset, omClass); 1210 1211 boolean newObject = true; 1212 for (int j = 0; j < results.size(); j++) 1213 { 1214 SorderItem temp_obj1 = (SorderItem)results.get(j); 1215 Currency temp_obj2 = (Currency)temp_obj1.getCurrency(); 1216 if (temp_obj2.getPrimaryKey().equals(obj2.getPrimaryKey())) 1217 { 1218 newObject = false; 1219 temp_obj2.addSorderItem(obj1); 1220 break; 1221 } 1222 } 1223 if (newObject) 1224 { 1225 obj2.initSorderItems(); 1226 obj2.addSorderItem(obj1); 1227 } 1228 results.add(obj1); 1229 } 1230 return results; 1231 } 1232 1233 1234 1235 1236 1237 1238 1239 1240 1251 protected static List doSelectJoinAllExceptSorder(Criteria criteria) 1252 throws TorqueException 1253 { 1254 setDbName(criteria); 1255 1256 addSelectColumns(criteria); 1257 int offset2 = numColumns + 1; 1258 1259 1260 ProductPeer.addSelectColumns(criteria); 1261 int offset3 = offset2 + ProductPeer.numColumns; 1262 1263 CustomerPeer.addSelectColumns(criteria); 1264 int offset4 = offset3 + CustomerPeer.numColumns; 1265 1266 CustomerPeer.addSelectColumns(criteria); 1267 int offset5 = offset4 + CustomerPeer.numColumns; 1268 1269 ProjectPeer.addSelectColumns(criteria); 1270 int offset6 = offset5 + ProjectPeer.numColumns; 1271 1272 CurrencyPeer.addSelectColumns(criteria); 1273 int offset7 = offset6 + CurrencyPeer.numColumns; 1274 1275 List rows = BasePeer.doSelect(criteria); 1276 List results = new ArrayList (); 1277 1278 for (int i = 0; i < rows.size(); i++) 1279 { 1280 Record row = (Record)rows.get(i); 1281 1282 Class omClass = SorderItemPeer.getOMClass(); 1283 SorderItem obj1 = (SorderItem)SorderItemPeer 1284 .row2Object(row, 1, omClass); 1285 1286 1287 1288 1289 1290 omClass = ProductPeer.getOMClass(); 1291 Product obj2 = (Product)ProductPeer 1292 .row2Object( row, offset2, omClass); 1293 1294 boolean newObject = true; 1295 for (int j = 0; j < results.size(); j++) 1296 { 1297 SorderItem temp_obj1 = (SorderItem)results.get(j); 1298 Product temp_obj2 = (Product)temp_obj1.getProduct(); 1299 if (temp_obj2.getPrimaryKey().equals(obj2.getPrimaryKey())) 1300 { 1301 newObject = false; 1302 temp_obj2.addSorderItem(obj1); 1303 break; 1304 } 1305 } 1306 if (newObject) 1307 { 1308 obj2.initSorderItems(); 1309 obj2.addSorderItem(obj1); 1310 } 1311 1312 1313 1314 1315 omClass = CustomerPeer.getOMClass(); 1316 Customer obj3 = (Customer)CustomerPeer 1317 .row2Object( row, offset3, omClass); 1318 1319 newObject = true; 1320 for (int j = 0; j < results.size(); j++) 1321 { 1322 SorderItem temp_obj1 = (SorderItem)results.get(j); 1323 Customer temp_obj3 = (Customer)temp_obj1.getCustomerRelatedByCustomerId(); 1324 if (temp_obj3.getPrimaryKey().equals(obj3.getPrimaryKey())) 1325 { 1326 newObject = false; 1327 temp_obj3.addSorderItemRelatedByCustomerId(obj1); 1328 break; 1329 } 1330 } 1331 if (newObject) 1332 { 1333 obj3.initSorderItemsRelatedByCustomerId(); 1334 obj3.addSorderItemRelatedByCustomerId(obj1); 1335 } 1336 1337 1338 1339 1340 omClass = CustomerPeer.getOMClass(); 1341 Customer obj4 = (Customer)CustomerPeer 1342 .row2Object( row, offset4, omClass); 1343 1344 newObject = true; 1345 for (int j = 0; j < results.size(); j++) 1346 { 1347 SorderItem temp_obj1 = (SorderItem)results.get(j); 1348 Customer temp_obj4 = (Customer)temp_obj1.getCustomerRelatedByRecipientId(); 1349 if (temp_obj4.getPrimaryKey().equals(obj4.getPrimaryKey())) 1350 { 1351 newObject = false; 1352 temp_obj4.addSorderItemRelatedByRecipientId(obj1); 1353 break; 1354 } 1355 } 1356 if (newObject) 1357 { 1358 obj4.initSorderItemsRelatedByRecipientId(); 1359 obj4.addSorderItemRelatedByRecipientId(obj1); 1360 } 1361 1362 1363 1364 1365 omClass = ProjectPeer.getOMClass(); 1366 Project obj5 = (Project)ProjectPeer 1367 .row2Object( row, offset5, omClass); 1368 1369 newObject = true; 1370 for (int j = 0; j < results.size(); j++) 1371 { 1372 SorderItem temp_obj1 = (SorderItem)results.get(j); 1373 Project temp_obj5 = (Project)temp_obj1.getProject(); 1374 if (temp_obj5.getPrimaryKey().equals(obj5.getPrimaryKey())) 1375 { 1376 newObject = false; 1377 temp_obj5.addSorderItem(obj1); 1378 break; 1379 } 1380 } 1381 if (newObject) 1382 { 1383 obj5.initSorderItems(); 1384 obj5.addSorderItem(obj1); 1385 } 1386 1387 1388 1389 1390 omClass = CurrencyPeer.getOMClass(); 1391 Currency obj6 = (Currency)CurrencyPeer 1392 .row2Object( row, offset6, omClass); 1393 1394 newObject = true; 1395 for (int j = 0; j < results.size(); j++) 1396 { 1397 SorderItem temp_obj1 = (SorderItem)results.get(j); 1398 Currency temp_obj6 = (Currency)temp_obj1.getCurrency(); 1399 if (temp_obj6.getPrimaryKey().equals(obj6.getPrimaryKey())) 1400 { 1401 newObject = false; 1402 temp_obj6.addSorderItem(obj1); 1403 break; 1404 } 1405 } 1406 if (newObject) 1407 { 1408 obj6.initSorderItems(); 1409 obj6.addSorderItem(obj1); 1410 } 1411 results.add(obj1); 1412 } 1413 return results; 1414 } 1415 1416 1417 1418 1419 1420 1431 protected static List doSelectJoinAllExceptProduct(Criteria criteria) 1432 throws TorqueException 1433 { 1434 setDbName(criteria); 1435 1436 addSelectColumns(criteria); 1437 int offset2 = numColumns + 1; 1438 1439 SorderPeer.addSelectColumns(criteria); 1440 int offset3 = offset2 + SorderPeer.numColumns; 1441 1442 1443 CustomerPeer.addSelectColumns(criteria); 1444 int offset4 = offset3 + CustomerPeer.numColumns; 1445 1446 CustomerPeer.addSelectColumns(criteria); 1447 int offset5 = offset4 + CustomerPeer.numColumns; 1448 1449 ProjectPeer.addSelectColumns(criteria); 1450 int offset6 = offset5 + ProjectPeer.numColumns; 1451 1452 CurrencyPeer.addSelectColumns(criteria); 1453 int offset7 = offset6 + CurrencyPeer.numColumns; 1454 1455 List rows = BasePeer.doSelect(criteria); 1456 List results = new ArrayList (); 1457 1458 for (int i = 0; i < rows.size(); i++) 1459 { 1460 Record row = (Record)rows.get(i); 1461 1462 Class omClass = SorderItemPeer.getOMClass(); 1463 SorderItem obj1 = (SorderItem)SorderItemPeer 1464 .row2Object(row, 1, omClass); 1465 1466 1467 1468 1469 omClass = SorderPeer.getOMClass(); 1470 Sorder obj2 = (Sorder)SorderPeer 1471 .row2Object( row, offset2, omClass); 1472 1473 boolean newObject = true; 1474 for (int j = 0; j < results.size(); j++) 1475 { 1476 SorderItem temp_obj1 = (SorderItem)results.get(j); 1477 Sorder temp_obj2 = (Sorder)temp_obj1.getSorder(); 1478 if (temp_obj2.getPrimaryKey().equals(obj2.getPrimaryKey())) 1479 { 1480 newObject = false; 1481 temp_obj2.addSorderItem(obj1); 1482 break; 1483 } 1484 } 1485 if (newObject) 1486 { 1487 obj2.initSorderItems(); 1488 obj2.addSorderItem(obj1); 1489 } 1490 1491 1492 1493 1494 1495 omClass = CustomerPeer.getOMClass(); 1496 Customer obj3 = (Customer)CustomerPeer 1497 .row2Object( row, offset3, omClass); 1498 1499 newObject = true; 1500 for (int j = 0; j < results.size(); j++) 1501 { 1502 SorderItem temp_obj1 = (SorderItem)results.get(j); 1503 Customer temp_obj3 = (Customer)temp_obj1.getCustomerRelatedByCustomerId(); 1504 if (temp_obj3.getPrimaryKey().equals(obj3.getPrimaryKey())) 1505 { 1506 newObject = false; 1507 temp_obj3.addSorderItemRelatedByCustomerId(obj1); 1508 break; 1509 } 1510 } 1511 if (newObject) 1512 { 1513 obj3.initSorderItemsRelatedByCustomerId(); 1514 obj3.addSorderItemRelatedByCustomerId(obj1); 1515 } 1516 1517 1518 1519 1520 omClass = CustomerPeer.getOMClass(); 1521 Customer obj4 = (Customer)CustomerPeer 1522 .row2Object( row, offset4, omClass); 1523 1524 newObject = true; 1525 for (int j = 0; j < results.size(); j++) 1526 { 1527 SorderItem temp_obj1 = (SorderItem)results.get(j); 1528 Customer temp_obj4 = (Customer)temp_obj1.getCustomerRelatedByRecipientId(); 1529 if (temp_obj4.getPrimaryKey().equals(obj4.getPrimaryKey())) 1530 { 1531 newObject = false; 1532 temp_obj4.addSorderItemRelatedByRecipientId(obj1); 1533 break; 1534 } 1535 } 1536 if (newObject) 1537 { 1538 obj4.initSorderItemsRelatedByRecipientId(); 1539 obj4.addSorderItemRelatedByRecipientId(obj1); 1540 } 1541 1542 1543 1544 1545 omClass = ProjectPeer.getOMClass(); 1546 Project obj5 = (Project)ProjectPeer 1547 .row2Object( row, offset5, omClass); 1548 1549 newObject = true; 1550 for (int j = 0; j < results.size(); j++) 1551 { 1552 SorderItem temp_obj1 = (SorderItem)results.get(j); 1553 Project temp_obj5 = (Project)temp_obj1.getProject(); 1554 if (temp_obj5.getPrimaryKey().equals(obj5.getPrimaryKey())) 1555 { 1556 newObject = false; 1557 temp_obj5.addSorderItem(obj1); 1558 break; 1559 } 1560 } 1561 if (newObject) 1562 { 1563 obj5.initSorderItems(); 1564 obj5.addSorderItem(obj1); 1565 } 1566 1567 1568 1569 1570 omClass = CurrencyPeer.getOMClass(); 1571 Currency obj6 = (Currency)CurrencyPeer 1572 .row2Object( row, offset6, omClass); 1573 1574 newObject = true; 1575 for (int j = 0; j < results.size(); j++) 1576 { 1577 SorderItem temp_obj1 = (SorderItem)results.get(j); 1578 Currency temp_obj6 = (Currency)temp_obj1.getCurrency(); 1579 if (temp_obj6.getPrimaryKey().equals(obj6.getPrimaryKey())) 1580 { 1581 newObject = false; 1582 temp_obj6.addSorderItem(obj1); 1583 break; 1584 } 1585 } 1586 if (newObject) 1587 { 1588 obj6.initSorderItems(); 1589 obj6.addSorderItem(obj1); 1590 } 1591 results.add(obj1); 1592 } 1593 return results; 1594 } 1595 1596 1597 1598 1599 1600 1611 protected static List doSelectJoinAllExceptCustomerRelatedByCustomerId(Criteria criteria) 1612 throws TorqueException 1613 { 1614 setDbName(criteria); 1615 1616 addSelectColumns(criteria); 1617 int offset2 = numColumns + 1; 1618 1619 SorderPeer.addSelectColumns(criteria); 1620 int offset3 = offset2 + SorderPeer.numColumns; 1621 1622 ProductPeer.addSelectColumns(criteria); 1623 int offset4 = offset3 + ProductPeer.numColumns; 1624 1625 1626 1627 ProjectPeer.addSelectColumns(criteria); 1628 int offset5 = offset4 + ProjectPeer.numColumns; 1629 1630 CurrencyPeer.addSelectColumns(criteria); 1631 int offset6 = offset5 + CurrencyPeer.numColumns; 1632 1633 List rows = BasePeer.doSelect(criteria); 1634 List results = new ArrayList (); 1635 1636 for (int i = 0; i < rows.size(); i++) 1637 { 1638 Record row = (Record)rows.get(i); 1639 1640 Class omClass = SorderItemPeer.getOMClass(); 1641 SorderItem obj1 = (SorderItem)SorderItemPeer 1642 .row2Object(row, 1, omClass); 1643 1644 1645 1646 1647 omClass = SorderPeer.getOMClass(); 1648 Sorder obj2 = (Sorder)SorderPeer 1649 .row2Object( row, offset2, omClass); 1650 1651 boolean newObject = true; 1652 for (int j = 0; j < results.size(); j++) 1653 { 1654 SorderItem temp_obj1 = (SorderItem)results.get(j); 1655 Sorder temp_obj2 = (Sorder)temp_obj1.getSorder(); 1656 if (temp_obj2.getPrimaryKey().equals(obj2.getPrimaryKey())) 1657 { 1658 newObject = false; 1659 temp_obj2.addSorderItem(obj1); 1660 break; 1661 } 1662 } 1663 if (newObject) 1664 { 1665 obj2.initSorderItems(); 1666 obj2.addSorderItem(obj1); 1667 } 1668 1669 1670 1671 1672 omClass = ProductPeer.getOMClass(); 1673 Product obj3 = (Product)ProductPeer 1674 .row2Object( row, offset3, omClass); 1675 1676 newObject = true; 1677 for (int j = 0; j < results.size(); j++) 1678 { 1679 SorderItem temp_obj1 = (SorderItem)results.get(j); 1680 Product temp_obj3 = (Product)temp_obj1.getProduct(); 1681 if (temp_obj3.getPrimaryKey().equals(obj3.getPrimaryKey())) 1682 { 1683 newObject = false; 1684 temp_obj3.addSorderItem(obj1); 1685 break; 1686 } 1687 } 1688 if (newObject) 1689 { 1690 obj3.initSorderItems(); 1691 obj3.addSorderItem(obj1); 1692 } 1693 1694 1695 1696 1697 1698 1699 omClass = ProjectPeer.getOMClass(); 1700 Project obj4 = (Project)ProjectPeer 1701 .row2Object( row, offset4, omClass); 1702 1703 newObject = true; 1704 for (int j = 0; j < results.size(); j++) 1705 { 1706 SorderItem temp_obj1 = (SorderItem)results.get(j); 1707 Project temp_obj4 = (Project)temp_obj1.getProject(); 1708 if (temp_obj4.getPrimaryKey().equals(obj4.getPrimaryKey())) 1709 { 1710 newObject = false; 1711 temp_obj4.addSorderItem(obj1); 1712 break; 1713 } 1714 } 1715 if (newObject) 1716 { 1717 obj4.initSorderItems(); 1718 obj4.addSorderItem(obj1); 1719 } 1720 1721 1722 1723 1724 omClass = CurrencyPeer.getOMClass(); 1725 Currency obj5 = (Currency)CurrencyPeer 1726 .row2Object( row, offset5, omClass); 1727 1728 newObject = true; 1729 for (int j = 0; j < results.size(); j++) 1730 { 1731 SorderItem temp_obj1 = (SorderItem)results.get(j); 1732 Currency temp_obj5 = (Currency)temp_obj1.getCurrency(); 1733 if (temp_obj5.getPrimaryKey().equals(obj5.getPrimaryKey())) 1734 { 1735 newObject = false; 1736 temp_obj5.addSorderItem(obj1); 1737 break; 1738 } 1739 } 1740 if (newObject) 1741 { 1742 obj5.initSorderItems(); 1743 obj5.addSorderItem(obj1); 1744 } 1745 results.add(obj1); 1746 } 1747 return results; 1748 } 1749 1750 1751 1752 1753 1754 1765 protected static List doSelectJoinAllExceptCustomerRelatedByRecipientId(Criteria criteria) 1766 throws TorqueException 1767 { 1768 setDbName(criteria); 1769 1770 addSelectColumns(criteria); 1771 int offset2 = numColumns + 1; 1772 1773 SorderPeer.addSelectColumns(criteria); 1774 int offset3 = offset2 + SorderPeer.numColumns; 1775 1776 ProductPeer.addSelectColumns(criteria); 1777 int offset4 = offset3 + ProductPeer.numColumns; 1778 1779 1780 1781 ProjectPeer.addSelectColumns(criteria); 1782 int offset5 = offset4 + ProjectPeer.numColumns; 1783 1784 CurrencyPeer.addSelectColumns(criteria); 1785 int offset6 = offset5 + CurrencyPeer.numColumns; 1786 1787 List rows = BasePeer.doSelect(criteria); 1788 List results = new ArrayList (); 1789 1790 for (int i = 0; i < rows.size(); i++) 1791 { 1792 Record row = (Record)rows.get(i); 1793 1794 Class omClass = SorderItemPeer.getOMClass(); 1795 SorderItem obj1 = (SorderItem)SorderItemPeer 1796 .row2Object(row, 1, omClass); 1797 1798 1799 1800 1801 omClass = SorderPeer.getOMClass(); 1802 Sorder obj2 = (Sorder)SorderPeer 1803 .row2Object( row, offset2, omClass); 1804 1805 boolean newObject = true; 1806 for (int j = 0; j < results.size(); j++) 1807 { 1808 SorderItem temp_obj1 = (SorderItem)results.get(j); 1809 Sorder temp_obj2 = (Sorder)temp_obj1.getSorder(); 1810 if (temp_obj2.getPrimaryKey().equals(obj2.getPrimaryKey())) 1811 { 1812 newObject = false; 1813 temp_obj2.addSorderItem(obj1); 1814 break; 1815 } 1816 } 1817 if (newObject) 1818 { 1819 obj2.initSorderItems(); 1820 obj2.addSorderItem(obj1); 1821 } 1822 1823 1824 1825 1826 omClass = ProductPeer.getOMClass(); 1827 Product obj3 = (Product)ProductPeer 1828 .row2Object( row, offset3, omClass); 1829 1830 newObject = true; 1831 for (int j = 0; j < results.size(); j++) 1832 { 1833 SorderItem temp_obj1 = (SorderItem)results.get(j); 1834 Product temp_obj3 = (Product)temp_obj1.getProduct(); 1835 if (temp_obj3.getPrimaryKey().equals(obj3.getPrimaryKey())) 1836 { 1837 newObject = false; 1838 temp_obj3.addSorderItem(obj1); 1839 break; 1840 } 1841 } 1842 if (newObject) 1843 { 1844 obj3.initSorderItems(); 1845 obj3.addSorderItem(obj1); 1846 } 1847 1848 1849 1850 1851 1852 1853 omClass = ProjectPeer.getOMClass(); 1854 Project obj4 = (Project)ProjectPeer 1855 .row2Object( row, offset4, omClass); 1856 1857 newObject = true; 1858 for (int j = 0; j < results.size(); j++) 1859 { 1860 SorderItem temp_obj1 = (SorderItem)results.get(j); 1861 Project temp_obj4 = (Project)temp_obj1.getProject(); 1862 if (temp_obj4.getPrimaryKey().equals(obj4.getPrimaryKey())) 1863 { 1864 newObject = false; 1865 temp_obj4.addSorderItem(obj1); 1866 break; 1867 } 1868 } 1869 if (newObject) 1870 { 1871 obj4.initSorderItems(); 1872 obj4.addSorderItem(obj1); 1873 } 1874 1875 1876 1877 1878 omClass = CurrencyPeer.getOMClass(); 1879 Currency obj5 = (Currency)CurrencyPeer 1880 .row2Object( row, offset5, omClass); 1881 1882 newObject = true; 1883 for (int j = 0; j < results.size(); j++) 1884 { 1885 SorderItem temp_obj1 = (SorderItem)results.get(j); 1886 Currency temp_obj5 = (Currency)temp_obj1.getCurrency(); 1887 if (temp_obj5.getPrimaryKey().equals(obj5.getPrimaryKey())) 1888 { 1889 newObject = false; 1890 temp_obj5.addSorderItem(obj1); 1891 break; 1892 } 1893 } 1894 if (newObject) 1895 { 1896 obj5.initSorderItems(); 1897 obj5.addSorderItem(obj1); 1898 } 1899 results.add(obj1); 1900 } 1901 return results; 1902 } 1903 1904 1905 1906 1907 1908 1919 protected static List doSelectJoinAllExceptProject(Criteria criteria) 1920 throws TorqueException 1921 { 1922 setDbName(criteria); 1923 1924 addSelectColumns(criteria); 1925 int offset2 = numColumns + 1; 1926 1927 SorderPeer.addSelectColumns(criteria); 1928 int offset3 = offset2 + SorderPeer.numColumns; 1929 1930 ProductPeer.addSelectColumns(criteria); 1931 int offset4 = offset3 + ProductPeer.numColumns; 1932 1933 CustomerPeer.addSelectColumns(criteria); 1934 int offset5 = offset4 + CustomerPeer.numColumns; 1935 1936 CustomerPeer.addSelectColumns(criteria); 1937 int offset6 = offset5 + CustomerPeer.numColumns; 1938 1939 1940 CurrencyPeer.addSelectColumns(criteria); 1941 int offset7 = offset6 + CurrencyPeer.numColumns; 1942 1943 List rows = BasePeer.doSelect(criteria); 1944 List results = new ArrayList (); 1945 1946 for (int i = 0; i < rows.size(); i++) 1947 { 1948 Record row = (Record)rows.get(i); 1949 1950 Class omClass = SorderItemPeer.getOMClass(); 1951 SorderItem obj1 = (SorderItem)SorderItemPeer 1952 .row2Object(row, 1, omClass); 1953 1954 1955 1956 1957 omClass = SorderPeer.getOMClass(); 1958 Sorder obj2 = (Sorder)SorderPeer 1959 .row2Object( row, offset2, omClass); 1960 1961 boolean newObject = true; 1962 for (int j = 0; j < results.size(); j++) 1963 { 1964 SorderItem temp_obj1 = (SorderItem)results.get(j); 1965 Sorder temp_obj2 = (Sorder)temp_obj1.getSorder(); 1966 if (temp_obj2.getPrimaryKey().equals(obj2.getPrimaryKey())) 1967 { 1968 newObject = false; 1969 temp_obj2.addSorderItem(obj1); 1970 break; 1971 } 1972 } 1973 if (newObject) 1974 { 1975 obj2.initSorderItems(); 1976 obj2.addSorderItem(obj1); 1977 } 1978 1979 1980 1981 1982 omClass = ProductPeer.getOMClass(); 1983 Product obj3 = (Product)ProductPeer 1984 .row2Object( row, offset3, omClass); 1985 1986 newObject = true; 1987 for (int j = 0; j < results.size(); j++) 1988 { 1989 SorderItem temp_obj1 = (SorderItem)results.get(j); 1990 Product temp_obj3 = (Product)temp_obj1.getProduct(); 1991 if (temp_obj3.getPrimaryKey().equals(obj3.getPrimaryKey())) 1992 { 1993 newObject = false; 1994 temp_obj3.addSorderItem(obj1); 1995 break; 1996 } 1997 } 1998 if (newObject) 1999 { 2000 obj3.initSorderItems(); 2001 obj3.addSorderItem(obj1); 2002 } 2003 2004 2005 2006 2007 omClass = CustomerPeer.getOMClass(); 2008 Customer obj4 = (Customer)CustomerPeer 2009 .row2Object( row, offset4, omClass); 2010 2011 newObject = true; 2012 for (int j = 0; j < results.size(); j++) 2013 { 2014 SorderItem temp_obj1 = (SorderItem)results.get(j); 2015 Customer temp_obj4 = (Customer)temp_obj1.getCustomerRelatedByCustomerId(); 2016 if (temp_obj4.getPrimaryKey().equals(obj4.getPrimaryKey())) 2017 { 2018 newObject = false; 2019 temp_obj4.addSorderItemRelatedByCustomerId(obj1); 2020 break; 2021 } 2022 } 2023 if (newObject) 2024 { 2025 obj4.initSorderItemsRelatedByCustomerId(); 2026 obj4.addSorderItemRelatedByCustomerId(obj1); 2027 } 2028 2029 2030 2031 2032 omClass = CustomerPeer.getOMClass(); 2033 Customer obj5 = (Customer)CustomerPeer 2034 .row2Object( row, offset5, omClass); 2035 2036 newObject = true; 2037 for (int j = 0; j < results.size(); j++) 2038 { 2039 SorderItem temp_obj1 = (SorderItem)results.get(j); 2040 Customer temp_obj5 = (Customer)temp_obj1.getCustomerRelatedByRecipientId(); 2041 if (temp_obj5.getPrimaryKey().equals(obj5.getPrimaryKey())) 2042 { 2043 newObject = false; 2044 temp_obj5.addSorderItemRelatedByRecipientId(obj1); 2045 break; 2046 } 2047 } 2048 if (newObject) 2049 { 2050 obj5.initSorderItemsRelatedByRecipientId(); 2051 obj5.addSorderItemRelatedByRecipientId(obj1); 2052 } 2053 2054 2055 2056 2057 2058 omClass = CurrencyPeer.getOMClass(); 2059 Currency obj6 = (Currency)CurrencyPeer 2060 .row2Object( row, offset6, omClass); 2061 2062 newObject = true; 2063 for (int j = 0; j < results.size(); j++) 2064 { 2065 SorderItem temp_obj1 = (SorderItem)results.get(j); 2066 Currency temp_obj6 = (Currency)temp_obj1.getCurrency(); 2067 if (temp_obj6.getPrimaryKey().equals(obj6.getPrimaryKey())) 2068 { 2069 newObject = false; 2070 temp_obj6.addSorderItem(obj1); 2071 break; 2072 } 2073 } 2074 if (newObject) 2075 { 2076 obj6.initSorderItems(); 2077 obj6.addSorderItem(obj1); 2078 } 2079 results.add(obj1); 2080 } 2081 return results; 2082 } 2083 2084 2085 2086 2087 2088 2099 protected static List doSelectJoinAllExceptCurrency(Criteria criteria) 2100 throws TorqueException 2101 { 2102 setDbName(criteria); 2103 2104 addSelectColumns(criteria); 2105 int offset2 = numColumns + 1; 2106 2107 SorderPeer.addSelectColumns(criteria); 2108 int offset3 = offset2 + SorderPeer.numColumns; 2109 2110 ProductPeer.addSelectColumns(criteria); 2111 int offset4 = offset3 + ProductPeer.numColumns; 2112 2113 CustomerPeer.addSelectColumns(criteria); 2114 int offset5 = offset4 + CustomerPeer.numColumns; 2115 2116 CustomerPeer.addSelectColumns(criteria); 2117 int offset6 = offset5 + CustomerPeer.numColumns; 2118 2119 ProjectPeer.addSelectColumns(criteria); 2120 int offset7 = offset6 + ProjectPeer.numColumns; 2121 2122 2123 List rows = BasePeer.doSelect(criteria); 2124 List results = new ArrayList (); 2125 2126 for (int i = 0; i < rows.size(); i++) 2127 { 2128 Record row = (Record)rows.get(i); 2129 2130 Class omClass = SorderItemPeer.getOMClass(); 2131 SorderItem obj1 = (SorderItem)SorderItemPeer 2132 .row2Object(row, 1, omClass); 2133 2134 2135 2136 2137 omClass = SorderPeer.getOMClass(); 2138 Sorder obj2 = (Sorder)SorderPeer 2139 .row2Object( row, offset2, omClass); 2140 2141 boolean newObject = true; 2142 for (int j = 0; j < results.size(); j++) 2143 { 2144 SorderItem temp_obj1 = (SorderItem)results.get(j); 2145 Sorder temp_obj2 = (Sorder)temp_obj1.getSorder(); 2146 if (temp_obj2.getPrimaryKey().equals(obj2.getPrimaryKey())) 2147 { 2148 newObject = false; 2149 temp_obj2.addSorderItem(obj1); 2150 break; 2151 } 2152 } 2153 if (newObject) 2154 { 2155 obj2.initSorderItems(); 2156 obj2.addSorderItem(obj1); 2157 } 2158 2159 2160 2161 2162 omClass = ProductPeer.getOMClass(); 2163 Product obj3 = (Product)ProductPeer 2164 .row2Object( row, offset3, omClass); 2165 2166 newObject = true; 2167 for (int j = 0; j < results.size(); j++) 2168 { 2169 SorderItem temp_obj1 = (SorderItem)results.get(j); 2170 Product temp_obj3 = (Product)temp_obj1.getProduct(); 2171 if (temp_obj3.getPrimaryKey().equals(obj3.getPrimaryKey())) 2172 { 2173 newObject = false; 2174 temp_obj3.addSorderItem(obj1); 2175 break; 2176 } 2177 } 2178 if (newObject) 2179 { 2180 obj3.initSorderItems(); 2181 obj3.addSorderItem(obj1); 2182 } 2183 2184 2185 2186 2187 omClass = CustomerPeer.getOMClass(); 2188 Customer obj4 = (Customer)CustomerPeer 2189 .row2Object( row, offset4, omClass); 2190 2191 newObject = true; 2192 for (int j = 0; j < results.size(); j++) 2193 { 2194 SorderItem temp_obj1 = (SorderItem)results.get(j); 2195 Customer temp_obj4 = (Customer)temp_obj1.getCustomerRelatedByCustomerId(); 2196 if (temp_obj4.getPrimaryKey().equals(obj4.getPrimaryKey())) 2197 { 2198 newObject = false; 2199 temp_obj4.addSorderItemRelatedByCustomerId(obj1); 2200 break; 2201 } 2202 } 2203 if (newObject) 2204 { 2205 obj4.initSorderItemsRelatedByCustomerId(); 2206 obj4.addSorderItemRelatedByCustomerId(obj1); 2207 } 2208 2209 2210 2211 2212 omClass = CustomerPeer.getOMClass(); 2213 Customer obj5 = (Customer)CustomerPeer 2214 .row2Object( row, offset5, omClass); 2215 2216 newObject = true; 2217 for (int j = 0; j < results.size(); j++) 2218 { 2219 SorderItem temp_obj1 = (SorderItem)results.get(j); 2220 Customer temp_obj5 = (Customer)temp_obj1.getCustomerRelatedByRecipientId(); 2221 if (temp_obj5.getPrimaryKey().equals(obj5.getPrimaryKey())) 2222 { 2223 newObject = false; 2224 temp_obj5.addSorderItemRelatedByRecipientId(obj1); 2225 break; 2226 } 2227 } 2228 if (newObject) 2229 { 2230 obj5.initSorderItemsRelatedByRecipientId(); 2231 obj5.addSorderItemRelatedByRecipientId(obj1); 2232 } 2233 2234 2235 2236 2237 omClass = ProjectPeer.getOMClass(); 2238 Project obj6 = (Project)ProjectPeer 2239 .row2Object( row, offset6, omClass); 2240 2241 newObject = true; 2242 for (int j = 0; j < results.size(); j++) 2243 { 2244 SorderItem temp_obj1 = (SorderItem)results.get(j); 2245 Project temp_obj6 = (Project)temp_obj1.getProject(); 2246 if (temp_obj6.getPrimaryKey().equals(obj6.getPrimaryKey())) 2247 { 2248 newObject = false; 2249 temp_obj6.addSorderItem(obj1); 2250 break; 2251 } 2252 } 2253 if (newObject) 2254 { 2255 obj6.initSorderItems(); 2256 obj6.addSorderItem(obj1); 2257 } 2258 2259 results.add(obj1); 2260 } 2261 return results; 2262 } 2263 2264 2265 2272 protected static TableMap getTableMap() 2273 throws TorqueException 2274 { 2275 return Torque.getDatabaseMap(DATABASE_NAME).getTable(TABLE_NAME); 2276 } 2277 2278 private static void setDbName(Criteria crit) 2279 { 2280 if (crit.getDbName() == Torque.getDefaultDB()) 2284 { 2285 crit.setDbName(DATABASE_NAME); 2286 } 2287 } 2288} 2289
| Popular Tags
|