Generating entries via hook????

[michamamo2]

Hi,


Is it possible to generate new entries or change existing entries in a customized module using a logical hook?
- if yes, how does it work (especially generating the new entry)?
- I think I can change the entries using some sql code in php ... ... right?

Micha

[mikesolomon]

Hi,


Is it possible to generate new entries or change existing entries in a customized module using a logical hook?
- if yes, how does it work (especially generating the new entry)?
- I think I can change the entries using some sql code in php ... ... right?

Micha

You can generate new entries or amend existing ones

Both are done using sql

[dwheeler]

New entries can/should be created from a logic hook without directly interfacing with the database by create a new instance of the SugarBean of your the module, setting the values on that bean, and then calling the beans save() function.

Example using Accounts:

 require_once("modules/Accounts/Account.php");
$temp_account = new Account();
$temp_account->name = "My new account";
$temp_account->save(); 
  

Similarly, if you wanted to change an existing account, you can call

 $temp_account->retrieve($id) 
  

after creating the new Account object and before making any changes

[michamamo2]

Hi,

that sounds good - what I want is to create entries for a new module (copied from opportunities) every time an opportunity is saved. I assume I will have to call the retrieve function and define the mandatory data (out of the opportunity data) like done in your example with the name for accounts.
Is this a plausible solution?

Greetings from Germany
Micha

[SugarDev.net]

Yes that's correct.

[michamamo2]

Hi,

my hook works quite good in creating new entries in my customized module. But there's still one problem:

The new module was copied from the opportunity module and it needs an entry in the "date_closed" field. Just copying the field doesn't seem to work

In the hook function I defined:
$temp_[New_Module]->date_closed = $focus->date_closed

This always leads to 01/01/2000 in the date_closed field of the new module.

What can I do to copy the real "date_closed"?

Micha

[SugarDev.net]

Yeah, hooks and date field don't really match...don't have a solution right now but you could try using $focus->fetched_row['date_closed'] instead.

[michamamo2]

Hi,

my hook is working now, including the date fields.
It will work if the date formatting is same for all users (which I am responsible for):
$temp_[new_module]->date_closed = $help5."/01/".$help6;
(by defining the date format to mm/dd/yyyy and using integer variables $helpX to calculate year and month)

By the way: If I change the config.php in a way, that only one dateformat is allowed, is it right, that then the users have to use this dateformat and that the hook should be save if it can manage this dateformat?

Now there's a second question:
I want to delete some entries in a submodule with the same hook ....

OK, I need to update the relationship table and the new created table with deleted = 1 - but do I need to do thisg via SQL (I have a query for that running in my database environment) or is there another solution using Sugar functionality?

Any ideas?

Micha