Displaying phone number in weekly schedule view

[Smiddler]

Hello I have a request to display the phone number as well as the user name in the schedule view , the information is available when the reservation is clicked on but I need it displayed as the schedule will be printed and given to a user without online access , any help greatly appreciated

[Nick]

Within lib/Schedule.class.php write_reservation(), you can get $rs['phone'] and set it on the Summary or something.  You could also pass it in to write_reservation() in templates/schedule.template.php from there and do whatever you want with it.

[Smiddler]

Thanks Nick for the reply , I have almost zero knowledge on php but gave it a try I am not sure I was editing the correct file as it seemed to be affecting a different view than I was expecting attached is a link of what I would like to achieve ,if its easy I can give it a go otherwise  if anyone can do it for a reasonable cost (its for a volunteer organization) can they let me know

 http://cid-d376f6be36fb1e04.office.live.com/self.aspx/Public/Php%20image/screen%20shot.jpg

[Nick]

Sorry, I misunderstood.  This is even easier since the data is already coming back.

You can add this right before line 186 of templates/rescalendar.template.php

Code:

echo "{$res['phone']}<br/>";

[Smiddler]

Hi Nick thanks for your reply unfortunately I tried that it didn't work , As a test I replaced the variable with some text and that printed out where I expected it to so its close  but adding the code didnt display the phone number.

 echo "{$res['phone']}<br/>";

[Nick]

Sorry, I thought that data was being returned but it is not.  Change line 41 of lib\db\rescalendardb.class.php to:

Code:

$sql = 'SELECT res.*, res_users.*, resources.name, resources.location, users.fname, users.lname, users.phone'

[Smiddler]

Thanks Heaps that works perfectly , I will let you know when we roll it out   !!

[georkame]

I've tried adding (sperately and together)

 echo "{$res['phone']}<br/>";

and

$sql = 'SELECT res.*, res_users.*, resources.name, resources.location, users.fname, users.lname, users.phone'

but when i hover the mouse over the reservation it does not show the Phone, nor the phone is shown in the reservation box; but once you click on the box the phone info are there.

Did I miss something?

thx for your responses in advance.

[Nick]

What page are you referring to?

[georkame]

On the Booking page and/or the schedule page.  

[Nick]

Sorry, I thought you meant that weekly calendar view.  There are a couple of layers that need to change for this.

In lib\schedule.class.php, change line 514 to       

write_reservation($colspan, $color_select, $mod_view, $rs['resid'], $summary, $viewable, $this->scheduleType == READ_ONLY, $is_pending, $rs['phone']);

In templates\schedule.template.php, change line 225 to

function write_reservation($colspan, $color_select, $mod_view, $resid, $summary = '', $viewable = false, $read_only = false, $pending = 0, $phone = '') {


And then change that function to write it out wherever you want.