/**
* @brief Returns uploadname as link for geeky scan
* @param $job_pk
* @return uploadname
**/
function getUploadNameForGeekyScan($job_pk)
{
$row = $this->showJobsDao->getDataForASingleJob($job_pk);
if (empty($row["job_upload_fk"])) {
return '';
}
if (empty($row['jq_pk'])) {
return _("Job history record is no longer available");
}
/* get the upload filename */
$uploadFileName = htmlspecialchars($this->uploadDao->getUpload($row['job_upload_fk'])->getFilename());
if (empty($uploadFileName)) {
/* upload has been deleted so try to get the job name from the original upload job record */
$jobName = $this->showJobsDao->getJobName($row["job_upload_fk"]);
$uploadFileName = "Deleted " . $jobName;
}
$uploadtree_pk = -1;
/* Find the uploadtree_pk for this upload so that it can be used in the browse link */
try {
$uploadtree_pk = $this->uploadDao->getUploadParent($row['job_upload_fk']);
} catch (Exception $e) {
echo $e->getMessage(), "\n";
}
/* upload file name link to browse */
$uploadNameLink = "<a title='Click to browse this upload' href='" . Traceback_uri() . "?mod=browse&upload=" . $row['job_upload_fk'] . "&item=" . $uploadtree_pk . "'>" . $uploadFileName . "</a>";
return $uploadNameLink;
}
public function testgetJobName()
{
$testJobName = $this->showJobsDao->getJobName(1);
assertThat($testJobName, equalTo("FCKeditor_2.6.4.zip"));
$testJobNameIfNothingQueued = $this->showJobsDao->getJobName($uploadId = 3);
assertThat($testJobNameIfNothingQueued, equalTo($uploadId));
}
/**
* @brief Returns geeky scan details about the jobqueue item
* @param $job_pk
* @return Return job and jobqueue record data in an html table.
**/
function showJobDB($job_pk)
{
global $container;
/** @var DbManager */
$dbManager = $container->get('db.manager');
$statementName = __METHOD__ . "ShowJobDBforjob";
$dbManager->prepare($statementName, "SELECT *, jq_endtime-jq_starttime as elapsed FROM jobqueue LEFT JOIN job ON job.job_pk = jobqueue.jq_job_fk WHERE jobqueue.jq_pk = \$1");
$result = $dbManager->execute($statementName, array($job_pk));
$row = $dbManager->fetchArray($result);
$dbManager->freeResult($result);
if (!empty($row["job_upload_fk"])) {
/* get the upload filename */
$statementName = __METHOD__ . "upload_filenameforShowJobDB";
$dbManager->prepare($statementName, "select upload_filename, upload_desc from upload where upload_pk =\$1");
$uploadresult = $dbManager->execute($statementName, array($row['job_upload_fk']));
$uploadRow = $dbManager->fetchArray($uploadresult);
if (empty($uploadRow)) {
/* upload has been deleted so try to get the job name from the original upload job record */
$jobName = $this->showJobsDao->getJobName($row["job_upload_fk"]);
$upload_filename = "Deleted " . $jobName;
$upload_desc = '';
} else {
$upload_filename = $uploadRow['upload_filename'];
$upload_desc = $uploadRow['upload_desc'];
}
$dbManager->freeResult($uploadresult);
if (empty($row['jq_pk'])) {
return _("Job history record is no longer available");
}
$uploadtree_tablename = $this->uploadDao->getUploadtreeTableName($row['job_upload_fk']);
/* Find the uploadtree_pk for this upload so that it can be used in the browse link */
$statementName = __METHOD__ . "uploadtreeRec";
$uploadtreeRec = $dbManager->getSingleRow("select * from {$uploadtree_tablename} where parent is NULL and upload_fk=\$1", array($row['job_upload_fk']), $statementName);
$uploadtree_pk = $uploadtreeRec['uploadtree_pk'];
}
/* upload file name link to browse */
if (!empty($row['job_upload_fk'])) {
$uploadTreeName = "";
$uploadTreeName = "<a title='Click to browse this upload' href='" . Traceback_uri() . "?mod=browse&upload=" . $row['job_upload_fk'] . "&item=" . $uploadtree_pk . "'>" . $upload_filename . "</a>";
return $uploadTreeName;
}
}
