@Override
protected void onRestart() {
db = (new N_LocalDataBase(getApplicationContext(), null)).getDataBase();
Cursor cursor =
db.rawQuery(
"select * from group_notification where type='receive' order by cast(receive_time as bigint) desc",
null);
List<Map<String, Object>> listitems = new ArrayList<Map<String, Object>>();
for (cursor.moveToFirst(); !cursor.isAfterLast(); cursor.moveToNext()) {
String old_create_time = cursor.getString(cursor.getColumnIndex("receive_time"));
String creatorName = cursor.getString(cursor.getColumnIndex("creatorName"));
String title = cursor.getString(cursor.getColumnIndex("title"));
String content = cursor.getString(cursor.getColumnIndex("content"));
String _id = cursor.getString(cursor.getColumnIndex("_id"));
String if_read = cursor.getString(cursor.getColumnIndex("read"));
Map<String, Object> item = new HashMap<String, Object>();
item.put("name", creatorName);
item.put("title", title);
item.put("content", content);
item.put("_id", _id);
if (if_read == null || if_read.equals("false")) {
item.put("image", R.drawable.notificationred);
item.put("status", "未读");
} else {
item.put("image", R.drawable.notificationgreen);
item.put("status", "已读");
}
item.put("create_time", NotificationDetailActivity.gethowlong(old_create_time));
listitems.add(item);
}
simpleAdapter =
new SimpleAdapter(
this,
listitems,
R.layout.receivenotification,
new String[] {"image", "_id", "name", "title", "content", "create_time", "status"},
new int[] {
R.id.notification_ifread,
R.id.id_msg_item_receive,
R.id.notifation_creater1,
R.id.notification_name1,
R.id.notification_content1,
R.id.bmjnotification_time,
R.id.member_status
});
// simpleCursorAdapter = new
// SimpleCursorAdapter(this,R.layout.receivenotification,cursor,
// new String[] {"_id","creatorName","title","content","create_time"}
// ,new
// int[]{R.id.id_msg_item_receive,R.id.notifation_creater1,R.id.notification_name1,R.id.notification_content1,R.id.bmjnotification_time} ,0);
Cursor cursor1 =
db.rawQuery(
"select * from group_notification where type='send' order by cast(create_time as bigint) desc",
null);
List<Map<String, Object>> listitems1 = new ArrayList<Map<String, Object>>();
for (cursor1.moveToFirst(); !cursor1.isAfterLast(); cursor1.moveToNext()) {
String old_create_time1 = cursor1.getString(cursor1.getColumnIndex("create_time"));
String title1 = cursor1.getString(cursor1.getColumnIndex("title"));
String content1 = cursor1.getString(cursor1.getColumnIndex("content"));
String _id1 = cursor1.getString(cursor1.getColumnIndex("_id"));
Map<String, Object> item = new HashMap<String, Object>();
item.put("title1", title1);
item.put("content1", content1);
item.put("_id1", _id1);
item.put("create_time1", NotificationDetailActivity.gethowlong(old_create_time1));
listitems1.add(item);
}
simpleAdapter1 =
new SimpleAdapter(
this,
listitems1,
R.layout.mysend_notification,
new String[] {"_id1", "title1", "content1", "create_time1"},
new int[] {
R.id.id_msg_item_send,
R.id.notification_name2,
R.id.notification_content,
R.id.bmjnotification_time2
});
lv_my.setAdapter(simpleAdapter);
lv_receive.setAdapter(simpleAdapter1);
// simpleCursorAdapter1 = new
// SimpleCursorAdapter(this,R.layout.mysend_notification,cursor1,
// new String[] {"_id","title","content","create_time"}
// ,new
// int[]{R.id.id_msg_item_send,R.id.notification_name2,R.id.notification_content,R.id.bmjnotification_time2} ,0);
//
// lv_my.setAdapter(simpleCursorAdapter);
// lv_receive.setAdapter(simpleCursorAdapter1);
simpleAdapter.notifyDataSetChanged();
simpleAdapter1.notifyDataSetChanged();
super.onRestart();
}
private void initView() {
iv_create = (ImageView) findViewById(R.id.imageView_create_new);
iv_create.setOnClickListener(
new View.OnClickListener() {
@Override
public void onClick(View view) {
Intent intent = new Intent();
Bundle b = new Bundle();
intent.setClass(GroupNotificationMainActivity.this, CreateNotificationActivity.class);
startActivityForResult(intent, REQUSETOK2);
}
});
iv_back = (RelativeLayout) findViewById(R.id.back);
iv_back.setOnClickListener(
new View.OnClickListener() {
@Override
public void onClick(View view) {
finish();
}
});
lv_receive = (ListView) findViewById(R.id.mynotification_list);
lv_my = (ListView) findViewById(R.id.receivenotification_list);
final TextView tabBtnReceive = (TextView) findViewById(R.id.tab_btn_receive);
final TextView tabBtnSend = (TextView) findViewById(R.id.tab_btn_send);
tabBtnReceive.setOnClickListener(
new View.OnClickListener() {
@Override
public void onClick(View v) {
tabBtnReceive.setBackgroundResource(R.drawable.my_tab_sel);
tabBtnReceive.setTextColor(getResources().getColor(R.color.my_tab_sel_color));
tabBtnSend.setBackgroundColor(getResources().getColor(android.R.color.white));
tabBtnSend.setTextColor(Color.parseColor("#313131"));
lv_my.setVisibility(View.VISIBLE);
lv_receive.setVisibility(View.GONE);
}
});
tabBtnSend.setOnClickListener(
new View.OnClickListener() {
@Override
public void onClick(View v) {
tabBtnSend.setBackgroundResource(R.drawable.my_tab_sel);
tabBtnSend.setTextColor(getResources().getColor(R.color.my_tab_sel_color));
tabBtnReceive.setBackgroundColor(getResources().getColor(android.R.color.white));
tabBtnReceive.setTextColor(Color.parseColor("#313131"));
lv_receive.setVisibility(View.VISIBLE);
lv_my.setVisibility(View.GONE);
}
});
db = (new N_LocalDataBase(getApplicationContext(), null)).getDataBase();
Cursor cursor =
db.rawQuery(
"select * from group_notification where type='receive' order by cast(receive_time as bigint) desc",
null);
List<Map<String, Object>> listitems = new ArrayList<Map<String, Object>>();
for (cursor.moveToFirst(); !cursor.isAfterLast(); cursor.moveToNext()) {
String old_create_time = cursor.getString(cursor.getColumnIndex("receive_time"));
String creatorName = cursor.getString(cursor.getColumnIndex("creatorName"));
String title = cursor.getString(cursor.getColumnIndex("title"));
String content = cursor.getString(cursor.getColumnIndex("content"));
String _id = cursor.getString(cursor.getColumnIndex("_id"));
String if_read = cursor.getString(cursor.getColumnIndex("read"));
Map<String, Object> item = new HashMap<String, Object>();
item.put("name", creatorName);
item.put("title", title);
item.put("content", content);
item.put("_id", _id);
if (if_read == null || if_read.equals("false")) {
item.put("image", R.drawable.notificationred);
item.put("status", "未读");
} else {
item.put("image", R.drawable.notificationgreen);
item.put("status", "已读");
}
item.put("create_time", NotificationDetailActivity.gethowlong(old_create_time));
listitems.add(item);
}
simpleAdapter =
new SimpleAdapter(
this,
listitems,
R.layout.receivenotification,
new String[] {"image", "_id", "name", "title", "content", "create_time", "status"},
new int[] {
R.id.notification_ifread,
R.id.id_msg_item_receive,
R.id.notifation_creater1,
R.id.notification_name1,
R.id.notification_content1,
R.id.bmjnotification_time,
R.id.member_status
});
// simpleCursorAdapter = new
// SimpleCursorAdapter(this,R.layout.receivenotification,cursor,
// new String[] {"_id","creatorName","title","content","create_time"}
// ,new
// int[]{R.id.id_msg_item_receive,R.id.notifation_creater1,R.id.notification_name1,R.id.notification_content1,R.id.bmjnotification_time} ,0);
Cursor cursor1 =
db.rawQuery(
"select * from group_notification where type='send' order by cast(create_time as bigint) desc",
null);
List<Map<String, Object>> listitems1 = new ArrayList<Map<String, Object>>();
for (cursor1.moveToFirst(); !cursor1.isAfterLast(); cursor1.moveToNext()) {
String old_create_time1 = cursor1.getString(cursor1.getColumnIndex("create_time"));
String title1 = cursor1.getString(cursor1.getColumnIndex("title"));
String content1 = cursor1.getString(cursor1.getColumnIndex("content"));
String _id1 = cursor1.getString(cursor1.getColumnIndex("_id"));
Map<String, Object> item = new HashMap<String, Object>();
item.put("title1", title1);
item.put("content1", content1);
item.put("_id1", _id1);
item.put("create_time1", NotificationDetailActivity.gethowlong(old_create_time1));
listitems1.add(item);
}
simpleAdapter1 =
new SimpleAdapter(
this,
listitems1,
R.layout.mysend_notification,
new String[] {"_id1", "title1", "content1", "create_time1"},
new int[] {
R.id.id_msg_item_send,
R.id.notification_name2,
R.id.notification_content,
R.id.bmjnotification_time2
});
lv_my.setAdapter(simpleAdapter);
lv_receive.setAdapter(simpleAdapter1);
// simpleCursorAdapter1 = new
// SimpleCursorAdapter(this,R.layout.mysend_notification,cursor1,
// new String[] {"_id","title","content","create_time"}
// ,new
// int[]{R.id.id_msg_item_send,R.id.notification_name2,R.id.notification_content,R.id.bmjnotification_time2} ,0);
//
// lv_my.setAdapter(simpleCursorAdapter);
// lv_receive.setAdapter(simpleCursorAdapter1);
simpleAdapter.notifyDataSetChanged();
simpleAdapter1.notifyDataSetChanged();
lv_my.setOnItemClickListener(
new AdapterView.OnItemClickListener() {
@Override
public void onItemClick(AdapterView<?> parent, View view, int position, long i) {
TextView id =
(TextView)
parent
.getChildAt(position - parent.getFirstVisiblePosition())
.findViewById(R.id.id_msg_item_receive);
SQLiteDatabase db;
db = (new N_LocalDataBase(getApplicationContext(), null)).getDataBase();
Cursor c =
db.rawQuery(
"select * from group_notification where _id='" + id.getText() + "'", null);
// db.execSQL("update group_notification set read='true' where _id='"+id.getText()+"'");
if (c.getCount() > 0) {
c.moveToFirst();
String sever_id = c.getString(c.getColumnIndex("server_id"));
String joiner_id = c.getString(c.getColumnIndex("joinerID"));
String[] split_id = joiner_id.split(",");
c.close();
Intent intent = new Intent();
intent.putExtra("item_id", id.getText());
// intent.putExtra("severid",sever_id);
intent.setClass(GroupNotificationMainActivity.this, NotificationDetailActivity.class);
startActivity(intent);
// Toast.makeText(getApplicationContext(), id.getText(), Toast.LENGTH_SHORT).show();
}
}
});
lv_receive.setOnItemClickListener(
new AdapterView.OnItemClickListener() {
@Override
public void onItemClick(AdapterView<?> parent, View view, int position, long i) {
TextView id =
(TextView)
parent
.getChildAt(position - parent.getFirstVisiblePosition())
.findViewById(R.id.id_msg_item_send);
Intent intent = new Intent();
intent.putExtra("item_id", id.getText());
intent.setClass(GroupNotificationMainActivity.this, NotificationDetailActivity.class);
startActivity(intent);
// Toast.makeText(getApplicationContext(), id.getText(), Toast.LENGTH_SHORT).show();
}
});
}
