summaryrefslogtreecommitdiffstats
path: root/src/database/database.vala
AgeCommit message (Collapse)AuthorFilesLines
2022-12-18web: show aliases in product detail pageHEADmasterSebastian Reichel1-0/+21
2018-08-27Merge branch 'master' into better_inventoryHolger Cremer1-95/+176
Conflicts: README data/templates/products/entry.html docker/Dockerfile docker/init.sh src/database/database.vala src/database/db-interface.vala src/pdf-stock/Makefile src/pdf-stock/pdf-stock-interface.vala src/pdf-stock/pdf-stock.vala src/web/Makefile src/web/main.vala templates/menu.html templates/products/index.html
2018-07-26adds an inventory functionHolger Cremer1-0/+11
2018-07-20database: fix get_product_for_eanSebastian Reichel1-5/+5
2018-07-18database: fix stock_statusSebastian Reichel1-1/+1
2018-07-17database: add add_category(name)Sebastian Reichel1-0/+18
2018-06-29all: I18N supportSebastian Reichel1-44/+44
This adds I18N support using standard gettext system together with an initial German translation. This can be used to search locales in some directory: Intl.bindtextdomain("shopsystem", "/home/sre/src/serial-barcode-scanner"); And this can be used to switch language at runtime: Intl.setlocale(LocaleCategory.ALL, "");
2018-06-28Update CopyrightJohannes Rudolph1-0/+1
2018-06-28all: Add DBusError to avoid warnings with valac 0.40Sebastian Reichel1-53/+54
2018-06-28Add RFID supportJohannes Rudolph1-0/+46
2018-06-28database: add method to retrieve product details with pricesJohannes Rudolph1-5/+20
2017-06-13adds the joined_at column and support in the db/webHolger Cremer1-3/+5
2017-05-07keeps the sound_theme value on user import (by using a sub select)Holger Cremer1-1/+2
2017-04-16adds a new feature: a user can select it's sond theme in the web interface. ↵Holger Cremer1-11/+40
If not selected, a random theme is used.
2016-09-17move disabled flag from auth table to user tableSebastian Reichel1-11/+13
2016-04-10database: add set_user_auth()Sebastian Reichel1-0/+23
2016-01-21database: handle sqlite constraint exception speciallySebastian Reichel1-1/+3
2015-10-28add product categorySebastian Reichel1-6/+42
2015-10-28database: implement the invoice view change for database querySebastian Reichel1-2/+2
This change ensures, that older invoices for special users (< 0) are not affected by future price changes.
2015-09-15web: new product list sorted by best before dateSebastian Reichel1-10/+52
2015-09-13Add support for aliased EANsSebastian Reichel1-0/+43
Some products are sold under different EANs (e.g. per-country EANs). The alias table can be used to map multiple EANs to a single product.
2015-04-07cashbox: add page with detailsSebastian Reichel1-0/+21
2015-03-08web: cashbox: try makeing update function foolproof and add historySebastian Reichel1-0/+18
2015-02-16web: support setting product deprecation stateSebastian Reichel1-0/+30
2015-02-14web: more detailed authentication systemSebastian Reichel1-1/+7
2014-02-02database: do not use invoice viewSebastian Reichel1-2/+2
using the view results in sqlite not making use of the sales index.
2013-06-15cashbox trackingSebastian Reichel1-0/+27
2013-05-24add minimal support for deprecation flagSebastian Reichel1-1/+1
2013-05-11database: postcode is string, add get_user_invoice_sum()Sebastian Reichel1-3/+18
2013-05-09database: add get_users_with_salesSebastian Reichel1-0/+14
2013-04-28report sale removal to UIdbusSebastian Reichel1-3/+4
2013-04-27db: get_user_auth: return defaults if user not foundSebastian Reichel1-1/+1
2013-03-26fix merge conflictSebastian Reichel1-8/+2
2013-03-26code restructureSebastian Reichel1-0/+846
generated by cgit v1.2.3 (git 2.39.1) at 2024-05-05 12:15:35 +0000