Spaces:
Sleeping
Sleeping
| import streamlit as st | |
| import pandas as pd | |
| from utils import * | |
| from data import * | |
| from io import BytesIO | |
| def screenFull(): | |
| if "screen_full_entries" not in st.session_state: | |
| st.session_state.screen_full_entries = [] | |
| col1, col2 = st.columns(2) | |
| with col1: | |
| brand_name = st.text_input("Brand Name", key="brand_name") | |
| with col2: | |
| cur_date = st.date_input("Date", value="today", key="quote_date") | |
| # Select Companies | |
| sp_company = st.selectbox("Select Screen Print Company", list(screen_data.keys()), key="combo_screen_full_sp_company") | |
| fc_company = st.selectbox("Select Full Colour Company", list(full_data.keys()), key="combo_screen_full_fc_company") | |
| sp_data = screen_data[sp_company] | |
| df_fc = pd.DataFrame(full_data[fc_company]) | |
| col1, col2, col3 = st.columns(3) | |
| with col1: | |
| selected_type = st.selectbox("Print Type", list(sp_data.keys()), key="combo_screen_full_print_type") | |
| with col2: | |
| selected_size = st.selectbox("Print Size", list(sp_data[selected_type].columns[1:4]), key="combo_screen_full_print_size") | |
| with col3: | |
| selected_options = st.multiselect("Options", ["Darks", "Fleece", "90% Poly+", "Sleeves & Legs"], key="combo_screen_full_options") | |
| col4, col5, col6 = st.columns(3) | |
| with col4: | |
| print_area = st.selectbox("Full Colour Print", list(df_fc.columns[1:]), key="combo_screen_full_print_area") | |
| with col5: | |
| quantity = st.number_input("Enter Quantity", min_value=1, step=1, key="combo_screen_full_quantity") | |
| with col6: | |
| item_price = st.number_input("Item Cost (Fixed)", min_value=0.0, step=0.01, key="combo_screen_full_item_price") | |
| # Calculate Prices | |
| # --- Screen Print --- | |
| sp_df = sp_data[selected_type] | |
| sp_range = next((row["Qty"] for _, row in sp_df.iterrows() if quantity <= int(row["Qty"].split()[-1])), sp_df.iloc[-1]["Qty"]) | |
| sp_row = sp_df[sp_df["Qty"] == sp_range] | |
| sp_base_price = sp_row[selected_size].values[0] if not sp_row.empty else 0.0 | |
| sp_option_cost = sum(sp_row[opt].values[0] for opt in selected_options if opt in sp_row) if not sp_row.empty else 0.0 | |
| sp_total_price = sp_base_price + sp_option_cost | |
| # --- Full Color --- | |
| quantity_labels_fc = df_fc["Quantity"].tolist() | |
| fc_range = find_quantity_range(quantity, quantity_labels_fc) | |
| fc_print_price = float(df_fc[df_fc["Quantity"] == fc_range][print_area].values[0]) | |
| total_deco_price = sp_total_price + fc_print_price | |
| net_value = quantity * (item_price + total_deco_price) | |
| unit_net_cost = item_price + total_deco_price | |
| net_value = unit_net_cost * quantity | |
| margin_percentage = st.number_input("Enter Margin (%)", min_value=1.0, max_value=99.0, step=0.1, value=40.0, key="combo_screen_full_margin_val") | |
| margin = margin_percentage / 100 | |
| margin_display = f"{margin_percentage:.2f}%" | |
| total_selling_price = net_value / (1 - margin) | |
| unit_selling_price = total_selling_price / quantity | |
| # Add Entry | |
| if st.button("➕ Add Entry", key="add_screen_full_entry"): | |
| entry = { | |
| "Brand Name": brand_name, | |
| "Selected Date": cur_date, | |
| "Quantity": quantity, | |
| "Print Type": selected_type, | |
| "Print Size": selected_size, | |
| "SP Base Price": f"${sp_base_price:.2f}", | |
| "SP Options": ", ".join(selected_options) if selected_options else "None", | |
| "SP Option Price": f"${sp_option_cost:.2f}", | |
| "SP Total Price": f"${sp_total_price:.2f}", | |
| "Full Colour Area": print_area, | |
| "FC Price": f"${fc_print_price:.2f}", | |
| "Total Decoration Cost": f"${total_deco_price:.2f}", | |
| "Item Cost": f"${item_price:.2f}", | |
| "Net Cost (per unit)": f"${unit_net_cost:.2f}", | |
| "Total Net Cost": f"${net_value:,.2f}", | |
| "Margin": margin_display, | |
| "Unit Selling Price": f"${unit_selling_price:.2f}", | |
| "Total Selling Price": f"${total_selling_price:.2f}" | |
| } | |
| st.session_state.screen_full_entries.append(entry) | |
| # Display Breakdown | |
| if st.session_state.screen_full_entries: | |
| #st.subheader("Pricing Breakdown") | |
| st.markdown(f"<h4 style='color: #f1c40f';>{brand_name}</h4>", unsafe_allow_html=True) | |
| entries = st.session_state.screen_full_entries | |
| cols = st.columns(len(entries)) | |
| for i, (col, entry) in enumerate(zip(cols, entries)): | |
| with col: | |
| st.markdown(f"<h4 style='color: #d31145;'>Entry {i+1}</h4>", unsafe_allow_html=True) | |
| st.markdown(f"<div style='font-size: 16px;'>📌 Quantity:<br><b>{entry['Quantity']}</b></div><br>", unsafe_allow_html=True) | |
| st.markdown(f"<div style='font-size: 16px;'>🖨️ Screen Print Total:<br><b>{entry['SP Total Price']}</b></div><br>", unsafe_allow_html=True) | |
| st.markdown(f"<div style='font-size: 16px;'>🎨 Full Colour Price:<br><b>{entry['FC Price']}</b></div><br>", unsafe_allow_html=True) | |
| st.markdown(f"<div style='font-size: 16px;'>🪙 Net Cost (per unit):<br><b>{entry['Net Cost (per unit)']}</b></div><br>", unsafe_allow_html=True) | |
| st.markdown(f"<div style='font-size: 16px;'>💰 Total Net Cost:<br><b>{entry['Total Net Cost']}</b></div><br>", unsafe_allow_html=True) | |
| st.markdown(f"<div style='font-size: 16px;'>📈 Margin:<br><b>{entry['Margin']}</b></div><br>", unsafe_allow_html=True) | |
| st.markdown(f"<div style='font-size: 16px;'>📊 Unit Price:<br><b>{entry['Unit Selling Price']}</b></div><br>", unsafe_allow_html=True) | |
| st.markdown(f"<div style='font-size: 16px;'>💵 Total Selling Price:<br><b>{entry['Total Selling Price']}</b></div><br>", unsafe_allow_html=True) | |
| if st.button(f"❌ Delete {i+1}", key=f"delete_screen_full_{i}"): | |
| del st.session_state.screen_full_entries[i] | |
| st.rerun() | |
| if st.button("🔄 Reset Entries", key="reset_screen_full"): | |
| st.session_state.screen_full_entries = [] | |
| st.rerun() | |
| entries = st.session_state.get("screen_full_entries", []) | |
| if entries: | |
| st.markdown(""" | |
| <style> | |
| .excel-button { | |
| background-color: #d31145; | |
| color: white; | |
| padding: 12px 24px; | |
| border: none; | |
| border-radius: 8px; | |
| font-size: 14px; | |
| font-weight: bold; | |
| cursor: pointer; | |
| transition: background-color 0.3s ease; | |
| box-shadow: 0 2px 5px rgba(0,0,0,0.2); | |
| } | |
| .excel-button:hover { | |
| background-color: #b80e3a; | |
| } | |
| </style> | |
| """, unsafe_allow_html=True) | |
| df = pd.DataFrame(entries) | |
| df = df[[ | |
| 'Quantity', 'SP Total Price', 'FC Price', 'Net Cost (per unit)', 'Total Net Cost', | |
| 'Margin', 'Unit Selling Price', 'Total Selling Price', 'Selected Date' | |
| ]] | |
| output = BytesIO() | |
| with pd.ExcelWriter(output, engine='xlsxwriter') as writer: | |
| df.to_excel(writer, index=False, startrow=3, sheet_name='Screenprint Fullcolor Breakdown') | |
| workbook = writer.book | |
| worksheet = writer.sheets['Screenprint Fullcolor Breakdown'] | |
| header_format = workbook.add_format({'bold': True, 'font_color': '#d31145', 'font_size': 14}) | |
| worksheet.write('A1', brand_name, header_format) | |
| #worksheet.write('A2', cur_date) | |
| processed_data = output.getvalue() | |
| output.seek(0) | |
| st.download_button( | |
| label="📥 Download Results as Excel", | |
| data=output, | |
| file_name='embroideryFullcolor.xlsx', | |
| mime='application/vnd.openxmlformats-officedocument.spreadsheetml.sheet', | |
| key="excel-download", | |
| help="Download screenprint fullcolor pricing breakdown as an Excel file" | |
| ) | |
| # html = """ | |
| # <html> | |
| # <head> | |
| # <script src="https://cdnjs.cloudflare.com/ajax/libs/html2pdf.js/0.10.1/html2pdf.bundle.min.js"></script> | |
| # <style> | |
| # .pdf-button {{ | |
| # background-color: #d31145; | |
| # color: white; | |
| # padding: 12px 24px; | |
| # border: none; | |
| # border-radius: 8px; | |
| # font-size: 14px; | |
| # font-weight: bold; | |
| # cursor: pointer; | |
| # transition: background-color 0.3s ease; | |
| # box-shadow: 0 2px 5px rgba(0,0,0,0.2); | |
| # }} | |
| # .pdf-button:hover {{ | |
| # background-color: #b80e3a; | |
| # }} | |
| # </style> | |
| # </head> | |
| # <body> | |
| # <div id="pdf-content" style="display: none;"> | |
| # <h4 style='color:#d31145;'>{brand_name}</h4> | |
| # <p>{cur_date}</p> | |
| # """.format(brand_name=brand_name, cur_date=cur_date) | |
| # for i, entry in enumerate(entries): | |
| # html += f""" | |
| # <div style='margin-bottom: 20px; border:1px solid #ccc; padding: 10px; border-radius: 8px;'> | |
| # <h4 style='color:#d31145;'>Entry {i+1}</h4> | |
| # <p>📌 Quantity: {entry['Quantity']}</p> | |
| # <p>🖨️ Screen Print Type: {entry['Print Type']}</p> | |
| # <p>📏 Print Size: {entry['Print Size']}</p> | |
| # <p>⚙️ Options: {entry['SP Options']}</p> | |
| # <p>💸 Screen Print Total: {entry['SP Total Price']}</p> | |
| # <p>🎨 Full Colour Area: {entry['Full Colour Area']}</p> | |
| # <p>🖍️ Full Colour Price: {entry['FC Price']}</p> | |
| # <p>💰 Total Net Cost: {entry['Total Net Cost']}</p> | |
| # <p>📈 Margin: {entry['Margin']}</p> | |
| # <p>📊 Unit Price: {entry['Unit Selling Price']}</p> | |
| # <p>💵 Total Selling Price: {entry['Total Selling Price']}</p> | |
| # </div> | |
| # """ | |
| # html += """ | |
| # </div> | |
| # <button class="pdf-button" onclick="downloadPDF()">📄 Download Results as PDF</button> | |
| # <script> | |
| # function downloadPDF() { | |
| # const element = document.getElementById("pdf-content"); | |
| # element.style.display = 'block'; | |
| # html2pdf().set({ | |
| # margin: 0.5, | |
| # filename: 'combo_screenprint_fullcolor_breakdown.pdf', | |
| # image: { type: 'jpeg', quality: 0.98 }, | |
| # html2canvas: { scale: 2 }, | |
| # jsPDF: { unit: 'in', format: 'letter', orientation: 'portrait' } | |
| # }).from(element).save().then(() => { | |
| # element.style.display = 'none'; | |
| # }); | |
| # } | |
| # </script> | |
| # </body> | |
| # </html> | |
| # """ | |
| # st.components.v1.html(html, height=120) | |