test.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Timestamp_1</th>\n",
       "      <th>Column_No</th>\n",
       "      <th>Check-in date</th>\n",
       "      <th>Check-out date</th>\n",
       "      <th>City of birth</th>\n",
       "      <th>City of residence</th>\n",
       "      <th>Country of issue</th>\n",
       "      <th>Country of residence</th>\n",
       "      <th>Date of birth</th>\n",
       "      <th>First name</th>\n",
       "      <th>Last name</th>\n",
       "      <th>Nationality</th>\n",
       "      <th>Passport (or ID) number</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>63</th>\n",
       "      <td>5/27/2024 23:40:47</td>\n",
       "      <td>2</td>\n",
       "      <td>07-07-2024</td>\n",
       "      <td>16-07-2024</td>\n",
       "      <td>Helmond</td>\n",
       "      <td>Venlo</td>\n",
       "      <td>Netherlands</td>\n",
       "      <td>Netherlands</td>\n",
       "      <td>04-07-1999</td>\n",
       "      <td>Anab</td>\n",
       "      <td>Ahmed</td>\n",
       "      <td>Dutch</td>\n",
       "      <td>NS5L1B179</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64</th>\n",
       "      <td>5/27/2024 23:40:47</td>\n",
       "      <td>3</td>\n",
       "      <td>07-07-2024</td>\n",
       "      <td>16-07-2024</td>\n",
       "      <td>Helmond</td>\n",
       "      <td>Venlo</td>\n",
       "      <td>Netherlands</td>\n",
       "      <td>Netherlands</td>\n",
       "      <td>15-01-1997</td>\n",
       "      <td>Asha</td>\n",
       "      <td>Ahmed</td>\n",
       "      <td>Dutch</td>\n",
       "      <td>NWHBLH580</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65</th>\n",
       "      <td>7/16/2024 18:23:06</td>\n",
       "      <td>6</td>\n",
       "      <td>16-07-2024</td>\n",
       "      <td>18-07-2024</td>\n",
       "      <td>Abu Dhabi</td>\n",
       "      <td>Abu Dhabi</td>\n",
       "      <td>United Arab Emirates</td>\n",
       "      <td>United Arab Emirates</td>\n",
       "      <td>22-06-2023</td>\n",
       "      <td>Salman</td>\n",
       "      <td>Alhosani</td>\n",
       "      <td>Emirian</td>\n",
       "      <td>AA0321692</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>66</th>\n",
       "      <td>7/16/2024 18:23:06</td>\n",
       "      <td>4</td>\n",
       "      <td>16-07-2024</td>\n",
       "      <td>18-07-2024</td>\n",
       "      <td>Jidhafs</td>\n",
       "      <td>Abu Dhabi</td>\n",
       "      <td>Bahrain</td>\n",
       "      <td>United Arab Emirates</td>\n",
       "      <td>18-04-1984</td>\n",
       "      <td>Fatema</td>\n",
       "      <td>Taraif</td>\n",
       "      <td>Bahraini</td>\n",
       "      <td>2717652</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>67</th>\n",
       "      <td>7/16/2024 18:23:06</td>\n",
       "      <td>5</td>\n",
       "      <td>16-07-2024</td>\n",
       "      <td>18-07-2024</td>\n",
       "      <td>Abu Dhabi</td>\n",
       "      <td>Abu Dhabi</td>\n",
       "      <td>United Arab Emirates</td>\n",
       "      <td>United Arab Emirates</td>\n",
       "      <td>19-01-1982</td>\n",
       "      <td>Fares</td>\n",
       "      <td>Alhosani</td>\n",
       "      <td>Emirian</td>\n",
       "      <td>C8YK16609</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68</th>\n",
       "      <td>7/9/2024 11:40:22</td>\n",
       "      <td>2</td>\n",
       "      <td>18-07-2024</td>\n",
       "      <td>24-07-2024</td>\n",
       "      <td>London</td>\n",
       "      <td>London</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>10-05-2004</td>\n",
       "      <td>Anya</td>\n",
       "      <td>Smitherman</td>\n",
       "      <td>British</td>\n",
       "      <td>124549266</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>69</th>\n",
       "      <td>7/9/2024 11:40:22</td>\n",
       "      <td>3</td>\n",
       "      <td>18-07-2024</td>\n",
       "      <td>24-07-2024</td>\n",
       "      <td>London</td>\n",
       "      <td>London</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>30-07-2004</td>\n",
       "      <td>Maya</td>\n",
       "      <td>Mitchell-Lambert</td>\n",
       "      <td>British</td>\n",
       "      <td>132449114</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>7/6/2024 1:34:05</td>\n",
       "      <td>1</td>\n",
       "      <td>17-08-2024</td>\n",
       "      <td>21-08-2024</td>\n",
       "      <td>Glen Cove</td>\n",
       "      <td>Brooklyn</td>\n",
       "      <td>United States</td>\n",
       "      <td>United States</td>\n",
       "      <td>06-12-1967</td>\n",
       "      <td>Kathryn</td>\n",
       "      <td>Maloney</td>\n",
       "      <td>American</td>\n",
       "      <td>A44191676</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71</th>\n",
       "      <td>7/4/2024 15:51:12</td>\n",
       "      <td>3</td>\n",
       "      <td>07-09-2024</td>\n",
       "      <td>13-09-2024</td>\n",
       "      <td>Windsor, Ontario</td>\n",
       "      <td>Glen Ellen</td>\n",
       "      <td>United States</td>\n",
       "      <td>United States</td>\n",
       "      <td>23-02-1976</td>\n",
       "      <td>Ingalis</td>\n",
       "      <td>Salonen</td>\n",
       "      <td>American</td>\n",
       "      <td>683238569</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>72</th>\n",
       "      <td>7/4/2024 15:51:12</td>\n",
       "      <td>2</td>\n",
       "      <td>07-09-2024</td>\n",
       "      <td>13-09-2024</td>\n",
       "      <td>Huntington, New York</td>\n",
       "      <td>Glen Ellen</td>\n",
       "      <td>United States</td>\n",
       "      <td>United States</td>\n",
       "      <td>18-04-1972</td>\n",
       "      <td>Chris</td>\n",
       "      <td>Record</td>\n",
       "      <td>American</td>\n",
       "      <td>A36330457</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "           Timestamp_1 Column_No Check-in date Check-out date  \\\n",
       "63  5/27/2024 23:40:47         2    07-07-2024     16-07-2024   \n",
       "64  5/27/2024 23:40:47         3    07-07-2024     16-07-2024   \n",
       "65  7/16/2024 18:23:06         6    16-07-2024     18-07-2024   \n",
       "66  7/16/2024 18:23:06         4    16-07-2024     18-07-2024   \n",
       "67  7/16/2024 18:23:06         5    16-07-2024     18-07-2024   \n",
       "68   7/9/2024 11:40:22         2    18-07-2024     24-07-2024   \n",
       "69   7/9/2024 11:40:22         3    18-07-2024     24-07-2024   \n",
       "70    7/6/2024 1:34:05         1    17-08-2024     21-08-2024   \n",
       "71   7/4/2024 15:51:12         3    07-09-2024     13-09-2024   \n",
       "72   7/4/2024 15:51:12         2    07-09-2024     13-09-2024   \n",
       "\n",
       "           City of birth City of residence      Country of issue  \\\n",
       "63              Helmond             Venlo            Netherlands   \n",
       "64               Helmond             Venlo           Netherlands   \n",
       "65            Abu Dhabi         Abu Dhabi   United Arab Emirates   \n",
       "66              Jidhafs         Abu Dhabi                Bahrain   \n",
       "67            Abu Dhabi         Abu Dhabi   United Arab Emirates   \n",
       "68                London            London        United Kingdom   \n",
       "69                London            London        United Kingdom   \n",
       "70            Glen Cove           Brooklyn         United States   \n",
       "71      Windsor, Ontario        Glen Ellen         United States   \n",
       "72  Huntington, New York        Glen Ellen         United States   \n",
       "\n",
       "    Country of residence Date of birth First name         Last name  \\\n",
       "63           Netherlands    04-07-1999       Anab            Ahmed    \n",
       "64           Netherlands    15-01-1997       Asha            Ahmed    \n",
       "65  United Arab Emirates    22-06-2023    Salman          Alhosani    \n",
       "66  United Arab Emirates    18-04-1984    Fatema             Taraif   \n",
       "67  United Arab Emirates    19-01-1982     Fares          Alhosani    \n",
       "68        United Kingdom    10-05-2004       Anya        Smitherman   \n",
       "69        United Kingdom    30-07-2004      Maya   Mitchell-Lambert   \n",
       "70         United States    06-12-1967    Kathryn           Maloney   \n",
       "71         United States    23-02-1976    Ingalis           Salonen   \n",
       "72         United States    18-04-1972      Chris            Record   \n",
       "\n",
       "   Nationality Passport (or ID) number  \n",
       "63       Dutch               NS5L1B179  \n",
       "64       Dutch               NWHBLH580  \n",
       "65     Emirian               AA0321692  \n",
       "66    Bahraini                 2717652  \n",
       "67     Emirian               C8YK16609  \n",
       "68     British               124549266  \n",
       "69     British               132449114  \n",
       "70    American               A44191676  \n",
       "71    American               683238569  \n",
       "72    American               A36330457  "
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "from scripts.google_api import get_form\n",
    "from scripts.data_processing import clean_sheet\n",
    "\n",
    "# Get the form responses\n",
    "df = get_form()\n",
    "clean_df = clean_sheet()\n",
    "\n",
    "clean_df.tail(10)\n",
    "# df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Timestamp_1</th>\n",
       "      <th>Column_No</th>\n",
       "      <th>Check-in date</th>\n",
       "      <th>Check-out date</th>\n",
       "      <th>City of birth</th>\n",
       "      <th>City of residence</th>\n",
       "      <th>Country of issue</th>\n",
       "      <th>Country of residence</th>\n",
       "      <th>Date of birth</th>\n",
       "      <th>First name</th>\n",
       "      <th>Last name</th>\n",
       "      <th>Nationality</th>\n",
       "      <th>Passport (or ID) number</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "Empty DataFrame\n",
       "Columns: [Timestamp_1, Column_No, Check-in date, Check-out date, City of birth, City of residence, Country of issue, Country of residence, Date of birth, First name, Last name, Nationality, Passport (or ID) number]\n",
       "Index: []"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Get the form responses\n",
    "get_form()\n",
    "clean_df = clean_sheet()\n",
    "\n",
    "def filter_df_on_name(clean_df, first_name=None, last_name=None):\n",
    "\n",
    "    # Filter the DataFrame based on combinations of first and last name\n",
    "    if first_name and last_name:\n",
    "        filtered_df = clean_df[(clean_df['First name'] == first_name) & (clean_df['Last name'] == last_name)]\n",
    "    elif first_name:\n",
    "        filtered_df = clean_df[clean_df['First name'] == first_name]\n",
    "    elif last_name:\n",
    "        filtered_df = clean_df[clean_df['Last name'] == last_name]\n",
    "    else:\n",
    "        filtered_df = clean_df\n",
    "\n",
    "    return filtered_df\n",
    "\n",
    "# filter_df_on_name(clean_df, first_name='Lucie', last_name=None)\n",
    "# filter_df_on_name(clean_df, first_name=None, last_name='Hazan')\n",
    "# filter_df_on_name(clean_df, first_name='Lucie', last_name='Hazan')\n",
    "filter_df_on_name(clean_df, first_name='Fatema')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "String is not empty\n"
     ]
    }
   ],
   "source": [
    "string = ''\n",
    "\n",
    "if not string:\n",
    "    print('String is not empty')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "import json\n",
    "from scripts.aws import *\n",
    "\n",
    "key = 'records.json'\n",
    "obj = download_object(bucket_name, key)\n",
    "records = json.loads(obj)\n",
    "\n",
    "records"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "from scripts.data_processing import *\n",
    "import json\n",
    "\n",
    "records = write_new_records_to_json(None)\n",
    "\n",
    "json.dumps(records)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "from selenium import webdriver\n",
    "from selenium.webdriver.common.keys import Keys\n",
    "from selenium.webdriver.chrome.options import Options\n",
    "import time\n",
    "\n",
    "def test_duckduckgo_search():\n",
    "    # Set up Chrome options for headless mode\n",
    "    chrome_options = Options()\n",
    "    chrome_options.add_argument(\"--headless\")  # Ensure GUI is not displayed\n",
    "    chrome_options.add_argument(\"--no-sandbox\")  # Bypass OS security model\n",
    "    chrome_options.add_argument(\"--disable-dev-shm-usage\")  # Overcome limited resource problems\n",
    "\n",
    "    # Initialize WebDriver with options\n",
    "    driver = webdriver.Chrome(options=chrome_options)\n",
    "\n",
    "    try:\n",
    "        # Navigate to DuckDuckGo\n",
    "        driver.get(\"https://www.duckduckgo.com\")\n",
    "        assert \"DuckDuckGo\" in driver.title\n",
    "\n",
    "        # Find the search box using its name attribute value\n",
    "        search_box = driver.find_element(\"name\", \"q\")\n",
    "        search_box.clear()\n",
    "\n",
    "        # Perform a search operation\n",
    "        search_term = \"selenium headless browser testing\"\n",
    "        search_box.send_keys(search_term)\n",
    "        search_box.send_keys(Keys.RETURN)  # Simulate pressing the Enter key\n",
    "\n",
    "        time.sleep(2)  # Wait a bit for the search results to load\n",
    "\n",
    "        # Verify that the search operation was successful\n",
    "        assert search_term in driver.title\n",
    "\n",
    "        print(\"Test passed: Search operation was successful.\")\n",
    "    except AssertionError as e:\n",
    "        print(f\"Test failed: {e}\")\n",
    "    finally:\n",
    "        driver.quit()\n",
    "\n",
    "test_duckduckgo_search()\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Timestamp_1</th>\n",
       "      <th>Column_No</th>\n",
       "      <th>Check-in date</th>\n",
       "      <th>Check-out date</th>\n",
       "      <th>City of birth</th>\n",
       "      <th>City of residence</th>\n",
       "      <th>Country of issue</th>\n",
       "      <th>Country of residence</th>\n",
       "      <th>Date of birth</th>\n",
       "      <th>First name</th>\n",
       "      <th>Last name</th>\n",
       "      <th>Nationality</th>\n",
       "      <th>Passport (or ID) number</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>3/28/2024 7:09:06</td>\n",
       "      <td>2</td>\n",
       "      <td>29-03-2024</td>\n",
       "      <td>01-04-2024</td>\n",
       "      <td>Pelhřimov</td>\n",
       "      <td>Praha</td>\n",
       "      <td>Portugal</td>\n",
       "      <td>Czech Republic</td>\n",
       "      <td>16-04-1985</td>\n",
       "      <td>Olga</td>\n",
       "      <td>Kučerová</td>\n",
       "      <td>Czech</td>\n",
       "      <td>47515859</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>3/28/2024 7:09:06</td>\n",
       "      <td>3</td>\n",
       "      <td>29-03-2024</td>\n",
       "      <td>01-04-2024</td>\n",
       "      <td>Rakovník</td>\n",
       "      <td>Praha</td>\n",
       "      <td>Portugal</td>\n",
       "      <td>Czech Republic</td>\n",
       "      <td>04-08-1975</td>\n",
       "      <td>Tomáš</td>\n",
       "      <td>Baldýnský</td>\n",
       "      <td>Czech</td>\n",
       "      <td>207867301</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          Timestamp_1 Column_No Check-in date Check-out date City of birth  \\\n",
       "28  3/28/2024 7:09:06         2    29-03-2024     01-04-2024     Pelhřimov   \n",
       "29  3/28/2024 7:09:06         3    29-03-2024     01-04-2024      Rakovník   \n",
       "\n",
       "   City of residence Country of issue Country of residence Date of birth  \\\n",
       "28             Praha         Portugal       Czech Republic    16-04-1985   \n",
       "29             Praha         Portugal       Czech Republic    04-08-1975   \n",
       "\n",
       "   First name  Last name Nationality Passport (or ID) number  \n",
       "28      Olga    Kučerová       Czech                47515859  \n",
       "29      Tomáš  Baldýnský       Czech               207867301  "
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "from scripts.data_processing import *\n",
    "from scripts.google_api import *\n",
    "\n",
    "checkin_date = '29-03-2024'\n",
    "# Get form responses\n",
    "# sheet_path = get_form()\n",
    "clean_df = clean_sheet()\n",
    "filtered_df = filter_df_on_checkin_date(clean_df, checkin_date)\n",
    "\n",
    "filtered_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Opening the IRS website...\n",
      "Filling in the login details...\n",
      "Logged in successfully.\n",
      "Filling in the date and type of invoice...\n",
      "Filling in the invoice details...\n",
      "Submitting the invoice (first button)...\n",
      "Submitting the invoice (second button)...\n",
      "Invoice Completed\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "'Invoice Completed'"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import os\n",
    "from selenium import webdriver\n",
    "from selenium.webdriver.common.keys import Keys\n",
    "from selenium.webdriver.chrome.options import Options\n",
    "from selenium.webdriver.common.by import By\n",
    "from selenium.webdriver.support.ui import WebDriverWait\n",
    "from selenium.webdriver.support import expected_conditions as EC\n",
    "from selenium.webdriver.common.action_chains import ActionChains\n",
    "import time\n",
    "from scripts import google_api, web_automation, data_processing\n",
    "from dotenv import load_dotenv\n",
    "\n",
    "# Load environment variables from a .env file located in the same directory as this script\n",
    "load_dotenv()\n",
    "uh_input_ = os.getenv('SEF_UH')\n",
    "estabelecimento_input_ = os.getenv('SEF_ESTABELECIMENTO')\n",
    "chave_activacao_input_ = os.getenv('SEF_CHAVE')\n",
    "pdf_nif = os.getenv('PDF_NIF')\n",
    "pdf_senha = os.getenv('PDF_SENHA')\n",
    "\n",
    "# Extract the mapping files\n",
    "countries_mapping = os.path.join(os.getcwd(), 'parameters', 'countries_mapping.json')\n",
    "nationalities_mapping = os.path.join(os.getcwd(), 'parameters', 'nationalities_mapping.json')\n",
    "\n",
    "def callback(msg):\n",
    "    print(msg)\n",
    "\n",
    "def fill_in_sef_form(df, callback):\n",
    "    try:\n",
    "        with open(countries_mapping) as f:\n",
    "            countries = json.load(f)\n",
    "\n",
    "        with open(nationalities_mapping) as f:\n",
    "            nationalities = json.load(f)\n",
    "\n",
    "        chrome_options = Options()\n",
    "        chrome_options.add_argument(\"--headless\")\n",
    "        chrome_options.add_argument(\"--no-sandbox\")\n",
    "        chrome_options.add_argument(\"--disable-dev-shm-usage\")\n",
    "\n",
    "        web = webdriver.Chrome(options=chrome_options)\n",
    "\n",
    "        callback(\"Opening the SEF website...\")\n",
    "        url = 'https://siba.sef.pt/s/FB.aspx?ReturnUrl=%2fs%2fbal%2fLotesEnvio.aspx'\n",
    "        web.get(url)\n",
    "        time.sleep(2)\n",
    "\n",
    "        callback(\"Filling in the establishment details...\")\n",
    "        uh_input = web.find_element('id', 'Conteudo_txtUH')\n",
    "        estabelecimento_input = web.find_element('id', 'Conteudo_txtEstabelecimento')\n",
    "        chave_activacao_input = web.find_element('id', 'Conteudo_txtChaveActivacao')\n",
    "\n",
    "        uh_input.send_keys(uh_input_)\n",
    "        estabelecimento_input.send_keys(estabelecimento_input_)\n",
    "        chave_activacao_input.send_keys(chave_activacao_input_)\n",
    "\n",
    "        # submit_button = web.find_element('id', 'Conteudo_btnConfirmar')\n",
    "        # submit_button.click()\n",
    "\n",
    "        # Example for the submit button\n",
    "        # submit_button = WebDriverWait(web, 10).until(\n",
    "        #     EC.element_to_be_clickable((By.ID, 'Conteudo_btnConfirmar'))\n",
    "        # )\n",
    "        # submit_button.click()\n",
    "\n",
    "        # submit_button = web.find_element('id', 'Conteudo_btnConfirmar')\n",
    "        # ActionChains(web).move_to_element(submit_button).perform()\n",
    "        # submit_button.click()\n",
    "\n",
    "        submit_button = web.find_element('id', 'Conteudo_btnConfirmar')\n",
    "        web.execute_script(\"arguments[0].click();\", submit_button)\n",
    "\n",
    "        time.sleep(2)\n",
    "\n",
    "        callback(\"Creating a new list...\")\n",
    "        new_list = web.find_element('id', 'Conteudo_btnNovaLista')\n",
    "        new_list.click()\n",
    "        time.sleep(2)\n",
    "\n",
    "        callback(\"Editing the list...\")\n",
    "        edit_list = web.find_element('id', 'Conteudo_dg_btnSelect_0')\n",
    "        edit_list.click()\n",
    "        time.sleep(2)\n",
    "\n",
    "        try:\n",
    "            callback(\"Trying to add new bulletin in case list already existed...\")\n",
    "            add_bulletin = web.find_element('id', 'Conteudo_btnNovaBAL')\n",
    "            # add_bulletin.click()\n",
    "            web.execute_script(\"arguments[0].click();\", add_bulletin)\n",
    "            callback(\"Added new bulleting...\")\n",
    "            time.sleep(2)\n",
    "        except Exception as e:\n",
    "            callback(f\"Skipped adding new bulleting. Error: {e}\")\n",
    "            time.sleep(1)\n",
    "\n",
    "        callback(\"Preparing to fill in guest details...\")\n",
    "        for idx, row in df.iterrows():\n",
    "            name_ = web.find_element('id', 'Conteudo_txtNome')\n",
    "            dob_ = web.find_element('id', 'Conteudo_txtDataNascimento')\n",
    "            nationality_ = web.find_element('id', 'Conteudo_lstNacionalidade')\n",
    "            country_of_res_ = web.find_element('id', 'Conteudo_lstPaisResidencia')\n",
    "            passport_ = web.find_element('id', 'Conteudo_txtNumPassaporteBI')\n",
    "            country_of_issue_ = web.find_element('id', 'Conteudo_lstPaisEmissor')\n",
    "            checkin_date_ = web.find_element('id', 'Conteudo_txtDataEntrada')\n",
    "            checkout_date_ = web.find_element('id', 'Conteudo_txtDataSaida')\n",
    "\n",
    "            name = row['First name'] + ' ' + row['Last name']\n",
    "            dob = row['Date of birth']\n",
    "            nationality = countries[nationalities[row['Nationality']]]\n",
    "            country_of_res = countries[row['Country of residence']]\n",
    "            passport = row['Passport (or ID) number']\n",
    "            country_of_issue = countries[row['Country of issue']]\n",
    "            checkin_date = row['Check-in date']\n",
    "            checkout_date = row['Check-out date']\n",
    "            print(\"before sending keys\")\n",
    "            name_.send_keys(name)\n",
    "            print(\"name done\")\n",
    "            dob_.send_keys(dob)\n",
    "            print(\"dob_ done\")\n",
    "            nationality_.send_keys(nationality)\n",
    "            # web.execute_script(\"arguments[0].value = arguments[1];\", nationality_, nationality)\n",
    "            print(\"nationality_ done\")\n",
    "            country_of_res_.send_keys(country_of_res)\n",
    "            print(\"country_of_res_ done\")\n",
    "            passport_.send_keys(passport)\n",
    "            print(\"passport_ done\")\n",
    "            country_of_issue_.send_keys(country_of_issue)\n",
    "            print(\"country_of_issue_ done\")\n",
    "            checkin_date_.send_keys(checkin_date)\n",
    "            print(\"checkin_date_ done\")\n",
    "            checkout_date_.send_keys(checkout_date)\n",
    "            print(\"checkout done\")\n",
    "\n",
    "            # Using JavaScript to set the values\n",
    "            # web.execute_script(\"arguments[0].value = arguments[1];\", name_, name)\n",
    "            # print(\"name done\")\n",
    "            # web.execute_script(\"arguments[0].value = arguments[1];\", dob_, dob)\n",
    "            # print(\"dob_ done\")\n",
    "            # web.execute_script(\"arguments[0].value = arguments[1];\", nationality_, nationality)\n",
    "            # print(\"nationality_ done\")\n",
    "            # web.execute_script(\"arguments[0].value = arguments[1];\", country_of_res_, country_of_res)\n",
    "            # print(\"country_of_res_ done\")\n",
    "            # web.execute_script(\"arguments[0].value = arguments[1];\", passport_, passport)\n",
    "            # print(\"passport_ done\")\n",
    "            # web.execute_script(\"arguments[0].value = arguments[1];\", country_of_issue_, country_of_issue)\n",
    "            # print(\"country_of_issue_ done\")\n",
    "            # web.execute_script(\"arguments[0].value = arguments[1];\", checkin_date_, checkin_date)\n",
    "            # print(\"checkin_date_ done\")\n",
    "            # web.execute_script(\"arguments[0].value = arguments[1];\", checkout_date_, checkout_date)\n",
    "            # print(\"checkout done\")\n",
    "\n",
    "            print(\"after sending keys\")\n",
    "            save = web.find_element('id', 'Conteudo_btnActualizarBAL')\n",
    "            save.click()\n",
    "            # web.execute_script(\"arguments[0].click();\", save)\n",
    "\n",
    "            callback(f\"Details for {name} saved. Proceeding to the next guest...\")\n",
    "            time.sleep(3)\n",
    "\n",
    "        callback(\"Finalizing and sending the list...\")\n",
    "        send = web.find_element('id', 'Conteudo_btnEnviarLista')\n",
    "        # web.execute_script(\"arguments[0].click();\", send)\n",
    "        send.click()\n",
    "        time.sleep(3)\n",
    "\n",
    "        callback(\"SEF registration completed successfully.\")\n",
    "\n",
    "    except Exception as e:\n",
    "        callback(f\"Error during SEF registration: {e}\")\n",
    "\n",
    "    finally:\n",
    "        web.quit()\n",
    "\n",
    "####################################################################################################\n",
    "        \n",
    "def fill_in_invoice(callback, filtered_df, amount, date=None, invoice_nif=None):\n",
    "\n",
    "    if filtered_df.empty:\n",
    "        print('Data provided is empty.')\n",
    "        message = 'Data provided is empty.'\n",
    "        return message\n",
    "    \n",
    "    # Extract info from df\n",
    "    row = filtered_df.iloc[0]\n",
    "    if not date:\n",
    "        date = pd.to_datetime(row['Check-out date'], dayfirst=True).strftime('%Y-%m-%d')\n",
    "    else:\n",
    "        date = date.strftime('%Y-%m-%d')\n",
    "\n",
    "    try:\n",
    "\n",
    "        with open(countries_mapping) as f:\n",
    "            countries = json.load(f)\n",
    "\n",
    "        chrome_options = Options()\n",
    "        chrome_options.add_argument(\"--headless\")\n",
    "        chrome_options.add_argument(\"--no-sandbox\")\n",
    "        chrome_options.add_argument(\"--disable-dev-shm-usage\")\n",
    "\n",
    "        web = webdriver.Chrome(options=chrome_options)\n",
    "\n",
    "        callback(\"Opening the IRS website...\")\n",
    "        url = r'https://irs.portaldasfinancas.gov.pt/recibos/portal/emitir/emitirDocumentos'\n",
    "        web.get(url)\n",
    "\n",
    "        time.sleep(2)\n",
    "\n",
    "        callback(\"Filling in the login details...\")\n",
    "        # Find the label element by its text content (assuming \"NIF\" is the text)\n",
    "        label_element = web.find_element(By.XPATH, \"//label[span='NIF']\")\n",
    "\n",
    "        # Click the label element to perform the action\n",
    "        label_element.click()\n",
    "        time.sleep(1)\n",
    "\n",
    "        # Find and fill in the input fields\n",
    "        nif = web.find_element('id', 'username')\n",
    "        senha = web.find_element('id', 'password-nif')\n",
    "\n",
    "        nif.send_keys(pdf_nif)\n",
    "        senha.send_keys(pdf_senha)\n",
    "\n",
    "        # Locate and click the submit button\n",
    "        submit_button = web.find_element('id', 'sbmtLogin')\n",
    "        submit_button.click()\n",
    "        time.sleep(2)\n",
    "\n",
    "        callback(\"Logged in successfully.\")\n",
    "        time.sleep(1)\n",
    "\n",
    "        callback(\"Filling in the date and type of invoice...\")\n",
    "        # Input date and type of invoice\n",
    "        date_ = web.find_element(By.XPATH, '//*[@id=\"main-content\"]/div/div/emitir-documentos-app-v2/emitir-documentos-form-v2/div[1]/div[2]/div/div/div/div[3]/div/div[1]/lf-date/div/div[1]/input')\n",
    "        date_.send_keys(date)\n",
    "\n",
    "        type_ = web.find_element(By.XPATH, '//*[@id=\"main-content\"]/div/div/emitir-documentos-app-v2/emitir-documentos-form-v2/div[1]/div[2]/div/div/div/div[3]/div/div[2]/lf-dropdown/div/select')\n",
    "        type_.send_keys('Fatura-Recibo')\n",
    "        \n",
    "        # Scroll into view (if needed)\n",
    "        emitir_button = web.find_element(By.XPATH, '//*[@id=\"main-content\"]/div/div/emitir-documentos-app-v2/emitir-documentos-form-v2/div[1]/div[2]/div/div/div/div[3]/div/div[3]/button')\n",
    "        web.execute_script(\"arguments[0].scrollIntoView(true);\", emitir_button)\n",
    "        time.sleep(1)  # Just to be safe, give it a moment\n",
    "\n",
    "        # Click using JavaScript\n",
    "        web.execute_script(\"arguments[0].click();\", emitir_button)    \n",
    "        time.sleep(2)\n",
    "\n",
    "        callback(\"Filling in the invoice details...\")\n",
    "        # Get all fields\n",
    "        country_ = web.find_element(By.XPATH, '//*[@id=\"main-content\"]/div/div/emitir-app/emitir-form/div[1]/div[2]/div/dados-adquirente/div/div[2]/div[1]/div[1]/lf-dropdown/div/select')\n",
    "        name_ = web.find_element(By.XPATH, '//*[@id=\"main-content\"]/div/div/emitir-app/emitir-form/div[1]/div[2]/div/dados-adquirente/div/div[2]/div[2]/div/lf-text/div/input')\n",
    "        payment_ = web.find_element(By.XPATH, '//*[@id=\"main-content\"]/div/div/emitir-app/emitir-form/div[1]/div[2]/div/dados-transmissao/div/div[2]/div[1]/pf-radio/div/div[1]/label/input')\n",
    "        description_ = web.find_element(By.XPATH, '//*[@id=\"main-content\"]/div/div/emitir-app/emitir-form/div[1]/div[2]/div/dados-transmissao/div/div[2]/div[2]/div/textarea')\n",
    "        iva_ = web.find_element(By.XPATH, '//*[@id=\"main-content\"]/div/div/emitir-app/emitir-form/div[1]/div[2]/div/dados-transmissao/div/div[2]/div[6]/div/div[1]/lf-dropdown/div/select')\n",
    "        incidencia_ = web.find_element(By.XPATH, '//*[@id=\"main-content\"]/div/div/emitir-app/emitir-form/div[1]/div[2]/div/dados-transmissao/div/div[2]/div[7]/div[1]/div/lf-dropdown/div/select')\n",
    "        amount_ = web.find_element(By.XPATH, '//*[@id=\"main-content\"]/div/div/emitir-app/emitir-form/div[1]/div[2]/div/dados-transmissao/div/div[2]/div[4]/div/div/div/input')\n",
    "        selo_ = web.find_element(By.XPATH, '//*[@id=\"main-content\"]/div/div/emitir-app/emitir-form/div[1]/div[2]/div/dados-transmissao/div/div[2]/div[8]/div/div/div/input')\n",
    "\n",
    "        # Write in fields\n",
    "        country = countries[row['Country of residence']]\n",
    "        country_.send_keys(country)\n",
    "\n",
    "        if country.lower() == 'portugal':\n",
    "            nif_ = web.find_element(By.XPATH, '//*[@id=\"main-content\"]/div/div/emitir-app/emitir-form/div[1]/div[2]/div/dados-adquirente/div/div[2]/div[1]/div[3]/lf-nif/div/input')\n",
    "            nif_.send_keys(invoice_nif)\n",
    "        else:\n",
    "            passport_ = web.find_element(By.XPATH, '//*[@id=\"main-content\"]/div/div/emitir-app/emitir-form/div[1]/div[2]/div/dados-adquirente/div/div[2]/div[1]/div[2]/lf-text/div/input')\n",
    "            passport = row['Passport (or ID) number']\n",
    "            passport_.send_keys(passport)\n",
    "\n",
    "        name = row['First name'] + ' ' + row['Last name']\n",
    "        name_.send_keys(name)\n",
    "\n",
    "        payment_.click()\n",
    "\n",
    "        checkin_date = pd.to_datetime(row['Check-in date'], dayfirst=True).strftime('%d/%m/%Y')\n",
    "        checkout_date = pd.to_datetime(row['Check-out date'], dayfirst=True).strftime('%d/%m/%Y')\n",
    "        al_number = '138454/AL'\n",
    "        address = 'RUA DE MARVILA N 54 R/C E 1950-199 LISBOA'\n",
    "        description = f'Prestação de serviços de alojamento mobilado para turistas, da data {checkin_date} a {checkout_date}, no AL {al_number}, sito na morada: {address}'\n",
    "        description_.send_keys(description)\n",
    "\n",
    "        iva = 'Continente - 6% [taxa reduzida atual]'\n",
    "        iva_.send_keys(iva)\n",
    "\n",
    "        incidencia = 'Sem retenção - Art.101º, n.º1 do CIRS'\n",
    "        incidencia_.send_keys(incidencia)\n",
    "\n",
    "        amount = float(amount)\n",
    "        amount = round(amount/1.06, 2) # Remove the 6% VAT\n",
    "        amount = str(amount)\n",
    "        amount_.send_keys(amount)\n",
    "\n",
    "        selo = '0'\n",
    "        selo_.send_keys(selo)\n",
    "        time.sleep(2)\n",
    "\n",
    "        callback(\"Submitting the invoice (first button)...\")\n",
    "        first_emitir_ = web.find_element(By.XPATH, '//*[@id=\"main-content\"]/div/div/emitir-app/emitir-form/div[1]/div[1]/div[1]/div[1]/div[3]/button')\n",
    "        # first_emitir_.click()\n",
    "        time.sleep(2)\n",
    "\n",
    "        callback(\"Submitting the invoice (second button)...\")\n",
    "        second_emitir_ = web.find_element(By.XPATH, '//*[@id=\"emitirModal\"]/div/div/div[3]/button[2]')\n",
    "        # second_emitir_.click()\n",
    "        time.sleep(2)\n",
    "\n",
    "        message = 'Invoice Completed'\n",
    "\n",
    "        print(message)\n",
    "\n",
    "    except Exception as e:\n",
    "\n",
    "        print(f\"Error: {e}\")\n",
    "        message = e\n",
    "    \n",
    "    return message\n",
    "\n",
    "# Get the form responses\n",
    "checkout_date = '01-04-2024'\n",
    "clean_df = data_processing.clean_sheet()\n",
    "filtered_df = data_processing.filter_df_on_checkout_date(clean_df, checkout_date)\n",
    "amount = '393.33'\n",
    "\n",
    "fill_in_invoice(callback, filtered_df, amount)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "import os\n",
    "import pandas as pd\n",
    "import json\n",
    "from selenium import webdriver\n",
    "from selenium.webdriver.common.keys import Keys\n",
    "from selenium.webdriver.chrome.options import Options\n",
    "from selenium.webdriver.common.by import By\n",
    "from selenium.webdriver.support.ui import WebDriverWait\n",
    "from selenium.webdriver.support import expected_conditions as EC\n",
    "from selenium.webdriver.common.action_chains import ActionChains\n",
    "import time\n",
    "from scripts import google_api, web_automation, data_processing\n",
    "from dotenv import load_dotenv\n",
    "\n",
    "# Load environment variables from a .env file located in the same directory as this script\n",
    "load_dotenv()\n",
    "pdf_nif = os.getenv('PDF_NIF')\n",
    "pdf_senha = os.getenv('PDF_SENHA')\n",
    "\n",
    "# Extract the mapping files\n",
    "countries_mapping = os.path.join(os.getcwd(), 'parameters', 'countries_mapping.json')\n",
    "nationalities_mapping = os.path.join(os.getcwd(), 'parameters', 'nationalities_mapping.json')\n",
    "\n",
    "def fill_in_invoice(filtered_df, amount, date=None, invoice_nif=None):\n",
    "\n",
    "    if filtered_df.empty:\n",
    "        print('Data provided is empty.')\n",
    "        message = 'Data provided is empty.'\n",
    "        return message\n",
    "    \n",
    "    # Extract info from df\n",
    "    row = filtered_df.iloc[0]\n",
    "    if not date:\n",
    "        date = pd.to_datetime(row['Check-out date'], dayfirst=True).strftime('%Y-%m-%d')\n",
    "    else:\n",
    "        date = date.strftime('%Y-%m-%d')\n",
    "\n",
    "    try:\n",
    "\n",
    "        with open(countries_mapping) as f:\n",
    "            countries = json.load(f)\n",
    "\n",
    "        web = webdriver.Chrome()\n",
    "\n",
    "        url = r'https://irs.portaldasfinancas.gov.pt/recibos/portal/emitir/emitirDocumentos'\n",
    "        web.get(url)\n",
    "\n",
    "        time.sleep(2)\n",
    "\n",
    "        # Find the label element by its text content (assuming \"NIF\" is the text)\n",
    "        label_element = web.find_element(By.XPATH, \"//label[span='NIF']\")\n",
    "\n",
    "        # Click the label element to perform the action\n",
    "        label_element.click()\n",
    "\n",
    "        time.sleep(1)\n",
    "\n",
    "        # Find and fill in the input fields\n",
    "        nif = web.find_element('id', 'username')\n",
    "        senha = web.find_element('id', 'password-nif')\n",
    "\n",
    "        nif.send_keys(pdf_nif)\n",
    "        senha.send_keys(pdf_senha)\n",
    "\n",
    "        # Locate and click the submit button\n",
    "        submit_button = web.find_element('id', 'sbmtLogin')\n",
    "        submit_button.click()\n",
    "\n",
    "        time.sleep(2)\n",
    "\n",
    "        # Input date and type of invoice\n",
    "        date_ = web.find_element(By.XPATH, '//*[@id=\"main-content\"]/div/div/emitir-documentos-app-v2/emitir-documentos-form-v2/div[1]/div[2]/div/div/div/div[3]/div/div[1]/lf-date/div/div[1]/input')\n",
    "        date_.send_keys(date)\n",
    "\n",
    "        type_ = web.find_element(By.XPATH, '//*[@id=\"main-content\"]/div/div/emitir-documentos-app-v2/emitir-documentos-form-v2/div[1]/div[2]/div/div/div/div[3]/div/div[2]/lf-dropdown/div/select')\n",
    "        type_.send_keys('Fatura-Recibo')\n",
    "\n",
    "        emitir_button = web.find_element(By.XPATH, '//*[@id=\"main-content\"]/div/div/emitir-documentos-app-v2/emitir-documentos-form-v2/div[1]/div[2]/div/div/div/div[3]/div/div[3]/button')\n",
    "        emitir_button.click()        \n",
    "\n",
    "        time.sleep(2)\n",
    "\n",
    "        # Get all fields\n",
    "        country_ = web.find_element(By.XPATH, '//*[@id=\"main-content\"]/div/div/emitir-app/emitir-form/div[1]/div[2]/div/dados-adquirente/div/div[2]/div[1]/div[1]/lf-dropdown/div/select')\n",
    "        name_ = web.find_element(By.XPATH, '//*[@id=\"main-content\"]/div/div/emitir-app/emitir-form/div[1]/div[2]/div/dados-adquirente/div/div[2]/div[2]/div/lf-text/div/input')\n",
    "        payment_ = web.find_element(By.XPATH, '//*[@id=\"main-content\"]/div/div/emitir-app/emitir-form/div[1]/div[2]/div/dados-transmissao/div/div[2]/div[1]/pf-radio/div/div[1]/label/input')\n",
    "        description_ = web.find_element(By.XPATH, '//*[@id=\"main-content\"]/div/div/emitir-app/emitir-form/div[1]/div[2]/div/dados-transmissao/div/div[2]/div[2]/div/textarea')\n",
    "        iva_ = web.find_element(By.XPATH, '//*[@id=\"main-content\"]/div/div/emitir-app/emitir-form/div[1]/div[2]/div/dados-transmissao/div/div[2]/div[6]/div/div[1]/lf-dropdown/div/select')\n",
    "        incidencia_ = web.find_element(By.XPATH, '//*[@id=\"main-content\"]/div/div/emitir-app/emitir-form/div[1]/div[2]/div/dados-transmissao/div/div[2]/div[7]/div[1]/div/lf-dropdown/div/select')\n",
    "        amount_ = web.find_element(By.XPATH, '//*[@id=\"main-content\"]/div/div/emitir-app/emitir-form/div[1]/div[2]/div/dados-transmissao/div/div[2]/div[4]/div/div/div/input')\n",
    "        selo_ = web.find_element(By.XPATH, '//*[@id=\"main-content\"]/div/div/emitir-app/emitir-form/div[1]/div[2]/div/dados-transmissao/div/div[2]/div[8]/div/div/div/input')\n",
    "        first_emitir_ = web.find_element(By.XPATH, '//*[@id=\"main-content\"]/div/div/emitir-app/emitir-form/div[1]/div[1]/div[1]/div[1]/div[3]/button')\n",
    "        second_emitir_ = web.find_element(By.XPATH, '//*[@id=\"emitirModal\"]/div/div/div[3]/button[2]')\n",
    "\n",
    "        # Write in fields\n",
    "        country = countries[row['Country of residence']]\n",
    "        country_.send_keys(country)\n",
    "\n",
    "        if country.lower() == 'portugal':\n",
    "            nif_ = web.find_element(By.XPATH, '//*[@id=\"main-content\"]/div/div/emitir-app/emitir-form/div[1]/div[2]/div/dados-adquirente/div/div[2]/div[1]/div[3]/lf-nif/div/input')\n",
    "            nif_.send_keys(invoice_nif)\n",
    "        else:\n",
    "            passport_ = web.find_element(By.XPATH, '//*[@id=\"main-content\"]/div/div/emitir-app/emitir-form/div[1]/div[2]/div/dados-adquirente/div/div[2]/div[1]/div[2]/lf-text/div/input')\n",
    "            passport = row['Passport (or ID) number']\n",
    "            passport_.send_keys(passport)\n",
    "\n",
    "        name = row['First name'] + ' ' + row['Last name']\n",
    "        name_.send_keys(name)\n",
    "\n",
    "        payment_.click()\n",
    "\n",
    "        checkin_date = pd.to_datetime(row['Check-in date'], dayfirst=True).strftime('%d/%m/%Y')\n",
    "        checkout_date = pd.to_datetime(row['Check-out date'], dayfirst=True).strftime('%d/%m/%Y')\n",
    "        al_number = '138454/AL'\n",
    "        address = 'RUA DE MARVILA N 54 R/C E 1950-199 LISBOA'\n",
    "        description = f'Prestação de serviços de alojamento mobilado para turistas, da data {checkin_date} a {checkout_date}, no AL {al_number}, sito na morada: {address}'\n",
    "        description_.send_keys(description)\n",
    "\n",
    "        iva = 'Continente - 6% [taxa reduzida atual]'\n",
    "        iva_.send_keys(iva)\n",
    "\n",
    "        incidencia = 'Sem retenção - Art.101º, n.º1 do CIRS'\n",
    "        incidencia_.send_keys(incidencia)\n",
    "\n",
    "        amount = float(amount)\n",
    "        amount = round(amount/1.06, 2) # Remove the 6% VAT\n",
    "        amount = str(amount)\n",
    "        amount_.send_keys(amount)\n",
    "\n",
    "        selo = '0'\n",
    "        selo_.send_keys(selo)\n",
    "\n",
    "        time.sleep(2)\n",
    "\n",
    "        # first_emitir_.click()\n",
    "\n",
    "        # time.sleep(2)\n",
    "\n",
    "        # second_emitir_.click()\n",
    "        \n",
    "        time.sleep(10)\n",
    "\n",
    "        message = 'Invoice Completed'\n",
    "\n",
    "        print(message)\n",
    "\n",
    "    except Exception as e:\n",
    "\n",
    "        print(f\"Error: {e}\")\n",
    "        message = e\n",
    "    \n",
    "    return message\n",
    "\n",
    "# Get the form responses\n",
    "checkout_date = '01-04-2024'\n",
    "clean_df = data_processing.clean_sheet()\n",
    "filtered_df = data_processing.filter_df_on_checkout_date(clean_df, checkout_date)\n",
    "\n",
    "amount = '393.33'\n",
    "\n",
    "# fill_in_invoice(filtered_df, amount)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Please visit this URL to authorize this application: https://accounts.google.com/o/oauth2/auth?response_type=code&client_id=997149058913-gs5122uc033sk42ohidnjs9pvfdhjsik.apps.googleusercontent.com&redirect_uri=http%3A%2F%2Flocalhost%3A50994%2F&scope=https%3A%2F%2Fwww.googleapis.com%2Fauth%2Fgmail.readonly&state=T9WBxBFd6jEnOmd1H4PqhnJwXq90ZE&access_type=offline\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "'s3://your-casinha/emails.json'"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "from scripts import google_api\n",
    "\n",
    "google_api.get_emails()"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.11.4"
  },
  "orig_nbformat": 4
 },
 "nbformat": 4,
 "nbformat_minor": 2
}