Dh8ekkXM

1public ArrayList<UserCommunity> getUsersToInvite() {
2    ArrayList<UserCommunity> users = new ArrayList<>();
3
4    // 1. build the query
5    String query = "SELECT * FROM " + TABLE_USERS +
6            "  WHERE invited = '0' OR invited = null";
7
8    // 2. get reference to writable DB
9    SQLiteDatabase db = this.getWritableDatabase();
10    Cursor cursor = db.rawQuery(query, null);
11
12    // 3. go over each row, build book and add it to list
13    UserCommunity user = null;
14    if (cursor.moveToFirst()) {
15        do {
16            user = new UserCommunity();
17            user.id = Integer.parseInt(cursor.getString(0));
18            user.name = cursor.getString(1);
19            user.email = cursor.getString(2);
20            //user.distance = Integer.parseInt(cursor.getString(9));
21
22            // Add book to books
23            users.add(user);
24        } while (cursor.moveToNext());
25    }
26
27    Log.d("getUsersNearCoordinat()", users.toString());
28
29    // return books
30    return users;
31}
32	
33public InvitePresenter(InviteView inviteView){
34
35        inflater = (LayoutInflater)inviteView.getContext().getSystemService(Context.LAYOUT_INFLATER_SERVICE);
36        serviceDB = new UsersMySQLiteHelper(AppController.getAppContext());
37
38        RequestManager.Users(new FutureCallback<JsonObject>() {
39            @Override
40            public void onCompleted(Exception e, JsonObject result) {
41                SessionManager sessionManager = new SessionManager();
42                if (!sessionManager.getInvitedUser()) {
43                    usersList = new Gson().fromJson(result.get("data"), new TypeToken<ArrayList<UserCommunity>>() {
44                    }.getType());
45                    sessionManager.setInvitedUser(true);
46                }else{
47                    usersList = serviceDB.getUsersToInvite();
48                }
49                notifyDataSetChanged();
50            }
51        });
52        this.inviteView = inviteView;
53}
54	
55String CREATE_USERS_TABLE = "CREATE TABLE if not exists users ( " +
56        "id INTEGER PRIMARY KEY, " +
57        "name TEXT, "+
58        "email TEXT, "+
59        "company TEXT, "+
60        "photo_url TEXT, "+
61        "departure_time TEXT, "+
62        "arrival_time TEXT, "+
63        "address_lat DOUBLE,"+
64        "address_lng DOUBLE,"+
65        "invited INTEGER)";
66
67// create books table
68db.execSQL(CREATE_USERS_TABLE);