38 require
'../main.inc.php';
39 require_once DOL_DOCUMENT_ROOT.
'/core/class/html.formadmin.class.php';
40 require_once DOL_DOCUMENT_ROOT.
'/core/class/html.formcompany.class.php';
41 require_once DOL_DOCUMENT_ROOT.
'/core/lib/admin.lib.php';
42 require_once DOL_DOCUMENT_ROOT.
'/core/lib/functions2.lib.php';
43 require_once DOL_DOCUMENT_ROOT.
'/core/class/doleditor.class.php';
44 require_once DOL_DOCUMENT_ROOT.
'/core/lib/accounting.lib.php';
45 require_once DOL_DOCUMENT_ROOT.
'/core/class/html.formaccounting.class.php';
48 $langs->loadLangs(array(
"errors",
"admin",
"main",
"companies",
"resource",
"holiday",
"accountancy",
"hrm",
"orders",
"contracts",
"projects",
"propal",
"bills",
"interventions",
"ticket"));
50 $action =
GETPOST(
'action',
'alpha') ?
GETPOST(
'action',
'alpha') :
'view';
51 $confirm =
GETPOST(
'confirm',
'alpha');
53 $rowid =
GETPOST(
'rowid',
'alpha');
54 $entity =
GETPOST(
'entity',
'int');
55 $code =
GETPOST(
'code',
'alpha');
57 $allowed = $user->admin;
58 if ($id == 7 && $user->hasRight(
'accounting',
'chartofaccount')) {
61 if ($id == 10 && $user->hasRight(
'accounting',
'chartofaccount')) {
64 if ($id == 17 && $user->hasRight(
'accounting',
'chartofaccount')) {
71 $acts = array(); $actl = array();
72 $acts[0] =
"activate";
74 $actl[0] =
img_picto($langs->trans(
"Disabled"),
'switch_off',
'class="size15x"');
75 $actl[1] =
img_picto($langs->trans(
"Activated"),
'switch_on',
'class="size15x"');
77 $listoffset =
GETPOST(
'listoffset');
78 $listlimit =
GETPOST(
'listlimit') > 0 ?
GETPOST(
'listlimit') : 1000;
81 $sortfield =
GETPOST(
'sortfield',
'aZ09comma');
82 $sortorder =
GETPOST(
'sortorder',
'aZ09comma');
84 if (empty($page) || $page == -1) {
87 $offset = $listlimit * $page;
88 $pageprev = $page - 1;
89 $pagenext = $page + 1;
91 $search_country_id =
GETPOST(
'search_country_id',
'int');
92 if (!
GETPOSTISSET(
'search_country_id') && $search_country_id ==
'' && ($id == 2 || $id == 3 || $id == 10)) {
93 $search_country_id = $mysoc->country_id;
95 $search_code =
GETPOST(
'search_code',
'alpha');
98 $hookmanager->initHooks(array(
'admin',
'dictionaryadmin'));
104 $taborder = array(9, 15, 30, 0, 4, 3, 2, 0, 1, 8, 19, 16, 39, 27, 40, 38, 0, 5, 11, 0, 6, 24, 0, 29, 0, 33, 34, 32, 28, 17, 35, 36, 0, 10, 31, 23, 12, 13, 7, 0, 14, 0, 22, 20, 18, 21, 41, 0, 37, 42, 0, 43, 0, 25, 0, 44, 0);
108 $tabname[1] =
"c_forme_juridique";
109 $tabname[2] =
"c_departements";
110 $tabname[3] =
"c_regions";
111 $tabname[4] =
"c_country";
112 $tabname[5] =
"c_civility";
113 $tabname[6] =
"c_actioncomm";
114 $tabname[7] =
"c_chargesociales";
115 $tabname[8] =
"c_typent";
116 $tabname[9] =
"c_currencies";
117 $tabname[10] =
"c_tva";
118 $tabname[11] =
"c_type_contact";
119 $tabname[12] =
"c_payment_term";
120 $tabname[13] =
"c_paiement";
121 $tabname[14] =
"c_ecotaxe";
122 $tabname[15] =
"c_paper_format";
123 $tabname[16] =
"c_prospectlevel";
124 $tabname[17] =
"c_type_fees";
125 $tabname[18] =
"c_shipment_mode";
126 $tabname[19] =
"c_effectif";
127 $tabname[20] =
"c_input_method";
128 $tabname[21] =
"c_availability";
129 $tabname[22] =
"c_input_reason";
130 $tabname[23] =
"c_revenuestamp";
131 $tabname[24] =
"c_type_resource";
132 $tabname[25] =
"c_type_container";
134 $tabname[27] =
"c_stcomm";
135 $tabname[28] =
"c_holiday_types";
136 $tabname[29] =
"c_lead_status";
137 $tabname[30] =
"c_format_cards";
138 $tabname[31] =
"c_invoice_subtype";
139 $tabname[32] =
"c_hrm_public_holiday";
140 $tabname[33] =
"c_hrm_department";
141 $tabname[34] =
"c_hrm_function";
142 $tabname[35] =
"c_exp_tax_cat";
143 $tabname[36] =
"c_exp_tax_range";
144 $tabname[37] =
"c_units";
145 $tabname[38] =
"c_socialnetworks";
146 $tabname[39] =
"c_prospectcontactlevel";
147 $tabname[40] =
"c_stcommcontact";
148 $tabname[41] =
"c_transport_mode";
149 $tabname[42] =
"c_product_nature";
150 $tabname[43] =
"c_productbatch_qcstatus";
151 $tabname[44] =
"c_asset_disposal_type";
155 $tablib[1] =
"DictionaryCompanyJuridicalType";
156 $tablib[2] =
"DictionaryCanton";
157 $tablib[3] =
"DictionaryRegion";
158 $tablib[4] =
"DictionaryCountry";
159 $tablib[5] =
"DictionaryCivility";
160 $tablib[6] =
"DictionaryActions";
161 $tablib[7] =
"DictionarySocialContributions";
162 $tablib[8] =
"DictionaryCompanyType";
163 $tablib[9] =
"DictionaryCurrency";
164 $tablib[10] =
"DictionaryVAT";
165 $tablib[11] =
"DictionaryTypeContact";
166 $tablib[12] =
"DictionaryPaymentConditions";
167 $tablib[13] =
"DictionaryPaymentModes";
168 $tablib[14] =
"DictionaryEcotaxe";
169 $tablib[15] =
"DictionaryPaperFormat";
170 $tablib[16] =
"DictionaryProspectLevel";
171 $tablib[17] =
"DictionaryFees";
172 $tablib[18] =
"DictionarySendingMethods";
173 $tablib[19] =
"DictionaryStaff";
174 $tablib[20] =
"DictionaryOrderMethods";
175 $tablib[21] =
"DictionaryAvailability";
176 $tablib[22] =
"DictionarySource";
177 $tablib[23] =
"DictionaryRevenueStamp";
178 $tablib[24] =
"DictionaryResourceType";
179 $tablib[25] =
"DictionaryTypeOfContainer";
181 $tablib[27] =
"DictionaryProspectStatus";
182 $tablib[28] =
"DictionaryHolidayTypes";
183 $tablib[29] =
"DictionaryOpportunityStatus";
184 $tablib[30] =
"DictionaryFormatCards";
185 $tablib[31] =
"DictionaryInvoiceSubtype";
186 $tablib[32] =
"DictionaryPublicHolidays";
187 $tablib[33] =
"DictionaryDepartment";
188 $tablib[34] =
"DictionaryFunction";
189 $tablib[35] =
"DictionaryExpenseTaxCat";
190 $tablib[36] =
"DictionaryExpenseTaxRange";
191 $tablib[37] =
"DictionaryMeasuringUnits";
192 $tablib[38] =
"DictionarySocialNetworks";
193 $tablib[39] =
"DictionaryProspectContactLevel";
194 $tablib[40] =
"DictionaryProspectContactStatus";
195 $tablib[41] =
"DictionaryTransportMode";
196 $tablib[42] =
"DictionaryProductNature";
197 $tablib[43] =
"DictionaryBatchStatus";
198 $tablib[44] =
"DictionaryAssetDisposalType";
202 $tabsql[1] =
"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";
203 $tabsql[2] =
"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";
204 $tabsql[3] =
"SELECT r.rowid as rowid, r.code_region as state_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";
205 $tabsql[4] =
"SELECT c.rowid as rowid, c.code, c.label, c.active, c.favorite, c.eec FROM ".MAIN_DB_PREFIX.
"c_country AS c";
206 $tabsql[5] =
"SELECT c.rowid as rowid, c.code as code, c.label, c.active FROM ".MAIN_DB_PREFIX.
"c_civility AS c";
207 $tabsql[6] =
"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";
208 $tabsql[7] =
"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";
209 $tabsql[8] =
"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.active FROM ".MAIN_DB_PREFIX.
"c_typent as t LEFT JOIN ".MAIN_DB_PREFIX.
"c_country as c ON t.fk_country=c.rowid";
210 $tabsql[9] =
"SELECT c.code_iso as code, c.label, c.unicode, c.active FROM ".MAIN_DB_PREFIX.
"c_currencies AS c";
211 $tabsql[10] =
"SELECT t.rowid, t.code, 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.recuperableonly, t.note, t.active, t.accountancy_code_sell, t.accountancy_code_buy FROM ".MAIN_DB_PREFIX.
"c_tva as t, ".MAIN_DB_PREFIX.
"c_country as c WHERE t.fk_pays = c.rowid";
212 $tabsql[11] =
"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";
213 $tabsql[12] =
"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 = ".
getEntity($tabname[12]);
214 $tabsql[13] =
"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 = ".
getEntity($tabname[13]);
215 $tabsql[14] =
"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";
216 $tabsql[15] =
"SELECT rowid as rowid, code, label as libelle, width, height, unit, active FROM ".MAIN_DB_PREFIX.
"c_paper_format";
217 $tabsql[16] =
"SELECT code, label as libelle, sortorder, active FROM ".MAIN_DB_PREFIX.
"c_prospectlevel";
218 $tabsql[17] =
"SELECT id as rowid, code, label, accountancy_code, active FROM ".MAIN_DB_PREFIX.
"c_type_fees";
219 $tabsql[18] =
"SELECT rowid as rowid, code, libelle, tracking, active FROM ".MAIN_DB_PREFIX.
"c_shipment_mode";
220 $tabsql[19] =
"SELECT id as rowid, code, libelle, active FROM ".MAIN_DB_PREFIX.
"c_effectif";
221 $tabsql[20] =
"SELECT rowid as rowid, code, libelle, active FROM ".MAIN_DB_PREFIX.
"c_input_method";
222 $tabsql[21] =
"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";
223 $tabsql[22] =
"SELECT rowid as rowid, code, label, active FROM ".MAIN_DB_PREFIX.
"c_input_reason";
224 $tabsql[23] =
"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";
225 $tabsql[24] =
"SELECT rowid as rowid, code, label, active FROM ".MAIN_DB_PREFIX.
"c_type_resource";
226 $tabsql[25] =
"SELECT rowid as rowid, code, label, active, module FROM ".MAIN_DB_PREFIX.
"c_type_container as t WHERE t.entity = ".
getEntity($tabname[25]);
228 $tabsql[27] =
"SELECT id as rowid, code, libelle, picto, active FROM ".MAIN_DB_PREFIX.
"c_stcomm";
229 $tabsql[28] =
"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";
230 $tabsql[29] =
"SELECT rowid as rowid, code, label, percent, position, active FROM ".MAIN_DB_PREFIX.
"c_lead_status";
231 $tabsql[30] =
"SELECT rowid, code, name, paper_size, orientation, metric, leftmargin, topmargin, nx, ny, spacex, spacey, width, height, font_size, custom_x, custom_y, active FROM ".MAIN_DB_PREFIX.
"c_format_cards";
232 $tabsql[31] =
"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";
233 $tabsql[32] =
"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";
234 $tabsql[33] =
"SELECT rowid, pos, code, label, active FROM ".MAIN_DB_PREFIX.
"c_hrm_department";
235 $tabsql[34] =
"SELECT rowid, pos, code, label, c_level, active FROM ".MAIN_DB_PREFIX.
"c_hrm_function";
236 $tabsql[35] =
"SELECT c.rowid, c.label, c.active, c.entity FROM ".MAIN_DB_PREFIX.
"c_exp_tax_cat c";
237 $tabsql[36] =
"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";
238 $tabsql[37] =
"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";
239 $tabsql[38] =
"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 = ".
getEntity($tabname[38]);
240 $tabsql[39] =
"SELECT code, label as libelle, sortorder, active FROM ".MAIN_DB_PREFIX.
"c_prospectcontactlevel";
241 $tabsql[40] =
"SELECT id as rowid, code, libelle, picto, active FROM ".MAIN_DB_PREFIX.
"c_stcommcontact";
242 $tabsql[41] =
"SELECT rowid as rowid, code, label, active FROM ".MAIN_DB_PREFIX.
"c_transport_mode";
243 $tabsql[42] =
"SELECT rowid as rowid, code, label, active FROM ".MAIN_DB_PREFIX.
"c_product_nature";
244 $tabsql[43] =
"SELECT rowid, code, label, active FROM ".MAIN_DB_PREFIX.
"c_productbatch_qcstatus";
245 $tabsql[44] =
"SELECT rowid, code, label, active FROM ".MAIN_DB_PREFIX.
"c_asset_disposal_type";
248 $tabsqlsort = array();
249 $tabsqlsort[1] =
"country ASC, code ASC";
250 $tabsqlsort[2] =
"country ASC, code ASC";
251 $tabsqlsort[3] =
"country ASC, code ASC";
252 $tabsqlsort[4] =
"code ASC";
253 $tabsqlsort[5] =
"label ASC";
254 $tabsqlsort[6] =
"a.type ASC, a.module ASC, a.position ASC, a.code ASC";
255 $tabsqlsort[7] =
"c.label ASC, a.code ASC, a.libelle ASC";
256 $tabsqlsort[8] =
"country DESC,".(!empty($conf->global->SOCIETE_SORT_ON_TYPEENT) ?
' t.position ASC,' :
'').
" libelle ASC";
257 $tabsqlsort[9] =
"label ASC";
258 $tabsqlsort[10] =
"country ASC, code ASC, taux ASC, recuperableonly ASC, localtax1 ASC, localtax2 ASC";
259 $tabsqlsort[11] =
"t.element ASC, t.source ASC, t.position ASC, t.code ASC";
260 $tabsqlsort[12] =
"sortorder ASC, code ASC";
261 $tabsqlsort[13] =
"code ASC";
262 $tabsqlsort[14] =
"country ASC, e.organization ASC, code ASC";
263 $tabsqlsort[15] =
"rowid ASC";
264 $tabsqlsort[16] =
"sortorder ASC";
265 $tabsqlsort[17] =
"code ASC";
266 $tabsqlsort[18] =
"code ASC, libelle ASC";
267 $tabsqlsort[19] =
"id ASC";
268 $tabsqlsort[20] =
"code ASC, libelle ASC";
269 $tabsqlsort[21] =
"position ASC, type_duration ASC, qty ASC";
270 $tabsqlsort[22] =
"code ASC, label ASC";
271 $tabsqlsort[23] =
"country ASC, taux ASC";
272 $tabsqlsort[24] =
"code ASC, label ASC";
273 $tabsqlsort[25] =
"t.module ASC, t.code ASC, t.label ASC";
275 $tabsqlsort[27] =
"code ASC";
276 $tabsqlsort[28] =
"sortorder ASC, country ASC, code ASC";
277 $tabsqlsort[29] =
"position ASC";
278 $tabsqlsort[30] =
"code ASC";
279 $tabsqlsort[31] =
"country ASC, code ASC";
280 $tabsqlsort[32] =
"country, year ASC, month ASC, day ASC";
281 $tabsqlsort[33] =
"code ASC";
282 $tabsqlsort[34] =
"code ASC";
283 $tabsqlsort[35] =
"c.label ASC";
284 $tabsqlsort[36] =
"r.fk_c_exp_tax_cat ASC, r.range_ik ASC";
285 $tabsqlsort[37] =
"sortorder ASC";
286 $tabsqlsort[38] =
"rowid, code ASC";
287 $tabsqlsort[39] =
"sortorder ASC";
288 $tabsqlsort[40] =
"code ASC";
289 $tabsqlsort[41] =
"code ASC";
290 $tabsqlsort[42] =
"code ASC";
291 $tabsqlsort[43] =
"code ASC";
292 $tabsqlsort[44] =
"code ASC";
296 $tabfield[1] =
"code,libelle,country";
297 $tabfield[2] =
"code,libelle,region_id,region,country";
298 $tabfield[3] =
"code,libelle,country_id,country";
299 $tabfield[4] =
"code,label";
300 $tabfield[5] =
"code,label";
301 $tabfield[6] =
"code,libelle,type,color,position";
302 $tabfield[7] =
"code,libelle,country,accountancy_code";
303 $tabfield[8] =
"code,libelle,country_id,country".(!empty($conf->global->SOCIETE_SORT_ON_TYPEENT) ?
',position' :
'');
304 $tabfield[9] =
"code,label,unicode";
305 $tabfield[10] =
"country_id,country,code,taux,localtax1_type,localtax1,localtax2_type,localtax2,recuperableonly,accountancy_code_sell,accountancy_code_buy,note";
306 $tabfield[11] =
"element,source,code,libelle,position";
307 $tabfield[12] =
"code,libelle,libelle_facture,deposit_percent,nbjour,type_cdr,decalage,sortorder,entity";
308 $tabfield[13] =
"code,libelle,type,entity";
309 $tabfield[14] =
"code,label,price,organization,country";
310 $tabfield[15] =
"code,libelle,width,height,unit";
311 $tabfield[16] =
"code,libelle,sortorder";
312 $tabfield[17] =
"code,label,accountancy_code";
313 $tabfield[18] =
"code,libelle,tracking";
314 $tabfield[19] =
"code,libelle";
315 $tabfield[20] =
"code,libelle";
316 $tabfield[21] =
"code,label,qty,type_duration,position";
317 $tabfield[22] =
"code,label";
318 $tabfield[23] =
"country_id,country,taux,revenuestamp_type,accountancy_code_sell,accountancy_code_buy,note";
319 $tabfield[24] =
"code,label";
320 $tabfield[25] =
"code,label";
322 $tabfield[27] =
"code,libelle,picto";
323 $tabfield[28] =
"code,label,affect,delay,newbymonth,country_id,country,block_if_negative,sortorder";
324 $tabfield[29] =
"code,label,percent,position";
325 $tabfield[30] =
"code,name,paper_size,orientation,metric,leftmargin,topmargin,nx,ny,spacex,spacey,width,height,font_size,custom_x,custom_y";
326 $tabfield[31] =
"country_id,country,code,label";
327 $tabfield[32] =
"code,dayrule,year,month,day,country_id,country";
328 $tabfield[33] =
"code,label";
329 $tabfield[34] =
"code,label";
330 $tabfield[35] =
"label";
331 $tabfield[36] =
"range_ik,fk_c_exp_tax_cat";
332 $tabfield[37] =
"code,label,short_label,unit_type,scale,sortorder";
333 $tabfield[38] =
"code,label,url,icon,entity";
334 $tabfield[39] =
"code,libelle,sortorder";
335 $tabfield[40] =
"code,libelle,picto";
336 $tabfield[41] =
"code,label";
337 $tabfield[42] =
"code,label";
338 $tabfield[43] =
"code,label";
339 $tabfield[44] =
"code,label";
342 $tabfieldvalue = array();
343 $tabfieldvalue[1] =
"code,libelle,country";
344 $tabfieldvalue[2] =
"code,libelle,region";
345 $tabfieldvalue[3] =
"code,libelle,country";
346 $tabfieldvalue[4] =
"code,label";
347 $tabfieldvalue[5] =
"code,label";
348 $tabfieldvalue[6] =
"code,libelle,type,color,position";
349 $tabfieldvalue[7] =
"code,libelle,country,accountancy_code";
350 $tabfieldvalue[8] =
"code,libelle,country".(!empty($conf->global->SOCIETE_SORT_ON_TYPEENT) ?
',position' :
'');
351 $tabfieldvalue[9] =
"code,label,unicode";
352 $tabfieldvalue[10] =
"country,code,taux,localtax1_type,localtax1,localtax2_type,localtax2,recuperableonly,accountancy_code_sell,accountancy_code_buy,note";
353 $tabfieldvalue[11] =
"element,source,code,libelle,position";
354 $tabfieldvalue[12] =
"code,libelle,libelle_facture,deposit_percent,nbjour,type_cdr,decalage,sortorder";
355 $tabfieldvalue[13] =
"code,libelle,type";
356 $tabfieldvalue[14] =
"code,label,price,organization,country";
357 $tabfieldvalue[15] =
"code,libelle,width,height,unit";
358 $tabfieldvalue[16] =
"code,libelle,sortorder";
359 $tabfieldvalue[17] =
"code,label,accountancy_code";
360 $tabfieldvalue[18] =
"code,libelle,tracking";
361 $tabfieldvalue[19] =
"code,libelle";
362 $tabfieldvalue[20] =
"code,libelle";
363 $tabfieldvalue[21] =
"code,label,qty,type_duration,position";
364 $tabfieldvalue[22] =
"code,label";
365 $tabfieldvalue[23] =
"country,taux,revenuestamp_type,accountancy_code_sell,accountancy_code_buy,note";
366 $tabfieldvalue[24] =
"code,label";
367 $tabfieldvalue[25] =
"code,label";
369 $tabfieldvalue[27] =
"code,libelle,picto";
370 $tabfieldvalue[28] =
"code,label,affect,delay,newbymonth,country,block_if_negative,sortorder";
371 $tabfieldvalue[29] =
"code,label,percent,position";
372 $tabfieldvalue[30] =
"code,name,paper_size,orientation,metric,leftmargin,topmargin,nx,ny,spacex,spacey,width,height,font_size,custom_x,custom_y";
373 $tabfieldvalue[31] =
"country,code,label";
374 $tabfieldvalue[32] =
"code,dayrule,day,month,year,country";
375 $tabfieldvalue[33] =
"code,label";
376 $tabfieldvalue[34] =
"code,label";
377 $tabfieldvalue[35] =
"label";
378 $tabfieldvalue[36] =
"range_ik,fk_c_exp_tax_cat";
379 $tabfieldvalue[37] =
"code,label,short_label,unit_type,scale,sortorder";
380 $tabfieldvalue[38] =
"code,label,url,icon";
381 $tabfieldvalue[39] =
"code,libelle,sortorder";
382 $tabfieldvalue[40] =
"code,libelle,picto";
383 $tabfieldvalue[41] =
"code,label";
384 $tabfieldvalue[42] =
"code,label";
385 $tabfieldvalue[43] =
"code,label";
386 $tabfieldvalue[44] =
"code,label";
389 $tabfieldinsert = array();
390 $tabfieldinsert[1] =
"code,libelle,fk_pays";
391 $tabfieldinsert[2] =
"code_departement,nom,fk_region";
392 $tabfieldinsert[3] =
"code_region,nom,fk_pays";
393 $tabfieldinsert[4] =
"code,label";
394 $tabfieldinsert[5] =
"code,label";
395 $tabfieldinsert[6] =
"code,libelle,type,color,position";
396 $tabfieldinsert[7] =
"code,libelle,fk_pays,accountancy_code";
397 $tabfieldinsert[8] =
"code,libelle,fk_country".(!empty($conf->global->SOCIETE_SORT_ON_TYPEENT) ?
',position' :
'');
398 $tabfieldinsert[9] =
"code_iso,label,unicode";
399 $tabfieldinsert[10] =
"fk_pays,code,taux,localtax1_type,localtax1,localtax2_type,localtax2,recuperableonly,accountancy_code_sell,accountancy_code_buy,note";
400 $tabfieldinsert[11] =
"element,source,code,libelle,position";
401 $tabfieldinsert[12] =
"code,libelle,libelle_facture,deposit_percent,nbjour,type_cdr,decalage,sortorder,entity";
402 $tabfieldinsert[13] =
"code,libelle,type,entity";
403 $tabfieldinsert[14] =
"code,label,price,organization,fk_pays";
404 $tabfieldinsert[15] =
"code,label,width,height,unit";
405 $tabfieldinsert[16] =
"code,label,sortorder";
406 $tabfieldinsert[17] =
"code,label,accountancy_code";
407 $tabfieldinsert[18] =
"code,libelle,tracking";
408 $tabfieldinsert[19] =
"code,libelle";
409 $tabfieldinsert[20] =
"code,libelle";
410 $tabfieldinsert[21] =
"code,label,qty,type_duration,position";
411 $tabfieldinsert[22] =
"code,label";
412 $tabfieldinsert[23] =
"fk_pays,taux,revenuestamp_type,accountancy_code_sell,accountancy_code_buy,note";
413 $tabfieldinsert[24] =
"code,label";
414 $tabfieldinsert[25] =
"code,label";
416 $tabfieldinsert[27] =
"code,libelle,picto";
417 $tabfieldinsert[28] =
"code,label,affect,delay,newbymonth,fk_country,block_if_negative,sortorder";
418 $tabfieldinsert[29] =
"code,label,percent,position";
419 $tabfieldinsert[30] =
"code,name,paper_size,orientation,metric,leftmargin,topmargin,nx,ny,spacex,spacey,width,height,font_size,custom_x,custom_y";
420 $tabfieldinsert[31] =
"fk_country,code,label";
421 $tabfieldinsert[32] =
"code,dayrule,day,month,year,fk_country";
422 $tabfieldinsert[33] =
"code,label";
423 $tabfieldinsert[34] =
"code,label";
424 $tabfieldinsert[35] =
"label";
425 $tabfieldinsert[36] =
"range_ik,fk_c_exp_tax_cat";
426 $tabfieldinsert[37] =
"code,label,short_label,unit_type,scale,sortorder";
427 $tabfieldinsert[38] =
"code,label,url,icon,entity";
428 $tabfieldinsert[39] =
"code,label,sortorder";
429 $tabfieldinsert[40] =
"code,libelle,picto";
430 $tabfieldinsert[41] =
"code,label";
431 $tabfieldinsert[42] =
"code,label";
432 $tabfieldinsert[43] =
"code,label";
433 $tabfieldinsert[44] =
"code,label";
442 $tabrowid[4] =
"rowid";
443 $tabrowid[5] =
"rowid";
447 $tabrowid[9] =
"code_iso";
449 $tabrowid[11] =
"rowid";
451 $tabrowid[13] =
"id";
454 $tabrowid[16] =
"code";
455 $tabrowid[17] =
"id";
456 $tabrowid[18] =
"rowid";
457 $tabrowid[19] =
"id";
459 $tabrowid[21] =
"rowid";
460 $tabrowid[22] =
"rowid";
465 $tabrowid[27] =
"id";
470 $tabrowid[32] =
"id";
471 $tabrowid[33] =
"rowid";
472 $tabrowid[34] =
"rowid";
477 $tabrowid[39] =
"code";
478 $tabrowid[40] =
"id";
480 $tabrowid[42] =
"rowid";
481 $tabrowid[43] =
"rowid";
482 $tabrowid[44] =
"rowid";
499 $tabcond[14] = (
isModEnabled(
"product") && (
isModEnabled(
'ecotax') || !empty($conf->global->MAIN_SHOW_ECOTAX_DICTIONNARY)));
501 $tabcond[16] = (
isModEnabled(
"societe") && empty($conf->global->SOCIETE_DISABLE_PROSPECTS));
520 $tabcond[35] =
isModEnabled(
'expensereport') && !empty($conf->global->MAIN_USE_EXPENSE_IK);
521 $tabcond[36] =
isModEnabled(
'expensereport') && !empty($conf->global->MAIN_USE_EXPENSE_IK);
524 $tabcond[39] = (
isModEnabled(
"societe") && empty($conf->global->SOCIETE_DISABLE_PROSPECTS) && !empty($conf->global->THIRDPARTY_ENABLE_PROSPECTION_ON_ALTERNATIVE_ADRESSES));
525 $tabcond[40] = (
isModEnabled(
"societe") && !empty($conf->global->THIRDPARTY_ENABLE_PROSPECTION_ON_ALTERNATIVE_ADRESSES));
535 $tabcomplete = array(
536 'c_forme_juridique'=>array(
'picto'=>
'company',
'help'=>array(
'code'=>$langs->trans(
"EnterAnyCode"))),
537 'c_departements'=>array(
'picto'=>
'state',
'help'=>array(
'code'=>$langs->trans(
"EnterAnyCode"))),
538 'c_regions'=>array(
'picto'=>
'region',
'help'=>array(
'code'=>$langs->trans(
"EnterAnyCode"))),
539 'c_country'=>array(
'picto'=>
'country',
'help'=>array(
'code'=>$langs->trans(
"EnterAnyCode"))),
540 'c_civility'=>array(
'picto'=>
'contact',
'help'=>array(
'code'=>$langs->trans(
"EnterAnyCode"))),
541 'c_actioncomm'=>array(
'picto'=>
'action',
'help'=>array(
'code'=>$langs->trans(
"EnterAnyCode"),
'color'=>$langs->trans(
"ColorFormat"),
'position'=>$langs->trans(
"PositionIntoComboList"))),
542 'c_chargesociales'=>array(
'picto'=>
'bill',
'help'=>array(
'code'=>$langs->trans(
"EnterAnyCode"))),
543 'c_typent'=>array(
'picto'=>
'company',
'help'=>array(
'code'=>$langs->trans(
"EnterAnyCode"),
'position'=>$langs->trans(
"PositionIntoComboList"))),
544 'c_currencies'=>array(
'picto'=>
'multicurrency',
'help'=>array(
'code'=>$langs->trans(
"EnterAnyCode"),
'unicode'=>$langs->trans(
"UnicodeCurrency"))),
545 '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"))),
546 'c_type_contact'=>array(
'picto'=>
'contact',
'help'=>array(
'code'=>$langs->trans(
"EnterAnyCode"),
'position'=>$langs->trans(
"PositionIntoComboList"))),
547 '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")))),
548 'c_paiement'=>array(
'picto'=>
'bill',
'help'=>array(
'code'=>$langs->trans(
"EnterAnyCode"))),
549 'c_ecotaxe'=>array(
'picto'=>
'bill',
'help'=>array(
'code'=>$langs->trans(
"EnterAnyCode"))),
550 'c_paper_format'=>array(
'picto'=>
'generic',
'help'=>array(
'code'=>$langs->trans(
"EnterAnyCode"))),
551 'c_prospectlevel'=>array(
'picto'=>
'company',
'help'=>array(
'code'=>$langs->trans(
"EnterAnyCode"))),
552 'c_type_fees'=>array(
'picto'=>
'trip',
'help'=>array(
'code'=>$langs->trans(
"EnterAnyCode"))),
553 'c_shipment_mode'=>array(
'picto'=>
'shipment',
'help'=>array(
'code'=>$langs->trans(
"EnterAnyCode"),
'tracking'=>$langs->trans(
"UrlTrackingDesc"))),
554 'c_effectif'=>array(
'picto'=>
'company',
'help'=>array(
'code'=>$langs->trans(
"EnterAnyCode"))),
555 'c_input_method'=>array(
'picto'=>
'order',
'help'=>array(
'code'=>$langs->trans(
"EnterAnyCode"))),
556 'c_input_reason'=>array(
'picto'=>
'order',
'help'=>array(
'code'=>$langs->trans(
"EnterAnyCode"),
'position'=>$langs->trans(
"PositionIntoComboList"))),
557 'c_availability'=>array(
'picto'=>
'shipment',
'help'=>array(
'code'=>$langs->trans(
"EnterAnyCode"))),
558 'c_revenuestamp'=>array(
'picto'=>
'bill',
'help'=>array(
'revenuestamp_type'=>$langs->trans(
'FixedOrPercent'))),
559 'c_type_resource'=>array(
'picto'=>
'resource',
'help'=>array(
'code'=>$langs->trans(
"EnterAnyCode"))),
560 'c_type_container'=>array(
'picto'=>
'website',
'help'=>array(
'code'=>$langs->trans(
"EnterAnyCode"))),
561 'c_stcomm'=>array(
'picto'=>
'company',
'help'=>array(
'code'=>$langs->trans(
"EnterAnyCode"),
'picto'=>$langs->trans(
"PictoHelp"))),
562 'c_holiday_types'=>array(
'picto'=>
'holiday',
'help'=>array(
'affect'=>$langs->trans(
"FollowedByACounter"),
'delay'=>$langs->trans(
"MinimumNoticePeriod"),
'newbymonth'=>$langs->trans(
"NbAddedAutomatically"))),
563 'c_lead_status'=>array(
'picto'=>
'project',
'help'=>array(
'code'=>$langs->trans(
"EnterAnyCode"),
'percent'=>$langs->trans(
"OpportunityPercent"),
'position'=>$langs->trans(
"PositionIntoComboList"))),
564 'c_format_cards'=>array(
'picto'=>
'generic',
'help'=>array(
'code'=>$langs->trans(
"EnterAnyCode"),
'name'=>$langs->trans(
"LabelName"),
'paper_size'=>$langs->trans(
"LabelPaperSize"))),
565 '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"))),
566 'c_hrm_department'=>array(
'picto'=>
'hrm',
'help'=>array(
'code'=>$langs->trans(
"EnterAnyCode"))),
567 'c_hrm_function'=>array(
'picto'=>
'hrm',
'help'=>array(
'code'=>$langs->trans(
"EnterAnyCode"))),
568 'c_exp_tax_cat'=>array(
'picto'=>
'expensereport',
'help'=>array()),
569 'c_exp_tax_range'=>array(
'picto'=>
'expensereport',
'help'=>array(
'range_ik'=>$langs->trans(
'PrevRangeToThisRange'))),
570 'c_units'=>array(
'picto'=>
'product',
'help'=>array(
'code'=>$langs->trans(
"EnterAnyCode"),
'unit_type' => $langs->trans(
'Measuringtype_durationDesc'),
'scale' => $langs->trans(
'MeasuringScaleDesc'))),
571 'c_socialnetworks'=>array(
'picto'=>
'share-alt',
'help'=>array(
'code'=>$langs->trans(
"EnterAnyCode"),
'url' => $langs->trans(
'UrlSocialNetworksDesc'),
'icon' => $langs->trans(
'FafaIconSocialNetworksDesc'))),
572 'c_prospectcontactlevel'=>array(
'picto'=>
'company',
'help'=>array(
'code'=>$langs->trans(
"EnterAnyCode"))),
573 'c_stcommcontact'=>array(
'picto'=>
'company',
'help'=>array(
'code'=>$langs->trans(
"EnterAnyCode"),
'picto'=>$langs->trans(
"PictoHelp"))),
574 'c_transport_mode'=>array(
'picto'=>
'incoterm',
'help'=>array(
'code'=>$langs->trans(
"EnterAnyCode"))),
575 'c_product_nature'=>array(
'picto'=>
'product',
'help'=>array(
'code'=>$langs->trans(
"EnterAnyCode"))),
576 'c_productbatch_qcstatus'=>array(
'picto'=>
'lot',
'help'=>array(
'code'=>$langs->trans(
"EnterAnyCode"))),
577 'c_asset_disposal_type'=>array(
'picto'=>
'asset',
'help'=>array(
'code'=>$langs->trans(
"EnterAnyCode"))),
578 'c_invoice_subtype'=>array(
'picto'=>
'bill',
'help'=>array(
'code'=>$langs->trans(
"EnterAnyCode"))),
583 complete_dictionary_with_modules($taborder, $tabname, $tablib, $tabsql, $tabsqlsort, $tabfield, $tabfieldvalue, $tabfieldinsert, $tabrowid, $tabcond, $tabhelp, $tabcomplete);
587 foreach ($tabcomplete as $key => $value) {
590 if (!isset($tabcond[$i])) {
593 $tabcomplete[$key][
'id'] = $i;
594 $tabcomplete[$key][
'cond'] = $tabcond[$i];
595 $tabcomplete[$key][
'rowid'] = $tabrowid[$i];
596 $tabcomplete[$key][
'fieldinsert'] = $tabfieldinsert[$i];
597 $tabcomplete[$key][
'fieldvalue'] = $tabfieldvalue[$i];
598 $tabcomplete[$key][
'lib'] = $tablib[$i];
599 $tabcomplete[$key][
'sql'] = $tabsql[$i];
600 $tabcomplete[$key][
'sqlsort'] = $tabsqlsort[$i];
601 $tabcomplete[$key][
'field'] = $tabfield[$i];
607 $arrayofkeys = array_keys($tabcomplete);
608 if (array_key_exists($id -1, $arrayofkeys)) {
609 $keytable = $arrayofkeys[$id - 1];
614 if (empty($sortfield)) {
615 $tmp1 = explode(
',', empty($tabcomplete[$keytable][
'sqlsort']) ?
'' : $tabcomplete[$keytable][
'sqlsort']);
616 $tmp2 = explode(
' ', $tmp1[0]);
617 $sortfield = preg_replace(
'/^.*\./',
'', $tmp2[0]);
618 $sortorder = (!empty($tmp2[1]) ? $tmp2[1] :
'');
623 $elementList = array();
624 $sourceList = array();
626 $elementList = array(
628 'agenda' =>
img_picto(
'',
'action',
'class="pictofixedwidth"').$langs->trans(
'Agenda'),
629 'dolresource' =>
img_picto(
'',
'resource',
'class="pictofixedwidth"').$langs->trans(
'Resource'),
630 'societe' =>
img_picto(
'',
'company',
'class="pictofixedwidth"').$langs->trans(
'ThirdParty'),
636 'project' =>
img_picto(
'',
'project',
'class="pictofixedwidth"').$langs->trans(
'Project'),
637 'project_task' =>
img_picto(
'',
'projecttask',
'class="pictofixedwidth"').$langs->trans(
'Task'),
638 'propal' =>
img_picto(
'',
'propal',
'class="pictofixedwidth"').$langs->trans(
'Proposal'),
639 'commande' =>
img_picto(
'',
'order',
'class="pictofixedwidth"').$langs->trans(
'Order'),
640 'facture' =>
img_picto(
'',
'bill',
'class="pictofixedwidth"').$langs->trans(
'Bill'),
641 'fichinter' =>
img_picto(
'',
'intervention',
'class="pictofixedwidth"').$langs->trans(
'InterventionCard'),
642 'contrat' =>
img_picto(
'',
'contract',
'class="pictofixedwidth"').$langs->trans(
'Contract'),
643 'ticket' =>
img_picto(
'',
'ticket',
'class="pictofixedwidth"').$langs->trans(
'Ticket'),
644 'supplier_proposal' =>
img_picto(
'',
'supplier_proposal',
'class="pictofixedwidth"').$langs->trans(
'SupplierProposal'),
645 'order_supplier' =>
img_picto(
'',
'supplier_order',
'class="pictofixedwidth"').$langs->trans(
'SupplierOrder'),
646 'invoice_supplier' =>
img_picto(
'',
'supplier_invoice',
'class="pictofixedwidth"').$langs->trans(
'SupplierBill'),
648 if (!empty($conf->global->MAIN_FEATURES_LEVEL) && $conf->global->MAIN_FEATURES_LEVEL >= 2) {
649 $elementList[
'conferenceorbooth'] =
img_picto(
'',
'eventorganization',
'class="pictofixedwidth"').$langs->trans(
'ConferenceOrBooth');
656 'internal' => $langs->trans(
'Internal'),
657 'external' => $langs->trans(
'External')
662 $localtax_typeList = array(
663 "0" => $langs->trans(
"No"),
664 "1" => $langs->trans(
"Yes").
' ('.$langs->trans(
"Type").
" 1)",
665 "2" => $langs->trans(
"Yes").
' ('.$langs->trans(
"Type").
" 2)",
666 "3" => $langs->trans(
"Yes").
' ('.$langs->trans(
"Type").
" 3)",
667 "4" => $langs->trans(
"Yes").
' ('.$langs->trans(
"Type").
" 4)",
668 "5" => $langs->trans(
"Yes").
' ('.$langs->trans(
"Type").
" 5)",
669 "6" => $langs->trans(
"Yes").
' ('.$langs->trans(
"Type").
" 6)"
677 $object =
new stdClass();
682 'confirm' =>$confirm,
684 'taborder' =>$taborder,
685 'tabname' =>$tabname,
688 'tabsqlsort' =>$tabsqlsort,
689 'tabfield' =>$tabfield,
690 'tabfieldvalue' =>$tabfieldvalue,
691 'tabfieldinsert'=>$tabfieldinsert,
692 'tabrowid' =>$tabrowid,
693 'tabcond' =>$tabcond,
694 'tabhelp' =>$tabhelp,
695 'tabcomplete' =>$tabcomplete
697 $reshook = $hookmanager->executeHooks(
'doActions', $parameters, $object, $action);
702 if (
GETPOST(
'button_removefilter',
'alpha') ||
GETPOST(
'button_removefilter.x',
'alpha') ||
GETPOST(
'button_removefilter_x',
'alpha')) {
703 $search_country_id =
'';
707 if (empty($reshook)) {
710 $listfield = explode(
',', str_replace(
' ',
'', $tabfield[$id]));
711 $listfieldinsert = explode(
',', $tabfieldinsert[$id]);
712 $listfieldmodify = explode(
',', $tabfieldinsert[$id]);
713 $listfieldvalue = explode(
',', $tabfieldvalue[$id]);
717 foreach ($listfield as $f => $value) {
719 if ($value ==
'country_id' && in_array($tablib[$id], array(
'DictionaryPublicHolidays',
'DictionaryVAT',
'DictionaryInvoiceSubtype',
'DictionaryRegion',
'DictionaryCompanyType',
'DictionaryHolidayTypes',
'DictionaryRevenueStamp',
'DictionaryAccountancysystem',
'DictionaryAccountancyCategory'))) {
722 if ($value ==
'country' && in_array($tablib[$id], array(
'DictionaryPublicHolidays',
'DictionaryCanton',
'DictionaryCompanyType',
'DictionaryHolidayTypes',
'DictionaryRevenueStamp'))) {
726 if ($value ==
'localtax1' && !
GETPOST(
'localtax1_type')) {
729 if ($value ==
'localtax2' && !
GETPOST(
'localtax2_type')) {
732 if ($value ==
'color' && !
GETPOST(
'color')) {
735 if ($value ==
'formula' && !
GETPOST(
'formula')) {
738 if ($value ==
'dayrule' && !
GETPOST(
'dayrule')) {
741 if ($value ==
'sortorder') {
745 && (!in_array($value, array(
'decalage',
'module',
'accountancy_code',
'accountancy_code_sell',
'accountancy_code_buy',
'tracking',
'picto',
'deposit_percent'))
746 && ($id != 10 || ($value !=
'code' && $value !=
'note'))
750 $fieldnamekey = $value;
752 if ($fieldnamekey ==
'libelle' || ($fieldnamekey ==
'label')) {
753 $fieldnamekey =
'Label';
755 if ($fieldnamekey ==
'libelle_facture') {
756 $fieldnamekey =
'LabelOnDocuments';
758 if ($fieldnamekey ==
'deposit_percent') {
759 $fieldnamekey =
'DepositPercent';
761 if ($fieldnamekey ==
'nbjour') {
762 $fieldnamekey =
'NbOfDays';
764 if ($fieldnamekey ==
'decalage') {
765 $fieldnamekey =
'Offset';
767 if ($fieldnamekey ==
'module') {
768 $fieldnamekey =
'Module';
770 if ($fieldnamekey ==
'code') {
771 $fieldnamekey =
'Code';
773 if ($fieldnamekey ==
'note') {
774 $fieldnamekey =
'Note';
776 if ($fieldnamekey ==
'taux') {
777 $fieldnamekey =
'Rate';
779 if ($fieldnamekey ==
'type') {
780 $fieldnamekey =
'Type';
782 if ($fieldnamekey ==
'position') {
783 $fieldnamekey =
'Position';
785 if ($fieldnamekey ==
'unicode') {
786 $fieldnamekey =
'Unicode';
788 if ($fieldnamekey ==
'deductible') {
789 $fieldnamekey =
'Deductible';
791 if ($fieldnamekey ==
'sortorder') {
792 $fieldnamekey =
'SortOrder';
794 if ($fieldnamekey ==
'category_type') {
795 $fieldnamekey =
'Calculated';
797 if ($fieldnamekey ==
'revenuestamp_type') {
798 $fieldnamekey =
'TypeOfRevenueStamp';
800 if ($fieldnamekey ==
'use_default') {
801 $fieldnamekey =
'UseByDefault';
804 setEventMessages($langs->transnoentities(
"ErrorFieldRequired", $langs->transnoentities($fieldnamekey)),
null,
'errors');
808 if (
GETPOST(
'actionadd') && $tabname[$id] ==
"c_actioncomm" &&
GETPOSTISSET(
"type") && in_array(
GETPOST(
"type"), array(
'system',
'systemauto'))) {
810 setEventMessages($langs->transnoentities(
'ErrorReservedTypeSystemSystemAuto'),
null,
'errors');
815 setEventMessages($langs->transnoentities(
'ErrorCodeCantContainZero'),
null,
'errors');
819 if (in_array($tablib[$id], array(
'DictionaryCompanyType',
'DictionaryHolidayTypes'))) {
820 $_POST[
"country"] =
'';
823 setEventMessages($langs->transnoentities(
"ErrorFieldRequired", $langs->transnoentities(
"Country")),
null,
'errors');
826 if (($id == 3 || $id == 42) && !is_numeric(
GETPOST(
"code"))) {
828 setEventMessages($langs->transnoentities(
"ErrorFieldMustBeANumeric", $langs->transnoentities(
"Code")),
null,
'errors');
833 $_POST[
"localtax1"] =
'0';
836 $_POST[
"localtax2"] =
'0';
838 if (
GETPOST(
"accountancy_code") <= 0) {
839 $_POST[
"accountancy_code"] =
'';
841 if (
GETPOST(
"accountancy_code_sell") <= 0) {
842 $_POST[
"accountancy_code_sell"] =
'';
844 if (
GETPOST(
"accountancy_code_buy") <= 0) {
845 $_POST[
"accountancy_code_buy"] =
'';
848 $_POST[
"code"] = preg_replace(
'/[^a-zA-Z0-9_\-\+]/',
'',
GETPOST(
"code"));
851 $tablename = $tabname[$id];
852 $tablename = preg_replace(
'/^'.preg_quote(MAIN_DB_PREFIX,
'/').
'/',
'', $tablename);
855 if ($ok &&
GETPOST(
'actionadd')) {
856 if ($tabrowid[$id]) {
859 $sql =
"SELECT MAX(".$tabrowid[$id].
") as newid FROM ".MAIN_DB_PREFIX.$tablename;
860 $result = $db->query(
$sql);
862 $obj = $db->fetch_object($result);
863 $newid = ($obj->newid + 1);
870 $sql =
"INSERT INTO ".MAIN_DB_PREFIX.$tablename.
" (";
872 if ($tabrowid[$id] && !in_array($tabrowid[$id], $listfieldinsert)) {
873 $sql .= $tabrowid[$id].
",";
875 $sql .= $tabfieldinsert[$id];
880 if ($tabrowid[$id] && !in_array($tabrowid[$id], $listfieldinsert)) {
884 foreach ($listfieldinsert as $f => $value) {
885 $keycode = $listfieldvalue[$i];
886 if (empty($keycode)) {
890 if ($value ==
'price' || preg_match(
'/^amount/i', $value)) {
892 } elseif ($value ==
'taux' || $value ==
'localtax1') {
894 } elseif ($value ==
'entity') {
895 $_POST[$keycode] =
getEntity($tablename);
902 if ($keycode ==
'sortorder') {
904 } elseif (
GETPOST($keycode) ==
'' && !($keycode ==
'code' && $id == 10)) {
906 } elseif ($keycode ==
'content') {
907 $sql .=
"'".$db->escape(
GETPOST($keycode,
'restricthtml')).
"'";
908 } elseif (in_array($keycode, array(
'joinfile',
'private',
'pos',
'position',
'scale',
'use_default'))) {
911 $sql .=
"'".$db->escape(
GETPOST($keycode,
'alphanohtml')).
"'";
919 $resql = $db->query(
$sql);
921 setEventMessages($langs->transnoentities(
"RecordCreatedSuccessfully"),
null,
'mesgs');
924 if ($id == 10 &&
GETPOST(
'country',
'int') > 0) {
925 $search_country_id =
GETPOST(
'country',
'int');
927 $_POST = array(
'id'=>$id);
929 if ($db->errno() ==
'DB_ERROR_RECORD_ALREADY_EXISTS') {
930 setEventMessages($langs->transnoentities(
"ErrorRecordAlreadyExists"),
null,
'errors');
938 if ($ok &&
GETPOST(
'actionmodify')) {
939 if ($tabrowid[$id]) {
940 $rowidcol = $tabrowid[$id];
946 $sql =
"UPDATE ".MAIN_DB_PREFIX.$tablename.
" SET ";
948 if ($tabrowid[$id] && !in_array($tabrowid[$id], $listfieldmodify)) {
949 $sql .= $tabrowid[$id].
"=";
950 $sql .=
"'".$db->escape($rowid).
"', ";
953 foreach ($listfieldmodify as $field) {
954 $keycode = $listfieldvalue[$i];
955 if (empty($keycode)) {
959 if ($field ==
'price' || preg_match(
'/^amount/i', $field)) {
961 } elseif ($field ==
'taux' || $field ==
'localtax1') {
963 } elseif ($field ==
'entity') {
964 $_POST[$keycode] =
getEntity($tablename);
971 if ($listfieldvalue[$i] ==
'sortorder') {
973 } elseif (
GETPOST($keycode) ==
'' && !($keycode ==
'code' && $id == 10)) {
975 } elseif ($keycode ==
'content') {
976 $sql .=
"'".$db->escape(
GETPOST($keycode,
'restricthtml')).
"'";
977 } elseif (in_array($keycode, array(
'joinfile',
'private',
'pos',
'position',
'scale',
'use_default'))) {
980 $sql .=
"'".$db->escape(
GETPOST($keycode,
'alphanohtml')).
"'";
985 if (in_array($rowidcol, array(
'code',
'code_iso'))) {
986 $sql .=
" WHERE ".$rowidcol.
" = '".$db->escape($rowid).
"'";
988 $sql .=
" WHERE ".$rowidcol.
" = ".((int) $rowid);
990 if (in_array(
'entity', $listfieldmodify)) {
996 $resql = $db->query(
$sql);
1003 if ($action ==
'confirm_delete' && $confirm ==
'yes') {
1004 if ($tabrowid[$id]) {
1005 $rowidcol = $tabrowid[$id];
1007 $rowidcol =
"rowid";
1010 $tablename = $tabname[$id];
1011 $tablename = preg_replace(
'/^'.preg_quote(MAIN_DB_PREFIX,
'/').
'/',
'', $tablename);
1013 $sql =
"DELETE FROM ".MAIN_DB_PREFIX.$tablename.
" WHERE ".$rowidcol.
" = '".$db->escape($rowid).
"'".($entity !=
'' ?
" AND entity = ".(int) $entity :
'');
1016 $result = $db->query(
$sql);
1018 if ($db->errno() ==
'DB_ERROR_CHILD_EXISTS') {
1019 setEventMessages($langs->transnoentities(
"ErrorRecordIsUsedByChild"),
null,
'errors');
1027 if ($action == $acts[0]) {
1028 if ($tabrowid[$id]) {
1029 $rowidcol = $tabrowid[$id];
1031 $rowidcol =
"rowid";
1034 $tablename = $tabname[$id];
1035 $tablename = preg_replace(
'/^'.preg_quote(MAIN_DB_PREFIX,
'/').
'/',
'', $tablename);
1038 $sql =
"UPDATE ".MAIN_DB_PREFIX.$tablename.
" SET active = 1 WHERE ".$rowidcol.
" = '".$db->escape($rowid).
"'".($entity !=
'' ?
" AND entity = ".(int) $entity :
'');
1040 $sql =
"UPDATE ".MAIN_DB_PREFIX.$tablename.
" SET active = 1 WHERE code = '".$db->escape(
dol_escape_htmltag($code)).
"'".($entity !=
'' ?
" AND entity = ".(int) $entity :
'');
1043 $result = $db->query(
$sql);
1050 if ($action == $acts[1]) {
1051 if ($tabrowid[$id]) {
1052 $rowidcol = $tabrowid[$id];
1054 $rowidcol =
"rowid";
1057 $tablename = $tabname[$id];
1058 $tablename = preg_replace(
'/^'.preg_quote(MAIN_DB_PREFIX,
'/').
'/',
'', $tablename);
1061 $sql =
"UPDATE ".MAIN_DB_PREFIX.$tablename.
" SET active = 0 WHERE ".$rowidcol.
" = '".$db->escape($rowid).
"'".($entity !=
'' ?
" AND entity = ".(int) $entity :
'');
1063 $sql =
"UPDATE ".MAIN_DB_PREFIX.$tablename.
" SET active = 0 WHERE code = '".$db->escape(
dol_escape_htmltag($code)).
"'".($entity !=
'' ?
" AND entity = ".(int) $entity :
'');
1066 $result = $db->query(
$sql);
1073 if ($action ==
'activate_favorite') {
1074 if ($tabrowid[$id]) {
1075 $rowidcol = $tabrowid[$id];
1077 $rowidcol =
"rowid";
1080 $tablename = $tabname[$id];
1081 $tablename = preg_replace(
'/^'.preg_quote(MAIN_DB_PREFIX,
'/').
'/',
'', $tablename);
1084 $sql =
"UPDATE ".MAIN_DB_PREFIX.$tablename.
" SET favorite = 1 WHERE ".$rowidcol.
" = '".$db->escape($rowid).
"'".($entity !=
'' ?
" AND entity = ".(int) $entity :
'');
1086 $sql =
"UPDATE ".MAIN_DB_PREFIX.$tablename.
" SET favorite = 1 WHERE code = '".$db->escape(
dol_escape_htmltag($code)).
"'".($entity !=
'' ?
" AND entity = ".(int) $entity :
'');
1089 $result = $db->query(
$sql);
1096 if ($action ==
'disable_favorite') {
1097 if ($tabrowid[$id]) {
1098 $rowidcol = $tabrowid[$id];
1100 $rowidcol =
"rowid";
1103 $tablename = $tabname[$id];
1104 $tablename = preg_replace(
'/^'.preg_quote(MAIN_DB_PREFIX,
'/').
'/',
'', $tablename);
1107 $sql =
"UPDATE ".MAIN_DB_PREFIX.$tablename.
" SET favorite = 0 WHERE ".$rowidcol.
" = '".$db->escape($rowid).
"'".($entity !=
'' ?
" AND entity = ".(int) $entity :
'');
1109 $sql =
"UPDATE ".MAIN_DB_PREFIX.$tablename.
" SET favorite = 0 WHERE code = '".$db->escape(
dol_escape_htmltag($code)).
"'".($entity !=
'' ?
" AND entity = ".(int) $entity :
'');
1112 $result = $db->query(
$sql);
1119 if ($action ==
'activate_eec') {
1120 if ($tabrowid[$id]) {
1121 $rowidcol = $tabrowid[$id];
1123 $rowidcol =
"rowid";
1126 $tablename = $tabname[$id];
1127 $tablename = preg_replace(
'/^'.preg_quote(MAIN_DB_PREFIX,
'/').
'/',
'', $tablename);
1130 $sql =
"UPDATE ".MAIN_DB_PREFIX.$tablename.
" SET eec = 1 WHERE ".$rowidcol.
" = '".$db->escape($rowid).
"'".($entity !=
'' ?
" AND entity = ".(int) $entity :
'');
1132 $sql =
"UPDATE ".MAIN_DB_PREFIX.$tablename.
" SET eec = 1 WHERE code = '".$db->escape(
dol_escape_htmltag($code)).
"'".($entity !=
'' ?
" AND entity = ".(int) $entity :
'');
1135 $result = $db->query(
$sql);
1142 if ($action ==
'disable_eec') {
1143 if ($tabrowid[$id]) {
1144 $rowidcol = $tabrowid[$id];
1146 $rowidcol =
"rowid";
1149 $tablename = $tabname[$id];
1150 $tablename = preg_replace(
'/^'.preg_quote(MAIN_DB_PREFIX,
'/').
'/',
'', $tablename);
1153 $sql =
"UPDATE ".MAIN_DB_PREFIX.$tablename.
" SET eec = 0 WHERE ".$rowidcol.
" = '".$db->escape($rowid).
"'".($entity !=
'' ?
" AND entity = ".(int) $entity :
'');
1155 $sql =
"UPDATE ".MAIN_DB_PREFIX.$tablename.
" SET eec = 0 WHERE code = '".$db->escape(
dol_escape_htmltag($code)).
"'".($entity !=
'' ?
" AND entity = ".(int) $entity :
'');
1158 $result = $db->query(
$sql);
1173 $title = $langs->trans(
"DictionarySetup");
1179 $title .=
' - '.$langs->trans($tablib[$id]);
1180 $linkback =
'<a href="'.$_SERVER[
'PHP_SELF'].
'">'.$langs->trans(
"BackToDictionaryList").
'</a>';
1182 $titlepicto =
'title_setup';
1183 if ($id == 10 &&
GETPOST(
'from') ==
'accountancy') {
1184 $title = $langs->trans(
"MenuVatAccounts");
1185 $titlepicto =
'accountancy';
1187 if ($id == 7 &&
GETPOST(
'from') ==
'accountancy') {
1188 $title = $langs->trans(
"MenuTaxAccounts");
1189 $titlepicto =
'accountancy';
1195 print
'<span class="opacitymedium">'.$langs->trans(
"DictionaryDesc");
1196 print
" ".$langs->trans(
"OnlyActiveElementsAreShown").
"<br>\n";
1197 print
'</span><br>';
1201 $param =
'&id='.urlencode($id);
1202 if ($search_country_id > 0) {
1203 $param .=
'&search_country_id='.urlencode($search_country_id);
1205 if ($search_code !=
'') {
1206 $param .=
'&search_code='.urlencode($search_code);
1208 if ($entity !=
'') {
1209 $param .=
'&entity='.(int) $entity;
1211 $paramwithsearch = $param;
1213 $paramwithsearch .=
'&sortorder='.urlencode($sortorder);
1216 $paramwithsearch .=
'&sortfield='.urlencode($sortfield);
1219 $paramwithsearch .=
'&from='.urlencode(
GETPOST(
'from',
'alpha'));
1224 if ($action ==
'delete') {
1225 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);
1233 $sql = $tabsql[$id];
1235 if (!preg_match(
'/ WHERE /',
$sql)) {
1236 $sql .=
" WHERE 1 = 1";
1238 if ($search_country_id > 0) {
1239 $sql .=
" AND c.rowid = ".((int) $search_country_id);
1241 if ($search_code !=
'' && $id == 9) {
1243 } elseif ($search_code !=
'' && $id == 28) {
1245 } elseif ($search_code !=
'' && ($id == 7 || $id == 32)) {
1247 } elseif ($search_code !=
'' && $id == 3) {
1249 } elseif ($search_code !=
'' && ($id == 8 || $id == 10)) {
1251 } elseif ($search_code !=
'' && $id == 1) {
1253 } elseif ($search_code !=
'' && $id == 2) {
1255 } elseif ($search_code !=
'' && $id == 14) {
1257 } elseif ($search_code !=
'' && $id != 9) {
1263 if ($sortfield ==
'country') {
1264 $sortfield =
'country_code';
1266 $sql .= $db->order($sortfield, $sortorder);
1269 $tabsqlsort[$id] = preg_replace(
'/([a-z]+\.)?'.$sortfield.
' '.$sortorder.
',/i',
'', $tabsqlsort[$id]);
1270 $tabsqlsort[$id] = preg_replace(
'/([a-z]+\.)?'.$sortfield.
',/i',
'', $tabsqlsort[$id]);
1272 $sql .=
" ORDER BY ";
1274 $sql .= $tabsqlsort[$id];
1275 $sql .= $db->plimit($listlimit + 1, $offset);
1278 if (empty($tabfield[$id])) {
1279 dol_print_error($db,
'The table with id '.$id.
' has no array tabfield defined');
1282 $fieldlist = explode(
',', $tabfield[$id]);
1284 print
'<form action="'.$_SERVER[
'PHP_SELF'].
'?id='.$id.
'" method="POST">';
1285 print
'<input type="hidden" name="token" value="'.newToken().
'">';
1286 print
'<input type="hidden" name="from" value="'.dol_escape_htmltag(
GETPOST(
'from',
'alpha')).
'">';
1288 if ($id == 10 && empty($conf->global->FACTURE_TVAOPTION)) {
1289 print
info_admin($langs->trans(
"VATIsUsedIsOff", $langs->transnoentities(
"Setup"), $langs->transnoentities(
"CompanyFoundation")));
1294 if ($tabname[$id]) {
1297 $fieldlist = explode(
',', $tabfield[$id]);
1299 print
'<div class="div-table-responsive-no-min">';
1300 print
'<table class="noborder centpercent">';
1303 print
'<!-- line title to add new entry -->';
1304 $tdsoffields =
'<tr class="liste_titre">';
1305 foreach ($fieldlist as $field => $value) {
1306 if ($value ==
'entity') {
1312 $valuetoshow = ucfirst($value);
1313 $valuetoshow = $langs->trans($valuetoshow);
1316 if ($value ==
'pos') {
1317 $valuetoshow = $langs->trans(
"Position"); $class =
'right';
1319 if ($value ==
'source') {
1320 $valuetoshow = $langs->trans(
"Contact");
1322 if ($value ==
'price') {
1323 $valuetoshow = $langs->trans(
"PriceUHT");
1325 if ($value ==
'taux') {
1326 if ($tabname[$id] !=
"c_revenuestamp") {
1327 $valuetoshow = $langs->trans(
"Rate");
1329 $valuetoshow = $langs->trans(
"Amount");
1333 if ($value ==
'localtax1_type') {
1334 $valuetoshow = $langs->trans(
"UseLocalTax").
" 2"; $class =
"center"; $sortable = 0;
1336 if ($value ==
'localtax1') {
1337 $valuetoshow = $langs->trans(
"RateOfTaxN",
'2'); $class =
"center";
1339 if ($value ==
'localtax2_type') {
1340 $valuetoshow = $langs->trans(
"UseLocalTax").
" 3"; $class =
"center"; $sortable = 0;
1342 if ($value ==
'localtax2') {
1343 $valuetoshow = $langs->trans(
"RateOfTaxN",
'3'); $class =
"center";
1345 if ($value ==
'organization') {
1346 $valuetoshow = $langs->trans(
"Organization");
1348 if ($value ==
'lang') {
1349 $valuetoshow = $langs->trans(
"Language");
1351 if ($value ==
'type') {
1352 if ($tabname[$id] ==
"c_paiement") {
1353 $valuetoshow =
$form->textwithtooltip($langs->trans(
"Type"), $langs->trans(
"TypePaymentDesc"), 2, 1,
img_help(1,
''));
1355 $valuetoshow = $langs->trans(
"Type");
1358 if ($value ==
'code') {
1359 $valuetoshow = $langs->trans(
"Code"); $class =
'maxwidth100';
1361 if ($value ==
'libelle' || $value ==
'label') {
1362 $valuetoshow =
$form->textwithtooltip($langs->trans(
"Label"), $langs->trans(
"LabelUsedByDefault"), 2, 1,
img_help(1,
''));
1364 if ($value ==
'libelle_facture') {
1365 $valuetoshow =
$form->textwithtooltip($langs->trans(
"LabelOnDocuments"), $langs->trans(
"LabelUsedByDefault"), 2, 1,
img_help(1,
''));
1367 if ($value ==
'deposit_percent') {
1368 $valuetoshow = $langs->trans(
'DepositPercent');
1371 if ($value ==
'country') {
1372 if (in_array(
'region_id', $fieldlist)) {
1373 print
'<td> </td>';
continue;
1375 $valuetoshow = $langs->trans(
"Country");
1377 if ($value ==
'recuperableonly') {
1378 $valuetoshow = $langs->trans(
"NPR"); $class =
"center";
1380 if ($value ==
'nbjour') {
1381 $valuetoshow = $langs->trans(
"NbOfDays");
1384 if ($value ==
'type_cdr') {
1385 $valuetoshow = $langs->trans(
"AtEndOfMonth"); $class =
"center";
1387 if ($value ==
'decalage') {
1388 $valuetoshow = $langs->trans(
"Offset");
1391 if ($value ==
'width' || $value ==
'nx') {
1392 $valuetoshow = $langs->trans(
"Width");
1394 if ($value ==
'height' || $value ==
'ny') {
1395 $valuetoshow = $langs->trans(
"Height");
1397 if ($value ==
'unit' || $value ==
'metric') {
1398 $valuetoshow = $langs->trans(
"MeasuringUnit");
1400 if ($value ==
'region_id' || $value ==
'country_id') {
1403 if ($value ==
'accountancy_code') {
1404 $valuetoshow = $langs->trans(
"AccountancyCode");
1406 if ($value ==
'accountancy_code_sell') {
1407 $valuetoshow = $langs->trans(
"AccountancyCodeSell");
1409 if ($value ==
'accountancy_code_buy') {
1410 $valuetoshow = $langs->trans(
"AccountancyCodeBuy");
1412 if ($value ==
'pcg_version' || $value ==
'fk_pcg_version') {
1413 $valuetoshow = $langs->trans(
"Pcg_version");
1415 if ($value ==
'account_parent') {
1416 $valuetoshow = $langs->trans(
"Accountparent");
1418 if ($value ==
'pcg_type') {
1419 $valuetoshow = $langs->trans(
"Pcg_type");
1421 if ($value ==
'pcg_subtype') {
1422 $valuetoshow = $langs->trans(
"Pcg_subtype");
1424 if ($value ==
'sortorder') {
1425 $valuetoshow = $langs->trans(
"SortOrder");
1428 if ($value ==
'short_label') {
1429 $valuetoshow = $langs->trans(
"ShortLabel");
1431 if ($value ==
'fk_parent') {
1432 $valuetoshow = $langs->trans(
"ParentID"); $class =
'center';
1434 if ($value ==
'range_account') {
1435 $valuetoshow = $langs->trans(
"Range");
1437 if ($value ==
'sens') {
1438 $valuetoshow = $langs->trans(
"Sens");
1440 if ($value ==
'category_type') {
1441 $valuetoshow = $langs->trans(
"Calculated");
1443 if ($value ==
'formula') {
1444 $valuetoshow = $langs->trans(
"Formula");
1446 if ($value ==
'paper_size') {
1447 $valuetoshow = $langs->trans(
"PaperSize");
1449 if ($value ==
'orientation') {
1450 $valuetoshow = $langs->trans(
"Orientation");
1452 if ($value ==
'leftmargin') {
1453 $valuetoshow = $langs->trans(
"LeftMargin");
1455 if ($value ==
'topmargin') {
1456 $valuetoshow = $langs->trans(
"TopMargin");
1458 if ($value ==
'spacex') {
1459 $valuetoshow = $langs->trans(
"SpaceX");
1461 if ($value ==
'spacey') {
1462 $valuetoshow = $langs->trans(
"SpaceY");
1464 if ($value ==
'font_size') {
1465 $valuetoshow = $langs->trans(
"FontSize");
1467 if ($value ==
'custom_x') {
1468 $valuetoshow = $langs->trans(
"CustomX");
1470 if ($value ==
'custom_y') {
1471 $valuetoshow = $langs->trans(
"CustomY");
1473 if ($value ==
'percent') {
1474 $valuetoshow = $langs->trans(
"Percentage");
1476 if ($value ==
'affect') {
1477 $valuetoshow = $langs->trans(
"WithCounter");
1479 if ($value ==
'delay') {
1480 $valuetoshow = $langs->trans(
"NoticePeriod");
1482 if ($value ==
'newbymonth') {
1483 $valuetoshow = $langs->trans(
"NewByMonth");
1485 if ($value ==
'fk_tva') {
1486 $valuetoshow = $langs->trans(
"VAT");
1488 if ($value ==
'range_ik') {
1489 $valuetoshow = $langs->trans(
"RangeIk");
1491 if ($value ==
'fk_c_exp_tax_cat') {
1492 $valuetoshow = $langs->trans(
"CarCategory");
1494 if ($value ==
'revenuestamp_type') {
1495 $valuetoshow = $langs->trans(
'TypeOfRevenueStamp');
1497 if ($value ==
'use_default') {
1498 $valuetoshow = $langs->trans(
'Default'); $class =
'center';
1500 if ($value ==
'unit_type') {
1501 $valuetoshow = $langs->trans(
'TypeOfUnit');
1503 if ($value ==
'public' && $tablib[$id] ==
'TicketDictCategory') {
1504 $valuetoshow = $langs->trans(
'TicketGroupIsPublic'); $class =
'center';
1506 if ($value ==
'block_if_negative') {
1507 $valuetoshow = $langs->trans(
'BlockHolidayIfNegative');
1509 if ($value ==
'type_duration') {
1510 $valuetoshow = $langs->trans(
'Unit');
1514 if ($value ==
'region_id') {
1515 $valuetoshow =
' '; $showfield = 1;
1517 if ($value ==
'region') {
1518 $valuetoshow = $langs->trans(
"Country").
'/'.$langs->trans(
"Region"); $showfield = 1;
1522 if ($valuetoshow !=
'') {
1523 $tooltiphelp = (isset($tabcomplete[$tabname[$id]][
'help'][$value]) ? $tabcomplete[$tabname[$id]][
'help'][$value] :
'');
1525 $tdsoffields .=
'<th'.($class ?
' class="'.$class.
'"' :
'').
'>';
1526 if ($tooltiphelp && preg_match(
'/^http(s*):/i', $tooltiphelp)) {
1527 $tdsoffields .=
'<a href="'.$tooltiphelp.
'" target="_blank">'.$valuetoshow.
' '.
img_help(1, $valuetoshow).
'</a>';
1528 } elseif ($tooltiphelp) {
1529 $tdsoffields .=
$form->textwithpicto($valuetoshow, $tooltiphelp);
1531 $tdsoffields .= $valuetoshow;
1533 $tdsoffields .=
'</th>';
1538 $tdsoffields .=
'<th></th>';
1539 $tdsoffields .=
'<th></th>';
1541 $tdsoffields .=
'<th>';
1542 $tdsoffields .=
'<input type="hidden" name="id" value="'.$id.
'">';
1543 if (!is_null($withentity)) {
1544 $tdsoffields .=
'<input type="hidden" name="entity" value="'.$withentity.
'">';
1546 $tdsoffields .=
'</th>';
1547 $tdsoffields .=
'<th style="min-width: 26px;"></th>';
1548 $tdsoffields .=
'<th style="min-width: 26px;"></th>';
1549 $tdsoffields .=
'</tr>';
1555 print
'<!-- line input to add new entry -->';
1556 print
'<tr class="oddeven nodrag nodrop nohover">';
1558 $obj =
new stdClass();
1561 foreach ($fieldlist as $key => $val) {
1568 $tmpaction =
'create';
1569 $parameters = array(
'fieldlist'=>$fieldlist,
'tabname'=>$tabname[$id]);
1570 $reshook = $hookmanager->executeHooks(
'createDictionaryFieldlist', $parameters, $obj, $tmpaction);
1571 $error = $hookmanager->error; $errors = $hookmanager->errors;
1574 unset($fieldlist[2]);
1577 if (empty($reshook)) {
1578 fieldList($fieldlist, $obj, $tabname[$id],
'add');
1585 print
'<td colspan="3" class="center">';
1586 if ($action !=
'edit') {
1587 print
'<input type="submit" class="button button-add small" name="actionadd" value="'.$langs->trans(
"Add").
'">';
1589 print
'<input type="submit" class="button button-add small disabled" name="actionadd" value="'.$langs->trans(
"Add").
'">';
1605 print
'<form action="'.$_SERVER[
'PHP_SELF'].
'?id='.$id.
'" method="POST">';
1606 print
'<input type="hidden" name="token" value="'.newToken().
'">';
1607 print
'<input type="hidden" name="from" value="'.dol_escape_htmltag(
GETPOST(
'from',
'alpha')).
'">';
1612 $resql = $db->query(
$sql);
1614 $num = $db->num_rows($resql);
1618 if (($num > $listlimit) || $page) {
1619 print_fleche_navigation($page, $_SERVER[
"PHP_SELF"], $paramwithsearch, ($num > $listlimit),
'<li class="pagination"><span>'.$langs->trans(
"Page").
' '.($page + 1).
'</span></li>');
1620 print
'<div class="clearboth"></div>';
1624 foreach ($fieldlist as $field => $value) {
1625 if ($value ==
'entity') {
1630 if ($value ==
'region_id' || $value ==
'country_id') {
1635 if ($value ==
'country') {
1637 } elseif ($value ==
'code') {
1643 print
'<div class="div-table-responsive">';
1644 print
'<table class="noborder centpercent">';
1647 print
'<!-- line title to search record -->'.
"\n";
1648 print
'<tr class="liste_titre_filter">';
1652 print
'<td class="liste_titre center">';
1654 $searchpicto =
$form->showFilterAndCheckAddButtons(0);
1662 foreach ($fieldlist as $field => $value) {
1663 if ($value ==
'entity') {
1668 if ($value ==
'region_id' || $value ==
'country_id') {
1673 if ($value ==
'country') {
1674 print
'<td class="liste_titre">';
1675 print
$form->select_country($search_country_id,
'search_country_id',
'', 28,
'minwidth100 maxwidth150 maxwidthonsmartphone');
1678 } elseif ($value ==
'code') {
1679 print
'<td class="liste_titre">';
1680 print
'<input type="text" class="maxwidth100" name="search_code" value="'.dol_escape_htmltag($search_code).
'">';
1684 print
'<td class="liste_titre">';
1697 print
'<td class="liste_titre"></td>';
1702 print
'<td class="liste_titre center">';
1704 $searchpicto =
$form->showFilterAndCheckAddButtons(0);
1714 print
'<!-- line title of record -->'.
"\n";
1715 print
'<tr class="liste_titre">';
1722 foreach ($fieldlist as $field => $value) {
1723 if ($value ==
'entity') {
1727 if (in_array($value, array(
'label',
'libelle',
'libelle_facture')) && empty($tabcomplete[$tabname[$id]][
'help'][$value])) {
1728 $tabcomplete[$tabname[$id]][
'help'][$value] = $langs->trans(
'LabelUsedByDefault');
1736 $valuetoshow = ucfirst($value);
1737 $valuetoshow = $langs->trans($valuetoshow);
1740 if ($value ==
'source') {
1741 $valuetoshow = $langs->trans(
"Contact");
1743 if ($value ==
'price') {
1744 $valuetoshow = $langs->trans(
"PriceUHT");
1746 if ($value ==
'taux') {
1747 if ($tabname[$id] !=
"c_revenuestamp") {
1748 $valuetoshow = $langs->trans(
"Rate");
1750 $valuetoshow = $langs->trans(
"Amount");
1752 $cssprefix =
'center ';
1755 if ($value ==
'localtax1_type') {
1756 $valuetoshow = $langs->trans(
"UseLocalTax").
" 2"; $cssprefix =
"center "; $sortable = 0;
1758 if ($value ==
'localtax1') {
1759 $valuetoshow = $langs->trans(
"RateOfTaxN",
'2'); $cssprefix =
"center "; $sortable = 0;
1761 if ($value ==
'localtax2_type') {
1762 $valuetoshow = $langs->trans(
"UseLocalTax").
" 3"; $cssprefix =
"center "; $sortable = 0;
1764 if ($value ==
'localtax2') {
1765 $valuetoshow = $langs->trans(
"RateOfTaxN",
'3'); $cssprefix =
"center "; $sortable = 0;
1767 if ($value ==
'organization') {
1768 $valuetoshow = $langs->trans(
"Organization");
1770 if ($value ==
'lang') {
1771 $valuetoshow = $langs->trans(
"Language");
1773 if ($value ==
'type') {
1774 $valuetoshow = $langs->trans(
"Type");
1776 if ($value ==
'code') {
1777 $valuetoshow = $langs->trans(
"Code");
1779 if (in_array($value, array(
'pos',
'position'))) {
1780 $valuetoshow = $langs->trans(
"Position"); $cssprefix =
'right ';
1782 if ($value ==
'libelle' || $value ==
'label') {
1783 $valuetoshow = $langs->trans(
"Label");
1785 if ($value ==
'libelle_facture') {
1786 $valuetoshow = $langs->trans(
"LabelOnDocuments");
1788 if ($value ==
'deposit_percent') {
1789 $valuetoshow = $langs->trans(
'DepositPercent');
1790 $cssprefix =
'right ';
1792 if ($value ==
'country') {
1793 $valuetoshow = $langs->trans(
"Country");
1795 if ($value ==
'recuperableonly') {
1796 $valuetoshow = $langs->trans(
"NPR"); $cssprefix =
"center ";
1798 if ($value ==
'nbjour') {
1799 $valuetoshow = $langs->trans(
"NbOfDays");
1800 $cssprefix =
'right ';
1802 if ($value ==
'type_cdr') {
1803 $valuetoshow = $langs->trans(
"AtEndOfMonth"); $cssprefix =
"center ";
1805 if ($value ==
'decalage') {
1806 $valuetoshow = $langs->trans(
"Offset");
1807 $cssprefix =
'right ';
1809 if ($value ==
'width' || $value ==
'nx') {
1810 $valuetoshow = $langs->trans(
"Width");
1812 if ($value ==
'height' || $value ==
'ny') {
1813 $valuetoshow = $langs->trans(
"Height");
1815 if ($value ==
'unit' || $value ==
'metric') {
1816 $valuetoshow = $langs->trans(
"MeasuringUnit");
1818 if ($value ==
'accountancy_code') {
1819 $valuetoshow = $langs->trans(
"AccountancyCode");
1821 if ($value ==
'accountancy_code_sell') {
1822 $valuetoshow = $langs->trans(
"AccountancyCodeSell"); $sortable = 0;
1824 if ($value ==
'accountancy_code_buy') {
1825 $valuetoshow = $langs->trans(
"AccountancyCodeBuy"); $sortable = 0;
1827 if ($value ==
'fk_pcg_version') {
1828 $valuetoshow = $langs->trans(
"Pcg_version");
1830 if ($value ==
'account_parent') {
1831 $valuetoshow = $langs->trans(
"Accountsparent");
1833 if ($value ==
'pcg_type') {
1834 $valuetoshow = $langs->trans(
"Pcg_type");
1836 if ($value ==
'pcg_subtype') {
1837 $valuetoshow = $langs->trans(
"Pcg_subtype");
1839 if ($value ==
'sortorder') {
1840 $valuetoshow = $langs->trans(
"SortOrder");
1841 $cssprefix =
'center ';
1843 if ($value ==
'short_label') {
1844 $valuetoshow = $langs->trans(
"ShortLabel");
1846 if ($value ==
'fk_parent') {
1847 $valuetoshow = $langs->trans(
"ParentID"); $cssprefix =
'center ';
1849 if ($value ==
'range_account') {
1850 $valuetoshow = $langs->trans(
"Range");
1852 if ($value ==
'sens') {
1853 $valuetoshow = $langs->trans(
"Sens");
1855 if ($value ==
'category_type') {
1856 $valuetoshow = $langs->trans(
"Calculated");
1858 if ($value ==
'formula') {
1859 $valuetoshow = $langs->trans(
"Formula");
1861 if ($value ==
'paper_size') {
1862 $valuetoshow = $langs->trans(
"PaperSize");
1864 if ($value ==
'orientation') {
1865 $valuetoshow = $langs->trans(
"Orientation");
1867 if ($value ==
'leftmargin') {
1868 $valuetoshow = $langs->trans(
"LeftMargin");
1870 if ($value ==
'topmargin') {
1871 $valuetoshow = $langs->trans(
"TopMargin");
1873 if ($value ==
'spacex') {
1874 $valuetoshow = $langs->trans(
"SpaceX");
1876 if ($value ==
'spacey') {
1877 $valuetoshow = $langs->trans(
"SpaceY");
1879 if ($value ==
'font_size') {
1880 $valuetoshow = $langs->trans(
"FontSize");
1882 if ($value ==
'custom_x') {
1883 $valuetoshow = $langs->trans(
"CustomX");
1885 if ($value ==
'custom_y') {
1886 $valuetoshow = $langs->trans(
"CustomY");
1888 if ($value ==
'percent') {
1889 $valuetoshow = $langs->trans(
"Percentage");
1891 if ($value ==
'affect') {
1892 $valuetoshow = $langs->trans(
"WithCounter");
1894 if ($value ==
'delay') {
1895 $valuetoshow = $langs->trans(
"NoticePeriod");
1897 if ($value ==
'newbymonth') {
1898 $valuetoshow = $langs->trans(
"NewByMonth");
1900 if ($value ==
'fk_tva') {
1901 $valuetoshow = $langs->trans(
"VAT");
1903 if ($value ==
'range_ik') {
1904 $valuetoshow = $langs->trans(
"RangeIk");
1906 if ($value ==
'fk_c_exp_tax_cat') {
1907 $valuetoshow = $langs->trans(
"CarCategory");
1909 if ($value ==
'revenuestamp_type') {
1910 $valuetoshow = $langs->trans(
'TypeOfRevenueStamp');
1912 if ($value ==
'use_default') {
1913 $valuetoshow = $langs->trans(
'Default'); $cssprefix =
'center ';
1915 if ($value ==
'unit_type') {
1916 $valuetoshow = $langs->trans(
'TypeOfUnit');
1918 if ($value ==
'public' && $tablib[$id] ==
'TicketDictCategory') {
1919 $valuetoshow = $langs->trans(
'TicketGroupIsPublic'); $cssprefix =
'center ';
1921 if ($value ==
'block_if_negative') {
1922 $valuetoshow = $langs->trans(
'BlockHolidayIfNegative');
1924 if ($value ==
'type_duration') {
1925 $valuetoshow = $langs->trans(
'Unit');
1928 if ($value ==
'region_id' || $value ==
'country_id') {
1934 $tooltiphelp = (isset($tabcomplete[$tabname[$id]][
'help'][$value]) ? $tabcomplete[$tabname[$id]][
'help'][$value] :
'');
1936 if ($tooltiphelp && preg_match(
'/^http(s*):/i', $tooltiphelp)) {
1937 $newvaluetoshow =
'<a href="'.$tooltiphelp.
'" target="_blank">'.$valuetoshow.
' '.
img_help(1, $valuetoshow).
'</a>';
1938 } elseif ($tooltiphelp) {
1939 $newvaluetoshow =
$form->textwithpicto($valuetoshow, $tooltiphelp);
1941 $newvaluetoshow = $valuetoshow;
1944 print
getTitleFieldOfList($newvaluetoshow, 0, $_SERVER[
"PHP_SELF"], ($sortable ? $value :
''), ($page ?
'page='.$page.
'&' :
''), $param,
'', $sortfield, $sortorder, $cssprefix);
1949 print
getTitleFieldOfList($langs->trans(
"InEEC"), 0, $_SERVER[
"PHP_SELF"],
"eec", ($page ?
'page='.$page.
'&' :
''), $param,
'align="center"', $sortfield, $sortorder,
'', 0, $langs->trans(
"CountryIsInEEC"));
1950 print
getTitleFieldOfList($langs->trans(
"Favorite"), 0, $_SERVER[
"PHP_SELF"],
"favorite", ($page ?
'page='.$page.
'&' :
''), $param,
'align="center"', $sortfield, $sortorder);
1954 print
getTitleFieldOfList($langs->trans(
"Status"), 0, $_SERVER[
"PHP_SELF"],
"active", ($page ?
'page='.$page.
'&' :
''), $param,
'align="center"', $sortfield, $sortorder);
1965 $obj = $db->fetch_object($resql);
1972 if (isset($obj->code) && $id != 10 && $id != 42) {
1973 if (($obj->code ==
'0' || $obj->code ==
'' || preg_match(
'/unknown/i', $obj->code))) {
1974 $iserasable = 0; $canbedisabled = 0;
1975 } elseif ($obj->code ==
'RECEP') {
1976 $iserasable = 0; $canbedisabled = 0;
1977 } elseif ($obj->code ==
'EF0') {
1978 $iserasable = 0; $canbedisabled = 0;
1981 if ($id == 25 && in_array($obj->code, array(
'banner',
'blogpost',
'other',
'page'))) {
1982 $iserasable = 0; $canbedisabled = 0;
1983 if (in_array($obj->code, array(
'banner'))) {
1987 if (isset($obj->type) && in_array($obj->type, array(
'system',
'systemauto'))) {
1990 if (in_array(empty($obj->code) ?
'' : $obj->code, array(
'AC_OTH',
'AC_OTH_AUTO')) || in_array(empty($obj->type) ?
'' : $obj->type, array(
'systemauto'))) {
1991 $canbedisabled = 0; $canbedisabled = 0;
1993 $canbemodified = $iserasable;
1995 if (!empty($obj->code) && $obj->code ==
'RECEP') {
1998 if ($tabname[$id] ==
"c_actioncomm") {
2003 $rowidcol = $tabrowid[$id];
2005 if (empty($rowidcol) || in_array($id, array(6, 7, 8, 13, 17, 19, 27, 32))) {
2006 $rowidcol =
'rowid';
2008 $url = $_SERVER[
"PHP_SELF"].
'?'.($page ?
'page='.$page.
'&' :
'').
'sortfield='.$sortfield.
'&sortorder='.$sortorder.
'&rowid='.(isset($obj->{$rowidcol}) ? $obj->{$rowidcol} : (!empty($obj->code) ? urlencode($obj->code) :
'')).
'&code='.(!empty($obj->
code) ?urlencode($obj->
code) :
'');
2009 if (!empty($param)) {
2012 if (!is_null($withentity)) {
2013 $url .=
'&entity='.$withentity;
2019 print
'<tr class="oddeven" id="rowid-'.(empty($obj->rowid) ?
'' : $obj->rowid).
'">';
2023 print
'<td class="center maxwidthsearch nowraponall">';
2025 if ($canbemodified) {
2026 print
'<a class="reposition editfielda marginleftonly paddingleft marginrightonly paddingright" href="'.$url.
'action=edit&token='.
newToken().
'">'.
img_edit().
'</a>';
2031 print
'<a class="reposition marginleftonly paddingleft marginrightonly paddingright" href="'.$url.
'action=delete&token='.
newToken().
'">'.
img_delete().
'</a>';
2037 if ($action ==
'edit' && ($rowid == (!empty($obj->rowid) ? $obj->rowid : $obj->code))) {
2038 $tmpaction =
'edit';
2039 $parameters = array(
'fieldlist'=>$fieldlist,
'tabname'=>$tabname[$id]);
2040 $reshook = $hookmanager->executeHooks(
'editDictionaryFieldlist', $parameters, $obj, $tmpaction);
2041 $error = $hookmanager->error; $errors = $hookmanager->errors;
2044 if (empty($reshook)) {
2045 $withentity =
fieldList($fieldlist, $obj, $tabname[$id],
'edit');
2048 print
'<td colspan="3" class="center">';
2049 print
'<div name="'.(!empty($obj->rowid) ? $obj->rowid : $obj->code).
'"></div>';
2050 print
'<input type="hidden" name="page" value="'.dol_escape_htmltag($page).
'">';
2051 print
'<input type="hidden" name="rowid" value="'.dol_escape_htmltag($rowid).
'">';
2052 if (!is_null($withentity)) {
2053 print
'<input type="hidden" name="entity" value="'.$withentity.
'">';
2055 print
'<input type="submit" class="button button-edit small" name="actionmodify" value="'.$langs->trans(
"Modify").
'">';
2056 print
'<input type="submit" class="button button-cancel small" name="actioncancel" value="'.$langs->trans(
"Cancel").
'">';
2059 $tmpaction =
'view';
2060 $parameters = array(
'fieldlist'=>$fieldlist,
'tabname'=>$tabname[$id]);
2061 $reshook = $hookmanager->executeHooks(
'viewDictionaryFieldlist', $parameters, $obj, $tmpaction);
2063 $error = $hookmanager->error; $errors = $hookmanager->errors;
2065 if (empty($reshook)) {
2068 foreach ($fieldlist as $field => $value) {
2072 $valuetoshow = empty($obj->$value) ?
'' : $obj->$value;
2075 if ($value ==
'entity') {
2076 $withentity = $valuetoshow;
2080 if ($value ==
'element') {
2081 $valuetoshow = isset($elementList[$valuetoshow]) ? $elementList[$valuetoshow] : $valuetoshow;
2082 } elseif ($value ==
'source') {
2083 $valuetoshow = isset($sourceList[$valuetoshow]) ? $sourceList[$valuetoshow] : $valuetoshow;
2084 } elseif ($valuetoshow ==
'all') {
2085 $valuetoshow = $langs->trans(
'All');
2086 } elseif ($value ==
'country') {
2087 if (empty($obj->country_code)) {
2090 $key = $langs->trans(
"Country".strtoupper($obj->country_code));
2091 $valuetoshow = ($key !=
"Country".strtoupper($obj->country_code) ? $obj->country_code.
" - ".$key : $obj->country);
2093 } elseif ($value ==
'recuperableonly' || $value ==
'deductible' || $value ==
'category_type') {
2094 $valuetoshow =
yn($valuetoshow ? 1 : 0);
2096 } elseif ($value ==
'type_cdr') {
2097 if (empty($valuetoshow)) {
2098 $valuetoshow = $langs->trans(
'None');
2099 } elseif ($valuetoshow == 1) {
2100 $valuetoshow = $langs->trans(
'AtEndOfMonth');
2101 } elseif ($valuetoshow == 2) {
2102 $valuetoshow = $langs->trans(
'CurrentNext');
2105 } elseif ($value ==
'price' || preg_match(
'/^amount/i', $value)) {
2106 $valuetoshow =
price($valuetoshow);
2108 if ($value ==
'private') {
2109 $valuetoshow =
yn($valuetoshow);
2110 } elseif ($value ==
'libelle_facture') {
2111 $langs->load(
"bills");
2112 $key = $langs->trans(
"PaymentCondition".strtoupper($obj->code));
2113 $valuetoshow = ($obj->code && $key !=
"PaymentCondition".strtoupper($obj->code) ? $key : $obj->$value);
2114 $valuetoshow = nl2br($valuetoshow);
2115 } elseif ($value ==
'label' && $tabname[$id] ==
'c_country') {
2116 $key = $langs->trans(
"Country".strtoupper($obj->code));
2117 $valuetoshow = ($obj->code && $key !=
"Country".strtoupper($obj->code) ? $key : $obj->$value);
2118 } elseif ($value ==
'label' && $tabname[$id] ==
'c_availability') {
2119 $langs->load(
"propal");
2120 $key = $langs->trans(
"AvailabilityType".strtoupper($obj->code));
2121 $valuetoshow = ($obj->code && $key !=
"AvailabilityType".strtoupper($obj->code) ? $key : $obj->$value);
2122 } elseif ($value ==
'libelle' && $tabname[$id] ==
'c_actioncomm') {
2123 $key = $langs->trans(
"Action".strtoupper($obj->code));
2124 $valuetoshow = ($obj->code && $key !=
"Action".strtoupper($obj->code) ? $key : $obj->$value);
2125 } elseif (!empty($obj->code_iso) && $value ==
'label' && $tabname[$id] ==
'c_currencies') {
2126 $key = $langs->trans(
"Currency".strtoupper($obj->code_iso));
2127 $valuetoshow = ($obj->code_iso && $key !=
"Currency".strtoupper($obj->code_iso) ? $key : $obj->$value);
2128 } elseif ($value ==
'libelle' && $tabname[$id] ==
'c_typent') {
2129 $key = $langs->trans(strtoupper($obj->code));
2130 $valuetoshow = ($key != strtoupper($obj->code) ? $key : $obj->$value);
2131 } elseif ($value ==
'libelle' && $tabname[$id] ==
'c_prospectlevel') {
2132 $key = $langs->trans(strtoupper($obj->code));
2133 $valuetoshow = ($key != strtoupper($obj->code) ? $key : $obj->$value);
2134 } elseif ($value ==
'label' && $tabname[$id] ==
'c_civility') {
2135 $key = $langs->trans(
"Civility".strtoupper($obj->code));
2136 $valuetoshow = ($obj->code && $key !=
"Civility".strtoupper($obj->code) ? $key : $obj->$value);
2137 } elseif ($value ==
'libelle' && $tabname[$id] ==
'c_type_contact') {
2138 $langs->load(
'agenda');
2139 $key = $langs->trans(
"TypeContact_".$obj->element.
"_".$obj->source.
"_".strtoupper($obj->code));
2140 $valuetoshow = ($obj->code && $key !=
"TypeContact_".$obj->element.
"_".$obj->source.
"_".strtoupper($obj->code) ? $key : $obj->$value);
2141 } elseif ($value ==
'libelle' && $tabname[$id] ==
'c_payment_term') {
2142 $langs->load(
"bills");
2143 $key = $langs->trans(
"PaymentConditionShort".strtoupper($obj->code));
2144 $valuetoshow = ($obj->code && $key !=
"PaymentConditionShort".strtoupper($obj->code) ? $key : $obj->$value);
2145 } elseif ($value ==
'libelle' && $tabname[$id] ==
'c_paiement') {
2146 $langs->load(
"bills");
2147 $key = $langs->trans(
"PaymentType".strtoupper($obj->code));
2148 $valuetoshow = ($obj->code && $key !=
"PaymentType".strtoupper($obj->code) ? $key : $obj->$value);
2149 } elseif ($value ==
'type' && $tabname[$id] ==
'c_paiement') {
2150 $payment_type_list = array(0=>$langs->trans(
'PaymentTypeCustomer'), 1=>$langs->trans(
'PaymentTypeSupplier'), 2=>$langs->trans(
'PaymentTypeBoth'));
2151 $valuetoshow = $payment_type_list[$valuetoshow];
2152 } elseif ($value ==
'label' && $tabname[$id] ==
'c_input_reason') {
2153 $key = $langs->trans(
"DemandReasonType".strtoupper($obj->code));
2154 $valuetoshow = ($obj->code && $key !=
"DemandReasonType".strtoupper($obj->code) ? $key : $obj->$value);
2155 } elseif ($value ==
'libelle' && $tabname[$id] ==
'c_input_method') {
2156 $langs->load(
"orders");
2157 $key = $langs->trans($obj->code);
2158 $valuetoshow = ($obj->code && $key != $obj->code) ? $key : $obj->$value;
2159 } elseif ($value ==
'libelle' && $tabname[$id] ==
'c_shipment_mode') {
2160 $langs->load(
"sendings");
2161 $key = $langs->trans(
"SendingMethod".strtoupper($obj->code));
2162 $valuetoshow = ($obj->code && $key !=
"SendingMethod".strtoupper($obj->code) ? $key : $obj->$value);
2163 } elseif ($value ==
'libelle' && $tabname[$id] ==
'c_paper_format') {
2164 $key = $langs->trans(
'PaperFormat'.strtoupper($obj->code));
2165 $valuetoshow = ($obj->code && $key !=
'PaperFormat'.strtoupper($obj->code) ? $key : $obj->$value);
2166 } elseif ($value ==
'label' && $tabname[$id] ==
'c_type_fees') {
2167 $langs->load(
'trips');
2168 $key = $langs->trans(strtoupper($obj->code));
2169 $valuetoshow = ($obj->code && $key != strtoupper($obj->code) ? $key : $obj->$value);
2170 } elseif ($value ==
'region_id' || $value ==
'country_id') {
2172 } elseif ($value ==
'unicode') {
2173 $valuetoshow = $langs->getCurrencySymbol($obj->code, 1);
2174 } elseif ($value ==
'label' && $tabname[
GETPOST(
"id",
'int')] ==
'c_units') {
2175 $langs->load(
"products");
2176 $valuetoshow = $langs->trans($obj->$value);
2177 } elseif ($value ==
'short_label' && $tabname[
GETPOST(
"id",
'int')] ==
'c_units') {
2178 $langs->load(
"products");
2179 $valuetoshow = $langs->trans($obj->$value);
2180 } elseif (($value ==
'unit') && ($tabname[$id] ==
'c_paper_format')) {
2181 $key = $langs->trans(
'SizeUnit'.strtolower($obj->unit));
2182 $valuetoshow = ($obj->code && $key !=
'SizeUnit'.strtolower($obj->unit) ? $key : $obj->$value);
2183 } elseif ($value ==
'localtax1' || $value ==
'localtax2') {
2185 } elseif ($value ==
'localtax1_type') {
2186 if ($obj->localtax1 != 0) {
2187 $valuetoshow = $localtax_typeList[$valuetoshow];
2192 } elseif ($value ==
'localtax2_type') {
2193 if ($obj->localtax2 != 0) {
2194 $valuetoshow = $localtax_typeList[$valuetoshow];
2199 } elseif ($value ==
'taux') {
2200 $valuetoshow =
price($valuetoshow, 0, $langs, 0, 0);
2202 } elseif (in_array($value, array(
'recuperableonly'))) {
2204 } elseif ($value ==
'accountancy_code' || $value ==
'accountancy_code_sell' || $value ==
'accountancy_code_buy') {
2206 require_once DOL_DOCUMENT_ROOT.
'/accountancy/class/accountingaccount.class.php';
2208 $tmpaccountingaccount->fetch(0, $valuetoshow, 1);
2209 $titletoshow = $langs->transnoentitiesnoconv(
"Pcgtype").
': '.$tmpaccountingaccount->pcg_type;
2212 } elseif ($value ==
'fk_tva') {
2213 foreach (
$form->cache_vatrates as $key => $Tab) {
2214 if (
$form->cache_vatrates[$key][
'rowid'] == $valuetoshow) {
2215 $valuetoshow =
$form->cache_vatrates[$key][
'label'];
2219 } elseif ($value ==
'fk_c_exp_tax_cat') {
2220 $tmpid = $valuetoshow;
2222 $valuetoshow = $langs->trans($valuetoshow ? $valuetoshow : $tmpid);
2223 } elseif ($tabname[$id] ==
'c_exp_tax_cat') {
2224 $valuetoshow = $langs->trans($valuetoshow);
2225 } elseif ($value ==
'label' && $tabname[$id] ==
'c_units') {
2226 $langs->load(
'other');
2227 $key = $langs->trans($obj->label);
2228 $valuetoshow = ($obj->label && $key != strtoupper($obj->label) ? $key : $obj->{$value});
2229 } elseif ($value ==
'code' && $id == 3) {
2230 $valuetoshow = $obj->state_code;
2231 } elseif ($value ==
'label' && $tabname[$id] ==
'c_product_nature') {
2232 $langs->load(
"products");
2233 $valuetoshow = $langs->trans($obj->{$value});
2234 } elseif ($fieldlist[$field] ==
'label' && $tabname[$id] ==
'c_productbatch_qcstatus') {
2235 $langs->load(
"productbatch");
2236 $valuetoshow = $langs->trans($obj->{$value});
2237 } elseif ($value ==
'block_if_negative') {
2238 $valuetoshow =
yn($obj->{$value});
2239 } elseif ($value ==
'icon') {
2240 $valuetoshow = $obj->{$value}.
" ".
img_picto(
"", $obj->{$value});
2241 } elseif ($value ==
'type_duration') {
2242 $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'));
2243 if (!empty($obj->{$value}) && array_key_exists($obj->{$value}, $TDurationTypes)) {
2244 $valuetoshow = $TDurationTypes[$obj->{$value}];
2247 $class .= ($class ?
' ' :
'').
'tddict';
2248 if ($value ==
'note' && $id == 10) {
2249 $class .=
' tdoverflowmax200';
2251 if ($value ==
'tracking') {
2252 $class .=
' tdoverflowauto';
2254 if (in_array($value, array(
'nbjour',
'decalage',
'pos',
'position',
'deposit_percent'))) {
2257 if (in_array($value, array(
'localtax1_type',
'localtax2_type'))) {
2258 $class .=
' nowraponall';
2260 if (in_array($value, array(
'use_default',
'fk_parent',
'sortorder'))) {
2261 $class .=
' center';
2263 if ($value ==
'public') {
2264 $class .=
' center';
2268 print
'<!-- '. $value .
' --><td class="'.$class.
'"'.($titletoshow ?
' title="'.dol_escape_htmltag($titletoshow).
'"' :
'').
'>'.$valuetoshow.
'</td>';
2276 print
'<td class="nowrap center">';
2279 print
'<a class="reposition" href="'.$url.
'action='.$acts[$obj->eec].
'_eec&token='.
newToken().
'">'.$actl[$obj->eec].
'</a>';
2281 print
'<span class="opacitymedium">'.$langs->trans(
"AlwaysActive").
'</span>';
2284 print
'<td class="nowrap center">';
2287 print
'<a class="reposition" href="'.$url.
'action='.$acts[$obj->favorite].
'_favorite&token='.
newToken().
'">'.$actl[$obj->favorite].
'</a>';
2289 print
'<span class="opacitymedium">'.$langs->trans(
"AlwaysActive").
'</span>';
2295 print
'<td class="nowrap center">';
2296 if ($canbedisabled) {
2297 print
'<a class="reposition" href="'.$url.
'action='.$acts[$obj->active].
'&token='.
newToken().
'">'.$actl[$obj->active].
'</a>';
2299 if (in_array($obj->code, array(
'AC_OTH',
'AC_OTH_AUTO'))) {
2300 print $langs->trans(
"AlwaysActive");
2301 } elseif (isset($obj->type) && in_array($obj->type, array(
'systemauto')) && empty($obj->active)) {
2302 print $langs->trans(
"Deprecated");
2303 } elseif (isset($obj->type) && in_array($obj->type, array(
'system')) && !empty($obj->active) && $obj->code !=
'AC_OTH') {
2304 print $langs->trans(
"UsedOnlyWithTypeOption");
2306 print
'<span class="opacitymedium">'.$langs->trans(
"AlwaysActive").
'</span>';
2313 print
'<td class="center maxwidthsearch">';
2315 if ($canbemodified) {
2316 print
'<a class="reposition marginleftonly paddingleft marginrightonly paddingright editfielda" href="'.$url.
'action=edit&token='.
newToken().
'">'.
img_edit().
'</a>';
2321 print
'<a class="reposition marginleftonly paddingleft marginrightonly paddingright" href="'.$url.
'action=delete&token='.
newToken().
'">'.
img_delete().
'</a>';
2332 print
'<tr><td colspan="'.$colspan.
'"><span class="opacitymedium">'.$langs->trans(
"NoRecordFound").
'</span></td></tr>';
2347 $lastlineisempty =
false;
2349 print
'<div class="div-table-responsive-no-min">';
2350 print
'<table class="noborder centpercent">';
2351 print
'<tr class="liste_titre">';
2352 print
'<td>'.$langs->trans(
"Dictionary").
'</td>';
2354 print
'<td class="hideonsmartphone"></td>';
2357 $showemptyline =
'';
2358 foreach ($taborder as $i) {
2359 if (isset($tabname[$i]) && empty($tabcond[$i])) {
2364 if ($showemptyline) {
2365 print
'<tr class="oddeven"><td></td><td></td><td class="hideonsmartphone"></td></tr>';
2370 $value = $tabname[$i];
2371 print
'<tr class="oddeven"><td class="minwidth200">';
2372 if (!empty($tabcond[$i])) {
2373 $tabnamenoprefix = preg_replace(
'/'.MAIN_DB_PREFIX.
'/',
'', $tabname[$i]);
2374 print
'<a href="'.$_SERVER[
"PHP_SELF"].
'?id='.$i.
'">';
2375 if (!empty($tabcomplete[$tabnamenoprefix][
'picto'])) {
2376 print
img_picto(
'', $tabcomplete[$tabnamenoprefix][
'picto'],
'class="pictofixedwidth paddingrightonly"');
2378 print $langs->trans($tablib[$i]);
2381 print $langs->trans($tablib[$i]);
2385 print
'<a class="editfielda" href="'.$_SERVER[
"PHP_SELF"].
'?id='.$i.
'">';
2389 print
'<td class="right hideonsmartphone">';
2390 print
$form->textwithpicto(
'', $langs->trans(
"Table").
': '.MAIN_DB_PREFIX.$tabname[$i]);
2393 $lastlineisempty =
false;
2395 if (!$lastlineisempty) {
2397 $lastlineisempty =
true;
2421 function fieldList($fieldlist, $obj =
'', $tabname =
'', $context =
'')
2423 global $conf, $langs, $db, $mysoc;
2426 global $elementList, $sourceList, $localtax_typeList;
2434 foreach ($fieldlist as $field => $value) {
2435 if ($value ==
'entity' && isset($obj->$value)) {
2436 $withentity = $obj->$value;
2440 if (in_array($value, array(
'code',
'libelle',
'type')) && $tabname ==
"c_actioncomm" && isset($obj->$value) && in_array($obj->type, array(
'system',
'systemauto'))) {
2441 $hidden = (!empty($obj->{$value}) ? $obj->{$value}:
'');
2443 print
'<input type="hidden" name="'. $value .
'" value="'.$hidden.
'">';
2444 print $langs->trans($hidden);
2446 } elseif ($value ==
'country') {
2447 if (in_array(
'region_id', $fieldlist)) {
2454 $selected = (!empty($obj->country_code) ? $obj->country_code : (!empty($obj->country) ? $obj->country :
''));
2456 $selected =
GETPOST(
'countryidforinsert');
2458 print
$form->select_country($selected, $value,
'', 28,
'minwidth100 maxwidth150 maxwidthonsmartphone');
2460 } elseif ($value ==
'country_id') {
2461 if (!in_array(
'country', $fieldlist)) {
2462 $country_id = (!empty($obj->{$value}) ? $obj->{$value} : 0);
2463 print
'<td class="tdoverflowmax100">';
2464 print
'<input type="hidden" name="'. $value .
'" value="'.$country_id.
'">';
2467 } elseif ($value ==
'region') {
2469 $formcompany->select_region($region_id,
'region');
2471 } elseif ($value ==
'region_id') {
2472 $region_id = (!empty($obj->{$value}) ? $obj->{$value}:0);
2474 print
'<input type="hidden" name="'. $value .
'" value="'.$region_id.
'">';
2476 } elseif ($value ==
'lang') {
2478 print $formadmin->select_language($conf->global->MAIN_LANG_DEFAULT,
'lang');
2480 } elseif (in_array($value, array(
'element',
'source'))) {
2481 $tmparray = array();
2482 if ($value ==
'element') {
2483 $tmparray = $elementList;
2485 $tmparray = $sourceList;
2488 print
$form->selectarray($value, $tmparray, (!empty($obj->{$value}) ? $obj->{$value}:
''), 0, 0, 0,
'', 0, 0, 0,
'',
'maxwidth250');
2490 } elseif (in_array($value, array(
'public',
'use_default'))) {
2492 print
'<td class="center">';
2493 print
$form->selectyesno($value, (!empty($obj->{$value}) ? $obj->{$value}:
''), 1);
2495 } elseif ($value ==
'private') {
2498 print
$form->selectyesno(
"private", (!empty($obj->{$value}) ? $obj->{$value}:
''));
2500 } elseif ($value ==
'type' && $tabname ==
"c_actioncomm") {
2501 $type = (!empty($obj->type) ? $obj->type :
'user');
2503 print $type.
'<input type="hidden" name="type" value="'.$type.
'">';
2505 } elseif ($value ==
'type' && $tabname ==
'c_paiement') {
2507 $select_list = array(0=>$langs->trans(
'PaymentTypeCustomer'), 1=>$langs->trans(
'PaymentTypeSupplier'), 2=>$langs->trans(
'PaymentTypeBoth'));
2508 print
$form->selectarray($value, $select_list, (!empty($obj->{$value}) ? $obj->{$value}:
'2'));
2510 } elseif ($value ==
'recuperableonly' || $value ==
'type_cdr' || $value ==
'deductible' || $value ==
'category_type') {
2511 if ($value ==
'type_cdr') {
2512 print
'<td class="center">';
2516 if ($value ==
'type_cdr') {
2517 print
$form->selectarray($value, array(0=>$langs->trans(
'None'), 1=>$langs->trans(
'AtEndOfMonth'), 2=>$langs->trans(
'CurrentNext')), (!empty($obj->{$value}) ? $obj->{$value}:
''));
2519 print
$form->selectyesno($value, (!empty($obj->{$value}) ? $obj->{$value}:
''), 1);
2522 } elseif (in_array($value, array(
'nbjour',
'decalage',
'taux',
'localtax1',
'localtax2'))) {
2524 if (in_array($value, array(
'taux',
'localtax1',
'localtax2'))) {
2527 print
'<td class="'.$class.
'">';
2528 print
'<input type="text" class="flat" value="'.(isset($obj->{$value}) ? $obj->{$value} :
'').
'" size="3" name="'. $value .
'">';
2530 } elseif (in_array($value, array(
'libelle_facture'))) {
2535 if ($tabname ==
'c_payment_term') {
2536 $langs->load(
"bills");
2537 if (isset($obj->code) && !empty($obj->code)) {
2538 $transkey =
"PaymentCondition" . strtoupper($obj->code);
2539 if ($langs->trans($transkey) != $transkey) {
2541 print
$form->textwithpicto($langs->trans($transkey), $langs->trans(
"GoIntoTranslationMenuToChangeThis"));
2546 print
'<textarea cols="30" rows="'.ROWS_2.
'" class="flat" name="'. $value .
'">'.(!empty($obj->{$value}) ? $obj->{$value}:
'').
'</textarea>';
2548 print
'<input type="hidden" name="'. $value .
'" value="'.$transkey.
'">';
2551 } elseif ($value ==
'price' || preg_match(
'/^amount/i', $value)) {
2552 print
'<td><input type="text" class="flat minwidth75" value="'.price((!empty($obj->{$value}) ? $obj->{$value}:
'')).
'" name="'. $value .
'"></td>';
2553 } elseif ($value ==
'code' && isset($obj->{$value})) {
2554 print
'<td><input type="text" class="flat minwidth75 maxwidth100" value="'.(!empty($obj->{$value}) ? $obj->{$value}:
'').
'" name="'. $value .
'"></td>';
2555 } elseif ($value ==
'unit') {
2558 'mm' => $langs->trans(
'SizeUnitmm'),
2559 'cm' => $langs->trans(
'SizeUnitcm'),
2560 'point' => $langs->trans(
'SizeUnitpoint'),
2561 'inch' => $langs->trans(
'SizeUnitinch')
2563 print
$form->selectarray(
'unit', $units, (!empty($obj->{$value}) ? $obj->{$value}:
''), 0, 0, 0);
2565 } elseif ($value ==
'localtax1_type' || $value ==
'localtax2_type') {
2567 print
'<td class="center">';
2568 print
$form->selectarray($value, $localtax_typeList, (!empty($obj->{$value}) ? $obj->{$value}:
''));
2570 } elseif ($value ==
'accountancy_code' || $value ==
'accountancy_code_sell' || $value ==
'accountancy_code_buy') {
2573 $fieldname = $value;
2574 $accountancy_account = (!empty($obj->$fieldname) ? $obj->$fieldname : 0);
2575 print $formaccounting->select_account($accountancy_account,
'.'. $value, 1,
'', 1, 1,
'maxwidth200 maxwidthonsmartphone');
2577 $fieldname = $value;
2578 print
'<input type="text" size="10" class="flat" value="'.(isset($obj->$fieldname) ? $obj->$fieldname :
'').
'" name="'. $value .
'">';
2581 } elseif ($value ==
'fk_tva') {
2583 print
$form->load_tva(
'fk_tva', $obj->taux, $mysoc,
new Societe($db), 0, 0,
'',
false, -1);
2585 } elseif ($value ==
'fk_c_exp_tax_cat') {
2587 print
$form->selectExpenseCategories($obj->fk_c_exp_tax_cat);
2589 } elseif ($value ==
'fk_range') {
2591 print
$form->selectExpenseRanges($obj->fk_range);
2593 } elseif ($value ==
'block_if_negative') {
2595 print
$form->selectyesno(
"block_if_negative", (empty($obj->block_if_negative) ?
'' : $obj->block_if_negative), 1);
2597 } elseif ($value ==
'type_duration') {
2599 print
$form->selectTypeDuration(
'', (empty($obj->type_duration) ?
'' : $obj->type_duration), array(
'i',
'h'));
2602 $fieldValue = isset($obj->{$value}) ? $obj->{$value}:
'';
2603 $classtd =
''; $class =
'';
2605 if ($value ==
'sortorder') {
2606 $fieldlist[$field] =
'position';
2609 if ($fieldlist[$field] ==
'code') {
2610 $class =
'maxwidth100';
2612 if (in_array($fieldlist[$field], array(
'deposit_percent'))) {
2613 $classtd =
'right'; $class =
'maxwidth50 right';
2615 if (in_array($fieldlist[$field], array(
'pos',
'position'))) {
2616 $classtd =
'right'; $class =
'maxwidth50 right';
2618 if (in_array($fieldlist[$field], array(
'dayrule',
'day',
'month',
'year',
'use_default',
'affect',
'delay',
'public',
'sortorder',
'sens',
'category_type',
'fk_parent'))) {
2619 $class =
'maxwidth50 center';
2621 if (in_array($fieldlist[$field], array(
'use_default',
'public',
'fk_parent'))) {
2622 $classtd =
'center';
2624 if (in_array($fieldlist[$field], array(
'libelle',
'label',
'tracking'))) {
2625 $class =
'quatrevingtpercent';
2628 if ($fieldlist[$field] ==
'fk_parent') {
2629 if (empty($fieldValue)) {
2636 if (in_array($fieldlist[$field], array(
'libelle',
'label'))) {
2638 case 'c_accounting_category':
2640 case 'c_email_senderprofile':
2641 case 'c_forme_juridique':
2642 case 'c_holiday_types':
2643 case 'c_payment_term':
2644 case 'c_transport_mode':
2645 $maxlength =
' maxlength="255"';
2647 case 'c_email_templates':
2648 $maxlength =
' maxlength="180"';
2650 case 'c_socialnetworks':
2651 $maxlength =
' maxlength="150"';
2654 $maxlength =
' maxlength="128"';
2658 print
'<td class="'.$classtd.
'">';
2661 if (in_array($fieldlist[$field], array(
'label',
'libelle'))) {
2663 if ($tabname ==
'c_civility' && !empty($obj->code)) {
2664 $transkey =
"Civility".strtoupper($obj->code);
2666 if ($tabname ==
'c_payment_term' && !empty($obj->code)) {
2667 $langs->load(
"bills");
2668 $transkey =
"PaymentConditionShort".strtoupper($obj->code);
2670 if ($transkey && $langs->trans($transkey) != $transkey) {
2672 print
$form->textwithpicto($langs->trans($transkey), $langs->trans(
"GoIntoTranslationMenuToChangeThis"));
2676 print
'<input type="text" class="flat'.($class ?
' '.$class :
'').
'"'.($maxlength ?
' '.$maxlength :
'').
' value="'.
dol_escape_htmltag($fieldValue).
'" name="'.$fieldlist[$field].
'">';
2678 print
'<input type="hidden" name="'.$fieldlist[$field].
'" value="'.$transkey.
'">';