public function testGetJobInfo()
{
$this->dbManager->prepare($stmt = 'insert.jobqueue', "INSERT INTO jobqueue (jq_pk, jq_job_fk, jq_type, jq_args, jq_starttime, jq_endtime, jq_endtext, jq_end_bits, jq_schedinfo, jq_itemsprocessed)" . "VALUES (\$1, \$2, \$3, \$4,\$5, \$6,\$7,\$8,\$9,\$10)");
$nowTime = time();
$diffTime = 2345;
$nomosTime = date('Y-m-d H:i:sO', $nowTime - $diffTime);
$uploadArrayQue = array(array(8, $jobId = 1, "nomos", 1, $nomosTime, null, "Started", 0, "localhost.5963", $itemNomos = 147), array(1, $jobId, "ununpack", 1, "2015-04-21 18:29:19.23825+05:30", "2015-04-21 18:29:26.396562+05:30", "Completed", 1, null, $itemCount = 646));
foreach ($uploadArrayQue as $uploadEntry) {
$this->dbManager->freeResult($this->dbManager->execute($stmt, $uploadEntry));
}
$this->dbManager->prepare($stmt = 'insert.uploadtree_a', "INSERT INTO uploadtree_a (uploadtree_pk, parent, upload_fk, pfile_fk, ufile_mode, lft, rgt, ufile_name)" . "VALUES (\$1, \$2, \$3, \$4,\$5, \$6, \$7, \$8)");
$uploadTreeArray = array(array(123, 121, 1, 103, 32768, 542, 543, "fckeditorcode_ie.js"), array(121, 120, 1, 0, 536888320, 537, 544, "js"), array(715, 651, 2, 607, 33188, 534, 535, "zconf.h.cmakein"), array(915, 651, 2, 606, 33188, 532, 533, "zconf.h"));
foreach ($uploadTreeArray as $uploadEntry) {
$this->dbManager->freeResult($this->dbManager->execute($stmt, $uploadEntry));
}
$this->dbManager->prepare($stmt = 'insert.jobdepends', "INSERT INTO jobdepends (jdep_jq_fk, jdep_jq_depends_fk) VALUES (\$1, \$2 )");
$jqWithTwoDependencies = 8;
$jobDependsArray = array(array(2, 1), array(3, 2), array(4, 2), array(5, 2), array(6, 2), array($jqWithTwoDependencies, 4), array($jqWithTwoDependencies, 4));
foreach ($jobDependsArray as $uploadEntry) {
$this->dbManager->freeResult($this->dbManager->execute($stmt, $uploadEntry));
}
$testMyJobInfo = $this->showJobsDao->getJobInfo($this->job_pks);
assertThat($testMyJobInfo, hasKey($jobId));
assertThat($testMyJobInfo[$jobId]['jobqueue'][$jqWithTwoDependencies]['depends'], is(arrayWithSize(2)));
$testFilesPerSec = 0.23;
$formattedEstimatedTime = $this->showJobsDao->getEstimatedTime($job_pk = 1, $jq_Type = "nomos", $testFilesPerSec);
assertThat($formattedEstimatedTime, matchesPattern('/\\d+:\\d{2}:\\d{2}/'));
$hourMinSec = explode(':', $formattedEstimatedTime);
assertThat($hourMinSec[0] * 3600 + $hourMinSec[1] * 60 + $hourMinSec[2], is(closeTo(($itemCount - $itemNomos) / $testFilesPerSec, 0.5 + $testFilesPerSec)));
$testGetEstimatedTime = $this->showJobsDao->getEstimatedTime($job_pk = 1, $jq_Type, 0);
assertThat($testGetEstimatedTime, matchesPattern('/\\d+:\\d{2}:\\d{2}/'));
$hourMinSec = explode(':', $testGetEstimatedTime);
$tolerance = 0.5 + ($itemCount - $itemNomos) / $itemNomos + (time() - $nowTime);
assertThat($hourMinSec[0] * 3600 + $hourMinSec[1] * 60 + $hourMinSec[2], is(closeTo(($itemCount - $itemNomos) / $itemNomos * $diffTime, $tolerance)));
$fewFilesPerSec = 0.003;
$formattedLongTime = $this->showJobsDao->getEstimatedTime($job_pk = 1, $jq_Type = "nomos", $fewFilesPerSec);
assertThat($formattedLongTime, matchesPattern('/\\d+:\\d{2}:\\d{2}/'));
$hourMinSec = explode(':', $formattedLongTime);
assertThat($hourMinSec[0] * 3600 + $hourMinSec[1] * 60 + $hourMinSec[2], is(closeTo(($itemCount - $itemNomos) / $fewFilesPerSec, 0.5 + $fewFilesPerSec)));
}
/**
* @brief Returns an upload job status in html
* @param $jobData
* @return Returns an upload job status in html
**/
protected function show($jobData, $page)
{
global $container;
/** @var DbManager */
$dbManager = $container->get('db.manager');
$outBuf = '';
$pagination = '';
$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 */
/*****************************************************************/
$job = -1;
$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 = "";
$allusers = GetParm("allusers", PARM_INTEGER);
if ($allusers > 0) {
$statementName = __METHOD__ . "UploadRec";
$uploadRec = $dbManager->getSingleRow("select * from upload where upload_pk=\$1", array($job['job']['job_upload_fk']), $statementName);
if (!empty($uploadRec['user_fk'])) {
$statementName = __METHOD__ . "UserRec";
$userRec = $dbManager->getSingleRow("select * from users where user_pk=\$1", array($uploadRec['user_fk']), $statementName);
$userName = "******";
} else {
$statementName = __METHOD__ . "UserRec1";
$userRec = $dbManager->getSingleRow("select * from users where user_pk=\$1", array($job['job']['job_user_fk']), $statementName);
$userName = "******";
}
}
$outBuf .= $uploadName . $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']);
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);
}
