Ejemplo n.º 1
0
def addUser(phone_number, URL=None):

    if SELF_SERVICE is False:  # Users must be manually added
        return -1

    if URL is None:
        sendTxt("User not found. Please reply with a Google Sheets URL.", phone_number)

    # Get Admin workbook
    book = getWorkbook(ADMIN_BOOK)

    # Get user sheet
    sheet = getSheet("users", book)

    # Check if phone number has tried to add itself already
    col_values = sheet.col_values(1)  # First column lists users, second column is workbook URL
    if phone_number in col_values:
        cell = sheet.find(phone_number)
        # Update the URL of the user's book
        sheet.update_cell(cell.row, cell.col + 1, URL)

    else:  # The user just got sent a message telling them to add the URL
        # Add them to the db, so they will be recognized when they respond
        depth = len(sheet.col_values(1)) + 1
        sheet.update_cell(depth, 1, phone_number)
        
Ejemplo n.º 2
0
def getUserBook(phone_number):
    """Takes a phone number, returns phone number's workbook"""
    # Get Admin workbook
    book = getWorkbook(ADMIN_BOOK)

    # Get user sheet
    sheet = getSheet("users", book)

    # Check if phone_number is a valid user
    col_values = sheet.col_values(1)  # First column lists users, second column is workbook URL
    if phone_number in col_values:
        cell = sheet.find(phone_number)
        # URL is adjacent column
        URL = sheet.cell(cell.row, cell.col + 1).value

        if URL[:4] == 'http':  # If 'valid' URL
            try:
                book = getWorkbook(URL)

            except gspread.exceptions.SpreadsheetNotFound:  # Workbook is not shared
                sendTxt('Workbook not found. Make sure you shared it with: ' + SHARE_EMAIL, phone_number)
                return -1
            except gspread.exceptions.NoValidUrlKeyFound:  # Workbook URL is invalid
                sendTxt("Workbook is invalid. Please reply with a valid Google Sheets URL.", phone_number)
                return -1

            return book

        elif URL == '':  # Field is empty
            pass

    else:  # If not an existing user
        addUser(phone_number)
        return -1
Ejemplo n.º 3
0
def interpreter(content=None):
    """Takes a message object, containing: msisdn, recipient, message, id, timestamp"""
    if content is None or content['message'] == '':
        return 0

    print content['message']  # Debugging

    # Add 1 to the front of the phone number (Nexmo requires it for sending SMS)
    # Makes this app USA only for the moment :(
    if content['msisdn'][0] != '1':
        # Append it
        l = []
        l.append('1')
        l.append(content['msisdn'])
        content['msisdn'] = ''.join(l)

    # Message contains administrative commands
    if ADMIN is content['message'][0]:
        pass

    # If it is a request from a user to add themselves
    if NEW_USER == content['message'].lower():
        gs.addUser(content['msisdn'])

    # Message contains expenses
    elif EXPENSE is content['message'][0]:
        # Clean the timestamp
        content['timestamp'] = content['timestamp'].split()[0]
        # Clean and normalize the message
        content['message'] = content['message'][1:].lower()

        # Get user workbook
        book = gs.getUserBook(content['msisdn'])

        if book != -1:  # Book == -1 if user does not exist
            sheet = gs.getSheet(content['timestamp'], book)
            result = gs.commit(content, sheet)
            if 'malformed' == result:
                sendTxt(
                    "New users, txt: 'add'\nAdd expense format:\n@<category>:cost <category>:cost", content['msisdn'])

    # If the message is a URL, assume the user is trying to add themselves
    # to the system. This also allows for updating one's workbook on the fly.
    elif 'http' == content['message'][:4]:
        gs.addUser(content['msisdn'], content['message'])
        sendTxt("Workbook added!\n Make sure you share it with " + SHARE_EMAIL, content['msisdn'])