| Customer ID | id_customer (NUMBER) | * select = 'c.`id_customer`'; |
| email (TEXT) | * select = 'c.`email`'; | |
| Firstname | firstname (TEXT) | * select = 'c.`firstname`'; |
| Lastname | lastname (TEXT) | * select = 'c.`lastname`'; |
| Gender | gender (TEXT) | * select = 'COALESCE(`gender`.name, '') as `gender`';
* join = 'LEFT JOIN `ps_gender_lang` `gender` ON `gender`.id_gender = c.id_gender AND `gender`.id_lang = 1'; |
| Birthday | birthday (TEXT) | * select = 'DATE_FORMAT(c.`birthday`, '%Y%m%d') as `birthday`';
|
| Group | group (TEXT) | * select = 'COALESCE(`group`.name, '') as `group`';
* join = 'LEFT JOIN `ps_group_lang` `group` ON `group`.id_group = c.`id_default_group` AND `group`.id_lang = 1'; |
| Company | company (TEXT) | * select = 'COALESCE(c.company, '') as `company`';
|
| SIRET | siret (TEXT) | * select = 'COALESCE(c.siret, '') as `siret`';
|
| APE | ape (TEXT) | * select = 'c.`ape`'; |
| Newsletter | newsletter (BOOLEAN) | * select = 'IF (c.newsletter > 0, 'true', 'false') as `newsletter`';
|
| Outstanding Amount | outstanding_allow_amount (NUMBER) | * select = 'c.`outstanding_allow_amount`'; |
| Max payment days | max_payment_days (NUMBER) | * select = 'c.`max_payment_days`'; |
| Show public price | show_public_prices (BOOLEAN) | * select = 'IF (c.show_public_prices > 0, 'true', 'false') as `show_public_prices`';
|
| Creation date | date_add (YEAR_MONTH_DAY_HOUR) | * select = 'DATE_FORMAT(c.date_add, '%Y%m%d%H') as date_add';
|
| Number of orders | orders_nb (NUMBER) | * select = '(SELECT COUNT(*) FROM `ps_orders` o_nb
WHERE o_nb.id_customer = c.id_customer) as orders_nb'; |
| Number of carts | carts_nb (NUMBER) | * select = '(SELECT COUNT(*) FROM `ps_cart` c_nb
WHERE c_nb.id_customer = c.id_customer) as carts_nb'; |
| Number of address | addresses_nb (NUMBER) | * select = '(SELECT COUNT(*) FROM `ps_address` a_nb
WHERE a_nb.id_customer = c.id_customer) as addresses_nb'; |
| Shop | shop (TEXT) | * select = 'COALESCE(`shop`.name, '') as `shop`';
* join = 'LEFT JOIN `ps_shop` `shop` ON `shop`.id_shop = c.id_shop'; |