👋Hello, James here!

Tracker

Improve the tracker system to aid in planning perpouses as well as day to day activities(presentations)

Activities
  • Improve the workplan module
    • Review the current model to ensure it can publish and accommodate this year's work plans
  • Change column name to App
  • Add a button on planner to add a project
  • Review the data model to ensure the system is able to aid in our day to day presentations
  • Evaluate the reletionship between the minutes and the activities in line with the new changes

Metavisuo

Improve the alredy existing Metavisuo system with additional create, reveiw, update and delete functionalities on data and metadata of Relational databases

Activities
  • CRUD
    • Creating
      • Learn mysql data defination language(Create, Alter, Truncate & delete)
      • Entities
      • Attributes
      • Relations
    • Review
      • Add buttons that:-
        • Expand the attributes to show the comments (separate with "//")
        • Expand the attributes to show the data types (Use TypeScript data types - on strings also show the max length)
      • Add click events for the attributes and the relations
      • Review of entity data in tabular format utilizing the new tabulation library
      • Saving of the svg viewbox settings to the metavisuo database
      • Modification of metavisuo database to help in hidding of
    • Update
      • Entities
      • Relations
      • Attributes
    • Delete entities relation attributes

Registration

Work on documentation of the level 1 registration and also start implementing the level 2 registration in the tracker system for purpouses of intern registration

Activities
  • Documentation of the level 1 registration
    • Mainstream the level 1 registration
  • Work on a detailed level 2 registration for interns
    • Work on a mechanism to get the information from a form
      • Improve the IO library to ensure it can facilitate the collection of clean data using user friendly forms
        • Consolidation of initially developed code:
          • Dialog - Data collection using forms which are dialog based
          • Browser - Explore files in a server
          • Flactuate - User friendly radio forms
          • Preview - User feedback on image file selections
          • Get Value & Set value - Read and populate quality data to forms
          • IO library - look at the pre existing Input output library with the aim of improving it with the code above

Rentize

Try to reproduce mutall rental invoices using the updated cte queries

Activities
  • CTEs
    • Rent CTE is done
    • Water calculation is done
    • Complete service charge (kangara)
    • Complete electricity (kibe)
    • Complete the adjustment (debit and credit) - George
    • Complete the opening balances (muli)
    • Loan tracking (mogaka)
  • Combine CTEs into a single structured query
  • Use the query to produce monthly invoice versions
    • SMS
    • A summary
    • A detailed

E-billing

An Android software that Automates the aquisition of electricity bill infomation from Kenya Power And Ligting Company(KPLC)

Activities
  • Monthly report on progress
  • Ensure that the existing code is working
    • Document the existing code. This will help to understand and remember the concepts
    • Work on improving the existing code
  • Formulate the last steps to completion of the application

Intern Support

Help the interns getting started.