app.py

import streamlit as st
import pandas as pd
import requests
from datetime import datetime
import pytz

# SheetDB API Endpoint for Timecard Data
SHEETDB_API_URL_TIMECARD = "https://sheetdb.io/api/v1/jsh4nri7t8rko"  # Replace with your SheetDB API URL for timecard

# Define password
PASSWORD = "ma_12345"  # Replace with your desired password

# Hardcoded Metadata
METADATA = {
    "Employee Names": [
        "Ubaid Bashir", "Shoaib Ahmad", "Rumaan Hassan Alamgeer",
        "Sana Sanaullah", "Aafreen Mushtaq", "Andleeb Gul", "Irtika", "Sahil","Muhammad Areeb Bhat"
    ],
    "Project Names": [
        "ICCL", "Reston", "Clermont", "Dale", "Pulaski", "NISA",
        "BAC", "Church", "Bishop", "Paramount", "Preng", "Misc.", "Marketing",
        "Ridge road", "Irving Street", "Bayfield road", "Bishops road", "Dale Dr",
        "Brook Dr", "Cpmi Church", "Dual Hwy", "Rhode Island Ave", "College plaza redevelopment",
        "Pulaski hwy", "Sonoma road", "Ridge PI", "Broad Street", "Hardy Dr",
        "22nd street N", "Clue Dr", "Clermont Ave"
    ],
    "Project Codes": [
        "US 001", "US 003", "US 004", "US 005", "US 006", "US 007",
        "US 008", "US 009", "US 010", "IND 001", "IND 007", "IND 008", "US 011",
        "USA_01", "USA_02", "USA_03", "USA_04", "USA_05",
        "USA_06", "USA_07", "USA_08", "USA_09", "USA_10",
        "USA_11", "USA_12", "USA_13", "USA_14", "USA_15",
        "USA_16", "USA_17", "USA_18"
    ]
}


# Load timecard data from SheetDB
def load_data():
    response = requests.get(SHEETDB_API_URL_TIMECARD)
    if response.status_code == 200:
        return pd.DataFrame(response.json())
    else:
        return pd.DataFrame(columns=["Employee Name", "Project Name", "Project Code", "Date", "Hours", "Notes"])

# Save timecard data to SheetDB
def save_data(employee_name, project_name, project_code, hours, notes):
    # Automatically set the date to the current date


    ist = pytz.timezone('Asia/Kolkata')
    ist_now = datetime.now(ist)
    
    # Format to get only the date
    formatted_date = ist_now.date().isoformat()

    
    new_entry = {
        "Employee Name": employee_name,
        "Project Name": project_name,
        "Project Code": project_code,
        "Date": formatted_date,
        "Hours": hours,
        "Notes": notes
    }
    response = requests.post(SHEETDB_API_URL_TIMECARD, json=new_entry)
    if response.status_code == 201:
        st.success("Entry added successfully!")
    else:
        st.error("Failed to add entry. Please try again.")

# Custom Cyberpunk CSS (Less Glowy)
st.markdown(
    """
    <style>
    /* General Styling */
    body {
        background-color: #000000;
        color: #00FF00;
        font-family: 'Courier New', monospace;
    }
    h1, h2, h3, h4, h5, h6 {
        color: #00FF00;
        font-family: 'Courier New', monospace;
    }
    .stButton button {
        background-color: #00FF00;
        color: #000000;
        border: 2px solid #00FF00;
        border-radius: 5px;
        font-family: 'Courier New', monospace;
        font-weight: bold;
    }
    .stButton button:hover {
        background-color: #000000;
        color: #00FF00;
        border: 2px solid #00FF00;
    }
    .stTextInput input, .stSelectbox select, .stDateInput input, .stNumberInput input, .stTextArea textarea {
        background-color: #000000;
        color: #00FF00;
        border: 2px solid #00FF00;
        font-family: 'Courier New', monospace;
    }
    .stDataFrame {
        background-color: #000000;
        color: #00FF00;
        border: 2px solid #00FF00;
    }
    .stSidebar {
        background-color: #000000;
        color: #00FF00;
        border-right: 2px solid #00FF00;
    }
    .stMarkdown {
        color: #00FF00;
    }
    /* Reduced Neon Glow Effect */
    .neon-text {
        color: #00FF00;
        text-shadow: 0 0 3px #00FF00, 0 0 5px #00FF00;
    }
    .neon-border {
        border: 2px solid #00FF00;
        box-shadow: 0 0 3px #00FF00, 0 0 5px #00FF00;
    }
    </style>
    """,
    unsafe_allow_html=True
)

# Password authentication
if "authenticated" not in st.session_state:
    st.session_state.authenticated = False

if not st.session_state.authenticated:
    st.markdown("<h1 class='neon-text' style='text-align: center;'>Munshi Associates Dashboard</h1>", unsafe_allow_html=True)
    st.markdown("<p class='neon-text'>Please enter the password to access the application.</p>", unsafe_allow_html=True)
    password = st.text_input("Password", type="password")

    if st.button("Login"):
        if password == PASSWORD:
            st.session_state.authenticated = True
            st.success("Login successful!")
        else:
            st.error("Incorrect password. Please try again.")
else:
    # Display company logo and title in the sidebar
    st.sidebar.image("ma_logo.png")  # Replace with your logo
    st.sidebar.markdown("<h1 class='neon-text'>Munshi Associates Dashboard</h1>", unsafe_allow_html=True)
    st.sidebar.markdown("<p class='neon-text'>Employee Timecard Management System</p>", unsafe_allow_html=True)

    # Main section
    st.markdown("<h1 class='neon-text'>Employee Time Card Management</h1>", unsafe_allow_html=True)
    st.markdown("<p class='neon-text'>Welcome to the <strong>Munshi Associates Time Card Management System</strong></p>", unsafe_allow_html=True)

    # Load metadata (hardcoded)
    employee_names = METADATA["Employee Names"]
    project_names = METADATA["Project Names"]
    project_codes = METADATA["Project Codes"]

    # Form for adding timecard entries
    st.markdown("<h3 class='neon-text'>Add Timecard Entry</h3>", unsafe_allow_html=True)
    with st.form("timecard_form"):
        st.markdown("<p class='neon-text'>Fill out the form below to add a new entry.</p>", unsafe_allow_html=True)
        col1, col2 = st.columns(2)
        with col1:
            employee_name = st.selectbox("Select Employee Name", employee_names)
            project_name = st.selectbox("Select Project Name", project_names)
            project_code = st.selectbox("Select Project Code", project_codes)
        with col2:
            hours = st.number_input("Hours Worked", min_value=0.0, step=0.5)
            notes = st.text_area("Notes", placeholder="Add any relevant notes here...")

        submitted = st.form_submit_button("Add Entry")
        if submitted:
            save_data(employee_name, project_name, project_code, hours, notes)

    # Display existing timecard data
    st.markdown("<h3 class='neon-text'>Existing Time Card Data</h3>", unsafe_allow_html=True)
    data = load_data()
    st.dataframe(data, use_container_width=True)

    # Option to download the data
    st.markdown("<h3 class='neon-text'>Download Time Card Data</h3>", unsafe_allow_html=True)
    st.download_button(
        label="Download CSV",
        data=data.to_csv(index=False),
        file_name="timecard_data.csv",
        mime="text/csv"
    )