33require
'../main.inc.php';
41require_once DOL_DOCUMENT_ROOT.
'/reception/class/reception.class.php';
42require_once DOL_DOCUMENT_ROOT.
'/fourn/class/fournisseur.facture.class.php';
43require_once DOL_DOCUMENT_ROOT.
'/core/class/discount.class.php';
44require_once DOL_DOCUMENT_ROOT.
'/fourn/class/fournisseur.commande.class.php';
45require_once DOL_DOCUMENT_ROOT.
'/fourn/class/fournisseur.product.class.php';
46require_once DOL_DOCUMENT_ROOT.
'/core/class/html.formcompany.class.php';
47require_once DOL_DOCUMENT_ROOT.
'/core/class/html.formfile.class.php';
48require_once DOL_DOCUMENT_ROOT.
'/core/lib/date.lib.php';
49require_once DOL_DOCUMENT_ROOT.
'/core/lib/company.lib.php';
51$langs->loadLangs(array(
"sendings",
"receptions",
'companies',
'bills',
'orders'));
53$contextpage =
GETPOST(
'contextpage',
'aZ') ?
GETPOST(
'contextpage',
'aZ') :
'shipmentlist';
57$action =
GETPOST(
'action',
'alpha');
58$massaction =
GETPOST(
'massaction',
'alpha');
59$toselect =
GETPOST(
'toselect',
'array:int');
61$optioncss =
GETPOST(
'optioncss',
'alpha');
62$mode =
GETPOST(
'mode',
'alpha');
65$search_ref_rcp =
GETPOST(
"search_ref_rcp");
66$search_ref_liv =
GETPOST(
'search_ref_liv');
67$search_ref_supplier =
GETPOST(
'search_ref_supplier');
68$search_company =
GETPOST(
"search_company");
69$search_town =
GETPOST(
'search_town',
'alpha');
70$search_zip =
GETPOST(
'search_zip',
'alpha');
71$search_state =
GETPOST(
"search_state");
72$search_country =
GETPOST(
"search_country",
'aZ09');
73$search_type_thirdparty =
GETPOST(
"search_type_thirdparty",
'intcomma');
74$search_date_delivery_startday =
GETPOSTINT(
'search_date_delivery_startday');
75$search_date_delivery_startmonth =
GETPOSTINT(
'search_date_delivery_startmonth');
76$search_date_delivery_startyear =
GETPOSTINT(
'search_date_delivery_startyear');
77$search_date_delivery_endday =
GETPOSTINT(
'search_date_delivery_endday');
78$search_date_delivery_endmonth =
GETPOSTINT(
'search_date_delivery_endmonth');
79$search_date_delivery_endyear =
GETPOSTINT(
'search_date_delivery_endyear');
80$search_date_delivery_start =
dol_mktime(0, 0, 0, $search_date_delivery_startmonth, $search_date_delivery_startday, $search_date_delivery_startyear);
81$search_date_delivery_end =
dol_mktime(23, 59, 59, $search_date_delivery_endmonth, $search_date_delivery_endday, $search_date_delivery_endyear);
82$search_date_create_startday =
GETPOSTINT(
'search_date_create_startday');
83$search_date_create_startmonth =
GETPOSTINT(
'search_date_create_startmonth');
84$search_date_create_startyear =
GETPOSTINT(
'search_date_create_startyear');
85$search_date_create_endday =
GETPOSTINT(
'search_date_create_endday');
86$search_date_create_endmonth =
GETPOSTINT(
'search_date_create_endmonth');
87$search_date_create_endyear =
GETPOSTINT(
'search_date_create_endyear');
88$search_date_create_start =
dol_mktime(0, 0, 0, $search_date_create_startmonth, $search_date_create_startday, $search_date_create_startyear);
89$search_date_create_end =
dol_mktime(23, 59, 59, $search_date_create_endmonth, $search_date_create_endday, $search_date_create_endyear);
90$search_billed =
GETPOST(
"search_billed",
'intcomma');
91$search_status =
GETPOST(
'search_status',
'intcomma');
92$search_all =
GETPOST(
'search_all',
'alphanohtml');
93$search_note_private =
GETPOST(
'search_note_private',
'alpha');
94$search_note_public =
GETPOST(
'search_note_public',
'alpha');
97$sortfield =
GETPOST(
'sortfield',
'aZ09comma');
98$sortorder =
GETPOST(
'sortorder',
'aZ09comma');
101 $sortfield =
"e.ref";
106if (empty($page) || $page < 0 ||
GETPOST(
'button_search',
'alpha') ||
GETPOST(
'button_removefilter',
'alpha')) {
110$offset = $limit * $page;
111$pageprev = $page - 1;
112$pagenext = $page + 1;
114$diroutputmassaction =
$conf->reception->multidir_output[
$conf->entity].
'/temp/massgeneration/'.$user->id;
118$hookmanager->initHooks(array(
'receptionlist'));
122$extrafields->fetch_name_optionals_label(
$object->table_element);
123$search_array_options = $extrafields->getOptionalsFromPost(
$object->table_element,
'',
'search_');
126$fieldstosearchall = array(
128 'e.ref_supplier' =>
"RefSupplier",
129 's.nom' =>
"ThirdParty",
130 'e.note_public' =>
'NotePublic',
132if (empty($user->socid)) {
133 $fieldstosearchall[
"e.note_private"] =
"NotePrivate";
136$checkedtypetiers =
'0';
138 'e.ref' => array(
'label' => $langs->trans(
"Ref"),
'checked' =>
'1'),
139 'e.ref_supplier' => array(
'label' => $langs->trans(
"RefSupplier"),
'checked' =>
'1'),
140 's.nom' => array(
'label' => $langs->trans(
"ThirdParty"),
'checked' =>
'1'),
141 's.town' => array(
'label' => $langs->trans(
"Town"),
'checked' =>
'1'),
142 's.zip' => array(
'label' => $langs->trans(
"Zip"),
'checked' =>
'1'),
143 'state.nom' => array(
'label' => $langs->trans(
"StateShort"),
'checked' =>
'0'),
144 'country.code_iso' => array(
'label' => $langs->trans(
"Country"),
'checked' =>
'0'),
145 'typent.code' => array(
'label' => $langs->trans(
"ThirdPartyType"),
'checked' => $checkedtypetiers),
146 'e.date_delivery' => array(
'label' => $langs->trans(
"DateDeliveryPlanned"),
'checked' =>
'1'),
147 'e.datec' => array(
'label' => $langs->trans(
"DateCreation"),
'checked' =>
'0',
'position' => 500),
148 'e.tms' => array(
'label' => $langs->trans(
"DateModificationShort"),
'checked' =>
'0',
'position' => 500),
149 'e.note_public' => array(
'label' =>
'NotePublic',
'checked' =>
'0',
'position' => 520,
'enabled' => (
getDolGlobalInt(
'MAIN_LIST_HIDE_PUBLIC_NOTES') ?
'0' :
'1')),
150 'e.note_private' => array(
'label' =>
'NotePrivate',
'checked' =>
'0',
'position' => 521,
'enabled' => (
getDolGlobalInt(
'MAIN_LIST_HIDE_PRIVATE_NOTES') ?
'0' :
'1')),
151 'e.fk_statut' => array(
'label' => $langs->trans(
"Status"),
'checked' =>
'1',
'position' => 1000),
152 'e.billed' => array(
'label' => $langs->trans(
"Billed"),
'checked' =>
'1',
'position' => 1000,
'enabled' =>
'getDolGlobalString("WORKFLOW_BILL_ON_RECEPTION") !== "0"')
156include DOL_DOCUMENT_ROOT.
'/core/tpl/extrafields_list_array_fields.tpl.php';
159$parameters = array(
'arrayfields' => &$arrayfields);
160$reshook = $hookmanager->executeHooks(
'completeArrayFields', $parameters, $object, $action);
170 $socid = $user->socid;
179if (
GETPOST(
'cancel',
'alpha')) {
183if (!
GETPOST(
'confirmmassaction',
'alpha') && $massaction !=
'presend' && $massaction !=
'confirm_createbills') {
187$parameters = array(
'socid' => $socid,
'arrayfields' => &$arrayfields);
188$reshook = $hookmanager->executeHooks(
'doActions', $parameters, $object, $action);
193include DOL_DOCUMENT_ROOT.
'/core/actions_changeselectedfields.inc.php';
196if (
GETPOST(
'button_removefilter_x',
'alpha') ||
GETPOST(
'button_removefilter.x',
'alpha') ||
GETPOST(
'button_removefilter',
'alpha')) {
197 $search_ref_supplier =
'';
198 $search_ref_rcp =
'';
199 $search_ref_liv =
'';
200 $search_company =
'';
204 $search_country =
'';
205 $search_type_thirdparty =
'';
206 $search_date_delivery_startday =
'';
207 $search_date_delivery_startmonth =
'';
208 $search_date_delivery_startyear =
'';
209 $search_date_delivery_endday =
'';
210 $search_date_delivery_endmonth =
'';
211 $search_date_delivery_endyear =
'';
212 $search_date_delivery_start =
'';
213 $search_date_delivery_end =
'';
214 $search_date_create_startday =
'';
215 $search_date_create_startmonth =
'';
216 $search_date_create_startyear =
'';
217 $search_date_create_endday =
'';
218 $search_date_create_endmonth =
'';
219 $search_date_create_endyear =
'';
220 $search_date_create_start =
'';
221 $search_date_create_end =
'';
225 $search_array_options = array();
228if (empty($reshook)) {
230 $objectclass =
'Reception';
231 $objectlabel =
'Receptions';
232 $permissiontoread = $user->hasRight(
'reception',
'lire');
233 $permissiontoadd = $user->hasRight(
'reception',
'creer');
234 $permissiontodelete = $user->hasRight(
'reception',
'supprimer');
235 $uploaddir =
$conf->reception->multidir_output[
$conf->entity];
236 include DOL_DOCUMENT_ROOT.
'/core/actions_massactions.inc.php';
238 if (!$error && $massaction ==
'confirm_createbills' && ($user->hasRight(
"fournisseur",
"facture",
"creer") || $user->hasRight(
"supplier_invoice",
"creer"))) {
239 $receptions = $toselect;
240 $createbills_onebythird =
GETPOSTINT(
'createbills_onebythird');
241 $validate_invoices =
GETPOSTINT(
'validate_invoices');
246 $TFactThird = array();
247 '@phan-var FactureFournisseur[] $TFactThird';
248 $TFactThirdNbLines = array();
250 $nb_bills_created = 0;
258 foreach ($receptions as $id_reception) {
262 if ($rcp->fetch($id_reception) <= 0 || $rcp->statut == $rcp::STATUS_DRAFT) {
263 $errors[] = $langs->trans(
'StatusOfRefMustBe', $rcp->ref, $langs->transnoentities(
"StatusReceptionValidatedShort"));
269 if (!empty($createbills_onebythird) && !empty($TFactThird[$rcp->socid])) {
271 $objecttmp = $TFactThird[$rcp->socid];
274 $objecttmp->fetchObjectLinked();
275 $objecttmp->clearObjectLinkedCache();
276 $rcp->fetchObjectLinked();
277 if (!empty($rcp->linkedObjectsIds[
'order_supplier']) && is_array($rcp->linkedObjectsIds[
'order_supplier'])) {
278 foreach ($rcp->linkedObjectsIds[
'order_supplier'] as $key => $value) {
279 if (empty($objecttmp->linkedObjectsIds[
'order_supplier']) || !in_array($value, $objecttmp->linkedObjectsIds[
'order_supplier'])) {
280 $objecttmp->add_object_linked(
'order_supplier', $value);
285 $cond_reglement_id = 0;
286 $mode_reglement_id = 0;
288 $transport_mode_id = 0;
289 $multicurrency_code =
null;
291 if (!empty($rcp->cond_reglement_id)) {
292 $cond_reglement_id = $rcp->cond_reglement_id;
294 if (!empty($rcp->mode_reglement_id)) {
295 $mode_reglement_id = $rcp->mode_reglement_id;
297 if (!empty($rcp->fk_account)) {
298 $fk_account = $rcp->fk_account;
300 if (!empty($rcp->transport_mode_id)) {
301 $transport_mode_id = $rcp->transport_mode_id;
303 if (!empty($rcp->multicurrency_code)) {
304 $multicurrency_code = $rcp->multicurrency_code;
307 if (empty($cond_reglement_id)
308 || empty($mode_reglement_id)
309 || empty($fk_account)
310 || empty($transport_mode_id)
311 || empty($multicurrency_code)
313 if (!isset($rcp->supplier_order)) {
314 $rcp->fetch_origin();
318 if (!empty($rcp->origin_object)) {
319 $supplierOrder = $rcp->origin_object;
320 if (empty($cond_reglement_id) && !empty($supplierOrder->cond_reglement_id)) {
321 $cond_reglement_id = $supplierOrder->cond_reglement_id;
323 if (empty($mode_reglement_id) && !empty($supplierOrder->mode_reglement_id)) {
324 $mode_reglement_id = $supplierOrder->mode_reglement_id;
326 if (empty($fk_account) && !empty($supplierOrder->fk_account)) {
327 $fk_account = $supplierOrder->fk_account;
329 if (empty($transport_mode_id) && !empty($supplierOrder->transport_mode_id)) {
330 $transport_mode_id = $supplierOrder->transport_mode_id;
332 if (empty($multicurrency_code) && !empty($supplierOrder->multicurrency_code)) {
333 $multicurrency_code = $supplierOrder->multicurrency_code;
338 if (!empty($rcp->thirdparty)) {
339 $soc = $rcp->thirdparty;
340 if (empty($cond_reglement_id) && !empty($soc->cond_reglement_supplier_id)) {
341 $cond_reglement_id = $soc->cond_reglement_supplier_id;
343 if (empty($mode_reglement_id) && !empty($soc->mode_reglement_supplier_id)) {
344 $mode_reglement_id = $soc->mode_reglement_supplier_id;
346 if (empty($fk_account) && !empty($soc->fk_account)) {
347 $fk_account = $soc->fk_account;
349 if (empty($transport_mode_id) && !empty($soc->transport_mode_id)) {
350 $transport_mode_id = $soc->transport_mode_id;
352 if (empty($multicurrency_code) && !empty($soc->multicurrency_code)) {
353 $multicurrency_code = $soc->multicurrency_code;
359 $objecttmp->socid = $rcp->socid;
360 $objecttmp->type = $objecttmp::TYPE_STANDARD;
361 $objecttmp->cond_reglement_id = $cond_reglement_id;
362 $objecttmp->mode_reglement_id = $mode_reglement_id;
363 $objecttmp->fk_account = $fk_account;
364 $objecttmp->transport_mode_id = $transport_mode_id;
365 $objecttmp->multicurrency_code = $multicurrency_code;
368 if (is_object($soc)) {
369 $objecttmp->vat_reverse_charge = $soc->vat_reverse_charge;
372 $objecttmp->fk_project = $rcp->fk_project;
374 if (empty($createbills_onebythird)) {
375 $objecttmp->ref_supplier = $rcp->ref;
378 $objecttmp->ref_supplier = $langs->trans(
"Reception").
' '.
dol_print_date(
dol_now(),
'dayhourlog').
'-'.$rcp->socid;
382 if (empty($datefacture)) {
386 $objecttmp->date = $datefacture;
387 $objecttmp->origin =
'reception';
388 $objecttmp->origin_id = (int) $id_reception;
391 if (empty($objecttmp->date_echeance)) {
392 $objecttmp->date_echeance = $objecttmp->calculate_date_lim_reglement();
395 $objecttmp->array_options = $rcp->array_options;
398 $rcp->fetchObjectLinked();
399 if (count($rcp->linkedObjectsIds[
'order_supplier']) > 0) {
400 foreach ($rcp->linkedObjectsIds[
'order_supplier'] as $key => $value) {
401 $objecttmp->linked_objects[
'order_supplier'] = $value;
405 $res = $objecttmp->create($user);
410 $lastref = $objecttmp->ref;
411 $lastid = $objecttmp->id;
413 $TFactThird[$rcp->socid] = $objecttmp;
414 $TFactThirdNbLines[$rcp->socid] = 0;
416 $langs->load(
"errors");
417 $errors[] = $rcp->ref.
' : '.$langs->trans($objecttmp->error);
422 if ($objecttmp->id > 0) {
423 if (!isset($rcp->origin_object)) {
424 $rcp->fetch_origin();
426 if ($rcp->origin_object->multicurrency_code != $objecttmp->multicurrency_code) {
427 $errors[] = $rcp->ref.
" : ".$langs->trans(
"ReceptionMustBeInTheSameCurrencyThanOther");
430 $res = $objecttmp->add_object_linked($objecttmp->origin, $id_reception);
433 $errors[] = $objecttmp->error;
438 $lines = $rcp->lines;
439 if (empty($lines) && method_exists($rcp,
'fetch_lines')) {
441 $lines = $rcp->lines;
445 $num = count($lines);
447 for ($i = 0; $i < $num; $i++) {
448 $desc = ($lines[$i]->desc ? $lines[$i]->desc : $lines[$i]->libelle);
450 if (!empty($createbills_onebythird)) {
451 $desc =
dol_concatdesc($desc, $langs->trans(
"Reception").
' '.$rcp->ref);
452 $desc .= (!empty($rcp->date_reception) ?
' - '.dol_print_date($rcp->date_reception,
'day') :
'');
455 if ($lines[$i]->subprice < 0) {
458 $discount->discount_type = 1;
459 $discount->fk_soc = $objecttmp->socid;
460 $discount->socid = $objecttmp->socid;
461 $discount->amount_ht = abs($lines[$i]->total_ht);
462 $discount->amount_tva = abs($lines[$i]->total_tva);
463 $discount->amount_ttc = abs($lines[$i]->total_ttc);
464 $discount->tva_tx = $lines[$i]->tva_tx;
465 $discount->fk_user = $user->id;
466 $discount->description = $desc;
467 $discountid = $discount->create($user);
468 if ($discountid > 0) {
469 $result = $objecttmp->insert_discount($discountid);
478 $product_type = ($lines[$i]->product_type ? $lines[$i]->product_type : 0);
481 if ($lines[$i]->date_debut_prevue) {
484 if ($lines[$i]->date_debut_reel) {
487 if ($lines[$i]->date_start) {
492 if ($lines[$i]->date_fin_prevue) {
493 $date_end = $lines[$i]->date_fin_prevue;
495 if ($lines[$i]->date_fin_reel) {
496 $date_end = $lines[$i]->date_fin_reel;
498 if ($lines[$i]->date_end) {
499 $date_end = $lines[$i]->date_end;
502 if (($lines[$i]->product_type != 9 && empty($lines[$i]->fk_parent_line)) || $lines[$i]->product_type == 9) {
507 if (method_exists($lines[$i],
'fetch_optionals')) {
508 $lines[$i]->fetch_optionals();
509 $array_options = $lines[$i]->array_options;
512 $objecttmp->context[
'createfromclone'] =
'createfromclone';
516 if (!empty($createbills_onebythird)) {
517 $rang = $TFactThirdNbLines[$rcp->socid];
520 $result = $objecttmp->addline(
522 $lines[$i]->subprice,
524 $lines[$i]->localtax1_tx,
525 $lines[$i]->localtax2_tx,
527 $lines[$i]->fk_product,
528 $lines[$i]->remise_percent,
532 (
int) $lines[$i]->info_bits,
540 $lines[$i]->multicurrency_subprice,
541 $lines[$i]->ref_supplier
544 $rcp->add_object_linked(
'facture_fourn_det', $result);
548 if (!empty($createbills_onebythird)) {
549 $TFactThirdNbLines[$rcp->socid]++;
557 if ($result > 0 && $lines[$i]->product_type == 9) {
558 $fk_parent_line = $result;
567 if (!empty($createbills_onebythird) && empty($TFactThird[$rcp->socid])) {
568 $TFactThird[$rcp->socid] = $objecttmp;
570 $TFact[$objecttmp->id] = $objecttmp;
575 $TAllFact = empty($createbills_onebythird) ? $TFact : $TFactThird;
578 if (!$error && $validate_invoices) {
579 $massaction = $action =
'builddoc';
580 foreach ($TAllFact as &$objecttmp) {
581 $result = $objecttmp->validate($user);
588 $id = $objecttmp->id;
589 $lastref = $objecttmp->ref;
594 $upload_dir =
$conf->fournisseur->facture->dir_output;
595 $permissiontoadd = ($user->hasRight(
'fournisseur',
'facture',
'creer') || $user->hasRight(
'supplier_invoice',
'creer'));
600 include DOL_DOCUMENT_ROOT.
'/core/actions_builddoc.inc.php';
604 $massaction = $action =
'confirm_createbills';
610 if ($nb_bills_created == 1) {
611 $texttoshow = $langs->trans(
'BillXCreated',
'{s1}');
612 $texttoshow = str_replace(
'{s1}',
'<a href="'.DOL_URL_ROOT.
'/fourn/facture/card.php?id='.urlencode((
string) ($lastid)).
'">'.$lastref.
'</a>', $texttoshow);
615 setEventMessages($langs->trans(
'BillCreated', $nb_bills_created),
null,
'mesgs');
621 $_GET[
"origin"] =
GETPOST(
"origin",
'alpha');
642$title = $langs->trans(
'Receptions');
643$helpurl =
'EN:Module_Receptions|FR:Module_Receptions|ES:Módulo_Receptiones';
644llxHeader(
'', $title, $helpurl,
'', 0, 0,
'',
'',
'',
'bodyforlist mod-reception page-list');
646$sql =
"SELECT e.rowid, e.ref, e.ref_supplier, e.date_reception as date_reception, e.date_delivery as delivery_date, l.date_delivery as date_reception2, e.fk_statut as status, e.billed,e.note_private, e.note_public,";
647$sql .=
" s.rowid as socid, s.nom as name, s.town, s.zip, s.fk_pays, s.client, s.code_client,";
648$sql .=
" typent.code as typent_code,";
649$sql .=
" state.code_departement as state_code, state.nom as state_name,";
650$sql .=
" e.date_creation as date_creation, e.tms as date_modification";
652if (!empty($extrafields->attributes[
$object->table_element][
'label'])) {
653 foreach ($extrafields->attributes[
$object->table_element][
'label'] as $key => $val) {
654 $sql .= ($extrafields->attributes[
$object->table_element][
'type'][$key] !=
'separate' ?
", ef.".$key.
" as options_".$key :
'');
658$parameters = array();
659$reshook = $hookmanager->executeHooks(
'printFieldListSelect', $parameters);
660$sql .= $hookmanager->resPrint;
664$sql .=
" FROM ".MAIN_DB_PREFIX.
"reception as e";
665if (!empty($extrafields->attributes[
$object->table_element][
'label']) && is_array($extrafields->attributes[
$object->table_element][
'label']) && count($extrafields->attributes[
$object->table_element][
'label'])) {
666 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.$object->table_element.
"_extrafields as ef on (e.rowid = ef.fk_object)";
668$sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"societe as s ON s.rowid = e.fk_soc";
669$sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"c_country as country on (country.rowid = s.fk_pays)";
670$sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"c_typent as typent on (typent.id = s.fk_typent)";
671$sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"c_departements as state on (state.rowid = s.fk_departement)";
672$sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"element_element as ee ON e.rowid = ee.fk_source AND ee.sourcetype = 'reception' AND ee.targettype = 'delivery'";
673$sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"delivery as l ON l.rowid = ee.fk_target";
675$parameters = array();
677$reshook = $hookmanager->executeHooks(
'printFieldListFrom', $parameters, $object);
678$sql .= $hookmanager->resPrint;
679$sql .=
" WHERE e.entity IN (".getEntity(
'reception').
")";
681 $sql .=
" AND e.fk_soc = ".((int) $socid);
683if ($search_status !=
'' && $search_status >= 0) {
684 $sql .=
" AND e.fk_statut = ".((int) $search_status);
686if ($search_billed !=
'' && $search_billed >= 0) {
687 $sql .=
' AND e.billed = '.((int) $search_billed);
698if ($search_country) {
699 $sql .=
" AND s.fk_pays IN (".$db->sanitize($search_country).
')';
701if ($search_type_thirdparty !=
'' && $search_type_thirdparty > 0) {
702 $sql .=
" AND s.fk_typent IN (".$db->sanitize($search_type_thirdparty).
')';
704if ($search_date_delivery_start) {
705 $sql .=
" AND e.date_delivery >= '".$db->idate($search_date_delivery_start).
"'";
707if ($search_date_delivery_end) {
708 $sql .=
" AND e.date_delivery <= '".$db->idate($search_date_delivery_end).
"'";
710if ($search_date_create_start) {
711 $sql .=
" AND e.date_creation >= '".$db->idate($search_date_create_start).
"'";
714if ($search_note_public) {
715 $sql .=
" AND e.note_public LIKE '%".$db->escape(
$db->escapeforlike($search_note_public)).
"%'";
717if ($search_note_private) {
718 $sql .=
" AND e.note_private LIKE '%".$db->escape(
$db->escapeforlike($search_note_private)).
"%'";
720if ($search_date_create_end) {
721 $sql .=
" AND e.date_creation <= '".$db->idate($search_date_create_end).
"'";
723if ($search_ref_rcp) {
726if ($search_ref_liv) {
729if ($search_company) {
732if ($search_ref_supplier) {
736 $sql .=
natural_search(array_keys($fieldstosearchall), $search_all);
749include DOL_DOCUMENT_ROOT.
'/core/tpl/extrafields_list_search_sql.tpl.php';
751$parameters = array();
752$reshook = $hookmanager->executeHooks(
'printFieldListWhere', $parameters);
753$sql .= $hookmanager->resPrint;
756$parameters = array();
757$reshook = $hookmanager->executeHooks(
'printFieldListHaving', $parameters, $object);
758if (empty($reshook)) {
759 $sql .= empty($hookmanager->resPrint) ?
"" :
" HAVING 1=1 ".$hookmanager->resPrint;
761 $sql = $hookmanager->resPrint;
764$nbtotalofrecords =
'';
767 $sqlforcount = preg_replace(
'/^'.preg_quote($sqlfields,
'/').
'/',
'SELECT COUNT(*) as nbtotalofrecords', $sql);
768 $sqlforcount = preg_replace(
'/GROUP BY .*$/',
'', $sqlforcount);
769 $resql =
$db->query($sqlforcount);
771 $objforcount =
$db->fetch_object($resql);
772 $nbtotalofrecords = $objforcount->nbtotalofrecords;
777 if (($page * $limit) > (
int) $nbtotalofrecords) {
785$sql .=
$db->order($sortfield, $sortorder);
787 $sql .=
$db->plimit($limit + 1, $offset);
791$resql =
$db->query($sql);
797$num =
$db->num_rows($resql);
801$arrayofselected = is_array($toselect) ? $toselect : array();
805 $param .=
'&mode='.urlencode($mode);
807if (!empty($contextpage) && $contextpage != $_SERVER[
"PHP_SELF"]) {
808 $param .=
'&contextpage='.urlencode($contextpage);
810if ($limit > 0 && $limit !=
$conf->liste_limit) {
811 $param .=
'&limit='.((int) $limit);
814 $param .=
"&search_all=".urlencode($search_all);
816if ($search_ref_rcp) {
817 $param .=
"&search_ref_rcp=".urlencode($search_ref_rcp);
819if ($search_ref_liv) {
820 $param .=
"&search_ref_liv=".urlencode($search_ref_liv);
822if ($search_company) {
823 $param .=
"&search_company=".urlencode($search_company);
825if ($optioncss !=
'') {
826 $param .=
'&optioncss='.urlencode($optioncss);
828if ($search_billed !=
'' && $search_billed >= 0) {
829 $param .=
"&search_billed=".urlencode((
string) ($search_billed));
832 $param .=
"&search_town=".urlencode($search_town);
835 $param .=
"&search_zip=".urlencode($search_zip);
838 $param .=
"&search_state=".urlencode($search_state);
840if ($search_status !=
'') {
841 $param .=
"&search_status=".urlencode($search_status);
843if ($search_country) {
844 $param .=
"&search_country=".urlencode((
string) ($search_country));
846if ($search_type_thirdparty) {
847 $param .=
"&search_type_thirdparty=".urlencode((
string) ($search_type_thirdparty));
849if ($search_date_delivery_startday) {
850 $param .=
'&search_date_delivery_startday='.urlencode((
string) ($search_date_delivery_startday));
852if ($search_date_delivery_startmonth) {
853 $param .=
'&search_date_delivery_startmonth='.urlencode((
string) ($search_date_delivery_startmonth));
855if ($search_date_delivery_startyear) {
856 $param .=
'&search_date_delivery_startyear='.urlencode((
string) ($search_date_delivery_startyear));
858if ($search_date_delivery_endday) {
859 $param .=
'&search_date_delivery_endday='.urlencode((
string) ($search_date_delivery_endday));
861if ($search_date_delivery_endmonth) {
862 $param .=
'&search_date_delivery_endmonth='.urlencode((
string) ($search_date_delivery_endmonth));
864if ($search_date_delivery_endyear) {
865 $param .=
'&search_date_delivery_endyear='.urlencode((
string) ($search_date_delivery_endyear));
867if ($search_date_create_startday) {
868 $param .=
'&search_date_create_startday='.urlencode((
string) ($search_date_create_startday));
870if ($search_date_create_startmonth) {
871 $param .=
'&search_date_create_startmonth='.urlencode((
string) ($search_date_create_startmonth));
873if ($search_date_create_startyear) {
874 $param .=
'&search_date_create_startyear='.urlencode((
string) ($search_date_create_startyear));
876if ($search_date_create_endday) {
877 $param .=
'&search_date_create_endday='.urlencode((
string) ($search_date_create_endday));
879if ($search_date_create_endmonth) {
880 $param .=
'&search_date_create_endmonth='.urlencode((
string) ($search_date_create_endmonth));
882if ($search_date_create_endyear) {
883 $param .=
'&search_date_create_endyear='.urlencode((
string) ($search_date_create_endyear));
885if ($search_ref_supplier) {
886 $param .=
"&search_ref_supplier=".urlencode($search_ref_supplier);
889if ($search_array_options) {
890 foreach ($search_array_options as $key => $val) {
892 $tmpkey = preg_replace(
'/search_options_/',
'', $key);
893 if (is_array($val) && array_key_exists(
'start', $val) && array_key_exists(
'end', $val)) {
896 $param .=
'&search_options_'.$tmpkey.
'_startyear='.
dol_print_date($val[
'start'],
'%Y');
897 $param .=
'&search_options_'.$tmpkey.
'_startmonth='.
dol_print_date($val[
'start'],
'%m');
898 $param .=
'&search_options_'.$tmpkey.
'_startday='.
dol_print_date($val[
'start'],
'%d');
899 $param .=
'&search_options_'.$tmpkey.
'_starthour='.
dol_print_date($val[
'start'],
'%H');
900 $param .=
'&search_options_'.$tmpkey.
'_startmin='.
dol_print_date($val[
'start'],
'%M');
902 $param .=
'&search_options_'.$tmpkey.
'_endyear='.
dol_print_date($val[
'end'],
'%Y');
903 $param .=
'&search_options_'.$tmpkey.
'_endmonth='.
dol_print_date($val[
'end'],
'%m');
904 $param .=
'&search_options_'.$tmpkey.
'_endday='.
dol_print_date($val[
'end'],
'%d');
905 $param .=
'&search_options_'.$tmpkey.
'_endhour='.
dol_print_date($val[
'end'],
'%H');
906 $param .=
'&search_options_'.$tmpkey.
'_endmin='.
dol_print_date($val[
'end'],
'%M');
910 $param .=
'&search_options_'.$tmpkey.
'='.urlencode($val);
916$arrayofmassactions = array(
917 'builddoc' =>
img_picto(
'',
'pdf',
'class="pictofixedwidth"').$langs->trans(
"PDFMerge"),
921if ($user->hasRight(
'fournisseur',
'facture',
'creer') || $user->hasRight(
'supplier_invoice',
'creer')) {
922 $arrayofmassactions[
'createbills'] = $langs->trans(
"CreateInvoiceForThisReceptions");
924if (in_array($massaction, array(
'presend',
'createbills'))) {
925 $arrayofmassactions = array();
927$massactionbutton = $form->selectMassAction(
'', $arrayofmassactions);
934$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'));
935$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'));
936$newcardbutton .=
dolGetButtonTitle($langs->trans(
'Statistics'),
'',
'fa fa-chart-bar imgforviewmode', DOL_URL_ROOT.
'/reception/stats/index.php?mode=statistics'.preg_replace(
'/(&|\?)*(mode|groupby)=[^&]+/',
'', $param),
'', ($mode ==
'statistics' ? 2 : 1), array(
'morecss' =>
'reposition'));
938$newcardbutton .=
dolGetButtonTitle($langs->trans(
'NewReception'),
'',
'fa fa-plus-circle', DOL_URL_ROOT.
'/reception/card.php?action=create',
'', $user->hasRight(
'reception',
'creer'));
941print
'<form method="POST" action="'.$_SERVER[
"PHP_SELF"].
'">'.
"\n";
942if ($optioncss !=
'') {
943 print
'<input type="hidden" name="optioncss" value="'.$optioncss.
'">';
945print
'<input type="hidden" name="token" value="'.newToken().
'">';
946print
'<input type="hidden" name="formfilteraction" id="formfilteraction" value="list">';
947print
'<input type="hidden" name="action" value="list">';
948print
'<input type="hidden" name="sortfield" value="'.$sortfield.
'">';
949print
'<input type="hidden" name="sortorder" value="'.$sortorder.
'">';
950print
'<input type="hidden" name="mode" value="'.$mode.
'">';
953print_barre_liste($title, $page, $_SERVER[
"PHP_SELF"], $param, $sortfield, $sortorder, $massactionbutton, $num, $nbtotalofrecords,
'dollyrevert', 0, $newcardbutton,
'', $limit, 0, 0, 1);
955if ($massaction ==
'createbills') {
957 print
'<input type="hidden" name="massaction" value="confirm_createbills">';
959 print
'<table class="noborder centpercent">';
961 print
'<td class="titlefieldmiddle">';
962 print $langs->trans(
'DateInvoice');
965 print $form->selectDate(
'',
'', 0, 0, 0,
'', 1, 1);
970 print $langs->trans(
'CreateOneBillByThird');
973 print $form->selectyesno(
'createbills_onebythird',
'', 1);
978 print $langs->trans(
'ValidateInvoices');
982 print $form->selectyesno(
'validate_invoices', 0, 1, 1);
983 print
' ('.$langs->trans(
"AutoValidationNotPossibleWhenStockIsDecreasedOnInvoiceValidation").
')';
985 print $form->selectyesno(
'validate_invoices', 0, 1);
992 print
'<div class="center">';
993 print
'<input type="submit" class="button" id="createbills" name="createbills" value="'.$langs->trans(
'CreateInvoiceForThisReceptions').
'"> ';
994 print
'<input type="submit" class="button button-cancel" id="cancel" name="cancel" value="'.$langs->trans(
"Cancel").
'">';
1000 foreach ($fieldstosearchall as $key => $val) {
1001 $fieldstosearchall[$key] = $langs->trans($val);
1003 print
'<div class="divsearchfieldfilter">'.$langs->trans(
"FilterOnInto", $search_all).implode(
', ', $fieldstosearchall).
'</div>';
1008if (!empty($moreforfilter)) {
1009 print
'<div class="liste_titre liste_titre_bydiv centpercent">';
1010 print $moreforfilter;
1011 $parameters = array();
1012 $reshook = $hookmanager->executeHooks(
'printFieldPreListTitle', $parameters, $object, $action);
1013 print $hookmanager->resPrint;
1017$varpage = empty($contextpage) ? $_SERVER[
"PHP_SELF"] : $contextpage;
1018$selectedfields = $form->multiSelectArrayWithCheckbox(
'selectedfields', $arrayfields, $varpage,
$conf->main_checkbox_left_column);
1019if ($massactionbutton) {
1020 $selectedfields .= $form->showCheckAddButtons(
'checkforselect', 1);
1023print
'<div class="div-table-responsive">';
1024print
'<table class="tagtable liste'.($moreforfilter ?
" listwithfilterbefore" :
"").
'">'.
"\n";
1028print
'<tr class="liste_titre_filter">';
1030if (
$conf->main_checkbox_left_column) {
1031 print
'<td class="liste_titre center maxwidthsearch">';
1032 $searchpicto = $form->showFilterButtons(
'left');
1037if (!empty($arrayfields[
'e.ref'][
'checked'])) {
1038 print
'<td class="liste_titre">';
1039 print
'<input class="flat" size="6" type="text" name="search_ref_rcp" value="'.$search_ref_rcp.
'">';
1043if (!empty($arrayfields[
'e.ref_supplier'][
'checked'])) {
1044 print
'<td class="liste_titre">';
1045 print
'<input class="flat" size="6" type="text" name="search_ref_supplier" value="'.$search_ref_supplier.
'">';
1049if (!empty($arrayfields[
's.nom'][
'checked'])) {
1050 print
'<td class="liste_titre left">';
1051 print
'<input class="flat" type="text" size="8" name="search_company" value="'.dol_escape_htmltag($search_company).
'">';
1055if (!empty($arrayfields[
's.town'][
'checked'])) {
1056 print
'<td class="liste_titre"><input class="flat" type="text" size="6" name="search_town" value="'.$search_town.
'"></td>';
1059if (!empty($arrayfields[
's.zip'][
'checked'])) {
1060 print
'<td class="liste_titre"><input class="flat" type="text" size="6" name="search_zip" value="'.$search_zip.
'"></td>';
1063if (!empty($arrayfields[
'state.nom'][
'checked'])) {
1064 print
'<td class="liste_titre">';
1065 print
'<input class="flat" size="4" type="text" name="search_state" value="'.dol_escape_htmltag($search_state).
'">';
1069if (!empty($arrayfields[
'country.code_iso'][
'checked'])) {
1070 print
'<td class="liste_titre center">';
1071 print $form->select_country($search_country,
'search_country',
'', 0,
'minwidth100imp maxwidth100');
1075if (!empty($arrayfields[
'typent.code'][
'checked'])) {
1076 print
'<td class="liste_titre maxwidthonsmartphone center">';
1077 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'),
'', 1);
1081if (!empty($arrayfields[
'e.date_delivery'][
'checked'])) {
1082 print
'<td class="liste_titre center">';
1083 print
'<div class="nowrapfordate">';
1084 print $form->selectDate($search_date_delivery_start ? $search_date_delivery_start : -1,
'search_date_delivery_start', 0, 0, 1,
'', 1, 0, 0,
'',
'',
'',
'', 1,
'', $langs->trans(
'From'));
1086 print
'<div class="nowrapfordate">';
1087 print $form->selectDate($search_date_delivery_end ? $search_date_delivery_end : -1,
'search_date_delivery_end', 0, 0, 1,
'', 1, 0, 0,
'',
'',
'',
'', 1,
'', $langs->trans(
'to'));
1091if (!empty($arrayfields[
'l.ref'][
'checked'])) {
1093 print
'<td class="liste_titre">';
1094 print
'<input class="flat" type="text" name="search_ref_liv" value="'.dol_escape_htmltag($search_ref_liv).
'"';
1097if (!empty($arrayfields[
'l.date_delivery'][
'checked'])) {
1099 print
'<td class="liste_titre center"> </td>';
1102include DOL_DOCUMENT_ROOT.
'/core/tpl/extrafields_list_search_input.tpl.php';
1105$parameters = array(
'arrayfields' => $arrayfields);
1106$reshook = $hookmanager->executeHooks(
'printFieldListOption', $parameters);
1107print $hookmanager->resPrint;
1109if (!empty($arrayfields[
'e.datec'][
'checked'])) {
1110 print
'<td class="liste_titre center">';
1111 print
'<div class="nowrapfordate">';
1112 print $form->selectDate($search_date_create_start ? $search_date_create_start : -1,
'search_date_create_start', 0, 0, 1,
'', 1, 0, 0,
'',
'',
'',
'', 1,
'', $langs->trans(
'From'));
1114 print
'<div class="nowrapfordate">';
1115 print $form->selectDate($search_date_create_end ? $search_date_create_end : -1,
'search_date_create_end', 0, 0, 1,
'', 1, 0, 0,
'',
'',
'',
'', 1,
'', $langs->trans(
'to'));
1120if (!empty($arrayfields[
'e.tms'][
'checked'])) {
1121 print
'<td class="liste_titre">';
1124if (!empty($arrayfields[
'e.note_public'][
'checked'])) {
1126 print
'<td class="liste_titre">';
1127 print
'<input class="flat maxwidth75" type="text" name="search_note_public" value="'.dol_escape_htmltag($search_note_public).
'">';
1130if (!empty($arrayfields[
'e.note_private'][
'checked'])) {
1132 print
'<td class="liste_titre">';
1133 print
'<input class="flat maxwidth75" type="text" name="search_note_private" value="'.dol_escape_htmltag($search_note_private).
'">';
1137if (!empty($arrayfields[
'e.fk_statut'][
'checked'])) {
1138 print
'<td class="liste_titre right parentonrightofpage">';
1139 print $form->selectarray(
'search_status', array(
'0' => $langs->trans(
'StatusReceptionDraftShort'),
'1' => $langs->trans(
'StatusReceptionValidatedShort'),
'2' => $langs->trans(
'StatusReceptionProcessedShort')), $search_status, 1, 0, 0,
'', 0, 0, 0,
'',
'search_status width100 onrightofpage');
1143if (!empty($arrayfields[
'e.billed'][
'checked'])) {
1144 print
'<td class="liste_titre maxwidthonsmartphone center">';
1145 print $form->selectyesno(
'search_billed', $search_billed, 1, 0, 1);
1149if (!
$conf->main_checkbox_left_column) {
1150 print
'<td class="liste_titre middle">';
1151 $searchpicto = $form->showFilterButtons();
1162print
'<tr class="liste_titre">';
1164if (
$conf->main_checkbox_left_column) {
1165 print_liste_field_titre($selectedfields, $_SERVER[
"PHP_SELF"],
"",
'',
'',
'', $sortfield, $sortorder,
'center maxwidthsearch ');
1168if (!empty($arrayfields[
'e.ref'][
'checked'])) {
1170 print_liste_field_titre($arrayfields[
'e.ref'][
'label'], $_SERVER[
"PHP_SELF"],
"e.ref",
"", $param,
'', $sortfield, $sortorder);
1173if (!empty($arrayfields[
'e.ref_supplier'][
'checked'])) {
1174 print_liste_field_titre($arrayfields[
'e.ref_supplier'][
'label'], $_SERVER[
"PHP_SELF"],
"e.ref_supplier",
"", $param,
'', $sortfield, $sortorder);
1177if (!empty($arrayfields[
's.nom'][
'checked'])) {
1178 print_liste_field_titre($arrayfields[
's.nom'][
'label'], $_SERVER[
"PHP_SELF"],
"s.nom",
"", $param,
'', $sortfield, $sortorder,
'left ');
1181if (!empty($arrayfields[
's.town'][
'checked'])) {
1182 print_liste_field_titre($arrayfields[
's.town'][
'label'], $_SERVER[
"PHP_SELF"],
's.town',
'', $param,
'', $sortfield, $sortorder);
1185if (!empty($arrayfields[
's.zip'][
'checked'])) {
1186 print_liste_field_titre($arrayfields[
's.zip'][
'label'], $_SERVER[
"PHP_SELF"],
's.zip',
'', $param,
'', $sortfield, $sortorder);
1189if (!empty($arrayfields[
'state.nom'][
'checked'])) {
1190 print_liste_field_titre($arrayfields[
'state.nom'][
'label'], $_SERVER[
"PHP_SELF"],
"state.nom",
"", $param,
'', $sortfield, $sortorder);
1193if (!empty($arrayfields[
'country.code_iso'][
'checked'])) {
1194 print_liste_field_titre($arrayfields[
'country.code_iso'][
'label'], $_SERVER[
"PHP_SELF"],
"country.code_iso",
"", $param,
'', $sortfield, $sortorder,
'center ');
1197if (!empty($arrayfields[
'typent.code'][
'checked'])) {
1198 print_liste_field_titre($arrayfields[
'typent.code'][
'label'], $_SERVER[
"PHP_SELF"],
"typent.code",
"", $param,
'', $sortfield, $sortorder,
'center ');
1201if (!empty($arrayfields[
'e.date_delivery'][
'checked'])) {
1202 print_liste_field_titre($arrayfields[
'e.date_delivery'][
'label'], $_SERVER[
"PHP_SELF"],
"e.date_delivery",
"", $param,
'', $sortfield, $sortorder,
'center ');
1205if (!empty($arrayfields[
'l.ref'][
'checked'])) {
1206 print_liste_field_titre($arrayfields[
'l.ref'][
'label'], $_SERVER[
"PHP_SELF"],
"l.ref",
"", $param,
'', $sortfield, $sortorder);
1209if (!empty($arrayfields[
'l.date_delivery'][
'checked'])) {
1210 print_liste_field_titre($arrayfields[
'l.date_delivery'][
'label'], $_SERVER[
"PHP_SELF"],
"l.date_delivery",
"", $param,
'', $sortfield, $sortorder,
'center ');
1214include DOL_DOCUMENT_ROOT.
'/core/tpl/extrafields_list_search_title.tpl.php';
1216$parameters = array(
'arrayfields' => $arrayfields,
'param' => $param,
'sortfield' => $sortfield,
'sortorder' => $sortorder,
'$totalarray' => &
$totalarray);
1217$reshook = $hookmanager->executeHooks(
'printFieldListTitle', $parameters, $object);
1218print $hookmanager->resPrint;
1219if (!empty($arrayfields[
'e.datec'][
'checked'])) {
1220 print_liste_field_titre($arrayfields[
'e.datec'][
'label'], $_SERVER[
"PHP_SELF"],
"e.date_creation",
"", $param,
'', $sortfield, $sortorder,
'center nowrap ');
1223if (!empty($arrayfields[
'e.tms'][
'checked'])) {
1224 print_liste_field_titre($arrayfields[
'e.tms'][
'label'], $_SERVER[
"PHP_SELF"],
"e.tms",
"", $param,
'', $sortfield, $sortorder,
'center nowrap ');
1227if (!empty($arrayfields[
'e.note_public'][
'checked'])) {
1228 print_liste_field_titre($arrayfields[
'e.note_public'][
'label'], $_SERVER[
"PHP_SELF"],
"e.note_public",
"", $param,
'', $sortfield, $sortorder,
'center nowrap ');
1231if (!empty($arrayfields[
'e.note_private'][
'checked'])) {
1232 print_liste_field_titre($arrayfields[
'e.note_private'][
'label'], $_SERVER[
"PHP_SELF"],
"e.note_private",
"", $param,
'', $sortfield, $sortorder,
'center nowrap ');
1235if (!empty($arrayfields[
'e.fk_statut'][
'checked'])) {
1236 print_liste_field_titre($arrayfields[
'e.fk_statut'][
'label'], $_SERVER[
"PHP_SELF"],
"e.fk_statut",
"", $param,
'', $sortfield, $sortorder,
'right ');
1239if (!empty($arrayfields[
'e.billed'][
'checked'])) {
1240 print_liste_field_titre($arrayfields[
'e.billed'][
'label'], $_SERVER[
"PHP_SELF"],
"e.billed",
"", $param,
'', $sortfield, $sortorder,
'center ');
1244if (!
$conf->main_checkbox_left_column) {
1245 print_liste_field_titre($selectedfields, $_SERVER[
"PHP_SELF"],
"",
'',
'',
'', $sortfield, $sortorder,
'center maxwidthsearch ');
1257$imaxinloop = ($limit ? min($num, $limit) : $num);
1258while ($i < $imaxinloop) {
1259 $obj =
$db->fetch_object($resql);
1264 $reception->id = $obj->rowid;
1265 $reception->ref = $obj->ref;
1267 $reception->statut = $obj->status;
1268 $reception->status = $obj->status;
1269 $reception->socid = $obj->socid;
1270 $reception->billed = $obj->billed;
1271 $reception->note_public = $obj->note_public;
1272 $reception->note_private = $obj->note_private;
1274 $reception->fetch_thirdparty();
1278 $companystatic->id = $obj->socid;
1279 $companystatic->ref = $obj->name;
1280 $companystatic->name = $obj->name;
1282 if ($mode ==
'kanban') {
1284 print
'<tr class="trkanban"><td colspan="'.$savnbfield.
'">';
1285 print
'<div class="box-flex-container kanban">';
1287 $object->date_delivery = $obj->delivery_date;
1292 if ($massactionbutton || $massaction) {
1294 if (in_array(
$object->id, $arrayofselected)) {
1298 print
$object->getKanbanView(
'', array(
'thirdparty' => $companystatic->getNomUrl(1),
'selected' => $selected));
1299 if ($i == min($num, $limit) - 1) {
1304 print
'<tr class="oddeven row-with-select">';
1307 if (
$conf->main_checkbox_left_column) {
1308 print
'<td class="nowrap center">';
1309 if ($massactionbutton || $massaction) {
1311 if (in_array($obj->rowid, $arrayofselected)) {
1314 print
'<input id="cb'.$obj->rowid.
'" class="flat checkforselect" type="checkbox" name="toselect[]" value="'.$obj->rowid.
'"'.($selected ?
' checked="checked"' :
'').
'>';
1319 if (!empty($arrayfields[
'e.ref'][
'checked'])) {
1320 print
'<td class="nowraponall">';
1321 print $reception->getNomUrl(1);
1324 $urlsource = $_SERVER[
'PHP_SELF'].
'?id='.$reception->id;
1325 print $formfile->getDocumentsLink($reception->element, $filename, $filedir);
1334 if (!empty($arrayfields[
'e.ref_supplier'][
'checked'])) {
1335 print
'<td class="tdoverflowmax200" title="'.dol_escape_htmltag($obj->ref_supplier).
'">';
1344 if (!empty($arrayfields[
's.nom'][
'checked'])) {
1345 print
'<td class="tdoverflowmax150">';
1346 print $companystatic->getNomUrl(1);
1353 if (!empty($arrayfields[
's.town'][
'checked'])) {
1354 print
'<td class="nocellnopadd tdoverflowmax200" title="'.dol_escape_htmltag($obj->town).
'">';
1362 if (!empty($arrayfields[
's.zip'][
'checked'])) {
1363 print
'<td class="nocellnopadd center"">';
1371 if (!empty($arrayfields[
'state.nom'][
'checked'])) {
1372 print
"<td>".dol_escape_htmltag($obj->state_name).
"</td>\n";
1378 if (!empty($arrayfields[
'country.code_iso'][
'checked'])) {
1379 print
'<td class="center">';
1380 $tmparray =
getCountry($obj->fk_pays,
'all');
1388 if (!empty($arrayfields[
'typent.code'][
'checked'])) {
1389 print
'<td class="center">';
1390 if (!isset($typenArray) || empty($typenArray)) {
1391 $typenArray = $formcompany->typent_array(1);
1393 if (isset($typenArray[$obj->typent_code])) {
1394 print $typenArray[$obj->typent_code];
1403 if (!empty($arrayfields[
'e.date_delivery'][
'checked'])) {
1404 print
'<td class="center">';
1416 if (!empty($arrayfields[
'l.ref'][
'checked']) || !empty($arrayfields[
'l.date_delivery'][
'checked'])) {
1417 $reception->fetchObjectLinked($reception->id, $reception->element);
1419 if (count($reception->linkedObjects[
'delivery']) > 0) {
1420 $receiving = reset($reception->linkedObjects[
'delivery']);
1423 if (!empty($arrayfields[
'l.ref'][
'checked'])) {
1426 print !empty($receiving) ? $receiving->getNomUrl(
$db) :
'';
1430 if (!empty($arrayfields[
'l.date_delivery'][
'checked'])) {
1432 print
'<td class="center">';
1439 include DOL_DOCUMENT_ROOT.
'/core/tpl/extrafields_list_print_fields.tpl.php';
1442 $parameters = array(
'arrayfields' => $arrayfields,
'obj' => $obj,
'i' => $i,
'totalarray' => &
$totalarray);
1443 $reshook = $hookmanager->executeHooks(
'printFieldListValue', $parameters);
1444 print $hookmanager->resPrint;
1446 if (!empty($arrayfields[
'e.datec'][
'checked'])) {
1447 print
'<td class="center nowraponall">';
1455 if (!empty($arrayfields[
'e.tms'][
'checked'])) {
1456 print
'<td class="center nowraponall">';
1457 print
dol_print_date(
$db->jdate($obj->date_modification),
'dayhour',
'tzuserrel');
1464 if (!empty($arrayfields[
'e.note_public'][
'checked'])) {
1465 print
'<td class="sensiblehtmlcontent center">';
1466 print
'<div class="small lineheightsmall twolinesmax-normallineheight">'.dolPrintHTML(
dolGetFirstLineOfText($obj->note_public, 5)).
'</div>';
1473 if (!empty($arrayfields[
'e.note_private'][
'checked'])) {
1474 print
'<td class="sensiblehtmlcontent center">';
1475 print
'<div class="small lineheightsmall twolinesmax-normallineheight">'.dolPrintHTML(
dolGetFirstLineOfText($obj->note_private, 5)).
'</div>';
1482 if (!empty($arrayfields[
'e.fk_statut'][
'checked'])) {
1483 print
'<td class="right nowrap">'.$reception->LibStatut($obj->status, 5).
'</td>';
1489 if (!empty($arrayfields[
'e.billed'][
'checked'])) {
1490 print
'<td class="center">'.yn($obj->billed).
'</td>';
1497 if (!
$conf->main_checkbox_left_column) {
1498 print
'<td class="nowrap center">';
1499 if ($massactionbutton || $massaction) {
1502 if (in_array($obj->rowid, $arrayofselected)) {
1505 print
'<input id="cb'.$obj->rowid.
'" class="flat checkforselect" type="checkbox" name="toselect[]" value="'.$obj->rowid.
'"'.($selected ?
' checked="checked"' :
'').
'>';
1521 foreach ($arrayfields as $key => $val) {
1522 if (!empty($val[
'checked'])) {
1526 print
'<tr><td colspan="'.$colspan.
'" class="opacitymedium">'.$langs->trans(
"NoRecordFound").
'</td></tr>';
1530include DOL_DOCUMENT_ROOT.
'/core/tpl/list_print_total.tpl.php';
1532$parameters = array(
'arrayfields' => $arrayfields,
'totalarray' =>
$totalarray,
'sql' => $sql);
1533$reshook = $hookmanager->executeHooks(
'printFieldListFooter', $parameters);
1534print $hookmanager->resPrint;
1542$hidegeneratedfilelistifempty = 1;
1543if ($massaction ==
'builddoc' || $action ==
'remove_file') {
1544 $hidegeneratedfilelistifempty = 0;
1548$urlsource = $_SERVER[
'PHP_SELF'].
'?sortfield='.$sortfield.
'&sortorder='.$sortorder;
1549$urlsource .= str_replace(
'&',
'&', $param);
1551$filedir = $diroutputmassaction;
1552$genallowed = $user->hasRight(
'reception',
'lire');
1553$delallowed = $user->hasRight(
'reception',
'creer');
1556print $formfile->showdocuments(
'massfilesarea_receipts',
'', $filedir, $urlsource, 0, $delallowed,
'', 1, 1, 0, 48, 1, $param, $title,
'',
'',
'',
null, $hidegeneratedfilelistifempty);
$id
Support class for third parties, contacts, members, users or resources.
if(! $sortfield) if(! $sortorder) $object
llxFooter($comment='', $zone='private', $disabledoutputofmessages=0)
Empty footer.
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.
Class to manage absolute discounts.
Class to manage suppliers invoices.
Class to manage receptions.
Class to manage third parties objects (customers, suppliers, prospects...)
getCountry($searchkey, $withcode='', $dbtouse=null, $outputlangs=null, $entconv=1, $searchlabel='')
Return country label, code or id from an id, code or label.
$date_start
Variables from include:
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.
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)
dolGetFirstLineOfText($text, $nboflines=1, $charset='UTF-8')
Return first line of text.
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_sanitizeFileName($str, $newstr='_', $unaccent=1, $includequotes=0, $allowdash=0)
Clean a string to use it as a file name.
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.
dol_concatdesc($text1, $text2, $forxml=false, $invert=false)
Concat 2 descriptions with a new line between them (second operand after first one with appropriate n...
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...
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.