コード例 #1
0
  private void loadEntryNames() {
    try {
      SQLiteConnection db_conn = new SQLiteConnection(getApplicationContext());

      Cursor cursor =
          db_conn.query(
              "SELECT id,name,type_name FROM "
                  + SQLiteConnection.TABLE_ENTRY_NAMES
                  + " ORDER BY sort");

      array_en_id = null;
      array_en_id = new int[cursor.getCount()];
      array_en_name = null;
      array_en_name = new String[cursor.getCount()];
      array_en_type = null;
      array_en_type = new String[cursor.getCount()];

      for (int i = 0; i < cursor.getCount(); i++) {
        cursor.moveToPosition(i);
        array_en_id[i] = cursor.getInt(0);
        array_en_name[i] = cursor.getString(1);
        array_en_type[i] = cursor.getString(2);
      }

      cursor.close();

      db_conn.close();
    } catch (Exception e) {
      e.printStackTrace();
    }
  }
コード例 #2
0
  private boolean checkLogin() {

    // funzt noch nicht
    /*UserFunctions uf = new UserFunctions(this);
    if (!uf.checkPlayServices(this)) {
        finish();
        return false;
    }*/

    SQLiteConnection db_conn = new SQLiteConnection(this);
    String[] user_res = db_conn.getUser();
    db_conn.close();

    if (user_res == null) {
      Intent login_intent = new Intent();
      login_intent.setClass(this, LoginActivity.class);
      startActivityForResult(login_intent, 0);
      return false;
    } else {

      return true;
    }
  }
コード例 #3
0
  private void logout() {

    final Context context = this;

    SQLiteConnection db_conn = new SQLiteConnection(context);

    ((NotificationManager) getSystemService(Context.NOTIFICATION_SERVICE)).cancel(1);

    AccountManager am = AccountManager.get(context);
    Account accounts[] = am.getAccounts();
    for (int i = 0; i < accounts.length; i++) {
      if (accounts[i].type.equals(getString(R.string.account_type))) {
        am.removeAccount(accounts[i], null, null);
      }
    }

    UserFunctions uf = new UserFunctions(context);
    uf.resetGCM();

    try {
      uf.logoutFacebook();
    } catch (Exception ex) {
    }

    db_conn.resetUserTable();
    db_conn.close();

    Intent intent = getIntent();
    overridePendingTransition(0, 0);
    intent.addFlags(Intent.FLAG_ACTIVITY_NO_ANIMATION);
    finish();
    overridePendingTransition(0, 0);
    startActivity(intent);

    // checkLogin();

  }
コード例 #4
0
        public void onClick(DialogInterface dialog, int id) {

          SQLiteConnection sql = new SQLiteConnection(getApplicationContext());

          Cursor c =
              getContentResolver()
                  .query(ContactsContract.Profile.CONTENT_RAW_CONTACTS_URI, null, null, null, null);
          try {

            c.moveToFirst();

            Uri rawContactUri =
                ContentUris.withAppendedId(
                    RawContacts.CONTENT_URI, c.getLong(c.getColumnIndex("contact_id")));
            Uri entityUri = Uri.withAppendedPath(rawContactUri, Entity.CONTENT_DIRECTORY);
            c =
                getContentResolver()
                    .query(
                        entityUri,
                        new String[] {
                          RawContacts.SOURCE_ID, Entity.DATA_ID, Entity.MIMETYPE, Entity.DATA1
                        },
                        null,
                        null,
                        null);

            while (c.moveToNext()) {

              if (!c.isNull(1)) {
                String mimeType = c.getString(2);
                String data = c.getString(3);

                Cursor tmp_c =
                    sql.query(
                        "SELECT id FROM "
                            + SQLiteConnection.TABLE_USER_DATA
                            + " WHERE value='"
                            + data
                            + "'");
                if (tmp_c.getCount() == 0) {

                  ContentValues values = new ContentValues();

                  tmp_c =
                      sql.query(
                          "SELECT id FROM "
                              + SQLiteConnection.TABLE_USER_DATA
                              + " ORDER BY id DESC");
                  tmp_c.moveToFirst();
                  int newID = tmp_c.getInt(0) + 1;

                  int en_id = -1;

                  if (mimeType.equals(ContactsContract.CommonDataKinds.Phone.CONTENT_ITEM_TYPE)) {

                    for (int i = 0; i < array_en_type.length; i++) {
                      if (array_en_type[i].equals("number")) {
                        en_id = array_en_id[i];

                        tmp_c =
                            sql.query(
                                "SELECT id FROM "
                                    + SQLiteConnection.TABLE_USER_DATA
                                    + " WHERE entrynames_id='"
                                    + String.valueOf(en_id)
                                    + "'");
                        if (tmp_c.getCount() == 0) break;
                      }
                    }

                  } else if (mimeType.equals(
                      ContactsContract.CommonDataKinds.Email.CONTENT_ITEM_TYPE)) {

                    for (int i = 0; i < array_en_type.length; i++) {
                      if (array_en_type[i].equals("email")) {
                        en_id = array_en_id[i];

                        tmp_c =
                            sql.query(
                                "SELECT id FROM "
                                    + SQLiteConnection.TABLE_USER_DATA
                                    + " WHERE entrynames_id='"
                                    + String.valueOf(en_id)
                                    + "'");
                        if (tmp_c.getCount() == 0) break;
                      }
                    }
                  }

                  if (en_id != -1) {
                    values.put("id", newID);
                    values.put("entrynames_id", en_id);
                    values.put("value", data);
                    sql.insert(SQLiteConnection.TABLE_USER_DATA, values);
                  }
                }
                tmp_c.close();
              }
            }

            new Thread(
                    new Runnable() {

                      @Override
                      public void run() {

                        new UserFunctions(getApplicationContext()).syncMyContact();
                      }
                    })
                .start();

            showDataInMyContact(fragment_mycontact.getView());

          } finally {
            c.close();
            sql.close();
          }
        }
コード例 #5
0
  public void showDataInMyFriends(final View friendsView) {

    if (friendsView == null) return;

    ListView lv_main = (ListView) friendsView.findViewById(R.id.myfriends_lv_main);
    LinearLayout ll_info_no_item =
        (LinearLayout) friendsView.findViewById(R.id.myfriends_ll_info_no_item);

    SQLiteConnection db_conn = new SQLiteConnection(getApplicationContext());

    List<ContactListViewItem> items = new ArrayList<ContactListViewItem>();

    lv_main.setVisibility(View.GONE);
    ll_info_no_item.setVisibility(View.VISIBLE);

    // Anfragen:

    final Cursor requests =
        db_conn.query(
            "SELECT id,name,frontname,birthday,place,pic FROM "
                + SQLiteConnection.TABLE_REQUESTS
                + " ORDER BY frontname, name"); // <> TODO eventuell //
    // nach nachname ordnen

    for (int i = 0; i < requests.getCount(); i++) {
      if (i == 0) {
        lv_main.setVisibility(View.VISIBLE);
        ll_info_no_item.setVisibility(View.GONE);
      }

      requests.moveToPosition(i);

      items.add(
          new ContactListViewItem() {
            {
              String str_pic = requests.getString(5);
              if ((str_pic != null) && (!str_pic.equals("")) && (!str_pic.equals("null"))) {
                try {
                  byte[] imageAsBytes = Base64.decode(str_pic.getBytes(), Base64.DEFAULT);
                  Bitmap bmThumbnail =
                      BitmapFactory.decodeByteArray(imageAsBytes, 0, imageAsBytes.length);

                  int x = Functions.dpsToPx(getApplicationContext(), 64);
                  bmThumbnail = Functions.scaleCenterCrop(bmThumbnail, x, x);

                  Thumbnail = bmThumbnail;
                } catch (Exception e) {
                  e.printStackTrace();
                }
              }
              ThumbnailResource = R.drawable.no_user_pic;
              Title = requests.getString(2) + " " + requests.getString(1);
              SubTitle = requests.getString(4);

              Id = (requests.getInt(0) * (-1) - 1);

              BackColor = getResources().getColor(R.color.request_background);
            }
          });
    }

    // Freunde:

    final Cursor friends =
        db_conn.query(
            "SELECT id,name,frontname,birthday,place,pic FROM "
                + SQLiteConnection.TABLE_FRIENDS
                + " ORDER BY frontname, name"); // <> TODO eventuell //
    // nach nachname ordnen

    for (int i = 0; i < friends.getCount(); i++) {

      if (i == 0) {
        lv_main.setVisibility(View.VISIBLE);
        ll_info_no_item.setVisibility(View.GONE);
      }

      friends.moveToPosition(i);

      items.add(
          new ContactListViewItem() {
            {
              String str_pic = friends.getString(5);
              if ((str_pic != null) && (!str_pic.equals("")) && (!str_pic.equals("null"))) {
                try {
                  byte[] imageAsBytes = Base64.decode(str_pic.getBytes(), Base64.DEFAULT);
                  Bitmap bmThumbnail =
                      BitmapFactory.decodeByteArray(imageAsBytes, 0, imageAsBytes.length);

                  int x = Functions.dpsToPx(getApplicationContext(), 64);
                  bmThumbnail = Functions.scaleCenterCrop(bmThumbnail, x, x);

                  Thumbnail = bmThumbnail;

                } catch (Exception e) {
                }
              }
              ThumbnailResource = R.drawable.no_user_pic;
              Title = friends.getString(2) + " " + friends.getString(1);
              SubTitle = friends.getString(4);

              Id = friends.getLong(0);
            }
          });
    }

    ContactListViewAdapter adapter = new ContactListViewAdapter(this, items);

    lv_main.setAdapter(adapter);

    lv_main.setOnItemClickListener(
        new OnItemClickListener() {

          @Override
          public void onItemClick(AdapterView<?> arg0, View arg1, int arg2, long arg3) {

            // Item - Click

            try {

              SQLiteConnection db_conn = new SQLiteConnection(getApplicationContext());
              Fragment myfraFragment = fragment_friends;

              boolean request = false;

              ListView lv_main = (ListView) friendsView.findViewById(R.id.myfriends_lv_main);

              long tmp_friend_id = ((ContactListViewItem) lv_main.getItemAtPosition(arg2)).Id;
              String[] items = null;
              Cursor friends;
              if (tmp_friend_id < 0) {
                // Anfrage:

                tmp_friend_id = ((tmp_friend_id + 1) * -1);

                friends =
                    db_conn.query(
                        "SELECT id,name,frontname,birthday,place,pic FROM "
                            + SQLiteConnection.TABLE_REQUESTS
                            + " WHERE id='"
                            + tmp_friend_id
                            + "'");
                friends.moveToFirst();

                request = true;

              } else {
                // Freund:
                friends =
                    db_conn.query(
                        "SELECT id,name,frontname,birthday,place,pic FROM "
                            + SQLiteConnection.TABLE_FRIENDS
                            + " WHERE id='"
                            + String.valueOf(tmp_friend_id)
                            + "'");
                friends.moveToFirst();

                Cursor friends_data =
                    db_conn.query(
                        "SELECT entrynames_id,value FROM "
                            + SQLiteConnection.TABLE_FRIENDS_DATA
                            + " WHERE friend_id='"
                            + String.valueOf(tmp_friend_id)
                            + "' ORDER BY entrynames_id");
                items = new String[friends_data.getCount()];

                for (int i = 0; i < friends_data.getCount(); i++) {
                  friends_data.moveToPosition(i);
                  items[i] =
                      String.valueOf(friends_data.getInt(0)) + "|" + friends_data.getString(1);
                }
              }

              String strPic = friends.getString(5);
              Bitmap bmPic;
              if (strPic != null && !(strPic.equals("") && !strPic.equals("null"))) {
                try {
                  byte[] imageAsBytes = Base64.decode(strPic.getBytes(), Base64.DEFAULT);
                  bmPic = BitmapFactory.decodeByteArray(imageAsBytes, 0, imageAsBytes.length);

                  // int x=Functions.dpsToPx(getApplicationContext(),128);
                  bmPic = Functions.scaleCenterCrop(bmPic, 256, 256);
                } catch (Exception e) {
                  bmPic = null;
                }
              } else {
                bmPic = null;
              }

              Intent details = new Intent(getApplicationContext(), DetailsDialogActivity.class);

              details.putExtra(DetailsDialogActivity.PARAM_NAME, friends.getString(1));
              details.putExtra(DetailsDialogActivity.PARAM_FRONTNAME, friends.getString(2));
              details.putExtra(DetailsDialogActivity.PARAM_BIRTHDAY, friends.getString(3));
              details.putExtra(DetailsDialogActivity.PARAM_PLACE, friends.getString(4));
              details.putExtra(DetailsDialogActivity.PARAM_PIC, bmPic);

              details.putExtra(DetailsDialogActivity.PARAM_ITEMS, items);

              details.putExtra(DetailsDialogActivity.PARAM_ID, tmp_friend_id);

              if (!request) {
                details.putExtra(DetailsDialogActivity.PARAM_ACTION_ID, 3);
              } else {

                details.putExtra(DetailsDialogActivity.PARAM_ACTION_ID, 2);
              }

              myfraFragment.startActivityForResult(details, 1);

              friends.close();
              db_conn.close();

            } catch (Exception e) {
              // Fehlermeldung
              e.printStackTrace();
            }
          }
        });

    db_conn.close();
    lv_main.setAdapter(adapter);
  }
コード例 #6
0
  public void showDataInMyContact(View myContactView) {

    if (myContactView == null) return;

    // lade Daten in UI
    try {

      SQLiteConnection db_conn = new SQLiteConnection(this);

      String[] user_res = db_conn.getUser();

      if (user_res != null) {
        TextView tv_name = (TextView) myContactView.findViewById(R.id.mycontact_tv_name);
        TextView tv_frontname = (TextView) myContactView.findViewById(R.id.mycontact_tv_frontname);
        ImageView iv_pic = (ImageView) myContactView.findViewById(R.id.mycontact_iv_picture);

        tv_name.setText(user_res[2]);
        tv_frontname.setText(user_res[3]);

        if (!(user_res[6] == null || user_res[6].equals("") || user_res[6].equals("null"))) {

          byte[] imageAsBytes = Base64.decode(user_res[6].getBytes(), Base64.DEFAULT);
          Bitmap bmPic = BitmapFactory.decodeByteArray(imageAsBytes, 0, imageAsBytes.length);

          int x = Functions.dpsToPx(this, 64);
          bmPic = Functions.scaleCenterCrop(bmPic, x, x);

          iv_pic.setImageBitmap(bmPic);
        }
      }

      LinearLayout ll_telephone =
          (LinearLayout) myContactView.findViewById(R.id.mycontact_ll_data_telephone);
      LinearLayout ll_email =
          (LinearLayout) myContactView.findViewById(R.id.mycontact_ll_data_email);
      LinearLayout ll_other =
          (LinearLayout) myContactView.findViewById(R.id.mycontact_ll_data_other);

      // jetzigen Inhalt l�schen
      ll_telephone.removeAllViews();
      ll_email.removeAllViews();

      ll_other.removeAllViews();

      Cursor mycontact_data =
          db_conn.query(
              "SELECT entrynames_id,value FROM "
                  + SQLiteConnection.TABLE_USER_DATA
                  + " ORDER BY entrynames_id");

      for (int i = 0; i < mycontact_data.getCount(); i++) {

        mycontact_data.moveToPosition(i);

        String name = array_en_name[Functions.indexOf(array_en_id, mycontact_data.getInt(0))];
        String type = array_en_type[Functions.indexOf(array_en_id, mycontact_data.getInt(0))];

        String value = mycontact_data.getString(1);
        String[] splitedValue = value.split("\\|");

        createNewContactObject(type, myContactView);
        LinearLayout container;

        if (type.equals("number")) {
          container = ll_telephone;
        } else if (type.equals("email")) {
          container = ll_email;
        } else {
          container = ll_other;
        }

        LinearLayout child = (LinearLayout) container.getChildAt(container.getChildCount() - 1);

        Spinner spinner = (Spinner) child.getChildAt(1);

        String items[] = new String[spinner.getAdapter().getCount()];
        for (int a = 0; a < spinner.getAdapter().getCount(); a++) {
          items[a] = ((String) spinner.getItemAtPosition(a)).toLowerCase(new Locale("en"));
        }

        if (splitedValue.length >= 2) {
          String[] newItems = new String[items.length + 1];
          System.arraycopy(items, 0, newItems, 0, items.length);
          newItems[newItems.length - 1] = splitedValue[0];

          MySpinnerArrayAdapter adapter =
              new MySpinnerArrayAdapter(
                  this, newItems, ((MySpinnerArrayAdapter) spinner.getAdapter()).getLargeScreen());
          spinner.setAdapter(adapter);
          spinner.setSelection(newItems.length - 1);
          ((EditText) child.getChildAt(0)).setText(splitedValue[1]);
        } else {
          spinner.setSelection(Functions.indexOf(items, name.toLowerCase(new Locale("en"))));
          ((EditText) child.getChildAt(0)).setText(value);
        }
      }

      mycontact_data.close();

      db_conn.close();

      myContactIsLoaded = true;
    } catch (Exception e) {
      e.printStackTrace();
    }
  }
コード例 #7
0
 private void requestsSeen() {
   SQLiteConnection sql = new SQLiteConnection(this);
   sql.executeQuery("UPDATE " + SQLiteConnection.TABLE_REQUESTS + " SET seen=1");
   sql.close();
 }
コード例 #8
0
  public boolean saveDataFromMyContact() {
    // speichere Daten von der UI

    try {

      SQLiteConnection db_conn = new SQLiteConnection(this);

      String[][] ui_data = getMyContactObjects();

      if ((!myContactIsLoaded) || (ui_data == null)) {
        db_conn.close();
        return false;
      }

      Cursor data =
          db_conn.query("SELECT entrynames_id,value FROM " + SQLiteConnection.TABLE_USER_DATA);
      String[][] data_edit = new String[data.getCount()][];

      for (int i = 0; i < data.getCount(); i++) {
        data.moveToPosition(i);
        data_edit[i] = new String[] {String.valueOf(data.getInt(0)), data.getString(1)};
      }

      if (!Functions.equalsArray(ui_data, data_edit)) {
        // Mein Kontakt in lokale db schreiben

        db_conn.executeQuery("DELETE FROM " + SQLiteConnection.TABLE_USER_DATA);

        for (int i = 0; i < ui_data.length; i++) {

          String[] str_tmp = ui_data[i];

          ContentValues values = new ContentValues();

          values.put("id", i);
          values.put("entrynames_id", Integer.parseInt(str_tmp[0]));
          values.put("value", str_tmp[1]);

          db_conn.insert(SQLiteConnection.TABLE_USER_DATA, values);
        }

        db_conn.executeQuery(
            "UPDATE " + SQLiteConnection.TABLE_USER + " SET change_date=CURRENT_TIMESTAMP");

        String checksums = db_conn.getChecksums();

        db_conn.setChecksums(
            checksums.replace(checksums.substring(32, 64), "00000000000000000000000000000000"));

        try {
          if (thread_sync != null) thread_sync.interrupt();
        } finally {
        }

        thread_sync =
            new Thread(
                new Runnable() {
                  public void run() {
                    new UserFunctions(getApplicationContext()).sync();
                  }
                });
        thread_sync.start();
      }

      data.close();
      db_conn.close();

    } catch (Exception ex) {
      ex.printStackTrace();
      return false;
    }

    return true;
  }