Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SQLiteDatabase sqLiteDatabase=myDbHelper.getWritableDatabase();
- String rowQuery="SELECT " +
- Database_Creation.MESSAGES_TABLE+"."+Database_Creation.MESSAGE+", "+
- Database_Creation.MESSAGES_TABLE+"."+Database_Creation.MESSAGE_ID+", "+
- Database_Creation.MESSAGES_TABLE+"."+Database_Creation.MESSAGE_PHONE_SENDER+", "+
- Database_Creation.MESSAGES_TABLE+"."+Database_Creation.MESSAGE_PHONE_RECIEVER+", "+
- Database_Creation.MESSAGES_TABLE+"."+Database_Creation.MESSAGE_DELEVERY_STATUS+", "+
- Database_Creation.MESSAGES_TABLE+"."+Database_Creation.MESSAGE_TAG+", "+
- Database_Creation.MESSAGES_TABLE+"."+Database_Creation.MESSAGE_TIME_STAMP+", "+
- Database_Creation.MESSAGES_TABLE+"."+Database_Creation.MESSAGE_CONVERSATION_ID+", "+
- Database_Creation.MESSAGES_TABLE+"."+Database_Creation.MESSAGE_TEXT_TYPE+", "+
- Database_Creation.MESSAGES_TABLE+"."+Database_Creation.MESSAGE_IS_DOWNLOADED+", "+
- Database_Creation.MESSAGES_TABLE+"."+Database_Creation.MESSAGE_TINY_FILE+", "+
- Database_Creation.MESSAGE_FILE_TABLE+"."+Database_Creation.MESSAGE_File_NAME+", "+
- Database_Creation.MESSAGE_FILE_TABLE+"."+Database_Creation.MESSAGE_FIle_SYNC_STATUS+", "+
- Database_Creation.MESSAGE_FILE_TABLE+"."+Database_Creation.MESSAGE_FILE_MIME_TYPE+", "+
- Database_Creation.MESSAGE_FILE_TABLE+"."+Database_Creation.MESSAGE_FIle_DELETED_STATUS+", "+
- Database_Creation.MESSAGE_FILE_TABLE+"."+Database_Creation.MESSAGE_File_THUMBNAIL+", "+
- Database_Creation.MESSAGE_FILE_TABLE+"."+Database_Creation.MESSAGE_FILE_ORIGINAL_NAME+", "+
- Database_Creation.MESSAGE_TABLE_FUNCTIONS+"."+Database_Creation.MESSAGE_FUNTION_MESSAGE_ID_REFRENCE+", "+
- Database_Creation.MESSAGE_TABLE_FUNCTIONS+"."+Database_Creation.MESSAGE_FUNTION+
- " FROM "+Database_Creation.MESSAGES_TABLE+
- " 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+
- " 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+
- " WHERE "+Database_Creation.MESSAGE_CONVERSATION_ID+"=? "
- +"ORDER BY "+Database_Creation.MESSAGES_TABLE+"."+Database_Creation.MESSAGE_TIME_STAMP+" DESC" +
- " LIMIT "+offset+","+itemcount;
- linearLayoutManager.setInitialPrefetchItemCount(2);
- rv_messages.setLayoutManager(linearLayoutManager);
- rv_messages.setHasFixedSize(true);
- rv_messages.setNestedScrollingEnabled(false);
- endlessScrollListener=new EndlessScrollListener(linearLayoutManager) {
- @Override
- public void onLoadMore(int page, int totalItemsCount, RecyclerView view) {
- Log.d(TAG,"new pag no:"+page);
- //populate_messages_add(conversation_id,page);
- }
- };
- rv_messages.addOnScrollListener(endlessScrollListener)
- private void processDate(@NonNull TextView tv, String dateAPIStr
- , String dateAPICompareStr
- , boolean isFirstItem) {
- SimpleDateFormat f = new SimpleDateFormat("dd MMM yy");
- if (isFirstItem) {
- //first item always got date/today to shows
- //and overkill to compare with next item flow
- Date dateFromAPI = null;
- try {
- dateFromAPI = f.parse(dateAPIStr);
- if (DateUtils.isToday(dateFromAPI.getTime())) tv.setText("today");
- else if (DateUtils.isToday(dateFromAPI.getTime() + DateUtils.DAY_IN_MILLIS)) tv.setText("yesterday");
- else tv.setText(dateAPIStr);
- tv.setIncludeFontPadding(false);
- tv.setVisibility(View.VISIBLE);
- } catch (ParseException e) {
- e.printStackTrace();
- tv.setVisibility(View.GONE);
- }
- } else {
- Log.d(TAG,"dateAPIStr:"+dateAPIStr+" dateAPICompareStr:"+dateAPICompareStr);
- if (!dateAPIStr.equalsIgnoreCase(dateAPICompareStr) || tv.getText()==null) {
- try {
- Date dateFromAPI = f.parse(dateAPIStr);
- // if (DateUtils.isToday(dateFromAPI.getTime())) tv.setText("today");
- // else if (DateUtils.isToday(dateFromAPI.getTime() + DateUtils.DAY_IN_MILLIS)) tv.setText("yesterday");
- tv.setText(dateAPIStr);
- tv.setIncludeFontPadding(false);
- tv.setVisibility(View.VISIBLE);
- } catch (ParseException e) {
- e.printStackTrace();
- tv.setVisibility(View.GONE);
- }
- } else {
- tv.setVisibility(View.GONE);
- //}
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement