system
(system)
April 1, 2014, 10:32pm
1
nursejeff wrote on Tuesday, April 01, 2014 :
I have noticed a problem when printing the immunization record.
When the document is printed the Expiration Date is incorrectly today’s date.
Can anyone confirm this.
Jeff Guillory Jr.
NP Health Clinic
system
(system)
April 2, 2014, 11:45am
2
fsgl wrote on Wednesday, April 02, 2014 :
It’s a bug either printing in PDF or HTML.
Don’t know where to fix it.
system
(system)
April 2, 2014, 11:30pm
3
cmswest wrote on Wednesday, April 02, 2014 :
researching this and couldn’t load imms in my test system then realized that i hadn’t set default timezone in php.ini file
this is a nice link: http://open-emr.org/wiki/index.php/Common_Installation_Problems
anyways, i will continue debugging(hopefully the missing expiration date and not my own personal problems)
system
(system)
April 2, 2014, 11:43pm
4
cmswest wrote on Wednesday, April 02, 2014 :
add
",i1.expiration_date " . to the end of this line:
*
* @param string $pid person id
* @param string $sortby sorting field ('vacc' sorts by name, otherwise will sort by date)
* @param boolean $showError indicator whether to retrieve the records that were added erroneously
* @return recordset listing of immunizations for a patient
*/
function getImmunizationList($pid, $sortby, $showError)
{
$sql = "select i1.id ,i1.immunization_id, i1.cvx_code, i1.administered_date, c.code_text_short, c.code".
",i1.manufacturer ,i1.lot_number, i1.completion_status ".
",ifnull(concat(u.lname,', ',u.fname),'Other') as administered_by ".
",i1.education_date ,i1.note ". ",i1.expiration_date " .
",i1.amount_administered, i1.amount_administered_unit, i1.route, i1.administration_site, i1.added_erroneously".
" from immunizations i1 ".
" left join users u on i1.administered_by_id = u.id ".
" left join code_types ct on ct.ct_key = 'CVX' ".
" left join codes c on c.code_type = ct.ct_id AND i1.cvx_code = c.code ".
" where i1.patient_id = ? ";
if (!$showError) {
$sql .= "and i1.added_erroneously = 0 ";
}
and then replace this
with this:
if (isset($row[‘expiration_date’])) {
$temp_date = new DateTime($row[‘expiration_date’]);
$data[$current][xl(‘Expiration’) . “\n” . xl(‘Date’)] = $temp_date->format(‘Y-m-d’);
}
else{
$data[$current][xl(‘Expiration’) . “\n” . xl(‘Date’)] = ‘’;//$temp_date->format(‘Y-m-d’);
}
sorry about lousy formatting
system
(system)
April 3, 2014, 2:21am
5
cmswest wrote on Thursday, April 03, 2014 :
committed 02:10AM - 03 Apr 14 UTC
system
(system)
April 3, 2014, 1:55pm
6
fsgl wrote on Thursday, April 03, 2014 :
Thanks, Stephen for the fix.
Thought I try it out on my test copy. Jeff and I were aware of the timezone problem from another thread.
Got nowhere fast because the json extension is missing, There is no access to the database. Not knowing what exactly is amiss, I would guess it is one of the dependencies. The GDebi Installer can be hit or miss. If all else fails, I’ll re-install Brady’s package.
Not a big deal because it’s the test copy. Really glad, however, the production copy is on a Windows device.
system
(system)
April 3, 2014, 2:21pm
7
cmswest wrote on Thursday, April 03, 2014 :
try this from the terminal apt-get install php5-json
system
(system)
April 3, 2014, 3:12pm
8
fsgl wrote on Thursday, April 03, 2014 :
Json installed successfully, but exactly the same error message preventing access to the database. Must be missing other stuff.
system
(system)
April 3, 2014, 3:22pm
9
cmswest wrote on Thursday, April 03, 2014 :
did you restart apache2?
sudo service apache2 restart
system
(system)
April 3, 2014, 5:57pm
10
fsgl wrote on Thursday, April 03, 2014 :
Les gens de la Nouvelle-Angletere sont les meilleurs!
Xampp Control had always been a guide post in Windows. Usually would remember to turn Apache off and on, but no such animal in Linux Mint.
Now have access to phpMyAdmin and bug fixed for both PDF and HTML printing.
Mille grazie.
system
(system)
April 3, 2014, 6:57pm
11
system
(system)
April 3, 2014, 11:32pm
12
jcahn2 wrote on Thursday, April 03, 2014 :
From the dreaded command line:
sudo apache2ctl graceful
will restart apache without hurting anyone’s feelings (will only restart apache if it is inactive).
system
(system)
April 4, 2014, 12:02am
13
jackfruit501 wrote on Friday, April 04, 2014 :
I wonder if cmdline $’ sudo /etc/init.d/mysql restart ’ will help. I had to reboot or to do this and to restart apache2 as well everytime I upgrade/update any emr.
system
(system)
April 4, 2014, 10:47am
14
fsgl wrote on Friday, April 04, 2014 :
The Terminal is like old crusty professors in medical school with the demeanor of the Old Testament God but the best interests of students in their hearts.
system
(system)
April 4, 2014, 10:53am
15
fsgl wrote on Friday, April 04, 2014 :
Makes sense to do both after an upgrade.
In this case because changes occurred only in the apache2 folder, I would think that only one restart was required.
system
(system)
April 5, 2014, 3:26am
16
bradymiller wrote on Saturday, April 05, 2014 :
Hi Stephen,
Thanks for the fix. Committed it to the codebase and it will be in the next 4.1.2 patch.
-brady
OpenEMR