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