chaaals / se-financial-reporting Goto Github PK

Description

Napapansin ko we're using too many types of variable naming. May snake and camel case. Let's create a PR once we're done with the major features to refactor variables in snake case.

Let's utilize camel case in this project.

          change to their respective templates

Originally posted by @chaaals in #21 (comment)

          Work on `Add Trial Balance from GL (proof of concept)` in a separate PR and issue

Originally posted by @chaaals in #6 (review)

Description

Add the relevant assets for the front-end of the system.

Asset list

• PLM Logo
• Icons

(add more if we missed anything @marcusandrev)

• fr

  • (+) notes: long text null
  • (+) date: date
  • (-) tb_id

• fs

  • (~) statement_type --> fs_type
  • (+) report_id: from fr
  • (-) statement_name
  • (-) tb_id
  • (-) created_at

• tb

  • (+) report_id: from fr
  • (-) tb_name
  • (-) created_at
  • (-) date
  • (-) interim_period
  • (-) created_at

• rt

  • (~) template_name.length = 255 --> 20

• rearrange migrations

  • rt still first
  • fr now 2nd from 4th
  • tb now 4th from 2nd

Description

Create a model and migration for Trial Balance, Financial Reports, and Financial Statements.

References

ERD (Make sure its finalized)

• tb

  • (~) report_name -> tb_name
  • (~) report_status -> tb_status

• fs -> fs_collection

  • (-) fs_type
  • (-) fs_data
  • (-) template_name
  • (~) statement_id -> collection_id
  • (~) report_name -> collection_name
  • (~) report_status -> collection_status
  • (+) tb_id (foreign from tb)

• fs (new)

  • (+) fs_id (primary)
  • (+) collection_id (foreign from fs_collection)
  • (+) fs_type (enum)
  • (+) fs_data (longtext json)
  • (+) template_name (enum)

• report_notes (new)

  • note_id (primary)
  • report_id (foreign from tb->tb_id)
  • content (varchar)
  • author (varchar)

Description

Create excel templates for FS and TB.

Tasks

• Create Financial Statement templates with computation
• Create Trial Balance templates with computation

Description

Add unit tests for various Livewire components

Tasks

• Read Livewire documentation for running unit tests
• Implement unit tests per feature. TB, FS, and FR unit tests should be on different PRs

Description

Implement mobile responsive sidebar and navbar into general layout.

Description

Polish pages by adding semantics on application layout. Include meta tags and dynamic page naming.

Task

• Add meta tags
• Modfiy application layout

Description

Once we've already implemented everything, I'll remove bits of boilerplate code from the codebase para easier navigation for the integ team.

Description

Implement basic crud operations for FS feature.

Tasks

• List Financial Statements based on report type /financial-statements
• Support filtering on listing Financial Statements /financial-statements?type={ fs_type }
  Additional context: the reason for this type of URL is because of this dropdown in our sidebar
  
• Preview Financial Statement /financial-statements/{ fs_id }
• Delete Financial Statement
• Export Financial Statement

Description

Implement Financial Reporting feature.

Tasks

• List Financial Reports /financial-reports
• Preview Financial Reports /financial-reports/{ report_id }
• Add Financial Report /financial-reports/add
• Update Financial Report (only fields). Should be available on List and Preview Financial Reports
  Note: you can simply add an update method on Livewire Component
• Delete Financial Report. Should be available on List and Preview Financial Reports

Additional Notes

Integration with Trial Balance and FS can come later. Let's finish all CRUD functionalities for different features first then integrate them with one another. Let's try to finish this on this sprint.

• FR

  • (~) report_type --> interim_period
  • (+) fiscal_year: int = YYYY
  • (+) quarter = ['Q1','Q2','Q3','Q4']
  • (-) start_date
  • (-) end_date

• FS

  • (~) statement_type = ['SFPO', 'SFPE', 'SCNAE', 'SCF', 'SCBAA'] --> ['SFPO', 'SFPE', 'SCF']
  • (+) statement_name: varchar
  • (+) template_name: varchar

• TB

  • (~) period --> interim_period
  • (+) tb_type = ['Pre-closing', 'Post-closing']
  • (-) closing

Description

Create an API for Trial Balance feature

Tasks

• GET /api/trial-balances
• POST /api/trial-balances
• GET /api/trial-balances/:id
• PATCH /api/trial-balances/:id
• DELETE /api/trial-balances/:id

Description

For backend, we can implement websockets/laravel broadcast for real-time updates on the mentioned features.

Tasks

• Read about laravel broadcast
• Implement after defense

Description

For simulation purposes, in this repo, we will add Login and auth. This is so that we can play around w/ differen user views.

Description

Add soft delete to TB and FSC models to support archiving

Tasks

• Remove delete function when report status is "For Approval", "Change Requested", and "Approved"
• Add archive function on "Approved" reports

• fr
  • remove everything
• fs
  • (+) report_name
  • (+) report_status
  • (+) quarter
  • (+) approved
  • (+) date
  • (+) interim_period
  • (+) notes
  • (+) created_at
  • (+) updated_at
  • (-) report_id
• tb
  • (+) report_name
  • (+) report_status
  • (+) quarter
  • (+) approved
  • (+) date
  • (+) interim_period
  • (+) notes
  • (+) created_at
  • (+) updated_at
  • (-) report_id
• rt
  • no changes

Description

Create report templates table and model

Reference