function render_empty_form($F)
{
$action = $GLOBALS['webaction'];
extract($F);
$rule_id = $rule_info['rule_id'];
$stat = sprintf("\n%s\n", '<table width="100%">');
$stat .= sprintf("%s\n", '<tr bgcolor="lightyellow"><td colspan="3">');
$stat .= sprintf("%s\n", '[' . $rule_info['subject'] . ' | <a id="' . $rule_info['rule_id'] . '">' . printVerbStat($rule_info['verb']) . ' | <b>' . $rule_info['object'] . '</b> ] <font size=2 color=red>(R' . $rule_info['rule_id'] . ')</font><br /> ');
$stat .= sprintf("%s\n", '<font size-=2 color=dodgerblue>' . ($rule_info['validation'] != '' ? 'Validation: ' . $rule_info['validation'] : '') . '</font>');
$stat .= sprintf("%s\n", '</td></tr>');
$stat .= sprintf("%s\n", '<tr><td width="33%"><b><font color="navy" size="-1"> Value</font></b></td><td width="33%"><b><font color="navy" size="-1">Notes</font></b></td><td width="33%"><b><font color="navy" size="-1"><a href="' . S3DB_URI_BASE . '/statement/jumpuploader.php?rule_id=' . $rule_id . '&item_id=' . $instance_id . '" title="Please note that importing a file will take the place of the Value of the statement. You may add another statement to this item if you wish to keep both.">Multiple Files</a></font></b></td>');
#$stat .= sprintf("%s\n", '<tr><td width="33%"><b><font color="navy" size="-1"> Value</font></b></td><td width="33%"><b><font color="navy" size="-1">Notes</font></b></td><td width="33%"><b><font color="navy" size="-1"><a href="#" title="Please note that importing a file will take the place of the Value of the statement. You may add another statement to this item if you wish to keep both.">File (hover for instructions)</a></font></b></td>');
$stat .= sprintf("%s\n", '<tr><td valign="top" width="33%">');
if ($rule_info['add_data']) {
if ($rule_info['object_id'] != '') {
$select_name = 'input_' . $instance_id . '_' . $rule_id;
$inputBox = get_rule_drop_down_menu(compact('select_name', 'rule_info', 'project_id', 'db', 'user_id'));
} else {
$inputBox = sprintf("%s\n", '<textarea style="background: lightyellow" name="input_' . $instance_id . '_' . $rule_id . '" cols="20"></textarea>');
$peek = '';
}
} else {
$inputBox = sprintf("%s\n", '<I><font color="red">User cannot add data to this rule</font></I>');
$peek = '';
}
$stat .= $inputBox;
$stat .= $peek . "</td>";
$stat .= sprintf("%s\n", '<td valign="top" width="33%"><textarea style="background: lightyellow" name="text_' . $instance_id . '_' . $rule_info['rule_id'] . '" rows="2" cols="20"></textarea></td>');
$stat .= sprintf("%s\n", '<td valign="top" width="33%"><input name="upload_input_' . $instance_id . '_' . $rule_id . '" type="file"><font style="font-size: 10"></font></td>');
#$stat .= sprintf("%s\n", '<td valign="top"><input type="submit" name="insert_'.$resource_id.'_'.$rule_id.'" value="Insert">');
$stat .= sprintf("\n%s\n", '<tr><td colspan="3"><hr size="1" align="center" color="blue"></hr></td></tr>');
$stat .= sprintf("%s\n", '</table>');
#$stat .=sprintf("%s\n", '</form>');
$stats .= $stat;
//echo " I am here";
return $stats;
}
function display_option($C)
{
extract($C);
#echo '<pre>';print_r($cells);
$action = $GLOBALS['webaction'];
$tablecells .= '';
$tablecells .= '<form name = "importform" action = "' . $action['excelimport'] . '" method="POST">';
$tablecells .= "<table width='100%'><tr bgcolor=lightyellow><td>3. Select fields to be updated</td></tr></table>";
$tablecells .= "<TABLE border=1>";
$tablecells .= "<TR>";
#start the row where the rule are displayed
#echo '<pre>';print_r($cells);exit;
foreach ($cells['rules'] as $col => $rules) {
if ($col == 0) {
$tablecells .= '<TD><BR>UID<BR><br>';
$tablecells .= '<input type="button" value="Check all" name="fieldcheck' . $col . '" onClick="this.value=check_rule(' . $col . ')" checked><BR></TD>';
} elseif ($col == 1) {
$tablecells .= '<TD>';
$tablecells .= 'Notes';
$tablecells .= '<BR><br><br><input type="button" value="Check all" "fieldcheck' . $col . '" onClick="this.value=check_rule(' . $col . ')" checked><BR>';
$tablecells .= '</TD>';
} elseif ($col >= 2) {
if (is_array($rules['rule_info'])) {
$tablecells .= '<TD>' . $rules['rule_info']['verb'] . '<BR><font color=blue>' . $rules['rule_info']['object'] . '<BR>(rule id ' . $rules['rule_info']['rule_id'] . ')</font><BR><input type="button" value="Check all" name="fieldcheck' . $col . '" onClick="this.value=check_rule(' . $col . ')" checked></TD>';
} else {
$tablecells .= '<TD><BR>' . $rules['verb'] . '<BR><font color=red>' . $rules['object'] . '<BR>(rule id NOT FOUND)</font>';
$tablecells .= '<br>';
$tablecells .= 'create rule?';
$tablecells .= '<input type="checkbox" name="newrule_0_' . $col . '" checked>';
$tablecells .= '<input type="button" value="Check all" name="fieldcheck' . $col . '" onClick="this.value=check_rule(' . $col . ')" checked></TD>';
}
}
}
$tablecells .= "</TR>";
foreach ($cells['data'] as $row => $row_data) {
$tablecells .= '<TR>';
for ($col = 0; $col < count($cells['rules']); $col++) {
if ($col == 0) {
$tablecells .= '<TD>';
if ($row_data['UID'] == '') {
$tablecells .= '(no UID)';
$tablecells .= '<input type="checkbox" name="newinstance_' . $row . '" id="confirm_me' . $col . '[]" checked>';
} elseif ($row_data['UID'] != '' && !is_array($row_data['instance_info'])) {
#so, the instance was not found?
$tablecells .= '<font color=red>';
$tablecells .= '(UID not found)';
$tablecells .= '</font>';
$tablecells .= '<br>new?';
$tablecells .= '<input type="checkbox" name="newinstance_' . $row . '" id="confirm_me' . $col . '[]" checked>';
} else {
$tablecells .= instanceButton($row_data['instance_info']);
$tablecells .= '<input type="checkbox" name="confirminstance_' . $row . '" id="confirm_me' . $col . '[]" checked>';
}
$tablecells .= '</TD>';
} elseif ($col == 1) {
$tablecells .= '<TD>';
if (!is_array($row_data['instance_info']) && $row_data[1] == '') {
#no a ,no b
$tablecells .= '(notes empty)';
} elseif ($row_data[1] != '' && !is_array($row_data['instance_info'])) {
#a but no b
$tablecells .= $row_data[1];
$tablecells .= '<input type="checkbox" name="confirmnotes_' . $row . '" id="confirm_me' . $col . '[]" checked>';
} elseif ($row_data[1] == '' && is_array($row_data['instance_info']) && $row_data['instance_info']['notes'] != '') {
#b but no a
$tablecells .= 'old:' . $row_data['instance_info']['notes'] . '<br>';
$tablecells .= 'new: (empty)<br>';
if ($row_data['instance_info']['add_data']) {
$tablecells .= '<font color=red>';
$tablecells .= 'delete?';
$tablecells .= '</font>';
$tablecells .= '<input type="checkbox" name="confirmnotes_' . $row . '" value="editnotes_' . $row_data['instance_info']['resource_id'] . '" id="confirm_me' . $col . '[]" checked>';
} else {
#uh ho, you're not allowed!
$tablecells .= '<font color=red>';
$tablecells .= 'User is not allowed to change instance_id ' . $row_data['instance_info']['resource_id'];
$tablecells .= '</font>';
}
} elseif ($row_data[1] != '' && is_array($row_data['instance_info']) && $row_data['instance_info']['notes'] == $row_data[1]) {
#a==b
#this is an intance where notes were NOT modified
$tablecells .= $row_data[1];
$tablecells .= '<br>';
$tablecells .= '<font color=navy>';
$tablecells .= '(no change)';
$tablecells .= '</font>';
} elseif ($row_data[1] != '' && is_array($row_data['instance_info']) && $row_data[1] != $row_data['instance_info']['notes']) {
#a!=b this is an intance where notes were modified
$tablecells .= 'old:' . $row_data['instance_info']['notes'] . '<br>';
if ($row_data['instance_info']['add_data']) {
$tablecells .= '<font color=DarkGreen>';
$tablecells .= 'new:' . $row_data[1] . '';
$tablecells .= '</font>';
$tablecells .= '<br>edit?';
$tablecells .= '<input type="checkbox" name="confirmnotes_' . $row . '" value="editnotes_' . $row_data['instance_info']['resource_id'] . '" id="confirm_me' . $col . '[]" checked>';
} else {
$tablecells .= '<font color=red>';
$tablecells .= 'User is not allowed to change instance_id ' . $row_data['instance_info']['resource_id'];
$tablecells .= '</font>';
}
}
$tablecells .= '</TD>';
} elseif ($col >= 2) {
$tablecells .= '<TD>';
$statement_info = $row_data[$col]['statement_info'];
#if ($rules['rule_info']['rule_id']=='') {#no rule
#$tablecells .='(Data will NOT be imported)';
#}
#else
if ($statement_info['value'] == '' && $row_data[$col]['newvalue'] == '') {
$tablecells .= '';
} elseif ($row_data[$col]['newvalue'] != '' && empty($statement_info['value'])) {
#a but not b this means nothing was there, no checking required except for rule
if (!is_array($cells['rules'][$col]['rule_info'])) {
$tablecells .= $row_data[$col]['newvalue'];
} elseif ($cells['rules'][$col]['rule_info']['object_id'] == '') {
$tablecells .= $row_data[$col]['newvalue'];
} else {
$IN_instance_info = s3info('instance', $row_data[$col]['newvalue'], $db);
if (!is_array($IN_instance_info)) {
$tablecells .= '<font color=red>';
$tablecells .= '(UID ' . $row_data[$col]['newvalue'] . ' not found)';
$tablecells .= '<br>';
$tablecells .= 'Please insert a valid resource';
$tablecells .= '</font>';
$tablecells .= get_rule_drop_down_menu(array('select_name' => 'selectstatement_' . $row . '_' . $col, 'rule_info' => $cells['rules'][$col]['rule_info'], 'db' => $db, 'user_id' => $user_id, 'project_id' => $project_id, 'instance_id' => $row_data['instance_info']['resource_id']));
} else {
#object is a resource and instance was found
$tablecells .= instanceButton($IN_instance_info);
}
}
$tablecells .= '<br>';
$tablecells .= '<input type="checkbox" name="insertstatement_' . $row . '_' . $col . '" value="insertstatement_' . $row_data['instance_info']['resource_id'] . '_' . $rule_id . '" id="confirm_me' . $col . '[]" checked>';
} elseif ($row_data[$col]['newvalue'] == '' && is_array($statement_info) && $statement_info['value'] != '') {
#b but not a #here is something being deleted
if ($statement_info['change']) {
if ($statement_info['file_name'] != '') {
$tablecells .= '<font color=red>';
$tablecells .= '(statement contains a file, please change it in the interface)<br /><a href=# onClick="window.open(\'' . $action['instance'] . '&instance_id=' . $statement_info['resource_id'] . '\')">Edit</a>';
$tablecells .= '</font>';
} else {
if ($cells['rules'][$col]['rule_info']['object_id'] == '') {
$tablecells .= 'old: ' . $statement_info['value'];
} else {
$OUT_instance_info = get_info('instance', $statement_info['value'], $db);
$tablecells .= 'old: ' . instanceButton($OUT_instance_info);
}
$tablecells .= '<br>';
$tablecells .= '<font color=red>';
$tablecells .= 'new: (empty)<br>';
$tablecells .= 'delete?';
$tablecells .= '</font>';
$tablecells .= '<input type="checkbox" name="deletestatement_' . $row . '_' . $col . '" value="deletestatement_' . $row_data['instance_info']['resource_id'] . '_' . $rule_id . '" id="confirm_me' . $col . '[]">';
}
} else {
$tablecells .= 'old: ' . $statement_info['value'];
$tablecells .= '<font color=red>';
$tablecells .= 'User does not have permission to delete statement_id ' . $statement_info['statement_id'] . '!!';
$tablecells .= '</font>';
}
} elseif ($row_data[$col]['newvalue'] != '' && is_array($statement_info) && $statement_info['value'] == $row_data[$col]['newvalue']) {
#a==b nothing to change
if ($cells['rules'][$col]['rule_info']['object_id'] == '') {
$tablecells .= $statement_info['value'];
} else {
$OUT_instance_info = get_info('instance', $statement_info['value'], $db);
$tablecells .= instanceButton($OUT_instance_info);
}
$tablecells .= '<font color=navy>';
$tablecells .= '<br>';
$tablecells .= '(no change)';
$tablecells .= '</font>';
} elseif ($row_data[$col]['newvalue'] != '' && is_array($statement_info) && $statement_info['value'] != '' && $statement_info['value'] != $row_data[$col]['newvalue']) {
#a!=b
if ($statement_info['change']) {
if ($statement_info['file_name'] != '') {
$tablecells .= '<font color=red>';
$tablecells .= '(statement contains a file, please change it in the interface)<br /><a href=# onClick="window.open(\'' . $action['instance'] . '&instance_id=' . $statement_info['resource_id'] . '\')">Edit</a>';
$tablecells .= '</font>';
} else {
if ($cells['rules'][$col]['rule_info']['object_id'] == '') {
$tablecells .= 'old: ' . $statement_info['value'];
$tablecells .= '<br>';
$tablecells .= 'new: ' . $row_data[$col]['newvalue'];
} else {
$OLD_instance_info = URIinfo('I' . $statement_info['value'], $user_id, $key, $db);
$NEW_instance_info = URIinfo('I' . $row_data[$col]['newvalue'], $user_id, $key, $db);
$tablecells .= 'old: ' . instanceButton($OLD_instance_info);
$tablecells .= '<br>';
if (!is_array($NEW_instance_info)) {
$tablecells .= '<font color=red>';
$tablecells .= '(UID ' . $row_data[$col]['newvalue'] . ' not found)';
$tablecells .= '<br>';
$tablecells .= 'Please insert a valid resource';
$tablecells .= '</font>';
$tablecells .= get_rule_drop_down_menu(array('select_name' => 'selectstatement_' . $row . '_' . $col, 'rule_info' => $cells['rules'][$col]['rule_info'], 'db' => $db, 'user_id' => $user_id, 'project_id' => $project_id, 'instance_id' => $row_data['instance_info']['resource_id']));
} else {
$NEW_instance_info = URIinfo('I' . $row_data[$col]['newvalue'], $user_id, $key, $db);
$tablecells .= 'new: ' . instanceButton($NEW_instance_info);
}
}
$tablecells .= '<br>';
$tablecells .= '<font color=DarkGreen>';
$tablecells .= 'edit?';
$tablecells .= '</font>';
$tablecells .= '<input type="checkbox" name="editstatement_' . $row . '_' . $col . '" value="editstatement_' . $row_data['instance_info']['resource_id'] . '_' . $rule_id . '" id="confirm_me' . $col . '[]" checked>';
}
} else {
$tablecells .= 'old: ' . $statement_info['value'];
$tablecells .= '<font color=red>';
$tablecells .= 'User does not have permission to delete statement_id ' . $statement_info['statement_id'] . '!!';
$tablecells .= '</font>';
}
}
$tablecells .= '</TD>';
}
}
$tablecells .= '</TR>';
}
$tablecells .= '<input type="submit" name="InsertinDB" value="Import ' . $resource_info['entity'] . '"><BR>';
$tablecells .= '</table>';
return $tablecells;
}
