$return = show_workflow_opt(-1); echo $return; exit; } // show workflow in edit area if (isset($_GET['action']) && $_GET['action'] == 'show_workflow') { $return = show_workflow($_GET['workflow_id']); echo json_encode($return); exit; } // save/insert workflow if (isset($_GET['action']) && $_GET['action'] == 'save_workflow') { $workflow_id = isset($_GET['workflow_id']) ? $_GET['workflow_id'] : ''; $name = SQLString($_GET['name'], "text"); $description = SQLString($_GET['description'], 'text'); $rt = save_workflow($workflow_id, $name, $description); echo json_encode($rt); exit; } // delete workflow if (isset($_GET['action']) && $_GET['action'] == 'delete_workflow') { $sql = sprintf("SELECT * FROM product WHERE workflow_id = %d", $_GET['workflow_id']); $st = @mysql_query($sql); if (@mysql_num_rows($st) > 0) { $return = array('status' => 1, 'msg' => 'Cannot delete workflow because it is used by a product'); echo json_encode($return); exit; } // now we need to delete everything in workflow_object, workflow_sequence, goal, sequence_object, goal_object, horse $sql = sprintf("\n\t\t\t\tDELETE FROM\n\t\t\t\t\t\tworkflow, workflow_object, workflow_sequence, goal, sequence_object, goal_object, horse\n\t\t\t\t\tUSING workflow LEFT JOIN ( workflow_object, workflow_sequence, goal, sequence_object, goal_object, horse)\n\t\t\t\t\tON ( \n\t\t\t\t\t\tworkflow.id\t\t\t\t= workflow_object.workflow_id\n\t\t\t\t\t\tAND workflow.id \t\t\t= workflow_sequence.workflow_id\n\t\t\t\t\t\tAND workflow_sequence.id \t= goal.workflow_sequence_id\n\t\t\t\t\t\tAND workflow_sequence.id \t= sequence_object.workflow_sequence_id\n\t\t\t\t\t\tAND goal.id \t\t\t\t\t= goal_object.goal_id\n\t\t\t\t\t\tAND workflow_object.id \t\t\t= horse.workflow_object_id)\n\t\t\t\t\tWHERE\n\t\t\t\t\t\tworkflow.id \t\t\t\t= %d\n\t\t\t\t\t", $_GET['workflow_id']); $st = @mysql_query($sql);
$offsetLeft = intval($_POST['task_left'][$i]); $offsetTop = intval($_POST['task_top'][$i]); if ($task_id > 0) { //new tasks have a negative id... we will be storing them differently DB_query("UPDATE {$_TABLES['nf_templatedata']} SET offsetLeft={$offsetLeft}, offsetTop={$offsetTop} WHERE id={$task_id}"); } } } // // main code /////////////////////////////////////////////// $op = COM_applyFilter($_REQUEST['op']); $workflow_id = intval($_REQUEST['workflow_id']); $navbar = new navbar(); $navbar->add_menuitem($LANG_NF02['my_tasks'], $_CONF['site_url'] . '/nexflow/index.php'); $navbar->add_menuitem($LANG_NF02['view_templates'], $_CONF['site_admin_url'] . '/plugins/nexflow/templates.php'); $navbar->add_menuitem($LANG_NF02['view_workflow'], $_CONF['site_admin_url'] . '/plugins/nexflow/edit.php?workflow_id=' . $workflow_id); $navbar->set_selected($LANG_NF02['view_workflow']); switch ($op) { case 'save_workflow': save_workflow(); $display = display_main($workflow_id); break; default: $display = display_main($workflow_id); break; } echo COM_siteHeader('none'); //echo COM_siteFooter(); echo $navbar->generate(); echo $display;