8 namespace Fossology\Lib\Dao;
20 function __construct(
DbManager $dbManager, Logger $logger)
23 $this->logger = $logger;
26 public function getAllJobStatus($uploadId, $userId, $groupId)
31 "SELECT jobqueue.jq_pk as jq_pk,
32 jobqueue.jq_end_bits as end_bits
35 ON jobqueue.jq_job_fk = job.job_pk
36 LEFT JOIN group_user_member gm
37 ON gm.user_fk = job_user_fk
38 WHERE job.job_upload_fk = $1
40 OR gm.group_fk = $3)");
42 $res = $this->
dbManager->execute($stmt, array($uploadId, $userId, $groupId));
43 while ($row = $this->
dbManager->fetchArray($res)) {
44 $result[$row[
'jq_pk']] = $row[
'end_bits'];
51 public function hasActionPermissionsOnJob($jobId, $userId, $groupId)
58 LEFT JOIN group_user_member gm
59 ON gm.user_fk = job_user_fk
62 OR gm.group_fk = $3)");
64 $res = $this->
dbManager->execute($stmt, array($jobId, $userId, $groupId));
65 while ($row = $this->
dbManager->fetchArray($res)) {
66 $result[$row[
'jq_pk']] = $row[
'end_bits'];
fo_dbManager * dbManager
fo_dbManager object