47 global $conf, $user, $mysoc, $langs;
52 $this->family =
"crm";
53 $this->module_position =
'09';
55 $this->
name = preg_replace(
'/^mod/i',
'', get_class($this));
56 $this->
description =
"Gestion des sociétés et contacts";
59 $this->version =
'dolibarr';
61 $this->const_name =
'MAIN_MODULE_'.strtoupper($this->
name);
62 $this->config_page_url = array(
"societe.php@societe");
64 $this->picto =
'company';
67 $this->dirs = array(
"/societe/temp");
70 $this->hidden =
false;
71 $this->depends = array();
72 $this->requiredby = array(
"modExpedition",
"modFacture",
"modFournisseur",
"modFicheinter",
"modPropale",
"modContrat",
"modCommande");
73 $this->conflictwith = array();
74 $this->phpmin = array(7, 0);
75 $this->langfiles = array(
"companies",
'bills',
"compta",
"admin",
"banks");
78 $this->
const = array();
81 $this->
const[$r][0] =
"SOCIETE_CODECLIENT_ADDON";
82 $this->
const[$r][1] =
"chaine";
83 $this->
const[$r][2] =
"mod_codeclient_monkey";
84 $this->
const[$r][3] =
'Module to control third parties codes';
85 $this->
const[$r][4] = 0;
88 $this->
const[$r][0] =
"SOCIETE_CODECOMPTA_ADDON";
89 $this->
const[$r][1] =
"chaine";
90 $this->
const[$r][2] =
"mod_codecompta_panicum";
91 $this->
const[$r][3] =
'Module to control third parties codes';
92 $this->
const[$r][4] = 0;
95 $this->
const[$r][0] =
"SOCIETE_FISCAL_MONTH_START";
96 $this->
const[$r][1] =
"chaine";
97 $this->
const[$r][2] =
"0";
98 $this->
const[$r][3] =
"Enter the month number of the first month of the fiscal year, e. g. 9 for September";
99 $this->
const[$r][4] = 0;
102 $this->
const[$r][0] =
"COMPANY_ADDON_PDF_ODT_PATH";
103 $this->
const[$r][1] =
"chaine";
104 $this->
const[$r][2] =
"DOL_DATA_ROOT/doctemplates/thirdparties";
105 $this->
const[$r][3] =
"";
106 $this->
const[$r][4] = 0;
118 $this->
const[$r][0] =
"SOCIETE_ADD_REF_IN_LIST";
119 $this->
const[$r][1] =
"yesno";
120 $this->
const[$r][2] =
"0";
121 $this->
const[$r][3] =
"Display customer ref into select list";
122 $this->
const[$r][4] = 0;
126 $this->boxes = array(
127 0 => array(
'file' =>
'box_clients.php',
'enabledbydefaulton' =>
'Home'),
128 1 => array(
'file' =>
'box_prospect.php',
'enabledbydefaulton' =>
'Home'),
129 2 => array(
'file' =>
'box_contacts.php',
'enabledbydefaulton' =>
'Home'),
130 3 => array(
'file' =>
'box_activity.php',
'enabledbydefaulton' =>
'Home',
'note' =>
'(WarningUsingThisBoxSlowDown)'),
131 4 => array(
'file' =>
'box_goodcustomers.php',
'enabledbydefaulton' =>
'Home',
'note' =>
'(WarningUsingThisBoxSlowDown)'),
135 $this->rights = array();
136 $this->rights_class =
'societe';
140 $this->rights[$r][0] = 121;
141 $this->rights[$r][1] =
'Read third parties';
142 $this->rights[$r][2] =
'r';
143 $this->rights[$r][3] = 0;
144 $this->rights[$r][4] =
'lire';
164 $this->rights[$r][0] = 122;
165 $this->rights[$r][1] =
'Create and update third parties';
166 $this->rights[$r][2] =
'w';
167 $this->rights[$r][3] = 0;
168 $this->rights[$r][4] =
'creer';
188 $this->rights[$r][0] = 125;
189 $this->rights[$r][1] =
'Delete third parties';
190 $this->rights[$r][2] =
'd';
191 $this->rights[$r][3] = 0;
192 $this->rights[$r][4] =
'supprimer';
195 $this->rights[$r][0] = 126;
196 $this->rights[$r][1] =
'Export third parties';
197 $this->rights[$r][2] =
'r';
198 $this->rights[$r][3] = 0;
199 $this->rights[$r][4] =
'export';
202 $this->rights[$r][0] = 130;
203 $this->rights[$r][1] =
'Modify thirdparty information payment';
204 $this->rights[$r][3] = 0;
205 $this->rights[$r][4] =
'thirdparty_paymentinformation_advance';
206 $this->rights[$r][5] =
'write';
210 $this->rights[$r][0] = 262;
211 $this->rights[$r][1] =
'Read all third parties (and their objects) by internal users (otherwise only if commercial contact). Not effective for external users (limited to themselves).';
212 $this->rights[$r][2] =
'r';
213 $this->rights[$r][3] = 0;
214 $this->rights[$r][4] =
'client';
215 $this->rights[$r][5] =
'voir';
228 $this->rights[$r][0] = 281;
229 $this->rights[$r][1] =
'Read contacts';
230 $this->rights[$r][2] =
'r';
231 $this->rights[$r][3] = 0;
232 $this->rights[$r][4] =
'contact';
233 $this->rights[$r][5] =
'lire';
236 $this->rights[$r][0] = 282;
237 $this->rights[$r][1] =
'Create and update contact';
238 $this->rights[$r][2] =
'w';
239 $this->rights[$r][3] = 0;
240 $this->rights[$r][4] =
'contact';
241 $this->rights[$r][5] =
'creer';
244 $this->rights[$r][0] = 283;
245 $this->rights[$r][1] =
'Delete contacts';
246 $this->rights[$r][2] =
'd';
247 $this->rights[$r][3] = 0;
248 $this->rights[$r][4] =
'contact';
249 $this->rights[$r][5] =
'supprimer';
252 $this->rights[$r][0] = 286;
253 $this->rights[$r][1] =
'Export contacts';
254 $this->rights[$r][2] =
'd';
255 $this->rights[$r][3] = 0;
256 $this->rights[$r][4] =
'contact';
257 $this->rights[$r][5] =
'export';
271 $this->export_code[$r] = $this->rights_class.
'_'.$r;
272 $this->export_label[$r] =
'ExportDataset_company_1';
273 $this->export_icon[$r] =
'company';
274 $this->export_permission[$r] = array(array(
"societe",
"export"));
275 $this->export_fields_array[$r] = array(
276 's.rowid' =>
"Id",
's.nom' =>
"Name",
's.name_alias' =>
"AliasNameShort",
'ps.nom' =>
"ParentCompany",
277 's.status' =>
"Status",
's.client' =>
"Customer",
's.fournisseur' =>
"Supplier",
's.datec' =>
"DateCreation",
's.tms' =>
"DateLastModification",
278 's.code_client' =>
"CustomerCode",
's.code_fournisseur' =>
"SupplierCode",
's.code_compta' =>
"AccountancyCode",
's.code_compta_fournisseur' =>
"SupplierAccountancyCode",
279 's.address' =>
"Address",
's.zip' =>
"Zip",
's.town' =>
"Town",
'd.nom' =>
'State',
'r.nom' =>
'Region',
'c.label' =>
"Country",
'c.code' =>
"CountryCode",
's.phone' =>
"Phone",
's.fax' =>
"Fax",
280 's.url' =>
"Url",
's.email' =>
"Email",
's.default_lang' =>
"DefaultLang",
's.canvas' =>
"Canvas",
's.siren' =>
"ProfId1",
's.siret' =>
"ProfId2",
's.ape' =>
"ProfId3",
's.idprof4' =>
"ProfId4",
281 's.idprof5' =>
"ProfId5",
's.idprof6' =>
"ProfId6",
's.tva_intra' =>
"VATIntraShort",
's.capital' =>
"Capital",
's.note_private' =>
"NotePrivate",
's.note_public' =>
"NotePublic",
282 't.code' =>
"ThirdPartyType",
'ce.code' =>
"DictionaryStaff",
"cfj.libelle" =>
"JuridicalStatus",
's.fk_prospectlevel' =>
'ProspectLevel',
283 'st.code' =>
'ProspectStatus',
'payterm.libelle' =>
'PaymentConditions',
'paymode.libelle' =>
'PaymentMode',
284 's.outstanding_limit' =>
'OutstandingBill',
'pbacc.ref' =>
'PaymentBankAccount',
'incoterm.code' =>
'IncotermLabel'
287 $this->export_fields_array[$r][
's.prefix'] =
'Prefix';
290 $this->export_fields_array[$r][
's.price_level'] =
'PriceLevel';
293 $this->export_fields_array[$r] += array(
's.accountancy_code_sell' =>
'ProductAccountancySellCode',
's.accountancy_code_buy' =>
'ProductAccountancyBuyCode');
297 $nbofallowedentities = count(explode(
',',
getEntity(
'societe')));
298 if (isModEnabled(
'multicompany') && $nbofallowedentities > 1) {
299 $this->export_fields_array[$r] += array(
's.entity' =>
'Entity');
302 $keyforselect =
'societe';
303 $keyforelement =
'company';
304 $keyforaliasextra =
'extra';
305 include DOL_DOCUMENT_ROOT.
'/core/extrafieldsinexport.inc.php';
306 $this->export_fields_array[$r] += array(
'u.login' =>
'SaleRepresentativeLogin',
'u.firstname' =>
'SaleRepresentativeFirstname',
'u.lastname' =>
'SaleRepresentativeLastname');
308 $this->export_TypeFields_array[$r] = array(
309 's.rowid' =>
"Numeric",
's.nom' =>
"Text",
's.name_alias' =>
"Text",
'ps.nom' =>
"Text",
310 's.status' =>
"Numeric",
's.client' =>
"Numeric",
's.fournisseur' =>
"Boolean",
's.datec' =>
"Date",
's.tms' =>
"Date",
311 's.code_client' =>
"Text",
's.code_fournisseur' =>
"Text",
's.code_compta' =>
"Text",
's.code_compta_fournisseur' =>
"Text",
312 's.address' =>
"Text",
's.zip' =>
"Text",
's.town' =>
"Text",
313 'd.nom' =>
'Text',
'r.nom' =>
'Text',
'c.label' =>
'List:c_country:label:label',
'c.code' =>
'Text',
314 's.phone' =>
"Text",
's.fax' =>
"Text",
315 's.url' =>
"Text",
's.email' =>
"Text",
's.default_lang' =>
"Text",
's.canvas' =>
"Text",
316 's.siret' =>
"Text",
's.siren' =>
"Text",
's.ape' =>
"Text",
's.idprof4' =>
"Text",
's.idprof5' =>
"Text",
's.idprof6' =>
"Text",
317 's.tva_intra' =>
"Text",
's.capital' =>
"Numeric",
318 's.note_private' =>
"Text",
's.note_public' =>
"Text",
319 't.code' =>
"List:c_typent:libelle:code",
320 'ce.code' =>
"List:c_effectif:libelle:code",
321 "cfj.libelle" =>
"Text",
322 's.fk_prospectlevel' =>
'List:c_prospectlevel:label:code',
323 'st.code' =>
'List:c_stcomm:libelle:code',
324 'payterm.libelle' =>
'Text',
'paymode.libelle' =>
'Text',
325 's.outstanding_limit' =>
'Numeric',
'pbacc.ref' =>
'Text',
'incoterm.code' =>
'Text',
326 'u.login' =>
'Text',
'u.firstname' =>
'Text',
'u.lastname' =>
'Text',
327 's.entity' =>
'List:entity:label:rowid',
's.price_level' =>
'Numeric',
328 's.accountancy_code_sell' =>
'Text',
's.accountancy_code_buy' =>
'Text'
331 $this->export_entities_array[$r] = array(
333 'u.firstname' =>
'user',
334 'u.lastname' =>
'user');
335 $this->export_examplevalues_array[$r] = array(
's.client' =>
'0 (no customer no prospect)/1 (customer)/2 (prospect)/3 (customer and prospect)',
's.fournisseur' =>
'0 (not a supplier) or 1 (supplier)');
336 $this->export_sql_start[$r] =
'SELECT DISTINCT ';
337 $this->export_sql_end[$r] =
' FROM '.MAIN_DB_PREFIX.
'societe as s';
338 $this->export_sql_end[$r] .=
' LEFT JOIN '.MAIN_DB_PREFIX.
'societe_extrafields as extra ON s.rowid = extra.fk_object';
339 $this->export_sql_end[$r] .=
' LEFT JOIN '.MAIN_DB_PREFIX.
'societe as ps ON s.parent = ps.rowid';
340 $this->export_sql_end[$r] .=
' LEFT JOIN '.MAIN_DB_PREFIX.
'c_typent as t ON s.fk_typent = t.id';
341 $this->export_sql_end[$r] .=
' LEFT JOIN '.MAIN_DB_PREFIX.
'c_country as c ON s.fk_pays = c.rowid';
342 $this->export_sql_end[$r] .=
' LEFT JOIN '.MAIN_DB_PREFIX.
'c_effectif as ce ON s.fk_effectif = ce.id';
343 $this->export_sql_end[$r] .=
' LEFT JOIN '.MAIN_DB_PREFIX.
'c_forme_juridique as cfj ON s.fk_forme_juridique = cfj.code';
344 $this->export_sql_end[$r] .=
' LEFT JOIN '.MAIN_DB_PREFIX.
'c_departements as d ON s.fk_departement = d.rowid';
345 $this->export_sql_end[$r] .=
' LEFT JOIN '.MAIN_DB_PREFIX.
'c_regions as r ON r.code_region = d.fk_region AND r.fk_pays = s.fk_pays';
346 $this->export_sql_end[$r] .=
' LEFT JOIN '.MAIN_DB_PREFIX.
'c_stcomm as st ON s.fk_stcomm = st.id';
347 $this->export_sql_end[$r] .=
' LEFT JOIN '.MAIN_DB_PREFIX.
'societe_commerciaux as sc ON sc.fk_soc = s.rowid LEFT JOIN '.MAIN_DB_PREFIX.
'user as u ON sc.fk_user = u.rowid';
348 $this->export_sql_end[$r] .=
' LEFT JOIN '.MAIN_DB_PREFIX.
'c_payment_term as payterm ON s.cond_reglement = payterm.rowid';
349 $this->export_sql_end[$r] .=
' LEFT JOIN '.MAIN_DB_PREFIX.
'c_paiement as paymode ON s.mode_reglement = paymode.id';
350 $this->export_sql_end[$r] .=
' LEFT JOIN '.MAIN_DB_PREFIX.
'bank_account as pbacc ON s.fk_account = pbacc.rowid';
351 $this->export_sql_end[$r] .=
' LEFT JOIN '.MAIN_DB_PREFIX.
'c_incoterms as incoterm ON s.fk_incoterms = incoterm.rowid';
352 $this->export_sql_end[$r] .=
' WHERE s.entity IN ('.getEntity(
'societe').
')';
353 if (is_object($user) && !$user->hasRight(
'societe',
'client',
'voir')) {
354 $this->export_sql_end[$r] .=
' AND (sc.fk_user = '.((int) $user->id).
' ';
356 $subordinatesids = $user->getAllChildIds();
357 $this->export_sql_end[$r] .= count($subordinatesids) > 0 ?
' OR (sc.fk_user IN ('.$this->db->sanitize(implode(
',', $subordinatesids)).
')' :
'';
359 $this->export_sql_end[$r] .=
')';
364 $this->export_code[$r] = $this->rights_class.
'_'.$r;
365 $this->export_label[$r] =
'ExportDataset_company_2';
366 $this->export_icon[$r] =
'contact';
367 $this->export_permission[$r] = array(array(
"societe",
"contact",
"export"));
368 $this->export_fields_array[$r] = array(
369 'c.rowid' =>
"IdContact",
'c.civility' =>
"CivilityCode",
'c.lastname' =>
'Lastname',
'c.firstname' =>
'Firstname',
'c.poste' =>
'PostOrFunction',
370 'c.datec' =>
"DateCreation",
'c.tms' =>
"DateLastModification",
'c.priv' =>
"ContactPrivate",
'c.address' =>
"Address",
'c.zip' =>
"Zip",
'c.town' =>
"Town",
371 'd.nom' =>
'State',
'r.nom' =>
'Region',
'co.label' =>
"Country",
'co.code' =>
"CountryCode",
'c.phone' =>
"Phone",
'c.fax' =>
"Fax",
'c.phone_mobile' =>
"Mobile",
'c.email' =>
"EMail",
372 'c.note_private' =>
'NotePrivate',
'c.note_public' =>
"NotePublic",
373 'c.statut' =>
"Status",
374 's.rowid' =>
"IdCompany",
's.nom' =>
"CompanyName",
's.status' =>
"Status",
's.code_client' =>
"CustomerCode",
's.code_fournisseur' =>
"SupplierCode",
375 's.code_compta' =>
"AccountancyCode",
's.code_compta_fournisseur' =>
"SupplierAccountancyCode",
376 's.client' =>
'Customer',
's.fournisseur' =>
'Supplier',
377 's.address' =>
'Address',
's.zip' =>
"Zip",
's.town' =>
"Town",
's.phone' =>
'Phone',
's.email' =>
"Email",
378 's.note_private' =>
'NotePrivate',
's.note_public' =>
"NotePublic",
379 't.code' =>
"ThirdPartyType"
383 if (isModEnabled(
'multicompany')) {
384 $nbofallowedentities = count(explode(
',',
getEntity(
'contact')));
385 if ($nbofallowedentities > 1) {
386 $this->export_fields_array[$r][
'c.entity'] =
'Entity';
389 $nbofallowedentities = count(explode(
',',
getEntity(
'societe')));
390 if ($nbofallowedentities > 1) {
391 $this->export_fields_array[$r][
's.entity'] =
'Entity';
395 $this->export_examplevalues_array[$r] = array(
's.client' =>
'0 (no customer no prospect)/1 (customer)/2 (prospect)/3 (customer and prospect)',
's.fournisseur' =>
'0 (not a supplier) or 1 (supplier)');
396 $this->export_TypeFields_array[$r] = array(
397 'c.civility' =>
"List:c_civility:label:code",
'c.lastname' =>
'Text',
'c.firstname' =>
'Text',
'c.poste' =>
'Text',
'c.datec' =>
"Date",
'c.priv' =>
"Boolean",
398 'c.address' =>
"Text",
'c.zip' =>
"Text",
'c.town' =>
"Text",
'd.nom' =>
'Text',
'r.nom' =>
'Text',
'co.label' =>
"List:c_country:label:rowid",
'co.code' =>
"Text",
'c.phone' =>
"Text",
399 'c.fax' =>
"Text",
'c.email' =>
"Text",
400 'c.statut' =>
"Status",
401 's.rowid' =>
"Numeric",
's.nom' =>
"Text",
's.status' =>
"Status",
's.code_client' =>
"Text",
's.code_fournisseur' =>
"Text",
402 's.code_compta' =>
"Text",
's.code_compta_fournisseur' =>
"Text",
403 's.client' =>
"Numeric",
's.fournisseur' =>
"Numeric",
404 's.address' =>
"Text",
's.zip' =>
"Text",
's.town' =>
"Text",
's.phone' =>
"Text",
's.email' =>
"Text",
405 't.code' =>
"List:c_stcomm:libelle:code",
406 'c.entity' =>
'List:entity:label:rowid',
407 's.entity' =>
'List:entity:label:rowid',
409 $this->export_entities_array[$r] = array(
410 's.rowid' =>
"company",
's.nom' =>
"company",
's.status' =>
'company',
's.code_client' =>
"company",
's.code_fournisseur' =>
"company",
411 's.code_compta' =>
"company",
's.code_compta_fournisseur' =>
"company",
412 's.client' =>
"company",
's.fournisseur' =>
"company",
413 's.address' =>
"company",
's.zip' =>
"company",
's.town' =>
"company",
's.phone' =>
"company",
's.email' =>
"company",
414 't.code' =>
"company",
415 's.entity' =>
'company',
417 if (!isModEnabled(
"supplier_order") && !isModEnabled(
"supplier_invoice")) {
418 unset($this->export_fields_array[$r][
's.code_fournisseur']);
419 unset($this->export_entities_array[$r][
's.code_fournisseur']);
421 $keyforselect =
'socpeople';
422 $keyforelement =
'contact';
423 $keyforaliasextra =
'extra';
424 include DOL_DOCUMENT_ROOT.
'/core/extrafieldsinexport.inc.php';
425 $keyforselect =
'societe';
426 $keyforelement =
'company';
427 $keyforaliasextra =
'extrasoc';
428 include DOL_DOCUMENT_ROOT.
'/core/extrafieldsinexport.inc.php';
429 $this->export_sql_start[$r] =
'SELECT DISTINCT ';
430 $this->export_sql_end[$r] =
' FROM '.MAIN_DB_PREFIX.
'socpeople as c';
431 $this->export_sql_end[$r] .=
' LEFT JOIN '.MAIN_DB_PREFIX.
'societe as s ON c.fk_soc = s.rowid';
432 $this->export_sql_end[$r] .=
' LEFT JOIN '.MAIN_DB_PREFIX.
'societe_extrafields as extrasoc ON s.rowid = extrasoc.fk_object';
433 if (is_object($user) && !$user->hasRight(
'societe',
'client',
'voir')) {
434 $this->export_sql_end[$r] .=
' LEFT JOIN '.MAIN_DB_PREFIX.
'societe_commerciaux as sc ON sc.fk_soc = s.rowid';
436 $this->export_sql_end[$r] .=
' LEFT JOIN '.MAIN_DB_PREFIX.
'c_departements as d ON c.fk_departement = d.rowid';
437 $this->export_sql_end[$r] .=
' LEFT JOIN '.MAIN_DB_PREFIX.
'c_regions as r ON r.code_region = d.fk_region AND r.fk_pays = c.fk_pays';
438 $this->export_sql_end[$r] .=
' LEFT JOIN '.MAIN_DB_PREFIX.
'c_country as co ON c.fk_pays = co.rowid';
439 $this->export_sql_end[$r] .=
' LEFT JOIN '.MAIN_DB_PREFIX.
'socpeople_extrafields as extra ON extra.fk_object = c.rowid';
440 $this->export_sql_end[$r] .=
' LEFT JOIN '.MAIN_DB_PREFIX.
'c_typent as t ON s.fk_typent = t.id';
441 $this->export_sql_end[$r] .=
' WHERE c.entity IN ('.getEntity(
'contact').
')';
442 if (is_object($user) && !$user->hasRight(
'societe',
'client',
'voir')) {
443 $this->export_sql_end[$r] .=
' AND (sc.fk_user = '.((int) $user->id).
' ';
445 $subordinatesids = $user->getAllChildIds();
446 $this->export_sql_end[$r] .= count($subordinatesids) > 0 ?
' OR (sc.fk_user IN ('.$this->db->sanitize(implode(
',', $subordinatesids)).
')' :
'';
448 $this->export_sql_end[$r] .=
')';
453 $this->export_code[$r] = $this->rights_class.
'_'.$r;
454 $this->export_label[$r] =
'ExportDataset_company_3';
455 $this->export_icon[$r] =
'account';
456 $this->export_permission[$r] = array(array(
"societe",
"contact",
"export"), array(
"societe",
"thirdparty_paymentinformation_advance",
"write"));
457 $this->export_fields_array[$r] = array(
458 'b.rowid' =>
"IdPaymentMode",
459 'b.fk_soc' =>
"ThirdPartyName",
460 'b.label' =>
'Label',
462 'b.code_banque' =>
'Code banque',
463 'b.code_guichet' =>
'Code guichet',
464 'b.number' =>
'Number',
465 'b.cle_rib' =>
'Cle rib',
467 'b.iban_prefix' =>
'Iban prefix',
468 'b.domiciliation' =>
'Domiciliation',
469 'b.proprio' =>
'Proprio',
470 'b.owner_address' =>
'Owner address',
471 'b.default_rib' =>
'Default rib',
473 'b.date_rum' =>
'Date rum',
474 'b.frstrecur' =>
'Frstrecur',
476 'b.status' =>
"status",
477 'b.datec' =>
"DateCreation",
478 'b.tms' =>
"DateLastModification"
482 if (isModEnabled(
'multicompany')) {
483 $nbofallowedentities = count(explode(
',',
getEntity(
'societe')));
484 if ($nbofallowedentities > 1) {
485 $this->export_fields_array[$r][
's.entity'] =
'Entity';
489 $this->export_examplevalues_array[$r] = array();
490 $this->export_TypeFields_array[$r] = array(
492 's.entity' =>
"List:entity:label:rowid",
493 'b.rowid' =>
"Numeric",
496 'b.code_banque' =>
'Text',
497 'b.code_guichet' =>
'Text',
498 'b.number' =>
'Text',
499 'b.cle_rib' =>
'Text',
501 'b.iban_prefix' =>
'Text',
502 'b.domiciliation' =>
'Text',
503 'b.proprio' =>
'Text',
504 'b.owner_address' =>
'Text',
505 'b.default_rib' =>
'Boolean"',
507 'b.date_rum' =>
'Date',
508 'b.frstrecur' =>
'Text',
510 'b.status' =>
"Status",
514 $this->export_entities_array[$r] = array(
515 's.nom' =>
"company",
516 's.entity' =>
'company'
518 $this->export_sql_start[$r] =
'SELECT DISTINCT ';
519 $this->export_sql_end[$r] =
' FROM '.MAIN_DB_PREFIX.
'societe_rib as b';
520 $this->export_sql_end[$r] .=
' LEFT JOIN '.MAIN_DB_PREFIX.
'societe as s ON b.fk_soc = s.rowid';
521 if (is_object($user) && !$user->hasRight(
'societe',
'client',
'voir')) {
522 $this->export_sql_end[$r] .=
' LEFT JOIN '.MAIN_DB_PREFIX.
'societe_commerciaux as sc ON sc.fk_soc = s.rowid';
524 $this->export_sql_end[$r] .=
' WHERE s.entity IN ('.getEntity(
'societe').
')';
525 if (is_object($user) && !$user->hasRight(
'societe',
'client',
'voir')) {
526 $this->export_sql_end[$r] .=
' AND (sc.fk_user = '.((int) $user->id).
' ';
528 $subordinatesids = $user->getAllChildIds();
529 $this->export_sql_end[$r] .= count($subordinatesids) > 0 ?
' OR (sc.fk_user IN ('.$this->db->sanitize(implode(
',', $subordinatesids)).
')' :
'';
531 $this->export_sql_end[$r] .=
')';
541 $this->import_code[$r] = $this->rights_class.
'_'.$r;
542 $this->import_label[$r] =
'ImportDataset_company_1';
543 $this->import_icon[$r] =
'company';
544 $this->import_entities_array[$r] = array();
545 $this->import_tables_array[$r] = array(
546 's' => MAIN_DB_PREFIX.
'societe',
547 'extra' => MAIN_DB_PREFIX.
'societe_extrafields'
549 $this->import_fields_array[$r] = array(
550 's.nom' =>
"ThirdPartyName*",
551 's.name_alias' =>
"AliasNameShort",
552 's.parent' =>
"ParentCompany",
553 's.status' =>
"Status*",
554 's.code_client' =>
"CustomerCode",
555 's.code_fournisseur' =>
"SupplierCode",
556 's.code_compta' =>
"CustomerAccountancyCode",
557 's.code_compta_fournisseur' =>
"SupplierAccountancyCode",
558 's.address' =>
"Address",
561 's.fk_departement' =>
"StateCode",
562 's.fk_pays' =>
"CountryCode",
563 's.phone' =>
"Phone",
566 's.email' =>
"Email",
567 's.fk_effectif' =>
"Staff",
568 's.fk_typent' =>
"ThirdPartyType",
569 "s.fk_forme_juridique" =>
"JuridicalStatus",
570 's.siren' =>
"ProfId1",
571 's.siret' =>
"ProfId2",
572 's.ape' =>
"ProfId3",
573 's.idprof4' =>
"ProfId4",
574 's.idprof5' =>
"ProfId5",
575 's.idprof6' =>
"ProfId6",
576 's.tva_intra' =>
"VATIntraShort",
577 's.capital' =>
"Capital",
578 's.fk_stcomm' =>
'ProspectStatus',
579 's.note_private' =>
"NotePrivate",
580 's.note_public' =>
"NotePublic",
581 's.client' =>
"Customer*",
582 's.fournisseur' =>
"Supplier*",
583 's.fk_prospectlevel' =>
'ProspectLevel',
584 's.mode_reglement' =>
'PaymentTypeCustomer',
585 's.cond_reglement' =>
"PaymentTermsCustomer",
586 's.mode_reglement_supplier' =>
'PaymentTypeSupplier',
587 's.cond_reglement_supplier' =>
"PaymentTermsSupplier",
588 's.outstanding_limit' =>
'OutstandingBill',
589 's.fk_account' =>
'PaymentBankAccount',
590 's.fk_incoterms' =>
'IncotermLabel',
591 's.tva_assuj' =>
'VATIsUsed',
592 's.barcode' =>
'BarCode',
593 's.default_lang' =>
'DefaultLanguage',
594 's.canvas' =>
"Canvas",
595 's.datec' =>
"DateCreation",
596 's.fk_multicurrency' =>
'MulticurrencyUsed',
597 's.multicurrency_code' =>
'MulticurrencyCurrency'
600 $this->import_fields_array[$r][
's.price_level'] =
'PriceLevel';
603 $this->import_fields_array[$r] += array(
's.accountancy_code_sell' =>
'ProductAccountancySellCode',
's.accountancy_code_buy' =>
'ProductAccountancyBuyCode');
606 if (isModEnabled(
'socialnetworks')) {
607 $sql =
"SELECT code, label FROM ".MAIN_DB_PREFIX.
"c_socialnetworks WHERE active = 1";
608 $resql = $this->db->query($sql);
610 while ($obj = $this->db->fetch_object($resql)) {
611 $fieldname =
's.socialnetworks_'.$obj->code;
612 $fieldlabel = ucfirst($obj->label);
613 $this->import_fields_array[$r][$fieldname] = $fieldlabel;
618 $sql =
"SELECT name, label, fieldrequired FROM ".MAIN_DB_PREFIX.
"extrafields WHERE type <> 'separate' AND elementtype = 'societe' AND entity IN (0, ".$conf->entity.
")";
619 $resql = $this->db->query($sql);
621 while ($obj = $this->db->fetch_object($resql)) {
622 $fieldname =
'extra.'.$obj->name;
623 $fieldlabel = ucfirst($obj->label);
624 $this->import_fields_array[$r][$fieldname] = $fieldlabel.($obj->fieldrequired ?
'*' :
'');
628 $this->import_fieldshidden_array[$r] = array(
629 's.fk_user_creat' =>
'user->id',
630 'extra.fk_object' =>
'lastrowid-'.MAIN_DB_PREFIX.
'societe'
632 $this->import_convertvalue_array[$r] = array(
633 's.code_client' => array(
'rule' =>
'getcustomercodeifauto'),
634 's.code_fournisseur' => array(
'rule' =>
'getsuppliercodeifauto'),
635 's.code_compta' => array(
'rule' =>
'getcustomeraccountancycodeifauto'),
636 's.code_compta_fournisseur' => array(
'rule' =>
'getsupplieraccountancycodeifauto'),
637 's.fk_departement' => array(
638 'rule' =>
'fetchidfromcodeid',
639 'classfile' =>
'/core/class/cstate.class.php',
642 'dict' =>
'DictionaryStateCode'
644 's.fk_pays' => array(
645 'rule' =>
'fetchidfromcodeid',
646 'classfile' =>
'/core/class/ccountry.class.php',
647 'class' =>
'Ccountry',
649 'dict' =>
'DictionaryCountry'
651 's.fk_typent' => array(
652 'rule' =>
'fetchidfromcodeorlabel',
653 'classfile' =>
'/core/class/ctypent.class.php',
654 'class' =>
'Ctypent',
656 'dict' =>
'DictionaryCompanyType'
658 's.capital' => array(
'rule' =>
'numeric'),
660 'rule' =>
'fetchidfromref',
661 'file' =>
'/societe/class/societe.class.php',
662 'class' =>
'Societe',
664 'element' =>
'ThirdParty'
666 's.outstanding_limit' => array(
'rule' =>
'numeric'),
667 's.fk_account' => array(
668 'rule' =>
'fetchidfromcodeid',
669 'classfile' =>
'/compta/bank/class/account.class.php',
670 'class' =>
'Account',
672 'element' =>
'BankAccount'
674 's.fk_stcomm' => array(
675 'rule' =>
'fetchidfromcodeid',
676 'classfile' =>
'/core/class/cgenericdic.class.php',
677 'class' =>
'CGenericDic',
679 'dict' =>
'DictionaryProspectStatus',
680 'element' =>
'c_stcomm',
681 'table_element' =>
'c_stcomm'
703 $this->import_regex_array[$r] = array(
704 's.status' =>
'^[0|1]',
705 's.fk_typent' =>
'id@'.MAIN_DB_PREFIX.
'c_typent',
706 's.client' =>
'^[0|1|2|3]',
707 's.fournisseur' =>
'^[0|1]',
708 's.mode_reglement' =>
'id@'.MAIN_DB_PREFIX.
'c_paiement',
709 's.cond_reglement' =>
'rowid@'.MAIN_DB_PREFIX.
'c_payment_term',
710 's.mode_reglement_supplier' =>
'id@'.MAIN_DB_PREFIX.
'c_paiement',
711 's.cond_reglement_supplier' =>
'rowid@'.MAIN_DB_PREFIX.
'c_payment_term',
712 's.fk_incoterms' =>
'rowid@'.MAIN_DB_PREFIX.
'c_incoterms',
713 's.tva_assuj' =>
'^[0|1]',
714 's.fk_multicurrency' =>
'^[0|1]',
715 's.datec' =>
'^[0-9][0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9]( [0-9][0-9]:[0-9][0-9]:[0-9][0-9])?$',
716 's.multicurrency_code' =>
'code_iso@'.MAIN_DB_PREFIX.
'c_currencies'
719 $this->import_examplevalues_array[$r] = array(
720 's.nom' =>
"TPBigCompany",
721 's.name_alias' =>
"Alias for TPBigCompany",
722 's.parent' =>
"TPMotherCompany",
723 's.status' =>
"0 (closed) / 1 (active)",
724 's.code_client' =>
'eg. CU01-0001 / empty / "auto"',
725 's.code_fournisseur' =>
'eg. SU01-0001 / empty / "auto"',
726 's.code_compta' =>
"Code or empty to be auto-created",
727 's.code_compta_fournisseur' =>
"Code or empty to be auto-created",
728 's.address' =>
"61 Jump Street",
730 's.town' =>
"Bigtown",
731 's.fk_departement' =>
'matches field "code_departement" in table "'.MAIN_DB_PREFIX.
'c_departements"',
732 's.fk_pays' =>
'US/FR/DE etc. matches field "code" in table "'.MAIN_DB_PREFIX.
'c_country"',
733 's.phone' =>
"eg: +34123456789",
734 's.fax' =>
"eg. +34987654321",
735 's.url' =>
"e.g. https://www.mybigcompany.com",
736 's.email' =>
"e.g. test@mybigcompany.com",
737 's.fk_effectif' =>
"1/2/3/5: represents one of the five ranges of employees",
738 's.fk_typent' =>
'matches field "id" (1-9 etc.) OR "code" (TE_SMALL etc.) in table "'.MAIN_DB_PREFIX.
'c_typent"',
739 's.fk_forme_juridique' =>
'1/2/3 etc...matches field "code" in table "'.MAIN_DB_PREFIX.
'c_forme_juridique"',
746 's.tva_intra' =>
'VAT number e.g."FR0123456789"',
747 's.capital' =>
"10000",
748 's.fk_stcomm' =>
'-1/0/1/2 etc... matches field "id" in table "'.MAIN_DB_PREFIX.
'c_stcomm"',
749 's.note_private' =>
"Example of a PRIVATE note.",
750 's.note_public' =>
"Example of a PUBLIC note.",
751 's.client' =>
'0 (no customer no prospect) / 1 (customer) / 2 (prospect)/ 3 (customer and prospect)',
752 's.fournisseur' =>
'0 (not supplier) / 1 (supplier)',
753 's.fk_prospectlevel' =>
'eg. "PL_MEDIUM" matches field "code" in table "'.MAIN_DB_PREFIX.
'c_prospectlevel"',
754 's.mode_reglement' =>
'1/2/3...matches field "id" in table "'.MAIN_DB_PREFIX.
'c_paiement"',
755 's.cond_reglement' =>
'1/2/3...matches field "rowid" in table "'.MAIN_DB_PREFIX.
'c_payment_term"',
756 's.mode_reglement_supplier' =>
'1/2/3...matches field "id" in table "'.MAIN_DB_PREFIX.
'c_paiement"',
757 's.cond_reglement_supplier' =>
'1/2/3...matches field "rowid" in table "'.MAIN_DB_PREFIX.
'c_payment_term"',
758 's.outstanding_limit' =>
"5000",
759 's.fk_account' =>
"rowid or ref",
760 's.fk_incoterms' =>
'1/2/3...matches field "rowid" in table "'.MAIN_DB_PREFIX.
'c_incoterms"',
761 's.tva_assuj' =>
'0 (VAT not used) / 1 (VAT used)',
762 's.barcode' =>
'123456789',
763 's.default_lang' =>
'en_US / es_ES etc...matches a language directory in htdocs/langs/',
764 's.canvas' =>
"empty / a custom canvas form layout url e.g. mycanvas@mymodule",
765 's.datec' =>
'formatted as '.dol_print_date(
dol_now(),
'%Y-%m-%d'),
766 's.fk_multicurrency' =>
'0 (use system default currency) / 1 (use local currency)',
767 's.multicurrency_code' =>
'GBP/USD etc... matches field "code_iso" in table "'.MAIN_DB_PREFIX.
'c_currencies"',
768 's.accountancy_code_sell' =>
'707',
769 's.accountancy_code_buy' =>
'607',
771 $this->import_updatekeys_array[$r] = array(
772 's.nom' =>
'ThirdPartyName',
774 's.email' =>
'Email',
775 's.code_client' =>
'CustomerCode',
776 's.code_fournisseur' =>
'SupplierCode',
777 's.code_compta' =>
'CustomerAccountancyCode',
778 's.code_compta_fournisseur' =>
'SupplierAccountancyCode'
780 if (isModEnabled(
'socialnetworks')) {
781 $sql =
"SELECT code, label FROM ".MAIN_DB_PREFIX.
"c_socialnetworks WHERE active = 1";
782 $resql = $this->db->query($sql);
784 while ($obj = $this->db->fetch_object($resql)) {
785 $fieldname =
's.socialnetworks_'.$obj->code;
786 $fieldlabel = ucfirst($obj->label);
787 $this->import_updatekeys_array[$r][$fieldname] = $fieldlabel;
792 $langs->load(
"companies");
796 $this->import_updatekeys_array[$r][
's.siren'] =
'ProfId1'.(empty($mysoc->country_code) ?
'' : $mysoc->country_code);
799 $this->import_updatekeys_array[$r][
's.siret'] =
'ProfId2'.(empty($mysoc->country_code) ?
'' : $mysoc->country_code);
802 $this->import_updatekeys_array[$r][
's.ape'] =
'ProfId3'.(empty($mysoc->country_code) ?
'' : $mysoc->country_code);
806 if ($langs->trans(
'ProfId'.$i.(empty($mysoc->country_code) ?
'' : $mysoc->country_code)) !=
'-') {
807 $this->import_updatekeys_array[$r][
's.idprof'.$i] =
'ProfId'.$i.(empty($mysoc->country_code) ?
'' : $mysoc->country_code);
815 $this->import_code[$r] = $this->rights_class.
'_'.$r;
816 $this->import_label[$r] =
'ImportDataset_company_2';
817 $this->import_icon[$r] =
'contact';
818 $this->import_entities_array[$r] = array(
's.fk_soc' =>
'company');
819 $this->import_tables_array[$r] = array(
820 's' => MAIN_DB_PREFIX.
'socpeople',
821 'extra' => MAIN_DB_PREFIX.
'socpeople_extrafields'
823 $this->import_fields_array[$r] = array(
825 's.datec' =>
"DateCreation",
826 's.fk_soc' =>
'ThirdPartyName',
827 's.civility' =>
'UserTitle',
828 's.lastname' =>
"Lastname*",
829 's.firstname' =>
"Firstname",
830 's.address' =>
"Address",
833 's.fk_departement' =>
"StateCode",
834 's.fk_pays' =>
"CountryCode",
835 's.birthday' =>
"DateOfBirth",
836 's.poste' =>
"PostOrFunction",
837 's.phone' =>
"Phone",
838 's.phone_perso' =>
"PhonePerso",
839 's.phone_mobile' =>
"PhoneMobile",
841 's.email' =>
"Email",
842 's.note_private' =>
"NotePrivate",
843 's.note_public' =>
"NotePublic"
846 if (isModEnabled(
'socialnetworks')) {
847 $sql =
"SELECT code, label FROM ".MAIN_DB_PREFIX.
"c_socialnetworks WHERE active = 1";
848 $resql = $this->db->query($sql);
850 while ($obj = $this->db->fetch_object($resql)) {
851 $fieldname =
's.socialnetworks_'.$obj->code;
852 $fieldlabel = ucfirst($obj->label);
853 $this->import_fields_array[$r][$fieldname] = $fieldlabel;
858 $sql =
"SELECT name, label, fieldrequired FROM ".MAIN_DB_PREFIX.
"extrafields WHERE type <> 'separate' AND elementtype = 'socpeople' AND entity IN (0, ".$conf->entity.
")";
859 $resql = $this->db->query($sql);
861 while ($obj = $this->db->fetch_object($resql)) {
862 $fieldname =
'extra.'.$obj->name;
863 $fieldlabel = ucfirst($obj->label);
864 $this->import_fields_array[$r][$fieldname] = $fieldlabel.($obj->fieldrequired ?
'*' :
'');
868 $this->import_fieldshidden_array[$r] = array(
869 's.fk_user_creat' =>
'user->id',
870 'extra.fk_object' =>
'lastrowid-'.MAIN_DB_PREFIX.
'socpeople'
872 $this->import_convertvalue_array[$r] = array(
874 'rule' =>
'fetchidfromref',
875 'file' =>
'/societe/class/societe.class.php',
876 'class' =>
'Societe',
878 'element' =>
'ThirdParty'
880 's.fk_departement' => array(
881 'rule' =>
'fetchidfromcodeid',
882 'classfile' =>
'/core/class/cstate.class.php',
885 'dict' =>
'DictionaryCanton'
887 's.fk_pays' => array(
888 'rule' =>
'fetchidfromcodeid',
889 'classfile' =>
'/core/class/ccountry.class.php',
890 'class' =>
'Ccountry',
892 'dict' =>
'DictionaryCountry'
896 $this->import_regex_array[$r] = array(
897 's.birthday' =>
'^[0-9][0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9]$',
898 's.datec' =>
'^[0-9][0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9]( [0-9][0-9]:[0-9][0-9]:[0-9][0-9])?$'
900 $this->import_examplevalues_array[$r] = array(
903 's.fk_soc' =>
'Third Party name eg. TPBigCompany',
904 's.civility' =>
'Title of civility eg: MR...matches field "code" in table "'.MAIN_DB_PREFIX.
'c_civility"',
905 's.lastname' =>
"lastname or label",
906 's.firstname' =>
'John',
907 's.address' =>
'61 Jump street',
909 's.town' =>
'Bigtown',
910 's.fk_departement' =>
'matches field "code_departement" in table "'.MAIN_DB_PREFIX.
'c_departements"',
911 's.fk_pays' =>
'US/FR/DE etc. matches field "code" in table "'.MAIN_DB_PREFIX.
'c_country"',
912 's.birthday' =>
'formatted as '.dol_print_date(
dol_now(),
'%Y-%m-%d'),
913 's.poste' =>
"Director",
914 's.phone' =>
"5551122",
915 's.phone_perso' =>
"5551133",
916 's.phone_mobile' =>
"5551144",
917 's.fax' =>
"5551155",
918 's.email' =>
"johnsmith@email.com",
919 's.note_private' =>
"My private note",
920 's.note_public' =>
"My public note"
922 $this->import_updatekeys_array[$r] = array(
924 's.lastname' =>
"Lastname",
926 if (isModEnabled(
'socialnetworks')) {
927 $sql =
"SELECT code, label FROM ".MAIN_DB_PREFIX.
"c_socialnetworks WHERE active = 1";
928 $resql = $this->db->query($sql);
930 while ($obj = $this->db->fetch_object($resql)) {
931 $fieldname =
's.socialnetworks_'.$obj->code;
932 $fieldlabel = ucfirst($obj->label);
933 $this->import_updatekeys_array[$r][$fieldname] = $fieldlabel;
940 $this->import_code[$r] = $this->rights_class.
'_'.$r;
941 $this->import_label[$r] =
"ImportDataset_company_3";
942 $this->import_icon[$r] =
'company';
943 $this->import_entities_array[$r] = array();
944 $this->import_tables_array[$r] = array(
'sr' => MAIN_DB_PREFIX.
'societe_rib');
945 $this->import_fields_array[$r] = array(
946 'sr.label' =>
"Label*",
947 'sr.fk_soc' =>
"ThirdPartyName*",
948 'sr.datec' =>
"DateCreation*",
950 'sr.code_banque' =>
"BankCode",
951 'sr.code_guichet' =>
"DeskCode",
952 'sr.number' =>
"BankAccountNumber",
953 'sr.cle_rib' =>
"BankAccountNumberKey",
955 'sr.iban_prefix' =>
"IBAN",
956 'sr.domiciliation' =>
"BankAccountDomiciliation",
957 'sr.proprio' =>
"BankAccountOwner",
958 'sr.owner_address' =>
"BankAccountOwnerAddress",
959 'sr.default_rib' =>
'Default',
961 'sr.frstrecur' =>
"WithdrawMode",
962 'sr.type' =>
"Type ban is default",
965 $this->import_convertvalue_array[$r] = array(
966 'sr.fk_soc' => array(
967 'rule' =>
'fetchidfromref',
968 'classfile' =>
'/societe/class/societe.class.php',
969 'class' =>
'Societe',
971 'element' =>
'ThirdParty'
974 $this->import_examplevalues_array[$r] = array(
975 'sr.label' =>
'eg. "account1"',
976 'sr.fk_soc' =>
'eg. "TPBigCompany"',
977 'sr.datec' =>
'date used for creating direct debit UMR formatted as '.
dol_print_date(
981 'sr.bank' =>
'bank name eg: "ING-Direct"',
982 'sr.code_banque' =>
'account sort code (GB)/Routing number (US) eg. "8456"',
983 'sr.code_guichet' =>
"bank code for office/branch",
984 'sr.number' =>
'account number eg. "3333333333"',
985 'sr.cle_rib' =>
'account checksum/control digits (if used) eg. "22"',
986 'sr.bic' =>
'bank identifier eg. "USHINGMMXXX"',
987 'sr.iban_prefix' =>
'complete account IBAN eg. "GB78CPBK08925068637123"',
988 'sr.domiciliation' =>
'bank branch address eg. "PARIS"',
989 'sr.proprio' =>
'name on the bank account',
990 'sr.owner_address' =>
'address of account holder',
991 'sr.default_rib' =>
'1 (default account) / 0 (not default)',
992 'sr.rum' =>
'RUM code',
993 'sr.frstrecur' =>
'FRST',
999 $this->import_code[$r] = $this->rights_class.
'_'.$r;
1000 $this->import_label[$r] =
"ImportDataset_company_4";
1001 $this->import_icon[$r] =
'company';
1002 $this->import_entities_array[$r] = array(
'sr.fk_user' =>
'user');
1003 $this->import_tables_array[$r] = array(
'sr' => MAIN_DB_PREFIX.
'societe_commerciaux');
1004 $this->import_fields_array[$r] = array(
'sr.fk_soc' =>
"ThirdPartyName*",
'sr.fk_user' =>
"User*");
1006 $this->import_convertvalue_array[$r] = array(
1007 'sr.fk_soc' => array(
'rule' =>
'fetchidfromref',
'classfile' =>
'/societe/class/societe.class.php',
'class' =>
'Societe',
'method' =>
'fetch',
'element' =>
'ThirdParty'),
1008 'sr.fk_user' => array(
'rule' =>
'fetchidfromref',
'classfile' =>
'/user/class/user.class.php',
'class' =>
'User',
'method' =>
'fetch',
'element' =>
'User')
1010 $this->import_examplevalues_array[$r] = array(
'sr.fk_soc' =>
"MyBigCompany",
'sr.fk_user' =>
"login");