Spaces:
Sleeping
Sleeping
| import streamlit as st | |
| import requests | |
| import streamlit_authenticator as stauth | |
| import datetime | |
| # ---------------- LOGIN SETUP ---------------- | |
| credentials = { | |
| "usernames": { | |
| "admin": { | |
| "name": "Admin", | |
| "password": "12345" # Replace with hashed password for security | |
| } | |
| } | |
| } | |
| authenticator = stauth.Authenticate(credentials, "app_home", "abcdef", cookie_expiry_days=1) | |
| name, auth_status, username = authenticator.login("Login", "main") | |
| if auth_status is False: | |
| st.error("Incorrect username/password") | |
| elif auth_status is None: | |
| st.warning("Enter your credentials") | |
| elif auth_status: | |
| authenticator.logout("Logout", "sidebar") | |
| st.title("Boiler Production Tracking") | |
| with st.form("entry_form"): | |
| customer_name = st.text_input("CUSTOMER NAME") | |
| boiler_no = st.text_input("BOILER NO") | |
| capacity_tph = st.number_input("CAPACITY IN TPH", min_value=0.0, step=0.1) | |
| material_offer_planned = st.date_input("MATERIAL OFFER PLANNED") | |
| material_offer_actual = st.date_input("MATERIAL OFFER ACTUAL") | |
| cutting_planned = st.date_input("CUTTING PLANNED") | |
| cutting_actual = st.date_input("CUTTING ACTUAL") | |
| rolling_planned = st.date_input("ROLLING PLANNED") | |
| rolling_actual = st.date_input("ROLLING ACTUAL") | |
| l_seam_rt_planned = st.date_input("L-SEAM RT PLANNED") | |
| l_seam_rt_actual = st.date_input("L-SEAM RT ACTUAL") | |
| c_seam_planned = st.date_input("C-SEAM PLANNED") | |
| c_seam_actual = st.date_input("C-SEAM ACTUAL") | |
| shell_ready_planned = st.date_input("SHELL READY PLANNED") | |
| shell_ready_actual = st.date_input("SHELL READY ACTUAL") | |
| test_plate_testing_planned = st.date_input("TEST PLATE TESTING PLANNED") | |
| test_plate_testing_actual = st.date_input("TEST PLATE TESTING ACTUAL") | |
| tube_plate_drilling_planned = st.date_input("TUBE PLATE DRILLING PLANNED") | |
| tube_plate_drilling_actual = st.date_input("TUBE PLATE DRILLING ACTUAL") | |
| material_shortage = st.text_area("MATERIAL SHORTAGE DETAILS") | |
| ftp_setup_planned = st.date_input("FTP SETUP PLANNED") | |
| ftp_setup_actual = st.date_input("FTP SETUP ACTUAL") | |
| nozzle_setup_planned = st.date_input("NOZZLE SETUP PLANNED") | |
| nozzle_setup_actual = st.date_input("NOZZLE SETUP ACTUAL") | |
| final_setup_planned = st.date_input("FINAL SETUP PLANNED") | |
| final_setup_actual = st.date_input("FINAL SETUP ACTUAL") | |
| full_welding_planned = st.date_input("FULL WELDING PLANNED") | |
| full_welding_actual = st.date_input("FULL WELDING ACTUAL") | |
| hydro_planned = st.date_input("HYDRO DATE PLANNED") | |
| hydro_actual = st.date_input("HYDRO DATE ACTUAL") | |
| customer_hydro_planned = st.date_input("CUSTOMER HYDRO DATE PLANNED") | |
| customer_hydro_actual = st.date_input("CUSTOMER HYDRO DATE ACTUAL") | |
| remark = st.text_area("REMARK") | |
| submitted = st.form_submit_button("Submit Data") | |
| if submitted: | |
| url = "https://script.google.com/a/macros/forbesmarshall.com/s/AKfycbyPTwzYNsy8D2M27O8ZZ90G1UYHP1aPExA_FX7VLh3iQquOt16Cc14tF7-xp8SGd1bE/exec" # Replace with your deployment URL | |
| payload = { | |
| "customer_name": customer_name, | |
| "boiler_no": boiler_no, | |
| "capacity_tph": capacity_tph, | |
| "material_offer_planned": str(material_offer_planned), | |
| "material_offer_actual": str(material_offer_actual), | |
| "cutting_planned": str(cutting_planned), | |
| "cutting_actual": str(cutting_actual), | |
| "rolling_planned": str(rolling_planned), | |
| "rolling_actual": str(rolling_actual), | |
| "l_seam_rt_planned": str(l_seam_rt_planned), | |
| "l_seam_rt_actual": str(l_seam_rt_actual), | |
| "c_seam_planned": str(c_seam_planned), | |
| "c_seam_actual": str(c_seam_actual), | |
| "shell_ready_planned": str(shell_ready_planned), | |
| "shell_ready_actual": str(shell_ready_actual), | |
| "test_plate_testing_planned": str(test_plate_testing_planned), | |
| "test_plate_testing_actual": str(test_plate_testing_actual), | |
| "tube_plate_drilling_planned": str(tube_plate_drilling_planned), | |
| "tube_plate_drilling_actual": str(tube_plate_drilling_actual), | |
| "material_shortage": material_shortage, | |
| "ftp_setup_planned": str(ftp_setup_planned), | |
| "ftp_setup_actual": str(ftp_setup_actual), | |
| "nozzle_setup_planned": str(nozzle_setup_planned), | |
| "nozzle_setup_actual": str(nozzle_setup_actual), | |
| "final_setup_planned": str(final_setup_planned), | |
| "final_setup_actual": str(final_setup_actual), | |
| "full_welding_planned": str(full_welding_planned), | |
| "full_welding_actual": str(full_welding_actual), | |
| "hydro_planned": str(hydro_planned), | |
| "hydro_actual": str(hydro_actual), | |
| "customer_hydro_planned": str(customer_hydro_planned), | |
| "customer_hydro_actual": str(customer_hydro_actual), | |
| "remark": remark | |
| } | |
| r = requests.post(url, json=payload) | |
| if r.status_code == 200: | |
| st.success("✅ Data added to Google Sheet successfully!") | |
| else: | |
| st.error("❌ Failed to send data. Please check the script URL.") |