# Project: Report Generator for EHR **URL:** \ **Category:** EHR\ **Tags:** gsoc2018, ehr, gsoc2018-project\ **Created:** [April 23, 2018, 6:57pm UTC](https://forums.librehealth.io/t/project-report-generator-for-ehr/2327 "2018-04-23T18:57:43Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![Trodrige](https://forums.librehealth.io/user_avatar/forums.librehealth.io/trodrige/32/447_2.png) [@Trodrige](https://forums.librehealth.io/u/Trodrige)\ **Post date:** [April 23, 2018, 6:57pm UTC](https://forums.librehealth.io/t/project-report-generator-for-ehr/2327/1 "2018-04-23T18:57:43Z")
@pri2si17@aethelwulffe @teryhill @tony I’m opening this thread for discussions and way forward on the report generator. Read the overview of the project here: [https://summerofcode.withgoogle.com/dashboard/project/4707875692216320/details/](https://summerofcode.withgoogle.com/dashboard/project/4707875692216320/details/) ---
**Author:** ![teryhill](https://forums.librehealth.io/user_avatar/forums.librehealth.io/teryhill/32/58_2.png) [@teryhill](https://forums.librehealth.io/u/teryhill)\ **Post date:** [April 23, 2018, 7:14pm UTC](https://forums.librehealth.io/t/project-report-generator-for-ehr/2327/2 "2018-04-23T19:14:53Z")
Can you put a check list of the major items for the project here ? ---
**Author:** ![Trodrige](https://forums.librehealth.io/user_avatar/forums.librehealth.io/trodrige/32/447_2.png) [@Trodrige](https://forums.librehealth.io/u/Trodrige)\ **Post date:** [April 23, 2018, 8:18pm UTC](https://forums.librehealth.io/t/project-report-generator-for-ehr/2327/3 "2018-04-23T20:18:23Z")
Below is a list of the major modules for the project. These items can change depending on the discussion we have during this period. At least the items below is how I see the project. 1. User-friendly interface with components. (Components are the draggable elements that represent particular report columns). 2. Adding drag and drop features to components. 3. Generating queries based on user’s chosen components. 4. Formatting and rendering report data. 5. Support for various output types (pdf, csv). 6. Documentation of the tool. WELCOME to your all your ideas, questions and contributions. ---
**Author:** ![Trodrige](https://forums.librehealth.io/user_avatar/forums.librehealth.io/trodrige/32/447_2.png) [@Trodrige](https://forums.librehealth.io/u/Trodrige)\ **Post date:** [May 7, 2018, 5:40pm UTC](https://forums.librehealth.io/t/project-report-generator-for-ehr/2327/4 "2018-05-07T17:40:14Z")
What do you all think of creating a new Laravel EHR project to track the changes made by @pri2si17 and me. I’m just saying this to get your thoughts. @aethelwulffe @teryhill @tony I know it’s a little more work checking different places for changes, but what do you think? ---
**Author:** ![Trodrige](https://forums.librehealth.io/user_avatar/forums.librehealth.io/trodrige/32/447_2.png) [@Trodrige](https://forums.librehealth.io/u/Trodrige)\ **Post date:** [May 16, 2018, 7:38pm UTC](https://forums.librehealth.io/t/project-report-generator-for-ehr/2327/5 "2018-05-16T19:38:18Z")
This is the link to my first blog post for GSoC18. > **[1: GSoC18 at LibreHealth - The ball is rolling with LibreHealth.](https://medium.com/@tigrodrige/gsoc-2018-the-ball-is-rolling-with-librehealth-fb5838cc7492)** > > BANG BANG, I’ve been accepted for GSoC 2018. BANG BANG BANG, my proposal to work on LibreHealth’s EHR system was accepted. Link to second article: > **[2: GSoC18 at LibreHealth - Community bonding ends, CODING starts!](https://medium.com/@tigrodrige/2-gsoc18-at-librehealth-community-bonding-ends-coding-starts-e815c94499d4)** > > The first phase of Google Summer of Code 2018 closed on May 14th. ---
**Author:** ![Trodrige](https://forums.librehealth.io/user_avatar/forums.librehealth.io/trodrige/32/447_2.png) [@Trodrige](https://forums.librehealth.io/u/Trodrige)\ **Post date:** [May 16, 2018, 7:57pm UTC](https://forums.librehealth.io/t/project-report-generator-for-ehr/2327/6 "2018-05-16T19:57:25Z")
@pri2si17 @teryhill @aethelwulffe I wish to know how we’ll display the draggable components in the report generator. I need you all to pour your ideas here. I need this to keep moving with coding. This is what I’m thinking. The reports have particular tables and columns from which they’re generated. So we can sort those tables and columns, and create ‘table components’ which have ‘column draggable components’ which appear as dropdown list under the particular table. This is going to be lots of components to display. We’ll use tooltips to show more information for a particular column. This route is painful, but this is what I have for now. Terry suggested we use the lists in the system to create the draggable components. In his method it’ll be easy to get the query that we’ll need to execute at the back. ‘Wise Gramps Terry’ explains that we’ll have draggable components like this: - Patient\_Full :patient\_data|fname|mname|lname - Patient\_Last\_first :patient\_data|lname|fname - Patient\_full\_reverse :patient\_data|lname|fname|mname Patient\_Full, Patient\_Last\_first and Patient\_full\_reverse will be the draggable components (and will appear as title in the list). patient\_data is that table, that has columns fname,lname, mname. the user will choose the component in any order that suits them. The lists in the system have fields, id, title, order, default, active which are mandatory. We’ll fill these fields accordingly. ‘The wise man’, @teryhill says we’ll add fields; notes, toggle\_1 and toggle\_2. - **notes** is something like this: patient\_data|lname|fname|mname. This will give the field the generator needs to generate a report. - **toggle\_1** : sorts each column depending on the value of the checkbox - **toggle\_2** : From my understanding, this will act the same as ‘ACTIVE’. Except Terry has another thing in mind. I’ve tried to tell you how @teryhill and me are thinking. @pri2si17 and @aethelwulffe any ideas? You will understand these better if see the interface I’ve made for the generator. ---
**Author:** ![pri2si17](https://forums.librehealth.io/user_avatar/forums.librehealth.io/pri2si17/32/1320_2.png) [@pri2si17](https://forums.librehealth.io/u/pri2si17)\ **Post date:** [May 17, 2018, 7:53pm UTC](https://forums.librehealth.io/t/project-report-generator-for-ehr/2327/7 "2018-05-17T19:53:37Z")
Hi @Trodrige, - > The reports have particular tables and columns from which they’re generated. What I think is majority of reports will use same column and fields with some modifications. Correct me if I’m wrong. Now come to implementation, what I think is separate your generator in two parts : - Playground : This is area where you will bring your draggable components and arrange to generate report. - Toolbox : This contains all your draggable components. First make a list of all common tools needed in report generation, and give them certain unique ids. There should be option for creating custom tools, and you will associate each custom tool generated with uuid. I don’t think this list is going to be long. Now from database perspective, I would suggest to use a new table, as you are not mingling with current code base and this is your separate module, so this should have its own database/tables. Now save data in table, for every value and link that with the user creating it, in another table. That’s how I think. Note : I am not able to run your code as my internet services are down and using mobile hotspot. I would like to have opinion of @teryhill @aethelwulffe @tony ---
**Author:** ![Trodrige](https://forums.librehealth.io/user_avatar/forums.librehealth.io/trodrige/32/447_2.png) [@Trodrige](https://forums.librehealth.io/u/Trodrige)\ **Post date:** [May 19, 2018, 6:48am UTC](https://forums.librehealth.io/t/project-report-generator-for-ehr/2327/8 "2018-05-19T06:48:01Z")
> [@pri2si17](#): > > First make a list of all common tools needed in report generation, and give them certain unique ids. @pri2si17 do you mean draggable components here? That is draggable components = common tools? If I get you clearly, you want that we use 2 databases, the main database you started already, and a report generator specific database. Note: - The list of draggable components will be stored in the list\_options table found in the main database. - The reports that are generated will get the data from the main database. This includes the user to whom a particular custom draggable component or report format is tied to. Of course, users exists in the main database. ---
**Author:** ![pri2si17](https://forums.librehealth.io/user_avatar/forums.librehealth.io/pri2si17/32/1320_2.png) [@pri2si17](https://forums.librehealth.io/u/pri2si17)\ **Post date:** [May 21, 2018, 3:23pm UTC](https://forums.librehealth.io/t/project-report-generator-for-ehr/2327/9 "2018-05-21T15:23:51Z")
> do you mean draggable components here? That is draggable components = common tools? Yes > If I get you clearly, you want that we use 2 databases, the main database you started already, and a report generator specific database. I would have to research about it, but I think it is a good practice to separate module wise database. Will let you know after some research. ---
**Author:** ![Trodrige](https://forums.librehealth.io/user_avatar/forums.librehealth.io/trodrige/32/447_2.png) [@Trodrige](https://forums.librehealth.io/u/Trodrige)\ **Post date:** [June 11, 2018, 9:14am UTC](https://forums.librehealth.io/t/project-report-generator-for-ehr/2327/10 "2018-06-11T09:14:14Z")
This is the link to my 3rd blog post: > **[3: GSoC18 at LibreHealth — Phase 1 of coding period!](https://medium.com/@tigrodrige/3-gsoc18-at-librehealth-phase-1-of-coding-period-4dfcb10728f5)** > > This article is the third, telling my story about GSoC 2018 experience. At the time of writing, we’re ending the 3rd week of coding. This… ---
**Author:** ![Trodrige](https://forums.librehealth.io/user_avatar/forums.librehealth.io/trodrige/32/447_2.png) [@Trodrige](https://forums.librehealth.io/u/Trodrige)\ **Post date:** [July 8, 2018, 7:59pm UTC](https://forums.librehealth.io/t/project-report-generator-for-ehr/2327/11 "2018-07-08T19:59:43Z")
Link to my 4th blog post: [https://medium.com/@tigrodrige/4-gsoc18-at-librehealth-report-generator-logic-f5aba3e6672](https://medium.com/@tigrodrige/4-gsoc18-at-librehealth-report-generator-logic-f5aba3e6672) ---
**Author:** ![Trodrige](https://forums.librehealth.io/user_avatar/forums.librehealth.io/trodrige/32/447_2.png) [@Trodrige](https://forums.librehealth.io/u/Trodrige)\ **Post date:** [July 23, 2018, 4:36pm UTC](https://forums.librehealth.io/t/project-report-generator-for-ehr/2327/12 "2018-07-23T16:36:46Z")
Link to my 5th post: [https://medium.com/@tigrodrige/5-gsoc18-at-librehealth-generators-report-formats-and-system-features-bc478884a4f5](https://medium.com/@tigrodrige/5-gsoc18-at-librehealth-generators-report-formats-and-system-features-bc478884a4f5) ---
**Author:** ![Trodrige](https://forums.librehealth.io/user_avatar/forums.librehealth.io/trodrige/32/447_2.png) [@Trodrige](https://forums.librehealth.io/u/Trodrige)\ **Post date:** [July 23, 2018, 9:24pm UTC](https://forums.librehealth.io/t/project-report-generator-for-ehr/2327/13 "2018-07-23T21:24:18Z")
I’m writing this to get ideas on how we can create and display clauses (WHERE clause especially) for the report generator. @teryhill gave some suggestions, which he can better explain. His was close to mine. It would be great if @pri2si17 and @aethelwulffe can chip in something here. My idea about the WHERE clause: - We create a table to store the possible variable we can think of. We’ll add more entries when the users start using the tool. Some of these variables could be patient\_name, appointment, provider, facility, age, gender, medical problems etc - On dragging components, we display a dropdown list of these WHERE and ORDERBY variables for the users to select after dragging and dropping components. For example, the user can select ‘patient name’ and enter the patient’s name. That is … WHERE patient\_name = ‘Mr. Nice’. - Each of these variables are tied to a particular table and column. When any is used, the value is used to filter the results of the dragged components that referenced the same table. For example, a user drags the **Patient\_Fullname** and **Facility\_Name** components. He further specifies the ‘provider\_name’ WHERE variable as provider\_name=Mr. Kanus. The query selects all patient fullnames where provider=Mr. Kanus, and joins it to their respective Facilities. I wish to have other views, and possible ideas you think we can go about this. I can elaborate on how I’m thinking if you don’t get the point. I also wish that @teryhill contributes his ideas here, so we can come up with the best solution here. Thanks. ---
**Author:** ![aethelwulffe](https://forums.librehealth.io/user_avatar/forums.librehealth.io/aethelwulffe/32/63_2.png) [@aethelwulffe](https://forums.librehealth.io/u/aethelwulffe)\ **Post date:** [July 24, 2018, 12:32am UTC](https://forums.librehealth.io/t/project-report-generator-for-ehr/2327/14 "2018-07-24T00:32:32Z")
This is going to be a bit of fun. 1. A local store and a remote store of these would be nice. 2. We should allow compound clause storage too, even if they are built up out of several clauses. Basically like burning a big logic circuit to a chip. I’ll try to do up a “builder” demo piece without reference to anything else, then look at what you guys are thinking. I have done stuff like this before, basically drag-and-drop coding with icons for brackets and icons for functions out of a standard library. I think that the key is to use the “visual code” approach. Basically that means that the user can think about object classes and other uninstanciated stuff, the user thinks about it at the instance level. Kind of like the user can create a class called “toy” (top level parent object), an extended version of that called “ball” (parent object), and a non-abstract version called “red\_ball”, but he is going to be thinking in terms of “red\_ball\_1”, “red\_ball\_2”, “green\_ball\_1” etc… so just draw the colored balls on the screen. [https://www.emojicode.org/](https://www.emojicode.org/) ---
**Author:** ![Trodrige](https://forums.librehealth.io/user_avatar/forums.librehealth.io/trodrige/32/447_2.png) [@Trodrige](https://forums.librehealth.io/u/Trodrige)\ **Post date:** [July 24, 2018, 8:46am UTC](https://forums.librehealth.io/t/project-report-generator-for-ehr/2327/15 "2018-07-24T08:46:11Z")
Hello @aethelwulffe, thanks for replying. I get the object and instance parts of what you said. What I don’t get is the local store, remote store, compound clause storage, and how we’ll use these (including the object-instance part) to provide users with the opportunity to specify WHERE clauses that we’ll use in querying our database. Also, how do we use [https://www.emojicode.org/](https://www.emojicode.org/) here? I’m sure @aethelwulffe has lots of cool, and fun stuff running in his mind. Thanks, Tigpezeghe. ---
**Author:** ![teryhill](https://forums.librehealth.io/user_avatar/forums.librehealth.io/teryhill/32/58_2.png) [@teryhill](https://forums.librehealth.io/u/teryhill)\ **Post date:** [July 28, 2018, 2:11pm UTC](https://forums.librehealth.io/t/project-report-generator-for-ehr/2327/16 "2018-07-28T14:11:33Z")
for right now we just need to keep it within the scope of the project. Store the items like you are doing for the fields in the drag and drop. setting the basic where clauses and letting the enduser add to them. ---
**Author:** ![Trodrige](https://forums.librehealth.io/user_avatar/forums.librehealth.io/trodrige/32/447_2.png) [@Trodrige](https://forums.librehealth.io/u/Trodrige)\ **Post date:** [July 28, 2018, 4:41pm UTC](https://forums.librehealth.io/t/project-report-generator-for-ehr/2327/17 "2018-07-28T16:41:51Z")
Ok @teryhill this is clearer now. So we need a database table to store these fields to be used in the where clauses. That’s clear. So the users can add fields to this table like the can add new system features. I get this, but how will they specify the table columns as most users don’t understand how the database looks like. ---
**Author:** ![pri2si17](https://forums.librehealth.io/user_avatar/forums.librehealth.io/pri2si17/32/1320_2.png) [@pri2si17](https://forums.librehealth.io/u/pri2si17)\ **Post date:** [July 28, 2018, 5:08pm UTC](https://forums.librehealth.io/t/project-report-generator-for-ehr/2327/18 "2018-07-28T17:08:21Z")
@Trodrige If I get you clear, then you probably want a way for end user to select what columns of lets say ‘X’ table they want in report. If wrong then correct me. I am providing suggestion using this assumption. You will need to use map data structure. For eg : In table X you have, three columns ‘pat\_name’, ‘pat\_id’ and ‘pat\_addr’. On UI you should display columns as (Checkbox) [1] Patient Name [2] Patient ID and [3]Patient Address. and in program/code you should implement this as map like : `$table_column_map = array("pat_name" => "Patient Name")` or `$table_column_map = {}` `$table_column_map['pat_name'] = "Patient Name"` This way, whatever user will select, that can be sent as POST request, and internally you can use your code display result according to corresponding table columns. Hope I 'm clear. If my assumption is wrong, or anything you haven’t got, please let me know. ---
**Author:** ![Trodrige](https://forums.librehealth.io/user_avatar/forums.librehealth.io/trodrige/32/447_2.png) [@Trodrige](https://forums.librehealth.io/u/Trodrige)\ **Post date:** [July 28, 2018, 5:56pm UTC](https://forums.librehealth.io/t/project-report-generator-for-ehr/2327/19 "2018-07-28T17:56:28Z")
@pri2si17 we’ve passed this stage of the report generator. What I mean is providing an opportunity for a user to provide a where clause from the report main page. This will be used to reduce the number of entries for the generated report. However, this is similar to what Terry was describing, mapping possible fields that can be used in the where clause to the actual fields in the database. This is the same way we did for draggable components. ---
**Author:** ![pri2si17](https://forums.librehealth.io/user_avatar/forums.librehealth.io/pri2si17/32/1320_2.png) [@pri2si17](https://forums.librehealth.io/u/pri2si17)\ **Post date:** [July 28, 2018, 6:10pm UTC](https://forums.librehealth.io/t/project-report-generator-for-ehr/2327/20 "2018-07-28T18:10:28Z")
I think this will cover it also. In either case you need to do mapping. @Trodrige [Next page](https://forums.librehealth.io/t/project-report-generator-for-ehr/2327.md?page=2)