Reservations resources in e-mail notification?

[thermskin]

Hi Nick,

How can I include additional resources from additional_resources table into e-mail notification?

Best regards,
T.

[Nick]

The short answer is that you'll need to change/add something to the localization file(s) for your supported language(s), then change send_email() in lib/Reservation.class.php to somehow append the accessories that are being booked with the resource.

This is fairly difficult since only the accessory IDs are provided when adding/modifying reservations.  The easiest way to get the accessory names for the email would be to pull all of the accessory info for this reservation from the database when sending the email.

The other option would be to change how add/modify works to accept a dictionary of accessoryId => accessoryName and use that from the send_email() function.

Either way, this is a pretty complicated change.

[thermskin]

Hi Nick,

Thanx for tip:-)

I have managed to do that in RSS. Now I'm going to do it for e-mail.
I'll post here how-to, when I finish it.

Best regads,
T.

[thermskin]

Hi all,

This is a small how-to for getting additional resources in e-mail.

Everything is done inside Reservation.class.php.

In function send_email you have to add :

Code:

$this->ar = $this->db->get_sup_resources($this->id); // return array

$arCount = count($this->ar);
$arArray = $this->ar;
$txtAR = "";

for ($i=0;$i < $arCount; $i++) {
  $txtAR = $txtAR . $arArray[$i]['name'].", "; // concenate string
}

then depending on layout of your table (message)
you have to put this

Code:

  <tr class="values">
    <td>Additional resources</td>
    <td>$txtAR</td>
    <td colspan="6">&nbsp;</td>
  </tr>

That's it.

[Nick]

Nice.  Thanks for the contribution!