TEAM PROJECT: TEAM 9

# TEAM PROJECT: TEAM 9 # XP Core Values Tracker This section has been added to track the XP Core Values followed by the team each week. Simplicity -- the art of maximizing the amount of work not done -- is essential. ### Timeline ``` March 12, 2021 ``` * __Communication:__ Several discussions as a team on requirement overview. ``` March 19, 2021 ``` * __Courage:__ Tech stack discussions called for various team members to learn new skills so a common stack could be finalized. ``` March 26, 2021 ``` * __Communication:__ All members contributed equally in discussions for component wise assignment of tasks and what each person would own end to end. * __Respect:__ Each person's inputs were taken into consideration during design disussions. ``` April 2, 2021 ``` > __Varsha__ * __Communication:__ Discussions with Lasya to finalize Navbar component and its design in the application. > __Lasya__ * __Respect:__ As we discussed as team, we were respectful of each other's suggestion on design and implementation. > __Prathima__ * __Simplicity:__ Created a DB and created tables for customer side details and transaction details.Started with simple implementation of backend code using Sequelize ORM. > __Yi__ * __Communication:__ Discussion with team about database schema and create tables/data models for admin and transactions. ``` April 9, 2021 ``` > __Varsha__ * __Communication:__ Discussions with Prathima on schema design of the customer and accounts table. > __Lasya__ * __Simplicity:__ Created reusable commom react components. > __Prathima__ * __Simplicity:__ Decided to implement a simple layout for the customer end of application. > __Yi__ * __Simplicity:__ Implemented add transaction function with simple design and UI. ``` April 16, 2021 ``` > __Varsha__ * __Courage:__ Exploring React a little deeper to understand nuances of rendering. > __Lasya__ * __Feedback:__ Provided and adapted recieved feedback on common components like NavBar. > __Prathima__ * __Simplicity:__ Used React and Node js for implementing a view(internal transfer) that is easy for the customers to use. > __Yi__ * __Courage:__ Exploring Sequelize ORM library to develop add transaction api/backend. ``` April 23, 2021 ``` > __Varsha__ * __Simplicity:__ Design frotnend my accounts section of customer page to view own accounts and initiate requests. > __Lasya__ * __Courage:__ Looked for non-conventional approaches that could be used for token storage. > __Prathima__ * __Communication:__ Discussions with Lasya regarding a Customer login and Customer landing page. > __Yi__ * __Simplicity__ Disigned admin transaction view with simple functions for the requirements and implemented the backend api. ``` April 30, 2021 ``` > __Varsha__ * __Simplicity:__ Added backend sequelize models for account and customer relations. > __Lasya__ * __Simplicity:__ Added MySQL stored procedures to handle backend logic for credential generation to keep iplementation effective and efficient. > __Prathima__ * __Communication:__ Discussions with Varsha regarding alteration in Accounts table to include an attribute for existing account and closed ones. > __Yi__ * __Courage:__ Exploring React components and refactoring code to implement admin transaction functions on same page. ``` May 7, 2021 ``` > __Varsha__ * __Communication:__ Discussions with remaining team members for remaning tasks completion, plans for deployment. > __Lasya__ * __Feedback:__ Collaborated with team for integration test and identify pending items and improvements. > __Prathima__ * __Simplicity:__ To implement final changes on the customer accounts page and display account details based on UserId. > __Yi__ * __Feedback:__ Collaborated with team for integration test and identify pending items and improvements. # Weekly Scrum Report This section has been added to track the weekly scrum report and contribution by each team member. ### Timeline ``` March 12, 2021 ``` * Several discussions as a team on requirement overview. ``` March 19, 2021 ``` * Tech stack discussions - finalizing the database to be used, frontend and backend frameworks. Research by each team member to explore tech stack. ``` March 26, 2021 ``` * Component wise assignment of tasks and what each person would own end to end. Design discussions to finalize database schemas to implement. ``` April 2, 2021 ``` > __Varsha__ * __What tasks did I work on / complete?:__ Basic UI design + common navbar component design. Admin new acount page. * __What am I planning to work on next?:__ Backend query for create account. * __What tasks are blocked waiting on another team member?:__ NA > __Lasya__ * __What tasks did I work on / complete?:__ Implemented Landing page in UI * __What am I planning to work on next?:__ Planning to work on Customer Login UI * __What tasks are blocked waiting on another team member?:__ NA > __Prathima__ * __What tasks did I work on / complete?:__ Wireframes; Database table creation, adding data to table * __What am I planning to work on next?:__ Customer accounts transfer (internal) * __What tasks are blocked waiting on another team member?:__ NA > __Yi__ * __What tasks did I work on / complete?:__ Database schema design and set up data model for admin and transactions. * __What am I planning to work on next?:__ Frontend development for admin new transaction. * __What tasks are blocked waiting on another team member?:__ NA ``` April 9, 2021 ``` > __Varsha__ * __What tasks did I work on / complete?:__ Backend api for create acount. (UI) Template page for Admin view of new account requests. * __What am I planning to work on next?:__ (UI) Finalize Admin side account management console. * __What tasks are blocked waiting on another team member?:__ NA > __Lasya__ * __What tasks did I work on / complete?:__ Completed customer login UI and basic backend validation. * __What am I planning to work on next?:__ Work on backend authentication implementation and External Payee UI * __What tasks are blocked waiting on another team member?:__ NA > __Prathima__ * __What tasks did I work on / complete?:__ Customer accounts transfer page (backend & frontend) * __What am I planning to work on next?:__ Customer accounts display * __What tasks are blocked waiting on another team member?:__ NA > __Yi__ * __What tasks did I work on / complete?:__ Frontend development for admin new transaction. * __What am I planning to work on next?:__ Admin new transaction backend api development. * __What tasks are blocked waiting on another team member?:__ NA ``` April 16, 2021 ``` > __Varsha__ * __What tasks did I work on / complete?:__ (UI) Admin side account management console to create new customer account, update new account requests, update account closure requests. * __What am I planning to work on next?:__ (UI) Customer side request new account, closure of account. * __What tasks are blocked waiting on another team member?:__ > __Lasya__ * __What tasks did I work on / complete?:__ Worked on External payee UI and completed JWT setup. * __What am I planning to work on next?:__ Complete implementation for external payee functionality * __What tasks are blocked waiting on another team member?:__ NA > __Prathima__ * __What tasks did I work on / complete?:__ Customer accounts display(front end & backend); View transaction - backend * __What am I planning to work on next?:__ Complete view & search transactions * __What tasks are blocked waiting on another team member?:__ NA > __Yi__ * __What tasks did I work on / complete?:__ Admin new transaction backend api development. * __What am I planning to work on next?:__ Admin all transaction view api development. * __What tasks are blocked waiting on another team member?:__ NA ``` April 23, 2021 ``` > __Varsha__ * __What tasks did I work on / complete?:__ (UI) Customer side request new account, closure of account. Created sequelize model for association between tables. * __What am I planning to work on next?:__ Backend Apis for account creation and closure service requests. * __What tasks are blocked waiting on another team member?:__ > __Lasya__ * __What tasks did I work on / complete?:__ Completed UI for external payee and implement Backend APIs for onetime payment. * __What am I planning to work on next?:__ Implmentation on recurring external payment * __What tasks are blocked waiting on another team member?:__ NA > __Prathima__ * __What tasks did I work on / complete?:__ Completed view & search transactions (frontend & backend) * __What am I planning to work on next?:__ Changes on navbar * __What tasks are blocked waiting on another team member?:__ Waiting for completion of customer login page > __Yi__ * __What tasks did I work on / complete?:__ Admin all transaction view api development. * __What am I planning to work on next?:__ Frontend development of admin all transaction view. * __What tasks are blocked waiting on another team member?:__ ``` April 30, 2021 ``` > __Varsha__ * __What tasks did I work on / complete?:__ Design backend apis from admin and customer end for account creation and closure. Research on implementing transactions in sequelize for ACID properties. * __What am I planning to work on next?:__ Add apis to Backend and test via postman. Link backend to frontend. Deployment. * __What tasks are blocked waiting on another team member?:__ NA > __Lasya__ * __What tasks did I work on / complete?:__ Implemented Backend APIs for External payee recurring payment. * __What am I planning to work on next?:__ Permon unit testing * __What tasks are blocked waiting on another team member?:__ NA > __Prathima__ * __What tasks did I work on / complete?:__ Implemented user name restriction & navbar; documentation * __What am I planning to work on next?:__ Add final screenshots and documentation * __What tasks are blocked waiting on another team member?:__ NA > __Yi__ * __What tasks did I work on / complete?:__ Frontend development of admin all transaction view. * __What am I planning to work on next?:__ Admin login implementation, integration test * __What tasks are blocked waiting on another team member?:__ ``` May 7, 2021 ``` > __Varsha__ * __What tasks did I work on / complete?:__ Added backend apis and connetion to frontend. * __What tasks are blocked waiting on another team member?:__ > __Lasya__ * __What tasks did I work on / complete?:__ Fixed the bugs in external payee functionality. and implemented auto credential generation logic. * __What tasks are blocked waiting on another team member?:__ > __Prathima__ * __What tasks did I work on / complete?:__ Final screenshots of the application; Pushed final changes; Documentation * __What tasks are blocked waiting on another team member?:__ NA > __Yi__ * __What tasks did I work on / complete?:__ Add admin login function. Integration test. * __What tasks are blocked waiting on another team member?:__ NA # UI Wire Frames This section has been added to show the UI wire frames the team used a a guideline for deisgning the UI components. __Admin Views:__ ![Admin Wireframes](./frontend/wireframes/admin_views.png) __Customer Views:__ ![Customer Wireframes](./frontend/wireframes/customer_views.png) # Database Schema Design ![Database Schema](./backend/backend_schema.png) # Architecture Diagram // to be done # Deployment Diagram // to be done # Design Decisions * Decided to use MySql database rather than MongoDB since bank data are structured and relational. * Decided to have separate login for customer and admin, and use token instead of cookie since token is good for scaled system and bank data are secure and sensative. * # Link to burndown chart

Syntax	Example	Reference
# Header	Header	基本排版
- Unordered List	Unordered List
1. Ordered List	Ordered List
- [ ] Todo List	Todo List
> Blockquote	Blockquote
Bold font	Bold font
Italics font	Italics font
~~Strikethrough~~	~~Strikethrough~~
19^th^	19^th
H~2~O	H₂O
++Inserted text++	Inserted text
==Marked text==	Marked text
[link text](https:// "title")	Link
![image alt](https:// "title")	Image
`Code`	`Code`	在筆記中貼入程式碼
```javascript var i = 0; ```	`var i = 0;`
:smile:		Emoji list
{%youtube youtube_id %}	Externals
$L^aT_eX$	L^aT_eX
:::info This is a alert area. :::	This is a alert area.