XAMPP?
Debian?
Virtual Machine?
MSI Installer?
Ubuntu Software Center?

Review and integrate update (in progress) to Dates functions.

1. Make sure all dates are stored UTC
2. Add Timezone support at the user and site level
3. Replace DatePicker with newer tools, keep localization support

This is work that is already nearly completed on MI2 private repos and will be pushed to this one for team review.

Completely re-style the LibreEHR login page, probably removing the top bar, giving it a much-needed makeover that looks completely different.

We have lots of messy stuff in the application root directory. I would like to see that, as a start, get moved somewhere appropriate.

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.

Review and Cherry-Pick elements of @openemr that pass muster with the team for inclusion in the 1.0 release

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

Time to talk about the next milestone and what it should have:

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

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;
}

Replace ZHH features (Portal). Enhance current portal to meet measure or other method.

Replace ZHH feature with internal one or Immunization and Public Health Registries.

MI2 has a Immunization connection to CAIR (California).

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

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.

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?

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)

Probably

because of a rebase or revert.

https://forums.librehealth.io/c/7-support
And make sure you set your preference to watch that category ...

Construct more configuration tools for menus, making decisions about the JSON vs. DB approaches for the frameless configuration.

The search button gives the attached error.

This issue addresses general conversation, assignment of issues, and other communications related to the milestone that are not directly applicable to a single issue.

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.

Update styling ot "Industry Standard" look and feel on the main components.

Frames, Menus a priority

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?

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 ?

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.

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

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>

Replace ZHH feature with one that's part of the core.

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://open-emr.org/',

  'http://libreehr.github.io',

refs/remotes/origin/master
xl('URL for LibreEHR support.')

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..."

@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.

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.

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

List of irritations, minor bugs, and personal peeves:

• Stray html and header tags everywhere. In interface alone, there are 350 html opening tags. Most all, if not all of these are seen as a second opening tag by time php makes a page.
• Unused tables.

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?

1990 called, and they want their progress notes back.

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.

Remove embedded PhpMyAdmin

It briefly says "New" and then changes to "unknown"

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.

After setup.

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)

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)

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:

• Installation
• How LibreEHR works: An overview of the patient-centric design and component interactions, then a demonstration of the workflow process of patient intake, assessment, treatment, billing and AR activity.
• Configuration: Analyzing your clinic workflow scenario, then configuring LibreEHR to accommodate your needs. Includes Users, Facilities, Globals, Pharmacies, Insurance Companies, Partners Vendor settings (eRX, x12 etc...), Data loads, Forms, Menu changes, Themes, Calendar, then returns to ACL configuration for users.
• Patient Management: Creating patients/demographics, managing documents, scheduling, flowboard, Encounters and other interventions, Treatment plans, Progress notes, PCP letters, reporting.
• Billing and Accounting: A mini introduction to medical billing concepts including EDI/ERA and clearinghouse partners. Instruction on: Code and fee management, Fee sheets, Authorization, Billing Report review of claims, Creating invoices, checkouts, CMS-1500's, then x12 batch file creation-upload, ERA acquisition and upload, manual payments and distribution. Then a discussion of batch errors, adjustments, denials and related topics.
• Reporting, Exports, Imports

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

A document needs to be written for the menu tool.

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.

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 encounter, when hitting save: Error: Incorrect datetime value: '' for column 'onset_date' at row 1
• adding any/ all issues, when hitting save: Error: Incorrect integer value: '' for column 'reinjury_id' at row 1
• trying 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
• at bottom of patient record, clicked on Amendments's Edit button
  ERROR: query failed: SELECT * FROM amendments WHERE pid = ? ORDER BY amendment_date DESC
  Error: Table 'libreehr_socrates.amendments' doesn't exist
• fees/ billing: 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
• all procedures screens had one or another of these:
  Error: Table 'libreehr_socrates.procedure_providers' doesn't exist
  Error: Table 'libreehr_socrates.procedure_order' doesn't exist
  Error: Table 'libreehr_socrates.procedure_result' doesn't exist
  details:

  . 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)

[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