/**
* @param UploadTree $upload
* @return string
*/
protected function getVerificationCode(Upload $upload)
{
$stmt = __METHOD__;
$param = array();
if ($upload->getTreeTableName() == 'uploadtree_a') {
$sql = $upload->getTreeTableName() . ' WHERE upload_fk=$1 AND';
$param[] = $upload->getId();
} else {
$sql = $upload->getTreeTableName() . ' WHERE';
$stmt .= '.' . $upload->getTreeTableName();
}
$sql = "SELECT STRING_AGG(lower_sha1,'') concat_sha1 FROM\n (SELECT LOWER(pfile_sha1) lower_sha1 FROM pfile, {$sql} pfile_fk=pfile_pk ORDER BY pfile_sha1) templist";
$filelistPack = $this->dbManager->getSingleRow($sql, $param, $stmt);
return sha1($filelistPack['concat_sha1']);
}
