PhilRunninger
86225ea7e5
Get pounds to update for each forecast adjustment.
...
Lots of cleanup here too, removing large swaths of code that are no
longer needed. Many improvements the Excel workbook, which is kept in
Teams, not git. These changes may or may not have had accompanying VBA
changes.
2023-04-27 16:54:37 -04:00
PhilRunninger
59cb926d9c
Make the log statements unique for each route.
2023-03-01 17:51:01 -05:00
Paul Trowbridge
68aa1c219a
updates
2023-02-24 19:28:14 -05:00
Paul Trowbridge
c48e52f95c
add a floor date to prevent adjusting actual history based on the supplied timestamp
2021-07-16 10:20:32 -04:00
Paul Trowbridge
a328aaeaaf
running the SQL was commented out in the router, also the columns were incorrect when swapping customer, and outer join was spelled wrong
2021-04-07 21:23:19 +00:00
Paul Trowbridge
28ee5dfbb4
update history pull to match dev branch
2021-04-07 12:55:35 -04:00
Paul Trowbridge
e4604a16f5
merge dev branch
2021-04-07 10:17:12 -04:00
Paul Trowbridge
1b0f4b9f04
history target is wrapped in scenario key from UI
2021-04-05 19:03:31 +00:00
Paul Trowbridge
98eff757c0
add route for sales basis adjustment
2020-06-15 18:02:21 -04:00
pt
834d52a2a2
customer swap route will do nothing
2020-05-12 16:55:37 -04:00
Paul Trowbridge
e3205a94c1
setup history listing to be based on a where clause to allow for director level
2020-04-02 09:55:53 -04:00
Paul Trowbridge
9539b99301
manually force 'adj volume' as a valid baseline iteration to build on. this is the iteration for 'new basket'
2020-03-19 12:59:17 -04:00
pt
1c0e07502d
swap ( #45 )
2020-03-13 14:48:26 +00:00
Trowbridge
fcc95ecb40
validate forecast matches actual, build in log entries for initial build
2020-02-20 14:26:39 -05:00
pt
2ec8ec75f0
deprecate add month for volume only
2020-02-16 22:34:06 -05:00
Trowbridge
6774a2fdff
default load as not null
2020-02-14 17:00:06 -05:00
Trowbridge
6485613ab7
add undo route, and include comments
2020-02-14 14:41:29 -05:00
pt
1b8c101429
update history log
2020-02-14 02:24:52 -05:00
Paul Trowbridge
8cf8490887
Merge branch 'bugfix/div0'
2019-04-03 08:57:59 -05:00
Paul Trowbridge
e312bc1abd
add log file routes and queries
2019-04-03 08:56:01 -05:00
Paul Trowbridge
723e2a250c
fix add month route for volume only with base = 0
2019-04-03 03:26:07 -04:00
fleetside72
8cb6b843ba
recast scale_v to be based on qty and handle -0- qty
2019-04-03 01:42:10 -04:00
Paul Trowbridge
731c811fc3
change message on list route
2019-03-28 09:32:09 -04:00
Paul Trowbridge
0c08dae349
variabalize port
2019-03-27 11:59:21 -05:00
Paul Trowbridge
6c0e98b13e
specifiy env
2019-03-27 12:50:09 -04:00
Paul Trowbridge
172b00b9ee
working directory comes from env file
2019-03-27 12:28:51 -04:00
Paul Trowbridge
fdb54f4a8b
change directory
2019-03-25 13:32:51 -05:00
Paul Trowbridge
bb5f74a058
add timestamp to log
2019-03-25 02:44:40 -04:00
Paul Trowbridge
1f9623e026
swap out timestamp before pushing into the database
2019-03-22 14:39:16 -04:00
Trowbridge
429baa0c04
add route to list changes
2019-03-22 14:02:03 -04:00
Trowbridge
c85994b606
correct log stmt and add route
2019-03-22 04:49:35 -04:00
Paul Trowbridge
8f2ef692df
Merge branch 'dev' of github.com:fleetside72/forecast_api into dev
2019-03-21 16:52:35 -04:00
Trowbridge
bb83caa46f
parameterize sql and add route for new part
2019-03-21 15:29:17 -04:00
Paul Trowbridge
ccb40d309d
Merge branch 'dev' of github.com:fleetside72/forecast_api into dev
2019-03-20 00:44:27 -05:00
Trowbridge
5245bfac74
add a part list and log sql statements
2019-03-20 00:37:36 -04:00
Paul Trowbridge
d01a2f9f74
Merge branch 'dev' of github.com:fleetside72/forecast_api into dev
2019-03-18 18:16:38 -05:00
Paul Trowbridge
8f7a9d5e8d
change path
2019-03-18 18:16:35 -05:00
Paul Trowbridge
ecaef0ae4b
setup a basket to send back, convert to https
2019-03-18 17:27:01 -04:00
Paul Trowbridge
ec9bd664c1
Merge branch 'dev' of github.com:fleetside72/forecast_api into dev
2019-03-18 15:07:21 -05:00
Paul Trowbridge
5247ecfc06
add some logging
2019-03-18 15:07:15 -05:00
Trowbridge
191b735061
alter scnaerio package for part, bill, ship
2019-03-18 16:02:45 -04:00
Paul Trowbridge
582683cd15
adjust labels
2019-03-14 11:05:00 -04:00
Paul Trowbridge
932c95e83c
dont use iterdet anymore since not in osm. iter = source + behavior
2019-03-14 10:47:29 -04:00
Paul Trowbridge
1f97d74257
adjust path
2019-03-14 00:51:08 -04:00
Paul Trowbridge
e9d96b0de1
test sending logs
2019-03-14 00:49:33 -04:00
Paul Trowbridge
861ba2eee6
adjust volume and price lable
2019-03-14 00:13:32 -04:00
Paul Trowbridge
0e3bc60dd7
update volume and price, as well as description on other routes
2019-03-13 23:32:12 -04:00
Paul Trowbridge
92657e72c3
update scale volume route to contain iteration info
2019-03-13 23:25:07 -04:00
Paul Trowbridge
9d6453f837
update scale by price route
2019-03-13 17:27:59 -04:00
Trowbridge
0ce9056d7c
fix up volume and price
2019-03-13 13:53:19 -04:00