001    /**
002     * Copyright (c) 2000-2012 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.persistence;
016    
017    import com.liferay.portal.service.persistence.BasePersistence;
018    
019    import com.liferay.portlet.shopping.model.ShoppingItem;
020    
021    /**
022     * The persistence interface for the shopping item service.
023     *
024     * <p>
025     * Caching information and settings can be found in <code>portal.properties</code>
026     * </p>
027     *
028     * @author Brian Wing Shun Chan
029     * @see ShoppingItemPersistenceImpl
030     * @see ShoppingItemUtil
031     * @generated
032     */
033    public interface ShoppingItemPersistence extends BasePersistence<ShoppingItem> {
034            /*
035             * NOTE FOR DEVELOPERS:
036             *
037             * Never modify or reference this interface directly. Always use {@link ShoppingItemUtil} to access the shopping item persistence. Modify <code>service.xml</code> and rerun ServiceBuilder to regenerate this interface.
038             */
039    
040            /**
041            * Caches the shopping item in the entity cache if it is enabled.
042            *
043            * @param shoppingItem the shopping item
044            */
045            public void cacheResult(
046                    com.liferay.portlet.shopping.model.ShoppingItem shoppingItem);
047    
048            /**
049            * Caches the shopping items in the entity cache if it is enabled.
050            *
051            * @param shoppingItems the shopping items
052            */
053            public void cacheResult(
054                    java.util.List<com.liferay.portlet.shopping.model.ShoppingItem> shoppingItems);
055    
056            /**
057            * Creates a new shopping item with the primary key. Does not add the shopping item to the database.
058            *
059            * @param itemId the primary key for the new shopping item
060            * @return the new shopping item
061            */
062            public com.liferay.portlet.shopping.model.ShoppingItem create(long itemId);
063    
064            /**
065            * Removes the shopping item with the primary key from the database. Also notifies the appropriate model listeners.
066            *
067            * @param itemId the primary key of the shopping item
068            * @return the shopping item that was removed
069            * @throws com.liferay.portlet.shopping.NoSuchItemException if a shopping item with the primary key could not be found
070            * @throws SystemException if a system exception occurred
071            */
072            public com.liferay.portlet.shopping.model.ShoppingItem remove(long itemId)
073                    throws com.liferay.portal.kernel.exception.SystemException,
074                            com.liferay.portlet.shopping.NoSuchItemException;
075    
076            public com.liferay.portlet.shopping.model.ShoppingItem updateImpl(
077                    com.liferay.portlet.shopping.model.ShoppingItem shoppingItem,
078                    boolean merge)
079                    throws com.liferay.portal.kernel.exception.SystemException;
080    
081            /**
082            * Returns the shopping item with the primary key or throws a {@link com.liferay.portlet.shopping.NoSuchItemException} if it could not be found.
083            *
084            * @param itemId the primary key of the shopping item
085            * @return the shopping item
086            * @throws com.liferay.portlet.shopping.NoSuchItemException if a shopping item with the primary key could not be found
087            * @throws SystemException if a system exception occurred
088            */
089            public com.liferay.portlet.shopping.model.ShoppingItem findByPrimaryKey(
090                    long itemId)
091                    throws com.liferay.portal.kernel.exception.SystemException,
092                            com.liferay.portlet.shopping.NoSuchItemException;
093    
094            /**
095            * Returns the shopping item with the primary key or returns <code>null</code> if it could not be found.
096            *
097            * @param itemId the primary key of the shopping item
098            * @return the shopping item, or <code>null</code> if a shopping item with the primary key could not be found
099            * @throws SystemException if a system exception occurred
100            */
101            public com.liferay.portlet.shopping.model.ShoppingItem fetchByPrimaryKey(
102                    long itemId) throws com.liferay.portal.kernel.exception.SystemException;
103    
104            /**
105            * Returns the shopping item where smallImageId = &#63; or throws a {@link com.liferay.portlet.shopping.NoSuchItemException} if it could not be found.
106            *
107            * @param smallImageId the small image ID
108            * @return the matching shopping item
109            * @throws com.liferay.portlet.shopping.NoSuchItemException if a matching shopping item could not be found
110            * @throws SystemException if a system exception occurred
111            */
112            public com.liferay.portlet.shopping.model.ShoppingItem findBySmallImageId(
113                    long smallImageId)
114                    throws com.liferay.portal.kernel.exception.SystemException,
115                            com.liferay.portlet.shopping.NoSuchItemException;
116    
117            /**
118            * Returns the shopping item where smallImageId = &#63; or returns <code>null</code> if it could not be found. Uses the finder cache.
119            *
120            * @param smallImageId the small image ID
121            * @return the matching shopping item, or <code>null</code> if a matching shopping item could not be found
122            * @throws SystemException if a system exception occurred
123            */
124            public com.liferay.portlet.shopping.model.ShoppingItem fetchBySmallImageId(
125                    long smallImageId)
126                    throws com.liferay.portal.kernel.exception.SystemException;
127    
128            /**
129            * Returns the shopping item where smallImageId = &#63; or returns <code>null</code> if it could not be found, optionally using the finder cache.
130            *
131            * @param smallImageId the small image ID
132            * @param retrieveFromCache whether to use the finder cache
133            * @return the matching shopping item, or <code>null</code> if a matching shopping item could not be found
134            * @throws SystemException if a system exception occurred
135            */
136            public com.liferay.portlet.shopping.model.ShoppingItem fetchBySmallImageId(
137                    long smallImageId, boolean retrieveFromCache)
138                    throws com.liferay.portal.kernel.exception.SystemException;
139    
140            /**
141            * Returns the shopping item where mediumImageId = &#63; or throws a {@link com.liferay.portlet.shopping.NoSuchItemException} if it could not be found.
142            *
143            * @param mediumImageId the medium image ID
144            * @return the matching shopping item
145            * @throws com.liferay.portlet.shopping.NoSuchItemException if a matching shopping item could not be found
146            * @throws SystemException if a system exception occurred
147            */
148            public com.liferay.portlet.shopping.model.ShoppingItem findByMediumImageId(
149                    long mediumImageId)
150                    throws com.liferay.portal.kernel.exception.SystemException,
151                            com.liferay.portlet.shopping.NoSuchItemException;
152    
153            /**
154            * Returns the shopping item where mediumImageId = &#63; or returns <code>null</code> if it could not be found. Uses the finder cache.
155            *
156            * @param mediumImageId the medium image ID
157            * @return the matching shopping item, or <code>null</code> if a matching shopping item could not be found
158            * @throws SystemException if a system exception occurred
159            */
160            public com.liferay.portlet.shopping.model.ShoppingItem fetchByMediumImageId(
161                    long mediumImageId)
162                    throws com.liferay.portal.kernel.exception.SystemException;
163    
164            /**
165            * Returns the shopping item where mediumImageId = &#63; or returns <code>null</code> if it could not be found, optionally using the finder cache.
166            *
167            * @param mediumImageId the medium image ID
168            * @param retrieveFromCache whether to use the finder cache
169            * @return the matching shopping item, or <code>null</code> if a matching shopping item could not be found
170            * @throws SystemException if a system exception occurred
171            */
172            public com.liferay.portlet.shopping.model.ShoppingItem fetchByMediumImageId(
173                    long mediumImageId, boolean retrieveFromCache)
174                    throws com.liferay.portal.kernel.exception.SystemException;
175    
176            /**
177            * Returns the shopping item where largeImageId = &#63; or throws a {@link com.liferay.portlet.shopping.NoSuchItemException} if it could not be found.
178            *
179            * @param largeImageId the large image ID
180            * @return the matching shopping item
181            * @throws com.liferay.portlet.shopping.NoSuchItemException if a matching shopping item could not be found
182            * @throws SystemException if a system exception occurred
183            */
184            public com.liferay.portlet.shopping.model.ShoppingItem findByLargeImageId(
185                    long largeImageId)
186                    throws com.liferay.portal.kernel.exception.SystemException,
187                            com.liferay.portlet.shopping.NoSuchItemException;
188    
189            /**
190            * Returns the shopping item where largeImageId = &#63; or returns <code>null</code> if it could not be found. Uses the finder cache.
191            *
192            * @param largeImageId the large image ID
193            * @return the matching shopping item, or <code>null</code> if a matching shopping item could not be found
194            * @throws SystemException if a system exception occurred
195            */
196            public com.liferay.portlet.shopping.model.ShoppingItem fetchByLargeImageId(
197                    long largeImageId)
198                    throws com.liferay.portal.kernel.exception.SystemException;
199    
200            /**
201            * Returns the shopping item where largeImageId = &#63; or returns <code>null</code> if it could not be found, optionally using the finder cache.
202            *
203            * @param largeImageId the large image ID
204            * @param retrieveFromCache whether to use the finder cache
205            * @return the matching shopping item, or <code>null</code> if a matching shopping item could not be found
206            * @throws SystemException if a system exception occurred
207            */
208            public com.liferay.portlet.shopping.model.ShoppingItem fetchByLargeImageId(
209                    long largeImageId, boolean retrieveFromCache)
210                    throws com.liferay.portal.kernel.exception.SystemException;
211    
212            /**
213            * Returns all the shopping items where groupId = &#63; and categoryId = &#63;.
214            *
215            * @param groupId the group ID
216            * @param categoryId the category ID
217            * @return the matching shopping items
218            * @throws SystemException if a system exception occurred
219            */
220            public java.util.List<com.liferay.portlet.shopping.model.ShoppingItem> findByG_C(
221                    long groupId, long categoryId)
222                    throws com.liferay.portal.kernel.exception.SystemException;
223    
224            /**
225            * Returns a range of all the shopping items where groupId = &#63; and categoryId = &#63;.
226            *
227            * <p>
228            * 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.
229            * </p>
230            *
231            * @param groupId the group ID
232            * @param categoryId the category ID
233            * @param start the lower bound of the range of shopping items
234            * @param end the upper bound of the range of shopping items (not inclusive)
235            * @return the range of matching shopping items
236            * @throws SystemException if a system exception occurred
237            */
238            public java.util.List<com.liferay.portlet.shopping.model.ShoppingItem> findByG_C(
239                    long groupId, long categoryId, int start, int end)
240                    throws com.liferay.portal.kernel.exception.SystemException;
241    
242            /**
243            * Returns an ordered range of all the shopping items where groupId = &#63; and categoryId = &#63;.
244            *
245            * <p>
246            * 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.
247            * </p>
248            *
249            * @param groupId the group ID
250            * @param categoryId the category ID
251            * @param start the lower bound of the range of shopping items
252            * @param end the upper bound of the range of shopping items (not inclusive)
253            * @param orderByComparator the comparator to order the results by (optionally <code>null</code>)
254            * @return the ordered range of matching shopping items
255            * @throws SystemException if a system exception occurred
256            */
257            public java.util.List<com.liferay.portlet.shopping.model.ShoppingItem> findByG_C(
258                    long groupId, long categoryId, int start, int end,
259                    com.liferay.portal.kernel.util.OrderByComparator orderByComparator)
260                    throws com.liferay.portal.kernel.exception.SystemException;
261    
262            /**
263            * Returns the first shopping item in the ordered set where groupId = &#63; and categoryId = &#63;.
264            *
265            * <p>
266            * 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.
267            * </p>
268            *
269            * @param groupId the group ID
270            * @param categoryId the category ID
271            * @param orderByComparator the comparator to order the set by (optionally <code>null</code>)
272            * @return the first matching shopping item
273            * @throws com.liferay.portlet.shopping.NoSuchItemException if a matching shopping item could not be found
274            * @throws SystemException if a system exception occurred
275            */
276            public com.liferay.portlet.shopping.model.ShoppingItem findByG_C_First(
277                    long groupId, long categoryId,
278                    com.liferay.portal.kernel.util.OrderByComparator orderByComparator)
279                    throws com.liferay.portal.kernel.exception.SystemException,
280                            com.liferay.portlet.shopping.NoSuchItemException;
281    
282            /**
283            * Returns the last shopping item in the ordered set where groupId = &#63; and categoryId = &#63;.
284            *
285            * <p>
286            * 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.
287            * </p>
288            *
289            * @param groupId the group ID
290            * @param categoryId the category ID
291            * @param orderByComparator the comparator to order the set by (optionally <code>null</code>)
292            * @return the last matching shopping item
293            * @throws com.liferay.portlet.shopping.NoSuchItemException if a matching shopping item could not be found
294            * @throws SystemException if a system exception occurred
295            */
296            public com.liferay.portlet.shopping.model.ShoppingItem findByG_C_Last(
297                    long groupId, long categoryId,
298                    com.liferay.portal.kernel.util.OrderByComparator orderByComparator)
299                    throws com.liferay.portal.kernel.exception.SystemException,
300                            com.liferay.portlet.shopping.NoSuchItemException;
301    
302            /**
303            * Returns the shopping items before and after the current shopping item in the ordered set where groupId = &#63; and categoryId = &#63;.
304            *
305            * <p>
306            * 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.
307            * </p>
308            *
309            * @param itemId the primary key of the current shopping item
310            * @param groupId the group ID
311            * @param categoryId the category ID
312            * @param orderByComparator the comparator to order the set by (optionally <code>null</code>)
313            * @return the previous, current, and next shopping item
314            * @throws com.liferay.portlet.shopping.NoSuchItemException if a shopping item with the primary key could not be found
315            * @throws SystemException if a system exception occurred
316            */
317            public com.liferay.portlet.shopping.model.ShoppingItem[] findByG_C_PrevAndNext(
318                    long itemId, long groupId, long categoryId,
319                    com.liferay.portal.kernel.util.OrderByComparator orderByComparator)
320                    throws com.liferay.portal.kernel.exception.SystemException,
321                            com.liferay.portlet.shopping.NoSuchItemException;
322    
323            /**
324            * Returns all the shopping items that the user has permission to view where groupId = &#63; and categoryId = &#63;.
325            *
326            * @param groupId the group ID
327            * @param categoryId the category ID
328            * @return the matching shopping items that the user has permission to view
329            * @throws SystemException if a system exception occurred
330            */
331            public java.util.List<com.liferay.portlet.shopping.model.ShoppingItem> filterFindByG_C(
332                    long groupId, long categoryId)
333                    throws com.liferay.portal.kernel.exception.SystemException;
334    
335            /**
336            * Returns a range of all the shopping items that the user has permission to view where groupId = &#63; and categoryId = &#63;.
337            *
338            * <p>
339            * 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.
340            * </p>
341            *
342            * @param groupId the group ID
343            * @param categoryId the category ID
344            * @param start the lower bound of the range of shopping items
345            * @param end the upper bound of the range of shopping items (not inclusive)
346            * @return the range of matching shopping items that the user has permission to view
347            * @throws SystemException if a system exception occurred
348            */
349            public java.util.List<com.liferay.portlet.shopping.model.ShoppingItem> filterFindByG_C(
350                    long groupId, long categoryId, int start, int end)
351                    throws com.liferay.portal.kernel.exception.SystemException;
352    
353            /**
354            * Returns an ordered range of all the shopping items that the user has permissions to view where groupId = &#63; and categoryId = &#63;.
355            *
356            * <p>
357            * 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.
358            * </p>
359            *
360            * @param groupId the group ID
361            * @param categoryId the category ID
362            * @param start the lower bound of the range of shopping items
363            * @param end the upper bound of the range of shopping items (not inclusive)
364            * @param orderByComparator the comparator to order the results by (optionally <code>null</code>)
365            * @return the ordered range of matching shopping items that the user has permission to view
366            * @throws SystemException if a system exception occurred
367            */
368            public java.util.List<com.liferay.portlet.shopping.model.ShoppingItem> filterFindByG_C(
369                    long groupId, long categoryId, int start, int end,
370                    com.liferay.portal.kernel.util.OrderByComparator orderByComparator)
371                    throws com.liferay.portal.kernel.exception.SystemException;
372    
373            /**
374            * Returns the shopping items before and after the current shopping item in the ordered set of shopping items that the user has permission to view where groupId = &#63; and categoryId = &#63;.
375            *
376            * @param itemId the primary key of the current shopping item
377            * @param groupId the group ID
378            * @param categoryId the category ID
379            * @param orderByComparator the comparator to order the set by (optionally <code>null</code>)
380            * @return the previous, current, and next shopping item
381            * @throws com.liferay.portlet.shopping.NoSuchItemException if a shopping item with the primary key could not be found
382            * @throws SystemException if a system exception occurred
383            */
384            public com.liferay.portlet.shopping.model.ShoppingItem[] filterFindByG_C_PrevAndNext(
385                    long itemId, long groupId, long categoryId,
386                    com.liferay.portal.kernel.util.OrderByComparator orderByComparator)
387                    throws com.liferay.portal.kernel.exception.SystemException,
388                            com.liferay.portlet.shopping.NoSuchItemException;
389    
390            /**
391            * Returns the shopping item where companyId = &#63; and sku = &#63; or throws a {@link com.liferay.portlet.shopping.NoSuchItemException} if it could not be found.
392            *
393            * @param companyId the company ID
394            * @param sku the sku
395            * @return the matching shopping item
396            * @throws com.liferay.portlet.shopping.NoSuchItemException if a matching shopping item could not be found
397            * @throws SystemException if a system exception occurred
398            */
399            public com.liferay.portlet.shopping.model.ShoppingItem findByC_S(
400                    long companyId, java.lang.String sku)
401                    throws com.liferay.portal.kernel.exception.SystemException,
402                            com.liferay.portlet.shopping.NoSuchItemException;
403    
404            /**
405            * Returns the shopping item where companyId = &#63; and sku = &#63; or returns <code>null</code> if it could not be found. Uses the finder cache.
406            *
407            * @param companyId the company ID
408            * @param sku the sku
409            * @return the matching shopping item, or <code>null</code> if a matching shopping item could not be found
410            * @throws SystemException if a system exception occurred
411            */
412            public com.liferay.portlet.shopping.model.ShoppingItem fetchByC_S(
413                    long companyId, java.lang.String sku)
414                    throws com.liferay.portal.kernel.exception.SystemException;
415    
416            /**
417            * Returns the shopping item where companyId = &#63; and sku = &#63; or returns <code>null</code> if it could not be found, optionally using the finder cache.
418            *
419            * @param companyId the company ID
420            * @param sku the sku
421            * @param retrieveFromCache whether to use the finder cache
422            * @return the matching shopping item, or <code>null</code> if a matching shopping item could not be found
423            * @throws SystemException if a system exception occurred
424            */
425            public com.liferay.portlet.shopping.model.ShoppingItem fetchByC_S(
426                    long companyId, java.lang.String sku, boolean retrieveFromCache)
427                    throws com.liferay.portal.kernel.exception.SystemException;
428    
429            /**
430            * Returns all the shopping items.
431            *
432            * @return the shopping items
433            * @throws SystemException if a system exception occurred
434            */
435            public java.util.List<com.liferay.portlet.shopping.model.ShoppingItem> findAll()
436                    throws com.liferay.portal.kernel.exception.SystemException;
437    
438            /**
439            * Returns a range of all the shopping items.
440            *
441            * <p>
442            * 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.
443            * </p>
444            *
445            * @param start the lower bound of the range of shopping items
446            * @param end the upper bound of the range of shopping items (not inclusive)
447            * @return the range of shopping items
448            * @throws SystemException if a system exception occurred
449            */
450            public java.util.List<com.liferay.portlet.shopping.model.ShoppingItem> findAll(
451                    int start, int end)
452                    throws com.liferay.portal.kernel.exception.SystemException;
453    
454            /**
455            * Returns an ordered range of all the shopping items.
456            *
457            * <p>
458            * 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.
459            * </p>
460            *
461            * @param start the lower bound of the range of shopping items
462            * @param end the upper bound of the range of shopping items (not inclusive)
463            * @param orderByComparator the comparator to order the results by (optionally <code>null</code>)
464            * @return the ordered range of shopping items
465            * @throws SystemException if a system exception occurred
466            */
467            public java.util.List<com.liferay.portlet.shopping.model.ShoppingItem> findAll(
468                    int start, int end,
469                    com.liferay.portal.kernel.util.OrderByComparator orderByComparator)
470                    throws com.liferay.portal.kernel.exception.SystemException;
471    
472            /**
473            * Removes the shopping item where smallImageId = &#63; from the database.
474            *
475            * @param smallImageId the small image ID
476            * @throws SystemException if a system exception occurred
477            */
478            public void removeBySmallImageId(long smallImageId)
479                    throws com.liferay.portal.kernel.exception.SystemException,
480                            com.liferay.portlet.shopping.NoSuchItemException;
481    
482            /**
483            * Removes the shopping item where mediumImageId = &#63; from the database.
484            *
485            * @param mediumImageId the medium image ID
486            * @throws SystemException if a system exception occurred
487            */
488            public void removeByMediumImageId(long mediumImageId)
489                    throws com.liferay.portal.kernel.exception.SystemException,
490                            com.liferay.portlet.shopping.NoSuchItemException;
491    
492            /**
493            * Removes the shopping item where largeImageId = &#63; from the database.
494            *
495            * @param largeImageId the large image ID
496            * @throws SystemException if a system exception occurred
497            */
498            public void removeByLargeImageId(long largeImageId)
499                    throws com.liferay.portal.kernel.exception.SystemException,
500                            com.liferay.portlet.shopping.NoSuchItemException;
501    
502            /**
503            * Removes all the shopping items where groupId = &#63; and categoryId = &#63; from the database.
504            *
505            * @param groupId the group ID
506            * @param categoryId the category ID
507            * @throws SystemException if a system exception occurred
508            */
509            public void removeByG_C(long groupId, long categoryId)
510                    throws com.liferay.portal.kernel.exception.SystemException;
511    
512            /**
513            * Removes the shopping item where companyId = &#63; and sku = &#63; from the database.
514            *
515            * @param companyId the company ID
516            * @param sku the sku
517            * @throws SystemException if a system exception occurred
518            */
519            public void removeByC_S(long companyId, java.lang.String sku)
520                    throws com.liferay.portal.kernel.exception.SystemException,
521                            com.liferay.portlet.shopping.NoSuchItemException;
522    
523            /**
524            * Removes all the shopping items from the database.
525            *
526            * @throws SystemException if a system exception occurred
527            */
528            public void removeAll()
529                    throws com.liferay.portal.kernel.exception.SystemException;
530    
531            /**
532            * Returns the number of shopping items where smallImageId = &#63;.
533            *
534            * @param smallImageId the small image ID
535            * @return the number of matching shopping items
536            * @throws SystemException if a system exception occurred
537            */
538            public int countBySmallImageId(long smallImageId)
539                    throws com.liferay.portal.kernel.exception.SystemException;
540    
541            /**
542            * Returns the number of shopping items where mediumImageId = &#63;.
543            *
544            * @param mediumImageId the medium image ID
545            * @return the number of matching shopping items
546            * @throws SystemException if a system exception occurred
547            */
548            public int countByMediumImageId(long mediumImageId)
549                    throws com.liferay.portal.kernel.exception.SystemException;
550    
551            /**
552            * Returns the number of shopping items where largeImageId = &#63;.
553            *
554            * @param largeImageId the large image ID
555            * @return the number of matching shopping items
556            * @throws SystemException if a system exception occurred
557            */
558            public int countByLargeImageId(long largeImageId)
559                    throws com.liferay.portal.kernel.exception.SystemException;
560    
561            /**
562            * Returns the number of shopping items where groupId = &#63; and categoryId = &#63;.
563            *
564            * @param groupId the group ID
565            * @param categoryId the category ID
566            * @return the number of matching shopping items
567            * @throws SystemException if a system exception occurred
568            */
569            public int countByG_C(long groupId, long categoryId)
570                    throws com.liferay.portal.kernel.exception.SystemException;
571    
572            /**
573            * Returns the number of shopping items that the user has permission to view where groupId = &#63; and categoryId = &#63;.
574            *
575            * @param groupId the group ID
576            * @param categoryId the category ID
577            * @return the number of matching shopping items that the user has permission to view
578            * @throws SystemException if a system exception occurred
579            */
580            public int filterCountByG_C(long groupId, long categoryId)
581                    throws com.liferay.portal.kernel.exception.SystemException;
582    
583            /**
584            * Returns the number of shopping items where companyId = &#63; and sku = &#63;.
585            *
586            * @param companyId the company ID
587            * @param sku the sku
588            * @return the number of matching shopping items
589            * @throws SystemException if a system exception occurred
590            */
591            public int countByC_S(long companyId, java.lang.String sku)
592                    throws com.liferay.portal.kernel.exception.SystemException;
593    
594            /**
595            * Returns the number of shopping items.
596            *
597            * @return the number of shopping items
598            * @throws SystemException if a system exception occurred
599            */
600            public int countAll()
601                    throws com.liferay.portal.kernel.exception.SystemException;
602    
603            /**
604            * Returns all the shopping item prices associated with the shopping item.
605            *
606            * @param pk the primary key of the shopping item
607            * @return the shopping item prices associated with the shopping item
608            * @throws SystemException if a system exception occurred
609            */
610            public java.util.List<com.liferay.portlet.shopping.model.ShoppingItemPrice> getShoppingItemPrices(
611                    long pk) throws com.liferay.portal.kernel.exception.SystemException;
612    
613            /**
614            * Returns a range of all the shopping item prices associated with the shopping item.
615            *
616            * <p>
617            * 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.
618            * </p>
619            *
620            * @param pk the primary key of the shopping item
621            * @param start the lower bound of the range of shopping items
622            * @param end the upper bound of the range of shopping items (not inclusive)
623            * @return the range of shopping item prices associated with the shopping item
624            * @throws SystemException if a system exception occurred
625            */
626            public java.util.List<com.liferay.portlet.shopping.model.ShoppingItemPrice> getShoppingItemPrices(
627                    long pk, int start, int end)
628                    throws com.liferay.portal.kernel.exception.SystemException;
629    
630            /**
631            * Returns an ordered range of all the shopping item prices associated with the shopping item.
632            *
633            * <p>
634            * 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.
635            * </p>
636            *
637            * @param pk the primary key of the shopping item
638            * @param start the lower bound of the range of shopping items
639            * @param end the upper bound of the range of shopping items (not inclusive)
640            * @param orderByComparator the comparator to order the results by (optionally <code>null</code>)
641            * @return the ordered range of shopping item prices associated with the shopping item
642            * @throws SystemException if a system exception occurred
643            */
644            public java.util.List<com.liferay.portlet.shopping.model.ShoppingItemPrice> getShoppingItemPrices(
645                    long pk, int start, int end,
646                    com.liferay.portal.kernel.util.OrderByComparator orderByComparator)
647                    throws com.liferay.portal.kernel.exception.SystemException;
648    
649            /**
650            * Returns the number of shopping item prices associated with the shopping item.
651            *
652            * @param pk the primary key of the shopping item
653            * @return the number of shopping item prices associated with the shopping item
654            * @throws SystemException if a system exception occurred
655            */
656            public int getShoppingItemPricesSize(long pk)
657                    throws com.liferay.portal.kernel.exception.SystemException;
658    
659            /**
660            * Returns <code>true</code> if the shopping item price is associated with the shopping item.
661            *
662            * @param pk the primary key of the shopping item
663            * @param shoppingItemPricePK the primary key of the shopping item price
664            * @return <code>true</code> if the shopping item price is associated with the shopping item; <code>false</code> otherwise
665            * @throws SystemException if a system exception occurred
666            */
667            public boolean containsShoppingItemPrice(long pk, long shoppingItemPricePK)
668                    throws com.liferay.portal.kernel.exception.SystemException;
669    
670            /**
671            * Returns <code>true</code> if the shopping item has any shopping item prices associated with it.
672            *
673            * @param pk the primary key of the shopping item to check for associations with shopping item prices
674            * @return <code>true</code> if the shopping item has any shopping item prices associated with it; <code>false</code> otherwise
675            * @throws SystemException if a system exception occurred
676            */
677            public boolean containsShoppingItemPrices(long pk)
678                    throws com.liferay.portal.kernel.exception.SystemException;
679    }