Commit graph

  • 0789cb89ea refactor: Convert currency tests to pytest and run in Docker pasky/sql-fixups-and-tests Petr Baudis 2025-04-23 16:45:06 +02:00
  • 8983ae13bf Reproducible Docker-based test environment Petr Baudis 2025-04-23 16:18:13 +02:00
  • e252390985 test--currency-rates: Make verbose to clarify the test is succeeding Petr Baudis 2025-04-23 16:16:47 +02:00
  • e738ca2b84 brmbar.Currency: Fix exception handling, Account.name is an attribute Petr Baudis 2025-04-23 16:16:30 +02:00
  • 3f45f52f60 schema/9,10,18: Fix to run with psql15 (files 11+ may still fail to load) Petr Baudis 2025-04-23 16:14:35 +02:00
  • fadf064387 Remove SQL-schema-*.sql obsolete files Petr Baudis 2025-04-23 16:14:02 +02:00
  • 0bff27da29 test reimplementation of brmbar.Currency.rates method TMA 2025-04-22 00:00:38 +02:00
  • f0058aad68 #18: stored function for "fixing cash" transaction TMA 2025-04-21 21:14:34 +02:00
  • c21b394b42 #17: stored function for "fixing" inventory transaction TMA 2025-04-21 21:14:18 +02:00
  • 69c405f715 #20: stored function for undo transaction TMA 2025-04-21 19:56:39 +02:00
  • c8892f825c cosmetic TMA 2025-04-21 19:56:15 +02:00
  • 96027ca66a #19: stored function for "consolidation" transaction TMA 2025-04-21 19:49:07 +02:00
  • aad79dafa6 fix bugs in schema version checking TMA 2025-04-21 18:45:00 +02:00
  • 1df7db93e7 #16: stored function for receipt reimbursement transaction TMA 2025-04-21 18:36:50 +02:00
  • 629b35655d #15: stored function for cash-based stock replenishment transaction TMA 2025-04-21 18:23:11 +02:00
  • ad832fc71b #14: stored function for "credit" transfer transactions TMA 2025-04-21 17:45:40 +02:00
  • e15f1646ce #13: stored function for cash withdrawal transactions TMA 2025-04-21 17:35:03 +02:00
  • 7b11a8c954 #12 - stored function for cash deposit transactions - remove duplicate fn TMA 2025-04-21 17:30:57 +02:00
  • f0cd8361d1 #12 - stored function for cash deposit transactions TMA 2025-04-21 17:23:24 +02:00
  • 7ed7417492 schema 0010: fix header id TMA 2025-04-21 17:06:42 +02:00
  • 028d4d98db #11: stored function for sale undo transaction TMA 2025-04-21 17:06:21 +02:00
  • deb3faa717 minor fixes in schemata 0009 and 0010 TMA 2025-04-21 12:27:29 +02:00
  • 4c7012c517 #10: stored function for cash sell transaction TMA 2025-04-21 12:22:22 +02:00
  • cef95c4313 #9: stored function for sell transaction TMA 2025-04-20 23:43:52 +02:00
  • aded7a5769 #8: stored function to update currency buy rate Dominik Pantůček 2025-04-20 19:27:02 +02:00
  • 66870bbc8c #7: migrate to stored function for updating currency sell rate. Dominik Pantůček 2025-04-20 19:22:19 +02:00
  • 9235607d4c #6: new currency stored function Dominik Pantůček 2025-04-20 19:15:23 +02:00
  • 8f42145bee #5: rename account stored function Dominik Pantůček 2025-04-20 18:00:40 +02:00
  • 58ab1d00be #4: add account to barcode stored procedure. Dominik Pantůček 2025-04-20 17:55:18 +02:00
  • c5d1fc3402 #3: create account in SQL not in Python. Dominik Pantůček 2025-04-20 17:42:12 +02:00
  • 111a8c9b63 #2: add trading account type type and fix schema migrations machinery Dominik Pantůček 2025-04-20 17:11:49 +02:00
  • c04f934340 #1: add initial SQL schema as the database currently in use Dominik Pantůček 2025-04-20 17:01:05 +02:00
  • 40f4abe37f Merge branch 'sql-refactor' TMA 2025-04-20 14:51:32 +02:00
  • 900264469a schema v2 setup script TMA 2025-04-20 10:13:31 +02:00
  • f6ec2be215 schema v1 setup script TMA 2025-04-19 22:44:01 +02:00
  • 3000731ac7 SQL schema v002 script part 1 TMA 2025-04-11 20:56:17 +02:00
  • 2f601a0b1a functions for querying sequence values for read only access TMA 2025-04-11 13:39:07 +02:00
  • 5f9292fd02 Merge code from deployed production version TMA 2025-03-30 20:58:03 +02:00
  • e04d614e15 uncommitted changes from other people... again TMA 2025-03-30 20:55:00 +02:00
  • dbd3835dfb fixed NaN issue in withdraw/charge master niekt0 2024-01-30 20:18:07 +01:00
  • 6749b2c97a autostock.py brmbar 2018-04-02 01:46:01 +02:00
  • a1c37cb695 brmbar-cli: restock by EAN (for automated restocking) brmbar 2018-04-02 01:41:24 +02:00
  • f061cc7f7b gitignore brmbar 2018-04-02 01:41:02 +02:00
  • 6f3fc6767a db purge howto brmbar 2018-04-02 01:40:46 +02:00
  • e2e6632df0 sample crontab file brmbar 2018-04-02 01:40:37 +02:00
  • 1f3f1cdd8f disable exchange rate and balance in StockMgmt because of unbearable slowdown brmbar 2016-08-19 04:37:04 +02:00
  • 466b92e7c2 uncommitted changes from other people... brmbar 2016-08-19 04:26:40 +02:00
  • 6208ae6027 Merge branch 'master' of https://github.com/brmlab/brmbar brmbar 2016-01-10 21:13:58 +01:00
  • 8f6776f3d0 brmbar-cli userlog Ruzicka Pavel 2016-01-10 21:07:47 +01:00
  • a9e72d736c brmbar-cli userlog brmbar 2016-01-10 21:03:59 +01:00
  • 0e306912d7 USAGE: Document brmbar-cli stats Petr Baudis 2016-01-07 05:26:40 +01:00
  • c419c91a40 brmbar-cli stats: separate material, logical accounts brmbar 2016-01-07 05:26:13 +01:00
  • c5becfcabe brmbar-cli stats: sum excess and deficit to Fixups brmbar 2016-01-07 05:20:50 +01:00
  • 2bfd1796d0 brmbar-cli stats: Separate credit and overflow brmbar 2016-01-07 05:06:37 +01:00
  • 9a70088591 USAGE: Fix pre within lists Petr Baudis 2016-01-06 05:02:24 +01:00
  • 11eaecfccf brmbar-cli changecash -> fixcash (changecash remains an alias) Petr Baudis 2016-01-06 02:00:56 +01:00
  • 0c349f6c6a USAGE: A few new scenarios for Administrative Usage Petr Baudis 2016-01-05 22:00:03 +01:00
  • e3a4fe880d brmbar-cli.py docs: Two examples brmbar 2016-01-04 21:04:49 +01:00
  • 4494dafbb8 Shop.inventory_balance(): Tidy up, commented out code for easy per-item balance dumps brmbar 2016-01-04 21:04:35 +01:00
  • 9e95724556 brmbar-cli.py sellitem: Allow selling for cash brmbar 2016-01-04 20:49:08 +01:00
  • 2bbb46d4ea brmbar-cli.py inventory-interactive: Tidy up code brmbar 2016-01-04 20:41:19 +01:00
  • 6b67dd372e brmbar-cli.py inventory-interactive: Try to detect mistaken barcode scan brmbar 2016-01-04 20:39:51 +01:00
  • edc99f1ff9 brmbar-cli.py docs: All commands are implemented brmbar 2016-01-04 20:35:43 +01:00
  • 7a8e4ef794 mplayer -really-quiet Pavel Ruzicka 2015-12-15 02:54:46 +01:00
  • 3ea61f01d7 brmbar-cli undo: New feature brmbar 2015-12-13 16:36:50 +01:00
  • feec2c9ac4 brmbar-cli restock: Print correct old balance brmbar 2015-12-13 16:36:21 +01:00
  • 76bb2cac98 brmbar-cli help: Nicer inventorization split Petr Baudis 2015-12-13 16:10:34 +01:00
  • 099d775102 Add missing collateral changes for Transfer Petr Baudis 2015-12-13 16:10:03 +01:00
  • 5c84bd6a8f GUI: Support for money transfer (by sachy + pasky) brmbar 2015-10-31 22:02:12 +01:00
  • a162e544c1 alert.sh: +x brmbar 2015-10-31 21:16:01 +01:00
  • 906a3b62ed brmbar-qt4: Add charge sound TrimenZ 2015-10-14 22:44:12 +02:00
  • fe80200e49 alert.sh TrimenZ 2015-10-14 22:39:36 +02:00
  • 48c583a81c Merge branch 'master' of github.com:brmlab/brmbar Mrkva 2015-07-01 01:08:12 +02:00
  • 934873c2fc Old uncommited changes, restock from cli, "cleanup bounty" feature Mrkva 2015-07-01 01:06:59 +02:00
  • 6cc95ab680 brmbar-qt4: Add ALERT_SCRIPT support to call external hook on low balance Petr Baudis 2015-06-04 23:06:57 +02:00
  • 1c0e51a246 brmbar-qt4: Add LIMIT_BALANCE(=-200) as a lower limit of user credit Petr Baudis 2015-06-04 22:57:20 +02:00
  • 84881dece3 * merge barcode-generator to master * quick howto on how current barcodes are generated Mrkva 2015-05-11 02:04:11 +02:00
  • 5de7bf7458 Disabled default and inefective computation of the stock sumary niekt0 2015-01-31 21:09:52 +01:00
  • 5bc7b0e004 runtime sql error fixed test_cache niekt0 2015-01-31 04:24:05 +01:00
  • 96bf23662e fixes from runtime niekt0 2015-01-31 04:11:28 +01:00
  • f922edf042 tab vs. spaces unification (python:( niekt0 2015-01-31 03:45:50 +01:00
  • 0d2bb2eed7 sign fix (credit vs. debit) niekt0 2015-01-31 03:38:08 +01:00
  • 15bb03e5fe Added caching of credit balance to accounts and replacing view account_balances. niekt0 2015-01-31 02:39:07 +01:00
  • 4604cd36c3 SQL: add column for disabling unused accounts Jiří Pinkava 2015-01-06 17:41:16 +01:00
  • d79dcb5a5c SQL transaction_cashsums: Update view to differentiate cash_credit, cash_debit Petr Baudis 2015-01-02 19:35:39 +01:00
  • 4c6558015f daily-summary.sh: Add granatove mate to the count Petr Baudis 2015-01-02 19:35:00 +01:00
  • 664e7a5b32 daily-summary.sh: New script Petr Baudis 2014-10-22 22:22:07 +02:00
  • 8229b44774 USAGE.md: Select for listing inventory items by their worth Petr Baudis 2014-06-06 20:39:58 +02:00
  • 6ed53b92aa Added Barcode for cash payment. Barcode is '_cash_'. Stevko 2014-05-11 02:38:53 +02:00
  • 65741c31f0 brmbar-web: By default hide out-of-stock items Petr Baudis 2014-04-06 21:29:04 +02:00
  • bf3fd3e842 brmbar-web: Listen publicly Petr Baudis 2014-04-06 21:18:52 +02:00
  • ae82675a60 brmbar-web: Color rows by balance Petr Baudis 2014-04-06 21:18:36 +02:00
  • 400ef9e969 brmbar.Currency: Include utf8 fenc declaration, e.g. for python2 compatibility Petr Baudis 2014-04-06 21:10:53 +02:00
  • e6870f8b2a brmbar-web: New trivial read-only UI Petr Baudis 2014-04-06 20:41:28 +02:00
  • 10d8a17723 SQL: Two new convenience views transaction_nicesplits and transaction_cashsums Petr Baudis 2013-08-31 19:11:14 +02:00
  • 22503c242f USAGE: + recipe to list all cash transactions brmbar 2013-08-11 23:07:26 +02:00
  • 617b466c77 brmbar-cli: New command consolidate to finalize inventory check brmbar 2013-08-11 22:53:53 +02:00
  • 4f3bc87733 Shop.inventory_balance(): Use buy price, not sell price brmbar 2013-08-06 22:30:27 +02:00
  • e567d36e77 USAGE: Add some useful SQL queries brmbar 2013-08-06 22:18:23 +02:00
  • d74ca2b6c0 Shop: Create null inventory fix transaction in case amount is correct brmbar 2013-08-06 21:51:58 +02:00