/**
* @brief Returns an upload job status in html
* @param $jobData, $page, $allusers
* @return Returns an upload job status in html
**/
protected function getShowJobsForEachJob($jobData, $page, $allusers)
{
$outBuf = '';
$pagination = '';
$uploadtree_pk = 0;
$numJobs = count($jobData);
if ($numJobs == 0) {
return array('showJobsData' => "There are no jobs to display");
}
$uri = Traceback_uri() . "?mod=showjobs";
$uriFull = $uri . Traceback_parm_keep(array("upload"));
$uriFullMenu = $uri . Traceback_parm_keep(array("allusers"));
/* Next/Prev menu */
$next = $numJobs > $this->maxUploadsPerPage;
if ($numJobs > $this->maxUploadsPerPage) {
$pagination .= MenuEndlessPage($page, $next, $uriFullMenu);
}
/*****************************************************************/
/* Now display the summary */
/*****************************************************************/
$uploadStyle = "style='font:bold 10pt verdana, arial, helvetica; background:gold; color:white;'";
$noUploadStyle = "style='font:bold 10pt verdana, arial, helvetica; background:gold; color:black;'";
$jobStyle = "style='font:bold 8pt verdana, arial, helvetica; background:lavender; color:black;'";
$prevupload_pk = "";
$firstJob = $page * $this->maxUploadsPerPage;
$lastJob = $page * $this->maxUploadsPerPage + $this->maxUploadsPerPage;
$jobNumber = -1;
/** if $single_browse is 1, represent alread has an upload browse link, if single_browse is 0, no upload browse link */
$single_browse = 0;
foreach ($jobData as $job) {
/* Upload */
if (!empty($job["upload"])) {
$uploadName = GetArrayVal("upload_filename", $job["upload"]);
$uploadDesc = GetArrayVal("upload_desc", $job["upload"]);
$upload_pk = GetArrayVal("upload_pk", $job["upload"]);
$jobId = GetArrayVal("job_pk", $job["job"]);
/** the column pfile_fk of the record in the table(upload) is NULL when this record is inserted */
if (!empty($upload_pk) && $prevupload_pk != $upload_pk || empty($upload_pk) && 0 == $single_browse) {
$prevupload_pk = $upload_pk;
$jobNumber++;
/* Only display the jobs for this page */
if ($jobNumber >= $lastJob) {
break;
}
if ($jobNumber < $firstJob) {
continue;
}
/* blank line separator between pfiles */
$outBuf .= "<tr><td colspan=8> <hr> </td></tr>";
$outBuf .= "<tr>";
$outBuf .= "<th {$uploadStyle}></th>";
$outBuf .= "<th colspan=6 {$uploadStyle}>";
if (!empty($job['uploadtree'])) {
$uploadtree_pk = $job['uploadtree']['uploadtree_pk'];
$outBuf .= "<a title='Click to browse' href='" . Traceback_uri() . "?mod=browse&upload=" . $job['job']['job_upload_fk'] . "&item=" . $uploadtree_pk . "'>";
} else {
$outBuf .= "<a {$noUploadStyle}>";
}
/* get $userName if all jobs are shown */
$userName = "";
if ($allusers > 0) {
$statementName = __METHOD__ . "UploadRec";
$uploadRec = $this->dbManager->getSingleRow("select user_fk from upload where upload_pk=\$1", array($job['job']['job_upload_fk']), $statementName);
if (!empty($uploadRec['user_fk'])) {
$userName = $this->userDao->getUserName($uploadRec['user_fk']);
} else {
$userName = $this->userDao->getUserName($job['job']['job_user_fk']);
}
$userName = "******" . htmlentities($userName, ENT_QUOTES) . ")";
}
$outBuf .= htmlentities($uploadName, ENT_QUOTES) . $userName;
if (!empty($uploadDesc)) {
$outBuf .= " (" . $uploadDesc . ")";
}
$outBuf .= "</a>";
$outBuf .= "</th>";
$outBuf .= "<th {$uploadStyle}><a>" . $this->showJobsDao->getEstimatedTime($jobId) . "</a></th>";
$outBuf .= "</tr>";
$single_browse = 1;
} else {
if ($jobNumber < $firstJob) {
continue;
}
}
} else {
/* Show Jobs that are not attached to an upload */
$jobNumber++;
/* Only display the jobs for this page */
if ($jobNumber >= $lastJob) {
break;
}
if ($jobNumber < $firstJob) {
continue;
}
/* blank line separator between pfiles */
$outBuf .= "<tr><td colspan=8> <hr> </td></tr>";
$outBuf .= "<tr>";
$outBuf .= "<th {$noUploadStyle}></th>";
$outBuf .= "<th colspan=6 {$noUploadStyle}>";
$outBuf .= htmlentities($job["job"]["job_name"], ENT_QUOTES);
$outBuf .= "</th>";
$outBuf .= "<th {$noUploadStyle}></th>";
$outBuf .= "</tr>";
}
/* Job data */
$outBuf .= "<tr>";
$outBuf .= "<th {$jobStyle}>";
$outBuf .= _("Job/Dependency");
$outBuf .= "</th>";
$outBuf .= "<th {$jobStyle}>";
$outBuf .= _("Status");
$outBuf .= "</th>";
$outBuf .= "<th colspan=3 {$jobStyle}>";
$outBuf .= htmlentities($job["job"]["job_name"], ENT_QUOTES);
$outBuf .= "</th>";
$outBuf .= "<th {$jobStyle}>";
$outBuf .= _("Average items/sec");
$outBuf .= "</th>";
$outBuf .= "<th {$jobStyle}>";
$outBuf .= _("ETA");
$outBuf .= "</th>";
$outBuf .= "<th {$jobStyle}>";
$outBuf .= "</th></tr>";
/* Job queue */
foreach ($job['jobqueue'] as $jq_pk => $jobqueueRec) {
$varJobQueueRow = array('jqId' => $jq_pk, 'jobId' => $jobqueueRec['jq_job_fk'], 'class' => $this->getClass($jobqueueRec), 'uriFull' => $uriFull, 'depends' => $jobqueueRec['jdep_jq_depends_fk'] ? $jobqueueRec['depends'] : array(), 'status' => $jobqueueRec['jq_endtext'], 'agentName' => $jobqueueRec['jq_type'], 'itemsProcessed' => $jobqueueRec['jq_itemsprocessed'], 'startTime' => substr($jobqueueRec['jq_starttime'], 0, 16), 'endTime' => empty($jobqueueRec["jq_endtime"]) ? '' : substr($jobqueueRec['jq_endtime'], 0, 16), 'endText' => $jobqueueRec['jq_endtext'], 'page' => $page, 'allusers' => $allusers);
if (!empty($jobqueueRec["jq_endtime"])) {
$numSecs = strtotime($jobqueueRec['jq_endtime']) - strtotime($jobqueueRec['jq_starttime']);
} else {
$numSecs = time() - strtotime($jobqueueRec['jq_starttime']);
}
$itemsPerSec = null;
if ($jobqueueRec['jq_starttime']) {
$itemsPerSec = $this->showJobsDao->getNumItemsPerSec($jobqueueRec['jq_itemsprocessed'], $numSecs);
$varJobQueueRow['itemsPerSec'] = $itemsPerSec;
}
if (empty($jobqueueRec['jq_endtime'])) {
$varJobQueueRow['eta'] = $this->showJobsDao->getEstimatedTime($jobId, $jobqueueRec['jq_type'], $itemsPerSec, $job['job']['job_upload_fk']);
}
$varJobQueueRow['canDoActions'] = $_SESSION[Auth::USER_LEVEL] == PLUGIN_DB_ADMIN || Auth::getUserId() == $job['job']['job_user_fk'];
$varJobQueueRow['isInProgress'] = $jobqueueRec['jq_end_bits'] == 0;
$varJobQueueRow['isReady'] = $jobqueueRec['jq_end_bits'] == 1;
switch ($jobqueueRec['jq_type']) {
case 'readmeoss':
$varJobQueueRow['download'] = "ReadMeOss";
break;
case 'spdx2':
$varJobQueueRow['download'] = "SPDX2 report";
break;
case 'spdx2tv':
$varJobQueueRow['download'] = "SPDX2 tag/value report";
break;
case 'dep5':
$varJobQueueRow['download'] = "DEP5 copyright file";
break;
default:
$varJobQueueRow['download'] = "";
}
$outBuf .= $this->renderString('ui-showjobs-jobqueue-row.html.twig', $varJobQueueRow);
}
}
if ($numJobs > $this->maxUploadsPerPage) {
$pagination = "<p>" . MenuEndlessPage($page, $next, $uriFullMenu);
}
return array('showJobsData' => $outBuf, 'pagination' => $pagination);
}
