CiviCRM Community Forums (archive)

Hi to all,
I'm tring to figure out how to use hooks to prepopulate the fields Invoice ID and Transaction ID on Offline Contribution Page. I would like that every time an operator insert an offline contrib automatically Civicrm populate Invoice ID adn Transaction ID based on a particular sql query or value.
I read manuel and documentation but I can't understand how to apply that. I know that I have to use hooks to implement it, and I should use hook_buildForm(), but in wich file I have to put the code? In the main.php of the contrib?

I'm using the last version of Wordpress as CMS and the last version of civicrm

Thank you all for your support

Barto

I have figured out! 

I have added civicrmHooks.php on custom php url with this code

<?php
function wordpress_civicrm_buildForm($formName, &$form) {


if ( is_a( $form, 'CRM_Contribute_Form_Contribution' ) ) {

 mysql_connect("HOST", "USER", "PASSWORD") or die(mysql_error()); 
 mysql_select_db("DATABASE") or die(mysql_error()); 
 $data = mysql_query("SELECT * FROM TABLE") 
 or die(mysql_error()); 
 $info = mysql_fetch_array( $data );
 $idda = $info['anno'];
 $idfa = $info['val'] + 1;
$valore = $idda . '-' . str_pad($idfa, 10, '0', STR_PAD_LEFT);
    $defaults['invoice_id'] = $valore;
$defaults['trxn_id'] = $valore;
    $form->setDefaults($defaults);
  }
  }
  
function wordpress_civicrm_post($op, $objectName, $objectId, &$objectRef) {
 
 
  if ($op == 'create' && $objectName == 'Contribution') {
 mysql_connect("HOST", "USER", "PASSWORD") or die(mysql_error()); 
 mysql_select_db("DATABASE") or die(mysql_error());
 $data = mysql_query("SELECT * FROM TABLE") 
 or die(mysql_error()); 
 $info = mysql_fetch_array( $data );
 $idfa = $info['val'] + 1;
 mysql_query("UPDATE TABLE SET val='".$idfa."'");
  } 
 
}  
?>
In this way I can query a DB for invoice id, punt in the field and if the form is confirmed the db is updated back.
What do you think about?