#!/usr/bin/python3

# ## {R2D2919B742E} ##
# ###########################################################################
# What if magic existed?
# What if a place existed where your every thought and dream come to life.
# There is only one catch: it has to be written down.
# Such a place exists, it is called programming.
#    - Scott Taylor Reph, RightThumb.com
# ###########################################################################
# ## {C3P0D40fAe8B} ##
##################################################
import os, sys, time
##################################################
import _rightThumb._construct as __
appDBA = __.clearFocus( __name__, __file__ )
__.appReg = appDBA
def focus( parentApp='', childApp='', reg=True ):
    global appDBA
    f = __.appName( appDBA, parentApp, childApp )
    if reg:
        __.appReg = f
    return f
__.registeredApps.append( focus() )
import _rightThumb._base3 as _
_.load()
##################################################
import _rightThumb._vars as _v
import _rightThumb._string as _str
##################################################

def appSwitches():
    pass
    _.switches.register( 'Files', '-f,-file,-files','file.txt',  description='Files', isRequired=True )
    _.switches.register( 'Save', '-save' )

_.autoBackupData = __.setting('receipt-log')
__.releaseAcquiredData = __.setting('receipt-file')
__.myFileLocations_SKIP_VALIDATION = False
__.isRequired_Pipe = False
__.isRequired_Pipe_or_File = False
__.pre_error = False
__.switch_raw = []
# __.switch_raw = [ 'Delim' ]
# __.isRequired_or_List = ['Pipe','Files','Plus']
# __.setting( 'app-switches-raw', [ 'Delim' ] )


_.appInfo[focus()] = {
    'file': 'vps-hoth-7i0ZA-7GzGHN-gen-lon-lat.py',
    'liveAppName': __.thisApp( __file__ ),
     'description': 'gen lon and lat clients',
    'categories': [
                        'gps',
                        'lon',
                        'lat',
                        'longitude',
                        'latitude',
                ],
    'usage': [
                        # 'epy another',
                        # 'e nmap',
                        # '',
    ],
    'relatedapps': [
                        # 'p another -file file.txt',
                        # '',
    ],
    'prerequisite': [
                        # 'p another -file file.txt',
                        # '',
    ],
    'examples': [
                        _.hp('p vps-hoth-7i0ZA-7GzGHN-gen-lon-lat -f clients.csv  -save clients.json'),
                        _.hp('p vps-hoth-7i0ZA-7GzGHN-gen-lon-lat -f clients.json -save clients.json'),
                        '',
    ],
    'columns': [
                       # { 'name': 'name', 'abbreviation': 'n' },
                       # { 'name': '{1}', 'abbreviation': '{0}', 'sort': '{2}' },
    ],
    'aliases': [
                       # 'this',
                       # 'app',
    ],
    'notes': [
                       # {},
    ],
}

_.appData[focus()] = {
        'start': __.startTime,
        'uuid': '',
        'audit': [],
        'pipe': False,
        'data': {
                    'field': {'sent': [], 'received': [] }, # { 'label': '', 'context': [],  }
                    'table': {'sent': [], 'received': [] }, 
        },
    }



def registerSwitches( argvProcessForce=False ):
    global appDBA
    if not __.appReg == appDBA and appDBA in __.appReg:

        if not __name__ == '__main__':
            _.argvProcess = argvProcessForce
        else:
            _.argvProcess = True

        _.load()
        _.appInfo[__.appReg] = _.appInfo[appDBA]
        _.appData[__.appReg] = _.appData[appDBA]
    __.constructRegistration( _.appInfo[__.appReg]['file'],__.appReg )
    appSwitches()

    _.myFileLocation_Print = False
    # _.switches.trigger( 'Files', _.myFileLocations, vs=True )
    _.switches.trigger( 'Folder', _.myFolderLocations )
    _.switches.trigger( 'URL', _.urlTrigger )
    _.switches.trigger( 'Ago', _.timeAgo )
    _.switches.trigger( 'Duration', _.timeFuture )
    
    _.defaultScriptTriggers()
    _.switches.process()


if not __name__ == '__main__':
    _.argvProcess = False
else:
    _.argvProcess = True

registerSwitches()


def fieldSet( switchName, switchField, switchValue, theFocus=False ):
    if not type( theFocus ) == bool:
        theFocus = theFocus
    _.switches.fieldSet( switchName, switchField, switchValue, theFocus )


if __name__ == '__main__':
    if not sys.stdin.isatty():
        _.setPipeData( sys.stdin.readlines(), __.appReg, clean=True )


_.postLoad( __file__ )

########################################################################################
# START

def ziper(address):

    parts=address.split(' ')
    parts.reverse()
    for i,p in enumerate(parts):
        if len(p) == 5 and p[0] in '0123456789':
            return p
    return None
def dress(aa):
    aa=aa.replace(',','')
    aa=aa.replace('\r','')
    aa=aa.replace('\n',' ')
    aa=aa.lower().replace('fl','fl ')
    aa=_str.cleanBE(aa,' ')
    aa=_str.cleanBE(aa,'\t')
    if not ' fl ' in aa and 'tampa' in aa:
        aa=aa.replace('tampa','tampa fl ')
    aa=_str.replaceDuplicate(aa,' ')
    aa=aa.replace('fl orida','fl')
    return aa
def action():
    # should be   Single-Task   OR   Imply-Architecture-Functions   OR   CLASSES!!
    load()
    global data
    total=len(data)
    cnt=0
    partial=0
    for i,row in enumerate( data ):
        if not 'coordinates' in data[i]:
            data[i]['coordinates']={}
        if 'latitude' in data[i]['coordinates']:
            cnt+=1
        else:
            a=row['BillingAddress']
            if not a or a.lower().replace('.','').startswith('po'):
                a=row['ShippingAddress']
            a=dress(a)
            if a:
                # _.pr('|'+a+'|')
                z=ziper(a)
                if z is None:
                    partial+=1
                    pass
                    # _.pr(a)
                else:
                    # _.pr(z)
                    nomi = pgeocode.Nominatim('us')
                    info=nomi.query_postal_code(z)
                    lat=info['latitude']
                    lon=info['longitude']
                    try:
                        lat=float(lat)
                        lon=float(lon)
                    except Exception as e:
                        pass
                    if type(lat) == float and type(lon) == float and not math.isnan(lon):
                        cnt+=1
                        data[i]['coordinates']['longitude']=lon
                        data[i]['coordinates']['latitude']=lat
                        # _.pr(lon,lat)
                    else:
                        partial+=1
        data[i]['i']=i
            # _.pr()
            # _.pr(type(ziper(a)))
        # _.pr()
        # _.pr(row.keys())
        # sys.exit()
    pass
    _.pr( '\n', cnt, 'of', total )
    _.pr( '', partial, 'partial' )
    _.pr( '', total-(partial+cnt), 'none' )
    if _.switches.isActive('Save'):
        _.saveTable2(data,_.switches.values('Save')[0])
        _.cp('saved','green')



def load():
    global data
    fi = _.switches.values('Files')[0]
    if fi.lower().endswith('.csv'):
        data = _.csv( fi )
    else:
        data = _.getTable2( fi )

import pgeocode
import math



########################################################################################
if __name__ == '__main__':
    action()
    __.isExit()





