JSFiddle - React, Tailwind, and code Playground

by schantanu

HTML

<p>
Tracked Items Features
</p>

JavaScript

// TO DO
// -----------------------------------------------------------------------------------------------
// 1. Admin Console
//    a. When a button is clicked, then disable the other buttons
//    b. Get Data
//       1. Update SQL with WINDOW clause
//       2. Update the Tracked Items table with Last Updated and Last Updated By field
//    c. Update Data
//       1. Show dropdown with 2 sections - Attribute Values (UPDATE, INSERT), Tracked Items (INSERT only), Add SKUs (INSERT)
//       2. Will take Approved requests from 'Requests' sheet
//       3. Trim the values while being uploaded
//    d. Reload Dropdowns
//    e. Review Requests
//       1. Will show the same menu as User Requests
//       2. Admin will get access to button to 'Approve' or 'Reject'
//       3. 'Approve'or 'Reject' will remove the notes and highlights in the cell
//       4. After SKU request, realign the notes in the 'Input' and 'Data' tab
//    f. Reset Sheets
//       1. If Input or Data sheet is reset, remove notes as well. Then use Requests sheet to reapply the notes and highlights
//
// 2. User Console
//    a. Attribute Manager
//       1. Trim field values once submitted by user
//       2. Once user submits a request, the Requests sheet is populated first
//       3. Once the requests sheet is populated, then apply the notes and highlights using the requests sheet.
//       4. For Common level, improve efficiency by adding notes to only the first cell of the Common ID attribute column
//       5. Check date formatting for Date fields requests
//    b. Review Requests
//       1. User gets to see only their requests
//       2. User only gets an option to edit or cancel requests
//    c. Update Values Attributes
//       1. User gets an option to add value (INSERT)
//       2. User gets an option to update existing value (UPDATE)
//    d. Add SKUs
//       1. Insert Common ID with ZHER and ZHWN (required)


//...