|
1 /* |
|
2 * Copyright (c) 2007 Nokia Corporation and/or its subsidiary(-ies). |
|
3 * All rights reserved. |
|
4 * This component and the accompanying materials are made available |
|
5 * under the terms of "Eclipse Public License v1.0" |
|
6 * which accompanies this distribution, and is available |
|
7 * at the URL "http://www.eclipse.org/legal/epl-v10.html". |
|
8 * |
|
9 * Initial Contributors: |
|
10 * Nokia Corporation - initial contribution. |
|
11 * |
|
12 * Contributors: |
|
13 * |
|
14 * Description: Responsible for the auto playlist functionality. |
|
15 * |
|
16 */ |
|
17 |
|
18 |
|
19 // INCLUDE FILES |
|
20 #include <mpxlog.h> |
|
21 #include <mpxcollectiondbhgres.rsg> |
|
22 #include <sqldb.h> |
|
23 #include <hbtextresolversymbian.h> |
|
24 |
|
25 #include "mpxresource.h" |
|
26 #include "mpxdbcommonutil.h" |
|
27 #include "mpxdbmanager.h" |
|
28 #include "mpxdbutil.h" |
|
29 #include "mpxcollectiondbdef.h" |
|
30 #include "mpxdbautoplaylist.h" |
|
31 #include "mpxdbpluginqueries.h" |
|
32 #include "mpxdbcommondef.h" |
|
33 |
|
34 const TInt KMPXTableDefaultIndex = 0; |
|
35 const TInt32 KMPXRecentlyPlayedPlaylistId = 0x20000000; |
|
36 const TInt32 KMPXMostPlayedPlaylistId = 0x20000001; |
|
37 const TInt32 KMPXRecentlyAddedPlaylistId = 0x20000002; |
|
38 |
|
39 |
|
40 // ============================ MEMBER FUNCTIONS ============================== |
|
41 |
|
42 // ---------------------------------------------------------------------------- |
|
43 // Two-phased constructor. |
|
44 // ---------------------------------------------------------------------------- |
|
45 // |
|
46 CMPXDbAutoPlaylist* CMPXDbAutoPlaylist::NewL( |
|
47 CMPXDbManager& aDbManager, |
|
48 RFs& aFs, |
|
49 CMPXResource& aResource) |
|
50 { |
|
51 MPX_FUNC("CMPXDbAutoPlaylist::NewL"); |
|
52 |
|
53 CMPXDbAutoPlaylist* self = CMPXDbAutoPlaylist::NewLC(aDbManager, aFs, aResource); |
|
54 CleanupStack::Pop(self); |
|
55 return self; |
|
56 } |
|
57 |
|
58 // ---------------------------------------------------------------------------- |
|
59 // Two-phased constructor. |
|
60 // ---------------------------------------------------------------------------- |
|
61 // |
|
62 CMPXDbAutoPlaylist* CMPXDbAutoPlaylist::NewLC( |
|
63 CMPXDbManager& aDbManager, |
|
64 RFs& aFs, |
|
65 CMPXResource& aResource) |
|
66 { |
|
67 MPX_FUNC("CMPXDbAutoPlaylist::NewLC"); |
|
68 |
|
69 CMPXDbAutoPlaylist* self = new (ELeave) CMPXDbAutoPlaylist(aDbManager); |
|
70 CleanupStack::PushL(self); |
|
71 self->ConstructL(aFs, aResource); |
|
72 return self; |
|
73 } |
|
74 |
|
75 // ---------------------------------------------------------------------------- |
|
76 // Destructor |
|
77 // ---------------------------------------------------------------------------- |
|
78 // |
|
79 CMPXDbAutoPlaylist::~CMPXDbAutoPlaylist() |
|
80 { |
|
81 MPX_FUNC("CMPXDbAutoPlaylist::~CMPXDbAutoPlaylist"); |
|
82 |
|
83 delete iRecentlyPlayedPlaylist; |
|
84 delete iMostPlayedPlaylist; |
|
85 delete iRecentlyAddedPlaylist; |
|
86 } |
|
87 |
|
88 // ---------------------------------------------------------------------------- |
|
89 // Constructor |
|
90 // ---------------------------------------------------------------------------- |
|
91 // |
|
92 CMPXDbAutoPlaylist::CMPXDbAutoPlaylist(CMPXDbManager& aDbManager) |
|
93 : iDbManager(aDbManager) |
|
94 { |
|
95 MPX_FUNC("CMPXDbAutoPlaylist::CMPXDbAutoPlaylist"); |
|
96 } |
|
97 |
|
98 // ---------------------------------------------------------------------------- |
|
99 // Second phase constructor. |
|
100 // ---------------------------------------------------------------------------- |
|
101 // |
|
102 void CMPXDbAutoPlaylist::ConstructL( |
|
103 RFs& /*aFs*/, |
|
104 CMPXResource& /*aResource*/) |
|
105 { |
|
106 MPX_FUNC("CMPXDbAutoPlaylist::ConstructL"); |
|
107 |
|
108 // Localization using QT |
|
109 TBool result = HbTextResolverSymbian::Init(KMPXMusicPlayerTsFile, KMPXMusicPlayerTsPath); |
|
110 if ( result ) |
|
111 { |
|
112 iMostPlayedPlaylist = HbTextResolverSymbian::LoadL( _L("txt_mus_list_most_played") ); |
|
113 iRecentlyAddedPlaylist = HbTextResolverSymbian::LoadL( _L("txt_mus_list_recently_added") ); |
|
114 iRecentlyPlayedPlaylist = HbTextResolverSymbian::LoadL( _L("txt_mus_list_recently_played") ); |
|
115 } |
|
116 else |
|
117 { |
|
118 // error initializing HbTextResolverSymbian, use logical string. |
|
119 MPX_DEBUG1("CMPXDbAutoPlaylist::ConstructL - HbTextResolverSymbian::Init() Failed."); |
|
120 TBufC<50> buf( _L("txt_mus_list_most_played") ); |
|
121 iMostPlayedPlaylist = buf.AllocL(); |
|
122 buf = _L("txt_mus_list_recently_added"); |
|
123 iRecentlyAddedPlaylist = buf.AllocL(); |
|
124 buf = _L("txt_mus_list_recently_played"); |
|
125 iRecentlyPlayedPlaylist = buf.AllocL(); |
|
126 } |
|
127 |
|
128 iRecentlyPlayedPlaylistId = KMPXRecentlyPlayedPlaylistId; |
|
129 iMostPlayedPlaylistId = KMPXMostPlayedPlaylistId; |
|
130 iRecentlyAddedPlaylistId = KMPXRecentlyAddedPlaylistId; |
|
131 } |
|
132 |
|
133 // ---------------------------------------------------------------------------- |
|
134 // CMPXDbAutoPlaylist::AutoPlaylistIdL |
|
135 // ---------------------------------------------------------------------------- |
|
136 // |
|
137 TUint32 CMPXDbAutoPlaylist::AutoPlaylistIdL( |
|
138 TMPXAutoPlaylistType aPlaylistType) |
|
139 { |
|
140 MPX_FUNC("CMPXDbAutoPlaylist::AutoPlaylistIdL"); |
|
141 |
|
142 TUint32 id(0); |
|
143 switch (aPlaylistType) |
|
144 { |
|
145 case EMPXRecentlyPlayedPlaylist: |
|
146 { |
|
147 id = iRecentlyPlayedPlaylistId; |
|
148 } |
|
149 break; |
|
150 |
|
151 case EMPXMostPlayedPlaylist: |
|
152 { |
|
153 id = iMostPlayedPlaylistId; |
|
154 } |
|
155 break; |
|
156 |
|
157 case EMPXRecentlyAddedPlaylist: |
|
158 { |
|
159 id = iRecentlyAddedPlaylistId; |
|
160 } |
|
161 break; |
|
162 |
|
163 default: |
|
164 User::Leave(KErrNotSupported); |
|
165 } |
|
166 |
|
167 return id; |
|
168 } |
|
169 |
|
170 // ---------------------------------------------------------------------------- |
|
171 // CMPXDbAutoPlaylist::AutoPlaylistNameL |
|
172 // ---------------------------------------------------------------------------- |
|
173 // |
|
174 TPtrC CMPXDbAutoPlaylist::AutoPlaylistNameL( |
|
175 TUint32 aPlaylistId) |
|
176 { |
|
177 MPX_FUNC("CMPXDbAutoPlaylist::AutoPlaylistNameL"); |
|
178 |
|
179 TPtrC ptr; |
|
180 if (aPlaylistId == iRecentlyPlayedPlaylistId) |
|
181 { |
|
182 ptr.Set(*iRecentlyPlayedPlaylist); |
|
183 } |
|
184 else if (aPlaylistId == iMostPlayedPlaylistId) |
|
185 { |
|
186 ptr.Set(*iMostPlayedPlaylist); |
|
187 } |
|
188 else if (aPlaylistId == iRecentlyAddedPlaylistId) |
|
189 { |
|
190 ptr.Set(*iRecentlyAddedPlaylist); |
|
191 } |
|
192 else |
|
193 { |
|
194 User::Leave(KErrNotSupported); |
|
195 } |
|
196 |
|
197 return ptr; |
|
198 } |
|
199 |
|
200 // ---------------------------------------------------------------------------- |
|
201 // CMPXDbAutoPlaylist::AutoPlaylistTypeL |
|
202 // ---------------------------------------------------------------------------- |
|
203 // |
|
204 TMPXAutoPlaylistType CMPXDbAutoPlaylist::AutoPlaylistTypeL( |
|
205 TUint32 aPlaylistId) |
|
206 { |
|
207 MPX_FUNC("CMPXDbAutoPlaylist::AutoPlaylistTypeL"); |
|
208 |
|
209 TMPXAutoPlaylistType type(EMPXNoAutoPlaylist); |
|
210 if (aPlaylistId == iRecentlyPlayedPlaylistId) |
|
211 { |
|
212 type = EMPXRecentlyPlayedPlaylist; |
|
213 } |
|
214 else if (aPlaylistId == iMostPlayedPlaylistId) |
|
215 { |
|
216 type = EMPXMostPlayedPlaylist; |
|
217 } |
|
218 else if (aPlaylistId == iRecentlyAddedPlaylistId) |
|
219 { |
|
220 type = EMPXRecentlyAddedPlaylist; |
|
221 } |
|
222 else |
|
223 { |
|
224 // do nothing |
|
225 } |
|
226 |
|
227 return type; |
|
228 } |
|
229 |
|
230 // ---------------------------------------------------------------------------- |
|
231 // CMPXDbAutoPlaylist::GetPlaylistL |
|
232 // ---------------------------------------------------------------------------- |
|
233 // |
|
234 void CMPXDbAutoPlaylist::GetPlaylistL( |
|
235 TUint32 aPlaylistId, |
|
236 const TArray<TMPXAttribute>& aAttrs, |
|
237 CMPXMedia& aMedia) |
|
238 { |
|
239 MPX_FUNC("CMPXDbAutoPlaylist::GetPlaylistL"); |
|
240 |
|
241 if (EMPXNoAutoPlaylist == AutoPlaylistTypeL(aPlaylistId)) |
|
242 { |
|
243 User::Leave(KErrNotSupported); |
|
244 } |
|
245 |
|
246 UpdateMediaL(aPlaylistId, aAttrs, aMedia); |
|
247 } |
|
248 |
|
249 // ---------------------------------------------------------------------------- |
|
250 // CMPXDbAutoPlaylist::GetAllPlaylistsL |
|
251 // ---------------------------------------------------------------------------- |
|
252 // |
|
253 void CMPXDbAutoPlaylist::GetAllPlaylistsL( |
|
254 CMPXMediaArray& aMediaArray) |
|
255 { |
|
256 MPX_FUNC("CMPXDbAutoPlaylist::GetAllPlaylistsL"); |
|
257 |
|
258 MPX_ASSERT(aMediaArray.Count()); |
|
259 MPX_ASSERT(aMediaArray[0]->IsSupported(KMPXMediaGeneralValue)); |
|
260 TInt pPath = aMediaArray[0]->ValueTObjectL<TInt>(KMPXMediaGeneralValue); |
|
261 MPX_ASSERT(pPath); |
|
262 MPXDbCommonUtil::AppendMediaL(aMediaArray, *iMostPlayedPlaylist, EMPXItem, |
|
263 EMPXPlaylist, iMostPlayedPlaylistId, EMPXWrite); |
|
264 TInt count = aMediaArray.Count(); |
|
265 TMPXItemId id = aMediaArray[count-1]->ValueTObjectL<TMPXItemId>(KMPXMediaGeneralId); |
|
266 if (count==2) |
|
267 { // the first playlist |
|
268 if (((CMPXCollectionPath*)pPath)->Id()==KMPXInvalidItemId) |
|
269 { // Remove top level with invalid id |
|
270 ((CMPXCollectionPath*)pPath)->Back(); |
|
271 } |
|
272 ((CMPXCollectionPath*)pPath)->AppendL(id); |
|
273 } |
|
274 else |
|
275 { // append the end |
|
276 ((CMPXCollectionPath*)pPath)->InsertL(id, |
|
277 ((CMPXCollectionPath*)pPath)->Count()); |
|
278 } |
|
279 TInt songCount = 0; |
|
280 TInt duration = 0; |
|
281 GetPlaylistDetailsL(EMPXMostPlayedPlaylist, songCount, duration); |
|
282 aMediaArray[count-1]->SetTObjectValueL<TInt>(KMPXMediaGeneralCount, songCount); |
|
283 aMediaArray[count-1]->SetTObjectValueL<TInt>(KMPXMediaGeneralDuration, duration); |
|
284 |
|
285 MPXDbCommonUtil::AppendMediaL(aMediaArray, *iRecentlyPlayedPlaylist, EMPXItem, |
|
286 EMPXPlaylist, iRecentlyPlayedPlaylistId, EMPXWrite); |
|
287 id = aMediaArray[count]->ValueTObjectL<TMPXItemId>(KMPXMediaGeneralId); |
|
288 ((CMPXCollectionPath*)pPath)->InsertL(id, ((CMPXCollectionPath*)pPath)->Count()); |
|
289 songCount = 0; |
|
290 duration = 0; |
|
291 GetPlaylistDetailsL(EMPXRecentlyPlayedPlaylist, songCount, duration); |
|
292 aMediaArray[count]->SetTObjectValueL<TInt>(KMPXMediaGeneralCount, songCount); |
|
293 aMediaArray[count]->SetTObjectValueL<TInt>(KMPXMediaGeneralDuration, duration); |
|
294 |
|
295 MPXDbCommonUtil::AppendMediaL(aMediaArray, *iRecentlyAddedPlaylist, EMPXItem, |
|
296 EMPXPlaylist, iRecentlyAddedPlaylistId, EMPXWrite); |
|
297 id = aMediaArray[count+1]->ValueTObjectL<TMPXItemId>(KMPXMediaGeneralId); |
|
298 ((CMPXCollectionPath*)pPath)->InsertL(id, ((CMPXCollectionPath*)pPath)->Count()); |
|
299 songCount = 0; |
|
300 duration = 0; |
|
301 GetPlaylistDetailsL(EMPXRecentlyAddedPlaylist, songCount, duration); |
|
302 aMediaArray[count+1]->SetTObjectValueL<TInt>(KMPXMediaGeneralCount, songCount); |
|
303 aMediaArray[count+1]->SetTObjectValueL<TInt>(KMPXMediaGeneralDuration, duration); |
|
304 } |
|
305 |
|
306 // ---------------------------------------------------------------------------- |
|
307 // CMPXDbAutoPlaylist::GetPlaylistDetails |
|
308 // ---------------------------------------------------------------------------- |
|
309 // |
|
310 void CMPXDbAutoPlaylist::GetPlaylistDetailsL(TMPXAutoPlaylistType aType, TInt& aCount, TInt& aDuration) |
|
311 { |
|
312 MPX_FUNC("CMPXDbAutoPlaylist::GetPlaylistDetails"); |
|
313 |
|
314 HBufC* query = NULL; |
|
315 |
|
316 switch ( aType ) |
|
317 { |
|
318 case EMPXMostPlayedPlaylist: |
|
319 query = HBufC::NewLC(KQueryMusicGetDurationMostPlayed().Length() + KMCIntegerLen); |
|
320 query->Des().Format(KQueryMusicGetDurationMostPlayed(), KMPXMaxMostPlayedSongs); |
|
321 break; |
|
322 case EMPXRecentlyPlayedPlaylist: |
|
323 query = HBufC::NewLC(KQueryMusicGetDurationRecentlyPlayed().Length() + KMCIntegerLen); |
|
324 query->Des().Format(KQueryMusicGetDurationRecentlyPlayed(), KMPXMaxRecentlyPlayedSongs); |
|
325 break; |
|
326 case EMPXRecentlyAddedPlaylist: |
|
327 query = HBufC::NewLC(KQueryMusicGetDurationRecentlyAdded().Length()); |
|
328 query->Des().Append(KQueryMusicGetDurationRecentlyAdded()); |
|
329 break; |
|
330 default: |
|
331 User::Leave(KErrArgument); |
|
332 break; |
|
333 } |
|
334 |
|
335 RSqlStatement recordset(iDbManager.ExecuteSelectQueryL(*query)); |
|
336 CleanupClosePushL(recordset); |
|
337 |
|
338 TInt sum(0); |
|
339 TInt err(KErrNone); |
|
340 while ((err = recordset.Next()) == KSqlAtRow) |
|
341 { |
|
342 aCount++; |
|
343 sum += recordset.ColumnInt64(KMPXTableDefaultIndex); |
|
344 } |
|
345 |
|
346 CleanupStack::PopAndDestroy(&recordset); |
|
347 CleanupStack::PopAndDestroy(query); |
|
348 |
|
349 if (err != KSqlAtEnd) |
|
350 { |
|
351 User::Leave(KErrCorrupt); |
|
352 } |
|
353 |
|
354 aDuration = sum; |
|
355 MPX_DEBUG3(" Count[%d], Duration[%d]", aCount, aDuration); |
|
356 } |
|
357 |
|
358 // ---------------------------------------------------------------------------- |
|
359 // CMPXDbAutoPlaylist::UpdateMediaL |
|
360 // ---------------------------------------------------------------------------- |
|
361 // |
|
362 void CMPXDbAutoPlaylist::UpdateMediaL( |
|
363 TUint32 aPlaylistId, |
|
364 const TArray<TMPXAttribute>& aAttrs, |
|
365 CMPXMedia& aMedia) |
|
366 { |
|
367 MPX_FUNC("CMPXDbAutoPlaylist::UpdateMediaL"); |
|
368 |
|
369 TInt count(aAttrs.Count()); |
|
370 for (TInt i = 0; i < count; ++i) |
|
371 { |
|
372 TInt contentId(aAttrs[i].ContentId()); |
|
373 |
|
374 if (contentId == KMPXMediaIdGeneral) |
|
375 { |
|
376 TUint attributeId(aAttrs[i].AttributeId()); |
|
377 |
|
378 if (attributeId & EMPXMediaGeneralId) |
|
379 { |
|
380 aMedia.SetTObjectValueL<TMPXItemId>(KMPXMediaGeneralId, aPlaylistId); |
|
381 } |
|
382 if (attributeId & EMPXMediaGeneralCollectionId ) |
|
383 { |
|
384 aMedia.SetTObjectValueL<TUid>(KMPXMediaGeneralCollectionId, |
|
385 TUid::Uid(KDBPluginUid)); |
|
386 } |
|
387 if (attributeId & EMPXMediaGeneralTitle) |
|
388 { |
|
389 if (aPlaylistId == iRecentlyPlayedPlaylistId) |
|
390 { |
|
391 aMedia.SetTextValueL(KMPXMediaGeneralTitle, *iRecentlyPlayedPlaylist); |
|
392 } |
|
393 else if (aPlaylistId == iMostPlayedPlaylistId) |
|
394 { |
|
395 aMedia.SetTextValueL(KMPXMediaGeneralTitle,*iMostPlayedPlaylist); |
|
396 } |
|
397 else if (aPlaylistId == iRecentlyAddedPlaylistId) |
|
398 { |
|
399 aMedia.SetTextValueL(KMPXMediaGeneralTitle, *iRecentlyAddedPlaylist); |
|
400 } |
|
401 else |
|
402 { |
|
403 User::Leave(KErrArgument); |
|
404 } |
|
405 } |
|
406 if (attributeId & EMPXMediaGeneralSynchronized) |
|
407 { |
|
408 aMedia.SetTObjectValueL<TBool>(KMPXMediaGeneralSynchronized, EFalse); |
|
409 } |
|
410 if (attributeId & EMPXMediaGeneralNonPermissibleActions) |
|
411 { |
|
412 aMedia.SetTObjectValueL<TMPXGeneralNonPermissibleActions>( |
|
413 KMPXMediaGeneralNonPermissibleActions, EMPXWrite); |
|
414 } |
|
415 // EMPXMediaGeneralCount, EMPXMediaGeneralDate, EMPXMediaGeneralDuration, |
|
416 // EMPXMediaGeneralUri, EMPXMediaGeneralDrive, and EMPXMediaGeneralFlags |
|
417 // attributes are not applicable for auto-playlists |
|
418 } // end if contentId == KMPXMediaIdGeneral |
|
419 } // end for |
|
420 |
|
421 aMedia.SetTObjectValueL<TMPXGeneralType>(KMPXMediaGeneralType, EMPXItem); |
|
422 aMedia.SetTObjectValueL<TMPXGeneralCategory>(KMPXMediaGeneralCategory, EMPXPlaylist); |
|
423 } |
|
424 |
|
425 // End of File |