[SOLVED] Custom SQL right after account created [prestashop 1.7]

[batou]

Hi, 

I'm currently creating some custom modules.

I need to do some sql select, update and insert right after a customer created his account.

To do my sql, I need the e-mail used and the ID of this new customer.

I don't know where to do that properly.

Thank's in advance

Edited August 11, 2019 by batou (see edit history)

[Janett]

You can use hook actionCustomerAccountAdd, new customer data is in param argument

[batou]

That means I need to create a specific module to do this ?

[Janett]

Yes

[batou]

Not possible to add smth like override script? 

I have a table with email invited and I want to compare new customer with this table. If they match, do 2 insert sql with the new id_customer

If not, I will create new module  thank you for your help

[Janett]

Override are not recommended, it's a bad practice.

Use them only if any hook can be used. It's really easy to create a module to do what you need.

[batou]

Ok I just dont know how to get the new ID but I will try! Thank you

[Janett]

Looks into param argument, it's an array who contain useful data like Customer Id

[Nishith Nesdiya]

Hi..

use like this actionCustomerAccountAdd hook in your module file
 

public function hookActionCustomerAccountAdd($params)
{
   $id_customer = $params['newCustomer']->id; //get your customer id here
   return true;
}

Thanks

Edited April 29, 2019 by Nishith (see edit history)

[batou]

Thank you Nishith.

Can I add my sql request directly in this hook ?

Something like ?

    public function hookActionObjectCustomerAddAfter($params)
    {
       $id_customer = $params['newCustomer']->id; //get your customer id here
       $customerEmail = $params['newCustomer']->email; //get your customer email here
       $sql = '
     		SELECT `id_list` FROM `ilea_join_list_new_customer` WHERE email='.$customerEmail;
        if ($results = Db::getInstance()->ExecuteS($sql)){
          foreach ($results as $curent_id_list) {
            Db::getInstance()->insert('ilea_join_list_customer', array(
              'id_customer' => (int)$id_customer,
              'id_giftlist' => (int)$curent_id_list
            ), false, true, Db::INSERT, false);
          }
        }
    }

> didn't work even with your hook hookActionCustomerAccountAdd  

Edited April 29, 2019 by batou (see edit history)

[batou]

up ! 

I didn't find the solution for the moment 😕

[Janett]

It didn't work because your code is not right...

    /**
     * Install Module.
     *
     * @return bool
     */
    public function install()
    {
        return parent::install()
            && $this->registerHook('actionCustomerAccountAdd');
    }

    /**
     * Retrieve Customer data after account creation.
     *
     * @param array $params
     */
    public function hookActionCustomerAccountAdd(array $params)
    {
        if (isset($params['newCustomer'])
            && Validate::isLoadedObject($params['newCustomer'])
        ) {
            $giftList = Db::getInstance(_PS_USE_SQL_SLAVE_)->executeS('
                SELECT `id_list`
                FROM `ilea_join_list_new_customer`
                WHERE `email` LIKE "'.pSQL($params['newCustomer']->email).'"
            ');

            if ($giftList) {
                foreach ($giftList as $giftListItem) {
                    Db::getInstance()->execute('
                        INSERT INTO `ilea_join_list_customer` (`id_customer`, `id_giftlist`)
                        VALUES (' . (int) $params['newCustomer']->id . ', ' . (int) $giftListItem['id_list'] . ')
                    ');
                }
            }
        }
    }

If your module is already installed, reset it for hook registration.

Edited May 24, 2019 by Janett (see edit history)

[Janett]

@KILIYATSIA Create a module and use hook ActionCustomerAccountAdd as explained