Using AJAX to Update Status in SubPanel SugarCRM

Question

I would like to use AJAX to update the status of entries in SubPanel SugarCRM. Below is an image of the project management modules I'm working on.

In the image, you can get a better idea of ​​what I would like to achieve. In the left column, I would like to add a new button that will allow the user to quickly mark the Project Task entry as complete. You can do this by changing the Status field on this entry to Complete.

I can figure out how to add a new button, but I'm not sure how to update the record status in this way. I can compute JavaScript to make an AJAX call and update the user interface, but I don't know where to get my AJAX POST, etc., to update the record.

Do I need to create a new controller so that I have a URL for publishing? I hope for a simple solution, but if not, maybe someone who is familiar with SugarCRM can point me in the right direction?

I would be grateful for any help in this matter to bring me closer to completion.

Answer 1

You can create your AJAX in a JS file in a user directory ...

custom / modules / project / javascript / ajax.js

function updateStatus(project_task_id) { if (project_task_id) { $.ajax({ url: 'index.php?to_pdf=true&module=Project&action=ChangeProjectTaskStatus&id=' + project_task_id, success: function() { // Reload subpanel showSubPanel('projects_project_tasks', null, true); } }); } 

Then create a new PHP file with the action corresponding to the file name ...

custom / modules / Project / ChangeProjectTaskStatus.php

 <?php if (!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point'); $project_task = BeanFactory::getBean('ProjectTask'); $project_task->retrieve($_GET['project_task_id']); // Update status logic goes here $project_task->save(); exit();