<?php
/* Copyright (C) 2002-2005  Rodolphe Quiedeville    <rodolphe@quiedeville.org>
 * Copyright (C) 2005-2020  Laurent Destailleur     <eldy@users.sourceforge.net>
 * Copyright (C) 2005-2010  Regis Houssin           <regis.houssin@inodbox.com>
 * Copyright (C) 2013	    Florian Henry           <florian.henry@open-concept.pro>
 * Copyright (C) 2014-2017  Marcos García           <marcosgdf@gmail.com>
 * Copyright (C) 2017       Ferran Marcet           <fmarcet@2byte.es>
 * Copyright (C) 2019       Juanjo Menent           <jmenent@2byte.es>
 * Copyright (C) 2022       Charlene Benke          <charlene@patas-monkey.com>
 * Copyright (C) 2023       Gauthier VERDOL         <gauthier.verdol@atm-consulting.fr>
 * Copyright (C) 2024		Frédéric France         <frederic.france@free.fr>
 * Copyright (C) 2024		MDW						<mdeweerd@users.noreply.github.com>
 * Copyright (C) 2024		William Mead			<william.mead@manchenumerique.fr>
 *
 * This program is free software; you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published by
 * the Free Software Foundation; either version 3 of the License, or
 * (at your option) any later version.
 *
 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU General Public License for more details.
 *
 * You should have received a copy of the GNU General Public License
 * along with this program. If not, see <https://www.gnu.org/licenses/>.
 */

/**
 * 		\file       htdocs/projet/class/project.class.php
 * 		\ingroup    projet
 * 		\brief      File of class to manage projects
 */
require_once DOL_DOCUMENT_ROOT.'/core/class/commonobject.class.php';

/**
 *	Class to manage projects
 */
class Project extends CommonObject
{
	/**
	 * @var string ID to identify managed object
	 */
	public $element = 'project';

	/**
	 * @var string Name of table without prefix where object is stored
	 */
	public $table_element = 'projet';

	/**
	 * @var string    Name of subtable line
	 */
	public $table_element_line = 'projet_task';

	/**
	 * @var string    Name of field date
	 */
	public $table_element_date;

	/**
	 * @var string Field with ID of parent key if this field has a parent
	 */
	public $fk_element = 'fk_projet';

	/**
	 * @var string String with name of icon for myobject. Must be the part after the 'object_' into object_myobject.png
	 */
	public $picto = 'project';

	/**
	 * {@inheritdoc}
	 */
	protected $table_ref_field = 'ref';

	/**
	 * @var int parent project
	 */
	public $fk_project;

	/**
	 * @var string description
	 */
	public $description;

	/**
	 * @var string
	 */
	public $title;

	/**
	 * @var int 	Date start
	 * @deprecated Use $date_start
	 */
	public $dateo;

	/**
	 * @var null|int|string 	Field with Date start
	 */
	public $date_start;

	/**
	 * @var int 	Date end
	 * @deprecated Use $date_end
	 */
	public $datee;

	/**
	 * @var null|int|string 	Field with Date end
	 */
	public $date_end;

	/**
	 * @var int 	Date start event
	 */
	public $date_start_event;

	/**
	 * @var int 	Date end event
	 */
	public $date_end_event;

	/**
	 * @var string	Location
	 */
	public $location;

	/**
	 * @var int Date close
	 */
	public $date_close;

	/**
	 * @var int	Id of thirdparty
	 */
	public $socid; // To store id of thirdparty

	/**
	 * @var string thirdparty name
	 */
	public $thirdparty_name; // To store name of thirdparty (defined only in some cases)

	/**
	 * @var int	Id of project creator. Not defined if shared project.
	 */
	public $user_author_id;

	/**
	 * @var int user close id
	 */
	public $fk_user_close;

	/**
	 * @var int<0,1>  Tell if this is a public or private project
	 */
	public $public;

	/**
	 * @var float|string budget Amount (May need price2num)
	 */
	public $budget_amount;

	/**
	 * @var integer		Can use projects to follow opportunities
	 */
	public $usage_opportunity;

	/**
	 * @var integer		Can follow tasks on project and enter time spent on it
	 */
	public $usage_task;

	/**
	 * @var integer	 	Use to bill task spend time
	 */
	public $usage_bill_time; // Is the time spent on project must be invoiced or not

	/**
	   * @var integer		Event organization: Use Event Organization
	   */
	public $usage_organize_event;

	/**
	 * @var integer		Event organization: Allow unknown people to suggest new conferences
	 */
	public $accept_conference_suggestions;

	/**
	 * @var integer		Event organization: Allow unknown people to suggest new booth
	 */
	public $accept_booth_suggestions;

	/**
	 * @var float|string Event organization: registration price (may need price2num)
	 */
	public $price_registration;

	/**
	 * @var float|string Event organization: booth price (may need price2num)
	 */
	public $price_booth;

	/**
	 * @var int|'' Max attendees (may be empty/need cast to int)
	 */
	public $max_attendees;

	/**
	 * @var int status
	 * @deprecated Use $status
	 */
	public $statut; // 0=draft, 1=opened, 2=closed

	/**
	 * @var int opportunity status
	 */
	public $opp_status; // opportunity status, into table llx_c_lead_status

	/**
	 * @var string opportunity code
	 */
	public $opp_status_code;

	/**
	 * @var int opportunity status
	 */
	public $fk_opp_status; // opportunity status, into table llx_c_lead_status

	/**
	 * @var float|'' opportunity amount
	 */
	public $opp_amount; // opportunity amount

	/**
	 * @var float|'' opportunity percent
	 */
	public $opp_percent; // opportunity probability

	/**
	 * @var float|'' opportunity weighted amount
	 */
	public $opp_weighted_amount; // opportunity weighted amount

	/**
	 * @var string email msgid
	 */
	public $email_msgid;

	/**
	 * @var array<int,int> Used to store workload details of a projet (array[day])
	 */
	public $weekWorkLoad;
	/**
	 * @var array<int,array<int,int>> Used to store workload details of a projet (array[day][taskid])
	 */
	public $weekWorkLoadPerTask; // Used to store workload details of tasks of a projet

	/**
	 * @var array<string,int> Used to store workload details of a projet
	 */
	public $monthWorkLoad;

	/**
	 * @var array<string,array<int,int>> Used to store workload details of tasks of a projet (array[weeknbr][task_id])
	 */
	public $monthWorkLoadPerTask;

	/**
	 * @var int Creation date
	 * @deprecated Use $date_c
	 */
	public $datec;

	/**
	 * @var int Creation date
	 */
	public $date_c;

	/**
	 * @var int Modification date
	 * @deprecated Use $date_m
	 */
	public $datem;

	/**
	 * @var int Modification date
	 */
	public $date_m;

	/**
	 * @var string Ip address
	 */
	public $ip;

	/**
	 * @var Task[]
	 */
	public $lines;

	/**
	 *  'type' field format:
	 *  	'integer', 'integer:ObjectClass:PathToClass[:AddCreateButtonOrNot[:Filter[:Sortfield]]]',
	 *  	'select' (list of values are in 'options'. for integer list of values are in 'arrayofkeyval'),
	 *  	'sellist:TableName:LabelFieldName[:KeyFieldName[:KeyFieldParent[:Filter[:CategoryIdType[:CategoryIdList[:SortField]]]]]]',
	 *  	'chkbxlst:...',
	 *  	'varchar(x)',
	 *  	'text', 'text:none', 'html',
	 *   	'double(24,8)', 'real', 'price', 'stock',
	 *  	'date', 'datetime', 'timestamp', 'duration',
	 *  	'boolean', 'checkbox', 'radio', 'array',
	 *  	'mail', 'phone', 'url', 'password', 'ip'
	 *		Note: Filter must be a Dolibarr Universal Filter syntax string. Example: "(t.ref:like:'SO-%') or (t.date_creation:<:'20160101') or (t.status:!=:0) or (t.nature:is:NULL)"
	 *  'label' the translation key.
	 *  'alias' the alias used into some old hard coded SQL requests
	 *  'picto' is code of a picto to show before value in forms
	 *  'enabled' is a condition when the field must be managed (Example: 1 or 'getDolGlobalInt("MY_SETUP_PARAM")' or 'isModEnabled("multicurrency")' ...)
	 *  'position' is the sort order of field.
	 *  'notnull' is set to 1 if not null in database. Set to -1 if we must set data to null if empty ('' or 0).
	 *  'visible' says if field is visible in list (Examples: 0=Not visible, 1=Visible on list and create/update/view forms, 2=Visible on list only, 3=Visible on create/update/view form only (not list), 4=Visible on list and update/view form only (not create). 5=Visible on list and view only (not create/not update). Using a negative value means field is not shown by default on list but can be selected for viewing)
	 *  'noteditable' says if field is not editable (1 or 0)
	 *  'alwayseditable' says if field can be modified also when status is not draft ('1' or '0')
	 *  'default' is a default value for creation (can still be overwrote by the Setup of Default Values if field is editable in creation form). Note: If default is set to '(PROV)' and field is 'ref', the default value will be set to '(PROVid)' where id is rowid when a new record is created.
	 *  'index' if we want an index in database.
	 *  'foreignkey'=>'tablename.field' if the field is a foreign key (it is recommended to name the field fk_...).
	 *  'searchall' is 1 if we want to search in this field when making a search from the quick search button.
	 *  'isameasure' must be set to 1 or 2 if field can be used for measure. Field type must be summable like integer or double(24,8). Use 1 in most cases, or 2 if you don't want to see the column total into list (for example for percentage)
	 *  'css' and 'cssview' and 'csslist' is the CSS style to use on field. 'css' is used in creation and update. 'cssview' is used in view mode. 'csslist' is used for columns in lists. For example: 'css'=>'minwidth300 maxwidth500 widthcentpercentminusx', 'cssview'=>'wordbreak', 'csslist'=>'tdoverflowmax200'
	 *  'help' and 'helplist' is a 'TranslationString' to use to show a tooltip on field. You can also use 'TranslationString:keyfortooltiponlick' for a tooltip on click.
	 *  'showoncombobox' if value of the field must be visible into the label of the combobox that list record
	 *  'disabled' is 1 if we want to have the field locked by a 'disabled' attribute. In most cases, this is never set into the definition of $fields into class, but is set dynamically by some part of code.
	 *  'arrayofkeyval' to set a list of values if type is a list of predefined values. For example: array("0"=>"Draft","1"=>"Active","-1"=>"Cancel"). Note that type can be 'integer' or 'varchar'
	 *  'autofocusoncreate' to have field having the focus on a create form. Only 1 field should have this property set to 1.
	 *  'comment' is not used. You can store here any text of your choice. It is not used by application.
	 *	'validate' is 1 if you need to validate the field with $this->validateField(). Need MAIN_ACTIVATE_VALIDATION_RESULT.
	 *  'copytoclipboard' is 1 or 2 to allow to add a picto to copy value into clipboard (1=picto after label, 2=picto after value)
	 *
	 *  Note: To have value dynamic, you can set value to 0 in definition and edit the value on the fly into the constructor.
	 */

	// BEGIN MODULEBUILDER PROPERTIES
	/**
	 * @var array<string,array{type:string,label:string,enabled:int<0,2>|string,position:int,notnull?:int,visible:int<-5,5>|string,alwayseditable?:int<0,1>,noteditable?:int<0,1>,default?:string,index?:int,foreignkey?:string,searchall?:int<0,1>,isameasure?:int<0,1>,css?:string,csslist?:string,help?:string,showoncombobox?:int<0,4>,disabled?:int<0,1>,arrayofkeyval?:array<int|string,string>,autofocusoncreate?:int<0,1>,comment?:string,copytoclipboard?:int<1,2>,validate?:int<0,1>,showonheader?:int<0,1>}>  Array with all fields and their property. Do not use it as a static var. It may be modified by constructor.
	 */
	public $fields = array(
		'rowid' => array('type' => 'integer', 'label' => 'ID', 'enabled' => 1, 'visible' => -1, 'notnull' => 1, 'position' => 10),
		'fk_project' => array('type' => 'integer', 'label' => 'Parent', 'enabled' => 1, 'visible' => 1, 'notnull' => 0, 'position' => 12),
		'ref' => array('type' => 'varchar(50)', 'label' => 'Ref', 'enabled' => 1, 'visible' => 1, 'showoncombobox' => 1, 'position' => 15, 'searchall' => 1),
		'title' => array('type' => 'varchar(255)', 'label' => 'ProjectLabel', 'enabled' => 1, 'visible' => 1, 'notnull' => 1, 'position' => 17, 'showoncombobox' => 2, 'searchall' => 1),
		'entity' => array('type' => 'integer', 'label' => 'Entity', 'default' => '1', 'enabled' => 1, 'visible' => 3, 'notnull' => 1, 'position' => 19),
		'fk_soc' => array('type' => 'integer', 'label' => 'Thirdparty', 'enabled' => 1, 'visible' => 0, 'position' => 20),
		'dateo' => array('type' => 'date', 'label' => 'DateStart', 'enabled' => 1, 'visible' => -1, 'position' => 30),
		'datee' => array('type' => 'date', 'label' => 'DateEnd', 'enabled' => 1, 'visible' => 1, 'position' => 35),
		'description' => array('type' => 'text', 'label' => 'Description', 'enabled' => 1, 'visible' => 3, 'position' => 55, 'searchall' => 1),
		'public' => array('type' => 'integer', 'label' => 'Visibility', 'enabled' => 1, 'visible' => -1, 'position' => 65),
		'fk_opp_status' => array('type' => 'integer:CLeadStatus:core/class/cleadstatus.class.php', 'label' => 'OpportunityStatusShort', 'enabled' => 'getDolGlobalString("PROJECT_USE_OPPORTUNITIES")', 'visible' => 1, 'position' => 75),
		'opp_percent' => array('type' => 'double(5,2)', 'label' => 'OpportunityProbabilityShort', 'enabled' => 'getDolGlobalString("PROJECT_USE_OPPORTUNITIES")', 'visible' => 1, 'position' => 80),
		'note_private' => array('type' => 'html', 'label' => 'NotePrivate', 'enabled' => 1, 'visible' => 0, 'position' => 85, 'searchall' => 1),
		'note_public' => array('type' => 'html', 'label' => 'NotePublic', 'enabled' => 1, 'visible' => 0, 'position' => 90, 'searchall' => 1),
		'model_pdf' => array('type' => 'varchar(255)', 'label' => 'ModelPdf', 'enabled' => 1, 'visible' => 0, 'position' => 95),
		'date_close' => array('type' => 'datetime', 'label' => 'DateClosing', 'enabled' => 1, 'visible' => 0, 'position' => 105),
		'fk_user_close' => array('type' => 'integer', 'label' => 'UserClosing', 'enabled' => 1, 'visible' => 0, 'position' => 110),
		'opp_amount' => array('type' => 'double(24,8)', 'label' => 'OpportunityAmountShort', 'enabled' => 1, 'visible' => 'getDolGlobalString("PROJECT_USE_OPPORTUNITIES")', 'position' => 115),
		'budget_amount' => array('type' => 'double(24,8)', 'label' => 'Budget', 'enabled' => 1, 'visible' => -1, 'position' => 119),
		'usage_opportunity' => array('type' => 'integer', 'label' => 'UsageOpportunity', 'enabled' => 1, 'visible' => -1, 'position' => 130),
		'usage_task' => array('type' => 'integer', 'label' => 'UsageTasks', 'enabled' => 1, 'visible' => -1, 'position' => 135),
		'usage_bill_time' => array('type' => 'integer', 'label' => 'UsageBillTimeShort', 'enabled' => 1, 'visible' => -1, 'position' => 140),
		'usage_organize_event' => array('type' => 'integer', 'label' => 'UsageOrganizeEvent', 'enabled' => 1, 'visible' => -1, 'position' => 145),
		// Properties for event organization
		'date_start_event' => array('type' => 'date', 'label' => 'DateStartEvent', 'enabled' => "isModEnabled('eventorganization')", 'visible' => 1, 'position' => 200),
		'date_end_event' => array('type' => 'date', 'label' => 'DateEndEvent', 'enabled' => "isModEnabled('eventorganization')", 'visible' => 1, 'position' => 201),
		'location' => array('type' => 'text', 'label' => 'Location', 'enabled' => 1, 'visible' => 3, 'position' => 202, 'searchall' => 1),
		'accept_conference_suggestions' => array('type' => 'integer', 'label' => 'AllowUnknownPeopleSuggestConf', 'enabled' => 1, 'visible' => -1, 'position' => 210),
		'accept_booth_suggestions' => array('type' => 'integer', 'label' => 'AllowUnknownPeopleSuggestBooth', 'enabled' => 1, 'visible' => -1, 'position' => 211),
		'price_registration' => array('type' => 'double(24,8)', 'label' => 'PriceOfRegistration', 'enabled' => 1, 'visible' => -1, 'position' => 212),
		'price_booth' => array('type' => 'double(24,8)', 'label' => 'PriceOfBooth', 'enabled' => 1, 'visible' => -1, 'position' => 215),
		'max_attendees' => array('type' => 'integer', 'label' => 'MaxNbOfAttendees', 'enabled' => 1, 'visible' => -1, 'position' => 215),
		// Generic
		'datec' => array('type' => 'datetime', 'label' => 'DateCreationShort', 'enabled' => 1, 'visible' => -2, 'position' => 400),
		'tms' => array('type' => 'timestamp', 'label' => 'DateModificationShort', 'enabled' => 1, 'visible' => -2, 'notnull' => 1, 'position' => 405),
		'fk_user_creat' => array('type' => 'integer', 'label' => 'UserCreation', 'enabled' => 1, 'visible' => 0, 'notnull' => 1, 'position' => 410),
		'fk_user_modif' => array('type' => 'integer', 'label' => 'UserModification', 'enabled' => 1, 'visible' => 0, 'position' => 415),
		'import_key' => array('type' => 'varchar(14)', 'label' => 'ImportId', 'enabled' => 1, 'visible' => -1, 'position' => 420),
		'email_msgid' => array('type' => 'varchar(255)', 'label' => 'EmailMsgID', 'enabled' => 1, 'visible' => -1, 'position' => 450, 'help' => 'EmailMsgIDWhenSourceisEmail', 'csslist' => 'tdoverflowmax125'),
		'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')),
	);
	// END MODULEBUILDER PROPERTIES

	/**
	 * Draft status
	 */
	const STATUS_DRAFT = 0;

	/**
	 * Open/Validated status
	 */
	const STATUS_VALIDATED = 1;

	/**
	 * Closed status
	 */
	const STATUS_CLOSED = 2;


	/**
	 *  Constructor
	 *
	 *  @param      DoliDB		$db      Database handler
	 */
	public function __construct($db)
	{
		global $conf;

		$this->db = $db;

		$this->ismultientitymanaged = 1;
		$this->isextrafieldmanaged = 1;

		$this->labelStatusShort = array(0 => 'Draft', 1 => 'Opened', 2 => 'Closed');
		$this->labelStatus = array(0 => 'Draft', 1 => 'Opened', 2 => 'Closed');

		global $conf;

		if (!getDolGlobalString('MAIN_SHOW_TECHNICAL_ID')) {
			$this->fields['rowid']['visible'] = 0;
		}

		if (!getDolGlobalString('PROJECT_USE_OPPORTUNITIES')) {
			$this->fields['fk_opp_status']['enabled'] = 0;
			$this->fields['opp_percent']['enabled'] = 0;
			$this->fields['opp_amount']['enabled'] = 0;
			$this->fields['usage_opportunity']['enabled'] = 0;
		}

		if (getDolGlobalString('PROJECT_HIDE_TASKS')) {
			$this->fields['usage_bill_time']['visible'] = 0;
			$this->fields['usage_task']['visible'] = 0;
		}

		if (empty($conf->eventorganization->enabled)) {
			$this->fields['usage_organize_event']['visible'] = 0;
			$this->fields['accept_conference_suggestions']['enabled'] = 0;
			$this->fields['accept_booth_suggestions']['enabled'] = 0;
			$this->fields['price_registration']['enabled'] = 0;
			$this->fields['price_booth']['enabled'] = 0;
			$this->fields['max_attendees']['enabled'] = 0;
		}
	}

	/**
	 *    Create a project into database
	 *
	 *    @param    User	$user       	User making creation
	 *    @param	int		$notrigger		Disable triggers
	 *    @return   int         			Return integer <0 if KO, id of created project if OK
	 */
	public function create($user, $notrigger = 0)
	{
		$error = 0;
		$ret = 0;

		$now = dol_now();

		// Clean parameters
		$this->note_private = dol_substr($this->note_private, 0, 65535);
		$this->note_public = dol_substr($this->note_public, 0, 65535);

		// Check parameters
		if (!trim($this->ref)) {
			$this->error = 'ErrorFieldsRequired';
			dol_syslog(get_class($this)."::create error -1 ref null", LOG_ERR);
			return -1;
		}
		if (getDolGlobalString('PROJECT_THIRDPARTY_REQUIRED') && !($this->socid > 0)) {
			$this->error = 'ErrorFieldsRequired';
			dol_syslog(get_class($this)."::create error -1 thirdparty not defined and option PROJECT_THIRDPARTY_REQUIRED is set", LOG_ERR);
			return -1;
		}

		// Create project
		$this->db->begin();

		$sql = "INSERT INTO ".MAIN_DB_PREFIX."projet (";
		$sql .= "ref";
		$sql .= ", fk_project";
		$sql .= ", title";
		$sql .= ", description";
		$sql .= ", fk_soc";
		$sql .= ", fk_user_creat";
		$sql .= ", fk_statut";
		$sql .= ", fk_opp_status";
		$sql .= ", opp_percent";
		$sql .= ", public";
		$sql .= ", datec";
		$sql .= ", dateo";
		$sql .= ", datee";
		$sql .= ", opp_amount";
		$sql .= ", budget_amount";
		$sql .= ", usage_opportunity";
		$sql .= ", usage_task";
		$sql .= ", usage_bill_time";
		$sql .= ", usage_organize_event";
		$sql .= ", accept_conference_suggestions";
		$sql .= ", accept_booth_suggestions";
		$sql .= ", price_registration";
		$sql .= ", price_booth";
		$sql .= ", max_attendees";
		$sql .= ", date_start_event";
		$sql .= ", date_end_event";
		$sql .= ", location";
		$sql .= ", email_msgid";
		$sql .= ", note_private";
		$sql .= ", note_public";
		$sql .= ", entity";
		$sql .= ", ip";
		$sql .= ") VALUES (";
		$sql .= "'".$this->db->escape($this->ref)."'";
		$sql .= ", ".($this->fk_project ? ((int) $this->fk_project) : "null");
		$sql .= ", '".$this->db->escape($this->title)."'";
		$sql .= ", '".$this->db->escape($this->description)."'";
		$sql .= ", ".($this->socid > 0 ? $this->socid : "null");
		$sql .= ", ".((int) $user->id);
		$sql .= ", ".(is_numeric($this->status) ? ((int) $this->status) : '0');
		$sql .= ", ".((is_numeric($this->opp_status) && $this->opp_status > 0) ? ((int) $this->opp_status) : 'NULL');
		$sql .= ", ".(is_numeric($this->opp_percent) ? ((int) $this->opp_percent) : 'NULL');
		$sql .= ", ".($this->public ? 1 : 0);
		$sql .= ", '".$this->db->idate($now)."'";
		$sql .= ", ".($this->date_start != '' ? "'".$this->db->idate($this->date_start)."'" : 'null');
		$sql .= ", ".($this->date_end != '' ? "'".$this->db->idate($this->date_end)."'" : 'null');
		$sql .= ", ".(strcmp($this->opp_amount, '') ? price2num($this->opp_amount) : 'null');
		$sql .= ", ".(strcmp((string) $this->budget_amount, '') ? price2num($this->budget_amount) : 'null');
		$sql .= ", ".($this->usage_opportunity ? 1 : 0);
		$sql .= ", ".($this->usage_task ? 1 : 0);
		$sql .= ", ".($this->usage_bill_time ? 1 : 0);
		$sql .= ", ".($this->usage_organize_event ? 1 : 0);
		$sql .= ", ".($this->accept_conference_suggestions ? 1 : 0);
		$sql .= ", ".($this->accept_booth_suggestions ? 1 : 0);
		$sql .= ", ".(strcmp((string) $this->price_registration, '') ? price2num($this->price_registration) : 'null');
		$sql .= ", ".(strcmp((string) $this->price_booth, '') ? price2num($this->price_booth) : 'null');
		$sql .= ", ".(strcmp((string) $this->max_attendees, '') ? ((int) $this->max_attendees) : 'null');
		$sql .= ", ".($this->date_start_event != '' ? "'".$this->db->idate($this->date_start_event)."'" : 'null');
		$sql .= ", ".($this->date_end_event != '' ? "'".$this->db->idate($this->date_end_event)."'" : 'null');
		$sql .= ", ".($this->location ? "'".$this->db->escape($this->location)."'" : 'null');
		$sql .= ", ".($this->email_msgid ? "'".$this->db->escape($this->email_msgid)."'" : 'null');
		$sql .= ", ".($this->note_private ? "'".$this->db->escape($this->note_private)."'" : 'null');
		$sql .= ", ".($this->note_public ? "'".$this->db->escape($this->note_public)."'" : 'null');
		$sql .= ", ".setEntity($this);
		$sql .= ", ".(!isset($this->ip) ? 'NULL' : "'".$this->db->escape($this->ip)."'");
		$sql .= ")";

		dol_syslog(get_class($this)."::create", LOG_DEBUG);
		$resql = $this->db->query($sql);
		if ($resql) {
			$this->id = $this->db->last_insert_id(MAIN_DB_PREFIX."projet");
			$ret = $this->id;

			if (!$notrigger) {
				// Call trigger
				$result = $this->call_trigger('PROJECT_CREATE', $user);
				if ($result < 0) {
					$error++;
				}
				// End call triggers
			}
		} else {
			$this->error = $this->db->lasterror();
			$error++;
		}

		// Update extrafield
		if (!$error) {
			$result = $this->insertExtraFields();
			if ($result < 0) {
				$error++;
			}
		}

		if (!$error && (getDolGlobalString('MAIN_DISABLEDRAFTSTATUS') || getDolGlobalString('MAIN_DISABLEDRAFTSTATUS_PROJECT'))) {
			$res = $this->setValid($user);
			if ($res < 0) {
				$error++;
			}
		}

		if (!$error) {
			$this->db->commit();
			return $ret;
		} else {
			$this->db->rollback();
			return -1;
		}
	}

	/**
	 * Update a project
	 *
	 * @param  User		$user       User object of making update
	 * @param  int		$notrigger  1=Disable all triggers
	 * @return int                  Return integer <=0 if KO, >0 if OK
	 */
	public function update($user, $notrigger = 0)
	{
		global $langs, $conf;

		$error = 0;

		// Clean parameters
		$this->title = trim($this->title);
		$this->description = trim($this->description);
		if ($this->opp_amount < 0) {
			$this->opp_amount = '';
		}
		if ($this->opp_percent < 0) {
			$this->opp_percent = '';
		}
		if ($this->date_end && $this->date_end < $this->date_start) {
			$this->error = $langs->trans("ErrorDateEndLowerThanDateStart");
			$this->errors[] = $this->error;
			$this->db->rollback();
			dol_syslog(get_class($this)."::update error -3 ".$this->error, LOG_ERR);
			return -3;
		}

		$this->entity = ((isset($this->entity) && is_numeric($this->entity)) ? $this->entity : $conf->entity);

		if (dol_strlen(trim($this->ref)) > 0) {
			$this->db->begin();

			$sql = "UPDATE ".MAIN_DB_PREFIX."projet SET";
			$sql .= " ref='".$this->db->escape($this->ref)."'";
			$sql .= ", fk_project=".($this->fk_project ? ((int) $this->fk_project) : "null");
			$sql .= ", title = '".$this->db->escape($this->title)."'";
			$sql .= ", description = '".$this->db->escape($this->description)."'";
			$sql .= ", fk_soc = ".($this->socid > 0 ? $this->socid : "null");
			$sql .= ", fk_statut = ".((int) $this->status);
			$sql .= ", fk_opp_status = ".((is_numeric($this->opp_status) && $this->opp_status > 0) ? $this->opp_status : 'null');
			$sql .= ", opp_percent = ".((is_numeric($this->opp_percent) && $this->opp_percent != '') ? $this->opp_percent : 'null');
			$sql .= ", public = ".($this->public ? 1 : 0);
			$sql .= ", datec = ".($this->date_c != '' ? "'".$this->db->idate($this->date_c)."'" : 'null');
			$sql .= ", dateo = ".($this->date_start != '' ? "'".$this->db->idate($this->date_start)."'" : 'null');
			$sql .= ", datee = ".($this->date_end != '' ? "'".$this->db->idate($this->date_end)."'" : 'null');
			$sql .= ", date_close = ".($this->date_close != '' ? "'".$this->db->idate($this->date_close)."'" : 'null');
			$sql .= ", note_public = ".($this->note_public ? "'".$this->db->escape($this->note_public)."'" : "null");
			$sql .= ", note_private = ".($this->note_private ? "'".$this->db->escape($this->note_private)."'" : "null");
			$sql .= ", fk_user_close = ".($this->fk_user_close > 0 ? $this->fk_user_close : "null");
			$sql .= ", opp_amount = ".(strcmp($this->opp_amount, '') ? price2num($this->opp_amount) : "null");
			$sql .= ", budget_amount = ".(strcmp($this->budget_amount, '') ? price2num($this->budget_amount) : "null");
			$sql .= ", fk_user_modif = ".((int) $user->id);
			$sql .= ", usage_opportunity = ".($this->usage_opportunity ? 1 : 0);
			$sql .= ", usage_task = ".($this->usage_task ? 1 : 0);
			$sql .= ", usage_bill_time = ".($this->usage_bill_time ? 1 : 0);
			$sql .= ", usage_organize_event = ".($this->usage_organize_event ? 1 : 0);
			$sql .= ", accept_conference_suggestions = ".($this->accept_conference_suggestions ? 1 : 0);
			$sql .= ", accept_booth_suggestions = ".($this->accept_booth_suggestions ? 1 : 0);
			$sql .= ", price_registration = ".(isset($this->price_registration) && strcmp($this->price_registration, '') ? price2num($this->price_registration) : "null");
			$sql .= ", price_booth = ".(isset($this->price_booth) && strcmp((string) $this->price_booth, '') ? price2num($this->price_booth) : "null");
			$sql .= ", max_attendees = ".(strcmp((string) $this->max_attendees, '') ? (int) $this->max_attendees : "null");
			$sql .= ", date_start_event = ".($this->date_start_event != '' ? "'".$this->db->idate($this->date_start_event)."'" : 'null');
			$sql .= ", date_end_event = ".($this->date_end_event != '' ? "'".$this->db->idate($this->date_end_event)."'" : 'null');
			$sql .= ", location = '".$this->db->escape($this->location)."'";
			$sql .= ", entity = ".((int) $this->entity);
			$sql .= " WHERE rowid = ".((int) $this->id);

			dol_syslog(get_class($this)."::update", LOG_DEBUG);
			$resql = $this->db->query($sql);
			if ($resql) {
				// Update extrafield
				if (!$error) {
					$result = $this->insertExtraFields();
					if ($result < 0) {
						$error++;
					}
				}

				if (!$error && !$notrigger) {
					// Call trigger
					$result = $this->call_trigger('PROJECT_MODIFY', $user);
					if ($result < 0) {
						$error++;
					}
					// End call triggers
				}

				if (!$error && (is_object($this->oldcopy) && $this->oldcopy->ref !== $this->ref)) {
					// We remove directory
					if ($conf->project->dir_output) {
						$olddir = $conf->project->dir_output."/".dol_sanitizeFileName($this->oldcopy->ref);
						$newdir = $conf->project->dir_output."/".dol_sanitizeFileName($this->ref);
						if (file_exists($olddir)) {
							include_once DOL_DOCUMENT_ROOT.'/core/lib/files.lib.php';
							$res = @rename($olddir, $newdir);
							if (!$res) {
								$langs->load("errors");
								$this->error = $langs->trans('ErrorFailToRenameDir', $olddir, $newdir);
								$error++;
							}
						}
					}
				}
				if (!$error) {
					$this->db->commit();
					$result = 1;
				} else {
					$this->db->rollback();
					$result = -1;
				}
			} else {
				$this->error = $this->db->lasterror();
				$this->errors[] = $this->error;
				$this->db->rollback();
				if ($this->db->lasterrno() == 'DB_ERROR_RECORD_ALREADY_EXISTS') {
					$result = -4;
				} else {
					$result = -2;
				}
				dol_syslog(get_class($this)."::update error ".$result." ".$this->error, LOG_ERR);
			}
		} else {
			dol_syslog(get_class($this)."::update ref null");
			$result = -1;
		}

		return $result;
	}

	/**
	 * 	Get object from database
	 *
	 * 	@param      int		$id       		Id of object to load
	 * 	@param		string	$ref			Ref of project
	 * 	@param		string	$ref_ext		Ref ext of project
	 *  @param		string	$email_msgid	Email msgid
	 * 	@return     int      		   		>0 if OK, 0 if not found, <0 if KO
	 */
	public function fetch($id, $ref = '', $ref_ext = '', $email_msgid = '')
	{
		if (empty($id) && empty($ref) && empty($ref_ext) && empty($email_msgid)) {
			dol_syslog(get_class($this)."::fetch Bad parameters", LOG_WARNING);
			return -1;
		}

		$sql = "SELECT rowid, entity, fk_project, ref, title, description, public, datec, opp_amount, budget_amount,";
		$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,";
		$sql .= " note_private, note_public, model_pdf, usage_opportunity, usage_task, usage_bill_time, usage_organize_event, email_msgid,";
		$sql .= " accept_conference_suggestions, accept_booth_suggestions, price_registration, price_booth, max_attendees, date_start_event, date_end_event, location, extraparams";
		$sql .= " FROM ".MAIN_DB_PREFIX."projet";
		if (!empty($id)) {
			$sql .= " WHERE rowid = ".((int) $id);
		} else {
			$sql .= " WHERE entity IN (".getEntity('project').")";
			if (!empty($ref)) {
				$sql .= " AND ref = '".$this->db->escape($ref)."'";
			} elseif (!empty($ref_ext)) {
				$sql .= " AND ref_ext = '".$this->db->escape($ref_ext)."'";
			} else {
				$sql .= " AND email_msgid = '".$this->db->escape($email_msgid)."'";
			}
		}

		dol_syslog(get_class($this)."::fetch", LOG_DEBUG);
		$resql = $this->db->query($sql);
		if ($resql) {
			$num_rows = $this->db->num_rows($resql);

			if ($num_rows) {
				$obj = $this->db->fetch_object($resql);

				$this->id = $obj->rowid;
				$this->entity = $obj->entity;
				$this->ref = $obj->ref;
				$this->fk_project = $obj->fk_project;
				$this->title = $obj->title;
				$this->description = $obj->description;
				$this->date_c = $this->db->jdate($obj->datec);
				$this->datec = $this->db->jdate($obj->datec); // TODO deprecated
				$this->date_m = $this->db->jdate($obj->tms);
				$this->datem = $this->db->jdate($obj->tms); // TODO deprecated
				$this->date_start = $this->db->jdate($obj->date_start);
				$this->date_end = $this->db->jdate($obj->date_end);
				$this->date_close = $this->db->jdate($obj->date_close);
				$this->note_private = $obj->note_private;
				$this->note_public = $obj->note_public;
				$this->socid = $obj->fk_soc;
				$this->user_author_id = $obj->fk_user_creat;
				$this->user_modification_id = $obj->fk_user_modif;
				$this->user_closing_id = $obj->fk_user_close;
				$this->public = $obj->public;
				$this->statut = $obj->status; // deprecated
				$this->status = $obj->status;
				$this->opp_status = $obj->fk_opp_status;
				$this->opp_amount	= $obj->opp_amount;
				$this->opp_percent = $obj->opp_percent;
				$this->budget_amount = $obj->budget_amount;
				$this->model_pdf = $obj->model_pdf;
				$this->usage_opportunity = (int) $obj->usage_opportunity;
				$this->usage_task = (int) $obj->usage_task;
				$this->usage_bill_time = (int) $obj->usage_bill_time;
				$this->usage_organize_event = (int) $obj->usage_organize_event;
				$this->accept_conference_suggestions = (int) $obj->accept_conference_suggestions;
				$this->accept_booth_suggestions = (int) $obj->accept_booth_suggestions;
				$this->price_registration = $obj->price_registration;
				$this->price_booth = $obj->price_booth;
				$this->max_attendees = $obj->max_attendees;
				$this->date_start_event = $this->db->jdate($obj->date_start_event);
				$this->date_end_event = $this->db->jdate($obj->date_end_event);
				$this->location = $obj->location;
				$this->email_msgid = $obj->email_msgid;
				$this->extraparams = !empty($obj->extraparams) ? (array) json_decode($obj->extraparams, true) : array();

				$this->db->free($resql);

				// Retrieve all extrafield
				// fetch optionals attributes and labels
				$this->fetch_optionals();

				return 1;
			}

			$this->db->free($resql);

			return 0;
		} else {
			$this->error = $this->db->lasterror();
			$this->errors[] = $this->db->lasterror();
			return -1;
		}
	}

	/**
	 * Fetch object and substitute key
	 *
	 * @param	int			$id					Project id
	 * @param 	string		$key				Key to substitute
	 * @param 	bool		$fetched			[=false] Not already fetched
	 * @return 	string		Substitute key
	 */
	public function fetchAndSetSubstitution($id, $key, $fetched = false)
	{
		$substitution = '';

		if ($fetched === false) {
			$res = $this->fetch($id);
			if ($res > 0) {
				$fetched = true;
			}
		}

		if ($fetched === true) {
			if ($key == '__PROJECT_ID__') {
				$substitution = ($this->id > 0 ? $this->id : '');
			} elseif ($key == '__PROJECT_REF__') {
				$substitution = $this->ref;
			} elseif ($key == '__PROJECT_NAME__') {
				$substitution = $this->title;
			}
		}

		return $substitution;
	}

	// phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps
	/**
	 * 	Return list of elements for type, linked to a project
	 *
	 * 	@param		string		$type			'propal','order','invoice','order_supplier','invoice_supplier',...
	 * 	@param		string		$tablename		name of table associated of the type
	 * 	@param		string		$datefieldname	name of date field for filter
	 *  @param		int			$date_start		Start date
	 *  @param		int			$date_end		End date
	 *	@param		string		$projectkey		Equivalent key  to fk_projet for actual type
	 * 	@return		mixed						Array list of object ids linked to project, < 0 or string if error
	 */
	public function get_element_list($type, $tablename, $datefieldname = '', $date_start = null, $date_end = null, $projectkey = 'fk_projet')
	{
		// phpcs:enable

		global $hookmanager;

		$elements = array();

		if ($this->id <= 0) {
			return $elements;
		}

		$ids = $this->id;

		if ($type == 'agenda') {
			$sql = "SELECT id as rowid FROM ".MAIN_DB_PREFIX."actioncomm WHERE fk_project IN (".$this->db->sanitize($ids).") AND entity IN (".getEntity('agenda').")";
		} elseif ($type == 'expensereport') {
			$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).")";
		} elseif ($type == 'project_task') {
			$sql = "SELECT DISTINCT pt.rowid FROM ".MAIN_DB_PREFIX."projet_task as pt WHERE pt.fk_projet IN (".$this->db->sanitize($ids).")";
		} elseif ($type == 'element_time') {	// Case we want to duplicate line foreach user
			$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).")";
		} elseif ($type == 'stocktransfer_stocktransfer') {
			$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";
		} elseif ($type == 'loan') {
			$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).")";
		} else {
			$sql = "SELECT rowid FROM ".MAIN_DB_PREFIX.$tablename." WHERE ".$projectkey." IN (".$this->db->sanitize($ids).") AND entity IN (".getEntity($type).")";
		}

		if (isDolTms($date_start) && $type == 'loan') {
			$sql .= " AND (dateend > '".$this->db->idate($date_start)."' OR dateend IS NULL)";
		} elseif (isDolTms($date_start) && ($type != 'project_task')) {	// For table project_taks, we want the filter on date apply on project_time_spent table
			if (empty($datefieldname) && !empty($this->table_element_date)) {
				$datefieldname = $this->table_element_date;
			}
			if (empty($datefieldname)) {
				return 'Error this object has no date field defined';
			}
			$sql .= " AND (".$datefieldname." >= '".$this->db->idate($date_start)."' OR ".$datefieldname." IS NULL)";
		}

		if (isDolTms($date_end) && $type == 'loan') {
			$sql .= " AND (datestart < '".$this->db->idate($date_end)."' OR datestart IS NULL)";
		} elseif (isDolTms($date_end) && ($type != 'project_task')) {	// For table project_taks, we want the filter on date apply on project_time_spent table
			if (empty($datefieldname) && !empty($this->table_element_date)) {
				$datefieldname = $this->table_element_date;
			}
			if (empty($datefieldname)) {
				return 'Error this object has no date field defined';
			}
			$sql .= " AND (".$datefieldname." <= '".$this->db->idate($date_end)."' OR ".$datefieldname." IS NULL)";
		}

		$parameters = array(
			'sql' => $sql,
			'type' => $type,
			'tablename' => $tablename,
			'datefieldname'  => $datefieldname,
			'dates' => $date_start,
			'datee' => $date_end,
			'fk_projet' => $projectkey,
			'ids' => $ids,
		);
		$reshook = $hookmanager->executeHooks('getElementList', $parameters);
		if ($reshook > 0) {
			$sql = $hookmanager->resPrint;
		} else {
			$sql .= $hookmanager->resPrint;
		}

		if (!$sql) {
			return -1;
		}

		//print $sql;
		dol_syslog(get_class($this)."::get_element_list", LOG_DEBUG);
		$result = $this->db->query($sql);
		if ($result) {
			$nump = $this->db->num_rows($result);
			if ($nump) {
				$i = 0;
				while ($i < $nump) {
					$obj = $this->db->fetch_object($result);

					$elements[$i] = $obj->rowid.(empty($obj->fk_user) ? '' : '_'.$obj->fk_user);

					$i++;
				}
				$this->db->free($result);
			}

			/* Return array even if empty*/
			return $elements;
		} else {
			dol_print_error($this->db);
		}
		return -1;
	}

	/**
	 *    Delete a project from database
	 *
	 *    @param       User		$user            User
	 *    @param       int		$notrigger       Disable triggers
	 *    @return      int       			      Return integer <0 if KO, 0 if not possible, >0 if OK
	 */
	public function delete($user, $notrigger = 0)
	{
		global $langs, $conf;
		require_once DOL_DOCUMENT_ROOT.'/core/lib/files.lib.php';

		$error = 0;

		$this->db->begin();

		if (!$error) {
			// Delete linked contacts
			$res = $this->delete_linked_contact();
			if ($res < 0) {
				$this->error = 'ErrorFailToDeleteLinkedContact';
				//$error++;
				$this->db->rollback();
				return 0;
			}
		}

		// Set fk_projet into elements to null
		$listoftables = array(
			'propal' => 'fk_projet',
			'commande' => 'fk_projet',
			'facture' => 'fk_projet',
			'supplier_proposal' => 'fk_projet',
			'commande_fournisseur' => 'fk_projet',
			'facture_fourn' => 'fk_projet',
			'expensereport_det' => 'fk_projet',
			'contrat' => 'fk_projet',
			'fichinter' => 'fk_projet',
			'don' => array('field' => 'fk_projet', 'module' => 'don'),
			'actioncomm' => 'fk_project',
			'mrp_mo' => array('field' => 'fk_project', 'module' => 'mrp'),
			'entrepot' => 'fk_project',
		);
		foreach ($listoftables as $key => $value) {
			if (is_array($value)) {
				if (!isModEnabled($value['module'])) {
					continue;
				}
				$fieldname = $value['field'];
			} else {
				$fieldname = $value;
			}
			$sql = "UPDATE ".MAIN_DB_PREFIX.$key." SET ".$fieldname." = NULL where ".$fieldname." = ".((int) $this->id);

			$resql = $this->db->query($sql);
			if (!$resql) {
				$this->errors[] = $this->db->lasterror();
				$error++;
				break;
			}
		}

		// Remove linked categories.
		if (!$error) {
			$sql = "DELETE FROM ".MAIN_DB_PREFIX."categorie_project";
			$sql .= " WHERE fk_project = ".((int) $this->id);

			$result = $this->db->query($sql);
			if (!$result) {
				$error++;
				$this->errors[] = $this->db->lasterror();
			}
		}

		// Fetch tasks
		$this->getLinesArray($user, 0);

		// Delete tasks
		$ret = $this->deleteTasks($user);
		if ($ret < 0) {
			$error++;
		}


		// Delete all child tables
		if (!$error) {
			$elements = array('categorie_project'); // elements to delete. TODO Make goodway to delete
			foreach ($elements as $table) {
				if (!$error) {
					$sql = "DELETE FROM ".MAIN_DB_PREFIX.$table;
					$sql .= " WHERE fk_project = ".((int) $this->id);

					$result = $this->db->query($sql);
					if (!$result) {
						$error++;
						$this->errors[] = $this->db->lasterror();
					}
				}
			}
		}

		if (!$error) {
			$sql = "DELETE FROM ".MAIN_DB_PREFIX."projet_extrafields";
			$sql .= " WHERE fk_object = ".((int) $this->id);

			$resql = $this->db->query($sql);
			if (!$resql) {
				$this->errors[] = $this->db->lasterror();
				$error++;
			}
		}

		// Delete project
		if (!$error) {
			$sql = "DELETE FROM ".MAIN_DB_PREFIX."projet";
			$sql .= " WHERE rowid=".((int) $this->id);

			$resql = $this->db->query($sql);
			if (!$resql) {
				$this->errors[] = $langs->trans("CantRemoveProject", $langs->transnoentitiesnoconv("ProjectOverview"));
				$error++;
			}
		}



		if (empty($error)) {
			// We remove directory
			$projectref = dol_sanitizeFileName($this->ref);
			if ($conf->project->dir_output) {
				$dir = $conf->project->dir_output."/".$projectref;
				if (file_exists($dir)) {
					$res = @dol_delete_dir_recursive($dir);
					if (!$res) {
						$this->errors[] = 'ErrorFailToDeleteDir';
						$error++;
					}
				}
			}

			if (!$notrigger) {
				// Call trigger
				$result = $this->call_trigger('PROJECT_DELETE', $user);

				if ($result < 0) {
					$error++;
				}
				// End call triggers
			}
		}

		if (empty($error)) {
			$this->db->commit();
			return 1;
		} else {
			foreach ($this->errors as $errmsg) {
				dol_syslog(get_class($this)."::delete ".$errmsg, LOG_ERR);
				$this->error .= ($this->error ? ', '.$errmsg : $errmsg);
			}
			dol_syslog(get_class($this)."::delete ".$this->error, LOG_ERR);
			$this->db->rollback();
			return -1;
		}
	}

	/**
	 * Return the count of a type of linked elements of this project
	 *
	 * @param string	$type			The type of the linked elements (e.g. 'propal', 'order', 'invoice', 'order_supplier', 'invoice_supplier')
	 * @param string	$tablename		The name of table associated of the type
	 * @param string	$projectkey 	(optional) Equivalent key to fk_projet for actual type
	 * @return integer					The count of the linked elements (the count is zero on request error too)
	 */
	public function getElementCount($type, $tablename, $projectkey = 'fk_projet')
	{
		if ($this->id <= 0) {
			return 0;
		}

		if ($type == 'agenda') {
			$sql = "SELECT COUNT(id) as nb FROM ".MAIN_DB_PREFIX."actioncomm WHERE fk_project = ".((int) $this->id)." AND entity IN (".getEntity('agenda').")";
		} elseif ($type == 'expensereport') {
			$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);
		} elseif ($type == 'project_task') {
			$sql = "SELECT DISTINCT COUNT(pt.rowid) as nb FROM ".MAIN_DB_PREFIX."projet_task as pt WHERE pt.fk_projet = ".((int) $this->id);
		} elseif ($type == 'element_time') {	// Case we want to duplicate line foreach user
			$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);
		} elseif ($type == 'stock_mouvement') {
			$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";
		} elseif ($type == 'loan') {
			$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);
		} else {
			$sql = "SELECT COUNT(rowid) as nb FROM ".MAIN_DB_PREFIX.$tablename." WHERE ".$projectkey." = ".((int) $this->id)." AND entity IN (".getEntity($type).")";
		}

		$result = $this->db->query($sql);

		if (!$result) {
			return 0;
		}

		$obj = $this->db->fetch_object($result);

		$this->db->free($result);

		return $obj->nb;
	}

	/**
	 *  Delete tasks with no children first, then task with children recursively
	 *
	 *  @param   User	$user		User
	 *  @return	 int				Return integer <0 if KO, 1 if OK
	 */
	public function deleteTasks($user)
	{
		$countTasks = count($this->lines);
		$deleted = false;
		if ($countTasks) {
			foreach ($this->lines as $task) {
				if ($task->hasChildren() <= 0) {		// If there is no children (or error to detect them)
					$deleted = true;
					$ret = $task->delete($user);
					if ($ret <= 0) {
						$this->errors[] = $this->db->lasterror();
						return -1;
					}
				}
			}
		}
		$this->getLinesArray($user);
		if ($deleted && count($this->lines) < $countTasks) {
			if (count($this->lines)) {
				$this->deleteTasks($user);
			}
		}

		return 1;
	}

	/**
	 * 		Validate a project
	 *
	 * 		@param		User	$user		   User that validate
	 *      @param      int     $notrigger     1=Disable triggers
	 * 		@return		int					   Return integer <0 if KO, 0=Nothing done, >0 if KO
	 */
	public function setValid($user, $notrigger = 0)
	{
		global $langs;

		$error = 0;

		// Protection
		if ($this->status == self::STATUS_VALIDATED) {
			dol_syslog(get_class($this)."::validate action abandoned: already validated", LOG_WARNING);
			return 0;
		}

		// Check parameters
		if (preg_match('/^'.preg_quote($langs->trans("CopyOf").' ').'/', $this->title)) {
			$this->error = $langs->trans("ErrorFieldFormat", $langs->transnoentities("Label")).'. '.$langs->trans('RemoveString', $langs->transnoentitiesnoconv("CopyOf"));
			return -1;
		}

		$this->db->begin();

		$sql = "UPDATE ".MAIN_DB_PREFIX."projet";
		$sql .= " SET fk_statut = ".self::STATUS_VALIDATED;
		$sql .= " WHERE rowid = ".((int) $this->id);
		//$sql .= " AND entity = ".((int) $conf->entity);	// Disabled, when we use the ID for the where, we must not add any other search condition

		dol_syslog(get_class($this)."::setValid", LOG_DEBUG);
		$resql = $this->db->query($sql);
		if ($resql) {
			// Call trigger
			if (empty($notrigger)) {
				$result = $this->call_trigger('PROJECT_VALIDATE', $user);
				if ($result < 0) {
					$error++;
				}
				// End call triggers
			}

			if (!$error) {
				$this->statut = 1;
				$this->status = 1;
				$this->db->commit();
				return 1;
			} else {
				$this->db->rollback();
				$this->error = implode(',', $this->errors);
				dol_syslog(get_class($this)."::setValid ".$this->error, LOG_ERR);
				return -1;
			}
		} else {
			$this->db->rollback();
			$this->error = $this->db->lasterror();
			return -1;
		}
	}

	/**
	 * 		Close a project
	 *
	 * 		@param		User	$user		User that close project
	 * 		@return		int					Return integer <0 if KO, 0 if already closed, >0 if OK
	 */
	public function setClose($user)
	{
		$now = dol_now();

		$error = 0;

		if ($this->status != self::STATUS_CLOSED) {
			$this->db->begin();

			$sql = "UPDATE ".MAIN_DB_PREFIX."projet";
			$sql .= " SET fk_statut = ".self::STATUS_CLOSED.", fk_user_close = ".((int) $user->id).", date_close = '".$this->db->idate($now)."'";
			$sql .= " WHERE rowid = ".((int) $this->id);
			$sql .= " AND fk_statut = ".self::STATUS_VALIDATED;

			if (getDolGlobalString('PROJECT_USE_OPPORTUNITIES')) {
				// TODO What to do if fk_opp_status is not code 'WON' or 'LOST'
			}

			dol_syslog(get_class($this)."::setClose", LOG_DEBUG);
			$resql = $this->db->query($sql);
			if ($resql) {
				// Call trigger
				$result = $this->call_trigger('PROJECT_CLOSE', $user);
				if ($result < 0) {
					$error++;
				}
				// End call triggers

				if (!$error) {
					$this->status = 2;
					$this->db->commit();
					return 1;
				} else {
					$this->db->rollback();
					$this->error = implode(',', $this->errors);
					dol_syslog(get_class($this)."::setClose ".$this->error, LOG_ERR);
					return -1;
				}
			} else {
				$this->db->rollback();
				$this->error = $this->db->lasterror();
				return -1;
			}
		}

		return 0;
	}

	/**
	 *  Return status label of object
	 *
	 *  @param  int			$mode       0=long label, 1=short label, 2=Picto + short label, 3=Picto, 4=Picto + long label, 5=Short label + Picto
	 * 	@return string      			Label
	 */
	public function getLibStatut($mode = 0)
	{
		return $this->LibStatut(isset($this->status) ? $this->status : $this->statut, $mode);
	}

	// phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps
	/**
	 *  Renvoi status label for a status
	 *
	 *  @param	int		$status     id status
	 *  @param  int		$mode       0=long label, 1=short label, 2=Picto + short label, 3=Picto, 4=Picto + long label, 5=Short label + Picto, 6=Long label + Picto
	 * 	@return string				Label
	 */
	public function LibStatut($status, $mode = 0)
	{
		// phpcs:enable
		global $langs;

		if (is_null($status)) {
			return '';
		}

		$statustrans = array(
			0 => 'status0',
			1 => 'status4',
			2 => 'status6',
		);

		$statusClass = 'status0';
		if (!empty($statustrans[$status])) {
			$statusClass = $statustrans[$status];
		}

		return dolGetStatus($langs->transnoentitiesnoconv($this->labelStatus[$status]), $langs->transnoentitiesnoconv($this->labelStatusShort[$status]), '', $statusClass, $mode);
	}

	/**
	 * getTooltipContentArray
	 * @param array<string,mixed> $params params to construct tooltip data
	 * @since v18
	 * @return array{picto?:string,ref?:string,refsupplier?:string,label?:string,date?:string,date_echeance?:string,amountht?:string,total_ht?:string,totaltva?:string,amountlt1?:string,amountlt2?:string,amountrevenustamp?:string,totalttc?:string}|array{optimize:string}
	 */
	public function getTooltipContentArray($params)
	{
		global $conf, $langs;

		$langs->load('projects');
		$option = $params['option'] ?? '';
		$moreinpopup = $params['moreinpopup'] ?? '';

		$datas = [];
		if ($option != 'nolink') {
			$datas['picto'] = img_picto('', $this->picto, 'class="pictofixedwidth"').' <u class="paddingrightonly">'.$langs->trans("Project").'</u>';
		}
		if (isset($this->status)) {
			$datas['picto'] .= ' '.$this->getLibStatut(5);
		}
		$datas['ref'] = (isset($datas['picto']) ? '<br>' : '').'<b>'.$langs->trans('Ref').': </b>'.$this->ref; // The space must be after the : to not being explode when showing the title in img_picto
		$datas['label'] = '<br><b>'.$langs->trans('Label').': </b>'.$this->title; // The space must be after the : to not being explode when showing the title in img_picto
		if (isset($this->public)) {
			$datas['visibility'] = '<br><b>'.$langs->trans("Visibility").":</b> ";
			$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"));
		}
		if (!empty($this->thirdparty_name)) {
			$datas['thirdparty'] = '<br><b>'.$langs->trans('ThirdParty').': </b>'.$this->thirdparty_name; // The space must be after the : to not being explode when showing the title in img_picto
		}
		if (!empty($this->date_start)) {
			$datas['datestart'] = '<br><b>'.$langs->trans('DateStart').': </b>'.dol_print_date($this->date_start, 'day'); // The space must be after the : to not being explode when showing the title in img_picto
		}
		if (!empty($this->date_end)) {
			$datas['dateend'] = '<br><b>'.$langs->trans('DateEnd').': </b>'.dol_print_date($this->date_end, 'day'); // The space must be after the : to not being explode when showing the title in img_picto
		}
		if ($moreinpopup) {
			$datas['moreinpopup'] = '<br>'.$moreinpopup;
		}

		return $datas;
	}

	/**
	 * 	Return clickable name (with picto eventually)
	 *
	 * 	@param	int		$withpicto		          0=No picto, 1=Include picto into link, 2=Only picto
	 * 	@param	string	$option			          Variant where the link point to ('', 'nolink')
	 * 	@param	int		$addlabel		          0=Default, 1=Add label into string, >1=Add first chars into string
	 *  @param	string	$moreinpopup	          Text to add into popup
	 *  @param	string	$sep			          Separator between ref and label if option addlabel is set
	 *  @param	int   	$notooltip		          1=Disable tooltip
	 *  @param  int     $save_lastsearch_value    -1=Auto, 0=No save of lastsearch_values when clicking, 1=Save lastsearch_values whenclicking
	 *  @param	string	$morecss				  More css on a link
	 *  @param	string	$save_pageforbacktolist		  Back to this page 'context:url'
	 * 	@return	string					          String with URL
	 */
	public function getNomUrl($withpicto = 0, $option = '', $addlabel = 0, $moreinpopup = '', $sep = ' - ', $notooltip = 0, $save_lastsearch_value = -1, $morecss = '', $save_pageforbacktolist = '')
	{
		global $conf, $langs, $user, $hookmanager;

		if (!empty($conf->dol_no_mouse_hover)) {
			$notooltip = 1; // Force disable tooltips
		}

		$result = '';
		if (getDolGlobalString('PROJECT_OPEN_ALWAYS_ON_TAB')) {
			$option = getDolGlobalString('PROJECT_OPEN_ALWAYS_ON_TAB');
		}
		$params = [
			'id' => $this->id,
			'objecttype' => $this->element,
			'moreinpopup' => $moreinpopup,
			'option' => $option,
		];
		$classfortooltip = 'classfortooltip';
		$dataparams = '';
		if (getDolGlobalInt('MAIN_ENABLE_AJAX_TOOLTIP')) {
			$classfortooltip = 'classforajaxtooltip';
			$dataparams = ' data-params="'.dol_escape_htmltag(json_encode($params)).'"';
			$label = '';
		} else {
			$label = implode($this->getTooltipContentArray($params));
		}

		$url = '';
		if ($option != 'nolink') {
			if (preg_match('/\.php$/', $option)) {
				$url = dol_buildpath($option, 1).'?id='.$this->id;
			} elseif ($option == 'task') {
				$url = DOL_URL_ROOT.'/projet/tasks.php?id='.$this->id;
			} elseif ($option == 'preview') {
				$url = DOL_URL_ROOT.'/projet/element.php?id='.$this->id;
			} elseif ($option == 'eventorganization') {
				$url = DOL_URL_ROOT.'/eventorganization/conferenceorbooth_list.php?projectid='.$this->id;
			} else {
				$url = DOL_URL_ROOT.'/projet/card.php?id='.$this->id;
			}
			// Add param to save lastsearch_values or not
			$add_save_lastsearch_values = ($save_lastsearch_value == 1 ? 1 : 0);
			if ($save_lastsearch_value == -1 && isset($_SERVER["PHP_SELF"]) && preg_match('/list\.php/', $_SERVER["PHP_SELF"])) {
				$add_save_lastsearch_values = 1;
			}
			if ($add_save_lastsearch_values) {
				$url .= '&save_lastsearch_values=1';
			}
			$add_save_backpagefor = ($save_pageforbacktolist ? 1 : 0);
			if ($add_save_backpagefor) {
				$url .= "&save_pageforbacktolist=".urlencode($save_pageforbacktolist);
			}
		}

		$linkclose = '';
		if (empty($notooltip) && $user->hasRight('projet', 'lire')) {
			if (getDolGlobalString('MAIN_OPTIMIZEFORTEXTBROWSER')) {
				$label = $langs->trans("ShowProject");
				$linkclose .= ' alt="'.dolPrintHTMLForAttribute($label).'"';
			}
			$linkclose .= ($label ? ' title="'.dolPrintHTMLForAttribute($label).'"' : ' title="tocomplete"');
			$linkclose .= $dataparams.' class="'.$classfortooltip.($morecss ? ' '.$morecss : '').'"';
		} else {
			$linkclose = ($morecss ? ' class="'.$morecss.'"' : '');
		}

		$picto = 'projectpub';
		if (!$this->public) {
			$picto = 'project';
		}

		$linkstart = '<a href="'.$url.'"';
		$linkstart .= $linkclose.'>';
		$linkend = '</a>';

		$result .= $linkstart;
		if ($withpicto) {
			$result .= img_object(($notooltip ? '' : $label), $picto, 'class="pictofixedwidth em088"', 0, 0, $notooltip ? 0 : 1);
		}
		if ($withpicto != 2) {
			$result .= $this->ref;
		}
		$result .= $linkend;
		if ($withpicto != 2) {
			$result .= (($addlabel && $this->title) ? '<span class="opacitymedium">'.$sep.dol_trunc($this->title, ($addlabel > 1 ? $addlabel : 0)).'</span>' : '');
		}

		global $action;
		$hookmanager->initHooks(array('projectdao'));
		$parameters = array('id' => $this->id, 'getnomurl' => &$result);
		$reshook = $hookmanager->executeHooks('getNomUrl', $parameters, $this, $action); // Note that $action and $object may have been modified by some hooks
		if ($reshook > 0) {
			$result = $hookmanager->resPrint;
		} else {
			$result .= $hookmanager->resPrint;
		}

		return $result;
	}

	/**
	 *  Initialise an instance with random values.
	 *  Used to build previews or test instances.
	 * 	id must be 0 if object instance is a specimen.
	 *
	 *  @return int
	 */
	public function initAsSpecimen()
	{
		global $user, $langs, $conf;

		$now = dol_now();

		// Initialise parameters
		$this->id = 0;
		$this->ref = 'SPECIMEN';
		$this->entity = $conf->entity;
		$this->specimen = 1;
		$this->socid = 1;
		$this->date_c = $now;
		$this->date_m = $now;
		$this->date_start = $now;
		$this->date_end = $now + (3600 * 24 * 365);
		$this->note_public = 'SPECIMEN';
		$this->note_private = 'Private Note';
		$this->fk_project = 0;
		$this->opp_amount = 20000;
		$this->budget_amount = 10000;

		$this->usage_opportunity = 1;
		$this->usage_task = 1;
		$this->usage_bill_time = 1;
		$this->usage_organize_event = 1;

		/*
		 $nbp = mt_rand(1, 9);
		 $xnbp = 0;
		 while ($xnbp < $nbp)
		 {
		 $line = new Task($this->db);
		 $line->fk_project = 0;
		 $line->label = $langs->trans("Label") . " " . $xnbp;
		 $line->description = $langs->trans("Description") . " " . $xnbp;

		 $this->lines[]=$line;
		 $xnbp++;
		 }
		 */

		return 1;
	}

	/**
	 * 	Check if user has permission on current project
	 *
	 * 	@param	User	$user		Object user to evaluate
	 * 	@param  string	$mode		Type of permission we want to know: 'read', 'write'
	 * 	@return	int					>0 if user has permission, <0 if user has no permission
	 */
	public function restrictedProjectArea(User $user, $mode = 'read')
	{
		// To verify role of users
		$userAccess = 0;
		if (($mode == 'read' && $user->hasRight('projet', 'all', 'lire')) || ($mode == 'write' && $user->hasRight('projet', 'all', 'creer')) || ($mode == 'delete' && $user->hasRight('projet', 'all', 'supprimer'))) {
			$userAccess = 1;
		} elseif ($this->public && (($mode == 'read' && $user->hasRight('projet', 'lire')) || ($mode == 'write' && $user->hasRight('projet', 'creer')) || ($mode == 'delete' && $user->hasRight('projet', 'supprimer')))) {
			$userAccess = 1;
		} else {	// No access due to permission to read all projects, so we check if we are a contact of project
			foreach (array('internal', 'external') as $source) {
				$userRole = $this->liste_contact(4, $source);
				$num = count($userRole);

				$nblinks = 0;
				while ($nblinks < $num) {
					if ($source == 'internal' && $user->id == $userRole[$nblinks]['id']) {	// $userRole[$nblinks]['id'] is id of user (llx_user) for internal contacts
						if ($mode == 'read' && $user->hasRight('projet', 'lire')) {
							$userAccess++;
						}
						if ($mode == 'write' && $user->hasRight('projet', 'creer')) {
							$userAccess++;
						}
						if ($mode == 'delete' && $user->hasRight('projet', 'supprimer')) {
							$userAccess++;
						}
					}
					if ($source == 'external' && $user->socid > 0 && $user->socid == $userRole[$nblinks]['socid']) {	// $userRole[$nblinks]['id'] is id of contact (llx_socpeople) or external contacts
						if ($mode == 'read' && $user->hasRight('projet', 'lire')) {
							$userAccess++;
						}
						if ($mode == 'write' && $user->hasRight('projet', 'creer')) {
							$userAccess++;
						}
						if ($mode == 'delete' && $user->hasRight('projet', 'supprimer')) {
							$userAccess++;
						}
					}
					$nblinks++;
				}
			}
			//if (empty($nblinks))	// If nobody has permission, we grant creator
			//{
			//	if ((!empty($this->user_author_id) && $this->user_author_id == $user->id))
			//	{
			//		$userAccess = 1;
			//	}
			//}
		}

		return ($userAccess ? $userAccess : -1);
	}

	/**
	 * Return array of projects a user has permission on, is affected to, or all projects
	 *
	 * @param 	User	$user			User object
	 * @param 	int		$mode			0=All project I have permission on (assigned to me or public), 1=Projects assigned to me only, 2=Will return list of all projects with no test on contacts
	 * @param 	int		$list			0=Return array, 1=Return string list
	 * @param	int		$socid			0=No filter on third party, id of third party
	 * @param	string	$filter			Additional filter on project (statut, ref, ...). TODO Use USF syntax here.
	 * @return 	int[]|string			Array of projects id, or string with projects id separated with "," if list is 1
	 */
	public function getProjectsAuthorizedForUser($user, $mode = 0, $list = 0, $socid = 0, $filter = '')
	{
		$projects = array();
		$temp = array();

		$sql = "SELECT ".(($mode == 0 || $mode == 1) ? "DISTINCT " : "")."p.rowid, p.ref";
		$sql .= " FROM ".MAIN_DB_PREFIX."projet as p";
		if ($mode == 0) {
			$sql .= " LEFT JOIN ".MAIN_DB_PREFIX."element_contact as ec ON ec.element_id = p.rowid";
		} elseif ($mode == 1) {
			$sql .= ", ".MAIN_DB_PREFIX."element_contact as ec";
		} // elseif ($mode == 2) {
		// No filter. Use this if user has permission to see all project
		// }
		$sql .= " WHERE p.entity IN (".getEntity('project').")";
		// Internal users must see project he is contact to even if project linked to a third party he can't see.
		//if ($socid || ! $user->rights->societe->client->voir)	$sql.= " AND (p.fk_soc IS NULL OR p.fk_soc = 0 OR p.fk_soc = ".((int) $socid).")";
		if ($socid > 0) {
			$sql .= " AND (p.fk_soc IS NULL OR p.fk_soc = 0 OR p.fk_soc = ".((int) $socid).")";
		}

		// Get id of types of contacts for projects (This list never contains a lot of elements)
		$listofprojectcontacttype = array();
		$sql2 = "SELECT ctc.rowid, ctc.code FROM ".MAIN_DB_PREFIX."c_type_contact as ctc";
		$sql2 .= " WHERE ctc.element = '".$this->db->escape($this->element)."'";
		$sql2 .= " AND ctc.source = 'internal'";
		$resql = $this->db->query($sql2);
		if ($resql) {
			while ($obj = $this->db->fetch_object($resql)) {
				$listofprojectcontacttype[$obj->rowid] = $obj->code;
			}
		} else {
			dol_print_error($this->db);
		}
		if (count($listofprojectcontacttype) == 0) {
			$listofprojectcontacttype[0] = '0'; // To avoid syntax error if not found
		}

		if ($mode == 0) {
			$sql .= " AND ( p.public = 1";
			$sql .= " OR ( ec.fk_c_type_contact IN (".$this->db->sanitize(implode(',', array_keys($listofprojectcontacttype))).")";
			$sql .= " AND ec.fk_socpeople = ".((int) $user->id).")";
			$sql .= " )";
		} elseif ($mode == 1) {
			$sql .= " AND ec.element_id = p.rowid";
			$sql .= " AND (";
			$sql .= "  ( ec.fk_c_type_contact IN (".$this->db->sanitize(implode(',', array_keys($listofprojectcontacttype))).")";
			$sql .= " AND ec.fk_socpeople = ".((int) $user->id).")";
			$sql .= " )";
		} // elseif ($mode == 2) {
		// No filter. Use this if user has permission to see all project
		//}

		// Manage filter
		$errormessage = '';
		$sql .= forgeSQLFromUniversalSearchCriteria($filter, $errormessage);
		if ($errormessage) {
			$this->errors[] = $errormessage;
			dol_syslog(__METHOD__.' '.implode(',', $this->errors), LOG_ERR);
			$sql .= $filter;
		}

		//print $sql;

		$resql = $this->db->query($sql);
		if ($resql) {
			$num = $this->db->num_rows($resql);
			$i = 0;
			while ($i < $num) {
				$row = $this->db->fetch_row($resql);
				$projects[$row[0]] = $row[1];
				$temp[] = $row[0];
				$i++;
			}

			$this->db->free($resql);

			if ($list) {
				if (empty($temp)) {
					return '0';
				}
				$result = implode(',', $temp);
				return $result;
			}
		} else {
			dol_print_error($this->db);
		}

		return $projects;
	}

	/**
	 * Load an object from its id and create a new one in database
	 *
	 *  @param	User	$user		          User making the clone
	 *  @param	int		$fromid     	      Id of object to clone
	 *  @param	bool	$clone_contact	      Clone contact of project
	 *  @param	bool	$clone_task		      Clone task of project
	 *  @param	bool	$clone_project_file	  Clone file of project
	 *  @param	bool	$clone_task_file	  Clone file of task (if task are copied)
	 *  @param	bool	$clone_note		      Clone note of project
	 *  @param	bool	$move_date		      Move task date on clone
	 *  @param	int    	$notrigger		      No trigger flag
	 *  @param  int     $newthirdpartyid      New thirdparty id
	 *  @return	int						      New id of clone
	 */
	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)
	{
		global $langs, $conf;

		$error = 0;
		$clone_project_id = 0;   // For static toolcheck

		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);

		$now = dol_mktime(0, 0, 0, idate('m', dol_now()), idate('d', dol_now()), idate('Y', dol_now()));

		$clone_project = new Project($this->db);

		$clone_project->context['createfromclone'] = 'createfromclone';

		$this->db->begin();

		// Load source object
		$clone_project->fetch($fromid);
		$clone_project->fetch_optionals();
		$clone_project->socid = ($newthirdpartyid > 0 ? $newthirdpartyid : 0);
		$clone_project->fetch_thirdparty();

		$orign_dt_start = $clone_project->date_start;
		$orign_project_ref = $clone_project->ref;

		$clone_project->id = 0;
		if ($move_date) {
			$clone_project->date_start = $now;
			if (!(empty($clone_project->date_end))) {
				$clone_project->date_end += ($now - $orign_dt_start);
			}
		}

		$clone_project->date_c = $now;

		if (!$clone_note) {
			$clone_project->note_private = '';
			$clone_project->note_public = '';
		}

		//Generate next ref
		$defaultref = '';
		$obj = getDolGlobalString('PROJECT_ADDON', 'mod_project_simple');
		// Search template files
		$file = '';
		$classname = '';
		$filefound = 0;
		$dirmodels = array_merge(array('/'), (array) $conf->modules_parts['models']);
		foreach ($dirmodels as $reldir) {
			$file = dol_buildpath($reldir."core/modules/project/".$obj.'.php', 0);
			if (file_exists($file)) {
				$filefound = 1;
				dol_include_once($reldir."core/modules/project/".$obj.'.php');
				$modProject = new $obj();
				'@phan-var-force ModeleNumRefProjects $modProject';
				$defaultref = $modProject->getNextValue(is_object($clone_project->thirdparty) ? $clone_project->thirdparty : null, $clone_project);
				break;
			}
		}
		if (is_numeric($defaultref) && $defaultref <= 0) {
			$defaultref = '';
		}

		$clone_project->ref = $defaultref;
		$clone_project->title = $langs->trans("CopyOf").' '.$clone_project->title;

		// Create clone
		$result = $clone_project->create($user, $notrigger);

		// Other options
		if ($result < 0) {
			$this->error .= $clone_project->error;
			$error++;
		}

		if (!$error) {
			//Get the new project id
			$clone_project_id = $clone_project->id;

			//Note Update
			if (!$clone_note) {
				$clone_project->note_private = '';
				$clone_project->note_public = '';
			} else {
				$this->db->begin();
				$res = $clone_project->update_note(dol_html_entity_decode($clone_project->note_public, ENT_QUOTES | ENT_HTML5), '_public');
				if ($res < 0) {
					$this->error .= $clone_project->error;
					$error++;
					$this->db->rollback();
				} else {
					$this->db->commit();
				}

				$this->db->begin();
				$res = $clone_project->update_note(dol_html_entity_decode($clone_project->note_private, ENT_QUOTES | ENT_HTML5), '_private');
				if ($res < 0) {
					$this->error .= $clone_project->error;
					$error++;
					$this->db->rollback();
				} else {
					$this->db->commit();
				}
			}

			//Duplicate contact
			if ($clone_contact) {
				$origin_project = new Project($this->db);
				$origin_project->fetch($fromid);

				foreach (array('internal', 'external') as $source) {
					$tab = $origin_project->liste_contact(-1, $source);
					if (is_array($tab) && count($tab) > 0) {
						foreach ($tab as $contacttoadd) {
							$clone_project->add_contact($contacttoadd['id'], $contacttoadd['code'], $contacttoadd['source'], $notrigger);
							if ($clone_project->error == 'DB_ERROR_RECORD_ALREADY_EXISTS') {
								$langs->load("errors");
								$this->error .= $langs->trans("ErrorThisContactIsAlreadyDefinedAsThisType");
								$error++;
							} else {
								if ($clone_project->error != '') {
									$this->error .= $clone_project->error;
									$error++;
								}
							}
						}
					} elseif ($tab < 0) {
						$this->error .= $origin_project->error;
						$error++;
					}
				}
			}

			//Duplicate file
			if ($clone_project_file) {
				require_once DOL_DOCUMENT_ROOT.'/core/lib/files.lib.php';

				$clone_project_dir = $conf->project->dir_output."/".dol_sanitizeFileName($defaultref);
				$ori_project_dir = $conf->project->dir_output."/".dol_sanitizeFileName($orign_project_ref);

				if (dol_mkdir($clone_project_dir) >= 0) {
					$filearray = dol_dir_list($ori_project_dir, "files", 0, '', '(\.meta|_preview.*\.png)$', '', SORT_ASC, 1);
					foreach ($filearray as $key => $file) {
						$rescopy = dol_copy($ori_project_dir.'/'.$file['name'], $clone_project_dir.'/'.$file['name'], '0', 1);
						if (is_numeric($rescopy) && $rescopy < 0) {
							$this->error .= $langs->trans("ErrorFailToCopyFile", $ori_project_dir.'/'.$file['name'], $clone_project_dir.'/'.$file['name']);
							$error++;
						}
					}
				} else {
					$this->error .= $langs->trans('ErrorInternalErrorDetected').':dol_mkdir';
					$error++;
				}
			}

			//Duplicate task
			if ($clone_task) {
				require_once DOL_DOCUMENT_ROOT.'/projet/class/task.class.php';

				$taskstatic = new Task($this->db);

				// Security check
				$socid = 0;
				if ($user->socid > 0) {
					$socid = $user->socid;
				}

				$tasksarray = $taskstatic->getTasksArray(null, null, $fromid, $socid, 0);

				$tab_conv_child_parent = array();
				$result_clone = 0;

				// Loop on each task, to clone it
				foreach ($tasksarray as $tasktoclone) {
					$result_clone = $taskstatic->createFromClone($user, $tasktoclone->id, $clone_project_id, $tasktoclone->fk_task_parent, $move_date, true, false, $clone_task_file, true, false);
					if ($result_clone <= 0) {
						$this->error .= $taskstatic->error;
						$error++;
					} else {
						$new_task_id = $result_clone;
						$taskstatic->fetch($tasktoclone->id);

						//manage new parent clone task id
						// if the current task has child we store the original task id and the equivalent clone task id
						if (($taskstatic->hasChildren()) && !array_key_exists($tasktoclone->id, $tab_conv_child_parent)) {
							$tab_conv_child_parent[$tasktoclone->id] = $new_task_id;
						}
					}
				}

				//Parse all clone node to be sure to update new parent
				$tasksarray = $taskstatic->getTasksArray(null, null, $clone_project_id, $socid, 0);
				foreach ($tasksarray as $task_cloned) {
					$taskstatic->fetch($task_cloned->id);
					if ($taskstatic->fk_task_parent != 0) {
						$taskstatic->fk_task_parent = $tab_conv_child_parent[$taskstatic->fk_task_parent];
					}
					$res = $taskstatic->update($user, $notrigger);
					if ($result_clone <= 0) {
						$this->error .= $taskstatic->error;
						$error++;
					}
				}
			}
		}

		unset($clone_project->context['createfromclone']);

		if (!$error && $clone_project_id != 0) {
			$this->db->commit();
			return $clone_project_id;
		} else {
			$this->db->rollback();
			dol_syslog(get_class($this)."::createFromClone nbError: ".$error." error : ".$this->error, LOG_ERR);
			return -1;
		}
	}


	/**
	 *    Shift project task date from current date to delta
	 *
	 *    @param	integer		$old_project_dt_start	Old project start date
	 *    @return	int				                    1 if OK or < 0 if KO
	 */
	public function shiftTaskDate($old_project_dt_start)
	{
		global $user, $langs, $conf;

		$error = 0;
		$result = 0;

		$taskstatic = new Task($this->db);

		// Security check
		$socid = 0;
		if ($user->socid > 0) {
			$socid = $user->socid;
		}

		$tasksarray = $taskstatic->getTasksArray(null, null, $this->id, $socid, 0);

		foreach ($tasksarray as $tasktoshiftdate) {
			$to_update = false;
			// Fetch only if update of date will be made
			if ((!empty($tasktoshiftdate->date_start)) || (!empty($tasktoshiftdate->date_end))) {
				//dol_syslog(get_class($this)."::shiftTaskDate to_update", LOG_DEBUG);
				$to_update = true;
				$task = new Task($this->db);
				$result = $task->fetch($tasktoshiftdate->id);
				if (!$result) {
					$error++;
					$this->error .= $task->error;
				}
			} else {
				continue;
			}
			//print "$this->date_start + $tasktoshiftdate->date_start - $old_project_dt_start";exit;

			//Calculate new task start date with difference between old proj start date and origin task start date
			if (!empty($tasktoshiftdate->date_start)) {
				$task->date_start = $this->date_start + ($tasktoshiftdate->date_start - $old_project_dt_start);
			}

			//Calculate new task end date with difference between origin proj end date and origin task end date
			if (!empty($tasktoshiftdate->date_end)) {
				$task->date_end = $this->date_start + ($tasktoshiftdate->date_end - $old_project_dt_start);
			}

			if ($to_update) {
				$result = $task->update($user);
				if (!$result) {
					$error++;
					$this->error .= $task->error;
				}
			}
		}
		if ($error != 0) {
			return -1;
		}
		return $result;
	}


	// phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps
	/**
	 *    Associate element to a project
	 *
	 *    @param	string	$tableName			Table of the element to update
	 *    @param	int		$elementSelectId	Key-rowid of the line of the element to update
	 *    @return	int							1 if OK or < 0 if KO
	 */
	public function update_element($tableName, $elementSelectId)
	{
		// phpcs:enable
		$sql = "UPDATE ".MAIN_DB_PREFIX.$tableName;

		if ($tableName == "actioncomm") {
			$sql .= " SET fk_project=".$this->id;
			$sql .= " WHERE id=".((int) $elementSelectId);
		} elseif (in_array($tableName, ["entrepot","mrp_mo","stocktransfer_stocktransfer"])) {
			$sql .= " SET fk_project=".$this->id;
			$sql .= " WHERE rowid=".((int) $elementSelectId);
		} else {
			$sql .= " SET fk_projet=".$this->id;
			$sql .= " WHERE rowid=".((int) $elementSelectId);
		}

		dol_syslog(get_class($this)."::update_element", LOG_DEBUG);
		$resql = $this->db->query($sql);
		if (!$resql) {
			$this->error = $this->db->lasterror();
			return -1;
		} else {
			return 1;
		}
	}

	// phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps
	/**
	 *    Associate element to a project
	 *
	 *    @param	string	$tableName			Table of the element to update
	 *    @param	int		$elementSelectId	Key-rowid of the line of the element to update
	 *    @param	string	$projectfield	    The column name that stores the link with the project
	 *
	 *    @return	int							1 if OK or < 0 if KO
	 */
	public function remove_element($tableName, $elementSelectId, $projectfield = 'fk_projet')
	{
		// phpcs:enable
		$sql = "UPDATE ".MAIN_DB_PREFIX.$tableName;

		if ($tableName == "actioncomm") {
			$sql .= " SET fk_project=NULL";
			$sql .= " WHERE id=".((int) $elementSelectId);
		} else {
			$sql .= " SET ".$projectfield."=NULL";
			$sql .= " WHERE rowid=".((int) $elementSelectId);
		}

		dol_syslog(get_class($this)."::remove_element", LOG_DEBUG);
		$resql = $this->db->query($sql);
		if (!$resql) {
			$this->error = $this->db->lasterror();
			return -1;
		} else {
			return 1;
		}
	}

	/**
	 *  Create an intervention document on disk using template defined into PROJECT_ADDON_PDF
	 *
	 *  @param	string		$modele			Force template to use ('' by default)
	 *  @param	Translate	$outputlangs	Object lang to use for translation
	 *  @param  int			$hidedetails    Hide details of lines
	 *  @param  int			$hidedesc       Hide description
	 *  @param  int			$hideref        Hide ref
	 *  @return int         				0 if KO, 1 if OK
	 */
	public function generateDocument($modele, $outputlangs, $hidedetails = 0, $hidedesc = 0, $hideref = 0)
	{
		global $conf, $langs;

		$langs->load("projects");

		if (!dol_strlen($modele)) {
			$modele = 'baleine';

			if ($this->model_pdf) {
				$modele = $this->model_pdf;
			} elseif (getDolGlobalString('PROJECT_ADDON_PDF')) {
				$modele = getDolGlobalString('PROJECT_ADDON_PDF');
			}
		}

		$modelpath = "core/modules/project/doc/";

		return $this->commonGenerateDocument($modelpath, $modele, $outputlangs, $hidedetails, $hidedesc, $hideref);
	}


	/**
	 * Load time spent into this->weekWorkLoad and this->weekWorkLoadPerTask for all day of a week of project.
	 * Note: array weekWorkLoad and weekWorkLoadPerTask are reset and filled at each call.
	 *
	 * @param 	int		$datestart		First day of week (use dol_get_first_day to find this date)
	 * @param 	int		$taskid			Filter on a task id
	 * @param 	int		$userid			Time spent by a particular user
	 * @return 	int						Return integer <0 if OK, >0 if KO
	 */
	public function loadTimeSpent($datestart, $taskid = 0, $userid = 0)
	{
		$this->weekWorkLoad = array();
		$this->weekWorkLoadPerTask = array();

		if (empty($datestart)) {
			dol_print_error(null, 'Error datestart parameter is empty');
		}

		$sql = "SELECT ptt.rowid as taskid, ptt.element_duration, ptt.element_date, ptt.element_datehour, ptt.fk_element";
		$sql .= " FROM ".MAIN_DB_PREFIX."element_time AS ptt, ".MAIN_DB_PREFIX."projet_task as pt";
		$sql .= " WHERE ptt.fk_element = pt.rowid";
		$sql .= " AND ptt.elementtype = 'task'";
		$sql .= " AND pt.fk_projet = ".((int) $this->id);
		$sql .= " AND (ptt.element_date >= '".$this->db->idate($datestart)."' ";
		$sql .= " AND ptt.element_date <= '".$this->db->idate(dol_time_plus_duree($datestart, 1, 'w') - 1)."')";
		if ($taskid) {
			$sql .= " AND ptt.fk_element=".((int) $taskid);
		}
		if (is_numeric($userid)) {
			$sql .= " AND ptt.fk_user=".((int) $userid);
		}

		//print $sql;
		$resql = $this->db->query($sql);
		if ($resql) {
			$dayallreadyfound = array();

			$num = $this->db->num_rows($resql);
			$i = 0;
			// Loop on each record found, so each couple (project id, task id)
			while ($i < $num) {
				$obj = $this->db->fetch_object($resql);
				$day = $this->db->jdate($obj->element_date); // task_date is date without hours
				if (empty($dayallreadyfound[$day])) {
					$this->weekWorkLoad[$day] = $obj->element_duration;
					$this->weekWorkLoadPerTask[$day][$obj->fk_element] = $obj->element_duration;
				} else {
					$this->weekWorkLoad[$day] += $obj->element_duration;
					$this->weekWorkLoadPerTask[$day][$obj->fk_element] += $obj->element_duration;
				}
				$dayallreadyfound[$day] = 1;
				$i++;
			}
			$this->db->free($resql);
			return 1;
		} else {
			$this->error = "Error ".$this->db->lasterror();
			dol_syslog(get_class($this)."::fetch ".$this->error, LOG_ERR);
			return -1;
		}
	}

	/**
	 * Load time spent into this->weekWorkLoad and this->weekWorkLoadPerTask for all day of a week of project.
	 * Note: array weekWorkLoad and weekWorkLoadPerTask are reset and filled at each call.
	 *
	 * @param 	int		$datestart		First day of week (use dol_get_first_day to find this date)
	 * @param 	int		$taskid			Filter on a task id
	 * @param 	int		$userid			Time spent by a particular user
	 * @return 	int						Return integer <0 if OK, >0 if KO
	 */
	public function loadTimeSpentMonth($datestart, $taskid = 0, $userid = 0)
	{
		$this->monthWorkLoad = array();
		$this->monthWorkLoadPerTask = array();

		if (empty($datestart)) {
			dol_print_error(null, 'Error datestart parameter is empty');
		}

		$sql = "SELECT ptt.rowid as taskid, ptt.element_duration, ptt.element_date, ptt.element_datehour, ptt.fk_element";
		$sql .= " FROM ".MAIN_DB_PREFIX."element_time AS ptt, ".MAIN_DB_PREFIX."projet_task as pt";
		$sql .= " WHERE ptt.fk_element = pt.rowid";
		$sql .= " AND ptt.elementtype = 'task'";
		$sql .= " AND pt.fk_projet = ".((int) $this->id);
		$sql .= " AND (ptt.element_date >= '".$this->db->idate($datestart)."' ";
		$sql .= " AND ptt.element_date <= '".$this->db->idate(dol_time_plus_duree($datestart, 1, 'm') - 1)."')";
		if ($taskid) {
			$sql .= " AND ptt.fk_element=".((int) $taskid);
		}
		if (is_numeric($userid)) {
			$sql .= " AND ptt.fk_user=".((int) $userid);
		}

		//print $sql;
		$resql = $this->db->query($sql);
		if ($resql) {
			$weekalreadyfound = array();

			$num = $this->db->num_rows($resql);
			$i = 0;
			$week_number = '';  // Initialisation for static analysis
			// Loop on each record found, so each couple (project id, task id)
			while ($i < $num) {
				$obj = $this->db->fetch_object($resql);
				if (!empty($obj->element_date)) {
					$date = explode('-', $obj->element_date);
					$week_number = getWeekNumber((int) $date[2], (int) $date[1], (int) $date[0]);
				}
				if (empty($weekalreadyfound[$week_number])) {
					$this->monthWorkLoad[$week_number] = $obj->element_duration;
					$this->monthWorkLoadPerTask[$week_number][$obj->fk_element] = $obj->element_duration;
				} else {
					$this->monthWorkLoad[$week_number] += $obj->element_duration;
					if (!isset($this->monthWorkLoadPerTask[$week_number][$obj->fk_element])) {
						$this->monthWorkLoadPerTask[$week_number][$obj->fk_element] = 0;
					}
					$this->monthWorkLoadPerTask[$week_number][$obj->fk_element] += $obj->element_duration;
				}
				$weekalreadyfound[$week_number] = 1;
				$i++;
			}
			$this->db->free($resql);
			return 1;
		} else {
			$this->error = "Error ".$this->db->lasterror();
			dol_syslog(get_class($this)."::fetch ".$this->error, LOG_ERR);
			return -1;
		}
	}

	// phpcs:disable PEAR.NamingConventions.ValidFunctionName.ScopeNotCamelCaps
	/**
	 * Load indicators for dashboard (this->nbtodo and this->nbtodolate)
	 *
	 * @param	User	$user   Object user
	 * @return WorkboardResponse|int Return integer <0 if KO, WorkboardResponse if OK
	 */
	public function load_board($user)
	{
		// phpcs:enable
		global $conf, $langs;

		// For external user, no check is done on company because readability is managed by public status of project and assignment.
		//$socid=$user->socid;

		$response = new WorkboardResponse();
		$response->warning_delay = $conf->project->warning_delay / 60 / 60 / 24;
		$response->label = $langs->trans("OpenedProjects");
		$response->labelShort = $langs->trans("Opened");
		$response->url = DOL_URL_ROOT.'/projet/list.php?search_project_user=-1&search_status=1&mainmenu=project';
		$response->url_late = DOL_URL_ROOT.'/projet/list.php?search_option=late&mainmenu=project';
		$response->img = img_object('', "projectpub");
		$response->nbtodo = 0;
		$response->nbtodolate = 0;

		$sql = "SELECT p.rowid, p.fk_statut as status, p.fk_opp_status, p.datee as datee";
		$sql .= " FROM (".MAIN_DB_PREFIX."projet as p";
		$sql .= ")";
		$sql .= " LEFT JOIN ".MAIN_DB_PREFIX."societe as s on p.fk_soc = s.rowid";
		// For external user, no check is done on company permission because readability is managed by public status of project and assignment.
		//if (! $user->rights->societe->client->voir && ! $socid) $sql .= " LEFT JOIN ".MAIN_DB_PREFIX."societe_commerciaux as sc ON sc.fk_soc = s.rowid";
		$sql .= " WHERE p.fk_statut = 1";
		$sql .= " AND p.entity IN (".getEntity('project').')';


		$projectsListId = null;
		if (!$user->hasRight("projet", "all", "lire")) {
			$response->url = DOL_URL_ROOT.'/projet/list.php?search_status=1&mainmenu=project';
			$projectsListId = $this->getProjectsAuthorizedForUser($user, 0, 1);
			if (empty($projectsListId)) {
				return $response;
			}

			$sql .= " AND p.rowid IN (".$this->db->sanitize($projectsListId).")";
		}

		// No need to check company, as filtering of projects must be done by getProjectsAuthorizedForUser
		//if ($socid || ! $user->rights->societe->client->voir)	$sql.= "  AND (p.fk_soc IS NULL OR p.fk_soc = 0 OR p.fk_soc = ".((int) $socid).")";
		// For external user, no check is done on company permission because readability is managed by public status of project and assignment.
		//if (! $user->rights->societe->client->voir && ! $socid) $sql.= " AND ((s.rowid = sc.fk_soc AND sc.fk_user = ".((int) $user->id).") OR (s.rowid IS NULL))";

		//print $sql;
		$resql = $this->db->query($sql);
		if ($resql) {
			$project_static = new Project($this->db);


			// This assignment in condition is not a bug. It allows walking the results.
			while ($obj = $this->db->fetch_object($resql)) {
				$response->nbtodo++;

				$project_static->statut = $obj->status;
				$project_static->status = $obj->status;
				$project_static->opp_status = $obj->fk_opp_status;
				$project_static->date_end = $this->db->jdate($obj->datee);

				if ($project_static->hasDelay()) {
					$response->nbtodolate++;
				}
			}

			return $response;
		}

		$this->error = $this->db->error();
		return -1;
	}

	/**
	 * Function used to replace a thirdparty id with another one.
	 *
	 * @param DoliDB $dbs 		Database handler
	 * @param int $origin_id 	Old thirdparty id
	 * @param int $dest_id 		New thirdparty id
	 * @return bool
	 */
	public static function replaceThirdparty(DoliDB $dbs, $origin_id, $dest_id)
	{
		$tables = array(
			'projet'
		);

		return CommonObject::commonReplaceThirdparty($dbs, $origin_id, $dest_id, $tables);
	}


	/**
	 * Load indicators this->nb for the state board
	 *
	 * @return     int         Return integer <0 if KO, >0 if OK
	 */
	public function loadStateBoard()
	{
		global $user;

		$this->nb = array();

		$sql = "SELECT count(p.rowid) as nb";
		$sql .= " FROM ".MAIN_DB_PREFIX."projet as p";
		$sql .= " WHERE";
		$sql .= " p.entity IN (".getEntity('project').")";
		if (!$user->hasRight('projet', 'all', 'lire')) {
			$projectsListId = $this->getProjectsAuthorizedForUser($user, 0, 1);
			$sql .= "AND p.rowid IN (".$this->db->sanitize($projectsListId).")";
		}

		$resql = $this->db->query($sql);
		if ($resql) {
			while ($obj = $this->db->fetch_object($resql)) {
				$this->nb["projects"] = $obj->nb;
			}
			$this->db->free($resql);
			return 1;
		} else {
			dol_print_error($this->db);
			$this->error = $this->db->error();
			return -1;
		}
	}


	/**
	 * Is the project delayed?
	 *
	 * @return bool
	 */
	public function hasDelay()
	{
		global $conf;

		if (!($this->status == self::STATUS_VALIDATED)) {
			return false;
		}
		if (!$this->date_end) {
			return false;
		}

		$now = dol_now();

		return ($this->date_end) < ($now - $conf->project->warning_delay);
	}


	/**
	 *	Charge les information d'ordre info dans l'objet commande
	 *
	 *	@param  int		$id       Id of order
	 *	@return	void
	 */
	public function info($id)
	{
		$sql = 'SELECT c.rowid, datec as datec, tms as datem,';
		$sql .= ' date_close as datecloture,';
		$sql .= ' fk_user_creat as fk_user_author, fk_user_close as fk_user_cloture';
		$sql .= ' FROM '.MAIN_DB_PREFIX.'projet as c';
		$sql .= ' WHERE c.rowid = '.((int) $id);
		$result = $this->db->query($sql);
		if ($result) {
			if ($this->db->num_rows($result)) {
				$obj = $this->db->fetch_object($result);

				$this->id = $obj->rowid;

				$this->user_creation_id = $obj->fk_user_author;
				$this->user_closing_id   = $obj->fk_user_cloture;

				$this->date_creation     = $this->db->jdate($obj->datec);
				$this->date_modification = $this->db->jdate($obj->datem);
				$this->date_cloture      = $this->db->jdate($obj->datecloture);
			}

			$this->db->free($result);
		} else {
			dol_print_error($this->db);
		}
	}

	/**
	 * Sets object to supplied categories.
	 *
	 * Deletes object from existing categories not supplied.
	 * Adds it to non existing supplied categories.
	 * Existing categories are left untouch.
	 *
	 * @param 	int[]|int 	$categories 	Category or categories IDs
	 * @return 	int							Return integer <0 if KO, >0 if OK
	 */
	public function setCategories($categories)
	{
		require_once DOL_DOCUMENT_ROOT.'/categories/class/categorie.class.php';
		return parent::setCategoriesCommon($categories, Categorie::TYPE_PROJECT);
	}


	/**
	 * Create an array of tasks of current project
	 *
	 * @param	?User	$user       		Object user we want project allowed to
	 * @param	int		$loadRoleMode		1= will test Roles on task;  0 used in delete project action
	 * @return 	int							>0 if OK, <0 if KO
	 */
	public function getLinesArray($user, $loadRoleMode = 1)
	{
		require_once DOL_DOCUMENT_ROOT.'/projet/class/task.class.php';
		$taskstatic = new Task($this->db);

		$this->lines = $taskstatic->getTasksArray(null, $user, $this->id, 0, 0, '', '-1', '', 0, 0, null, 0, array(), 0, $loadRoleMode);
		return 1;
	}

	/**
	 *  Function sending an email to the current project with the text supplied in parameter.
	 *  TODO When this is used ?
	 *
	 *  @param	string	$text				Content of message (not html entities encoded)
	 *  @param	string	$subject			Subject of message
	 *  @param	string[]	$filename_list      Array of attached files
	 *  @param 	string[]	$mimetype_list      Array of mime types of attached files
	 *  @param 	string[]	$mimefilename_list  Array of public names of attached files
	 *  @param 	string	$addr_cc            Email cc
	 *  @param 	string	$addr_bcc           Email bcc
	 *  @param 	int		$deliveryreceipt	Ask a delivery receipt
	 *  @param	int		$msgishtml			1=String IS already html, 0=String IS NOT html, -1=Unknown need autodetection
	 *  @param	string	$errors_to			errors to
	 *  @param	string	$moreinheader		Add more html headers
	 *  @since V18
	 *  @return	int							Return integer <0 if KO, >0 if OK
	 */
	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 = '')
	{
		// TODO EMAIL

		return 1;
	}

	/**
	 *	Return clickable link of object (with eventually picto)
	 *
	 *	@param      string	    			$option                 Where point the link (0=> main card, 1,2 => shipment, 'nolink'=>No link)
	 *  @param		array{string,mixed}		$arraydata				Array of data
	 *  @param		string					$size					Size of thumb (''=auto, 'large'=large, 'small'=small)
	 *  @return		string											HTML Code for Kanban thumb.
	 */
	public function getKanbanView($option = '', $arraydata = null, $size = '')
	{
		global $conf, $langs;

		$selected = (empty($arraydata['selected']) ? 0 : $arraydata['selected']);

		if (empty($size)) {
			if (empty($conf->dol_optimize_smallscreen)) {
				$size = 'large';
			} else {
				$size = 'small';
			}
		}

		$return = '<div class="box-flex-item '.($size == 'small' ? 'box-flex-item-small' : '').' box-flex-grow-zero">';
		$return .= '<div class="info-box info-box-sm">';
		$return .= '<span class="info-box-icon bg-infobox-action">';
		$return .= img_picto('', $this->public ? 'projectpub' : $this->picto);
		//$return .= '<i class="fa fa-dol-action"></i>'; // Can be image
		$return .= '</span>';
		$return .= '<div class="info-box-content">';
		$return .= '<span class="info-box-ref inline-block tdoverflowmax150 valignmiddle">'.(method_exists($this, 'getNomUrl') ? $this->getNomUrl() : $this->ref);
		if ($this->hasDelay()) {
			$return .= img_warning($langs->trans('Late'));
		}
		$return .= '</span>';
		if ($selected >= 0) {
			$return .= '<input id="cb'.$this->id.'" class="flat checkforselect fright" type="checkbox" name="toselect[]" value="'.$this->id.'"'.($selected ? ' checked="checked"' : '').'>';
		}
		// Date
		/*
		if (property_exists($this, 'date_start') && $this->date_start) {
			$return .= '<br><span class="info-box-label">'.dol_print_date($this->date_start, 'day').'</>';
		}
		if (property_exists($this, 'date_end') && $this->date_end) {
			if ($this->date_start) {
				$return .= ' - ';
			} else {
				$return .= '<br>';
			}
			$return .= '<span class="info-box-label">'.dol_print_date($this->date_end, 'day').'</span>';
		}*/
		if (property_exists($this, 'thirdparty') && !is_null($this->thirdparty) && is_object($this->thirdparty) && $this->thirdparty instanceof Societe) {
			$return .= '<br><div class="info-box-ref tdoverflowmax125 inline-block valignmiddle">'.$this->thirdparty->getNomUrl(1);
			$return .= '</div>';
			if (!empty($this->thirdparty->phone)) {
				$return .= '<div class="inline-block valignmiddle">';
				$return .= dol_print_phone($this->thirdparty->phone, $this->thirdparty->country_code, 0, $this->thirdparty->id, 'tel', 'hidenum', 'phone', $this->thirdparty->phone, 0, 'paddingleft paddingright');  // @phan-suppress-current-line PhanPluginSuspiciousParamPosition
				$return .= '</div>';
			}
			if (!empty($this->thirdparty->email)) {
				$return .= '<div class="inline-block valignmiddle">';
				$return .= dol_print_email($this->thirdparty->email, 0, $this->thirdparty->id, 'thirdparty', -1, 1, 2, 'paddingleft paddingright');
				$return .= '</div>';
			}
		}
		if (!empty($arraydata['assignedusers'])) {
			$return .= '<br>';
			if ($this->public) {
				$return .= img_picto($langs->trans('Visibility').': '.$langs->trans('SharedProject'), 'world', 'class="paddingrightonly valignmiddle"');
				//print $langs->trans('SharedProject');
			} else {
				$return .= img_picto($langs->trans('Visibility').': '.$langs->trans('PrivateProject'), 'private', 'class="paddingrightonly valignmiddle"');
				//print $langs->trans('PrivateProject');
			}

			$return .= ' <span class="small valignmiddle">'.$arraydata['assignedusers'].'</span>';
		}
		/*if (property_exists($this, 'user_author_id')) {
			$return .= '<br><span class="info-box-label opacitymedium">'.$langs->trans("Author").'</span>';
			$return .= '<span> : '.$user->getNomUrl(1).'</span>';
		}*/
		$return .= '<br><div>';	// start div line status
		if ($this->usage_opportunity && $this->opp_status_code) {
			//$return .= '<br><span class="info-bo-label opacitymedium">'.$langs->trans("OpportunityStatusShort").'</span>';
			//$return .= '<div class="small inline-block">'.dol_trunc($langs->trans("OppStatus".$this->opp_status_code), 5).'</div>';
			$return .= '<div class="opacitymedium small marginrightonly inline-block" title="'.dol_escape_htmltag($langs->trans("OppStatus".$this->opp_status_code)).'">'.round($this->opp_percent).'%</div>';
			$return .= ' <div class="amount small marginrightonly inline-block">'.price($this->opp_amount).'</div>';
		}
		if (method_exists($this, 'getLibStatut')) {
			$return .= '<div class="info-box-status small inline-block valignmiddle">'.$this->getLibStatut(3).'</div>';
		}
		$return .= '</div>';	// end div line status

		$return .= '</div>';
		$return .= '</div>';
		$return .= '</div>';

		return $return;
	}

	/**
	 *  Return array of sub-projects of the current project
	 *
	 *  @return		stdClass[]	Children of this project as objects with rowid & title as members
	 */
	public function getChildren()
	{
		$children = [];
		$sql = 'SELECT rowid,title';
		$sql .= ' FROM '.MAIN_DB_PREFIX.'projet';
		$sql .= ' WHERE fk_project = '.((int) $this->id);
		$sql .= ' ORDER BY title';
		$result = $this->db->query($sql);
		if ($result) {
			$n = $this->db->num_rows($result);
			while ($n) {
				$children[] = $this->db->fetch_object($result);
				$n--;
			}
			$this->db->free($result);
		} else {
			dol_print_error($this->db);
		}

		return $children;
	}

	/**
	 * Method for calculating weekly hours worked and generating a report
	 * @return int   0 if OK, <>0 if KO (this function is used also by cron so only 0 is OK)
	 */
	public function createWeeklyReport()
	{
		global $mysoc, $user;

		$now = dol_now();
		$nowDate = dol_getdate($now, true);

		$errormesg = '';
		$errorsMsg = array();

		$firstDayOfWeekTS = dol_get_first_day_week($nowDate['mday'], $nowDate['mon'], $nowDate['year']);

		$firstDayOfWeekDate = dol_mktime(0, 0, 0, $nowDate['mon'], $firstDayOfWeekTS['first_day'], $nowDate['year']);

		$lastWeekStartTS = dol_time_plus_duree($firstDayOfWeekDate, -7, 'd');

		$lastWeekEndTS = dol_time_plus_duree($lastWeekStartTS, 6, 'd');

		$startDate = dol_print_date($lastWeekStartTS, '%Y-%m-%d 00:00:00');
		$endDate = dol_print_date($lastWeekEndTS, '%Y-%m-%d 23:59:59');

		$sql = "SELECT
		u.rowid AS user_id,
		CONCAT(u.firstname, ' ', u.lastname) AS name,
		u.email,u.weeklyhours,
		SUM(et.element_duration) AS total_seconds
		FROM
			".MAIN_DB_PREFIX."element_time AS et
		JOIN
			".MAIN_DB_PREFIX."user AS u ON et.fk_user = u.rowid
		WHERE
			et.element_date BETWEEN '".$this->db->escape($startDate)."' AND '".$this->db->escape($endDate)."'
			AND et.elementtype = 'task'
		GROUP BY
			et.fk_user";

		$resql = $this->db->query($sql);
		if (!$resql) {
			dol_print_error($this->db);
			return -1;
		} else {
			$reportContent = "<span>Weekly time report from $startDate to $endDate </span><br><br>";
			$reportContent .= '<table border="1" style="border-collapse: collapse;">';
			$reportContent .= '<tr><th>Nom d\'utilisateur</th><th>Temps saisi (heures)</th><th>Temps travaillé par semaine (heures)</th></tr>';

			$weekendEnabled = 0;
			$to = '';
			$nbMailSend = 0;
			$error = 0;
			$errors_to = '';
			while ($obj = $this->db->fetch_object($resql)) {
				$to = $obj->email;
				$numHolidays = num_public_holiday($lastWeekStartTS, $lastWeekEndTS, $mysoc->country_code, 1);
				if (getDolGlobalString('MAIN_NON_WORKING_DAYS_INCLUDE_SATURDAY') && getDolGlobalString('MAIN_NON_WORKING_DAYS_INCLUDE_SUNDAY')) {
					$numHolidays -= 2;
					$weekendEnabled = 2;
				}

				$dailyHours = $obj->weeklyhours / (7 - $weekendEnabled);

				// Adjust total on seconde
				$adjustedSeconds = $obj->total_seconds + ($numHolidays * $dailyHours * 3600);

				$totalHours = round($adjustedSeconds / 3600, 2);

				$reportContent .= "<tr><td>{$obj->name}</td><td>{$totalHours}</td><td>".round($obj->weeklyhours, 2)."</td></tr>";

				$reportContent .= '</table>';

				require_once DOL_DOCUMENT_ROOT.'/core/class/CMailFile.class.php';

				// PREPARE EMAIL
				$errormesg = '';

				$subject = 'Rapport hebdomadaire des temps travaillés';

				$from = getDolGlobalString('MAIN_MAIL_EMAIL_FROM');
				if (empty($from)) {
					$errormesg = "Failed to get sender into global setup MAIN_MAIL_EMAIL_FROM";
					$error++;
				}

				$mail = new CMailFile($subject, $to, $from, $reportContent, array(), array(), array(), '', '', 0, -1, '', '', '', 'text/html');

				if ($mail->sendfile()) {
					$nbMailSend++;

					// Add a line into event table
					require_once DOL_DOCUMENT_ROOT.'/comm/action/class/actioncomm.class.php';

					// Insert record of emails sent
					$actioncomm = new ActionComm($this->db);

					$actioncomm->type_code = 'AC_OTH_AUTO'; // Event insert into agenda automatically
					$actioncomm->socid = $this->thirdparty->id; // To link to a company
					$actioncomm->contact_id = 0;

					$actioncomm->code = 'AC_EMAIL';
					$actioncomm->label = 'createWeeklyReportOK()';
					$actioncomm->fk_project = $this->id;
					$actioncomm->datep = dol_now();
					$actioncomm->datef = $actioncomm->datep;
					$actioncomm->percentage = -1; // Not applicable
					$actioncomm->authorid = $user->id; // User saving action
					$actioncomm->userownerid = $user->id; // Owner of action
					// Fields when action is an email (content should be added into note)
					$actioncomm->email_msgid = $mail->msgid;
					$actioncomm->email_subject = $subject;
					$actioncomm->email_from = $from;
					$actioncomm->email_sender = '';
					$actioncomm->email_to = $to;

					$actioncomm->errors_to = $errors_to;

					$actioncomm->elementtype = 'project_task';
					$actioncomm->fk_element = (int) $this->element;

					$actioncomm->create($user);
				} else {
					$errormesg = $mail->error.' : '.$to;
					$error++;

					// Add a line into event table
					require_once DOL_DOCUMENT_ROOT.'/comm/action/class/actioncomm.class.php';

					// Insert record of emails sent
					$actioncomm = new ActionComm($this->db);

					$actioncomm->type_code = 'AC_OTH_AUTO'; // Event insert into agenda automatically
					$actioncomm->socid = $this->thirdparty->id; // To link to a company
					$actioncomm->contact_id = 0;

					$actioncomm->code = 'AC_EMAIL';
					$actioncomm->label = 'createWeeklyReportKO()';
					$actioncomm->note_private = $errormesg;
					$actioncomm->fk_project = $this->id;
					$actioncomm->datep = dol_now();
					$actioncomm->datef = $actioncomm->datep;
					$actioncomm->authorid = $user->id; // User saving action
					$actioncomm->userownerid = $user->id; // Owner of action
					// Fields when action is an email (content should be added into note)
					$actioncomm->email_msgid = $mail->msgid;
					$actioncomm->email_from = $from;
					$actioncomm->email_sender = '';
					$actioncomm->email_to = $to;

					$actioncomm->errors_to = $errors_to;

					$actioncomm->elementtype = 'project_task';
					$actioncomm->fk_element = (int) $this->element;

					$actioncomm->create($user);
				}
				$this->db->commit();
			}
		}
		if (!empty($errormesg)) {
			$errorsMsg[] = $errormesg;
		}

		if (!$error) {
			$this->output .= 'Nb of emails sent : '.$nbMailSend;
			dol_syslog(__METHOD__." end - ".$this->output, LOG_INFO);
			return 0;
		} else {
			$this->error = 'Nb of emails sent : '.$nbMailSend.', '.(empty($errorsMsg) ? $error : implode(', ', $errorsMsg));
			dol_syslog(__METHOD__." end - ".$this->error, LOG_INFO);
			return $error;
		}
	}
}
