dolibarr 22.0.5
dict.php
Go to the documentation of this file.
1<?php
2/* Copyright (C) 2004 Rodolphe Quiedeville <rodolphe@quiedeville.org>
3 * Copyright (C) 2004-2018 Laurent Destailleur <eldy@users.sourceforge.net>
4 * Copyright (C) 2004 Benoit Mortier <benoit.mortier@opensides.be>
5 * Copyright (C) 2005-2017 Regis Houssin <regis.houssin@inodbox.com>
6 * Copyright (C) 2010-2022 Juanjo Menent <jmenent@2byte.es>
7 * Copyright (C) 2011-2021 Philippe Grand <philippe.grand@atoo-net.com>
8 * Copyright (C) 2011 Remy Younes <ryounes@gmail.com>
9 * Copyright (C) 2012-2015 Marcos García <marcosgdf@gmail.com>
10 * Copyright (C) 2012 Christophe Battarel <christophe.battarel@ltairis.fr>
11 * Copyright (C) 2011-2025 Alexandre Spangaro <alexandre@inovea-conseil.com>
12 * Copyright (C) 2015 Ferran Marcet <fmarcet@2byte.es>
13 * Copyright (C) 2016 Raphaël Doursenaud <rdoursenaud@gpcsolutions.fr>
14 * Copyright (C) 2019-2025 Frédéric France <frederic.france@free.fr>
15 * Copyright (C) 2020-2022 Open-Dsi <support@open-dsi.fr>
16 * Copyright (C) 2024 Charlene Benke <charlene@patas-monkey.com>
17 * Copyright (C) 2024 MDW <mdeweerd@users.noreply.github.com>
18 *
19 * This program is free software; you can redistribute it and/or modify
20 * it under the terms of the GNU General Public License as published by
21 * the Free Software Foundation; either version 3 of the License, or
22 * (at your option) any later version.
23 *
24 * This program is distributed in the hope that it will be useful,
25 * but WITHOUT ANY WARRANTY; without even the implied warranty of
26 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
27 * GNU General Public License for more details.
28 *
29 * You should have received a copy of the GNU General Public License
30 * along with this program. If not, see <https://www.gnu.org/licenses/>.
31 */
32
39// Load Dolibarr environment
40require '../main.inc.php';
41require_once DOL_DOCUMENT_ROOT.'/core/class/html.formadmin.class.php';
42require_once DOL_DOCUMENT_ROOT.'/core/class/html.formcompany.class.php';
43require_once DOL_DOCUMENT_ROOT.'/core/lib/admin.lib.php';
44require_once DOL_DOCUMENT_ROOT.'/core/lib/functions2.lib.php';
45require_once DOL_DOCUMENT_ROOT.'/core/class/doleditor.class.php';
46require_once DOL_DOCUMENT_ROOT.'/core/lib/accounting.lib.php';
47require_once DOL_DOCUMENT_ROOT.'/core/class/html.formaccounting.class.php';
48require_once DOL_DOCUMENT_ROOT.'/core/lib/socialnetwork.lib.php';
49
50// constants for IDs of core dictionaries
51const DICT_FORME_JURIDIQUE = 1;
52const DICT_DEPARTEMENTS = 2;
53const DICT_REGIONS = 3;
54const DICT_COUNTRY = 4;
55const DICT_CIVILITY = 5;
56const DICT_ACTIONCOMM = 6;
57const DICT_CHARGESOCIALES = 7;
58const DICT_TYPENT = 8;
59const DICT_CURRENCIES = 9;
60const DICT_TVA = 10;
61const DICT_TYPE_CONTACT = 11;
62const DICT_PAYMENT_TERM = 12;
63const DICT_PAIEMENT = 13;
64const DICT_ECOTAXE = 14;
65const DICT_PAPER_FORMAT = 15;
66const DICT_PROSPECTLEVEL = 16;
67const DICT_TYPE_FEES = 17;
68const DICT_SHIPMENT_MODE = 18;
69const DICT_EFFECTIF = 19;
70const DICT_INPUT_METHOD = 20;
71const DICT_AVAILABILITY = 21;
72const DICT_INPUT_REASON = 22;
73const DICT_REVENUESTAMP = 23;
74const DICT_TYPE_RESOURCE = 24;
75const DICT_TYPE_CONTAINER = 25;
76//const DICT_UNITS = 26;
77const DICT_STCOMM = 27;
78const DICT_HOLIDAY_TYPES = 28;
79const DICT_LEAD_STATUS = 29;
80const DICT_FORMAT_CARDS = 30;
81const DICT_INVOICE_SUBTYPE = 31;
82const DICT_HRM_PUBLIC_HOLIDAY = 32;
83const DICT_HRM_DEPARTMENT = 33;
84const DICT_HRM_FUNCTION = 34;
85const DICT_EXP_TAX_CAT = 35;
86const DICT_EXP_TAX_RANGE = 36;
87const DICT_UNITS = 37;
88const DICT_SOCIALNETWORKS = 38;
89const DICT_PROSPECTCONTACTLEVEL = 39;
90const DICT_STCOMMCONTACT = 40;
91const DICT_TRANSPORT_MODE = 41;
92const DICT_PRODUCT_NATURE = 42;
93const DICT_PRODUCTBATCH_QCSTATUS = 43;
94const DICT_ASSET_DISPOSAL_TYPE = 44;
95
105// Load translation files required by the page
106$langs->loadLangs(array("errors", "admin", "main", "companies", "resource", "holiday", "accountancy", "hrm", "orders", "contracts", "projects", "propal", "bills", "interventions", "ticket"));
107
108$action = GETPOST('action', 'alpha') ? GETPOST('action', 'alpha') : 'view';
109$confirm = GETPOST('confirm', 'alpha');
110
111$id = GETPOSTINT('id');
112$rowid = GETPOST('rowid', 'alpha');
113$entity = GETPOST('entity', 'alpha'); // Do not use GETPOSTINT here. Should be '', 0 or >0.
114$code = GETPOST('code', 'alpha');
115$from = GETPOST('from', 'alpha');
116
117$acts = array();
118$actl = array();
119$acts[0] = "activate";
120$acts[1] = "disable";
121$actl[0] = img_picto($langs->trans("Disabled"), 'switch_off', 'class="size15x"');
122$actl[1] = img_picto($langs->trans("Activated"), 'switch_on', 'class="size15x"');
123
124// Load variable for pagination
125$listoffset = GETPOST('listoffset');
126$listlimit = GETPOST('listlimit') > 0 ? GETPOST('listlimit') : 1000; // To avoid too long dictionaries
127$sortfield = GETPOST('sortfield', 'aZ09comma');
128$sortorder = GETPOST('sortorder', 'aZ09comma');
129$page = GETPOSTISSET('pageplusone') ? (GETPOSTINT('pageplusone') - 1) : GETPOSTINT("page");
130if (empty($page) || $page < 0 || GETPOST('button_search', 'alpha') || GETPOST('button_removefilter', 'alpha')) {
131 // If $page is not defined, or '' or -1 or if we click on clear filters
132 $page = 0;
133}
134$offset = $listlimit * $page;
135$pageprev = $page - 1;
136$pagenext = $page + 1;
137
138$search_country_id = GETPOST('search_country_id', 'int');
139$search_code = GETPOST('search_code', 'alpha');
140$search_active = GETPOST('search_active', 'alpha');
141
142// Special case to set a default value for country according to dictionary
143if (!GETPOSTISSET('search_country_id') && $search_country_id == '' && ($id == DICT_DEPARTEMENTS || $id == DICT_REGIONS || $id == DICT_TVA)) { // Not a so good idea to force on current country for all dictionaries. Some tables have entries that are for all countries, we must be able to see them, so this is done for dedicated dictionaries only.
144 $search_country_id = $mysoc->country_id;
145}
146
147// Initialize a technical object to manage hooks of page. Note that conf->hooks_modules contains an array of hook context
148$hookmanager->initHooks(array('admin', 'dictionaryadmin'));
149
150$allowed = $user->admin;
151if ($id == DICT_CHARGESOCIALES && $user->hasRight('accounting', 'chartofaccount')) {
152 $allowed = 1; // Tax page allowed to manager of chart account
153}
154if ($id == DICT_TVA && $user->hasRight('accounting', 'chartofaccount')) {
155 $allowed = 1; // Vat page allowed to manager of chart account
156}
157if ($id == DICT_TYPE_FEES && $user->hasRight('accounting', 'chartofaccount')) {
158 $allowed = 1; // Dictionary with type of expense report and accounting account allowed to manager of chart account
159}
160if (!$allowed) {
162}
163
164$permissiontoadd = $allowed;
165
166
167// This page is a generic page to edit dictionaries
168// Put here declaration of dictionaries properties
169
170// Sort order to show dictionary (0 is space). All other dictionaries (added by modules) will be at end of this.
171$taborder = array(DICT_CURRENCIES, DICT_PAPER_FORMAT, DICT_FORMAT_CARDS, 0, DICT_COUNTRY, DICT_REGIONS, DICT_DEPARTEMENTS, 0, DICT_FORME_JURIDIQUE, DICT_TYPENT, DICT_EFFECTIF, DICT_PROSPECTLEVEL, DICT_PROSPECTCONTACTLEVEL, DICT_STCOMM, DICT_STCOMMCONTACT, DICT_SOCIALNETWORKS, 0, DICT_CIVILITY, DICT_TYPE_CONTACT, 0, DICT_ACTIONCOMM, DICT_TYPE_RESOURCE, 0, DICT_LEAD_STATUS, 0, DICT_HRM_DEPARTMENT, DICT_HRM_FUNCTION, DICT_HRM_PUBLIC_HOLIDAY, DICT_HOLIDAY_TYPES, DICT_TYPE_FEES, DICT_EXP_TAX_CAT, DICT_EXP_TAX_RANGE, 0, DICT_TVA, DICT_INVOICE_SUBTYPE, DICT_REVENUESTAMP, DICT_PAYMENT_TERM, DICT_PAIEMENT, DICT_CHARGESOCIALES, 0, DICT_ECOTAXE, 0, DICT_INPUT_REASON, DICT_INPUT_METHOD, DICT_SHIPMENT_MODE, DICT_AVAILABILITY, DICT_TRANSPORT_MODE, 0, DICT_UNITS, DICT_PRODUCT_NATURE, 0, DICT_PRODUCTBATCH_QCSTATUS, 0, DICT_TYPE_CONTAINER, 0, DICT_ASSET_DISPOSAL_TYPE, 0);
172
173// Name of SQL tables of dictionaries
174$tabname = array();
175$tabname[DICT_FORME_JURIDIQUE] = "c_forme_juridique";
176$tabname[DICT_DEPARTEMENTS] = "c_departements";
177$tabname[DICT_REGIONS] = "c_regions";
178$tabname[DICT_COUNTRY] = "c_country";
179$tabname[DICT_CIVILITY] = "c_civility";
180$tabname[DICT_ACTIONCOMM] = "c_actioncomm";
181$tabname[DICT_CHARGESOCIALES] = "c_chargesociales";
182$tabname[DICT_TYPENT] = "c_typent";
183$tabname[DICT_CURRENCIES] = "c_currencies";
184$tabname[DICT_TVA] = "c_tva";
185$tabname[DICT_TYPE_CONTACT] = "c_type_contact";
186$tabname[DICT_PAYMENT_TERM] = "c_payment_term";
187$tabname[DICT_PAIEMENT] = "c_paiement";
188$tabname[DICT_ECOTAXE] = "c_ecotaxe";
189$tabname[DICT_PAPER_FORMAT] = "c_paper_format";
190$tabname[DICT_PROSPECTLEVEL] = "c_prospectlevel";
191$tabname[DICT_TYPE_FEES] = "c_type_fees";
192$tabname[DICT_SHIPMENT_MODE] = "c_shipment_mode";
193$tabname[DICT_EFFECTIF] = "c_effectif";
194$tabname[DICT_INPUT_METHOD] = "c_input_method";
195$tabname[DICT_AVAILABILITY] = "c_availability";
196$tabname[DICT_INPUT_REASON] = "c_input_reason";
197$tabname[DICT_REVENUESTAMP] = "c_revenuestamp";
198$tabname[DICT_TYPE_RESOURCE] = "c_type_resource";
199$tabname[DICT_TYPE_CONTAINER] = "c_type_container";
200//$tabname[DICT_UNITS]= "c_units";
201$tabname[DICT_STCOMM] = "c_stcomm";
202$tabname[DICT_HOLIDAY_TYPES] = "c_holiday_types";
203$tabname[DICT_LEAD_STATUS] = "c_lead_status";
204$tabname[DICT_FORMAT_CARDS] = "c_format_cards";
205$tabname[DICT_INVOICE_SUBTYPE] = "c_invoice_subtype";
206$tabname[DICT_HRM_PUBLIC_HOLIDAY] = "c_hrm_public_holiday";
207$tabname[DICT_HRM_DEPARTMENT] = "c_hrm_department";
208$tabname[DICT_HRM_FUNCTION] = "c_hrm_function";
209$tabname[DICT_EXP_TAX_CAT] = "c_exp_tax_cat";
210$tabname[DICT_EXP_TAX_RANGE] = "c_exp_tax_range";
211$tabname[DICT_UNITS] = "c_units";
212$tabname[DICT_SOCIALNETWORKS] = "c_socialnetworks";
213$tabname[DICT_PROSPECTCONTACTLEVEL] = "c_prospectcontactlevel";
214$tabname[DICT_STCOMMCONTACT] = "c_stcommcontact";
215$tabname[DICT_TRANSPORT_MODE] = "c_transport_mode";
216$tabname[DICT_PRODUCT_NATURE] = "c_product_nature";
217$tabname[DICT_PRODUCTBATCH_QCSTATUS] = "c_productbatch_qcstatus";
218$tabname[DICT_ASSET_DISPOSAL_TYPE] = "c_asset_disposal_type";
219
220// Dictionary labels
221$tablib = array();
222$tablib[DICT_FORME_JURIDIQUE] = "DictionaryCompanyJuridicalType";
223$tablib[DICT_DEPARTEMENTS] = "DictionaryCanton";
224$tablib[DICT_REGIONS] = "DictionaryRegion";
225$tablib[DICT_COUNTRY] = "DictionaryCountry";
226$tablib[DICT_CIVILITY] = "DictionaryCivility";
227$tablib[DICT_ACTIONCOMM] = "DictionaryActions";
228$tablib[DICT_CHARGESOCIALES] = "DictionarySocialContributions";
229$tablib[DICT_TYPENT] = "DictionaryCompanyType";
230$tablib[DICT_CURRENCIES] = "DictionaryCurrency";
231$tablib[DICT_TVA] = "DictionaryVAT";
232$tablib[DICT_TYPE_CONTACT] = "DictionaryTypeContact";
233$tablib[DICT_PAYMENT_TERM] = "DictionaryPaymentConditions";
234$tablib[DICT_PAIEMENT] = "DictionaryPaymentModes";
235$tablib[DICT_ECOTAXE] = "DictionaryEcotaxe";
236$tablib[DICT_PAPER_FORMAT] = "DictionaryPaperFormat";
237$tablib[DICT_PROSPECTLEVEL] = "DictionaryProspectLevel";
238$tablib[DICT_TYPE_FEES] = "DictionaryFees";
239$tablib[DICT_SHIPMENT_MODE] = "DictionarySendingMethods";
240$tablib[DICT_EFFECTIF] = "DictionaryStaff";
241$tablib[DICT_INPUT_METHOD] = "DictionaryOrderMethods";
242$tablib[DICT_AVAILABILITY] = "DictionaryAvailability";
243$tablib[DICT_INPUT_REASON] = "DictionarySource";
244$tablib[DICT_REVENUESTAMP] = "DictionaryRevenueStamp";
245$tablib[DICT_TYPE_RESOURCE] = "DictionaryResourceType";
246$tablib[DICT_TYPE_CONTAINER] = "DictionaryTypeOfContainer";
247//$tablib[DICT_UNITS]= "DictionaryUnits";
248$tablib[DICT_STCOMM] = "DictionaryProspectStatus";
249$tablib[DICT_HOLIDAY_TYPES] = "DictionaryHolidayTypes";
250$tablib[DICT_LEAD_STATUS] = "DictionaryOpportunityStatus";
251$tablib[DICT_FORMAT_CARDS] = "DictionaryFormatCards";
252$tablib[DICT_INVOICE_SUBTYPE] = "DictionaryInvoiceSubtype";
253$tablib[DICT_HRM_PUBLIC_HOLIDAY] = "DictionaryPublicHolidays";
254$tablib[DICT_HRM_DEPARTMENT] = "DictionaryDepartment";
255$tablib[DICT_HRM_FUNCTION] = "DictionaryFunction";
256$tablib[DICT_EXP_TAX_CAT] = "DictionaryExpenseTaxCat";
257$tablib[DICT_EXP_TAX_RANGE] = "DictionaryExpenseTaxRange";
258$tablib[DICT_UNITS] = "DictionaryMeasuringUnits";
259$tablib[DICT_SOCIALNETWORKS] = "DictionarySocialNetworks";
260$tablib[DICT_PROSPECTCONTACTLEVEL] = "DictionaryProspectContactLevel";
261$tablib[DICT_STCOMMCONTACT] = "DictionaryProspectContactStatus";
262$tablib[DICT_TRANSPORT_MODE] = "DictionaryTransportMode";
263$tablib[DICT_PRODUCT_NATURE] = "DictionaryProductNature";
264$tablib[DICT_PRODUCTBATCH_QCSTATUS] = "DictionaryBatchStatus";
265$tablib[DICT_ASSET_DISPOSAL_TYPE] = "DictionaryAssetDisposalType";
266
267// Requests to extract data
268$tabsql = array();
269$tabsql[DICT_FORME_JURIDIQUE] = "SELECT f.rowid as rowid, f.code, f.libelle, c.code as country_code, c.label as country, f.active FROM ".MAIN_DB_PREFIX."c_forme_juridique as f, ".MAIN_DB_PREFIX."c_country as c WHERE f.fk_pays=c.rowid";
270$tabsql[DICT_DEPARTEMENTS] = "SELECT d.rowid as rowid, d.code_departement as code, d.nom as libelle, d.fk_region as region_id, r.nom as region, c.code as country_code, c.label as country, d.active FROM ".MAIN_DB_PREFIX."c_departements as d, ".MAIN_DB_PREFIX."c_regions as r, ".MAIN_DB_PREFIX."c_country as c WHERE d.fk_region=r.code_region and r.fk_pays=c.rowid and r.active=1 and c.active=1";
271$tabsql[DICT_REGIONS] = "SELECT r.rowid as rowid, r.code_region as code, r.nom as libelle, r.fk_pays as country_id, c.code as country_code, c.label as country, r.active FROM ".MAIN_DB_PREFIX."c_regions as r, ".MAIN_DB_PREFIX."c_country as c WHERE r.fk_pays=c.rowid and c.active=1";
272$tabsql[DICT_COUNTRY] = "SELECT c.rowid as rowid, c.code, c.label, c.active, c.favorite, c.eec, c.sepa FROM ".MAIN_DB_PREFIX."c_country AS c";
273$tabsql[DICT_CIVILITY] = "SELECT c.rowid as rowid, c.code as code, c.label, c.active FROM ".MAIN_DB_PREFIX."c_civility AS c";
274$tabsql[DICT_ACTIONCOMM] = "SELECT a.id as rowid, a.code as code, a.libelle AS libelle, a.type, a.active, a.module, a.color, a.position FROM ".MAIN_DB_PREFIX."c_actioncomm AS a";
275$tabsql[DICT_CHARGESOCIALES] = "SELECT a.id as rowid, a.code as code, a.libelle AS libelle, a.accountancy_code as accountancy_code, c.code as country_code, c.label as country, a.fk_pays as country_id, a.active FROM ".MAIN_DB_PREFIX."c_chargesociales AS a, ".MAIN_DB_PREFIX."c_country as c WHERE a.fk_pays = c.rowid and c.active = 1";
276$tabsql[DICT_TYPENT] = "SELECT t.id as rowid, t.code as code, t.libelle, t.fk_country as country_id, c.code as country_code, c.label as country, t.position, t.module, t.active FROM ".MAIN_DB_PREFIX."c_typent as t LEFT JOIN ".MAIN_DB_PREFIX."c_country as c ON t.fk_country=c.rowid";
277$tabsql[DICT_CURRENCIES] = "SELECT c.code_iso as code, c.label, c.unicode, c.active FROM ".MAIN_DB_PREFIX."c_currencies AS c";
278$tabsql[DICT_TVA] = "SELECT t.rowid, t.entity, t.code, t.type_vat, t.taux, t.localtax1_type, t.localtax1, t.localtax2_type, t.localtax2, c.label as country, c.code as country_code, t.fk_pays as country_id, t.fk_department_buyer as department_buyer_id, db.nom as department_buyer, t.recuperableonly, t.note, t.active, t.accountancy_code_sell, t.accountancy_code_buy, t.use_default FROM ".MAIN_DB_PREFIX."c_tva as t INNER JOIN ".MAIN_DB_PREFIX."c_country as c ON t.fk_pays = c.rowid LEFT JOIN ".MAIN_DB_PREFIX."c_departements as db ON t.fk_department_buyer = db.rowid WHERE t.entity IN (".getEntity($tabname[DICT_TVA]).")";
279$tabsql[DICT_TYPE_CONTACT] = "SELECT t.rowid as rowid, t.element, t.source, t.code, t.libelle, t.position, t.active FROM ".MAIN_DB_PREFIX."c_type_contact AS t";
280$tabsql[DICT_PAYMENT_TERM] = "SELECT c.rowid as rowid, c.code, c.libelle, c.libelle_facture, c.deposit_percent, c.nbjour, c.type_cdr, c.decalage, c.active, c.sortorder, c.entity FROM ".MAIN_DB_PREFIX."c_payment_term AS c WHERE c.entity IN (".getEntity($tabname[DICT_PAYMENT_TERM]).")";
281$tabsql[DICT_PAIEMENT] = "SELECT c.id as rowid, c.code, c.libelle, c.type, c.active, c.entity FROM ".MAIN_DB_PREFIX."c_paiement AS c WHERE c.entity IN (".getEntity($tabname[DICT_PAIEMENT]).")";
282$tabsql[DICT_ECOTAXE] = "SELECT e.rowid as rowid, e.code as code, e.label, e.price, e.organization, e.fk_pays as country_id, c.code as country_code, c.label as country, e.active FROM ".MAIN_DB_PREFIX."c_ecotaxe AS e, ".MAIN_DB_PREFIX."c_country as c WHERE e.fk_pays=c.rowid and c.active=1";
283$tabsql[DICT_PAPER_FORMAT] = "SELECT t.rowid as rowid, t.code, t.label as libelle, t.width, t.height, t.unit, t.active FROM ".MAIN_DB_PREFIX."c_paper_format as t";
284$tabsql[DICT_PROSPECTLEVEL] = "SELECT t.code, t.label as libelle, t.sortorder, t.active FROM ".MAIN_DB_PREFIX."c_prospectlevel as t";
285$tabsql[DICT_TYPE_FEES] = "SELECT t.id as rowid, t.code, t.label, t.accountancy_code, t.active FROM ".MAIN_DB_PREFIX."c_type_fees as t";
286$tabsql[DICT_SHIPMENT_MODE] = "SELECT t.rowid as rowid, t.code, t.libelle, t.tracking, t.active FROM ".MAIN_DB_PREFIX."c_shipment_mode as t";
287$tabsql[DICT_EFFECTIF] = "SELECT t.id as rowid, t.code, t.libelle, t.active FROM ".MAIN_DB_PREFIX."c_effectif as t";
288$tabsql[DICT_INPUT_METHOD] = "SELECT t.rowid as rowid, t.code, t.libelle, t.active FROM ".MAIN_DB_PREFIX."c_input_method as t";
289$tabsql[DICT_AVAILABILITY] = "SELECT c.rowid as rowid, c.code, c.label, c.type_duration, c.qty, c.active, c.position FROM ".MAIN_DB_PREFIX."c_availability AS c";
290$tabsql[DICT_INPUT_REASON] = "SELECT t.rowid as rowid, t.code, t.label, t.active FROM ".MAIN_DB_PREFIX."c_input_reason as t";
291$tabsql[DICT_REVENUESTAMP] = "SELECT t.rowid as rowid, t.taux, t.revenuestamp_type, c.label as country, c.code as country_code, t.fk_pays as country_id, t.note, t.active, t.accountancy_code_sell, t.accountancy_code_buy FROM ".MAIN_DB_PREFIX."c_revenuestamp as t, ".MAIN_DB_PREFIX."c_country as c WHERE t.fk_pays=c.rowid";
292$tabsql[DICT_TYPE_RESOURCE] = "SELECT t.rowid as rowid, t.code, t.label, t.active FROM ".MAIN_DB_PREFIX."c_type_resource as t";
293$tabsql[DICT_TYPE_CONTAINER] = "SELECT t.rowid as rowid, t.code, t.label, t.active, t.module FROM ".MAIN_DB_PREFIX."c_type_container as t WHERE t.entity IN (".getEntity($tabname[DICT_TYPE_CONTAINER]).")";
294//$tabsql[DICT_UNITS]= "SELECT t.rowid as rowid, t.code, t.label, t.short_label, t.active FROM ".MAIN_DB_PREFIX."c_units as t";
295$tabsql[DICT_STCOMM] = "SELECT t.id as rowid, t.code, t.libelle, t.picto, t.active FROM ".MAIN_DB_PREFIX."c_stcomm as t";
296$tabsql[DICT_HOLIDAY_TYPES] = "SELECT h.rowid as rowid, h.code, h.label, h.affect, h.delay, h.newbymonth, h.fk_country as country_id, c.code as country_code, c.label as country, h.block_if_negative, h.sortorder, h.active FROM ".MAIN_DB_PREFIX."c_holiday_types as h LEFT JOIN ".MAIN_DB_PREFIX."c_country as c ON h.fk_country=c.rowid WHERE h.entity IN (".getEntity($tabname[DICT_HOLIDAY_TYPES]).")";
297$tabsql[DICT_LEAD_STATUS] = "SELECT t.rowid as rowid, t.code, t.label, percent, t.position, t.active FROM ".MAIN_DB_PREFIX."c_lead_status as t";
298$tabsql[DICT_FORMAT_CARDS] = "SELECT t.rowid, t.code, t.name, t.paper_size, t.orientation, t.metric, t.leftmargin, t.topmargin, t.nx, t.ny, t.spacex, t.spacey, t.width, t.height, t.font_size, t.custom_x, t.custom_y, t.active FROM ".MAIN_DB_PREFIX."c_format_cards as t";
299$tabsql[DICT_INVOICE_SUBTYPE] = "SELECT t.rowid, t.code, t.label, c.label as country, c.code as country_code, t.fk_country as country_id, t.active FROM ".MAIN_DB_PREFIX."c_invoice_subtype as t, ".MAIN_DB_PREFIX."c_country as c WHERE t.fk_country = c.rowid";
300$tabsql[DICT_HRM_PUBLIC_HOLIDAY] = "SELECT a.id as rowid, a.entity, a.code, a.fk_country as country_id, c.code as country_code, c.label as country, a.dayrule, a.day, a.month, a.year, a.active FROM ".MAIN_DB_PREFIX."c_hrm_public_holiday as a LEFT JOIN ".MAIN_DB_PREFIX."c_country as c ON a.fk_country=c.rowid AND c.active=1 WHERE a.entity IN (".getEntity($tabname[DICT_HRM_PUBLIC_HOLIDAY]).")";
301$tabsql[DICT_HRM_DEPARTMENT] = "SELECT t.rowid, t.pos, t.code, t.label, t.active FROM ".MAIN_DB_PREFIX."c_hrm_department as t";
302$tabsql[DICT_HRM_FUNCTION] = "SELECT t.rowid, t.pos, t.code, t.label, t.c_level, t.active FROM ".MAIN_DB_PREFIX."c_hrm_function as t";
303$tabsql[DICT_EXP_TAX_CAT] = "SELECT c.rowid, c.label, c.active, c.entity FROM ".MAIN_DB_PREFIX."c_exp_tax_cat as c";
304$tabsql[DICT_EXP_TAX_RANGE] = "SELECT r.rowid, r.fk_c_exp_tax_cat, r.range_ik, r.active, r.entity FROM ".MAIN_DB_PREFIX."c_exp_tax_range r";
305$tabsql[DICT_UNITS] = "SELECT r.rowid, r.code, r.sortorder, r.label, r.short_label, r.unit_type, r.scale, r.active FROM ".MAIN_DB_PREFIX."c_units r";
306$tabsql[DICT_SOCIALNETWORKS] = "SELECT s.rowid, s.entity, s.code, s.label, s.url, s.icon, s.active FROM ".MAIN_DB_PREFIX."c_socialnetworks as s WHERE s.entity IN (".getEntity($tabname[DICT_SOCIALNETWORKS]).")";
307$tabsql[DICT_PROSPECTCONTACTLEVEL] = "SELECT t.code, t.label as libelle, t.sortorder, t.active FROM ".MAIN_DB_PREFIX."c_prospectcontactlevel as t";
308$tabsql[DICT_STCOMMCONTACT] = "SELECT t.id as rowid, t.code, t.libelle, t.picto, t.active FROM ".MAIN_DB_PREFIX."c_stcommcontact as t";
309$tabsql[DICT_TRANSPORT_MODE] = "SELECT t.rowid as rowid, t.code, t.label, t.active FROM ".MAIN_DB_PREFIX."c_transport_mode as t";
310$tabsql[DICT_PRODUCT_NATURE] = "SELECT t.rowid as rowid, t.code, t.label, t.active FROM ".MAIN_DB_PREFIX."c_product_nature as t";
311$tabsql[DICT_PRODUCTBATCH_QCSTATUS] = "SELECT t.rowid, t.code, t.label, t.active FROM ".MAIN_DB_PREFIX."c_productbatch_qcstatus as t";
312$tabsql[DICT_ASSET_DISPOSAL_TYPE] = "SELECT t.rowid, t.code, t.label, t.active FROM ".MAIN_DB_PREFIX."c_asset_disposal_type as t";
313
314// Criteria to sort dictionaries
315$tabsqlsort = array();
316$tabsqlsort[DICT_FORME_JURIDIQUE] = "country ASC, code ASC";
317$tabsqlsort[DICT_DEPARTEMENTS] = "country ASC, code ASC";
318$tabsqlsort[DICT_REGIONS] = "country ASC, code ASC";
319$tabsqlsort[DICT_COUNTRY] = "code ASC";
320$tabsqlsort[DICT_CIVILITY] = "label ASC";
321$tabsqlsort[DICT_ACTIONCOMM] = "a.type ASC, a.module ASC, a.position ASC, a.code ASC";
322$tabsqlsort[DICT_CHARGESOCIALES] = "c.label ASC, a.code ASC, a.libelle ASC";
323$tabsqlsort[DICT_TYPENT] = "country DESC,".(getDolGlobalString('SOCIETE_SORT_ON_TYPEENT') ? ' t.position ASC,' : '')." libelle ASC";
324$tabsqlsort[DICT_CURRENCIES] = "label ASC";
325$tabsqlsort[DICT_TVA] = "country ASC, department_buyer ASC, code ASC, taux ASC, recuperableonly ASC, localtax1 ASC, localtax2 ASC";
326$tabsqlsort[DICT_TYPE_CONTACT] = "t.element ASC, t.source ASC, t.position ASC, t.code ASC";
327$tabsqlsort[DICT_PAYMENT_TERM] = "sortorder ASC, code ASC";
328$tabsqlsort[DICT_PAIEMENT] = "code ASC";
329$tabsqlsort[DICT_ECOTAXE] = "country ASC, e.organization ASC, code ASC";
330$tabsqlsort[DICT_PAPER_FORMAT] = "rowid ASC";
331$tabsqlsort[DICT_PROSPECTLEVEL] = "sortorder ASC";
332$tabsqlsort[DICT_TYPE_FEES] = "code ASC";
333$tabsqlsort[DICT_SHIPMENT_MODE] = "code ASC, libelle ASC";
334$tabsqlsort[DICT_EFFECTIF] = "id ASC";
335$tabsqlsort[DICT_INPUT_METHOD] = "code ASC, libelle ASC";
336$tabsqlsort[DICT_AVAILABILITY] = "position ASC, type_duration ASC, qty ASC";
337$tabsqlsort[DICT_INPUT_REASON] = "code ASC, label ASC";
338$tabsqlsort[DICT_REVENUESTAMP] = "country ASC, taux ASC";
339$tabsqlsort[DICT_TYPE_RESOURCE] = "code ASC, label ASC";
340$tabsqlsort[DICT_TYPE_CONTAINER] = "t.module ASC, t.code ASC, t.label ASC";
341//$tabsqlsort[DICT_UNITS]="code ASC";
342$tabsqlsort[DICT_STCOMM] = "code ASC";
343$tabsqlsort[DICT_HOLIDAY_TYPES] = "sortorder ASC, country ASC, code ASC";
344$tabsqlsort[DICT_LEAD_STATUS] = "position ASC";
345$tabsqlsort[DICT_FORMAT_CARDS] = "code ASC";
346$tabsqlsort[DICT_INVOICE_SUBTYPE] = "country ASC, code ASC";
347$tabsqlsort[DICT_HRM_PUBLIC_HOLIDAY] = "country, year ASC, month ASC, day ASC";
348$tabsqlsort[DICT_HRM_DEPARTMENT] = "code ASC";
349$tabsqlsort[DICT_HRM_FUNCTION] = "code ASC";
350$tabsqlsort[DICT_EXP_TAX_CAT] = "c.label ASC";
351$tabsqlsort[DICT_EXP_TAX_RANGE] = "r.fk_c_exp_tax_cat ASC, r.range_ik ASC";
352$tabsqlsort[DICT_UNITS] = "sortorder ASC";
353$tabsqlsort[DICT_SOCIALNETWORKS] = "rowid, code ASC";
354$tabsqlsort[DICT_PROSPECTCONTACTLEVEL] = "sortorder ASC";
355$tabsqlsort[DICT_STCOMMCONTACT] = "code ASC";
356$tabsqlsort[DICT_TRANSPORT_MODE] = "code ASC";
357$tabsqlsort[DICT_PRODUCT_NATURE] = "code ASC";
358$tabsqlsort[DICT_PRODUCTBATCH_QCSTATUS] = "code ASC";
359$tabsqlsort[DICT_ASSET_DISPOSAL_TYPE] = "code ASC";
360
361// Field names in select result for dictionary display
362$tabfield = array();
363$tabfield[DICT_FORME_JURIDIQUE] = "code,libelle,country";
364$tabfield[DICT_DEPARTEMENTS] = "code,libelle,region_id,region,country"; // "code,libelle,region,country_code-country"
365$tabfield[DICT_REGIONS] = "code,libelle,country_id,country";
366$tabfield[DICT_COUNTRY] = "code,label";
367$tabfield[DICT_CIVILITY] = "code,label";
368$tabfield[DICT_ACTIONCOMM] = "code,libelle,type,color,position";
369$tabfield[DICT_CHARGESOCIALES] = "code,libelle,country,accountancy_code";
370$tabfield[DICT_TYPENT] = "code,libelle,module,country_id,country".(getDolGlobalString('SOCIETE_SORT_ON_TYPEENT') ? ',position' : '');
371$tabfield[DICT_CURRENCIES] = "code,label,unicode";
372$tabfield[DICT_TVA] = "country_id,country,department_buyer_id,department_buyer,code,type_vat,taux,localtax1_type,localtax1,localtax2_type,localtax2,recuperableonly,accountancy_code_sell,accountancy_code_buy,use_default,note";
373$tabfield[DICT_TYPE_CONTACT] = "element,source,code,libelle,position";
374$tabfield[DICT_PAYMENT_TERM] = "code,libelle,libelle_facture,deposit_percent,nbjour,type_cdr,decalage,sortorder";
375$tabfield[DICT_PAIEMENT] = "code,libelle,type";
376$tabfield[DICT_ECOTAXE] = "code,label,price,organization,country";
377$tabfield[DICT_PAPER_FORMAT] = "code,libelle,width,height,unit";
378$tabfield[DICT_PROSPECTLEVEL] = "code,libelle,sortorder";
379$tabfield[DICT_TYPE_FEES] = "code,label,accountancy_code";
380$tabfield[DICT_SHIPMENT_MODE] = "code,libelle,tracking";
381$tabfield[DICT_EFFECTIF] = "code,libelle";
382$tabfield[DICT_INPUT_METHOD] = "code,libelle";
383$tabfield[DICT_AVAILABILITY] = "code,label,qty,type_duration,position";
384$tabfield[DICT_INPUT_REASON] = "code,label";
385$tabfield[DICT_REVENUESTAMP] = "country_id,country,taux,revenuestamp_type,accountancy_code_sell,accountancy_code_buy,note";
386$tabfield[DICT_TYPE_RESOURCE] = "code,label";
387$tabfield[DICT_TYPE_CONTAINER] = "code,label";
388//$tabfield[DICT_UNITS]= "code,label,short_label";
389$tabfield[DICT_STCOMM] = "code,libelle,picto";
390$tabfield[DICT_HOLIDAY_TYPES] = "code,label,affect,delay,newbymonth,country_id,country,block_if_negative,sortorder";
391$tabfield[DICT_LEAD_STATUS] = "code,label,percent,position";
392$tabfield[DICT_FORMAT_CARDS] = "code,name,paper_size,orientation,metric,leftmargin,topmargin,nx,ny,spacex,spacey,width,height,font_size,custom_x,custom_y";
393$tabfield[DICT_INVOICE_SUBTYPE] = "country_id,country,code,label";
394$tabfield[DICT_HRM_PUBLIC_HOLIDAY] = "code,dayrule,year,month,day,country_id,country";
395$tabfield[DICT_HRM_DEPARTMENT] = "code,label";
396$tabfield[DICT_HRM_FUNCTION] = "code,label";
397$tabfield[DICT_EXP_TAX_CAT] = "label";
398$tabfield[DICT_EXP_TAX_RANGE] = "range_ik,fk_c_exp_tax_cat";
399$tabfield[DICT_UNITS] = "code,label,short_label,unit_type,scale,sortorder";
400$tabfield[DICT_SOCIALNETWORKS] = "code,label,url,icon";
401$tabfield[DICT_PROSPECTCONTACTLEVEL] = "code,libelle,sortorder";
402$tabfield[DICT_STCOMMCONTACT] = "code,libelle,picto";
403$tabfield[DICT_TRANSPORT_MODE] = "code,label";
404$tabfield[DICT_PRODUCT_NATURE] = "code,label";
405$tabfield[DICT_PRODUCTBATCH_QCSTATUS] = "code,label";
406$tabfield[DICT_ASSET_DISPOSAL_TYPE] = "code,label";
407
408// Edit field names for editing a record
409$tabfieldvalue = array();
410$tabfieldvalue[DICT_FORME_JURIDIQUE] = "code,libelle,country";
411$tabfieldvalue[DICT_DEPARTEMENTS] = "code,libelle,region"; // "code,libelle,region"
412$tabfieldvalue[DICT_REGIONS] = "code,libelle,country";
413$tabfieldvalue[DICT_COUNTRY] = "code,label";
414$tabfieldvalue[DICT_CIVILITY] = "code,label";
415$tabfieldvalue[DICT_ACTIONCOMM] = "code,libelle,type,color,position";
416$tabfieldvalue[DICT_CHARGESOCIALES] = "code,libelle,country,accountancy_code";
417$tabfieldvalue[DICT_TYPENT] = "code,libelle,country".(getDolGlobalString('SOCIETE_SORT_ON_TYPEENT') ? ',position' : '');
418$tabfieldvalue[DICT_CURRENCIES] = "code,label,unicode";
419$tabfieldvalue[DICT_TVA] = "country,department_buyer_id,code,type_vat,taux,localtax1_type,localtax1,localtax2_type,localtax2,recuperableonly,accountancy_code_sell,accountancy_code_buy,use_default,note";
420$tabfieldvalue[DICT_TYPE_CONTACT] = "element,source,code,libelle,position";
421$tabfieldvalue[DICT_PAYMENT_TERM] = "code,libelle,libelle_facture,deposit_percent,nbjour,type_cdr,decalage,sortorder";
422$tabfieldvalue[DICT_PAIEMENT] = "code,libelle,type";
423$tabfieldvalue[DICT_ECOTAXE] = "code,label,price,organization,country";
424$tabfieldvalue[DICT_PAPER_FORMAT] = "code,libelle,width,height,unit";
425$tabfieldvalue[DICT_PROSPECTLEVEL] = "code,libelle,sortorder";
426$tabfieldvalue[DICT_TYPE_FEES] = "code,label,accountancy_code";
427$tabfieldvalue[DICT_SHIPMENT_MODE] = "code,libelle,tracking";
428$tabfieldvalue[DICT_EFFECTIF] = "code,libelle";
429$tabfieldvalue[DICT_INPUT_METHOD] = "code,libelle";
430$tabfieldvalue[DICT_AVAILABILITY] = "code,label,qty,type_duration,position";
431$tabfieldvalue[DICT_INPUT_REASON] = "code,label";
432$tabfieldvalue[DICT_REVENUESTAMP] = "country,taux,revenuestamp_type,accountancy_code_sell,accountancy_code_buy,note";
433$tabfieldvalue[DICT_TYPE_RESOURCE] = "code,label";
434$tabfieldvalue[DICT_TYPE_CONTAINER] = "code,label";
435//$tabfieldvalue[DICT_UNITS]= "code,label,short_label";
436$tabfieldvalue[DICT_STCOMM] = "code,libelle,picto";
437$tabfieldvalue[DICT_HOLIDAY_TYPES] = "code,label,affect,delay,newbymonth,country,block_if_negative,sortorder";
438$tabfieldvalue[DICT_LEAD_STATUS] = "code,label,percent,position";
439$tabfieldvalue[DICT_FORMAT_CARDS] = "code,name,paper_size,orientation,metric,leftmargin,topmargin,nx,ny,spacex,spacey,width,height,font_size,custom_x,custom_y";
440$tabfieldvalue[DICT_INVOICE_SUBTYPE] = "country,code,label";
441$tabfieldvalue[DICT_HRM_PUBLIC_HOLIDAY] = "code,dayrule,day,month,year,country";
442$tabfieldvalue[DICT_HRM_DEPARTMENT] = "code,label";
443$tabfieldvalue[DICT_HRM_FUNCTION] = "code,label";
444$tabfieldvalue[DICT_EXP_TAX_CAT] = "label";
445$tabfieldvalue[DICT_EXP_TAX_RANGE] = "range_ik,fk_c_exp_tax_cat";
446$tabfieldvalue[DICT_UNITS] = "code,label,short_label,unit_type,scale,sortorder";
447$tabfieldvalue[DICT_SOCIALNETWORKS] = "code,label,url,icon";
448$tabfieldvalue[DICT_PROSPECTCONTACTLEVEL] = "code,libelle,sortorder";
449$tabfieldvalue[DICT_STCOMMCONTACT] = "code,libelle,picto";
450$tabfieldvalue[DICT_TRANSPORT_MODE] = "code,label";
451$tabfieldvalue[DICT_PRODUCT_NATURE] = "code,label";
452$tabfieldvalue[DICT_PRODUCTBATCH_QCSTATUS] = "code,label";
453$tabfieldvalue[DICT_ASSET_DISPOSAL_TYPE] = "code,label";
454
455// Field names in the table for inserting a record (add field "entity" only here when dictionary is ready to personalized by entity)
456$tabfieldinsert = array();
457$tabfieldinsert[DICT_FORME_JURIDIQUE] = "code,libelle,fk_pays";
458$tabfieldinsert[DICT_DEPARTEMENTS] = "code_departement,nom,fk_region";
459$tabfieldinsert[DICT_REGIONS] = "code_region,nom,fk_pays";
460$tabfieldinsert[DICT_COUNTRY] = "code,label";
461$tabfieldinsert[DICT_CIVILITY] = "code,label";
462$tabfieldinsert[DICT_ACTIONCOMM] = "code,libelle,type,color,position";
463$tabfieldinsert[DICT_CHARGESOCIALES] = "code,libelle,fk_pays,accountancy_code";
464$tabfieldinsert[DICT_TYPENT] = "code,libelle,fk_country".(getDolGlobalString('SOCIETE_SORT_ON_TYPEENT') ? ',position' : '');
465$tabfieldinsert[DICT_CURRENCIES] = "code_iso,label,unicode";
466$tabfieldinsert[DICT_TVA] = "fk_pays,fk_department_buyer,code,type_vat,taux,localtax1_type,localtax1,localtax2_type,localtax2,recuperableonly,accountancy_code_sell,accountancy_code_buy,use_default,note,entity";
467$tabfieldinsert[DICT_TYPE_CONTACT] = "element,source,code,libelle,position";
468$tabfieldinsert[DICT_PAYMENT_TERM] = "code,libelle,libelle_facture,deposit_percent,nbjour,type_cdr,decalage,sortorder,entity";
469$tabfieldinsert[DICT_PAIEMENT] = "code,libelle,type,entity";
470$tabfieldinsert[DICT_ECOTAXE] = "code,label,price,organization,fk_pays";
471$tabfieldinsert[DICT_PAPER_FORMAT] = "code,label,width,height,unit";
472$tabfieldinsert[DICT_PROSPECTLEVEL] = "code,label,sortorder";
473$tabfieldinsert[DICT_TYPE_FEES] = "code,label,accountancy_code";
474$tabfieldinsert[DICT_SHIPMENT_MODE] = "code,libelle,tracking";
475$tabfieldinsert[DICT_EFFECTIF] = "code,libelle";
476$tabfieldinsert[DICT_INPUT_METHOD] = "code,libelle";
477$tabfieldinsert[DICT_AVAILABILITY] = "code,label,qty,type_duration,position";
478$tabfieldinsert[DICT_INPUT_REASON] = "code,label";
479$tabfieldinsert[DICT_REVENUESTAMP] = "fk_pays,taux,revenuestamp_type,accountancy_code_sell,accountancy_code_buy,note";
480$tabfieldinsert[DICT_TYPE_RESOURCE] = "code,label";
481$tabfieldinsert[DICT_TYPE_CONTAINER] = "code,label,entity";
482//$tabfieldinsert[DICT_UNITS]= "code,label,short_label";
483$tabfieldinsert[DICT_STCOMM] = "code,libelle,picto";
484$tabfieldinsert[DICT_HOLIDAY_TYPES] = "code,label,affect,delay,newbymonth,fk_country,block_if_negative,sortorder,entity";
485$tabfieldinsert[DICT_LEAD_STATUS] = "code,label,percent,position";
486$tabfieldinsert[DICT_FORMAT_CARDS] = "code,name,paper_size,orientation,metric,leftmargin,topmargin,nx,ny,spacex,spacey,width,height,font_size,custom_x,custom_y";
487$tabfieldinsert[DICT_INVOICE_SUBTYPE] = "fk_country,code,label";
488$tabfieldinsert[DICT_HRM_PUBLIC_HOLIDAY] = "code,dayrule,day,month,year,fk_country,entity";
489$tabfieldinsert[DICT_HRM_DEPARTMENT] = "code,label";
490$tabfieldinsert[DICT_HRM_FUNCTION] = "code,label";
491$tabfieldinsert[DICT_EXP_TAX_CAT] = "label";
492$tabfieldinsert[DICT_EXP_TAX_RANGE] = "range_ik,fk_c_exp_tax_cat";
493$tabfieldinsert[DICT_UNITS] = "code,label,short_label,unit_type,scale,sortorder";
494$tabfieldinsert[DICT_SOCIALNETWORKS] = "code,label,url,icon,entity";
495$tabfieldinsert[DICT_PROSPECTCONTACTLEVEL] = "code,label,sortorder";
496$tabfieldinsert[DICT_STCOMMCONTACT] = "code,libelle,picto";
497$tabfieldinsert[DICT_TRANSPORT_MODE] = "code,label";
498$tabfieldinsert[DICT_PRODUCT_NATURE] = "code,label";
499$tabfieldinsert[DICT_PRODUCTBATCH_QCSTATUS] = "code,label";
500$tabfieldinsert[DICT_ASSET_DISPOSAL_TYPE] = "code,label";
501
502// Rowid name of field depending if field is autoincrement on or off..
503// Use "" if id field is "rowid" and has autoincrement on
504// Use "nameoffield" if id field is not "rowid" or has not autoincrement on
505$tabrowid = array();
506$tabrowid[DICT_FORME_JURIDIQUE] = "";
507$tabrowid[DICT_DEPARTEMENTS] = "";
508$tabrowid[DICT_REGIONS] = "";
509$tabrowid[DICT_COUNTRY] = "rowid";
510$tabrowid[DICT_CIVILITY] = "rowid";
511$tabrowid[DICT_ACTIONCOMM] = "id";
512$tabrowid[DICT_CHARGESOCIALES] = "id";
513$tabrowid[DICT_TYPENT] = "id";
514$tabrowid[DICT_CURRENCIES] = "code_iso";
515$tabrowid[DICT_TVA] = "";
516$tabrowid[DICT_TYPE_CONTACT] = "rowid";
517$tabrowid[DICT_PAYMENT_TERM] = "";
518$tabrowid[DICT_PAIEMENT] = "id";
519$tabrowid[DICT_ECOTAXE] = "";
520$tabrowid[DICT_PAPER_FORMAT] = "";
521$tabrowid[DICT_PROSPECTLEVEL] = "code";
522$tabrowid[DICT_TYPE_FEES] = "id";
523$tabrowid[DICT_SHIPMENT_MODE] = "rowid";
524$tabrowid[DICT_EFFECTIF] = "id";
525$tabrowid[DICT_INPUT_METHOD] = "";
526$tabrowid[DICT_AVAILABILITY] = "rowid";
527$tabrowid[DICT_INPUT_REASON] = "rowid";
528$tabrowid[DICT_REVENUESTAMP] = "";
529$tabrowid[DICT_TYPE_RESOURCE] = "";
530$tabrowid[DICT_TYPE_CONTAINER] = "";
531//$tabrowid[DICT_UNITS]= "";
532$tabrowid[DICT_STCOMM] = "id";
533$tabrowid[DICT_HOLIDAY_TYPES] = "";
534$tabrowid[DICT_LEAD_STATUS] = "";
535$tabrowid[DICT_FORMAT_CARDS] = "";
536$tabrowid[DICT_INVOICE_SUBTYPE] = "";
537$tabrowid[DICT_HRM_PUBLIC_HOLIDAY] = "id";
538$tabrowid[DICT_HRM_DEPARTMENT] = "rowid";
539$tabrowid[DICT_HRM_FUNCTION] = "rowid";
540$tabrowid[DICT_EXP_TAX_CAT] = "";
541$tabrowid[DICT_EXP_TAX_RANGE] = "";
542$tabrowid[DICT_UNITS] = "";
543$tabrowid[DICT_SOCIALNETWORKS] = "";
544$tabrowid[DICT_PROSPECTCONTACTLEVEL] = "code";
545$tabrowid[DICT_STCOMMCONTACT] = "id";
546$tabrowid[DICT_TRANSPORT_MODE] = "";
547$tabrowid[DICT_PRODUCT_NATURE] = "rowid";
548$tabrowid[DICT_PRODUCTBATCH_QCSTATUS] = "rowid";
549$tabrowid[DICT_ASSET_DISPOSAL_TYPE] = "rowid";
550
551// Condition to show dictionary in setup page
552$tabcond = array();
553$tabcond[DICT_FORME_JURIDIQUE] = (isModEnabled("societe"));
554$tabcond[DICT_DEPARTEMENTS] = true;
555$tabcond[DICT_REGIONS] = true;
556$tabcond[DICT_COUNTRY] = true;
557$tabcond[DICT_CIVILITY] = (isModEnabled("societe") || isModEnabled('member'));
558$tabcond[DICT_ACTIONCOMM] = isModEnabled('agenda');
559$tabcond[DICT_CHARGESOCIALES] = isModEnabled('tax');
560$tabcond[DICT_TYPENT] = isModEnabled("societe");
561$tabcond[DICT_CURRENCIES] = true;
562$tabcond[DICT_TVA] = true;
563$tabcond[DICT_TYPE_CONTACT] = (isModEnabled("societe"));
564$tabcond[DICT_PAYMENT_TERM] = (isModEnabled('order') || isModEnabled("propal") || isModEnabled('invoice') || isModEnabled("supplier_invoice") || isModEnabled("supplier_order"));
565$tabcond[DICT_PAIEMENT] = (isModEnabled('order') || isModEnabled("propal") || isModEnabled('invoice') || isModEnabled("supplier_invoice") || isModEnabled("supplier_order"));
566$tabcond[DICT_ECOTAXE] = (isModEnabled("product") && (isModEnabled('ecotax') || getDolGlobalString('MAIN_SHOW_ECOTAX_DICTIONNARY')));
567$tabcond[DICT_PAPER_FORMAT] = true;
568$tabcond[DICT_PROSPECTLEVEL] = (isModEnabled("societe") && !getDolGlobalString('SOCIETE_DISABLE_PROSPECTS'));
569$tabcond[DICT_TYPE_FEES] = (isModEnabled('deplacement') || isModEnabled('expensereport'));
570$tabcond[DICT_SHIPMENT_MODE] = isModEnabled("shipping") || isModEnabled("reception");
571$tabcond[DICT_EFFECTIF] = isModEnabled("societe");
572$tabcond[DICT_INPUT_METHOD] = isModEnabled("supplier_order");
573$tabcond[DICT_AVAILABILITY] = isModEnabled("propal");
574$tabcond[DICT_INPUT_REASON] = (isModEnabled('order') || isModEnabled("propal"));
575$tabcond[DICT_REVENUESTAMP] = true;
576$tabcond[DICT_TYPE_RESOURCE] = isModEnabled('resource');
577$tabcond[DICT_TYPE_CONTAINER] = isModEnabled('website');
578//$tabcond[DICT_UNITS]= isModEnabled("product");
579$tabcond[DICT_STCOMM] = isModEnabled("societe");
580$tabcond[DICT_HOLIDAY_TYPES] = isModEnabled('holiday');
581$tabcond[DICT_LEAD_STATUS] = isModEnabled('project');
582$tabcond[DICT_FORMAT_CARDS] = (isModEnabled('label') || isModEnabled('barcode') || isModEnabled('member')); // stickers format dictionary
583$tabcond[DICT_INVOICE_SUBTYPE] = ((isModEnabled('invoice') || isModEnabled('supplier_invoice')) && $mysoc->country_code == 'GR');
584$tabcond[DICT_HRM_PUBLIC_HOLIDAY] = (isModEnabled('holiday') || isModEnabled('hrm'));
585$tabcond[DICT_HRM_DEPARTMENT] = isModEnabled('hrm');
586$tabcond[DICT_HRM_FUNCTION] = isModEnabled('hrm');
587$tabcond[DICT_EXP_TAX_CAT] = isModEnabled('expensereport') && getDolGlobalString('MAIN_USE_EXPENSE_IK');
588$tabcond[DICT_EXP_TAX_RANGE] = isModEnabled('expensereport') && getDolGlobalString('MAIN_USE_EXPENSE_IK');
589$tabcond[DICT_UNITS] = isModEnabled("product");
590$tabcond[DICT_SOCIALNETWORKS] = isModEnabled('socialnetworks');
591$tabcond[DICT_PROSPECTCONTACTLEVEL] = (isModEnabled("societe") && !getDolGlobalString('SOCIETE_DISABLE_PROSPECTS') && getDolGlobalString('THIRDPARTY_ENABLE_PROSPECTION_ON_ALTERNATIVE_ADRESSES'));
592$tabcond[DICT_STCOMMCONTACT] = (isModEnabled("societe") && getDolGlobalString('THIRDPARTY_ENABLE_PROSPECTION_ON_ALTERNATIVE_ADRESSES'));
593$tabcond[DICT_TRANSPORT_MODE] = isModEnabled('intracommreport');
594$tabcond[DICT_PRODUCT_NATURE] = isModEnabled("product");
595$tabcond[DICT_PRODUCTBATCH_QCSTATUS] = isModEnabled("product") && isModEnabled('productbatch') && getDolGlobalInt('MAIN_FEATURES_LEVEL') >= 2;
596$tabcond[DICT_ASSET_DISPOSAL_TYPE] = isModEnabled('asset');
597
598// List of help for fields (no more used, help is defined into tabcomplete)
599$tabhelp = array();
600
601// Table to store complete information (will replace all other tables). Key is table name.
602$tabcomplete = array(
603 'c_forme_juridique' => array(
604 'picto' => 'company',
605 'help' => array('code' => $langs->trans("EnterAnyCode"))
606 ),
607 'c_departements' => array(
608 'picto' => 'state',
609 'help' => array('code' => $langs->trans("EnterAnyCode"))
610 ),
611 'c_regions' => array(
612 'picto' => 'region',
613 'help' => array('code' => $langs->trans("EnterAnyCode"))
614 ),
615 'c_country' => array('picto' => 'country', 'help' => array('code' => $langs->trans("EnterAnyCode"))),
616 'c_civility' => array('picto' => 'contact', 'help' => array('code' => $langs->trans("EnterAnyCode"))),
617 'c_actioncomm' => array('picto' => 'action', 'help' => array('code' => $langs->trans("EnterAnyCode"), 'color' => $langs->trans("ColorFormat"), 'position' => $langs->trans("PositionIntoComboList"))),
618 'c_chargesociales' => array('picto' => 'bill', 'help' => array('code' => $langs->trans("EnterAnyCode"))),
619 'c_typent' => array('picto' => 'company', 'help' => array('code' => $langs->trans("EnterAnyCode"), 'position' => $langs->trans("PositionIntoComboList"))),
620 'c_currencies' => array('picto' => 'multicurrency', 'help' => array('code' => $langs->trans("EnterAnyCode"), 'unicode' => $langs->trans("UnicodeCurrency"))),
621 'c_tva' => array('picto' => 'bill', 'help' => array('code' => $langs->trans("EnterAnyCode"), 'taux' => $langs->trans("SellTaxRate"), 'recuperableonly' => $langs->trans("RecuperableOnly"), 'localtax1_type' => $langs->trans("LocalTaxDesc"), 'localtax2_type' => $langs->trans("LocalTaxDesc"))),
622 'c_type_contact' => array('picto' => 'contact', 'help' => array('code' => $langs->trans("EnterAnyCode"), 'position' => $langs->trans("PositionIntoComboList"))),
623 'c_payment_term' => array('picto' => 'bill', 'help' => array('code' => $langs->trans("EnterAnyCode"), 'type_cdr' => $langs->trans("TypeCdr", $langs->transnoentitiesnoconv("NbOfDays"), $langs->transnoentitiesnoconv("Offset"), $langs->transnoentitiesnoconv("NbOfDays"), $langs->transnoentitiesnoconv("Offset")))),
624 'c_paiement' => array('picto' => 'bill', 'help' => array('code' => $langs->trans("EnterAnyCode"))),
625 'c_ecotaxe' => array('picto' => 'bill', 'help' => array('code' => $langs->trans("EnterAnyCode"))),
626 'c_paper_format' => array('picto' => 'generic', 'help' => array('code' => $langs->trans("EnterAnyCode"))),
627 'c_prospectlevel' => array('picto' => 'company', 'help' => array('code' => $langs->trans("EnterAnyCode"))),
628 'c_type_fees' => array('picto' => 'trip', 'help' => array('code' => $langs->trans("EnterAnyCode"))),
629 'c_shipment_mode' => array('picto' => 'shipment', 'help' => array('code' => $langs->trans("EnterAnyCode"), 'tracking' => $langs->trans("UrlTrackingDesc"))),
630 'c_effectif' => array('picto' => 'company', 'help' => array('code' => $langs->trans("EnterAnyCode"))),
631 'c_input_method' => array('picto' => 'order', 'help' => array('code' => $langs->trans("EnterAnyCode"))),
632 'c_input_reason' => array('picto' => 'order', 'help' => array('code' => $langs->trans("EnterAnyCode"), 'position' => $langs->trans("PositionIntoComboList"))),
633 'c_availability' => array('picto' => 'shipment', 'help' => array('code' => $langs->trans("EnterAnyCode"))),
634 'c_revenuestamp' => array('picto' => 'bill', 'help' => array('revenuestamp_type' => $langs->trans('FixedOrPercent'))),
635 'c_type_resource' => array('picto' => 'resource', 'help' => array('code' => $langs->trans("EnterAnyCode"))),
636 'c_type_container' => array('picto' => 'website', 'help' => array('code' => $langs->trans("EnterAnyCode"))),
637 'c_stcomm' => array('picto' => 'company', 'help' => array('code' => $langs->trans("EnterAnyCode"), 'picto' => $langs->trans("PictoHelp"))),
638 'c_holiday_types' => array('picto' => 'holiday', 'help' => array('affect' => $langs->trans("FollowedByACounter"), 'delay' => $langs->trans("MinimumNoticePeriod"), 'newbymonth' => $langs->trans("NbAddedAutomatically"))),
639 'c_lead_status' => array('picto' => 'project', 'help' => array('code' => $langs->trans("EnterAnyCode"), 'percent' => $langs->trans("OpportunityPercent"), 'position' => $langs->trans("PositionIntoComboList"))),
640 'c_format_cards' => array('picto' => 'generic', 'help' => array('code' => $langs->trans("EnterAnyCode"), 'name' => $langs->trans("LabelName"), 'paper_size' => $langs->trans("LabelPaperSize"))),
641 'c_hrm_public_holiday' => array('picto' => 'holiday', 'help' => array('code' => $langs->trans("EnterAnyCode"), 'dayrule' => "Keep empty for a date defined with month and day (most common case).<br>Use a keyword like 'easter', 'eastermonday', ... for a date predefined by complex rules.", 'country' => $langs->trans("CountryIfSpecificToOneCountry"), 'year' => $langs->trans("ZeroMeansEveryYear"))),
642 'c_hrm_department' => array('picto' => 'hrm', 'help' => array('code' => $langs->trans("EnterAnyCode"))),
643 'c_hrm_function' => array('picto' => 'hrm', 'help' => array('code' => $langs->trans("EnterAnyCode"))),
644 'c_exp_tax_cat' => array('picto' => 'expensereport', 'help' => array()),
645 'c_exp_tax_range' => array('picto' => 'expensereport', 'help' => array('range_ik' => $langs->trans('PrevRangeToThisRange'))),
646 'c_units' => array('picto' => 'product', 'help' => array('code' => $langs->trans("EnterAnyCode"), 'unit_type' => $langs->trans('Measuringtype_durationDesc'), 'scale' => $langs->trans('MeasuringScaleDesc'))),
647 'c_socialnetworks' => array('picto' => 'share-alt', 'help' => array('code' => $langs->trans("EnterAnyCode"), 'url' => $langs->trans('UrlSocialNetworksDesc'), 'icon' => $langs->trans('FafaIconSocialNetworksDesc'))),
648 'c_prospectcontactlevel' => array('picto' => 'company', 'help' => array('code' => $langs->trans("EnterAnyCode"))),
649 'c_stcommcontact' => array('picto' => 'company', 'help' => array('code' => $langs->trans("EnterAnyCode"), 'picto' => $langs->trans("PictoHelp"))),
650 'c_transport_mode' => array('picto' => 'incoterm', 'help' => array('code' => $langs->trans("EnterAnyCode"))),
651 'c_product_nature' => array('picto' => 'product', 'help' => array('code' => $langs->trans("EnterAnyCode"))),
652 'c_productbatch_qcstatus' => array('picto' => 'lot', 'help' => array('code' => $langs->trans("EnterAnyCode"))),
653 'c_asset_disposal_type' => array('picto' => 'asset', 'help' => array('code' => $langs->trans("EnterAnyCode"))),
654 'c_invoice_subtype' => array('picto' => 'bill', 'help' => array('code' => $langs->trans("EnterAnyCode"))),
655);
656
657
658// Complete all arrays with entries found into modules
659complete_dictionary_with_modules($taborder, $tabname, $tablib, $tabsql, $tabsqlsort, $tabfield, $tabfieldvalue, $tabfieldinsert, $tabrowid, $tabcond, $tabhelp, $tabcomplete);
660
661// Complete the table $tabcomplete
662$i = 0;
663foreach ($tabcomplete as $key => $value) {
664 $i++;
665 // When a dictionary is commented
666 if (!isset($tabcond[$i])) {
667 continue;
668 }
669 $tabcomplete[$key]['id'] = $i;
670
671 // TODO Comment this lines when data is stored into the tabcomplete array
672 $tabcomplete[$key]['cond'] = $tabcond[$i];
673 $tabcomplete[$key]['rowid'] = $tabrowid[$i];
674 $tabcomplete[$key]['fieldinsert'] = $tabfieldinsert[$i];
675 $tabcomplete[$key]['fieldvalue'] = $tabfieldvalue[$i];
676 $tabcomplete[$key]['lib'] = $tablib[$i];
677 $tabcomplete[$key]['sql'] = $tabsql[$i];
678 $tabcomplete[$key]['sqlsort'] = $tabsqlsort[$i];
679 $tabcomplete[$key]['field'] = $tabfield[$i];
680 //$tabcomplete[$key]['picto'] = $tabpicto[$i]; // array picto already loaded into tabcomplete
681 //$tabcomplete[$key]['help'] = $tabhelp[$i]; // array help already loaded into tabcomplete
682}
683
684$keytable = '';
685if ($id > 0) {
686 $arrayofkeys = array_keys($tabcomplete);
687 if (array_key_exists($id - 1, $arrayofkeys)) {
688 $keytable = $arrayofkeys[$id - 1];
689 }
690}
691
692// Default sortorder
693if (empty($sortfield)) {
694 $tmp1 = explode(',', empty($tabcomplete[$keytable]['sqlsort']) ? '' : $tabcomplete[$keytable]['sqlsort']);
695 $tmp2 = explode(' ', $tmp1[0]);
696 $sortfield = preg_replace('/^.*\./', '', $tmp2[0]);
697 $sortorder = (!empty($tmp2[1]) ? $tmp2[1] : '');
698 //var_dump($sortfield); //var_dump($sortorder);
699}
700
701// Define elementList and sourceList (used for dictionary type of contacts "llx_c_type_contact")
702$elementList = array();
703$sourceList = array();
704if ($id == DICT_TYPE_CONTACT) {
705 $elementList = array(
706 '' => '',
707 'agenda' => img_picto('', 'action', 'class="pictofixedwidth"').$langs->trans('Agenda'),
708 'dolresource' => img_picto('', 'resource', 'class="pictofixedwidth"').$langs->trans('Resource'),
709 'societe' => img_picto('', 'company', 'class="pictofixedwidth"').$langs->trans('ThirdParty'),
710 // 'proposal' => $langs->trans('Proposal'),
711 // 'order' => $langs->trans('Order'),
712 // 'invoice' => $langs->trans('Bill'),
713 // 'intervention' => $langs->trans('InterventionCard'),
714 // 'contract' => $langs->trans('Contract'),
715 'project' => img_picto('', 'project', 'class="pictofixedwidth"').$langs->trans('Project'),
716 'project_task' => img_picto('', 'projecttask', 'class="pictofixedwidth"').$langs->trans('Task'),
717 'propal' => img_picto('', 'propal', 'class="pictofixedwidth"').$langs->trans('Proposal'),
718 'commande' => img_picto('', 'order', 'class="pictofixedwidth"').$langs->trans('Order'),
719 'shipping' => img_picto('', 'dolly', 'class="pictofixedwidth"') . $langs->trans('Shipment'),
720 'facture' => img_picto('', 'bill', 'class="pictofixedwidth"').$langs->trans('Bill'),
721 'fichinter' => img_picto('', 'intervention', 'class="pictofixedwidth"').$langs->trans('InterventionCard'),
722 'contrat' => img_picto('', 'contract', 'class="pictofixedwidth"').$langs->trans('Contract'),
723 'ticket' => img_picto('', 'ticket', 'class="pictofixedwidth"').$langs->trans('Ticket'),
724 'supplier_proposal' => img_picto('', 'supplier_proposal', 'class="pictofixedwidth"').$langs->trans('SupplierProposal'),
725 'order_supplier' => img_picto('', 'supplier_order', 'class="pictofixedwidth"').$langs->trans('SupplierOrder'),
726 'invoice_supplier' => img_picto('', 'supplier_invoice', 'class="pictofixedwidth"').$langs->trans('SupplierBill'),
727 'conferenceorbooth' => img_picto('', 'eventorganization', 'class="pictofixedwidth"').$langs->trans('ConferenceOrBooth'),
728 );
729
731
732 //asort($elementList);
733 $sourceList = array(
734 'internal' => $langs->trans('Internal'),
735 'external' => $langs->trans('External')
736 );
737}
738
739// Define type_vatList (used for dictionary "llx_c_tva")
740$type_vatList = array(
741 "0" => $langs->trans("Sell").'+'.$langs->trans("Buy"),
742 "1" => $langs->trans("Sell"),
743 "2" => $langs->trans("Buy")
744);
745
746// Define localtax_typeList (used for dictionary "llx_c_tva")
747$localtax_typeList = array(
748 "0" => $langs->trans("No"),
749 "1" => $langs->trans("Yes").' ('.$langs->trans("Type")." 1)", //$langs->trans("%ageOnAllWithoutVAT"),
750 "2" => $langs->trans("Yes").' ('.$langs->trans("Type")." 2)", //$langs->trans("%ageOnAllBeforeVAT"),
751 "3" => $langs->trans("Yes").' ('.$langs->trans("Type")." 3)", //$langs->trans("%ageOnProductsWithoutVAT"),
752 "4" => $langs->trans("Yes").' ('.$langs->trans("Type")." 4)", //$langs->trans("%ageOnProductsBeforeVAT"),
753 "5" => $langs->trans("Yes").' ('.$langs->trans("Type")." 5)", //$langs->trans("%ageOnServiceWithoutVAT"),
754 "6" => $langs->trans("Yes").' ('.$langs->trans("Type")." 6)" //$langs->trans("%ageOnServiceBeforeVAT"),
755);
756
757
758
759/*
760 * Actions
761 */
762
763$object = new stdClass();
764$parameters = array(
765 'id' => $id,
766 'rowid' => $rowid,
767 'code' => $code,
768 'confirm' => $confirm,
769 'entity' => $entity,
770 'taborder' => $taborder,
771 'tabname' => $tabname,
772 'tablib' => $tablib,
773 'tabsql' => $tabsql,
774 'tabsqlsort' => $tabsqlsort,
775 'tabfield' => $tabfield,
776 'tabfieldvalue' => $tabfieldvalue,
777 'tabfieldinsert' => $tabfieldinsert,
778 'tabrowid' => $tabrowid,
779 'tabcond' => $tabcond,
780 'tabhelp' => $tabhelp,
781 'tabcomplete' => $tabcomplete
782);
783$reshook = $hookmanager->executeHooks('doActions', $parameters, $object, $action); // Note that $action and $object may have been modified by some hooks
784if ($reshook < 0) {
785 setEventMessages($hookmanager->error, $hookmanager->errors, 'errors');
786}
787
788if (GETPOST('button_removefilter', 'alpha') || GETPOST('button_removefilter.x', 'alpha') || GETPOST('button_removefilter_x', 'alpha')) {
789 $search_country_id = '';
790 $search_code = '';
791 $search_active = '';
792}
793
794if (empty($reshook)) {
795 // Actions add or modify an entry into a dictionary
796 if (GETPOST('actionadd') || GETPOST('actionmodify')) {
797 $listfield = explode(',', str_replace(' ', '', $tabfield[$id]));
798 $listfieldinsert = explode(',', $tabfieldinsert[$id]);
799 $listfieldmodify = explode(',', $tabfieldinsert[$id]);
800 $listfieldvalue = explode(',', $tabfieldvalue[$id]);
801
802 // Check that all mandatory fields are filled
803 $ok = 1;
804 foreach ($listfield as $f => $value) {
805 // Discard check of mandatory fields for country for some tables
806 if ($value == 'country_id' && in_array($tablib[$id], array('DictionaryPublicHolidays', 'DictionaryVAT', 'DictionaryInvoiceSubtype', 'DictionaryRegion', 'DictionaryCompanyType', 'DictionaryHolidayTypes', 'DictionaryRevenueStamp', 'DictionaryAccountancysystem', 'DictionaryAccountancyCategory'))) {
807 continue; // For some pages, country is not mandatory
808 }
809 if ($value == 'country' && in_array($tablib[$id], array('DictionaryPublicHolidays', 'DictionaryCanton', 'DictionaryCompanyType', 'DictionaryHolidayTypes', 'DictionaryRevenueStamp'))) {
810 continue; // For some pages, country is not mandatory
811 }
812 // Discard check of mandatory fields for department buyer id for some tables (only for add action)
813 if (GETPOST('actionadd') && $value == 'department_buyer_id' && $tablib[$id] == 'DictionaryVAT') {
814 continue; // For some pages, department buyer id is not mandatory
815 }
816 // Discard check of mandatory fields for department buyer for some tables
817 if ($value == 'department_buyer' && $tablib[$id] == 'DictionaryVAT') {
818 continue; // For some pages, department buyer is not mandatory
819 }
820 // Discard check of mandatory fields for other fields
821 if ($value == 'localtax1' && !GETPOST('localtax1_type')) {
822 continue;
823 }
824 if ($value == 'localtax2' && !GETPOST('localtax2_type')) {
825 continue;
826 }
827 if ($value == 'color' && !GETPOST('color')) {
828 continue;
829 }
830 if ($value == 'formula' && !GETPOST('formula')) {
831 continue;
832 }
833 if ($value == 'dayrule' && !GETPOST('dayrule')) {
834 continue;
835 }
836 if ($value == 'sortorder') {
837 continue; // For a column name 'sortorder', we use the field name 'position'
838 }
839 if ((!GETPOSTISSET($value) || GETPOST($value) == '')
840 && (
841 !in_array($value, array('decalage', 'module', 'accountancy_code', 'accountancy_code_sell', 'accountancy_code_buy', 'tracking', 'picto', 'deposit_percent')) // Fields that are not mandatory
842 && ($id != DICT_TVA || ($value != 'code' && $value != 'note')) // Field code and note is not mandatory for dictionary table 10
843 )
844 ) {
845 $ok = 0;
846 $fieldnamekey = $value;
847 // We take translate key of field
848 if ($fieldnamekey == 'libelle' || ($fieldnamekey == 'label')) {
849 $fieldnamekey = 'Label';
850 }
851 if ($fieldnamekey == 'libelle_facture') {
852 $fieldnamekey = 'LabelOnDocuments';
853 }
854 if ($fieldnamekey == 'deposit_percent') {
855 $fieldnamekey = 'DepositPercent';
856 }
857 if ($fieldnamekey == 'nbjour') {
858 $fieldnamekey = 'NbOfDays';
859 }
860 if ($fieldnamekey == 'decalage') {
861 $fieldnamekey = 'Offset';
862 }
863 if ($fieldnamekey == 'module') {
864 $fieldnamekey = 'Module';
865 }
866 if ($fieldnamekey == 'code') {
867 $fieldnamekey = 'Code';
868 }
869 if ($fieldnamekey == 'note') {
870 $fieldnamekey = 'Note';
871 }
872 if ($fieldnamekey == 'taux') {
873 $fieldnamekey = 'Rate';
874 }
875 if ($fieldnamekey == 'type') {
876 $fieldnamekey = 'Type';
877 }
878 if ($fieldnamekey == 'position') {
879 $fieldnamekey = 'Position';
880 }
881 if ($fieldnamekey == 'unicode') {
882 $fieldnamekey = 'Unicode';
883 }
884 if ($fieldnamekey == 'deductible') {
885 $fieldnamekey = 'Deductible';
886 }
887 if ($fieldnamekey == 'sortorder') {
888 $fieldnamekey = 'SortOrder';
889 }
890 if ($fieldnamekey == 'category_type') {
891 $fieldnamekey = 'Calculated';
892 }
893 if ($fieldnamekey == 'revenuestamp_type') {
894 $fieldnamekey = 'TypeOfRevenueStamp';
895 }
896 if ($fieldnamekey == 'use_default') {
897 $fieldnamekey = 'UseByDefault';
898 }
899
900 setEventMessages($langs->transnoentities("ErrorFieldRequired", $langs->transnoentities($fieldnamekey)), null, 'errors');
901 }
902 }
903 // Other special checks
904 if (GETPOST('actionadd') && $tabname[$id] == "c_actioncomm" && GETPOSTISSET("type") && in_array(GETPOST("type"), array('system', 'systemauto'))) {
905 $ok = 0;
906 setEventMessages($langs->transnoentities('ErrorReservedTypeSystemSystemAuto'), null, 'errors');
907 }
908 if (GETPOSTISSET("code")) {
909 if (GETPOST("code") == '0') {
910 $ok = 0;
911 setEventMessages($langs->transnoentities('ErrorCodeCantContainZero'), null, 'errors');
912 }
913 }
914 if (GETPOSTISSET("country") && (GETPOST("country") == '0') && ($id != DICT_DEPARTEMENTS)) {
915 if (in_array($tablib[$id], array('DictionaryCompanyType', 'DictionaryHolidayTypes'))) { // Field country is no mandatory for such dictionaries
916 $_POST["country"] = '';
917 } else {
918 $ok = 0;
919 setEventMessages($langs->transnoentities("ErrorFieldRequired", $langs->transnoentities("Country")), null, 'errors');
920 }
921 }
922 if (($id == DICT_REGIONS || $id == DICT_PRODUCT_NATURE) && !is_numeric(GETPOST("code")) && GETPOST('actionadd')) {
923 $ok = 0;
924 setEventMessages($langs->transnoentities("ErrorFieldMustBeANumeric", $langs->transnoentities("Code")), null, 'errors');
925 }
926 if ($id == DICT_COUNTRY && strlen(GETPOST("code")) != 2) { // 2 char on code for country code
927 $ok = 0;
928 setEventMessages($langs->transnoentities("ErrorCountryCodeMustBe2Char", $langs->transnoentities("Code")), null, 'errors');
929 }
930 if ($id == DICT_PAIEMENT && strlen(GETPOST("code")) >= 6) { // 6 char max on code for payment mode codes
931 $ok = 0;
932 setEventMessages($langs->transnoentities("ErrorFieldMustHaveLessThanXChar", $langs->transnoentities("Code"), '6'), null, 'errors');
933 }
934
935 // Clean some parameters
936 if ((GETPOST("localtax1_type") || (GETPOST('localtax1_type') == '0')) && !GETPOST("localtax1")) {
937 $_POST["localtax1"] = '0'; // If empty, we force to 0
938 }
939 if ((GETPOST("localtax2_type") || (GETPOST('localtax2_type') == '0')) && !GETPOST("localtax2")) {
940 $_POST["localtax2"] = '0'; // If empty, we force to 0
941 }
942 if (GETPOST('department_buyer_id') <= 0) {
943 $_POST['department_buyer_id'] = ''; // If empty, we force to null
944 }
945 if (GETPOST("accountancy_code") <= 0) {
946 $_POST["accountancy_code"] = ''; // If empty, we force to null
947 }
948 if (GETPOST("accountancy_code_sell") <= 0) {
949 $_POST["accountancy_code_sell"] = ''; // If empty, we force to null
950 }
951 if (GETPOST("accountancy_code_buy") <= 0) {
952 $_POST["accountancy_code_buy"] = ''; // If empty, we force to null
953 }
954 if ($id == DICT_TVA && GETPOSTISSET("code")) { // Spaces are not allowed into code for tax dictionary
955 $_POST["code"] = preg_replace('/[^a-zA-Z0-9_\-\+]/', '', GETPOST("code"));
956 }
957 // Checked after the cleaning above, so that a code shortened by it is not refused. The column c_tva.code
958 // is a varchar(10) and a longer value ended in a fatal SQL error instead of a message on the form.
959 if ($id == DICT_TVA && strlen(GETPOST("code")) > 10) {
960 $ok = 0;
961 setEventMessages($langs->transnoentities("ErrorFieldMustHaveLessThanXChar", $langs->transnoentities("Code"), '10'), null, 'errors');
962 }
963
964 $tablename = $tabname[$id];
965 $tablename = preg_replace('/^'.preg_quote(MAIN_DB_PREFIX, '/').'/', '', $tablename);
966
967 // If check ok and action add, add the line
968 if ($ok && GETPOST('actionadd')) {
969 $newid = 0;
970 if ($tabrowid[$id] && !in_array($tabrowid[$id], $listfieldinsert)) {
971 // Get free id for insert
972 $sql = "SELECT MAX(".$tabrowid[$id].") as newid FROM ".MAIN_DB_PREFIX.$tablename;
973 $result = $db->query($sql);
974 if ($result) {
975 $obj = $db->fetch_object($result);
976 $newid = ((int) $obj->newid) + 1;
977 } else {
978 dol_print_error($db);
979 }
980 }
981
982 // Add new entry
983 $sql = "INSERT INTO ".MAIN_DB_PREFIX.$tablename." (";
984 // List of fields
985 if ($tabrowid[$id] && !in_array($tabrowid[$id], $listfieldinsert)) {
986 $sql .= $tabrowid[$id].",";
987 }
988 $sql .= $tabfieldinsert[$id];
989 $sql .= ",active)";
990 $sql .= " VALUES(";
991
992 // List of values
993 if ($tabrowid[$id] && !in_array($tabrowid[$id], $listfieldinsert)) {
994 $sql .= $newid.",";
995 }
996 $i = 0;
997 foreach ($listfieldinsert as $f => $value) {
998 $keycode = (isset($listfieldvalue[$i]) ? $listfieldvalue[$i] : '');
999 if (empty($keycode)) {
1000 $keycode = $value;
1001 }
1002
1003 if ($value == 'price' || preg_match('/^amount/i', $value)) {
1004 $_POST[$keycode] = price2num(GETPOST($keycode), 'MU');
1005 } elseif ($value == 'taux' || $value == 'localtax1') {
1006 $_POST[$keycode] = price2num(GETPOST($keycode), 8); // Note that localtax2 can be a list of rates separated by coma like X:Y:Z
1007 } elseif ($value == 'entity') {
1008 $_POST[$keycode] = getEntity($tablename);
1009 }
1010
1011 if ($i) {
1012 $sql .= ",";
1013 }
1014
1015 if ($keycode == 'sortorder') { // For column name 'sortorder', we use the field name 'position'
1016 $sql .= GETPOSTINT('position');
1017 } elseif (GETPOST($keycode) == '' && !($keycode == 'code' && $id == DICT_TVA)) {
1018 $sql .= "null"; // For vat, we want/accept code = ''
1019 } elseif ($keycode == 'content') {
1020 $sql .= "'".$db->escape(GETPOST($keycode, 'restricthtml'))."'";
1021 } elseif (in_array($keycode, array('joinfile', 'private', 'pos', 'position', 'scale', 'use_default'))) {
1022 $sql .= GETPOSTINT($keycode);
1023 } else {
1024 $sql .= "'".$db->escape(GETPOST($keycode, 'alphanohtml'))."'";
1025 }
1026
1027 $i++;
1028 }
1029 $sql .= ",1)";
1030
1031 dol_syslog("actionadd", LOG_DEBUG);
1032 $resql = $db->query($sql);
1033 if ($resql) { // Add is ok
1034 setEventMessages($langs->transnoentities("RecordCreatedSuccessfully"), null, 'mesgs');
1035
1036 // Clean $_POST array, we keep only id of dictionary
1037 if ($id == DICT_TVA && GETPOSTINT('country') > 0) {
1038 $search_country_id = GETPOSTINT('country');
1039 }
1040 $_POST = array('id' => $id);
1041 } else {
1042 if ($db->errno() == 'DB_ERROR_RECORD_ALREADY_EXISTS') {
1043 setEventMessages($langs->transnoentities("ErrorRecordAlreadyExists"), null, 'errors');
1044 } else {
1045 dol_print_error($db);
1046 }
1047 }
1048 }
1049
1050 // If verif ok and action modify, modify the line
1051 if ($ok && GETPOST('actionmodify')) {
1052 if ($tabrowid[$id]) {
1053 $rowidcol = $tabrowid[$id];
1054 } else {
1055 $rowidcol = "rowid";
1056 }
1057
1058 // Modify entry
1059 $sql = "UPDATE ".MAIN_DB_PREFIX.$tablename." SET ";
1060 // Modifie valeur des champs
1061 if ($tabrowid[$id] && !in_array($tabrowid[$id], $listfieldmodify)) {
1062 $sql .= $tabrowid[$id]."=";
1063 $sql .= "'".$db->escape($rowid)."', ";
1064 }
1065 $i = 0;
1066 foreach ($listfieldmodify as $field) {
1067 $keycode = empty($listfieldvalue[$i]) ? '' : $listfieldvalue[$i];
1068 if (empty($keycode)) {
1069 $keycode = $field;
1070 }
1071
1072 if ($field == 'price' || preg_match('/^amount/i', $field)) {
1073 $_POST[$keycode] = price2num(GETPOST($keycode), 'MU');
1074 } elseif ($field == 'taux' || $field == 'localtax1') {
1075 $_POST[$keycode] = price2num(GETPOST($keycode), 8); // Note that localtax2 can be a list of rates separated by coma like X:Y:Z
1076 } elseif ($field == 'entity') {
1077 $_POST[$keycode] = getEntity($tablename);
1078 }
1079
1080 if ($i) {
1081 $sql .= ",";
1082 }
1083 $sql .= $field."=";
1084 if ($keycode == 'sortorder') { // For column name 'sortorder', we use the field name 'position'
1085 $sql .= GETPOSTINT('position');
1086 } elseif (GETPOST($keycode) == '' && !($keycode == 'code' && $id == DICT_TVA)) {
1087 $sql .= "null"; // For vat, we want/accept code = ''
1088 } elseif ($keycode == 'content') {
1089 $sql .= "'".$db->escape(GETPOST($keycode, 'restricthtml'))."'";
1090 } elseif (in_array($keycode, array('joinfile', 'private', 'pos', 'position', 'scale', 'use_default'))) {
1091 $sql .= GETPOSTINT($keycode);
1092 } else {
1093 $sql .= "'".$db->escape(GETPOST($keycode, 'alphanohtml'))."'";
1094 }
1095
1096 $i++;
1097 }
1098 if (in_array($rowidcol, array('code', 'code_iso'))) {
1099 $sql .= " WHERE ".$db->sanitize($rowidcol)." = '".$db->escape($rowid)."'";
1100 } else {
1101 $sql .= " WHERE ".$db->sanitize($rowidcol)." = ".((int) $rowid);
1102 }
1103 if (in_array('entity', $listfieldmodify)) {
1104 $sql .= " AND entity = ".((int) getEntity($tablename, 0));
1105 }
1106
1107 dol_syslog("actionmodify", LOG_DEBUG);
1108 //print $sql;
1109 $resql = $db->query($sql);
1110 if (!$resql) {
1111 setEventMessages($db->error(), null, 'errors');
1112 }
1113 }
1114
1115 if (!$ok && GETPOST('actionadd')) {
1116 $action = 'create';
1117 }
1118 if (!$ok && GETPOST('actionmodify')) {
1119 $action = 'edit';
1120 }
1121 }
1122
1123 if ($action == 'confirm_delete' && $confirm == 'yes') { // delete
1124 if ($tabrowid[$id]) {
1125 $rowidcol = $tabrowid[$id];
1126 } else {
1127 $rowidcol = "rowid";
1128 }
1129
1130 $tablename = $tabname[$id];
1131 $tablename = preg_replace('/^'.preg_quote(MAIN_DB_PREFIX, '/').'/', '', $tablename);
1132
1133 $sql = "DELETE FROM ".MAIN_DB_PREFIX.$tablename." WHERE ".$rowidcol." = '".$db->escape($rowid)."'".($entity != '' ? " AND entity = ".(int) $entity : '');
1134
1135 dol_syslog("delete", LOG_DEBUG);
1136 $result = $db->query($sql);
1137 if (!$result) {
1138 if ($db->errno() == 'DB_ERROR_CHILD_EXISTS') {
1139 setEventMessages($langs->transnoentities("ErrorRecordIsUsedByChild"), null, 'errors');
1140 } else {
1141 dol_print_error($db);
1142 }
1143 }
1144 }
1145
1146 // activate
1147 if ($action == $acts[0]) {
1148 if ($tabrowid[$id]) {
1149 $rowidcol = $tabrowid[$id];
1150 } else {
1151 $rowidcol = "rowid";
1152 }
1153
1154 $tablename = $tabname[$id];
1155 $tablename = preg_replace('/^'.preg_quote(MAIN_DB_PREFIX, '/').'/', '', $tablename);
1156
1157 if ($rowid) {
1158 $sql = "UPDATE ".MAIN_DB_PREFIX.$tablename." SET active = 1 WHERE ".$db->escape($rowidcol)." = '".$db->escape($rowid)."'".($entity != '' ? " AND entity = ".(int) $entity : '');
1159 } elseif ($code) {
1160 $sql = "UPDATE ".MAIN_DB_PREFIX.$tablename." SET active = 1 WHERE code = '".$db->escape(dol_escape_htmltag($code))."'".($entity != '' ? " AND entity = ".(int) $entity : '');
1161 } else {
1162 $sql = null;
1163 }
1164
1165 if ($sql !== null) {
1166 $result = $db->query($sql);
1167 if (!$result) {
1168 dol_print_error($db);
1169 }
1170 } else {
1171 dol_print_error(null, "No DB entry or no code");
1172 }
1173 }
1174
1175 // disable
1176 if ($action == $acts[1]) {
1177 if ($tabrowid[$id]) {
1178 $rowidcol = $tabrowid[$id];
1179 } else {
1180 $rowidcol = "rowid";
1181 }
1182
1183 $tablename = $tabname[$id];
1184 $tablename = preg_replace('/^'.preg_quote(MAIN_DB_PREFIX, '/').'/', '', $tablename);
1185
1186 if ($rowid) {
1187 $sql = "UPDATE ".MAIN_DB_PREFIX.$tablename." SET active = 0 WHERE ".$rowidcol." = '".$db->escape($rowid)."'".($entity != '' ? " AND entity = ".(int) $entity : '');
1188 } elseif ($code) {
1189 $sql = "UPDATE ".MAIN_DB_PREFIX.$tablename." SET active = 0 WHERE code = '".$db->escape(dol_escape_htmltag($code))."'".($entity != '' ? " AND entity = ".(int) $entity : '');
1190 } else {
1191 $sql = null;
1192 }
1193
1194 if ($sql !== null) {
1195 $result = $db->query($sql);
1196 if (!$result) {
1197 dol_print_error($db);
1198 }
1199 } else {
1200 dol_print_error(null, "No DB entry or no code");
1201 }
1202 }
1203
1204 // favorite
1205 if ($action == 'activate_favorite') {
1206 if ($tabrowid[$id]) {
1207 $rowidcol = $tabrowid[$id];
1208 } else {
1209 $rowidcol = "rowid";
1210 }
1211
1212 $tablename = $tabname[$id];
1213 $tablename = preg_replace('/^'.preg_quote(MAIN_DB_PREFIX, '/').'/', '', $tablename);
1214
1215 if ($rowid) {
1216 $sql = "UPDATE ".MAIN_DB_PREFIX.$tablename." SET favorite = 1 WHERE ".$rowidcol." = '".$db->escape($rowid)."'".($entity != '' ? " AND entity = ".(int) $entity : '');
1217 } elseif ($code) {
1218 $sql = "UPDATE ".MAIN_DB_PREFIX.$tablename." SET favorite = 1 WHERE code = '".$db->escape(dol_escape_htmltag($code))."'".($entity != '' ? " AND entity = ".(int) $entity : '');
1219 } else {
1220 $sql = null;
1221 }
1222
1223 if ($sql !== null) {
1224 $result = $db->query($sql);
1225 if (!$result) {
1226 dol_print_error($db);
1227 }
1228 } else {
1229 dol_print_error(null, "No DB entry or no code");
1230 }
1231 }
1232
1233 // disable favorite
1234 if ($action == 'disable_favorite') {
1235 if ($tabrowid[$id]) {
1236 $rowidcol = $tabrowid[$id];
1237 } else {
1238 $rowidcol = "rowid";
1239 }
1240
1241 $tablename = $tabname[$id];
1242 $tablename = preg_replace('/^'.preg_quote(MAIN_DB_PREFIX, '/').'/', '', $tablename);
1243
1244 if ($rowid) {
1245 $sql = "UPDATE ".MAIN_DB_PREFIX.$tablename." SET favorite = 0 WHERE ".$rowidcol." = '".$db->escape($rowid)."'".($entity != '' ? " AND entity = ".(int) $entity : '');
1246 } elseif ($code) {
1247 $sql = "UPDATE ".MAIN_DB_PREFIX.$tablename." SET favorite = 0 WHERE code = '".$db->escape(dol_escape_htmltag($code))."'".($entity != '' ? " AND entity = ".(int) $entity : '');
1248 } else {
1249 $sql = null;
1250 }
1251
1252 if ($sql !== null) {
1253 $result = $db->query($sql);
1254 if (!$result) {
1255 dol_print_error($db);
1256 }
1257 } else {
1258 dol_print_error(null, "No DB entry or no code");
1259 }
1260 }
1261
1262 // Is in EEC - Activate
1263 if ($action == 'activate_eec') {
1264 if ($tabrowid[$id]) {
1265 $rowidcol = $tabrowid[$id];
1266 } else {
1267 $rowidcol = "rowid";
1268 }
1269
1270 $tablename = $tabname[$id];
1271 $tablename = preg_replace('/^'.preg_quote(MAIN_DB_PREFIX, '/').'/', '', $tablename);
1272
1273 if ($rowid) {
1274 $sql = "UPDATE ".MAIN_DB_PREFIX.$tablename." SET eec = 1 WHERE ".$rowidcol." = '".$db->escape($rowid)."'".($entity != '' ? " AND entity = ".(int) $entity : '');
1275 } elseif ($code) {
1276 $sql = "UPDATE ".MAIN_DB_PREFIX.$tablename." SET eec = 1 WHERE code = '".$db->escape(dol_escape_htmltag($code))."'".($entity != '' ? " AND entity = ".(int) $entity : '');
1277 } else {
1278 $sql = null;
1279 }
1280
1281 if ($sql !== null) {
1282 $result = $db->query($sql);
1283 if (!$result) {
1284 dol_print_error($db);
1285 }
1286 } else {
1287 dol_print_error(null, "No DB entry or no code");
1288 }
1289 }
1290
1291 // Is in EEC - Disable
1292 if ($action == 'disable_eec') {
1293 if ($tabrowid[$id]) {
1294 $rowidcol = $tabrowid[$id];
1295 } else {
1296 $rowidcol = "rowid";
1297 }
1298
1299 $tablename = $tabname[$id];
1300 $tablename = preg_replace('/^'.preg_quote(MAIN_DB_PREFIX, '/').'/', '', $tablename);
1301
1302 if ($rowid) {
1303 $sql = "UPDATE ".MAIN_DB_PREFIX.$tablename." SET eec = 0 WHERE ".$rowidcol." = '".$db->escape($rowid)."'".($entity != '' ? " AND entity = ".(int) $entity : '');
1304 } elseif ($code) {
1305 $sql = "UPDATE ".MAIN_DB_PREFIX.$tablename." SET eec = 0 WHERE code = '".$db->escape(dol_escape_htmltag($code))."'".($entity != '' ? " AND entity = ".(int) $entity : '');
1306 } else {
1307 $sql = null;
1308 }
1309
1310 if ($sql !== null) {
1311 $result = $db->query($sql);
1312 if (!$result) {
1313 dol_print_error($db);
1314 }
1315 } else {
1316 dol_print_error(null, "No DB entry or no code");
1317 }
1318 }
1319
1320 // Is in Sepa - Activate
1321 if ($action == 'activate_sepa') {
1322 if ($tabrowid[$id]) {
1323 $rowidcol = $tabrowid[$id];
1324 } else {
1325 $rowidcol = "rowid";
1326 }
1327
1328 $tablename = $tabname[$id];
1329 $tablename = preg_replace('/^'.preg_quote(MAIN_DB_PREFIX, '/').'/', '', $tablename);
1330
1331 if ($rowid) {
1332 $sql = "UPDATE ".MAIN_DB_PREFIX.$tablename." SET sepa = 1 WHERE ".$rowidcol." = '".$db->escape($rowid)."'".($entity != '' ? " AND entity = ".(int) $entity : '');
1333 } elseif ($code) {
1334 $sql = "UPDATE ".MAIN_DB_PREFIX.$tablename." SET sepa = 1 WHERE code = '".$db->escape(dol_escape_htmltag($code))."'".($entity != '' ? " AND entity = ".(int) $entity : '');
1335 } else {
1336 $sql = null;
1337 }
1338
1339 if ($sql !== null) {
1340 $result = $db->query($sql);
1341 if (!$result) {
1342 dol_print_error($db);
1343 }
1344 } else {
1345 dol_print_error(null, "No DB entry or no code");
1346 }
1347 }
1348
1349 // Is in Sepa - Disable
1350 if ($action == 'disable_sepa') {
1351 if ($tabrowid[$id]) {
1352 $rowidcol = $tabrowid[$id];
1353 } else {
1354 $rowidcol = "rowid";
1355 }
1356
1357 $tablename = $tabname[$id];
1358 $tablename = preg_replace('/^'.preg_quote(MAIN_DB_PREFIX, '/').'/', '', $tablename);
1359
1360 if ($rowid) {
1361 $sql = "UPDATE ".MAIN_DB_PREFIX.$tablename." SET sepa = 0 WHERE ".$rowidcol." = '".$db->escape($rowid)."'".($entity != '' ? " AND entity = ".(int) $entity : '');
1362 } elseif ($code) {
1363 $sql = "UPDATE ".MAIN_DB_PREFIX.$tablename." SET sepa = 0 WHERE code = '".$db->escape(dol_escape_htmltag($code))."'".($entity != '' ? " AND entity = ".(int) $entity : '');
1364 } else {
1365 $sql = null;
1366 }
1367
1368 if ($sql !== null) {
1369 $result = $db->query($sql);
1370 if (!$result) {
1371 dol_print_error($db);
1372 }
1373 } else {
1374 dol_print_error(null, "No DB entry or no code");
1375 }
1376 }
1377}
1378
1379
1380/*
1381 * View
1382 */
1383
1384$form = new Form($db);
1385
1386$title = $langs->trans("DictionarySetup");
1387
1388llxHeader('', $title, '', '', 0, 0, '', '', '', 'mod-admin page-dict');
1389
1390if (GETPOSTINT('id') == DICT_SOCIALNETWORKS && $from == 'socialnetworksetup') {
1391 $head = socialnetwork_prepare_head();
1392 print dol_get_fiche_head($head, 'dict', $langs->trans('MenuDict'), -1, 'user');
1393}
1394
1395
1396$linkback = '';
1397if ($id && empty($from)) {
1398 $title .= ' - '.$langs->trans($tablib[$id]);
1399 $linkback = '<a href="'.$_SERVER['PHP_SELF'].'">'.img_picto($langs->trans("BackToDictionaryList"), 'back', 'class="pictofixedwidth"').'<span class="hideonsmartphone">'.$langs->trans("BackToDictionaryList").'</span></a>';
1400}
1401$titlepicto = 'title_setup';
1402if ($id == DICT_TVA && GETPOST('from') == 'accountancy') {
1403 $title = $langs->trans("MenuVatAccounts");
1404 $titlepicto = 'accountancy';
1405}
1406if ($id == DICT_CHARGESOCIALES && GETPOST('from') == 'accountancy') {
1407 $title = $langs->trans("MenuTaxAccounts");
1408 $titlepicto = 'accountancy';
1409}
1410
1411$param = '&id='.urlencode((string) ($id));
1412if ($search_country_id || GETPOSTISSET('page') || GETPOST('button_removefilter', 'alpha') || GETPOST('button_removefilter.x', 'alpha') || GETPOST('button_removefilter_x', 'alpha')) {
1413 $param .= '&search_country_id='.urlencode((string) ($search_country_id ? $search_country_id : -1));
1414}
1415if ($search_code != '') {
1416 $param .= '&search_code='.urlencode($search_code);
1417}
1418if ($search_active != '') {
1419 $param .= '&search_active='.urlencode($search_active);
1420}
1421if ($entity != '') {
1422 $param .= '&entity='.(int) $entity;
1423}
1424if ($from) {
1425 $param .= '&from='.urlencode($from);
1426}
1427$paramwithsearch = $param;
1428if ($sortorder) {
1429 $paramwithsearch .= '&sortorder='.urlencode($sortorder);
1430}
1431if ($sortfield) {
1432 $paramwithsearch .= '&sortfield='.urlencode($sortfield);
1433}
1434if ($from) {
1435 $paramwithsearch .= '&from='.urlencode($from);
1436}
1437
1438
1439// Confirmation of the deletion of the line
1440if ($action == 'delete') {
1441 print $form->formconfirm($_SERVER["PHP_SELF"].'?'.($page ? 'page='.$page.'&' : '').'rowid='.urlencode($rowid).'&code='.urlencode($code).$paramwithsearch, $langs->trans('DeleteLine'), $langs->trans('ConfirmDeleteLine'), 'confirm_delete', '', 0, 1);
1442}
1443
1444// Show a dictionary
1445if ($id > 0) {
1446 // Complete search values request with sort criteria
1447 $sqlfields = $tabsql[$id];
1448
1449 $tablecode = 't.code';
1450 $tableprefix = '';
1451 $tableprefixarray = array(
1452 DICT_FORME_JURIDIQUE => 'f.code',
1453 DICT_DEPARTEMENTS => 'd.code_departement',
1454 DICT_REGIONS => 'r.code_region',
1455 DICT_COUNTRY => 'c.code',
1456 DICT_CIVILITY => 'c.code',
1457 DICT_ACTIONCOMM => 'a.code',
1458 DICT_CHARGESOCIALES => 'a.code',
1459 DICT_TYPENT => 't.code',
1460 DICT_CURRENCIES => 'c.code_iso',
1461 DICT_ECOTAXE => 'e.code',
1462 DICT_HOLIDAY_TYPES => 'h.code',
1463 DICT_HRM_PUBLIC_HOLIDAY => 'a.code',
1464 DICT_UNITS => 'r.code',
1465 DICT_SOCIALNETWORKS => 's.code',
1466 45 => 'f.code',
1467 46 => 'f.code',
1468 47 => 'f.code',
1469 48 => 'f.code',
1470 );
1471 if (!empty($tableprefixarray[$id])) {
1472 $tablecode = $tableprefixarray[$id];
1473 $tableprefix = preg_replace('/\..*$/', '.', $tablecode);
1474 }
1475 $reg = array();
1476 if (empty($tableprefix) && preg_match('/SELECT ([a-z]\.)rowid/i', $sqlfields, $reg)) {
1477 $tableprefix = $reg[1];
1478 }
1479
1480 $sql = $sqlfields;
1481 if (!preg_match('/ WHERE /', $sql)) {
1482 $sql .= " WHERE 1 = 1";
1483 }
1484 if ($search_country_id > 0) {
1485 $sql .= " AND c.rowid = ".((int) $search_country_id);
1486 }
1487 if ($search_code != '') {
1488 $sql .= natural_search($tablecode, $search_code);
1489 }
1490 if ($search_active == 'yes') {
1491 $sql .= " AND ".$db->sanitize($tableprefix)."active = 1";
1492 } elseif ($search_active == 'no') {
1493 $sql .= " AND ".$db->sanitize($tableprefix)."active = 0";
1494 }
1495
1496 // Count total nb of records
1497 $nbtotalofrecords = '';
1498 if (!getDolGlobalInt('MAIN_DISABLE_FULL_SCANLIST')) {
1499 /* The fast and low memory method to get and count full list converts the sql into a sql count */
1500 $sqlforcount = preg_replace('/^.*\sFROM\s/', 'SELECT COUNT(*) as nbtotalofrecords FROM ', $sql);
1501 $sqlforcount = preg_replace('/GROUP BY .*$/', '', $sqlforcount);
1502 $resql = $db->query($sqlforcount);
1503 if ($resql) {
1504 $objforcount = $db->fetch_object($resql);
1505 $nbtotalofrecords = $objforcount->nbtotalofrecords;
1506 } else {
1507 dol_print_error($db);
1508 }
1509
1510 if (($page * $listlimit) > $nbtotalofrecords) { // if total resultset is smaller than the paging size (filtering), goto and load page 0
1511 $page = 0;
1512 $offset = 0;
1513 }
1514 $db->free($resql);
1515 }
1516
1517 if ($sortfield) {
1518 // If sort order is "country", we use country_code instead
1519 if ($sortfield == 'country') {
1520 $sortfield = 'country_code';
1521 }
1522 $sql .= $db->order($sortfield, $sortorder);
1523 $sql .= ", ";
1524 // Clear the required sort criteria for the tabsqlsort to be able to force it with selected value
1525 $tabsqlsort[$id] = preg_replace('/([a-z]+\.)?'.$sortfield.' '.$sortorder.',/i', '', $tabsqlsort[$id]);
1526 $tabsqlsort[$id] = preg_replace('/([a-z]+\.)?'.$sortfield.',/i', '', $tabsqlsort[$id]);
1527 } else {
1528 $sql .= " ORDER BY ";
1529 }
1530 $sql .= $tabsqlsort[$id];
1531
1532 $sql .= $db->plimit($listlimit + 1, $offset);
1533
1534 $resql = $db->query($sql);
1535 if (!$resql) {
1536 dol_print_error($db);
1537 exit;
1538 }
1539 $num = $db->num_rows($resql);
1540
1541 //print $sql;
1542
1543 if (empty($tabfield[$id])) {
1544 dol_print_error($db, 'The table with id '.$id.' has no array tabfield defined');
1545 exit;
1546 }
1547 $fieldlist = explode(',', $tabfield[$id]);
1548
1549 print '<form action="'.$_SERVER['PHP_SELF'].'?id='.$id.'" method="POST">';
1550 print '<input type="hidden" name="token" value="'.newToken().'">';
1551 print '<input type="hidden" name="from" value="'.dol_escape_htmltag($from).'">';
1552
1553 // Special warning for VAT dictionary
1554 if ($id == DICT_TVA && !getDolGlobalString('FACTURE_TVAOPTION')) {
1555 print info_admin($langs->trans("VATIsUsedIsOff", $langs->transnoentities("Setup"), $langs->transnoentities("CompanyFoundation")));
1556 print "<br>\n";
1557 }
1558
1559 // List of available record in database
1560 dol_syslog("htdocs/admin/dict", LOG_DEBUG);
1561
1562 $resql = $db->query($sql);
1563 if ($resql) {
1564 $num = $db->num_rows($resql);
1565 $i = 0;
1566
1567 $massactionbutton = $linkback;
1568
1569 $newcardbutton = '';
1570 /*$newcardbutton .= dolGetButtonTitle($langs->trans('ViewList'), '', 'fa fa-bars imgforviewmode', $_SERVER["PHP_SELF"].'?mode=common'.preg_replace('/(&|\?)*mode=[^&]+/', '', $param), '', ((empty($mode) || $mode == 'common') ? 2 : 1), array('morecss'=>'reposition'));
1571 $newcardbutton .= dolGetButtonTitle($langs->trans('ViewKanban'), '', 'fa fa-th-list imgforviewmode', $_SERVER["PHP_SELF"].'?mode=kanban'.preg_replace('/(&|\?)*mode=[^&]+/', '', $param), '', ($mode == 'kanban' ? 2 : 1), array('morecss'=>'reposition'));
1572 $newcardbutton .= dolGetButtonTitleSeparator();
1573 */
1574 $newcardbutton .= dolGetButtonTitle($langs->trans('New'), '', 'fa fa-plus-circle', DOL_URL_ROOT.'/admin/dict.php?action=create'.$param.'&backtopage='.urlencode($_SERVER['PHP_SELF']), '', $permissiontoadd);
1575
1576 print_barre_liste($title, $page, $_SERVER["PHP_SELF"], $param, $sortfield, $sortorder, $massactionbutton, $num, $nbtotalofrecords, 'tools', 0, $newcardbutton, '', $listlimit, 1, 0, 1);
1577
1578
1579 if ($action == 'create') {
1580 // Form to add a new line
1581 if ($tabname[$id]) {
1582 $withentity = null;
1583
1584 $fieldlist = explode(',', $tabfield[$id]);
1585
1586 print '<div class="div-table-responsive-no-min">';
1587 print '<table class="noborder centpercent">';
1588
1589 // Line for title
1590 print '<!-- line title to add new entry -->';
1591 $tdsoffields = '<tr class="liste_titre">';
1592 foreach ($fieldlist as $field => $value) {
1593 if ($value == 'entity') {
1594 $withentity = getEntity($tabname[$id]);
1595 continue;
1596 }
1597
1598 // Define field friendly name from its technical name
1599 $valuetoshow = ucfirst($value); // Par default
1600 $valuetoshow = $langs->trans($valuetoshow); // try to translate
1601 $class = '';
1602
1603 if ($value == 'pos') {
1604 $valuetoshow = $langs->trans("Position");
1605 $class = 'right';
1606 }
1607 if ($value == 'source') {
1608 $valuetoshow = $langs->trans("Contact");
1609 }
1610 if ($value == 'price') {
1611 $valuetoshow = $langs->trans("PriceUHT");
1612 }
1613 if ($value == 'taux') {
1614 if ($tabname[$id] != "c_revenuestamp") {
1615 $valuetoshow = $langs->trans("Rate");
1616 } else {
1617 $valuetoshow = $langs->trans("Amount");
1618 }
1619 $class = 'center';
1620 }
1621 if ($value == 'localtax1_type') {
1622 $valuetoshow = $langs->trans("UseLocalTax")." 2";
1623 $class = "center";
1624 $sortable = 0;
1625 }
1626 if ($value == 'localtax1') {
1627 $valuetoshow = $langs->trans("RateOfTaxN", '2');
1628 $class = "center minwidth75";
1629 }
1630 if ($value == 'localtax2_type') {
1631 $valuetoshow = $langs->trans("UseLocalTax")." 3";
1632 $class = "center";
1633 $sortable = 0;
1634 }
1635 if ($value == 'localtax2') {
1636 $valuetoshow = $langs->trans("RateOfTaxN", '3');
1637 $class = "center minwidth75";
1638 }
1639 if ($value == 'type_vat') {
1640 $valuetoshow = $langs->trans("VATType");
1641 }
1642 if ($value == 'organization') {
1643 $valuetoshow = $langs->trans("Organization");
1644 }
1645 if ($value == 'lang') {
1646 $valuetoshow = $langs->trans("Language");
1647 }
1648 if ($value == 'type') {
1649 if ($tabname[$id] == "c_paiement") {
1650 $valuetoshow = $form->textwithtooltip($langs->trans("Type"), $langs->trans("TypePaymentDesc"), 2, 1, img_help(1, ''));
1651 } else {
1652 $valuetoshow = $langs->trans("Type");
1653 }
1654 }
1655 if ($value == 'code') {
1656 $valuetoshow = $langs->trans("Code");
1657 $class = 'maxwidth100';
1658 }
1659 if ($value == 'libelle' || $value == 'label') {
1660 $valuetoshow = $form->textwithtooltip($langs->trans("Label"), $langs->trans("LabelUsedByDefault"), 2, 1, img_help(1, ''));
1661 }
1662 if ($value == 'libelle_facture') {
1663 $valuetoshow = $form->textwithtooltip($langs->trans("LabelOnDocuments"), $langs->trans("LabelUsedByDefault"), 2, 1, img_help(1, ''));
1664 }
1665 if ($value == 'deposit_percent') {
1666 $valuetoshow = $langs->trans('DepositPercent');
1667 $class = 'right';
1668 }
1669 if ($value == 'country') {
1670 if (in_array('region_id', $fieldlist)) {
1671 //print '<td>&nbsp;</td>';
1672 continue;
1673 } // For region page, we do not show the country input
1674 $valuetoshow = $langs->trans("Country");
1675 }
1676 if ($value == 'department_buyer') {
1677 $valuetoshow = '';
1678 }
1679 if ($value == 'recuperableonly') {
1680 $valuetoshow = $langs->trans("NPR");
1681 $class = "center";
1682 }
1683 if ($value == 'nbjour') {
1684 $valuetoshow = $langs->trans("NbOfDays");
1685 $class = 'right';
1686 }
1687 if ($value == 'type_cdr') {
1688 $valuetoshow = $langs->trans("AtEndOfMonth");
1689 $class = "center";
1690 }
1691 if ($value == 'decalage') {
1692 $valuetoshow = $langs->trans("Offset");
1693 $class = 'right';
1694 }
1695 if ($value == 'width' || $value == 'nx') {
1696 $valuetoshow = $langs->trans("Width");
1697 }
1698 if ($value == 'height' || $value == 'ny') {
1699 $valuetoshow = $langs->trans("Height");
1700 }
1701 if ($value == 'unit' || $value == 'metric') {
1702 $valuetoshow = $langs->trans("MeasuringUnit");
1703 }
1704 if ($value == 'region_id' || $value == 'country_id' || $value == 'department_buyer_id') {
1705 $valuetoshow = '';
1706 }
1707 if ($value == 'accountancy_code') {
1708 $valuetoshow = $langs->trans("AccountancyCode");
1709 }
1710 if ($value == 'accountancy_code_sell') {
1711 $valuetoshow = $langs->trans("AccountancyCodeSell");
1712 }
1713 if ($value == 'accountancy_code_buy') {
1714 $valuetoshow = $langs->trans("AccountancyCodeBuy");
1715 }
1716 if ($value == 'pcg_version' || $value == 'fk_pcg_version') {
1717 $valuetoshow = $langs->trans("Pcg_version");
1718 }
1719 if ($value == 'account_parent') {
1720 $valuetoshow = $langs->trans("Accountparent");
1721 }
1722 if ($value == 'pcg_type') {
1723 $valuetoshow = $langs->trans("Pcg_type");
1724 }
1725 if ($value == 'pcg_subtype') {
1726 $valuetoshow = $langs->trans("Pcg_subtype");
1727 }
1728 if ($value == 'sortorder') {
1729 $valuetoshow = $langs->trans("SortOrder");
1730 $class = 'center';
1731 }
1732 if ($value == 'short_label') {
1733 $valuetoshow = $langs->trans("ShortLabel");
1734 }
1735 if ($value == 'fk_parent') {
1736 $valuetoshow = $langs->trans("ParentID");
1737 $class = 'center';
1738 }
1739 if ($value == 'range_account') {
1740 $valuetoshow = $langs->trans("Range");
1741 }
1742 if ($value == 'sens') {
1743 $valuetoshow = $langs->trans("Sens");
1744 }
1745 if ($value == 'category_type') {
1746 $valuetoshow = $langs->trans("Calculated");
1747 }
1748 if ($value == 'formula') {
1749 $valuetoshow = $langs->trans("Formula");
1750 }
1751 if ($value == 'paper_size') {
1752 $valuetoshow = $langs->trans("PaperSize");
1753 }
1754 if ($value == 'orientation') {
1755 $valuetoshow = $langs->trans("Orientation");
1756 }
1757 if ($value == 'leftmargin') {
1758 $valuetoshow = $langs->trans("LeftMargin");
1759 }
1760 if ($value == 'topmargin') {
1761 $valuetoshow = $langs->trans("TopMargin");
1762 }
1763 if ($value == 'spacex') {
1764 $valuetoshow = $langs->trans("SpaceX");
1765 }
1766 if ($value == 'spacey') {
1767 $valuetoshow = $langs->trans("SpaceY");
1768 }
1769 if ($value == 'font_size') {
1770 $valuetoshow = $langs->trans("FontSize");
1771 }
1772 if ($value == 'custom_x') {
1773 $valuetoshow = $langs->trans("CustomX");
1774 }
1775 if ($value == 'custom_y') {
1776 $valuetoshow = $langs->trans("CustomY");
1777 }
1778 if ($value == 'percent') {
1779 $valuetoshow = $langs->trans("Percentage");
1780 }
1781 if ($value == 'affect') {
1782 $valuetoshow = $langs->trans("WithCounter");
1783 }
1784 if ($value == 'delay') {
1785 $valuetoshow = $langs->trans("NoticePeriod");
1786 }
1787 if ($value == 'newbymonth') {
1788 $valuetoshow = $langs->trans("NewByMonth");
1789 }
1790 if ($value == 'fk_tva') {
1791 $valuetoshow = $langs->trans("VAT");
1792 }
1793 if ($value == 'range_ik') {
1794 $valuetoshow = $langs->trans("RangeIk");
1795 }
1796 if ($value == 'fk_c_exp_tax_cat') {
1797 $valuetoshow = $langs->trans("CarCategory");
1798 }
1799 if ($value == 'revenuestamp_type') {
1800 $valuetoshow = $langs->trans('TypeOfRevenueStamp');
1801 }
1802 if ($value == 'use_default') {
1803 $valuetoshow = $langs->trans('Default');
1804 $class = 'center';
1805 }
1806 if ($value == 'unit_type') {
1807 $valuetoshow = $langs->trans('TypeOfUnit');
1808 }
1809 if ($value == 'public' && $tablib[$id] == 'TicketDictCategory') {
1810 $valuetoshow = $langs->trans('TicketGroupIsPublic');
1811 $class = 'center';
1812 }
1813 if ($value == 'block_if_negative') {
1814 $valuetoshow = $langs->trans('BlockHolidayIfNegative');
1815 }
1816 if ($value == 'type_duration') {
1817 $valuetoshow = $langs->trans('Unit');
1818 }
1819
1820 if ($id == DICT_DEPARTEMENTS) { // Special case for state page
1821 if ($value == 'region_id') {
1822 $valuetoshow = '&nbsp;';
1823 $showfield = 1;
1824 }
1825 if ($value == 'region') {
1826 $valuetoshow = $langs->trans("Country").'/'.$langs->trans("Region");
1827 $showfield = 1;
1828 }
1829 }
1830
1831 if ($valuetoshow != '') {
1832 $tooltiphelp = (isset($tabcomplete[$tabname[$id]]['help'][$value]) ? $tabcomplete[$tabname[$id]]['help'][$value] : '');
1833
1834 $tdsoffields .= '<th'.($class ? ' class="'.$class.'"' : '').'>';
1835 if ($tooltiphelp && preg_match('/^http(s*):/i', $tooltiphelp)) {
1836 $tdsoffields .= '<a href="'.$tooltiphelp.'" target="_blank">'.$valuetoshow.' '.img_help(1, $valuetoshow).'</a>';
1837 } elseif ($tooltiphelp) {
1838 $tdsoffields .= $form->textwithpicto($valuetoshow, $tooltiphelp);
1839 } else {
1840 $tdsoffields .= $valuetoshow;
1841 }
1842 $tdsoffields .= '</th>';
1843 }
1844 }
1845
1846 if ($id == DICT_COUNTRY) {
1847 $tdsoffields .= '<th></th>';
1848 $tdsoffields .= '<th></th>';
1849 }
1850 $tdsoffields .= '<th>';
1851 $tdsoffields .= '<input type="hidden" name="id" value="'.$id.'">';
1852 if (!is_null($withentity)) {
1853 $tdsoffields .= '<input type="hidden" name="entity" value="'.$withentity.'">';
1854 }
1855 $tdsoffields .= '</th>';
1856 $tdsoffields .= '<th style="min-width: 26px;"></th>';
1857 $tdsoffields .= '<th style="min-width: 26px;"></th>';
1858 $tdsoffields .= '</tr>';
1859
1860 print $tdsoffields;
1861
1862
1863 // Line to enter new values
1864 print '<!-- line input to add new entry -->';
1865 print '<tr class="oddeven nodrag nodrop nohover">';
1866
1867 $obj = new stdClass();
1868 // If data was already input, we define them in obj to populate input fields.
1869 if (GETPOST('actionadd')) {
1870 foreach ($fieldlist as $key => $val) {
1871 if (GETPOST($val) != '') {
1872 $obj->$val = GETPOST($val);
1873 }
1874 }
1875 }
1876
1877 $tmpaction = 'create';
1878 $parameters = array('fieldlist' => $fieldlist, 'tabname' => $tabname[$id]);
1879 $reshook = $hookmanager->executeHooks('createDictionaryFieldlist', $parameters, $obj, $tmpaction); // Note that $action and $object may have been modified by some hooks
1880 $error = $hookmanager->error;
1881 $errors = $hookmanager->errors;
1882
1883 if ($id == DICT_REGIONS) {
1884 unset($fieldlist[2]); // Remove field ??? if dictionary Regions
1885 }
1886
1887 if (empty($reshook)) {
1888 dictFieldList($fieldlist, $obj, $tabname[$id], 'add');
1889 }
1890
1891 if ($id == DICT_COUNTRY) {
1892 print '<td></td>';
1893 print '<td></td>';
1894 print '<td></td>';
1895 }
1896 print '<td colspan="3" class="center">';
1897 if ($action != 'edit') {
1898 print '<input type="submit" class="button button-add small" name="actionadd" value="'.$langs->trans("Add").'">';
1899 } else {
1900 print '<input type="submit" class="button button-add small disabled" name="actionadd" value="'.$langs->trans("Add").'">';
1901 }
1902 print '</td>';
1903
1904 print "</tr>";
1905
1906 print '</table>';
1907 print '</div>';
1908 }
1909
1910 print '</form>';
1911
1912 print '<form action="'.$_SERVER['PHP_SELF'].'?id='.$id.'" method="POST">';
1913 print '<input type="hidden" name="token" value="'.newToken().'">';
1914 print '<input type="hidden" name="from" value="'.dol_escape_htmltag(GETPOST('from', 'alpha')).'">';
1915 }
1916
1917
1918 $filterfound = 0;
1919 foreach ($fieldlist as $field => $value) {
1920 if ($value == 'entity') {
1921 continue;
1922 }
1923
1924 $showfield = 1; // By default
1925 if ($value == 'region_id' || $value == 'country_id' || $value == 'department_buyer_id') {
1926 $showfield = 0;
1927 }
1928
1929 if ($showfield) {
1930 if ($value == 'country') {
1931 $filterfound++;
1932 } elseif ($value == 'code') {
1933 $filterfound++;
1934 }
1935 }
1936 }
1937
1938 print '<div class="div-table-responsive">';
1939 print '<table class="noborder centpercent noborder">';
1940
1941 $colspan = 0;
1942
1943 // Title line with search input fields
1944 print '<!-- line title to search record -->'."\n";
1945 print '<tr class="liste_titre_filter">';
1946
1947 // Action button
1948 if (getDolGlobalString('MAIN_CHECKBOX_LEFT_COLUMN')) {
1949 print '<td class="liste_titre center">';
1950 if ($filterfound) {
1951 $searchpicto = $form->showFilterAndCheckAddButtons(0);
1952 print $searchpicto;
1953 }
1954 print '</td>';
1955 $colspan++;
1956 }
1957
1958 foreach ($fieldlist as $field => $value) {
1959 if ($value == 'entity') {
1960 continue;
1961 }
1962
1963 $showfield = 1; // By default
1964 if ($value == 'region_id' || $value == 'country_id' || $value == 'department_buyer_id') {
1965 $showfield = 0;
1966 }
1967
1968 if ($showfield) {
1969 if ($value == 'country') {
1970 print '<td class="liste_titre">';
1971 print $form->select_country($search_country_id, 'search_country_id', '', 28, 'minwidth100 maxwidth150 maxwidthonsmartphone', '', '&nbsp;');
1972 print '</td>';
1973 $colspan++;
1974 } elseif ($value == 'code') {
1975 print '<td class="liste_titre">';
1976 print '<input type="text" class="maxwidth100" name="search_code" value="'.dol_escape_htmltag($search_code).'">';
1977 print '</td>';
1978 $colspan++;
1979 } elseif ($value == 'type_vat') {
1980 print '<td class="liste_titre">';
1981 print $form->selectarray('search_'.$value, $type_vatList, (empty($obj->{$value}) ? '' : $obj->{$value}), 1);
1982 print '</td>';
1983 $colspan++;
1984 } else {
1985 print '<td class="liste_titre">';
1986 print '</td>';
1987 $colspan++;
1988 }
1989 }
1990 }
1991 if ($id == DICT_COUNTRY) {
1992 print '<td></td>';
1993 $colspan++;
1994 print '<td></td>';
1995 $colspan++;
1996 print '<td></td>';
1997 $colspan++;
1998 }
1999
2000 // Active
2001 print '<td class="liste_titre center parentonrightofpage">';
2002 print $form->selectyesno('search_active', $search_active, 0, false, 1, 1, 'maxwidth100 onrightofpage', 'Activated', 'Disabled');
2003 print '</td>';
2004 $colspan++;
2005
2006 // Action button
2007 if (!getDolGlobalString('MAIN_CHECKBOX_LEFT_COLUMN')) {
2008 print '<td class="liste_titre center">';
2009 if ($filterfound) {
2010 $searchpicto = $form->showFilterAndCheckAddButtons(0);
2011 print $searchpicto;
2012 }
2013 print '</td>';
2014 $colspan++;
2015 }
2016
2017 print '</tr>';
2018
2019
2020 // Title of lines
2021 print '<!-- line title of record -->'."\n";
2022 print '<tr class="liste_titre">';
2023
2024 // Action button
2025 if (getDolGlobalString('MAIN_CHECKBOX_LEFT_COLUMN')) {
2026 print getTitleFieldOfList('');
2027 }
2028
2029 foreach ($fieldlist as $field => $value) {
2030 if ($value == 'entity') {
2031 continue;
2032 }
2033
2034 if (in_array($value, array('label', 'libelle', 'libelle_facture')) && empty($tabcomplete[$tabname[$id]]['help'][$value])) {
2035 if (!isset($tabcomplete[$tabname[$id]]['help']) || !is_array($tabcomplete[$tabname[$id]]['help'])) { // protection when $tabcomplete[$tabname[$id]]['help'] is a an empty string, we must force it into an array
2036 $tabcomplete[$tabname[$id]]['help'] = array();
2037 }
2038 $tabcomplete[$tabname[$id]]['help'][$value] = $langs->trans('LabelUsedByDefault');
2039 }
2040
2041 // Determines the name of the field in relation to the possible names
2042 // in data dictionaries
2043 $showfield = 1; // By default
2044 $cssprefix = '';
2045 $sortable = 1;
2046 $valuetoshow = ucfirst($value); // By default
2047 $valuetoshow = $langs->trans($valuetoshow); // try to translate
2048
2049 // Special cases
2050 if ($value == 'source') {
2051 $valuetoshow = $langs->trans("Contact");
2052 }
2053 if ($value == 'price') {
2054 $valuetoshow = $langs->trans("PriceUHT");
2055 }
2056 if ($value == 'taux') {
2057 if ($tabname[$id] != "c_revenuestamp") {
2058 $valuetoshow = $langs->trans("Rate");
2059 } else {
2060 $valuetoshow = $langs->trans("Amount");
2061 }
2062 $cssprefix = 'center ';
2063 }
2064
2065 if ($value == 'type_vat') {
2066 $valuetoshow = $langs->trans("VATType");
2067 $cssprefix = "center minwidth75 ";
2068 $sortable = 0;
2069 }
2070 if ($value == 'localtax1_type') {
2071 $valuetoshow = $langs->trans("UseLocalTax")." 2";
2072 $cssprefix = "center minwidth75 ";
2073 $sortable = 0;
2074 }
2075 if ($value == 'localtax1') {
2076 $valuetoshow = $langs->trans("RateOfTaxN", '2');
2077 $cssprefix = "center minwidth75 ";
2078 $sortable = 0;
2079 }
2080 if ($value == 'localtax2_type') {
2081 $valuetoshow = $langs->trans("UseLocalTax")." 3";
2082 $cssprefix = "center minwidth75 ";
2083 $sortable = 0;
2084 }
2085 if ($value == 'localtax2') {
2086 $valuetoshow = $langs->trans("RateOfTaxN", '3');
2087 $cssprefix = "center minwidth75 ";
2088 $sortable = 0;
2089 }
2090 if ($value == 'organization') {
2091 $valuetoshow = $langs->trans("Organization");
2092 }
2093 if ($value == 'lang') {
2094 $valuetoshow = $langs->trans("Language");
2095 }
2096 if ($value == 'type') {
2097 $valuetoshow = $langs->trans("Type");
2098 }
2099 if ($value == 'code') {
2100 $valuetoshow = $langs->trans("Code");
2101 }
2102 if (in_array($value, array('pos', 'position'))) {
2103 $valuetoshow = $langs->trans("Position");
2104 $cssprefix = 'right ';
2105 }
2106 if ($value == 'libelle' || $value == 'label') {
2107 $valuetoshow = $langs->trans("Label");
2108 }
2109 if ($value == 'libelle_facture') {
2110 $valuetoshow = $langs->trans("LabelOnDocuments");
2111 }
2112 if ($value == 'deposit_percent') {
2113 $valuetoshow = $langs->trans('DepositPercent');
2114 $cssprefix = 'right ';
2115 }
2116 if ($value == 'country') {
2117 $valuetoshow = $langs->trans("Country");
2118 }
2119 if ($value == 'department_buyer') {
2120 $valuetoshow = $langs->trans('DepartmentBuyer');
2121 }
2122 if ($value == 'recuperableonly') {
2123 $valuetoshow = $langs->trans("NPR");
2124 $cssprefix = "center ";
2125 }
2126 if ($value == 'nbjour') {
2127 $valuetoshow = $langs->trans("NbOfDays");
2128 $cssprefix = 'right ';
2129 }
2130 if ($value == 'type_cdr') {
2131 $valuetoshow = $langs->trans("AtEndOfMonth");
2132 $cssprefix = "center ";
2133 }
2134 if ($value == 'decalage') {
2135 $valuetoshow = $langs->trans("Offset");
2136 $cssprefix = 'right ';
2137 }
2138 if ($value == 'width' || $value == 'nx') {
2139 $valuetoshow = $langs->trans("Width");
2140 }
2141 if ($value == 'height' || $value == 'ny') {
2142 $valuetoshow = $langs->trans("Height");
2143 }
2144 if ($value == 'unit' || $value == 'metric') {
2145 $valuetoshow = $langs->trans("MeasuringUnit");
2146 }
2147 if ($value == 'accountancy_code') {
2148 $valuetoshow = $langs->trans("AccountancyCode");
2149 }
2150 if ($value == 'accountancy_code_sell') {
2151 $valuetoshow = $langs->trans("AccountancyCodeSell");
2152 $sortable = 0;
2153 }
2154 if ($value == 'accountancy_code_buy') {
2155 $valuetoshow = $langs->trans("AccountancyCodeBuy");
2156 $sortable = 0;
2157 }
2158 if ($value == 'fk_pcg_version') {
2159 $valuetoshow = $langs->trans("Pcg_version");
2160 }
2161 if ($value == 'account_parent') {
2162 $valuetoshow = $langs->trans("Accountsparent");
2163 }
2164 if ($value == 'pcg_type') {
2165 $valuetoshow = $langs->trans("Pcg_type");
2166 }
2167 if ($value == 'pcg_subtype') {
2168 $valuetoshow = $langs->trans("Pcg_subtype");
2169 }
2170 if ($value == 'sortorder') {
2171 $valuetoshow = $langs->trans("SortOrder");
2172 $cssprefix = 'center ';
2173 }
2174 if ($value == 'short_label') {
2175 $valuetoshow = $langs->trans("ShortLabel");
2176 }
2177 if ($value == 'fk_parent') {
2178 $valuetoshow = $langs->trans("ParentID");
2179 $cssprefix = 'center ';
2180 }
2181 if ($value == 'range_account') {
2182 $valuetoshow = $langs->trans("Range");
2183 }
2184 if ($value == 'sens') {
2185 $valuetoshow = $langs->trans("Sens");
2186 }
2187 if ($value == 'category_type') {
2188 $valuetoshow = $langs->trans("Calculated");
2189 }
2190 if ($value == 'formula') {
2191 $valuetoshow = $langs->trans("Formula");
2192 }
2193 if ($value == 'paper_size') {
2194 $valuetoshow = $langs->trans("PaperSize");
2195 }
2196 if ($value == 'orientation') {
2197 $valuetoshow = $langs->trans("Orientation");
2198 }
2199 if ($value == 'leftmargin') {
2200 $valuetoshow = $langs->trans("LeftMargin");
2201 }
2202 if ($value == 'topmargin') {
2203 $valuetoshow = $langs->trans("TopMargin");
2204 }
2205 if ($value == 'spacex') {
2206 $valuetoshow = $langs->trans("SpaceX");
2207 }
2208 if ($value == 'spacey') {
2209 $valuetoshow = $langs->trans("SpaceY");
2210 }
2211 if ($value == 'font_size') {
2212 $valuetoshow = $langs->trans("FontSize");
2213 }
2214 if ($value == 'custom_x') {
2215 $valuetoshow = $langs->trans("CustomX");
2216 }
2217 if ($value == 'custom_y') {
2218 $valuetoshow = $langs->trans("CustomY");
2219 }
2220 if ($value == 'percent') {
2221 $valuetoshow = $langs->trans("Percentage");
2222 }
2223 if ($value == 'affect') {
2224 $valuetoshow = $langs->trans("WithCounter");
2225 }
2226 if ($value == 'delay') {
2227 $valuetoshow = $langs->trans("NoticePeriod");
2228 }
2229 if ($value == 'newbymonth') {
2230 $valuetoshow = $langs->trans("NewByMonth");
2231 }
2232 if ($value == 'fk_tva') {
2233 $valuetoshow = $langs->trans("VAT");
2234 }
2235 if ($value == 'range_ik') {
2236 $valuetoshow = $langs->trans("RangeIk");
2237 }
2238 if ($value == 'fk_c_exp_tax_cat') {
2239 $valuetoshow = $langs->trans("CarCategory");
2240 }
2241 if ($value == 'revenuestamp_type') {
2242 $valuetoshow = $langs->trans('TypeOfRevenueStamp');
2243 }
2244 if ($value == 'use_default') {
2245 $valuetoshow = $langs->trans('Default');
2246 $cssprefix = 'center ';
2247 }
2248 if ($value == 'unit_type') {
2249 $valuetoshow = $langs->trans('TypeOfUnit');
2250 }
2251 if ($value == 'public' && $tablib[$id] == 'TicketDictCategory') {
2252 $valuetoshow = $langs->trans('TicketGroupIsPublic');
2253 $cssprefix = 'center ';
2254 }
2255 if ($value == 'block_if_negative') {
2256 $valuetoshow = $langs->trans('BlockHolidayIfNegative');
2257 }
2258 if ($value == 'type_duration') {
2259 $valuetoshow = $langs->trans('Unit');
2260 }
2261
2262 if ($value == 'region_id' || $value == 'country_id' || $value == 'department_buyer_id') {
2263 $showfield = 0;
2264 }
2265
2266 // Show field title
2267 if ($showfield) {
2268 $tooltiphelp = (isset($tabcomplete[$tabname[$id]]['help'][$value]) ? $tabcomplete[$tabname[$id]]['help'][$value] : '');
2269
2270 if ($tooltiphelp && preg_match('/^http(s*):/i', $tooltiphelp)) {
2271 $newvaluetoshow = '<a href="'.$tooltiphelp.'" target="_blank">'.$valuetoshow.' '.img_help(1, $valuetoshow).'</a>';
2272 } elseif ($tooltiphelp) {
2273 $newvaluetoshow = $form->textwithpicto($valuetoshow, $tooltiphelp);
2274 } else {
2275 $newvaluetoshow = $valuetoshow;
2276 }
2277
2278 print getTitleFieldOfList($newvaluetoshow, 0, $_SERVER["PHP_SELF"], ($sortable ? $value : ''), ($page ? 'page='.$page.'&' : ''), $param, '', $sortfield, $sortorder, $cssprefix);
2279 }
2280 }
2281 // Favorite, EEC & Sepa - Only activated on country dictionary
2282 if ($id == DICT_COUNTRY) {
2283 print getTitleFieldOfList($langs->trans("InEEC"), 0, $_SERVER["PHP_SELF"], "eec", ($page ? 'page='.$page.'&' : ''), $param, '', $sortfield, $sortorder, 'center ', 0, $langs->trans("CountryIsInEEC"));
2284 print getTitleFieldOfList($langs->trans("InSepa"), 0, $_SERVER["PHP_SELF"], "sepa", ($page ? 'page='.$page.'&' : ''), $param, '', $sortfield, $sortorder, 'center ', 0, $langs->trans("CountryIsInSepa"));
2285 print getTitleFieldOfList($langs->trans("Favorite"), 0, $_SERVER["PHP_SELF"], "favorite", ($page ? 'page='.$page.'&' : ''), $param, '', $sortfield, $sortorder, 'center ');
2286 }
2287
2288 // Status
2289 print getTitleFieldOfList($langs->trans("Status"), 0, $_SERVER["PHP_SELF"], "active", ($page ? 'page='.$page.'&' : ''), $param, '', $sortfield, $sortorder, 'center ');
2290
2291 // Action button
2292 if (!getDolGlobalString('MAIN_CHECKBOX_LEFT_COLUMN')) {
2293 print getTitleFieldOfList('');
2294 }
2295 print '</tr>';
2296
2297
2298 // Lines with values
2299 if ($num) {
2300 print '<!-- lines of dict -->'."\n";
2301 while ($i < $num) {
2302 $obj = $db->fetch_object($resql);
2303
2304 $withentity = null;
2305
2306 // We discard empty lines
2307 if ($id == DICT_COUNTRY) {
2308 if ($obj->code == '') {
2309 $i++;
2310 continue;
2311 }
2312 }
2313
2314 // Can an entry be erased, disabled or modified ? (true by default)
2315 $iserasable = 1;
2316 $canbedisabled = 1;
2317 $canbemodified = 1;
2318 if (isset($obj->code) && $id != DICT_TVA && $id != DICT_PRODUCT_NATURE) {
2319 if (($obj->code == '0' || $obj->code == '' || preg_match('/unknown/i', $obj->code))) {
2320 $iserasable = 0;
2321 $canbedisabled = 0;
2322 } elseif ($obj->code == 'RECEP') {
2323 $iserasable = 0;
2324 $canbedisabled = 0;
2325 } elseif ($obj->code == 'EF0') {
2326 $iserasable = 0;
2327 $canbedisabled = 0;
2328 }
2329 }
2330 if ($id == DICT_TYPE_CONTAINER && $obj->module == 'system') {
2331 $iserasable = 0;
2332 $canbedisabled = 0;
2333 if (in_array($obj->code, array('banner'))) {
2334 $canbedisabled = 1;
2335 }
2336 }
2337 if (isset($obj->type) && in_array($obj->type, array('system', 'systemauto'))) {
2338 $iserasable = 0;
2339 }
2340 if (in_array(empty($obj->code) ? '' : $obj->code, array('AC_OTH', 'AC_OTH_AUTO')) || in_array(empty($obj->type) ? '' : $obj->type, array('systemauto'))) {
2341 $canbedisabled = 0;
2342 $canbedisabled = 0;
2343 }
2344 $canbemodified = $iserasable;
2345
2346 if (!empty($obj->code) && $obj->code == 'RECEP') {
2347 $canbemodified = 1;
2348 }
2349 if ($tabname[$id] == "c_actioncomm") {
2350 $canbemodified = 1;
2351 }
2352
2353 if ($tabname[$id] == "c_product_nature" && in_array($obj->code, array(0, 1))) {
2354 $canbedisabled = 0;
2355 $canbemodified = 0;
2356 $iserasable = 0;
2357 }
2358 // Build Url. The table is id=, the id of line is rowid=
2359 $rowidcol = empty($tabrowid[$id]) ? 'rowid' : $tabrowid[$id];
2360 // If rowidcol not defined
2361 if (empty($rowidcol) || in_array($id, array(DICT_ACTIONCOMM, DICT_CHARGESOCIALES, DICT_TYPENT, DICT_PAIEMENT, DICT_TYPE_FEES, DICT_EFFECTIF, DICT_STCOMM, DICT_HRM_PUBLIC_HOLIDAY))) {
2362 $rowidcol = 'rowid';
2363 }
2364 $url = $_SERVER["PHP_SELF"].'?'.($page ? 'page='.$page.'&' : '').'sortfield='.urlencode($sortfield).'&sortorder='.urlencode($sortorder);
2365 $url .= '&rowid='.(isset($obj->$rowidcol) ? ((int) $obj->$rowidcol) : (!empty($obj->code) ? urlencode($obj->code) : ''));
2366 $url .= '&code='.(!empty($obj->code) ? urlencode($obj->code) : '');
2367 if (!empty($param)) {
2368 $url .= '&'.$param;
2369 }
2370 // If dictionary is different for each entity
2371 if (!is_null($withentity)) {
2372 $url .= '&entity='.((int) $withentity);
2373 }
2374 $url .= '&';
2375
2376
2377 //print_r($obj);
2378 print '<tr class="oddeven" id="rowid-'.(empty($obj->rowid) ? '' : $obj->rowid).'">';
2379
2380 // Action button
2381 if (getDolGlobalString('MAIN_CHECKBOX_LEFT_COLUMN')) {
2382 print '<td class="center maxwidthsearch nowraponall">';
2383 // Modify link
2384 if ($canbemodified) {
2385 print '<a class="reposition editfielda marginleftonly paddingleft marginrightonly paddingright" href="'.$url.'action=edit&token='.newToken().'">'.img_edit().'</a>';
2386 }
2387 // Delete link
2388 if ($iserasable) {
2389 if ($user->admin) {
2390 print '<a class="reposition marginleftonly paddingleft marginrightonly paddingright" href="'.$url.'action=delete&token='.newToken().'">'.img_delete().'</a>';
2391 }
2392 }
2393 print '</td>';
2394 }
2395
2396 if ($action == 'edit' && ($rowid == (isset($obj->rowid) ? $obj->rowid : $obj->code))) {
2397 $tmpaction = 'edit';
2398 $parameters = array('fieldlist' => $fieldlist, 'tabname' => $tabname[$id]);
2399 $reshook = $hookmanager->executeHooks('editDictionaryFieldlist', $parameters, $obj, $tmpaction); // Note that $action and $object may have been modified by some hooks
2400 $error = $hookmanager->error;
2401 $errors = $hookmanager->errors;
2402
2403 // Show fields
2404 if (empty($reshook)) {
2405 $withentity = dictFieldList($fieldlist, $obj, $tabname[$id], 'edit');
2406 }
2407
2408 print '<td colspan="3" class="center">';
2409 print '<div name="'.(isset($obj->rowid) ? $obj->rowid : $obj->code).'"></div>';
2410 print '<input type="hidden" name="page" value="'.((int) $page).'">';
2411 print '<input type="hidden" name="rowid" value="'.dol_escape_htmltag($rowid).'">';
2412 if (!is_null($withentity)) {
2413 print '<input type="hidden" name="entity" value="'.$withentity.'">';
2414 }
2415 print '<input type="submit" class="button button-edit smallpaddingimp" name="actionmodify" value="'.$langs->trans("Modify").'">';
2416 print '<input type="submit" class="button button-cancel smallpaddingimp" name="actioncancel" value="'.$langs->trans("Cancel").'">';
2417 print '</td>';
2418 } else {
2419 $tmpaction = 'view';
2420 $parameters = array('fieldlist' => $fieldlist, 'tabname' => $tabname[$id]);
2421 $reshook = $hookmanager->executeHooks('viewDictionaryFieldlist', $parameters, $obj, $tmpaction); // Note that $action and $object may have been modified by some hooks
2422
2423 $error = $hookmanager->error;
2424 $errors = $hookmanager->errors;
2425
2426 $langs->loadLangs(array("bills", "agenda", "propal"));
2427
2428 if (empty($reshook)) {
2429 $withentity = null;
2430
2431 foreach ($fieldlist as $field => $value) {
2432 //var_dump($fieldlist);
2433 $class = '';
2434 $showfield = 1;
2435 $valuetoshow = empty($obj->$value) ? '' : $obj->$value;
2436 $titletoshow = '';
2437
2438 if ($value == 'entity') {
2439 $withentity = $valuetoshow;
2440 continue;
2441 }
2442
2443 // Management of several special cases and exceptions
2444 if ($value == 'code' && $id == DICT_PRODUCT_NATURE) {
2445 $valuetoshow = (int) $valuetoshow;
2446 } elseif ($value == 'element') {
2447 $valuetoshow = isset($elementList[$valuetoshow]) ? $elementList[$valuetoshow] : $valuetoshow;
2448 } elseif ($value == 'source') {
2449 $valuetoshow = isset($sourceList[$valuetoshow]) ? $sourceList[$valuetoshow] : $valuetoshow;
2450 } elseif ($valuetoshow == 'all') {
2451 $valuetoshow = $langs->trans('All');
2452 } elseif ($value == 'country') {
2453 if (empty($obj->country_code)) {
2454 $valuetoshow = '-';
2455 } else {
2456 $key = $langs->trans("Country".strtoupper($obj->country_code));
2457 $valuetoshow = ($key != "Country".strtoupper($obj->country_code) ? $obj->country_code." - ".$key : $obj->country);
2458 }
2459 } elseif ($value == 'recuperableonly' || $value == 'deductible' || $value == 'category_type') {
2460 $valuetoshow = yn($valuetoshow ? 1 : 0);
2461 $class = "center";
2462 } elseif ($value == 'type_cdr') {
2463 if (empty($valuetoshow)) {
2464 $valuetoshow = $langs->trans('None');
2465 } elseif ($valuetoshow == 1) {
2466 $valuetoshow = $langs->trans('AtEndOfMonth');
2467 } elseif ($valuetoshow == 2) {
2468 $valuetoshow = $langs->trans('CurrentNext');
2469 }
2470 $class = "center tdoverflowmax125";
2471 } elseif ($value == 'price' || preg_match('/^amount/i', $value)) {
2472 $valuetoshow = price($valuetoshow);
2473 }
2474 if (in_array($value, array('private', 'joinfile', 'use_default'))) {
2475 if ($valuetoshow) {
2476 $valuetoshow = yn($valuetoshow);
2477 }
2478 } elseif ($value == 'libelle_facture') {
2479 $key = $langs->trans("PaymentCondition".strtoupper($obj->code));
2480 $valuetoshow = ($obj->code && $key != "PaymentCondition".strtoupper($obj->code) ? $key : $obj->$value);
2481 $valuetoshow = nl2br($valuetoshow);
2482 $titletoshow = $valuetoshow;
2483 $class = 'small tdoverflowmax200';
2484 } elseif ($value == 'label' && $tabname[$id] == 'c_country') {
2485 $key = $langs->trans("Country".strtoupper($obj->code));
2486 $valuetoshow = ($obj->code && $key != "Country".strtoupper($obj->code) ? $key : $obj->$value);
2487 } elseif ($value == 'label' && $tabname[$id] == 'c_availability') {
2488 $key = $langs->trans("AvailabilityType".strtoupper($obj->code));
2489 $valuetoshow = ($obj->code && $key != "AvailabilityType".strtoupper($obj->code) ? $key : $obj->$value);
2490 } elseif ($value == 'libelle' && $tabname[$id] == 'c_actioncomm') {
2491 $key = $langs->trans("Action".strtoupper($obj->code));
2492 $valuetoshow = ($obj->code && $key != "Action".strtoupper($obj->code) ? $key : $obj->$value);
2493 } elseif (!empty($obj->code_iso) && $value == 'label' && $tabname[$id] == 'c_currencies') {
2494 $key = $langs->trans("Currency".strtoupper($obj->code_iso));
2495 $valuetoshow = (/* $obj->code_iso && */ $key != "Currency".strtoupper($obj->code_iso) ? $key : $obj->$value);
2496 } elseif ($value == 'libelle' && $tabname[$id] == 'c_typent') {
2497 $key = $langs->trans(strtoupper($obj->code));
2498 $valuetoshow = ($key != strtoupper($obj->code) ? $key : $obj->$value);
2499 } elseif ($value == 'libelle' && $tabname[$id] == 'c_prospectlevel') {
2500 $key = $langs->trans(strtoupper($obj->code));
2501 $valuetoshow = ($key != strtoupper($obj->code) ? $key : $obj->$value);
2502 } elseif ($value == 'label' && $tabname[$id] == 'c_civility') {
2503 $key = $langs->trans("Civility".strtoupper($obj->code));
2504 $valuetoshow = ($obj->code && $key != "Civility".strtoupper($obj->code) ? $key : $obj->$value);
2505 } elseif ($value == 'libelle' && $tabname[$id] == 'c_type_contact') {
2506 $key = $langs->trans("TypeContact_".$obj->element."_".$obj->source."_".strtoupper($obj->code));
2507 $valuetoshow = ($obj->code && $key != "TypeContact_".$obj->element."_".$obj->source."_".strtoupper($obj->code) ? $key : $obj->$value);
2508 } elseif ($value == 'libelle' && $tabname[$id] == 'c_payment_term') {
2509 $key = $langs->trans("PaymentConditionShort".strtoupper($obj->code));
2510 $valuetoshow = ($obj->code && $key != "PaymentConditionShort".strtoupper($obj->code) ? $key : $obj->$value);
2511 $titletoshow = $key;
2512 $class = "tdoverflowmax150";
2513 } elseif ($value == 'libelle' && $tabname[$id] == 'c_paiement') {
2514 $key = $langs->trans("PaymentType".strtoupper($obj->code));
2515 $valuetoshow = $obj->$value;
2516 if ($obj->code && array_key_exists("PaymentType".strtoupper($obj->code), $langs->tab_translate)) {
2517 $htmltext = $form->textwithpicto($langs->trans("TranslationFound").': '.$key, $langs->trans("TheTranslationIsSearchedFromKey", "PaymentType".strtoupper($obj->code)));
2518 } else {
2519 $htmltext = $form->textwithpicto($langs->trans("TranslationFound").': '.$langs->trans("No"), $langs->trans("TheTranslationIsSearchedFromKey", "PaymentType".strtoupper($obj->code)));
2520 }
2521 //$valuetoshow = $form->textwithpicto($valuetoshow, $htmltext);
2522 $valuetoshow .= '<br><span class="opacitymedium small">'.$htmltext.'</span>';
2523 } elseif ($value == 'type' && $tabname[$id] == 'c_paiement') {
2524 $payment_type_list = array(0 => $langs->trans('PaymentTypeCustomer'), 1 => $langs->trans('PaymentTypeSupplier'), 2 => $langs->trans('PaymentTypeBoth'));
2525 $valuetoshow = $payment_type_list[$valuetoshow];
2526 } elseif ($value == 'label' && $tabname[$id] == 'c_input_reason') {
2527 $key = $langs->trans("DemandReasonType".strtoupper($obj->code));
2528 $valuetoshow = ($obj->code && $key != "DemandReasonType".strtoupper($obj->code) ? $key : $obj->$value);
2529 } elseif ($value == 'libelle' && $tabname[$id] == 'c_input_method') {
2530 $langs->load("orders");
2531 $key = $langs->trans($obj->code);
2532 $valuetoshow = ($obj->code && $key != $obj->code) ? $key : $obj->$value;
2533 } elseif ($value == 'libelle' && $tabname[$id] == 'c_shipment_mode') {
2534 $langs->load("sendings");
2535 $key = $langs->trans("SendingMethod".strtoupper($obj->code));
2536 $valuetoshow = ($obj->code && $key != "SendingMethod".strtoupper($obj->code) ? $key : $obj->$value);
2537 } elseif ($value == 'libelle' && $tabname[$id] == 'c_paper_format') {
2538 $key = $langs->trans('PaperFormat'.strtoupper($obj->code));
2539 $valuetoshow = ($obj->code && $key != 'PaperFormat'.strtoupper($obj->code) ? $key : $obj->$value);
2540 } elseif ($value == 'label' && $tabname[$id] == 'c_type_fees') {
2541 $langs->load('trips');
2542 $key = $langs->trans(strtoupper($obj->code));
2543 $valuetoshow = ($obj->code && $key != strtoupper($obj->code) ? $key : $obj->$value);
2544 } elseif ($value == 'region_id' || $value == 'country_id' || $value == 'department_buyer_id') {
2545 $showfield = 0;
2546 } elseif ($value == 'unicode') {
2547 $valuetoshow = $langs->getCurrencySymbol($obj->code, 1);
2548 } elseif ($value == 'label' && $tabname[GETPOSTINT("id")] == 'c_units') {
2549 $langs->load("products");
2550 $valuetoshow = $langs->trans($obj->$value);
2551 } elseif ($value == 'short_label' && $tabname[GETPOSTINT("id")] == 'c_units') {
2552 $langs->load("products");
2553 $valuetoshow = $langs->trans($obj->$value);
2554 } elseif (($value == 'unit') && ($tabname[$id] == 'c_paper_format')) {
2555 $key = $langs->trans('SizeUnit'.strtolower($obj->unit));
2556 $valuetoshow = ($obj->code && $key != 'SizeUnit'.strtolower($obj->unit) ? $key : $obj->$value);
2557 } elseif ($value == 'localtax1' || $value == 'localtax2') {
2558 $class = "center";
2559 } elseif ($value == 'type_vat') {
2560 $valuetoshow = $type_vatList[(int) $valuetoshow];
2561 $class = "center";
2562 } elseif ($value == 'localtax1_type') {
2563 if ($obj->localtax1 != 0) {
2564 $valuetoshow = $localtax_typeList[$valuetoshow];
2565 } else {
2566 $valuetoshow = '';
2567 }
2568 $class = "center";
2569 } elseif ($value == 'localtax2_type') {
2570 if ($obj->localtax2 != 0) {
2571 $valuetoshow = $localtax_typeList[$valuetoshow];
2572 } else {
2573 $valuetoshow = '';
2574 }
2575 $class = "center";
2576 } elseif ($value == 'taux') {
2577 $valuetoshow = price($valuetoshow, 0, $langs, 0, 0);
2578 $class = "center";
2579 } elseif (in_array($value, array('recuperableonly'))) {
2580 $class = "center";
2581 } elseif ($value == 'accountancy_code' || $value == 'accountancy_code_sell' || $value == 'accountancy_code_buy') {
2582 if (isModEnabled('accounting')) {
2583 require_once DOL_DOCUMENT_ROOT.'/accountancy/class/accountingaccount.class.php';
2584 $tmpaccountingaccount = new AccountingAccount($db);
2585 $tmpaccountingaccount->fetch(0, $valuetoshow, 1);
2586 $titletoshow = $langs->transnoentitiesnoconv("Pcgtype").': '.$tmpaccountingaccount->pcg_type;
2587 }
2588 $valuetoshow = length_accountg($valuetoshow);
2589 } elseif ($value == 'fk_tva') {
2590 if (empty($form->cache_vatrates)) {
2591 $form->load_tva('cache_fk_tva', '', $mysoc, new Societe($db), 0, 0, '', false, -1);
2592 }
2593 foreach ($form->cache_vatrates as $key => $Tab) {
2594 if ($form->cache_vatrates[$key]['rowid'] == $valuetoshow) {
2595 $valuetoshow = $form->cache_vatrates[$key]['label'];
2596 break;
2597 }
2598 }
2599 } elseif ($value == 'fk_c_exp_tax_cat') {
2600 $tmpid = $valuetoshow;
2601 $valuetoshow = getDictionaryValue('c_exp_tax_cat', 'label', $tmpid);
2602 $valuetoshow = $langs->trans($valuetoshow ? $valuetoshow : $tmpid);
2603 } elseif ($tabname[$id] == 'c_exp_tax_cat') {
2604 $valuetoshow = $langs->trans($valuetoshow);
2605 } elseif ($value == 'libelle' && ($tabname[$id] == 'c_stcomm' || $tabname[$id] == 'c_stcommcontact')) {
2606 $key = 'StatusProspect'.$obj->rowid;
2607 $trans = $langs->trans($key);
2608 $valuetoshow = ($trans != $key ? $trans : $obj->{$value});
2609 } elseif ($value == 'label' && $tabname[$id] == 'c_units') {
2610 $langs->load('other');
2611 $key = $langs->trans($obj->label);
2612 $valuetoshow = ($obj->label && $key != strtoupper($obj->label) ? $key : $obj->{$value});
2613 } elseif ($value == 'label' && $tabname[$id] == 'c_product_nature') {
2614 $langs->load("products");
2615 $valuetoshow = $langs->trans($obj->{$value});
2616 } elseif ($fieldlist[$field] == 'label' && $tabname[$id] == 'c_productbatch_qcstatus') {
2617 $langs->load("productbatch");
2618 $valuetoshow = $langs->trans($obj->{$value});
2619 } elseif ($value == 'block_if_negative') {
2620 $valuetoshow = yn($obj->{$value});
2621 } elseif ($value == 'icon') {
2622 $valuetoshow = $obj->{$value}." ".img_picto("", preg_replace('/^fa-/', '', $obj->{$value}));
2623 } elseif ($value == 'type_duration') {
2624 $TDurationTypes = array('y' => $langs->trans('Years'), 'm' => $langs->trans('Month'), 'w' => $langs->trans('Weeks'), 'd' => $langs->trans('Days'), 'h' => $langs->trans('Hours'), 'i' => $langs->trans('Minutes'));
2625 if (!empty($obj->{$value}) && array_key_exists($obj->{$value}, $TDurationTypes)) {
2626 $valuetoshow = $TDurationTypes[$obj->{$value}];
2627 }
2628 }
2629
2630 $class .= ($class ? ' ' : '').'tddict';
2631 if ($value == 'name') {
2632 $class .= ' tdoverflowmax200';
2633 }
2634 if ($value == 'note' && $id == DICT_TVA) {
2635 $class .= ' tdoverflowmax200';
2636 }
2637 if ($value == 'tracking') {
2638 $class .= ' tdoverflowauto';
2639 }
2640 if (in_array($value, array('nbjour', 'decalage', 'pos', 'position', 'deposit_percent'))) {
2641 $class .= ' right';
2642 }
2643 if (in_array($value, array('icon', 'type_vat', 'localtax1_type', 'localtax2_type'))) {
2644 $class .= ' nowraponall';
2645 }
2646 if (in_array($value, array('use_default', 'fk_parent', 'sortorder'))) {
2647 $class .= ' center';
2648 }
2649 if ($value == 'public') {
2650 $class .= ' center';
2651 }
2652 if (in_array($value, array('localtax1_type', 'localtax2_type', 'note', 'note_public', 'note_private'))) {
2653 $class .= ' small';
2654 }
2655 // Show value for field
2656 if ($showfield) {
2657 print '<!-- field value '. $value .' --><td class="'.$class.'"'.($titletoshow ? ' title="'.dolPrintHTMLForAttribute($titletoshow).'"' : '').'>'.$valuetoshow.'</td>';
2658 }
2659 }
2660
2661 // Favorite, EEC & Sepa
2662 // Only for country dictionary
2663 if ($id == DICT_COUNTRY) {
2664 print '<td class="nowraponall center">';
2665 // Is in EEC
2666 if ($iserasable) {
2667 print '<a class="reposition" href="'.$url.'action='.$acts[$obj->eec].'_eec&token='.newToken().'">'.$actl[$obj->eec].'</a>';
2668 } else {
2669 print '<span class="opacitymedium">'.$langs->trans("AlwaysActive").'</span>';
2670 }
2671 print '</td>';
2672 print '<td class="nowraponall center">';
2673 // Is in Sepa
2674 if ($iserasable) {
2675 print '<a class="reposition" href="'.$url.'action='.$acts[$obj->sepa].'_sepa&token='.newToken().'">'.$actl[$obj->sepa].'</a>';
2676 } else {
2677 print '<span class="opacitymedium">'.$langs->trans("AlwaysActive").'</span>';
2678 }
2679 print '</td>';
2680 print '<td class="nowraponall center">';
2681 // Favorite
2682 if ($iserasable) {
2683 print '<a class="reposition" href="'.$url.'action='.$acts[$obj->favorite].'_favorite&token='.newToken().'">'.$actl[$obj->favorite].'</a>';
2684 } else {
2685 print '<span class="opacitymedium">'.$langs->trans("AlwaysActive").'</span>';
2686 }
2687 print '</td>';
2688 }
2689 }
2690
2691 // Active
2692 print '<td class="nowraponall center">';
2693 if ($canbedisabled) {
2694 print '<a class="reposition" href="'.$url.'action='.$acts[$obj->active].'&token='.newToken().'">'.$actl[$obj->active].'</a>';
2695 } else {
2696 if (in_array($obj->code, array('AC_OTH', 'AC_OTH_AUTO'))) {
2697 print $langs->trans("AlwaysActive");
2698 } elseif (isset($obj->type) && in_array($obj->type, array('systemauto')) && empty($obj->active)) {
2699 print $langs->trans("Deprecated");
2700 } elseif (isset($obj->type) && in_array($obj->type, array('system')) && !empty($obj->active) && $obj->code != 'AC_OTH') {
2701 print $langs->trans("UsedOnlyWithTypeOption");
2702 } else {
2703 print '<span class="opacitymedium">'.$langs->trans("AlwaysActive").'</span>';
2704 }
2705 }
2706 print "</td>";
2707
2708 // Action button
2709 if (!getDolGlobalString('MAIN_CHECKBOX_LEFT_COLUMN')) {
2710 print '<td class="center maxwidthsearch nowraponall">';
2711 // Modify link
2712 if ($canbemodified) {
2713 print '<a class="reposition marginleftonly paddingleft marginrightonly paddingright editfielda" href="'.$url.'action=edit&token='.newToken().'">'.img_edit().'</a>';
2714 }
2715 // Delete link
2716 if ($iserasable) {
2717 if ($user->admin) {
2718 print '<a class="reposition marginleftonly paddingleft marginrightonly paddingright" href="'.$url.'action=delete&token='.newToken().'">'.img_delete().'</a>';
2719 }
2720 }
2721 print '</td>';
2722 }
2723
2724 print "</tr>\n";
2725 }
2726 $i++;
2727 }
2728 } else {
2729 print '<tr><td colspan="'.$colspan.'"><span class="opacitymedium">'.$langs->trans("NoRecordFound").'</span></td></tr>';
2730 }
2731
2732 print '</table>';
2733 print '</div>';
2734 } else {
2735 dol_print_error($db);
2736 }
2737
2738 print '</form>';
2739} else {
2740 /*
2741 * Show list of dictionary to show
2742 */
2743 print load_fiche_titre($title, $linkback, $titlepicto);
2744
2745 print '<span class="opacitymedium">'.$langs->trans("DictionaryDesc");
2746 print " ".$langs->trans("OnlyActiveElementsAreShown")."<br>\n";
2747 print '</span><br>';
2748 print "<br>\n";
2749
2750 $lastlineisempty = false;
2751
2752 print '<div class="div-table-responsive-no-min">';
2753 print '<table class="noborder centpercent">';
2754 print '<tr class="liste_titre">';
2755 print '<td>'.$langs->trans("Dictionary").'</td>';
2756 print '<td></td>';
2757 print '<td class="hideonsmartphone"></td>';
2758 print '</tr>';
2759
2760 $showemptyline = '';
2761 foreach ($taborder as $i) {
2762 if (isset($tabname[$i]) && empty($tabcond[$i])) {
2763 continue;
2764 }
2765
2766 if ($i) {
2767 if ($showemptyline) {
2768 print '<tr class="oddeven"><td></td><td></td><td class="hideonsmartphone"></td></tr>';
2769 $showemptyline = 0;
2770 }
2771
2772
2773 $value = $tabname[$i];
2774 print '<tr class="oddeven"><td class="minwidth200">';
2775 if (!empty($tabcond[$i])) {
2776 $tabnamenoprefix = preg_replace('/'.MAIN_DB_PREFIX.'/', '', $tabname[$i]);
2777 print '<a href="'.$_SERVER["PHP_SELF"].'?id='.$i;
2778 if ($i == DICT_CHARGESOCIALES) {
2779 print '&search_country_id='.$mysoc->country_id;
2780 }
2781 print '">';
2782 if (!empty($tabcomplete[$tabnamenoprefix]['picto'])) {
2783 print img_picto('', $tabcomplete[$tabnamenoprefix]['picto'], 'class="pictofixedwidth paddingrightonly"');
2784 }
2785 print $langs->trans($tablib[$i]);
2786 print '</a>';
2787 } else {
2788 print $langs->trans($tablib[$i]);
2789 }
2790 print '</td>';
2791 print '<td>';
2792 print '<a class="editfielda" href="'.$_SERVER["PHP_SELF"].'?id='.$i.'">';
2793 print img_picto('Edit', 'edit', '');
2794 print '</a>';
2795 print '</td>';
2796 print '<td class="right hideonsmartphone">';
2797 print $form->textwithpicto('', $langs->trans("Table").': '.MAIN_DB_PREFIX.$tabname[$i]);
2798 print '</td>';
2799 print '</tr>';
2800 $lastlineisempty = false;
2801 } else {
2802 if (!$lastlineisempty) {
2803 $showemptyline = 1;
2804 $lastlineisempty = true;
2805 }
2806 }
2807 }
2808 print '</table>';
2809 print '</div>';
2810}
2811
2812print '<br>';
2813if (GETPOST('id') && GETPOST('id') == DICT_SOCIALNETWORKS) {
2814 print dol_get_fiche_end();
2815}
2816// End of page
2817llxFooter();
2818$db->close();
2819
2820
2830function dictFieldList($fieldlist, $obj = null, $tabname = '', $context = '')
2831{
2832 global $langs, $db, $mysoc;
2833 global $form;
2834 global $region_id;
2835 global $elementList, $sourceList, $localtax_typeList, $type_vatList;
2836
2837 $formadmin = new FormAdmin($db);
2838 $formcompany = new FormCompany($db);
2839 $formaccounting = new FormAccounting($db);
2840
2841 $withentity = '';
2842
2843 foreach ($fieldlist as $field => $value) {
2844 if ($value == 'entity' && isset($obj->$value)) {
2845 $withentity = $obj->$value;
2846 continue;
2847 }
2848
2849 if (in_array($value, array('code', 'libelle', 'type')) && $tabname == "c_actioncomm" && isset($obj->$value) && in_array($obj->type, array('system', 'systemauto'))) {
2850 // Special case for c_actioncomm (field that should not be modified)
2851 $hidden = (!empty($obj->{$value}) ? $obj->{$value} : '');
2852 print '<td>';
2853 print '<input type="hidden" name="'. $value .'" value="'.$hidden.'">';
2854 print $langs->trans($hidden);
2855 print '</td>';
2856 } elseif ($value == 'country') {
2857 if (in_array('region_id', $fieldlist)) {
2858 print '<td>';
2859 print '</td>';
2860 continue;
2861 } // For state page, we do not show the country input (we link to region, not country)
2862 print '<td>';
2863
2864 $selected = (!empty($obj->country_code) ? $obj->country_code : (!empty($obj->country) ? $obj->country : ''));
2865 if (!GETPOSTISSET('code')) {
2866 $selected = GETPOST('countryidforinsert');
2867 }
2868 print $form->select_country($selected, $value, '', 28, 'minwidth100 maxwidth150 maxwidthonsmartphone');
2869 print '</td>';
2870 } elseif ($value == 'country_id') {
2871 if (!in_array('country', $fieldlist)) { // If there is already a field country, we don't show country_id (avoid duplicate)
2872 $country_id = (!empty($obj->{$value}) ? $obj->{$value} : 0);
2873 print '<td class="tdoverflowmax100">';
2874 print '<input type="hidden" name="'. $value .'" value="'.$country_id.'">';
2875 print '</td>';
2876 }
2877 } elseif ($value == 'region') {
2878 print '<td>';
2879 $formcompany->select_region($region_id, 'region');
2880 print '</td>';
2881 } elseif ($value == 'region_id') {
2882 $region_id = (!empty($obj->{$value}) ? $obj->{$value} : 0);
2883 print '<td>';
2884 print '<input type="hidden" name="'. $value .'" value="'.$region_id.'">';
2885 print '</td>';
2886 } elseif ($value == 'department_buyer') {
2887 if ($context == 'edit') {
2888 print '<td class="nowraponall">';
2889 // show department buyer list
2890 $country_code = (!empty($obj->country_code) ? $obj->country_code : '');
2891 $department_buyer_id = (!empty($obj->department_buyer_id) ? (int) $obj->department_buyer_id : 0);
2892 if ($country_code != '') {
2893 print $formcompany->select_state($department_buyer_id, $country_code, 'department_buyer_id', 'minwidth100 maxwidth150 maxwidthonsmartphone');
2894 }
2895 print '</td>';
2896 }
2897 } elseif ($value == 'department_buyer_id') {
2898 if (!in_array('department_buyer', $fieldlist)) { // If there is already a field department buyer, we don't show department buyer id (avoid duplicate)
2899 $department_buyer_id = (!empty($obj->{$value}) ? $obj->{$value} : 0);
2900 print '<td class="tdoverflowmax100">';
2901 print '<input type="hidden" name="'.$value.'" value="'.$department_buyer_id.'">';
2902 print '</td>';
2903 }
2904 } elseif ($value == 'lang') {
2905 print '<td>';
2906 print $formadmin->select_language(getDolGlobalString('MAIN_LANG_DEFAULT'), 'lang');
2907 print '</td>';
2908 } elseif (in_array($value, array('element', 'source'))) { // Example: the type and source of the element (for contact types)
2909 $tmparray = array();
2910 if ($value == 'element') {
2911 $tmparray = $elementList;
2912 } else {
2913 $tmparray = $sourceList;
2914 }
2915 print '<td>';
2916 print $form->selectarray($value, $tmparray, (!empty($obj->{$value}) ? $obj->{$value} : ''), 0, 0, 0, '', 0, 0, 0, '', 'maxwidth250');
2917 print '</td>';
2918 } elseif (in_array($value, array('public', 'use_default'))) {
2919 // Fields 0/1 with a combo select Yes/No
2920 print '<td class="center">';
2921 // @phan-suppress-next-line PhanPluginSuspiciousParamPosition
2922 print $form->selectyesno($value, (!empty($obj->{$value}) ? $obj->{$value} : ''), 1);
2923 print '</td>';
2924 } elseif ($value == 'private') {
2925 // Fields 'no'/'yes' with a combo select Yes/No
2926 print '<td>';
2927 print $form->selectyesno("private", (!empty($obj->{$value}) ? $obj->{$value} : ''));
2928 print '</td>';
2929 } elseif ($value == 'type' && $tabname == "c_actioncomm") {
2930 $type = (!empty($obj->type) ? $obj->type : 'user'); // Check if type is different of 'user' (external module)
2931 print '<td>';
2932 print $type.'<input type="hidden" name="type" value="'.$type.'">';
2933 print '</td>';
2934 } elseif ($value == 'type' && $tabname == 'c_paiement') {
2935 print '<td>';
2936 $select_list = array(0 => $langs->trans('PaymentTypeCustomer'), 1 => $langs->trans('PaymentTypeSupplier'), 2 => $langs->trans('PaymentTypeBoth'));
2937 // Use isset(), not !empty(), because 0 (Customer) is a valid value that empty() would treat as unset
2938 print $form->selectarray($value, $select_list, (isset($obj->{$value}) && $obj->{$value} !== '' ? $obj->{$value} : '2'));
2939 print '</td>';
2940 } elseif ($value == 'recuperableonly' || $value == 'type_cdr' || $value == 'deductible' || $value == 'category_type') {
2941 if ($value == 'type_cdr') {
2942 print '<td class="center">';
2943 } else {
2944 print '<td>';
2945 }
2946 if ($value == 'type_cdr') {
2947 print $form->selectarray($value, array(0 => $langs->trans('None'), 1 => $langs->trans('AtEndOfMonth'), 2 => $langs->trans('CurrentNext')), (!empty($obj->{$value}) ? $obj->{$value} : ''));
2948 } else {
2949 // @phan-suppress-next-line PhanPluginSuspiciousParamPosition
2950 print $form->selectyesno($value, (!empty($obj->{$value}) ? $obj->{$value} : ''), 1);
2951 }
2952 print '</td>';
2953 } elseif (in_array($value, array('nbjour', 'decalage', 'taux', 'localtax1', 'localtax2'))) {
2954 $class = "right";
2955 if (in_array($value, array('taux', 'localtax1', 'localtax2'))) {
2956 $class = "center"; // Fields aligned on right
2957 }
2958 print '<td class="'.$class.'">';
2959 print '<input type="text" class="flat" value="'.(isset($obj->{$value}) ? $obj->{$value} : '').'" size="3" name="'. $value .'">';
2960 print '</td>';
2961 } elseif (in_array($value, array('libelle_facture'))) {
2962 print '<td>';
2963 $transfound = 0;
2964 $transkey = '';
2965 // Special case for labels
2966 if ($tabname == 'c_payment_term') {
2967 $langs->load("bills");
2968 if (isset($obj->code) && !empty($obj->code)) {
2969 $transkey = "PaymentCondition" . strtoupper($obj->code);
2970 if ($langs->trans($transkey) != $transkey) {
2971 $transfound = 1;
2972 print $form->textwithpicto($langs->trans($transkey), $langs->trans("GoIntoTranslationMenuToChangeThis"));
2973 }
2974 }
2975 }
2976 if (!$transfound) {
2977 print '<textarea cols="30" rows="'.ROWS_2.'" class="flat" name="'. $value .'">'.(empty($obj->{$value}) ? '' : $obj->{$value}).'</textarea>';
2978 } else {
2979 print '<input type="hidden" name="'. $value .'" value="'.$transkey.'">';
2980 }
2981 print '</td>';
2982 } elseif ($value == 'price' || preg_match('/^amount/i', (string) $value)) {
2983 print '<td><input type="text" class="flat minwidth75" value="'.price((!empty($obj->{$value}) ? $obj->{$value} : '')).'" name="'. $value .'"></td>';
2984 } elseif ($value == 'code' && isset($obj->{$value})) {
2985 print '<td>';
2986 if ($tabname == 'c_paiement' && in_array($obj->{$value}, array('LIQ', 'CB', 'CHQ', 'VIR'))) {
2987 // Case of code that should not be modified
2988 print '<input type="hidden" class="flat minwidth75 maxwidth100" value="'.(empty($obj->{$value}) ? '' : $obj->{$value}).'" name="'. $value .'">';
2989 print $obj->{$value};
2990 } else {
2991 print '<input type="text" class="flat minwidth75 maxwidth100" value="'.(empty($obj->{$value}) ? '' : $obj->{$value}).'" name="'. $value .'">';
2992 }
2993 print '</td>';
2994 } elseif ($value == 'unit') {
2995 print '<td>';
2996 $units = array(
2997 'mm' => $langs->trans('SizeUnitmm'),
2998 'cm' => $langs->trans('SizeUnitcm'),
2999 'point' => $langs->trans('SizeUnitpoint'),
3000 'inch' => $langs->trans('SizeUnitinch')
3001 );
3002 print $form->selectarray('unit', $units, (empty($obj->{$value}) ? '' : $obj->{$value}), 0, 0, 0);
3003 print '</td>';
3004 } elseif ($value == 'type_vat') {
3005 // VAT type 0: all, 1: sell, 2: purchase
3006 print '<td class="center">';
3007 print $form->selectarray($value, $type_vatList, (empty($obj->{$value}) ? '0' : $obj->{$value}));
3008 print '</td>';
3009 } elseif ($value == 'localtax1_type' || $value == 'localtax2_type') {
3010 // Le type de taxe locale
3011 print '<td class="center">';
3012 print $form->selectarray($value, $localtax_typeList, (empty($obj->{$value}) ? '' : $obj->{$value}));
3013 print '</td>';
3014 } elseif ($value == 'accountancy_code' || $value == 'accountancy_code_sell' || $value == 'accountancy_code_buy') {
3015 print '<td>';
3016 if (isModEnabled('accounting')) {
3017 $fieldname = $value;
3018 $accountancy_account = (empty($obj->$fieldname) ? 0 : $obj->$fieldname);
3019 print $formaccounting->select_account($accountancy_account, '.'. $value, 1, array(), 1, 1, 'maxwidth125 maxwidthonsmartphone');
3020 } else {
3021 $fieldname = $value;
3022 print '<input type="text" class="flat minwidth100" value="'.(isset($obj->$fieldname) ? $obj->$fieldname : '').'" name="'. $value .'">';
3023 }
3024 print '</td>';
3025 } elseif ($value == 'fk_tva') {
3026 print '<td>';
3027 print $form->load_tva('fk_tva', $obj->taux, $mysoc, new Societe($db), 0, 0, '', false, -1);
3028 print '</td>';
3029 } elseif ($value == 'fk_c_exp_tax_cat') {
3030 print '<td>';
3031 print $form->selectExpenseCategories($obj->fk_c_exp_tax_cat);
3032 print '</td>';
3033 } elseif ($value == 'fk_range') {
3034 print '<td>';
3035 print $form->selectExpenseRanges($obj->fk_range);
3036 print '</td>';
3037 } elseif ($value == 'block_if_negative') {
3038 print '<td>';
3039 print $form->selectyesno("block_if_negative", (empty($obj->block_if_negative) ? '' : $obj->block_if_negative), 1);
3040 print '</td>';
3041 } elseif ($value == 'type_duration') {
3042 print '<td>';
3043 print $form->selectTypeDuration('', (empty($obj->type_duration) ? '' : $obj->type_duration), array('i','h'));
3044 print '</td>';
3045 } else {
3046 $fieldValue = isset($obj->{$value}) ? $obj->{$value} : '';
3047 $classtd = '';
3048 $class = '';
3049
3050 if ($value == 'sortorder') {
3051 $fieldlist[$field] = 'position';
3052 }
3053
3054 if ($fieldlist[$field] == 'code') {
3055 $class = 'maxwidth100';
3056 }
3057 if (in_array($fieldlist[$field], array('deposit_percent'))) {
3058 $classtd = 'right';
3059 $class = 'maxwidth50 right';
3060 }
3061 if (in_array($fieldlist[$field], array('pos', 'position'))) {
3062 $classtd = 'right';
3063 $class = 'maxwidth50 right';
3064 }
3065 if (in_array($fieldlist[$field], array('dayrule', 'day', 'month', 'year', 'use_default', 'affect', 'delay', 'public', 'sortorder', 'sens', 'category_type', 'fk_parent'))) {
3066 $class = 'maxwidth50 center';
3067 }
3068 if (in_array($fieldlist[$field], array('use_default', 'public', 'fk_parent'))) {
3069 $classtd = 'center';
3070 }
3071 if (in_array($fieldlist[$field], array('libelle', 'label', 'tracking'))) {
3072 $class = 'quatrevingtpercent';
3073 }
3074 // Fields that must be suggested as '0' instead of ''
3075 if ($fieldlist[$field] == 'fk_parent') {
3076 if (empty($fieldValue)) {
3077 $fieldValue = '0';
3078 }
3079 }
3080
3081 // Labels Length
3082 $maxlength = '';
3083 if (in_array($fieldlist[$field], array('libelle', 'label'))) {
3084 switch ($tabname) {
3085 case 'c_ecotaxe':
3086 case 'c_email_senderprofile':
3087 case 'c_forme_juridique':
3088 case 'c_holiday_types':
3089 case 'c_payment_term':
3090 case 'c_transport_mode':
3091 $maxlength = ' maxlength="255"';
3092 break;
3093 case 'c_email_templates':
3094 $maxlength = ' maxlength="180"';
3095 break;
3096 case 'c_socialnetworks':
3097 $maxlength = ' maxlength="150"';
3098 break;
3099 default:
3100 $maxlength = ' maxlength="128"';
3101 }
3102 }
3103
3104 print '<td class="'.$classtd.'">';
3105 $transfound = 0;
3106 $transkey = '';
3107 if (in_array($fieldlist[$field], array('label', 'libelle'))) { // For label
3108 // Special case for labels
3109 if ($tabname == 'c_civility' && !empty($obj->code)) {
3110 $transkey = "Civility".strtoupper($obj->code);
3111 }
3112 if ($tabname == 'c_payment_term' && !empty($obj->code)) {
3113 $langs->load("bills");
3114 $transkey = "PaymentConditionShort".strtoupper($obj->code);
3115 }
3116 if ($transkey && $langs->trans($transkey) != $transkey) {
3117 $transfound = 1;
3118 print $form->textwithpicto($langs->trans($transkey), $langs->trans("GoIntoTranslationMenuToChangeThis"));
3119 }
3120 }
3121 if (!$transfound) {
3122 print '<input type="text" class="flat'.($class ? ' '.$class : '').'"'.($maxlength ? ' '.$maxlength : '').' value="'.dol_escape_htmltag($fieldValue).'" name="'.$fieldlist[$field].'">';
3123 } else {
3124 print '<input type="hidden" name="'.$fieldlist[$field].'" value="'.$transkey.'">';
3125 }
3126 print '</td>';
3127 }
3128 }
3129
3130 return $withentity;
3131}
$id
Support class for third parties, contacts, members, users or resources.
Definition account.php:48
if( $user->socid > 0) if(! $user->hasRight('accounting', 'chartofaccount')) $object
Definition card.php:67
length_accountg($account)
Return General accounting account with defined length (used for product and miscellaneous)
complete_dictionary_with_modules(&$taborder, &$tabname, &$tablib, &$tabsql, &$tabsqlsort, &$tabfield, &$tabfieldvalue, &$tabfieldinsert, &$tabrowid, &$tabcond, &$tabhelp, &$tabcomplete)
Add external modules to list of dictionaries.
complete_elementList_with_modules(&$elementList)
Search external modules to complete the list of contact element.
llxFooter($comment='', $zone='private', $disabledoutputofmessages=0)
Empty footer.
Definition wrapper.php:91
if(!defined('NOREQUIRESOC')) if(!defined( 'NOREQUIRETRAN')) if(!defined('NOTOKENRENEWAL')) if(!defined( 'NOREQUIREMENU')) if(!defined('NOREQUIREHTML')) if(!defined( 'NOREQUIREAJAX')) llxHeader($head='', $title='', $help_url='', $target='', $disablejs=0, $disablehead=0, $arrayofjs='', $arrayofcss='', $morequerystring='', $morecssonbody='', $replacemainareaby='', $disablenofollow=0, $disablenoindex=0)
Empty header.
Definition wrapper.php:73
Class to manage accounting accounts.
Class to manage generation of HTML components for accounting management.
Class to generate html code for admin pages.
Class to build HTML component for third parties management Only common components are here.
Class to manage generation of HTML components Only common components must be here.
Class to manage third parties objects (customers, suppliers, prospects...)
dictFieldList($fieldlist, $obj=null, $tabname='', $context='')
Show fields in insert/edit mode.
Definition dict.php:2830
load_fiche_titre($title, $morehtmlright='', $picto='generic', $pictoisfullpath=0, $id='', $morecssontable='', $morehtmlcenter='')
Load a title with picto.
setEventMessages($mesg, $mesgs, $style='mesgs', $messagekey='', $noduplicate=0, $attop=0)
Set event messages in dol_events session object.
print_barre_liste($title, $page, $file, $options='', $sortfield='', $sortorder='', $morehtmlcenter='', $num=-1, $totalnboflines='', $picto='generic', $pictoisfullpath=0, $morehtmlright='', $morecss='', $limit=-1, $selectlimitsuffix=0, $hidenavigation=0, $pagenavastextinput=0, $morehtmlrightbeforearrow='')
Print a title with navigation controls for pagination.
img_help($usehelpcursor=1, $usealttitle=1)
Show help logo with cursor "?".
img_picto($titlealt, $picto, $moreatt='', $pictoisfullpath=0, $srconly=0, $notitle=0, $alt='', $morecss='', $marginleftonlyshort=2, $allowothertags=array())
Show picto whatever it's its name (generic function)
img_delete($titlealt='default', $other='class="pictodelete"', $morecss='')
Show delete logo.
GETPOSTINT($paramname, $method=0)
Return the value of a $_GET or $_POST supervariable, converted into integer.
dol_get_fiche_head($links=array(), $active='', $title='', $notab=0, $picto='', $pictoisfullpath=0, $morehtmlright='', $morecss='', $limittoshow=0, $moretabssuffix='', $dragdropfile=0, $morecssdiv='')
Show tabs of a record.
price2num($amount, $rounding='', $option=0)
Function that return a number with universal decimal format (decimal separator is '.
dolGetButtonTitle($label, $helpText='', $iconClass='fa fa-file', $url='', $id='', $status=1, $params=array())
Function dolGetButtonTitle : this kind of buttons are used in title in list.
dol_get_fiche_end($notab=0)
Return tab footer of a card.
natural_search($fields, $value, $mode=0, $nofirstand=0)
Generate natural SQL search string for a criteria (this criteria can be tested on one or several fiel...
price($amount, $form=0, $outlangs='', $trunc=1, $rounding=-1, $forcerounding=-1, $currency_code='')
Function to format a value into an amount for visual output Function used into PDF and HTML pages.
getDolGlobalInt($key, $default=0)
Return a Dolibarr global constant int value.
newToken()
Return the value of token currently saved into session with name 'newtoken'.
yn($yesno, $format=1, $color=0)
Return yes or no in current language.
getTitleFieldOfList($name, $thead=0, $file="", $field="", $begin="", $moreparam="", $moreattrib="", $sortfield="", $sortorder="", $prefix="", $disablesortlink=0, $tooltip='', $forcenowrapcolumntitle=0)
Get title line of an array.
GETPOST($paramname, $check='alphanohtml', $method=0, $filter=null, $options=null, $noreplace=0)
Return value of a param into GET or POST supervariable.
dol_print_error($db=null, $error='', $errors=null)
Displays error message system with all the information to facilitate the diagnosis and the escalation...
getDolGlobalString($key, $default='')
Return a Dolibarr global constant string value.
info_admin($text, $infoonimgalt=0, $nodiv=0, $admin='1', $morecss='hideonsmartphone', $textfordropdown='', $picto='')
Show information in HTML for admin users or standard users.
img_edit($titlealt='default', $float=0, $other='')
Show logo edit/modify fiche.
getDictionaryValue($tablename, $field, $id, $checkentity=false, $rowidfield='rowid')
Return the value of a filed into a dictionary for the record $id.
dol_syslog($message, $level=LOG_INFO, $ident=0, $suffixinfilename='', $restricttologhandler='', $logcontext=null)
Write log message into outputs.
getEntity($element, $shared=1, $currentobject=null)
Get list of entity id to use.
dol_escape_htmltag($stringtoescape, $keepb=0, $keepn=0, $noescapetags='', $escapeonlyhtmltags=0, $cleanalsojavascript=0)
Returns text escaped for inclusion in HTML alt or title or value tags, or into values of HTML input f...
$context
@method int call_trigger(string $triggerName, User $user)
Definition logout.php:42
if(preg_match('/(crypted|dolcrypt):/i', $dolibarr_main_db_pass)||!empty($dolibarr_main_db_encrypted_pass)) $conf db type
Definition repair.php:158
accessforbidden($message='', $printheader=1, $printfooter=1, $showonlymessage=0, $params=null)
Show a message to say access is forbidden and stop program.