Navigation buttons problem in customized Project Tasks form

[rpompeo68]

» Operating system type and version: CentOS 2.6.18-92.1.10.el5 #1 SMP
» Sugar version and edition[I]: 5.2.0a Community Edition
» Webserver type and version: Apache 2.2.3
» PHP version[I]: 5.1.6-20.el5_2.1
» MySQL server version: 5.0.45

Installed modules:
1) Connector for Google Calendar (1.0.7)
2) SuperTimesheet (2.2)
3) Team (0.98.12338)
4) Helpdesk (1233157583)

Team is deployed on these modules:
- Bugs
- Project
- Project Tasks
- Cases

I customized Project Tasks adding some fields using SugarCRM Studio. This is the table created by SugarCRM in MySQL:

CREATE TABLE `sugarcrm`.`project_task_cstm` (
`id_c` char(36) NOT NULL,
`activity_type_c` varchar(100) NOT NULL default 'Workorder',
`job_code_c` varchar(6) default NULL,
`estimated_cost_c` varchar(0) default '',
`currency_id` char(36) default NULL,
`team_id_c` char(36) default NULL,
`requesting_team_c` varchar(255) NOT NULL,
`team_id1_c` char(36) default NULL,
`owner_team_c` varchar(255) NOT NULL,
`team_id2_c` char(36) default NULL,
`collaborating_team_1_c` varchar(255) default NULL,
`team_id3_c` char(36) default NULL,
`collaborating_team_2_c` varchar(255) default NULL,
`team_id4_c` char(36) default NULL,
`team_id5_c` char(36) default NULL,
`collaborating_team_3_c` varchar(255) default NULL,
`on_schedule_c` tinyint(1) default '1',
`on_specs_c` tinyint(1) default '1',
`note_c` text,
PRIMARY KEY (`id_c`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8

I customized also the Projects Tasks forms edit, display and list.

When I use the admin user there aren't any problem. I can navigate the list of 106 records using NEXT and END buttons.

When I use a not administrative account, I can see only the first page of list but I can't navigate the list using NEXT and END buttons. I can select a single record to display and navigate the entire list displaying a single entry at time. Both Project and Project Tasks records have all Assigned Team=Everyone.

I tested the problem with the latest releases of Firefox and Explorer and it doesn't seam related to a javascript malfunction but to something related to administrative permissions.

Do I have to drop the cache of the Project Task form?
(delete *.tpl inside /var/www/html/sugarcrm/cache/modules/ProjectTask/)

[rpompeo68]

Submited as Bug Number: 27833

[rpompeo68]

In attachment my Project Tasks list

[rpompeo68]

These are the fields added in Project Tasks form from SugarCRM Studio

[rpompeo68]

Using Firebug the navigation buttons have the following html/javascript declaration:

<td align='right' nowrap='nowrap' id='listViewPaginationButtons' class='listViewPaginationTdS1' width='90%'>

<button type='button' title='Start' class='button' disabled>

<img src='themes/Sugar/images/start_off.gif' alt='Start' align='absmiddle' border='0' width='13' height='11'>

</button>

<button type='button' class='button' disabled title='Previous'>

<img src='themes/Sugar/images/previous_off.gif' alt='Previous' align='absmiddle' border='0' width='8' height='11'>

</button>

<span class='pageNumbers'>(1 - 20 of 106)</span>

<button type='button' title='Next' class='button' onclick='return sListView.save_checks(20, "ProjectTask2_PROJECTTASK_offset")' >

<img src='themes/Sugar/images/next.gif' alt='Next' align='absmiddle' border='0' width='8' height='11'>

</button>

<button type='button' title='End' class='button' onclick='return sListView.save_checks("end", "ProjectTask2_PROJECTTASK_offset")' >

<img src='themes/Sugar/images/end.gif' alt='End' align='absmiddle' border='0' width='13' height='11'>

</button>

</td>

[rpompeo68]

The function is loaded by Project Tasks through the js module sugar_grp1.js

<script src="include/javascript/sugar_grp1.js?c=...." type="text/javascript">

Editing ./include/javascript/sugar_grp1.js

sugarListView.prototype.save_checks=function(offset,moduleString)
{

checks=sugarListView.get_checks();

eval('document.MassUpdate.'+moduleString+'.value = offset');

if(typeof document.MassUpdate.massupdate!='undefined'){docum ent.MassUpdate.massupdate.value='false';}

document.MassUpdate.action.value=document.MassUpda te.return_action.value;
document.MassUpdate.return_module.value='';
document.MassUpdate.return_action.value='';
document.MassUpdate.submit();

return!checks;

}

[rpompeo68]

The problem is that Projet Tasks doesn't generate, for a not administrative account, this HTML code:

<form id="MassUpdate" onsubmit="return check_form('MassUpdate');" name="MassUpdate" method="post" action="index.php">

<input type="hidden" value="index" name="return_action"/>
<input type="hidden" value="ProjectTask" name="return_module"/>
<input type="hidden" value="true" name="massupdate"/>
<input type="hidden" value="false" name="delete"/>
<input type="hidden" value="false" name="merge"/>
<input type="hidden" value="...." name="current_query_by_page"/>
<input type="hidden" value="ProjectTask" name="module"/>
<input type="hidden" value="MassUpdate" name="action"/>
<input type="hidden" value="" name="lvso"/>
<input type="hidden" value="" name="ProjectTask2_PROJECTTASK_ORDER_BY"/>
<input type="hidden" value="0" name="select_entire_list"/>
<input type="hidden" value="0" name="ProjectTask2_PROJECTTASK_offset"/>

[rpompeo68]

This code is generated by the funcion in ./include/MassUpdate.php:

function getMassUpdateFormHeader($multi_select_popup = false)
{

global $sugar_version;
global $sugar_config;
global $current_user;

$query = base64_encode(serialize($_REQUEST));

$bean = loadBean($_REQUEST['module']);
$order_by_name = $bean->module_dir.'2_'.strtoupper($bean->object_name).'_ORDER_BY' ;
$lvso = isset($_REQUEST['lvso'])?$_REQUEST['lvso']:"";
$request_order_by_name = isset($_REQUEST[$order_by_name])?$_REQUEST[$order_by_name]:"";
if($multi_select_popup)
$tempString = '';
else
$tempString = "<form action='index.php' method='post' name='MassUpdate' id='MassUpdate' onsubmit=\"return check_form('MassUpdate');\">\n"
. "<input type='hidden' name='return_action' value='{$_REQUEST['action']}' />\n"
. "<input type='hidden' name='return_module' value='{$_REQUEST['module']}' />\n"
. "<input type='hidden' name='massupdate' value='true' />\n"
. "<input type='hidden' name='delete' value='false' />\n"
. "<input type='hidden' name='merge' value='false' />\n"
. "<input type='hidden' name='current_query_by_page' value='{$query}' />\n"
. "<input type='hidden' name='module' value='{$_REQUEST['module']}' />\n"
. "<input type='hidden' name='action' value='MassUpdate' />\n"
. "<input type='hidden' name='lvso' value='{$lvso}' />\n"
. "<input type='hidden' name='{$order_by_name}' value='{$request_order_by_name}' />\n";

[rpompeo68]

The function is called inside ./include/ListView/ListView.php

function processListView($seed, $xTemplateSection, $html_varName)
{

.....

require_once('include/MassUpdate.php');
$mass = new MassUpdate();
$add_acl_javascript = false;
if(!isset($_REQUEST['action'])) {
$this->shouldProcess=false;
} else {
$this->shouldProcess = is_subclass_of($seed, "SugarBean")
&& (($_REQUEST['action'] == 'index') || ('ListView' == substr($_REQUEST['action'],0,8)) /* cn: to include all ListViewXXX.php type views */)
&& ($_REQUEST['module'] == $seed->module_dir);
}

......

if($this->shouldProcess) {
echo $mass->getDisplayMassUpdateForm(true, $this->multi_select_popup);
echo $mass->getMassUpdateFormHeader($this->multi_select_popup);
$mass->setSugarBean($seed);

[rpompeo68]

Waiting a patch for my problem I changed in Admin > System Setting

Listview items per page: 1000
Subpanel items per page: 1000