9 namespace Fossology\Lib\Dao;
22 require_once(dirname(dirname(__FILE__)) .
"/common-dir.php");
28 const REUSE_ENHANCED = 2;
30 const REUSE_CONF = 16;
31 const REUSE_COPYRIGHT = 128;
32 const UNIFIED_REPORT_HEADINGS = array(
33 "assessment" => array(
"Assessment Summary" =>
true),
34 "compliancetasks" => array(
"Required license compliance tasks" =>
true),
35 "acknowledgements" => array(
"Acknowledgements" =>
true),
36 "exportrestrictions" => array(
"Export Restrictions" =>
true),
37 "intellectualProperty" => array(
"Patent Relevant Statements" =>
true),
38 "notes" => array(
"Notes" =>
true),
39 "scanresults" => array(
"Results of License Scan" =>
true),
40 "mainlicenses" => array(
"Main Licenses" =>
true),
41 "redlicense" => array(
"Other OSS Licenses (red) - Do not Use Licenses" =>
true),
42 "yellowlicense" => array(
"Other OSS Licenses (yellow) - additional obligations to common rules (e.g. copyleft)" =>
true),
43 "whitelicense" => array(
"Other OSS Licenses (white) - only common rules" =>
true),
44 "overviewwithwithoutobligations" => array(
"Overview of All Licenses with or without Obligations" =>
true),
45 "copyrights" => array(
"Copyrights" =>
true),
46 "copyrightsuf" => array(
"Copyrights (User Findings)" =>
true),
47 "bulkfindings" => array(
"Bulk Findings" =>
true),
48 "licensenf" => array(
"Non-Functional Licenses" =>
true),
49 "irrelevantfiles" => array(
"Irrelevant Files" =>
true),
50 "dnufiles" => array(
"Do not use Files" =>
true),
51 "changelog" => array(
"Clearing Protocol Change Log" =>
true)
53 const CLIXML_REPORT_HEADINGS = array(
54 "mainlicensesclixml" => array(
"Main Licenses" =>
true),
55 "licensepath" => array(
"License File Path" =>
true),
56 "licensehash" => array(
"License File Hash" =>
true),
57 "copyrightsclixml" => array(
"Copyrights" =>
true),
58 "copyrightpath" => array(
"Copyright File Path" =>
true),
59 "copyrighthash" => array(
"Copyright File Hash" =>
true),
60 "exportrestrictionsclixml" => array(
"Export Restrictions(ECC)" =>
true),
61 "eccpath" => array(
"ECC File Path" =>
true),
62 "ecchash" => array(
"ECC File Hash" =>
true),
63 "intellectualPropertyclixml" => array(
"Identified Patent Relevant Analysis(IPRA)" =>
true),
64 "iprapath" => array(
"IPRA File Path" =>
true),
65 "iprahash" => array(
"IPRA File Hash" =>
true),
66 "allobligations" => array(
"All Obligations" =>
true),
67 "acknowledgementsclixml" => array(
"Acknowledgements" =>
true),
68 "irrelevantfilesclixml" => array(
"Irrelevant Files" =>
true),
69 "dnufilesclixml" => array(
"Do not use Files" =>
true),
70 "notesclixml" => array(
"Additional Notes" =>
true)
77 private $permissionDao;
82 $this->logger = $logger;
83 $this->permissionDao = $uploadPermissionDao;
92 public function getUploadEntry($uploadTreeId, $uploadTreeTableName =
"uploadtree")
94 $stmt = __METHOD__ .
".$uploadTreeTableName";
95 $uploadEntry = $this->
dbManager->getSingleRow(
"SELECT * FROM $uploadTreeTableName WHERE uploadtree_pk = $1",
96 array($uploadTreeId), $stmt);
98 $uploadEntry[
'tablename'] = $uploadTreeTableName;
112 $stmt = __METHOD__ .
".$uploadTreeTableName";
113 $uploadEntry = $this->
dbManager->getSingleRow(
"SELECT uploadtree_pk " .
114 "FROM $uploadTreeTableName " .
115 "WHERE upload_fk = $1 AND pfile_fk = $2",
116 array($uploadFk, $pfileFk), $stmt);
117 return intval($uploadEntry[
'uploadtree_pk']);
127 $row = $this->
dbManager->getSingleRow(
"SELECT * FROM upload WHERE upload_pk = $1",
128 array($uploadId), $stmt);
133 public function getActiveUploadsArray()
136 $queryResult = $this->
dbManager->getRows(
"SELECT * FROM upload where pfile_fk IS NOT NULL",
140 foreach ($queryResult as $row) {
154 $uploadEntryData = $this->
getUploadEntry($itemId, $uploadTreeTableName);
177 if ($uploadTreeTableName ===
null) {
181 $stmt = __METHOD__ .
".$uploadTreeTableName";
182 $parameters = array();
183 $uploadCondition = $this->handleUploadIdForTable($uploadTreeTableName, $uploadId, $parameters);
185 $uploadEntryData = $this->
dbManager->getSingleRow(
"SELECT * FROM $uploadTreeTableName
191 return $uploadEntryData ? $this->
createItemTreeBounds($uploadEntryData, $uploadTreeTableName) :
false;
202 $stmt = __METHOD__ .
".$uploadTreeTableName";
203 $parameters = array($itemTreeBounds->
getLeft(), $itemTreeBounds->
getRight());
204 $uploadCondition = $this->handleUploadIdForTable($uploadTreeTableName, $itemTreeBounds->
getUploadId(), $parameters);
206 $row = $this->
dbManager->getSingleRow(
"SELECT count(*) as count FROM $uploadTreeTableName
207 WHERE lft BETWEEN $1 AND $2
209 AND ((ufile_mode & (3<<28))=0)
212 return intval($row[
"count"]);
215 private function handleUploadIdForTable($uploadTreeTableName, $uploadId, &$parameters)
217 if ($uploadTreeTableName ===
"uploadtree" || $uploadTreeTableName ===
"uploadtree_a") {
218 $parameters[] = $uploadId;
219 return " AND upload_fk = $" . count($parameters) .
" ";
228 public function getStatusTypeMap()
232 $uploadStatus = $container->get(
'upload_status.types');
233 return $uploadStatus->getMap();
245 if ($this->isAccessible($uploadId, $groupId)) {
246 $row = $this->
dbManager->getSingleRow(
"SELECT status_fk " .
247 "FROM upload_clearing WHERE upload_fk=$1 AND group_fk=$2;",
248 array($uploadId, $groupId));
249 if (
false === $row) {
252 return $row[
'status_fk'];
254 throw new \Exception(
"permission denied");
268 if ($this->isAccessible($uploadId, $groupId)) {
269 $row = $this->
dbManager->getSingleRow(
"SELECT assignee FROM upload_clearing WHERE upload_fk=$1 AND group_fk=$2;",
270 array($uploadId, $groupId));
271 if (
false === $row) {
274 return $row[
'assignee'];
276 throw new \Exception(
"permission denied");
289 $sql =
"SELECT event_ts FROM upload_events WHERE upload_fk = $1 " .
291 $row = $this->
dbManager->getSingleRow($sql, [$uploadId], __METHOD__);
292 if (empty($row) || empty($row[
"event_ts"])) {
295 return $row[
"event_ts"];
306 $sql =
"SELECT event_ts FROM upload_events WHERE upload_fk = $1 " .
308 $row = $this->
dbManager->getSingleRow($sql, [$uploadId], __METHOD__);
309 if (empty($row) || empty($row[
"event_ts"])) {
312 return $row[
"event_ts"];
325 if (!empty($uploadId)) {
326 $statementName = __METHOD__;
328 "SELECT uploadtree_tablename FROM upload WHERE upload_pk=$1",
332 if (!empty($row[
'uploadtree_tablename'])) {
333 return $row[
'uploadtree_tablename'];
362 const NOT_FOUND =
null;
375 $originItem = $this->
getUploadEntry($itemId, $uploadTreeTableName);
376 $originLft = $originItem[
'lft'];
378 $options[UploadTreeProxy::OPT_ITEM_FILTER] =
" AND ut.ufile_mode & (3<<28) = 0";
379 $uploadTreeViewName =
'items2care';
381 if ($direction == self::DIR_FWD) {
382 $uploadTreeViewName .=
'fwd';
383 $options[UploadTreeProxy::OPT_ITEM_FILTER] .=
" AND lft>$1";
386 $uploadTreeViewName .=
'bwd';
387 $options[UploadTreeProxy::OPT_ITEM_FILTER] .=
" AND lft<$1";
391 $uploadTreeView =
new UploadTreeProxy($uploadId, $options, $uploadTreeTableName, $uploadTreeViewName);
392 $statementName = __METHOD__ .
".$uploadTreeViewName.";
393 $query = $uploadTreeView->getDbViewQuery().
" ORDER BY lft $order";
395 $newItemRow = $this->
dbManager->getSingleRow(
"$query LIMIT 1", array($originLft), $statementName);
397 return $this->
createItem($newItemRow, $uploadTreeTableName);
399 return self::NOT_FOUND;
411 $statementname = __METHOD__ . $uploadTreeTableName;
413 $parent = $this->
dbManager->getSingleRow(
414 "SELECT uploadtree_pk
415 FROM $uploadTreeTableName
416 WHERE upload_fk=$1 AND parent IS NULL", array($uploadId), $statementname);
417 if (
false === $parent) {
418 throw new \Exception(
"Missing upload tree parent for upload");
420 return $parent[
'uploadtree_pk'];
423 public function getLeftAndRight($uploadtreeID, $uploadTreeTableName =
"uploadtree")
425 $statementName = __METHOD__ . $uploadTreeTableName;
426 $leftRight = $this->
dbManager->getSingleRow(
427 "SELECT lft,rgt FROM $uploadTreeTableName WHERE uploadtree_pk = $1",
428 array($uploadtreeID), $statementName
431 return array($leftRight[
'lft'], $leftRight[
'rgt']);
441 $sql =
"SELECT count(*) FROM " . $uploadTreeView->
getDbViewName() .
" WHERE lft BETWEEN $1 AND $2";
442 $result = $this->
dbManager->getSingleRow($sql
443 , array($itemTreeBounds->
getLeft(), $itemTreeBounds->
getRight()), __METHOD__ . $uploadTreeView->
asCTE());
444 return $result[
'count'];
453 public function getContainedItems(
ItemTreeBounds $itemTreeBounds, $addCondition =
"", $addParameters = array())
457 $statementName = __METHOD__ .
".$uploadTreeTableName";
459 $view =
new UploadTreeViewProxy($itemTreeBounds, array(UploadTreeViewProxy::CONDITION_PLAIN_FILES));
461 $this->
dbManager->prepare($statementName,
462 $view->asCTE() .
" SELECT * FROM " . $view->getDbViewName() .
" ut ".
463 ($addCondition ?
" WHERE " . $addCondition :
''));
464 $res = $this->
dbManager->execute($statementName, $addParameters);
467 while ($row = $this->
dbManager->fetchArray($res)) {
468 $items[] = $this->
createItem($row, $uploadTreeTableName);
481 public function addReusedUpload($uploadId, $reusedUploadId, $groupId, $reusedGroupId, $reuseMode=0)
483 $this->
dbManager->insertTableRow(
'upload_reuse',
484 array(
'upload_fk'=>$uploadId,
'group_fk'=> $groupId,
'reused_upload_fk'=>$reusedUploadId,
'reused_group_fk'=>$reusedGroupId,
'reuse_mode'=>$reuseMode));
495 $statementName = __METHOD__;
497 $this->
dbManager->prepare($statementName,
498 "SELECT reused_upload_fk, reused_group_fk, reuse_mode FROM upload_reuse WHERE upload_fk = $1 AND group_fk=$2 ORDER BY date_added DESC");
499 $res = $this->
dbManager->execute($statementName, array($uploadId, $groupId));
500 $reusedPairs = $this->
dbManager->fetchAll($res);
510 protected function createItem($uploadEntry, $uploadTreeTableName)
513 intval($uploadEntry[
'uploadtree_pk']),
514 $uploadTreeTableName,
515 intval($uploadEntry[
'upload_fk']),
516 intval($uploadEntry[
'lft']), intval($uploadEntry[
'rgt']));
518 $parent = $uploadEntry[
'parent'];
520 $itemTreeBounds, $parent !==
null ? intval($parent) :
null, intval($uploadEntry[
'pfile_fk']), intval($uploadEntry[
'ufile_mode']), $uploadEntry[
'ufile_name']
532 if ($uploadEntryData ===
false) {
533 throw new Exception(
"did not find uploadTreeId in $uploadTreeTableName");
535 return new ItemTreeBounds(intval($uploadEntryData[
'uploadtree_pk']), $uploadTreeTableName, intval($uploadEntryData[
'upload_fk']), intval($uploadEntryData[
'lft']), intval($uploadEntryData[
'rgt']));
546 $sql =
"SELECT count(*) FROM ".$itemTreeBounds->getUploadTreeTableName().
" ut "
547 .
"WHERE ut.upload_fk=$1";
550 $stmt = __METHOD__.
'.parent';
551 $params[] = $itemTreeBounds->
getItemId();
552 $sql .=
" AND ut.ufile_mode & (1<<28) = 0 AND ut.realparent = $2";
554 $params[] = $itemTreeBounds->
getLeft();
555 $params[] = $itemTreeBounds->
getRight();
556 $sql .=
" AND ut.ufile_mode & (3<<28) = 0 AND (ut.lft BETWEEN $2 AND $3)";
559 $descendants = $this->
dbManager->getSingleRow($sql,$params);
560 return $descendants[
'count'];
564 public function isAccessible($uploadId, $groupId)
566 return $this->permissionDao->isAccessible($uploadId, $groupId);
569 public function isEditable($uploadId, $groupId)
571 return $this->permissionDao->isEditable($uploadId, $groupId);
574 public function makeAccessibleToGroup($uploadId, $groupId, $perm=
null)
576 $this->permissionDao->makeAccessibleToGroup($uploadId, $groupId, $perm);
579 public function makeAccessibleToAllGroupsOf($uploadId, $userId, $perm=
null)
581 $this->permissionDao->makeAccessibleToAllGroupsOf($uploadId, $userId, $perm);
590 $pfile = $this->
dbManager->getSingleRow(
'SELECT pfile.* FROM upload, pfile WHERE upload_pk=$1 AND pfile_fk=pfile_pk',
591 array($uploadId), __METHOD__);
592 return array(
'sha1'=>$pfile[
'pfile_sha1'],
'md5'=>$pfile[
'pfile_md5'],
'sha256'=>$pfile[
'pfile_sha256']);
603 $sqlChildrenOf =
"SELECT COUNT(*) FROM $uploadtreeTablename s
604 WHERE ufile_mode&(1<<28)=0 and s.upload_fk=$2 AND s.realparent=";
605 $sql=
"WITH RECURSIVE item_path (item_id,num_children,depth,ufile_mode,ufile_name) AS (
606 SELECT uploadtree_pk item_id, ($sqlChildrenOf $1) num_children, 0 depth, ufile_mode, ufile_name
607 FROM $uploadtreeTablename WHERE upload_fk=$2 AND uploadtree_pk=$1
609 SELECT uploadtree_pk item_id, ($sqlChildrenOf ut.uploadtree_pk) num_children,
610 item_path.depth+1 depth, ut.ufile_mode, item_path.ufile_name||'/'||ut.ufile_name ufile_name
611 FROM $uploadtreeTablename ut INNER JOIN item_path ON item_id=ut.realparent
612 WHERE upload_fk=$2 AND ut.ufile_mode&(1<<28)=0 AND num_children<2
614 SELECT * FROM item_path WHERE num_children!=1 OR ufile_mode&(1<<29)=0 ORDER BY depth DESC LIMIT 1";
615 return $this->
dbManager->getSingleRow($sql,array($itemId, $uploadId),__METHOD__.$uploadtreeTablename);
626 $itemRow = $this->
getFatItemArray($itemId,$uploadId,$uploadtreeTablename);
627 return $itemRow[
'item_id'];
637 $statementName = __METHOD__ .
'.' . $uploadTreeTableName;
640 $param[] = $itemTreeBounds->
getLeft();
641 $param[] = $itemTreeBounds->
getRight();
642 $condition =
" lft BETWEEN $1 AND $2";
643 $condition .=
" AND (ufile_mode & (1<<28)) = 0";
645 if (
'uploadtree_a' == $uploadTreeTableName) {
647 $condition .=
" AND upload_fk=$".count($param);
651 SELECT ufile_name, uploadtree_pk, lft, rgt, ufile_mode,
652 pfile_pk, pfile_md5, pfile_sha1, pfile_sha256
653 FROM $uploadTreeTableName
655 ON pfile_fk = pfile_pk
660 $this->
dbManager->prepare($statementName, $sql);
661 $result = $this->
dbManager->execute($statementName, $param);
662 $pfilePerFileName = array();
664 $row = $this->
dbManager->fetchArray($result);
665 $pathStack = array($row[
'ufile_name']);
666 $rgtStack = array($row[
'rgt']);
667 $lastLft = $row[
'lft'];
668 $this->addToPFilePerFileName($pfilePerFileName, $pathStack, $row);
669 while ($row = $this->
dbManager->fetchArray($result)) {
670 if ($row[
'lft'] < $lastLft) {
674 $this->updateStackState($pathStack, $rgtStack, $lastLft, $row);
675 $this->addToPFilePerFileName($pfilePerFileName, $pathStack, $row);
678 return $pfilePerFileName;
681 private function updateStackState(&$pathStack, &$rgtStack, &$lastLft, $row)
683 if ($row[
'lft'] >= $lastLft) {
684 while (count($rgtStack) > 0 && $row[
'lft'] > $rgtStack[count($rgtStack)-1]) {
685 array_pop($pathStack);
686 array_pop($rgtStack);
688 if ($row[
'lft'] > $lastLft) {
689 $pathStack[] = $row[
'ufile_name'];
690 $rgtStack[] = $row[
'rgt'];
691 $lastLft = $row[
'lft'];
696 private function addToPFilePerFileName(&$pfilePerFileName, $pathStack, $row)
698 if (($row[
'ufile_mode'] & (1 << 29)) == 0) {
699 $path = implode(
'/', $pathStack);
700 $pfilePerFileName[$path][
'pfile_pk'] = $row[
'pfile_pk'];
701 $pfilePerFileName[$path][
'uploadtree_pk'] = $row[
'uploadtree_pk'];
702 $pfilePerFileName[$path][
'md5'] = $row[
'pfile_md5'];
703 $pfilePerFileName[$path][
'sha1'] = $row[
'pfile_sha1'];
704 $pfilePerFileName[$path][
'sha256'] = $row[
'pfile_sha256'];
716 $statementName = __METHOD__ .
'.' . $uploadTreeTableName;
719 $param[] = $itemTreeBounds->
getLeft();
720 $param[] = $itemTreeBounds->
getRight();
721 $condition =
" lft BETWEEN $1 AND $2";
722 $condition .=
" AND (ufile_mode & (1<<28)) = 0";
724 if (
'uploadtree_a' == $uploadTreeTableName) {
726 $condition .=
" AND upload_fk=$".count($param);
728 $condition .=
" AND pfile_$hashAlgo IS NOT NULL";
731 SELECT pfile_fk, uploadtree_pk, ufile_mode, pfile_$hashAlgo as hash
732 FROM $uploadTreeTableName
734 ON pfile_fk = pfile_pk
739 $this->
dbManager->prepare($statementName, $sql);
740 $result = $this->
dbManager->execute($statementName, $param);
742 $pfilePerHashAlgo = array();
743 while ($row = $this->
dbManager->fetchArray($result)) {
744 if (($row[
'ufile_mode']&(1<<29)) == 0) {
745 $pfilePerHashAlgo[strtolower($row[
'hash'])][] = array(
'pfile_pk' => $row[
'pfile_fk'],
746 'uploadtree_pk' => $row[
'uploadtree_pk']);
750 return $pfilePerHashAlgo;
757 public function getReportInfo($uploadId)
760 $sql =
"SELECT * FROM report_info WHERE upload_fk = $1";
761 $row = $this->
dbManager->getSingleRow($sql, array($uploadId), $stmt);
765 $stmt = __METHOD__.
'ifempty';
766 $sql =
"INSERT INTO report_info (upload_fk) VALUES ($1) RETURNING *";
767 $row = $this->
dbManager->getSingleRow($sql, array($uploadId), $stmt);
782 if ($column ===
"ri_unifiedcolumns") {
783 $value = json_decode($value,
true);
784 $oldValues = $this->getReportInfo($uploadId)[
"ri_unifiedcolumns"];
785 if (!empty($oldValues)) {
786 $oldValues = json_decode($oldValues,
true);
788 $oldValues = self::UNIFIED_REPORT_HEADINGS;
790 foreach ($value as $key => $val) {
791 $newValText = array_keys($val)[0];
792 $newValValue = array_values($val)[0];
793 $newValValue = ($newValValue ===
true || $newValValue ==
"true") ?
"on" :
null;
794 $oldValues[$key] = [$newValText => $newValValue];
796 $value = json_encode($oldValues);
797 } elseif ($column ===
"ri_excluded_obligations") {
798 $value = json_decode($value,
true);
799 $oldValues = $this->getReportInfo($uploadId)[
"ri_excluded_obligations"];
800 if (!empty($oldValues)) {
801 $oldValues = json_decode($oldValues,
true);
805 foreach ($value as $key => $newValue) {
806 $oldValues[$key] = $newValue;
808 $value = json_encode($oldValues);
809 } elseif ($column ===
"ri_globaldecision") {
810 $value = filter_var($value, FILTER_VALIDATE_BOOL);
813 $sql =
"UPDATE report_info SET $column = $2 WHERE upload_fk = $1;";
814 $stmt = __METHOD__ .
"updateReportInfo" . $column;
815 $this->
dbManager->getSingleRow($sql, [$uploadId, $value], $stmt);
822 public function getGlobalDecisionSettingsFromInfo($uploadId, $setGlobal=
null)
824 $stmt = __METHOD__ .
'get';
825 $sql =
"SELECT ri_globaldecision FROM report_info WHERE upload_fk = $1";
826 $row = $this->
dbManager->getSingleRow($sql, array($uploadId), $stmt);
828 if ($setGlobal ===
null) {
832 $stmt = __METHOD__ .
'ifempty';
833 $sql =
"INSERT INTO report_info (upload_fk, ri_globaldecision) VALUES ($1, $2) RETURNING ri_globaldecision";
834 $row = $this->
dbManager->getSingleRow($sql, array($uploadId, $setGlobal), $stmt);
837 if (!empty($setGlobal)) {
838 $stmt = __METHOD__ .
'update';
839 $sql =
"UPDATE report_info SET ri_globaldecision = $2 WHERE upload_fk = $1 RETURNING ri_globaldecision";
840 $row = $this->
dbManager->getSingleRow($sql, array($uploadId, $setGlobal), $stmt);
843 return $row[
'ri_globaldecision'];
853 $stmt = __METHOD__.
"getUploadHashesFromPfileId";
854 $sql =
"SELECT * FROM pfile WHERE pfile_pk = $1";
855 $row = $this->
dbManager->getSingleRow($sql, array($pfilePk), $stmt);
857 return [
"sha1" => $row[
"pfile_sha1"],
"md5" => $row[
"pfile_md5"],
"sha256" => $row[
"pfile_sha256"]];
867 $stmt = __METHOD__ .
".checkReused";
868 $sql =
"SELECT 1 AS exists FROM report_info WHERE upload_fk = $1 LIMIT 1;";
869 $row = $this->
dbManager->getSingleRow($sql, array($reusedUploadId), $stmt);
871 if (empty($row[
'exists'])) {
877 $stmt = __METHOD__ .
".removeExists";
878 $sql =
"DELETE FROM report_info WHERE upload_fk = $1;";
879 $this->
dbManager->getSingleRow($sql, [$uploadId], $stmt);
881 $stmt = __METHOD__ .
".getAllColumns";
882 $sql =
"SELECT string_agg(column_name, ',') AS columns
883 FROM information_schema.columns
884 WHERE table_name = 'report_info'
885 AND column_name != 'ri_pk'
886 AND column_name != 'upload_fk';";
887 $row = $this->
dbManager->getSingleRow($sql, [], $stmt);
888 $columns = $row[
'columns'];
890 $stmt = __METHOD__.
"CopyinsertReportConfReuse";
892 "INSERT INTO report_info(upload_fk, $columns)
894 FROM report_info WHERE upload_fk = $2"
897 $stmt, array($uploadId, $reusedUploadId)
getUploadtreeIdFromPfile($uploadFk, $pfileFk)
getParentItemBounds($uploadId, $uploadTreeTableName=null)
getReusedUpload($uploadId, $groupId)
createItem($uploadEntry, $uploadTreeTableName)
addReusedUpload($uploadId, $reusedUploadId, $groupId, $reusedGroupId, $reuseMode=0)
getUploadHashes($uploadId)
countNonArtifactDescendants(ItemTreeBounds $itemTreeBounds, $isFlat=true)
createItemTreeBounds($uploadEntryData, $uploadTreeTableName)
getUploadHashesFromPfileId($pfilePk)
Get Pfile hashes from the pfile id.
getPFileDataPerFileName(ItemTreeBounds $itemTreeBounds)
getContainingFileCount(ItemTreeBounds $itemTreeBounds, UploadTreeProxy $uploadTreeView)
getFatItemId($itemId, $uploadId, $uploadtreeTablename)
getItemTreeBoundsFromUploadId($uploadTreeId, $uploadId)
getAssigneeDate(int $uploadId)
getPFilesDataPerHashAlgo(ItemTreeBounds $itemTreeBounds, $hashAlgo="sha1")
getUploadParent($uploadId)
getItemByDirection($uploadId, $itemId, $direction, $options)
getFatItemArray($itemId, $uploadId, $uploadtreeTablename)
countPlainFiles(ItemTreeBounds $itemTreeBounds)
getNextItem($uploadId, $itemId, $options=null)
getClosedDate(int $uploadId)
updateReportInfo($uploadId, $column, $value)
Update report info for upload.
getPreviousItem($uploadId, $itemId, $options=null)
getItemTreeBounds($itemId, $uploadTreeTableName="uploadtree")
getUploadtreeTableName($uploadId)
Get the uploadtree table name for this upload_pk If upload_pk does not exist, return "uploadtree".
getAssignee($uploadId, $groupId)
Get the upload assignee id.
getUploadEntry($uploadTreeId, $uploadTreeTableName="uploadtree")
insertReportConfReuse($uploadId, $reusedUploadId)
getStatus($uploadId, $groupId)
Get the upload status.
This class contains the events for the upload_events table.
const UPLOAD_CLOSED_EVENT
static createFromTable($row)
asCTE()
Common Table Expressions.
fo_dbManager * dbManager
fo_dbManager object