$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;
