#!/usr/bin/env python
# -*- coding:utf-8 -*-
# @FileName  :data_nwp_ftp.py
# @Time      :2024/12/26 08:38
# @Author    :David
# @Company: shenyang JY
import requests, json
from datetime import timedelta
from ftplib import FTP
import threading, glob, pytz
import pandas as pd
from pytz import timezone
from flask import Flask,request,jsonify
import time, datetime, os, traceback, re
import zipfile, tempfile, shutil, fnmatch
from common.database_dml import insert_data_into_mongo
from apscheduler.schedulers.background import BackgroundScheduler
from apscheduler.triggers.cron import CronTrigger

from common.logs import Log
logger = Log('data-processing').logger

app = Flask('data_nwp_ftp——service')


def update_thread():
    thread = threading.Thread(target=start_jobs)
    thread.start()


def start_jobs():
    scheduler = BackgroundScheduler()
    scheduler.configure({'timezone': timezone("Asia/Shanghai")})
    trigger1 = CronTrigger(
        hour='0,1,2,4,5,6,11,12,13,16,17,18',  # 主触发小时
        minute='0-50/10',  # 每 10 分钟一次，覆盖 00:00-00:50
        timezone='Asia/Shanghai'  # 按需设置时区
    )

    scheduler.add_job(func=download_zip_files_from_ftp, trigger=trigger1)
    scheduler.start()

def match_date(date, filename):
    given_date = datetime.datetime.strptime(date, '%Y%m%d')
    date_pattern = re.compile(r'(\d{8})')
    match = date_pattern.search(filename)
    if match:
        filename_str = match.group(0)
        filename_date = datetime.datetime.strptime(filename_str, '%Y%m%d')
        if filename_date <= given_date:
            return True

def delete_zip_files(date):
    xxl_path = ftp_params['xxl']['local_dir']
    # 遍历文件夹中的所有文件
    for root, dirs, files in os.walk(xxl_path):
        for filename in files:
            # 检查文件名是否以 'meteo_date_' 开头且以 '.zip' 结尾
            if fnmatch.fnmatch(filename, f'*.zip') and match_date(date, filename):
                # 构建文件的完整路径
                file_path = os.path.join(xxl_path, filename)
                # 删除文件
                try:
                    os.remove(file_path)
                    print(f"Deleted file: {file_path}")
                except OSError as e:
                    print(f"Error deleting file {file_path}: {e.strerror}")
        for farmId in dirs:
            target_dir_path = os.path.join(root, farmId)
            for file_name in os.listdir(target_dir_path):
                csv_file_path = os.path.join(target_dir_path, file_name)
                if fnmatch.fnmatch(csv_file_path, f'*.csv') and match_date(date, file_name):
                    try:
                        os.remove(csv_file_path)
                        print(f"Deleted file: {csv_file_path}")
                    except OSError as e:
                        print(f"Error deleting file {csv_file_path}: {e.strerror}")

def get_moment_next(schedule_dt=None):
    if schedule_dt is not None:
        now = datetime.datetime.strptime(str(schedule_dt), '%Y-%m-%d %H:%M:%S')
    else:
        now = datetime.datetime.now(pytz.utc).astimezone(timezone("Asia/Shanghai"))
    date = now.strftime('%Y%m%d')
    if now.hour == 18:
        moment = '18'
    elif now.hour > 18:
        moment = '00'
    elif now.hour == 12:
        moment = '12'
    elif now.hour > 12:
        moment = '18'
    elif now.hour == 6:
        moment = '06'
    elif now.hour > 6:
        moment = '12'
    elif 2 >= now.hour >= 0:
        moment = '00'
    else:
        moment = '06'
    return date, moment

def get_previous_moment(original_date, original_moment):
    # 将原date和moment转换为上海时区的datetime对象
    tz_shanghai = timezone('Asia/Shanghai')
    original_dt = datetime.datetime.strptime(f"{original_date}{original_moment}", "%Y%m%d%H")
    original_dt = tz_shanghai.localize(original_dt)

    # 减去6小时
    new_dt = original_dt - datetime.timedelta(hours=6)

    # 转换为原方法可接受的schedule_dt字符串格式
    schedule_dt_str = new_dt.strftime('%Y-%m-%d %H:%M:%S')

    # 调用原方法获取新的date和moment
    new_date, new_moment = get_moment_next(schedule_dt=schedule_dt_str)

    return new_date, new_moment

def download_zip_files_from_ftp(moment=None):
    now = datetime.datetime.now(pytz.utc).astimezone(timezone("Asia/Shanghai"))
    date = now.strftime("%Y%m%d")
    date_2 = (now - timedelta(days=2)).strftime("%Y%m%d")
    if moment is None:
        date, moment = get_moment_next()
    host = 'xxl'
    ftp_host, ftp_user, ftp_password, remote_dir, local_dir = ftp_params[host]['host'], ftp_params[host]['user'], ftp_params[host]['password'], ftp_params[host]['remote_dir'], ftp_params['xxl']['local_dir']
    zip_extension = f'meteoforce_{date}{str(moment)}_*.zip'
    zip_file_path = []
    # 连接到FTP服务器
    with FTP(ftp_host) as ftp:
        ftp.login(user=ftp_user, passwd=ftp_password)

        # 切换到远程目录
        ftp.cwd(remote_dir)

        # 获取远程目录中的文件和目录列表
        files = ftp.nlst()

        # 遍历文件列表，找到ZIP文件并下载
        for file_name in files:
            if fnmatch.fnmatch(file_name, zip_extension):
                start = time.time()
                remote_file_path = os.path.join(remote_dir, file_name)
                local_file_path = os.path.join(local_dir, file_name)

                if os.path.isfile(local_file_path):
                    continue

                with open(local_file_path, 'wb') as local_file:
                    logger.info(f"Downloading {remote_file_path} to {local_file_path}")
                    ftp.retrbinary(f'RETR {remote_file_path}', local_file.write)
                end = time.time()
                now = datetime.datetime.now(pytz.utc).astimezone(timezone("Asia/Shanghai"))
                logger_text = f"下载完成时间：{now.strftime('%Y-%m-%d %H:%M:%S')}，下载 {file_name} 文件，用时 {(end - start)/60:.2f}分钟"
                logger.info(logger_text)
                send_message(file_name, logger_text)
                zip_file_path.append(local_file_path)
    # 解压 ZIP 文件到临时目录
    for zip_file_p in zip_file_path:
        with zipfile.ZipFile(zip_file_p, 'r') as zip_ref:
            zip_ref.extractall(local_dir)
    # 删除前天之前所有 ZIP 文件
    delete_zip_files(date_2)

def select_file_to_mongo(args, date, moment):
    farmId, isDq = args['farmId'], args['isDq']
    csv_file_format = 'meteoforce_{}_{}_*.csv'.format(farmId, date + str(moment))
    csv_file_weather = csv_file_format.replace('*', 'weather')
    csv_file_power = csv_file_format.replace('*', 'power')
    csv_weather_path, csv_power_path = False, False
    # 查找目标目录并读取 CSV 文件
    for root, dirs, files in os.walk(ftp_params['xxl']['local_dir']):
        if farmId in dirs:
            target_dir_path = os.path.join(root, farmId)
            for file_name in os.listdir(target_dir_path):
                csv_file_path = os.path.join(target_dir_path, file_name)
                if fnmatch.fnmatch(file_name, csv_file_weather):
                    csv_weather_path = csv_file_path
                    logger.info("***找到nwp:{}***".format(csv_weather_path))
                if fnmatch.fnmatch(file_name, csv_file_power):
                    csv_power_path = csv_file_path
                    logger.info("***找到power:{}***".format(csv_power_path))
            if csv_weather_path or csv_power_path:
                break
    if csv_weather_path is False:
        logger.info("获取nwp文件异常:找不到场站 {} nwp文件".format(farmId))
        return False
    # 使用 pandas 读取 CSV 文件
    weather = pd.read_csv(csv_weather_path)
    power = pd.read_csv(csv_power_path) if csv_power_path else None
    if isDq:
        if csv_weather_path and csv_power_path:
            power.drop(columns=['farm_id'], inplace=True)
            weather_power = pd.merge(weather, power, on='date_time')
            # 截取D0-D13时段数据
            df = select_dx_from_nwp(weather_power, args)
            insert_data_into_mongo(df, args)
        else:
            df = select_dx_from_nwp(weather, args)
            insert_data_into_mongo(df, args)
            logger.info(f"CSV 文件 {csv_file_power} 在目标目录 {farmId} 中未找到")
    else:
        if csv_weather_path:
            weather = select_dx_from_nwp(weather, args)
            # 截取D0-D13时段数据
            df = select_dx_from_nwp(weather, args)
            insert_data_into_mongo(df, args)
        else:
            logger.info(f"CSV 文件 {csv_file_weather} 在目标目录 {farmId} 中未找到")
    return True


def select_dx_from_nwp(df, args):
    date, moment = get_moment_next(args.get('dt'))
    date = datetime.datetime.strptime(date, "%Y%m%d")
    date_begin = date + pd.Timedelta(days=int(args.get('day_begin', 'D0')[1:]))
    date_end = date + pd.Timedelta(days=int(args.get('day_end', 'D13')[1:]))
    df['date_time'] = df['date_time'].str.replace("_", " ")
    df['date_time'] = pd.to_datetime(df['date_time'])
    df.set_index('date_time', inplace=True)
    df = df.loc[date_begin.strftime('%Y-%m-%d'): date_end.strftime('%Y-%m-%d')].reset_index(drop=False)
    df.reset_index(drop=True, inplace=True)
    df['date_time'] = df['date_time'].dt.strftime('%Y-%m-%d %H:%M:%S')
    return df

# 示例使用
ftp_params = {
    'xxl' : {
        'host' : '39.107.246.215',
        'user' : 'jiayue',
        'password' : 'JYoguf2018',
        'remote_dir' : './',
        'local_dir': 'data_processing/cache/data/xxl'
    }
}

def send_message(filename, text):
    """
    1. 下载超时
    2. 找不到nwp
    """
    url = "https://qyapi.weixin.qq.com/cgi-bin/webhook/send?key=553f02de-0ef4-49ce-8d68-2489c032d42f"
    # 设置请求头
    headers = {'Content-Type': 'application/json'}
    text=f"""<font color=\'warning\'>算法平台解析nwp模块</font>
        >文件:<font color=\'comment\'>{filename}</font>\n
        >日志:<font color=\'comment\'> {text} \n</font>  """
    # 设置消息内容
    data = {
        "msgtype": "markdown",
        "markdown": {
            "content": text
        }
    }
    # 发送POST请求
    response = requests.post(url, headers=headers, data=json.dumps(data))

@app.route('/data_nwp_ftp', methods=['POST'])
def get_nwp_from_ftp():
    # 获取程序开始时间
    start_time = time.time()
    result = {}
    success = False
    args = {}
    # print("data_nwp_ftp starts execution!")
    try:
        args = request.values.to_dict()
        # 1. 获取参数：日期，数据源，时刻，D0-9，场站ID，存储的 mongo 和表
        # print('args', args)
        logger.info(args)
        # 2. 连接FTP，从FTP服务器中获取指定参数的压缩文件（定时任务）
        # 3. 解压压缩文件，将其存储到mongo中
        date, moment = get_moment_next(args.get('dt'))
        logger.info("从日期{}时刻{}开始查找文件".format(date, moment))
        success = select_file_to_mongo(args, date, moment)
        new_date = date
        i = 1
        while not success and date == new_date and i <= 2:
            new_date, moment = get_previous_moment(date, moment)
            logger.info("未找到，从日期{}时刻{}开始查找文件".format(new_date, moment))
            success = select_file_to_mongo(args, new_date, moment)
            i += 1
        if not success:
            csv_file_weather = 'meteoforce_{}_{}_weather.csv'.format(args['farmId'], date + str(moment))
            logger_text = f"未找到 {csv_file_weather} 文件"
            logger.info(logger_text)
            send_message(csv_file_weather, logger_text)
    except Exception as e:
        my_exception = traceback.format_exc()
        my_exception.replace("\n", "\t")
        result['msg'] = my_exception
        logger.info("生产，获取原始nwp出错：{}".format(my_exception))
    end_time = time.time()
    result['success'] = success
    result['args'] = args
    result['start_time'] = time.strftime('%Y-%m-%d %H:%M:%S', time.localtime(start_time))
    result['end_time'] = time.strftime('%Y-%m-%d %H:%M:%S', time.localtime(end_time))
    # print("Program execution ends!")
    return result


if __name__ == "__main__":
    print("Program starts execution!")
    from waitress import serve
    update_thread() #定时任务开启
    # 遍历参数，创建并启动线程
    for moment in ['00', '06', '12', '18']:
        threading.Thread(target=download_zip_files_from_ftp, kwargs={'moment': moment}).start()

    serve(app, host="0.0.0.0", port=10102)
    print("server start!")

    # now = datetime.datetime.now(pytz.utc).astimezone(timezone("Asia/Shanghai"))
    # logger_text = f"下载完成时间：{now.strftime('%Y-%m-%d %H:%M:%S')}，下载 20230323-meteoforece-nwp.zip 文件，用时 {700/60:.2f}分钟"
    # logger.info(logger_text)
    # send_message('20230323-meteoforece-nwp.zip', logger_text)

    # farmId, isDq = 'j01096', 1
    # date, moment = get_moment_next()
    # csv_file_weather = 'meteoforce_{}_{}_weather.csv'.format(farmId, date + str(moment))
    # logger_text = f"未找到 {csv_file_weather} 文件"
    # send_message(csv_file_weather, logger_text)