Advertisement
Guest User

Untitled

a guest
Jun 18th, 2019
97
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 5.19 KB | None | 0 0
  1. SQLiteDatabase sqLiteDatabase=myDbHelper.getWritableDatabase();
  2. String rowQuery="SELECT " +
  3. Database_Creation.MESSAGES_TABLE+"."+Database_Creation.MESSAGE+", "+
  4. Database_Creation.MESSAGES_TABLE+"."+Database_Creation.MESSAGE_ID+", "+
  5. Database_Creation.MESSAGES_TABLE+"."+Database_Creation.MESSAGE_PHONE_SENDER+", "+
  6. Database_Creation.MESSAGES_TABLE+"."+Database_Creation.MESSAGE_PHONE_RECIEVER+", "+
  7. Database_Creation.MESSAGES_TABLE+"."+Database_Creation.MESSAGE_DELEVERY_STATUS+", "+
  8. Database_Creation.MESSAGES_TABLE+"."+Database_Creation.MESSAGE_TAG+", "+
  9. Database_Creation.MESSAGES_TABLE+"."+Database_Creation.MESSAGE_TIME_STAMP+", "+
  10. Database_Creation.MESSAGES_TABLE+"."+Database_Creation.MESSAGE_CONVERSATION_ID+", "+
  11. Database_Creation.MESSAGES_TABLE+"."+Database_Creation.MESSAGE_TEXT_TYPE+", "+
  12. Database_Creation.MESSAGES_TABLE+"."+Database_Creation.MESSAGE_IS_DOWNLOADED+", "+
  13. Database_Creation.MESSAGES_TABLE+"."+Database_Creation.MESSAGE_TINY_FILE+", "+
  14. Database_Creation.MESSAGE_FILE_TABLE+"."+Database_Creation.MESSAGE_File_NAME+", "+
  15. Database_Creation.MESSAGE_FILE_TABLE+"."+Database_Creation.MESSAGE_FIle_SYNC_STATUS+", "+
  16. Database_Creation.MESSAGE_FILE_TABLE+"."+Database_Creation.MESSAGE_FILE_MIME_TYPE+", "+
  17. Database_Creation.MESSAGE_FILE_TABLE+"."+Database_Creation.MESSAGE_FIle_DELETED_STATUS+", "+
  18. Database_Creation.MESSAGE_FILE_TABLE+"."+Database_Creation.MESSAGE_File_THUMBNAIL+", "+
  19. Database_Creation.MESSAGE_FILE_TABLE+"."+Database_Creation.MESSAGE_FILE_ORIGINAL_NAME+", "+
  20. Database_Creation.MESSAGE_TABLE_FUNCTIONS+"."+Database_Creation.MESSAGE_FUNTION_MESSAGE_ID_REFRENCE+", "+
  21. Database_Creation.MESSAGE_TABLE_FUNCTIONS+"."+Database_Creation.MESSAGE_FUNTION+
  22.  
  23.  
  24.  
  25. " FROM "+Database_Creation.MESSAGES_TABLE+
  26. " LEFT JOIN "+Database_Creation.MESSAGE_FILE_TABLE+" ON "+Database_Creation.MESSAGES_TABLE+"."+Database_Creation.MESSAGE_ID+" = "+Database_Creation.MESSAGE_FILE_TABLE+"."+Database_Creation.MESSAGE_FILE_MESSAGE_ID+
  27. " LEFT JOIN "+Database_Creation.MESSAGE_TABLE_FUNCTIONS+" ON "+Database_Creation.MESSAGES_TABLE+"."+Database_Creation.MESSAGE_ID+" = "+Database_Creation.MESSAGE_TABLE_FUNCTIONS+"."+Database_Creation.MESSAGE_FUNTION_MESSAGE_ID+
  28. " WHERE "+Database_Creation.MESSAGE_CONVERSATION_ID+"=? "
  29. +"ORDER BY "+Database_Creation.MESSAGES_TABLE+"."+Database_Creation.MESSAGE_TIME_STAMP+" DESC" +
  30. " LIMIT "+offset+","+itemcount;
  31.  
  32. linearLayoutManager.setInitialPrefetchItemCount(2);
  33. rv_messages.setLayoutManager(linearLayoutManager);
  34. rv_messages.setHasFixedSize(true);
  35. rv_messages.setNestedScrollingEnabled(false);
  36. endlessScrollListener=new EndlessScrollListener(linearLayoutManager) {
  37. @Override
  38. public void onLoadMore(int page, int totalItemsCount, RecyclerView view) {
  39. Log.d(TAG,"new pag no:"+page);
  40. //populate_messages_add(conversation_id,page);
  41. }
  42. };
  43. rv_messages.addOnScrollListener(endlessScrollListener)
  44.  
  45. private void processDate(@NonNull TextView tv, String dateAPIStr
  46. , String dateAPICompareStr
  47. , boolean isFirstItem) {
  48.  
  49. SimpleDateFormat f = new SimpleDateFormat("dd MMM yy");
  50. if (isFirstItem) {
  51. //first item always got date/today to shows
  52. //and overkill to compare with next item flow
  53. Date dateFromAPI = null;
  54. try {
  55. dateFromAPI = f.parse(dateAPIStr);
  56. if (DateUtils.isToday(dateFromAPI.getTime())) tv.setText("today");
  57. else if (DateUtils.isToday(dateFromAPI.getTime() + DateUtils.DAY_IN_MILLIS)) tv.setText("yesterday");
  58. else tv.setText(dateAPIStr);
  59. tv.setIncludeFontPadding(false);
  60. tv.setVisibility(View.VISIBLE);
  61. } catch (ParseException e) {
  62. e.printStackTrace();
  63. tv.setVisibility(View.GONE);
  64. }
  65. } else {
  66. Log.d(TAG,"dateAPIStr:"+dateAPIStr+" dateAPICompareStr:"+dateAPICompareStr);
  67. if (!dateAPIStr.equalsIgnoreCase(dateAPICompareStr) || tv.getText()==null) {
  68. try {
  69. Date dateFromAPI = f.parse(dateAPIStr);
  70. // if (DateUtils.isToday(dateFromAPI.getTime())) tv.setText("today");
  71. // else if (DateUtils.isToday(dateFromAPI.getTime() + DateUtils.DAY_IN_MILLIS)) tv.setText("yesterday");
  72. tv.setText(dateAPIStr);
  73. tv.setIncludeFontPadding(false);
  74. tv.setVisibility(View.VISIBLE);
  75. } catch (ParseException e) {
  76. e.printStackTrace();
  77. tv.setVisibility(View.GONE);
  78. }
  79. } else {
  80. tv.setVisibility(View.GONE);
  81. //}
  82. }
  83. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement