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, header=None)

# Create dictionaries to store SKUs and quantities from EMEA Quote and EMEA DSA
emeaQuoteDict = {sku: qty for sku, qty in curEmeaQuote.skusWithQuantities if pd.notna(sku)}
##emeaDsaDict = {row['SKU']: row['Qty'] for index, row in emeaDsaData.iterrows()}

emeaDsaDict = {}



notInEmeaQuote = []
notInEmeaDsa = []
qtyMismatch = []



# Compare SKUs and quantities
for index, row in emeaDsaData.iterrows():
sku = str(row.iloc[10]).strip()
qty = row.iloc[13]

if pd.notna(sku) and pd.notna(qty):
emeaDsaData[sku] = qty

if sku in emeaQuoteDict:
if emeaQuoteDict[sku] != qty:
qtyMismatch.append((sku, emeaQuoteDict[sku], qty))
else:
notInEmeaQuote.append(sku)

for sku, qty in emeaQuoteDict.items():
if pd.isna(sku) or len(str(sku).strip()) <4:
continue
if sku not in emeaDsaDict:
notInEmeaDsa.append(sku)

for sku, qty in curEmeaQuote.skusWithQuantities:
if sku in emeaDsaDict:
if emeaDsaDict[sku] != qty:
qtyMismatch.append((sku, qty, emeaDsaDict[sku]))
else:
notInEmeaDsa.append(sku)

for sku in emeaDsaDict:
if sku not in curEmeaQuote.skus:
notInEmeaQuote.append(sku)





# Initialize variables to hold the extracted details
quote_no_dsa = ""
total_usd_dsa = ""
quoted_on_dsa = ""

# Extract "Quote No.:" from row 11 (index 10)
quote_no_dsa = str(emeaDsaData.iloc[10, 4]).strip()

# Extract "Total(USD):" from row 12 (index 11) and convert it
total_value = str(emeaDsaData.iloc[11, 4]).strip()
numeric_value = ''.join(filter(lambda x: x.isdigit() or x == '.', total_value))
try:
total_usd_dsa = str(float(numeric_value)) # Convert to float
except ValueError:
total_usd_dsa = "Invalid value" # In case of conversion failure

# Extract "Quoted On:" from row 14 (index 13)
quoted_on_dsa = str(emeaDsaData.iloc[13, 4]).strip()

# 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 EMEA DSA quote details to the report
report_content += f"Emea Dsa Quote No.: {quote_no_dsa}n"
report_content += f"Total(USD): {total_usd_dsa}n"
report_content += f"Quoted On: {quoted_on_dsa}n"

report_content += "-------------------------n"
report_content += "The following items were not present in Emea Gii quote:n"
report_content += "n".join(notInEmeaDsa) + "n"
report_content += "The following items were present in Emea gii quote and not Emea Dsa quote:n"
report_content += "n".join(notInEmeaQuote) + "n"
report_content += "The following items had quantity mismatch between Emea Gii quote and Emea Dsa quote:n"
for sku, qty_gii, qty_dsa in qtyMismatch:
report_content += f"SKU: {sku}tEMEA Gii Quantity: {qty_gii}tEMEA Dsa Quantity: {qty_dsa}n"

directory = os.path.dirname(curEmeaQuoteFD)

# Define the filename for the report
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.")