Update app.py

app.py

@@ -5,10 +5,9 @@ import requests
 import os
 from datetime import datetime
 
-# Set page configuration (must be the first Streamlit command)
 st.set_page_config(page_title="Ticket System", layout="centered", initial_sidebar_state="expanded")
 
-# Apply custom CSS for design
+# CSS 
 st.markdown(
     """
         <style>
@@ -77,7 +76,6 @@ st.markdown(
     unsafe_allow_html=True
 )
 
-# Sample user data for login
 users = {
     "manager123": {"password": "managerpass", "role": "Manager"},
     "employee456": {"password": "employeepass", "role": "Employee"},
@@ -85,7 +83,6 @@ users = {
 }
 
 def login_page():
-    # Add custom styling and an image at the top
     customize_login_page()
     st.markdown(
         """
@@ -108,7 +105,7 @@ def login_page():
     username = st.text_input("Username")
     password = st.text_input("Password", type="password")
 
-    # Check login state
+    #Check login state
     if "login_success" not in st.session_state:
         st.session_state["login_success"] = False
 
@@ -142,9 +139,9 @@ def login_page():
 
 
 
-    col1, col2, col3 = st.columns(3)  # Create three columns
+    col1, col2, col3 = st.columns(3)  
 
-    with col1:  # First column for the Login button
+    with col1:  
         if st.button("Login"):
             if username in users and users[username]["password"] == password:
                 st.session_state["user_type"] = users[username]["role"]
@@ -153,7 +150,6 @@ def login_page():
 
                 st.success(f"Logged in successfully as {users[username]['role']}")
 
-                # Navigate to the appropriate page based on the user's role
                 if users[username]["role"] == "Customer":
                     st.session_state["page"] = "Submit Ticket"
                 elif users[username]["role"] == "Manager":
@@ -163,31 +159,29 @@ def login_page():
             else:
                 st.error("Invalid username or password.")
 
-    with col2:  # Second column for the Forget Password button
+    with col2:  
         if st.button("Forget Password"):
             st.session_state["page"] = "Forget Password"
 
-    with col3:  # Third column for the Create Account button
+    with col3:  
         if st.button("Create an Account"):
             st.session_state["page"] = "Create Account"
 
 
             
 def navigate_to_page(page_name):
-    st.session_state["current_page"] = page_name  # Update the page in session state
+    st.session_state["current_page"] = page_name  
 
 def get_current_page():
-    return st.session_state.get("current_page", "Login")  # Default to "Login"
+    return st.session_state.get("current_page", "Login")  
 
 def forget_password_page():
-    # Page title and instructions
     st.markdown('<h1 style="color: #084C3C; text-align: center;">Forget Password</h1>', unsafe_allow_html=True)
     st.markdown('<p style="color: #084C3C; text-align: center;">Enter your username or email to reset your password.</p>', unsafe_allow_html=True)
 
-    # Input field for username or email
     username_or_email = st.text_input("Username or Email")
 
-    # Custom button styling
+    #Custom button styling
     st.markdown(
         """
         <style>
@@ -216,14 +210,12 @@ def forget_password_page():
         unsafe_allow_html=True,
     )
 
-    # Reset Password button
     if st.button("Reset Password"):
         if username_or_email.strip():
             st.success(f"Password reset link has been sent to {username_or_email}.")
         else:
             st.error("Please enter a valid username or email.")
 
-    # Back to Login button
     if st.button("Back to Login"):
         st.session_state["page"] = "Login"  # Navigate back to Login
 
@@ -231,7 +223,6 @@ def forget_password_page():
 
 def add_return_to_login():
     if "logged_in" in st.session_state and st.session_state["logged_in"]:
-        # Add custom styling for the Back button
         st.markdown(
             """
             <style>
@@ -260,9 +251,7 @@ def add_return_to_login():
             unsafe_allow_html=True,
         )
 
-        # Functional and visually styled "Back" button
         if st.sidebar.button("Back"):
-            # Reset the 'logged_in' state and force a redirect to the login page
             st.session_state["logged_in"] = False; st.session_state["login_success"] = False; st.session_state["page"] = "Login"
             hide_sidebar()
             
@@ -280,11 +269,10 @@ def hide_sidebar():
 
 def main():
     if "page" not in st.session_state:
-        st.session_state["page"] = "Login"  # Default to the Login page
+        st.session_state["page"] = "Login"  
     add_return_to_login()
     if st.session_state["page"] == "Submit Ticket":
         submit_ticket_page()
-    # Show the navigation menu only if not on Login or Forget Password pages
     if st.session_state["page"] not in ["Login", "Forget Password","Create Account"]:
         st.sidebar.title("Navigation")
         user_type = st.session_state.get("user_type", "Customer")
@@ -298,9 +286,8 @@ def main():
         else:
             st.sidebar.write("No pages available for this user type.")
             return
-        st.session_state["page"] = page  # Update the page state based on navigation
+        st.session_state["page"] = page  
 
-    # Render the appropriate page
     if st.session_state["page"] == "Login":
         login_page()
     elif st.session_state["page"] == "Forget Password":
@@ -325,14 +312,13 @@ def main():
         employee_ticket_status_page()
 
 def center_logo():
-    # Create three columns
-    col1, col2, col3 = st.columns([1, 2, 1])  # Adjust column width ratios
+    col1, col2, col3 = st.columns([1, 2, 1]) 
 
     with col1:
-        st.empty()  # Empty content in the first column
+        st.empty()  
 
     with col2:
-        st.image("logo.png", width=300, use_container_width=True)
+        st.image("/Users/klnimri/Desktop/Newtest/Test/bin/logo.png", width=300, use_container_width=True)
 
     with col3:
         st.empty()
@@ -461,8 +447,9 @@ def submit_ticket_page():
     st.markdown('<h1 style="color: #084C3C;">Submit a Ticket</h1>', unsafe_allow_html=True)
     st.markdown('<p style="color: #084C3C;">Please fill out the form below to submit a ticket.</p>', unsafe_allow_html=True)
 
-    # Form for submitting a ticket
-    with st.form(key="submit_ticket_form"):
+    unique_form_key = f"submit_ticket_form_{st.session_state.get('page', 'default')}"  
+
+    with st.form(key=unique_form_key):
         customer_id = st.text_input("Customer ID")
         st.text_input("First Name")
         st.text_input("Last Name")
@@ -473,7 +460,6 @@ def submit_ticket_page():
         st.text_area("Describe your issue/request")
         st.file_uploader("Upload Attachments (if any)", accept_multiple_files=True)
         
-        # Add custom styling for the Submit button
         st.markdown(
             """
             <style>
@@ -502,7 +488,6 @@ def submit_ticket_page():
             unsafe_allow_html=True,
         )
 
-        # Submit button logic
         if st.form_submit_button("Submit"):
             if customer_id.strip():
                 st.success(f"Your ticket has been submitted successfully. Customer ID: {customer_id}")
@@ -522,13 +507,12 @@ def check_ticket_status_page():
     st.markdown('<h1 style="color: #084C3C;">Check Ticket Status</h1>', unsafe_allow_html=True)
     st.markdown('<p style="color: #084C3C;">Enter your Customer ID to view your tickets.</p>', unsafe_allow_html=True)
 
-    # Input field for Customer ID
     customer_id = st.text_input("Customer ID")
 
     # Check ticket status submission state
     if "customer_check_status_success" not in st.session_state:
         st.session_state["customer_check_status_success"] = False
-
+        
     # Add custom styling for the Check Status button
     st.markdown(
         """
@@ -729,9 +713,62 @@ def ticket_dashboard_page():
     vspace()
     vspace()
     st.markdown('<h1 style="color: #084C3C;">Ticket Dashboard</h1>', unsafe_allow_html=True)
+
+    # Sample ticket data
+    ticket_data = {
+        "Ticket Number": ["141", "565", "999"],
+        "Type": ["General", "Billing", "Technical"],
+        "Status": ["Pending", "Pending", "In Progress"],
+        "Assigned To": ["E001", "E002", "E003"],
+    }
+    df_tickets = pd.DataFrame(ticket_data)
+
+    # Display ticket data
+    st.markdown('<h2 style="color: #084C3C;">Tickets Overview</h2>', unsafe_allow_html=True)
+    st.dataframe(df_tickets)
+
+    # Add a section for ticket reassignment
+    st.markdown('<h2 style="color: #084C3C;">Reassign a Ticket</h2>', unsafe_allow_html=True)
+    
+    # Dropdown to select a ticket to reassign
+    ticket_to_reassign = st.selectbox("Select a ticket to reassign:", df_tickets["Ticket Number"].tolist())
+    
+    # Define employee data
+    employee_data = {
+        "Employee ID": ["E001", "E002", "E003"],
+        "Name": ["John Doe", "Jane Smith", "Ali Ahmad"],
+        "Department": ["Support", "Billing", "Technical"],
+    }
+    df_employee = pd.DataFrame(employee_data)
+
+    # Option to select an employee by dropdown or enter Employee ID manually
+    st.markdown('<p style="color: #084C3C;">Select an employee to assign the ticket:</p>', unsafe_allow_html=True)
+    assign_option = st.radio("Choose assignment method:", ["Select from Dropdown", "Enter Employee ID"])
+
+    if assign_option == "Select from Dropdown":
+        # Dropdown list with Employee Full Name + Department
+        employee_dropdown = st.selectbox(
+            "Select an employee:",
+            df_employee.apply(lambda row: f"{row['Name']} - {row['Department']} (ID: {row['Employee ID']})", axis=1)
+        )
+        # Extract Employee ID from the selected dropdown value
+        selected_employee_id = employee_dropdown.split("(ID: ")[-1].strip(")")
+
+    elif assign_option == "Enter Employee ID":
+        selected_employee_id = st.text_input("Enter Employee ID:")
+
+    # Button to confirm reassignment
+    if st.button("Reassign Ticket"):
+        if selected_employee_id.strip():
+            st.success(f"Ticket {ticket_to_reassign} has been successfully reassigned to Employee ID: {selected_employee_id}.")
+        else:
+            st.error("Please select or enter a valid Employee ID.")
+
+    # Add the Power BI dashboard iframe
+    st.markdown('<h2 style="color: #084C3C;">Dashboard Insights</h2>', unsafe_allow_html=True)
     st.components.v1.iframe(
         "https://app.powerbi.com/view?r=eyJrIjoiMDEwNzA2YjUtNGY0MC00NTFjLTg1ZTctYTZlZjQzOTUwNWUxIiwidCI6ImI0NTNkOTFiLTZhYzEtNGI2MS1iOGI4LTVlNjVlNDIyMjMzZiIsImMiOjl9",
-        height=700,
+        height=800,
         width=1000,
         scrolling=True
     )
@@ -744,13 +781,66 @@ def customer_dashboard_page():
     vspace()
     vspace()
     st.markdown('<h1 style="color: #084C3C;">Customer Dashboard</h1>', unsafe_allow_html=True)
+
+    # Define customer and ticket data
     customer_data = {
+        "Customer ID": ["C001", "C002", "C003"],
+        "Name": ["Alice", "Bob", "Charlie"],
+        "ID Number / Iqama Number": ["1234567890", "9876543210", "5678901234"],
+    }
+    df_customers = pd.DataFrame(customer_data)
+
+    ticket_data = {
+        "Ticket Number": ["141", "565", "999", "200", "345"],
+        "Customer ID": ["C001", "C002", "C003", "C001", "C003"],
+        "Type": ["General", "Billing", "Technical", "General", "Technical"],
+        "Status": ["Resolved", "Pending", "In Progress", "Resolved", "Closed"],
+        "Response": ["Issue fixed", "Pending customer reply", "Working on it", "Completed", "Closed successfully"],
+        "Assigned To": ["E001", "E002", "E003", "E001", "E003"],
+    }
+    df_tickets = pd.DataFrame(ticket_data)
+
+    # Search for a specific customer
+    st.markdown('<h2 style="color: #084C3C;">Search for a Customer</h2>', unsafe_allow_html=True)
+    
+    # Input field for ID Number / Iqama Number
+    search_customer_id = st.text_input("Enter Customer ID Number / Iqama Number:")
+
+    # Button to display customer tickets
+    if st.button("Search"):
+        # Find the customer based on ID Number / Iqama Number
+        customer_row = df_customers[df_customers["ID Number / Iqama Number"] == search_customer_id]
+        
+        if not customer_row.empty:
+            customer_id = customer_row["Customer ID"].values[0]
+            customer_name = customer_row["Name"].values[0]
+
+            # Filter tickets for the selected customer
+            customer_tickets = df_tickets[df_tickets["Customer ID"] == customer_id]
+
+            if not customer_tickets.empty:
+                st.markdown(
+                    f"<h3 style='color: #084C3C;'>Tickets filed by {customer_name} (Customer ID: {customer_id})</h3>",
+                    unsafe_allow_html=True
+                )
+                st.dataframe(customer_tickets)
+            else:
+                st.warning(f"No tickets found for Customer ID: {customer_id}")
+        else:
+            st.error("Customer not found. Please enter a valid ID Number / Iqama Number.")
+
+    # Add general customer stats for context
+    st.markdown('<h2 style="color: #084C3C;">Customer Overview</h2>', unsafe_allow_html=True)
+    customer_stats = {
         "Customer ID": ["C001", "C002", "C003"],
         "Tickets Submitted": [5, 3, 8],
         "Resolved": [4, 2, 7],
     }
-    df = pd.DataFrame(customer_data)
-    st.dataframe(df)
+    df_customer_stats = pd.DataFrame(customer_stats)
+    st.dataframe(df_customer_stats)
+
+    # Add Power BI dashboard insights
+    st.markdown('<h2 style="color: #084C3C;">Dashboard Insights</h2>', unsafe_allow_html=True)
     st.components.v1.iframe(
         "https://app.powerbi.com/view?r=eyJrIjoiOThhNGJkY2ItODUyZC00Y2UyLWJkYzQtYjdhZGVhOWI1ZWM5IiwidCI6ImI0NTNkOTFiLTZhYzEtNGI2MS1iOGI4LTVlNjVlNDIyMjMzZiIsImMiOjl9",
         height=600,
@@ -764,21 +854,67 @@ def management_dashboard_page():
     vspace()
     vspace()
     vspace()
-    #center_logo("logo.png")  # Center the logo
     st.markdown('<h1 style="color: #084C3C;">Management Dashboard</h1>', unsafe_allow_html=True)
     
     # Define employee data
     employee_data = {
         "Employee ID": ["E001", "E002", "E003"],
         "Name": ["John Doe", "Jane Smith", "Ali Ahmad"],
+        "Department": ["Support", "Billing", "Technical"],
         "Performance Score": [85, 90, 88],
     }
     df_employee = pd.DataFrame(employee_data)
     
     # Display the employee data table
+    st.markdown('<h2 style="color: #084C3C;">Employee Overview</h2>', unsafe_allow_html=True)
     st.dataframe(df_employee)
 
+    # Add search functionality for specific employees
+    st.markdown('<h2 style="color: #084C3C;">Search for an Employee</h2>', unsafe_allow_html=True)
+    
+    # Option to search by Employee ID or Dropdown List
+    search_option = st.radio("Search by:", ["Employee ID", "Dropdown"])
+    
+    if search_option == "Employee ID":
+        search_employee_id = st.text_input("Enter Employee ID:")
+    else:
+        # Dropdown list with Employee Full Name + Department
+        search_employee = st.selectbox(
+            "Select an employee:",
+            df_employee.apply(lambda row: f"{row['Name']} - {row['Department']} (ID: {row['Employee ID']})", axis=1)
+        )
+        # Extract Employee ID from the selected dropdown value
+        search_employee_id = search_employee.split("(ID: ")[-1].strip(")")
+
+    # Example ticket data
+    ticket_data = {
+        "Ticket Number": ["141", "565", "999", "200", "345"],
+        "Type": ["General", "Billing", "Technical", "General", "Technical"],
+        "Status": ["Resolved", "Pending", "In Progress", "Resolved", "Closed"],
+        "Response": ["Issue fixed", "Pending customer reply", "Working on it", "Completed", "Closed successfully"],
+        "Assigned To": ["E001", "E002", "E003", "E001", "E003"],
+    }
+    df_tickets = pd.DataFrame(ticket_data)
+
+    # Button to display employee tickets
+    if st.button("Search"):
+        if search_employee_id.strip():
+            # Filter tickets for the selected employee
+            filtered_tickets = df_tickets[df_tickets["Assigned To"] == search_employee_id]
+            
+            if not filtered_tickets.empty:
+                st.markdown(
+                    f"<h3 style='color: #084C3C;'>Tickets worked on by Employee ID: {search_employee_id}</h3>",
+                    unsafe_allow_html=True
+                )
+                st.dataframe(filtered_tickets)
+            else:
+                st.warning(f"No tickets found for Employee ID: {search_employee_id}")
+        else:
+            st.error("Please provide a valid Employee ID or select an employee.")
+
     # Add the Power BI dashboard iframe
+    st.markdown('<h2 style="color: #084C3C;">Dashboard Insights</h2>', unsafe_allow_html=True)
     st.components.v1.iframe(
         "https://app.powerbi.com/view?r=eyJrIjoiMzQ5N2RlMDQtY2I5ZC00NWE5LWE0ZjItMjExMzgyNmNmZWFjIiwidCI6ImI0NTNkOTFiLTZhYzEtNGI2MS1iOGI4LTVlNjVlNDIyMjMzZiIsImMiOjl9",
         height=800,
@@ -865,8 +1001,6 @@ def customize_submit_button():
     )
 
 
-
-
 if __name__ == "__main__":
     customize_navigation_menu_dark_green()
     main()