76 public function select_projects($socid = -1, $selected =
'', $htmlname =
'projectid', $maxlength = 16, $option_only = 0, $show_empty = 1, $discard_closed = 0, $forcefocus = 0, $disabled = 0, $mode = 0, $filterkey =
'', $nooutput = 0, $forceaddid = 0, $morecss =
'', $htmlid =
'')
79 global $langs, $conf,
$form;
81 $selected_input_value =
'';
82 if (is_object($selected)) {
83 $selected_input_value = $selected->ref;
84 $selected = $selected->id;
89 if (!empty($conf->use_javascript_ajax) && !empty($conf->global->PROJECT_USE_SEARCH_TO_SELECT)) {
92 if ($selected && empty($selected_input_value)) {
93 require_once DOL_DOCUMENT_ROOT.
'/projet/class/project.class.php';
95 $project->fetch($selected);
96 $selected_input_value = $project->ref;
98 $urloption =
'socid='.((int) $socid).
'&htmlname='.urlencode($htmlname).
'&discardclosed='.((int) $discard_closed);
100 $out .=
'<input type="text" class="minwidth200'.($morecss ?
' '.$morecss :
'').
'" name="search_'.$htmlname.
'" id="search_'.$htmlname.
'" value="'.$selected_input_value.
'"'.$placeholder.
' />';
102 $out .=
ajax_autocompleter($selected, $htmlname, DOL_URL_ROOT.
'/projet/ajax/projects.php', $urloption, $conf->global->PROJECT_USE_SEARCH_TO_SELECT, 0, array(
108 $out .= $this->
select_projects_list($socid, $selected, $htmlname, $maxlength, $option_only, $show_empty, abs($discard_closed), $forcefocus, $disabled, 0, $filterkey, 1, $forceaddid, $htmlid, $morecss);
110 if ($discard_closed > 0) {
112 $out .=
$form->textwithpicto(
'', $langs->trans(
"ClosedProjectsAreHidden"));
116 if (empty($nooutput)) {
145 public function select_projects_list($socid = -1, $selected =
'', $htmlname =
'projectid', $maxlength = 24, $option_only = 0, $show_empty = 1, $discard_closed = 0, $forcefocus = 0, $disabled = 0, $mode = 0, $filterkey =
'', $nooutput = 0, $forceaddid = 0, $htmlid =
'', $morecss =
'maxwidth500')
148 global $user, $conf, $langs;
150 require_once DOL_DOCUMENT_ROOT.
'/projet/class/project.class.php';
152 if (empty($htmlid)) {
159 $hideunselectables =
false;
160 if (!empty($conf->global->PROJECT_HIDE_UNSELECTABLES)) {
161 $hideunselectables =
true;
164 $projectsListId =
false;
165 if (empty($user->rights->projet->all->lire)) {
167 $projectsListId = $projectstatic->getProjectsAuthorizedForUser($user, 0, 1);
171 $sql =
"SELECT p.rowid, p.ref, p.title, p.fk_soc, p.fk_statut, p.public, s.nom as name, s.name_alias";
172 $sql .=
" FROM ".$this->db->prefix().
"projet as p LEFT JOIN ".$this->
db->prefix().
"societe as s ON s.rowid = p.fk_soc";
173 $sql .=
" WHERE p.entity IN (".getEntity(
'project').
")";
174 if ($projectsListId !==
false) {
175 $sql .=
" AND p.rowid IN (".$this->db->sanitize($projectsListId).
")";
178 $sql .=
" AND (p.fk_soc=0 OR p.fk_soc IS NULL)";
181 if (empty($conf->global->PROJECT_ALLOW_TO_LINK_FROM_OTHER_COMPANY)) {
182 $sql .=
" AND (p.fk_soc=".((int) $socid).
" OR p.fk_soc IS NULL)";
183 } elseif ($conf->global->PROJECT_ALLOW_TO_LINK_FROM_OTHER_COMPANY !=
'all') {
184 $sql .=
" AND (p.fk_soc IN (".$this->db->sanitize(((
int) $socid).
", ".$conf->global->PROJECT_ALLOW_TO_LINK_FROM_OTHER_COMPANY).
") OR p.fk_soc IS NULL)";
187 if (!empty($filterkey)) {
190 $sql .=
" ORDER BY p.ref ASC";
194 if (!empty($conf->use_javascript_ajax)) {
195 $morecss .=
' minwidth100';
197 if (empty($option_only)) {
198 $out .=
'<select class="flat'.($morecss ?
' '.$morecss :
'').
'"'.($disabled ?
' disabled="disabled"' :
'').
' id="'.$htmlid.
'" name="'.$htmlname.
'">';
200 if (!empty($show_empty)) {
201 $out .=
'<option value="0"> </option>';
207 $obj = $this->
db->fetch_object(
$resql);
209 if ($socid > 0 && (empty($obj->fk_soc) || $obj->fk_soc == $socid) && empty($user->rights->societe->lire)) {
212 if ($discard_closed == 1 && $obj->fk_statut == 2 && $obj->rowid != $selected) {
220 $labeltoshow .=
', '.dol_trunc($obj->title, $maxlength);
222 $labeltoshow .=
' - '.$obj->name;
223 if ($obj->name_alias) {
224 $labeltoshow .=
' ('.$obj->name_alias.
')';
229 if ($obj->fk_statut == 0) {
231 $labeltoshow .=
' - '.$langs->trans(
"Draft");
232 } elseif ($obj->fk_statut == 2) {
233 if ($discard_closed == 2) {
236 $labeltoshow .=
' - '.$langs->trans(
"Closed");
237 } elseif (empty($conf->global->PROJECT_ALLOW_TO_LINK_FROM_OTHER_COMPANY) && $socid > 0 && (!empty($obj->fk_soc) && $obj->fk_soc != $socid)) {
239 $labeltoshow .=
' - '.$langs->trans(
"LinkedToAnotherCompany");
242 if (!empty($selected) && $selected == $obj->rowid) {
243 $out .=
'<option value="'.$obj->rowid.
'" selected';
245 $out .=
'>'.$labeltoshow.
'</option>';
247 if ($hideunselectables && $disabled && ($selected != $obj->rowid)) {
250 $resultat =
'<option value="'.$obj->rowid.
'"';
252 $resultat .=
' disabled';
257 $resultat .= $labeltoshow;
258 $resultat .=
'</option>';
263 'key' => (
int) $obj->rowid,
264 'value' => $obj->ref,
266 'labelx' => $labeltoshow,
267 'label' => ((
bool) $disabled) ?
'<span class="opacitymedium">'.$labeltoshow.
'</span>' : $labeltoshow,
268 'disabled' => (
bool) $disabled
279 if (empty($option_only)) {
284 if (!empty($conf->use_javascript_ajax)) {
285 include_once DOL_DOCUMENT_ROOT.
'/core/lib/ajax.lib.php';
286 $comboenhancement =
ajax_combobox($htmlid, array(), 0, $forcefocus);
287 $out .= $comboenhancement;
288 $morecss .=
' minwidth100';
291 if (empty($nooutput)) {
324 public function selectTasks($socid = -1, $selected =
'', $htmlname =
'taskid', $maxlength = 24, $option_only = 0, $show_empty =
'1', $discard_closed = 0, $forcefocus = 0, $disabled = 0, $morecss =
'maxwidth500', $projectsListId =
'', $showmore =
'all', $usertofilter =
null)
326 global $user, $conf, $langs;
328 require_once DOL_DOCUMENT_ROOT.
'/projet/class/project.class.php';
330 if (is_null($usertofilter)) {
331 $usertofilter = $user;
336 $hideunselectables =
false;
337 if (!empty($conf->global->PROJECT_HIDE_UNSELECTABLES)) {
338 $hideunselectables =
true;
341 if (empty($projectsListId)) {
342 if (empty($usertofilter->rights->projet->all->lire)) {
344 $projectsListId = $projectstatic->getProjectsAuthorizedForUser($usertofilter, 0, 1);
349 $sql =
"SELECT t.rowid, t.ref as tref, t.label as tlabel, t.progress,";
350 $sql .=
" p.rowid as pid, p.ref, p.title, p.fk_soc, p.fk_statut, p.public, p.usage_task,";
351 $sql .=
" s.nom as name";
352 $sql .=
" FROM ".$this->db->prefix().
"projet as p";
353 $sql .=
" LEFT JOIN ".$this->db->prefix().
"societe as s ON s.rowid = p.fk_soc,";
354 $sql .=
" ".$this->db->prefix().
"projet_task as t";
355 $sql .=
" WHERE p.entity IN (".getEntity(
'project').
")";
356 $sql .=
" AND t.fk_projet = p.rowid";
357 if ($projectsListId) {
358 $sql .=
" AND p.rowid IN (".$this->db->sanitize($projectsListId).
")";
361 $sql .=
" AND (p.fk_soc=0 OR p.fk_soc IS NULL)";
364 $sql .=
" AND (p.fk_soc=".((int) $socid).
" OR p.fk_soc IS NULL)";
366 $sql .=
" ORDER BY p.ref, t.ref ASC";
371 if (empty($option_only) && !empty($conf->use_javascript_ajax)) {
372 include_once DOL_DOCUMENT_ROOT.
'/core/lib/ajax.lib.php';
373 $comboenhancement =
ajax_combobox($htmlname,
'', 0, $forcefocus);
374 $out .= $comboenhancement;
375 $morecss .=
' minwidth200 maxwidth500';
378 if (empty($option_only)) {
379 $out .=
'<select class="valignmiddle flat'.($morecss ?
' '.$morecss :
'').
'"'.($disabled ?
' disabled="disabled"' :
'').
' id="'.$htmlname.
'" name="'.$htmlname.
'">';
381 if (!empty($show_empty)) {
382 $out .=
'<option value="0" class="optiongrey">';
383 if (!is_numeric($show_empty)) {
397 $obj = $this->
db->fetch_object(
$resql);
399 if ($socid > 0 && (empty($obj->fk_soc) || $obj->fk_soc == $socid) && empty($usertofilter->rights->societe->lire)) {
414 if ($discard_closed == 2) {
417 } elseif ($socid > 0 && (!empty($obj->fk_soc) && $obj->fk_soc != $socid)) {
421 if (preg_match(
'/all/', $showmore)) {
422 $labeltoshow .=
dol_trunc($obj->ref, 18);
425 $labeltoshow .=
' '.dol_trunc($obj->title, $maxlength);
426 $titletoshow = $labeltoshow;
429 $labeltoshow .=
' ('.$obj->name.
')';
430 $titletoshow .=
' <span class="opacitymedium">('.$obj->name.
')</span>';
436 $labeltoshow .=
' - '.$langs->trans(
"Draft");
437 $titletoshow .=
' - <span class="opacitymedium">'.$langs->trans(
"Draft").
'</span>';
439 if ($discard_closed == 2) {
442 $labeltoshow .=
' - '.$langs->trans(
"Closed");
443 $titletoshow .=
' - <span class="opacitymedium">'.$langs->trans(
"Closed").
'</span>';
444 } elseif ($socid > 0 && (!empty($obj->fk_soc) && $obj->fk_soc != $socid)) {
446 $labeltoshow .=
' - '.$langs->trans(
"LinkedToAnotherCompany");
447 $titletoshow .=
' - <span class="opacitymedium">'.$langs->trans(
"LinkedToAnotherCompany").
'</span>';
449 $labeltoshow .=
' - ';
450 $titletoshow .=
' - ';
454 $labeltoshow .= $obj->tref.
' '.
dol_trunc($obj->tlabel, $maxlength);
455 $titletoshow .= $obj->tref.
' '.
dol_trunc($obj->tlabel, $maxlength);
456 if ($obj->usage_task && preg_match(
'/progress/', $showmore)) {
457 $labeltoshow .=
' <span class="opacitymedium">('.$obj->progress.
'%)</span>';
458 $titletoshow .=
' <span class="opacitymedium">('.$obj->progress.
'%)</span>';
461 if (!empty($selected) && $selected == $obj->rowid) {
462 $out .=
'<option value="'.$obj->rowid.
'" selected';
463 $out .=
' data-html="'.dol_escape_htmltag($titletoshow).
'"';
465 $out .=
'>'.$labeltoshow.
'</option>';
467 if ($hideunselectables && $disabled && ($selected != $obj->rowid)) {
470 $resultat =
'<option value="'.$obj->rowid.
'"';
472 $resultat .=
' disabled';
476 $resultat .=
' data-html="'.dol_escape_htmltag($titletoshow).
'"';
478 $resultat .= $labeltoshow;
479 $resultat .=
'</option>';
487 if (empty($option_only)) {
491 $this->nboftasks = $num;
516 public function select_element($table_element, $socid = 0, $morecss =
'', $limitonstatus = -2, $projectkey =
"fk_projet", $placeholder =
'')
519 global $conf, $langs;
521 if ($table_element ==
'projet_task') {
525 $linkedtothirdparty =
false;
526 if (!in_array($table_element, array(
529 'expensereport',
'loan',
537 $linkedtothirdparty =
true;
543 switch ($table_element) {
545 $sql =
"SELECT t.rowid, t.label as ref";
548 $sql =
"SELECT t.rowid, t.ref as ref";
550 case "facture_fourn":
551 $sql =
"SELECT t.rowid, t.ref, t.ref_supplier";
553 case "commande_fourn":
554 case "commande_fournisseur":
555 $sql =
"SELECT t.rowid, t.ref, t.ref_supplier";
558 $sql =
"SELECT t.rowid, t.titre as ref";
561 $sql =
"SELECT t.id as rowid, t.label as ref";
562 $projectkey =
"fk_project";
564 case "expensereport":
566 case "expensereport_det":
574 $sql =
"SELECT t.rowid, t.ref";
576 case 'stock_mouvement':
577 $sql =
"SELECT t.rowid, t.label as ref";
578 $projectkey =
'fk_origin';
580 case "payment_salary":
581 $sql =
"SELECT t.rowid, t.num_payment as ref";
583 case "payment_various":
584 $sql =
"SELECT t.rowid, t.num_payment as ref";
586 case "chargesociales":
588 $sql =
"SELECT t.rowid, t.ref";
591 if ($linkedtothirdparty) {
592 $sql .=
", s.nom as name";
594 $sql .=
" FROM ".$this->db->prefix().$table_element.
" as t";
595 if ($linkedtothirdparty) {
596 $sql .=
", ".$this->db->prefix().
"societe as s";
598 $sql .=
" WHERE ".$projectkey.
" is null";
599 if (!empty($socid) && $linkedtothirdparty) {
600 if (is_numeric($socid)) {
601 $sql .=
" AND t.fk_soc = ".((int) $socid);
603 $sql .=
" AND t.fk_soc IN (".$this->db->sanitize($socid).
")";
606 if (!in_array($table_element, array(
'expensereport_det',
'stock_mouvement'))) {
607 $sql .=
' AND t.entity IN ('.getEntity(
'project').
')';
609 if ($linkedtothirdparty) {
610 $sql .=
" AND s.rowid = t.fk_soc";
613 $sql .=
" AND ".$sqlfilter;
615 $sql .=
" ORDER BY ref DESC";
617 dol_syslog(get_class($this).
'::select_element', LOG_DEBUG);
623 $sellist =
'<select class="flat elementselect css'.$table_element.($morecss ?
' '.$morecss :
'').
'" name="elementselect">';
624 $sellist .=
'<option value="-1"'.($placeholder ?
' class="optiongrey"' :
'').
'>'.$placeholder.
'</option>';
626 $obj = $this->
db->fetch_object(
$resql);
627 $ref = $obj->ref ? $obj->ref : $obj->rowid;
628 if (!empty($obj->ref_supplier)) {
629 $ref .=
' ('.$obj->ref_supplier.
')';
631 if (!empty($obj->name)) {
632 $ref .=
' - '.$obj->name;
634 $sellist .=
'<option value="'.$obj->rowid.
'">'.$ref.
'</option>';
637 $sellist .=
'</select>';
650 $this->error = $this->
db->lasterror();
651 $this->errors[] = $this->
db->lasterror();
652 dol_syslog(get_class($this).
"::select_element ".$this->error, LOG_ERR);
672 public function selectOpportunityStatus($htmlname, $preselected =
'-1', $showempty = 1, $useshortlabel = 0, $showallnone = 0, $showpercent = 0, $morecss =
'', $noadmininfo = 0, $addcombojs = 0)
674 global $conf, $langs, $user;
676 $sql =
"SELECT rowid, code, label, percent";
677 $sql .=
" FROM ".$this->db->prefix().
'c_lead_status';
678 $sql .=
" WHERE active = 1";
679 $sql .=
" ORDER BY position";
686 $sellist =
'<select class="flat oppstatus'.($morecss ?
' '.$morecss :
'').
'" id="'.$htmlname.
'" name="'.$htmlname.
'">';
689 $sellist .=
'<option value="-1"> </option>';
692 $sellist .=
'<option value="all"'.($preselected ==
'all' ?
' selected="selected"' :
'').
'>-- '.$langs->trans(
"OnlyOpportunitiesShort").
' --</option>';
693 $sellist .=
'<option value="openedopp"'.($preselected ==
'openedopp' ?
' selected="selected"' :
'').
'>-- '.$langs->trans(
"OpenedOpportunitiesShort").
' --</option>';
694 $sellist .=
'<option value="notopenedopp"'.($preselected ==
'notopenedopp' ?
' selected="selected"' :
'').
'>-- '.$langs->trans(
"NotOpenedOpportunitiesShort").
' --</option>';
695 $sellist .=
'<option value="none"'.($preselected ==
'none' ?
' selected="selected"' :
'').
'>-- '.$langs->trans(
"NotAnOpportunityShort").
' --</option>';
698 $obj = $this->
db->fetch_object(
$resql);
700 $sellist .=
'<option value="'.$obj->rowid.
'" defaultpercent="'.$obj->percent.
'" elemcode="'.$obj->code.
'"';
701 if ($obj->rowid == $preselected) {
702 $sellist .=
' selected="selected"';
705 if ($useshortlabel) {
706 $finallabel = ($langs->transnoentitiesnoconv(
"OppStatus".$obj->code) !=
"OppStatus".$obj->code ? $langs->transnoentitiesnoconv(
"OppStatus".$obj->code) : $obj->label);
708 $finallabel = ($langs->transnoentitiesnoconv(
"OppStatus".$obj->code) !=
"OppStatus".$obj->code ? $langs->transnoentitiesnoconv(
"OppStatus".$obj->code) : $obj->label);
710 $finallabel .=
' ('.$obj->percent.
'%)';
713 $sellist .= $finallabel;
714 $sellist .=
'</option>';
717 $sellist .=
'</select>';
719 if ($user->admin && !$noadmininfo) {
720 $sellist .=
info_admin($langs->trans(
"YouCanChangeValuesForThisListFromDictionarySetup"), 1);
737 $this->error = $this->
db->lasterror();
738 $this->errors[] = $this->
db->lasterror();
739 dol_syslog(get_class($this).
"::selectOpportunityStatus ".$this->error, LOG_ERR);