22 Commits

Author SHA1 Message Date
Dan Dembinski
c9e8e3cdbf Merge branch 'master' into Dev 2019-06-28 13:25:15 -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
a62958d94a Merge remote-tracking branch 'origin/Dev' into Dev
# Conflicts:
#	main.py
2019-06-24 14:19:43 -04:00
Dan Dembinski
69f6d24839 Fixed stupididty 2019-06-24 14:16:11 -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
9053cdb4d0 Started working on pulling Item Details into spreadsheet 2019-06-21 16:48:51 -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
2936897c6f Pulls in Shipping Costs and adds them to column D in the report file. 2019-06-20 16:38:13 -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