Notes

def EmeaVsEmeaDsa(self):
self.window.destroy()
# Select the current EMEA Quote PDF
curEmeaQuoteFD = fd.askopenfilename(title='Select Current EMEA Quote')
# Select the EMEA DSA Excel file
emeaDsaFD = fd.askopenfilename(title='Select EMEA DSA Excel File', filetypes=[("Excel files", "*.xlsx *.xls")])

# Initialize the EMEA Quote
curEmeaQuote = EMEAQuote(curEmeaQuoteFD)
curEmeaQuote.getData()

# Read the EMEA DSA Excel file
emeaDsaData = pd.read_excel(emeaDsaFD)

# Initialize dictionaries to store SKU and quantity information for both quotes and DSA
emeaQuoteDict = {sku: qty for sku, qty in curEmeaQuote.skusWithQuantities if pd.notna(sku)}
emeaDsaDict = {}

# Iterate over rows in EMEA DSA data to populate emeaDsaDict
for index, row in emeaDsaData.iterrows():
sku = str(row.iloc[10]).strip()
qty = row.iloc[13]
if pd.notna(sku):
if sku in emeaDsaDict:
emeaDsaDict[sku] += qty
else:
emeaDsaDict[sku] = qty

# Initialize lists to store SKUs present in both datasets and SKUs not present in either dataset
skusInBoth = []
skusNotInEither = []

# Check for SKUs present in both datasets and SKUs not present in either dataset
for sku, qty in emeaQuoteDict.items():
if sku in emeaDsaDict:
skusInBoth.append((sku, qty, emeaDsaDict[sku]))
else:
skusNotInEither.append((sku, qty, "Not in EMEA DSA"))

for sku, qty in emeaDsaDict.items():
if sku not in emeaQuoteDict:
skusNotInEither.append((sku, "Not in EMEA Quote", qty))

# Generate the report content
report_content = "Emea Gii vs. Emea Dsa Report:n"
report_content += f"Emea Gii Quote No.: {curEmeaQuote.quoteNumber}n"
report_content += f"Total: {curEmeaQuote.total}n"
report_content += f"Date: {curEmeaQuote.quoteDate}n"
report_content += f"Part Number: {curEmeaQuote.partNumber}n"
report_content += "-------------------------n"

# Add SKUs present in both datasets to the report
report_content += "Skus present in both Emea Gii and Emea Dsa:n"
for sku_info in skusInBoth:
report_content += f"SKU: {sku_info[0]}tEMEA GII Qty: {sku_info[1]}tEMEA DSA Qty: {sku_info[2]}n"

# Add SKUs not present in either dataset to the report
report_content += "Skus not present in either Emea Gii or Emea Dsa:n"
for sku_info in skusNotInEither:
report_content += f"SKU: {sku_info[0]}tEMEA GII Qty: {sku_info[1]}tEMEA DSA Qty: {sku_info[2]}n"

directory = os.path.dirname(curEmeaQuoteFD)
report_filename = 'EMEA_vs_DSA_report.txt'
report_file_path = os.path.join(directory, report_filename)

# Save the report in the current working directory
with open(report_file_path, 'w') as file:
file.write(report_content)

# Confirm the file has been saved
if os.path.exists(report_file_path):
print(f"Report saved: {os.path.abspath(report_file_path)}")
else:
print("Report saving failed.")