Commit Graph

186 Commits

Author SHA1 Message Date
Paul Trowbridge 33c49f3463 accomodate an update to the stored proc that returns accessories list 2021-10-14 09:50:59 -04:00
Paul Trowbridge 0f8a560b4b work with target price generation 2021-10-07 18:28:15 -04:00
Paul Trowbridge 539a966e1c convert input box on cross joining to range selector 2021-08-16 09:17:52 -04:00
Paul Trowbridge 945863353e customized ribbon 2021-08-16 09:16:55 -04:00
Paul Trowbridge 79443856c5 increment PW 2021-08-13 11:01:28 -04:00
Paul Trowbridge d78f665533 upload product groups 2021-08-13 11:01:12 -04:00
Paul Trowbridge 34984de260 updates to nursery regional parsing 2021-08-13 10:34:20 -04:00
Paul Trowbridge c80e5296d1 add 2 subroutines and SQL formatting 2021-06-16 09:03:23 -04:00
Paul Trowbridge 0101b45e8a set header values, wrap the sql in a commit block, close the connection 2021-03-15 16:02:45 -04:00
Paul Trowbridge b1328fac50 load table pcore from sheet contents 2021-03-15 15:41:44 -04:00
Paul Trowbridge fac0a38977 optional param for pre-determined column types to be supplied instead of guessing 2021-03-15 15:40:43 -04:00
pt 605a1e95b0 update price list to just pull description columns 2020-12-02 11:53:21 -05:00
pt 0143a891bb rework the coloring a bit 2020-11-06 14:48:49 -05:00
Paul Trowbridge 9dcf8ac310 get rid of suffix column and include use accs instead of kit 2020-10-28 11:22:14 -04:00
Paul Trowbridge cc4bd12720 updates 2020-09-15 13:02:06 -04:00
Paul Trowbridge 4c0ceb334e add another iteration of the price list logic 2020-07-14 16:06:44 -04:00
Paul Trowbridge d10a15f113 live check of price list against lgdat records to test if inbound charges are new or update 2020-06-25 16:58:13 -04:00
Paul Trowbridge c14ba755f8 ignore 2020-06-23 15:44:20 -04:00
Paul Trowbridge 17b974a940 move colors to columns, and update the highlighting 2020-06-23 15:41:59 -04:00
pt 64c7be2587 finalize to get 1.5 done 2020-03-13 17:31:48 -04:00
pt 7182502669 list of parts to change not wrapped in an array if only one row 2020-03-06 00:33:24 -05:00
pt 19021da028 price volume colors 2020-03-06 00:32:12 -05:00
Trowbridge 7e57d4621f add a new route for swapping out parts 2020-03-05 01:08:10 -05:00
pt f569e6238d version 1.4 2020-03-03 23:22:13 -05:00
Trowbridge 043c7264bf various changes 2020-02-25 10:56:18 -05:00
pt 1ca398bb8e minor updates 2020-02-19 23:03:48 -05:00
Trowbridge 8e467677c4 add customized ribbon 2020-02-19 11:44:29 -05:00
Trowbridge 988f72996a accomodate tagging 2020-02-18 17:04:03 -05:00
pt ce6461007a loop thorugh each month line to add the tag/comment to the doc 2020-02-18 02:56:37 -05:00
pt 501fa5f4e6 monthly comments and tags 2020-02-18 02:07:38 -05:00
Trowbridge 3b3785dbd8 add undo and comments 2020-02-14 17:24:02 -05:00
pt 3932e224f0 lot of changes 2020-02-14 02:27:01 -05:00
Paul Trowbridge 3c646b3a8d add rounding, increment year, dont hardcode plan 2020-02-13 02:23:13 -05:00
pt 44ef2f5dc5 add characters 2020-02-13 02:19:15 -05:00
Paul Trowbridge 4b6d0c744d accomodate new sql builder parameters, and test for presence of price sheet 2020-01-29 13:31:32 -05:00
Paul Trowbridge 99905a9341 use regex to better parse data for SQL loading 2020-01-29 13:30:53 -05:00
Paul Trowbridge 022240f8d3 update price list build to include status and stocked 2020-01-15 17:17:07 -05:00
Paul Trowbridge b4291d15e7 rework logic to hook off of color indicator supplied instead of using first 11 2020-01-15 11:41:19 -05:00
Trowbridge 79e3c24a37 utf-8 was causing strange characters in CMS, should make a param 2020-01-13 17:26:32 -05:00
Trowbridge 35f5b04a1d use unit of measure to translate volume breaks, change default upload function to add 2020-01-13 17:25:22 -05:00
Trowbridge 56bb03ce7d default action is 1 2020-01-13 17:24:24 -05:00
Trowbridge aa88dbc9e7 upper bound was wrong 2020-01-13 17:23:39 -05:00
Trowbridge f825c61b62 add some array handling 2020-01-10 14:17:57 -05:00
Trowbridge 733d65881e build pricelist csv 2020-01-10 14:17:29 -05:00
Trowbridge 94bc6e2b14 add shortcut keys and pricelist csv 2020-01-10 14:17:16 -05:00
Paul Trowbridge 07d66cc754 build login form 2020-01-10 11:29:50 -05:00
Paul Trowbridge 9b14ba77f5 add function to test a string array for non numeric 2020-01-10 11:08:51 -05:00
Trowbridge fdd3ce6d93 add test for invalid numbers 2020-01-10 11:07:40 -05:00
pt 4311b3b3e4 build price list functionality 2020-01-09 17:53:00 -05:00
pt 787c2c736f dont quote column names 2020-01-09 17:51:26 -05:00