Commit Graph

Select branches

Hide Pull Requests

archive

backup

bighist

detaillevel

format

javascript_relevance_logic

master

new_guidance

new_targets

refactor_batch

suggested

update

Mono Color

• 5ec3f1d9c1 put target rebuild in a proc master Paul Trowbridge 2025-09-08 08:50:28 -0400
• 581224dad8 wrap in transaction Paul Trowbridge 2025-09-06 15:59:51 -0400
• af4c7c4853 change visibility level of target calculation Paul Trowbridge 2025-09-05 08:48:42 -0400
• abac006970 work on filter before row number Paul Trowbridge 2025-09-04 15:04:30 -0400
• a5a746c005 change visibility levels to hide target price details new_guidance Paul Trowbridge 2025-09-04 13:37:31 -0400
• fd930c9969 change guidance to limit to last price paid Paul Trowbridge 2025-09-04 13:37:03 -0400
• 7596038b54 remove price drop Paul Trowbridge 2025-09-03 09:35:09 -0400
• 1b7ec3635b testing Paul Trowbridge 2025-08-30 08:56:15 -0400
• ca2e9ea3be add approval columns to quote review Paul Trowbridge 2025-08-30 08:55:48 -0400
• a8d83cc042 revised run times Paul Trowbridge 2025-08-28 09:32:32 -0400
• ad6d3d60f0 break our approval versus guidance logic in postgres Paul Trowbridge 2025-08-28 09:08:51 -0400
• 2cc7204c7f update guidance logic to be the shown price which is great of target or last price but capped at list Paul Trowbridge 2025-08-28 00:19:27 -0400
• e047e7f39b mirror guidance logic Paul Trowbridge 2025-08-27 23:06:59 -0400
• c5532cd2dd convert to factor and clarify the logical steps Paul Trowbridge 2025-08-27 23:06:08 -0400
• a7945999a2 initial rework of last price so it is clearer to review Paul Trowbridge 2025-08-27 22:41:39 -0400
• 37fead59ff Merge branch 'new_targets' new_targets Paul Trowbridge 2025-08-27 20:26:36 -0400
• 42c5900efe huge increase in run times Paul Trowbridge 2025-08-27 20:06:02 -0400
• c61729e017 point target source to new target tables Paul Trowbridge 2025-08-27 15:08:50 -0400
• ce77ad7de3 flip the labels on last quote and last sale Paul Trowbridge 2025-08-27 15:08:33 -0400
• 9a410b82d1 break out base target table with proper index, and create separate refresh script Paul Trowbridge 2025-08-27 15:07:57 -0400
• 6bb0172c2d label parameters and adjust last to 5% Paul Trowbridge 2025-08-27 10:45:55 -0400
• 3c854ed0a4 repoint postgres targets to new targets Paul Trowbridge 2025-08-27 10:31:37 -0400
• d653917c8b point view to new target math Paul Trowbridge 2025-08-27 09:53:03 -0400
• 993a476bea expand core targets and populate Paul Trowbridge 2025-08-26 16:31:57 -0400
• 59a28591bd example with detaillevel key Paul Trowbridge 2025-08-26 16:31:31 -0400
• a79a6d973f change last price window to 18 months Paul Trowbridge 2025-08-26 09:51:59 -0400
• 11b1a3a2e4 only work off of actual sales, not quotes Paul Trowbridge 2025-08-26 09:50:05 -0400
• 3675b8541f introduce a new key-value pair in the ui json that indicates level of visibility to various roles detaillevel Paul Trowbridge 2025-08-25 21:05:13 -0400
• 2a699e8f83 only use actual sales for last price info in the evaluation process Paul Trowbridge 2025-08-25 17:35:19 -0400
• f19bd138e3 gate the row_number function so that only target rows are processes Actuals for sales and Quotes for quotes Paul Trowbridge 2025-08-25 17:31:37 -0400
• 8974095341 expand the new target definition into a complete listing Paul Trowbridge 2025-08-25 17:05:15 -0400
• 6e2e806f9b add sample build of new target logic Paul Trowbridge 2025-08-21 15:35:20 -0400
• e9bd81f352 new table to store target price components Paul Trowbridge 2025-08-21 15:30:08 -0400
• c77a6643b2 add commented out price build call Paul Trowbridge 2025-08-21 12:01:08 -0400
• c02f7ef765 include base item so calculation works Paul Trowbridge 2025-08-21 12:00:49 -0400
• 1d2c2741b1 create function that does not compound pricing Paul Trowbridge 2025-08-21 11:57:38 -0400
• 0fdf2e9775 formatting Paul Trowbridge 2025-08-21 11:08:06 -0400
• 11e3f419f6 formatting Paul Trowbridge 2025-08-21 11:07:14 -0400
• 7067f3d1fa update to reflect shown detail level Paul Trowbridge 2025-08-18 14:36:48 -0400
• 7f5994a40d handle nulls Paul Trowbridge 2025-08-18 14:36:33 -0400
• 379e6a5160 change to 15% price reduction Paul Trowbridge 2025-08-18 14:35:22 -0400
• b3635695e6 line ending or other non impact Paul Trowbridge 2025-08-18 14:34:28 -0400
• d2f56fcafa examples Paul Trowbridge 2025-08-18 14:33:38 -0400
• f1d4d8a60b cap at ceiling not working becuase _eff list was being set to null Paul Trowbridge 2025-08-14 03:30:25 -0400
• ccf50036ca work on guidance logic output text and parameterize caps and floors Paul Trowbridge 2025-08-14 02:32:01 -0400
• c46d4c25d7 link in cost, rounding, target for last price should be based on last price qty Paul Trowbridge 2025-08-14 01:50:57 -0400
• 23b3962313 join in cost and volume, fix last price cross join refactor_batch Paul Trowbridge 2025-08-14 00:50:31 -0400
• 3cc82d14c0 last price normalization and refactor Paul Trowbridge 2025-08-13 23:23:35 -0400
• 49748383ff return last part code; factor last qty into normalization, better notes on the last price sourcing Paul Trowbridge 2025-08-13 22:23:08 -0400
• 7f990ab611 commit: 2025-08-12 23:08:02 Paul Trowbridge 2025-08-12 23:08:02 -0400
• f2fe91f078 isolate version Paul Trowbridge 2025-08-12 22:32:47 -0400
• 9b2d1bef4d put base price in the note Paul Trowbridge 2025-08-12 09:58:24 -0400
• 59b616c2b7 truncate the descriptor on guidance logic Paul Trowbridge 2025-08-12 09:57:48 -0400
• fb462fbcb1 commit: 2025-08-12 01:19:30 Paul Trowbridge 2025-08-12 01:19:30 -0400
• d77b042581 formatting on last price normalizarion display Paul Trowbridge 2025-08-11 21:47:57 -0400
• f936b9d31d show bridge to normalize last price Paul Trowbridge 2025-08-11 21:18:22 -0400
• a649924c86 combine panels Paul Trowbridge 2025-08-11 20:47:08 -0400
• 3f56f04f8b notes Paul Trowbridge 2025-08-11 20:32:48 -0400
• eb7563f96c include last part code and add item for total target price Paul Trowbridge 2025-08-11 20:24:12 -0400
• 062b49e60c commit: 2025-08-11 17:42:43 Paul Trowbridge 2025-08-11 17:42:43 -0400
• 8624add269 force output if null Paul Trowbridge 2025-08-11 12:10:47 -0400
• 82db9a4334 populate something even if there is no record Paul Trowbridge 2025-08-11 12:00:08 -0400
• d46e71a170 shorten the note on last sale Paul Trowbridge 2025-08-11 11:01:04 -0400
• d37aded2c9 history should be in an array Paul Trowbridge 2025-08-11 11:00:40 -0400
• 310f1dc8f9 change last sale price flagging Paul Trowbridge 2025-08-11 09:50:37 -0400
• 9452220c46 Merge branch 'suggested' of github.com:The-HC-Companies/price_api into suggested suggested Paul Trowbridge 2025-08-11 09:22:21 -0400
• c423116b9d Merge branch 'master' of github.com:The-HC-Companies/price_api Paul Trowbridge 2025-08-11 09:21:18 -0400
• 5940300dee refresh Paul Trowbridge 2025-08-11 09:20:40 -0400
• 2bf970eb06 convert to materialized view Paul Trowbridge 2025-08-11 09:09:40 -0400
• ab5808d1e8 sequence variable according to population and sync up ms pg Paul Trowbridge 2025-08-11 09:04:31 -0400
• e04021caa1 commit: 2025-08-10 23:04:53 Paul Trowbridge 2025-08-10 23:04:53 -0400
• fe2145b7d2 work on broken target linkage Paul Trowbridge 2025-08-10 23:01:48 -0400
• 10ca238010 commit: 2025-08-08 17:36:58 Paul Trowbridge 2025-08-08 17:36:58 -0400
• 68921d9a7f suggested changes Paul Trowbridge 2025-08-08 09:33:20 -0400
• 849d176ad0 notes Paul Trowbridge 2025-08-08 02:59:42 -0400
• f8c62e5d27 handle differences quoted product versus product on list if customized or last price if no exact match found Paul Trowbridge 2025-08-08 02:45:06 -0400
• d1ca17b7e4 move quote review infrastructure Paul Trowbridge 2025-08-07 23:59:05 -0400
• da1b97f712 move files Paul Trowbridge 2025-08-07 23:54:07 -0400
• 5945364482 commit: 2025-08-07 23:51:14 Paul Trowbridge 2025-08-07 23:51:14 -0400
• 79a1d2a4ce commit: 2025-08-07 23:47:53 Paul Trowbridge 2025-08-07 23:47:53 -0400
• 35c7fbee6b example usage Paul Trowbridge 2025-08-07 23:42:26 -0400
• af5e4d202b bring func up to speed Paul Trowbridge 2025-08-07 23:35:09 -0400
• 4602db59bb move files Paul Trowbridge 2025-08-07 23:23:40 -0400
• 8675120993 move files around Paul Trowbridge 2025-08-07 23:21:09 -0400
• 045e050b0e move files around Paul Trowbridge 2025-08-07 23:16:18 -0400
• 92e25c004e update postgres matrix logic to use last price picker, add front matter to all scripts archive Paul Trowbridge 2025-08-07 22:54:27 -0400
• 34f390478e materialize the cte and pretty print the json for powerbi consumption Paul Trowbridge 2025-08-07 12:58:40 -0400
• d9ccc7b2a8 commit: 2025-08-07 02:20:36 Paul Trowbridge 2025-08-07 02:20:36 -0400
• fe67caf1af work on problems with dss not reflecting last sales Paul Trowbridge 2025-08-07 02:16:27 -0400
• 47d77d3706 duplicate dss dsq key sets built into json Paul Trowbridge 2025-08-07 02:08:07 -0400
• 213d1419fb format Paul Trowbridge 2025-08-07 02:02:02 -0400
• 165cfc9ec1 convert single price call to have a helper function handle last price selection Paul Trowbridge 2025-08-07 01:32:30 -0400
• 6eab5713cf update logic on last price Paul Trowbridge 2025-08-07 00:57:18 -0400
• ee653c5bba use a helper function with no intermediate pasring to get best anchor price Paul Trowbridge 2025-08-07 00:45:52 -0400
• 3468ba1faf get rid of old files and update matrix process to mirror single price calls Paul Trowbridge 2025-08-07 00:24:28 -0400
• 8d1c6995c6 commit: 2025-08-07 00:05:59 Paul Trowbridge 2025-08-07 00:05:59 -0400
• c6f817526f incorporate last price logic details Paul Trowbridge 2025-08-06 23:47:36 -0400
• 4b1f6a3136 work on syncing up logic Paul Trowbridge 2025-08-06 23:03:52 -0400
• b934bdda56 commit: 2025-08-06 17:15:27 Paul Trowbridge 2025-08-06 17:15:27 -0400
• d25f4fd838 call out evey last price object Paul Trowbridge 2025-08-06 14:11:38 -0400