/**
* @param int $id
* @param string $filename
* @param string $description
* @param string $treeTableName
* @param int $timestamp
*/
public function __construct($id, $filename, $description, $treeTableName, $timestamp, $groupId, $assignee, $status, $comment)
{
$this->groupId = $groupId;
$this->assignee = $assignee;
$this->status = $status;
$this->commen = $comment;
parent::__construct($id, $filename, $description, $treeTableName, $timestamp);
}
/**
* @param int $uploadId
* @return Package|null
*/
public function findPackageForUpload($uploadId)
{
$statementName = __METHOD__;
$this->dbManager->prepare($statementName, "\nSELECT p.*, u.*\nFROM package p\n INNER JOIN upload_packages up ON p.package_pk = up.package_fk\n INNER JOIN upload_packages up2 ON p.package_pk = up2.package_fk\n INNER JOIN upload u ON up2.upload_fk = u.upload_pk\nWHERE up.upload_fk = \$1\nORDER BY up2.upload_fk ASC");
$res = $this->dbManager->execute($statementName, array($uploadId));
$packageId = 0;
$packageName = "";
$uploads = array();
while ($row = $this->dbManager->fetchArray($res)) {
$packageId = intval($row['package_pk']);
$packageName = $row['package_name'];
$uploads[] = Upload::createFromTable($row);
}
$this->dbManager->freeResult($res);
return $packageId > 0 ? new Package($packageId, $packageName, $uploads) : null;
}
protected function setUp()
{
$this->uploads = array(M::mock(Upload::classname()));
$this->package = new Package($this->id, $this->name, $this->uploads);
}
/**
* @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']);
}
/**
* @param int $uploadId
* @return Upload|null
*/
public function getUpload($uploadId)
{
$stmt = __METHOD__;
$row = $this->dbManager->getSingleRow("SELECT * FROM upload WHERE upload_pk = \$1", array($uploadId), $stmt);
return $row ? Upload::createFromTable($row) : null;
}
