DashboardDataLayer.java

/*
 * Copyright (C) 2009 Dimagi Inc., UNICEF
 *
 * Licensed under the Apache License, Version 2.0 (the "License"); you may not
 * use this file except in compliance with the License. You may obtain a copy of
 * the License at
 *
 * http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS, WITHOUT
 * WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the
 * License for the specific language governing permissions and limitations under
 * the License.
 *
 */

package org.rapidandroid.data.controller;

import org.rapidandroid.data.RapidSmsDBConstants;
import org.rapidandroid.data.SmsDbHelper;
import org.rapidsms.java.core.model.Form;

import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;

/**
 * @author Daniel Myung dmyung@dimagi.com
 * @created Feb 4, 2009 Summary:
 */
public class DashboardDataLayer {

	private static SmsDbHelper mDbHelper;
	private static SQLiteDatabase mDb;

	public synchronized static Cursor getCursorForFormData(Context context, Form f, int count) {
		if (mDb != null) {
			if (mDb.isOpen()) {
				mDb.close();
			}
			mDb = null;
		}

		if (mDbHelper != null) {
			mDbHelper.close();
			mDbHelper = null;
		}

		mDbHelper = new SmsDbHelper(context);
		mDb = mDbHelper.getReadableDatabase();
		StringBuilder query = new StringBuilder();
		query.append("select " + RapidSmsDBConstants.FormData.TABLE_PREFIX);
		query.append(f.getPrefix()
				+ ".*, rapidandroid_message.message, rapidandroid_message.time, rapidandroid_monitor.phone ");
		query.append(" from " + RapidSmsDBConstants.FormData.TABLE_PREFIX + f.getPrefix());
		query.append(" join rapidandroid_message on (");
		query.append(RapidSmsDBConstants.FormData.TABLE_PREFIX + f.getPrefix());
		query.append(".message_id = rapidandroid_message._id");
		query.append(") ");
		query.append(" join rapidandroid_monitor on (rapidandroid_message.monitor_id = rapidandroid_monitor._id) ");
		query.append(" ORDER BY rapidandroid_message.time DESC LIMIT ").append(count);

		Cursor cr = mDb.rawQuery(query.toString(), null);

		//
		return cr;
	}

	public synchronized static Cursor getCursorForRawMessages(Context context, int count) {
		if (mDb != null) {
			if (mDb.isOpen()) {
				mDb.close();
			}
			mDb = null;
		}

		if (mDbHelper != null) {
			mDbHelper.close();
			mDbHelper = null;
		}
		mDbHelper = new SmsDbHelper(context);
		mDb = mDbHelper.getReadableDatabase();
		StringBuilder sb = new StringBuilder();
		sb.append("select * from rapidandroid_message ORDER BY time DESC LIMIT ").append(count);
		Cursor cr = mDb.rawQuery(sb.toString(), null);

		return cr;
	}
	
	public synchronized static Cursor getCursorForMultipartMessages(Context context, int mListCount){
		
		if (mDb != null){
			if (mDb.isOpen()){
				mDb.close();
			}
			mDb = null;
		}
		
		if (mDbHelper != null){
			mDbHelper.close();
			mDbHelper = null;
		}
		mDbHelper = new SmsDbHelper(context);
		mDb = mDbHelper.getReadableDatabase();
		StringBuilder sb = new StringBuilder();
//		sb.append("SELECT * FROM sages_multisms_worktable ORDER BY tx_id ASC, segment_number ASC;");
		//[MON_ID, alias, _id, segment_number, total_segments, tx_id, tx_timestamp, payload, monitor_msg_id, _id, phone, monitor_id, time, message, is_outgoing, is_virtual, receive_time, _id, first_name, last_name, alias, phone, email, incoming_messages, receive_reply]
		sb.append("SELECT mon._id as MON_ID, mon.alias,  * FROM sages_multisms_worktable smw left join rapidandroid_message mes on monitor_msg_id = mes._id left join rapidandroid_monitor mon on monitor_id = mon._id ORDER BY tx_id ASC, segment_number ASC;");
		Cursor cr = mDb.rawQuery(sb.toString(), null);
		return cr;
	}

}