import firebase_admin
from firebase_admin import credentials
from firebase_admin import db
import seaborn as sns
sns.set()
import csv
import time
import traceback
import xlsxwriter
cred = credentials.Certificate('servicekey.json')
try:
    firebase_admin.initialize_app(cred, {'databaseURL': 'https://farmbase-b2f7e-31c0c.firebaseio.com/'})
except:
    print('fire running')
x = 0.0003
y = 0.0003
fromdate = '20220701'
todate = '20220715'

s1_images = ['IW-VH-DB']
s2_images = []
workbook = xlsxwriter.Workbook('bhumitantra.xlsx')
worksheet = workbook.add_worksheet()
uids = ['AvlbNpsuI7P1sva1NWMBUN4Fmbg1','2Gpn5tspykcKPt0tQqkQrpT52Ji2', 'DgwGhWlZKndMe33MlmSnt2Vp0PD2', 'JNH5nfMdqDOQGrTOM0wrVysxgH92']
main_arr = []
row = 1
main_arr.append(['Name & Phone Number', 'Coordinates'])
uids = ['fSRlyKzCxxMJHJqDzpGhQImyyxf2','rF4qo7DGoxd3AeEC1Ux4vBGbsbl1']
uids = ['M53J9SImW9My4vghlCaaWLYxsc22']
all_farmers = []
#uids = ['YkJIYa63SLhOZdmo4hRKZ17z4lq2']
#uids = ['3slpdq65yYXR6M9zDU2I3Ng6kRD2']
num =0
for uid in uids:
    all_fields = db.reference('PaidMonitoredFields').child('PMF').child(uid).get()
    try:
        for (fieldid, fieldobj) in all_fields.items():
            #field_address = fieldobj["FieldAddress"]
            #points_obj = fieldobj["Coordinates"]
            # all_points = []
            # for (pointKey, single_point) in points_obj.items():
            #     all_points.append([single_point["Latitude"], single_point["Longitude"]])
            # print(field_address)
            # split_address = field_address.split(",")
            #db.reference('PaidMonitoredFields').child('PMF').child(uid).child(fieldid).child('Expired').delete()
            print(fieldid)
            num = num + 1
            # db.reference('PaidMonitoredFields').child('PMF').child(uid).child(fieldid).child('Expiring').set('no')
            # db.reference('PaidMonitoredFields').child('PMF').child(uid).child(fieldid).child('PaymentType').set('4')
            # db.reference('PaidMonitoredFields').child('PMF').child(uid).child(fieldid).child('Expired').delete()
            # db.reference('PaidMonitoredFields').child('PMF').child(uid).child(fieldid).child('Phone').set(split_address[1])
            # all_farmers.append([split_address[0],split_address[1], all_points])

            # temp_obj = {}
            # temp_obj["UID"] = "3slpdq65yYXR6M9zDU2I3Ng6kRD2"
            # temp_obj["Points"] = points_obj
            # print(temp_obj)
            # r = requests.post('https://us-central1-farmbase-b2f7e.cloudfunctions.net/getFieldAreaByBoundaryPoints', json = temp_obj)
            # print(r.text)
            # res_obj = json.loads(r.text)
            # area = res_obj["FieldArea"]
            # print(area)
            # db.reference('PaidMonitoredFields').child('PMF').child(uid).child(fieldid).child('FieldArea').set(area)
            # #break
            #time.sleep(1)
            sensed_days = db.reference('PaidMonitoredFields').child('PMF').child(uid).child(fieldid).child('SensedDays').get()
            new_sensed_days = {}
            len_days = 0
            for (p,q) in sensed_days.items():
                len_days = len_days+1
            temp_len = 0
            for (x,y) in sensed_days.items():
                if temp_len < len_days - 1:
                    new_sensed_days[x] = y
                    temp_len = temp_len+1
           # print([sensed_days, new_sensed_days])
            db.reference('PaidMonitoredFields').child('PMF').child(uid).child(fieldid).child('SensedDays').set(new_sensed_days)
            #db.reference('PaidMonitoredFields').child('PMF').child(uid).child(fieldid).child('Language').set('hi,en')
            time.sleep(0.1)
            # pointsObj = fieldobj["Coordinates"]
            # midlat, midlng, pointNum = 0,0,0
            # for (point_key, point_obj) in pointsObj.items():
            #     lat = point_obj["Latitude"]
            #     lng = point_obj["Longitude"]
            #     midlat = midlat + lat
            #     midlng = midlng + lng
            #     pointNum = pointNum + 1
            # midlat = midlat/pointNum
            # midlng = midlng/pointNum
            # field_address = fieldobj["FieldAddress"]
            # worksheet.write(row, 0, field_address)
            # worksheet.write(row, 1, (str(midlat) + ', ' + str(midlng)))
            # worksheet.write(row, 2, fieldid)
            # main_arr.append([field_address, (str(midlat) + ', ' + str(midlng))])
            # row = row + 1
    except:
        print(traceback.format_exc())
print(num)
with open('itc_list', 'w') as f:
      
    # using csv.writer method from CSV package
    write = csv.writer(f)
      
    write.writerow(['Name', 'Phone Number', 'Boundary Points'])
    write.writerows(all_farmers)