librehealthio / lh-ehr Goto Github PK
View Code? Open in Web Editor NEWLibreHealth EHR - Free Open Source Electronic Health Records
License: Other
LibreHealth EHR - Free Open Source Electronic Health Records
License: Other
tested links in patient summary screen, issue_55_zerodates branch; ran through the menu formerly known as 'Left Nav Menu' and opened every item.
Did not enter data to see how it was handled, just looked to see if the panel/ module opened without errors.
I'm only mentioning the modules that showed an err msg or did not open with their normal appearance.
details further below but the error messages I saw are:
. adding new pt encounter with both the main menu 'create visit' item and the encounter list in patient record header. Can open a new encounter panel but hit 'save amd get:
ERROR: insert failed: INSERT INTO form_encounter SET date = '2016-08-15', onset_date = '', reason = 'testy2', facility = 'Your Clinic Name Here', pc_catid = '10', facility_id = '3', billing_facility = '3', sensitivity = 'normal', referral_source = '', pid = '15168', encounter = '3', provider_id = '1'
Error: Incorrect datetime value: '' for column 'onset_date' at row 1
/opt/www/vhosts/gponline-emr.vu2vu.com/emr_gponline_dev/libreehr/interface/forms/newpatient/save.php at 72:sqlInsert
. In a new encounter panel before trying to to save it, add a new problem issue.
*** In all these issues and problem adding errors they appear when 'save' is clicked in the add problem details popup (pic)
ERROR: insert failed: INSERT INTO form_encounter SET date = '2016-08-15', onset_date = '', reason = 'test ecounter', facility = 'Your Clinic Name Here', pc_catid = '10', facility_id = '3', billing_facility = '3', sensitivity = 'normal', referral_source = '', pid = '15168', encounter = '2', provider_id = '1'
Error: Incorrect datetime value: '' for column 'onset_date' at row 1
/opt/www/vhosts/gponline-emr.vu2vu.com/emr_gponline_dev/libreehr/interface/forms/newpatient/save.php at 72:sqlInsert
new allergy issue
ERROR: insert failed: INSERT INTO lists ( date, pid, type, title, activity, comments, begdate, enddate, returndate, diagnosis, occurrence, classification, referredby, user, groupname, outcome, destination, reinjury_id, injury_grade, injury_part, injury_type, reaction, severity_al ) VALUES ( NOW(), '15168', 'allergy', 'codeine', 1, '', NULL, NULL, NULL, '', '0', '0', '', '', '', '0', '', '', '', '', '', 'unassigned', 'unassigned' )
Error: Incorrect integer value: '' for column 'reinjury_id' at row 1
/opt/www/vhosts/gponline-emr.vu2vu.com/emr_gponline_dev/libreehr/interface/patient_file/summary/add_edit_issue.php at 325:sqlInsert
attempting to open the history link on pt record screen.
ERROR: insert failed: insert into history_data set pid = ?, date = NOW()
Error: Field 'exams' doesn't have a default value
/opt/www/vhosts/gponline-emr.vu2vu.com/emr_gponline_dev/libreehr/library/patient.inc at 1297:sqlInsert
/opt/www/vhosts/gponline-emr.vu2vu.com/emr_gponline_dev/libreehr/interface/patient_file/history/history.php at 55:newHistoryData(15168)
at bottom of patient record, clicked on Amendments's Edit
ERROR: query failed: SELECT * FROM amendments WHERE pid = ? ORDER BY amendment_date DESC
Error: Table 'libreehr_socrates.amendments' doesn't exist
/opt/www/vhosts/gponline-emr.vu2vu.com/emr_gponline_dev/libreehr/interface/patient_file/summary/demographics.php at 1027:sqlStatement
running through the menu formerly known as 'left nav':
patient/ client works.
fees- payment and checkout displayed ok
- billing showed normal upper panel; threw this in lower panel of the display:
selected several search criteria then updated list -> no change in lower panel.
ERROR: query failed: select distinct billing.id, form_encounter.date, billing.pid, billing.code_type, billing.code, billing.user from form_encounter, billing, patient_data, claims, insurance_data where billing.encounter = form_encounter.encounter and billing.pid = form_encounter.pid and patient_data.pid = form_encounter.pid and claims.patient_id = form_encounter.pid and claims.encounter_id = form_encounter.encounter and insurance_data.pid = form_encounter.pid and insurance_data.type = 'primary' AND (billing.billed is null or billing.billed = '0' or (billing.billed = '1' and billing.bill_process = '3')) AND (form_encounter.date between '2016-08-16 00:00:00' and '2016-08-16 23:59:59') and billing.code_type like ? and billing.activity = 1 order by billing.pid, billing.date ASC
Error: Expression #2 of ORDER BY clause is not in SELECT list, references column 'libreehr_socrates.billing.date' which is not in SELECT list; this is incompatible with DISTINCT
/opt/www/vhosts/gponline-emr.vu2vu.com/emr_gponline_dev/libreehr/library/billrep.inc at 178:sqlStatement
/opt/www/vhosts/gponline-emr.vu2vu.com/emr_gponline_dev/libreehr/interface/billing/billing_report.php at 627:getBillsListBetween(%)
fees/ posting -> blank panel below the line of tabs and screen header
fees/ batch payments -> looks normal
fees/ edi history -> looks normal
modules/ manage modules -> blank panel below the line of tabs and screen header
procedures / providers:
ERROR: query failed: SELECT pp.* FROM procedure_providers AS pp ORDER BY pp.name
Error: Table 'libreehr_socrates.procedure_providers' doesn't exist
/opt/www/vhosts/gponline-emr.vu2vu.com/emr_gponline_dev/libreehr/interface/orders/procedure_provider_list.php at 37:sqlStatement
procedures/ configuration looks normal
procedures/ load compendium:
ERROR: query failed: SELECT pp.* FROM procedure_providers AS pp ORDER BY pp.name
Error: Table 'libreehr_socrates.procedure_providers' doesn't exist
/opt/www/vhosts/gponline-emr.vu2vu.com/emr_gponline_dev/libreehr/interface/orders/procedure_provider_list.php at 37:sqlStatement
procedures/ pending review and patient results
ERROR: query failed: SELECT po.procedure_order_id, po.date_ordered, pc.procedure_order_seq, pt1.procedure_type_id AS order_type_id, pc.procedure_name, pr.procedure_report_id, pr.date_report, pr.date_collected, pr.specimen_num, pr.report_status, pr.review_status FROM procedure_order AS po JOIN procedure_order_code AS pc ON pc.procedure_order_id = po.procedure_order_id LEFT JOIN procedure_type AS pt1 ON pt1.lab_id = po.lab_id AND pt1.procedure_code = pc.procedure_code LEFT JOIN procedure_report AS pr ON pr.procedure_order_id = po.procedure_order_id AND pr.procedure_order_seq = pc.procedure_order_seq WHERE po.patient_id = '15168' AND 1 = 1 ORDER BY po.date_ordered, po.procedure_order_id, pc.procedure_order_seq, pr.procedure_report_id
Error: Table 'libreehr_socrates.procedure_order' doesn't exist
/opt/www/vhosts/gponline-emr.vu2vu.com/emr_gponline_dev/libreehr/interface/orders/orders_results.php at 419:sqlStatement
procedures/ lab overview
ERROR: query failed: SELECT DISTINCT procedure_result.result_code AS value_code FROM procedure_result JOIN procedure_report ON procedure_result.procedure_report_id = procedure_report.procedure_report_id JOIN procedure_order ON procedure_report.procedure_order_id = procedure_order.procedure_order_id WHERE procedure_order.patient_id = ? AND procedure_result.result IS NOT NULL AND procedure_result.result != ''ORDER BY procedure_result.result_code ASC
Error: Table 'libreehr_socrates.procedure_result' doesn't exist
/opt/www/vhosts/gponline-emr.vu2vu.com/emr_gponline_dev/libreehr/interface/patient_file/summary/labdata.php at 158:sqlStatement
procedures/ batch results: opened looking normal
procedures/ electronic reports:
ERROR: query failed: SELECT * FROM procedure_providers ORDER BY name
Error: Table 'libreehr_socrates.procedure_providers' doesn't exist
/opt/www/vhosts/gponline-emr.vu2vu.com/emr_gponline_dev/libreehr/interface/orders/receive_hl7_results.inc.php at 1026:sqlStatement
/opt/www/vhosts/gponline-emr.vu2vu.com/emr_gponline_dev/libreehr/interface/orders/list_reports.php at 184:poll_hl7_results(Array)
We need a demo install running somewhere, even if the code is broken for the most part. I would like a news feed on the demo login page announcing recent features and advancements.
List of irritations, minor bugs, and personal peeves:
Unresolved merge conflicts in the latest commit ..
on or about line 261
'online_support_link' => array(
xl('Online Support Link'),
'text', // data type
<<<<<<< HEAD
'http://libreehr.github.io',
refs/remotes/origin/master
xl('URL for LibreEHR support.')
Remove embedded PhpMyAdmin
https://forums.librehealth.io/c/7-support
And make sure you set your preference to watch that category ...
adding new pt encounter with both the main menu 'create visit' item and the encounter list in patient record header. Can open a new encounter panel but hit 'save amd get:
ERROR: insert failed: INSERT INTO form_encounter SET date = '2016-08-15', onset_date = '', reason = 'testy2', facility = 'Your Clinic Name Here', pc_catid = '10', facility_id = '3', billing_facility = '3', sensitivity = 'normal', referral_source = '', pid = '15168', encounter = '3', provider_id = '1'
Error: Incorrect datetime value: '' for column 'onset_date' at row 1
/opt/www/vhosts/gponline-emr.vu2vu.com/emr_gponline_dev/libreehr/interface/forms/newpatient/save.php at 72:sqlInsert
the class descriptions for example menu are listed in all CSS style sheet but never used in any code, anywhere. This is minor clean-up stuff for down the road. CSS needs general cleaning ... maybe the bootstrap stuff will come along some day/
.example_menu ul ul {
display: block;
}
.example_menu a {
color: #000;
cursor: pointer;
display: block;
font-weight: bold;
margin-left: 0;
padding: 2px 2px 2px 17px;
width: 160px;
}
.example_menu a.expanded {
background: #bbb url('collapse.gif') no-repeat 3px 50%;
}
.example_menu a.collapsed {
background: #bbb url('expand.gif') no-repeat 3px 50%;
}
.example_menu a:hover {
text-decoration: none;
}
.example_menu ul li span {
background: #d9d1a4;
color: #000;
display: block;
font-weight: normal;
width:100%;
}
.example_menu ul a:Subjective {
font-weight: normal;
}
.example_menu ul a:hover {
background : #f5f5f5;
text-decoration: underline;
}
.example_menu li.active a {
background: #fff;
}
.example_menu li.active li a {
background: #e8e8e8;
}
Review and integrate update (in progress) to Dates functions.
This is work that is already nearly completed on MI2 private repos and will be pushed to this one for team review.
The JSON menu data is not correctly handled to run external URL. I had fixed the LeftNav menu, but I missed the menu_data.php and menu_data.sql files.
Might need to understand how the URLS are used better so that can be fixed @yehster ?
Replace ZHH feature with internal one or Immunization and Public Health Registries.
MI2 has a Immunization connection to CAIR (California).
Please use the below as a working discussion document. Edit as desired.
Documentation FORMAT:
HTML5 in in a repository with all materials linked (Watch video, download topic document), with the documentation web-site set to update from the repository. All items presented as a walk-through, but available with topic specific documentation. All terms in the material should be linked to the primary topic or a definition.
TOPIC groups:
Laravel has a process called 'artisan migrate' - https://laravel.com/docs/5.2/migrations
Not sure if we can use it directly, but we should use this model for data setup and database upgrades.
XAMPP?
Debian?
Virtual Machine?
MSI Installer?
Ubuntu Software Center?
include_once(dirname(FILE) . "/../../includes/config.php");
This contains:
This is stupid. Either we use this directory or get rid of it. Which one? Please Vote.
I have made a couple of pull requests dealing with /sql and the upgrade scripts.
I changed the version to 1.0.0, db=1, and made an sql upgrade file called 0.0.1_to_1.0.0 that includes most of the good stuff from the last two upgrade scripts. I have left out the species and theology bits, and dumped the county list for some random counties in an unknown state (which broke custom lists all over the place), and tossed a lot of other things like clickoptions conversions, old default data, and some odd scripts that allowed the creation of some users named "Barry" and others.
So: What is the next step in making a fresh new upgrade system?
Github issues are visible to anyone, but only github users can add new issues. We will need a way for basic users to request help, ask questions etc.
Time to talk about the next milestone and what it should have:
This was sent to me from Jerry who is working on secure messaging for portal
"there is also a bug in pnote.inc in the getPatientNotes and getPatientSentNotes query where ON pd.id = p.pid should be ON pd.pid = p.pid. How this has not been noticed till now shows either zh fixed in their stuff and did not update code base or they don't use their off site portal..."
This issue addresses general conversation, assignment of issues, and other communications related to the milestone that are not directly applicable to a single issue.
[Wed Aug 03 23:22:09.548820 2016] [:error] [pid 24054] [client 50.43.80.9:53045] PHP Fatal error: 'break' not in the 'loop' or 'switch' context in ... /libreehr/library/sql_upgrade_fx.php on line 337
Completely re-style the LibreEHR login page, probably removing the top bar, giving it a much-needed makeover that looks completely different.
Apparent SYNTAX error in globals.inc.php
PHP Parse error: syntax error, unexpected ';', expecting ')' in /opt/www/vhosts/gponline-emr.vu2vu.com/emr_gponline_dev/libreehr/library/globals.inc.php on line 2673, referer: https://gponline-emr.vu2vu.com/libreehr/setup.php?site=default
you would email us at [email protected] if you have installed this software
Do we have a email or should we just change/drop this whole sentence and refer them to the website and github accounts?
new allergy issue
ERROR: insert failed: INSERT INTO lists ( date, pid, type, title, activity, comments, begdate, enddate, returndate, diagnosis, occurrence, classification, referredby, user, groupname, outcome, destination, reinjury_id, injury_grade, injury_part, injury_type, reaction, severity_al ) VALUES ( NOW(), '15168', 'allergy', 'codeine', 1, '', NULL, NULL, NULL, '', '0', '0', '', '', '', '0', '', '', '', '', '', 'unassigned', 'unassigned' )
Error: Incorrect integer value: '' for column 'reinjury_id' at row 1
/opt/www/vhosts/gponline-emr.vu2vu.com/emr_gponline_dev/libreehr/interface/patient_file/summary/add_edit_issue.php at 325:sqlInsert
Review and Cherry-Pick elements of @openemr that pass muster with the team for inclusion in the 1.0 release
Update styling ot "Industry Standard" look and feel on the main components.
Frames, Menus a priority
Currently uses interface to NewCrop. this interface could be greatly improved and they also support some of the other features for MU2 through their portal.
This was offered on OpenEMR.. another good thing to clean out
remove adLDAP from library
D library/adldap/README.txt (9)
D library/adldap/adLDAP.php (725)
D library/adldap/adLDAP_auth.inc (261)
D library/adldap/adLDAP_conf.inc (24)
D library/adldap/adLDAP_sync.php (182)
D library/adldap/adLDAP_sync.sh (9)
when adding add a new problem issue.
*** In all these issues and problem adding errors they appear when 'save' is clicked in the add problem details popup
ERROR: insert failed: INSERT INTO form_encounter SET date = '2016-08-15', onset_date = '', reason = 'test ecounter', facility = 'Your Clinic Name Here', pc_catid = '10', facility_id = '3', billing_facility = '3', sensitivity = 'normal', referral_source = '', pid = '15168', encounter = '2', provider_id = '1'
Error: Incorrect datetime value: '' for column 'onset_date' at row 1
/opt/www/vhosts/gponline-emr.vu2vu.com/emr_gponline_dev/libreehr/interface/forms/newpatient/save.php at 72:sqlInsert
Could put a general acknowledgment to the OpenEMR Community with our Thanks ... and leave it at that, tracking only the new contribs to the new project
attempting to open the history link on pt record screen.
ERROR: insert failed: insert into history_data set pid = ?, date = NOW()
Error: Field 'exams' doesn't have a default value
/opt/www/vhosts/gponline-emr.vu2vu.com/emr_gponline_dev/libreehr/library/patient.inc at 1297:sqlInsert
/opt/www/vhosts/gponline-emr.vu2vu.com/emr_gponline_dev/libreehr/interface/patient_file/history/history.php at 55:newHistoryData(15168)
1990 called, and they want their progress notes back.
Replace ZHH features (Portal). Enhance current portal to meet measure or other method.
Documentation for PHPmyAdmin install references Old software not LibreEHR
add ability to register users for LibreEHR. This will allow security updates notices to be sent. Will also allow a marketing hook. Add the ability for registration to the about page and globals.
Construct more configuration tools for menus, making decisions about the JSON vs. DB approaches for the frameless configuration.
Replace ZHH feature with one that's part of the core.
On any attempted search I get this error: Notice Nothing between WHERE and ORDER
ERROR: query failed: SELECT *, DATE_FORMAT(DOB,'%m/%d/%Y') as DOB_TS FROM patient_data WHERE ORDER BY lname ASC, fname ASC LIMIT 0, 100
Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY lname ASC, fname ASC LIMIT 0, 100' at line 1
process_bill.log location needs to move to the sites/*/edi directory or similar
The are the reference currently
sites/default/config.php
3:$GLOBALS['oer_config']['freeb']['claim_file_dir'] = "/usr/share/freeb/public/";
10:// This does not seem useful for PDF HCFAs, see freeb/targetbin/ascii2pdf instead:
interface/billing/freebtest.php
8:$command = "perl /usr/share/freeb/formatbin/" . $format . ".pl";
interface/patient_file/pos_checkout.php
62:require_once("$srcdir/freeb/xmlrpc.inc");
63:require_once("$srcdir/freeb/xmlrpcs.inc");
library/classes/WSWrapper.class.php
2:require_once(dirname(__FILE__) . "/../freeb/xmlrpc.inc");
3:require_once(dirname(__FILE__) . "/../freeb/xmlrpcs.inc");
library/edihistory/csv_record_include.php
1099: // LibreEHR open log link: <a href='../../library/freeb/process_bills.log' target='_blank' class='link_submit' title=''>[View Log]</a>
@teryhill Would you consider reviewing the starting code for diffs against your favorite billing features? I would also like to get in a number of items dealing with claim generation, as well as removing ICD9 hard-coding that messes with manually entered dx. I would like to put together a definition of a second milestone that moves us toward a billing re-write...and allows me to scope a funding request. We need a fundamental advance in billing logic.
Remove the framework and document how to install it externally for use for now.
Consider removing the entire "Zend Modules" model in favor of @kchapple module hooks model.
The active check boxes in lists are not defaulted they are left unchecked and it is another item to check seeing that the list will not function without it being checked.
Should the whole active check box be scrapped?
If you have a Tab locked in position 1, like calendar. Other tabs open in split screen next to the locked tabs. However, patient->patients and flowboard both step on the locked tab in position 1.
No indication of errors in the apache logs ... but ..
MySQL said: Documentation
#1067 - Invalid default value for 'pc_eventDate'
pc_eventDate
date NOT NULL default '0000-00-00',
pc_endDate
date NOT NULL default '0000-00-00',
I don't think all zeros is allowed any more ...
mysql Ver 14.14 Distrib 5.7.13, for Linux (x86_64)
A document needs to be written for the menu tool.
We have lots of messy stuff in the application root directory. I would like to see that, as a start, get moved somewhere appropriate.
A declarative, efficient, and flexible JavaScript library for building user interfaces.
๐ Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. ๐๐๐
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google โค๏ธ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.