use std::time::{Duration, UNIX_EPOCH};
use json::{JsonValue, object};
use crate::Field;
use chrono::{DateTime, FixedOffset, Local, NaiveDate, NaiveDateTime};

pub struct Year {
    pub require: bool,
    pub field: String,
    pub mode: String,
    pub title: String,
    pub def: String,
    pub show: bool,
    pub describe: String,
}

impl Year {
    pub fn new(require: bool, field: &str, title: &str, default: &str) -> Self {
        Self {
            field: field.to_string(),
            mode: "year".to_string(),
            title: title.to_string(),
            def: default.to_string(),
            require,
            show: true,
            describe: String::new(),
        }
    }
    pub fn year() -> String {
        let now: DateTime<Local> = Local::now();
        let dft = now.format("%Y");
        dft.to_string()
    }
    pub fn timestamp_to_year(timestamp: i64) -> String {
        let d = UNIX_EPOCH + Duration::from_secs(timestamp as u64);
        let datetime = DateTime::<Local>::from(d);
        let timestamp_str = datetime.format("%Y").to_string();
        timestamp_str
    }
}

impl Field for Year {
    fn sql(&mut self, model: &str) -> String {
        let mut sql = format!("`{}`", self.field);
        sql = format!("{} year", sql.clone());
        if self.require {
            sql = format!("{} ", sql.clone())
        } else {
            sql = format!("{}  default '{}'", sql.clone(), self.def);
        }
        match model {
            "sqlite" => sql,
            _ => format!("{} comment '{}|{}|{}|{}'", sql.clone(), self.title, self.mode, self.require, self.def)
        }
    }

    fn hide(&mut self) -> &mut Self {
        self.show = false;
        self
    }


    fn describe(&mut self, text: &str) -> &mut Self {
        self.describe = text.to_string();
        self
    }

    fn field(&mut self) -> JsonValue {
        let mut field = object! {};
        field.insert("require", JsonValue::from(self.require.clone())).unwrap();
        field.insert("field", JsonValue::from(self.field.clone())).unwrap();
        field.insert("mode", JsonValue::from(self.mode.clone())).unwrap();
        field.insert("title", JsonValue::from(self.title.clone())).unwrap();
        field.insert("def", JsonValue::from(self.def.clone())).unwrap();
        field.insert("show", JsonValue::from(self.show.clone())).unwrap();
        field.insert("describe", JsonValue::from(self.describe.clone())).unwrap();
        field
    }
}


pub struct Datetime {
    pub require: bool,
    pub field: String,
    pub mode: String,
    pub title: String,
    pub def: String,
    pub show: bool,
    pub describe: String,
}

impl Datetime {
    pub fn new(require: bool, field: &str, title: &str, mut default: &str) -> Self {
        if default == "" {
            default = "0000-01-01 00:00:00";
        }
        Self {
            field: field.to_string(),
            mode: "datetime".to_string(),
            title: title.to_string(),
            def: default.to_string(),
            require,
            show: true,
            describe: String::new(),
        }
    }
    pub fn datetime() -> String {
        let now: DateTime<Local> = Local::now();
        let dft = now.format("%Y-%m-%d %H:%M:%S");
        dft.to_string()
    }
    pub fn timestamp_to_datetime(timestamp: i64) -> String {
        let d = UNIX_EPOCH + Duration::from_secs(timestamp as u64);
        let datetime = DateTime::<Local>::from(d);
        let timestamp_str = datetime.format("%Y-%m-%d %H:%M:%S").to_string();
        timestamp_str
    }
    pub fn datetime_format(format: &str) -> String {
        let now: DateTime<Local> = Local::now();
        let dft = now.format(format);
        dft.to_string()
    }
}

impl Field for Datetime {
    fn sql(&mut self, model: &str) -> String {
        let sql = format!("`{}` datetime  default '{}'", self.field, self.def.clone());
        match model {
            "sqlite" => sql,
            _ => format!("{} comment '{}|{}|{}|{}'", sql.clone(), self.title, self.mode, self.require, self.def)
        }
    }
    fn hide(&mut self) -> &mut Self {
        self.show = false;
        self
    }


    fn describe(&mut self, text: &str) -> &mut Self {
        self.describe = text.to_string();
        self
    }

    fn field(&mut self) -> JsonValue {
        let mut field = object! {};
        field.insert("require", JsonValue::from(self.require.clone())).unwrap();
        field.insert("field", JsonValue::from(self.field.clone())).unwrap();
        field.insert("mode", JsonValue::from(self.mode.clone())).unwrap();
        field.insert("title", JsonValue::from(self.title.clone())).unwrap();
        field.insert("def", JsonValue::from(self.def.clone())).unwrap();

        field.insert("show", JsonValue::from(self.show.clone())).unwrap();
        field.insert("describe", JsonValue::from(self.describe.clone())).unwrap();
        field
    }
}


pub struct Time {
    pub require: bool,
    pub field: String,
    pub mode: String,
    pub title: String,
    pub def: String,
    pub show: bool,
    pub describe: String,
}

impl Time {
    pub fn new(require: bool, field: &str, title: &str, default: &str) -> Self {
        Self {
            field: field.to_string(),
            mode: "time".to_string(),
            title: title.to_string(),
            def: default.to_string(),
            require,
            show: true,
            describe: String::new(),
        }
    }
    pub fn time() -> String {
        let now: DateTime<Local> = Local::now();
        let dft = now.format("%H:%M:%S");
        dft.to_string()
    }
}

impl Field for Time {
    fn sql(&mut self, model: &str) -> String {
        let sql = format!("`{}` time  default '{}'", self.field, self.def);
        match model {
            "sqlite" => sql,
            _ => format!("{} comment '{}|{}|{}|{}'", sql.clone(), self.title, self.mode, self.require, self.def)
        }
    }

    fn hide(&mut self) -> &mut Self {
        self.show = false;
        self
    }

    fn describe(&mut self, text: &str) -> &mut Self {
        self.describe = text.to_string();
        self
    }

    fn field(&mut self) -> JsonValue {
        let mut field = object! {};
        field.insert("require", JsonValue::from(self.require.clone())).unwrap();
        field.insert("field", JsonValue::from(self.field.clone())).unwrap();
        field.insert("mode", JsonValue::from(self.mode.clone())).unwrap();
        field.insert("title", JsonValue::from(self.title.clone())).unwrap();
        field.insert("def", JsonValue::from(self.def.clone())).unwrap();

        field.insert("show", JsonValue::from(self.show.clone())).unwrap();
        field.insert("describe", JsonValue::from(self.describe.clone())).unwrap();
        field
    }
}


pub struct Date {
    pub require: bool,
    pub field: String,
    pub mode: String,
    pub title: String,
    pub def: String,
    pub show: bool,
    pub describe: String,
}

impl Date {
    pub fn new(require: bool, field: &str, title: &str, default: &str) -> Self {
        let def = {
            if default == "" {
                "0000-01-01"
            } else {
                default
            }
        };
        Self {
            field: field.to_string(),
            mode: "date".to_string(),
            title: title.to_string(),
            def: def.parse().unwrap(),
            require,
            show: true,
            describe: "".to_string(),
        }
    }
    /// 默认值 2023-01-01
    pub fn date() -> String {
        let now: DateTime<Local> = Local::now();
        let dft = now.format("%Y-%m-%d");
        dft.to_string()
    }
    pub fn timestamp_to_date(timestamp: i64) -> String {
        let d = UNIX_EPOCH + Duration::from_secs(timestamp as u64);
        let datetime = DateTime::<Local>::from(d);
        let timestamp_str = datetime.format("%Y-%m-%d").to_string();
        timestamp_str
    }
}

impl Field for Date {
    fn sql(&mut self, model: &str) -> String {
        let sql = format!("`{}` date  default '{}'", self.field, self.def);
        match model {
            "sqlite" => sql,
            _ => format!("{} comment '{}|{}|{}|{}'", sql.clone(), self.title, self.mode, self.require, self.def)
        }
    }

    fn hide(&mut self) -> &mut Self {
        self.show = false;
        self
    }


    fn describe(&mut self, text: &str) -> &mut Self {
        self.describe = text.to_string();
        self
    }
    fn field(&mut self) -> JsonValue {
        let mut field = object! {};
        field.insert("require", JsonValue::from(self.require.clone())).unwrap();
        field.insert("field", JsonValue::from(self.field.clone())).unwrap();
        field.insert("mode", JsonValue::from(self.mode.clone())).unwrap();
        field.insert("title", JsonValue::from(self.title.clone())).unwrap();
        field.insert("def", JsonValue::from(self.def.clone())).unwrap();

        field.insert("show", JsonValue::from(self.show.clone())).unwrap();
        field.insert("describe", JsonValue::from(self.describe.clone())).unwrap();
        field
    }
}


pub struct Timestamp {
    pub require: bool,
    pub field: String,
    pub mode: String,
    pub title: String,
    pub def: f64,
    pub dec: i32,
    pub show: bool,
    pub describe: String,
}

impl Timestamp {
    pub fn new(require: bool, field: &str, title: &str, dec: i32, default: f64) -> Self {
        Self {
            require,
            field: field.to_string(),
            mode: "timestamp".to_string(),
            title: title.to_string(),
            def: default,
            dec,
            show: true,
            describe: "".to_string(),
        }
    }
    /// 默认值 秒 10位
    pub fn timestamp() -> i64 {
        return Local::now().timestamp();
    }
    /// 毫秒 13位
    pub fn timestamp_ms() -> i64 {
        return Local::now().timestamp_millis();
    }
    /// 毫秒 10位+3位
    pub fn timestamp_ms_f64() -> f64 {
        return Local::now().timestamp_millis() as f64 / 1000.0;
    }
    /// 微秒 16位
    pub fn timestamp_μs() -> i64 {
        return Local::now().timestamp_micros();
    }
    /// 微秒 16位
    pub fn timestamp_μs_f64() -> f64 {
        return Local::now().timestamp_micros() as f64 / 1000.0 / 1000.0;
    }
    /// 纳秒 19位
    pub fn timestamp_ns() -> i64 {
        return Local::now().timestamp_nanos_opt().unwrap();
    }

    /// 日期转时间戳
    pub fn date_to_timestamp(date: &str) -> i64 {
        let t = NaiveDate::parse_from_str(date, "%Y-%m-%d").unwrap();
        let tz = FixedOffset::east_opt(Local::now().offset().local_minus_utc()).unwrap();
        return t.and_hms_opt(0, 0, 0).unwrap().and_local_timezone(tz).unwrap().timestamp();
    }
    /// 日期时间转时间戳
    pub fn datetime_to_timestamp(datetime: &str) -> i64 {
        let t = NaiveDateTime::parse_from_str(datetime, "%Y-%m-%d %H:%M:%S").unwrap();
        let tz = FixedOffset::east_opt(Local::now().offset().local_minus_utc()).unwrap();
        return t.and_local_timezone(tz).unwrap().timestamp();
    }
    /// 日期时间转rfc2822 Thu, 3 Jul 2014 17:43:58 +0000
    pub fn datetime_to_rfc2822(datetime: &str) -> String {
        let t = NaiveDateTime::parse_from_str(datetime, "%Y-%m-%d %H:%M:%S").unwrap();
        let tz = FixedOffset::east_opt(Local::now().offset().local_minus_utc()).unwrap();
        return t.and_local_timezone(tz).unwrap().to_rfc2822();
    }
    pub fn datetime_utc_rfc2822(datetime: &str) -> String {
        let t = NaiveDateTime::parse_from_str(datetime, "%Y-%m-%d %H:%M:%S").unwrap();
        return t.and_utc().to_rfc2822();
    }
    pub fn datetime_to_fmt(datetime: &str, fmt: &str) -> String {
        let t = NaiveDateTime::parse_from_str(datetime, "%Y-%m-%d %H:%M:%S").unwrap();
        let tz = FixedOffset::east_opt(Local::now().offset().local_minus_utc()).unwrap();
        return t.and_local_timezone(tz).unwrap().format(fmt).to_string();
    }
}

impl Field for Timestamp {
    fn sql(&mut self, model: &str) -> String {
        let max = 10 + self.dec;
        match model {
            "sqlite" => {
                let mut sql = format!("`{}` float({},{}) ", self.field, max, self.dec);
                self.def = format!("{0:.width$}", self.def, width = self.dec as usize).parse::<f64>().unwrap();
                sql = format!("{} default {}", sql.clone(), self.def);
                sql
            }
            _ => {
                let mut sql = format!("`{}` decimal({},{}) ", self.field, max, self.dec);
                let def = format!("{0:.width$}", self.def, width = self.dec as usize);
                self.def = def.parse::<f64>().unwrap();
                sql = format!("{} default {}", sql.clone(), self.def);
                format!("{} comment '{}|{}|{}|{}|{}'", sql.clone(), self.title, self.mode, self.require, self.dec, self.def)
            }
        }
    }

    fn hide(&mut self) -> &mut Self {
        self.show = false;
        self
    }


    fn describe(&mut self, text: &str) -> &mut Self {
        self.describe = text.to_string();
        self
    }

    fn field(&mut self) -> JsonValue {
        let mut field = object! {};
        field.insert("require", JsonValue::from(self.require.clone())).unwrap();
        field.insert("field", JsonValue::from(self.field.clone())).unwrap();
        field.insert("mode", JsonValue::from(self.mode.clone())).unwrap();
        field.insert("title", JsonValue::from(self.title.clone())).unwrap();
        field.insert("def", JsonValue::from(self.def.clone())).unwrap();
        field.insert("dec", JsonValue::from(self.dec.clone())).unwrap();
        field.insert("show", JsonValue::from(self.show.clone())).unwrap();
        field.insert("describe", JsonValue::from(self.describe.clone())).unwrap();
        field
    }
}