salesagility_SuiteCRM/modules/AM_ProjectTemplates/project_table.php

<?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 Gantt chart
 * @copyright Andrew Mclaughlan 2014
 * @author Andrew Mclaughlan <andrew@mclaughlan.info>
 */

#[\AllowDynamicProperties]
class AM_ProjectTemplatesTable
{
    private $tasks;
    private $project_template_id;
    public function __construct($project_template_id, $tasks)
    {
        $this->tasks = $tasks;
        $this->project_template_id = $project_template_id;
        //draw the grid
        $this->draw($this->project_template_id, $this->tasks);
    }

    public function draw($project_template_id, $tasks)
    {
        global $mod_strings, $app_list_strings;

        // Instantiate the TimeDate Class
        $timeDate = new TimeDate();

        echo '<table id="Task_table" class="project_table_header">
                <tr class="disable_sort">
                    <td style="min-width:32px;" class="project_table_headings">'.$mod_strings['LBL_TASK_ID'].'</td>
                    <td style="min-width:85px;" class="project_table_headings">'.$mod_strings['LBL_TASK_NAME'].'</td>
                    <td style="min-width:100px;" class="project_table_headings">'.$mod_strings['LBL_PREDECESSORS'].'</td>
                    <!-- td style="min-width:100px;" class="project_table_headings">'.$mod_strings['LBL_START'].'</td>
                    <td style="min-width:100px;" class="project_table_headings">'.$mod_strings['LBL_FINISH'].'</td -->
                    <td style="min-width:100px;" class="project_table_headings">'.$mod_strings['LBL_DURATION'].'</td>
                    <td style="min-width:120px;" class="project_table_headings">'.$mod_strings['LBL_ASSIGNED_USER_ID'].'</td>
                    <td style="min-width:48px;" class="project_table_headings">'.$mod_strings['LBL_PERCENT_COMPLETE'].'</td>
                    <td style="min-width:80px;" class="project_table_headings">'.$mod_strings['LBL_MILESTONE_FLAG'].'</td>
                    <td style="min-width:30px;" class="project_table_headings"></td>
                </tr>
        ';

        $task_count = 0;


        //Get resources
        $project_template = BeanFactory::newBean('AM_ProjectTemplates');
        $project_template->retrieve($project_template_id);
        //Get project resources (users & contacts)
        $resources1 = $project_template->get_linked_beans('am_projecttemplates_users_1', 'User');
        $resources2 = $project_template->get_linked_beans('am_projecttemplates_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;
        }

        if (!is_null($tasks)) {
            foreach ($tasks as $task) {
                $task->duration_unit = "Days";
                $task->date_start =  Date('Y-m-d');
                $task->date_finish = Date('Y-m-d', strtotime("+" . ($task->duration - 1) . " days"));

                echo '<tr class="row_sortable">
                        <td class="project_table_cells"><input class="order_number" name="order_number[]" rel="'.$task->id.'" type="hidden" value="'.$task->order_number.'" />'.$task->task_number.'</td>';

                if (ACLController::checkAccess('AM_ProjectTemplates', 'edit', true)) {
                    echo '<td class="project_table_cells" ><span class="Task_name" ><a data = "'.$task->id.','.$task->predecessors.','.$task->relationship_type.','.$timeDate->to_display_date($task->date_start, true).','.$task->duration.','.$task->duration_unit.','.$task->assigned_user_id.','.$task->milestone_flag.','.$task->percent_complete.','.$task->description.'" onclick = "edit_task($(this));"title = "'.$mod_strings['LBL_TASK_TITLE'].'" href = "#" >'.$task->name.'</a ></span ></td>';
                } else {
                    echo '<td class="project_table_cells" ><span class="Task_name" >'.$task->name.'</span ></td>';
                }

                echo '<td class="project_table_cells">';

                foreach ($tasks as $predecessor) {
                    if ($predecessor->task_number==$task->predecessors) {
                        echo $predecessor->name;
                    }
                }
                echo '
                        </td>
                        <!-- td class="project_table_cells">'
                            .$timeDate->to_display_date($task->date_start, true).
                        '</td>
                        <td class="project_table_cells">'
                            .$timeDate->to_display_date($task->date_finish, true).
                        '</td -->
                        <td class="project_table_cells">'
                            .$task->duration.' '.$app_list_strings['duration_unit_dom'][$task->duration_unit].
                        '</td>
                        <td style="min-width:105px;" class="project_table_cells" >';
                $rflag = '0';
                foreach ($resource_array as $resource) {
                    if ($resource->id == $task->assigned_user_id) {
                        if ($resource->type == 'user') {
                            echo '<a target="blank" href="index.php?module=Users&action=DetailView&record='.$resource->id.'">'.$resource->name.'</a>';
                            $rflag = '1';
                        } elseif ($resource->type == 'contact') {
                            echo '<a target="blank" href="index.php?module=Contacts&action=DetailView&record='.$resource->id.'">'.$resource->name.'</a>';
                            $rflag = '1';
                        }
                    }
                }

                if ($rflag == '0') {
                    echo $mod_strings['LBL_UNASSIGNED'];
                }

                if ($task->milestone_flag == '1') {
                    $checked = $app_list_strings['checkbox_dom']['1'];
                } else {
                    $checked = $app_list_strings['checkbox_dom']['2'];
                }
                echo '</td>
                        <td class="project_table_cells">'.$task->percent_complete.'</td>
                        <td class="project_table_cells">'.$checked.'</td>
                        <td class="project_table_cells">
                            <span id="exportToPDFSpan">';

                if (ACLController::checkAccess('AM_ProjectTemplates', 'delete', true)) {
                    echo '<button style = "height:20px;width:20px;" class="remove_button" value = "'.$task->id.'" class="gantt_button" > Delete Task </button >';
                } else {
                    echo '<button disabled="disabled" style = "height:20px;width:20px;" class="remove_button" value = "'.$task->id.'" class="gantt_button" > Delete Task </button >';
                }
                echo '</span>
                         </td>
                    </tr>';

                $task_count++;
            }
        }

        echo '</table>';
    }

    // Function for basic field validation (present and neither empty nor only white space
    public function IsNullOrEmptyString($question)
    {
        return (!isset($question) || trim($question)==='');
    }
}