Working on Saved Screen of App

Saved Screen displays downloaded CDM which are saved to SQL database, User can view any CDM from SQL database.I have created separate BLoC for this.

For getting list of saved screen , I am searching all tables in database.

Screen UI

download_cdm

Made DAO ( Data Access Object )

This directly queries the database, I have created following Queries

  • Create Table with column ( description, charge, category )

  • Inserting CDM to table

  • Searching particular procedure in Database & converting result to list

  • Getting data of table

Worked on Search Screen & Filter Functionality

In search screen user can search for any procedure, the procedure will be queried in database, which returns list. I have also worked on filter functionality of App.

In Filter Functionality user can sort list by

  • Category which is of three types - Standard, DRG , Pharmacy

  • Price in Ascending or Descending Order

I have also created a "Clear All" button , which clears the filter.

I am saving these filter data to Hive as key-value Pair

UI

download_cdm

What do I plan to do next week?

For Web Scraper

  • Scraping CDM of California State

  • Making Separate Spider class for it

  • Generating “process.py” script for each hospital

  • Making generate.py file by which user can generate “process.py” scripts which will parse CDM to proper columns

For App

  • Working on View CDM Statewise screen.

  • Making seperate BLoC for it.

  • Using GitLab API to get CDM of each state