36 require
'../main.inc.php';
37 require_once DOL_DOCUMENT_ROOT.
'/core/class/html.formother.class.php';
38 require_once DOL_DOCUMENT_ROOT.
'/core/class/html.formfile.class.php';
39 require_once DOL_DOCUMENT_ROOT.
'/core/lib/date.lib.php';
40 require_once DOL_DOCUMENT_ROOT.
'/core/lib/company.lib.php';
41 require_once DOL_DOCUMENT_ROOT.
'/core/class/html.formpropal.class.php';
42 require_once DOL_DOCUMENT_ROOT.
'/core/class/html.formcompany.class.php';
43 require_once DOL_DOCUMENT_ROOT.
'/supplier_proposal/class/supplier_proposal.class.php';
44 if (!empty($conf->project->enabled)) {
45 require_once DOL_DOCUMENT_ROOT.
'/projet/class/project.class.php';
49 $langs->loadLangs(array(
'companies',
'propal',
'supplier_proposal',
'compta',
'bills',
'orders',
'products'));
51 $socid =
GETPOST(
'socid',
'int');
53 $action =
GETPOST(
'action',
'aZ09');
54 $massaction =
GETPOST(
'massaction',
'alpha');
55 $show_files =
GETPOST(
'show_files',
'int');
56 $confirm =
GETPOST(
'confirm',
'alpha');
57 $toselect =
GETPOST(
'toselect',
'array');
58 $contextpage =
GETPOST(
'contextpage',
'aZ') ?
GETPOST(
'contextpage',
'aZ') :
'supplierproposallist';
60 $search_user =
GETPOST(
'search_user',
'int');
61 $search_sale =
GETPOST(
'search_sale',
'int');
63 $search_societe =
GETPOST(
'search_societe',
'alpha');
64 $search_login =
GETPOST(
'search_login',
'alpha');
65 $search_town =
GETPOST(
'search_town',
'alpha');
66 $search_zip =
GETPOST(
'search_zip',
'alpha');
67 $search_state =
GETPOST(
"search_state");
68 $search_country =
GETPOST(
"search_country",
'int');
69 $search_date_startday =
GETPOST(
'search_date_startday',
'int');
70 $search_date_startmonth =
GETPOST(
'search_date_startmonth',
'int');
71 $search_date_startyear =
GETPOST(
'search_date_startyear',
'int');
72 $search_date_endday =
GETPOST(
'search_date_endday',
'int');
73 $search_date_endmonth =
GETPOST(
'search_date_endmonth',
'int');
74 $search_date_endyear =
GETPOST(
'search_date_endyear',
'int');
75 $search_date_start =
dol_mktime(0, 0, 0, $search_date_startmonth, $search_date_startday, $search_date_startyear);
76 $search_date_end =
dol_mktime(23, 59, 59, $search_date_endmonth, $search_date_endday, $search_date_endyear);
77 $search_date_valid_startday =
GETPOST(
'search_date_valid_startday',
'int');
78 $search_date_valid_startmonth =
GETPOST(
'search_date_valid_startmonth',
'int');
79 $search_date_valid_startyear =
GETPOST(
'search_date_valid_startyear',
'int');
80 $search_date_valid_endday =
GETPOST(
'search_date_valid_endday',
'int');
81 $search_date_valid_endmonth =
GETPOST(
'search_date_valid_endmonth',
'int');
82 $search_date_valid_endyear =
GETPOST(
'search_date_valid_endyear',
'int');
83 $search_date_valid_start =
dol_mktime(0, 0, 0, $search_date_valid_startmonth, $search_date_valid_startday, $search_date_valid_startyear);
84 $search_date_valid_end =
dol_mktime(23, 59, 59, $search_date_valid_endmonth, $search_date_valid_endday, $search_date_valid_endyear);
85 $search_type_thirdparty =
GETPOST(
"search_type_thirdparty",
'int');
86 $search_montant_ht =
GETPOST(
'search_montant_ht',
'alpha');
87 $search_montant_vat =
GETPOST(
'search_montant_vat',
'alpha');
88 $search_montant_ttc =
GETPOST(
'search_montant_ttc',
'alpha');
89 $search_multicurrency_code =
GETPOST(
'search_multicurrency_code',
'alpha');
90 $search_multicurrency_tx =
GETPOST(
'search_multicurrency_tx',
'alpha');
91 $search_multicurrency_montant_ht =
GETPOST(
'search_multicurrency_montant_ht',
'alpha');
92 $search_multicurrency_montant_vat =
GETPOST(
'search_multicurrency_montant_vat',
'alpha');
93 $search_multicurrency_montant_ttc =
GETPOST(
'search_multicurrency_montant_ttc',
'alpha');
94 $search_status =
GETPOST(
'search_status',
'int');
96 $object_statut = $db->escape(
GETPOST(
'supplier_proposal_statut'));
97 $search_btn =
GETPOST(
'button_search',
'alpha');
98 $search_remove_btn =
GETPOST(
'button_removefilter',
'alpha');
100 $sall = trim((
GETPOST(
'search_all',
'alphanohtml') !=
'') ?
GETPOST(
'search_all',
'alphanohtml') :
GETPOST(
'sall',
'alphanohtml'));
104 $optioncss =
GETPOST(
'optioncss',
'alpha');
105 $limit =
GETPOST(
'limit',
'int') ?
GETPOST(
'limit',
'int') : $conf->liste_limit;
106 $sortfield =
GETPOST(
'sortfield',
'aZ09comma');
107 $sortorder =
GETPOST(
'sortorder',
'aZ09comma');
109 if (empty($page) || $page == -1 || !empty($search_btn) || !empty($search_remove_btn) || (empty($toselect) && $massaction ===
'0')) {
112 $offset = $limit * $page;
113 $pageprev = $page - 1;
114 $pagenext = $page + 1;
116 $sortfield =
'sp.date_livraison';
122 if ($object_statut !=
'') {
123 $search_status = $object_statut;
130 $module =
'supplier_proposal';
133 if (!empty($user->socid)) {
134 $socid = $user->socid;
136 if (!empty($socid)) {
139 $dbtable =
'&societe';
143 $diroutputmassaction = $conf->supplier_proposal->dir_output.
'/temp/massgeneration/'.$user->id;
147 $hookmanager->initHooks(array(
'supplier_proposallist'));
151 $extrafields->fetch_name_optionals_label($object->table_element);
153 $search_array_options = $extrafields->getOptionalsFromPost($object->table_element,
'',
'search_');
157 $fieldstosearchall = array(
160 'pd.description'=>
'Description',
161 'sp.note_public'=>
'NotePublic',
163 if (empty($user->socid)) {
164 $fieldstosearchall[
"p.note_private"] =
"NotePrivate";
167 $checkedtypetiers = 0;
168 $arrayfields = array(
169 'sp.ref'=>array(
'label'=>$langs->trans(
"Ref"),
'checked'=>1),
170 's.nom'=>array(
'label'=>$langs->trans(
"Supplier"),
'checked'=>1),
171 's.town'=>array(
'label'=>$langs->trans(
"Town"),
'checked'=>1),
172 's.zip'=>array(
'label'=>$langs->trans(
"Zip"),
'checked'=>1),
173 'state.nom'=>array(
'label'=>$langs->trans(
"StateShort"),
'checked'=>0),
174 'country.code_iso'=>array(
'label'=>$langs->trans(
"Country"),
'checked'=>0),
175 'typent.code'=>array(
'label'=>$langs->trans(
"ThirdPartyType"),
'checked'=>$checkedtypetiers),
176 'sp.date_valid'=>array(
'label'=>$langs->trans(
"Date"),
'checked'=>1),
177 'sp.date_livraison'=>array(
'label'=>$langs->trans(
"DateEnd"),
'checked'=>1),
178 'sp.total_ht'=>array(
'label'=>$langs->trans(
"AmountHT"),
'checked'=>1),
179 'sp.total_tva'=>array(
'label'=>$langs->trans(
"AmountVAT"),
'checked'=>0),
180 'sp.total_ttc'=>array(
'label'=>$langs->trans(
"AmountTTC"),
'checked'=>0),
181 'sp.multicurrency_code'=>array(
'label'=>
'Currency',
'checked'=>0,
'enabled'=>(empty($conf->multicurrency->enabled) ? 0 : 1)),
182 'sp.multicurrency_tx'=>array(
'label'=>
'CurrencyRate',
'checked'=>0,
'enabled'=>(empty($conf->multicurrency->enabled) ? 0 : 1)),
183 'sp.multicurrency_total_ht'=>array(
'label'=>
'MulticurrencyAmountHT',
'checked'=>0,
'enabled'=>(empty($conf->multicurrency->enabled) ? 0 : 1)),
184 'sp.multicurrency_total_vat'=>array(
'label'=>
'MulticurrencyAmountVAT',
'checked'=>0,
'enabled'=>(empty($conf->multicurrency->enabled) ? 0 : 1)),
185 'sp.multicurrency_total_ttc'=>array(
'label'=>
'MulticurrencyAmountTTC',
'checked'=>0,
'enabled'=>(empty($conf->multicurrency->enabled) ? 0 : 1)),
186 'u.login'=>array(
'label'=>$langs->trans(
"Author"),
'checked'=>1,
'position'=>10),
187 'sp.datec'=>array(
'label'=>$langs->trans(
"DateCreation"),
'checked'=>0,
'position'=>500),
188 'sp.tms'=>array(
'label'=>$langs->trans(
"DateModificationShort"),
'checked'=>0,
'position'=>500),
189 'sp.fk_statut'=>array(
'label'=>$langs->trans(
"Status"),
'checked'=>1,
'position'=>1000),
192 include DOL_DOCUMENT_ROOT.
'/core/tpl/extrafields_list_array_fields.tpl.php';
203 if (
GETPOST(
'cancel',
'alpha')) {
204 $action =
'list'; $massaction =
'';
206 if (!
GETPOST(
'confirmmassaction',
'alpha') && $massaction !=
'presend' && $massaction !=
'confirm_presend') {
210 $parameters = array(
'socid'=>$socid);
211 $reshook = $hookmanager->executeHooks(
'doActions', $parameters, $object, $action);
216 $search_product_category = 0;
218 include DOL_DOCUMENT_ROOT.
'/core/actions_changeselectedfields.inc.php';
221 if (
GETPOST(
'button_removefilter_x',
'alpha') ||
GETPOST(
'button_removefilter.x',
'alpha') ||
GETPOST(
'button_removefilter',
'alpha')) {
226 $search_societe =
'';
227 $search_montant_ht =
'';
228 $search_montant_vat =
'';
229 $search_montant_ttc =
'';
230 $search_multicurrency_code =
'';
231 $search_multicurrency_tx =
'';
232 $search_multicurrency_montant_ht =
'';
233 $search_multicurrency_montant_vat =
'';
234 $search_multicurrency_montant_ttc =
'';
236 $search_product_category =
'';
241 $search_country =
'';
242 $search_type_thirdparty =
'';
243 $search_date_startday =
'';
244 $search_date_startmonth =
'';
245 $search_date_startyear =
'';
246 $search_date_endday =
'';
247 $search_date_endmonth =
'';
248 $search_date_endyear =
'';
249 $search_date_start =
'';
250 $search_date_end =
'';
251 $search_date_valid_startday =
'';
252 $search_date_valid_startmonth =
'';
253 $search_date_valid_startyear =
'';
254 $search_date_valid_endday =
'';
255 $search_date_valid_endmonth =
'';
256 $search_date_valid_endyear =
'';
257 $search_date_valid_start =
'';
258 $search_date_valid_end =
'';
263 if (empty($reshook)) {
264 $objectclass =
'SupplierProposal';
265 $objectlabel =
'SupplierProposals';
266 $permissiontoread = $user->rights->supplier_proposal->lire;
267 $permissiontodelete = $user->rights->supplier_proposal->supprimer;
268 $uploaddir = $conf->supplier_proposal->dir_output;
269 include DOL_DOCUMENT_ROOT.
'/core/actions_massactions.inc.php';
285 $companystatic =
new Societe($db);
288 $help_url =
'EN:Ask_Price_Supplier|FR:Demande_de_prix_fournisseur';
292 if ($sall || $search_product_category > 0 || $search_user > 0) {
293 $sql =
'SELECT DISTINCT';
295 $sql .=
' s.rowid as socid, s.nom as name, s.town, s.zip, s.fk_pays, s.client, s.code_client,';
296 $sql .=
" typent.code as typent_code,";
297 $sql .=
" state.code_departement as state_code, state.nom as state_name,";
298 $sql .=
' sp.rowid, sp.note_public, sp.note_private, sp.total_ht, sp.total_tva, sp.total_ttc, sp.localtax1, sp.localtax2, sp.ref, sp.fk_statut as status, sp.fk_user_author, sp.date_valid, sp.date_livraison as dp,';
299 $sql .=
' sp.fk_multicurrency, sp.multicurrency_code, sp.multicurrency_tx, sp.multicurrency_total_ht, sp.multicurrency_total_tva as multicurrency_total_vat, sp.multicurrency_total_ttc,';
300 $sql .=
' sp.datec as date_creation, sp.tms as date_update,';
301 $sql .=
" p.rowid as project_id, p.ref as project_ref,";
302 if (empty($user->rights->societe->client->voir) && !$socid) {
303 $sql .=
" sc.fk_soc, sc.fk_user,";
305 $sql .=
" u.firstname, u.lastname, u.photo, u.login, u.statut as ustatus, u.admin, u.employee, u.email as uemail";
307 if (!empty($extrafields->attributes[$object->table_element][
'label'])) {
308 foreach ($extrafields->attributes[$object->table_element][
'label'] as $key => $val) {
309 $sql .= ($extrafields->attributes[$object->table_element][
'type'][$key] !=
'separate' ?
", ef.".$key.
" as options_".$key :
'');
313 $parameters = array();
314 $reshook = $hookmanager->executeHooks(
'printFieldListSelect', $parameters);
315 $sql .= $hookmanager->resPrint;
316 $sql .=
' FROM '.MAIN_DB_PREFIX.
'societe as s';
317 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"c_country as country on (country.rowid = s.fk_pays)";
318 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"c_typent as typent on (typent.id = s.fk_typent)";
319 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"c_departements as state on (state.rowid = s.fk_departement)";
320 $sql .=
', '.MAIN_DB_PREFIX.
'supplier_proposal as sp';
321 if (isset($extrafields->attributes[$object->table_element][
'label']) && is_array($extrafields->attributes[$object->table_element][
'label']) && count($extrafields->attributes[$object->table_element][
'label'])) {
322 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.$object->table_element.
"_extrafields as ef on (sp.rowid = ef.fk_object)";
324 if ($sall || $search_product_category > 0) {
325 $sql .=
' LEFT JOIN '.MAIN_DB_PREFIX.
'supplier_proposaldet as pd ON sp.rowid=pd.fk_supplier_proposal';
327 if ($search_product_category > 0) {
328 $sql .=
' LEFT JOIN '.MAIN_DB_PREFIX.
'categorie_product as cp ON cp.fk_product=pd.fk_product';
330 $sql .=
' LEFT JOIN '.MAIN_DB_PREFIX.
'user as u ON sp.fk_user_author = u.rowid';
331 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"projet as p ON p.rowid = sp.fk_projet";
333 if ($search_sale > 0 || (empty($user->rights->societe->client->voir) && !$socid)) {
334 $sql .=
", ".MAIN_DB_PREFIX.
"societe_commerciaux as sc";
336 if ($search_user > 0) {
337 $sql .=
", ".MAIN_DB_PREFIX.
"element_contact as c";
338 $sql .=
", ".MAIN_DB_PREFIX.
"c_type_contact as tc";
340 $sql .=
' WHERE sp.fk_soc = s.rowid';
341 $sql .=
' AND sp.entity IN ('.getEntity(
'supplier_proposal').
')';
342 if (empty($user->rights->societe->client->voir) && !$socid) {
343 $sql .=
" AND s.rowid = sc.fk_soc AND sc.fk_user = ".((int) $user->id);
354 if ($search_country) {
355 $sql .=
" AND s.fk_pays IN (".$db->sanitize($search_country).
')';
357 if ($search_type_thirdparty !=
'' && $search_type_thirdparty > 0) {
358 $sql .=
" AND s.fk_typent IN (".$db->sanitize($search_type_thirdparty).
')';
363 if ($search_societe) {
367 $sql .=
natural_search(array(
'u.lastname',
'u.firstname',
'u.login'), $search_login);
369 if ($search_montant_ht) {
372 if ($search_montant_vat !=
'') {
375 if ($search_montant_ttc !=
'') {
378 if ($search_multicurrency_code !=
'') {
379 $sql .=
" AND sp.multicurrency_code = '".$db->escape($search_multicurrency_code).
"'";
381 if ($search_multicurrency_tx !=
'') {
382 $sql .=
natural_search(
'sp.multicurrency_tx', $search_multicurrency_tx, 1);
384 if ($search_multicurrency_montant_ht !=
'') {
385 $sql .=
natural_search(
'sp.multicurrency_total_ht', $search_multicurrency_montant_ht, 1);
387 if ($search_multicurrency_montant_vat !=
'') {
388 $sql .=
natural_search(
'sp.multicurrency_total_tva', $search_multicurrency_montant_vat, 1);
390 if ($search_multicurrency_montant_ttc !=
'') {
391 $sql .=
natural_search(
'sp.multicurrency_total_ttc', $search_multicurrency_montant_ttc, 1);
397 $sql .=
' AND s.rowid = '.((int) $socid);
399 if ($search_status >= 0 && $search_status !=
'') {
400 $sql .=
' AND sp.fk_statut IN ('.$db->sanitize($db->escape($search_status)).
')';
402 if ($search_date_start) {
403 $sql .=
" AND sp.date_livraison >= '".$db->idate($search_date_start).
"'";
405 if ($search_date_end) {
406 $sql .=
" AND sp.date_livraison <= '".$db->idate($search_date_end).
"'";
408 if ($search_date_valid_start) {
409 $sql .=
" AND sp.date_valid >= '".$db->idate($search_date_valid_start).
"'";
411 if ($search_date_valid_end) {
412 $sql .=
" AND sp.date_valid <= '".$db->idate($search_date_valid_end).
"'";
414 if ($search_sale > 0) {
415 $sql .=
" AND s.rowid = sc.fk_soc AND sc.fk_user = ".((int) $search_sale);
417 if ($search_user > 0) {
418 $sql .=
" AND c.fk_c_type_contact = tc.rowid AND tc.element='supplier_proposal' AND tc.source='internal' AND c.element_id = sp.rowid AND c.fk_socpeople = ".((int) $search_user);
421 include DOL_DOCUMENT_ROOT.
'/core/tpl/extrafields_list_search_sql.tpl.php';
423 $parameters = array();
424 $reshook = $hookmanager->executeHooks(
'printFieldListWhere', $parameters);
425 $sql .= $hookmanager->resPrint;
427 $sql .= $db->order($sortfield, $sortorder);
428 $sql .=
', sp.ref DESC';
431 $nbtotalofrecords =
'';
432 if (empty($conf->global->MAIN_DISABLE_FULL_SCANLIST)) {
433 $resql = $db->query($sql);
434 $nbtotalofrecords = $db->num_rows(
$resql);
435 if (($page * $limit) > $nbtotalofrecords) {
441 $sql .= $db->plimit($limit + 1, $offset);
443 $resql = $db->query($sql);
446 $userstatic =
new User($db);
451 $title = $langs->trans(
'SupplierProposals').
' - '.$soc->name;
453 $title = $langs->trans(
'SupplierProposals');
456 $num = $db->num_rows(
$resql);
458 $arrayofselected = is_array($toselect) ? $toselect : array();
460 if ($num == 1 && !empty($conf->global->MAIN_SEARCH_DIRECT_OPEN_IF_ONLY_ONE) && $sall) {
461 $obj = $db->fetch_object(
$resql);
465 header(
"Location: ".DOL_URL_ROOT.
'/supplier_proposal/card.php?id='.$id);
473 if (!empty($contextpage) && $contextpage != $_SERVER[
"PHP_SELF"]) {
474 $param .=
'&contextpage='.urlencode($contextpage);
476 if ($limit > 0 && $limit != $conf->liste_limit) {
477 $param .=
'&limit='.urlencode($limit);
480 $param .=
'&sall='.urlencode($sall);
482 if ($search_date_startday) {
483 $param .=
'&search_date_startday='.urlencode($search_date_startday);
485 if ($search_date_startmonth) {
486 $param .=
'&search_date_startmonth='.urlencode($search_date_startmonth);
488 if ($search_date_startyear) {
489 $param .=
'&search_date_startyear='.urlencode($search_date_startyear);
491 if ($search_date_endday) {
492 $param .=
'&search_date_endday='.urlencode($search_date_endday);
494 if ($search_date_endmonth) {
495 $param .=
'&search_date_endmonth='.urlencode($search_date_endmonth);
497 if ($search_date_endyear) {
498 $param .=
'&search_date_endyear='.urlencode($search_date_endyear);
500 if ($search_date_valid_startday) {
501 $param .=
'&search_date_valid_startday='.urlencode($search_date_valid_startday);
503 if ($search_date_valid_startmonth) {
504 $param .=
'&search_date_valid_startmonth='.urlencode($search_date_valid_startmonth);
506 if ($search_date_valid_startyear) {
507 $param .=
'&search_date_valid_startyear='.urlencode($search_date_valid_startyear);
509 if ($search_date_valid_endday) {
510 $param .=
'&search_date_valid_endday='.urlencode($search_date_valid_endday);
512 if ($search_date_valid_endmonth) {
513 $param .=
'&search_date_valid_endmonth='.urlencode($search_date_valid_endmonth);
515 if ($search_date_valid_endyear) {
516 $param .=
'&search_date_valid_endyear='.urlencode($search_date_valid_endyear);
519 $param .=
'&search_ref='.urlencode($search_ref);
521 if ($search_societe) {
522 $param .=
'&search_societe='.urlencode($search_societe);
524 if ($search_user > 0) {
525 $param .=
'&search_user='.urlencode($search_user);
527 if ($search_sale > 0) {
528 $param .=
'&search_sale='.urlencode($search_sale);
530 if ($search_montant_ht) {
531 $param .=
'&search_montant_ht='.urlencode($search_montant_ht);
533 if ($search_multicurrency_code !=
'') {
534 $param .=
'&search_multicurrency_code='.urlencode($search_multicurrency_code);
536 if ($search_multicurrency_tx !=
'') {
537 $param .=
'&search_multicurrency_tx='.urlencode($search_multicurrency_tx);
539 if ($search_multicurrency_montant_ht !=
'') {
540 $param .=
'&search_multicurrency_montant_ht='.urlencode($search_multicurrency_montant_ht);
542 if ($search_multicurrency_montant_vat !=
'') {
543 $param .=
'&search_multicurrency_montant_vat='.urlencode($search_multicurrency_montant_vat);
545 if ($search_multicurrency_montant_ttc !=
'') {
546 $param .=
'&search_multicurrency_montant_ttc='.urlencode($search_multicurrency_montant_ttc);
549 $param .=
'&search_login='.urlencode($search_login);
552 $param .=
'&search_town='.urlencode($search_town);
555 $param .=
'&search_zip='.urlencode($search_zip);
558 $param .=
'&socid='.urlencode($socid);
560 if ($search_status !=
'') {
561 $param .=
'&search_status='.urlencode($search_status);
563 if ($optioncss !=
'') {
564 $param .=
'&optioncss='.urlencode($optioncss);
566 if ($search_type_thirdparty !=
'' && $search_type_thirdparty > 0) {
567 $param .=
'&search_type_thirdparty='.urlencode($search_type_thirdparty);
570 include DOL_DOCUMENT_ROOT.
'/core/tpl/extrafields_list_search_param.tpl.php';
573 $arrayofmassactions = array(
574 'generate_doc'=>
img_picto(
'',
'pdf',
'class="pictofixedwidth"').$langs->trans(
"ReGeneratePDF"),
575 'builddoc'=>
img_picto(
'',
'pdf',
'class="pictofixedwidth"').$langs->trans(
"PDFMerge"),
578 if ($user->rights->supplier_proposal->supprimer) {
579 $arrayofmassactions[
'predelete'] =
img_picto(
'',
'delete',
'class="pictofixedwidth"').$langs->trans(
"Delete");
581 if (in_array($massaction, array(
'presend',
'predelete'))) {
582 $arrayofmassactions = array();
584 $massactionbutton =
$form->selectMassAction(
'', $arrayofmassactions);
586 $url = DOL_URL_ROOT.
'/supplier_proposal/card.php?action=create';
587 if (!empty($socid)) {
588 $url .=
'&socid='.$socid;
590 $newcardbutton =
dolGetButtonTitle($langs->trans(
'NewAskPrice'),
'',
'fa fa-plus-circle', $url,
'', $user->rights->supplier_proposal->creer);
593 print
'<form method="POST" id="searchFormList" action="'.$_SERVER[
"PHP_SELF"].
'">';
594 if ($optioncss !=
'') {
595 print
'<input type="hidden" name="optioncss" value="'.$optioncss.
'">';
597 print
'<input type="hidden" name="token" value="'.newToken().
'">';
598 print
'<input type="hidden" name="formfilteraction" id="formfilteraction" value="list">';
599 print
'<input type="hidden" name="action" value="list">';
600 print
'<input type="hidden" name="sortfield" value="'.$sortfield.
'">';
601 print
'<input type="hidden" name="sortorder" value="'.$sortorder.
'">';
603 print_barre_liste($title, $page, $_SERVER[
"PHP_SELF"], $param, $sortfield, $sortorder, $massactionbutton, $num, $nbtotalofrecords,
'supplier_proposal', 0, $newcardbutton,
'', $limit, 0, 0, 1);
605 $topicmail =
"SendSupplierProposalRef";
606 $modelmail =
"supplier_proposal_send";
608 $trackid =
'spro'.$object->id;
609 include DOL_DOCUMENT_ROOT.
'/core/tpl/massactions_pre.tpl.php';
612 foreach ($fieldstosearchall as $key => $val) {
613 $fieldstosearchall[$key] = $langs->trans($val);
615 print
'<div class="divsearchfieldfilter">'.$langs->trans(
"FilterOnInto", $sall).join(
', ', $fieldstosearchall).
'</div>';
623 if ($user->rights->user->user->lire) {
624 $langs->load(
"commercial");
625 $moreforfilter .=
'<div class="divsearchfield">';
626 $tmptitle = $langs->trans(
'ThirdPartiesOfSaleRepresentative');
627 $moreforfilter .=
img_picto($tmptitle,
'user',
'class="pictofixedwidth"').$formother->select_salesrepresentatives($search_sale,
'search_sale', $user, 0, $tmptitle,
'maxwidth250 widthcentpercentminusx');
628 $moreforfilter .=
'</div>';
631 if ($user->rights->user->user->lire) {
632 $moreforfilter .=
'<div class="divsearchfield">';
633 $tmptitle = $langs->trans(
'LinkedToSpecificUsers');
634 $moreforfilter .=
img_picto($tmptitle,
'user',
'class="pictofixedwidth"').$form->select_dolusers($search_user,
'search_user', $tmptitle,
'', 0,
'',
'', 0, 0, 0,
'', 0,
'',
'maxwidth250 widthcentpercentminusx');
635 $moreforfilter .=
'</div>';
638 if (!empty($conf->categorie->enabled) && $user->rights->categorie->lire && ($user->rights->produit->lire || $user->rights->service->lire)) {
639 include_once DOL_DOCUMENT_ROOT.
'/categories/class/categorie.class.php';
640 $moreforfilter .=
'<div class="divsearchfield">';
641 $tmptitle = $langs->trans(
'IncludingProductWithTag');
642 $cate_arbo =
$form->select_all_categories(Categorie::TYPE_PRODUCT,
null,
'parent',
null,
null, 1);
643 $moreforfilter .=
img_picto($tmptitle,
'category',
'class="pictofixedwidth"').$form->selectarray(
'search_product_category', $cate_arbo, $search_product_category, $tmptitle, 0, 0,
'', 0, 0, 0, 0,
'maxwidth300 widthcentpercentminusx', 1);
644 $moreforfilter .=
'</div>';
646 $parameters = array();
647 $reshook = $hookmanager->executeHooks(
'printFieldPreListTitle', $parameters);
648 if (empty($reshook)) {
649 $moreforfilter .= $hookmanager->resPrint;
651 $moreforfilter = $hookmanager->resPrint;
654 if (!empty($moreforfilter)) {
655 print
'<div class="liste_titre liste_titre_bydiv centpercent">';
656 print $moreforfilter;
660 $varpage = empty($contextpage) ? $_SERVER[
"PHP_SELF"] : $contextpage;
661 $selectedfields =
$form->multiSelectArrayWithCheckbox(
'selectedfields', $arrayfields, $varpage);
662 if ($massactionbutton) {
663 $selectedfields .=
$form->showCheckAddButtons(
'checkforselect', 1);
666 print
'<div class="div-table-responsive">';
667 print
'<table class="tagtable liste'.($moreforfilter ?
" listwithfilterbefore" :
"").
'">'.
"\n";
669 print
'<tr class="liste_titre_filter">';
670 if (!empty($arrayfields[
'sp.ref'][
'checked'])) {
671 print
'<td class="liste_titre">';
672 print
'<input class="flat" size="6" type="text" name="search_ref" value="'.dol_escape_htmltag($search_ref).
'">';
675 if (!empty($arrayfields[
's.nom'][
'checked'])) {
676 print
'<td class="liste_titre left">';
677 print
'<input class="flat" type="text" size="12" name="search_societe" value="'.dol_escape_htmltag($search_societe).
'">';
680 if (!empty($arrayfields[
's.town'][
'checked'])) {
681 print
'<td class="liste_titre"><input class="flat" type="text" size="6" name="search_town" value="'.$search_town.
'"></td>';
683 if (!empty($arrayfields[
's.zip'][
'checked'])) {
684 print
'<td class="liste_titre"><input class="flat" type="text" size="4" name="search_zip" value="'.$search_zip.
'"></td>';
687 if (!empty($arrayfields[
'state.nom'][
'checked'])) {
688 print
'<td class="liste_titre">';
689 print
'<input class="flat" size="4" type="text" name="search_state" value="'.dol_escape_htmltag($search_state).
'">';
693 if (!empty($arrayfields[
'country.code_iso'][
'checked'])) {
694 print
'<td class="liste_titre center">';
695 print
$form->select_country($search_country,
'search_country',
'', 0,
'minwidth100imp maxwidth100');
699 if (!empty($arrayfields[
'typent.code'][
'checked'])) {
700 print
'<td class="liste_titre maxwidthonsmartphone center">';
701 print
$form->selectarray(
"search_type_thirdparty", $formcompany->typent_array(0), $search_type_thirdparty, 1, 0, 0,
'', 0, 0, 0, (empty($conf->global->SOCIETE_SORT_ON_TYPEENT) ?
'ASC' : $conf->global->SOCIETE_SORT_ON_TYPEENT),
'', 1);
705 if (!empty($arrayfields[
'sp.date_valid'][
'checked'])) {
706 print
'<td class="liste_titre center">';
707 print
'<div class="nowrap">';
708 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'));
710 print
'<div class="nowrap">';
711 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'));
716 if (!empty($arrayfields[
'sp.date_livraison'][
'checked'])) {
717 print
'<td class="liste_titre center">';
718 print
'<div class="nowrap">';
719 print
$form->selectDate($search_date_start ? $search_date_start : -1,
'search_date_start', 0, 0, 1,
'', 1, 0, 0,
'',
'',
'',
'', 1,
'', $langs->trans(
'From'));
721 print
'<div class="nowrap">';
722 print
$form->selectDate($search_date_end ? $search_date_end : -1,
'search_date_end', 0, 0, 1,
'', 1, 0, 0,
'',
'',
'',
'', 1,
'', $langs->trans(
'to'));
727 if (!empty($arrayfields[
'sp.total_ht'][
'checked'])) {
729 print
'<td class="liste_titre right">';
730 print
'<input class="flat" type="text" size="5" name="search_montant_ht" value="'.dol_escape_htmltag($search_montant_ht).
'">';
733 if (!empty($arrayfields[
'sp.total_tva'][
'checked'])) {
735 print
'<td class="liste_titre right">';
736 print
'<input class="flat" type="text" size="5" name="search_montant_vat" value="'.dol_escape_htmltag($search_montant_vat).
'">';
739 if (!empty($arrayfields[
'sp.total_ttc'][
'checked'])) {
741 print
'<td class="liste_titre right">';
742 print
'<input class="flat" type="text" size="5" name="search_montant_ttc" value="'.dol_escape_htmltag($search_montant_ttc).
'">';
745 if (!empty($arrayfields[
'sp.multicurrency_code'][
'checked'])) {
747 print
'<td class="liste_titre">';
748 print
$form->selectMultiCurrency($search_multicurrency_code,
'search_multicurrency_code', 1);
751 if (!empty($arrayfields[
'sp.multicurrency_tx'][
'checked'])) {
753 print
'<td class="liste_titre">';
754 print
'<input class="flat" type="text" size="4" name="search_multicurrency_tx" value="'.dol_escape_htmltag($search_multicurrency_tx).
'">';
757 if (!empty($arrayfields[
'sp.multicurrency_total_ht'][
'checked'])) {
759 print
'<td class="liste_titre right">';
760 print
'<input class="flat" type="text" size="4" name="search_multicurrency_montant_ht" value="'.dol_escape_htmltag($search_multicurrency_montant_ht).
'">';
763 if (!empty($arrayfields[
'sp.multicurrency_total_vat'][
'checked'])) {
765 print
'<td class="liste_titre right">';
766 print
'<input class="flat" type="text" size="4" name="search_multicurrency_montant_vat" value="'.dol_escape_htmltag($search_multicurrency_montant_vat).
'">';
769 if (!empty($arrayfields[
'sp.multicurrency_total_ttc'][
'checked'])) {
771 print
'<td class="liste_titre right">';
772 print
'<input class="flat" type="text" size="4" name="search_multicurrency_montant_ttc" value="'.dol_escape_htmltag($search_multicurrency_montant_ttc).
'">';
775 if (!empty($arrayfields[
'u.login'][
'checked'])) {
777 print
'<td class="liste_titre center">';
778 print
'<input class="flat" size="4" type="text" name="search_login" value="'.dol_escape_htmltag($search_login).
'">';
782 include DOL_DOCUMENT_ROOT.
'/core/tpl/extrafields_list_search_input.tpl.php';
784 $parameters = array(
'arrayfields'=>$arrayfields);
785 $reshook = $hookmanager->executeHooks(
'printFieldListOption', $parameters);
786 print $hookmanager->resPrint;
788 if (!empty($arrayfields[
'sp.datec'][
'checked'])) {
789 print
'<td class="liste_titre">';
793 if (!empty($arrayfields[
'sp.tms'][
'checked'])) {
794 print
'<td class="liste_titre">';
798 if (!empty($arrayfields[
'sp.fk_statut'][
'checked'])) {
799 print
'<td class="liste_titre right">';
800 $formpropal->selectProposalStatus($search_status, 1, 0, 1,
'supplier',
'search_status',
'minwidth75imp');
804 print
'<td class="liste_titre middle">';
805 $searchpicto =
$form->showFilterButtons();
812 print
'<tr class="liste_titre">';
813 if (!empty($arrayfields[
'sp.ref'][
'checked'])) {
814 print_liste_field_titre($arrayfields[
'sp.ref'][
'label'], $_SERVER[
"PHP_SELF"],
'sp.ref',
'', $param,
'', $sortfield, $sortorder);
816 if (!empty($arrayfields[
's.nom'][
'checked'])) {
817 print_liste_field_titre($arrayfields[
's.nom'][
'label'], $_SERVER[
"PHP_SELF"],
's.nom',
'', $param,
'', $sortfield, $sortorder);
819 if (!empty($arrayfields[
's.town'][
'checked'])) {
820 print_liste_field_titre($arrayfields[
's.town'][
'label'], $_SERVER[
"PHP_SELF"],
's.town',
'', $param,
'', $sortfield, $sortorder);
822 if (!empty($arrayfields[
's.zip'][
'checked'])) {
823 print_liste_field_titre($arrayfields[
's.zip'][
'label'], $_SERVER[
"PHP_SELF"],
's.zip',
'', $param,
'', $sortfield, $sortorder);
825 if (!empty($arrayfields[
'state.nom'][
'checked'])) {
826 print_liste_field_titre($arrayfields[
'state.nom'][
'label'], $_SERVER[
"PHP_SELF"],
"state.nom",
"", $param,
'', $sortfield, $sortorder);
828 if (!empty($arrayfields[
'country.code_iso'][
'checked'])) {
829 print_liste_field_titre($arrayfields[
'country.code_iso'][
'label'], $_SERVER[
"PHP_SELF"],
"country.code_iso",
"", $param,
'', $sortfield, $sortorder,
'center ');
831 if (!empty($arrayfields[
'typent.code'][
'checked'])) {
832 print_liste_field_titre($arrayfields[
'typent.code'][
'label'], $_SERVER[
"PHP_SELF"],
"typent.code",
"", $param,
'', $sortfield, $sortorder,
'center ');
834 if (!empty($arrayfields[
'sp.date_valid'][
'checked'])) {
835 print_liste_field_titre($arrayfields[
'sp.date_valid'][
'label'], $_SERVER[
"PHP_SELF"],
'sp.date_valid',
'', $param,
'', $sortfield, $sortorder,
'center ');
837 if (!empty($arrayfields[
'sp.date_livraison'][
'checked'])) {
838 print_liste_field_titre($arrayfields[
'sp.date_livraison'][
'label'], $_SERVER[
"PHP_SELF"],
'sp.date_livraison',
'', $param,
'', $sortfield, $sortorder,
'center ');
840 if (!empty($arrayfields[
'sp.total_ht'][
'checked'])) {
841 print_liste_field_titre($arrayfields[
'sp.total_ht'][
'label'], $_SERVER[
"PHP_SELF"],
'sp.total_ht',
'', $param,
'', $sortfield, $sortorder,
'right ');
843 if (!empty($arrayfields[
'sp.total_tva'][
'checked'])) {
844 print_liste_field_titre($arrayfields[
'sp.total_tva'][
'label'], $_SERVER[
"PHP_SELF"],
'sp.total_tva',
'', $param,
'', $sortfield, $sortorder,
'right ');
846 if (!empty($arrayfields[
'sp.total_ttc'][
'checked'])) {
847 print_liste_field_titre($arrayfields[
'sp.total_ttc'][
'label'], $_SERVER[
"PHP_SELF"],
'sp.total_ttc',
'', $param,
'', $sortfield, $sortorder,
'right ');
849 if (!empty($arrayfields[
'sp.multicurrency_code'][
'checked'])) {
850 print_liste_field_titre($arrayfields[
'sp.multicurrency_code'][
'label'], $_SERVER[
'PHP_SELF'],
'sp.multicurrency_code',
'', $param,
'', $sortfield, $sortorder);
852 if (!empty($arrayfields[
'sp.multicurrency_tx'][
'checked'])) {
853 print_liste_field_titre($arrayfields[
'sp.multicurrency_tx'][
'label'], $_SERVER[
'PHP_SELF'],
'sp.multicurrency_tx',
'', $param,
'', $sortfield, $sortorder);
855 if (!empty($arrayfields[
'sp.multicurrency_total_ht'][
'checked'])) {
856 print_liste_field_titre($arrayfields[
'sp.multicurrency_total_ht'][
'label'], $_SERVER[
'PHP_SELF'],
'sp.multicurrency_total_ht',
'', $param,
'class="right"', $sortfield, $sortorder);
858 if (!empty($arrayfields[
'sp.multicurrency_total_vat'][
'checked'])) {
859 print_liste_field_titre($arrayfields[
'sp.multicurrency_total_vat'][
'label'], $_SERVER[
'PHP_SELF'],
'sp.multicurrency_total_tva',
'', $param,
'class="right"', $sortfield, $sortorder);
861 if (!empty($arrayfields[
'sp.multicurrency_total_ttc'][
'checked'])) {
862 print_liste_field_titre($arrayfields[
'sp.multicurrency_total_ttc'][
'label'], $_SERVER[
'PHP_SELF'],
'sp.multicurrency_total_ttc',
'', $param,
'class="right"', $sortfield, $sortorder);
864 if (!empty($arrayfields[
'u.login'][
'checked'])) {
865 print_liste_field_titre($arrayfields[
'u.login'][
'label'], $_SERVER[
"PHP_SELF"],
'u.login',
'', $param,
'', $sortfield, $sortorder,
'center ');
868 include DOL_DOCUMENT_ROOT.
'/core/tpl/extrafields_list_search_title.tpl.php';
870 $parameters = array(
'arrayfields'=>$arrayfields,
'param'=>$param,
'sortfield'=>$sortfield,
'sortorder'=>$sortorder);
871 $reshook = $hookmanager->executeHooks(
'printFieldListTitle', $parameters);
872 print $hookmanager->resPrint;
873 if (!empty($arrayfields[
'sp.datec'][
'checked'])) {
874 print_liste_field_titre($arrayfields[
'sp.datec'][
'label'], $_SERVER[
"PHP_SELF"],
"sp.datec",
"", $param,
'', $sortfield, $sortorder,
'center nowrap ');
876 if (!empty($arrayfields[
'sp.tms'][
'checked'])) {
877 print_liste_field_titre($arrayfields[
'sp.tms'][
'label'], $_SERVER[
"PHP_SELF"],
"sp.tms",
"", $param,
'', $sortfield, $sortorder,
'center nowrap');
879 if (!empty($arrayfields[
'sp.fk_statut'][
'checked'])) {
880 print_liste_field_titre($arrayfields[
'sp.fk_statut'][
'label'], $_SERVER[
"PHP_SELF"],
"sp.fk_statut",
"", $param,
'', $sortfield, $sortorder,
'right ');
882 print_liste_field_titre($selectedfields, $_SERVER[
"PHP_SELF"],
"",
'',
'',
'', $sortfield, $sortorder,
'center maxwidthsearch ');
889 $totalarray = array();
890 $totalarray[
'nbfield'] = 0;
891 $totalarray[
'val'] = array();
892 $totalarray[
'val'][
'sp.total_ht'] = 0;
893 $totalarray[
'val'][
'sp.total_tva'] = 0;
894 $totalarray[
'val'][
'sp.total_ttc'] = 0;
895 while ($i < min($num, $limit)) {
896 $obj = $db->fetch_object(
$resql);
898 $objectstatic->id = $obj->rowid;
899 $objectstatic->ref = $obj->ref;
900 $objectstatic->note_public = $obj->note_public;
901 $objectstatic->note_private = $obj->note_private;
902 $objectstatic->status = $obj->status;
905 $companystatic->id = $obj->socid;
906 $companystatic->name = $obj->name;
907 $companystatic->client = $obj->client;
908 $companystatic->code_client = $obj->code_client;
910 print
'<tr class="oddeven">';
912 if (!empty($arrayfields[
'sp.ref'][
'checked'])) {
913 print
'<td class="nowraponall">';
915 print
'<table class="nobordernopadding"><tr class="nocellnopadd">';
917 print
'<td class="nobordernopadding nowraponall">';
918 print $objectstatic->getNomUrl(1,
'',
'', 0, -1, 1);
924 print
'<td style="min-width: 20px" class="nobordernopadding nowrap">';
929 print
'<td width="16" class="right nobordernopadding hideonsmartphone">';
932 $urlsource = $_SERVER[
'PHP_SELF'].
'?id='.$obj->rowid;
933 print $formfile->getDocumentsLink($objectstatic->element, $filename, $filedir);
934 print
'</td></tr></table>';
938 $totalarray[
'nbfield']++;
943 if (!empty($arrayfields[
's.nom'][
'checked'])) {
944 print
'<td class="tdoverflowmax200">';
945 print $companystatic->getNomUrl(1,
'supplier');
948 $totalarray[
'nbfield']++;
953 if (!empty($arrayfields[
's.town'][
'checked'])) {
954 print
'<td class="nocellnopadd">';
958 $totalarray[
'nbfield']++;
962 if (!empty($arrayfields[
's.zip'][
'checked'])) {
963 print
'<td class="nocellnopadd">';
967 $totalarray[
'nbfield']++;
971 if (!empty($arrayfields[
'state.nom'][
'checked'])) {
972 print
"<td>".$obj->state_name.
"</td>\n";
974 $totalarray[
'nbfield']++;
978 if (!empty($arrayfields[
'country.code_iso'][
'checked'])) {
979 print
'<td class="center">';
981 print $tmparray[
'label'];
984 $totalarray[
'nbfield']++;
988 if (!empty($arrayfields[
'typent.code'][
'checked'])) {
989 print
'<td class="center">';
990 if (count($typenArray) == 0) {
991 $typenArray = $formcompany->typent_array(1);
993 print $typenArray[$obj->typent_code];
996 $totalarray[
'nbfield']++;
1001 if (!empty($arrayfields[
'sp.date_valid'][
'checked'])) {
1002 print
'<td class="center">';
1006 $totalarray[
'nbfield']++;
1011 if (!empty($arrayfields[
'sp.date_livraison'][
'checked'])) {
1012 print
'<td class="center">';
1016 $totalarray[
'nbfield']++;
1021 if (!empty($arrayfields[
'sp.total_ht'][
'checked'])) {
1022 print
'<td class="right"><span class="amount">'.price($obj->total_ht).
"</span></td>\n";
1024 $totalarray[
'nbfield']++;
1027 $totalarray[
'pos'][$totalarray[
'nbfield']] =
'sp.total_ht';
1029 $totalarray[
'val'][
'sp.total_ht'] += $obj->total_ht;
1032 if (!empty($arrayfields[
'sp.total_tva'][
'checked'])) {
1033 print
'<td class="right"><span class="amount">'.price($obj->total_tva).
"</span></td>\n";
1035 $totalarray[
'nbfield']++;
1038 $totalarray[
'pos'][$totalarray[
'nbfield']] =
'sp.total_tva';
1040 $totalarray[
'val'][
'sp.total_tva'] += $obj->total_tva;
1043 if (!empty($arrayfields[
'sp.total_ttc'][
'checked'])) {
1044 print
'<td class="right"><span class="amount">'.price($obj->total_ttc).
"</span></td>\n";
1046 $totalarray[
'nbfield']++;
1049 $totalarray[
'pos'][$totalarray[
'nbfield']] =
'sp.total_ttc';
1051 $totalarray[
'val'][
'sp.total_ttc'] += $obj->total_ttc;
1055 if (!empty($arrayfields[
'sp.multicurrency_code'][
'checked'])) {
1056 print
'<td class="nowrap">'.$obj->multicurrency_code.
' - '.$langs->trans(
'Currency'.$obj->multicurrency_code).
"</td>\n";
1058 $totalarray[
'nbfield']++;
1063 if (!empty($arrayfields[
'sp.multicurrency_tx'][
'checked'])) {
1064 print
'<td class="nowrap">';
1065 $form->form_multicurrency_rate($_SERVER[
'PHP_SELF'].
'?id='.$obj->rowid, $obj->multicurrency_tx,
'none', $obj->multicurrency_code);
1068 $totalarray[
'nbfield']++;
1072 if (!empty($arrayfields[
'sp.multicurrency_total_ht'][
'checked'])) {
1073 print
'<td class="right nowrap"><span class="amount">'.price($obj->multicurrency_total_ht).
"</span></td>\n";
1075 $totalarray[
'nbfield']++;
1079 if (!empty($arrayfields[
'sp.multicurrency_total_vat'][
'checked'])) {
1080 print
'<td class="right nowrap"><span class="amount">'.price($obj->multicurrency_total_vat).
"</span></td>\n";
1082 $totalarray[
'nbfield']++;
1086 if (!empty($arrayfields[
'sp.multicurrency_total_ttc'][
'checked'])) {
1087 print
'<td class="right nowrap"><span class="amount">'.price($obj->multicurrency_total_ttc).
"</span></td>\n";
1089 $totalarray[
'nbfield']++;
1093 $userstatic->id = $obj->fk_user_author;
1094 $userstatic->login = $obj->login;
1095 $userstatic->status = $obj->status;
1096 $userstatic->lastname = $obj->name;
1097 $userstatic->firstname = $obj->firstname;
1098 $userstatic->photo = $obj->photo;
1099 $userstatic->admin = $obj->admin;
1100 $userstatic->ref = $obj->fk_user_author;
1101 $userstatic->employee = $obj->employee;
1102 $userstatic->email = $obj->uemail;
1105 if (!empty($arrayfields[
'u.login'][
'checked'])) {
1106 print
'<td class="center">';
1107 if ($userstatic->id > 0) {
1108 print $userstatic->getNomUrl(-1,
'', 0, 0, 24, 1,
'login',
'', 1);
1114 $totalarray[
'nbfield']++;
1119 include DOL_DOCUMENT_ROOT.
'/core/tpl/extrafields_list_print_fields.tpl.php';
1121 $parameters = array(
'arrayfields'=>$arrayfields,
'obj'=>$obj,
'i'=>$i,
'totalarray'=>&$totalarray);
1122 $reshook = $hookmanager->executeHooks(
'printFieldListValue', $parameters);
1123 print $hookmanager->resPrint;
1125 if (!empty($arrayfields[
'sp.datec'][
'checked'])) {
1126 print
'<td class="center nowrap">';
1127 print
dol_print_date($db->jdate($obj->date_creation),
'dayhour',
'tzuser');
1130 $totalarray[
'nbfield']++;
1134 if (!empty($arrayfields[
'sp.tms'][
'checked'])) {
1135 print
'<td class="center nowrap">';
1136 print
dol_print_date($db->jdate($obj->date_update),
'dayhour',
'tzuser');
1139 $totalarray[
'nbfield']++;
1143 if (!empty($arrayfields[
'sp.fk_statut'][
'checked'])) {
1144 print
'<td class="right">'.$objectstatic->getLibStatut(5).
"</td>\n";
1146 $totalarray[
'nbfield']++;
1151 print
'<td class="nowrap center">';
1152 if ($massactionbutton || $massaction) {
1154 if (in_array($obj->rowid, $arrayofselected)) {
1157 print
'<input id="cb'.$obj->rowid.
'" class="flat checkforselect" type="checkbox" name="toselect[]" value="'.$obj->rowid.
'"'.($selected ?
' checked="checked"' :
'').
'>';
1161 $totalarray[
'nbfield']++;
1166 $total += $obj->total_ht;
1167 $subtotal += $obj->total_ht;
1173 include DOL_DOCUMENT_ROOT.
'/core/tpl/list_print_total.tpl.php';
1177 $parameters = array(
'arrayfields'=>$arrayfields,
'sql'=>$sql);
1178 $reshook = $hookmanager->executeHooks(
'printFieldListFooter', $parameters);
1179 print $hookmanager->resPrint;
1181 print
'</table>'.
"\n";
1182 print
'</div>'.
"\n";
1184 print
'</form>'.
"\n";
1186 $hidegeneratedfilelistifempty = 1;
1187 if ($massaction ==
'builddoc' || $action ==
'remove_file' || $show_files) {
1188 $hidegeneratedfilelistifempty = 0;
1192 $urlsource = $_SERVER[
'PHP_SELF'].
'?sortfield='.$sortfield.
'&sortorder='.$sortorder;
1193 $urlsource .= str_replace(
'&',
'&', $param);
1195 $filedir = $diroutputmassaction;
1197 $genallowed = $user->rights->supplier_proposal->lire;
1198 $delallowed = $user->rights->supplier_proposal->creer;
1200 print $formfile->showdocuments(
'massfilesarea_supplier_proposal',
'', $filedir, $urlsource, 0, $delallowed,
'', 1, 1, 0, 48, 1, $param, $title,
'',
'',
'',
null, $hidegeneratedfilelistifempty);