31 require_once DOL_DOCUMENT_ROOT.
'/core/class/commonobject.class.php';
42 public $element =
'project';
47 public $table_element =
'projet';
52 public $table_element_line =
'projet_task';
57 public $table_element_date;
62 public $fk_element =
'fk_projet';
68 public $ismultientitymanaged = 1;
73 public $isextrafieldmanaged = 1;
78 public $picto =
'project';
122 public $date_start_event;
127 public $date_end_event;
140 public $thirdparty_name;
147 public $fk_user_close;
152 public $user_close_id;
158 public $budget_amount;
163 public $usage_opportunity;
173 public $usage_bill_time;
178 public $usage_organize_event;
183 public $accept_conference_suggestions;
188 public $accept_booth_suggestions;
193 public $price_registration;
203 public $max_attendees;
205 public $statuts_short;
206 public $statuts_long;
211 public $opp_status_code;
212 public $fk_opp_status;
215 public $opp_weighted_amount;
221 public $weekWorkLoad;
222 public $weekWorkLoadPerTask;
281 public $fields = array(
282 'rowid' =>array(
'type'=>
'integer',
'label'=>
'ID',
'enabled'=>1,
'visible'=>-1,
'notnull'=>1,
'position'=>10),
283 'ref' =>array(
'type'=>
'varchar(50)',
'label'=>
'Ref',
'enabled'=>1,
'visible'=>1,
'showoncombobox'=>1,
'position'=>15,
'searchall'=>1),
284 'title' =>array(
'type'=>
'varchar(255)',
'label'=>
'ProjectLabel',
'enabled'=>1,
'visible'=>1,
'notnull'=>1,
'position'=>17,
'showoncombobox'=>2,
'searchall'=>1),
285 'entity' =>array(
'type'=>
'integer',
'label'=>
'Entity',
'default'=>1,
'enabled'=>1,
'visible'=>3,
'notnull'=>1,
'position'=>19),
286 'fk_soc' =>array(
'type'=>
'integer',
'label'=>
'Thirdparty',
'enabled'=>1,
'visible'=>0,
'position'=>20),
287 'dateo' =>array(
'type'=>
'date',
'label'=>
'DateStart',
'enabled'=>1,
'visible'=>1,
'position'=>30),
288 'datee' =>array(
'type'=>
'date',
'label'=>
'DateEnd',
'enabled'=>1,
'visible'=>1,
'position'=>35),
289 'description' =>array(
'type'=>
'text',
'label'=>
'Description',
'enabled'=>1,
'visible'=>3,
'position'=>55,
'searchall'=>1),
290 'public' =>array(
'type'=>
'integer',
'label'=>
'Visibility',
'enabled'=>1,
'visible'=>1,
'position'=>65),
291 'fk_opp_status' =>array(
'type'=>
'integer',
'label'=>
'OpportunityStatusShort',
'enabled'=>
'getDolGlobalString("PROJECT_USE_OPPORTUNITIES")',
'visible'=>1,
'position'=>75),
292 'opp_percent' =>array(
'type'=>
'double(5,2)',
'label'=>
'OpportunityProbabilityShort',
'enabled'=>
'getDolGlobalString("PROJECT_USE_OPPORTUNITIES")',
'visible'=>1,
'position'=>80),
293 'note_private' =>array(
'type'=>
'html',
'label'=>
'NotePrivate',
'enabled'=>1,
'visible'=>0,
'position'=>85,
'searchall'=>1),
294 'note_public' =>array(
'type'=>
'html',
'label'=>
'NotePublic',
'enabled'=>1,
'visible'=>0,
'position'=>90,
'searchall'=>1),
295 'model_pdf' =>array(
'type'=>
'varchar(255)',
'label'=>
'ModelPdf',
'enabled'=>1,
'visible'=>0,
'position'=>95),
296 'date_close' =>array(
'type'=>
'datetime',
'label'=>
'DateClosing',
'enabled'=>1,
'visible'=>0,
'position'=>105),
297 'fk_user_close' =>array(
'type'=>
'integer',
'label'=>
'UserClosing',
'enabled'=>1,
'visible'=>0,
'position'=>110),
298 'opp_amount' =>array(
'type'=>
'double(24,8)',
'label'=>
'OpportunityAmountShort',
'enabled'=>1,
'visible'=>
'getDolGlobalString("PROJECT_USE_OPPORTUNITIES")',
'position'=>115),
299 'budget_amount' =>array(
'type'=>
'double(24,8)',
'label'=>
'Budget',
'enabled'=>1,
'visible'=>-1,
'position'=>119),
300 'usage_opportunity' =>array(
'type'=>
'integer',
'label'=>
'UsageOpportunity',
'enabled'=>1,
'visible'=>-1,
'position'=>130),
301 'usage_task' =>array(
'type'=>
'integer',
'label'=>
'UsageTasks',
'enabled'=>1,
'visible'=>-1,
'position'=>135),
302 'usage_bill_time' =>array(
'type'=>
'integer',
'label'=>
'UsageBillTimeShort',
'enabled'=>1,
'visible'=>-1,
'position'=>140),
303 'usage_organize_event' =>array(
'type'=>
'integer',
'label'=>
'UsageOrganizeEvent',
'enabled'=>1,
'visible'=>-1,
'position'=>145),
305 'date_start_event' =>array(
'type'=>
'date',
'label'=>
'DateStartEvent',
'enabled'=>
"isModEnabled('eventorganization')",
'visible'=>1,
'position'=>200),
306 'date_end_event' =>array(
'type'=>
'date',
'label'=>
'DateEndEvent',
'enabled'=>
"isModEnabled('eventorganization')",
'visible'=>1,
'position'=>201),
307 'location' =>array(
'type'=>
'text',
'label'=>
'Location',
'enabled'=>1,
'visible'=>3,
'position'=>55,
'searchall'=>202),
308 'accept_conference_suggestions' =>array(
'type'=>
'integer',
'label'=>
'AllowUnknownPeopleSuggestConf',
'enabled'=>1,
'visible'=>-1,
'position'=>210),
309 'accept_booth_suggestions' =>array(
'type'=>
'integer',
'label'=>
'AllowUnknownPeopleSuggestBooth',
'enabled'=>1,
'visible'=>-1,
'position'=>211),
310 'price_registration' =>array(
'type'=>
'double(24,8)',
'label'=>
'PriceOfRegistration',
'enabled'=>1,
'visible'=>-1,
'position'=>212),
311 'price_booth' =>array(
'type'=>
'double(24,8)',
'label'=>
'PriceOfBooth',
'enabled'=>1,
'visible'=>-1,
'position'=>215),
312 'max_attendees' =>array(
'type'=>
'integer',
'label'=>
'MaxNbOfAttendees',
'enabled'=>1,
'visible'=>-1,
'position'=>215),
314 'datec' =>array(
'type'=>
'datetime',
'label'=>
'DateCreationShort',
'enabled'=>1,
'visible'=>-2,
'position'=>400),
315 'tms' =>array(
'type'=>
'timestamp',
'label'=>
'DateModificationShort',
'enabled'=>1,
'visible'=>-2,
'notnull'=>1,
'position'=>405),
316 'fk_user_creat' =>array(
'type'=>
'integer',
'label'=>
'UserCreation',
'enabled'=>1,
'visible'=>0,
'notnull'=>1,
'position'=>410),
317 'fk_user_modif' =>array(
'type'=>
'integer',
'label'=>
'UserModification',
'enabled'=>1,
'visible'=>0,
'position'=>415),
318 'import_key' =>array(
'type'=>
'varchar(14)',
'label'=>
'ImportId',
'enabled'=>1,
'visible'=>-1,
'position'=>420),
319 'email_msgid'=>array(
'type'=>
'varchar(255)',
'label'=>
'EmailMsgID',
'enabled'=>1,
'visible'=>-1,
'position'=>450,
'help'=>
'EmailMsgIDWhenSourceisEmail',
'csslist'=>
'tdoverflowmax125'),
320 'fk_statut' =>array(
'type'=>
'smallint(6)',
'label'=>
'Status',
'enabled'=>1,
'visible'=>1,
'notnull'=>1,
'position'=>500),
350 $this->statuts_short = array(0 =>
'Draft', 1 =>
'Opened', 2 =>
'Closed');
351 $this->statuts_long = array(0 =>
'Draft', 1 =>
'Opened', 2 =>
'Closed');
355 if (empty($conf->global->MAIN_SHOW_TECHNICAL_ID)) {
356 $this->fields[
'rowid'][
'visible'] = 0;
359 if (empty($conf->global->PROJECT_USE_OPPORTUNITIES)) {
360 $this->fields[
'fk_opp_status'][
'enabled'] = 0;
361 $this->fields[
'opp_percent'][
'enabled'] = 0;
362 $this->fields[
'opp_amount'][
'enabled'] = 0;
363 $this->fields[
'usage_opportunity'][
'enabled'] = 0;
366 if (!empty($conf->global->PROJECT_HIDE_TASKS)) {
367 $this->fields[
'usage_bill_time'][
'visible'] = 0;
368 $this->fields[
'usage_task'][
'visible'] = 0;
371 if (empty($conf->eventorganization->enabled)) {
372 $this->fields[
'usage_organize_event'][
'visible'] = 0;
373 $this->fields[
'accept_conference_suggestions'][
'enabled'] = 0;
374 $this->fields[
'accept_booth_suggestions'][
'enabled'] = 0;
375 $this->fields[
'price_registration'][
'enabled'] = 0;
376 $this->fields[
'price_booth'][
'enabled'] = 0;
377 $this->fields[
'max_attendees'][
'enabled'] = 0;
388 public function create($user, $notrigger = 0)
390 global $conf, $langs;
398 $this->note_private =
dol_substr($this->note_private, 0, 65535);
399 $this->note_public =
dol_substr($this->note_public, 0, 65535);
402 if (!trim($this->
ref)) {
403 $this->error =
'ErrorFieldsRequired';
404 dol_syslog(get_class($this).
"::create error -1 ref null", LOG_ERR);
407 if (!empty($conf->global->PROJECT_THIRDPARTY_REQUIRED) && !($this->socid > 0)) {
408 $this->error =
'ErrorFieldsRequired';
409 dol_syslog(get_class($this).
"::create error -1 thirdparty not defined and option PROJECT_THIRDPARTY_REQUIRED is set", LOG_ERR);
416 $sql =
"INSERT INTO ".MAIN_DB_PREFIX.
"projet (";
419 $sql .=
", description";
421 $sql .=
", fk_user_creat";
422 $sql .=
", fk_statut";
423 $sql .=
", fk_opp_status";
424 $sql .=
", opp_percent";
429 $sql .=
", opp_amount";
430 $sql .=
", budget_amount";
431 $sql .=
", usage_opportunity";
432 $sql .=
", usage_task";
433 $sql .=
", usage_bill_time";
434 $sql .=
", usage_organize_event";
435 $sql .=
", accept_conference_suggestions";
436 $sql .=
", accept_booth_suggestions";
437 $sql .=
", price_registration";
438 $sql .=
", price_booth";
439 $sql .=
", max_attendees";
440 $sql .=
", date_start_event";
441 $sql .=
", date_end_event";
442 $sql .=
", location";
443 $sql .=
", email_msgid";
444 $sql .=
", note_private";
445 $sql .=
", note_public";
448 $sql .=
") VALUES (";
449 $sql .=
"'".$this->db->escape($this->
ref).
"'";
450 $sql .=
", '".$this->db->escape($this->title).
"'";
452 $sql .=
", ".($this->socid > 0 ? $this->socid :
"null");
453 $sql .=
", ".((int) $user->id);
454 $sql .=
", ".(is_numeric($this->statut) ? ((int) $this->statut) :
'0');
455 $sql .=
", ".((is_numeric($this->opp_status) && $this->opp_status > 0) ? ((
int) $this->opp_status) :
'NULL');
456 $sql .=
", ".(is_numeric($this->opp_percent) ? ((int) $this->opp_percent) :
'NULL');
457 $sql .=
", ".($this->public ? 1 : 0);
458 $sql .=
", '".$this->db->idate($now).
"'";
459 $sql .=
", ".($this->date_start !=
'' ?
"'".$this->db->idate($this->date_start).
"'" :
'null');
460 $sql .=
", ".($this->date_end !=
'' ?
"'".$this->db->idate($this->date_end).
"'" :
'null');
461 $sql .=
", ".(strcmp($this->opp_amount,
'') ?
price2num($this->opp_amount) :
'null');
462 $sql .=
", ".(strcmp($this->budget_amount,
'') ?
price2num($this->budget_amount) :
'null');
463 $sql .=
", ".($this->usage_opportunity ? 1 : 0);
464 $sql .=
", ".($this->usage_task ? 1 : 0);
465 $sql .=
", ".($this->usage_bill_time ? 1 : 0);
466 $sql .=
", ".($this->usage_organize_event ? 1 : 0);
467 $sql .=
", ".($this->accept_conference_suggestions ? 1 : 0);
468 $sql .=
", ".($this->accept_booth_suggestions ? 1 : 0);
469 $sql .=
", ".(strcmp($this->price_registration,
'') ?
price2num($this->price_registration) :
'null');
470 $sql .=
", ".(strcmp($this->price_booth,
'') ?
price2num($this->price_booth) :
'null');
471 $sql .=
", ".(strcmp($this->max_attendees,
'') ? ((int) $this->max_attendees) :
'null');
472 $sql .=
", ".($this->date_start_event !=
'' ?
"'".$this->db->idate($this->date_start_event).
"'" :
'null');
473 $sql .=
", ".($this->date_end_event !=
'' ?
"'".$this->db->idate($this->date_end_event).
"'" :
'null');
474 $sql .=
", ".($this->location ?
"'".$this->db->escape($this->location).
"'" :
'null');
475 $sql .=
", ".($this->email_msgid ?
"'".$this->db->escape($this->email_msgid).
"'" :
'null');
476 $sql .=
", ".($this->note_private ?
"'".$this->db->escape($this->note_private).
"'" :
'null');
477 $sql .=
", ".($this->note_public ?
"'".$this->db->escape($this->note_public).
"'" :
'null');
478 $sql .=
", ".((int) $conf->entity);
479 $sql .=
", ".(!isset($this->ip) ?
'NULL' :
"'".$this->db->escape($this->ip).
"'");
482 dol_syslog(get_class($this).
"::create", LOG_DEBUG);
483 $resql = $this->db->query(
$sql);
485 $this->
id = $this->db->last_insert_id(MAIN_DB_PREFIX.
"projet");
497 $this->error = $this->db->lasterror();
498 $this->errno = $this->db->lasterrno();
521 $this->db->rollback();
533 public function update($user, $notrigger = 0)
535 global $langs, $conf;
540 $this->title = trim($this->title);
542 if ($this->opp_amount < 0) {
543 $this->opp_amount =
'';
545 if ($this->opp_percent < 0) {
546 $this->opp_percent =
'';
548 if ($this->date_end && $this->date_end < $this->date_start) {
549 $this->error = $langs->trans(
"ErrorDateEndLowerThanDateStart");
550 $this->errors[] = $this->error;
551 $this->db->rollback();
552 dol_syslog(get_class($this).
"::update error -3 ".$this->error, LOG_ERR);
556 $this->entity = ((isset($this->entity) && is_numeric($this->entity)) ? $this->entity : $conf->entity);
561 $sql =
"UPDATE ".MAIN_DB_PREFIX.
"projet SET";
562 $sql .=
" ref='".$this->db->escape($this->
ref).
"'";
563 $sql .=
", title = '".$this->db->escape($this->title).
"'";
565 $sql .=
", fk_soc = ".($this->socid > 0 ? $this->socid :
"null");
566 $sql .=
", fk_statut = ".((int) $this->statut);
567 $sql .=
", fk_opp_status = ".((is_numeric($this->opp_status) && $this->opp_status > 0) ? $this->opp_status :
'null');
568 $sql .=
", opp_percent = ".((is_numeric($this->opp_percent) && $this->opp_percent !=
'') ? $this->opp_percent :
'null');
569 $sql .=
", public = ".($this->public ? 1 : 0);
570 $sql .=
", datec = ".($this->date_c !=
'' ?
"'".$this->db->idate($this->date_c).
"'" :
'null');
571 $sql .=
", dateo = ".($this->date_start !=
'' ?
"'".$this->db->idate($this->date_start).
"'" :
'null');
572 $sql .=
", datee = ".($this->date_end !=
'' ?
"'".$this->db->idate($this->date_end).
"'" :
'null');
573 $sql .=
", date_close = ".($this->date_close !=
'' ?
"'".$this->db->idate($this->date_close).
"'" :
'null');
574 $sql .=
", fk_user_close = ".($this->fk_user_close > 0 ? $this->fk_user_close :
"null");
575 $sql .=
", opp_amount = ".(strcmp($this->opp_amount,
'') ?
price2num($this->opp_amount) :
"null");
576 $sql .=
", budget_amount = ".(strcmp($this->budget_amount,
'') ?
price2num($this->budget_amount) :
"null");
577 $sql .=
", fk_user_modif = ".$user->id;
578 $sql .=
", usage_opportunity = ".($this->usage_opportunity ? 1 : 0);
579 $sql .=
", usage_task = ".($this->usage_task ? 1 : 0);
580 $sql .=
", usage_bill_time = ".($this->usage_bill_time ? 1 : 0);
581 $sql .=
", usage_organize_event = ".($this->usage_organize_event ? 1 : 0);
582 $sql .=
", accept_conference_suggestions = ".($this->accept_conference_suggestions ? 1 : 0);
583 $sql .=
", accept_booth_suggestions = ".($this->accept_booth_suggestions ? 1 : 0);
584 $sql .=
", price_registration = ".(strcmp($this->price_registration,
'') ?
price2num($this->price_registration) :
"null");
585 $sql .=
", price_booth = ".(strcmp($this->price_booth,
'') ?
price2num($this->price_booth) :
"null");
586 $sql .=
", max_attendees = ".(strcmp($this->max_attendees,
'') ?
price2num($this->max_attendees) :
"null");
587 $sql .=
", date_start_event = ".($this->date_start_event !=
'' ?
"'".$this->db->idate($this->date_start_event).
"'" :
'null');
588 $sql .=
", date_end_event = ".($this->date_end_event !=
'' ?
"'".$this->db->idate($this->date_end_event).
"'" :
'null');
589 $sql .=
", location = '".$this->db->escape($this->location).
"'";
590 $sql .=
", entity = ".((int) $this->entity);
591 $sql .=
" WHERE rowid = ".((int) $this->
id);
593 dol_syslog(get_class($this).
"::update", LOG_DEBUG);
594 $resql = $this->db->query(
$sql);
604 if (!$error && !$notrigger) {
613 if (!$error && (is_object($this->oldcopy) && $this->oldcopy->ref !== $this->ref)) {
615 if ($conf->project->dir_output) {
618 if (file_exists($olddir)) {
619 include_once DOL_DOCUMENT_ROOT.
'/core/lib/files.lib.php';
620 $res = @rename($olddir, $newdir);
622 $langs->load(
"errors");
623 $this->error = $langs->trans(
'ErrorFailToRenameDir', $olddir, $newdir);
633 $this->db->rollback();
637 $this->error = $this->db->lasterror();
638 $this->errors[] = $this->error;
639 $this->db->rollback();
640 if ($this->db->lasterrno() ==
'DB_ERROR_RECORD_ALREADY_EXISTS') {
645 dol_syslog(get_class($this).
"::update error ".$result.
" ".$this->error, LOG_ERR);
648 dol_syslog(get_class($this).
"::update ref null");
664 public function fetch($id, $ref =
'', $ref_ext =
'', $email_msgid =
'')
666 if (empty($id) && empty($ref) && empty($ref_ext) && empty($email_msgid)) {
667 dol_syslog(get_class($this).
"::fetch Bad parameters", LOG_WARNING);
671 $sql =
"SELECT rowid, entity, ref, title, description, public, datec, opp_amount, budget_amount,";
672 $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,";
673 $sql .=
" note_private, note_public, model_pdf, usage_opportunity, usage_task, usage_bill_time, usage_organize_event, email_msgid,";
674 $sql .=
" accept_conference_suggestions, accept_booth_suggestions, price_registration, price_booth, max_attendees, date_start_event, date_end_event, location";
675 $sql .=
" FROM ".MAIN_DB_PREFIX.
"projet";
677 $sql .=
" WHERE rowid = ".((int) $id);
679 $sql .=
" WHERE entity IN (".getEntity(
'project').
")";
681 $sql .=
" AND ref = '".$this->db->escape($ref).
"'";
682 } elseif (!empty($ref_ext)) {
683 $sql .=
" AND ref_ext = '".$this->db->escape($ref_ext).
"'";
685 $sql .=
" AND email_msgid = '".$this->db->escape($email_msgid).
"'";
689 dol_syslog(get_class($this).
"::fetch", LOG_DEBUG);
690 $resql = $this->db->query(
$sql);
692 $num_rows = $this->db->num_rows($resql);
695 $obj = $this->db->fetch_object($resql);
697 $this->
id = $obj->rowid;
698 $this->entity = $obj->entity;
699 $this->
ref = $obj->ref;
700 $this->title = $obj->title;
702 $this->date_c = $this->db->jdate($obj->datec);
703 $this->datec = $this->db->jdate($obj->datec);
704 $this->date_m = $this->db->jdate($obj->tms);
705 $this->datem = $this->db->jdate($obj->tms);
706 $this->date_start = $this->db->jdate($obj->date_start);
707 $this->date_end = $this->db->jdate($obj->date_end);
708 $this->date_close = $this->db->jdate($obj->date_close);
709 $this->note_private = $obj->note_private;
710 $this->note_public = $obj->note_public;
711 $this->socid = $obj->fk_soc;
712 $this->user_author_id = $obj->fk_user_creat;
713 $this->user_modification_id = $obj->fk_user_modif;
714 $this->user_close_id = $obj->fk_user_close;
715 $this->
public = $obj->public;
716 $this->statut = $obj->status;
717 $this->status = $obj->status;
718 $this->opp_status = $obj->fk_opp_status;
719 $this->opp_amount = $obj->opp_amount;
720 $this->opp_percent = $obj->opp_percent;
721 $this->budget_amount = $obj->budget_amount;
722 $this->model_pdf = $obj->model_pdf;
723 $this->modelpdf = $obj->model_pdf;
724 $this->usage_opportunity = (int) $obj->usage_opportunity;
725 $this->usage_task = (
int) $obj->usage_task;
726 $this->usage_bill_time = (int) $obj->usage_bill_time;
727 $this->usage_organize_event = (
int) $obj->usage_organize_event;
728 $this->accept_conference_suggestions = (int) $obj->accept_conference_suggestions;
729 $this->accept_booth_suggestions = (
int) $obj->accept_booth_suggestions;
730 $this->price_registration = $obj->price_registration;
731 $this->price_booth = $obj->price_booth;
732 $this->max_attendees = $obj->max_attendees;
733 $this->date_start_event = $this->db->jdate($obj->date_start_event);
734 $this->date_end_event = $this->db->jdate($obj->date_end_event);
735 $this->location = $obj->location;
736 $this->email_msgid = $obj->email_msgid;
738 $this->db->free($resql);
747 $this->db->free($resql);
751 $this->error = $this->db->lasterror();
752 $this->errors[] = $this->db->lasterror();
769 public function get_element_list($type, $tablename, $datefieldname =
'', $date_start =
'', $date_end =
'', $projectkey =
'fk_projet')
777 if ($this->
id <= 0) {
783 if ($type ==
'agenda') {
784 $sql =
"SELECT id as rowid FROM ".MAIN_DB_PREFIX.
"actioncomm WHERE fk_project IN (".$this->db->sanitize($ids).
") AND entity IN (".
getEntity(
'agenda').
")";
785 } elseif ($type ==
'expensereport') {
786 $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).
")";
787 } elseif ($type ==
'project_task') {
788 $sql =
"SELECT DISTINCT pt.rowid FROM ".MAIN_DB_PREFIX.
"projet_task as pt WHERE pt.fk_projet IN (".$this->db->sanitize($ids).
")";
789 } elseif ($type ==
'element_time') {
790 $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).
")";
791 } elseif ($type ==
'stock_mouvement') {
792 $sql =
"SELECT ms.rowid, ms.fk_user_author as fk_user 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 IN (".$this->db->sanitize($ids).
") AND ms.type_mouvement = 1";
793 } elseif ($type ==
'loan') {
794 $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).
")";
796 $sql =
"SELECT rowid FROM ".MAIN_DB_PREFIX.$tablename.
" WHERE ".$projectkey.
" IN (".$this->db->sanitize($ids).
") AND entity IN (".
getEntity($type).
")";
799 if ($date_start > 0 && $type ==
'loan') {
800 $sql .=
" AND (dateend > '".$this->db->idate($date_start).
"' OR dateend IS NULL)";
801 } elseif ($date_start > 0 && ($type !=
'project_task')) {
802 if (empty($datefieldname) && !empty($this->table_element_date)) {
803 $datefieldname = $this->table_element_date;
805 if (empty($datefieldname)) {
806 return 'Error this object has no date field defined';
808 $sql .=
" AND (".$datefieldname.
" >= '".$this->db->idate($date_start).
"' OR ".$datefieldname.
" IS NULL)";
811 if ($date_end > 0 && $type ==
'loan') {
812 $sql .=
" AND (datestart < '".$this->db->idate($date_end).
"' OR datestart IS NULL)";
813 } elseif ($date_end > 0 && ($type !=
'project_task')) {
814 if (empty($datefieldname) && !empty($this->table_element_date)) {
815 $datefieldname = $this->table_element_date;
817 if (empty($datefieldname)) {
818 return 'Error this object has no date field defined';
820 $sql .=
" AND (".$datefieldname.
" <= '".$this->db->idate($date_end).
"' OR ".$datefieldname.
" IS NULL)";
826 'tablename' => $tablename,
827 'datefieldname' => $datefieldname,
828 'dates' => $date_start,
829 'datee' => $date_end,
830 'fk_projet' => $projectkey,
833 $reshook = $hookmanager->executeHooks(
'getElementList', $parameters);
835 $sql = $hookmanager->resPrint;
837 $sql .= $hookmanager->resPrint;
845 dol_syslog(get_class($this).
"::get_element_list", LOG_DEBUG);
846 $result = $this->db->query(
$sql);
848 $nump = $this->db->num_rows($result);
852 $obj = $this->db->fetch_object($result);
854 $elements[$i] = $obj->rowid.(empty($obj->fk_user) ?
'' :
'_'.$obj->fk_user);
858 $this->db->free($result);
875 public function delete($user, $notrigger = 0)
877 global $langs, $conf;
878 require_once DOL_DOCUMENT_ROOT.
'/core/lib/files.lib.php';
888 $this->error =
'ErrorFailToDeleteLinkedContact';
890 $this->db->rollback();
896 $listoftables = array(
897 'propal'=>
'fk_projet',
'commande'=>
'fk_projet',
'facture'=>
'fk_projet',
898 'supplier_proposal'=>
'fk_projet',
'commande_fournisseur'=>
'fk_projet',
'facture_fourn'=>
'fk_projet',
899 'expensereport_det'=>
'fk_projet',
'contrat'=>
'fk_projet',
900 'fichinter'=>
'fk_projet',
901 'don'=>array(
'field'=>
'fk_projet',
'module'=>
'don'),
902 'actioncomm'=>
'fk_project',
903 'mrp_mo'=>
'fk_project',
904 'entrepot'=>
'fk_project'
906 foreach ($listoftables as $key => $value) {
907 if (is_array($value)) {
911 $fieldname = $value[
'field'];
915 $sql =
"UPDATE ".MAIN_DB_PREFIX.$key.
" SET ".$fieldname.
" = NULL where ".$fieldname.
" = ".((int) $this->
id);
917 $resql = $this->db->query(
$sql);
919 $this->errors[] = $this->db->lasterror();
927 $sql =
"DELETE FROM ".MAIN_DB_PREFIX.
"categorie_project";
928 $sql .=
" WHERE fk_project = ".((int) $this->
id);
930 $result = $this->db->query(
$sql);
933 $this->errors[] = $this->db->lasterror();
949 $elements = array(
'categorie_project');
950 foreach ($elements as $table) {
952 $sql =
"DELETE FROM ".MAIN_DB_PREFIX.$table;
953 $sql .=
" WHERE fk_project = ".((int) $this->
id);
955 $result = $this->db->query(
$sql);
958 $this->errors[] = $this->db->lasterror();
965 $sql =
"DELETE FROM ".MAIN_DB_PREFIX.
"projet_extrafields";
966 $sql .=
" WHERE fk_object = ".((int) $this->
id);
968 $resql = $this->db->query(
$sql);
970 $this->errors[] = $this->db->lasterror();
977 $sql =
"DELETE FROM ".MAIN_DB_PREFIX.
"projet";
978 $sql .=
" WHERE rowid=".((int) $this->
id);
980 $resql = $this->db->query(
$sql);
982 $this->errors[] = $langs->trans(
"CantRemoveProject", $langs->transnoentitiesnoconv(
"ProjectOverview"));
992 if ($conf->project->dir_output) {
993 $dir = $conf->project->dir_output.
"/".$projectref;
994 if (file_exists($dir)) {
997 $this->errors[] =
'ErrorFailToDeleteDir';
1005 $result = $this->
call_trigger(
'PROJECT_DELETE', $user);
1014 if (empty($error)) {
1015 $this->db->commit();
1018 foreach ($this->errors as $errmsg) {
1019 dol_syslog(get_class($this).
"::delete ".$errmsg, LOG_ERR);
1020 $this->error .= ($this->error ?
', '.$errmsg : $errmsg);
1022 dol_syslog(get_class($this).
"::delete ".$this->error, LOG_ERR);
1023 $this->db->rollback();
1038 if ($this->
id <= 0) {
1042 if ($type ==
'agenda') {
1043 $sql =
"SELECT COUNT(id) as nb FROM ".MAIN_DB_PREFIX.
"actioncomm WHERE fk_project = ".((int) $this->
id).
" AND entity IN (".
getEntity(
'agenda').
")";
1044 } elseif ($type ==
'expensereport') {
1045 $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);
1046 } elseif ($type ==
'project_task') {
1047 $sql =
"SELECT DISTINCT COUNT(pt.rowid) as nb FROM ".MAIN_DB_PREFIX.
"projet_task as pt WHERE pt.fk_projet = ".((int) $this->
id);
1048 } elseif ($type ==
'element_time') {
1049 $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);
1050 } elseif ($type ==
'stock_mouvement') {
1051 $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";
1052 } elseif ($type ==
'loan') {
1053 $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);
1055 $sql =
"SELECT COUNT(rowid) as nb FROM ".MAIN_DB_PREFIX.$tablename.
" WHERE ".$projectkey.
" = ".((int) $this->
id).
" AND entity IN (".
getEntity($type).
")";
1058 $result = $this->db->query(
$sql);
1064 $obj = $this->db->fetch_object($result);
1066 $this->db->free($result);
1079 $countTasks = count($this->lines);
1082 foreach ($this->lines as $task) {
1083 if ($task->hasChildren() <= 0) {
1085 $ret = $task->delete($user);
1087 $this->errors[] = $this->db->lasterror();
1094 if ($deleted && count($this->lines) < $countTasks) {
1095 if (count($this->lines)) {
1112 global $langs, $conf;
1117 if ($this->status == self::STATUS_VALIDATED) {
1118 dol_syslog(get_class($this).
"::validate action abandonned: already validated", LOG_WARNING);
1123 if (preg_match(
'/^'.preg_quote($langs->trans(
"CopyOf").
' ').
'/', $this->title)) {
1124 $this->error = $langs->trans(
"ErrorFieldFormat", $langs->transnoentities(
"Label")).
'. '.$langs->trans(
'RemoveString', $langs->transnoentitiesnoconv(
"CopyOf"));
1130 $sql =
"UPDATE ".MAIN_DB_PREFIX.
"projet";
1131 $sql .=
" SET fk_statut = ".self::STATUS_VALIDATED;
1132 $sql .=
" WHERE rowid = ".((int) $this->
id);
1135 dol_syslog(get_class($this).
"::setValid", LOG_DEBUG);
1136 $resql = $this->db->query(
$sql);
1139 if (empty($notrigger)) {
1140 $result = $this->
call_trigger(
'PROJECT_VALIDATE', $user);
1149 $this->db->commit();
1152 $this->db->rollback();
1153 $this->error = join(
',', $this->errors);
1154 dol_syslog(get_class($this).
"::setValid ".$this->error, LOG_ERR);
1158 $this->db->rollback();
1159 $this->error = $this->db->lasterror();
1172 global $langs, $conf;
1178 if ($this->statut != self::STATUS_CLOSED) {
1181 $sql =
"UPDATE ".MAIN_DB_PREFIX.
"projet";
1182 $sql .=
" SET fk_statut = ".self::STATUS_CLOSED.
", fk_user_close = ".((int) $user->id).
", date_close = '".$this->db->idate($now).
"'";
1183 $sql .=
" WHERE rowid = ".((int) $this->
id);
1184 $sql .=
" AND fk_statut = ".self::STATUS_VALIDATED;
1186 if (!empty($conf->global->PROJECT_USE_OPPORTUNITIES)) {
1190 dol_syslog(get_class($this).
"::setClose", LOG_DEBUG);
1191 $resql = $this->db->query(
$sql);
1202 $this->db->commit();
1205 $this->db->rollback();
1206 $this->error = join(
',', $this->errors);
1207 dol_syslog(get_class($this).
"::setClose ".$this->error, LOG_ERR);
1211 $this->db->rollback();
1212 $this->error = $this->db->lasterror();
1228 return $this->
LibStatut(isset($this->statut) ? $this->statut : $this->status, $mode);
1244 $statustrans = array(
1250 $statusClass =
'status0';
1251 if (!empty($statustrans[$status])) {
1252 $statusClass = $statustrans[$status];
1255 return dolGetStatus($langs->transnoentitiesnoconv($this->statuts_long[$status]), $langs->transnoentitiesnoconv($this->statuts_short[$status]),
'', $statusClass, $mode);
1267 global $conf, $langs;
1269 $langs->load(
'projects');
1270 $option = $params[
'option'] ??
'';
1271 $moreinpopup = $params[
'morinpopup'] ??
'';
1274 if ($option !=
'nolink') {
1275 $datas[
'picto'] =
img_picto(
'', $this->picto,
'class="pictofixedwidth"').
' <u class="paddingrightonly">'.$langs->trans(
"Project").
'</u>';
1277 if (isset($this->status)) {
1278 $datas[
'picto'] .=
' '.$this->getLibStatut(5);
1280 $datas[
'ref'] = (isset($datas[
'picto']) ?
'<br>' :
'').
'<b>'.$langs->trans(
'Ref').
': </b>'.$this->ref;
1281 $datas[
'label'] =
'<br><b>'.$langs->trans(
'Label').
': </b>'.$this->title;
1282 if (isset($this->
public)) {
1283 $datas[
'visibility'] =
'<br><b>'.$langs->trans(
"Visibility").
":</b> ";
1284 $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"));
1286 if (!empty($this->thirdparty_name)) {
1287 $datas[
'thirdparty'] =
'<br><b>'.$langs->trans(
'ThirdParty').
': </b>'.$this->thirdparty_name;
1289 if (!empty($this->date_start)) {
1290 $datas[
'datestart'] =
'<br><b>'.$langs->trans(
'DateStart').
': </b>'.
dol_print_date($this->date_start,
'day');
1292 if (!empty($this->date_end)) {
1293 $datas[
'dateend'] =
'<br><b>'.$langs->trans(
'DateEnd').
': </b>'.
dol_print_date($this->date_end,
'day');
1296 $datas[
'moreinpopup'] =
'<br>'.$moreinpopup;
1315 public function getNomUrl($withpicto = 0, $option =
'', $addlabel = 0, $moreinpopup =
'', $sep =
' - ', $notooltip = 0, $save_lastsearch_value = -1, $morecss =
'')
1317 global $conf, $langs, $user, $hookmanager;
1319 if (!empty($conf->dol_no_mouse_hover)) {
1324 if (!empty($conf->global->PROJECT_OPEN_ALWAYS_ON_TAB)) {
1325 $option = $conf->global->PROJECT_OPEN_ALWAYS_ON_TAB;
1329 'objecttype' => $this->element,
1330 'moreinpopup' => $moreinpopup,
1331 'option' => $option,
1333 $classfortooltip =
'classfortooltip';
1336 $classfortooltip =
'classforajaxtooltip';
1337 $dataparams =
' data-params="'.dol_escape_htmltag(json_encode($params)).
'"';
1344 if ($option !=
'nolink') {
1345 if (preg_match(
'/\.php$/', $option)) {
1347 } elseif ($option ==
'task') {
1348 $url = DOL_URL_ROOT.
'/projet/tasks.php?id='.$this->id;
1349 } elseif ($option ==
'preview') {
1350 $url = DOL_URL_ROOT.
'/projet/element.php?id='.$this->id;
1351 } elseif ($option ==
'eventorganization') {
1352 $url = DOL_URL_ROOT.
'/eventorganization/conferenceorbooth_list.php?projectid='.$this->id;
1354 $url = DOL_URL_ROOT.
'/projet/card.php?id='.$this->id;
1357 $add_save_lastsearch_values = ($save_lastsearch_value == 1 ? 1 : 0);
1358 if ($save_lastsearch_value == -1 && preg_match(
'/list\.php/', $_SERVER[
"PHP_SELF"])) {
1359 $add_save_lastsearch_values = 1;
1361 if ($add_save_lastsearch_values) {
1362 $url .=
'&save_lastsearch_values=1';
1367 if (empty($notooltip) && $user->hasRight(
'projet',
'lire')) {
1368 if (!empty($conf->global->MAIN_OPTIMIZEFORTEXTBROWSER)) {
1369 $label = $langs->trans(
"ShowProject");
1370 $linkclose .=
' alt="'.dol_escape_htmltag($label, 1).
'"';
1372 $linkclose .= ($label ?
' title="'.dol_escape_htmltag($label, 1).
'"' :
' title="tocomplete"');
1373 $linkclose .= $dataparams.
' class="'.$classfortooltip.($morecss ?
' '.$morecss :
'').
'"';
1375 $linkclose = ($morecss ?
' class="'.$morecss.
'"' :
'');
1378 $picto =
'projectpub';
1379 if (!$this->
public) {
1383 $linkstart =
'<a href="'.$url.
'"';
1384 $linkstart .= $linkclose.
'>';
1387 $result .= $linkstart;
1389 $result .=
img_object(($notooltip ?
'' : $label), $picto,
'class="pictofixedwidth em088"', 0, 0, $notooltip ? 0 : 1);
1391 if ($withpicto != 2) {
1392 $result .= $this->ref;
1394 $result .= $linkend;
1395 if ($withpicto != 2) {
1396 $result .= (($addlabel && $this->title) ?
'<span class="opacitymedium">'.$sep.dol_trunc($this->title, ($addlabel > 1 ? $addlabel : 0)).
'</span>' :
'');
1400 $hookmanager->initHooks(array(
'projectdao'));
1401 $parameters = array(
'id'=>$this->
id,
'getnomurl' => &$result);
1402 $reshook = $hookmanager->executeHooks(
'getNomUrl', $parameters, $this, $action);
1404 $result = $hookmanager->resPrint;
1406 $result .= $hookmanager->resPrint;
1421 global $user, $langs, $conf;
1427 $this->
ref =
'SPECIMEN';
1428 $this->entity = $conf->entity;
1429 $this->specimen = 1;
1431 $this->date_c = $now;
1432 $this->date_m = $now;
1433 $this->date_start = $now;
1434 $this->date_end = $now + (3600 * 24 * 365);
1435 $this->note_public =
'SPECIMEN';
1436 $this->fk_ele = 20000;
1437 $this->opp_amount = 20000;
1438 $this->budget_amount = 10000;
1440 $this->usage_opportunity = 1;
1441 $this->usage_task = 1;
1442 $this->usage_bill_time = 1;
1443 $this->usage_organize_event = 1;
1472 if (($mode ==
'read' && !empty($user->rights->projet->all->lire)) || ($mode ==
'write' && !empty($user->rights->projet->all->creer)) || ($mode ==
'delete' && !empty($user->rights->projet->all->supprimer))) {
1474 } elseif ($this->
public && (($mode ==
'read' && !empty($user->rights->projet->lire)) || ($mode ==
'write' && !empty($user->rights->projet->creer)) || ($mode ==
'delete' && !empty($user->rights->projet->supprimer)))) {
1477 foreach (array(
'internal',
'external') as $source) {
1479 $num = count($userRole);
1482 while ($nblinks < $num) {
1483 if ($source ==
'internal' && $user->id == $userRole[$nblinks][
'id']) {
1484 if ($mode ==
'read' && $user->rights->projet->lire) {
1487 if ($mode ==
'write' && $user->rights->projet->creer) {
1490 if ($mode ==
'delete' && $user->rights->projet->supprimer) {
1494 if ($source ==
'external' && $user->socid > 0 && $user->socid == $userRole[$nblinks][
'socid']) {
1495 if ($mode ==
'read' && $user->rights->projet->lire) {
1498 if ($mode ==
'write' && $user->rights->projet->creer) {
1501 if ($mode ==
'delete' && $user->rights->projet->supprimer) {
1517 return ($userAccess ? $userAccess : -1);
1532 $projects = array();
1535 $sql =
"SELECT ".(($mode == 0 || $mode == 1) ?
"DISTINCT " :
"").
"p.rowid, p.ref";
1536 $sql .=
" FROM ".MAIN_DB_PREFIX.
"projet as p";
1538 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"element_contact as ec ON ec.element_id = p.rowid";
1539 } elseif ($mode == 1) {
1540 $sql .=
", ".MAIN_DB_PREFIX.
"element_contact as ec";
1541 } elseif ($mode == 2) {
1544 $sql .=
" WHERE p.entity IN (".getEntity(
'project').
")";
1548 $sql .=
" AND (p.fk_soc IS NULL OR p.fk_soc = 0 OR p.fk_soc = ".((int) $socid).
")";
1552 $listofprojectcontacttype = array();
1553 $sql2 =
"SELECT ctc.rowid, ctc.code FROM ".MAIN_DB_PREFIX.
"c_type_contact as ctc";
1554 $sql2 .=
" WHERE ctc.element = '".$this->db->escape($this->element).
"'";
1555 $sql2 .=
" AND ctc.source = 'internal'";
1556 $resql = $this->db->query($sql2);
1558 while ($obj = $this->db->fetch_object($resql)) {
1559 $listofprojectcontacttype[$obj->rowid] = $obj->code;
1564 if (count($listofprojectcontacttype) == 0) {
1565 $listofprojectcontacttype[0] =
'0';
1569 $sql .=
" AND ( p.public = 1";
1570 $sql .=
" OR ( ec.fk_c_type_contact IN (".$this->db->sanitize(join(
',', array_keys($listofprojectcontacttype))).
")";
1571 $sql .=
" AND ec.fk_socpeople = ".((int) $user->id).
")";
1573 } elseif ($mode == 1) {
1574 $sql .=
" AND ec.element_id = p.rowid";
1576 $sql .=
" ( ec.fk_c_type_contact IN (".$this->db->sanitize(join(
',', array_keys($listofprojectcontacttype))).
")";
1577 $sql .=
" AND ec.fk_socpeople = ".((int) $user->id).
")";
1579 } elseif ($mode == 2) {
1586 $resql = $this->db->query(
$sql);
1588 $num = $this->db->num_rows($resql);
1591 $row = $this->db->fetch_row($resql);
1592 $projects[$row[0]] = $row[1];
1597 $this->db->free($resql);
1603 $result = implode(
',', $temp);
1628 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)
1630 global $langs, $conf;
1634 dol_syslog(
"createFromClone clone_contact=".$clone_contact.
" clone_task=".$clone_task.
" clone_project_file=".$clone_project_file.
" clone_note=".$clone_note.
" move_date=".$move_date, LOG_DEBUG);
1638 $clone_project =
new Project($this->db);
1640 $clone_project->context[
'createfromclone'] =
'createfromclone';
1645 $clone_project->fetch($fromid);
1646 $clone_project->fetch_optionals();
1647 if ($newthirdpartyid > 0) {
1648 $clone_project->socid = $newthirdpartyid;
1650 $clone_project->fetch_thirdparty();
1652 $orign_dt_start = $clone_project->date_start;
1653 $orign_project_ref = $clone_project->ref;
1655 $clone_project->id = 0;
1657 $clone_project->date_start = $now;
1658 if (!(empty($clone_project->date_end))) {
1659 $clone_project->date_end = $clone_project->date_end + ($now - $orign_dt_start);
1663 $clone_project->date_c = $now;
1666 $clone_project->note_private =
'';
1667 $clone_project->note_public =
'';
1672 $obj = empty($conf->global->PROJECT_ADDON) ?
'mod_project_simple' : $conf->global->PROJECT_ADDON;
1674 $file =
''; $classname =
''; $filefound = 0;
1675 $dirmodels = array_merge(array(
'/'), (array) $conf->modules_parts[
'models']);
1676 foreach ($dirmodels as $reldir) {
1677 $file =
dol_buildpath($reldir.
"core/modules/project/".$obj.
'.php', 0);
1678 if (file_exists($file)) {
1681 $modProject =
new $obj;
1682 $defaultref = $modProject->getNextValue(is_object($clone_project->thirdparty) ? $clone_project->thirdparty :
null, $clone_project);
1686 if (is_numeric($defaultref) && $defaultref <= 0) {
1690 $clone_project->ref = $defaultref;
1691 $clone_project->title = $langs->trans(
"CopyOf").
' '.$clone_project->title;
1694 $result = $clone_project->create($user, $notrigger);
1698 $this->error .= $clone_project->error;
1704 $clone_project_id = $clone_project->id;
1708 $clone_project->note_private =
'';
1709 $clone_project->note_public =
'';
1712 $res = $clone_project->update_note(
dol_html_entity_decode($clone_project->note_public, ENT_QUOTES | ENT_HTML5),
'_public');
1714 $this->error .= $clone_project->error;
1716 $this->db->rollback();
1718 $this->db->commit();
1722 $res = $clone_project->update_note(
dol_html_entity_decode($clone_project->note_private, ENT_QUOTES | ENT_HTML5),
'_private');
1724 $this->error .= $clone_project->error;
1726 $this->db->rollback();
1728 $this->db->commit();
1733 if ($clone_contact) {
1734 $origin_project =
new Project($this->db);
1735 $origin_project->fetch($fromid);
1737 foreach (array(
'internal',
'external') as $source) {
1738 $tab = $origin_project->liste_contact(-1, $source);
1739 if (is_array($tab) && count($tab)>0) {
1740 foreach ($tab as $contacttoadd) {
1741 $clone_project->add_contact($contacttoadd[
'id'], $contacttoadd[
'code'], $contacttoadd[
'source'], $notrigger);
1742 if ($clone_project->error ==
'DB_ERROR_RECORD_ALREADY_EXISTS') {
1743 $langs->load(
"errors");
1744 $this->error .= $langs->trans(
"ErrorThisContactIsAlreadyDefinedAsThisType");
1747 if ($clone_project->error !=
'') {
1748 $this->error .= $clone_project->error;
1753 } elseif ($tab < 0) {
1754 $this->error .= $origin_project->error;
1761 if ($clone_project_file) {
1762 require_once DOL_DOCUMENT_ROOT.
'/core/lib/files.lib.php';
1767 if (
dol_mkdir($clone_project_dir) >= 0) {
1768 $filearray =
dol_dir_list($ori_project_dir,
"files", 0,
'',
'(\.meta|_preview.*\.png)$',
'', SORT_ASC, 1);
1769 foreach ($filearray as $key => $file) {
1770 $rescopy =
dol_copy($ori_project_dir.
'/'.$file[
'name'], $clone_project_dir.
'/'.$file[
'name'], 0, 1);
1771 if (is_numeric($rescopy) && $rescopy < 0) {
1772 $this->error .= $langs->trans(
"ErrorFailToCopyFile", $ori_project_dir.
'/'.$file[
'name'], $clone_project_dir.
'/'.$file[
'name']);
1777 $this->error .= $langs->trans(
'ErrorInternalErrorDetected').
':dol_mkdir';
1784 require_once DOL_DOCUMENT_ROOT.
'/projet/class/task.class.php';
1786 $taskstatic =
new Task($this->db);
1790 if ($user->socid > 0) {
1791 $socid = $user->socid;
1794 $tasksarray = $taskstatic->getTasksArray(0, 0, $fromid, $socid, 0);
1796 $tab_conv_child_parent = array();
1799 foreach ($tasksarray as $tasktoclone) {
1800 $result_clone = $taskstatic->createFromClone($user, $tasktoclone->id, $clone_project_id, $tasktoclone->fk_parent, $move_date,
true,
false, $clone_task_file,
true,
false);
1801 if ($result_clone <= 0) {
1802 $this->error .= $taskstatic->error;
1805 $new_task_id = $result_clone;
1806 $taskstatic->fetch($tasktoclone->id);
1810 if (($taskstatic->hasChildren()) && !array_key_exists($tasktoclone->id, $tab_conv_child_parent)) {
1811 $tab_conv_child_parent[$tasktoclone->id] = $new_task_id;
1817 $tasksarray = $taskstatic->getTasksArray(0, 0, $clone_project_id, $socid, 0);
1818 foreach ($tasksarray as $task_cloned) {
1819 $taskstatic->fetch($task_cloned->id);
1820 if ($taskstatic->fk_task_parent != 0) {
1821 $taskstatic->fk_task_parent = $tab_conv_child_parent[$taskstatic->fk_task_parent];
1823 $res = $taskstatic->update($user, $notrigger);
1824 if ($result_clone <= 0) {
1825 $this->error .= $taskstatic->error;
1832 unset($clone_project->context[
'createfromclone']);
1835 $this->db->commit();
1836 return $clone_project_id;
1838 $this->db->rollback();
1839 dol_syslog(get_class($this).
"::createFromClone nbError: ".$error.
" error : ".$this->error, LOG_ERR);
1853 global $user, $langs, $conf;
1858 $taskstatic =
new Task($this->db);
1862 if ($user->socid > 0) {
1863 $socid = $user->socid;
1866 $tasksarray = $taskstatic->getTasksArray(0, 0, $this->
id, $socid, 0);
1868 foreach ($tasksarray as $tasktoshiftdate) {
1871 if ((!empty($tasktoshiftdate->date_start)) || (!empty($tasktoshiftdate->date_end))) {
1874 $task =
new Task($this->db);
1875 $result = $task->fetch($tasktoshiftdate->id);
1878 $this->error .= $task->error;
1884 if (!empty($tasktoshiftdate->date_start)) {
1885 $task->date_start = $this->date_start + ($tasktoshiftdate->date_start - $old_project_dt_start);
1889 if (!empty($tasktoshiftdate->date_end)) {
1890 $task->date_end = $this->date_start + ($tasktoshiftdate->date_end - $old_project_dt_start);
1894 $result = $task->update($user);
1897 $this->error .= $task->error;
1919 $sql =
"UPDATE ".MAIN_DB_PREFIX.$tableName;
1921 if ($tableName ==
"actioncomm") {
1922 $sql .=
" SET fk_project=".$this->id;
1923 $sql .=
" WHERE id=".((int) $elementSelectId);
1924 } elseif ($tableName ==
"entrepot") {
1925 $sql .=
" SET fk_project=".$this->id;
1926 $sql .=
" WHERE rowid=".((int) $elementSelectId);
1928 $sql .=
" SET fk_projet=".$this->id;
1929 $sql .=
" WHERE rowid=".((int) $elementSelectId);
1932 dol_syslog(get_class($this).
"::update_element", LOG_DEBUG);
1933 $resql = $this->db->query(
$sql);
1935 $this->error = $this->db->lasterror();
1952 public function remove_element($tableName, $elementSelectId, $projectfield =
'fk_projet')
1955 $sql =
"UPDATE ".MAIN_DB_PREFIX.$tableName;
1957 if ($tableName ==
"actioncomm") {
1958 $sql .=
" SET fk_project=NULL";
1959 $sql .=
" WHERE id=".((int) $elementSelectId);
1961 $sql .=
" SET ".$projectfield.
"=NULL";
1962 $sql .=
" WHERE rowid=".((int) $elementSelectId);
1965 dol_syslog(get_class($this).
"::remove_element", LOG_DEBUG);
1966 $resql = $this->db->query(
$sql);
1968 $this->error = $this->db->lasterror();
1985 public function generateDocument($modele, $outputlangs, $hidedetails = 0, $hidedesc = 0, $hideref = 0)
1987 global $conf, $langs;
1989 $langs->load(
"projects");
1992 $modele =
'baleine';
1994 if ($this->model_pdf) {
1995 $modele = $this->model_pdf;
1996 } elseif (!empty($conf->global->PROJECT_ADDON_PDF)) {
1997 $modele = $conf->global->PROJECT_ADDON_PDF;
2001 $modelpath =
"core/modules/project/doc/";
2003 return $this->
commonGenerateDocument($modelpath, $modele, $outputlangs, $hidedetails, $hidedesc, $hideref);
2020 $this->weekWorkLoad = array();
2021 $this->weekWorkLoadPerTask = array();
2023 if (empty($datestart)) {
2027 $sql =
"SELECT ptt.rowid as taskid, ptt.element_duration, ptt.element_date, ptt.element_datehour, ptt.fk_element";
2028 $sql .=
" FROM ".MAIN_DB_PREFIX.
"element_time AS ptt, ".MAIN_DB_PREFIX.
"projet_task as pt";
2029 $sql .=
" WHERE ptt.fk_element = pt.rowid";
2030 $sql .=
" AND ptt.elementtype = 'task'";
2031 $sql .=
" AND pt.fk_projet = ".((int) $this->
id);
2032 $sql .=
" AND (ptt.element_date >= '".$this->db->idate($datestart).
"' ";
2035 $sql .=
" AND ptt.fk_element=".((int) $taskid);
2037 if (is_numeric($userid)) {
2038 $sql .=
" AND ptt.fk_user=".((int) $userid);
2042 $resql = $this->db->query(
$sql);
2044 $daylareadyfound = array();
2046 $num = $this->db->num_rows($resql);
2050 $obj = $this->db->fetch_object($resql);
2051 $day = $this->db->jdate($obj->element_date);
2052 if (empty($daylareadyfound[$day])) {
2053 $this->weekWorkLoad[$day] = $obj->element_duration;
2054 $this->weekWorkLoadPerTask[$day][$obj->fk_element] = $obj->element_duration;
2056 $this->weekWorkLoad[$day] += $obj->element_duration;
2057 $this->weekWorkLoadPerTask[$day][$obj->fk_element] += $obj->element_duration;
2059 $daylareadyfound[$day] = 1;
2062 $this->db->free($resql);
2065 $this->error =
"Error ".$this->db->lasterror();
2066 dol_syslog(get_class($this).
"::fetch ".$this->error, LOG_ERR);
2084 $this->monthWorkLoad = array();
2085 $this->monthWorkLoadPerTask = array();
2087 if (empty($datestart)) {
2091 $sql =
"SELECT ptt.rowid as taskid, ptt.element_duration, ptt.element_date, ptt.element_datehour, ptt.fk_element";
2092 $sql .=
" FROM ".MAIN_DB_PREFIX.
"element_time AS ptt, ".MAIN_DB_PREFIX.
"projet_task as pt";
2093 $sql .=
" WHERE ptt.fk_element = pt.rowid";
2094 $sql .=
" AND ptt.elementtype = 'task'";
2095 $sql .=
" AND pt.fk_projet = ".((int) $this->
id);
2096 $sql .=
" AND (ptt.element_date >= '".$this->db->idate($datestart).
"' ";
2099 $sql .=
" AND ptt.fk_element=".((int) $taskid);
2101 if (is_numeric($userid)) {
2102 $sql .=
" AND ptt.fk_user=".((int) $userid);
2106 $resql = $this->db->query(
$sql);
2108 $weekalreadyfound = array();
2110 $num = $this->db->num_rows($resql);
2114 $obj = $this->db->fetch_object($resql);
2115 if (!empty($obj->element_date)) {
2116 $date = explode(
'-', $obj->element_date);
2119 if (empty($weekalreadyfound[$week_number])) {
2120 $this->monthWorkLoad[$week_number] = $obj->element_duration;
2121 $this->monthWorkLoadPerTask[$week_number][$obj->fk_element] = $obj->element_duration;
2123 $this->monthWorkLoad[$week_number] += $obj->element_duration;
2124 $this->monthWorkLoadPerTask[$week_number][$obj->fk_element] += $obj->element_duration;
2126 $weekalreadyfound[$week_number] = 1;
2129 $this->db->free($resql);
2132 $this->error =
"Error ".$this->db->lasterror();
2133 dol_syslog(get_class($this).
"::fetch ".$this->error, LOG_ERR);
2148 global $conf, $langs;
2154 $response->warning_delay = $conf->project->warning_delay / 60 / 60 / 24;
2155 $response->label = $langs->trans(
"OpenedProjects");
2156 $response->labelShort = $langs->trans(
"Opened");
2157 $response->url = DOL_URL_ROOT.
'/projet/list.php?search_project_user=-1&search_status=1&mainmenu=project';
2158 $response->img =
img_object(
'',
"projectpub");
2159 $response->nbtodo = 0;
2160 $response->nbtodolate = 0;
2162 $sql =
"SELECT p.rowid, p.fk_statut as status, p.fk_opp_status, p.datee as datee";
2163 $sql .=
" FROM (".MAIN_DB_PREFIX.
"projet as p";
2165 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"societe as s on p.fk_soc = s.rowid";
2168 $sql .=
" WHERE p.fk_statut = 1";
2169 $sql .=
" AND p.entity IN (".getEntity(
'project').
')';
2172 $projectsListId =
null;
2173 if (!$user->hasRight(
"projet",
"all",
"lire")) {
2174 $response->url = DOL_URL_ROOT.
'/projet/list.php?search_status=1&mainmenu=project';
2176 if (empty($projectsListId)) {
2180 $sql .=
" AND p.rowid IN (".$this->db->sanitize($projectsListId).
")";
2189 $resql = $this->db->query(
$sql);
2191 $project_static =
new Project($this->db);
2195 while ($obj = $this->db->fetch_object($resql)) {
2196 $response->nbtodo++;
2198 $project_static->statut = $obj->status;
2199 $project_static->opp_status = $obj->fk_opp_status;
2200 $project_static->date_end = $this->db->jdate($obj->datee);
2202 if ($project_static->hasDelay()) {
2203 $response->nbtodolate++;
2210 $this->error = $this->db->error();
2243 $this->nb = array();
2245 $sql =
"SELECT count(p.rowid) as nb";
2246 $sql .=
" FROM ".MAIN_DB_PREFIX.
"projet as p";
2248 $sql .=
" p.entity IN (".getEntity(
'project').
")";
2249 if (empty($user->rights->projet->all->lire)) {
2251 $sql .=
"AND p.rowid IN (".$this->db->sanitize($projectsListId).
")";
2254 $resql = $this->db->query(
$sql);
2256 while ($obj = $this->db->fetch_object($resql)) {
2257 $this->nb[
"projects"] = $obj->nb;
2259 $this->db->free($resql);
2263 $this->error = $this->db->error();
2278 if (!($this->statut == self::STATUS_VALIDATED)) {
2281 if (!$this->date_end) {
2287 return ($this->date_end) < ($now - $conf->project->warning_delay);
2299 $sql =
'SELECT c.rowid, datec as datec, tms as datem,';
2300 $sql .=
' date_close as datecloture,';
2301 $sql .=
' fk_user_creat as fk_user_author, fk_user_close as fk_use_cloture';
2302 $sql .=
' FROM '.MAIN_DB_PREFIX.
'projet as c';
2303 $sql .=
' WHERE c.rowid = '.((int) $id);
2304 $result = $this->db->query(
$sql);
2306 if ($this->db->num_rows($result)) {
2307 $obj = $this->db->fetch_object($result);
2308 $this->
id = $obj->rowid;
2309 if ($obj->fk_user_author) {
2310 $cuser =
new User($this->db);
2311 $cuser->fetch($obj->fk_user_author);
2312 $this->user_creation = $cuser;
2315 if (!empty($obj->fk_user_cloture)) {
2316 $cluser =
new User($this->db);
2317 $cluser->fetch($obj->fk_user_cloture);
2318 $this->user_cloture = $cluser;
2321 $this->date_creation = $this->db->jdate($obj->datec);
2322 $this->date_modification = $this->db->jdate($obj->datem);
2323 $this->date_cloture = $this->db->jdate($obj->datecloture);
2326 $this->db->free($result);
2344 require_once DOL_DOCUMENT_ROOT.
'/categories/class/categorie.class.php';
2345 return parent::setCategoriesCommon($categories, Categorie::TYPE_PROJECT);
2358 require_once DOL_DOCUMENT_ROOT.
'/projet/class/task.class.php';
2359 $taskstatic =
new Task($this->db);
2361 $this->lines = $taskstatic->getTasksArray(0, $user, $this->
id, 0, 0,
'',
'-1',
'', 0, 0, array(), 0, array(), 0, $loadRoleMode);
2382 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 =
'')
2384 global $conf, $langs;
2400 $selected = (empty($arraydata[
'selected']) ? 0 : $arraydata[
'selected']);
2402 $return =
'<div class="box-flex-item box-flex-grow-zero">';
2403 $return .=
'<div class="info-box info-box-sm">';
2404 $return .=
'<span class="info-box-icon bg-infobox-action">';
2405 $return .=
img_picto(
'', $this->
public ?
'projectpub' : $this->picto);
2407 $return .=
'</span>';
2408 $return .=
'<div class="info-box-content">';
2409 $return .=
'<span class="info-box-ref inline-block tdoverflowmax150 valignmiddle">'.(method_exists($this,
'getNomUrl') ? $this->
getNomUrl() : $this->ref);
2413 $return .=
'</span>';
2414 $return .=
'<input id="cb'.$this->id.
'" class="flat checkforselect fright" type="checkbox" name="toselect[]" value="'.$this->
id.
'"'.($selected ?
' checked="checked"' :
'').
'>';
2428 if (!empty($arraydata[
'assignedusers'])) {
2429 $return .=
'<br><span class="small">'.$arraydata[
'assignedusers'].
'</span>';
2435 if ($this->usage_opportunity && $this->opp_status_code) {
2437 $return .=
'<br><span class="info-box-label small">'.$langs->trans(
"OppStatus".$this->opp_status_code).
'</span>';
2438 $return .=
' <span class="opacitymedium small">('.round($this->opp_percent).
'%)</span>';
2439 $return .=
'<br><span class="amount small">'.price($this->opp_amount).
'</span>';
2441 if (method_exists($this,
'getLibStatut')) {
2442 $return .=
'<br><div class="info-box-status small">'.$this->getLibStatut(3).
'</div>';
2444 $return .=
'</div>';
2445 $return .=
'</div>';
2446 $return .=
'</div>';