leiflm/bksystem

System for selling accouting sales based on sqlite3 and Enlightenment Foundation Libraries

bksystem's Issues

Doku UI

Show sale notification to user

If a sale is done, show a short notification perhaps with status.

SQLite schema of check_delete_user trigger

Views can't be modified. Either convert previous_fav_users to a table or remove the statements, that try to update the view as seen below.

CREATE TRIGGER "check_delete_user"
BEFORE DELETE ON "user_accounts"
FOR EACH ROW
BEGIN
SELECT CASE
WHEN OLD.uid = (SELECT userid FROM current_account_list)
THEN RAISE(ABORT, "Some unpaid products left in current_account_balance. Please make a new bill first.")
END;
DELETE FROM sales WHERE OLD.uid = sales.userid;
END;

Doku model / DB

show user status in views with color

Certain status codes in the user account list will prevent the user to purchase products. These user should be displayed in a different color.

set path of database function

function to set the path of the database, from where it will be loaded

DB constraints / default values

To avoid error while manipulating the database (adding user, etc.), add default values/constraints for tables where needed.
e.g. missig:

• defaults to status (user / product).

Use edj file for icons and ui configuration

administration user manual

The following actions should be documented / explained how they can be accomplished. Still there is more than one possible way. Mostly usage of SQL Manager extension for Firefox will be explained to allow administration from various platforms.

• adding/deleting products to database. including how to set the pictures.
• adding/deleting user_accounts.
• create/undo the bill.
• undo a sale.
• reset the sales history.

return DB not found error code to controller

if database is not found in configured path, an error code should be returned to the controller that it can take appropriate actions.

show path selection view/file browser

show UI where a user can select a new location of the database.

add product status

add status field to database. Purpose is to exclude a product from being listed in the application views without the necessity to delete it from the database. Document status codes and meaning.