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 previous 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

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


Current Time: Thu Nov 28 11:22:43 EST 2024

Total time taken to generate the page: 0.01001 seconds