The current ID generation strategy is AUTO

• Postgres
• Oracle
• check sequence per table is better
• check for better strategies
• check generationstrategy in legacy app

on Oracle the value will be pulled from hibernate_sequence which is not initialized (why?)

User passwords should be encrypted

Item overview

simply by entity/id , take a look at permissions!

relations in entities are missing, add 'em from original

Latest builds failed due to missing hibernate dependency.

The relation at https://github.com/devtty/store/blob/master/src/main/java/org/devtty/store/entity/Client.java#L20-L21 doesn't exist in the original code (check) but sounds useful.

• User
• Customer
• Collections
• Store
• Items
• Order
• Contractors
• Contract

font-awesone could be used to find some nice icons

The item table has different colours for items.

all conditions are dependent from holidays at the location of the item.

Project was left alone long ago...
... run it again

generate a random number (uid), store it and use it (later) for anonymized usage data

This could improve requirements planning

sub task from #8 create a CRUD form Item

Additionally to #11

Requirements

Very important: This must be voluntary and it must be possible (for each user) to switch off this function. A hierarchical solution would be good, e.g. submitting can be switched off:

• for everything by admin
• if admin allow than managers can switch off for there dept.
• ...

Further implementation details

Because this isn't a main feature a simple mail logger is enough.

Some entities need repos

FormValidation

value taken from WEB-INF/validation.xml in legacy application. These are validation constraints for the input form (maybe not necessary for bean validation)

User

• client required
• id integer
• name required, maxlength 60, minlength 3
• loginname required, maxlength 25, minlength 6
• pass required, maxlength 32, minlength 6
• email , email

Client

• name, required, maxlength 255, minlength 3
• address, maxlength 255

Collection

• client required
• id integer
• infos maxlength 4000
• status integer
• outNr maxlength 12
• outVehicleId maxlength 30
• outDestination maxlength 150
• outIncome date
• itemKey integer bw. 1 and 2147482647 (seems 2b loose relationship/referencing)

store

• id integer
• name required, maxlength 64
• address maxlength 250

item

• clientref maxlength 20
• kolli required, integer
• vehicleNr maxlength 20
• status required
• consolidation maxlength 12 (loose reference)
• startlocation maxlength 50
• startdate date
• startcorp maxlength 250
• name required, maxlength 100 minlength 3
• indate date
• inMProblem maxlength 4000
• inW required, mask ^[0-9],?[0-9]$
• istGewicht mask ^[0-9],?[0-9]$
• inWProblem maxlength 4000
• inV mask ^[0-9],?[0-9]$
• docs maxlength 200
• bvdInfo maxlength 255

Contract

• createdBy required
• client required
• id required
• adr maxlength 30
• additional maxlength 250
• ass required maxlength 1000
• bruttoweight required
• contact maxlength 100
• createexa required
• createt1 required
• execdate required
• fixterm maxlength 30
• laddress required, maxlength 500
• sender maxlength 50
• vaddress required maxlength 500
• name required maxlength 300
• annotation maxlength 250
• type maxlength 50

Contractor

• name required
• address required
• phone required
• fax required
• email email

Consolidation

• orderNr required mask ^(\d{6})$
• client required
• adr maxlength 30
• additional maxlength 250
• ass required, maxlength 1000
• bruttoweight required
• contact maxlength 100
• createexa required
• createt1 required
• execdate required
• fixterm maxlength 30
• laddress required maxlength 500
• sender maxlength 50
• vaddress required maxlength 500
• name required maxlength 300
• annotation maxlength 250
• type maxlength 50
• status required
• priceFreight required mask ^(\d+,\d{2})$
• priceExa required mask ^(\d+,\d{2})$
• priceT1 required mask ^(\d+,\d{2})$
• priceInsurance required mask ^(\d+,\d{2})$
• priceRoadCharge required mask ^(\d+,\d{2})$
• priceOther required mask ^(\d+,\d{2})$
• priceVAT mask ^(\d+,\d{2})$

checkout font awesome for some icons

http://deltaspike.apache.org/documentation/data.html

the package contains StrutsActions

Minimal form login first
jboss-developer/jboss-picketlink-quickstarts

For pf

Parameter like wga wgb etc should be stored in own table

image reloading takes place on every request (ajax calls included)

Store

• errormessage
• select
  • visible for supervisor when status 0 or 1
  • visible for internal when status 0 or 1
• static text
  • visible for supervisor and internal when status -1 or >1
  • visible for storage
  • visible for client

Client

• errormessage
• select
  • visible for supervisor when status 0 or 1
  • visible for internal when status 0 or 1
• static text
  • visible for supervisor and internal when status -1 or >1
  • visible for storage
  • visible for client

ClientRef

• errormessage
• textinput maxlength 20 size 20
  • visible for supervisor
  • visible for internal
• static text
  • visible for storage
  • visible for client

Name

• errormessage
• textinput size 50 maxlength 100
  • visible for supervisor, internal, storage
• static text
  • visible for client
• hidden in split mode

inDate

• errormessage
• calendar dateinput
  • visible for supervisor, internal
• static text
  • visible for storage and client

Kolli

• errormessage
• text input
  • visible for supervisor
  • visible for internal
  • visible for storage
• static text
  • visible for client

Palette

• errormessage
• text input
  • visible for supervisor
  • visible for internal
  • visible for storage
• static text
  • visible for client

State

• errormessage
• select
  • visible for supervisor and internal
    • sequencial state processing
  • visible for storage
    • sequencial state processing
• static text
  • visible for client

Consolidation

• errormessage
• text field size 12 maxlength 12
  • visible for supervisor and internal
    • when consolidation editing is allowed (disabledVhEdit false)
      • additional choice of consolidation proposals
        • only visible in Role Supersvisor or Accounting
    • when consolidationediting isn't allowed
      • disabled
      • link/button to disconnected consolidations
• static text
  • visible for storage
  • visible for client

vehicle

• errormessage
• text input size 50 maxlength 50
  • visible for supervisor
  • visible for internal
• static text
  • visible for storage
  • visible for client

startlocation

• errormessage
• text input size 50 maxlength 50
  • visible for supervisor
  • visible for internal
• static text
  • visible for storage
  • visible for client

sender

• errormessage
• text input size 50 maxlength 250
  • visible for supervisor
  • visible for internal
• static text
  • visible for storage
  • visible for client

ex

• errormessage
• boolean select
  • visible for supervisor
  • visible for internal
• boolean graphic
  • visible for storage
  • visible for client

adr

• errormessage
• boolean select
  • visible for supervisor
  • visible for internal
• boolean graphic
  • visible for storage
  • visible for client

inVOk

• errormessage
• text input
  • visible for supervisor
  • visible for internal
  • visible for storage
• static text
  • visible for client

storereport

#docWeight

inWOk

• errormessage
• boolean select
  • visible for supervisor
  • visible for internal
  • visible for storage
• boolean graphic
  • visible for client

isWeight

• errormessage
• text input
  • visible for supervisor
  • visible for internal
  • visible for storage
• static text
  • visible for client

weightproof

• errormessage
• boolean select
  • visible for supervisor
  • visible for internal
  • visible for storage
• boolean graphic
  • visible for client

vol

• errormessage
• text input
  • visible for supervisor
  • visible for internal
  • visible for storage
• static text
  • visible for client

docs

• errormessage
• text input size 50 maxlenght 200
  • visible for supervisor
  • visible for internal
• static text
  • visible for storage
  • visible for client

bvdinfo

• errormessage
• textinput size 50 maxlength 255
  • visible for supervisor
  • visible for internal
• static text
  • visible for storage
  • visible for client

t1

• errormessage
• boolean select
  • visible for supervisor
  • visible for internal
• boolean graphic
  • visible for client
  • visible for storage

customsdate

• errormessage
• calendar dateinput
  • visible for supervisor, internal
• static text
  • visible for storage and client

legacy application folder sql contains database init scripts; migrate to liquibase changesets

;-)

to build process

Enhance startup execution - Startup.java - maybe some additional functionality is helpful:

• Health check
• Anonymous Usage Data

• iCal
• xls / csv
• CalDav

If DB record for startup count doesn't exist. Catch Exception and add entry to database.

This is missing a button to collect items

check legacy InitRwLagerungSearchAction:

• input is a list of items
• check if all items belong to same store and same client (could be done in background/on selection)
• if all items belong to same store and client it initializes a new collection (collection form with array of those items)
• if not return to item overview

https://github.com/apache/myfaces/tree/master/extensions/quarkus/showcase

See There

The delete button should be disabled or not rendered for non supervisors.

• security

sth. like webcastellum maybe

Collections contain several Items