1 |
|
package com.loopback.androidapps.saveapp; |
2 |
|
|
3 |
|
import android.content.ContentValues; |
4 |
|
import android.database.Cursor; |
5 |
|
import android.util.Log; |
6 |
|
|
|
|
| 78,7% |
Uncovered Elements: 45 (211) |
Complexity: 44 |
Complexity Density: 0,28 |
|
7 |
|
public class Outlay implements SaveAppTable { |
8 |
|
|
9 |
|
private int id; |
10 |
|
private int charge; |
11 |
|
private String note; |
12 |
|
private String date; |
13 |
|
|
14 |
|
private int accountId; |
15 |
|
private int itemId; |
16 |
|
private int placeId; |
17 |
|
private int addressId; |
18 |
|
private int albumId; |
19 |
|
|
20 |
|
private String accountDesc; |
21 |
|
private String itemDesc; |
22 |
|
private String placeDesc; |
23 |
|
private String addressDesc; |
24 |
|
private String albumDesc; |
25 |
|
|
26 |
|
private Item item; |
27 |
|
private Place place; |
28 |
|
private AddressX address; |
29 |
|
private Album album; |
30 |
|
|
31 |
|
private DBManager dbManager; |
32 |
|
private Cursor cursor; |
33 |
|
public static SaveApp saveApp; |
34 |
|
|
|
|
| 100% |
Uncovered Elements: 0 (18) |
Complexity: 1 |
Complexity Density: 0,06 |
|
35 |
36
|
public Outlay() {... |
36 |
36
|
dbManager = saveApp.getDbManager(); |
37 |
36
|
id = 0; |
38 |
36
|
charge = 0; |
39 |
36
|
date = ""; |
40 |
36
|
note = ""; |
41 |
|
|
42 |
36
|
accountId = 0; |
43 |
36
|
itemId = 0; |
44 |
36
|
placeId = 0; |
45 |
36
|
addressId = 0; |
46 |
36
|
albumId = 0; |
47 |
|
|
48 |
36
|
itemDesc = ""; |
49 |
36
|
placeDesc = ""; |
50 |
36
|
addressDesc = ""; |
51 |
36
|
setAccountDesc(""); |
52 |
|
|
53 |
36
|
item = new Item(); |
54 |
36
|
place = new Place(); |
55 |
36
|
address = new AddressX(); |
56 |
36
|
album = new Album(); |
57 |
|
} |
58 |
|
|
|
|
| 0% |
Uncovered Elements: 18 (18) |
Complexity: 1 |
Complexity Density: 0,06 |
|
59 |
0
|
public Outlay(int _id, int _charge, int _accountId) {... |
60 |
0
|
dbManager = saveApp.getDbManager(); |
61 |
0
|
id = _id; |
62 |
0
|
charge = _charge; |
63 |
0
|
accountId = _accountId; |
64 |
|
|
65 |
0
|
date = ""; |
66 |
0
|
note = ""; |
67 |
|
|
68 |
0
|
itemId = 0; |
69 |
0
|
placeId = 0; |
70 |
0
|
addressId = 0; |
71 |
0
|
albumId = 0; |
72 |
|
|
73 |
0
|
itemDesc = ""; |
74 |
0
|
placeDesc = ""; |
75 |
0
|
addressDesc = ""; |
76 |
0
|
setAccountDesc(""); |
77 |
|
|
78 |
0
|
item = new Item(); |
79 |
0
|
place = new Place(); |
80 |
0
|
address = new AddressX(); |
81 |
0
|
album = new Album(); |
82 |
|
} |
83 |
|
|
|
|
| 100% |
Uncovered Elements: 0 (19) |
Complexity: 1 |
Complexity Density: 0,05 |
|
84 |
10
|
public Outlay(int _id) {... |
85 |
10
|
dbManager = saveApp.getDbManager(); |
86 |
10
|
id = _id; |
87 |
10
|
charge = 0; |
88 |
10
|
date = ""; |
89 |
10
|
note = ""; |
90 |
|
|
91 |
10
|
accountId = 0; |
92 |
10
|
itemId = 0; |
93 |
10
|
placeId = 0; |
94 |
10
|
addressId = 0; |
95 |
10
|
albumId = 0; |
96 |
|
|
97 |
10
|
itemDesc = ""; |
98 |
10
|
placeDesc = ""; |
99 |
10
|
addressDesc = ""; |
100 |
10
|
setAccountDesc(""); |
101 |
|
|
102 |
10
|
item = new Item(); |
103 |
10
|
place = new Place(); |
104 |
10
|
address = new AddressX(); |
105 |
10
|
album = new Album(); |
106 |
10
|
inflate(id); |
107 |
|
} |
108 |
|
|
109 |
|
|
110 |
|
|
111 |
|
|
112 |
|
|
|
|
| 85,7% |
Uncovered Elements: 4 (28) |
Complexity: 2 |
Complexity Density: 0,08 |
|
113 |
2
|
public void insert(int _accountId, int _charge, String _date, String _note,... |
114 |
|
String _itemDesc, String _placeDesc, String _albumDesc, |
115 |
|
String _addressDesc, double _longitude, double _latitude) { |
116 |
2
|
dbManager = saveApp.getDbManager(); |
117 |
2
|
charge = _charge; |
118 |
2
|
date = _date; |
119 |
2
|
note = _note; |
120 |
|
|
121 |
2
|
Log.i("OU", "Inserting Ids..."); |
122 |
|
|
123 |
2
|
itemId = item.insertOrGetId(_itemDesc); |
124 |
2
|
albumId = album.insertOrGetId(_albumDesc); |
125 |
2
|
placeId = place.insertOrGetId(_placeDesc); |
126 |
2
|
addressId = address.insertOrGetId(_addressDesc); |
127 |
2
|
address.inflate(addressId); |
128 |
2
|
if (address.getLatitude() == 0) { |
129 |
0
|
address.setLatitude(Double.valueOf(_latitude)); |
130 |
0
|
address.setLongitude(Double.valueOf(_longitude)); |
131 |
0
|
address.update(); |
132 |
|
} |
133 |
|
|
134 |
2
|
Log.i("OU", "Inserting Outlay..."); |
135 |
2
|
ContentValues cv = new ContentValues(); |
136 |
2
|
cv.put(DBManager.OUTLAY_COLUMN_CHARGE, charge); |
137 |
2
|
cv.put(DBManager.OUTLAY_COLUMN_DATE, date); |
138 |
2
|
cv.put(DBManager.OUTLAY_COLUMN_NOTES, note); |
139 |
2
|
cv.put(DBManager.OUTLAY_COLUMN_ITEM, itemId); |
140 |
2
|
cv.put(DBManager.OUTLAY_COLUMN_PLACE, placeId); |
141 |
2
|
cv.put(DBManager.OUTLAY_COLUMN_ADDRESS, addressId); |
142 |
2
|
cv.put(DBManager.OUTLAY_COLUMN_ALBUM, albumId); |
143 |
2
|
cv.put(DBManager.OUTLAY_COLUMN_ACCOUNT, saveApp.getAccountId()); |
144 |
2
|
dbManager.insert(DBManager.OUTLAY_TABLE, cv); |
145 |
2
|
Log.i("OU", "Inserted"); |
146 |
|
} |
147 |
|
|
|
|
| 90,9% |
Uncovered Elements: 2 (22) |
Complexity: 3 |
Complexity Density: 0,15 |
|
148 |
3
|
public void update() {... |
149 |
3
|
dbManager = saveApp.getDbManager(); |
150 |
3
|
Log.i("OU", "Updatinging Ids..."); |
151 |
3
|
itemId = item.insertOrGetId(itemDesc); |
152 |
3
|
if ((addressDesc == null) || (addressDesc.compareTo("") == 0)) |
153 |
0
|
addressId = 1; |
154 |
|
else |
155 |
3
|
addressId = address.insertOrGetId(addressDesc); |
156 |
3
|
placeId = place.insertOrGetId(placeDesc); |
157 |
3
|
albumId = album.insertOrGetId(albumDesc); |
158 |
|
|
159 |
3
|
Log.i("OU", "Updating Outlay..."); |
160 |
|
|
161 |
3
|
ContentValues cv = new ContentValues(); |
162 |
3
|
cv.put(DBManager.OUTLAY_COLUMN_CHARGE, charge); |
163 |
3
|
cv.put(DBManager.OUTLAY_COLUMN_DATE, date); |
164 |
3
|
cv.put(DBManager.OUTLAY_COLUMN_NOTES, note); |
165 |
3
|
cv.put(DBManager.OUTLAY_COLUMN_ITEM, itemId); |
166 |
3
|
cv.put(DBManager.OUTLAY_COLUMN_PLACE, placeId); |
167 |
3
|
cv.put(DBManager.OUTLAY_COLUMN_ADDRESS, addressId); |
168 |
3
|
cv.put(DBManager.OUTLAY_COLUMN_ALBUM, albumId); |
169 |
3
|
cv.put(DBManager.OUTLAY_COLUMN_ACCOUNT, saveApp.getAccountId()); |
170 |
3
|
dbManager.update(id, DBManager.OUTLAY_TABLE, cv); |
171 |
|
|
172 |
3
|
Log.i("OU", "Updated"); |
173 |
|
} |
174 |
|
|
|
|
| 100% |
Uncovered Elements: 0 (1) |
Complexity: 1 |
Complexity Density: 1 |
|
175 |
1
|
public void delete() {... |
176 |
1
|
dbManager.delete(id, DBManager.OUTLAY_TABLE); |
177 |
|
} |
178 |
|
|
|
|
| 85% |
Uncovered Elements: 6 (40) |
Complexity: 7 |
Complexity Density: 0,25 |
|
179 |
16
|
public void inflate(int _id) {... |
180 |
16
|
dbManager = saveApp.getDbManager(); |
181 |
16
|
id = _id; |
182 |
16
|
cursor = dbManager.select(id, DBManager.OUTLAY_TABLE_ID); |
183 |
16
|
int i = 0; |
184 |
16
|
Log.i("OU", "Read Cursor"); |
185 |
16
|
if (cursor.moveToFirst()) |
186 |
16
|
do { |
187 |
16
|
charge = Utilities |
188 |
|
.stringToInt(cursor.getString(cursor |
189 |
|
.getColumnIndexOrThrow(DBManager.OUTLAY_COLUMN_CHARGE))); |
190 |
|
|
191 |
16
|
note = cursor.getString(cursor |
192 |
|
.getColumnIndexOrThrow(DBManager.OUTLAY_COLUMN_NOTES)); |
193 |
|
|
194 |
16
|
date = cursor.getString(cursor |
195 |
|
.getColumnIndexOrThrow(DBManager.OUTLAY_COLUMN_DATE)); |
196 |
|
|
197 |
16
|
accountId = Utilities |
198 |
|
.stringToInt(cursor.getString(cursor |
199 |
|
.getColumnIndexOrThrow(DBManager.OUTLAY_COLUMN_ACCOUNT))); |
200 |
|
|
201 |
16
|
itemId = Utilities.stringToInt(cursor.getString(cursor |
202 |
|
.getColumnIndexOrThrow(DBManager.OUTLAY_COLUMN_ITEM))); |
203 |
|
|
204 |
16
|
placeId = Utilities.stringToInt(cursor.getString(cursor |
205 |
|
.getColumnIndexOrThrow(DBManager.OUTLAY_COLUMN_PLACE))); |
206 |
|
|
207 |
16
|
albumId = Utilities.stringToInt(cursor.getString(cursor |
208 |
|
.getColumnIndexOrThrow(DBManager.OUTLAY_COLUMN_ALBUM))); |
209 |
|
|
210 |
16
|
addressId = Utilities |
211 |
|
.stringToInt(cursor.getString(cursor |
212 |
|
.getColumnIndexOrThrow(DBManager.OUTLAY_COLUMN_ADDRESS))); |
213 |
|
|
214 |
16
|
setAccountDesc(saveApp.getAccountDesc()); |
215 |
|
|
216 |
16
|
if (itemId != 0) { |
217 |
16
|
item.inflate(itemId); |
218 |
16
|
itemDesc = item.getDescription(); |
219 |
|
} |
220 |
16
|
if (placeId != 0) { |
221 |
16
|
place.inflate(placeId); |
222 |
16
|
placeDesc = place.getDescription(); |
223 |
|
} |
224 |
16
|
if (albumId != 0) { |
225 |
|
|
226 |
16
|
albumDesc = ""; |
227 |
|
} |
228 |
16
|
if (addressId != 0) { |
229 |
16
|
address.inflate(addressId); |
230 |
16
|
addressDesc = address.getDescription(); |
231 |
|
} |
232 |
|
|
233 |
16
|
i++; |
234 |
16
|
} while (cursor.moveToNext()); |
235 |
|
} |
236 |
|
|
|
|
| 0% |
Uncovered Elements: 1 (1) |
Complexity: 1 |
Complexity Density: 1 |
|
237 |
0
|
public int insert() {... |
238 |
|
|
239 |
0
|
return 0; |
240 |
|
} |
241 |
|
|
|
|
| 100% |
Uncovered Elements: 0 (3) |
Complexity: 1 |
Complexity Density: 0,33 |
|
242 |
13
|
public int sum(int accountId) {... |
243 |
13
|
Log.i("IT", "Sum..."); |
244 |
13
|
int sum = dbManager.sum(DBManager.OUTLAY_TABLE, |
245 |
|
DBManager.OUTLAY_COLUMN_CHARGE, accountId, |
246 |
|
DBManager.OUTLAY_COLUMN_ACCOUNT); |
247 |
13
|
return sum; |
248 |
|
} |
249 |
|
|
|
|
| 100% |
Uncovered Elements: 0 (1) |
Complexity: 1 |
Complexity Density: 1 |
|
250 |
16
|
public void setId(int id) {... |
251 |
16
|
this.id = id; |
252 |
|
} |
253 |
|
|
|
|
| 100% |
Uncovered Elements: 0 (1) |
Complexity: 1 |
Complexity Density: 1 |
|
254 |
5
|
public int getId() {... |
255 |
5
|
return id; |
256 |
|
} |
257 |
|
|
|
|
| 100% |
Uncovered Elements: 0 (1) |
Complexity: 1 |
Complexity Density: 1 |
|
258 |
46
|
public void setCharge(int charge) {... |
259 |
46
|
this.charge = charge; |
260 |
|
} |
261 |
|
|
|
|
| 100% |
Uncovered Elements: 0 (1) |
Complexity: 1 |
Complexity Density: 1 |
|
262 |
67
|
public int getCharge() {... |
263 |
67
|
return charge; |
264 |
|
} |
265 |
|
|
|
|
| 100% |
Uncovered Elements: 0 (1) |
Complexity: 1 |
Complexity Density: 1 |
|
266 |
47
|
public void setDate(String date) {... |
267 |
47
|
this.date = date; |
268 |
|
} |
269 |
|
|
|
|
| 100% |
Uncovered Elements: 0 (1) |
Complexity: 1 |
Complexity Density: 1 |
|
270 |
67
|
public String getDate() {... |
271 |
67
|
return date; |
272 |
|
} |
273 |
|
|
|
|
| 0% |
Uncovered Elements: 1 (1) |
Complexity: 1 |
Complexity Density: 1 |
|
274 |
0
|
public void setAccount(int accountId) {... |
275 |
0
|
this.accountId = accountId; |
276 |
|
} |
277 |
|
|
|
|
| 0% |
Uncovered Elements: 1 (1) |
Complexity: 1 |
Complexity Density: 1 |
|
278 |
0
|
public int getAccount() {... |
279 |
0
|
return accountId; |
280 |
|
} |
281 |
|
|
|
|
| 100% |
Uncovered Elements: 0 (1) |
Complexity: 1 |
Complexity Density: 1 |
|
282 |
35
|
public void setNote(String note) {... |
283 |
35
|
this.note = note; |
284 |
|
} |
285 |
|
|
|
|
| 100% |
Uncovered Elements: 0 (1) |
Complexity: 1 |
Complexity Density: 1 |
|
286 |
22
|
public String getNote() {... |
287 |
22
|
return note; |
288 |
|
} |
289 |
|
|
|
|
| 100% |
Uncovered Elements: 0 (1) |
Complexity: 1 |
Complexity Density: 1 |
|
290 |
16
|
public void setItemId(int itemId) {... |
291 |
16
|
this.itemId = itemId; |
292 |
|
} |
293 |
|
|
|
|
| 0% |
Uncovered Elements: 1 (1) |
Complexity: 1 |
Complexity Density: 1 |
|
294 |
0
|
public int getItemId() {... |
295 |
0
|
return itemId; |
296 |
|
} |
297 |
|
|
|
|
| 100% |
Uncovered Elements: 0 (1) |
Complexity: 1 |
Complexity Density: 1 |
|
298 |
16
|
public void setPlaceId(int placeId) {... |
299 |
16
|
this.placeId = placeId; |
300 |
|
} |
301 |
|
|
|
|
| 0% |
Uncovered Elements: 1 (1) |
Complexity: 1 |
Complexity Density: 1 |
|
302 |
0
|
public int getPlaceId() {... |
303 |
0
|
return placeId; |
304 |
|
} |
305 |
|
|
|
|
| 100% |
Uncovered Elements: 0 (1) |
Complexity: 1 |
Complexity Density: 1 |
|
306 |
19
|
public void setAddressId(int addressId) {... |
307 |
19
|
this.addressId = addressId; |
308 |
|
} |
309 |
|
|
|
|
| 100% |
Uncovered Elements: 0 (1) |
Complexity: 1 |
Complexity Density: 1 |
|
310 |
2
|
public int getAddressId() {... |
311 |
2
|
return addressId; |
312 |
|
} |
313 |
|
|
|
|
| 100% |
Uncovered Elements: 0 (1) |
Complexity: 1 |
Complexity Density: 1 |
|
314 |
25
|
public void setAlbumId(int albumId) {... |
315 |
25
|
this.albumId = albumId; |
316 |
|
} |
317 |
|
|
|
|
| 0% |
Uncovered Elements: 1 (1) |
Complexity: 1 |
Complexity Density: 1 |
|
318 |
0
|
public int getAlbumId() {... |
319 |
0
|
return albumId; |
320 |
|
} |
321 |
|
|
|
|
| 100% |
Uncovered Elements: 0 (1) |
Complexity: 1 |
Complexity Density: 1 |
|
322 |
62
|
public void setAccountDesc(String accountDesc) {... |
323 |
62
|
this.accountDesc = accountDesc; |
324 |
|
} |
325 |
|
|
|
|
| 0% |
Uncovered Elements: 1 (1) |
Complexity: 1 |
Complexity Density: 1 |
|
326 |
0
|
public String getAccountDesc() {... |
327 |
0
|
return accountDesc; |
328 |
|
} |
329 |
|
|
|
|
| 100% |
Uncovered Elements: 0 (1) |
Complexity: 1 |
Complexity Density: 1 |
|
330 |
46
|
public void setItemDesc(String itemDesc) {... |
331 |
46
|
this.itemDesc = itemDesc; |
332 |
|
} |
333 |
|
|
|
|
| 100% |
Uncovered Elements: 0 (1) |
Complexity: 1 |
Complexity Density: 1 |
|
334 |
67
|
public String getItemDesc() {... |
335 |
67
|
return itemDesc; |
336 |
|
} |
337 |
|
|
|
|
| 100% |
Uncovered Elements: 0 (1) |
Complexity: 1 |
Complexity Density: 1 |
|
338 |
46
|
public void setPlaceDesc(String placeDesc) {... |
339 |
46
|
this.placeDesc = placeDesc; |
340 |
|
} |
341 |
|
|
|
|
| 100% |
Uncovered Elements: 0 (1) |
Complexity: 1 |
Complexity Density: 1 |
|
342 |
67
|
public String getPlaceDesc() {... |
343 |
67
|
return placeDesc; |
344 |
|
} |
345 |
|
|
|
|
| 100% |
Uncovered Elements: 0 (1) |
Complexity: 1 |
Complexity Density: 1 |
|
346 |
47
|
public void setAddressDesc(String addressDesc) {... |
347 |
47
|
this.addressDesc = addressDesc; |
348 |
|
} |
349 |
|
|
|
|
| 100% |
Uncovered Elements: 0 (1) |
Complexity: 1 |
Complexity Density: 1 |
|
350 |
32
|
public String getAddressDesc() {... |
351 |
32
|
return addressDesc; |
352 |
|
} |
353 |
|
|
354 |
|
} |