from tempfile import tempdir
import firebase_admin
from firebase_admin import credentials
from firebase_admin import db
from find_s1_image2 import find_img_value
import pandas as pdf
from sklearn.metrics import classification_report, confusion_matrix, accuracy_score
import statsmodels.api as sm
import seaborn as sns
sns.set()
import traceback
from sklearn.ensemble import RandomForestRegressor
from sklearn.model_selection import train_test_split
import csv
import time
import json
from find_modis_ndvi import find_modis_ndvi
import numpy as np
from sklearn.cluster import KMeans
from sentinelhub import WebFeatureService, BBox, CRS, MimeType, CRS, BBox, WmsRequest,DataCollection
import traceback
from get_mask import get_mask
from PIL import Image
import numpy as np
from google.cloud import storage
import requests
from simplify_coordinates import simplify_coordinates
cred = credentials.Certificate('servicekey.json')
x = 0.0003
y = 0.0003
fromdate = '20220701'
todate = '20220715'

s1_images = ['IW-VH-DB']
s2_images = []
# s1_images = ["B02", "B03", "B04", "B05"]
#s2_images = ["RVI-NEW"]
try:
    firebase_admin.initialize_app(cred, {'databaseURL': 'https://farmbase-b2f7e-31c0c.firebaseio.com/'})
except:
    print('fire running')
uid = 'TCXcp5VIsfhHZrh0nm2VsgBtcGy2'

uid = 'ipRHhCOFIDV2pxgg7Nfz1ufZBmV2'
num = 0
main_num = 0
#test_uid = 'MtO6G7AvlnPgQxAajMP6NtLS8fN2'
temp_list = db.reference('PaidMonitoredFields').child('PMF').child(uid).get(False, True)

temp_list = db.reference('IFPRITemp').get()
for field_id, field_obj in temp_list.items():
    field_id = str(field_id)
    temp_field_obj = db.reference('PaidMonitoredFields').child('PMF').child(uid).child(field_id).get()
    db.reference('PaidMonitoredFields').child('PMF').child('temp_ipRHhCOFIDV2pxgg7Nfz1ufZBmV2').child(field_id).set(temp_field_obj)
#     main_num = main_num+1
#     if temp_field_obj is None:
#         num = num + 1
#         db.reference('PaidMonitoredFields').child('PMF').child(uid).child(field_id).set(field_obj)
#         time.sleep(0.1)
# print(main_num, num)
time.sleep(100000)

uid_list = {}
for rr, tt in temp_list.items():
    #get all polygons in the field
    if int(rr) < 1715797800000:
        db.reference('PaidMonitoredFields').child('PMF').child(uid).child(rr).delete()
        print(rr)
        time.sleep(0.1)


    # polygons_obj = db.reference('PaidMonitoredFields').child('PMF').child(uid).child(rr).child('Polygons').get(False, True)
    # try:
    #     for polygon_id, uu in polygons_obj.items():
    #         polygon_id = str(polygon_id)
    #         sensed_days_obj = db.reference('PaidMonitoredFields').child('PMF').child(uid).child(rr).child('Polygons').child(polygon_id).child('SensedDays').get()
    #         sensed_days_arr = []
    #         try:
    #             for temp_key, val in sensed_days_obj.items():
    #                     sensed_days_arr.append(int(temp_key))
    #             if len(sensed_days_arr) >0:
    #                 if max(sensed_days_arr) > 20240415:
    #                     main_num = main_num + 1
    #                     print(main_num)
    #         except:
    #             print(traceback.format_exc())
    #         # main_num = main_num + 1
    #         # #check if the polygon exists in the polygons tree
    #         # paid_polygon_id = db.reference('PaidPolygonsByPolygonID').child('PMF').child(uid).child(polygon_id).child('polygonID').get()
    #         # #print((polygon_id,paid_polygon_id))
    #         # if paid_polygon_id is None:
    #         #     num = num+1
    #         #     #print(num)
    #         #     actual_polygon_obj = db.reference('PaidMonitoredFields').child('PMF').child(uid).child(rr).child('Polygons').child(polygon_id).get()
    #         #     db.reference('PaidPolygonsByPolygonID').child('PMF').child(uid).child(polygon_id).set(actual_polygon_obj)
    # except:
    #     print(traceback.format_exc())
print((main_num, num))