method getTasksTracks documentation in bbn\Appui\Task
function($id_user)
{
($manager = $this->idRole('managers')) &&
($worker = $this->idRole('workers')) &&
($ongoing = $this->idState('ongoing'))
){
return $this->db->getRows("
SELECT bbn_tasks.*, bbn_notes_versions.title, bbn_notes_versions.content
FROM bbn_tasks
JOIN bbn_notes_versions
ON bbn_notes_versions.id_note = bbn_tasks.id_note
AND bbn_notes_versions.latest = 1
JOIN bbn_tasks_roles
ON bbn_tasks_roles.id_task = bbn_tasks.id
AND bbn_tasks_roles.id_user = ?
AND (
bbn_tasks_roles.role = ?
OR bbn_tasks_roles.role = ?
)
WHERE bbn_tasks.active = 1
AND bbn_tasks.state = ?
GROUP BY bbn_tasks.id",
hex2bin($id_user),
hex2bin($manager),
hex2bin($worker),
hex2bin($ongoing)
);
}
}
BBN is a suite of PHP and JS libraries and VueJS components - all open-source! bbn.io, build applications, the quick way
This website uses cookies to ensure you get the best experience on our website.
© 2011-2024
BBN Solutions
