mirror of
https://github.com/salesagility/SuiteCRM.git
synced 2024-12-22 12:28:31 +00:00
654 lines
24 KiB
PHP
Executable File
654 lines
24 KiB
PHP
Executable File
<?php
|
|
if (!defined('sugarEntry') || !sugarEntry) {
|
|
die('Not A Valid Entry Point');
|
|
}
|
|
/**
|
|
*
|
|
* SugarCRM Community Edition is a customer relationship management program developed by
|
|
* SugarCRM, Inc. Copyright (C) 2004-2013 SugarCRM Inc.
|
|
*
|
|
* SuiteCRM is an extension to SugarCRM Community Edition developed by SalesAgility Ltd.
|
|
* Copyright (C) 2011 - 2018 SalesAgility Ltd.
|
|
*
|
|
* This program is free software; you can redistribute it and/or modify it under
|
|
* the terms of the GNU Affero General Public License version 3 as published by the
|
|
* Free Software Foundation with the addition of the following permission added
|
|
* to Section 15 as permitted in Section 7(a): FOR ANY PART OF THE COVERED WORK
|
|
* IN WHICH THE COPYRIGHT IS OWNED BY SUGARCRM, SUGARCRM DISCLAIMS THE WARRANTY
|
|
* OF NON INFRINGEMENT OF THIRD PARTY RIGHTS.
|
|
*
|
|
* 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 Affero General Public License for more
|
|
* details.
|
|
*
|
|
* You should have received a copy of the GNU Affero General Public License along with
|
|
* this program; if not, see http://www.gnu.org/licenses or write to the Free
|
|
* Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA
|
|
* 02110-1301 USA.
|
|
*
|
|
* You can contact SugarCRM, Inc. headquarters at 10050 North Wolfe Road,
|
|
* SW2-130, Cupertino, CA 95014, USA. or at email address contact@sugarcrm.com.
|
|
*
|
|
* The interactive user interfaces in modified source and object code versions
|
|
* of this program must display Appropriate Legal Notices, as required under
|
|
* Section 5 of the GNU Affero General Public License version 3.
|
|
*
|
|
* In accordance with Section 7(b) of the GNU Affero General Public License version 3,
|
|
* these Appropriate Legal Notices must retain the display of the "Powered by
|
|
* SugarCRM" logo and "Supercharged by SuiteCRM" logo. If the display of the logos is not
|
|
* reasonably feasible for technical reasons, the Appropriate Legal Notices must
|
|
* display the words "Powered by SugarCRM" and "Supercharged by SuiteCRM".
|
|
*/
|
|
|
|
|
|
#[\AllowDynamicProperties]
|
|
class Project extends SugarBean
|
|
{
|
|
// database table columns
|
|
public $id;
|
|
public $date_entered;
|
|
public $date_modified;
|
|
public $assigned_user_id;
|
|
public $modified_user_id;
|
|
public $created_by;
|
|
public $name;
|
|
public $description;
|
|
public $deleted;
|
|
|
|
|
|
// related information
|
|
public $assigned_user_name;
|
|
public $modified_by_name;
|
|
public $created_by_name;
|
|
|
|
public $account_id;
|
|
public $contact_id;
|
|
public $opportunity_id;
|
|
public $email_id;
|
|
public $estimated_start_date;
|
|
public $team_id;
|
|
|
|
// calculated information
|
|
public $total_estimated_effort;
|
|
public $total_actual_effort;
|
|
|
|
public $object_name = 'Project';
|
|
public $module_dir = 'Project';
|
|
public $new_schema = true;
|
|
public $table_name = 'project';
|
|
|
|
public $importable = true;
|
|
|
|
// This is used to retrieve related fields from form posts.
|
|
public $additional_column_fields = array(
|
|
'account_id',
|
|
'contact_id',
|
|
'opportunity_id',
|
|
);
|
|
|
|
public $relationship_fields = array(
|
|
'account_id' => 'accounts',
|
|
'contact_id'=>'contacts',
|
|
'opportunity_id'=>'opportunities',
|
|
'email_id' => 'emails',
|
|
);
|
|
|
|
//////////////////////////////////////////////////////////////////
|
|
// METHODS
|
|
//////////////////////////////////////////////////////////////////
|
|
|
|
/**
|
|
*
|
|
*/
|
|
public function __construct()
|
|
{
|
|
parent::__construct();
|
|
}
|
|
|
|
|
|
|
|
|
|
/**
|
|
* overriding the base class function to do a join with users table
|
|
*/
|
|
|
|
/**
|
|
*
|
|
*/
|
|
public function fill_in_additional_detail_fields()
|
|
{
|
|
parent::fill_in_additional_detail_fields();
|
|
|
|
$this->assigned_user_name = get_assigned_user_name($this->assigned_user_id);
|
|
//$this->total_estimated_effort = $this->_get_total_estimated_effort($this->id);
|
|
//$this->total_actual_effort = $this->_get_total_actual_effort($this->id);
|
|
}
|
|
|
|
/**
|
|
*
|
|
*/
|
|
public function fill_in_additional_list_fields()
|
|
{
|
|
parent::fill_in_additional_list_fields();
|
|
$this->assigned_user_name = get_assigned_user_name($this->assigned_user_id);
|
|
//$this->total_estimated_effort = $this->_get_total_estimated_effort($this->id);
|
|
//$this->total_actual_effort = $this->_get_total_actual_effort($this->id);
|
|
}
|
|
|
|
/**
|
|
* Save changes that have been made to a relationship.
|
|
*
|
|
* @param $is_update true if this save is an update.
|
|
*/
|
|
public function save_relationship_changes($is_update, $exclude=array())
|
|
{
|
|
parent::save_relationship_changes($is_update, $exclude);
|
|
$new_rel_id = false;
|
|
$new_rel_link = false;
|
|
//this allows us to dynamically relate modules without adding it to the relationship_fields array
|
|
if (!empty($_REQUEST['relate_id']) && !in_array($_REQUEST['relate_to'], $exclude) && $_REQUEST['relate_id'] != $this->id) {
|
|
$new_rel_id = $_REQUEST['relate_id'];
|
|
$new_rel_relname = $_REQUEST['relate_to'];
|
|
if (!empty($this->in_workflow) && !empty($this->not_use_rel_in_req)) {
|
|
$new_rel_id = $this->new_rel_id;
|
|
$new_rel_relname = $this->new_rel_relname;
|
|
}
|
|
$new_rel_link = $new_rel_relname;
|
|
//Try to find the link in this bean based on the relationship
|
|
foreach ($this->field_defs as $key => $def) {
|
|
if (isset($def['type']) && $def['type'] == 'link'
|
|
&& isset($def['relationship']) && $def['relationship'] == $new_rel_relname) {
|
|
$new_rel_link = $key;
|
|
}
|
|
}
|
|
if ($new_rel_link == 'contacts') {
|
|
$accountId = $this->db->getOne('SELECT account_id FROM accounts_contacts WHERE contact_id=' . $this->db->quoted($new_rel_id));
|
|
if ($accountId !== false) {
|
|
if ($this->load_relationship('accounts')) {
|
|
$this->accounts->add($accountId);
|
|
}
|
|
}
|
|
}
|
|
}
|
|
}
|
|
/**
|
|
*
|
|
*/
|
|
public function _get_total_estimated_effort($project_id)
|
|
{
|
|
$return_value = '';
|
|
|
|
$query = 'SELECT SUM('.$this->db->convert('estimated_effort', "IFNULL", 0).') total_estimated_effort';
|
|
$query.= ' FROM project_task';
|
|
$query.= " WHERE parent_id='{$project_id}' AND deleted=0";
|
|
|
|
$result = $this->db->query($query, true, " Error filling in additional detail fields: ");
|
|
$row = $this->db->fetchByAssoc($result);
|
|
if ($row != null) {
|
|
$return_value = $row['total_estimated_effort'];
|
|
}
|
|
|
|
return $return_value;
|
|
}
|
|
|
|
/**
|
|
*
|
|
*/
|
|
public function _get_total_actual_effort($project_id)
|
|
{
|
|
$return_value = '';
|
|
|
|
$query = 'SELECT SUM('.$this->db->convert('actual_effort', "IFNULL", 0).') total_actual_effort';
|
|
$query.= ' FROM project_task';
|
|
$query.= " WHERE parent_id='{$project_id}' AND deleted=0";
|
|
|
|
$result = $this->db->query($query, true, " Error filling in additional detail fields: ");
|
|
$row = $this->db->fetchByAssoc($result);
|
|
if ($row != null) {
|
|
$return_value = $row['total_actual_effort'];
|
|
}
|
|
|
|
return $return_value;
|
|
}
|
|
|
|
/**
|
|
*
|
|
*/
|
|
public function get_summary_text()
|
|
{
|
|
return $this->name;
|
|
}
|
|
|
|
/**
|
|
*
|
|
*/
|
|
public function build_generic_where_clause($the_query_string)
|
|
{
|
|
$where_clauses = array();
|
|
$the_query_string = DBManagerFactory::getInstance()->quote($the_query_string);
|
|
array_push($where_clauses, "project.name LIKE '%$the_query_string%'");
|
|
|
|
$the_where = '';
|
|
foreach ($where_clauses as $clause) {
|
|
if ($the_where != '') {
|
|
$the_where .= " OR ";
|
|
}
|
|
$the_where .= $clause;
|
|
}
|
|
|
|
return $the_where;
|
|
}
|
|
|
|
public function get_list_view_data()
|
|
{
|
|
$field_list = $this->get_list_view_array();
|
|
$field_list['USER_NAME'] = empty($this->user_name) ? '' : $this->user_name;
|
|
$field_list['ASSIGNED_USER_NAME'] = $this->assigned_user_name;
|
|
return $field_list;
|
|
}
|
|
public function bean_implements($interface)
|
|
{
|
|
switch ($interface) {
|
|
case 'ACL':return true;
|
|
}
|
|
return false;
|
|
}
|
|
|
|
public function create_export_query($order_by, $where, $relate_link_join='')
|
|
{
|
|
$custom_join = $this->getCustomJoin(true, true, $where);
|
|
$custom_join['join'] .= $relate_link_join;
|
|
$query = "SELECT
|
|
project.*,
|
|
users.user_name as assigned_user_name ";
|
|
$query .= $custom_join['select'];
|
|
$query .= " FROM project ";
|
|
|
|
$query .= $custom_join['join'];
|
|
$query .= " LEFT JOIN users
|
|
ON project.assigned_user_id=users.id ";
|
|
|
|
$where_auto = " project.deleted=0 ";
|
|
|
|
if ($where != "") {
|
|
$query .= "where ($where) AND ".$where_auto;
|
|
} else {
|
|
$query .= "where ".$where_auto;
|
|
}
|
|
|
|
if (!empty($order_by)) {
|
|
//check to see if order by variable already has table name by looking for dot "."
|
|
$table_defined_already = strpos((string) $order_by, ".");
|
|
|
|
if ($table_defined_already === false) {
|
|
//table not defined yet, define accounts to avoid "ambigous column" SQL error
|
|
$query .= " ORDER BY $order_by";
|
|
} else {
|
|
//table already defined, just add it to end of query
|
|
$query .= " ORDER BY $order_by";
|
|
}
|
|
}
|
|
return $query;
|
|
}
|
|
public function getAllProjectTasks()
|
|
{
|
|
$projectTasks = array();
|
|
|
|
$query = "SELECT * FROM project_task WHERE project_id = '" . $this->id. "' AND deleted = 0 ORDER BY project_task_id";
|
|
$result = $this->db->query($query, true, "Error retrieving project tasks");
|
|
$row = $this->db->fetchByAssoc($result);
|
|
|
|
while ($row != null) {
|
|
$projectTaskBean = BeanFactory::newBean('ProjectTask');
|
|
$projectTaskBean->id = $row['id'];
|
|
$projectTaskBean->retrieve();
|
|
array_push($projectTasks, $projectTaskBean);
|
|
|
|
$row = $this->db->fetchByAssoc($result);
|
|
}
|
|
|
|
return $projectTasks;
|
|
}
|
|
|
|
public function getDefaultStatus()
|
|
{
|
|
$def = $this->field_defs['status'];
|
|
if (isset($def['default'])) {
|
|
return $def['default'];
|
|
}
|
|
$app = return_app_list_strings_language($GLOBALS['current_language']);
|
|
if (isset($def['options']) && isset($app[$def['options']])) {
|
|
$keys = array_keys($app[$def['options']]);
|
|
return $keys[0];
|
|
}
|
|
|
|
return '';
|
|
}
|
|
|
|
public function save($check_notify = false)
|
|
{
|
|
global $current_user;
|
|
$db = DBManagerFactory::getInstance();
|
|
$focus = $this;
|
|
$enddate_array = [];
|
|
|
|
//--- check if project template is same or changed.
|
|
$new_template_id = property_exists($focus, 'am_projecttemplates_project_1am_projecttemplates_ida') ?
|
|
$focus->am_projecttemplates_project_1am_projecttemplates_ida : null;
|
|
$current_template_id = "";
|
|
|
|
$focus->load_relationship('am_projecttemplates_project_1');
|
|
$project_template = $focus->get_linked_beans('am_projecttemplates_project_1', 'AM_ProjectTemplates');
|
|
foreach ($project_template as $ptemplate) {
|
|
$current_template_id = $ptemplate->id;
|
|
}
|
|
//----------------------------------------------------------------
|
|
|
|
|
|
|
|
//if(!empty($this->id))
|
|
// $focus->retrieve($this->id);
|
|
|
|
if ((isset($_POST['isSaveFromDetailView']) && $_POST['isSaveFromDetailView'] == 'true') ||
|
|
(isset($_POST['is_ajax_call']) && !empty($_POST['is_ajax_call']) && !empty($focus->id) ||
|
|
(isset($_POST['return_action']) && $_POST['return_action'] == 'SubPanelViewer') && !empty($focus->id))||
|
|
!isset($_POST['user_invitees']) // we need to check that user_invitees exists before processing, it is ok to be empty
|
|
) {
|
|
parent::save($check_notify) ; //$focus->save(true);
|
|
$return_id = $focus->id;
|
|
} else {
|
|
if (!empty($_POST['user_invitees'])) {
|
|
$userInvitees = explode(',', trim($_POST['user_invitees'], ','));
|
|
} else {
|
|
$userInvitees = array();
|
|
}
|
|
|
|
|
|
if (!empty($_POST['contact_invitees'])) {
|
|
$contactInvitees = explode(',', trim($_POST['contact_invitees'], ','));
|
|
} else {
|
|
$contactInvitees = array();
|
|
}
|
|
|
|
|
|
$deleteUsers = array();
|
|
$existingUsers = array();
|
|
|
|
$deleteContacts = array();
|
|
$existingContacts = array();
|
|
|
|
if (!empty($this->id)) {
|
|
|
|
//$focus->retrieve($this->id);
|
|
|
|
//// REMOVE RESOURCE RELATIONSHIPS
|
|
// Calculate which users to flag as deleted and which to add
|
|
|
|
// Get all users for the project
|
|
$focus->load_relationship('users');
|
|
$users = $focus->get_linked_beans('project_users_1', 'User');
|
|
foreach ($users as $a) {
|
|
if (!in_array($a->id, $userInvitees)) {
|
|
$deleteUsers[$a->id] = $a->id;
|
|
} else {
|
|
$existingUsers[$a->id] = $a->id;
|
|
}
|
|
}
|
|
|
|
if (count($deleteUsers) > 0) {
|
|
$sql = '';
|
|
foreach ($deleteUsers as $u) {
|
|
$sql .= ",'" . $u . "'";
|
|
}
|
|
$sql = substr($sql, 1);
|
|
// We could run a delete SQL statement here, but will just mark as deleted instead
|
|
$sql = "UPDATE project_users_1_c set deleted = 1 where project_users_1users_idb in ($sql) AND project_users_1project_ida = '". $focus->id . "'";
|
|
$focus->db->query($sql);
|
|
echo $sql;
|
|
}
|
|
|
|
// Get all contacts for the project
|
|
$focus->load_relationship('contacts');
|
|
$contacts = $focus->get_linked_beans('project_contacts_1', 'Contact');
|
|
foreach ($contacts as $a) {
|
|
if (!in_array($a->id, $contactInvitees)) {
|
|
$deleteContacts[$a->id] = $a->id;
|
|
} else {
|
|
$existingContacts[$a->id] = $a->id;
|
|
}
|
|
}
|
|
|
|
if (count($deleteContacts) > 0) {
|
|
$sql = '';
|
|
foreach ($deleteContacts as $u) {
|
|
$sql .= ",'" . $u . "'";
|
|
}
|
|
$sql = substr($sql, 1);
|
|
// We could run a delete SQL statement here, but will just mark as deleted instead
|
|
$sql = "UPDATE project_contacts_1_c set deleted = 1 where project_contacts_1contacts_idb in ($sql) AND project_contacts_1project_ida = '". $focus->id . "'";
|
|
$focus->db->query($sql);
|
|
echo $sql;
|
|
}
|
|
|
|
////END REMOVE
|
|
}
|
|
|
|
$return_id = parent::save($check_notify);
|
|
$focus->retrieve($return_id);
|
|
|
|
////REBUILD INVITEE RELATIONSHIPS
|
|
|
|
// Process users
|
|
$focus->load_relationship('users');
|
|
$focus->get_linked_beans('project_users_1', 'User');
|
|
foreach ($userInvitees as $user_id) {
|
|
if (empty($user_id) || isset($existingUsers[$user_id]) || isset($deleteUsers[$user_id])) {
|
|
continue;
|
|
}
|
|
$focus->project_users_1->add($user_id);
|
|
}
|
|
|
|
// Process contacts
|
|
$focus->load_relationship('contacts');
|
|
$focus->get_linked_beans('project_contacts_1', 'Contact');
|
|
foreach ($contactInvitees as $contact_id) {
|
|
if (empty($contact_id) || isset($existingContacts[$contact_id]) || isset($deleteContacts[$contact_id])) {
|
|
continue;
|
|
}
|
|
$focus->project_contacts_1->add($contact_id);
|
|
}
|
|
|
|
//// END REBUILD INVITEE RELATIONSHIPS
|
|
///////////////////////////////////////////////////////////////////////////
|
|
}
|
|
|
|
|
|
|
|
///////////////////////////////
|
|
// Code Block to handle the template selection at project edit.
|
|
////////////////////////////////////////
|
|
|
|
if ($current_template_id != $new_template_id) {
|
|
$project_start = $focus->estimated_start_date;
|
|
//Get project start date
|
|
if ($project_start!='') {
|
|
$dateformat = $current_user->getPreference('datef');
|
|
$startdate = DateTime::createFromFormat($dateformat, $project_start);
|
|
if ($startdate == false) {
|
|
$startdate = DateTime::createFromFormat('Y-m-d', $project_start);
|
|
}
|
|
|
|
$start = $startdate->format('Y-m-d');
|
|
}
|
|
|
|
$duration_unit = 'Days';
|
|
|
|
//Get the project template
|
|
$template = BeanFactory::newBean('AM_ProjectTemplates');
|
|
$template->retrieve($new_template_id);
|
|
|
|
$override_business_hours = (int)$template->override_business_hours;
|
|
|
|
|
|
//------ build business hours array
|
|
|
|
$dateformat = $current_user->getPreference('datef');
|
|
|
|
$days = array("Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Sunday");
|
|
$businessHours = BeanFactory::getBean("AOBH_BusinessHours");
|
|
$bhours = array();
|
|
foreach ($days as $day) {
|
|
$bh = $businessHours->getBusinessHoursForDay($day);
|
|
|
|
if ($bh) {
|
|
$bh = $bh[0];
|
|
if ($bh->open) {
|
|
$open_h = $bh ? $bh->opening_hours : 9;
|
|
$close_h = $bh ? $bh->closing_hours : 17;
|
|
|
|
$start_time = DateTime::createFromFormat('Y-m-d', $start);
|
|
|
|
$start_time = $start_time->modify('+'.$open_h.' Hours');
|
|
|
|
$end_time = DateTime::createFromFormat('Y-m-d', $start);
|
|
$end_time = $end_time->modify('+'.$close_h.' Hours');
|
|
|
|
$hours = ($end_time->getTimestamp() - $start_time->getTimestamp())/(60*60);
|
|
if ($hours < 0) {
|
|
$hours = 0 - $hours ;
|
|
}
|
|
|
|
$bhours[$day] = $hours;
|
|
} else {
|
|
$bhours[$day] = 0;
|
|
}
|
|
}
|
|
}
|
|
//-----------------------------------
|
|
|
|
|
|
//default business hours array
|
|
if ($override_business_hours != 1 || empty($bhours)) {
|
|
$bhours = array('Monday' => 8,'Tuesday' => 8,'Wednesday' => 8, 'Thursday' => 8, 'Friday' => 8, 'Saturday' => 0, 'Sunday' => 0);
|
|
}
|
|
//---------------------------
|
|
|
|
//copy all resources from template to project
|
|
$template->load_relationship('am_projecttemplates_users_1');
|
|
$template_users = $template->get_linked_beans('am_projecttemplates_users_1', 'User');
|
|
|
|
$template->load_relationship('am_projecttemplates_contacts_1');
|
|
$template_contacts = $template->get_linked_beans('am_projecttemplates_contacts_1', 'Contact');
|
|
|
|
|
|
foreach ($template_users as $user) {
|
|
$focus->project_users_1->add($user->id);
|
|
}
|
|
|
|
foreach ($template_contacts as $contact) {
|
|
$focus->project_contacts_1->add($contact->id);
|
|
}
|
|
|
|
|
|
//Get related project template tasks. Using sql query so that the results can be ordered.
|
|
$get_tasks_sql = "SELECT * FROM am_tasktemplates
|
|
WHERE id
|
|
IN (
|
|
SELECT am_tasktemplates_am_projecttemplatesam_tasktemplates_idb
|
|
FROM am_tasktemplates_am_projecttemplates_c
|
|
WHERE am_tasktemplates_am_projecttemplatesam_projecttemplates_ida = '".$new_template_id."'
|
|
AND deleted =0
|
|
)
|
|
AND deleted =0
|
|
ORDER BY am_tasktemplates.order_number ASC";
|
|
$tasks = $db->query($get_tasks_sql);
|
|
|
|
//Create new project tasks from the template tasks
|
|
$count=1;
|
|
while ($row = $db->fetchByAssoc($tasks)) {
|
|
$project_task = BeanFactory::newBean('ProjectTask');
|
|
$project_task->name = $row['name'];
|
|
$project_task->status = $row['status'];
|
|
$project_task->priority = strtolower($row['priority']);
|
|
$project_task->percent_complete = $row['percent_complete'];
|
|
$project_task->predecessors = $row['predecessors'];
|
|
$project_task->milestone_flag = $row['milestone_flag'];
|
|
$project_task->relationship_type = $row['relationship_type'];
|
|
$project_task->task_number = $row['task_number'];
|
|
$project_task->order_number = $row['order_number'];
|
|
$project_task->estimated_effort = $row['estimated_effort'];
|
|
$project_task->utilization = $row['utilization'];
|
|
$project_task->assigned_user_id = $row['assigned_user_id'];
|
|
$project_task->description = $row['description'];
|
|
$project_task->duration = $row['duration'];
|
|
$project_task->duration_unit = $duration_unit;
|
|
$project_task->project_task_id = $count;
|
|
|
|
//Flag to prevent after save logichook running when project_tasks are created (see custom/modules/ProjectTask/updateProject.php)
|
|
$project_task->set_project_end_date = 0;
|
|
|
|
//
|
|
//code block to calculate end date based on user's business hours
|
|
//
|
|
|
|
$duration = $project_task->duration;
|
|
$enddate = $startdate;
|
|
|
|
$d = 0;
|
|
|
|
while ($duration > $d) {
|
|
$day = $enddate->format('l');
|
|
|
|
if ($bhours[$day] != 0) {
|
|
$d += 1;
|
|
}
|
|
|
|
$enddate = $enddate->modify('+1 Days');
|
|
}
|
|
$enddate = $enddate->modify('-1 Days');//readjust it back to remove 1 additional day added
|
|
|
|
|
|
//----------------------------------
|
|
|
|
|
|
if ($count == '1') {
|
|
$project_task->date_start = $start;
|
|
$end = $enddate->format('Y-m-d');
|
|
$project_task->date_finish = $end;
|
|
|
|
//add one day to let the next task start on next day of it's finish.
|
|
$enddate_array[$count] = $enddate->modify('+1 Days')->format('Y-m-d');
|
|
} else {
|
|
$start_date = $count - 1;
|
|
$startdate = DateTime::createFromFormat('Y-m-d', $enddate_array[$start_date]);
|
|
$start = $startdate->format('Y-m-d');
|
|
$project_task->date_start = $start;
|
|
$end = $enddate->format('Y-m-d');
|
|
$project_task->date_finish = $end;
|
|
|
|
$startdate = $enddate;
|
|
//add one day to let the next task start on next day of it's finish.
|
|
$enddate_array[$count] = $enddate->modify('+1 Days')->format('Y-m-d');
|
|
|
|
$enddate = $end;
|
|
}
|
|
|
|
$project_task->save();
|
|
|
|
//link tasks to the newly created project
|
|
$project_task->load_relationship('projects');
|
|
$project_task->projects->add($focus->id);
|
|
|
|
//Add assinged users from each task to the project resourses subpanel
|
|
$focus->load_relationship('project_users_1');
|
|
$focus->project_users_1->add($row['assigned_user_id']);
|
|
$count++;
|
|
}
|
|
}
|
|
/// End Template Selection handling
|
|
////////////////////////////////////////////////////////////
|
|
return $return_id;
|
|
}
|
|
}
|