Package com.jada.jpa.entity

Examples of com.jada.jpa.entity.Item

285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
    AdminBean adminBean = getAdminBean(request);
    Site site = adminBean.getSite();
    initSiteProfiles(form, site);

    Item item = new Item();
    if (!insertMode) {
      item = ItemDAO.load(site.getSiteId(), Format.getLong(form.getItemId()));
    }

    ActionMessages errors = validate(request, form, site.getSiteId(), insertMode, item);
    if (errors.size() != 0) {
      saveMessages(request, errors);
      createAdditionalInfo(adminBean, form, item);
      return mapping.findForward("error");
    }

    if (insertMode) {
      item.setSite(site);
      item.setItemTypeCd(form.getItemTypeCd());
      item.setItemHitCounter(new Integer(0));
      item.setItemRating(new Float(0));
      item.setItemRatingCount(new Integer(0));
      item.setItemQty(new Integer(0));
      item.setItemBookedQty(new Integer(0));
      item.setRecCreateBy(adminBean.getUser().getUserId());
      item.setRecCreateDatetime(new Date(System.currentTimeMillis()));
     
      if (!Format.isNullOrEmpty(form.getCustomAttribGroupId())) {
        Long customAttribGroupId = Format.getLong(form.getCustomAttribGroupId());
        CustomAttributeGroup customAttributeGroup = CustomAttributeGroupDAO.load(site.getSiteId(), customAttribGroupId);
        item.setCustomAttributeGroup(customAttributeGroup);
        form.setCustomAttribGroupName(customAttributeGroup.getCustomAttribGroupName());

        String sql = "select   customAttributeDetail " +
                   "from     CustomAttributeGroup customAttributeGroup " +
                   "join   customAttributeGroup.customAttributeDetails customAttributeDetail  " +
                   "where    customAttributeGroup.customAttribGroupId = :customAttribGroupId " +
                   "order    by customAttributeDetail.seqNum ";
        Query query = em.createQuery(sql);
        query.setParameter("customAttribGroupId", Format.getLong(form.getCustomAttribGroupId()));
        Iterator<?> iterator = query.getResultList().iterator();
        Vector<ItemAttributeDetailDisplayForm> itemAttributeDetails = new Vector<ItemAttributeDetailDisplayForm>();
        boolean itemAttributeLangFlag = false;
        while (iterator.hasNext()) {
          CustomAttributeDetail customAttributeDetail = (CustomAttributeDetail) iterator.next();
/*
          ItemAttributeDetail itemAttributeDetail = new ItemAttributeDetail();
          itemAttributeDetail.setItem(item);
          itemAttributeDetail.setCustomAttributeDetail(customAttributeDetail);
          itemAttributeDetail.setRecUpdateBy(adminBean.getUser().getUserId());
          itemAttributeDetail.setRecUpdateDatetime(new Date(System.currentTimeMillis()));
          itemAttributeDetail.setRecCreateBy(adminBean.getUser().getUserId());
          itemAttributeDetail.setRecCreateDatetime(new Date(System.currentTimeMillis()));
         
          ItemAttributeDetailLanguage itemAttributeDetailLanguage = new ItemAttributeDetailLanguage();
          itemAttributeDetailLanguage.setItemAttribDetailValue("");
          itemAttributeDetailLanguage.setRecUpdateBy(adminBean.getUser().getUserId());
          itemAttributeDetailLanguage.setRecUpdateDatetime(new Date(System.currentTimeMillis()));
          itemAttributeDetailLanguage.setRecCreateBy(adminBean.getUser().getUserId());
          itemAttributeDetailLanguage.setRecCreateDatetime(new Date(System.currentTimeMillis()));
          SiteProfileClass siteProfileClass = SiteProfileClassDAO.load(form.getSiteProfileClassDefaultId());
          itemAttributeDetailLanguage.setSiteProfileClass(siteProfileClass);
          if (customAttributeDetail.getCustomAttribute().getCustomAttribTypeCode() == Constants.CUSTOM_ATTRIBUTE_TYPE_USER_SELECT_DROPDOWN) {
            CustomAttributeOption customAttributeOption = null;
            for (CustomAttributeOption option : customAttributeDetail.getCustomAttribute().getCustomAttributeOptions()) {
              customAttributeOption = option;
              break;
            }
            itemAttributeDetail.setCustomAttributeOption(customAttributeOption);
          }
          em.persist(itemAttributeDetailLanguage);
         
          itemAttributeDetail.setItemAttributeDetailLanguage(itemAttributeDetailLanguage);
          em.persist(itemAttributeDetail);
*/
          ItemAttributeDetailDisplayForm displayForm = new ItemAttributeDetailDisplayForm();
          displayForm.setCustomAttribId(customAttributeDetail.getCustomAttribute().getCustomAttribId().toString());
          displayForm.setCustomAttribTypeCode(String.valueOf(customAttributeDetail.getCustomAttribute().getCustomAttribTypeCode()));
          displayForm.setCustomAttribDetailId(customAttributeDetail.getCustomAttribDetailId().toString());
          displayForm.setCustomAttribName(customAttributeDetail.getCustomAttribute().getCustomAttribName());
          displayForm.setCustomAttribTypeCode(String.valueOf(customAttributeDetail.getCustomAttribute().getCustomAttribTypeCode()));
          displayForm.setItemAttribDetailValue("");
          itemAttributeDetails.add(displayForm);
        }
        form.setItemAttribDetailValueLangFlag(itemAttributeLangFlag);
        ItemAttributeDetailDisplayForm[] itemAttributeDetailDisplayForms = new ItemAttributeDetailDisplayForm[itemAttributeDetails.size()];
        itemAttributeDetails.copyInto(itemAttributeDetailDisplayForms);
        form.setItemAttributeDetails(itemAttributeDetailDisplayForms);
      }
      form.setItemTypeDesc(resources.getMessage("item.typeCode." + form.getItemTypeCd()));
    }
   
    if (form.isSiteProfileClassDefault() && form.isSiteCurrencyClassDefault()) {
      saveDefault(item, form, adminBean, insertMode);
      form.setRecUpdateBy(item.getRecUpdateBy());
      form.setRecUpdateDatetime(Format.getFullDatetime(item.getRecUpdateDatetime()));
      User user = adminBean.getUser();
      item.setUser(user);
      if (insertMode) {
        em.persist(item);
        form.setItemId(Format.getLong(item.getItemId()));
      }
      else {
        // em.update(item);
      }
    }
    else {
      if (!form.isSiteProfileClassDefault()) {
        saveLanguage(item, form, adminBean);
      }
      if (!form.isSiteCurrencyClassDefault()) {
        saveCurrency(item, form, adminBean);
      }     
    }
   
    if (!Format.isNullOrEmpty(form.getShippingTypeId())) {
      ShippingType shippingType = (ShippingType) em.find(ShippingType.class, Format.getLong(form.getShippingTypeId()));
      if (shippingType != null) {
        item.setShippingType(shippingType);
      }
    }
    else {
      item.setShippingType(null);
    }
   
    if (!Format.isNullOrEmpty(form.getProductClassId())) {
      ProductClass productClass = (ProductClass) em.find(ProductClass.class, Format.getLong(form.getProductClassId()));
      if (productClass != null) {
        item.setProductClass(productClass);
      }
    }
    else {
      item.setShippingType(null);
    }
   
    CategorySearchUtil.itemPriceSearchUpdate(item, site, adminBean);
    CategorySearchUtil.itemDescSearchUpdate(item, site, adminBean);
    if (insertMode) {
      em.persist(item);
      form.setItemId(Format.getLong(item.getItemId()));
    }
    else {
      // em.update(item);
    }
   
    Iterator<?> iterator = item.getMenus().iterator();
    while (iterator.hasNext()) {
      Menu menu = (Menu) iterator.next();
      CacheDAO.removeByKeyPrefix(site.getSiteId(), Constants.CACHE_MENU + "." + menu.getMenuSetName());
    }
   
View Full Code Here
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
1001
1002
    Site site = adminBean.getSite();
        initSiteProfiles(form, site);
 
       EntityManager em = JpaConnection.getInstance().getCurrentEntityManager();
       String itemTierPriceId = form.getItemTierPriceId();
    Item item = ItemDAO.load(site.getSiteId(), Format.getLong(form.getItemId()));
   
    for (ItemTierPrice itemTierPrice : item.getItemTierPrices()) {
      if (itemTierPrice.getItemTierPriceId().equals(Format.getLong(itemTierPriceId))) {
        em.remove(itemTierPrice);
        for (ItemTierPriceCurrency itemTierPriceCurrency : itemTierPrice.getItemTierPriceCurrencies()) {
          itemTierPrice.getItemTierPriceCurrencies().remove(itemTierPriceCurrency);
          em.remove(itemTierPriceCurrency);
        }
      }
    }
    item.setRecUpdateBy(adminBean.getUser().getUserId());
    item.setRecUpdateDatetime(new Date(System.currentTimeMillis()));

      JSONEscapeObject jsonResult = new JSONEscapeObject();
    jsonResult.put("status", Constants.WEBSERVICE_STATUS_SUCCESS);
    jsonResult.put("recUpdateBy", item.getRecUpdateBy());
    jsonResult.put("recUpdateDatetime", Format.getFullDatetime(item.getRecUpdateDatetime()));
    String jsonString = jsonResult.toHtmlString();
    streamWebService(response, jsonString);
    em.getTransaction().commit();
      return null;
  }
View Full Code Here
1054
1055
1056
1057
1058
1059
1060
1061
1062
1063
1064
1065
1066
1067
1068
1069
1070
1071
1072
1073
1074
1075
1076
1077
1078
1079
1080
1081
1082
1083
1084
1085
1086
1087
1088
1089
1090
1091
1092
1093
1094
1095
1096
1097
1098
1099
1100
1101
1102
1103
1104
1105
1106
1107
1108
1109
1110
1111
1112
1113
1114
1115
1116
1117
1118
1119
1120
1121
1122
1123
1124
1125
1126
1127
1128
1129
1130
1131
1132
1133
1134
1135
1136
1137
1138
1139
1140
1141
1142
1143
1144
1145
1146
1147
1148
1149
1150
1151
1152
1153
1154
1155
1156
        jsonResult.put("itemTierPrice", resources.getMessage("error.float.invalid"));
      }
    }

       String itemTierPriceId = form.getItemTierPriceId();
    Item item = ItemDAO.load(site.getSiteId(), Format.getLong(form.getItemId()));
    ItemTierPrice itemTierPrice = null;
    ItemTierPriceCurrency itemTierPriceCurrency = null;
    boolean exist = true;
    if (!Format.isNullOrEmpty(itemTierPriceId)) {
      itemTierPrice = ItemTierPriceDAO.load(site.getSiteId(), Format.getLong(itemTierPriceId));
      itemTierPriceCurrency = itemTierPrice.getItemTierPriceCurrency();
    }
    else {
      itemTierPrice = new ItemTierPrice();
      itemTierPrice.setRecCreateBy(adminBean.getUser().getUserId());
      itemTierPrice.setRecCreateDatetime(new Date(System.currentTimeMillis()));
      itemTierPrice.setItem(item);
     
      itemTierPriceCurrency = new ItemTierPriceCurrency();
      exist = false;
      itemTierPriceCurrency.setRecCreateBy(adminBean.getUser().getUserId());
      itemTierPriceCurrency.setRecCreateDatetime(new Date(System.currentTimeMillis()));
      itemTierPrice.setItemTierPriceCurrency(itemTierPriceCurrency);
      itemTierPrice.getItemTierPriceCurrencies().add(itemTierPriceCurrency);
      SiteCurrencyClass siteCurrencyClass = SiteCurrencyClassDAO.load(form.getSiteCurrencyClassDefaultId());
      itemTierPriceCurrency.setSiteCurrencyClass(siteCurrencyClass);
    }
    if (form.isSiteCurrencyClassDefault()) {
      itemTierPriceCurrency.setItemPrice(Format.getFloat(form.getItemTierPrice()));
      itemTierPriceCurrency.setRecUpdateBy(adminBean.getUser().getUserId());
      itemTierPriceCurrency.setRecUpdateDatetime(new Date(System.currentTimeMillis()));
      if (!exist) {
        em.persist(itemTierPriceCurrency);
      }

      itemTierPrice.setItemTierQty(Format.getIntObj(form.getItemTierQty()));
      if (!Format.isNullOrEmpty(form.getItemTierPricePublishOn())) {
        itemTierPrice.setItemTierPricePublishOn(Format.getDate(form.getItemTierPricePublishOn()));
      }
      else {
        itemTierPrice.setItemTierPricePublishOn(null);
      }
      if (!Format.isNullOrEmpty(form.getItemTierPriceExpireOn())) {
        itemTierPrice.setItemTierPriceExpireOn(Format.getDate(form.getItemTierPriceExpireOn()));
      }
      else {
        itemTierPrice.setItemTierPriceExpireOn(null);
      }
      itemTierPrice.setRecUpdateBy(adminBean.getUser().getUserId());
      itemTierPrice.setRecUpdateDatetime(new Date(System.currentTimeMillis()));
      if (Format.isNullOrEmpty(form.getCustClassId())) {
        itemTierPrice.setCustomerClass(null);
      }
      else {
        CustomerClass customerClass = CustomerClassDAO.load(site.getSiteId(), Format.getLong(form.getCustClassId()));
        itemTierPrice.setCustomerClass(customerClass);
      }
      em.persist(itemTierPrice);
    }
    else {
      itemTierPriceCurrency = null;
      SiteCurrencyClass siteCurrencyClass = SiteCurrencyClassDAO.load(form.getSiteCurrencyClassId());
      for (ItemTierPriceCurrency priceCurrency : itemTierPrice.getItemTierPriceCurrencies()) {
        if (priceCurrency.getSiteCurrencyClass().getSiteCurrencyClassId().equals(siteCurrencyClass.getSiteCurrencyClassId())) {
          itemTierPriceCurrency = priceCurrency;
          break;
        }
      }
      exist = true;
      if (itemTierPriceCurrency == null) {
        itemTierPriceCurrency = new ItemTierPriceCurrency();
        exist = false;
        itemTierPriceCurrency.setRecCreateBy(adminBean.getUser().getUserId());
        itemTierPriceCurrency.setRecCreateDatetime(new Date(System.currentTimeMillis()));
        itemTierPriceCurrency.setItemTierPrice(itemTierPrice);
        itemTierPriceCurrency.setSiteCurrencyClass(siteCurrencyClass);
      }
      if (form.isItemTierPriceOverride()) {
        itemTierPriceCurrency.setItemPrice(Format.getFloat(form.getItemTierPrice()));
      }
      else {
        itemTierPriceCurrency.setItemPrice(null);
      }
      itemTierPriceCurrency.setRecUpdateBy(adminBean.getUser().getUserId());
      itemTierPriceCurrency.setRecUpdateDatetime(new Date(System.currentTimeMillis()));
      if (!exist) {
        em.persist(itemTierPriceCurrency);
      }
    }

    item.setRecUpdateBy(adminBean.getUser().getUserId());
    item.setRecUpdateDatetime(new Date(System.currentTimeMillis()));
    em.persist(item);

    jsonResult = new JSONEscapeObject();
    jsonResult.put("status", Constants.WEBSERVICE_STATUS_SUCCESS);
    jsonResult.put("itemTierPriceId", itemTierPrice.getItemTierPriceId());
    jsonResult.put("recUpdateBy", item.getRecUpdateBy());
    jsonResult.put("recUpdateDatetime", Format.getFullDatetime(item.getRecUpdateDatetime()));
    streamWebService(response, jsonResult.toHtmlString());
    return null;
  }
View Full Code Here
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
      jsonResult.put("itemUpcCd", itemUpcCd);
      jsonResult.put("itemShortDesc", itemShortDesc);
      int counter = 0;
      Vector<JSONEscapeObject> vector = new Vector<JSONEscapeObject>();
        while (iterator.hasNext()) {
          Item item = (Item) iterator.next();
          JSONEscapeObject jsonItem = new JSONEscapeObject();
          jsonItem.put("itemId", item.getItemId());
          jsonItem.put("itemNum", item.getItemNum());
          jsonItem.put("itemUpcCd", item.getItemUpcCd());
          jsonItem.put("itemShortDesc", item.getItemLanguage().getItemShortDesc());
          vector.add(jsonItem);
          counter++;
          if (counter == Constants.ADMIN_SEARCH_MAXCOUNT) {
              MessageResources resources = this.getResources(request);
            jsonResult.put("message", resources.getMessage("error.lookup.tooManyRecord"));
View Full Code Here
599
600
601
602
603
604
605
606
607
608
609
610
        content.getCategories().remove(parent);
      }
     
      iterator = parent.getItems().iterator();
      while (iterator.hasNext()) {
        Item item = (Item) iterator.next();
        item.getCategories().remove(parent);
      }
     
    for (Menu menu : parent.getMenus()) {
      menu.setItem(null);
      CacheDAO.removeByKeyPrefix(siteId, Constants.CACHE_MENU + "." + menu.getMenuSetName());
View Full Code Here
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
public class ItemDAO extends Item {
  private static final long serialVersionUID = 5075471885223815088L;

  public static Item load(String siteId, Long itemId, LockModeType lockModeType) throws SecurityException, Exception {
      EntityManager em = JpaConnection.getInstance().getCurrentEntityManager();
      Item item = (Item) em.find(Item.class, itemId);
      if (lockModeType != null) {
        em.lock(item, lockModeType);
      }
      if (item != null) {
      if (!item.getSiteId().equals(siteId)) {
        throw new SecurityException();
      }
      }
    return item;
  }
View Full Code Here
69
70
71
72
73
74
75
76
77
78
      Query query = em.createQuery("from Item where siteId = :siteId and itemNaturalKey = :itemNaturalKey");
      query.setParameter("siteId", siteId);
      query.setParameter("itemNaturalKey", itemNaturalKey);
      Iterator<?> iterator = query.getResultList().iterator();
      if (iterator.hasNext()) {
        Item item = (Item) iterator.next();
        return item;
      }
      return null;
  }
View Full Code Here
82
83
84
85
86
87
88
89
90
91
      Query query = em.createQuery("from Item where siteId = :siteId and itemSkuCd = :itemSkuCd");
      query.setParameter("siteId", siteId);
      query.setParameter("itemSkuCd", itemSkuCd);
      Iterator<?> iterator = query.getResultList().iterator();
      if (iterator.hasNext()) {
        Item item = (Item) iterator.next();
        return item;
      }
      return null;
  }
View Full Code Here
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
    while (iterator.hasNext()) {
      OrderItemDetail detail = (OrderItemDetail) iterator.next();
      OrderDetailDisplayForm dform = new OrderDetailDisplayForm();
      dform.setItemShortDesc(detail.getItemShortDesc());
     
      Item item = detail.getItem();
      if (item != null) {
        Item master = detail.getItem();
        if (item.getItemTypeCd().equals(Constants.ITEM_TYPE_SKU)) {
          master = item.getItemSkuParent();
        }
         
        ItemImage itemImage = master.getItemLanguage().getImage();
        if (itemImage != null) {
          dform.setImageId(itemImage.getImageId().toString());
        }
        dform.setItemShortDesc(master.getItemLanguage().getItemShortDesc());
        if (!contentBean.getContentSessionKey().isSiteProfileClassDefault()) {
          for (ItemLanguage itemLanguage : master.getItemLanguages()) {
            if (itemLanguage.getSiteProfileClass().getSiteProfileClassId().equals(contentBean.getContentSessionKey().getSiteProfileClassId())) {
              if (itemLanguage.getImage() != null) {
                itemImage = itemLanguage.getImage();
              }
              if (itemLanguage.getItemShortDesc() != null) {
View Full Code Here
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
    float itemDetailSubTotal = 0;
    while (iterator.hasNext()) {
      OrderItemDetail orderItemDetail = (OrderItemDetail) iterator.next();
      OrderItemDetailDisplayForm itemDisplay = new OrderItemDetailDisplayForm();
      itemDisplay.setOrderItemDetailId(orderItemDetail.getOrderItemDetailId().toString());
      Item item = orderItemDetail.getItem();
      itemDisplay.setItemId("");
      itemDisplay.setItemNum(orderItemDetail.getItemNum());
      itemDisplay.setItemSkuCd(orderItemDetail.getItemSkuCd());
      itemDisplay.setItemShortDesc(orderItemDetail.getItemShortDesc());
      itemDisplay.setItemTierQty(Format.getInt(orderItemDetail.getItemTierQty()));
      itemDisplay.setItemTierPrice(Format.getFloat(orderItemDetail.getItemTierPrice()));
      itemDisplay.setItemOrderQty(Format.getInt(orderItemDetail.getItemOrderQty()));
      itemDisplay.setItemDetailAmount(Format.getFloat(orderItemDetail.getItemDetailAmount()));
      itemDisplay.setItemDetailDiscountAmount(Format.getFloat(orderItemDetail.getItemDetailDiscountAmount()));
      float total = orderItemDetail.getItemDetailAmount() - orderItemDetail.getItemDetailDiscountAmount();
      itemDisplay.setItemDetailSubTotal(Format.getFloat(total));
     
      if (item != null) {
        itemDisplay.setItemId(item.getItemId().toString());
        itemDisplay.setItemShortDesc(orderItemDetail.getItem().getItemLanguage().getItemShortDesc());
      }
     
      Vector<OrderItemAttributeBean> orderItemAttributes = new Vector<OrderItemAttributeBean>();
      if (item != null && item.getItemTypeCd().equals(Constants.ITEM_TYPE_SKU)) {
          for (ItemAttributeDetail itemAttributeDetail : item.getItemAttributeDetails()) {
            CustomAttribute customAttribute = itemAttributeDetail.getCustomAttributeDetail().getCustomAttribute();
            if (customAttribute.getCustomAttribTypeCode() != Constants.CUSTOM_ATTRIBUTE_TYPE_SKU_MAKEUP) {
              continue;
            }
            OrderItemAttributeBean orderItemAttributeBean = new OrderItemAttributeBean();
View Full Code Here
TOP

Related Classes of com.jada.jpa.entity.Item

  • com.jada.admin.category.CategoryMaintAction
  • com.jada.admin.coupon.CouponMaintAction
  • com.jada.admin.homePage.HomePageMaintAction
  • com.jada.admin.ie.ExportAction
  • com.jada.admin.inventory.OrderMaintBaseAction
  • com.jada.admin.item.ItemListingAction
  • com.jada.admin.item.ItemMaintAction
  • com.jada.admin.lookup.ItemLookupAction
  • com.jada.admin.menu.MenuMaintAction
  • com.jada.admin.moderation.ModerationMaintAction
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.