docaltmed wrote on Wednesday, July 15, 2009:
How would I customize the Patient List report to replace the "work phone" field with the "email" field?
cfapress wrote on Friday, July 17, 2009:
Look at the file
<oemr>/interface/reports/patient_list.php
Then around line 157, where the SQL query is specified, add this line
"p.email,".
Next, you need to alter the code that outputs the table headers, around line 148 you’ll see something like this
<th> <?php xl(‘Work Phone’,‘e’); ?> </th>
change it to
<th> <?php xl(‘Email’,‘e’); ?> </th>
Finally, you need to alter the code that outputs the results of the query. Around line 226 look for this line:
<?php echo $row[‘phone_biz’] ?>
and change it to
<?php echo $row[‘email’] ?>
That should do the trick.
Jason