workweek.js 821 B

1234567891011121314151617181920212223242526272829303132333435
  1. const { register, Sequelize } = require('@alancnet/material-framework/auto-crud')
  2. register({
  3. camelName: 'workweek',
  4. // iconAsset: 'terminalIcon',
  5. showNav: false,
  6. schema: {
  7. id: {
  8. type: Sequelize.UUID,
  9. defaultValue: Sequelize.UUIDV1,
  10. primaryKey: true
  11. },
  12. startDate: Sequelize.DATEONLY,
  13. terminalId: Sequelize.UUID,
  14. hours: Sequelize.DOUBLE,
  15. regularHours: Sequelize.DOUBLE,
  16. overtimeHours: Sequelize.DOUBLE,
  17. doubletimeHours: Sequelize.DOUBLE,
  18. laborCost: Sequelize.DECIMAL(19, 4),
  19. inbound: Sequelize.INTEGER,
  20. delivered: Sequelize.INTEGER,
  21. laborCharge: Sequelize.DECIMAL(19, 4)
  22. },
  23. options: {
  24. paranoid: true,
  25. indexes: [
  26. {
  27. unique: true,
  28. fields: ['startDate', 'terminalId']
  29. }
  30. ]
  31. },
  32. columns: [],
  33. layout: []
  34. })