New/Search-Summary -> Patient problem

jfrshion wrote on Thursday, July 05, 2012:

Hey guys! I need to edit the contact details for New/Search->Patients: Who Contact Choices Employer Stats Misc The problem is that I have searched the .php to do it but I have not been able to find, I think I opened each .php OEMR and finding none, I hope you can tell me which file and location I also need to edit the summary and I have the same problem According to firebug should be the file in C:\xampp\htdocs\OpenEMR\Interface\new\new.php ….But I open it and isn’t it
I hope you can help me… I need it the soon as posible :confused:

bradymiller wrote on Thursday, July 05, 2012:

Hi,

This can be customized at Administration->Layouts->Demographics. Be sure you do a backup before modifying this.

-brady
OpenEMR

jfrshion wrote on Friday, July 06, 2012:

Thank you Brady, before do that… I can’t add a new patient… and i don’t know why…
I just create a new .css stylesheet and modified the left_nav
Ok… I can add a new patient, but when I do a search and try to open a patient for modify or view the summary I got an error:
ERROR: query failed: SELECT DATEDIFF(?,`deceased_date`) as `days_deceased` FROM `patient_data` WHERE `pid` = ? AND `deceased_date` IS NOT NULL AND `deceased_date` != ‘0000-00-00 00:00:00’ AND `deceased_date` <= ?

Error: Unknown column ‘deceased_date’ in ‘field list’

Can you help me with this?

bradymiller wrote on Saturday, July 07, 2012:

Hi,

Sounds like you removed the deceased_date column from the patient_data table (meaning you removed the Misc->deceased_date row from Administration->Layouts->Demographics. This is why it’s important to backup before modifying the layouts. Also, rather than remove rows in the Layout gui, suggest instead changing UOR to ‘Unused’.

-brady
OpenEMR

jfrshion wrote on Sunday, July 08, 2012:

Got it…! Thanks… again!!! Fortunately I have a backup

jfrshion wrote on Tuesday, July 10, 2012:

Hey Brady… Can you tell me where is the .css (or whatever) to modify the interface of the calendar?

bradymiller wrote on Wednesday, July 11, 2012:

Hi,
I am guessing this is it (for the default Outlook calendar):
interface/themes/ajax_calendar.css
-brady
OpenEMR

jfrshion wrote on Wednesday, July 11, 2012:

Yeap …. I guessed the same …. but doesn’t work, nothing changes
Actually I had already modified the previous version (before deleting misc), and it worked, but now I modified it and doesn’t work
You don’t have any idea why?

jfrshion wrote on Thursday, July 12, 2012:

Hi!
Thanks for all your help Brady, I resolve this, I just erased the cookies and caché from firefox, and BINGO hahaha all the changes in the new interface are there!!

deschel wrote on Sunday, July 29, 2012:

Some of what was expressed in this post is concerning to me.

Please verify that what I am interpreting is correct:
“Administration->Layouts” does not just change the layouts, but it changes the database tables. 

If so, then the word “Layouts” is misleading.  Additionally, giving the user this ability is kind of dangerous (even if they do have admin priviledges.) 

Plus, new updates to the software risk breaking the database customizations done in “Administration->Layouts”.  If someone, needs to add new fields, they should probably use the already existing “usertext” or “userlist” fields.  I really doubt many people add new fields by this method anyway. 

Can we remove the ability for users to make database changes from “Administration->Layouts”? 

The layout customization should just effect the layout, not the database.  If someone does not want to use a field, they can just delete it from the layout.  The field should still exist in the database after this deletion (there is really no need to delete the table field) and the user should be able to add it back later if they change their mind.  This would alleviate the risk of users messing up the database by modifying the layout.  And, also eliminate the need to back up the database prior to layout changes.

If someone really does need to track other data, requiring database changes, this should be done by using the phpMyAdmin database module embedded in OpenEMR to add new table fields.  This the more appropriate way to modify the database.  The phpMyAdmin database module can be accessed from: “Administration->Other->Database”.

“Administration->Other->Database” for database changes.
“Administration->Layouts” for layout changes.

We really need to keep these two things separate!

Brady, would you agree to this change?

-david

deschel wrote on Sunday, July 29, 2012:

To save me some time.

Can someone tell me:
In which files is the programming for “Administration->Layouts”?
Which tables are used to store this customization info?

Thanks.

-david

marka1211 wrote on Tuesday, July 31, 2012:

Table layout data is in the database table called “layout_options”.  Individual lists are in “list_options”.