AppsScript

The GAMEPLAN is to start working on software projects required by existing clients of LikhaInternet, that can also be used by other businesses including LikhaInternet itself.  The software must be complementary with the Google Cloud / Workspace Ecosystem, and the projects will be coded using javascript-based Google AppsScript. 

SUMMARY OF NEEDED SOFTWARE

PROJECT UPDATES

HRIS & Payroll Application

1. Front-end application

   • Find low cost and compatible RFID/Smart card device - completed

   • Procure sample device and tags - application approved and device delivered 9/16/2021

   • Test and evaluate the device and SDK - completed

   • Development of the application (Device registration/binding, time-in/out, time sync, and employee enrollment)

• Started development 

  • Connecting to reader - done

  • Get reader status - done

  • Card polling and scanning - done

  • Device binding, get card UID  - done

  • Employee ID enrollment - done

  • Sync user info from backend DB - done

    • Update local user database with the data from the API - done

    • Sync enrolled users to backend - done

  • Time in/out - done

  • Time log upload to backend - done

    • API for syncing time logs - done

  • Web cam integration for face capture - done

2. Backend application (Web App) - done

   • Basic functions (Employee module)

     • Add, Update, View - done

     • Access control - done

     • Create other sheets and fields (Departments, shifts, employee hierarchy, etc.) - done

   • HR module - on-going

     • Timekeeping - done

     • Leave, overtime, official business filing - pending

   • Accounting module - Completed

     • Payroll computation and approval - done

     • Payslip generation - done

   • Calendar and email integration - pending

   • Web API - on-doing - Completed

     • GET user list API - done

     • POST user updates - done

     • Time sync to work with the front-end application POST - done

3. QA test and bug fix

4. Web based time-in and time-out interface for remote users - on-going

   • Create a separate UI/App dedicated for time-in and time-out - done

   • Added real-time date & time - done

   • Interface with device camera (mobile or laptop) to get snapshot - done

   • Create function to save snapshot to Google Drive - done

   • Add time-in and time-out functionality to interact with DB (Spreadsheets) - done

LMS

1. Research & Functionality Test

   • Google classroom API through Apps Script

   • Read & write classes, teachers, and students

2. Development

   • Role-based access (Domain Admin) - completed  

   • Organization/Company enrollment - Completed

   • User registration - Completed

   • Update (Organization info & users including changing approval status) -Completed

   •  Teachers and student access (Dashboard) - Pending

   • Add, edit, assign, and delete courses - Pending