function __testDatabaseFields($workflowIDs, $timeStamps, $xmlPackage, $valueMode)
{
$workflowIDsSize = sizeof($workflowIDs);
for ($workflowIndex = 0; $workflowIndex < $workflowIDsSize; $workflowIndex++) {
$newDataItem = new coreWorkflowDataPacket($workflowIDs[$workflowIndex], $timeStamps[$workflowIndex]);
$tables = $xmlPackage->getTables();
//For each table
$tableSize = sizeof($tables);
for ($tableIndex = 0; $tableIndex < $tableSize; $tableIndex++) {
$table = $tables[$tableIndex]->getTableName();
$fields = $tables[$tableIndex]->getDbFields();
$fieldsSize = sizeof($fields);
//The fields specificed
for ($index = 0; $index < $fieldsSize; $index++) {
$field = $fields[$index];
$sql_query = "workflowId='{$workflowIDs[$workflowIndex]}'";
$dbvalue = dbpear::selAttribute($field, $table, "{$sql_query}");
$newDataItem->addId($field);
//False may be posted from db;
if ($dbvalue != 'false' && $dbvalue) {
if ($valueMode) {
//Store the value rather than presence
$newDataItem->addValue($dbvalue);
} else {
$newDataItem->addValue(true);
}
} else {
//Store the value rather than presence
if ($valueMode) {
$newDataItem->addValue($dbvalue);
} else {
$newDataItem->addValue(false);
}
}
}
}
$db = connect('iWFMS');
switch ($valueMode) {
case 'archive':
workflowDisplayHTML::html_displayXMLArchive($newDataItem, false);
break;
case 'archiveView':
workflowDisplayHTML::html_displayXMLArchive($newDataItem, true);
break;
case 'data':
workflowDisplayHTML::html_displayXMLData($newDataItem);
break;
default:
workflowDisplayHTML::html_displayXML($newDataItem);
break;
}
$db = connect($xmlPackage->getDb());
}
}
/**
* @return void
* @param CoreWorkflowDataPacket $coreWorkflowDataPacket
* @desc Display html for packet
*/
function html_displayXMLArchive($coreWorkflowDataPacket, $showValues)
{
$tdClass = 'helpBod';
if ($showValues) {
workflowDisplayHTML::html_displayXMLData($coreWorkflowDataPacket);
?>
<td class="<?php
echo $tdClass;
?>
"> <?php
echo time::arrangedate($coreWorkflowDataPacket->getDate());
?>
</td>
<td class="<?php
echo $tdClass;
?>
"> </td><?php
} else {
$data = $coreWorkflowDataPacket->getData();
workflowDisplayHTML::workflowState($coreWorkflowDataPacket->getWorkflowId(), $data, true);
?>
<td class="<?php
echo $tdClass;
?>
"> <?php
echo time::arrangedate($coreWorkflowDataPacket->getDate());
?>
</td>
<td class="<?php
echo $tdClass;
?>
"> <a href="viewArchivedItem.php?workflowID=<?php
echo $coreWorkflowDataPacket->getWorkflowId();
?>
">View</a> </td>
</tr>
<?php
}
}
