34require_once DOL_DOCUMENT_ROOT.
'/core/class/commonobject.class.php';
44 public $element =
'project';
49 public $table_element =
'projet';
54 public $table_element_line =
'projet_task';
59 public $table_element_date;
64 public $fk_element =
'fk_projet';
69 public $picto =
'project';
118 public $date_start_event;
123 public $date_end_event;
140 public $thirdparty_name;
147 public $fk_user_close;
154 public $budget_amount;
159 public $usage_opportunity;
169 public $usage_bill_time;
174 public $usage_organize_event;
179 public $accept_conference_suggestions;
184 public $accept_booth_suggestions;
189 public $price_registration;
199 public $max_attendees;
216 public $opp_status_code;
221 public $fk_opp_status;
236 public $opp_weighted_amount;
245 public $weekWorkLoad;
246 public $weekWorkLoadPerTask;
251 public $monthWorkLoad;
256 public $monthWorkLoadPerTask;
336 public $fields = array(
337 'rowid' => array(
'type' =>
'integer',
'label' =>
'ID',
'enabled' => 1,
'visible' => -1,
'notnull' => 1,
'position' => 10),
338 'fk_project' => array(
'type' =>
'integer',
'label' =>
'Parent',
'enabled' => 1,
'visible' => 1,
'notnull' => 0,
'position' => 12),
339 'ref' => array(
'type' =>
'varchar(50)',
'label' =>
'Ref',
'enabled' => 1,
'visible' => 1,
'showoncombobox' => 1,
'position' => 15,
'searchall' => 1),
340 'title' => array(
'type' =>
'varchar(255)',
'label' =>
'ProjectLabel',
'enabled' => 1,
'visible' => 1,
'notnull' => 1,
'position' => 17,
'showoncombobox' => 2,
'searchall' => 1),
341 'entity' => array(
'type' =>
'integer',
'label' =>
'Entity',
'default' =>
'1',
'enabled' => 1,
'visible' => 3,
'notnull' => 1,
'position' => 19),
342 'fk_soc' => array(
'type' =>
'integer',
'label' =>
'Thirdparty',
'enabled' => 1,
'visible' => 0,
'position' => 20),
343 'dateo' => array(
'type' =>
'date',
'label' =>
'DateStart',
'enabled' => 1,
'visible' => -1,
'position' => 30),
344 'datee' => array(
'type' =>
'date',
'label' =>
'DateEnd',
'enabled' => 1,
'visible' => 1,
'position' => 35),
345 'description' => array(
'type' =>
'text',
'label' =>
'Description',
'enabled' => 1,
'visible' => 3,
'position' => 55,
'searchall' => 1),
346 'public' => array(
'type' =>
'integer',
'label' =>
'Visibility',
'enabled' => 1,
'visible' => -1,
'position' => 65),
347 'fk_opp_status' => array(
'type' =>
'integer:CLeadStatus:core/class/cleadstatus.class.php',
'label' =>
'OpportunityStatusShort',
'enabled' =>
'getDolGlobalString("PROJECT_USE_OPPORTUNITIES")',
'visible' => 1,
'position' => 75),
348 'opp_percent' => array(
'type' =>
'double(5,2)',
'label' =>
'OpportunityProbabilityShort',
'enabled' =>
'getDolGlobalString("PROJECT_USE_OPPORTUNITIES")',
'visible' => 1,
'position' => 80),
349 'note_private' => array(
'type' =>
'html',
'label' =>
'NotePrivate',
'enabled' => 1,
'visible' => 0,
'position' => 85,
'searchall' => 1),
350 'note_public' => array(
'type' =>
'html',
'label' =>
'NotePublic',
'enabled' => 1,
'visible' => 0,
'position' => 90,
'searchall' => 1),
351 'model_pdf' => array(
'type' =>
'varchar(255)',
'label' =>
'ModelPdf',
'enabled' => 1,
'visible' => 0,
'position' => 95),
352 'date_close' => array(
'type' =>
'datetime',
'label' =>
'DateClosing',
'enabled' => 1,
'visible' => 0,
'position' => 105),
353 'fk_user_close' => array(
'type' =>
'integer',
'label' =>
'UserClosing',
'enabled' => 1,
'visible' => 0,
'position' => 110),
354 'opp_amount' => array(
'type' =>
'double(24,8)',
'label' =>
'OpportunityAmountShort',
'enabled' => 1,
'visible' =>
'getDolGlobalString("PROJECT_USE_OPPORTUNITIES")',
'position' => 115),
355 'budget_amount' => array(
'type' =>
'double(24,8)',
'label' =>
'Budget',
'enabled' => 1,
'visible' => -1,
'position' => 119),
356 'usage_opportunity' => array(
'type' =>
'integer',
'label' =>
'UsageOpportunity',
'enabled' => 1,
'visible' => -1,
'position' => 130),
357 'usage_task' => array(
'type' =>
'integer',
'label' =>
'UsageTasks',
'enabled' => 1,
'visible' => -1,
'position' => 135),
358 'usage_bill_time' => array(
'type' =>
'integer',
'label' =>
'UsageBillTimeShort',
'enabled' => 1,
'visible' => -1,
'position' => 140),
359 'usage_organize_event' => array(
'type' =>
'integer',
'label' =>
'UsageOrganizeEvent',
'enabled' => 1,
'visible' => -1,
'position' => 145),
361 'date_start_event' => array(
'type' =>
'date',
'label' =>
'DateStartEvent',
'enabled' =>
"isModEnabled('eventorganization')",
'visible' => 1,
'position' => 200),
362 'date_end_event' => array(
'type' =>
'date',
'label' =>
'DateEndEvent',
'enabled' =>
"isModEnabled('eventorganization')",
'visible' => 1,
'position' => 201),
363 'location' => array(
'type' =>
'text',
'label' =>
'Location',
'enabled' => 1,
'visible' => 3,
'position' => 55,
'searchall' => 202),
364 'accept_conference_suggestions' => array(
'type' =>
'integer',
'label' =>
'AllowUnknownPeopleSuggestConf',
'enabled' => 1,
'visible' => -1,
'position' => 210),
365 'accept_booth_suggestions' => array(
'type' =>
'integer',
'label' =>
'AllowUnknownPeopleSuggestBooth',
'enabled' => 1,
'visible' => -1,
'position' => 211),
366 'price_registration' => array(
'type' =>
'double(24,8)',
'label' =>
'PriceOfRegistration',
'enabled' => 1,
'visible' => -1,
'position' => 212),
367 'price_booth' => array(
'type' =>
'double(24,8)',
'label' =>
'PriceOfBooth',
'enabled' => 1,
'visible' => -1,
'position' => 215),
368 'max_attendees' => array(
'type' =>
'integer',
'label' =>
'MaxNbOfAttendees',
'enabled' => 1,
'visible' => -1,
'position' => 215),
370 'datec' => array(
'type' =>
'datetime',
'label' =>
'DateCreationShort',
'enabled' => 1,
'visible' => -2,
'position' => 400),
371 'tms' => array(
'type' =>
'timestamp',
'label' =>
'DateModificationShort',
'enabled' => 1,
'visible' => -2,
'notnull' => 1,
'position' => 405),
372 'fk_user_creat' => array(
'type' =>
'integer',
'label' =>
'UserCreation',
'enabled' => 1,
'visible' => 0,
'notnull' => 1,
'position' => 410),
373 'fk_user_modif' => array(
'type' =>
'integer',
'label' =>
'UserModification',
'enabled' => 1,
'visible' => 0,
'position' => 415),
374 'import_key' => array(
'type' =>
'varchar(14)',
'label' =>
'ImportId',
'enabled' => 1,
'visible' => -1,
'position' => 420),
375 'email_msgid' => array(
'type' =>
'varchar(255)',
'label' =>
'EmailMsgID',
'enabled' => 1,
'visible' => -1,
'position' => 450,
'help' =>
'EmailMsgIDWhenSourceisEmail',
'csslist' =>
'tdoverflowmax125'),
376 'fk_statut' => array(
'type' =>
'smallint(6)',
'label' =>
'Status',
'alias' =>
'status',
'enabled' => 1,
'visible' => 1,
'notnull' => 1,
'position' => 500,
'arrayofkeyval' => array(0 =>
'Draft', 1 =>
'Validated', 2 =>
'Closed')),
407 $this->ismultientitymanaged = 1;
408 $this->isextrafieldmanaged = 1;
410 $this->labelStatusShort = array(0 =>
'Draft', 1 =>
'Opened', 2 =>
'Closed');
411 $this->labelStatus = array(0 =>
'Draft', 1 =>
'Opened', 2 =>
'Closed');
416 $this->fields[
'rowid'][
'visible'] = 0;
420 $this->fields[
'fk_opp_status'][
'enabled'] = 0;
421 $this->fields[
'opp_percent'][
'enabled'] = 0;
422 $this->fields[
'opp_amount'][
'enabled'] = 0;
423 $this->fields[
'usage_opportunity'][
'enabled'] = 0;
427 $this->fields[
'usage_bill_time'][
'visible'] = 0;
428 $this->fields[
'usage_task'][
'visible'] = 0;
431 if (empty($conf->eventorganization->enabled)) {
432 $this->fields[
'usage_organize_event'][
'visible'] = 0;
433 $this->fields[
'accept_conference_suggestions'][
'enabled'] = 0;
434 $this->fields[
'accept_booth_suggestions'][
'enabled'] = 0;
435 $this->fields[
'price_registration'][
'enabled'] = 0;
436 $this->fields[
'price_booth'][
'enabled'] = 0;
437 $this->fields[
'max_attendees'][
'enabled'] = 0;
448 public function create($user, $notrigger = 0)
456 $this->note_private =
dol_substr($this->note_private, 0, 65535);
457 $this->note_public =
dol_substr($this->note_public, 0, 65535);
460 if (!trim($this->
ref)) {
461 $this->error =
'ErrorFieldsRequired';
462 dol_syslog(get_class($this).
"::create error -1 ref null", LOG_ERR);
466 $this->error =
'ErrorFieldsRequired';
467 dol_syslog(get_class($this).
"::create error -1 thirdparty not defined and option PROJECT_THIRDPARTY_REQUIRED is set", LOG_ERR);
474 $sql =
"INSERT INTO ".MAIN_DB_PREFIX.
"projet (";
476 $sql .=
", fk_project";
478 $sql .=
", description";
480 $sql .=
", fk_user_creat";
481 $sql .=
", fk_statut";
482 $sql .=
", fk_opp_status";
483 $sql .=
", opp_percent";
488 $sql .=
", opp_amount";
489 $sql .=
", budget_amount";
490 $sql .=
", usage_opportunity";
491 $sql .=
", usage_task";
492 $sql .=
", usage_bill_time";
493 $sql .=
", usage_organize_event";
494 $sql .=
", accept_conference_suggestions";
495 $sql .=
", accept_booth_suggestions";
496 $sql .=
", price_registration";
497 $sql .=
", price_booth";
498 $sql .=
", max_attendees";
499 $sql .=
", date_start_event";
500 $sql .=
", date_end_event";
501 $sql .=
", location";
502 $sql .=
", email_msgid";
503 $sql .=
", note_private";
504 $sql .=
", note_public";
507 $sql .=
") VALUES (";
508 $sql .=
"'".$this->db->escape($this->
ref).
"'";
509 $sql .=
", ".($this->fk_project ? ((int) $this->fk_project) :
"null");
510 $sql .=
", '".$this->db->escape($this->title).
"'";
511 $sql .=
", '".$this->db->escape($this->
description).
"'";
512 $sql .=
", ".($this->socid > 0 ? $this->socid :
"null");
513 $sql .=
", ".((int) $user->id);
514 $sql .=
", ".(is_numeric($this->
status) ? ((int) $this->
status) :
'0');
515 $sql .=
", ".((is_numeric($this->opp_status) && $this->opp_status > 0) ? ((
int) $this->opp_status) :
'NULL');
516 $sql .=
", ".(is_numeric($this->opp_percent) ? ((int) $this->opp_percent) :
'NULL');
517 $sql .=
", ".($this->public ? 1 : 0);
518 $sql .=
", '".$this->db->idate($now).
"'";
519 $sql .=
", ".($this->date_start !=
'' ?
"'".$this->db->idate($this->date_start).
"'" :
'null');
520 $sql .=
", ".($this->date_end !=
'' ?
"'".$this->db->idate($this->date_end).
"'" :
'null');
521 $sql .=
", ".(strcmp($this->opp_amount,
'') ?
price2num($this->opp_amount) :
'null');
522 $sql .=
", ".(strcmp((
string) $this->budget_amount,
'') ?
price2num($this->budget_amount) :
'null');
523 $sql .=
", ".($this->usage_opportunity ? 1 : 0);
524 $sql .=
", ".($this->usage_task ? 1 : 0);
525 $sql .=
", ".($this->usage_bill_time ? 1 : 0);
526 $sql .=
", ".($this->usage_organize_event ? 1 : 0);
527 $sql .=
", ".($this->accept_conference_suggestions ? 1 : 0);
528 $sql .=
", ".($this->accept_booth_suggestions ? 1 : 0);
529 $sql .=
", ".(strcmp((
string) $this->price_registration,
'') ?
price2num($this->price_registration) :
'null');
530 $sql .=
", ".(strcmp((
string) $this->price_booth,
'') ?
price2num($this->price_booth) :
'null');
531 $sql .=
", ".(strcmp((
string) $this->max_attendees,
'') ? ((
int) $this->max_attendees) :
'null');
532 $sql .=
", ".($this->date_start_event !=
'' ?
"'".$this->db->idate($this->date_start_event).
"'" :
'null');
533 $sql .=
", ".($this->date_end_event !=
'' ?
"'".$this->db->idate($this->date_end_event).
"'" :
'null');
534 $sql .=
", ".($this->location ?
"'".$this->db->escape($this->location).
"'" :
'null');
535 $sql .=
", ".($this->email_msgid ?
"'".$this->db->escape($this->email_msgid).
"'" :
'null');
536 $sql .=
", ".($this->note_private ?
"'".$this->db->escape($this->note_private).
"'" :
'null');
537 $sql .=
", ".($this->note_public ?
"'".$this->db->escape($this->note_public).
"'" :
'null');
538 $sql .=
", ".setEntity($this);
539 $sql .=
", ".(!isset($this->ip) ?
'NULL' :
"'".$this->db->escape($this->ip).
"'");
542 dol_syslog(get_class($this).
"::create", LOG_DEBUG);
543 $resql = $this->db->query($sql);
545 $this->
id = $this->db->last_insert_id(MAIN_DB_PREFIX.
"projet");
557 $this->error = $this->db->lasterror();
580 $this->db->rollback();
592 public function update($user, $notrigger = 0)
594 global $langs, $conf;
599 $this->title = trim($this->title);
601 if ($this->opp_amount < 0) {
602 $this->opp_amount =
'';
604 if ($this->opp_percent < 0) {
605 $this->opp_percent =
'';
607 if ($this->date_end && $this->date_end < $this->date_start) {
608 $this->error = $langs->trans(
"ErrorDateEndLowerThanDateStart");
609 $this->errors[] = $this->error;
610 $this->db->rollback();
611 dol_syslog(get_class($this).
"::update error -3 ".$this->error, LOG_ERR);
615 $this->entity = ((isset($this->entity) && is_numeric($this->entity)) ? $this->entity : $conf->entity);
620 $sql =
"UPDATE ".MAIN_DB_PREFIX.
"projet SET";
621 $sql .=
" ref='".$this->db->escape($this->
ref).
"'";
622 $sql .=
", fk_project=".($this->fk_project ? ((int) $this->fk_project) :
"null");
623 $sql .=
", title = '".$this->db->escape($this->title).
"'";
624 $sql .=
", description = '".$this->db->escape($this->
description).
"'";
625 $sql .=
", fk_soc = ".($this->socid > 0 ? $this->socid :
"null");
626 $sql .=
", fk_statut = ".((int) $this->
status);
627 $sql .=
", fk_opp_status = ".((is_numeric($this->opp_status) && $this->opp_status > 0) ? $this->opp_status :
'null');
628 $sql .=
", opp_percent = ".((is_numeric($this->opp_percent) && $this->opp_percent !=
'') ? $this->opp_percent :
'null');
629 $sql .=
", public = ".($this->public ? 1 : 0);
630 $sql .=
", datec = ".($this->date_c !=
'' ?
"'".$this->db->idate($this->date_c).
"'" :
'null');
631 $sql .=
", dateo = ".($this->date_start !=
'' ?
"'".$this->db->idate($this->date_start).
"'" :
'null');
632 $sql .=
", datee = ".($this->date_end !=
'' ?
"'".$this->db->idate($this->date_end).
"'" :
'null');
633 $sql .=
", date_close = ".($this->date_close !=
'' ?
"'".$this->db->idate($this->date_close).
"'" :
'null');
634 $sql .=
", note_public = ".($this->note_public ?
"'".$this->db->escape($this->note_public).
"'" :
"null");
635 $sql .=
", note_private = ".($this->note_private ?
"'".$this->db->escape($this->note_private).
"'" :
"null");
636 $sql .=
", fk_user_close = ".($this->fk_user_close > 0 ? $this->fk_user_close :
"null");
637 $sql .=
", opp_amount = ".(strcmp($this->opp_amount,
'') ?
price2num($this->opp_amount) :
"null");
638 $sql .=
", budget_amount = ".(strcmp($this->budget_amount,
'') ?
price2num($this->budget_amount) :
"null");
639 $sql .=
", fk_user_modif = ".$user->id;
640 $sql .=
", usage_opportunity = ".($this->usage_opportunity ? 1 : 0);
641 $sql .=
", usage_task = ".($this->usage_task ? 1 : 0);
642 $sql .=
", usage_bill_time = ".($this->usage_bill_time ? 1 : 0);
643 $sql .=
", usage_organize_event = ".($this->usage_organize_event ? 1 : 0);
644 $sql .=
", accept_conference_suggestions = ".($this->accept_conference_suggestions ? 1 : 0);
645 $sql .=
", accept_booth_suggestions = ".($this->accept_booth_suggestions ? 1 : 0);
646 $sql .=
", price_registration = ".(isset($this->price_registration) && strcmp($this->price_registration,
'') ?
price2num($this->price_registration) :
"null");
647 $sql .=
", price_booth = ".(isset($this->price_booth) && strcmp((
string) $this->price_booth,
'') ?
price2num($this->price_booth) :
"null");
648 $sql .=
", max_attendees = ".(strcmp((
string) $this->max_attendees,
'') ? (
int) $this->max_attendees :
"null");
649 $sql .=
", date_start_event = ".($this->date_start_event !=
'' ?
"'".$this->db->idate($this->date_start_event).
"'" :
'null');
650 $sql .=
", date_end_event = ".($this->date_end_event !=
'' ?
"'".$this->db->idate($this->date_end_event).
"'" :
'null');
651 $sql .=
", location = '".$this->db->escape($this->location).
"'";
652 $sql .=
", entity = ".((int) $this->entity);
653 $sql .=
" WHERE rowid = ".((int) $this->
id);
655 dol_syslog(get_class($this).
"::update", LOG_DEBUG);
656 $resql = $this->db->query($sql);
666 if (!$error && !$notrigger) {
675 if (!$error && (is_object($this->oldcopy) && $this->oldcopy->ref !== $this->ref)) {
677 if ($conf->project->dir_output) {
680 if (file_exists($olddir)) {
681 include_once DOL_DOCUMENT_ROOT.
'/core/lib/files.lib.php';
682 $res = @rename($olddir, $newdir);
684 $langs->load(
"errors");
685 $this->error = $langs->trans(
'ErrorFailToRenameDir', $olddir, $newdir);
695 $this->db->rollback();
699 $this->error = $this->db->lasterror();
700 $this->errors[] = $this->error;
701 $this->db->rollback();
702 if ($this->db->lasterrno() ==
'DB_ERROR_RECORD_ALREADY_EXISTS') {
707 dol_syslog(get_class($this).
"::update error ".$result.
" ".$this->error, LOG_ERR);
710 dol_syslog(get_class($this).
"::update ref null");
726 public function fetch($id, $ref =
'', $ref_ext =
'', $email_msgid =
'')
728 if (empty($id) && empty($ref) && empty($ref_ext) && empty($email_msgid)) {
729 dol_syslog(get_class($this).
"::fetch Bad parameters", LOG_WARNING);
733 $sql =
"SELECT rowid, entity, fk_project, ref, title, description, public, datec, opp_amount, budget_amount,";
734 $sql .=
" tms, dateo as date_start, datee as date_end, date_close, fk_soc, fk_user_creat, fk_user_modif, fk_user_close, fk_statut as status, fk_opp_status, opp_percent,";
735 $sql .=
" note_private, note_public, model_pdf, usage_opportunity, usage_task, usage_bill_time, usage_organize_event, email_msgid,";
736 $sql .=
" accept_conference_suggestions, accept_booth_suggestions, price_registration, price_booth, max_attendees, date_start_event, date_end_event, location, extraparams";
737 $sql .=
" FROM ".MAIN_DB_PREFIX.
"projet";
739 $sql .=
" WHERE rowid = ".((int) $id);
741 $sql .=
" WHERE entity IN (".getEntity(
'project').
")";
743 $sql .=
" AND ref = '".$this->db->escape($ref).
"'";
744 } elseif (!empty($ref_ext)) {
745 $sql .=
" AND ref_ext = '".$this->db->escape($ref_ext).
"'";
747 $sql .=
" AND email_msgid = '".$this->db->escape($email_msgid).
"'";
751 dol_syslog(get_class($this).
"::fetch", LOG_DEBUG);
752 $resql = $this->db->query($sql);
754 $num_rows = $this->db->num_rows($resql);
757 $obj = $this->db->fetch_object($resql);
759 $this->
id = $obj->rowid;
760 $this->entity = $obj->entity;
761 $this->
ref = $obj->ref;
762 $this->fk_project = $obj->fk_project;
763 $this->title = $obj->title;
765 $this->date_c = $this->db->jdate($obj->datec);
766 $this->datec = $this->db->jdate($obj->datec);
767 $this->date_m = $this->db->jdate($obj->tms);
768 $this->datem = $this->db->jdate($obj->tms);
769 $this->date_start = $this->db->jdate($obj->date_start);
770 $this->date_end = $this->db->jdate($obj->date_end);
771 $this->date_close = $this->db->jdate($obj->date_close);
772 $this->note_private = $obj->note_private;
773 $this->note_public = $obj->note_public;
774 $this->socid = $obj->fk_soc;
775 $this->user_author_id = $obj->fk_user_creat;
776 $this->user_modification_id = $obj->fk_user_modif;
777 $this->user_closing_id = $obj->fk_user_close;
778 $this->
public = $obj->public;
779 $this->statut = $obj->status;
780 $this->
status = $obj->status;
781 $this->opp_status = $obj->fk_opp_status;
782 $this->opp_amount = $obj->opp_amount;
783 $this->opp_percent = $obj->opp_percent;
784 $this->budget_amount = $obj->budget_amount;
785 $this->model_pdf = $obj->model_pdf;
786 $this->usage_opportunity = (int) $obj->usage_opportunity;
787 $this->usage_task = (int) $obj->usage_task;
788 $this->usage_bill_time = (int) $obj->usage_bill_time;
789 $this->usage_organize_event = (int) $obj->usage_organize_event;
790 $this->accept_conference_suggestions = (int) $obj->accept_conference_suggestions;
791 $this->accept_booth_suggestions = (int) $obj->accept_booth_suggestions;
792 $this->price_registration = $obj->price_registration;
793 $this->price_booth = $obj->price_booth;
794 $this->max_attendees = $obj->max_attendees;
795 $this->date_start_event = $this->db->jdate($obj->date_start_event);
796 $this->date_end_event = $this->db->jdate($obj->date_end_event);
797 $this->location = $obj->location;
798 $this->email_msgid = $obj->email_msgid;
799 $this->extraparams = !empty($obj->extraparams) ? (array) json_decode($obj->extraparams,
true) : array();
801 $this->db->free($resql);
810 $this->db->free($resql);
814 $this->error = $this->db->lasterror();
815 $this->errors[] = $this->db->lasterror();
832 if ($fetched ===
false) {
833 $res = $this->
fetch($id);
839 if ($fetched ===
true) {
840 if ($key ==
'__PROJECT_ID__') {
841 $substitution = ($this->
id > 0 ? $this->id :
'');
842 } elseif ($key ==
'__PROJECT_REF__') {
843 $substitution = $this->ref;
844 } elseif ($key ==
'__PROJECT_NAME__') {
845 $substitution = $this->title;
849 return $substitution;
864 public function get_element_list($type, $tablename, $datefieldname =
'', $date_start =
null, $date_end =
null, $projectkey =
'fk_projet')
872 if ($this->
id <= 0) {
878 if ($type ==
'agenda') {
879 $sql =
"SELECT id as rowid FROM ".MAIN_DB_PREFIX.
"actioncomm WHERE fk_project IN (".$this->db->sanitize($ids).
") AND entity IN (".
getEntity(
'agenda').
")";
880 } elseif ($type ==
'expensereport') {
881 $sql =
"SELECT ed.rowid FROM ".MAIN_DB_PREFIX.
"expensereport as e, ".MAIN_DB_PREFIX.
"expensereport_det as ed WHERE e.rowid = ed.fk_expensereport AND e.entity IN (".
getEntity(
'expensereport').
") AND ed.fk_projet IN (".$this->db->sanitize($ids).
")";
882 } elseif ($type ==
'project_task') {
883 $sql =
"SELECT DISTINCT pt.rowid FROM ".MAIN_DB_PREFIX.
"projet_task as pt WHERE pt.fk_projet IN (".$this->db->sanitize($ids).
")";
884 } elseif ($type ==
'element_time') {
885 $sql =
"SELECT DISTINCT pt.rowid, ptt.fk_user FROM ".MAIN_DB_PREFIX.
"projet_task as pt, ".MAIN_DB_PREFIX.
"element_time as ptt WHERE pt.rowid = ptt.fk_element AND ptt.elementtype = 'task' AND pt.fk_projet IN (".$this->db->sanitize($ids).
")";
886 } elseif ($type ==
'stocktransfer_stocktransfer') {
887 $sql =
"SELECT ms.rowid, ms.fk_user_author as fk_user FROM ".MAIN_DB_PREFIX.
"stocktransfer_stocktransfer as ms, ".MAIN_DB_PREFIX.
"entrepot as e WHERE e.rowid = ms.fk_entrepot AND e.entity IN (".
getEntity(
'stock').
") AND ms.origintype = 'project' AND ms.fk_origin IN (".$this->db->sanitize($ids).
") AND ms.type_mouvement = 1";
888 } elseif ($type ==
'loan') {
889 $sql =
"SELECT l.rowid, l.fk_user_author as fk_user FROM ".MAIN_DB_PREFIX.
"loan as l WHERE l.entity IN (".
getEntity(
'loan').
") AND l.fk_projet IN (".$this->db->sanitize($ids).
")";
891 $sql =
"SELECT rowid FROM ".MAIN_DB_PREFIX.$tablename.
" WHERE ".$projectkey.
" IN (".$this->db->sanitize($ids).
") AND entity IN (".
getEntity($type).
")";
894 if (
isDolTms($date_start) && $type ==
'loan') {
895 $sql .=
" AND (dateend > '".$this->db->idate($date_start).
"' OR dateend IS NULL)";
896 } elseif (
isDolTms($date_start) && ($type !=
'project_task')) {
897 if (empty($datefieldname) && !empty($this->table_element_date)) {
898 $datefieldname = $this->table_element_date;
900 if (empty($datefieldname)) {
901 return 'Error this object has no date field defined';
903 $sql .=
" AND (".$datefieldname.
" >= '".$this->db->idate($date_start).
"' OR ".$datefieldname.
" IS NULL)";
906 if (
isDolTms($date_end) && $type ==
'loan') {
907 $sql .=
" AND (datestart < '".$this->db->idate($date_end).
"' OR datestart IS NULL)";
908 } elseif (
isDolTms($date_end) && ($type !=
'project_task')) {
909 if (empty($datefieldname) && !empty($this->table_element_date)) {
910 $datefieldname = $this->table_element_date;
912 if (empty($datefieldname)) {
913 return 'Error this object has no date field defined';
915 $sql .=
" AND (".$datefieldname.
" <= '".$this->db->idate($date_end).
"' OR ".$datefieldname.
" IS NULL)";
921 'tablename' => $tablename,
922 'datefieldname' => $datefieldname,
923 'dates' => $date_start,
924 'datee' => $date_end,
925 'fk_projet' => $projectkey,
928 $reshook = $hookmanager->executeHooks(
'getElementList', $parameters);
930 $sql = $hookmanager->resPrint;
932 $sql .= $hookmanager->resPrint;
940 dol_syslog(get_class($this).
"::get_element_list", LOG_DEBUG);
941 $result = $this->db->query($sql);
943 $nump = $this->db->num_rows($result);
947 $obj = $this->db->fetch_object($result);
949 $elements[$i] = $obj->rowid.(empty($obj->fk_user) ?
'' :
'_'.$obj->fk_user);
953 $this->db->free($result);
971 public function delete($user, $notrigger = 0)
973 global $langs, $conf;
974 require_once DOL_DOCUMENT_ROOT.
'/core/lib/files.lib.php';
984 $this->error =
'ErrorFailToDeleteLinkedContact';
986 $this->db->rollback();
992 $listoftables = array(
993 'propal' =>
'fk_projet',
994 'commande' =>
'fk_projet',
995 'facture' =>
'fk_projet',
996 'supplier_proposal' =>
'fk_projet',
997 'commande_fournisseur' =>
'fk_projet',
998 'facture_fourn' =>
'fk_projet',
999 'expensereport_det' =>
'fk_projet',
1000 'contrat' =>
'fk_projet',
1001 'fichinter' =>
'fk_projet',
1002 'don' => array(
'field' =>
'fk_projet',
'module' =>
'don'),
1003 'actioncomm' =>
'fk_project',
1004 'mrp_mo' =>
'fk_project',
1005 'entrepot' =>
'fk_project',
1007 foreach ($listoftables as $key => $value) {
1008 if (is_array($value)) {
1009 if (!isModEnabled($value[
'module'])) {
1012 $fieldname = $value[
'field'];
1014 $fieldname = $value;
1016 $sql =
"UPDATE ".MAIN_DB_PREFIX.$key.
" SET ".$fieldname.
" = NULL where ".$fieldname.
" = ".((int) $this->
id);
1018 $resql = $this->db->query($sql);
1020 $this->errors[] = $this->db->lasterror();
1028 $sql =
"DELETE FROM ".MAIN_DB_PREFIX.
"categorie_project";
1029 $sql .=
" WHERE fk_project = ".((int) $this->
id);
1031 $result = $this->db->query($sql);
1034 $this->errors[] = $this->db->lasterror();
1050 $elements = array(
'categorie_project');
1051 foreach ($elements as $table) {
1053 $sql =
"DELETE FROM ".MAIN_DB_PREFIX.$table;
1054 $sql .=
" WHERE fk_project = ".((int) $this->
id);
1056 $result = $this->db->query($sql);
1059 $this->errors[] = $this->db->lasterror();
1066 $sql =
"DELETE FROM ".MAIN_DB_PREFIX.
"projet_extrafields";
1067 $sql .=
" WHERE fk_object = ".((int) $this->
id);
1069 $resql = $this->db->query($sql);
1071 $this->errors[] = $this->db->lasterror();
1078 $sql =
"DELETE FROM ".MAIN_DB_PREFIX.
"projet";
1079 $sql .=
" WHERE rowid=".((int) $this->
id);
1081 $resql = $this->db->query($sql);
1083 $this->errors[] = $langs->trans(
"CantRemoveProject", $langs->transnoentitiesnoconv(
"ProjectOverview"));
1090 if (empty($error)) {
1093 if ($conf->project->dir_output) {
1094 $dir = $conf->project->dir_output.
"/".$projectref;
1095 if (file_exists($dir)) {
1098 $this->errors[] =
'ErrorFailToDeleteDir';
1106 $result = $this->
call_trigger(
'PROJECT_DELETE', $user);
1115 if (empty($error)) {
1116 $this->db->commit();
1119 foreach ($this->errors as $errmsg) {
1120 dol_syslog(get_class($this).
"::delete ".$errmsg, LOG_ERR);
1121 $this->error .= ($this->error ?
', '.$errmsg : $errmsg);
1123 dol_syslog(get_class($this).
"::delete ".$this->error, LOG_ERR);
1124 $this->db->rollback();
1139 if ($this->
id <= 0) {
1143 if ($type ==
'agenda') {
1144 $sql =
"SELECT COUNT(id) as nb FROM ".MAIN_DB_PREFIX.
"actioncomm WHERE fk_project = ".((int) $this->
id).
" AND entity IN (".
getEntity(
'agenda').
")";
1145 } elseif ($type ==
'expensereport') {
1146 $sql =
"SELECT COUNT(ed.rowid) as nb FROM ".MAIN_DB_PREFIX.
"expensereport as e, ".MAIN_DB_PREFIX.
"expensereport_det as ed WHERE e.rowid = ed.fk_expensereport AND e.entity IN (".
getEntity(
'expensereport').
") AND ed.fk_projet = ".((int) $this->
id);
1147 } elseif ($type ==
'project_task') {
1148 $sql =
"SELECT DISTINCT COUNT(pt.rowid) as nb FROM ".MAIN_DB_PREFIX.
"projet_task as pt WHERE pt.fk_projet = ".((int) $this->
id);
1149 } elseif ($type ==
'element_time') {
1150 $sql =
"SELECT DISTINCT COUNT(pt.rowid) as nb FROM ".MAIN_DB_PREFIX.
"projet_task as pt, ".MAIN_DB_PREFIX.
"element_time as ptt WHERE pt.rowid = ptt.fk_element AND ptt.elementtype = 'task' AND pt.fk_projet = ".((int) $this->
id);
1151 } elseif ($type ==
'stock_mouvement') {
1152 $sql =
"SELECT COUNT(ms.rowid) as nb FROM ".MAIN_DB_PREFIX.
"stock_mouvement as ms, ".MAIN_DB_PREFIX.
"entrepot as e WHERE e.rowid = ms.fk_entrepot AND e.entity IN (".
getEntity(
'stock').
") AND ms.origintype = 'project' AND ms.fk_origin = ".((int) $this->
id).
" AND ms.type_mouvement = 1";
1153 } elseif ($type ==
'loan') {
1154 $sql =
"SELECT COUNT(l.rowid) as nb FROM ".MAIN_DB_PREFIX.
"loan as l WHERE l.entity IN (".
getEntity(
'loan').
") AND l.fk_projet = ".((int) $this->
id);
1156 $sql =
"SELECT COUNT(rowid) as nb FROM ".MAIN_DB_PREFIX.$tablename.
" WHERE ".$projectkey.
" = ".((int) $this->
id).
" AND entity IN (".
getEntity($type).
")";
1159 $result = $this->db->query($sql);
1165 $obj = $this->db->fetch_object($result);
1167 $this->db->free($result);
1180 $countTasks = count($this->lines);
1183 foreach ($this->lines as $task) {
1184 if ($task->hasChildren() <= 0) {
1186 $ret = $task->delete($user);
1188 $this->errors[] = $this->db->lasterror();
1195 if ($deleted && count($this->lines) < $countTasks) {
1196 if (count($this->lines)) {
1218 if ($this->
status == self::STATUS_VALIDATED) {
1219 dol_syslog(get_class($this).
"::validate action abandoned: already validated", LOG_WARNING);
1224 if (preg_match(
'/^'.preg_quote($langs->trans(
"CopyOf").
' ').
'/', $this->title)) {
1225 $this->error = $langs->trans(
"ErrorFieldFormat", $langs->transnoentities(
"Label")).
'. '.$langs->trans(
'RemoveString', $langs->transnoentitiesnoconv(
"CopyOf"));
1231 $sql =
"UPDATE ".MAIN_DB_PREFIX.
"projet";
1232 $sql .=
" SET fk_statut = ".self::STATUS_VALIDATED;
1233 $sql .=
" WHERE rowid = ".((int) $this->
id);
1236 dol_syslog(get_class($this).
"::setValid", LOG_DEBUG);
1237 $resql = $this->db->query($sql);
1240 if (empty($notrigger)) {
1241 $result = $this->
call_trigger(
'PROJECT_VALIDATE', $user);
1251 $this->db->commit();
1254 $this->db->rollback();
1255 $this->error = implode(
',', $this->errors);
1256 dol_syslog(get_class($this).
"::setValid ".$this->error, LOG_ERR);
1260 $this->db->rollback();
1261 $this->error = $this->db->lasterror();
1278 if ($this->
status != self::STATUS_CLOSED) {
1281 $sql =
"UPDATE ".MAIN_DB_PREFIX.
"projet";
1282 $sql .=
" SET fk_statut = ".self::STATUS_CLOSED.
", fk_user_close = ".((int) $user->id).
", date_close = '".$this->db->idate($now).
"'";
1283 $sql .=
" WHERE rowid = ".((int) $this->
id);
1284 $sql .=
" AND fk_statut = ".self::STATUS_VALIDATED;
1290 dol_syslog(get_class($this).
"::setClose", LOG_DEBUG);
1291 $resql = $this->db->query($sql);
1302 $this->db->commit();
1305 $this->db->rollback();
1306 $this->error = implode(
',', $this->errors);
1307 dol_syslog(get_class($this).
"::setClose ".$this->error, LOG_ERR);
1311 $this->db->rollback();
1312 $this->error = $this->db->lasterror();
1344 if (is_null($status)) {
1348 $statustrans = array(
1354 $statusClass =
'status0';
1355 if (!empty($statustrans[$status])) {
1356 $statusClass = $statustrans[$status];
1359 return dolGetStatus($langs->transnoentitiesnoconv($this->labelStatus[$status]), $langs->transnoentitiesnoconv($this->labelStatusShort[$status]),
'', $statusClass, $mode);
1371 global $conf, $langs;
1373 $langs->load(
'projects');
1374 $option = $params[
'option'] ??
'';
1375 $moreinpopup = $params[
'moreinpopup'] ??
'';
1378 if ($option !=
'nolink') {
1379 $datas[
'picto'] =
img_picto(
'', $this->picto,
'class="pictofixedwidth"').
' <u class="paddingrightonly">'.$langs->trans(
"Project").
'</u>';
1381 if (isset($this->
status)) {
1382 $datas[
'picto'] .=
' '.$this->getLibStatut(5);
1384 $datas[
'ref'] = (isset($datas[
'picto']) ?
'<br>' :
'').
'<b>'.$langs->trans(
'Ref').
': </b>'.$this->ref;
1385 $datas[
'label'] =
'<br><b>'.$langs->trans(
'Label').
': </b>'.$this->title;
1386 if (isset($this->
public)) {
1387 $datas[
'visibility'] =
'<br><b>'.$langs->trans(
"Visibility").
":</b> ";
1388 $datas[
'visibility'] .= ($this->
public ?
img_picto($langs->trans(
'SharedProject'),
'world',
'class="pictofixedwidth"').$langs->trans(
"SharedProject") :
img_picto($langs->trans(
'PrivateProject'),
'private',
'class="pictofixedwidth"').$langs->trans(
"PrivateProject"));
1390 if (!empty($this->thirdparty_name)) {
1391 $datas[
'thirdparty'] =
'<br><b>'.$langs->trans(
'ThirdParty').
': </b>'.$this->thirdparty_name;
1393 if (!empty($this->date_start)) {
1394 $datas[
'datestart'] =
'<br><b>'.$langs->trans(
'DateStart').
': </b>'.
dol_print_date($this->date_start,
'day');
1396 if (!empty($this->date_end)) {
1397 $datas[
'dateend'] =
'<br><b>'.$langs->trans(
'DateEnd').
': </b>'.
dol_print_date($this->date_end,
'day');
1400 $datas[
'moreinpopup'] =
'<br>'.$moreinpopup;
1420 public function getNomUrl($withpicto = 0, $option =
'', $addlabel = 0, $moreinpopup =
'', $sep =
' - ', $notooltip = 0, $save_lastsearch_value = -1, $morecss =
'', $save_pageforbacktolist =
'')
1422 global $conf, $langs, $user, $hookmanager;
1424 if (!empty($conf->dol_no_mouse_hover)) {
1434 'objecttype' => $this->element,
1435 'moreinpopup' => $moreinpopup,
1436 'option' => $option,
1438 $classfortooltip =
'classfortooltip';
1441 $classfortooltip =
'classforajaxtooltip';
1442 $dataparams =
' data-params="'.dol_escape_htmltag(json_encode($params)).
'"';
1449 if ($option !=
'nolink') {
1450 if (preg_match(
'/\.php$/', $option)) {
1452 } elseif ($option ==
'task') {
1453 $url = DOL_URL_ROOT.
'/projet/tasks.php?id='.$this->id;
1454 } elseif ($option ==
'preview') {
1455 $url = DOL_URL_ROOT.
'/projet/element.php?id='.$this->id;
1456 } elseif ($option ==
'eventorganization') {
1457 $url = DOL_URL_ROOT.
'/eventorganization/conferenceorbooth_list.php?projectid='.$this->id;
1459 $url = DOL_URL_ROOT.
'/projet/card.php?id='.$this->id;
1462 $add_save_lastsearch_values = ($save_lastsearch_value == 1 ? 1 : 0);
1463 if ($save_lastsearch_value == -1 && isset($_SERVER[
"PHP_SELF"]) && preg_match(
'/list\.php/', $_SERVER[
"PHP_SELF"])) {
1464 $add_save_lastsearch_values = 1;
1466 if ($add_save_lastsearch_values) {
1467 $url .=
'&save_lastsearch_values=1';
1469 $add_save_backpagefor = ($save_pageforbacktolist ? 1 : 0);
1470 if ($add_save_backpagefor) {
1471 $url .=
"&save_pageforbacktolist=".urlencode($save_pageforbacktolist);
1476 if (empty($notooltip) && $user->hasRight(
'projet',
'lire')) {
1478 $label = $langs->trans(
"ShowProject");
1479 $linkclose .=
' alt="'.dol_escape_htmltag($label, 1).
'"';
1481 $linkclose .= ($label ?
' title="'.dol_escape_htmltag($label, 1).
'"' :
' title="tocomplete"');
1482 $linkclose .= $dataparams.
' class="'.$classfortooltip.($morecss ?
' '.$morecss :
'').
'"';
1484 $linkclose = ($morecss ?
' class="'.$morecss.
'"' :
'');
1487 $picto =
'projectpub';
1488 if (!$this->
public) {
1492 $linkstart =
'<a href="'.$url.
'"';
1493 $linkstart .= $linkclose.
'>';
1496 $result .= $linkstart;
1498 $result .=
img_object(($notooltip ?
'' : $label), $picto,
'class="pictofixedwidth em088"', 0, 0, $notooltip ? 0 : 1);
1500 if ($withpicto != 2) {
1501 $result .= $this->ref;
1503 $result .= $linkend;
1504 if ($withpicto != 2) {
1505 $result .= (($addlabel && $this->title) ?
'<span class="opacitymedium">'.$sep.dol_trunc($this->title, ($addlabel > 1 ? $addlabel : 0)).
'</span>' :
'');
1509 $hookmanager->initHooks(array(
'projectdao'));
1510 $parameters = array(
'id' => $this->
id,
'getnomurl' => &$result);
1511 $reshook = $hookmanager->executeHooks(
'getNomUrl', $parameters, $this, $action);
1513 $result = $hookmanager->resPrint;
1515 $result .= $hookmanager->resPrint;
1530 global $user, $langs, $conf;
1536 $this->
ref =
'SPECIMEN';
1537 $this->entity = $conf->entity;
1538 $this->specimen = 1;
1540 $this->date_c = $now;
1541 $this->date_m = $now;
1542 $this->date_start = $now;
1543 $this->date_end = $now + (3600 * 24 * 365);
1544 $this->note_public =
'SPECIMEN';
1545 $this->note_private =
'Private Note';
1546 $this->fk_project = 0;
1547 $this->opp_amount = 20000;
1548 $this->budget_amount = 10000;
1550 $this->usage_opportunity = 1;
1551 $this->usage_task = 1;
1552 $this->usage_bill_time = 1;
1553 $this->usage_organize_event = 1;
1584 if (($mode ==
'read' && $user->hasRight(
'projet',
'all',
'lire')) || ($mode ==
'write' && $user->hasRight(
'projet',
'all',
'creer')) || ($mode ==
'delete' && $user->hasRight(
'projet',
'all',
'supprimer'))) {
1586 } elseif ($this->
public && (($mode ==
'read' && $user->hasRight(
'projet',
'lire')) || ($mode ==
'write' && $user->hasRight(
'projet',
'creer')) || ($mode ==
'delete' && $user->hasRight(
'projet',
'supprimer')))) {
1589 foreach (array(
'internal',
'external') as $source) {
1591 $num = count($userRole);
1594 while ($nblinks < $num) {
1595 if ($source ==
'internal' && $user->id == $userRole[$nblinks][
'id']) {
1596 if ($mode ==
'read' && $user->hasRight(
'projet',
'lire')) {
1599 if ($mode ==
'write' && $user->hasRight(
'projet',
'creer')) {
1602 if ($mode ==
'delete' && $user->hasRight(
'projet',
'supprimer')) {
1606 if ($source ==
'external' && $user->socid > 0 && $user->socid == $userRole[$nblinks][
'socid']) {
1607 if ($mode ==
'read' && $user->hasRight(
'projet',
'lire')) {
1610 if ($mode ==
'write' && $user->hasRight(
'projet',
'creer')) {
1613 if ($mode ==
'delete' && $user->hasRight(
'projet',
'supprimer')) {
1629 return ($userAccess ? $userAccess : -1);
1644 $projects = array();
1647 $sql =
"SELECT ".(($mode == 0 || $mode == 1) ?
"DISTINCT " :
"").
"p.rowid, p.ref";
1648 $sql .=
" FROM ".MAIN_DB_PREFIX.
"projet as p";
1650 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"element_contact as ec ON ec.element_id = p.rowid";
1651 } elseif ($mode == 1) {
1652 $sql .=
", ".MAIN_DB_PREFIX.
"element_contact as ec";
1653 } elseif ($mode == 2) {
1656 $sql .=
" WHERE p.entity IN (".getEntity(
'project').
")";
1660 $sql .=
" AND (p.fk_soc IS NULL OR p.fk_soc = 0 OR p.fk_soc = ".((int) $socid).
")";
1664 $listofprojectcontacttype = array();
1665 $sql2 =
"SELECT ctc.rowid, ctc.code FROM ".MAIN_DB_PREFIX.
"c_type_contact as ctc";
1666 $sql2 .=
" WHERE ctc.element = '".$this->db->escape($this->element).
"'";
1667 $sql2 .=
" AND ctc.source = 'internal'";
1668 $resql = $this->db->query($sql2);
1670 while ($obj = $this->db->fetch_object($resql)) {
1671 $listofprojectcontacttype[$obj->rowid] = $obj->code;
1676 if (count($listofprojectcontacttype) == 0) {
1677 $listofprojectcontacttype[0] =
'0';
1681 $sql .=
" AND ( p.public = 1";
1682 $sql .=
" OR ( ec.fk_c_type_contact IN (".$this->db->sanitize(implode(
',', array_keys($listofprojectcontacttype))).
")";
1683 $sql .=
" AND ec.fk_socpeople = ".((int) $user->id).
")";
1685 } elseif ($mode == 1) {
1686 $sql .=
" AND ec.element_id = p.rowid";
1688 $sql .=
" ( ec.fk_c_type_contact IN (".$this->db->sanitize(implode(
',', array_keys($listofprojectcontacttype))).
")";
1689 $sql .=
" AND ec.fk_socpeople = ".((int) $user->id).
")";
1691 } elseif ($mode == 2) {
1698 $resql = $this->db->query($sql);
1700 $num = $this->db->num_rows($resql);
1703 $row = $this->db->fetch_row($resql);
1704 $projects[$row[0]] = $row[1];
1709 $this->db->free($resql);
1715 $result = implode(
',', $temp);
1740 public function createFromClone(
User $user, $fromid, $clone_contact =
false, $clone_task =
true, $clone_project_file =
false, $clone_task_file =
false, $clone_note =
true, $move_date =
true, $notrigger = 0, $newthirdpartyid = 0)
1742 global $langs, $conf;
1745 $clone_project_id = 0;
1747 dol_syslog(
"createFromClone clone_contact=".json_encode($clone_contact).
" clone_task=".json_encode($clone_task).
" clone_project_file=".json_encode($clone_project_file).
" clone_note=".json_encode($clone_note).
" move_date=".json_encode($move_date), LOG_DEBUG);
1751 $clone_project =
new Project($this->db);
1753 $clone_project->context[
'createfromclone'] =
'createfromclone';
1758 $clone_project->fetch($fromid);
1759 $clone_project->fetch_optionals();
1760 if ($newthirdpartyid > 0) {
1761 $clone_project->socid = $newthirdpartyid;
1763 $clone_project->fetch_thirdparty();
1765 $orign_dt_start = $clone_project->date_start;
1766 $orign_project_ref = $clone_project->ref;
1768 $clone_project->id = 0;
1770 $clone_project->date_start = $now;
1771 if (!(empty($clone_project->date_end))) {
1772 $clone_project->date_end += ($now - $orign_dt_start);
1776 $clone_project->date_c = $now;
1779 $clone_project->note_private =
'';
1780 $clone_project->note_public =
'';
1790 $dirmodels = array_merge(array(
'/'), (array) $conf->modules_parts[
'models']);
1791 foreach ($dirmodels as $reldir) {
1792 $file =
dol_buildpath($reldir.
"core/modules/project/".$obj.
'.php', 0);
1793 if (file_exists($file)) {
1796 $modProject =
new $obj();
1797 $defaultref = $modProject->getNextValue(is_object($clone_project->thirdparty) ? $clone_project->thirdparty :
null, $clone_project);
1801 if (is_numeric($defaultref) && $defaultref <= 0) {
1805 $clone_project->ref = $defaultref;
1806 $clone_project->title = $langs->trans(
"CopyOf").
' '.$clone_project->title;
1809 $result = $clone_project->create($user, $notrigger);
1813 $this->error .= $clone_project->error;
1819 $clone_project_id = $clone_project->id;
1823 $clone_project->note_private =
'';
1824 $clone_project->note_public =
'';
1827 $res = $clone_project->update_note(
dol_html_entity_decode($clone_project->note_public, ENT_QUOTES | ENT_HTML5),
'_public');
1829 $this->error .= $clone_project->error;
1831 $this->db->rollback();
1833 $this->db->commit();
1837 $res = $clone_project->update_note(
dol_html_entity_decode($clone_project->note_private, ENT_QUOTES | ENT_HTML5),
'_private');
1839 $this->error .= $clone_project->error;
1841 $this->db->rollback();
1843 $this->db->commit();
1848 if ($clone_contact) {
1849 $origin_project =
new Project($this->db);
1850 $origin_project->fetch($fromid);
1852 foreach (array(
'internal',
'external') as $source) {
1853 $tab = $origin_project->liste_contact(-1, $source);
1854 if (is_array($tab) && count($tab) > 0) {
1855 foreach ($tab as $contacttoadd) {
1856 $clone_project->add_contact($contacttoadd[
'id'], $contacttoadd[
'code'], $contacttoadd[
'source'], $notrigger);
1857 if ($clone_project->error ==
'DB_ERROR_RECORD_ALREADY_EXISTS') {
1858 $langs->load(
"errors");
1859 $this->error .= $langs->trans(
"ErrorThisContactIsAlreadyDefinedAsThisType");
1862 if ($clone_project->error !=
'') {
1863 $this->error .= $clone_project->error;
1868 } elseif ($tab < 0) {
1869 $this->error .= $origin_project->error;
1876 if ($clone_project_file) {
1877 require_once DOL_DOCUMENT_ROOT.
'/core/lib/files.lib.php';
1882 if (
dol_mkdir($clone_project_dir) >= 0) {
1883 $filearray =
dol_dir_list($ori_project_dir,
"files", 0,
'',
'(\.meta|_preview.*\.png)$',
'', SORT_ASC, 1);
1884 foreach ($filearray as $key => $file) {
1885 $rescopy =
dol_copy($ori_project_dir.
'/'.$file[
'name'], $clone_project_dir.
'/'.$file[
'name'], 0, 1);
1886 if (is_numeric($rescopy) && $rescopy < 0) {
1887 $this->error .= $langs->trans(
"ErrorFailToCopyFile", $ori_project_dir.
'/'.$file[
'name'], $clone_project_dir.
'/'.$file[
'name']);
1892 $this->error .= $langs->trans(
'ErrorInternalErrorDetected').
':dol_mkdir';
1899 require_once DOL_DOCUMENT_ROOT.
'/projet/class/task.class.php';
1901 $taskstatic =
new Task($this->db);
1905 if ($user->socid > 0) {
1906 $socid = $user->socid;
1909 $tasksarray = $taskstatic->getTasksArray(0, 0, $fromid, $socid, 0);
1911 $tab_conv_child_parent = array();
1914 foreach ($tasksarray as $tasktoclone) {
1915 $result_clone = $taskstatic->createFromClone($user, $tasktoclone->id, $clone_project_id, $tasktoclone->fk_task_parent, $move_date,
true,
false, $clone_task_file,
true,
false);
1916 if ($result_clone <= 0) {
1917 $this->error .= $taskstatic->error;
1920 $new_task_id = $result_clone;
1921 $taskstatic->fetch($tasktoclone->id);
1925 if (($taskstatic->hasChildren()) && !array_key_exists($tasktoclone->id, $tab_conv_child_parent)) {
1926 $tab_conv_child_parent[$tasktoclone->id] = $new_task_id;
1932 $tasksarray = $taskstatic->getTasksArray(0, 0, $clone_project_id, $socid, 0);
1933 foreach ($tasksarray as $task_cloned) {
1934 $taskstatic->fetch($task_cloned->id);
1935 if ($taskstatic->fk_task_parent != 0) {
1936 $taskstatic->fk_task_parent = $tab_conv_child_parent[$taskstatic->fk_task_parent];
1938 $res = $taskstatic->update($user, $notrigger);
1939 if ($result_clone <= 0) {
1940 $this->error .= $taskstatic->error;
1947 unset($clone_project->context[
'createfromclone']);
1949 if (!$error && $clone_project_id != 0) {
1950 $this->db->commit();
1951 return $clone_project_id;
1953 $this->db->rollback();
1954 dol_syslog(get_class($this).
"::createFromClone nbError: ".$error.
" error : ".$this->error, LOG_ERR);
1968 global $user, $langs, $conf;
1973 $taskstatic =
new Task($this->db);
1977 if ($user->socid > 0) {
1978 $socid = $user->socid;
1981 $tasksarray = $taskstatic->getTasksArray(0, 0, $this->
id, $socid, 0);
1983 foreach ($tasksarray as $tasktoshiftdate) {
1986 if ((!empty($tasktoshiftdate->date_start)) || (!empty($tasktoshiftdate->date_end))) {
1989 $task =
new Task($this->db);
1990 $result = $task->fetch($tasktoshiftdate->id);
1993 $this->error .= $task->error;
1999 if (!empty($tasktoshiftdate->date_start)) {
2000 $task->date_start = $this->date_start + ($tasktoshiftdate->date_start - $old_project_dt_start);
2004 if (!empty($tasktoshiftdate->date_end)) {
2005 $task->date_end = $this->date_start + ($tasktoshiftdate->date_end - $old_project_dt_start);
2009 $result = $task->update($user);
2012 $this->error .= $task->error;
2034 $sql =
"UPDATE ".MAIN_DB_PREFIX.$tableName;
2036 if ($tableName ==
"actioncomm") {
2037 $sql .=
" SET fk_project=".$this->id;
2038 $sql .=
" WHERE id=".((int) $elementSelectId);
2039 } elseif (in_array($tableName, [
"entrepot",
"mrp_mo",
"stocktransfer_stocktransfer"])) {
2040 $sql .=
" SET fk_project=".$this->id;
2041 $sql .=
" WHERE rowid=".((int) $elementSelectId);
2043 $sql .=
" SET fk_projet=".$this->id;
2044 $sql .=
" WHERE rowid=".((int) $elementSelectId);
2047 dol_syslog(get_class($this).
"::update_element", LOG_DEBUG);
2048 $resql = $this->db->query($sql);
2050 $this->error = $this->db->lasterror();
2067 public function remove_element($tableName, $elementSelectId, $projectfield =
'fk_projet')
2070 $sql =
"UPDATE ".MAIN_DB_PREFIX.$tableName;
2072 if ($tableName ==
"actioncomm") {
2073 $sql .=
" SET fk_project=NULL";
2074 $sql .=
" WHERE id=".((int) $elementSelectId);
2076 $sql .=
" SET ".$projectfield.
"=NULL";
2077 $sql .=
" WHERE rowid=".((int) $elementSelectId);
2080 dol_syslog(get_class($this).
"::remove_element", LOG_DEBUG);
2081 $resql = $this->db->query($sql);
2083 $this->error = $this->db->lasterror();
2100 public function generateDocument($modele, $outputlangs, $hidedetails = 0, $hidedesc = 0, $hideref = 0)
2102 global $conf, $langs;
2104 $langs->load(
"projects");
2107 $modele =
'baleine';
2109 if ($this->model_pdf) {
2110 $modele = $this->model_pdf;
2116 $modelpath =
"core/modules/project/doc/";
2118 return $this->
commonGenerateDocument($modelpath, $modele, $outputlangs, $hidedetails, $hidedesc, $hideref);
2133 $this->weekWorkLoad = array();
2134 $this->weekWorkLoadPerTask = array();
2136 if (empty($datestart)) {
2140 $sql =
"SELECT ptt.rowid as taskid, ptt.element_duration, ptt.element_date, ptt.element_datehour, ptt.fk_element";
2141 $sql .=
" FROM ".MAIN_DB_PREFIX.
"element_time AS ptt, ".MAIN_DB_PREFIX.
"projet_task as pt";
2142 $sql .=
" WHERE ptt.fk_element = pt.rowid";
2143 $sql .=
" AND ptt.elementtype = 'task'";
2144 $sql .=
" AND pt.fk_projet = ".((int) $this->
id);
2145 $sql .=
" AND (ptt.element_date >= '".$this->db->idate($datestart).
"' ";
2146 $sql .=
" AND ptt.element_date <= '".$this->db->idate(
dol_time_plus_duree($datestart, 1,
'w') - 1).
"')";
2148 $sql .=
" AND ptt.fk_element=".((int) $taskid);
2150 if (is_numeric($userid)) {
2151 $sql .=
" AND ptt.fk_user=".((int) $userid);
2155 $resql = $this->db->query($sql);
2157 $daylareadyfound = array();
2159 $num = $this->db->num_rows($resql);
2163 $obj = $this->db->fetch_object($resql);
2164 $day = $this->db->jdate($obj->element_date);
2165 if (empty($daylareadyfound[$day])) {
2166 $this->weekWorkLoad[$day] = $obj->element_duration;
2167 $this->weekWorkLoadPerTask[$day][$obj->fk_element] = $obj->element_duration;
2169 $this->weekWorkLoad[$day] += $obj->element_duration;
2170 $this->weekWorkLoadPerTask[$day][$obj->fk_element] += $obj->element_duration;
2172 $daylareadyfound[$day] = 1;
2175 $this->db->free($resql);
2178 $this->error =
"Error ".$this->db->lasterror();
2179 dol_syslog(get_class($this).
"::fetch ".$this->error, LOG_ERR);
2195 $this->monthWorkLoad = array();
2196 $this->monthWorkLoadPerTask = array();
2198 if (empty($datestart)) {
2202 $sql =
"SELECT ptt.rowid as taskid, ptt.element_duration, ptt.element_date, ptt.element_datehour, ptt.fk_element";
2203 $sql .=
" FROM ".MAIN_DB_PREFIX.
"element_time AS ptt, ".MAIN_DB_PREFIX.
"projet_task as pt";
2204 $sql .=
" WHERE ptt.fk_element = pt.rowid";
2205 $sql .=
" AND ptt.elementtype = 'task'";
2206 $sql .=
" AND pt.fk_projet = ".((int) $this->
id);
2207 $sql .=
" AND (ptt.element_date >= '".$this->db->idate($datestart).
"' ";
2208 $sql .=
" AND ptt.element_date <= '".$this->db->idate(
dol_time_plus_duree($datestart, 1,
'm') - 1).
"')";
2210 $sql .=
" AND ptt.fk_element=".((int) $taskid);
2212 if (is_numeric($userid)) {
2213 $sql .=
" AND ptt.fk_user=".((int) $userid);
2217 $resql = $this->db->query($sql);
2219 $weekalreadyfound = array();
2221 $num = $this->db->num_rows($resql);
2225 $obj = $this->db->fetch_object($resql);
2226 if (!empty($obj->element_date)) {
2227 $date = explode(
'-', $obj->element_date);
2228 $week_number =
getWeekNumber((
int) $date[2], (
int) $date[1], (
int) $date[0]);
2230 '@phan-var-force int $week_number';
2231 if (empty($weekalreadyfound[$week_number])) {
2232 $this->monthWorkLoad[$week_number] = $obj->element_duration;
2233 $this->monthWorkLoadPerTask[$week_number][$obj->fk_element] = $obj->element_duration;
2235 $this->monthWorkLoad[$week_number] += $obj->element_duration;
2236 $this->monthWorkLoadPerTask[$week_number][$obj->fk_element] += $obj->element_duration;
2238 $weekalreadyfound[$week_number] = 1;
2241 $this->db->free($resql);
2244 $this->error =
"Error ".$this->db->lasterror();
2245 dol_syslog(get_class($this).
"::fetch ".$this->error, LOG_ERR);
2260 global $conf, $langs;
2266 $response->warning_delay = $conf->project->warning_delay / 60 / 60 / 24;
2267 $response->label = $langs->trans(
"OpenedProjects");
2268 $response->labelShort = $langs->trans(
"Opened");
2269 $response->url = DOL_URL_ROOT.
'/projet/list.php?search_project_user=-1&search_status=1&mainmenu=project';
2270 $response->url_late = DOL_URL_ROOT.
'/projet/list.php?search_option=late&mainmenu=project';
2271 $response->img =
img_object(
'',
"projectpub");
2272 $response->nbtodo = 0;
2273 $response->nbtodolate = 0;
2275 $sql =
"SELECT p.rowid, p.fk_statut as status, p.fk_opp_status, p.datee as datee";
2276 $sql .=
" FROM (".MAIN_DB_PREFIX.
"projet as p";
2278 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"societe as s on p.fk_soc = s.rowid";
2281 $sql .=
" WHERE p.fk_statut = 1";
2282 $sql .=
" AND p.entity IN (".getEntity(
'project').
')';
2285 $projectsListId =
null;
2286 if (!$user->hasRight(
"projet",
"all",
"lire")) {
2287 $response->url = DOL_URL_ROOT.
'/projet/list.php?search_status=1&mainmenu=project';
2289 if (empty($projectsListId)) {
2293 $sql .=
" AND p.rowid IN (".$this->db->sanitize($projectsListId).
")";
2302 $resql = $this->db->query($sql);
2304 $project_static =
new Project($this->db);
2308 while ($obj = $this->db->fetch_object($resql)) {
2309 $response->nbtodo++;
2311 $project_static->statut = $obj->status;
2312 $project_static->status = $obj->status;
2313 $project_static->opp_status = $obj->fk_opp_status;
2314 $project_static->date_end = $this->db->jdate($obj->datee);
2316 if ($project_static->hasDelay()) {
2317 $response->nbtodolate++;
2324 $this->error = $this->db->error();
2355 $this->nb = array();
2357 $sql =
"SELECT count(p.rowid) as nb";
2358 $sql .=
" FROM ".MAIN_DB_PREFIX.
"projet as p";
2360 $sql .=
" p.entity IN (".getEntity(
'project').
")";
2361 if (!$user->hasRight(
'projet',
'all',
'lire')) {
2363 $sql .=
"AND p.rowid IN (".$this->db->sanitize($projectsListId).
")";
2366 $resql = $this->db->query($sql);
2368 while ($obj = $this->db->fetch_object($resql)) {
2369 $this->nb[
"projects"] = $obj->nb;
2371 $this->db->free($resql);
2375 $this->error = $this->db->error();
2390 if (!($this->
status == self::STATUS_VALIDATED)) {
2393 if (!$this->date_end) {
2399 return ($this->date_end) < ($now - $conf->project->warning_delay);
2411 $sql =
'SELECT c.rowid, datec as datec, tms as datem,';
2412 $sql .=
' date_close as datecloture,';
2413 $sql .=
' fk_user_creat as fk_user_author, fk_user_close as fk_user_cloture';
2414 $sql .=
' FROM '.MAIN_DB_PREFIX.
'projet as c';
2415 $sql .=
' WHERE c.rowid = '.((int) $id);
2416 $result = $this->db->query($sql);
2418 if ($this->db->num_rows($result)) {
2419 $obj = $this->db->fetch_object($result);
2421 $this->
id = $obj->rowid;
2423 $this->user_creation_id = $obj->fk_user_author;
2424 $this->user_closing_id = $obj->fk_user_cloture;
2426 $this->date_creation = $this->db->jdate($obj->datec);
2427 $this->date_modification = $this->db->jdate($obj->datem);
2428 $this->date_cloture = $this->db->jdate($obj->datecloture);
2431 $this->db->free($result);
2449 require_once DOL_DOCUMENT_ROOT.
'/categories/class/categorie.class.php';
2450 return parent::setCategoriesCommon($categories, Categorie::TYPE_PROJECT);
2463 require_once DOL_DOCUMENT_ROOT.
'/projet/class/task.class.php';
2464 $taskstatic =
new Task($this->db);
2466 $this->lines = $taskstatic->getTasksArray(0, $user, $this->
id, 0, 0,
'',
'-1',
'', 0, 0, array(), 0, array(), 0, $loadRoleMode);
2488 public function sendEmail($text, $subject, $filename_list = array(), $mimetype_list = array(), $mimefilename_list = array(), $addr_cc =
"", $addr_bcc =
"", $deliveryreceipt = 0, $msgishtml = -1, $errors_to =
'', $moreinheader =
'')
2505 global $conf, $langs;
2507 $selected = (empty($arraydata[
'selected']) ? 0 : $arraydata[
'selected']);
2510 if (empty($conf->dol_optimize_smallscreen)) {
2517 $return =
'<div class="box-flex-item '.($size ==
'small' ?
'box-flex-item-small' :
'').
' box-flex-grow-zero">';
2518 $return .=
'<div class="info-box info-box-sm">';
2519 $return .=
'<span class="info-box-icon bg-infobox-action">';
2520 $return .=
img_picto(
'', $this->
public ?
'projectpub' : $this->picto);
2522 $return .=
'</span>';
2523 $return .=
'<div class="info-box-content">';
2524 $return .=
'<span class="info-box-ref inline-block tdoverflowmax150 valignmiddle">'.(method_exists($this,
'getNomUrl') ? $this->
getNomUrl() : $this->ref);
2528 $return .=
'</span>';
2529 if ($selected >= 0) {
2530 $return .=
'<input id="cb'.$this->id.
'" class="flat checkforselect fright" type="checkbox" name="toselect[]" value="'.$this->
id.
'"'.($selected ?
' checked="checked"' :
'').
'>';
2545 if (property_exists($this,
'thirdparty') && !is_null($this->thirdparty) && is_object($this->thirdparty) && $this->thirdparty instanceof
Societe) {
2546 $return .=
'<br><div class="info-box-ref tdoverflowmax125 inline-block valignmiddle">'.$this->thirdparty->getNomUrl(1);
2547 $return .=
'</div>';
2548 if (!empty($this->thirdparty->phone)) {
2549 $return .=
'<div class="inline-block valignmiddle">';
2550 $return .=
dol_print_phone($this->thirdparty->phone, $this->thirdparty->country_code, 0, $this->thirdparty->id,
'tel',
'hidenum',
'phone', $this->thirdparty->phone, 0,
'paddingleft paddingright');
2551 $return .=
'</div>';
2553 if (!empty($this->thirdparty->email)) {
2554 $return .=
'<div class="inline-block valignmiddle">';
2555 $return .=
dol_print_email($this->thirdparty->email, 0, $this->thirdparty->id,
'thirdparty', -1, 1, 2,
'paddingleft paddingright');
2556 $return .=
'</div>';
2559 if (!empty($arraydata[
'assignedusers'])) {
2561 if ($this->
public) {
2562 $return .=
img_picto($langs->trans(
'Visibility').
': '.$langs->trans(
'SharedProject'),
'world',
'class="paddingrightonly valignmiddle"');
2565 $return .=
img_picto($langs->trans(
'Visibility').
': '.$langs->trans(
'PrivateProject'),
'private',
'class="paddingrightonly valignmiddle"');
2569 $return .=
' <span class="small valignmiddle">'.$arraydata[
'assignedusers'].
'</span>';
2575 $return .=
'<br><div>';
2576 if ($this->usage_opportunity && $this->opp_status_code) {
2579 $return .=
'<div class="opacitymedium small marginrightonly inline-block" title="'.dol_escape_htmltag($langs->trans(
"OppStatus".$this->opp_status_code)).
'">'.round($this->opp_percent).
'%</div>';
2580 $return .=
' <div class="amount small marginrightonly inline-block">'.price($this->opp_amount).
'</div>';
2582 if (method_exists($this,
'getLibStatut')) {
2583 $return .=
'<div class="info-box-status small inline-block valignmiddle">'.$this->getLibStatut(3).
'</div>';
2585 $return .=
'</div>';
2587 $return .=
'</div>';
2588 $return .=
'</div>';
2589 $return .=
'</div>';
2602 $sql =
'SELECT rowid,title';
2603 $sql .=
' FROM '.MAIN_DB_PREFIX.
'projet';
2604 $sql .=
' WHERE fk_project = '.((int) $this->
id);
2605 $sql .=
' ORDER BY title';
2606 $result = $this->db->query($sql);
2608 $n = $this->db->num_rows($result);
2610 $children[] = $this->db->fetch_object($result);
2613 $this->db->free($result);
2627 global $mysoc, $user;
2633 $errorsMsg = array();
2637 $firstDayOfWeekDate =
dol_mktime(0, 0, 0, $nowDate[
'mon'], $firstDayOfWeekTS[
'first_day'], $nowDate[
'year']);
2643 $startDate =
dol_print_date($lastWeekStartTS,
'%Y-%m-%d 00:00:00');
2648 CONCAT(u.firstname, ' ', u.lastname) AS name,
2649 u.email,u.weeklyhours,
2650 SUM(et.element_duration) AS total_seconds
2652 ".MAIN_DB_PREFIX.
"element_time AS et
2654 ".MAIN_DB_PREFIX.
"user AS u ON et.fk_user = u.rowid
2656 et.element_date BETWEEN '".$this->db->escape($startDate).
"' AND '".$this->db->escape($endDate).
"'
2657 AND et.elementtype = 'task'
2661 $resql = $this->db->query($sql);
2666 $reportContent =
"<span>Weekly time report from $startDate to $endDate </span><br><br>";
2667 $reportContent .=
'<table border="1" style="border-collapse: collapse;">';
2668 $reportContent .=
'<tr><th>Nom d\'utilisateur</th><th>Temps saisi (heures)</th><th>Temps travaillé par semaine (heures)</th></tr>';
2670 $weekendEnabled = 0;
2675 while ($obj = $this->db->fetch_object($resql)) {
2677 $numHolidays =
num_public_holiday($lastWeekStartTS, $lastWeekEndTS, $mysoc->country_code, 1);
2680 $weekendEnabled = 2;
2683 $dailyHours = $obj->weeklyhours / (7 - $weekendEnabled);
2686 $adjustedSeconds = $obj->total_seconds + ($numHolidays * $dailyHours * 3600);
2688 $totalHours = round($adjustedSeconds / 3600, 2);
2690 $reportContent .=
"<tr><td>{$obj->name}</td><td>{$totalHours}</td><td>".round($obj->weeklyhours, 2).
"</td></tr>";
2692 $reportContent .=
'</table>';
2694 require_once DOL_DOCUMENT_ROOT.
'/core/class/CMailFile.class.php';
2699 $subject =
'Rapport hebdomadaire des temps travaillés';
2703 $errormesg =
"Failed to get sender into global setup MAIN_MAIL_EMAIL_FROM";
2707 $mail =
new CMailFile($subject, $to, $from, $reportContent, array(), array(), array(),
'',
'', 0, -1,
'',
'', 0,
'text/html');
2709 if ($mail->sendfile()) {
2713 require_once DOL_DOCUMENT_ROOT.
'/comm/action/class/actioncomm.class.php';
2718 $actioncomm->type_code =
'AC_OTH_AUTO';
2719 $actioncomm->socid = $this->thirdparty->id;
2720 $actioncomm->contact_id = 0;
2722 $actioncomm->code =
'AC_EMAIL';
2723 $actioncomm->label =
'createWeeklyReportOK()';
2724 $actioncomm->fk_project = $this->id;
2725 $actioncomm->datep =
dol_now();
2726 $actioncomm->datef = $actioncomm->datep;
2727 $actioncomm->percentage = -1;
2728 $actioncomm->authorid = $user->id;
2729 $actioncomm->userownerid = $user->id;
2731 $actioncomm->email_msgid = $mail->msgid;
2732 $actioncomm->email_subject = $subject;
2733 $actioncomm->email_from = $from;
2734 $actioncomm->email_sender =
'';
2735 $actioncomm->email_to = $to;
2737 $actioncomm->errors_to = $errors_to;
2739 $actioncomm->elementtype =
'project_task';
2740 $actioncomm->fk_element = (int) $this->element;
2742 $actioncomm->create($user);
2744 $errormesg = $mail->error.
' : '.$to;
2748 require_once DOL_DOCUMENT_ROOT.
'/comm/action/class/actioncomm.class.php';
2753 $actioncomm->type_code =
'AC_OTH_AUTO';
2754 $actioncomm->socid = $this->thirdparty->id;
2755 $actioncomm->contact_id = 0;
2757 $actioncomm->code =
'AC_EMAIL';
2758 $actioncomm->label =
'createWeeklyReportKO()';
2759 $actioncomm->note_private = $errormesg;
2760 $actioncomm->fk_project = $this->id;
2761 $actioncomm->datep =
dol_now();
2762 $actioncomm->datef = $actioncomm->datep;
2763 $actioncomm->authorid = $user->id;
2764 $actioncomm->userownerid = $user->id;
2766 $actioncomm->email_msgid = $mail->msgid;
2767 $actioncomm->email_from = $from;
2768 $actioncomm->email_sender =
'';
2769 $actioncomm->email_to = $to;
2771 $actioncomm->errors_to = $errors_to;
2773 $actioncomm->elementtype =
'project_task';
2774 $actioncomm->fk_element = (int) $this->element;
2776 $actioncomm->create($user);
2778 $this->db->commit();
2781 if (!empty($errormesg)) {
2782 $errorsMsg[] = $errormesg;
2786 $this->output .=
'Nb of emails sent : '.$nbMailSend;
2787 dol_syslog(__METHOD__.
" end - ".$this->output, LOG_INFO);
2790 $this->error =
'Nb of emails sent : '.$nbMailSend.
', '.(empty($errorsMsg) ? $error : implode(
', ', $errorsMsg));
2791 dol_syslog(__METHOD__.
" end - ".$this->error, LOG_INFO);
print $langs trans("AuditedSecurityEvents").'</strong >< span class="opacitymedium"></span >< br > status
Or an array listing all the potential status of the object: array: int of the status => translated la...
Class to manage agenda events (actions)
Class to send emails (with attachments or not) Usage: $mailfile = new CMailFile($subject,...
Parent class of all other business classes (invoices, contracts, proposals, orders,...
fetch_optionals($rowid=null, $optionsArray=null)
Function to get extra fields of an object into $this->array_options This method is in most cases call...
commonGenerateDocument($modelspath, $modele, $outputlangs, $hidedetails, $hidedesc, $hideref, $moreparams=null)
Common function for all objects extending CommonObject for generating documents.
liste_contact($statusoflink=-1, $source='external', $list=0, $code='', $status=-1, $arrayoftcids=array())
Get array of all contacts for an object.
static commonReplaceThirdparty(DoliDB $dbs, $origin_id, $dest_id, array $tables, $ignoreerrors=0)
Function used to replace a thirdparty id with another one.
insertExtraFields($trigger='', $userused=null)
Add/Update all extra fields values for the current object.
delete_linked_contact($source='', $code='')
Delete all links between an object $this and all its contacts in llx_element_contact.
call_trigger($triggerName, $user)
Call trigger based on this instance.
Class to manage Dolibarr database access.
Class to manage projects.
$user_author_id
Id of project creator. Not defined if shared project.
LibStatut($status, $mode=0)
Renvoi status label for a status.
getLibStatut($mode=0)
Return status label of object.
getElementCount($type, $tablename, $projectkey='fk_projet')
Return the count of a type of linked elements of this project.
getNomUrl($withpicto=0, $option='', $addlabel=0, $moreinpopup='', $sep=' - ', $notooltip=0, $save_lastsearch_value=-1, $morecss='', $save_pageforbacktolist='')
Return clickable name (with picto eventually)
fetchAndSetSubstitution($id, $key, $fetched=false)
Fetch object and substitute key.
getChildren()
Return array of sub-projects of the current project.
setValid($user, $notrigger=0)
Validate a project.
createWeeklyReport()
Method for calculating weekly hours worked and generating a report.
static replaceThirdparty(DoliDB $dbs, $origin_id, $dest_id)
Function used to replace a thirdparty id with another one.
const STATUS_VALIDATED
Open/Validated status.
$public
Tell if this is a public or private project.
getProjectsAuthorizedForUser($user, $mode=0, $list=0, $socid=0, $filter='')
Return array of projects a user has permission on, is affected to, or all projects.
create($user, $notrigger=0)
Create a project into database.
const STATUS_CLOSED
Closed status.
const STATUS_DRAFT
Draft status.
loadTimeSpentMonth($datestart, $taskid=0, $userid=0)
Load time spent into this->weekWorkLoad and this->weekWorkLoadPerTask for all day of a week of projec...
__construct($db)
Constructor.
fetch($id, $ref='', $ref_ext='', $email_msgid='')
Get object from database.
shiftTaskDate($old_project_dt_start)
Shift project task date from current date to delta.
hasDelay()
Is the project delayed?
remove_element($tableName, $elementSelectId, $projectfield='fk_projet')
Associate element to a project.
setCategories($categories)
Sets object to supplied categories.
update_element($tableName, $elementSelectId)
Associate element to a project.
createFromClone(User $user, $fromid, $clone_contact=false, $clone_task=true, $clone_project_file=false, $clone_task_file=false, $clone_note=true, $move_date=true, $notrigger=0, $newthirdpartyid=0)
Load an object from its id and create a new one in database.
loadStateBoard()
Load indicators this->nb for the state board.
load_board($user)
Load indicators for dashboard (this->nbtodo and this->nbtodolate)
getLinesArray($user, $loadRoleMode=1)
Create an array of tasks of current project.
get_element_list($type, $tablename, $datefieldname='', $date_start=null, $date_end=null, $projectkey='fk_projet')
Return list of elements for type, linked to a project.
getKanbanView($option='', $arraydata=null, $size='')
Return clickable link of object (with eventually picto)
info($id)
Charge les information d'ordre info dans l'objet commande.
getTooltipContentArray($params)
getTooltipContentArray
sendEmail($text, $subject, $filename_list=array(), $mimetype_list=array(), $mimefilename_list=array(), $addr_cc="", $addr_bcc="", $deliveryreceipt=0, $msgishtml=-1, $errors_to='', $moreinheader='')
Function sending an email to the current project with the text supplied in parameter.
initAsSpecimen()
Initialise an instance with random values.
setClose($user)
Close a project.
loadTimeSpent($datestart, $taskid=0, $userid=0)
Load time spent into this->weekWorkLoad and this->weekWorkLoadPerTask for all day of a week of projec...
generateDocument($modele, $outputlangs, $hidedetails=0, $hidedesc=0, $hideref=0)
Create an intervention document on disk using template defined into PROJECT_ADDON_PDF.
restrictedProjectArea(User $user, $mode='read')
Check if user has permission on current project.
deleteTasks($user)
Delete tasks with no children first, then task with children recursively.
update($user, $notrigger=0)
Update a project.
Class to manage third parties objects (customers, suppliers, prospects...)
Class to manage Dolibarr users.
dol_get_first_day_week($day, $month, $year, $gm=false)
Return first day of week for a date.
getWeekNumber($day, $month, $year)
Return week number.
dol_time_plus_duree($time, $duration_value, $duration_unit, $ruleforendofmonth=0)
Add a delay to a date.
num_public_holiday($timestampStart, $timestampEnd, $country_code='', $lastday=0, $includesaturday=-1, $includesunday=-1, $includefriday=-1, $includemonday=-1)
Return the number of non working days including Friday, Saturday and Sunday (or not) between 2 dates ...
print $script_file $mode $langs defaultlang(is_numeric($duration_value) ? " delay=". $duration_value :"").(is_numeric($duration_value2) ? " after cd cd cd description as description
Only used if Module[ID]Desc translation string is not found.
dol_delete_dir_recursive($dir, $count=0, $nophperrors=0, $onlysub=0, &$countdeleted=0, $indexdatabase=1, $nolog=0)
Remove a directory $dir and its subdirectories (or only files and subdirectories)
dol_copy($srcfile, $destfile, $newmask='0', $overwriteifexists=1, $testvirus=0, $indexdatabase=0)
Copy a file to another file.
dol_dir_list($utf8_path, $types="all", $recursive=0, $filter="", $excludefilter=null, $sortcriteria="name", $sortorder=SORT_ASC, $mode=0, $nohook=0, $relativename="", $donotfollowsymlinks=0, $nbsecondsold=0)
Scan a directory and return a list of files/directories.
dol_html_entity_decode($a, $b, $c='UTF-8', $keepsomeentities=0)
Replace html_entity_decode functions to manage errors.
dol_mktime($hour, $minute, $second, $month, $day, $year, $gm='auto', $check=1)
Return a timestamp date built from detailed information (by default a local PHP server timestamp) Rep...
img_object($titlealt, $picto, $moreatt='', $pictoisfullpath=0, $srconly=0, $notitle=0)
Show a picto called object_picto (generic function)
img_warning($titlealt='default', $moreatt='', $morecss='pictowarning')
Show warning logo.
img_picto($titlealt, $picto, $moreatt='', $pictoisfullpath=0, $srconly=0, $notitle=0, $alt='', $morecss='', $marginleftonlyshort=2)
Show picto whatever it's its name (generic function)
dol_print_phone($phone, $countrycode='', $cid=0, $socid=0, $addlink='', $separ=" ", $withpicto='', $titlealt='', $adddivfloat=0, $morecss='paddingright')
Format phone numbers according to country.
price2num($amount, $rounding='', $option=0)
Function that return a number with universal decimal format (decimal separator is '.
isDolTms($timestamp)
isDolTms check if a timestamp is valid.
dol_strlen($string, $stringencoding='UTF-8')
Make a strlen call.
dol_now($mode='auto')
Return date for now.
getDolGlobalInt($key, $default=0)
Return a Dolibarr global constant int value.
dol_print_date($time, $format='', $tzoutput='auto', $outputlangs=null, $encodetooutput=false)
Output date in a string format according to outputlangs (or langs if not defined).
if(!function_exists( 'dol_getprefix')) dol_include_once($relpath, $classname='')
Make an include_once using default root and alternate root if it fails.
dol_print_email($email, $cid=0, $socid=0, $addlink=0, $max=64, $showinvalid=1, $withpicto=0, $morecss='paddingrightonly')
Show EMail link formatted for HTML output.
dol_substr($string, $start, $length=null, $stringencoding='', $trunconbytes=0)
Make a substring.
dol_buildpath($path, $type=0, $returnemptyifnotfound=0)
Return path of url or filesystem.
dol_sanitizeFileName($str, $newstr='_', $unaccent=1)
Clean a string to use it as a file name.
dol_print_error($db=null, $error='', $errors=null)
Displays error message system with all the information to facilitate the diagnosis and the escalation...
getDolGlobalString($key, $default='')
Return a Dolibarr global constant string value.
dol_syslog($message, $level=LOG_INFO, $ident=0, $suffixinfilename='', $restricttologhandler='', $logcontext=null)
Write log message into outputs.
getEntity($element, $shared=1, $currentobject=null)
Get list of entity id to use.
dol_getdate($timestamp, $fast=false, $forcetimezone='')
Return an array with locale date info.
dol_mkdir($dir, $dataroot='', $newmask='')
Creation of a directory (this can create recursive subdir)