How is reference_number generated

[Photovor]

Hi, I have a case where I want to manually create a reservation through another script. I was curious as to how the reference_number in the reservation_instances table is generated. Could you please shed light on that process?

Thanks!

[Nick]

It's simply using uniqid(). You can change it on line 140 of /Domain/Reservation.php

[bobbyliew]

Nick,

TQ for the guide, and product. May I know, except uniqid(), any other tools can generate number only? because I want to integrate with the machine to unlock the door. Please guide.

Thanks again.

[bobbyliew]

and, may I know, how can I export the reference number to external programme? thanks.

[Nick]

When an admin exports reservations as CSV you get the reference number.

[bobbyliew]

When an admin exports reservations as CSV you get the reference number.

Nick, ... thanks for the reply.

[hglezq]

Hey Nick.

I need the reference to be consecutive numbers instead of uniqid. Is there any chance to make this happen?

[Nick]

If you're comfortable with PHP, you can do this pretty easily. Just let me know if you need more info.

[hglezq]

I haven´t enough experiencie in php code.

Could you please tell me what it´s the method?

[Nick]

I unfortunately don't have the time to post the full code. You'll need to change line 140 of Domain/Reservation.php to be something like:

$this->SetReferenceNumber(ReferenceNumberGenerator::Next());

Your implementation of ReferenceNumberGenerator will need to pull the next sequential number from a database or something.

Alternatively, if the numbers don't need to be sequential, but simply incremental and numeric, you can just use the date formatted as year month date hour minute second millisecond or a timestamp.

[hglezq]

Thank u so much