package com.basic.security.manager;

import android.database.Cursor;

import com.basic.security.dao.DatabaseManager;
import com.basic.security.dao.SqliteManager;

import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import java.util.Map;

public class AlarmManager extends SqliteManager {

    public static List<Map<String, String>> sqliteAlarmList = new ArrayList<>();
    public static SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");

    public static Map<String, String> findById(String id) {
        Cursor cursor = null;
        try {
            cursor = DatabaseManager.getDatabase().rawQuery("select * from alarm where id = '" + id + "'", null);
            if (cursor.moveToFirst()) {
                return cursorToModelAdapter(cursor, "alarm");
            }
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            if (cursor != null)
                cursor.close();
        }
        return null;
    }

    public static void renameKeys(List<Map<String, String>> listApiModel) {
        for (Map<String, String> apiModel : listApiModel) {
            for (Map.Entry<String, String> entry : apiModel.entrySet()) {
                String value = entry.getValue();
                if (value != null) {
                    if (value.startsWith("\"")) {
                        value = value.substring(1);
                    }
                    if (value.endsWith("\"")) {
                        value = value.substring(0, value.length() - 1);
                    }
                    apiModel.put(entry.getKey(), value);
                }
            }
        }
        for (Map<String, String> apiModel : listApiModel) {
            apiModel.put("table", "alarm");
            apiModel.put("alarmTime", apiModel.get("picDate"));
            apiModel.put("alarmPerson", "");

            String sdkType = apiModel.get("sdkType");
            if (sdkType != null) {
                apiModel.put("alarmType", apiModel.remove("sdkType"));
                if (sdkType.equals("人脸")) {
                    apiModel.put("property", apiModel.get("gender") + " " + apiModel.get("ageDescription") + " " + apiModel.get("race"));
                    apiModel.put("alarmPerson",
                            apiModel.remove("tableName")+" "+               apiModel.remove("idcard"));
                }
            }
            apiModel.put("alarmVideo", apiModel.get("videoNum"));
            String picDate = apiModel.get("picDate");
            if (picDate != null) {
                apiModel.put("alarmPicture", apiModel.remove("picDate"));
            }
            apiModel.put("alarmPicture",
                    apiModel.get("picSmUrl")
            );
            apiModel.put("alarmLargePicture",
                    apiModel.get("picMaxUrl")
            );
            String picAddress = apiModel.get("picAddress");
            if (picAddress != null) {
                apiModel.put("alarmAddress", apiModel.remove("picAddress"));
            }
        }
    }

    public static List<Map<String, String>> findAlarmList() {
        List<Map<String, String>> dbSqliteAlarmList = findList("select * from alarm where 1=1 and closeAlarm='false' order by alarmTime desc ");
        int maxAlarm = 1000;
        sqliteAlarmList.clear();
        if (dbSqliteAlarmList.size() > maxAlarm) {
            for (int i = 0; i < dbSqliteAlarmList.size(); i++) {
                if (i < maxAlarm) {
                    sqliteAlarmList.add(dbSqliteAlarmList.get(i));
                } else {
                    try {
                        DatabaseManager.execSQL("delete from alarm where id='" + dbSqliteAlarmList.get(i).get("id") + "'");
                    } catch (Exception e) {
                        e.printStackTrace();
                    }
                }

            }
        } else {
            sqliteAlarmList.addAll(dbSqliteAlarmList);
        }
        for (Map<String, String> alarm : sqliteAlarmList) {
            String alarmVideo = alarm.get("alarmVideo");
            String alarmPicture = alarm.get("alarmPicture");
            String alarmLargePicture = alarm.get("alarmLargePicture");

            if (alarmVideo != null && alarmVideo.startsWith("http:")) {
                alarm.put("alarmVideoValid", "true");
            } else {
                alarm.put("alarmVideoValid", "false");
            }
            if (alarmPicture != null && alarmPicture.startsWith("http:")) {
                alarm.put("alarmPictureValid", "true");
            } else {
                alarm.put("alarmPictureValid", "false");
            }
            if (alarmLargePicture != null && alarmLargePicture.startsWith("http:")) {
                alarm.put("alarmLargePictureValid", "true");
            } else {
                alarm.put("alarmLargePictureValid", "false");
            }
        }
        return sqliteAlarmList;
    }

    public static int saveRemoteAlarmListToSqlite(List<Map<String, String>> newRemoteAlarmList) {
        int savedCount = 0;
        for (Map<String, String> newRemoteAlarm : newRemoteAlarmList) {
            if (findById(newRemoteAlarm.get("id")) == null) {
                newRemoteAlarm.put("table", "alarm");
                newRemoteAlarm.put("closeAlarm", "false");
                newRemoteAlarm.put("mute", "false");
                newRemoteAlarm.put("createTime", new Date().getTime()+"");
                save(newRemoteAlarm);
                savedCount++;
            }
        }
        return savedCount;
    }

    public static void deleteAlarm(Map<String, String> alarm) {
        try {
            DatabaseManager.execSQL("delete from alarm where id='" + alarm.get("id") + "'");
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}