$formtype = DB_getItem($_TABLES['nxform_fields'], 'field_values', "formid='{$form_id}' AND field_name='formtype'");
$taskid = intval($taskid);
$dup_form_check = DB_getItem($_TABLES['nf_projectforms'], 'id', "created_by_taskid={$taskid} AND formtype='{$formtype}'");
if ($dup_form_check !== NULL) {
//form already exists
if ($mode == 'draft' and !isset($_POST['custom_handler'])) {
echo COM_refresh($form_return_url);
} else {
echo COM_refresh($_CONF['site_url'] . '/nexflow/index.php' . $optReturnVars);
}
exit;
}
DB_query("INSERT INTO {$_TABLES['nf_projectforms']} (formtype,created_by_taskid) VALUES ('{$formtype}', '{$taskid}');");
$project_formid = DB_insertID();
if ($newform == 1) {
nexform_dbupdate($form_id, $id);
$result_id = $id;
} else {
$result_id = nexform_dbsave($form_id, $postUID);
}
$nfclass = new nexflow($processid, $postUID);
/* Update the hit or results counter */
DB_query("UPDATE {$_TABLES['nxform_definitions']} SET responses = responses + 1 WHERE id='{$form_id}'");
$newproject = false;
if ($processid > 0 and $taskid > 0) {
$project_id = $nfclass->get_ProcessVariable('PID');
}
// Create new project tracking record if project does not yet exist
if ($project_id < 1 or DB_count($_TABLES['nf_projects'], 'id', $project_id) == 0) {
$processid = intval($processid);
DB_query("INSERT INTO {$_TABLES['nf_projects']} (originator_uid,wf_process_id,wf_task_id,status)\r\n VALUES ('{$postUID}','{$processid}','{$taskid}','1') ");
DB_query("UPDATE {$_TABLES['nxform_definitions']} SET responses = responses + 1 WHERE id='{$form_id}'");
$completion_msg = DB_getItem($_TABLES['nxform_definitions'], 'after_post_text', "id={$form_id}");
if ($completion_msg == '') {
echo COM_refresh($returnURL . '?msg=1&plugin=nexform');
} else {
echo COM_refresh($CONF_FE['public_url'] . "/complete.php?id={$form_id}");
}
exit;
} elseif ($_POST['formhandler'] == 'email+dbsave') {
/* Save results to Database */
$newform = COM_applyFilter($_REQUEST['newform'], true);
/* Save results to Database */
if ($newform == 1) {
//this form was already saved by the file uploader ajax
$result_id = COM_applyFilter($_REQUEST['res_id'], true);
nexform_dbupdate($form_id, $result_id);
} else {
nexform_dbsave($form_id);
}
/* Send results via email */
nexform_emailresults();
/* Update the hit or results counter */
DB_query("UPDATE {$_TABLES['nxform_definitions']} SET responses = responses + 1 WHERE id='{$form_id}'");
$completion_msg = DB_getItem($_TABLES['nxform_definitions'], 'after_post_text', "id={$form_id}");
if ($completion_msg == '') {
echo COM_refresh($returnURL . '?msg=1&plugin=nexform');
} else {
echo COM_refresh($CONF_FE['public_url'] . "/complete.php?id={$form_id}");
}
exit;
} else {
