Delete Project Tasks when A Project is delete in CE

[oozypal]

Hello,

Can you guys/gals help in doing the following:

1. Delete all Project Tasks when its Project is deleted
2. Show warning or some indication when the project task end date is past the project end date

[davidboris]

Hello,

You can use after_delete logic_hook to delete the related records.

[oozypal]

Hello,

I did the logic hook and it works; however, I am not sure how to start the deletion process.

Can you put on the right track.

Thank you

Logic Hook

 <?php
$hook_version = 1; 
$hook_array = Array(); 
$hook_array['after_save'] = Array(); 
$hook_array['after_save'][] = Array(1,     'ProjectAssignmentNotification', 
                                        'custom/modules/Project/email_notes.php',
                                        'userNotification', 
                                        'notifyAssignee'); 
 
 
$hook_array['after_delete'] = Array(); 
$hook_array['after_delete'][] = Array(1, 'ProjectAssignmentNotification', 
                                        'custom/modules/Project/delete_children.php',
                                        'deleteChildren', 
                                        'deleteChild'); 
 
 
?>  

Deletion File

 <?php
    class deleteChildren{
    
        function deleteChild(&$bean, $event, $arguments)
        {
            echo "delete ok";
            break;    
        }
    }
 
?>  

[davidboris]

Hello,

Write following code in function,

 $sugarbean = new ProjectTask();
        $query = "SELECT id FROM project_task WHERE project_id = '" . $bean->id . "' AND deleted = 0";
        $result = $sugarbean->db->query($query,true,"Error retrieving project tasks");
        while($row = $sugarbean->db->fetchByAssoc($result))
        {
            $sugarbean->mark_deleted($row['id']);
        } 
  

[oozypal]

Hello,

It did not work. The project get deleted and the project task are not.

There is no error.

The code does not go inside the while loop.

Any idea?

OOzy

[davidboris]

Hello,

Use before_delete logic hook instead.

[oozypal]

Bingo!! Worked like a charm!

Thank you

OOzy