Dan Dembinski
5ee6190bc2
Updating to most recent
2021-02-16 11:55:15 -05:00
Dan Dembinski
2bb9baecf6
Everything seems to be working. Selecting the client and hitting the submit button runs the report for the select client and downloads the report as *clientname*+*datetime+report.xlsx.
2019-07-15 12:59:24 -04:00
Dan Dembinski
1d29437189
Got submit button working
2019-07-03 15:08:22 -04:00
Dan Dembinski
bde35b86ac
Index adds XML client names to a drop down. Added a pretty submit button that doesn't do anything.
...
Started reworking main.py. Broke loadMenu out into LoadClient to get just client names, and ClientConfig, which will load xml for only the selected client.
2019-06-28 15:53:00 -04:00
Dan Dembinski
ecb9757fb5
Started moving SFU over to Flask
2019-06-28 14:23:10 -04:00
Dan Dembinski
17894e82ea
Since there was some varience between clients on the order of the headers, I reworked some sections to work off header names instead of hardcoded column letter/numbers
2019-06-28 13:24:25 -04:00
Dan Dembinski
a287e7386f
Total Sums are now colored on Summary Sheet. Made changes to Production cost and Adjustment columns in Summary Tab. Now pulls in Item cost from Item Detail tab and sums all production charges in the order. Adjustment is balance due - production - shipping. This matches the original SFU. Minus column widths not being autoset(I'm still researching this) it seems to be on par with the original version.
2019-06-28 11:21:49 -04:00
Dan Dembinski
f58ccd9896
Product summary tab is working. Added total sums to bottom. Started working on coloring the total due in Summary tab
2019-06-27 16:50:28 -04:00
Dan Dembinski
988159af7e
Cleaned some sections up a bit to make format checking and column styling better.
2019-06-25 16:42:47 -04:00
Dan Dembinski
28fce7e10f
Column Format is now working for both summary and item details. Load function passes client name to the client_Specific_Tabs function in ClientSpecific.py. This will allow any client customization to be done outside of the main program (in theory. I haven't actually tested this yet).
2019-06-25 13:47:17 -04:00
Dan Dembinski
b8e5ae6baa
Broke report appending into a separate function/file. Started working on Column Format Checking Function
2019-06-24 16:48:40 -04:00
Dan Dembinski
46b50bf2fa
Item Details work properly. Working on loading Column Formating from XML file
2019-06-24 14:11:42 -04:00
Dan Dembinski
4d775482c2
Checks report results for '$', strips it converts string to float. Added item detail tab, pulls in detail tab heads and writes to the spreadsheet.
2019-06-21 15:45:48 -04:00
Dan Dembinski
4d97c8aeb7
Pulls in Shipping Costs and adds them to column D in the report file.
2019-06-20 16:35:20 -04:00
Dan Dembinski
ffd1cebdaf
Started work on fetching shipping costs.
2019-06-20 14:35:46 -04:00
Dan Dembinski
7d41521576
Completed+Balance due report filter is working
2019-06-20 14:23:46 -04:00
Dan Dembinski
cc1b6e8626
Exports as XLSX file now. Started working on Report Filters
2019-06-19 16:42:25 -04:00
Dan Dembinski
a4337edddd
Loads Summary Tab report fields from URL and generates report. Also added headers to CSV output
2019-06-19 11:50:35 -04:00
Dan Dembinski
231d0fac9f
Can now generate CSV output from report. Working on reading in XML config file and setting client settings with simple menu selection
2019-06-19 09:39:09 -04:00
cfa93e0092
Updated to allow updating URL/Hostname easier.
2019-06-03 21:40:50 -04:00
ac6f077879
Holy shit, it works. Kind of
2019-06-03 21:23:57 -04:00
e4b27b56b9
Initial commit
2019-06-03 20:49:43 -04:00
