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