Support

September 16, 2017 at 12:42 pm

In Belgium (like many European countries) sequential invoice numbers are mandatory; therefore they need to be generated right after registration. My code:

// assign invoice number right after registration
add_action( 'AHEE__EE_Registration_Processor__trigger_registration_update_notifications', 'act_ee4_assign_invoicenr', 10, 2); 

function act_ee4_assign_invoicenr( $registration, $update_params ) {
  // get transaction
  $transaction = $registration->transaction();

  // get invoice year and prefix
  $current_year = (int) date( 'Y' ); 
  $invoice_prefix = get_option( 'invoice_prefix' ); // e.g. EE-
  $invoice_year = (int) get_option( 'invoice_year' ); // e.g. 2017

  // happy new year
  if ( $invoice_year != $current_year ) {
    update_option( 'invoice_year', $current_year );
    update_option( 'invoice_order', 1 );
  }

  // get invoice number
  $invoice_order = (int) get_option( 'invoice_order' ); // e.g. 24

  // increment for next invoice
  update_option( 'invoice_order', $invoice_order + 1 );

  // assemble invoice number and assign
  $invoice_number = $invoice_prefix . $invoice_year 
    . str_pad( $invoice_order, 4, '0', STR_PAD_LEFT ); // e.g. EE-20170024
  EEM_Answer::instance()->insert(
    array(
      'REG_ID' => $registration->ID(),
      'QST_ID' => 16, // admin only question 'invoice number'
      'ANS_value' => $invoice_number
    )    
  );
}

Question number 16 is an admin question called ‘invoice number’ added to the user details system group. This works most of the time, but randomly, the invoice number is not filled and remains empty.

Any idea of what’s going wrong?

• This topic was modified 7 years, 4 months ago by Tony. Reason: code formatting