5ee6190bc2
Updating to most recent
Dev
Dan Dembinski
2021-02-16 11:55:15 -05:00
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.
Dan Dembinski
2019-07-15 12:59:24 -04:00
1d29437189
Got submit button working
Dan Dembinski
2019-07-03 15:08:22 -04:00
bde35b86ac
Index adds XML client names to a drop down. Added a pretty submit button that doesn't do anything.
Dan Dembinski
2019-06-28 15:53:00 -04:00
ecb9757fb5
Started moving SFU over to Flask
Dan Dembinski
2019-06-28 14:23:10 -04:00
256bd1ceae
Branched out stable code to CLI version
SFU-CLI
Dan Dembinski
2019-06-28 13:33:44 -04:00
c9e8e3cdbf
Merge branch 'master' into Dev
master
Dan Dembinski
2019-06-28 13:25:15 -04:00
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
Dan Dembinski
2019-06-28 13:24:25 -04:00
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.
Dan Dembinski
2019-06-28 11:21:49 -04:00
f58ccd9896
Product summary tab is working. Added total sums to bottom. Started working on coloring the total due in Summary tab
Dan Dembinski
2019-06-27 16:50:28 -04:00
988159af7e
Cleaned some sections up a bit to make format checking and column styling better.
Dan Dembinski
2019-06-25 16:42:47 -04:00
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).
Dan Dembinski
2019-06-25 13:47:17 -04:00
b8e5ae6baa
Broke report appending into a separate function/file. Started working on Column Format Checking Function
Dan Dembinski
2019-06-24 16:48:40 -04:00
a62958d94a
Merge remote-tracking branch 'origin/Dev' into Dev
Dan Dembinski
2019-06-24 14:19:43 -04:00
69f6d24839
Fixed stupididty
Dan Dembinski
2019-06-24 14:16:11 -04:00
46b50bf2fa
Item Details work properly. Working on loading Column Formating from XML file
Dan Dembinski
2019-06-24 14:11:42 -04:00
9053cdb4d0
Started working on pulling Item Details into spreadsheet
Dan Dembinski
2019-06-21 16:48:51 -04:00
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.
Dan Dembinski
2019-06-21 15:45:48 -04:00
2936897c6f
Pulls in Shipping Costs and adds them to column D in the report file.
Dan Dembinski
2019-06-20 16:38:13 -04:00
4d97c8aeb7
Pulls in Shipping Costs and adds them to column D in the report file.
Dan Dembinski
2019-06-20 16:35:20 -04:00
ffd1cebdaf
Started work on fetching shipping costs.
Dan Dembinski
2019-06-20 14:35:46 -04:00
7d41521576
Completed+Balance due report filter is working
Dan Dembinski
2019-06-20 14:23:46 -04:00
cc1b6e8626
Exports as XLSX file now. Started working on Report Filters
Dan Dembinski
2019-06-19 16:42:25 -04:00
a4337edddd
Loads Summary Tab report fields from URL and generates report. Also added headers to CSV output
Dan Dembinski
2019-06-19 11:50:35 -04:00
231d0fac9f
Can now generate CSV output from report. Working on reading in XML config file and setting client settings with simple menu selection
Dan Dembinski
2019-06-19 09:39:09 -04:00
cfa93e0092
Updated to allow updating URL/Hostname easier.
Dan Dembinski2019-06-03 21:40:50 -04:00
Dan Dembinski
Dan Dembinski