German Medical Exams

allow for AND or OR operator within multiselect fields

Stewart — Thu, 24 Jun 2010 16:55:37 +0000

Based on work documented in previous post, I then decided to allow the user to configure whether multiple selections made within one multiselect field should be related to each other by OR or AND, for example to allow
remedy = bloodletting AND purge
as well as
remedy = bloodletting OR purge
The operator within each field works independently of the control for the existing operator between fields, so any of these queries is now doable:
(examiner = smith) OR (remedy = bloodletting OR purge)
(examiner = smith) AND (remedy = bloodletting OR purge)
(examiner = smith) OR (remedy = bloodletting AND purge)
(examiner = smith) AND (remedy = bloodletting AND purge)

I had to extend the code modifications described before, and add a pair of radio buttons to the interface of the popup window to allow the user to specify. Entailed changes to a javascript file, lib.php and libsql.php, search.php and datalist.php by the time all was done.

Original post blogged on b2evolution.

query fails when more than one item selected in multiselect fields

Stewart — Thu, 24 Jun 2010 16:46:58 +0000

MLH told me that if he did queries involving more than one choice in a multiselect field, the results coming back were wrong. For example,
If I search for remedy = bloodletting, I get 23 results
If I search for remedy = purge, I get 52 results
Before, when I searched for remedy = bloodletting OR purge I got 0 hits.

Problem was with code that generates the where clause in the SQL query, in particular where that code has to search 2 fields. It was generating a clause like this:
((remedy1 = "bloodletting OR purge") OR (remedy2 = "bloodletting OR purge"))
and so I corrected it to create a clause like this:
(((remedy1 = "bloodletting") OR (remedy1 = "purge")) OR ((remedy2 = "bloodletting") OR (remedy2 = "purge")))

Now, when I search for remedy = bloodletting OR purge, I get 58 hits.

Original post blogged on b2evolution.

add filter for Has Nurse or Support Care

Stewart — Tue, 20 Apr 2010 19:30:20 +0000

ML asked to be able to filter search results based on whether either of two boolean values in a record were true. Took a couple of tries to figure out how checkboxes behave with regard to the POST array, but I finally figured it out with help from Greg and Martin 1) To report the status of a checkbox in the POST array and use that in PHP to set the state when the page reloads itself. If the checkbox is not checked, then no value is sent in the POST array, so the PHP that checks has to check not the value, but if isset($_POST[checkbox_element_id]). If that returns true, then write 'checked="checked"' into the page and if it returns false, then write nothing. If the PHP writes 'checked=""' or includes the checked attribute at all, then the checkbox is checked. In search.php: $is_nurse_or_support_care_checked = ''; if (isset($_POST['is_nurse_or_support_care_checked'])) { $is_nurse_or_support_care_checked = "yes"; } In includes/searchformbasic.inc: <label for="is_nurse_or_support_care_checked">Has Nurse or Support Care</label> <input name="is_nurse_or_support_care_checked" type="checkbox" id="is_nurse_or_support_care_checked" <?php if ($is_nurse_or_support_care_checked == 'yes') {echo ' checked="checked"'; } ?> value="checked" ></input> To modify the where clause to include only those records in which either of the two affected fields have the value 1 (as opposed to the only other possible value, which is 0) in search.php: if (!empty($is_nurse_or_support_care_checked)) { if (!empty($where)) {$where .= " " . $combine_fields_using_value . " ";} $where .= "("; $where .= "(exams.food_rest = '1') "; $where .= "OR (exams.nursing_care = '1') "; $where .= ")"; }

Original post blogged on b2evolution.

add another search, one still to go

Stewart — Mon, 08 Mar 2010 21:56:40 +0000

Added a text search on the "Miscellaneous" textbox? Started work on this request, but it will take some more doing: Search those entries which get a * for either nursing or support care under the search display of Remedies. Add that search under "Residential Care" in the Examination search box (just a menu with "yes/checked" and "no").

Original post blogged on b2evolution.

update order-by control

Stewart — Wed, 16 Dec 2009 18:32:02 +0000

Noticed that the values in the order-by control were based on the original fields in the line that's always visible for each record. Updated that to reconcile with current fields in that line. Had to update the order-by table in the db and update the switch($order_by_1_text) statement in search.php.

Original post blogged on b2evolution.

Add search of treatments textarea

Stewart — Wed, 16 Dec 2009 18:29:10 +0000

MH asked to be able to query large blocks of text in the treatments field, similar to what I gave him for the conditions, namely: "Treatment any word begins with" "Treatment contains" "Treatment also contains" "Treatment does not contain" My first implementation had a bug resulting from a copy-and-paste error.

Original post blogged on b2evolution.

Add search of conditions textarea, new report presentation to follow

Stewart — Sat, 28 Nov 2009 00:38:31 +0000

MH asked to be able to query large blocks of text in the condition field. I gave him controls so that he could try:

"Condition begins with"
"Condition any word begins with"
"Condition contains"
"Condition also contains"
"Condition does not contain"

For now, the query just returns the same results as all the other types of query. Once he's settled on the type of query interface he wants, I'll likely implement it on a separate page and have a different presentation of the report.

Original post blogged on b2evolution.

change which fields appear in report

Stewart — Sat, 28 Nov 2009 00:35:32 +0000

substituted the "Approved Measure" field in place of the Document ID (and omitted the Document ID out--MH doesn't want it there

In the initial search display, moved the results for "Bathing and "Res. Care" that are now in the Exam detail and put them in the initial display of search results

Original post blogged on b2evolution.