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
from firebase_admin import firestore
import xlsxwriter
from firebase_admin import auth

workbook = xlsxwriter.Workbook('users.xlsx')
worksheet = workbook.add_worksheet()
i,j =0,0
cred = credentials.Certificate('servicekey.json')
#os.system("rm -rf AwsData")
try:
    firebase_admin.initialize_app(cred, {'databaseURL': 'https://farmbase-b2f7e-60c5a.firebaseio.com/'})
except:
    qysy = 1
temp_list = db.reference().get()
for (uid, uidObj) in temp_list.items():
    try:
        myProfileObj = uidObj["MyProfile"]
        name = myProfileObj["Name"]
        user = auth.get_user(uid)
        try:
            phone = user.phone_number
        except:
            phone = user.email
        print(phone)
        worksheet.write(i,0,uid)
        worksheet.write(i,1,phone)
        worksheet.write(i,2,name)
        i = i +1
    except Exception as e:
        print(e)
workbook.close()