How to I get the ID a record that is created in a logic hook in the Hook

[chrislynch8]

The title might not explain extactly what I need.

I have a before_save logic hook and depending on a field in the record the before_save will create a new contact record. I have it passing values from the current record into the new record as follows

 $contact = new Contact();
$contact->first_name = $bean->fdc_first_name;
$contact->last_name = $bean->fdc_las_name;
and so on 
$contact->save(); 
  

hen below the last line above I have more custom logic but I need to uset he ID of the new contact it in to create a relationship to an account by adding to hte accounts_contacts table .

I need to get the id of the newly created record.

Rgds
Chris

[wdroush]

I'm not sure, can you force the ID? Do a "SELECT UUID()" from MySQL and force the contact's ID to be that?

Just a guess.

[tellusmore]

all my logic hooks i did everything "manually" via mysql_query's

force sugar's hand, it's the only way, just make sure you include all the extra tables they use for every single piece of info

like the 2 tables they use just to store an email address...

query away!

[jjwdesign]

At least use $db

 global $db
 
$query = "write your query"; 
$result = $db->query($query);
while ($row = $db->fetchByAssoc($result)) {
...some stuff...
} 
  

[SugarDev.net]

Direct querying for stuff like this??



Here's how it's done:

 $bean->id = create_guid();
$bean->new_with_id = true;

$contact = new Contact();
$contact->first_name = $bean->fdc_first_name; 
$contact->last_name = $bean->fdc_las_name; 
and so on  
$contact->save(); 
  

$bean->id is yours for the taking.

[datasponge]

I create the guid beforehand and save it with the record so I know it.

Here's a function to create a guid

 function guid(){
    if (function_exists('com_create_guid')){
        return com_create_guid();
    }else{
        mt_srand((double)microtime()*10000);//optional for php 4.2.0 and up.
        $charid = strtolower(md5(uniqid(rand(), true)));
        $hyphen = chr(45);// "-"
        $uuid = substr($charid, 0, 8).$hyphen
                .substr($charid, 8, 4).$hyphen
                .substr($charid,12, 4).$hyphen
                .substr($charid,16, 4).$hyphen
                .substr($charid,20,12);
        return $uuid;
    }
} 
  

Then you just add a line between your lines like:

 $contact = new Contact();
$contact->id = guid();
$contact->first_name = $bean->fdc_first_name; 
  

Then you can reference $contact->id or save it to another temporary variable to use later.

Phil

[Edit - looks like SugarDev snuck in before me with a similar answer and better data regarding using the bean with hooks]

[chrislynch8]

Direct querying for stuff like this??



Here's how it's done:

 $bean->id = create_guid();
$bean->new_with_id = true;
 
$contact = new Contact();
$contact->first_name = $bean->fdc_first_name; 
$contact->last_name = $bean->fdc_las_name; 
and so on  
$contact->save(); 
  

$bean->id is yours for the taking.

Si I add

 $bean->id = create_guid();
$bean->new_with_id = true; 
  

Then that is the ID that will be given to the contact with the $contact->save();

I don't fully understand, how - because is $bean->id not the ID of the record the logic is currently running for. Could you explain a little further please.

Rgds
Chris

[Gyro.Gearless]

The title might not explain extactly what I need.

I have a before_save logic hook and depending on a field in the record the before_save will create a new contact record. I have it passing values from the current record into the new record as follows

 $contact = new Contact();
$contact->first_name = $bean->fdc_first_name;
$contact->last_name = $bean->fdc_las_name;
and so on 
$contact->save(); 
  

hen below the last line above I have more custom logic but I need to uset he ID of the new contact it in to create a relationship to an account by adding to hte accounts_contacts table .

I need to get the id of the newly created record.

Rgds
Chris

IIRR, SugarBean::save() returns the id of the newly created record, so just take the return value from $contact->save() ; otherwise $contact->id should also do the trick. See data/SugarBean.php....

HTH
Gyro

[chrislynch8]

IIRR, SugarBean::save() returns the id of the newly created record, so just take the return value from $contact->save() ; otherwise $contact->id should also do the trick. See data/SugarBean.php....

HTH
Gyro

That is perfect the $contact->id is the correct ID I was looking for. Thanks

Rgds
Chris

[wdroush]

IIRR, SugarBean::save() returns the id of the newly created record

FUUUUUUUUUUUUUUUUUUUU

I didn't know that, oh the pain I've had forcing UUID generation through MySQL.