| |
| from __future__ import annotations |
|
|
| from datetime import datetime, date, time |
|
|
| import pandas as pd |
| import streamlit as st |
|
|
| from analysis import read_excel_safe, build, get_pivots_for_ppt |
| from ppt_fill import fill_ppt |
|
|
| st.set_page_config(page_title="Reports 940", layout="centered") |
|
|
| VISION_URL = "https://huggingface.co/spaces/DAM20/Etmam/resolve/main/assets/vision2030_logo.png" |
| AMANAH_URL = "https://huggingface.co/spaces/DAM20/Etmam/resolve/main/assets/amanah_logo.png" |
| CENTER_URL = "https://huggingface.co/spaces/DAM20/Etmam/resolve/main/assets/center_logo.png" |
|
|
| page_css = """ |
| <style> |
| .stAppViewContainer { |
| position: relative; |
| background: linear-gradient(to bottom, #043548 0%, #02141e 55%, #01080c 100%); |
| background-attachment: fixed; |
| } |
| main .block-container { |
| max-width: 900px; |
| padding-top: 2rem !important; |
| } |
| [data-testid="stHeader"] { |
| background-color: rgba(0, 0, 0, 0); |
| } |
| .top-logos-wrapper { |
| display: flex; |
| flex-direction: column; |
| align-items: center; |
| justify-content: center; |
| margin-bottom: 1.2rem; |
| } |
| .vision-logo { |
| width: 280px; |
| height: auto; |
| } |
| .bottom-logos-row { |
| display: flex; |
| align-items: center; |
| justify-content: center; |
| column-gap: 25px; |
| margin-top: -5px; |
| } |
| .center-logo { |
| width: 270px; |
| height: auto; |
| } |
| .amanah-logo { |
| width: 200px; |
| height: auto; |
| } |
| h1 { |
| margin-top: 0.5rem !important; |
| color: white !important; |
| } |
| label, p, span { |
| color: white !important; |
| } |
| </style> |
| """ |
|
|
| st.markdown(page_css, unsafe_allow_html=True) |
|
|
| st.markdown( |
| f""" |
| <div class="top-logos-wrapper"> |
| <img src="{VISION_URL}" class="vision-logo" /> |
| <div class="bottom-logos-row"> |
| <img src="{CENTER_URL}" class="center-logo" /> |
| <img src="{AMANAH_URL}" class="amanah-logo" /> |
| </div> |
| </div> |
| """, |
| unsafe_allow_html=True, |
| ) |
|
|
| st.markdown("<h1>Reports 940</h1>", unsafe_allow_html=True) |
|
|
| uploaded_file = st.file_uploader("Upload file (Excel)", type=["xlsx"]) |
|
|
| col1, col2 = st.columns(2) |
| with col1: |
| d_closed = st.date_input("Date", value=date.today()) |
| with col2: |
| t_closed = st.time_input("Time", value=time(8, 0)) |
|
|
| CLOSED_DT = pd.Timestamp(datetime.combine(d_closed, t_closed)) |
|
|
| if uploaded_file is not None: |
| df0 = read_excel_safe(uploaded_file) |
|
|
| out_excel = build(df0, CLOSED_DT) |
|
|
| p_open_ar, p_sla_ar, p_urbi = get_pivots_for_ppt(df0, CLOSED_DT) |
|
|
| ppt_template = "templates/balady_template.pptx" |
| out_ppt = fill_ppt(ppt_template, p_open_ar, p_sla_ar, p_urbi, CLOSED_DT) |
|
|
| dl1, dl2 = st.columns(2) |
| with dl1: |
| st.download_button( |
| "Download Excel report", |
| data=out_excel.getvalue(), |
| file_name="report_balady.xlsx", |
| mime="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", |
| ) |
| with dl2: |
| st.download_button( |
| "Download PowerPoint", |
| data=out_ppt.getvalue(), |
| file_name="report_balady.pptx", |
| mime="application/vnd.openxmlformats-officedocument.presentationml.presentation", |
| ) |
