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