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