DB_query($sql); $sql = "SELECT a.task_id, c.taskname, d.description, d.project_num, d.id\r\n FROM {$_TABLES['nf_productionassignments']} a\r\n LEFT JOIN {$_TABLES['nf_queue']} b ON a.task_id=b.id\r\n LEFT JOIN {$_TABLES['nf_templatedata']} c ON b.nf_templateDataID=c.id\r\n LEFT JOIN {$_TABLES['nf_projects']} d ON b.nf_processID=d.wf_process_id\r\n WHERE a.id={$id};"; $res = DB_query($sql); $B = DB_fetchArray($res); if ($B['id'] != '') { $sql = "INSERT INTO {$_TABLES['nf_projectcomments']} (project_id, task_id, uid, timestamp, comment) VALUES ({$B['id']}, {$B['task_id']}, {$ruid}, " . time() . ", 'Task was returned to original owner, {$fullname}');"; DB_query($sql); } echo "You have successfully returned the task to {$fullname}"; break; case 'delreassignedtask': $id = COM_applyFilter($_REQUEST['id'], true); //added assignBack_uid check in sql statement only to ensure authenticated user is deleting the reassignment record $sql = "UPDATE {$_TABLES['nf_productionassignments']} SET assignBack_uid=0, security_hash='' WHERE id={$id} AND assignBack_uid={$_USER['uid']};"; DB_query($sql); echo taskconsoleShowNavbar('My Tasks'); if (DB_count($_TABLES['nf_productionassignments'], 'assignBack_uid', $_USER['uid']) == 0) { echo display_mytasks(); } else { echo display_reassignedTasks(); } break; default: echo taskconsoleShowNavbar(); echo display_mytasks(); break; } if ($_GET['singleuse'] != 1 and $nomenu != 1) { echo COM_endblock(); } echo COM_siteFooter();
$sql .= "WHERE a.id='{$taskid}' "; $A = DB_fetchArray(DB_query($sql), false); $notifyUser = COM_getDisplayName($notifyUID); if ($CONF_NF['debug']) { COM_errorLog("Nexflow: Send task reminder notificaton for task id: {$A['id']} ({$A['nf_templateDataID']}), {$A['taskname']} to: {$notifyUser} "); } $subject = 'Workflow Task Reminder Notification'; list($subject, $msg) = nf_formatEmailMessage('reminder', $A['nf_templateDataID'], $A['id'], $notifyUser); $message .= $msg; nf_sendEmail($email, $subject, $message); } break; } echo COM_siteHeader('menu'); echo COM_startBlock("Outstanding Tasks"); echo taskconsoleShowNavbar('Outstanding Tasks'); $p = new Template($_CONF['path_layout'] . 'nexflow/admin'); $p->set_file(array('report' => 'view_outstandingtasks.thtml', 'tasks' => 'view_outstandingtask_record.thtml')); $imgset = $_CONF['layout_url'] . '/nexflow/images'; $actionurl = $_CONF['site_admin_url'] . '/plugins/nexflow/outstanding.php'; $p->set_var('layout_url', $_CONF['layout_url']); $p->set_var('site_url', $_CONF['site_url']); $p->set_var('imgset', $imgset); $p->set_var('actionurl', $actionurl); $p->set_var('heading1', 'Assigned'); $p->set_var('heading2', 'Owner'); $p->set_var('heading3', 'Request'); $p->set_var('heading4', 'Task Description'); $p->set_var('heading5', 'Actions'); $p->set_var('user_options', nf_listUsers()); $p->set_var('public_url', $_CONF['site_admin_url'] . '/plugins/nexflow');
$selectUser = COM_applyFilter($_REQUEST['taskuser'], true); $optLinkVars = ''; if ($selectUser > 0) { $usermodeUID = $selectUser; if (SEC_hasRights('nexflow.admin')) { $optLinkVars = "&taskuser={$usermodeUID}"; } } else { $usermodeUID = $_USER['uid'] > 1 ? $_USER['uid'] : 1; } $nfclass = new nexflow('', $usermodeUID); $retval = ''; echo COM_siteHeader('menu'); $username = COM_getDisplayName($usermodeUID); echo COM_startBlock("Workflow Task Console for: {$username}", '', 'blockheader.thtml'); echo taskconsoleShowNavbar('Start Process'); $p = new Template($_CONF['path_layout'] . 'nexflow/admin'); $p->set_file(array('page' => 'startprocesses.thtml', 'record' => 'process_record.thtml')); $p->set_var('site_url', $_CONF['site_url']); $p->set_var('optional_parms', $optLinkVars); $tquery = DB_query("SELECT id,templateName FROM {$_TABLES["nf_template"]} ORDER BY id"); $i = 1; while (list($templateId, $templateName) = DB_fetchArray($tquery)) { $p->set_var('template_id', $templateId); $p->set_var('template_name', $templateName); $p->set_var('csscode', $i % 2 + 1); $p->parse('template_records', 'record', true); $i++; } if ($_GET['start'] != NULL) { $newProcess = $nfclass->newprocess($_GET['start']);