519 lines
20 KiB
PHP
Executable File
519 lines
20 KiB
PHP
Executable File
<?php
|
|
/**
|
|
* This program is free software; you can redistribute it and/or modify
|
|
* it under the terms of the GNU AFFERO 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 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
|
|
* @Package Project templates
|
|
* @copyright Andrew Mclaughlan 2014
|
|
* @author Andrew Mclaughlan <andrew@mclaughlan.info>
|
|
*/
|
|
|
|
if (!defined('sugarEntry') || !sugarEntry) {
|
|
die('Not A Valid Entry Point');
|
|
}
|
|
|
|
#[\AllowDynamicProperties]
|
|
class AM_ProjectTemplatesController extends SugarController
|
|
{
|
|
|
|
//Loads the gantt view
|
|
public function action_view_GanttChart()
|
|
{
|
|
$this->view = 'GanttChart';
|
|
}
|
|
|
|
|
|
public function action_create_project()
|
|
{
|
|
global $current_user, $db, $mod_strings;
|
|
|
|
$project_name = $_POST['p_name'];
|
|
$template_id = $_POST['template_id'];
|
|
$project_start = $_POST['start_date'];
|
|
$copy_all = isset($_POST['copy_all_tasks']) ? 1 : 0;
|
|
$copy_tasks = isset($_POST['tasks']) ? $_POST['tasks'] : array() ;
|
|
|
|
|
|
|
|
//Get project start date
|
|
if ($project_start!='') {
|
|
$dateformat = $current_user->getPreference('datef');
|
|
$startdate = DateTime::createFromFormat($dateformat, $project_start);
|
|
$start = $startdate->format('Y-m-d');
|
|
}
|
|
|
|
$duration_unit = 'Days';
|
|
|
|
|
|
//Get the project template
|
|
$template = BeanFactory::newBean('AM_ProjectTemplates');
|
|
$template->retrieve($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);
|
|
}
|
|
//---------------------------
|
|
|
|
|
|
|
|
|
|
//create project from template
|
|
$project = BeanFactory::newBean('Project');
|
|
$project->name = $project_name;
|
|
$project->estimated_start_date = $start;
|
|
$project->status = $template->status;
|
|
$project->priority = strtolower($template->priority);
|
|
$project->description = $template->description;
|
|
$project->assigned_user_id = $template->assigned_user_id;
|
|
$project->save();
|
|
|
|
|
|
//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');
|
|
|
|
$project->load_relationship('project_users_1');
|
|
foreach ($template_users as $user) {
|
|
$project->project_users_1->add($user->id);
|
|
}
|
|
|
|
$project->load_relationship('project_contacts_1');
|
|
foreach ($template_contacts as $contact) {
|
|
$project->project_contacts_1->add($contact->id);
|
|
}
|
|
|
|
|
|
$template->load_relationship('am_projecttemplates_project_1');
|
|
$template->am_projecttemplates_project_1->add($project->id);
|
|
|
|
//Get related project template tasks. Using sql query so that the results can be ordered.
|
|
$get_tasks = "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 = '".$template_id."'
|
|
AND deleted =0
|
|
)
|
|
AND deleted =0
|
|
ORDER BY am_tasktemplates.order_number ASC";
|
|
$tasks = $db->query($get_tasks);
|
|
//Create new project tasks from the template tasks
|
|
$enddate_array = [];
|
|
$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'];
|
|
|
|
if ($copy_all == 0 && !in_array($row['id'], $copy_tasks)) {
|
|
$project_task->assigned_user_id = null;
|
|
} else {
|
|
$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'); //$end;
|
|
$enddate = $end;
|
|
}
|
|
$project_task->save();
|
|
//link tasks to the newly created project
|
|
$project_task->load_relationship('projects');
|
|
$project_task->projects->add($project->id);
|
|
//Add assinged users from each task to the project resourses subpanel
|
|
$project->load_relationship('project_users_1');
|
|
$project->project_users_1->add($row['assigned_user_id']);
|
|
$count++;
|
|
}
|
|
|
|
//set project end date to the same as end date of the last task
|
|
$project->estimated_end_date = $end ?? '';
|
|
$project->save();
|
|
|
|
|
|
//redirct to new project
|
|
SugarApplication::appendErrorMessage($mod_strings["LBL_NEW_PROJECT_CREATED"]);
|
|
$params = array(
|
|
'module'=> 'Project',
|
|
'action'=>'DetailView',
|
|
'record' => $project->id,
|
|
);
|
|
SugarApplication::redirect('index.php?' . http_build_query($params));
|
|
}
|
|
|
|
|
|
public function action_generate_chart()
|
|
{
|
|
$db = DBManagerFactory::getInstance();
|
|
|
|
include_once('modules/AM_ProjectTemplates/gantt.php');
|
|
include_once('modules/AM_ProjectTemplates/project_table.php');
|
|
|
|
$project_template = BeanFactory::newBean('AM_ProjectTemplates');
|
|
$pid = $_POST["pid"];
|
|
$project_template->retrieve($pid);
|
|
|
|
//Get project tasks
|
|
$project_template->load_relationship('am_tasktemplates_am_projecttemplates');
|
|
$tasks = $project_template->get_linked_beans('am_tasktemplates_am_projecttemplates', 'AM_TaskTemplates');
|
|
|
|
//--- get the gantt chart start and end
|
|
|
|
$start_date = Date('Y-m-d');
|
|
|
|
$query = "select max(duration) +1 from am_tasktemplates inner join am_tasktemplates_am_projecttemplates_c on am_tasktemplates_am_projecttemplatesam_tasktemplates_idb = am_tasktemplates.id and am_tasktemplates_am_projecttemplatesam_projecttemplates_ida = '{$pid}'";
|
|
|
|
$duration = $db->getOne($query);
|
|
|
|
if ($duration < 31) {
|
|
$end_date = Date('Y-m-d', strtotime("+30 days"));
|
|
} else {
|
|
$end_date = Date('Y-m-d', strtotime("+ " . $duration . " days"));
|
|
}
|
|
|
|
//-------------------------------------------?>
|
|
|
|
<script type="text/javascript">
|
|
//Get the height if the #gantt div and add 18px
|
|
var size = $('#gantt').height() +18;
|
|
//Call jquery splitter function
|
|
$('#project').splitter({
|
|
outline: true
|
|
});
|
|
//Set height of gantt wrapping divs to make sure it shows
|
|
$('#project').css('height', size+'px');
|
|
$('.splitter-bar').css('height', size+'px');
|
|
|
|
</script>
|
|
<div id="project">
|
|
<div id="left_pane">
|
|
<?php new AM_ProjectTemplatesTable($project_template->id, $tasks); ?>
|
|
</div>
|
|
<div id="right_pane">
|
|
<div id="gantt">
|
|
<?php new Gantt($start_date, $end_date, $tasks); ?>
|
|
</div>
|
|
<div id="arrow_divs" style=""></div>
|
|
</div>
|
|
</div>
|
|
|
|
<?php
|
|
die();
|
|
}
|
|
|
|
//Create new project task
|
|
public function action_update_GanttChart()
|
|
{
|
|
|
|
global $current_user, $db;
|
|
|
|
$task_name = $_POST['task_name'];
|
|
$project_id = $_POST['project_id'];
|
|
$override_business_hours = (int)$_POST['override_business_hours'];
|
|
$task_id = $_POST['task_id'] ?? '';
|
|
$predecessor = $_POST['predecessor'];
|
|
$rel_type = $_POST['rel_type'];
|
|
$resource = $_POST['resource'];
|
|
$percent = $_POST['percent'];
|
|
$note = $_POST['note'];
|
|
$milestone_flag = '';
|
|
|
|
//$actual_duration = $_POST['actual_duration'];
|
|
|
|
if ($_POST['milestone'] == 'Milestone') {
|
|
$milestone_flag = '1';
|
|
} else {
|
|
if ($_POST['milestone'] == 'Task') {
|
|
$milestone_flag = '0';
|
|
}
|
|
}
|
|
|
|
$project_template = BeanFactory::newBean('AM_ProjectTemplates');
|
|
$project_template->retrieve($project_id);
|
|
|
|
|
|
$dateformat = $current_user->getPreference('datef');
|
|
|
|
$startdate = DateTime::createFromFormat("d/m/Y", "01/01/2016");
|
|
$start = $startdate->format('Y-m-d');
|
|
|
|
//Take 1 off duration so that task displays in correct number of table cells in gantt chart.
|
|
$duration = $_POST['duration'] -1;
|
|
|
|
$duration_unit = $_POST['unit'];
|
|
$actual_duration = 0;
|
|
//Compensate for resulting negative number when a 0 duration is passed in above
|
|
if ($duration < 0) {
|
|
$duration = 0;
|
|
}
|
|
|
|
//
|
|
//code block to calculate end date based on user's business hours
|
|
//
|
|
$enddate = $startdate->modify('+'.$duration.' '.$duration_unit);
|
|
$enddate = $enddate->modify('-1 Days');//readjust it back to remove 1 additional day added
|
|
$enddate = $enddate->format('Y-m-d');
|
|
|
|
//---------------
|
|
|
|
if ($percent > 0) {
|
|
$status = 'In Progress';
|
|
} else {
|
|
$status = 'Not Started';
|
|
}
|
|
|
|
|
|
//count tasks
|
|
$project_template->load_relationship('am_tasktemplates_am_projecttemplates');
|
|
$tasks = $project_template->get_linked_beans('am_tasktemplates_am_projecttemplates', 'AM_TaskTemplates');
|
|
|
|
$tid = (is_countable($tasks) ? count($tasks) : 0) + 1 ;
|
|
|
|
if ($this->IsNullOrEmptyString($task_id)) {
|
|
$this->create_task($task_name, $start, $enddate, $project_id, $milestone_flag, $status, $tid, $predecessor, $rel_type, $duration, $duration_unit, $resource, $percent, $note, $actual_duration, $tid);
|
|
} else {
|
|
$this->update_task($task_id, $task_name, $start, $enddate, $project_id, $milestone_flag, $status, $predecessor, $rel_type, $duration, $duration_unit, $resource, $percent, $note, $actual_duration);
|
|
}
|
|
}
|
|
|
|
|
|
//mark project task as deleted
|
|
public function action_delete_task()
|
|
{
|
|
$id = $_POST['task_id'];
|
|
$task = BeanFactory::newBean('AM_TaskTemplates');
|
|
$task->retrieve($id);
|
|
$task->deleted = '1';
|
|
$task->save();
|
|
}
|
|
|
|
//Returns new task start date including any lag via ajax call
|
|
public function action_get_end_date()
|
|
{
|
|
global $timeDate;
|
|
$db = DBManagerFactory::getInstance();
|
|
|
|
$timeDate = new TimeDate();
|
|
$id = $_POST['task_id'];
|
|
$lag = $_POST['lag'];
|
|
|
|
//Get the end date of the projectTask in raw database format
|
|
$query = "SELECT date_finish FROM project_task WHERE id = '{$id}'";
|
|
$end_date = $db->getOne($query);
|
|
//Add 1 day onto end date for first day of new task
|
|
$start_date = date('Y-m-d', strtotime($end_date. ' + 1 days'));
|
|
//Add lag onto start date
|
|
$start_date = date('Y-m-d', strtotime($start_date. ' + '.$lag.' days'));
|
|
|
|
echo $timeDate->to_display_date($start_date, true);
|
|
die();
|
|
}
|
|
|
|
|
|
//updates the order of the tasks
|
|
public function action_update_order()
|
|
{
|
|
|
|
//convert quotes in json string back to normal
|
|
$jArray = htmlspecialchars_decode((string) $_POST['orderArray']);
|
|
|
|
//create object/array from json data
|
|
$orderArray = json_decode($jArray);
|
|
|
|
foreach ($orderArray as $id => $order_number) {
|
|
$task = BeanFactory::newBean('AM_TaskTemplates');
|
|
$task->retrieve($id);
|
|
$task->order_number = $order_number;
|
|
$task->save();
|
|
}
|
|
}
|
|
//returns tasks for predecessor in the add task pop-up form
|
|
public function action_get_predecessors()
|
|
{
|
|
global $mod_strings;
|
|
$project_template = BeanFactory::newBean('AM_ProjectTemplates');
|
|
$project_template->retrieve($_REQUEST["project_id"]);
|
|
|
|
//Get tasks
|
|
$project_template->load_relationship('am_tasktemplates_am_projecttemplates');
|
|
$tasks = $project_template->get_linked_beans('am_tasktemplates_am_projecttemplates', 'AM_TaskTemplates');
|
|
echo '<option rel="0" value="0">'.$mod_strings["LBL_NONE"].'</option>';
|
|
foreach ($tasks as $task) {
|
|
echo '<option rel="'.$task->task_number.'" value="'.$task->task_number.'">'.$task->name.'</opion>';
|
|
}
|
|
die();
|
|
}
|
|
|
|
|
|
public function create_task($name, $start, $end, $project_id, $milestone_flag, $status, $project_task_id, $predecessors, $rel_type, $duration, $duration_unit, $resource, $percent_complete, $description, $actual_duration, $order_number)
|
|
{
|
|
$task = BeanFactory::newBean('AM_TaskTemplates');
|
|
$task->name = $name;
|
|
//$task->date_start = $start;
|
|
//$task->date_finish = $end;
|
|
//$task->project_id = $project_id;
|
|
$task->milestone_flag = $milestone_flag;
|
|
$task->status = $status;
|
|
$task->task_number = $project_task_id;
|
|
$task->predecessors = $predecessors;
|
|
$task->relationship_type = $rel_type;
|
|
$task->duration = $duration + 1; //+1 to make duration appear correct in project table
|
|
//$task->duration_unit = $duration_unit;
|
|
$task->assigned_user_id = $resource;
|
|
$task->percent_complete = $percent_complete;
|
|
$task->description = $description;
|
|
//$task->actual_duration = $actual_duration;
|
|
$task->order_number = $order_number;
|
|
$task_id = $task->save();
|
|
|
|
$project_template = BeanFactory::newBean('AM_ProjectTemplates');
|
|
$project_template->retrieve($project_id);
|
|
$project_template->load_relationship('am_tasktemplates_am_projecttemplates');
|
|
$project_template->get_linked_beans('am_tasktemplates_am_projecttemplates', 'AM_TaskTemplates');
|
|
$project_template->am_tasktemplates_am_projecttemplates->add($task_id);
|
|
}
|
|
|
|
public function update_task($id, $name, $start, $end, $project_id, $milestone_flag, $status, $predecessors, $rel_type, $duration, $duration_unit, $resource, $percent_complete, $description, $actual_duration)
|
|
{
|
|
$task = BeanFactory::newBean('AM_TaskTemplates');
|
|
|
|
$task->retrieve($id);
|
|
$task->name = $name;
|
|
//$task->date_start = $start;
|
|
//$task->date_finish = $end;
|
|
//$task->project_id = $project_id;
|
|
$task->milestone_flag = $milestone_flag;
|
|
$task->status = $status;
|
|
// $task->parent_task_id = $parent_task_id;
|
|
$task->predecessors = $predecessors;
|
|
$task->relationship_type = $rel_type;
|
|
$task->duration = $duration + 1; //+1 to make duration appear correct in project table
|
|
//$task->duration_unit = $duration_unit;
|
|
$task->assigned_user_id = $resource;
|
|
$task->percent_complete = $percent_complete;
|
|
//$task->actual_duration = $actual_duration;
|
|
$task->description = $description;
|
|
$task->save();
|
|
}
|
|
|
|
|
|
|
|
// Function for basic field validation (present and neither empty nor only white space
|
|
public function IsNullOrEmptyString($question)
|
|
{
|
|
return (!isset($question) || trim($question)==='');
|
|
}
|
|
}
|