function render_inserted_statement_all($I) { extract($I); $_SESSION['current_color'] = '0'; $_SESSION['previous_verb'] = ''; $instance_id = $instance_info['resource_id']; $stats = ''; if (is_array($rules)) { foreach ($rules as $rule_info) { $report_msg = ''; $subject = $rule_info['subject']; $verb = $rule_info['verb']; $object = $rule_info['object']; $rule_id = $rule_info['rule_id']; $rule_notes = $rule_info['notes']; $notes = $_POST['text_' . $instance_id . '_' . $rule_id]; $index = $index + 1; if (in_array($rule_id, $rule_ids)) { #echo 'upload_input_'.$instance_id.'_'.$rule_id.'<BR>'; #gather data from post if ($_FILES['upload_input_' . $instance_id . '_' . $rule_id]['name'] == '') { $value = $_POST['input_' . $instance_id . '_' . $rule_id]; if ($value == '') { $value = $_POST['input_' . str_replace('.', '_', $instance_id) . '_' . str_replace('.', '_', $rule_id)]; } #insert the statement, run S3QL $s3ql = compact('db', 'user_id'); $s3ql['insert'] = 'statement'; #$s3ql['where']['project_id'] = $project_id; $s3ql['where']['item_id'] = $instance_id; $s3ql['where']['rule_id'] = $rule_id; $s3ql['where']['value'] = $value; $s3ql['where']['notes'] = $notes; #$s3ql['format']='html'; $done = S3QLaction($s3ql); $done = html2cell($done); #ereg('<error>([0-9]+)</error>.*<(message|statement_id)>(.*)</(message|statement_id)>', $done, $s3qlout); $statement_id = $done[2]['statement_id']; $S = compact('user_id', 'rule_info', 'instance_id', 'statement_id', 'value', 'notes', 'db', 'done'); if ($done[2]['error_code'] == '0') { $report_msg = render_inserted($s3ql, $statement_id); #$report_msg .= sprintf("%s\n", ' <br /><input type="button" value="Insert Another" onClick="window.location=\''.$action['instanceform'].'\'">'); #$report_msg .= sprintf("%s\n", ' <br /><input type="button" value="Close Window" onClick="window.location=\''.$action['instanceform'].'\'">'); } else { $report_msg = couldnot_insert_statement($S); #render_statement_already_exists($s3ql); } #elseif($s3qlout[1]=='7') #{ #$report_msg = render_resource_doesnot_exist($s3ql); #} #elseif($s3qlout[1]=='3') #{ #$report_msg = render_value_cannot_be_null($s3ql); #} } else { #project is the same that will go to instance $project_id = $rule_info['project_id']; $value = project_folder_name($project_id, $db); $notes = $_REQUEST['text_' . $instance_id . '_' . $rule_id]; $filename = $_FILES['upload_input_' . $instance_id . '_' . $rule_id]['name']; $mimetype = $_FILES['upload_input_' . $instance_id . '_' . $rule_id]['type']; $filesize = filesize($_FILES['upload_input_' . $instance_id . '_' . $rule_id]['tmp_name']); $uploadedfile = $_FILES['upload_input_' . $instance_id . '_' . $rule_id]['tmp_name']; if ($filesize <= 0) { $report_msg = 'Filesize cannot be null'; } elseif ($filename == '') { $report_msg = 'Filename cannot be empty'; } elseif ($value == '' || $uploadedfile == '') { $report_msg = 'Could not move file, please check with you administrator if file uploads are allowed.'; } else { $tmp = fileNameAndExtension($filename); extract($tmp); #write a filekey to send the file by the API $filekey = generateAFilekey(compact('filename', 'extension', 'filesize', 'user_id', 'db')); #move the file like the API would do $file = $uploadedfile; $fileMoved = MoveFile(compact('filekey', 'db', 'file')); #generate a statement_id if ($fileMoved) { $s3ql = compact('db', 'user_id'); $s3ql['insert'] = 'file'; $s3ql['where']['filekey'] = $filekey; $s3ql['where']['notes'] = $notes; $s3ql['where']['project_id'] = $project_id; $s3ql['where']['rule_id'] = $rule_id; $s3ql['where']['item_id'] = $instance_id; $s3ql['format'] = 'html'; $done = S3QLaction($s3ql); $done = html2cell($done); #echo '<pre>';print_r($done); #ereg('<statement_id>([0-9]+)</statement_id>', $done, $s3qlout); $statement_id = $done[2]['file_id']; if ($statement_id != '') { $insert = 'file'; $S = compact('rule_id', 'instance_id', 'db', 'insert', 'filename'); $report_msg = render_inserted($S, $statement_id); } } else { $report_msg = "<font color='red'>Could not move the file</font>"; exit; } } } } else { $report_msg = render_empty_form(compact('index', 'rule_info', 'project_id', 'instance_id', 'db')); } $finalOutput .= $report_msg; } } //echo $stats; return $finalOutput; }
$done = S3QLaction($s3ql); $msg = html2cell($done); $msg = $msg[2]; #ereg('<error>([0-9]+)</error>.*<(message|statement_id)>(.*)</(message|statement_id)>', $done, $s3qlout); #preg_match('/[0-9]+/', $done, $statement_id); if ($msg['error_code'] == '0') { $statement_id = $msg['statement_id']; $S = compact('user_id', 'rule_info', 'instance_id', 'statement_id', 'value', 'notes', 'db'); $report_msg = render_inserted($s3ql, $statement_id); $report_msg .= sprintf("%s\n", ' <br /><input type="button" value="Insert Another" onClick="window.location=\'' . $action['insertstatement'] . '\'">'); $report_msg .= sprintf("%s\n", ' <input type="button" value="Close Window" onClick="opener.window.location.reload(); self.close();return false;">'); #exit; } else { $S = compact('user_id', 'rule_info', 'instance_id', 'statement_id', 'value', 'notes', 'db', 's3qlout'); $report_msg = $msg['message']; $report_msg .= couldnot_insert_statement($S); #exit; } } else { $report_msg = render_value_cannot_be_null($s3ql); } #$message = "Value cannot be empty"; } else { $value = project_folder_name($project_id, $db); $notes = $_REQUEST['text_' . $instance_id . '_' . $rule_id]; $filename = $_FILES['upload_input_' . $instance_id . '_' . $rule_id]['name']; $mimetype = $_FILES['upload_input_' . $instance_id . '_' . $rule_id]['type']; $filesize = filesize($_FILES['upload_input_' . $instance_id . '_' . $rule_id]['tmp_name']); $uploadedfile = $_FILES['upload_input_' . $instance_id . '_' . $rule_id]['tmp_name']; if ($filesize <= 0) { $report_msg = 'Filesize cannot be null';