2796 lines
99 KiB
PHP
2796 lines
99 KiB
PHP
<?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
|
|
* @see $date_start
|
|
*/
|
|
public $dateo;
|
|
|
|
/**
|
|
* @var int Date start
|
|
*/
|
|
public $date_start;
|
|
|
|
/**
|
|
* @var int Date end
|
|
* @deprecated
|
|
* @see $date_end
|
|
*/
|
|
public $datee;
|
|
|
|
/**
|
|
* @var int 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;
|
|
|
|
public $socid; // To store id of thirdparty
|
|
|
|
/**
|
|
* @var string thirdparty name
|
|
*/
|
|
public $thirdparty_name; // To store name of thirdparty (defined only in some cases)
|
|
|
|
public $user_author_id; //!< Id of project creator. Not defined if shared project.
|
|
|
|
/**
|
|
* @var int user close id
|
|
*/
|
|
public $fk_user_close;
|
|
|
|
public $public; //!< Tell if this is a public or private project
|
|
|
|
/**
|
|
* @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
|
|
* @see $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;
|
|
|
|
public $oldcopy;
|
|
|
|
public $weekWorkLoad; // Used to store workload details of a projet
|
|
public $weekWorkLoadPerTask; // Used to store workload details of tasks of a projet
|
|
|
|
/**
|
|
* @var array Used to store workload details of a projet
|
|
*/
|
|
public $monthWorkLoad;
|
|
|
|
/**
|
|
* @var array Used to store workload details of tasks of a projet
|
|
*/
|
|
public $monthWorkLoadPerTask;
|
|
|
|
/**
|
|
* @var int Creation date
|
|
* @deprecated
|
|
* @see $date_c
|
|
*/
|
|
public $datec;
|
|
|
|
/**
|
|
* @var int Creation date
|
|
*/
|
|
public $date_c;
|
|
|
|
/**
|
|
* @var int Modification date
|
|
* @deprecated
|
|
* @see $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<-2,5>|string,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,2>,disabled?:int<0,1>,arrayofkeyval?:array<int|string,string>,comment?:string,validate?: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' => 55, 'searchall' => 202),
|
|
'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 = ".$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' => 'fk_project',
|
|
'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 $params ex option, infologin
|
|
* @since v18
|
|
* @return array
|
|
*/
|
|
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="'.dol_escape_htmltag($label, 1).'"';
|
|
}
|
|
$linkclose .= ($label ? ' title="'.dol_escape_htmltag($label, 1).'"' : ' 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 array|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
|
|
}
|
|
|
|
$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();
|
|
if ($newthirdpartyid > 0) {
|
|
$clone_project->socid = $newthirdpartyid;
|
|
}
|
|
$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();
|
|
$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(0, 0, $fromid, $socid, 0);
|
|
|
|
$tab_conv_child_parent = array();
|
|
|
|
// 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(0, 0, $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(0, 0, $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;
|
|
}
|
|
}
|
|
//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) {
|
|
$daylareadyfound = 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($daylareadyfound[$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;
|
|
}
|
|
$daylareadyfound[$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;
|
|
// 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]);
|
|
}
|
|
'@phan-var-force int $week_number'; // Needed because phan considers it might be null
|
|
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;
|
|
$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(0, $user, $this->id, 0, 0, '', '-1', '', 0, 0, array(), 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 array $filename_list Array of attached files
|
|
* @param array $mimetype_list Array of mime types of attached files
|
|
* @param array $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');
|
|
$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 array 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;
|
|
}
|
|
}
|
|
}
|