B2BTranzact (using both SQL and NOSQL)
A simple B2B system with features of adding and updating documents.
React is used to power front-end.
React Router is implemented to change routes (not added routes for now)
Database used are SQL (for branch SQL) and NOSQL (for branch master).
# clone repo
$ git clone https://github.com/arihant-jain-09/B2B-transact.git
$ cd B2B - transact
#install dependencies
//for backend
$ npm install
//for frontend
$ cd client
$ npm install
for launch server
$ npm run dev
A user may not be assigned to any company, we need to add it as an employee.
After user becomes an employee it will be assigned a unique email and company_id by the company.
Separate products table for generating invoice of goods.
Endpoint
Info
/
Frontened on localhost:3000
/users
List all the users
/companies
List all the companies
/employee
List all the employee of the companies
/employee/invoice?employee_id=2
List all the invoices of an employee
/employee/invoice?employee_id=2&count=3
List all the invoices of an employee and limit results to 3
/employee/invoice?employee_id=2&count=3&page=2
List all the invoices of an employee, go to page 2 and limit results to 3
/employee/invoice?employee_id=2&count=3&page=2&status=pending
List all the invoices of an employee, go to page 2, filter by status of pending and limit results to 3
/invoices
List all the invoices
/invoices?count=2
List all the invoices with limit to 2
/invoices?count=2&sortBy=grand_total
List all the invoices , sort by grand_total and limit to 2
/invoices?count=2&sortBy=grand_total&page=2
List all the invoices , go to page 2, sort by grand_total and limit to 2
/invoices?count=2&sortBy=grand_total&page=2&filter_status=pending
List all the invoices , go to page 2, sort by grand_total, filter by status of pending and limit to 2
/invoices
List all the invoices
/products
List all the products
Endpoint
body params
Info
/addtable
sqlQueryAdds a table to tranzact database
/users
name usernameAdds a user with unique username
/companies
company_name email establishedAdds a company with unique name and email
/employee
email company_id user_idAdds an employee to the company
/invoices
employee_id seller_id buyer_id grand_total skuAdds an invoice (requires all body params)
/products
sku item_name priceAdds a product
Endpoint
body params
Info
/users/id
name usernameChange user properties
/companies/id
company_name email establishedAdds a company with unique name and email
/employee/id
email company_idChange email OR company_id or both.
/invoices/id
employee_id seller_id grand_total statusUpdate if employee_id is of seller company
/products/products/id
item_name price currencySKU is fixed once declared.
Invoices can be filtered based on grand_total or thier status.
Company can register user as its employee.
Separate Products table to keep track of all products.
Pagination in /invoices and /employee/invoice and filteration based on query params
Timestamp for all enteries.
