rattail/pycorepos
2
0
Fork 0
Code Issues Pull requests Actions Packages Projects Releases Wiki Activity
160 commits 1 branch 31 tags 361 KiB
Commit graph

101 commits

Author SHA1 Message Date
Lance Edgar 97a1396a54 feat: use true column names for transaction data models 
as much as i kind of want to "rename" some of these for convenience,
it seems safest here to just stick with true names to avoid confusion
 2025-01-25 17:04:43 -06:00
Lance Edgar a2a1d7faee fix: define common base schema for Product model 2025-01-25 17:04:40 -06:00
Lance Edgar 2fe089bd57 fix: add Parameter model for lane_op 2025-01-25 16:41:17 -06:00
Lance Edgar 50351596ac fix: add model for lane_trans LocalTrans 2025-01-24 20:18:13 -06:00
Lance Edgar c3b639390d fix: add Employee model for lane_op 
with abstract common base schema
 2025-01-24 19:21:00 -06:00
Lance Edgar 97fb0b28cb feat: add common base class for dtransactions and similar models 
more work to be done here i'm sure, but this should hopefully be a
conservative change in the right direction
 2025-01-24 19:20:18 -06:00
Lance Edgar d21346bbff fix: fix ordering of name columns for MemberInfo 
so they show up correctly by default e.g. in UI
 2025-01-15 14:48:18 -06:00
Lance Edgar 7aaa35dac7 fix: add workaround to avoid missing schema columns 
more columns will need to be added to this workaround i'm sure, but
this takes care of a couple small ones
 2025-01-15 10:59:14 -06:00
Lance Edgar 01852ceecc fix: misc. cleanup for sales batch models 2025-01-15 08:45:59 -06:00
Lance Edgar ab56a35acc fix: add more enums for batch discount type, editor UI 
also fix column type for editor UI
 2025-01-14 20:20:41 -06:00
Lance Edgar 023d826d31 fix: remove autoincrement option for composite PK fields 2025-01-13 12:57:41 -06:00
Lance Edgar 47c23a65ae fix: add base class for all transaction tables, views 
also rename some classes; add `dlogBig` for archive view
 2025-01-11 21:55:54 -06:00
Lance Edgar 464f107a88 fix: add MemberType.ignore_sales column 2025-01-11 21:52:22 -06:00
Lance Edgar cb6ed15eb8 fix: add model for MasterSuperDepartment 2025-01-11 21:51:28 -06:00
Lance Edgar 3bb01f2397 fix: add wicable, active columns for Department model 2024-12-17 16:45:11 -06:00
Lance Edgar b5b29cdcf1 feat: add model for MemberContactPreference (op.memContactPrefs) 2024-08-06 11:34:07 -05:00
Lance Edgar 27a46ed18f feat: add model for CustomReceiptLine (op.customReceipt) 2024-08-06 10:38:01 -05:00
Lance Edgar 66cf108b3f fix: remove Change data model 
since it isn't actually part of CORE, and is now handled in other ways
with regard to datasync
 2024-07-04 13:18:45 -05:00
Lance Edgar 909d75796b Fix synonym for dtransactions.tax 2023-10-20 19:03:20 -05:00
Lance Edgar f217f00a8f Fix data types for tax, voided in dtransactions 2023-10-20 14:31:13 -05:00
Lance Edgar 1597c163c6 Let MemberInfo.dates be an object, not a list 2023-10-12 10:34:13 -05:00
Lance Edgar 3a3fba19e4 Fix the Department.tax_rate relationship 
whoops i mistook `dept_tax` for a boolean previously
 2023-10-11 18:36:12 -05:00
Lance Edgar e5988102ad Rename module to corepos.db.office_arch 2023-10-05 11:52:39 -05:00
Lance Edgar 83eecad28d Add model for office_op.Tender 2023-09-15 12:43:02 -05:00
Lance Edgar 5214db0a83 Add model for CustomerNotifications table 2023-09-13 16:23:33 -05:00
Lance Edgar 0e30303947 Tweak primary key for StockPurchase model 
per having a better understanding now, i think..
 2023-09-07 17:45:14 -05:00
Lance Edgar 5a77d14a26 Add models for StockPurchase and EquityLiveBalance 2023-06-18 11:38:14 -05:00
Lance Edgar c6144ab310 Add note about meminfo.email_2 field, aka. "alt. phone" 2023-06-12 20:38:12 -05:00
Lance Edgar 4952d2fa3d Rename custdata model to CustomerClassic 2023-06-12 17:28:55 -05:00
Lance Edgar ad5837405f Require SQLAlchemy 1.4.x 2023-02-15 12:51:50 -06:00
Lance Edgar c2723de467 Delete productUser record when products record is deleted 2022-08-21 00:11:24 -05:00
Lance Edgar 2b80fd6a6b Add basic TransactionDetail for trans archive model 2022-03-26 23:04:05 -05:00
Lance Edgar b46282264c Add model for UserGroup 2022-01-17 18:59:19 -06:00
Lance Edgar a6306a4882 Remove deprecation warning for corepos.db 
everything should be using the right imports now
 2021-12-30 21:47:55 -06:00
Lance Edgar 41c142b837 Add the custdata model for lane_op DB 
also use Numeric instead of Float for "MONEY" columns, for custdata in
both lane_op and office_op
 2021-11-04 17:41:39 -05:00
Lance Edgar 754d8697e8 Add proper support for str(Suspension) 2021-09-30 18:44:53 -04:00
Lance Edgar 0d81a41b54 Add User model for office_op 2021-09-07 15:45:51 -05:00
Lance Edgar 092884eab3 Add lane_op model for Department 2021-08-31 22:40:58 -05:00
Lance Edgar e4c46b3fa4 Add schema for TableSyncRules 2021-08-02 08:56:05 -05:00
Lance Edgar 178acdac31 Add basic 'lane_op' DB schema 
just the 'products' table so far
 2021-07-21 20:02:17 -05:00
Lance Edgar 170f0a769a Remove duplicated column name 2021-05-07 11:12:44 -05:00
Lance Edgar d94189c404 Add FK constraint for ProductLikeCode.upc 
not sure why that wasn't already present?
 2021-05-04 20:10:14 -05:00
Lance Edgar b40fbf7cab Add the Product.complete_size convenience attribute 
also define `str(VendorItem)`
 2021-02-15 12:59:21 -06:00
Lance Edgar 1757d09781 Add schema model for Purchase Orders 2021-02-01 15:35:22 -06:00
Lance Edgar ee9451588c Add basic support for Stores schema and API 2021-01-27 22:19:38 -06:00
Lance Edgar d398e706c4 Add MemberBarcode to op model 2021-01-13 19:18:17 -06:00
Lance Edgar 19d62b535f Tweak that thing again... 2020-12-31 19:25:33 -06:00
Lance Edgar 52d9595331 Fix Department.see_id field definition 
this is not a flag, but a minimum age requirement
 2020-12-31 19:01:40 -06:00
Lance Edgar ff428c4635 Misc. tweaks to product-related schema, for sake of generating SQL 
e.g. from IFPS data
 2020-12-09 13:09:58 -06:00
Lance Edgar 29638c062c Remove "default" values from Product model definition 
i'm a bit torn about this.  on the one hand i like there being some default
values here, but realistically they didn't all make sense.  also it could be
said that default values amount to business logic and that should stay in CORE
basically.

but in the end, i needed these to go away in order to simplify generating some
SQL INSERT statements.  was using SQLAlchemy core and it kept insisting that
all fields with a "default" defined should be part of the INSERT statement, but
really i didn't want them to be.  so they no longer have defaults.
 2020-12-07 17:41:01 -06:00