1050 lines
48 KiB
PHP
1050 lines
48 KiB
PHP
<?php
|
|
/* Copyright (C) 2003-2005 Rodolphe Quiedeville <rodolphe@quiedeville.org>
|
|
* Copyright (C) 2004-2013 Laurent Destailleur <eldy@users.sourceforge.net>
|
|
* Copyright (C) 2004 Sebastien Di Cintio <sdicintio@ressource-toi.org>
|
|
* Copyright (C) 2004 Benoit Mortier <benoit.mortier@opensides.be>
|
|
* Copyright (C) 2005-2013 Regis Houssin <regis.houssin@inodbox.com>
|
|
* Copyright (C) 2012-2014 Juanjo Menent <jmenent@2byte.es>
|
|
* Copyright (C) 2022 Ferran Marcet <fmarcet@2byte.es>
|
|
* Copyright (C) 2024 MDW <mdeweerd@users.noreply.github.com>
|
|
*
|
|
* This program is free software; you can redistribute it and/or modify
|
|
* it under the terms of the GNU General Public License as published by
|
|
* the Free Software Foundation; either version 3 of the License, or
|
|
* (at your option) any later version.
|
|
*
|
|
* This program is distributed in the hope that it will be useful,
|
|
* but WITHOUT ANY WARRANTY; without even the implied warranty of
|
|
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
|
|
* GNU General Public License for more details.
|
|
*
|
|
* You should have received a copy of the GNU General Public License
|
|
* along with this program. If not, see <https://www.gnu.org/licenses/>.
|
|
*/
|
|
|
|
/**
|
|
* \defgroup societe Module societe
|
|
* \brief Module to manage third parties (customers, prospects)
|
|
* \file htdocs/core/modules/modSociete.class.php
|
|
* \ingroup societe
|
|
* \brief Description and activation file for the module societe (thirdparty)
|
|
*/
|
|
include_once DOL_DOCUMENT_ROOT.'/core/modules/DolibarrModules.class.php';
|
|
|
|
|
|
/**
|
|
* Class to describe and enable module Societe
|
|
*/
|
|
class modSociete extends DolibarrModules
|
|
{
|
|
/**
|
|
* Constructor. Define names, constants, directories, boxes, permissions
|
|
*
|
|
* @param DoliDB $db Database handler
|
|
*/
|
|
public function __construct($db)
|
|
{
|
|
global $conf, $user, $mysoc, $langs;
|
|
|
|
$this->db = $db;
|
|
$this->numero = 1;
|
|
|
|
$this->family = "crm";
|
|
$this->module_position = '09';
|
|
// Module label (no space allowed), used if translation string 'ModuleXXXName' not found (where XXX is value of numeric property 'numero' of module)
|
|
$this->name = preg_replace('/^mod/i', '', get_class($this));
|
|
$this->description = "Gestion des sociétés et contacts";
|
|
|
|
// Possible values for version are: 'development', 'experimental', 'dolibarr' or version
|
|
$this->version = 'dolibarr';
|
|
|
|
$this->const_name = 'MAIN_MODULE_'.strtoupper($this->name);
|
|
$this->config_page_url = array("societe.php@societe");
|
|
// Name of image file used for this module.
|
|
$this->picto = 'company';
|
|
|
|
// Data directories to create when module is enabled
|
|
$this->dirs = array("/societe/temp");
|
|
|
|
// Dependencies
|
|
$this->hidden = false; // A condition to hide module
|
|
$this->depends = array(); // List of module class names as string that must be enabled if this module is enabled
|
|
$this->requiredby = array("modExpedition", "modFacture", "modFournisseur", "modFicheinter", "modPropale", "modContrat", "modCommande"); // List of module ids to disable if this one is disabled
|
|
$this->conflictwith = array(); // List of module class names as string this module is in conflict with
|
|
$this->phpmin = array(7, 0); // Minimum version of PHP required by module
|
|
$this->langfiles = array("companies", 'bills', "compta", "admin", "banks");
|
|
|
|
// Constants
|
|
$this->const = array();
|
|
$r = 0;
|
|
|
|
$this->const[$r][0] = "SOCIETE_CODECLIENT_ADDON";
|
|
$this->const[$r][1] = "chaine";
|
|
$this->const[$r][2] = "mod_codeclient_monkey";
|
|
$this->const[$r][3] = 'Module to control third parties codes';
|
|
$this->const[$r][4] = 0;
|
|
$r++;
|
|
|
|
$this->const[$r][0] = "SOCIETE_CODECOMPTA_ADDON";
|
|
$this->const[$r][1] = "chaine";
|
|
$this->const[$r][2] = "mod_codecompta_panicum";
|
|
$this->const[$r][3] = 'Module to control third parties codes';
|
|
$this->const[$r][4] = 0;
|
|
$r++;
|
|
|
|
$this->const[$r][0] = "SOCIETE_FISCAL_MONTH_START";
|
|
$this->const[$r][1] = "chaine";
|
|
$this->const[$r][2] = "0";
|
|
$this->const[$r][3] = "Enter the month number of the first month of the fiscal year, e. g. 9 for September";
|
|
$this->const[$r][4] = 0;
|
|
$r++;
|
|
|
|
$this->const[$r][0] = "COMPANY_ADDON_PDF_ODT_PATH";
|
|
$this->const[$r][1] = "chaine";
|
|
$this->const[$r][2] = "DOL_DATA_ROOT/doctemplates/thirdparties";
|
|
$this->const[$r][3] = "";
|
|
$this->const[$r][4] = 0;
|
|
$r++;
|
|
|
|
/*
|
|
$this->const[$r][0] = "COMPANY_HIDE_INACTIVE_IN_COMBOBOX";
|
|
$this->const[$r][1] = "chaine";
|
|
$this->const[$r][2] = "0";
|
|
$this->const[$r][3] = "hide thirdparty customer inative in combobox";
|
|
$this->const[$r][4] = 1;
|
|
$r++;
|
|
*/
|
|
|
|
$this->const[$r][0] = "SOCIETE_ADD_REF_IN_LIST";
|
|
$this->const[$r][1] = "yesno";
|
|
$this->const[$r][2] = "0";
|
|
$this->const[$r][3] = "Display customer ref into select list";
|
|
$this->const[$r][4] = 0;
|
|
$r++;
|
|
|
|
// Boxes
|
|
$this->boxes = array(
|
|
0 => array('file' => 'box_clients.php', 'enabledbydefaulton' => 'Home'),
|
|
1 => array('file' => 'box_prospect.php', 'enabledbydefaulton' => 'Home'),
|
|
2 => array('file' => 'box_contacts.php', 'enabledbydefaulton' => 'Home'),
|
|
3 => array('file' => 'box_activity.php', 'enabledbydefaulton' => 'Home', 'note' => '(WarningUsingThisBoxSlowDown)'),
|
|
4 => array('file' => 'box_goodcustomers.php', 'enabledbydefaulton' => 'Home', 'note' => '(WarningUsingThisBoxSlowDown)'),
|
|
);
|
|
|
|
// Permissions
|
|
$this->rights = array();
|
|
$this->rights_class = 'societe';
|
|
$r = 0;
|
|
|
|
$r++;
|
|
$this->rights[$r][0] = 121; // id de la permission
|
|
$this->rights[$r][1] = 'Read third parties'; // libelle de la permission
|
|
$this->rights[$r][2] = 'r'; // type de la permission (deprecated)
|
|
$this->rights[$r][3] = 0; // La permission est-elle une permission par default
|
|
$this->rights[$r][4] = 'lire';
|
|
|
|
/*$r++;
|
|
$this->rights[$r][0] = 241;
|
|
$this->rights[$r][1] = 'Read thirdparties customers';
|
|
$this->rights[$r][2] = 'r';
|
|
$this->rights[$r][3] = 0;
|
|
$this->rights[$r][4] = 'thirdparty_customer_advance'; // Visible if option MAIN_USE_ADVANCED_PERMS is on
|
|
$this->rights[$r][5] = 'read';
|
|
|
|
$r++;
|
|
$this->rights[$r][0] = 242;
|
|
$this->rights[$r][1] = 'Read thirdparties suppliers';
|
|
$this->rights[$r][2] = 'r';
|
|
$this->rights[$r][3] = 0;
|
|
$this->rights[$r][4] = 'thirdparty_supplier_advance'; // Visible if option MAIN_USE_ADVANCED_PERMS is on
|
|
$this->rights[$r][5] = 'read';
|
|
*/
|
|
|
|
$r++;
|
|
$this->rights[$r][0] = 122; // id de la permission
|
|
$this->rights[$r][1] = 'Create and update third parties'; // libelle de la permission
|
|
$this->rights[$r][2] = 'w'; // type de la permission (deprecated)
|
|
$this->rights[$r][3] = 0; // La permission est-elle une permission par default
|
|
$this->rights[$r][4] = 'creer';
|
|
|
|
/* $r++;
|
|
$this->rights[$r][0] = 251;
|
|
$this->rights[$r][1] = 'Create thirdparties customers';
|
|
$this->rights[$r][2] = 'r';
|
|
$this->rights[$r][3] = 0;
|
|
$this->rights[$r][4] = 'thirdparty_customer_advance'; // Visible if option MAIN_USE_ADVANCED_PERMS is on
|
|
$this->rights[$r][5] = 'read';
|
|
|
|
$r++;
|
|
$this->rights[$r][0] = 252;
|
|
$this->rights[$r][1] = 'Create thirdparties suppliers';
|
|
$this->rights[$r][2] = 'r';
|
|
$this->rights[$r][3] = 0;
|
|
$this->rights[$r][4] = 'thirdparty_supplier_advance'; // Visible if option MAIN_USE_ADVANCED_PERMS is on
|
|
$this->rights[$r][5] = 'read';
|
|
*/
|
|
|
|
$r++;
|
|
$this->rights[$r][0] = 125; // id de la permission
|
|
$this->rights[$r][1] = 'Delete third parties'; // libelle de la permission
|
|
$this->rights[$r][2] = 'd'; // type de la permission (deprecated)
|
|
$this->rights[$r][3] = 0; // La permission est-elle une permission par default
|
|
$this->rights[$r][4] = 'supprimer';
|
|
|
|
$r++;
|
|
$this->rights[$r][0] = 126; // id de la permission
|
|
$this->rights[$r][1] = 'Export third parties'; // libelle de la permission
|
|
$this->rights[$r][2] = 'r'; // type de la permission (deprecated)
|
|
$this->rights[$r][3] = 0; // La permission est-elle une permission par default
|
|
$this->rights[$r][4] = 'export';
|
|
|
|
$r++;
|
|
$this->rights[$r][0] = 130;
|
|
$this->rights[$r][1] = 'Modify thirdparty information payment';
|
|
$this->rights[$r][3] = 0;
|
|
$this->rights[$r][4] = 'thirdparty_paymentinformation_advance'; // Visible if option MAIN_USE_ADVANCED_PERMS is on
|
|
$this->rights[$r][5] = 'write';
|
|
|
|
// 262 : Restrict access to sales representative
|
|
$r++;
|
|
$this->rights[$r][0] = 262;
|
|
$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).';
|
|
$this->rights[$r][2] = 'r';
|
|
$this->rights[$r][3] = 0;
|
|
$this->rights[$r][4] = 'client';
|
|
$this->rights[$r][5] = 'voir';
|
|
|
|
/*
|
|
$r++;
|
|
$this->rights[$r][0] = 263;
|
|
$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).';
|
|
$this->rights[$r][2] = 'r';
|
|
$this->rights[$r][3] = 0;
|
|
$this->rights[$r][4] = 'client';
|
|
$this->rights[$r][5] = 'readallthirdparties_advance';
|
|
*/
|
|
|
|
$r++;
|
|
$this->rights[$r][0] = 281; // id de la permission
|
|
$this->rights[$r][1] = 'Read contacts'; // libelle de la permission
|
|
$this->rights[$r][2] = 'r'; // type de la permission (deprecated)
|
|
$this->rights[$r][3] = 0; // La permission est-elle une permission par default
|
|
$this->rights[$r][4] = 'contact';
|
|
$this->rights[$r][5] = 'lire';
|
|
|
|
$r++;
|
|
$this->rights[$r][0] = 282; // id de la permission
|
|
$this->rights[$r][1] = 'Create and update contact'; // libelle de la permission
|
|
$this->rights[$r][2] = 'w'; // type de la permission (deprecated)
|
|
$this->rights[$r][3] = 0; // La permission est-elle une permission par default
|
|
$this->rights[$r][4] = 'contact';
|
|
$this->rights[$r][5] = 'creer';
|
|
|
|
$r++;
|
|
$this->rights[$r][0] = 283; // id de la permission
|
|
$this->rights[$r][1] = 'Delete contacts'; // libelle de la permission
|
|
$this->rights[$r][2] = 'd'; // type de la permission (deprecated)
|
|
$this->rights[$r][3] = 0; // La permission est-elle une permission par default
|
|
$this->rights[$r][4] = 'contact';
|
|
$this->rights[$r][5] = 'supprimer';
|
|
|
|
$r++;
|
|
$this->rights[$r][0] = 286; // id de la permission
|
|
$this->rights[$r][1] = 'Export contacts'; // libelle de la permission
|
|
$this->rights[$r][2] = 'd'; // type de la permission (deprecated)
|
|
$this->rights[$r][3] = 0; // La permission est-elle une permission par default
|
|
$this->rights[$r][4] = 'contact';
|
|
$this->rights[$r][5] = 'export';
|
|
|
|
|
|
// Menus
|
|
//-------
|
|
$this->menu = 1; // This module add menu entries. They are coded into menu manager.
|
|
|
|
|
|
// Exports
|
|
//--------
|
|
$r = 0;
|
|
|
|
// Export list of third parties and attributes
|
|
$r++;
|
|
$this->export_code[$r] = $this->rights_class.'_'.$r;
|
|
$this->export_label[$r] = 'ExportDataset_company_1';
|
|
$this->export_icon[$r] = 'company';
|
|
$this->export_permission[$r] = array(array("societe", "export"));
|
|
$this->export_fields_array[$r] = array(
|
|
's.rowid' => "Id", 's.nom' => "Name", 's.name_alias' => "AliasNameShort", 'ps.nom' => "ParentCompany",
|
|
's.status' => "Status", 's.client' => "Customer", 's.fournisseur' => "Supplier", 's.datec' => "DateCreation", 's.tms' => "DateLastModification",
|
|
's.code_client' => "CustomerCode", 's.code_fournisseur' => "SupplierCode", 's.code_compta' => "AccountancyCode", 's.code_compta_fournisseur' => "SupplierAccountancyCode",
|
|
'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",
|
|
'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",
|
|
's.idprof5' => "ProfId5", 's.idprof6' => "ProfId6", 's.tva_intra' => "VATIntraShort", 's.capital' => "Capital", 's.note_private' => "NotePrivate", 's.note_public' => "NotePublic",
|
|
't.code' => "ThirdPartyType", 'ce.code' => "DictionaryStaff", "cfj.libelle" => "JuridicalStatus", 's.fk_prospectlevel' => 'ProspectLevel',
|
|
'st.code' => 'ProspectStatus', 'payterm.libelle' => 'PaymentConditions', 'paymode.libelle' => 'PaymentMode',
|
|
's.outstanding_limit' => 'OutstandingBill', 'pbacc.ref' => 'PaymentBankAccount', 'incoterm.code' => 'IncotermLabel'
|
|
);
|
|
if (getDolGlobalString('SOCIETE_USEPREFIX')) {
|
|
$this->export_fields_array[$r]['s.prefix'] = 'Prefix';
|
|
}
|
|
if (getDolGlobalString('PRODUIT_MULTIPRICES')) {
|
|
$this->export_fields_array[$r]['s.price_level'] = 'PriceLevel';
|
|
}
|
|
if (getDolGlobalString('ACCOUNTANCY_USE_PRODUCT_ACCOUNT_ON_THIRDPARTY')) {
|
|
$this->export_fields_array[$r] += array('s.accountancy_code_sell' => 'ProductAccountancySellCode', 's.accountancy_code_buy' => 'ProductAccountancyBuyCode');
|
|
}
|
|
// Add multicompany field
|
|
if (getDolGlobalString('MULTICOMPANY_ENTITY_IN_EXPORT_IF_SHARED')) {
|
|
$nbofallowedentities = count(explode(',', getEntity('societe'))); // If project are shared, nb will be > 1
|
|
if (isModEnabled('multicompany') && $nbofallowedentities > 1) {
|
|
$this->export_fields_array[$r] += array('s.entity' => 'Entity');
|
|
}
|
|
}
|
|
$keyforselect = 'societe';
|
|
$keyforelement = 'company';
|
|
$keyforaliasextra = 'extra';
|
|
include DOL_DOCUMENT_ROOT.'/core/extrafieldsinexport.inc.php';
|
|
$this->export_fields_array[$r] += array('u.login' => 'SaleRepresentativeLogin', 'u.firstname' => 'SaleRepresentativeFirstname', 'u.lastname' => 'SaleRepresentativeLastname');
|
|
|
|
$this->export_TypeFields_array[$r] = array(
|
|
's.rowid' => "Numeric", 's.nom' => "Text", 's.name_alias' => "Text", 'ps.nom' => "Text",
|
|
's.status' => "Numeric", 's.client' => "Numeric", 's.fournisseur' => "Boolean", 's.datec' => "Date", 's.tms' => "Date",
|
|
's.code_client' => "Text", 's.code_fournisseur' => "Text", 's.code_compta' => "Text", 's.code_compta_fournisseur' => "Text",
|
|
's.address' => "Text", 's.zip' => "Text", 's.town' => "Text",
|
|
'd.nom' => 'Text', 'r.nom' => 'Text', 'c.label' => 'List:c_country:label:label', 'c.code' => 'Text',
|
|
's.phone' => "Text", 's.fax' => "Text",
|
|
's.url' => "Text", 's.email' => "Text", 's.default_lang' => "Text", 's.canvas' => "Text",
|
|
's.siret' => "Text", 's.siren' => "Text", 's.ape' => "Text", 's.idprof4' => "Text", 's.idprof5' => "Text", 's.idprof6' => "Text",
|
|
's.tva_intra' => "Text", 's.capital' => "Numeric",
|
|
's.note_private' => "Text", 's.note_public' => "Text",
|
|
't.code' => "List:c_typent:libelle:code",
|
|
'ce.code' => "List:c_effectif:libelle:code",
|
|
"cfj.libelle" => "Text",
|
|
's.fk_prospectlevel' => 'List:c_prospectlevel:label:code',
|
|
'st.code' => 'List:c_stcomm:libelle:code',
|
|
'payterm.libelle' => 'Text', 'paymode.libelle' => 'Text',
|
|
's.outstanding_limit' => 'Numeric', 'pbacc.ref' => 'Text', 'incoterm.code' => 'Text',
|
|
'u.login' => 'Text', 'u.firstname' => 'Text', 'u.lastname' => 'Text',
|
|
's.entity' => 'List:entity:label:rowid', 's.price_level' => 'Numeric',
|
|
's.accountancy_code_sell' => 'Text', 's.accountancy_code_buy' => 'Text'
|
|
);
|
|
|
|
$this->export_entities_array[$r] = array( // We define here only fields that use another picto
|
|
'u.login' => 'user',
|
|
'u.firstname' => 'user',
|
|
'u.lastname' => 'user');
|
|
$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)');
|
|
$this->export_sql_start[$r] = 'SELECT DISTINCT ';
|
|
$this->export_sql_end[$r] = ' FROM '.MAIN_DB_PREFIX.'societe as s';
|
|
$this->export_sql_end[$r] .= ' LEFT JOIN '.MAIN_DB_PREFIX.'societe_extrafields as extra ON s.rowid = extra.fk_object';
|
|
$this->export_sql_end[$r] .= ' LEFT JOIN '.MAIN_DB_PREFIX.'societe as ps ON s.parent = ps.rowid';
|
|
$this->export_sql_end[$r] .= ' LEFT JOIN '.MAIN_DB_PREFIX.'c_typent as t ON s.fk_typent = t.id';
|
|
$this->export_sql_end[$r] .= ' LEFT JOIN '.MAIN_DB_PREFIX.'c_country as c ON s.fk_pays = c.rowid';
|
|
$this->export_sql_end[$r] .= ' LEFT JOIN '.MAIN_DB_PREFIX.'c_effectif as ce ON s.fk_effectif = ce.id';
|
|
$this->export_sql_end[$r] .= ' LEFT JOIN '.MAIN_DB_PREFIX.'c_forme_juridique as cfj ON s.fk_forme_juridique = cfj.code';
|
|
$this->export_sql_end[$r] .= ' LEFT JOIN '.MAIN_DB_PREFIX.'c_departements as d ON s.fk_departement = d.rowid';
|
|
$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';
|
|
$this->export_sql_end[$r] .= ' LEFT JOIN '.MAIN_DB_PREFIX.'c_stcomm as st ON s.fk_stcomm = st.id';
|
|
$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';
|
|
$this->export_sql_end[$r] .= ' LEFT JOIN '.MAIN_DB_PREFIX.'c_payment_term as payterm ON s.cond_reglement = payterm.rowid';
|
|
$this->export_sql_end[$r] .= ' LEFT JOIN '.MAIN_DB_PREFIX.'c_paiement as paymode ON s.mode_reglement = paymode.id';
|
|
$this->export_sql_end[$r] .= ' LEFT JOIN '.MAIN_DB_PREFIX.'bank_account as pbacc ON s.fk_account = pbacc.rowid';
|
|
$this->export_sql_end[$r] .= ' LEFT JOIN '.MAIN_DB_PREFIX.'c_incoterms as incoterm ON s.fk_incoterms = incoterm.rowid';
|
|
$this->export_sql_end[$r] .= ' WHERE s.entity IN ('.getEntity('societe').')';
|
|
if (is_object($user) && !$user->hasRight('societe', 'client', 'voir')) {
|
|
$this->export_sql_end[$r] .= ' AND (sc.fk_user = '.((int) $user->id).' ';
|
|
if (getDolGlobalString('SOCIETE_EXPORT_SUBORDINATES_CHILDS')) {
|
|
$subordinatesids = $user->getAllChildIds();
|
|
$this->export_sql_end[$r] .= count($subordinatesids) > 0 ? ' OR (sc.fk_user IN ('.$this->db->sanitize(implode(',', $subordinatesids)).')' : '';
|
|
}
|
|
$this->export_sql_end[$r] .= ')';
|
|
}
|
|
|
|
// Export list of contacts and attributes
|
|
$r++;
|
|
$this->export_code[$r] = $this->rights_class.'_'.$r;
|
|
$this->export_label[$r] = 'ExportDataset_company_2';
|
|
$this->export_icon[$r] = 'contact';
|
|
$this->export_permission[$r] = array(array("societe", "contact", "export"));
|
|
$this->export_fields_array[$r] = array(
|
|
'c.rowid' => "IdContact", 'c.civility' => "CivilityCode", 'c.lastname' => 'Lastname', 'c.firstname' => 'Firstname', 'c.poste' => 'PostOrFunction',
|
|
'c.datec' => "DateCreation", 'c.tms' => "DateLastModification", 'c.priv' => "ContactPrivate", 'c.address' => "Address", 'c.zip' => "Zip", 'c.town' => "Town",
|
|
'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",
|
|
'c.note_private' => 'NotePrivate', 'c.note_public' => "NotePublic",
|
|
'c.statut' => "Status",
|
|
's.rowid' => "IdCompany", 's.nom' => "CompanyName", 's.status' => "Status", 's.code_client' => "CustomerCode", 's.code_fournisseur' => "SupplierCode",
|
|
's.code_compta' => "AccountancyCode", 's.code_compta_fournisseur' => "SupplierAccountancyCode",
|
|
's.client' => 'Customer', 's.fournisseur' => 'Supplier',
|
|
's.address' => 'Address', 's.zip' => "Zip", 's.town' => "Town", 's.phone' => 'Phone', 's.email' => "Email",
|
|
's.note_private' => 'NotePrivate', 's.note_public' => "NotePublic",
|
|
't.code' => "ThirdPartyType"
|
|
);
|
|
// Add multicompany field
|
|
if (getDolGlobalString('MULTICOMPANY_ENTITY_IN_EXPORT_IF_SHARED')) {
|
|
if (isModEnabled('multicompany')) {
|
|
$nbofallowedentities = count(explode(',', getEntity('contact')));
|
|
if ($nbofallowedentities > 1) {
|
|
$this->export_fields_array[$r]['c.entity'] = 'Entity';
|
|
}
|
|
|
|
$nbofallowedentities = count(explode(',', getEntity('societe')));
|
|
if ($nbofallowedentities > 1) {
|
|
$this->export_fields_array[$r]['s.entity'] = 'Entity';
|
|
}
|
|
}
|
|
}
|
|
$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)');
|
|
$this->export_TypeFields_array[$r] = array(
|
|
'c.civility' => "List:c_civility:label:code", 'c.lastname' => 'Text', 'c.firstname' => 'Text', 'c.poste' => 'Text', 'c.datec' => "Date", 'c.priv' => "Boolean",
|
|
'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",
|
|
'c.fax' => "Text", 'c.email' => "Text",
|
|
'c.statut' => "Status",
|
|
's.rowid' => "Numeric", 's.nom' => "Text", 's.status' => "Status", 's.code_client' => "Text", 's.code_fournisseur' => "Text",
|
|
's.code_compta' => "Text", 's.code_compta_fournisseur' => "Text",
|
|
's.client' => "Numeric", 's.fournisseur' => "Numeric",
|
|
's.address' => "Text", 's.zip' => "Text", 's.town' => "Text", 's.phone' => "Text", 's.email' => "Text",
|
|
't.code' => "List:c_stcomm:libelle:code",
|
|
'c.entity' => 'List:entity:label:rowid',
|
|
's.entity' => 'List:entity:label:rowid',
|
|
);
|
|
$this->export_entities_array[$r] = array( // We define here only fields that use another picto
|
|
's.rowid' => "company", 's.nom' => "company", 's.status' => 'company', 's.code_client' => "company", 's.code_fournisseur' => "company",
|
|
's.code_compta' => "company", 's.code_compta_fournisseur' => "company",
|
|
's.client' => "company", 's.fournisseur' => "company",
|
|
's.address' => "company", 's.zip' => "company", 's.town' => "company", 's.phone' => "company", 's.email' => "company",
|
|
't.code' => "company",
|
|
's.entity' => 'company',
|
|
); // We define here only fields that use another picto
|
|
if (!isModEnabled("supplier_order") && !isModEnabled("supplier_invoice")) {
|
|
unset($this->export_fields_array[$r]['s.code_fournisseur']);
|
|
unset($this->export_entities_array[$r]['s.code_fournisseur']);
|
|
}
|
|
$keyforselect = 'socpeople';
|
|
$keyforelement = 'contact';
|
|
$keyforaliasextra = 'extra';
|
|
include DOL_DOCUMENT_ROOT.'/core/extrafieldsinexport.inc.php';
|
|
$keyforselect = 'societe';
|
|
$keyforelement = 'company';
|
|
$keyforaliasextra = 'extrasoc';
|
|
include DOL_DOCUMENT_ROOT.'/core/extrafieldsinexport.inc.php';
|
|
$this->export_sql_start[$r] = 'SELECT DISTINCT ';
|
|
$this->export_sql_end[$r] = ' FROM '.MAIN_DB_PREFIX.'socpeople as c';
|
|
$this->export_sql_end[$r] .= ' LEFT JOIN '.MAIN_DB_PREFIX.'societe as s ON c.fk_soc = s.rowid';
|
|
$this->export_sql_end[$r] .= ' LEFT JOIN '.MAIN_DB_PREFIX.'societe_extrafields as extrasoc ON s.rowid = extrasoc.fk_object';
|
|
if (is_object($user) && !$user->hasRight('societe', 'client', 'voir')) {
|
|
$this->export_sql_end[$r] .= ' LEFT JOIN '.MAIN_DB_PREFIX.'societe_commerciaux as sc ON sc.fk_soc = s.rowid';
|
|
}
|
|
$this->export_sql_end[$r] .= ' LEFT JOIN '.MAIN_DB_PREFIX.'c_departements as d ON c.fk_departement = d.rowid';
|
|
$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';
|
|
$this->export_sql_end[$r] .= ' LEFT JOIN '.MAIN_DB_PREFIX.'c_country as co ON c.fk_pays = co.rowid';
|
|
$this->export_sql_end[$r] .= ' LEFT JOIN '.MAIN_DB_PREFIX.'socpeople_extrafields as extra ON extra.fk_object = c.rowid';
|
|
$this->export_sql_end[$r] .= ' LEFT JOIN '.MAIN_DB_PREFIX.'c_typent as t ON s.fk_typent = t.id';
|
|
$this->export_sql_end[$r] .= ' WHERE c.entity IN ('.getEntity('contact').')';
|
|
if (is_object($user) && !$user->hasRight('societe', 'client', 'voir')) {
|
|
$this->export_sql_end[$r] .= ' AND (sc.fk_user = '.((int) $user->id).' ';
|
|
if (getDolGlobalString('SOCIETE_EXPORT_SUBORDINATES_CHILDS')) {
|
|
$subordinatesids = $user->getAllChildIds();
|
|
$this->export_sql_end[$r] .= count($subordinatesids) > 0 ? ' OR (sc.fk_user IN ('.$this->db->sanitize(implode(',', $subordinatesids)).')' : '';
|
|
}
|
|
$this->export_sql_end[$r] .= ')';
|
|
}
|
|
|
|
// Export list of third-party payment methods
|
|
$r++;
|
|
$this->export_code[$r] = $this->rights_class.'_'.$r;
|
|
$this->export_label[$r] = 'ExportDataset_company_3';
|
|
$this->export_icon[$r] = 'account';
|
|
$this->export_permission[$r] = array(array("societe", "contact", "export"), array("societe", "thirdparty_paymentinformation_advance", "write"));
|
|
$this->export_fields_array[$r] = array(
|
|
'b.rowid' => "IdPaymentMode",
|
|
'b.fk_soc' => "ThirdPartyName",
|
|
'b.label' => 'Label',
|
|
'b.bank' => 'Bank',
|
|
'b.code_banque' => 'Code banque',
|
|
'b.code_guichet' => 'Code guichet',
|
|
'b.number' => 'Number',
|
|
'b.cle_rib' => 'Cle rib',
|
|
'b.bic' => 'Bic',
|
|
'b.iban_prefix' => 'Iban prefix',
|
|
'b.domiciliation' => 'Domiciliation',
|
|
'b.proprio' => 'Proprio',
|
|
'b.owner_address' => 'Owner address',
|
|
'b.default_rib' => 'Default rib',
|
|
'b.rum' => 'Rum',
|
|
'b.date_rum' => 'Date rum',
|
|
'b.frstrecur' => 'Frstrecur',
|
|
'b.type' => 'Type',
|
|
'b.status' => "status",
|
|
'b.datec' => "DateCreation",
|
|
'b.tms' => "DateLastModification"
|
|
);
|
|
// Add multicompany field
|
|
if (getDolGlobalString('MULTICOMPANY_ENTITY_IN_EXPORT_IF_SHARED')) {
|
|
if (isModEnabled('multicompany')) {
|
|
$nbofallowedentities = count(explode(',', getEntity('societe')));
|
|
if ($nbofallowedentities > 1) {
|
|
$this->export_fields_array[$r]['s.entity'] = 'Entity';
|
|
}
|
|
}
|
|
}
|
|
$this->export_examplevalues_array[$r] = array();
|
|
$this->export_TypeFields_array[$r] = array(
|
|
's.nom' => "Text",
|
|
's.entity' => "List:entity:label:rowid",
|
|
'b.rowid' => "Numeric",
|
|
'b.label' => 'Text',
|
|
'b.bank' => 'Text',
|
|
'b.code_banque' => 'Text',
|
|
'b.code_guichet' => 'Text',
|
|
'b.number' => 'Text',
|
|
'b.cle_rib' => 'Text',
|
|
'b.bic' => 'Text',
|
|
'b.iban_prefix' => 'Text',
|
|
'b.domiciliation' => 'Text',
|
|
'b.proprio' => 'Text',
|
|
'b.owner_address' => 'Text',
|
|
'b.default_rib' => 'Boolean"',
|
|
'b.rum' => 'Text',
|
|
'b.date_rum' => 'Date',
|
|
'b.frstrecur' => 'Text',
|
|
'b.type' => 'Text',
|
|
'b.status' => "Status",
|
|
'b.datec' => "Date",
|
|
'b.tms' => "Date"
|
|
);
|
|
$this->export_entities_array[$r] = array(
|
|
's.nom' => "company",
|
|
's.entity' => 'company'
|
|
); // We define here only fields that use another picto
|
|
$this->export_sql_start[$r] = 'SELECT DISTINCT ';
|
|
$this->export_sql_end[$r] = ' FROM '.MAIN_DB_PREFIX.'societe_rib as b';
|
|
$this->export_sql_end[$r] .= ' LEFT JOIN '.MAIN_DB_PREFIX.'societe as s ON b.fk_soc = s.rowid';
|
|
if (is_object($user) && !$user->hasRight('societe', 'client', 'voir')) {
|
|
$this->export_sql_end[$r] .= ' LEFT JOIN '.MAIN_DB_PREFIX.'societe_commerciaux as sc ON sc.fk_soc = s.rowid';
|
|
}
|
|
$this->export_sql_end[$r] .= ' WHERE s.entity IN ('.getEntity('societe').')';
|
|
if (is_object($user) && !$user->hasRight('societe', 'client', 'voir')) {
|
|
$this->export_sql_end[$r] .= ' AND (sc.fk_user = '.((int) $user->id).' ';
|
|
if (getDolGlobalString('SOCIETE_EXPORT_SUBORDINATES_CHILDS')) {
|
|
$subordinatesids = $user->getAllChildIds();
|
|
$this->export_sql_end[$r] .= count($subordinatesids) > 0 ? ' OR (sc.fk_user IN ('.$this->db->sanitize(implode(',', $subordinatesids)).')' : '';
|
|
}
|
|
$this->export_sql_end[$r] .= ')';
|
|
}
|
|
|
|
// Imports
|
|
//--------
|
|
$r = 0;
|
|
|
|
// Import list of third parties and attributes
|
|
|
|
$r++;
|
|
$this->import_code[$r] = $this->rights_class.'_'.$r;
|
|
$this->import_label[$r] = 'ImportDataset_company_1';
|
|
$this->import_icon[$r] = 'company';
|
|
$this->import_entities_array[$r] = array(); // We define here only fields that use a different icon from the one defined in import_icon
|
|
$this->import_tables_array[$r] = array(
|
|
's' => MAIN_DB_PREFIX.'societe',
|
|
'extra' => MAIN_DB_PREFIX.'societe_extrafields'
|
|
); // List of tables to insert into (insert done in same order)
|
|
$this->import_fields_array[$r] = array(//field order as per structure of table llx_societe
|
|
's.nom' => "ThirdPartyName*",
|
|
's.name_alias' => "AliasNameShort",
|
|
's.parent' => "ParentCompany",
|
|
's.status' => "Status*",
|
|
's.code_client' => "CustomerCode",
|
|
's.code_fournisseur' => "SupplierCode",
|
|
's.code_compta' => "CustomerAccountancyCode",
|
|
's.code_compta_fournisseur' => "SupplierAccountancyCode",
|
|
's.address' => "Address",
|
|
's.zip' => "Zip",
|
|
's.town' => "Town",
|
|
's.fk_departement' => "StateCode",
|
|
's.fk_pays' => "CountryCode",
|
|
's.phone' => "Phone",
|
|
's.fax' => "Fax",
|
|
's.url' => "Url",
|
|
's.email' => "Email",
|
|
's.fk_effectif' => "Staff",
|
|
's.fk_typent' => "ThirdPartyType",
|
|
"s.fk_forme_juridique" => "JuridicalStatus",
|
|
's.siren' => "ProfId1",
|
|
's.siret' => "ProfId2",
|
|
's.ape' => "ProfId3",
|
|
's.idprof4' => "ProfId4",
|
|
's.idprof5' => "ProfId5",
|
|
's.idprof6' => "ProfId6",
|
|
's.tva_intra' => "VATIntraShort",
|
|
's.capital' => "Capital",
|
|
's.fk_stcomm' => 'ProspectStatus',
|
|
's.note_private' => "NotePrivate",
|
|
's.note_public' => "NotePublic",
|
|
's.client' => "Customer*",
|
|
's.fournisseur' => "Supplier*",
|
|
's.fk_prospectlevel' => 'ProspectLevel',
|
|
's.mode_reglement' => 'PaymentTypeCustomer',
|
|
's.cond_reglement' => "PaymentTermsCustomer",
|
|
's.mode_reglement_supplier' => 'PaymentTypeSupplier',
|
|
's.cond_reglement_supplier' => "PaymentTermsSupplier",
|
|
's.outstanding_limit' => 'OutstandingBill',
|
|
's.fk_account' => 'PaymentBankAccount',
|
|
's.fk_incoterms' => 'IncotermLabel',
|
|
's.tva_assuj' => 'VATIsUsed',
|
|
's.barcode' => 'BarCode',
|
|
's.default_lang' => 'DefaultLanguage',
|
|
's.canvas' => "Canvas",
|
|
's.datec' => "DateCreation",
|
|
's.fk_multicurrency' => 'MulticurrencyUsed',
|
|
's.multicurrency_code' => 'MulticurrencyCurrency'
|
|
);
|
|
if (getDolGlobalString('PRODUIT_MULTIPRICES')) {
|
|
$this->import_fields_array[$r]['s.price_level'] = 'PriceLevel';
|
|
}
|
|
if (getDolGlobalString('ACCOUNTANCY_USE_PRODUCT_ACCOUNT_ON_THIRDPARTY')) {
|
|
$this->import_fields_array[$r] += array('s.accountancy_code_sell' => 'ProductAccountancySellCode', 's.accountancy_code_buy' => 'ProductAccountancyBuyCode');
|
|
}
|
|
// Add social networks fields
|
|
if (isModEnabled('socialnetworks')) {
|
|
$sql = "SELECT code, label FROM ".MAIN_DB_PREFIX."c_socialnetworks WHERE active = 1";
|
|
$resql = $this->db->query($sql);
|
|
if ($resql) {
|
|
while ($obj = $this->db->fetch_object($resql)) {
|
|
$fieldname = 's.socialnetworks_'.$obj->code;
|
|
$fieldlabel = ucfirst($obj->label);
|
|
$this->import_fields_array[$r][$fieldname] = $fieldlabel;
|
|
}
|
|
}
|
|
}
|
|
// Add extra fields
|
|
$sql = "SELECT name, label, fieldrequired FROM ".MAIN_DB_PREFIX."extrafields WHERE type <> 'separate' AND elementtype = 'societe' AND entity IN (0, ".$conf->entity.")";
|
|
$resql = $this->db->query($sql);
|
|
if ($resql) { // This can fail when class is used on old database (during migration for example)
|
|
while ($obj = $this->db->fetch_object($resql)) {
|
|
$fieldname = 'extra.'.$obj->name;
|
|
$fieldlabel = ucfirst($obj->label);
|
|
$this->import_fields_array[$r][$fieldname] = $fieldlabel.($obj->fieldrequired ? '*' : '');
|
|
}
|
|
}
|
|
// End add extra fields
|
|
$this->import_fieldshidden_array[$r] = array(
|
|
's.fk_user_creat' => 'user->id',
|
|
'extra.fk_object' => 'lastrowid-'.MAIN_DB_PREFIX.'societe'
|
|
); // aliastable.field => ('user->id' or 'lastrowid-'.tableparent)
|
|
$this->import_convertvalue_array[$r] = array(//field order as per structure of table llx_societe
|
|
's.code_client' => array('rule' => 'getcustomercodeifauto'),
|
|
's.code_fournisseur' => array('rule' => 'getsuppliercodeifauto'),
|
|
's.code_compta' => array('rule' => 'getcustomeraccountancycodeifauto'),
|
|
's.code_compta_fournisseur' => array('rule' => 'getsupplieraccountancycodeifauto'),
|
|
's.fk_departement' => array(
|
|
'rule' => 'fetchidfromcodeid',
|
|
'classfile' => '/core/class/cstate.class.php',
|
|
'class' => 'Cstate',
|
|
'method' => 'fetch',
|
|
'dict' => 'DictionaryStateCode'
|
|
),
|
|
's.fk_pays' => array(
|
|
'rule' => 'fetchidfromcodeid',
|
|
'classfile' => '/core/class/ccountry.class.php',
|
|
'class' => 'Ccountry',
|
|
'method' => 'fetch',
|
|
'dict' => 'DictionaryCountry'
|
|
),
|
|
's.fk_typent' => array(
|
|
'rule' => 'fetchidfromcodeorlabel',
|
|
'classfile' => '/core/class/ctypent.class.php',
|
|
'class' => 'Ctypent',
|
|
'method' => 'fetch',
|
|
'dict' => 'DictionaryCompanyType'
|
|
),
|
|
's.capital' => array('rule' => 'numeric'),
|
|
's.parent' => array(
|
|
'rule' => 'fetchidfromref',
|
|
'file' => '/societe/class/societe.class.php',
|
|
'class' => 'Societe',
|
|
'method' => 'fetch',
|
|
'element' => 'ThirdParty'
|
|
),
|
|
's.outstanding_limit' => array('rule' => 'numeric'),
|
|
's.fk_account' => array(
|
|
'rule' => 'fetchidfromcodeid',
|
|
'classfile' => '/compta/bank/class/account.class.php',
|
|
'class' => 'Account',
|
|
'method' => 'fetch',
|
|
'element' => 'BankAccount'
|
|
),
|
|
's.fk_stcomm' => array(
|
|
'rule' => 'fetchidfromcodeid',
|
|
'classfile' => '/core/class/cgenericdic.class.php',
|
|
'class' => 'CGenericDic',
|
|
'method' => 'fetch',
|
|
'dict' => 'DictionaryProspectStatus',
|
|
'element' => 'c_stcomm',
|
|
'table_element' => 'c_stcomm'
|
|
),
|
|
/*
|
|
's.fk_prospectlevel' => array(
|
|
'rule' => 'fetchidfromcodeid',
|
|
'classfile' => '/core/class/cgenericdic.class.php',
|
|
'class' => 'CGenericDic',
|
|
'method' => 'fetch',
|
|
'dict' => 'DictionaryProspectLevel',
|
|
'element' => 'c_prospectlevel',
|
|
'table_element' => 'c_prospectlevel'
|
|
),*/
|
|
// TODO
|
|
// 's.fk_incoterms' => array(
|
|
// 'rule' => 'fetchidfromcodeid',
|
|
// 'classfile' => '/core/class/cincoterm.class.php',
|
|
// 'class' => 'Cincoterm',
|
|
// 'method' => 'fetch',
|
|
// 'dict' => 'IncotermLabel'
|
|
// )
|
|
);
|
|
//$this->import_convertvalue_array[$r]=array('s.fk_soc'=>array('rule'=>'lastrowid',table='t');
|
|
$this->import_regex_array[$r] = array(//field order as per structure of table llx_societe
|
|
's.status' => '^[0|1]',
|
|
's.fk_typent' => 'id@'.MAIN_DB_PREFIX.'c_typent',
|
|
's.client' => '^[0|1|2|3]',
|
|
's.fournisseur' => '^[0|1]',
|
|
's.mode_reglement' => 'id@'.MAIN_DB_PREFIX.'c_paiement',
|
|
's.cond_reglement' => 'rowid@'.MAIN_DB_PREFIX.'c_payment_term',
|
|
's.mode_reglement_supplier' => 'id@'.MAIN_DB_PREFIX.'c_paiement',
|
|
's.cond_reglement_supplier' => 'rowid@'.MAIN_DB_PREFIX.'c_payment_term',
|
|
's.fk_incoterms' => 'rowid@'.MAIN_DB_PREFIX.'c_incoterms',
|
|
's.tva_assuj' => '^[0|1]',
|
|
's.fk_multicurrency' => '^[0|1]',
|
|
'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])?$',
|
|
's.multicurrency_code' => 'code_iso@'.MAIN_DB_PREFIX.'c_currencies'
|
|
);
|
|
|
|
$this->import_examplevalues_array[$r] = array(//field order as per structure of table llx_societe
|
|
's.nom' => "TPBigCompany",
|
|
's.name_alias' => "Alias for TPBigCompany",
|
|
's.parent' => "TPMotherCompany",
|
|
's.status' => "0 (closed) / 1 (active)",
|
|
's.code_client' => 'eg. CU01-0001 / empty / "auto"',
|
|
's.code_fournisseur' => 'eg. SU01-0001 / empty / "auto"',
|
|
's.code_compta' => "Code or empty to be auto-created",
|
|
's.code_compta_fournisseur' => "Code or empty to be auto-created",
|
|
's.address' => "61 Jump Street",
|
|
's.zip' => "123456",
|
|
's.town' => "Bigtown",
|
|
's.fk_departement' => 'matches field "code_departement" in table "'.MAIN_DB_PREFIX.'c_departements"',
|
|
's.fk_pays' => 'US/FR/DE etc. matches field "code" in table "'.MAIN_DB_PREFIX.'c_country"',
|
|
's.phone' => "eg: +34123456789",
|
|
's.fax' => "eg. +34987654321",
|
|
's.url' => "e.g. https://www.mybigcompany.com",
|
|
's.email' => "e.g. test@mybigcompany.com",
|
|
's.fk_effectif' => "1/2/3/5: represents one of the five ranges of employees",
|
|
's.fk_typent' => 'matches field "id" (1-9 etc.) OR "code" (TE_SMALL etc.) in table "'.MAIN_DB_PREFIX.'c_typent"',
|
|
's.fk_forme_juridique' => '1/2/3 etc...matches field "code" in table "'.MAIN_DB_PREFIX.'c_forme_juridique"',
|
|
's.siret' => "",
|
|
's.siren' => "",
|
|
's.ape' => "",
|
|
's.idprof4' => "",
|
|
's.idprof5' => "",
|
|
's.idprof6' => "",
|
|
's.tva_intra' => 'VAT number e.g."FR0123456789"',
|
|
's.capital' => "10000",
|
|
's.fk_stcomm' => '-1/0/1/2 etc... matches field "id" in table "'.MAIN_DB_PREFIX.'c_stcomm"',
|
|
's.note_private' => "Example of a PRIVATE note.",
|
|
's.note_public' => "Example of a PUBLIC note.",
|
|
's.client' => '0 (no customer no prospect) / 1 (customer) / 2 (prospect)/ 3 (customer and prospect)',
|
|
's.fournisseur' => '0 (not supplier) / 1 (supplier)',
|
|
's.fk_prospectlevel' => 'eg. "PL_MEDIUM" matches field "code" in table "'.MAIN_DB_PREFIX.'c_prospectlevel"',
|
|
's.mode_reglement' => '1/2/3...matches field "id" in table "'.MAIN_DB_PREFIX.'c_paiement"',
|
|
's.cond_reglement' => '1/2/3...matches field "rowid" in table "'.MAIN_DB_PREFIX.'c_payment_term"',
|
|
's.mode_reglement_supplier' => '1/2/3...matches field "id" in table "'.MAIN_DB_PREFIX.'c_paiement"',
|
|
's.cond_reglement_supplier' => '1/2/3...matches field "rowid" in table "'.MAIN_DB_PREFIX.'c_payment_term"',
|
|
's.outstanding_limit' => "5000",
|
|
's.fk_account' => "rowid or ref",
|
|
's.fk_incoterms' => '1/2/3...matches field "rowid" in table "'.MAIN_DB_PREFIX.'c_incoterms"',
|
|
's.tva_assuj' => '0 (VAT not used) / 1 (VAT used)',
|
|
's.barcode' => '123456789',
|
|
's.default_lang' => 'en_US / es_ES etc...matches a language directory in htdocs/langs/',
|
|
's.canvas' => "empty / a custom canvas form layout url e.g. mycanvas@mymodule",
|
|
's.datec' => 'formatted as '.dol_print_date(dol_now(), '%Y-%m-%d'),
|
|
's.fk_multicurrency' => '0 (use system default currency) / 1 (use local currency)',
|
|
's.multicurrency_code' => 'GBP/USD etc... matches field "code_iso" in table "'.MAIN_DB_PREFIX.'c_currencies"',
|
|
's.accountancy_code_sell' => '707',
|
|
's.accountancy_code_buy' => '607',
|
|
);
|
|
$this->import_updatekeys_array[$r] = array(
|
|
's.nom' => 'ThirdPartyName',
|
|
's.zip' => 'Zip',
|
|
's.email' => 'Email',
|
|
's.code_client' => 'CustomerCode',
|
|
's.code_fournisseur' => 'SupplierCode',
|
|
's.code_compta' => 'CustomerAccountancyCode',
|
|
's.code_compta_fournisseur' => 'SupplierAccountancyCode'
|
|
);
|
|
if (isModEnabled('socialnetworks')) {
|
|
$sql = "SELECT code, label FROM ".MAIN_DB_PREFIX."c_socialnetworks WHERE active = 1";
|
|
$resql = $this->db->query($sql);
|
|
if ($resql) {
|
|
while ($obj = $this->db->fetch_object($resql)) {
|
|
$fieldname = 's.socialnetworks_'.$obj->code;
|
|
$fieldlabel = ucfirst($obj->label);
|
|
$this->import_updatekeys_array[$r][$fieldname] = $fieldlabel;
|
|
}
|
|
}
|
|
}
|
|
// Add profids as criteria to search duplicates
|
|
$langs->load("companies");
|
|
$i = 1;
|
|
while ($i <= 6) {
|
|
if ($i == 1) {
|
|
$this->import_updatekeys_array[$r]['s.siren'] = 'ProfId1'.(empty($mysoc->country_code) ? '' : $mysoc->country_code);
|
|
}
|
|
if ($i == 2) {
|
|
$this->import_updatekeys_array[$r]['s.siret'] = 'ProfId2'.(empty($mysoc->country_code) ? '' : $mysoc->country_code);
|
|
}
|
|
if ($i == 3) {
|
|
$this->import_updatekeys_array[$r]['s.ape'] = 'ProfId3'.(empty($mysoc->country_code) ? '' : $mysoc->country_code);
|
|
}
|
|
if ($i >= 4) {
|
|
//var_dump($langs->trans('ProfId'.$i.(empty($mysoc->country_code) ? '' : $mysoc->country_code)));
|
|
if ($langs->trans('ProfId'.$i.(empty($mysoc->country_code) ? '' : $mysoc->country_code)) != '-') {
|
|
$this->import_updatekeys_array[$r]['s.idprof'.$i] = 'ProfId'.$i.(empty($mysoc->country_code) ? '' : $mysoc->country_code);
|
|
}
|
|
}
|
|
$i++;
|
|
}
|
|
|
|
// Import list of contacts/addresses of thirparties and attributes
|
|
$r++;
|
|
$this->import_code[$r] = $this->rights_class.'_'.$r;
|
|
$this->import_label[$r] = 'ImportDataset_company_2';
|
|
$this->import_icon[$r] = 'contact';
|
|
$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
|
|
$this->import_tables_array[$r] = array(
|
|
's' => MAIN_DB_PREFIX.'socpeople',
|
|
'extra' => MAIN_DB_PREFIX.'socpeople_extrafields'
|
|
); // List of tables to insert into (insert done in same order)
|
|
$this->import_fields_array[$r] = array(//field order as per structure of table llx_socpeople
|
|
's.rowid' => 'Id',
|
|
's.datec' => "DateCreation",
|
|
's.fk_soc' => 'ThirdPartyName',
|
|
's.civility' => 'UserTitle',
|
|
's.lastname' => "Lastname*",
|
|
's.firstname' => "Firstname",
|
|
's.address' => "Address",
|
|
's.zip' => "Zip",
|
|
's.town' => "Town",
|
|
's.fk_departement' => "StateCode",
|
|
's.fk_pays' => "CountryCode",
|
|
's.birthday' => "DateOfBirth",
|
|
's.poste' => "PostOrFunction",
|
|
's.phone' => "Phone",
|
|
's.phone_perso' => "PhonePerso",
|
|
's.phone_mobile' => "PhoneMobile",
|
|
's.fax' => "Fax",
|
|
's.email' => "Email",
|
|
's.note_private' => "NotePrivate",
|
|
's.note_public' => "NotePublic"
|
|
);
|
|
// Add social networks fields
|
|
if (isModEnabled('socialnetworks')) {
|
|
$sql = "SELECT code, label FROM ".MAIN_DB_PREFIX."c_socialnetworks WHERE active = 1";
|
|
$resql = $this->db->query($sql);
|
|
if ($resql) {
|
|
while ($obj = $this->db->fetch_object($resql)) {
|
|
$fieldname = 's.socialnetworks_'.$obj->code;
|
|
$fieldlabel = ucfirst($obj->label);
|
|
$this->import_fields_array[$r][$fieldname] = $fieldlabel;
|
|
}
|
|
}
|
|
}
|
|
// Add extra fields
|
|
$sql = "SELECT name, label, fieldrequired FROM ".MAIN_DB_PREFIX."extrafields WHERE type <> 'separate' AND elementtype = 'socpeople' AND entity IN (0, ".$conf->entity.")";
|
|
$resql = $this->db->query($sql);
|
|
if ($resql) { // This can fail when class is used on an old database (during a migration for example)
|
|
while ($obj = $this->db->fetch_object($resql)) {
|
|
$fieldname = 'extra.'.$obj->name;
|
|
$fieldlabel = ucfirst($obj->label);
|
|
$this->import_fields_array[$r][$fieldname] = $fieldlabel.($obj->fieldrequired ? '*' : '');
|
|
}
|
|
}
|
|
// End add extra fields
|
|
$this->import_fieldshidden_array[$r] = array(
|
|
's.fk_user_creat' => 'user->id',
|
|
'extra.fk_object' => 'lastrowid-'.MAIN_DB_PREFIX.'socpeople'
|
|
); // aliastable.field => ('user->id' or 'lastrowid-'.tableparent)
|
|
$this->import_convertvalue_array[$r] = array(
|
|
's.fk_soc' => array(
|
|
'rule' => 'fetchidfromref',
|
|
'file' => '/societe/class/societe.class.php',
|
|
'class' => 'Societe',
|
|
'method' => 'fetch',
|
|
'element' => 'ThirdParty'
|
|
),
|
|
's.fk_departement' => array(
|
|
'rule' => 'fetchidfromcodeid',
|
|
'classfile' => '/core/class/cstate.class.php',
|
|
'class' => 'Cstate',
|
|
'method' => 'fetch',
|
|
'dict' => 'DictionaryCanton'
|
|
),
|
|
's.fk_pays' => array(
|
|
'rule' => 'fetchidfromcodeid',
|
|
'classfile' => '/core/class/ccountry.class.php',
|
|
'class' => 'Ccountry',
|
|
'method' => 'fetch',
|
|
'dict' => 'DictionaryCountry'
|
|
),
|
|
);
|
|
//$this->import_convertvalue_array[$r]=array('s.fk_soc'=>array('rule'=>'lastrowid',table='t');
|
|
$this->import_regex_array[$r] = array(
|
|
's.birthday' => '^[0-9][0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9]$',
|
|
'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])?$'
|
|
);
|
|
$this->import_examplevalues_array[$r] = array(//field order as per structure of table llx_socpeople
|
|
's.rowid' => '1',
|
|
's.datec' => 'formatted as '.dol_print_date(dol_now(), '%Y-%m-%d'),
|
|
's.fk_soc' => 'Third Party name eg. TPBigCompany',
|
|
's.civility' => 'Title of civility eg: MR...matches field "code" in table "'.MAIN_DB_PREFIX.'c_civility"',
|
|
's.lastname' => "lastname or label",
|
|
's.firstname' => 'John',
|
|
's.address' => '61 Jump street',
|
|
's.zip' => '75000',
|
|
's.town' => 'Bigtown',
|
|
's.fk_departement' => 'matches field "code_departement" in table "'.MAIN_DB_PREFIX.'c_departements"',
|
|
's.fk_pays' => 'US/FR/DE etc. matches field "code" in table "'.MAIN_DB_PREFIX.'c_country"',
|
|
's.birthday' => 'formatted as '.dol_print_date(dol_now(), '%Y-%m-%d'),
|
|
's.poste' => "Director",
|
|
's.phone' => "5551122",
|
|
's.phone_perso' => "5551133",
|
|
's.phone_mobile' => "5551144",
|
|
's.fax' => "5551155",
|
|
's.email' => "johnsmith@email.com",
|
|
's.note_private' => "My private note",
|
|
's.note_public' => "My public note"
|
|
);
|
|
$this->import_updatekeys_array[$r] = array(
|
|
's.rowid' => 'Id',
|
|
's.lastname' => "Lastname",
|
|
);
|
|
if (isModEnabled('socialnetworks')) {
|
|
$sql = "SELECT code, label FROM ".MAIN_DB_PREFIX."c_socialnetworks WHERE active = 1";
|
|
$resql = $this->db->query($sql);
|
|
if ($resql) {
|
|
while ($obj = $this->db->fetch_object($resql)) {
|
|
$fieldname = 's.socialnetworks_'.$obj->code;
|
|
$fieldlabel = ucfirst($obj->label);
|
|
$this->import_updatekeys_array[$r][$fieldname] = $fieldlabel;
|
|
}
|
|
}
|
|
}
|
|
|
|
// Import Bank Accounts
|
|
$r++;
|
|
$this->import_code[$r] = $this->rights_class.'_'.$r;
|
|
$this->import_label[$r] = "ImportDataset_company_3"; // Translation key
|
|
$this->import_icon[$r] = 'company';
|
|
$this->import_entities_array[$r] = array(); // We define here only fields that use a different icon to the one defined in import_icon
|
|
$this->import_tables_array[$r] = array('sr' => MAIN_DB_PREFIX.'societe_rib');
|
|
$this->import_fields_array[$r] = array(//field order as per structure of table llx_societe_rib
|
|
'sr.label' => "Label*",
|
|
'sr.fk_soc' => "ThirdPartyName*",
|
|
'sr.datec' => "DateCreation*",
|
|
'sr.bank' => "Bank",
|
|
'sr.code_banque' => "BankCode",
|
|
'sr.code_guichet' => "DeskCode",
|
|
'sr.number' => "BankAccountNumber",
|
|
'sr.cle_rib' => "BankAccountNumberKey",
|
|
'sr.bic' => "BIC",
|
|
'sr.iban_prefix' => "IBAN",
|
|
'sr.domiciliation' => "BankAccountDomiciliation",
|
|
'sr.proprio' => "BankAccountOwner",
|
|
'sr.owner_address' => "BankAccountOwnerAddress",
|
|
'sr.default_rib' => 'Default',
|
|
'sr.rum' => 'RUM',
|
|
'sr.frstrecur' => "WithdrawMode",
|
|
'sr.type' => "Type ban is default",
|
|
);
|
|
|
|
$this->import_convertvalue_array[$r] = array(
|
|
'sr.fk_soc' => array(
|
|
'rule' => 'fetchidfromref',
|
|
'classfile' => '/societe/class/societe.class.php',
|
|
'class' => 'Societe',
|
|
'method' => 'fetch',
|
|
'element' => 'ThirdParty'
|
|
)
|
|
);
|
|
$this->import_examplevalues_array[$r] = array(//field order as per structure of table llx_societe_rib
|
|
'sr.label' => 'eg. "account1"',
|
|
'sr.fk_soc' => 'eg. "TPBigCompany"',
|
|
'sr.datec' => 'date used for creating direct debit UMR formatted as '.dol_print_date(
|
|
dol_now(),
|
|
'%Y-%m-%d'
|
|
),
|
|
'sr.bank' => 'bank name eg: "ING-Direct"',
|
|
'sr.code_banque' => 'account sort code (GB)/Routing number (US) eg. "8456"',
|
|
'sr.code_guichet' => "bank code for office/branch",
|
|
'sr.number' => 'account number eg. "3333333333"',
|
|
'sr.cle_rib' => 'account checksum/control digits (if used) eg. "22"',
|
|
'sr.bic' => 'bank identifier eg. "USHINGMMXXX"',
|
|
'sr.iban_prefix' => 'complete account IBAN eg. "GB78CPBK08925068637123"',
|
|
'sr.domiciliation' => 'bank branch address eg. "PARIS"',
|
|
'sr.proprio' => 'name on the bank account',
|
|
'sr.owner_address' => 'address of account holder',
|
|
'sr.default_rib' => '1 (default account) / 0 (not default)',
|
|
'sr.rum' => 'RUM code',
|
|
'sr.frstrecur' => 'FRST',
|
|
'sr.type' => 'ban',
|
|
);
|
|
|
|
// Import Company Sales representatives
|
|
$r++;
|
|
$this->import_code[$r] = $this->rights_class.'_'.$r;
|
|
$this->import_label[$r] = "ImportDataset_company_4"; // Translation key
|
|
$this->import_icon[$r] = 'company';
|
|
$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
|
|
$this->import_tables_array[$r] = array('sr' => MAIN_DB_PREFIX.'societe_commerciaux');
|
|
$this->import_fields_array[$r] = array('sr.fk_soc' => "ThirdPartyName*", 'sr.fk_user' => "User*");
|
|
|
|
$this->import_convertvalue_array[$r] = array(
|
|
'sr.fk_soc' => array('rule' => 'fetchidfromref', 'classfile' => '/societe/class/societe.class.php', 'class' => 'Societe', 'method' => 'fetch', 'element' => 'ThirdParty'),
|
|
'sr.fk_user' => array('rule' => 'fetchidfromref', 'classfile' => '/user/class/user.class.php', 'class' => 'User', 'method' => 'fetch', 'element' => 'User')
|
|
);
|
|
$this->import_examplevalues_array[$r] = array('sr.fk_soc' => "MyBigCompany", 'sr.fk_user' => "login");
|
|
}
|
|
|
|
|
|
/**
|
|
* Function called when module is enabled.
|
|
* The init function add constants, boxes, permissions and menus (defined in constructor) into Dolibarr database.
|
|
* It also creates data directories
|
|
*
|
|
* @param string $options Options when enabling module ('', 'noboxes')
|
|
* @return int 1 if OK, 0 if KO
|
|
*/
|
|
public function init($options = '')
|
|
{
|
|
global $conf, $langs;
|
|
|
|
// We disable this to prevent pb of modules not correctly disabled
|
|
//$this->remove($options);
|
|
|
|
//ODT template
|
|
$src = DOL_DOCUMENT_ROOT.'/install/doctemplates/thirdparties/template_thirdparty.odt';
|
|
$dirodt = DOL_DATA_ROOT.'/doctemplates/thirdparties';
|
|
$dest = $dirodt.'/template_thirdparty.odt';
|
|
|
|
if (file_exists($src) && !file_exists($dest)) {
|
|
require_once DOL_DOCUMENT_ROOT.'/core/lib/files.lib.php';
|
|
dol_mkdir($dirodt);
|
|
$result = dol_copy($src, $dest, 0, 0);
|
|
if ($result < 0) {
|
|
$langs->load("errors");
|
|
$this->error = $langs->trans('ErrorFailToCopyFile', $src, $dest);
|
|
return 0;
|
|
}
|
|
}
|
|
|
|
$sql = array();
|
|
|
|
return $this->_init($sql, $options);
|
|
}
|
|
}
|