67 public $errors = array();
72 public $cache_types_paiements = array();
73 public $cache_conditions_paiements = array();
74 public $cache_transport_mode = array();
75 public $cache_availability = array();
76 public $cache_demand_reason = array();
77 public $cache_types_fees = array();
78 public $cache_vatrates = array();
107 public function editfieldkey($text, $htmlname, $preselected, $object, $perm, $typeofdata =
'string', $moreparam =
'', $fieldrequired = 0, $notabletag = 0, $paramid =
'id', $help =
'')
109 global $conf, $langs;
114 if (!empty($conf->global->MAIN_USE_JQUERY_JEDITABLE) && !preg_match(
'/^select;/', $typeofdata)) {
116 $tmp = explode(
':', $typeofdata);
117 $ret .=
'<div class="editkey_'.$tmp[0].(!empty($tmp[1]) ?
' '.$tmp[1] :
'').
'" id="'.$htmlname.
'">';
118 if ($fieldrequired) {
119 $ret .=
'<span class="fieldrequired">';
124 $ret .= $langs->trans($text);
126 if ($fieldrequired) {
129 $ret .=
'</div>'.
"\n";
131 if ($fieldrequired) {
132 $ret .=
'<span class="fieldrequired">';
137 $ret .= $langs->trans($text);
139 if ($fieldrequired) {
144 if (empty($notabletag) && $perm) {
145 $ret .=
'<table class="nobordernopadding centpercent"><tr><td class="nowrap">';
147 if ($fieldrequired) {
148 $ret .=
'<span class="fieldrequired">';
153 $ret .= $langs->trans($text);
155 if ($fieldrequired) {
158 if (!empty($notabletag)) {
161 if (empty($notabletag) && $perm) {
164 if (empty($notabletag) && $perm) {
165 $ret .=
'<td class="right">';
167 if ($htmlname &&
GETPOST(
'action',
'aZ09') !=
'edit'.$htmlname && $perm) {
168 $ret .=
'<a class="editfielda" href="'.$_SERVER[
"PHP_SELF"].
'?action=edit'.$htmlname.
'&token='.
newToken().
'&'.$paramid.
'='.$object->id.$moreparam.
'">'.
img_edit($langs->trans(
'Edit'), ($notabletag ? 0 : 1)).
'</a>';
170 if (!empty($notabletag) && $notabletag == 1) {
173 if (!empty($notabletag) && $notabletag == 3) {
176 if (empty($notabletag) && $perm) {
179 if (empty($notabletag) && $perm) {
180 $ret .=
'</tr></table>';
206 public function editfieldval($text, $htmlname, $value, $object, $perm, $typeofdata =
'string', $editvalue =
'', $extObject =
null, $custommsg =
null, $moreparam =
'', $notabletag = 0, $formatfunc =
'', $paramid =
'id', $gm =
'auto')
208 global $conf, $langs;
213 if (empty($typeofdata)) {
214 return 'ErrorBadParameter';
218 if (!empty($conf->global->MAIN_USE_JQUERY_JEDITABLE) && !preg_match(
'/^select;|day|datepicker|dayhour|datehourpicker/', $typeofdata)) {
219 $ret .= $this->
editInPlace($object, $value, $htmlname, $perm, $typeofdata, $editvalue, $extObject, $custommsg);
221 $editmode = (
GETPOST(
'action',
'aZ09') ==
'edit'.$htmlname);
224 $ret .=
'<form method="post" action="'.$_SERVER[
"PHP_SELF"].($moreparam ?
'?'.$moreparam :
'').
'">';
225 $ret .=
'<input type="hidden" name="action" value="set'.$htmlname.
'">';
226 $ret .=
'<input type="hidden" name="token" value="'.newToken().
'">';
227 $ret .=
'<input type="hidden" name="'.$paramid.
'" value="'.$object->id.
'">';
228 if (empty($notabletag)) {
229 $ret .=
'<table class="nobordernopadding centpercent">';
231 if (empty($notabletag)) {
234 if (preg_match(
'/^(string|safehtmlstring|email)/', $typeofdata)) {
235 $tmp = explode(
':', $typeofdata);
236 $ret .=
'<input type="text" id="'.$htmlname.
'" name="'.$htmlname.
'" value="'.($editvalue ? $editvalue : $value).
'"'.(empty($tmp[1]) ?
'' :
' size="'.$tmp[1].
'"').
' autofocus>';
237 } elseif (preg_match(
'/^(integer)/', $typeofdata)) {
238 $tmp = explode(
':', $typeofdata);
239 $valuetoshow =
price2num($editvalue ? $editvalue : $value, 0);
240 $ret .=
'<input type="text" id="'.$htmlname.
'" name="'.$htmlname.
'" value="'.$valuetoshow.
'"'.(empty($tmp[1]) ?
'' :
' size="'.$tmp[1].
'"').
' autofocus>';
241 } elseif (preg_match(
'/^(numeric|amount)/', $typeofdata)) {
242 $tmp = explode(
':', $typeofdata);
243 $valuetoshow =
price2num($editvalue ? $editvalue : $value);
244 $ret .=
'<input type="text" id="'.$htmlname.
'" name="'.$htmlname.
'" value="'.($valuetoshow !=
'' ?
price($valuetoshow) :
'').
'"'.(empty($tmp[1]) ?
'' :
' size="'.$tmp[1].
'"').
' autofocus>';
245 } elseif (preg_match(
'/^(checkbox)/', $typeofdata)) {
246 $tmp = explode(
':', $typeofdata);
247 $ret .=
'<input type="checkbox" id="' . $htmlname .
'" name="' . $htmlname .
'" value="' . $value .
'"' . (empty($tmp[1]) ?
'' : $tmp[1]) .
'/>';
248 } elseif (preg_match(
'/^text/', $typeofdata) || preg_match(
'/^note/', $typeofdata)) {
249 $tmp = explode(
':', $typeofdata);
250 $cols = (empty($tmp[2]) ?
'' : $tmp[2]);
252 if (preg_match(
'/%/', $cols)) {
253 $morealt =
' style="width: '.$cols.
'"';
257 $valuetoshow = ($editvalue ? $editvalue : $value);
258 $ret .=
'<textarea id="'.$htmlname.
'" name="'.$htmlname.
'" wrap="soft" rows="'.(empty($tmp[1]) ?
'20' : $tmp[1]).
'"'.($cols ?
' cols="'.$cols.
'"' :
'class="quatrevingtpercent"').$morealt.
'" autofocus>';
261 $valuetoshow = str_replace(
'&',
'&', $valuetoshow);
263 $ret .=
'</textarea>';
264 } elseif ($typeofdata ==
'day' || $typeofdata ==
'datepicker') {
265 $ret .= $this->
selectDate($value, $htmlname, 0, 0, 1,
'form'.$htmlname, 1, 0, 0,
'',
'',
'',
'', 1,
'',
'', $gm);
266 } elseif ($typeofdata ==
'dayhour' || $typeofdata ==
'datehourpicker') {
267 $ret .= $this->
selectDate($value, $htmlname, 1, 1, 1,
'form'.$htmlname, 1, 0, 0,
'',
'',
'',
'', 1,
'',
'', $gm);
268 } elseif (preg_match(
'/^select;/', $typeofdata)) {
269 $arraydata = explode(
',', preg_replace(
'/^select;/',
'', $typeofdata));
270 $arraylist = array();
271 foreach ($arraydata as $val) {
272 $tmp = explode(
':', $val);
273 $tmpkey = str_replace(
'|',
':', $tmp[0]);
274 $arraylist[$tmpkey] = $tmp[1];
276 $ret .= $this->
selectarray($htmlname, $arraylist, $value);
277 } elseif (preg_match(
'/^ckeditor/', $typeofdata)) {
278 $tmp = explode(
':', $typeofdata);
279 require_once DOL_DOCUMENT_ROOT.
'/core/class/doleditor.class.php';
280 $doleditor =
new DolEditor($htmlname, ($editvalue ? $editvalue : $value), (empty($tmp[2]) ?
'' : $tmp[2]), (empty($tmp[3]) ?
'100' : $tmp[3]), (empty($tmp[1]) ?
'dolibarr_notes' : $tmp[1]),
'In', (empty($tmp[5]) ? 0 : $tmp[5]), (isset($tmp[8]) ? ($tmp[8] ?
true :
false) :
true),
true, (empty($tmp[6]) ?
'20' : $tmp[6]), (empty($tmp[7]) ?
'100' : $tmp[7]));
281 $ret .= $doleditor->Create(1);
283 if (empty($notabletag)) {
288 if (empty($notabletag)) {
289 $ret .=
'<td class="left">';
292 $ret .=
'<input type="submit" class="smallpaddingimp button'.(empty($notabletag) ?
'' :
' ').
'" name="modify" value="'.$langs->trans(
"Modify").
'">';
293 if (preg_match(
'/ckeditor|textarea/', $typeofdata) && empty($notabletag)) {
296 $ret .=
'<input type="submit" class="smallpaddingimp button button-cancel'.(empty($notabletag) ?
'' :
' ').
'" name="cancel" value="'.$langs->trans(
"Cancel").
'">';
297 if (empty($notabletag)) {
301 if (empty($notabletag)) {
302 $ret .=
'</tr></table>'.
"\n";
304 $ret .=
'</form>'.
"\n";
306 if (preg_match(
'/^(email)/', $typeofdata)) {
308 } elseif (preg_match(
'/^(amount|numeric)/', $typeofdata)) {
309 $ret .= ($value !=
'' ?
price($value,
'', $langs, 0, -1, -1, $conf->currency) :
'');
310 } elseif (preg_match(
'/^(checkbox)/', $typeofdata)) {
311 $tmp = explode(
':', $typeofdata);
312 $ret .=
'<input type="checkbox" disabled id="' . $htmlname .
'" name="' . $htmlname .
'" value="' . $value .
'"' . ($tmp[1] ? $tmp[1] :
'') .
'/>';
313 } elseif (preg_match(
'/^text/', $typeofdata) || preg_match(
'/^note/', $typeofdata)) {
315 } elseif (preg_match(
'/^safehtmlstring/', $typeofdata)) {
317 } elseif (preg_match(
'/^restricthtml/', $typeofdata)) {
319 } elseif ($typeofdata ==
'day' || $typeofdata ==
'datepicker') {
320 $ret .=
'<span class="valuedate">'.dol_print_date($value,
'day', $gm).
'</span>';
321 } elseif ($typeofdata ==
'dayhour' || $typeofdata ==
'datehourpicker') {
322 $ret .=
'<span class="valuedate">'.dol_print_date($value,
'dayhour', $gm).
'</span>';
323 } elseif (preg_match(
'/^select;/', $typeofdata)) {
324 $arraydata = explode(
',', preg_replace(
'/^select;/',
'', $typeofdata));
325 $arraylist = array();
326 foreach ($arraydata as $val) {
327 $tmp = explode(
':', $val);
328 $arraylist[$tmp[0]] = $tmp[1];
330 $ret .= $arraylist[$value];
331 if ($htmlname ==
'fk_product_type') {
333 $ret =
img_picto($langs->trans(
"Product"),
'product',
'class="paddingleftonly paddingrightonly colorgrey"').$ret;
335 $ret =
img_picto($langs->trans(
"Service"),
'service',
'class="paddingleftonly paddingrightonly colorgrey"').$ret;
338 } elseif (preg_match(
'/^ckeditor/', $typeofdata)) {
340 if (!empty($conf->global->MAIN_DISABLE_NOTES_TAB)) {
341 $firstline = preg_replace(
'/<br>.*/',
'', $tmpcontent);
342 $firstline = preg_replace(
'/[\n\r].*/',
'', $firstline);
343 $tmpcontent = $firstline.((strlen($firstline) != strlen($tmpcontent)) ?
'...' :
'');
352 if ($formatfunc && method_exists($object, $formatfunc)) {
353 $ret = $object->$formatfunc($ret);
371 public function widgetForTranslation($fieldname, $object, $perm, $typeofdata =
'string', $check =
'', $morecss =
'')
373 global $conf, $langs, $extralanguages;
378 $arrayoflangcode = array();
379 if (!empty($conf->global->PDF_USE_ALSO_LANGUAGE_CODE)) {
380 $arrayoflangcode[] = $conf->global->PDF_USE_ALSO_LANGUAGE_CODE;
383 if (is_array($arrayoflangcode) && count($arrayoflangcode)) {
384 if (!is_object($extralanguages)) {
385 include_once DOL_DOCUMENT_ROOT.
'/core/class/extralanguages.class.php';
388 $extralanguages->fetch_name_extralanguages(
'societe');
390 if (!is_array($extralanguages->attributes[$object->element]) || empty($extralanguages->attributes[$object->element][$fieldname])) {
394 $result .=
'<!-- Widget for translation -->'.
"\n";
395 $result .=
'<div class="inline-block paddingleft image-'.$object->element.
'-'.$fieldname.
'">';
396 $s =
img_picto($langs->trans(
"ShowOtherLanguages"),
'language',
'',
false, 0, 0,
'',
'fa-15 editfieldlang');
400 $result .=
'<div class="inline-block hidden field-'.$object->element.
'-'.$fieldname.
'">';
402 $resultforextrlang =
'';
403 foreach ($arrayoflangcode as $langcode) {
404 $valuetoshow =
GETPOSTISSET(
'field-'.$object->element.
"-".$fieldname.
"-".$langcode) ?
GETPOST(
'field-'.$object->element.
'-'.$fieldname.
"-".$langcode, $check) :
'';
405 if (empty($valuetoshow)) {
406 $object->fetchValuesForExtraLanguages();
408 $valuetoshow = $object->array_languages[$fieldname][$langcode];
412 $resultforextrlang .= $s;
415 if ($typeofdata ==
'textarea') {
416 $resultforextrlang .=
'<textarea name="field-'.$object->element.
"-".$fieldname.
"-".$langcode.
'" id="'.$fieldname.
"-".$langcode.
'" class="'.$morecss.
'" rows="'.ROWS_2.
'" wrap="soft">';
417 $resultforextrlang .= $valuetoshow;
418 $resultforextrlang .=
'</textarea>';
420 $resultforextrlang .=
'<input type="text" class="inputfieldforlang '.($morecss ?
' '.$morecss :
'').
'" name="field-'.$object->element.
'-'.$fieldname.
'-'.$langcode.
'" value="'.$valuetoshow.
'">';
423 $result .= $resultforextrlang;
426 $result .=
'<script>$(".image-'.$object->element.
'-'.$fieldname.
'").click(function() { console.log("Toggle lang widget"); jQuery(".field-'.$object->element.
'-'.$fieldname.
'").toggle(); });</script>';
445 protected function editInPlace($object, $value, $htmlname, $condition, $inputType =
'textarea', $editvalue =
null, $extObject =
null, $custommsg =
null)
452 if (preg_match(
'/^text/', $inputType)) {
454 } elseif (preg_match(
'/^numeric/', $inputType)) {
455 $value =
price($value);
456 } elseif ($inputType ==
'day' || $inputType ==
'datepicker') {
462 $table_element =
false;
466 $ext_element =
false;
467 $button_only =
false;
472 if (is_object($object)) {
473 $element = $object->element;
474 $table_element = $object->table_element;
475 $fk_element = $object->id;
478 if (is_object($extObject)) {
479 $ext_element = $extObject->element;
482 if (preg_match(
'/^(string|email|numeric)/', $inputType)) {
483 $tmp = explode(
':', $inputType);
484 $inputType = $tmp[0];
485 if (!empty($tmp[1])) {
486 $inputOption = $tmp[1];
488 if (!empty($tmp[2])) {
489 $savemethod = $tmp[2];
491 $out .=
'<input id="width_'.$htmlname.
'" value="'.$inputOption.
'" type="hidden"/>'.
"\n";
492 } elseif ((preg_match(
'/^day$/', $inputType)) || (preg_match(
'/^datepicker/', $inputType)) || (preg_match(
'/^datehourpicker/', $inputType))) {
493 $tmp = explode(
':', $inputType);
494 $inputType = $tmp[0];
495 if (!empty($tmp[1])) {
496 $inputOption = $tmp[1];
498 if (!empty($tmp[2])) {
499 $savemethod = $tmp[2];
502 $out .=
'<input id="timestamp" type="hidden"/>'.
"\n";
503 } elseif (preg_match(
'/^(select|autocomplete)/', $inputType)) {
504 $tmp = explode(
':', $inputType);
505 $inputType = $tmp[0];
506 $loadmethod = $tmp[1];
507 if (!empty($tmp[2])) {
508 $savemethod = $tmp[2];
510 if (!empty($tmp[3])) {
513 } elseif (preg_match(
'/^textarea/', $inputType)) {
514 $tmp = explode(
':', $inputType);
515 $inputType = $tmp[0];
516 $rows = (empty($tmp[1]) ?
'8' : $tmp[1]);
517 $cols = (empty($tmp[2]) ?
'80' : $tmp[2]);
518 } elseif (preg_match(
'/^ckeditor/', $inputType)) {
519 $tmp = explode(
':', $inputType);
520 $inputType = $tmp[0];
522 if (!empty($tmp[2])) {
525 if (!empty($tmp[3])) {
528 if (!empty($tmp[4])) {
529 $savemethod = $tmp[4];
532 if (!empty($conf->fckeditor->enabled)) {
533 $out .=
'<input id="ckeditor_toolbar" value="'.$toolbar.
'" type="hidden"/>'.
"\n";
535 $inputType =
'textarea';
539 $out .=
'<input id="element_'.$htmlname.
'" value="'.$element.
'" type="hidden"/>'.
"\n";
540 $out .=
'<input id="table_element_'.$htmlname.
'" value="'.$table_element.
'" type="hidden"/>'.
"\n";
541 $out .=
'<input id="fk_element_'.$htmlname.
'" value="'.$fk_element.
'" type="hidden"/>'.
"\n";
542 $out .=
'<input id="loadmethod_'.$htmlname.
'" value="'.$loadmethod.
'" type="hidden"/>'.
"\n";
543 if (!empty($savemethod)) {
544 $out .=
'<input id="savemethod_'.$htmlname.
'" value="'.$savemethod.
'" type="hidden"/>'.
"\n";
546 if (!empty($ext_element)) {
547 $out .=
'<input id="ext_element_'.$htmlname.
'" value="'.$ext_element.
'" type="hidden"/>'.
"\n";
549 if (!empty($custommsg)) {
550 if (is_array($custommsg)) {
551 if (!empty($custommsg[
'success'])) {
552 $out .=
'<input id="successmsg_'.$htmlname.
'" value="'.$custommsg[
'success'].
'" type="hidden"/>'.
"\n";
554 if (!empty($custommsg[
'error'])) {
555 $out .=
'<input id="errormsg_'.$htmlname.
'" value="'.$custommsg[
'error'].
'" type="hidden"/>'.
"\n";
558 $out .=
'<input id="successmsg_'.$htmlname.
'" value="'.$custommsg.
'" type="hidden"/>'.
"\n";
561 if ($inputType ==
'textarea') {
562 $out .=
'<input id="textarea_'.$htmlname.
'_rows" value="'.$rows.
'" type="hidden"/>'.
"\n";
563 $out .=
'<input id="textarea_'.$htmlname.
'_cols" value="'.$cols.
'" type="hidden"/>'.
"\n";
565 $out .=
'<span id="viewval_'.$htmlname.
'" class="viewval_'.$inputType.($button_only ?
' inactive' :
' active').
'">'.$value.
'</span>'.
"\n";
566 $out .=
'<span id="editval_'.$htmlname.
'" class="editval_'.$inputType.($button_only ?
' inactive' :
' active').
' hideobject">'.(!empty($editvalue) ? $editvalue : $value).
'</span>'.
"\n";
592 public function textwithtooltip($text, $htmltext, $tooltipon = 1, $direction = 0, $img =
'', $extracss =
'', $notabs = 3, $incbefore =
'', $noencodehtmltext = 0, $tooltiptrigger =
'', $forcenowrap = 0)
595 $text = $incbefore.$text;
600 $direction = (int) $direction;
610 $htmltext = str_replace(array(
"\r",
"\n"),
'', $htmltext);
613 if ($direction < 0) {
614 $extracss = ($extracss ? $extracss.
' ' :
'').($notabs != 3 ?
'inline-block' :
'');
615 $extrastyle =
'padding: 0px; padding-left: 3px !important;';
617 if ($direction > 0) {
618 $extracss = ($extracss ? $extracss.
' ' :
'').($notabs != 3 ?
'inline-block' :
'');
619 $extrastyle =
'padding: 0px; padding-right: 3px !important;';
622 $classfortooltip =
'classfortooltip';
627 if ($tooltiptrigger ==
'') {
628 $htmltext = str_replace(
'"',
'"', $htmltext);
630 $classfortooltip =
'classfortooltiponclick';
631 $textfordialog .=
'<div style="display: none;" id="idfortooltiponclick_'.$tooltiptrigger.
'" class="classfortooltiponclicktext">'.$htmltext.
'</div>';
633 if ($tooltipon == 2 || $tooltipon == 3) {
634 $paramfortooltipimg =
' class="'.$classfortooltip.($notabs != 3 ?
' inline-block' :
'').($extracss ?
' '.$extracss :
'').
'" style="padding: 0px;'.($extrastyle ?
' '.$extrastyle :
'').
'"';
635 if ($tooltiptrigger ==
'') {
636 $paramfortooltipimg .=
' title="'.($noencodehtmltext ? $htmltext :
dol_escape_htmltag($htmltext, 1)).
'"';
638 $paramfortooltipimg .=
' dolid="'.$tooltiptrigger.
'"';
641 $paramfortooltipimg = ($extracss ?
' class="'.$extracss.
'"' :
'').($extrastyle ?
' style="'.$extrastyle.
'"' :
'');
643 if ($tooltipon == 1 || $tooltipon == 3) {
644 $paramfortooltiptd =
' class="'.($tooltipon == 3 ?
'cursorpointer ' :
'').$classfortooltip.
' inline-block'.($extracss ?
' '.$extracss :
'').
'" style="padding: 0px;'.($extrastyle ?
' '.$extrastyle :
'').
'" ';
645 if ($tooltiptrigger ==
'') {
646 $paramfortooltiptd .=
' title="'.($noencodehtmltext ? $htmltext :
dol_escape_htmltag($htmltext, 1)).
'"';
648 $paramfortooltiptd .=
' dolid="'.$tooltiptrigger.
'"';
651 $paramfortooltiptd = ($extracss ?
' class="'.$extracss.
'"' :
'').($extrastyle ?
' style="'.$extrastyle.
'"' :
'');
653 if (empty($notabs)) {
654 $s .=
'<table class="nobordernopadding"><tr style="height: auto;">';
655 } elseif ($notabs == 2) {
656 $s .=
'<div class="inline-block'.($forcenowrap ?
' nowrap' :
'').
'">';
659 if ($direction < 0) {
660 $s .=
'<'.$tag.$paramfortooltipimg;
662 $s .=
' class=valigntop" width="14"';
664 $s .=
'>'.$textfordialog.$img.
'</'.$tag.
'>';
668 if ((
string) $text !=
'') {
669 $s .=
'<'.$tag.$paramfortooltiptd.
'>'.$text.
'</'.$tag.
'>';
672 if ($direction > 0) {
673 $s .=
'<'.$tag.$paramfortooltipimg;
675 $s .=
' class="valignmiddle" width="14"';
677 $s .=
'>'.$textfordialog.$img.
'</'.$tag.
'>';
679 if (empty($notabs)) {
680 $s .=
'</tr></table>';
681 } elseif ($notabs == 2) {
702 public function textwithpicto($text, $htmltext, $direction = 1, $type =
'help', $extracss =
'', $noencodehtmltext = 0, $notabs = 3, $tooltiptrigger =
'', $forcenowrap = 0)
704 global $conf, $langs;
707 if ($tooltiptrigger) {
708 $alt = $langs->transnoentitiesnoconv(
"ClickToShowHelp");
714 } elseif ($type ==
'1') {
719 if (empty($conf->use_javascript_ajax)) {
720 if ($type ==
'info' || $type ==
'infoclickable' || $type ==
'help' || $type ==
'helpclickable') {
729 if (!empty($conf->dol_no_mouse_hover) && empty($tooltiptrigger)) {
730 if ($type ==
'info' || $type ==
'infoclickable' || $type ==
'help' || $type ==
'helpclickable') {
741 if ($type ==
'info') {
743 } elseif ($type ==
'help') {
744 $img =
img_help(($tooltiptrigger !=
'' ? 2 : 1), $alt);
745 } elseif ($type ==
'helpclickable') {
746 $img =
img_help(($tooltiptrigger !=
'' ? 2 : 1), $alt);
747 } elseif ($type ==
'superadmin') {
749 } elseif ($type ==
'admin') {
751 } elseif ($type ==
'warning') {
753 } elseif ($type !=
'none') {
757 return $this->
textwithtooltip($text, $htmltext, ((($tooltiptrigger && !$img) || strpos($type,
'clickable')) ? 3 : 2), $direction, $img, $extracss, $notabs,
'', $noencodehtmltext, $tooltiptrigger, $forcenowrap);
770 public function selectMassAction($selected, $arrayofaction, $alwaysvisible = 0, $name =
'massaction', $cssclass =
'checkforselect')
772 global $conf, $langs, $hookmanager;
776 $ret =
'<div class="centpercent center">';
777 $ret .=
'<select class="flat'.(empty($conf->use_javascript_ajax) ?
'' :
' hideobject').
' '.$name.
' '.$name.
'select valignmiddle alignstart" id="'.$name.
'" name="'.$name.
'"'.($disabled ?
' disabled="disabled"' :
'').
'>';
780 $parameters = array();
781 $reshook = $hookmanager->executeHooks(
'addMoreMassActions', $parameters);
783 if (count($arrayofaction) == 0 && empty($hookmanager->resPrint)) {
786 if (empty($reshook)) {
787 $ret .=
'<option value="0"'.($disabled ?
' disabled="disabled"' :
'').
'>-- '.$langs->trans(
"SelectAction").
' --</option>';
788 foreach ($arrayofaction as $code => $label) {
789 $ret .=
'<option value="'.$code.
'"'.($disabled ?
' disabled="disabled"' :
'').
' data-html="'.
dol_escape_htmltag($label).
'">'.$label.
'</option>';
792 $ret .= $hookmanager->resPrint;
796 if (empty($conf->dol_optimize_smallscreen)) {
801 $ret .=
'<input type="submit" name="confirmmassactioninvisible" style="display: none" tabindex="-1">';
802 $ret .=
'<input type="submit" disabled name="confirmmassaction"'.(empty($conf->use_javascript_ajax) ?
'' :
' style="display: none"').
' class="button smallpaddingimp'.(empty($conf->use_javascript_ajax) ?
'' :
' hideobject').
' '.$name.
' '.$name.
'confirmed" value="'.
dol_escape_htmltag($langs->trans(
"Confirm")).
'">';
805 if (!empty($conf->use_javascript_ajax)) {
806 $ret .=
'<!-- JS CODE TO ENABLE mass action select -->
808 function initCheckForSelect(mode, name, cssclass) /* mode is 0 during init of page or click all, 1 when we click on 1 checkboxi, "name" refers to the class of the massaction button, "cssclass" to the class of the checkfor select boxes */
810 atleastoneselected=0;
811 jQuery("."+cssclass).each(function( index ) {
812 /* console.log( index + ": " + $( this ).text() ); */
813 if ($(this).is(\':checked\')) atleastoneselected++;
816 console.log("initCheckForSelect mode="+mode+" name="+name+" cssclass="+cssclass+" atleastoneselected="+atleastoneselected);
818 if (atleastoneselected || '.$alwaysvisible.
')
820 jQuery("."+name).show();
821 '.($selected ?
'if (atleastoneselected) { jQuery("."+name+"select").val("'.$selected.
'").trigger(\'change\'); jQuery("."+name+"confirmed").prop(\'disabled\', false); }' :
'').
'
822 '.($selected ?
'if (! atleastoneselected) { jQuery("."+name+"select").val("0").trigger(\'change\'); jQuery("."+name+"confirmed").prop(\'disabled\', true); } ' :
'').
'
826 jQuery("."+name).hide();
827 jQuery("."+name+"other").hide();
831 jQuery(document).ready(function () {
832 initCheckForSelect(0, "' . $name.
'", "'.$cssclass.
'");
833 jQuery(".' . $cssclass.
'").click(function() {
834 initCheckForSelect(1, "'.$name.
'", "'.$cssclass.
'");
836 jQuery(".' . $name.
'select").change(function() {
837 var massaction = $( this ).val();
838 var urlform = $( this ).closest("form").attr("action").replace("#show_files","");
839 if (massaction == "builddoc")
841 urlform = urlform + "#show_files";
843 $( this ).closest("form").attr("action", urlform);
844 console.log("we select a mass action name='.$name.
' massaction="+massaction+" - "+urlform);
845 /* Warning: if you set submit button to disabled, post using Enter will no more work if there is no other button */
846 if ($(this).val() != \'0\')
848 jQuery(".' . $name.
'confirmed").prop(\'disabled\', false);
849 jQuery(".' . $name.
'other").hide(); /* To disable if another div was open */
850 jQuery(".' . $name.
'"+massaction).show();
854 jQuery(".' . $name.
'confirmed").prop(\'disabled\', true);
855 jQuery(".' . $name.
'other").hide(); /* To disable any div open */
883 public function select_country($selected =
'', $htmlname =
'country_id', $htmloption =
'', $maxlength = 0, $morecss =
'minwidth300', $usecodeaskey =
'', $showempty = 1, $disablefavorites = 0, $addspecialentries = 0, $exclude_country_code = array(), $hideflags = 0)
886 global $conf, $langs, $mysoc;
888 $langs->load(
"dict");
891 $countryArray = array();
894 $atleastonefavorite = 0;
896 $sql =
"SELECT rowid, code as code_iso, code_iso as code_iso3, label, favorite, eec";
897 $sql .=
" FROM ".$this->db->prefix().
"c_country";
898 $sql .=
" WHERE active > 0";
901 dol_syslog(get_class($this).
"::select_country", LOG_DEBUG);
904 $out .=
'<select id="select'.$htmlname.
'" class="flat maxwidth200onsmartphone selectcountry'.($morecss ?
' '.$morecss :
'').
'" name="'.$htmlname.
'" '.$htmloption.
'>';
905 $num = $this->db->num_rows(
$resql);
909 $obj = $this->
db->fetch_object(
$resql);
911 $countryArray[$i][
'rowid'] = $obj->rowid;
912 $countryArray[$i][
'code_iso'] = $obj->code_iso;
913 $countryArray[$i][
'code_iso3'] = $obj->code_iso3;
914 $countryArray[$i][
'label'] = ($obj->code_iso && $langs->transnoentitiesnoconv(
"Country".$obj->code_iso) !=
"Country".$obj->code_iso ? $langs->transnoentitiesnoconv(
"Country".$obj->code_iso) : ($obj->label !=
'-' ? $obj->label :
''));
915 $countryArray[$i][
'favorite'] = $obj->favorite;
916 $countryArray[$i][
'eec'] = $obj->eec;
917 $favorite[$i] = $obj->favorite;
922 if (empty($disablefavorites)) {
923 $array1_sort_order = SORT_DESC;
924 $array2_sort_order = SORT_ASC;
925 array_multisort($favorite, $array1_sort_order, $label, $array2_sort_order, $countryArray);
931 if (is_numeric($showempty)) {
932 $out .=
'<option value=""> </option>'.
"\n";
934 $out .=
'<option value="">'.$langs->trans($showempty).
'</option>'.
"\n";
938 if ($addspecialentries) {
940 $out .=
'<option value="special_allnotme"'.($selected ==
'special_allnotme' ?
' selected' :
'').
'>'.$langs->trans(
"CountriesExceptMe", $langs->transnoentitiesnoconv(
"Country".$mysoc->country_code)).
'</option>';
941 $out .=
'<option value="special_eec"'.($selected ==
'special_eec' ?
' selected' :
'').
'>'.$langs->trans(
"CountriesInEEC").
'</option>';
942 if ($mysoc->isInEEC()) {
943 $out .=
'<option value="special_eecnotme"'.($selected ==
'special_eecnotme' ?
' selected' :
'').
'>'.$langs->trans(
"CountriesInEECExceptMe", $langs->transnoentitiesnoconv(
"Country".$mysoc->country_code)).
'</option>';
945 $out .=
'<option value="special_noteec"'.($selected ==
'special_noteec' ?
' selected' :
'').
'>'.$langs->trans(
"CountriesNotInEEC").
'</option>';
946 $out .=
'<option value="" disabled class="selectoptiondisabledwhite">------------</option>';
949 foreach ($countryArray as $row) {
951 if (empty($row[
'rowid'])) {
954 if (is_array($exclude_country_code) && count($exclude_country_code) && in_array($row[
'code_iso'], $exclude_country_code)) {
958 if (empty($disablefavorites) && $row[
'favorite'] && $row[
'code_iso']) {
959 $atleastonefavorite++;
961 if (empty($row[
'favorite']) && $atleastonefavorite) {
962 $atleastonefavorite = 0;
963 $out .=
'<option value="" disabled class="selectoptiondisabledwhite">------------</option>';
968 $labeltoshow .=
dol_trunc($row[
'label'], $maxlength,
'middle');
970 $labeltoshow .=
' ';
972 if ($row[
'code_iso']) {
973 $labeltoshow .=
' <span class="opacitymedium">('.$row[
'code_iso'].
')</span>';
974 if (empty($hideflags)) {
975 $tmpflag =
picto_from_langcode($row[
'code_iso'],
'class="saturatemedium paddingrightonly"', 1);
976 $labeltoshow = $tmpflag.
' '.$labeltoshow;
980 if ($selected && $selected !=
'-1' && ($selected == $row[
'rowid'] || $selected == $row[
'code_iso'] || $selected == $row[
'code_iso3'] || $selected == $row[
'label'])) {
981 $out .=
'<option value="'.($usecodeaskey ? ($usecodeaskey ==
'code2' ? $row[
'code_iso'] : $row[
'code_iso3']) : $row[
'rowid']).
'" selected data-html="'.
dol_escape_htmltag($labeltoshow).
'" data-eec="'.((int) $row[
'eec']).
'">';
983 $out .=
'<option value="'.($usecodeaskey ? ($usecodeaskey ==
'code2' ? $row[
'code_iso'] : $row[
'code_iso3']) : $row[
'rowid']).
'" data-html="'.
dol_escape_htmltag($labeltoshow).
'" data-eec="'.((int) $row[
'eec']).
'">';
985 $out .= $labeltoshow;
986 $out .=
'</option>'.
"\n";
995 include_once DOL_DOCUMENT_ROOT.
'/core/lib/ajax.lib.php';
996 $out .=
ajax_combobox(
'select'.$htmlname, array(), 0, 0,
'resolve');
1015 public function select_incoterms($selected =
'', $location_incoterms =
'', $page =
'', $htmlname =
'incoterm_id', $htmloption =
'', $forcecombo = 1, $events = array(), $disableautocomplete = 0)
1018 global $conf, $langs;
1020 $langs->load(
"dict");
1024 $incotermArray = array();
1026 $sql =
"SELECT rowid, code";
1027 $sql .=
" FROM ".$this->db->prefix().
"c_incoterms";
1028 $sql .=
" WHERE active > 0";
1029 $sql .=
" ORDER BY code ASC";
1031 dol_syslog(get_class($this).
"::select_incoterm", LOG_DEBUG);
1034 if ($conf->use_javascript_ajax && !$forcecombo) {
1035 include_once DOL_DOCUMENT_ROOT.
'/core/lib/ajax.lib.php';
1039 if (!empty($page)) {
1040 $out .=
'<form method="post" action="'.$page.
'">';
1041 $out .=
'<input type="hidden" name="action" value="set_incoterms">';
1042 $out .=
'<input type="hidden" name="token" value="'.newToken().
'">';
1045 $out .=
'<select id="'.$htmlname.
'" class="flat selectincoterm width75" name="'.$htmlname.
'" '.$htmloption.
'>';
1046 $out .=
'<option value="0"> </option>';
1047 $num = $this->
db->num_rows(
$resql);
1051 $obj = $this->
db->fetch_object(
$resql);
1052 $incotermArray[$i][
'rowid'] = $obj->rowid;
1053 $incotermArray[$i][
'code'] = $obj->code;
1057 foreach ($incotermArray as $row) {
1058 if ($selected && ($selected == $row[
'rowid'] || $selected == $row[
'code'])) {
1059 $out .=
'<option value="'.$row[
'rowid'].
'" selected>';
1061 $out .=
'<option value="'.$row[
'rowid'].
'">';
1065 $out .= $row[
'code'];
1068 $out .=
'</option>';
1071 $out .=
'</select>';
1073 if ($conf->use_javascript_ajax && empty($disableautocomplete)) {
1074 $out .=
ajax_multiautocompleter(
'location_incoterms',
'', DOL_URL_ROOT.
'/core/ajax/locationincoterms.php').
"\n";
1075 $moreattrib .=
' autocomplete="off"';
1077 $out .=
'<input id="location_incoterms" class="maxwidthonsmartphone type="text" name="location_incoterms" value="'.$location_incoterms.
'">'.
"\n";
1079 if (!empty($page)) {
1080 $out .=
'<input type="submit" class="button valignmiddle smallpaddingimp nomargintop nomarginbottom" value="'.$langs->trans(
"Modify").
'"></form>';
1101 public function select_type_of_lines($selected =
'', $htmlname =
'type', $showempty = 0, $hidetext = 0, $forceall = 0)
1104 global $langs, $conf;
1107 if ($forceall == 1 || (empty($forceall) && !empty($conf->product->enabled) && !empty($conf->service->enabled))
1108 || (empty($forceall) && empty($conf->product->enabled) && empty($conf->service->enabled))) {
1109 if (empty($hidetext)) {
1110 print $langs->trans(
"Type").
': ';
1112 print
'<select class="flat" id="select_'.$htmlname.
'" name="'.$htmlname.
'">';
1114 print
'<option value="-1"';
1115 if ($selected == -1) {
1118 print
'> </option>';
1121 print
'<option value="0"';
1122 if (0 == $selected || ($selected == -1 &&
getDolGlobalString(
'MAIN_FREE_PRODUCT_CHECKED_BY_DEFAULT') ==
'product')) {
1125 print
'>'.$langs->trans(
"Product");
1127 print
'<option value="1"';
1128 if (1 == $selected || ($selected == -1 &&
getDolGlobalString(
'MAIN_FREE_PRODUCT_CHECKED_BY_DEFAULT') ==
'service')) {
1131 print
'>'.$langs->trans(
"Service");
1137 if ((empty($forceall) && empty($conf->product->enabled) && !empty($conf->service->enabled)) || $forceall == 3) {
1138 print $langs->trans(
"Service");
1139 print
'<input type="hidden" name="'.$htmlname.
'" value="1">';
1141 if ((empty($forceall) && !empty($conf->product->enabled) && empty($conf->service->enabled)) || $forceall == 2) {
1142 print $langs->trans(
"Product");
1143 print
'<input type="hidden" name="'.$htmlname.
'" value="0">';
1145 if ($forceall < 0) {
1146 print
'<input type="hidden" name="'.$htmlname.
'" value="1">';
1161 $num = count($this->cache_types_fees);
1168 $langs->load(
"trips");
1170 $sql =
"SELECT c.code, c.label";
1171 $sql .=
" FROM ".$this->db->prefix().
"c_type_fees as c";
1172 $sql .=
" WHERE active > 0";
1176 $num = $this->
db->num_rows(
$resql);
1180 $obj = $this->
db->fetch_object(
$resql);
1183 $label = ($obj->code != $langs->trans($obj->code) ? $langs->trans($obj->code) : $langs->trans($obj->label));
1184 $this->cache_types_fees[$obj->code] = $label;
1188 asort($this->cache_types_fees);
1209 global $user, $langs;
1211 dol_syslog(__METHOD__.
" selected=".$selected.
", htmlname=".$htmlname, LOG_DEBUG);
1215 print
'<select id="select_'.$htmlname.
'" class="flat" name="'.$htmlname.
'">';
1217 print
'<option value="-1"';
1218 if ($selected == -1) {
1221 print
'> </option>';
1224 foreach ($this->cache_types_fees as $key => $value) {
1225 print
'<option value="'.$key.
'"';
1226 if ($key == $selected) {
1236 print
info_admin($langs->trans(
"YouCanChangeValuesForThisListFromDictionarySetup"), 1);
1263 public function select_company($selected =
'', $htmlname =
'socid', $filter =
'', $showempty =
'', $showtype = 0, $forcecombo = 0, $events = array(), $limit = 0, $morecss =
'minwidth100', $moreparam =
'', $selected_input_value =
'', $hidelabel = 1, $ajaxoptions = array(), $multiple =
false, $excludeids = array(), $showcode = 0)
1266 global $conf, $user, $langs;
1270 if (!empty($conf->use_javascript_ajax) && !empty($conf->global->COMPANY_USE_SEARCH_TO_SELECT) && !$forcecombo) {
1271 if (is_null($ajaxoptions)) {
1272 $ajaxoptions = array();
1275 require_once DOL_DOCUMENT_ROOT .
'/core/lib/ajax.lib.php';
1279 if ($selected && empty($selected_input_value)) {
1280 require_once DOL_DOCUMENT_ROOT.
'/societe/class/societe.class.php';
1282 $societetmp->fetch($selected);
1283 $selected_input_value = $societetmp->name;
1288 $urloption =
'htmlname='.urlencode(str_replace(
'.',
'_', $htmlname)).
'&outjson=1&filter='.urlencode($filter).(empty($excludeids) ?
'' :
'&excludeids='.join(
',', $excludeids)).($showtype ?
'&showtype='.urlencode($showtype) :
'').($showcode ?
'&showcode='.urlencode($showcode) :
'');
1290 $out .=
'<style type="text/css">.ui-autocomplete { z-index: 1003; }</style>';
1291 if (empty($hidelabel)) {
1292 print $langs->trans(
"RefOrLabel").
' : ';
1293 } elseif ($hidelabel > 1) {
1294 $placeholder = $langs->trans(
"RefOrLabel");
1295 if ($hidelabel == 2) {
1296 $out .=
img_picto($langs->trans(
"Search"),
'search');
1299 $out .=
'<input type="text" class="'.$morecss.
'" name="search_'.$htmlname.
'" id="search_'.$htmlname.
'" value="'.$selected_input_value.
'"'.($placeholder ?
' placeholder="'.dol_escape_htmltag($placeholder).
'"' :
'').
' '.(!empty($conf->global->THIRDPARTY_SEARCH_AUTOFOCUS) ?
'autofocus' :
'').
' />';
1300 if ($hidelabel == 3) {
1301 $out .=
img_picto($langs->trans(
"Search"),
'search');
1304 $out .=
ajax_autocompleter($selected, $htmlname, DOL_URL_ROOT.
'/societe/ajax/company.php', $urloption, $conf->global->COMPANY_USE_SEARCH_TO_SELECT, 0, $ajaxoptions);
1307 $out .= $this->
select_thirdparty_list($selected, $htmlname, $filter, $showempty, $showtype, $forcecombo, $events,
'', 0, $limit, $morecss, $moreparam, $multiple, $excludeids, $showcode);
1335 public function select_thirdparty_list($selected =
'', $htmlname =
'socid', $filter =
'', $showempty =
'', $showtype = 0, $forcecombo = 0, $events = array(), $filterkey =
'', $outputmode = 0, $limit = 0, $morecss =
'minwidth100', $moreparam =
'', $multiple =
false, $excludeids = array(), $showcode = 0)
1338 global $conf, $user, $langs;
1339 global $hookmanager;
1343 $outarray = array();
1345 if ($selected ===
'') {
1346 $selected = array();
1347 } elseif (!is_array($selected)) {
1348 $selected = array($selected);
1352 if (function_exists(
'testSqlAndScriptInject')) {
1359 $sql =
"SELECT s.rowid, s.nom as name, s.name_alias, s.tva_intra, s.client, s.fournisseur, s.code_client, s.code_fournisseur";
1360 if (!empty($conf->global->COMPANY_SHOW_ADDRESS_SELECTLIST)) {
1361 $sql .=
", s.address, s.zip, s.town";
1362 $sql .=
", dictp.code as country_code";
1364 $sql .=
" FROM ".$this->db->prefix().
"societe as s";
1365 if (!empty($conf->global->COMPANY_SHOW_ADDRESS_SELECTLIST)) {
1366 $sql .=
" LEFT JOIN ".$this->db->prefix().
"c_country as dictp ON dictp.rowid = s.fk_pays";
1368 if (empty($user->rights->societe->client->voir) && !$user->socid) {
1369 $sql .=
", ".$this->db->prefix().
"societe_commerciaux as sc";
1371 $sql .=
" WHERE s.entity IN (".getEntity(
'societe').
")";
1372 if (!empty($user->socid)) {
1373 $sql .=
" AND s.rowid = ".((int) $user->socid);
1376 $sql .=
" AND (".$filter.
")";
1378 if (empty($user->rights->societe->client->voir) && !$user->socid) {
1379 $sql .=
" AND s.rowid = sc.fk_soc AND sc.fk_user = ".((int) $user->id);
1381 if (!empty($conf->global->COMPANY_HIDE_INACTIVE_IN_COMBOBOX)) {
1382 $sql .=
" AND s.status <> 0";
1384 if (!empty($excludeids)) {
1385 $sql .=
" AND s.rowid NOT IN (".$this->db->sanitize(join(
',', $excludeids)).
")";
1388 $parameters = array();
1389 $reshook = $hookmanager->executeHooks(
'selectThirdpartyListWhere', $parameters);
1390 $sql .= $hookmanager->resPrint;
1392 if ($filterkey && $filterkey !=
'') {
1394 $prefix = empty($conf->global->COMPANY_DONOTSEARCH_ANYWHERE) ?
'%' :
'';
1396 $scrit = explode(
' ', $filterkey);
1398 if (count($scrit) > 1) {
1401 foreach ($scrit as $crit) {
1405 $sql .=
"(s.nom LIKE '".$this->db->escape($prefix.$crit).
"%')";
1408 if (count($scrit) > 1) {
1411 if (!empty($conf->barcode->enabled)) {
1412 $sql .=
" OR s.barcode LIKE '".$this->db->escape($prefix.$filterkey).
"%'";
1414 $sql .=
" OR s.code_client LIKE '".$this->db->escape($prefix.$filterkey).
"%' OR s.code_fournisseur LIKE '".$this->
db->escape($prefix.$filterkey).
"%'";
1415 $sql .=
" OR s.name_alias LIKE '".$this->db->escape($prefix.$filterkey).
"%' OR s.tva_intra LIKE '".$this->
db->escape($prefix.$filterkey).
"%'";
1418 $sql .= $this->
db->order(
"nom",
"ASC");
1419 $sql .= $this->
db->plimit($limit, 0);
1422 dol_syslog(get_class($this).
"::select_thirdparty_list", LOG_DEBUG);
1426 include_once DOL_DOCUMENT_ROOT.
'/core/lib/ajax.lib.php';
1431 $out .=
'<select id="'.$htmlname.
'" class="flat'.($morecss ?
' '.$morecss :
'').
'"'.($moreparam ?
' '.$moreparam :
'').
' name="'.$htmlname.($multiple ?
'[]' :
'').
'" '.($multiple ?
'multiple' :
'').
'>'.
"\n";
1433 $textifempty = (($showempty && !is_numeric($showempty)) ? $langs->trans($showempty) :
'');
1434 if (!empty($conf->global->COMPANY_USE_SEARCH_TO_SELECT)) {
1437 if ($showempty && !is_numeric($showempty)) {
1438 $textifempty = $langs->trans($showempty);
1440 $textifempty .= $langs->trans(
"All");
1444 $out .=
'<option value="-1" data-html="'.dol_escape_htmltag(
'<span class="opacitymedium">'.($textifempty ? $textifempty :
' ').
'</span>').
'">'.$textifempty.
'</option>'.
"\n";
1449 $num = $this->
db->num_rows(
$resql);
1453 $obj = $this->
db->fetch_object(
$resql);
1455 if ($showcode || !empty($conf->global->SOCIETE_ADD_REF_IN_LIST)) {
1456 if (($obj->client) && (!empty($obj->code_client))) {
1457 $label = $obj->code_client.
' - ';
1459 if (($obj->fournisseur) && (!empty($obj->code_fournisseur))) {
1460 $label .= $obj->code_fournisseur.
' - ';
1462 $label .=
' '.$obj->name;
1464 $label = $obj->name;
1467 if (!empty($obj->name_alias)) {
1468 $label .=
' ('.$obj->name_alias.
')';
1471 if (!empty($conf->global->SOCIETE_SHOW_VAT_IN_LIST) && !empty($obj->tva_intra)) {
1472 $label .=
' - '.$obj->tva_intra.
'';
1475 $labelhtml = $label;
1478 $companytemp->id = $obj->rowid;
1479 $companytemp->client = $obj->client;
1480 $companytemp->fournisseur = $obj->fournisseur;
1481 $tmptype = $companytemp->getTypeUrl(1,
'', 0,
'span');
1483 $labelhtml .=
' '.$tmptype;
1486 if ($obj->client || $obj->fournisseur) {
1489 if ($obj->client == 1 || $obj->client == 3) {
1490 $label .= $langs->trans(
"Customer");
1492 if ($obj->client == 2 || $obj->client == 3) {
1493 $label .= ($obj->client == 3 ?
', ' :
'').$langs->trans(
"Prospect");
1495 if ($obj->fournisseur) {
1496 $label .= ($obj->client ?
', ' :
'').$langs->trans(
"Supplier");
1498 if ($obj->client || $obj->fournisseur) {
1503 if (!empty($conf->global->COMPANY_SHOW_ADDRESS_SELECTLIST)) {
1504 $s = ($obj->address ?
' - '.$obj->address :
'').($obj->zip ?
' - '.$obj->zip :
'').($obj->town ?
' '.$obj->town :
'');
1505 if (!empty($obj->country_code)) {
1506 $s .=
', '.$langs->trans(
'Country'.$obj->country_code);
1512 if (empty($outputmode)) {
1513 if (in_array($obj->rowid, $selected)) {
1514 $out .=
'<option value="'.$obj->rowid.
'" selected data-html="'.
dol_escape_htmltag($labelhtml).
'">'.$label.
'</option>';
1516 $out .=
'<option value="'.$obj->rowid.
'" data-html="'.
dol_escape_htmltag($labelhtml).
'">'.$label.
'</option>';
1519 array_push($outarray, array(
'key'=>$obj->rowid,
'value'=>$label,
'label'=>$label,
'labelhtml'=>$labelhtml));
1523 if (($i % 10) == 0) {
1528 $out .=
'</select>'.
"\n";
1533 $this->result = array(
'nbofthirdparties'=>$num);
1556 global $langs, $conf;
1559 $sql =
"SELECT re.rowid, re.amount_ht, re.amount_tva, re.amount_ttc,";
1560 $sql .=
" re.description, re.fk_facture_source";
1561 $sql .=
" FROM ".$this->db->prefix().
"societe_remise_except as re";
1562 $sql .=
" WHERE re.fk_soc = ".(int) $socid;
1563 $sql .=
" AND re.entity = ".$conf->entity;
1565 $sql .=
" AND ".$filter;
1567 $sql .=
" ORDER BY re.description ASC";
1569 dol_syslog(get_class($this).
"::select_remises", LOG_DEBUG);
1572 print
'<select id="select_'.$htmlname.
'" class="flat maxwidthonsmartphone" name="'.$htmlname.
'">';
1573 $num = $this->
db->num_rows(
$resql);
1575 $qualifiedlines = $num;
1579 print
'<option value="0"> </option>';
1581 $obj = $this->
db->fetch_object(
$resql);
1582 $desc =
dol_trunc($obj->description, 40);
1583 if (preg_match(
'/\(CREDIT_NOTE\)/', $desc)) {
1584 $desc = preg_replace(
'/\(CREDIT_NOTE\)/', $langs->trans(
"CreditNote"), $desc);
1586 if (preg_match(
'/\(DEPOSIT\)/', $desc)) {
1587 $desc = preg_replace(
'/\(DEPOSIT\)/', $langs->trans(
"Deposit"), $desc);
1589 if (preg_match(
'/\(EXCESS RECEIVED\)/', $desc)) {
1590 $desc = preg_replace(
'/\(EXCESS RECEIVED\)/', $langs->trans(
"ExcessReceived"), $desc);
1592 if (preg_match(
'/\(EXCESS PAID\)/', $desc)) {
1593 $desc = preg_replace(
'/\(EXCESS PAID\)/', $langs->trans(
"ExcessPaid"), $desc);
1597 if ($selected > 0 && $selected == $obj->rowid) {
1598 $selectstring =
' selected';
1602 if ($maxvalue > 0 && $obj->amount_ttc > $maxvalue) {
1604 $disabled =
' disabled';
1607 if (!empty($conf->global->MAIN_SHOW_FACNUMBER_IN_DISCOUNT_LIST) && !empty($obj->fk_facture_source)) {
1609 if ($tmpfac->fetch($obj->fk_facture_source) > 0) {
1610 $desc = $desc.
' - '.$tmpfac->ref;
1614 print
'<option value="'.$obj->rowid.
'"'.$selectstring.$disabled.
'>'.$desc.
' ('.
price($obj->amount_ht).
' '.$langs->trans(
"HT").
' - '.
price($obj->amount_ttc).
' '.$langs->trans(
"TTC").
')</option>';
1621 return $qualifiedlines;
1649 public function select_contacts($socid, $selected =
'', $htmlname =
'contactid', $showempty = 0, $exclude =
'', $limitto =
'', $showfunction = 0, $morecss =
'', $showsoc = 0, $forcecombo = 0, $events = array(), $options_only =
false, $moreparam =
'', $htmlid =
'')
1652 print $this->
selectcontacts($socid, $selected, $htmlname, $showempty, $exclude, $limitto, $showfunction, $morecss, $options_only, $showsoc, $forcecombo, $events, $moreparam, $htmlid);
1680 public function selectcontacts($socid, $selected =
'', $htmlname =
'contactid', $showempty = 0, $exclude =
'', $limitto =
'', $showfunction = 0, $morecss =
'', $options_only =
false, $showsoc = 0, $forcecombo = 0, $events = array(), $moreparam =
'', $htmlid =
'', $multiple =
false, $disableifempty = 0)
1682 global $conf, $langs, $hookmanager, $action;
1684 $langs->load(
'companies');
1686 if (empty($htmlid)) {
1687 $htmlid = $htmlname;
1691 if ($selected ===
'') {
1692 $selected = array();
1693 } elseif (!is_array($selected)) {
1694 $selected = array($selected);
1698 if (!is_object($hookmanager)) {
1699 include_once DOL_DOCUMENT_ROOT.
'/core/class/hookmanager.class.php';
1704 $sql =
"SELECT sp.rowid, sp.lastname, sp.statut, sp.firstname, sp.poste, sp.email, sp.phone, sp.phone_perso, sp.phone_mobile, sp.town AS contact_town";
1705 if ($showsoc > 0 || !empty($conf->global->CONTACT_SHOW_EMAIL_PHONE_TOWN_SELECTLIST)) {
1706 $sql .=
", s.nom as company, s.town AS company_town";
1708 $sql .=
" FROM ".$this->db->prefix().
"socpeople as sp";
1709 if ($showsoc > 0 || !empty($conf->global->CONTACT_SHOW_EMAIL_PHONE_TOWN_SELECTLIST)) {
1710 $sql .=
" LEFT OUTER JOIN ".$this->db->prefix().
"societe as s ON s.rowid=sp.fk_soc";
1712 $sql .=
" WHERE sp.entity IN (".getEntity(
'contact').
")";
1713 if ($socid > 0 || $socid == -1) {
1714 $sql .=
" AND sp.fk_soc = ".((int) $socid);
1716 if (!empty($conf->global->CONTACT_HIDE_INACTIVE_IN_COMBOBOX)) {
1717 $sql .=
" AND sp.statut <> 0";
1720 $parameters = array();
1721 $reshook = $hookmanager->executeHooks(
'selectContactListWhere', $parameters);
1722 $sql .= $hookmanager->resPrint;
1723 $sql .=
" ORDER BY sp.lastname ASC";
1725 dol_syslog(get_class($this).
"::selectcontacts", LOG_DEBUG);
1728 $num = $this->
db->num_rows(
$resql);
1730 if ($htmlname !=
'none' && !$options_only) {
1731 $out .=
'<select class="flat'.($morecss ?
' '.$morecss :
'').
'" id="'.$htmlid.
'" name="'.$htmlname.(($num || empty($disableifempty)) ?
'' :
' disabled').($multiple ?
'[]' :
'').
'" '.($multiple ?
'multiple' :
'').
' '.(!empty($moreparam) ? $moreparam :
'').
'>';
1734 if ($showempty && ! is_numeric($showempty)) {
1735 $textforempty = $showempty;
1736 $out .=
'<option class="optiongrey" value="-1"'.(in_array(-1, $selected) ?
' selected' :
'').
'>'.$textforempty.
'</option>';
1738 if (($showempty == 1 || ($showempty == 3 && $num > 1)) && ! $multiple) {
1739 $out .=
'<option value="0"'.(in_array(0, $selected) ?
' selected' :
'').
'> </option>';
1741 if ($showempty == 2) {
1742 $out .=
'<option value="0"'.(in_array(0, $selected) ?
' selected' :
'').
'>-- '.$langs->trans(
"Internal").
' --</option>';
1748 include_once DOL_DOCUMENT_ROOT.
'/contact/class/contact.class.php';
1749 $contactstatic =
new Contact($this->
db);
1752 $obj = $this->
db->fetch_object(
$resql);
1755 $extendedInfos =
'';
1756 if (!empty($conf->global->CONTACT_SHOW_EMAIL_PHONE_TOWN_SELECTLIST)) {
1757 $extendedInfos = array();
1758 $email = trim($obj->email);
1759 if (!empty($email)) {
1760 $extendedInfos[] = $email;
1762 $phone = trim($obj->phone);
1763 $phone_perso = trim($obj->phone_perso);
1764 $phone_mobile = trim($obj->phone_mobile);
1765 if (!empty($phone)) {
1766 $extendedInfos[] = $phone;
1768 if (!empty($phone_perso)) {
1769 $extendedInfos[] = $phone_perso;
1771 if (!empty($phone_mobile)) {
1772 $extendedInfos[] = $phone_mobile;
1775 $contact_town = trim($obj->contact_town);
1776 $company_town = trim($obj->company_town);
1777 if (!empty($contact_town)) {
1778 $extendedInfos[] = $contact_town;
1779 } elseif (!empty($company_town)) {
1780 $extendedInfos[] = $company_town;
1782 $extendedInfos = implode(
' - ', $extendedInfos);
1783 if (!empty($extendedInfos)) {
1784 $extendedInfos =
' - '.$extendedInfos;
1788 $contactstatic->id = $obj->rowid;
1789 $contactstatic->lastname = $obj->lastname;
1790 $contactstatic->firstname = $obj->firstname;
1791 if ($obj->statut == 1) {
1792 if ($htmlname !=
'none') {
1794 if (is_array($exclude) && count($exclude) && in_array($obj->rowid, $exclude)) {
1797 if (is_array($limitto) && count($limitto) && !in_array($obj->rowid, $limitto)) {
1800 if (!empty($selected) && in_array($obj->rowid, $selected)) {
1801 $out .=
'<option value="'.$obj->rowid.
'"';
1803 $out .=
' disabled';
1805 $out .=
' selected>';
1806 $out .= $contactstatic->getFullName($langs).$extendedInfos;
1807 if ($showfunction && $obj->poste) {
1808 $out .=
' ('.$obj->poste.
')';
1810 if (($showsoc > 0) && $obj->company) {
1811 $out .=
' - ('.$obj->company.
')';
1813 $out .=
'</option>';
1815 $out .=
'<option value="'.$obj->rowid.
'"';
1817 $out .=
' disabled';
1820 $out .= $contactstatic->getFullName($langs).$extendedInfos;
1821 if ($showfunction && $obj->poste) {
1822 $out .=
' ('.$obj->poste.
')';
1824 if (($showsoc > 0) && $obj->company) {
1825 $out .=
' - ('.$obj->company.
')';
1827 $out .=
'</option>';
1830 if (in_array($obj->rowid, $selected)) {
1831 $out .= $contactstatic->getFullName($langs).$extendedInfos;
1832 if ($showfunction && $obj->poste) {
1833 $out .=
' ('.$obj->poste.
')';
1835 if (($showsoc > 0) && $obj->company) {
1836 $out .=
' - ('.$obj->company.
')';
1844 $labeltoshow = ($socid != -1) ? ($langs->trans($socid ?
"NoContactDefinedForThirdParty" :
"NoContactDefined")) : $langs->trans(
'SelectAThirdPartyFirst');
1845 $out .=
'<option class="disabled" value="-1"'.(($showempty == 2 || $multiple) ?
'' :
' selected').
' disabled="disabled">';
1846 $out .= $labeltoshow;
1847 $out .=
'</option>';
1850 $parameters = array(
1852 'htmlname'=>$htmlname,
1855 'showfunction'=>$showfunction,
1856 'showsoc'=>$showsoc,
1859 $reshook = $hookmanager->executeHooks(
'afterSelectContactOptions', $parameters, $this, $action);
1861 if ($htmlname !=
'none' && !$options_only) {
1862 $out .=
'</select>';
1865 if ($conf->use_javascript_ajax && !$forcecombo && !$options_only) {
1866 include_once DOL_DOCUMENT_ROOT.
'/core/lib/ajax.lib.php';
1894 public function select_users($selected =
'', $htmlname =
'userid', $show_empty = 0, $exclude =
null, $disabled = 0, $include =
'', $enableonly =
'', $force_entity =
'0')
1897 print $this->
select_dolusers($selected, $htmlname, $show_empty, $exclude, $disabled, $include, $enableonly, $force_entity);
1925 public function select_dolusers($selected =
'', $htmlname =
'userid', $show_empty = 0, $exclude =
null, $disabled = 0, $include =
'', $enableonly =
'', $force_entity =
'0', $maxlength = 0, $showstatus = 0, $morefilter =
'', $show_every = 0, $enableonlytext =
'', $morecss =
'', $noactive = 0, $outputmode = 0, $multiple =
false, $forcecombo = 0)
1928 global $conf, $user, $langs, $hookmanager;
1932 if ((is_numeric($selected) && ($selected < -2 || empty($selected))) && empty($conf->global->SOCIETE_DISABLE_DEFAULT_SALESREPRESENTATIVE)) {
1933 $selected = $user->id;
1936 if ($selected ===
'') {
1937 $selected = array();
1938 } elseif (!is_array($selected)) {
1939 $selected = array($selected);
1942 $excludeUsers =
null;
1943 $includeUsers =
null;
1946 if (is_array($exclude)) {
1947 $excludeUsers = implode(
",", $exclude);
1950 if (is_array($include)) {
1951 $includeUsers = implode(
",", $include);
1952 } elseif ($include ==
'hierarchy') {
1954 $includeUsers = implode(
",", $user->getAllChildIds(0));
1955 } elseif ($include ==
'hierarchyme') {
1957 $includeUsers = implode(
",", $user->getAllChildIds(1));
1961 $outarray = array();
1964 $sql =
"SELECT DISTINCT u.rowid, u.lastname as lastname, u.firstname, u.statut as status, u.login, u.admin, u.entity, u.photo";
1965 if (!empty($conf->multicompany->enabled) && $conf->entity == 1 && $user->admin && !$user->entity) {
1966 $sql .=
", e.label";
1968 $sql .=
" FROM ".$this->db->prefix().
"user as u";
1969 if (!empty($conf->multicompany->enabled) && $conf->entity == 1 && $user->admin && !$user->entity) {
1970 $sql .=
" LEFT JOIN ".$this->db->prefix().
"entity as e ON e.rowid = u.entity";
1971 if ($force_entity) {
1972 $sql .=
" WHERE u.entity IN (0, ".$this->db->sanitize($force_entity).
")";
1974 $sql .=
" WHERE u.entity IS NOT NULL";
1977 if (!empty($conf->multicompany->enabled) && !empty($conf->global->MULTICOMPANY_TRANSVERSE_MODE)) {
1978 $sql .=
" LEFT JOIN ".$this->db->prefix().
"usergroup_user as ug";
1979 $sql .=
" ON ug.fk_user = u.rowid";
1980 $sql .=
" WHERE ug.entity = ".$conf->entity;
1982 $sql .=
" WHERE u.entity IN (0, ".$conf->entity.
")";
1985 if (!empty($user->socid)) {
1986 $sql .=
" AND u.fk_soc = ".((int) $user->socid);
1988 if (is_array($exclude) && $excludeUsers) {
1989 $sql .=
" AND u.rowid NOT IN (".$this->db->sanitize($excludeUsers).
")";
1991 if ($includeUsers) {
1992 $sql .=
" AND u.rowid IN (".$this->db->sanitize($includeUsers).
")";
1994 if (!empty($conf->global->USER_HIDE_INACTIVE_IN_COMBOBOX) || $noactive) {
1995 $sql .=
" AND u.statut <> 0";
1997 if (!empty($morefilter)) {
1998 $sql .=
" ".$morefilter;
2002 $reshook = $hookmanager->executeHooks(
'addSQLWhereFilterOnSelectUsers', array(), $this, $action);
2003 if (!empty($reshook)) {
2004 $sql .= $hookmanager->resPrint;
2007 if (empty($conf->global->MAIN_FIRSTNAME_NAME_POSITION)) {
2008 $sql .=
" ORDER BY u.statut DESC, u.firstname ASC, u.lastname ASC";
2010 $sql .=
" ORDER BY u.statut DESC, u.lastname ASC, u.firstname ASC";
2013 dol_syslog(get_class($this).
"::select_dolusers", LOG_DEBUG);
2017 $num = $this->
db->num_rows(
$resql);
2021 $out .=
'<select class="flat'.($morecss ?
' '.$morecss :
' minwidth200').
'" id="'.$htmlname.
'" name="'.$htmlname.($multiple ?
'[]' :
'').
'" '.($multiple ?
'multiple' :
'').
' '.($disabled ?
' disabled' :
'').
'>';
2022 if ($show_empty && !$multiple) {
2023 $textforempty =
' ';
2024 if (!empty($conf->use_javascript_ajax)) {
2025 $textforempty =
' ';
2027 if (!is_numeric($show_empty)) {
2028 $textforempty = $show_empty;
2030 $out .=
'<option class="optiongrey" value="'.($show_empty < 0 ? $show_empty : -1).
'"'.((empty($selected) || in_array(-1, $selected)) ?
' selected' :
'').
'>'.$textforempty.
'</option>'.
"\n";
2033 $out .=
'<option value="-2"'.((in_array(-2, $selected)) ?
' selected' :
'').
'>-- '.$langs->trans(
"Everybody").
' --</option>'.
"\n";
2036 $userstatic =
new User($this->
db);
2039 $obj = $this->
db->fetch_object(
$resql);
2041 $userstatic->id = $obj->rowid;
2042 $userstatic->lastname = $obj->lastname;
2043 $userstatic->firstname = $obj->firstname;
2044 $userstatic->photo = $obj->photo;
2045 $userstatic->statut = $obj->status;
2046 $userstatic->entity = $obj->entity;
2047 $userstatic->admin = $obj->admin;
2050 if (is_array($enableonly) && count($enableonly) && !in_array($obj->rowid, $enableonly)) {
2051 $disableline = ($enableonlytext ? $enableonlytext :
'1');
2058 if (empty($conf->global->MAIN_FIRSTNAME_NAME_POSITION)) {
2061 $labeltoshow .= $userstatic->getFullName($langs, $fullNameMode, -1, $maxlength);
2062 if (empty($obj->firstname) && empty($obj->lastname)) {
2063 $labeltoshow .= $obj->login;
2068 if (!empty($conf->global->MAIN_SHOW_LOGIN)) {
2069 $moreinfo .= ($moreinfo ?
' - ' :
' (').$obj->login;
2071 if ($showstatus >= 0) {
2072 if ($obj->status == 1 && $showstatus == 1) {
2073 $moreinfo .= ($moreinfo ?
' - ' :
' (').$langs->trans(
'Enabled');
2075 if ($obj->status == 0 && $showstatus == 1) {
2076 $moreinfo .= ($moreinfo ?
' - ' :
' (').$langs->trans(
'Disabled');
2079 if (!empty($conf->multicompany->enabled) && empty($conf->global->MULTICOMPANY_TRANSVERSE_MODE) && $conf->entity == 1 && $user->admin && !$user->entity) {
2080 if (!$obj->entity) {
2081 $moreinfo .= ($moreinfo ?
' - ' :
' (').$langs->trans(
"AllEntities");
2083 if ($obj->entity != $conf->entity) {
2084 $moreinfo .= ($moreinfo ?
' - ' :
' (').($obj->label ? $obj->label : $langs->trans(
"EntityNameNotDefined"));
2088 $moreinfo .= ($moreinfo ?
')' :
'');
2089 if ($disableline && $disableline !=
'1') {
2090 $moreinfo .=
' - '.$disableline;
2092 $labeltoshow .= $moreinfo;
2094 $out .=
'<option value="'.$obj->rowid.
'"';
2096 $out .=
' disabled';
2098 if ((is_object($selected) && $selected->id == $obj->rowid) || (!is_object($selected) && in_array($obj->rowid, $selected))) {
2099 $out .=
' selected';
2101 $out .=
' data-html="';
2104 $outhtml .= $userstatic->getNomUrl(-3,
'', 0, 1, 24, 1,
'login',
'', 1).
' ';
2106 if ($showstatus >= 0 && $obj->status == 0) {
2107 $outhtml .=
'<strike class="opacitymediumxxx">';
2109 $outhtml .= $labeltoshow;
2110 if ($showstatus >= 0 && $obj->status == 0) {
2111 $outhtml .=
'</strike>';
2115 $out .= $labeltoshow;
2116 $out .=
'</option>';
2118 $outarray[$userstatic->id] = $userstatic->getFullName($langs, $fullNameMode, -1, $maxlength).$moreinfo;
2123 $out .=
'<select class="flat" id="'.$htmlname.
'" name="'.$htmlname.
'" disabled>';
2124 $out .=
'<option value="">'.$langs->trans(
"None").
'</option>';
2126 $out .=
'</select>';
2128 if ($num && !$forcecombo) {
2130 include_once DOL_DOCUMENT_ROOT.
'/core/lib/ajax.lib.php';
2168 public function select_dolusers_forevent($action =
'', $htmlname =
'userid', $show_empty = 0, $exclude =
null, $disabled = 0, $include =
'', $enableonly =
'', $force_entity =
'0', $maxlength = 0, $showstatus = 0, $morefilter =
'', $showproperties = 0, $listofuserid = array(), $listofcontactid = array(), $listofotherid = array())
2171 global $conf, $user, $langs;
2173 $userstatic =
new User($this->
db);
2177 $assignedtouser = array();
2178 if (!empty($_SESSION[
'assignedtouser'])) {
2179 $assignedtouser = json_decode($_SESSION[
'assignedtouser'],
true);
2181 $nbassignetouser = count($assignedtouser);
2184 if ($nbassignetouser) {
2185 $out .=
'<ul class="attendees">';
2189 foreach ($assignedtouser as $key => $value) {
2190 if ($value[
'id'] == $ownerid) {
2195 $userstatic->fetch($value[
'id']);
2196 $out .= $userstatic->getNomUrl(-1);
2198 $ownerid = $value[
'id'];
2199 $out .=
' ('.$langs->trans(
"Owner").
')';
2201 if ($nbassignetouser > 1 && $action !=
'view') {
2202 $out .=
' <input type="image" style="border: 0px;" src="'.img_picto($langs->trans(
"Remove"),
'delete',
'', 0, 1).
'" value="'.$userstatic->id.
'" class="removedassigned reposition" id="removedassigned_'.$userstatic->id.
'" name="removedassigned_'.$userstatic->id.
'">';
2205 if ($showproperties) {
2206 if ($ownerid == $value[
'id'] && is_array($listofuserid) && count($listofuserid) && in_array($ownerid, array_keys($listofuserid))) {
2207 $out .=
'<div class="myavailability inline-block">';
2208 $out .=
'<span class="hideonsmartphone"> - <span class="opacitymedium">'.$langs->trans(
"Availability").
':</span> </span><input id="transparency" class="paddingrightonly" '.($action ==
'view' ?
'disabled' :
'').
' type="checkbox" name="transparency"'.($listofuserid[$ownerid][
'transparency'] ?
' checked' :
'').
'><label for="transparency">'.$langs->trans(
"Busy").
'</label>';
2218 if ($nbassignetouser) {
2223 if ($action !=
'view') {
2224 $out .=
'<input type="hidden" class="removedassignedhidden" name="removedassigned" value="">';
2225 $out .=
'<script type="text/javascript">jQuery(document).ready(function () {';
2226 $out .=
'jQuery(".removedassigned").click(function() { jQuery(".removedassignedhidden").val(jQuery(this).val()); });';
2227 $out .=
'jQuery(".assignedtouser").change(function() { console.log(jQuery(".assignedtouser option:selected").val());';
2228 $out .=
' if (jQuery(".assignedtouser option:selected").val() > 0) { jQuery("#'.$action.
'assignedtouser").attr("disabled", false); }';
2229 $out .=
' else { jQuery("#'.$action.
'assignedtouser").attr("disabled", true); }';
2231 $out .=
'})</script>';
2232 $out .= $this->
select_dolusers(
'', $htmlname, $show_empty, $exclude, $disabled, $include, $enableonly, $force_entity, $maxlength, $showstatus, $morefilter);
2233 $out .=
' <input type="submit" disabled class="button valignmiddle smallpaddingimp reposition" id="'.$action.
'assignedtouser" name="'.$action.
'assignedtouser" value="'.
dol_escape_htmltag($langs->trans(
"Add")).
'">';
2269 public function select_produits($selected =
'', $htmlname =
'productid', $filtertype =
'', $limit = 0, $price_level = 0, $status = 1, $finished = 2, $selected_input_value =
'', $hidelabel = 0, $ajaxoptions = array(), $socid = 0, $showempty =
'1', $forcecombo = 0, $morecss =
'', $hidepriceinlabel = 0, $warehouseStatus =
'', $selected_combinations =
null, $nooutput = 0, $status_purchase = -1)
2272 global $langs, $conf;
2277 $price_level = (!empty($price_level) ? $price_level : 0);
2278 if (is_null($ajaxoptions)) {
2279 $ajaxoptions = array();
2282 if (strval($filtertype) ===
'' && (!empty($conf->product->enabled) || !empty($conf->service->enabled))) {
2283 if (!empty($conf->product->enabled) && empty($conf->service->enabled)) {
2285 } elseif (empty($conf->product->enabled) && !empty($conf->service->enabled)) {
2290 if (!empty($conf->use_javascript_ajax) && !empty($conf->global->PRODUIT_USE_SEARCH_TO_SELECT)) {
2293 if ($selected && empty($selected_input_value)) {
2294 require_once DOL_DOCUMENT_ROOT.
'/product/class/product.class.php';
2295 $producttmpselect =
new Product($this->
db);
2296 $producttmpselect->fetch($selected);
2297 $selected_input_value = $producttmpselect->ref;
2298 unset($producttmpselect);
2301 if ($filtertype ==
'') {
2302 if (empty($conf->product->enabled)) {
2304 } elseif (empty($conf->service->enabled)) {
2309 $urloption =
'htmlname='.$htmlname.
'&outjson=1&price_level='.$price_level.
'&type='.$filtertype.
'&mode=1&status='.$status.
'&status_purchase='.$status_purchase.
'&finished='.$finished.
'&hidepriceinlabel='.$hidepriceinlabel.
'&warehousestatus='.$warehouseStatus;
2311 if (!empty($conf->global->PRODUIT_CUSTOMER_PRICES) && !empty($socid)) {
2312 $urloption .=
'&socid='.$socid;
2314 $out .=
ajax_autocompleter($selected, $htmlname, DOL_URL_ROOT.
'/product/ajax/products.php', $urloption, $conf->global->PRODUIT_USE_SEARCH_TO_SELECT, 1, $ajaxoptions);
2316 if (!empty($conf->variants->enabled) && is_array($selected_combinations)) {
2320 <!-- script to auto show attributes select tags if a variant was selected -->
2322 // auto show attributes fields
2323 selected = '.json_encode($selected_combinations).
';
2326 jQuery(document).ready(function () {
2328 jQuery("input[name=\'prod_entry_mode\']").change(function () {
2329 if (jQuery(this).val() == \'free\') {
2330 jQuery(\'div#attributes_box\').empty();
2334 jQuery("input#'.$htmlname.
'").change(function () {
2336 if (!jQuery(this).val()) {
2337 jQuery(\'div#attributes_box\').empty();
2341 console.log("A change has started. We get variants fields to inject html select");
2343 jQuery.getJSON("'.DOL_URL_ROOT.
'/variants/ajax/getCombinations.php", {
2344 id: jQuery(this).val()
2345 }, function (data) {
2346 jQuery(\'div#attributes_box\').empty();
2348 jQuery.each(data, function (key, val) {
2350 combvalues[val.id] = val.values;
2352 var span = jQuery(document.createElement(\'div\')).css({
2353 \'display\': \'table-row\'
2357 jQuery(document.createElement(\'div\')).text(val.label).css({
2358 \'font-weight\': \'bold\',
2359 \'display\': \'table-cell\'
2363 var html = jQuery(document.createElement(\'select\')).attr(\'name\', \'combinations[\' + val.id + \']\').css({
2364 \'margin-left\': \'15px\',
2365 \'white-space\': \'pre\'
2367 jQuery(document.createElement(\'option\')).val(\'\')
2370 jQuery.each(combvalues[val.id], function (key, val) {
2371 var tag = jQuery(document.createElement(\'option\')).val(val.id).html(val.value);
2373 if (selected[val.fk_product_attribute] == val.id) {
2374 tag.attr(\'selected\', \'selected\');
2381 jQuery(\'div#attributes_box\').append(span);
2386 '.($selected ?
'jQuery("input#'.$htmlname.
'").change();' :
'').
'
2392 if (empty($hidelabel)) {
2393 $out .= $langs->trans(
"RefOrLabel").
' : ';
2394 } elseif ($hidelabel > 1) {
2395 $placeholder =
' placeholder="'.$langs->trans(
"RefOrLabel").
'"';
2396 if ($hidelabel == 2) {
2397 $out .=
img_picto($langs->trans(
"Search"),
'search');
2400 $out .=
'<input type="text" class="minwidth100'.($morecss ?
' '.$morecss :
'').
'" name="search_'.$htmlname.
'" id="search_'.$htmlname.
'" value="'.$selected_input_value.
'"'.$placeholder.
' '.(!empty($conf->global->PRODUCT_SEARCH_AUTOFOCUS) ?
'autofocus' :
'').
' />';
2401 if ($hidelabel == 3) {
2402 $out .=
img_picto($langs->trans(
"Search"),
'search');
2405 $out .= $this->
select_produits_list($selected, $htmlname, $filtertype, $limit, $price_level,
'', $status, $finished, 0, $socid, $showempty, $forcecombo, $morecss, $hidepriceinlabel, $warehouseStatus, $status_purchase);
2408 if (empty($nooutput)) {
2432 public function select_bom($selected =
'', $htmlname =
'bom_id', $limit = 0, $status = 1, $type = 0, $showempty =
'1', $morecss =
'', $nooutput =
'', $forcecombo = 0, $TProducts = [])
2435 global $conf, $user, $langs, $db;
2437 require_once DOL_DOCUMENT_ROOT.
'/product/class/product.class.php';
2443 include_once DOL_DOCUMENT_ROOT.
'/core/lib/ajax.lib.php';
2448 $out .=
'<select class="flat'.($morecss ?
' '.$morecss :
'').
'" name="'.$htmlname.
'" id="'.$htmlname.
'">';
2450 $sql =
'SELECT b.rowid, b.ref, b.label, b.fk_product';
2451 $sql.=
' FROM '.MAIN_DB_PREFIX.
'bom_bom as b';
2452 $sql.=
' WHERE b.entity IN ('.getEntity(
'bom').
')';
2453 if (!empty($status)) $sql.=
' AND status = '. (
int) $status;
2454 if (!empty($type)) $sql.=
' AND bomtype = '. (
int) $type;
2455 if (!empty($TProducts)) $sql .=
' AND fk_product IN ('.$this->
db->sanitize(implode(
',', $TProducts)).
')';
2456 if (!empty($limit)) $sql.=
' LIMIT '. (
int) $limit;
2457 $resql = $db->query($sql);
2460 $out .=
'<option value="-1"';
2461 if (empty($selected)) $out .=
' selected';
2462 $out .=
'> </option>';
2464 while ($obj = $db->fetch_object(
$resql)) {
2466 $res = $product->fetch($obj->fk_product);
2467 $out .=
'<option value="'.$obj->rowid.
'"';
2468 if ($obj->rowid == $selected) $out .=
'selected';
2469 $out .=
'>'.$obj->ref.
' - '.$product->label .
' - '. $obj->label.
'</option>';
2475 if (empty($nooutput)) {
2508 public function select_produits_list($selected =
'', $htmlname =
'productid', $filtertype =
'', $limit = 20, $price_level = 0, $filterkey =
'', $status = 1, $finished = 2, $outputmode = 0, $socid = 0, $showempty =
'1', $forcecombo = 0, $morecss =
'', $hidepriceinlabel = 0, $warehouseStatus =
'', $status_purchase = -1)
2511 global $langs, $conf;
2512 global $hookmanager;
2515 $outarray = array();
2518 if (!empty($conf->global->PRODUCT_USE_UNITS)) {
2519 $langs->load(
'other');
2522 $warehouseStatusArray = array();
2523 if (!empty($warehouseStatus)) {
2524 require_once DOL_DOCUMENT_ROOT.
'/product/stock/class/entrepot.class.php';
2525 if (preg_match(
'/warehouseclosed/', $warehouseStatus)) {
2528 if (preg_match(
'/warehouseopen/', $warehouseStatus)) {
2531 if (preg_match(
'/warehouseinternal/', $warehouseStatus)) {
2536 $selectFields =
" p.rowid, p.ref, p.label, p.description, p.barcode, p.fk_country, p.fk_product_type, p.price, p.price_ttc, p.price_base_type, p.tva_tx, p.default_vat_code, p.duration, p.fk_price_expression";
2537 if (count($warehouseStatusArray)) {
2538 $selectFieldsGrouped =
", sum(".$this->db->ifsql(
"e.statut IS NULL",
"0",
"ps.reel").
") as stock";
2540 $selectFieldsGrouped =
", ".$this->db->ifsql(
"p.stock IS NULL", 0,
"p.stock").
" AS stock";
2544 $sql .= $selectFields.$selectFieldsGrouped;
2546 if (!empty($conf->global->PRODUCT_SORT_BY_CATEGORY)) {
2548 $sql .=
", (SELECT ".$this->db->prefix().
"categorie_product.fk_categorie
2549 FROM ".$this->
db->prefix().
"categorie_product
2550 WHERE ".$this->
db->prefix().
"categorie_product.fk_product=p.rowid
2552 ) AS categorie_product_id ";
2556 if (!empty($conf->global->PRODUIT_CUSTOMER_PRICES) && !empty($socid)) {
2557 $sql .=
', pcp.rowid as idprodcustprice, pcp.price as custprice, pcp.price_ttc as custprice_ttc,';
2558 $sql .=
' pcp.price_base_type as custprice_base_type, pcp.tva_tx as custtva_tx, pcp.default_vat_code as custdefault_vat_code, pcp.ref_customer as custref';
2559 $selectFields .=
", idprodcustprice, custprice, custprice_ttc, custprice_base_type, custtva_tx, custdefault_vat_code, custref";
2562 if (!empty($conf->global->PRODUCT_USE_UNITS)) {
2563 $sql .=
", u.label as unit_long, u.short_label as unit_short, p.weight, p.weight_units, p.length, p.length_units, p.width, p.width_units, p.height, p.height_units, p.surface, p.surface_units, p.volume, p.volume_units";
2564 $selectFields .=
', unit_long, unit_short, p.weight, p.weight_units, p.length, p.length_units, p.width, p.width_units, p.height, p.height_units, p.surface, p.surface_units, p.volume, p.volume_units';
2568 if (!empty($conf->global->MAIN_MULTILANGS)) {
2569 $sql .=
", pl.label as label_translated";
2570 $sql .=
", pl.description as description_translated";
2571 $selectFields .=
", label_translated";
2572 $selectFields .=
", description_translated";
2575 if (!empty($conf->global->PRODUIT_CUSTOMER_PRICES_BY_QTY) || !empty($conf->global->PRODUIT_CUSTOMER_PRICES_BY_QTY_MULTIPRICES)) {
2576 $sql .=
", (SELECT pp.rowid FROM ".$this->db->prefix().
"product_price as pp WHERE pp.fk_product = p.rowid";
2577 if ($price_level >= 1 && !empty($conf->global->PRODUIT_CUSTOMER_PRICES_BY_QTY_MULTIPRICES)) {
2578 $sql .=
" AND price_level = ".((int) $price_level);
2580 $sql .=
" ORDER BY date_price";
2581 $sql .=
" DESC LIMIT 1) as price_rowid";
2582 $sql .=
", (SELECT pp.price_by_qty FROM ".$this->db->prefix().
"product_price as pp WHERE pp.fk_product = p.rowid";
2583 if ($price_level >= 1 && !empty($conf->global->PRODUIT_CUSTOMER_PRICES_BY_QTY_MULTIPRICES)) {
2584 $sql .=
" AND price_level = ".((int) $price_level);
2586 $sql .=
" ORDER BY date_price";
2587 $sql .=
" DESC LIMIT 1) as price_by_qty";
2588 $selectFields .=
", price_rowid, price_by_qty";
2590 $sql .=
" FROM ".$this->db->prefix().
"product as p";
2591 if (count($warehouseStatusArray)) {
2592 $sql .=
" LEFT JOIN ".$this->db->prefix().
"product_stock as ps on ps.fk_product = p.rowid";
2593 $sql .=
" LEFT JOIN ".$this->db->prefix().
"entrepot as e on ps.fk_entrepot = e.rowid AND e.entity IN (".
getEntity(
'stock').
")";
2594 $sql .=
' AND e.statut IN ('.$this->db->sanitize($this->
db->escape(implode(
',', $warehouseStatusArray))).
')';
2598 if (!empty($conf->global->MAIN_SEARCH_PRODUCT_BY_FOURN_REF)) {
2599 $sql .=
" LEFT JOIN ".$this->db->prefix().
"product_fournisseur_price as pfp ON p.rowid = pfp.fk_product";
2603 if (!empty($conf->global->PRODUIT_CUSTOMER_PRICES) && !empty($socid)) {
2604 $sql .=
" LEFT JOIN ".$this->db->prefix().
"product_customer_price as pcp ON pcp.fk_soc=".((int) $socid).
" AND pcp.fk_product=p.rowid";
2607 if (!empty($conf->global->PRODUCT_USE_UNITS)) {
2608 $sql .=
" LEFT JOIN ".$this->db->prefix().
"c_units u ON u.rowid = p.fk_unit";
2611 if (!empty($conf->global->MAIN_MULTILANGS)) {
2612 $sql .=
" LEFT JOIN ".$this->db->prefix().
"product_lang as pl ON pl.fk_product = p.rowid ";
2613 if (!empty($conf->global->PRODUIT_TEXTS_IN_THIRDPARTY_LANGUAGE) && !empty($socid)) {
2614 require_once DOL_DOCUMENT_ROOT.
'/societe/class/societe.class.php';
2616 $result = $soc->fetch($socid);
2617 if ($result > 0 && !empty($soc->default_lang)) {
2618 $sql .=
" AND pl.lang = '".$this->db->escape($soc->default_lang).
"'";
2620 $sql .=
" AND pl.lang = '".$this->db->escape($langs->getDefaultLang()).
"'";
2623 $sql .=
" AND pl.lang = '".$this->db->escape($langs->getDefaultLang()).
"'";
2627 if (!empty($conf->global->PRODUIT_ATTRIBUTES_HIDECHILD)) {
2628 $sql .=
" LEFT JOIN ".$this->db->prefix().
"product_attribute_combination pac ON pac.fk_product_child = p.rowid";
2631 $sql .=
' WHERE p.entity IN ('.getEntity(
'product').
')';
2633 if (!empty($conf->global->PRODUIT_ATTRIBUTES_HIDECHILD)) {
2634 $sql .=
" AND pac.rowid IS NULL";
2637 if ($finished == 0) {
2638 $sql .=
" AND p.finished = ".((int) $finished);
2639 } elseif ($finished == 1) {
2640 $sql .=
" AND p.finished = ".((int) $finished);
2642 $sql .=
" AND p.tosell = ".((int) $status);
2644 } elseif ($status >= 0) {
2645 $sql .=
" AND p.tosell = ".((int) $status);
2647 if ($status_purchase >= 0) {
2648 $sql .=
" AND p.tobuy = ".((int) $status_purchase);
2651 if (strval($filtertype) !=
'') {
2652 $sql .=
" AND p.fk_product_type = ".((int) $filtertype);
2653 } elseif (empty($conf->product->enabled)) {
2654 $sql .=
" AND p.fk_product_type = 1";
2655 } elseif (empty($conf->service->enabled)) {
2656 $sql .=
" AND p.fk_product_type = 0";
2659 $parameters = array();
2660 $reshook = $hookmanager->executeHooks(
'selectProductsListWhere', $parameters);
2661 $sql .= $hookmanager->resPrint;
2663 if ($filterkey !=
'') {
2665 $prefix = empty($conf->global->PRODUCT_DONOTSEARCH_ANYWHERE) ?
'%' :
'';
2667 $scrit = explode(
' ', $filterkey);
2669 if (count($scrit) > 1) {
2672 foreach ($scrit as $crit) {
2676 $sql .=
"(p.ref LIKE '".$this->db->escape($prefix.$crit).
"%' OR p.label LIKE '".$this->
db->escape($prefix.$crit).
"%'";
2677 if (!empty($conf->global->MAIN_MULTILANGS)) {
2678 $sql .=
" OR pl.label LIKE '".$this->db->escape($prefix.$crit).
"%'";
2680 if (!empty($conf->global->PRODUIT_CUSTOMER_PRICES) && ! empty($socid)) {
2681 $sql .=
" OR pcp.ref_customer LIKE '".$this->db->escape($prefix.$crit).
"%'";
2683 if (!empty($conf->global->PRODUCT_AJAX_SEARCH_ON_DESCRIPTION)) {
2684 $sql .=
" OR p.description LIKE '".$this->db->escape($prefix.$crit).
"%'";
2685 if (!empty($conf->global->MAIN_MULTILANGS)) {
2686 $sql .=
" OR pl.description LIKE '".$this->db->escape($prefix.$crit).
"%'";
2689 if (!empty($conf->global->MAIN_SEARCH_PRODUCT_BY_FOURN_REF)) {
2690 $sql .=
" OR pfp.ref_fourn LIKE '".$this->db->escape($prefix.$crit).
"%'";
2695 if (count($scrit) > 1) {
2698 if (!empty($conf->barcode->enabled)) {
2699 $sql .=
" OR p.barcode LIKE '".$this->db->escape($prefix.$filterkey).
"%'";
2703 if (count($warehouseStatusArray)) {
2704 $sql .=
" GROUP BY ".$selectFields;
2708 if (!empty($conf->global->PRODUCT_SORT_BY_CATEGORY)) {
2709 $sql .=
" ORDER BY categorie_product_id ";
2711 ($conf->global->PRODUCT_SORT_BY_CATEGORY == 1) ? $sql .=
"ASC" : $sql .=
"DESC";
2713 $sql .= $this->
db->order(
"p.ref");
2716 $sql .= $this->
db->plimit($limit, 0);
2719 dol_syslog(get_class($this).
"::select_produits_list search products", LOG_DEBUG);
2720 $result = $this->
db->query($sql);
2722 require_once DOL_DOCUMENT_ROOT.
'/product/class/product.class.php';
2723 require_once DOL_DOCUMENT_ROOT.
'/product/dynamic_price/class/price_parser.class.php';
2724 require_once DOL_DOCUMENT_ROOT.
'/core/lib/product.lib.php';
2726 $num = $this->
db->num_rows($result);
2731 include_once DOL_DOCUMENT_ROOT.
'/core/lib/ajax.lib.php';
2735 $out .=
'<select class="flat'.($morecss ?
' '.$morecss :
'').
'" name="'.$htmlname.
'" id="'.$htmlname.
'">';
2740 if (!empty($conf->global->PRODUIT_USE_SEARCH_TO_SELECT)) {
2741 if ($showempty && !is_numeric($showempty)) {
2742 $textifempty = $langs->trans($showempty);
2744 $textifempty .= $langs->trans(
"All");
2747 if ($showempty && !is_numeric($showempty)) {
2748 $textifempty = $langs->trans($showempty);
2752 $out .=
'<option value="-1" selected>'.($textifempty ? $textifempty :
' ').
'</option>';
2756 while ($num && $i < $num) {
2759 $objp = $this->
db->fetch_object($result);
2761 if ((!empty($conf->global->PRODUIT_CUSTOMER_PRICES_BY_QTY) || !empty($conf->global->PRODUIT_CUSTOMER_PRICES_BY_QTY_MULTIPRICES)) && !empty($objp->price_by_qty) && $objp->price_by_qty == 1) {
2762 $sql =
"SELECT rowid, quantity, price, unitprice, remise_percent, remise, price_base_type";
2763 $sql .=
" FROM ".$this->db->prefix().
"product_price_by_qty";
2764 $sql .=
" WHERE fk_product_price = ".((int) $objp->price_rowid);
2765 $sql .=
" ORDER BY quantity ASC";
2767 dol_syslog(get_class($this).
"::select_produits_list search prices by qty", LOG_DEBUG);
2768 $result2 = $this->
db->query($sql);
2770 $nb_prices = $this->
db->num_rows($result2);
2772 while ($nb_prices && $j < $nb_prices) {
2773 $objp2 = $this->
db->fetch_object($result2);
2775 $objp->price_by_qty_rowid = $objp2->rowid;
2776 $objp->price_by_qty_price_base_type = $objp2->price_base_type;
2777 $objp->price_by_qty_quantity = $objp2->quantity;
2778 $objp->price_by_qty_unitprice = $objp2->unitprice;
2779 $objp->price_by_qty_remise_percent = $objp2->remise_percent;
2781 $objp->quantity = $objp2->quantity;
2782 $objp->price = $objp2->price;
2783 $objp->unitprice = $objp2->unitprice;
2784 $objp->remise_percent = $objp2->remise_percent;
2797 array_push($outarray, $optJson);
2801 if (!empty($conf->dynamicprices->enabled) && !empty($objp->fk_price_expression)) {
2802 $price_product =
new Product($this->
db);
2803 $price_product->fetch($objp->rowid,
'',
'', 1);
2805 $price_result = $priceparser->parseProduct($price_product);
2806 if ($price_result >= 0) {
2807 $objp->price = $price_result;
2808 $objp->unitprice = $price_result;
2810 $objp->price_ttc =
price2num($objp->price) * (1 + ($objp->tva_tx / 100));
2811 $objp->price_ttc =
price2num($objp->price_ttc,
'MU');
2820 array_push($outarray, $optJson);
2826 $out .=
'</select>';
2828 $this->
db->free($result);
2830 if (empty($outputmode)) {
2854 protected function constructProductListOption(&$objp, &$opt, &$optJson, $price_level, $selected, $hidepriceinlabel = 0, $filterkey =
'', $novirtualstock = 0)
2856 global $langs, $conf, $user;
2862 $outlabel_translated =
'';
2864 $outdesc_translated =
'';
2870 $outpricebasetype =
'';
2872 $outdefault_vat_code =
'';
2876 $maxlengtharticle = (empty($conf->global->PRODUCT_MAX_LENGTH_COMBO) ? 48 : $conf->global->PRODUCT_MAX_LENGTH_COMBO);
2878 $label = $objp->label;
2879 if (!empty($objp->label_translated)) {
2880 $label = $objp->label_translated;
2882 if (!empty($filterkey) && $filterkey !=
'') {
2883 $label = preg_replace(
'/('.preg_quote($filterkey,
'/').
')/i',
'<strong>$1</strong>', $label, 1);
2886 $outkey = $objp->rowid;
2887 $outref = $objp->ref;
2888 $outrefcust = empty($objp->custref) ?
'' : $objp->custref;
2889 $outlabel = $objp->label;
2890 $outdesc = $objp->description;
2891 if (!empty($conf->global->MAIN_MULTILANGS)) {
2892 $outlabel_translated = $objp->label_translated;
2893 $outdesc_translated = $objp->description_translated;
2895 $outbarcode = $objp->barcode;
2896 $outorigin = $objp->fk_country;
2897 $outpbq = empty($objp->price_by_qty_rowid) ?
'' : $objp->price_by_qty_rowid;
2899 $outtype = $objp->fk_product_type;
2903 if ($outorigin && !empty($conf->global->PRODUCT_SHOW_ORIGIN_IN_COMBO)) {
2904 require_once DOL_DOCUMENT_ROOT.
'/core/lib/company.lib.php';
2909 if (!empty($conf->global->PRODUCT_USE_UNITS)) {
2910 if (!empty($objp->unit_short)) {
2911 $outvalUnits .=
' - '.$objp->unit_short;
2914 if (!empty($conf->global->PRODUCT_SHOW_DIMENSIONS_IN_COMBO)) {
2915 if (!empty($objp->weight) && $objp->weight_units !==
null) {
2917 $outvalUnits .=
' - '.$unitToShow;
2919 if ((!empty($objp->length) || !empty($objp->width) || !empty($objp->height)) && $objp->length_units !==
null) {
2920 $unitToShow = $objp->length.
' x '.$objp->width.
' x '.$objp->height.
' '.
measuringUnitString(0,
'size', $objp->length_units);
2921 $outvalUnits .=
' - '.$unitToShow;
2923 if (!empty($objp->surface) && $objp->surface_units !==
null) {
2925 $outvalUnits .=
' - '.$unitToShow;
2927 if (!empty($objp->volume) && $objp->volume_units !==
null) {
2929 $outvalUnits .=
' - '.$unitToShow;
2932 if ($outdurationvalue && $outdurationunit) {
2934 'h' => $langs->trans(
'Hour'),
2935 'd' => $langs->trans(
'Day'),
2936 'w' => $langs->trans(
'Week'),
2937 'm' => $langs->trans(
'Month'),
2938 'y' => $langs->trans(
'Year')
2940 if (isset($da[$outdurationunit])) {
2941 $outvalUnits .=
' - '.$outdurationvalue.
' '.$langs->transnoentities($da[$outdurationunit].($outdurationvalue > 1 ?
's' :
''));
2945 $opt =
'<option value="'.$objp->rowid.
'"';
2946 $opt .= ($objp->rowid == $selected) ?
' selected' :
'';
2947 if (!empty($objp->price_by_qty_rowid) && $objp->price_by_qty_rowid > 0) {
2948 $opt .=
' pbq="'.$objp->price_by_qty_rowid.
'" data-pbq="'.$objp->price_by_qty_rowid.
'" data-pbqup="'.$objp->price_by_qty_unitprice.
'" data-pbqbase="'.$objp->price_by_qty_price_base_type.
'" data-pbqqty="'.$objp->price_by_qty_quantity.
'" data-pbqpercent="'.$objp->price_by_qty_remise_percent.
'"';
2950 if (!empty($conf->stock->enabled) && isset($objp->stock) && ($objp->fk_product_type ==
Product::TYPE_PRODUCT || !empty($conf->global->STOCK_SUPPORTS_SERVICES))) {
2951 if (!empty($user->rights->stock->lire)) {
2952 if ($objp->stock > 0) {
2953 $opt .=
' class="product_line_stock_ok"';
2954 } elseif ($objp->stock <= 0) {
2955 $opt .=
' class="product_line_stock_too_low"';
2959 if (!empty($conf->global->PRODUIT_TEXTS_IN_THIRDPARTY_LANGUAGE)) {
2960 $opt .=
' data-labeltrans="'.$outlabel_translated.
'"';
2961 $opt .=
' data-desctrans="'.dol_escape_htmltag($outdesc_translated).
'"';
2965 if (! empty($objp->custref)) {
2966 $opt.=
' (' . $objp->custref .
')';
2969 $opt .=
' ('.$outbarcode.
')';
2971 $opt .=
' - '.dol_trunc($label, $maxlengtharticle);
2972 if ($outorigin && !empty($conf->global->PRODUCT_SHOW_ORIGIN_IN_COMBO)) {
2973 $opt .=
' ('.getCountry($outorigin, 1).
')';
2976 $objRef = $objp->ref;
2977 if (! empty($objp->custref)) {
2978 $objRef .=
' (' . $objp->custref .
')';
2980 if (!empty($filterkey) && $filterkey !=
'') {
2981 $objRef = preg_replace(
'/('.preg_quote($filterkey,
'/').
')/i',
'<strong>$1</strong>', $objRef, 1);
2985 $outval .=
' ('.$outbarcode.
')';
2987 $outval .=
' - '.dol_trunc($label, $maxlengtharticle);
2988 if ($outorigin && !empty($conf->global->PRODUCT_SHOW_ORIGIN_IN_COMBO)) {
2989 $outval .=
' ('.getCountry($outorigin, 1).
')';
2993 $opt .= $outvalUnits;
2994 $outval .= $outvalUnits;
3000 if (empty($hidepriceinlabel) && $price_level >= 1 && (!empty($conf->global->PRODUIT_MULTIPRICES) || !empty($conf->global->PRODUIT_CUSTOMER_PRICES_BY_QTY_MULTIPRICES))) {
3001 $sql =
"SELECT price, price_ttc, price_base_type, tva_tx, default_vat_code";
3002 $sql .=
" FROM ".$this->db->prefix().
"product_price";
3003 $sql .=
" WHERE fk_product = ".((int) $objp->rowid);
3004 $sql .=
" AND entity IN (".getEntity(
'productprice').
")";
3005 $sql .=
" AND price_level = ".((int) $price_level);
3006 $sql .=
" ORDER BY date_price DESC, rowid DESC";
3009 dol_syslog(get_class($this).
'::constructProductListOption search price for product '.$objp->rowid.
' AND level '.$price_level.
'', LOG_DEBUG);
3010 $result2 = $this->
db->query($sql);
3012 $objp2 = $this->
db->fetch_object($result2);
3015 if ($objp2->price_base_type ==
'HT') {
3016 $opt .=
' - '.price($objp2->price, 1, $langs, 0, 0, -1, $conf->currency).
' '.$langs->trans(
"HT");
3017 $outval .=
' - '.price($objp2->price, 0, $langs, 0, 0, -1, $conf->currency).
' '.$langs->transnoentities(
"HT");
3019 $opt .=
' - '.price($objp2->price_ttc, 1, $langs, 0, 0, -1, $conf->currency).
' '.$langs->trans(
"TTC");
3020 $outval .=
' - '.price($objp2->price_ttc, 0, $langs, 0, 0, -1, $conf->currency).
' '.$langs->transnoentities(
"TTC");
3022 $outprice_ht =
price($objp2->price);
3023 $outprice_ttc =
price($objp2->price_ttc);
3024 $outpricebasetype = $objp2->price_base_type;
3025 if (!empty($conf->global->PRODUIT_MULTIPRICES_USE_VAT_PER_LEVEL)) {
3026 $outtva_tx = $objp2->tva_tx;
3027 $outdefault_vat_code = $objp2->default_vat_code;
3029 $outtva_tx = $objp->tva_tx;
3030 $outdefault_vat_code = $objp->default_vat_code;
3039 if (empty($hidepriceinlabel) && !empty($objp->quantity) && $objp->quantity >= 1 && (!empty($conf->global->PRODUIT_CUSTOMER_PRICES_BY_QTY) || !empty($conf->global->PRODUIT_CUSTOMER_PRICES_BY_QTY_MULTIPRICES))) {
3041 $outqty = $objp->quantity;
3042 $outdiscount = $objp->remise_percent;
3043 if ($objp->quantity == 1) {
3044 $opt .=
' - '.price($objp->unitprice, 1, $langs, 0, 0, -1, $conf->currency).
"/";
3045 $outval .=
' - '.price($objp->unitprice, 0, $langs, 0, 0, -1, $conf->currency).
"/";
3046 $opt .= $langs->trans(
"Unit");
3047 $outval .= $langs->transnoentities(
"Unit");
3049 $opt .=
' - '.price($objp->price, 1, $langs, 0, 0, -1, $conf->currency).
"/".$objp->quantity;
3050 $outval .=
' - '.price($objp->price, 0, $langs, 0, 0, -1, $conf->currency).
"/".$objp->quantity;
3051 $opt .= $langs->trans(
"Units");
3052 $outval .= $langs->transnoentities(
"Units");
3055 $outprice_ht =
price($objp->unitprice);
3056 $outprice_ttc =
price($objp->unitprice * (1 + ($objp->tva_tx / 100)));
3057 $outpricebasetype = $objp->price_base_type;
3058 $outtva_tx = $objp->tva_tx;
3059 $outdefault_vat_code = $objp->default_vat_code;
3061 if (empty($hidepriceinlabel) && !empty($objp->quantity) && $objp->quantity >= 1) {
3062 $opt .=
" (".price($objp->unitprice, 1, $langs, 0, 0, -1, $conf->currency).
"/".$langs->trans(
"Unit").
")";
3063 $outval .=
" (".price($objp->unitprice, 0, $langs, 0, 0, -1, $conf->currency).
"/".$langs->transnoentities(
"Unit").
")";
3065 if (empty($hidepriceinlabel) && !empty($objp->remise_percent) && $objp->remise_percent >= 1) {
3066 $opt .=
" - ".$langs->trans(
"Discount").
" : ".
vatrate($objp->remise_percent).
' %';
3067 $outval .=
" - ".$langs->transnoentities(
"Discount").
" : ".
vatrate($objp->remise_percent).
' %';
3071 if (empty($hidepriceinlabel) && !empty($conf->global->PRODUIT_CUSTOMER_PRICES)) {
3072 if (!empty($objp->idprodcustprice)) {
3075 if ($objp->custprice_base_type ==
'HT') {
3076 $opt .=
' - '.price($objp->custprice, 1, $langs, 0, 0, -1, $conf->currency).
' '.$langs->trans(
"HT");
3077 $outval .=
' - '.price($objp->custprice, 0, $langs, 0, 0, -1, $conf->currency).
' '.$langs->transnoentities(
"HT");
3079 $opt .=
' - '.price($objp->custprice_ttc, 1, $langs, 0, 0, -1, $conf->currency).
' '.$langs->trans(
"TTC");
3080 $outval .=
' - '.price($objp->custprice_ttc, 0, $langs, 0, 0, -1, $conf->currency).
' '.$langs->transnoentities(
"TTC");
3083 $outprice_ht =
price($objp->custprice);
3084 $outprice_ttc =
price($objp->custprice_ttc);
3085 $outpricebasetype = $objp->custprice_base_type;
3086 $outtva_tx = $objp->custtva_tx;
3087 $outdefault_vat_code = $objp->custdefault_vat_code;
3092 if (empty($hidepriceinlabel) && !$found) {
3093 if ($objp->price_base_type ==
'HT') {
3094 $opt .=
' - '.price($objp->price, 1, $langs, 0, 0, -1, $conf->currency).
' '.$langs->trans(
"HT");
3095 $outval .=
' - '.price($objp->price, 0, $langs, 0, 0, -1, $conf->currency).
' '.$langs->transnoentities(
"HT");
3097 $opt .=
' - '.price($objp->price_ttc, 1, $langs, 0, 0, -1, $conf->currency).
' '.$langs->trans(
"TTC");
3098 $outval .=
' - '.price($objp->price_ttc, 0, $langs, 0, 0, -1, $conf->currency).
' '.$langs->transnoentities(
"TTC");
3100 $outprice_ht =
price($objp->price);
3101 $outprice_ttc =
price($objp->price_ttc);
3102 $outpricebasetype = $objp->price_base_type;
3103 $outtva_tx = $objp->tva_tx;
3104 $outdefault_vat_code = $objp->default_vat_code;
3107 if (!empty($conf->stock->enabled) && isset($objp->stock) && ($objp->fk_product_type ==
Product::TYPE_PRODUCT || !empty($conf->global->STOCK_SUPPORTS_SERVICES))) {
3108 if (!empty($user->rights->stock->lire)) {
3109 $opt .=
' - '.$langs->trans(
"Stock").
': '.
price(
price2num($objp->stock,
'MS'));
3111 if ($objp->stock > 0) {
3112 $outval .=
' - <span class="product_line_stock_ok">';
3113 } elseif ($objp->stock <= 0) {
3114 $outval .=
' - <span class="product_line_stock_too_low">';
3116 $outval .= $langs->transnoentities(
"Stock").
': '.
price(
price2num($objp->stock,
'MS'));
3117 $outval .=
'</span>';
3118 if (empty($novirtualstock) && !empty($conf->global->STOCK_SHOW_VIRTUAL_STOCK_IN_PRODUCTS_COMBO)) {
3119 $langs->load(
"stocks");
3122 $tmpproduct->fetch($objp->rowid,
'',
'',
'', 1, 1, 1);
3123 $tmpproduct->load_virtual_stock();
3124 $virtualstock = $tmpproduct->stock_theorique;
3126 $opt .=
' - '.$langs->trans(
"VirtualStock").
':'.$virtualstock;
3128 $outval .=
' - '.$langs->transnoentities(
"VirtualStock").
':';
3129 if ($virtualstock > 0) {
3130 $outval .=
'<span class="product_line_stock_ok">';
3131 } elseif ($virtualstock <= 0) {
3132 $outval .=
'<span class="product_line_stock_too_low">';
3134 $outval .= $virtualstock;
3135 $outval .=
'</span>';
3142 $opt .=
"</option>\n";
3147 'label2'=>$outlabel,
3154 'pricebasetype'=>$outpricebasetype,
3155 'tva_tx'=>$outtva_tx,
3156 'default_vat_code'=>$outdefault_vat_code,
3158 'discount'=>$outdiscount,
3159 'duration_value'=>$outdurationvalue,
3160 'duration_unit'=>$outdurationunit,
3162 'labeltrans'=>$outlabel_translated,
3163 'desctrans'=>$outdesc_translated,
3164 'ref_customer'=>$outrefcust
3184 public function select_produits_fournisseurs($socid, $selected =
'', $htmlname =
'productid', $filtertype =
'', $filtre =
'', $ajaxoptions = array(), $hidelabel = 0, $alsoproductwithnosupplierprice = 0, $morecss =
'', $placeholder =
'')
3187 global $langs, $conf;
3188 global $price_level, $status, $finished;
3190 if (!isset($status)) {
3194 $selected_input_value =
'';
3195 if (!empty($conf->use_javascript_ajax) && !empty($conf->global->PRODUIT_USE_SEARCH_TO_SELECT)) {
3196 if ($selected > 0) {
3197 require_once DOL_DOCUMENT_ROOT.
'/product/class/product.class.php';
3198 $producttmpselect =
new Product($this->
db);
3199 $producttmpselect->fetch($selected);
3200 $selected_input_value = $producttmpselect->ref;
3201 unset($producttmpselect);
3205 $urloption = ($socid > 0 ?
'socid='.$socid.
'&' :
'').
'htmlname='.$htmlname.
'&outjson=1&price_level='.$price_level.
'&type='.$filtertype.
'&mode=2&status='.$status.
'&finished='.$finished.
'&alsoproductwithnosupplierprice='.$alsoproductwithnosupplierprice;
3206 print
ajax_autocompleter($selected, $htmlname, DOL_URL_ROOT.
'/product/ajax/products.php', $urloption, $conf->global->PRODUIT_USE_SEARCH_TO_SELECT, 0, $ajaxoptions);
3207 print ($hidelabel ?
'' : $langs->trans(
"RefOrLabel").
' : ').
'<input type="text" class="minwidth300" name="search_'.$htmlname.
'" id="search_'.$htmlname.
'" value="'.$selected_input_value.
'"'.($placeholder ?
' placeholder="'.$placeholder.
'"' :
'').
'>';
3209 print $this->
select_produits_fournisseurs_list($socid, $selected, $htmlname, $filtertype, $filtre,
'', $status, 0, 0, $alsoproductwithnosupplierprice, $morecss, 0, $placeholder);
3232 public function select_produits_fournisseurs_list($socid, $selected =
'', $htmlname =
'productid', $filtertype =
'', $filtre =
'', $filterkey =
'', $statut = -1, $outputmode = 0, $limit = 100, $alsoproductwithnosupplierprice = 0, $morecss =
'', $showstockinlist = 0, $placeholder =
'')
3235 global $langs, $conf, $user;
3236 global $hookmanager;
3239 $outarray = array();
3241 $maxlengtharticle = (empty($conf->global->PRODUCT_MAX_LENGTH_COMBO) ? 48 : $conf->global->PRODUCT_MAX_LENGTH_COMBO);
3243 $langs->load(
'stocks');
3245 if (!empty($conf->global->PRODUCT_USE_UNITS)) {
3246 $langs->load(
'other');
3249 $sql =
"SELECT p.rowid, p.ref, p.label, p.price, p.duration, p.fk_product_type, p.stock,";
3250 $sql .=
" pfp.ref_fourn, pfp.rowid as idprodfournprice, pfp.price as fprice, pfp.quantity, pfp.remise_percent, pfp.remise, pfp.unitprice,";
3251 $sql .=
" pfp.fk_supplier_price_expression, pfp.fk_product, pfp.tva_tx, pfp.default_vat_code, pfp.fk_soc, s.nom as name,";
3252 $sql .=
" pfp.supplier_reputation";
3254 if (!empty($conf->global->PRODUIT_FOURN_TEXTS)) {
3255 $sql .=
", pfp.desc_fourn as description";
3257 $sql .=
", p.description";
3260 if (!empty($conf->global->PRODUCT_USE_UNITS)) {
3261 $sql .=
", u.label as unit_long, u.short_label as unit_short, p.weight, p.weight_units, p.length, p.length_units, p.width, p.width_units, p.height, p.height_units, p.surface, p.surface_units, p.volume, p.volume_units";
3263 if (!empty($conf->barcode->enabled)) {
3264 $sql .=
", pfp.barcode";
3266 $sql .=
" FROM ".$this->db->prefix().
"product as p";
3267 $sql .=
" LEFT JOIN ".$this->db->prefix().
"product_fournisseur_price as pfp ON ( p.rowid = pfp.fk_product AND pfp.entity IN (".
getEntity(
'product').
") )";
3269 $sql .=
" AND pfp.fk_soc = ".((int) $socid);
3271 $sql .=
" LEFT JOIN ".$this->db->prefix().
"societe as s ON pfp.fk_soc = s.rowid";
3273 if (!empty($conf->global->PRODUCT_USE_UNITS)) {
3274 $sql .=
" LEFT JOIN ".$this->db->prefix().
"c_units u ON u.rowid = p.fk_unit";
3276 $sql .=
" WHERE p.entity IN (".getEntity(
'product').
")";
3277 if ($statut != -1) {
3278 $sql .=
" AND p.tobuy = ".((int) $statut);
3280 if (strval($filtertype) !=
'') {
3281 $sql .=
" AND p.fk_product_type = ".((int) $filtertype);
3283 if (!empty($filtre)) {
3284 $sql .=
" ".$filtre;
3287 $parameters = array();
3288 $reshook = $hookmanager->executeHooks(
'selectSuppliersProductsListWhere', $parameters);
3289 $sql .= $hookmanager->resPrint;
3291 if ($filterkey !=
'') {
3293 $prefix = empty($conf->global->PRODUCT_DONOTSEARCH_ANYWHERE) ?
'%' :
'';
3295 $scrit = explode(
' ', $filterkey);
3297 if (count($scrit) > 1) {
3300 foreach ($scrit as $crit) {
3304 $sql .=
"(pfp.ref_fourn LIKE '".$this->db->escape($prefix.$crit).
"%' OR p.ref LIKE '".$this->
db->escape($prefix.$crit).
"%' OR p.label LIKE '".$this->
db->escape($prefix.$crit).
"%'";
3305 if (!empty($conf->global->PRODUIT_FOURN_TEXTS)) {
3306 $sql .=
" OR pfp.desc_fourn LIKE '".$this->db->escape($prefix.$crit).
"%'";
3311 if (count($scrit) > 1) {
3314 if (!empty($conf->barcode->enabled)) {
3315 $sql .=
" OR p.barcode LIKE '".$this->db->escape($prefix.$filterkey).
"%'";
3316 $sql .=
" OR pfp.barcode LIKE '".$this->db->escape($prefix.$filterkey).
"%'";
3320 $sql .=
" ORDER BY pfp.ref_fourn DESC, pfp.quantity ASC";
3321 $sql .= $this->
db->plimit($limit, 0);
3325 dol_syslog(get_class($this).
"::select_produits_fournisseurs_list", LOG_DEBUG);
3326 $result = $this->
db->query($sql);
3328 require_once DOL_DOCUMENT_ROOT.
'/product/dynamic_price/class/price_parser.class.php';
3329 require_once DOL_DOCUMENT_ROOT.
'/core/lib/product.lib.php';
3331 $num = $this->
db->num_rows($result);
3334 $out .=
'<select class="flat '.($morecss ?
' '.$morecss :
'').
'" id="'.$htmlname.
'" name="'.$htmlname.
'">';
3336 $out .=
'<option value="-1" selected>'.($placeholder ? $placeholder :
' ').
'</option>';
3338 $out .=
'<option value="-1">'.($placeholder ? $placeholder :
' ').
'</option>';
3343 $objp = $this->
db->fetch_object($result);
3345 $outkey = $objp->idprodfournprice;
3346 if (!$outkey && $alsoproductwithnosupplierprice) {
3347 $outkey =
'idprod_'.$objp->rowid;
3350 $outref = $objp->ref;
3352 $outbarcode = $objp->barcode;
3355 $outtype = $objp->fk_product_type;
3361 if (!empty($conf->global->PRODUCT_USE_UNITS)) {
3362 if (!empty($objp->unit_short)) {
3363 $outvalUnits .=
' - '.$objp->unit_short;
3365 if (!empty($objp->weight) && $objp->weight_units !==
null) {
3367 $outvalUnits .=
' - '.$unitToShow;
3369 if ((!empty($objp->length) || !empty($objp->width) || !empty($objp->height)) && $objp->length_units !==
null) {
3370 $unitToShow = $objp->length.
' x '.$objp->width.
' x '.$objp->height.
' '.
measuringUnitString(0,
'size', $objp->length_units);
3371 $outvalUnits .=
' - '.$unitToShow;
3373 if (!empty($objp->surface) && $objp->surface_units !==
null) {
3375 $outvalUnits .=
' - '.$unitToShow;
3377 if (!empty($objp->volume) && $objp->volume_units !==
null) {
3379 $outvalUnits .=
' - '.$unitToShow;
3381 if ($outdurationvalue && $outdurationunit) {
3383 'h' => $langs->trans(
'Hour'),
3384 'd' => $langs->trans(
'Day'),
3385 'w' => $langs->trans(
'Week'),
3386 'm' => $langs->trans(
'Month'),
3387 'y' => $langs->trans(
'Year')
3389 if (isset($da[$outdurationunit])) {
3390 $outvalUnits .=
' - '.$outdurationvalue.
' '.$langs->transnoentities($da[$outdurationunit].($outdurationvalue > 1 ?
's' :
''));
3395 $objRef = $objp->ref;
3396 if ($filterkey && $filterkey !=
'') {
3397 $objRef = preg_replace(
'/('.preg_quote($filterkey,
'/').
')/i',
'<strong>$1</strong>', $objRef, 1);
3399 $objRefFourn = $objp->ref_fourn;
3400 if ($filterkey && $filterkey !=
'') {
3401 $objRefFourn = preg_replace(
'/('.preg_quote($filterkey,
'/').
')/i',
'<strong>$1</strong>', $objRefFourn, 1);
3403 $label = $objp->label;
3404 if ($filterkey && $filterkey !=
'') {
3405 $label = preg_replace(
'/('.preg_quote($filterkey,
'/').
')/i',
'<strong>$1</strong>', $label, 1);
3408 $optlabel = $objp->ref;
3409 if (!empty($objp->idprodfournprice) && ($objp->ref != $objp->ref_fourn)) {
3410 $optlabel .=
' <span class="opacitymedium">('.$objp->ref_fourn.
')</span>';
3412 if (!empty($conf->barcode->enabled) && !empty($objp->barcode)) {
3413 $optlabel .=
' ('.$outbarcode.
')';
3415 $optlabel .=
' - '.dol_trunc($label, $maxlengtharticle);
3417 $outvallabel = $objRef;
3418 if (!empty($objp->idprodfournprice) && ($objp->ref != $objp->ref_fourn)) {
3419 $outvallabel .=
' ('.$objRefFourn.
')';
3421 if (!empty($conf->barcode->enabled) && !empty($objp->barcode)) {
3422 $outvallabel .=
' ('.$outbarcode.
')';
3424 $outvallabel .=
' - '.dol_trunc($label, $maxlengtharticle);
3427 $optlabel .= $outvalUnits;
3428 $outvallabel .= $outvalUnits;
3430 if (!empty($objp->idprodfournprice)) {
3431 $outqty = $objp->quantity;
3432 $outdiscount = $objp->remise_percent;
3433 if (!empty($conf->dynamicprices->enabled) && !empty($objp->fk_supplier_price_expression)) {
3435 $prod_supplier->product_fourn_price_id = $objp->idprodfournprice;
3436 $prod_supplier->id = $objp->fk_product;
3437 $prod_supplier->fourn_qty = $objp->quantity;
3438 $prod_supplier->fourn_tva_tx = $objp->tva_tx;
3439 $prod_supplier->fk_supplier_price_expression = $objp->fk_supplier_price_expression;
3441 $price_result = $priceparser->parseProductSupplier($prod_supplier);
3442 if ($price_result >= 0) {
3443 $objp->fprice = $price_result;
3444 if ($objp->quantity >= 1) {
3445 $objp->unitprice = $objp->fprice / $objp->quantity;
3449 if ($objp->quantity == 1) {
3450 $optlabel .=
' - '.price($objp->fprice * (!empty($conf->global->DISPLAY_DISCOUNTED_SUPPLIER_PRICE) ? (1 - $objp->remise_percent / 100) : 1), 1, $langs, 0, 0, -1, $conf->currency).
"/";
3451 $outvallabel .=
' - '.price($objp->fprice * (!empty($conf->global->DISPLAY_DISCOUNTED_SUPPLIER_PRICE) ? (1 - $objp->remise_percent / 100) : 1), 0, $langs, 0, 0, -1, $conf->currency).
"/";
3452 $optlabel .= $langs->trans(
"Unit");
3453 $outvallabel .= $langs->transnoentities(
"Unit");
3455 $optlabel .=
' - '.price($objp->fprice * (!empty($conf->global->DISPLAY_DISCOUNTED_SUPPLIER_PRICE) ? (1 - $objp->remise_percent / 100) : 1), 1, $langs, 0, 0, -1, $conf->currency).
"/".$objp->quantity;
3456 $outvallabel .=
' - '.price($objp->fprice * (!empty($conf->global->DISPLAY_DISCOUNTED_SUPPLIER_PRICE) ? (1 - $objp->remise_percent / 100) : 1), 0, $langs, 0, 0, -1, $conf->currency).
"/".$objp->quantity;
3457 $optlabel .=
' '.$langs->trans(
"Units");
3458 $outvallabel .=
' '.$langs->transnoentities(
"Units");
3461 if ($objp->quantity > 1) {
3462 $optlabel .=
" (".price($objp->unitprice * (!empty($conf->global->DISPLAY_DISCOUNTED_SUPPLIER_PRICE) ? (1 - $objp->remise_percent / 100) : 1), 1, $langs, 0, 0, -1, $conf->currency).
"/".$langs->trans(
"Unit").
")";
3463 $outvallabel .=
" (".price($objp->unitprice * (!empty($conf->global->DISPLAY_DISCOUNTED_SUPPLIER_PRICE) ? (1 - $objp->remise_percent / 100) : 1), 0, $langs, 0, 0, -1, $conf->currency).
"/".$langs->transnoentities(
"Unit").
")";
3465 if ($objp->remise_percent >= 1) {
3466 $optlabel .=
" - ".$langs->trans(
"Discount").
" : ".
vatrate($objp->remise_percent).
' %';
3467 $outvallabel .=
" - ".$langs->transnoentities(
"Discount").
" : ".
vatrate($objp->remise_percent).
' %';
3469 if ($objp->duration) {
3470 $optlabel .=
" - ".$objp->duration;
3471 $outvallabel .=
" - ".$objp->duration;
3474 $optlabel .=
" - ".dol_trunc($objp->name, 8);
3475 $outvallabel .=
" - ".dol_trunc($objp->name, 8);
3477 if ($objp->supplier_reputation) {
3479 $reputations = array(
''=>$langs->trans(
'Standard'),
'FAVORITE'=>$langs->trans(
'Favorite'),
'NOTTHGOOD'=>$langs->trans(
'NotTheGoodQualitySupplier'),
'DONOTORDER'=>$langs->trans(
'DoNotOrderThisProductToThisSupplier'));
3481 $optlabel .=
" - ".$reputations[$objp->supplier_reputation];
3482 $outvallabel .=
" - ".$reputations[$objp->supplier_reputation];
3485 if (empty($alsoproductwithnosupplierprice)) {
3486 $optlabel .=
" - <span class='opacitymedium'>".$langs->trans(
"NoPriceDefinedForThisSupplier").
'</span>';
3487 $outvallabel .=
' - '.$langs->transnoentities(
"NoPriceDefinedForThisSupplier");
3490 $optlabel .=
" - <span class='opacitymedium'>".$langs->trans(
"NoPriceDefinedForThisSupplier").
'</span>';
3491 $outvallabel .=
' - '.$langs->transnoentities(
"NoPriceDefinedForThisSupplier");
3495 if (!empty($conf->stock->enabled) && $showstockinlist && isset($objp->stock) && ($objp->fk_product_type ==
Product::TYPE_PRODUCT || !empty($conf->global->STOCK_SUPPORTS_SERVICES))) {
3496 $novirtualstock = ($showstockinlist == 2);
3498 if (!empty($user->rights->stock->lire)) {
3499 $outvallabel .=
' - '.$langs->trans(
"Stock").
': '.
price(
price2num($objp->stock,
'MS'));
3501 if ($objp->stock > 0) {
3502 $optlabel .=
' - <span class="product_line_stock_ok">';
3503 } elseif ($objp->stock <= 0) {
3504 $optlabel .=
' - <span class="product_line_stock_too_low">';
3506 $optlabel .= $langs->transnoentities(
"Stock").
':'.
price(
price2num($objp->stock,
'MS'));
3507 $optlabel .=
'</span>';
3508 if (empty($novirtualstock) && !empty($conf->global->STOCK_SHOW_VIRTUAL_STOCK_IN_PRODUCTS_COMBO)) {
3509 $langs->load(
"stocks");
3512 $tmpproduct->fetch($objp->rowid,
'',
'',
'', 1, 1, 1);
3513 $tmpproduct->load_virtual_stock();
3514 $virtualstock = $tmpproduct->stock_theorique;
3516 $outvallabel .=
' - '.$langs->trans(
"VirtualStock").
':'.$virtualstock;
3518 $optlabel .=
' - '.$langs->transnoentities(
"VirtualStock").
':';
3519 if ($virtualstock > 0) {
3520 $optlabel .=
'<span class="product_line_stock_ok">';
3521 } elseif ($virtualstock <= 0) {
3522 $optlabel .=
'<span class="product_line_stock_too_low">';
3524 $optlabel .= $virtualstock;
3525 $optlabel .=
'</span>';
3532 $opt =
'<option value="'.$outkey.
'"';
3533 if ($selected && $selected == $objp->idprodfournprice) {
3534 $opt .=
' selected';
3536 if (empty($objp->idprodfournprice) && empty($alsoproductwithnosupplierprice)) {
3537 $opt .=
' disabled';
3539 if (!empty($objp->idprodfournprice) && $objp->idprodfournprice > 0) {
3540 $opt .=
' data-product-id="'.dol_escape_htmltag($objp->rowid).
'"';
3541 $opt .=
' data-price-id="'.dol_escape_htmltag($objp->idprodfournprice).
'"';
3542 $opt .=
' data-qty="'.dol_escape_htmltag($objp->quantity).
'"';
3543 $opt .=
' data-up="'.dol_escape_htmltag($objp->unitprice).
'"';
3544 $opt .=
' data-up-locale="'.dol_escape_htmltag(
price($objp->unitprice)).
'"';
3545 $opt .=
' data-discount="'.dol_escape_htmltag($outdiscount).
'"';
3546 $opt .=
' data-tvatx="'.dol_escape_htmltag($objp->tva_tx).
'"';
3548 $opt .=
' data-description="'.dol_escape_htmltag($objp->description, 0, 1).
'"';
3549 $opt .=
' data-html="'.dol_escape_htmltag($optlabel).
'"';
3553 $outval .= $outvallabel;
3555 $opt .=
"</option>\n";
3563 array(
'key'=>$outkey,
3567 'price_qty_ht'=>
price2num($objp->fprice,
'MU'),
3568 'price_unit_ht'=>
price2num($objp->unitprice,
'MU'),
3569 'price_ht'=>
price2num($objp->unitprice,
'MU'),
3570 'price_qty_ht_locale'=>
price($objp->fprice),
3571 'price_unit_ht_locale'=>
price($objp->unitprice),
3572 'tva_tx'=>$objp->tva_tx,
3573 'default_vat_code'=>$objp->default_vat_code,
3574 'discount'=>$outdiscount,
3576 'duration_value'=>$outdurationvalue,
3577 'duration_unit'=>$outdurationunit,
3578 'disabled'=>(empty($objp->idprodfournprice) ?
true :
false),
3579 'description'=>$objp->description
3593 $out .=
'</select>';
3595 $this->
db->free($result);
3597 include_once DOL_DOCUMENT_ROOT.
'/core/lib/ajax.lib.php';
3600 if (empty($outputmode)) {
3621 global $langs, $conf;
3623 $langs->load(
'stocks');
3625 $sql =
"SELECT p.rowid, p.ref, p.label, p.price, p.duration, pfp.fk_soc,";
3626 $sql .=
" pfp.ref_fourn, pfp.rowid as idprodfournprice, pfp.price as fprice, pfp.remise_percent, pfp.quantity, pfp.unitprice,";
3627 $sql .=
" pfp.fk_supplier_price_expression, pfp.fk_product, pfp.tva_tx, s.nom as name";
3628 $sql .=
" FROM ".$this->db->prefix().
"product as p";
3629 $sql .=
" LEFT JOIN ".$this->db->prefix().
"product_fournisseur_price as pfp ON p.rowid = pfp.fk_product";
3630 $sql .=
" LEFT JOIN ".$this->db->prefix().
"societe as s ON pfp.fk_soc = s.rowid";
3631 $sql .=
" WHERE pfp.entity IN (".getEntity(
'productsupplierprice').
")";
3632 $sql .=
" AND p.tobuy = 1";
3633 $sql .=
" AND s.fournisseur = 1";
3634 $sql .=
" AND p.rowid = ".((int) $productid);
3635 $sql .=
" ORDER BY s.nom, pfp.ref_fourn DESC";
3637 dol_syslog(get_class($this).
"::select_product_fourn_price", LOG_DEBUG);
3638 $result = $this->
db->query($sql);
3641 $num = $this->
db->num_rows($result);
3643 $form =
'<select class="flat" id="select_'.$htmlname.
'" name="'.$htmlname.
'">';
3646 $form .=
'<option value="0">-- '.$langs->trans(
"NoSupplierPriceDefinedForThisProduct").
' --</option>';
3648 require_once DOL_DOCUMENT_ROOT.
'/product/dynamic_price/class/price_parser.class.php';
3649 $form .=
'<option value="0"> </option>';
3653 $objp = $this->
db->fetch_object($result);
3655 $opt =
'<option value="'.$objp->idprodfournprice.
'"';
3657 if ($num == 1 || ($selected_supplier > 0 && $objp->fk_soc == $selected_supplier)) {
3658 $opt .=
' selected';
3660 $opt .=
'>'.$objp->name.
' - '.$objp->ref_fourn.
' - ';
3662 if (!empty($conf->dynamicprices->enabled) && !empty($objp->fk_supplier_price_expression)) {
3664 $prod_supplier->product_fourn_price_id = $objp->idprodfournprice;
3665 $prod_supplier->id = $productid;
3666 $prod_supplier->fourn_qty = $objp->quantity;
3667 $prod_supplier->fourn_tva_tx = $objp->tva_tx;
3668 $prod_supplier->fk_supplier_price_expression = $objp->fk_supplier_price_expression;
3670 $price_result = $priceparser->parseProductSupplier($prod_supplier);
3671 if ($price_result >= 0) {
3672 $objp->fprice = $price_result;
3673 if ($objp->quantity >= 1) {
3674 $objp->unitprice = $objp->fprice / $objp->quantity;
3678 if ($objp->quantity == 1) {
3679 $opt .=
price($objp->fprice * (!empty($conf->global->DISPLAY_DISCOUNTED_SUPPLIER_PRICE) ? (1 - $objp->remise_percent / 100) : 1), 1, $langs, 0, 0, -1, $conf->currency).
"/";
3682 $opt .= $objp->quantity.
' ';
3684 if ($objp->quantity == 1) {
3685 $opt .= $langs->trans(
"Unit");
3687 $opt .= $langs->trans(
"Units");
3689 if ($objp->quantity > 1) {
3691 $opt .=
price($objp->unitprice * (!empty($conf->global->DISPLAY_DISCOUNTED_SUPPLIER_PRICE) ? (1 - $objp->remise_percent / 100) : 1), 1, $langs, 0, 0, -1, $conf->currency).
"/".$langs->trans(
"Unit");
3693 if ($objp->duration) {
3694 $opt .=
" - ".$objp->duration;
3696 $opt .=
"</option>\n";
3703 $form .=
'</select>';
3704 $this->
db->free($result);
3721 public function select_address($selected, $socid, $htmlname =
'address_id', $showempty = 0)
3725 $sql =
"SELECT a.rowid, a.label";
3726 $sql .=
" FROM ".$this->db->prefix().
"societe_address as a";
3727 $sql .=
" WHERE a.fk_soc = ".((int) $socid);
3728 $sql .=
" ORDER BY a.label ASC";
3730 dol_syslog(get_class($this).
"::select_address", LOG_DEBUG);
3733 print
'<select class="flat" id="select_'.$htmlname.
'" name="'.$htmlname.
'">';
3735 print
'<option value="0"> </option>';
3737 $num = $this->
db->num_rows(
$resql);
3741 $obj = $this->
db->fetch_object(
$resql);
3743 if ($selected && $selected == $obj->rowid) {
3744 print
'<option value="'.$obj->rowid.
'" selected>'.$obj->label.
'</option>';
3746 print
'<option value="'.$obj->rowid.
'">'.$obj->label.
'</option>';
3769 $num = count($this->cache_conditions_paiements);
3776 $sql =
"SELECT rowid, code, libelle as label, deposit_percent";
3777 $sql .=
" FROM ".$this->db->prefix().
'c_payment_term';
3778 $sql .=
" WHERE entity IN (".getEntity(
'c_payment_term').
")";
3779 $sql .=
" AND active > 0";
3780 $sql .=
" ORDER BY sortorder";
3784 $num = $this->
db->num_rows(
$resql);
3787 $obj = $this->
db->fetch_object(
$resql);
3790 $label = ($langs->trans(
"PaymentConditionShort".$obj->code) != (
"PaymentConditionShort".$obj->code) ? $langs->trans(
"PaymentConditionShort".$obj->code) : ($obj->label !=
'-' ? $obj->label :
''));
3791 $this->cache_conditions_paiements[$obj->rowid][
'code'] = $obj->code;
3792 $this->cache_conditions_paiements[$obj->rowid][
'label'] = $label;
3793 $this->cache_conditions_paiements[$obj->rowid][
'deposit_percent'] = $obj->deposit_percent;
3817 $num = count($this->cache_availability);
3824 $langs->load(
'propal');
3826 $sql =
"SELECT rowid, code, label, position";
3827 $sql .=
" FROM ".$this->db->prefix().
'c_availability';
3828 $sql .=
" WHERE active > 0";
3832 $num = $this->
db->num_rows(
$resql);
3835 $obj = $this->
db->fetch_object(
$resql);
3838 $label = ($langs->trans(
"AvailabilityType".$obj->code) != (
"AvailabilityType".$obj->code) ? $langs->trans(
"AvailabilityType".$obj->code) : ($obj->label !=
'-' ? $obj->label :
''));
3839 $this->cache_availability[$obj->rowid][
'code'] = $obj->code;
3840 $this->cache_availability[$obj->rowid][
'label'] = $label;
3841 $this->cache_availability[$obj->rowid][
'position'] = $obj->position;
3845 $this->cache_availability =
dol_sort_array($this->cache_availability,
'position',
'asc', 0, 0, 1);
3866 global $langs, $user;
3870 dol_syslog(__METHOD__.
" selected=".$selected.
", htmlname=".$htmlname, LOG_DEBUG);
3872 print
'<select id="'.$htmlname.
'" class="flat'.($morecss ?
' '.$morecss :
'').
'" name="'.$htmlname.
'">';
3874 print
'<option value="0"> </option>';
3876 foreach ($this->cache_availability as $id => $arrayavailability) {
3877 if ($selected == $id) {
3878 print
'<option value="'.$id.
'" selected>';
3880 print
'<option value="'.$id.
'">';
3887 print
info_admin($langs->trans(
"YouCanChangeValuesForThisListFromDictionarySetup"), 1);
3901 $num = count($this->cache_demand_reason);
3906 $sql =
"SELECT rowid, code, label";
3907 $sql .=
" FROM ".$this->db->prefix().
'c_input_reason';
3908 $sql .=
" WHERE active > 0";
3912 $num = $this->
db->num_rows(
$resql);
3914 $tmparray = array();
3916 $obj = $this->
db->fetch_object(
$resql);
3919 $label = ($obj->label !=
'-' ? $obj->label :
'');
3920 if ($langs->trans(
"DemandReasonType".$obj->code) != (
"DemandReasonType".$obj->code)) {
3921 $label = $langs->trans(
"DemandReasonType".$obj->code);
3923 if ($langs->trans($obj->code) != $obj->code) {
3924 $label = $langs->trans($obj->code);
3927 $tmparray[$obj->rowid][
'id'] = $obj->rowid;
3928 $tmparray[$obj->rowid][
'code'] = $obj->code;
3929 $tmparray[$obj->rowid][
'label'] = $label;
3933 $this->cache_demand_reason =
dol_sort_array($tmparray,
'label',
'asc', 0, 0, 1);
3955 public function selectInputReason($selected =
'', $htmlname =
'demandreasonid', $exclude =
'', $addempty = 0, $morecss =
'', $notooltip = 0)
3957 global $langs, $user;
3961 print
'<select class="flat'.($morecss ?
' '.$morecss :
'').
'" id="select_'.$htmlname.
'" name="'.$htmlname.
'">';
3963 print
'<option value="0"'.(empty($selected) ?
' selected' :
'').
'> </option>';
3965 foreach ($this->cache_demand_reason as $id => $arraydemandreason) {
3966 if ($arraydemandreason[
'code'] == $exclude) {
3970 if ($selected && ($selected == $arraydemandreason[
'id'] || $selected == $arraydemandreason[
'code'])) {
3971 print
'<option value="'.$arraydemandreason[
'id'].
'" selected>';
3973 print
'<option value="'.$arraydemandreason[
'id'].
'">';
3975 $label = $arraydemandreason[
'label'];
3976 print $langs->trans($label);
3980 if ($user->admin && empty($notooltip)) {
3981 print
info_admin($langs->trans(
"YouCanChangeValuesForThisListFromDictionarySetup"), 1);
3997 $num = count($this->cache_types_paiements);
4004 $this->cache_types_paiements = array();
4006 $sql =
"SELECT id, code, libelle as label, type, active";
4007 $sql .=
" FROM ".$this->db->prefix().
"c_paiement";
4008 $sql .=
" WHERE entity IN (".getEntity(
'c_paiement').
")";
4012 $num = $this->
db->num_rows(
$resql);
4015 $obj = $this->
db->fetch_object(
$resql);
4018 $label = ($langs->transnoentitiesnoconv(
"PaymentTypeShort".$obj->code) != (
"PaymentTypeShort".$obj->code) ? $langs->transnoentitiesnoconv(
"PaymentTypeShort".$obj->code) : ($obj->label !=
'-' ? $obj->label :
''));
4019 $this->cache_types_paiements[$obj->id][
'id'] = $obj->id;
4020 $this->cache_types_paiements[$obj->id][
'code'] = $obj->code;
4021 $this->cache_types_paiements[$obj->id][
'label'] = $label;
4022 $this->cache_types_paiements[$obj->id][
'type'] = $obj->type;
4023 $this->cache_types_paiements[$obj->id][
'active'] = $obj->active;
4027 $this->cache_types_paiements =
dol_sort_array($this->cache_types_paiements,
'label',
'asc', 0, 0, 1);
4054 public function select_conditions_paiements($selected = 0, $htmlname =
'condid', $filtertype = -1, $addempty = 0, $noinfoadmin = 0, $morecss =
'', $deposit_percent = -1)
4077 public function getSelectConditionsPaiements($selected = 0, $htmlname =
'condid', $filtertype = -1, $addempty = 0, $noinfoadmin = 0, $morecss =
'', $deposit_percent = -1)
4079 global $langs, $user, $conf;
4082 dol_syslog(__METHOD__.
" selected=".$selected.
", htmlname=".$htmlname, LOG_DEBUG);
4087 if (empty($selected) && !empty($conf->global->MAIN_DEFAULT_PAYMENT_TERM_ID)) {
4088 $selected = $conf->global->MAIN_DEFAULT_PAYMENT_TERM_ID;
4091 $out.=
'<select id="'.$htmlname.
'" class="flat selectpaymentterms'.($morecss ?
' '.$morecss :
'').
'" name="'.$htmlname.
'">';
4093 $out.=
'<option value="0"> </option>';
4096 $selectedDepositPercent =
null;
4098 foreach ($this->cache_conditions_paiements as $id => $arrayconditions) {
4099 if ($filtertype <= 0 && ! empty($arrayconditions[
'deposit_percent'])) {
4103 if ($selected == $id) {
4104 $selectedDepositPercent = $deposit_percent > 0 ? $deposit_percent : $arrayconditions[
'deposit_percent'];
4105 $out .=
'<option value="'.$id.
'" data-deposit_percent="' . $arrayconditions[
'deposit_percent'] .
'" selected>';
4107 $out .=
'<option value="'.$id.
'" data-deposit_percent="' . $arrayconditions[
'deposit_percent'] .
'">';
4109 $label = $arrayconditions[
'label'];
4111 if (! empty($arrayconditions[
'deposit_percent'])) {
4112 $label = str_replace(
'__DEPOSIT_PERCENT__', $deposit_percent > 0 ? $deposit_percent : $arrayconditions[
'deposit_percent'], $label);
4119 if ($user->admin && empty($noinfoadmin)) {
4120 $out.=
info_admin($langs->trans(
"YouCanChangeValuesForThisListFromDictionarySetup"), 1);
4124 if ($deposit_percent >= 0) {
4125 $out .=
' <span id="'.$htmlname.
'_deposit_percent_container"' . (empty($selectedDepositPercent) ?
' style="display: none"' :
'') .
'>';
4126 $out .= $langs->trans(
'DepositPercent') .
' : ';
4127 $out .=
'<input id="'.$htmlname.
'_deposit_percent" name="'.$htmlname.
'_deposit_percent" class="maxwidth50" value="' . strval($deposit_percent) .
'" />';
4131 $(document).ready(function () {
4132 $("#' . $htmlname .
'").change(function () {
4133 let $selected = $(this).find("option:selected");
4134 let depositPercent = $selected.attr("data-deposit_percent");
4136 if (depositPercent.length > 0) {
4137 $("#'.$htmlname.
'_deposit_percent_container").show().find("#'.$htmlname.
'_deposit_percent").val(depositPercent);
4139 $("#'.$htmlname.
'_deposit_percent_container").hide();
4169 public function select_types_paiements($selected =
'', $htmlname =
'paiementtype', $filtertype =
'', $format = 0, $empty = 1, $noadmininfo = 0, $maxlength = 0, $active = 1, $morecss =
'', $nooutput = 0)
4172 global $langs, $user, $conf;
4176 dol_syslog(__METHOD__.
" ".$selected.
", ".$htmlname.
", ".$filtertype.
", ".$format, LOG_DEBUG);
4178 $filterarray = array();
4179 if ($filtertype ==
'CRDT') {
4180 $filterarray = array(0, 2, 3);
4181 } elseif ($filtertype ==
'DBIT') {
4182 $filterarray = array(1, 2, 3);
4183 } elseif ($filtertype !=
'' && $filtertype !=
'-1') {
4184 $filterarray = explode(
',', $filtertype);
4190 if (empty($selected) && !empty($conf->global->MAIN_DEFAULT_PAYMENT_TYPE_ID)) {
4191 $selected = $conf->global->MAIN_DEFAULT_PAYMENT_TYPE_ID;
4194 $out .=
'<select id="select'.$htmlname.
'" class="flat selectpaymenttypes'.($morecss ?
' '.$morecss :
'').
'" name="'.$htmlname.
'">';
4196 $out .=
'<option value=""> </option>';
4198 foreach ($this->cache_types_paiements as $id => $arraytypes) {
4200 if ($active >= 0 && $arraytypes[
'active'] != $active) {
4205 if (count($filterarray) && !in_array($arraytypes[
'type'], $filterarray)) {
4210 if ($empty && empty($arraytypes[
'code'])) {
4215 $out .=
'<option value="'.$id.
'"';
4216 } elseif ($format == 1) {
4217 $out .=
'<option value="'.$arraytypes[
'code'].
'"';
4218 } elseif ($format == 2) {
4219 $out .=
'<option value="'.$arraytypes[
'code'].
'"';
4220 } elseif ($format == 3) {
4221 $out .=
'<option value="'.$id.
'"';
4224 if ($format == 1 || $format == 2) {
4225 if ($selected == $arraytypes[
'code']) {
4226 $out .=
' selected';
4229 if ($selected == $id) {
4230 $out .=
' selected';
4236 $value = ($maxlength ?
dol_trunc($arraytypes[
'label'], $maxlength) : $arraytypes[
'label']);
4237 } elseif ($format == 1) {
4238 $value = $arraytypes[
'code'];
4239 } elseif ($format == 2) {
4240 $value = ($maxlength ?
dol_trunc($arraytypes[
'label'], $maxlength) : $arraytypes[
'label']);
4241 } elseif ($format == 3) {
4242 $value = $arraytypes[
'code'];
4244 $out .= $value ? $value :
' ';
4245 $out .=
'</option>';
4247 $out .=
'</select>';
4248 if ($user->admin && !$noadmininfo) {
4249 $out .=
info_admin($langs->trans(
"YouCanChangeValuesForThisListFromDictionarySetup"), 1);
4253 if (empty($nooutput)) {
4273 $return =
'<select class="flat maxwidth100" id="select_'.$htmlname.
'" name="'.$htmlname.
'">';
4275 'HT'=>$langs->trans(
"HT"),
4276 'TTC'=>$langs->trans(
"TTC")
4278 foreach ($options as $id => $value) {
4279 if ($selected == $id) {
4280 $return .=
'<option value="'.$id.
'" selected>'.$value;
4282 $return .=
'<option value="'.$id.
'">'.$value;
4284 $return .=
'</option>';
4286 $return .=
'</select>';
4305 $num = count($this->cache_transport_mode);
4312 $this->cache_transport_mode = array();
4314 $sql =
"SELECT rowid, code, label, active";
4315 $sql .=
" FROM ".$this->db->prefix().
"c_transport_mode";
4316 $sql .=
" WHERE entity IN (".getEntity(
'c_transport_mode').
")";
4320 $num = $this->
db->num_rows(
$resql);
4323 $obj = $this->
db->fetch_object(
$resql);
4326 $label = ($langs->transnoentitiesnoconv(
"PaymentTypeShort".$obj->code) != (
"PaymentTypeShort".$obj->code) ? $langs->transnoentitiesnoconv(
"PaymentTypeShort".$obj->code) : ($obj->label !=
'-' ? $obj->label :
''));
4327 $this->cache_transport_mode[$obj->rowid][
'rowid'] = $obj->rowid;
4328 $this->cache_transport_mode[$obj->rowid][
'code'] = $obj->code;
4329 $this->cache_transport_mode[$obj->rowid][
'label'] = $label;
4330 $this->cache_transport_mode[$obj->rowid][
'active'] = $obj->active;
4334 $this->cache_transport_mode =
dol_sort_array($this->cache_transport_mode,
'label',
'asc', 0, 0, 1);
4356 public function selectTransportMode($selected =
'', $htmlname =
'transportmode', $format = 0, $empty = 1, $noadmininfo = 0, $maxlength = 0, $active = 1, $morecss =
'')
4358 global $langs, $user;
4360 dol_syslog(__METHOD__.
" ".$selected.
", ".$htmlname.
", ".$format, LOG_DEBUG);
4364 print
'<select id="select'.$htmlname.
'" class="flat selectmodetransport'.($morecss ?
' '.$morecss :
'').
'" name="'.$htmlname.
'">';
4366 print
'<option value=""> </option>';
4368 foreach ($this->cache_transport_mode as $id => $arraytypes) {
4370 if ($active >= 0 && $arraytypes[
'active'] != $active) {
4375 if ($empty && empty($arraytypes[
'code'])) {
4380 print
'<option value="'.$id.
'"';
4381 } elseif ($format == 1) {
4382 print
'<option value="'.$arraytypes[
'code'].
'"';
4383 } elseif ($format == 2) {
4384 print
'<option value="'.$arraytypes[
'code'].
'"';
4385 } elseif ($format == 3) {
4386 print
'<option value="'.$id.
'"';
4389 if (preg_match(
'/[a-z]/i', $selected) && $selected == $arraytypes[
'code']) {
4391 } elseif ($selected == $id) {
4397 $value = ($maxlength ?
dol_trunc($arraytypes[
'label'], $maxlength) : $arraytypes[
'label']);
4398 } elseif ($format == 1) {
4399 $value = $arraytypes[
'code'];
4400 } elseif ($format == 2) {
4401 $value = ($maxlength ?
dol_trunc($arraytypes[
'label'], $maxlength) : $arraytypes[
'label']);
4402 } elseif ($format == 3) {
4403 $value = $arraytypes[
'code'];
4405 print $value ? $value :
' ';
4409 if ($user->admin && !$noadmininfo) {
4410 print
info_admin($langs->trans(
"YouCanChangeValuesForThisListFromDictionarySetup"), 1);
4426 public function selectShippingMethod($selected =
'', $htmlname =
'shipping_method_id', $filtre =
'', $useempty = 0, $moreattrib =
'', $noinfoadmin = 0, $morecss =
'')
4428 global $langs, $conf, $user;
4430 $langs->load(
"admin");
4431 $langs->load(
"deliveries");
4433 $sql =
"SELECT rowid, code, libelle as label";
4434 $sql .=
" FROM ".$this->db->prefix().
"c_shipment_mode";
4435 $sql .=
" WHERE active > 0";
4437 $sql .=
" AND ".$filtre;
4439 $sql .=
" ORDER BY libelle ASC";
4441 dol_syslog(get_class($this).
"::selectShippingMode", LOG_DEBUG);
4442 $result = $this->
db->query($sql);
4444 $num = $this->
db->num_rows($result);
4447 print
'<select id="select'.$htmlname.
'" class="flat selectshippingmethod'.($morecss ?
' '.$morecss :
'').
'" name="'.$htmlname.
'"'.($moreattrib ?
' '.$moreattrib :
'').
'>';
4448 if ($useempty == 1 || ($useempty == 2 && $num > 1)) {
4449 print
'<option value="-1"> </option>';
4452 $obj = $this->
db->fetch_object($result);
4453 if ($selected == $obj->rowid) {
4454 print
'<option value="'.$obj->rowid.
'" selected>';
4456 print
'<option value="'.$obj->rowid.
'">';
4458 print ($langs->trans(
"SendingMethod".strtoupper($obj->code)) !=
"SendingMethod".strtoupper($obj->code)) ? $langs->trans(
"SendingMethod".strtoupper($obj->code)) : $obj->label;
4463 if ($user->admin && empty($noinfoadmin)) {
4464 print
info_admin($langs->trans(
"YouCanChangeValuesForThisListFromDictionarySetup"), 1);
4469 print $langs->trans(
"NoShippingMethodDefined");
4489 $langs->load(
"deliveries");
4491 if ($htmlname !=
"none") {
4492 print
'<form method="POST" action="'.$page.
'">';
4493 print
'<input type="hidden" name="action" value="setshippingmethod">';
4494 print
'<input type="hidden" name="token" value="'.newToken().
'">';
4496 print
'<input type="submit" class="button valignmiddle" value="'.$langs->trans(
"Modify").
'">';
4500 $code = $langs->getLabelFromKey($this->
db, $selected,
'c_shipment_mode',
'rowid',
'code');
4501 print $langs->trans(
"SendingMethod".strtoupper($code));
4520 $langs->load(
'bills');
4522 $opt =
'<option value="" selected></option>';
4523 $sql =
"SELECT rowid, ref, situation_cycle_ref, situation_counter, situation_final, fk_soc";
4524 $sql .=
' FROM '.$this->db->prefix().
'facture';
4525 $sql .=
' WHERE entity IN ('.getEntity(
'invoice').
')';
4526 $sql .=
' AND situation_counter >= 1';
4527 $sql .=
' AND fk_soc = '.(int) $socid;
4528 $sql .=
' AND type <> 2';
4529 $sql .=
' ORDER by situation_cycle_ref, situation_counter desc';
4535 while ($obj = $this->
db->fetch_object(
$resql)) {
4537 if ($obj->situation_cycle_ref != $ref) {
4539 $ref = $obj->situation_cycle_ref;
4541 if ($obj->situation_final != 1) {
4543 if (substr($obj->ref, 1, 4) !=
'PROV') {
4544 if ($selected == $obj->rowid) {
4545 $opt .=
'<option value="'.$obj->rowid.
'" selected>'.$obj->ref.
'</option>';
4547 $opt .=
'<option value="'.$obj->rowid.
'">'.$obj->ref.
'</option>';
4554 dol_syslog(
"Error sql=".$sql.
", error=".$this->error, LOG_ERR);
4556 if ($opt ==
'<option value ="" selected></option>') {
4557 $opt =
'<option value ="0" selected>'.$langs->trans(
'NoSituations').
'</option>';
4571 public function selectUnits($selected =
'', $htmlname =
'units', $showempty = 0, $unit_type =
'')
4575 $langs->load(
'products');
4577 $return =
'<select class="flat" id="'.$htmlname.
'" name="'.$htmlname.
'">';
4579 $sql =
"SELECT rowid, label, code FROM ".$this->db->prefix().
"c_units";
4580 $sql .=
' WHERE active > 0';
4581 if (!empty($unit_type)) {
4582 $sql .=
" AND unit_type = '".$this->db->escape($unit_type).
"'";
4584 $sql .=
" ORDER BY sortorder";
4589 $return .=
'<option value="none"></option>';
4592 while ($res = $this->
db->fetch_object(
$resql)) {
4593 $unitLabel = $res->label;
4594 if (!empty($langs->tab_translate[
'unit'.$res->code])) {
4595 $unitLabel = $langs->trans(
'unit'.$res->code) != $res->label ? $langs->trans(
'unit'.$res->code) : $res->label;
4598 if ($selected == $res->rowid) {
4599 $return .=
'<option value="'.$res->rowid.
'" selected>'.$unitLabel.
'</option>';
4601 $return .=
'<option value="'.$res->rowid.
'">'.$unitLabel.
'</option>';
4604 $return .=
'</select>';
4624 public function select_comptes($selected =
'', $htmlname =
'accountid', $status = 0, $filtre =
'', $useempty = 0, $moreattrib =
'', $showcurrency = 0, $morecss =
'', $nooutput = 0)
4627 global $langs, $conf;
4631 $langs->load(
"admin");
4634 $sql =
"SELECT rowid, label, bank, clos as status, currency_code";
4635 $sql .=
" FROM ".$this->db->prefix().
"bank_account";
4636 $sql .=
" WHERE entity IN (".getEntity(
'bank_account').
")";
4638 $sql .=
" AND clos = ".(int) $status;
4641 $sql .=
" AND ".$filtre;
4643 $sql .=
" ORDER BY label";
4645 dol_syslog(get_class($this).
"::select_comptes", LOG_DEBUG);
4646 $result = $this->
db->query($sql);
4648 $num = $this->
db->num_rows($result);
4651 $out .=
'<select id="select'.$htmlname.
'" class="flat selectbankaccount'.($morecss ?
' '.$morecss :
'').
'" name="'.$htmlname.
'"'.($moreattrib ?
' '.$moreattrib :
'').
'>';
4652 if ($useempty == 1 || ($useempty == 2 && $num > 1)) {
4653 $out .=
'<option value="-1"> </option>';
4657 $obj = $this->
db->fetch_object($result);
4658 if ($selected == $obj->rowid || ($useempty == 2 && $num == 1 && empty($selected))) {
4659 $out .=
'<option value="'.$obj->rowid.
'" data-currency-code="'.$obj->currency_code.
'" selected>';
4661 $out .=
'<option value="'.$obj->rowid.
'" data-currency-code="'.$obj->currency_code.
'">';
4663 $out .= trim($obj->label);
4664 if ($showcurrency) {
4665 $out .=
' ('.$obj->currency_code.
')';
4667 if ($status == 2 && $obj->status == 1) {
4668 $out .=
' ('.$langs->trans(
"Closed").
')';
4670 $out .=
'</option>';
4673 $out .=
"</select>";
4677 $out .=
'<span class="opacitymedium">'.$langs->trans(
"NoActiveBankAccountDefined").
'</span>';
4679 $out .=
'<span class="opacitymedium">'.$langs->trans(
"NoBankAccountFound").
'</span>';
4687 if (empty($nooutput)) {
4707 public function selectEstablishments($selected =
'', $htmlname =
'entity', $status = 0, $filtre =
'', $useempty = 0, $moreattrib =
'')
4709 global $langs, $conf;
4711 $langs->load(
"admin");
4714 $sql =
"SELECT rowid, name, fk_country, status, entity";
4715 $sql .=
" FROM ".$this->db->prefix().
"establishment";
4716 $sql .=
" WHERE 1=1";
4718 $sql .=
" AND status = ".(int) $status;
4721 $sql .=
" AND ".$filtre;
4723 $sql .=
" ORDER BY name";
4725 dol_syslog(get_class($this).
"::select_establishment", LOG_DEBUG);
4726 $result = $this->
db->query($sql);
4728 $num = $this->
db->num_rows($result);
4731 print
'<select id="select'.$htmlname.
'" class="flat selectestablishment" name="'.$htmlname.
'"'.($moreattrib ?
' '.$moreattrib :
'').
'>';
4732 if ($useempty == 1 || ($useempty == 2 && $num > 1)) {
4733 print
'<option value="-1"> </option>';
4737 $obj = $this->
db->fetch_object($result);
4738 if ($selected == $obj->rowid) {
4739 print
'<option value="'.$obj->rowid.
'" selected>';
4741 print
'<option value="'.$obj->rowid.
'">';
4743 print trim($obj->name);
4744 if ($status == 2 && $obj->status == 1) {
4745 print
' ('.$langs->trans(
"Closed").
')';
4753 print
'<span class="opacitymedium">'.$langs->trans(
"NoActiveEstablishmentDefined").
'</span>';
4755 print
'<span class="opacitymedium">'.$langs->trans(
"NoEstablishmentFound").
'</span>';
4775 if ($htmlname !=
"none") {
4776 print
'<form method="POST" action="'.$page.
'">';
4777 print
'<input type="hidden" name="action" value="setbankaccount">';
4778 print
'<input type="hidden" name="token" value="'.newToken().
'">';
4779 print
img_picto(
'',
'bank_account',
'class="pictofixedwidth"');
4780 $nbaccountfound = $this->
select_comptes($selected, $htmlname, 0,
'', $addempty);
4781 if ($nbaccountfound > 0) {
4782 print
'<input type="submit" class="button smallpaddingimp valignmiddle" value="'.$langs->trans(
"Modify").
'">';
4786 $langs->load(
'banks');
4789 require_once DOL_DOCUMENT_ROOT.
'/compta/bank/class/account.class.php';
4791 $result = $bankstatic->fetch($selected);
4793 print $bankstatic->getNomUrl(1);
4820 public function select_all_categories($type, $selected =
'', $htmlname =
"parent", $maxlength = 64, $markafterid = 0, $outputmode = 0, $include = 0, $morecss =
'')
4823 global $conf, $langs;
4824 $langs->load(
"categories");
4826 include_once DOL_DOCUMENT_ROOT.
'/categories/class/categorie.class.php';
4829 if (is_numeric($type)) {
4830 dol_syslog(__METHOD__.
': using numeric value for parameter type is deprecated. Use string code instead.', LOG_WARNING);
4833 if ($type === Categorie::TYPE_BANK_LINE) {
4835 $cate_arbo = array();
4836 $sql =
"SELECT c.label, c.rowid";
4837 $sql .=
" FROM ".$this->db->prefix().
"bank_categ as c";
4838 $sql .=
" WHERE entity = ".$conf->entity;
4839 $sql .=
" ORDER BY c.label";
4840 $result = $this->
db->query($sql);
4842 $num = $this->
db->num_rows($result);
4845 $objp = $this->
db->fetch_object($result);
4847 $cate_arbo[$objp->rowid] = array(
'id'=>$objp->rowid,
'fulllabel'=>$objp->label);
4851 $this->
db->free($result);
4857 $cate_arbo = $cat->get_full_arbo($type, $markafterid, $include);
4860 $output =
'<select class="flat'.($morecss ?
' '.$morecss :
'').
'" name="'.$htmlname.
'" id="'.$htmlname.
'">';
4861 $outarray = array();
4862 if (is_array($cate_arbo)) {
4863 if (!count($cate_arbo)) {
4864 $output .=
'<option value="-1" disabled>'.$langs->trans(
"NoCategoriesDefined").
'</option>';
4866 $output .=
'<option value="-1"> </option>';
4867 foreach ($cate_arbo as $key => $value) {
4868 if ($cate_arbo[$key][
'id'] == $selected || ($selected ===
'auto' && count($cate_arbo) == 1)) {
4873 $output .=
'<option '.$add.
'value="'.$cate_arbo[$key][
'id'].
'">'.
dol_trunc($cate_arbo[$key][
'fulllabel'], $maxlength,
'middle').
'</option>';
4875 $outarray[$cate_arbo[$key][
'id']] = $cate_arbo[$key][
'fulllabel'];
4879 $output .=
'</select>';
4905 public function form_confirm($page, $title, $question, $action, $formquestion =
'', $selectedchoice =
"", $useajax = 0, $height = 170, $width = 500)
4908 dol_syslog(__METHOD__.
': using form_confirm is deprecated. Use formconfim instead.', LOG_WARNING);
4909 print $this->
formconfirm($page, $title, $question, $action, $formquestion, $selectedchoice, $useajax, $height, $width);
4938 public function formconfirm($page, $title, $question, $action, $formquestion =
'', $selectedchoice =
'', $useajax = 0, $height = 0, $width = 500, $disableformtag = 0, $labelbuttonyes =
'Yes', $labelbuttonno =
'No')
4940 global $langs, $conf;
4942 $more =
'<!-- formconfirm before calling page='.dol_escape_htmltag($page).
' -->';
4948 $newselectedchoice = empty($selectedchoice) ?
"no" : $selectedchoice;
4949 if ($conf->browser->layout ==
'phone') {
4954 if (empty($height)) {
4956 if (is_array($formquestion) && count($formquestion) > 2) {
4957 $height += ((count($formquestion) - 2) * 24);
4961 if (is_array($formquestion) && !empty($formquestion)) {
4963 foreach ($formquestion as $key => $input) {
4964 if (is_array($input) && !empty($input)) {
4965 if ($input[
'type'] ==
'hidden') {
4966 $moreattr = (!empty($input[
'moreattr']) ?
' '.$input[
'moreattr'] :
'');
4967 $morecss = (!empty($input[
'morecss']) ?
' '.$input[
'morecss'] :
'');
4969 $more .=
'<input type="hidden" id="'.dol_escape_htmltag($input[
'name']).
'" name="'.
dol_escape_htmltag($input[
'name']).
'" value="'.
dol_escape_htmltag($input[
'value']).
'" class="'.$morecss.
'"'.$moreattr.
'>'.
"\n";
4975 $moreonecolumn =
'';
4976 $more .=
'<div class="tagtable paddingtopbottomonly centpercent noborderspacing">'.
"\n";
4977 foreach ($formquestion as $key => $input) {
4978 if (is_array($input) && !empty($input)) {
4979 $size = (!empty($input[
'size']) ?
' size="'.$input[
'size'].
'"' :
'');
4980 $moreattr = (!empty($input[
'moreattr']) ?
' '.$input[
'moreattr'] :
'');
4981 $morecss = (!empty($input[
'morecss']) ?
' '.$input[
'morecss'] :
'');
4983 if ($input[
'type'] ==
'text') {
4984 $more .=
'<div class="tagtr"><div class="tagtd'.(empty($input[
'tdclass']) ?
'' : (
' '.$input[
'tdclass'])).
'">'.$input[
'label'].
'</div><div class="tagtd"><input type="text" class="flat'.$morecss.
'" id="'.
dol_escape_htmltag($input[
'name']).
'" name="'.
dol_escape_htmltag($input[
'name']).
'"'.$size.
' value="'.$input[
'value'].
'"'.$moreattr.
' /></div></div>'.
"\n";
4985 } elseif ($input[
'type'] ==
'password') {
4986 $more .=
'<div class="tagtr"><div class="tagtd'.(empty($input[
'tdclass']) ?
'' : (
' '.$input[
'tdclass'])).
'">'.$input[
'label'].
'</div><div class="tagtd"><input type="password" class="flat'.$morecss.
'" id="'.
dol_escape_htmltag($input[
'name']).
'" name="'.
dol_escape_htmltag($input[
'name']).
'"'.$size.
' value="'.$input[
'value'].
'"'.$moreattr.
' /></div></div>'.
"\n";
4987 } elseif ($input[
'type'] ==
'textarea') {
4993 $moreonecolumn .=
'<div class="margintoponly">';
4994 $moreonecolumn .= $input[
'label'].
'<br>';
4995 $moreonecolumn .=
'<textarea name="'.dol_escape_htmltag($input[
'name']).
'" id="'.
dol_escape_htmltag($input[
'name']).
'" class="'.$morecss.
'"'.$moreattr.
'>';
4996 $moreonecolumn .= $input[
'value'];
4997 $moreonecolumn .=
'</textarea>';
4998 $moreonecolumn .=
'</div>';
4999 } elseif ($input[
'type'] ==
'select') {
5000 if (empty($morecss)) {
5001 $morecss =
'minwidth100';
5004 $show_empty = isset($input[
'select_show_empty']) ? $input[
'select_show_empty'] : 1;
5005 $key_in_label = isset($input[
'select_key_in_label']) ? $input[
'select_key_in_label'] : 0;
5006 $value_as_key = isset($input[
'select_value_as_key']) ? $input[
'select_value_as_key'] : 0;
5007 $translate = isset($input[
'select_translate']) ? $input[
'select_translate'] : 0;
5008 $maxlen = isset($input[
'select_maxlen']) ? $input[
'select_maxlen'] : 0;
5009 $disabled = isset($input[
'select_disabled']) ? $input[
'select_disabled'] : 0;
5010 $sort = isset($input[
'select_sort']) ? $input[
'select_sort'] :
'';
5012 $more .=
'<div class="tagtr"><div class="tagtd'.(empty($input[
'tdclass']) ?
'' : (
' '.$input[
'tdclass'])).
'">';
5013 if (!empty($input[
'label'])) {
5014 $more .= $input[
'label'].
'</div><div class="tagtd left">';
5016 $more .= $this->
selectarray($input[
'name'], $input[
'values'], isset($input[
'default'])?$input[
'default']:
'', $show_empty, $key_in_label, $value_as_key, $moreattr, $translate, $maxlen, $disabled, $sort, $morecss);
5017 $more .=
'</div></div>'.
"\n";
5018 } elseif ($input[
'type'] ==
'checkbox') {
5019 $more .=
'<div class="tagtr">';
5020 $more .=
'<div class="tagtd'.(empty($input[
'tdclass']) ?
'' : (
' '.$input[
'tdclass'])).
'">'.$input[
'label'].
' </div><div class="tagtd">';
5022 if (!is_bool($input[
'value']) && $input[
'value'] !=
'false' && $input[
'value'] !=
'0' && $input[
'value'] !=
'') {
5023 $more .=
' checked';
5025 if (is_bool($input[
'value']) && $input[
'value']) {
5026 $more .=
' checked';
5028 if (isset($input[
'disabled'])) {
5029 $more .=
' disabled';
5031 $more .=
' /></div>';
5032 $more .=
'</div>'.
"\n";
5033 } elseif ($input[
'type'] ==
'radio') {
5035 foreach ($input[
'values'] as $selkey => $selval) {
5036 $more .=
'<div class="tagtr">';
5038 $more .=
'<div class="tagtd'.(empty($input[
'tdclass']) ?
' tdtop' : (
' tdtop '.$input[
'tdclass'])).
'">'.$input[
'label'].
'</div>';
5040 $more .=
'<div clas="tagtd'.(empty($input[
'tdclass']) ?
'' : (
' "'.$input[
'tdclass'])).
'"> </div>';
5042 $more .=
'<div class="tagtd'.($i == 0 ?
' tdtop' :
'').
'"><input type="radio" class="flat'.$morecss.
'" id="'.
dol_escape_htmltag($input[
'name'].$selkey).
'" name="'.
dol_escape_htmltag($input[
'name']).
'" value="'.$selkey.
'"'.$moreattr;
5043 if (!empty($input[
'disabled'])) {
5044 $more .=
' disabled';
5046 if (isset($input[
'default']) && $input[
'default'] === $selkey) {
5047 $more .=
' checked="checked"';
5050 $more .=
'<label for="'.dol_escape_htmltag($input[
'name'].$selkey).
'" class="valignmiddle">'.$selval.
'</label>';
5051 $more .=
'</div></div>'.
"\n";
5054 } elseif ($input[
'type'] ==
'date') {
5055 $more .=
'<div class="tagtr"><div class="tagtd'.(empty($input[
'tdclass']) ?
'' : (
' '.$input[
'tdclass'])).
'">'.$input[
'label'].
'</div>';
5056 $more .=
'<div class="tagtd">';
5057 $addnowlink = (empty($input[
'datenow']) ? 0 : 1);
5058 $more .= $this->
selectDate($input[
'value'], $input[
'name'], 0, 0, 0,
'', 1, $addnowlink);
5059 $more .=
'</div></div>'.
"\n";
5060 $formquestion[] = array(
'name'=>$input[
'name'].
'day');
5061 $formquestion[] = array(
'name'=>$input[
'name'].
'month');
5062 $formquestion[] = array(
'name'=>$input[
'name'].
'year');
5063 $formquestion[] = array(
'name'=>$input[
'name'].
'hour');
5064 $formquestion[] = array(
'name'=>$input[
'name'].
'min');
5065 } elseif ($input[
'type'] ==
'other') {
5066 $more .=
'<div class="tagtr"><div class="tagtd'.(empty($input[
'tdclass']) ?
'' : (
' '.$input[
'tdclass'])).
'">';
5067 if (!empty($input[
'label'])) {
5068 $more .= $input[
'label'].
'</div><div class="tagtd">';
5070 $more .= $input[
'value'];
5071 $more .=
'</div></div>'.
"\n";
5072 } elseif ($input[
'type'] ==
'onecolumn') {
5073 $moreonecolumn .=
'<div class="margintoponly">';
5074 $moreonecolumn .= $input[
'value'];
5075 $moreonecolumn .=
'</div>'.
"\n";
5076 } elseif ($input[
'type'] ==
'hidden') {
5078 } elseif ($input[
'type'] ==
'separator') {
5081 $more .=
'Error type '.$input[
'type'].
' for the confirm box is not a supported type';
5085 $more .=
'</div>'.
"\n";
5086 $more .= $moreonecolumn;
5092 if (!empty($conf->dol_use_jmobile)) {
5095 if (empty($conf->use_javascript_ajax)) {
5101 $dialogconfirm =
'dialog-confirm';
5103 if (!is_numeric($useajax)) {
5107 $dialogconfirm .=
'-'.$button;
5109 $pageyes = $page.(preg_match(
'/\?/', $page) ?
'&' :
'?').
'action='.urlencode($action).
'&confirm=yes';
5110 $pageno = ($useajax == 2 ? $page.(preg_match(
'/\?/', $page) ?
'&' :
'?').
'action='.urlencode($action).
'&confirm=no' :
'');
5113 if (is_array($formquestion)) {
5114 foreach ($formquestion as $key => $input) {
5117 if (is_array($input) && isset($input[
'name'])) {
5118 if (strpos($input[
'name'],
',') > 0) {
5119 $inputok = array_merge($inputok, explode(
',', $input[
'name']));
5121 array_push($inputok, $input[
'name']);
5125 if (isset($input[
'inputko']) && $input[
'inputko'] == 1) {
5126 array_push($inputko, $input[
'name']);
5133 if (is_array($formquestion) && !empty($formquestion[
'text'])) {
5134 $formconfirm .=
'<div class="confirmtext">'.$formquestion[
'text'].
'</div>'.
"\n";
5136 if (!empty($more)) {
5137 $formconfirm .=
'<div class="confirmquestions">'.$more.
'</div>'.
"\n";
5139 $formconfirm .= ($question ?
'<div class="confirmmessage">'.img_help(
'',
'').
' '.$question.
'</div>' :
'');
5142 $formconfirm .=
"\n<!-- begin code of popup for formconfirm page=".$page.
" -->\n";
5143 $formconfirm .=
'<script type="text/javascript">'.
"\n";
5144 $formconfirm .=
"/* Code for the jQuery('#dialogforpopup').dialog() */\n";
5147 $( "#'.$dialogconfirm.
'" ).dialog(
5149 autoOpen: '.($autoOpen ?
"true" :
"false").
',';
5150 if ($newselectedchoice ==
'no') {
5153 $(this).parent().find("button.ui-button:eq(2)").focus();
5158 if (empty($useajax)) {
5159 $jsforcursor =
'// The call to urljump can be slow, so we set the wait cursor'.
"\n";
5160 $jsforcursor .=
'jQuery("html,body,#id-container").addClass("cursorwait");'.
"\n";
5165 height: "'.$height.
'",
5166 width: "'.$width.
'",
5168 closeOnEscape: false,
5170 "'.
dol_escape_js($langs->transnoentities($labelbuttonyes)).
'": function() {
5171 var options = "&token='.urlencode(
newToken()).
'";
5172 var inputok = '.json_encode($inputok).
'; /* List of fields into form */
5173 var pageyes = "'.
dol_escape_js(!empty($pageyes) ? $pageyes :
'').
'";
5175 if (inputok.length > 0) {
5176 $.each(inputok, function(i, inputname) {
5179 if ($("input[name=\'" + inputname + "\']").attr("type") == "radio") {
5180 inputvalue = $("input[name=\'" + inputname + "\']:checked").val();
5182 if ($("#" + inputname).attr("type") == "checkbox") { more = ":checked"; }
5183 inputvalue = $("#" + inputname + more).val();
5185 if (typeof inputvalue == "undefined") { inputvalue=""; }
5186 console.log("formconfirm check inputname="+inputname+" inputvalue="+inputvalue);
5187 options += "&" + inputname + "=" + encodeURIComponent(inputvalue);
5190 var urljump = pageyes + (pageyes.indexOf("?") < 0 ? "?" : "") + options;
5191 if (pageyes.length > 0) {
5193 location.href = urljump;
5194 console.log("after location.href");
5196 $(this).dialog("close");
5198 "'.
dol_escape_js($langs->transnoentities($labelbuttonno)).
'": function() {
5199 var options = "&token='.urlencode(
newToken()).
'";
5200 var inputko = '.json_encode($inputko).
'; /* List of fields into form */
5201 var pageno="'.
dol_escape_js(!empty($pageno) ? $pageno :
'').
'";
5202 if (inputko.length > 0) {
5203 $.each(inputko, function(i, inputname) {
5205 if ($("#" + inputname).attr("type") == "checkbox") { more = ":checked"; }
5206 var inputvalue = $("#" + inputname + more).val();
5207 if (typeof inputvalue == "undefined") { inputvalue=""; }
5208 options += "&" + inputname + "=" + encodeURIComponent(inputvalue);
5211 var urljump=pageno + (pageno.indexOf("?") < 0 ? "?" : "") + options;
5213 if (pageno.length > 0) {
5215 location.href = urljump;
5216 console.log("after location.href");
5218 $(this).dialog("close");
5224 var button = "'.$button.
'";
5225 if (button.length > 0) {
5226 $( "#" + button ).click(function() {
5227 $("#'.$dialogconfirm.
'").dialog("open");
5235 $formconfirm .=
"\n<!-- begin formconfirm page=".dol_escape_htmltag($page).
" -->\n";
5237 if (empty($disableformtag)) {
5238 $formconfirm .=
'<form method="POST" action="'.$page.
'" class="notoptoleftroright">'.
"\n";
5241 $formconfirm .=
'<input type="hidden" name="action" value="'.$action.
'">'.
"\n";
5242 $formconfirm .=
'<input type="hidden" name="token" value="'.newToken().
'">'.
"\n";
5244 $formconfirm .=
'<table class="valid centpercent">'.
"\n";
5247 $formconfirm .=
'<tr class="validtitre"><td class="validtitre" colspan="2">';
5252 if (is_array($formquestion) && !empty($formquestion[
'text'])) {
5253 $formconfirm .=
'<tr class="valid"><td class="valid" colspan="2">'.$formquestion[
'text'].
'</td></tr>'.
"\n";
5258 $formconfirm .=
'<tr class="valid"><td class="valid" colspan="2">'.
"\n";
5265 $formconfirm .=
'<td class="valid">'.$question.
'</td>';
5267 $formconfirm .= $this->
selectyesno(
"confirm", $newselectedchoice, 0,
false, 0, 0,
'marginleftonly marginrightonly', $labelbuttonyes, $labelbuttonno);
5268 $formconfirm .=
'<input class="button valignmiddle confirmvalidatebutton small" type="submit" value="'.$langs->trans(
"Validate").
'">';
5274 if (empty($disableformtag)) {
5279 if (!empty($conf->use_javascript_ajax)) {
5280 $formconfirm .=
'<!-- code to disable button to avoid double clic -->';
5281 $formconfirm .=
'<script type="text/javascript">'.
"\n";
5283 $(document).ready(function () {
5284 $(".confirmvalidatebutton").on("click", function() {
5285 console.log("We click on button");
5286 $(this).attr("disabled", "disabled");
5287 setTimeout(\'$(".confirmvalidatebutton").removeAttr("disabled")\', 3000);
5288 //console.log($(this).closest("form"));
5289 $(this).closest("form").submit();
5317 public function form_project($page, $socid, $selected =
'', $htmlname =
'projectid', $discard_closed = 0, $maxlength = 20, $forcefocus = 0, $nooutput = 0)
5322 require_once DOL_DOCUMENT_ROOT.
'/core/lib/project.lib.php';
5323 require_once DOL_DOCUMENT_ROOT.
'/core/class/html.formprojet.class.php';
5329 $langs->load(
"project");
5330 if ($htmlname !=
"none") {
5332 $out .=
'<form method="post" action="'.$page.
'">';
5333 $out .=
'<input type="hidden" name="action" value="classin">';
5334 $out .=
'<input type="hidden" name="token" value="'.newToken().
'">';
5335 $out .= $formproject->select_projects($socid, $selected, $htmlname, $maxlength, 0, 1, $discard_closed, $forcefocus, 0, 0,
'', 1);
5336 $out .=
'<input type="submit" class="button smallpaddingimp" value="'.$langs->trans(
"Modify").
'">';
5339 $out .=
'<span class="project_head_block">';
5342 $projet->fetch($selected);
5343 $out .= $projet->getNomUrl(1,
'', 1);
5350 if (empty($nooutput)) {
5372 public function form_conditions_reglement($page, $selected =
'', $htmlname =
'cond_reglement_id', $addempty = 0, $type =
'', $filtertype = -1, $deposit_percent = -1)
5376 if ($htmlname !=
"none") {
5377 print
'<form method="POST" action="'.$page.
'">';
5378 print
'<input type="hidden" name="action" value="setconditions">';
5379 print
'<input type="hidden" name="token" value="'.newToken().
'">';
5381 print
'<input type="hidden" name="type" value="'.dol_escape_htmltag($type).
'">';
5384 print
'<input type="submit" class="button valignmiddle smallpaddingimp" value="'.$langs->trans(
"Modify").
'">';
5389 if (isset($this->cache_conditions_paiements[$selected])) {
5390 $label = $this->cache_conditions_paiements[$selected][
'label'];
5392 if (! empty($this->cache_conditions_paiements[$selected][
'deposit_percent'])) {
5393 $label = str_replace(
'__DEPOSIT_PERCENT__', $deposit_percent > 0 ? $deposit_percent : $this->cache_conditions_paiements[$selected][
'deposit_percent'], $label);
5398 $langs->load(
'errors');
5399 print $langs->trans(
'ErrorNotInDictionaryPaymentConditions');
5421 if ($htmlname !=
"none") {
5422 print
'<form method="post" action="'.$page.
'">';
5423 print
'<input type="hidden" name="action" value="setavailability">';
5424 print
'<input type="hidden" name="token" value="'.newToken().
'">';
5426 print
'<input type="submit" name="modify" class="button smallpaddingimp" value="'.$langs->trans(
"Modify").
'">';
5427 print
'<input type="submit" name="cancel" class="button smallpaddingimp" value="'.$langs->trans(
"Cancel").
'">';
5432 print $this->cache_availability[$selected][
'label'];
5449 public function formInputReason($page, $selected =
'', $htmlname =
'demandreason', $addempty = 0)
5452 if ($htmlname !=
"none") {
5453 print
'<form method="post" action="'.$page.
'">';
5454 print
'<input type="hidden" name="action" value="setdemandreason">';
5455 print
'<input type="hidden" name="token" value="'.newToken().
'">';
5457 print
'<input type="submit" class="button smallpaddingimp" value="'.$langs->trans(
"Modify").
'">';
5462 foreach ($this->cache_demand_reason as $key => $val) {
5463 if ($val[
'id'] == $selected) {
5464 print $val[
'label'];
5488 public function form_date($page, $selected, $htmlname, $displayhour = 0, $displaymin = 0, $nooutput = 0, $type =
'')
5495 if ($htmlname !=
"none") {
5496 $ret .=
'<form method="POST" action="'.$page.
'" name="form'.$htmlname.
'">';
5497 $ret .=
'<input type="hidden" name="action" value="set'.$htmlname.
'">';
5498 $ret .=
'<input type="hidden" name="token" value="'.newToken().
'">';
5500 $ret .=
'<input type="hidden" name="type" value="'.dol_escape_htmltag($type).
'">';
5502 $ret .=
'<table class="nobordernopadding">';
5504 $ret .= $this->
selectDate($selected, $htmlname, $displayhour, $displaymin, 1,
'form'.$htmlname, 1, 0);
5506 $ret .=
'<td class="left"><input type="submit" class="button smallpaddingimp" value="'.$langs->trans(
"Modify").
'"></td>';
5507 $ret .=
'</tr></table></form>';
5516 if (empty($nooutput)) {
5534 public function form_users($page, $selected =
'', $htmlname =
'userid', $exclude =
'', $include =
'')
5539 if ($htmlname !=
"none") {
5540 print
'<form method="POST" action="'.$page.
'" name="form'.$htmlname.
'">';
5541 print
'<input type="hidden" name="action" value="set'.$htmlname.
'">';
5542 print
'<input type="hidden" name="token" value="'.newToken().
'">';
5543 print $this->
select_dolusers($selected, $htmlname, 1, $exclude, 0, $include);
5544 print
'<input type="submit" class="button smallpaddingimp valignmiddle" value="'.$langs->trans(
"Modify").
'">';
5548 require_once DOL_DOCUMENT_ROOT.
'/user/class/user.class.php';
5549 $theuser =
new User($this->
db);
5550 $theuser->fetch($selected);
5551 print $theuser->getNomUrl(1);
5572 public function form_modes_reglement($page, $selected =
'', $htmlname =
'mode_reglement_id', $filtertype =
'', $active = 1, $addempty = 0, $type =
'')
5576 if ($htmlname !=
"none") {
5577 print
'<form method="POST" action="'.$page.
'">';
5578 print
'<input type="hidden" name="action" value="setmode">';
5579 print
'<input type="hidden" name="token" value="'.newToken().
'">';
5581 print
'<input type="hidden" name="type" value="'.dol_escape_htmltag($type).
'">';
5583 print $this->
select_types_paiements($selected, $htmlname, $filtertype, 0, $addempty, 0, 0, $active,
'', 1);
5584 print
'<input type="submit" class="button smallpaddingimp valignmiddle" value="'.$langs->trans(
"Modify").
'">';
5589 print $this->cache_types_paiements[$selected][
'label'];
5609 if ($htmlname !=
"none") {
5610 print
'<form method="POST" action="'.$page.
'">';
5611 print
'<input type="hidden" name="action" value="settransportmode">';
5612 print
'<input type="hidden" name="token" value="'.newToken().
'">';
5614 print
'<input type="submit" class="button smallpaddingimp valignmiddle" value="'.$langs->trans(
"Modify").
'">';
5619 print $this->cache_transport_mode[$selected][
'label'];
5639 if ($htmlname !=
"none") {
5640 print
'<form method="POST" action="'.$page.
'">';
5641 print
'<input type="hidden" name="action" value="setmulticurrencycode">';
5642 print
'<input type="hidden" name="token" value="'.newToken().
'">';
5644 print
'<input type="submit" class="button smallpaddingimp valignmiddle" value="'.$langs->trans(
"Modify").
'">';
5648 print !empty($selected) ?
currency_name($selected, 1) :
' ';
5665 global $langs, $mysoc, $conf;
5667 if ($htmlname !=
"none") {
5668 print
'<form method="POST" action="'.$page.
'">';
5669 print
'<input type="hidden" name="action" value="setmulticurrencyrate">';
5670 print
'<input type="hidden" name="token" value="'.newToken().
'">';
5671 print
'<input type="text" class="maxwidth100" name="'.$htmlname.
'" value="'.(!empty($rate) ?
price(
price2num($rate,
'CU')) : 1).
'" /> ';
5672 print
'<select name="calculation_mode">';
5673 print
'<option value="1">Change '.$langs->trans(
"PriceUHT").
' of lines</option>';
5674 print
'<option value="2">Change '.$langs->trans(
"PriceUHTCurrency").
' of lines</option>';
5676 print
'<input type="submit" class="button smallpaddingimp valignmiddle" value="'.$langs->trans(
"Modify").
'">';
5679 if (!empty($rate)) {
5680 print
price($rate, 1, $langs, 1, 0);
5681 if ($currency && $rate != 1) {
5682 print
' ('.price($rate, 1, $langs, 1, 0).
' '.$currency.
' = 1 '.$conf->currency.
')';
5707 public function form_remise_dispo($page, $selected, $htmlname, $socid, $amount, $filter =
'', $maxvalue = 0, $more =
'', $hidelist = 0, $discount_type = 0)
5710 global $conf, $langs;
5711 if ($htmlname !=
"none") {
5712 print
'<form method="post" action="'.$page.
'">';
5713 print
'<input type="hidden" name="action" value="setabsolutediscount">';
5714 print
'<input type="hidden" name="token" value="'.newToken().
'">';
5715 print
'<div class="inline-block">';
5716 if (!empty($discount_type)) {
5717 if (!empty($conf->global->FACTURE_SUPPLIER_DEPOSITS_ARE_JUST_PAYMENTS)) {
5718 if (!$filter || $filter ==
"fk_invoice_supplier_source IS NULL") {
5719 $translationKey =
'HasAbsoluteDiscountFromSupplier';
5721 $translationKey =
'HasCreditNoteFromSupplier';
5724 if (!$filter || $filter ==
"fk_invoice_supplier_source IS NULL OR (description LIKE '(DEPOSIT)%' AND description NOT LIKE '(EXCESS PAID)%')") {
5725 $translationKey =
'HasAbsoluteDiscountFromSupplier';
5727 $translationKey =
'HasCreditNoteFromSupplier';
5731 if (!empty($conf->global->FACTURE_DEPOSITS_ARE_JUST_PAYMENTS)) {
5732 if (!$filter || $filter ==
"fk_facture_source IS NULL") {
5733 $translationKey =
'CompanyHasAbsoluteDiscount';
5735 $translationKey =
'CompanyHasCreditNote';
5738 if (!$filter || $filter ==
"fk_facture_source IS NULL OR (description LIKE '(DEPOSIT)%' AND description NOT LIKE '(EXCESS RECEIVED)%')") {
5739 $translationKey =
'CompanyHasAbsoluteDiscount';
5741 $translationKey =
'CompanyHasCreditNote';
5745 print $langs->trans($translationKey,
price($amount, 0, $langs, 0, 0, -1, $conf->currency));
5746 if (empty($hidelist)) {
5750 if (empty($hidelist)) {
5751 print
'<div class="inline-block" style="padding-right: 10px">';
5752 $newfilter =
'discount_type='.intval($discount_type);
5753 if (!empty($discount_type)) {
5754 $newfilter .=
' AND fk_invoice_supplier IS NULL AND fk_invoice_supplier_line IS NULL';
5756 $newfilter .=
' AND fk_facture IS NULL AND fk_facture_line IS NULL';
5759 $newfilter .=
' AND ('.$filter.
')';
5762 $nbqualifiedlines = $this->
select_remises($selected, $htmlname, $newfilter, $socid, $maxvalue);
5763 if ($nbqualifiedlines > 0) {
5764 print
' <input type="submit" class="button smallpaddingimp" value="'.dol_escape_htmltag($langs->trans(
"UseLine")).
'"';
5765 if (!empty($discount_type) && $filter && $filter !=
"fk_invoice_supplier_source IS NULL OR (description LIKE '(DEPOSIT)%' AND description NOT LIKE '(EXCESS PAID)%')") {
5766 print
' title="'.$langs->trans(
"UseCreditNoteInInvoicePayment").
'"';
5768 if (empty($discount_type) && $filter && $filter !=
"fk_facture_source IS NULL OR (description LIKE '(DEPOSIT)%' AND description NOT LIKE '(EXCESS RECEIVED)%')") {
5769 print
' title="'.$langs->trans(
"UseCreditNoteInInvoicePayment").
'"';
5777 print
'<div class="inline-block">';
5802 public function form_contacts($page, $societe, $selected =
'', $htmlname =
'contactid')
5805 global $langs, $conf;
5807 if ($htmlname !=
"none") {
5808 print
'<form method="post" action="'.$page.
'">';
5809 print
'<input type="hidden" name="action" value="set_contact">';
5810 print
'<input type="hidden" name="token" value="'.newToken().
'">';
5811 print
'<table class="nobordernopadding">';
5816 $addcontact = (!empty($conf->global->SOCIETE_ADDRESSES_MANAGEMENT) ? $langs->trans(
"AddContact") : $langs->trans(
"AddContactAddress"));
5817 print
'<a href="'.DOL_URL_ROOT.
'/contact/card.php?socid='.$societe->id.
'&action=create&backtoreferer=1">'.$addcontact.
'</a>';
5820 print
'<td class="left"><input type="submit" class="button smallpaddingimp" value="'.$langs->trans(
"Modify").
'"></td>';
5821 print
'</tr></table></form>';
5824 require_once DOL_DOCUMENT_ROOT.
'/contact/class/contact.class.php';
5826 $contact->fetch($selected);
5827 print $contact->getFullName($langs);
5850 public function form_thirdparty($page, $selected =
'', $htmlname =
'socid', $filter =
'', $showempty = 0, $showtype = 0, $forcecombo = 0, $events = array(), $nooutput = 0, $excludeids = array())
5856 if ($htmlname !=
"none") {
5857 $out .=
'<form method="post" action="'.$page.
'">';
5858 $out .=
'<input type="hidden" name="action" value="set_thirdparty">';
5859 $out .=
'<input type="hidden" name="token" value="'.newToken().
'">';
5860 $out .= $this->
select_company($selected, $htmlname, $filter, $showempty, $showtype, $forcecombo, $events, 0,
'minwidth100',
'',
'', 1, array(),
false, $excludeids);
5861 $out .=
'<input type="submit" class="button smallpaddingimp valignmiddle" value="'.$langs->trans(
"Modify").
'">';
5865 require_once DOL_DOCUMENT_ROOT.
'/societe/class/societe.class.php';
5867 $soc->fetch($selected);
5868 $out .= $soc->getNomUrl($langs);
5905 public function selectCurrency($selected =
'', $htmlname =
'currency_id', $mode = 0, $useempty =
'')
5907 global $conf, $langs, $user;
5909 $langs->loadCacheCurrencies(
'');
5913 if ($selected ==
'euro' || $selected ==
'euros') {
5917 $out .=
'<select class="flat maxwidth200onsmartphone minwidth300" name="'.$htmlname.
'" id="'.$htmlname.
'">';
5919 $out .=
'<option value="-1" selected></option>';
5921 foreach ($langs->cache_currencies as $code_iso => $currency) {
5922 $labeltoshow = $currency[
'label'];
5924 $labeltoshow .=
' <span class="opacitymedium">('.$code_iso.
')</span>';
5926 $labeltoshow .=
' <span class="opacitymedium">('.$langs->getCurrencySymbol($code_iso).
')</span>';
5929 if ($selected && $selected == $code_iso) {
5930 $out .=
'<option value="'.$code_iso.
'" selected data-html="'.
dol_escape_htmltag($labeltoshow).
'">';
5932 $out .=
'<option value="'.$code_iso.
'" data-html="'.
dol_escape_htmltag($labeltoshow).
'">';
5934 $out .= $labeltoshow;
5935 $out .=
'</option>';
5937 $out .=
'</select>';
5939 $out .=
info_admin($langs->trans(
"YouCanChangeValuesForThisListFromDictionarySetup"), 1);
5943 include_once DOL_DOCUMENT_ROOT.
'/core/lib/ajax.lib.php';
5961 public function selectMultiCurrency($selected =
'', $htmlname =
'multicurrency_code', $useempty = 0, $filter =
'', $excludeConfCurrency =
false, $morecss =
'')
5963 global $conf, $langs;
5965 $langs->loadCacheCurrencies(
'');
5967 $TCurrency = array();
5969 $sql =
"SELECT code FROM ".$this->db->prefix().
"multicurrency";
5970 $sql .=
" WHERE entity IN ('".getEntity(
'mutlicurrency').
"')";
5972 $sql .=
" AND ".$filter;
5976 while ($obj = $this->
db->fetch_object(
$resql)) {
5977 $TCurrency[$obj->code] = $obj->code;
5982 $out .=
'<select class="flat'.($morecss ?
' '.$morecss :
'').
'" name="'.$htmlname.
'" id="'.$htmlname.
'">';
5984 $out .=
'<option value=""> </option>';
5987 if (!in_array($conf->currency, $TCurrency) && !$excludeConfCurrency) {
5988 $TCurrency[$conf->currency] = $conf->currency;
5990 if (count($TCurrency) > 0) {
5991 foreach ($langs->cache_currencies as $code_iso => $currency) {
5992 if (isset($TCurrency[$code_iso])) {
5993 if (!empty($selected) && $selected == $code_iso) {
5994 $out .=
'<option value="'.$code_iso.
'" selected="selected">';
5996 $out .=
'<option value="'.$code_iso.
'">';
5999 $out .= $currency[
'label'];
6000 $out .=
' ('.$langs->getCurrencySymbol($code_iso).
')';
6001 $out .=
'</option>';
6006 $out .=
'</select>';
6009 include_once DOL_DOCUMENT_ROOT.
'/core/lib/ajax.lib.php';
6027 $num = count($this->cache_vatrates);
6034 $sql =
"SELECT DISTINCT t.rowid, t.code, t.taux, t.localtax1, t.localtax1_type, t.localtax2, t.localtax2_type, t.recuperableonly";
6035 $sql .=
" FROM ".$this->db->prefix().
"c_tva as t, ".$this->
db->prefix().
"c_country as c";
6036 $sql .=
" WHERE t.fk_pays = c.rowid";
6037 $sql .=
" AND t.active > 0";
6038 $sql .=
" AND c.code IN (".$this->db->sanitize($country_code, 1).
")";
6039 $sql .=
" ORDER BY t.code ASC, t.taux ASC, t.recuperableonly ASC";
6043 $num = $this->
db->num_rows(
$resql);
6045 for ($i = 0; $i < $num; $i++) {
6046 $obj = $this->
db->fetch_object(
$resql);
6047 $this->cache_vatrates[$i][
'rowid'] = $obj->rowid;
6048 $this->cache_vatrates[$i][
'code'] = $obj->code;
6049 $this->cache_vatrates[$i][
'txtva'] = $obj->taux;
6050 $this->cache_vatrates[$i][
'nprtva'] = $obj->recuperableonly;
6051 $this->cache_vatrates[$i][
'localtax1'] = $obj->localtax1;
6052 $this->cache_vatrates[$i][
'localtax1_type'] = $obj->localtax1_type;
6053 $this->cache_vatrates[$i][
'localtax2'] = $obj->localtax2;
6054 $this->cache_vatrates[$i][
'localtax2_type'] = $obj->localtax1_type;
6056 $this->cache_vatrates[$i][
'label'] = $obj->taux.
'%'.($obj->code ?
' ('.$obj->code.
')' :
'');
6057 $this->cache_vatrates[$i][
'labelallrates'] = $obj->taux.
'/'.($obj->localtax1 ? $obj->localtax1 :
'0').
'/'.($obj->localtax2 ? $obj->localtax2 :
'0').($obj->code ?
' ('.$obj->code.
')' :
'');
6058 $positiverates =
'';
6060 $positiverates .= ($positiverates ?
'/' :
'').$obj->taux;
6062 if ($obj->localtax1) {
6063 $positiverates .= ($positiverates ?
'/' :
'').$obj->localtax1;
6065 if ($obj->localtax2) {
6066 $positiverates .= ($positiverates ?
'/' :
'').$obj->localtax2;
6068 if (empty($positiverates)) {
6069 $positiverates =
'0';
6071 $this->cache_vatrates[$i][
'labelpositiverates'] = $positiverates.($obj->code ?
' ('.$obj->code.
')' :
'');
6076 $this->error =
'<span class="error">'.$langs->trans(
"ErrorNoVATRateDefinedForSellerCountry", $country_code).
'</span>';
6080 $this->error =
'<span class="error">'.$this->db->error().
'</span>';
6107 public function load_tva($htmlname =
'tauxtva', $selectedrate =
'', $societe_vendeuse =
'', $societe_acheteuse =
'', $idprod = 0, $info_bits = 0, $type =
'', $options_only =
false, $mode = 0)
6110 global $langs, $conf, $mysoc;
6112 $langs->load(
'errors');
6117 $defaultnpr = ($info_bits & 0x01);
6118 $defaultnpr = (preg_match(
'/\*/', $selectedrate) ? 1 : $defaultnpr);
6119 $defaulttx = str_replace(
'*',
'', $selectedrate);
6122 if (preg_match(
'/\((.*)\)/', $defaulttx, $reg)) {
6123 $defaultcode = $reg[1];
6124 $defaulttx = preg_replace(
'/\s*\(.*\)/',
'', $defaulttx);
6129 if (is_object($societe_vendeuse) && !$societe_vendeuse->country_code) {
6130 if ($societe_vendeuse->id == $mysoc->id) {
6131 $return .=
'<span class="error">'.$langs->trans(
"ErrorYourCountryIsNotDefined").
'</span>';
6133 $return .=
'<span class="error">'.$langs->trans(
"ErrorSupplierCountryIsNotDefined").
'</span>';
6144 if (is_object($societe_vendeuse)) {
6145 $code_country =
"'".$societe_vendeuse->country_code.
"'";
6147 $code_country =
"'".$mysoc->country_code.
"'";
6149 if (!empty($conf->global->SERVICE_ARE_ECOMMERCE_200238EC)) {
6150 require_once DOL_DOCUMENT_ROOT.
'/core/lib/company.lib.php';
6151 if (!
isInEEC($societe_vendeuse) && (!is_object($societe_acheteuse) || (
isInEEC($societe_acheteuse) && !$societe_acheteuse->isACompany()))) {
6153 if (is_numeric($type)) {
6155 $code_country .=
",'".$societe_acheteuse->country_code.
"'";
6157 } elseif (!$idprod) {
6158 $code_country .=
",'".$societe_acheteuse->country_code.
"'";
6161 $prodstatic->fetch($idprod);
6163 $code_country .=
",'".$societe_acheteuse->country_code.
"'";
6174 if ($defaulttx < 0 ||
dol_strlen($defaulttx) == 0) {
6175 $tmpthirdparty =
new Societe($this->
db);
6176 $defaulttx =
get_default_tva($societe_vendeuse, (is_object($societe_acheteuse) ? $societe_acheteuse : $tmpthirdparty), $idprod);
6177 $defaultnpr =
get_default_npr($societe_vendeuse, (is_object($societe_acheteuse) ? $societe_acheteuse : $tmpthirdparty), $idprod);
6178 if (preg_match(
'/\((.*)\)/', $defaulttx, $reg)) {
6179 $defaultcode = $reg[1];
6180 $defaulttx = preg_replace(
'/\s*\(.*\)/',
'', $defaulttx);
6182 if (empty($defaulttx)) {
6189 if ($defaulttx < 0 ||
dol_strlen($defaulttx) == 0) {
6190 if (empty($conf->global->MAIN_VAT_DEFAULT_IF_AUTODETECT_FAILS)) {
6191 $defaulttx = $this->cache_vatrates[$num - 1][
'txtva'];
6193 $defaulttx = ($conf->global->MAIN_VAT_DEFAULT_IF_AUTODETECT_FAILS ==
'none' ?
'' : $conf->global->MAIN_VAT_DEFAULT_IF_AUTODETECT_FAILS);
6200 if (is_object($societe_vendeuse) && $societe_vendeuse->id == $mysoc->id && $societe_vendeuse->tva_assuj ==
"0") {
6203 if (empty($conf->global->EXPENSEREPORT_OVERRIDE_VAT)) {
6204 $title =
' title="'.$langs->trans(
'VATIsNotUsed').
'"';
6209 if (!$options_only) {
6210 $return .=
'<select class="flat minwidth75imp" id="'.$htmlname.
'" name="'.$htmlname.
'"'.($disabled ?
' disabled' :
'').$title.
'>';
6213 $selectedfound =
false;
6214 foreach ($this->cache_vatrates as $rate) {
6216 if ($disabled && $rate[
'txtva'] != 0) {
6221 $key = $rate[
'txtva'];
6222 $key .= $rate[
'nprtva'] ?
'*' :
'';
6223 if ($mode > 0 && $rate[
'code']) {
6224 $key .=
' ('.$rate[
'code'].
')';
6227 $key = $rate[
'rowid'];
6230 $return .=
'<option value="'.$key.
'"';
6231 if (!$selectedfound) {
6233 if ($defaultcode == $rate[
'code']) {
6234 $return .=
' selected';
6235 $selectedfound =
true;
6237 } elseif ($rate[
'txtva'] == $defaulttx && $rate[
'nprtva'] == $defaultnpr) {
6238 $return .=
' selected';
6239 $selectedfound =
true;
6244 if ($mysoc->country_code ==
'IN' || !empty($conf->global->MAIN_VAT_LABEL_IS_POSITIVE_RATES)) {
6245 $return .= $rate[
'labelpositiverates'];
6247 $return .=
vatrate($rate[
'label']);
6250 $return .= (empty($rate[
'code']) && $rate[
'nprtva']) ?
' *' :
'';
6252 $return .=
'</option>';
6255 if (!$options_only) {
6256 $return .=
'</select>';
6259 $return .= $this->error;
6292 public function select_date($set_time =
'', $prefix =
're', $h = 0, $m = 0, $empty = 0, $form_name =
"", $d = 1, $addnowlink = 0, $nooutput = 0, $disabled = 0, $fullday =
'', $addplusone =
'', $adddateof =
'')
6295 $retstring = $this->
selectDate($set_time, $prefix, $h, $m, $empty, $form_name, $d, $addnowlink, $disabled, $fullday, $addplusone, $adddateof);
6296 if (!empty($nooutput)) {
6318 public function selectDateToDate($set_time =
'', $set_time_end =
'', $prefix =
're', $empty = 0, $forcenewline = 0)
6322 $ret = $this->
selectDate($set_time, $prefix.
'_start', 0, 0, $empty,
'', 1, 0, 0,
'',
'',
'',
'', 1,
'', $langs->trans(
"from"),
'tzuserrel');
6323 if ($forcenewline) {
6326 $ret .= $this->
selectDate($set_time_end, $prefix.
'_end', 0, 0, $empty,
'', 1, 0, 0,
'',
'',
'',
'', 1,
'', $langs->trans(
"to"),
'tzuserrel');
6357 public function selectDate($set_time =
'', $prefix =
're', $h = 0, $m = 0, $empty = 0, $form_name =
"", $d = 1, $addnowlink = 0, $disabled = 0, $fullday =
'', $addplusone =
'', $adddateof =
'', $openinghours =
'', $stepminutes = 1, $labeladddateof =
'', $placeholder =
'', $gm =
'auto')
6359 global $conf, $langs;
6361 if ($gm ===
'auto') {
6362 $gm = (empty($conf) ?
'tzserver' : $conf->tzuserinputkey);
6367 if ($prefix ==
'') {
6378 if ($stepminutes <= 0 || $stepminutes > 30) {
6389 $orig_set_time = $set_time;
6391 if ($set_time ===
'' && $emptydate == 0) {
6392 include_once DOL_DOCUMENT_ROOT.
'/core/lib/date.lib.php';
6393 if ($gm ==
'tzuser' || $gm ==
'tzuserrel') {
6405 if (preg_match(
'/^([0-9]+)\-([0-9]+)\-([0-9]+)\s?([0-9]+)?:?([0-9]+)?/', $set_time, $reg)) {
6407 $syear = (!empty($reg[1]) ? $reg[1] :
'');
6408 $smonth = (!empty($reg[2]) ? $reg[2] :
'');
6409 $sday = (!empty($reg[3]) ? $reg[3] :
'');
6410 $shour = (!empty($reg[4]) ? $reg[4] :
'');
6411 $smin = (!empty($reg[5]) ? $reg[5] :
'');
6412 } elseif (strval($set_time) !=
'' && $set_time != -1) {
6417 if ($orig_set_time !=
'') {
6427 $shour = !isset($conf->global->MAIN_DEFAULT_DATE_HOUR) ? ($h == -1 ?
'23' :
'') : $conf->global->MAIN_DEFAULT_DATE_HOUR;
6428 $smin = !isset($conf->global->MAIN_DEFAULT_DATE_MIN) ? ($h == -1 ?
'59' :
'') : $conf->global->MAIN_DEFAULT_DATE_MIN;
6429 $ssec = !isset($conf->global->MAIN_DEFAULT_DATE_SEC) ? ($h == -1 ?
'59' :
'') : $conf->global->MAIN_DEFAULT_DATE_SEC;
6442 $usecalendar =
'combo';
6443 if (!empty($conf->use_javascript_ajax) && (empty($conf->global->MAIN_POPUP_CALENDAR) || $conf->global->MAIN_POPUP_CALENDAR !=
"none")) {
6444 $usecalendar = ((empty($conf->global->MAIN_POPUP_CALENDAR) || $conf->global->MAIN_POPUP_CALENDAR ==
'eldy') ?
'jquery' : $conf->global->MAIN_POPUP_CALENDAR);
6449 if ($usecalendar !=
'combo') {
6450 $formated_date =
'';
6452 if (strval($set_time) !=
'' && $set_time != -1) {
6454 $formated_date =
dol_print_date($set_time, $langs->trans(
"FormatDateShortInput"), $gm);
6458 if ($usecalendar ==
"eldy") {
6460 $retstring .=
'<input id="'.$prefix.
'" name="'.$prefix.
'" type="text" class="maxwidthdate" maxlength="11" value="'.$formated_date.
'"';
6461 $retstring .= ($disabled ?
' disabled' :
'');
6462 $retstring .=
' onChange="dpChangeDay(\''.$prefix.
'\',\
''.$langs->trans(
"FormatDateShortJavaInput").
'\');
"'; // FormatDateShortInput for dol_print_date / FormatDateShortJavaInput that is same for javascript
6466 $retstringbuttom = '';
6468 $retstringbuttom = '<button id="'.$prefix.'Button
" type="button
" class="dpInvisibleButtons
"';
6469 $base = DOL_URL_ROOT.'/core/';
6470 $retstringbuttom .= ' onClick="showDP(\
''.$base.
'\',\
''.$prefix.
'\',\
''.$langs->trans(
"FormatDateShortJavaInput").
'\',\
''.$langs->defaultlang.
'\');
"';
6471 $retstringbuttom .= '>'.img_object($langs->trans("SelectDate
"), 'calendarday', 'class="datecallink
"').'</button>';
6473 $retstringbuttom = '<button id="'.$prefix.'Button
" type="button
" class="dpInvisibleButtons
">'.img_object($langs->trans("Disabled
"), 'calendarday', 'class="datecallink
"').'</button>';
6475 $retstring = $retstringbuttom.$retstring;
6477 $retstring .= '<input type="hidden
" id="'.$prefix.'day
" name="'.$prefix.'day
" value="'.$sday.'">'."\n
";
6478 $retstring .= '<input type="hidden
" id="'.$prefix.'month
" name="'.$prefix.'month
" value="'.$smonth.'">'."\n
";
6479 $retstring .= '<input type="hidden
" id="'.$prefix.'year
" name="'.$prefix.'year
" value="'.$syear.'">'."\n
";
6480 } elseif ($usecalendar == 'jquery') {
6482 // Output javascript for datepicker
6483 $minYear = getDolGlobalString('MIN_YEAR_SELECT_DATE', date('Y') - 100);
6484 $maxYear = getDolGlobalString('MAX_YEAR_SELECT_DATE', date('Y') + 100);
6486 $retstring .= "<script
type=
'text/javascript'>
";
6487 $retstring .= "$(
function(){ $(
'#".$prefix."').datepicker({
6488 dateFormat:
'".$langs->trans("FormatDateShortJQueryInput")."',
6490 todayHighlight:
true,
6491 yearRange:
'".$minYear.":".$maxYear."',
";
6492 if (!empty($conf->dol_use_jmobile)) {
6494 beforeShow:
function (input, datePicker) {
6495 input.disabled =
true;
6497 onClose:
function (dateText, datePicker) {
6498 this.disabled =
false;
6502 // Note: We don't need monthNames, monthNamesShort, dayNames, dayNamesShort, dayNamesMin, they are set globally on datepicker component in lib_head.js.php
6503 if (empty($conf->global->MAIN_POPUP_CALENDAR_ON_FOCUS)) {
6506 buttonImage:
'".DOL_URL_ROOT."/theme/".dol_escape_js($conf->theme)."/img/object_calendarday.png',
6507 buttonImageOnly:
true";
6511 $retstring .= "</script>
";
6514 // Zone de saisie manuelle de la date
6515 $retstring .= '<div class="nowrap
inline-block divfordateinput
">';
6516 $retstring .= '<input id="'.$prefix.'" name="'.$prefix.'" type="text
" class="maxwidthdate
" maxlength="11
" value="'.$formated_date.'"';
6517 $retstring .= ($disabled ? ' disabled' : '');
6518 $retstring .= ($placeholder ? ' placeholder="'.dol_escape_htmltag($placeholder).'"' : '');
6519 $retstring .= ' onChange="dpChangeDay(\
''.
dol_escape_js($prefix).
'\',\
''.
dol_escape_js($langs->trans(
"FormatDateShortJavaInput")).
'\');
"'; // FormatDateShortInput for dol_print_date / FormatDateShortJavaInput that is same for javascript
6524 /* Not required. Managed by option buttonImage of jquery
6525 $retstring.=img_object($langs->trans("SelectDate
"),'calendarday','id="'.$prefix.'id" class="datecallink
"');
6526 $retstring.="<script
type=
'text/javascript'>
";
6527 $retstring.="jQuery(document).ready(
function() {
";
6528 $retstring.=' jQuery("#
'.$prefix.'id").click(function() {';
6529 $retstring.=" jQuery(
'#".$prefix."').focus();
";
6532 $retstring.="</script>
";*/
6534 $retstringbutton = '<button id="'.$prefix.'Button
" type="button
" class="dpInvisibleButtons
">'.img_object($langs->trans("Disabled
"), 'calendarday', 'class="datecallink
"').'</button>';
6535 $retsring = $retstringbutton.$retstring;
6538 $retstring .= '</div>';
6539 $retstring .= '<input type="hidden
" id="'.$prefix.'day
" name="'.$prefix.'day
" value="'.$sday.'">'."\n
";
6540 $retstring .= '<input type="hidden
" id="'.$prefix.'month
" name="'.$prefix.'month
" value="'.$smonth.'">'."\n
";
6541 $retstring .= '<input type="hidden
" id="'.$prefix.'year
" name="'.$prefix.'year
" value="'.$syear.'">'."\n
";
6543 $retstring .= "Bad value of MAIN_POPUP_CALENDAR
";
6546 // Show date with combo selects
6548 $retstring .= '<select'.($disabled ? ' disabled' : '').' class="flat valignmiddle maxwidth50imp
" id="'.$prefix.'day
" name="'.$prefix.'day
">';
6550 if ($emptydate || $set_time == -1) {
6551 $retstring .= '<option value="0
" selected> </option>';
6554 for ($day = 1; $day <= 31; $day++) {
6555 $retstring .= '<option value="'.$day.'"'.($day == $sday ? ' selected' : '').'>'.$day.'</option>';
6558 $retstring .= "</select>
";
6560 $retstring .= '<select'.($disabled ? ' disabled' : '').' class="flat valignmiddle maxwidth75imp
" id="'.$prefix.'month
" name="'.$prefix.'month
">';
6561 if ($emptydate || $set_time == -1) {
6562 $retstring .= '<option value="0
" selected> </option>';
6566 for ($month = 1; $month <= 12; $month++) {
6567 $retstring .= '<option value="'.$month.'"'.($month == $smonth ? ' selected' : '').'>';
6568 $retstring .= dol_print_date(mktime(12, 0, 0, $month, 1, 2000), "%b
");
6569 $retstring .= "</option>
";
6571 $retstring .= "</select>
";
6574 if ($emptydate || $set_time == -1) {
6575 $retstring .= '<input'.($disabled ? ' disabled' : '').' placeholder="'.dol_escape_htmltag($langs->trans("Year")).'" class="flat maxwidth50imp valignmiddle
" type="number
" min="0
" max="3000
" maxlength="4
" id="'.$prefix.'year
" name="'.$prefix.'year
" value="'.$syear.'">';
6577 $retstring .= '<select'.($disabled ? ' disabled' : '').' class="flat valignmiddle maxwidth75imp
" id="'.$prefix.'year
" name="'.$prefix.'year
">';
6579 for ($year = $syear - 10; $year < $syear + 10; $year++) {
6580 $retstring .= '<option value="'.$year.'"'.($year == $syear ? ' selected' : '').'>'.$year.'</option>';
6582 $retstring .= "</select>\n
";
6588 $retstring .= ($h == 2 ? '<br>' : ' ');
6589 $retstring .= '<span class="nowraponall
">';
6595 if ($openinghours != '') {
6596 $openinghours = explode(',', $openinghours);
6597 $hourstart = $openinghours[0];
6598 $hourend = $openinghours[1];
6599 if ($hourend < $hourstart) {
6600 $hourend = $hourstart;
6604 $retstring .= '<select'.($disabled ? ' disabled' : '').' class="flat valignmiddle maxwidth50
'.($fullday ? $fullday.'hour
' : '').'" id="'.$prefix.'hour
" name="'.$prefix.'hour
">';
6606 $retstring .= '<option value="-1
"> </option>';
6608 for ($hour = $hourstart; $hour < $hourend; $hour++) {
6609 if (strlen($hour) < 2) {
6612 $retstring .= '<option value="'.$hour.'"'.(($hour == $shour) ? ' selected' : '').'>'.$hour;
6613 //$retstring .= (empty($conf->dol_optimize_smallscreen) ? '' : 'H');
6614 $retstring .= '</option>';
6616 $retstring .= '</select>';
6617 //if ($m && empty($conf->dol_optimize_smallscreen)) $retstring .= ":
";
6625 $retstring .= '<select'.($disabled ? ' disabled' : '').' class="flat valignmiddle maxwidth50
'.($fullday ? $fullday.'min
' : '').'<