Making selections inactive

[steveblamey]

There are many places in uzERP where unused, or no longer required items, should not be available for selection. For example, users often want to stop using certain GL codes or centres but there is currently no way to stop them being available to select throughout the system.

I propose that we add a column, perhaps named 'item_active', to each db table/view that may contain items that the user has decided should no-longer be used. This could be a simple boolean field, default true.

We can adjust the getAll()* function on the DataObject to filter out the selected items by default so they are not shown in select lists, etc in the UI. Using the same column name on each table facilitates this.
* The getALL function retrieves arrays that are used to populate dropdowns, etc. in most templates

Ideally, the DataObject code should also be updated to prevent the saving of new records containing inactive codes.

[steveblamey]

See also #195

[mshiner]

@steveblamey agreed that this could be a useful enhancement.

Perhaps it could be used as a first step to selecting contacts for batch deletion (see #116)