from socket import *
from oct2py import octave
from io import BytesIO
import base64
from google.cloud import storage
from oauth2client.service_account import ServiceAccountCredentials
import os
import firebase_admin
from firebase_admin import credentials
from firebase_admin import db
from PIL import Image, ImageFilter
from send_notification import send_notification
from sendemail import sendemail
from sen_start_noti import sen_start_noti
from send_sar_email import send_sar_email
import json
import scipy
import random
from gen_report_new import gen_report_new
import time
import datetime
from merge_sar import merge_sar
from find_sar import find_sar
from merge_dem import merge_dem
from find_dem import find_dem
from scipy import ndimage
from make_bigquery import make_bigquery
from send_moni_noti import send_moni_noti
from send_error_noti import send_error_noti
from gmap_image import gmap_image
from gmap_image_large import gmap_image_large
from datetime import date
from find_img import find_img
from find_img_large import find_img_large
from merge_img import merge_img
from all_proc import all_proc
from contour_images import contour_images
from send_expiring_noti import send_expiring_noti
from send_expired_noti import send_expired_noti
from make_trial_bigquery import make_trial_bigquery
from gen_geotiff import gen_geotiff
from sendgeotifs import sendgeotifs
from gen_report import gen_report
from get_weather_data import get_weather_data
from sendonlyreport import sendonlyreport
from gen_failed_report import gen_failed_report
from sendfailedreport import sendfailedreport
from map_coords import map_coords
from search_new_sentinel import search_new_sentinel
from convert_to_pdf import convert_to_pdf
from latlon_jp2_to_pixel import latlon_jp2_to_pixel
from gen_geotiff2 import gen_geotiff2
from search_sentinel_again import search_sentinel_again
from get_prev_date import get_prev_date
from make_bigquery_again import make_bigquery_again
import requests
import pdftotree
from convert_to_html import convert_to_html
from geopy.geocoders import Nominatim
import json
import pandas as pd
from fastkml import kml

cred = credentials.Certificate('servicekey.json')
#os.system("rm -rf AwsData")
try:
    firebase_admin.initialize_app(cred, {'databaseURL': 'https://farmbase-b2f7e-31c0c.firebaseio.com/'})
except:
    qysy = 1
uid = 'KZQ7TZIYXnXN0b07OtrL1hlyYij1'
uidObj = db.reference('PaidMonitoredFields').child('PMF').child('KZQ7TZIYXnXN0b07OtrL1hlyYij1').get()
storage_client = storage.Client()
bucket_name = 'farmbase-b2f7e.appspot.com'
bucket = storage_client.get_bucket(bucket_name)
mainObj = {}
for (u,v) in uidObj.items():
    fieldObj = v
    fieldID = u
    sensedDays = fieldObj["SensedDays"]
    fieldRVIObj = {}
    for (p,q) in sensedDays.items():
        day = p
        htmlfilename = uid +'/' + day+ '_rvi.png'
        destination_blob_name = 'PaidMonitoredFields/'+str(uid)+'/'+str(fieldID)+'/'+str(day)+ '/rvi'
        blob = bucket.blob(destination_blob_name)
        blob.download_to_filename(htmlfilename)
        result_status= octave.get_rvi_value(uid,day)
        fieldRVIObj[day] = result_status
    mainObj[fieldID] = fieldRVIObj
with open('data2.json','w') as f2:
    json.dump(mainObj,f2)
df_json = pd.read_json('data2.json')
df_json.to_excel('rvi_indigo.xlsx')