dolibarr 20.0.0
modSociete.class.php
Go to the documentation of this file.
1<?php
2/* Copyright (C) 2003-2005 Rodolphe Quiedeville <rodolphe@quiedeville.org>
3 * Copyright (C) 2004-2013 Laurent Destailleur <eldy@users.sourceforge.net>
4 * Copyright (C) 2004 Sebastien Di Cintio <sdicintio@ressource-toi.org>
5 * Copyright (C) 2004 Benoit Mortier <benoit.mortier@opensides.be>
6 * Copyright (C) 2005-2013 Regis Houssin <regis.houssin@inodbox.com>
7 * Copyright (C) 2012-2014 Juanjo Menent <jmenent@2byte.es>
8 * Copyright (C) 2022 Ferran Marcet <fmarcet@2byte.es>
9 * Copyright (C) 2024 MDW <mdeweerd@users.noreply.github.com>
10 *
11 * This program is free software; you can redistribute it and/or modify
12 * it under the terms of the GNU General Public License as published by
13 * the Free Software Foundation; either version 3 of the License, or
14 * (at your option) any later version.
15 *
16 * This program is distributed in the hope that it will be useful,
17 * but WITHOUT ANY WARRANTY; without even the implied warranty of
18 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
19 * GNU General Public License for more details.
20 *
21 * You should have received a copy of the GNU General Public License
22 * along with this program. If not, see <https://www.gnu.org/licenses/>.
23 */
24
32include_once DOL_DOCUMENT_ROOT.'/core/modules/DolibarrModules.class.php';
33
34
39{
45 public function __construct($db)
46 {
47 global $conf, $user, $mysoc, $langs;
48
49 $this->db = $db;
50 $this->numero = 1;
51
52 $this->family = "crm";
53 $this->module_position = '09';
54 // Module label (no space allowed), used if translation string 'ModuleXXXName' not found (where XXX is value of numeric property 'numero' of module)
55 $this->name = preg_replace('/^mod/i', '', get_class($this));
56 $this->description = "Gestion des sociétés et contacts";
57
58 // Possible values for version are: 'development', 'experimental', 'dolibarr' or version
59 $this->version = 'dolibarr';
60
61 $this->const_name = 'MAIN_MODULE_'.strtoupper($this->name);
62 $this->config_page_url = array("societe.php@societe");
63 // Name of image file used for this module.
64 $this->picto = 'company';
65
66 // Data directories to create when module is enabled
67 $this->dirs = array("/societe/temp");
68
69 // Dependencies
70 $this->hidden = false; // A condition to hide module
71 $this->depends = array(); // List of module class names as string that must be enabled if this module is enabled
72 $this->requiredby = array("modExpedition", "modFacture", "modFournisseur", "modFicheinter", "modPropale", "modContrat", "modCommande"); // List of module ids to disable if this one is disabled
73 $this->conflictwith = array(); // List of module class names as string this module is in conflict with
74 $this->phpmin = array(7, 0); // Minimum version of PHP required by module
75 $this->langfiles = array("companies", 'bills', "compta", "admin", "banks");
76
77 // Constants
78 $this->const = array();
79 $r = 0;
80
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;
86 $r++;
87
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;
93 $r++;
94
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;
100 $r++;
101
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;
107 $r++;
108
109 /*
110 $this->const[$r][0] = "COMPANY_HIDE_INACTIVE_IN_COMBOBOX";
111 $this->const[$r][1] = "chaine";
112 $this->const[$r][2] = "0";
113 $this->const[$r][3] = "hide thirdparty customer inative in combobox";
114 $this->const[$r][4] = 1;
115 $r++;
116 */
117
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;
123 $r++;
124
125 // Boxes
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)'),
132 );
133
134 // Permissions
135 $this->rights = array();
136 $this->rights_class = 'societe';
137 $r = 0;
138
139 $r++;
140 $this->rights[$r][0] = 121; // id de la permission
141 $this->rights[$r][1] = 'Read third parties'; // libelle de la permission
142 $this->rights[$r][2] = 'r'; // type de la permission (deprecated)
143 $this->rights[$r][3] = 0; // La permission est-elle une permission par default
144 $this->rights[$r][4] = 'lire';
145
146 /*$r++;
147 $this->rights[$r][0] = 241;
148 $this->rights[$r][1] = 'Read thirdparties customers';
149 $this->rights[$r][2] = 'r';
150 $this->rights[$r][3] = 0;
151 $this->rights[$r][4] = 'thirdparty_customer_advance'; // Visible if option MAIN_USE_ADVANCED_PERMS is on
152 $this->rights[$r][5] = 'read';
153
154 $r++;
155 $this->rights[$r][0] = 242;
156 $this->rights[$r][1] = 'Read thirdparties suppliers';
157 $this->rights[$r][2] = 'r';
158 $this->rights[$r][3] = 0;
159 $this->rights[$r][4] = 'thirdparty_supplier_advance'; // Visible if option MAIN_USE_ADVANCED_PERMS is on
160 $this->rights[$r][5] = 'read';
161 */
162
163 $r++;
164 $this->rights[$r][0] = 122; // id de la permission
165 $this->rights[$r][1] = 'Create and update third parties'; // libelle de la permission
166 $this->rights[$r][2] = 'w'; // type de la permission (deprecated)
167 $this->rights[$r][3] = 0; // La permission est-elle une permission par default
168 $this->rights[$r][4] = 'creer';
169
170 /* $r++;
171 $this->rights[$r][0] = 251;
172 $this->rights[$r][1] = 'Create thirdparties customers';
173 $this->rights[$r][2] = 'r';
174 $this->rights[$r][3] = 0;
175 $this->rights[$r][4] = 'thirdparty_customer_advance'; // Visible if option MAIN_USE_ADVANCED_PERMS is on
176 $this->rights[$r][5] = 'read';
177
178 $r++;
179 $this->rights[$r][0] = 252;
180 $this->rights[$r][1] = 'Create thirdparties suppliers';
181 $this->rights[$r][2] = 'r';
182 $this->rights[$r][3] = 0;
183 $this->rights[$r][4] = 'thirdparty_supplier_advance'; // Visible if option MAIN_USE_ADVANCED_PERMS is on
184 $this->rights[$r][5] = 'read';
185 */
186
187 $r++;
188 $this->rights[$r][0] = 125; // id de la permission
189 $this->rights[$r][1] = 'Delete third parties'; // libelle de la permission
190 $this->rights[$r][2] = 'd'; // type de la permission (deprecated)
191 $this->rights[$r][3] = 0; // La permission est-elle une permission par default
192 $this->rights[$r][4] = 'supprimer';
193
194 $r++;
195 $this->rights[$r][0] = 126; // id de la permission
196 $this->rights[$r][1] = 'Export third parties'; // libelle de la permission
197 $this->rights[$r][2] = 'r'; // type de la permission (deprecated)
198 $this->rights[$r][3] = 0; // La permission est-elle une permission par default
199 $this->rights[$r][4] = 'export';
200
201 $r++;
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'; // Visible if option MAIN_USE_ADVANCED_PERMS is on
206 $this->rights[$r][5] = 'write';
207
208 // 262 : Restrict access to sales representative
209 $r++;
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';
216
217 /*
218 $r++;
219 $this->rights[$r][0] = 263;
220 $this->rights[$r][1] = 'Read all third parties (without their objects) by internal users (otherwise only if commercial contact). Not effective for external users (limited to themselves).';
221 $this->rights[$r][2] = 'r';
222 $this->rights[$r][3] = 0;
223 $this->rights[$r][4] = 'client';
224 $this->rights[$r][5] = 'readallthirdparties_advance';
225 */
226
227 $r++;
228 $this->rights[$r][0] = 281; // id de la permission
229 $this->rights[$r][1] = 'Read contacts'; // libelle de la permission
230 $this->rights[$r][2] = 'r'; // type de la permission (deprecated)
231 $this->rights[$r][3] = 0; // La permission est-elle une permission par default
232 $this->rights[$r][4] = 'contact';
233 $this->rights[$r][5] = 'lire';
234
235 $r++;
236 $this->rights[$r][0] = 282; // id de la permission
237 $this->rights[$r][1] = 'Create and update contact'; // libelle de la permission
238 $this->rights[$r][2] = 'w'; // type de la permission (deprecated)
239 $this->rights[$r][3] = 0; // La permission est-elle une permission par default
240 $this->rights[$r][4] = 'contact';
241 $this->rights[$r][5] = 'creer';
242
243 $r++;
244 $this->rights[$r][0] = 283; // id de la permission
245 $this->rights[$r][1] = 'Delete contacts'; // libelle de la permission
246 $this->rights[$r][2] = 'd'; // type de la permission (deprecated)
247 $this->rights[$r][3] = 0; // La permission est-elle une permission par default
248 $this->rights[$r][4] = 'contact';
249 $this->rights[$r][5] = 'supprimer';
250
251 $r++;
252 $this->rights[$r][0] = 286; // id de la permission
253 $this->rights[$r][1] = 'Export contacts'; // libelle de la permission
254 $this->rights[$r][2] = 'd'; // type de la permission (deprecated)
255 $this->rights[$r][3] = 0; // La permission est-elle une permission par default
256 $this->rights[$r][4] = 'contact';
257 $this->rights[$r][5] = 'export';
258
259
260 // Menus
261 //-------
262 $this->menu = 1; // This module add menu entries. They are coded into menu manager.
263
264
265 // Exports
266 //--------
267 $r = 0;
268
269 // Export list of third parties and attributes
270 $r++;
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'
285 );
286 if (getDolGlobalString('SOCIETE_USEPREFIX')) {
287 $this->export_fields_array[$r]['s.prefix'] = 'Prefix';
288 }
289 if (getDolGlobalString('PRODUIT_MULTIPRICES')) {
290 $this->export_fields_array[$r]['s.price_level'] = 'PriceLevel';
291 }
292 if (getDolGlobalString('ACCOUNTANCY_USE_PRODUCT_ACCOUNT_ON_THIRDPARTY')) {
293 $this->export_fields_array[$r] += array('s.accountancy_code_sell' => 'ProductAccountancySellCode', 's.accountancy_code_buy' => 'ProductAccountancyBuyCode');
294 }
295 // Add multicompany field
296 if (getDolGlobalString('MULTICOMPANY_ENTITY_IN_EXPORT_IF_SHARED')) {
297 $nbofallowedentities = count(explode(',', getEntity('societe'))); // If project are shared, nb will be > 1
298 if (isModEnabled('multicompany') && $nbofallowedentities > 1) {
299 $this->export_fields_array[$r] += array('s.entity' => 'Entity');
300 }
301 }
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');
307
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'
329 );
330
331 $this->export_entities_array[$r] = array( // We define here only fields that use another picto
332 'u.login' => 'user',
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).' ';
355 if (getDolGlobalString('SOCIETE_EXPORT_SUBORDINATES_CHILDS')) {
356 $subordinatesids = $user->getAllChildIds();
357 $this->export_sql_end[$r] .= count($subordinatesids) > 0 ? ' OR (sc.fk_user IN ('.$this->db->sanitize(implode(',', $subordinatesids)).')' : '';
358 }
359 $this->export_sql_end[$r] .= ')';
360 }
361
362 // Export list of contacts and attributes
363 $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"
380 );
381 // Add multicompany field
382 if (getDolGlobalString('MULTICOMPANY_ENTITY_IN_EXPORT_IF_SHARED')) {
383 if (isModEnabled('multicompany')) {
384 $nbofallowedentities = count(explode(',', getEntity('contact')));
385 if ($nbofallowedentities > 1) {
386 $this->export_fields_array[$r]['c.entity'] = 'Entity';
387 }
388
389 $nbofallowedentities = count(explode(',', getEntity('societe')));
390 if ($nbofallowedentities > 1) {
391 $this->export_fields_array[$r]['s.entity'] = 'Entity';
392 }
393 }
394 }
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',
408 );
409 $this->export_entities_array[$r] = array( // We define here only fields that use another picto
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 's.note_private' => 'company', 's.note_public' => "company",
415 't.code' => "company",
416 's.entity' => 'company',
417 ); // We define here only fields that use another picto
418 if (!isModEnabled("supplier_order") && !isModEnabled("supplier_invoice")) {
419 unset($this->export_fields_array[$r]['s.code_fournisseur']);
420 unset($this->export_entities_array[$r]['s.code_fournisseur']);
421 }
422 $keyforselect = 'socpeople';
423 $keyforelement = 'contact';
424 $keyforaliasextra = 'extra';
425 include DOL_DOCUMENT_ROOT.'/core/extrafieldsinexport.inc.php';
426 $keyforselect = 'societe';
427 $keyforelement = 'company';
428 $keyforaliasextra = 'extrasoc';
429 include DOL_DOCUMENT_ROOT.'/core/extrafieldsinexport.inc.php';
430 $this->export_sql_start[$r] = 'SELECT DISTINCT ';
431 $this->export_sql_end[$r] = ' FROM '.MAIN_DB_PREFIX.'socpeople as c';
432 $this->export_sql_end[$r] .= ' LEFT JOIN '.MAIN_DB_PREFIX.'societe as s ON c.fk_soc = s.rowid';
433 $this->export_sql_end[$r] .= ' LEFT JOIN '.MAIN_DB_PREFIX.'societe_extrafields as extrasoc ON s.rowid = extrasoc.fk_object';
434 if (is_object($user) && !$user->hasRight('societe', 'client', 'voir')) {
435 $this->export_sql_end[$r] .= ' LEFT JOIN '.MAIN_DB_PREFIX.'societe_commerciaux as sc ON sc.fk_soc = s.rowid';
436 }
437 $this->export_sql_end[$r] .= ' LEFT JOIN '.MAIN_DB_PREFIX.'c_departements as d ON c.fk_departement = d.rowid';
438 $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';
439 $this->export_sql_end[$r] .= ' LEFT JOIN '.MAIN_DB_PREFIX.'c_country as co ON c.fk_pays = co.rowid';
440 $this->export_sql_end[$r] .= ' LEFT JOIN '.MAIN_DB_PREFIX.'socpeople_extrafields as extra ON extra.fk_object = c.rowid';
441 $this->export_sql_end[$r] .= ' LEFT JOIN '.MAIN_DB_PREFIX.'c_typent as t ON s.fk_typent = t.id';
442 $this->export_sql_end[$r] .= ' WHERE c.entity IN ('.getEntity('contact').')';
443 if (is_object($user) && !$user->hasRight('societe', 'client', 'voir')) {
444 $this->export_sql_end[$r] .= ' AND (sc.fk_user = '.((int) $user->id).' ';
445 if (getDolGlobalString('SOCIETE_EXPORT_SUBORDINATES_CHILDS')) {
446 $subordinatesids = $user->getAllChildIds();
447 $this->export_sql_end[$r] .= count($subordinatesids) > 0 ? ' OR (sc.fk_user IN ('.$this->db->sanitize(implode(',', $subordinatesids)).')' : '';
448 }
449 $this->export_sql_end[$r] .= ')';
450 }
451
452
453 // Imports
454 //--------
455 $r = 0;
456
457 // Import list of third parties and attributes
458
459 $r++;
460 $this->import_code[$r] = $this->rights_class.'_'.$r;
461 $this->import_label[$r] = 'ImportDataset_company_1';
462 $this->import_icon[$r] = 'company';
463 $this->import_entities_array[$r] = array(); // We define here only fields that use a different icon from the one defined in import_icon
464 $this->import_tables_array[$r] = array(
465 's' => MAIN_DB_PREFIX.'societe',
466 'extra' => MAIN_DB_PREFIX.'societe_extrafields'
467 ); // List of tables to insert into (insert done in same order)
468 $this->import_fields_array[$r] = array(//field order as per structure of table llx_societe
469 's.nom' => "ThirdPartyName*",
470 's.name_alias' => "AliasNameShort",
471 's.parent' => "ParentCompany",
472 's.status' => "Status*",
473 's.code_client' => "CustomerCode",
474 's.code_fournisseur' => "SupplierCode",
475 's.code_compta' => "CustomerAccountancyCode",
476 's.code_compta_fournisseur' => "SupplierAccountancyCode",
477 's.address' => "Address",
478 's.zip' => "Zip",
479 's.town' => "Town",
480 's.fk_departement' => "StateCode",
481 's.fk_pays' => "CountryCode",
482 's.phone' => "Phone",
483 's.fax' => "Fax",
484 's.url' => "Url",
485 's.email' => "Email",
486 's.fk_effectif' => "Staff",
487 's.fk_typent' => "ThirdPartyType",
488 "s.fk_forme_juridique" => "JuridicalStatus",
489 's.siren' => "ProfId1",
490 's.siret' => "ProfId2",
491 's.ape' => "ProfId3",
492 's.idprof4' => "ProfId4",
493 's.idprof5' => "ProfId5",
494 's.idprof6' => "ProfId6",
495 's.tva_intra' => "VATIntraShort",
496 's.capital' => "Capital",
497 's.fk_stcomm' => 'ProspectStatus',
498 's.note_private' => "NotePrivate",
499 's.note_public' => "NotePublic",
500 's.client' => "Customer*",
501 's.fournisseur' => "Supplier*",
502 's.fk_prospectlevel' => 'ProspectLevel',
503 's.mode_reglement' => 'PaymentTypeCustomer',
504 's.cond_reglement' => "PaymentTermsCustomer",
505 's.mode_reglement_supplier' => 'PaymentTypeSupplier',
506 's.cond_reglement_supplier' => "PaymentTermsSupplier",
507 's.outstanding_limit' => 'OutstandingBill',
508 's.fk_account' => 'PaymentBankAccount',
509 's.fk_incoterms' => 'IncotermLabel',
510 's.tva_assuj' => 'VATIsUsed',
511 's.barcode' => 'BarCode',
512 's.default_lang' => 'DefaultLanguage',
513 's.canvas' => "Canvas",
514 's.datec' => "DateCreation",
515 's.fk_multicurrency' => 'MulticurrencyUsed',
516 's.multicurrency_code' => 'MulticurrencyCurrency'
517 );
518 if (getDolGlobalString('PRODUIT_MULTIPRICES')) {
519 $this->import_fields_array[$r]['s.price_level'] = 'PriceLevel';
520 }
521 if (getDolGlobalString('ACCOUNTANCY_USE_PRODUCT_ACCOUNT_ON_THIRDPARTY')) {
522 $this->import_fields_array[$r] += array('s.accountancy_code_sell' => 'ProductAccountancySellCode', 's.accountancy_code_buy' => 'ProductAccountancyBuyCode');
523 }
524 // Add social networks fields
525 if (isModEnabled('socialnetworks')) {
526 $sql = "SELECT code, label FROM ".MAIN_DB_PREFIX."c_socialnetworks WHERE active = 1";
527 $resql = $this->db->query($sql);
528 if ($resql) {
529 while ($obj = $this->db->fetch_object($resql)) {
530 $fieldname = 's.socialnetworks_'.$obj->code;
531 $fieldlabel = ucfirst($obj->label);
532 $this->import_fields_array[$r][$fieldname] = $fieldlabel;
533 }
534 }
535 }
536 // Add extra fields
537 $sql = "SELECT name, label, fieldrequired FROM ".MAIN_DB_PREFIX."extrafields WHERE type <> 'separate' AND elementtype = 'societe' AND entity IN (0, ".$conf->entity.")";
538 $resql = $this->db->query($sql);
539 if ($resql) { // This can fail when class is used on old database (during migration for example)
540 while ($obj = $this->db->fetch_object($resql)) {
541 $fieldname = 'extra.'.$obj->name;
542 $fieldlabel = ucfirst($obj->label);
543 $this->import_fields_array[$r][$fieldname] = $fieldlabel.($obj->fieldrequired ? '*' : '');
544 }
545 }
546 // End add extra fields
547 $this->import_fieldshidden_array[$r] = array(
548 's.fk_user_creat' => 'user->id',
549 'extra.fk_object' => 'lastrowid-'.MAIN_DB_PREFIX.'societe'
550 ); // aliastable.field => ('user->id' or 'lastrowid-'.tableparent)
551 $this->import_convertvalue_array[$r] = array(//field order as per structure of table llx_societe
552 's.code_client' => array('rule' => 'getcustomercodeifauto'),
553 's.code_fournisseur' => array('rule' => 'getsuppliercodeifauto'),
554 's.code_compta' => array('rule' => 'getcustomeraccountancycodeifauto'),
555 's.code_compta_fournisseur' => array('rule' => 'getsupplieraccountancycodeifauto'),
556 's.fk_departement' => array(
557 'rule' => 'fetchidfromcodeid',
558 'classfile' => '/core/class/cstate.class.php',
559 'class' => 'Cstate',
560 'method' => 'fetch',
561 'dict' => 'DictionaryStateCode'
562 ),
563 's.fk_pays' => array(
564 'rule' => 'fetchidfromcodeid',
565 'classfile' => '/core/class/ccountry.class.php',
566 'class' => 'Ccountry',
567 'method' => 'fetch',
568 'dict' => 'DictionaryCountry'
569 ),
570 's.fk_typent' => array(
571 'rule' => 'fetchidfromcodeorlabel',
572 'classfile' => '/core/class/ctypent.class.php',
573 'class' => 'Ctypent',
574 'method' => 'fetch',
575 'dict' => 'DictionaryCompanyType'
576 ),
577 's.capital' => array('rule' => 'numeric'),
578 's.parent' => array(
579 'rule' => 'fetchidfromref',
580 'file' => '/societe/class/societe.class.php',
581 'class' => 'Societe',
582 'method' => 'fetch',
583 'element' => 'ThirdParty'
584 ),
585 's.outstanding_limit' => array('rule' => 'numeric'),
586 's.fk_account' => array(
587 'rule' => 'fetchidfromcodeid',
588 'classfile' => '/compta/bank/class/account.class.php',
589 'class' => 'Account',
590 'method' => 'fetch',
591 'element' => 'BankAccount'
592 ),
593 's.fk_stcomm' => array(
594 'rule' => 'fetchidfromcodeid',
595 'classfile' => '/core/class/cgenericdic.class.php',
596 'class' => 'CGenericDic',
597 'method' => 'fetch',
598 'dict' => 'DictionaryProspectStatus',
599 'element' => 'c_stcomm',
600 'table_element' => 'c_stcomm'
601 ),
602 /*
603 's.fk_prospectlevel' => array(
604 'rule' => 'fetchidfromcodeid',
605 'classfile' => '/core/class/cgenericdic.class.php',
606 'class' => 'CGenericDic',
607 'method' => 'fetch',
608 'dict' => 'DictionaryProspectLevel',
609 'element' => 'c_prospectlevel',
610 'table_element' => 'c_prospectlevel'
611 ),*/
612 // TODO
613 // 's.fk_incoterms' => array(
614 // 'rule' => 'fetchidfromcodeid',
615 // 'classfile' => '/core/class/cincoterm.class.php',
616 // 'class' => 'Cincoterm',
617 // 'method' => 'fetch',
618 // 'dict' => 'IncotermLabel'
619 // )
620 );
621 //$this->import_convertvalue_array[$r]=array('s.fk_soc'=>array('rule'=>'lastrowid',table='t');
622 $this->import_regex_array[$r] = array(//field order as per structure of table llx_societe
623 's.status' => '^[0|1]',
624 's.fk_typent' => 'id@'.MAIN_DB_PREFIX.'c_typent',
625 's.client' => '^[0|1|2|3]',
626 's.fournisseur' => '^[0|1]',
627 's.mode_reglement' => 'id@'.MAIN_DB_PREFIX.'c_paiement',
628 's.cond_reglement' => 'rowid@'.MAIN_DB_PREFIX.'c_payment_term',
629 's.mode_reglement_supplier' => 'id@'.MAIN_DB_PREFIX.'c_paiement',
630 's.cond_reglement_supplier' => 'rowid@'.MAIN_DB_PREFIX.'c_payment_term',
631 's.fk_incoterms' => 'rowid@'.MAIN_DB_PREFIX.'c_incoterms',
632 's.tva_assuj' => '^[0|1]',
633 's.fk_multicurrency' => '^[0|1]',
634 '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])?$',
635 's.multicurrency_code' => 'code_iso@'.MAIN_DB_PREFIX.'c_currencies'
636 );
637
638 $this->import_examplevalues_array[$r] = array(//field order as per structure of table llx_societe
639 's.nom' => "TPBigCompany",
640 's.name_alias' => "Alias for TPBigCompany",
641 's.parent' => "TPMotherCompany",
642 's.status' => "0 (closed) / 1 (active)",
643 's.code_client' => 'eg. CU01-0001 / empty / "auto"',
644 's.code_fournisseur' => 'eg. SU01-0001 / empty / "auto"',
645 's.code_compta' => "Code or empty to be auto-created",
646 's.code_compta_fournisseur' => "Code or empty to be auto-created",
647 's.address' => "61 Jump Street",
648 's.zip' => "123456",
649 's.town' => "Bigtown",
650 's.fk_departement' => 'matches field "code_departement" in table "'.MAIN_DB_PREFIX.'c_departements"',
651 's.fk_pays' => 'US/FR/DE etc. matches field "code" in table "'.MAIN_DB_PREFIX.'c_country"',
652 's.phone' => "eg: +34123456789",
653 's.fax' => "eg. +34987654321",
654 's.url' => "e.g. https://www.mybigcompany.com",
655 's.email' => "e.g. test@mybigcompany.com",
656 's.fk_effectif' => "1/2/3/5: represents one of the five ranges of employees",
657 's.fk_typent' => 'matches field "id" (1-9 etc.) OR "code" (TE_SMALL etc.) in table "'.MAIN_DB_PREFIX.'c_typent"',
658 's.fk_forme_juridique' => '1/2/3 etc...matches field "code" in table "'.MAIN_DB_PREFIX.'c_forme_juridique"',
659 's.siret' => "",
660 's.siren' => "",
661 's.ape' => "",
662 's.idprof4' => "",
663 's.idprof5' => "",
664 's.idprof6' => "",
665 's.tva_intra' => 'VAT number e.g."FR0123456789"',
666 's.capital' => "10000",
667 's.fk_stcomm' => '-1/0/1/2 etc... matches field "id" in table "'.MAIN_DB_PREFIX.'c_stcomm"',
668 's.note_private' => "Example of a PRIVATE note.",
669 's.note_public' => "Example of a PUBLIC note.",
670 's.client' => '0 (no customer no prospect) / 1 (customer) / 2 (prospect)/ 3 (customer and prospect)',
671 's.fournisseur' => '0 (not supplier) / 1 (supplier)',
672 's.fk_prospectlevel' => 'eg. "PL_MEDIUM" matches field "code" in table "'.MAIN_DB_PREFIX.'c_prospectlevel"',
673 's.mode_reglement' => '1/2/3...matches field "id" in table "'.MAIN_DB_PREFIX.'c_paiement"',
674 's.cond_reglement' => '1/2/3...matches field "rowid" in table "'.MAIN_DB_PREFIX.'c_payment_term"',
675 's.mode_reglement_supplier' => '1/2/3...matches field "id" in table "'.MAIN_DB_PREFIX.'c_paiement"',
676 's.cond_reglement_supplier' => '1/2/3...matches field "rowid" in table "'.MAIN_DB_PREFIX.'c_payment_term"',
677 's.outstanding_limit' => "5000",
678 's.fk_account' => "rowid or ref",
679 's.fk_incoterms' => '1/2/3...matches field "rowid" in table "'.MAIN_DB_PREFIX.'c_incoterms"',
680 's.tva_assuj' => '0 (VAT not used) / 1 (VAT used)',
681 's.barcode' => '123456789',
682 's.default_lang' => 'en_US / es_ES etc...matches a language directory in htdocs/langs/',
683 's.canvas' => "empty / a custom canvas form layout url e.g. mycanvas@mymodule",
684 's.datec' => 'formatted as '.dol_print_date(dol_now(), '%Y-%m-%d'),
685 's.fk_multicurrency' => '0 (use system default currency) / 1 (use local currency)',
686 's.multicurrency_code' => 'GBP/USD etc... matches field "code_iso" in table "'.MAIN_DB_PREFIX.'c_currencies"',
687 's.accountancy_code_sell' => '707',
688 's.accountancy_code_buy' => '607',
689 );
690 $this->import_updatekeys_array[$r] = array(
691 's.nom' => 'ThirdPartyName',
692 's.zip' => 'Zip',
693 's.email' => 'Email',
694 's.code_client' => 'CustomerCode',
695 's.code_fournisseur' => 'SupplierCode',
696 's.code_compta' => 'CustomerAccountancyCode',
697 's.code_compta_fournisseur' => 'SupplierAccountancyCode'
698 );
699 if (isModEnabled('socialnetworks')) {
700 $sql = "SELECT code, label FROM ".MAIN_DB_PREFIX."c_socialnetworks WHERE active = 1";
701 $resql = $this->db->query($sql);
702 if ($resql) {
703 while ($obj = $this->db->fetch_object($resql)) {
704 $fieldname = 's.socialnetworks_'.$obj->code;
705 $fieldlabel = ucfirst($obj->label);
706 $this->import_updatekeys_array[$r][$fieldname] = $fieldlabel;
707 }
708 }
709 }
710 // Add profids as criteria to search duplicates
711 $langs->load("companies");
712 $i = 1;
713 while ($i <= 6) {
714 if ($i == 1) {
715 $this->import_updatekeys_array[$r]['s.siren'] = 'ProfId1'.(empty($mysoc->country_code) ? '' : $mysoc->country_code);
716 }
717 if ($i == 2) {
718 $this->import_updatekeys_array[$r]['s.siret'] = 'ProfId2'.(empty($mysoc->country_code) ? '' : $mysoc->country_code);
719 }
720 if ($i == 3) {
721 $this->import_updatekeys_array[$r]['s.ape'] = 'ProfId3'.(empty($mysoc->country_code) ? '' : $mysoc->country_code);
722 }
723 if ($i >= 4) {
724 //var_dump($langs->trans('ProfId'.$i.(empty($mysoc->country_code) ? '' : $mysoc->country_code)));
725 if ($langs->trans('ProfId'.$i.(empty($mysoc->country_code) ? '' : $mysoc->country_code)) != '-') {
726 $this->import_updatekeys_array[$r]['s.idprof'.$i] = 'ProfId'.$i.(empty($mysoc->country_code) ? '' : $mysoc->country_code);
727 }
728 }
729 $i++;
730 }
731
732 // Import list of contacts/addresses of thirparties and attributes
733 $r++;
734 $this->import_code[$r] = $this->rights_class.'_'.$r;
735 $this->import_label[$r] = 'ImportDataset_company_2';
736 $this->import_icon[$r] = 'contact';
737 $this->import_entities_array[$r] = array('s.fk_soc' => 'company'); // We define here only fields that use a different icon than the one defined in import_icon
738 $this->import_tables_array[$r] = array(
739 's' => MAIN_DB_PREFIX.'socpeople',
740 'extra' => MAIN_DB_PREFIX.'socpeople_extrafields'
741 ); // List of tables to insert into (insert done in same order)
742 $this->import_fields_array[$r] = array(//field order as per structure of table llx_socpeople
743 's.rowid' => 'Id',
744 's.datec' => "DateCreation",
745 's.fk_soc' => 'ThirdPartyName',
746 's.civility' => 'UserTitle',
747 's.lastname' => "Lastname*",
748 's.firstname' => "Firstname",
749 's.address' => "Address",
750 's.zip' => "Zip",
751 's.town' => "Town",
752 's.fk_departement' => "StateCode",
753 's.fk_pays' => "CountryCode",
754 's.birthday' => "DateOfBirth",
755 's.poste' => "PostOrFunction",
756 's.phone' => "Phone",
757 's.phone_perso' => "PhonePerso",
758 's.phone_mobile' => "PhoneMobile",
759 's.fax' => "Fax",
760 's.email' => "Email",
761 's.note_private' => "NotePrivate",
762 's.note_public' => "NotePublic"
763 );
764 // Add social networks fields
765 if (isModEnabled('socialnetworks')) {
766 $sql = "SELECT code, label FROM ".MAIN_DB_PREFIX."c_socialnetworks WHERE active = 1";
767 $resql = $this->db->query($sql);
768 if ($resql) {
769 while ($obj = $this->db->fetch_object($resql)) {
770 $fieldname = 's.socialnetworks_'.$obj->code;
771 $fieldlabel = ucfirst($obj->label);
772 $this->import_fields_array[$r][$fieldname] = $fieldlabel;
773 }
774 }
775 }
776 // Add extra fields
777 $sql = "SELECT name, label, fieldrequired FROM ".MAIN_DB_PREFIX."extrafields WHERE type <> 'separate' AND elementtype = 'socpeople' AND entity IN (0, ".$conf->entity.")";
778 $resql = $this->db->query($sql);
779 if ($resql) { // This can fail when class is used on an old database (during a migration for example)
780 while ($obj = $this->db->fetch_object($resql)) {
781 $fieldname = 'extra.'.$obj->name;
782 $fieldlabel = ucfirst($obj->label);
783 $this->import_fields_array[$r][$fieldname] = $fieldlabel.($obj->fieldrequired ? '*' : '');
784 }
785 }
786 // End add extra fields
787 $this->import_fieldshidden_array[$r] = array(
788 's.fk_user_creat' => 'user->id',
789 'extra.fk_object' => 'lastrowid-'.MAIN_DB_PREFIX.'socpeople'
790 ); // aliastable.field => ('user->id' or 'lastrowid-'.tableparent)
791 $this->import_convertvalue_array[$r] = array(
792 's.fk_soc' => array(
793 'rule' => 'fetchidfromref',
794 'file' => '/societe/class/societe.class.php',
795 'class' => 'Societe',
796 'method' => 'fetch',
797 'element' => 'ThirdParty'
798 ),
799 's.fk_departement' => array(
800 'rule' => 'fetchidfromcodeid',
801 'classfile' => '/core/class/cstate.class.php',
802 'class' => 'Cstate',
803 'method' => 'fetch',
804 'dict' => 'DictionaryCanton'
805 ),
806 's.fk_pays' => array(
807 'rule' => 'fetchidfromcodeid',
808 'classfile' => '/core/class/ccountry.class.php',
809 'class' => 'Ccountry',
810 'method' => 'fetch',
811 'dict' => 'DictionaryCountry'
812 ),
813 );
814 //$this->import_convertvalue_array[$r]=array('s.fk_soc'=>array('rule'=>'lastrowid',table='t');
815 $this->import_regex_array[$r] = array(
816 's.birthday' => '^[0-9][0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9]$',
817 '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])?$'
818 );
819 $this->import_examplevalues_array[$r] = array(//field order as per structure of table llx_socpeople
820 's.rowid' => '1',
821 's.datec' => 'formatted as '.dol_print_date(dol_now(), '%Y-%m-%d'),
822 's.fk_soc' => 'Third Party name eg. TPBigCompany',
823 's.civility' => 'Title of civility eg: MR...matches field "code" in table "'.MAIN_DB_PREFIX.'c_civility"',
824 's.lastname' => "lastname or label",
825 's.firstname' => 'John',
826 's.address' => '61 Jump street',
827 's.zip' => '75000',
828 's.town' => 'Bigtown',
829 's.fk_departement' => 'matches field "code_departement" in table "'.MAIN_DB_PREFIX.'c_departements"',
830 's.fk_pays' => 'US/FR/DE etc. matches field "code" in table "'.MAIN_DB_PREFIX.'c_country"',
831 's.birthday' => 'formatted as '.dol_print_date(dol_now(), '%Y-%m-%d'),
832 's.poste' => "Director",
833 's.phone' => "5551122",
834 's.phone_perso' => "5551133",
835 's.phone_mobile' => "5551144",
836 's.fax' => "5551155",
837 's.email' => "johnsmith@email.com",
838 's.note_private' => "My private note",
839 's.note_public' => "My public note"
840 );
841 $this->import_updatekeys_array[$r] = array(
842 's.rowid' => 'Id',
843 's.lastname' => "Lastname",
844 );
845 if (isModEnabled('socialnetworks')) {
846 $sql = "SELECT code, label FROM ".MAIN_DB_PREFIX."c_socialnetworks WHERE active = 1";
847 $resql = $this->db->query($sql);
848 if ($resql) {
849 while ($obj = $this->db->fetch_object($resql)) {
850 $fieldname = 's.socialnetworks_'.$obj->code;
851 $fieldlabel = ucfirst($obj->label);
852 $this->import_updatekeys_array[$r][$fieldname] = $fieldlabel;
853 }
854 }
855 }
856
857 // Import Bank Accounts
858 $r++;
859 $this->import_code[$r] = $this->rights_class.'_'.$r;
860 $this->import_label[$r] = "ImportDataset_company_3"; // Translation key
861 $this->import_icon[$r] = 'company';
862 $this->import_entities_array[$r] = array(); // We define here only fields that use a different icon to the one defined in import_icon
863 $this->import_tables_array[$r] = array('sr' => MAIN_DB_PREFIX.'societe_rib');
864 $this->import_fields_array[$r] = array(//field order as per structure of table llx_societe_rib
865 'sr.label' => "Label*",
866 'sr.fk_soc' => "ThirdPartyName*",
867 'sr.datec' => "DateCreation*",
868 'sr.bank' => "Bank",
869 'sr.code_banque' => "BankCode",
870 'sr.code_guichet' => "DeskCode",
871 'sr.number' => "BankAccountNumber",
872 'sr.cle_rib' => "BankAccountNumberKey",
873 'sr.bic' => "BIC",
874 'sr.iban_prefix' => "IBAN",
875 'sr.domiciliation' => "BankAccountDomiciliation",
876 'sr.proprio' => "BankAccountOwner",
877 'sr.owner_address' => "BankAccountOwnerAddress",
878 'sr.default_rib' => 'Default',
879 'sr.rum' => 'RUM',
880 'sr.frstrecur' => "WithdrawMode",
881 'sr.type' => "Type ban is default",
882 );
883
884 $this->import_convertvalue_array[$r] = array(
885 'sr.fk_soc' => array(
886 'rule' => 'fetchidfromref',
887 'classfile' => '/societe/class/societe.class.php',
888 'class' => 'Societe',
889 'method' => 'fetch',
890 'element' => 'ThirdParty'
891 )
892 );
893 $this->import_examplevalues_array[$r] = array(//field order as per structure of table llx_societe_rib
894 'sr.label' => 'eg. "account1"',
895 'sr.fk_soc' => 'eg. "TPBigCompany"',
896 'sr.datec' => 'date used for creating direct debit UMR formatted as '.dol_print_date(
897 dol_now(),
898 '%Y-%m-%d'
899 ),
900 'sr.bank' => 'bank name eg: "ING-Direct"',
901 'sr.code_banque' => 'account sort code (GB)/Routing number (US) eg. "8456"',
902 'sr.code_guichet' => "bank code for office/branch",
903 'sr.number' => 'account number eg. "3333333333"',
904 'sr.cle_rib' => 'account checksum/control digits (if used) eg. "22"',
905 'sr.bic' => 'bank identifier eg. "USHINGMMXXX"',
906 'sr.iban_prefix' => 'complete account IBAN eg. "GB78CPBK08925068637123"',
907 'sr.domiciliation' => 'bank branch address eg. "PARIS"',
908 'sr.proprio' => 'name on the bank account',
909 'sr.owner_address' => 'address of account holder',
910 'sr.default_rib' => '1 (default account) / 0 (not default)',
911 'sr.rum' => 'RUM code',
912 'sr.frstrecur' => 'FRST',
913 'sr.type' => 'ban',
914 );
915
916 // Import Company Sales representatives
917 $r++;
918 $this->import_code[$r] = $this->rights_class.'_'.$r;
919 $this->import_label[$r] = "ImportDataset_company_4"; // Translation key
920 $this->import_icon[$r] = 'company';
921 $this->import_entities_array[$r] = array('sr.fk_user' => 'user'); // We define here only fields that use another icon that the one defined into import_icon
922 $this->import_tables_array[$r] = array('sr' => MAIN_DB_PREFIX.'societe_commerciaux');
923 $this->import_fields_array[$r] = array('sr.fk_soc' => "ThirdPartyName*", 'sr.fk_user' => "User*");
924
925 $this->import_convertvalue_array[$r] = array(
926 'sr.fk_soc' => array('rule' => 'fetchidfromref', 'classfile' => '/societe/class/societe.class.php', 'class' => 'Societe', 'method' => 'fetch', 'element' => 'ThirdParty'),
927 'sr.fk_user' => array('rule' => 'fetchidfromref', 'classfile' => '/user/class/user.class.php', 'class' => 'User', 'method' => 'fetch', 'element' => 'User')
928 );
929 $this->import_examplevalues_array[$r] = array('sr.fk_soc' => "MyBigCompany", 'sr.fk_user' => "login");
930 }
931
932
941 public function init($options = '')
942 {
943 global $conf, $langs;
944
945 // We disable this to prevent pb of modules not correctly disabled
946 //$this->remove($options);
947
948 //ODT template
949 $src = DOL_DOCUMENT_ROOT.'/install/doctemplates/thirdparties/template_thirdparty.odt';
950 $dirodt = DOL_DATA_ROOT.'/doctemplates/thirdparties';
951 $dest = $dirodt.'/template_thirdparty.odt';
952
953 if (file_exists($src) && !file_exists($dest)) {
954 require_once DOL_DOCUMENT_ROOT.'/core/lib/files.lib.php';
955 dol_mkdir($dirodt);
956 $result = dol_copy($src, $dest, 0, 0);
957 if ($result < 0) {
958 $langs->load("errors");
959 $this->error = $langs->trans('ErrorFailToCopyFile', $src, $dest);
960 return 0;
961 }
962 }
963
964 $sql = array();
965
966 return $this->_init($sql, $options);
967 }
968}
Class DolibarrModules.
_init($array_sql, $options='')
Enables a module.
Class to describe and enable module Societe.
init($options='')
Function called when module is enabled.
__construct($db)
Constructor.
print $script_file $mode $langs defaultlang(is_numeric($duration_value) ? " delay=". $duration_value :"").(is_numeric($duration_value2) ? " after cd cd cd description as description
Only used if Module[ID]Desc translation string is not found.
dol_copy($srcfile, $destfile, $newmask='0', $overwriteifexists=1, $testvirus=0, $indexdatabase=0)
Copy a file to another file.
dol_now($mode='auto')
Return date for now.
dol_print_date($time, $format='', $tzoutput='auto', $outputlangs=null, $encodetooutput=false)
Output date in a string format according to outputlangs (or langs if not defined).
getDolGlobalString($key, $default='')
Return dolibarr global constant string value.
getEntity($element, $shared=1, $currentobject=null)
Get list of entity id to use.
dol_mkdir($dir, $dataroot='', $newmask='')
Creation of a directory (this can create recursive subdir)
$conf db name
Only used if Module[ID]Name translation string is not found.
Definition repair.php:140