001    /**
002     * Copyright (c) 2000-present Liferay, Inc. All rights reserved.
003     *
004     * This library is free software; you can redistribute it and/or modify it under
005     * the terms of the GNU Lesser General Public License as published by the Free
006     * Software Foundation; either version 2.1 of the License, or (at your option)
007     * any later version.
008     *
009     * This library is distributed in the hope that it will be useful, but WITHOUT
010     * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
011     * FOR A PARTICULAR PURPOSE. See the GNU Lesser General Public License for more
012     * details.
013     */
014    
015    package com.liferay.portlet.shopping.service.base;
016    
017    import aQute.bnd.annotation.ProviderType;
018    
019    import com.liferay.portal.kernel.bean.BeanReference;
020    import com.liferay.portal.kernel.bean.IdentifiableBean;
021    import com.liferay.portal.kernel.dao.db.DB;
022    import com.liferay.portal.kernel.dao.db.DBFactoryUtil;
023    import com.liferay.portal.kernel.dao.jdbc.SqlUpdate;
024    import com.liferay.portal.kernel.dao.jdbc.SqlUpdateFactoryUtil;
025    import com.liferay.portal.kernel.dao.orm.ActionableDynamicQuery;
026    import com.liferay.portal.kernel.dao.orm.DefaultActionableDynamicQuery;
027    import com.liferay.portal.kernel.dao.orm.DynamicQuery;
028    import com.liferay.portal.kernel.dao.orm.DynamicQueryFactoryUtil;
029    import com.liferay.portal.kernel.dao.orm.Projection;
030    import com.liferay.portal.kernel.exception.PortalException;
031    import com.liferay.portal.kernel.exception.SystemException;
032    import com.liferay.portal.kernel.search.Indexable;
033    import com.liferay.portal.kernel.search.IndexableType;
034    import com.liferay.portal.kernel.util.OrderByComparator;
035    import com.liferay.portal.model.PersistedModel;
036    import com.liferay.portal.service.BaseLocalServiceImpl;
037    import com.liferay.portal.service.PersistedModelLocalServiceRegistry;
038    import com.liferay.portal.service.persistence.UserFinder;
039    import com.liferay.portal.service.persistence.UserPersistence;
040    import com.liferay.portal.util.PortalUtil;
041    
042    import com.liferay.portlet.shopping.model.ShoppingCoupon;
043    import com.liferay.portlet.shopping.service.ShoppingCouponLocalService;
044    import com.liferay.portlet.shopping.service.persistence.ShoppingCategoryPersistence;
045    import com.liferay.portlet.shopping.service.persistence.ShoppingCouponFinder;
046    import com.liferay.portlet.shopping.service.persistence.ShoppingCouponPersistence;
047    import com.liferay.portlet.shopping.service.persistence.ShoppingItemFinder;
048    import com.liferay.portlet.shopping.service.persistence.ShoppingItemPersistence;
049    
050    import java.io.Serializable;
051    
052    import java.util.List;
053    
054    import javax.sql.DataSource;
055    
056    /**
057     * Provides the base implementation for the shopping coupon local service.
058     *
059     * <p>
060     * This implementation exists only as a container for the default service methods generated by ServiceBuilder. All custom service methods should be put in {@link com.liferay.portlet.shopping.service.impl.ShoppingCouponLocalServiceImpl}.
061     * </p>
062     *
063     * @author Brian Wing Shun Chan
064     * @see com.liferay.portlet.shopping.service.impl.ShoppingCouponLocalServiceImpl
065     * @see com.liferay.portlet.shopping.service.ShoppingCouponLocalServiceUtil
066     * @generated
067     */
068    @ProviderType
069    public abstract class ShoppingCouponLocalServiceBaseImpl
070            extends BaseLocalServiceImpl implements ShoppingCouponLocalService,
071                    IdentifiableBean {
072            /*
073             * NOTE FOR DEVELOPERS:
074             *
075             * Never modify or reference this class directly. Always use {@link com.liferay.portlet.shopping.service.ShoppingCouponLocalServiceUtil} to access the shopping coupon local service.
076             */
077    
078            /**
079             * Adds the shopping coupon to the database. Also notifies the appropriate model listeners.
080             *
081             * @param shoppingCoupon the shopping coupon
082             * @return the shopping coupon that was added
083             */
084            @Indexable(type = IndexableType.REINDEX)
085            @Override
086            public ShoppingCoupon addShoppingCoupon(ShoppingCoupon shoppingCoupon) {
087                    shoppingCoupon.setNew(true);
088    
089                    return shoppingCouponPersistence.update(shoppingCoupon);
090            }
091    
092            /**
093             * Creates a new shopping coupon with the primary key. Does not add the shopping coupon to the database.
094             *
095             * @param couponId the primary key for the new shopping coupon
096             * @return the new shopping coupon
097             */
098            @Override
099            public ShoppingCoupon createShoppingCoupon(long couponId) {
100                    return shoppingCouponPersistence.create(couponId);
101            }
102    
103            /**
104             * Deletes the shopping coupon with the primary key from the database. Also notifies the appropriate model listeners.
105             *
106             * @param couponId the primary key of the shopping coupon
107             * @return the shopping coupon that was removed
108             * @throws PortalException if a shopping coupon with the primary key could not be found
109             */
110            @Indexable(type = IndexableType.DELETE)
111            @Override
112            public ShoppingCoupon deleteShoppingCoupon(long couponId)
113                    throws PortalException {
114                    return shoppingCouponPersistence.remove(couponId);
115            }
116    
117            /**
118             * Deletes the shopping coupon from the database. Also notifies the appropriate model listeners.
119             *
120             * @param shoppingCoupon the shopping coupon
121             * @return the shopping coupon that was removed
122             */
123            @Indexable(type = IndexableType.DELETE)
124            @Override
125            public ShoppingCoupon deleteShoppingCoupon(ShoppingCoupon shoppingCoupon) {
126                    return shoppingCouponPersistence.remove(shoppingCoupon);
127            }
128    
129            @Override
130            public DynamicQuery dynamicQuery() {
131                    Class<?> clazz = getClass();
132    
133                    return DynamicQueryFactoryUtil.forClass(ShoppingCoupon.class,
134                            clazz.getClassLoader());
135            }
136    
137            /**
138             * Performs a dynamic query on the database and returns the matching rows.
139             *
140             * @param dynamicQuery the dynamic query
141             * @return the matching rows
142             */
143            @Override
144            public <T> List<T> dynamicQuery(DynamicQuery dynamicQuery) {
145                    return shoppingCouponPersistence.findWithDynamicQuery(dynamicQuery);
146            }
147    
148            /**
149             * Performs a dynamic query on the database and returns a range of the matching rows.
150             *
151             * <p>
152             * Useful when paginating results. Returns a maximum of <code>end - start</code> instances. <code>start</code> and <code>end</code> are not primary keys, they are indexes in the result set. Thus, <code>0</code> refers to the first result in the set. Setting both <code>start</code> and <code>end</code> to {@link com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS} will return the full result set. If <code>orderByComparator</code> is specified, then the query will include the given ORDER BY logic. If <code>orderByComparator</code> is absent and pagination is required (<code>start</code> and <code>end</code> are not {@link com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS}), then the query will include the default ORDER BY logic from {@link com.liferay.portlet.shopping.model.impl.ShoppingCouponModelImpl}. If both <code>orderByComparator</code> and pagination are absent, for performance reasons, the query will not have an ORDER BY clause and the returned result set will be sorted on by the primary key in an ascending order.
153             * </p>
154             *
155             * @param dynamicQuery the dynamic query
156             * @param start the lower bound of the range of model instances
157             * @param end the upper bound of the range of model instances (not inclusive)
158             * @return the range of matching rows
159             */
160            @Override
161            public <T> List<T> dynamicQuery(DynamicQuery dynamicQuery, int start,
162                    int end) {
163                    return shoppingCouponPersistence.findWithDynamicQuery(dynamicQuery,
164                            start, end);
165            }
166    
167            /**
168             * Performs a dynamic query on the database and returns an ordered range of the matching rows.
169             *
170             * <p>
171             * Useful when paginating results. Returns a maximum of <code>end - start</code> instances. <code>start</code> and <code>end</code> are not primary keys, they are indexes in the result set. Thus, <code>0</code> refers to the first result in the set. Setting both <code>start</code> and <code>end</code> to {@link com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS} will return the full result set. If <code>orderByComparator</code> is specified, then the query will include the given ORDER BY logic. If <code>orderByComparator</code> is absent and pagination is required (<code>start</code> and <code>end</code> are not {@link com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS}), then the query will include the default ORDER BY logic from {@link com.liferay.portlet.shopping.model.impl.ShoppingCouponModelImpl}. If both <code>orderByComparator</code> and pagination are absent, for performance reasons, the query will not have an ORDER BY clause and the returned result set will be sorted on by the primary key in an ascending order.
172             * </p>
173             *
174             * @param dynamicQuery the dynamic query
175             * @param start the lower bound of the range of model instances
176             * @param end the upper bound of the range of model instances (not inclusive)
177             * @param orderByComparator the comparator to order the results by (optionally <code>null</code>)
178             * @return the ordered range of matching rows
179             */
180            @Override
181            public <T> List<T> dynamicQuery(DynamicQuery dynamicQuery, int start,
182                    int end, OrderByComparator<T> orderByComparator) {
183                    return shoppingCouponPersistence.findWithDynamicQuery(dynamicQuery,
184                            start, end, orderByComparator);
185            }
186    
187            /**
188             * Returns the number of rows matching the dynamic query.
189             *
190             * @param dynamicQuery the dynamic query
191             * @return the number of rows matching the dynamic query
192             */
193            @Override
194            public long dynamicQueryCount(DynamicQuery dynamicQuery) {
195                    return shoppingCouponPersistence.countWithDynamicQuery(dynamicQuery);
196            }
197    
198            /**
199             * Returns the number of rows matching the dynamic query.
200             *
201             * @param dynamicQuery the dynamic query
202             * @param projection the projection to apply to the query
203             * @return the number of rows matching the dynamic query
204             */
205            @Override
206            public long dynamicQueryCount(DynamicQuery dynamicQuery,
207                    Projection projection) {
208                    return shoppingCouponPersistence.countWithDynamicQuery(dynamicQuery,
209                            projection);
210            }
211    
212            @Override
213            public ShoppingCoupon fetchShoppingCoupon(long couponId) {
214                    return shoppingCouponPersistence.fetchByPrimaryKey(couponId);
215            }
216    
217            /**
218             * Returns the shopping coupon with the primary key.
219             *
220             * @param couponId the primary key of the shopping coupon
221             * @return the shopping coupon
222             * @throws PortalException if a shopping coupon with the primary key could not be found
223             */
224            @Override
225            public ShoppingCoupon getShoppingCoupon(long couponId)
226                    throws PortalException {
227                    return shoppingCouponPersistence.findByPrimaryKey(couponId);
228            }
229    
230            @Override
231            public ActionableDynamicQuery getActionableDynamicQuery() {
232                    ActionableDynamicQuery actionableDynamicQuery = new DefaultActionableDynamicQuery();
233    
234                    actionableDynamicQuery.setBaseLocalService(com.liferay.portlet.shopping.service.ShoppingCouponLocalServiceUtil.getService());
235                    actionableDynamicQuery.setClass(ShoppingCoupon.class);
236                    actionableDynamicQuery.setClassLoader(getClassLoader());
237    
238                    actionableDynamicQuery.setPrimaryKeyPropertyName("couponId");
239    
240                    return actionableDynamicQuery;
241            }
242    
243            protected void initActionableDynamicQuery(
244                    ActionableDynamicQuery actionableDynamicQuery) {
245                    actionableDynamicQuery.setBaseLocalService(com.liferay.portlet.shopping.service.ShoppingCouponLocalServiceUtil.getService());
246                    actionableDynamicQuery.setClass(ShoppingCoupon.class);
247                    actionableDynamicQuery.setClassLoader(getClassLoader());
248    
249                    actionableDynamicQuery.setPrimaryKeyPropertyName("couponId");
250            }
251    
252            /**
253             * @throws PortalException
254             */
255            @Override
256            public PersistedModel deletePersistedModel(PersistedModel persistedModel)
257                    throws PortalException {
258                    return shoppingCouponLocalService.deleteShoppingCoupon((ShoppingCoupon)persistedModel);
259            }
260    
261            @Override
262            public PersistedModel getPersistedModel(Serializable primaryKeyObj)
263                    throws PortalException {
264                    return shoppingCouponPersistence.findByPrimaryKey(primaryKeyObj);
265            }
266    
267            /**
268             * Returns a range of all the shopping coupons.
269             *
270             * <p>
271             * Useful when paginating results. Returns a maximum of <code>end - start</code> instances. <code>start</code> and <code>end</code> are not primary keys, they are indexes in the result set. Thus, <code>0</code> refers to the first result in the set. Setting both <code>start</code> and <code>end</code> to {@link com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS} will return the full result set. If <code>orderByComparator</code> is specified, then the query will include the given ORDER BY logic. If <code>orderByComparator</code> is absent and pagination is required (<code>start</code> and <code>end</code> are not {@link com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS}), then the query will include the default ORDER BY logic from {@link com.liferay.portlet.shopping.model.impl.ShoppingCouponModelImpl}. If both <code>orderByComparator</code> and pagination are absent, for performance reasons, the query will not have an ORDER BY clause and the returned result set will be sorted on by the primary key in an ascending order.
272             * </p>
273             *
274             * @param start the lower bound of the range of shopping coupons
275             * @param end the upper bound of the range of shopping coupons (not inclusive)
276             * @return the range of shopping coupons
277             */
278            @Override
279            public List<ShoppingCoupon> getShoppingCoupons(int start, int end) {
280                    return shoppingCouponPersistence.findAll(start, end);
281            }
282    
283            /**
284             * Returns the number of shopping coupons.
285             *
286             * @return the number of shopping coupons
287             */
288            @Override
289            public int getShoppingCouponsCount() {
290                    return shoppingCouponPersistence.countAll();
291            }
292    
293            /**
294             * Updates the shopping coupon in the database or adds it if it does not yet exist. Also notifies the appropriate model listeners.
295             *
296             * @param shoppingCoupon the shopping coupon
297             * @return the shopping coupon that was updated
298             */
299            @Indexable(type = IndexableType.REINDEX)
300            @Override
301            public ShoppingCoupon updateShoppingCoupon(ShoppingCoupon shoppingCoupon) {
302                    return shoppingCouponPersistence.update(shoppingCoupon);
303            }
304    
305            /**
306             * Returns the shopping coupon local service.
307             *
308             * @return the shopping coupon local service
309             */
310            public com.liferay.portlet.shopping.service.ShoppingCouponLocalService getShoppingCouponLocalService() {
311                    return shoppingCouponLocalService;
312            }
313    
314            /**
315             * Sets the shopping coupon local service.
316             *
317             * @param shoppingCouponLocalService the shopping coupon local service
318             */
319            public void setShoppingCouponLocalService(
320                    com.liferay.portlet.shopping.service.ShoppingCouponLocalService shoppingCouponLocalService) {
321                    this.shoppingCouponLocalService = shoppingCouponLocalService;
322            }
323    
324            /**
325             * Returns the shopping coupon remote service.
326             *
327             * @return the shopping coupon remote service
328             */
329            public com.liferay.portlet.shopping.service.ShoppingCouponService getShoppingCouponService() {
330                    return shoppingCouponService;
331            }
332    
333            /**
334             * Sets the shopping coupon remote service.
335             *
336             * @param shoppingCouponService the shopping coupon remote service
337             */
338            public void setShoppingCouponService(
339                    com.liferay.portlet.shopping.service.ShoppingCouponService shoppingCouponService) {
340                    this.shoppingCouponService = shoppingCouponService;
341            }
342    
343            /**
344             * Returns the shopping coupon persistence.
345             *
346             * @return the shopping coupon persistence
347             */
348            public ShoppingCouponPersistence getShoppingCouponPersistence() {
349                    return shoppingCouponPersistence;
350            }
351    
352            /**
353             * Sets the shopping coupon persistence.
354             *
355             * @param shoppingCouponPersistence the shopping coupon persistence
356             */
357            public void setShoppingCouponPersistence(
358                    ShoppingCouponPersistence shoppingCouponPersistence) {
359                    this.shoppingCouponPersistence = shoppingCouponPersistence;
360            }
361    
362            /**
363             * Returns the shopping coupon finder.
364             *
365             * @return the shopping coupon finder
366             */
367            public ShoppingCouponFinder getShoppingCouponFinder() {
368                    return shoppingCouponFinder;
369            }
370    
371            /**
372             * Sets the shopping coupon finder.
373             *
374             * @param shoppingCouponFinder the shopping coupon finder
375             */
376            public void setShoppingCouponFinder(
377                    ShoppingCouponFinder shoppingCouponFinder) {
378                    this.shoppingCouponFinder = shoppingCouponFinder;
379            }
380    
381            /**
382             * Returns the counter local service.
383             *
384             * @return the counter local service
385             */
386            public com.liferay.counter.service.CounterLocalService getCounterLocalService() {
387                    return counterLocalService;
388            }
389    
390            /**
391             * Sets the counter local service.
392             *
393             * @param counterLocalService the counter local service
394             */
395            public void setCounterLocalService(
396                    com.liferay.counter.service.CounterLocalService counterLocalService) {
397                    this.counterLocalService = counterLocalService;
398            }
399    
400            /**
401             * Returns the user local service.
402             *
403             * @return the user local service
404             */
405            public com.liferay.portal.service.UserLocalService getUserLocalService() {
406                    return userLocalService;
407            }
408    
409            /**
410             * Sets the user local service.
411             *
412             * @param userLocalService the user local service
413             */
414            public void setUserLocalService(
415                    com.liferay.portal.service.UserLocalService userLocalService) {
416                    this.userLocalService = userLocalService;
417            }
418    
419            /**
420             * Returns the user remote service.
421             *
422             * @return the user remote service
423             */
424            public com.liferay.portal.service.UserService getUserService() {
425                    return userService;
426            }
427    
428            /**
429             * Sets the user remote service.
430             *
431             * @param userService the user remote service
432             */
433            public void setUserService(
434                    com.liferay.portal.service.UserService userService) {
435                    this.userService = userService;
436            }
437    
438            /**
439             * Returns the user persistence.
440             *
441             * @return the user persistence
442             */
443            public UserPersistence getUserPersistence() {
444                    return userPersistence;
445            }
446    
447            /**
448             * Sets the user persistence.
449             *
450             * @param userPersistence the user persistence
451             */
452            public void setUserPersistence(UserPersistence userPersistence) {
453                    this.userPersistence = userPersistence;
454            }
455    
456            /**
457             * Returns the user finder.
458             *
459             * @return the user finder
460             */
461            public UserFinder getUserFinder() {
462                    return userFinder;
463            }
464    
465            /**
466             * Sets the user finder.
467             *
468             * @param userFinder the user finder
469             */
470            public void setUserFinder(UserFinder userFinder) {
471                    this.userFinder = userFinder;
472            }
473    
474            /**
475             * Returns the shopping category local service.
476             *
477             * @return the shopping category local service
478             */
479            public com.liferay.portlet.shopping.service.ShoppingCategoryLocalService getShoppingCategoryLocalService() {
480                    return shoppingCategoryLocalService;
481            }
482    
483            /**
484             * Sets the shopping category local service.
485             *
486             * @param shoppingCategoryLocalService the shopping category local service
487             */
488            public void setShoppingCategoryLocalService(
489                    com.liferay.portlet.shopping.service.ShoppingCategoryLocalService shoppingCategoryLocalService) {
490                    this.shoppingCategoryLocalService = shoppingCategoryLocalService;
491            }
492    
493            /**
494             * Returns the shopping category remote service.
495             *
496             * @return the shopping category remote service
497             */
498            public com.liferay.portlet.shopping.service.ShoppingCategoryService getShoppingCategoryService() {
499                    return shoppingCategoryService;
500            }
501    
502            /**
503             * Sets the shopping category remote service.
504             *
505             * @param shoppingCategoryService the shopping category remote service
506             */
507            public void setShoppingCategoryService(
508                    com.liferay.portlet.shopping.service.ShoppingCategoryService shoppingCategoryService) {
509                    this.shoppingCategoryService = shoppingCategoryService;
510            }
511    
512            /**
513             * Returns the shopping category persistence.
514             *
515             * @return the shopping category persistence
516             */
517            public ShoppingCategoryPersistence getShoppingCategoryPersistence() {
518                    return shoppingCategoryPersistence;
519            }
520    
521            /**
522             * Sets the shopping category persistence.
523             *
524             * @param shoppingCategoryPersistence the shopping category persistence
525             */
526            public void setShoppingCategoryPersistence(
527                    ShoppingCategoryPersistence shoppingCategoryPersistence) {
528                    this.shoppingCategoryPersistence = shoppingCategoryPersistence;
529            }
530    
531            /**
532             * Returns the shopping item local service.
533             *
534             * @return the shopping item local service
535             */
536            public com.liferay.portlet.shopping.service.ShoppingItemLocalService getShoppingItemLocalService() {
537                    return shoppingItemLocalService;
538            }
539    
540            /**
541             * Sets the shopping item local service.
542             *
543             * @param shoppingItemLocalService the shopping item local service
544             */
545            public void setShoppingItemLocalService(
546                    com.liferay.portlet.shopping.service.ShoppingItemLocalService shoppingItemLocalService) {
547                    this.shoppingItemLocalService = shoppingItemLocalService;
548            }
549    
550            /**
551             * Returns the shopping item remote service.
552             *
553             * @return the shopping item remote service
554             */
555            public com.liferay.portlet.shopping.service.ShoppingItemService getShoppingItemService() {
556                    return shoppingItemService;
557            }
558    
559            /**
560             * Sets the shopping item remote service.
561             *
562             * @param shoppingItemService the shopping item remote service
563             */
564            public void setShoppingItemService(
565                    com.liferay.portlet.shopping.service.ShoppingItemService shoppingItemService) {
566                    this.shoppingItemService = shoppingItemService;
567            }
568    
569            /**
570             * Returns the shopping item persistence.
571             *
572             * @return the shopping item persistence
573             */
574            public ShoppingItemPersistence getShoppingItemPersistence() {
575                    return shoppingItemPersistence;
576            }
577    
578            /**
579             * Sets the shopping item persistence.
580             *
581             * @param shoppingItemPersistence the shopping item persistence
582             */
583            public void setShoppingItemPersistence(
584                    ShoppingItemPersistence shoppingItemPersistence) {
585                    this.shoppingItemPersistence = shoppingItemPersistence;
586            }
587    
588            /**
589             * Returns the shopping item finder.
590             *
591             * @return the shopping item finder
592             */
593            public ShoppingItemFinder getShoppingItemFinder() {
594                    return shoppingItemFinder;
595            }
596    
597            /**
598             * Sets the shopping item finder.
599             *
600             * @param shoppingItemFinder the shopping item finder
601             */
602            public void setShoppingItemFinder(ShoppingItemFinder shoppingItemFinder) {
603                    this.shoppingItemFinder = shoppingItemFinder;
604            }
605    
606            public void afterPropertiesSet() {
607                    persistedModelLocalServiceRegistry.register("com.liferay.portlet.shopping.model.ShoppingCoupon",
608                            shoppingCouponLocalService);
609            }
610    
611            public void destroy() {
612                    persistedModelLocalServiceRegistry.unregister(
613                            "com.liferay.portlet.shopping.model.ShoppingCoupon");
614            }
615    
616            /**
617             * Returns the Spring bean ID for this bean.
618             *
619             * @return the Spring bean ID for this bean
620             */
621            @Override
622            public String getBeanIdentifier() {
623                    return _beanIdentifier;
624            }
625    
626            /**
627             * Sets the Spring bean ID for this bean.
628             *
629             * @param beanIdentifier the Spring bean ID for this bean
630             */
631            @Override
632            public void setBeanIdentifier(String beanIdentifier) {
633                    _beanIdentifier = beanIdentifier;
634            }
635    
636            protected Class<?> getModelClass() {
637                    return ShoppingCoupon.class;
638            }
639    
640            protected String getModelClassName() {
641                    return ShoppingCoupon.class.getName();
642            }
643    
644            /**
645             * Performs a SQL query.
646             *
647             * @param sql the sql query
648             */
649            protected void runSQL(String sql) {
650                    try {
651                            DataSource dataSource = shoppingCouponPersistence.getDataSource();
652    
653                            DB db = DBFactoryUtil.getDB();
654    
655                            sql = db.buildSQL(sql);
656                            sql = PortalUtil.transformSQL(sql);
657    
658                            SqlUpdate sqlUpdate = SqlUpdateFactoryUtil.getSqlUpdate(dataSource,
659                                            sql, new int[0]);
660    
661                            sqlUpdate.update();
662                    }
663                    catch (Exception e) {
664                            throw new SystemException(e);
665                    }
666            }
667    
668            @BeanReference(type = com.liferay.portlet.shopping.service.ShoppingCouponLocalService.class)
669            protected com.liferay.portlet.shopping.service.ShoppingCouponLocalService shoppingCouponLocalService;
670            @BeanReference(type = com.liferay.portlet.shopping.service.ShoppingCouponService.class)
671            protected com.liferay.portlet.shopping.service.ShoppingCouponService shoppingCouponService;
672            @BeanReference(type = ShoppingCouponPersistence.class)
673            protected ShoppingCouponPersistence shoppingCouponPersistence;
674            @BeanReference(type = ShoppingCouponFinder.class)
675            protected ShoppingCouponFinder shoppingCouponFinder;
676            @BeanReference(type = com.liferay.counter.service.CounterLocalService.class)
677            protected com.liferay.counter.service.CounterLocalService counterLocalService;
678            @BeanReference(type = com.liferay.portal.service.UserLocalService.class)
679            protected com.liferay.portal.service.UserLocalService userLocalService;
680            @BeanReference(type = com.liferay.portal.service.UserService.class)
681            protected com.liferay.portal.service.UserService userService;
682            @BeanReference(type = UserPersistence.class)
683            protected UserPersistence userPersistence;
684            @BeanReference(type = UserFinder.class)
685            protected UserFinder userFinder;
686            @BeanReference(type = com.liferay.portlet.shopping.service.ShoppingCategoryLocalService.class)
687            protected com.liferay.portlet.shopping.service.ShoppingCategoryLocalService shoppingCategoryLocalService;
688            @BeanReference(type = com.liferay.portlet.shopping.service.ShoppingCategoryService.class)
689            protected com.liferay.portlet.shopping.service.ShoppingCategoryService shoppingCategoryService;
690            @BeanReference(type = ShoppingCategoryPersistence.class)
691            protected ShoppingCategoryPersistence shoppingCategoryPersistence;
692            @BeanReference(type = com.liferay.portlet.shopping.service.ShoppingItemLocalService.class)
693            protected com.liferay.portlet.shopping.service.ShoppingItemLocalService shoppingItemLocalService;
694            @BeanReference(type = com.liferay.portlet.shopping.service.ShoppingItemService.class)
695            protected com.liferay.portlet.shopping.service.ShoppingItemService shoppingItemService;
696            @BeanReference(type = ShoppingItemPersistence.class)
697            protected ShoppingItemPersistence shoppingItemPersistence;
698            @BeanReference(type = ShoppingItemFinder.class)
699            protected ShoppingItemFinder shoppingItemFinder;
700            @BeanReference(type = PersistedModelLocalServiceRegistry.class)
701            protected PersistedModelLocalServiceRegistry persistedModelLocalServiceRegistry;
702            private String _beanIdentifier;
703    }