Commit Graph

Select branches

Hide Pull Requests

archive

dev_ms_target_build

master

Mono Color

• dbbf7d6c6c create tables necessary to expand targt price list dev_ms_target_build Paul Trowbridge 2025-10-22 21:34:46 -0400
• 0708793aeb
  Merge pull request #6 from The-HC-Companies/dev_targetvisibility master Paul Trowbridge 2025-10-22 20:55:03 -0400
• b994e2c661 make target calculation visible Paul Trowbridge 2025-10-22 20:54:14 -0400
• 49ceebc696 include price level in debug data Paul Trowbridge 2025-10-21 10:28:14 -0400
• 82b68c80b3
  Merge pull request #5 from The-HC-Companies/dev_coalecseblanks Paul Trowbridge 2025-10-21 10:06:56 -0400
• 6101bf4ddf do a coalesce on blanks instead of nulls as the db is populated with blanks Paul Trowbridge 2025-10-21 10:06:15 -0400
• 66779efb0a
  Merge pull request #4 from The-HC-Companies/dev_pricelist Paul Trowbridge 2025-10-21 09:48:59 -0400
• c9b90ad22b use bill-to price level if there is no ship-to level Paul Trowbridge 2025-10-21 09:38:10 -0400
• 0527b40ea4
  Merge pull request #3 from The-HC-Companies/dev_reorder Paul Trowbridge 2025-10-07 23:37:29 -0400
• f890ef4ba5 move final guidance to bottom Paul Trowbridge 2025-10-07 23:36:02 -0400
• e930830f27 make cash cost level 10 and fix target build to be all 5s Paul Trowbridge 2025-10-07 15:52:38 -0400
• b33ae7d085 add cash cost with visibility level 5 Paul Trowbridge 2025-10-03 16:54:21 -0400
• e1fa96c59d move cost Paul Trowbridge 2025-10-03 16:36:21 -0400
• 36f52134ce move guidance to top Paul Trowbridge 2025-10-03 16:35:17 -0400
• 5a8ae45a01
  Merge pull request #2 from The-HC-Companies/dev_onylist Paul Trowbridge 2025-10-03 15:51:14 -0400
• f4d25e6819 dont return a price if all you have is price list Paul Trowbridge 2025-10-03 15:45:11 -0400
• b62f2275d6 partition by data source so that row number will start with 1 inside of actuals or quotes Paul Trowbridge 2025-10-02 14:00:43 -0400
• 964616beec remove comment Paul Trowbridge 2025-10-01 16:22:53 -0400
• 326784e18c additional transaction wrapping and consolidated proc to sync tables Paul Trowbridge 2025-10-01 16:13:35 -0400
• 9dd85505ea migrate tables and pointers away from fanalysis Paul Trowbridge 2025-10-01 15:24:45 -0400
• 2ba73ac036 migrate rlarp to pricing Paul Trowbridge 2025-10-01 15:16:44 -0400
• 34c811123a wrap last price rebuild in transaction Paul Trowbridge 2025-10-01 14:31:05 -0400
• 31172e7e35 work on targeting a new db Paul Trowbridge 2025-10-01 09:55:56 -0400
• 42f8d1b777 include cost section Paul Trowbridge 2025-09-22 17:23:55 -0400
• 81736b51b1 add run times Paul Trowbridge 2025-09-22 11:56:19 -0400
• 1f9d8b9c85 spelling Paul Trowbridge 2025-09-16 23:07:34 -0400
• 28be5a3540 create master refresh scripts Paul Trowbridge 2025-09-16 22:39:14 -0400
• 4b477b990f wrap in procedures Paul Trowbridge 2025-09-16 22:34:50 -0400
• 12787d297b rename Paul Trowbridge 2025-09-16 22:10:10 -0400
• eb7f200880 wrap rebuild in a proc Paul Trowbridge 2025-09-16 22:09:10 -0400
• 5dc970da3f move rebuild scripts and create ddl scripts Paul Trowbridge 2025-09-16 21:41:07 -0400
• 619539eac9 update to hold at last price, no drop Paul Trowbridge 2025-09-09 15:39:40 -0400
• 5ec3f1d9c1 put target rebuild in a proc 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 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' 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 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 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
• 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