function removeWorkflowUnit($workflowID)
{
$table = 'plans';
$planValues = array();
$planValues['workflowid'] = $workflowID;
dbs::delrecord($table, 'workflowId', $workflowID);
dbs::delrecord('workflow', 'workflowId', $workflowID);
}
function updatePlanGraphList($workflowID, $plans)
{
$planValuesCollection = array();
$table = 'plans';
$planValues = array();
$planValues['workflowid'] = $workflowID;
dbs::delrecord($table, 'workflowId', $workflowID);
$plansSize = sizeof($plans);
for ($index = 0; $index < $plansSize; $index++) {
$planValues['plan'] = addslashes(serialize($plans[$index]));
array_push($planValuesCollection, $planValues);
//dbs::irrecord($table,$planValues, false);
}
dbs::irrecordArray($table, $planValuesCollection, false);
}
function dbmanagement_simple($table, $key, &$keyvalue, &$mode, $process, $vals)
{
global $sql_debug;
if ($process == 'delete') {
// Delete the record from table
dbs::delrecord($table, $key, $keyvalue);
$mesg = DELETED;
$mode = 'preview';
} elseif ($process == 'add' || $process == 'edit') {
// generate table column field names
$cols = dbs::genfieldnames($table, '0');
if (!empty($keyvalue)) {
/*
this is an existing record
adjust the columns and values parts of the replace sql statement
*/
$cols = "`" . $key . "`, " . $cols;
$vals = "'" . $keyvalue . "', " . $vals;
$request = "REPLACE";
} else {
// this is a new record so set the insert sql statement
$request = "INSERT";
}
// run the sql for the live database
echo $cols;
echo $vals;
dbs::irrecord($request, $table, $cols, $vals);
$mesg = SAVED;
// get the primary key for the previously inserted record
if (empty($keyvalue)) {
$row = dbs::getlast();
$keyvalue = $row[0];
}
// set return mode
$mode = "edit";
}
return $mesg;
}
<?php
$root = "../";
$pageref = "admin_groups.php";
$sql_debug = true;
include_once '../includes/commonPages/system_header.php';
// Database setup variables
$table = "groups";
$key = "groupid";
$identifier = "name";
$mesg = '';
if ($process) {
switch ($process) {
case 'delete':
dbs::delrecord($table, $key, ${$key});
$mesg = 'Deleted!';
break;
case 'add':
$vals['name'] = $name;
$vals['members'] = $groupmembers;
dbs::irrecord($table, $vals, false);
$mesg = 'Added!';
break;
}
}
if (!isset($mode) || $mode == 'preview') {
// show preview page
include_once 'preview/' . str_replace('.php', '', $pageref) . '_preview.php';
} elseif ($mode == 'add' || $mode == 'edit') {
// show edit page
include_once 'edit/' . str_replace('.php', '', $pageref) . '_edit.php';
