import android.content.ContentValues;
import android.content.Context;
import android.content.Intent;
+import android.database.Cursor;
import android.database.SQLException;
import android.database.sqlite.SQLiteDatabase;
import android.view.View;
}
public static String formatDate(final int year, final int month, final int day){
- return String.format(Locale.ENGLISH, "%4d-%02d-%02d", year, month, day);
+ return String.format(Locale.ENGLISH, "%4d-%02d-%02d", year, month+1, day);
}
public static void addAlarm(final Application application, final long time, final long eventId) throws SQLException{
public static void deleteAlarm(final Application application, final long time) throws SQLException{
final SQLiteDatabase db = application.alarmOpenHelper.getWritableDatabase();
- db.delete(AlarmOpenHelper.TABLE, AlarmOpenHelper.TIME + " = " + time, new String[]{});
+ db.delete(AlarmOpenHelper.TABLE, AlarmOpenHelper.TIME + " = " + time, new String[0]);
unsetAlarm(application, time);
}
+ public static Long[] getAlarmsByEvent(final Application application, final long eventId) throws SQLException{
+ final SQLiteDatabase db = application.alarmOpenHelper.getWritableDatabase();
+ db.delete(AlarmOpenHelper.TABLE, AlarmOpenHelper.TIME + " < " + System.currentTimeMillis(), new String[0]);
+ final Cursor cursor = db.query(AlarmOpenHelper.TABLE, new String[]{AlarmOpenHelper.TIME}, AlarmOpenHelper.EVENT + " = " + eventId, new String[0], null, null, null);
+ if(cursor.moveToFirst()){
+ final Long[] ret = new Long[cursor.getCount()];
+ for(int i=0;i<ret.length;i++){
+ ret[i]=cursor.getLong(0);
+ cursor.moveToNext();
+ }
+ return ret;
+ }
+ return new Long[0];
+ }
+
public static void setAlarm(final Context context, final long time, final long eventId){
final Intent intent = new Intent(context, AlarmReceiverActivity.class);
intent.setAction(Long.toString(time));