dolibarr 24.0.3
list.php
Go to the documentation of this file.
1<?php
2/* Copyright (C) 2002-2006 Rodolphe Quiedeville <rodolphe@quiedeville.org>
3 * Copyright (C) 2004 Eric Seigne <eric.seigne@ryxeo.com>
4 * Copyright (C) 2004-2016 Laurent Destailleur <eldy@users.sourceforge.net>
5 * Copyright (C) 2005 Marc Barilley / Ocebo <marc@ocebo.com>
6 * Copyright (C) 2005-2015 Regis Houssin <regis.houssin@inodbox.com>
7 * Copyright (C) 2006 Andre Cianfarani <acianfa@free.fr>
8 * Copyright (C) 2010-2020 Juanjo Menent <jmenent@2byte.es>
9 * Copyright (C) 2012 Christophe Battarel <christophe.battarel@altairis.fr>
10 * Copyright (C) 2013 Florian Henry <florian.henry@open-concept.pro>
11 * Copyright (C) 2013 Cédric Salvador <csalvador@gpcsolutions.fr>
12 * Copyright (C) 2015 Jean-François Ferry <jfefe@aternatik.fr>
13 * Copyright (C) 2015-2022 Ferran Marcet <fmarcet@2byte.es>
14 * Copyright (C) 2017 Josep Lluís Amador <joseplluis@lliuretic.cat>
15 * Copyright (C) 2018 Charlene Benke <charlie@patas-monkey.com>
16 * Copyright (C) 2019-2026 Alexandre Spangaro <alexandre@inovea-conseil.com>
17 * Copyright (C) 2021-2024 Anthony Berton <anthony.berton@bb2a.fr>
18 * Copyright (C) 2023 Nick Fragoulis
19 * Copyright (C) 2023 Joachim Kueter <git-jk@bloxera.com>
20 * Copyright (C) 2024-2026 MDW <mdeweerd@users.noreply.github.com>
21 * Copyright (C) 2024-2026 Frédéric France <frederic.france@free.fr>
22 * Copyright (C) 2024 Solution Libre SAS <contact@solution-libre.fr>
23 * Copyright (C) 2024 William Mead <william.mead@manchenumerique.fr>
24 *
25 * This program is free software; you can redistribute it and/or modify
26 * it under the terms of the GNU General Public License as published by
27 * the Free Software Foundation; either version 3 of the License, or
28 * (at your option) any later version.
29 *
30 * This program is distributed in the hope that it will be useful,
31 * but WITHOUT ANY WARRANTY; without even the implied warranty of
32 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
33 * GNU General Public License for more details.
34 *
35 * You should have received a copy of the GNU General Public License
36 * along with this program. If not, see <https://www.gnu.org/licenses/>.
37 */
38
45// Load Dolibarr environment
46require '../../main.inc.php';
56require_once DOL_DOCUMENT_ROOT.'/core/class/discount.class.php';
57require_once DOL_DOCUMENT_ROOT.'/core/class/html.formfile.class.php';
58require_once DOL_DOCUMENT_ROOT.'/core/class/html.formother.class.php';
59require_once DOL_DOCUMENT_ROOT.'/core/class/html.formcompany.class.php';
60require_once DOL_DOCUMENT_ROOT.'/core/class/html.formmargin.class.php';
61require_once DOL_DOCUMENT_ROOT.'/core/lib/functions2.lib.php';
62require_once DOL_DOCUMENT_ROOT.'/core/lib/invoice.lib.php';
63require_once DOL_DOCUMENT_ROOT.'/core/lib/date.lib.php';
64require_once DOL_DOCUMENT_ROOT.'/core/lib/company.lib.php';
65require_once DOL_DOCUMENT_ROOT.'/core/modules/facture/modules_facture.php';
66require_once DOL_DOCUMENT_ROOT.'/compta/bank/class/account.class.php';
67require_once DOL_DOCUMENT_ROOT.'/compta/facture/class/facture.class.php';
68require_once DOL_DOCUMENT_ROOT.'/compta/paiement/class/paiement.class.php';
69require_once DOL_DOCUMENT_ROOT.'/compta/facture/class/facture-rec.class.php';
70require_once DOL_DOCUMENT_ROOT.'/projet/class/project.class.php';
71if (isModEnabled('order')) {
72 require_once DOL_DOCUMENT_ROOT.'/commande/class/commande.class.php';
73}
74if (isModEnabled('category')) {
75 require_once DOL_DOCUMENT_ROOT.'/categories/class/categorie.class.php';
76 require_once DOL_DOCUMENT_ROOT.'/core/class/html.formcategory.class.php';
77}
78
79// Load translation files required by the page
80$langs->loadLangs(array('banks', 'bills', 'companies', 'products', 'categories', 'cashdesk'));
81
82$search_all = trim(GETPOST('search_all', 'alphanohtml'));
83
84// Get Parameters
85$action = GETPOST('action', 'aZ09');
86$massaction = GETPOST('massaction', 'alpha');
87$show_files = GETPOSTINT('show_files');
88$confirm = GETPOST('confirm', 'alpha');
89$toselect = GETPOST('toselect', 'array:int');
90$optioncss = GETPOST('optioncss', 'alpha');
91$contextpage = GETPOST('contextpage', 'aZ') ? GETPOST('contextpage', 'aZ') : 'invoicelist';
92$mode = GETPOST('mode', 'aZ'); // The output mode ('list', 'kanban', 'hierarchy', 'calendar', ...)
93
94if ($contextpage == 'poslist') {
95 $optioncss = 'print';
96}
97
98$id = (GETPOSTINT('id') ? GETPOSTINT('id') : GETPOSTINT('facid')); // For backward compatibility
99$ref = GETPOST('ref', 'alpha');
100$socid = GETPOSTINT('socid');
101
102$userid = GETPOSTINT('userid');
103$search_ref = GETPOST('sf_ref') ? GETPOST('sf_ref', 'alpha') : GETPOST('search_ref', 'alpha');
104$search_refcustomer = GETPOST('search_refcustomer', 'alpha');
105$search_type = GETPOST('search_type', 'intcomma');
106$search_subtype = GETPOST('search_subtype', 'intcomma');
107$search_project_ref = GETPOST('search_project_ref', 'alpha');
108$search_project = GETPOST('search_project', 'alpha');
109$search_company = GETPOST('search_company', 'alpha');
110$search_company_alias = GETPOST('search_company_alias', 'alpha');
111$search_parent_name = trim(GETPOST('search_parent_name', 'alphanohtml'));
112$search_montant_ht = GETPOST('search_montant_ht', 'alpha');
113$search_montant_vat = GETPOST('search_montant_vat', 'alpha');
114$search_montant_localtax1 = GETPOST('search_montant_localtax1', 'alpha');
115$search_montant_localtax2 = GETPOST('search_montant_localtax2', 'alpha');
116$search_montant_ttc = GETPOST('search_montant_ttc', 'alpha');
117$search_login = GETPOST('search_login', 'alpha');
118$search_multicurrency_code = GETPOST('search_multicurrency_code', 'alpha');
119$search_multicurrency_tx = GETPOST('search_multicurrency_tx', 'alpha');
120$search_multicurrency_montant_ht = GETPOST('search_multicurrency_montant_ht', 'alpha');
121$search_multicurrency_montant_vat = GETPOST('search_multicurrency_montant_vat', 'alpha');
122$search_multicurrency_montant_ttc = GETPOST('search_multicurrency_montant_ttc', 'alpha');
123$search_dispute_status = GETPOST('search_dispute_status', 'intcomma');
124$search_status = GETPOST('search_status', 'array:intcomma');
125// if (empty($search_status) && GETPOSTISSET('search_status')) {
126// // The parameter exists in the URL but was not recognized as an array.
127// $search_status = GETPOST('search_status', 'intcomma');
128// if ($search_status !== '' && $search_status !== '-1') {
129// $search_status = array($search_status);
130// } else {
131// $search_status = '';
132// }
133// } elseif (is_array($search_status) && count($search_status) == 0) {
134// $search_status = '';
135// }
136$search_paymentmode = GETPOST('search_paymentmode', 'intcomma');
137$search_paymentterms = GETPOST('search_paymentterms', 'intcomma');
138$search_bankaccount = GETPOST('search_bankaccount', 'intcomma');
139$search_fk_input_reason = GETPOSTINT('search_fk_input_reason');
140$search_module_source = GETPOST('search_module_source', 'alpha');
141$search_pos_source = GETPOST('search_pos_source', 'alpha');
142$search_town = GETPOST('search_town', 'alpha');
143$search_zip = GETPOST('search_zip', 'alpha');
144$search_state = GETPOST("search_state");
145$search_country = GETPOST("search_country", 'aZ09');
146$search_customer_code = GETPOST("search_customer_code", 'alphanohtml');
147$search_type_thirdparty = GETPOST("search_type_thirdparty", 'intcomma');
148$search_user = GETPOST('search_user', 'intcomma');
149$search_sale = GETPOST('search_sale', 'intcomma');
150
151$search_date_startday = GETPOSTINT('search_date_startday');
152$search_date_startmonth = GETPOSTINT('search_date_startmonth');
153$search_date_startyear = GETPOSTINT('search_date_startyear');
154$search_date_endday = GETPOSTINT('search_date_endday');
155$search_date_endmonth = GETPOSTINT('search_date_endmonth');
156$search_date_endyear = GETPOSTINT('search_date_endyear');
157$search_date_start = GETPOSTDATE('search_date_start', 'getpost'); // Use tzserver because date invoice is a date without hour
158$search_date_end = GETPOSTDATE('search_date_end', 'getpostend');
159
160$search_date_valid_startday = GETPOSTINT('search_date_valid_startday');
161$search_date_valid_startmonth = GETPOSTINT('search_date_valid_startmonth');
162$search_date_valid_startyear = GETPOSTINT('search_date_valid_startyear');
163$search_date_valid_endday = GETPOSTINT('search_date_valid_endday');
164$search_date_valid_endmonth = GETPOSTINT('search_date_valid_endmonth');
165$search_date_valid_endyear = GETPOSTINT('search_date_valid_endyear');
166$search_date_valid_start = GETPOSTDATE('search_date_valid_start', 'getpost');
167$search_date_valid_end = GETPOSTDATE('search_date_valid_end', 'getpostend');
168$search_note_private = GETPOST('search_note_private', 'alpha');
169$search_note_public = GETPOST('search_note_public', 'alpha');
170
171$search_datelimit_startday = GETPOSTINT('search_datelimit_startday');
172$search_datelimit_startmonth = GETPOSTINT('search_datelimit_startmonth');
173$search_datelimit_startyear = GETPOSTINT('search_datelimit_startyear');
174$search_datelimit_endday = GETPOSTINT('search_datelimit_endday');
175$search_datelimit_endmonth = GETPOSTINT('search_datelimit_endmonth');
176$search_datelimit_endyear = GETPOSTINT('search_datelimit_endyear');
177$search_datelimit_start = GETPOSTDATE('search_datelimit_start', 'getpost'); // Use tzserver because date invoice is a date without hour
178$search_datelimit_end = GETPOSTDATE('search_datelimit_end', 'getpostend');
179
180
181$search_datec_start = GETPOSTDATE('search_datec_start', 'getpost', 'tzuserrel');
182$search_datec_end = GETPOSTDATE('search_datec_end', 'getpostend', 'tzuserrel');
183$search_datem_start = GETPOSTDATE('search_datem_start', 'getpost', 'tzuserrel');
184$search_datem_end = GETPOSTDATE('search_datem_end', 'getpostend', 'tzuserrel');
185
186$search_categ_cus = GETPOST("search_categ_cus", 'intcomma');
187$searchCategoryInvoiceOperator = 0;
188if (GETPOSTISSET('formfilteraction')) {
189 $searchCategoryInvoiceOperator = GETPOSTINT('search_category_invoice_operator');
190} elseif (getDolGlobalString('MAIN_SEARCH_CAT_OR_BY_DEFAULT')) {
191 $searchCategoryInvoiceOperator = getDolGlobalString('MAIN_SEARCH_CAT_OR_BY_DEFAULT');
192}
193$searchCategoryInvoiceList = GETPOST('search_category_invoice_list', 'array:int');
194// to dump type seen by phpstan during analyse
195// \PHPStan\dumpType($searchCategoryInvoiceList);
196$search_product_category = GETPOST('search_product_category', 'intcomma');
197$search_fac_rec_source_title = GETPOST("search_fac_rec_source_title", 'alpha');
198$search_fk_fac_rec_source = GETPOST('search_fk_fac_rec_source', 'int');
199$search_import_key = trim(GETPOST("search_import_key", "alpha"));
200
201$search_option = GETPOST('search_option');
202if ($search_option == 'late') {
203 $search_status = array('1');
204}
205
206$limit = GETPOSTINT('limit') ? GETPOSTINT('limit') : $conf->liste_limit;
207$sortfield = GETPOST('sortfield', 'aZ09comma');
208$sortorder = GETPOST('sortorder', 'aZ09comma');
209$page = GETPOSTISSET('pageplusone') ? (GETPOSTINT('pageplusone') - 1) : GETPOSTINT("page");
210if (empty($page) || $page < 0 || GETPOST('button_search', 'alpha') || GETPOST('button_removefilter', 'alpha')) {
211 // If $page is not defined, or '' or -1 or if we click on clear filters
212 $page = 0;
213}
214
215if ($contextpage == 'poslist' && !GETPOSTISSET('limit')) {
216 $limit = 5;
217}
218
219$offset = $limit * $page;
220if (!$sortorder && getDolGlobalString('INVOICE_DEFAULT_UNPAYED_SORT_ORDER') && $search_status == '1') {
221 $sortorder = getDolGlobalString('INVOICE_DEFAULT_UNPAYED_SORT_ORDER');
222}
223if (!$sortorder) {
224 $sortorder = 'DESC';
225}
226if (!$sortfield) {
227 $sortfield = 'f.datef,f.rowid';
228}
229$pageprev = $page - 1;
230$pagenext = $page + 1;
231
232$diroutputmassaction = isModEnabled('invoice') ? $conf->invoice->dir_output.'/temp/massgeneration/'.$user->id : '';
233
234$now = dol_now();
235$error = 0;
236$sql = '';
237
238// Initialize a technical object to manage hooks of page. Note that conf->hooks_modules contains an array of hook context
239$object = new Facture($db);
240$hookmanager->initHooks(array($contextpage));
241
242// Fetch optionals attributes and labels
243$extrafields->fetch_name_optionals_label($object->table_element);
244
245$search_array_options = $extrafields->getOptionalsFromPost($object->table_element, '', 'search_') ?: [];
246
247// List of fields to search into when doing a "search in all"
248$fieldstosearchall = array(
249 'f.ref' => 'Ref',
250 'f.ref_client' => 'RefCustomer',
251 'f.note_public' => 'NotePublic',
252 's.nom' => "ThirdParty",
253 's.code_client' => "CustomerCodeShort",
254 's.name_alias' => "AliasNameShort",
255 's.zip' => "Zip",
256 's.town' => "Town",
257 'pd.description' => 'ProductDescription',
258);
259if (empty($user->socid)) {
260 $fieldstosearchall["f.note_private"] = "NotePrivate";
261}
262
263// Show POS fields if cashdesk or takepos module enabled or if global configuration to show POS fields on order list is enabled
264$showpos = (isModEnabled('cashdesk') || isModEnabled('takepos') || getDolGlobalInt('INVOICE_SHOW_POS')) ? '1' : '0';
265
266$checkedtypetiers = '0';
267$arrayfields = array(
268 'f.ref' => array('label' => "Ref", 'checked' => '1', 'position' => 5),
269 'f.ref_client' => array('label' => "RefCustomer", 'checked' => '-1', 'position' => 10),
270 'f.type' => array('label' => "Type", 'checked' => '0', 'position' => 15),
271 'f.subtype' => array('label' => "InvoiceSubtype", 'checked' => '0', 'position' => 17),
272 'f.datef' => array('label' => "DateInvoice", 'checked' => '1', 'position' => 20),
273 'f.date_valid' => array('label' => "DateValidation", 'checked' => '0', 'position' => 22),
274 'f.date_lim_reglement' => array('label' => "DateDue", 'checked' => '1', 'position' => 25),
275 'f.date_closing' => array('label' => "DateClosing", 'checked' => '0', 'position' => 30),
276 'p.ref' => array('label' => "ProjectRef", 'langfile' => 'projects', 'checked' => '1', 'enabled' => (isModEnabled('project') ? '1' : '0'), 'position' => 40),
277 'p.title' => array('label' => "ProjectLabel", 'langfile' => 'projects', 'checked' => '0', 'enabled' => (isModEnabled('project') ? '1' : '0'), 'position' => 41),
278 's.nom' => array('label' => "ThirdParty", 'checked' => '1', 'position' => 50),
279 's.name_alias' => array('label' => "AliasNameShort", 'checked' => '-1', 'position' => 51),
280 's.code_client' => array('label' => "CustomerCodeShort", 'checked' => '-1', 'position' => 52),
281 's2.nom' => array('label' => 'ParentCompany', 'position' => 32, 'checked' => '0'),
282 's.town' => array('label' => "Town", 'checked' => '-1', 'position' => 55),
283 's.zip' => array('label' => "Zip", 'checked' => '-1', 'position' => 60),
284 'state.nom' => array('label' => "StateShort", 'checked' => '0', 'position' => 65),
285 'country.code_iso' => array('label' => "Country", 'checked' => '0', 'position' => 70),
286 'typent.code' => array('label' => "ThirdPartyType", 'checked' => $checkedtypetiers, 'position' => 75),
287 'f.fk_mode_reglement' => array('label' => "PaymentMode", 'checked' => '1', 'position' => 80),
288 'f.fk_cond_reglement' => array('label' => "PaymentConditionsShort", 'checked' => '0', 'position' => 85),
289 'ba.label' => array('label' => "DefaultBankAccount", 'langfile' => 'banks', 'checked' => '0', 'enabled' => (isModEnabled('bank') ? '1' : '0'), 'position' => 192),
290 'f.fk_input_reason' => array('label' => "Source", 'checked' => 0, 'enabled' => 1, 'position' => 88),
291 'f.module_source' => array('label' => "POSModule", 'langfile' => 'cashdesk', 'checked' => ($contextpage == 'poslist' ? '1' : '0'), 'enabled' => $showpos, 'position' => 90),
292 'f.pos_source' => array('label' => "POSTerminal", 'langfile' => 'cashdesk', 'checked' => ($contextpage == 'poslist' ? '1' : '0'), 'enabled' => $showpos, 'position' => 91),
293 'f.total_ht' => array('label' => "AmountHT", 'checked' => '1', 'position' => 95),
294 'f.total_tva' => array('label' => "AmountVAT", 'checked' => '0', 'position' => 100),
295 'f.total_localtax1' => array('label' => $langs->transcountry("AmountLT1", $mysoc->country_code), 'checked' => '0', 'enabled' => ($mysoc->localtax1_assuj == "1"), 'position' => 110),
296 'f.total_localtax2' => array('label' => $langs->transcountry("AmountLT2", $mysoc->country_code), 'checked' => '0', 'enabled' => ($mysoc->localtax2_assuj == "1"), 'position' => 120),
297 'f.total_ttc' => array('label' => "AmountTTC", 'checked' => '0', 'position' => 130),
298 'dynamount_payed' => array('label' => "AlreadyPaid", 'checked' => '0', 'position' => 140),
299 'rtp' => array('label' => "RemainderToPay", 'checked' => '0', 'position' => 150), // Not enabled by default because slow
300 'f.multicurrency_code' => array('label' => 'Currency', 'checked' => '0', 'enabled' => (!isModEnabled('multicurrency') ? '0' : '1'), 'position' => 280),
301 'f.multicurrency_tx' => array('label' => 'CurrencyRate', 'checked' => '0', 'enabled' => (!isModEnabled('multicurrency') ? '0' : '1'), 'position' => 285),
302 'f.multicurrency_total_ht' => array('label' => 'MulticurrencyAmountHT', 'checked' => '0', 'enabled' => (!isModEnabled('multicurrency') ? '0' : '1'), 'position' => 290),
303 'f.multicurrency_total_vat' => array('label' => 'MulticurrencyAmountVAT', 'checked' => '0', 'enabled' => (!isModEnabled('multicurrency') ? '0' : '1'), 'position' => 291),
304 'f.multicurrency_total_ttc' => array('label' => 'MulticurrencyAmountTTC', 'checked' => '0', 'enabled' => (!isModEnabled('multicurrency') ? '0' : '1'), 'position' => 292),
305 'multicurrency_dynamount_payed' => array('label' => 'MulticurrencyAlreadyPaid', 'checked' => '0', 'enabled' => (!isModEnabled('multicurrency') ? '0' : '1'), 'position' => 295),
306 'multicurrency_rtp' => array('label' => 'MulticurrencyRemainderToPay', 'checked' => '0', 'enabled' => (!isModEnabled('multicurrency') ? '0' : '1'), 'position' => 296), // Not enabled by default because slow
307 'total_pa' => array('label' => ((getDolGlobalString('MARGIN_TYPE') == '1') ? 'BuyingPrice' : 'CostPrice'), 'checked' => '0', 'position' => 300, 'enabled' => (!isModEnabled('margin') || !$user->hasRight('margins', 'liretous') ? '0' : '1')),
308 'total_margin' => array('label' => 'Margin', 'langfile' => 'margins', 'checked' => '0', 'position' => 301, 'enabled' => (!isModEnabled('margin') || !$user->hasRight('margins', 'liretous') ? '0' : '1')),
309 'total_margin_rate' => array('label' => 'MarginRate', 'langfile' => 'margins', 'checked' => '0', 'position' => 302, 'enabled' => (!isModEnabled('margin') || !$user->hasRight('margins', 'liretous') || !getDolGlobalString('DISPLAY_MARGIN_RATES') ? '0' : '1')),
310 'total_mark_rate' => array('label' => 'MarkRate', 'langfile' => 'margins', 'checked' => '0', 'position' => 303, 'enabled' => (!isModEnabled('margin') || !$user->hasRight('margins', 'liretous') || !getDolGlobalString('DISPLAY_MARK_RATES') ? '0' : '1')),
311 'f.datec' => array('label' => "DateCreation", 'checked' => '0', 'position' => 500),
312 'f.tms' => array('type' => 'timestamp', 'label' => 'DateModificationShort', 'enabled' => '1', 'visible' => -1, 'notnull' => 1, 'position' => 502),
313 'u.login' => array('label' => "UserAuthor", 'checked' => '0', 'visible' => -1, 'position' => 504),
314 'sale_representative' => array('label' => "SaleRepresentativesOfThirdParty", 'checked' => '0', 'position' => 506),
315 //'f.fk_user_author' =>array('type'=>'integer:User:user/class/user.class.php', 'label'=>'UserAuthor', 'enabled'=>1, 'visible'=>-1, 'position'=>506),
316 //'f.fk_user_modif' =>array('type'=>'integer:User:user/class/user.class.php', 'label'=>'UserModif', 'enabled'=>1, 'visible'=>-1, 'notnull'=>-1, 'position'=>508),
317 //'f.fk_user_valid' =>array('type'=>'integer:User:user/class/user.class.php', 'label'=>'UserValidation', 'enabled'=>1, 'visible'=>-1, 'position'=>510),
318 //'f.fk_user_closing' =>array('type'=>'integer:User:user/class/user.class.php', 'label'=>'UserClosing', 'enabled'=>1, 'visible'=>-1, 'position'=>512),
319 'f.note_public' => array('label' => 'NotePublic', 'checked' => '0', 'position' => 520, 'enabled' => (!getDolGlobalInt('MAIN_LIST_HIDE_PUBLIC_NOTES'))),
320 'f.note_private' => array('label' => 'NotePrivate', 'checked' => '0', 'position' => 521, 'enabled' => (!getDolGlobalInt('MAIN_LIST_HIDE_PRIVATE_NOTES'))),
321 'f.fk_fac_rec_source' => array('label' => 'GeneratedFromTemplate', 'checked' => '0', 'position' => 530, 'enabled' => '1'),
322 'f.import_key' => array('type' => 'varchar(14)', 'label' => 'ImportId', 'enabled' => '1', 'visible' => -2, 'position' => 990),
323 'f.dispute_status' => array('label' => "DisputeStatus", 'checked' => '-1', 'position' => 999),
324 'f.fk_statut' => array('label' => "Status", 'checked' => '1', 'position' => 1000),
325);
326if ($user->socid) {
327 unset($arrayfields['f.note_private']);
328}
329if (getDolGlobalString("INVOICE_USE_SITUATION") && getDolGlobalString('INVOICE_USE_RETAINED_WARRANTY')) {
330 $arrayfields['f.retained_warranty'] = array('label' => $langs->trans("RetainedWarranty"), 'checked' => '0', 'position' => 86);
331}
332
333$subtypearray = $object->getArrayOfInvoiceSubtypes(0);
334if (empty($subtypearray)) {
335 unset($arrayfields['f.subtype']);
336}
337
338// Overwrite $arrayfields from columns into ->fields (transition before removal of $arrayoffields)
339foreach ($object->fields as $key => $val) {
340 // If $val['visible']==0, then we never show the field
341
342 if (!empty($val['visible'])) {
343 $visible = (int) dol_eval((string) $val['visible'], 1, 1, '1');
344 $newkey = '';
345 if (array_key_exists($key, $arrayfields)) {
346 $newkey = $key;
347 } elseif (array_key_exists('f.'.$key, $arrayfields)) {
348 $newkey = 'f.'.$key;
349 } elseif (array_key_exists('s.'.$key, $arrayfields)) {
350 $newkey = 's.'.$key;
351 }
352 if ($newkey) {
353 $arrayfields[$newkey] = array(
354 'label' => $val['label'],
355 'checked' => (($visible < 0) ? '0' : '1'),
356 'enabled' => (string) (int) (abs($visible) != 3 && (bool) dol_eval((string) $val['enabled'], 1)),
357 'position' => $val['position'],
358 'help' => empty($val['help']) ? '' : $val['help'],
359 );
360 }
361 }
362}
363// Extra fields
364include DOL_DOCUMENT_ROOT.'/core/tpl/extrafields_list_array_fields.tpl.php';
365// Add hook to complete $arrayfield
366$parameters = array('arrayfields' => &$arrayfields);
367$reshook = $hookmanager->executeHooks('completeArrayFields', $parameters, $object, $action); // Note that $action and $object may have been modified by hook
368
369// For POS context, we force some fields
370if ($contextpage == 'poslist') {
371 $arrayfields["f.module_source"]['checked'] = 1;
372 $arrayfields["f.pos_source"]['checked'] = 1;
373 $arrayfields["f.date_lim_reglement"]['checked'] = 0;
374 $arrayfields["f.total_ttc"]['checked'] = 1;
375 $arrayfields["f.tms"]['checked'] = 1;
376 $arrayfields["p.ref"]['checked'] = 0;
377}
378
379$object->fields = dol_sort_array($object->fields, 'position');
380$arrayfields = dol_sort_array($arrayfields, 'position');
381
382
383// Check only if it's an internal user, external users are already filtered by $socid
384if (empty($user->socid) && !$user->hasRight('societe', 'client', 'voir')) {
385 $search_sale = $user->id;
386}
387
388// Security check
389$fieldid = (!empty($ref) ? 'ref' : 'rowid');
390if (!empty($user->socid)) {
391 $socid = $user->socid;
392}
393if (empty($user->socid) && !$user->hasRight('societe', 'client', 'voir')) {
394 $search_sale = $user->id;
395}
396
397$result = restrictedArea($user, 'facture', $id, '', '', 'fk_soc', $fieldid);
398
399
400/*
401 * Actions
402 */
403
404if (GETPOST('cancel', 'alpha')) {
405 $action = 'list';
406 $massaction = '';
407}
408if (!GETPOST('confirmmassaction', 'alpha') && $massaction != 'presend' && $massaction != 'confirm_presend') {
409 $massaction = '';
410}
411
412
413$parameters = array('socid' => $socid, 'arrayfields' => &$arrayfields);
414$reshook = $hookmanager->executeHooks('doActions', $parameters, $object, $action); // Note that $action and $object may have been modified by some hooks
415if ($reshook < 0) {
416 setEventMessages($hookmanager->error, $hookmanager->errors, 'errors');
417}
418
419
420include DOL_DOCUMENT_ROOT.'/core/actions_changeselectedfields.inc.php';
421
422// Do we click on purge search criteria ?
423if (GETPOST('button_removefilter_x', 'alpha') || GETPOST('button_removefilter', 'alpha') || GETPOST('button_removefilter.x', 'alpha')) { // All tests are required to be compatible with all browsers
424 $search_user = '';
425 $search_sale = '';
426 $search_product_category = '';
427 $searchCategoryInvoiceList = array();
428 $search_ref = '';
429 $search_refcustomer = '';
430 $search_type = '';
431 $search_subtype = '';
432 $search_project_ref = '';
433 $search_project = '';
434 $search_company = '';
435 $search_company_alias = '';
436 $search_parent_name = '';
437 $search_montant_ht = '';
438 $search_montant_vat = '';
439 $search_montant_localtax1 = '';
440 $search_montant_localtax2 = '';
441 $search_montant_ttc = '';
442 $search_login = '';
443 $search_multicurrency_code = '';
444 $search_multicurrency_tx = '';
445 $search_multicurrency_montant_ht = '';
446 $search_multicurrency_montant_vat = '';
447 $search_multicurrency_montant_ttc = '';
448 $search_dispute_status = '';
449 $search_status = [];
450 $search_paymentmode = '';
451 $search_paymentterms = '';
452 $search_bankaccount = '';
453 $search_fk_input_reason = '';
454 $search_module_source = '';
455 $search_pos_source = '';
456 $search_town = '';
457 $search_zip = "";
458 $search_state = "";
459 $search_country = '';
460 $search_type_thirdparty = '';
461 $search_customer_code = '';
462 $search_date_startday = '';
463 $search_date_startmonth = '';
464 $search_date_startyear = '';
465 $search_date_endday = '';
466 $search_date_endmonth = '';
467 $search_date_endyear = '';
468 $search_date_start = '';
469 $search_date_end = '';
470 $search_date_valid_startday = '';
471 $search_date_valid_startmonth = '';
472 $search_date_valid_startyear = '';
473 $search_date_valid_endday = '';
474 $search_date_valid_endmonth = '';
475 $search_date_valid_endyear = '';
476 $search_date_valid_start = '';
477 $search_date_valid_end = '';
478 $search_datelimit_startday = '';
479 $search_datelimit_startmonth = '';
480 $search_datelimit_startyear = '';
481 $search_datelimit_endday = '';
482 $search_datelimit_endmonth = '';
483 $search_datelimit_endyear = '';
484 $search_datelimit_start = '';
485 $search_datelimit_end = '';
486
487 $search_datec_start = '';
488 $search_datec_end = '';
489
490 $search_datem_start = '';
491 $search_datem_end = '';
492
493 $search_fac_rec_source_title = '';
494 $search_option = '';
495 $search_import_key = '';
496 $search_categ_cus = 0;
497
498 $search_all = '';
499 $toselect = array();
500 $search_array_options = array();
501}
502
503if (empty($reshook)) {
504 $objectclass = 'Facture';
505 $objectlabel = 'Invoices';
506 $permissiontoread = $user->hasRight("facture", "lire");
507 $permissiontoadd = $user->hasRight("facture", "creer");
508 $permissiontodelete = $user->hasRight("facture", "supprimer");
509 $uploaddir = $conf->invoice->dir_output;
510 include DOL_DOCUMENT_ROOT.'/core/actions_massactions.inc.php';
511}
512
513if ($action == 'makepayment_confirm' && $user->hasRight('facture', 'paiement')) {
514 require_once DOL_DOCUMENT_ROOT.'/compta/paiement/class/paiement.class.php';
515 $arrayofselected = is_array($toselect) ? $toselect : array();
516 if (!empty($arrayofselected)) {
517 $bankid = GETPOSTINT('bankid');
518 $paiementid = GETPOSTINT('paiementid');
519 $note_private = GETPOST('note_private', 'restricthtml');
520 $paiementdate = dol_mktime(12, 0, 0, GETPOSTINT('datepaimentmonth'), GETPOSTINT('datepaimentday'), GETPOSTINT('datepaimentyear'));
521 if (empty($paiementdate)) {
522 setEventMessages($langs->trans("ErrorFieldRequired", $langs->transnoentitiesnoconv("Date")), null, 'errors');
523 $error++;
524 $action = 'makepayment';
525 }
526
527 if (!$error) {
528 foreach ($arrayofselected as $toselectid) {
529 $errorpayment = 0;
530 $facture = new Facture($db);
531 $result = $facture->fetch($toselectid);
532
533 $db->begin();
534
535 if ($result < 0) {
536 setEventMessage($facture->error, 'errors');
537 $errorpayment++;
538 } else {
539 if ($facture->type != Facture::TYPE_CREDIT_NOTE && $facture->status == Facture::STATUS_VALIDATED && $facture->paye == 0) {
540 // Get both the base-currency and invoice-currency paid amount in a single query
541 $sommePaiement = $facture->getSommePaiement(-1);
542 $paiementAmount = $sommePaiement['alreadypaid'];
543
544 $totalcreditnotes = $facture->getSumCreditNotesUsed();
545 $totaldeposits = $facture->getSumDepositsUsed();
546
547 $totalallpayments = $paiementAmount + $totalcreditnotes + $totaldeposits;
548 $remaintopay = (float) price2num($facture->total_ttc - $totalallpayments);
549
550 // hook to finalize the remaining amount, considering e.g. cash discount agreements
551 $parameters = array('remaintopay' => $remaintopay);
552 $reshook = $hookmanager->executeHooks('finalizeAmountOfInvoice', $parameters, $facture, $action); // Note that $action and $object may have been modified by some hooks
553 if ($reshook > 0) {
554 if (!empty($remain = (float) $hookmanager->resArray['remaintopay'])) {
555 $remaintopay = $remain;
556 }
557 } elseif ($reshook < 0) {
558 $error++;
559 setEventMessages($facture->ref.' '.$langs->trans("ProcessingError"), $hookmanager->errors, 'errors');
560 }
561
562 // Remain to pay in the invoice currency (may differ from $remaintopay when multicurrency is used)
563 $multicurrency_remaintopay = (float) price2num($facture->multicurrency_total_ttc - $sommePaiement['alreadypaid_multicurrency']);
564
565 if ($remaintopay != 0) {
566 $resultBank = $facture->setBankAccount($bankid);
567 if ($resultBank < 0) {
568 setEventMessages($facture->error, null, 'errors');
569 $errorpayment++;
570 } else {
571 $paiement = new Paiement($db);
572 $paiement->datepaye = $paiementdate;
573 $paiement->amounts[$facture->id] = $remaintopay; // Array with all payments dispatching with invoice id
574 $paiement->multicurrency_amounts[$facture->id] = (float) $multicurrency_remaintopay;
575 $paiement->paiementid = $paiementid;
576 $paiement->note_private = $note_private;
577 $paiement_id = $paiement->create($user, 1, $facture->thirdparty);
578 if ($paiement_id < 0) {
579 $langs->load("errors");
580 setEventMessages($facture->ref.' '.$langs->trans($paiement->error), $paiement->errors, 'errors');
581 $errorpayment++;
582 } else {
583 $result = $paiement->addPaymentToBank($user, 'payment', '', $bankid, '', '');
584 if ($result < 0) {
585 $langs->load("errors");
586 setEventMessages($facture->ref.' '.$langs->trans($paiement->error), $paiement->errors, 'errors');
587 $errorpayment++;
588 }
589 }
590 }
591 } else {
592 setEventMessage($langs->trans('NoPaymentAvailable', $facture->ref), 'warnings');
593 $errorpayment++;
594 }
595 } else {
596 setEventMessage($langs->trans('BulkPaymentNotPossibleForInvoice', $facture->ref), 'warnings');
597 $errorpayment++;
598 }
599 }
600
601 if (empty($errorpayment)) {
602 setEventMessage($langs->trans('PaymentRegisteredAndInvoiceSetToPaid', $facture->ref));
603 $db->commit();
604 } else {
605 $db->rollback();
606 }
607 }
608 }
609 }
610} elseif ($massaction == 'withdrawrequest') {
611 $langs->load("withdrawals");
612
613 if (!$user->hasRight('prelevement', 'bons', 'creer')) {
614 $error++;
615 setEventMessages($langs->trans("NotEnoughPermissions"), null, 'errors');
616 } else {
617 //Checking error
618 $error = 0;
619
620 $arrayofselected = is_array($toselect) ? $toselect : array();
621 $listofbills = array();
622 foreach ($arrayofselected as $toselectid) {
623 $objecttmp = new Facture($db);
624 $result = $objecttmp->fetch($toselectid);
625 if ($result > 0) {
626 $totalpaid = $objecttmp->getSommePaiement();
627 $totalcreditnotes = $objecttmp->getSumCreditNotesUsed();
628 $totaldeposits = $objecttmp->getSumDepositsUsed();
629 $objecttmp->resteapayer = price2num($objecttmp->total_ttc - $totalpaid - $totalcreditnotes - $totaldeposits, 'MT');
630
631 // hook to finalize the remaining amount, considering e.g. cash discount agreements
632 $parameters = array('remaintopay' => $objecttmp->resteapayer);
633 $reshook = $hookmanager->executeHooks('finalizeAmountOfInvoice', $parameters, $objecttmp, $action); // Note that $action and $object may have been modified by some hooks
634 if ($reshook > 0) {
635 if (!empty($remaintopay = $hookmanager->resArray['remaintopay'])) {
636 $objecttmp->resteapayer = $remaintopay;
637 }
638 } elseif ($reshook < 0) {
639 $error++;
640 setEventMessages($objecttmp->ref.' '.$langs->trans("ProcessingError"), $hookmanager->errors, 'errors');
641 }
642
643 if ($objecttmp->statut == Facture::STATUS_DRAFT) {
644 $error++;
645 setEventMessages($objecttmp->ref.' '.$langs->trans("Draft"), $objecttmp->errors, 'errors');
646 } elseif ($objecttmp->paye || $objecttmp->resteapayer == 0) {
647 $error++;
648 setEventMessages($objecttmp->ref.' '.$langs->trans("AlreadyPaid"), $objecttmp->errors, 'errors');
649 } elseif ($objecttmp->resteapayer < 0) {
650 $error++;
651 setEventMessages($objecttmp->ref.' '.$langs->trans("AmountMustBePositive"), $objecttmp->errors, 'errors');
652 }
653
654 $rsql = "SELECT pfd.rowid, pfd.traite, pfd.date_demande as date_demande";
655 $rsql .= " , pfd.date_traite as date_traite";
656 $rsql .= " , pfd.amount";
657 $rsql .= " , u.rowid as user_id, u.lastname, u.firstname, u.login";
658 $rsql .= " FROM ".MAIN_DB_PREFIX."prelevement_demande as pfd";
659 $rsql .= " , ".MAIN_DB_PREFIX."user as u";
660 $rsql .= " WHERE fk_facture = ".((int) $objecttmp->id);
661 $rsql .= " AND pfd.fk_user_demande = u.rowid";
662 $rsql .= " AND pfd.traite = 0";
663 $rsql .= " ORDER BY pfd.date_demande DESC";
664
665 $numprlv = 0;
666 $result_sql = $db->query($rsql);
667 if ($result_sql) {
668 $numprlv = $db->num_rows($result_sql);
669 }
670
671 if ($numprlv > 0) {
672 $error++;
673 setEventMessages($objecttmp->ref.' '.$langs->trans("RequestAlreadyDone"), $objecttmp->errors, 'warnings');
674 } elseif (!empty($objecttmp->mode_reglement_code) && $objecttmp->mode_reglement_code != 'PRE') {
675 $langs->load("errors");
676 $error++;
677 setEventMessages($objecttmp->ref.' '.$langs->trans("ErrorThisPaymentModeIsNotDirectDebit"), $objecttmp->errors, 'errors');
678 } else {
679 $listofbills[] = $objecttmp; // $listofbills will only contains invoices with good payment method and no request already done
680 }
681 }
682 }
683
684 //Massive withdraw request for request with no errors
685 if (!empty($listofbills)) {
686 $nbwithdrawrequestok = 0;
687 foreach ($listofbills as $aBill) {
688 // Note: The 2 following SQL requests are wrong but it works because we have one record into pfd for one record into pl and for into p for the same fk_facture_fourn.
689 // The table prelevement and prelevement_lignes must be removed in future and merged into prelevement_demande
690 // Step 1: Move field fk_... of llx_prelevement into llx_prelevement_lignes
691 // Step 2: Move field fk_... + status into prelevement_demande.
692 $pending = 0;
693 // Get pending requests open with no transfer receipt yet
694 $sql = "SELECT SUM(pfd.amount) as amount";
695 $sql .= " FROM ".MAIN_DB_PREFIX."prelevement_demande as pfd";
696 //if ($type == 'bank-transfer') {
697 //$sql .= " WHERE pfd.fk_facture_fourn = ".((int) $aBill->id);
698 //} else {
699 $sql .= " WHERE pfd.fk_facture = ".((int) $aBill->id);
700 //}
701 $sql .= " AND pfd.traite = 0";
702 //$sql .= " AND pfd.type = 'ban'";
703 $resql = $db->query($sql);
704 if ($resql) {
705 $obj = $db->fetch_object($resql);
706 if ($obj) {
707 $pending += (float) $obj->amount;
708 }
709 } else {
711 }
712 // Get pending request with a transfer receipt generated but not yet processed
713 $sqlPending = "SELECT SUM(pl.amount) as amount";
714 $sqlPending .= " FROM ".$db->prefix()."prelevement_lignes as pl";
715 $sqlPending .= " INNER JOIN ".$db->prefix()."prelevement as p ON p.fk_prelevement_lignes = pl.rowid";
716 //if ($type == 'bank-transfer') {
717 //$sqlPending .= " WHERE p.fk_facture_fourn = ".((int) $aBill->id);
718 //} else {
719 $sqlPending .= " WHERE p.fk_facture = ".((int) $aBill->id);
720 //}
721 $sqlPending .= " AND (pl.statut IS NULL OR pl.statut = 0)";
722 $resPending = $db->query($sqlPending);
723 if ($resPending) {
724 if ($objPending = $db->fetch_object($resPending)) {
725 $pending += (float) $objPending->amount;
726 }
727 }
728 $db->free($resPending);
729
730 $requestAmount = $aBill->resteapayer - $pending;
731
732 $db->begin();
733 $result = $aBill->demande_prelevement($user, $requestAmount, 'direct-debit', 'facture');
734 if ($requestAmount > 0) {
735 if ($result > 0) {
736 $db->commit();
737 $nbwithdrawrequestok++;
738 } else {
739 $db->rollback();
740 setEventMessages($aBill->error, $aBill->errors, 'errors');
741 }
742 } else {
743 $aBill->error = 'WithdrawRequestErrorNilAmount';
744 $aBill->errors[] = $aBill->error;
745 setEventMessages($aBill->error, $aBill->errors, 'errors');
746 }
747 }
748 if ($nbwithdrawrequestok > 0) {
749 setEventMessages($langs->trans("WithdrawRequestsDone", $nbwithdrawrequestok), null, 'mesgs');
750 }
751 }
752 }
753}
754
755
756
757/*
758 * View
759 */
760
761$form = new Form($db);
762$formother = new FormOther($db);
763$formfile = new FormFile($db);
764$formmargin = new FormMargin($db);
765$facturestatic = new Facture($db);
766$accountstatic = new Account($db);
767$formcompany = new FormCompany($db);
768$companystatic = new Societe($db);
769$companyparent = new Societe($db);
770
771$company_url_list = array();
772
773if ($socid > 0) {
774 $soc = new Societe($db);
775 $soc->fetch($socid);
776 if (empty($search_company)) {
777 $search_company = $soc->name;
778 }
779} else {
780 $soc = null;
781}
782
783$title = $langs->trans('BillsCustomers').' '.(($socid > 0 && $soc !== null) ? ' - '.$soc->name : '');
784$help_url = 'EN:Customers_Invoices|FR:Factures_Clients|ES:Facturas_a_clientes';
785
786$varpage = empty($contextpage) ? $_SERVER["PHP_SELF"] : $contextpage;
787$selectedfields = $form->multiSelectArrayWithCheckbox('selectedfields', $arrayfields, $varpage); // This also change content of $arrayfields
788
789// Build and execute select
790// --------------------------------------------------------------------
791$sql = 'SELECT';
792$sql .= ' f.rowid as id, f.ref, f.ref_client, f.fk_soc, f.type, f.subtype, f.note_private, f.note_public, f.increment, f.fk_mode_reglement, f.fk_cond_reglement, ba.rowid as bid, ba.ref as bref, ba.label as blabel, ba.number as bnumber, ba.account_number as baccount_number, ba.fk_accountancy_journal as baccountancy_journal, f.total_ht, f.total_tva, f.total_ttc,';
793$sql .= ' f.localtax1 as total_localtax1, f.localtax2 as total_localtax2,';
794$sql .= ' f.fk_user_author,';
795$sql .= ' f.fk_multicurrency, f.multicurrency_code, f.multicurrency_tx, f.multicurrency_total_ht, f.multicurrency_total_tva as multicurrency_total_vat, f.multicurrency_total_ttc,';
796$sql .= ' f.datef, f.date_valid, f.date_lim_reglement as datelimite,';
797$sql .= " f.fk_input_reason,";
798$sql .= " f.module_source, f.pos_source,";
799$sql .= ' f.paye as paye, f.fk_statut as status, f.import_key, f.close_code,';
800$sql .= ' f.datec as date_creation, f.tms as date_modification, f.date_closing as date_closing,';
801$sql .= ' f.retained_warranty, f.retained_warranty_date_limit, f.situation_final, f.situation_cycle_ref, f.situation_counter,';
802$sql .= ' f.payment_reference, f.dispute_status,';
803$sql .= ' s.rowid as socid, s.nom as name, s.name_alias as alias, s.email, s.phone, s.fax, s.address, s.town, s.zip, s.fk_pays, s.client, s.fournisseur, s.code_client, s.code_fournisseur, s.code_compta as code_compta_client, s.code_compta_fournisseur,';
804$sql .= " s.parent as fk_parent,";
805$sql .= " s2.nom as name2,";
806$sql .= ' typent.code as typent_code,';
807$sql .= ' state.code_departement as state_code, state.nom as state_name,';
808$sql .= ' country.code as country_code,';
809$sql .= ' f.fk_fac_rec_source,';
810$sql .= ' p.rowid as project_id, p.ref as project_ref, p.title as project_label,';
811$sql .= ' u.login, u.lastname, u.firstname, u.email as user_email, u.statut as user_statut, u.entity, u.photo, u.office_phone, u.office_fax, u.user_mobile, u.job, u.gender';
812// We need dynamount_payed to be able to sort on status (value is surely wrong because we can count several lines several times due to other left join or link with contacts. But what we need is just 0 or > 0).
813// A Better solution to be able to sort on already paid or remain to pay is to store amount_payed in a denormalized field.
814// We disable this. It create a bug when searching with search_all and sorting on status. Also it create performance troubles.
815/*
816if (!$search_all) {
817 $sql .= ', SUM(pf.amount) as dynamount_payed, SUM(pf.multicurrency_amount) as multicurrency_dynamount_payed';
818}
819*/
820// Add fields from extrafields
821if (!empty($extrafields->attributes[$object->table_element]['label'])) {
822 foreach ($extrafields->attributes[$object->table_element]['label'] as $key => $val) {
823 $sql .= ($extrafields->attributes[$object->table_element]['type'][$key] != 'separate' ? ", ef.".$key." as options_".$key : '');
824 }
825}
826// Add fields from hooks
827$parameters = array();
828$reshook = $hookmanager->executeHooks('printFieldListSelect', $parameters, $object, $action); // Note that $action and $object may have been modified by hook
829$sql .= $hookmanager->resPrint;
830$sql = preg_replace('/,\s*$/', '', $sql);
831
832$sqlfields = $sql; // $sql fields to remove for count total
833
834$sql .= ' FROM '.MAIN_DB_PREFIX.'societe as s';
835$sql .= " LEFT JOIN ".MAIN_DB_PREFIX."societe as s2 ON s2.rowid = s.parent";
836$sql .= " LEFT JOIN ".MAIN_DB_PREFIX."c_country as country on (country.rowid = s.fk_pays)";
837$sql .= " LEFT JOIN ".MAIN_DB_PREFIX."c_typent as typent on (typent.id = s.fk_typent)";
838$sql .= " LEFT JOIN ".MAIN_DB_PREFIX."c_departements as state on (state.rowid = s.fk_departement)";
839$sql .= ', '.MAIN_DB_PREFIX.'facture as f';
840// Add a special index hint if we sort on datef. But only if there is not search filter set to avoid bad query plan
841if ($sortfield == "f.datef") {
842 $hasAnotherfilter = false;
843 foreach ($search_array_options as $v) {
844 if ($v !== '' && (string) $v !== '-1') {
845 $hasAnotherfilter = true;
846 break;
847 }
848 }
849 if (!$hasAnotherfilter) {
850 $sql .= $db->hintindex('idx_facture_datef');
851 }
852}
853if (isset($extrafields->attributes[$object->table_element]['label']) && is_array($extrafields->attributes[$object->table_element]['label']) && count($extrafields->attributes[$object->table_element]['label'])) {
854 $sql .= " LEFT JOIN ".MAIN_DB_PREFIX.$object->table_element."_extrafields as ef on (f.rowid = ef.fk_object)";
855}
856if (!empty($search_fac_rec_source_title)) {
857 $sql .= ' LEFT JOIN '.MAIN_DB_PREFIX.'facture_rec as facrec ON f.fk_fac_rec_source = facrec.rowid';
858}
859$sql .= " LEFT JOIN ".MAIN_DB_PREFIX."projet as p ON p.rowid = f.fk_projet";
860$sql .= ' LEFT JOIN '.MAIN_DB_PREFIX.'user AS u ON f.fk_user_author = u.rowid';
861$sql .= ' LEFT JOIN '.MAIN_DB_PREFIX.'bank_account as ba ON ba.rowid = f.fk_account';
862// Add table from hooks
863$parameters = array();
864$reshook = $hookmanager->executeHooks('printFieldListFrom', $parameters, $object, $action); // Note that $action and $object may have been modified by hook
865$sql .= $hookmanager->resPrint;
866
867$sql .= ' WHERE f.fk_soc = s.rowid';
868$sql .= ' AND f.entity IN ('.getEntity('invoice').')';
869if ($socid > 0) {
870 $sql .= ' AND s.rowid = '.((int) $socid);
871}
872if ($userid) {
873 if ($userid == -1) {
874 $sql .= ' AND f.fk_user_author IS NULL';
875 } else {
876 $sql .= ' AND f.fk_user_author = '.((int) $userid);
877 }
878}
879if ($search_ref) {
880 $sql .= natural_search('f.ref', $search_ref);
881}
882if ($search_refcustomer) {
883 $sql .= natural_search('f.ref_client', $search_refcustomer);
884}
885if ($search_type != '' && $search_type != '-1') {
886 $sql .= " AND f.type IN (".$db->sanitize($db->escape($search_type)).")";
887}
888if ($search_subtype != '' && $search_subtype != '-1') {
889 $sql .= " AND f.subtype IN (".$db->sanitize($db->escape($search_subtype)).")";
890}
891if ($search_project_ref) {
892 $sql .= natural_search('p.ref', $search_project_ref);
893}
894if ($search_project) {
895 $sql .= natural_search('p.title', $search_project);
896}
897if (empty($arrayfields['s.name_alias']['checked']) && $search_company) {
898 $sql .= natural_search(array("s.nom", "s.name_alias"), $search_company);
899} else {
900 if ($search_company) {
901 $sql .= natural_search('s.nom', $search_company);
902 }
903 if ($search_company_alias) {
904 $sql .= natural_search('s.name_alias', $search_company_alias);
905 }
906}
907if ($search_parent_name) {
908 $sql .= natural_search('s2.nom', $search_parent_name);
909}
910if ($search_customer_code) {
911 $sql .= natural_search('s.code_client', $search_customer_code);
912}
913if ($search_town) {
914 $sql .= natural_search('s.town', $search_town);
915}
916if ($search_zip) {
917 $sql .= natural_search("s.zip", $search_zip);
918}
919if ($search_state) {
920 $sql .= natural_search("state.nom", $search_state);
921}
922if (strlen(trim($search_country))) {
923 $arrayofcode = getCountriesInEEC();
924 $country_code_in_EEC = $country_code_in_EEC_without_me = '';
925 foreach ($arrayofcode as $key => $value) {
926 $country_code_in_EEC .= ($country_code_in_EEC ? "," : "")."'".$value."'";
927 if ($value != $mysoc->country_code) {
928 $country_code_in_EEC_without_me .= ($country_code_in_EEC_without_me ? "," : "")."'".$value."'";
929 }
930 }
931 if ($search_country == 'special_allnotme') {
932 $sql .= " AND country.code <> '".$db->escape($mysoc->country_code)."'";
933 } elseif ($search_country == 'special_eec') {
934 $sql .= " AND country.code IN (".$db->sanitize($country_code_in_EEC, 1).")";
935 } elseif ($search_country == 'special_eecnotme') {
936 $sql .= " AND country.code IN (".$db->sanitize($country_code_in_EEC_without_me, 1).")";
937 } elseif ($search_country == 'special_noteec') {
938 $sql .= " AND country.code NOT IN (".$db->sanitize($country_code_in_EEC, 1).")";
939 } else {
940 $sql .= natural_search("country.code", $search_country);
941 }
942}
943if ($search_type_thirdparty != '' && $search_type_thirdparty != '-1') {
944 $sql .= " AND s.fk_typent IN (".$db->sanitize($db->escape($search_type_thirdparty)).')';
945}
946if ($search_montant_ht != '') {
947 $sql .= natural_search('f.total_ht', $search_montant_ht, 1);
948}
949if ($search_montant_vat != '') {
950 $sql .= natural_search('f.total_tva', $search_montant_vat, 1);
951}
952if ($search_montant_localtax1 != '') {
953 $sql .= natural_search('f.localtax1', $search_montant_localtax1, 1);
954}
955if ($search_montant_localtax2 != '') {
956 $sql .= natural_search('f.localtax2', $search_montant_localtax2, 1);
957}
958if ($search_montant_ttc != '') {
959 $sql .= natural_search('f.total_ttc', $search_montant_ttc, 1);
960}
961if ($search_multicurrency_code != '') {
962 $sql .= " AND f.multicurrency_code = '".$db->escape($search_multicurrency_code)."'";
963}
964if ($search_multicurrency_tx != '') {
965 $sql .= natural_search('f.multicurrency_tx', $search_multicurrency_tx, 1);
966}
967if ($search_multicurrency_montant_ht != '') {
968 $sql .= natural_search('f.multicurrency_total_ht', $search_multicurrency_montant_ht, 1);
969}
970if ($search_multicurrency_montant_vat != '') {
971 $sql .= natural_search('f.multicurrency_total_tva', $search_multicurrency_montant_vat, 1);
972}
973if ($search_multicurrency_montant_ttc != '') {
974 $sql .= natural_search('f.multicurrency_total_ttc', $search_multicurrency_montant_ttc, 1);
975}
976if ($search_login) {
977 $sql .= natural_search(array('u.login', 'u.firstname', 'u.lastname'), $search_login);
978}
979if ($search_dispute_status != '-1' && $search_dispute_status != '') {
980 if ($search_dispute_status == '0') {
981 $sql .= " AND (f.dispute_status IS NULL OR f.dispute_status = 0)";
982 } else {
983 $sql .= " AND f.dispute_status IN (".$db->sanitize($search_dispute_status).")";
984 }
985}
986if (is_array($search_status) && count($search_status) > 0) {
987 $search_statusArray = $search_status;
988 $sql .= " AND f.fk_statut IN (" . $db->sanitize(implode(',', array_map('intval', $search_statusArray))) . ")";
989}
990
991if ($search_paymentmode > 0) {
992 $sql .= " AND f.fk_mode_reglement = ".((int) $search_paymentmode);
993}
994if ($search_paymentterms > 0) {
995 $sql .= " AND f.fk_cond_reglement = ".((int) $search_paymentterms);
996}
997if ($search_bankaccount > 0) {
998 $sql .= " AND ba.rowid = ".((int) $search_bankaccount);
999}
1000if ($search_fk_input_reason > 0) {
1001 $sql .= " AND f.fk_input_reason = ".((int) $search_fk_input_reason);
1002}
1003if ($search_module_source) {
1004 $sql .= natural_search("f.module_source", $search_module_source);
1005}
1006if ($search_pos_source) {
1007 $sql .= natural_search("f.pos_source", $search_pos_source);
1008}
1009if ($search_date_start) {
1010 $sql .= " AND f.datef >= '".$db->idate($search_date_start)."'";
1011}
1012if ($search_date_end) {
1013 $sql .= " AND f.datef <= '".$db->idate($search_date_end)."'";
1014}
1015if ($search_date_valid_start) {
1016 $sql .= " AND f.date_valid >= '".$db->idate($search_date_valid_start)."'";
1017}
1018if ($search_date_valid_end) {
1019 $sql .= " AND f.date_valid <= '".$db->idate($search_date_valid_end)."'";
1020}
1021if ($search_datelimit_start) {
1022 $sql .= " AND f.date_lim_reglement >= '".$db->idate($search_datelimit_start)."'";
1023}
1024if ($search_datelimit_end) {
1025 $sql .= " AND f.date_lim_reglement <= '".$db->idate($search_datelimit_end)."'";
1026}
1027if ($search_note_public) {
1028 $sql .= " AND p.note_public LIKE '%".$db->escape($db->escapeforlike($search_note_public))."%'";
1029}
1030if ($search_note_private) {
1031 $sql .= " AND p.note_private LIKE '%".$db->escape($db->escapeforlike($search_note_private))."%'";
1032}
1033if ($search_datec_start) {
1034 $sql .= " AND f.datec >= '".$db->idate($search_datec_start)."'";
1035}
1036if ($search_datec_end) {
1037 $sql .= " AND f.datec <= '".$db->idate($search_datec_end)."'";
1038}
1039if ($search_datem_start) {
1040 $sql .= " AND f.tms >= '".$db->idate($search_datem_start)."'";
1041}
1042if ($search_datem_end) {
1043 $sql .= " AND f.tms <= '".$db->idate($search_datem_end)."'";
1044}
1045if ($search_option == 'late') {
1046 $sql .= " AND f.date_lim_reglement < '".$db->idate(dol_now() - $conf->invoice->client->warning_delay)."'";
1047}
1048/*if ($search_sale > 0) {
1049 $sql .= " AND s.rowid = sc.fk_soc AND sc.fk_user = ".((int) $search_sale);
1050}*/
1051if (!empty($search_fac_rec_source_title)) {
1052 $sql .= natural_search('facrec.titre', $search_fac_rec_source_title);
1053}
1054if ($search_fk_fac_rec_source) {
1055 $sql .= ' AND f.fk_fac_rec_source = ' . (int) $search_fk_fac_rec_source;
1056}
1057if ($search_import_key) {
1058 $sql .= natural_search("f.import_key", $search_import_key);
1059}
1060// Search on user
1061if ($search_user > 0) {
1062 $sql .= " AND EXISTS (";
1063 $sql .= " SELECT ec.fk_c_type_contact, ec.element_id, ec.fk_socpeople";
1064 $sql .= " FROM ".MAIN_DB_PREFIX."element_contact as ec";
1065 $sql .= " INNER JOIN ".MAIN_DB_PREFIX."c_type_contact as tc";
1066 $sql .= " ON ec.fk_c_type_contact = tc.rowid AND tc.element = 'facture' AND tc.source = 'internal'";
1067 $sql .= " WHERE ec.element_id = f.rowid AND ec.fk_socpeople = ".((int) $search_user).")";
1068}
1069// Search on sale representative
1070if ($search_sale && $search_sale != '-1') {
1071 if ($search_sale == -2) {
1072 $sql .= " AND NOT EXISTS (SELECT sc.fk_soc FROM ".MAIN_DB_PREFIX."societe_commerciaux as sc WHERE sc.fk_soc = f.fk_soc)";
1073 } elseif ($search_sale > 0) {
1074 $sql .= " AND EXISTS (SELECT sc.fk_soc FROM ".MAIN_DB_PREFIX."societe_commerciaux as sc WHERE sc.fk_soc = f.fk_soc AND sc.fk_user = ".((int) $search_sale).")";
1075 }
1076}
1077
1078// Search for tag/category ($searchCategoryInvoiceList is an array of ID)
1079if (!empty($searchCategoryInvoiceList)) {
1080 $searchCategoryInvoiceSqlList = array();
1081 $listofcategoryid = '';
1082 foreach ($searchCategoryInvoiceList as $searchCategoryInvoice) {
1083 if (intval($searchCategoryInvoice) == -2) {
1084 $searchCategoryInvoiceSqlList[] = "NOT EXISTS (SELECT ck.fk_invoice FROM ".MAIN_DB_PREFIX."categorie_invoice as ck WHERE f.rowid = ck.fk_invoice)";
1085 } elseif (intval($searchCategoryInvoice) > 0) {
1086 if ($searchCategoryInvoiceOperator == 0) {
1087 $searchCategoryInvoiceSqlList[] = " EXISTS (SELECT ck.fk_invoice FROM ".MAIN_DB_PREFIX."categorie_invoice as ck WHERE f.rowid = ck.fk_invoice AND ck.fk_categorie = ".((int) $searchCategoryInvoice).")";
1088 } else {
1089 $listofcategoryid .= ($listofcategoryid ? ', ' : '') .((int) $searchCategoryInvoice);
1090 }
1091 }
1092 }
1093 if ($listofcategoryid) {
1094 $searchCategoryInvoiceSqlList[] = " EXISTS (SELECT ck.fk_invoice FROM ".MAIN_DB_PREFIX."categorie_invoice as ck WHERE f.rowid = ck.fk_invoice AND ck.fk_categorie IN (".$db->sanitize($listofcategoryid)."))";
1095 }
1096 if ($searchCategoryInvoiceOperator == 1) {
1097 if (!empty($searchCategoryInvoiceSqlList)) {
1098 $sql .= " AND (".implode(' OR ', $searchCategoryInvoiceSqlList).")";
1099 }
1100 } else {
1101 if (!empty($searchCategoryInvoiceSqlList)) {
1102 $sql .= " AND (".implode(' AND ', $searchCategoryInvoiceSqlList).")";
1103 }
1104 }
1105}
1106
1107// Search for tag/category ($searchCategoryProductList is an array of ID)
1108$searchCategoryProductList = $search_product_category ? array($search_product_category) : array();
1109$searchCategoryProductOperator = 0;
1110if (!empty($searchCategoryProductList)) {
1111 $searchCategoryProductSqlList = array();
1112 $listofcategoryid = '';
1113 foreach ($searchCategoryProductList as $searchCategoryProduct) {
1114 if (intval($searchCategoryProduct) == -2) {
1115 $searchCategoryProductSqlList[] = "NOT EXISTS (SELECT ck.fk_product FROM ".MAIN_DB_PREFIX."categorie_product as ck, ".MAIN_DB_PREFIX."facturedet as fd WHERE fd.fk_facture = f.rowid AND fd.fk_product = ck.fk_product)";
1116 } elseif (intval($searchCategoryProduct) > 0) {
1117 if ($searchCategoryProductOperator == 0) {
1118 $searchCategoryProductSqlList[] = " EXISTS (SELECT ck.fk_product FROM ".MAIN_DB_PREFIX."categorie_product as ck, ".MAIN_DB_PREFIX."facturedet as fd WHERE fd.fk_facture = f.rowid AND fd.fk_product = ck.fk_product AND ck.fk_categorie = ".((int) $searchCategoryProduct).")";
1119 } else {
1120 $listofcategoryid .= ($listofcategoryid ? ', ' : '') .((int) $searchCategoryProduct);
1121 }
1122 }
1123 }
1124 if ($listofcategoryid) {
1125 $searchCategoryProductSqlList[] = " EXISTS (SELECT ck.fk_product FROM ".MAIN_DB_PREFIX."categorie_product as ck, ".MAIN_DB_PREFIX."facturedet as fd WHERE fd.fk_facture = f.rowid AND fd.fk_product = ck.fk_product AND ck.fk_categorie IN (".$db->sanitize($listofcategoryid)."))";
1126 }
1127 if ($searchCategoryProductOperator == 1) {
1128 if (!empty($searchCategoryProductSqlList)) {
1129 $sql .= " AND (".implode(' OR ', $searchCategoryProductSqlList).")";
1130 }
1131 } else {
1132 if (!empty($searchCategoryProductSqlList)) {
1133 $sql .= " AND (".implode(' AND ', $searchCategoryProductSqlList).")";
1134 }
1135 }
1136}
1137$searchCategoryCustomerList = $search_categ_cus ? array($search_categ_cus) : array();
1138$searchCategoryCustomerOperator = 0;
1139// Search for tag/category ($searchCategoryCustomerList is an array of ID)
1140if (!empty($searchCategoryCustomerList)) {
1141 $searchCategoryCustomerSqlList = array();
1142 $listofcategoryid = '';
1143 foreach ($searchCategoryCustomerList as $searchCategoryCustomer) {
1144 if (intval($searchCategoryCustomer) == -2) {
1145 $searchCategoryCustomerSqlList[] = "NOT EXISTS (SELECT ck.fk_soc FROM ".MAIN_DB_PREFIX."categorie_societe as ck WHERE s.rowid = ck.fk_soc)";
1146 } elseif (intval($searchCategoryCustomer) > 0) {
1147 if ($searchCategoryCustomerOperator == 0) {
1148 $searchCategoryCustomerSqlList[] = " EXISTS (SELECT ck.fk_soc FROM ".MAIN_DB_PREFIX."categorie_societe as ck WHERE s.rowid = ck.fk_soc AND ck.fk_categorie = ".((int) $searchCategoryCustomer).")";
1149 } else {
1150 $listofcategoryid .= ($listofcategoryid ? ', ' : '') .((int) $searchCategoryCustomer);
1151 }
1152 }
1153 }
1154 if ($listofcategoryid) {
1155 $searchCategoryCustomerSqlList[] = " EXISTS (SELECT ck.fk_soc FROM ".MAIN_DB_PREFIX."categorie_societe as ck WHERE s.rowid = ck.fk_soc AND ck.fk_categorie IN (".$db->sanitize($listofcategoryid)."))";
1156 }
1157 if ($searchCategoryCustomerOperator == 1) {
1158 if (!empty($searchCategoryCustomerSqlList)) {
1159 $sql .= " AND (".implode(' OR ', $searchCategoryCustomerSqlList).")";
1160 }
1161 } else {
1162 if (!empty($searchCategoryCustomerSqlList)) {
1163 $sql .= " AND (".implode(' AND ', $searchCategoryCustomerSqlList).")";
1164 }
1165 }
1166}
1167// Add where from extra fields
1168include DOL_DOCUMENT_ROOT.'/core/tpl/extrafields_list_search_sql.tpl.php';
1169// Add where from hooks
1170$parameters = array();
1171$reshook = $hookmanager->executeHooks('printFieldListWhere', $parameters, $object, $action); // Note that $action and $object may have been modified by hook
1172$sql .= $hookmanager->resPrint;
1173
1174if ($search_all) {
1175 // Prepare the $sqltoadd for fields pd.* that need a test by doing a "or exits"
1176 $sqltoadd = '';
1177 $fieldstosearchallwithoutpd = array();
1178 $fieldstosearchallwithpd = array();
1179 foreach ($fieldstosearchall as $key => $val) {
1180 if (!preg_match('/^pd\./', $key)) {
1181 $fieldstosearchallwithoutpd[$key] = $val;
1182 } else {
1183 $fieldstosearchallwithpd[$key] = $val;
1184 }
1185 }
1186
1187 if (count($fieldstosearchallwithpd) > 0) {
1188 $sqltoadd .= " OR EXISTS (SELECT pd.rowid FROM ".MAIN_DB_PREFIX."facturedet as pd WHERE pd.fk_facture = f.rowid";
1189 $sqltoadd .= natural_search(array_keys($fieldstosearchallwithpd), '__KEYTOSEARCH__');
1190 $sqltoadd .= ')';
1191 }
1192
1193 $sql .= natural_search(array_keys($fieldstosearchallwithoutpd), $search_all, 0, 0, $sqltoadd);
1194}
1195// Add HAVING from hooks
1196$parameters = array();
1197$reshook = $hookmanager->executeHooks('printFieldListHaving', $parameters, $object, $action); // Note that $action and $object may have been modified by hook
1198if (empty($reshook)) {
1199 $sql .= empty($hookmanager->resPrint) ? "" : " HAVING 1=1 ".$hookmanager->resPrint;
1200} else {
1201 $sql = $hookmanager->resPrint;
1202}
1203
1204// Count total nb of records
1205$nbtotalofrecords = '';
1206if (!getDolGlobalInt('MAIN_DISABLE_FULL_SCANLIST')) {
1207 /* The fast and low memory method to get and count full list converts the sql into a sql count */
1208 $sqlforcount = preg_replace('/^'.preg_quote($sqlfields, '/').'/', 'SELECT COUNT(*) as nbtotalofrecords', $sql);
1209 $sqlforcount = preg_replace('/GROUP BY .*$/', '', $sqlforcount);
1210
1211 $resql = $db->query($sqlforcount);
1212 if ($resql) {
1213 $objforcount = $db->fetch_object($resql);
1214 $nbtotalofrecords = $objforcount->nbtotalofrecords;
1215 } else {
1217 }
1218
1219 if (($page * $limit) > (int) $nbtotalofrecords) { // if total resultset is smaller than the paging size (filtering), goto and load page 0
1220 $page = 0;
1221 $offset = 0;
1222 }
1223 $db->free($resql);
1224}
1225
1226// Complete request and execute it with limit
1227$sql .= $db->order($sortfield, $sortorder);
1228if ($limit) {
1229 $sql .= $db->plimit($limit + 1, $offset);
1230}
1231
1232$resql = $db->query($sql);
1233if (!$resql) {
1235 exit;
1236}
1237
1238$num = $db->num_rows($resql);
1239
1240$arrayofselected = is_array($toselect) ? $toselect : array();
1241
1242if ($num == 1 && getDolGlobalString('MAIN_SEARCH_DIRECT_OPEN_IF_ONLY_ONE') && $search_all) {
1243 $obj = $db->fetch_object($resql);
1244 $id = $obj->id;
1245
1246 header("Location: ".DOL_URL_ROOT.'/compta/facture/card.php?id='.$id);
1247 exit;
1248}
1249
1250// Output page
1251// --------------------------------------------------------------------
1252
1253llxHeader('', $title, $help_url, '', 0, 0, '', '', '', 'bodyforlist'.($contextpage == 'poslist' ? ' '.$contextpage : ''));
1254
1255
1256if ($search_fk_fac_rec_source) {
1257 $object = new FactureRec($db);
1258 $object->fetch((int) $search_fk_fac_rec_source);
1259
1260 $head = invoice_rec_prepare_head($object);
1261
1262 print dol_get_fiche_head($head, 'generated', $langs->trans('InvoicesGeneratedFromRec'), -1, $object->picto); // Add a div
1263}
1264
1265$param = '';
1266if (!empty($mode)) {
1267 $param .= '&mode='.urlencode($mode);
1268}
1269if (!empty($contextpage) && $contextpage != $_SERVER["PHP_SELF"]) {
1270 $param .= '&contextpage='.urlencode($contextpage);
1271}
1272if ($limit > 0 && $limit != $conf->liste_limit) {
1273 $param .= '&limit='.((int) $limit);
1274}
1275if ($optioncss != '') {
1276 $param .= '&optioncss='.urlencode($optioncss);
1277}
1278if ($show_files) {
1279 $param .= '&show_files='.urlencode((string) ($show_files));
1280}
1281if ($search_all) {
1282 $param .= '&search_all='.urlencode($search_all);
1283}
1284if ($socid > 0) {
1285 $param .= '&socid='.((int) $socid);
1286}
1287if ($search_date_startday) {
1288 $param .= '&search_date_startday='.urlencode((string) ($search_date_startday));
1289}
1290if ($search_date_startmonth) {
1291 $param .= '&search_date_startmonth='.urlencode((string) ($search_date_startmonth));
1292}
1293if ($search_date_startyear) {
1294 $param .= '&search_date_startyear='.urlencode((string) ($search_date_startyear));
1295}
1296if ($search_date_endday) {
1297 $param .= '&search_date_endday='.urlencode((string) ($search_date_endday));
1298}
1299if ($search_date_endmonth) {
1300 $param .= '&search_date_endmonth='.urlencode((string) ($search_date_endmonth));
1301}
1302if ($search_date_endyear) {
1303 $param .= '&search_date_endyear='.urlencode((string) ($search_date_endyear));
1304}
1305if ($search_date_valid_startday) {
1306 $param .= '&search_date_valid_startday='.urlencode((string) ($search_date_valid_startday));
1307}
1308if ($search_date_valid_startmonth) {
1309 $param .= '&search_date_valid_startmonth='.urlencode((string) ($search_date_valid_startmonth));
1310}
1311if ($search_date_valid_startyear) {
1312 $param .= '&search_date_valid_startyear='.urlencode((string) ($search_date_valid_startyear));
1313}
1314if ($search_date_valid_endday) {
1315 $param .= '&search_date_valid_endday='.urlencode((string) ($search_date_valid_endday));
1316}
1317if ($search_date_valid_endmonth) {
1318 $param .= '&search_date_valid_endmonth='.urlencode((string) ($search_date_valid_endmonth));
1319}
1320if ($search_date_valid_endyear) {
1321 $param .= '&search_date_valid_endyear='.urlencode((string) ($search_date_valid_endyear));
1322}
1323if ($search_datelimit_startday) {
1324 $param .= '&search_datelimit_startday='.urlencode((string) ($search_datelimit_startday));
1325}
1326if ($search_datelimit_startmonth) {
1327 $param .= '&search_datelimit_startmonth='.urlencode((string) ($search_datelimit_startmonth));
1328}
1329if ($search_datelimit_startyear) {
1330 $param .= '&search_datelimit_startyear='.urlencode((string) ($search_datelimit_startyear));
1331}
1332if ($search_datelimit_endday) {
1333 $param .= '&search_datelimit_endday='.urlencode((string) ($search_datelimit_endday));
1334}
1335if ($search_datelimit_endmonth) {
1336 $param .= '&search_datelimit_endmonth='.urlencode((string) ($search_datelimit_endmonth));
1337}
1338if ($search_datelimit_endyear) {
1339 $param .= '&search_datelimit_endyear='.urlencode((string) ($search_datelimit_endyear));
1340}
1341// The 4 date filters above are read by GETPOSTDATE from their day/month/year/hour/min parts, so the parts are what must be kept
1342foreach (array('search_datec_start', 'search_datec_end', 'search_datem_start', 'search_datem_end') as $tmpprefix) {
1343 foreach (array('day', 'month', 'year', 'hour', 'min') as $tmpsuffix) {
1344 if (GETPOSTISSET($tmpprefix.$tmpsuffix)) {
1345 $param .= '&'.$tmpprefix.$tmpsuffix.'='.urlencode((string) GETPOSTINT($tmpprefix.$tmpsuffix));
1346 }
1347 }
1348}
1349if ($search_ref) {
1350 $param .= '&search_ref='.urlencode($search_ref);
1351}
1352if ($search_note_private) {
1353 $param .= '&search_note_private='.urlencode($search_note_private);
1354}
1355if ($search_note_public) {
1356 $param .= '&search_note_public='.urlencode($search_note_public);
1357}
1358if ($search_refcustomer) {
1359 $param .= '&search_refcustomer='.urlencode($search_refcustomer);
1360}
1361if ($search_project_ref) {
1362 $param .= '&search_project_ref='.urlencode($search_project_ref);
1363}
1364if ($search_project) {
1365 $param .= '&search_project='.urlencode($search_project);
1366}
1367if ($search_type != '') {
1368 $param .= '&search_type='.urlencode($search_type);
1369}
1370if ($search_subtype != '') {
1371 $param .= '&search_subtype='.urlencode($search_subtype);
1372}
1373if ($search_company) {
1374 $param .= '&search_company='.urlencode($search_company);
1375}
1376if ($search_company_alias) {
1377 $param .= '&search_company_alias='.urlencode($search_company_alias);
1378}
1379if ($search_parent_name != '') {
1380 $param .= '&search_parent_name='.urlencode($search_parent_name);
1381}
1382if ($search_town) {
1383 $param .= '&search_town='.urlencode($search_town);
1384}
1385if ($search_zip) {
1386 $param .= '&search_zip='.urlencode($search_zip);
1387}
1388if ($search_state) {
1389 $param .= '&search_state='.urlencode($search_state);
1390}
1391if ($search_country) {
1392 $param .= "&search_country=".urlencode($search_country);
1393}
1394if ($search_type_thirdparty != '') {
1395 $param .= '&search_type_thirdparty='.urlencode($search_type_thirdparty);
1396}
1397if ($search_customer_code) {
1398 $param .= '&search_customer_code='.urlencode($search_customer_code);
1399}
1400if ($search_sale > 0) {
1401 $param .= '&search_sale='.urlencode((string) $search_sale);
1402}
1403if ($search_user > 0) {
1404 $param .= '&search_user='.urlencode((string) $search_user);
1405}
1406if ($search_login) {
1407 $param .= '&search_login='.urlencode($search_login);
1408}
1409if ($searchCategoryInvoiceOperator == 1) {
1410 $param .= "&search_category_invoice_operator=".urlencode((string) ($searchCategoryInvoiceOperator));
1411}
1412foreach ($searchCategoryInvoiceList as $searchCategoryInvoice) {
1413 $param .= "&search_category_invoice_list[]=".urlencode($searchCategoryInvoice);
1414}
1415if ($search_product_category > 0) {
1416 $param .= '&search_product_category='.urlencode((string) $search_product_category);
1417}
1418if ($search_montant_ht != '') {
1419 $param .= '&search_montant_ht='.urlencode($search_montant_ht);
1420}
1421if ($search_montant_vat != '') {
1422 $param .= '&search_montant_vat='.urlencode($search_montant_vat);
1423}
1424if ($search_montant_localtax1 != '') {
1425 $param .= '&search_montant_localtax1='.urlencode($search_montant_localtax1);
1426}
1427if ($search_montant_localtax2 != '') {
1428 $param .= '&search_montant_localtax2='.urlencode($search_montant_localtax2);
1429}
1430if ($search_montant_ttc != '') {
1431 $param .= '&search_montant_ttc='.urlencode($search_montant_ttc);
1432}
1433if ($search_multicurrency_code != '') {
1434 $param .= '&search_multicurrency_code='.urlencode($search_multicurrency_code);
1435}
1436if ($search_multicurrency_tx != '') {
1437 $param .= '&search_multicurrency_tx='.urlencode($search_multicurrency_tx);
1438}
1439if ($search_multicurrency_montant_ht != '') {
1440 $param .= '&search_multicurrency_montant_ht='.urlencode($search_multicurrency_montant_ht);
1441}
1442if ($search_multicurrency_montant_vat != '') {
1443 $param .= '&search_multicurrency_montant_vat='.urlencode($search_multicurrency_montant_vat);
1444}
1445if ($search_multicurrency_montant_ttc != '') {
1446 $param .= '&search_multicurrency_montant_ttc='.urlencode($search_multicurrency_montant_ttc);
1447}
1448if ($search_dispute_status != '') {
1449 $param .= '&search_dispute_status='.urlencode($search_dispute_status);
1450}
1451if (count($search_status) > 0) {
1452 foreach ($search_status as $key => $val) {
1453 $param .= '&search_status[]='.urlencode($val);
1454 }
1455}
1456if ($search_paymentmode > 0) {
1457 $param .= '&search_paymentmode='.urlencode((string) ($search_paymentmode));
1458}
1459if ($search_paymentterms > 0) {
1460 $param .= '&search_paymentterms='.urlencode((string) ($search_paymentterms));
1461}
1462if ($search_bankaccount > 0) {
1463 $param .= '&search_bankaccount='.urlencode((string) ($search_bankaccount));
1464}
1465if ($search_fk_input_reason > 0) {
1466 $param .= '&search_fk_input_reason='.urlencode((string) $search_fk_input_reason);
1467}
1468if ($search_module_source) {
1469 $param .= '&search_module_source='.urlencode($search_module_source);
1470}
1471if ($search_pos_source) {
1472 $param .= '&search_pos_source='.urlencode($search_pos_source);
1473}
1474if ($search_option) {
1475 $param .= "&search_option=".urlencode($search_option);
1476}
1477if ($search_categ_cus > 0) {
1478 $param .= '&search_categ_cus='.urlencode((string) ($search_categ_cus));
1479}
1480if (!empty($search_fac_rec_source_title)) {
1481 $param .= '&search_fac_rec_source_title='.urlencode($search_fac_rec_source_title);
1482}
1483if ($search_fk_fac_rec_source) {
1484 $param .= '&search_fk_fac_rec_source=' . (int) $search_fk_fac_rec_source;
1485}
1486if ($search_import_key != '') {
1487 $param .= '&search_import_key='.urlencode($search_import_key);
1488}
1489
1490// Add $param from extra fields
1491include DOL_DOCUMENT_ROOT.'/core/tpl/extrafields_list_search_param.tpl.php';
1492// Add $param from hooks
1493$parameters = array('param' => &$param);
1494$reshook = $hookmanager->executeHooks('printFieldListSearchParam', $parameters, $object, $action); // Note that $action and $object may have been modified by hook
1495$param .= $hookmanager->resPrint;
1496
1497$arrayofmassactions = array(
1498 'validate' => img_picto('', 'check', 'class="pictofixedwidth"').$langs->trans("Validate"),
1499 'generate_doc' => img_picto('', 'pdf', 'class="pictofixedwidth"').$langs->trans("ReGeneratePDF"),
1500 'builddoc' => img_picto('', 'pdf', 'class="pictofixedwidth"').$langs->trans("PDFMerge"),
1501 'presend' => img_picto('', 'email', 'class="pictofixedwidth"').$langs->trans("SendByMail"),
1502);
1503
1504if (isModEnabled('category') && $user->hasRight('facture', 'creer')) {
1505 $arrayofmassactions['preaffecttag'] = img_picto('', 'category', 'class="pictofixedwidth"').$langs->trans("AffectTag");
1506}
1507if ($user->hasRight('facture', 'paiement')) {
1508 $arrayofmassactions['makepayment'] = img_picto('', 'payment', 'class="pictofixedwidth"').$langs->trans("MakePaymentAndClassifyPayed");
1509}
1510if (isModEnabled('prelevement') && $user->hasRight('prelevement', 'bons', 'creer')) {
1511 $langs->load("withdrawals");
1512 $arrayofmassactions['withdrawrequest'] = img_picto('', 'payment', 'class="pictofixedwidth"').$langs->trans("MakeWithdrawRequest");
1513}
1514if ($user->hasRight('facture', 'supprimer')) {
1515 if (!getDolGlobalString('INVOICE_DIABLE_MASS_DELETION_ON_DRAFT_INVOICES')) {
1516 $arrayofmassactions['predeletedraft'] = img_picto('', 'delete', 'class="pictofixedwidth"').$langs->trans("Deletedraft");
1517 }
1518}
1519if ($user->hasRight("facture", "creer")) {
1520 if (!getDolGlobalInt('STOCK_CALCULATE_ON_BILL')) {
1521 $arrayofmassactions['precreatecreditnote'] = img_picto('', 'undo', 'class="pictofixedwidth"').$langs->trans("cancelByCreditNote");
1522 }
1523}
1524if (in_array($massaction, array('presend', 'predelete', 'makepayment'))) {
1525 $arrayofmassactions = array();
1526}
1527$massactionbutton = $form->selectMassAction('', $arrayofmassactions);
1528
1529
1530// Show the new button only when this page is not opened from the Extended POS
1531$newcardbutton = '';
1532if ($contextpage != 'poslist') {
1533 $url = DOL_URL_ROOT.'/compta/facture/card.php?action=create';
1534 if (!empty($object->socid)) {
1535 $url .= '&socid='.urlencode((string) $object->socid);
1536 }
1537 if (!empty($object->id)) {
1538 $url .= '&fac_rec='.urlencode((string) $object->id);
1539 }
1540 $newcardbutton = '';
1541 $newcardbutton .= dolGetButtonTitle($langs->trans('ViewList'), '', 'fa fa-bars imgforviewmode', $_SERVER["PHP_SELF"].'?mode=common'.preg_replace('/(&|\?)*mode=[^&]+/', '', $param), '', ((empty($mode) || $mode == 'common') ? 2 : 1), array('morecss' => 'reposition'));
1542 $newcardbutton .= dolGetButtonTitle($langs->trans('ViewKanban'), '', 'fa fa-th-list imgforviewmode', $_SERVER["PHP_SELF"].'?mode=kanban'.preg_replace('/(&|\?)*mode=[^&]+/', '', $param), '', ($mode == 'kanban' ? 2 : 1), array('morecss' => 'reposition'));
1543 $newcardbutton .= dolGetButtonTitle($langs->trans('Statistics'), '', 'fa fa-chart-bar imgforviewmode', DOL_URL_ROOT.'/compta/facture/stats/index.php?'.preg_replace('/(&|\?)*(mode|groupby)=[^&]+/', '', $param), '', ($mode == 'statistics' ? 2 : 1), array('morecss' => 'reposition'));
1544 $newcardbutton .= dolGetButtonTitleSeparator();
1545 $newcardbutton .= dolGetButtonTitle($langs->trans('NewBill'), '', 'fa fa-plus-circle', $url, '', $user->hasRight("facture", "creer"));
1546}
1547
1548
1549// Lines of title fields
1550$i = 0;
1551print '<form method="POST" id="searchFormList" name="searchFormList" action="'.$_SERVER["PHP_SELF"].'">'."\n";
1552if ($optioncss != '') {
1553 print '<input type="hidden" name="optioncss" value="'.$optioncss.'">';
1554}
1555print '<input type="hidden" name="token" value="'.newToken().'">';
1556print '<input type="hidden" name="formfilteraction" id="formfilteraction" value="list">';
1557if (!in_array($massaction, array('makepayment'))) {
1558 print '<input type="hidden" name="action" value="list">';
1559}
1560print '<input type="hidden" name="sortfield" value="'.$sortfield.'">';
1561print '<input type="hidden" name="sortorder" value="'.$sortorder.'">';
1562// print '<input type="hidden" name="search_status" value="'.$search_status.'">';
1563print '<input type="hidden" name="contextpage" value="'.$contextpage.'">';
1564print '<input type="hidden" name="socid" value="'.$socid.'">';
1565print '<input type="hidden" name="mode" value="'.$mode.'">';
1566
1567print_barre_liste($title, $page, $_SERVER["PHP_SELF"], $param, $sortfield, $sortorder, $massactionbutton, $num, $nbtotalofrecords, 'bill', 0, $newcardbutton, '', $limit, 0, 0, 1);
1568
1569$topicmail = "SendBillRef";
1570$modelmail = "facture_send";
1571$objecttmp = new Facture($db);
1572$trackid = 'inv'.$object->id;
1573include DOL_DOCUMENT_ROOT.'/core/tpl/massactions_pre.tpl.php';
1574
1575if ($massaction == 'makepayment') {
1576 $formconfirm = '';
1577 $formquestion = array(
1578 // 'text' => $langs->trans("ConfirmClone"),
1579 // array('type' => 'checkbox', 'name' => 'clone_content', 'label' => $langs->trans("CloneMainAttributes"), 'value' => 1),
1580 // array('type' => 'checkbox', 'name' => 'update_prices', 'label' => $langs->trans("PuttingPricesUpToDate"), 'value' => 1),
1581 array('type' => 'date', 'name' => 'datepaiment', 'label' => $langs->trans("Date"), 'datenow' => 1),
1582 array('type' => 'other', 'name' => 'paiementid', 'label' => $langs->trans("PaymentMode"), 'value' => $form->select_types_paiements(GETPOST('search_paymentmode'), 'paiementid', '', 0, 0, 1, 0, 1, '', 1)),
1583 array('type' => 'other', 'name' => 'bankid', 'label' => $langs->trans("BankAccount"), 'value' => $form->select_comptes('', 'bankid', 0, '', 0, '', 0, '', 1)),
1584 array('type' => 'other', 'name' => 'note_private', 'label' => $langs->trans("Comments"), 'value' => '<textarea name="note_private" id="note_private" class="minwidth200" rows="3"></textarea>'),
1585 //array('type' => 'other', 'name' => 'invoicesid', 'label' => '', 'value'=>'<input type="hidden" id="invoicesid" name="invoicesid" value="'.implode('#',GETPOST('toselect','array')).'">'),
1586 );
1587 $formconfirm = $form->formconfirm($_SERVER["PHP_SELF"], $langs->trans('MakePaymentAndClassifyPayed'), $langs->trans('EnterPaymentReceivedFromCustomer'), 'makepayment_confirm', $formquestion, 1, 0, 200, 500, 1);
1588 print $formconfirm;
1589}
1590
1591if ($search_all) {
1592 foreach ($fieldstosearchall as $key => $val) {
1593 $fieldstosearchall[$key] = $langs->trans($val);
1594 }
1595 print '<div class="divsearchfieldfilter">'.$langs->trans("FilterOnInto", $search_all).implode(', ', $fieldstosearchall).'</div>';
1596}
1597
1598// If the user can view prospects other than his'
1599$moreforfilter = '';
1600
1601if (isModEnabled('category') && $user->hasRight('categorie', 'read')) {
1602 $formcategory = new FormCategory($db);
1603 $moreforfilter .= $formcategory->getFilterBox(Categorie::TYPE_INVOICE, $searchCategoryInvoiceList, 'minwidth300', $searchCategoryInvoiceOperator ? $searchCategoryInvoiceOperator : 0);
1604}
1605if ($user->hasRight("user", "user", "lire")) {
1606 $langs->load("commercial");
1607 $moreforfilter .= '<div class="divsearchfield">';
1608 $tmptitle = $langs->trans('ThirdPartiesOfSaleRepresentative');
1609 $moreforfilter .= img_picto($tmptitle, 'user', 'class="pictofixedwidth"').$formother->select_salesrepresentatives($search_sale, 'search_sale', $user, 0, $tmptitle, 'maxwidth200');
1610 $moreforfilter .= '</div>';
1611}
1612// If the user can view other users
1613if ($user->hasRight("user", "user", "lire")) {
1614 $moreforfilter .= '<div class="divsearchfield">';
1615 $tmptitle = $langs->trans('LinkedToSpecificUsers');
1616 $moreforfilter .= img_picto($tmptitle, 'user', 'class="pictofixedwidth"').$form->select_dolusers($search_user, 'search_user', $tmptitle, null, 0, '', '', '0', 0, 0, '', 0, '', 'maxwidth200');
1617 $moreforfilter .= '</div>';
1618}
1619// Filter on product tags
1620if (isModEnabled('category') && $user->hasRight("categorie", "lire") && ($user->hasRight("produit", "lire") || $user->hasRight("service", "lire"))) {
1621 include_once DOL_DOCUMENT_ROOT.'/categories/class/categorie.class.php';
1622 $moreforfilter .= '<div class="divsearchfield">';
1623 $tmptitle = $langs->trans('IncludingProductWithTag');
1624 $cate_arbo = $form->select_all_categories(Categorie::TYPE_PRODUCT, '', 'parent', 0, 0, 1);
1625 $moreforfilter .= img_picto($tmptitle, 'category', 'class="pictofixedwidth"').$form->selectarray('search_product_category', $cate_arbo, $search_product_category, $tmptitle, 0, 0, '', 0, 0, 0, '', 'maxwidth300 widthcentpercentminusx', 1);
1626 $moreforfilter .= '</div>';
1627}
1628if (isModEnabled('category') && $user->hasRight("categorie", "lire")) {
1629 require_once DOL_DOCUMENT_ROOT.'/categories/class/categorie.class.php';
1630 $moreforfilter .= '<div class="divsearchfield">';
1631 $tmptitle = $langs->trans('CustomersProspectsCategoriesShort');
1632 $moreforfilter .= img_picto($tmptitle, 'category', 'class="pictofixedwidth"').$formother->select_categories('customer', $search_categ_cus, 'search_categ_cus', 1, $tmptitle);
1633 $moreforfilter .= '</div>';
1634}
1635// alert on due date
1636$moreforfilter .= '<div class="divsearchfield">';
1637$moreforfilter .= '<label for="search_option">'.$langs->trans('Alert').' </label><input type="checkbox" name="search_option" id="search_option" value="late"'.($search_option == 'late' ? ' checked' : '').'>';
1638$moreforfilter .= '</div>';
1639
1640$parameters = array();
1641$reshook = $hookmanager->executeHooks('printFieldPreListTitle', $parameters, $object, $action); // Note that $action and $object may have been modified by hook
1642if (empty($reshook)) {
1643 $moreforfilter .= $hookmanager->resPrint;
1644} else {
1645 $moreforfilter = $hookmanager->resPrint;
1646}
1647
1648if (!empty($moreforfilter)) {
1649 print '<div class="liste_titre liste_titre_bydiv centpercent">';
1650 print $moreforfilter;
1651 print '</div>';
1652}
1653
1654
1655$varpage = empty($contextpage) ? $_SERVER["PHP_SELF"] : $contextpage;
1656$selectedfields = $form->multiSelectArrayWithCheckbox('selectedfields', $arrayfields, $varpage, $conf->main_checkbox_left_column); // This also change content of $arrayfields
1657
1658// Show the massaction checkboxes only when this page is not opened from the Extended POS
1659if ($massactionbutton && $contextpage != 'poslist') {
1660 $selectedfields .= $form->showCheckAddButtons('checkforselect', 1);
1661}
1662
1663print '<div class="div-table-responsive">';
1664print '<table class="tagtable nobottomiftotal liste'.($moreforfilter ? " listwithfilterbefore" : "").'">'."\n";
1665
1666// Fields title search
1667// --------------------------------------------------------------------
1668print '<tr class="liste_titre_filter">';
1669
1670// Action column
1671if ($conf->main_checkbox_left_column) {
1672 print '<td class="liste_titre center maxwidthsearch actioncolumn">';
1673 $searchpicto = $form->showFilterButtons('left');
1674 print $searchpicto;
1675 print '</td>';
1676}
1677
1678if (getDolGlobalString('MAIN_VIEW_LINE_NUMBER_IN_LIST')) {
1679 print '<td class="liste_titre">';
1680 print '</td>';
1681}
1682// Ref
1683if (!empty($arrayfields['f.ref']['checked'])) {
1684 print '<td class="liste_titre">';
1685 print '<input class="flat maxwidth75imp" type="text" name="search_ref" value="'.dol_escape_htmltag($search_ref).'">';
1686 print '</td>';
1687}
1688// Ref customer
1689if (!empty($arrayfields['f.ref_client']['checked'])) {
1690 print '<td class="liste_titre">';
1691 print '<input class="flat maxwidth50imp" type="text" name="search_refcustomer" value="'.dol_escape_htmltag($search_refcustomer).'">';
1692 print '</td>';
1693}
1694// Type
1695if (!empty($arrayfields['f.type']['checked'])) {
1696 print '<td class="liste_titre maxwidthonsmartphone">';
1697 $listtype = array(
1698 Facture::TYPE_STANDARD => $langs->trans("InvoiceStandard"),
1699 Facture::TYPE_DEPOSIT => $langs->trans("InvoiceDeposit"),
1700 Facture::TYPE_CREDIT_NOTE => $langs->trans("InvoiceAvoir"),
1701 Facture::TYPE_REPLACEMENT => $langs->trans("InvoiceReplacement"),
1702 );
1703 if (getDolGlobalString('INVOICE_USE_SITUATION')) {
1704 $listtype[Facture::TYPE_SITUATION] = $langs->trans("InvoiceSituation");
1705 }
1706 //$listtype[Facture::TYPE_PROFORMA]=$langs->trans("InvoiceProForma"); // A proformat invoice is not an invoice but must be an order.
1707 // @phan-suppress-next-line PhanPluginSuspiciousParamOrder
1708 print $form->selectarray('search_type', $listtype, $search_type, 1, 0, 0, '', 0, 0, 0, '', 'maxwidth75');
1709 print '</td>';
1710}
1711// Invoice Subtype
1712if (!empty($arrayfields['f.subtype']['checked'])) {
1713 print '<td class="liste_titre maxwidthonsmartphone" align="center">';
1714 print $form->selectarray('search_subtype', $subtypearray, $search_subtype, 1, 0, 0, '', 0, 0, 0, '', 'maxwidth100');
1715 print '</td>';
1716}
1717// Date invoice
1718if (!empty($arrayfields['f.datef']['checked'])) {
1719 print '<td class="liste_titre center">';
1720 print '<div class="nowrapfordate">';
1721 print $form->selectDate($search_date_start ? $search_date_start : -1, 'search_date_start', 0, 0, 1, '', 1, 0, 0, '', '', '', '', 1, '', $langs->trans('From'));
1722 print '</div>';
1723 print '<div class="nowrapfordate">';
1724 print $form->selectDate($search_date_end ? $search_date_end : -1, 'search_date_end', 0, 0, 1, '', 1, 0, 0, '', '', '', '', 1, '', $langs->trans('to'));
1725 print '</div>';
1726 print '</td>';
1727}
1728// Date valid
1729if (!empty($arrayfields['f.date_valid']['checked'])) {
1730 print '<td class="liste_titre center">';
1731 print '<div class="nowrapfordate">';
1732 print $form->selectDate($search_date_valid_start ? $search_date_valid_start : -1, 'search_date_valid_start', 0, 0, 1, '', 1, 0, 0, '', '', '', '', 1, '', $langs->trans('From'));
1733 print '</div>';
1734 print '<div class="nowrapfordate">';
1735 print $form->selectDate($search_date_valid_end ? $search_date_valid_end : -1, 'search_date_valid_end', 0, 0, 1, '', 1, 0, 0, '', '', '', '', 1, '', $langs->trans('to'));
1736 print '</div>';
1737 print '</td>';
1738}
1739// Date due
1740if (!empty($arrayfields['f.date_lim_reglement']['checked'])) {
1741 print '<td class="liste_titre center">';
1742 print '<div class="nowrapfordate">';
1743 print $form->selectDate($search_datelimit_start ? $search_datelimit_start : -1, 'search_datelimit_start', 0, 0, 1, '', 1, 0, 0, '', '', '', '', 1, '', $langs->trans('From'));
1744 print '</div>';
1745 print '<div class="nowrapfordate">';
1746 print $form->selectDate($search_datelimit_end ? $search_datelimit_end : -1, 'search_datelimit_end', 0, 0, 1, '', 1, 0, 0, '', '', '', '', 1, '', $langs->trans('to'));
1747 print '</div>';
1748 print '</td>';
1749}
1750// Project ref
1751if (!empty($arrayfields['p.ref']['checked'])) {
1752 print '<td class="liste_titre"><input class="flat maxwidth50imp" type="text" name="search_project_ref" value="'.dol_escape_htmltag($search_project_ref).'"></td>';
1753}
1754// Project label
1755if (!empty($arrayfields['p.title']['checked'])) {
1756 print '<td class="liste_titre"><input class="flat maxwidth50imp" type="text" name="search_project" value="'.dol_escape_htmltag($search_project).'"></td>';
1757}
1758// Thirdparty
1759if (!empty($arrayfields['s.nom']['checked'])) {
1760 print '<td class="liste_titre"><input class="flat maxwidth75imp" type="text" name="search_company" value="'.dol_escape_htmltag((string) $search_company).'"'.($socid > 0 ? " disabled" : "").'></td>';
1761}
1762// Alias
1763if (!empty($arrayfields['s.name_alias']['checked'])) {
1764 print '<td class="liste_titre"><input class="flat maxwidth75imp" type="text" name="search_company_alias" value="'.dol_escape_htmltag($search_company_alias).'"></td>';
1765}
1766// Parent company
1767if (!empty($arrayfields['s2.nom']['checked'])) {
1768 print '<td class="liste_titre">';
1769 print '<input class="flat maxwidth100" type="text" name="search_parent_name" value="'.dol_escape_htmltag($search_parent_name).'">';
1770 print '</td>';
1771}
1772// Customer Code
1773if (!empty($arrayfields['s.code_client']['checked'])) {
1774 print '<td class="liste_titre"><input class="flat maxwidth75imp" type="text" name="search_customer_code" value="'.dol_escape_htmltag($search_customer_code).'"></td>';
1775}
1776// Town
1777if (!empty($arrayfields['s.town']['checked'])) {
1778 print '<td class="liste_titre"><input class="flat maxwidth75imp" type="text" name="search_town" value="'.dol_escape_htmltag($search_town).'"></td>';
1779}
1780// Zip
1781if (!empty($arrayfields['s.zip']['checked'])) {
1782 print '<td class="liste_titre"><input class="flat maxwidth50imp" type="text" name="search_zip" value="'.dol_escape_htmltag($search_zip).'"></td>';
1783}
1784// State
1785if (!empty($arrayfields['state.nom']['checked'])) {
1786 print '<td class="liste_titre">';
1787 print '<input class="flat maxwidth50imp" type="text" name="search_state" value="'.dol_escape_htmltag($search_state).'">';
1788 print '</td>';
1789}
1790// Country
1791if (!empty($arrayfields['country.code_iso']['checked'])) {
1792 print '<td class="liste_titre center">';
1793 print $form->select_country($search_country, 'search_country', '', 0, 'minwidth150imp maxwidth150', 'code2', 1, 0, 1, array(), 1);
1794 print '</td>';
1795}
1796// Company type
1797if (!empty($arrayfields['typent.code']['checked'])) {
1798 print '<td class="liste_titre maxwidthonsmartphone center">';
1799 print $form->selectarray("search_type_thirdparty", $formcompany->typent_array(0), $search_type_thirdparty, 1, 0, 0, '', 0, 0, 0, getDolGlobalString('SOCIETE_SORT_ON_TYPEENT', 'ASC'), 'maxwidth100', 1);
1800 print '</td>';
1801}
1802// Payment mode
1803if (!empty($arrayfields['f.fk_mode_reglement']['checked'])) {
1804 print '<td class="liste_titre">';
1805 print $form->select_types_paiements($search_paymentmode, 'search_paymentmode', '', 0, 1, 1, 0, 1, 'minwidth100 maxwidth100', 1);
1806 print '</td>';
1807}
1808// Payment terms
1809if (!empty($arrayfields['f.fk_cond_reglement']['checked'])) {
1810 print '<td class="liste_titre left">';
1811 print $form->getSelectConditionsPaiements((int) $search_paymentterms, 'search_paymentterms', -1, 1, 1, 'minwidth100 maxwidth100');
1812 print '</td>';
1813}
1814// Bank account
1815if (!empty($arrayfields['ba.label']['checked'])) {
1816 print '<td class="liste_titre">';
1817 $form->select_comptes($search_bankaccount, 'search_bankaccount', 0, '', 1, '', 0, 'maxwidth125');
1818 print '</td>';
1819}
1820// Channel
1821if (!empty($arrayfields['f.fk_input_reason']['checked'])) {
1822 print '<td class="liste_titre">';
1823 $form->selectInputReason($search_fk_input_reason, 'search_fk_input_reason', '', 1, '', 1);
1824 print '</td>';
1825}
1826// Module source
1827if (!empty($arrayfields['f.module_source']['checked'])) {
1828 print '<td class="liste_titre">';
1829 print '<input class="flat maxwidth75" type="text" name="search_module_source" value="'.dol_escape_htmltag($search_module_source).'">';
1830 print '</td>';
1831}
1832// POS Terminal
1833if (!empty($arrayfields['f.pos_source']['checked'])) {
1834 print '<td class="liste_titre">';
1835 print '<input class="flat maxwidth50" type="text" name="search_pos_source" value="'.dol_escape_htmltag($search_pos_source).'">';
1836 print '</td>';
1837}
1838if (!empty($arrayfields['f.total_ht']['checked'])) {
1839 // Amount without tax
1840 print '<td class="liste_titre right">';
1841 print '<input class="flat" type="text" size="4" name="search_montant_ht" value="'.dol_escape_htmltag($search_montant_ht).'">';
1842 print '</td>';
1843}
1844if (!empty($arrayfields['f.total_tva']['checked'])) {
1845 // Amount vat
1846 print '<td class="liste_titre right">';
1847 print '<input class="flat" type="text" size="4" name="search_montant_vat" value="'.dol_escape_htmltag($search_montant_vat).'">';
1848 print '</td>';
1849}
1850if (!empty($arrayfields['f.total_localtax1']['checked'])) {
1851 // Localtax1
1852 print '<td class="liste_titre right">';
1853 print '<input class="flat" type="text" size="4" name="search_montant_localtax1" value="'.dol_escape_htmltag($search_montant_localtax1).'">';
1854 print '</td>';
1855}
1856if (!empty($arrayfields['f.total_localtax2']['checked'])) {
1857 // Localtax2
1858 print '<td class="liste_titre right">';
1859 print '<input class="flat" type="text" size="4" name="search_montant_localtax2" value="'.dol_escape_htmltag($search_montant_localtax2).'">';
1860 print '</td>';
1861}
1862if (!empty($arrayfields['f.total_ttc']['checked'])) {
1863 // Amount inc tax
1864 print '<td class="liste_titre right">';
1865 print '<input class="flat" type="text" size="4" name="search_montant_ttc" value="'.dol_escape_htmltag($search_montant_ttc).'">';
1866 print '</td>';
1867}
1868if (!empty($arrayfields['u.login']['checked'])) {
1869 // Author
1870 print '<td class="liste_titre" align="center">';
1871 print '<input class="flat" size="4" type="text" name="search_login" value="'.dol_escape_htmltag($search_login).'">';
1872 print '</td>';
1873}
1874if (!empty($arrayfields['sale_representative']['checked'])) {
1875 print '<td class="liste_titre"></td>';
1876}
1877if (!empty($arrayfields['f.retained_warranty']['checked'])) {
1878 print '<td class="liste_titre" align="right">';
1879 print '</td>';
1880}
1881if (!empty($arrayfields['dynamount_payed']['checked'])) {
1882 print '<td class="liste_titre right">';
1883 print '</td>';
1884}
1885if (!empty($arrayfields['rtp']['checked'])) {
1886 print '<td class="liste_titre">';
1887 print '</td>';
1888}
1889if (!empty($arrayfields['f.multicurrency_code']['checked'])) {
1890 // Currency
1891 print '<td class="liste_titre">';
1892 print $form->selectMultiCurrency($search_multicurrency_code, 'search_multicurrency_code', 1);
1893 print '</td>';
1894}
1895if (!empty($arrayfields['f.multicurrency_tx']['checked'])) {
1896 // Currency rate
1897 print '<td class="liste_titre">';
1898 print '<input class="flat" type="text" size="4" name="search_multicurrency_tx" value="'.dol_escape_htmltag($search_multicurrency_tx).'">';
1899 print '</td>';
1900}
1901if (!empty($arrayfields['f.multicurrency_total_ht']['checked'])) {
1902 // Amount
1903 print '<td class="liste_titre right">';
1904 print '<input class="flat" type="text" size="4" name="search_multicurrency_montant_ht" value="'.dol_escape_htmltag($search_multicurrency_montant_ht).'">';
1905 print '</td>';
1906}
1907if (!empty($arrayfields['f.multicurrency_total_vat']['checked'])) {
1908 // Amount
1909 print '<td class="liste_titre right">';
1910 print '<input class="flat" type="text" size="4" name="search_multicurrency_montant_vat" value="'.dol_escape_htmltag($search_multicurrency_montant_vat).'">';
1911 print '</td>';
1912}
1913if (!empty($arrayfields['f.multicurrency_total_ttc']['checked'])) {
1914 // Amount
1915 print '<td class="liste_titre right">';
1916 print '<input class="flat width75" type="text" name="search_multicurrency_montant_ttc" value="'.dol_escape_htmltag($search_multicurrency_montant_ttc).'">';
1917 print '</td>';
1918}
1919if (!empty($arrayfields['multicurrency_dynamount_payed']['checked'])) {
1920 print '<td class="liste_titre">';
1921 print '</td>';
1922}
1923if (!empty($arrayfields['multicurrency_rtp']['checked'])) {
1924 print '<td class="liste_titre right">';
1925 print '</td>';
1926}
1927if (!empty($arrayfields['total_pa']['checked'])) {
1928 print '<td class="liste_titre right">';
1929 print '</td>';
1930}
1931if (!empty($arrayfields['total_margin']['checked'])) {
1932 print '<td class="liste_titre right">';
1933 print '</td>';
1934}
1935if (!empty($arrayfields['total_margin_rate']['checked'])) {
1936 print '<td class="liste_titre right">';
1937 print '</td>';
1938}
1939if (!empty($arrayfields['total_mark_rate']['checked'])) {
1940 print '<td class="liste_titre right">';
1941 print '</td>';
1942}
1943
1944// Extra fields
1945include DOL_DOCUMENT_ROOT.'/core/tpl/extrafields_list_search_input.tpl.php';
1946
1947// Fields from hook
1948$parameters = array('arrayfields' => $arrayfields);
1949$reshook = $hookmanager->executeHooks('printFieldListOption', $parameters, $object, $action); // Note that $action and $object may have been modified by hook
1950print $hookmanager->resPrint;
1951// Date creation
1952if (!empty($arrayfields['f.datec']['checked'])) {
1953 print '<td class="liste_titre center">';
1954 print '<div class="nowrapfordate">';
1955 print $form->selectDate($search_datec_start ? $search_datec_start : -1, 'search_datec_start', 1, 1, 1, '', 1, 0, 0, '', '', '', '', 1, '', $langs->trans('From'), 'tzuserrel');
1956 print '</div>';
1957 print '<div class="nowrapfordate">';
1958 print $form->selectDate($search_datec_end ? $search_datec_end : -1, 'search_datec_end', 1, 1, 1, '', 1, 0, 0, '', '', '', '', 1, '', $langs->trans('to'), 'tzuserrel');
1959 print '</div>';
1960 print '</td>';
1961}
1962// Date modification
1963if (!empty($arrayfields['f.tms']['checked'])) {
1964 print '<td class="liste_titre center">';
1965 print '<div class="nowrapfordate">';
1966 print $form->selectDate($search_datem_start ? $search_datem_start : -1, 'search_datem_start', 1, 1, 1, '', 1, 0, 0, '', '', '', '', 1, '', $langs->trans('From'), 'tzuserrel');
1967 print '</div>';
1968 print '<div class="nowrapfordate">';
1969 print $form->selectDate($search_datem_end ? $search_datem_end : -1, 'search_datem_end', 1, 1, 1, '', 1, 0, 0, '', '', '', '', 1, '', $langs->trans('to'), 'tzuserrel');
1970 print '</div>';
1971 print '</td>';
1972}
1973// Date closing
1974if (!empty($arrayfields['f.date_closing']['checked'])) {
1975 print '<td class="liste_titre">';
1976 print '</td>';
1977}
1978if (!empty($arrayfields['f.note_public']['checked'])) {
1979 // Note public
1980 print '<td class="liste_titre">';
1981 print '<input class="flat maxwidth75" type="text" name="search_note_public" value="'.dol_escape_htmltag($search_note_public).'">';
1982 print '</td>';
1983}
1984if (!empty($arrayfields['f.note_private']['checked'])) {
1985 // Note private
1986 print '<td class="liste_titre">';
1987 print '<input class="flat maxwidth75" type="text" name="search_note_private" value="'.dol_escape_htmltag($search_note_private).'">';
1988 print '</td>';
1989}
1990if (!empty($arrayfields['f.fk_fac_rec_source']['checked'])) {
1991 // Template Invoice
1992 print '<td class="liste_titre maxwidthonsmartphone right">';
1993 print '<input class="flat maxwidth50imp" type="text" name="search_fac_rec_source_title" id="search_fac_rec_source_title" value="'.dol_escape_htmltag($search_fac_rec_source_title).'">';
1994 print '</td>';
1995}
1996// Import key
1997if (!empty($arrayfields['f.import_key']['checked'])) {
1998 print '<td class="liste_titre maxwidthonsmartphone center">';
1999 print '<input class="flat searchstring maxwidth50" type="text" name="search_import_key" value="'.dol_escape_htmltag($search_import_key).'">';
2000 print '</td>';
2001}
2002// Dispute status
2003if (!empty($arrayfields['f.dispute_status']['checked'])) {
2004 print '<td class="liste_titre center parentonrightofpage">';
2005 $liststatus = Facture::ARRAY_OF_DISPUTE_STATUS;
2006 // @phan-suppress-next-line PhanPluginSuspiciousParamOrder
2007 print $form->selectarray('search_dispute_status', $liststatus, $search_dispute_status, 1, 0, 0, '', 1, 0, 0, '', 'search_status width100 onrightofpage', 1);
2008 print '</td>';
2009}
2010// Status
2011if (!empty($arrayfields['f.fk_statut']['checked'])) {
2012 print '<td class="liste_titre center parentonrightofpage">';
2013 $liststatus = array(
2014 '0' => $langs->trans("BillShortStatusDraft"),
2015 '1' => $langs->trans("BillShortStatusNotPaid"),
2016 '2' => $langs->trans("BillShortStatusPaid"),
2017 '3' => $langs->trans("BillShortStatusCanceled")
2018 );
2019 // @phan-suppress-next-line PhanPluginSuspiciousParamOrder
2020 print $form->multiselectarray('search_status', $liststatus, $search_status, 0, 0, 'minwidth125', 1, 0);
2021 print '</td>';
2022}
2023// Action column
2024if (!$conf->main_checkbox_left_column) {
2025 print '<td class="liste_titre center maxwidthsearch actioncolumn">';
2026 $searchpicto = $form->showFilterButtons();
2027 print $searchpicto;
2028 print '</td>';
2029}
2030print "</tr>\n";
2031
2032$totalarray = array();
2033$totalarray['nbfield'] = 0;
2034
2035// Fields title label
2036// --------------------------------------------------------------------
2037print '<tr class="liste_titre">';
2038// Action column
2039if ($conf->main_checkbox_left_column) {
2040 print_liste_field_titre($selectedfields, $_SERVER["PHP_SELF"], "", '', '', 'align="center"', $sortfield, $sortorder, 'maxwidthsearch ');
2041 $totalarray['nbfield']++;
2042}
2043if (getDolGlobalString('MAIN_VIEW_LINE_NUMBER_IN_LIST')) {
2044 print_liste_field_titre('#', $_SERVER['PHP_SELF'], '', '', $param, '', $sortfield, $sortorder);
2045 $totalarray['nbfield']++;
2046}
2047if (!empty($arrayfields['f.ref']['checked'])) {
2048 print_liste_field_titre($arrayfields['f.ref']['label'], $_SERVER['PHP_SELF'], 'f.ref', '', $param, '', $sortfield, $sortorder);
2049 $totalarray['nbfield']++;
2050}
2051if (!empty($arrayfields['f.ref_client']['checked'])) {
2052 print_liste_field_titre($arrayfields['f.ref_client']['label'], $_SERVER["PHP_SELF"], 'f.ref_client', '', $param, '', $sortfield, $sortorder);
2053 $totalarray['nbfield']++;
2054}
2055if (!empty($arrayfields['f.type']['checked'])) {
2056 print_liste_field_titre($arrayfields['f.type']['label'], $_SERVER["PHP_SELF"], 'f.type', '', $param, '', $sortfield, $sortorder);
2057 $totalarray['nbfield']++;
2058}
2059if (!empty($arrayfields['f.subtype']['checked'])) {
2060 print_liste_field_titre($arrayfields['f.subtype']['label'], $_SERVER["PHP_SELF"], 'f.subtype', '', $param, '', $sortfield, $sortorder);
2061}
2062if (!empty($arrayfields['f.datef']['checked'])) {
2063 print_liste_field_titre($arrayfields['f.datef']['label'], $_SERVER['PHP_SELF'], 'f.datef', '', $param, '', $sortfield, $sortorder, 'center ');
2064 $totalarray['nbfield']++;
2065}
2066if (!empty($arrayfields['f.date_valid']['checked'])) {
2067 print_liste_field_titre($arrayfields['f.date_valid']['label'], $_SERVER['PHP_SELF'], 'f.date_valid', '', $param, '', $sortfield, $sortorder, 'center ');
2068 $totalarray['nbfield']++;
2069}
2070if (!empty($arrayfields['f.date_lim_reglement']['checked'])) {
2071 print_liste_field_titre($arrayfields['f.date_lim_reglement']['label'], $_SERVER['PHP_SELF'], "f.date_lim_reglement", '', $param, '', $sortfield, $sortorder, 'center ');
2072 $totalarray['nbfield']++;
2073}
2074if (!empty($arrayfields['p.ref']['checked'])) {
2075 $langs->load("projects");
2076 print_liste_field_titre($arrayfields['p.ref']['label'], $_SERVER['PHP_SELF'], "p.ref", '', $param, '', $sortfield, $sortorder);
2077 $totalarray['nbfield']++;
2078}
2079if (!empty($arrayfields['p.title']['checked'])) {
2080 print_liste_field_titre($arrayfields['p.title']['label'], $_SERVER['PHP_SELF'], "p.title", '', $param, '', $sortfield, $sortorder);
2081 $totalarray['nbfield']++;
2082}
2083if (!empty($arrayfields['s.nom']['checked'])) {
2084 print_liste_field_titre($arrayfields['s.nom']['label'], $_SERVER['PHP_SELF'], 's.nom', '', $param, '', $sortfield, $sortorder);
2085 $totalarray['nbfield']++;
2086}
2087if (!empty($arrayfields['s.name_alias']['checked'])) {
2088 // False positive @phan-suppress-next-line PhanTypeInvalidDimOffset
2089 print_liste_field_titre($arrayfields['s.name_alias']['label'], $_SERVER['PHP_SELF'], 's.name_alias', '', $param, '', $sortfield, $sortorder);
2090 $totalarray['nbfield']++;
2091}
2092if (!empty($arrayfields['s2.nom']['checked'])) {
2093 print_liste_field_titre($arrayfields['s2.nom']['label'], $_SERVER['PHP_SELF'], 's2.nom', '', $param, '', $sortfield, $sortorder);
2094 $totalarray['nbfield']++;
2095}
2096if (!empty($arrayfields['s.code_client']['checked'])) {
2097 print_liste_field_titre($arrayfields['s.code_client']['label'], $_SERVER['PHP_SELF'], 's.code_client', '', $param, '', $sortfield, $sortorder);
2098 $totalarray['nbfield']++;
2099}
2100if (!empty($arrayfields['s.town']['checked'])) {
2101 print_liste_field_titre($arrayfields['s.town']['label'], $_SERVER["PHP_SELF"], 's.town', '', $param, '', $sortfield, $sortorder);
2102 $totalarray['nbfield']++;
2103}
2104if (!empty($arrayfields['s.zip']['checked'])) {
2105 print_liste_field_titre($arrayfields['s.zip']['label'], $_SERVER["PHP_SELF"], 's.zip', '', $param, '', $sortfield, $sortorder);
2106 $totalarray['nbfield']++;
2107}
2108if (!empty($arrayfields['state.nom']['checked'])) {
2109 print_liste_field_titre($arrayfields['state.nom']['label'], $_SERVER["PHP_SELF"], "state.nom", "", $param, '', $sortfield, $sortorder);
2110 $totalarray['nbfield']++;
2111}
2112if (!empty($arrayfields['country.code_iso']['checked'])) {
2113 print_liste_field_titre($arrayfields['country.code_iso']['label'], $_SERVER["PHP_SELF"], "country.code_iso", "", $param, '', $sortfield, $sortorder, 'center ');
2114 $totalarray['nbfield']++;
2115}
2116if (!empty($arrayfields['typent.code']['checked'])) {
2117 print_liste_field_titre($arrayfields['typent.code']['label'], $_SERVER["PHP_SELF"], "typent.code", "", $param, '', $sortfield, $sortorder, 'center ');
2118 $totalarray['nbfield']++;
2119}
2120if (!empty($arrayfields['f.fk_mode_reglement']['checked'])) {
2121 print_liste_field_titre($arrayfields['f.fk_mode_reglement']['label'], $_SERVER["PHP_SELF"], "f.fk_mode_reglement", "", $param, "", $sortfield, $sortorder);
2122 $totalarray['nbfield']++;
2123}
2124if (!empty($arrayfields['f.fk_cond_reglement']['checked'])) {
2125 print_liste_field_titre($arrayfields['f.fk_cond_reglement']['label'], $_SERVER["PHP_SELF"], "f.fk_cond_reglement", "", $param, "", $sortfield, $sortorder);
2126 $totalarray['nbfield']++;
2127}
2128if (!empty($arrayfields['ba.label']['checked'])) {
2129 print_liste_field_titre($arrayfields['ba.label']['label'], $_SERVER["PHP_SELF"], "ba.label", "", $param, "", $sortfield, $sortorder);
2130 $totalarray['nbfield']++;
2131}
2132if (!empty($arrayfields['f.fk_input_reason']['checked'])) {
2133 print_liste_field_titre($arrayfields['f.fk_input_reason']['label'], $_SERVER['PHP_SELF'], 'f.fk_input_reason', '', $param, '', $sortfield, $sortorder);
2134}
2135if (!empty($arrayfields['f.module_source']['checked'])) {
2136 print_liste_field_titre($arrayfields['f.module_source']['label'], $_SERVER["PHP_SELF"], "f.module_source", "", $param, "", $sortfield, $sortorder);
2137 $totalarray['nbfield']++;
2138}
2139if (!empty($arrayfields['f.pos_source']['checked'])) {
2140 print_liste_field_titre($arrayfields['f.pos_source']['label'], $_SERVER["PHP_SELF"], "f.pos_source", "", $param, "", $sortfield, $sortorder);
2141 $totalarray['nbfield']++;
2142}
2143if (!empty($arrayfields['f.total_ht']['checked'])) {
2144 print_liste_field_titre($arrayfields['f.total_ht']['label'], $_SERVER['PHP_SELF'], 'f.total_ht', '', $param, '', $sortfield, $sortorder, 'right ');
2145 $totalarray['nbfield']++;
2146}
2147if (!empty($arrayfields['f.total_tva']['checked'])) {
2148 print_liste_field_titre($arrayfields['f.total_tva']['label'], $_SERVER['PHP_SELF'], 'f.total_tva', '', $param, '', $sortfield, $sortorder, 'right ');
2149 $totalarray['nbfield']++;
2150}
2151if (!empty($arrayfields['f.total_localtax1']['checked'])) {
2152 print_liste_field_titre($arrayfields['f.total_localtax1']['label'], $_SERVER['PHP_SELF'], 'f.localtax1', '', $param, '', $sortfield, $sortorder, 'right ');
2153 $totalarray['nbfield']++;
2154}
2155if (!empty($arrayfields['f.total_localtax2']['checked'])) {
2156 print_liste_field_titre($arrayfields['f.total_localtax2']['label'], $_SERVER['PHP_SELF'], 'f.localtax2', '', $param, '', $sortfield, $sortorder, 'right ');
2157 $totalarray['nbfield']++;
2158}
2159if (!empty($arrayfields['f.total_ttc']['checked'])) {
2160 print_liste_field_titre($arrayfields['f.total_ttc']['label'], $_SERVER['PHP_SELF'], 'f.total_ttc', '', $param, '', $sortfield, $sortorder, 'right ');
2161 $totalarray['nbfield']++;
2162}
2163if (!empty($arrayfields['u.login']['checked'])) {
2164 print_liste_field_titre($arrayfields['u.login']['label'], $_SERVER["PHP_SELF"], 'u.login', '', $param, '', $sortfield, $sortorder, 'center ');
2165 $totalarray['nbfield']++;
2166}
2167if (!empty($arrayfields['sale_representative']['checked'])) {
2168 print_liste_field_titre($arrayfields['sale_representative']['label'], $_SERVER["PHP_SELF"], "", "", "$param", '', $sortfield, $sortorder);
2169 $totalarray['nbfield']++;
2170}
2171if (!empty($arrayfields['f.retained_warranty']['checked'])) {
2172 print_liste_field_titre($arrayfields['f.retained_warranty']['label'], $_SERVER['PHP_SELF'], '', '', $param, '', $sortfield, $sortorder, 'right ');
2173 $totalarray['nbfield']++;
2174}
2175if (!empty($arrayfields['dynamount_payed']['checked'])) {
2176 print_liste_field_titre($arrayfields['dynamount_payed']['label'], $_SERVER['PHP_SELF'], '', '', $param, '', $sortfield, $sortorder, 'right ');
2177 $totalarray['nbfield']++;
2178}
2179if (!empty($arrayfields['rtp']['checked'])) {
2180 print_liste_field_titre($arrayfields['rtp']['label'], $_SERVER['PHP_SELF'], '', '', $param, '', $sortfield, $sortorder, 'right ');
2181 $totalarray['nbfield']++;
2182}
2183if (!empty($arrayfields['f.multicurrency_code']['checked'])) {
2184 print_liste_field_titre($arrayfields['f.multicurrency_code']['label'], $_SERVER['PHP_SELF'], 'f.multicurrency_code', '', $param, '', $sortfield, $sortorder);
2185 $totalarray['nbfield']++;
2186}
2187if (!empty($arrayfields['f.multicurrency_tx']['checked'])) {
2188 print_liste_field_titre($arrayfields['f.multicurrency_tx']['label'], $_SERVER['PHP_SELF'], 'f.multicurrency_tx', '', $param, '', $sortfield, $sortorder);
2189 $totalarray['nbfield']++;
2190}
2191if (!empty($arrayfields['f.multicurrency_total_ht']['checked'])) {
2192 print_liste_field_titre($arrayfields['f.multicurrency_total_ht']['label'], $_SERVER['PHP_SELF'], 'f.multicurrency_total_ht', '', $param, '', $sortfield, $sortorder, 'right ');
2193 $totalarray['nbfield']++;
2194}
2195if (!empty($arrayfields['f.multicurrency_total_vat']['checked'])) {
2196 print_liste_field_titre($arrayfields['f.multicurrency_total_vat']['label'], $_SERVER['PHP_SELF'], 'f.multicurrency_total_tva', '', $param, '', $sortfield, $sortorder, 'right ');
2197 $totalarray['nbfield']++;
2198}
2199if (!empty($arrayfields['f.multicurrency_total_ttc']['checked'])) {
2200 print_liste_field_titre($arrayfields['f.multicurrency_total_ttc']['label'], $_SERVER['PHP_SELF'], 'f.multicurrency_total_ttc', '', $param, '', $sortfield, $sortorder, 'right ');
2201 $totalarray['nbfield']++;
2202}
2203if (!empty($arrayfields['multicurrency_dynamount_payed']['checked'])) {
2204 print_liste_field_titre($arrayfields['multicurrency_dynamount_payed']['label'], $_SERVER['PHP_SELF'], '', '', $param, '', $sortfield, $sortorder, 'right ');
2205 $totalarray['nbfield']++;
2206}
2207if (!empty($arrayfields['multicurrency_rtp']['checked'])) {
2208 print_liste_field_titre($arrayfields['multicurrency_rtp']['label'], $_SERVER['PHP_SELF'], '', '', $param, '', $sortfield, $sortorder, 'right ');
2209 $totalarray['nbfield']++;
2210}
2211if (!empty($arrayfields['total_pa']['checked'])) {
2212 print_liste_field_titre($arrayfields['total_pa']['label'], $_SERVER['PHP_SELF'], '', '', $param, '', $sortfield, $sortorder, 'right ');
2213 $totalarray['nbfield']++;
2214}
2215if (!empty($arrayfields['total_margin']['checked'])) {
2216 print_liste_field_titre($arrayfields['total_margin']['label'], $_SERVER['PHP_SELF'], '', '', $param, '', $sortfield, $sortorder, 'right ');
2217 $totalarray['nbfield']++;
2218}
2219if (!empty($arrayfields['total_margin_rate']['checked'])) {
2220 print_liste_field_titre($arrayfields['total_margin_rate']['label'], $_SERVER['PHP_SELF'], '', '', $param, '', $sortfield, $sortorder, 'right ');
2221 $totalarray['nbfield']++;
2222}
2223if (!empty($arrayfields['total_mark_rate']['checked'])) {
2224 print_liste_field_titre($arrayfields['total_mark_rate']['label'], $_SERVER['PHP_SELF'], '', '', $param, '', $sortfield, $sortorder, 'right ');
2225 $totalarray['nbfield']++;
2226}
2227// Extra fields
2228include DOL_DOCUMENT_ROOT.'/core/tpl/extrafields_list_search_title.tpl.php';
2229// Hook fields
2230$parameters = array('arrayfields' => $arrayfields, 'param' => $param, 'sortfield' => $sortfield, 'sortorder' => $sortorder, 'totalarray' => &$totalarray);
2231$reshook = $hookmanager->executeHooks('printFieldListTitle', $parameters, $object, $action); // Note that $action and $object may have been modified by hook
2232print $hookmanager->resPrint;
2233if (!empty($arrayfields['f.datec']['checked'])) {
2234 print_liste_field_titre($arrayfields['f.datec']['label'], $_SERVER["PHP_SELF"], "f.datec", "", $param, '', $sortfield, $sortorder, 'nowraponall center ');
2235 $totalarray['nbfield']++;
2236}
2237if (!empty($arrayfields['f.tms']['checked'])) {
2238 print_liste_field_titre($arrayfields['f.tms']['label'], $_SERVER["PHP_SELF"], "f.tms", "", $param, '', $sortfield, $sortorder, 'nowraponall center ');
2239 $totalarray['nbfield']++;
2240}
2241if (!empty($arrayfields['f.date_closing']['checked'])) {
2242 print_liste_field_titre($arrayfields['f.date_closing']['label'], $_SERVER["PHP_SELF"], "f.date_closing", "", $param, '', $sortfield, $sortorder, 'nowraponall center ');
2243 $totalarray['nbfield']++;
2244}
2245if (!empty($arrayfields['f.note_public']['checked'])) {
2246 print_liste_field_titre($arrayfields['f.note_public']['label'], $_SERVER["PHP_SELF"], "f.note_public", "", $param, '', $sortfield, $sortorder, 'center nowrap ');
2247 $totalarray['nbfield']++;
2248}
2249if (!empty($arrayfields['f.note_private']['checked'])) {
2250 print_liste_field_titre($arrayfields['f.note_private']['label'], $_SERVER["PHP_SELF"], "f.note_private", "", $param, '', $sortfield, $sortorder, 'center nowrap ');
2251 $totalarray['nbfield']++;
2252}
2253if (!empty($arrayfields['f.fk_fac_rec_source']['checked'])) {
2254 print_liste_field_titre($arrayfields['f.fk_fac_rec_source']['label'], $_SERVER["PHP_SELF"], "facrec.titre", "", $param, '', $sortfield, $sortorder);
2255 $totalarray['nbfield']++;
2256}
2257// Import key
2258if (!empty($arrayfields['f.import_key']['checked'])) {
2259 print_liste_field_titre($arrayfields['f.import_key']['label'], $_SERVER["PHP_SELF"], "f.import_key", "", $param, '', $sortfield, $sortorder, 'center ');
2260 $totalarray['nbfield']++;
2261}
2262// Dispute status
2263if (!empty($arrayfields['f.dispute_status']['checked'])) {
2264 print_liste_field_titre($arrayfields['f.dispute_status']['label'], $_SERVER["PHP_SELF"], "f.dispute_status,f.ref", "", $param, '', $sortfield, $sortorder, 'center ');
2265 $totalarray['nbfield']++;
2266}
2267// Status
2268if (!empty($arrayfields['f.fk_statut']['checked'])) {
2269 print_liste_field_titre($arrayfields['f.fk_statut']['label'], $_SERVER["PHP_SELF"], "f.fk_statut,f.paye,f.type", "", $param, '', $sortfield, $sortorder, 'center ');
2270 $totalarray['nbfield']++;
2271}
2272// Action column
2273if (!$conf->main_checkbox_left_column) {
2274 print_liste_field_titre($selectedfields, $_SERVER["PHP_SELF"], "", '', $param, '', $sortfield, $sortorder, 'maxwidthsearch center ');
2275 $totalarray['nbfield']++;
2276}
2277
2278print "</tr>\n";
2279
2280$projectstatic = new Project($db);
2281$discount = new DiscountAbsolute($db);
2282$userstatic = new User($db);
2283
2284// Loop on record
2285// --------------------------------------------------------------------
2286if ($num > 0) {
2287 $i = 0;
2288 $savnbfield = $totalarray['nbfield'];
2289 $totalarray = array();
2290 $totalarray['nbfield'] = 0;
2291 $totalarray['val'] = array();
2292 $totalarray['val']['f.total_ht'] = 0;
2293 $totalarray['val']['f.total_tva'] = 0;
2294 $totalarray['val']['f.total_localtax1'] = 0;
2295 $totalarray['val']['f.total_localtax1'] = 0;
2296 $totalarray['val']['f.total_ttc'] = 0;
2297 $totalarray['val']['dynamount_payed'] = 0;
2298 $totalarray['val']['rtp'] = 0;
2299
2300 $typenArray = $formcompany->typent_array(1);
2301
2302 $with_margin_info = false;
2303 if (isModEnabled('margin') && (
2304 !empty($arrayfields['total_pa']['checked'])
2305 || !empty($arrayfields['total_margin']['checked'])
2306 || !empty($arrayfields['total_margin_rate']['checked'])
2307 || !empty($arrayfields['total_mark_rate']['checked'])
2308 )
2309 ) {
2310 $with_margin_info = true;
2311 }
2312 $total_ht = 0;
2313 $total_margin = 0;
2314
2315 $imaxinloop = ($limit ? min($num, $limit) : $num);
2316 while ($i < $imaxinloop) {
2317 $obj = $db->fetch_object($resql);
2318 if (empty($obj)) {
2319 break; // Should not happen
2320 }
2321
2322 $datelimit = $db->jdate($obj->datelimite);
2323
2324 $facturestatic->id = $obj->id;
2325 $facturestatic->ref = $obj->ref;
2326 $facturestatic->ref_client = $obj->ref_client; // deprecated
2327 $facturestatic->ref_customer = $obj->ref_client;
2328 $facturestatic->type = $obj->type;
2329 $facturestatic->subtype = $obj->subtype;
2330 $facturestatic->total_ht = $obj->total_ht;
2331 $facturestatic->total_tva = $obj->total_tva;
2332 $facturestatic->total_ttc = $obj->total_ttc;
2333 $facturestatic->multicurrency_code = $obj->multicurrency_code;
2334 $facturestatic->multicurrency_tx = $obj->multicurrency_tx;
2335 $facturestatic->multicurrency_total_ht = $obj->multicurrency_total_ht;
2336 $facturestatic->multicurrency_total_tva = $obj->multicurrency_total_vat;
2337 $facturestatic->multicurrency_total_ttc = $obj->multicurrency_total_ttc;
2338 $facturestatic->status = $obj->status;
2339 $facturestatic->close_code = $obj->close_code;
2340 $facturestatic->total_ttc = $obj->total_ttc;
2341 $facturestatic->paye = $obj->paye;
2342 $facturestatic->socid = $obj->fk_soc;
2343
2344 $facturestatic->date = $db->jdate($obj->datef);
2345 $facturestatic->date_validation = $db->jdate($obj->date_valid);
2346 $facturestatic->date_lim_reglement = $db->jdate($obj->datelimite);
2347
2348 $facturestatic->note_public = $obj->note_public;
2349 $facturestatic->note_private = $obj->note_private;
2350
2351 if (getDolGlobalString('INVOICE_USE_SITUATION') && getDolGlobalString('INVOICE_USE_RETAINED_WARRANTY')) {
2352 $facturestatic->retained_warranty = $obj->retained_warranty;
2353 $facturestatic->retained_warranty_date_limit = $obj->retained_warranty_date_limit;
2354 $facturestatic->situation_final = $obj->retained_warranty_date_limit;
2355 $facturestatic->situation_final = $obj->retained_warranty_date_limit;
2356 $facturestatic->situation_cycle_ref = $obj->situation_cycle_ref;
2357 $facturestatic->situation_counter = $obj->situation_counter;
2358 }
2359
2360 $facturestatic->payment_reference = $obj->payment_reference;
2361 $facturestatic->dispute_status = $obj->dispute_status;
2362
2363 $companystatic->id = $obj->socid;
2364 $companystatic->name = $obj->name;
2365 $companystatic->name_alias = $obj->alias;
2366 $companystatic->client = $obj->client;
2367 $companystatic->fournisseur = $obj->fournisseur;
2368 $companystatic->code_client = $obj->code_client;
2369 $companystatic->code_compta_client = $obj->code_compta_client;
2370 $companystatic->code_fournisseur = $obj->code_fournisseur;
2371 $companystatic->code_compta_fournisseur = $obj->code_compta_fournisseur;
2372 $companystatic->email = $obj->email;
2373 $companystatic->phone = $obj->phone;
2374 $companystatic->fax = $obj->fax;
2375 $companystatic->address = $obj->address;
2376 $companystatic->zip = $obj->zip;
2377 $companystatic->town = $obj->town;
2378 $companystatic->country_code = $obj->country_code;
2379
2380 $projectstatic->id = $obj->project_id;
2381 $projectstatic->ref = $obj->project_ref;
2382 $projectstatic->title = $obj->project_label;
2383
2384 $paiement = $facturestatic->getSommePaiement();
2385 $totalcreditnotes = $facturestatic->getSumCreditNotesUsed();
2386 $totaldeposits = $facturestatic->getSumDepositsUsed();
2387 $totalallpayments = $paiement + $totalcreditnotes + $totaldeposits;
2388 $remaintopay = $obj->total_ttc - $totalallpayments;
2389
2390 $multicurrency_paiement = $facturestatic->getSommePaiement(1);
2391 $multicurrency_totalcreditnotes = $facturestatic->getSumCreditNotesUsed(1);
2392 $multicurrency_totaldeposits = $facturestatic->getSumDepositsUsed(1);
2393
2394 $totalallpayments = $paiement + $totalcreditnotes + $totaldeposits;
2395 $remaintopay = price2num($facturestatic->total_ttc - $totalallpayments);
2396
2397 $multicurrency_totalpay = $multicurrency_paiement + $multicurrency_totalcreditnotes + $multicurrency_totaldeposits;
2398 $multicurrency_remaintopay = (float) price2num($facturestatic->multicurrency_total_ttc - $multicurrency_totalpay);
2399
2400 if ($facturestatic->status == Facture::STATUS_CLOSED) {
2401 $remaintopay = 0;
2402 $multicurrency_remaintopay = 0;
2403 }
2404 if ($facturestatic->type == Facture::TYPE_CREDIT_NOTE && $obj->paye == 1) { // If credit note closed, we take into account the amount not yet consumed
2405 $remaincreditnote = $discount->getAvailableDiscounts($companystatic, null, 'rc.fk_facture_source='.$facturestatic->id);
2406 $remaintopay = -$remaincreditnote;
2407 $totalallpayments = price2num($facturestatic->total_ttc - $remaintopay);
2408 $multicurrency_remaincreditnote = $discount->getAvailableDiscounts($companystatic, null, 'rc.fk_facture_source='.$facturestatic->id, 0, 0, 1);
2409 $multicurrency_remaintopay = -$multicurrency_remaincreditnote;
2410 $multicurrency_totalpay = (float) price2num($facturestatic->multicurrency_total_ttc - $multicurrency_remaintopay);
2411 }
2412
2413 $facturestatic->alreadypaid = $paiement;
2414 $facturestatic->totalpaid = $paiement;
2415 $facturestatic->totalcreditnotes = $totalcreditnotes;
2416 $facturestatic->totaldeposits = $totaldeposits;
2417
2418 $marginInfo = array();
2419 if ($with_margin_info) {
2420 $facturestatic->fetch_lines();
2421 $marginInfo = $formmargin->getMarginInfosArray($facturestatic);
2422 $total_ht += $obj->total_ht;
2423 $total_margin += $marginInfo['total_margin'];
2424 }
2425
2426 $object = $facturestatic;
2427
2428 if ($mode == 'kanban') {
2429 if ($i == 0) {
2430 print '<tr class="trkanban"><td colspan="'.$savnbfield.'">';
2431 print '<div class="box-flex-container kanban">';
2432 }
2433 // Output Kanban
2434 if ($massactionbutton || $massaction) { // If we are in select mode (massactionbutton defined) or if we have already selected and sent an action ($massaction) defined
2435 $selected = 0;
2436 if (in_array($object->id, $arrayofselected)) {
2437 $selected = 1;
2438 }
2439 }
2440
2441 $arraydata = array('alreadypaid' => $paiement, 'thirdparty' => $companystatic->getNomUrl(1, '', 12), 'userauthor' => $userstatic->getNomUrl(1), 'selected' => in_array($object->id, $arrayofselected));
2442 print $facturestatic->getKanbanView('', $arraydata);
2443 if ($i == ($imaxinloop - 1)) {
2444 print '</div>';
2445 print '</td></tr>';
2446 }
2447 } else {
2448 // Show line of result
2449 $j = 0;
2450 print '<tr data-rowid="'.$object->id.'" class="oddeven row-with-select status'.$object->status.((getDolGlobalInt('MAIN_FINISHED_LINES_OPACITY') == 1 && $obj->status > 1) ? ' opacitymedium' : '').'"';
2451 if ($contextpage == 'poslist') {
2452 print ' onclick="parent.$(\'#poslines\').load(\'invoice.php?action=history&placeid='.$obj->id.'\', function() {parent.$.colorbox.close();';
2453 if (strpos($obj->ref, 'PROV') !== false) {
2454 //If is a draft invoice, load var to be able to add products
2455 $place = str_replace(")", "", str_replace("(PROV-POS".$_SESSION["takeposterminal"]."-", "", $obj->ref));
2456 print 'parent.place=\''.dol_escape_js($place).'\'';
2457 }
2458 print '});"';
2459 }
2460 print '>';
2461
2462 // Action column
2463 if ($conf->main_checkbox_left_column) {
2464 print '<td class="nowrap center">';
2465 if (($massactionbutton || $massaction) && $contextpage != 'poslist') { // If we are in select mode (massactionbutton defined) or if we have already selected and sent an action ($massaction) defined
2466 $selected = 0;
2467 if (in_array($obj->id, $arrayofselected)) {
2468 $selected = 1;
2469 }
2470 print '<input id="cb'.$obj->id.'" class="flat checkforselect" type="checkbox" name="toselect[]" value="'.$obj->id.'"'.($selected ? ' checked="checked"' : '').'>';
2471 }
2472 print '</td>';
2473 if (!$i) {
2474 $totalarray['nbfield']++;
2475 }
2476 }
2477
2478 // No
2479 if (getDolGlobalString('MAIN_VIEW_LINE_NUMBER_IN_LIST')) {
2480 print '<td>'.(($offset * $limit) + $i).'</td>';
2481 if (!$i) {
2482 $totalarray['nbfield']++;
2483 }
2484 }
2485
2486 // Ref
2487 if (!empty($arrayfields['f.ref']['checked'])) {
2488 print '<td class="nowraponall">';
2489
2490 print '<table class="nobordernopadding"><tr class="nocellnopadd">';
2491
2492 print '<td class="nobordernopadding nowraponall">';
2493 if ($contextpage == 'poslist') {
2494 print dolPrintHTML($obj->ref);
2495 } else {
2496 print $facturestatic->getNomUrl(1, '', 200, 0, '', 0, 1);
2497 }
2498
2499 $filename = dol_sanitizeFileName($obj->ref);
2500 $filepath = $conf->invoice->multidir_output[$obj->entity] ?? $conf->invoice->dir_output;
2501 $filedir = $filepath.'/'.$filename;
2502
2503 $urlsource = $_SERVER['PHP_SELF'].'?id='.$obj->id;
2504 print $formfile->getDocumentsLink($facturestatic->element, $filename, $filedir);
2505 print '</td>';
2506 print '</tr>';
2507 print '</table>';
2508
2509 print "</td>\n";
2510 if (!$i) {
2511 $totalarray['nbfield']++;
2512 }
2513 }
2514
2515 // Customer ref
2516 if (!empty($arrayfields['f.ref_client']['checked'])) {
2517 $tdcss = (getDolGlobalInt('MAIN_SHOW_GLOBAL_REF_CUSTOMER_SUPPLIER') ? 'class="minwidth400 maxwidth400"' : 'class="nowrap tdoverflowmax200"');
2518 print '<td title="'.dolPrintHTMLForAttribute($obj->ref_client).'" '.$tdcss.'>';
2519 print dol_escape_htmltag($obj->ref_client);
2520 print '</td>';
2521 if (!$i) {
2522 $totalarray['nbfield']++;
2523 }
2524 }
2525
2526 // Type
2527 if (!empty($arrayfields['f.type']['checked'])) {
2528 print '<td class="nowraponall tdoverflowmax100" title="'.$facturestatic->getLibType().'">';
2529 print $facturestatic->getLibType(2);
2530 print "</td>";
2531 if (!$i) {
2532 $totalarray['nbfield']++;
2533 }
2534 }
2535
2536 // Invoice Subtype
2537 if (!empty($arrayfields['f.subtype']['checked'])) {
2538 $labeltoshow = '';
2539 if ($facturestatic->subtype > 0) {
2540 $labeltoshow = $facturestatic->getSubtypeLabel('facture');
2541 }
2542 print '<td class="nowraponall tdoverflowmax300" title="'.$labeltoshow.'">';
2543 print $labeltoshow;
2544 print "</td>";
2545 if (!$i) {
2546 $totalarray['nbfield']++;
2547 }
2548 }
2549
2550 // Date
2551 if (!empty($arrayfields['f.datef']['checked'])) {
2552 print '<td align="center" class="nowraponall">';
2553 print dol_print_date($db->jdate($obj->datef), 'day');
2554 print '</td>';
2555 if (!$i) {
2556 $totalarray['nbfield']++;
2557 }
2558 }
2559
2560 // Date
2561 if (!empty($arrayfields['f.date_valid']['checked'])) {
2562 print '<td align="center" class="nowraponall">';
2563 print dol_print_date($db->jdate($obj->date_valid), 'day');
2564 print '</td>';
2565 if (!$i) {
2566 $totalarray['nbfield']++;
2567 }
2568 }
2569
2570 // Date limit
2571 if (!empty($arrayfields['f.date_lim_reglement']['checked'])) {
2572 print '<td align="center" class="nowraponall">'.dol_print_date($datelimit, 'day');
2573 if ($facturestatic->hasDelay()) {
2574 print img_warning($langs->trans('Alert').' - '.$langs->trans('Late'));
2575 }
2576 print '</td>';
2577 if (!$i) {
2578 $totalarray['nbfield']++;
2579 }
2580 }
2581
2582 // Project ref
2583 if (!empty($arrayfields['p.ref']['checked'])) {
2584 print '<td class="nocellnopadd nowraponall">';
2585 if ($obj->project_id > 0) {
2586 print $projectstatic->getNomUrl(1);
2587 }
2588 print '</td>';
2589 if (!$i) {
2590 $totalarray['nbfield']++;
2591 }
2592 }
2593
2594 // Project label
2595 if (!empty($arrayfields['p.title']['checked'])) {
2596 print '<td class="nowraponall">';
2597 if ($obj->project_id > 0) {
2598 print dol_escape_htmltag($projectstatic->title);
2599 }
2600 print '</td>';
2601 if (!$i) {
2602 $totalarray['nbfield']++;
2603 }
2604 }
2605
2606 // Third party
2607 if (!empty($arrayfields['s.nom']['checked'])) {
2608 print '<td class="tdoverflowmax150">';
2609 if ($contextpage == 'poslist') {
2610 print dol_escape_htmltag($companystatic->name);
2611 } else {
2612 print $companystatic->getNomUrl(1, 'customer', 0, 0, -1, empty($arrayfields['s.name_alias']['checked']) ? 0 : 1);
2613 }
2614 print '</td>';
2615 if (!$i) {
2616 $totalarray['nbfield']++;
2617 }
2618 }
2619 // Alias name
2620 if (!empty($arrayfields['s.name_alias']['checked'])) {
2621 print '<td class="tdoverflowmax150" title="'.dol_escape_htmltag($companystatic->name_alias).'">';
2622 print dol_escape_htmltag($companystatic->name_alias);
2623 print '</td>';
2624 if (!$i) {
2625 $totalarray['nbfield']++;
2626 }
2627 }
2628 // Parent company
2629 if (!empty($arrayfields['s2.nom']['checked'])) {
2630 print '<td class="tdoverflowmax200">';
2631 if ($obj->fk_parent > 0) {
2632 if (!isset($company_url_list[$obj->fk_parent])) {
2633 $companyparent = new Societe($db);
2634 $res = $companyparent->fetch($obj->fk_parent);
2635 if ($res > 0) {
2636 $company_url_list[$obj->fk_parent] = $companyparent->getNomUrl(1);
2637 }
2638 }
2639 if (isset($company_url_list[$obj->fk_parent])) {
2640 print $company_url_list[$obj->fk_parent];
2641 }
2642 }
2643 print "</td>";
2644 if (!$i) {
2645 $totalarray['nbfield']++;
2646 }
2647 }
2648 // Customer Code
2649 if (!empty($arrayfields['s.code_client']['checked'])) {
2650 print '<td class="tdoverflowmax150" title="'.dol_escape_htmltag($companystatic->code_client).'">';
2651 print dol_escape_htmltag($companystatic->code_client);
2652 print '</td>';
2653 if (!$i) {
2654 $totalarray['nbfield']++;
2655 }
2656 }
2657 // Town
2658 if (!empty($arrayfields['s.town']['checked'])) {
2659 print '<td class="tdoverflowmax100" title="'.dol_escape_htmltag($obj->town).'">';
2660 print dolPrintLabel($obj->town);
2661 print '</td>';
2662 if (!$i) {
2663 $totalarray['nbfield']++;
2664 }
2665 }
2666 // Zip
2667 if (!empty($arrayfields['s.zip']['checked'])) {
2668 print '<td class="nowraponall">';
2669 print dolPrintLabel($obj->zip);
2670 print '</td>';
2671 if (!$i) {
2672 $totalarray['nbfield']++;
2673 }
2674 }
2675 // State
2676 if (!empty($arrayfields['state.nom']['checked'])) {
2677 print '<td class="tdoverflowmax100" title="'.dol_escape_htmltag($obj->state_name).'">'.dol_escape_htmltag($obj->state_name)."</td>\n";
2678 if (!$i) {
2679 $totalarray['nbfield']++;
2680 }
2681 }
2682 // Country
2683 if (!empty($arrayfields['country.code_iso']['checked'])) {
2684 $tmparray = getCountry($obj->fk_pays, 'all');
2685 print '<td class="center tdoverflowmax100" title="'.dol_escape_htmltag($tmparray['label']).'">';
2686 print dolPrintLabel($tmparray['label']);
2687 print '</td>';
2688 if (!$i) {
2689 $totalarray['nbfield']++;
2690 }
2691 }
2692 // Type ent
2693 if (!empty($arrayfields['typent.code']['checked'])) {
2694 if (!is_array($typenArray) || count($typenArray) == 0) {
2695 $typenArray = $formcompany->typent_array(1);
2696 }
2697 print '<td class="center tdoverflowmax100" title="'.dolPrintHTMLForAttribute($typenArray[$obj->typent_code]).'">';
2698 if (!empty($obj->typent_code)) {
2699 print $typenArray[$obj->typent_code];
2700 }
2701 print '</td>';
2702 if (!$i) {
2703 $totalarray['nbfield']++;
2704 }
2705 }
2706 // Staff
2707 if (!empty($arrayfields['staff.code']['checked'])) {
2708 if (!is_array($conf->cache['staff']) || count($conf->cache['staff']) == 0) {
2709 $conf->cache['staff'] = $formcompany->effectif_array(1);
2710 }
2711 print '<td class="center tdoverflowmax100" title="'.dolPrintHTML($conf->cache['staff'][$obj->staff_code]).'">';
2712 print $conf->cache['staff'][$obj->staff_code];
2713 print '</td>';
2714 if (!$i) {
2715 $totalarray['nbfield']++;
2716 }
2717 }
2718
2719 // Payment mode
2720 if (!empty($arrayfields['f.fk_mode_reglement']['checked'])) {
2721 $s = $form->form_modes_reglement($_SERVER['PHP_SELF'], $obj->fk_mode_reglement, 'none', '', -1, 0, '', 1);
2722 print '<td class="tdoverflowmax100" title="'.dol_escape_htmltag($s).'">';
2723 print $s;
2724 print '</td>';
2725 if (!$i) {
2726 $totalarray['nbfield']++;
2727 }
2728 }
2729
2730 // Payment terms
2731 if (!empty($arrayfields['f.fk_cond_reglement']['checked'])) {
2732 $s = $form->form_conditions_reglement($_SERVER['PHP_SELF'], $obj->fk_cond_reglement, 'none', 0, '', -1, -1, 1);
2733 print '<td class="tdoverflowmax100" title="'.dol_escape_htmltag($s).'">';
2734 print $s;
2735 print '</td>';
2736 if (!$i) {
2737 $totalarray['nbfield']++;
2738 }
2739 }
2740
2741 // Bank account
2742 if (!empty($arrayfields['ba.label']['checked'])) {
2743 print '<td>';
2744 if (!empty($obj->bid)) {
2745 $accountstatic->id = $obj->bid;
2746 $accountstatic->ref = $obj->bref;
2747 $accountstatic->label = $obj->blabel;
2748 $accountstatic->number = $obj->bnumber;
2749 $accountstatic->account_number = $obj->baccount_number;
2750 $accountstatic->accountancy_journal = $obj->baccountancy_journal;
2751 print $accountstatic->getNomUrl(1);
2752 }
2753 print '</td>';
2754 if (!$i) {
2755 $totalarray['nbfield']++;
2756 }
2757 }
2758
2759 // Input channel
2760 if (!empty($arrayfields['f.fk_input_reason']['checked'])) {
2761 print '<td>';
2762 $form->formInputReason($_SERVER['PHP_SELF'], (string) $obj->fk_input_reason, 'none');
2763 print '</td>';
2764 if (!$i) {
2765 $totalarray['nbfield']++;
2766 }
2767 }
2768
2769 // Module Source
2770 if (!empty($arrayfields['f.module_source']['checked'])) {
2771 print '<td>';
2772 print dol_escape_htmltag($obj->module_source);
2773 print '</td>';
2774 if (!$i) {
2775 $totalarray['nbfield']++;
2776 }
2777 }
2778 // POS Terminal
2779 if (!empty($arrayfields['f.pos_source']['checked'])) {
2780 print '<td>';
2781 print dol_escape_htmltag($obj->pos_source);
2782 print '</td>';
2783 if (!$i) {
2784 $totalarray['nbfield']++;
2785 }
2786 }
2787
2788 // Amount HT
2789 if (!empty($arrayfields['f.total_ht']['checked'])) {
2790 print '<td class="right nowraponall"><span class="amount">'.price($obj->total_ht)."</span></td>\n";
2791 if (!$i) {
2792 $totalarray['nbfield']++;
2793 }
2794 if (!$i) {
2795 $totalarray['pos'][$totalarray['nbfield']] = 'f.total_ht';
2796 }
2797 $totalarray['val']['f.total_ht'] += $obj->total_ht;
2798 }
2799 // Amount VAT
2800 if (!empty($arrayfields['f.total_tva']['checked'])) {
2801 print '<td class="right nowraponall amount">'.price($obj->total_tva)."</td>\n";
2802 if (!$i) {
2803 $totalarray['nbfield']++;
2804 }
2805 if (!$i) {
2806 $totalarray['pos'][$totalarray['nbfield']] = 'f.total_tva';
2807 }
2808 $totalarray['val']['f.total_tva'] += $obj->total_tva;
2809 }
2810 // Amount LocalTax1
2811 if (!empty($arrayfields['f.total_localtax1']['checked'])) {
2812 print '<td class="right nowraponall amount">'.price($obj->total_localtax1)."</td>\n";
2813 if (!$i) {
2814 $totalarray['nbfield']++;
2815 }
2816 if (!$i) {
2817 $totalarray['pos'][$totalarray['nbfield']] = 'f.total_localtax1';
2818 }
2819 $totalarray['val']['f.total_localtax1'] += $obj->total_localtax1;
2820 }
2821 // Amount LocalTax2
2822 if (!empty($arrayfields['f.total_localtax2']['checked'])) {
2823 print '<td class="right nowraponall amount">'.price($obj->total_localtax2)."</td>\n";
2824 if (!$i) {
2825 $totalarray['nbfield']++;
2826 }
2827 if (!$i) {
2828 $totalarray['pos'][$totalarray['nbfield']] = 'f.total_localtax2';
2829 }
2830 $totalarray['val']['f.total_localtax2'] += $obj->total_localtax2;
2831 }
2832 // Amount TTC
2833 if (!empty($arrayfields['f.total_ttc']['checked'])) {
2834 print '<td class="right nowraponall amount">'.price($obj->total_ttc)."</td>\n";
2835 if (!$i) {
2836 $totalarray['nbfield']++;
2837 }
2838 if (!$i) {
2839 $totalarray['pos'][$totalarray['nbfield']] = 'f.total_ttc';
2840 }
2841 $totalarray['val']['f.total_ttc'] += $obj->total_ttc;
2842 }
2843
2844 $userstatic->id = $obj->fk_user_author;
2845 $userstatic->login = $obj->login;
2846 $userstatic->lastname = $obj->lastname;
2847 $userstatic->firstname = $obj->firstname;
2848 $userstatic->email = $obj->user_email;
2849 $userstatic->status = $obj->user_statut;
2850 $userstatic->entity = $obj->entity;
2851 $userstatic->photo = $obj->photo;
2852 $userstatic->office_phone = $obj->office_phone;
2853 $userstatic->office_fax = $obj->office_fax;
2854 $userstatic->user_mobile = $obj->user_mobile;
2855 $userstatic->job = $obj->job;
2856 $userstatic->gender = $obj->gender;
2857
2858 // Author
2859 if (!empty($arrayfields['u.login']['checked'])) {
2860 print '<td class="tdoverflowmax100">';
2861 if ($userstatic->id) {
2862 print $userstatic->getNomUrl(-1);
2863 } else {
2864 print '&nbsp;';
2865 }
2866 print "</td>\n";
2867 if (!$i) {
2868 $totalarray['nbfield']++;
2869 }
2870 }
2871
2872 if (!empty($arrayfields['sale_representative']['checked'])) {
2873 // Sales representatives
2874 print '<td>';
2875 if ($obj->socid > 0) {
2876 $listsalesrepresentatives = $companystatic->getSalesRepresentatives($user);
2877 if ($listsalesrepresentatives < 0) {
2879 }
2880 $nbofsalesrepresentative = count($listsalesrepresentatives);
2881 if ($nbofsalesrepresentative > 6) {
2882 // We print only number
2883 print $nbofsalesrepresentative;
2884 } elseif ($nbofsalesrepresentative > 0) {
2885 $j = 0;
2886 foreach ($listsalesrepresentatives as $val) {
2887 $userstatic->id = $val['id'];
2888 $userstatic->lastname = $val['lastname'];
2889 $userstatic->firstname = $val['firstname'];
2890 $userstatic->email = $val['email'];
2891 $userstatic->status = $val['statut'];
2892 $userstatic->entity = $val['entity'];
2893 $userstatic->photo = $val['photo'];
2894 $userstatic->login = $val['login'];
2895 $userstatic->office_phone = $val['office_phone'];
2896 $userstatic->office_fax = $val['office_fax'];
2897 $userstatic->user_mobile = $val['user_mobile'];
2898 $userstatic->job = $val['job'];
2899 $userstatic->gender = $val['gender'];
2900 //print '<div class="float">':
2901 print ($nbofsalesrepresentative < 2) ? $userstatic->getNomUrl(-1, '', 0, 0, 12) : $userstatic->getNomUrl(-2);
2902 $j++;
2903 if ($j < $nbofsalesrepresentative) {
2904 print ' ';
2905 }
2906 //print '</div>';
2907 }
2908 }
2909 //else print $langs->trans("NoSalesRepresentativeAffected");
2910 }
2911 print '</td>';
2912 if (!$i) {
2913 $totalarray['nbfield']++;
2914 }
2915 }
2916
2917 if (!empty($arrayfields['f.retained_warranty']['checked'])) {
2918 print '<td align="right">'.(!empty($obj->retained_warranty) ? price($obj->retained_warranty).'%' : '&nbsp;').'</td>';
2919 if (!$i) {
2920 $totalarray['nbfield']++;
2921 }
2922 }
2923
2924 if (!empty($arrayfields['dynamount_payed']['checked'])) {
2925 print '<td class="right nowraponall amount">'.(!empty($totalallpayments) ? price($totalallpayments, 0, $langs) : '&nbsp;').'</td>'; // TODO Use a denormalized field
2926 if (!$i) {
2927 $totalarray['nbfield']++;
2928 }
2929 if (!$i) {
2930 $totalarray['pos'][$totalarray['nbfield']] = 'dynamount_payed';
2931 }
2932 $totalarray['val']['dynamount_payed'] += $totalallpayments;
2933 }
2934
2935 // Pending amount
2936 if (!empty($arrayfields['rtp']['checked'])) {
2937 print '<td class="right nowraponall amount">';
2938 print(!empty($remaintopay) ? price($remaintopay, 0, $langs) : '&nbsp;');
2939 print '</td>'; // TODO Use a denormalized field
2940 if (!$i) {
2941 $totalarray['nbfield']++;
2942 }
2943 if (!$i) {
2944 $totalarray['pos'][$totalarray['nbfield']] = 'rtp';
2945 }
2946 $totalarray['val']['rtp'] += $remaintopay;
2947 }
2948
2949
2950 // Currency
2951 if (!empty($arrayfields['f.multicurrency_code']['checked'])) {
2952 if (!getDolGlobalString('MAIN_SHOW_ONLY_CODE_MULTICURRENCY') && !empty($obj->multicurrency_code)) {
2953 $title = $obj->multicurrency_code.' - '.$langs->transnoentitiesnoconv('Currency'.$obj->multicurrency_code);
2954 $label = $langs->transnoentitiesnoconv('Currency'.$obj->multicurrency_code);
2955 } else {
2956 $title = $obj->multicurrency_code;
2957 $label = $obj->multicurrency_code;
2958 }
2959 print '<td class="nowraponall tdoverflowmax125" title="'.dolPrintHTMLForAttribute($title).'">';
2960 print dolPrintHTML($label);
2961 print "</td>\n";
2962 if (!$i) {
2963 $totalarray['nbfield']++;
2964 }
2965 }
2966
2967 // Currency rate
2968 if (!empty($arrayfields['f.multicurrency_tx']['checked'])) {
2969 print '<td class="nowraponall">';
2970 $form->form_multicurrency_rate($_SERVER['PHP_SELF'].'?id='.$obj->id, $obj->multicurrency_tx, 'none', $obj->multicurrency_code);
2971 print "</td>\n";
2972 if (!$i) {
2973 $totalarray['nbfield']++;
2974 }
2975 }
2976 // Amount HT
2977 if (!empty($arrayfields['f.multicurrency_total_ht']['checked'])) {
2978 print '<td class="right nowraponall amount">'.price($obj->multicurrency_total_ht)."</td>\n";
2979 if (!$i) {
2980 $totalarray['nbfield']++;
2981 }
2982 }
2983 // Amount VAT
2984 if (!empty($arrayfields['f.multicurrency_total_vat']['checked'])) {
2985 print '<td class="right nowraponall amount">'.price($obj->multicurrency_total_vat)."</td>\n";
2986 if (!$i) {
2987 $totalarray['nbfield']++;
2988 }
2989 }
2990 // Amount TTC
2991 if (!empty($arrayfields['f.multicurrency_total_ttc']['checked'])) {
2992 print '<td class="right nowraponall amount">'.price($obj->multicurrency_total_ttc)."</td>\n";
2993 if (!$i) {
2994 $totalarray['nbfield']++;
2995 }
2996 }
2997 // Dyn amount
2998 if (!empty($arrayfields['multicurrency_dynamount_payed']['checked'])) {
2999 print '<td class="right nowraponall amount">'.(!empty($multicurrency_totalpay) ? price($multicurrency_totalpay, 0, $langs) : '&nbsp;').'</td>'; // TODO Use a denormalized field
3000 if (!$i) {
3001 $totalarray['nbfield']++;
3002 }
3003 }
3004
3005 // Pending amount
3006 if (!empty($arrayfields['multicurrency_rtp']['checked'])) {
3007 print '<td class="right nowraponall amount">';
3008 print(!empty($multicurrency_remaintopay) ? price($multicurrency_remaintopay, 0, $langs) : '&nbsp;');
3009 print '</td>'; // TODO Use a denormalized field ?
3010 if (!$i) {
3011 $totalarray['nbfield']++;
3012 }
3013 }
3014
3015 // Total buying or cost price
3016 if (!empty($arrayfields['total_pa']['checked'])) {
3017 print '<td class="right nowrap">'.price($marginInfo['pa_total'], 0, $langs, 1, -1, 'MT').'</td>';
3018 if (!$i) {
3019 $totalarray['nbfield']++;
3020 $totalarray['pos'][$totalarray['nbfield']] = 'total_pa';
3021 }
3022 if (empty($totalarray['val']['total_pa'])) {
3023 $totalarray['val']['total_pa'] = 0;
3024 }
3025 $totalarray['val']['total_pa'] += $marginInfo['pa_total'];
3026 }
3027 // Total margin
3028 if (!empty($arrayfields['total_margin']['checked'])) {
3029 print '<td class="right nowrap">'.price($marginInfo['total_margin'], 0, $langs, 1, -1, 'MT').'</td>';
3030 if (!$i) {
3031 $totalarray['nbfield']++;
3032 $totalarray['pos'][$totalarray['nbfield']] = 'total_margin';
3033 }
3034 if (empty($totalarray['val']['total_margin'])) {
3035 $totalarray['val']['total_margin'] = 0;
3036 }
3037 $totalarray['val']['total_margin'] += $marginInfo['total_margin'];
3038 }
3039 // Total margin rate
3040 if (!empty($arrayfields['total_margin_rate']['checked'])) {
3041 print '<td class="right nowrap">'.(($marginInfo['total_margin_rate'] == '') ? '' : price($marginInfo['total_margin_rate'], 0, '', 0, 0, 2).'%').'</td>';
3042 if (!$i) {
3043 $totalarray['nbfield']++;
3044 }
3045 }
3046 // Total mark rate
3047 if (!empty($arrayfields['total_mark_rate']['checked'])) {
3048 print '<td class="right nowrap">'.(($marginInfo['total_mark_rate'] == '') ? '' : price($marginInfo['total_mark_rate'], 0, '', 0, 0, 2).'%').'</td>';
3049 if (!$i) {
3050 $totalarray['nbfield']++;
3051 $totalarray['pos'][$totalarray['nbfield']] = 'total_mark_rate';
3052 }
3053 if ($i >= $imaxinloop - 1) {
3054 if (!empty($total_ht)) {
3055 $totalarray['val']['total_mark_rate'] = price2num($total_margin * 100 / $total_ht, 'MT');
3056 } else {
3057 $totalarray['val']['total_mark_rate'] = '';
3058 }
3059 }
3060 }
3061
3062 // Extra fields
3063 include DOL_DOCUMENT_ROOT.'/core/tpl/extrafields_list_print_fields.tpl.php';
3064 // Fields from hook
3065 $parameters = array('arrayfields' => $arrayfields, 'obj' => $obj, 'i' => $i, 'totalarray' => &$totalarray);
3066 $reshook = $hookmanager->executeHooks('printFieldListValue', $parameters, $object, $action); // Note that $action and $object may have been modified by hook
3067 print $hookmanager->resPrint;
3068 // Date creation
3069 if (!empty($arrayfields['f.datec']['checked'])) {
3070 print '<td class="nowraponall center">';
3071 print dol_print_date($db->jdate($obj->date_creation), 'dayhour', 'tzuserrel');
3072 print '</td>';
3073 if (!$i) {
3074 $totalarray['nbfield']++;
3075 }
3076 }
3077 // Date modification
3078 if (!empty($arrayfields['f.tms']['checked'])) {
3079 print '<td class="nowraponall center">';
3080 print dol_print_date($db->jdate($obj->date_modification), 'dayhour', 'tzuserrel');
3081 print '</td>';
3082 if (!$i) {
3083 $totalarray['nbfield']++;
3084 }
3085 }
3086 // Date closing
3087 if (!empty($arrayfields['f.date_closing']['checked'])) {
3088 print '<td class="nowraponall center">';
3089 print dol_print_date($db->jdate($obj->date_closing), 'dayhour', 'tzuserrel');
3090 print '</td>';
3091 if (!$i) {
3092 $totalarray['nbfield']++;
3093 }
3094 }
3095 // Note public
3096 if (!empty($arrayfields['f.note_public']['checked'])) {
3097 print '<td class="sensiblehtmlcontent center">';
3098 print '<div class="small lineheightsmall twolinesmax-normallineheight">'.dolPrintHTML(dolGetFirstLineOfText($obj->note_public, 5)).'</div>';
3099 print '</td>';
3100 if (!$i) {
3101 $totalarray['nbfield']++;
3102 }
3103 }
3104 // Note private
3105 if (!empty($arrayfields['f.note_private']['checked'])) {
3106 print '<td class="sensiblehtmlcontent center">';
3107 print '<div class="small lineheightsmall twolinesmax-normallineheight">'.dolPrintHTML(dolGetFirstLineOfText($obj->note_private, 5)).'</div>';
3108 print '</td>';
3109 if (!$i) {
3110 $totalarray['nbfield']++;
3111 }
3112 }
3113 // Template Invoice
3114 if (!empty($arrayfields['f.fk_fac_rec_source']['checked'])) {
3115 print '<td class="center">';
3116 if (!empty($obj->fk_fac_rec_source)) {
3117 $facrec = new FactureRec($db);
3118 $result = $facrec->fetch($obj->fk_fac_rec_source);
3119 if ($result < 0) {
3120 setEventMessages($facrec->error, $facrec->errors, 'errors');
3121 } else {
3122 print $facrec->getNomUrl();
3123 }
3124 }
3125 print '</td>';
3126 if (!$i) {
3127 $totalarray['nbfield']++;
3128 }
3129 }
3130
3131 // Import key
3132 if (!empty($arrayfields['f.import_key']['checked'])) {
3133 print '<td class="nowrap center">'.dol_escape_htmltag($obj->import_key).'</td>';
3134 if (!$i) {
3135 $totalarray['nbfield']++;
3136 }
3137 }
3138
3139 // Dispute status
3140 if (!empty($arrayfields['f.dispute_status']['checked'])) {
3141 print '<td class="nowrap center">';
3142 if ($facturestatic->dispute_status) {
3143 $liststatus = Facture::ARRAY_OF_DISPUTE_STATUS;
3144 print $langs->trans($liststatus[$facturestatic->dispute_status]['label']);
3145 }
3146 print "</td>";
3147 if (!$i) {
3148 $totalarray['nbfield']++;
3149 }
3150 }
3151
3152 // Status
3153 if (!empty($arrayfields['f.fk_statut']['checked'])) {
3154 print '<td class="nowrap center">';
3155 print $facturestatic->getLibStatut(5, $totalallpayments);
3156 print "</td>";
3157 if (!$i) {
3158 $totalarray['nbfield']++;
3159 }
3160 }
3161
3162 // Action column (Show the massaction button only when this page is not opened from the Extended POS)
3163
3164 if (!$conf->main_checkbox_left_column) {
3165 print '<td class="nowrap center">';
3166 if (($massactionbutton || $massaction) && $contextpage != 'poslist') { // If we are in select mode (massactionbutton defined) or if we have already selected and sent an action ($massaction) defined
3167 $selected = 0;
3168 if (in_array($obj->id, $arrayofselected)) {
3169 $selected = 1;
3170 }
3171 print '<input id="cb'.$obj->id.'" class="flat checkforselect" type="checkbox" name="toselect[]" value="'.$obj->id.'"'.($selected ? ' checked="checked"' : '').'>';
3172 }
3173 print '</td>';
3174 if (!$i) {
3175 $totalarray['nbfield']++;
3176 }
3177 }
3178
3179 print "</tr>\n";
3180 }
3181
3182 $i++;
3183 }
3184
3185 // Use correct digits number for totals
3186 $totalarray['val']['total_pa'] = (isset($totalarray['val']['total_pa']) ? price2num($totalarray['val']['total_pa'], 'MT') : null);
3187 $totalarray['val']['total_margin'] = (isset($totalarray['val']['total_margin']) ? price2num($totalarray['val']['total_margin'], 'MT') : null);
3188
3189 // Show total line
3190 include DOL_DOCUMENT_ROOT.'/core/tpl/list_print_total.tpl.php';
3191}
3192
3193// If no record found
3194if ($num == 0) {
3195 $colspan = 1;
3196 foreach ($arrayfields as $key => $val) {
3197 if (!empty($val['checked'])) {
3198 $colspan++;
3199 }
3200 }
3201 print '<tr><td colspan="'.$colspan.'"><span class="opacitymedium">'.$langs->trans("NoRecordFound").'</span></td></tr>';
3202}
3203
3204$db->free($resql);
3205
3206$parameters = array('arrayfields' => $arrayfields, 'sql' => $sql);
3207$reshook = $hookmanager->executeHooks('printFieldListFooter', $parameters, $object, $action); // Note that $action and $object may have been modified by hook
3208print $hookmanager->resPrint;
3209
3210print '</table>'."\n";
3211print '</div>'."\n";
3212
3213print '</form>'."\n";
3214
3215// Show the file area only when this page is not opened from the Extended POS
3216if ($contextpage != 'poslist') {
3217 $hidegeneratedfilelistifempty = 1;
3218 if ($massaction == 'builddoc' || $action == 'remove_file' || $show_files) {
3219 $hidegeneratedfilelistifempty = 0;
3220 }
3221
3222 // Show list of available documents
3223 $urlsource = $_SERVER['PHP_SELF'].'?sortfield='.$sortfield.'&sortorder='.$sortorder;
3224 $urlsource .= str_replace('&amp;', '&', $param);
3225
3226 $filedir = $diroutputmassaction;
3227 $genallowed = $user->hasRight("facture", "lire");
3228 $delallowed = $user->hasRight("facture", "creer");
3229 $title = '';
3230
3231 print $formfile->showdocuments('massfilesarea_invoices', '', $filedir, $urlsource, 0, $delallowed, '', 1, 1, 0, 48, 1, $param, $title, '', '', '', null, $hidegeneratedfilelistifempty);
3232}
3233
3234// End of page
3235llxFooter();
3236$db->close();
$id
Support class for third parties, contacts, members, users or resources.
Definition account.php:47
if(! $sortfield) if(! $sortorder) $object
Definition account.php:100
$totalarray
Definition list.php:501
llxFooter($comment='', $zone='private', $disabledoutputofmessages=0)
Empty footer.
Definition wrapper.php:91
if(!defined('NOREQUIRESOC')) if(!defined( 'NOREQUIRETRAN')) if(!defined('NOTOKENRENEWAL')) if(!defined( 'NOREQUIREMENU')) if(!defined('NOREQUIREHTML')) if(!defined( 'NOREQUIREAJAX')) llxHeader($head='', $title='', $help_url='', $target='', $disablejs=0, $disablehead=0, $arrayofjs='', $arrayofcss='', $morequerystring='', $morecssonbody='', $replacemainareaby='', $disablenofollow=0, $disablenoindex=0)
Empty header.
Definition wrapper.php:73
Class to manage bank accounts.
Class to manage absolute discounts.
Class to manage invoices.
const TYPE_REPLACEMENT
Replacement invoice.
const STATUS_DRAFT
Draft status.
const TYPE_STANDARD
Standard invoice.
const TYPE_SITUATION
Situation invoice.
const STATUS_VALIDATED
Validated (need to be paid)
const TYPE_DEPOSIT
Deposit invoice.
const TYPE_CREDIT_NOTE
Credit note invoice.
const STATUS_CLOSED
Classified paid.
Class to manage invoice templates.
Class to manage forms for categories.
Class to build HTML component for third parties management Only common components are here.
Class to offer components to list and upload files.
Class to manage generation of HTML components Only common components must be here.
Class to manage "other" html components Only common components are here.
Class to help generate other html components Only common components are here.
Class to manage payments of customer invoices.
Class to manage projects.
Class to manage third parties objects (customers, suppliers, prospects...)
Class to manage Dolibarr users.
getCountry($searchkey, $withcode='', $dbtouse=null, $outputlangs=null, $entconv=1, $searchlabel='')
Return country label, code or id from an id, code or label.
getCountriesInEEC()
Return list of countries that are inside the EEC (European Economic Community) Note: Try to keep this...
global $mysoc
if(!isModEnabled('ai')||!getDolGlobalString('AI_ASSISTANT_ENABLED')) global $conf
The main.inc.php has been included so the following variable are now defined:
if(!isModEnabled('ai')||!getDolGlobalString('AI_ASSISTANT_ENABLED')) global $db
API class for accounts.
dol_now($mode='gmt')
Return date for now.
dol_mktime($hour, $minute, $second, $month, $day, $year, $gm='auto', $check=1)
Return a timestamp date built from detailed information (by default a local PHP server timestamp) Rep...
setEventMessages($mesg, $mesgs, $style='mesgs', $messagekey='', $noduplicate=0, $attop=0)
Set event messages in dol_events session object.
GETPOSTDATE($prefix, $hourTime='', $gm='auto', $saverestore='')
Helper function that combines values of a dolibarr DatePicker (such as Form\selectDate) for year,...
print_liste_field_titre($name, $file="", $field="", $begin="", $param="", $moreattrib="", $sortfield="", $sortorder="", $prefix="", $tooltip="", $forcenowrapcolumntitle=0)
Show title line of an array.
print_barre_liste($title, $page, $file, $options='', $sortfield='', $sortorder='', $morehtmlcenter='', $num=-1, $totalnboflines='', $picto='generic', $pictoisfullpath=0, $morehtmlright='', $morecss='', $limit=-1, $selectlimitsuffix=0, $hidenavigation=0, $pagenavastextinput=0, $morehtmlrightbeforearrow='')
Print a title with navigation controls for pagination.
img_picto($titlealt, $picto, $moreatt='', $pictoisfullpath=0, $srconly=0, $notitle=0, $alt='', $morecss='', $marginleftonlyshort=2, $allowothertags=array())
Show picto whatever it's its name (generic function)
img_warning($titlealt='default', $moreatt='', $morecss='pictowarning')
Show warning logo.
dolPrintHTML($s, $allowiframe=0, $moreallowedtags=array())
Return a string (that can be on several lines) ready to be output on a HTML page.
dolGetFirstLineOfText($text, $nboflines=1, $charset='UTF-8')
Return first line of text.
dol_get_fiche_head($links=array(), $active='', $title='', $notab=0, $picto='', $pictoisfullpath=0, $morehtmlright='', $morecss='', $limittoshow=0, $moretabssuffix='', $dragdropfile=0, $morecssdiv='')
Show tabs of a record.
price2num($amount, $rounding='', $option=0)
Function that return a number with universal decimal format (decimal separator is '.
dolGetButtonTitle($label, $helpText='', $iconClass='fa fa-file', $url='', $id='', $status=1, $params=array())
Function dolGetButtonTitle : this kind of buttons are used in title in list.
dol_eval($s, $returnvalue=1, $hideerrors=1, $onlysimplestring='1')
Replace eval function to add more security.
setEventMessage($mesgs, $style='mesgs', $noduplicate=0, $attop=0)
Set event message in dol_events session object.
dol_sanitizeFileName($str, $newstr='_', $unaccent=1, $includequotes=0, $allowdash=0)
Clean a string to use it as a file name.
price($amount, $form=0, $outlangs='', $trunc=1, $rounding=-1, $forcerounding=-1, $currency_code='')
Function to format a value into an amount for visual output Function used into PDF and HTML pages.
natural_search($fields, $value, $mode=0, $nofirstand=0, $sqltoadd='')
Generate natural SQL search string for a criteria (this criteria can be tested on one or several fiel...
getDolGlobalInt($key, $default=0)
Return a Dolibarr global constant int value.
dol_sort_array(&$array, $index, $order='asc', $natsort=0, $case_sensitive=0, $keepindex=0)
Advanced sort array by the value of a given key, which produces ascending (default) or descending out...
GETPOST($paramname, $check='alphanohtml', $method=0, $filter=null, $options=null, $noreplace=0, $nodefault=0)
Return value of a param into GET or POST supervariable.
dolPrintLabel($s, $escapeonlyhtmltags=0)
Return a string label (so on 1 line only and that should not contains any HTML) ready to be output on...
dolGetButtonTitleSeparator($moreClass="")
Add space between dolGetButtonTitle.
GETPOSTINT($paramname, $method=0, $nodefault=0)
Return the value of a $_GET or $_POST supervariable, converted into integer.
dol_print_date($time, $format='', $tzoutput='auto', $outputlangs=null, $encodetooutput=false, $decorate=0)
Output date in a string format according to outputlangs (or langs if not defined).
dol_print_error($db=null, $error='', $errors=null)
Displays error message system with all the information to facilitate the diagnosis and the escalation...
GETPOSTISSET($paramname)
Return true if we are in a context of submitting the parameter $paramname from a POST of a form.
getDolGlobalString($key, $default='')
Return a Dolibarr global constant string value.
isModEnabled($module)
Is Dolibarr module enabled.
dol_escape_htmltag($stringtoescape, $keepb=0, $keepn=0, $noescapetags='', $escapeonlyhtmltags=0, $cleanalsojavascript=0)
Returns text escaped for inclusion in HTML alt or title or value tags, or into values of HTML input f...
invoice_rec_prepare_head($object)
Return array head with list of tabs to view object information.
print $langs trans("Show") . '< td style="' . $timeColor . '" align="center"> s</td > badge status0 badge status4 badge status3 Error badge status8< td align="center">< span class="badge ' . $badge . '"></span ></td >< td align="center">< a href="#" class="button button-small" onclick="openLogModal(this)" data-req="' . dol_escape_htmltag($reqSafe) . '" data-res="' . dol_escape_htmltag($resSafe) . '" data-err="' . dol_escape_htmltag($errSafe) . '">< span class="fa fa-search-plus"></span ></a ></td ></tr >< tr >< td colspan="' . $colspan . '" class="opacitymedium"></td ></tr ></table ></div ></form > logModal none logModal none s a JSON string
buildzip.php
restrictedArea(User $user, $features, $object=0, $tableandshare='', $feature2='', $dbt_keyfield='fk_soc', $dbt_select='rowid', $isdraft=0, $nodie=0, $mode='')
Check permissions of a user to show a page and an object.