Radicore Forum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » RADICORE development » Bug Reports » Localization of task_desc in workitem
Localization of task_desc in workitem [message #5926] Sun, 02 October 2016 13:38 Go to next message
kong is currently offline  kong
Messages: 90
Registered: December 2011
Member
Work-item hyperlinks on user's home pages show task descriptions without converting into user's language.

To fix this, in file wf_workitem.class.inc, function _cm_pre_getData, change this:
$this->sql_select = 'rdcaccount_id, user_id, role_id, wf_workitem.workflow_id, case_id, workitem_id, transition_id, wf_workitem.task_id, transition_trigger, workitem_status, enabled_date, cancelled_date, finished_date, deadline, context, workflow_name, task_desc';

$this->sql_from   = 'wf_workitem '
                  . 'LEFT JOIN wf_workflow ON (wf_workflow.workflow_id=wf_workitem.workflow_id) '
                  . 'LEFT JOIN '.$menuDB.'mnu_task ON (mnu_task.task_id=wf_workitem.task_id) ';

To this:
$this->sql_select = 'rdcaccount_id, user_id, role_id, wf_workitem.workflow_id, case_id, workitem_id, transition_id, wf_workitem.task_id, transition_trigger, workitem_status, enabled_date, cancelled_date, finished_date, deadline, context, workflow_name';
$this->sql_select .= ", COALESCE({$menuDB}mnu_task_alt.task_desc, {$menuDB}mnu_task.task_desc) AS task_desc";

$this->sql_from   = 'wf_workitem '
                  . 'LEFT JOIN wf_workflow ON (wf_workflow.workflow_id=wf_workitem.workflow_id) '
                  . 'LEFT JOIN '.$menuDB.'mnu_task ON (mnu_task.task_id=wf_workitem.task_id) '
                  . "LEFT JOIN {$menuDB}mnu_task_alt ON (mnu_task.task_id=mnu_task_alt.task_id AND mnu_task_alt.language_id='{$_SESSION['user_language']}')";

[Updated on: Sun, 02 October 2016 15:41]

Report message to a moderator

Re: Localization of task_desc in workitem [message #5928 is a reply to message #5926] Mon, 03 October 2016 05:45 Go to previous message
AJM is currently offline  AJM
Messages: 2347
Registered: April 2006
Location: Surrey, UK
Senior Member
Thanks for spotting that. I shall include your change in the next release.

Previous Topic: Not processing $javascript['foot'][]['code']
Next Topic: Application Crashes Due to Duplicated Concurrent INSERT Transactions
Goto Forum:
  


Current Time: Fri Mar 29 00:51:36 EDT 2024

Total time taken to generate the page: 0.01036 seconds