Example #1
0
$_NF_TABLES['nfproject_timestamps'] = $_DB_table_prefix . 'nfproject_timestamps';
$_NF_TABLES['nfproject_comments'] = $_DB_table_prefix . 'nfproject_comments';
$_NF_TABLES['nfproject_taskhistory'] = $_DB_table_prefix . 'nfproject_taskhistory';
$_NF_TABLES['nfproject_approvals'] = $_DB_table_prefix . 'nfproject_approvals';
$_NF_TABLES['nfprocess'] = $_DB_table_prefix . 'nf_process';
$_NF_TABLES['nfqueue'] = $_DB_table_prefix . 'nf_queue';
$_NF_TABLES['nfprocessvariables'] = $_DB_table_prefix . 'nf_processvariables';
$_NF_TABLES['nfqueuefrom'] = $_DB_table_prefix . 'nf_queuefrom';
$_NF_TABLES['nfnotifications'] = $_DB_table_prefix . 'nf_notifications';
$_NF_TABLES['nfproductionassignments'] = $_DB_table_prefix . 'nf_productionassignments';
echo COM_siteHeader();
if (!SEC_inGroup('Root')) {
    echo COM_startBlock('Invalid Access');
    echo "<br><blockquote>You don't have access to execute this program!</blockquote>";
} else {
    echo COM_StartBlock("nexFlow Initialization Script");
    if ($_GET['op'] != 'initialize') {
        echo "<br><blockquote>This script will remove all workflow application related records and intialize all the Nexflow Process Tables but not effect your workflow defintions.";
        echo "<p>Do you want to proceed? <a href=\"{$_SERVER['PHP_SELF']}?op=initialize\">Yes</a>&nbsp;&nbsp;<a href=\"{$_CONF['site_url']}\">No</a></p>";
        echo "</blockquote>";
    } else {
        echo "<br><h3>Initialize Begins .... </h3>";
        foreach ($_NF_TABLES as $table) {
            echo "<br>Removing all records in {$table} ...";
            DB_query("DELETE FROM {$table}");
            DB_query("ALTER TABLE {$table} AUTO_INCREMENT = 1");
        }
        echo "<br><h3>Initialize Completed .... </h3>";
    }
}
echo COM_endblock();
Example #2
0
$reminderInterval = 3;
// Number of days between reminder notifications
$setEscalation = true;
// Set to true if you want to set or reset the escalation settings
$escalateAfterReminders = 0;
// Set to number of reminder Notification > 0 if you want to set default escalation
// Assumes the same Template Variable is available for all templates.
// Need to lookup variable ID as thats used to identify the user to escalate to
$escalateVariable = 'PD_Coordinator';
/* END of Setup Options */
echo COM_siteHeader();
if (!SEC_inGroup('Root')) {
    echo COM_startBlock('Invalid Access');
    echo "<br><blockquote>You don't have access to execute this program!</blockquote>";
} else {
    echo COM_StartBlock("Initialization Script");
    if ($_GET['op'] != 'initialize') {
        echo "<br><blockquote>This script will set default task notifications for all interactive tasks defined";
        echo "<p>Do you want to proceed? <a href=\"{$_SERVER['PHP_SELF']}?op=initialize\">Yes</a>&nbsp;&nbsp;<a href=\"{$_CONF['site_url']}\">No</a></p>";
        echo "</blockquote>";
    } else {
        echo "<br><h3>Update Begin .... </h3>";
        if ($deleteDefaultNotifications) {
            DB_query("DELETE FROM {$_TABLES['nf_templateassignment']} WHERE nf_prenotifyVariable = 999");
        }
        if ($deleteDefaultReminders) {
            DB_query("DELETE FROM {$_TABLES['nf_templateassignment']} WHERE nf_remindernotifyVariable = 999");
        }
        // Retrieve all interactive tasks - for all requested templates
        $sql = "SELECT id,nf_templateID FROM {$_TABLES['nf_templatedata']} ";
        $sql .= "WHERE (nf_stepType=1 OR nf_stepType=7 OR nf_stepType=8) ";