· 8 years ago · Jul 26, 2018, 02:36 AM
1package syntechbd.com.posspot.app;
2
3import android.content.ContentValues;
4import android.content.Context;
5import android.database.Cursor;
6import android.database.DatabaseUtils;
7import android.database.sqlite.SQLiteDatabase;
8import android.database.sqlite.SQLiteOpenHelper;
9import android.util.Log;
10
11import java.util.ArrayList;
12import java.util.HashMap;
13
14import syntechbd.com.posspot.modal.AddTOCartModal;
15import syntechbd.com.posspot.modal.CartModal;
16
17import static com.android.volley.VolleyLog.TAG;
18
19public class DBHelper extends SQLiteOpenHelper {
20
21
22
23 public static final String DATABASE_NAME = "SalesManager.db";
24// public static final String BATCH_TABLE_NAME = "BatchTable";
25// public static final String BATCH_COLUMN_PRODUCT_ID = "product_id";
26// public static final String BATCH_COLUMN_BATCH_NO = "batch_no";
27 // public static final String EXPENSE_COLUMN_CATEGORY_IDENTIFIER = "identifier";
28
29 public static final String CART_TABLE_ADD = "Add_To_Cart";
30 public static final String CART_ADD_COLUMN_ID = "columnId";
31 //public static final String CART_ADD_COLUMN_PRODUCT_ID = "ProductID";
32 public static final String CART_ADD_COLUMN_PRODUCT_CODE = "ProductCode";
33 public static final String CART_ADD_COLUMN_PRODUCT_NAME = "ProductName";
34
35 public static final String CART_ADD_COLUMN_SELECTED_BATCH = "SelectedBatch";
36 public static final String CART_ADD_COLUMN_PRODUCT_PRICE = "ProductPrice";
37 public static final String CART_ADD_COLUMN_PRODUCT_STOCK = "ProductStock";
38 public static final String CART_ADD_COLUMN_PRODUCT_QTY = "ProductQty";
39 public static final String CART_ADD_COLUMN_PRODUCT_DISCOUNT = "ProductDiscount";
40 public static final String CART_ADD_COLUMN_PRODUCT_DISCOUNT_PROMOTION_ID = "ProductDiscountPromotionID";
41 public static final String CART_ADD_COLUMN_VAT = "Vat";
42 public static final String CART_ADD_COLUMN_TOTALTAKA = "TotalTaka";
43 public static final String CART_ADD_COLUMN_DEFAULT_DISCOUNT ="DefaultDiscount" ;
44 public static final String CART_ADD_COLUMN_DEFAULT_VAT ="DefaultVat" ;
45
46
47 private HashMap hp;
48 private Context con;
49 public static String ProductCodes;
50
51 public DBHelper(Context context) {
52 super(context, "SalesManager", null, 1);
53 con = context;
54 }
55
56
57 @Override
58 public void onCreate(SQLiteDatabase db) {
59
60// String createTable = "create table BatchTable (id integer primary key AUTOINCREMENT UNIQUE, product_id, batch_no, identifier);";
61// db.execSQL(createTable);
62
63 String createTableAdd = "create table Add_To_Cart (columnId integer primary key AUTOINCREMENT UNIQUE, ProductCode, ProductName, SelectedBatch,ProductPrice,ProductStock,ProductQty,ProductDiscount,ProductDiscountPromotionID,Vat,TotalTaka,DefaultDiscount,DefaultVat);";
64 db.execSQL(createTableAdd);
65
66
67 }
68
69 @Override
70 public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
71 db.execSQL("DROP TABLE IF EXISTS!");
72 onCreate(db);
73 }
74
75
76// public boolean CheckBatch(String bAtch) {
77// SQLiteDatabase db = getWritableDatabase();
78// String selectString = "SELECT * FROM " + BATCH_TABLE_NAME + " WHERE " + BATCH_COLUMN_BATCH_NO + " =?";
79//
80// // Add the String you are searching by here.
81// // Put it in an array to avoid an unrecognized token error
82// Cursor cursor = db.rawQuery(selectString, new String[] {bAtch});
83// int count = 0;
84// boolean hasObject = false;
85// if(cursor.moveToFirst()){
86// hasObject = true;
87//
88// //region if you had multiple records to check for, use this region.
89//
90//
91// while(cursor.moveToNext()){
92// count++;
93// }
94//
95// if(count<=0){
96// hasObject = true;
97// }else hasObject = false;
98// //here, count is records found
99//
100//
101// //endregion
102//
103// }
104//// Log.d(TAG, String.format("Searching for String %d", bAtch));
105// Log.e("Searching Batch: ",bAtch);
106// Log.d(TAG, String.format("%d batch records found", count));
107//
108//
109// cursor.close(); // Dont forget to close your cursor
110// db.close(); //AND your Database!
111// return hasObject;
112// }
113
114
115
116
117// public void insertBatch(String product_id, String batch_no) {
118// SQLiteDatabase db = this.getWritableDatabase();
119//
120// ContentValues values = new ContentValues();
121// values.put(BATCH_COLUMN_PRODUCT_ID, product_id);//product_id name, product_id value
122// values.put(BATCH_COLUMN_BATCH_NO, batch_no);//batch_no name, batch_no value
123//
124//
125// // Inserting Row
126// db.insert(BATCH_TABLE_NAME, null, values);//tableName, nullColumnHack, ContentValues
127//
128// Log.e("Batch Inserted to db",values.toString());
129// db.close(); // Closing database connection
130//
131// }
132
133 public void insertAdd_To_Cart(String ProductCode, String ProductName, String SelectedBatch, String ProductPrice,String ProductStock, String ProductQty, String ProductDiscount,String ProductDiscountPromotionID, String Vat, String TotalTaka, String DefaultDiscount, String DefaultVat ) {
134 SQLiteDatabase db = this.getWritableDatabase();
135
136 ContentValues values = new ContentValues();
137
138 values.put(CART_ADD_COLUMN_PRODUCT_CODE, ProductCode);
139 values.put(CART_ADD_COLUMN_PRODUCT_NAME, ProductName);
140 values.put(CART_ADD_COLUMN_SELECTED_BATCH, SelectedBatch);
141 values.put(CART_ADD_COLUMN_PRODUCT_PRICE, ProductPrice);
142 values.put(CART_ADD_COLUMN_PRODUCT_STOCK, ProductStock);
143 values.put(CART_ADD_COLUMN_PRODUCT_QTY, ProductQty);
144
145 values.put(CART_ADD_COLUMN_PRODUCT_DISCOUNT, ProductDiscount);
146 values.put(CART_ADD_COLUMN_PRODUCT_DISCOUNT_PROMOTION_ID, ProductDiscountPromotionID);
147 values.put(CART_ADD_COLUMN_VAT, Vat);
148 values.put(CART_ADD_COLUMN_TOTALTAKA, TotalTaka);
149 values.put(CART_ADD_COLUMN_DEFAULT_DISCOUNT, DefaultDiscount);
150 values.put(CART_ADD_COLUMN_DEFAULT_VAT, DefaultVat);
151
152// for(int i=0;i<category_add.length;i++){
153// values.put(EXPENSE_ADD_COLUMN_CATEGORY_ADD, category_add[i]);
154// }
155 Log.e("Inserted to db",values.toString());
156 db.insert(CART_TABLE_ADD, null, values);
157 db.close();
158 }
159
160 public Integer deleteAddToCartItem(int idss){
161 SQLiteDatabase db = this.getWritableDatabase();
162 return db.delete(CART_TABLE_ADD, CART_ADD_COLUMN_ID +"=" + idss , null);
163
164
165 }
166 public int CheckSelectedSpinner(String selectedBatch) {
167 int rowId = -1 ;
168 SQLiteDatabase db = getWritableDatabase();
169 String selectString = "SELECT * FROM " + CART_TABLE_ADD + " WHERE " + CART_ADD_COLUMN_SELECTED_BATCH + " =?";
170 // String selectStringROW = "SELECT SelectedBatch FROM " + CART_TABLE_ADD + " WHERE " + CART_ADD_COLUMN_SELECTED_BATCH + " =?";
171 Cursor cursor = db.rawQuery(selectString, new String[] {selectedBatch});
172
173 if (cursor.moveToFirst()) {
174 do {
175
176 rowId = cursor.getInt(0);
177
178
179 } while (cursor.moveToNext());
180 }
181
182 cursor.close();
183 db.close();
184// Log.e("RowId:", rowId);
185
186 // Add the String you are searching by here.
187 // Put it in an array to avoid an unrecognized token error
188// Cursor cursor = db.rawQuery(selectString, new String[] {selectedBatch});
189// int count;
190// count = cursor.getCount();
191//// boolean hasObject = false;
192//// if(cursor.moveToFirst()){
193//// hasObject = true;
194////
195//// //region if you had multiple records to check for, use this region.
196////
197////
198//// while(cursor.moveToNext()){
199//// count++;
200////
201//// }
202////
203//// if(count<=0){
204//// hasObject = false;
205//// }else hasObject = true;
206//// //here, count is records found
207////
208////
209//// //endregion
210////
211//// }
212//// Log.d(TAG, String.format("Searching for String %d", selectedBatch));
213// Log.e("Searching String: ",selectedBatch);
214// Log.d(TAG, String.format("%d records got", count));
215//
216//
217// cursor.close(); // Dont forget to close your cursor
218// db.close(); //AND your Database!
219 return rowId;
220 }
221
222 public int ifFoundBatch (String selectedBatch) {
223
224 SQLiteDatabase db = getWritableDatabase();
225 String selectString = "SELECT * FROM " + CART_TABLE_ADD + " WHERE " + CART_ADD_COLUMN_SELECTED_BATCH + " =?";
226
227 Cursor cursor = db.rawQuery(selectString, new String[] {selectedBatch});
228 int count;
229 count = cursor.getCount();
230
231 Log.e("Searching String: ",selectedBatch);
232 Log.d(TAG, String.format("%d records got", count));
233
234
235 cursor.close(); // Dont forget to close your cursor
236 db.close(); //AND your Database!
237 return count;
238 }
239
240 public boolean CheckIsDataAlreadyInDBorNot(String pCode) {
241 SQLiteDatabase db = getWritableDatabase();
242 String selectString = "SELECT * FROM " + CART_TABLE_ADD + " WHERE " + CART_ADD_COLUMN_PRODUCT_CODE + " =?";
243
244 // Add the String you are searching by here.
245 // Put it in an array to avoid an unrecognized token error
246 Cursor cursor = db.rawQuery(selectString, new String[]{pCode});
247 int count = 0;
248 boolean hasObject = false;
249 if (cursor.moveToFirst()) {
250 hasObject = true;
251
252 //region if you had multiple records to check for, use this region.
253
254
255 while (cursor.moveToNext()) {
256 count++;
257 }
258
259 if (count <= 0) {
260 hasObject = false;
261 } else hasObject = true;
262 //here, count is records found
263
264
265 //endregion
266
267 }
268// Log.d(TAG, String.format("Searching for String %d", pCode));
269 Log.e("Searching String: ", pCode);
270 Log.d(TAG, String.format("%d records found", count));
271
272
273 cursor.close(); // Dont forget to close your cursor
274 db.close(); //AND your Database!
275 return hasObject;
276 }
277
278 public boolean aaaa(String PCode) {
279 SQLiteDatabase sqldb = this.getReadableDatabase();
280
281 String Query = "Select ProductCode from " + "Add_To_Cart" + " where " + "ProductCode" + " = " + PCode;
282 //Cursor cursor = sqldb.rawQuery("SELECT ProductCode from " + CART_TABLE_ADD + " where " + CART_ADD_COLUMN_PRODUCT_CODE+" =?", new String[]{PCode}, null);
283 Cursor cursor = sqldb.rawQuery(Query, null);
284
285 if(cursor.getCount() <= 0){
286 Log.e("This PCode ","does not Exist!");
287 cursor.close();
288 return false;
289 }else {
290 cursor.close();
291 Log.e("FoundDs product code?","YES");
292 return true;
293 }
294 }
295
296 public int getProductQty (String selectedBatch) {
297
298 SQLiteDatabase db = getWritableDatabase();
299 String selectString = "SELECT * FROM " + CART_TABLE_ADD + " WHERE " + CART_ADD_COLUMN_SELECTED_BATCH + " =?";
300
301 Cursor c = db.rawQuery(selectString, new String[] {selectedBatch});
302 int count=0;
303
304 if (c.moveToFirst()){
305 do{
306 count = Integer.valueOf(c.getString(c.getColumnIndex(CART_ADD_COLUMN_PRODUCT_QTY)));
307 }while(c.moveToNext());
308 }
309
310
311 Log.e("Searching String:--- ",selectedBatch);
312 Log.d(TAG, String.format("%d RECORDS got", count));
313
314
315 c.close(); // Dont forget to close your cursor
316 db.close(); //AND your Database!
317 return count;
318 }
319
320
321 public int getProdusctQty(String batch){
322
323 int totalQTY = 0;
324 SQLiteDatabase db = this.getReadableDatabase();
325 String selectQuery = "SELECT " +
326 CART_ADD_COLUMN_PRODUCT_QTY +
327 " FROM " + CART_TABLE_ADD
328 + " WHERE " +
329 CART_ADD_COLUMN_SELECTED_BATCH + "=?";
330
331
332 Cursor cursor = db.rawQuery(selectQuery, new String[] { batch } );
333
334
335
336
337 if (cursor.moveToFirst()) {
338 do {
339
340 totalQTY = Integer.valueOf(cursor.getString(cursor.getColumnIndex("ProductQty")));
341
342
343
344 } while (cursor.moveToNext());
345 }
346
347 cursor.close();
348 //db.close();
349 return totalQTY;
350 }
351
352
353 public String getProductCodes(int index) {
354 SQLiteDatabase sqldb = this.getReadableDatabase();
355
356 String productCode = "";
357 Cursor c = sqldb.rawQuery("SELECT ProductCode from " + "Add_To_Cart" + " where " + "columnId" + " = " + index, null);
358
359
360 if (c.moveToFirst()){
361 do{
362 productCode = c.getString(c.getColumnIndex("ProductCode"));
363 }while(c.moveToNext());
364 }
365//
366// cursor.moveToFirst();
367// while (!cursor.isAfterLast()) {
368// productCode = cursor.getString(cursor.getColumnIndex("ProductCode"));
369// ProductCodes = productCode;
370// cursor.moveToNext();
371// }
372//
373// cursor.close();
374// sqldb.close();
375
376// if(!cursor.moveToFirst()){
377//
378//// do {
379//// //productCode = cursor.getString(1);
380//// productCode = cursor.getString(cursor.getColumnIndex("ProductCode"));
381//// ProductCodes = productCode;
382//// //do something which you want and break
383//// break;
384//// } while (cursor.moveToLast());
385// }
386// else{
387//
388// do {
389// //productCode = cursor.getString(1);
390// productCode = cursor.getString(cursor.getColumnIndex("ProductCode"));
391// ProductCodes = productCode;
392//
393// //do something which you want and break
394// break;
395// } while (cursor.moveToLast());
396//
397// }
398
399 ProductCodes = productCode;
400 return ProductCodes;
401
402// Cursor cursor = null;
403// String productCode = "";
404// try {
405// cursor = sqldb.rawQuery("SELECT * from " + CART_TABLE_ADD + " where " + CART_ADD_COLUMN_ID+" =?", new String[]{index});
406// // db.rawQuery("SELECT ProductCode from " + CART_TABLE_ADD + " where " + CART_ADD_COLUMN_ID+" =?", new String[]{index});
407// if(cursor.getCount() > 0) {
408// cursor.moveToFirst();
409// productCode = cursor.getString(cursor.getColumnIndex("ProductCode"));
410// }
411// return productCode;
412// }finally {
413// cursor.close();
414// }
415 }
416
417// public boolean sss(String productCode) {
418// SQLiteDatabase db = this.getWritableDatabase();
419// boolean result = db.delete(BATCH_TABLE_NAME, BATCH_COLUMN_PRODUCT_ID + "='" + productCode +"' ;", null) > 0;
420// Log.e("Deleted? :","YES "+result);
421// return result;
422//
423// }
424
425// public void deleteBatch(String productCode)
426// {
427// SQLiteDatabase db = this.getWritableDatabase();
428// try
429// {
430// db.delete(BATCH_TABLE_NAME, "product_id = ?", new String[] { productCode });
431// Log.e("Deleted? :","YES ");
432// }
433// catch(Exception e)
434// {
435// e.printStackTrace();
436// Log.e("Deleted? :","No "+e.getMessage());
437// }
438// finally
439// {
440// db.close();
441// }
442// }
443
444
445 public ArrayList<CartModal> getOverviewList() {
446 CartModal overList = null;
447
448 ArrayList<CartModal> listOverview = new ArrayList<>();
449 hp = new HashMap();
450 SQLiteDatabase db = this.getReadableDatabase();
451 Cursor cursor = db.rawQuery("SELECT * FROM Add_To_Cart ORDER by columnId desc ", null);
452 cursor.moveToFirst();
453 while (!cursor.isAfterLast()) {
454 overList = new CartModal(cursor.getInt(0)
455 , cursor.getString(cursor.getColumnIndexOrThrow("ProductName")),
456 cursor.getString(cursor.getColumnIndexOrThrow("ProductCode"))
457 , cursor.getString(cursor.getColumnIndexOrThrow("ProductStock"))
458 , cursor.getString(cursor.getColumnIndexOrThrow("TotalTaka"))
459 , cursor.getString(cursor.getColumnIndexOrThrow("SelectedBatch"))
460 , cursor.getString(cursor.getColumnIndexOrThrow("ProductQty"))
461 , cursor.getString(cursor.getColumnIndexOrThrow("ProductPrice"))
462 , cursor.getString(cursor.getColumnIndexOrThrow("ProductDiscount"))
463 , cursor.getString(cursor.getColumnIndexOrThrow("ProductDiscountPromotionID"))
464 , cursor.getString(cursor.getColumnIndexOrThrow("Vat"))
465 , cursor.getString(cursor.getColumnIndexOrThrow("DefaultDiscount"))
466 , cursor.getString(cursor.getColumnIndexOrThrow("DefaultVat"))
467
468 );
469 listOverview.add(overList);
470 cursor.moveToNext();
471
472 }
473 cursor.close();
474 db.close();
475 return listOverview;
476 }
477
478
479
480
481
482 public Cursor getData(int id) {
483 SQLiteDatabase db = this.getReadableDatabase();
484 Cursor res = db.rawQuery("select * from Category where id=" + id + "", null);
485 return res;
486 }
487
488 public Cursor getDataAdd(int id) {
489 SQLiteDatabase db = this.getWritableDatabase();
490 Cursor cursor_add = db.rawQuery("select * from Category where id_add=" + id + "", null);
491 return cursor_add;
492 }
493
494 public Cursor getsumExpenseAmount(int id) {
495 SQLiteDatabase db = this.getWritableDatabase();
496 Cursor cursor_EA = db.rawQuery("select sum(amount) from Add_Expense where category_add = '$category_add' ", null);
497 return cursor_EA;
498 }
499
500 public int numberOfRows() {
501 SQLiteDatabase db = this.getReadableDatabase();
502 int numRows = (int) DatabaseUtils.queryNumEntries(db, CART_TABLE_ADD);
503 return numRows;
504 }
505
506 public int numberOfRowsAdd() {
507 SQLiteDatabase db = this.getReadableDatabase();
508 int numRowsAdd = (int) DatabaseUtils.queryNumEntries(db, CART_TABLE_ADD);
509 return numRowsAdd;
510 }
511
512// public boolean updateCategory(Integer id, String name) {
513// SQLiteDatabase db = this.getWritableDatabase();
514// ContentValues contentValues = new ContentValues();
515// contentValues.put("product_id", id);
516// contentValues.put("batch_no", name);
517//
518// db.update("BatchTable", contentValues, BATCH_COLUMN_PRODUCT_ID+ "=" +id, null);
519// return true;
520// }
521
522// public boolean updateAddExpense(Integer id, String name) {
523// SQLiteDatabase db = this.getWritableDatabase();
524//
525// ContentValues contentValues = new ContentValues();
526// contentValues.put("product_id", id);
527// contentValues.put("category_add", name);
528//
529// db.update("Add_To_Cart", contentValues, BATCH_COLUMN_PRODUCT_ID + "=" +id , new String[]{name});
530// return true;
531// }
532
533 public boolean sss(Integer id, String qty) {
534 SQLiteDatabase db = this.getWritableDatabase();
535
536 ContentValues contentValues = new ContentValues();
537 contentValues.put("product_id", id);
538 contentValues.put("category_add", qty);
539
540 db.update("Add_To_Cart", contentValues, CART_ADD_COLUMN_ID + "=" +id , new String[]{qty});
541 return true;
542 }
543
544 public void updateAddeedItem(String ProductCode, String ProductName, String SelectedBatch, String ProductPrice,String ProductStock, String ProductQty, String ProductDiscount,String ProductDiscountPromotionID, String Vat, String TotalTaka, String DefaultDiscount,String DefaultVat ) {
545 SQLiteDatabase db = this.getWritableDatabase();
546 ContentValues values = new ContentValues();
547 values.put(CART_ADD_COLUMN_PRODUCT_CODE, ProductCode);
548 values.put(CART_ADD_COLUMN_PRODUCT_NAME, ProductName);
549 values.put(CART_ADD_COLUMN_SELECTED_BATCH, SelectedBatch);
550 values.put(CART_ADD_COLUMN_PRODUCT_PRICE, ProductPrice);
551 values.put(CART_ADD_COLUMN_PRODUCT_STOCK, ProductStock);
552 values.put(CART_ADD_COLUMN_PRODUCT_QTY, ProductQty);
553
554 values.put(CART_ADD_COLUMN_PRODUCT_DISCOUNT, ProductDiscount);
555 values.put(CART_ADD_COLUMN_PRODUCT_DISCOUNT_PROMOTION_ID, ProductDiscountPromotionID);
556 values.put(CART_ADD_COLUMN_VAT, Vat);
557 values.put(CART_ADD_COLUMN_TOTALTAKA, TotalTaka);
558 values.put(CART_ADD_COLUMN_DEFAULT_DISCOUNT, DefaultDiscount);
559 values.put(CART_ADD_COLUMN_DEFAULT_VAT, DefaultVat);
560
561 // db.update("Add_To_Cart", values,CART_ADD_COLUMN_SELECTED_BATCH+ "=" +SelectedBatch , null );
562 db.update("Add_To_Cart", values,CART_ADD_COLUMN_SELECTED_BATCH+"= ?", new String[]{SelectedBatch});
563 // return true;
564 }
565
566 public void updateFromAdapter(String SelectedBatch, String ProductPrice, String ProductStock, String ProductQty,String Vat, String ProductDiscount, String TotalTaka) {
567 SQLiteDatabase db = this.getWritableDatabase();
568 ContentValues values = new ContentValues();
569 values.put(CART_ADD_COLUMN_SELECTED_BATCH, SelectedBatch);
570 values.put(CART_ADD_COLUMN_PRODUCT_PRICE, ProductPrice);
571 values.put(CART_ADD_COLUMN_PRODUCT_STOCK, ProductStock);
572 values.put(CART_ADD_COLUMN_PRODUCT_QTY, ProductQty);
573
574 values.put(CART_ADD_COLUMN_PRODUCT_DISCOUNT, ProductDiscount);
575 values.put(CART_ADD_COLUMN_VAT, Vat);
576 values.put(CART_ADD_COLUMN_TOTALTAKA, TotalTaka);
577
578 // db.update("Add_To_Cart", values,CART_ADD_COLUMN_SELECTED_BATCH+ "=" +SelectedBatch , null );
579 db.update("Add_To_Cart", values, CART_ADD_COLUMN_SELECTED_BATCH + "= ?", new String[]{SelectedBatch});
580 db.close();
581 Log.e("updated:", "YES");
582 // return true;
583 }
584
585 public boolean updateCategoryAdd(Integer id, String category_add, String amount, String date, String note) {
586 SQLiteDatabase db = this.getWritableDatabase();
587 ContentValues contentValues = new ContentValues();
588 contentValues.put("columnId", id);
589 contentValues.put("category_add", category_add);
590 contentValues.put("amount", amount);
591 contentValues.put("date", date);
592 contentValues.put("note", note);
593
594 db.update("Add_To_Cart", contentValues, CART_ADD_COLUMN_ID + "=" + id, null);
595 return true;
596 }
597
598 public boolean deleteCategoryAdd(Integer id, String category_add, String amount, String date, String note) {
599 SQLiteDatabase db = this.getWritableDatabase();
600 ContentValues contentValues = new ContentValues();
601 //contentValues.remove("columnId", product_id);
602 contentValues.put("category_add", category_add);
603 contentValues.put("amount", amount);
604 contentValues.put("date", date);
605 contentValues.put("note", note);
606
607 //db.delete(EXPENSE_TABLE_ADD, contentValues,EXPENSE_ADD_COLUMN_ID+ "=" +product_id , null );
608 return true;
609 }
610
611
612
613 public boolean deleteAddCategory(String value) {
614 SQLiteDatabase db = this.getWritableDatabase();
615 return db.delete(CART_TABLE_ADD, CART_ADD_COLUMN_SELECTED_BATCH + "='" + value +"' ;", null) > 0;
616 }
617
618 // test...........
619
620
621
622 public boolean deleteAddItem(String value) {
623 SQLiteDatabase db = this.getWritableDatabase();
624 return db.delete(CART_TABLE_ADD, CART_ADD_COLUMN_ID + "='" + value +"' ;", null) > 0;
625 }
626
627 //-------------
628
629
630
631
632
633
634
635// public ArrayList<String> getAllBatch(String productCode) {
636// ArrayList<String> array_list = new ArrayList<String>();
637// hp = new HashMap();
638// SQLiteDatabase db = this.getReadableDatabase();
639//
640// String selectString = "SELECT * FROM " + BATCH_TABLE_NAME + " WHERE " + BATCH_COLUMN_PRODUCT_ID + " =?";
641//
642// // Add the String you are searching by here.
643// // Put it in an array to avoid an unrecognized token error
644// Cursor res = db.rawQuery(selectString, new String[] {productCode});
645//
646// //Cursor res = db.rawQuery("select * from Category", null);
647// res.moveToFirst();
648//
649// while (res.isAfterLast() == false) {
650// //array_list.add("Default BatchTable");
651// array_list.add(res.getString(res.getColumnIndex(BATCH_COLUMN_BATCH_NO)));
652// res.moveToNext();
653// }
654// return array_list;
655// }
656
657
658
659// public List<Overview_ListView> getOverviewListOfaPerson(String person) {
660// Overview_ListView overList = null;
661//
662// List<Overview_ListView> listOverview = new ArrayList<>();
663// hp = new HashMap();
664// SQLiteDatabase db = this.getReadableDatabase();
665// //Cursor cursor = db.rawQuery("SELECT category_add, date, note, SUM(amount) AS total FROM Add_To_Cart Group by category_add ORDER by date desc ", null);
666// Cursor cursor = db.rawQuery("UPDATE Add_Expense SET amount= '0' WHERE category_add='" + person + "' ", null);
667// cursor.moveToFirst();
668// while (!cursor.isAfterLast()) {
669// overList = new Overview_ListView(cursor.getInt(0), cursor.getString(cursor.getColumnIndexOrThrow("category_add")), cursor.getInt(cursor.getColumnIndexOrThrow("total")),
670// cursor.getString(cursor.getColumnIndexOrThrow("date")), cursor.getString(cursor.getColumnIndexOrThrow("note")));
671// listOverview.add(overList);
672// cursor.moveToNext();
673//
674// }
675// cursor.close();
676// db.close();
677// return listOverview;
678// }
679//
680 public String getTotalAmountInCart() {
681 String totalAmmount = null;
682 SQLiteDatabase db = this.getReadableDatabase();
683 Cursor cursor = db.rawQuery("SELECT SUM(TotalTaka) AS TotalTaka FROM Add_To_Cart ", null);
684 //Cursor cursor = db.rawQuery("UPDATE Add_Expense SET amount= '0'", null);
685 cursor.moveToFirst();
686 while (!cursor.isAfterLast()) {
687 totalAmmount = cursor.getString(cursor.getColumnIndexOrThrow("TotalTaka"));
688 cursor.moveToNext();
689
690 }
691 cursor.close();
692 db.close();
693 return totalAmmount;
694 }
695//
696// public List<TabHistory_Week_List> getHistoryWeek() {
697// TabHistory_Week_List sample = null;
698//
699// List<TabHistory_Week_List> sampleList = new ArrayList<>();
700// hp = new HashMap();
701// SQLiteDatabase db = this.getReadableDatabase();
702// Cursor cursor = db.rawQuery("select * from Add_Expense ORDER by date desc ", null);
703// cursor.moveToFirst();
704// while (!cursor.isAfterLast()) {
705// sample = new TabHistory_Week_List(cursor.getInt(0), cursor.getString(1), cursor.getInt(2), cursor.getString(3), cursor.getString(4));
706// sampleList.add(sample);
707// cursor.moveToNext();
708// }
709// cursor.close();
710// db.close();
711// return sampleList;
712// }
713//
714// public List<TabHistory_Week_List> getHistoryofaDate(String date1, String date2) {
715// TabHistory_Week_List sample = null;
716//
717// List<TabHistory_Week_List> sampleList = new ArrayList<>();
718// hp = new HashMap();
719// SQLiteDatabase db = this.getReadableDatabase();
720// String selectQuery = "SELECT * FROM Add_Expense WHERE date BETWEEN '" + date1 + "' and '" + date2 + "' ";
721//
722// Cursor cursor = db.rawQuery(selectQuery, null);
723// cursor.moveToFirst();
724// while (!cursor.isAfterLast()) {
725// sample = new TabHistory_Week_List(cursor.getInt(0), cursor.getString(1), cursor.getInt(2), cursor.getString(3), cursor.getString(4));
726// sampleList.add(sample);
727// cursor.moveToNext();
728// }
729// cursor.close();
730// db.close();
731// return sampleList;
732// }
733//
734// public List<Graph_all_List> getPieGrapgListView() {
735// Graph_all_List overList = null;
736//
737// List<Graph_all_List> listOverview = new ArrayList<>();
738// hp = new HashMap();
739// SQLiteDatabase db = this.getReadableDatabase();
740// Cursor cursor = db.rawQuery("SELECT category_add, SUM(amount) AS total FROM Add_Expense GROUP BY category_add", null);
741// cursor.moveToFirst();
742// while (!cursor.isAfterLast()) {
743// overList = new Graph_all_List(cursor.getInt(0), cursor.getString(cursor.getColumnIndexOrThrow("category_add")), cursor.getInt(cursor.getColumnIndexOrThrow("total")));
744// listOverview.add(overList);
745// cursor.moveToNext();
746// }
747// cursor.close();
748// db.close();
749// return listOverview;
750// }
751//
752 public ArrayList<AddTOCartModal> getProductCodes() {
753 AddTOCartModal overList = null;
754
755 ArrayList<AddTOCartModal> listOverview = new ArrayList<>();
756 hp = new HashMap();
757 SQLiteDatabase db = this.getReadableDatabase();
758 Cursor cursor = db.rawQuery("SELECT * FROM ProductCode", null);
759 cursor.moveToFirst();
760 while (!cursor.isAfterLast()) {
761 overList = new AddTOCartModal(cursor.getInt(0), cursor.getString(2));
762 listOverview.add(overList);
763 cursor.moveToNext();
764 }
765 cursor.close();
766 db.close();
767 return listOverview;
768 }
769//
770// public List<TabHistory_Week_List> getHistoryList(){
771// TabHistory_Week_List tab = null;
772//
773// List<TabHistory_Week_List> listArrayList = new ArrayList<>();
774// hp = new HashMap();
775// SQLiteDatabase db = this.getReadableDatabase();
776// Cursor cursor = db.rawQuery("SELECT * FROM Add_Expense ", null);
777// cursor.moveToFirst();
778//
779// while (!cursor.isAfterLast()) {
780// tab = new TabHistory_Week_List(cursor.getInt(0), cursor.getString(1), cursor.getInt(2), cursor.getString(3), cursor.getString(4));
781// listArrayList.add(tab);
782// cursor.moveToNext();
783// }
784// cursor.close();
785// db.close();
786// return listArrayList;
787// }
788//
789// public List<Edit_expense_List> getAllExpenses() {
790// Edit_expense_List list = null;
791//
792// List<Edit_expense_List> listArray = new ArrayList<>();
793// hp = new HashMap();
794// SQLiteDatabase db = this.getReadableDatabase();
795// Cursor cursor = db.rawQuery("SELECT * FROM Add_Expense ORDER by date desc ", null);
796// cursor.moveToFirst();
797//
798// while (!cursor.isAfterLast()) {
799// list = new Edit_expense_List(cursor.getInt(0), cursor.getString(1), cursor.getString(2), cursor.getString(3), cursor.getString(4));
800// listArray.add(list);
801// cursor.moveToNext();
802// }
803// cursor.close();
804// db.close();
805// return listArray;
806// }
807//
808// public List<Edit_expense_List2> getCustomExpenses() {
809// Edit_expense_List2 list = null;
810//
811// List<Edit_expense_List2> listArray = new ArrayList<>();
812// hp = new HashMap();
813// SQLiteDatabase db = this.getReadableDatabase();
814// // Cursor cursor = db.rawQuery("SELECT * FROM Add_To_Cart UNION ALL ", null);
815// Cursor cursor = db.rawQuery("SELECT * FROM Add_Expense Group by date order by date desc; ", null);
816//
817//
818//
819// cursor.moveToFirst();
820//
821// while (!cursor.isAfterLast()) {
822// String deteils = cursor.getString(1) +" | "+ cursor.getString(4)+" | "+ cursor.getString(2)+" tk";
823// list = new Edit_expense_List2(deteils,cursor.getString(3));
824// listArray.add(list);
825// cursor.moveToNext();
826// }
827// cursor.close();
828// db.close();
829// return listArray;
830// }
831//
832// public List<Edit_expense_List> getAllExpensesByaSpecificUser(String user) {
833// Edit_expense_List list = null;
834//
835// List<Edit_expense_List> listArray = new ArrayList<>();
836// hp = new HashMap();
837// SQLiteDatabase db = this.getReadableDatabase();
838// Cursor cursor = db.rawQuery("SELECT * FROM Add_Expense WHERE category_add='" + user + "' ", null);
839// cursor.moveToFirst();
840//
841// while (!cursor.isAfterLast()) {
842// list = new Edit_expense_List(cursor.getInt(0), cursor.getString(1), cursor.getString(2), cursor.getString(3), cursor.getString(4));
843// listArray.add(list);
844// cursor.moveToNext();
845// }
846// cursor.close();
847// db.close();
848// return listArray;
849// }
850//
851//
852//
853// public List<List_All> getAllList() {
854// List_All overList = null;
855//
856// List<List_All> listOverview = new ArrayList<>();
857// hp = new HashMap();
858// SQLiteDatabase db = this.getReadableDatabase();
859// Cursor cursor = db.rawQuery("SELECT category_name, SUM(amount) AS total, date FROM Add_Expense " , null);
860// cursor.moveToFirst();
861// while (!cursor.isAfterLast()) {
862// overList = new List_All(cursor.getInt(0), cursor.getString(cursor.getColumnIndexOrThrow("batch_no")),
863// cursor.getInt(cursor.getColumnIndexOrThrow("total")), cursor.getString(cursor.getColumnIndexOrThrow("date")) );
864// listOverview.add(overList);
865// cursor.moveToNext();
866//
867// }
868// cursor.close();
869// db.close();
870// return listOverview;
871// }
872}