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