Menu

#222 Display user custom field on reports

open
nobody
None
5
2012-07-20
2011-09-13
Paulo
No

Hi,
I would like to display a custom field that I add to the users table (with the user real name) on the reports. It would be nice to display that also on the reservations in calendar view.
How can I do this.
Thanks,
Paulo F.

Discussion

  • Campbell Morrison

    You'll need to modify the MRBS code to do this, changing the SQL queries so that they do a join on the users table and then displaying the results.

    I agree that this feature should ideally be in MRBS as standard and it's something I'd like to include.

    Campbell

     
  • Paulo

    Paulo - 2011-09-14

    Thanks for your reply.
    What file do I need to change to replace the username with the 'custom field' on the reports.

    Thanks,
    Paulo F.

     
  • Campbell Morrison

    You'll need to modify report.php. For the calendar view you'll need to modify day.php, week.php, month.php and functions.inc.

    Campbell