No Provider Schedule files!
", None, None if not provider_info_path: return "Provider Info required!
", None, None if check_ma_mismatch_flag and not ma_paths: return "MA files required for mismatch check!
", None, None # Validate and load provider info info_df, err = validate_provider_info(provider_info_path) if err: return f"{err}
", None, None # Validate and load all provider schedule files prov_dfs = [] for p in provider_paths: df, err = validate_excel_file(p, ['Name', 'Location']) if err: return f"{err}
", None, None if df is not None: prov_dfs.append(df) if not prov_dfs: return "No valid provider data!
", None, None providers_df = pd.concat(prov_dfs, ignore_index=True).drop_duplicates() # Load MA schedules if mismatch check is enabled ma_df = pd.DataFrame() if check_ma_mismatch_flag: ma_dfs = [] for p in ma_paths: df, err = validate_excel_file(p, ['Name', 'Location']) if err: return f"{err}
", None, None if df is not None: ma_dfs.append(df) if ma_dfs: ma_df = pd.concat(ma_dfs, ignore_index=True).drop_duplicates() ma_df['Display_Location'] = ma_df.apply(determine_display_location, axis=1) # Determine which locations to display all_locs = set(providers_df['Display_Location'].unique()) specific_locs = [loc for loc in selected_locations if loc != 'All Locations'] display_locs = {loc for loc in (specific_locs or all_locs) if loc in all_locs} if not display_locs: return "No valid locations selected!
", None, None # Parse and validate date range try: start_obj = pd.to_datetime(start_date.strip(), format='%m/%d/%y') end_obj = pd.to_datetime(end_date.strip(), format='%m/%d/%y') if start_obj > end_obj: return "Start date is after end date!
", None, None dates = providers_df['Date'].unique() if dates.size: dates = pd.to_datetime(dates) start_obj = max(start_obj, dates.min()) end_obj = min(end_obj, dates.max()) except: return "Invalid date format! Use MM/DD/YY
", None, None # Determine whether multi-file checks should be performed bmw_locs = [loc for loc in display_locs if loc in ['Berwyn', 'Morgan', 'Western']] perform_overall = check_age_coverage_flag and len(prov_dfs) > 1 and len(bmw_locs) > 1 perform_conflict = check_location_conflicts_flag and len(prov_dfs) > 1 and len(display_locs) > 1 # Prepare header/footer values loc_str = ", ".join(sorted(display_locs)) gen_time = datetime.now(CHICAGO_TZ).strftime('%I:%M %p CDT, %B %d, %Y') # Begin HTML construction html = f"""| {week} Clinical Hours | ||
|---|---|---|
| Provider | ' + ''.join(f'{loc} | ' for loc in sorted(display_locs)) + 'Total |
| {prov} | ' + ''.join(f'{wh[week].get(loc, {}).get(prov, 0.0):.1f} | ' for loc in sorted(display_locs)) + f'{wt[week].get(prov, 0.0):.1f} |
PDF generation error: {e}
", html_path, None return html, html_path, pdf_path # === Password Check === def check_password(pwd): """ Simple password check to unlock the admin upload/delete panel. """ if pwd == "alivio0000": return gr.update(visible=False), gr.update(visible=True), "" return gr.update(visible=True), gr.update(visible=False), "Incorrect password." # === Gradio Interface === def create_interface(): """ Build the complete Gradio interface with public view tab and password-protected admin tab. """ with gr.Blocks(title="Alivio Schedule Display") as demo: gr.Markdown("# Alivio Schedule Display") gr.Markdown("""Upload the Provider Information Excel and at least one Provider Schedule Excel file.""") gr.Markdown("""Schedules will be generated for the selected locations found in the uploaded provider schedule files, displayed on a single calendar.""") gr.Markdown("""Providers are always displayed in different colors based on age coverage:""") gr.HTML("""