*/
if (!defined('sugarEntry') || !sugarEntry) {
die('Not A Valid Entry Point');
}
#[\AllowDynamicProperties]
class ProjectViewGanttChart extends ViewDetail
{
public function display()
{
global $mod_strings, $app_list_strings;
$db = DBManagerFactory::getInstance();
echo '';
echo '';
echo '';
echo '';
echo '';
echo '';
$project = BeanFactory::newBean('Project');
if (!isset($_REQUEST["project_id"]) || trim($_REQUEST["project_id"]) == "") {
$_REQUEST["project_id"] = $_REQUEST["record"];
}
$project->retrieve($_REQUEST["project_id"]);
//Get project resources (users & contacts)
$resources1 = $project->get_linked_beans('project_users_1', 'User');
$resources2 = $project->get_linked_beans('project_contacts_1', 'Contact');
//Combine resources into array of objects
$resource_array = array();
foreach ($resources1 as $user) {
$resource = new stdClass;
$resource->id = $user->id;
$resource->name = $user->name;
$resource->type = 'user';
$resource_array[] = $resource;
}
foreach ($resources2 as $contact) {
$resource = new stdClass;
$resource->id = $contact->id;
$resource->name = $contact->name;
$resource->type = 'contact';
$resource_array[] = $resource;
}
//Get the start and end date of the project in database format
$query = "SELECT estimated_start_date FROM project WHERE id = '{$project->id}'";
$start_date = $db->getOne($query);
$query = "SELECT estimated_end_date FROM project WHERE id = '{$project->id}'";
$end_date = $db->getOne($query);
parent::display(); ?>
Are you sure you want to delete this task?
';
echo '';
} ?>
" />
add(new DateInterval('P1D')); //Add 1 day to include the end date as a day
$interval = $datetime1->diff($datetime2);
return $interval->format('%m '.$mod_strings['LBL_MONTHS'].', %d '.$mod_strings['LBL_DAYS']);
}
}