Radicore Forum: Bug Reports » Localization of task

Home » RADICORE development » Bug Reports » Localization of task_desc in workitem

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Localization of task_desc in workitem [message #5926]

Sun, 02 October 2016 13:38

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