PageRenderTime 60ms CodeModel.GetById 20ms RepoModel.GetById 0ms app.codeStats 0ms

/src/mpv5/db/common/Context.java

http://mp-rechnungs-und-kundenverwaltung.googlecode.com/
Java | 1786 lines | 1302 code | 187 blank | 297 comment | 105 complexity | f3af97773d126fe701ae97555a0d949a MD5 | raw file
Possible License(s): LGPL-3.0, Apache-2.0, GPL-3.0, GPL-2.0, AGPL-3.0, JSON, BSD-3-Clause 
    

  1. package mpv5.db.common;
    2. 

  2. 

  3. import java.io.Serializable;
    4. 

  4. import java.util.ArrayList;
    5. 

  5. import java.util.Arrays;
    6. 

  6. import java.util.HashMap;
    7. 

  7. import java.util.List;
    8. 

  8. import java.util.Map;
    9. 

  9. import mpv5.db.objects.Account;
    10. 

  10. import mpv5.db.objects.ActivityList;
    11. 

  11. import mpv5.db.objects.ActivityListSubItem;
    12. 

  12. import mpv5.db.objects.Address;
    13. 

  13. import mpv5.db.objects.Company;
    14. 

  14. import mpv5.db.objects.Contact;
    15. 

  15. import mpv5.db.objects.Conversation;
    16. 

  16. import mpv5.db.objects.Expense;
    17. 

  17. import mpv5.db.objects.Favourite;
    18. 

  18. import mpv5.db.objects.FileToContact;
    19. 

  19. import mpv5.db.objects.Group;
    20. 

  20. import mpv5.db.objects.HistoryItem;
    21. 

  21. import mpv5.db.objects.UserProperty;
    22. 

  22. import mpv5.db.objects.Schedule;
    23. 

  23. import mpv5.db.objects.FileToItem;
    24. 

  24. import mpv5.db.objects.FileToProduct;
    25. 

  25. import mpv5.db.objects.Item;
    26. 

  26. import mpv5.db.objects.MailMessage;
    27. 

  27. import mpv5.db.objects.MassprintRules;
    28. 

  28. import mpv5.db.objects.Product;
    29. 

  29. import mpv5.db.objects.ProductGroup;
    30. 

  30. import mpv5.db.objects.ProductList;
    31. 

  31. import mpv5.db.objects.ProductOrder;
    32. 

  32. import mpv5.db.objects.ProductOrderSubItem;
    33. 

  33. import mpv5.db.objects.ProductPrice;
    34. 

  34. import mpv5.db.objects.ProductlistSubItem;
    35. 

  35. import mpv5.db.objects.ProductsToSuppliers;
    36. 

  36. import mpv5.db.objects.Reminder;
    37. 

  37. import mpv5.db.objects.Revenue;
    38. 

  38. import mpv5.db.objects.ScheduleTypes;
    39. 

  39. import mpv5.db.objects.Stage;
    40. 

  40. import mpv5.db.objects.SubItem;
    41. 

  41. import mpv5.db.objects.Tax;
    42. 

  42. import mpv5.db.objects.Template;
    43. 

  43. import mpv5.pluginhandling.Plugin;
    44. 

  44. import mpv5.db.objects.User;
    45. 

  45. import mpv5.db.objects.ValueProperty;
    46. 

  46. import mpv5.db.objects.WSContactsMapping;
    47. 

  47. import mpv5.db.objects.WSItemsMapping;
    48. 

  48. import mpv5.db.objects.WebShop;
    49. 

  49. import mpv5.logging.Log;
    50. 

  50. import mpv5.pluginhandling.UserPlugin;
    51. 

  51. import mpv5.usermanagement.MPSecurityManager;
    52. 

  52. import mpv5.utils.text.RandomText;
    53. 

  53. import mpv5.utils.xml.XMLReader;
    54. 

  54. 

  55. /**
    56. 

  56.  *
    57. 

  57.  * Context controls Database Queries for all native MP {@link DatabaseObject}s
    58. 

  58.  */
    59. 

  59. public class Context implements Serializable {
    60. 

  60. 

  61.     //********** tablenames ****************************************************
    62. 

  62.     public static String IDENTITY_CONTACTS = "contacts";
    63. 

  63.     public static String IDENTITY_USERS = "users";
    64. 

  64.     public static String IDENTITY_ITEMS = "items";
    65. 

  65.     public static String IDENTITY_SUBITEMS = "subitems";
    66. 

  66.     public static String IDENTITY_LANGUAGES = "languages";
    67. 

  67.     public static String IDENTITY_COUNTRIES = "countries";
    68. 

  68.     public static String IDENTITY_PRODUCTS = "products";
    69. 

  69.     public static String IDENTITY_FILES = "files";
    70. 

  70.     public static String IDENTITY_LOCK = "tablelock";
    71. 

  71.     public static String IDENTITY_FAVS = "favourites";
    72. 

  72.     public static String IDENTITY_ADDRESS = "addresses";
    73. 

  73.     public static String IDENTITY_GROUPS = "groups";
    74. 

  74.     public static String IDENTITY_PGROUPS = "productgroups";
    75. 

  75.     public static String IDENTITY_SCHEDULE = "schedule";
    76. 

  76.     public static String IDENTITY_SCHEDULE_TYPES = "scheduletypes";
    77. 

  77.     public static String IDENTITY_HISTORY = "history";
    78. 

  78.     public static String IDENTITY_FILES_TO_CONTACTS = "filestocontacts";
    79. 

  79.     public static String IDENTITY_FILES_TO_PRODUCTS = "filestoproducts";
    80. 

  80.     public static String IDENTITY_SEARCHINDEX = "searchindex";
    81. 

  81.     public static String IDENTITY_PLUGINS_TO_USERS = "pluginstousers";
    82. 

  82.     public static String IDENTITY_TEMPLATES_TO_USERS = "templatestousers";
    83. 

  83.     public static String IDENTITY_PLUGINS = "plugins";
    84. 

  84.     public static String IDENTITY_PROPERTIES_TO_USERS = "userproperties";
    85. 

  85.     public static String IDENTITY_ACCOUNTS = "accounts";
    86. 

  86.     public static String IDENTITY_ITEMS_TO_ACCOUNTS = "itemstoaccounts";
    87. 

  87.     public static String IDENTITY_PRODUCTSLISTITEMS = "productlistitems";
    88. 

  88.     public static String IDENTITY_PRODUCTSLIST = "productlists";
    89. 

  89.     public static String IDENTITY_FORMATS_T_USERS = "formatstousers";
    90. 

  90.     public static String IDENTITY_FILES_TO_ITEMS = "filestoitems";
    91. 

  91.     public static String IDENTITY_MAIL = "mails";
    92. 

  92.     public static String IDENTITY_TAX = "tax";
    93. 

  93.     public static String IDENTITY_COMPANIES = "comps";
    94. 

  94.     public static String IDENTITY_GLOBALSETTINGS = "globalsettings";
    95. 

  95.     public static String IDENTITY_WEBSHOPS = "webshops";
    96. 

  96.     public static String IDENTITY_WSMAPPING = "wscontactsmapping";
    97. 

  97.     public static String IDENTITY_WSIMAPPING = "wsitemsmapping";
    98. 

  98.     public static String IDENTITY_TEMPLATES = "templates";
    99. 

  99.     public static String IDENTITY_REMINDERS = "reminders";
    100. 

  100.     public static String IDENTITY_STAGES = "stages";
    101. 

  101.     public static String IDENTITY_REVENUE = "revenues";
    102. 

  102.     public static String IDENTITY_EXPENSE = "expenses";
    103. 

  103.     public static String IDENTITY_PRODUCTS_TO_SUPPLIERS = "productstosuppliers";
    104. 

  104.     public static String IDENTITY_VALUE_PROPERTIES = "valueproperties";
    105. 

  105.     public static String IDENTITY_CONVERSATION = "conversations";
    106. 

  106.     public static String IDENTITY_PRODUCT_PRICES = "productprices";
    107. 

  107.     public static String IDENTITY_ACTIVITYLISTITEMS = "activitylistitems";
    108. 

  108.     public static String IDENTITY_ACTIVITYLIST = "activitylists";
    109. 

  109.     public static String IDENTITY_MASSPRINT = "massprintrules";
    110. 

  110.     public static String IDENTITY_PRODUCTORDER = "productorders";
    111. 

  111.     public static String IDENTITY_PRODUCTORDERSUBITEM = "productordersubitems";
    112. 

  112.     //********** identity classes **********************************************
    113. 

  113.     private static Class<Contact> IDENTITY_CONTACTS_CLASS = Contact.class;
    114. 

  114.     private static Class<Address> IDENTITY_ADDRESS_CLASS = Address.class;
    115. 

  115.     private static Class<User> IDENTITY_USERS_CLASS = User.class;
    116. 

  116.     private static Class<Item> IDENTITY_ITEMS_CLASS = Item.class;
    117. 

  117.     private static Class<FileToContact> IDENTITY_CONTACTS_FILES_CLASS = FileToContact.class;
    118. 

  118.     private static Class<FileToItem> IDENTITY_ITEM_FILES_CLASS = FileToItem.class;
    119. 

  119.     private static Class<HistoryItem> IDENTITY_HISTORY_ITEMS_CLASS = HistoryItem.class;
    120. 

  120.     private static Class<SubItem> IDENTITY_SUBITEMS_CLASS = SubItem.class;
    121. 

  121.     private static Class<UserPlugin> IDENTITY_USER_PLUGINS_CLASS = UserPlugin.class;
    122. 

  122.     private static Class<Plugin> IDENTITY_PLUGINS_CLASS = Plugin.class;
    123. 

  123.     private static Class<UserProperty> IDENTITY_PROPERTIES_CLASS = UserProperty.class;
    124. 

  124.     private static Class<Account> IDENTITY_ACCOUNTS_CLASS = Account.class;
    125. 

  125.     private static Class<ProductlistSubItem> IDENTITY_ITEMSLIST_CLASS = ProductlistSubItem.class;
    126. 

  126.     private static Class<MailMessage> IDENTITY_MAILS_CLASS = MailMessage.class;
    127. 

  127.     private static Class<Product> IDENTITY_PRODUCTS_CLASS = Product.class;
    128. 

  128.     private static Class<Group> IDENTITY_GROUPS_CLASS = Group.class;
    129. 

  129.     private static Class<Company> IDENTITY_COMPANY_CLASS = Company.class;
    130. 

  130.     private static Class<ProductGroup> IDENTITY_PGROUPS_CLASS = ProductGroup.class;
    131. 

  131.     private static Class<FileToProduct> IDENTITY_PRODUCTS_FILES_CLASS = FileToProduct.class;
    132. 

  132.     private static Class<WebShop> IDENTITY_WEBSHOP_CLASS = WebShop.class;
    133. 

  133.     private static Class<Template> IDENTITY_TEMPLATE_CLASS = Template.class;
    134. 

  134.     private static Class<Reminder> IDENTITY_REMINDER_CLASS = Reminder.class;
    135. 

  135.     private static Class<Stage> IDENTITY_STAGE_CLASS = Stage.class;
    136. 

  136.     private static Class<ValueProperty> IDENTITY_VALUEPROPERTY_CLASS = ValueProperty.class;
    137. 

  137.     private static Class<ProductPrice> IDENTITY_PRODUCTPRICE_CLASS = ProductPrice.class;
    138. 

  138.     private static Class<Favourite> IDENTITY_FAVOURITE_CLASS = Favourite.class;
    139. 

  139.     private static Class<Tax> IDENTITY_TAX_CLASS = Tax.class;
    140. 

  140.     private static Class<WSContactsMapping> IDENTITY_WSCONTACTSMAPPING_CLASS = WSContactsMapping.class;
    141. 

  141.     private static Class<WSItemsMapping> IDENTITY_WSITEMSMAPPING_CLASS = WSItemsMapping.class;
    142. 

  142.     private static Class<Expense> IDENTITY_EXPENSE_CLASS = Expense.class;
    143. 

  143.     private static Class<ProductList> IDENTITY_PRODUCTLIST_CLASS = ProductList.class;
    144. 

  144.     private static Class<ProductsToSuppliers> IDENTITY_PRODUCTSTOSUPPLIERS_CLASS = ProductsToSuppliers.class;
    145. 

  145.     private static Class<Conversation> IDENTITY_CONVERSATION_CLASS = Conversation.class;
    146. 

  146.     private static Class<Schedule> IDENTITY_SCHEDULE_CLASS = Schedule.class;
    147. 

  147.     private static Class<ScheduleTypes> IDENTITY_SCHEDULETYPES_CLASS = ScheduleTypes.class;
    148. 

  148.     private static Class<ActivityListSubItem> IDENTITY_ACTIVITYITEMSLIST_CLASS = ActivityListSubItem.class;
    149. 

  149.     private static Class<ActivityList> IDENTITY_ACTIVITYLIST_CLASS = ActivityList.class;
    150. 

  150.     private static Class<MassprintRules> IDENTITY_MASSPRINT_CLASS = MassprintRules.class;
    151. 

  151.     private static Class<ProductOrder> IDENTITY_PRODUCTORDER_CLASS = ProductOrder.class;
    152. 

  152.     private static Class<ProductOrderSubItem> IDENTITY_PRODUCTORDERSUBITEM_CLASS = ProductOrderSubItem.class;
    153. 

  153.     
    154. 

  154.     //********** unique constraints *******************************************
    155. 

  155.     public static String UNIQUECOLUMNS_USER = "cname";
    156. 

  156.     public static String UNIQUECOLUMNS_ITEMS = "cname";
    157. 

  157.     public static String UNIQUECOLUMNS_GROUPS = "cname";
    158. 

  158.     public static String UNIQUECOLUMNS_DEFAULT = "cname";
    159. 

  159.     public static String DETAIL_CONTACT_SEARCH = "prename,cname,street,city,country,notes";
    160. 

  160.     private static final long serialVersionUID = 1L;
    161. 

  161. 

  162.     //********** conditions ****************************************************
    163. 

  163.     private boolean isCompany = false;
    164. 

  164.     private boolean isCustomer = false;
    165. 

  165.     private boolean isManufacturer = false;
    166. 

  166.     private boolean isSupplier = false;
    167. 

  167.     private Integer itemStatus = null;
    168. 

  168.     private Integer itemType = null;
    169. 

  169.     public static final String CONDITION_DEFAULT = "%%tablename%%" + "." + "IDS>0";
    170. 

  170.     public static final String CONDITION_CONTACTS_COMPANY = IDENTITY_CONTACTS + "." + "iscompany";
    171. 

  171.     public static final String CONDITION_CONTACTS_CUSTOMER = IDENTITY_CONTACTS + "." + "iscustomer";
    172. 

  172.     public static final String CONDITION_CONTACTS_MANUFACTURER = IDENTITY_CONTACTS + "." + "ismanufacturer";
    173. 

  173.     public static final String CONDITION_CONTACTS_SUPPLIER = IDENTITY_CONTACTS + "." + "issupplier";
    174. 

  174.     public static final String CONDITION_ITEMS_TYPE = IDENTITY_ITEMS + "." + "inttype";
    175. 

  175.     public static final String CONDITION_ITEMS_STATUS = IDENTITY_ITEMS + "." + "intstatus";
    176. 

  176.     //********** searchfields **************************************************
    177. 

  177.     public static final String SEARCH_NAME = "cname";
    178. 

  178. //    public static final String SEARCH_CONTACT_NUMBER = "cnumber";
    179. 

  179. //    public static final String SEARCH_CONTACT_CITY = "city";
    180. 

  180.     //********** defaults ******************************************************
    181. 

  181.     public static String DEFAULT_SUBID = "ids, cname";
    182. 

  182.     public static String DEFAULT_CONTACT_SEARCH = "ids, cnumber, cname, city, street";
    183. 

  183.     public static String DEFAULT_USER_SEARCH = "ids, cname, mail, lastlogdate";
    184. 

  184.     public static String DEFAULT_ITEM_SEARCH = "ids, cname, dateadded, netvalue";
    185. 

  185.     public static String DEFAULT_PRODUCT_SEARCH = "ids, cnumber, cname, description";
    186. 

  186.     public static String DEFAULT_ACTIVITYLIST_SEARCH = "DISTINCT ids,cname";
    187. 

  187.     public static String DEFAULT_PRODUCTSLIST_SEARCH = "DISTINCT ids,cname,description";
    188. 

  188.     //********** table fields ********************************************************
    189. 

  189.     public static String DETAILS_CONTACTS = IDENTITY_CONTACTS + "." + "IDS," + IDENTITY_CONTACTS + "." + "CNUMBER,"
    190. 

  190.             + IDENTITY_CONTACTS + "." + "TITLE," + IDENTITY_CONTACTS + "." + "PRENAME," + IDENTITY_CONTACTS + "." + "CNAME,"
    191. 

  191.             + IDENTITY_CONTACTS + "." + "STREET," + IDENTITY_CONTACTS + "." + "ZIP," + IDENTITY_CONTACTS + "." + "CITY,"
    192. 

  192.             + IDENTITY_CONTACTS + "." + "MAINPHONE," + IDENTITY_CONTACTS + "." + "FAX," + IDENTITY_CONTACTS + "." + "MOBILEPHONE,"
    193. 

  193.             + IDENTITY_CONTACTS + "." + "WORKPHONE," + IDENTITY_CONTACTS + "." + "COMPANY," + IDENTITY_CONTACTS + "." + "MAILADDRESS,"
    194. 

  194.             + IDENTITY_CONTACTS + "." + "WEBSITE," + IDENTITY_CONTACTS + "." + "NOTES,"
    195. 

  195.             + IDENTITY_CONTACTS + "." + "TAXNUMBER";
    196. 

  196.     public static String DETAILS_PRODUCTS =
    197. 

  197.             IDENTITY_PRODUCTS + "." + "ids,"
    198. 

  198.             + IDENTITY_PRODUCTS + "." + "cnumber,"
    199. 

  199.             + IDENTITY_PRODUCTS + "." + "cname,"
    200. 

  200.             + IDENTITY_PRODUCTS + "." + "ean,"
    201. 

  201.             + IDENTITY_PRODUCTS + "." + "reference,"
    202. 

  202.             + IDENTITY_CONTACTS + "." + "cname,"
    203. 

  203.             + IDENTITY_GROUPS + "." + "cname,"
    204. 

  204.             + IDENTITY_PRODUCTS + "." + "internalnetvalue,"
    205. 

  205.             + IDENTITY_PRODUCTS + "." + "externalnetvalue,"
    206. 

  206.             + IDENTITY_PRODUCTS + "." + "stockvalue";
    207. 

  207.     public static String DETAILS_USERS = IDENTITY_USERS + "." + "IDS," + IDENTITY_USERS + "." + "CNAME,"
    208. 

  208.             + IDENTITY_USERS + "." + "fullname,"
    209. 

  209.             + IDENTITY_USERS + "." + "mail,"
    210. 

  210.             + IDENTITY_USERS + "." + "isenabled,"
    211. 

  211.             + IDENTITY_USERS + "." + "isloggedin";
    212. 

  212.     public static String DETAILS_ITEMS =
    213. 

  213.             IDENTITY_ITEMS + "." + "IDS,"
    214. 

  214.             + IDENTITY_ITEMS + "." + "CNAME,"
    215. 

  215.             + IDENTITY_ITEMS + "." + "dateadded,"
    216. 

  216.             + IDENTITY_ITEMS + "." + "netvalue,"
    217. 

  217.             + IDENTITY_ITEMS + "." + "taxvalue, "
    218. 

  218.             + IDENTITY_ITEMS + "." + "datetodo";
    219. 

  219.     public static String DETAILS_JOURNAL =  Context.IDENTITY_ITEMS   + "." + "IDS," + Context.IDENTITY_CONTACTS + "." + "cname," +    Context.IDENTITY_CONTACTS + "." + "prename,"  + Context.IDENTITY_CONTACTS + "." + "street,"   + Context.IDENTITY_CONTACTS + "." + "city,"     + Context.IDENTITY_CONTACTS + "." + "country,"  + Context.IDENTITY_ITEMS   + "." + "{date},"    + Context.IDENTITY_GROUPS + "." + "CNAME," + Context.IDENTITY_ACCOUNTS + "." + "cname," + Context.IDENTITY_ITEMS   + "." + "CNAME," + Context.IDENTITY_ITEMS   + "." + "inttype," + Context.IDENTITY_ITEMS   + "." + "intstatus," + Context.IDENTITY_ITEMS   + "." + "netvalue,"   + Context.IDENTITY_ITEMS   + "." + "taxvalue, ("      + Context.IDENTITY_ITEMS   + "." + "netvalue +" + Context.IDENTITY_ITEMS   + "." + "taxvalue)";
    220. 

  220.     public static String DETAILS_JOURNAL2 = Context.IDENTITY_REVENUE + "." + "IDS," + Context.IDENTITY_GROUPS +   "." + "reserve2," + Context.IDENTITY_GROUPS + "."   + "reserve2," + Context.IDENTITY_GROUPS + "."   + "reserve2," + Context.IDENTITY_GROUPS   + "." + "reserve2," + Context.IDENTITY_GROUPS   + "." + "reserve2," + Context.IDENTITY_REVENUE + "." + "dateadded," + Context.IDENTITY_GROUPS + "." + "CNAME," + Context.IDENTITY_ACCOUNTS + "." + "cname," + Context.IDENTITY_REVENUE + "." + "CNAME," + Context.IDENTITY_REVENUE + "." + "ids,"     + Context.IDENTITY_REVENUE + "." + "ispaid,"    + Context.IDENTITY_REVENUE + "." + "netvalue, (" + Context.IDENTITY_REVENUE + "." + "brutvalue-" + Context.IDENTITY_REVENUE + "." + "netvalue)," + Context.IDENTITY_REVENUE + "." + "brutvalue";
    221. 

  221.     public static String DETAILS_JOURNAL3 = Context.IDENTITY_EXPENSE + "." + "IDS," + Context.IDENTITY_GROUPS +   "." + "reserve2," + Context.IDENTITY_GROUPS + "."   + "reserve2," + Context.IDENTITY_GROUPS + "."   + "reserve2," + Context.IDENTITY_GROUPS   + "." + "reserve2," + Context.IDENTITY_GROUPS   + "." + "reserve2," + Context.IDENTITY_EXPENSE + "." + "{date},"    + Context.IDENTITY_GROUPS + "." + "CNAME," + Context.IDENTITY_ACCOUNTS + "." + "cname," + Context.IDENTITY_EXPENSE + "." + "CNAME," + Context.IDENTITY_EXPENSE + "." + "ids,"     + Context.IDENTITY_EXPENSE + "." + "ispaid,"    + Context.IDENTITY_EXPENSE + "." + "netvalue, (" + Context.IDENTITY_EXPENSE + "." + "brutvalue-" + Context.IDENTITY_EXPENSE + "." + "netvalue)," + Context.IDENTITY_EXPENSE + "." + "brutvalue";
    222. 

  222.     public static String DETAILS_HISTORY = getHistory().getDbIdentity() + ".ids, " + getHistory().getDbIdentity() + ".cname, " + getHistory().getDbIdentity() + ".username, " + Context.getGroup().getDbIdentity() + ".cname," + Context.getHistory().getDbIdentity() + ".dateadded";
    223. 

  223.     public static String DETAILS_FILES_TO_CONTACTS = Context.getFiles().getDbIdentity() + ".cname," + getFilesToContacts().getDbIdentity() + ".cname, " + Context.getFiles().getDbIdentity() + ".dateadded," + Context.getFilesToContacts().getDbIdentity() + ".description," + Context.getFilesToContacts().getDbIdentity() + ".intsize," + Context.getFilesToContacts().getDbIdentity() + ".mimetype";
    224. 

  224.     public static String DETAILS_FILES_TO_ITEMS = Context.getFiles().getDbIdentity() + ".cname," + getFilesToItems().getDbIdentity() + ".cname, " + Context.getFiles().getDbIdentity() + ".dateadded," + Context.getFilesToItems().getDbIdentity() + ".description," + Context.getFilesToItems().getDbIdentity() + ".intsize," + Context.getFilesToItems().getDbIdentity() + ".mimetype";
    225. 

  225.     public static String DETAILS_FILES_TO_PRODUCTS = Context.getFiles().getDbIdentity() + ".cname," + getFilesToProducts().getDbIdentity() + ".cname, " + Context.getFiles().getDbIdentity() + ".dateadded," + Context.getFilesToProducts().getDbIdentity() + ".description," + Context.getFilesToProducts().getDbIdentity() + ".intsize," + Context.getFilesToProducts().getDbIdentity() + ".mimetype";
    226. 

  226.     public static String DETAILS_MASSPRINT =
    227. 

  227.             Context.IDENTITY_MASSPRINT + "." + "IDS,"
    228. 

  228.             + Context.IDENTITY_MASSPRINT + "." + "cname,"
    229. 

  229.             + Context.IDENTITY_MASSPRINT + "." + "inttype,"
    230. 

  230.             + Context.IDENTITY_MASSPRINT + "." + "dateadded";
    231. 

  231. //    public static String DETAILS_FILES_TO_TEMPLATES = Context.getTemplate().getDbIdentity() + ".ids," + getTemplate().getDbIdentity() + ".cname, " + Context.getTemplate().getDbIdentity() + ".dateadded," + Context.getTemplate().getDbIdentity() + ".intsize," + Context.getTemplate().getDbIdentity() + ".mimetype";
    232. 

  232. //    public static String DETAILS_TEMPLATES = Context.getTemplate().getDbIdentity() + ".ids," + getTemplate().getDbIdentity() + ".cname, " + Context.getTemplate().getDbIdentity() + ".mimetype," + " groups0.cname";
    233. 

  233.     private static final Map<String, String> FOREIGN_KEY_ALIASES = new HashMap<String, String>();
    234. 

  234. 

  235.     /**
    236. 

  236.      * Find an alias (eg originalproducstids is an alias for productsids in table subitems)
    237. 

  237.      * @param context
    238. 

  238.      * @param exct
    239. 

  239.      * @return 
    240. 

  240.      */
    241. 

  241.     public static String getAliasFor(Context context, Context exct) {
    242. 

  242.         if (FOREIGN_KEY_ALIASES.containsKey(context + "@" + exct)) {
    243. 

  243.             return FOREIGN_KEY_ALIASES.get(context + "@" + exct);
    244. 

  244.         } else {
    245. 

  245.             return context.getDbIdentity();
    246. 

  246.         }
    247. 

  247.     }
    248. 

  248.     //**************************************************************************
    249. 

  249. 

  250.     /**
    251. 

  251.      * Contexts which can have an export template
    252. 

  252.      * @return
    253. 

  253.      */
    254. 

  254.     public static ArrayList<Context> getTemplateableContexts() {
    255. 

  255.         ArrayList<Context> list = new ArrayList<Context>();
    256. 

  256.         list.add(getItem(null, null));
    257. 

  257.         list.add(getInvoice());
    258. 

  258.         list.add(getOrder());
    259. 

  259.         list.add(getOffer());
    260. 

  260.         list.add(getProduct());
    261. 

  261.         list.add(getReminder());
    262. 

  262.         list.add(getActivityList());
    263. 

  263.         return list;
    264. 

  264.     }
    265. 

  265. 

  266.     /**
    267. 

  267.      * Contexts which are protected by the Securitymanager
    268. 

  268.      * @return
    269. 

  269.      */
    270. 

  270.     public static ArrayList<Context> getSecuredContexts() {
    271. 

  271.         ArrayList<Context> list = new ArrayList<Context>();
    272. 

  272.         list.add(getContactsCompanies());
    273. 

  273. //        list.add(getUser()); Needs to be non-secure, to update user details on close
    274. 

  274.         list.add(getCustomer());
    275. 

  275.         list.add(getManufacturer());
    276. 

  276.         list.add(getSupplier());
    277. 

  277.         list.add(getAddress());
    278. 

  278.         list.add(getItem(null, null));
    279. 

  279.         list.add(getInvoice());
    280. 

  280.         list.add(getOrder());
    281. 

  281.         list.add(getOffer());
    282. 

  282.         list.add(getSchedule());
    283. 

  283.         list.add(getCountries());
    284. 

  284.         list.add(getContact());
    285. 

  285.         list.add(getProduct());
    286. 

  286.         list.add(getAccounts());
    287. 

  287.         list.add(getCompany());
    288. 

  288.         list.add(getWebShop());
    289. 

  289.         list.add(getTemplate());
    290. 

  290.         list.add(getReminder());
    291. 

  291.         list.add(getSubItem());
    292. 

  292.         list.add(getProductOrderSubitem());
    293. 

  293.         list.add(getProductOrder());
    294. 

  294.         list.add(getProductPrice());
    295. 

  295. 

  296.         return list;
    297. 

  297.     }
    298. 

  298. 

  299.     /**
    300. 

  300.      * Contexts which can get cached
    301. 

  301.      * @return
    302. 

  302.      */
    303. 

  303.     public static ArrayList<Context> getCacheableContexts() {
    304. 

  304.         return cacheableContexts;
    305. 

  305.     }
    306. 

  306.     private static ArrayList<Context> cacheableContexts = new ArrayList<Context>(Arrays.asList(new Context[]{
    307. 

  307.                 getContact(),
    308. 

  308.                 getFavourite(),
    309. 

  309.                 getUser(),
    310. 

  310.                 getAddress(),
    311. 

  311.                 getItem(null, null),
    312. 

  312.                 getSubItem(),
    313. 

  313.                 getGroup(),
    314. 

  314.                 getSchedule(),
    315. 

  315.                 getFilesToContacts(),
    316. 

  316.                 getFilesToItems(),
    317. 

  317.                 getFilesToProducts(),
    318. 

  318.                 getProduct(),
    319. 

  319.                 getAccounts(),
    320. 

  320.                 getMessage(),
    321. 

  321.                 getProductListItems(),
    322. 

  322.                 getCompany(),
    323. 

  323.                 getWebShop(),
    324. 

  324.                 getTemplate(),
    325. 

  325.                 getReminder(),
    326. 

  326.                 getStage(),
    327. 

  327.                 getTaxes(),
    328. 

  328.                 getProductGroup(),
    329. 

  329.                 getProductPrice(),
    330. 

  330.                 getActivityListItems(),
    331. 

  331.                 getProductOrderSubitem(),
    332. 

  332.                 getProductOrder()
    333. 

  333.             }));
    334. 

  334. 

  335.     /**
    336. 

  336.      * Contexts which are groupable
    337. 

  337.      * @return
    338. 

  338.      */
    339. 

  339.     public static ArrayList<Context> getGroupableContexts() {
    340. 

  340.         ArrayList<Context> list = new ArrayList<Context>();
    341. 

  341.         list.add(getContactsCompanies());
    342. 

  342.         list.add(getCustomer());
    343. 

  343.         list.add(getManufacturer());
    344. 

  344.         list.add(getSupplier());
    345. 

  345.         list.add(getItem(null, null));
    346. 

  346.         list.add(getInvoice());
    347. 

  347.         list.add(getOrder());
    348. 

  348.         list.add(getOffer());
    349. 

  349.         list.add(getSchedule());
    350. 

  350.         list.add(getContact());
    351. 

  351.         list.add(getProduct());
    352. 

  352.         list.add(getAccounts());
    353. 

  353.         list.add(getMessage());
    354. 

  354.         list.add(getProductListItems());
    355. 

  355.         list.add(getSearchIndex());
    356. 

  356.         list.add(getGlobalSettings());
    357. 

  357.         list.add(getCompany());
    358. 

  358.         list.add(getWebShop());
    359. 

  359.         list.add(getTemplate());
    360. 

  360.         list.add(getReminder());
    361. 

  361.         list.add(getStage());
    362. 

  362.         list.add(getExpense());
    363. 

  363.         list.add(getRevenue());
    364. 

  364.         list.add(getTaxes());
    365. 

  365.         list.add(getProductPrice());
    366. 

  366.         list.add(getActivityListItems());
    367. 

  367.         list.add(getProductOrderSubitem());
    368. 

  368.         list.add(getProductOrder());
    369. 

  369.         return list;
    370. 

  370.     }
    371. 

  371. 

  372.     /**
    373. 

  373.      * Contexts which can be moved to trash rather than delete
    374. 

  374.      * @return
    375. 

  375.      */
    376. 

  376.     public static ArrayList<Context> getTrashableContexts() {
    377. 

  377.         ArrayList<Context> list = new ArrayList<Context>();
    378. 

  378.         list.add(getContactsCompanies());
    379. 

  379.         list.add(getCustomer());
    380. 

  380.         list.add(getManufacturer());
    381. 

  381.         list.add(getSupplier());
    382. 

  382.         list.add(getItem(null, null));
    383. 

  383.         list.add(getInvoice());
    384. 

  384.         list.add(getOrder());
    385. 

  385.         list.add(getOffer());
    386. 

  386.         list.add(getSubItem());
    387. 

  387.         list.add(getContact());
    388. 

  388.         list.add(getProduct());
    389. 

  389.         list.add(getFiles());
    390. 

  390.         list.add(getExpense());
    391. 

  391.         list.add(getRevenue());
    392. 

  392.         list.add(getActivityList());
    393. 

  393.         list.add(getProductOrderSubitem());
    394. 

  394.         list.add(getProductOrder());
    395. 

  395.         return list;
    396. 

  396.     }
    397. 

  397. 

  398.     /**
    399. 

  399.      * Contexts which are monitored by the History
    400. 

  400.      * @return
    401. 

  401.      */
    402. 

  402.     public static ArrayList<Context> getArchivableContexts() {
    403. 

  403.         return getSecuredContexts();
    404. 

  404.     }
    405. 

  405. 

  406.     /**
    407. 

  407.      * Contexts which can be used in a user's Search
    408. 

  408.      * @return
    409. 

  409.      */
    410. 

  410.     public static ArrayList<Context> getSearchableContexts() {
    411. 

  411.         ArrayList<Context> list = new ArrayList<Context>();
    412. 

  412.         list.add(getSubItem());
    413. 

  413.         list.add(getItem());
    414. 

  414.         list.add(getSchedule());
    415. 

  415.         list.add(getContact());
    416. 

  416.         list.add(getProduct());
    417. 

  417.         list.add(getProductOrderSubitem());
    418. 

  418.         list.add(getProductOrder());
    419. 

  419. ////        list.add(getAccounts());
    420. 

  420.         return list;
    421. 

  421.     }
    422. 

  422. 

  423.     /**
    424. 

  424.      * LOckable Contexts
    425. 

  425.      * @return
    426. 

  426.      */
    427. 

  427.     public static ArrayList<Context> getLockableContexts() {
    428. 

  428.         ArrayList<Context> list = new ArrayList<Context>();
    429. 

  429. //        list.add(getUser());
    430. 

  430.         list.add(getItem(null, null));
    431. 

  431.         list.add(getSchedule());
    432. 

  432.         list.add(getContact());
    433. 

  433.         list.add(getProduct());
    434. 

  434.         list.add(getContactsCompanies());
    435. 

  435.         list.add(getCustomer());
    436. 

  436.         list.add(getSupplier());
    437. 

  437.         list.add(getManufacturer());
    438. 

  438.         list.add(getWebShop());
    439. 

  439.         return list;
    440. 

  440.     }
    441. 

  441. 

  442.     /**
    443. 

  443.      * Importable Contexts
    444. 

  444.      * @return
    445. 

  445.      */
    446. 

  446.     public static ArrayList<Context> getImportableContexts() {
    447. 

  447.         ArrayList<Context> list = new ArrayList<Context>();
    448. 

  448.         list.add(getItem(null, null));
    449. 

  449.         list.add(getMessage());
    450. 

  450.         list.add(getContact());
    451. 

  451.         list.add(getProduct());
    452. 

  452.         list.add(getAccounts());
    453. 

  453.         list.add(getGroup());
    454. 

  454.         return list;
    455. 

  455.     }
    456. 

  456. 

  457.     /**
    458. 

  458.      *
    459. 

  459.      * @return All availbale contexts
    460. 

  460.      */
    461. 

  461.     public static ArrayList<Context> getContexts() {
    462. 

  462.         return allContexts;
    463. 

  463.     }
    464. 

  464.     /**
    465. 

  465.      * A list of all available contexts
    466. 

  466.      */
    467. 

  467.     private static ArrayList<Context> allContexts = new ArrayList<Context>(Arrays.asList(new Context[]{
    468. 

  468.                 getContactsCompanies(),
    469. 

  469.                 getContact(),
    470. 

  470.                 getCustomer(),
    471. 

  471.                 getFavourite(),
    472. 

  472.                 getFiles(),
    473. 

  473.                 getLanguage(),
    474. 

  474.                 getLock(),
    475. 

  475.                 getManufacturer(),
    476. 

  476.                 getSupplier(),
    477. 

  477.                 getUser(),
    478. 

  478.                 getAddress(),
    479. 

  479.                 getItem(null, null),
    480. 

  480.                 getInvoice(),
    481. 

  481.                 getOrder(),
    482. 

  482.                 getOffer(),
    483. 

  483.                 getSubItem(),
    484. 

  484.                 getGroup(),
    485. 

  485.                 getSchedule(),
    486. 

  486.                 getFilesToContacts(),
    487. 

  487.                 getHistory(),
    488. 

  488.                 getCountries(),
    489. 

  489.                 getProduct(),
    490. 

  490.                 getPlugins(),
    491. 

  491.                 getPluginsToUsers(),
    492. 

  492.                 getTemplatesToUsers(),
    493. 

  493.                 getUserProperties(),
    494. 

  494.                 getAccounts(),
    495. 

  495.                 getItemsToAccounts(),
    496. 

  496.                 getMessage(),
    497. 

  497.                 getProductListItems(),
    498. 

  498.                 getFormats(),
    499. 

  499.                 getTaxes(),
    500. 

  500.                 getGlobalSettings(),
    501. 

  501.                 getCompany(),
    502. 

  502.                 getWebShop(),
    503. 

  503.                 getWebShopItemMapping(),
    504. 

  504.                 getWebShopContactMapping(),
    505. 

  505.                 getTemplate(),
    506. 

  506.                 getReminder(),
    507. 

  507.                 getStage(),
    508. 

  508.                 getProductlist(),
    509. 

  509.                 getExpense(),
    510. 

  510.                 getRevenue(),
    511. 

  511.                 getProductsToSuppliers(),
    512. 

  512.                 getValueProperties(),
    513. 

  513.                 getProductPrice(),
    514. 

  514.                 getMassprint(),
    515. 

  515.                 getProductOrderSubitem(),
    516. 

  516.                 getProductOrder()
    517. 

  517.             }));
    518. 

  518. //    private String[] searchHeaders;
    519. 

  519.     private volatile ArrayList<String[]> references = new ArrayList<String[]>();
    520. 

  520.     private boolean exclusiveConditionsAvailable = false;
    521. 

  521.     private volatile String exclusiveCondition;
    522. 

  522.     private volatile String uniqueColumns;
    523. 

  523.     private volatile int id = -1;
    524. 

  524. 

  525.     /**
    526. 

  526.      * Constructor now private
    527. 

  527.      */
    528. 

  528.     private Context() {
    529. 

  529.     }
    530. 

  530. 

  531.     /**
    532. 

  532.      * Constructs a new Context with a random ID
    533. 

  533.      * @param tablename The name of the table to use
    534. 

  534.      * @param targetObjectClass The class of the {@link DatabaseObject} child to be used with this Context
    535. 

  535.      * @param cacheable If true, the {@link DatabaseObject}s related to this context will be cached
    536. 

  536.      * @param secured If true, the {@link DatabaseObject}s related to this context will be protected by the {@link MPSecurityManager}
    537. 

  537.      * @param importable If true, the {@link DatabaseObject}s related to this context will be importable by the {@link XMLReader}
    538. 

  538.      * @param lockable If true, the {@link DatabaseObject}s related to this context will be loackable to avoid concurrent access
    539. 

  539.      * @param groupable If true, the {@link DatabaseObject}s related to this context will apply to a users group restriction
    540. 

  540.      * @param trashable If true, the {@link DatabaseObject}s related to this context will be moved to the trashbin on delete
    541. 

  541.      * @param archivable If true, actions on the {@link DatabaseObject}s related to this context will be monitored
    542. 

  542.      */
    543. 

  543.     public Context(String tablename, Class targetObjectClass, boolean cacheable,
    544. 

  544.             boolean secured, boolean importable, boolean lockable, boolean groupable,
    545. 

  545.             boolean trashable, boolean archivable) {
    546. 

  546.         setId(Integer.valueOf(RandomText.getNumberText()));
    547. 

  547.         this.setSubID(DEFAULT_SUBID);
    548. 

  548.         this.setDbIdentity(tablename);
    549. 

  549.         this.setIdentityClass(targetObjectClass);
    550. 

  550.         if (archivable) {
    551. 

  551.             getArchivableContexts().add(this);
    552. 

  552.         }
    553. 

  553.         if (cacheable) {
    554. 

  554.             getCacheableContexts().add(this);
    555. 

  555.         }
    556. 

  556.         if (secured) {
    557. 

  557.             getSecuredContexts().add(this);
    558. 

  558.         }
    559. 

  559.         if (importable) {
    560. 

  560.             getImportableContexts().add(this);
    561. 

  561.         }
    562. 

  562.         if (lockable) {
    563. 

  563.             getLockableContexts().add(this);
    564. 

  564.         }
    565. 

  565.         if (groupable) {
    566. 

  566.             getGroupableContexts().add(this);
    567. 

  567.         }
    568. 

  568.         if (trashable) {
    569. 

  569.             getTrashableContexts().add(this);
    570. 

  570.         }
    571. 

  571.         if (archivable) {
    572. 

  572.             getArchivableContexts().add(this);
    573. 

  573.         }
    574. 

  574.     }
    575. 

  575. 

  576.     /**
    577. 

  577.      * Constructs a new Context with a random ID
    578. 

  578.      * @param tablename The name of the table to use
    579. 

  579.      * @param targetObjectClass The class of the {@link DatabaseObject} child to be used with this Context
    580. 

  580.      */
    581. 

  581.     public Context(String tablename, Class targetObjectClass) {
    582. 

  582.         setId(Integer.valueOf(RandomText.getNumberText()));
    583. 

  583.         this.setSubID(DEFAULT_SUBID);
    584. 

  584.         this.setDbIdentity(tablename);
    585. 

  585.         this.setIdentityClass(targetObjectClass);
    586. 

  586.     }
    587. 

  587. 

  588.     /**
    589. 

  589.      * Constructs a new Context with a random ID
    590. 

  590.      * @param targetObjectClass The tablename will be assumed from the Class' simple name
    591. 

  591.      */
    592. 

  592.     public Context(Class targetObjectClass) {
    593. 

  593.         this(targetObjectClass.getSimpleName(), targetObjectClass);
    594. 

  594.     }
    595. 

  595. 

  596.     /**
    597. 

  597.      * Constructs a new Context with a random ID.
    598. 

  598.      * The tablename will be assumed from the targetObject's Class simple name
    599. 

  599.      * @param targetObject
    600. 

  600.      */
    601. 

  601.     public Context(DatabaseObject targetObject) {
    602. 

  602.         setId(Integer.valueOf(RandomText.getNumberText()));
    603. 

  603.         this.setSubID(DEFAULT_SUBID);
    604. 

  604.         this.setDbIdentity(targetObject.getClass().getSimpleName());
    605. 

  605.         this.setIdentityClass(targetObject.getClass());
    606. 

  606.     }
    607. 

  607.     /**
    608. 

  608.      * A default, empty Context without id
    609. 

  609.      */
    610. 

  610.     public static Context DEFAULT = new Context();
    611. 

  611.     private Class identityClass = null;
    612. 

  612.     /*
    613. 

  613.      * The DB Identity name - usually the table
    614. 

  614.      */
    615. 

  615.     private String dbIdentity = null;
    616. 

  616. 

  617.     /*
    618. 

  618.      * The DB Sub Identity name - maybe a column name
    619. 

  619.      */
    620. 

  620.     private String subID = null;
    621. 

  621. 

  622.     /*
    623. 

  623.      * The search default result columns
    624. 

  624.      */
    625. 

  625.     private String defResultFields = null;
    626. 

  626. 

  627.     /**
    628. 

  628.      *
    629. 

  629.      * @return The unique constraints
    630. 

  630.      */
    631. 

  631.     public String getUniqueColumns() {
    632. 

  632.         return uniqueColumns;
    633. 

  633.     }
    634. 

  634. 

  635.     /**
    636. 

  636.      *
    637. 

  637.      * @param customer
    638. 

  638.      * @param supplier
    639. 

  639.      * @param manufacturer
    640. 

  640.      * @param company
    641. 

  641.      */
    642. 

  642.     public void setContactConditions(boolean customer, boolean supplier, boolean manufacturer, boolean company) {
    643. 

  643.         setCustomer(customer);
    644. 

  644.         setSupplier(supplier);
    645. 

  645.         setManufacturer(manufacturer);
    646. 

  646.         setCompany(company);
    647. 

  647.     }
    648. 

  648. 

  649.     /**
    650. 

  650.      * Set conditions to get exclusive data (e.g. customer = false results in all data without any customer)
    651. 

  651.      * @param customer
    652. 

  652.      * @param supplier
    653. 

  653.      * @param manufacturer
    654. 

  654.      * @param company
    655. 

  655.      */
    656. 

  656.     public void setExclusiveContactConditions(boolean customer, boolean supplier, boolean manufacturer, boolean company) {
    657. 

  657. 

  658.         String cond = "    ";
    659. 

  659.         boolean first = true;
    660. 

  660. 

  661.         if (customer) {
    662. 

  662.             if (first) {
    663. 

  663.                 cond += "WHERE ";
    664. 

  664.             }
    665. 

  665.             first = false;
    666. 

  666.             cond += " " + CONDITION_CONTACTS_CUSTOMER + "=1 AND ";
    667. 

  667.         } else {
    668. 

  668.             if (first) {
    669. 

  669.                 cond += "WHERE ";
    670. 

  670.             }
    671. 

  671.             first = false;
    672. 

  672.             cond += " " + CONDITION_CONTACTS_CUSTOMER + "=0 AND ";
    673. 

  673.         }
    674. 

  674.         if (supplier) {
    675. 

  675.             if (first) {
    676. 

  676.                 cond += "WHERE ";
    677. 

  677.             }
    678. 

  678.             first = false;
    679. 

  679.             cond += " " + CONDITION_CONTACTS_SUPPLIER + "=1 AND ";
    680. 

  680.         } else {
    681. 

  681.             if (first) {
    682. 

  682.                 cond += "WHERE ";
    683. 

  683.             }
    684. 

  684.             first = false;
    685. 

  685.             cond += " " + CONDITION_CONTACTS_SUPPLIER + "=0 AND ";
    686. 

  686.         }
    687. 

  687.         if (manufacturer) {
    688. 

  688.             if (first) {
    689. 

  689.                 cond += "WHERE ";
    690. 

  690.             }
    691. 

  691.             first = false;
    692. 

  692.             cond += " " + CONDITION_CONTACTS_MANUFACTURER + "=1 AND ";
    693. 

  693.         } else {
    694. 

  694.             if (first) {
    695. 

  695.                 cond += "WHERE ";
    696. 

  696.             }
    697. 

  697.             first = false;
    698. 

  698.             cond += " " + CONDITION_CONTACTS_MANUFACTURER + "=0 AND ";
    699. 

  699.         }
    700. 

  700.         if (company) {
    701. 

  701.             if (first) {
    702. 

  702.                 cond += "WHERE ";
    703. 

  703.             }
    704. 

  704.             first = false;
    705. 

  705.             cond += " " + CONDITION_CONTACTS_COMPANY + "=1 AND ";
    706. 

  706.         } else {
    707. 

  707.             if (first) {
    708. 

  708.                 cond += "WHERE ";
    709. 

  709.             }
    710. 

  710.             first = false;
    711. 

  711.             cond += " " + CONDITION_CONTACTS_COMPANY + "=0 AND ";
    712. 

  712.         }
    713. 

  713. 

  714.         if (!first) {
    715. 

  715.             cond = cond.substring(4, cond.length() - 4);
    716. 

  716.             if (mpv5.db.objects.User.getCurrentUser().isGroupRestricted() && getGroupableContexts().contains(this)) {
    717. 

  717.                 cond += "AND   (" + dbIdentity + "." + "GROUPSIDS = " + mpv5.db.objects.User.getCurrentUser().__getGroupsids() + " OR " + dbIdentity + "." + "GROUPSIDS = 1)";
    718. 

  718.             }
    719. 

  719.         } else {
    720. 

  720. 

  721.             if (mpv5.db.objects.User.getCurrentUser().isGroupRestricted() && getGroupableContexts().contains(this)) {
    722. 

  722.                 cond = "WHERE (" + dbIdentity + "." + "GROUPSIDS = " + mpv5.db.objects.User.getCurrentUser().__getGroupsids() + " OR " + dbIdentity + "." + "GROUPSIDS = 1)";
    723. 

  723.             } else {
    724. 

  724.                 cond = "WHERE " + CONDITION_DEFAULT;
    725. 

  725.             }
    726. 

  726.         }
    727. 

  727. 

  728.         if (getTrashableContexts().contains(this)) {
    729. 

  729.             cond += " AND " + getDbIdentity() + ".invisible = 0 ";
    730. 

  730.         }
    731. 

  731. 

  732.         exclusiveCondition = cond;
    733. 

  733.     }
    734. 

  734. 

  735.     /**
    736. 

  736.      *
    737. 

  737.      * @return DB condition string
    738. 

  738.      */
    739. 

  739.     public String getConditions(boolean withInvisible) {
    740. 

  740.         if (!exclusiveConditionsAvailable) {
    741. 

  741.             String cond = "    ";
    742. 

  742.             boolean first = true;
    743. 

  743.             if (isCompany()) {
    744. 

  744.                 if (first) {
    745. 

  745.                     cond += "(";
    746. 

  746.                 }
    747. 

  747.                 first = false;
    748. 

  748.                 cond += " " + CONDITION_CONTACTS_COMPANY + "=1 OR ";
    749. 

  749.             }
    750. 

  750.             if (isCustomer()) {
    751. 

  751.                 if (first) {
    752. 

  752.                     cond += "(";
    753. 

  753.                 }
    754. 

  754.                 first = false;
    755. 

  755.                 cond += " " + CONDITION_CONTACTS_CUSTOMER + "=1 OR ";
    756. 

  756.             }
    757. 

  757.             if (isManufacturer()) {
    758. 

  758.                 if (first) {
    759. 

  759.                     cond += "(";
    760. 

  760.                 }
    761. 

  761.                 first = false;
    762. 

  762.                 cond += " " + CONDITION_CONTACTS_MANUFACTURER + "=1 OR ";
    763. 

  763.             }
    764. 

  764.             if (isSupplier()) {
    765. 

  765.                 if (first) {
    766. 

  766.                     cond += "(";
    767. 

  767.                 }
    768. 

  768.                 first = false;
    769. 

  769.                 cond += " " + CONDITION_CONTACTS_SUPPLIER + "=1 OR ";
    770. 

  770.             }
    771. 

  771.             if (itemType != null) {
    772. 

  772.                 if (first) {
    773. 

  773.                     cond += "(";
    774. 

  774. 

  775.                 }
    776. 

  776.                 first = false;
    777. 

  777.                 cond += " " + CONDITION_ITEMS_TYPE + "=" + getItemType() + " OR ";
    778. 

  778.             }
    779. 

  779.             if (itemStatus != null) {
    780. 

  780.                 if (first) {
    781. 

  781.                     cond += "(";
    782. 

  782. 

  783.                 }
    784. 

  784.                 first = false;
    785. 

  785.                 cond += " " + CONDITION_ITEMS_STATUS + "=" + getItemStatus() + " OR ";
    786. 

  786.             }
    787. 

  787.             if (!first) {
    788. 

  788.                 cond = "WHERE" + cond.substring(0, cond.length() - 3) + ")";
    789. 

  789.                 if (mpv5.db.objects.User.getCurrentUser().isGroupRestricted() && getGroupableContexts().contains(this)) {
    790. 

  790.                     cond += " AND (" + dbIdentity + "." + "GROUPSIDS = " + mpv5.db.objects.User.getCurrentUser().__getGroupsids() + " OR " + dbIdentity + "." + "GROUPSIDS = 1)";
    791. 

  791.                 }
    792. 

  792.             } else {
    793. 

  793.                 if (mpv5.db.objects.User.getCurrentUser().isGroupRestricted() && getGroupableContexts().contains(this)) {
    794. 

  794.                     cond = "WHERE (" + dbIdentity + "." + "GROUPSIDS = " + mpv5.db.objects.User.getCurrentUser().__getGroupsids() + " OR " + dbIdentity + "." + "GROUPSIDS = 1)";
    795. 

  795.                 } else {
    796. 

  796.                     cond = "WHERE " + CONDITION_DEFAULT;
    797. 

  797.                 }
    798. 

  798.             }
    799. 

  799.             if (!withInvisible && getTrashableContexts().contains(this)) {
    800. 

  800.                 cond += " AND " + dbIdentity + ".invisible = 0 ";
    801. 

  801.             }
    802. 

  802. //            if (!QueryHandler.isMatchingBraces(cond)) {
    803. 

  803. //                cond += ")";
    804. 

  804. //            }
    805. 

  805.             return cond;
    806. 

  806.         } else {
    807. 

  807.             return exclusiveCondition.toString();
    808. 

  808.         }
    809. 

  809.     }
    810. 

  810. 

  811.     /**
    812. 

  812.      * Generates a SQL String (WHERE clause) which can be used to implement multi-client capability.<br/>
    813. 

  813.      * <br/>
    814. 

  814.      * <b>If the current Context does not support grouping, or the current user is not Group restricted, this will return NULL.</b>
    815. 

  815.      * @return
    816. 

  816.      */
    817. 

  817.     public synchronized String getGroupRestrictionSQLString() {
    818. 

  818.         if (mpv5.db.objects.User.getCurrentUser().isGroupRestricted() && getGroupableContexts().contains(this)) {
    819. 

  819.             return " (" + dbIdentity + "." + "GROUPSIDS = " + mpv5.db.objects.User.getCurrentUser().__getGroupsids() + " OR " + dbIdentity + "." + "GROUPSIDS = 1)";
    820. 

  820.         } else {
    821. 

  821.             return null;
    822. 

  822.         }
    823. 

  823.     }
    824. 

  824. 

  825.     /**
    826. 

  826.      * Generates a SQL String (WHERE clause) which can be used to avoid having already trashed elements in the resulting data.
    827. 

  827.      *
    828. 

  828.      * @return  " invisible = 0 " or NULL if Context is not trashable
    829. 

  829.      */
    830. 

  830.     public synchronized String getNoTrashSQLString() {
    831. 

  831.         if (getTrashableContexts().contains(this)) {
    832. 

  832.             return " " + dbIdentity + ".invisible = 0 ";
    833. 

  833.         } else {
    834. 

  834.             return null;
    835. 

  835.         }
    836. 

  836.     }
    837. 

  837. 

  838.     /**
    839. 

  839.      * Generates a SQL String (WHERE clause) which can be used to implement multi-client capability.<br/>
    840. 

  840.      * <br/>
    841. 

  841.      * <b>If the current Context does not support grouping, or the current user is not Group restricted, this will return NULL.</b>
    842. 

  842.      * @param tableName
    843. 

  843.      * @return
    844. 

  844.      */
    845. 

  845.     public synchronized String getGroupRestrictionSQLString(String tableName) {
    846. 

  846.         if (mpv5.db.objects.User.getCurrentUser().isGroupRestricted() && getGroupableContexts().contains(this)) {
    847. 

  847.             return " (" + tableName + "." + "GROUPSIDS = " + mpv5.db.objects.User.getCurrentUser().__getGroupsids() + " OR " + tableName + "." + "GROUPSIDS = 1)";
    848. 

  848.         } else {
    849. 

  849.             return null;
    850. 

  850.         }
    851. 

  851.     }
    852. 

  852. 

  853.     /**
    854. 

  854.      * Generates a SQL String (WHERE clause) which can be used to avoid having already trashed elements in the resulting data.
    855. 

  855.      *
    856. 

  856.      * @param tableName
    857. 

  857.      * @return  " invisible = 0 " or NULL if Context is not trashable
    858. 

  858.      */
    859. 

  859.     public synchronized String getNoTrashSQLString(String tableName) {
    860. 

  860.         if (getTrashableContexts().contains(this)) {
    861. 

  861.             return " " + tableName + ".invisible = 0 ";
    862. 

  862.         } else {
    863. 

  863.             return null;
    864. 

  864.         }
    865. 

  865.     }
    866. 

  866. 

  867.     /**
    868. 

  868.      * Add MP specific conditions to a sql query
    869. 

  869.      * @param query
    870. 

  870.      * @return The query
    871. 

  871.      */
    872. 

  872.     public synchronized String prepareSQLString(String query) {
    873. 

  873. 

  874.         if (getGroupRestrictionSQLString() != null) {
    875. 

  875.             if (query.toUpperCase().contains("WHERE")) {
    876. 

  876.                 query = query + " AND" + getGroupRestrictionSQLString();
    877. 

  877.             } else {
    878. 

  878.                 query = query + " WHERE" + getGroupRestrictionSQLString();
    879. 

  879.             }
    880. 

  880.         }
    881. 

  881.         if (getNoTrashSQLString() != null) {
    882. 

  882.             if (query.toUpperCase().contains("WHERE")) {
    883. 

  883.                 query = query + " AND" + getNoTrashSQLString();
    884. 

  884.             } else {
    885. 

  885.                 query = query + " WHERE" + getNoTrashSQLString();
    886. 

  886.             }
    887. 

  887.         }
    888. 

  888.         return query;
    889. 

  889.     }
    890. 

  890. 

  891.     /**
    892. 

  892.      * Add MP specific conditions to a sql query
    893. 

  893.      * @param query
    894. 

  894.      * @param tableName
    895. 

  895.      * @return The query
    896. 

  896.      */
    897. 

  897.     public synchronized String prepareSQLString(String query, String tableName) {
    898. 

  898. 

  899.         if (getGroupRestrictionSQLString(tableName) != null) {
    900. 

  900.             if (query.toUpperCase().contains("WHERE")) {
    901. 

  901.                 query = query + " AND" + getGroupRestrictionSQLString(tableName);
    902. 

  902.             } else {
    903. 

  903.                 query = query + " WHERE" + getGroupRestrictionSQLString(tableName);
    904. 

  904.             }
    905. 

  905.         }
    906. 

  906.         if (getNoTrashSQLString(tableName) != null) {
    907. 

  907.             if (query.toUpperCase().contains("WHERE")) {
    908. 

  908.                 query = query + " AND" + getNoTrashSQLString(tableName);
    909. 

  909.             } else {
    910. 

  910.                 query = query + " WHERE" + getNoTrashSQLString(tableName);
    911. 

  911.             }
    912. 

  912.         }
    913. 

  913.         return query;
    914. 

  914.     }
    915. 

  915. 

  916. //    /**
    917. 

  917. //     * Define the owner of this Context
    918. 

  918. //     * @param parentobject
    919. 

  919. //     */
    920. 

  920. //    public void setOwner(DatabaseObject parentobject) {
    921. 

  921. //        this.parent = parentobject;
    922. 

  922. //    }
    923. 

  923.     /**
    924. 

  924.      * Remove all exclusive conditions or reuse them
    925. 

  925.      * @param bool
    926. 

  926.      */
    927. 

  927.     public void useExclusiveConditions(boolean bool) {
    928. 

  928.         exclusiveConditionsAvailable = bool;
    929. 

  929.     }
    930. 

  930. 

  931. //    /**
    932. 

  932. //     * Add a self-table reference to this context
    933. 

  933. //     * @param referencekey
    934. 

  934. //     * @param referenceidkey
    935. 

  935. //     */
    936. 

  936. //    public void addReference(String referencekey, String referenceidkey) {
    937. 

  937. //        String alias = this.getDbIdentity();
    938. 

  938. //        references.add(new String[]{this.getDbIdentity(), referencekey, referenceidkey, alias});
    939. 

  939. //    }
    940. 

  940.     /**
    941. 

  941.      * Add a foreign table reference to this context
    942. 

  942.      * @param c
    943. 

  943.      */
    944. 

  944.     public void addReference(Context c) {
    945. 

  945.         if (!refs.contains(c)) {
    946. 

  946.             String alias = c.getDbIdentity();
    947. 

  947.             refs.add(c);
    948. 

  948.             references.add(new String[]{alias, "ids", alias + "ids", alias, this.getDbIdentity()});
    949. 

  949.         }
    950. 

  950.     }
    951. 

  951.     List<Context> refs = new ArrayList<Context>();
    952. 

  952. 

  953.     /**
    954. 

  954.      * Add a foreign table reference to this context<br/><br/>
    955. 

  955.      *  Context c= Context.getFilesToContacts();<br/>
    956. 

  956.      *  c.addReference(Context.getFiles().getDbIdentity(), "cname", "filename");<br/>
    957. 

  957.      * @param referencetable The table which will be joined
    958. 

  958.      * @param referencekey The key column of the joined table
    959. 

  959.      * @param referenceidkey They key column in the original table
    960. 

  960.      */
    961. 

  961.     public void addReference(String referencetable, String referencekey, String referenceidkey) {
    962. 

  962.         synchronized (this) {
    963. 

  963.             String alias = referencetable;
    964. 

  964.             references.add(new String[]{referencetable, referencekey, referenceidkey, alias, getDbIdentity()});
    965. 

  965.         }
    966. 

  966.     }
    967. 

  967. 

  968.     /**
    969. 

  969.      * @return the dbIdentity
    970. 

  970.      */
    971. 

  971.     public String getDbIdentity() {
    972. 

  972.         return dbIdentity;
    973. 

  973.     }
    974. 

  974. 

  975.     public String getSearchFields() {
    976. 

  976.         return defResultFields;
    977. 

  977.     }
    978. 

  978. //
    979. 

  979. //    public String[] getSearchHeaders() {
    980. 

  980. //        return searchHeaders;
    981. 

  981. //    }
    982. 

  982. //
    983. 

  983. //    public DatabaseObject getParent() {
    984. 

  984. //        return parent;
    985. 

  985. //    }
    986. 

  986. 

  987.     /**
    988. 

  988.      * @param dbIdentity the dbIdentity to set
    989. 

  989.      */
    990. 

  990.     public final void setDbIdentity(String dbIdentity) {
    991. 

  991.         this.dbIdentity = dbIdentity;
    992. 

  992.     }
    993. 

  993. 

  994.     /**
    995. 

  995.      * @return the subID
    996. 

  996.      */
    997. 

  997.     public String getSubID() {
    998. 

  998.         return subID;
    999. 

  999.     }
    1000. 

  1000. 

  1001.     /**
    1002. 

  1002.      * @return the IDENTITY CLASS
    1003. 

  1003.      */
    1004. 

  1004.     public Class getIdentityClass() {
    1005. 

  1005.         return identityClass;
    1006. 

  1006.     }
    1007. 

  1007. 

  1008.     /**
    1009. 

  1009.      * @param subID the subID to set
    1010. 

  1010.      */
    1011. 

  1011.     public final void setSubID(String subID) {
    1012. 

  1012.         this.subID = subID;
    1013. 

  1013.     }
    1014. 

  1014. 

  1015.     public String getReferences() {
    1016. 

  1016.         String cond = "";
    1017. 

  1017.         if (references.size() > 0) {
    1018. 

  1018.             for (int i = 0; i < references.size(); i++) {
    1019. 

  1019.                 if (references.get(i).length == 4) {
    1020. 

  1020.                     cond += " LEFT OUTER JOIN " + references.get(i)[0] + " ON " + references.get(i)[3] + "." + references.get(i)[1] + " = " + references.get(i)[3] + "." + references.get(i)[2];
    1021. 

  1021.                 } else if (references.get(i).length == 5) {
    1022. 

  1022.                     cond += " LEFT OUTER JOIN " + references.get(i)[0] + " ON " + references.get(i)[3] + "." + references.get(i)[1] + " = " + references.get(i)[4] + "." + references.get(i)[2];
    1023. 

  1023.                 }
    1024. 

  1024.             }
    1025. 

  1025.         }
    1026. 

  1026.         return cond;
    1027. 

  1027.     }
    1028. 

  1028. 

  1029.     /**
    1030. 

  1030.      * @return the Company
    1031. 

  1031.      */
    1032. 

  1032.     public boolean isCompany() {
    1033. 

  1033.         return isCompany;
    1034. 

  1034.     }
    1035. 

  1035. 

  1036.     /**
    1037. 

  1037.      * @param Company the Company to set
    1038. 

  1038.      */
    1039. 

  1039.     private void setCompany(boolean Company) {
    1040. 

  1040.         this.isCompany = Company;
    1041. 

  1041.     }
    1042. 

  1042. 

  1043.     /**
    1044. 

  1044.      * @return the Customer
    1045. 

  1045.      */
    1046. 

  1046.     private boolean isCustomer() {
    1047. 

  1047.         return isCustomer;
    1048. 

  1048.     }
    1049. 

  1049. 

  1050.     /**
    1051. 

  1051.      * @param Customer the Customer to set
    1052. 

  1052.      */
    1053. 

  1053.     private void setCustomer(boolean Customer) {
    1054. 

  1054.         this.isCustomer = Customer;
    1055. 

  1055.     }
    1056. 

  1056. 

  1057.     /**
    1058. 

  1058.      * @return the Manufacturer
    1059. 

  1059.      */
    1060. 

  1060.     private boolean isManufacturer() {
    1061. 

  1061.         return isManufacturer;
    1062. 

  1062.     }
    1063. 

  1063. 

  1064.     private void setId(int id) {
    1065. 

  1065.         this.id = id;
    1066. 

  1066.     }
    1067. 

  1067. 

  1068.     /**
    1069. 

  1069.      * @param Manufacturer the Manufacturer to set
    1070. 

  1070.      */
    1071. 

  1071.     private void setManufacturer(boolean Manufacturer) {
    1072. 

  1072.         this.isManufacturer = Manufacturer;
    1073. 

  1073.     }
    1074. 

  1074. 

  1075.     /**
    1076. 

  1076.      * @return the Supplier
    1077. 

  1077.      */
    1078. 

  1078.     private boolean isSupplier() {
    1079. 

  1079.         return isSupplier;
    1080. 

  1080.     }
    1081. 

  1081. 

  1082.     /**
    1083. 

  1083.      * @param Supplier the Supplier to set
    1084. 

  1084.      */
    1085. 

  1085.     private void setSupplier(boolean Supplier) {
    1086. 

  1086.         this.isSupplier = Supplier;
    1087. 

  1087.     }
    1088. 

  1088. 

  1089.     /**
    1090. 

  1090.      * @return the itemStatus
    1091. 

  1091.      */
    1092. 

  1092.     public int getItemStatus() {
    1093. 

  1093.         return itemStatus;
    1094. 

  1094.     }
    1095. 

  1095. 

  1096.     /**
    1097. 

  1097.      * @param itemStatus the itemStatus to set
    1098. 

  1098.      */
    1099. 

  1099.     public void setItemStatus(int itemStatus) {
    1100. 

  1100.         this.itemStatus = itemStatus;
    1101. 

  1101.     }
    1102. 

  1102. 

  1103.     /**
    1104. 

  1104.      * @return the itemType
    1105. 

  1105.      */
    1106. 

  1106.     public int getItemType() {
    1107. 

  1107.         return itemType;
    1108. 

  1108.     }
    1109. 

  1109. 

  1110.     /**
    1111. 

  1111.      * @param itemType the itemType to set
    1112. 

  1112.      */
    1113. 

  1113.     public void setItemType(int itemType) {
    1114. 

  1114.         this.itemType = itemType;
    1115. 

  1115.     }
    1116. 

  1116. 

  1117.     /**
    1118. 

  1118.      * Returns an empty "sample" Object of the context type
    1119. 

  1119.      * @param <T> 
    1120. 

  1120.      * @return An empty {@link DatabaseObject}
    1121. 

  1121.      */
    1122. 

  1122.     @SuppressWarnings("unchecked")
    1123. 

  1123.     public <T extends DatabaseObject> T getSampleObject() {
    1124. 

  1124.         return (T) DatabaseObject.getObject(this);
    1125. 

  1125.     }
    1126. 

  1126. ////////////////////////////////////////////////////////////////////////////////
    1127. 

  1127. //generate a new Context Object on each call here, callers may alter them to variants
    1128. 

  1128. 

  1129.     public static synchronized Context getContactsCompanies() {
    1130. 

  1130.         Context c = new Context();
    1131. 

  1131.         c.setCompany(true);
    1132. 

  1132.         c.setSubID(DEFAULT_SUBID);
    1133. 

  1133.         c.setDbIdentity(IDENTITY_CONTACTS);
    1134. 

  1134.         c.setSearchFields(DEFAULT_CONTACT_SEARCH);
    1135. 

  1135. //        c.setSearchHeaders(Headers.CONTACT_DEFAULT.getValue());
    1136. 

  1136.         c.setIdentityClass(IDENTITY_CONTACTS_CLASS);
    1137. 

  1137.         c.setId(0);
    1138. 

  1138. 

  1139.         return c;
    1140. 

  1140.     }
    1141. 

  1141. 

  1142.     /**
    1143. 

  1143.      * 
    1144. 

  1144.      * @param type 
    1145. 

  1145.      * @param status
    1146. 

  1146.      * @return
    1147. 

  1147.      */
    1148. 

  1148.     public static synchronized Context getItem(Integer type, Integer status) {
    1149. 

  1149.         Context c = new Context();
    1150. 

  1150.         c.setSubID(DEFAULT_SUBID);
    1151. 

  1151.         c.setDbIdentity(IDENTITY_ITEMS);
    1152. 

  1152.         c.setSearchFields(DEFAULT_ITEM_SEARCH);
    1153. 

  1153. //        c.setSearchHeaders(Headers.ITEM_DEFAULT.getValue());
    1154. 

  1154.         c.setIdentityClass(IDENTITY_ITEMS_CLASS);
    1155. 

  1155.         if (status != null) {
    1156. 

  1156.             c.setItemStatus(status);
    1157. 

  1157.         }
    1158. 

  1158.         if (type != null) {
    1159. 

  1159.             c.setItemType(type);
    1160. 

  1160.         }
    1161. 

  1161.         c.setId(1);
    1162. 

  1162. 

  1163.         return c;
    1164. 

  1164.     }
    1165. 

  1165. 

  1166.     public static synchronized Context getItem() {
    1167. 

  1167.         return getItem(null, null);
    1168. 

  1168.     }
    1169. 

  1169. 

  1170.     public static synchronized Context getSubItem() {
    1171. 

  1171.         Context subitem = new Context();
    1172. 

  1172.         subitem.setSubID(DEFAULT_SUBID);
    1173. 

  1173.         subitem.setDbIdentity(IDENTITY_SUBITEMS);
    1174. 

  1174.         subitem.setIdentityClass(IDENTITY_SUBITEMS_CLASS);
    1175. 

  1175.         subitem.setId(2);
    1176. 

  1176. 

  1177.         return subitem;
    1178. 

  1178.     }
    1179. 

  1179. 

  1180.     public static synchronized Context getCustomer() {
    1181. 

  1181.         Context c = new Context();
    1182. 

  1182.         c.setCustomer(true);
    1183. 

  1183.         c.setSubID(DEFAULT_SUBID);
    1184. 

  1184.         c.setDbIdentity(IDENTITY_CONTACTS);
    1185. 

  1185.         c.setSearchFields(DEFAULT_CONTACT_SEARCH);
    1186. 

  1186. //        c.setSearchHeaders(Headers.CONTACT_DEFAULT.getValue());
    1187. 

  1187.         c.setIdentityClass(IDENTITY_CONTACTS_CLASS);
    1188. 

  1188.         c.setId(3);
    1189. 

  1189. 

  1190.         return c;
    1191. 

  1191.     }
    1192. 

  1192. 

  1193.     public static synchronized Context getManufacturer() {
    1194. 

  1194.         Context c = new Context();
    1195. 

  1195.         c.setManufacturer(true);
    1196. 

  1196.         c.setSubID(DEFAULT_SUBID);
    1197. 

  1197.         c.setDbIdentity(IDENTITY_CONTACTS);
    1198. 

  1198.         c.setSearchFields(DEFAULT_CONTACT_SEARCH);
    1199. 

  1199. //        c.setSearchHeaders(Headers.CONTACT_DEFAULT.getValue());
    1200. 

  1200.         c.setIdentityClass(IDENTITY_CONTACTS_CLASS);
    1201. 

  1201.         c.setId(4);
    1202. 

  1202. 

  1203.         return c;
    1204. 

  1204.     }
    1205. 

  1205. 

  1206.     public static synchronized Context getSupplier() {
    1207. 

  1207.         Context c = new Context();
    1208. 

  1208.         c.setSupplier(true);
    1209. 

  1209.         c.setSubID(DEFAULT_SUBID);
    1210. 

  1210.         c.setDbIdentity(IDENTITY_CONTACTS);
    1211. 

  1211.         c.setSearchFields(DEFAULT_CONTACT_SEARCH);
    1212. 

  1212. //        c.setSearchHeaders(Headers.CONTACT_DEFAULT.getValue());
    1213. 

  1213.         c.setIdentityClass(IDENTITY_CONTACTS_CLASS);
    1214. 

  1214.         c.setId(5);
    1215. 

  1215. 

  1216.         return c;
    1217. 

  1217.     }
    1218. 

  1218. 

  1219.     public static synchronized Context getContact() {
    1220. 

  1220.         Context c = new Context();
    1221. 

  1221.         c.setSubID(DEFAULT_SUBID);
    1222. 

  1222.         c.setDbIdentity(IDENTITY_CONTACTS);
    1223. 

  1223.         c.setSearchFields(DEFAULT_CONTACT_SEARCH);
    1224. 

  1224. //        c.setSearchHeaders(Headers.CONTACT_DEFAULT.getValue());
    1225. 

  1225.         c.setIdentityClass(IDENTITY_CONTACTS_CLASS);
    1226. 

  1226.         c.setId(6);
    1227. 

  1227. 

  1228.         return c;
    1229. 

  1229.     }
    1230. 

  1230. 

  1231.     public static synchronized Context getUser() {
    1232. 

  1232.         Context c = new Context();
    1233. 

  1233.         c.setSubID(DEFAULT_SUBID);
    1234. 

  1234.         c.setDbIdentity(IDENTITY_USERS);
    1235. 

  1235.         c.setSearchFields(DEFAULT_USER_SEARCH);
    1236. 

  1236. //        c.setSearchHeaders(Headers.USER_DEFAULT.getValue());
    1237. 

  1237.         c.setIdentityClass(IDENTITY_USERS_CLASS);
    1238. 

  1238.         c.uniqueColumns = UNIQUECOLUMNS_USER;
    1239. 

  1239.         c.setId(7);
    1240. 

  1240. 

  1241.         return c;
    1242. 

  1242.     }
    1243. 

  1243. 

  1244.     public static synchronized Context getSchedule() {
    1245. 

  1245.         Context c = new Context();
    1246. 

  1246.         c.setSubID(DEFAULT_SUBID);
    1247. 

  1247.         c.setDbIdentity(IDENTITY_SCHEDULE);
    1248. 

  1248.         c.setIdentityClass(IDENTITY_SCHEDULE_CLASS);
    1249. 

  1249.         c.setId(8);
    1250. 

  1250. 

  1251.         return c;
    1252. 

  1252.     }
    1253. 

  1253. 

  1254.     public static synchronized Context getLanguage() {
    1255. 

  1255.         Context c = new Context();
    1256. 

  1256.         c.setSubID(DEFAULT_SUBID);
    1257. 

  1257.         c.setDbIdentity(IDENTITY_LANGUAGES);
    1258. 

  1258.         c.setId(9);
    1259. 

  1259. 

  1260.         return c;
    1261. 

  1261.     }
    1262. 

  1262. 

  1263.     public static synchronized Context getFiles() {
    1264. 

  1264.         Context c = new Context();
    1265. 

  1265.         c.setSubID(DEFAULT_SUBID);
    1266. 

  1266.         c.setDbIdentity(IDENTITY_FILES);
    1267. 

  1267.         c.setId(10);
    1268. 

  1268. 

  1269.         return c;
    1270. 

  1270.     }
    1271. 

  1271. 

  1272.     public static synchronized Context getLock() {
    1273. 

  1273.         Context c = new Context();
    1274. 

  1274.         c.setSubID(DEFAULT_SUBID);
    1275. 

  1275.         c.setDbIdentity(IDENTITY_LOCK);
    1276. 

  1276.         c.setId(11);
    1277. 

  1277. 

  1278.         return c;
    1279. 

  1279.     }
    1280. 

  1280. 

  1281.     public static synchronized Context getGroup() {
    1282. 

  1282.         Context c = new Context();
    1283. 

  1283.         c.setSubID(DEFAULT_SUBID);
    1284. 

  1284.         c.setDbIdentity(IDENTITY_GROUPS);
    1285. 

  1285.         c.setIdentityClass(IDENTITY_GROUPS_CLASS);
    1286. 

  1286.         c.uniqueColumns = UNIQUECOLUMNS_GROUPS;
    1287. 

  1287.         c.setId(14);
    1288. 

  1288. 

  1289.         return c;
    1290. 

  1290.     }
    1291. 

  1291. 

  1292.     public static synchronized Context getFavourite() {
    1293. 

  1293.         Context c = new Context();
    1294. 

  1294.         c.setSubID(DEFAULT_SUBID);
    1295. 

  1295.         c.setDbIdentity(IDENTITY_FAVS);
    1296. 

  1296.         c.setIdentityClass(IDENTITY_FAVOURITE_CLASS);
    1297. 

  1297.         c.setId(15);
    1298. 

  1298. 

  1299.         return c;
    1300. 

  1300.     }
    1301. 

  1301. 

  1302.     public static synchronized Context getAddress() {
    1303. 

  1303.         Context c = new Context();
    1304. 

  1304.         c.setSubID(DEFAULT_SUBID);
    1305. 

  1305.         c.setDbIdentity(IDENTITY_ADDRESS);
    1306. 

  1306.         c.setIdentityClass(IDENTITY_ADDRESS_CLASS);
    1307. 

  1307.         c.setId(16);
    1308. 

  1308. 

  1309.         return c;
    1310. 

  1310.     }
    1311. 

  1311. 

  1312.     public static synchronized Context getInvoice() {
    1313. 

  1313.         return getItem(Item.TYPE_BILL, Item.STATUS_IN_PROGRESS);
    1314. 

  1314.     }
    1315. 

  1315. 

  1316.     public static synchronized Context getOrder() {
    1317. 

  1317.         Context c = new Context();
    1318. 

  1318.         c.setSubID(DEFAULT_SUBID);
    1319. 

  1319.         c.setDbIdentity(IDENTITY_ITEMS);
    1320. 

  1320.         c.setSearchFields(DEFAULT_ITEM_SEARCH);
    1321. 

  1321. //        c.setSearchHeaders(Headers.ITEM_DEFAULT.getValue());
    1322. 

  1322.         c.setIdentityClass(IDENTITY_ITEMS_CLASS);
    1323. 

  1323.         c.setItemType(Item.TYPE_ORDER);
    1324. 

  1324.         c.setId(18);
    1325. 

  1325. 

  1326.         return c;
    1327. 

  1327.     }
    1328. 

  1328. 

  1329.     public static synchronized Context getOffer() {
    1330. 

  1330.         Context c = new Context();
    1331. 

  1331.         c.setSubID(DEFAULT_SUBID);
    1332. 

  1332.         c.setDbIdentity(IDENTITY_ITEMS);
    1333. 

  1333.         c.setSearchFields(DEFAULT_ITEM_SEARCH);
    1334. 

  1334. //        c.setSearchHeaders(Headers.ITEM_DEFAULT.getValue());
    1335. 

  1335.         c.setIdentityClass(IDENTITY_ITEMS_CLASS);
    1336. 

  1336.         c.setItemType(Item.TYPE_OFFER);
    1337. 

  1337.         c.setId(19);
    1338. 

  1338. 

  1339.         return c;
    1340. 

  1340.     }
    1341. 

  1341. 

  1342.     public static synchronized Context getFilesToContacts() {
    1343. 

  1343.         Context c = new Context();
    1344. 

  1344.         c.setSubID(DEFAULT_SUBID);
    1345. 

  1345.         c.setDbIdentity(IDENTITY_FILES_TO_CONTACTS);
    1346. 

  1346.         c.setIdentityClass(IDENTITY_CONTACTS_FILES_CLASS);
    1347. 

  1347.         c.setId(20);
    1348. 

  1348. 

  1349.         return c;
    1350. 

  1350.     }
    1351. 

  1351. 

  1352.     public static synchronized Context getHistory() {
    1353. 

  1353.         Context c = new Context();
    1354. 

  1354.         c.setSubID(DEFAULT_SUBID);
    1355. 

  1355.         c.setDbIdentity(IDENTITY_HISTORY);
    1356. 

  1356.         c.setIdentityClass(IDENTITY_HISTORY_ITEMS_CLASS);
    1357. 

  1357.         c.setId(21);
    1358. 

  1358. 

  1359.         return c;
    1360. 

  1360.     }
    1361. 

  1361. 

  1362.     public static synchronized Context getCountries() {
    1363. 

  1363.         Context c = new Context();
    1364. 

  1364.         c.setSubID(DEFAULT_SUBID);
    1365. 

  1365.         c.setDbIdentity(IDENTITY_COUNTRIES);
    1366. 

  1366.         c.setId(22);
    1367. 

  1367. 

  1368.         return c;
    1369. 

  1369.     }
    1370. 

  1370. 

  1371.     public static synchronized Context getProduct() {
    1372. 

  1372.         Context c = new Context();
    1373. 

  1373.         c.setSubID(DEFAULT_SUBID);
    1374. 

  1374.         c.setDbIdentity(IDENTITY_PRODUCTS);
    1375. 

  1375.         c.setIdentityClass(IDENTITY_PRODUCTS_CLASS);
    1376. 

  1376.         c.setSearchFields(DEFAULT_PRODUCT_SEARCH);
    1377. 

  1377.         c.setId(23);
    1378. 

  1378.         FOREIGN_KEY_ALIASES.put(c + "@" + getSubItem(), "originalproducts");
    1379. 

  1379. 

  1380.         return c;
    1381. 

  1381.     }
    1382. 

  1382. 

  1383.     public static synchronized Context getSearchIndex() {
    1384. 

  1384.         Context c = new Context();
    1385. 

  1385.         c.setSubID(DEFAULT_SUBID);
    1386. 

  1386.         c.setDbIdentity(IDENTITY_SEARCHINDEX);
    1387. 

  1387.         c.setId(24);
    1388. 

  1388. 

  1389.         return c;
    1390. 

  1390.     }
    1391. 

  1391. 

  1392.     public static synchronized Context getPluginsToUsers() {
    1393. 

  1393.         Context c = new Context();
    1394. 

  1394.         c.setSubID(DEFAULT_SUBID);
    1395. 

  1395.         c.setDbIdentity(IDENTITY_PLUGINS_TO_USERS);
    1396. 

  1396.         c.setIdentityClass(IDENTITY_USER_PLUGINS_CLASS);
    1397. 

  1397.         c.setId(25);
    1398. 

  1398. 

  1399.         return c;
    1400. 

  1400.     }
    1401. 

  1401. 

  1402.     public static synchronized Context getPlugins() {
    1403. 

  1403.         Context c = new Context();
    1404. 

  1404.         c.setSubID(DEFAULT_SUBID);
    1405. 

  1405.         c.setDbIdentity(IDENTITY_PLUGINS);
    1406. 

  1406.         c.setIdentityClass(IDENTITY_PLUGINS_CLASS);
    1407. 

  1407.         c.setId(26);
    1408. 

  1408. 

  1409.         return c;
    1410. 

  1410.     }
    1411. 

  1411. 

  1412.     public static synchronized Context getUserProperties() {
    1413. 

  1413.         Context c = new Context();
    1414. 

  1414.         c.setSubID(DEFAULT_SUBID);
    1415. 

  1415.         c.setDbIdentity(IDENTITY_PROPERTIES_TO_USERS);
    1416. 

  1416.         c.setIdentityClass(IDENTITY_PROPERTIES_CLASS);
    1417. 

  1417.         c.setId(27);
    1418. 

  1418. 

  1419.         return c;
    1420. 

  1420.     }
    1421. 

  1421. 

  1422.     public static synchronized Context getAccounts() {
    1423. 

  1423.         Context c = new Context();
    1424. 

  1424.         c.setSubID(DEFAULT_SUBID);
    1425. 

  1425.         c.setDbIdentity(IDENTITY_ACCOUNTS);
    1426. 

  1426.         c.setIdentityClass(IDENTITY_ACCOUNTS_CLASS);
    1427. 

  1427.         c.setId(28);
    1428. 

  1428.         c.uniqueColumns = UNIQUECOLUMNS_DEFAULT;
    1429. 

  1429. 

  1430.         return c;
    1431. 

  1431.     }
    1432. 

  1432. 

  1433.     public static synchronized Context getItemsToAccounts() {
    1434. 

  1434.         Context c = new Context();
    1435. 

  1435.         c.setSubID(DEFAULT_SUBID);
    1436. 

  1436.         c.setDbIdentity(IDENTITY_ITEMS_TO_ACCOUNTS);
    1437. 

  1437.         c.setId(29);
    1438. 

  1438. 

  1439.         return c;
    1440. 

  1440.     }
    1441. 

  1441. 

  1442.     public static synchronized Context getMessage() {
    1443. 

  1443.         Context c = new Context();
    1444. 

  1444.         c.setSubID(DEFAULT_SUBID);
    1445. 

  1445.         c.setDbIdentity(IDENTITY_MAIL);
    1446. 

  1446.         c.setIdentityClass(IDENTITY_MAILS_CLASS);
    1447. 

  1447.         c.setId(30);
    1448. 

  1448.         c.uniqueColumns = UNIQUECOLUMNS_DEFAULT;
    1449. 

  1449. 

  1450.         return c;
    1451. 

  1451.     }
    1452. 

  1452. 

  1453.     public static synchronized Context getProductListItems() {
    1454. 

  1454.         Context c = new Context();
    1455. 

  1455.         c.setSubID(DEFAULT_SUBID);
    1456. 

  1456.         c.setDbIdentity(IDENTITY_PRODUCTSLISTITEMS);
    1457. 

  1457.         c.setIdentityClass(IDENTITY_ITEMSLIST_CLASS);
    1458. 

  1458.         c.setId(32);
    1459. 

  1459. 

  1460.         return c;
    1461. 

  1461.     }
    1462. 

  1462. 

  1463.     public static synchronized Context getFormats() {
    1464. 

  1464.         Context c = new Context();
    1465. 

  1465.         c.setSubID(DEFAULT_SUBID);
    1466. 

  1466.         c.setDbIdentity(IDENTITY_FORMATS_T_USERS);
    1467. 

  1467.         c.setId(33);
    1468. 

  1468. 

  1469.         return c;
    1470. 

  1470.     }
    1471. 

  1471. 

  1472.     public static synchronized Context getFilesToItems() {
    1473. 

  1473.         Context c = new Context();
    1474. 

  1474.         c.setSubID(DEFAULT_SUBID);
    1475. 

  1475.         c.setDbIdentity(IDENTITY_FILES_TO_ITEMS);
    1476. 

  1476.         c.setIdentityClass(IDENTITY_ITEM_FILES_CLASS);
    1477. 

  1477.         c.setId(34);
    1478. 

  1478. 

  1479.         return c;
    1480. 

  1480.     }
    1481. 

  1481. 

  1482.     public static synchronized Context getTaxes() {
    1483. 

  1483.         Context c = new Context();
    1484. 

  1484.         c.setSubID(DEFAULT_SUBID);
    1485. 

  1485.         c.setDbIdentity(IDENTITY_TAX);
    1486. 

  1486.         c.setIdentityClass(IDENTITY_TAX_CLASS);
    1487. 

  1487.         c.setId(36);
    1488. 

  1488. 

  1489.         return c;
    1490. 

  1490.     }
    1491. 

  1491. 

  1492.     public static synchronized Context getGlobalSettings() {
    1493. 

  1493.         Context c = new Context();
    1494. 

  1494.         c.setSubID(DEFAULT_SUBID);
    1495. 

  1495.         c.setDbIdentity(IDENTITY_GLOBALSETTINGS);
    1496. 

  1496.         c.setId(37);
    1497. 

  1497. 

  1498.         return c;
    1499. 

  1499.     }
    1500. 

  1500. 

  1501.     public static synchronized Context getProductGroup() {
    1502. 

  1502.         Context c = new Context();
    1503. 

  1503.         c.setSubID(DEFAULT_SUBID);
    1504. 

  1504.         c.setDbIdentity(IDENTITY_PGROUPS);
    1505. 

  1505.         c.setIdentityClass(IDENTITY_PGROUPS_CLASS);
    1506. 

  1506.         c.uniqueColumns = UNIQUECOLUMNS_GROUPS;
    1507. 

  1507.         c.setId(38);
    1508. 

  1508. 

  1509.         return c;
    1510. 

  1510.     }
    1511. 

  1511. 

  1512.     public static synchronized Context getFilesToProducts() {
    1513. 

  1513.         Context c = new Context();
    1514. 

  1514.         c.setSubID(DEFAULT_SUBID);
    1515. 

  1515.         c.setDbIdentity(IDENTITY_FILES_TO_PRODUCTS);
    1516. 

  1516.         c.setIdentityClass(IDENTITY_PRODUCTS_FILES_CLASS);
    1517. 

  1517.         c.setId(20);
    1518. 

  1518. 

  1519.         return c;
    1520. 

  1520.     }
    1521. 

  1521. 

  1522.     public static synchronized Context getCompany() {
    1523. 

  1523.         Context c = new Context();
    1524. 

  1524.         c.setSubID(DEFAULT_SUBID);
    1525. 

  1525.         c.setDbIdentity(IDENTITY_COMPANIES);
    1526. 

  1526.         c.setIdentityClass(IDENTITY_COMPANY_CLASS);
    1527. 

  1527.         c.setId(39);
    1528. 

  1528. 

  1529.         return c;
    1530. 

  1530.     }
    1531. 

  1531. 

  1532.     public static synchronized Context getWebShop() {
    1533. 

  1533.         Context c = new Context();
    1534. 

  1534.         c.setSubID(DEFAULT_SUBID);
    1535. 

  1535.         c.setDbIdentity(IDENTITY_WEBSHOPS);
    1536. 

  1536.         c.setIdentityClass(IDENTITY_WEBSHOP_CLASS);
    1537. 

  1537.         c.setId(40);
    1538. 

  1538. 

  1539.         return c;
    1540. 

  1540.     }
    1541. 

  1541. 

  1542.     public static synchronized Context getWebShopContactMapping() {
    1543. 

  1543.         Context c = new Context();
    1544. 

  1544.         c.setSubID(DEFAULT_SUBID);
    1545. 

  1545.         c.setDbIdentity(IDENTITY_WSMAPPING);
    1546. 

  1546.         c.setIdentityClass(IDENTITY_WSCONTACTSMAPPING_CLASS);
    1547. 

  1547.         c.setId(41);
    1548. 

  1548. 

  1549.         return c;
    1550. 

  1550.     }
    1551. 

  1551. 

  1552.     public static synchronized Context getWebShopItemMapping() {
    1553. 

  1553.         Context c = new Context();
    1554. 

  1554.         c.setSubID(DEFAULT_SUBID);
    1555. 

  1555.         c.setDbIdentity(IDENTITY_WSIMAPPING);
    1556. 

  1556.         c.setIdentityClass(IDENTITY_WSITEMSMAPPING_CLASS);
    1557. 

  1557.         c.setId(42);
    1558. 

  1558. 

  1559.         return c;
    1560. 

  1560.     }
    1561. 

  1561. 

  1562.     public static synchronized Context getTemplate() {
    1563. 

  1563.         Context c = new Context();
    1564. 

  1564.         c.setSubID(DEFAULT_SUBID);
    1565. 

  1565.         c.setDbIdentity(IDENTITY_TEMPLATES);
    1566. 

  1566.         c.setIdentityClass(IDENTITY_TEMPLATE_CLASS);
    1567. 

  1567.         c.setId(43);
    1568. 

  1568. 

  1569.         return c;
    1570. 

  1570.     }
    1571. 

  1571. 

  1572.     public static synchronized Context getTemplatesToUsers() {
    1573. 

  1573.         Context c = new Context();
    1574. 

  1574.         c.setSubID(DEFAULT_SUBID);
    1575. 

  1575.         c.setDbIdentity(IDENTITY_TEMPLATES_TO_USERS);
    1576. 

  1576.         c.setId(44);
    1577. 

  1577. 

  1578.         return c;
    1579. 

  1579.     }
    1580. 

  1580. 

  1581.     public static synchronized Context getReminder() {
    1582. 

  1582.         Context c = new Context();
    1583. 

  1583.         c.setSubID(DEFAULT_SUBID);
    1584. 

  1584.         c.setDbIdentity(IDENTITY_REMINDERS);
    1585. 

  1585.         c.setIdentityClass(IDENTITY_REMINDER_CLASS);
    1586. 

  1586.         c.setId(45);
    1587. 

  1587. 

  1588.         return c;
    1589. 

  1589.     }
    1590. 

  1590. 

  1591.     public static synchronized Context getStage() {
    1592. 

  1592.         Context c = new Context();
    1593. 

  1593.         c.setSubID(DEFAULT_SUBID);
    1594. 

  1594.         c.setDbIdentity(IDENTITY_STAGES);
    1595. 

  1595.         c.setIdentityClass(IDENTITY_STAGE_CLASS);
    1596. 

  1596.         c.setId(46);
    1597. 

  1597. 

  1598.         return c;
    1599. 

  1599.     }
    1600. 

  1600. 

  1601.     public static synchronized Context getRevenue() {
    1602. 

  1602.         Context c = new Context();
    1603. 

  1603.         c.setSubID(DEFAULT_SUBID);
    1604. 

  1604.         c.setDbIdentity(IDENTITY_REVENUE);
    1605. 

  1605.         c.setIdentityClass(Revenue.class);
    1606. 

  1606.         c.setId(47);
    1607. 

  1607. 

  1608.         return c;
    1609. 

  1609.     }
    1610. 

  1610. 

  1611.     public static synchronized Context getExpense() {
    1612. 

  1612.         Context c = new Context();
    1613. 

  1613.         c.setSubID(DEFAULT_SUBID);
    1614. 

  1614.         c.setDbIdentity(IDENTITY_EXPENSE);
    1615. 

  1615.         c.setIdentityClass(IDENTITY_EXPENSE_CLASS);
    1616. 

  1616.         c.setId(48);
    1617. 

  1617. 

  1618.         return c;
    1619. 

  1619.     }
    1620. 

  1620. 

  1621.     public static synchronized Context getProductlist() {
    1622. 

  1622.         Context c = new Context();
    1623. 

  1623.         c.setSubID(DEFAULT_SUBID);
    1624. 

  1624.         c.setDbIdentity(IDENTITY_PRODUCTSLIST);
    1625. 

  1625.         c.setSearchFields(DEFAULT_PRODUCTSLIST_SEARCH);
    1626. 

  1626.         c.setIdentityClass(IDENTITY_PRODUCTLIST_CLASS);
    1627. 

  1627.         c.setId(48);
    1628. 

  1628. 

  1629.         return c;
    1630. 

  1630.     }
    1631. 

  1631. 

  1632.     public static synchronized Context getProductsToSuppliers() {
    1633. 

  1633.         Context c = new Context();
    1634. 

  1634.         c.setSubID(DEFAULT_SUBID);
    1635. 

  1635.         c.setDbIdentity(IDENTITY_PRODUCTS_TO_SUPPLIERS);
    1636. 

  1636.         c.setIdentityClass(IDENTITY_PRODUCTSTOSUPPLIERS_CLASS);
    1637. 

  1637.         c.setId(49);
    1638. 

  1638. 

  1639.         return c;
    1640. 

  1640.     }
    1641. 

  1641. 

  1642.     public static synchronized Context getValueProperties() {
    1643. 

  1643.         Context c = new Context();
    1644. 

  1644.         c.setSubID(DEFAULT_SUBID);
    1645. 

  1645.         c.setDbIdentity(IDENTITY_VALUE_PROPERTIES);
    1646. 

  1646.         c.setIdentityClass(IDENTITY_VALUEPROPERTY_CLASS);
    1647. 

  1647.         c.setId(50);
    1648. 

  1648. 

  1649.         return c;
    1650. 

  1650.     }
    1651. 

  1651. 

  1652.     public static synchronized Context getScheduleTypes() {
    1653. 

  1653.         Context c = new Context();
    1654. 

  1654.         c.setSubID(DEFAULT_SUBID);
    1655. 

  1655.         c.setDbIdentity(IDENTITY_SCHEDULE_TYPES);
    1656. 

  1656.         c.setIdentityClass(IDENTITY_SCHEDULETYPES_CLASS);
    1657. 

  1657.         c.setId(51);
    1658. 

  1658. 

  1659.         return c;
    1660. 

  1660.     }
    1661. 

  1661. 

  1662.     public static synchronized Context getConversation() {
    1663. 

  1663.         Context c = new Context();
    1664. 

  1664.         c.setSubID(DEFAULT_SUBID);
    1665. 

  1665.         c.setDbIdentity(IDENTITY_CONVERSATION);
    1666. 

  1666.         c.setIdentityClass(IDENTITY_CONVERSATION_CLASS);
    1667. 

  1667.         c.setSearchFields(DEFAULT_SUBID);
    1668. 

  1668.         c.setId(52);
    1669. 

  1669. 

  1670.         return c;
    1671. 

  1671.     }
    1672. 

  1672. 

  1673.     public static synchronized Context getProductPrice() {
    1674. 

  1674.         Context c = new Context();
    1675. 

  1675.         c.setSubID(DEFAULT_SUBID);
    1676. 

  1676.         c.setDbIdentity(IDENTITY_PRODUCT_PRICES);
    1677. 

  1677.         c.setIdentityClass(IDENTITY_PRODUCTPRICE_CLASS);
    1678. 

  1678.         c.setId(53);
    1679. 

  1679. 

  1680.         return c;
    1681. 

  1681.     }
    1682. 

  1682. 

  1683.     public static synchronized Context getActivityList() {
    1684. 

  1684.         Context c = new Context();
    1685. 

  1685.         c.setSubID(DEFAULT_SUBID);
    1686. 

  1686.         c.setDbIdentity(IDENTITY_ACTIVITYLIST);
    1687. 

  1687.         c.setSearchFields(DEFAULT_ACTIVITYLIST_SEARCH);
    1688. 

  1688.         c.setIdentityClass(IDENTITY_ACTIVITYLIST_CLASS);
    1689. 

  1689.         c.setId(54);
    1690. 

  1690. 

  1691.         return c;
    1692. 

  1692.     }
    1693. 

  1693. 

  1694.     public static synchronized Context getActivityListItems() {
    1695. 

  1695.         Context c = new Context();
    1696. 

  1696.         c.setSubID(DEFAULT_SUBID);
    1697. 

  1697.         c.setDbIdentity(IDENTITY_ACTIVITYLISTITEMS);
    1698. 

  1698.         c.setIdentityClass(IDENTITY_ACTIVITYITEMSLIST_CLASS);
    1699. 

  1699.         c.setId(55);
    1700. 

  1700. 

  1701.         return c;
    1702. 

  1702.     }
    1703. 

  1703. 

  1704.     public static Context getMassprint() {
    1705. 

  1705.         Context c = new Context();
    1706. 

  1706.         c.setSubID(DEFAULT_SUBID);
    1707. 

  1707.         c.setDbIdentity(IDENTITY_MASSPRINT);
    1708. 

  1708.         c.setIdentityClass(IDENTITY_MASSPRINT_CLASS);
    1709. 

  1709.         c.setId(56);
    1710. 

  1710. 

  1711.         return c;
    1712. 

  1712.     }
    1713. 

  1713.     
    1714. 

  1714.     public static Context getProductOrder() {
    1715. 

  1715.         Context c = new Context();
    1716. 

  1716.         c.setSubID(DEFAULT_SUBID);
    1717. 

  1717.         c.setDbIdentity(IDENTITY_PRODUCTORDER);
    1718. 

  1718.         c.setIdentityClass(IDENTITY_PRODUCTORDER_CLASS);
    1719. 

  1719.         c.setId(57);
    1720. 

  1720. 

  1721.         return c;
    1722. 

  1722.     }
    1723. 

  1723.      
    1724. 

  1724.     public static Context getProductOrderSubitem() {
    1725. 

  1725.         Context c = new Context();
    1726. 

  1726.         c.setSubID(DEFAULT_SUBID);
    1727. 

  1727.         c.setDbIdentity(IDENTITY_PRODUCTORDERSUBITEM);
    1728. 

  1728.         c.setIdentityClass(IDENTITY_PRODUCTORDERSUBITEM_CLASS);
    1729. 

  1729.         c.setId(58);
    1730. 

  1730. 

  1731.         return c;
    1732. 

  1732.     }
    1733. 

  1733. 

  1734.     /////////////////////////////////////////////////////////////////////////////////////////////////
    1735. 

  1735.     /**
    1736. 

  1736.      *
    1737. 

  1737.      * @param contextdbidentity
    1738. 

  1738.      * @return The matching context or null if not existing
    1739. 

  1739.      */
    1740. 

  1740.     public static synchronized Context getMatchingContext(String contextdbidentity) {
    1741. 

  1741.         if (contextdbidentity.toLowerCase().endsWith("ids")) {
    1742. 

  1742.             contextdbidentity = contextdbidentity.replace("ids", "");
    1743. 

  1743.         }
    1744. 

  1744.         for (int i = 0; i < allContexts.size(); i++) {
    1745. 

  1745.             Context context = allContexts.get(i);
    1746. 

  1746.             if (context.getDbIdentity().equalsIgnoreCase(contextdbidentity)) {
    1747. 

  1747.                 return context;
    1748. 

  1748.             }
    1749. 

  1749.         }
    1750. 

  1750.         Log.Debug(Context.class, "Context not found for name: " + contextdbidentity);
    1751. 

  1751.         return null;
    1752. 

  1752.     }
    1753. 

  1753. 

  1754.     /**
    1755. 

  1755.      *
    1756. 

  1756.      * @param contextId
    1757. 

  1757.      * @return The matching context or null if not existing
    1758. 

  1758.      */
    1759. 

  1759.     public static synchronized Context getMatchingContext(int contextId) {
    1760. 

  1760.         for (int i = 0; i < allContexts.size(); i++) {
    1761. 

  1761.             Context context = allContexts.get(i);
    1762. 

  1762.             if (context.getId() == contextId) {
    1763. 

  1763.                 return context;
    1764. 

  1764.             }
    1765. 

  1765.         }
    1766. 

  1766.         Log.Debug(Context.class, "Context not found for id: " + contextId);
    1767. 

  1767.         return null;
    1768. 

  1768.     }
    1769. 

  1769. 

  1770.     public void setSearchFields(String fields) {
    1771. 

  1771.         defResultFields = fields;
    1772. 

  1772.     }
    1773. 

  1773. 

  1774.     /**
    1775. 

  1775.      * @param identityClass the identityClass to set
    1776. 

  1776.      */
    1777. 

  1777.     public final void setIdentityClass(Class identityClass) {
    1778. 

  1778.         this.identityClass = identityClass;
    1779. 

  1779.     }
    1780. 

  1780. 

  1781.     @Override
    1782. 

  1782.     public String toString() {
    1783. 

  1783.         if (true/*getIdentityClass() == null*/) {
    1784. 

  1784.             return String.valueOf(dbIdentity).toUpperCase() + " [" + id + "]";
    1785. 

  1785.         } else {
    1786. 

  1786.             return "<html>"+String.valueOf(dbIdentity).toUpperCase() + " [" + id + "] (<b>"
    1787.