Diagnosis code in the same window with other fields

system · December 30, 2013, 12:51pm

cyprol wrote on Monday, December 30, 2013:

Hello,

I want to customize the openemr in a way that the diagnosis code will fit into one windows with the other fields when adding a medical problem.I found that the source code in …/interface/patient_file/summary/add_edit_issue.php calls a function sel_diagnosis() and it popups the new window.Then,I found the source code of interface/patient_file/encounter/find_code_popup.php and because I am new to openemr and php, I want to help me and tell me which is the main function that calls from sql and gets the results to show them when you hit “search” button?

Thank you!

system · December 30, 2013, 2:05pm

mdsupport wrote on Monday, December 30, 2013:

We made code box a Select2 dropdown. As users type key words, the dropdown shows 20 matches dynamically. 1 more line also converts the title box that now offers top 20 problem descriptions matching partial User input.

system · December 30, 2013, 2:13pm

cyprol wrote on Monday, December 30, 2013:

Where can I find the source code for this function? I have version 4.1.1 openemr and I can’t find this.

system · December 30, 2013, 4:06pm

mdsupport wrote on Monday, December 30, 2013:

We had submitted some code to the project as part of larger design change we went through. This thread identifies some of the places you can look for ‘standard’ code. We did not find any of those approaches reusable.

system · December 31, 2013, 8:14am

bradymiller wrote on Tuesday, December 31, 2013:

Hi Phil,

Function is main_code_set_search() in the script you pointed to above that can be found in custom/code_types.inc.php library. Note that function can deal with any code set/type and can even do a search across multiple different code types/sets(see Administration->Codes which can search across multiple code sets/types via the multiselect). Check out Kevin’s code in the Fee Sheet which uses that same function to do a dynamic search via his diagnosis_search() wrapper:
interface/forms/fee_sheet/review/fee_sheet_search_queries.php
interface/forms/fee_sheet/review/fee_sheet_search_ajax.php

-brady
OpenEMR

system · December 31, 2013, 12:18pm

cyprol wrote on Tuesday, December 31, 2013:

Thank you for your answers.I have a question,how can I get the description of the diagnosis in the search box so when I start typing some words,the most suitable descriptions will appear, and then I will select the one I want? I know about jquery autocomplete and I would like to import it in the away I just wrote,so I will remove the extra window that appears when the diagnosis code field is tapped.Should I choose simple jquery autocomplete or select2 as MD Support mentioned above? Thank you!

system · December 31, 2013, 6:57pm

mdsupport wrote on Tuesday, December 31, 2013:

Whatever approach you choose, you need to handle multiple code selections from different descriptions. Another user experience improvement you may want to consider:
a. Selectively delete a code
b. reorder existing selections.

system · January 2, 2014, 2:10pm

cyprol wrote on Thursday, January 02, 2014:

I know I must consider these also. I have another question as I am new to this project,is there any table that has all the words or keywords of all the diseases so I can use it for autocomplete instead of showing the whole description? My idea is to start typing and then to show you some recommendations of what disease you look for.If there is a that has all the keywords would help a lot. Thank you!

system · January 2, 2014, 2:22pm

cmswest wrote on Thursday, January 02, 2014:

there’s the short description field in the table icd9_dx_code

system · January 2, 2014, 2:45pm

yehster wrote on Thursday, January 02, 2014:

No, there is no table that breakdowns the descriptions by keyword.

However, if you use the existing code search routines, it effectively treats search terms separated by spaces as keywords. It’s table scanning, but performance seems to be adequate given the size of the data set.

system · January 2, 2014, 6:20pm

cyprol wrote on Thursday, January 02, 2014:

Could you provide the link of the folder that I will call for the short description from icd9_dx_code table?

system · January 2, 2014, 6:37pm

cmswest wrote on Thursday, January 02, 2014:

it’s just a field in the mysql table but i’ve attached a zipped up file

i think Kevin’s solution is preferrable

system · January 5, 2014, 12:24pm

cyprol wrote on Sunday, January 05, 2014:

Ok thank you,I will try it later. Now,I try to fit the diagnosis popup window into the add issue window.As a result, some fields that should not be appeared they appear in this window. I attached the photo of the original window and the modified one.Why is that happening? How can I fix the problem? I also attach the source code of add_issue.php so you can see I didn’t change anything but only added code. Another problem is that, after I press the “search” button,the title’s text box is going blank and the title I enter before pressing the button is disappeared.How can I keep the text of title in the text box after pressing the search button? Thank you.

system · January 5, 2014, 2:29pm

cyprol wrote on Sunday, January 05, 2014:

I solved the problem with the extra fields that appeared, now remains the problem with the title as I mentioned before.Any help will be appreciated.

system · January 8, 2014, 10:12am

cyprol wrote on Wednesday, January 08, 2014:

As for the autocomplete,I try to use jquery autocomplete (http://jqueryui.com/autocomplete/) with remote datasource. However,I can’t understand how can I create the search.php at line that says source: search.php.
Is there any way for getting the database values of descriptions? I looked at fee sheet autocomplete and it’s the perfect example for me.Can you explain me please,Kevin, how the files are connected and how is working the autocomplete? Thank you!

system · January 8, 2014, 10:21am

yehster wrote on Wednesday, January 08, 2014:

I use knockoutjs to handle the UI for autocomplete in the fee sheet.
This is the event handler code that triggers a request from the browser

github.com

openemr/openemr/blob/master/interface/forms/fee_sheet/review/fee_sheet_justify_view_model.js#L101


    parent.diagnosis_options.push(new_justify);
    parent.added_keys[code_key]=new_justify;
    update_diagnosis_options(parent.diagnosis_options,new_justify);
    parent.search_has_focus(false);
    parent.diagnosis_options.sort(priority_order);
}
parent.search_query("");
return true;
}


function search_change(data,model)
{
var search_query=data;
model.search_show(true);
var search_type= model.searchType().key;
var search_type_id=model.searchType().id;
if(search_query.length>0)
    {
        $.post(ajax_fee_sheet_search,
                {
                    search_query:search_query,

and this is the ajax page:

github.com

openemr/openemr/blob/master/interface/forms/fee_sheet/review/fee_sheet_search_ajax.php

<?php
/**
 * Controller for AJAX requests to search for codes from the fee sheet
 *
 * Copyright (C) 2013 Kevin Yeh <kevin.y@integralemr.com> and OEMR <www.oemr.org>
 *
 * LICENSE: This program is free software; you can redistribute it and/or
 * modify it under the terms of the GNU General Public License
 * as published by the Free Software Foundation; either version 3
 * of the License, or (at your option) any later version.
 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
 * GNU General Public License for more details.
 * You should have received a copy of the GNU General Public License
 * along with this program. If not, see <http://opensource.org/licenses/gpl-license.php>;.
 *
 * @package OpenEMR
 * @author  Kevin Yeh <kevin.y@integralemr.com>
 * @link    http://www.open-emr.org

This file has been truncated. show original

that processes the request and returns matching codes and descriptions.

system · January 8, 2014, 10:37am

yehster wrote on Wednesday, January 08, 2014:

github.com

openemr/openemr/blob/master/interface/forms/fee_sheet/review/fee_sheet_search_queries.php

<?php
/**
 * Functions to help search for codes on the fee sheet
 *
 * Copyright (C) 2013 Kevin Yeh <kevin.y@integralemr.com> and OEMR <www.oemr.org>
 *
 * LICENSE: This program is free software; you can redistribute it and/or
 * modify it under the terms of the GNU General Public License
 * as published by the Free Software Foundation; either version 3
 * of the License, or (at your option) any later version.
 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
 * GNU General Public License for more details.
 * You should have received a copy of the GNU General Public License
 * along with this program. If not, see <http://opensource.org/licenses/gpl-license.php>;.
 *
 * @package OpenEMR
 * @author  Kevin Yeh <kevin.y@integralemr.com>
 * @link    http://www.open-emr.org

This file has been truncated. show original

This is the code where the records are retrieved from the database itself (called from the ajax wrapper.)

system · January 9, 2014, 1:21pm

cyprol wrote on Thursday, January 09, 2014:

Thank you Kevin for your explanation.I have a question,the source code for the small window that does the autocomplete where actually is it? I attached the small window I talk about. I am confused because I tried to create a similar approach with the diagnosis code but failed.I also tried jquery with json without the UI of knockoutjs but not working…I would really appreciate if you can guide me with any of 2 ways for autocomplete,with yours Kevin if I can use it without knockoutjs or with jquery simple autocomplete.Thank you.

system · January 9, 2014, 1:45pm

yehster wrote on Thursday, January 09, 2014:

This is the view template which renders the html for that window.
Binding to the keydown event is what triggers the lookup

github.com

openemr/openemr/blob/master/interface/forms/fee_sheet/review/views/justify_display.php#L36


    <div data-bind="event:{click: toggle_warning_details}" class="problem_warning" title="<?php echo xla('Click for more details') ?>"><?php echo xlt("Warning, patient has ambiguous codes in the problems list!") ?></div>
    <div class="warning_details" data-bind="visible: show_warning_details">
        <?php echo xlt("The following problems have the same diagnosis codes. Encounter issues will not be updated. Please use the encounter interface instead.") ?>
        <span data-bind="foreach: $data.duplicates">
            <div data-bind="text: description() +':'+ code_type() + '|' + code()"></div>
        </span>
    </div>
</div>
<span>
    <span data-bind="visible: diag_code_types.length>0">
        <input value= type="text" data-bind="value: search_query, valueUpdate: 'afterkeydown', event:{focus:search_focus, blur: search_blur, keydown:search_key}, hasfocus: search_has_focus"/>
        <span class="search_results" data-bind="visible: (search_results().length>0) && search_show">
            <table>
                <tbody data-bind="foreach: $data.search_results">
                    <tr>
                        <td class="search_result_code" data-bind="text:description, event:{click: function(data,event){return choose_search_diag(data,event,$parent)}}"></td>
                        <td data-bind="text:code, attr:{title:code_type}"></td>
                    </tr>
                </tbody>
            </table>
        </span>

My approach fundamentally depends on using knockout, between triggering the lookup, rendering the options, and what happens when you choose a diagnosis code. Everything is driven by knockout’s mvvm framework. It is inseparable.

I have never used jquery autocomplete so I can’t help you there.

system · January 9, 2014, 3:59pm

cyprol wrote on Thursday, January 09, 2014:

Ok but I saw that in fee_sheet_search_queries.php you implement the function diagnosis_search and you return an array.Then, in fee_sheet_search_ajax.php why you put that array in $retval[‘codes’]? What is that mean? A whole array returns to a row? The variable has the same name “retval” in both files and I think is global.I need some explanation on this as I can’t understand how that part works.