how to add hook for civibooking

[henro]

hi all ,
ho do i add hook for civibooking


appreciate for your suggestion

thanks henro tanjung

[Erik Hommel]

Henro,

can you expand on your question? What hook do you want to use? Do you mean what entity to use?

[henro]

thanks erick,

so my case is :

i have 3 resources for booking :
1. room physioterapy
2. Bed A001
3. Chair 001

so, when room physioterapy has booked, bed A001 and chair 001 cannot be booking in the same time ( time for physioterapy booking ).

but if bed or chair already book, room physioterapy still can be booking

thanks again

[Erik Hommel]

I understand. So what do you want to do with what hook? Or do you want to create a new hook? I am not sure about the hook bit :-)
Do you want to add validation? You should use a hook civicrm_validateForm and check for the form name, see http://wiki.civicrm.org/confluence/display/CRMDOC/hook_civicrm_validateForm.
You will need to find out what the formname is (the namespace of the class). You can do that by checking which file is used (should be something like CRM/Civibooking/Form/xxxxxxx.php meaning the form name is CRM_Civibooking_Form_xxxxxx), by setting the CiviCRM setting debug to Yes and then adding &smartyDebug=1 at the end of your URL (which brings up a separate window showing you all your form fields) OR by adding a debug at the beginning of the validateForm hook whilst you are at that form, and the refreshing the form.
Does it make sense?

[henro]

thanks again erick 

here is a bit of my code

 

function myextension_civicrm_validateForm( $formName, &$fields, &$files, &$form, &$errors)

{
include "koneksi.php";                  
               $query = "select civicrm_booking.id as bookingid,
               
               civicrm_booking.start_date as datebooking
               from civicrm_booking
                   
               where civicrm_booking.id = 16";
               $exe = mysql_query($query);
               while($row = mysql_fetch_assoc($exe))
               {
               $booking = $row['bookingid'];
               $parent = $row['parent'];
               $start_date = $row['datebooking'];
               }
watchdog('myextension', print_r($fields, false), array(), WATCHDOG_DEBUG);
  drupal_set_message( '<b>TESTING: </b><pre>' . print_r($formName,1) . '</pre>');


if (($formName=='CRM_Booking_Form_SelectResource') || ($formName=='CRM_Booking_Form_SelectResource'))   {
 
     if ( $fields['event_start_date'] == $start_date ){
    $errors[$fields['event_start_date']] = ts('parent already book');
   
  }
  else{

  }
  }
  }
 
  return;

[Erik Hommel]

I do not know all the details of CiviBooking so I have no idea if you are evaluating the right fields? I find this hard to relate to the question 'how do I add a hook to CiviBooking' :-)))))

[Erik Hommel]

but I would recommend that you do not access the civicrm database directly but use this pattern:

Code: [Select]

$targetQuery = 'SELECT contact_id FROM civicrm_activity_contact WHERE activity_id = %1 AND record_type_id = %2';
$targetParams = array(
      1 => array($activityId, 'Integer'),
      2 => array(3, 'Integer'));
$daoTargets = CRM_Core_DAO::executeQuery($targetQuery, $targetParams);
while ($daoTargets->fetch()) {
     $targetContactNames[] = CRM_Costinvoicelink_Utils::getContactName($daoTargets->contact_id);
}

Does it make sense? That way your code will always work with whatever database or DB toolset CiviCRM uses, and you do not have to manage your own connections.

[henro]

thanks Erick