/*  Copyright (C) 2019-2024 Carsten Pfeiffer, Daniel Dakhno

    This file is part of Gadgetbridge.

    Gadgetbridge is free software: you can redistribute it and/or modify
    it under the terms of the GNU Affero General Public License as published
    by the Free Software Foundation, either version 3 of the License, or
    (at your option) any later version.

    Gadgetbridge is distributed in the hope that it will be useful,
    but WITHOUT ANY WARRANTY; without even the implied warranty of
    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
    GNU Affero General Public License for more details.

    You should have received a copy of the GNU Affero General Public License
    along with this program.  If not, see <https://www.gnu.org/licenses/>. */
package nodomain.freeyourgadget.gadgetbridge.devices.qhybrid;

import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.util.Log;

import java.util.ArrayList;

import nodomain.freeyourgadget.gadgetbridge.GBApplication;
import nodomain.freeyourgadget.gadgetbridge.database.DBHandler;
import nodomain.freeyourgadget.gadgetbridge.service.devices.qhybrid.requests.misfit.PlayNotificationRequest;
import nodomain.freeyourgadget.gadgetbridge.util.GB;

public class PackageConfigHelper {
    public static final String DB_NAME = "qhybridNotifications.db";
    public static final String DB_ID = "id";
    public static final String DB_TABLE = "notifications";
    public static final String DB_PACKAGE = "package";
    public static final String DB_APPNAME = "appName";
    public static final String DB_VIBRATION = "vibrationTtype";
    public static final String DB_MINUTE = "minDegress";
    public static final String DB_HOUR = "hourDegrees";
    public static final String DB_RESPECT_SILENT = "respectSilent";


    public PackageConfigHelper(Context context) {
        try {
            initDB();
        } catch (Exception e) {
            GB.log("error getting database", GB.ERROR, e);
        }
    }

    public void saveNotificationConfiguration(NotificationConfiguration settings) throws Exception {
        ContentValues values = new ContentValues(6);
        values.put(DB_PACKAGE, settings.getPackageName());
        values.put(DB_APPNAME, settings.getAppName());
        values.put(DB_HOUR, settings.getHour());
        values.put(DB_MINUTE, settings.getMin());
        values.put(DB_VIBRATION, settings.getVibration().getValue());
        values.put(DB_RESPECT_SILENT, settings.getRespectSilentMode());

        try (DBHandler db = GBApplication.acquireDB()) {
            SQLiteDatabase database = db.getDatabase();

            if (settings.getId() == -1) {
                settings.setId(database.insert(DB_TABLE, null, values));
            } else {
                database.update(DB_TABLE, values, DB_ID + "=?", new String[]{String.valueOf(settings.getId())});
            }
        }
        //LocalBroadcastManager.getInstance(this).sendBroadcast(new Intent());
    }

    public ArrayList<NotificationConfiguration> getNotificationConfigurations() throws Exception {
        try (DBHandler db = GBApplication.acquireDB()) {
            SQLiteDatabase database = db.getDatabase();

            try (Cursor cursor = database.query(DB_TABLE, new String[]{"*"}, null, null, null, null, null)) {
                int size = cursor.getCount();
                ArrayList<NotificationConfiguration> list = new ArrayList<>(size);
                if (size > 0) {
                    int appNamePos = cursor.getColumnIndex(DB_APPNAME);
                    int packageNamePos = cursor.getColumnIndex(DB_PACKAGE);
                    int hourPos = cursor.getColumnIndex(DB_HOUR);
                    int minPos = cursor.getColumnIndex(DB_MINUTE);
                    int silentPos = cursor.getColumnIndex(DB_RESPECT_SILENT);
                    int vibrationPos = cursor.getColumnIndex(DB_VIBRATION);
                    int idPos = cursor.getColumnIndex(DB_ID);
                    cursor.moveToFirst();
                    do {
                        list.add(new NotificationConfiguration(
                                (short) cursor.getInt(minPos),
                                (short) cursor.getInt(hourPos),
                                cursor.getString(packageNamePos),
                                cursor.getString(appNamePos),
                                cursor.getInt(silentPos) == 1,
                                PlayNotificationRequest.VibrationType.fromValue((byte) cursor.getInt(vibrationPos)),
                                cursor.getInt(idPos)
                        ));
                        Log.d("Settings", "setting #" + cursor.getPosition() + ": " + cursor.getInt(silentPos));
                    } while (cursor.moveToNext());
                }
                return list;
            }
        }
    }

    public NotificationConfiguration getNotificationConfiguration(String appName) throws Exception {
        if(appName == null) return null;

        try (DBHandler db = GBApplication.acquireDB()) {
            SQLiteDatabase database = db.getDatabase();

            try (Cursor c = database.query(DB_TABLE, new String[]{"*"}, DB_APPNAME + "=?", new String[]{appName}, null, null, null)) {
                if (c.getCount() == 0) {
                    return null;
                }
                c.moveToFirst();
                NotificationConfiguration settings = new NotificationConfiguration(
                        (short) c.getInt(c.getColumnIndex(DB_MINUTE)),
                        (short) c.getInt(c.getColumnIndex(DB_HOUR)),
                        c.getString(c.getColumnIndex(DB_PACKAGE)),
                        c.getString(c.getColumnIndex(DB_APPNAME)),
                        c.getInt(c.getColumnIndex(DB_RESPECT_SILENT)) == 1,
                        PlayNotificationRequest.VibrationType.fromValue((byte) c.getInt(c.getColumnIndex(DB_VIBRATION))),
                        c.getInt(c.getColumnIndex(DB_ID))
                );
                return settings;
            }
        }
    }

    private void initDB() throws Exception {
        try (DBHandler db = GBApplication.acquireDB()) {
            SQLiteDatabase database = db.getDatabase();

            database.execSQL("CREATE TABLE IF NOT EXISTS notifications(" +
                    DB_ID + " INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, " +
                    DB_PACKAGE + " TEXT, " +
                    DB_VIBRATION + " INTEGER, " +
                    DB_MINUTE + " INTEGER DEFAULT -1, " +
                    DB_APPNAME + " TEXT," +
                    DB_RESPECT_SILENT + " INTEGER," +
                    DB_HOUR + " INTEGER DEFAULT -1);");
        }
    }

    public void deleteNotificationConfiguration(NotificationConfiguration packageSettings) throws Exception {
        Log.d("DB", "deleting id " + packageSettings.getId());
        if(packageSettings.getId() == -1) return;

        try (DBHandler db = GBApplication.acquireDB()) {
            SQLiteDatabase database = db.getDatabase();
            database.delete(DB_TABLE, DB_ID + "=?", new String[]{String.valueOf(packageSettings.getId())});
        }
    }
}