5 files changed, 507 insertions, 0 deletions
diff --git a/src/org/ryuslash/Dailies/AddActivity.java b/src/org/ryuslash/Dailies/AddActivity.java
new file mode 100644
index 0000000..4ede5fc
--- /dev/null
+++ b/src/org/ryuslash/Dailies/AddActivity.java
@@ -0,0 +1,106 @@
+package org.ryuslash.Dailies;
+
+import android.app.Activity;
+import android.content.Intent;
+import android.os.Bundle;
+import android.view.Menu;
+import android.view.MenuInflater;
+import android.view.MenuItem;
+import android.widget.CheckBox;
+import android.widget.EditText;
+import android.widget.TimePicker;
+
+public class AddActivity extends Activity
+{
+    private DailiesDataSource datasource;
+    private long id;
+
+    public void saveDaily()
+    {
+        EditText name_entry = (EditText) findViewById(R.id.name_entry);
+        CheckBox alarm_entry =
+            (CheckBox) findViewById(R.id.alarm_entry);
+        TimePicker time_entry =
+            (TimePicker) findViewById(R.id.time_entry);
+
+        String name = name_entry.getText().toString();
+        boolean alarm = alarm_entry.isChecked();
+        int hour = alarm ? time_entry.getCurrentHour() : 0;
+        int minute = alarm ? time_entry.getCurrentMinute() : 0;
+
+        if (id > 0)
+            datasource.updateDaily(id, name, alarm, hour, minute, null);
+        else
+            datasource.createDaily(name, alarm, hour, minute);
+    }
+
+    @Override
+    public void onCreate(Bundle savedInstanceState)
+    {
+        super.onCreate(savedInstanceState);
+        setContentView(R.layout.add);
+
+        datasource = new DailiesDataSource(this);
+        datasource.open();
+
+        Intent intent = getIntent();
+        id = intent.getLongExtra(SQLiteHelper.COLUMN_ID, 0l);
+
+        if (id > 0) {
+            Daily daily = datasource.getById(id);
+            EditText name_entry =
+                (EditText) findViewById(R.id.name_entry);
+            CheckBox alarm_entry =
+                (CheckBox) findViewById(R.id.alarm_entry);
+            TimePicker time_entry =
+                (TimePicker) findViewById(R.id.alarm_entry);
+
+            name_entry.setText(daily.getTitle());
+            alarm_entry.setChecked(daily.getAlarm());
+            time_entry.setCurrentHour(daily.getHour());
+            time_entry.setCurrentMinute(daily.getMinute());
+        }
+    }
+
+    @Override
+    public boolean onCreateOptionsMenu(Menu menu)
+    {
+        MenuInflater inflater = getMenuInflater();
+        inflater.inflate(R.menu.add_activity, menu);
+        return true;
+    }
+
+    @Override
+    protected void onDestroy()
+    {
+        datasource.close();
+        super.onDestroy();
+    }
+
+    @Override
+    public boolean onOptionsItemSelected(MenuItem item)
+    {
+        switch (item.getItemId()) {
+        case R.id.add_menu_save:
+            saveDaily();
+            finish();
+            return true;
+        }
+
+        return false;
+    }
+
+    @Override
+    protected void onPause()
+    {
+        datasource.close();
+        super.onPause();
+    }
+
+    @Override
+    protected void onResume()
+    {
+        datasource.open();
+        super.onResume();
+    }
+}
diff --git a/src/org/ryuslash/Dailies/DailiesActivity.java b/src/org/ryuslash/Dailies/DailiesActivity.java
new file mode 100644
index 0000000..91a6353
--- /dev/null
+++ b/src/org/ryuslash/Dailies/DailiesActivity.java
@@ -0,0 +1,91 @@
+package org.ryuslash.Dailies;
+
+import java.util.List;
+
+import android.app.ListActivity;
+import android.content.Intent;
+import android.os.Bundle;
+import android.view.Menu;
+import android.view.MenuInflater;
+import android.view.MenuItem;
+import android.widget.ArrayAdapter;
+
+public class DailiesActivity extends ListActivity
+{
+    private DailiesDataSource datasource;
+
+    private List<Daily> getData()
+    {
+        return datasource.getDailiesList();
+    }
+
+    @Override
+    protected void onActivityResult(int requestCode,
+                                    int resultCode,
+                                    Intent data)
+    {
+        super.onActivityResult(requestCode, resultCode, data);
+        datasource.open();
+    }
+
+    /** Called when the activity is first created. */
+    @Override
+    public void onCreate(Bundle savedInstanceState)
+    {
+        super.onCreate(savedInstanceState);
+        setContentView(R.layout.main);
+
+        datasource = new DailiesDataSource(this);
+        datasource.open();
+
+        List<Daily> dailies = getData();
+
+        ArrayAdapter<Daily> adapter = new ArrayAdapter<Daily>(
+            this, android.R.layout.simple_list_item_1, dailies
+        );
+        setListAdapter(adapter);
+    }
+
+    @Override
+    public boolean onCreateOptionsMenu(Menu menu)
+    {
+        MenuInflater inflater = getMenuInflater();
+        inflater.inflate(R.menu.main_activity, menu);
+
+        return true;
+    }
+
+    @Override
+    public boolean onOptionsItemSelected(MenuItem item)
+    {
+        switch (item.getItemId()) {
+        case R.id.main_menu_add:
+            showAdd();
+            return true;
+        }
+
+        return false;
+    }
+
+    @Override
+    public void onPause()
+    {
+        datasource.close();
+        super.onPause();
+    }
+
+    @Override
+    protected void onResume()
+    {
+        datasource.open();
+        super.onResume();
+    }
+
+    public void showAdd()
+    {
+        Intent intent = new Intent(this, AddActivity.class);
+
+        datasource.close();
+        startActivityForResult(intent, 0);
+    }
+}
diff --git a/src/org/ryuslash/Dailies/DailiesDataSource.java b/src/org/ryuslash/Dailies/DailiesDataSource.java
new file mode 100644
index 0000000..d679f5f
--- /dev/null
+++ b/src/org/ryuslash/Dailies/DailiesDataSource.java
@@ -0,0 +1,152 @@
+package org.ryuslash.Dailies;
+
+import java.text.DateFormat;
+import java.util.ArrayList;
+import java.util.Date;
+import java.util.List;
+
+import android.content.ContentValues;
+import android.content.Context;
+import android.database.Cursor;
+import android.database.SQLException;
+import android.database.sqlite.SQLiteDatabase;
+
+public class DailiesDataSource
+{
+    private SQLiteDatabase database;
+    private SQLiteHelper dbHelper;
+    private String[] allColumns = { SQLiteHelper.COLUMN_ID,
+                                    SQLiteHelper.COLUMN_TITLE,
+                                    SQLiteHelper.COLUMN_ALARM,
+                                    SQLiteHelper.COLUMN_HOUR,
+                                    SQLiteHelper.COLUMN_MINUTE,
+                                    SQLiteHelper.COLUMN_LAST_COMPLETED };
+
+    public DailiesDataSource(Context context)
+    {
+        dbHelper = new SQLiteHelper(context);
+    }
+
+    public void open() throws SQLException
+    {
+        database = dbHelper.getWritableDatabase();
+    }
+
+    public void close()
+    {
+        dbHelper.close();
+    }
+
+    private String dateToString(Date date)
+    {
+        DateFormat df = DateFormat.getDateInstance();
+        return df.format(date);
+    }
+
+    private ContentValues createValues(String title, boolean alarm,
+                                       int hour, int minute, Date date)
+    {
+        ContentValues values = new ContentValues();
+
+
+        values.put(SQLiteHelper.COLUMN_TITLE, title);
+        values.put(SQLiteHelper.COLUMN_ALARM, alarm ? 1 : 0);
+        values.put(SQLiteHelper.COLUMN_HOUR, hour);
+        values.put(SQLiteHelper.COLUMN_MINUTE, minute);
+
+        if (date != null)
+            values.put(SQLiteHelper.COLUMN_LAST_COMPLETED,
+                       dateToString(date));
+
+        return values;
+    }
+
+    private ContentValues createValues(String title, boolean alarm,
+                                       int  hour, int minute)
+    {
+        return createValues(title, alarm, hour, minute, null);
+    }
+
+    public Daily createDaily(String title, boolean alarm, int hour,
+                             int minute)
+    {
+        ContentValues values = createValues(title, alarm, hour, minute);
+        long insertId = database.insert(SQLiteHelper.TABLE_DAILY, null,
+                                        values);
+        Daily daily = new Daily(insertId, title, alarm, hour, minute);
+
+        return daily;
+    }
+
+    public void updateDaily(long id, String title, boolean alarm,
+                            int hour, int minute, Date last_completed)
+    {
+        ContentValues values = createValues(title, alarm, hour, minute,
+                                            last_completed);
+        String whereArgs[] = { "" + id };
+
+        database.update(SQLiteHelper.TABLE_DAILY, values, "id = ?",
+                        whereArgs);
+    }
+
+    public void deleteDaily(Daily daily)
+    {
+        deleteDaily(daily.getId());
+    }
+
+    public void deleteDaily(long id)
+    {
+        database.delete(SQLiteHelper.TABLE_DAILY,
+                        SQLiteHelper.COLUMN_ID + " = " + id, null);
+    }
+
+    public List<Daily> getDailiesList()
+    {
+        List<Daily> dailies = new ArrayList<Daily>();
+        Cursor cursor = database.query(
+            SQLiteHelper.TABLE_DAILY, allColumns, null, null, null,
+            null, "last_completed DESC, hour, minute"
+        );
+
+        cursor.moveToFirst();
+
+        while(!cursor.isAfterLast()) {
+            Daily daily = cursorToDaily(cursor);
+
+            dailies.add(daily);
+            cursor.moveToNext();
+        }
+
+        cursor.close();
+
+        return dailies;
+    }
+
+    public Daily getById(long id)
+    {
+        Cursor cursor = database.query(SQLiteHelper.TABLE_DAILY,
+                                       allColumns,
+                                       SQLiteHelper.COLUMN_ID + " = ?",
+                                       new String[] { "" + id },
+                                       null, null, null);
+        cursor.moveToFirst();
+        Daily daily = cursorToDaily(cursor);
+        cursor.close();
+
+        return daily;
+    }
+
+    private Daily cursorToDaily(Cursor cursor)
+    {
+        Daily daily = new Daily();
+
+        daily.setId(cursor.getLong(0));
+        daily.setTitle(cursor.getString(1));
+        daily.setAlarm(cursor.getInt(2) == 1);
+        daily.setHour(cursor.getInt(3));
+        daily.setMinute(cursor.getInt(4));
+        daily.setLastCompleted(cursor.getString(5));
+
+        return daily;
+    }
+}
diff --git a/src/org/ryuslash/Dailies/Daily.java b/src/org/ryuslash/Dailies/Daily.java
new file mode 100644
index 0000000..e1bbdba
--- /dev/null
+++ b/src/org/ryuslash/Dailies/Daily.java
@@ -0,0 +1,107 @@
+package org.ryuslash.Dailies;
+
+import java.util.Date;
+import java.text.DateFormat;
+
+public class Daily
+{
+    private long id;
+    private String title;
+    private boolean alarm;
+    private int hour;
+    private int minute;
+    private Date last_completed;
+
+    public Daily() { }
+
+    public Daily(long id, String title, boolean alarm, int hour,
+                 int minute, Date last_completed)
+    {
+        this.id = id;
+        this.title = title;
+        this.alarm = alarm;
+        this.hour = hour;
+        this.minute = minute;
+        this.last_completed = last_completed;
+    }
+
+    public Daily(long id, String title, boolean alarm, int hour,
+                 int minute)
+    {
+        this(id, title, alarm, hour, minute, null);
+    }
+
+    public long getId()
+    {
+        return id;
+    }
+
+    public void setId(long id)
+    {
+        this.id = id;
+    }
+
+    public String getTitle()
+    {
+        return title;
+    }
+
+    public void setTitle(String title)
+    {
+        this.title = title;
+    }
+
+    public boolean getAlarm()
+    {
+        return alarm;
+    }
+
+    public void setAlarm(boolean alarm)
+    {
+        this.alarm = alarm;
+    }
+
+    public int getHour()
+    {
+        return hour;
+    }
+
+    public void setHour(int hour)
+    {
+        this.hour = hour;
+    }
+
+    public int getMinute()
+    {
+        return minute;
+    }
+
+    public void setMinute(int minute)
+    {
+        this.minute = minute;
+    }
+
+    public Date getLastCompleted()
+    {
+        return last_completed;
+    }
+
+    public void setLastCompleted(Date last_completed)
+    {
+        this.last_completed = last_completed;
+    }
+
+    public void setLastCompleted(String last_completed)
+    {
+        if (last_completed != null && !last_completed.isEmpty()) {
+            DateFormat df = DateFormat.getDateInstance();
+            setLastCompleted(df.format(last_completed));
+        }
+    }
+
+    @Override
+    public String toString()
+    {
+        return String.format("%02d:%02d %s", hour, minute, title);
+    }
+}
diff --git a/src/org/ryuslash/Dailies/SQLiteHelper.java b/src/org/ryuslash/Dailies/SQLiteHelper.java
new file mode 100644
index 0000000..0934f4e
--- /dev/null
+++ b/src/org/ryuslash/Dailies/SQLiteHelper.java
@@ -0,0 +1,51 @@
+package org.ryuslash.Dailies;
+
+import android.content.Context;
+import android.database.sqlite.SQLiteDatabase;
+import android.database.sqlite.SQLiteOpenHelper;
+import android.util.Log;
+
+public class SQLiteHelper extends SQLiteOpenHelper
+{
+    public static final String TABLE_DAILY = "daily";
+    public static final String COLUMN_ID = "id";
+    public static final String COLUMN_TITLE = "title";
+    public static final String COLUMN_ALARM = "alarm";
+    public static final String COLUMN_HOUR = "hour";
+    public static final String COLUMN_MINUTE = "minute";
+    public static final String COLUMN_LAST_COMPLETED = "last_completed";
+
+    private static final String DATABASE_NAME = "dailies.db";
+    private static final int DATABASE_VERSION = 1;
+
+    private static final String TABLE_DAILY_CREATE =
+        "CREATE TABLE " + TABLE_DAILY + " ("
+        + COLUMN_ID + " INTEGER PRIMARY KEY AUTOINCREMENT, "
+        + COLUMN_TITLE + " TEXT NOT NULL, "
+        + COLUMN_ALARM + " INTEGER NOT NULL, "
+        + COLUMN_HOUR + " INTEGER NULL, "
+        + COLUMN_MINUTE + " INTEGER NULL, "
+        + COLUMN_LAST_COMPLETED + " TEXT NULL "
+        + ");";
+
+    public SQLiteHelper(Context context)
+    {
+        super(context, DATABASE_NAME, null, DATABASE_VERSION);
+    }
+
+    @Override
+    public void onCreate(SQLiteDatabase database)
+    {
+        database.execSQL(TABLE_DAILY_CREATE);
+    }
+
+    @Override
+    public void onUpgrade(SQLiteDatabase db, int oldV, int newV)
+    {
+        Log.w(SQLiteHelper.class.getName(),
+              "Upgrading database from version " + oldV + " to "
+              + newV + ", which will destroy all old data");
+        db.execSQL("DROP TABLE IF EXISTS " + TABLE_DAILY);
+        onCreate(db);
+    }
+}