| Order ID | id_order (NUMBER) | * select = 'o.id_order as `id_order`';
|
| 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`';
|
| Paid and not canceled ? | valid (BOOLEAN) | * select = 'IF (o.valid > 0, 'true', 'false') as `valid`';
|
| Validated ? (logable) | logable (BOOLEAN) | * select = 'IF (oslg.logable > 0, 'true', 'false') as `logable`';
* join = 'LEFT JOIN `ps_order_state` `oslg` ON `oslg`.id_order_state = o.current_state'; |
| Shop | shop (TEXT) | * select = 'COALESCE(`shop`.name, '') as `shop`';
* join = 'LEFT JOIN `ps_shop` `shop` ON `shop`.id_shop = c.id_shop'; |